/** * Class constructor * */ private function __construct() { $this->balanceDao = USERCREDITS_BOL_BalanceDao::getInstance(); $this->actionDao = USERCREDITS_BOL_ActionDao::getInstance(); $this->actionPriceDao = USERCREDITS_BOL_ActionPriceDao::getInstance(); $this->packDao = USERCREDITS_BOL_PackDao::getInstance(); $this->logDao = USERCREDITS_BOL_LogDao::getInstance(); }
/** * Finds action list by type * * @param string $type * @param $accTypeId * @return array */ public function findList($type, $accTypeId) { switch ($type) { case 'earn': $amountCond = ' AND `ap`.`amount` > 0 '; break; case 'lose': $amountCond = ' AND `ap`.`amount` < 0 '; break; default: $amountCond = ' AND `ap`.`amount` = 0 '; break; } $actionPriceDao = USERCREDITS_BOL_ActionPriceDao::getInstance(); $sql = "SELECT `a`.*, `ap`.`amount`, `ap`.`disabled` FROM `" . $this->getTableName() . "` AS `a`\n LEFT JOIN `" . $actionPriceDao->getTableName() . "` AS `ap`\n ON (`a`.`id`=`ap`.`actionId` AND `ap`.`accountTypeId` = :id)\n WHERE `a`.`isHidden` = 0 AND `a`.`active` = 1 " . $amountCond; return $this->dbo->queryForList($sql, array('id' => $accTypeId)); }