Esempio n. 1
0
 function getProposal($vendor)
 {
     $cat = LibCatalog::getInstance();
     $cat->noCity = true;
     $q = "{$cat->selectProposal()} AND i.vendor={$vendor}  ORDER BY sort DESC";
     return DB::select($q)->toArray();
 }
Esempio n. 2
0
 function actDefault()
 {
     $data = array('category' => 0);
     $page = new Page($this->cfg('PAGE_SIZE'));
     $condition = "b.status=1 AND date_to>='" . date('Y-m-d') . "'";
     if ($c = $this->getUriIntVal('catalog')) {
         $condition .= " AND b.category={$c}";
         $rs = DB::select("SELECT * FROM sc_shop_catalog WHERE id={$c}");
         if ($rs->next()) {
             $this->setPageTitle($rs->get('name'));
         }
         $data['category'] = $c;
     }
     if ($this->getUriIntVal('my')) {
         $condition .= " AND b.userid={$this->getUserId()}";
     }
     $queryStr = "SELECT COUNT(*) as c FROM sc_shop_board b WHERE {$condition}";
     $rs = DB::select($queryStr);
     if ($rs->next()) {
         $page->all = $rs->getInt("c");
     }
     $order = " ORDER BY time DESC";
     $queryStr = "SELECT b.*,u.name,c.name AS c_name,c.id AS c_id FROM sc_shop_board b\r\n\t\t\tLEFT JOIN sc_users u ON u.u_id=b.userid \r\n\t\t\tLEFT JOIN sc_shop_catalog c ON c.id=b.category \r\n\t\tWHERE {$condition} {$order} LIMIT " . $page->getBegin() . "," . $page->per;
     $rs = DB::select($queryStr)->toArray();
     $data['rs'] = $rs;
     $data['pg'] = $page;
     $data['catalog_tree'] = LibCatalog::getInstance()->getCatalogTree();
     $data['date_to'] = date('Y-m-d', time() + 3600 * 24 * 30);
     $this->setCommonCont();
     $this->display($data, dirname(__FILE__) . '/board.tpl.php');
 }
