示例#1
0
 public function getUserTotal()
 {
     $_sql = "select count(*) from cms_user;";
     return parent::total($_sql);
 }
示例#2
0
 public function getVoteTotal()
 {
     $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\t\tCOUNT(*) \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\t\tcms_vote\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\tvid=0";
     return parent::total($_sql);
 }
 public function getListContentTotal()
 {
     $_sql = "select count(*) from cms_content c, cms_nav n where c.nav=n.id and c.nav in ({$this->nav});";
     return parent::total($_sql);
 }
示例#4
0
 public function total()
 {
     if (Validate::isNullString($this->_R['navid'])) {
         return parent::total();
     } else {
         return parent::total(array('where' => array('nav in(' . $this->getNavId() . ')')));
     }
 }
示例#5
0
 public function getUserTotal()
 {
     $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tCOUNT(*) \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\tcms_user";
     return parent::total($_sql);
 }
示例#6
0
 public function getNavChildTotal()
 {
     $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tCOUNT(*) \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\tcms_nav\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\tpid={$this->id}";
     return parent::total($_sql);
 }
 public function getManageTotal()
 {
     $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tCOUNT(*) \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\tcms_manage";
     return parent::total($_sql);
 }
 public function total()
 {
     return parent::total(array('where' => array("goods_id='{$this->R['goodsid']}'")));
 }
示例#9
0
 public function getAdverTotal()
 {
     $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\t\tCOUNT(*) \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\t\tcms_adver\n\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\ttype IN ({$this->kind})";
     return parent::total($_sql);
 }
示例#10
0
 public function getRotatainTotal()
 {
     $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tCOUNT(*) \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\tcms_rotatain";
     return parent::total($_sql);
 }
示例#11
0
 public function total()
 {
     $where = array("sid='{$this->R['sid']}'");
     return parent::total(array('where' => $where));
 }
示例#12
0
 public function getLevelTotal()
 {
     $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tCOUNT(*) \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\tcms_level";
     return parent::total($_sql);
 }
示例#13
0
 public function getListContentTotal()
 {
     $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tCOUNT(*) \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\t\tcms_content c,\n\t\t\t\t\t\t\t\t\t\t\tcms_nav n\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\tc.nav=n.id\n\t\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\t\t\t\tc.nav IN ({$this->nav})";
     return parent::total($_sql);
 }
示例#14
0
 public function getManageTotal()
 {
     $_sql = "select count(*) from cms_manage";
     return parent::total($_sql);
 }
 public function total()
 {
     if ($this->R['goods_id']) {
         $where = array("goods_id='{$this->R['goods_id']}'");
     } else {
         $where = array("user='******'user']}'");
     }
     return parent::total(array('where' => $where));
 }
示例#16
0
 public function total()
 {
     if ($this->getId()) {
         $where = array('where' => array("nav IN ('{$this->getId()}')"));
         return parent::total($where);
     } elseif ($_POST['way'] == 'nav' && isset($_POST['content'])) {
         $this->tables = array(DB_FREFIX . 'goods a', DB_FREFIX . 'nav b');
         $where = array("b.name LIKE '%{$_POST['content']}%'");
         $this->tables = array(DB_FREFIX . 'goods');
         return parent::total($where);
     } else {
         $where = '';
         return parent::total($where);
     }
 }
示例#17
0
 public function total()
 {
     return parent::total(array('where' => array("sid='{$this->_R['sid']}'")));
 }
示例#18
0
 public function getPremissionTotal()
 {
     $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\t\tCOUNT(*) \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\t\tcms_premission";
     return parent::total($_sql);
 }
示例#19
0
 public function getCommentTotal()
 {
     $_sql = "select count(*) from cms_comment where cid='{$this->cid}';";
     return parent::total($_sql);
 }
示例#20
0
 public function getCommentTotal()
 {
     $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tCOUNT(*) \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\t\tcms_comment \n\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\tstate=1\n\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\t\t\t\tcid='{$this->cid}'";
     return parent::total($_sql);
 }
示例#21
0
 public function getLevelTotal()
 {
     $_sql = "select count(*) from cms_level;";
     return parent::total($_sql);
 }
示例#22
0
 public function getContentTotal()
 {
     $_sql = "SELECT \n\t\t\t\t\t\t\t\t\t\tCOUNT(*) \n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\ttg_article\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\tmid = '{$this->mid}'";
     return parent::total($_sql);
 }
示例#23
0
 public function total()
 {
     return parent::total(array("user='******'user']}'"));
 }
示例#24
0
 public function total()
 {
     if (isset($_COOKIE['user']) && $_GET['a'] == 'member' && $_GET['m'] == 'order') {
         return parent::total(array('where' => array("user='******'user']}'")));
     } else {
         return parent::total();
     }
 }
示例#25
0
 public function total()
 {
     return parent::total();
 }
示例#26
0
 public function getNavChildTotal()
 {
     $_sql = "select count(*) from cms_nav where pid={$this->id};";
     return parent::total($_sql);
 }