projekt kivitendo

      "ustid"              => "ct.ustid",

      "creditlimit"        => "ct.creditlimit",

      "commercial_court"   => "ct.commercial_court",

    );

  $form->{sort} ||= "name";

  }

  my $sortdir   = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC';

    $sortorder  = "lower($sortorder) ${sortdir}";

  } else {

    $sortorder .= " ${sortdir}";

    push @values, conv_date($form->{insertdateto});

  }

  if ($form->{all}) {

    my @tokens = parse_line('\s+', 0, $form->{all});

      $where .= qq| AND (

  push @options, $locale->text('Billing/shipping address (GLN)')     . " : $form->{addr_gln}"              if $form->{addr_gln};

  push @options, $locale->text('Quick Search')                       . " : $form->{all}"                   if $form->{all};

  push @options, $locale->text('Factur-X/ZUGFeRD settings')          . " : $zugferd_filter"                if $zugferd_filter;

  if ($form->{business_id}) {

    my $business = SL::DB::Manager::Business->find_by(id => $form->{business_id});

    'fax',       'email',   'taxnumber',           'street',    'zipcode' , 'city',

    'business',  'payment', 'invnumber', 'ordnumber',           'quonumber', 'salesman',

    'country',   'gln',     'insertdate',           'pricegroup', 'contact_origin', 'invoice_mail',

  );

  my @includeable_custom_variables = grep { $_->{includeable} } @{ $cvar_configs };

    'ustid'             => { 'text' => $locale->text('VAT ID'), },

    'commercial_court'  => { 'text' => $locale->text('Commercial court'), },

    create_zugferd_invoices => { text => $locale->text('Factur-X/ZUGFeRD settings'), },

    %column_defs_cvars,

  );

  my @hidden_variables  = ( qw(

      db status obsolete name contact email cp_name addr_street addr_zipcode

      addr_city addr_country addr_gln business_id salesman_id insertdateto insertdatefrom all

    ), "$form->{db}number",

    map({ "cvar_$_->{name}" } @searchable_custom_variables),

    map({'cvar_'. $_->{name} .'_from'} grep({$_->{type} eq 'date'} @searchable_custom_variables)),

          <th>[% 'All phone numbers' | $T8 %]</th>

          <td><input type="text" name="all_phonenumbers" class="wi-normal"></td>

        </tr>

      </tbody>

    </table>

      <input name="l_creditlimit" id="l_creditlimit" type="checkbox" class="checkbox" value="Y">

      <label for="l_creditlimit">[% 'Credit Limit' | $T8 %]</label>

    </div>

    <div>

      <input name="l_commercial_court" id="l_commercial_court" type="checkbox" class="checkbox" value="Y">

      <label for="l_commercial_court">[% 'Commercial court' | $T8 %]</label>

      [% L.date_tag('insertdateto') %]

    </td>

   </tr>

   [% CUSTOM_VARIABLES_FILTER_CODE %]

        <input name="l_department_2" id="l_department_2" type="checkbox" class="checkbox" value="Y">

        <label for="l_department_2">[% 'Department' | $T8 %] 2</label>

       </td>

      </tr>

      [% END %]