function showLoanHist($num_recs_show = 1000000) { global $dbs; require SIMBIO . 'simbio_GUI/table/simbio_table.inc.php'; require SIMBIO . 'simbio_DB/datagrid/simbio_dbgrid.inc.php'; require SIMBIO . 'simbio_GUI/paging/simbio_paging.inc.php'; require SIMBIO . 'simbio_UTILS/simbio_date.inc.php'; // table spec $_table_spec = 'loan AS l LEFT JOIN member AS m ON l.member_id=m.member_id LEFT JOIN item AS i ON l.item_code=i.item_code LEFT JOIN biblio AS b ON i.biblio_id=b.biblio_id'; // create datagrid $_loan_hist = new simbio_datagrid(); $_loan_hist->disable_paging = true; $_loan_hist->table_ID = 'loanhist'; $_loan_hist->setSQLColumn('l.item_code AS \'' . __('Item Code') . '\'', 'b.title AS \'' . __('Title') . '\'', 'l.loan_date AS \'' . __('Loan Date') . '\'', 'l.return_date AS \'' . __('Return Date') . '\''); $_loan_hist->setSQLorder('l.loan_date DESC'); $_criteria = sprintf('m.member_id=\'%s\' AND l.is_lent=1 AND is_return=1 ', $_SESSION['mid']); $_loan_hist->setSQLCriteria($_criteria); /* callback function to show overdue */ function showOverdue($obj_db, $array_data) { $_curr_date = date('Y-m-d'); if (simbio_date::compareDates($array_data[3], $_curr_date) == $_curr_date) { #return '<strong style="color: #f00;">'.$array_data[3].' '.__('OVERDUED').'</strong>'; } else { return $array_data[3]; } } // modify column value #$_loan_hist->modifyColumnContent(3, 'callback{showOverdue}'); // set table and table header attributes $_loan_hist->table_attr = 'align="center" class="memberLoanList" cellpadding="5" cellspacing="0"'; $_loan_hist->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; $_loan_hist->using_AJAX = false; // return the result $_result = $_loan_hist->createDataGrid($dbs, $_table_spec, $num_recs_show); $_result = '<div class="memberLoanHistInfo">' . $_loan_hist->num_rows . ' ' . __('item(s) loan history') . '</div>' . "\n" . $_result; return $_result; }
//mfc } // print out the form object echo $form->printOut(); } else { /* MODULE LIST */ // table spec $table_spec = 'mst_module AS mdl'; // create datagrid $datagrid = new simbio_datagrid(); $datagrid->setSQLColumn('mdl.module_id', 'mdl.module_name AS \'' . __('Module Name') . '\'', 'mdl.module_desc AS \'' . __('Module Description') . '\''); $datagrid->setSQLorder('module_name ASC'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keywords = $dbs->escape_string($_GET['keywords']); $datagrid->setSQLCriteria("mdl.module_name LIKE '%{$keywords}%'"); } // set table and table header attributes $datagrid->icon_edit = $sysconf['admin_template']['dir'] . '/' . $sysconf['admin_template']['theme'] . '/edit.gif'; $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF']; // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, true); if (isset($_GET['keywords']) and $_GET['keywords']) { $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords')); //mfc echo '<div class="infoBox">' . $msg . ' : "' . $_GET['keywords'] . '"</div>'; } echo $datagrid_result;
/* PUBLISHER LIST */ // table spec $table_spec = 'mst_publisher AS p'; // create datagrid $datagrid = new simbio_datagrid(); if ($can_read and $can_write) { $datagrid->setSQLColumn('p.publisher_id', 'p.publisher_name AS \'' . __('Publisher Name') . '\'', 'p.last_update AS \'' . __('Last Update') . '\''); } else { // TODO: publisher_place was dropped in stable7...? $datagrid->setSQLColumn('p.publisher_name AS \'' . __('Publisher Name') . '\'', 'p.publisher_place AS \'' . lang_mod_masterfile_publisher_form_field_place . '\'', 'p.last_update AS \'' . __('Last Update') . '\''); } $datagrid->setSQLorder('publisher_name ASC'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keywords = $dbs->escape_string($_GET['keywords']); $datagrid->setSQLCriteria("p.publisher_name LIKE '%{$keywords}%'"); } // set table and table header attributes $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF']; // put the result into variable $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, $can_read and $can_write); if (isset($_GET['keywords']) and $_GET['keywords']) { echo '<table cellpadding="3" cellspacing="0" class="infoBox">'; $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords')); //mfc echo '<tr><th>' . $msg . ' : "' . $_GET['keywords'] . '"</th></tr>'; echo '</table>'; }
if ($can_read and $can_write) { $datagrid->setSQLColumn('m.member_id', 'm.member_id AS \'' . __('Member ID') . '\'', 'm.member_name AS \'' . __('Member Name') . '\'', 'mt.member_type_name AS \'' . __('Membership Type') . '\'', 'm.member_email AS \'' . __('E-mail') . '\'', 'm.last_update AS \'' . __('Last Updated') . '\''); } else { $datagrid->setSQLColumn('m.member_id AS \'' . __('Member ID') . '\'', 'm.member_name AS \'' . __('Member Name') . '\'', 'mt.member_type_name AS \'' . __('Membership Type') . '\'', 'm.member_email AS \'' . __('E-mail') . '\'', 'm.last_update AS \'' . __('Last Updated') . '\''); } $datagrid->setSQLorder('member_name ASC'); // is there any search $criteria = 'm.member_id IS NOT NULL '; if (isset($_GET['keywords']) and $_GET['keywords']) { $keywords = $dbs->escape_string($_GET['keywords']); $criteria .= " AND (m.member_name LIKE '%{$keywords}%' OR m.member_id LIKE '%{$keywords}%') "; } if (isset($_GET['expire'])) { $criteria .= " AND TO_DAYS('" . date('Y-m-d') . "')>TO_DAYS(m.expire_date)"; } $datagrid->setSQLCriteria($criteria); // set table and table header attributes $datagrid->icon_edit = SENAYAN_WEB_ROOT_DIR . 'admin/' . $sysconf['admin_template']['dir'] . '/' . $sysconf['admin_template']['theme'] . '/edit.gif'; $datagrid->table_name = 'memberList'; $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF']; // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, $can_read and $can_write); if (isset($_GET['keywords']) and $_GET['keywords'] or isset($_GET['expire'])) { echo '<div class="infoBox">'; if (isset($_GET['expire'])) { echo '<b style="color: #FF0000;">' . __('Expired Member List') . '</b><hr size="1" />'; echo '<div><input type="button" value="' . __('Extend Selected Member(s)') . '" onclick="javascript: if (confirm(\'' . __('Are you sure to EXTEND membership for selected members?') . '\')) { setContent(\'mainContent\', \'' . MODULES_WEB_ROOT_DIR . 'membership/index.php?expire=1\', \'post\', $H($(\'memberList\').serialize(true)).update({ batchExtend: \'true\' }) ); }" class="button" /></div>'; if (isset($_GET['numExtended']) and $_GET['numExtended'] > 0) {
" /> </form> </div> </div> </fieldset> <?php /* BACKUP LOG LIST */ // table spec $table_spec = 'backup_log AS bl LEFT JOIN user AS u ON bl.user_id=u.user_id'; // create datagrid $datagrid = new simbio_datagrid(); $datagrid->setSQLColumn('u.realname AS \'Backup Executor\'', 'bl.backup_time AS \'Backup Time\'', 'bl.backup_file AS \'Backup File Location\''); $datagrid->setSQLorder('backup_time DESC'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keywords = $dbs->escape_string($_GET['keywords']); $datagrid->setSQLCriteria("bl.backup_time LIKE '%{$keywords}%' OR bl.backup_file LIKE '%{$keywords}%'"); } // set table and table header attributes $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->delete_URL = $_SERVER['PHP_SELF']; // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, false); if (isset($_GET['keywords']) and $_GET['keywords']) { $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords')); //mfc echo '<div class="infoBox">' . $msg . ' : "' . $_GET['keywords'] . '"</div>'; } echo $datagrid_result;
} else { /* DOCUMENT LANGUAGE LIST */ // table spec $table_spec = 'mst_language AS l'; // create datagrid $datagrid = new simbio_datagrid(); if ($can_read and $can_write) { $datagrid->setSQLColumn('l.language_id', 'l.language_name AS \'' . __('Language') . '\'', 'l.last_update AS \'' . __('Last Update') . '\''); } else { $datagrid->setSQLColumn('l.language_name AS \'' . __('Language') . '\'', 'l.last_update AS \'' . __('Last Update') . '\''); } $datagrid->setSQLorder('language_name ASC'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keywords = $dbs->escape_string($_GET['keywords']); $datagrid->setSQLCriteria("l.language_name LIKE '%{$keywords}%'"); } // set table and table header attributes $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF']; // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, $can_read and $can_write); if (isset($_GET['keywords']) and $_GET['keywords']) { $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords')); //mfc echo '<div class="infoBox">' . $msg . ' : "' . $_GET['keywords'] . '"</div>'; } echo $datagrid_result; }
$table_spec = 'mst_loan_rules AS lr LEFT JOIN mst_member_type AS mt ON lr.member_type_id=mt.member_type_id LEFT JOIN mst_coll_type AS ct ON lr.coll_type_id=ct.coll_type_id LEFT JOIN mst_gmd AS g ON lr.gmd_id=g.gmd_id'; // create datagrid $datagrid = new simbio_datagrid(); if ($can_read and $can_write) { $datagrid->setSQLColumn('lr.loan_rules_id', 'mt.member_type_name AS \'' . __('Member Type') . '\'', 'ct.coll_type_name AS \'' . __('Collection Type') . '\'', 'g.gmd_name AS \'' . __('GMD') . '\'', 'lr.loan_limit AS \'' . __('Loan Limit') . '\'', 'lr.loan_periode AS \'' . __('Loan Period') . '\'', 'lr.last_update AS \'' . __('Last Update') . '\''); } else { $datagrid->setSQLColumn('mt.member_type_name AS \'' . __('Member Type') . '\'', 'ct.coll_type_name AS \'' . __('Collection Type') . '\'', 'g.gmd_name AS \'' . __('GMD') . '\'', 'lr.loan_limit AS \'' . __('Loan Limit') . '\'', 'lr.loan_periode AS \'' . __('Loan Period') . '\'', 'lr.last_update AS \'' . __('Last Update') . '\''); } $datagrid->setSQLorder('mt.member_type_name ASC'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keywords = $dbs->escape_string($_GET['keywords']); $datagrid->setSQLCriteria("mt.member_type_name LIKE '%{$keywords}%'"); } // set table and table header attributes $datagrid->icon_edit = $sysconf['admin_template']['dir'] . '/' . $sysconf['admin_template']['theme'] . '/edit.gif'; $datagrid->table_attr = 'align="center" class="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF']; // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, $can_read and $can_write); if (isset($_GET['keywords']) and $_GET['keywords']) { $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords')); //mfc echo '<div class="infoBox">' . $msg . ' : "' . $_GET['keywords'] . '"</div>'; } echo $datagrid_result;
$datagrid->setSQLColumn('st.stock_take_id', 'st.stock_take_name AS \'' . __('Stock Take Name') . '\'', 'st.start_date AS \'' . __('Start Date') . '\'', 'st.end_date AS \'' . __('End Date') . '\'', 'CONCAT(\'<a class="notAJAX" href="' . SENAYAN_WEB_ROOT_DIR . FILES_DIR . '/' . REPORT_DIR . '/\', st.report_file, \'" target="_blank">\', st.report_file, \'</a>\') AS \'' . __('Report') . '\''); $datagrid->setSQLorder('st.start_date DESC'); $datagrid->disableSort('Report'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keyword = $dbs->escape_string(trim($_GET['keywords'])); $words = explode(' ', $keyword); if (count($words) > 1) { $concat_sql = ' ('; foreach ($words as $word) { $concat_sql .= " (stock_take_name LIKE '%{$word}%' OR init_user LIKE '%{$word}%') AND"; } // remove the last AND $concat_sql = substr_replace($concat_sql, '', -3); $concat_sql .= ') '; $datagrid->setSQLCriteria($concat_sql); } else { $datagrid->setSQLCriteria("stock_take_name LIKE '%{$keyword}%' OR init_user LIKE '%{$keyword}%'"); } } // set table and table header attributes $datagrid->icon_edit = $sysconf['admin_template']['dir'] . '/' . $sysconf['admin_template']['theme'] . '/edit.gif'; $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; $datagrid->chbox_property = false; // set delete proccess URL $datagrid->delete_URL = $_SERVER['PHP_SELF']; // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, true); if (isset($_GET['keywords']) and $_GET['keywords']) { $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords'));
$datagrid->setSQLorder("'" . urldecode($_GET['fld']) . "' " . $dbs->escape_string($_GET['dir'])); } $checkout_criteria = ' (l.is_lent=1 AND l.is_return=0) '; // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keyword = $dbs->escape_string(trim($_GET['keywords'])); $words = explode(' ', $keyword); if (count($words) > 1) { $concat_sql = ' ('; foreach ($words as $word) { $concat_sql .= " (b.title LIKE '%{$word}%' OR i.item_code LIKE '%{$word}%') AND"; } // remove the last AND $concat_sql = substr_replace($concat_sql, '', -3); $concat_sql .= ') '; $datagrid->setSQLCriteria($checkout_criteria . ' AND ' . $concat_sql); } else { $datagrid->setSQLCriteria($checkout_criteria . " AND (b.title LIKE '%{$keyword}%' OR i.item_code LIKE '%{$keyword}%')"); } } else { $datagrid->setSQLCriteria($checkout_criteria); } // set table and table header attributes $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set column width $datagrid->column_width = array(0 => '12%', 1 => '12%', 2 => '50%'); // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, false); if (isset($_GET['keywords']) and $_GET['keywords']) { echo '<div class="infoBox">';
// create datagrid $datagrid = new simbio_datagrid(); if ($can_read and $can_write) { $datagrid->setSQLColumn('ct.coll_type_id', 'ct.coll_type_name AS \'' . __('Collection Type') . '\'', 'ct.last_update AS \'' . __('Last Update') . '\''); } else { $datagrid->setSQLColumn('ct.coll_type_name AS \'' . __('Collection Type') . '\'', 'ct.last_update AS \'' . __('Last Update') . '\''); } $datagrid->setSQLorder('coll_type_name ASC'); // change the record order if (isset($_GET['fld']) and isset($_GET['dir'])) { $datagrid->setSQLorder("'" . urldecode($_GET['fld']) . "' " . $dbs->escape_string($_GET['dir'])); } // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keywords = $dbs->escape_string($_GET['keywords']); $datagrid->setSQLCriteria("ct.coll_type_name LIKE '%{$keywords}%'"); } // set table and table header attributes $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF']; // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, $can_read and $can_write); if (isset($_GET['keywords']) and $_GET['keywords']) { $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords')); //mfc echo '<div class="infoBox">' . $msg . ' : "' . $_GET['keywords'] . '"</div>'; } echo $datagrid_result; }
$datagrid->setSQLColumn('sl.log_date AS \'Time\'', 'sl.log_msg AS \'Message\''); $datagrid->setSQLorder("sl.log_date DESC"); $criteria = 'sl.log_location=\'stock_take\' AND sl.log_msg LIKE \'Stock Take ERROR%\' '; // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keyword = $dbs->escape_string(trim($_GET['keywords'])); $words = explode(' ', $keyword); if (count($words) > 1) { $concat_sql = ' ('; foreach ($words as $word) { $concat_sql .= " (sl.log_date LIKE '%{$word}%' OR sl.log_msg LIKE '%{$word}%') AND"; } // remove the last AND $concat_sql = substr_replace($concat_sql, '', -3); $concat_sql .= ') '; $datagrid->setSQLCriteria($criteria . ' AND ' . $concat_sql); } else { $datagrid->setSQLCriteria($criteria . " AND sl.log_date LIKE '%{$keyword}%' OR sl.log_msg LIKE '%{$keyword}%'"); } } $datagrid->setSQLCriteria($criteria); // set table and table header attributes $datagrid->icon_edit = SENAYAN_WEB_ROOT_DIR . 'admin/' . $sysconf['admin_template']['dir'] . '/' . $sysconf['admin_template']['theme'] . '/edit.gif'; $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->delete_URL = $_SERVER['PHP_SELF']; $datagrid->column_width = array('18%', '82%'); $datagrid->disableSort('Message'); // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 50, false);
} else { /* GMD LIST */ // table spec $table_spec = 'mst_' . $type . '_type AS g'; // create datagrid $datagrid = new simbio_datagrid(); if ($can_read and $can_write) { $datagrid->setSQLColumn('g.id', 'g.code AS \'' . __('Code') . '\'', 'g.' . $type . '_type AS \'' . __('Name') . '\'', 'g.last_update AS \'' . __('Last Update') . '\''); } else { $datagrid->setSQLColumn('g.code AS \'' . __('Code') . '\'', 'g.' . $type . '_type AS \'' . __('Name') . '\'', 'g.last_update AS \'' . __('Last Update') . '\''); } $datagrid->setSQLorder($type . '_type ASC'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keywords = $dbs->escape_string($_GET['keywords']); $datagrid->setSQLCriteria("g." . $type . "_type LIKE '%{$keywords}%' OR g.code LIKE '%{$keywords}%'"); } // set table and table header attributes $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF'] . '?type=' . $type; // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, $can_read and $can_write); if (isset($_GET['keywords']) and $_GET['keywords']) { $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords')); //mfc echo '<div class="infoBox">' . $msg . ' : "' . $_GET['keywords'] . '"</div>'; } echo $datagrid_result; }
function showLoanList($num_recs_show = 20) { global $dbs; require SIMBIO_BASE_DIR . 'simbio_GUI/table/simbio_table.inc.php'; require SIMBIO_BASE_DIR . 'simbio_DB/datagrid/simbio_dbgrid.inc.php'; require SIMBIO_BASE_DIR . 'simbio_GUI/paging/simbio_paging.inc.php'; require SIMBIO_BASE_DIR . 'simbio_UTILS/simbio_date.inc.php'; // table spec $_table_spec = 'loan AS l LEFT JOIN member AS m ON l.member_id=m.member_id LEFT JOIN item AS i ON l.item_code=i.item_code LEFT JOIN biblio AS b ON i.biblio_id=b.biblio_id'; // create datagrid $_loan_list = new simbio_datagrid(); $_loan_list->setSQLColumn('l.item_code AS \'' . __('Item Code') . '\'', 'b.title AS \'' . __('Title') . '\'', 'l.loan_date AS \'' . __('Loan Date') . '\'', 'l.due_date AS \'' . __('Due Date') . '\''); $_loan_list->setSQLorder('l.loan_date DESC'); $_criteria = 'm.member_id=\'' . $_SESSION['mid'] . '\' '; $_loan_list->setSQLCriteria($_criteria); // modify column value $_loan_list->modifyColumnContent(3, 'callback{showOverdue}'); // set table and table header attributes $_loan_list->table_attr = 'align="center" class="memberLoanList" cellpadding="5" cellspacing="0"'; $_loan_list->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; $_loan_list->using_AJAX = false; // return the result $_result = $_loan_list->createDataGrid($dbs, $_table_spec, $num_recs_show); $_result = '<div class="memberLoanListInfo">' . $_loan_list->num_rows . ' ' . __('item(s) currently on loan') . '</div>' . "\n" . $_result; return $_result; }
$datagrid->setSQLColumn('t.topic AS \'' . __('Subject') . '\'', 't.topic_type AS \'' . __('Subject Type') . '\'', 't.auth_list AS \'' . __('Authority Files') . '\'', 't.last_update AS \'' . __('Last Update') . '\''); } $datagrid->setSQLorder('topic ASC'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keyword = $dbs->escape_string(trim($_GET['keywords'])); $words = explode(' ', $keyword); if (count($words) > 1) { $concat_sql = ' ('; foreach ($words as $word) { $concat_sql .= " t.topic LIKE '%{$word}%' AND"; } // remove the last AND $concat_sql = substr_replace($concat_sql, '', -3); $concat_sql .= ') '; $datagrid->setSQLCriteria($concat_sql); } else { $datagrid->setSQLCriteria("t.topic LIKE '%{$keyword}%'"); } } // set table and table header attributes $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF']; // callback function to change value of subject type function callbackSubjectType($obj_db, $rec_d) { global $sysconf, $subj_type_fld; return $sysconf['subject_type'][$rec_d[$subj_type_fld]]; }
} else { /* HOLIDAY LIST */ // table spec $table_spec = 'holiday'; // create datagrid $datagrid = new simbio_datagrid(); if ($can_read and $can_write) { $datagrid->setSQLColumn('holiday_id', "holiday_dayname AS '" . __('Day name') . "'", "holiday_date AS '" . __('Holiday Date Start') . "'", "description AS '" . __('Holiday Description') . "'"); } else { $datagrid->setSQLColumn("holiday_dayname AS '" . __('Day name') . "'", "holiday_date AS '" . __('Holiday Date Start') . "'", "description AS '" . __('Holiday Description') . "'"); } $datagrid->setSQLorder('holiday_date DESC'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keywords = $dbs->escape_string($_GET['keywords']); $datagrid->setSQLCriteria("holiday_description LIKE '%{$keywords}%' OR holiday_date LIKE '%{$keywords}%'"); } else { $datagrid->setSQLCriteria('holiday_date IS NOT NULL'); } // set table and table header attributes $datagrid->icon_edit = SWB . 'admin/' . $sysconf['admin_template']['dir'] . '/' . $sysconf['admin_template']['theme'] . '/edit.gif'; $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF']; // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, $can_read and $can_write); if (isset($_GET['keywords']) and $_GET['keywords']) { $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords')); //mfc echo '<div class="infoBox">' . $msg . ' : "' . $_GET['keywords'] . '"</div>';
/* GMD LIST */ // table spec $table_spec = 'mst_frequency AS f LEFT JOIN mst_language AS l ON f.language_prefix=l.language_id'; // create datagrid $datagrid = new simbio_datagrid(); if ($can_read and $can_write) { $datagrid->setSQLColumn('f.frequency_id', 'f.frequency AS \'' . __('Frequency') . '\'', 'l.language_name AS \'' . __('Language') . '\'', 'f.time_increment AS \'' . __('Time Increment') . '\'', 'f.time_unit AS \'' . __('Time Unit') . '\'', 'f.last_update AS \'' . __('Last Update') . '\''); } else { $datagrid->setSQLColumn('f.frequency AS \'' . __('Frequency') . '\'', 'l.language_name AS \'' . __('Language') . '\'', 'f.time_increment AS \'' . __('Time Increment') . '\'', 'f.time_unit AS \'' . __('Time Unit') . '\'', 'f.last_update AS \'' . __('Last Update') . '\''); } $datagrid->setSQLorder('frequency ASC'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keywords = $dbs->escape_string($_GET['keywords']); $datagrid->setSQLCriteria("g.frequency_name LIKE '%{$keywords}%'"); } // set table and table header attributes $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF']; // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, $can_read and $can_write); if (isset($_GET['keywords']) and $_GET['keywords']) { $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords')); //mfc echo '<div class="infoBox">' . $msg . ' : "' . $_GET['keywords'] . '"</div>'; } echo $datagrid_result; }
} else { /* PLACE LIST */ // table spec $table_spec = 'mst_place AS pl'; // create datagrid $datagrid = new simbio_datagrid(); if ($can_read and $can_write) { $datagrid->setSQLColumn('pl.place_id', 'pl.place_name AS \'' . __('Place Name') . '\'', 'pl.last_update AS \'' . __('Last Update') . '\''); } else { $datagrid->setSQLColumn('pl.place_name AS \'' . __('Place Name') . '\'', 'pl.last_update AS \'' . __('Last Update') . '\''); } $datagrid->setSQLorder('place_name ASC'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keywords = $dbs->escape_string($_GET['keywords']); $datagrid->setSQLCriteria("pl.place_name LIKE '%{$keywords}%'"); } // set table and table header attributes $datagrid->table_attr = 'align="center" class="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF']; // put the result into variable $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, $can_read and $can_write); if (isset($_GET['keywords']) and $_GET['keywords']) { $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords')); //mfc echo '<div class="infoBox">' . $msg . ' : "' . $_GET['keywords'] . '"</div>'; } echo $datagrid_result; }
function showLoanHist($num_recs_show = 20) { global $dbs; // table spec $_table_spec = 'loan AS l LEFT JOIN member AS m ON l.member_id=m.member_id LEFT JOIN item AS i ON l.item_code=i.item_code LEFT JOIN biblio AS b ON i.biblio_id=b.biblio_id'; // create datagrid $_loan_hist = new simbio_datagrid(); $_loan_hist->disable_paging = true; $_loan_hist->table_ID = 'loanhist'; $_loan_hist->setSQLColumn('l.item_code AS \'' . __('Item Code') . '\'', 'b.title AS \'' . __('Title') . '\'', 'l.loan_date AS \'' . __('Loan Date') . '\'', 'l.return_date AS \'' . __('Return Date') . '\''); $_loan_hist->setSQLorder('l.loan_date DESC'); $_criteria = sprintf('m.member_id=\'%s\' AND l.is_lent=1 AND is_return=1 ', $_SESSION['mid']); $_loan_hist->setSQLCriteria($_criteria); // modify column value #$_loan_hist->modifyColumnContent(3, 'callback{showOverdue}'); // set table and table header attributes $_loan_hist->table_attr = 'align="center" class="memberLoanList" cellpadding="5" cellspacing="0"'; $_loan_hist->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; $_loan_hist->using_AJAX = false; // return the result $_result = $_loan_hist->createDataGrid($dbs, $_table_spec, $num_recs_show); $_result = '<div class="memberLoanHistInfo"> ' . $_loan_hist->num_rows . ' ' . __('item(s) loan history') . ' | <a href="?p=download_loan_history">Download All Loan History</a></div>' . "\n" . $_result; return $_result; }
} else { /* LOCATION LIST */ // table spec $table_spec = 'mst_location AS l'; // create datagrid $datagrid = new simbio_datagrid(); if ($can_read and $can_write) { $datagrid->setSQLColumn('l.location_id', 'l.location_id AS \'' . __('Location Code') . '\'', 'l.location_name AS \'' . __('Location Name') . '\'', 'l.last_update AS \'' . __('Last Update') . '\''); } else { $datagrid->setSQLColumn('l.location_id AS \'' . __('Location Code') . '\'', 'l.location_name AS \'' . __('Location Name') . '\'', 'l.last_update AS \'' . __('Last Update') . '\''); } $datagrid->setSQLorder('location_name ASC'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keywords = $dbs->escape_string($_GET['keywords']); $datagrid->setSQLCriteria("l.location_name LIKE '%{$keywords}%'"); } // set table and table header attributes $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF']; // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, $can_read and $can_write); if (isset($_GET['keywords']) and $_GET['keywords']) { $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords')); //mfc echo '<div class="infoBox">' . $msg . ' : "' . $_GET['keywords'] . '"</div>'; } echo $datagrid_result; }
$datagrid = new simbio_datagrid(); if ($can_read and $can_write) { $auth_type_fld = 2; $datagrid->setSQLColumn('a.author_id', 'a.author_name AS \'' . lang_mod_masterfile_author_form_field_name . '\'', 'a.authority_type AS \'' . lang_mod_masterfile_author_form_field_authority . '\'', 'a.auth_list AS \'' . lang_mod_masterfile_authority_files . '\'', 'a.last_update AS \'' . lang_mod_masterfile_author_common_last_update . '\''); } else { $datagrid->setSQLColumn('a.author_name AS \'' . lang_mod_masterfile_author_form_field_name . '\'', 'a.authority_type AS \'' . lang_mod_masterfile_author_form_field_authority . '\'', 'a.auth_list AS \'' . lang_mod_masterfile_authority_files . '\'', 'a.last_update AS \'' . lang_mod_masterfile_author_common_last_update . '\''); } $datagrid->setSQLorder('author_name ASC'); // change the record order if (isset($_GET['fld']) and isset($_GET['dir'])) { $datagrid->setSQLorder("'" . urldecode($_GET['fld']) . "' " . $dbs->escape_string($_GET['dir'])); } // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keywords = $dbs->escape_string($_GET['keywords']); $datagrid->setSQLCriteria("a.author_name LIKE '%{$keywords}%'"); } // set table and table header attributes $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF']; // callback function to change value of authority type function callbackAuthorType($obj_db, $rec_d) { global $sysconf, $auth_type_fld; return $sysconf['authority_type'][$rec_d[$auth_type_fld]]; } // modify column content $datagrid->modifyColumnContent($auth_type_fld, 'callback{callbackAuthorType}'); // put the result into variable
} else { /* SUPPLIER LIST */ // table spec $table_spec = 'mst_supplier AS sp'; // create datagrid $datagrid = new simbio_datagrid(); if ($can_read and $can_write) { $datagrid->setSQLColumn('sp.supplier_id', 'sp.supplier_name AS \'' . __('Supplier Name') . '\'', 'sp.contact AS \'' . __('Contact') . '\'', 'sp.phone AS \'' . __('Phone Number') . '\'', 'sp.fax AS \'' . __('Fax Number') . '\'', 'sp.last_update AS \'' . __('Last Update') . '\''); } else { $datagrid->setSQLColumn('sp.supplier_name AS \'' . __('Supplier Name') . '\'', 'sp.contact AS \'' . __('Contact') . '\'', 'sp.phone AS \'' . __('Phone Number') . '\'', 'sp.fax AS \'' . __('Fax Number') . '\'', 'sp.last_update AS \'' . __('Last Update') . '\''); } $datagrid->setSQLorder('supplier_name ASC'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keywords = $dbs->escape_string($_GET['keywords']); $datagrid->setSQLCriteria("sp.supplier_name LIKE '%{$keywords}%' OR sp.supplier_id LIKE '%{$keywords}%'\n OR sp.contact LIKE '%{$keywords}%' OR sp.address LIKE '%{$keywords}%'"); } // set table and table header attributes $datagrid->table_attr = 'align="center" class="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF']; // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, $can_read and $can_write); if (isset($_GET['keywords']) and $_GET['keywords']) { $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords')); //mfc echo '<div class="infoBox">' . $msg . ' : "' . $_GET['keywords'] . '"</div>'; } echo $datagrid_result; }
// create datagrid $datagrid = new simbio_datagrid(); if ($can_read and $can_write) { $datagrid->setSQLColumn('ist.item_status_id', 'ist.item_status_id AS \'' . __('Item Status Code') . '\'', 'ist.item_status_name AS \'' . __('Item Status Name') . '\'', 'ist.last_update AS \'' . __('Last Update') . '\''); } else { $datagrid->setSQLColumn('ist.item_status_id AS \'' . __('Item Status Code') . '\'', 'ist.item_status_name AS \'' . __('Item Status Name') . '\'', 'ist.last_update AS \'' . __('Last Update') . '\''); } $datagrid->setSQLorder('item_status_name ASC'); // change the record order if (isset($_GET['fld']) and isset($_GET['dir'])) { $datagrid->setSQLorder("'" . urldecode($_GET['fld']) . "' " . $dbs->escape_string($_GET['dir'])); } // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keywords = $dbs->escape_string($_GET['keywords']); $datagrid->setSQLCriteria("ist.item_status_name LIKE '%{$keywords}%'"); } // set table and table header attributes $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF']; // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, $can_read and $can_write); if (isset($_GET['keywords']) and $_GET['keywords']) { $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords')); //mfc echo '<div class="infoBox">' . $msg . ' : "' . $_GET['keywords'] . '"</div>'; } echo $datagrid_result; }
$datagrid = new simbio_datagrid(); $datagrid->setSQLColumn('m.member_id', 'm.member_id AS \'' . __('Member ID') . '\'', 'm.member_name AS \'' . __('Member Name') . '\'', 'mt.member_type_name AS \'' . __('Membership Type') . '\''); $datagrid->setSQLorder('m.last_update DESC'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keyword = $dbs->escape_string(trim($_GET['keywords'])); $words = explode(' ', $keyword); if (count($words) > 1) { $concat_sql = ' ('; foreach ($words as $word) { $concat_sql .= " (m.member_id LIKE '%{$word}%' OR m.member_name LIKE '%{$word}%'"; } // remove the last AND $concat_sql = substr_replace($concat_sql, '', -3); $concat_sql .= ') '; $datagrid->setSQLCriteria($concat_sql); } else { $datagrid->setSQLCriteria("m.member_id LIKE '%{$keyword}%' OR m.member_name LIKE '%{$keyword}%'"); } } // set table and table header attributes $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // edit and checkbox property $datagrid->edit_property = false; $datagrid->chbox_property = array('itemID', __('Add')); $datagrid->chbox_action_button = __('Add To Print Queue'); $datagrid->chbox_confirm_msg = __('Add to print queue?'); $datagrid->column_width = array('10%', '70%', '15%'); // set checkbox action URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF'];
$keyword = $dbs->escape_string(trim($_GET['keywords'])); $words = explode(' ', $keyword); if (count($words) > 1) { $concat_sql = ' AND ('; foreach ($words as $word) { $concat_sql .= " t.topic LIKE '%{$word}%' AND"; } // remove the last AND $concat_sql = substr_replace($concat_sql, '', -3); $concat_sql .= ') '; $sql_criteria .= $concat_sql; } else { $sql_criteria .= " AND t.topic LIKE '%{$keyword}%'"; } } $datagrid->setSQLCriteria($sql_criteria); // set table and table header attributes $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF']; // callback function to change value of subject type function callbackSubjectType($obj_db, $rec_d) { global $sysconf, $subj_type_fld; return $sysconf['subject_type'][$rec_d[$subj_type_fld]]; } // modify column content $datagrid->modifyColumnContent($subj_type_fld, 'callback{callbackSubjectType}'); // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, $can_read and $can_write);
$datagrid = new simbio_datagrid(); $datagrid->setSQLColumn('sl.log_date AS \'' . __('Time') . '\'', 'sl.log_location AS \'' . __('Location') . '\'', 'sl.log_msg AS \'' . __('Message') . '\''); $datagrid->setSQLorder('sl.log_date DESC'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keyword = $dbs->escape_string(trim($_GET['keywords'])); $words = explode(' ', $keyword); if (count($words) > 1) { $concat_sql = ' ('; foreach ($words as $word) { $concat_sql .= " (sl.log_date LIKE '%{$word}%' OR sl.log_msg LIKE '%{$word}%') AND"; } // remove the last AND $concat_sql = substr_replace($concat_sql, '', -3); $concat_sql .= ') '; $datagrid->setSQLCriteria($concat_sql); } else { $datagrid->setSQLCriteria("sl.log_date LIKE '%{$keyword}%' OR sl.log_msg LIKE '%{$keyword}%'"); } } // set table and table header attributes $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->delete_URL = $_SERVER['PHP_SELF']; $datagrid->column_width = array('18%', '10%', '72%'); $datagrid->disableSort('Message'); // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 50, false); if (isset($_GET['keywords']) and $_GET['keywords']) { $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords'));
} else { /* GMD LIST */ // table spec $table_spec = 'mst_gmd AS g'; // create datagrid $datagrid = new simbio_datagrid(); if ($can_read and $can_write) { $datagrid->setSQLColumn('g.gmd_id', 'g.gmd_code AS \'' . __('GMD Code') . '\'', 'g.gmd_name AS \'' . __('GMD Name') . '\'', 'g.last_update AS \'' . __('Last Update') . '\''); } else { $datagrid->setSQLColumn('g.gmd_code AS \'' . __('GMD Code') . '\'', 'g.gmd_name AS \'' . __('GMD Name') . '\'', 'g.last_update AS \'' . __('Last Update') . '\''); } $datagrid->setSQLorder('gmd_name ASC'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keywords = $dbs->escape_string($_GET['keywords']); $datagrid->setSQLCriteria("g.gmd_name LIKE '%{$keywords}%' OR g.gmd_code LIKE '%{$keywords}%'"); } // set table and table header attributes $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->chbox_form_URL = $_SERVER['PHP_SELF']; // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 20, $can_read and $can_write); if (isset($_GET['keywords']) and $_GET['keywords']) { $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords')); //mfc echo '<div class="infoBox">' . $msg . ' : "' . $_GET['keywords'] . '"</div>'; } echo $datagrid_result; }
$datagrid->setSQLorder('node_poll_time DESC'); // modify column value $datagrid->modifyColumnContent(4, 'callback{showStatus}'); // is there any search if (isset($_GET['keywords']) and $_GET['keywords']) { $keyword = $dbs->escape_string(trim($_GET['keywords'])); $words = explode(' ', $keyword); if (count($words) > 1) { $concat_sql = ' ('; foreach ($words as $word) { $concat_sql .= " (node_id LIKE '%{$word}%' OR node_poll_time LIKE '%{$word}%') AND"; } // remove the last AND $concat_sql = substr_replace($concat_sql, '', -3); $concat_sql .= ') '; $datagrid->setSQLCriteria($concat_sql); } else { $datagrid->setSQLCriteria("node_id LIKE '%{$keyword}%' OR node_poll_time LIKE '%{$keyword}%'"); } } // set table and table header attributes $datagrid->table_attr = 'align="center" id="dataList" cellpadding="5" cellspacing="0"'; $datagrid->table_header_attr = 'class="dataListHeader" style="font-weight: bold;"'; // set delete proccess URL $datagrid->delete_URL = $_SERVER['PHP_SELF']; // put the result into variables $datagrid_result = $datagrid->createDataGrid($dbs, $table_spec, 50, false); if (isset($_GET['keywords']) and $_GET['keywords']) { $msg = str_replace('{result->num_rows}', $datagrid->num_rows, __('Found <strong>{result->num_rows}</strong> from your keywords')); //mfc echo '<div class="infoBox">' . $msg . ' : "' . $_GET['keywords'] . '"</div>';