PageRenderTime 36ms CodeModel.GetById 17ms RepoModel.GetById 1ms app.codeStats 0ms

/modules/storecommander/ead6f6fce09/SC/lib/cat/win-export/cat_win-export_process.php

https://gitlab.com/ptisky/API_prestashop
PHP | 1200 lines | 973 code | 63 blank | 164 comment | 228 complexity | d42b3780460363c02c5647d8360dd121 MD5 | raw file
    

  1. <?php


    2. 

  2. /**


    3. 

  3.  * Store Commander


    4. 

  4.  *


    5. 

  5.  * @category administration


    6. 

  6.  * @author Store Commander - support@storecommander.com


    7. 

  7.  * @version 2015-09-15


    8. 

  8.  * @uses Prestashop modules


    9. 

  9.  * @since 2009


    10. 

  10.  * @copyright Copyright &copy; 2009-2015, Store Commander


    11. 

  11.  * @license commercial


    12. 

  12.  * All rights reserved! Copying, duplication strictly prohibited


    13. 

  13.  *


    14. 

  14.  * *****************************************


    15. 

  15.  * *           STORE COMMANDER             *


    16. 

  16.  * *   http://www.StoreCommander.com       *


    17. 

  17.  * *            V 2015-09-15               *


    18. 

  18.  * *****************************************


    19. 

  19.  *


    20. 

  20.  * Compatibility: PS version: 1.1 to 1.6.1


    21. 

  21.  *


    22. 

  22.  **/


    23. 

  23. 


    24. 

  24. 	$debug=false;


    25. 

  25. 


    26. 

  26. 	error_reporting(E_ALL ^ E_NOTICE);


    27. 

  27. 	@ini_set('display_errors', 'on');


    28. 

  28. 


    29. 

  29. 	if (!isset($CRON)) $CRON=0;


    30. 

  30. 	if (!isset($CRONVERSION)) $CRONVERSION=1;


    31. 

  31. 	


    32. 

  32. 	if(!empty($CRON))


    33. 

  33. 	{


    34. 

  34. 		Context::getContext()->employee = new Employee( Tools::getValue('id_employee') );


    35. 

  35. 		$sc_agent=new SC_Agent();


    36. 

  36. 	}


    37. 

  37. 	


    38. 

  38. 	require_once(SC_DIR.'lib/cat/win-export/cat_win-export_tools.php');


    39. 

  39. 	


    40. 

  40. 


    41. 

  41. 	$action=Tools::getValue('action');


    42. 

  42. 	$id_lang=intval(Tools::getValue('id_lang'));


    43. 

  43. 	$mapping=Tools::getValue('mapping');


    44. 

  44. 	$cache=array();


    45. 

  45. 	


    46. 

  46. 	$cacheCategory=array();


    47. 

  47. 	$cacheCategoryPath=array();


    48. 

  48. 	$categoriesProperties=array();


    49. 

  49. 	$categoryNameByID=array();


    50. 

  50. 	$cacheCarriers=array();


    51. 

  51. 


    52. 

  52. 	switch($action){


    53. 

  53. 		case 'conf_delete':


    54. 

  54. 			$exp_opt_files=Tools::getValue('exp_opt_files','');


    55. 

  55. 			if ($exp_opt_files=='') die(_l('You should mark at least one file to delete'));


    56. 

  56. 			$exp_opt_files_array=preg_split('/;/',$exp_opt_files);


    57. 

  57. 			foreach($exp_opt_files_array as $exp_opt_file)


    58. 

  58. 			{


    59. 

  59. 				if ($exp_opt_file!='')


    60. 

  60. 				{


    61. 

  61. 					if (@unlink(SC_TOOLS_DIR.'cat_export/'.$exp_opt_file.'.script.xml'))


    62. 

  62. 					{


    63. 

  63. 						echo $exp_opt_file." "._l('deleted')."\n";


    64. 

  64. 					}else{


    65. 

  65. 						echo _l("Unable to delete this file, please check write permissions:")." ".$exp_opt_file."\n";


    66. 

  66. 					}


    67. 

  67. 				}


    68. 

  68. 			}


    69. 

  69. 			break;


    70. 

  70. 		case 'conf_add':


    71. 

  71. 			$scriptname=Tools::getValue('scriptname','');


    72. 

  72. 			readExportConfigXML('');


    73. 

  73. 			writeExportConfigXML($scriptname.'.script.xml');


    74. 

  74. 			break;


    75. 

  75. 		case 'reset_export':


    76. 

  76. 			$return = false;


    77. 

  77. 			$export_id = intval(Tools::getValue('export_id', 0));


    78. 

  78. 			if(!empty($export_id))


    79. 

  79. 			{


    80. 

  80. 				$sql = "UPDATE "._DB_PREFIX_."sc_export SET exporting = 0, id_next = 0, id_combination_next = 0 WHERE id_sc_export = '".intval($export_id)."'";


    81. 

  81. 				Db::getInstance()->Execute($sql);


    82. 

  82. 				$return = true;


    83. 

  83. 			}


    84. 

  84. 				


    85. 

  85. 			if(!$return)


    86. 

  86. 				echo '<strong style="color: #831f1f;">'._l('An error occured during reset. Please try again.').'</span>';


    87. 

  87. 			else


    88. 

  88. 				echo '<strong style="color: #266e00;">'._l('The export was successfully reset.').'</span>';


    89. 

  89. 			


    90. 

  90. 			break;


    91. 

  91. 		case 'mapping_delete':


    92. 

  92. 			$filename=str_replace('.map.xml','',Tools::getValue('filename'));


    93. 

  93. 			@unlink(SC_TOOLS_DIR.'cat_export/'.$filename.'.map.xml');


    94. 

  94. 			break;


    95. 

  95. 		case 'mapping_saveas':


    96. 

  96. 			$filename=str_replace('.map.xml','',Tools::getValue('filename'));


    97. 

  97. 			$mapping=Tools::getValue('mapping');


    98. 

  98. 			@unlink(SC_TOOLS_DIR.'cat_export/'.$filename.'.map.xml');


    99. 

  99. 			$mapping=preg_split('/;/',$mapping);


    100. 

  100. 			$content="<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n".'<mapping version="'.SC_EXPORT_VERSION.'">';


    101. 

  101. 			$contentArray=array();


    102. 

  102. 			foreach($mapping AS $map)


    103. 

  103. 			{


    104. 

  104. 				$val=explode('|||',$map);


    105. 

  105. 				if (count($val)==8)


    106. 

  106. 				{


    107. 

  107. 					$contentArray[(int)$val[1]]='<field>';


    108. 

  108. 					$contentArray[(int)$val[1]].='<id><![CDATA['.$val[0].']]></id>';


    109. 

  109. 					$contentArray[(int)$val[1]].='<used><![CDATA['.$val[2].']]></used>';


    110. 

  110. 					$contentArray[(int)$val[1]].='<name><![CDATA['.$val[3].']]></name>';


    111. 

  111. 					$contentArray[(int)$val[1]].='<lang><![CDATA['.$val[4].']]></lang>';


    112. 

  112. 					$contentArray[(int)$val[1]].='<options><![CDATA['.$val[5].']]></options>';


    113. 

  113. 					//$contentArray[(int)$val[1]].='<filters><![CDATA['.$val[6].']]></filters>';


    114. 

  114. 					$contentArray[(int)$val[1]].='<modifications><![CDATA['.$val[6].']]></modifications>';


    115. 

  115. 					$contentArray[(int)$val[1]].='<column_name><![CDATA['.$val[7].']]></column_name>';


    116. 

  116. 					$contentArray[(int)$val[1]].='</field>'."\n";


    117. 

  117. 				}


    118. 

  118. 			}


    119. 

  119. 			ksort($contentArray);


    120. 

  120. 			$content.=join('',$contentArray).'</mapping>';


    121. 

  121. 			file_put_contents(SC_TOOLS_DIR.'cat_export/'.$filename.'.map.xml', $content);


    122. 

  122. 			echo _l('Data saved!');


    123. 

  123. 			break;


    124. 

  124. 		case 'categselection_load':


    125. 

  125. 			$filename=str_replace('.sel.xml','',Tools::getValue('filename')).'.sel.xml';


    126. 

  126. 			$content='';


    127. 

  127. 			if (file_exists(SC_TOOLS_DIR.'cat_categories_sel/'.$filename) && $feed = simplexml_load_file(SC_TOOLS_DIR.'cat_categories_sel/'.$filename))


    128. 

  128. 				foreach($feed->category AS $category)


    129. 

  129. 					$content.=(string)$category->id.';';


    130. 

  130. 			echo $content;


    131. 

  131. 			break;


    132. 

  132. 		case 'categselection_saveas':


    133. 

  133. 			$filename=Tools::getValue('filename');


    134. 

  134. 			$categselection=Tools::getValue('categselection');


    135. 

  135. 			@unlink(SC_TOOLS_DIR.'cat_categories_sel/'.$filename.'.sel.xml');


    136. 

  136. 			$categselection=preg_split('/,/',$categselection);


    137. 

  137. 			$content="<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n".'<categselection>';


    138. 

  138. 			$contentArray=array();


    139. 

  139. 			foreach($categselection AS $catsel)


    140. 

  140. 			{


    141. 

  141. 				$val=preg_split('/,/',$catsel);


    142. 

  142. 				if (count($val)==1 && $val[0]!='')


    143. 

  143. 				{


    144. 

  144. 					$contentArray[(int)$val[0]]='<category>';


    145. 

  145. 					$contentArray[(int)$val[0]].='<id><![CDATA['.$val[0].']]></id>';


    146. 

  146. 					$contentArray[(int)$val[0]].='</category>'."\n";


    147. 

  147. 				}


    148. 

  148. 			}


    149. 

  149. 			ksort($contentArray);


    150. 

  150. 			$content.=join('',$contentArray).'</categselection>';


    151. 

  151. 			file_put_contents(SC_TOOLS_DIR.'cat_categories_sel/'.$filename.'.sel.xml', $content);


    152. 

  152. 			echo _l('Data saved!');


    153. 

  153. 			break;


    154. 

  154. 		case 'categselection_delete':


    155. 

  155. 			$filename=Tools::getValue('filename');


    156. 

  156. 			@unlink(SC_TOOLS_DIR.'cat_categories_sel/'.$filename.'.sel.xml');


    157. 

  157. 			break;


    158. 

  158. 		case 'export_process':


    159. 

  159. 			global $switchObject,$switchObjectOption,$switchObjectLang,$p,$getIDlangByISO,$field,$id_product,$id_product_attribute; // variable for custom import fields check, used in extensions, do not remove


    160. 

  160. 			// INIT VARS


    161. 

  161. 			$AUTO_EXPORT=intval(Tools::getValue('auto_export',0));


    162. 

  162. 			$export_limit=intval(Tools::getValue('export_limit',500));


    163. 

  163. 			$first_interval=intval(Tools::getValue('first_interval',0));


    164. 

  164. 			


    165. 

  165. 			$time_start = microtime(true);


    166. 

  166. 			


    167. 

  167. 			$ALREADY_EXPORTING = false;


    168. 

  168. 			$STOP_SCRIPT = false;


    169. 

  169. 			


    170. 

  170. 			$switchObject=''; 


    171. 

  171. 			$switchObjectOption='';


    172. 

  172. 			$switchObjectLang='';


    173. 

  173. 			$link = new Link();


    174. 

  174. 			$id_product=0; 


    175. 

  175. 			$id_product_attribute=0;


    176. 

  176. 			$defaultLanguageId = intval(Configuration::get('PS_LANG_DEFAULT'));


    177. 

  177. 			$defaultLanguage=new Language($defaultLanguageId);


    178. 

  178. 			$getIDlangByISO=array();


    179. 

  179. 			foreach($languages AS $lang)


    180. 

  180. 				$getIDlangByISO[$lang['iso_code']]=$lang['id_lang'];


    181. 

  181. 			$filename=Tools::getValue('filename',0);


    182. 

  182. 			$sc_active=SCI::getConfigurationValue('SC_PLUG_DISABLECOMBINATIONS',0);


    183. 

  183. 			$auto_filename=$filename;//str_replace(".script.xml","",$filename);


    184. 

  184. 			if ($filename===0)


    185. 

  185. 			{


    186. 

  186. 				if(!$AUTO_EXPORT && !$CRON)


    187. 

  187. 					die(_l('You have to select a file.'));


    188. 

  188. 				elseif($CRON)


    189. 

  189. 				{


    190. 

  190. 					echo _l('You have to select a file.');


    191. 

  191. 					$STOP_SCRIPT = true;


    192. 

  192. 				}


    193. 

  193. 				else


    194. 

  194. 				{


    195. 

  195. 					echo json_encode(array(


    196. 

  196. 						"type" => "error",


    197. 

  197. 						"stop" => 1,


    198. 

  198. 						"content" => '<strong style="color: #831f1f;">'._l('You have to select a file.', 1).'</span>',


    199. 

  199. 						"filename" => $auto_filename,


    200. 

  200. 						"first_interval" => $first_interval


    201. 

  201. 					));


    202. 

  202. 					die();


    203. 

  203. 				}


    204. 

  204. 			}


    205. 

  205. 			if($STOP_SCRIPT)


    206. 

  206. 				break;


    207. 

  207. 			


    208. 

  208. 			$arrIdAvailableLater = array();


    209. 

  209. 			if(SCI::getConfigurationValue("SC_DELIVERYDATE_INSTALLED")=="1")


    210. 

  210. 			{


    211. 

  211. 				$sql = "SELECT * FROM "._DB_PREFIX_."sc_available_later";


    212. 

  212. 				$res=Db::getInstance()->ExecuteS($sql);


    213. 

  213. 				foreach($res as $row){


    214. 

  214. 					$arrIdAvailableLater[$row['id_sc_available_later']][$row['id_lang']]=$row['available_later'];


    215. 

  215. 				}


    216. 

  216. 			}


    217. 

  217. 			


    218. 

  218. 			// fields to search in ps_product_lang


    219. 

  219. 			$fields_lang=array('name','available_now','link_rewrite','meta_title','meta_description','meta_keywords','description_short','description','name_with_attributes');


    220. 

  220. 			// fields specific to combination, should not be read in Product object


    221. 

  221. 			$combination_fields=array('name_with_attributes');


    222. 

  222. 


    223. 

  223. 			$not_auto_combination_fields=array();


    224. 

  224. 			if(version_compare(_PS_VERSION_, '1.5.0.0', '>='))


    225. 

  225. 				$not_auto_combination_fields[]='supplier_reference';


    226. 

  226. 			


    227. 

  227. 			$marginMatrix_forms=array(


    228. 

  228. 					0=>'{price}-{wholesale_price}',


    229. 

  229. 					1=>'({price}-{wholesale_price})*100/{wholesale_price}',


    230. 

  230. 					2=>'{price}/{wholesale_price}',


    231. 

  231. 					3=>'{price_inc_tax}/{wholesale_price}',


    232. 

  232. 					4=>'({price_inc_tax}-{wholesale_price})*100/{wholesale_price}',


    233. 

  233. 					5=>'({price}-{wholesale_price})*100/{price}'


    234. 

  234. 			);


    235. 

  235. 			$marginMatrix_form = $marginMatrix_forms[_s('CAT_PROD_GRID_MARGIN_OPERATION')];


    236. 

  236. 			


    237. 

  237. 			if (!$CRON && !$AUTO_EXPORT) 


    238. 

  238. 				showHeaders();


    239. 

  239. 			


    240. 

  240. 			if($AUTO_EXPORT || ($CRON && $CRONVERSION>=2))


    241. 

  241. 			{


    242. 

  242. 				$sql = "SELECT * FROM "._DB_PREFIX_."sc_export WHERE name='".pSQL($auto_filename)."'";


    243. 

  243. 				$sc_export=Db::getInstance()->ExecuteS($sql);


    244. 

  244. 				if(!empty($sc_export[0]["id_sc_export"]))


    245. 

  245. 				{


    246. 

  246. 					$sc_export = $sc_export[0];


    247. 

  247. 				}


    248. 

  248. 				else


    249. 

  249. 				{


    250. 

  250. 					$sql = "INSERT INTO "._DB_PREFIX_."sc_export (name, last_export, exporting, id_next, id_combination_next, total_lines)


    251. 

  251. 							VALUES ('".pSQL($auto_filename)."',NULL,0,0,0,0)";


    252. 

  252. 					Db::getInstance()->Execute($sql);


    253. 

  253. 					$temp_id = Db::getInstance()->Insert_ID();


    254. 

  254. 					if(!empty($temp_id))


    255. 

  255. 						$sc_export = array("id_sc_export"=>$temp_id,"name"=>$auto_filename, "last_export"=>null, "exporting"=>0, "id_next"=>0,"id_combination_next"=>0,"total_lines"=>0);


    256. 

  256. 					else


    257. 

  257. 					{


    258. 

  258. 						if($AUTO_EXPORT)


    259. 

  259. 						{


    260. 

  260. 							echo json_encode(array(


    261. 

  261. 								"type" => "error",


    262. 

  262. 								"stop" => 1,


    263. 

  263. 								"content" => '<strong style="color: #831f1f;">'._l('Error during sc_export creation.', 1).'</span>',


    264. 

  264. 								"debug" => $sql,


    265. 

  265. 								"filename" => $auto_filename,


    266. 

  266. 								"first_interval" => $first_interval


    267. 

  267. 							));


    268. 

  268. 							die();


    269. 

  269. 						}


    270. 

  270. 						else


    271. 

  271. 						{


    272. 

  272. 							echo _l('Error during sc_export creation.');


    273. 

  273. 							$STOP_SCRIPT= true;


    274. 

  274. 						}


    275. 

  275. 					}


    276. 

  276. 				}


    277. 

  277. 			}


    278. 

  278. 			if($STOP_SCRIPT)


    279. 

  279. 				break;


    280. 

  280. 			


    281. 

  281. 


    282. 

  282. 			/*$time_end = microtime(true);


    283. 

  283. 			$time = $time_end - $time_start;


    284. 

  284. 			echo "<br/><br/>after auto export : $time seconds";*/


    285. 

  285. 			


    286. 

  286. 			// GET MAPPING


    287. 

  287. 			readExportConfigXML($filename);


    288. 

  288. 			if ($exportConfig['fieldsep']=='dcomma') $exportConfig['fieldsep']=';';


    289. 

  289. 			if ($exportConfig['fieldsep']=='dcommamac') $exportConfig['fieldsep']=';';


    290. 

  290. 			if ($exportConfig['fieldsep']=='tab') $exportConfig['fieldsep']='	';


    291. 

  291. 			if ($exportConfig['enclosedby']=='quote') $exportConfig['enclosedby']='"';


    292. 

  292. 			$selected_shops_id = (int)$exportConfig['shops'];


    293. 

  293. 			if(empty($selected_shops_id))


    294. 

  294. 				$selected_shops_id = SCI::getSelectedShop();


    295. 

  295. 			if(empty($selected_shops_id))


    296. 

  296. 				$selected_shops_id = (int)Configuration::get('PS_SHOP_DEFAULT');


    297. 

  297. 			


    298. 

  298. 			/* Server Params */


    299. 

  299. 			$server_host = getHttpHost(false, true);


    300. 

  300. 			$protocol = 'http://';


    301. 

  301. 			$protocol_ssl = 'https://';


    302. 

  302. 			$protocol_link = (Configuration::get('PS_SSL_ENABLED')) ? $protocol_ssl : $protocol;


    303. 

  303. 			if (SCMS)


    304. 

  304. 			{


    305. 

  305. 				$shop=new Shop((int)$selected_shops_id);


    306. 

  306. 				$_PS_BASE_URL_ = $protocol_link.$shop->domain.$shop->getBaseURI().'img/p/';


    307. 

  307. 			}else{


    308. 

  308. 				$_PS_BASE_URL_ = $protocol_link.$server_host._THEME_PROD_DIR_;


    309. 

  309. 			}


    310. 

  310. 			


    311. 

  311. 			// READ MAPPING


    312. 

  312. 			$fieldList=array();


    313. 

  313. 			$mapping=array();


    314. 

  314. 			if ($exportConfig['categoriessel']=='')


    315. 

  315. 			{


    316. 

  316. 				if(!$AUTO_EXPORT && !$CRON)


    317. 

  317. 					die(_l('You have to set the category selection for the script')._l(':').' '.substr($filename,0,-11));


    318. 

  318. 				elseif($CRON)


    319. 

  319. 				{


    320. 

  320. 					echo _l('You have to set the category selection for the script')._l(':').' '.substr($filename,0,-11);


    321. 

  321. 					$STOP_SCRIPT = true;


    322. 

  322. 				}


    323. 

  323. 				else


    324. 

  324. 				{


    325. 

  325. 					echo json_encode(array(


    326. 

  326. 						"type" => "error",


    327. 

  327. 						"stop" => 1,


    328. 

  328. 						"content" => '<strong style="color: #831f1f;">'._l('You have to set the category selection for the script')._l(':').' '.substr($filename,0,-11).'</span>',


    329. 

  329. 						"filename" => $auto_filename,


    330. 

  330. 						"first_interval" => $first_interval


    331. 

  331. 					));


    332. 

  332. 					die();


    333. 

  333. 				}


    334. 

  334. 			}


    335. 

  335. 			if ($exportConfig['mapping']=='')


    336. 

  336. 			{


    337. 

  337. 				if(!$AUTO_EXPORT && !$CRON)


    338. 

  338. 					die(_l('You have to set the mapping for the script.')._l(':').' '.substr($filename,0,-11));


    339. 

  339. 				elseif($CRON)


    340. 

  340. 				{


    341. 

  341. 					echo _l('You have to set the mapping for the script.')._l(':').' '.substr($filename,0,-11);


    342. 

  342. 					$STOP_SCRIPT = true;


    343. 

  343. 				}


    344. 

  344. 				else


    345. 

  345. 				{


    346. 

  346. 					echo json_encode(array(


    347. 

  347. 						"type" => "error",


    348. 

  348. 						"stop" => 1,


    349. 

  349. 						"content" => '<strong style="color: #831f1f;">'._l('You have to set the mapping for the script.')._l(':').' '.substr($filename,0,-11).'</span>',


    350. 

  350. 						"filename" => $auto_filename,


    351. 

  351. 						"first_interval" => $first_interval


    352. 

  352. 					));


    353. 

  353. 					die();


    354. 

  354. 				}


    355. 

  355. 			}


    356. 

  356. 			if ($exportConfig['mapping']!='' && $feed = @simplexml_load_file(SC_TOOLS_DIR.'cat_export/'.$exportConfig['mapping']))


    357. 

  357. 			{


    358. 

  358. 				foreach($feed->field AS $mfield)


    359. 

  359. 				{


    360. 

  360. 					if ((int)$mfield->used)


    361. 

  361. 					{


    362. 

  362. 						$mapping[]=array(	'name'=>(string)$mfield->name,


    363. 

  363. 															'lang'=>(string)$mfield->lang,


    364. 

  364. 															'options'=>(string)$mfield->options,


    365. 

  365. 															'filters'=>(string)$mfield->filters,


    366. 

  366. 															'modifications'=>(string)$mfield->modifications,


    367. 

  367. 															'column_name'=>(string)$mfield->column_name);


    368. 

  368. 						$fieldList[]=(string)$mfield->name;


    369. 

  369. 					}


    370. 

  370. 				}


    371. 

  371. 			}


    372. 

  372. 			


    373. 

  373. 			if ($exportConfig['exportfilename']=='')


    374. 

  374. 			{


    375. 

  375. 				if(!$AUTO_EXPORT && !$CRON)


    376. 

  376. 					die(_l('You have to define a filename for the export.')._l(':').' '.substr($filename,0,-11));


    377. 

  377. 				elseif($CRON)


    378. 

  378. 				{


    379. 

  379. 					echo _l('You have to define a filename for the export.')._l(':').' '.substr($filename,0,-11);


    380. 

  380. 					$STOP_SCRIPT = true;


    381. 

  381. 				}


    382. 

  382. 				else


    383. 

  383. 				{


    384. 

  384. 					echo json_encode(array(


    385. 

  385. 						"type" => "error",


    386. 

  386. 						"stop" => 1,


    387. 

  387. 						"content" => '<strong style="color: #831f1f;">'._l('You have to define a filename for the export.',1)._l(':',1).' '.substr($filename,0,-11).'</span>',


    388. 

  388. 						"filename" => $auto_filename,


    389. 

  389. 						"first_interval" => $first_interval


    390. 

  390. 					));


    391. 

  391. 					die();


    392. 

  392. 				}


    393. 

  393. 			}


    394. 

  394. 			if($STOP_SCRIPT)


    395. 

  395. 				break;


    396. 

  396. 			


    397. 

  397. 			// CRON CHECK


    398. 

  398. 			if($CRON && $CRONVERSION>=2)


    399. 

  399. 			{


    400. 

  400. 				if($sc_export["exporting"]==1)


    401. 

  401. 				{


    402. 

  402. 					$ALREADY_EXPORTING = true;


    403. 

  403. 				}


    404. 

  404. 				else


    405. 

  405. 				{


    406. 

  406. 					$sql = "UPDATE "._DB_PREFIX_."sc_export SET exporting = 1 WHERE name = '".pSQL($auto_filename)."'";


    407. 

  407. 					Db::getInstance()->Execute($sql);


    408. 

  408. 				}


    409. 

  409. 			}


    410. 

  410. 			/*$time_end = microtime(true);


    411. 

  411. 			$time = $time_end - $time_start;


    412. 

  412. 			echo "<br/><br/>after mapping : $time seconds";*/


    413. 

  413. 			


    414. 

  414. 			// AUTO EXPORT & FIRST INTERVAL


    415. 

  415. 			if(($AUTO_EXPORT || ($CRON && $CRONVERSION>=2)) && $first_interval)


    416. 

  416. 			{


    417. 

  417. 				if($sc_export["exporting"]==0)


    418. 

  418. 				{


    419. 

  419. 					$sql = "UPDATE "._DB_PREFIX_."sc_export SET exporting = 1, id_next=0, id_combination_next=0, last_export='".date("Y-m-d H:i:s")."' WHERE name = '".pSQL($auto_filename)."'";


    420. 

  420. 					Db::getInstance()->Execute($sql);


    421. 

  421. 					


    422. 

  422. 					// INITIALISATION


    423. 

  423. 					$sql = "DELETE FROM "._DB_PREFIX_."sc_export_product WHERE id_sc_export = '".(int)$sc_export["id_sc_export"]."'";


    424. 

  424. 					Db::getInstance()->Execute($sql);


    425. 

  425. 					


    426. 

  426. 					file_put_contents(SC_CSV_EXPORT_DIR.$exportConfig['exportfilename'], "");


    427. 

  427. 


    428. 

  428. 					$sc_export["exporting"] = 0;


    429. 

  429. 					$sc_export["id_next"] = 0;


    430. 

  430. 					$sc_export["id_combination_next"] = 0;


    431. 

  431. 				}


    432. 

  432. 				else


    433. 

  433. 				{


    434. 

  434. 					$ALREADY_EXPORTING = true;


    435. 

  435. 					/*echo json_encode(array(


    436. 

  436. 							"type" => "error",


    437. 

  437. 							"stop" => 1,


    438. 

  438. 							"content" => '<strong style="color: #831f1f;">'._l('This export is already in progress.',1).'</span>',


    439. 

  439. 							"filename" => $auto_filename,


    440. 

  440. 							"first_interval" => $first_interval


    441. 

  441. 					));


    442. 

  442. 					die();*/


    443. 

  443. 				}


    444. 

  444. 			}


    445. 

  445. 


    446. 

  446. 			//die("error");


    447. 

  447. 			


    448. 

  448. 			// MAIN QUERIES


    449. 

  449. 			if ($exportConfig['exportbydefaultcategory']) // by default category


    450. 

  450. 			{


    451. 

  451. 				// TOTAL LINES


    452. 

  452. 				/*if($AUTO_EXPORT && $first_interval)


    453. 

  453. 				{


    454. 

  454. 					$sql= ' SELECT p.id_product,c.id_category';


    455. 

  455. 					$sql.=' FROM '._DB_PREFIX_.'product p';


    456. 

  456. 					if(SCMS && $selected_shops_id > 0)


    457. 

  457. 						$sql.='	INNER JOIN `'._DB_PREFIX_.'product_shop` ps ON (p.id_product = ps.id_product AND ps.id_shop = "'.(int)$selected_shops_id.'")';


    458. 

  458. 					$sql.=' LEFT JOIN '._DB_PREFIX_.'category_product pdc ON (pdc.id_category='.(	SCMS && $selected_shops_id > 0 ? 'ps':'p').'.id_category_default AND pdc.id_product=p.id_product)';


    459. 

  459. 					$sql.=' LEFT JOIN '._DB_PREFIX_.'category c ON (c.id_category=pdc.id_category)';


    460. 

  460. 					$sql.=' WHERE 1';


    461. 

  461. 					switch($exportConfig['categoriessel']){


    462. 

  462. 						case 'all' :


    463. 

  463. 							break;


    464. 

  464. 						case 'all_enabled' :


    465. 

  465. 							$sql.=' AND c.active=1'."\n";


    466. 

  466. 							break;


    467. 

  467. 						case 'all_disabled' :


    468. 

  468. 							$sql.=' AND c.active=0'."\n";


    469. 

  469. 							break;


    470. 

  470. 						default:


    471. 

  471. 							$filename=$exportConfig['categoriessel'];


    472. 

  472. 							$categories=array();


    473. 

  473. 							if ($feed = simplexml_load_file(SC_TOOLS_DIR.'cat_categories_sel/'.$filename))


    474. 

  474. 							{


    475. 

  475. 								foreach($feed->category AS $category)


    476. 

  476. 									$categories[]=(string)$category->id;


    477. 

  477. 								$sql.=' AND pdc.id_category IN ('.join(',',$categories).')';


    478. 

  478. 							}


    479. 

  479. 							break;


    480. 

  480. 					}


    481. 

  481. 					if(SCMS && $selected_shops_id>0)


    482. 

  482. 					{


    483. 

  483. 						$sql.=((int)($exportConfig['exportdisabledproducts'])?'':' AND ps.active=1');


    484. 

  484. 					}else{


    485. 

  485. 						$sql.=((int)($exportConfig['exportdisabledproducts'])?'':' AND p.active=1');


    486. 

  486. 					}


    487. 

  487. 					$sql.=' GROUP BY p.id_product,c.id_category';


    488. 

  488. 					$total_products=Db::getInstance()->ExecuteS($sql);


    489. 

  489. 					$sc_export["total_lines"] = count($total_products);


    490. 

  490. 					


    491. 

  491. 					$sql = "UPDATE "._DB_PREFIX_."sc_export SET total_lines='".(int)$sc_export["total_lines"]."' WHERE name = '".pSQL($auto_filename)."'";


    492. 

  492. 					Db::getInstance()->Execute($sql);


    493. 

  493. 				}*/


    494. 

  494. 				


    495. 

  495. 				$sql= ' SELECT p.id_product,c.id_category';


    496. 

  496. 				$sql.=' FROM '._DB_PREFIX_.'product p';


    497. 

  497. 				if(SCMS && $selected_shops_id > 0)


    498. 

  498. 					$sql.='	INNER JOIN `'._DB_PREFIX_.'product_shop` ps ON (p.id_product = ps.id_product AND ps.id_shop = "'.(int)$selected_shops_id.'")';


    499. 

  499. 				elseif(!SCMS && version_compare(_PS_VERSION_, '1.5.0.0', '>='))


    500. 

  500. 					$sql.='	INNER JOIN `'._DB_PREFIX_.'product_shop` ps ON (p.id_product = ps.id_product AND ps.id_shop = "'.SCI::getSelectedShop().'")';


    501. 

  501. 				$sql.=' LEFT JOIN '._DB_PREFIX_.'category_product pdc ON (pdc.id_category='.((SCMS && $selected_shops_id > 0) || (!SCMS && version_compare(_PS_VERSION_, '1.5.0.0', '>='))? 'ps':'p').'.id_category_default AND pdc.id_product=p.id_product)';


    502. 

  502. 				$sql.=' LEFT JOIN '._DB_PREFIX_.'category c ON (c.id_category=pdc.id_category)';


    503. 

  503. 				$sql.=' WHERE 1';


    504. 

  504. 				switch($exportConfig['categoriessel']){


    505. 

  505. 					case 'all' :


    506. 

  506. 						break;


    507. 

  507. 					case 'all_enabled' :


    508. 

  508. 						$sql.=' AND c.active=1'."\n";


    509. 

  509. 						break;


    510. 

  510. 					case 'all_disabled' :


    511. 

  511. 						$sql.=' AND c.active=0'."\n";


    512. 

  512. 						break;


    513. 

  513. 					default:


    514. 

  514. 						$filename=$exportConfig['categoriessel'];


    515. 

  515. 						$categories=array();


    516. 

  516. 						if ($feed = simplexml_load_file(SC_TOOLS_DIR.'cat_categories_sel/'.$filename))


    517. 

  517. 						{


    518. 

  518. 							foreach($feed->category AS $category)


    519. 

  519. 								$categories[]=(string)$category->id;


    520. 

  520. 							$sql.=' AND pdc.id_category IN ('.join(',',$categories).')';


    521. 

  521. 						}


    522. 

  522. 						break;


    523. 

  523. 				}


    524. 

  524. 				if((SCMS && $selected_shops_id > 0) || (!SCMS && version_compare(_PS_VERSION_, '1.5.0.0', '>=')))


    525. 

  525. 				{


    526. 

  526. 					$sql.=((int)($exportConfig['exportdisabledproducts'])?'':' AND ps.active=1');


    527. 

  527. 				}else{


    528. 

  528. 					$sql.=((int)($exportConfig['exportdisabledproducts'])?'':' AND p.active=1');


    529. 

  529. 				}


    530. 

  530. 				if($AUTO_EXPORT || ($CRON && $CRONVERSION>=2))


    531. 

  531. 				{


    532. 

  532. 					$sql.=' AND  (


    533. 

  533. 								p.id_product NOT IN (SELECT id_product FROM '._DB_PREFIX_.'sc_export_product WHERE id_sc_export = "'.(int)$sc_export["id_sc_export"].'" AND handled=1) ';


    534. 

  534. 					if(!empty($sc_export["id_next"]) && $exportConfig['exportcombinations'])


    535. 

  535. 						$sql.=' OR (p.id_product = "'.$sc_export["id_next"].'") ';


    536. 

  536. 					$sql.=' ) ';


    537. 

  537. 				}


    538. 

  538. 				$sql.=' GROUP BY p.id_product,c.id_category';


    539. 

  539. 				if($AUTO_EXPORT || ($CRON && $CRONVERSION>=2))


    540. 

  540. 				{


    541. 

  541. 					if(!empty($sc_export["id_next"]) && $exportConfig['exportcombinations'])


    542. 

  542. 						$sql.=' ORDER BY p.id_product ASC


    543. 

  543. 								LIMIT '.intval($export_limit+1);


    544. 

  544. 					else


    545. 

  545. 						$sql.=' ORDER BY p.id_product ASC


    546. 

  546. 								LIMIT '.intval($export_limit);


    547. 

  547. 				}


    548. 

  548. 				else


    549. 

  549. 					$sql.=' ORDER BY p.id_category_default, pdc.position';


    550. 

  550. 			}else{ // for all categories


    551. 

  551. 


    552. 

  552. 				// TOTAL LINES


    553. 

  553. 				/*if($AUTO_EXPORT && $first_interval)


    554. 

  554. 				{


    555. 

  555. 					$sql= ' SELECT DISTINCT cp.id_product,cp.id_category';


    556. 

  556. 					$sql.=' FROM '._DB_PREFIX_.'category_product cp';


    557. 

  557. 					$sql.=' LEFT JOIN '._DB_PREFIX_.'category c ON (c.id_category=cp.id_category)';


    558. 

  558. 					$sql.=' LEFT JOIN '._DB_PREFIX_.'product p ON (p.id_product=cp.id_product)';


    559. 

  559. 					if(SCMS && $selected_shops_id>0)


    560. 

  560. 					{


    561. 

  561. 						$sql.='	INNER JOIN `'._DB_PREFIX_.'product_shop` ps ON (p.id_product = ps.id_product AND ps.id_shop = "'.(int)$selected_shops_id.'")';


    562. 

  562. 					}


    563. 

  563. 					$sql.=' WHERE 1';


    564. 

  564. 					switch($exportConfig['categoriessel']){


    565. 

  565. 						case 'all' :


    566. 

  566. 							break;


    567. 

  567. 						case 'all_enabled' :


    568. 

  568. 							$sql.=' AND c.active=1';


    569. 

  569. 							break;


    570. 

  570. 						case 'all_disabled' :


    571. 

  571. 							$sql.=' AND c.active=0';


    572. 

  572. 							break;


    573. 

  573. 						default:


    574. 

  574. 							$filename=$exportConfig['categoriessel'];


    575. 

  575. 							$categories=array();


    576. 

  576. 							if ($feed = simplexml_load_file(SC_TOOLS_DIR.'cat_categories_sel/'.$filename))


    577. 

  577. 							{


    578. 

  578. 								foreach($feed->category AS $category)


    579. 

  579. 									$categories[]=(string)$category->id;


    580. 

  580. 								$sql.=' AND cp.id_category IN ('.join(',',$categories).')';


    581. 

  581. 							}


    582. 

  582. 							break;


    583. 

  583. 					}


    584. 

  584. 					if(SCMS && $selected_shops_id>0)


    585. 

  585. 					{


    586. 

  586. 						$sql.=((int)($exportConfig['exportdisabledproducts'])?'':' AND ps.active=1');


    587. 

  587. 					}else{


    588. 

  588. 						$sql.=((int)($exportConfig['exportdisabledproducts'])?'':' AND p.active=1');


    589. 

  589. 					}


    590. 

  590. 					$sql.=' GROUP BY cp.id_product,cp.id_category';


    591. 

  591. 					$total_products=Db::getInstance()->ExecuteS($sql);


    592. 

  592. 					$sc_export["total_lines"] = count($total_products);


    593. 

  593. 						


    594. 

  594. 					$sql = "UPDATE "._DB_PREFIX_."sc_export SET total_lines='".(int)$sc_export["total_lines"]."' WHERE name = '".pSQL($auto_filename)."'";


    595. 

  595. 					Db::getInstance()->Execute($sql);


    596. 

  596. 				}*/


    597. 

  597. 				


    598. 

  598. 				$sql= ' SELECT DISTINCT(cp.id_product),cp.id_category';


    599. 

  599. 				$sql.=' FROM '._DB_PREFIX_.'category_product cp';


    600. 

  600. 				$sql.=' LEFT JOIN '._DB_PREFIX_.'category c ON (c.id_category=cp.id_category)';


    601. 

  601. 				$sql.=' LEFT JOIN '._DB_PREFIX_.'product p ON (p.id_product=cp.id_product)';


    602. 

  602. 				if(SCMS && $selected_shops_id > 0)


    603. 

  603. 					$sql.='	INNER JOIN `'._DB_PREFIX_.'product_shop` ps ON (p.id_product = ps.id_product AND ps.id_shop = "'.(int)$selected_shops_id.'")';


    604. 

  604. 				elseif(!SCMS && version_compare(_PS_VERSION_, '1.5.0.0', '>='))


    605. 

  605. 					$sql.='	INNER JOIN `'._DB_PREFIX_.'product_shop` ps ON (p.id_product = ps.id_product AND ps.id_shop = "'.SCI::getSelectedShop().'")';


    606. 

  606. 				$sql.=' WHERE 1';


    607. 

  607. 				switch($exportConfig['categoriessel']){


    608. 

  608. 					case 'all' :


    609. 

  609. 						break;


    610. 

  610. 					case 'all_enabled' :


    611. 

  611. 						$sql.=' AND c.active=1';


    612. 

  612. 						break;


    613. 

  613. 					case 'all_disabled' :


    614. 

  614. 						$sql.=' AND c.active=0';


    615. 

  615. 						break;


    616. 

  616. 					default:


    617. 

  617. 						$filename=$exportConfig['categoriessel'];


    618. 

  618. 						$categories=array();


    619. 

  619. 						if ($feed = simplexml_load_file(SC_TOOLS_DIR.'cat_categories_sel/'.$filename))


    620. 

  620. 						{


    621. 

  621. 							foreach($feed->category AS $category)


    622. 

  622. 								$categories[]=(string)$category->id;


    623. 

  623. 							$sql.=' AND cp.id_category IN ('.join(',',$categories).')';


    624. 

  624. 						}


    625. 

  625. 						break;


    626. 

  626. 				}


    627. 

  627. 				if((SCMS && $selected_shops_id > 0) || (!SCMS && version_compare(_PS_VERSION_, '1.5.0.0', '>=')))


    628. 

  628. 				{


    629. 

  629. 					$sql.=((int)($exportConfig['exportdisabledproducts'])?'':' AND ps.active=1');


    630. 

  630. 				}else{


    631. 

  631. 					$sql.=((int)($exportConfig['exportdisabledproducts'])?'':' AND p.active=1');


    632. 

  632. 				}


    633. 

  633. 				if($AUTO_EXPORT || ($CRON && $CRONVERSION>=2))


    634. 

  634. 				{


    635. 

  635. 					$sql.=' AND  (


    636. 

  636. 								cp.id_product NOT IN (SELECT id_product FROM '._DB_PREFIX_.'sc_export_product WHERE id_sc_export = "'.(int)$sc_export["id_sc_export"].'") ';


    637. 

  637. 					if(!empty($sc_export["id_next"]) && $exportConfig['exportcombinations'])


    638. 

  638. 						$sql.=' OR (cp.id_product = "'.$sc_export["id_next"].'") ';


    639. 

  639. 					$sql.=' ) ';


    640. 

  640. 				}


    641. 

  641. 				$sql.=' GROUP BY cp.id_product';


    642. 

  642. 				if($AUTO_EXPORT || ($CRON && $CRONVERSION>=2))


    643. 

  643. 				{


    644. 

  644. 					if(!empty($sc_export["id_next"]) && $exportConfig['exportcombinations'])


    645. 

  645. 						$sql.=' ORDER BY cp.id_product ASC


    646. 

  646. 								LIMIT '.intval($export_limit+1);


    647. 

  647. 					else


    648. 

  648. 						$sql.=' ORDER BY cp.id_product ASC


    649. 

  649. 								LIMIT '.intval($export_limit);


    650. 

  650. 				}


    651. 

  651. 				else


    652. 

  652. 					$sql.=' ORDER BY cp.id_category, cp.position';


    653. 

  653. 			}


    654. 

  654. 			$products=Db::getInstance()->ExecuteS($sql);


    655. 

  655. 			if (!is_array($products))


    656. 

  656. 			{


    657. 

  657. 				if(!$CRON)


    658. 

  658. 				{


    659. 

  659. 					echo json_encode(array(


    660. 

  660. 							"type" => "error",


    661. 

  661. 							"stop" => 1,


    662. 

  662. 							"content" => '<strong style="color: #831f1f;">MySQL error: '.Db::getInstance()->getMsgError().'</span>',


    663. 

  663. 							"filename" => $auto_filename,


    664. 

  664. 							"debug" => $debug,


    665. 

  665. 							"first_interval" => $first_interval


    666. 

  666. 					));


    667. 

  667. 					exit;


    668. 

  668. 				}


    669. 

  669. 			}


    670. 

  670. //			$debug .= Db::getInstance()->getMsgError();


    671. 

  671. 			$linecount=0;


    672. 

  672. 			$linecountreal=0;


    673. 

  673. 			/*$time_end = microtime(true);


    674. 

  674. 			$time = $time_end - $time_start;


    675. 

  675. 			echo "<br/><br/>after products : $time seconds";*/


    676. 

  676. 			


    677. 

  677. 			// ALREADY EXPORTING


    678. 

  678. 			if(($AUTO_EXPORT || ($CRON && $CRONVERSION>=2)) && $ALREADY_EXPORTING && !$exportConfig['exportcombinations'])


    679. 

  679. 			{


    680. 

  680. 				if(!empty($products[0]["id_product"]))


    681. 

  681. 				{


    682. 

  682. 					$id_product_first = $products[0]["id_product"];


    683. 

  683. 					


    684. 

  684. 					if($id_product_first==$sc_export["id_next"])


    685. 

  685. 					{


    686. 

  686. 						$sql = "UPDATE "._DB_PREFIX_."sc_export SET exporting = 0 WHERE name = '".pSQL($auto_filename)."'";


    687. 

  687. 						Db::getInstance()->Execute($sql);


    688. 

  688. 							


    689. 

  689. 						if($AUTO_EXPORT)


    690. 

  690. 						{


    691. 

  691. 							echo json_encode(array(


    692. 

  692. 									"type" => "error",


    693. 

  693. 									"stop" => 1,


    694. 

  694. 									"content" => '<strong style="color: #831f1f;">'._l('An error occured during last export with product').' #'.$id_product_first.' <br/>'._l('Check this product before to try again.').'</span>',


    695. 

  695. 									"filename" => $auto_filename,


    696. 

  696. 									"first_interval" => $first_interval


    697. 

  697. 							));


    698. 

  698. 							die();


    699. 

  699. 						}


    700. 

  700. 						else


    701. 

  701. 						{


    702. 

  702. 							$STOP_SCRIPT = true;


    703. 

  703. 							echo _l('An error occured during last export with product').' #'.$id_product_first.' <br/>'._l('Check this product before to try again.');


    704. 

  704. 						}


    705. 

  705. 					}


    706. 

  706. 					else


    707. 

  707. 					{	


    708. 

  708. 						if($AUTO_EXPORT)


    709. 

  709. 						{


    710. 

  710. 							echo json_encode(array(


    711. 

  711. 									"type" => "error",


    712. 

  712. 									"stop" => 1,


    713. 

  713. 									"content" => '<strong style="color: #831f1f;">'._l('This export is already in progress.',1).' - <a href="javascript: void(0);" class="reset_export" id="export_'.(int)$sc_export["id_sc_export"].'">'._l('Reset',1).'</a></span>',


    714. 

  714. 									"filename" => $auto_filename,


    715. 

  715. 									"first_interval" => $first_interval


    716. 

  716. 							));


    717. 

  717. 							die();


    718. 

  718. 						}


    719. 

  719. 						else


    720. 

  720. 						{


    721. 

  721. 							$STOP_SCRIPT = true;


    722. 

  722. 							echo _l('This export is already in progress.');


    723. 

  723. 						}


    724. 

  724. 								


    725. 

  725. 					}


    726. 

  726. 				}


    727. 

  727. 				else


    728. 

  728. 				{


    729. 

  729. 					$sql = "UPDATE "._DB_PREFIX_."sc_export SET exporting = 0 WHERE name = '".pSQL($auto_filename)."'";


    730. 

  730. 					Db::getInstance()->Execute($sql);


    731. 

  731. 


    732. 

  732. 					if($AUTO_EXPORT)


    733. 

  733. 					{


    734. 

  734. 						echo json_encode(array(


    735. 

  735. 						 "type" => "error",


    736. 

  736. 								"stop" => 1,


    737. 

  737. 								"content" => '<strong style="color: #831f1f;">'._l('An error occured during export. Please try again.',1).'</span>',


    738. 

  738. 								"filename" => $auto_filename,


    739. 

  739. 								"first_interval" => $first_interval


    740. 

  740. 						));


    741. 

  741. 						die();


    742. 

  742. 					}


    743. 

  743. 						else


    744. 

  744. 						{


    745. 

  745. 							$STOP_SCRIPT = true;


    746. 

  746. 							echo _l('An error occured during export. Please try again.');


    747. 

  747. 						}


    748. 

  748. 				}


    749. 

  749. 			}


    750. 

  750. 			if($STOP_SCRIPT)


    751. 

  751. 				break;


    752. 

  752. 			


    753. 

  753. 			// WRITE FILE


    754. 

  754. 			if(($AUTO_EXPORT || ($CRON && $CRONVERSION>=2)) && $ALREADY_EXPORTING)


    755. 

  755. 				$fp = null;


    756. 

  756. 			elseif(($AUTO_EXPORT || ($CRON && $CRONVERSION>=2)) && !$ALREADY_EXPORTING)


    757. 

  757. 				$fp = fopen(SC_CSV_EXPORT_DIR.$exportConfig['exportfilename'], 'a');


    758. 

  758. 			else


    759. 

  759. 				$fp = fopen(SC_CSV_EXPORT_DIR.$exportConfig['exportfilename'], 'w');


    760. 

  760. 			


    761. 

  761. 			// First line			


    762. 

  762. 			if((!$AUTO_EXPORT && !($CRON && $CRONVERSION>=2)) || (($AUTO_EXPORT || ($CRON && $CRONVERSION>=2)) && $first_interval && !$ALREADY_EXPORTING))


    763. 

  763. 			{


    764. 

  764. 				if ($exportConfig['firstlinecontent']!='')


    765. 

  765. 				{


    766. 

  766. 					if (trim($exportConfig['firstlinecontent'])!='-')


    767. 

  767. 						fwrite($fp,((int)$exportConfig['iso']?utf8_decode($exportConfig['firstlinecontent']):$exportConfig['firstlinecontent'])."\n");


    768. 

  768. 				}else{


    769. 

  769. 					$fname=getExportCSVFields();


    770. 

  770. 					$fname=array_flip($fname);


    771. 

  771. 					$names=array();


    772. 

  772. 					$image_link_num=1;


    773. 

  773. 					$image_id_num=1;


    774. 

  774. 					$image_legend_num=1;


    775. 

  775. 					foreach($fieldList as $k => $mfield)


    776. 

  776. 					{


    777. 

  777. 						if(!empty($mapping[$k]['column_name']))


    778. 

  778. 							$names[]=stripslashes($mapping[$k]['column_name']);


    779. 

  779. 						else


    780. 

  780. 						{


    781. 

  781. 							if(SCAS && ($mfield=="quantity" || $mfield=="location" || $mfield=="quantity_physical" || $mfield=="quantity_usable" || $mfield=="quantity_real"))


    782. 

  782. 							{


    783. 

  783. 								$temp_name = $fname[$mfield];


    784. 

  784. 								if(empty($mapping[$k]['options']) || $mapping[$k]['options']=="warehouse_none")


    785. 

  785. 									$temp_name .= " "._l('No warehouse');


    786. 

  786. 								else


    787. 

  787. 								{


    788. 

  788. 									$temp = intval(str_replace("warehouse_","",$mapping[$k]['options']));


    789. 

  789. 									if(!empty($temp))


    790. 

  790. 									{


    791. 

  791. 										$warehouse = new Warehouse((int)$temp, (int)$id_lang);


    792. 

  792. 										if(!empty($warehouse->name))


    793. 

  793. 											$temp_name .= " "._l('Warehouse')." ".$warehouse->reference." - ".$warehouse->name;


    794. 

  794. 									}


    795. 

  795. 								}


    796. 

  796. 								$names[]=stripslashes($temp_name);


    797. 

  797. 							}


    798. 

  798. 							elseif($mfield=="supplier_reference" || $mfield=="wholesale_price")


    799. 

  799. 							{


    800. 

  800. 								$temp_name = $fname[$mfield];


    801. 

  801. 								if(empty($mapping[$k]['options']) || $mapping[$k]['options']=="supplier_none")


    802. 

  802. 									$temp_name .= " "._l('Default values display products/combinations grids');


    803. 

  803. 								else


    804. 

  804. 								{


    805. 

  805. 									$temp = ($mapping[$k]['options']);


    806. 

  806. 									if(!empty($temp))


    807. 

  807. 									{


    808. 

  808. 										$temp_name .= " "._l('Supplier')." ".$temp;


    809. 

  809. 									}


    810. 

  810. 								}


    811. 

  811. 								$names[]=stripslashes($temp_name);


    812. 

  812. 							}


    813. 

  813. 							elseif($mfield=="links_to_all_images")


    814. 

  814. 							{


    815. 

  815. 								$names[]=stripslashes($fname[$mfield]);


    816. 

  816. 							}


    817. 

  817. 							elseif($mfield=="image_link" || $mfield=="image_id" || $mfield=="image_legend")


    818. 

  818. 							{


    819. 

  819. 								$num = 1;


    820. 

  820. 								if($mfield=="image_link")


    821. 

  821. 								{


    822. 

  822. 									$num = $image_link_num;


    823. 

  823. 									$image_link_num++;


    824. 

  824. 								}


    825. 

  825. 								if($mfield=="image_id")


    826. 

  826. 								{


    827. 

  827. 									$num = $image_id_num;


    828. 

  828. 									$image_id_num++;


    829. 

  829. 								}


    830. 

  830. 								if($mfield=="image_legend")


    831. 

  831. 								{


    832. 

  832. 									$num = $image_legend_num;


    833. 

  833. 									$image_legend_num++;


    834. 

  834. 								}


    835. 

  835. 								$names[]=stripslashes($fname[$mfield].($mapping[$k]['options']!='' && $mapping[$k]['options']!="supplier_none"?' '.$mapping[$k]['options']:'').($mapping[$k]['lang']!=''?' '.strtoupper($mapping[$k]['lang']):'')." ".$num);


    836. 

  836. 							}


    837. 

  837. 							else


    838. 

  838. 							{


    839. 

  839. 								$names[]=stripslashes($fname[$mfield].($mapping[$k]['options']!='' && $mapping[$k]['options']!="supplier_none"?' '.$mapping[$k]['options']:'').($mapping[$k]['lang']!=''?' '.strtoupper($mapping[$k]['lang']):''));


    840. 

  840. 							}


    841. 

  841. 						}


    842. 

  842. 					}


    843. 

  843. 					fwrite($fp,((int)$exportConfig['iso']?utf8_decode(join($exportConfig['fieldsep'],$names)):join($exportConfig['fieldsep'],$names))."\n");


    844. 

  844. 				}


    845. 

  845. 			}


    846. 

  846. 			


    847. 

  847. 			// supplier


    848. 

  848. 			if (sc_in_array('supplier_reference',$fieldList,"catWinExportProcess_fieldList") || sc_in_array('wholesale_price',$fieldList,"catWinExportProcess_fieldList"))


    849. 

  849. 			{


    850. 

  850. 				$suppliersListByLang=array();


    851. 

  851. 					


    852. 

  852. 				// DEFAULT LANG


    853. 

  853. 				$sql='SELECT s.name,s.`id_supplier`


    854. 

  854. 							FROM `'._DB_PREFIX_.'supplier` s


    855. 

  855. 							'.((SCMS && $selected_shops_id>0)?' INNER JOIN `'._DB_PREFIX_.'supplier_shop` ss ON (s.`id_supplier` = ss.`id_supplier` AND ss.id_shop = "'.(int)$selected_shops_id.'") ':'').'';


    856. 

  856. 				$suppliers=Db::getInstance()->ExecuteS($sql);


    857. 

  857. 				foreach($suppliers AS $supplier)


    858. 

  858. 					$suppliersListByLang[$supplier['name']]=$supplier['id_supplier'];


    859. 

  859. 			}


    860. 

  860. 


    861. 

  861. 			// PRODUCTS TREATMENT


    862. 

  862. 			foreach($products AS $idp)


    863. 

  863. 			{


    864. 

  864. 				$id_product_attribute=0;


    865. 

  865. 				$sql = "UPDATE "._DB_PREFIX_."sc_export SET id_next = '".(int)$idp['id_product']."' WHERE name = '".pSQL($auto_filename)."'";


    866. 

  866. 				Db::getInstance()->Execute($sql);


    867. 

  867. 				


    868. 

  868. 				// array_diff checks if we need to load product details (more queries to handle)


    869. 

  869. 				if(SCMS && $selected_shops_id>0)


    870. 

  870. 					$p=new Product($idp['id_product'], (count($fieldList)!=count(array_diff($fieldList,array('supplier','manufacturer','vat','link_to_product','unity','tags'))) ? true:false), null, (int)$selected_shops_id );


    871. 

  871. 				else


    872. 

  872. 					$p=new Product($idp['id_product'], (count($fieldList)!=count(array_diff($fieldList,array('supplier','manufacturer','vat','link_to_product','unity','tags'))) ? true:false) );


    873. 

  873. 


    874. 

  874. 				$id_product = $idp['id_product'];


    875. 

  875. 				


    876. 

  876. 				// features


    877. 

  877. 				if (sc_in_array('feature',$fieldList,"catWinExportProcess_fieldList") || sc_in_array('multiple_features',$fieldList,"catWinExportProcess_fieldList"))


    878. 

  878. 				{


    879. 

  879. 					$featuresListByLang=array();


    880. 

  880. 					


    881. 

  881. 					// DEFAULT LANG


    882. 

  882. 					$featuresListNameDefault = array();


    883. 

  883. 					$sql='SELECT fl.name,fp.`id_feature`


    884. 

  884. 							FROM `'._DB_PREFIX_.'feature_product` fp


    885. 

  885. 							LEFT JOIN `'._DB_PREFIX_.'feature_lang` fl ON fp.`id_feature` = fl.`id_feature`


    886. 

  886. 							'.((SCMS && $selected_shops_id>0)?' INNER JOIN `'._DB_PREFIX_.'feature_shop` fs ON (fp.`id_feature` = fs.`id_feature` AND fs.id_shop = "'.(int)$selected_shops_id.'") ':'').'


    887. 

  887. 							WHERE fp.`id_product` = '.intval($idp['id_product']).'


    888. 

  888. 							AND fl.`id_lang` = '.intval($sc_agent->id_lang);


    889. 

  889. 					$features=Db::getInstance()->ExecuteS($sql);


    890. 

  890. 					foreach($features AS $feature)


    891. 

  891. 						$featuresListNameDefault[$feature['id_feature']]=$feature['name'];


    892. 

  892. 					


    893. 

  893. 					// OTHER LANGS


    894. 

  894. 					$langs = Language::getLanguages();


    895. 

  895. 					foreach($langs as $lang)


    896. 

  896. 					{


    897. 

  897. 						$sql='SELECT fl.name,fvl.value,fp.`id_feature`


    898. 

  898. 									FROM `'._DB_PREFIX_.'feature_product` fp


    899. 

  899. 									LEFT JOIN `'._DB_PREFIX_.'feature_lang` fl ON fp.`id_feature` = fl.`id_feature`


    900. 

  900. 									LEFT JOIN `'._DB_PREFIX_.'feature_value_lang` fvl ON fp.`id_feature_value` = fvl.`id_feature_value`


    901. 

  901. 									'.((SCMS && $selected_shops_id>0)?' INNER JOIN `'._DB_PREFIX_.'feature_shop` fs ON (fp.`id_feature` = fs.`id_feature` AND fs.id_shop = "'.(int)$selected_shops_id.'") ':'').'


    902. 

  902. 									WHERE fp.`id_product` = '.intval($idp['id_product']).'


    903. 

  903. 									AND fl.`id_lang` = '.intval($lang['id_lang']).'


    904. 

  904. 									AND fvl.`id_lang` = '.intval($lang['id_lang']);


    905. 

  905. 						$features=Db::getInstance()->ExecuteS($sql);


    906. 

  906. 						$featuresListByLang[$lang['id_lang']]=array();


    907. 

  907. 						foreach($features AS $feature)


    908. 

  908. 						{


    909. 

  909. 							$featuresListByLang[$lang['id_lang']][$featuresListNameDefault[$feature['id_feature']]]=$feature['value'];


    910. 

  910. 						}


    911. 

  911. 					}


    912. 

  912. 				}


    913. 

  913. 


    914. 

  914. 				// combinations


    915. 

  915. 				if(


    916. 

  916. 					(!$AUTO_EXPORT && !($CRON && $CRONVERSION>=2))


    917. 

  917. 					|| (($AUTO_EXPORT || ($CRON && $CRONVERSION>=2)) && $exportConfig['exportcombinations'] && $idp['id_product']!=$sc_export["id_next"]) 


    918. 

  918. 					|| (($AUTO_EXPORT || ($CRON && $CRONVERSION>=2)) && !$exportConfig['exportcombinations'])


    919. 

  919. 				)


    920. 

  920. 					$combArray=array(0 => array()); // 0: initialize array for products without combinations


    921. 

  921. 				else


    922. 

  922. 					$combArray=array();


    923. 

  923. 				if ($exportConfig['exportcombinations'])


    924. 

  924. 				{


    925. 

  925. 					// IN DEFAULT LANG


    926. 

  926. 					$attributesByDefaultLang = array();


    927. 

  927. 					$sql='SELECT agl.`name` AS group_name, ag.`id_attribute_group`


    928. 

  928. 								FROM `'._DB_PREFIX_.'attribute_group` ag


    929. 

  929. 								LEFT JOIN `'._DB_PREFIX_.'attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)


    930. 

  930. 								WHERE agl.`id_lang` = '.intval($sc_agent->id_lang).'


    931. 

  931. 								ORDER BY ag.`id_attribute_group`';


    932. 

  932. 					$temp_attributes = Db::getInstance()->ExecuteS($sql);


    933. 

  933. 					foreach($temp_attributes as $temp_attribute)


    934. 

  934. 					{


    935. 

  935. 						$attributesByDefaultLang[$temp_attribute['id_attribute_group']]=$temp_attribute['group_name'];


    936. 

  936. 					}


    937. 

  937. 					


    938. 

  938. 					/* Build attributes combinaisons */


    939. 

  939. 					$standardFields=array('price','wholesale_price','weight','reference','upc','unit_price_impact','supplier_reference','ean13','default_on','ecotax');


    940. 

  940. 					if (version_compare(_PS_VERSION_, '1.5.0.0', '>='))


    941. 

  941. 						$standardFields[] = 'available_date';


    942. 

  942. 					if (!SCAS)


    943. 

  943. 						$standardFields[] = 'location';


    944. 

  944. 					sc_ext::readExportCSVConfigXML('addInCombiFields');


    945. 

  945. 					//pa.id_product_attribute, pa.quantity, pa.'.(implode(", pa.", $standardFields)).'


    946. 

  946. 					$sql='SELECT pa.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, a.`color`,al.id_lang '.((version_compare(_PS_VERSION_, '1.5.0.0', '>=') && $selected_shops_id>0)?',pas.*':"").'


    947. 

  947. 								FROM `'._DB_PREFIX_.'product_attribute` pa


    948. 

  948. 								LEFT JOIN `'._DB_PREFIX_.'product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`


    949. 

  949. 								LEFT JOIN `'._DB_PREFIX_.'attribute` a ON a.`id_attribute` = pac.`id_attribute`


    950. 

  950. 								LEFT JOIN `'._DB_PREFIX_.'attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`


    951. 

  951. 								LEFT JOIN `'._DB_PREFIX_.'attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)


    952. 

  952. 								LEFT JOIN `'._DB_PREFIX_.'attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND al.`id_lang` = agl.`id_lang`)


    953. 

  953. 								'.((version_compare(_PS_VERSION_, '1.5.0.0', '>=') && $selected_shops_id>0)?' INNER JOIN `'._DB_PREFIX_.'product_attribute_shop` pas ON (pa.`id_product_attribute` = pas.`id_product_attribute` AND pas.id_shop="'.(int)$selected_shops_id.'")':"").'


    954. 

  954. 								WHERE pa.`id_product` = '.intval($p->id).' ';


    955. 

  955. 					if($AUTO_EXPORT || ($CRON && $CRONVERSION>=2))


    956. 

  956. 					{


    957. 

  957. 						$sql.=' AND  (


    958. 

  958. 									pa.id_product_attribute NOT IN (SELECT id_product_attribute FROM '._DB_PREFIX_.'sc_export_product WHERE id_sc_export = "'.(int)$sc_export["id_sc_export"].'" AND id_product="'.intval($p->id).'") ';


    959. 

  959. 						$sql.=' ) ';


    960. 

  960. 					}


    961. 

  961. 					$sql.=' ORDER BY pa.`id_product_attribute`';


    962. 

  962. 					


    963. 

  963. 					$combinaisons = Db::getInstance()->ExecuteS($sql);


    964. 

  964. 					$groups = array();


    965. 

  965. 					if (is_array($combinaisons))


    966. 

  966. 					{


    967. 

  967. 						$combinationImages = getCombinationImages((int)$p->id);


    968. 

  968. 						foreach ($combinaisons AS $k => $combinaison)


    969. 

  969. 						{


    970. 

  970. 							$id_product_attribute = $combinaison['id_product_attribute'];


    971. 

  971. 							if (!$exportConfig['exportoutofstock'])


    972. 

  972. 							{


    973. 

  973. 								if (version_compare(_PS_VERSION_, '1.5.0.0', '>='))


    974. 

  974. 									$qty=StockAvailable::getQuantityAvailableByProduct($p->id, ($id_product_attribute==0 ? NULL:$id_product_attribute), (version_compare(_PS_VERSION_, '1.5.0.0', '>=') && $selected_shops_id>0?(int)$selected_shops_id:null));


    975. 

  975. 								else


    976. 

  976. 									$qty=intval($combinaison['quantity']);


    977. 

  977. 								if ($qty<=0)


    978. 

  978. 									continue;


    979. 

  979. 							}


    980. 

  980. 							//if (!$exportConfig['exportoutofstock'] && intval($combinaison['quantity'])==0) continue;


    981. 

  981. 							$combArray[$combinaison['id_product_attribute']]['price_impact'] = $combinaison['price'];


    982. 

  982. 							$combArray[$combinaison['id_product_attribute']]['pa_location'] = $combinaison['location'];


    983. 

  983. 							$combArray[$combinaison['id_product_attribute']]['weight_impact'] = $combinaison['weight'];


    984. 

  984. 							$combArray[$combinaison['id_product_attribute']]['attribute_color'] = $combinaison['color'];


    985. 

  985. 							if(isset($combinaison['minimal_quantity']))


    986. 

  986. 								$combArray[$combinaison['id_product_attribute']]['minimal_quantity'] = $combinaison['minimal_quantity'];


    987. 

  987. 							if(!empty($sc_active))


    988. 

  988. 								$combArray[$combinaison['id_product_attribute']]['sc_active'] = $combinaison['sc_active'];


    989. 

  989. 							if(SCI::getConfigurationValue("SC_DELIVERYDATE_INSTALLED")=="1")


    990. 

  990. 								$combArray[$combinaison['id_product_attribute']]['id_sc_available_later'] = $combinaison['id_sc_available_later'];


    991. 

  991. 							$combArray[$combinaison['id_product_attribute']]['id_image'] = sc_array_key_exists($combinaison['id_product_attribute'],$combinationImages) ? $combinationImages[$combinaison['id_product_attribute']] : 0;


    992. 

  992. 							$combArray[$combinaison['id_product_attribute']]['attributes'][$combinaison['id_lang']][] = array($combinaison['group_name'], $combinaison['attribute_name'], $combinaison['id_attribute'], $combinaison['id_attribute_group']);


    993. 

  993. 							//$standardFields=array('price','wholesale_price','weight','reference','upc','unit_price_impact','supplier_reference','ean13','location','default_on','ecotax');


    994. 

  994. 							foreach($standardFields AS $sfield)


    995. 

  995. 							{


    996. 

  996. 								if (sc_array_key_exists($sfield,$combinaison))


    997. 

  997. 									$combArray[$combinaison['id_product_attribute']][$sfield] = $combinaison[$sfield];


    998. 

  998. 								if (version_compare(_PS_VERSION_, '1.5.0.0', '>=') && $sfield=='supplier_reference')


    999. 

  999. 									$combArray[$combinaison['id_product_attribute']][$sfield] = ProductSupplier::getProductSupplierReference((int)$p->id, (int)$combinaison['id_product_attribute'], (int)$p->id_supplier);


    1000. 

  1000. 							}


    1001. 

  1001. 							if(intval(_s("CAT_EXPORT_EAN13_COMBI"))!="1")


    1002. 

  1002. 							{


    1003. 

  1003. 								if(empty($combinaison['ean13']))


    1004. 

  1004. 								{


    1005. 

  1005. 									$combArray[$combinaison['id_product_attribute']]['ean13']="";


    1006. 

  1006. 								}


    1007. 

  1007. 							}


    1008. 

  1008. 							if(intval(_s("CAT_EXPORT_UPC_COMBI"))!="1")


    1009. 

  1009. 							{


    1010. 

  1010. 								if(empty($combinaison['upc']))


    1011. 

  1011. 								{


    1012. 

  1012. 									$combArray[$combinaison['id_product_attribute']]['upc']="";


    1013. 

  1013. 								}


    1014. 

  1014. 							}


    1015. 

  1015. 							if(intval(_s("CAT_EXPORT_REF_COMBI"))!="1")


    1016. 

  1016. 							{


    1017. 

  1017. 								if(empty($combinaison['reference']))


    1018. 

  1018. 								{


    1019. 

  1019. 									$combArray[$combinaison['id_product_attribute']]['reference']="";


    1020. 

  1020. 								}


    1021. 

  1021. 							}


    1022. 

  1022. 							if ($combinaison['is_color_group'])


    1023. 

  1023. 								$groups[$combinaison['id_attribute_group']] = $combinaison['group_name'];


    1024. 

  1024. 						}


    1025. 

  1025. 						if (count($combArray)>1) // unset products without combinations to skip next foreach


    1026. 

  1026. 							unset($combArray[0]);


    1027. 

  1027. 						foreach($combArray AS $id_product_attribute => $attributes)


    1028. 

  1028. 						{


    1029. 

  1029. 							if ($id_product_attribute!=0)


    1030. 

  1030. 								foreach($attributes['attributes'] AS $id_lang => $values)


    1031. 

  1031. 								{


    1032. 

  1032. 									foreach($values AS $v)


    1033. 

  1033. 									{


    1034. 

  1034. 										if (!isset($combArray[$id_product_attribute]['name_with_attributes'][$id_lang]))


    1035. 

  1035. 											$combArray[$id_product_attribute]['name_with_attributes'][$id_lang] = $p->name[intval($id_lang)].' ';


    1036. 

  1036. 										$combArray[$id_product_attribute]['name_with_attributes'][$id_lang].=$v[0].':'.$v[1].' - ';


    1037. 

  1037. 										if (!isset($combArray[$id_product_attribute]['attributeByGroup'][$id_lang]))


    1038. 

  1038. 											$combArray[$id_product_attribute]['attributeByGroup'][$id_lang] = array();


    1039. 

  1039. 										$combArray[$id_product_attribute]['attributeByGroup'][$id_lang][ $attributesByDefaultLang[$v[3]] ]=$v[1];


    1040. 

  1040. 										if (!isset($combArray[$id_product_attribute]['attribute_color']))


    1041. 

  1041. 											$combArray[$id_product_attribute]['attribute_color'] = '';


    1042. 

  1042. 										if ($v[4]!='')


    1043. 

  1043. 											$combArray[$id_product_attribute]['attribute_color'] .= ',#'.$v[4];


    1044. 

  1044. 										// $group[0] : group name


    1045. 

  1045. 										// $group[1] : attribute name


    1046. 

  1046. 										// $group[2] : attribute id


    1047. 

  1047. 										// $group[3] : id_attribute_group


    1048. 

  1048. 										// $group[4] : color


    1049. 

  1049. 									}


    1050. 

  1050. 								}


    1051. 

  1051. 						}


    1052. 

  1052. 					}


    1053. 

  1053. 				}


    1054. 

  1054. 				


    1055. 

  1055. 				// ALREADY EXPORTING


    1056. 

  1056. 				if(($AUTO_EXPORT || ($CRON && $CRONVERSION>=2)) && $ALREADY_EXPORTING && $exportConfig['exportcombinations'])


    1057. 

  1057. 				{


    1058. 

  1058. 					$id_product_attribute_first = 0;


    1059. 

  1059. 					ksort($combArray);


    1060. 

  1060. 					foreach($combArray AS $id_product_attribute => $product_attribute)


    1061. 

  1061. 					{


    1062. 

  1062. 						if(!empty($id_product_attribute) && $idp['id_product']==$sc_export["id_next"])


    1063. 

  1063. 						{


    1064. 

  1064. 							$id_product_attribute_first = $id_product_attribute;


    1065. 

  1065. 							break;


    1066. 

  1066. 						}


    1067. 

  1067. 					}


    1068. 

  1068. 					


    1069. 

  1069. 					if(!empty($id_product_attribute_first))


    1070. 

  1070. 					{


    1071. 

  1071. 						if($id_product_attribute_first==$sc_export["id_combination_next"])


    1072. 

  1072. 						{


    1073. 

  1073. 							$sql = "UPDATE "._DB_PREFIX_."sc_export SET exporting = 0 WHERE name = '".pSQL($auto_filename)."'";


    1074. 

  1074. 							Db::getInstance()->Execute($sql);


    1075. 

  1075. 								


    1076. 

  1076. 							if($AUTO_EXPORT)


    1077. 

  1077. 							{


    1078. 

  1078. 								echo json_encode(array(


    1079. 

  1079. 										"type" => "error",


    1080. 

  1080. 										"stop" => 1,


    1081. 

  1081. 										"content" => '<strong style="color: #831f1f;">'._l('An error occured during last export with combination').' #'.$id_product_attribute_first.' '._l('from product').' #'.$idp['id_product'].'<br/>'._l('Check this combination before to try again.').'</span>',


    1082. 

  1082. 										"filename" => $auto_filename,


    1083. 

  1083. 										"first_interval" => $first_interval


    1084. 

  1084. 								));


    1085. 

  1085. 								die();


    1086. 

  1086. 							}


    1087. 

  1087. 							else


    1088. 

  1088. 							{


    1089. 

  1089. 								$STOP_SCRIPT=true;


    1090. 

  1090. 								echo _l('An error occured during last export with combination').' #'.$id_product_attribute_first.' '._l('from product').' #'.$idp['id_product'].'<br/>'._l('Check this combination before to try again.');


    1091. 

  1091. 							}


    1092. 

  1092. 						}


    1093. 

  1093. 						else


    1094. 

  1094. 						{


    1095. 

  1095. 							if($AUTO_EXPORT)


    1096. 

  1096. 							{


    1097. 

  1097. 								echo json_encode(array(


    1098. 

  1098. 										"type" => "error",


    1099. 

  1099. 										"stop" => 1,


    1100. 

  1100. 										"content" => '<strong style="color: #831f1f;">'._l('This export is already in progress.',1).' - <a href="javascript: void(0);" class="reset_export" id="export_'.(int)$sc_export["id_sc_export"].'">'._l('Reset',1).'</a></span>',


    1101. 

  1101. 										"filename" => $auto_filename,


    1102. 

  1102. 										"first_interval" => $first_interval


    1103. 

  1103. 								));


    1104. 

  1104. 								die();


    1105. 

  1105. 							}


    1106. 

  1106. 							else


    1107. 

  1107. 							{


    1108. 

  1108. 								$STOP_SCRIPT=true;


    1109. 

  1109. 								echo _l('This export is already in progress.');


    1110. 

  1110. 							}


    1111. 

  1111. 						}


    1112. 

  1112. 					}


    1113. 

  1113. 					else


    1114. 

  1114. 					{


    1115. 

  1115. 						$sql = "UPDATE "._DB_PREFIX_."sc_export SET exporting = 0 WHERE name = '".pSQL($auto_filename)."'";


    1116. 

  1116. 						Db::getInstance()->Execute($sql);


    1117. 

  1117. 


    1118. 

  1118. 						if($AUTO_EXPORT)


    1119. 

  1119. 						{


    1120. 

  1120. 							echo json_encode(array(


    1121. 

  1121. 									"type" => "error",


    1122. 

  1122. 									"stop" => 1,


    1123. 

  1123. 									"content" => '<strong style="color: #831f1f;">'._l('An error occured during last export with product').' #'.$idp['id_product'].' <br/>'._l('Check this product before to try again.').'</span>',


    1124. 

  1124. 									"filename" => $auto_filename,


    1125. 

  1125. 									"first_interval" => $first_interval


    1126. 

  1126. 							));


    1127. 

  1127. 							die();


    1128. 

  1128. 						}


    1129. 

  1129. 						else


    1130. 

  1130. 						{


    1131. 

  1131. 							$STOP_SCRIPT=true;


    1132. 

  1132. 							echo _l('An error occured during last export with product').' #'.$idp['id_product'].' <br/>'._l('Check this product before to try again.');


    1133. 

  1133. 						}


    1134. 

  1134. 					}


    1135. 

  1135. 				}


    1136. 

  1136. 				if($STOP_SCRIPT)


    1137. 

  1137. 					break;


    1138. 

  1138. 				


    1139. 

  1139. 				$extension_vars = array();


    1140. 

  1140. 				


    1141. 

  1141. 				// COMBINATIONS TREATMENT


    1142. 

  1142. 				foreach($combArray AS $id_product_attribute => $product_attribute)


    1143. 

  1143. 				{		


    1144. 

  1144. 					if(


    1145. 

  1145. 						!(


    1146. 

  1146. 							($AUTO_EXPORT || ($CRON && $CRONVERSION>=2))


    1147. 

  1147. 							&& $exportConfig['exportcombinations'] 


    1148. 

  1148. 							&& $p->id==$sc_export["id_next"] 


    1149. 

  1149. 							&& !empty($id_product_attribute) 


    1150. 

  1150. 							&& $id_product_attribute<=$sc_export["id_combination_next"]


    1151. 

  1151. 						)


    1152. 

  1152. 					)


    1153. 

  1153. 					{


    1154. 

  1154. 						if(!empty($id_product_attribute))


    1155. 

  1155. 						{


    1156. 

  1156. 							$sql = "UPDATE "._DB_PREFIX_."sc_export SET id_combination_next = '".(int)$id_product_attribute."' WHERE name = '".pSQL($auto_filename)."'";


    1157. 

  1157. 							Db::getInstance()->Execute($sql);


    1158. 

  1158. 						}


    1159. 

  1159. 


    1160. 

  1160. 						$linecount++;


    1161. 

  1161. 						if (!$exportConfig['exportoutofstock'])


    1162. 

  1162. 						{


    1163. 

  1163. 							if (version_compare(_PS_VERSION_, '1.5.0.0', '>='))


    1164. 

  1164. 								$qty=StockAvailable::getQuantityAvailableByProduct($p->id, ($id_product_attribute==0 ? NULL:$id_product_attribute), (version_compare(_PS_VERSION_, '1.5.0.0', '>=') && $selected_shops_id>0?(int)$selected_shops_id:null));


    1165. 

  1165. 							else


    1166. 

  1166. 								$qty=$p->getQuantity($p->id,($id_product_attribute==0 ? NULL:$id_product_attribute));


    1167. 

  1167. 							if ($qty<=0)


    1168. 

  1168. 							{


    1169. 

  1169. 								if(!empty($sc_export["id_sc_export"]))


    1170. 

  1170. 								{


    1171. 

  1171. 									$sql = "


    1172. 

  1172. 									INSERT INTO "._DB_PREFIX_."sc_export_product (id_sc_export, id_product, id_product_attribute,exported)


    1173. 

  1173. 									VALUES ('".(int)$sc_export["id_sc_export"]."','".(int)$idp['id_product']."','".(int)$id_product_attribute."','0')";


    1174. 

  1174. 									Db::getInstance()->Execute($sql);


    1175. 

  1175. 								}


    1176. 

  1176. 								continue;


    1177. 

  1177. 							}


    1178. 

  1178. 						}


    1179. 

  1179. 						if(!empty($sc_export["id_sc_export"]))


    1180. 

  1180. 						{


    1181. 

  1181. 							$sql = "


    1182. 

  1182. 								INSERT INTO "._DB_PREFIX_."sc_export_product (id_sc_export, id_product, id_product_attribute,exported)


    1183. 

  1183. 								VALUES ('".(int)$sc_export["id_sc_export"]."','".(int)$idp['id_product']."','".(int)$id_product_attribute."','1')";


    1184. 

  1184. 							Db::getInstance()->Execute($sql);


    1185. 

  1185. 						}


    1186. 

  1186. 


    1187. 

  1187. 						$linecontent='';


    1188. 

  1188. 						$cacheProductImages=array();


    1189. 

  1189. 						$num_img_link = 1;


    1190. 

  1190. 						$num_img_legend = 1;


    1191. 

  1191. 						$num_img_id = 1;


    1192. 

  1192. 						$legends = array();


    1193. 

  1193. 						sc_ext::readExportCSVConfigXML('exportProcessInitRowVars');


    1194. 

  1194. 						


    1195. 

  1195. 						// foreach field in mapping


    1196. 

  1196. 						foreach($mapping AS $n => $f)


    1197. 

  1197. 						{


    1198. 

  1198. 							$field='';


    1199. 

  1199. 							// extensions


    1200. 

  1200. 							$switchObject=$f['name']
    1201.