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, | .

    qq|  pr.projectnumber AS globalprojectnumber, | .

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

    qq|  ct.${vc}number AS vcnumber, ct.country, ct.ustid, ct.business_id,  | .

    $periodic_invoices_columns .

    $phone_notes_columns .

    qq|  , o.order_probability, o.expected_billing_date, (o.netamount * o.order_probability / 100) AS expected_netamount | .

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

    qq|LEFT JOIN tax_zones tz ON (o.taxzone_id = tz.id) | .

    qq|LEFT JOIN department   ON (o.department_id = department.id) | .

    qq|$periodic_invoices_joins | .

    $phone_notes_join .

    qq|WHERE (o.quotation = ?) |;

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

  }

  if ($form->{phone_notes}) {

    $query .= qq| AND (phone_notes.subject ILIKE ? OR regexp_replace(phone_notes.body, '<[^>]*>', '', 'g') ILIKE ?)|;

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

    "payment_terms"           => "pt.description",

    "department"              => "department.description",

    "intnotes"                => "o.intnotes",

  );

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

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

  $form->get_lists("projects"     => { "key" => "ALL_PROJECTS", "all" => 1 },

                   "taxzones"     => "ALL_TAXZONES",

                   "business_types" => "ALL_BUSINESS_TYPES",);

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

  ($form->{CT_CUSTOM_VARIABLES_FILTER_CODE},

    "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_netamount'      => { 'text' => $locale->text('Exp. netamount'), },

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

    'intnotes'                => { 'text' => $locale->text('Internal Notes'), },

    %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('Bis')  . " " . $locale->date(\%myconfig, $form->{expected_billing_date_to},   1) if $form->{expected_billing_date_to};

  }

  $report->set_options('top_info_text'        => join("\n", @options),

                       'raw_top_info_text'    => $form->parse_html_template('oe/orders_top'),

                       'raw_bottom_info_text' => $form->parse_html_template('oe/orders_bottom'),

    <tr>

     <th align="right">[% HTML.escape(ordlabel) %]</th>

     <td>[% L.input_tag(ordnrname, "", style=style) %]</td>

    </tr>

[% IF is_order %]

    <tr>

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

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

         <label for="l_remaining_netamount">[% 'Remaining Net Amount' | $T8 %]</label>

        </td>

       </tr>

       <tr>

        <td colspan=4 align=left><b>[% HTML.escape(vclabel) %]</b></td>