public static function sai_mod__SYSTEM_SAI_saimod_sys_cron() { $vars['content'] = ''; $vars['last_visit'] = \SYSTEM\time::time_ago_string(strtotime(\SYSTEM\CRON\cron::last_visit())); $res = \SYSTEM\SQL\SYS_SAIMOD_CRON::QQ(); $i = 0; while ($r = $res->next()) { $r['selected_0'] = $r['selected_1'] = $r['selected_2'] = $r['selected_3'] = ''; $r['next'] = date('Y-m-d H:i:s', \SYSTEM\CRON\cron::next($r['class'])); $r['selected_' . $r['status']] = 'selected'; $r['i'] = $i++; $vars['content'] .= \SYSTEM\PAGE\replace::replaceFile((new \SYSTEM\PSAI('modules/saimod_sys_cron/tpl/list_entry.tpl'))->SERVERPATH(), $r); } $vars = array_merge($vars, \SYSTEM\PAGE\text::tag(\SYSTEM\SQL\system_text::TAG_SAI_CRON), \SYSTEM\PAGE\text::tag(\SYSTEM\SQL\system_text::TAG_TIME)); return \SYSTEM\PAGE\replace::replaceFile((new \SYSTEM\PSAI('modules/saimod_sys_cron/tpl/tabs.tpl'))->SERVERPATH(), $vars); }
public static function sai_mod__SYSTEM_SAI_saimod_sys_log_action_filter($filter = "%", $search = "%", $page = 0) { $filter = str_replace('\\', '\\\\', $filter); $count = \SYSTEM\SQL\SYS_SAIMOD_LOG_FILTER_COUNT::Q1(array($filter, $search, $search, $search))['count']; $vars = array(); $vars['filter'] = $filter; $vars['search'] = $search; $vars['page'] = $page; $res = \SYSTEM\SQL\SYS_SAIMOD_LOG_FILTER::QQ(array($filter, $search, $search, $search)); $vars['table'] = ''; $count_filtered = 0; $res->seek(100 * $page); while (($r = $res->next()) && $count_filtered < 100) { $r['class_row'] = self::tablerow_class($r['class']); $r['time'] = \SYSTEM\time::time_ago_string(strtotime($r['time'])); $r['message'] = htmlspecialchars(substr($r['message'], 0, 255)); $r['request_uri'] = htmlspecialchars($r['request_uri']); $vars['table'] .= \SYSTEM\PAGE\replace::replaceFile((new \SYSTEM\PSAI('modules/saimod_sys_log/tpl/saimod_sys_log_table_row.tpl'))->SERVERPATH(), $r); $count_filtered++; } $vars['pagination'] = ''; $vars['page_last'] = ceil($count / 100) - 1; for ($i = 0; $i < ceil($count / 100); $i++) { $data = array('page' => $i, 'search' => $search, 'filter' => $filter, 'active' => $i == $page ? 'active' : ''); $vars['pagination'] .= \SYSTEM\PAGE\replace::replaceFile((new \SYSTEM\PSAI('modules/saimod_sys_log/tpl/saimod_sys_log_pagination.tpl'))->SERVERPATH(), $data); } $vars['count'] = $count_filtered . '/' . $count; $vars['error_filter'] = ''; $res = \SYSTEM\SQL\SYS_SAIMOD_LOG_FILTERS::QQ(); while ($row = $res->next()) { $data = array('active' => $filter == $row['class'] ? 'active' : '', 'filter' => $row['class'], 'search' => $search); $vars['error_filter'] .= \SYSTEM\PAGE\replace::replaceFile((new \SYSTEM\PSAI('modules/saimod_sys_log/tpl/saimod_sys_log_error_filter.tpl'))->SERVERPATH(), $data); } $vars['active'] = $filter == '%' ? 'active' : ''; $vars = array_merge($vars, \SYSTEM\PAGE\text::tag(\SYSTEM\SQL\system_text::TAG_SAI_LOG)); return \SYSTEM\PAGE\replace::replaceFile((new \SYSTEM\PSAI('modules/saimod_sys_log/tpl/saimod_sys_log_filter.tpl'))->SERVERPATH(), $vars); }
public static function sai_mod__SYSTEM_SAI_saimod_sys_security_action_users($filter = "all", $search = "%", $page = 0) { $count = $filter == "all" ? \SYSTEM\SQL\SYS_SAIMOD_SECURITY_USER_COUNT::Q1(array($search, $search))['count'] : \SYSTEM\SQL\SYS_SAIMOD_SECURITY_USER_COUNT_FILTER::Q1(array($search, $search, $filter))['count']; $vars = array(); $vars['filter'] = $filter; $vars['search'] = $search; $vars['page'] = $page; $vars['table'] = ''; $res = $filter == "all" ? \SYSTEM\SQL\SYS_SAIMOD_SECURITY_USERS::QQ(array($search, $search)) : \SYSTEM\SQL\SYS_SAIMOD_SECURITY_USERS_FILTER::QQ(array($search, $search, $filter)); $count_filtered = 0; $res->seek(100 * $page); while (($r = $res->next()) && $count_filtered < 100) { $r['class'] = self::tablerow_class($r['last_active']); $r['time_elapsed'] = \SYSTEM\time::time_ago_string($r['last_active']); $vars['table'] .= \SYSTEM\PAGE\replace::replaceFile((new \SYSTEM\PSAI('modules/saimod_sys_security/tpl/saimod_sys_security_user.tpl'))->SERVERPATH(), $r); $count_filtered++; } $vars['pagination'] = ''; $vars['page_last'] = ceil($count / 100) - 1; for ($i = 0; $i < ceil($count / 100); $i++) { $data = array('page' => $i, 'search' => $search, 'filter' => $filter, 'active' => $i == $page ? 'active' : ''); $vars['pagination'] .= \SYSTEM\PAGE\replace::replaceFile((new \SYSTEM\PSAI('modules/saimod_sys_security/tpl/saimod_sys_security_pagination.tpl'))->SERVERPATH(), $data); } $vars['count'] = $count_filtered . '/' . $count; $vars['right_filter'] = ''; $res = \SYSTEM\SQL\SYS_SAIMOD_SECURITY_RIGHTS::QQ(); while ($row = $res->next()) { $data = array('active' => $filter == $row['ID'] ? 'active' : '', 'filter' => $row['ID'], 'search' => $search, 'name' => $row['name']); $vars['right_filter'] .= \SYSTEM\PAGE\replace::replaceFile((new \SYSTEM\PSAI('modules/saimod_sys_security/tpl/saimod_sys_security_right_filter.tpl'))->SERVERPATH(), $data); } $vars['active'] = $filter == 'all' ? 'active' : ''; $vars = array_merge($vars, \SYSTEM\PAGE\text::tag(\SYSTEM\SQL\system_text::TAG_SAI_SECURITY)); return \SYSTEM\PAGE\replace::replaceFile((new \SYSTEM\PSAI('modules/saimod_sys_security/tpl/saimod_sys_security_users.tpl'))->SERVERPATH(), $vars); }
private static function generate_list($state, $filter, $search, $page) { $vars = array(); $vars['filter'] = $filter; $vars['search'] = $search; $vars['page'] = $page; $search = $search; $vars['todo_list_elements'] = $vars['filter_mine'] = $vars['filter_free'] = $vars['filter_others'] = $vars['filter_gen'] = $vars['filter_user'] = $vars['filter_report'] = ''; $userid = \SYSTEM\SECURITY\Security::getUser()->id; switch ($filter) { case 'mine': $count = \SYSTEM\SQL\SYS_SAIMOD_TODO_COUNT_MINE::Q1(array($state, $userid, $search, $search, $search))['count']; $res = \SYSTEM\SQL\SYS_SAIMOD_TODO_LIST_MINE::QQ(array($state, $userid, $search, $search, $search)); $vars['filter_mine'] = 'active'; break; case 'free': $count = \SYSTEM\SQL\SYS_SAIMOD_TODO_COUNT_FREE::Q1(array($state, $search, $search, $search))['count']; $res = \SYSTEM\SQL\SYS_SAIMOD_TODO_LIST_FREE::QQ(array($state, $search, $search, $search)); $vars['filter_free'] = 'active'; break; case 'others': $count = \SYSTEM\SQL\SYS_SAIMOD_TODO_COUNT_OTHERS::Q1(array($state, $userid, $search, $search, $search))['count']; $res = \SYSTEM\SQL\SYS_SAIMOD_TODO_LIST_OTHERS::QQ(array($state, $userid, $search, $search, $search)); $vars['filter_others'] = 'active'; break; case 'gen': $count = \SYSTEM\SQL\SYS_SAIMOD_TODO_COUNT_TYPE::Q1(array($state, \SYSTEM\SQL\system_todo::FIELD_TYPE_EXCEPTION, $search, $search, $search))['count']; $res = \SYSTEM\SQL\SYS_SAIMOD_TODO_LIST_TYPE::QQ(array($state, \SYSTEM\SQL\system_todo::FIELD_TYPE_EXCEPTION, $search, $search, $search, $userid)); $vars['filter_gen'] = 'active'; break; case 'user': $count = \SYSTEM\SQL\SYS_SAIMOD_TODO_COUNT_TYPE::Q1(array($state, \SYSTEM\SQL\system_todo::FIELD_TYPE_USER, $search, $search, $search))['count']; $res = \SYSTEM\SQL\SYS_SAIMOD_TODO_LIST_TYPE::QQ(array($state, \SYSTEM\SQL\system_todo::FIELD_TYPE_USER, $search, $search, $search, $userid)); $vars['filter_user'] = '******'; break; case 'report': $count = \SYSTEM\SQL\SYS_SAIMOD_TODO_COUNT_TYPE::Q1(array($state, \SYSTEM\SQL\system_todo::FIELD_TYPE_REPORT, $search, $search, $search))['count']; $res = \SYSTEM\SQL\SYS_SAIMOD_TODO_LIST_TYPE::QQ(array($state, \SYSTEM\SQL\system_todo::FIELD_TYPE_REPORT, $search, $search, $search, $userid)); $vars['filter_report'] = 'active'; break; default: $count = \SYSTEM\SQL\SYS_SAIMOD_TODO_COUNT::Q1(array($state, $search, $search, $search))['count']; $res = \SYSTEM\SQL\SYS_SAIMOD_TODO_LIST::QQ(array($state, $search, $search, $search, $userid)); $vars['filter_all'] = 'active'; break; } $count_filtered = 0; $res->seek(100 * $page); while (($row = $res->next()) && $count_filtered < 100) { $row['class_row'] = self::trclass($row['type'], $row['class'], $row['assignee_id'], $userid); $row['time_elapsed'] = \SYSTEM\time::time_ago_string(strtotime($row['time'])); $row['state_string'] = self::state($row['count']); $row['state_btn'] = self::statebtn($row['count']); $row['message'] = $row['message']; $row['request_uri'] = htmlspecialchars($row['request_uri']); $row['openclose'] = $state == \SYSTEM\SQL\system_todo::FIELD_STATE_OPEN ? 'close' : 'open'; $row['message'] = str_replace("\n", '<br/>', $row['message']); $vars['todo_list_elements'] .= \SYSTEM\PAGE\replace::replaceFile((new \SYSTEM\PSAI('modules/saimod_sys_todo/tpl/todo_user_list_element.tpl'))->SERVERPATH(), $row); $count_filtered++; } $vars['pagination'] = ''; $vars['page_last'] = ceil($count / 100) - 1; for ($i = 0; $i < ceil($count / 100); $i++) { $data = array('page' => $i, 'search' => $search, 'filter' => $filter, 'active' => $i == $page ? 'active' : ''); $vars['pagination'] .= \SYSTEM\PAGE\replace::replaceFile((new \SYSTEM\PSAI('modules/saimod_sys_todo/tpl/todo_list_pagination.tpl'))->SERVERPATH(), $data); } $vars['count'] = $count_filtered . '/' . $count; $vars['state'] = $state == \SYSTEM\SQL\system_todo::FIELD_STATE_OPEN ? 'todo' : 'todo(doto)'; $vars = array_merge($vars, \SYSTEM\PAGE\text::tag(\SYSTEM\SQL\system_text::TAG_SAI_TODO)); return \SYSTEM\PAGE\replace::replaceFile((new \SYSTEM\PSAI('modules/saimod_sys_todo/tpl/todo_list.tpl'))->SERVERPATH(), $vars); }