Lines 506-512
sub calculate {
Link Here
|
506 |
$strcalc .= " LEFT JOIN borrower_attributes AS attribute_$_ ON (statistics.borrowernumber = attribute_$_.borrowernumber AND attribute_$_.code = '$_') "; |
506 |
$strcalc .= " LEFT JOIN borrower_attributes AS attribute_$_ ON (statistics.borrowernumber = attribute_$_.borrowernumber AND attribute_$_.code = '$_') "; |
507 |
} |
507 |
} |
508 |
} |
508 |
} |
509 |
$strcalc .= "LEFT JOIN items ON statistics.itemnumber=items.itemnumber " |
509 |
$strcalc .= "LEFT JOIN (SELECT * FROM items UNION SELECT * FROM deleteditems) items ON statistics.itemnumber=items.itemnumber " |
510 |
if ( $linefield =~ /^items\./ |
510 |
if ( $linefield =~ /^items\./ |
511 |
or $colfield =~ /^items\./ |
511 |
or $colfield =~ /^items\./ |
512 |
or $process == 5 |
512 |
or $process == 5 |
513 |
- |
|
|