function draw() { global $display; $list_faq = Faq::get_collection(null, null, " sort ASC"); $list_faq = Util::removeKey($list_faq); $display->add('list_faq', $list_faq); $display->output('Support'); $this->endForm(); }
function draw() { global $display; $this->beginForm(false, 'post', false, Url::build_current(array('cmd' => 'list_faq'))); $filter_name = trim(Url::get('filter_name')); $filter_id = intval(trim(Url::get('filter_id'))); $filter_active = intval(trim(Url::get('filter_active'))); $faq_ids = Url::get('banner_ids'); if (!empty($faq_ids) && !empty($bulk_action)) { $faq_ids = implode(',', $faq_ids); switch ($bulk_action) { case '1': $query = 'UPDATE faq SET is_active = 1 WHERE id IN (' . $faq_ids . ')'; DB::query($query); break; case '2': $query = 'UPDATE faq SET is_active = 0 WHERE id IN (' . $faq_ids . ')'; DB::query($query); break; case '3': $query = 'DELETE FROM faq WHERE id IN (' . $faq_ids . ')'; DB::query($query); break; } if (isset($query)) { DB::query($query); } } $cond = array(); if (!empty($filter_id)) { $cond[] = 'id LIKE "%' . $filter_id . '%"'; $display->add('filter_id', $filter_id); } if (!empty($filter_name)) { $cond[] = 'name LIKE "%' . $filter_name . '%" '; $display->add('filter_name', $filter_name); } if (!empty($_POST)) { switch ($filter_active) { case 0: $cond[] = ' is_active = ' . $filter_active; break; case 1: $cond[] = ' is_active = ' . $filter_active; break; default: break; } $display->add('filter_active', $filter_active); } else { $display->add('filter_active', 2); } $item_per_page = 50; $cond = EClassApi::analyze_conditions($cond); $list_faq = array(); $paging = ''; $total_row = Faq::count_all($cond); if ($total_row) { require_once ROOT_PATH . 'core/ECPagging.php'; $limit = ''; $paging = ECPagging::pagingSE($limit, $total_row, $item_per_page, 10, 'page_no', true); $list_faq = Faq::get_collection($limit, $cond, ' ORDER BY question ASC'); } $error_message = $this->getErrorMessage('admin/faq/error'); $display->add('error_message', $error_message); $display->add('paging', $paging); $display->add('list_faq', $list_faq); $display->output('List'); $this->endForm(); }