public static function getInstance() { if (self::$classInstance === null) { self::$classInstance = new self(); } return self::$classInstance; }
public function countVideos($listtype) { switch ($listtype) { case 'featured': $featuredDao = IVIDEO_BOL_VideoFeaturedDao::getInstance(); $query = "\n SELECT COUNT(`c`.`id`) \n FROM `" . $this->getTableName() . "` AS `c`\n LEFT JOIN `" . $featuredDao->getTableName() . "` AS `f` ON ( `c`.`id` = `f`.`videoId` )\n WHERE `c`.`status` = 'approved' AND `c`.`privacy` = 'everybody' AND `f`.`id` IS NOT NULL\n "; return $this->dbo->queryForColumn($query); break; case 'latest': $example = new OW_Example(); $example->andFieldEqual('status', 'approved'); $example->andFieldEqual('privacy', 'everybody'); return $this->countByExample($example); break; case 'pending': $example = new OW_Example(); $example->andFieldEqual('status', 'pending'); return $this->countByExample($example); break; } }
private function __construct() { $this->videoFeaturedDao = IVIDEO_BOL_VideoFeaturedDao::getInstance(); }