Esempio n. 3
0
 function getQuery($key)
 {
     $search = explode(' ', trim(preg_replace('/\\s+/', ' ', $this->search)));
     if (in_array($key, array('public', 'news'))) {
         $cond = " type IN('{$key}') \r\n\t\t\t\t\tAND (state='main' OR state='public') ";
         //				$relev=" MATCH nws_title, nws_content,nws_desc AGAINST ('".$this->search."') ";
         //				$cond.=" AND (content ILIKE '%".SQL::slashes($this->search)."%' OR title ILIKE '%".SQL::slashes($this->search)."%' OR description ILIKE '%".SQL::slashes($this->search)."%')";
         $subCond = array();
         foreach ($search as $s) {
             $subCond[] = "(content LIKE '%" . SQL::slashes($s) . "%' OR title LIKE '%" . SQL::slashes($s) . "%' OR description LIKE '%" . SQL::slashes($s) . "%')";
         }
         //				$cond.=" AND (".implode(' OR ',$subCond).")";
         $cond .= " AND (" . implode(' AND ', $subCond) . ")";
         $q = "SELECT id ,title, description FROM sc_news WHERE " . $cond . " ";
         $countQ = "SELECT COUNT(id) AS c FROM sc_news WHERE " . $cond;
         $href = "/news/view/";
         $title = "Статьи";
     }
     if ($key == 'gallery') {
         $cond = " type='gallery' \r\n\t\t\t\t\t";
         $subCond = array();
         foreach ($search as $s) {
             $subCond[] = "(text LIKE '%" . SQL::slashes($s) . "%' OR name LIKE '%" . SQL::slashes($s) . "%' OR description LIKE '%" . SQL::slashes($s) . "%')";
         }
         //				$cond.=" AND (".implode(' OR ',$subCond).")";
         $cond .= " AND (" . implode(' AND ', $subCond) . ")";
         $q = "SELECT id ,name as title, description FROM sc_gallery WHERE " . $cond . " ";
         $countQ = "SELECT COUNT(id) AS c FROM sc_gallery WHERE " . $cond;
         $href = "/gallery/";
         $title = "Галлерея";
     }
     if ($key == 'content') {
         //				$cond=" mod_content_id=c_id AND (mod_location LIKE 'main' OR  mod_location LIKE 'footer' OR  mod_location LIKE 'top')
         //						AND (mod_name ILIKE '%".SQL::slashes($this->search)."%' OR mod_title ILIKE '%".SQL::slashes($this->search)."%' OR c_text ILIKE '%".SQL::slashes($this->search)."%')";
         //				$cond=" c_name ILIKE '%'||mod_alias||'%' AND mod_alias <>'/'";
         $cond = " mod_alias LIKE CONCAT('%',c_name,'%') AND mod_title<>'' AND c_text<>''";
         //				$cond=" mod_alias =c_name ";
         //				$cond.=" AND (mod_location LIKE '%main%' OR  mod_location LIKE '%footer%' OR  mod_location LIKE '%top%')";
         //				$cond.=" AND (mod_name ILIKE '%".SQL::slashes($this->search)."%' OR mod_title ILIKE '%".SQL::slashes($this->search)."%' OR c_text ILIKE '%".SQL::slashes($this->search)."%')";
         $subCond = array();
         foreach ($search as $s) {
             $subCond[] = "(mod_name LIKE '%" . SQL::slashes($s) . "%' OR mod_title LIKE '%" . SQL::slashes($s) . "%' OR c_text LIKE '%" . SQL::slashes($s) . "%')";
         }
         //				$cond.=" AND (".implode(' OR ',$subCond).")";
         $cond .= " AND (" . implode(' AND ', $subCond) . ")";
         //				$q="SELECT mod_alias AS id,mod_title AS title,mod_description AS description FROM sc_content,sc_module WHERE ".$cond." ";
         $q = "SELECT c_name AS id,mod_title AS title,mod_description AS description FROM sc_content,sc_module WHERE " . $cond . " ";
         $countQ = "SELECT COUNT(c_id) AS c FROM sc_content,sc_module WHERE " . $cond;
         $href = "";
         $title = "Разделы сайта";
     }
     if ($key == 'catalog') {
         $cond = "";
         //				$cond.=" AND (g.name ILIKE '%".SQL::slashes($this->search)."%' OR g.description ILIKE '%".SQL::slashes($this->search)."%' OR c.name ILIKE '%".SQL::slashes($this->search)."%' )";
         $subCond = array();
         foreach ($search as $s) {
             $subCond[] = "(i.name LIKE '%" . SQL::slashes($s) . "%' OR i.description LIKE '%" . SQL::slashes($s) . "%' )";
         }
         //				$cond.=" AND (".implode(' OR ',$subCond).")";
         $cond .= " AND (" . implode(' AND ', $subCond) . ")";
         $cat = LibCatalog::getInstance();
         $q = "SELECT g.*, g.id AS id, g.name AS title, g.description AS description FROM sc_shop_item g WHERE " . $cond . "";
         $q = "{$cat->select()} " . $cond . "";
         $countQ = "{$cat->selectCount()} " . $cond;
         $href = "/catalog/goods/";
         $title = "Товары";
     }
     return array($q, $countQ, $href, $title);
 }
Esempio n. 4
0
 function getBasket()
 {
     return LibCatalog::getInstance()->getBasket();
 }
 function actSend()
 {
     global $post;
     $item = $post->getArray('item');
     $cat = LibCatalog::getInstance();
     if ($item) {
         $rs = DB::select("SELECT * FROM sc_users WHERE  u_id IN(" . implode(',', $item) . ")");
         while ($rs->next()) {
             $rs1 = DB::select("SELECT * FROM sc_shop_item i,sc_shop_proposal p WHERE vendor={$rs->get('u_id')}\r\n\t\t\t\t{$cat->proposalCond()}\r\n\t\t\t\t\r\n\t\t\t\t")->toArray();
             $goods = $this->render(array('rs' => $rs1), dirname(__FILE__) . '/goods.snd.php');
             $password = '******';
             if ($post->getInt('with_pass')) {
                 $password = substr(md5(time() . $rs->get('mail')), 0, 8);
                 DB::update('sc_users', array('password' => md5($password)), "u_id={$rs->get('u_id')}");
             }
             $notice = array('name' => $rs->get('name'), 'login' => $rs->get('login'), 'password' => $password, 'goods' => $goods, 'href' => "http://{$_SERVER['HTTP_HOST']}/");
             $this->sendTemplateMail($rs->get('mail'), 'notice_check_vendor', $notice);
         }
     }
     echo printJSON(array('msg' => 'Отправлено'));
     exit;
 }
Esempio n. 6
0
 function getMainCat()
 {
     return LibCatalog::getInstance()->getCatalogTree();
 }
Esempio n. 7
0
 function actRemove()
 {
     global $get;
     $key = $get->get('key');
     $basket = LibCatalog::getInstance()->getBasketData();
     unset($basket[$key]);
     $this->saveBasketData($basket);
     echo printJSON(array('key' => $key));
     exit;
 }