function actPopup()
{
global $ST;
parent::refresh();
$cond = " WHERE 1 ";
if ($this->getURIVal('usertype')) {
$cond .= " AND type='" . SQL::slashes($this->getURIVal('usertype')) . "'";
}
$query = "SELECT count(*) AS c FROM sc_users" . $cond;
$rs = $this->getStatement()->execute($query);
if ($rs->next()) {
$this->page->all = $rs->getInt('c');
}
$order = 'ORDER BY ';
$ord = $this->getURIVal('ord') != 'asc' ? 'asc' : 'desc';
if (in_array($this->getURIVal('sort'), array('login', 'u_id', 'status', 'type', 'city', 'company', 'balance', 'discount', 'bonus', 'visit', 'last_visit', 'reg_date'))) {
$order .= $this->getURIVal('sort') . ' ' . $ord;
} elseif ($this->getURIVal('sort') == 'fio') {
$order .= 'last_name ' . $ord . ',first_name ' . $ord . ',middle_name ' . $ord;
} else {
$order .= 'type,u_id';
}
$queryStr = "SELECT * FROM sc_users {$cond} {$order} LIMIT " . $this->page->getBegin() . "," . $this->page->per;
$this->rs = $ST->select($queryStr);
$data['usertype'] = $this->enum('u_type');
$this->tplContainer = 'core/tpl/admin/admin_popup.php';
$this->display($data, dirname(__FILE__) . '/users_popup.tpl.php');
}
function actDefault()
{
parent::refresh();
$cond = " type='vendor' ";
if ($this->getURIVal('hidden') != 1) {
$cond .= " AND hide=0";
}
$query = "SELECT count(*) AS c FROM sc_users WHERE {$cond}";
$rs = DB::select($query);
if ($rs->next()) {
$this->page->all = $rs->getInt('c');
}
$order = 'ORDER BY ';
$ord = $this->getURIVal('ord') != 'asc' ? 'asc' : 'desc';
if (in_array($this->getURIVal('sort'), array('login', 'u_id', 'status', 'type', 'company', 'balance', 'discount', 'bonus', 'visit', 'last_visit', 'reg_date'))) {
$order .= $this->getURIVal('sort') . ' ' . $ord;
} elseif ($this->getURIVal('sort') == 'fio') {
$order .= 'last_name ' . $ord . ',first_name ' . $ord . ',middle_name ' . $ord;
} else {
$order .= 'type,u_id';
}
$q = "SELECT * FROM sc_users u\r\n\t\t\tLEFT JOIN sc_users_vendor v ON v.vendor_id=u.u_id\r\n\t\t\tLEFT JOIN (SELECT COUNT(id) ci,vendor FROM sc_shop_item GROUP BY vendor) AS cci ON cci.vendor=u.u_id\r\n\t\tWHERE {$cond} {$order} LIMIT " . $this->page->getBegin() . "," . $this->page->per;
$data['rs'] = DB::select($q)->toArray();
$this->display($data, dirname(__FILE__) . '/admin_vendor.tpl.php');
}
function refresh()
{
parent::refresh();
$query = "SELECT count(*) AS c FROM sc_letter_template";
$rs = $this->getStatement()->execute($query);
if ($rs->next()) {
$this->page->all = $rs->getInt('c');
}
$queryStr = "select * from sc_letter_template LIMIT " . $this->page->getBegin() . "," . $this->page->per;
$this->rs = $this->getStatement()->execute($queryStr);
}
function refresh()
{
parent::refresh();
$query = "SELECT count(*) AS c FROM sc_content";
$rs = $this->getStatement()->execute($query);
if ($rs->next()) {
$this->page->all = $rs->getInt('c');
}
$queryStr = "SELECT * FROM sc_content ORDER BY c_name LIMIT " . $this->page->getBegin() . "," . $this->page->per . " ";
$this->rs = $this->getStatement()->execute($queryStr);
}
function actDefault()
{
global $ST;
parent::refresh();
$queryStr = "SELECT count(*) AS c FROM sc_guestbook";
$rs = $ST->select($queryStr);
if ($rs->next()) {
$this->page->all = $rs->getInt("c");
}
$order = "ORDER BY time DESC";
$queryStr = "SELECT * FROM sc_guestbook {$order} LIMIT " . $this->page->getBegin() . "," . $this->page->per;
$this->rs = $ST->select($queryStr);
$this->display(array(), dirname(__FILE__) . '/guestbook_list.tpl.php');
}
function actAddr()
{
global $ST;
parent::refresh();
$queryStr = "SELECT count(*) AS c FROM sc_contacts_points";
$rs = $ST->select($queryStr);
if ($rs->next()) {
$this->page->all = $rs->getInt("c");
}
$order = "ORDER BY id DESC";
$queryStr = "SELECT * FROM sc_contacts_points {$order} LIMIT " . $this->page->getBegin() . "," . $this->page->per . "";
$this->rs = $ST->select($queryStr);
$this->setPageTitle('Адреса');
$this->display(array(), dirname(__FILE__) . '/contacts_points_list.tpl.php');
}
function actDefault()
{
global $ST;
parent::refresh();
$this->updateParams();
$queryStr = "SELECT count(*) AS c FROM sc_faq WHERE type='" . $this->type . "'";
$rs = $ST->select($queryStr);
if ($rs->next()) {
$this->page->all = $rs->getInt("c");
}
$order = "ORDER BY time ASC";
$queryStr = "SELECT * FROM sc_faq WHERE type='" . $this->type . "' {$order} limit " . $this->page->getBegin() . "," . $this->page->per;
$this->rs = $ST->select($queryStr);
$this->display(array(), dirname(__FILE__) . '/faq_list.tpl.php');
}
function actDefault()
{
global $ST;
parent::refresh();
$cnd = "1=1";
$queryStr = "SELECT count(*) AS c FROM sc_shop_board b WHERE {$cnd}";
$rs = $ST->select($queryStr);
if ($rs->next()) {
$this->page->all = $rs->getInt("c");
}
$order = "ORDER BY time ASC";
$queryStr = "SELECT * FROM sc_shop_board b\r\n\t\t\tLEFT JOIN sc_users as u ON u.u_id=b.userid\r\n\t\tWHERE {$cnd} {$order} limit " . $this->page->getBegin() . "," . $this->page->per;
$this->rs = $ST->select($queryStr);
$this->display(array(), dirname(__FILE__) . '/board_list.tpl.php');
}
function actDefault()
{
global $ST;
parent::refresh();
$this->updateParams();
$queryStr = "SELECT count(*) AS c FROM sc_news WHERE type='" . $this->getType() . "'";
$rs = $ST->select($queryStr);
if ($rs->next()) {
$this->page->all = $rs->getInt("c");
}
$order = "ORDER BY date desc,id DESC, position DESC";
if ($this->type == 'article') {
$order = "ORDER BY position DESC, view DESC";
}
$queryStr = "SELECT * FROM sc_news WHERE type='" . $this->getType() . "' {$order} limit " . $this->page->getBegin() . "," . $this->page->per;
$this->rs = $ST->select($queryStr);
$this->display(array(), dirname(__FILE__) . '/news_list.tpl.php');
}
function actDefault()
{
global $ST;
parent::refresh();
$cond = "type='{$this->getType()}'";
if ($cat = $this->getURIIntVal('category')) {
$cond .= " AND cat={$cat}";
}
if ($label = $this->getURIIntVal('label')) {
$cond .= " AND EXISTS (SELECT gallery_id FROM sc_gallery_label WHERE gallery_id=g.id AND label_id={$label})";
}
$q = "SELECT count(*) AS c FROM sc_gallery g WHERE {$cond}";
$rs = $ST->select($q);
if ($rs->next()) {
$this->page->all = $rs->getInt("c");
}
$order = 'ORDER BY ';
$ord = $this->getURIVal('ord') != 'asc' ? 'asc' : 'desc';
if (in_array($this->getURIVal('sort'), array('name', 'id', 'sort', 'sort_main', 'cat', 'img', 'date'))) {
$order .= $this->getURIVal('sort') . ' ' . $ord;
} else {
$order .= 'id DESC';
}
// $order="ORDER BY sort DESC";
$q = "SELECT g.*,c.value_desc AS cat_desc FROM sc_gallery g\r\n\t\tLEFT JOIN (SELECT field_value,value_desc FROM sc_enum where field_name='gal_{$this->getType()}_cat') AS c ON c.field_value=g.cat\r\n\t\t\r\n\t\tWHERE {$cond} {$order} limit " . $this->page->getBegin() . "," . $this->page->per;
$this->rs = $ST->select($q);
$ids = array();
while ($this->rs->next()) {
$ids[] = $this->rs->getInt('id');
}
$this->rs->reset();
$labels = array();
if ($ids) {
$rs = $ST->select("SELECT * FROM sc_gallery_label WHERE gallery_id IN (" . implode(',', $ids) . ")");
while ($rs->next()) {
if (empty($labels[$rs->get('gallery_id')])) {
$labels[$rs->get('gallery_id')] = array();
}
$labels[$rs->get('gallery_id')][] = $rs->get('label_id');
}
}
$data = array('cat_list' => $this->enum("gal_{$this->getType()}_cat"), 'label_list' => $this->enum("gal_{$this->getType()}_label"), 'labels' => $labels);
$this->display($data, dirname(__FILE__) . '/gallery_list.tpl.php');
}
function actSubscribe()
{
$page = new Page($this->getPages());
parent::refresh();
$cond = " WHERE 1=1 ";
$query = "SELECT count(*) AS c FROM sc_subscribe " . $cond;
$rs = DB::select($query);
if ($rs->next()) {
$page->all = $rs->getInt('c');
}
$order = 'ORDER BY ';
$ord = $this->getURIVal('ord') != 'asc' ? 'asc' : 'desc';
if (in_array($this->getURIVal('sort'), array('login', 'mail'))) {
$order .= $this->getURIVal('sort') . ' ' . $ord;
} else {
$order .= " mail";
}
$data = array();
$queryStr = "SELECT s.*,u.login FROM sc_subscribe s\r\n\t\tLEFT JOIN sc_users u ON s.mail=u.mail\r\n\t\t\r\n\t\t{$cond} {$order} LIMIT " . $page->getBegin() . "," . $page->per;
$data['rs'] = DB::select($queryStr);
$data['pg'] = $page;
$this->setPageTitle('Подписка');
$this->display($data, dirname(__FILE__) . '/subscribe.tpl.php');
}
function actRelation()
{
global $ST;
$data = array('rs' => array());
parent::refresh();
$cond = " r.par=p.id AND r.ch=ch.id";
if ($par = $this->getURIIntVal('relation')) {
$cond .= " AND par={$par}";
}
$query = "SELECT count(*) AS c FROM sc_shop_item AS p,sc_shop_item AS ch,sc_shop_relation r WHERE" . $cond;
$rs = $ST->select($query);
if ($rs->next()) {
$this->page->all = $rs->getInt('c');
}
$q = "SELECT p.*,ch.name AS ch_name,ch.id AS ch_id,ch.img AS ch_img,r.type,r.id AS r_id,rt.value_desc AS type_desc FROM sc_shop_item AS p,sc_shop_item AS ch,sc_shop_relation r\r\n\t\t\tLEFT JOIN (SELECT field_value,value_desc FROM sc_enum WHERE field_name='shop_relation') AS rt ON rt.field_value=r.type\r\n\t\tWHERE {$cond} LIMIT {$this->page->getBegin()},{$this->page->per}";
$rs = $ST->select($q);
while ($rs->next()) {
$data['rs'][] = $rs->getRow();
}
$this->setPageTitle('Связанные');
$this->display($data, dirname(__FILE__) . '/admin_relation.tpl.php');
}
function actFix()
{
global $ST, $get;
parent::refresh();
$cond = "AND type='fix'";
$queryStr = "SELECT count(*) AS c FROM sc_feedback WHERE 1=1 {$cond}";
$rs = $ST->select($queryStr);
if ($rs->next()) {
$this->page->all = $rs->getInt("c");
}
$order = "ORDER BY id DESC";
$queryStr = "SELECT * FROM sc_feedback WHERE 1=1 {$cond} {$order} LIMIT " . $this->page->getBegin() . "," . $this->page->per . "";
$this->rs = $ST->select($queryStr);
$this->display(array(), dirname(__FILE__) . '/feedback_fix_list.tpl.php');
}
function actPlace()
{
global $ST;
parent::refresh();
$q = "SELECT count(*) AS c FROM sc_advertising_place";
$rs = $ST->execute($q);
if ($rs->next()) {
$this->page->all = $rs->getInt('c');
}
$q = "select * from sc_advertising_place LIMIT " . $this->page->getBegin() . "," . $this->page->per;
$data['rs'] = $ST->execute($q);
$this->setPageTitle('Места');
$this->display($data, dirname(__FILE__) . '/adv_place.tpl.php');
}