|
Lines 249-255
sub calculate {
Link Here
|
| 249 |
my $strcalc ; |
249 |
my $strcalc ; |
| 250 |
|
250 |
|
| 251 |
# Processing average loanperiods |
251 |
# Processing average loanperiods |
| 252 |
$strcalc .= "SELECT CONCAT_WS('', borrowers.surname , \",\\t\", borrowers.firstname), COUNT(*) AS RANK, borrowers.borrowernumber AS ID"; |
252 |
$strcalc .= "SELECT CONCAT_WS('', borrowers.surname , \",\\t\", borrowers.firstname), COUNT(*) AS `RANK`, borrowers.borrowernumber AS ID"; |
| 253 |
$strcalc .= " , $colfield " if ($colfield); |
253 |
$strcalc .= " , $colfield " if ($colfield); |
| 254 |
$strcalc .= " FROM `old_issues` |
254 |
$strcalc .= " FROM `old_issues` |
| 255 |
LEFT JOIN borrowers USING(borrowernumber) |
255 |
LEFT JOIN borrowers USING(borrowernumber) |
|
Lines 274-280
sub calculate {
Link Here
|
| 274 |
} |
274 |
} |
| 275 |
$strcalc .= " GROUP BY borrowers.borrowernumber"; |
275 |
$strcalc .= " GROUP BY borrowers.borrowernumber"; |
| 276 |
$strcalc .= ", $colfield" if ($column); |
276 |
$strcalc .= ", $colfield" if ($column); |
| 277 |
$strcalc .= " ORDER BY RANK DESC"; |
277 |
$strcalc .= " ORDER BY `RANK` DESC"; |
| 278 |
$strcalc .= ",$colfield " if ($colfield); |
278 |
$strcalc .= ",$colfield " if ($colfield); |
| 279 |
$strcalc .= " LIMIT $limit" if ($limit); |
279 |
$strcalc .= " LIMIT $limit" if ($limit); |
| 280 |
|
280 |
|
| 281 |
- |
|
|