function get_io_id($id) { if ($id > 0) { $rubrics = new collection(); $rubrics->Load(TABLE_RUBRICATOR, false, $where); $rubrics = $rubrics->_collection; for ($i = 0; $i < count($rubrics); $i++) { if ($id == $rubrics[$i]->id) { if ($rubrics[$i]->id_io_object > 0) { return $rubrics[$i]->id_io_object; } else { if ($rubrics[$i]->id_parent > 0) { return get_io_id($rubrics[$i]->id_parent); } else { return 0; } } } } return 0; } else { return 0; } }
} if ($save) { if ($_REQUEST['io_id'] > 0 && $_REQUEST['cat_id'] > 0) { $io_rub = new io_rubricator(); $io_rub->id_rubric = $_REQUEST['cat_id']; $io_rub->id_io_object = $io_id; $io_rub->Save(); } } if ($_REQUEST['cat_id'] > 0) { $rubricator = new rubricator(); $rubricator->id = $_REQUEST['cat_id']; $rubricator->Load(); $db = db_class::get_instance(); $query = 'SELECT id_io_object as id FROM ' . TABLE_IO_RUBRICATOR . ' WHERE id_rubric=' . $rubricator->id; $db->query($query); $id = ''; for ($i = 0; $i < count($db->value); $i++) { $id = $db->value[$i]['id']; $where[] = " ID !=" . $id; } if ($rubricator->id_io_category > 0) { $where[] = 'id_io_category = ' . $rubricator->id_io_category . ' '; } } $contact_persons = new collection(); $contact_persons->Load(TABLE_OBJECTS, false, join(' AND ', $where), '"' . $sort . '" ' . $sort_dir); $contact_persons = $contact_persons->_collection; $additional_vars = ($letter != '' ? 'letter/' . urlencode($letter) . '/' : '') . ($pattern != '' ? 'letter/' . urlencode($pattern) . '/' : '') . 'callback/' . urlencode($_REQUEST['callback']); include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/' . $STORAGE['action'] . '.php'; include SITE_FILE_ROOT . 'template/simple_footer.php';
if ($io_object->id > 0) { $query = 'SELECT * FROM ioinsertemptyrecord(' . $io_object->id . ',\'' . $io_object->table_name . '\');'; $db->query($query); //echo $query; $set_empty = true; } } //echo "TYPE ATR: ".$type_attribute; //types attributes //id value description //1 't' 'f' logical //2 int4 element of list - use table_name and column_name - receive id //3 int4 element of list - use table samesalfe //4 date - ex 1999-01-08 YYYY-MM-DD //5 timestamp - ex 1999-01-08 04:05:08 //6 float - ex 8.999 //7 dont do - infirm user!!! //8 int4 - min int - max int if ($save) { $db = db_class::get_instance(); $db->begin(); $query = 'UPDATE ' . $table_name . ' SET ' . $name . ' = \'' . $value . '\' WHERE id=' . $rec_id; $db->query($query); $db->commit(); } $names = new collection(); $names->Load(TABLE_ATTRIBUTES, false, $where, 'name ASC'); $names = $names->_collection; include SITE_FILE_ROOT . 'template/simple_header.php'; include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/' . $STORAGE['action'] . '.php'; include SITE_FILE_ROOT . 'template/simple_footer.php';
$rubricator->id_search_template = $templ_id; if ($rubricator->id_parent === 0) { $rubricator->id_parent = null; } if ($rubricator->id_io_object === 0) { $rubricator->id_io_object = null; } if ($rubricator->id_io_category === 0) { $rubricator->id_io_category = null; } if ($rubricator->id_search_template === 0) { $rubricator->id_search_template = null; } $rubricator->name = $name; $rubricator->code = $code; $rubricator->description = $description; $errors = $rubricator->IsValidData(); if (count($errors) == 0) { $rubricator->Save(); } } else { $categories = new collection(); $categories->Load(TABLE_CATEGORIES, false, $where, 'name ASC'); $categories = $categories->_collection; $templates = new collection(); $templates->Load(TABLE_SEARCH_TEMPLATES, false, $where, 'name ASC'); $templates = $templates->_collection; } include SITE_FILE_ROOT . 'template/header.php'; include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/' . $STORAGE['action'] . '.php'; include SITE_FILE_ROOT . 'template/footer.php';
<?php $page_title = 'Выбор сотрудника'; include SITE_FILE_ROOT . 'template/simple_header.php'; $sort = 'name'; $sort_dir = 'asc'; $pattern = get_request_variable('pattern', ''); $letter = get_request_variable('letter', ''); $dept_id = get_request_variable('dept_id', ''); $_REQUEST['callback'] = get_request_variable('callback', ''); $where = array(); if ($pattern != '') { $where[] = '"name" LIKE \'%' . db_class::escape_like($pattern) . '%\''; $letter = ''; } elseif ($letter != '') { $where[] = '"name" LIKE \'' . db_class::escape_like($letter) . '%\''; } elseif ($dept_id != '') { $where[] = '"department_id" = ' . $dept_id; $letter = ''; } $where[] = '"active_flag"=\'yes\''; $contact_persons = new collection(); $contact_persons->Load(TABLE_EMPLOYEE, false, join(' AND ', $where), '"' . $sort . '" ' . $sort_dir); $contact_persons = $contact_persons->_collection; $additional_vars = ($letter != '' ? 'letter/' . urlencode($letter) . '/' : '') . ($pattern != '' ? 'letter/' . urlencode($pattern) . '/' : '') . 'callback/' . urlencode($_REQUEST['callback']); include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/' . $STORAGE['action'] . '.php'; include SITE_FILE_ROOT . 'template/simple_footer.php';
<?php include SITE_FILE_ROOT . 'template/header.php'; $enable_sort_fields = array('id_role', 'name'); $from = intval(get_request_variable('from', 0)); $sort = get_request_variable('sort', 'name'); $sort_dir = get_request_variable('sort_dir', 'asc'); if (array_search($sort, $enable_sort_fields) === false) { $sort = 'name'; } if (array_search($sort_dir, $convert_sort_dirs) === false) { $sort_dir = 'asc'; } $additional_vars = 'sort/' . urlencode($sort) . '/sort_dir/' . urlencode($sort_dir); $roles = new collection(); $all_num = $roles->Load(TABLE_ROLE, true, '', '"' . $sort . '" ' . $sort_dir, $from, LIMIT_ROLES_ON_PAGE); $page_break = get_page_break(SITE_URI_ROOT . $STORAGE['module'] . '/' . $STORAGE['action'] . '/', $all_num, $from, LIMIT_ROLES_ON_PAGE, LIMIT_PAGE_ON_PAGE, $additional_vars); include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/' . $STORAGE['action'] . '.php'; include SITE_FILE_ROOT . 'template/footer.php';
$categories->id = null; $childs = $categories->ChildExists(); echo '<tree id="root">' . "\n"; echo '<item text="ККС СИТО" id="0" child="' . ($childs ? 1 : 0) . '"></item>'; echo '</tree>' . "\n"; } else { $type_collection = new collection(); $type_collection->Load(TABLE_CATEGORIES, false, $id > 0 ? 'id=' . $id . ' AND is_main=TRUE' : 'is_main=TRUE', ' name ASC'); echo '<tree id="' . $id . '">' . "\n"; for ($i = 0; $i < count($type_collection->_collection); $i++) { $childs = $type_collection->_collection[$i]->ChildExists(); if ($id == 0) { echo '<item child="' . ($childs ? 1 : 0) . '" id="' . $type_collection->_collection[$i]->id . '" text="' . escape($type_collection->_collection[$i]->name) . '" im0="folderOpen.gif" im1="folderOpen.gif" im2="folderClosed.gif">'; } if ($childs == true) { $child = $type_collection->_collection[$i]->id_child; if ($child > 0 && $id > 0) { $type_coll = new collection(); $type_coll->Load(TABLE_CATEGORIES, false, 'id=' . $child, 'name ASC'); for ($j = 0; $j < count($type_coll->_collection); $j++) { echo '<item child="0" id="' . $type_coll->_collection[$j]->id . '" text="' . escape($type_coll->_collection[$j]->name) . '" >'; echo '</item>'; } } } if ($id == 0) { echo '</item>'; } } echo '</tree>' . "\n"; }
if (!ereg("[0-9]{4}-[0-9]{2}-[0-9]{2}", $pattern)) { $pattern_flag = false; } if ($pattern != '' && $pattern_flag == true) { $query = 'SELECT COUNT(*) AS num FROM io_objects WHERE date(insert_time) = \'' . db_class::escape_like($pattern) . '\';'; } else { $query = 'SELECT COUNT(*) AS num FROM io_objects;'; } //echo $query; $db->query($query); $all_num = $db->value[0]['num']; $coms = array(); if ($all_num > 0) { if ($pattern != '' && $pattern_flag == true) { $query = 'SELECT * FROM io_objects WHERE date(insert_time) = \'' . db_class::escape_like($pattern) . '\' ORDER BY "' . $sort . '" ' . $sort_dir . ' LIMIT ' . LIMIT_COMPANY_ON_PAGE . ';'; } else { $query = 'SELECT * FROM io_objects ORDER BY "' . $sort . '" ' . $sort_dir . ' LIMIT ' . LIMIT_COMPANY_ON_PAGE . ' OFFSET ' . $from . ';'; } $db->query($query); $coms = $db->value; } $cats = new collection(); $cats->Load(TABLE_CATEGORIES, false, $where, 'name ASC'); $cats = $cats->_collection; $users = new collection(); $users->Load(TABLE_USERS, false, $where, 'fio ASC'); $users = $users->_collection; $page_break = get_page_break(SITE_URI_ROOT . $STORAGE['module'] . '/' . $STORAGE['action'] . '/', $all_num, $from, LIMIT_COMPANY_ON_PAGE, LIMIT_PAGE_ON_PAGE, $additional_vars); include SITE_FILE_ROOT . 'template/header.php'; include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/view.php'; include SITE_FILE_ROOT . 'template/footer.php';
$where[] = 'employee_id IN (' . join(',', $arr) . ')'; } $report_employees = array_flip($report_employees); $arr = array_flip($arr); if (count($where) > 0) { $query = 'SELECT COUNT(*) AS num FROM `' . TABLE_COMANDIROVKA . '`'; $query .= ' WHERE ' . join(' AND ', $where); } else { $query = 'SELECT COUNT(*) AS num FROM `' . TABLE_COMANDIROVKA . '`'; } $db->query($query); $all_num = $db->value[0]['num']; $coms = array(); if ($all_num > 0) { if (count($where) > 0) { $query = 'SELECT * FROM `' . TABLE_COMANDIROVKA . '`'; $query .= ' WHERE ' . join(' AND ', $where); $query .= ' ORDER BY ' . $sort . ' ' . $sort_dir; $query .= ' LIMIT ' . $from . ',' . LIMIT_COMPANY_ON_PAGE; } else { $query = 'SELECT * FROM `' . TABLE_COMANDIROVKA . '` ORDER BY `' . $sort . '` ' . $sort_dir . ' LIMIT ' . $from . ',' . LIMIT_COMPANY_ON_PAGE; } $db->query($query); $coms = $db->value; } $page_break = get_page_break(SITE_URI_ROOT . $STORAGE['module'] . '/' . $STORAGE['action'] . '/', $all_num, $from, LIMIT_COMPANY_ON_PAGE, LIMIT_PAGE_ON_PAGE, $additional_vars); $all_employees = new collection(); $all_employees->Load(TABLE_EMPLOYEE, false, 'active_flag=\'yes\''); include SITE_FILE_ROOT . 'template/header.php'; include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/' . $STORAGE['action'] . '.php'; include SITE_FILE_ROOT . 'template/footer.php';
$_REQUEST['callback'] = get_request_variable('callback', ''); $department = new department(); $department->id_department = $id; if ($id > 0) { if (!$department->Load()) { $department->id_department = 0; } } $department->parent_id = $parent_id; if ($save) { $department->head_id = $head_id; if ($department->parent_id === 0) { $department->parent_id = null; } if ($department->head_id === 0) { $department->head_id = null; } $department->name = $name; $department->prefix = $prefix; $department->description = $description; $errors = $department->IsValidData(); if (count($errors) == 0) { $department->Save(); } } $employees = new collection(); $employees->Load(TABLE_EMPLOYEE, false, '', 'name ASC'); $employees = $employees->_collection; include SITE_FILE_ROOT . 'template/simple_header.php'; include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/' . $STORAGE['action'] . '.php'; include SITE_FILE_ROOT . 'template/simple_footer.php';
case 'folder': $type_collection = new collection(); $type_collection->Load(TABLE_RUBRICATOR, false, $type_id > 0 ? 'id_parent=' . $type_id : 'id_parent IS NULL AND id_io_object IS NULL', 'name ASC'); $rubricator = new rubricator(); for ($i = 0; $i < count($type_collection->_collection); $i++) { $rubricator->id = $type_collection->_collection[$i]->id; $rubricator->Load(); $childs = $rubricator->ObjectExists(); if (!$childs) { $childs = $rubricator->ChildExists(); } echo '<item child="' . ($childs ? 1 : 0) . '" id="folder-' . $rubricator->id . '" text="' . escape($type_collection->_collection[$i]->name) . '" im0="folderOpen.gif" im1="folderOpen.gif" im2="folderClosed.gif">'; if ($rubricator->ObjectExists()) { if ($type_id > 0) { $agr_collection = new collection(); $agr_collection->Load(TABLE_IO_RUBRICATOR, false, 'id_rubric=' . $rubricator->id, 'id_rubric ASC'); for ($k = 0; $k < count($agr_collection->_collection); $k++) { $io_object = new io_objects(); $io_object->id = $agr_collection->_collection[$k]->id_io_object; $io_object->Load(); echo '<item child="0" id="agreement-' . $agr_collection->_collection[$k]->id_io_object . '" text="' . escape($io_object->name) . '" im0="../csh_books/leaf.gif" ></item>'; } } } echo '</item>'; } break; case 'agreement': break; } echo '</tree>' . "\n";
<?php $page_title = 'Выбор должностей'; include SITE_FILE_ROOT . 'template/simple_header.php'; $sort = 'name'; $sort_dir = 'asc'; $pattern = get_request_variable('pattern', ''); $letter = get_request_variable('letter', ''); $_REQUEST['callback'] = get_request_variable('callback', ''); $where = array(); if ($pattern != '') { $where[] = '"name" LIKE \'%' . db_class::escape_like($pattern) . '%\''; $letter = ''; } else { if ($letter != '') { $where[] = '"name" LIKE \'' . db_class::escape_like($letter) . '%\''; } } $offices = new collection(); $offices->Load(TABLE_OFFICE, false, join(' AND ', $where), '"' . $sort . '" ' . $sort_dir); $offices = $offices->_collection; $additional_vars = ($letter != '' ? 'letter/' . urlencode($letter) . '/' : '') . ($pattern != '' ? 'letter/' . urlencode($pattern) . '/' : '') . 'callback/' . urlencode($_REQUEST['callback']); include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/' . $STORAGE['action'] . '.php'; include SITE_FILE_ROOT . 'template/simple_footer.php';
<?php header("Content-type:text/xml"); $id = get_request_variable('id', 'root'); if ($id != 'root') { $id = intval($id); } $db = db_class::get_instance(); echo '<?xml version="1.0" ?>' . "\n"; if ($id === 'root') { $department = new department(); $department->id_department = null; $childs = $department->ChildExists(); echo '<tree id="root">' . "\n"; echo '<item text="ККС СИТО" id="0" child="' . ($childs ? 1 : 0) . '"></item>'; echo '</tree>' . "\n"; } else { $type_collection = new collection(); $type_collection->Load(TABLE_DEPARMENT, false, $id > 0 ? 'parent_id=' . $id : 'parent_id IS NULL', 'name ASC'); echo '<tree id="' . $id . '">' . "\n"; for ($i = 0; $i < count($type_collection->_collection); $i++) { $childs = $type_collection->_collection[$i]->ChildExists(); echo '<item child="' . ($childs ? 1 : 0) . '" id="' . $type_collection->_collection[$i]->id_department . '" text="' . escape($type_collection->_collection[$i]->name) . '" im0="folderOpen.gif" im1="folderOpen.gif" im2="folderClosed.gif">'; echo '</item>'; } echo '</tree>' . "\n"; }
$type_id = 0; } $type_id = intval($type_id); $db = db_class::get_instance(); echo '<?xml version="1.0" ?>' . "\n"; echo '<tree id="' . $id . '">' . "\n"; switch ($type) { case 'root': $categories = new io_categories(); $categories->id = null; $childs = true; echo '<item text="Категории и шаблоны:" id="folder-0" child="' . ($childs ? 1 : 0) . '"></item>'; break; case 'folder': $type_collection = new collection(); $type_collection->Load(TABLE_CATEGORIES, false, $type_id > 0 ? 'id=' . $type_id : 'is_main = TRUE', 'name ASC'); $cat = new io_categories(); for ($i = 0; $i < count($type_collection->_collection); $i++) { if ($type_id <= 0) { $cat->id = $type_collection->_collection[$i]->id; } else { $cat->id = $type_collection->_collection[$i]->id_child; } $cat->Load(); $childs = $cat->ChildExists(); if ($cat->id > 0) { echo '<item child="' . ($childs ? 1 : 0) . '" id="folder-' . $cat->id . '" text="' . escape($cat->name) . '" im0="folderOpen.gif" im1="folderOpen.gif" im2="folderClosed.gif">'; echo '</item>'; } } break;
$role_actions = array_flip($role_actions); $role_variables = $role->GetRoleVariablesId(); $role_variables = array_flip($role_variables); } } // Получаем все типы дополнительных полей и сами поля $variable = new variable(); $variable_modules = $variable->GetModules(); reset($variable_modules); $variables = array(); while (list($variable_module, $variable_module_name) = each($variable_modules)) { $variable_modules[$variable_module] = array(); $variable_modules[$variable_module]['name'] = $variable_module_name; $variable_modules[$variable_module]['vars'] = array(); $variables = new collection(); $variables->Load(TABLE_VARIABLE, false, '"module"=\'' . db_class::str2base($variable_module) . '\'', '"name" ASC'); $variable_modules[$variable_module]['vars'] = $variables->_collection; } // Получаем все модули и все операции, связанные с ними $modules = new collection(); $modules->Load(TABLE_MODULE, false, '', '"name" ASC'); $modules = $modules->_collection; $module_actions = array(); for ($i = 0; $i < count($modules); $i++) { $module_action_collection = new collection(); $module_action_collection->Load(TABLE_MODULE_ACTION, false, 'module_id=' . $modules[$i]->id_module . ' AND public_flag=\'yes\'', '"name" ASC'); $module_actions[$modules[$i]->id_module] = $module_action_collection->_collection; unset($module_action_collection); } if ($save) { $role_actions = array();
} if (array_search($sort_dir, $convert_sort_dirs) === false) { $sort_dir = 'asc'; } $additional_vars = 'sort/' . urlencode($sort) . '/sort_dir/' . urlencode($sort_dir); $pattern = get_request_variable('pattern', ''); if ($pattern != '') { $query = 'SELECT COUNT(*) AS num FROM iogetlog(' . $id . ') WHERE date(insert_time) \'' . db_class::escape_like($pattern) . '\';'; } else { $query = 'SELECT COUNT(*) AS num FROM iogetlog(' . $id . ');'; } $db->query($query); $all_num = $db->value[0]['num']; $coms = array(); if ($all_num > 0) { if ($pattern != '') { $query = 'SELECT * FROM iogetlog(' . $id . ') WHERE date(insert_time) = \'' . db_class::escape_like($pattern) . '\';'; } else { $query = 'SELECT * FROM iogetlog(' . $id . ') ;'; } $db->query($query); $coms = $db->value; } //TO DO - load operation type from bd $cats = new collection(); $cats->Load(TABLE_CATEGORIES, false, $where, 'name ASC'); $cats = $cats->_collection; $page_break = get_page_break(SITE_URI_ROOT . $STORAGE['module'] . '/' . $STORAGE['action'] . '/', $all_num, $from, LIMIT_COMPANY_ON_PAGE, LIMIT_PAGE_ON_PAGE, $additional_vars); include SITE_FILE_ROOT . 'template/header.php'; include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/logs.php'; include SITE_FILE_ROOT . 'template/footer.php';
} } for ($i = 0; $i < count($STORAGE['menu']); $i++) { if (strpos($STORAGE['menu'][$i]['path'], 'category') !== false) { $menulevel = $STORAGE['menu'][$i]; break; } } $STORAGE['site_path'][] = array('name' => $menulevel['name'], 'path' => $menulevel['path']); $menulevel = $menulevel['childs'][0]; $STORAGE['site_path'][] = array('name' => $menulevel['name'], 'path' => $menulevel['path']); if ($save) { $menulevel = $menulevel['childs'][0]; $STORAGE['site_path'][] = array('name' => $menulevel['name'], 'path' => $menulevel['path']); header('Location:' . SITE_HTTP_ROOT . $STORAGE['site_path'][count($STORAGE['site_path']) - 1]['path']); } else { $cats = new collection(); $cats->Load(TABLE_CATEGORIES, false, $where, 'name ASC'); $cats = $cats->_collection; $childs = new collection(); $childs->Load(TABLE_CATEGORIES, false, "is_main = FALSE", 'name ASC'); $childs = $childs->_collection; $menulevel = $menulevel['childs'][0]; $STORAGE['site_path'][] = array('name' => $menulevel['name'], 'path' => $menulevel['path']); $path_name = 'Редактировать'; $STORAGE['site_path'][] = array('name' => $path_name, 'path' => $STORAGE['request_uri']); $page_title = $path_name; include SITE_FILE_ROOT . 'template/header.php'; include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/' . $STORAGE['action'] . '.php'; include SITE_FILE_ROOT . 'template/footer.php'; }
$errors[] = 'Файл не найден'; } } $errors = array(); if ($save) { if (!$enabled_file_roles) { $errors[] = 'Укажите доступные роли'; } if (!$errors) { $db = db_class::get_instance(); $db->begin(); $file->DeleteFileRoles(); reset($enabled_file_roles); $file_role = new file_role(); $file_role->file_id = $file->id_file; while (list(, $role_id) = each($enabled_file_roles)) { $file_role->role_id = $role_id; $file_role->Save(); } $db->commit(); } } else { $enabled_file_roles = $file->GetFileRoleIds(); } $enabled_file_roles = array_flip($enabled_file_roles); $roles = new collection(); $roles->Load(TABLE_ROLE, false, '', 'name ASC'); $roles = $roles->_collection; include SITE_FILE_ROOT . 'template/simple_header.php'; include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/' . $STORAGE['action'] . '.php'; include SITE_FILE_ROOT . 'template/simple_footer.php';
<?php include SITE_FILE_ROOT . 'template/header.php'; $enable_sort_fields = array('id_variable', 'order', 'name', 'show_name', 'module'); $from = intval(get_request_variable('from', 0)); $sort = get_request_variable('sort', 'show_name'); $sort_dir = get_request_variable('sort_dir', 'asc'); if (array_search($sort, $enable_sort_fields) === false) { $sort = 'show_name'; } if (array_search($sort_dir, $convert_sort_dirs) === false) { $sort_dir = 'asc'; } $additional_vars = 'sort/' . urlencode($sort) . '/sort_dir/' . urlencode($sort_dir); $variables = new collection(); $all_num = $variables->Load(TABLE_VARIABLE, true, '', '"' . $sort . '" ' . $sort_dir, $from, LIMIT_VARIABLES_ON_PAGE); $page_break = get_page_break(SITE_URI_ROOT . $STORAGE['module'] . '/' . $STORAGE['action'] . '/', $all_num, $from, LIMIT_VARIABLES_ON_PAGE, LIMIT_PAGE_ON_PAGE, $additional_vars); include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/' . $STORAGE['action'] . '.php'; include SITE_FILE_ROOT . 'template/footer.php';
if (!ereg("[0-9]{4}-[0-9]{2}-[0-9]{2}", $pattern)) { $pattern_flag = false; } if ($pattern != '' && $pattern_flag == true) { $query = 'select count(*) as num from jGetMsgsEx(date(NOW()) -7, date(NOW()));'; } else { $query = 'select count(*) as num from jGetMsgsEx(date(NOW()) - 7, date(NOW()));'; } //echo $query; $db->query($query); $all_num = $db->value[0]['num']; $coms = array(); if ($all_num > 0) { if ($pattern != '' && $pattern_flag == true) { $query = 'SELECT * FROM jGetMsgsEx( \'' . db_class::escape_like($pattern) . '\', date(NOW()));'; } else { $query = 'SELECT * FROM jGetMsgsEx( date(NOW())-7, date(NOW()))'; } $db->query($query); $coms = $db->value; } $empl = new collection(); $empl->Load(TABLE_DLS, false, $where, 'name ASC'); $empl = $empl->_collection; $cats = new collection(); $cats->Load(TABLE_OBJECTS, false, $where, 'name ASC'); $cats = $cats->_collection; $page_break = get_page_break(SITE_URI_ROOT . $STORAGE['module'] . '/' . $STORAGE['action'] . '/', $all_num, $from, LIMIT_COMPANY_ON_PAGE, LIMIT_PAGE_ON_PAGE, $additional_vars); include SITE_FILE_ROOT . 'template/header.php'; include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/view.php'; include SITE_FILE_ROOT . 'template/footer.php';
} } else { $enabled_employee_roles = $employee->GetEmployeeRolesId(); } $department_name = '---'; if ($employee->department_id > 0) { $department = new department(); $department->id_department = $employee->department_id; if ($department->Load()) { $department_name = $department->name; } } $enabled_employee_roles = array_flip($enabled_employee_roles); $where = ''; //if ($employee->id_employee>0) $where = 'id_employee<>'.$employee->id_employee; $employees = new collection(); $employees->Load(TABLE_EMPLOYEE, false, $where, 'name ASC'); $employees = $employees->_collection; $where = ''; if (!check_current_employee_admin($STORAGE)) { $where = '"super_user"=\'no\''; } $roles = new collection(); $roles->Load(TABLE_ROLE, false, $where, 'name ASC'); $roles = $roles->_collection; $offices = new collection(); $offices->Load(TABLE_OFFICE, false, '', 'name ASC'); $offices = $offices->_collection; include SITE_FILE_ROOT . 'template/simple_header.php'; include SITE_FILE_ROOT . 'template/' . $STORAGE['module'] . '/' . $STORAGE['action'] . '.php'; include SITE_FILE_ROOT . 'template/simple_footer.php';