projekt kivitendo

use SL::Helper::PrintOptions;

sub action_showdetails {

  my ($self, %params) = @_;

  eval {

      my @bindata;

      my $bins = SL::DB::Manager::Bin->get_all(with_objects => ['warehouse' ]);

      my %bins_by_id = map { $_->id => $_ } @$bins;

      my $inventories = SL::DB::Manager::Inventory->get_all(where => [ parts_id => $self->part->id],

                             with_objects => ['parts', 'trans_type' ], sort_by => 'bin_id ASC');

      foreach my $bin (@{ $bins }) {

          $bin->{qty} = 0;

      }

      foreach my $inv (@{ $inventories }) {

          my $bin = $bins_by_id{ $inv->bin_id };

          $bin->{qty}      += $inv->qty;

          $bin->{unit}     =  $inv->parts->unit;

          $bin->{reserved} =  defined $inv->reserve_for_id ? 1 : 0;

      }

      my $sum = 0;

      my $reserve_sum = 0;

      for my $bin (@{ $bins }) {

        push @bindata , {

          'warehouse'    => $bin->warehouse->forreserve ? $bin->warehouse->description.' (R)' : $bin->warehouse->description,

          'description'  => $bin->description,

          'qty'          => $bin->{qty},

          'unit'         => $bin->{unit},

        } if $bin->{qty} != 0;

        $sum += $bin->{qty};

        if($bin->warehouse->forreserve || defined $bin->warehouse->{reserve_for_id}){

          $reserve_sum += $bin->{qty};

        }

      }

      # Einfacher ? $sum = $self->part->onhand

      my $todate   = DateTime->now_local;

      my $fromdate = DateTime->now_local->add_duration(DateTime::Duration->new(years => -1));

      my $average  = 0;

      foreach my $inv (@{ $inventories }) {

        $average += abs($inv->qty) if $inv->shippingdate && $inv->trans_type->direction eq 'out' &&

          DateTime->compare($inv->shippingdate,$fromdate) != -1 &&

          DateTime->compare($inv->shippingdate,$todate)   == -1;

      }

      my $openitems = SL::DB::Manager::OrderItem->get_all(where => [ parts_id => $self->part->id, 'order.closed' => 0 ],

                                                           with_objects => ['order'],);

      my ($not_delivered, $ordered) = 0;

      for my $openitem (@{ $openitems }) {

        if($openitem -> order -> type eq 'sales_order') {

          $not_delivered += $openitem->qty - $openitem->shipped_qty;

        } elsif ( $openitem->order->type eq 'purchase_order' ) {

          $ordered += $openitem->qty - $openitem->delivered_qty;

        }

      }

      my $print_form = Form->new('');

      my $part = $self->part;

      my $stock_amounts = $self->part->get_simple_stock_sql;

      $print_form->{type}      = 'part';

      $print_form->{printers}  = SL::DB::Manager::Printer->get_all_sorted;

      my $output = SL::Presenter->get->render('part/showdetails',

          part          => $self->part,

          BINS          => \@bindata,

          stock_amounts => $stock_amounts,

          average       => $average/12,

          fromdate      => $fromdate,

          todate        => $todate,

          sum           => $sum,

          reserve_sum   => $reserve_sum,

          not_delivered => $not_delivered,

          ordered       => $ordered,

          type_beleg    => $::form->{type},

          type_id       => $::form->{type_id},

          maker_id      => $::form->{maker_id},

          drawing       => $::form->{drawing},

    print_options   => SL::Helper::PrintOptions->get_print_options(

      form => $print_form,

      options => {dialog_name_prefix => 'print_options.',

                  show_headers       => 1,

                  no_queue           => 1,

                  no_postscript      => 1,

                  no_opendocument    => 1,

                  hide_language_id_print => 1,

                  no_html            => 1},

    ),

      );

      $self->render(\$output, { layout => 0, process => 0 });

    1;

  } or do {

  };

}

sub action_print_label {

  my ($self) = @_;

  # TODO: implement

  return $self->render('generic/error', { layout => 1 }, label_error => t8('Not implemented yet!'));

}

  ns.print_from_showdetail = function(part_id) {

    var data = $('#print_options_form').serializeArray();

    data.push({ name: 'action', value: 'Part/print_label' });

    data.push({ name: 'part.id', value: part_id });

  $.download("controller.pl", data);

  };

[%- USE LxERP -%][% USE L %][% USE HTML %][%- USE JavaScript -%][% USE T8 %][%- USE Dumper %]

