コード例 #1
0
    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();
コード例 #2
0
ファイル: loan_list.php プロジェクト: slims/slims8_akasia
     $extend_link = '<span class="noExtendLink" title="' . __('No Extend') . '">&nbsp;</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') . '">&nbsp;</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">&nbsp;</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%;'");