API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 16th, 2019
769
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 41.37 KB | None | 0 0
raw download clone embed print report
  1. <html>
  2. <head>
  3. <meta charset="UTF-8">
  4. <title></title>
  5. </head>
  6. <body>
  7. <?php
  8. //Importe les extensions si elle ne sont pas dèjà présente
  9. require_once 'C:\xampp\htdocs\PhpProject\PHPExcel-1.8\PHPExcel-1.8\Classes\PHPExcel.php';
  10. require_once 'C:\xampp\htdocs\PhpProject\PHPExcel-1.8\PHPExcel-1.8\Classes\PHPExcel\IOFactory.php';
  11. require_once('C:\xampp\htdocs\PhpProject\PHPExcel-1.8\PHPExcel-1.8\Classes\PHPExcel\Writer\CSV.php');
  12. $PHPExcel = new PHPExcel();
  13. //Création de la feuille PHPExcel relié à la feuille excel ps_product
  14. $ps_product = PHPExcel_IOFactory::load("ps_product.xlsx");
  15. $sheet = PHPExcel_IOFactory::createReader('Excel2007');
  16. $sheet = $sheet->load('ps_product.xlsx');
  17. $sheet = $PHPExcel->setActiveSheetIndex(0);
  18. //Création de la feuille PHPExcel relié à la feuille excel ps_product
  19. $sheetr = PHPExcel_IOFactory::createReader('Excel2007');
  20. $sheetr = $sheetr->load('Tarif fournisseur 2019.xlsx');
  21. $sheetr->setActiveSheetIndex(0);
  22. //Création de la feuille PHPExcel relié à la feuille excel ps_product_test
  23. $sheet_test = PHPExcel_IOFactory::createReader('Excel2007');
  24. $sheet_test = $sheet_test->load('ps_product_test.xlsx');
  25. $sheet_test->setActiveSheetIndex(0);
  26. //Connexion à la base de données
  27. $bdd = new mysqli("localhost", "root", "", "soyons_chimie_biotechnologie");
  28. $host = "localhost";
  29. $username = "root";
  30. $passwd = "";
  31. $dbname = "soyons_chimie_biotechnologie";
  32. if ($bdd->connect_errno) {
  33. echo "Echec lors de la connexion à MySQL : (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
  34. }
  35. $link = mysqli_connect($host, $username, $passwd, $dbname);
  36. $bdd->set_charset("UTF_8_general_ci");
  37. //Méthode pour chercher la dernière variable de la table
  38. $requete = 'SELECT * FROM ps_product';
  39. $resultat = $bdd->query($requete);
  40. $last = '0';
  41. while ($ligne = $resultat->fetch_assoc()) {
  42. if ($ligne > $last) {
  43. $last++;
  44. }
  45. }
  46. $last++;
  47.  
  48. //Méthode pour remplir le tableau ps_product en fonction de Tarif fournisseur 2019
  49. $colonne0 = 65;
  50. $colonne1 = 65;
  51. $colonne2 = 65;
  52. $passage = $last;
  53. $ligneFourniseeur = 7;
  54. $machin = 0;
  55. $write;
  56. for ($ligne = 0; $ligne < 54; $ligne++) {
  57. if ($colonne0 == 91 || $machin > 0) {
  58. $machin++;
  59. //Methode quand la ligne arrive à AZ pour passer à BA
  60. if ($ligne == 52) {
  61. $colonne2++;
  62. $colonne1 = 65;
  63.  
  64. }
  65. //Methode quand la ligne arrive à BA pour repasser à A
  66. else if ($ligne == 53) {
  67.  
  68. $a0 = chr($colonne2);
  69. $a1 = chr($colonne1);
  70. $a2 = $passage;
  71. $write = "$a0$a1$a2";
  72. $colonne1 = 65;
  73. $colonne2 = 65;
  74. }
  75. //Methode quand la ligne arrive à Z pour passer à AA-AZ
  76. else {
  77.  
  78. $a0 = chr($colonne2);
  79. $a1 = chr($colonne1);
  80. $a2 = $passage;
  81. $write = "$a0$a1$a2";
  82. $colonne1++;
  83. }
  84. }
  85. //Methode pour aller de A à Z
  86. else {
  87.  
  88.  
  89. $a0 = chr($colonne0);
  90. $a1 = $passage;
  91. $write = "$a0$a1";
  92. }
  93. /*Technique pour remplir les tableaux ps_product avec Tarif Fournisseur 2019
  94. Pour comprendre pourquoi ces valeurs sont placé comme ça aller à:
  95. PrestaShop\Word PrestaShop\ps_product.docx
  96. Marche pour la fiche Rogo pour changer de tableau il faut changer $ligneFourniseeur
  97. et les valeurs du switch pour les case 2/3/16/21
  98. */
  99. switch ($ligne) {
  100.  
  101. case 0:
  102. $sheet_test->getActiveSheet()->setCellValue($write, $passage);
  103. break;
  104. case 1:
  105. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  106. break;
  107. case 2:
  108. $vendeur = 0;
  109. $vend = 'J' . $ligneFourniseeur;
  110. //Voir table mySQL ps_manufacturer pour comprendre les ID
  111. switch ($sheetr->getActiveSheet()->getCell($vend)->getValue()) {
  112. case 'Nahita':
  113. $vendeur = 4;
  114. break;
  115. case 'Avignon':
  116. $vendeur = 5;
  117. break;
  118. case 'Jipo':
  119. $vendeur = 6;
  120. break;
  121. case 'Endo Glassware':
  122. $vendeur = 7;
  123. break;
  124. case 'Simax':
  125. $vendeur = 8;
  126. break;
  127. case 'Selecta':
  128. $vendeur = 9;
  129. break;
  130. case 'Kartell':
  131. $vendeur = 10;
  132. break;
  133. case 'VitLab':
  134. $vendeur = 11;
  135. break;
  136. case 'TS':
  137. $vendeur = 12;
  138. break;
  139. case 'Glassco':
  140. $vendeur = 13;
  141. break;
  142. case 'RSG':
  143. $vendeur = 14;
  144. break;
  145. case 'Saint Gobain':
  146. $vendeur = 15;
  147. break;
  148. case 'Filtre RS':
  149. $vendeur = 16;
  150. break;
  151. case 'RS France':
  152. $vendeur = 17;
  153. break;
  154. case 'Zuzi':
  155. $vendeur = 18;
  156. break;
  157. case 'Ghäasel':
  158. $vendeur = 19;
  159. break;
  160. case 'Knittel':
  161. $vendeur = 20;
  162. break;
  163. case 'Anumbra':
  164. $vendeur = 21;
  165. break;
  166. case 'Gilac':
  167. $vendeur = 22;
  168. break;
  169. case 'Agencinox':
  170. $vendeur = 23;
  171. break;
  172. case 'Qualicolor':
  173. $vendeur = 24;
  174. break;
  175. case 'Technosklo':
  176. $vendeur = 25;
  177. break;
  178. case 'Nahita-Blue':
  179. $vendeur = 26;
  180. break;
  181. case 'Orto Alresa':
  182. $vendeur = 27;
  183. break;
  184. case 'RS Lab':
  185. $vendeur = 28;
  186. break;
  187. case 'Ura Technic':
  188. $vendeur = 29;
  189. break;
  190. case 'Socorex':
  191. $vendeur = 30;
  192. break;
  193. case 'Digipette':
  194. $vendeur = 31;
  195. break;
  196. case 'Ratiolab':
  197. $vendeur = 32;
  198. break;
  199. case 'Bomex':
  200. $vendeur = 33;
  201. break;
  202. case 'Gibertini':
  203. $vendeur = 34;
  204. break;
  205. case 'KNF':
  206. $vendeur = 35;
  207. break;
  208. case 'Univet':
  209. $vendeur = 36;
  210. break;
  211. case 'Endo Plasticware':
  212. $vendeur = 37;
  213. break;
  214. case 'Endo Protectlab':
  215. $vendeur = 38;
  216. break;
  217. case 'Plum':
  218. $vendeur = 39;
  219. break;
  220. case 'Emag':
  221. $vendeur = 40;
  222. break;
  223. case 'Preciss Europe':
  224. $vendeur = 41;
  225. break;
  226. default:
  227. $vendeur = 53;
  228. break;
  229.  
  230. }
  231. $sheet_test->getActiveSheet()->setCellValue($write, $vendeur);
  232. break;
  233. case 3:
  234. $category = 0;
  235. $cat = 'D' . $ligneFourniseeur;
  236. //Voir table mySQL ps_category_lang pour comprendre les ID
  237. switch ($sheetr->getActiveSheet()->getCell($cat)->getValue()) {
  238. case 'Mortiers':
  239. $category = 12;
  240. break;
  241. case 'Dessiccateurs':
  242. $category = 13;
  243. break;
  244. case 'Tubes':
  245. $category = 14;
  246. break;
  247. case 'Flacon à vis':
  248. $category = 15;
  249. break;
  250. case 'Portoirs et supports':
  251. $category = 16;
  252. break;
  253. case 'Bouchons':
  254. $category = 17;
  255. break;
  256. case 'Microscopie':
  257. $category = 18;
  258. break;
  259. case 'Microbiologie':
  260. $category = 19;
  261. break;
  262. case 'Bac et plateaux':
  263. $category = 20;
  264. break;
  265. case 'Mobilier':
  266. $category = 21;
  267. break;
  268. case 'Béchers':
  269. $category = 23;
  270. break;
  271. case 'Carafes':
  272. $category = 24;
  273. break;
  274. case 'Fioles':
  275. $category = 25;
  276. break;
  277. case 'Flacons ISO':
  278. $category = 26;
  279. break;
  280. case 'Flacons à vis':
  281. $category = 27;
  282. break;
  283. case 'Flacon à rodage':
  284. $category = 28;
  285. break;
  286. case 'Flacons compte-goutte':
  287. $category = 29;
  288. break;
  289. case 'Flacons laveurs':
  290. $category = 30;
  291. break;
  292. case 'Bidons':
  293. $category = 31;
  294. break;
  295. case 'Flacons':
  296. $category = 32;
  297. break;
  298. case 'Verrerie volumétrique':
  299. $category = 33;
  300. break;
  301. case 'Evaporation':
  302. $category = 34;
  303. break;
  304. case 'Incinération':
  305. $category = 35;
  306. break;
  307. case 'Eprouvettes':
  308. $category = 36;
  309. break;
  310. case 'Fioles jaugées':
  311. $category = 37;
  312. break;
  313. case 'Pipettes graduées':
  314. $category = 38;
  315. break;
  316. case 'Pipettes jaugées':
  317. $category = 39;
  318. break;
  319. case 'Pipettes,autres':
  320. $category = 40;
  321. break;
  322. case 'Burettes':
  323. $category = 41;
  324. break;
  325. case 'Cônes d\'Imhoff':
  326. $category = 42;
  327. break;
  328. case 'Montages':
  329. $category = 43;
  330. break;
  331. case 'Chauffage':
  332. $category = 44;
  333. break;
  334. case 'Tuyauterie et accessoire':
  335. $category = 45;
  336. break;
  337. case 'Spatules/cuillères':
  338. $category = 46;
  339. break;
  340. case 'Matériel à dissection':
  341. $category = 48;
  342. break;
  343. case 'Mono-rotor':
  344. $category = 49;
  345. break;
  346. case 'Minicentrifugeuses':
  347. $category = 50;
  348. break;
  349. case 'Microhématocrite':
  350. $category = 51;
  351. break;
  352. case 'Pour micro-tubes':
  353. $category = 57;
  354. break;
  355. case 'Universelles':
  356. $category = 58;
  357. break;
  358. case 'Grande capacité':
  359. $category = 59;
  360. break;
  361. case 'Microscopes':
  362. $category = 61;
  363. break;
  364. case 'Stéréomicroscopes':
  365. $category = 62;
  366. break;
  367. case 'Caméras vidéo':
  368. $category = 63;
  369. break;
  370. case 'Spectophotomètres':
  371. $category = 64;
  372. break;
  373. case 'Polarimètres':
  374. $category = 65;
  375. break;
  376. case 'Réfractomètres':
  377. $category = 66;
  378. break;
  379. case 'Loupes':
  380. $category = 67;
  381. break;
  382. case 'Etuves':
  383. $category = 69;
  384. break;
  385. case 'Bains':
  386. $category = 70;
  387. break;
  388. case 'Chauffe-ballons':
  389. $category = 71;
  390. break;
  391. case 'Réfrigération/Congélation':
  392. $category = 72;
  393. break;
  394. case 'Balances':
  395. $category = 75;
  396. break;
  397. case 'pH-mètres':
  398. $category = 76;
  399. break;
  400. case 'Conductimètres':
  401. $category = 77;
  402. break;
  403. case 'Thermomètres':
  404. $category = 78;
  405. break;
  406. case 'Temps':
  407. $category = 79;
  408. break;
  409. case 'Densimètres':
  410. $category = 80;
  411. break;
  412. case 'Viscosimètres':
  413. $category = 81;
  414. break;
  415. case 'Agitateurs magnétique':
  416. $category = 83;
  417. break;
  418. case 'Barreaux magnétique':
  419. $category = 84;
  420. break;
  421. case 'Agitateurs vibrateurs':
  422. $category = 85;
  423. break;
  424. case 'Agitateurs multidimensionnels':
  425. $category = 87;
  426. break;
  427. case 'Agitateurs à tige':
  428. $category = 88;
  429. break;
  430. case 'Auxiliaires de pipetage':
  431. $category = 90;
  432. break;
  433. case 'Distributeurs':
  434. $category = 91;
  435. break;
  436. case 'Pointes et autres consommables':
  437. $category = 92;
  438. break;
  439. case 'Seringues':
  440. $category = 93;
  441. break;
  442. case 'Pompes':
  443. $category = 94;
  444. break;
  445. case 'Equipements/pièces en verre':
  446. $category = 96;
  447. break;
  448. case 'Purification d\'eau':
  449. $category = 97;
  450. break;
  451. case 'Evaporateurs rotatifs':
  452. $category = 98;
  453. break;
  454. case 'Système de filtration':
  455. $category = 99;
  456. break;
  457. case 'Creusets filtrants':
  458. $category = 100;
  459. break;
  460. case 'Entonnoirs':
  461. $category = 101;
  462. break;
  463. case 'Ampoules à décanter':
  464. $category = 102;
  465. break;
  466. case 'Papier filtre':
  467. $category = 103;
  468. break;
  469. case 'Filtres seringues':
  470. $category = 104;
  471. break;
  472. case 'Pompes à vide':
  473. $category = 105;
  474. break;
  475. case 'Modèles':
  476. $category = 107;
  477. break;
  478. case 'Préparations microscopiques':
  479. $category = 108;
  480. break;
  481. case 'Physique':
  482. $category = 109;
  483. break;
  484. case 'Blouse de protection':
  485. $category = 110;
  486. break;
  487. case 'Douches et lave-oeil':
  488. $category = 111;
  489. break;
  490. case 'Verrerie Industrielle & Tubing':
  491. $category = 113;
  492. break;
  493. case 'Verrerie à rodage à vis':
  494. $category = 114;
  495. break;
  496. case 'Tubes, boro':
  497. $category = 115;
  498. break;
  499. case 'Capillaires':
  500. $category = 116;
  501. break;
  502. case 'Baguettes':
  503. $category = 117;
  504. break;
  505. case 'Nettoyage et stérilisation':
  506. $category = 119;
  507. break;
  508. case 'Sciences de la vie':
  509. $category = 120;
  510. break;
  511. case 'Préparation d\'échantillons':
  512. $category = 121;
  513. break;
  514. case 'Analyses des eaux, aliments':
  515. $category = 122;
  516. break;
  517. case 'Articles p/ usage clinique':
  518. $category = 123;
  519. break;
  520. default:
  521. $category = 128;
  522. }
  523. $sheet_test->getActiveSheet()->setCellValue($write, $category);
  524. break;
  525. case 4:
  526. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  527. break;
  528. case 5:
  529. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  530. break;
  531. case 6:
  532. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  533. break;
  534. case 7:
  535. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  536. break;
  537. case 8:
  538. $sheet_test->getActiveSheet()->setCellValue($write, '');
  539. break;
  540. case 9:
  541. $sheet_test->getActiveSheet()->setCellValue($write, '');
  542. break;
  543. case 10:
  544. $sheet_test->getActiveSheet()->setCellValue($write, '');
  545. break;
  546. case 11:
  547. $sheet_test->getActiveSheet()->setCellValue($write, '0.00000');
  548. break;
  549. case 12:
  550. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  551. break;
  552. case 13:
  553. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  554. break;
  555. case 14:
  556. $sheet_test->getActiveSheet()->setCellValue($write, 'NULL');
  557. break;
  558. case 15:
  559. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  560. break;
  561. case 16:
  562. $prix = 'L' . $ligneFourniseeur;
  563. //Methode pour récupérer la valeur dans le tableau Tarif fournisseur 2019
  564. $sheet_test->getActiveSheet()->setCellValue($write, $sheetr->getActiveSheet()->getCell($prix)->getValue());
  565. break;
  566. case 17:
  567. $sheet_test->getActiveSheet()->setCellValue($write, '0.000000');
  568. break;
  569. case 18:
  570. $sheet_test->getActiveSheet()->setCellValue($write, '');
  571. break;
  572. case 19:
  573. $sheet_test->getActiveSheet()->setCellValue($write, '0.0000000');
  574. break;
  575. case 20:
  576. $sheet_test->getActiveSheet()->setCellValue($write, '0.00');
  577. break;
  578. case 21:
  579. $ref = 'G' . $ligneFourniseeur;
  580. $sheet_test->getActiveSheet()->setCellValue($write, $sheetr->getActiveSheet()->getCell($ref)->getValue());
  581. break;
  582. case 22:
  583. $sheet_test->getActiveSheet()->setCellValue($write, '');
  584. break;
  585. case 23:
  586. $sheet_test->getActiveSheet()->setCellValue($write, '');
  587. break;
  588. case 24:
  589. $sheet_test->getActiveSheet()->setCellValue($write, '0.00000');
  590. break;
  591. case 25:
  592. $sheet_test->getActiveSheet()->setCellValue($write, '0.00000');
  593. break;
  594. case 26:
  595. $sheet_test->getActiveSheet()->setCellValue($write, '0.00000');
  596. break;
  597. case 27:
  598. $sheet_test->getActiveSheet()->setCellValue($write, '0.00000');
  599. break;
  600. case 28:
  601. $sheet_test->getActiveSheet()->setCellValue($write, '2');
  602. break;
  603. case 29:
  604. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  605. break;
  606. case 30:
  607. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  608. break;
  609. case 31:
  610. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  611. break;
  612. case 32:
  613. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  614. break;
  615. case 33:
  616. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  617. break;
  618. case 34:
  619. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  620. break;
  621. case 35:
  622. $sheet_test->getActiveSheet()->setCellValue($write, '301-category');
  623. break;
  624. case 36:
  625. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  626. break;
  627. case 37:
  628. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  629. break;
  630. case 38:
  631. $sheet_test->getActiveSheet()->setCellValue($write, '0000-00-00');
  632. break;
  633. case 39:
  634. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  635. break;
  636. case 40:
  637. $sheet_test->getActiveSheet()->setCellValue($write, 'new');
  638. break;
  639. case 41:
  640. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  641. break;
  642. case 42:
  643. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  644. break;
  645. case 43:
  646. $sheet_test->getActiveSheet()->setCellValue($write, 'both');
  647. break;
  648. case 44:
  649. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  650. break;
  651. case 45:
  652. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  653. break;
  654. case 46:
  655. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  656. break;
  657. case 47:
  658. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  659. break;
  660. case 48:
  661. $sheet_test->getActiveSheet()->setCellValue($write, '02/07/2019 10:12:00');
  662. break;
  663. case 49:
  664. $sheet_test->getActiveSheet()->setCellValue($write, '02/07/2019 10:12:00');
  665. break;
  666. case 50:
  667. $sheet_test->getActiveSheet()->setCellValue($write, '0');
  668. break;
  669. case 51:
  670. $sheet_test->getActiveSheet()->setCellValue($write, '3');
  671. break;
  672. case 53:
  673. $sheet_test->getActiveSheet()->setCellValue($write, '1');
  674. break;
  675. }
  676. if ($ligne == 53) {
  677. $machin = 0;
  678. $colonne0 = 64;
  679. $ligne = -1;
  680.  
  681. $passage++;
  682. if ($passage == $last + 301) {
  683. $ligne = 53;
  684. }
  685. $ligneFourniseeur++;
  686. }
  687.  
  688. $colonne0++;
  689. }
  690.  
  691.  
  692. echo "check";
  693. $sheet_test = PHPExcel_IOFactory::createWriter($sheet_test, 'Excel2007');
  694. $sheet_test->save('ps_product_test.xlsx');
  695. //mysqli_close($link); //A enlever
  696. /*
  697. //Affichage table mysql ps_manufacturer
  698. $requete = 'SELECT * FROM ps_manufacturer';
  699. $resultat = $bdd->query($requete);
  700. while ($ligne = $resultat->fetch_assoc()) {
  701. echo $ligne['id_manufacturer'] . " " . $ligne['name'] . " " . $ligne['date_add'] . " " . $ligne['date_upd'] . " " . $ligne['active'];
  702. echo "</br>";
  703. }
  704. //Affichage tabel mysql ps_manufacturer
  705. //Affichage table mysql ps_category_lang
  706. $requete = 'SELECT * FROM ps_category_lang';
  707. $resultat = $bdd->query($requete);
  708. while ($ligne = $resultat->fetch_assoc()) {
  709. echo $ligne['id_category'] . " " . $ligne['id_shop'] . " " . $ligne['id_lang'] . " " . $ligne['name'] . " ";
  710. echo $ligne['description'] . " " . $ligne['link_rewrite'] . " " . $ligne['meta_title'] . " " . $ligne['meta_keywords'] . " ";
  711. echo $ligne['meta_description'];
  712. }
  713. //Affichage table mysql ps_category_lang
  714. //Affichage table mysql ps_category
  715. $requete = 'SELECT * FROM ps_category';
  716. $resultat = $bdd->query($requete);
  717. while ($ligne = $resultat->fetch_assoc()) {
  718. echo $ligne['id_category'] . " " . $ligne['id_parent'] . " " . $ligne['id_shop_default'] . " " . $ligne['level_depth'] . " ";
  719. echo $ligne['nleft'] . " " . $ligne['nright'] . " " . $ligne['active'] . " " . $ligne['date_add'] . " ";
  720. echo $ligne['date_upd'] . " " . $ligne['position'] . " " . $ligne['is_root_category'];
  721. echo "</br>";
  722. }
  723. //Affichage table mysql ps_category
  724. //Affichage table mysql ps_product_lang
  725. $requete = 'SELECT * FROM ps_product_lang';
  726. $resultat = $bdd->query($requete);
  727. while ($ligne = $resultat->fetch_assoc()) {
  728. echo $ligne['id_product'] . " " . $ligne['id_shop'] . " " . $ligne['id_lang'] . " " . $ligne['description'] . " ";
  729. echo $ligne['description_short'] . " " . $ligne['link_rewrite'] . " " . $ligne['meta_description'] . " " . $ligne['meta_keywords'] . " ";
  730. echo $ligne['meta_title'] . " " . $ligne['name'] . " " . $ligne['available_now'] . " " . $ligne['available_later'] . " ";
  731. echo $ligne['delivery_in_stock'] . " " . $ligne['delivery_out_stock'];
  732. }
  733. //Affichage table mysql ps_product_lang
  734. //Affichage table mysql ps_product
  735. $requete = 'SELECT * FROM ps_product';
  736. $resultat = $bdd->query($requete);
  737. while ($ligne = $resultat->fetch_assoc()) {
  738. echo $ligne['id_product'] . " " . $ligne['id_supplier'] . " " . $ligne['id_manufacturer'] . " " . $ligne['id_category_default'] . " ";
  739. echo $ligne['id_shop_default'] . " " . $ligne['id_tax_rules_group'] . " " . $ligne['on_sale'] . " " . $ligne['online_only'] . " ";
  740. echo $ligne['ean13'] . " " . $ligne['isbn'] . " " . $ligne['upc'] . " " . $ligne['ecotax'] . " ";
  741. echo $ligne['quantity'] . " " . $ligne['minimal_quantity'] . " " . $ligne['low_stock_threshold'] . " " . $ligne['low_stock_alert'] . " ";
  742. echo $ligne['price'] . " " . $ligne['wholesale_price'] . " " . $ligne['unity'] . " " . $ligne['unit_price_ratio'] . " ";
  743. echo $ligne['additional_shipping_cost'] . " " . $ligne['reference'] . " " . $ligne['supplier_reference'] . " " . $ligne['location'] . " ";
  744. echo $ligne['width'] . " " . $ligne['height'] . " " . $ligne['depth'] . " " . $ligne['weight'] . " ";
  745. echo $ligne['out_of_stock'] . " " . $ligne['additional_delivery_times'] . " " . $ligne['quantity_discount'] . " " . $ligne['customizable'] . " ";
  746. echo $ligne['uploadable_files'] . " " . $ligne['text_fields'] . " " . $ligne['active'] . " " . $ligne['redirect_type'] . " ";
  747. echo $ligne['id_type_redirected'] . " " . $ligne['available_for_order'] . " " . $ligne['available_date'] . " " . $ligne['show_condition'] . " ";
  748. echo $ligne['condition'] . " " . $ligne['show_price'] . " " . $ligne['indexed'] . " " . $ligne['visibility'] . " ";
  749. echo $ligne['cache_is_pack'] . " " . $ligne['cache_has_attachments'] . " " . $ligne['is_virtual'] . " " . $ligne['cache_default_attribute'] . " ";
  750. echo $ligne['date_add'] . " " . $ligne['date_upd'] . " " . $ligne['advanced_stock_management'] . " " . $ligne['pack_stock_type'] . " ";
  751. echo $ligne['state'];
  752. echo "</br>";
  753. }
  754. //Affichage table mysql ps_product
  755.  
  756. mysqli_close($link);
  757.  
  758. //Remplissage du tableau ps_manufacturer
  759. $colonne03 = 65;
  760. $passage03 = 0;
  761. $nbrLigne03 = 5;
  762. for ($ligne = 0; $ligne < ($nbrLigne03 * 112); $ligne++) {
  763. if ($colonne03 == 70) {
  764. $colonne03 = 65;
  765. $passage03++;
  766. echo "</br>";
  767. }
  768. echo chr($colonne03);
  769. echo $passage03;
  770. echo " ";
  771. $colonne03++;
  772. }
  773. //Remplissage du tableau ps_manufacturer
  774. //Remplissage du tableau ps_category_lang
  775. $colonne02 = 65;
  776. $passage02 = 0;
  777. $nbrLigne02 = 9;
  778. for ($ligne = 0; $ligne < ($nbrLigne02 * 112); $ligne++) {
  779. if ($colonne02 == 74) {
  780. $colonne02 = 65;
  781. $passage02++;
  782. echo "</br>";
  783. }
  784. echo chr($colonne02);
  785. echo $passage02;
  786. echo " ";
  787. $colonne02++;
  788. }
  789. //Remplissage du tableau ps_category_lang
  790. //Remplissage du tableau ps_category
  791. $colonne01 = 65;
  792. $passage01 = 0;
  793. $nbrLigne01 = 11;
  794. for ($ligne = 0; $ligne < ($nbrLigne01 * 112); $ligne++) {
  795. if ($colonne01 == 76) {
  796. $colonne01 = 65;
  797. $passage01++;
  798. echo "</br>";
  799. }
  800. echo chr($colonne01);
  801. echo $passage01;
  802. echo " ";
  803. $colonne01++;
  804. }
  805. //Remplissage du tableau ps_category
  806. //Remplissage du tableau ps_product_lang
  807. $colonne00 = 65;
  808. $passage00 = 0;
  809. $nbrLigne00 = 14;
  810. for ($ligne = 0; $ligne < ($nbrLigne00 * 112); $ligne++) {
  811. if ($colonne00 == 79) {
  812. $colonne00 = 65;
  813. $passage00++;
  814. echo "</br>";
  815. }
  816. echo chr($colonne00);
  817. echo $passage00;
  818. echo " ";
  819. $colonne00++;
  820. }
  821. //Remplissage du tableau ps_product_lang
  822. //Remplissage du tableau ps_product
  823. $colonne0 = 65;
  824. $colonne1 = 65;
  825. $colonne2 = 65;
  826. $passage = 1;
  827. $machin = 0;
  828. for ($ligne = 0; $ligne < 54; $ligne++) {
  829. if ($colonne0 == 91 || $machin > 0) {
  830. $machin++;
  831. if ($ligne == 52) {
  832. $colonne2++;
  833. $colonne1 = 65;
  834. } else if ($ligne == 53) {
  835. echo chr($colonne2), chr($colonne1);
  836. echo $passage;
  837. $colonne1 = 65;
  838. $colonne2 = 65;
  839. } else {
  840. echo chr($colonne2), chr($colonne1);
  841. echo $passage;
  842. $colonne1++;
  843. }
  844. } else {
  845. echo chr($colonne0);
  846. echo $passage;
  847. }
  848.  
  849. if ($ligne == 53) {
  850. $machin = 0;
  851. $colonne0 = 64;
  852. $ligne = -1;
  853.  
  854. $passage++;
  855. if ($passage == 112) {
  856. $ligne = 53;
  857. }
  858. echo "</br>";
  859. echo "</br>";
  860. }
  861. $colonne0++;
  862. echo "'";
  863. }
  864. //Remplissage du tableau ps_product
  865.  
  866. /*
  867. //Convertisseur xls en csv
  868. $excel_readers = array(
  869. 'Excel5',
  870. 'Excel2003XML',
  871. 'Excel2007'
  872. );
  873. $reader = PHPExcel_IOFactory::createReader('Excel5');
  874. $reader->setReadDataOnly(false);
  875. $path = 'test123.xls';
  876. $excel = $reader->load($path);
  877. $writer = PHPExcel_IOFactory::createWriter($excel, 'CSV');
  878. $writer->setUseBOM(true);
  879. $writer->save('test123.csv');
  880. echo 'File saved to csv format';
  881. //Convertisseur xls en csv
  882. */
  883. /*
  884. //Pour ps_product
  885. echo '<table border="1">';
  886. $un = 0;
  887. $gauche = 1;
  888. $haut = 65;
  889. $haut2 = 65;
  890. $haut3 = 0;
  891. foreach ($sheet->getRowIterator() as $row) {
  892. foreach ($row->getCellIterator() as $cell) {
  893. ($cell->getValue());
  894.  
  895.  
  896. if ($haut == 91 || $haut3 > 0) {
  897. $haut3++;
  898. if ($un == 26) {
  899. echo chr($haut2), chr(65);
  900. } else if ($un == 52) {
  901. $haut2++;
  902. echo chr($haut2), chr(65);
  903. } else if ($un == 53) {
  904. echo chr(65);
  905. } else {
  906. echo chr($haut2), chr($haut);
  907. }
  908. } else {
  909. echo chr($haut);
  910. }
  911. if ($haut == 91) {
  912. $haut = 65;
  913. }
  914. if ($un == 53) {
  915. $haut3 = 0;
  916. $haut = 65;
  917. $haut2 = 65;
  918. $gauche++;
  919. $un = 0;
  920. }
  921.  
  922. $haut++;
  923. $un++;
  924. echo $gauche;
  925. echo " ";
  926. echo " ";
  927. }
  928. echo "</tr>";
  929. }
  930. echo '</table>';
  931. $writer = new PHPExcel_Writer_Excel2007($PHPExcel);
  932. $writer->save('C:\xampp\htdocs\PhpProject\poule.xlsx');
  933. //Tableau ps_product
  934. //Afficahge tableau
  935. echo '<table border="1">';
  936. $un = 0;
  937. foreach ($sheet->getRowIterator() as $row) {
  938. echo '<tr>';
  939. foreach ($row->getCellIterator() as $cell) {
  940. echo "<td>";
  941. echo($cell->getValue());
  942. echo " ";
  943. $un++;
  944. echo "</td>";
  945. if ($un == 53) {
  946. echo "</br>";
  947. }
  948. }
  949. echo "</tr>";
  950. }
  951. echo '</table>';
  952. //Affichage tableau
  953.  
  954. //Remplir tableau
  955. //Supression à partir d'une virgule
  956. $poule = 15;
  957. $poulet = 18;
  958. $oui = "Je suis dans le train, j'aime pas";
  959. echo $oui;
  960. if (strstr($oui, ',') == true) {
  961. echo "</br> non";
  962. $moins = strpos($oui, ',');
  963. $plus = strlen($oui);
  964. $non = substr($oui, 0, $moins - $plus);
  965. echo "</br>";
  966. echo $non;
  967. }
  968. //Supression à partir d'une virgule
  969. //Création tableau
  970. echo '<table border="1">';
  971. for ($i = 65; $i < 91; ++$i) {
  972. echo "<td>";
  973. $passage = 0;
  974. $ch = 65;
  975. echo chr($i), PHP_EOL;
  976. if ($i == 90) {
  977. echo "</tr>";
  978. for ($j = 65; $j < 91; ++$j) {
  979. echo "<td>";
  980. echo chr($ch), chr($j), PHP_EOL;
  981. echo "</td>";
  982. if ($j == 90) {
  983. if ($j == 90 && $ch == 90) {
  984. $j = 90;
  985. } else {
  986. $ch++;
  987. $j = 64;
  988. echo "</tr>";
  989. }
  990. }
  991. }
  992. }
  993. $ch++;
  994. echo "</td>";
  995. }
  996. echo "</table>";
  997. //Création tableau
  998. //Test PHP
  999. echo "<h1>";
  1000. echo"Addition = ";
  1001. echo $poule + $poulet;
  1002. echo "</br>";
  1003. echo "Soustraction = ";
  1004. echo $poule - $poulet;
  1005. echo "</br>";
  1006. echo "Multiplication = ";
  1007. echo $poule * $poulet;
  1008. echo "</br>";
  1009. echo "Division = ";
  1010. echo $poule / $poulet;
  1011. echo "</br>";
  1012. echo "Modulo = ";
  1013. echo $poule % $poulet;
  1014. echo "</br>";
  1015. echo "Incrémentation = ";
  1016. echo ++$poule;
  1017. echo "</br>";
  1018. echo "Décrémentation = ";
  1019. echo --$poule;
  1020. echo "</br>";
  1021. echo "Exponatiation = ";
  1022. echo $poule ** $poulet;
  1023. echo "</h1>";
  1024. echo "Elle écrivit dessus, \"Retour à l'expéditeur\".";
  1025. //Test PHP
  1026.  
  1027.  
  1028. */
  1029. ?>
  1030. </body>
  1031. </html>
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!