Revision 3ecc10d2
Von Tamino Steinert vor mehr als 1 Jahr hinzugefügt
| SL/DO.pm | ||
|---|---|---|
| 192 | 192 |
push @values, conv_date($form->{insertdateto});
|
| 193 | 193 |
} |
| 194 | 194 |
|
| 195 |
$form->{fulltext} = trim($form->{fulltext});
|
|
| 196 |
if ($form->{fulltext}) {
|
|
| 197 |
my @fulltext_fields = qw(dord.notes |
|
| 198 |
dord.intnotes |
|
| 199 |
dord.shippingpoint |
|
| 200 |
dord.shipvia |
|
| 201 |
dord.transaction_description |
|
| 202 |
dord.donumber |
|
| 203 |
dord.ordnumber |
|
| 204 |
dord.cusordnumber |
|
| 205 |
dord.oreqnumber |
|
| 206 |
); |
|
| 207 |
my $tmp_where = ''; |
|
| 208 |
$tmp_where .= join ' OR ', map {"$_ ILIKE ?"} @fulltext_fields;
|
|
| 209 |
push(@values, like($form->{fulltext})) for 1 .. (scalar @fulltext_fields);
|
|
| 210 |
|
|
| 211 |
$tmp_where .= <<SQL; |
|
| 212 |
OR EXISTS ( |
|
| 213 |
SELECT files.id FROM files LEFT JOIN file_full_texts ON (file_full_texts.file_id = files.id) |
|
| 214 |
WHERE files.object_id = dord.id AND files.object_type = ? |
|
| 215 |
AND file_full_texts.full_text ILIKE ?) |
|
| 216 |
SQL |
|
| 217 |
push(@values, $form->{type});
|
|
| 218 |
push(@values, like($form->{fulltext}));
|
|
| 219 |
push @where, $tmp_where; |
|
| 220 |
|
|
| 221 |
} |
|
| 222 |
|
|
| 195 | 223 |
if ($form->{parts_partnumber}) {
|
| 196 | 224 |
push @where, <<SQL; |
| 197 | 225 |
EXISTS ( |
| bin/mozilla/do.pl | ||
|---|---|---|
| 796 | 796 |
push @hidden_variables, $form->{vc}, qw(l_closed l_notdelivered open closed delivered notdelivered donumber ordnumber serialnumber cusordnumber
|
| 797 | 797 |
transaction_description transdatefrom transdateto reqdatefrom reqdateto |
| 798 | 798 |
type vc employee_id salesman_id project_id parts_partnumber parts_description |
| 799 |
insertdatefrom insertdateto business_id all department_id chargenumber); |
|
| 799 |
insertdatefrom insertdateto business_id all department_id chargenumber full_text);
|
|
| 800 | 800 |
|
| 801 | 801 |
my $href = build_std_url('action=orders', grep { $form->{$_} } @hidden_variables);
|
| 802 | 802 |
|
| ... | ... | |
| 866 | 866 |
if ($form->{transaction_description}) {
|
| 867 | 867 |
push @options, $locale->text('Transaction description') . " : $form->{transaction_description}";
|
| 868 | 868 |
} |
| 869 |
if ($form->{fulltext}) {
|
|
| 870 |
push @options, $locale->text('Full Text') . " : $form->{fulltext}";
|
|
| 871 |
} |
|
| 869 | 872 |
if ($form->{parts_description}) {
|
| 870 | 873 |
push @options, $locale->text('Part Description') . " : $form->{parts_description}";
|
| 871 | 874 |
} |
| templates/design40_webpages/do/search.html | ||
|---|---|---|
| 103 | 103 |
<td> <input type="text" name="transaction_description" class="fixed_width wi-mediumsmall"> |
| 104 | 104 |
</td> |
| 105 | 105 |
</tr> |
| 106 |
<tr> |
|
| 107 |
<th align="right">[% 'Full Text' | $T8 %]</th> |
|
| 108 |
<td>[% L.input_tag('fulltext', '', class="fixed_width wi-mediumsmall") %]</td>
|
|
| 109 |
</tr> |
|
| 106 | 110 |
<tr> |
| 107 | 111 |
<th class="caption" colspan="2">[% 'Article data' | $T8 %]</th> |
| 108 | 112 |
</tr> |
| templates/webpages/do/search.html | ||
|---|---|---|
| 72 | 72 |
<td><input name="parts_description" size="20" class="fixed_width"></td> |
| 73 | 73 |
</tr> |
| 74 | 74 |
|
| 75 |
<tr> |
|
| 76 |
<th align="right">[% 'Full Text' | $T8 %]</th> |
|
| 77 |
<td colspan="3">[% L.input_tag('fulltext', '', class="fixed_width") %]</td>
|
|
| 78 |
</tr> |
|
| 79 |
|
|
| 75 | 80 |
<tr> |
| 76 | 81 |
<th align="right">[% 'Project Number' | $T8 %]</th> |
| 77 | 82 |
<td> |
Auch abrufbar als: Unified diff
Volltext-Suche im Lieferscheinbericht