Export module

davarious · July 28, 2011

Momenteel maak ik gebruik van een export module die de belangrijkste zaken kan exporteren.

Hieraan heb ik zelf al een beetje gesleuteld aangezien de nieuwere versies niet helemaal lekker lopen heb ik de oude versie die het wel goed doet uitgebreid met de keuzes die ik nodig heb.

Nu moet ook ook in de export de deeplink (link van de productpagina) in de csv krijgen, maar dit is me tot op heden nog niet gelukt.

Deze URL moet in php gegenereerd worden aangezien er geen product paginalink in de database wordt opgeslagen.

Iemand enig idee hoe ik dit zou kunnen realiseren?

Ik hoop dat iemand mij uit de brand kan helpen! Alvast hartelijk bedankt!

Ik post hier maar gelijk de code:

<?php
/**
 * Export Products
 * @category export
 *
 * @author Lee Wood - lmwood.com
 * @copyright Lee Wood / PrestaShop
 * @license http://www.opensource.org/licenses/osl-3.0.php Open-source licence 3.0
 * @version 0.1
 */
class ExportProducts extends Module
{
function __construct()
{
	$this->name = 'exportproducts';
	$this->tab = 'Tools';
	$this->version = '0.1';

	/* The parent construct is required for translations */
	parent::__construct();

	$this->page = basename(__FILE__, '.php');
	$this->displayName = $this->l('Export Products');
	$this->description = $this->l('A module to export all products to csv');
}

function install()
{

	$export_fields_sql = "
	CREATE TABLE IF NOT EXISTS `" . _DB_PREFIX_ . "export_fields` (
		`id` int(10) NOT NULL auto_increment,
		`field_name` varchar(50) NOT NULL,
		`database_name` varchar(50) NOT NULL,
		`category` varchar(50) NOT NULL,
		`position` int(2) NOT NULL default '0',
		PRIMARY KEY  (`id`)
	)";

	$export_set_sql = '	
	CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'export_set` (
	  `id` int(10) unsigned NOT NULL auto_increment,
	  `set_name` varchar(200) NOT NULL,
	  `set_values` text NOT NULL,
	  PRIMARY KEY  (`id`)
	)';

	$export_fields_data_sql = "
	INSERT INTO `" . _DB_PREFIX_ . "export_fields` (`id`, `field_name`, `database_name`, `category`, `position`) VALUES
	(1, 'Product Id', 'id_product', 'products', 0),
	(2, 'Product Reference', 'reference', 'products', 0),
	(3, 'Name', 'name', 'products_lang', 0),
	(4, 'Short Description', 'description_short', 'products_lang', 0),
	(5, 'Long Description', 'description', 'products_lang', 0),
	(6, 'Quantity', 'quantity', 'products', 0),
	(7, 'Price', 'price', 'products', 0),
	(8, 'Wholesale Price', 'wholesale_price', 'products', 0),
	(9, 'Supplier Name', 'id_supplier', 'products', 0),
	(10, 'Manufacturer', 'id_manufacturer', 'products', 0),
	(11, 'Tax %', 'id_tax', 'products', 0),
	(12, 'Categories', 'id_category_default', 'products', 0),
	(13, 'On Sale', 'on_sale', 'products', 0),
	(14, 'Reduction Price', 'reduction_price', 'products', 0),
	(15, 'Reduction %', 'reduction_percent', 'products', 0),
	(16, 'Reduction From', 'reduction_from', 'products', 0),
	(17, 'Reduction To', 'reduction_to', 'products', 0),
	(18, 'Supplier Reference', 'supplier_reference', 'products', 0),
	(19, 'Weight', 'weight', 'products', 0),
	(20, 'Date Added', 'date_add', 'products', 0),
	(21, 'Active', 'active', 'products', 0),
	(22, 'Meta Title', 'meta_title', 'products_lang', 0),
	(23, 'Meta Description', 'meta_description', 'products_lang', 0),
	(24, 'Meta Keywords', 'meta_keywords', 'products_lang', 0),
	(25, 'Available Now', 'available_now', 'products_lang', 0),
	(26, 'Available Later', 'available_later', 'products_lang', 0),
	(27, 'Tags', 'tags', 'products', 0),
	(28, 'Accessories', 'accessories', 'products', 0),
	(29, 'Images', 'images', 'products', 0),
	(30, 'EAN Code', 'ean13', 'products', 0);
	";

