)\s+(?=\<)@', ' ', $s); # strip some whitespace
$s = trim($s);
// $s = preg_replace('@[\r\n]+@', '
', $s);
$s = preg_replace('@
+@', PHP_EOL, $s);
$s = strip_tags($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('Magento\Catalog\Model\ResourceModel\Product\CollectionFactory');
$collection = $productCollection->create()
->addAttributeToSelect('*')
->addAttributeToFilter('status', \Magento\Catalog\Model\Product\Attribute\Source\Status::STATUS_ENABLED)
// ->setPageSize('100')
;
# 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) {
$data = $product->getData();
#print_r($data);
$description = $data['description'];
$values = array();
foreach($product->getAttributes() as $attribute) {
if($attribute->getIsVisibleOnFront()) {
$value = trim($attribute->getFrontend()->getValue($product));
$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('Magento\Catalog\Model\Product\Gallery\ReadHandler')->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) {
}
$price = $data['price'];
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(
'Piese auto',
'Consumabile si Accesorii',
$product->getAttributeText('auto_brand'),
$product->getAttributeText('tip_carlig'),// tip carlig
$product->getAttributeText('manufacturer'),
$product->getData('sku_fz'), // sku_fz
"NOU", // STARE*
self::prepareTitle($product->getName()), //TITLU*
"", //SCURTA-DESCRIERE, O pun eu manual
self::prepareDescription($description), // DESCRIERE, O luam din M2. Tragame si descriere si specificatii
$currency, // MONEDA*
$price, // PRET*
"Da", // PRET-NET
$stock, //qty
implode(',', $images), // toate din M2, inclusiv print video
);
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;
# ----------------------------------------------------------------------------------------------------------------