View | Details | Raw Unified | Return to bug 10608
Collapse All | Expand All

(-)a/reports/catalogue_stats.pl (+9 lines)
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";

Return to bug 10608