/**
* Returns an instance of class
*
* @return BOL_BillingGatewayDao
*/
public static function getInstance()
{
if (self::$classInstance === null) {
self::$classInstance = new self();
}
return self::$classInstance;
}
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));
}
/**
* Returns the list of gateways without dynamic pricing support
*/
public function getNotDynamicGatewaysList()
{
return $this->billingGatewayDao->getNotDynamicList();
}
public function addConfig($gatewayKey, $name, $value)
{
if (!mb_strlen($gatewayKey) || !mb_strlen($name)) {
return false;
}
$gateway = BOL_BillingGatewayDao::getInstance()->findByKey($gatewayKey);
if ($gateway) {
$config = new BOL_BillingGatewayConfig();
$config->gatewayId = $gateway->id;
$config->name = $name;
$config->value = $value;
$this->save($config);
return true;
}
return false;
}
