)\s+(?=\<)@', ' ', $s); # strip some whitespace
$s = trim($s);
$s = preg_replace('@[\r\n]+@', '
', $s);
return $s;
}
public static function prepareTitle($s) {
if(function_exists('iconv')) {
$s = iconv('UTF-8', 'UTF-8//IGNORE', $s);
}
$backup = $s;
$s = html_entity_decode($s, ENT_QUOTES, 'UTF-8');
if(!$s)
$s = $backup; # html_entity_decode() may have failed
$s = preg_replace('/\s+/', ' ', $s);
$s = trim($s);
return $s;
}
public static function escapeImgURL($url) {
$url = str_replace(array(' ', '[,]'), array('%20', '[%2C]'), $url);
return $url;
}
public static function loadMage() {
require_once dirname(__FILE__) . '/app/bootstrap.php';
}
/**
* @param Throwable
* @return string
*/
public static function strerror($e) {
$errmsg = "[" . date('Y-m-d H:i:s') . "] ";
$errmsg .= get_class($e) . ": " . $e->getMessage();
$code = $e->getCode();
if($code) {
$errmsg .= " (EXCEPTION CODE: $code)";
}
$errmsg .= "\n";
$stack = "STACK:\n# " . $e->getFile() . "(" . $e->getLine() . ")\n" . $e->getTraceAsString() . "\n";
$stack = str_replace(__DIR__ . '/', '', $stack);
$stack = str_replace(__DIR__, '', $stack);
$errmsg .= $stack;
return $errmsg;
}
public static function export() {
self::init();
# https://docs.magento.com/mbi/data-analyst/data-warehouse-mgr/mage-store-data.html#catalog_product_entity
$bootstrap = \Magento\Framework\App\Bootstrap::create(BP, $_SERVER);
$objectManager = $bootstrap->getObjectManager();
$state = $objectManager->get(Magento\Framework\App\State::class);
$state->setAreaCode(\Magento\Framework\App\Area::AREA_FRONTEND);
$store = $objectManager->get(\Magento\Store\Model\StoreManagerInterface::class)->getStore();
$currency = $store->getCurrentCurrency()->getCode();
#$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$productCollection = $objectManager->create(CollectionFactory::class);
$collection = $productCollection->create()
->addAttributeToSelect('*')
->addAttributeToFilter('visibility', Visibility::VISIBILITY_BOTH)
->addAttributeToFilter('status', Status::STATUS_ENABLED)
->addPriceData()
//->addFieldToFilter('sku', ['like' => 'GVB%'])
# https://magento.stackexchange.com/a/303902
#->setFlag('has_stock_status_filter', false)
#->joinField('stock_item', 'cataloginventory_stock_item', 'is_in_stock', 'product_id=entity_id', 'is_in_stock=1')
#->addAttributeToFilter("visibility", array("in" =>[2,4] ))
#->load()
;
$productsPrice = [];
$categoryRules = [
];
foreach($collection as $product) {
try {
$catCollection = $product->getCategoryCollection()->addAttributeToSelect('name');
if(!$catCollection)
throw new Exception();
$category = array();
foreach($catCollection as $cat) {
$categoryPath = explode('/', $cat->getPath());
foreach ($categoryPath as $categoryId) {
if (in_array($categoryId, array_keys($categoryRules))) {
$productsPrice[$product->getId()] = $categoryRules[$categoryId];
}
}
$catname = trim($cat->getName());
if($catname && !preg_match('@^(promotii|black\s*friday|piese\s*auto|diverse)$@i', $catname)) {
$category[$catname] = $catname;
}
}
$category = implode(' >> ', $category);
if(!$category)
throw new Exception();
} catch(Exception $e) {
$category = 'NONE';
}
$data = $product->getData();
#print_r($data);
$description = $data['description'];
$values = array();
foreach($product->getAttributes() as $attribute) {
$value = $attribute->getFrontend()->getValue($product);
if($value && $attribute->getIsVisibleOnFront()) {
$value = trim($value);
$name = trim($attribute->getName());
if($value && $name) {
$values[$name] = array('label' => $attribute->getFrontendLabel(), 'value' => $value);
}
}
}
if(@$values['in_depth']) {
$description .= '
' . $values['in_depth']['value'];
unset($values['in_depth']);
}
foreach($values as $v) {
$description .= '
' . $v['label'] . ': ' . $v['value'];
}
$img_relpath = $product->getImage();
$images = array();
$main_img_url = $store->getBaseUrl(\Magento\Framework\UrlInterface::URL_TYPE_MEDIA) . 'catalog/product' . $product->getImage();
if($main_img_url) {
$images[$main_img_url] = $main_img_url;
}
$objectManager->get(ReadHandler::class)->execute($product);
foreach($product->getMediaGalleryImages() as $img) {
$images[$img['url']] = $img['url'];
}
$stock = 99999;
//try {
//$stock = (int)$objectManager->get('Magento\CatalogInventory\Api\StockRegistryInterface')->getStockItem($product->getId())->getQty();
//} catch(Throwable $e) {}
//if($stock < 1) $stock = 20;
$price = round(($data['final_price'] - 0), 2);
/*try {
$productDiscount = 0;
if (isset($productsPrice[$product->getId()])) {
$productDiscount = $productsPrice[$product->getId()];
}
$price = $product->getPriceInfo()->getPrice('final_price')->getValue() - $productDiscount;
} catch(Throwable $e) {}*/
$row = array(
$product->getId(), // Coloana 0: id produs
self::prepareTitle($product->getName()), // Coloana 1: titlu produs
$category, // Coloana 2: categoria (asa cum este la dumneavoastra pe site, maparile se vor face ulterior)
self::prepareDescription($description), // Coloana 3: descriere
$currency, // Coloana 4: moneda (RON, EUR sau USD)
$price, // Coloana 5: pret
$stock, // Coloana 6: cantitate (numar intreg pozitiv)
implode('[,]', str_replace('[,]', '[%2C]', $images)), // Coloana 7: url catre poza (optional)
);
if(!$row[3]) {
$row[3] = $row[1];
}
self::fputcsv($row);
}
self::cleanup();
}
}
# ----------------------------------------------------------------------------------------------------------------
try {
AS_CSVFEED::export();
} catch(Throwable $e) {
@header('HTTP/1.1 500 Internal Server Error');
if(AS_CSVFEED::is_dev() && AS_CSVFEED::is_authorized()) {
echo AS_CSVFEED::strerror($e);
} else {
echo 'eroare...';
}
}
die;
# ----------------------------------------------------------------------------------------------------------------