コード例 #1
0
ファイル: plugin_service.php プロジェクト: hardikamutech/loov
 /**
  * Constructor.
  */
 private function __construct()
 {
     $this->pluginDao = BOL_PluginDao::getInstance();
     $this->readPluginsList();
 }
コード例 #2
0
 public function getSaleList($page, $onPage)
 {
     $first = ($page - 1) * $onPage;
     $gatewayDao = BOL_BillingGatewayDao::getInstance();
     $pluginDao = BOL_PluginDao::getInstance();
     $sql = "SELECT `s`.*, `gw`.`gatewayKey`, `p`.`title` AS `pluginTitle` \n            FROM `" . $this->getTableName() . "` AS `s`\n            LEFT JOIN `" . $gatewayDao->getTableName() . "` AS `gw` ON (`s`.`gatewayId` = `gw`.`id`)\n            LEFT JOIN `" . $pluginDao->getTableName() . "` AS `p` ON (`s`.`pluginKey` = `p`.`key`)\n            WHERE `s`.`status` = 'delivered'\n            ORDER BY `timeStamp` DESC\n            LIMIT :first, :limit";
     return $this->dbo->queryForList($sql, array('first' => $first, 'limit' => $onPage));
 }