/**
*
* @param str $productName
* @param str $policyOption
*/
public function getProductOptionDiscountListByProductAndOptionName($productName, $policyOption)
{
$optds = new Datasource_Core_Product_Options();
$opt = $optds->getProductOptionByProductAndOptionName($productName, $policyOption);
$select = $this->select()->where('productOptionID = ?', $opt->getProductOptionsId());
$row = $this->fetchAll($select);
if (count($row)) {
$discount = array();
foreach ($row as $data) {
$prodOptDisc = new Model_Core_Product_ProductOptionDiscount();
$prodOptDisc->populate($data);
$discount[] = $prodOptDisc;
}
} else {
$discount = false;
}
return $discount;
}
/**
* Fetch a csu Team by the csu
* For supervise use
* @param int $csuid
* @param int $productOptionID
* @return csuTeamID
*/
public function getProductDiscByCsuProductOptionId($csuid, $productOptionID)
{
$select = $this->select()->setIntegrityCheck(false)->from(array('c' => $this->_name))->join(array('d' => 'productOptionDiscount'), 'd.id=c.productOptDiscID')->where('d.productOptionID = ?', $productOptionID)->where('c.csuid = ?', $csuid);
$row = $this->fetchAll($select);
if (count($row) > 0) {
$pricelist = array();
foreach ($row as $data) {
$csuDiscount = new Model_Core_Discount_CsuDiscount();
$csuDiscount->populate($data);
$prodOptDisc = new Model_Core_Product_ProductOptionDiscount();
$prodOptDisc->populate($data);
$prodOpts = new Datasource_Core_Product_Options();
$pricelist[] = new Model_Core_Discount_CsuProductOptionDiscount($csuDiscount, $prodOptDisc, $prodOpts->getProductOptionsByID($data['productOptionID']));
}
} else {
$pricelist = false;
}
return $pricelist;
}
