public function testSearchItemsWithReference()
{
$context = TestHelper::getContext();
$params = (object) array('site' => 'unittest', 'condition' => (object) array('&&' => array(0 => (object) array('==' => (object) array('price.quantity' => 1000)))), 'sort' => 'price.quantity', 'dir' => 'ASC', 'start' => 0, 'limit' => 1);
$price = $this->_object->searchItems($params);
// find refs
$productManager = MShop_Product_Manager_Factory::createManager($context);
$productsList = $productManager->getSubManager('list');
$search = $productsList->createSearch();
$expr = array($search->compare('==', 'product.list.domain', 'price'), $search->compare('==', 'product.list.refid', $price['items'][0]->{'price.id'}));
$search->setConditions($search->combine('&&', $expr));
$sort = array($search->sort('+', 'product.list.id'));
$search->setSortations($sort);
$search->setSlice(0, 1);
$items = $productsList->searchItems($search);
if (($productItem = reset($items)) === false) {
throw new Exception('No item found');
}
$parentid = $productItem->getParentId();
// search with refs
$params = (object) array('site' => 'unittest', 'condition' => (object) array('&&' => array(0 => (object) array('==' => (object) array('price.quantity' => 1000)))), 'sort' => 'price.quantity', 'dir' => 'ASC', 'start' => 0, 'limit' => 1, 'domain' => 'product', 'parentid' => $parentid);
$result = $this->_object->searchItems($params);
$this->assertEquals(1, count($result['items']));
$this->assertEquals(1, $result['total']);
$this->assertTrue($result['success']);
$this->assertEquals($price['items'], $result['items']);
}
/**
* Initializes the product tag type controller.
*
* @param MShop_Context_Item_Interface $context MShop context object
*/
public function __construct(MShop_Context_Item_Interface $context)
{
parent::__construct($context, 'Product_Tag_Type');
$manager = MShop_Product_Manager_Factory::createManager($context);
$tagManager = $manager->getSubManager('tag');
$this->_manager = $tagManager->getSubManager('type');
}
public function testCreateManagerInvalidName()
{
$this->setExpectedException('MShop_Product_Exception');
$target = 'MShop_Common_Manager_Interface';
$manager = MShop_Product_Manager_Factory::createManager(TestHelper::getContext(), '#$%');
$this->assertInstanceOf($target, $manager);
}
/**
* Sets up the fixture, especially creates products.
* This method is called before a test is executed.
*
* @access protected
*/
protected function setUp()
{
$orderProducts = array();
$context = TestHelper::getContext();
$couponManager = MShop_Coupon_Manager_Factory::createManager($context);
$this->_couponItem = $couponManager->createItem();
$provider = new MShop_Coupon_Provider_Example($context, $this->_couponItem, 'abcd');
$this->_object = new MShop_Coupon_Provider_Decorator_BasketValues($context, $this->_couponItem, 'abcd', $provider);
$this->_object->setObject($this->_object);
$orderManager = MShop_Order_Manager_Factory::createManager($context);
$orderBaseManager = $orderManager->getSubManager('base');
$orderProductManager = $orderBaseManager->getSubManager('product');
$productManager = MShop_Product_Manager_Factory::createManager($context);
$search = $productManager->createSearch();
$search->setConditions($search->compare('==', 'product.code', array('CNC')));
$products = $productManager->searchItems($search);
$priceManager = MShop_Price_Manager_Factory::createManager($context);
$price = $priceManager->createItem();
$price->setValue(321);
foreach ($products as $product) {
$orderProduct = $orderProductManager->createItem();
$orderProduct->copyFrom($product);
$orderProducts[$product->getCode()] = $orderProduct;
}
$orderProducts['CNC']->setPrice($price);
$this->_orderBase = new MShop_Order_Item_Base_Default($priceManager->createItem(), $context->getLocale());
$this->_orderBase->addProduct($orderProducts['CNC']);
}
/**
* Adds product test data.
*/
protected function _process()
{
$iface = 'MShop_Context_Item_Interface';
if (!$this->_additional instanceof $iface) {
throw new MW_Setup_Exception(sprintf('Additionally provided object is not of type "%1$s"', $iface));
}
$this->_msg('Adding product-list test data', 0);
$this->_additional->setEditor('core:unittest');
$ds = DIRECTORY_SEPARATOR;
$path = dirname(__FILE__) . $ds . 'data' . $ds . 'product-list.php';
if (($testdata = (include $path)) == false) {
throw new MShop_Exception(sprintf('No file "%1$s" found for product domain', $path));
}
$refKeys = array();
foreach ($testdata['product/list'] as $dataset) {
$refKeys[$dataset['domain']][] = $dataset['refid'];
}
$productManager = MShop_Product_Manager_Factory::createManager($this->_additional, 'Default');
$refIds = array();
$refIds['attribute'] = $this->_getAttributeData($refKeys['attribute']);
$refIds['media'] = $this->_getMediaData($refKeys['media']);
$refIds['price'] = $this->_getPriceData($refKeys['price']);
$refIds['text'] = $this->_getTextData($refKeys['text']);
$refIds['product/tag'] = $this->_getProductTagData($productManager, $refKeys['product/tag']);
$this->_addProductData($testdata, $productManager, $refIds, $refKeys['product']);
$this->_status('done');
}
/**
* Sets up the fixture.
* This method is called before a test is executed.
*
* @access protected
*/
protected function setUp()
{
$this->_editor = TestHelper::getContext()->getEditor();
$manager = MShop_Product_Manager_Factory::createManager(TestHelper::getContext());
$listManager = $manager->getSubManager('list');
$this->_object = $listManager->getSubManager('type');
}
/**
* Adds the product test data.
*
* @param array $testdata Associative list of key/list pairs
* @throws MW_Setup_Exception If no type ID is found
*/
private function _addProductData(array $testdata)
{
$productManager = MShop_Product_Manager_Factory::createManager($this->_additional, 'Default');
$productTypeManager = $productManager->getSubManager('type', 'Default');
$typeIds = array();
$type = $productTypeManager->createItem();
$this->_conn->begin();
foreach ($testdata['product/type'] as $key => $dataset) {
$type->setId(null);
$type->setCode($dataset['code']);
$type->setDomain($dataset['domain']);
$type->setLabel($dataset['label']);
$type->setStatus($dataset['status']);
$productTypeManager->saveItem($type);
$typeIds[$key] = $type->getId();
}
$product = $productManager->createItem();
foreach ($testdata['product'] as $key => $dataset) {
if (!isset($typeIds[$dataset['typeid']])) {
throw new MW_Setup_Exception(sprintf('No product type ID found for "%1$s"', $dataset['typeid']));
}
$product->setId(null);
$product->setTypeId($typeIds[$dataset['typeid']]);
$product->setCode($dataset['code']);
$product->setLabel($dataset['label']);
$product->setSupplierCode($dataset['suppliercode']);
$product->setStatus($dataset['status']);
$productManager->saveItem($product, false);
}
$this->_conn->commit();
}
/**
* Initializes the product stock warehouse controller.
*
* @param MShop_Context_Item_Interface $context MShop context object
*/
public function __construct(MShop_Context_Item_Interface $context)
{
parent::__construct($context, 'Product_Stock_Warehouse');
$manager = MShop_Product_Manager_Factory::createManager($context);
$stockManager = $manager->getSubManager('stock');
$this->_manager = $stockManager->getSubManager('warehouse');
}
/**
* Adds product stock test data.
*/
protected function _process()
{
$iface = 'MShop_Context_Item_Interface';
if (!$this->_additional instanceof $iface) {
throw new MW_Setup_Exception(sprintf('Additionally provided object is not of type "%1$s"', $iface));
}
$this->_msg('Adding warehouse data', 0);
$ds = DIRECTORY_SEPARATOR;
$path = dirname(__FILE__) . $ds . 'default' . $ds . 'data' . $ds . 'warehouse.php';
if (($data = (include $path)) == false) {
throw new MShop_Exception(sprintf('No file "%1$s" found for product stock domain', $path));
}
$manager = MShop_Product_Manager_Factory::createManager($this->_additional);
$warehouseManager = $manager->getSubManager('stock')->getSubManager('warehouse');
$num = $total = 0;
$item = $warehouseManager->createItem();
foreach ($data['warehouse'] as $key => $dataset) {
$total++;
$item->setId(null);
$item->setCode($dataset['code']);
$item->setLabel($dataset['label']);
$item->setStatus($dataset['status']);
try {
$warehouseManager->saveItem($item);
$num++;
} catch (MW_DB_Exception $e) {
}
// if warehouse was already available
}
$this->_status($num > 0 ? $num . '/' . $total : 'OK');
}
/**
* Initializes the product list controller.
*
* @param MShop_Context_Item_Interface $context MShop context object
*/
public function __construct(MShop_Context_Item_Interface $context)
{
parent::__construct($context, 'Product_List');
$manager = MShop_Product_Manager_Factory::createManager($context);
$this->_manager = $manager->getSubManager('list');
$this->_context = $context;
}
/**
* Adds the product property test data.
*
* @param array $testdata Associative list of key/list pairs
* @throws MW_Setup_Exception If no type ID is found
*/
private function _addProductPropertyData(array $testdata)
{
$productManager = MShop_Product_Manager_Factory::createManager($this->_additional, 'Default');
$productPropertyManager = $productManager->getSubManager('property', 'Default');
$productPropertyTypeManager = $productPropertyManager->getSubManager('type', 'Default');
$typeIds = array();
$type = $productPropertyTypeManager->createItem();
$prodIds = $this->_getProductIds($productManager);
$this->_conn->begin();
foreach ($testdata['product/property/type'] as $key => $dataset) {
$type->setId(null);
$type->setCode($dataset['code']);
$type->setDomain($dataset['domain']);
$type->setLabel($dataset['label']);
$type->setStatus($dataset['status']);
$productPropertyTypeManager->saveItem($type);
$typeIds[$key] = $type->getId();
}
$prodProperty = $productPropertyManager->createItem();
foreach ($testdata['product/property'] as $key => $dataset) {
if (!isset($typeIds[$dataset['typeid']])) {
throw new MW_Setup_Exception(sprintf('No product property type ID found for "%1$s"', $dataset['typeid']));
}
$prodProperty->setId(null);
$prodProperty->setParentId($prodIds[$dataset['parentid']]);
$prodProperty->setTypeId($typeIds[$dataset['typeid']]);
$prodProperty->setLanguageId($dataset['langid']);
$prodProperty->setValue($dataset['value']);
$productPropertyManager->saveItem($prodProperty, false);
}
$this->_conn->commit();
}
/**
* Sets up the fixture, for example, opens a network connection.
* This method is called before a test is executed.
*
* @access protected
*/
protected function setUp()
{
$context = TestHelper::getContext();
$paths = TestHelper::getHtmlTemplatePaths();
$this->_object = new Client_Html_Catalog_List_Items_Default($context, $paths);
$catalogManager = MShop_Catalog_Manager_Factory::createManager($context);
$search = $catalogManager->createSearch();
$search->setConditions($search->compare('==', 'catalog.code', 'cafe'));
$catItems = $catalogManager->searchItems($search);
if (($catItem = reset($catItems)) === false) {
throw new Exception('No catalog item found');
}
$productManager = MShop_Product_Manager_Factory::createManager($context);
$search = $productManager->createSearch();
$search->setConditions($search->compare('==', 'product.code', array('CNC', 'CNE')));
$total = 0;
$view = TestHelper::getView();
$view->listProductItems = $productManager->searchItems($search, array('media', 'price', 'text'), $total);
$view->listProductTotal = $total;
$view->listPageSize = 100;
$view->listPageCurr = 1;
$view->listParams = array();
$view->listCatPath = array($catalogManager->createItem(), $catItem);
$this->_object->setView($view);
}
/**
* Sets up the fixture, for example, opens a network connection.
* This method is called before a test is executed.
*
* @access protected
*/
protected function setUp()
{
$pluginManager = MShop_Plugin_Manager_Factory::createManager(TestHelper::getContext());
$this->_plugin = $pluginManager->createItem();
$this->_plugin->setTypeId(2);
$this->_plugin->setProvider('PropertyMatch');
$this->_plugin->setConfig(array('product.suppliercode' => 'unitSupplier'));
$this->_plugin->setStatus('1');
$orderManager = MShop_Order_Manager_Factory::createManager(TestHelper::getContext());
$orderBaseManager = $orderManager->getSubManager('base');
$orderBaseProductManager = $orderBaseManager->getSubManager('product');
$manager = MShop_Product_Manager_Factory::createManager(TestHelper::getContext());
$search = $manager->createSearch();
$search->setConditions($search->compare('==', 'product.code', array('CNE', 'CNC')));
$products = $manager->searchItems($search);
if (count($products) !== 2) {
throw new Exception('Wrong number of products');
}
$this->_products = array();
foreach ($products as $product) {
$item = $orderBaseProductManager->createItem();
$item->copyFrom($product);
$this->_products[$product->getCode()] = $item;
}
$this->_order = $orderBaseManager->createItem();
$this->_object = new MShop_Plugin_Provider_Order_PropertyMatch(TestHelper::getContext(), $this->_plugin);
}
public function testSaveDeleteItem()
{
$ctx = TestHelper::getContext();
$productManager = MShop_Product_Manager_Factory::createManager($ctx);
$warehouseManager = $productManager->getSubManager('stock')->getSubManager('warehouse');
$search = $warehouseManager->createSearch();
$search->setConditions($search->compare('==', 'product.stock.warehouse.code', 'default'));
$search->setSlice(0, 1);
$items = $warehouseManager->searchItems($search);
if (($warehouseItem = reset($items)) === false) {
throw new Exception('No item found');
}
$search = $productManager->createSearch();
$search->setConditions($search->compare('~=', 'product.label', 'Cheapest'));
$items = $productManager->searchItems($search);
if (($productItem = reset($items)) === false) {
throw new Exception('No item found');
}
$saveParams = (object) array('site' => 'unittest', 'items' => (object) array('product.stock.productid' => $productItem->getId(), 'product.stock.warehouseid' => $warehouseItem->getId(), 'product.stock.stocklevel' => 999, 'product.stock.dateback' => '2000-01-01 00:00:01'));
$saved = $this->_object->saveItems($saveParams);
$searchParams = (object) array('site' => 'unittest', 'condition' => (object) array('&&' => array(0 => (object) array('==' => (object) array('product.stock.dateback' => '2000-01-01 00:00:01')))));
$searched = $this->_object->searchItems($searchParams);
$deleteParams = (object) array('site' => 'unittest', 'items' => $saved['items']->{'product.stock.id'});
$this->_object->deleteItems($deleteParams);
$result = $this->_object->searchItems($searchParams);
$this->assertInternalType('object', $saved['items']);
$this->assertNotNull($saved['items']->{'product.stock.id'});
$this->assertEquals($saved['items']->{'product.stock.id'}, $searched['items'][0]->{'product.stock.id'});
$this->assertEquals($saved['items']->{'product.stock.productid'}, $searched['items'][0]->{'product.stock.productid'});
$this->assertEquals($saved['items']->{'product.stock.warehouseid'}, $searched['items'][0]->{'product.stock.warehouseid'});
$this->assertEquals($saved['items']->{'product.stock.stocklevel'}, $searched['items'][0]->{'product.stock.stocklevel'});
$this->assertEquals($saved['items']->{'product.stock.dateback'}, $searched['items'][0]->{'product.stock.dateback'});
$this->assertEquals(1, count($searched['items']));
$this->assertEquals(0, count($result['items']));
}
public function testSaveDeleteItem()
{
$productManager = MShop_Product_Manager_Factory::createManager(TestHelper::getContext());
$search = $productManager->createSearch();
$search->setConditions($search->compare('==', 'product.code', 'CNC'));
$result = $productManager->searchItems($search, array('attribute'));
if (($product = reset($result)) === false) {
throw new Exception('No product item with code CNE found!');
}
$attributes = $product->getRefItems('attribute');
if (($attrItem = reset($attributes)) === false) {
throw new Exception('Product doesnt have any attribute item');
}
$product->setId(null);
$product->setCode('ModifiedCNC');
$productManager->saveItem($product);
$this->_object->saveItem($product);
$search = $this->_object->createSearch();
$search->setConditions($search->compare('==', 'catalog.index.attribute.id', $attrItem->getId()));
$result = $this->_object->searchItems($search);
$this->_object->deleteItem($product->getId());
$productManager->deleteItem($product->getId());
$search = $this->_object->createSearch();
$search->setConditions($search->compare('==', 'catalog.index.attribute.id', $attrItem->getId()));
$result2 = $this->_object->searchItems($search);
$this->assertContains($product->getId(), array_keys($result));
$this->assertFalse(in_array($product->getId(), array_keys($result2)));
}
public function testFinish()
{
$productManager = MShop_Product_Manager_Factory::createManager(TestHelper::getContext());
$search = $productManager->createSearch();
$search->setConditions($search->compare('==', 'product.code', array('CNC', 'CNE')));
$result = $productManager->searchItems($search);
$this->_object->finish((object) array('site' => 'unittest', 'items' => array_keys($result)));
}
public function testExportCSVFile()
{
$productManager = MShop_Product_Manager_Factory::createManager($this->_context);
$criteria = $productManager->createSearch();
$expr = array();
$expr[] = $criteria->compare('==', 'product.code', 'CNE');
$criteria->setConditions($criteria->compare('==', 'product.code', 'CNE'));
$searchResult = $productManager->searchItems($criteria);
if (($productItem = reset($searchResult)) === false) {
throw new Exception('No item with product code CNE found');
}
$params = new stdClass();
$params->site = $this->_context->getLocale()->getSite()->getCode();
$params->items = $productItem->getId();
$params->lang = 'de';
$result = $this->_object->exportFile($params);
$file = substr($result['file'], 9, -14);
$this->assertTrue(file_exists($file));
$zip = new ZipArchive();
$zip->open($file);
$testdir = 'tmp' . DIRECTORY_SEPARATOR . 'csvexport';
if (mkdir($testdir) === false) {
throw new Controller_ExtJS_Exception(sprintf('Couldn\'t create directory "csvexport"'));
}
$zip->extractTo($testdir);
$zip->close();
if (unlink($file) === false) {
throw new Exception('Unable to remove export file');
}
$deCSV = $testdir . DIRECTORY_SEPARATOR . 'de.csv';
$this->assertTrue(file_exists($deCSV));
$fh = fopen($deCSV, 'r');
$lines = array();
while (($data = fgetcsv($fh)) != false) {
$lines[] = $data;
}
fclose($fh);
if (unlink($deCSV) === false) {
throw new Exception('Unable to remove export file');
}
if (rmdir($testdir) === false) {
throw new Exception('Unable to remove test export directory');
}
$this->assertEquals($lines[0][0], 'Language ID');
$this->assertEquals($lines[0][1], 'Product type');
$this->assertEquals($lines[0][2], 'Product code');
$this->assertEquals($lines[0][3], 'List type');
$this->assertEquals($lines[0][4], 'Text type');
$this->assertEquals($lines[0][5], 'Text ID');
$this->assertEquals($lines[0][6], 'Text');
$this->assertEquals('de', $lines[2][0]);
$this->assertEquals('default', $lines[2][1]);
$this->assertEquals('CNE', $lines[2][2]);
$this->assertEquals('unittype13', $lines[2][3]);
$this->assertEquals('metadescription', $lines[2][4]);
$this->assertEquals('Expresso', $lines[2][6]);
}
/**
* Adds the product stock test data.
*
* @param array $testdata Associative list of key/list pairs
* @throws MW_Setup_Exception If no type ID is found
*/
private function _addProductStockData(array $testdata)
{
$productManager = MShop_Product_Manager_Factory::createManager($this->_additional, 'Default');
$productStockManager = $productManager->getSubManager('stock', 'Default');
$productStockWarehouse = $productStockManager->getSubManager('warehouse', 'Default');
$productStockUnitManager = $productStockManager->getSubManager('unit', 'Default');
$prodcode = array();
foreach ($testdata['product/stock'] as $dataset) {
if (($pos = strpos($dataset['prodid'], '/')) === false || ($str = substr($dataset['prodid'], $pos + 1)) == false) {
throw new MW_Setup_Exception(sprintf('Some keys for prodid are set wrong "%1$s"', $dataset['prodid']));
}
$prodcode[] = $str;
}
$search = $productManager->createSearch();
$search->setConditions($search->compare('==', 'product.code', $prodcode));
$parentIds = array();
foreach ($productManager->searchItems($search) as $item) {
$parentIds['product/' . $item->getCode()] = $item->getId();
}
$wareIds = $unitIds = array();
$ware = $productStockWarehouse->createItem();
$unit = $productStockUnitManager->createItem();
$this->_conn->begin();
foreach ($testdata['product/stock/unit'] as $key => $dataset) {
$unit->setId(null);
$unit->setCode($dataset['code']);
$unit->setLabel($dataset['label']);
$unit->setStatus($dataset['status']);
$productStockUnitManager->saveItem($unit);
$unitIds[$key] = $unit->getId();
}
foreach ($testdata['product/stock/warehouse'] as $key => $dataset) {
$ware->setId(null);
$ware->setCode($dataset['code']);
$ware->setLabel($dataset['label']);
$ware->setStatus($dataset['status']);
$productStockWarehouse->saveItem($ware);
$wareIds[$key] = $ware->getId();
}
$stock = $productStockManager->createItem();
foreach ($testdata['product/stock'] as $dataset) {
if (!isset($parentIds[$dataset['prodid']])) {
throw new MW_Setup_Exception(sprintf('No product ID found for "%1$s"', $dataset['prodid']));
}
if (!isset($wareIds[$dataset['warehouseid']])) {
throw new MW_Setup_Exception(sprintf('No warehouse ID found for "%1$s"', $dataset['warehouseid']));
}
$stock->setId(null);
$stock->setProductId($parentIds[$dataset['prodid']]);
$stock->setWarehouseId($wareIds[$dataset['warehouseid']]);
$stock->setUnitId($unitIds[$dataset['unitid']]);
$stock->setStocklevel($dataset['stocklevel']);
$stock->setDateBack($dataset['backdate']);
$productStockManager->saveItem($stock, false);
}
$this->_conn->commit();
}
protected function _getProductItem()
{
$manager = MShop_Product_Manager_Factory::createManager(TestHelper::getContext());
$search = $manager->createSearch();
$search->setConditions($search->compare('==', 'product.code', 'CNC'));
$items = $manager->searchItems($search, array('text'));
if (($item = reset($items)) === false) {
throw new Exception('No product item with code "CNC" found');
}
return $item;
}
/**
* @param string $code
*/
protected function _getProductItem($code)
{
$manager = MShop_Product_Manager_Factory::createManager($this->_context);
$search = $manager->createSearch();
$search->setConditions($search->compare('==', 'product.code', $code));
$items = $manager->searchItems($search);
if (($item = reset($items)) === false) {
throw new Exception(sprintf('No product item with code "%1$s" found', $code));
}
return $item;
}
/**
* Sets up the fixture, for example, opens a network connection.
* This method is called before a test is executed.
*
* @access protected
*/
protected function setUp()
{
$context = TestHelper::getContext();
$pluginManager = MShop_Plugin_Manager_Factory::createManager($context);
$plugin = $pluginManager->createItem();
$plugin->setTypeId(2);
$plugin->setProvider('Shipping');
$plugin->setConfig(array('threshold' => array('EUR' => '34.00')));
$plugin->setStatus('1');
$orderManager = MShop_Order_Manager_Factory::createManager($context);
$orderBaseManager = $orderManager->getSubManager('base');
$orderBaseProductManager = $orderBaseManager->getSubManager('product');
$manager = MShop_Product_Manager_Factory::createManager($context);
$search = $manager->createSearch();
$search->setConditions($search->compare('==', 'product.code', array('CNE', 'CNC', 'IJKL')));
$pResults = $manager->searchItems($search, array('price'));
if (count($pResults) !== 3) {
throw new Exception('Wrong number of products');
}
$products = array();
foreach ($pResults as $prod) {
$products[$prod->getCode()] = $prod;
}
if (($price = current($products['IJKL']->getRefItems('price'))) === false) {
throw new Exception('No price item found');
}
$price->setValue(10.0);
$this->_product = $orderBaseProductManager->createItem();
$this->_product->copyFrom($products['CNE']);
$this->_product->setPrice($price);
$product2 = $orderBaseProductManager->createItem();
$product2->copyFrom($products['CNC']);
$product2->setPrice($price);
$product3 = $orderBaseProductManager->createItem();
$product3->copyFrom($products['IJKL']);
$product3->setPrice($price);
$orderBaseServiceManager = $orderBaseManager->getSubManager('service');
$serviceSearch = $orderBaseServiceManager->createSearch();
$exp = array($serviceSearch->compare('==', 'order.base.service.type', 'delivery'), $serviceSearch->compare('==', 'order.base.service.costs', '5.00'));
$serviceSearch->setConditions($serviceSearch->combine('&&', $exp));
$results = $orderBaseServiceManager->searchItems($serviceSearch);
if (($delivery = reset($results)) === false) {
throw new Exception('No order base item found');
}
$this->_order = $orderBaseManager->createItem();
$this->_order->setService($delivery, 'delivery');
$this->_order->addProduct($this->_product);
$this->_order->addProduct($product2);
$this->_order->addProduct($product3);
$this->_object = new MShop_Plugin_Provider_Order_Shipping($context, $plugin);
}
/**
* Insert catalog nodes and product/catalog relations.
*/
protected function _process()
{
$this->_msg('Adding product categories performance data', 0);
$context = $this->_getContext();
$catalogManager = MShop_Catalog_Manager_Factory::createManager($context);
$catalogListManager = $catalogManager->getSubManager('list');
$catalogListTypeManager = $catalogListManager->getSubManager('type');
$search = $catalogListTypeManager->createSearch();
$expr = array($search->compare('==', 'catalog.list.type.domain', 'product'), $search->compare('==', 'catalog.list.type.code', 'default'));
$search->setConditions($search->combine('&&', $expr));
$types = $catalogListTypeManager->searchItems($search);
if (($typeItem = reset($types)) === false) {
throw new Exception('Catalog list type item not found');
}
$search = $catalogManager->createSearch();
$search->setSortations(array($search->sort('+', 'catalog.level'), $search->sort('+', 'catalog.left')));
$search->setSlice(0, 0x7fffffff);
$catIds = array_keys($catalogManager->searchItems($search));
$listItem = $catalogListManager->createItem();
$listItem->setTypeId($typeItem->getId());
$listItem->setDomain('product');
$this->_txBegin();
$productManager = MShop_Product_Manager_Factory::createManager($context);
$search = $productManager->createSearch();
$search->setSortations(array($search->sort('+', 'product.id')));
$start = $pos = 0;
do {
$catId = current($catIds);
if (($catId2 = next($catIds)) === false) {
$catId2 = reset($catIds);
}
$result = $productManager->searchItems($search);
foreach ($result as $id => $item) {
$listItem->setId(null);
$listItem->setParentId($catId);
$listItem->setRefId($id);
$listItem->setPosition($pos++);
$catalogListManager->saveItem($listItem, false);
$listItem->setId(null);
$listItem->setParentId($catId2);
$listItem->setRefId($id);
$listItem->setPosition($pos++);
$catalogListManager->saveItem($listItem, false);
}
$count = count($result);
$start += $count;
$search->setSlice($start);
} while ($count == $search->getSliceSize());
$this->_txCommit();
$this->_status('done');
}
/**
* Insert product data.
*/
protected function _process()
{
$this->_msg('Adding product suggestion performance data', 0);
$productManager = MShop_Product_Manager_Factory::createManager($this->_getContext());
$productListManager = $productManager->getSubManager('list');
$productListTypeManager = $productListManager->getSubManager('type');
$expr = array();
$search = $productListTypeManager->createSearch();
$expr[] = $search->compare('==', 'product.list.type.code', 'suggestion');
$expr[] = $search->compare('==', 'product.list.type.domain', 'product');
$search->setConditions($search->combine('&&', $expr));
$types = $productListTypeManager->searchItems($search);
if (($listTypeItem = reset($types)) === false) {
throw new Exception('Product list type item not found');
}
$search = $productManager->createSearch();
$search->setSortations(array($search->sort('+', 'product.id')));
$refsearch = $productManager->createSearch();
$refsearch->setSortations(array($refsearch->sort('+', 'product.id')));
$refsearch->setSlice(1);
$listItem = $productListManager->createItem();
$listItem->setTypeId($listTypeItem->getId());
$listItem->setDomain('product');
$this->_txBegin();
$start = 0;
do {
$num = 0;
$result = $productManager->searchItems($search);
$refresult = $productManager->searchItems($refsearch);
foreach ($result as $id => $product) {
$pos = 0;
$length = $num % 4 + 3;
foreach (array_slice($refresult, $num, $length, true) as $refid => $refproduct) {
$listItem->setId(null);
$listItem->setParentId($id);
$listItem->setRefId($refid);
$listItem->setPosition($pos++);
$productListManager->saveItem($listItem, false);
}
$num++;
}
$count = count($result);
$start += $count;
$search->setSlice($start);
$refsearch->setSlice($start + 1);
} while ($count == $search->getSliceSize());
$this->_txCommit();
$this->_status('done');
}
public static function setUpBeforeClass()
{
$context = TestHelper::getContext();
$manager = MShop_Customer_Manager_Factory::createManager($context);
$search = $manager->createSearch();
$search->setConditions($search->compare('==', 'customer.code', 'UTC001'));
$result = $manager->searchItems($search);
if ((self::$_customerItem = reset($result)) === false) {
throw new Exception('No customer found');
}
$manager = MShop_Product_Manager_Factory::createManager($context);
$search = $manager->createSearch();
$search->setConditions($search->compare('==', 'product.code', array('CNC', 'CNE')));
self::$_productItems = $manager->searchItems($search, array('text', 'price', 'media'));
}
public function testDetail()
{
$start = microtime(true);
$productManager = MShop_Product_Manager_Factory::createManager($this->_context);
$product = $productManager->getItem($this->_item->getId(), array('text', 'media', 'price', 'product', 'attribute'));
$ids = array();
foreach ($product->getRefItems('product') as $subproduct) {
$ids[] = $subproduct->getId();
}
if (count($ids) > 0) {
$search = $productManager->createSearch(true);
$search->setConditions($search->compare('==', 'product.id', $ids));
$productManager->searchItems($search, array('text', 'media', 'price', 'product', 'attribute'));
}
$stop = microtime(true);
echo "\n product detail: " . ($stop - $start) * 1000 . " msec\n";
}
/**
* Insert attribute items and product/attribute relations.
*/
protected function _process()
{
$this->_msg('Adding product config attribute performance data', 0);
$this->_txBegin();
$attrList = $this->_getAttributeList();
$this->_txCommit();
$context = $this->_getContext();
$productManager = MShop_Product_Manager_Factory::createManager($context);
$productListManager = $productManager->getSubManager('list');
$productListTypeManager = $productListManager->getSubManager('type');
$expr = array();
$search = $productListTypeManager->createSearch();
$expr[] = $search->compare('==', 'product.list.type.domain', 'attribute');
$expr[] = $search->compare('==', 'product.list.type.code', 'config');
$search->setConditions($search->combine('&&', $expr));
$types = $productListTypeManager->searchItems($search);
if (($productListTypeItem = reset($types)) === false) {
throw new Exception('Product list type item not found');
}
$search = $productManager->createSearch();
$search->setSortations(array($search->sort('+', 'product.id')));
$listItem = $productListManager->createItem();
$listItem->setTypeId($productListTypeItem->getId());
$listItem->setDomain('attribute');
$this->_txBegin();
$start = 0;
do {
$result = $productManager->searchItems($search);
foreach ($result as $id => $item) {
$pos = 0;
foreach ($attrList as $attrId => $attrItem) {
$listItem->setId(null);
$listItem->setParentId($id);
$listItem->setRefId($attrId);
$listItem->setPosition($pos++);
$productListManager->saveItem($listItem, false);
}
}
$count = count($result);
$start += $count;
$search->setSlice($start);
} while ($count == $search->getSliceSize());
$this->_txCommit();
$this->_status('done');
}
/**
* Gets required product item ids.
*
* @param array $keys List of keys for search
* @throws MW_Setup_Exception If no type ID is found
*/
protected function _getProductData(array $keys)
{
$manager = MShop_Product_Manager_Factory::createManager($this->_additional, 'Default');
$codes = array();
foreach ($keys as $dataset) {
if (($pos = strpos($dataset, '/')) === false || ($str = substr($dataset, $pos + 1)) === false) {
throw new MW_Setup_Exception(sprintf('Some keys for ref products are set wrong "%1$s"', $dataset));
}
$codes[] = $str;
}
$search = $manager->createSearch();
$search->setConditions($search->compare('==', 'product.code', $codes));
$refIds = array();
foreach ($manager->searchItems($search) as $item) {
$refIds['product/' . $item->getCode()] = $item->getId();
}
return $refIds;
}
/**
* Executes the job.
*
* @throws Controller_Jobs_Exception If an error occurs
*/
public function run()
{
$context = $this->_getContext();
$config = $context->getConfig();
$productManager = MShop_Product_Manager_Factory::createManager($context);
$productListManager = $productManager->getSubManager('list');
$listTypeId = $this->_getProductListTypeId($productListManager, 'suggestion');
$baseProductManager = MShop_Factory::createManager($context, 'order/base/product');
$search = $baseProductManager->createSearch();
$config->set('aggregatekey', 'mshop/order/manager/base/product/default/aggregateAllProductsInOrders');
$totalsCnt = $baseProductManager->aggregate($search, 'order.base.product.productid');
$search = $baseProductManager->createSearch();
$context->getConfig()->set('aggregatekey', 'mshop/order/manager/base/product/default/countAll');
$ordersCnt = $baseProductManager->aggregate($search, 'order.base.product.baseid');
$totalOrders = $ordersCnt[0];
$minSupport = $config->get('controller/jobs/product/suggestions/minsupport', 0.1);
$filteredBySupport = array();
foreach ($totalsCnt as $id => $totalCnt) {
if ($minSupport <= ($sup = $totalCnt / $totalOrders)) {
$filteredBySupport[$id] = $sup;
}
}
$minConfidence = $config->get('controller/jobs/product/suggestions/minconfidence', 0.3);
$maxSuggestions = $config->get('controller/jobs/product/suggestions/maxsuggestions', 10);
foreach ($filteredBySupport as $id => $sup) {
$prodList = array();
$search = $baseProductManager->createSearch();
$search->setConditions($search->compare('==', 'order.base.product.productid', $id));
$this->_getContext()->getConfig()->set('aggregatekey', 'mshop/order/manager/base/product/default/aggregateProductsInOrders');
$relativeCnt = $baseProductManager->aggregate($search, 'order.base.product.productid');
unset($relativeCnt[$id]);
foreach ($relativeCnt as $relId => $relCnt) {
if ($minSupport <= $relCnt / $totalOrders) {
if ($minConfidence <= ($conf = $relCnt / $totalsCnt[$id])) {
$prodList[$relId] = $conf;
}
}
}
arsort($prodList);
$prodList = array_slice($prodList, 0, $maxSuggestions, true);
$this->_removeProductSuggestions($id, $listTypeId, $productListManager);
$this->_createProductListSuggestions($id, array_keys($prodList), $listTypeId, $productListManager);
}
}
/**
* Insert product data.
*/
protected function _process()
{
$this->_msg('Adding product base performance data', 0);
$productManager = MShop_Product_Manager_Factory::createManager($this->_getContext());
$productTypeItem = $this->_getTypeItem('product/type', 'product', 'default');
$this->_txBegin();
$productItem = $productManager->createItem();
$productItem->setTypeId($productTypeItem->getId());
$productItem->setStatus(1);
$productItem->setSupplierCode('My brand');
$productItem->setDateStart('1970-01-01 00:00:00');
for ($i = 0; $i < $this->_count; $i++) {
$code = 'perf-' . str_pad($i, 5, '0', STR_PAD_LEFT);
$productItem->setId(null);
$productItem->setCode($code);
$productItem->setLabel($code);
$productManager->saveItem($productItem, false);
}
$this->_txCommit();
$this->_status('done');
}
public function testExportXLSFile()
{
$this->_object = new Controller_ExtJS_Product_Export_Text_Default($this->_context);
$productManager = MShop_Product_Manager_Factory::createManager($this->_context);
$criteria = $productManager->createSearch();
$expr = array();
$expr[] = $criteria->compare('==', 'product.code', 'CNE');
$criteria->setConditions($criteria->compare('==', 'product.code', 'CNE'));
$searchResult = $productManager->searchItems($criteria);
if (($productItem = reset($searchResult)) === false) {
throw new Exception('No item with product code CNE found');
}
$params = new stdClass();
$params->site = $this->_context->getLocale()->getSite()->getCode();
$params->items = $productItem->getId();
$params->lang = 'de';
$result = $this->_object->exportFile($params);
$this->assertTrue(array_key_exists('file', $result));
$file = substr($result['file'], 9, -14);
$this->assertTrue(file_exists($file));
$inputFileType = PHPExcel_IOFactory::identify($file);
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objReader->setLoadSheetsOnly($params->lang);
$objPHPExcel = $objReader->load($file);
if (unlink($file) === false) {
throw new Exception('Unable to remove export file');
}
$objWorksheet = $objPHPExcel->getActiveSheet();
$product = $productItem->toArray();
for ($i = 2; $i < 8; $i++) {
$this->assertEquals($params->lang, $objWorksheet->getCellByColumnAndRow(0, $i)->getValue());
$this->assertEquals($product['product.type'], $objWorksheet->getCellByColumnAndRow(1, $i)->getValue());
$this->assertEquals($product['product.code'], $objWorksheet->getCellByColumnAndRow(2, $i)->getValue());
}
$this->assertEquals('List type', $objWorksheet->getCellByColumnAndRow(3, 1)->getValue());
$this->assertEquals('Text type', $objWorksheet->getCellByColumnAndRow(4, 1)->getValue());
$this->assertEquals('Text ID', $objWorksheet->getCellByColumnAndRow(5, 1)->getValue());
$this->assertEquals('Text', $objWorksheet->getCellByColumnAndRow(6, 1)->getValue());
}