	return(Db::getInstance()->Execute($export_fields_sql) AND
		   Db::getInstance()->Execute($export_set_sql) AND
		   Db::getInstance()->Execute($export_fields_data_sql) AND
		   parent::install());
}

function uninstall()
{
	return(Db::getInstance()->Execute('DROP TABLE ' . _DB_PREFIX_ . 'export_fields') AND 
		   Db::getInstance()->Execute('DROP TABLE ' . _DB_PREFIX_ . 'export_set') AND 
		   parent::uninstall());
}

function getContent()
{
	global $smarty;

		$sql="SELECT * FROM `"._DB_PREFIX_."export_fields`";
		$field_list = Db::getInstance()->ExecuteS($sql);
		foreach($field_list as $value) {
			if($value['position'] != "0") {
				$currentfields[intval($value['position'])] = $value;
			} else {
				$availablefields[] = $value;
			}
		}
		if(isset($currentfields)) {
			ksort($currentfields);
			$smarty->assign("current_fields",$currentfields);
		}
		$smarty->assign("available_fields", $availablefields);

		$sql="SELECT * FROM `"._DB_PREFIX_."export_set`";
		if($field_list = Db::getInstance()->ExecuteS($sql)) {
			foreach($field_list as $value) {
				$sets[$value['id']] = $value['set_name'];
			}
			$smarty->assign('sets', $sets);
		}

		$langs = Language::getLanguages();
		$smarty->assign('langs', $langs);

		/* display the module name */
		$this->_html = '<h2>'.$this->displayName.'</h2>';

		if(isset($_POST['export'])) {

		$sql="SELECT * FROM `"._DB_PREFIX_."export_fields` WHERE position !=0 ORDER BY position ASC";
		$field_list = Db::getInstance()->ExecuteS($sql);

		foreach($field_list as $field => $value){
				$export_fields[$value['database_name']] = array('name' => $value['field_name'], 'category' => $value['category']);
		} 

		foreach($export_fields as $field => $array) {
			$titles[] = $array['name'];

			switch($array['category']) {
				case "products":

					switch($field) {
						case "accessories":
							$inc_accessories = true;
						break;
						case "tags":
							$inc_tags = true;
						break;
						case "images":
							$inc_images = true;
						break;
						case "id_product":
						break;
						default:
							$fields[] = "p.`" . $field . "`";
						break;
					}

				break;
				case "products_lang":
					$fields[] = "pl.`" . $field . "`";
				break;
			}
		}
		$lang = $_REQUEST['lang'];
		$sql='SELECT p.`id_product`, '.implode(', ', $fields).'
		FROM '._DB_PREFIX_.'product as p
		LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (pl.`id_product` = p.`id_product`)
		WHERE pl.`id_lang`=' . $lang . ' GROUP BY p.`id_product`
		';

		$delimiter = $_REQUEST['delimiter'];
		$exportlist = Db::getInstance()->ExecuteS($sql);
		$f=fopen(dirname(__FILE__).'/products.csv', 'w');
		fwrite($f, implode($delimiter, $titles) . "\r\n");
		foreach($exportlist AS $export) {
			$product = new Product($export['id_product'], true, $lang);
			$tags = array();
			$accessories = array();
			$export_final = array();
			$imagelinks = array();
			$cats = array();

			if(isset($export['id_category_default'])) {
				$categories = $product->getIndexedCategories($export['id_product']);
				foreach($categories as $cat) {
					$category = new Category($cat['id_category'], 1);
					$cats[] = $category->name;
				}
				$export['id_category_default'] = implode(",", $cats);
			}

			if($inc_images) {
				$link = new Link();
				$images = $product->getImages($export['id_product']);
				foreach($images as $image) {
					$imagelinks[] = "http://" . htmlspecialchars($_SERVER['HTTP_HOST'], ENT_COMPAT, 'UTF-8').$link->getImageLink($product->link_rewrite, $product->id .'-'. $image['id_image']);
				}
				$export['images'] = implode(",", $imagelinks);
			}

			if(isset($export['id_manufacturer'])) {
				$export['id_manufacturer'] = $product->manufacturer_name;
			}

			if(isset($export['meta_description'])) {
				$export['meta_description'] = $product->meta_description;
			}

			if(isset($export['meta_title'])) {
				$export['meta_title'] = $product->meta_title;
			}

			if(isset($export['meta_keywords'])) {
				$export['meta_keywords'] = $product->meta_keywords;
			}
			if(isset($export['id_supplier'])) {
				$export['id_supplier'] = $product->supplier_name;
			}

			if(isset($export['id_tax'])) {
				$export['id_tax'] = $product->tax_rate;
			}

			if(isset($inc_tags)) 
			{
				$export['tags'] = $product->getTags(1);
			}

			if(isset($inc_accessories)) {

				if($acc = $product->getAccessories(1, false)) {
					foreach($acc as $acc_key => $acc_value)
					{
						$accessories[] = $acc_value['reference'];
					}
					$export['accessories'] = implode(',', $accessories);
				} else {
					$export['accessories'] = '';
				}
			}

			if($_REQUEST['wcurrency'] == 1) {
			$params['currency'] = Tools::setCurrency();
				if(isset($export['price'])) {
					$params['price'] = $product->price;
					$export['price'] = $product->displayWtPriceWithCurrency($params, $smarty);
				}

				if(isset($export['wholesale_price'])) {
					$params['price'] = $product->wholesale_price;
					$export['wholesale_price'] = $product->displayWtPriceWithCurrency($params, $smarty);
				}
			}
			foreach($export_fields as $field => $value) {
					$export_final[$field] = iconv("UTF-8", "ISO-8859-1//TRANSLIT", $export[$field]);
			}

			fputcsv($f, $export_final, $delimiter, '"');

		}
		Tools::redirect('modules/exportproducts/products.csv');
	}
	$this->_html.=$this->_displayForm();
	return $this->_html;
}

