Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 991369b1

Von Bernd Bleßmann vor mehr als 2 Jahren hinzugefügt

  • ID 991369b17d679e2855f4d5086d0b9769dc2ae1aa
  • Vorgänger 04dccca7
  • Nachfolger 45ee0662

Volltext-Suche im Auftragsbericht

Unterschiede anzeigen:

SL/OE.pm
318 318 
    push(@values, like($form->{phone_notes}), like($form->{phone_notes}));
319 319 
  }
320 320 

  		




  
  321
  
    
  $form->{fulltext} = trim($form->{fulltext});


  		




  
  322
  
    
  if ($form->{fulltext}) {


  		




  
  323
  
    
    my @fulltext_fields = qw(o.notes


  		




  
  324
  
    
                             o.intnotes


  		




  
  325
  
    
                             o.shippingpoint


  		




  
  326
  
    
                             o.shipvia


  		




  
  327
  
    
                             o.transaction_description


  		




  
  328
  
    
                             o.quonumber


  		




  
  329
  
    
                             o.ordnumber


  		




  
  330
  
    
                             o.cusordnumber);


  		




  
  331
  
    
    $query .= ' AND (';


  		




  
  332
  
    
    $query .= join ' ILIKE ? OR ', @fulltext_fields;


  		




  
  333
  
    
    $query .= ' ILIKE ?';


  		




  
  334
  
    
    $query .= qq| OR EXISTS (SELECT files.id FROM files LEFT JOIN file_full_texts ON (file_full_texts.file_id = files.id) WHERE files.object_id = o.id AND files.object_type = 'sales_order' AND file_full_texts.full_text ILIKE ?)|;


  		




  
  335
  
    
    $query .= qq| OR EXISTS (SELECT notes.id FROM notes WHERE notes.trans_id = o.id AND notes.trans_module LIKE 'oe' AND (notes.subject ILIKE ? OR notes.body ILIKE ?))|;


  		




  
  336
  
    
    $query .= ')';


  		




  
  337
  
    
    push(@values, like($form->{fulltext})) for 1 .. (scalar @fulltext_fields) + 3;


  		




  
  338
  
    
  }


  		




  
  339
  
    

  		




  321
  340
  
    
  if ($form->{parts_partnumber}) {


  		




  322
  341
  
    
    $query .= <<SQL;


  		




  323
  342
  
    
      AND EXISTS (


  		












  

    
      bin/mozilla/oe.pl
    
  





  1102
  1102
  
    
                                                        reqdatefrom reqdateto projectnumber project_id periodic_invoices_active periodic_invoices_inactive


  		




  1103
  1103
  
    
                                                        business_id shippingpoint taxzone_id reqdate_unset_or_old insertdatefrom insertdateto


  		




  1104
  1104
  
    
                                                        order_probability_op order_probability_value expected_billing_date_from expected_billing_date_to


  		




  1105
  
  
    
                                                        parts_partnumber parts_description all department_id intnotes phone_notes);


  		




  
  1105
  
    
                                                        parts_partnumber parts_description all department_id intnotes phone_notes fulltext);


  		




  1106
  1106
  
    
  push @hidden_variables, map { "cvar_$_->{name}" } @ct_searchable_custom_variables;


  		




  1107
  1107
  
    

  		




  1108
  1108
  
    
  my   @keys_for_url = grep { $form->{$_} } @hidden_variables;


  		




  ......




  1189
  1189
  
    
  push @options, $locale->text('Part Description')        . " : $form->{parts_description}"               if $form->{parts_description};


  		




  1190
  1190
  
    
  push @options, $locale->text('Part Number')             . " : $form->{parts_partnumber}"                if $form->{parts_partnumber};


  		




  1191
  1191
  
    
  push @options, $locale->text('Phone Notes')             . " : $form->{phone_notes}"                     if $form->{phone_notes};


  		




  
  1192
  
    
  push @options, $locale->text('Full Text')               . " : $form->{fulltext}"                        if $form->{fulltext};


  		




  1192
  1193
  
    
  if ( $form->{transdatefrom} or $form->{transdateto} ) {


  		




  1193
  1194
  
    
    push @options, $locale->text('Order Date');


  		




  1194
  1195
  
    
    push @options, $locale->text('From') . " " . $locale->date(\%myconfig, $form->{transdatefrom}, 1)     if $form->{transdatefrom};


  		












  

    
      locale/de/all
    
  





  1635
  1635
  
    
  'Front page'                  => 'Hauptseite',


  		




  1636
  1636
  
    
  'Full Access'                 => 'Vollzugriff',


  		




  1637
  1637
  
    
  'Full Preview'                => 'Alles',


  		




  
  1638
  
    
  'Full Text'                   => 'Volltext',


  		




  1638
  1639
  
    
  'Full access to all functions' => 'Vollzugriff auf alle Funktionen',


  		




  1639
  1640
  
    
  'Function block'              => 'Funktionsblock',


  		




  1640
  1641
  
    
  'Function block actions'      => 'Funktionsblockaktionen',


  		












  

    
      locale/en/all
    
  





  1635
  1635
  
    
  'Front page'                  => '',


  		




  1636
  1636
  
    
  'Full Access'                 => '',


  		




  1637
  1637
  
    
  'Full Preview'                => '',


  		




  
  1638
  
    
  'Full Text'                   => '',


  		




  1638
  1639
  
    
  'Full access to all functions' => '',


  		




  1639
  1640
  
    
  'Function block'              => '',


  		




  1640
  1641
  
    
  'Function block actions'      => '',


  		












  

    
      templates/webpages/oe/search.html
    
  





  84
  84
  
    
     <th align="right">[% 'Phone Notes' | $T8 %]</th>


  		




  85
  85
  
    
     <td>[% L.input_tag('phone_notes', '', style=style) %]</td>


  		




  86
  86
  
    
    </tr>


  		




  
  87
  
    
    [%- IF type == 'sales_order' %]


  		




  
  88
  
    
    <tr>


  		




  
  89
  
    
     <th align="right">[% 'Full Text' | $T8 %]</th>


  		




  
  90
  
    
     <td>[% L.input_tag('fulltext', '', style=style) %]</td>


  		




  
  91
  
    
    </tr>


  		




  
  92
  
    
    [%- END %]


  		




  87
  93
  
    
    <tr>


  		




  88
  94
  
    
     <th align="right">[% IF is_order %][% 'Order Date' | $T8 %][% ELSE %][% 'Quotation Date' | $T8 %][% END %] [% 'From' | $T8 %]</th>


  		




  89
  95
  
    
     <td>


  		












Auch abrufbar als:  Unified diff