function ReturnBook($rowCopy, $rowLoan, $rowMember){
// Set date_returned
$irDate = $_SESSION['irDate'];
unset($_SESSION['irDate']);
if(isset($irDate) && $irDate != ""){
$t = @strtotime($irDate);
if($t!=-1){
$date_returned = date("Y-m-d G:i:s",$t);
} else {
$_SESSION['msg'] = 'ERROR issuing book.<br>' .
$rowCopy['title'] . " by " . $rowCopy['authors'] . '<br>' .
"Please enter a valid date time in the format 'YYYY-MM-DD hh:mm'.<br>".
"Or you may leave the Date/Time box blank to use the current time.<br>";
header("Location: ir2.php?mid=" . $rowMember['mid']);
exit();
}
} else {
$date_returned = date("Y-m-d G:i:s");
}
$rowLoan['date_returned'] = $date_returned;
// Update loan table
$fineDetails = CalcFine($rowCopy, $rowLoan, $rowMember);
$rowLoan['fine'] = $fineDetails[0];
$rowLoan['date_returned'] = $date_returned;
$sql = sprintf("UPDATE loan SET returned=1, date_returned = '%s', fine=%d WHERE lid=%d",
$date_returned, $fine,$rowLoan['lid']);
$a = executeSqlNonQuery($sql);
$rowsUpdated = $a['rows'];
if($rowsUpdated != 1){
$_SESSION['msg'] = "An error occured while returning book.";
$_SESSION['msgIcon'] = 'ERROR';
header("Location: ir2.php?mid=" . $rowMember['mid']);
exit();
}
$des = '[' . $rowCopy['access_no'] . ']' . $rowCopy['title'] . ' <== ' . '[' . $rowMember['title'] . ' ' . $rowMember['firstnames'] . ' ' . $rowMember['surname'] . ']';
logEvent('RETURN', $_SESSION['CurrentUser']['mid'], $rowMember['mid'], addslashes($des));
include('../classes/Reservations.php');
$re = new Reservations;
if ($re->IsReserved($rowCopy['bid'])){
$reservationsMsg = $re->updateReservations($rowCopy);
}
// Display Returned Books info
if(!isset($_SESSION['Returned'])){
$_SESSION['Returned'][0] = 0;
$_SESSION['TotalFine'] = 0;
}
$_SESSION['Returned'][0] += 1;
$n = $_SESSION['Returned'][0];
$_SESSION['Returned'][$n]['copy'] = $rowCopy;
$_SESSION['Returned'][$n]['member'] = $rowMember;
$_SESSION['Returned'][$n]['loan'] = $rowLoan;
$_SESSION['Returned'][$n]['msg'] = $fineDetails[1];
if(!isset($_SESSION['TotalFine'])) $_SESSION['TotalFine']=0;
$_SESSION['TotalFine'] = (int)$_SESSION['TotalFine'] + $fineDetails[0];
$_SESSION['msg'] = $_SESSION['msg'] . "Book Returned<br>".
$rowCopy['title'] . " by " . $rowCopy['authors'] . '<br>';
$_SESSION['msgIcon'] = 'INFO';
if(isset($reservationsMsg)) $_SESSION['msg'] = $_SESSION['msg'] .
"<div class='reservationsMsg'>" . $reservationsMsg . '</div>';
header("Location: ir2.php?mid=" . $rowMember['mid']);
exit();
}
