| Barcode |
Title |
Author |
Date Borrowed |
Due Date |
Penalty |
Action |
$due_date) {
$penalty = round((float)(strtotime($date_returned) - strtotime($due_date)) / (60 * 60 *24) * ($penalty_amount['penalty_amount']));
} elseif ($date_returned < $due_date) {
$penalty = 'No Penalty';
} else {
$penalty = 'No Penalty';
}
?>
|
|
|
|
".date('M d, Y h:m:s a',strtotime($borrow_row['due_date']))."";
} else {
echo "".'Hardbound Book, Inside Only'." | ";
}
?>
".$penalty."";
} else {
echo "".'Hardbound Book, Inside Only'." | ";
}
?>
|
| No books borrowed |
';
}
?>
$due_date) {
$penalty = round((float)(strtotime($date_returned) - strtotime($due_date)) / (60 * 60 *24) * ($penalty_amount['penalty_amount']));
} elseif ($date_returned < $due_date) {
$penalty = 'No Penalty';
} else {
$penalty = 'No Penalty';
}
mysqli_query ($conn,"UPDATE borrow_book SET borrowed_status = 'returned', date_returned = '$date_returned_now', book_penalty = '$penalty' WHERE borrow_book_id= '$borrow_book_id' and user_id = '$user_id' and book_id = '$book_id' ") or die (mysqli_error());
mysqli_query ($conn,"INSERT INTO return_book (user_id, book_id, date_borrowed, due_date, date_returned, book_penalty)
values ('$user_id', '$book_id', '$date_borrowed', '$due_date', '$date_returned', '$penalty')") or die (mysqli_error());
$report_history1=mysqli_query($conn,"select * from admin where admin_id = $id_session ") or die (mysqli_error());
$report_history_row1=mysqli_fetch_array($report_history1);
$admin_row1=$report_history_row1['firstname']." ".$report_history_row1['middlename']." ".$report_history_row1['lastname'];
mysqli_query($conn,"INSERT INTO report
(book_id, user_id, admin_name, detail_action, date_transaction)
VALUES ('$book_id','$user_id','$admin_row1','Returned Book',NOW())") or die(mysqli_error());
?>
';
} elseif ($barcode == '') {
echo '
| Enter the correct details! |
';
}else{
?>
|
|
|
|
|
|
|
alert(' ".$allowed['qntty_books']." ".'Books Allowed per User!'." '); window.location='borrow_book.php?member_id=".$school_number."'";
}elseif ($bookCount['book_count'] == 1){
echo "";
}else{
$update_copies = mysqli_query ($conn,"SELECT * from book where book_id = '$book_id' ") or die (mysqli_error());
$copies_row= mysqli_fetch_assoc($update_copies);
$book_copies = $copies_row['book_copies'];
$new_book_copies = $book_copies - 1;
if ($new_book_copies < 0){
echo "";
}elseif ($copies_row['status'] == 'Damaged'){
echo "";
}elseif ($copies_row['status'] == 'Lost'){
echo "";
}else{
if ($new_book_copies == '0') {
$remark = 'Not Available';
} else {
$remark = 'Available';
}
mysqli_query($conn,"UPDATE book SET book_copies = '$new_book_copies' where book_id = '$book_id' ") or die (mysqli_error());
mysqli_query($conn,"UPDATE book SET remarks = '$remark' where book_id = '$book_id' ") or die (mysql_error());
mysqli_query($conn,"INSERT INTO borrow_book(user_id,book_id,date_borrowed,due_date,borrowed_status)
VALUES('$user_id','$book_id','$date_borrowed','$due_date','borrowed')") or die (mysqli_error());
$report_history=mysqli_query($conn,"select * from admin where admin_id = $id_session ") or die (mysqli_error());
$report_history_row=mysqli_fetch_array($report_history);
$admin_row=$report_history_row['firstname']." ".$report_history_row['middlename']." ".$report_history_row['lastname'];
mysqli_query($conn,"INSERT INTO report
(book_id, user_id, admin_name, detail_action, date_transaction)
VALUES ('$book_id','$user_id','$admin_row','Borrowed Book',NOW())") or die(mysqli_error());
}
}
?>