projekt kivitendo

  my $vc = $form->{vc} eq "customer" ? "customer" : "vendor";

  $query =

         ct.name, dord.${vc}_id, dord.globalproject_id,

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

         dord.transaction_description,

         pr.projectnumber AS globalprojectnumber,

         e.name AS employee,

         sm.name AS salesman,

         oe.id AS oe_id

       FROM delivery_orders dord

       LEFT JOIN $vc ct ON (dord.${vc}_id = ct.id)

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

       LEFT JOIN employee sm ON (dord.salesman_id = sm.id)

       LEFT JOIN project pr ON (dord.globalproject_id = pr.id)

       LEFT JOIN oe ON ((dord.ordnumber = oe.ordnumber) AND NOT COALESCE(oe.quotation, FALSE))|;

  push @where, ($form->{type} eq 'sales_delivery_order' ? '' : 'NOT ') . qq|COALESCE(dord.is_sales, FALSE)|;

    "id"                      => "dord.id",

    "donumber"                => "dord.donumber",

    "ordnumber"               => "dord.ordnumber",

    "name"                    => "ct.name",

    "employee"                => "e.name",

    "salesman"                => "sm.name",

         id, delivery_order_id, parts_id, description, longdescription, qty, base_qty,

         sellprice, discount, unit, reqdate, project_id, serialnumber,

         ordnumber, transdate, cusordnumber,

       VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

  my $h_item = prepare_query($form, $dbh, $q_item);

  my $q_item_stock =

               $form->{"cusordnumber_$i"},

               $form->{"lastcost_$i"},

               conv_i($form->{"price_factor_id_$i"}), conv_i($form->{"price_factor_id_$i"}),

    do_statement($form, $h_item, $q_item, @values);

    my $stock_info = DO->unpack_stock_information('packed' => $form->{"stock_${in_out}_$i"});

  # save DO record

  $query =

    qq|UPDATE delivery_orders SET

         customer_id = ?, reqdate = ?,

         shippingpoint = ?, shipvia = ?, notes = ?, intnotes = ?, closed = ?,

         delivered = ?, department_id = ?, language_id = ?, shipto_id = ?,

       WHERE id = ?|;

  @values = ($form->{donumber}, $form->{ordnumber},

             conv_i($form->{vendor_id}), conv_i($form->{customer_id}),

             conv_date($reqdate), $form->{shippingpoint}, $form->{shipvia},

             $form->{notes}, $form->{intnotes},

    # so if any of these infos is important (or even different) for any item,

    # it will be killed out and then has to be fetched from the item scope query further down

    $query =

           dord.shippingpoint, dord.shipvia, dord.notes, dord.intnotes,

           e.name AS employee, dord.employee_id, dord.salesman_id,

           dord.${vc}_id, cv.name AS ${vc},

           doi.reqdate, doi.project_id, doi.serialnumber, doi.lastcost,

           doi.ordnumber, doi.transdate, doi.cusordnumber, doi.longdescription,

           doi.price_factor_id, doi.price_factor, doi.marge_price_factor,

           pr.projectnumber,

           pg.partsgroup

         FROM delivery_order_items doi

    qw(runningnumber number description longdescription qty unit

       partnotes serialnumber reqdate projectnumber

       si_runningnumber si_number si_description

  my $sameitem = "";

  foreach $item (sort { $a->[1] cmp $b->[1] } @partsgroup) {

    push @{ $form->{serialnumber} },    $form->{"serialnumber_$i"};

    push @{ $form->{reqdate} },         $form->{"reqdate_$i"};

    push @{ $form->{projectnumber} },   $projectnumbers{$form->{"project_id_$i"}};

    if ($form->{"assembly_$i"}) {

      $sameitem = "";

  my @columns = qw(

    transdate

    id                      donumber

    name                    employee

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

    'shipvia'                 => { 'text' => $locale->text('Ship via'), },

    'delivered'               => { 'text' => $locale->text('Delivered'), },

  );

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

  }

  my $edit_url       = build_std_url('action=edit', 'type', 'vc');

  my $edit_order_url = build_std_url('script=oe.pl', 'type=' . ($form->{type} eq 'sales_delivery_order' ? 'sales_order' : 'purchase_order'), 'action=edit');

  foreach $dord (@{ $form->{DO} }) {

    $dord->{open}      = $dord->{closed}    ? $locale->text('No')  : $locale->text('Yes');

    my $row = { map { $_ => { 'data' => $dord->{$_} } } @columns };

    $report->add_data($row);

  }

  'Last Credit Note Number'     => 'Letzte Gutschriftnummer',

  'Last Customer Number'        => 'Letzte Kundennummer',

  'Last Invoice Number'         => 'Letzte Rechnungsnummer',

  'Last Purchase Delivery Order Number' => 'Letzte Lieferscheinnummer (Einkauf)',

  'Last Purchase Order Number'  => 'Letzte Lieferantenautragsnummer',

  'Last RFQ Number'             => 'Letzte Anfragenummer',

  'Last Sales Delivery Order Number' => 'Letzte Lieferscheinnummer (Verkauf)',

  'Last Sales Order Number'     => 'Letzte Auftragsnummer',

  'Last Sales Quotation Number' => 'Letzte Angebotsnummer',

  'Order Date missing!'         => 'Auftragsdatum fehlt!',

  'Order Number'                => 'Auftragsnummer',

  'Order Number missing!'       => 'Auftragsnummer fehlt!',

  'Order deleted!'              => 'Auftrag gel?scht!',

  'Ordered'                     => 'Vom Kunde bestellt',

  'Orientation'                 => 'Seitenformat',

  'Order Date missing!'         => 'Auftragsdatum fehlt!',

  'Order Number'                => 'Auftragsnummer',

  'Order Number missing!'       => 'Auftragsnummer fehlt!',

  'Others'                      => 'Andere',

  'PAYMENT POSTED'              => 'Rechung gebucht',

  'PDF'                         => 'PDF',

  'Order Date missing!'         => 'Auftragsdatum fehlt!',

  'Order Number'                => 'Auftragsnummer',

  'Order Number missing!'       => 'Auftragsnummer fehlt!',

  'Order deleted!'              => 'Auftrag gel?scht!',

  'Other users\' follow-ups'    => 'Wiedervorlagen anderer Benutzer',

  'Others'                      => 'Andere',

  'Order Date missing!'         => 'Auftragsdatum fehlt!',

  'Order Number'                => 'Auftragsnummer',

  'Order Number missing!'       => 'Auftragsnummer fehlt!',

  'Order deleted!'              => 'Auftrag gel?scht!',

  'Others'                      => 'Andere',

  'PAYMENT POSTED'              => 'Rechung gebucht',

  'Order Date missing!'         => 'Auftragsdatum fehlt!',

  'Order Number'                => 'Auftragsnummer',

  'Order Number missing!'       => 'Auftragsnummer fehlt!',

  'Order deleted!'              => 'Auftrag gel?scht!',

  'Other users\' follow-ups'    => 'Wiedervorlagen anderer Benutzer',

  'Others'                      => 'Andere',

     <td><input name="pdonumber" size="10" value="[% HTML.escape(defaults_pdonumber) %]"></td>

    </tr>

    <tr class="listheading">

     <th colspan="4">Standardkonten</th>

    </tr>

     <td><input name="pdonumber" size="10" value="[% HTML.escape(defaults_pdonumber) %]"></td>

    </tr>

    <tr class="listheading">

     <th colspan="4"><translate>Default Accounts</translate></th>

    </tr>

        <td><input name="cusordnumber" size="11" value="[% HTML.escape(cusordnumber) %]"[% RO %]></td>

       </tr>

       <tr>

        <th align="right" nowrap>Lieferscheindatum</th>

        <td nowrap>

        <td><input name="cusordnumber" size="11" value="[% HTML.escape(cusordnumber) %]"[% RO %]></td>

       </tr>

       <tr>

        <th align="right" nowrap><translate>Delivery Order Date</translate></th>

        <td nowrap>

     <td colspan="3"><input name="ordnumber" class="fixed_width"></td>

    </tr>

    [%- IF ALL_DEPARTMENTS.size %]

    <tr>

     <th align="right" nowrap>Abteilung</th>

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

         <label for="l_cusordnumber">Bestellnummer des Kunden</label>

        </td>

       </tr>

       <tr>

     <td colspan="3"><input name="ordnumber" class="fixed_width"></td>

    </tr>

    [%- IF ALL_DEPARTMENTS.size %]

    <tr>

     <th align="right" nowrap><translate>Department</translate></th>

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

         <label for="l_cusordnumber"><translate>Customer Order Number</translate></label>

        </td>

       </tr>

       <tr>

                    <th width=70% align=right nowrap>Auftragsnummer</th>

                    <td><input name=ordnumber size=11 value="[% HTML.escape(ordnumber) %]"></td>

                  </tr>

[%- END %]

                  <tr>

                    <th width=70% align=right nowrap>[% IF is_req_quo %]Anfragenummer[% ELSE %]Angebotsnummer[% END %]</th>

                    <th width=70% align=right nowrap><translate>Order Number</translate></th>

                    <td><input name=ordnumber size=11 value="[% HTML.escape(ordnumber) %]"></td>

                  </tr>

[%- END %]

                  <tr>

                    <th width=70% align=right nowrap>[% IF is_req_quo %]<translate>RFQ Number</translate>[% ELSE %]<translate>Quotation Number</translate>[% END %]</th>