projekt kivitendo

      "insertdate"         => "ct.itime",

      "salesman"           => "e.name",

      "payment"            => "pt.description",

      "pricegroup"         => "pg.pricegroup",

      "ustid"              => "ct.ustid",

      "creditlimit"        => "ct.creditlimit",

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

  }

  if($form->{insertdatefrom}) {

    $where .= qq| AND (ct.itime::DATE >= ?)|;

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

  }

  my $query =

    qq|SELECT ct.*, ct.itime::DATE AS insertdate, b.description AS business, e.name as salesman, | .

    $pg_select .

    $main_cp_select .

    (qq|, NULL AS invnumber, NULL AS ordnumber, NULL AS quonumber, NULL AS invid, NULL AS module, NULL AS formtype, NULL AS closed | x!! $join_records) .

    qq|LEFT JOIN business b ON (ct.business_id = b.id) | .

    qq|LEFT JOIN employee e ON (ct.salesman_id = e.id) | .

    qq|LEFT JOIN payment_terms pt ON (ct.payment_id = pt.id) | .

    $pg_join .

    qq|WHERE $where|;

use SL::DB::Default;

use SL::DB::DeliveryTerm;

use SL::DB::Manager::PaymentTerm;

use SL::ReportGenerator;

use SL::Locale::String qw(t8);

use SL::MoreCommon qw(uri_encode);

  $form->get_lists("business_types" => "ALL_BUSINESS_TYPES",

                   "salesmen"       => "ALL_SALESMEN");

  $form->{ALL_PAYMENT_TERMS} = SL::DB::Manager::PaymentTerm->get_all_sorted;

  $form->{SHOW_BUSINESS_TYPES} = scalar @{ $form->{ALL_BUSINESS_TYPES} } > 0;

  $form->{CUSTOM_VARIABLES}                  = CVar->get_configs('module' => 'CT');

    }

  }

  if ( $form->{insertdatefrom} or $form->{insertdateto} ) {

    push @options, $locale->text('Insert Date');

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

    'id',        'name',    "$form->{db}number",   'contact', 'main_contact_person',

    'department_1',         'department_2',        'phone',   'discount',

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

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

    'creditlimit', 'ustid', 'commercial_court', 'delivery_order_mail', 'dunning_lock'

  );

    'salesman'          => { 'text' => $locale->text('Salesman'), },

    'discount'          => { 'text' => $locale->text('Discount'), },

    'payment'           => { 'text' => $locale->text('Payment Terms'), },

    'insertdate'        => { 'text' => $locale->text('Insert Date'), },

    'pricegroup'        => { 'text' => $locale->text('Pricegroup'), },

    'invoice_mail'      => { 'text' => $locale->text('Email of the invoice recipient'), },

  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>[% 'Payment Term' | $T8 %]</th>

          <td>[% L.select_tag('payment_id', ALL_PAYMENT_TERMS, with_empty=1, title_key='description', with_empty=1, class="wi-lightwide") %]</td>

        </tr>

      [% CUSTOM_VARIABLES_FILTER_CODE %]

      <tr>

        <th>[% 'Scope' | $T8 %] </th>

      <input name="l_payment" id="l_payment" type="checkbox" value="Y">

      <label for="l_payment"> [% 'Payment Terms' | $T8 %] </label>

    </div>

  </div>

  <div class="list col">

     <td>[% L.select_tag('payment_id', ALL_PAYMENT_TERMS, with_empty=1, title_key='description', with_empty=1) %]</td>

   </tr>

[% IF IS_CUSTOMER %]

   <tr>

     <th align="right" nowrap>[% LxERP.t8("Factur-X/ZUGFeRD settings") %]</th>

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

        <label for="l_payment">[% 'Payment Terms' | $T8 %]</label>

       </td>

       <td>

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

        <label for="l_insertdate">[% 'Insert Date' | $T8 %]</label>