$gender = intval($_GET['gender']);
$criteria .= ' AND m.gender=' . $gender;
}
if (isset($_GET['address']) and !empty($_GET['address'])) {
$address = $dbs->escape_string(trim($_GET['address']));
$criteria .= ' AND m.member_address LIKE \'%' . $address . '%\'';
}
// register date
if (isset($_GET['startDate']) and isset($_GET['untilDate'])) {
$criteria .= ' AND (TO_DAYS(m.register_date) BETWEEN TO_DAYS(\'' . $_GET['startDate'] . '\') AND
TO_DAYS(\'' . $_GET['untilDate'] . '\'))';
}
if (isset($_GET['recsEachPage'])) {
$recsEachPage = (int) $_GET['recsEachPage'];
$num_recs_show = $recsEachPage >= 20 && $recsEachPage <= 200 ? $recsEachPage : $num_recs_show;
}
$reportgrid->setSQLCriteria($criteria);
// put the result into variables
echo $reportgrid->createDataGrid($dbs, $table_spec, $num_recs_show);
echo '<script type="text/javascript">' . "\n";
echo 'parent.$(\'#pagingBox\').html(\'' . str_replace(array("\n", "\r", "\t"), '', $reportgrid->paging_set) . '\');' . "\n";
echo '</script>';
$xlsquery = 'SELECT m.member_id AS \'' . __('Member ID') . '\'' . ', m.member_name AS \'' . __('Member Name') . '\'' . ', mt.member_type_name AS \'' . __('Membership Type') . '\' FROM ' . $table_spec . ' WHERE ' . $criteria;
unset($_SESSION['xlsdata']);
$_SESSION['xlsquery'] = $xlsquery;
$_SESSION['tblout'] = "member_list";
echo '<p><a href="../xlsoutput.php" class="button">' . __('Export to spreadsheet format') . '</a></p>';
$content = ob_get_clean();
// include the page template
require SB . '/admin/' . $sysconf['admin_template']['dir'] . '/printed_page_tpl.php';
}
}
// remove the last AND
$concat_sql = substr_replace($concat_sql, '', -3);
$concat_sql .= ') ';
$criteria .= $concat_sql;
} else {
$criteria .= ' AND (b.title 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['member']) and !empty($_GET['member'])) {
$member = $dbs->escape_string($_GET['member']);
$criteria .= ' AND (m.member_name LIKE \'%' . $member . '%\' OR m.member_id LIKE \'%' . $member . '%\')';
}
if (isset($_GET['startDate']) and isset($_GET['untilDate'])) {
$criteria .= ' AND (TO_DAYS(r.reserve_date) BETWEEN TO_DAYS(\'' . $_GET['startDate'] . '\') AND
TO_DAYS(\'' . $_GET['untilDate'] . '\'))';
}
$reportgrid->setSQLCriteria($criteria);
// put the result into variables
echo $reportgrid->createDataGrid($dbs, $table_spec, 20);
echo '<script type="text/javascript">' . "\n";
echo 'parent.$(\'#pagingBox\').html(\'' . str_replace(array("\n", "\r", "\t"), '', $reportgrid->paging_set) . '\');' . "\n";
echo '</script>';
$content = ob_get_clean();
// include the page template
require SENAYAN_BASE_DIR . '/admin/' . $sysconf['admin_template']['dir'] . '/printed_page_tpl.php';
}
