projekt kivitendo

package SL::Controller::ShopOrder;

use strict;

use parent qw(SL::Controller::Base);

use SL::DB::ShopOrder;

use SL::DB::ShopOrderItem;

use SL::DB::Shop;

use SL::Shop;

use SL::Presenter;

use SL::Locale::String;

use SL::Controller::Helper::ParseFilter;

use Rose::Object::MakeMethods::Generic

(

  'scalar --get_set_init' => [ qw(shop_order transferred) ],

);

use Data::Dumper;

sub action_get_orders {

  my ( $self ) = @_;

  my $active_shops = SL::DB::Manager::Shop->get_all(query => [ obsolete => 0 ]);

  foreach my $shop_config ( @{ $active_shops } ) {

    my $shop = SL::Shop->new( config => $shop_config );

    my $new_orders = $shop->connector->get_new_orders;

  };

  $self->action_list;

}

sub action_list {

  my ( $self ) = @_;

  $::lxdebug->dump(0, "WH: LIST ", \$::form);

  my %filter = ($::form->{filter} ? parse_filter($::form->{filter}) : query => [ transferred => 0 ]);

  my $transferred = $::form->{filter}->{transferred_eq_ignore_empty} ne '' ? $::form->{filter}->{transferred_eq_ignore_empty} : '';

  #$::lxdebug->dump(0, "WH: FILTER ",  $::form->{filter}->{_eq_ignore_empty}." - ".$transferred);

  #$::lxdebug->dump(0, "WH: FILTER2 ",  \%filter);

  my $sort_by = $::form->{sort_by} ? $::form->{sort_by} : 'order_date';

  $sort_by .=$::form->{sort_dir} ? ' DESC' : ' ASC';

  my $shop_orders = SL::DB::Manager::ShopOrder->get_all( %filter, sort_by => $sort_by,

                                                      with_objects => ['shop_order_items'],

                                                    );

  $::lxdebug->dump(0, "WH: IMPORTS ",  \$shop_orders);

  $self->render('shop_order/list',

                title       => t8('ShopOrders'),

                SHOPORDERS  => $shop_orders,

                TOOK        => $transferred,  # is this used?

              );

}

sub action_show {

  my ( $self ) = @_;

  my $id = $::form->{id} || {};

  my $shop_order = SL::DB::Manager::ShopOrder->find_by( id => $id );

  die "can't find shoporder with id $id" unless $shop_order;

  # the different importaddresscheck if there complete in the customer table to prevent duplicats inserts

  my %customer_address = ( 'name'    => $shop_order->customer_lastname,

                           'company' => $shop_order->customer_company,

                           'street'  => $shop_order->customer_street,

                           'zipcode' => $shop_order->customer_zipcode,

                           'city'    => $shop_order->customer_city,

                         );

  my %billing_address = ( 'name'     => $shop_order->billing_lastname,

                          'company'  => $shop_order->billing_company,

                          'street'   => $shop_order->billing_street,

                          'zipcode'  => $shop_order->billing_zipcode,

                          'city'     => $shop_order->billing_city,

                        );

  my %delivery_address = ( 'name'    => $shop_order->delivery_lastname,

                           'company' => $shop_order->delivery_company,

                           'street'  => $shop_order->delivery_street,

                           'zipcode' => $shop_order->delivery_zipcode,

                           'city'    => $shop_order->delivery_city,

                         );

  my $c_address = $self->check_address(%customer_address);

  my $b_address = $self->check_address(%billing_address);

  my $d_address = $self->check_address(%delivery_address);

  ####

  my $lastname = $shop_order->customer_lastname;

  my $proposals = SL::DB::Manager::Customer->get_all(

       where => [

                   or => [

                            and => [ # when matching names also match zipcode

                                     or => [ 'name' => { like => "%$lastname%"},

                                             'name' => { like => $shop_order->customer_company },

                                           ],

                                     'zipcode' => { like => $shop_order->customer_zipcode },

                                   ],

                            or  => [ 'email' => { like => $shop_order->customer_email } ],

                         ],

                ],

  );

  $self->render('shop_order/show',

                title       => t8('Shoporder'),

                IMPORT      => $shop_order,

                PROPOSALS   => $proposals,

                C_ADDRESS   => $c_address,

                B_ADDRESS   => $b_address,

                D_ADDRESS   => $d_address,

              );

}

