/WEBCRUD/controleur/R-CRUD_import_partie_order.php

https://gitlab.com/ptisky/API_prestashop · PHP · 242 lines · 61 code · 31 blank · 150 comment · 6 complexity · 911415a8de0ee8d5a7e00b291e0d133c MD5 · raw file 

    

  1. <?php
    2. 

  2. try{
    3. 

  3. $bdd = new PDO('mysql:host=localhost;dbname=prestashop;charset=utf8', 'root', '');
    4. 

  4. }
    5. 

  5. catch (Exception $e)
    6. 

  6. {
    7. 

  7.         die('Erreur : ' . $e->getMessage());
    8. 

  8. }
    9. 

  9. 

  10. 	    //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    11. 

  11. 	   //																																			  ///////
    12. 

  12. 	  //-----------------------------------------------------------// PARTIE PRESTASHOP //-----------------------------------------------------------///////
    13. 

  13. 	 //																																				///////
    14. 

  14. 	//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    15. 

  15. 	
    16. 

  16. 				//connection de l'api au webservice
    17. 

  17. 				include("connection.php");
    18. 

  18. 				
    19. 

  19. 					//on recupere le fichier xml
    20. 

  20. 					$get_xml_orders = simplexml_load_file("orders.xml");	
    21. 

  21. 					$get_xml_carts = simplexml_load_file("carts.xml");	
    22. 

  22. 	
    23. 

  23. 	//-----------------------------------------------// CUSTOMER //---------------------------------//
    24. 

  24. 	foreach ($get_xml_orders->children()->children() as $ressources_cart)
    25. 

  25. 	{
    26. 

  26. 		try {
    27. 

  27. 				$webService = new PrestaShopWebservice(PS_SHOP_PATH, PS_WS_AUTH_KEY, DEBUG); //connection
    28. 

  28. 				$xml_cart = $webService->get(array('url' => PS_SHOP_PATH.'/api/carts?schema=synopsis'));//on recupere un shemas blanc xml
    29. 

  29. 							
    30. 

  30. 				$opt_customers['resource'] = 'customers';
    31. 

  31. 				$xml_customers = $webService->get($opt_customers);
    32. 

  32. 				$resources_customer_id = $xml_customers->children()->children()->id;
    33. 

  33. 

  34. 				$opt_addresses['resource'] = 'addresses';
    35. 

  35. 				$xml_address = $webService->get($opt_addresses);
    36. 

  36. 				$resources_address_id = $xml_address->children()->children()->id;
    37. 

  37. 

  38. 				$opt_currencies['resource'] = 'currencies';
    39. 

  39. 				$xml_currency = $webService->get($opt_currencies);
    40. 

  40. 				$resources_currency_id = $xml_currency->children()->children()->id;	
    41. 

  41. 

  42. 				$opt_languages['resource'] = 'languages';
    43. 

  43. 				$xml_lang = $webService->get($opt_languages);
    44. 

  44. 				$resources_lang_id = $xml_lang->children()->children()->id;
    45. 

  45. 

  46. 				$opt_carriers['resource'] = 'carriers';
    47. 

  47. 				$xml_carrier = $webService->get($opt_carriers);
    48. 

  48. 				$resources_carrier_id = $xml_carrier->children()->children()->id;
    49. 

  49. 

  50. 				$opt_products['resource'] = 'products';
    51. 

  51. 				$xml_product = $webService->get($opt_products);
    52. 

  52. 				$resources_product_id = $xml_product->children()->children()->id;	
    53. 

  53. 				$resources_product_quantity = $xml_product->children()->children()->quantity;	
    54. 

  54. 

  55. 				while($xml_customers->children()->children()->outstanding_allow_amount > 0)
    56. 

  56. 				{
    57. 

  57. 						
    58. 

  58. 						$xml_cart->cart->id_customer = $resources_customer_id;
    59. 

  59. 						$xml_cart->cart->id_address_delivery = $resources_address_id;
    60. 

  60. 						$xml_cart->cart->id_address_invoice = $resources_address_id;
    61. 

  61. 						$xml_cart->cart->id_currency = $resources_currency_id;
    62. 

  62. 						$xml_cart->cart->id_lang = $resources_lang_id;
    63. 

  63. 						$xml_cart->cart->id_carrier = $resources_carrier_id;
    64. 

  64. 						
    65. 

  65. 						$xml_cart->cart->associations->cart_rows->cart_row->id_product = $resources_product_id;
    66. 

  66. 						$xml_cart->cart->associations->cart_rows->cart_row->quantity = $resources_product_quantity;
    67. 

  67. 						
    68. 

  68. 						
    69. 

  69. 						$opt_orders = array('resource' => 'carts');
    70. 

  70. 						$opt_orders['postXml'] = $xml_cart->asXML();
    71. 

  71. 

  72. 						// var_dump($opt);
    73. 

  73. 						
    74. 

  74. 						//envoie le xml a prestashop
    75. 

  75. 						$xml_orders = $webService->add($opt_orders);
    76. 

  76. 

  77. 						$monid_orders = $xml_orders->customer->id;//récupere l'id inséré dans prestashop par auto increment
    78. 

  78. 						$bdd->query('UPDATE `prestashop`.`ps_order` SET `id_order` = '.$id_orders.' WHERE `ps_order`.`id_order` = '.$monid_orders.'');//envoie la nouvelle id				
    79. 

  79. 				}	
    80. 

  80. 			}
    81. 

  81. 			catch (PrestaShopWebserviceException $e)
    82. 

  82. 			{
    83. 

  83. 			  // Here we are dealing with errors
    84. 

  84. 			  $trace = $e->getTrace();
    85. 

  85. 			  if ($trace[0]['args'][0] == 404) echo 'Bad ID';
    86. 

  86. 			  else if ($trace[0]['args'][0] == 401) echo 'Bad auth key';
    87. 

  87. 			  else echo 'Other error<br />'.$e->getMessage();
    88. 

  88. 			}
    89. 

  89. 	}
    90. 

  90. 

  91. 	
    92. 

  92. 	// foreach ($get_xml_orders->children()->children() as $ressources_orders)
    93. 

  93. 	// {
    94. 

  94. 		// try {
    95. 

  95. 				// $webService = new PrestaShopWebservice(PS_SHOP_PATH, PS_WS_AUTH_KEY, DEBUG); //connection
    96. 

  96. 				// $xml_orders = $webService->get(array('url' => PS_SHOP_PATH.'/api/orders?schema=synopsis'));//on recupere un shemas blanc xml
    97. 

  97. 

  98. 

  99. 				// données obligatoires dans mon xml	
    100. 

  100. 				// $id_orders 					         					= $ressources_orders->id;
    101. 

  101. 				// $id_address_delivery_orders  					        = $ressources_orders->id_address_delivery;
    102. 

  102. 				// $id_address_invoice_orders  					        = $ressources_orders->id_address_invoice;
    103. 

  103. 				// $id_cart_orders  					         			= $ressources_orders->id_cart;
    104. 

  104. 				// $id_currency_orders  					         		= $ressources_orders->id_currency;
    105. 

  105. 				// $id_lang_orders 		 			         			= $ressources_orders->id_lang;
    106. 

  106. 				// $id_customer_orders 					         		= $ressources_orders->id_customer;
    107. 

  107. 				// $id_carrier_orders 					         			= $ressources_orders->id_carrier;
    108. 

  108. 				// $current_state_orders 					         		= $ressources_orders->current_state;
    109. 

  109. 				// $module_orders 					         				= $ressources_orders->module;
    110. 

  110. 				// $invoice_number_orders 					         		= $ressources_orders->invoice_number;
    111. 

  111. 				// $invoice_date_orders 					         		= $ressources_orders->invoice_date;
    112. 

  112. 				// $delivery_number_orders 					         	= $ressources_orders->delivery_number;
    113. 

  113. 				// $delivery_date_orders 					         		= $ressources_orders->delivery_date;
    114. 

  114. 				// $valid_orders 					         				= $ressources_orders->valid;
    115. 

  115. 				// $date_add_orders 					         			= $ressources_orders->date_add;
    116. 

  116. 				// $date_upd_orders 					         			= $ressources_orders->date_upd;
    117. 

  117. 				// $shipping_number_orders 					         	= $ressources_orders->shipping_number;
    118. 

  118. 				// $id_shop_group_orders 					         		= $ressources_orders->id_shop_group;
    119. 

  119. 				// $id_shop_orders 					         			= $ressources_orders->id_shop;
    120. 

  120. 				// $secure_key_orders 					         			= $ressources_orders->secure_key;
    121. 

  121. 				// $payment_orders 					         			= $ressources_orders->payment;
    122. 

  122. 				// $recyclable_orders 					         			= $ressources_orders->recyclable;
    123. 

  123. 				// $gift_orders 					         				= $ressources_orders->gift;
    124. 

  124. 				// $gift_message_orders 					         		= $ressources_orders->gift_message;
    125. 

  125. 				// $mobile_theme_orders 					         		= $ressources_orders->mobile_theme;
    126. 

  126. 				// $total_discounts_orders 					         	= $ressources_orders->total_discounts;
    127. 

  127. 				// $total_discounts_tax_incl_orders 					    = $ressources_orders->total_discounts_tax_incl;
    128. 

  128. 				// $total_discounts_tax_excl_orders 					    = $ressources_orders->total_discounts_tax_excl;
    129. 

  129. 				// $total_paid_orders 					         			= $ressources_orders->total_paid;
    130. 

  130. 				// $total_paid_tax_incl_orders 					        = $ressources_orders->total_paid_tax_incl;
    131. 

  131. 				// $total_paid_tax_excl_orders 					        = $ressources_orders->total_paid_tax_excl;
    132. 

  132. 				// $total_paid_real_orders 					         	= $ressources_orders->total_paid_real;
    133. 

  133. 				// $total_products_orders 					         		= $ressources_orders->total_products;
    134. 

  134. 				// $total_products_wt_orders 					         	= $ressources_orders->total_products_wt;
    135. 

  135. 				// $total_shipping_orders 					         		= $ressources_orders->total_shipping;
    136. 

  136. 				// $total_shipping_tax_incl_orders 					    = $ressources_orders->total_shipping_tax_incl;
    137. 

  137. 				// $total_shipping_tax_excl_orders 					    = $ressources_orders->total_shipping_tax_excl;
    138. 

  138. 				// $carrier_tax_rate_orders 					         	= $ressources_orders->carrier_tax_rate;
    139. 

  139. 				// $total_wrapping_orders 					         		= $ressources_orders->total_wrapping;
    140. 

  140. 				// $total_wrapping_tax_incl_orders 					    = $ressources_orders->total_wrapping_tax_incl;
    141. 

  141. 				// $total_wrapping_tax_excl_orders 					    = $ressources_orders->total_wrapping_tax_excl;
    142. 

  142. 				// $round_mode_orders 					         			= $ressources_orders->round_mode;
    143. 

  143. 				// $round_type_orders 					         			= $ressources_orders->round_type;
    144. 

  144. 				// $conversion_rate_orders 					         	= $ressources_orders->conversion_rate;
    145. 

  145. 				// $reference_orders 					         			= $ressources_orders->reference;
    146. 

  146. 

  147. 				
    148. 

  148. 				// $xml_orders->order->id_address_delivery  				       	= $id_address_delivery_orders;
    149. 

  149. 				// $xml_orders->order->id_address_invoice  				       	= $id_address_invoice_orders;
    150. 

  150. 				// $xml_orders->order->id_cart  				        	   		= $id_cart_orders;
    151. 

  151. 				// $xml_orders->order->id_currency  				        	   	= $id_currency_orders;
    152. 

  152. 				// $xml_orders->order->id_lang  				        	   		= $id_lang_orders;
    153. 

  153. 				// $xml_orders->order->id_customer  				        	   	= $id_customer_orders;
    154. 

  154. 				// $xml_orders->order->id_carrier  				        	   	= $id_carrier_orders;
    155. 

  155. 				// $xml_orders->order->current_state  				        	   	= $current_state_orders;
    156. 

  156. 				// $xml_orders->order->module  				        	   		= $module_orders;
    157. 

  157. 				// $xml_orders->order->invoice_number  				        	= $invoice_number_orders;
    158. 

  158. 				// $xml_orders->order->invoice_date  				        	   	= $invoice_date_orders;
    159. 

  159. 				// $xml_orders->order->delivery_number  				        	= $delivery_number_orders;
    160. 

  160. 				// $xml_orders->order->delivery_date  				        	   	= $delivery_date_orders;
    161. 

  161. 				// $xml_orders->order->valid  				        	   			= $valid_orders;
    162. 

  162. 				// $xml_orders->order->date_add  				        	   		= $date_add_orders;
    163. 

  163. 				// $xml_orders->order->date_upd  				        	   		= $date_upd_orders;
    164. 

  164. 				// $xml_orders->order->shipping_number  				        	= $shipping_number_orders;
    165. 

  165. 				// $xml_orders->order->id_shop_group  				        	   	= $id_shop_group_orders;
    166. 

  166. 				// $xml_orders->order->id_shop  				        	   		= $id_shop_orders;
    167. 

  167. 				// $xml_orders->order->secure_key  				        	   	= $secure_key_orders;
    168. 

  168. 				// $xml_orders->order->payment  				        	   		= $payment_orders;
    169. 

  169. 				// $xml_orders->order->recyclable  				        	   	= $recyclable_orders;
    170. 

  170. 				// $xml_orders->order->gift  				        	   			= $gift_orders;
    171. 

  171. 				// $xml_orders->order->gift_message  				        	   	= $gift_message_orders;
    172. 

  172. 				// $xml_orders->order->mobile_theme  				        	   	= $mobile_theme_orders;
    173. 

  173. 				// $xml_orders->order->total_discounts  				        	= $total_discounts_orders;
    174. 

  174. 				// $xml_orders->order->total_discounts_tax_incl  				    = $total_discounts_tax_incl_orders;
    175. 

  175. 				// $xml_orders->order->total_discounts_tax_excl  				    = $total_discounts_tax_excl_orders;
    176. 

  176. 				// $xml_orders->order->total_paid  				        	   	= $total_paid_orders;
    177. 

  177. 				// $xml_orders->order->total_paid_tax_incl  				        = $total_paid_tax_incl_orders;
    178. 

  178. 				// $xml_orders->order->total_paid_tax_excl  				        = $total_paid_tax_excl_orders;
    179. 

  179. 				// $xml_orders->order->total_paid_real  				        	= $total_paid_real_orders;
    180. 

  180. 				// $xml_orders->order->total_products  				        	= $total_products_orders;
    181. 

  181. 				// $xml_orders->order->total_products_wt  				        	= $total_products_wt_orders;
    182. 

  182. 				// $xml_orders->order->total_shipping  				        	= $total_shipping_orders;
    183. 

  183. 				// $xml_orders->order->total_shipping_tax_incl  				    = $total_shipping_tax_incl_orders;
    184. 

  184. 				// $xml_orders->order->total_shipping_tax_excl  				    = $total_shipping_tax_excl_orders;
    185. 

  185. 				// $xml_orders->order->carrier_tax_rate  				        	= $carrier_tax_rate_orders;
    186. 

  186. 				// $xml_orders->order->total_wrapping  				        	= $total_wrapping_orders;
    187. 

  187. 				// $xml_orders->order->total_wrapping_tax_incl  				    = $total_wrapping_tax_incl_orders;
    188. 

  188. 				// $xml_orders->order->total_wrapping_tax_excl  				   	= $total_wrapping_tax_excl_orders;
    189. 

  189. 				// $xml_orders->order->round_mode  				        	   	= $round_mode_orders;
    190. 

  190. 				// $xml_orders->order->round_type  				        	   	= $round_type_orders;
    191. 

  191. 				// $xml_orders->order->conversion_rate  				        	= $conversion_rate_orders;
    192. 

  192. 				// $xml_orders->order->reference  				        	   		= $reference_orders;
    193. 

  193. 				
    194. 

  194. 				// foreach ($ressources_orders->associations->order_rows->children() as $ressources_orders_assos)
    195. 

  195. 				// {				
    196. 

  196. 				
    197. 

  197. 					// $id_assos_orders 					         			= $ressources_orders_assos->id;
    198. 

  198. 					// $product_id_assos_orders 					         	= $ressources_orders_assos->product_id;
    199. 

  199. 					// $product_attribute_id_assos_orders  					= $ressources_orders_assos->product_attribute_id;
    200. 

  200. 					// $product_quantity_assos_orders 					        = $ressources_orders_assos->product_quantity;
    201. 

  201. 					// $product_name_assos_orders 					         	= $ressources_orders_assos->product_name;
    202. 

  202. 					// $product_reference_assos_orders 					    = $ressources_orders_assos->product_reference;
    203. 

  203. 					// $product_ean13_assos_orders 					        = $ressources_orders_assos->product_ean13;
    204. 

  204. 					// $product_upc_assos_orders 					         	= $ressources_orders_assos->product_upc;
    205. 

  205. 					// $product_price_assos_orders 					        = $ressources_orders_assos->product_price;
    206. 

  206. 					// $unit_price_tax_incl_assos_orders 					    = $ressources_orders_assos->unit_price_tax_incl;
    207. 

  207. 					// $unit_price_tax_excl_assos_orders 					    = $ressources_orders_assos->unit_price_tax_excl;
    208. 

  208. 					
    209. 

  209. 					// $xml_orders->order->associations->order_rows->order_row->id 					= $id_assos_orders;
    210. 

  210. 					// $xml_orders->order->associations->order_rows->order_row->product_id 			= $product_id_assos_orders;
    211. 

  211. 					// $xml_orders->order->associations->order_rows->order_row->product_attribute_id 	= $product_attribute_id_assos_orders;
    212. 

  212. 					// $xml_orders->order->associations->order_rows->order_row->product_quantity 		= $product_quantity_assos_orders;
    213. 

  213. 					// $xml_orders->order->associations->order_rows->order_row->product_name 			= $product_name_assos_orders;
    214. 

  214. 					// $xml_orders->order->associations->order_rows->order_row->product_reference 		= $product_reference_assos_orders;
    215. 

  215. 					// $xml_orders->order->associations->order_rows->order_row->product_ean13 			= $product_ean13_assos_orders;
    216. 

  216. 					// $xml_orders->order->associations->order_rows->order_row->product_upc 			= $product_upc_assos_orders;
    217. 

  217. 					// $xml_orders->order->associations->order_rows->order_row->product_price 			= $product_price_assos_orders;
    218. 

  218. 					// $xml_orders->order->associations->order_rows->order_row->unit_price_tax_incl 	= $unit_price_tax_incl_assos_orders;
    219. 

  219. 					// $xml_orders->order->associations->order_rows->order_row->unit_price_tax_excl 	= $unit_price_tax_excl_assos_orders;
    220. 

  220. 				// }
    221. 

  221. 				
    222. 

  222. 				// $opt_orders = array('resource' => 'orders');
    223. 

  223. 				// $opt_orders['postXml'] = $xml_orders->asXML();
    224. 

  224. 

  225. 				// var_dump($opt);
    226. 

  226. 				
    227. 

  227. 				// envoie le xml a prestashop
    228. 

  228. 				// $xml_orders = $webService->add($opt_orders);
    229. 

  229. 

  230. 				// $monid_orders = $xml_orders->customer->id;//récupere l'id inséré dans prestashop par auto increment
    231. 

  231. 				// $bdd->query('UPDATE `prestashop`.`ps_order` SET `id_order` = '.$id_orders.' WHERE `ps_order`.`id_order` = '.$monid_orders.'');//envoie la nouvelle id				
    232. 

  232. 			// }	
    233. 

  233. 			// catch (PrestaShopWebserviceException $e)
    234. 

  234. 			// {
    235. 

  235. 			  // Here we are dealing with errors
    236. 

  236. 			  // $trace = $e->getTrace();
    237. 

  237. 			  // if ($trace[0]['args'][0] == 404) echo 'Bad ID';
    238. 

  238. 			  // else if ($trace[0]['args'][0] == 401) echo 'Bad auth key';
    239. 

  239. 			  // else echo 'Other error<br />'.$e->getMessage();
    240. 

  240. 			// }
    241. 

  241. 	// }
    242. 

  242. 		?>
    243.