1 package C4::Circulation::Main; #asummes C4/Circulation/Main
3 #package to deal with circulation
9 use C4::Circulation::Issues;
10 use C4::Circulation::Returns;
11 use C4::Circulation::Renewals;
12 use C4::Circulation::Borrower;
19 use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
21 # set the version for version checking
25 @EXPORT = qw(&pastitems &checkoverdues &previousissue
26 &checkreserve &checkwaiting &scanbook &scanborrower &getbranch &getprinter);
27 %EXPORT_TAGS = ( ); # eg: TAG => [ qw!name1 name2! ],
29 # your exported package globals go here,
30 # as well as any optionally exported functions
32 @EXPORT_OK = qw($Var1 %Hashit);
35 # non-exported package globals go here
36 use vars qw(@more $stuff);
38 # initalize package globals, first exported ones
43 # then the others (which are still accessible as $Some::Module::stuff)
47 # all file-scoped lexicals must be created before
48 # the functions below that use them.
50 # file-private lexicals go here
54 # here's a file-private function as a closure,
55 # callable as &$priv_func; it cannot be prototyped.
60 # make all your functions, whether exported or not;
65 my $query = "select * from branches order by branchcode";
66 my $sth = $dbh->prepare($query);
70 while (my $data = $sth->fetchrow_hashref) {
73 brmenu ($env,\@branches);
75 my $data = $sth->fetchrow_hashref;
76 $env->{'branchcode'}=$data->{'branchcode'};
78 my $query = "select * from branches
79 where branchcode = '$env->{'branchcode'}'";
80 $sth = $dbh->prepare($query);
82 my $data = $sth->fetchrow_hashref;
83 $env->{'brdata'} = $data;
84 $env->{'branchname'} = $data->{'branchname'};
92 my $query = "select * from printers order by printername";
93 my $sth = $dbh->prepare($query);
97 while (my $data = $sth->fetchrow_hashref) {
100 prmenu ($env,\@printers);
102 my $data=$sth->fetchrow_hashref;
103 $env->{'queue'}=$data->{'printqueue'};
104 $env->{'printtype'}=$data->{'printtype'};
111 #Get list of all items borrower has currently on issue
112 my ($env,$bornum,$dbh)=@_;
113 my $query1 = "select * from issues where (borrowernumber=$bornum)
114 and (returndate is null) order by date_due";
115 my $sth=$dbh->prepare($query1);
120 while (my $data1=$sth->fetchrow_hashref) {
121 my $data = itemnodata($env,$dbh,$data1->{'itemnumber'}); #C4::Search
122 my @date = split("-",$data1->{'date_due'});
123 my $odate = (@date[2]+0)."-".(@date[1]+0)."-".@date[0];
124 my $line = C4::Circulation::Issues::formatitem($env,$data,$odate,"");
129 return(\@items,\@items2);
133 #checks whether a borrower has overdue items
134 my ($env,$bornum,$dbh)=@_;
135 my @datearr = localtime;
136 my $today = ($datearr[5] + 1900)."-".($datearr[4]+1)."-".$datearr[3];
137 my $query = "Select count(*) from issues where borrowernumber=$bornum and
138 returndate is NULL and date_due < '$today'";
139 my $sth=$dbh->prepare($query);
141 my $data = $sth->fetchrow_hashref;
143 return $data->{'count(*)'};
147 my ($env,$itemnum,$dbh,$bornum)=@_;
148 my $sth=$dbh->prepare("Select
149 firstname,surname,issues.borrowernumber,cardnumber,returndate
150 from issues,borrowers where
151 issues.itemnumber='$itemnum' and
152 issues.borrowernumber=borrowers.borrowernumber
153 and issues.returndate is NULL");
155 my $borrower=$sth->fetchrow_hashref;
159 if ($borrower->{'borrowernumber'} ne ''){
160 if ($bornum eq $borrower->{'borrowernumber'}){
162 my ($renewstatus) = C4::Circulation::Renewals::renewstatus($env,$dbh,$bornum,$itemnum);
163 my ($resbor,$resrec) = checkreserve($env,$dbh,$itemnum);
164 if ($renewstatus == "0") {
165 info_msg($env,"</S>Issued to this borrower - No renewals<!S>");
167 } elsif ($resbor ne "") {
168 my $resp = C4::InterfaceCDK::msg_ny($env,"Book is issued to this borrower",
169 "and is reserved - Renew?");
171 $newdate = C4::Circulation::Renewals::renewbook($env,$dbh,$bornum,$itemnum);
177 my $resp = C4::InterfaceCDK::msg_yn($env,"Book is issued to this borrower", "Renew?");
179 $newdate = C4::Circulation::Renewals::renewbook($env,$dbh,$bornum,$itemnum);
186 my $text="Issued to $borrower->{'firstname'} $borrower->{'surname'} ($borrower->{'cardnumber'})";
187 my $resp = C4::InterfaceCDK::msg_yn($env,$text,"Mark as returned?");
189 &returnrecord($env,$dbh,$borrower->{'borrowernumber'},$itemnum);
195 return($borrower->{'borrowernumber'},$canissue,$newdate);
200 # Check for reserves for biblio
201 my ($env,$dbh,$itemnum)=@_;
203 my $query = "select * from reserves,items
204 where (items.itemnumber = '$itemnum')
205 and (reserves.cancellationdate is NULL)
206 and (items.biblionumber = reserves.biblionumber)
207 and ((reserves.found = 'W')
208 or (reserves.found is null))
210 my $sth = $dbh->prepare($query);
213 if (my $data=$sth->fetchrow_hashref) {
215 my $const = $data->{'constrainttype'};
217 $resbor = $data->{'borrowernumber'};
220 my $cquery = "select * from reserveconstraints,items
221 where (borrowernumber='$data->{'borrowernumber'}')
222 and reservedate='$data->{'reservedate'}'
223 and reserveconstraints.biblionumber='$data->{'biblionumber'}'
224 and (items.itemnumber=$itemnum and
225 items.biblioitemnumber = reserveconstraints.biblioitemnumber)";
226 my $csth = $dbh->prepare($cquery);
228 if (my $cdata=$csth->fetchrow_hashref) {$found = 1;}
230 if ($found eq 1) {$resbor = $data->{'borrowernumber'};}
232 if ($found eq 0) {$resbor = $data->{'borrowernumber'};}
238 return ($resbor,$resrec);
242 # check for reserves waiting
243 my ($env,$dbh,$bornum)=@_;
245 my $query = "select * from reserves
246 where (borrowernumber = '$bornum')
247 and (reserves.found='W') and cancellationdate is NULL";
248 my $sth = $dbh->prepare($query);
251 if (my $data=$sth->fetchrow_hashref) {
252 @itemswaiting[$cnt] =$data;
256 return ($cnt,\@itemswaiting);
260 my ($env,$interface)=@_;
262 my ($number,$reason)=dialog("Book Barcode:");
264 return ($number,$reason);
268 my ($env,$interface)=@_;
270 my ($number,$reason,$book)=C4::InterfaceCDK::borrower_dialog($env); #C4::InterfaceCDK
273 return ($number,$reason,$book);
277 END { } # module clean-up code here (global destructor)