public function newRule($sender, $param)
{
$results = $errors = array();
try {
Dao::beginTransaction();
$results = $param->CallbackParameter;
if (!isset($param->CallbackParameter->productId) || !($product = Product::get(trim($param->CallbackParameter->productId))) instanceof Product) {
throw new Exception('Invalid Product Id passed in, "' . $param->CallbackParameter->productId . '" given');
}
if (!isset($param->CallbackParameter->rule)) {
throw new Exception('Invalid PriceMatchRule passed in, "' . $param->CallbackParameter->rule . '" given');
}
if (!isset($param->CallbackParameter->rule->active)) {
throw new Exception('Must pass in active (bool) for PriceMatchRule, "' . $param->CallbackParameter->rule->active . '" given');
} else {
$active = $param->CallbackParameter->rule->active;
}
if ($active === true && (!isset($param->CallbackParameter->rule->company_id) || !($company = PriceMatchCompany::get(trim($param->CallbackParameter->rule->company_id))) instanceof PriceMatchCompany)) {
throw new Exception('Invalid PriceMatchCompany Id passed in, "' . $param->CallbackParameter->rule->company_id . '" given');
}
if ($active === false && ($rule = ProductPriceMatchRule::getByProduct($product)) instanceof ProductPriceMatchRule) {
$rule->setActive($active)->save();
$results = $rule->getJson();
} elseif ($active === true) {
$rule = ProductPriceMatchRule::create($product, $company, trim($param->CallbackParameter->rule->price_from), trim($param->CallbackParameter->rule->price_to), trim($param->CallbackParameter->rule->offset));
//file_put_contents('/tmp/datafeed/web.log', __FILE__ .':' . __FUNCTION__ . ':' . __LINE__ . ': run' . date('Y-m-d\TH:i:sP') . PHP_EOL, FILE_APPEND | LOCK_EX);
PriceMatchConnector::run($product->getSku(), true);
//file_put_contents('/tmp/datafeed/web.log', __FILE__ .':' . __FUNCTION__ . ':' . __LINE__ . ': getMinRecord' . date('Y-m-d\TH:i:sP'). PHP_EOL, FILE_APPEND | LOCK_EX);
PriceMatchConnector::getMinRecord($product->getSku(), true);
//file_put_contents('/tmp/datafeed/web.log', __FILE__ .':' . __FUNCTION__ . ':' . __LINE__ . ': getNewPrice' . date('Y-m-d\TH:i:sP') . PHP_EOL, FILE_APPEND | LOCK_EX);
PriceMatchConnector::getNewPrice($product->getSku(), true, true);
//file_put_contents('/tmp/datafeed/web.log', __FILE__ .':' . __FUNCTION__ . ':' . __LINE__ . ': end' . date('Y-m-d\TH:i:sP'). PHP_EOL, FILE_APPEND | LOCK_EX);
$results = $rule->getJson();
}
Dao::commitTransaction();
} catch (Exception $ex) {
Dao::rollbackTransaction();
$errors[] = $ex->getMessage();
}
$param->ResponseData = StringUtilsAbstract::getJson($results, $errors);
}
private function _getNewPrice($updateMagento)
{
$result = null;
$sku = $this->sku;
$updateMagento = $updateMagento === true ? true : false;
$product = Product::getBySku($sku);
if (!$product instanceof Product) {
throw new Exception('Invalid sku passed in, "' . $sku . '" given');
}
$min = PriceMatchMin::getBySku($sku);
$rule = ProductPriceMatchRule::getByProduct($product);
$prices = ProductPrice::getPrices($product, ProductPriceType::get(ProductPriceType::ID_RRP));
if (count($prices) === 0) {
$newPrice = ProductPrice::create($product, ProductPriceType::get(ProductPriceType::ID_RRP), 0);
$prices = array($newPrice);
}
// if(($magePrice = $this->_getMagentoProductPrice($sku)) !== null)
// $prices[0]->setPrice($magePrice)->save();
$myPrice = $prices[0]->getPrice();
if (!$min instanceof PriceMatchMin) {
$min = PriceMatchMin::create($this->sku);
}
if ($rule instanceof ProductPriceMatchRule) {
$company = $rule->getCompany();
$price_from = $rule->getPrice_from();
$price_to = $rule->getPrice_to();
$offset = $rule->getOffset();
$where = array(1);
$params = array();
$where[] = "minId = ? ";
$params[] = $min->getId();
$from_date = UDate::now('Australia/Melbourne')->setTime(0, 0, 0)->setTimeZone('UTC');
$to_date = UDate::now('Australia/Melbourne')->setTime(23, 59, 59)->setTimeZone('UTC');
$where[] = "created >= ? ";
$params[] = $from_date;
$where[] = "created <= ? ";
$params[] = $to_date;
$companies = $company->getAllAlias();
$companyIds = array_map(create_function('$a', 'return $a->getId();'), $companies);
$where[] = 'companyId IN (' . implode(", ", array_fill(0, count($companyIds), "?")) . ')';
$params = array_merge($params, $companyIds);
//calculate target compatitor price
$records = PriceMatchRecord::getAllByCriteria(implode(' AND ', $where), $params, true, null, DaoQuery::DEFAUTL_PAGE_SIZE, array('price' => 'asc'));
$base_price = null;
foreach ($records as $record) {
if ($base_price === null || doubleval($record->getPrice()) !== doubleval(0) && doubleval($record->getPrice()) < doubleval($base_price)) {
$base_price = doubleval($record->getPrice());
}
}
if ($base_price !== null) {
if ($price_from !== null) {
if (strpos($price_from, '%') !== false) {
$price_from = $base_price - $base_price * doubleval(0.01 * doubleval(str_replace('%', '', $price_from)));
} else {
$price_from = $base_price - doubleval($price_from);
}
if (doubleval($price_from) <= doubleval(0)) {
$price_from = doubleval(0);
}
}
if ($price_to !== null) {
if (strpos($price_to, '%') !== false) {
$price_to = $base_price + $base_price * doubleval(0.01 * doubleval(str_replace('%', '', $price_to)));
} else {
$price_to = $base_price + doubleval($price_to);
}
}
// check if in range
if (($price_from === null || $myPrice >= $price_from) && ($price_to === null || $myPrice <= $price_to)) {
$result = $base_price;
// apply offset
if ($offset !== null) {
if (strpos($offset, '%') !== false) {
$result = $result + $result * doubleval(0.01 * doubleval(str_replace('%', '', $offset)));
} else {
$result = $result + doubleval($offset);
}
}
// set product price
if (isset($prices[0]) && $prices[0] instanceof ProductPrice) {
$newmatchprice = doubleval($result);
if ($newmatchprice > 0) {
$oldPrice = $prices[0]->getPrice();
echo 'update price from old price : ' . $oldPrice . ' to new price :' . $newmatchprice . "\n";
$prices[0]->setPrice(doubleval($result))->save()->addLog('PriceMatch change price from $' . $oldPrice . 'to new price $' . $result, Log::TYPE_SYSTEM);
// if($updateMagento === true)
// $this->updateMagentoPrice(doubleval($result));
} else {
echo 'not update price because new match price is 0 ( ' . $newmatchprice . ' )' . "\n";
}
}
}
} else {
if ($this->debug === true) {
echo "cannot find price for PriceMatchCompany " . $company->getCompanyName() . ', ' . $product->getSku() . '(id=' . $product->getId() . ', min(id=' . $min->getId() . '), records found:' . count($records) . "\n";
}
}
if ($this->debug === true) {
echo 'new price= ' . ($result === null ? 'N/A' : $result) . ', my price= ' . (isset($myPrice) ? $myPrice : 'N/A') . ', ' . $company->getCompanyName() . ' price= ' . $base_price . ', matching range=[' . $price_from . ',' . $price_to . '], offset=' . ($offset === null ? 'null' : $offset) . "\n";
}
} elseif ($this->debug === true) {
echo ($min instanceof PriceMatchMin ? '' : 'Cannot find result on StaticIce for all known PriceMatchCompanies') . ($rule instanceof ProductPriceMatchRule ? '' : 'cannot find ProductPriceMatchRule for product ' . $product->getSku() . '(id=' . $product->getId() . ')') . "\n";
}
return $result;
}
/**
* (non-PHPdoc)
* @see BaseEntityAbstract::getJson()
*/
public function getJson($extra = array(), $reset = false)
{
try {
$array = $extra;
if (!$this->isJsonLoaded($reset)) {
$array['prices'] = array_map(create_function('$a', 'return $a->getJson();'), $this->getPrices());
$array['manufacturer'] = $this->getManufacturer() instanceof Manufacturer ? $this->getManufacturer()->getJson() : null;
$array['supplierCodes'] = array_map(create_function('$a', 'return $a->getJson();'), SupplierCode::getAllByCriteria('productId = ?', array($this->getId())));
$array['productCodes'] = array_map(create_function('$a', 'return $a->getJson();'), ProductCode::getAllByCriteria('productId = ?', array($this->getId())));
$array['images'] = array_map(create_function('$a', 'return $a->getJson();'), $this->getImages());
$array['categories'] = array_map(create_function('$a', '$json = $a->getJson(); return $json["category"];'), Product_Category::getCategories($this));
$array['fullDescriptionAsset'] = ($asset = Asset::getAsset($this->getFullDescAssetId())) instanceof Asset ? $asset->getJson() : null;
$array['locations'] = array_map(create_function('$a', 'return $a->getJson();'), PreferredLocation::getPreferredLocations($this));
$array['unitCost'] = $this->getUnitCost();
$array['priceMatchRule'] = ($i = ProductPriceMatchRule::getByProduct($this)) instanceof ProductPriceMatchRule ? $i->getJson() : null;
$array['attributeSet'] = ($i = $this->getAttributeSet()) instanceof ProductAttributeSet ? $i->getJson() : null;
$array['status'] = ($i = $this->getStatus()) instanceof ProductStatus ? $i->getJson() : null;
}
} catch (Exception $ex) {
throw new Exception(' ********** getJson exception :' . $ex->getMessage());
}
return parent::getJson($array, $reset);
}
