Revision eb693e82
Von Moritz Bunkus vor etwa 16 Jahren hinzugefügt
| SL/GL.pm | ||
|---|---|---|
| 272 | 272 |
} |
| 273 | 273 |
|
| 274 | 274 |
if ($form->{category} ne 'X') {
|
| 275 |
$glwhere .= |
|
| 276 |
qq| AND gl.id in (SELECT trans_id FROM acc_trans ac2 WHERE ac2.chart_id IN |
|
| 277 |
(SELECT id FROM chart c2 WHERE c2.category = ?))|; |
|
| 278 |
$arwhere .= |
|
| 279 |
qq| AND ar.id in (SELECT trans_id FROM acc_trans ac2 WHERE ac2.chart_id IN |
|
| 280 |
(SELECT id FROM chart c2 WHERE c2.category = ?))|; |
|
| 281 |
$apwhere .= |
|
| 282 |
qq| AND ap.id in (SELECT trans_id FROM acc_trans ac2 WHERE ac2.chart_id IN |
|
| 283 |
(SELECT id FROM chart c2 WHERE c2.category = ?))|; |
|
| 275 |
$glwhere .= qq| AND g.id in (SELECT trans_id FROM acc_trans ac2 WHERE ac2.chart_id IN (SELECT id FROM chart c2 WHERE c2.category = ?))|; |
|
| 276 |
$arwhere .= qq| AND a.id in (SELECT trans_id FROM acc_trans ac2 WHERE ac2.chart_id IN (SELECT id FROM chart c2 WHERE c2.category = ?))|; |
|
| 277 |
$apwhere .= qq| AND a.id in (SELECT trans_id FROM acc_trans ac2 WHERE ac2.chart_id IN (SELECT id FROM chart c2 WHERE c2.category = ?))|; |
|
| 284 | 278 |
push(@glvalues, $form->{category});
|
| 285 | 279 |
push(@arvalues, $form->{category});
|
| 286 | 280 |
push(@apvalues, $form->{category});
|
Auch abrufbar als: Unified diff
SQL-Fehler: Im Query die richtigen Tabellen-Aliase benutzen. Fix für Bug 812.