projekt kivitendo

  my $query =

    qq|SELECT dord.id, dord.donumber, dord.ordnumber, dord.transdate,

         dord.closed, dord.delivered, dord.shippingpoint, dord.shipvia,

         dord.transaction_description,

         pr.projectnumber AS globalprojectnumber,

  $query =

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

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

    qq|  o.transaction_description, | .

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

  my @columns = qw(

    ids                     transdate

    id                      donumber

    name                    employee  salesman

    shipvia                 globalprojectnumber

    transaction_description

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

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

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

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

    'employee'                => { 'text' => $locale->text('Employee'), },

    'salesman'                => { 'text' => $locale->text('Salesman'), },

  my @columns = (

    "transdate",               "reqdate",

    "id",                      $ordnumber,

    "name",                    "netamount",

    "tax",                     "amount",

    "curr",                    "employee",

    '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'), },

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

    'tax'                     => { 'text' => $locale->text('Tax'), },

    'amount'                  => { 'text' => $locale->text('Total'), },

          <tr>

           <td align=right><input name="l_name" class=checkbox type=checkbox value=Y checked></td>

           <td nowrap>[% 'Customer' | $T8 %]</td>

           <td align=right><input name="l_netamount" class=checkbox type=checkbox value="Y" checked></td>

           <td nowrap>[% 'Amount' | $T8 %]</td>

           <td align=right><input name="l_tax" class=checkbox type=checkbox value=Y></td>

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

         <label for="l_name">[% IF is_customer %][% 'Customer' | $T8 %][% ELSE %][% 'Vendor' | $T8 %][% END %]</label>

        </td>

       </tr>

       <tr>

         <label for="l_shipvia">[% 'Ship via' | $T8 %]</label>

        </td>

       </tr>

       <tr>

        <td>

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