|
- #!/usr/bin/perl
-
- #script to do a borrower enquiery/brin up borrower details etc
- #written 20/12/99 by chris@katipo.co.nz
- #Displays all the detailas about a borrower
- #needs html removed and to use the C4::Output more, but its tricky
- #last modified 21/1/2000 by chris@katipo.co.nz
-
- use strict;
- use C4::Output;
- use CGI;
- use C4::Search;
- use Date::Manip;
- use C4::Reserves2;
- use C4::Circulation::Renewals2;
- my $input = new CGI;
- my $bornum=$input->param('bornum');
-
- my %env;
- print $input->header;
- #start the page and read in includes
- print startpage();
- print startmenu('member');
- my $data=borrdata('',$bornum);
- my @temp=split('-',$data->{'dateenrolled'});
- $data->{'dateenrolled'}="$temp[2]/$temp[1]/$temp[0]";
- @temp=split('-',$data->{'expiry'});
- $data->{'expiry'}="$temp[2]/$temp[1]/$temp[0]";
- @temp=split('-',$data->{'dateofbirth'});
- $data->{'dateofbirth'}="$temp[2]/$temp[1]/$temp[0]";
- if ($data->{'ethnicity'} eq 'maori'){
- $data->{'ethnicity'} = 'Maori';
- }
- if ($data->{'ethnicity'}eq 'european'){
- $data->{'ethnicity'} = 'European/Pakeha';
- }
- if ($data->{'ethnicity'}eq 'pi'){
- $data->{'ethnicity'} = 'Pacific Islander';
- }
- if ($data->{'ethnicity'}eq 'asian'){
- $data->{'ethnicity'} = 'Asian';
- }
- print <<printend
- <FONT SIZE=6><em>$data->{'firstname'} $data->{'surname'}</em></FONT><P>
- <p>
- <form action=/cgi-bin/koha/jmemberentry.pl method=post>
- <TABLE CELLSPACING=0 CELLPADDING=5 border=1 align=left width=270>
- <TR VALIGN=TOP>
- <td bgcolor="99cc33" background="/images/background-mem.gif"><B>MEMBERSHIP RECORD</TD></TR>
- <tr VALIGN=TOP >
- <TD>
- <p align=right><INPUT TYPE="image" name="submit" VALUE="add-child" height=42 WIDTH=120 BORDER=0 src="/images/add-child.gif">
- <input type=hidden name=type value=Add>
- <input type=hidden name=bornum value=$data->{'borrowernumber'}>
- </form>
- </P><br>
- <FONT SIZE=2 face="arial, helvetica">$data->{'title'} $data->{'othernames'} $data->{'surname'} ($data->{'firstname'}, $data->{'initials'})<p>
-
- Card Number: $data->{'cardnumber'}<BR>
- Postal Address: $data->{'streetaddress'}, $data->{'city'}<BR>
- Home Address: $data->{'physstreet'}, $data->{'streetcity'}<BR>
- Phone (Home): $data->{'phone'}<BR>
- Phone (Daytime): $data->{'phoneday'}<BR>
- Fax: $data->{'faxnumber'}<BR>
- E-mail: <a href="mailto:$data->{'emailaddress'}">$data->{'emailaddress'}</a><P>
- Membership Number: $data->{'borrowernumber'}<BR>
- Membership: $data->{'categorycode'}<BR>
- Area: $data->{'area'}<BR>
- Fee:$30/year, Paid<BR>
- Joined: $data->{'dateenrolled'}, Expires: $data->{'expiry'} <BR>
- Joining Branch: $data->{'homebranch'}<P>
- Ethnicity: $data->{'ethnicity'}, $data->{'ethnotes'}<BR>
- DoB: $data->{'dateofbirth'}<BR>
- Sex: $data->{'sex'}<P>
-
- Alternative Contact:$data->{'contactname'}<BR>
- Phone: $data->{'altphone'}<BR>
- Relationship: $data->{'altrelationship'}<BR>
- Notes: $data->{'altnotes'}<P>
- Guarantees:
- printend
- ;
- my ($count,$guarantees)=findguarantees($data->{'borrowernumber'});
- for (my $i=0;$i<$count;$i++){
- print "<A HREF=\"/cgi-bin/koha/moremember.pl?bornum=$guarantees->[$i]->{'borrowernumber'}\">$guarantees->[$i]->{'cardnumber'}</a><br>";
- }
- print <<printend
-
-
- <P>
-
- General Notes: <A HREF="popbox.html" onclick="messenger(200,250,'Form that lets you add to and delete notes.'); return false">
- $data->{'borrowernotes'}</a>
- <p align=right>
- <form action=/cgi-bin/koha/memberentry.pl method=post>
- <input type=hidden name=bornum value=$bornum>
- <INPUT TYPE="image" name="submit" VALUE="modify" height=42 WIDTH=93 BORDER=0 src="/images/modify-mem.gif">
-
- <INPUT TYPE="image" name="submit" VALUE="delete" height=42 WIDTH=93 BORDER=0 src="/images/delete-mem.gif">
- </p>
-
- </TD>
- </TR>
- </TABLE>
- </FORM>
- <img src="/images/holder.gif" width=16 height=800 align=left>
- <TABLE CELLSPACING=0 CELLPADDING=5 border=1 >
- <TR VALIGN=TOP>
- <td bgcolor="99cc33" background="/images/background-mem.gif" colspan=4><B>FINES & CHARGES</TD></TR>
- printend
- ;
- my %bor;
- $bor{'borrowernumber'}=$bornum;
- my ($numaccts,$accts,$total)=getboracctrecord('',\%bor);
- #if ($numaccts > 10){
- # $numaccts=10;
- #}
- for (my$i=0;$i<$numaccts;$i++){
- #if ($accts->[$i]{'accounttype'} ne 'Pay'){
- my $amount= $accts->[$i]{'amount'} + 0.00;
- my $amount2= $accts->[$i]{'amountoutstanding'} + 0.00;
- if ($amount2 > 0){
- print "<tr VALIGN=TOP >";
- my $item=" ";
- @temp=split('-',$accts->[$i]{'date'});
- $accts->[$i]{'date'}="$temp[2]/$temp[1]/$temp[0]";
- if ($accts->[$i]{'accounttype'} ne 'Res'){
- #get item data
- #$item=
- }
- print "<td>$accts->[$i]{'date'}</td>";
- # print "<TD>$accts->[$i]{'accounttype'}</td>";
- print "<TD>$accts->[$i]{'description'} $accts->[$i]{'title'}</td>
- <TD>$amount</td><td>$amount2</td>
- </tr>";
- }
- }
- print <<printend
-
- <tr VALIGN=TOP >
- <TD colspan=3 align=right>
- <nobr>
- <a href=/cgi-bin/koha/boraccount.pl?bornum=$bornum><img height=42 WIDTH=187 BORDER=0 src="/images/view-account.gif"></a>
- <a href=/cgi-bin/koha/pay.pl?bornum=$bornum><img height=42 WIDTH=187 BORDER=0 src="/images/pay-fines.gif"></a></nobr>
- </td>
-
- </tr>
-
-
- </table>
-
- <p>
- <form action="renewscript.pl" method=post>
- <input type=hidden name=bornum value=$bornum>
- <TABLE CELLSPACING=0 CELLPADDING=5 border=1 >
-
- <TR VALIGN=TOP>
-
- <td bgcolor="99cc33" background="/images/background-mem.gif" colspan=6><B>ITEMS CURRENTLY ON ISSUE</b></TD>
- </TR>
-
- <TR VALIGN=TOP>
- <td bgcolor="99cc33" background="/images/background-mem.gif"><B>Title</b></TD>
- <td bgcolor="99cc33" background="/images/background-mem.gif"><B>Due</b></TD>
- <td bgcolor="99cc33" background="/images/background-mem.gif"><B>Itemtype</b></TD>
- <td bgcolor="99cc33" background="/images/background-mem.gif"><B>Charge</b></TD>
- <td bgcolor="99cc33" background="/images/background-mem.gif"><B>Renew</b></TD>
- </TR>
- printend
- ;
- my ($count,$issue)=borrissues($bornum);
- my $today=ParseDate('today');
- for (my $i=0;$i<$count;$i++){
- print "<tr VALIGN=TOP >
- <TD>";
- my $datedue=ParseDate($issue->[$i]{'date_due'});
- @temp=split('-',$issue->[$i]{'date_due'});
- $issue->[$i]{'date_due'}="$temp[2]/$temp[1]/$temp[0]";
- if ($datedue < $today){
- print "<font color=red>";
- }
- print "$issue->[$i]{'title'} $issue->[$i]{'barcode'}</td>
- <TD>$issue->[$i]{'date_due'}</td>";
- #find the charge for an item
- my ($charge,$itemtype)=calc_charges(\%env,$issue->[$i]{'itemnumber'},$bornum);
- print "<TD>$itemtype</td>";
- print "<TD>$charge</td>";
-
- # if ($datedue < $today){
- # print "<td>Overdue</td>";
- # } else {
- # print "<td> </td>";
- # }
- #check item is not reserved
- my ($rescount,$reserves)=FindReserves($issue->[$i]{'biblionumber'},'');
- if ($rescount >0){
- print "<TD>On Request";
- } else {
- print "<TD>";
- }
- print "<input type=radio name=\"renew_item_$issue->[$i]{'itemnumber'}\" value=y>Y
- <input type=radio name=\"renew_item_$issue->[$i]{'itemnumber'}\" value=n>N</td>
- </tr>
- ";
-
- }
- print <<printend
-
- <tr VALIGN=TOP >
- <TD colspan=5 align=right>
- <INPUT TYPE="image" name="submit" VALUE="update" height=42 WIDTH=187 BORDER=0 src="/images/update-renewals.gif">
- </td>
- </form>
- </tr>
-
-
- </table>
-
-
- <P>
-
- <TABLE CELLSPACING=0 CELLPADDING=5 border=1 >
-
- <TR VALIGN=TOP>
-
- <td bgcolor="99cc33" background="/images/background-mem.gif" colspan=5><B>ITEMS REQUESTED</b></TD>
- </TR>
-
- <TR VALIGN=TOP>
-
- <td bgcolor="99cc33" background="/images/background-mem.gif"><B>Title</b></TD>
- <td bgcolor="99cc33" background="/images/background-mem.gif"><B>Requested</b></TD>
-
-
- <td bgcolor="99cc33" background="/images/background-mem.gif"><B>Charge</b></TD>
-
- <td bgcolor="99cc33" background="/images/background-mem.gif"><B>Remove</b></TD>
- </TR>
- <form action=/cgi-bin/koha/modrequest.pl method=post>
- <input type=hidden name=from value=borrower>
- printend
- ;
- my ($rescount,$reserves)=FindReserves('',$bornum); #From C4::Reserves2
- for (my $i=0;$i<$rescount;$i++){
- @temp=split('-',$reserves->[$i]{'reservedate'});
- $reserves->[$i]{'reservedate'}="$temp[2]/$temp[1]/$temp[0]";
- print "<tr VALIGN=TOP >
- <TD><a href=\"/cgi-bin/koha/request.pl?bib=$reserves->[$i]{'biblionumber'}\">$reserves->[$i]{'title'}</a></td>
- <TD>$reserves->[$i]{'reservedate'}</td>
- <input type=hidden name=biblio value=$reserves->[$i]{'biblionumber'}>
- <input type=hidden name=borrower value=$bornum>
- <TD></td>
- <TD><select name=\"rank-request\">
- <option value=n>No
- <option value=del>Yes
- </select>
- </tr>
- ";
- }
- print <<printend
-
- <tr VALIGN=TOP >
- <TD colspan=5 align=right>
- <INPUT TYPE="image" name="submit" VALUE="update" height=42 WIDTH=187 BORDER=0 src="/images/cancel-requests.gif"></td>
- </tr>
- </table>
- </form>
- <p align=right>
- <a href=/cgi-bin/koha/readingrec.pl?bornum=$bornum><img height=42 WIDTH=187 BORDER=0 src="/images/reading-record.gif"></a>
- </p>
- printend
- ;
-
-
- print endmenu('member');
- print endpage();
|