API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 27th, 2015
67
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 66.57 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. if(isset($_POST['con'])){
  3. $_SESSION['id_con'] = trim(htmlspecialchars($_POST['id_con']));
  4.  
  5. $level = $db->where('id_number', $_SESSION['id_con'])->getOne('info')['level'];
  6.  
  7. if($level == 2){
  8. $_SESSION['level'] = 3;
  9. }
  10.  
  11. }
  12.  
  13.  
  14.  
  15. if (isset($_POST['submit'])) {
  16. if(!array_key_exists('level', $_SESSION)){
  17. $_SESSION['level'] = 1;
  18. //הכנסת הנתונים למערך
  19. $info['id'] = $_SESSION['id'] = trim(htmlspecialchars($_POST['id']));
  20. $info['date'] = $_SESSION['date'] = trim(htmlspecialchars($_POST['date']));
  21.  
  22.  
  23.  
  24. //הכנסה למסד נתונים
  25. $data = Array ("id_number" => $info['id'],
  26. "birth_date" => $info['date'],
  27. "level" => '1'
  28. );
  29. $id = $db->insert ('info', $data);
  30. //אינקלוד הדף הבא
  31. include ('page2.php');
  32. }
  33.  
  34. elseif($_SESSION['level'] == 1){
  35. $_SESSION['level'] = 2;
  36. $info['email'] = $_SESSION['email'] = trim(htmlspecialchars($_POST['email']));
  37. $info['dadname'] = $_SESSION['dadname'] = trim(htmlspecialchars($_POST['dadname']));
  38. $info['name_1'] = $_SESSION['name_1'] = trim(htmlspecialchars($_POST['name_partner_1']));
  39. $info['lastname_1'] = $_SESSION['lastname_1'] = trim(htmlspecialchars($_POST['lastname_partner_1']));
  40. $info['status_1'] = $_SESSION['status_1'] = trim(htmlspecialchars($_POST['status_1']));
  41. $info['company'] = $_SESSION['company'] = trim(htmlspecialchars($_POST['company']));
  42. $info['phone'] = $_SESSION['phone'] = trim(htmlspecialchars($_POST['phone']));
  43. $info['address'] = $_SESSION['address'] = trim(htmlspecialchars($_POST['address']));$info['address'] = $_SESSION['address'] = trim(htmlspecialchars($_POST['address']));$info['address'] = $_SESSION['address'] = trim(htmlspecialchars($_POST['address']));
  44. $info['address_2'] = $_SESSION['address_2'] = trim(htmlspecialchars($_POST['address_2']));
  45. $info['name_2'] = $_SESSION['name_2'] = trim(htmlspecialchars($_POST['name_partner_2']));
  46. $info['lastname_2'] = $_SESSION['lastname_2'] = trim(htmlspecialchars($_POST['lastname_partner_2']));
  47. $info['id_2'] = $_SESSION['id_2'] = trim(htmlspecialchars($_POST['id_2']));
  48. $info['status_2'] = $_SESSION['status_2'] = trim(htmlspecialchars($_POST['status_2']));
  49. $info['date_n'] = $_SESSION['date_n'] = trim(htmlspecialchars($_POST['date_n']));
  50. $info['date_n_2'] = $_SESSION['date_n_2'] = trim(htmlspecialchars($_POST['date_n_2']));
  51. $info['date_n_a'] = $_SESSION['date_n_a'] = trim(htmlspecialchars($_POST['date_n_a']));
  52. $info['company_2'] = $_SESSION['company_2'] = trim(htmlspecialchars($_POST['company_2']));
  53. $info['date_2'] = $_SESSION['date_2'] = trim(htmlspecialchars($_POST['date_2']));
  54. $info['phone_2'] = $_SESSION['phone_2'] = trim(htmlspecialchars($_POST['phone_2']));
  55. $info['date_g'] = $_SESSION['date_g'] = trim(htmlspecialchars($_POST['date_g']));
  56. $info['date_a'] = $_SESSION['date_a'] = trim(htmlspecialchars($_POST['date_a']));
  57.  
  58. $data = Array (
  59. 'email' => $info['email'],
  60. 'dadname' => $info['dadname'],
  61. 'name' => $info['name_1'],
  62. 'last_name' => $info['lastname_1'],
  63. 'status' => $info['status_1'],
  64. 'company' => $info['company'],
  65. 'phone' => $info['phone'],
  66. 'address' => $info['address'],
  67. 'address_2' => $info['address_2'],
  68. 'name_2' => $info['name_2'],
  69. 'lastname_2' => $info['lastname_2'],
  70. 'id_number_2' => $info['id_2'],
  71. 'status_2' => $info['status_2'],
  72. 'date_n' => $info['date_n'],
  73. 'date_n_2' => $info['date_n_2'],
  74. 'date_n_a' => $info['date_n_a'],
  75. 'company_2' => $info['company_2'],
  76. 'date_2' => $info['date_2'],
  77. 'phone_2' => $info['phone_2'],
  78. 'date_g' => $info['date_g'],
  79. 'date_a' => $info['date_a']
  80.  
  81.  
  82. );
  83.  
  84.  
  85. if($_POST['status_1'] == "נשוי"){
  86. $showstyle ='';
  87.  
  88. }else{
  89. $showstyle = 'display:none';
  90. }
  91.  
  92. $_SESSION['showstyle'] = $showstyle;
  93.  
  94. #echo $_SESSION['id'];
  95. $db->where ('id_number', $_SESSION['id']);#EDIT
  96. if ($db->update ('info', $data)){
  97.  
  98. }
  99.  
  100. else
  101. echo 'עדכון הנתונים במסד נכשל: ' . $db->getLastError();
  102.  
  103. $data = Array ( 'level' => '2');
  104. $db->where ('id_number', $_SESSION['id']);
  105. if ($db->update ('info', $data))
  106. echo $db->count . ' records were updated';
  107. else
  108. echo 'update failed: ' . $db->getLastError();
  109.  
  110. include ('page3.php');
  111.  
  112.  
  113.  
  114.  
  115. }
  116.  
  117. elseif ($_SESSION['level'] == 2) {
  118. $_SESSION['level'] = 3;
  119. $info['p3_q1'] = $_SESSION['p3_q1'] = trim(htmlspecialchars($_POST['p3_q1']));
  120. $info['p3_q1_y1'] = $_SESSION['p3_q1_y1'] = trim(htmlspecialchars($_POST['p3_q1_y1']));
  121. $info['p3_q1_y2'] = $_SESSION['p3_q1_y2'] = trim(htmlspecialchars($_POST['p3_q1_y2']));
  122. $info['p3_q2'] = $_SESSION['p3_q2'] = trim(htmlspecialchars($_POST['p3_q2']));
  123. $info['p3_q3'] = $_SESSION['p3_q3'] = trim(htmlspecialchars($_POST['p3_q3']));
  124. $info['p3_q4'] = $_SESSION['p3_q4'] = trim(htmlspecialchars($_POST['p3_q4']));
  125. $info['p3_q5'] = $_SESSION['p3_q5'] = trim(htmlspecialchars($_POST['p3_q5']));
  126. $info['p3_q6'] = $_SESSION['p3_q6'] = trim(htmlspecialchars($_POST['p3_q6']));
  127. $info['p3_q7'] = $_SESSION['p3_q7'] = trim(htmlspecialchars($_POST['p3_q7']));
  128. $info['p3_q8'] = $_SESSION['p3_q8'] = trim(htmlspecialchars($_POST['p3_q8']));
  129. $info['p3_q8_1'] = $_SESSION['p3_q8_1'] = trim(htmlspecialchars($_POST['p3_q8_1']));
  130. $info['p3_q8_2'] = $_SESSION['p3_q8_2'] = trim(htmlspecialchars($_POST['p3_q8_2']));
  131. $info['p3_q8_3'] = $_SESSION['p3_q8_3'] = trim(htmlspecialchars($_POST['p3_q8_3']));
  132. $info['p3_q8_4'] = $_SESSION['p3_q8_4'] = trim(htmlspecialchars($_POST['p3_q8_4']));
  133. $info['p3_q8_5'] = $_SESSION['p3_q8_5'] = trim(htmlspecialchars($_POST['p3_q8_5']));
  134. $info['p3_q8_6'] = $_SESSION['p3_q8_6'] = trim(htmlspecialchars($_POST['p3_q8_6']));
  135. $info['p3_q9_1'] = $_SESSION['p3_q9_1'] = trim(htmlspecialchars($_POST['p3_q9_1']));
  136. $info['p3_q9_2'] = $_SESSION['p3_q9_2'] = trim(htmlspecialchars($_POST['p3_q9_2']));
  137. $info['p3_q9_3'] = $_SESSION['p3_q9_3'] = trim(htmlspecialchars($_POST['p3_q9_3']));
  138. $info['p3_q9_4'] = $_SESSION['p3_q9_4'] = trim(htmlspecialchars($_POST['p3_q9_4']));
  139. $info['p3_q10_1'] = $_SESSION['p3_q10_1'] = trim(htmlspecialchars($_POST['p3_q10_1']));
  140. $info['p3_q10_2'] = $_SESSION['p3_q10_2'] = trim(htmlspecialchars($_POST['p3_q10_2']));
  141. $info['p3_q11'] = $_SESSION['p3_q11'] = trim(htmlspecialchars($_POST['p3_q11']));
  142.  
  143. $info['p3_qP1'] = $_SESSION['p3_qP1'] = trim(htmlspecialchars($_POST['p3_qP1']));
  144. $info['p3_qP2'] = $_SESSION['p3_qP2'] = trim(htmlspecialchars($_POST['p3_qP2']));
  145. $info['p3_qP3'] = $_SESSION['p3_qP3'] = trim(htmlspecialchars($_POST['p3_qP3']));
  146. $info['p3_qP4'] = $_SESSION['p3_qP4'] = trim(htmlspecialchars($_POST['p3_qP4']));
  147. $info['p3_qP5'] = $_SESSION['p3_qP5'] = trim(htmlspecialchars($_POST['p3_qP5']));
  148. $info['p3_qP6'] = $_SESSION['p3_qP6'] = trim(htmlspecialchars($_POST['p3_qP6']));
  149. $info['p3_qP7'] = $_SESSION['p3_qP7'] = trim(htmlspecialchars($_POST['p3_qP7']));
  150. $info['p3_qP8'] = $_SESSION['p3_qP8'] = trim(htmlspecialchars($_POST['p3_qP8']));
  151. $info['p3_qP8_1'] = $_SESSION['p3_qP8_1'] = trim(htmlspecialchars($_POST['p3_qP8_1']));
  152. $info['p3_qP8_2'] = $_SESSION['p3_qP8_2'] = trim(htmlspecialchars($_POST['p3_qP8_2']));
  153. $info['p3_qP8_3'] = $_SESSION['p3_qP8_3'] = trim(htmlspecialchars($_POST['p3_qP8_3']));
  154. $info['p3_qP8_4'] = $_SESSION['p3_qP8_4'] = trim(htmlspecialchars($_POST['p3_qP8_4']));
  155. $info['p3_qP8_5'] = $_SESSION['p3_qP8_5'] = trim(htmlspecialchars($_POST['p3_qP8_5']));
  156. $info['p3_qP8_6'] = $_SESSION['p3_qP8_6'] = trim(htmlspecialchars($_POST['p3_qP8_6']));
  157. $info['p3_qP9_1'] = $_SESSION['p3_qP9_1'] = trim(htmlspecialchars($_POST['p3_qP9_1']));
  158. $info['p3_qP9_2'] = $_SESSION['p3_qP9_2'] = trim(htmlspecialchars($_POST['p3_qP9_2']));
  159. $info['p3_qP9_3'] = $_SESSION['p3_qP9_3'] = trim(htmlspecialchars($_POST['p3_qP9_3']));
  160. $info['p3_qP9_4'] = $_SESSION['p3_qP9_4'] = trim(htmlspecialchars($_POST['p3_qP9_4']));
  161. $info['p3_qP10_1'] = $_SESSION['p3_qP10_1'] = trim(htmlspecialchars($_POST['p3_qP10_1']));
  162. $info['p3_qP10_2'] = $_SESSION['p3_qP10_2'] = trim(htmlspecialchars($_POST['p3_qP10_2']));
  163. $info['p3_qP11'] = $_SESSION['p3_qP11'] = trim(htmlspecialchars($_POST['p3_qP11']));
  164.  
  165. $data = Array (
  166. 'p3_q1' => $info['p3_q1'],
  167. 'p3_q1_y1' => $info['p3_q1_y1'],
  168. 'p3_q1_y2' => $info['p3_q1_y2'],
  169. 'p3_q2' => $info['p3_q2'],
  170. 'p3_q3' => $info['p3_q3'],
  171. 'p3_q4' => $info['p3_q4'],
  172. 'p3_q5' => $info['p3_q5'],
  173. 'p3_q6' => $info['p3_q6'],
  174. 'p3_q7' => $info['p3_q7'],
  175. 'p3_q8' => $info['p3_q8'],
  176. 'p3_q8_1' => $info['p3_q8_1'],
  177. 'p3_q8_2' => $info['p3_q8_2'],
  178. 'p3_q8_3' => $info['p3_q8_3'],
  179. 'p3_q8_4' => $info['p3_q8_4'],
  180. 'p3_q8_5' => $info['p3_q8_5'],
  181. 'p3_q8_6' => $info['p3_q8_6'],
  182. 'p3_q9_1' => $info['p3_q9_1'],
  183. 'p3_q9_2' => $info['p3_q9_2'],
  184. 'p3_q9_3' => $info['p3_q9_3'],
  185. 'p3_q9_4' => $info['p3_q9_4'],
  186. 'p3_q10_1' => $info['p3_q10_1'],
  187. 'p3_q10_2' => $info['p3_q10_2'],
  188. 'p3_q11' => $info['p3_q11'],
  189. 'p3_qP1' => $info['p3_qP1'],
  190. 'p3_qP2' => $info['p3_qP2'],
  191. 'p3_qP3' => $info['p3_qP3'],
  192. 'p3_qP4' => $info['p3_qP4'],
  193. 'p3_qP5' => $info['p3_qP5'],
  194. 'p3_qP6' => $info['p3_qP6'],
  195. 'p3_qP7' => $info['p3_qP7'],
  196. 'p3_qP8' => $info['p3_qP8'],
  197. 'p3_qP8_1' => $info['p3_qP8_1'],
  198. 'p3_qP8_2' => $info['p3_qP8_2'],
  199. 'p3_qP8_3' => $info['p3_qP8_3'],
  200. 'p3_qP8_4' => $info['p3_qP8_4'],
  201. 'p3_qP8_5' => $info['p3_qP8_5'],
  202. 'p3_qP8_6' => $info['p3_qP8_6'],
  203. 'p3_qP9_1' => $info['p3_qP9_1'],
  204. 'p3_qP9_2' => $info['p3_qP9_2'],
  205. 'p3_qP9_3' => $info['p3_qP9_3'],
  206. 'p3_qP9_4' => $info['p3_qP9_4'],
  207. 'p3_qP10_1' => $info['p3_qP10_1'],
  208. 'p3_qP10_2' => $info['p3_qP10_2'],
  209. 'p3_qP11' => $info['p3_qP11']
  210. );
  211.  
  212.  
  213. #echo $_SESSION['id'];
  214. $db->where ('id_number', $_SESSION['id']);#EDIT
  215. if ($db->update ('info', $data)){
  216.  
  217. }
  218.  
  219. else
  220. echo 'עדכון הנתונים במסד נכשל: ' . $db->getLastError();
  221.  
  222. $data = Array ( 'level' => '3');
  223. $db->where ('id_number', $_SESSION['id']);
  224. if ($db->update ('info', $data))
  225. echo $db->count . ' records were updated';
  226. else
  227. echo 'update failed: ' . $db->getLastError();
  228.  
  229. include ('page4.php');
  230.  
  231. }
  232. elseif ($_SESSION['level'] == 3) {
  233. $_SESSION['level'] = 4;
  234.  
  235. $info['p4_q1'] = $_SESSION['p4_q1'] = trim(htmlspecialchars($_POST['p4_q1']));
  236. $info['p4_q2'] = $_SESSION['p4_q2'] = trim(htmlspecialchars($_POST['p4_q2']));
  237. $info['p4_q3'] = $_SESSION['p4_q3'] = trim(htmlspecialchars($_POST['p4_q3']));
  238. $info['p4_q4'] = $_SESSION['p4_q4'] = trim(htmlspecialchars($_POST['p4_q4']));
  239. $info['p4_q5'] = $_SESSION['p4_q5'] = trim(htmlspecialchars($_POST['p4_q5']));
  240. $info['p4_q6'] = $_SESSION['p4_q6'] = trim(htmlspecialchars($_POST['p4_q6']));
  241. $info['p4_q7'] = $_SESSION['p4_q7'] = trim(htmlspecialchars($_POST['p4_q7']));
  242. $info['p4_q8'] = $_SESSION['p4_q8'] = trim(htmlspecialchars($_POST['p4_q8']));
  243. $info['p4_q9'] = $_SESSION['p4_q9'] = trim(htmlspecialchars($_POST['p4_q9']));
  244. $info['p4_q10'] = $_SESSION['p4_q10'] = trim(htmlspecialchars($_POST['p4_q10']));
  245. $info['p4_q11'] = $_SESSION['p4_q11'] = trim(htmlspecialchars($_POST['p4_q11']));
  246. $info['p4_q12'] = $_SESSION['p4_q12'] = trim(htmlspecialchars($_POST['p4_q12']));
  247. $info['p4_q13'] = $_SESSION['p4_q13'] = trim(htmlspecialchars($_POST['p4_q13']));
  248. $info['p4_q14'] = $_SESSION['p4_q14'] = trim(htmlspecialchars($_POST['p4_q14']));
  249. $info['p4_q15'] = $_SESSION['p4_q15'] = trim(htmlspecialchars($_POST['p4_q15']));
  250. $info['p4_q16'] = $_SESSION['p4_q16'] = trim(htmlspecialchars($_POST['p4_q16']));
  251. $info['p4_q17'] = $_SESSION['p4_q17'] = trim(htmlspecialchars($_POST['p4_q17']));
  252. $info['p4_q18'] = $_SESSION['p4_q18'] = trim(htmlspecialchars($_POST['p4_q18']));
  253. $info['p4_q19'] = $_SESSION['p4_q19'] = trim(htmlspecialchars($_POST['p4_q19']));
  254. $info['p4_q20'] = $_SESSION['p4_q20'] = trim(htmlspecialchars($_POST['p4_q20']));
  255. $info['p4_q21'] = $_SESSION['p4_q21'] = trim(htmlspecialchars($_POST['p4_q21']));
  256.  
  257. $info['p4_qP1'] = $_SESSION['p4_qP1'] = trim(htmlspecialchars($_POST['p4_qP1']));
  258. $info['p4_qP2'] = $_SESSION['p4_qP2'] = trim(htmlspecialchars($_POST['p4_qP2']));
  259. $info['p4_qP3'] = $_SESSION['p4_qP3'] = trim(htmlspecialchars($_POST['p4_qP3']));
  260. $info['p4_qP4'] = $_SESSION['p4_qP4'] = trim(htmlspecialchars($_POST['p4_qP4']));
  261. $info['p4_qP5'] = $_SESSION['p4_qP5'] = trim(htmlspecialchars($_POST['p4_qP5']));
  262. $info['p4_qP6'] = $_SESSION['p4_qP6'] = trim(htmlspecialchars($_POST['p4_qP6']));
  263. $info['p4_qP7'] = $_SESSION['p4_qP7'] = trim(htmlspecialchars($_POST['p4_qP7']));
  264. $info['p4_qP8'] = $_SESSION['p4_qP8'] = trim(htmlspecialchars($_POST['p4_qP8']));
  265. $info['p4_qP9'] = $_SESSION['p4_qP9'] = trim(htmlspecialchars($_POST['p4_qP9']));
  266. $info['p4_qP10'] = $_SESSION['p4_qP10'] = trim(htmlspecialchars($_POST['p4_qP10']));
  267. $info['p4_qP11'] = $_SESSION['p4_qP11'] = trim(htmlspecialchars($_POST['p4_qP11']));
  268. $info['p4_qP12'] = $_SESSION['p4_qP12'] = trim(htmlspecialchars($_POST['p4_qP12']));
  269. $info['p4_qP13'] = $_SESSION['p4_qP13'] = trim(htmlspecialchars($_POST['p4_qP13']));
  270. $info['p4_qP14'] = $_SESSION['p4_qP14'] = trim(htmlspecialchars($_POST['p4_qP14']));
  271. $info['p4_qP15'] = $_SESSION['p4_qP15'] = trim(htmlspecialchars($_POST['p4_qP15']));
  272. $info['p4_qP16'] = $_SESSION['p4_qP16'] = trim(htmlspecialchars($_POST['p4_qP16']));
  273. $info['p4_qP17'] = $_SESSION['p4_qP17'] = trim(htmlspecialchars($_POST['p4_qP17']));
  274. $info['p4_qP18'] = $_SESSION['p4_qP18'] = trim(htmlspecialchars($_POST['p4_qP18']));
  275. $info['p4_qP19'] = $_SESSION['p4_qP19'] = trim(htmlspecialchars($_POST['p4_qP19']));
  276. $info['p4_qP20'] = $_SESSION['p4_qP20'] = trim(htmlspecialchars($_POST['p4_qP20']));
  277. $info['p4_qP21'] = $_SESSION['p4_qP21'] = trim(htmlspecialchars($_POST['p4_qP21']));
  278. $info['sfar_1'] = $_SESSION['sfar_1'] = trim(htmlspecialchars($_POST['sfar_1']));
  279. $info['sfar1_y'] = $_SESSION['sfar1_y'] = trim(htmlspecialchars($_POST['sfar1_y']));
  280. $info['sfar1_y2'] = $_SESSION['sfar1_y2'] = trim(htmlspecialchars($_POST['sfar1_y2']));
  281. $info['sfar_2'] = $_SESSION['sfar_2'] = trim(htmlspecialchars($_POST['sfar_2']));
  282. $info['sfar2_y'] = $_SESSION['sfar2_y'] = trim(htmlspecialchars($_POST['sfar2_y']));
  283. $info['sfar2_y2'] = $_SESSION['sfar2_y2'] = trim(htmlspecialchars($_POST['sfar2_y2']));
  284.  
  285. $data = Array (
  286. 'p4_q1' => $info['p4_q1'],
  287. 'p4_q2' => $info['p4_q2'],
  288. 'p4_q3' => $info['p4_q3'],
  289. 'p4_q4' => $info['p4_q4'],
  290. 'p4_q5' => $info['p4_q5'],
  291. 'p4_q6' => $info['p4_q6'],
  292. 'p4_q7' => $info['p4_q7'],
  293. 'p4_q8' => $info['p4_q8'],
  294. 'p4_q9' => $info['p4_q9'],
  295. 'p4_q10' => $info['p4_q10'],
  296. 'p4_q11' => $info['p4_q11'],
  297. 'p4_q12' => $info['p4_q12'],
  298. 'p4_q13' => $info['p4_q13'],
  299. 'p4_q14' => $info['p4_q14'],
  300. 'p4_q15' => $info['p4_q15'],
  301. 'p4_q16' => $info['p4_q16'],
  302. 'p4_q17' => $info['p4_q17'],
  303. 'p4_q18' => $info['p4_q18'],
  304. 'p4_q19' => $info['p4_q19'],
  305. 'p4_q20' => $info['p4_q20'],
  306. 'p4_q21' => $info['p4_q21'],
  307. 'p4_qP1' => $info['p4_qP1'],
  308. 'p4_qP2' => $info['p4_qP2'],
  309. 'p4_qP3' => $info['p4_qP3'],
  310. 'p4_qP4' => $info['p4_qP4'],
  311. 'p4_qP5' => $info['p4_qP5'],
  312. 'p4_qP6' => $info['p4_qP6'],
  313. 'p4_qP7' => $info['p4_qP7'],
  314. 'p4_qP8' => $info['p4_qP8'],
  315. 'p4_qP9' => $info['p4_qP9'],
  316. 'p4_qP10' => $info['p4_qP10'],
  317. 'p4_qP11' => $info['p4_qP11'],
  318. 'p4_qP12' => $info['p4_qP12'],
  319. 'p4_qP13' => $info['p4_qP13'],
  320. 'p4_qP14' => $info['p4_qP14'],
  321. 'p4_qP15' => $info['p4_qP15'],
  322. 'p4_qP16' => $info['p4_qP16'],
  323. 'p4_qP17' => $info['p4_qP17'],
  324. 'p4_qP18' => $info['p4_qP18'],
  325. 'p4_qP19' => $info['p4_qP19'],
  326. 'p4_qP20' => $info['p4_qP20'],
  327. 'p4_qP21' => $info['p4_qP21'],
  328. 'sfar_1' => $info['sfar_1'],
  329. 'sfar1_y' => $info['sfar1_y'],
  330. 'sfar1_y2' => $info['sfar1_y2'],
  331. 'sfar_2' => $info['sfar_2'],
  332. 'sfar2_y' => $info['sfar2_y'],
  333. 'sfar2_y2' => $info['sfar2_y2']
  334.  
  335.  
  336. );
  337.  
  338.  
  339. #echo $_SESSION['id'];
  340. $db->where ('id_number', $_SESSION['id']);#EDIT
  341. if ($db->update ('info', $data)){
  342.  
  343. }
  344.  
  345. else
  346. echo 'עדכון הנתונים במסד נכשל: ' . $db->getLastError();
  347.  
  348. $data = Array ( 'level' => '4');
  349. $db->where ('id_number', $_SESSION['id']);
  350. if ($db->update ('info', $data))
  351. echo $db->count . ' records were updated';
  352. else
  353. echo 'update failed: ' . $db->getLastError();
  354.  
  355. include ('page5.php');
  356.  
  357. }
  358.  
  359. elseif ($_SESSION['level'] == 4) {
  360. $_SESSION['level'] = 5;
  361.  
  362. function date1(){
  363. $dt = new DateTime();
  364. echo $dt->format('Y-m-d H:i:s');
  365. }
  366.  
  367. $info['p4_q1'] = $_SESSION['p4_q1'] = trim(htmlspecialchars($_POST['p4_q1']));
  368. $info['p5_q1'] = $_SESSION['p5_q1'] = trim(htmlspecialchars($_POST['p5_q1']));
  369. $info['p5_q2'] = $_SESSION['p5_q2'] = trim(htmlspecialchars($_POST['p5_q2']));
  370. $info['p5_q3'] = $_SESSION['p5_q3'] = trim(htmlspecialchars($_POST['p5_q3']));
  371. $info['p5_q4'] = $_SESSION['p5_q4'] = trim(htmlspecialchars($_POST['p5_q4']));
  372. $info['p5_q5'] = $_SESSION['p5_q5'] = trim(htmlspecialchars($_POST['p5_q5']));
  373. $info['p5_qP1'] = $_SESSION['p5_qP1'] = trim(htmlspecialchars($_POST['p5_qP1']));
  374. $info['p5_qP2'] = $_SESSION['p5_qP2'] = trim(htmlspecialchars($_POST['p5_qP2']));
  375. $info['p5_qP3'] = $_SESSION['p5_qP3'] = trim(htmlspecialchars($_POST['p5_qP3']));
  376. $info['p5_qP4'] = $_SESSION['p5_qP4'] = trim(htmlspecialchars($_POST['p5_qP4']));
  377. $info['p5_qP5'] = $_SESSION['p5_qP5'] = trim(htmlspecialchars($_POST['p5_qP5']));
  378. $date = date('Y-m-d H:i:s');
  379.  
  380.  
  381. $data = Array (
  382. 'p5_q1' => $info['p5_q1'],
  383. 'p5_q2' => $info['p5_q2'],
  384. 'p5_q3' => $info['p5_q3'],
  385. 'p5_q4' => $info['p5_q4'],
  386. 'p5_q5' => $info['p5_q5'],
  387. 'p5_qP1' => $info['p5_qP1'],
  388. 'p5_qP2' => $info['p5_qP2'],
  389. 'p5_qP3' => $info['p5_qP3'],
  390. 'p5_qP4' => $info['p5_qP4'],
  391. 'p5_qP5' => $info['p5_qP5'],
  392. 'timestamp' => $date
  393. );
  394.  
  395. #echo $_SESSION['id'];
  396. $db->where ('id_number', $_SESSION['id']);#EDIT
  397. if ($db->update ('info', $data)){
  398.  
  399. }
  400.  
  401. else
  402. echo 'עדכון הנתונים במסד נכשל: ' . $db->getLastError();
  403.  
  404. $data = Array ( 'level' => '5');
  405. $db->where ('id_number', $_SESSION['id']);
  406. if ($db->update ('info', $data))
  407. echo $db->count . ' records were updated';
  408. else
  409. echo 'update failed: ' . $db->getLastError();
  410.  
  411. $message = '<html>
  412. <head>
  413. <style>
  414. table, th, td {
  415. border: 1px solid black;
  416. border-collapse: collapse;
  417. }
  418. th, td {
  419. padding: 5px;
  420. }
  421.  
  422. </style>
  423.  
  424. </head>
  425. <body dir="rtl">';
  426. $message .= '<table style="width:80%">';
  427. $message .= '<tr>
  428. <th><span style="font-size:18px; font-weight:bold; text-align:center; display:block;">פרטי הלקוח</span></th>
  429. <th><span style="font-size:18px; font-weight:bold; text-align:center; display:block;">אודותיו</span></th>
  430. <th><span style="font-size:18px; font-weight:bold; text-align:center; display:block;">אודות בן/בת הזוג</span></th>
  431. </tr>';
  432. $message .='<tr>
  433. <td>שם הלקוח:</td>
  434. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['name'] ." ". $db->where('id_number', $_SESSION['id'])->getOne('info')['last_name'] . '</td>
  435. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  436. </tr>';
  437. $message .='<tr>
  438. <td>תאריך מילוי:</td>
  439. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['timestamp'] . '</td>
  440. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  441. </tr>';
  442. $message .='<tr>
  443. <td>מספר טלפון:</td>
  444. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['phone']. '</td>
  445. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  446. </tr>';
  447. $message .='<tr>
  448. <td>כתובת:</td>
  449. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['address']. '</td>
  450. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  451. </tr>';
  452. $message .='<tr>
  453. <td>דואר אלקטרוני:</td>
  454. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['email']. '</td>
  455. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  456. </tr>';
  457. $message .='<tr>
  458. <td>תעודת זהות:</td>
  459. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['id_number']. '</td>
  460. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  461. </tr>';
  462. $message .='<tr>
  463. <td>תאריך לידה:</td>
  464. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['birth_date']. '</td>
  465. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  466. </tr>';
  467. $message .='<tr>
  468. <td></td>
  469. <td><span style="font-size:18px; font-weight:bold; text-align:center; display:block;"> סטאטוס מילוי פרטים</span></td>
  470. <td></td>
  471. </tr>';
  472. $message .='<tr>
  473. <td></td>
  474. <td><span style="font-size:16px; font-weight:bold; text-align:center; display:block; color:red; text-decoration:underline;">מילוי פרטים אישיים</span></td>
  475. <td></td>
  476. </tr>';
  477. // עמוד שני
  478. $message .='<tr>
  479. <td>שם מלא:</td>
  480. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['name']. " " . $db->where('id_number', $_SESSION['id'])->getOne('info')['last_name'] . '</td>
  481. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['name_2']. " " . $db->where('id_number', $_SESSION['id'])->getOne('info')['lastname_2']. '</td>
  482. </tr>';
  483. $message .='<tr>
  484. <td>מספר תעודת זהות:</td>
  485. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['id_number']. '</td>
  486. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['id_number_2']. '</td>
  487. </tr>';
  488. $message .='<tr>
  489. <td>כתובת:</td>
  490. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['address']. '</td>
  491. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['address_2']. '</td>
  492. </tr>';
  493. $message .='<tr>
  494. <td>טלפון/טלפון נייד:</td>
  495. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['phone']. '</td>
  496. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['phone_2']. '</td>
  497. </tr>';
  498. $message .='<tr>
  499. <td>דואר אלקטרוני:</td>
  500. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['email']. '</td>
  501. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  502. </tr>';
  503. $message .='<tr>
  504. <td>שם האב:</td>
  505. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['dadname']. '</td>
  506. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  507. </tr>';
  508. $message .='<tr>
  509. <td>תאריך לידה:</td>
  510. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['birth_date']. '</td>
  511. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['date_2']. '</td>
  512. </tr>';
  513. $message .='<tr>
  514. <td>עיסוק עיקרי:</td>
  515. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['company']. '</td>
  516. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['company_2']. '</td>
  517. </tr>';
  518. $message .='<tr>
  519. <td>סטטוס משפחתי:</td>
  520. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['status']. '</td>
  521. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['status_2']. '</td>
  522. </tr>';
  523. $message .='<tr>
  524. <td>תאריך נישואים:</td>
  525. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['date_n'] . $db->where('id_number', $_SESSION['id'])->getOne('info')['date_n_2'] . $db->where('id_number', $_SESSION['id'])->getOne('info')['date_n_a'] . '</td>
  526. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  527. </tr>';
  528. $message .='<tr>
  529. <td>תאריך גירושים:</td>
  530. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['date_g']. '</td>
  531. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  532. </tr>';
  533. $message .='<tr>
  534. <td>תאריך התאלמנות:</td>
  535. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['date_a']. '</td>
  536. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  537. </tr>';
  538.  
  539. $message .='<tr>
  540. <td></td>
  541. <td><span style="font-size:16px; font-weight:bold; text-align:center; display:block; color:red; text-decoration:underline;">מילוי אירועים בעבודה</span></td>
  542. <td></td>
  543. </tr>';
  544. // עמוד שלישי
  545. $message .='<tr>
  546. <td>האם בין השנים 2014-2009 הגשת בקשת להחזר מס ?</td>
  547. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q1']. "<br>" . "משנה:" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q1_y1'] . "<br>" . "עד שנה:" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q1_y2'] . '</td>
  548. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP1']. '</td>
  549. </tr>';
  550. $message .='<tr>
  551. <td>האם בין השנים 2014-2009 היית שכיר/ה </td>
  552. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q2']. '</td>
  553. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP2']. '</td>
  554. </tr>';
  555. $message .='<tr>
  556. <td>האם בין השנים 2014-2009 היית גמלאי ו/או יצאת לפנסיה</td>
  557. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q3']. '</td>
  558. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP3']. '</td>
  559. </tr>';
  560. $message .='<tr>
  561. <td>האם בין השנים 2014-2009 שילמת מס הכנסה? </td>
  562. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q4']. '</td>
  563. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP4']. '</td>
  564. </tr>';
  565. $message .='<tr>
  566. <td>הרווחת מעל 7000 ש"ח</td>
  567. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q5']. '</td>
  568. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP5']. '</td>
  569. </tr>';
  570. $message .='<tr>
  571. <td>האם בין השנים 2014-2009 היית לך תקופה מסויימת בה לא עבדת? </td>
  572. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q6']. '</td>
  573. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP6']. '</td>
  574. </tr>';
  575. $message .='<tr>
  576. <td>האם בין השנים 2014-2009 החלפת מקומות עבודה? </td>
  577. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q7']. '</td>
  578. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP7']. '</td>
  579. </tr>';
  580. $message .='<tr>
  581. <td>האם בין השנים 2014-2009 היית לך הכנסה ממספר מקורות? </td>
  582. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q8']. "<br><br>" . "בשנים: " . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q8_1'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q8_2'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q8_3'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q8_4'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q8_5'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q8_6'] . "<br>" . '</td>
  583. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP8']. "<br><br>" . "בשנים: " . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP8_1'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP8_2'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP8_3'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP8_4'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP8_5'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP8_6'] . "<br>" . '</td>
  584. </tr>';
  585. $message .='<tr>
  586. <td>האם בין השנים 2014-2009 קיבלת: דמי אבטלה, דמי לידה, דמי מילואים, דמי פיצויים (נא לסמן)</td>
  587. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q9'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q9_1'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q9_2'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q9_3'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q9_4'] . '</td>
  588. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q9'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP9_1'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP9_2'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP9_3'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP9_4'] . '</td>
  589. </tr>';
  590. $message .='<tr>
  591. <td>האם בין השנים 2014-2009 קיבלת: פרישה, פיצויים (נא לסמן)</td>
  592. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q10_1'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q10_2'] . '</td>
  593. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP10_1'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP10_2'] . '</td>
  594. </tr>';
  595.  
  596. $message .='<tr>
  597. <td>האם פרסת פיצויים לאחר 2004 ? </td>
  598. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q11']. '</td>
  599. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP11']. '</td>
  600. </tr>';
  601. $message .='<tr>
  602. <td></td>
  603. <td><span style="font-size:16px; font-weight:bold; text-align:center; display:block; color:red; text-decoration:underline;">מילוי אירועים אישיים</span></td>
  604. <td></td>
  605. </tr>';
  606. // עמוד רביעי
  607. $message .='<tr>
  608. <td>האם בין השנים 2014-2009 פדית קופ"ג לפני מועד הפרעון החוקי </td>
  609. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q1']. '</td>
  610. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP1']. '</td>
  611. </tr>';
  612. $message .='<tr>
  613. <td>האם בין השנים 2014-2009 סחרת בניירות ערך? </td>
  614. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q2']. '</td>
  615. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP2']. '</td>
  616. </tr>';
  617. $message .='<tr>
  618. <td>האם בין השנים 2014-2009 מימשת אופציות?</td>
  619. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q3']. '</td>
  620. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP3']. '</td>
  621. </tr>';
  622. $message .='<tr>
  623. <td>האם סיימת תואר אקדמאי משנת 2006 ואילך ? (לא כולל קורסים והשתלמויות)</td>
  624. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q4']. '</td>
  625. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP4']. '</td>
  626. </tr>';
  627. $message .='<tr>
  628. <td>האם עלית לארץ משנת 2006 ואילך?</td>
  629. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q5']. '</td>
  630. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP5']. '</td>
  631. </tr>';
  632. $message .='<tr>
  633. <td>האם השתחרתת משירות חובה לאחר 2006 ?</td>
  634. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q6']. '</td>
  635. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP6']. '</td>
  636. </tr>';
  637. $message .='<tr>
  638. <td>האם בין השנים 2014-2009 תרמת למוסד ציבורי מעל 300 ש"ח?</td>
  639. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q7']. '</td>
  640. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP7']. '</td>
  641. </tr>';
  642. $message .='<tr>
  643. <td>האם בין השנים 2014-2009 הייתה לך משכנתא?</td>
  644. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q8']. '</td>
  645. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP8']. '</td>
  646. </tr>';
  647. $message .='<tr>
  648. <td>האם בין השנים 2014-2009 שילמת באופן עצמאי לביטוח חיים ו/או אבדן כושר עבודה שלא דרך המשכורת?</td>
  649. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q9']. '</td>
  650. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP9']. '</td>
  651. </tr>';
  652. $message .='<tr>
  653. <td>האם בין השנים 2014-2009 הפקדת באופן עצמאי לקופ"ג או לפנסיה עבורך ו/או עבור אחד מבני המשפחה שלא דרך המשכורת? </td>
  654. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q10']. '</td>
  655. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP10']. '</td>
  656. </tr>';
  657. $message .='<tr>
  658. <td>האם בין השנים 2014-2009 היו לך הוצאות להנצחת קרוב משפחה שנספה במערכה או בפעולת איבה? </td>
  659. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q11']. '</td>
  660. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP11']. '</td>
  661. </tr>';
  662. $message .='<tr>
  663. <td>האם בין השנים 2014-2009 שילמת מזונות? </td>
  664. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q12']. '</td>
  665. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP12']. '</td>
  666. </tr>';
  667. $message .='<tr>
  668. <td>האם בין השנים 2014-2009 היית אב/אם חד הורי? </td>
  669. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q13']. '</td>
  670. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP13']. '</td>
  671. </tr>';
  672. $message .='<tr>
  673. <td>האם בין השנים 2014-2009 ילדייך הנם מתחת לגיל 18?</td>
  674. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q14']. '</td>
  675. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP14']. '</td>
  676. </tr>';
  677. $message .='<tr>
  678. <td>האם בין השנים 2014-2009 גרת ביישוב ספר?</td>
  679. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q15'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['sfar_1'] . "<br>" . "משנה: " . $db->where('id_number', $_SESSION['id'])->getOne('info')['sfar1_y'] . "<br>" . "עד שנה: " . $db->where('id_number', $_SESSION['id'])->getOne('info')['sfar1_y2'] . '</td>
  680. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP15'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['sfar_2'] . "<br>" . "משנה: " . $db->where('id_number', $_SESSION['id'])->getOne('info')['sfar2_y'] . "<br>" . "עד שנה: " . $db->where('id_number', $_SESSION['id'])->getOne('info')['sfar2_y2'] . '</td>
  681. </tr>';
  682. $message .='<tr>
  683. <td>האם בין השנים 2014-2009 היית עצמאי? </td>
  684. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q16']. '</td>
  685. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP16']. '</td>
  686. </tr>';
  687. $message .='<tr>
  688. <td>האם בין השנים 2014-2009 היה לך הפסד מעסק? </td>
  689. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q17']. '</td>
  690. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP17']. '</td>
  691. </tr>';
  692. $message .='<tr>
  693. <td>האם בין השנים 2014-2009 היו לך הכנסות מחו"ל? </td>
  694. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q18']. '</td>
  695. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP18']. '</td>
  696. </tr>';
  697. $message .='<tr>
  698. <td>האם בין השנים 2014-2009 שילמת מס שבח בגין מכירת נכס?(לא מס רכישה)</td>
  699. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q19']. '</td>
  700. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP19']. '</td>
  701. </tr>';
  702. $message .='<tr>
  703. <td>האם בין השנים 2014-2009 קיבלת מענק חד פעמי ולא במשכורת? </td>
  704. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q20']. '</td>
  705. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP20']. '</td>
  706. </tr>';
  707. $message .='<tr>
  708. <td>האם בין השנים 2014-2009 היו לך הכנסות משכ"ד בארץ ו/או בחו"ל? </td>
  709. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q21']. '</td>
  710. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP21']. '</td>
  711. </tr>';
  712. $message .='<tr>
  713. <td></td>
  714. <td><span style="font-size:16px; font-weight:bold; text-align:center; display:block; color:red; text-decoration:underline;">מילוי אירועים רפואים</span></td>
  715. <td></td>
  716. </tr>';
  717. //עמוד חמישי
  718. $message .='<tr>
  719. <td>האם בין השנים 2009-2014 היה לך ילד לקוי למידה? (לרבות ADHD,ADD)</td>
  720. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_q1']. '</td>
  721. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_qP1']. '</td>
  722. </tr>';
  723. $message .='<tr>
  724. <td>האם בין השנים 2009-2014 היה לך ילד שסבל מקשיי התפתחות, מפגר, משותק, עיוור או חולה מחלה קשה? (לרבות חרש-אילם, חולה טלסמיה, דיסאוטונומיה, סיסטיק פיברוזיס וכד).</td>
  725. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_q2']. '</td>
  726. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_qP2']. '</td>
  727. </tr>';
  728. $message .='<tr>
  729. <td>האם בין השנים 2009-2014 ילדך היה זכאי לקיצבת נכות? (גם מעל גיל 18)</td>
  730. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_q3']. '</td>
  731. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_qP3']. '</td>
  732. </tr>';
  733. $message .='<tr>
  734. <td>האם עברת אירוע רפואי קשה וועדה רפואי ופנית לביטוח לאומי?</td>
  735. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_q4']. '</td>
  736. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_qP4']. '</td>
  737. </tr>';
  738. $message .='<tr>
  739. <td>האם בין השנים 2009-2014 היו לך הכנסות פטורות ממס כגון קיצבת שארים/ נכות (75% נכות ומעלה)?</td>
  740. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_q5']. '</td>
  741. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_qP5']. '</td>
  742. </tr>';
  743.  
  744. $message .= "</table>";
  745. $message .= "</body></html>";
  746.  
  747.  
  748. //------------------------------PDF-------------------------------//
  749.  
  750. require_once('tcpdf/tcpdf.php');
  751. $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
  752.  
  753. $pdf->setHeaderData('logo.png',33,'','',array(0,0,0), array(255,255,255) );
  754.  
  755. $pdf->SetMargins(PDF_MARGIN_LEFT, 50, PDF_MARGIN_RIGHT);
  756. $pdf->SetHeaderMargin(10);
  757.  
  758.  
  759.  
  760. include('tcpdf/examples/lang/heb.php');
  761. $pdf->setLanguageArray($l);
  762.  
  763.  
  764.  
  765.  
  766. $fontname = TCPDF_FONTS::addTTFfont('tcpdf/examples/fonts/arial.ttf', 'TrueTypeUnicode', '', 20);
  767. $fontname = TCPDF_FONTS::addTTFfont('tcpdf/examples/fonts/arialbd.ttf', 'TrueTypeUnicode', '', 20);
  768. $pdf->SetFont('arial', '', 14);
  769. $pdf->AddPage();
  770. $html = '<html>
  771. <head></head>
  772. <body>
  773. <table border="1">
  774. <thead>
  775. <tr>
  776. <th><span style="font-size:16px; font-weight:bold; text-align:center; display:block;">פרטי הלקוח</span></th>
  777. <th><span style="font-size:16px; font-weight:bold; text-align:center; display:block;">אודותיו</span></th>
  778. <th><span style="font-size:16px; font-weight:bold; text-align:center; display:block;">אודות בן/בת הזוג</span></th>
  779. </tr>
  780. </thead>
  781. <tbody>
  782. <tr>
  783. <td>שם הלקוח:</td>
  784. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['name'] ." ". $db->where('id_number', $_SESSION['id'])->getOne('info')['last_name'] . '</td>
  785. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  786. </tr>
  787. <tr>
  788. <td>תאריך מילוי:</td>
  789. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['timestamp'] . '</td>
  790. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  791. </tr>
  792. <tr>
  793. <td>מספר טלפון:</td>
  794. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['phone']. '</td>
  795. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  796. </tr>
  797. <tr>
  798. <td>כתובת:</td>
  799. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['address']. '</td>
  800. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  801. </tr>
  802. <tr>
  803. <td>דואר אלקטרוני:</td>
  804. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['email']. '</td>
  805. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  806. </tr>
  807. <tr>
  808. <td>תעודת זהות:</td>
  809. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['id_number']. '</td>
  810. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  811. </tr>
  812. <tr>
  813. <td>תאריך לידה:</td>
  814. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['birth_date']. '</td>
  815. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  816. </tr>
  817. <tr>
  818. <td></td>
  819. <td><span style="font-size:18px; font-weight:bold; text-align:center; display:block;"> סטאטוס מילוי פרטים</span></td>
  820. <td></td>
  821. </tr>
  822. <tr>
  823. <td></td>
  824. <td><span style="font-size:16px; font-weight:bold; text-align:center; display:block; color:red; text-decoration:underline;">מילוי פרטים אישיים</span></td>
  825. <td></td>
  826. </tr>
  827. <tr>
  828. <td>שם מלא:</td>
  829. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['name']. " " . $db->where('id_number', $_SESSION['id'])->getOne('info')['last_name'] . '</td>
  830. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['name_2']. " " . $db->where('id_number', $_SESSION['id'])->getOne('info')['lastname_2']. '</td>
  831. </tr>
  832. <tr>
  833. <td>מספר תעודת זהות:</td>
  834. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['id_number']. '</td>
  835. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['id_number_2']. '</td>
  836. </tr>
  837. <tr>
  838. <td>כתובת:</td>
  839. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['address']. '</td>
  840. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['address_2']. '</td>
  841. </tr>
  842. <tr>
  843. <td>טלפון/טלפון נייד:</td>
  844. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['phone']. '</td>
  845. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['phone_2']. '</td>
  846. </tr>
  847. <tr>
  848. <td>דואר אלקטרוני:</td>
  849. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['email']. '</td>
  850. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  851. </tr>
  852. <tr>
  853. <td>שם האב:</td>
  854. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['dadname']. '</td>
  855. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  856. </tr>
  857. <tr>
  858. <td>תאריך לידה:</td>
  859. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['birth_date']. '</td>
  860. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['date_2']. '</td>
  861. </tr>
  862. <tr>
  863. <td>עיסוק עיקרי:</td>
  864. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['company']. '</td>
  865. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['company_2']. '</td>
  866. </tr>
  867. <tr>
  868. <td>סטטוס משפחתי:</td>
  869. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['status']. '</td>
  870. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['status_2']. '</td>
  871. </tr>
  872. <tr>
  873. <td>תאריך נישואים:</td>
  874. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['date_n'] . $db->where('id_number', $_SESSION['id'])->getOne('info')['date_n_2'] . $db->where('id_number', $_SESSION['id'])->getOne('info')['date_n_a'] . '</td>
  875. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  876. </tr>
  877. <tr>
  878. <td>תאריך גירושים:</td>
  879. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['date_g']. '</td>
  880. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  881. </tr>
  882. <tr>
  883. <td>תאריך התאלמנות:</td>
  884. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['date_a']. '</td>
  885. <td><span style="font-weight:bold; text-align:center; display:block; text-decoration:underline;">-לא רלוונטי-</span></td>
  886. </tr>
  887. <tr>
  888. <td></td>
  889. <td><span style="font-size:16px; font-weight:bold; text-align:center; display:block; color:red; text-decoration:underline;">מילוי אירועים בעבודה</span></td>
  890. <td></td>
  891. </tr>
  892.  
  893. <tr>
  894. <td>האם בין השנים 2014-2009 הגשת בקשת להחזר מס ?</td>
  895. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q1']. "<br>" . "משנה:" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q1_y1'] . "<br>" . "עד שנה:" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q1_y2'] . '</td>
  896. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP1']. '</td>
  897. </tr>
  898. <tr>
  899. <td>האם בין השנים 2014-2009 היית שכיר/ה </td>
  900. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q2']. '</td>
  901. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP2']. '</td>
  902. </tr>
  903. <tr>
  904. <td>האם בין השנים 2014-2009 היית גמלאי ו/או יצאת לפנסיה</td>
  905. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q3']. '</td>
  906. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP3']. '</td>
  907. </tr>
  908. <tr>
  909. <td>האם בין השנים 2014-2009 שילמת מס הכנסה? </td>
  910. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q4']. '</td>
  911. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP4']. '</td>
  912. </tr>
  913. <tr>
  914. <td>הרווחת מעל 7000 ש"ח</td>
  915. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q5']. '</td>
  916. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP5']. '</td>
  917. </tr>
  918. <tr>
  919. <td>האם בין השנים 2014-2009 היית לך תקופה מסויימת בה לא עבדת? </td>
  920. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q6']. '</td>
  921. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP6']. '</td>
  922. </tr>
  923. <tr>
  924. <td>האם בין השנים 2014-2009 החלפת מקומות עבודה? </td>
  925. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q7']. '</td>
  926. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP7']. '</td>
  927. </tr>
  928. <tr>
  929. <td>האם בין השנים 2014-2009 היית לך הכנסה ממספר מקורות? </td>
  930. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q8']. "<br><br>" . "בשנים: " . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q8_1'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q8_2'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q8_3'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q8_4'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q8_5'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q8_6'] . "<br>" . '</td>
  931. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP8']. "<br><br>" . "בשנים: " . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP8_1'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP8_2'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP8_3'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP8_4'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP8_5'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP8_6'] . "<br>" . '</td>
  932. </tr>
  933. <tr>
  934. <td>האם בין השנים 2014-2009 קיבלת: דמי אבטלה, דמי לידה, דמי מילואים, דמי פיצויים (נא לסמן)</td>
  935. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q9'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q9_1'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q9_2'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q9_3'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q9_4'] . '</td>
  936. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q9'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP9_1'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP9_2'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP9_3'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP9_4'] . '</td>
  937. </tr>
  938. <tr>
  939. <td>האם בין השנים 2014-2009 קיבלת: פרישה, פיצויים (נא לסמן)</td>
  940. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q10_1'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q10_2'] . '</td>
  941. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP10_1'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP10_2'] . '</td>
  942. </tr>
  943.  
  944. <tr>
  945. <td>האם פרסת פיצויים לאחר 2004 ? </td>
  946. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_q11']. '</td>
  947. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p3_qP11']. '</td>
  948. </tr>
  949. <tr>
  950. <td></td>
  951. <td><span style="font-size:16px; font-weight:bold; text-align:center; display:block; color:red; text-decoration:underline;">מילוי אירועים אישיים</span></td>
  952. <td></td>
  953. </tr>
  954.  
  955. <tr>
  956. <td>האם בין השנים 2014-2009 פדית קופ"ג לפני מועד הפרעון החוקי </td>
  957. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q1']. '</td>
  958. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP1']. '</td>
  959. </tr>
  960. <tr>
  961. <td>האם בין השנים 2014-2009 סחרת בניירות ערך? </td>
  962. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q2']. '</td>
  963. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP2']. '</td>
  964. </tr>
  965. <tr>
  966. <td>האם בין השנים 2014-2009 מימשת אופציות?</td>
  967. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q3']. '</td>
  968. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP3']. '</td>
  969. </tr>
  970. <tr>
  971. <td>האם סיימת תואר אקדמאי משנת 2006 ואילך ? (לא כולל קורסים והשתלמויות)</td>
  972. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q4']. '</td>
  973. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP4']. '</td>
  974. </tr>
  975. <tr>
  976. <td>האם עלית לארץ משנת 2006 ואילך?</td>
  977. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q5']. '</td>
  978. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP5']. '</td>
  979. </tr>
  980. <tr>
  981. <td>האם השתחרתת משירות חובה לאחר 2006 ?</td>
  982. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q6']. '</td>
  983. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP6']. '</td>
  984. </tr>
  985. <tr>
  986. <td>האם בין השנים 2014-2009 תרמת למוסד ציבורי מעל 300 ש"ח?</td>
  987. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q7']. '</td>
  988. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP7']. '</td>
  989. </tr>
  990. <tr>
  991. <td>האם בין השנים 2014-2009 הייתה לך משכנתא?</td>
  992. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q8']. '</td>
  993. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP8']. '</td>
  994. </tr>
  995. <tr>
  996. <td>האם בין השנים 2014-2009 שילמת באופן עצמאי לביטוח חיים ו/או אבדן כושר עבודה שלא דרך המשכורת?</td>
  997. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q9']. '</td>
  998. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP9']. '</td>
  999. </tr>
  1000. <tr>
  1001. <td>האם בין השנים 2014-2009 הפקדת באופן עצמאי לקופ"ג או לפנסיה עבורך ו/או עבור אחד מבני המשפחה שלא דרך המשכורת? </td>
  1002. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q10']. '</td>
  1003. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP10']. '</td>
  1004. </tr>
  1005. <tr>
  1006. <td>האם בין השנים 2014-2009 היו לך הוצאות להנצחת קרוב משפחה שנספה במערכה או בפעולת איבה? </td>
  1007. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q11']. '</td>
  1008. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP11']. '</td>
  1009. </tr>
  1010. <tr>
  1011. <td>האם בין השנים 2014-2009 שילמת מזונות? </td>
  1012. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q12']. '</td>
  1013. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP12']. '</td>
  1014. </tr>
  1015. <tr>
  1016. <td>האם בין השנים 2014-2009 היית אב/אם חד הורי? </td>
  1017. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q13']. '</td>
  1018. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP13']. '</td>
  1019. </tr>
  1020. <tr>
  1021. <td>האם בין השנים 2014-2009 ילדייך הנם מתחת לגיל 18?</td>
  1022. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q14']. '</td>
  1023. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP14']. '</td>
  1024. </tr>
  1025. <tr>
  1026. <td>האם בין השנים 2014-2009 גרת ביישוב ספר?</td>
  1027. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q15'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['sfar_1'] . "<br>" . "משנה: " . $db->where('id_number', $_SESSION['id'])->getOne('info')['sfar1_y'] . "<br>" . "עד שנה: " . $db->where('id_number', $_SESSION['id'])->getOne('info')['sfar1_y2'] . '</td>
  1028. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP15'] . "<br>" . $db->where('id_number', $_SESSION['id'])->getOne('info')['sfar_2'] . "<br>" . "משנה: " . $db->where('id_number', $_SESSION['id'])->getOne('info')['sfar2_y'] . "<br>" . "עד שנה: " . $db->where('id_number', $_SESSION['id'])->getOne('info')['sfar2_y2'] . '</td>
  1029. </tr>
  1030. <tr>
  1031. <td>האם בין השנים 2014-2009 היית עצמאי? </td>
  1032. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q16']. '</td>
  1033. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP16']. '</td>
  1034. </tr>
  1035. <tr>
  1036. <td>האם בין השנים 2014-2009 היה לך הפסד מעסק? </td>
  1037. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q17']. '</td>
  1038. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP17']. '</td>
  1039. </tr>
  1040. <tr>
  1041. <td>האם בין השנים 2014-2009 היו לך הכנסות מחו"ל? </td>
  1042. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q18']. '</td>
  1043. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP18']. '</td>
  1044. </tr>
  1045. <tr>
  1046. <td>האם בין השנים 2014-2009 שילמת מס שבח בגין מכירת נכס?(לא מס רכישה)</td>
  1047. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q19']. '</td>
  1048. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP19']. '</td>
  1049. </tr>
  1050. <tr>
  1051. <td>האם בין השנים 2014-2009 קיבלת מענק חד פעמי ולא במשכורת? </td>
  1052. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q20']. '</td>
  1053. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP20']. '</td>
  1054. </tr>
  1055. <tr>
  1056. <td>האם בין השנים 2014-2009 היו לך הכנסות משכ"ד בארץ ו/או בחו"ל? </td>
  1057. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_q21']. '</td>
  1058. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p4_qP21']. '</td>
  1059. </tr>
  1060. <tr>
  1061. <td></td>
  1062. <td><span style="font-size:16px; font-weight:bold; text-align:center; display:block; color:red; text-decoration:underline;">מילוי אירועים רפואים</span></td>
  1063. <td></td>
  1064. </tr>
  1065.  
  1066. <tr>
  1067. <td>האם בין השנים 2009-2014 היה לך ילד לקוי למידה? (לרבות ADHD,ADD)</td>
  1068. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_q1']. '</td>
  1069. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_qP1']. '</td>
  1070. </tr>
  1071. <tr>
  1072. <td>האם בין השנים 2009-2014 היה לך ילד שסבל מקשיי התפתחות, מפגר, משותק, עיוור או חולה מחלה קשה? (לרבות חרש-אילם, חולה טלסמיה, דיסאוטונומיה, סיסטיק פיברוזיס וכד).</td>
  1073. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_q2']. '</td>
  1074. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_qP2']. '</td>
  1075. </tr>
  1076. <tr>
  1077. <td>האם בין השנים 2009-2014 ילדך היה זכאי לקיצבת נכות? (גם מעל גיל 18)</td>
  1078. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_q3']. '</td>
  1079. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_qP3']. '</td>
  1080. </tr>
  1081. <tr>
  1082. <td>האם עברת אירוע רפואי קשה וועדה רפואי ופנית לביטוח לאומי?</td>
  1083. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_q4']. '</td>
  1084. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_qP4']. '</td>
  1085. </tr>
  1086. <tr>
  1087. <td>האם בין השנים 2009-2014 היו לך הכנסות פטורות ממס כגון קיצבת שארים/ נכות (75% נכות ומעלה)?</td>
  1088. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_q5']. '</td>
  1089. <td>' . $db->where('id_number', $_SESSION['id'])->getOne('info')['p5_qP5']. '</td>
  1090. </tr>
  1091.  
  1092. </tbody>
  1093. </table>
  1094. </body>
  1095. </html>';
  1096.  
  1097. $pdf->writeHTML($html, true, 0, true);
  1098. $pdf->lastPage();
  1099. ob_end_clean();
  1100.  
  1101. $pdf->Output($_SERVER['DOCUMENT_ROOT'].'/'.'invoice2.pdf', 'F'); //save the pdf to a folder setting `F`
  1102. require_once('tcpdf/examples/phpmailer/class.phpmailer.php'); //where your phpmailer folder is
  1103. $mail = new PHPMailer();
  1104. $mail->CharSet = 'UTF-8';
  1105. $mail->From = "sigal.zioni@gmail.com";
  1106. $mail->FromName = "Your name";
  1107. $mail->AddAddress("eliron@scolpy.net");
  1108. $mail->AddAttachment($_SERVER['DOCUMENT_ROOT'].'/'.'invoice2.pdf');
  1109. // attach pdf that was saved in a folder
  1110. $mail->Subject = "";
  1111. $mail->Body = $message;
  1112. $mail->IsHTML(true);
  1113.  
  1114. if(!$mail->Send())
  1115. {
  1116. echo "Message could not be sent. <p>";
  1117. echo "Mailer Error: " . $mail->ErrorInfo;
  1118. }
  1119. else
  1120. {
  1121. echo "Message sent";
  1122. } //`the end`
  1123.  
  1124.  
  1125.  
  1126.  
  1127.  
  1128.  
  1129.  
  1130.  
  1131.  
  1132. /*
  1133. $headers = 'MIME-Version: 1.0' . "\r\n";
  1134. $headers .= 'Content-type: text/html; charset= UTF-8' . "\r\n";
  1135.  
  1136.  
  1137. // send email
  1138. mail("eliron@scolpy.net","My subject",$message, $headers);
  1139. */
  1140. include ('page6.php');
  1141. session_destroy();
  1142.  
  1143. }
  1144.  
  1145. }
  1146.  
  1147.  
  1148. ?>
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!