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 |
} |