sub action_transfer {

  my ( $self ) = @_;

  my $customer = SL::DB::Manager::Customer->find_by(id => $::form->{customer});

  die "Can't find customer" unless $customer;

  my $employee = SL::DB::Manager::Employee->current;

  # $self->shop_order inits via $::form->{import_id}

  die "Can't load shop_order form form->import_id" unless $self->shop_order;

  my $order = $self->shop_order->convert_to_sales_order(customer => $customer, employee => $employee);

  $order->save;

  $self->shop_order->transferred(1);

  $self->shop_order->transfer_date(DateTime->now_local);

  $self->shop_order->oe_transid($order->id);

  $self->shop_order->save;

  $self->shop_order->link_to_record($order);

  $self->redirect_to(controller => "oe.pl", action => 'edit', type => 'sales_order', vc => 'customer', id => $order->id);

}

sub action_apply_customer {

  my ( $self ) = @_;

  $::lxdebug->dump(0, "WH: CUSTOMER ", \$::form);

  my $what = $::form->{create_customer}; # billing, customer or delivery

  $::lxdebug->dump(0, "WH: WHAT ",$what);

  my %address = ( 'name'       => $::form->{$what.'_name'},

                  'street'     => $::form->{$what.'_street'},

                  'zipcode'    => $::form->{$what.'_zipcode'},

                  'city'       => $::form->{$what.'_city'},

                  'email'      => $::form->{$what.'_email'},

                  'country'    => $::form->{$what.'_country'},

                  'greeting'   => $::form->{$what.'_greeting'},

                  'taxzone_id' => 4,  # hardcoded, use default taxzone instead

                  'currency'   => 1,  # hardcoded

                );

  $address{contact} = ($address{name} ne $::form->{$what.'_firstname'} . " " . $::form->{$what.'_lastname'} ? $::form->{$what.'_firstname'} . " " . $::form->{$what.'_lastname'} : '');

  $::lxdebug->dump(0, "WH: ADDRESS ",\%address);

  my $customer = SL::DB::Customer->new(%address);

  $customer->save;

  if($::form->{$what.'_country'} ne "Deutschland") {   # hardcoded

    $self->redirect_to(controller => "controller.pl", action => 'CustomerVendor/edit', id => $customer->id);

  }else{

    $self->redirect_to(action => 'show', id => $::form->{import_id});

  }

}

#

# Helper

#

sub check_address {

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

  my $addressdata = SL::DB::Manager::Customer->get_all(

                                query => [

                                            or => [ 'name'   => { like => "%$address{'name'}%" }, 'name' => { like => $address{'company'} }, ],

                                           'street' => { like => $address{'street'} },

                                           'zipcode'=> { like => $address{'zipcode'} },

                                           'city'   => { like => $address{'city'} },

                                         ]);

  $::lxdebug->dump(0, "WH: CUSTOMER ", \$addressdata);

  return @{$addressdata}[0];

}

sub init_shop_order {

  my ( $self ) = @_;

  return SL::DB::ShopOrder->new(id => $::form->{import_id})->load if $::form->{import_id};

}

sub init_transferred {

  # data for drop down filter options

  [ { title => t8("all"),             value => '' },

    { title => t8("transferred"),     value => 1  },

    { title => t8("not transferred"), value => 0  }, ]

}

1;

use SL::DB::Helper::LinkedRecords;

