Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 2e4e2ba9

Von Moritz Bunkus vor etwa 11 Jahren hinzugefügt

  • ID 2e4e2ba959344a6db630b5b9e9c6f8b93c666fc2
  • Vorgänger 2fcb9a09
  • Nachfolger 1ad3632f

Lieferscheinbericht: Suchmöglichkeit nach Seriennummer

Unterschiede anzeigen:

SL/DO.pm
130 130
    push @where, ($form->{delivered} ? "" : "NOT ") . "COALESCE(dord.delivered, FALSE)";
131 131
  }
132 132

  
133
  if ($form->{serialnumber}) {
134
    push @where, 'dord.id IN (SELECT doi.delivery_order_id FROM delivery_order_items doi WHERE doi.serialnumber LIKE ?)';
135
    push @values, '%' . $form->{serialnumber} . '%';
136
  }
137

  
133 138
  if($form->{transdatefrom}) {
134 139
    push @where,  qq|dord.transdate >= ?|;
135 140
    push @values, conv_date($form->{transdatefrom});
bin/mozilla/do.pl
507 507
  my $report = SL::ReportGenerator->new(\%myconfig, $form);
508 508

  
509 509
  my @hidden_variables = map { "l_${_}" } @columns;
510
  push @hidden_variables, $form->{vc}, qw(l_closed l_notdelivered open closed delivered notdelivered donumber ordnumber
510
  push @hidden_variables, $form->{vc}, qw(l_closed l_notdelivered open closed delivered notdelivered donumber ordnumber chargenumber
511 511
                                          transaction_description transdatefrom transdateto type vc employee_id salesman_id project_id);
512 512

  
513 513
  my $href = build_std_url('action=orders', grep { $form->{$_} } @hidden_variables);
......
565 565
  if ($form->{ordnumber}) {
566 566
    push @options, $locale->text('Order Number') . " : $form->{ordnumber}";
567 567
  }
568
  push @options, $locale->text('Serial Number') . " : $form->{serialnumber}" if $form->{serialnumber};
568 569
  if ($form->{transaction_description}) {
569 570
    push @options, $locale->text('Transaction description') . " : $form->{transaction_description}";
570 571
  }
templates/webpages/do/search.html
98 98
     </td>
99 99
    </tr>
100 100

  
101
    <tr>
102
     <th align="right">[% 'Serial Number' | $T8 %]</th>
103
     <td colspan="3"><input name="serialnumber" class="fixed_width"></td>
104
    </tr>
105

  
101 106
    <tr>
102 107
     <th align="right">[% 'From' | $T8 %]</th>
103 108
     <td>

Auch abrufbar als: Unified diff