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