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