PHP Model::total示例

示例#1

文件： UserModel.class.php 项目： e0zhao02/sample_code

 public function getUserTotal()
 {
     $_sql = "select count(*) from cms_user;";
     return parent::total($_sql);
 }

示例#2

文件： VoteModel.class.php 项目： denson7/phpstudy

 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);
 }

示例#3

文件： ContentModel.class.php 项目： e0zhao02/sample_code

 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

文件： GoodsModel.class.php 项目： yjf0503/Mall

 public function total()
 {
     if (Validate::isNullString($this->_R['navid'])) {
         return parent::total();
     } else {
         return parent::total(array('where' => array('nav in(' . $this->getNavId() . ')')));
     }
 }

示例#5

文件： UserModel.class.php 项目： denson7/phpstudy

 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

文件： NavModel.class.php 项目： denson7/phpstudy

 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);
 }

示例#7

文件： ManageModel.class.php 项目： Cyc429170296/webName

 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);
 }

示例#8

文件： RecordModel.class.php 项目： zhendeguoke1008/shop-1

 public function total()
 {
     return parent::total(array('where' => array("goods_id='{$this->R['goodsid']}'")));
 }

示例#9

文件： AdverModel.class.php 项目： denson7/phpstudy

 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

文件： RotatainModel.class.php 项目： denson7/phpstudy

 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

文件： NavModel.class.php 项目： zhendeguoke1008/shop-1

 public function total()
 {
     $where = array("sid='{$this->R['sid']}'");
     return parent::total(array('where' => $where));
 }

示例#12

文件： LevelModel.class.php 项目： denson7/phpstudy

 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

文件： ContentModel.class.php 项目： denson7/phpstudy

 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

文件： ManageModel.class.php 项目： e0zhao02/sample_code

 public function getManageTotal()
 {
     $_sql = "select count(*) from cms_manage";
     return parent::total($_sql);
 }

示例#15

文件： CommendModel.class.php 项目： zhendeguoke1008/shop-1

 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

文件： GoodsModel.class.php 项目： zhendeguoke1008/shop-1

 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

文件： NavModel.class.php 项目： yjf0503/Mall

 public function total()
 {
     return parent::total(array('where' => array("sid='{$this->_R['sid']}'")));
 }

示例#18

文件： PremissionModel.class.php 项目： denson7/phpstudy

 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

文件： CommentModel.class.php 项目： e0zhao02/sample_code

 public function getCommentTotal()
 {
     $_sql = "select count(*) from cms_comment where cid='{$this->cid}';";
     return parent::total($_sql);
 }

示例#20

文件： CommentModel.class.php 项目： denson7/phpstudy

 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

文件： LevelModel.class.php 项目： e0zhao02/sample_code

 public function getLevelTotal()
 {
     $_sql = "select count(*) from cms_level;";
     return parent::total($_sql);
 }

示例#22

文件： ContentModel.class.php 项目： Cyc429170296/webName

 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

文件： OrderModel.class.php 项目： zhendeguoke1008/shop-1

 public function total()
 {
     return parent::total(array("user='******'user']}'"));
 }

示例#24

文件： OrderModel.class.php 项目： yjf0503/Mall

 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

文件： BrandModel.class.php 项目： zhendeguoke1008/shop-1

 public function total()
 {
     return parent::total();
 }

示例#26

文件： NavModel.class.php 项目： e0zhao02/sample_code

 public function getNavChildTotal()
 {
     $_sql = "select count(*) from cms_nav where pid={$this->id};";
     return parent::total($_sql);
 }