function Show() { $return = ' <script langauge = "JavaScript"> function deleteItems() { } </script> <script language = "JavaScript"> var Ahistory0 = new Array(0,0,0,0,0,0,0,0,1); var Ahistory1 = new Array(0,1,1,1,0,0,0,0,1); var Ahistory2 = new Array(0,1,0,0,0,0,0,0,1); window.parent.elemActions(\'history\', 0); </script> <script language="JavaScript" src="tooltip/tooltip.js"></script> '; require_once core('ajax_table'); // Create templorary table sql_query("DROP TABLE tmp_history"); sql_query("CREATE TABLE tmp_history (\n\t\t\ttype VARCHAR(50) NOT NULL,\n\t\t\tid INT UNSIGNED NOT NULL,\n\t\t\tdate INT UNSIGNED NOT NULL,\n\t\t\tdescription VARCHAR(255) NOT NULL,\n\t\t\ttext TEXT NOT NULL,\n\t\t\tPRIMARY KEY (type, id)\n\t\t)"); // insert notes sql_query("INSERT INTO tmp_history SELECT 'note', id, date, name, text FROM notes WHERE client_id=" . $this->client_id); // insert notes sql_query("INSERT INTO tmp_history SELECT 'order', id, order_date, id, '' FROM orders WHERE client_id=" . $this->client_id); // insert notes sql_query("INSERT INTO tmp_history SELECT 'mail', id, UNIX_TIMESTAMP(em.date), em.subject, em.body FROM email_sent AS em LEFT JOIN email_log AS log ON em.id=log.email_id WHERE log.client_id=" . $this->client_id); $return .= ajax_table(array('columns' => array(array('select' => 'date', 'display' => 'date', 'type' => 'datetime', 'nowrap' => true), array('select' => 'type', 'display' => 'type', 'type' => 'type'), array('select' => 'description', 'display' => 'description', 'type' => 'description', 'width' => '50%'), array('select' => 'text'), array('select' => 'id', 'display' => 'edit', 'type' => 'edit', 'width' => '30', 'align' => 'center')), 'from' => 'tmp_history', 'orderby' => 'date DESC', 'params' => array('page' => $this->name, 'do' => 'show', 'client_id' => $this->client_id)), $this); return $return; }
function Show() { // обязательная фигня if (!empty($GLOBALS['_POST'])) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } global $settings; $types = array(); foreach ($settings['subscribe_categories'] as $key => $val) { if (isset($val['sub'])) { foreach ($val['sub'] as $k => $v) { $types[$v['type']] = $v['title']; } } } require_once core('ajax_table'); $data['table'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox', 'width' => '1px'), array('select' => 'email', 'display' => 'email', 'flags' => FLAG_SORT | FLAG_SEARCH), array('select' => 'type', 'display' => 'type', 'type' => 'type', 'flags' => FLAG_SORT | FLAG_FILTER, 'filter_display' => 'type', 'filter_type' => 'array', 'filter_value' => array('' => '-- Все --') + $types, 'filter_field' => 'type')), 'from' => $this->table, 'where' => 'root_id=' . domainRootId(), 'params' => array('page' => $this->name, 'do' => 'show'), 'click' => 'ID=cb.value'), $this); $this->AddStrings($data); $data['thisname'] = $this->name; $data['thisname2'] = str_replace('/', '', $this->name); return Parse($data, "notify/tmpls/properties.tmpl"); }
function Show() { if (!empty($GLOBALS['_POST'])) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } require_once core('ajax_table'); $ret['id'] = 0; $ret['auth_group'] = (int) get('auth_group'); $ret['auth_groups'] = sql_getRows('select id, name from auth_groups order by priority, name', true); if (!$ret['auth_group']) { $ret['auth_group'] = key($ret['auth_groups']); } $ret['auth_group_type'] = sql_getValue(' SELECT dt.type FROM auth_groups AS ag LEFT JOIN discount_types AS dt ON dt.id = ag.discount_type WHERE ag.id = ' . $ret['auth_group']); if ($ret['auth_group_type'] == 'fix') { $ret['table'] = ajax_table(array('columns' => array(array('select' => 'dg.id', 'type' => 'checkbox'), array('select' => 'dg.name', 'display' => 'product_group'), array('select' => 'discounts.discount', 'display' => 'discount', 'type' => 'edit', 'align' => 'right', 'text-align' => 'right', 'maxlength' => 2, 'size' => 2), array('select' => '""', 'display' => '', 'width' => '50%')), 'from' => 'discount_groups AS dg LEFT OUTER JOIN discounts ON discounts.discount_group_id = dg.id AND discounts.user_discount_group_id=' . $ret['auth_group'], 'orderby' => 'priority, name', 'params' => array('page' => $this->name, 'do' => 'show', 'id' => '', 'auth_group' => $ret['auth_group']), 'click' => 'ID=cb.value;'), $this); } else { $ret['table'] = ajax_table(array('columns' => array(array('select' => 'id', 'type' => 'checkbox', 'display' => 'id'), array('select' => 'volume', 'display' => 'upvolume', 'type' => 'edit', 'align' => 'right', 'text-align' => 'right', 'maxlength' => 10, 'size' => 10), array('select' => 'discount', 'display' => 'discount', 'type' => 'edit', 'align' => 'right', 'text-align' => 'right', 'maxlength' => 2, 'size' => 2), array('select' => '""', 'display' => '', 'width' => '50%')), 'from' => 'discounts_volume', 'where' => 'auth_group_id=' . $ret['auth_group'], 'orderby' => 'volume', 'params' => array('page' => $this->name, 'do' => 'show', 'id' => '', 'auth_group' => $ret['auth_group']), 'click' => 'ID=cb.value;'), $this); } $this->AddStrings($ret); return $this->Parse($ret, $this->name . '.tmpl'); }
function Show() { if (!empty($GLOBALS['_POST'])) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } $this->SetValues(); require_once core('ajax_table'); $data['thisname'] = $this->name; $data['root'] = is_root(); $this->AddStrings($data); $_tables = sql_getRows('SHOW tables'); foreach ($_tables as $key => $val) { $tables[$val] = $val; } $_transactions = sql_getColumn('SELECT distinct action FROM ' . $this->table . ' ORDER BY action'); foreach ($_transactions as $key => $val) { $transactions[$val] = $val; } $where = ''; if ($this->from_date && $this->to_date) { $where = ' UNIX_TIMESTAMP(date)>=' . $this->from_date . ' AND UNIX_TIMESTAMP(date)<=' . $this->to_date; } $data['table'] = ajax_table(array('columns' => array(array('select' => 'user', 'display' => 'user', 'width' => '1px', 'flags' => FLAG_SORT | FLAG_SEARCH), array('select' => 'object', 'display' => 'object', 'width' => '1px', 'flags' => FLAG_SORT | FLAG_FILTER | FLAG_SEARCH, 'filter_type' => 'array', 'filter_value' => array('' => '-- все --') + $tables, 'filter_rule' => 'find_in_set'), array('select' => 'action', 'display' => 'action', 'width' => '1px', 'flags' => FLAG_SORT | FLAG_FILTER | FLAG_SEARCH, 'filter_type' => 'array', 'filter_value' => array('' => '-- все --') + $transactions), array('select' => 'description', 'display' => 'description', 'type' => 'description', 'flags' => FLAG_SEARCH), array('select' => 'date', 'display' => 'date', 'type' => 'datetime', 'width' => '100px', 'flags' => FLAG_SORT)), 'from' => $this->table, 'where' => $where, 'orderby' => 'date DESC', 'params' => array('page' => $this->name, 'do' => 'show'), 'dblclick' => '', 'click' => ''), $this); $data['navig'] = $this->NavigForm(); return $this->parse($data, $this->name . '.tmpl'); }
function ShowRecipientsAdmins() { $data = sql_getRows("SELECT id, login, fullname FROM admins"); require_once core('ajax_table'); $ret['thisname'] = $this->name; $ret['table'] = ajax_table(array('from' => "admins", 'columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox', 'width' => '1px'), array('select' => 'login', 'display' => 'client_login', 'flags' => FLAG_SEARCH), array('select' => 'email', 'display' => 'email', 'flags' => FLAG_SEARCH)), 'where' => 'LENGTH(email)>0 ', 'orderby' => 'id', 'params' => array('page' => 'notify/send', 'do' => 'showplugin', 'func' => 'ShowRecipientsAdmins', 'plugin' => 'email'), 'click' => 'ID=cb.value;', 'target' => 'tmpemailshowrecipients', 'dblclick' => 'PasteRecipientsAdmins(id)'), $this); //pr($ret); return $ret; }
function ShowRecycle() { global $limit; $limit = -1; require_once core('ajax_table'); $this->AddStrings($row); $row['table'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox'), array('select' => "description", 'display' => 'comment'), array('select' => "subject", 'display' => 'subject')), 'where' => "visible<=0 AND (user_id IS NULL OR user_id=" . $GLOBALS['user']['id'] . ")", 'orderby' => 'updated DESC', 'params' => array('page' => $this->name, 'do' => 'show')), $this); return $this->Parse($row, 'recycle.tmpl'); }
function ShowRecycle() { global $limit; $limit = -1; require_once core('ajax_table'); $columns = sql_getRows('SHOW columns FROM ' . $this->table, 'Field'); $name = isset($columns['name']) ? 'name' : 'address'; $this->AddStrings($row); $row['table'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox'), array('select' => $name, 'display' => 'name')), 'where' => 'visible<0 and obj_type_id="room"', 'orderby' => 'address', 'params' => array('page' => $this->name, 'do' => 'Show')), $this); return Parse($row, 'recycle.tmpl'); }
function Show() { if (!empty($GLOBALS['_POST'])) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } require_once core('ajax_table'); $ret['thisname'] = $this->name; $ret['table'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox'), array('select' => 'date', 'display' => 'date', 'type' => 'text', 'flags' => FLAG_SORT), array('select' => 'name', 'display' => 'name', 'flags' => FLAG_SORT), array('select' => 'visible', 'display' => 'visible', 'type' => 'visible', 'align' => 'center', 'flags' => FLAG_SORT), array('select' => 'open', 'display' => 'open', 'type' => 'visible', 'align' => 'center', 'flags' => FLAG_SORT)), 'where' => "lang='" . lang() . "' AND root_id=" . domainRootID(), 'orderby' => 'priority', 'params' => array('page' => $this->name, 'do' => 'show', 'move' => 0), 'dblclick' => 'editItem(id)', 'click' => 'ID = cb.value'), $this); return $this->Parse($ret, $this->name . '.tmpl'); }
function editGroupUsers() { $group_id = (int) get('id', 0, 'gp'); if (!$group_id) { return; } $ret = array(); $_GET['limit'] = -1; require_once core('ajax_table'); $ret['table'] = ajax_table(array('columns' => array(array('select' => 'auth_users.name', 'display' => 'user_name', 'flags' => FLAG_SORT), array('select' => 'auth_users.login', 'display' => 'user_login', 'flags' => FLAG_SORT)), 'from' => 'auth_users LEFT JOIN auth_users_groups ON (auth_users_groups.user_id = auth_users.id)', 'params' => array('page' => $this->name, 'do' => 'editgroupusers', 'id' => $group_id), 'orderby' => 'auth_users.name', 'where' => 'auth_users_groups.group_id=' . $group_id, 'roll' => 0), $this); $this->AddStrings($ret); return $this->Parse($ret, $this->name . '.groupusers.tmpl'); }
function Show() { if (!empty($GLOBALS['_POST'])) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } require_once core('ajax_table'); $ret['thisname'] = $this->name; $ret['table'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox', 'width' => '1px'), array('select' => 'name', 'display' => 'name')), 'orderby' => 'priority, name', 'params' => array('page' => $this->name, 'do' => 'show', 'move' => 0), 'click' => 'ID=cb.value', 'dblclick' => 'editItem(id)'), $this); return $this->Parse($ret, $this->name . '.tmpl'); }
function Show() { if (!empty($_POST)) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } require_once core('ajax_table'); $ret['table'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'as' => 'id', 'width' => '1%', 'type' => 'checkbox'), array('select' => 'name', 'display' => 'name', 'flags' => FLAG_SEARCH | FLAG_SORT, 'width' => '1px'), array('select' => 'okrug', 'display' => 'okrug', 'flags' => FLAG_SEARCH | FLAG_SORT, 'width' => '1px', 'type' => 'okrug')), 'from' => $this->table, 'params' => array('page' => $this->name, 'do' => 'show'), 'orderby' => 'name', 'click' => 'ID=cb.value', 'dblclick' => 'editItem(id)'), $this); $ret['thisname'] = $this->name; return $this->Parse($ret, $this->name . '.tmpl'); }
function Show() { global $lang; if (!empty($GLOBALS['_POST'])) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } require_once core('ajax_table'); $ret['thisname'] = $this->name; $ret['params'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox'), array('select' => 'object_id', 'display' => 'lot_id', 'type' => 'lot'), array('select' => 'flat_id', 'display' => 'flat_id', 'type' => 'flat'), array('select' => 'name', 'display' => 'name'), array('select' => 'date', 'display' => 'date', 'type' => 'date'), array('select' => 'contacts', 'display' => 'contacts')), 'orderby' => 'date desc', 'from' => $this->table, 'where' => '', 'params' => array('page' => $this->name, 'do' => 'show', 'move' => 0), 'click' => 'ID=cb.value', 'dblclick' => 'editItem(id)'), $this); return $this->Parse($ret, $this->name . '.tmpl'); }
function Show() { if (!empty($_POST)) { $action = get('actions', '', 'p'); if ($action) { return $this->{$action}(); } } require_once core('ajax_table'); $columns = array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox', 'width' => '1px'), array('select' => 'name', 'display' => 'name'), array('select' => 'image', 'display' => 'image', 'type' => 'image')); $ret['table'] = ajax_table(array('columns' => $columns, 'from' => $this->table, 'where' => 'pid=' . $_GET['pid'], 'params' => array('page' => $this->name, 'do' => 'show', 'move' => 0), 'orderby' => 'priority', 'click' => 'ID=cb.value', 'dblclick' => 'editItem(id)'), $this); $ret['thisname'] = $this->name; return $this->Parse($ret, $this->name . '.tmpl'); }
function Show() { if (!empty($GLOBALS['_POST'])) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } require_once core('ajax_table'); $data['thisname'] = $this->name; $this->AddStrings($data); $client_id = get('client_id', 0, 'g'); $data['client_id'] = $client_id; $data['table'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox', 'valign' => 'top'), array('select' => 'date', 'display' => 'date', 'type' => 'datetime', 'valign' => 'top', 'nowrap' => 1), array('select' => 'name', 'display' => 'subject', 'width' => '30%', 'valign' => 'top'), array('select' => 'SUBSTRING_INDEX(text, " ", 10)', 'display' => 'text', 'width' => '50%', 'type' => 'text'), array('select' => 'link', 'display' => 'link', 'width' => '20', 'align' => 'center', 'type' => 'link'), array('select' => 'text')), 'where' => 'visible="1" and client_id=' . $client_id, 'params' => array('page' => $this->name, 'do' => 'show', 'client_id' => $client_id), 'dblclick' => 'editItem(id)', 'click' => 'ID = cb.value'), $this); return $this->parse($data, $this->name . '.tmpl'); }
function Show() { // обязательная фигня if (!empty($GLOBALS['_POST'])) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } require_once core('ajax_table'); $data['table'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox'), array('select' => 'name', 'display' => 'name', 'flags' => FLAG_SORT), array('select' => 'id', 'display' => 'docopy', 'type' => 'docopy')), 'from' => $this->table, 'where' => '', 'params' => array('page' => $this->name, 'do' => 'show', 'move' => 0), 'dblclick' => 'editItem(id)', 'click' => 'ID=cb.value', 'orderby' => 'id'), $this); $this->AddStrings($data); $data['thisname'] = $this->name; $data['thisname2'] = str_replace('/', '', $this->name); return $this->Parse($data, "surveys_tmpl.tmpl"); }
function Show() { // обязательная фигня if (!empty($GLOBALS['_POST'])) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } // подключение библиотеки для построения таблиц require_once core('ajax_table'); // строим таблицу $data['table'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox'), array('select' => 'name', 'display' => 'name', 'flags' => FLAG_SEARCH | FLAG_SORT), array('select' => 'visible', 'display' => 'visible', 'type' => 'news_visible', 'flags' => FLAG_SORT), array('select' => 'type', 'display' => 'type', 'type' => 'str', 'flags' => FLAG_SORT), array('select' => 'UNIX_TIMESTAMP(date)', 'as' => 'date', 'type' => 'news_date', 'display' => 'date', 'flags' => FLAG_SEARCH | FLAG_SORT)), 'from' => $this->table, 'orderby' => 'date DESC', 'params' => array('page' => $this->name, 'do' => 'show'), 'where' => '', 'dblclick' => 'editItem(id)', 'click' => 'ID=cb.value'), $this); $this->AddStrings($data); return $this->Parse($data, $this->name . '.tmpl'); }
function Show($product_type_id) { if (!empty($GLOBALS['_POST'])) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } if (!$product_type_id) { return; } require_once core('ajax_table'); $ret['thisname'] = $this->name; $ret['table'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox'), array('select' => 'name', 'display' => 'param_names'), array('select' => 'visible', 'display' => 'visible', 'type' => 'visible', 'align' => 'center', 'flags' => FLAG_SORT)), 'from' => 'product_type_params', 'orderby' => 'priority, name', 'where' => 'product_type_id=' . $product_type_id, 'params' => array('page' => 'product_types', 'do' => 'editform', 'id' => $product_type_id), 'click' => 'ID=cb.value', 'dblclick' => 'editItem(id)'), $this); return $this->Parse($ret, $this->name . '.tmpl'); }
function Show() { if (!empty($_POST)) { $action = get('actions', '', 'p'); if ($action) { if ($this->Allow($action)) { return $this->{$action}(); } else { return $this->alert_method_not_allowed(); } } } require_once core('ajax_table'); $data['table'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox'), array('select' => 'display_' . int_lang(), 'display' => 'name', 'flags' => FLAG_SEARCH | FLAG_SORT), array('select' => 'name', 'flags' => FLAG_SEARCH | FLAG_SORT), array('select' => 'type', 'display' => 'type', 'flags' => FLAG_SEARCH | FLAG_SORT), array('select' => 'allowed', 'display' => is_devel() ? 'allowed' : NULL, 'type' => 'allowed', 'align' => 'center'), array('select' => 'required', 'display' => 'required', 'type' => 'required', 'align' => 'center'), array('select' => 'enabled', 'display' => 'enabled', 'type' => 'enabled', 'align' => 'center')), 'from' => $this->table, 'orderby' => 'required DESC, id', 'params' => array('page' => $this->name, 'do' => 'show'), 'where' => !is_devel() ? 'allowed=1' : '', 'dblclick' => 'editItem(id)', 'click' => 'ID = cb.value'), $this); $this->AddStrings($data); return $this->Parse($data, $this->name . '.tmpl'); }
function Show() { // обязательная фигня if (!empty($GLOBALS['_POST'])) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } // подключение библиотеки для построения таблиц require_once core('ajax_table'); // строим таблицу $data['table'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox'), array('select' => 'rooms', 'display' => 'rooms', 'flags' => FLAG_SORT), array('select' => 'street', 'display' => 'street', 'flags' => FLAG_SORT), array('select' => 'price_rub', 'display' => 'price_rub', 'flags' => FLAG_SORT)), 'from' => $this->table, 'orderby' => 'id DESC', 'params' => array('page' => $this->name, 'do' => 'show'), 'where' => '', 'dblclick' => 'editItem(id)', 'click' => 'ID=cb.value', '_sql' => true), $this); $this->AddStrings($data); $data['mode'] = DEV_MODE; return $this->Parse($data, $this->name . '.tmpl'); }
function Show() { if (!empty($_POST)) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } require_once core('ajax_table'); $ret['table'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox', 'width' => '1px'), array('select' => 'login', 'display' => 'login', 'flags' => FLAG_SEARCH | FLAG_SORT, 'width' => '1px'), array('select' => 'id', 'display' => 'id', 'flags' => FLAG_SEARCH | FLAG_SORT, 'width' => '1px'), array('select' => 'CONCAT(lname,CHAR(32),name,CHAR(32),tname)', 'as' => 'name', 'display' => 'fullname', 'flags' => FLAG_SEARCH | FLAG_SORT, 'width' => '100%'), array('select' => 'email', 'display' => 'email'), array('select' => 'DATE_FORMAT(last_visited,"%H:%i:%s %d.%m.%Y")', 'display' => 'last_access', 'flags' => FLAG_SORT), array('select' => 'DATE_FORMAT(reg_date,"%d.%m.%Y")', 'display' => 'reg_date', 'flags' => FLAG_SORT), array('select' => 'subscribe', 'display' => 'subscribe', 'flags' => FLAG_SORT, 'align' => 'center', 'type' => 'visible')), 'from' => $this->table, 'params' => array('page' => $this->name, 'do' => 'show'), 'orderby' => 'last_visited DESC', 'click' => 'ID=cb.value', 'dblclick' => 'editItem(id)'), $this); # сохранение в сессию session_start(); $_SESSION['client_selection'] = $GLOBALS['where']; session_write_close(); $ret['thisname'] = $this->name; return $this->Parse($ret, $this->name . '.tmpl'); }
function Show() { if (!empty($_POST)) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } require_once core('ajax_table'); $ret['table'] = ajax_table(array('columns' => array(array('select' => 'cl.id', 'display' => 'id', 'type' => 'checkbox', 'width' => '1px'), array('select' => 'login', 'display' => 'login', 'flags' => FLAG_SEARCH | FLAG_SORT, 'width' => '1px'), array('select' => 'cl.id', 'display' => 'id', 'flags' => FLAG_SEARCH | FLAG_SORT, 'width' => '1px'), array('select' => 'fio', 'as' => 'name', 'display' => 'fullname', 'flags' => FLAG_SEARCH | FLAG_SORT, 'width' => '100%'), array('select' => 'last_visited', 'type' => 'last_access', 'display' => 'last_access', 'flags' => FLAG_SORT), array('select' => 'reg_date', 'type' => 'reg_date', 'display' => 'reg_date', 'flags' => FLAG_SORT), array('select' => 'trusted', 'display' => 'trusted', 'type' => 'visible', 'flags' => FLAG_SORT), array('select' => 'COUNT(o.id)', 'as' => 'sum', 'display' => 'count_objects', 'flags' => FLAG_SORT), array('select' => 'cl.balance', 'display' => 'balance', 'flags' => FLAG_SORT)), 'from' => $this->table . ' as cl LEFT JOIN objects AS o ON o.client_id=cl.id', 'where' => 'cl.deleted=0', 'params' => array('page' => $this->name, 'do' => 'show'), 'orderby' => 'last_visited DESC', 'groupby' => 'cl.id', 'click' => 'ID=cb.value', 'dblclick' => 'editItem(id)'), $this); # сохранение в сессию session_start(); $_SESSION['client_selection'] = $GLOBALS['where']; session_write_close(); $ret['thisname'] = $this->name; return $this->Parse($ret, $this->name . '.tmpl'); }
function Show() { if (!empty($_POST)) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } $pids = $this->getChilds(); $this->getList($pids, $rows, 1); $districts = sql_getRows('SELECT id, name FROM ' . $this->table . ' WHERE pid IS NULL ORDER BY name', true); require_once core('ajax_table'); $ret['table'] = ajax_table(array('columns' => array(array('select' => 'd4.id', 'display' => 'id', 'type' => 'checkbox'), array('select' => 'd4.name', 'display' => 'district', 'flags' => FLAG_SORT | FLAG_SEARCH), array('select' => 'd1.pid', 'flags' => FLAG_FILTER, 'filter_display' => 'pid1', 'filter_type' => 'array', 'filter_value' => array('' => '-- все --') + $districts), array('select' => 'd2.pid'), array('select' => 'd3.pid'), array('select' => 'd4.pid')), 'from' => $this->table . ' AS d4 LEFT JOIN ' . $this->table . ' AS d3 ON d4.pid=d3.id LEFT JOIN ' . $this->table . ' AS d2 ON d3.pid=d2.id LEFT JOIN ' . $this->table . ' AS d1 ON d2.pid=d1.id', 'dataset' => $rows, 'params' => array('page' => $this->name, 'do' => 'show'), 'click' => 'ID=cb.value', 'dblclick' => 'editItem(id)', 'function' => 'setFilterData'), $this); $ret['thisname'] = $this->name; return $this->Parse($ret, $this->name . '.tmpl'); }
function ElemList() { $id = (int) get('id', 0); $rows = array(); // если редактируем if ($id) { $object = $this->getObject(); $rows = $object['object']; } require_once core('ajax_table'); $_GET['limit'] = '-1'; $data['table'] = ajax_table(array('columns' => array(array('select' => 'ep.id', 'as' => 'id', 'display' => 'ids', 'type' => 'checkbox', 'width' => '1px'), array('select' => 'p.name', 'as' => 'name', 'display' => 'name')), 'dataset' => $rows, 'from' => 'elem_product AS ep LEFT JOIN products AS p ON ep.id=p.id LEFT JOIN tree AS t ON ep.pid=t.id', 'params' => array('id' => $id, 'page' => $this->name, 'esId' => $this->esId, 'tab' => $this->tab, 'frame' => 'cnt'), 'editform_params' => array('do' => 'closeTab', 'act2' => '', 'newTab' => '', 'move' => '', 'frame' => 'tmp'), 'action' => 'ed.php', 'click' => 'ID=cb.value', 'target' => 'tmp' . $this->name . $id), $this); $this->AddStrings($data); $data['id'] = $id; $data['tab'] = $this->tab; $data['esId'] = $this->esId; return $this->Parse($data, 'elem_product.list.tmpl'); }
function Show() { global $cfg; if (!empty($_POST)) { $action = get('actions', '', 'p'); if ($action) { if ($this->Allow($action)) { return $this->{$action}(); } else { return $this->alert_method_not_allowed(); } } } // подключение библиотеки для построения таблиц require_once core('ajax_table'); // строим таблицу $data['table'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox'), array('select' => 'name', 'display' => 'name', 'flags' => FLAG_SEARCH | FLAG_SORT), array('select' => 'value', 'display' => 'value', 'flags' => FLAG_SEARCH | FLAG_SORT)), 'from' => $this->table, 'orderby' => '', 'params' => array('page' => $this->name, 'do' => 'show'), 'where' => '', 'dblclick' => 'editItem(id)', 'click' => 'ID=cb.value'), $this); $this->AddStrings($data); return $this->Parse($data, $this->name . '.tmpl'); }
function Show() { if (!empty($GLOBALS['_POST'])) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } require_once core('ajax_table'); $ret['thisname'] = $this->name; global $site_domains; $sites = array(); foreach ($site_domains as $key => $val) { foreach ($val['langs'] as $l) { $sites[$l['root_id']] = $val['name'] . ' (' . $l['descr'] . ')'; } } $ret['params'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox'), array('select' => 'name', 'display' => 'name', 'flags' => FLAG_SORT | FLAG_SEARCH), array('select' => 'budget', 'display' => 'budget', 'flags' => FLAG_SEARCH), array('select' => 'start_date', 'display' => 'start_date', 'type' => 'text', 'flags' => FLAG_SORT), array('select' => 'end_date', 'display' => 'end_date', 'type' => 'text', 'flags' => FLAG_SORT), array('select' => 'root_id', 'type' => 'text', 'flags' => FLAG_SORT | FLAG_FILTER, 'filter_type' => 'array', 'filter_display' => 'root_id', 'filter_value' => array('' => '-- все --') + $sites)), 'from' => $this->table, 'where' => '', 'orderby' => 'id', 'params' => array('page' => "stat/reklama_obj", 'do' => 'show'), 'click' => 'ID=cb.value', 'dblclick' => 'editItem(id)'), $this); $ret['thisname2'] = str_replace('/', '', $this->name); return Parse($ret, $this->name . '/reklama_obj.tmpl'); }
function Show() { if (!empty($_POST)) { $action = get('actions', '', 'p'); if ($action) { if ($this->Allow($action)) { return $this->{$action}(); } else { return $this->alert_method_not_allowed(); } } } require_once core('ajax_table'); $client_id = get('client_id', 0, 'g'); $ret['thisname'] = $this->name; $ret['table'] = ajax_table(array('columns' => array(array('select' => 'em.id', 'display' => 'id', 'type' => 'checkbox'), array('select' => 'COUNT(*)', 'as' => 'em_count'), array('select' => 'CONCAT(cl.name,CHAR(32),cl.lname,CHAR(32),"<",cl.login,">")', 'as' => 'to_field', 'display' => $client_id ? NULL : 'to', 'type' => 'to'), array('select' => 'u.id', 'display' => $client_id || is_root() ? 'from' : NULL, 'type' => 'from'), array('select' => 'em.subject', 'display' => 'subject'), array('select' => 'UNIX_TIMESTAMP(em.date)', 'as' => 'from_date', 'display' => 'date', 'type' => 'datetime'), array('select' => 'CONCAT(u.fullname,CHAR(32),"<",u.login,">")', 'as' => 'u_fullname')), 'from' => $this->table . ' AS em LEFT JOIN email_log AS log ON em.id=log.email_id LEFT JOIN auth_users AS cl ON log.client_id=cl.id LEFT JOIN users AS u ON em.user_id=u.id', 'where' => $client_id ? 'log.client_id=' . $client_id : '', 'orderby' => 'em.date DESC', 'groupby' => 'em.id', 'params' => array('page' => $this->name, 'do' => 'show', 'client_id' => $client_id), 'click' => 'ID=cb.value;', 'dblclick' => 'editItem(id)'), $this); return $this->Parse($ret, $this->name . '.tmpl'); }
function Show() { require_once core('ajax_table'); $client_id = get('client_id', ''); $ret['table'] = ajax_table(array('columns' => array(array('select' => 'p.id', 'display' => 'id', 'type' => 'checkbox'), array('select' => 'p.name', 'display' => 'product_name', 'flags' => FLAG_SORT), array('select' => 'o.order_date', 'display' => 'order_date', 'type' => 'datetime', 'flags' => FLAG_SORT), array('select' => 'o.id', 'display' => 'order_id', 'type' => 'order', 'flags' => FLAG_SORT), array('select' => 'o.status', 'display' => 'status', 'type' => 'status', 'flags' => FLAG_SORT), array('select' => 'c.quantity', 'display' => 'quantity', 'align' => 'right', 'flags' => FLAG_SORT), array('select' => 'ROUND((c.price+c.delta)*(1-c.discount))', 'display' => 'price', 'align' => 'right', 'type' => 'number', 'flags' => FLAG_SORT)), 'from' => ' orders AS o, cart AS c LEFT JOIN products AS p ON c.product_id=p.id LEFT JOIN auth_users AS cl ON o.client_id=cl.id', 'where' => 'c.order_id=o.id' . ' AND o.status IN ("Delivered","ReadyPaid")' . ($client_id ? ' AND o.client_id=' . $client_id : ''), 'orderby' => 'o.order_date', 'params' => array('page' => $this->name, 'do' => 'show', 'client_id' => $client_id)), $this); /****** Навигация *********/ /* $navig['from_date'] = get('from_date', ''); $navig['to_date'] = get('to_date', ''); // Set Default From_date and To_date if (empty($navig['from_date'])) { $navig['from_date'] = mktime(0,0,0,date('m') ,date('d')-7 ,date('Y')); $navig['from_date'] = date('Y-m-d', $navig['from_date']); } else $navig['from_date'] = date('Y-m-d', get('from_date', '')); if (empty($navig['to_date'])) { $navig['to_date'] = mktime(23, 59, 59, date('m'), date('d') ,date('Y')); $navig['to_date'] = date('Y-m-d', $navig['to_date']); } else $navig['to_date'] = date('Y-m-d', get('to_date', '')); $ret['navig'] = $navig; */ /**************************/ $ret['client_id'] = $client_id; $this->AddStrings($ret); return $this->Parse($ret, $this->name . '.tmpl'); }
function Show() { // обязательная фигня if (!empty($GLOBALS['_POST'])) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } // подключение библиотеки для построения таблиц require_once core('ajax_table'); // строим таблицу $columns = array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox', 'width' => '1px')); if (is_devel()) { $columns[] = array('select' => 'name', 'display' => 'name', 'width' => '1px', 'flags' => FLAG_SEARCH | FLAG_SORT); } $columns[] = array('select' => 'recipient', 'display' => 'recipient', 'width' => '1px', 'flags' => FLAG_SORT, 'type' => 'recipient'); $columns[] = array('select' => 'description', 'display' => 'description'); $columns[] = array('select' => 'comments', 'display' => 'comments'); $data['table'] = ajax_table(array('columns' => $columns, 'from' => $this->table, 'params' => array('page' => 'notify/' . $this->name, 'do' => 'show'), 'dblclick' => 'editItem(id)', 'click' => 'ID=cb.value'), $this); $this->AddStrings($data); $data['thisname'] = 'events'; return Parse($data, "notify/tmpls/" . $this->name . '.tmpl'); }
function ShowComponentSelector() { if (!empty($GLOBALS['_POST'])) { $actions = get('actions', '', 'p'); if ($actions) { return $this->{$actions}(); } } require_once core('ajax_table'); $prod_id = get('prod_id', '', 'g'); $temp = array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox'), array('select' => 'name', 'display' => 'component', 'flags' => FLAG_SEARCH)), 'from' => "products", 'where' => "product_type_id=" . $prod_id, 'orderby' => 'id', 'params' => array('page' => $this->name, 'do' => 'showcomponentselector'), 'click' => 'ID=cb.value', 'dblclick' => 'addToList2()', 'target' => 'tmp' . $this->name . 'select'); if (empty($prod_id) || $prod_id == 0) { $temp['where'] = ""; } $ret['table'] = ajax_table($temp, $this); $this->AddStrings($ret); return $this->Parse($ret, 'selectwindow.tmpl'); }
function ShowRecycle() { global $limit; $limit = -1; require_once core('ajax_table'); $this->AddStrings($row); $row['table'] = ajax_table(array('columns' => array(array('select' => 'id', 'display' => 'id', 'type' => 'checkbox'), array('select' => "name", 'display' => 'name')), 'where' => 'lang="' . lang() . '" AND visible<0', 'orderby' => 'id DESC', 'params' => array('page' => $this->name, 'do' => 'Show')), $this); return Parse($row, 'recycle.tmpl'); }