/** * Returns class instance * * @return YNSOCIALCONNECT_BOL_AgentsDao */ public static function getInstance() { if (self::$classInstance === null) { self::$classInstance = new self(); } return self::$classInstance; }
public function findByUserId($userId) { // init sql query $servicesDao = YNSOCIALCONNECT_BOL_ServicesDao::getInstance(); $agentsDao = YNSOCIALCONNECT_BOL_AgentsDao::getInstance(); $sqlQuery = "\n\t SELECT \t`ynu`.id, `ynu`.userId, `ynu`.identity, `ynu`.serviceId, `yns`.name, `yns`.title, `yna`.tokenData \t\n\t FROM {$this->getTableName()} AS `ynu`\n\t INNER JOIN `" . $servicesDao->getTableName() . "` AS `yns` ON(`yns`.`id` = `ynu`.`serviceId`) \n\t INNER JOIN `" . $agentsDao->getTableName() . "` AS `yna` ON(`yna`.`userId` = `ynu`.`userId` AND `yna`.`serviceId` = `ynu`.`serviceId` AND `yna`.`identity` = `ynu`.`identity` )\n\t WHERE 1=1 \n\t\t "; $sqlQuery .= " AND `ynu`.userId = :userId"; $sqlQuery .= " ORDER BY `yns`.ordering ASC, `ynu`.id ASC "; return $this->dbo->queryForList($sqlQuery, array('userId' => $userId)); }
private function __construct() { $this->agentsDao = YNSOCIALCONNECT_BOL_AgentsDao::getInstance(); }