members/guarantor_search.pl

   1 #!/usr/bin/perl
   2
   3
   4 # script to find a guarantor
   5
   6 # Copyright 2006 OUEST PROVENCE
   7 #
   8 # This file is part of Koha.
   9 #
  10 # Koha is free software; you can redistribute it and/or modify it under the
  11 # terms of the GNU General Public License as published by the Free Software
  12 # Foundation; either version 2 of the License, or (at your option) any later
  13 # version.
  14 #
  15 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
  16 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
  17 # A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
  18 #
  19 # You should have received a copy of the GNU General Public License along
  20 # with Koha; if not, write to the Free Software Foundation, Inc.,
  21 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
  22
  23 use strict;
  24 #use warnings; FIXME - Bug 2505
  25 use C4::Auth;
  26 use C4::Output;
  27 use CGI;
  28 use C4::Dates qw/format_date/;
  29 use C4::Members;
  30
  31 my $input = new CGI;
  32 my ($template, $loggedinuser, $cookie);
  33
  34         ($template, $loggedinuser, $cookie)
  35     = get_template_and_user({template_name => "members/guarantor_search.tmpl",
  36                              query => $input,
  37                              type => "intranet",
  38                              authnotrequired => 0,
  39                              flagsrequired => {borrowers => 1},
  40                              debug => 1,
  41                              });
  42 # }
  43 my $theme = $input->param('theme') || "default";
  44                         # only used if allowthemeoverride is set
  45
  46
  47 my $member=$input->param('member');
  48 my $orderby=$input->param('orderby');
  49 my $category_type=$input->param('category_type');
  50 $orderby = "surname,firstname" unless $orderby;
  51 $member =~ s/,//g;   #remove any commas from search string
  52 $member =~ s/\*/%/g;
  53 if ($member eq ''){
  54                 $template->param(results=>0);
  55 }else{
  56                 $template->param(results=>1);
  57 }
  58
  59 my $search_category = 'A';
  60 if ($category_type eq 'P'){
  61         $search_category = 'I';
  62 }
  63
  64 my ($count,$results);
  65 my @resultsdata;
  66 my $background = 0;
  67
  68 if ($member ne ''){
  69         if(length($member) == 1)
  70         {
  71                 ($count,$results)=SearchMember($member,$orderby,"simple",$search_category);
  72         }
  73         else
  74         {
  75                 ($count,$results)=SearchMember($member,$orderby,"advanced",$search_category);
  76         }
  77         for (my $i=0; $i < $count; $i++){
  78         #find out stats
  79         my ($od,$issue,$fines)=GetMemberIssuesAndFines($results->[$i]{'borrowerid'});
  80         my $guarantorinfo=uc($results->[$i]{'surname'})." , ".ucfirst($results->[$i]{'firstname'});
  81         my %row = (
  82                 background => $background,
  83                 count => $i+1,
  84                 borrowernumber => $results->[$i]{'borrowernumber'},
  85                 cardnumber => $results->[$i]{'cardnumber'},
  86                 surname => $results->[$i]{'surname'},
  87                 firstname => $results->[$i]{'firstname'},
  88                 categorycode => $results->[$i]{'categorycode'},
  89                 streetnumber => $results->[$i]{'streetnumber'},
  90                 address => $results->[$i]{'address'},
  91                 address2 => $results->[$i]{'address2'},
  92                 city => $results->[$i]{'city'},
  93                 state => $results->[$i]{'state'},
  94                 zipcode => $results->[$i]{'zipcode'},
  95                 country => $results->[$i]{'country'},
  96                 branchcode => $results->[$i]{'branchcode'},
  97                 guarantorinfo =>$guarantorinfo,
  98                 #op
  99                 dateofbirth =>format_date($results->[$i]{'dateofbirth'}),
 100                 #fi op
 101
 102                 odissue => "$od/$issue",
 103                 fines => $fines,
 104                 borrowernotes => $results->[$i]{'borrowernotes'});
 105         if ( $background ) { $background = 0; } else {$background = 1; }
 106         push(@resultsdata, \%row);
 107                 }
 108 }
 109 $template->param(
 110                         member          => $member,
 111                         numresults              => $count,
 112                         category_type   => $category_type,
 113                         resultsloop     => \@resultsdata );
 114
 115 output_html_with_http_headers $input, $cookie, $template->output;