|
Lines 2839-2853
sub ToggleNewStatus {
Link Here
|
| 2839 |
if ( defined $age ) { |
2839 |
if ( defined $age ) { |
| 2840 |
# Calculate item age based on hours since item last altered |
2840 |
# Calculate item age based on hours since item last altered |
| 2841 |
if ( defined $rule && defined $age_starting_point && $unit eq "hours" && $age_starting_point eq "itemaltered" ) { |
2841 |
if ( defined $rule && defined $age_starting_point && $unit eq "hours" && $age_starting_point eq "itemaltered" ) { |
| 2842 |
$query .= q| AND HOUR(TIMEDIFF(NOW(), timestamp)) >= ? |; |
2842 |
$query .= q| AND HOUR(TIMEDIFF(NOW(), items.timestamp)) >= ? |; |
| 2843 |
push @params, $age; |
2843 |
push @params, $age; |
| 2844 |
} elsif ( defined $rule && defined $age_starting_point && $unit eq "days" && $age_starting_point eq "itemaltered" ) { |
2844 |
} elsif ( defined $rule && defined $age_starting_point && $unit eq "days" && $age_starting_point eq "itemaltered" ) { |
| 2845 |
# Calculate item age based on days since item last altered |
2845 |
# Calculate item age based on days since item last altered |
| 2846 |
$query .= q| AND TO_DAYS(NOW()) - TO_DAYS(timestamp) >= ? |; |
2846 |
$query .= q| AND TO_DAYS(NOW()) - TO_DAYS(items.timestamp) >= ? |; |
| 2847 |
push @params, $age; |
2847 |
push @params, $age; |
| 2848 |
} else { |
2848 |
} else { |
| 2849 |
# Calculate item age based on days since item was created |
2849 |
# Calculate item age based on days since item was created |
| 2850 |
$query .= q| AND TO_DAYS(NOW()) - TO_DAYS(dateaccessioned) >= ? |; |
2850 |
$query .= q| AND TO_DAYS(NOW()) - TO_DAYS(items.dateaccessioned) >= ? |; |
| 2851 |
push @params, $age; |
2851 |
push @params, $age; |
| 2852 |
} |
2852 |
} |
| 2853 |
} |
2853 |
} |