<div style="padding-bottom: 15px">

  <table style="width: 100%" border="0px" ><tbody>

      <tr>

        <td><b>[%  LxERP.t8('Description') %]</b></td><td colspan="3">[% part.description %]</td>

      </tr>

      <tr>

        <td style="background:wheat;"><b>[%  LxERP.t8('Internal Notes') %]</b></td><td colspan="3" style="background:wheat;">[% part.intnotes %]</td>

      </tr>

      <tr>

        <td><b>[%  LxERP.t8('Default Warehouse') %]</b></td><td>[% part.warehouse.description %]</td>

        <td><b>[%  LxERP.t8('Default Bin') %]</b></td><td>[% part.bin.description %]</td>

      </tr>

      <tr>

        <td><b>[%  LxERP.t8('ROP') %]</b></td><td>[% part.rop_as_number %]</td>

      </tr>

      <tr>

        [%- IF stock_amounts.size %]

        <td colspan="4"><table style="width: 100%">

          <tr class='listheading'>

           <th class="listheading">[% 'Warehouse'   | $T8 %]</th>

           <th class="listheading">[% 'Bin'         | $T8 %]</th>

           <th class="listheading">[% 'Chargenumber'         | $T8 %]</th>

           <th class="listheading">[% 'Qty'         | $T8 %]</th>

           <th class="listheading">[% 'Unit'        | $T8 %]</th>

         </tr>

         [% FOREACH stock = stock_amounts %]

          <tr class='listrow'>

           <td                >[% HTML.escape(stock.warehouse_description)  %]</td>

           <td                >[% IF stock.order_link %]<a target="_blank" href="[% stock.order_link %]">[% END %]

                               [% HTML.escape(stock.bin_description)        %]

                               [% IF stock.order_link %]</a>[% END %]

           </td>

           <td                >[% HTML.escape(stock.chargenumber)                   %]</td>

           <td class='numeric'>[% LxERP.format_amount(stock.qty, dec)       %]</td>

           <td                >[% HTML.escape(stock.unit)                   %]</td>

          </tr>

          [% IF stock.wh_lead != stock.warehouse_description %]

          <tr class='listheading'>

           <th class="listheading"                >[% HTML.escape(stock.warehouse_description)           %]</th>

           <td></td>

           <td></td>

           <td class='numeric bold'>[% LxERP.format_amount(stock.wh_run_qty, dec)         %]</td>

           <td></td>

          </tr>

          [% END %]

          [% IF loop.last %]

          <tr class='listheading'>

           <th class="listheading">[% 'Total' | $T8 %]</th>

           <td></td>

           <td></td>

           <td class='numeric bold'>[% LxERP.format_amount(stock.run_qty, dec)         %]</td>

           <td></td>

          </tr>

          [% END %]

         [% END %]

        [% ELSE %]

        <td>

          <p>[% 'No transactions yet.' | $T8 %]</p>

        [% END %]

        </td>

      </tr>

      <tr>

        <td><b>[%  LxERP.t8('Sum Amount') %]</b></td><td>[% LxERP.format_amount(sum, 2) %] [% part.unit %]</td>

        <td rowspan="5">

          [% file = part.default_partimage %]

          [%- IF file && INSTANCE_CONF.get_parts_show_image %]

          <img src="controller.pl?action=File/download&id=[% file.id %][%- IF file.version %]&version=[%- file.version %][%- END %]" alt="[% file.title %]" style="[% INSTANCE_CONF.get_parts_image_css %]">

          [% END %]

        </td>

        <td rowspan="5">

  [%- FOREACH file = part.get_files %]

      <a href="controller.pl?action=File/download&id=[% file.id %][%- IF file.version %]&version=[%- file.version %][%- END %]">

        <span id="[% "filename_" _ file.id %][%- IF file.version %]_[% file.version %][%- END %]">[% file.file_name %]</span></a><br><br>

  [%- END %]

        </td>

      </tr>

      <tr>

        <td><b>[%  LxERP.t8('Not delivered amount') %]</b></td><td colspan="3">[% LxERP.format_amount(not_delivered, 2) %] [% part.unit %]</td></tr>

      </tr>

      <tr>

        <td><b>[%  LxERP.t8('Ordered, but not delivered (purchase)') %]</b></td><td colspan="3">[% LxERP.format_amount(ordered, 2) %] [% part.unit %]</td></tr>

      </tr>

      <tr>

        <td><b>[%  LxERP.t8('Reserved amount') %]</b></td><td colspan="3">[% LxERP.format_amount(part.stockqty - part.onhandqty, 2) %] [% part.unit %]</td></tr>

      </tr>

      <tr>

        <td><b>[%  LxERP.t8('Available amount') %]</b></td><td colspan="3">[% LxERP.format_amount(part.onhandqty, 2) %] [% part.unit %]</td></tr>

      </tr>

      <tr>

        <td><b>[%  LxERP.t8('Consume average') %]</b></td><td colspan="3">[% LxERP.format_amount(average, 2) %] [% part.unit %] [% LxERP.t8('per month') %]</td></tr>

        <tr><td colspan="4" nowrap>([%  LxERP.t8('in the time between') %] [% fromdate.to_kivitendo %] - [% todate.to_kivitendo %])</td>

      </tr>

      <tr>

        <td>[%- L.button_tag("return \$('#detail_menu').dialog('close');", LxERP.t8('Close Details'), class => "submit") %]</td>

      </tr>

  </tbody></table>

</div>

<div id="print_options" >

  <form id="print_options_form">

    [% print_options %]

    <br>

    [% L.button_tag('kivi.Part.print_from_showdetail(' _ part.id _ ')', LxERP.t8('Print')) %]

  </form>

</div>