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

(-)a/reports/borrowers_stats.pl (-2 / +1 lines)
Lines 407-413 sub calculate { Link Here
407
        }
407
        }
408
    }
408
    }
409
	$strcalc .= " AND borrowernumber in (select distinct(borrowernumber) from old_issues where issuedate > '" . $newperioddate . "')" if ($activity eq 'active');
409
	$strcalc .= " AND borrowernumber in (select distinct(borrowernumber) from old_issues where issuedate > '" . $newperioddate . "')" if ($activity eq 'active');
410
	$strcalc .= " AND borrowernumber not in (select distinct(borrowernumber) from old_issues where issuedate > '" . $newperioddate . "')" if ($activity eq 'nonactive');
410
	$strcalc .= " AND borrowernumber not in (select distinct(borrowernumber) from old_issues where issuedate > '" . $newperioddate . "' AND borrowernumber IS NOT NULL)" if ($activity eq 'nonactive');
411
	$strcalc .= " AND $status='1' " if ($status);
411
	$strcalc .= " AND $status='1' " if ($status);
412
412
413
    $strcalc .= " GROUP BY ";
413
    $strcalc .= " GROUP BY ";
414
- 

Return to bug 8306