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