Revision 777d9b30
Von Sven Schöling vor etwa 15 Jahren hinzugefügt
| SL/OE.pm | ||
|---|---|---|
| 111 | 111 |
qq|AND ((globalproject_id = ?) OR EXISTS | . |
| 112 | 112 |
qq| (SELECT * FROM orderitems oi | . |
| 113 | 113 |
qq| WHERE oi.project_id = ? AND oi.trans_id = o.id))|; |
| 114 |
push(@values, $form->{"project_id"}, $form->{"project_id"});
|
|
| 114 |
push(@values, conv_i($form->{"project_id"}), conv_i($form->{"project_id"}));
|
|
| 115 |
} |
|
| 116 |
|
|
| 117 |
if ($form->{"projectnumber"}) {
|
|
| 118 |
$query .= <<SQL; |
|
| 119 |
AND (pr.projectnumber ILIKE ?) OR EXISTS ( |
|
| 120 |
SELECT * FROM orderitems oi |
|
| 121 |
LEFT JOIN project proi ON proi.id = oi.project_id |
|
| 122 |
WHERE proi.projectnumber ILIKE ? AND oi.trans_id = o.id |
|
| 123 |
) |
|
| 124 |
SQL |
|
| 125 |
push @values, "%" . $form->{"projectnumber"} . "%", "%" . $form->{"projectnumber"} . "%" ;
|
|
| 115 | 126 |
} |
| 116 | 127 |
|
| 117 | 128 |
if ($form->{"${vc}_id"}) {
|
Auch abrufbar als: Unified diff
Bugfix: Auftragssuche: Bei niedrigen vclimit muss nach projectNUMMER und nicht nach id gesucht werden.
Fix für Bug 1108