API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 16th, 2019
283
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 25.34 KB | None | 0 0
raw download clone embed print report
  1. /*Technique pour remplir les tableaux ps_product avec Tarif Fournisseur 2019
  2. Pour comprendre pourquoi ces valeurs sont placé comme ça aller à:
  3. PrestaShop\Word PrestaShop\ps_product.docx
  4. Marche pour la fiche Rogo pour changer de tableau il faut changer $ligneFourniseeur
  5. et les valeurs du switch pour les case 2/3/16/21
  6. */
  7. switch ($ligne) {
  8.  
  9. case 0:
  10. $sheet_test->getActiveSheet()->setCellValue($write, $passage);
  11. break;
  12. case 1:
  13. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  14. break;
  15. case 2:
  16. $vendeur = 0;
  17. $vend = 'J' . $ligneFourniseeur;
  18. //Voir table mySQL ps_manufacturer pour comprendre les ID
  19. switch ($sheetr->getActiveSheet()->getCell($vend)->getValue()) {
  20. case 'Nahita':
  21. $vendeur = 4;
  22. break;
  23. case 'Avignon':
  24. $vendeur = 5;
  25. break;
  26. case 'Jipo':
  27. $vendeur = 6;
  28. break;
  29. case 'Endo Glassware':
  30. $vendeur = 7;
  31. break;
  32. case 'Simax':
  33. $vendeur = 8;
  34. break;
  35. case 'Selecta':
  36. $vendeur = 9;
  37. break;
  38. case 'Kartell':
  39. $vendeur = 10;
  40. break;
  41. case 'VitLab':
  42. $vendeur = 11;
  43. break;
  44. case 'TS':
  45. $vendeur = 12;
  46. break;
  47. case 'Glassco':
  48. $vendeur = 13;
  49. break;
  50. case 'RSG':
  51. $vendeur = 14;
  52. break;
  53. case 'Saint Gobain':
  54. $vendeur = 15;
  55. break;
  56. case 'Filtre RS':
  57. $vendeur = 16;
  58. break;
  59. case 'RS France':
  60. $vendeur = 17;
  61. break;
  62. case 'Zuzi':
  63. $vendeur = 18;
  64. break;
  65. case 'Ghäasel':
  66. $vendeur = 19;
  67. break;
  68. case 'Knittel':
  69. $vendeur = 20;
  70. break;
  71. case 'Anumbra':
  72. $vendeur = 21;
  73. break;
  74. case 'Gilac':
  75. $vendeur = 22;
  76. break;
  77. case 'Agencinox':
  78. $vendeur = 23;
  79. break;
  80. case 'Qualicolor':
  81. $vendeur = 24;
  82. break;
  83. case 'Technosklo':
  84. $vendeur = 25;
  85. break;
  86. case 'Nahita-Blue':
  87. $vendeur = 26;
  88. break;
  89. case 'Orto Alresa':
  90. $vendeur = 27;
  91. break;
  92. case 'RS Lab':
  93. $vendeur = 28;
  94. break;
  95. case 'Ura Technic':
  96. $vendeur = 29;
  97. break;
  98. case 'Socorex':
  99. $vendeur = 30;
  100. break;
  101. case 'Digipette':
  102. $vendeur = 31;
  103. break;
  104. case 'Ratiolab':
  105. $vendeur = 32;
  106. break;
  107. case 'Bomex':
  108. $vendeur = 33;
  109. break;
  110. case 'Gibertini':
  111. $vendeur = 34;
  112. break;
  113. case 'KNF':
  114. $vendeur = 35;
  115. break;
  116. case 'Univet':
  117. $vendeur = 36;
  118. break;
  119. case 'Endo Plasticware':
  120. $vendeur = 37;
  121. break;
  122. case 'Endo Protectlab':
  123. $vendeur = 38;
  124. break;
  125. case 'Plum':
  126. $vendeur = 39;
  127. break;
  128. case 'Emag':
  129. $vendeur = 40;
  130. break;
  131. case 'Preciss Europe':
  132. $vendeur = 41;
  133. break;
  134. default:
  135. $vendeur = 53;
  136. break;
  137.  
  138. }
  139. $sheet_test->getActiveSheet()->setCellValue($write, $vendeur);
  140. break;
  141. case 3:
  142. $category = 0;
  143. $cat = 'D' . $ligneFourniseeur;
  144. //Voir table mySQL ps_category_lang pour comprendre les ID
  145. switch ($sheetr->getActiveSheet()->getCell($cat)->getValue()) {
  146. case 'Mortiers':
  147. $category = 12;
  148. break;
  149. case 'Dessiccateurs':
  150. $category = 13;
  151. break;
  152. case 'Tubes':
  153. $category = 14;
  154. break;
  155. case 'Flacon à vis':
  156. $category = 15;
  157. break;
  158. case 'Portoirs et supports':
  159. $category = 16;
  160. break;
  161. case 'Bouchons':
  162. $category = 17;
  163. break;
  164. case 'Microscopie':
  165. $category = 18;
  166. break;
  167. case 'Microbiologie':
  168. $category = 19;
  169. break;
  170. case 'Bac et plateaux':
  171. $category = 20;
  172. break;
  173. case 'Mobilier':
  174. $category = 21;
  175. break;
  176. case 'Béchers':
  177. $category = 23;
  178. break;
  179. case 'Carafes':
  180. $category = 24;
  181. break;
  182. case 'Fioles':
  183. $category = 25;
  184. break;
  185. case 'Flacons ISO':
  186. $category = 26;
  187. break;
  188. case 'Flacons à vis':
  189. $category = 27;
  190. break;
  191. case 'Flacon à rodage':
  192. $category = 28;
  193. break;
  194. case 'Flacons compte-goutte':
  195. $category = 29;
  196. break;
  197. case 'Flacons laveurs':
  198. $category = 30;
  199. break;
  200. case 'Bidons':
  201. $category = 31;
  202. break;
  203. case 'Flacons':
  204. $category = 32;
  205. break;
  206. case 'Verrerie volumétrique':
  207. $category = 33;
  208. break;
  209. case 'Evaporation':
  210. $category = 34;
  211. break;
  212. case 'Incinération':
  213. $category = 35;
  214. break;
  215. case 'Eprouvettes':
  216. $category = 36;
  217. break;
  218. case 'Fioles jaugées':
  219. $category = 37;
  220. break;
  221. case 'Pipettes graduées':
  222. $category = 38;
  223. break;
  224. case 'Pipettes jaugées':
  225. $category = 39;
  226. break;
  227. case 'Pipettes,autres':
  228. $category = 40;
  229. break;
  230. case 'Burettes':
  231. $category = 41;
  232. break;
  233. case 'Cônes d\'Imhoff':
  234. $category = 42;
  235. break;
  236. case 'Montages':
  237. $category = 43;
  238. break;
  239. case 'Chauffage':
  240. $category = 44;
  241. break;
  242. case 'Tuyauterie et accessoire':
  243. $category = 45;
  244. break;
  245. case 'Spatules/cuillères':
  246. $category = 46;
  247. break;
  248. case 'Matériel à dissection':
  249. $category = 48;
  250. break;
  251. case 'Mono-rotor':
  252. $category = 49;
  253. break;
  254. case 'Minicentrifugeuses':
  255. $category = 50;
  256. break;
  257. case 'Microhématocrite':
  258. $category = 51;
  259. break;
  260. case 'Pour micro-tubes':
  261. $category = 57;
  262. break;
  263. case 'Universelles':
  264. $category = 58;
  265. break;
  266. case 'Grande capacité':
  267. $category = 59;
  268. break;
  269. case 'Microscopes':
  270. $category = 61;
  271. break;
  272. case 'Stéréomicroscopes':
  273. $category = 62;
  274. break;
  275. case 'Caméras vidéo':
  276. $category = 63;
  277. break;
  278. case 'Spectophotomètres':
  279. $category = 64;
  280. break;
  281. case 'Polarimètres':
  282. $category = 65;
  283. break;
  284. case 'Réfractomètres':
  285. $category = 66;
  286. break;
  287. case 'Loupes':
  288. $category = 67;
  289. break;
  290. case 'Etuves':
  291. $category = 69;
  292. break;
  293. case 'Bains':
  294. $category = 70;
  295. break;
  296. case 'Chauffe-ballons':
  297. $category = 71;
  298. break;
  299. case 'Réfrigération/Congélation':
  300. $category = 72;
  301. break;
  302. case 'Balances':
  303. $category = 75;
  304. break;
  305. case 'pH-mètres':
  306. $category = 76;
  307. break;
  308. case 'Conductimètres':
  309. $category = 77;
  310. break;
  311. case 'Thermomètres':
  312. $category = 78;
  313. break;
  314. case 'Temps':
  315. $category = 79;
  316. break;
  317. case 'Densimètres':
  318. $category = 80;
  319. break;
  320. case 'Viscosimètres':
  321. $category = 81;
  322. break;
  323. case 'Agitateurs magnétique':
  324. $category = 83;
  325. break;
  326. case 'Barreaux magnétique':
  327. $category = 84;
  328. break;
  329. case 'Agitateurs vibrateurs':
  330. $category = 85;
  331. break;
  332. case 'Agitateurs multidimensionnels':
  333. $category = 87;
  334. break;
  335. case 'Agitateurs à tige':
  336. $category = 88;
  337. break;
  338. case 'Auxiliaires de pipetage':
  339. $category = 90;
  340. break;
  341. case 'Distributeurs':
  342. $category = 91;
  343. break;
  344. case 'Pointes et autres consommables':
  345. $category = 92;
  346. break;
  347. case 'Seringues':
  348. $category = 93;
  349. break;
  350. case 'Pompes':
  351. $category = 94;
  352. break;
  353. case 'Equipements/pièces en verre':
  354. $category = 96;
  355. break;
  356. case 'Purification d\'eau':
  357. $category = 97;
  358. break;
  359. case 'Evaporateurs rotatifs':
  360. $category = 98;
  361. break;
  362. case 'Système de filtration':
  363. $category = 99;
  364. break;
  365. case 'Creusets filtrants':
  366. $category = 100;
  367. break;
  368. case 'Entonnoirs':
  369. $category = 101;
  370. break;
  371. case 'Ampoules à décanter':
  372. $category = 102;
  373. break;
  374. case 'Papier filtre':
  375. $category = 103;
  376. break;
  377. case 'Filtres seringues':
  378. $category = 104;
  379. break;
  380. case 'Pompes à vide':
  381. $category = 105;
  382. break;
  383. case 'Modèles':
  384. $category = 107;
  385. break;
  386. case 'Préparations microscopiques':
  387. $category = 108;
  388. break;
  389. case 'Physique':
  390. $category = 109;
  391. break;
  392. case 'Blouse de protection':
  393. $category = 110;
  394. break;
  395. case 'Douches et lave-oeil':
  396. $category = 111;
  397. break;
  398. case 'Verrerie Industrielle & Tubing':
  399. $category = 113;
  400. break;
  401. case 'Verrerie à rodage à vis':
  402. $category = 114;
  403. break;
  404. case 'Tubes, boro':
  405. $category = 115;
  406. break;
  407. case 'Capillaires':
  408. $category = 116;
  409. break;
  410. case 'Baguettes':
  411. $category = 117;
  412. break;
  413. case 'Nettoyage et stérilisation':
  414. $category = 119;
  415. break;
  416. case 'Sciences de la vie':
  417. $category = 120;
  418. break;
  419. case 'Préparation d\'échantillons':
  420. $category = 121;
  421. break;
  422. case 'Analyses des eaux, aliments':
  423. $category = 122;
  424. break;
  425. case 'Articles p/ usage clinique':
  426. $category = 123;
  427. break;
  428. default:
  429. $category = 128;
  430. }
  431. $sheet_test->getActiveSheet()->setCellValue($write, $category);
  432. break;
  433. case 4:
  434. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  435. break;
  436. case 5:
  437. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  438. break;
  439. case 6:
  440. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  441. break;
  442. case 7:
  443. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  444. break;
  445. case 8:
  446. $sheet_test->getActiveSheet()->setCellValue($write, '');
  447. break;
  448. case 9:
  449. $sheet_test->getActiveSheet()->setCellValue($write, '');
  450. break;
  451. case 10:
  452. $sheet_test->getActiveSheet()->setCellValue($write, '');
  453. break;
  454. case 11:
  455. $sheet_test->getActiveSheet()->setCellValue($write, '0.00000');
  456. break;
  457. case 12:
  458. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  459. break;
  460. case 13:
  461. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  462. break;
  463. case 14:
  464. $sheet_test->getActiveSheet()->setCellValue($write, 'NULL');
  465. break;
  466. case 15:
  467. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  468. break;
  469. case 16:
  470. $prix = 'L' . $ligneFourniseeur;
  471. //Methode pour récupérer la valeur dans le tableau Tarif fournisseur 2019
  472. $sheet_test->getActiveSheet()->setCellValue($write, $sheetr->getActiveSheet()->getCell($prix)->getValue());
  473. break;
  474. case 17:
  475. $sheet_test->getActiveSheet()->setCellValue($write, '0.000000');
  476. break;
  477. case 18:
  478. $sheet_test->getActiveSheet()->setCellValue($write, '');
  479. break;
  480. case 19:
  481. $sheet_test->getActiveSheet()->setCellValue($write, '0.0000000');
  482. break;
  483. case 20:
  484. $sheet_test->getActiveSheet()->setCellValue($write, '0.00');
  485. break;
  486. case 21:
  487. $ref = 'G' . $ligneFourniseeur;
  488. $sheet_test->getActiveSheet()->setCellValue($write, $sheetr->getActiveSheet()->getCell($ref)->getValue());
  489. break;
  490. case 22:
  491. $sheet_test->getActiveSheet()->setCellValue($write, '');
  492. break;
  493. case 23:
  494. $sheet_test->getActiveSheet()->setCellValue($write, '');
  495. break;
  496. case 24:
  497. $sheet_test->getActiveSheet()->setCellValue($write, '0.00000');
  498. break;
  499. case 25:
  500. $sheet_test->getActiveSheet()->setCellValue($write, '0.00000');
  501. break;
  502. case 26:
  503. $sheet_test->getActiveSheet()->setCellValue($write, '0.00000');
  504. break;
  505. case 27:
  506. $sheet_test->getActiveSheet()->setCellValue($write, '0.00000');
  507. break;
  508. case 28:
  509. $sheet_test->getActiveSheet()->setCellValue($write, '2');
  510. break;
  511. case 29:
  512. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  513. break;
  514. case 30:
  515. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  516. break;
  517. case 31:
  518. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  519. break;
  520. case 32:
  521. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  522. break;
  523. case 33:
  524. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  525. break;
  526. case 34:
  527. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  528. break;
  529. case 35:
  530. $sheet_test->getActiveSheet()->setCellValue($write, '301-category');
  531. break;
  532. case 36:
  533. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  534. break;
  535. case 37:
  536. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  537. break;
  538. case 38:
  539. $sheet_test->getActiveSheet()->setCellValue($write, '0000-00-00');
  540. break;
  541. case 39:
  542. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  543. break;
  544. case 40:
  545. $sheet_test->getActiveSheet()->setCellValue($write, 'new');
  546. break;
  547. case 41:
  548. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  549. break;
  550. case 42:
  551. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  552. break;
  553. case 43:
  554. $sheet_test->getActiveSheet()->setCellValue($write, 'both');
  555. break;
  556. case 44:
  557. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  558. break;
  559. case 45:
  560. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  561. break;
  562. case 46:
  563. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  564. break;
  565. case 47:
  566. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  567. break;
  568. case 48:
  569. $sheet_test->getActiveSheet()->setCellValue($write, '02/07/2019 10:12:00');
  570. break;
  571. case 49:
  572. $sheet_test->getActiveSheet()->setCellValue($write, '02/07/2019 10:12:00');
  573. break;
  574. case 50:
  575. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  576. break;
  577. case 51:
  578. $sheet_test->getActiveSheet()->setCellValue($write, '3');
  579. break;
  580. case 53:
  581. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  582. break;
  583. }
  584. if ($ligne == 53) {
  585. $machin = 0;
  586. $colonne0 = 64;
  587. $ligne = -1;
  588.  
  589. $passage++;
  590. if ($passage == $last + 301) {
  591. $ligne = 53;
  592. }
  593. $ligneFourniseeur++;
  594. }
  595.  
  596. $colonne0++;
  597. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!