projekt kivitendo

sub action_list {

  my ( $self ) = @_;

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

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

  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,

                                                    );

  foreach my $shop_order(@{ $shop_orders }){

sub shops_dd {

  my ( $self ) = @_;

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

  my @tmp = map { { title => $_->{description}, value => $_->{id} } } @{ $shops } ;

  push @shops_dd, @tmp;

 <table id="shoplist" width="100%">

  <thead>

   <tr class="listheading">

    <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 %]&filter.order_date:date::ge=[% FORM.filter.order_date_date__ge %]&filter.order_date:date::le=[% FORM.filter.order_date_date__le %]&filter.obsolete=[% FORM.filter.obsolete %]" 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>

      <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&filter.order_date:date::ge=[% FORM.filter.order_date_date__ge %]&filter.order_date:date::le=[% FORM.filter.order_date_date__le %]&filter.obsolete=[% FORM.filter.obsolete %]" 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 %]&filter.order_date:date::ge=[% FORM.filter.order_date_date__ge %]&filter.order_date:date::le=[% FORM.filter.order_date_date__le %]&filter.obsolete=[% FORM.filter.obsolete %]" class="sort_link">

  [% # Dumper.dump_html(shop_order) %]

    [% IF shop_order.kivi_customer.id && shop_order.kivi_customer.order_lock == 0 && shop_order.open_invoices == 0 %] [% SET transferable = 1 %] [% SET transferable_class = 'style="background:rgba(43, 208, 54, 0.5);"' %] [% ELSE %] [% SET transferable = 0 %] [% SET transferable_class = '' %][% END %]

  <tr class="listrow">

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