function newPassword($new_pass)
{
if (!empty($new_pass)) {
db::table('admin_users');
db::where('user_id', ADMIN_USER_ID);
db::update('user_password', md5($new_pass));
}
}
function load()
{
db::table('mails');
db::where('site_id', SITE_ID);
$res = db::select();
while ($row = mysql_fetch_assoc($res)) {
self::$mails[$row['mail_name']] = $row;
}
}
function delete($log_id)
{
db::table('admin_log_trash');
db::where('log_id', $log_id);
db::delete();
@unlink(SYS_ROOT . 'var/trash/' . $log_id . '_conf.zip');
@unlink(SYS_ROOT . 'var/trash/' . $log_id . '_base.zip');
@unlink(SYS_ROOT . 'var/trash/' . $log_id . '_files.zip');
}
function update($name, $value, $user_id = false)
{
if (!$user_id) {
$user_id = ADMIN_USER_ID;
}
db::table('admin_users');
db::where('user_id', $user_id);
db::update($name, $value);
}
function getFile()
{
$file_id = params::get('file');
$dir = FILES_ROOT . 'pages/';
db::table('pages_files');
db::where('file_id', $file_id);
$file = db::assoc();
$link = $dir . $file_id . '.' . $file['file_type'];
files::downloadFile($link, $file['file_name'] . '.' . $file['file_type']);
}
function edit()
{
events::observe('save', 'news', 'save');
events::observer();
admin::components('validator', 'redactor');
db::table('news');
db::where('news_id', admin::get('id'));
$row = db::assoc();
f::set($row);
}
function loadTmpls($site_id = 1)
{
db::table('templates');
db::where('site_id', $site_id);
db::where('tmpl_pub', '1');
$res = db::select();
while ($row = mysql_fetch_assoc($res)) {
self::$tmpls[$row['tmpl_id']] = $row['tmpl_name'];
}
}
function loadMenus($site_id)
{
db::table('menus');
db::where('site_id', $site_id);
db::where('menu_pub', '1');
$res = db::select();
while ($row = mysql_fetch_assoc($res)) {
self::$menus[$row['menu_id']] = $row['menu_name'];
}
}
function loadBlocks($site_id = 1)
{
db::table('blocks');
db::where('site_id', $site_id);
db::where('block_pub', '1');
$res = db::select('block_id', 'block_title', 'block_name', 'block_pub');
while ($row = mysql_fetch_assoc($res)) {
self::$blocks[$row['block_id']] = $row['block_name'];
}
}
function show()
{
$dir = IMAGES_PATH . 'index/';
db::table('images');
db::where('img_set', '1');
db::orderByRand();
$img = db::assoc();
if (db::rows() != 0) {
$file = $dir . $img['img_id'] . '.jpg';
buffer::set('<img src="' . $file . '" width="700" height="360" alt="" />');
}
}
function download()
{
$file_id = params::get('file');
db::table('files');
db::where('file_id', $file_id);
$file = db::assoc();
if (db::rows() == 0) {
web::error404();
}
$file_link = FILES_ROOT . 'all/' . $file_id . '.' . $file['file_type'];
files::downloadFile($file_link);
}
function show()
{
$event = web::getEvent();
if ($event === false) {
$year = date('Y');
} else {
$year = $event;
}
s::set('info_date_select', htmlspecialchars($year));
$sql = "SELECT `section_year` as date FROM `info_sections` WHERE `section_view`='0' GROUP BY `date` ORDER BY `date` DESC";
$res = db::query($sql);
$rows = mysql_num_rows($res);
if ($rows > 1) {
s::add('info_date_selector', '<ul class="years">');
while ($row = mysql_fetch_assoc($res)) {
if ($row['date'] == $year) {
$row['date'] = '<li><span>' . $row['date'] . '</span></li>';
} else {
$row['date'] = '<li><a href="' . web::get('page_folder') . '' . $row['date'] . '/">' . $row['date'] . '</a></li>';
}
s::add('info_date_selector', $row['date']);
}
s::add('info_date_selector', '</ul>');
}
$files = array();
db::table('info_files');
$r = db::select();
while ($a = mysql_fetch_assoc($r)) {
$files[$a['section_id']][] = $a;
}
db::table('info_sections');
db::order('section_order', 'DESC');
db::where('section_year', $year);
$r = db::select();
if (db::rows() == 0) {
web::error404();
}
while ($a = mysql_fetch_assoc($r)) {
if ($a['section_view'] == '0') {
s::roll('sections', $a);
} else {
s::roll('sections_view', $a);
}
if (isset($files[$a['section_id']])) {
foreach ($files[$a['section_id']] as $v) {
$v['file_icon'] = files::getFileIco($v['file_type']);
$v['file_size'] = files::parseSizeSmart($v['file_size']);
s::roll('items' . $a['section_id'], $v);
}
}
}
}
function showOne()
{
$news_id = web::getThis();
db::table('news');
db::where('news_pub', '1');
$news = db::assoc();
if (db::rows() == 0) {
web::error404();
}
$news['news_date'] = dt::date2print('%d %F %Y', $news['news_date']);
s::set('page_title', $news['news_title']);
s::set('page_header', $news['news_title']);
s::set($news);
}
function start()
{
db::connect();
if (!router::get(1)) {
return true;
}
self::$map = array('mode' => router::get(0), 'app' => router::get(1), 'module' => 'main', 'action' => router::get(2), 'id' => router::get(4));
s::set('SYS_PATH', 'http://' . SERVER . SYS_DIR);
define('APP', APPS . self::get('app') . '/');
s::set('APP', APP);
define('MODULE', APP . self::get('module') . '/');
s::set('MODULE', MODULE);
if (stristr(self::$map['mode'], 'admin')) {
self::$map['mode'] = 'admin';
} else {
self::$map['mode'] = 'web';
}
if (self::$map['mode'] == 'admin') {
if (defined('ADMIN_USER_SITE_ID')) {
admin::observer();
define('ADMIN_SITE_ID', ADMIN_USER_SITE_ID);
s::set('ADMIN_SITE_ID', ADMIN_USER_SITE_ID);
db::table('admin_sites');
db::where('site_id', ADMIN_USER_SITE_ID);
db::limit(1);
$row = db::select();
define('ADMIN_SITE', db::get('site_domain'));
s::set('ADMIN_SITE', ADMIN_SITE);
}
} else {
web::getSite();
$lang = lang::gets(LANG_INDEX, SITE_ID);
/*
Authentification webUser
*/
web::observer();
}
/*
Set params
*/
params::send();
if (router::get(0) == 'feed' || router::get(0) == 'rss') {
self::$map['module'] = 'feed';
}
if (self::$map['mode'] == 'admin') {
load::module(self::get('app'), self::get('module'), self::get('action'));
} else {
load::handler(self::get('app'), self::get('module'), self::get('action'));
}
}
function restore()
{
db::table('admin_log_trash');
db::where('log_id', params::get('log_id'));
$date = date('Y-m-d H:i:s');
db::update('log_restored', $date);
db::table('admin_log_trash');
db::where('log_id', params::get('log_id'));
$row = db::assoc();
if ($row['log_tmpl'] == '1') {
trash::restore(params::get('log_id'), SYS_ROOT . 'tmpls/' . ADMIN_SITE . '/');
} else {
trash::restore(params::get('log_id'));
}
buffer::set(dt::date2print('%H:%i:%s<br />%d %F %y', $date));
}
function show()
{
db::table('pages');
db::where('site_id', SITE_ID);
db::where('page_pub', '1');
db::where('page_map', '1');
$res = db::select();
while ($row = mysql_fetch_assoc($res)) {
if ($row['page_map'] == '1') {
$row['page_map'] = ' checked="checked"';
} else {
$row['page_map'] = '';
}
if ($row['page_folder'] == '/') {
$page_path = 'http://' . SITE;
} else {
$page_path = 'http://' . SITE . '' . $row['page_folder'];
}
$row['page_line'] = $row['page_title'] . ' <a href="' . $page_path . '" class="ico11 icoRoundArrow" title="Посмотреть на сайте"> </a>';
$page_tree[$row['page_parent']][$row['page_id']] = $row;
}
s::tree('map_tree', $page_tree);
}
function publish()
{
db::table('images');
db::where('img_id', params::get('img_id'));
db::update('img_set', params::get('pub'));
}
function saveMap()
{
$map = $nomap = array();
$map = explode(',', params::get('map'));
$nomap = explode(',', params::get('nomap'));
foreach ($map as $v) {
db::table('pages');
db::where('page_id', $v);
db::update('page_map', '1');
}
foreach ($nomap as $v) {
db::table('pages');
db::where('page_id', $v);
db::update('page_map', '0');
}
}
function delete()
{
$tmpl_file = params::get('tmpl_file');
$app = params::get('app');
@unlink(SYS_ROOT . 'tmpls/' . ADMIN_SITE . '/' . $app . '/' . $tmpl_file);
db::table('templates_versions');
db::where('app', $app);
db::where('tmpl_file', $tmpl_file);
db::delete();
}
function deleteFilesFile()
{
db::table('catalog_items_files');
db::where('file_id', params::get('file_id'));
$a = db::assoc();
if (db::rows() != 0) {
self::deleteFilesFileForce($a);
}
}
function observerMemory()
{
$cookie = cookie::get(self::$auth_cookie_name);
if ($cookie) {
$err = false;
list($username, $userid, $hash) = explode(',', $cookie);
$userid = intval($userid);
db::table('admin_users');
db::where('user_id', $userid);
$row = db::assoc();
$word = 'legenda';
if (md5($row['user_login'] . $word) != $hash) {
$err = true;
}
if (db::rows() == 0) {
$err = true;
}
if ($err) {
self::logout();
} else {
$_SESSION['ADMIN_AUTH'] = 1;
$_SESSION['ADMIN_USER_ID'] = $userid;
headers::self();
}
}
}
function saveVersion($tmpl_id, $code)
{
db::table('templates_versions');
db::where('tmpl_id', $tmpl_id);
db::where('version_code', $code);
db::order('version_date', 'DESC');
db::limit(1);
db::select();
if (db::rows() == 0) {
/*
delete over 20
*/
db::table('templates_versions');
db::where('tmpl_id', $tmpl_id);
db::order('version_date', 'DESC');
db::limit(20, 100);
db::delete();
db::table('templates_versions');
db::insert('', 'NOW()', $code, '', '', $tmpl_id, ADMIN_USER_ID, ADMIN_SITE_ID);
}
}
<?php
// error_reporting(0);
header("Content-type:text/html;charset=utf-8");
//require_once('/www/web/default/omp/conn.php');
require_once "../config.inc.php";
include "../lib/pdo.class.php";
if ($_POST["depname"]) {
$p = new db("oms_input_general_list");
if ($_POST['dep1']) {
$res = $p->where("department_name='" . $_POST['depname'] . "' and department_name2='" . $_POST['dep1'] . "' and state=0 ")->select("name_of_routine_input_work,program_file_link_the_name");
} else {
$res = $p->where("department_name='" . $_POST['depname'] . "' and department_name2='' and state=0 ")->select("name_of_routine_input_work,program_file_link_the_name");
}
die(json_encode($res));
}
if ($_POST["depname1"]) {
$p = new db("oms_select_general_list");
if ($_POST['dep1']) {
$res = $p->where("department_name='" . $_POST['depname1'] . "' and department_name2='" . $_POST['dep1'] . "' and state=0 ")->select("name_of_routine_select_work,program_file_link_the_name");
} else {
$res = $p->where("department_name='" . $_POST['depname1'] . "' and department_name2='' and state=0 ")->select("name_of_routine_select_work,program_file_link_the_name");
}
die(json_encode($res));
}
function edit()
{
events::observe('save', 'menus', '_save');
events::observer();
admin::components('tabs', 'validator');
appPages::getPagesSelect(ADMIN_SITE_ID);
appMenus::getMenus(ADMIN_SITE_ID);
$menu_id = admin::get('id');
$pages_in = conf::getPagesIn('menus', $menu_id);
$pages_out = conf::getPagesOut('menus', $menu_id);
if (conf::testPages($pages_in) && conf::testPages($pages_out)) {
f::set('allPages', 1);
f::set('allPagesOut', 0);
} else {
if (conf::testPages($pages_in) && !conf::testPages($pages_out)) {
f::set('allPages', 0);
f::set('allPagesOut', 1);
f::set('pages', $pages_out);
} else {
if (!conf::testPages($pages_in) && !conf::testPages($pages_out)) {
f::set('allPages', 0);
f::set('allPagesOut', 0);
f::set('pages', $pages_in);
} else {
if (!conf::testPages($pages_in) && conf::testPages($pages_out)) {
f::set('allPages', 0);
f::set('allPagesOut', 0);
f::set('pages', $pages_in);
}
}
}
}
db::table('menus');
db::where('menu_id', $menu_id);
$row = db::assoc();
f::set($row);
}
function editsection()
{
admin::components('validator');
events::observe('save', 'info', '_savesection');
events::observer();
db::table('info_sections');
db::where('section_id', admin::get('id'));
$section = db::assoc();
f::set($section);
}
function showSection()
{
$section_id = web::getThis();
$item_id = web::getEvent();
if ($item_id !== false) {
buffer::setTmpl('card.html');
self::showCard($item_id, $section_id);
return false;
}
$dir = IMAGES_ROOT . 'sections/';
$dir_path = IMAGES_PATH . 'sections/';
db::table('catalog_sections');
db::where('section_id', $section_id);
$section = db::assoc();
if (db::rows() == 0) {
web::error404();
}
s::set($section);
s::set('page_title', $section['section_name']);
s::set('page_header', $section['section_name']);
$file = $dir . $section['section_id'] . '.jpg';
if (file_exists($file)) {
s::set('section_img', '<img src="' . $dir_path . $section['section_id'] . '.jpg' . '" />');
}
db::table('catalog_items');
db::where('section_id', $section_id);
$r = db::select('item_name', 'item_id', 'item_desc');
$i = 0;
while ($a = mysql_fetch_assoc($r)) {
$i++;
if ($i % 2) {
s::roll('items1', $a);
} else {
s::roll('items2', $a);
}
}
}
function start()
{
db::connect();
if (!router::get(1)) {
return true;
}
self::$map = array('mode' => router::get(0), 'app' => router::get(1), 'module' => 'main', 'action' => router::get(2));
if (router::get(3)) {
self::set('module', router::get(2));
self::set('action', router::get(3));
}
s::set('SYS_PATH', 'http://' . SERVER . SYS_DIR);
define('APP', APPS . self::get('app') . '/');
s::set('APP', APP);
define('MODULE', APP . self::get('module') . '/');
s::set('MODULE', MODULE);
/*
Lang items
*/
if (self::get('mode') == 'webAjax') {
web::getSite();
$lang = lang::gets(LANG_INDEX, SITE_ID);
/*
Authentification webUser
*/
web::observer();
} else {
define('LANG_INDEX', SYS_INDEX);
$lang = lang::gets(LANG_INDEX);
admin::observer();
if (defined('ADMIN_USER_SITE_ID')) {
define('ADMIN_SITE_ID', ADMIN_USER_SITE_ID);
s::set('ADMIN_SITE_ID', ADMIN_USER_SITE_ID);
$group_rules = ini::parse(SYS_ROOT . 'conf/admin/groups.ini', ADMIN_USER_GROUP_ID);
define('RULE', $group_rules['rule']);
db::table('admin_sites');
db::where('site_id', ADMIN_USER_SITE_ID);
db::limit(1);
define('ADMIN_SITE', db::get('site_domain'));
s::set('ADMIN_SITE', ADMIN_SITE);
}
}
/*
Set params
*/
params::send();
$tmpl = params::get('tmpl');
$sys = false;
if (self::get('mode') == 'adminAjax') {
$sys = true;
}
buffer::init(0, self::get('app'), false, $tmpl);
if (self::get('mode') == 'webAjax') {
load::handler(self::get('app'), self::get('module'), self::get('action'));
} else {
load::module(self::get('app'), self::get('module'), self::get('action'));
}
/*
Get plugin action
*/
ob_start();
/*
запуск обработчика с возвратом данных
тут два варианта либо данные просто выводим если нет шаблона, а если есть то сначала обрабатываем шаблон
если буффер полный выводим информацию из него
*/
$buffer = buffer::gets();
if ($buffer[0]) {
if ($sys) {
buffer::$module = self::get('module');
}
$section = params::get('section');
echo buffer::get($buffer[0]['app'], $buffer[0]['tmpl'], $buffer[0]['data'], $section, $sys);
}
$code = ob_get_contents();
ob_clean();
s::$mode = 'code';
s::setTmpl($code, $lang);
s::display();
}
function getInfoByLogin($user_login, $name = false)
{
db::table('users');
db::where('user_pub', '1');
db::where('user_login', $user_login);
$user = db::assoc();
if (db::rows() == 0) {
return false;
} else {
if ($name === false) {
return $user;
} else {
if (isset($user[$name])) {
return $user[$name];
} else {
return false;
}
}
}
}
function add()
{
events::observe('add', 'blocks', '_save');
events::observer();
admin::components('tabs', 'validator');
appPages::getPagesSelect(ADMIN_SITE_ID);
appBlocks::getBlocks(ADMIN_SITE_ID);
// test reserved
db::table('admin_reserved');
db::where('`table`', 'blocks');
db::where('user_id', ADMIN_USER_ID);
$block_id = db::get('id');
if (db::rows() == 0) {
db::table('blocks');
db::smartInsert(array('block_pub' => '2', 'site_id' => ADMIN_SITE_ID));
$block_id = mysql_insert_id();
db::table('admin_reserved');
db::insert('', 'blocks', $block_id, ADMIN_USER_ID);
}
f::set('block_id', $block_id);
}
function loadSiteMenu()
{
db::table('menus');
db::join('menus_points', 'menus', 'menu_id');
db::where('point_pub', '1');
db::where('site_id', SITE_ID, '=', 'menus');
db::where('menu_pub', '1');
db::order('point_order');
$res = db::select();
while ($row = mysql_fetch_assoc($res)) {
self::$menu[$row['menu_name']][$row['point_parent']][$row['point_id']] = $row;
self::$menu_id[$row['menu_name']] = $row['menu_id'];
self::$menu_by_id[$row['menu_id']] = $row['menu_name'];
}
}
