'.__('You don\'t have enough privileges to access this area!').''); } require SIMBIO.'simbio_GUI/table/simbio_table.inc.php'; require SIMBIO.'simbio_GUI/paging/simbio_paging.inc.php'; require SIMBIO.'simbio_GUI/form_maker/simbio_form_element.inc.php'; require SIMBIO.'simbio_DB/datagrid/simbio_dbgrid.inc.php'; require MDLBS.'reporting/report_dbgrid.inc.php'; $page_title = 'Items/Copies Report'; $reportView = false; $num_recs_show = 20; if (isset($_GET['reportView'])) { $reportView = true; } if (!$reportView) { ?>

query('SELECT gmd_id, gmd_name FROM mst_gmd'); $gmd_options[] = array('0', __('ALL')); while ($gmd_d = $gmd_q->fetch_row()) { $gmd_options[] = array($gmd_d[0], $gmd_d[1]); } echo simbio_form_element::selectList('gmd[]', $gmd_options, '','multiple="multiple" size="5"'); ?>
query('SELECT coll_type_id, coll_type_name FROM mst_coll_type'); $coll_type_options = array(); $coll_type_options[] = array('0', __('ALL')); while ($coll_type_d = $coll_type_q->fetch_row()) { $coll_type_options[] = array($coll_type_d[0], $coll_type_d[1]); } echo simbio_form_element::selectList('collType[]', $coll_type_options, '', 'multiple="multiple" size="5"'); ?>
query('SELECT item_status_id, item_status_name FROM mst_item_status'); $status_options = array(); $status_options[] = array('0', __('ALL')); while ($status_d = $status_q->fetch_row()) { $status_options[] = array($status_d[0], $status_d[1]); } echo simbio_form_element::selectList('status', $status_options); ?>
query('SELECT location_id, location_name FROM mst_location'); $loc_options = array(); $loc_options[] = array('0', __('ALL')); while ($loc_d = $loc_q->fetch_row()) { $loc_options[] = array($loc_d[0], $loc_d[1]); } echo simbio_form_element::selectList('location', $loc_options); ?>
setSQLColumn('i.item_code AS \''.__('Item Code').'\'', 'b.title AS \''.__('Title').'\'', 'ct.coll_type_name AS \''.__('Collection Type').'\'', 's.item_status_name AS \''.__('Item Status').'\'', 'b.call_number AS \''.__('Call Number').'\'', 'i.biblio_id'); $reportgrid->setSQLorder('b.title ASC'); // is there any search $criteria = 'b.biblio_id IS NOT NULL '; if (isset($_GET['title']) AND !empty($_GET['title'])) { $keyword = $dbs->escape_string(trim($_GET['title'])); $words = explode(' ', $keyword); if (count($words) > 1) { $concat_sql = ' AND ('; foreach ($words as $word) { $concat_sql .= " (b.title LIKE '%$word%' OR b.isbn_issn LIKE '%$word%') AND"; } // remove the last AND $concat_sql = substr_replace($concat_sql, '', -3); $concat_sql .= ') '; $criteria .= $concat_sql; } else { $criteria .= ' AND (b.title LIKE \'%'.$keyword.'%\' OR b.isbn_issn LIKE \'%'.$keyword.'%\')'; } } if (isset($_GET['itemCode']) AND !empty($_GET['itemCode'])) { $item_code = $dbs->escape_string(trim($_GET['itemCode'])); $criteria .= ' AND i.item_code LIKE \'%'.$item_code.'%\''; } if (isset($_GET['collType'])) { $coll_type_IDs = ''; foreach ($_GET['collType'] as $id) { $id = (integer)$id; if ($id) { $coll_type_IDs .= "$id,"; } } $coll_type_IDs = substr_replace($coll_type_IDs, '', -1); if ($coll_type_IDs) { $criteria .= " AND i.coll_type_id IN($coll_type_IDs)"; } } if (isset($_GET['gmd']) AND !empty($_GET['gmd'])) { $gmd_IDs = ''; foreach ($_GET['gmd'] as $id) { $id = (integer)$id; if ($id) { $gmd_IDs .= "$id,"; } } $gmd_IDs = substr_replace($gmd_IDs, '', -1); if ($gmd_IDs) { $criteria .= " AND b.gmd_id IN($gmd_IDs)"; } } if (isset($_GET['status']) AND $_GET['status']!='0') { $status = $dbs->escape_string(trim($_GET['status'])); $criteria .= ' AND i.item_status_id=\''.$status.'\''; } if (isset($_GET['class']) AND ($_GET['class'] != '')) { $class = $dbs->escape_string($_GET['class']); $criteria .= ' AND b.classification LIKE \''.$class.'%\''; } if (isset($_GET['location']) AND !empty($_GET['location'])) { $location = $dbs->escape_string(trim($_GET['location'])); $criteria .= ' AND i.location_id=\''.$location.'\''; } if (isset($_GET['recsEachPage'])) { $recsEachPage = (integer)$_GET['recsEachPage']; $num_recs_show = ($recsEachPage >= 20 && $recsEachPage <= 200)?$recsEachPage:$num_recs_show; } $reportgrid->setSQLCriteria($criteria); // callback function to show title and authors function showTitleAuthors($obj_db, $array_data) { if (!$array_data[5]) { return; } // author name query $_biblio_q = $obj_db->query('SELECT b.title, a.author_name FROM biblio AS b LEFT JOIN biblio_author AS ba ON b.biblio_id=ba.biblio_id LEFT JOIN mst_author AS a ON ba.author_id=a.author_id WHERE b.biblio_id='.$array_data[5]); $_authors = ''; while ($_biblio_d = $_biblio_q->fetch_row()) { $_title = $_biblio_d[0]; $_authors .= $_biblio_d[1].' - '; } $_authors = substr_replace($_authors, '', -3); $_output = $_title.'
'.$_authors.''."\n"; return $_output; } // modify column value $reportgrid->modifyColumnContent(1, 'callback{showTitleAuthors}'); $reportgrid->invisible_fields = array(5); // put the result into variables echo $reportgrid->createDataGrid($dbs, $table_spec, $num_recs_show); echo ''; $content = ob_get_clean(); // include the page template require SB.'/admin/'.$sysconf['admin_template']['dir'].'/printed_page_tpl.php'; }