PHP Model::total Examples

Example #1

File: UserModel.class.php Project: e0zhao02/sample_code

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

Example #2

File: VoteModel.class.php Project: 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);
 }

Example #3

File: ContentModel.class.php Project: 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);
 }

Example #4

File: GoodsModel.class.php Project: 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() . ')')));
     }
 }

Example #5

File: UserModel.class.php Project: 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);
 }

Example #6

File: NavModel.class.php Project: 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);
 }

Example #7

File: ManageModel.class.php Project: 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);
 }

Example #8

File: RecordModel.class.php Project: zhendeguoke1008/shop-1

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

Example #9

File: AdverModel.class.php Project: 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);
 }

Example #10

File: RotatainModel.class.php Project: 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);
 }

Example #11

File: NavModel.class.php Project: zhendeguoke1008/shop-1

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

Example #12

File: LevelModel.class.php Project: 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);
 }

Example #13

File: ContentModel.class.php Project: 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);
 }

Example #14

File: ManageModel.class.php Project: e0zhao02/sample_code

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

Example #15

File: CommendModel.class.php Project: 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));
 }

Example #16

File: GoodsModel.class.php Project: 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);
     }
 }

Example #17

File: NavModel.class.php Project: yjf0503/Mall

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

Example #18

File: PremissionModel.class.php Project: 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);
 }

Example #19

File: CommentModel.class.php Project: e0zhao02/sample_code

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

Example #20

File: CommentModel.class.php Project: 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);
 }

Example #21

File: LevelModel.class.php Project: e0zhao02/sample_code

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

Example #22

File: ContentModel.class.php Project: 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);
 }

Example #23

File: OrderModel.class.php Project: zhendeguoke1008/shop-1

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

Example #24

File: OrderModel.class.php Project: 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();
     }
 }

Example #25

File: BrandModel.class.php Project: zhendeguoke1008/shop-1

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

Example #26

File: NavModel.class.php Project: e0zhao02/sample_code

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