admin/edi_accounts.pl

   1 #!/usr/bin/perl
   2
   3 # Copyright 2011,2014 Mark Gavillet & PTFS Europe Ltd
   4 #
   5 # This file is part of Koha.
   6 #
   7 # Koha is free software; you can redistribute it and/or modify it under the
   8 # terms of the GNU General Public License as published by the Free Software
   9 # Foundation; either version 3 of the License, or (at your option) any later
  10 # version.
  11 #
  12 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
  13 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
  14 # A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
  15 #
  16 # You should have received a copy of the GNU General Public License along
  17 # with Koha; if not, write to the Free Software Foundation, Inc.,
  18 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
  19
  20 use strict;
  21 use warnings;
  22 use CGI;
  23 use C4::Auth;
  24 use C4::Output;
  25 use Koha::Database;
  26
  27 my $input = CGI->new();
  28
  29 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
  30     {
  31         template_name   => 'admin/edi_accounts.tt',
  32         query           => $input,
  33         type            => 'intranet',
  34         authnotrequired => 0,
  35         flagsrequired   => { acquisition => 'edi_manage' },
  36     }
  37 );
  38
  39 my $op = $input->param('op');
  40 $op ||= 'display';
  41 my $schema = Koha::Database->new()->schema();
  42
  43 if ( $op eq 'acct_form' ) {
  44     show_account();
  45     $template->param( acct_form => 1 );
  46     my @vendors = $schema->resultset('Aqbookseller')->search(
  47         undef,
  48         {
  49             columns => [ 'name', 'id' ],
  50             order_by => { -asc => 'name' }
  51         }
  52     );
  53     $template->param( vendors => \@vendors );
  54     $template->param(
  55         code_qualifiers => [
  56             {
  57                 code        => '14',
  58                 description => 'EAN International',
  59             },
  60             {
  61                 code        => '31B',
  62                 description => 'US SAN Agency',
  63             },
  64             {
  65                 code        => '91',
  66                 description => 'Assigned by supplier',
  67             },
  68             {
  69                 code        => '92',
  70                 description => 'Assigned by buyer',
  71             },
  72         ]
  73     );
  74
  75 }
  76 elsif ( $op eq 'delete_confirm' ) {
  77     show_account();
  78     $template->param( delete_confirm => 1 );
  79 }
  80 else {
  81     if ( $op eq 'save' ) {
  82
  83         # validate & display
  84         my $id     = $input->param('id');
  85         my $fields = {
  86             description        => $input->param('description'),
  87             host               => $input->param('host'),
  88             username           => $input->param('username'),
  89             password           => $input->param('password'),
  90             vendor_id          => $input->param('vendor_id'),
  91             upload_directory   => $input->param('upload_directory'),
  92             download_directory => $input->param('download_directory'),
  93             san                => $input->param('san'),
  94             transport          => $input->param('transport'),
  95             quotes_enabled     => defined $input->param('quotes_enabled'),
  96             invoices_enabled   => defined $input->param('invoices_enabled'),
  97             orders_enabled     => defined $input->param('orders_enabled'),
  98             responses_enabled  => defined $input->param('responses_enabled'),
  99             auto_orders        => defined $input->param('auto_orders'),
 100             id_code_qualifier  => $input->param('id_code_qualifier'),
 101         };
 102
 103         if ($id) {
 104             $schema->resultset('VendorEdiAccount')->search(
 105                 {
 106                     id => $id,
 107                 }
 108             )->update_all($fields);
 109         }
 110         else {    # new record
 111             $schema->resultset('VendorEdiAccount')->create($fields);
 112         }
 113     }
 114     elsif ( $op eq 'delete_confirmed' ) {
 115
 116         $schema->resultset('VendorEdiAccount')
 117           ->search( { id => $input->param('id'), } )->delete_all;
 118     }
 119
 120     # we do a default dispaly after deletes and saves
 121     # as well as when thats all you want
 122     $template->param( display => 1 );
 123     my @ediaccounts = $schema->resultset('VendorEdiAccount')->search(
 124         {},
 125         {
 126             join => 'vendor',
 127         }
 128     );
 129     $template->param( ediaccounts => \@ediaccounts );
 130 }
 131
 132 output_html_with_http_headers( $input, $cookie, $template->output );
 133
 134 sub get_account {
 135     my $id = shift;
 136
 137     my $account = $schema->resultset('VendorEdiAccount')->find($id);
 138     if ($account) {
 139         return $account;
 140     }
 141
 142     # passing undef will default to add
 143     return;
 144 }
 145
 146 sub show_account {
 147     my $acct_id = $input->param('id');
 148     if ($acct_id) {
 149         my $acct = $schema->resultset('VendorEdiAccount')->find($acct_id);
 150         if ($acct) {
 151             $template->param( account => $acct );
 152         }
 153     }
 154     return;
 155 }