/** * Constructor. */ private function __construct() { $this->pluginDao = BOL_PluginDao::getInstance(); $this->readPluginsList(); }
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)); }