|
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"; |