projekt kivitendo

    qq|  o.marge_total, o.marge_percent, | .

    qq|  o.exchangerate, | .

    qq|  o.itime::DATE AS insertdate, | .

    qq|  department.description as department, | .

    qq|  ex.$rate AS daily_exchangerate, | .

    qq|  pt.description AS payment_terms, | .

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

  }

  if ($form->{parts_partnumber}) {

    $query .= <<SQL;

      AND EXISTS (

    "taxzone"                 => "tz.description",

    "payment_terms"           => "pt.description",

    "department"              => "department.description",

  );

  if ($form->{sort} && grep($form->{sort}, keys(%allowed_sort_columns))) {

    $sortorder = $allowed_sort_columns{$form->{sort}} . " ${sortdir}"  . ", o.itime ${sortdir}";

    "country",                 "shippingpoint",

    "taxzone",                 "insertdate",

    "order_probability",       "expected_billing_date", "expected_netamount",

  );

  # only show checkboxes if gotten here via sales_order form.

                                                        reqdatefrom reqdateto projectnumber project_id periodic_invoices_active periodic_invoices_inactive

                                                        business_id shippingpoint taxzone_id reqdate_unset_or_old insertdatefrom insertdateto

                                                        order_probability_op order_probability_value expected_billing_date_from expected_billing_date_to

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

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

    'expected_billing_date'   => { 'text' => $locale->text('Exp. bill. date'), },

    'expected_netamount'      => { 'text' => $locale->text('Exp. netamount'), },

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

    %column_defs_cvars,

  );

    my $sortdir                 = $form->{sort} eq $name ? 1 - $form->{sortdir} : $form->{sortdir};

    $column_defs{$name}->{link} = $href . "&sort=$name&sortdir=$sortdir";

  }

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

  push @options, $locale->text('Customer Order Number')   . " : $form->{cusordnumber}"                    if $form->{cusordnumber};

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

  push @options, $locale->text('Transaction description') . " : $form->{transaction_description}"         if $form->{transaction_description};

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

  push @options, $locale->text('Shipping Point')          . " : $form->{shippingpoint}"                   if $form->{shippingpoint};

     </td>

    </tr>

    [%- END %]

    <tr>

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

     <td>

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

         <label for="l_salesman">[% 'Salesman' | $T8 %]</label>

        </td>

       </tr>

[% IF type == 'sales_quotation' %]

       <tr>