private function _displayForm()
{
	global $smarty, $cookie;
	$smarty->assign('base_dir', _PS_BASE_URL_.__PS_BASE_URI__);
	$smarty->assign('currentIndex', $_SERVER['REQUEST_URI']);
	return $this->display(__FILE__,'exportproducts.tpl');
}

}

davarious · July 28, 2011

De linkcode zou er dan zo uit moeten zien:

$productLink =  "http://" . htmlspecialchars($_SERVER['HTTP_HOST'], ENT_COMPAT, 'UTF-8').'/'.$categorie.'/'.$product_id.'-'.$link_rewrite.'.html';

Maar hoe je dit allemaal werkend krijg... geb ik geen flauw idee van

davarious · July 28, 2011

Ik ben zelf al wat wezen knoeien en ik heb eindelijk een output!

Het enige wat er nu gebeurd is dat wanneer bijvoorbeeld de product ID en de URL geexporteerd wordt, dat die wel netjes alle ID nummers van alle producten onder elkaar zet...

Alleen de URL zet die bij iedere ID hetzelfde neer en dan alle prudct URL's naast elkaar.

Dus op iedere regel van een ID staat daarachter alle product URL's.

bijvoorbeeld:

ID | product URL

1 | http://www.website.nl/categorie/01-productomschrijving.html, http://www.website.nl/categorie/02-productomschrijving.html, http://www.website.nl/categorie/03-productomschrijving.html... etc...

2 | http://www.website.nl/categorie/01-productomschrijving.html, http://www.website.nl/categorie/02-productomschrijving.html, http://www.website.nl/categorie/03-productomschrijving.html... etc...

en ga zo door...

			if($inc_productlink) {
				$link = new Link();
				$productcat = $product->getIndexedCategories($export['id_product']);

				foreach($productcat as $pcat) {
					$category = new Category($pcat['id_category'], 1);
					$pcats[] = $category->name;
					$productcats = implode(",", $pcats);
					$plinks[] = "http://" . htmlspecialchars($_SERVER['HTTP_HOST'], ENT_COMPAT, 'UTF-8').'/'.$productcats.'/'.$product->id.'-'.$product->link_rewrite.'.html';

				}
				$export['productcat'] = implode(",", $plinks);

			}

Omdat het me in eerste instante niet lukte om de foreach commando op het product id te herhalen heb ik deze eerst even op de categorie gezet.

Na wat knoeien is dit gelukt, alleen met bovenstaand resultaat.

Even verder tunen...

Als iemand tips heeft is dat natuurlijk van harte welkom!

fabfab · January 12, 2012

Hoi,

Is het jou ook gelukt om de prijzen inclusief btw te krijgen?

Ik zoek me suf, maar kan het niet vinden.

Sign In

Export module

Recommended Posts

davarious

Link to comment

Share on other sites

davarious

Link to comment

Share on other sites

davarious

Link to comment

Share on other sites

fabfab

Link to comment

Share on other sites

Browse

Activity

Go back to prestashop.com