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();
}
function draw()
{
global $display;
// $this->beginForm(false, 'post', false, Url::build_current(array('cmd' => 'list_log')));
$filter_id = intval(trim(Url::get('filter_id')));
$filter_type = intval(trim(Url::get('filter_type')));
$display->add('from_time', Url::get('from_time'));
$display->add('to_time', Url::get('to_time'));
$cond = array();
if (!empty($filter_id)) {
$cond[] = 'a.id LIKE "' . $filter_id . '"';
$display->add('filter_id', $filter_id);
}
$from_time = 0;
$to_time = 0;
if (Url::get('from_time')) {
$date_arr = explode('/', Url::get('from_time'));
if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) {
$from_time = EClassApi::render_time($date_arr[1] . '/' . $date_arr[0] . '/' . (int) $date_arr[2], 0);
}
}
if (Url::get('to_time')) {
$date_arr = explode('/', Url::get('to_time'));
if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) {
$to_time = EClassApi::render_time($date_arr[1] . '/' . $date_arr[0] . '/' . (int) $date_arr[2], 1);
}
}
if ($from_time) {
$cond[] = ' `time` >= ' . $from_time;
}
if ($to_time) {
$cond[] = ' `time` <= ' . $to_time;
}
$cond[] = ' type_id = -1 ';
$item_per_page = 50;
$cond = EClassApi::analyze_conditions($cond);
$list_log = array();
$paging = '';
$total_row = Logs::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_log = Logs::get_collection($limit, $cond, ' ORDER BY id DESC');
foreach ($list_log as $k => $l) {
$l['data'] = unserialize($l['data']);
if ($l['data']['type'] != 'VIP') {
if (isset($l['data']['status'])) {
if ($l['data']['status'] == '00') {
$list_log[$k]['status'] = 1;
} else {
$list_log[$k]['status'] = 0;
}
} else {
$list_log[$k]['status'] = 0;
}
if (!empty($l['data']['status'])) {
$list_log[$k]['fail'] = 0;
} else {
$list_log[$k]['fail'] = 1;
}
} else {
$list_log[$k]['status'] = 1;
$list_log[$k]['fail'] = 0;
}
$list_log[$k]['data'] = $l['data'];
}
}
$display->add('paging', $paging);
$display->add('list_log', $list_log);
$display->add('is_admin', User::is_admin());
$display->add('is_root', User::is_root());
$display->output('ListCoin');
// $this->endForm();
}
function draw()
{
$user_ids = Url::get('id');
global $display;
// $this->beginForm(false, 'post', false, Url::build_current(array('cmd' => 'history_lesson')));
$filter_id = intval(trim(Url::get('filter_id')));
$sid = intval(trim(Url::get('subject')));
$display->add('from_time', Url::get('from_time'));
$display->add('to_time', Url::get('to_time'));
$display->add('subject', $sid);
$list_subject = Subjects::get_collection(null);
if (!empty($sid)) {
$list_lesson = Lessons::get_collection(null, ' subject = ' . $sid);
} else {
$list_lesson = Lessons::get_collection(null);
}
$display->add('list_subject', $list_subject);
$display->add('list_lesson', $list_lesson);
$cond = array();
if (!empty($filter_id)) {
$cond[] = 'id LIKE "%' . $filter_id . '%"';
$display->add('filter_id', $filter_id);
}
$from_time = 0;
$to_time = 0;
if (Url::get('from_time')) {
$date_arr = explode('/', Url::get('from_time'));
if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) {
$from_time = EClassApi::render_time($date_arr[1] . '/' . $date_arr[0] . '/' . (int) $date_arr[2], 0);
}
}
if (Url::get('to_time')) {
$date_arr = explode('/', Url::get('to_time'));
if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) {
$to_time = EClassApi::render_time($date_arr[1] . '/' . $date_arr[0] . '/' . (int) $date_arr[2], 1);
}
}
if ($from_time) {
$cond[] = ' `time` >= ' . $from_time;
}
if ($to_time) {
$cond[] = ' `time` <= ' . $to_time;
}
$cond[] = 'uid = ' . $user_ids;
$cond[] = 'type_id = 1';
$str_lesson = '';
foreach ($list_lesson as $lesson) {
$str_lesson .= $str_lesson == '' ? $lesson['id'] : ', ' . $lesson['id'];
}
$cond[] = ' object_id IN (' . $str_lesson . ') ';
$item_per_page = 50;
$cond = EClassApi::analyze_conditions($cond);
$list_user_log = array();
$paging = '';
$total_row = Logs::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_user_log = Logs::get_collection($limit, $cond, 'ORDER BY id DESC');
}
$error_message = $this->getErrorMessage('admin/category/error');
$display->add('error_message', $error_message);
$display->add('paging', $paging);
$display->add('user_ids', $user_ids);
$display->add('list_user_log', $list_user_log);
$display->add('is_admin', User::is_admin());
$display->output('history');
// $this->endForm();
}
function draw()
{
global $display;
// $this->beginForm(false, 'post', false, Url::build_current(array('cmd' => 'list_log')));
$filter_id = intval(trim(Url::get('filter_id')));
$filter_type = intval(trim(Url::get('filter_type')));
$type_id = intval(trim(Url::get('type_id')));
$cid = intval(trim(Url::get('cid')));
$display->add('cid', $cid);
$display->add('type_id', $type_id);
$display->add('from_time', Url::get('from_time'));
$display->add('to_time', Url::get('to_time'));
$cond = array();
if (!empty($filter_id)) {
$cond[] = 'a.id LIKE "' . $filter_id . '"';
$display->add('filter_id', $filter_id);
}
if (!empty($filter_type)) {
switch ($filter_type) {
case 1:
$cond[] = ' type_id = ' . $filter_type;
break;
case 2:
$cond[] = ' type_id = ' . $filter_type;
break;
case 0:
$cond[] = ' type_id = ' . $filter_type;
break;
default:
// $cond[] = ' type_id = 0';
break;
}
$display->add('filter_type', $filter_type);
} else {
$cond[] = ' type_id = 0';
$display->add('filter_type', 0);
}
if (!empty($type_id) && $type_id != 0) {
$cond[] = 'object_id = ' . $type_id;
if (!empty($cid)) {
$cond[] = ' (CONCAT(",", class_id, ",") LIKE "%,' . $cid . ',%") ';
}
}
$from_time = 0;
$to_time = 0;
if (Url::get('from_time')) {
$date_arr = explode('/', Url::get('from_time'));
if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) {
$from_time = EClassApi::render_time($date_arr[1] . '/' . $date_arr[0] . '/' . (int) $date_arr[2], 0);
}
}
if (Url::get('to_time')) {
$date_arr = explode('/', Url::get('to_time'));
if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) {
$to_time = EClassApi::render_time($date_arr[1] . '/' . $date_arr[0] . '/' . (int) $date_arr[2], 1);
}
}
if ($from_time) {
$cond[] = ' `time` >= ' . $from_time;
}
if ($to_time) {
$cond[] = ' `time` <= ' . $to_time;
}
$item_per_page = 50;
$cond = EClassApi::analyze_conditions($cond);
$list_log = array();
$paging = '';
$total_row = Logs::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_log = Logs::get_collection($limit, $cond, ' ORDER BY id DESC');
}
$list_class = Classes::get_collection_with_join(null);
$list_lesson = Lessons::get_collection_with_join(null);
$list_exam = Exam::get_collection(null);
$error_message = $this->getErrorMessage('admin/log/error');
$display->add('error_message', $error_message);
$display->add('paging', $paging);
$display->add('list_log', $list_log);
$display->add('list_class', $list_class);
$display->add('list_lesson', $list_lesson);
$display->add('list_exam', $list_exam);
$display->add('is_admin', User::is_admin());
$display->output('ListLog');
// $this->endForm();
}
function draw()
{
global $display;
// $this->beginForm(false, 'post', false, Url::build_current(array('cmd' => 'list_log')));
$filter_id = intval(trim(Url::get('filter_id')));
$cid = intval(trim(Url::get('cid')));
$display->add('cid', $cid);
$display->add('from_time', Url::get('from_time'));
$display->add('to_time', Url::get('to_time'));
$cond = array();
if (!empty($filter_id)) {
$cond[] = 'a.id LIKE "' . $filter_id . '%"';
$display->add('filter_id', $filter_id);
}
if (!empty($cid)) {
$cond[] = 'cid = ' . $cid;
}
$from_time = 0;
$to_time = 0;
if (Url::get('from_time')) {
$date_arr = explode('/', Url::get('from_time'));
if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) {
$from_time = EClassApi::render_time($date_arr[1] . '/' . $date_arr[0] . '/' . (int) $date_arr[2], 0);
}
}
if (Url::get('to_time')) {
$date_arr = explode('/', Url::get('to_time'));
if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) {
$to_time = EClassApi::render_time($date_arr[1] . '/' . $date_arr[0] . '/' . (int) $date_arr[2], 1);
}
}
if ($from_time) {
$cond[] = ' `time` >= ' . $from_time;
}
if ($to_time) {
$cond[] = ' `time` <= ' . $to_time;
}
// if (intval(date('d')) < 5)
// $month = date('n');
// else
// $month= date('n', strtotime('+1 month'));
$month = date('n');
$cond[] = 'month = ' . $month;
$item_per_page = 50;
$cond = EClassApi::analyze_conditions($cond);
$list_extend = array();
$paging = '';
$total_row = PersonalDB::count_all_paid($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_extend = PersonalDB::get_student_paid($limit, $cond, ' ORDER BY uid DESC');
}
foreach ($list_extend as $extend) {
$time = date('H:i:s d/m/Y', $extend['time']);
$list_extend[$extend['id']]['time'] = $time;
}
$list_class = Classes::get_collection_with_join(null);
$error_message = $this->getErrorMessage('admin/log/error');
$display->add('error_message', $error_message);
$display->add('paging', $paging);
$display->add('list_extend', $list_extend);
$display->add('list_class', $list_class);
$display->add('is_admin', User::is_admin());
$display->output('Extend');
// $this->endForm();
}
function preview_teacher_log()
{
header('Content-Type: text/html; charset=utf-8');
global $display;
$anchor_index = intval(Url::get('anchor_index', 0));
$tid = intval(Url::get('tid', 0));
$cid = intval(Url::get('cid', 0));
$lid = intval(Url::get('lid', 0));
$from_time = 0;
$to_time = 0;
$cond = array();
if (Url::get('from_time')) {
$date_arr = explode('/', Url::get('from_time'));
if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) {
$from_time = EClassApi::render_time($date_arr[1] . '/' . $date_arr[0] . '/' . (int) $date_arr[2], 0);
}
}
if (Url::get('to_time')) {
$date_arr = explode('/', Url::get('to_time'));
if (isset($date_arr[0]) && isset($date_arr[1]) && isset($date_arr[2])) {
$to_time = EClassApi::render_time($date_arr[1] . '/' . $date_arr[0] . '/' . (int) $date_arr[2], 1);
}
}
if ($from_time) {
$cond[] = ' `time` >= ' . $from_time;
}
if ($to_time) {
$cond[] = ' `time` <= ' . $to_time;
}
if ($cid) {
$cond[] = ' cid= ' . $cid;
}
if ($lid) {
$cond[] = ' lid= ' . $lid;
}
$cond[] = ' tid=' . $tid;
$cond = EClassApi::analyze_conditions($cond);
if ($anchor_index == 0) {
$list_logs = Classes::get_list_teacher_log(' LIMIT ' . $anchor_index * 9 . ', 9', $cond, 'ORDER BY id DESC');
$is_preview = 0;
} else {
$list_logs = Classes::get_list_teacher_log(' LIMIT ' . $anchor_index * 9 . ', 10', $cond, 'ORDER BY id DESC');
if (count($list_logs) == 10) {
$is_preview = 1;
array_pop($list_logs);
} else {
$is_preview = 0;
}
if (empty($list_logs)) {
exit;
}
}
$list_class = Classes::get_collection(null);
$list_lesson = Lessons::get_collection(null);
$list_user = User::get_collection(null);
$is_next = 1;
$display->add('list_class', $list_class);
$display->add('list_lesson', $list_lesson);
$display->add('list_user', $list_user);
$display->add('list_logs', $list_logs);
$display->add('anchor_index', $anchor_index);
$display->add('is_next', $is_next);
$display->add('is_preview', $is_preview);
$display->output('Personal/ajax/Next');
exit;
}
