projekt kivitendo

    qq|  o.closed, o.delivered, o.quonumber, o.cusordnumber, o.shippingpoint, o.shipvia, | .

    qq|  o.transaction_description, | .

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

    qq|  ex.$rate AS exchangerate, | .

    qq|  pr.projectnumber AS globalprojectnumber, | .

    qq|  e.name AS employee, s.name AS salesman, | .

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

  }

  if ($form->{shippingpoint}) {

    $query .= qq| AND o.shippingpoint ILIKE ?|;

    push(@values, '%' . $form->{shippingpoint} . '%');

    "shipvia"                 => "o.shipvia",

    "transaction_description" => "o.transaction_description",

    "shippingpoint"           => "o.shippingpoint",

    "taxzone"                 => "tz.description",

  );

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

           o.closed, o.reqdate, o.quonumber, o.department_id, o.cusordnumber,

           d.description AS department, o.payment_id, o.language_id, o.taxzone_id,

           o.delivery_customer_id, o.delivery_vendor_id, o.proforma, o.shipto_id,

         FROM oe o

         JOIN ${vc} cv ON (o.${vc}_id = cv.id)

         LEFT JOIN employee e ON (o.employee_id = e.id)

    "marge_total",             "marge_percent",

    "vcnumber",                "ustid",

    "country",                 "shippingpoint",

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

  );

  push @hidden_variables, "l_subtotal", $form->{vc}, qw(l_closed l_notdelivered open closed delivered notdelivered ordnumber quonumber cusordnumber

                                                        transaction_description transdatefrom transdateto type vc employee_id salesman_id

                                                        reqdatefrom reqdateto projectnumber project_id periodic_invoices_active periodic_invoices_inactive

                                                        order_probability_op order_probability_value expected_billing_date_from expected_billing_date_to);

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

    'periodic_invoices'       => { 'text' => $locale->text('Per. Inv.'), },

    'shippingpoint'           => { 'text' => $locale->text('Shipping Point'), },

    'taxzone'                 => { 'text' => $locale->text('Steuersatz'), },

    'order_probability'       => { 'text' => $locale->text('Order probability'), },

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

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

  );

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

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

  }

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

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

  };

  push @options, $locale->text('Open')                                                                    if $form->{open};

  push @options, $locale->text('Closed')                                                                  if $form->{closed};

  push @options, $locale->text('Delivery Order created')                                                               if $form->{delivered};

  'Information'                 => 'Information',

  'Initial version.'            => 'Initiale Version.',

  'Insert'                      => 'Einfügen',

  'Insert with new customer/vendor number' => 'Mit neuer Kunden-/Lieferantennummer anlegen',

  'Insert with new database ID' => 'Neu anlegen mit neuer Datenbank-ID',

  'Insert with new part number' => 'Mit neuer Artikelnummer einfügen',

  'Increase'                    => '',

  'Individual Items'            => '',

  'Information'                 => '',

  'Insert with new customer/vendor number' => '',

  'Insert with new database ID' => '',

  'Insert with new part number' => '',

                      [% L.date_tag('reqdate', reqdate, id='reqdate') %]

                    </td>

                  </tr>

                  <tr>

                    <th width="70%" align="right" nowrap>[% 'Project Number' | $T8 %]</th>

                    <td>

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

     </td>

    </tr>

[%- IF type == 'sales_quotation' %]

    <tr>

     <th align="right">[% 'Expected billing date' | $T8 %] [% 'From' | $T8 %]</th>

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

         <label for="l_reqdate">[% IF is_order %][% 'Required by' | $T8 %][% ELSE %][% 'Valid until' | $T8 %][% END %]</label>

        </td>

       </tr>

       <tr>

        <td>