public function testImportWorks()
{
// Export data
$data = $this->exportHandler->buildData(Lang::getDefaultLanguage());
$compareData = array();
$currentData = $data->getData();
// Replace the prices
foreach ($currentData as $key => &$entry) {
// let 6/10 prices be changed.
if (rand(1, 100) >= 60) {
$compareData[$key] = $rand = rand(1, 1000);
$entry["price"] = $rand;
} else {
$compareData[$key] = $entry["price"];
}
}
// Import new prices
$this->importHandler->retrieveFromFormatterData($data->setData($currentData));
// Export once again
$newData = $this->exportHandler->buildData(Lang::getDefaultLanguage());
$newDataEntries = $newData->getData();
// Check them
foreach ($compareData as $key => $price) {
$this->assertEquals($price, $newDataEntries[$key]["price"]);
}
}
public function testQuery()
{
new Translator(new Container());
$export = new ProductPricesExport(new Container());
$data = $export->buildData(Lang::getDefaultLanguage());
$keys = ["attributes", "currency", "ean", "id", "price", "product_id", "promo", "promo_price", "title"];
$rawData = $data->getData();
$max = count($rawData);
/**
* If there's more that 50 entries,
* just pick 50, it would be faster and as tested as if we test 1000 entries.
*/
if ($max > 50) {
$max = 50;
}
for ($i = 0; $i < $max; ++$i) {
$row = $rawData[$i];
$rowKeys = array_keys($row);
$this->assertTrue(sort($rowKeys));
$this->assertEquals($keys, $rowKeys);
$pse = ProductSaleElementsQuery::create()->findPk($row["id"]);
$this->assertNotNull($pse);
$this->assertEquals($pse->getEanCode(), $row["ean"]);
$this->assertEquals($pse->getPromo(), $row["promo"]);
$currency = CurrencyQuery::create()->findOneByCode($row["currency"]);
$this->assertNotNull($currency);
$price = $pse->getPricesByCurrency($currency);
// The substr is a patch for php 5.4 float round
$this->assertEquals(round($price->getPrice(), 3), round($row["price"], 3));
$this->assertEquals(round($price->getPromoPrice(), 3), round($row["promo_price"], 3));
$this->assertEquals($pse->getProduct()->getTitle(), $row["title"]);
$attributeCombinations = $pse->getAttributeCombinations();
$attributes = [];
foreach ($attributeCombinations as $attributeCombination) {
if (!in_array($attributeCombination->getAttributeAv()->getTitle(), $attributes)) {
$attributes[] = $attributeCombination->getAttributeAv()->getTitle();
}
}
$rowAttributes = explode(",", $row["attributes"]);
sort($rowAttributes);
sort($attributes);
$this->assertEquals($attributes, $rowAttributes);
}
}
public function buildDataSet(Lang $lang)
{
/** @var \Thelia\Model\AttributeCombinationQuery $query */
$query = parent::buildDataSet($lang);
$pseJoin = new Join(AttributeCombinationTableMap::PRODUCT_SALE_ELEMENTS_ID, ProductSaleElementsTableMap::ID);
$pseJoin->setRightTableAlias("pse_tax_join");
$productJoin = new Join(ProductSaleElementsTableMap::ID, ProductTableMap::ID);
$productJoin->setRightTableAlias("product_tax_join");
$taxJoin = new Join("`product_tax_join`.TAX_RULE_ID", TaxRuleTableMap::ID, Criteria::LEFT_JOIN);
$taxI18nJoin = new Join(TaxRuleTableMap::ID, TaxRuleI18nTableMap::ID, Criteria::LEFT_JOIN);
$query->addJoinObject($pseJoin, "pse_tax_join")->addJoinObject($productJoin, "product_tax_join")->addJoinObject($productJoin)->addJoinObject($taxJoin)->addJoinObject($taxI18nJoin)->addAsColumn("product_TAX_TITLE", TaxRuleI18nTableMap::TITLE)->addAsColumn("tax_ID", TaxRuleTableMap::ID)->select($query->getSelect() + ["product_TAX_TITLE", "tax_ID"]);
I18n::addI18nCondition($query, TaxRuleI18nTableMap::TABLE_NAME, TaxRuleTableMap::ID, TaxRuleI18nTableMap::ID, TaxRuleI18nTableMap::LOCALE, $lang->getLocale());
$dataSet = $query->keepQuery(true)->find()->toArray();
$productSaleElements = ProductSaleElementsQuery::create()->find()->toKeyIndex("Id");
$currencies = CurrencyQuery::create()->find()->toKeyIndex("Code");
foreach ($dataSet as &$line) {
/** @var \Thelia\Model\ProductSaleElements $pse */
$pse = $productSaleElements[$line["product_sale_elements_ID"]];
$pricesTools = $pse->getPricesByCurrency($currencies[$line["currency_CODE"]]);
$line["price_PRICE"] = $pricesTools->getPrice();
$line["price_PROMO_PRICE"] = $pricesTools->getPromoPrice();
}
return $dataSet;
}