sub convert_to_sales_order {

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

  my $customer = $params{customer};

  my $employee = $params{employee};

  die unless ref($customer) eq 'SL::DB::Customer';

  die unless ref($employee) eq 'SL::DB::Employee';

  require SL::DB::Order;

  require SL::DB::OrderItem;

  require SL::DB::Part;

  require SL::DB::Shipto;

  my @order_items;

  foreach my $items (@{$self->shop_order_items}) {

    my $item = SL::DB::OrderItem->new;

    my $part = SL::DB::Manager::Part->find_by( partnumber => $items->{partnumber} );

    $item->assign_attributes(

        parts_id        => $part->id,

        description     => $items->description,

        qty             => $items->quantity,

        sellprice       => $items->price,

        unit            => $part->unit,

        );

    push(@order_items,$item);

  }

  my $shipto_id;

  if ($self->{billing_firstname} ne $self->{delivery_firstname} || $self->{billing_lastname} ne $self->{delivery_lastname} || $self->{billing_city} ne $self->{delivery_city} || $self->{billing_street} ne $self->{delivery_street}) {

    if(my $address = SL::DB::Manager::Shipto->find_by( shiptoname          => $self->{delivery_firstname} . " " . $self->{delivery_lastname}, 

                                                        shiptostreet        => $self->{delivery_street},

                                                        shiptocity          => $self->{delivery_city},

                                                      )) {

      $shipto_id = $address->{shipto_id};

    } else {

      my $gender = $self->{delivery_greeting} eq "Frau" ? 'f' : 'm';

      my $deliveryaddress = SL::DB::Shipto->new;

      $deliveryaddress->assign_attributes(

        shiptoname      => $self->{delivery_firstname} . " " . $self->{delivery_lastname},

        shiptocp_gender => $gender,

        shiptostreet    => $self->{delivery_street},

        shiptozipcode   => $self->{delivery_zipcode},

        shiptocity      => $self->{delivery_city},

        shiptocountry   => $self->{delivery_country},

        trans_id        => $customer->id,   # ????

        module          => "CT",

      );

      $deliveryaddress->save;

      $shipto_id = $deliveryaddress->{shipto_id};

    }

  }

  my $order = SL::DB::Order->new(

                  amount                  => $self->amount,

                  cusordnumber            => $self->shop_id,

                  customer_id             => $customer->id,

                  shipto_id               => $shipto_id,

                  orderitems              => [ @order_items ],

                  employee_id             => $employee->id,

                  intnotes                => $self->{shop_customer_comment},

                  salesman_id             => $employee->id,

                  taxincluded             => 1,   # TODO: make variable

                  taxzone_id              => $customer->taxzone_id,

                  currency_id             => $customer->currency_id,

                  transaction_description => 'Shop Import',

                  transdate               => DateTime->today_local

                );

  # $order->save;

  return $order;

};

[%- USE T8 %]

[%- USE L %]

[%- USE LxERP %]

[%- USE HTML %]

<form action='controller.pl' method='post'>

 [% L.submit_tag('action_get_orders',LxERP.t8('New shop orders')) %]

 <table id='filter_table'>

    <tr>

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

     <td>[% L.select_tag('filter.transferred:eq_ignore_empty', SELF.transferred, value_key = 'value', title_key = 'title', default=TOOK) %]</td>

    </tr>

    <tr>

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

     <td>[% L.date_tag('filter.order_date:date::ge', filter.order_date_date__ge) %]</td>

    </tr>

    <tr>

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

     <td>[% L.date_tag('filter.order_date:date::le', filter.order_date_date__le) %]</td>

    </tr>

 </table>

<a href='#' onClick='javascript:$("#filter_table input").val("");$("#filter_table input[type=checkbox]").prop("checked", 0);'>[% 'Reset' | $T8 %]</a>

<br>

 [% L.hidden_tag('action', 'ShopOrder/dispatch') %]

 [% L.submit_tag('action_list',LxERP.t8('renew')) %]

</form>

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

[% USE Dumper %]

<h1>[% title %]</h1>

[%- PROCESS 'shop_order/_filter.html' filter=SELF.models.filtered.laundered %]

