projekt kivitendo

    qq|  o.exchangerate, | .

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

    qq|  o.intnotes,| .

    qq|  department.description as department, | .

    qq|  ex.$rate AS daily_exchangerate, | .

    qq|  pt.description AS payment_terms, | .

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

  }

  if($form->{transdatefrom}) {

    $query .= qq| AND o.transdate >= ?|;

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

                             o.transaction_description

                             o.quonumber

                             o.ordnumber

    $query .= ' AND (';

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

    $query .= ' ILIKE ?';

    "department"              => "department.description",

    "intnotes"                => "o.intnotes",

    "order_status"            => "order_statuses.name",

  );

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

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

  my @columns = (

    "transdate",               "reqdate",

    "id",                      $ordnumber,

    "name",                    "netamount",

    "tax",                     "amount",

    "remaining_netamount",     "remaining_amount",

    parts_description all department_id intnotes phone_notes fulltext

    order_status_id shiptoname shiptodepartment_1 shiptodepartment_2

    shiptostreet shiptozipcode shiptocity shiptocountry

  );

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

    shiptozipcode             => { 'text' => $locale->text('Zipcode (Shipping)'), },

    shiptocity                => { 'text' => $locale->text('City (Shipping)'), },

    shiptocountry             => { 'text' => $locale->text('Country (Shipping)'), },

    %column_defs_cvars,

  );

  foreach my $name (qw(id transdate reqdate quonumber ordnumber cusordnumber

                       name employee salesman shipvia transaction_description

                       shippingpoint taxzone insertdate payment_terms department

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

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

  }

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

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

  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('Internal Notes')          . " : $form->{intnotes}"                        if $form->{intnotes};

      <th>[% HTML.escape(ordlabel) %]</th>

      <td>[% L.input_tag(ordnrname, "", class="wi-lightwide") %]</td>

    </tr>

    [% IF is_order %]

    <tr>

      <th>[% LxERP.t8("Customer Order Number") %]</th>

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

    <label for="l_globalprojectnumber">[% 'Project Number' | $T8 %]</label>

  </div>

  [% IF is_order %]

  <div>

    <input name="l_cusordnumber" id="l_cusordnumber" type="checkbox" value="Y" checked>

     <td colspan=3>[% L.select_tag('order_status_id', ALL_ORDER_STATUSES, default = order_status_id, title_key = 'name', with_empty = 1, style=style) %]</td>

    </tr>

[% IF is_order %]

    <tr>

     <th align="right">[% LxERP.t8("Customer Order Number") %]</th>

         <input name="l_[% HTML.escape(ordnrname) %]" id="l_[% HTML.escape(ordnrname) %]" class="checkbox" type="checkbox" value="Y" checked>

         <label for="l_[% HTML.escape(ordnrname) %]">[% HTML.escape(ordlabel) %]</label>

        </td>

[% IF is_order %]

        <td>

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

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

        </td>

        [%- END %]

       </tr>

       <tr>

        <td>