'.__('You don\'t have enough privileges to access this area!').''); } require SIMBIO.'simbio_GUI/template_parser/simbio_template_parser.inc.php'; 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 = 'Members Report'; $reportView = false; $num_recs_show = 20; if (isset($_GET['reportView'])) { $reportView = true; } if (!$reportView) { ?>

query('SELECT member_type_id, member_type_name FROM mst_member_type'); $mtype_options = array(); $mtype_options[] = array('0', __('ALL')); while ($mtype_d = $mtype_q->fetch_row()) { $mtype_options[] = array($mtype_d[0], $mtype_d[1]); } echo simbio_form_element::selectList('member_type', $mtype_options); ?>
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'])) { $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 = (integer)$_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 ''; $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 '

'.__('Export to spreadsheet format').'

'; $content = ob_get_clean(); // include the page template require SB.'/admin/'.$sysconf['admin_template']['dir'].'/printed_page_tpl.php'; }