/**
* Returns an instance of class (singleton pattern implementation).
*
* @return BOL_PluginDao
*/
public static function getInstance()
{
if (self::$classInstance === null) {
self::$classInstance = new self();
}
return self::$classInstance;
}
private function updatePluginListCache()
{
$this->pluginListCache = array();
$dbData = $this->pluginDao->findAll();
/* @var $plugin BOL_Plugin */
foreach ($dbData as $plugin) {
$this->pluginListCache[$plugin->getKey()] = $plugin;
}
}
public function findAdsEnabledPluginList()
{
return array('base' => $this->pluginDao->findPluginByKey('base'));
}
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));
}