/**
* Deletes a page of invalid data
*
* @param integer $start
* @param integer $offset
*/
public function deleteInvalidData($start, $offset)
{
// Controller
$controller = new PlentymarketsImportControllerItem();
// StoreIds
$stores = Shopware()->Db()->fetchAll('
SELECT plentyID FROM plenty_mapping_shop
');
// Customer group
$customerGroupKey = PlentymarketsConfig::getInstance()->getDefaultCustomerGroupKey();
$customerGroupRepository = Shopware()->Models()->getRepository('Shopware\\Models\\Customer\\Group');
$customerGroups = $customerGroupRepository->findBy(array('key' => $customerGroupKey));
$customerGroup = array_pop($customerGroups);
//
foreach ($this->getInvalidData($start, $offset) as $data) {
PyLog()->message('Fix:Item:Price', 'Start of fixing corrupt prices of the item id ' . $data['itemId']);
// Search
foreach (explode(',', $data['detailIds']) as $detailId) {
try {
/** @var \Shopware\Models\Article\Detail $Detail */
$Detail = Shopware()->Models()->find('\\Shopware\\Models\\Article\\Detail', $detailId);
$price = new Shopware\Models\Article\Price();
$price->setFrom(1);
$price->setPrice(1);
$price->setPercent(0);
$price->setArticle($Detail->getArticle());
$price->setDetail($Detail);
$price->setCustomerGroup($customerGroup);
Shopware()->Models()->persist($price);
} catch (Exception $E) {
PyLog()->debug($E->getMessage());
}
}
Shopware()->Models()->flush();
PyLog()->message('Fix:Item:Price', 'Finished with the fixing corrupt prices of the item id »' . $data['itemId'] . '«');
try {
foreach ($stores as $store) {
// Update the complete item from plenty
$controller->importItem(PlentymarketsMappingController::getItemByShopwareID($data['itemId']), $store['plentyID']);
}
} catch (Exception $e) {
PyLog()->error('Fix:Item:Price', $e->getMessage());
}
// Stop after the first
break;
}
}
/**
* Syncs an item by it's plentymarkets id
*/
public function syncItemAction()
{
$itemId = (int) $this->Request()->get('itemId', 0);
if ($itemId) {
// Controller
$controller = new PlentymarketsImportControllerItem();
// StoreIds
$stores = Shopware()->Db()->fetchAll('
SELECT plentyID FROM plenty_mapping_shop
');
try {
foreach ($stores as $store) {
$controller->importItem($itemId, $store['plentyID']);
}
} catch (Exception $e) {
PyLog()->error('Fix:Item:Price', $e->getMessage());
}
$controller->finish();
}
}
/**
* Reads the items of plentymarkets that have changed
*/
public static function importItems()
{
$PlentymarketsImportControllerItem = new PlentymarketsImportControllerItem();
$PlentymarketsImportControllerItem->run();
}
