<div class="dataListHeader" style="padding: 3px;"><span id="pagingBox"></span></div>
<iframe name="reportView" id="reportView" src="<?php
echo $_SERVER['PHP_SELF'] . '?reportView=true';
?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php
} else {
ob_start();
// table spec
$table_spec = 'reserve AS r
LEFT JOIN biblio AS b ON r.biblio_id=b.biblio_id
LEFT JOIN member AS m ON r.member_id=m.member_id';
// create datagrid
$reportgrid = new report_datagrid();
$reportgrid->setSQLColumn('r.item_code AS \'' . __('Item Code') . '\'', 'b.title AS \'' . __('Title') . '\'', 'm.member_name AS \'' . __('Member Name') . '\'', 'r.reserve_date AS \'' . __('Reserve Date') . '\'');
$reportgrid->setSQLorder('r.reserve_date DESC');
// is there any search
$criteria = 'r.reserve_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}%') AND";
}
// remove the last AND
$concat_sql = substr_replace($concat_sql, '', -3);
$concat_sql .= ') ';
$criteria .= $concat_sql;
} else {
<!-- filter end -->
<div class="dataListHeader" style="padding: 3px;"><span id="pagingBox"></span></div>
<iframe name="reportView" id="reportView" src="<?php
echo $_SERVER['PHP_SELF'] . '?reportView=true';
?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php
} else {
ob_start();
// table spec
$table_spec = 'member AS m
LEFT JOIN mst_member_type AS mt ON m.member_type_id=mt.member_type_id';
// create datagrid
$reportgrid = new report_datagrid();
$reportgrid->setSQLColumn('m.member_id AS \'' . __('Member ID') . '\'', 'm.member_name AS \'' . __('Member Name') . '\'', 'mt.member_type_name AS \'' . __('Membership Type') . '\'');
$reportgrid->setSQLorder('member_name ASC');
// is there any search
$criteria = 'm.member_id IS NOT NULL ';
if (isset($_GET['member_type']) and !empty($_GET['member_type'])) {
$mtype = intval($_GET['member_type']);
$criteria .= ' AND m.member_type_id=' . $mtype;
}
if (isset($_GET['id_name']) and !empty($_GET['id_name'])) {
$id_name = $dbs->escape_string($_GET['id_name']);
$criteria .= ' AND (m.member_id LIKE \'%' . $id_name . '%\' OR m.member_name LIKE \'%' . $id_name . '%\')';
}
if (isset($_GET['gender']) and $_GET['gender'] != 'ALL') {
$gender = intval($_GET['gender']);
$criteria .= ' AND m.gender=' . $gender;
}
if (isset($_GET['address']) and !empty($_GET['address'])) {
</form>
</div>
</fieldset>
<!-- filter end -->
<div class="dataListHeader" style="padding: 3px;"><span id="pagingBox"></span></div>
<iframe name="reportView" id="reportView" src="<?php
echo $_SERVER['PHP_SELF'] . '?reportView=true';
?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php
} else {
ob_start();
// create datagrid
$reportgrid = new report_datagrid();
$reportgrid->setSQLColumn('b.biblio_id', 'b.title AS \'' . __('Title') . '\'', 'COUNT(item_id) AS \'' . __('Copies') . '\'', 'pl.place_name AS \'' . __('Publishing Place') . '\'', 'pb.publisher_name AS \'' . __('Publisher') . '\'', 'b.isbn_issn AS \'' . __('ISBN/ISSN') . '\'', 'b.call_number AS \'' . __('Call Number') . '\'');
$reportgrid->setSQLorder('b.title ASC');
$reportgrid->invisible_fields = array(0);
// is there any search
$criteria = 'bsub.biblio_id IS NOT NULL ';
$outer_criteria = 'b.biblio_id > 0 ';
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 .= " (bsub.title LIKE '%{$word}%' OR bsub.isbn_issn LIKE '%{$word}%') AND";
}
// remove the last AND
$concat_sql = substr_replace($concat_sql, '', -3);
$concat_sql .= ') ';
<iframe name="reportView" src="<?php
echo $_SERVER['PHP_SELF'] . '?reportView=true';
?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php
} else {
ob_start();
// 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
$reportgrid = new report_datagrid();
$reportgrid->setSQLColumn('m.member_id AS \'' . lang_mod_membership_field_member_id . '\'', 'm.member_name AS \'' . lang_mod_membership_field_name . '\'', 'l.item_code AS \'' . lang_mod_biblio_item_field_itemcode . '\'', 'b.title AS \'' . lang_mod_biblio_field_title . '\'', 'l.loan_date AS \'' . lang_mod_circ_tblheader_loan_date . '\'', 'l.due_date AS \'' . lang_mod_circ_tblheader_due_date . '\'', 'l.is_return AS \'' . lang_mod_biblio_item_common_status_description . '\'');
$reportgrid->setSQLorder('l.loan_date DESC');
$criteria = 'm.member_id IS NOT NULL ';
if (isset($_GET['id_name']) and !empty($_GET['id_name'])) {
$id_name = $dbs->escape_string($_GET['id_name']);
$criteria .= ' AND (m.member_id LIKE \'%' . $id_name . '%\' OR m.member_name LIKE \'%' . $id_name . '%\')';
}
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}%') AND";
}
// remove the last AND
$concat_sql = substr_replace($concat_sql, '', -3);
<!-- filter end -->
<div class="dataListHeader" style="padding: 3px;"><span id="pagingBox"></span></div>
<iframe name="reportView" id="reportView" src="<?php
echo $_SERVER['PHP_SELF'] . '?reportView=true';
?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php
} else {
ob_start();
// table spec
$table_spec = 'member AS m
LEFT JOIN loan AS l ON m.member_id=l.member_id';
// create datagrid
$reportgrid = new report_datagrid();
$reportgrid->setSQLColumn('m.member_id AS \'' . __('Member ID') . '\'');
$reportgrid->setSQLorder('l.due_date DESC');
$reportgrid->sql_group_by = 'm.member_id';
$overdue_criteria = ' (l.is_lent=1 AND l.is_return=0 AND TO_DAYS(due_date) < TO_DAYS(\'' . date('Y-m-d') . '\')) ';
// is there any search
if (isset($_GET['id_name']) and $_GET['id_name']) {
$keyword = $dbs->escape_string(trim($_GET['id_name']));
$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}%') AND";
}
// remove the last AND
$concat_sql = substr_replace($concat_sql, '', -3);
$concat_sql .= ') ';
$overdue_criteria .= ' AND ' . $concat_sql;
</fieldset>
<!-- filter end -->
<div class="dataListHeader" style="padding: 3px;"><span id="pagingBox"></span></div>
<iframe name="reportView" id="reportView" src="<?php
echo $_SERVER['PHP_SELF'] . '?reportView=true';
?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php
} else {
ob_start();
// table spec
$table_spec = 'user AS u';
// create datagrid
$reportgrid = new report_datagrid();
$reportgrid->setSQLColumn('u.realname AS \'' . __('Real Name') . '\'', 'u.username AS \'' . __('Login Username') . '\'', 'u.user_id AS \'' . __('Bibliography Data Entry') . '\'', 'u.user_id AS \'' . __('Item Data Entry') . '\'', 'u.user_id AS \'' . __('Member Data Entry') . '\'', 'u.user_id AS \'' . __('Circulation Tasks') . '\'');
$reportgrid->setSQLorder('realname ASC');
// is there any search
$criteria = 'user_id IS NOT NULL ';
$reportgrid->setSQLCriteria($criteria);
$start_date = '2000-01-01';
if (isset($_GET['startDate'])) {
$start_date = $_GET['startDate'];
}
$until_date = date('Y-m-d');
if (isset($_GET['untilDate'])) {
$until_date = $_GET['untilDate'];
}
// callbacks
function showBiblioEntries($obj_db, $array_data)
{
global $start_date, $until_date;
<div class="dataListHeader" style="padding: 3px;"><span id="pagingBox"></span></div>
<iframe name="reportView" id="reportView" src="<?php
echo $_SERVER['PHP_SELF'] . '?reportView=true';
?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php
} else {
ob_start();
// table spec
$table_spec = 'visitor_count AS vc
LEFT JOIN (member AS m LEFT JOIN mst_member_type AS mt ON m.member_type_id=mt.member_type_id)
ON vc.member_id=m.member_id';
// create datagrid
$reportgrid = new report_datagrid();
$reportgrid->setSQLColumn('IF(vc.member_id IS NOT NULL, vc.member_id, \'NON-MEMBER\') AS \'' . __('Member ID') . '\'', 'vc.member_name AS \'' . __('Visitor Name') . '\'', 'IF(mt.member_type_name IS NOT NULL, mt.member_type_name, \'NON-MEMBER\') AS \'' . __('Membership Type') . '\'', 'vc.institution AS \'' . __('Institution') . '\'', 'vc.checkin_date AS \'' . __('Visit Date') . '\'');
$reportgrid->setSQLorder('vc.member_id ASC');
// is there any search
$criteria = 'vc.visitor_id IS NOT NULL ';
if (isset($_GET['member_type']) and !empty($_GET['member_type'])) {
$mtype = $_GET['member_type'];
if (intval($mtype) < 0) {
$criteria .= ' AND (vc.member_id IS NULL OR vc.member_id=\'\')';
} else {
if (intval($mtype) > 0) {
$criteria .= ' AND mt.member_type_id=' . $mtype;
}
}
}
if (isset($_GET['id_name']) and !empty($_GET['id_name'])) {
$id_name = $dbs->escape_string($_GET['id_name']);
$criteria .= ' AND (vc.member_id LIKE \'%' . $id_name . '%\' OR vc.member_name LIKE \'%' . $id_name . '%\')';
