} 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(); $member = $reserve_d[1] . ' (' . $reserve_d[0] . ')'; $reserve_msg = str_replace(array('{itemCode}', '{member}'), array($loan_d['item_code'], $member), __('Item {itemCode} is being reserved by member {member}')); //mfc $loan_d['title'] .= '<div>' . $reserve_msg . '</div>'; } // write log utility::writeLogs($dbs, 'member', $loan_d['member_id'], 'circulation', $_SESSION['realname'] . ' return item (' . $_POST['quickReturnID'] . ') with title (' . $loan_d['title'] . ') with Quick Return method'); // show loan information