devis_form.inc.php 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. <?php
  2. if (empty($_GET['id']) || !is_numeric($id=$_GET['id']))
  3. die('NIET');
  4. $sql = 'SELECT *
  5. FROM ps_gformrequest
  6. WHERE id_gformrequest='.$id;
  7. $q = DB::p_select($sql);
  8. while($row=$q->fetch_assoc()) {
  9. //var_dump($row);
  10. // id request
  11. $row['id_gformrequest'];
  12. // id modèle form
  13. $row['id_gformbuilderpro'];
  14. // email client sender
  15. $row['sender'];
  16. // subject : nom form
  17. $row['subject'];
  18. // date
  19. $row['date_add'];
  20. // IP
  21. $row['user_id'];
  22. // json request
  23. $request = json_decode($row['jsonrequest'], true);
  24. var_dump($request);
  25. $fields_input = [
  26. 'gender',
  27. 'lastname',
  28. 'firstname',
  29. 'address',
  30. 'postalcode',
  31. 'city',
  32. 'email',
  33. 'phone1',
  34. 'phone2',
  35. 'demand', // détails texte
  36. ];
  37. $a = [];
  38. foreach($fields_input as $fieldname)
  39. $a[$fieldname] = $request['{'.$fieldname.'_input}'];
  40. $fields = [
  41. 'product_name', // label product
  42. 'input_98873', // Label Pays
  43. 'fileupload_80661', // contient un nom de fichier présent dans upload/ à mettre dans
  44. ];
  45. $a = [];
  46. foreach($fields as $fieldname)
  47. $a[$fieldname] = $request['{'.$fieldname.'}'];
  48. var_dump($a);
  49. $data_map = [
  50. '',
  51. ];
  52. }