<hr>

 <table id="shoplist">

  <thead>

   <tr class="listheading">

    <th>[% 'Shop Host' | $T8 %]</th>

    <th>[% IF FORM.sort_by == 'order_date' %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=order_date&sort_dir=[% 1 - FORM.sort_dir %]" class="sort_link">

        [% 'Shop orderdate' | $T8 %][% IF FORM.sort_dir == 0 %]<img border="0" src="image/down.png">[% ELSE %]<img border="0" src="image/up.png">[% END %]</a>

    [% ELSE %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=order_date&sort_dir=0" class="sort_link">

        [% 'Shop orderdate' | $T8 %]</a>

    [% END %]

    </th>

    <th>[% IF FORM.sort_by == 'shop_ordernumber' %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=shop_ordernumber&sort_dir=[% 1 - FORM.sort_dir %]" class="sort_link">

        [% 'Shop ordernumber' | $T8 %][% IF FORM.sort_dir == 0 %]<img border="0" src="image/down.png">[% ELSE %]<img border="0" src="image/up.png">[% END %]</a>

    [% ELSE %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=shop_ordernumber&sort_dir=0" class="sort_link">

        [% 'Shop ordernumber' | $T8 %]</a>

    [% END %]

    </th>

    <th>[% IF FORM.sort_by == 'shop_customer_number' %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=shop_customer_number&sort_dir=[% 1 - FORM.sort_dir %]" class="sort_link">

        [% 'Shop customernumber' | $T8 %][% IF FORM.sort_dir == 0 %]<img border="0" src="image/down.png">[% ELSE %]<img border="0" src="image/up.png">[% END %]</a>

    [% ELSE %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=shop_customer_number&sort_dir=0" class="sort_link">

        [% 'Shop customernumber' | $T8 %]</a>

    [% END %]

    </th>

    <th>[% 'Shop Customer Address' | $T8 %]<br>

    [% IF FORM.sort_by == 'customer_lastname' %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=customer_lastname&sort_dir=[% 1 - FORM.sort_dir %]" class="sort_link">

        [% 'Name' | $T8 %][% IF FORM.sort_dir == 0 %]<img border="0" src="image/down.png">[% ELSE %]<img border="0" src="image/up.png">[% END %]</a>|

    [% ELSE %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=customer_lastname&sort_dir=0" class="sort_link">

        [% 'Name' | $T8 %]</a>|

    [% END %]

    [% IF FORM.sort_by == 'customer_zipcode' %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=customer_zipcode&sort_dir=[% 1 - FORM.sort_dir %]" class="sort_link">

        [% 'Zip' | $T8 %][% IF FORM.sort_dir == 0 %]<img border="0" src="image/down.png">[% ELSE %]<img border="0" src="image/up.png">[% END %]</a>|

    [% ELSE %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=customer_zipcode&sort_dir=0" class="sort_link">

        [% 'Zip' | $T8 %]</a>|

    [% END %]

    [% IF FORM.sort_by == 'customer_country' %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=customer_country&sort_dir=[% 1 - FORM.sort_dir %]" class="sort_link">

        [% 'Country' | $T8 %][% IF FORM.sort_dir == 0 %]<img border="0" src="image/down.png">[% ELSE %]<img border="0" src="image/up.png">[% END %]</a>

    [% ELSE %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=customer_country&sort_dir=0" class="sort_link">

        [% 'Country' | $T8 %]</a>

    [% END %]

      </th>

    <th>[% 'Shop Billing Address' | $T8 %]</br>

    [% IF FORM.sort_by == 'billing_lastname' %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=billing_lastname&sort_dir=[% 1 - FORM.sort_dir %]" class="sort_link">

        [% 'Name' | $T8 %][% IF FORM.sort_dir == 0 %]<img border="0" src="image/down.png">[% ELSE %]<img border="0" src="image/up.png">[% END %]</a>|

    [% ELSE %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=billing_lastname&sort_dir=0" class="sort_link">

        [% 'Name' | $T8 %]</a>|

    [% END %]

    [% IF FORM.sort_by == 'billing_zipcode' %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=billing_zipcode&sort_dir=[% 1 - FORM.sort_dir %]" class="sort_link">

        [% 'Zip' | $T8 %][% IF FORM.sort_dir == 0 %]<img border="0" src="image/down.png">[% ELSE %]<img border="0" src="image/up.png">[% END %]</a>|

    [% ELSE %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=billing_zipcode&sort_dir=0" class="sort_link">

        [% 'Zip' | $T8 %]</a>|

    [% END %]

    [% IF FORM.sort_by == 'billing_country' %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=billing_country&sort_dir=[% 1 - FORM.sort_dir %]" class="sort_link">

        [% 'Country' | $T8 %][% IF FORM.sort_dir == 0 %]<img border="0" src="image/down.png">[% ELSE %]<img border="0" src="image/up.png">[% END %]</a>

    [% ELSE %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=billing_country&sort_dir=0" class="sort_link">

        [% 'Country' | $T8 %]</a>

    [% END %]

      </th>

    <th>[% 'Shop Delivery Address' | $T8 %]</br>

    [% IF FORM.sort_by == 'delivery_lastname' %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=delivery_lastname&sort_dir=[% 1 - FORM.sort_dir %]" class="sort_link">

        [% 'Name' | $T8 %][% IF FORM.sort_dir == 0 %]<img border="0" src="image/down.png">[% ELSE %]<img border="0" src="image/up.png">[% END %]</a>|

    [% ELSE %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=delivery_lastname&sort_dir=0" class="sort_link">

        [% 'Name' | $T8 %]</a>|

    [% END %]

    [% IF FORM.sort_by == 'delivery_zipcode' %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=delivery_zipcode&sort_dir=[% 1 - FORM.sort_dir %]" class="sort_link">

        [% 'Zip' | $T8 %][% IF FORM.sort_dir == 0 %]<img border="0" src="image/down.png">[% ELSE %]<img border="0" src="image/up.png">[% END %]</a>|

    [% ELSE %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=delivery_zipcode&sort_dir=0" class="sort_link">

        [% 'Zip' | $T8 %]</a>|

    [% END %]

    [% IF FORM.sort_by == 'delivery_country' %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=delivery_country&sort_dir=[% 1 - FORM.sort_dir %]" class="sort_link">

        [% 'Country' | $T8 %][% IF FORM.sort_dir == 0 %]<img border="0" src="image/down.png">[% ELSE %]<img border="0" src="image/up.png">[% END %]</a>

    [% ELSE %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=delivery_country&sort_dir=0" class="sort_link">

        [% 'Country' | $T8 %]</a>

    [% END %]

      </th>

    <th>[% IF FORM.sort_by == 'shop_customer_comment' %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=shop_customer_comment&sort_dir=[% 1 - FORM.sort_dir %]" class="sort_link">

        [% 'Notes' | $T8 %][% IF FORM.sort_dir == 0 %]<img border="0" src="image/down.png">[% ELSE %]<img border="0" src="image/up.png">[% END %]</a>

    [% ELSE %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=shop_customer_comment&sort_dir=0" class="sort_link">

        [% 'Notes' | $T8 %]</a>

    [% END %]

    </th>

    <th>

      [% 'Positions' | $T8 %]<br>

      [% IF FORM.sort_by == 'amount' %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=amount&sort_dir=[% 1 - FORM.sort_dir %]" class="sort_link">

        [% 'Amount' | $T8 %][% IF FORM.sort_dir == 0 %]<img border="0" src="image/down.png">[% ELSE %]<img border="0" src="image/up.png">[% END %]</a>

      [% ELSE %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=amount&sort_dir=0" class="sort_link"> [% 'Amount' | $T8 %]</a><br>

      [% END %]

      [% IF FORM.sort_by == 'shipping_costs' %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=shipping_costs&sort_dir=[% 1 - FORM.sort_dir %]" class="sort_link">

        [% 'Shippingcosts' | $T8 %][% IF FORM.sort_dir == 0 %]<img border="0" src="image/down.png">[% ELSE %]<img border="0" src="image/up.png">[% END %]</a>

      [% ELSE %]

      <a href ="controller.pl?action=ShopOrder/list&filter.transferred:eq_ignore_empty=[% FORM.filter.transferred_eq_ignore_empty %]&sort_by=shipping_costs&sort_dir=0" class="sort_link"> [% 'Shippingcosts' | $T8 %]</a><br>

      [% END %]

    </th>

    <th></th>

   </tr>

  </thead>

  [% FOREACH shop_order = SHOPORDERS %]

  <tr class="listrow">

    <td>[% HTML.escape(shop_order.host) %]</td>

    <td>[% shop_order.order_date.dmy('.') _ ' ' _ shop_order.order_date.hms(':') %]</td>

    <td>[% HTML.escape(shop_order.shop_ordernumber) %]</td>

    <td>[% HTML.escape(shop_order.shop_customer_number) %]</td>

    <td>[% IF shop_order.customer_company %]<b>[% HTML.escape(shop_order.customer_company) %]</b><br>[% END %]

      <b>[% HTML.escape(shop_order.customer_lastname) %],&nbsp;[% HTML.escape(shop_order.customer_firstname) %]</b>

      <br>[% HTML.escape(shop_order.customer_street) %]

      <br>[% HTML.escape(shop_order.customer_zipcode) %]&nbsp;[% HTML.escape(shop_order.customer_city) %]

      <br>[% HTML.escape(shop_order.customer_country) %] </td>

    <td>[% IF shop_order.customer_company %]<b>[% HTML.escape(shop_order.customer_company) %]</b><br>[% END %]

      <b>[% HTML.escape(shop_order.billing_lastname) %],&nbsp;[% HTML.escape(shop_order.billing_firstname) %]</b>

      <br>[% HTML.escape(shop_order.billing_street) %]

      <br>[% HTML.escape(shop_order.billing_zipcode) %]&nbsp;[% HTML.escape(shop_order.billing_city) %]

      <br>[% HTML.escape(shop_order.billing_country) %] </td>

    [% IF (shop_order.delivery_lastname != shop_order.billing_lastname || shop_order.delivery_firstname != shop_order.billing_firstname || shop_order.delivery_street != shop_order.billing_street || shop_order.delivery_city != shop_order.billing_city) %] [% SET deliveryclass = 'style="background-color:red;"' %] [% ELSE %] [% SET deliveryclass = '' %] [% END %]

    <td [% deliveryclass %]>[% IF shop_order.customer_company %]<b>[% HTML.escape(shop_order.customer_company) %]</b><br>[% END %]

      <b>[% HTML.escape(shop_order.delivery_lastname) %],&nbsp;[% HTML.escape(shop_order.delivery_firstname) %]</b>

      <br>[% HTML.escape(shop_order.delivery_street) %]

      <br>[% HTML.escape(shop_order.delivery_zipcode) %]&nbsp;[% HTML.escape(shop_order.delivery_city) %]

      <br>[% HTML.escape(shop_order.delivery_country) %] </td>

    <td>[% HTML.escape(shop_order.shop_customer_comment) %]</td>

    <td>[% shop_order.shop_order_items.size %]<br>[% shop_order.amount_as_number %]<br>[% shop_order.shipping_costs_as_number %]</td>

    <td>[% IF shop_order.transferred == 1 %]<a href="controller.pl?id=[% shop_order.id %]&action=ShopOrder/show">[% 'Show order' | $T8 %]<br>[% shop_order.transferred_date_as_date %]</a>

        [% ELSE %]<a href="controller.pl?id=[% shop_order.id %]&action=ShopOrder/show">[% 'Create order' | $T8 %][% END %]</a></td>

  </tr>

  [% END %]

 </table>

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

[% L.stylesheet_tag('webshop') %]

<h1>[% title %]</h1>

<form method="post" action="controller.pl">

  <div class="table main">

    <div class="table-row listheading">

      <div class="table-cell">

        <div class="table" style="margin:150px,15px,15px,15px;">

          <div class="table-row listheading">

            <div class="table-cell">[% 'Shop Customer Address' | $T8 %]</div>

          </div>

          <div class="table-row"><div class="table-cell">[% 'Greeting' | $T8 %]</div><div class="table-cell">[% L.input_tag('customer_greeting', IMPORT.customer_greeting) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Firstname' | $T8 %]</div><div class="table-cell">[% L.input_tag('customer_firstname', IMPORT.customer_firstname) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Lastname' | $T8 %]</div><div class="table-cell">[% L.input_tag('customer_lastname', IMPORT.customer_lastname) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Company' | $T8 %]</div><div class="table-cell">[% L.input_tag('customer_company', IMPORT.customer_company) %]</div></div>

          [% IF IMPORT.customer_company == '' %]

            [% SET customer = IMPORT.customer_firstname _ ' ' _ IMPORT.customer_lastname %]

          [% ELSE %]

            [% SET customer = IMPORT.customer_company %]

          [% END %]

          <hr>

          <div class="table-row"><div class="table-cell">[% 'Customer' | $T8 %]</div><div class="table-cell">[% L.input_tag('customer_name', customer) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Street' | $T8 %]</div><div class="table-cell">[% L.input_tag('customer_street', IMPORT.customer_street) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Zipcode' | $T8 %]</div><div class="table-cell">[% L.input_tag('customer_zipcode', IMPORT.customer_zipcode) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'City' | $T8 %]</div><div class="table-cell">[% L.input_tag('customer_city', IMPORT.customer_city) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Country' | $T8 %]</div><div class="table-cell">[% L.input_tag('customer_country', IMPORT.customer_country) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Email' | $T8 %]</div><div class="table-cell">[% L.input_tag('customer_email', IMPORT.customer_email) %]</div></div>

          [% IF C_ADDRESS %]

          <div>[% C_ADDRESS.customernumber %]</div>

          [% ELSE %]

          <div>[% L.radio_button_tag('create_customer', value='customer') %]</div>

          [% END %]

        </div>

      </div>

      <div class="table-cell">

        <div class="table">

          <div class="table-row listheading">

            <div class="table-cell">[% 'Shop Billing  Address' | $T8 %]</div>

          </div>

          <div class="table-row"><div class="table-cell">[% 'Greeting' | $T8 %]</div><div class="table-cell">[% L.input_tag('billing_greeting', IMPORT.billing_greeting) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Firstname' | $T8 %]</div><div class="table-cell">[% L.input_tag('billing_firstname', IMPORT.billing_firstname) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Lastname' | $T8 %]</div><div class="table-cell">[% L.input_tag('billing_lastname', IMPORT.billing_lastname) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Company' | $T8 %]</div><div class="table-cell">[% L.input_tag('billing_company', IMPORT.billing_company) %]</div></div>

          [% IF IMPORT.billing_company == '' %]

            [% SET billing = IMPORT.billing_firstname _ ' ' _ IMPORT.billing_lastname %]

          [% ELSE %]

            [% SET billing = IMPORT.billing_company %]

          [% END %]

          <hr>

          <div class="table-row"><div class="table-cell">[% 'Customer' | $T8 %]</div><div class="table-cell">[% L.input_tag('billing_name', billing) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Street' | $T8 %]</div><div class="table-cell">[% L.input_tag('billing_street', IMPORT.billing_street) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Zipcode' | $T8 %]</div><div class="table-cell">[% L.input_tag('billing_zipcode', IMPORT.billing_zipcode) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'City' | $T8 %]</div><div class="table-cell">[% L.input_tag('billing_city', IMPORT.billing_city) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Country' | $T8 %]</div><div class="table-cell">[% L.input_tag('billing_country', IMPORT.billing_country) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Email' | $T8 %]</div><div class="table-cell">[% L.input_tag('billing_email', IMPORT.billing_email) %]</div></div>

          [% IF B_ADDRESS %]

          <div>[% B_ADDRESS.customernumber %]</div>

          [% ELSE %]

          <div>[% L.radio_button_tag('create_customer', value='billing') %]</div>

          [% END %]

        </div>

      </div>

      <div class="table-cell">

        <div style="display:table;">

          <div class="table-row listheading">

            <div class="table-cell">[% 'Shop Delivery Address' | $T8 %]</div>

          </div>

          <div class="table-row"><div class="table-cell">[% 'Greeting' | $T8 %]</div><div class="table-cell">[% L.input_tag('delivery_greeting', IMPORT.billing_greeting) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Firstname' | $T8 %]</div><div class="table-cell">[% L.input_tag('delivery_firstname', IMPORT.delivery_firstname) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Lastname' | $T8 %]</div><div class="table-cell">[% L.input_tag('delivery_lastname', IMPORT.delivery_lastname) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Company' | $T8 %]</div><div class="table-cell">[% L.input_tag('delivery_company', IMPORT.delivery_company) %]</div></div>

          [% IF IMPORT.delivery_company == '' %]

            [% SET delivery = IMPORT.delivery_firstname _ ' ' _ IMPORT.delivery_lastname %]

          [% ELSE %]

            [% SET delivery = IMPORT.delivery_company %]

          [% END %]

          <hr>

          <div class="table-row"><div class="table-cell">[% 'Customer' | $T8 %]</div><div class="table-cell">[% L.input_tag('delivery_name', delivery) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Street' | $T8 %]</div><div class="table-cell">[% L.input_tag('delivery_street', IMPORT.delivery_street) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Zipcode' | $T8 %]</div><div class="table-cell">[% L.input_tag('delivery_zipcode', IMPORT.delivery_zipcode) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'City' | $T8 %]</div><div class="table-cell">[% L.input_tag('delivery_city', IMPORT.delivery_city) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Country' | $T8 %]</div><div class="table-cell">[% L.input_tag('delivery_country', IMPORT.delivery_country) %]</div></div>

          <div class="table-row"><div class="table-cell">[% 'Email' | $T8 %]</div><div class="table-cell">[% L.input_tag('delivery_email', IMPORT.delivery_email) %]</div></div>

          [% IF D_ADDRESS %]

          <div>[% D_ADDRESS.customernumber %]</div>

          [% ELSE %]

          <div>[% L.radio_button_tag('create_customer', value='delivery') %]</div>

          <div>[% L.submit_tag('action_apply_customer', LxERP.t8('Create customer')) %]</div>

          [% END %]

        </div>

      </div>

    </div>

  </div>

  <hr>

  <table width="100%">

    <tr>

      <td width="35%">

        <table>

          <tr class="listheading">

            <th colspan="2">[% 'Shop Headdata' | $T8 %]</th>

          </tr>

          <tr><td><b>[% 'Shop Ordernumber' | $T8 %]</b></td><td>[% HTML.escape(IMPORT.shop_ordernumber) %]</td></tr>

          <tr><td><b>[% 'Shop Orderdate' | $T8 %]</b></td><td>[% HTML.escape(IMPORT.order_date.dmy('.')) _ ' ' _ HTML.escape(IMPORT.order_date.hms(':')) %]</td></tr>

          <tr><td><b>[% 'Shop Host' | $T8 %]</b></td><td>[% HTML.escape(IMPORT.host) %]</td></tr>

          <tr><td><b>[% 'Shop OrderIP' | $T8 %]</b></td><td>[% HTML.escape(IMPORT.remote_ip) %]</td></tr>

          <tr><td><b>[% 'Shop Ordernotes' | $T8 %]</b></td><td>[% HTML.escape(IMPORT.shop_customer_comment) %]</td></tr>

          <tr><td><b>[% 'Shop Orderamount' | $T8 %]</b></td><td>[% HTML.escape(IMPORT.amount_as_number) %]</td></tr>

          <tr><td><b>[% 'Shipping costs' | $T8 %]</b></td><td>[% HTML.escape(IMPORT.shipping_costs_as_number) %]</td></tr>

        </table>

      </td>

      <td style="padding-left: 20px; vertical-align: top;">

        [% UNLESS IMPORT.tranferred %]

        [% IF PROPOSALS %]

        <div style="height: 120px; overflow:auto;">

          <table>

            <tr class="listheading">

              <th colspan="7">Customer Proposals</td>

            </tr>

            [% FOREACH prop = PROPOSALS %]

            <tr>

              <td>[% L.radio_button_tag('customer', value=prop.id) %]</td>

              <td>[% HTML.escape(prop.customernumber) %]</td>

              <td>[% HTML.escape(prop.name) %]</td>

              <td>[% HTML.escape(prop.street) %]</td>

              <td>[% HTML.escape(prop.zipcode) %]</td>

              <td>[% HTML.escape(prop.city) %]</td>

              <td>[% HTML.escape(prop.email) %]</td>

            </tr>

            [% END %]

          </table>

       [% END # PROPOSALS %]

        </div>

        [% L.hidden_tag('action', 'ShopOrder/dispatch') %]

        [% L.hidden_tag('import_id', IMPORT.id) %]

        [%- L.submit_tag('action_transfer', LxERP.t8('Create order')) %]

       [% ELSE %]

        <div>

          Wurde schon übernommen

        </div>

        [% END %]

      </td>

    </tr>

  </table>

  <hr>

  <div style="height: 250px; overflow:auto; margin:15px;">

    <table width="99%">

      <tr class="listheading">

        <th>[% 'Position' | $T8 %]</th>

        <th>[% 'Partnumber' | $T8 %]</th>

        <th>[% 'Partdescriptipion' | $T8 %]</th>

        <th>[% 'Qty' | $T8 %]</th>

        <th>[% 'Price' | $T8 %]</th>

        <th>[% 'Extended' | $T8 %]</th>

      </tr>

      [% SET counter = 1 %]

      [% FOREACH pos = IMPORT.shop_order_items %]

      <tr class="listrow">

        <td>[% counter %]</td>

        <td>[% HTML.escape(pos.partnumber) %]</td>

        <td>[% HTML.escape(pos.description) %]</td>

        <td>[% pos.quantity_as_number%]</td>

        <td>[% pos.price_as_number%]</td>

        [% SET extended = pos.price * pos.quantity %]

        <td>[% LxERP.format_amount(extended,2) %]</td>

      </tr>

      [% SET counter = counter + 1 %]

      [% END %]

    </table>

  </div>

  <hr>

</form>

<script type="text/javascript">

  function apply_customer(address) {

    alert('Hallo ' + address);

    $.post("controller.pl", { action: 'ShopOrder/list'});

  }

</script>

[% L.dump(IMPORT) %]