Lines 449-454
Link Here
|
449 |
@$filters[12]=~ s/\*/%/g; |
449 |
@$filters[12]=~ s/\*/%/g; |
450 |
$strcalc .= " AND items.ccode LIKE '" . @$filters[12] ."'"; |
450 |
$strcalc .= " AND items.ccode LIKE '" . @$filters[12] ."'"; |
451 |
} |
451 |
} |
|
|
452 |
if (@$filters[15]){ |
453 |
@$filters[15]=~ s/\*/%/g; |
454 |
$strcalc .= " AND items.dateaccessioned > '" .@$filters[15] ."'"; |
455 |
} |
456 |
if (@$filters[16]){ |
457 |
@$filters[16]=~ s/\*/%/g; |
458 |
$strcalc .= " AND items.dateaccessioned < '" .@$filters[16] ."'"; |
459 |
} |
460 |
|
452 |
|
461 |
|
453 |
$strcalc .= " group by $linefield, $colfield order by $linefield,$colfield"; |
462 |
$strcalc .= " group by $linefield, $colfield order by $linefield,$colfield"; |
454 |
$debug and warn "SQL: $strcalc"; |
463 |
$debug and warn "SQL: $strcalc"; |