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();
}
