PageRenderTime 55ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 0ms

/modules/storecommander/ead6f6fce09/SC/lib/cus/win-import/cus_win-import_process.php

https://gitlab.com/ptisky/API_prestashop
PHP | 767 lines | 673 code | 49 blank | 45 comment | 131 complexity | 6393a1897ca13672e62e950c04a3c36d 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. 


    25. 

  25. 	error_reporting(E_ALL ^ E_NOTICE);


    26. 

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


    27. 

  27. 


    28. 

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


    29. 

  29. 


    30. 

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


    31. 

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


    32. 

  32. 	$mapping=Tools::getValue('mapping','');


    33. 

  33. 	$create_categories=intval(Tools::getValue('create_categories',-1));


    34. 

  34. 


    35. 

  35. 	if(SCAS)


    36. 

  36. 		$stock_manager = StockManagerFactory::getManager();


    37. 

  37. 	


    38. 

  38. 	if (version_compare(_PS_VERSION_, '1.5.0.0', '<'))


    39. 

  39. 		include_once(SC_PS_PATH_DIR.'images.inc.php');


    40. 

  40. 


    41. 

  41. 	include_once(SC_DIR.'lib/php/parsecsv.lib.php');


    42. 

  42. 	require_once(SC_DIR.'lib/cat/win-import/cat_win-import_tools.php');


    43. 

  43. 	require_once(SC_DIR.'lib/cus/win-import/cus_win-import_tools.php');


    44. 

  44. 


    45. 

  45. 	switch($action){


    46. 

  46. 		case 'conf_delete':


    47. 

  47. 			$imp_opt_files=Tools::getValue('imp_opt_files','');


    48. 

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


    49. 

  49. 			$imp_opt_file_array=preg_split('/;/',$imp_opt_files);


    50. 

  50. 			foreach($imp_opt_file_array as $imp_opt_file)


    51. 

  51. 			{


    52. 

  52. 				if ($imp_opt_file!='')


    53. 

  53. 				{


    54. 

  54. 					if (@unlink(SC_CSV_IMPORT_DIR."customers/".$imp_opt_file))


    55. 

  55. 					{


    56. 

  56. 						echo $imp_opt_file." "._l('deleted')."\n";


    57. 

  57. 					}else{


    58. 

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


    59. 

  59. 					}


    60. 

  60. 				}


    61. 

  61. 			}


    62. 

  62. 			break;


    63. 

  63. 		case 'mapping_load':


    64. 

  64. 			echo loadMappingCus(Tools::getValue('filename',''));


    65. 

  65. 			break;


    66. 

  66. 		case 'mapping_delete':


    67. 

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


    68. 

  68. 			@unlink(SC_CSV_IMPORT_DIR."customers/".$filename.'.map.xml');


    69. 

  69. 			break;


    70. 

  70. 		case 'mapping_saveas':


    71. 

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


    72. 

  72. 			@unlink(SC_CSV_IMPORT_DIR."customers/".$filename.'.map.xml');


    73. 

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


    74. 

  74. 			$content='<mapping><id_lang>'.(int)$sc_agent->id_lang.'</id_lang>';


    75. 

  75. 			foreach($mapping AS $map)


    76. 

  76. 			{


    77. 

  77. 				$val=preg_split('/,/',$map);


    78. 

  78. 				if (count($val)==3)


    79. 

  79. 				{


    80. 

  80. 					$content.='<map>';


    81. 

  81. 					$content.='<csvname><![CDATA['.$val[0].']]></csvname>';


    82. 

  82. 					$content.='<dbname><![CDATA['.$val[1].']]></dbname>';


    83. 

  83. 					$content.='<options><![CDATA['.$val[2].']]></options>';


    84. 

  84. 					$content.='</map>';


    85. 

  85. 				}


    86. 

  86. 			}


    87. 

  87. 			$content.='</mapping>';


    88. 

  88. 			file_put_contents(SC_CSV_IMPORT_DIR."customers/".$filename.'.map.xml', $content);


    89. 

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


    90. 

  90. 			break;


    91. 

  91. 		case 'mapping_process':


    92. 

  92. 			if (SC_BETA)


    93. 

  93. 				$time_start = microtime(true);


    94. 

  94. 			checkDB();


    95. 

  95. 			$scdebug=false;


    96. 

  96. 			global $switchObject; // variable for custom import fields check


    97. 

  97. 			$switchObject='';


    98. 

  98. 			global $TODO; // actions


    99. 

  99. 			$TODO=array();


    100. 

  100. 			global $id_customer;


    101. 

  101. 			$id_customer=0;


    102. 

  102. 			$warehousesArray = array();


    103. 

  103. 			$productsStockAdvancedTypeArray = array();


    104. 

  104. 			$addressFields=array('address_title','address_country','address_state','address_company','address_lastname','address_firstname','address_1','address_2','address_postcode','address_city','address_other','address_phone','address_phonemobile');


    105. 

  105. 			


    106. 

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


    107. 

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


    108. 

  108. 			$getIDlangByISO=array();


    109. 

  109. 			$id_lang_sc=intval(Tools::getValue('id_lang_sc'));


    110. 

  110. 			foreach($languages AS $lang)


    111. 

  111. 			{


    112. 

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


    113. 

  113. 			}


    114. 

  114. 			


    115. 

  115. 			$files = array_diff( scandir( SC_CSV_IMPORT_DIR."customers/" ), array_merge( Array( ".", "..", "index.php", ".htaccess", SC_CSV_IMPORT_CONF)) );


    116. 

  116. 			readCusImportConfigXML($files);


    117. 

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


    118. 

  118. 			if ($create_categories <= 0) $create_categories=intval($importConfig[$filename]['createcategories']);


    119. 

  119. 			$importlimit=intval(Tools::getValue('importlimit',0));


    120. 

  120. 			$importlimit=($importlimit > 0 ? $importlimit : intval($importConfig[$filename]['importlimit']));


    121. 

  121. 			if ($importConfig[$filename]['firstlinecontent']!='') $importlimit--;


    122. 

  122. 			if ($CRON) $mapping=loadMappingCus($importConfig[$filename]['mapping']);


    123. 

  123. 			if ($filename===0 || $mapping=='')


    124. 

  124. 				die(_l('You have to select a file and a mapping.'));


    125. 

  125. 			$mappingDataArray=explode(';',$mapping);


    126. 

  126. 			$mappingData=array('CSVArray' => array(),'DBArray' => array(),'CSV2DB' => array(),'CSV2DBOptions' => array(),'CSV2DBOptionsMerged' => array());


    127. 

  127. 			foreach($mappingDataArray AS $val)


    128. 

  128. 			{


    129. 

  129. 				if ($val!='')


    130. 

  130. 				{


    131. 

  131. 					$tmp=explode(',',$val);


    132. 

  132. 					$tmp2=$tmp[0];


    133. 

  133. 					escapeCharForPS($tmp2);


    134. 

  134. 					$mappingData['CSVArray'][]=$tmp2;


    135. 

  135. 					$mappingData['DBArray'][]=$tmp[1];


    136. 

  136. 					$mappingData['CSV2DB'][$tmp[0]]=$tmp[1];


    137. 

  137. 					$mappingData['CSV2DBOptions'][$tmp[0]]=$tmp[2];


    138. 

  138. 					$mappingData['CSV2DBOptionsMerged'][$tmp[0]]=$tmp[1].'_'.$tmp[2];


    139. 

  139. 				}


    140. 

  140. 			}


    141. 

  141. 			// check mapping


    142. 

  142. 			switch ($importConfig[$filename]['idby']){


    143. 

  143. 				case'idcustomer':


    144. 

  144. 					if (!sc_in_array('id_customer',$mappingData['DBArray'],"cusWinImportProcess_DBArray"))


    145. 

  145. 						die(_l('Wrong mapping, mapping should contain the id_customer field'));


    146. 

  146. 					break;


    147. 

  147. 				case'email':


    148. 

  148. 					if (!sc_in_array('email',$mappingData['DBArray'],"cusWinImportProcess_DBArray"))


    149. 

  149. 						die(_l('Wrong mapping, mapping should contain the email field'));


    150. 

  150. 					break;


    151. 

  151. 				case'idcustomeradresse':


    152. 

  152. 					if (!sc_in_array('id_customer',$mappingData['DBArray'],"cusWinImportProcess_DBArray") && !sc_in_array('address_title',$mappingData['DBArray'],"cusWinImportProcess_DBArray"))


    153. 

  153. 						die(_l('Wrong mapping, mapping should contain the id_customer and the address title fields'));


    154. 

  154. 					else if (!sc_in_array('id_customer',$mappingData['DBArray'],"cusWinImportProcess_DBArray"))


    155. 

  155. 						die(_l('Wrong mapping, mapping should contain the id_customer field'));


    156. 

  156. 					else if (!sc_in_array('address_title',$mappingData['DBArray'],"cusWinImportProcess_DBArray"))


    157. 

  157. 						die(_l('Wrong mapping, mapping should contain the address title field'));


    158. 

  158. 					break;


    159. 

  159. 				case'emailadresse':


    160. 

  160. 					if (!sc_in_array('email',$mappingData['DBArray'],"cusWinImportProcess_DBArray") && !sc_in_array('address_title',$mappingData['DBArray'],"cusWinImportProcess_DBArray"))


    161. 

  161. 						die(_l('Wrong mapping, mapping should contain the email and the address title fields'));


    162. 

  162. 					else if (!sc_in_array('email',$mappingData['DBArray'],"cusWinImportProcess_DBArray"))


    163. 

  163. 						die(_l('Wrong mapping, mapping should contain the email field'));


    164. 

  164. 					else if (!sc_in_array('address_title',$mappingData['DBArray'],"cusWinImportProcess_DBArray"))


    165. 

  165. 						die(_l('Wrong mapping, mapping should contain the address title field'));


    166. 

  166. 					break;


    167. 

  167. 				case'idcustomeridadresse':


    168. 

  168. 					if (!sc_in_array('id_customer',$mappingData['DBArray'],"cusWinImportProcess_DBArray") && !sc_in_array('id_address',$mappingData['DBArray'],"cusWinImportProcess_DBArray"))


    169. 

  169. 						die(_l('Wrong mapping, mapping should contain the id_customer and the id_address fields'));


    170. 

  170. 					else if (!sc_in_array('id_customer',$mappingData['DBArray'],"cusWinImportProcess_DBArray"))


    171. 

  171. 						die(_l('Wrong mapping, mapping should contain the id_customer field'));


    172. 

  172. 					else if (!sc_in_array('id_address',$mappingData['DBArray'],"cusWinImportProcess_DBArray"))


    173. 

  173. 						die(_l('Wrong mapping, mapping should contain the id_address field'));


    174. 

  174. 					break;


    175. 

  175. 				case'emailidadresse':


    176. 

  176. 					if (!sc_in_array('email',$mappingData['DBArray'],"cusWinImportProcess_DBArray") && !sc_in_array('id_address',$mappingData['DBArray'],"cusWinImportProcess_DBArray"))


    177. 

  177. 						die(_l('Wrong mapping, mapping should contain the email and the id_address fields'));


    178. 

  178. 					else if (!sc_in_array('email',$mappingData['DBArray'],"cusWinImportProcess_DBArray"))


    179. 

  179. 						die(_l('Wrong mapping, mapping should contain the email field'));


    180. 

  180. 					else if (!sc_in_array('id_address',$mappingData['DBArray'],"cusWinImportProcess_DBArray"))


    181. 

  181. 						die(_l('Wrong mapping, mapping should contain the id_address field'));


    182. 

  182. 					break;


    183. 

  183. 			}


    184. 

  184. 


    185. 

  185. 			// create TODO file


    186. 

  186. 			if (substr($filename,strlen($filename)-9,9)=='.TODO.csv' && !file_exists(SC_CSV_IMPORT_DIR."customers/".$filename))


    187. 

  187. 				die(_l('The TODO file has been deleted, please select the original CSV file.'));


    188. 

  188. 			if (substr($filename,strlen($filename)-9,9)!='.TODO.csv')


    189. 

  189. 			{


    190. 

  190. 				$TODOfilename=substr($filename,0,-4).'.TODO.csv';


    191. 

  191. 				if (!file_exists(SC_CSV_IMPORT_DIR."customers/".$TODOfilename))


    192. 

  192. 				{


    193. 

  193. 					copy(SC_CSV_IMPORT_DIR."customers/".$filename,SC_CSV_IMPORT_DIR."customers/".$TODOfilename);


    194. 

  194. 					foreach($importConfig[$filename] AS $k => $v)


    195. 

  195. 					{


    196. 

  196. 						$importConfig[$TODOfilename][$k]=$v;


    197. 

  197. 						if ($k=='name') $importConfig[$TODOfilename][$k]=$TODOfilename;


    198. 

  198. 					}


    199. 

  199. 					writeCusImportConfigXML();


    200. 

  200. 				}


    201. 

  201. 			}else{


    202. 

  202. 				$TODOfilename=$filename;


    203. 

  203. 			}


    204. 

  204. 			$needSaveTODO=false;


    205. 

  205. 


    206. 

  206. 			// Get Other Informations


    207. 

  207. 			$all_genders = array();


    208. 

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


    209. 

  209. 			{


    210. 

  210. 				$sql = "SELECT id_gender, name


    211. 

  211. 					FROM "._DB_PREFIX_."gender_lang


    212. 

  212. 						WHERE id_lang = '".(int)$id_lang_sc."'


    213. 

  213. 					ORDER BY name";


    214. 

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


    215. 

  215. 				foreach($res as $re)


    216. 

  216. 				{


    217. 

  217. 					$all_genders[$re["id_gender"]] = $re["id_gender"];


    218. 

  218. 					$all_genders[mb_strtolower($re["name"], ($importConfig[$TODOfilename]['utf8']?'UTF-8':''))] = $re["id_gender"];


    219. 

  219. 				}


    220. 

  220. 				


    221. 

  221. 				$id_lang_en = Language::getIdByIso("en");


    222. 

  222. 				if($id_lang_en!=$id_lang_sc)


    223. 

  223. 				{


    224. 

  224. 					$sql = "SELECT id_gender, name


    225. 

  225. 					FROM "._DB_PREFIX_."gender_lang


    226. 

  226. 						WHERE id_lang = '".(int)$id_lang_en."'


    227. 

  227. 					ORDER BY name";


    228. 

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


    229. 

  229. 					foreach($res as $re)


    230. 

  230. 					{


    231. 

  231. 						$all_genders[$re["id_gender"]] = $re["id_gender"];


    232. 

  232. 						$all_genders[mb_strtolower($re["name"], ($importConfig[$TODOfilename]['utf8']?'UTF-8':''))] = $re["id_gender"];


    233. 

  233. 					}


    234. 

  234. 				}


    235. 

  235. 				if (version_compare(_PS_VERSION_, '1.6.0.0', '>='))


    236. 

  236. 				{


    237. 

  237. 					$all_genders[strtolower(_l("Miss"))] = 2;


    238. 

  238. 					$all_genders[strtolower(("Miss"))] = 2;


    239. 

  239. 				}


    240. 

  240. 			}


    241. 

  241. 			else


    242. 

  242. 			{	


    243. 

  243. 				$all_genders[0] = 0;


    244. 

  244. 				$all_genders[strtolower(_l("Unk."))] = 0;


    245. 

  245. 				$all_genders[strtolower("Unk.")] = 0;


    246. 

  246. 				$all_genders[1] = 1;


    247. 

  247. 				$all_genders[strtolower(_l("Mr."))] = 1;


    248. 

  248. 				$all_genders[strtolower(("Mr."))] = 1;


    249. 

  249. 				$all_genders[2] = 2;


    250. 

  250. 				$all_genders[strtolower(_l("Ms."))] = 2;


    251. 

  251. 				$all_genders[strtolower(("Ms."))] = 2;


    252. 

  252. 				$all_genders[3] = 3;


    253. 

  253. 				$all_genders[strtolower(_l("Miss"))] = 3;


    254. 

  254. 				$all_genders[strtolower(("Miss"))] = 3;


    255. 

  255. 				$all_genders[4] = 4;


    256. 

  256. 				$all_genders[9] = 9;


    257. 

  257. 			}


    258. 

  258. 			


    259. 

  259. 			if (version_compare(_PS_VERSION_, '1.2.0.0', '>='))


    260. 

  260. 			{


    261. 

  261. 				$all_groups = array();


    262. 

  262. 				$sql = "SELECT id_group, name


    263. 

  263. 					FROM "._DB_PREFIX_."group_lang


    264. 

  264. 						WHERE id_lang = '".(int)$id_lang_sc."'


    265. 

  265. 					ORDER BY name";


    266. 

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


    267. 

  267. 				foreach($res as $re)


    268. 

  268. 				{


    269. 

  269. 					$all_groups[$re["id_group"]] = $re["id_group"];


    270. 

  270. 					$all_groups[mb_strtolower($re["name"], ($importConfig[$TODOfilename]['utf8']?'UTF-8':''))] = $re["id_group"];


    271. 

  271. 				}


    272. 

  272. 			}


    273. 

  273. 			


    274. 

  274. 			$all_countries = array();


    275. 

  275. 			$sql = "SELECT id_country, name


    276. 

  276. 			FROM "._DB_PREFIX_."country_lang


    277. 

  277. 				WHERE id_lang = '".(int)$id_lang_sc."'


    278. 

  278. 			ORDER BY name";


    279. 

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


    280. 

  280. 			foreach($res as $re)


    281. 

  281. 			{


    282. 

  282. 				$all_countries[$re["id_country"]] = $re["id_country"];


    283. 

  283. 				$all_countries[mb_strtolower($re["name"], ($importConfig[$TODOfilename]['utf8']?'UTF-8':''))] = $re["id_country"];


    284. 

  284. 			}


    285. 

  285. 			$all_states = array();


    286. 

  286. 			$sql = "SELECT id_state, name


    287. 

  287. 			FROM "._DB_PREFIX_."state


    288. 

  288. 			ORDER BY name";


    289. 

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


    290. 

  290. 			foreach($res as $re)


    291. 

  291. 			{


    292. 

  292. 				$all_states[$re["id_state"]] = $re["id_state"];


    293. 

  293. 				$all_states[mb_strtolower($re["name"], ($importConfig[$TODOfilename]['utf8']?'UTF-8':''))] = $re["id_state"];


    294. 

  294. 			}


    295. 

  295. 			


    296. 

  296. 			// open csv filename


    297. 

  297. 			if ($importConfig[$TODOfilename]['fieldsep']=='dcomma') $importConfig[$TODOfilename]['fieldsep']=';';


    298. 

  298. 			if ($importConfig[$TODOfilename]['fieldsep']=='dcommamac') $importConfig[$TODOfilename]['fieldsep']=';';


    299. 

  299. 			// get first line


    300. 

  300. 			$DATAFILE=file_get_contents(SC_CSV_IMPORT_DIR."customers/".$TODOfilename);


    301. 

  301. 			$DATA = preg_split("/(?:\r\n|\r|\n)/", $DATAFILE);


    302. 

  302. 			if ($importConfig[$TODOfilename]['firstlinecontent']!='')


    303. 

  303. 			{


    304. 

  304. 				$firstLineData=explode($importConfig[$TODOfilename]['fieldsep'],$importConfig[$TODOfilename]['firstlinecontent']);


    305. 

  305. 				$FIRST_CONTENT_LINE=0;


    306. 

  306. 			}else{


    307. 

  307. 				$firstLineData=explode($importConfig[$TODOfilename]['fieldsep'],$DATA[0]);


    308. 

  308. 				$FIRST_CONTENT_LINE=1;


    309. 

  309. 			}


    310. 

  310. 			if (count($firstLineData)!=count(array_unique($firstLineData)))


    311. 

  311. 				die(_l('Error : at least 2 columns have the same name in CSV file. You must use a unique name by column in the first line of your CSV file.'));


    312. 

  312. 			foreach($firstLineData AS $key => $val)


    313. 

  313. 				escapeCharForPS($firstLineData[$key]);


    314. 

  314. 			$firstLineData=array_map('cleanQuotes',$firstLineData);


    315. 

  315. 			if ($importConfig[$TODOfilename]['utf8'])


    316. 

  316. 				utf8_encode_array($firstLineData);


    317. 

  317. 


    318. 

  318. 			// CHECK FILE VALIDITY


    319. 

  319. 			if (count($mappingData['CSVArray']) > count($firstLineData))


    320. 

  320. 				die(_l('Error in mapping: too much field to import').' (CSVArray:'.count($mappingData['CSVArray']).' - firstLineData:'.count($firstLineData).')');


    321. 

  321. 			foreach($mappingData['CSVArray'] AS $val)


    322. 

  322. 			{


    323. 

  323. 				if (!sc_in_array($val,$firstLineData,"cusWinImportProcess_firstLineData"))


    324. 

  324. 					die(_l('Error in mapping: the fields are not in the CSV file')._l(':').$val);


    325. 

  325. 			}


    326. 

  326. 			


    327. 

  327. 			if ($err!='')


    328. 

  328. 				die($err.'<br/><br/>'._l('The process has been stopped before any modification in the database. You need to fix these errors first.'));


    329. 

  329. 


    330. 

  330. 			


    331. 

  331. 			$stats=array('created' => 0,'modified' => 0,'skipped' => 0,'group_created' => 0);


    332. 

  332. 			$noWholesalepriceArray = array();


    333. 

  333. 			$CSVDataStr = file_get_contents(SC_CSV_IMPORT_DIR."customers/".$TODOfilename);


    334. 

  334. 			$CSVData = preg_split("/(?:\r\n|\r|\n)/", $CSVDataStr);


    335. 

  335. 			$lastIdentifier='';


    336. 

  336. 			


    337. 

  337. 			$id_shop_default=1;


    338. 

  338. 			if (SCMS)


    339. 

  339. 				$id_shop_default=array((int)Configuration::get('PS_SHOP_DEFAULT'));


    340. 

  340. 			$lastid_customer=0;


    341. 

  341. 			$id_shop=$id_shop_default;


    342. 

  342. 			if(!empty($importConfig[$TODOfilename]['id_shop']))


    343. 

  343. 				$id_shop=(int)$importConfig[$TODOfilename]['id_shop'];


    344. 

  344. 			


    345. 

  345. 			$customersWithTagUpdatedList=array();


    346. 

  346. 


    347. 

  347. 			for ($current_line = $FIRST_CONTENT_LINE; ((($current_line <= (count($DATA)-1)) && $line = parseCSVLine($importConfig[$TODOfilename]['fieldsep'],$DATA[$current_line])) && ($current_line <= $importlimit)) ; $current_line++)


    348. 

  348. 			{


    349. 

  349. 				if ($DATA[$current_line]=='') continue;


    350. 

  350. 				$line=array_map('cleanQuotes',$line);


    351. 

  351. 				if ($scdebug) echo 'line '.$current_line.': ';


    352. 

  352. 				$line[count($line)-1]=rtrim($line[count($line)-1]);


    353. 

  353. 				$TODO=array();


    354. 

  354. 				$TODOSHOP=array();


    355. 

  355. 				if ($importConfig[$TODOfilename]['utf8']==1)


    356. 

  356. 					utf8_encode_array($line);


    357. 

  357. 								


    358. 

  358. 				switch($importConfig[$TODOfilename]['idby'])


    359. 

  359. 				{


    360. 

  360. 					case 'idcustomer':


    361. 

  361. 						$sql="SELECT id_customer,date_upd FROM "._DB_PREFIX_."customer WHERE id_customer='".intval(findCSVLineValue('id_customer'))."' ".((SCMS)?" AND id_shop='".(int)$id_shop."'":"")."";


    362. 

  362. 						break;


    363. 

  363. 					case 'email':


    364. 

  364. 						$sql="SELECT id_customer,date_upd FROM "._DB_PREFIX_."customer WHERE email='".pSQL(findCSVLineValue('email'))."' ".((SCMS)?" AND id_shop='".(int)$id_shop."'":"")."";


    365. 

  365. 						break;


    366. 

  366. 					case 'idcustomeradresse':


    367. 

  367. 						$sql="SELECT id_customer,date_upd FROM "._DB_PREFIX_."customer WHERE id_customer='".intval(findCSVLineValue('id_customer'))."' ".((SCMS)?" AND id_shop='".(int)$id_shop."'":"")."";


    368. 

  368. 						break;


    369. 

  369. 					case 'emailadresse':


    370. 

  370. 						$sql="SELECT id_customer,date_upd FROM "._DB_PREFIX_."customer WHERE email='".pSQL(findCSVLineValue('email'))."' ".((SCMS)?" AND id_shop='".(int)$id_shop."'":"")."";


    371. 

  371. 						break;


    372. 

  372. 					case 'idcustomeridadresse':


    373. 

  373. 						$sql="SELECT id_customer,date_upd FROM "._DB_PREFIX_."customer WHERE id_customer='".intval(findCSVLineValue('id_customer'))."' ".((SCMS)?" AND id_shop='".(int)$id_shop."'":"")."";


    374. 

  374. 						break;


    375. 

  375. 					case 'emailidadresse':


    376. 

  376. 						$sql="SELECT id_customer,date_upd FROM "._DB_PREFIX_."customer WHERE email='".pSQL(findCSVLineValue('email'))."' ".((SCMS)?" AND id_shop='".(int)$id_shop."'":"")."";


    377. 

  377. 						break;


    378. 

  378. 					/*case 'specialIdentifier':


    379. 

  379. 						sc_ext::readImportCSVConfigXML('importProcessIdentifier');


    380. 

  380. 						break;*/


    381. 

  381. 				}


    382. 

  382. 				$res=Db::getInstance()->getRow($sql);


    383. 

  383. 				if (is_array($res) && count($res))


    384. 

  384. 				{


    385. 

  385. 					$id_customer=$res['id_customer'];


    386. 

  386. 				}else{


    387. 

  387. 					$id_customer=0;


    388. 

  388. 				}


    389. 

  389. 				


    390. 

  390. 				$id_address = 0;


    391. 

  391. 				if(!empty($id_customer))


    392. 

  392. 				{


    393. 

  393. 					$sql_address = "";


    394. 

  394. 					switch($importConfig[$TODOfilename]['idby'])


    395. 

  395. 					{


    396. 

  396. 						case 'idcustomeradresse':


    397. 

  397. 							$sql_address="SELECT id_address,date_upd FROM "._DB_PREFIX_."address WHERE id_customer='".intval($id_customer)."' AND LOWER(alias)='".pSQL(mb_strtolower(findCSVLineValue('address_title'), ($importConfig[$TODOfilename]['utf8']?'UTF-8':'')))."'";


    398. 

  398. 							break;


    399. 

  399. 						case 'emailadresse':


    400. 

  400. 							$sql_address="SELECT id_address,date_upd FROM "._DB_PREFIX_."address WHERE id_customer='".intval($id_customer)."' AND LOWER(alias)='".pSQL(mb_strtolower(findCSVLineValue('address_title'), ($importConfig[$TODOfilename]['utf8']?'UTF-8':'')))."'";


    401. 

  401. 							break;


    402. 

  402. 						case 'idcustomeridadresse':


    403. 

  403. 							$sql_address="SELECT id_address,date_upd FROM "._DB_PREFIX_."address WHERE id_customer='".intval($id_customer)."' AND id_address='".intval(findCSVLineValue('id_address'))."'";


    404. 

  404. 							break;


    405. 

  405. 						case 'emailidadresse':


    406. 

  406. 							$sql_address="SELECT id_address,date_upd FROM "._DB_PREFIX_."address WHERE id_customer='".intval($id_customer)."' AND id_address='".intval(findCSVLineValue('id_address'))."'";


    407. 

  407. 							break;


    408. 

  408. 					}


    409. 

  409. 					if(!empty($sql_address))


    410. 

  410. 					{


    411. 

  411. 						$res_address=Db::getInstance()->getRow($sql_address);


    412. 

  412. 						if (is_array($res_address) && count($res_address))


    413. 

  413. 						{


    414. 

  414. 							$id_address=$res_address['id_address'];


    415. 

  415. 						}


    416. 

  416. 					}


    417. 

  417. 				}


    418. 

  418. 				


    419. 

  419. 				if ($scdebug) echo findCSVLineValue('email').' : '.$id_customer.'<br/>';


    420. 

  420. 				if ($scdebug) echo 'a';


    421. 

  421. 


    422. 

  422. 				if ($CRON && isset($CRON_OLDERTHAN) && $CRON_OLDERTHAN > 0)


    423. 

  423. 				{


    424. 

  424. 					$date_upd=strtotime($res['date_upd']);


    425. 

  425. 					$nowres=Db::getInstance()->getRow('SELECT UNIX_TIMESTAMP() AS ut');


    426. 

  426. 					$now=($nowres ? $nowres['ut'] : 0);


    427. 

  427. 					if (($date_upd > ($now - ((int)$CRON_OLDERTHAN * 60)))) // if not a recent updated object...


    428. 

  428. 					{


    429. 

  429. 						$stats['skipped']++;


    430. 

  430. 						$importlimit++; // on suppose que tous les éléments ont été créés en BDD : le cron ne sert que pour mettre à jour stock et/ou prix


    431. 

  431. 						continue;


    432. 

  432. 					}


    433. 

  433. 				}


    434. 

  434. 				


    435. 

  435. 				if ($importConfig[$TODOfilename]['iffoundindb']=='skip' && $id_customer)


    436. 

  436. 				{


    437. 

  437. 					$stats['skipped']++;


    438. 

  438. 					if (_s('CAT_IMPORT_IGNORED_LINES')==1)


    439. 

  439. 					{


    440. 

  440. 						unset($CSVData[$current_line]);


    441. 

  441. 						$needSaveTODO=true;


    442. 

  442. 					}


    443. 

  443. 					// ne pas augmenter la limite totale car les prochaines lignes n'ont pas été analysées et donc des éléments peuvent manquer.


    444. 

  444. 					//$importlimit++;


    445. 

  445. 					continue;


    446. 

  446. 				}


    447. 

  447. 				elseif ($importConfig[$TODOfilename]['iffoundindb']=='replace' && $id_customer)


    448. 

  448. 				{


    449. 

  449. 					//in_array($importConfig[$TODOfilename]['idby'],array('idcustomeradresse','emailadresse','idcustomeridadresse','emailidadresse')) || 


    450. 

  450. 					if(hasAddress())


    451. 

  451. 					{


    452. 

  452. 						if(!empty($id_address))


    453. 

  453. 							$newaddress=new Address($id_address);


    454. 

  454. 						else


    455. 

  455. 						{


    456. 

  456. 							$newaddress=new Address();


    457. 

  457. 							$newaddress->id_customer=$id_customer;


    458. 

  458. 							$newaddress->active=1;


    459. 

  459. 							$newaddress->alias=_l('My address');


    460. 

  460. 						}


    461. 

  461. 					}


    462. 

  462. 					


    463. 

  463. 					if (SCMS)


    464. 

  464. 					{


    465. 

  465. 						$newcustomer=new Customer($id_customer, null, $id_shop);


    466. 

  466. 					}else{


    467. 

  467. 						$newcustomer=new Customer($id_customer);


    468. 

  468. 					}


    469. 

  469. 					$stats['modified']++;


    470. 

  470. 				}


    471. 

  471. 				elseif ($importConfig[$TODOfilename]['iffoundindb']=='replaceonly')


    472. 

  472. 				{


    473. 

  473. 					$skip=false;


    474. 

  474. 					


    475. 

  475. 					if(!empty($id_customer))


    476. 

  476. 					{


    477. 

  477. 						if(hasAddress())


    478. 

  478. 						{


    479. 

  479. 							if(!empty($id_address))


    480. 

  480. 								$newaddress=new Address($id_address);


    481. 

  481. 							else


    482. 

  482. 								$skip = true;


    483. 

  483. 						}


    484. 

  484. 					}


    485. 

  485. 					else


    486. 

  486. 						$skip=true;


    487. 

  487. 						


    488. 

  488. 					if($skip)


    489. 

  489. 					{


    490. 

  490. 						$stats['skipped']++;


    491. 

  491. 						if (_s('CAT_IMPORT_IGNORED_LINES')==1)


    492. 

  492. 						{


    493. 

  493. 							unset($CSVData[$current_line]);


    494. 

  494. 							$needSaveTODO=true;


    495. 

  495. 						}


    496. 

  496. 						// ne pas augmenter la limite totale car les prochaines lignes n'ont pas été analysées et donc des éléments peuvent manquer.


    497. 

  497. 						//$importlimit++;


    498. 

  498. 						continue;


    499. 

  499. 					}


    500. 

  500. 					else


    501. 

  501. 					{


    502. 

  502. 						if (SCMS)


    503. 

  503. 						{


    504. 

  504. 							$newcustomer=new Customer($id_customer, null, $id_shop);


    505. 

  505. 						}else{


    506. 

  506. 							$newcustomer=new Customer($id_customer);


    507. 

  507. 						}


    508. 

  508. 						$stats['modified']++;


    509. 

  509. 					}


    510. 

  510. 				}else{


    511. 

  511. 					$email = findCSVLineValue('email');


    512. 

  512. 					if(empty($email))


    513. 

  513. 						die(_l('Email can\'t be empty to create a customer: line n°').' '.$current_line);


    514. 

  514. 					// create new customer with default values


    515. 

  515. 					$newcustomer=new Customer();


    516. 

  516. 					$newcustomer->active=0;


    517. 

  517. 					$newcustomer->firstname=_l("Firstname");


    518. 

  518. 					$newcustomer->lastname=_l("Lastname");


    519. 

  519. 					$newcustomer->email=$email;


    520. 

  520. 					$newcustomer->passwd="password";


    521. 

  521. 					if(SCMS)


    522. 

  522. 						$newcustomer->id_shop=$id_shop;


    523. 

  523. 					


    524. 

  524. 					if(hasAddress())


    525. 

  525. 					{


    526. 

  526. 						$newaddress=new Address();


    527. 

  527. 						$newaddress->active=1;


    528. 

  528. 						$newaddress->alias=_l('My address');


    529. 

  529. 					}


    530. 

  530. 					


    531. 

  531. 					$stats['created']++;


    532. 

  532. 				}


    533. 

  533. 				


    534. 

  534. 				if ($scdebug) echo 'b';


    535. 

  535. 				foreach($line AS $key => $value)


    536. 

  536. 				{


    537. 

  537. 					$value=trim($value);


    538. 

  538. 					$GLOBALS['import_value']=$value;


    539. 

  539. 					if ($scdebug && !sc_array_key_exists($key,$firstLineData)) echo 'ERR'.$key.'x'.$current_line.'x'.join(';',$line).'xxx'.join(';',array_keys($firstLineData)).'<br/>';


    540. 

  540. 					if (sc_array_key_exists($key,$firstLineData) && sc_in_array($firstLineData[$key],$mappingData['CSVArray'],"cusWinImportProcess_CSVArray"))


    541. 

  541. 					{


    542. 

  542. 						if ($scdebug) echo 'c';


    543. 

  543. 						//@$id_lang=intval($getIDlangByISO[$mappingData['CSV2DBOptions'][$firstLineData[$key]]]);


    544. 

  544. 						$switchObject=$mappingData['CSV2DB'][$firstLineData[$key]];


    545. 

  545. 						switch($switchObject)


    546. 

  546. 						{


    547. 

  547. 							// CUSTOMER


    548. 

  548. 							case 'company':$newcustomer->company=psql($value);break;


    549. 

  549. 							case 'siret':$newcustomer->siret=psql($value);break;


    550. 

  550. 							case 'ape':$newcustomer->ape=psql($value);break;


    551. 

  551. 							case 'firstname':$newcustomer->firstname=psql($value);break;


    552. 

  552. 							case 'lastname':$newcustomer->lastname=psql($value);break;


    553. 

  553. 							case 'email':$newcustomer->email=psql($value);break;


    554. 

  554. 							case 'passwd':$newcustomer->passwd=psql(Tools::encrypt($value));break;


    555. 

  555. 							case 'birthday':$newcustomer->birthday=psql(importConv2Date($value));break;


    556. 

  556. 							case 'date_add':$newcustomer->date_add=psql(importConv2Date($value));break;


    557. 

  557. 							case 'newsletter':$newcustomer->newsletter=intval(getBoolean($value));break;


    558. 

  558. 							case 'optin':$newcustomer->optin=intval(getBoolean($value));break;


    559. 

  559. 							case 'website':$newcustomer->website=psql($value);break;


    560. 

  560. 							case 'active':$newcustomer->active=intval(getBoolean($value));break;


    561. 

  561. 							case 'note':$newcustomer->note=psql($value);break;


    562. 

  562. 							case 'id_gender':


    563. 

  563. 								$gender = mb_strtolower($value, ($importConfig[$TODOfilename]['utf8']?'UTF-8':''));


    564. 

  564. 								if(!empty($all_genders[$gender]))


    565. 

  565. 									$newcustomer->id_gender=(int)$all_genders[$gender];


    566. 

  566. 							break;


    567. 

  567. 							case 'id_default_group':


    568. 

  568. 								$group = mb_strtolower($value, ($importConfig[$TODOfilename]['utf8']?'UTF-8':''));


    569. 

  569. 								if(!empty($all_groups[$group]))


    570. 

  570. 									$newcustomer->id_default_group=(int)$all_groups[$group];


    571. 

  571. 								else


    572. 

  572. 								{


    573. 

  573. 									if(!is_numeric($value))


    574. 

  574. 									{


    575. 

  575. 										$newGroup = new Group();


    576. 

  576. 										$newGroup->name = $value;


    577. 

  577. 										$newGroup->price_display_method = 0;


    578. 

  578. 										$newGroup->save();


    579. 

  579. 										


    580. 

  580. 										$all_groups[$group]=$newGroup->id;


    581. 

  581. 										


    582. 

  582. 										$newcustomer->id_default_group=(int)$all_groups[$group];


    583. 

  583. 										$stats['group_created']++;


    584. 

  584. 									}


    585. 

  585. 								}


    586. 

  586. 							break;


    587. 

  587. 							


    588. 

  588. 							// ADDRESS


    589. 

  589. 							case 'address_title':$newaddress->alias=psql($value);break;


    590. 

  590. 							case 'address_country':


    591. 

  591. 								$country = mb_strtolower($value, ($importConfig[$TODOfilename]['utf8']?'UTF-8':''));


    592. 

  592. 								if (sc_array_key_exists($country, $all_countries))


    593. 

  593. 									$newaddress->id_country=(int)$all_countries[$country];


    594. 

  594. 							break;


    595. 

  595. 							case 'address_state':


    596. 

  596. 								$state = mb_strtolower($value, ($importConfig[$TODOfilename]['utf8']?'UTF-8':''));


    597. 

  597. 								if(!empty($all_states[$state]))


    598. 

  598. 									$newaddress->id_state=(int)$all_states[$state];


    599. 

  599. 							break;


    600. 

  600. 							case 'address_company':$newaddress->company=psql($value);break;


    601. 

  601. 							case 'address_lastname':$newaddress->lastname=psql($value);break;


    602. 

  602. 							case 'address_firstname':$newaddress->firstname=psql($value);break;


    603. 

  603. 							case 'address_1':$newaddress->address1=psql($value);break;


    604. 

  604. 							case 'address_2':$newaddress->address2=psql($value);break;


    605. 

  605. 							case 'address_postcode':$newaddress->postcode=psql($value);break;


    606. 

  606. 							case 'address_city':$newaddress->city=psql($value);break;


    607. 

  607. 							case 'address_other':$newaddress->other=psql($value);break;


    608. 

  608. 							case 'address_phone':$newaddress->phone=psql($value);break;


    609. 

  609. 							case 'address_phonemobile':$newaddress->phone_mobile=psql($value);break;


    610. 

  610. 							


    611. 

  611. 							// ACTIONS


    612. 

  612. 							case 'ActionDeleteAllCustomers':


    613. 

  613. 								if (getBoolean($value))


    614. 

  614. 								{


    615. 

  615. 									$sql = "SELECT id_customer FROM "._DB_PREFIX_."customer WHERE deleted!=1";


    616. 

  616. 									$all_customers = Db::getInstance()->ExecuteS($sql);


    617. 

  617. 									foreach($all_customers as $customer_id)


    618. 

  618. 									{


    619. 

  619. 										$customer_id = $customer_id["id_customer"];


    620. 

  620. 										$customer = new Customer((int)$customer_id);


    621. 

  621. 										


    622. 

  622. 										if (count(Order::getCustomerOrders((int)$customer_id))==0)


    623. 

  623. 											$customer->delete();


    624. 

  624. 										else


    625. 

  625. 										{


    626. 

  626. 											$customer->deleted=1;


    627. 

  627. 											$customer->save();


    628. 

  628. 										}


    629. 

  629. 									}


    630. 

  630. 								}


    631. 

  631. 							break;


    632. 

  632. 							case 'ActionDeleteAllAddresses':


    633. 

  633. 								if (getBoolean($value))


    634. 

  634. 								{


    635. 

  635. 									$sql = "SELECT id_address FROM "._DB_PREFIX_."address WHERE deleted!=1";


    636. 

  636. 									$all_addresses = Db::getInstance()->ExecuteS($sql);


    637. 

  637. 									foreach($all_addresses as $address_id)


    638. 

  638. 									{


    639. 

  639. 										$address_id = $address_id["id_address"];


    640. 

  640. 										$address = new Address((int)$address_id);


    641. 

  641. 										$address->delete();


    642. 

  642. 									}


    643. 

  643. 								}


    644. 

  644. 							break;


    645. 

  645. 							case 'ActionRegenerateAllPasswords':


    646. 

  646. 								if (getBoolean($value))


    647. 

  647. 								{


    648. 

  648. 									$sql = "SELECT id_customer FROM "._DB_PREFIX_."customer WHERE deleted!=1";


    649. 

  649. 									$all_customers = Db::getInstance()->ExecuteS($sql);


    650. 

  650. 									foreach($all_customers as $customer_id)


    651. 

  651. 									{


    652. 

  652. 										$customer_id = $customer_id["id_customer"];


    653. 

  653. 										$customer = new Customer((int)$customer_id);


    654. 

  654. 										$customer->passwd = Tools::encrypt(randomPassword());


    655. 

  655. 										$customer->save();


    656. 

  656. 									}


    657. 

  657. 								}


    658. 

  658. 							break;


    659. 

  659. 							


    660. 

  660. 							//case 'date_add':$TODO[]="UPDATE "._DB_PREFIX_."product SET date_add='".psql($value)."' WHERE id_customer=ID_PRODUCT";break;


    661. 

  661. 							//default:


    662. 

  662. 								//sc_ext::readImportCSVConfigXML('importProcessProduct');


    663. 

  663. 						}


    664. 

  664. 					}


    665. 

  665. 				}


    666. 

  666. 				


    667. 

  667. 				if ($scdebug) echo 'd';


    668. 

  668. 				$newcustomer->date_upd=date("Y-m-d H:i:s");


    669. 

  669. 				if ($newcustomer->save())


    670. 

  670. 				{


    671. 

  671. 					$lastid_customer=$newcustomer->id;


    672. 

  672. 					if ($scdebug) echo 'e';


    673. 

  673. 					


    674. 

  674. 					foreach($TODO AS $sql)


    675. 

  675. 					{


    676. 

  676. 						$sql=str_replace('ID_PRODUCT',$newcustomer->id,$sql);


    677. 

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


    678. 

  678. 					}


    679. 

  679. 


    680. 

  680. 					// SAVE ADDRESS


    681. 

  681. 					if(hasAddress())


    682. 

  682. 					{


    683. 

  683. 						$newaddress->id_customer = $lastid_customer;


    684. 

  684. 						if(empty($newaddress->firstname))


    685. 

  685. 							$newaddress->firstname = $newcustomer->firstname;


    686. 

  686. 						if(empty($newaddress->lastname))


    687. 

  687. 							$newaddress->lastname = $newcustomer->lastname;


    688. 

  688. 						if($newaddress->id_country == 0 || !$newaddress->save())


    689. 

  689. 						{


    690. 

  690. 							echo _l('The customer has been imported but there is a problem with his address.').'<br/>';


    691. 

  691. 							echo _l('You need to check these fields on the first line of').' '.$TODOfilename._l(':').' alias, lastname, firstname, address1, city, country<br/>';


    692. 

  692. 							echo _l('More information about the address')._l(':').'<br/>';


    693. 

  693. 							var_dump($newaddress);


    694. 

  694. 							exit;


    695. 

  695. 						}


    696. 

  696. 					}


    697. 

  697. 					


    698. 

  698. 					// ADD IN GROUPS


    699. 

  699. 					$name_groups = findCSVLineValue("groups");


    700. 

  700. 					if(sc_in_array("groups",$mappingData['DBArray'],"cusWinImportProcess_DBArray") && !empty($name_groups))


    701. 

  701. 					{


    702. 

  702. 						$temp_groups = array();


    703. 

  703. 						$groups = explode($importConfig[$TODOfilename]['valuesep'], $name_groups);


    704. 

  704. 						foreach($groups as $value)


    705. 

  705. 						{


    706. 

  706. 							$group = mb_strtolower($value, ($importConfig[$TODOfilename]['utf8']?'UTF-8':''));


    707. 

  707. 							if(!empty($all_groups[$group]))


    708. 

  708. 								$temp_groups[]=(int)$all_groups[$group];


    709. 

  709. 							else


    710. 

  710. 							{


    711. 

  711. 								if(!is_numeric($value))


    712. 

  712. 								{


    713. 

  713. 									$newGroup = new Group();


    714. 

  714. 									$newGroup->name = $value;


    715. 

  715. 									$newGroup->price_display_method = 0;


    716. 

  716. 									$newGroup->save();


    717. 

  717. 							


    718. 

  718. 									$all_groups[$group]=$newGroup->id;


    719. 

  719. 							


    720. 

  720. 									$temp_groups[]=(int)$all_groups[$group];


    721. 

  721. 									$stats['group_created']++;


    722. 

  722. 								}


    723. 

  723. 							}


    724. 

  724. 						}


    725. 

  725. 						if(!empty($temp_groups))


    726. 

  726. 							$newcustomer->updateGroup($temp_groups);


    727. 

  727. 					}


    728. 

  728. 					


    729. 

  729. 					unset($CSVData[$current_line]);


    730. 

  730. 					file_put_contents(SC_CSV_IMPORT_DIR."customers/".$TODOfilename,join("\n",$CSVData));


    731. 

  731. 					$needSaveTODO=false;


    732. 

  732. 				}


    733. 

  733. 			}


    734. 

  734.           		


    735. 

  735. 			if ($needSaveTODO)


    736. 

  736. 				file_put_contents(SC_CSV_IMPORT_DIR."customers/".$TODOfilename,join("\n",$CSVData));


    737. 

  737. 			echo '<b>'._l('Stats:').'</b><br/>';


    738. 

  738. 			$msg = _l('New customers:').' '.$stats['created'].'<br/>';


    739. 

  739. 			$msg.= _l('Modified customers:').' '.$stats['modified'].'<br/>';


    740. 

  740. 			$msg.= _l('Skipped lines:').' '.$stats['skipped'].'<br/>';


    741. 

  741. 			if(!empty($stats['group_created']))


    742. 

  742. 			$msg.= _l('New groups:').' '.$stats['group_created'].'<br/>';


    743. 

  743. 			echo $msg.'<br/>';


    744. 

  744. 			


    745. 

  745. 			if ((count($CSVData)==1) || (count($CSVData)==2 && $CSVData[0]==join('',$CSVData)) || (filesize(SC_CSV_IMPORT_DIR."customers/".$TODOfilename)==0))


    746. 

  746. 			{


    747. 

  747. 				@unlink(SC_CSV_IMPORT_DIR."customers/".$TODOfilename);


    748. 

  748. 				echo _l('All customers have been imported. The TODO file is deleted.').'<br/><br/>';


    749. 

  749. 				echo '<b>'._l('End of import process.').'</b><br/><br/>';


    750. 

  750. 				echo '<b>'._l('You need to refresh the page, click here:').' <a target="_top" href="index.php">Go!</a></b><br/>';


    751. 

  751. 				echo '<script type="text/javascript">window.top.displayOptionsCus();window.top.stopAutoImportCus(true);</script>';


    752. 

  752. 				$msg2 = 'All customers have been imported.';


    753. 

  753. 			}else{


    754. 

  754. 				echo '<b>'._l('There are still customers to be imported in the working file. It can mean errors you need to correct or lines which have been ignored on purpose. Once corrections have been made, click again on the import icon to proceed further.').'</b><br/><br/>';


    755. 

  755. 				echo '<script type="text/javascript">window.top.displayOptionsCus();window.top.prepareNextStepCus('.($stats['created']+$stats['modified']+$stats['skipped']==0?0:filesize(SC_CSV_IMPORT_DIR."customers/".$TODOfilename)).');</script>';


    756. 

  756. 				$msg2 = 'Need fix and run import again.';


    757. 

  757. 			}


    758. 

  758. 			$msg3='';


    759. 

  759. 			if ($CRON)


    760. 

  760. 			{


    761. 

  761. 				$msg3 .= _l('CRON task name')._l(':').' '.$CRON_NAME.'<br/>';


    762. 

  762. 				$msg3 .= ( isset($CRON_DELETETODO) && $CRON_DELETETODO ? $TODOfilename.' '._l('deleted').'<br/>':'');


    763. 

  763. 				$msg3 .= _l('Update customers older than').' '.$CRON_OLDERTHAN;


    764. 

  764. 			}


    765. 

  765. 			addToHistory('customer_import','import','','','','','Imported file: '.$TODOfilename.'<br/>'.$msg.$msg2.($msg3!=''?'<br/>'.$msg3:''),'');


    766. 

  766. 			break;


    767. 

  767. 		}


    768. 

  768.