exit; } // quick return proccess if (isset($_POST['quickReturnID']) and $_POST['quickReturnID']) { // get loan data $loan_info_q = $dbs->query("SELECT l.*,m.member_id,m.member_name,b.title FROM loan AS l\n LEFT JOIN item AS i ON i.item_code=l.item_code\n LEFT JOIN biblio AS b ON i.biblio_id=b.biblio_id\n LEFT JOIN member AS m ON l.member_id=m.member_id\n WHERE l.item_code='" . $dbs->escape_string($_POST['quickReturnID']) . "' AND is_lent=1 AND is_return=0"); if ($loan_info_q->num_rows < 1) { echo '<div class="errorBox">' . __('This is item already returned or not exists in loan database') . '</div>'; } else { $return_date = date('Y-m-d'); // get data $loan_d = $loan_info_q->fetch_assoc(); // create circulation object $circulation = new circulation($dbs, $loan_d['member_id']); // check for overdue $overdue = $circulation->countOverdueValue($loan_d['loan_id'], $return_date); // check overdue if ($overdue) { $msg = str_replace('{overdueDays}', $overdue['days'], __('OVERDUED for {overdueDays} days(s) with fines value of')); //mfc $loan_d['title'] .= '<div style="color: red; font-weight: bold;">' . $msg . $overdue['value'] . '</div>'; } // return item $return_status = $circulation->returnItem($loan_d['loan_id']); if ($return_status === ITEM_RESERVED) { // get reservation data $reserve_q = $dbs->query('SELECT r.member_id, m.member_name FROM reserve AS r LEFT JOIN member AS m ON r.member_id=m.member_id WHERE item_code=\'' . $loan_d['item_code'] . '\' ORDER BY reserve_date DESC'); $reserve_d = $reserve_q->fetch_row();
$extend_link = '<span class="noExtendLink" title="' . __('No Extend') . '"> </span>'; } else { // check if this loan just already renewed if ($loan_list_data['return_date'] == date('Y-m-d') || in_array($loan_list_data['loan_id'], $_SESSION['reborrowed']) || $loan_list_data['extend'] == 1) { $extend_link = '<span class="noExtendLink" title="' . __('No Extend') . '"> </span>'; } else { $extend_link = '<a href="#" onclick="confirmProcess(' . $loan_list_data['loan_id'] . ', \'' . $loan_list_data['item_code'] . '\', \'extend\')" title="' . __('Extend loan for this item') . '" class="extendLink"> </a>'; } } // renewed flag if ($loan_list_data['renewed'] > 0) { $loan_list_data['title'] = $loan_list_data['title'] . ' - <strong style="color: blue;">' . __('Extended') . '</strong>'; } // check for overdue $curr_date = date('Y-m-d'); $overdue = $circulation->countOverdueValue($loan_list_data['loan_id'], $curr_date); if ($overdue) { $is_overdue = true; $loan_list_data['title'] .= '<div style="color: red; font-weight: bold;">' . __('OVERDUED for') . ' ' . $overdue['days'] . ' ' . __('days(s) with fines value') . ' ' . $overdue['value'] . '</div>'; //mfc $_total_temp_fines = $_total_temp_fines + $overdue['value']; #newly added } // row colums array $fields = array($return_link, $extend_link, $loan_list_data['item_code'], $loan_list_data['title'], $loan_list_data['coll_type_name'], $loan_list_data['loan_date'], $loan_list_data['due_date']); // append data to table row $loan_list->appendTableRow($fields); // set the HTML attributes $loan_list->setCellAttr($row, null, "valign='top' class='{$row_class}'"); $loan_list->setCellAttr($row, 0, "valign='top' align='center' class='{$row_class}' style='width: 5%;'"); $loan_list->setCellAttr($row, 1, "valign='top' align='center' class='{$row_class}' style='width: 5%;'");