function change_item()
{
$filter_type = Url::get('filter_type');
if ($filter_type == 1) {
$result = Lessons::get_collection_with_join(null);
}
if ($filter_type == 0) {
$result = Classes::get_collection_with_join(null);
}
$html = "";
if ($result) {
foreach ($result as $row) {
if ($row['name'] != '' && $row['subject_type'] == 1) {
$html .= '<option value="' . $row['id'] . '">' . $row['id'] . '. ' . $row['name'] . '</option>';
}
}
}
echo $html;
exit;
}
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();
}
