public function __construct($table)
{
$_SESSION['rows_per_page'] = req::_('rows_per_page', 10, '_SESSION');
$this->table = $table;
$this->order = req::_('order', dbfn::_getprimary($table));
$this->order_dir = req::_('dir', 'ASC');
$this->page = req::_('page', '1');
$this->rows_per_page = $_SESSION['rows_per_page'] = req::_('rows_per_page', $_SESSION['rows_per_page']);
$this->filter_field = req::_('filter_field');
$this->filter_group = req::_('filter_group', -1);
$this->filter_group = is_array($this->filter_group) ? implode(',', $this->filter_group) : $this->filter_group;
$this->first_record = req::_chk('page') ? (req::_('page') - 1) * $this->rows_per_page + 1 : 1;
$this->last_record = $this->first_record + $this->rows_per_page - 1;
$this->limit = $this->first_record - 1 . "," . $this->rows_per_page;
$this->q = req::_('q') == 'Search Records...' ? '' : req::_('q');
$this->where = $this->q != '' ? dbfn::_buildwhere($table, $this->q) : 1;
$this->where .= $this->filter_group != -1 ? " AND `{$this->filter_field}` IN ({$this->filter_group})" : '';
}
} else {
echo "<pre>" . $s . "</pre>";
}
}
function preh($s)
{
echo pre(htmlentities($s));
}
function consoleLog($s)
{
if (is_array($s) || is_object($s)) {
$return = "console.log(\"{\\n\"";
foreach ($s as $key => $value) {
$return .= " + \"\t[" . addslashes($key) . "] => " . addslashes($s->{$key}) . " \\n \"";
}
$return .= "+\"}\" );";
} else {
$return = "console.log(\"" . addslashes($s) . "\");";
}
return $return;
}
// RESET USER PASSWORD
if (req::_chk('reset') > 0) {
$id = req::_('reset');
$_REQUEST['use_id'] = $id;
$query = "UPDATE `aimusers` SET `use_password` = md5(concat(`use_firstname`,`use_lastname`)) WHERE `use_id` = {$id} LIMIT 1";
$oResult = new db($query);
foreach ($oResult->ret as $key => $value) {
${$key} = $value;
}
}
function __construct($table, $joins = false)
{
global $option;
global $view;
$this->table = $table;
$this->friendlytable = ucfirst(str_replace(TABLEPREFIX, '', $table));
$this->option = $option;
$this->view = $view;
$this->frm_name = "{$table}_filter_form";
$this->joins = $joins;
// Are we actively performing a filter
$this->apply = req::_('frm_name') == $this->frm_name ? true : false;
if ($this->apply) {
// actively applying this filter to the current table
// Filter Params
$filter = req::_('filter', -1);
$this->filter = is_array($filter) ? implode(',', $filter) : $filter;
// Build Pagination params
$_SESSION['rows_per_page'] = req::_('rows_per_page', ROWS_PER_PAGE, '_SESSION');
$rows_per_page = $_SESSION['rows_per_page'] = req::_('rows_per_page', $_SESSION['rows_per_page']);
$first_record = req::_chk('page') ? (req::_('page') - 1) * $rows_per_page + 1 : 1;
$last_record = $first_record + $rows_per_page - 1;
// Build where statement
$search_criteria = req::_('search_criteria', '');
if (!empty($search_criteria)) {
$search_criteria = urldecode($search_criteria);
$pairs = explode('&', $search_criteria);
$this->search_criteria = array();
foreach ($pairs as $pair) {
$p = explode('=', $pair);
$this->search_criteria[$p[0]] = $p[1];
}
}
$this->where = !empty($this->search_criteria) ? dbfn::_buildwhere2($this->search_criteria) : 1;
// Build order criteria
$this->order = req::_('order', dbfn::_getPrimary($table));
$this->dir = req::_('dir', 'ASC');
} else {
// not actively applying any filters to this table
$this->filter = -1;
$rows_per_page = $_SESSION['rows_per_page'];
$first_record = 1;
$last_record = $first_record + $rows_per_page - 1;
$this->where = 1;
$this->order = dbfn::_getPrimary($table);
$this->dir = 'ASC';
}
$this->limit = $first_record - 1 . "," . $rows_per_page;
$this->page = req::_('page', 1);
$this->rows_per_page = $rows_per_page;
// Find total records
$select2 = "SELECT count(*) AS `c` FROM `{$table}` {$joins} WHERE {$this->where}";
$oTemp = new db($select2);
$this->total_rows = $oTemp->_getResult();
$this->first_record = $this->rows_per_page < $this->total_rows ? $first_record : 1;
$this->last_record = $this->total_rows <= $last_record ? $this->total_rows : $last_record;
$this->total_pages = ceil($this->total_rows / $this->rows_per_page);
// Update limit and page number if necessary
$this->limit = $this->first_record - 1 . "," . $rows_per_page;
$this->page = $this->rows_per_page < $this->total_rows ? $this->page : 1;
// Row message: Displaying x - y of z records...
$this->row_message = $this->total_rows > 0 ? "Showing " . $this->first_record . " - " . $this->last_record . " of " . $this->total_rows . " rows." : "<font style='color:red'>No records found.</font>";
$this->row_message_class = $this->total_rows > 0 ? "ui-state-success" : "ui-state-error";
}
