projekt kivitendo

  $query =

    qq|SELECT o.id, o.ordnumber, o.transdate, o.reqdate, | .

    qq|  o.amount, ct.${vc}number, ct.name, o.netamount, o.${vc}_id, o.globalproject_id, | .

    qq|  o.transaction_description, | .

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

    qq|  ex.$rate AS exchangerate, | .

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

  }

  if($form->{transdatefrom}) {

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

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

    "reqdate"                 => "o.reqdate",

    "id"                      => "o.id",

    "ordnumber"               => "o.ordnumber",

    "quonumber"               => "o.quonumber",

    "name"                    => "ct.name",

    "employee"                => "e.name",

  my @columns = (

    "transdate",               "reqdate",

    "id",                      $ordnumber,

    "name",                    "netamount",

    "tax",                     "amount",

    "curr",                    "employee",

  my $report = SL::ReportGenerator->new(\%myconfig, $form);

  my @hidden_variables = map { "l_${_}" } @columns;

                                                        transaction_description transdatefrom transdateto type vc employee_id salesman_id

                                                        reqdatefrom reqdateto projectnumber project_id periodic_invoices_active periodic_invoices_inactive

                                                        business_id shippingpoint taxzone_id);

    'id'                      => { 'text' => $locale->text('ID'), },

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

    'quonumber'               => { 'text' => $form->{type} eq "request_quotation" ? $locale->text('RFQ') : $locale->text('Quotation'), },

    'name'                    => { 'text' => $form->{vc} eq 'customer' ? $locale->text('Customer') : $locale->text('Vendor'), },

    'customernumber'          => { 'text' => $locale->text('Customer Number'), },

    'netamount'               => { 'text' => $locale->text('Amount'), },

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

  );

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

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

  }

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

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

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

  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('Shipping Point')          . " : $form->{shippingpoint}"                   if $form->{shippingpoint};

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

     <td colspan="3"><input name="[% HTML.escape(ordnrname) %]" style="width: 250px"></td>

    </tr>

    <tr>

     <th align="right">[% 'Employee' | $T8 %]</th>

     <td>[% L.select_tag('employee_id', ALL_EMPLOYEES, title_key='safe_name', with_empty=1, style='width:250px') %]</td>

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

       </tr>

       <tr>

        <td>