Advertisement
Guest User

Untitled

a guest
Mar 28th, 2018
308
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 82.21 KB | None | 0 0
  1. <?php
  2. include('header.php');
  3. ?>
  4.  
  5. <link rel="stylesheet" type="text/css" href="css/MainDataTables.css"/>
  6. <script type="text/javascript" src="js/jquery.dataTables.js"> </script>
  7.  
  8. <script type="text/javascript">
  9. jQuery(function($){
  10. var listTable =
  11. $('#employeeList')
  12. .dataTables({
  13. "columnDefs": [
  14. {"orderable":false, "targets":[-1]},
  15. {"width" :"20%","targets":[1,3]}
  16. ],
  17. "language" : {
  18. "lenghtMenu": "Display_MENU_records",
  19. "info": "Showing_START_to_END_of_TOTAL_records",
  20. },
  21. });
  22. });
  23. </script>
  24.  
  25. <script>
  26. function validate_form()
  27. {
  28. if(!IsNumeric(document.form_1.Nominal1.value.length == 0 && document.form_1.Nominal2.value.length == 0 && document.form_1.Nominal3.value.length == 0 &&
  29. document.form_1.Nominal4.value.length == 0 && document.form_1.Nominal5.value.length == 0 && document.form_1.Nominal6.value.length == 0 &&
  30. document.form_1.Nominal7.value.length == 0 && document.form_1.Nominal8.value.length == 0 && document.form_1.Nominal9.value.length == 0 &&
  31. document.form_1.Nominal10.value.length == 0))
  32. {
  33. alert('Please fill at least 1 Nominal Value');
  34. document.form_1.Nominal1.focus();
  35. return false;
  36. }
  37. if(document.form_1.TypeCost1.value.length == 0)
  38. {
  39. alert('Please select description of Type Cost Representation 1');
  40. document.form_1.TypeCost1 .focus();
  41. return false;
  42. }
  43. if(document.form_1.EntDate1.value == "none")
  44. {
  45. alert('Please fill at least 1 transaction data 1');
  46. document.form_1.EntDate1.focus();
  47. return false;
  48. }
  49. if(document.form_1.EntParty1.value.length == 0)
  50. {
  51. alert('Please fill Entertainment Party 1');
  52. document.form_1.EntParty1.focus();
  53. return false;
  54. }
  55. if(!IsNumeric(document.form_1.Premi1.value))
  56. {
  57. alert('Please fill amount of transaction 1 with numeric values');
  58. document.form_1.Premi1.focus();
  59. return false;
  60. }
  61. if(document.form_1.Nominal2.value.length > 0)
  62. {
  63. if(document.form_1.TypeCost2.value.length == 0)
  64. {
  65. alert('Please select description of Type Cost Representation 1');
  66. document.form_1.TypeCost2.focus();
  67. return false;
  68. }
  69. if(document.form_1.EntDate2.value == "none")
  70. {
  71. alert('Please fill at least 1 transaction data 1');
  72. document.form_1.EntDate2.focus();
  73. return false;
  74. }
  75. if(document.form_1.EntParty2.value.length == 0)
  76. {
  77. alert('Please fill Entertainment Party 1');
  78. document.form_1.EntParty2.focus();
  79. return false;
  80. }
  81. if(!IsNumeric(document.form_1.Premi2.value))
  82. {
  83. alert('Please fill amount of transaction 1 with numeric values');
  84. document.form_1.Premi2.focus();
  85. return false;
  86. }
  87. }
  88. if(document.form_1.Nominal3.value.length > 0)
  89. {
  90. if(document.form_1.TypeCost3.value.length == 0)
  91. {
  92. alert('Please select description of Type Cost Representation 1');
  93. document.form_1.TypeCost3.focus();
  94. return false;
  95. }
  96. if(document.form_1.EntDate3.value == "none")
  97. {
  98. alert('Please fill at least 1 transaction data 1');
  99. document.form_1.EntDate3.focus();
  100. return false;
  101. }
  102. if(document.form_1.EntParty3.value.length == 0)
  103. {
  104. alert('Please fill Entertainment Party 1');
  105. document.form_1.EntParty3.focus();
  106. return false;
  107. }
  108. if(!IsNumeric(document.form_1.Premi3.value))
  109. {
  110. alert('Please fill amount of transaction 1 with numeric values');
  111. document.form_1.Premi3.focus();
  112. return false;
  113. }
  114. }
  115. if(document.form_1.Nominal4.value.length > 0)
  116. {
  117. if(document.form_1.TypeCost4.value.length == 0)
  118. {
  119. alert('Please select description of Type Cost Representation 1');
  120. document.form_1.TypeCost4.focus();
  121. return false;
  122. }
  123. if(document.form_1.EntDate4.value == "none")
  124. {
  125. alert('Please fill at least 1 transaction data 1');
  126. document.form_1.EntDate4.focus();
  127. return false;
  128. }
  129. if(document.form_1.EntParty4.value.length == 0)
  130. {
  131. alert('Please fill Entertainment Party 1');
  132. document.form_1.EntParty4.focus();
  133. return false;
  134. }
  135. if(!IsNumeric(document.form_1.Premi4.value))
  136. {
  137. alert('Please fill amount of transaction 1 with numeric values');
  138. document.form_1.Premi4.focus();
  139. return false;
  140. }
  141. }
  142. if(document.form_1.Nominal5.value.length > 0)
  143. {
  144. if(document.form_1.TypeCost5.value.length == 0)
  145. {
  146. alert('Please select description of Type Cost Representation 1');
  147. document.form_1.TypeCost5.focus();
  148. return false;
  149. }
  150. if(document.form_1.EntDate5.value == "none")
  151. {
  152. alert('Please fill at least 1 transaction data 1');
  153. document.form_1.EntDate5.focus();
  154. return false;
  155. }
  156. if(document.form_1.EntParty5.value.length == 0)
  157. {
  158. alert('Please fill Entertainment Party 1');
  159. document.form_1.EntParty5.focus();
  160. return false;
  161. }
  162. if(!IsNumeric(document.form_1.Premi5.value))
  163. {
  164. alert('Please fill amount of transaction 1 with numeric values');
  165. document.form_1.Premi5.focus();
  166. return false;
  167. }
  168. }
  169. if(document.form_1.Nominal6.value.length > 0)
  170. {
  171. if(document.form_1.TypeCost6.value.length == 0)
  172. {
  173. alert('Please select description of Type Cost Representation 1');
  174. document.form_1.TypeCost6.focus();
  175. return false;
  176. }
  177. if(document.form_1.EntDate6.value == "none")
  178. {
  179. alert('Please fill at least 1 transaction data 1');
  180. document.form_1.EntDate6.focus();
  181. return false;
  182. }
  183. if(document.form_1.EntParty6.value.length == 0)
  184. {
  185. alert('Please fill Entertainment Party 1');
  186. document.form_1.EntParty6.focus();
  187. return false;
  188. }
  189. if(!IsNumeric(document.form_1.Premi6.value))
  190. {
  191. alert('Please fill amount of transaction 1 with numeric values');
  192. document.form_1.Premi6.focus();
  193. return false;
  194. }
  195. }
  196. if(document.form_1.Nominal7.value.length > 0)
  197. {
  198. if(document.form_1.TypeCost7.value.length == 0)
  199. {
  200. alert('Please select description of Type Cost Representation 1');
  201. document.form_1.TypeCost7.focus();
  202. return false;
  203. }
  204. if(document.form_1.EntDate7.value == "none")
  205. {
  206. alert('Please fill at least 1 transaction data 1');
  207. document.form_1.EntDate7.focus();
  208. return false;
  209. }
  210. if(document.form_1.EntParty7.value.length == 0)
  211. {
  212. alert('Please fill Entertainment Party 1');
  213. document.form_1.EntParty7.focus();
  214. return false;
  215. }
  216. if(!IsNumeric(document.form_1.Premi7.value))
  217. {
  218. alert('Please fill amount of transaction 1 with numeric values');
  219. document.form_1.Premi7.focus();
  220. return false;
  221. }
  222. }
  223. if(document.form_1.Nominal8.value.length > 0)
  224. {
  225. if(document.form_1.TypeCost8.value.length == 0)
  226. {
  227. alert('Please select description of Type Cost Representation 1');
  228. document.form_1.TypeCost8.focus();
  229. return false;
  230. }
  231. if(document.form_1.EntDate8.value == "none")
  232. {
  233. alert('Please fill at least 1 transaction data 1');
  234. document.form_1.EntDate8.focus();
  235. return false;
  236. }
  237. if(document.form_1.EntParty8.value.length == 0)
  238. {
  239. alert('Please fill Entertainment Party 1');
  240. document.form_1.EntParty8.focus();
  241. return false;
  242. }
  243. if(!IsNumeric(document.form_1.Premi8.value))
  244. {
  245. alert('Please fill amount of transaction 1 with numeric values');
  246. document.form_1.Premi8.focus();
  247. return false;
  248. }
  249. }
  250. if(document.form_1.Nominal9.value.length > 0)
  251. {
  252. if(document.form_1.TypeCost9.value.length == 0)
  253. {
  254. alert('Please select description of Type Cost Representation 1');
  255. document.form_1.TypeCost9.focus();
  256. return false;
  257. }
  258. if(document.form_1.EntDate9.value == "none")
  259. {
  260. alert('Please fill at least 1 transaction data 1');
  261. document.form_1.EntDate9.focus();
  262. return false;
  263. }
  264. if(document.form_1.EntParty9.value.length == 0)
  265. {
  266. alert('Please fill Entertainment Party 1');
  267. document.form_1.EntParty9.focus();
  268. return false;
  269. }
  270. if(!IsNumeric(document.form_1.Premi9.value))
  271. {
  272. alert('Please fill amount of transaction 1 with numeric values');
  273. document.form_1.Premi9.focus();
  274. return false;
  275. }
  276. }
  277. if(document.form_1.Nominal10.value.length > 0)
  278. {
  279. if(document.form_1.TypeCost10.value.length == 0)
  280. {
  281. alert('Please select description of Type Cost Representation 1');
  282. document.form_1.TypeCost10.focus();
  283. return false;
  284. }
  285. if(document.form_1.EntDate10.value == "none")
  286. {
  287. alert('Please fill at least 1 transaction data 1');
  288. document.form_1.EntDate10.focus();
  289. return false;
  290. }
  291. if(document.form_1.EntParty10.value.length == 0)
  292. {
  293. alert('Please fill Entertainment Party 1');
  294. document.form_1.EntParty10.focus();
  295. return false;
  296. }
  297. if(!IsNumeric(document.form_1.Premi10.value))
  298. {
  299. alert('Please fill amount of transaction 1 with numeric values');
  300. document.form_1.Premi10.focus();
  301. return false;
  302. }
  303. }
  304.  
  305. return true;
  306. }
  307.  
  308. function IsNumeric(sText)
  309. {
  310. var ValidChars = "0123456789,";
  311. var IsNumber = true;
  312. var Char;
  313. for(i=0;i<sText.length&&IsNumber==true;i++)
  314. {
  315. Char=sText.charAt(i);
  316. if(ValidChars.indexOf(Char) == -1)
  317. {
  318. IsNumber = false;
  319. }
  320. }
  321. return IsNumber;
  322. }
  323. </script>
  324.  
  325. <body>
  326. <div class="header" id="home">
  327. <?php
  328. include('menu.php');
  329. ?>
  330.  
  331. </div>
  332.  
  333. <?php
  334. if (isset($_POST['cmdSubmit']))
  335. {
  336.  
  337. $Div = $_POST['Div'];
  338.  
  339.  
  340. $Nominal1 = $_POST['Nominal1'];
  341. $TypeCost1 = $_POST['TypeCost1'];
  342. $EntDate1 = $_POST['EntDate1'];
  343. $EntParty1 = $_POST['EntParty1'];
  344. $Premi1 = $_POST['Premi1'];
  345. $RemarksAgent1 = $_POST['RemarksAgent1'];
  346.  
  347. $Nominal2 = $_POST['Nominal2'];
  348. $TypeCost2 = $_POST['TypeCost2'];
  349. $EntDate2 = $_POST['EntDate2'];
  350. $EntParty2 = $_POST['EntParty2'];
  351. $Premi2 = $_POST['Premi2'];
  352. $RemarksAgent2 = $_POST['RemarksAgent2'];
  353.  
  354. $Nominal3 = $_POST['Nominal3'];
  355. $TypeCost3 = $_POST['TypeCost3'];
  356. $EntDate3 = $_POST['EntDate3'];
  357. $EntParty3 = $_POST['EntParty3'];
  358. $Premi3 = $_POST['Premi3'];
  359. $RemarksAgent3 = $_POST['RemarksAgent3'];
  360.  
  361. $Nominal4 = $_POST['Nominal4'];
  362. $TypeCost4 = $_POST['TypeCost4'];
  363. $EntDate4 = $_POST['EntDate4'];
  364. $EntParty4 = $_POST['EntParty4'];
  365. $Premi4 = $_POST['Premi4'];
  366. $RemarksAgent4 = $_POST['RemarksAgent4'];
  367.  
  368. $Nominal5 = $_POST['Nominal5'];
  369. $TypeCost5 = $_POST['TypeCost5'];
  370. $EntDate5 = $_POST['EntDate5'];
  371. $EntParty5 = $_POST['EntParty5'];
  372. $Premi5 = $_POST['Premi5'];
  373. $RemarksAgent5 = $_POST['RemarksAgent5'];
  374.  
  375. $Nominal6 = $_POST['Nominal6'];
  376. $TypeCost6 = $_POST['TypeCost6'];
  377. $EntDate6 = $_POST['EntDate6'];
  378. $EntParty6 = $_POST['EntParty6'];
  379. $Premi6 = $_POST['Premi6'];
  380. $RemarksAgent6 = $_POST['RemarksAgent6'];
  381.  
  382. $Nominal7 = $_POST['Nominal7'];
  383. $TypeCost7 = $_POST['TypeCost7'];
  384. $EntDate7 = $_POST['EntDate7'];
  385. $EntParty7 = $_POST['EntParty7'];
  386. $Premi7 = $_POST['Premi7'];
  387. $RemarksAgent7 = $_POST['RemarksAgent7'];
  388.  
  389. $Nominal8 = $_POST['Nominal8'];
  390. $TypeCost8 = $_POST['TypeCost8'];
  391. $EntDate8 = $_POST['EntDate8'];
  392. $EntParty8 = $_POST['EntParty8'];
  393. $Premi8 = $_POST['Premi8'];
  394. $RemarksAgent8 = $_POST['RemarksAgent8'];
  395.  
  396. $Nominal9 = $_POST['Nominal9'];
  397. $TypeCost9 = $_POST['TypeCost9'];
  398. $EntDate9 = $_POST['EntDate9'];
  399. $EntParty9 = $_POST['EntParty9'];
  400. $Premi9 = $_POST['Premi9'];
  401. $RemarksAgent9 = $_POST['RemarksAgent9'];
  402.  
  403. $Nominal10 = $_POST['Nominal10'];
  404. $TypeCost10 = $_POST['TypeCost10'];
  405. $EntDate10 = $_POST['EntDate10'];
  406. $EntParty10 = $_POST['EntParty10'];
  407. $Premi10 = $_POST['Premi10'];
  408. $RemarksAgent10 = $_POST['RemarksAgent10'];
  409.  
  410.  
  411.  
  412.  
  413. $EntParty = strtoupper(str_replace("'", "'", $EntParty1));
  414.  
  415.  
  416. $EntParty = strtoupper(str_replace("'", "'", $EntParty2));
  417.  
  418.  
  419.  
  420. $EntParty = strtoupper(str_replace("'", "'", $EntParty3));
  421.  
  422.  
  423.  
  424. $EntParty = strtoupper(str_replace("'", "'", $EntParty4));
  425.  
  426.  
  427.  
  428. $EntParty = strtoupper(str_replace("'", "'", $EntParty5));
  429.  
  430.  
  431.  
  432. $EntParty = strtoupper(str_replace("'", "'", $EntParty6));
  433.  
  434.  
  435.  
  436. $EntParty = strtoupper(str_replace("'", "'", $EntParty7));
  437.  
  438.  
  439.  
  440. $EntParty = strtoupper(str_replace("'", "'", $EntParty8));
  441.  
  442.  
  443.  
  444. $EntParty = strtoupper(str_replace("'", "'", $EntParty9));
  445.  
  446.  
  447.  
  448. $EntParty = strtoupper(str_replace("'", "'", $EntParty10));
  449.  
  450.  
  451. $flag1 = 1; $flag2 = 1; $flag3 = 1; $flag4 = 1; $flag5 = 1;
  452. $flag6 = 1; $flag7 = 1; $flag8 = 1; $flag9 = 1; $flag10 = 1;
  453.  
  454. if($Nominal1 <> "")
  455. {
  456. $query1="insert into entReq (userID,Nominal,InputDate,TypeCost,EntDate,EntParty,Premi,Div,RemarksAgent)
  457. select '".$userID."','".$Nominal1."',getdate(),'".$TypeCost1."',convert(smalldatetime,'".$EntDate1."',103),
  458. '".$EntParty1."','".$Premi1."','".$Div."','".$RemarksAgent1."'";
  459. $result1= sqlsrv_query($conn, $query1);
  460. echo $query1."<br>";
  461. if(!$result1)
  462. {
  463. $flag1 = 0;
  464. }
  465. }
  466.  
  467. if($Nominal2 <> "")
  468. {
  469. $query2="insert into entReq (userID,Nominal,InputDate,TypeCost,EntDate,EntParty,Premi,Div,RemarksAgent)
  470. select '".$userID."','".$Nominal2."',getdate(),'".$TypeCost2."',convert(smalldatetime,'".$EntDate2."',103),
  471. '".$EntParty2."','".$Premi2."','".$Div."','".$RemarksAgent2."'";
  472. $result2= sqlsrv_query($conn, $query2);
  473. // echo $query1."<br>";
  474. if(!$result2)
  475. {
  476. $flag2 = 0;
  477. }
  478. }
  479.  
  480. if($Nominal3 <> "")
  481. {
  482. $query3="insert into entReq (userID,Nominal,InputDate,TypeCost,EntDate,EntParty,Premi,Div,RemarksAgent)
  483. select '".$userID."','".$Nominal3."',getdate(),'".$TypeCost3."',convert(smalldatetime,'".$EntDate3."',103),
  484. '".$EntParty3."','".$Premi3."','".$Div."','".$RemarksAgent3."'";
  485. $result3= sqlsrv_query($conn, $query3);
  486. // echo $query1."<br>";
  487. if(!$result3)
  488. {
  489. $flag3 = 0;
  490. }
  491. }
  492.  
  493. if($Nominal4 <> "")
  494. {
  495. $query4="insert into entReq (userID,Nominal,InputDate,TypeCost,EntDate,EntParty,Premi,Div,RemarksAgent)
  496. select '".$userID."','".$Nominal4."',getdate(),'".$TypeCost4."',convert(smalldatetime,'".$EntDate4."',103),
  497. '".$EntParty4."','".$Premi4."','".$Div."','".$RemarksAgent4."'";
  498. $result4= sqlsrv_query($conn, $query4);
  499. echo $query1."<br>";
  500. if(!$result4)
  501. {
  502. $flag4 = 0;
  503. }
  504. }
  505.  
  506. if($Nominal5 <> "")
  507. {
  508. $query5="insert into entReq (userID,Nominal,InputDate,TypeCost,EntDate,EntParty,Premi,Div,RemarksAgent)
  509. select '".$userID."','".$Nominal5."',getdate(),'".$TypeCost5."',convert(smalldatetime,'".$EntDate5."',103),
  510. '".$EntParty5."','".$Premi5."','".$Div."','".$RemarksAgent5."'";
  511. $result5= sqlsrv_query($conn, $query5);
  512. // echo $query1."<br>";
  513. if(!$result5)
  514. {
  515. $flag5 = 0;
  516. }
  517. }
  518.  
  519. if($Nominal6 <> "")
  520. {
  521. $query6="insert into entReq (userID,Nominal,InputDate,TypeCost,EntDate,EntParty,Premi,Div,RemarksAgent)
  522. select '".$userID."','".$Nominal6."',getdate(),'".$TypeCost6."',convert(smalldatetime,'".$EntDate6."',103),
  523. '".$EntParty6."','".$Premi6."','".$Div."','".$RemarksAgent6."'";
  524. $result6= sqlsrv_query($conn, $query6);
  525. // echo $query1."<br>";
  526. if(!$result6)
  527. {
  528. $flag6 = 0;
  529. }
  530. }
  531.  
  532. if($Nominal7 <> "")
  533. {
  534. $query7="insert into entReq (userID,Nominal,InputDate,TypeCost,EntDate,EntParty,Premi,Div,RemarksAgent)
  535. select '".$userID."','".$Nominal7."',getdate(),'".$TypeCost7."',convert(smalldatetime,'".$EntDate7."',103),
  536. '".$EntParty7."','".$Premi7."','".$Div."','".$RemarksAgent7."'";
  537. $result7= sqlsrv_query($conn, $query7);
  538. // echo $query1."<br>";
  539. if(!$result7)
  540. {
  541. $flag7 = 0;
  542. }
  543. }
  544.  
  545. if($Nominal8 <> "")
  546. {
  547. $query8="insert into entReq (userID,Nominal,InputDate,TypeCost,EntDate,EntParty,Premi,Div,RemarksAgent)
  548. select '".$userID."','".$Nominal8."',getdate(),'".$TypeCost8."',convert(smalldatetime,'".$EntDate8."',103),
  549. '".$EntParty8."','".$Premi8."','".$Div."','".$RemarksAgent8."'";
  550. $result8= sqlsrv_query($conn, $query8);
  551. // echo $query1."<br>";
  552. if(!$result8)
  553. {
  554. $flag8 = 0;
  555. }
  556. }
  557.  
  558. if($Nominal9 <> "")
  559. {
  560. $query9="insert into entReq (userID,Nominal,InputDate,TypeCost,EntDate,EntParty,Premi,Div,RemarksAgent)
  561. select '".$userID."','".$Nominal9."',getdate(),'".$TypeCost9."',convert(smalldatetime,'".$EntDate9."',103),
  562. '".$EntParty9."','".$Premi9."','".$Div."','".$RemarksAgent9."'";
  563. $result9= sqlsrv_query($conn, $query9);
  564. // echo $query1."<br>";
  565. if(!$result9)
  566. {
  567. $flag9 = 0;
  568. }
  569. }
  570.  
  571. if($Nominal10 <> "")
  572. {
  573. $query10="insert into entReq (userID,Nominal,InputDate,TypeCost,EntDate,EntParty,Premi,Div,RemarksAgent)
  574. select '".$userID."','".$Nominal10."',getdate(),'".$TypeCost10."',convert(smalldatetime,'".$EntDate10."',103),
  575. '".$EntParty10."','".$Premi10."','".$Div."','".$RemarksAgent10."'";
  576. $result10= sqlsrv_query($conn, $query10);
  577. // echo $query1."<br>";
  578. if(!$result10)
  579. {
  580. $flag10 = 0;
  581. }
  582. }
  583.  
  584. if($flag1 == 1 && $flag2 == 1 && $flag3 == 1 && $flag4 == 1 && $flag5 = 1 &&
  585. $flag6 == 1 && $flag7 == 1 && $flag8 == 1 && $flag9 == 1 && $flag10 == 1)
  586. {
  587. ?>
  588. <div class="homeLayerNotif">
  589. Input Request Success <br>
  590. </div>
  591. <?php
  592.  
  593. //Sending Email
  594. require_once('phpmailer/class.phpmailer.php');
  595.  
  596. define('GUSER', 'username email'); //username email
  597. define('GPWD', 'password email'); // password email
  598.  
  599. function smtpmailer($to, $from, $from_name, $subject, $body)
  600. {
  601. global $error;
  602. $mail = new PHPMailer();
  603. $mail->IsSMTP();
  604. $mail->SMTPDebug = 0; // untuk memunculkan pesan error /debug di layar
  605. $mail->SMTPAuth = true; // authentifikasi smtp enable atau disable
  606. $mail->SMTPSecure = 'ssl'; // secure transfer membutuhkan authentifikasi dari mail server
  607. $mail->Host ='info.intraasia.net'; // masukkan nama host email "diawal ssl://"
  608. $mail->Port = 465; //port secure ssl email
  609. $mail->Username = 'notify@info.intraasia.net'; //username email
  610. $mail->Password = 'intraasia021'; //password email
  611. $mail->SetFrom($from, $from_name);
  612. $mail->Subject = $subject;
  613. $mail->Body = $body;
  614. $mail->isHTML(true);
  615. $mail->AddAddress($to);
  616.  
  617. //----Send File Benefit----//
  618. //$mail->AddAttachment($docTable);
  619.  
  620. //$mail->addAttachment('logo.png');
  621. if(!$mail->Send())
  622. {
  623. $error = 'Mail error: '.$mail->ErrorInfo;
  624. return $error;
  625. }
  626. else
  627. {
  628. $error = 'Message sent!';
  629. //return $error;
  630. }
  631. }
  632.  
  633. $to = "mathews@intraasia.id";
  634. $to2 = "prima.ayu@intraasia.id";
  635. $to3 = "alfons.fasius@intraasia.id";
  636. $subject = "Email Notification of Upload Marketing Request Entertainment";
  637.  
  638. $message = '<html><body>';
  639. //$message .= '<img src="logo.png" />';
  640. $message .= '<br><strong>Information Marketing Request</strong><br>';
  641. $message .= '<table rules="all" style="border-color: #666; border:1px solid; border-collapse:collapse; width:75%" cellpadding="10">';
  642. $message .= "<tr><th style='background: #eee;border:1px solid; border-collapse:collapse;'><strong>Input Date</strong></th><th style='background: #eee;border:1px solid; border-collapse:collapse;'><strong>Division</strong></th><th style='background: #eee;border:1px solid; border-collapse:collapse;'><strong>Type Cost Representation</strong></th><th style='background: #eee;border:1px solid; border-collapse:collapse;'><strong>Entertainment Date</strong></th><th style='background: #eee;border:1px solid; border-collapse:collapse;'><strong>Nominal</strong></th><th style='background: #eee;border:1px solid; border-collapse:collapse;'><strong>Entertainment Party</strong></th><th style='background: #eee;border:1px solid; border-collapse:collapse;'><strong>Premium Prospect</strong></th><th
  643. style='background: #eee;border:1px solid; border-collapse:collapse;'><strong>Remarks from Marketing</strong></th></tr>";
  644.  
  645. if($Nominal1 <> "")
  646. {
  647. $message .= "<tr><td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  648. <td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  649. <td style='border:1px solid; border-collapse:collapse;'>".$TypeCost1."</td>
  650. <td style='border:1px solid; border-collapse:collapse;'>".$EntDate1."</td>
  651. <td style='border:1px solid; border-collapse:collapse;'>".$Nominal1."</td>
  652. <td style='border:1px solid; border-collapse:collapse;'>".$EntParty1."</td>
  653. <td style='border:1px solid; border-collapse:collapse;'>".$Premi1."</td>
  654. <td style='border:1px solid; border-collapse:collapse;'>".$RemarksAgent1."</td></tr>";
  655. }
  656.  
  657. if($Nominal2 <> "")
  658. {
  659. $message .="<tr><td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  660. <td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  661. <td style='border:1px solid; border-collapse:collapse;'>".$TypeCost2."</td>
  662. <td style='border:1px solid; border-collapse:collapse;'>".$EntDate2."</td>
  663. <td style='border:1px solid; border-collapse:collapse;'>".$Nominal2."</td>
  664. <td style='border:1px solid; border-collapse:collapse;'>".$EntParty2."</td>
  665. <td style='border:1px solid; border-collapse:collapse;'>".$Premi2."</td>
  666. <td style='border:1px solid; border-collapse:collapse;'>".$RemarksAgent2."</td></tr>";
  667. }
  668.  
  669. if($Nominal3 <> "")
  670. {
  671. $message .="<tr><td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  672. <td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  673. <td style='border:1px solid; border-collapse:collapse;'>".$TypeCost3."</td>
  674. <td style='border:1px solid; border-collapse:collapse;'>".$EntDate3."</td>
  675. <td style='border:1px solid; border-collapse:collapse;'>".$Nominal3."</td>
  676. <td style='border:1px solid; border-collapse:collapse;'>".$EntParty3."</td>
  677. <td style='border:1px solid; border-collapse:collapse;'>".$Premi3."</td>
  678. <td style='border:1px solid; border-collapse:collapse;'>".$RemarksAgent3."</td></tr>";
  679. }
  680.  
  681. if($Nominal4 <> "")
  682. {
  683. $message .="<tr><td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  684. <td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  685. <td style='border:1px solid; border-collapse:collapse;'>".$TypeCost4."</td>
  686. <td style='border:1px solid; border-collapse:collapse;'>".$EntDate4."</td>
  687. <td style='border:1px solid; border-collapse:collapse;'>".$Nominal4."</td>
  688. <td style='border:1px solid; border-collapse:collapse;'>".$EntParty4."</td>
  689. <td style='border:1px solid; border-collapse:collapse;'>".$Premi4."</td>
  690. <td style='border:1px solid; border-collapse:collapse;'>".$RemarksAgent4."</td></tr>";
  691. }
  692.  
  693. if($Nominal5 <> "")
  694. {
  695. $message .="<tr><td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  696. <td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  697. <td style='border:1px solid; border-collapse:collapse;'>".$TypeCost5."</td>
  698. <td style='border:1px solid; border-collapse:collapse;'>".$EntDate5."</td>
  699. <td style='border:1px solid; border-collapse:collapse;'>".$Nominal5."</td>
  700. <td style='border:1px solid; border-collapse:collapse;'>".$EntParty5."</td>
  701. <td style='border:1px solid; border-collapse:collapse;'>".$Premi5."</td>
  702. <td style='border:1px solid; border-collapse:collapse;'>".$RemarksAgent5."</td></tr>";
  703. }
  704.  
  705. if($Nominal6 <> "")
  706. {
  707. $message .="<tr><td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  708. <td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  709. <td style='border:1px solid; border-collapse:collapse;'>".$TypeCost6."</td>
  710. <td style='border:1px solid; border-collapse:collapse;'>".$EntDate6."</td>
  711. <td style='border:1px solid; border-collapse:collapse;'>".$Nominal6."</td>
  712. <td style='border:1px solid; border-collapse:collapse;'>".$EntParty6."</td>
  713. <td style='border:1px solid; border-collapse:collapse;'>".$Premi6."</td>
  714. <td style='border:1px solid; border-collapse:collapse;'>".$RemarksAgent6."</td></tr>";
  715. }
  716.  
  717. if($Nominal7 <> "")
  718. {
  719. $message .="<tr><td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  720. <td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  721. <td style='border:1px solid; border-collapse:collapse;'>".$TypeCost7."</td>
  722. <td style='border:1px solid; border-collapse:collapse;'>".$EntDate7."</td>
  723. <td style='border:1px solid; border-collapse:collapse;'>".$Nominal7."</td>
  724. <td style='border:1px solid; border-collapse:collapse;'>".$EntParty7."</td>
  725. <td style='border:1px solid; border-collapse:collapse;'>".$Premi7."</td>
  726. <td style='border:1px solid; border-collapse:collapse;'>".$RemarksAgent7."</td></tr>";
  727. }
  728.  
  729. if($Nominal8 <> "")
  730. {
  731. $message .="<tr><td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  732. <td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  733. <td style='border:1px solid; border-collapse:collapse;'>".$TypeCost8."</td>
  734. <td style='border:1px solid; border-collapse:collapse;'>".$EntDate8."</td>
  735. <td style='border:1px solid; border-collapse:collapse;'>".$Nominal8."</td>
  736. <td style='border:1px solid; border-collapse:collapse;'>".$EntParty8."</td>
  737. <td style='border:1px solid; border-collapse:collapse;'>".$Premi8."</td>
  738. <td style='border:1px solid; border-collapse:collapse;'>".$RemarksAgent8."</td></tr>";
  739. }
  740.  
  741. if($Nominal9 <> "")
  742. {
  743. $message .="<tr><td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  744. <td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  745. <td style='border:1px solid; border-collapse:collapse;'>".$TypeCost9."</td>
  746. <td style='border:1px solid; border-collapse:collapse;'>".$EntDate9."</td>
  747. <td style='border:1px solid; border-collapse:collapse;'>".$Nominal9."</td>
  748. <td style='border:1px solid; border-collapse:collapse;'>".$EntParty9."</td>
  749. <td style='border:1px solid; border-collapse:collapse;'>".$Premi9."</td>
  750. <td style='border:1px solid; border-collapse:collapse;'>".$RemarksAgent9."</td></tr>";
  751. }
  752.  
  753. if($Nominal10 <> "")
  754. {
  755. $message .="<tr><td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  756. <td style='border:1px solid; border-collapse:collapse;'>".$Div."</td>
  757. <td style='border:1px solid; border-collapse:collapse;'>".$TypeCost10."</td>
  758. <td style='border:1px solid; border-collapse:collapse;'>".$EntDate10."</td>
  759. <td style='border:1px solid; border-collapse:collapse;'>".$Nominal10."</td>
  760. <td style='border:1px solid; border-collapse:collapse;'>".$EntParty10."</td>
  761. <td style='border:1px solid; border-collapse:collapse;'>".$Premi10."</td>
  762. <td style='border:1px solid; border-collapse:collapse;'>".$RemarksAgent10."</td></tr>";
  763. }
  764.  
  765.  
  766.  
  767. $message .= '</table></body></html>';
  768. // $message .= '<p><a href="http://localhost/finance/ent_list">Click Here to Full Information</a></p>';
  769.  
  770.  
  771. echo smtpmailer($to,'notify@info.intraasia.net','Finance System Email Notification',$subject,$message); // script kirim email
  772. //echo smtpmailer($to2,'notify@info.intraasia.net','e-Filling Email Notification',$subject,$message); // script kirim email
  773. //echo smtpmailer($to3,'notify@info.intraasia.net','e-Filling Email Notification',$subject,$message); // script kirim email
  774.  
  775. }
  776.  
  777. else
  778. {
  779. ?>
  780. <div class="homeLayerNotifWrong">
  781. <?php
  782. if($flag1 == 0)
  783. {
  784. ?>
  785. Input Request <?php echo $EntParty1 ?> Failed <br>
  786. <?php
  787. }
  788. if($flag2 == 0)
  789. {
  790. ?>
  791. Input Request <?php echo $EntParty2 ?> Failed <br>
  792. <?php
  793. }
  794. if($flag3 == 0)
  795. {
  796. ?>
  797. Input Request <?php echo $EntParty3 ?> Failed <br>
  798. <?php
  799. }
  800. if($flag4 == 0)
  801. {
  802. ?>
  803. Input Request <?php echo $EntParty4 ?> Failed <br>
  804. <?php
  805. }
  806. if($flag5 == 0)
  807. {
  808. ?>
  809. Input Request <?php echo $EntParty5 ?> Failed <br>
  810. <?php
  811. }
  812. if($flag6 == 0)
  813. {
  814. ?>
  815. Input Request <?php echo $EntParty6 ?> Failed <br>
  816. <?php
  817. }
  818. if($flag7 == 0)
  819. {
  820. ?>
  821. Input Request <?php echo $EntParty7 ?> Failed <br>
  822. <?php
  823. }
  824. if($flag8 == 0)
  825. {
  826. ?>
  827. Input Request <?php echo $EntParty8 ?> Failed <br>
  828. <?php
  829. }
  830. if($flag9 == 0)
  831. {
  832. ?>
  833. Input Request <?php echo $EntParty9 ?> Failed <br>
  834. <?php
  835. }
  836. if($flag10 == 0)
  837. {
  838. ?>
  839. Input Request <?php echo $EntParty10 ?> Failed <br>
  840. <?php
  841. }
  842. ?>
  843. </div>
  844. <?php
  845. }
  846. }
  847. ?>
  848.  
  849.  
  850. <?php
  851. if(isset($_POST['cmdEdit']))
  852. {
  853. $IdEnt1=$_POST['IdEnt1'];
  854. $Nominal1=$_POST['Nominal1'];
  855. $TypeCost1 = $_POST['TypeCost1'];
  856. $EntDate1 = $_POST['EntDate1'];
  857. $EntParty1 = $_POST['EntParty1'];
  858. $Premi1 = $_POST['Premi1'];
  859. $Div = $_POST['Div'];
  860. $RemarksAgent1 = $_POST['RemarksAgent1'];
  861.  
  862. $IdEnt2=$_POST['IdEnt2'];
  863. $Nominal2=$_POST['Nominal2'];
  864. $TypeCost2 = $_POST['TypeCost2'];
  865. $EntDate2 = $_POST['EntDate2'];
  866. $EntParty2 = $_POST['EntParty2'];
  867. $Premi2 = $_POST['Premi2'];
  868. $Div = $_POST['Div'];
  869. $RemarksAgent2 = $_POST['RemarksAgent2'];
  870.  
  871. $IdEnt3=$_POST['IdEnt3'];
  872. $Nominal3=$_POST['Nominal3'];
  873. $TypeCost3 = $_POST['TypeCost3'];
  874. $EntDate3 = $_POST['EntDate3'];
  875. $EntParty3 = $_POST['EntParty3'];
  876. $Premi3 = $_POST['Premi3'];
  877. $Div = $_POST['Div'];
  878. $RemarksAgent3 = $_POST['RemarksAgent3'];
  879.  
  880. $IdEnt4=$_POST['IdEnt4'];
  881. $Nominal4=$_POST['Nominal4'];
  882. $TypeCost4 = $_POST['TypeCost4'];
  883. $EntDate4 = $_POST['EntDate4'];
  884. $EntParty4 = $_POST['EntParty4'];
  885. $Premi4 = $_POST['Premi4'];
  886. $Div = $_POST['Div'];
  887. $RemarksAgent4 = $_POST['RemarksAgent4'];
  888.  
  889. $IdEnt5=$_POST['IdEnt5'];
  890. $Nominal5=$_POST['Nominal5'];
  891. $TypeCost5 = $_POST['TypeCost5'];
  892. $EntDate5 = $_POST['EntDate5'];
  893. $EntParty5 = $_POST['EntParty5'];
  894. $Premi5 = $_POST['Premi5'];
  895. $Div = $_POST['Div'];
  896. $RemarksAgent5 = $_POST['RemarksAgent5'];
  897.  
  898. $IdEnt6=$_POST['IdEnt6'];
  899. $Nominal6=$_POST['Nominal6'];
  900. $TypeCost6 = $_POST['TypeCost6'];
  901. $EntDate6 = $_POST['EntDate6'];
  902. $EntParty6 = $_POST['EntParty6'];
  903. $Premi6 = $_POST['Premi6'];
  904. $Div = $_POST['Div'];
  905. $RemarksAgent6 = $_POST['RemarksAgent6'];
  906.  
  907. $IdEnt7=$_POST['IdEnt7'];
  908. $Nominal7=$_POST['Nominal7'];
  909. $TypeCost7 = $_POST['TypeCost7'];
  910. $EntDate7 = $_POST['EntDate7'];
  911. $EntParty7 = $_POST['EntParty7'];
  912. $Premi7 = $_POST['Premi7'];
  913. $Div = $_POST['Div'];
  914. $RemarksAgent7 = $_POST['RemarksAgent7'];
  915.  
  916. $IdEnt8=$_POST['IdEnt8'];
  917. $Nominal8=$_POST['Nominal8'];
  918. $TypeCost8 = $_POST['TypeCost8'];
  919. $EntDate8 = $_POST['EntDate8'];
  920. $EntParty8 = $_POST['EntParty8'];
  921. $Premi8 = $_POST['Premi8'];
  922. $Div = $_POST['Div'];
  923. $RemarksAgent8 = $_POST['RemarksAgent8'];
  924.  
  925. $IdEnt9=$_POST['IdEnt9'];
  926. $Nominal9=$_POST['Nominal9'];
  927. $TypeCost9 = $_POST['TypeCost9'];
  928. $EntDate9 = $_POST['EntDate9'];
  929. $EntParty9 = $_POST['EntParty9'];
  930. $Premi9 = $_POST['Premi9'];
  931. $Div = $_POST['Div'];
  932. $RemarksAgent9 = $_POST['RemarksAgent9'];
  933.  
  934. $IdEnt10=$_POST['IdEnt10'];
  935. $Nominal10=$_POST['Nominal10'];
  936. $TypeCost10 = $_POST['TypeCost10'];
  937. $EntDate10 = $_POST['EntDate10'];
  938. $EntParty10 = $_POST['EntParty10'];
  939. $Premi10 = $_POST['Premi10'];
  940. $Div = $_POST['Div'];
  941. $RemarksAgent10 = $_POST['RemarksAgent10'];
  942.  
  943.  
  944.  
  945.  
  946. $EntParty = strtoupper(str_replace("'", "'", $EntParty1));
  947.  
  948.  
  949. $EntParty = strtoupper(str_replace("'", "'", $EntParty2));
  950.  
  951.  
  952.  
  953. $EntParty = strtoupper(str_replace("'", "'", $EntParty3));
  954.  
  955.  
  956.  
  957. $EntParty = strtoupper(str_replace("'", "'", $EntParty4));
  958.  
  959.  
  960.  
  961. $EntParty = strtoupper(str_replace("'", "'", $EntParty5));
  962.  
  963.  
  964.  
  965. $EntParty = strtoupper(str_replace("'", "'", $EntParty6));
  966.  
  967.  
  968.  
  969. $EntParty = strtoupper(str_replace("'", "'", $EntParty7));
  970.  
  971.  
  972.  
  973. $EntParty = strtoupper(str_replace("'", "'", $EntParty8));
  974.  
  975.  
  976.  
  977. $EntParty = strtoupper(str_replace("'", "'", $EntParty9));
  978.  
  979.  
  980.  
  981. $EntParty = strtoupper(str_replace("'", "'", $EntParty10));
  982.  
  983. $flag1 = 1; $flag2 = 1; $flag3 = 1; $flag4 = 1; $flag5 = 1;
  984. $flag6 = 1; $flag7 = 1; $flag8 = 1; $flag9 = 1; $flag10 = 1;
  985.  
  986. if($Nominal1 <> "")
  987. {
  988. $query11 = "update entReq
  989. set Nominal ='".$Nominal1."',
  990. EditDate = getdate(),
  991. TypeCost = '".$TypeCost1."',
  992. EntDate = convert(smalldatetime,'".$EntDate1."',103),
  993. EntParty = '".$EntParty1."',
  994. Premi = '".$Premi1."',
  995. Div = '".$Div1."',
  996. RemarksAgent = '".$RemarksAgent1."',
  997. where IdEnt = ".$IdEnt1;
  998.  
  999. echo $query11."<br>";
  1000. $result11=sqlsrv_query($conn, $query11);
  1001. if(!$result11)
  1002. {
  1003. $flag1 = 0;
  1004. }
  1005. }
  1006.  
  1007.  
  1008. if($Nominal2 <> "")
  1009. {
  1010. $query12 = "update entReq
  1011. set Nominal ='".$Nominal2."',
  1012. EditDate = getdate(),
  1013. TypeCost = '".$TypeCost2."',
  1014. EntDate = convert(smalldatetime,'".$EntDate2."',103),
  1015. EntParty = '".$EntParty2."',
  1016. Premi = '".$Premi2."'
  1017. Div = '".$Div."'
  1018. RemarksAgent = '".$RemarksAgent2."'
  1019. where IdEnt = ".$IdEnt2;
  1020. $result12=sqlsrv_query($conn, $query12);
  1021. if(!$result12)
  1022. {
  1023. $flag2 = 0;
  1024. }
  1025. }
  1026.  
  1027. if($Nominal3 <> "")
  1028. {
  1029. $query13 = "update entReq
  1030. set Nominal ='".$Nominal3."',
  1031. EditDate = getdate(),
  1032. TypeCost = '".$TypeCost3."',
  1033. EntDate = convert(smalldatetime,'".$EntDate3."',103),
  1034. EntParty = '".$EntParty3."',
  1035. Premi = '".$Premi3."'
  1036. Div = '".$Div."'
  1037. RemarksAgent = '".$RemarksAgent3."'
  1038. where IdEnt = ".$IdEnt3;
  1039. $result13=sqlsrv_query($conn, $query13);
  1040. if(!$result13)
  1041. {
  1042. $flag3 = 0;
  1043. }
  1044. }
  1045.  
  1046. if($Nominal4 <> "")
  1047. {
  1048. $query14 = "update entReq
  1049. set Nominal ='".$Nominal4."',
  1050. EditDate = getdate(),
  1051. TypeCost = '".$TypeCost4."',
  1052. EntDate = convert(smalldatetime,'".$EntDate4."',103),
  1053. EntParty = '".$EntParty4."',
  1054. Premi = '".$Premi4."'
  1055. Div = '".$Div."'
  1056. RemarksAgent = '".$RemarksAgent4."'
  1057. where IdEnt = ".$IdEnt4;
  1058. $result14=sqlsrv_query($conn, $query14);
  1059. if(!$result14)
  1060. {
  1061. $flag4 = 0;
  1062. }
  1063. }
  1064. if($Nominal5 <> "")
  1065. {
  1066. $query15 = "update entReq
  1067. set Nominal ='".$Nominal5."',
  1068. EditDate = getdate(),
  1069. TypeCost = '".$TypeCost5."',
  1070. EntDate = convert(smalldatetime,'".$EntDate5."',103),
  1071. EntParty = '".$EntParty5."',
  1072. Premi = '".$Premi5."'
  1073. Div = '".$Div."'
  1074. RemarksAgent = '".$RemarksAgent5."'
  1075. where IdEnt = ".$IdEnt5;
  1076. $result15=sqlsrv_query($conn, $query15);
  1077. if(!$result15)
  1078. {
  1079. $flag5 = 0;
  1080. }
  1081. }
  1082.  
  1083. if($Nominal6 <> "")
  1084. {
  1085. $query16 = "update entReq
  1086. set Nominal ='".$Nominal6."',
  1087. EditDate = getdate(),
  1088. TypeCost = '".$TypeCost6."',
  1089. EntDate = convert(smalldatetime,'".$EntDate6."',103),
  1090. EntParty = '".$EntParty6."',
  1091. Premi = '".$Premi6."'
  1092. Div = '".$Div."'
  1093. RemarksAgent = '".$RemarksAgent6."'
  1094. where IdEnt = ".$IdEnt6;
  1095. $result16=sqlsrv_query($conn, $query16);
  1096. if(!$result16)
  1097. {
  1098. $flag6 = 0;
  1099. }
  1100. }
  1101.  
  1102. if($Nominal7 <> "")
  1103. {
  1104. $query17 = "update entReq
  1105. set Nominal ='".$Nominal7."',
  1106. EditDate = getdate(),
  1107. TypeCost = '".$TypeCost7."',
  1108. EntDate = convert(smalldatetime,'".$EntDate7."',103),
  1109. EntParty = '".$EntParty7."',
  1110. Premi = '".$Premi7."'
  1111. Div = '".$Div."'
  1112. RemarksAgent = '".$RemarksAgent7."'
  1113. where IdEnt = ".$IdEnt7;
  1114. $result17=sqlsrv_query($conn, $query17);
  1115. if(!$result17)
  1116. {
  1117. $flag7 = 0;
  1118. }
  1119. }
  1120. if($Nominal8 <> "")
  1121. {
  1122. $query18 = "update entReq
  1123. set Nominal ='".$Nominal8."',
  1124. EditDate = getdate(),
  1125. TypeCost = '".$TypeCost8."',
  1126. EntDate = convert(smalldatetime,'".$EntDate8."',103),
  1127. EntParty = '".$EntParty8."',
  1128. Premi = '".$Premi8."'
  1129. Div = '".$Div."'
  1130. RemarksAgent = '".$RemarksAgent8."'
  1131. where IdEnt = ".$IdEnt8;
  1132. $result18=sqlsrv_query($conn, $query18);
  1133. if(!$result18)
  1134. {
  1135. $flag8 = 0;
  1136. }
  1137. }
  1138. if($Nominal9 <> "")
  1139. {
  1140. $query19 = "update entReq
  1141. set Nominal ='".$Nominal9."',
  1142. EditDate = getdate(),
  1143. TypeCost = '".$TypeCost9."',
  1144. EntDate = convert(smalldatetime,'".$EntDate9."',103),
  1145. EntParty = '".$EntParty9."',
  1146. Premi = '".$Premi9."'
  1147. Div = '".$Div."'
  1148. RemarksAgent = '".$RemarksAgent9."'
  1149. where IdEnt = ".$IdEnt9;
  1150. $result19=sqlsrv_query($conn, $query19);
  1151. if(!$result19)
  1152. {
  1153. $flag9 = 0;
  1154. }
  1155. }
  1156. if($Nominal10 <> "")
  1157. {
  1158. $query20 = "update entReq
  1159. set Nominal ='".$Nominal10."',
  1160. EditDate = getdate(),
  1161. TypeCost = '".$TypeCost10."',
  1162. EntDate = convert(smalldatetime,'".$EntDate10."',103),
  1163. EntParty = '".$EntParty10."',
  1164. Premi = '".$Premi10."'
  1165. Div = '".$Div."'
  1166. RemarksAgent = '".$RemarksAgent10."'
  1167. where IdEnt = ".$IdEnt10;
  1168. $result20=sqlsrv_query($conn, $query20);
  1169. if(!$result20)
  1170. {
  1171. $flag10 = 0;
  1172. }
  1173. }
  1174.  
  1175. if($flag1 == 1 && $flag2 == 1 && $flag3 == 1 && $flag4 == 1 && $flag5 = 1 &&
  1176. $flag6 == 1 && $flag7 == 1 && $flag8 == 1 && $flag9 == 1 && $flag10 == 1)
  1177. {
  1178. ?>
  1179. <div class="homeLayerNotif">
  1180. Update Request Success <br>
  1181. </div>
  1182. <?php
  1183. }
  1184. else
  1185. {
  1186. ?>
  1187. <div class="homeLayerNotifWrong">
  1188. <?php
  1189. if($flag1 == 0)
  1190. {
  1191. ?>
  1192. Update Request <?php echo $EntParty1 ?> Failed <br>
  1193. <?php
  1194. }
  1195. if($flag2 == 0)
  1196. {
  1197. ?>
  1198. Update Request <?php echo $EntParty2 ?> Failed <br>
  1199. <?php
  1200. }
  1201. if($flag3 == 0)
  1202. {
  1203. ?>
  1204. Update Request <?php echo $EntParty3 ?> Failed <br>
  1205. <?php
  1206. }
  1207. if($flag4 == 0)
  1208. {
  1209. ?>
  1210. Update Request <?php echo $EntParty4 ?> Failed <br>
  1211. <?php
  1212. }
  1213. if($flag5 == 0)
  1214. {
  1215. ?>
  1216. Update Request <?php echo $EntParty5 ?> Failed <br>
  1217. <?php
  1218. }
  1219. if($flag6 == 0)
  1220. {
  1221. ?>
  1222. Update Request <?php echo $EntParty6 ?> Failed <br>
  1223. <?php
  1224. }
  1225. if($flag7 == 0)
  1226. {
  1227. ?>
  1228. Update Request <?php echo $EntParty7 ?> Failed <br>
  1229. <?php
  1230. }
  1231. if($flag8 == 0)
  1232. {
  1233. ?>
  1234. Update Request <?php echo $EntParty8 ?> Failed <br>
  1235. <?php
  1236. }
  1237. if($flag9 == 0)
  1238. {
  1239. ?>
  1240. Update Request <?php echo $EntParty9 ?> Failed <br>
  1241. <?php
  1242. }
  1243. if($flag10 == 0)
  1244. {
  1245. ?>
  1246. Update Request <?php echo $EntParty10 ?> Failed <br>
  1247. <?php
  1248. }
  1249. ?>
  1250. </div>
  1251. <?php
  1252. }
  1253. }
  1254. ?>
  1255.  
  1256. <?php
  1257. if(isset($_GET['IdEnt']))
  1258. {
  1259. $IdEnt=$_GET['IdEnt'];
  1260. $queryC="select Nominal,InputDate,TypeCost,convert(varchar(20),EntDate,103) as 'EntDate',EntParty,Premi,Div,RemarksAgent from entReq where IdEnt=".$IdEnt;
  1261. $resultC1=sqlsrv_query($conn, $queryC);
  1262. $resultC2=sqlsrv_query($conn, $queryC);
  1263. $resultC3=sqlsrv_query($conn, $queryC);
  1264. $resultC4=sqlsrv_query($conn, $queryC);
  1265. $resultC5=sqlsrv_query($conn, $queryC);
  1266. $resultC6=sqlsrv_query($conn, $queryC);
  1267. $resultC7=sqlsrv_query($conn, $queryC);
  1268. $resultC8=sqlsrv_query($conn, $queryC);
  1269. $resultC9=sqlsrv_query($conn, $queryC);
  1270. $resultC10=sqlsrv_query($conn, $queryC);
  1271.  
  1272. // echo $queryC."<br>";
  1273. $rowC1=sqlsrv_fetch_array($resultC1);
  1274. $Nominal1=$rowC1['Nominal'];
  1275. $InputDate1=$rowC1['InputDate'];
  1276. $TypeCost1=$rowC1['TypeCost'];
  1277. $EntDate1=$rowC1['EntDate'];
  1278. $EntParty1=$rowC1['EntParty'];
  1279. $Premi1=$rowC1['Premi'];
  1280. $Div =$rowC1['Div'];
  1281. $RemarksAgent1 = $rowC1['RemarksAgent'];
  1282.  
  1283.  
  1284. $rowC2=sqlsrv_fetch_array($resultC2);
  1285. $Nominal2=$rowC2['Nominal2'];
  1286. $InputDate2=$rowC2['InputDate2'];
  1287. $TypeCost2=$rowC2['TypeCost2'];
  1288. $EntDate2=$rowC2['EntDate2'];
  1289. $EntParty2=$rowC2['EntParty2'];
  1290. $Premi2=$rowC2['Premi2'];
  1291. $Div =$rowC2['Div'];
  1292. $RemarksAgent2 = $rowC2['RemarksAgent2'];
  1293.  
  1294.  
  1295. $rowC3=sqlsrv_fetch_array($resultC3);
  1296. $Nominal3=$rowC3['Nominal3'];
  1297. $InputDate3=$rowC3['InputDate3'];
  1298. $TypeCost3=$rowC3['TypeCost3'];
  1299. $EntDate3=$rowC3['EntDate3'];
  1300. $EntParty3=$rowC3['EntParty3'];
  1301. $Premi3=$rowC3['Premi3'];
  1302. $Div =$rowC3['Div'];
  1303. $RemarksAgent3 = $rowC3['RemarksAgent3'];
  1304.  
  1305. $rowC4=sqlsrv_fetch_array($resultC4);
  1306. $Nominal4=$rowC4['Nominal4'];
  1307. $InputDate4=$rowC4['InputDate4'];
  1308. $TypeCost4=$rowC4['TypeCost4'];
  1309. $EntDate4=$rowC4['EntDate4'];
  1310. $EntParty4=$rowC4['EntParty4'];
  1311. $Premi4=$rowC4['Premi4'];
  1312. $Div =$rowC4['Div'];
  1313. $RemarksAgent4 = $rowC4['RemarksAgent4'];
  1314.  
  1315. $rowC5=sqlsrv_fetch_array($resultC5);
  1316. $Nominal5=$rowC5['Nominal5'];
  1317. $InputDate5=$rowC5['InputDate5'];
  1318. $TypeCost5=$rowC5['TypeCost5'];
  1319. $EntDate5=$rowC5['EntDate5'];
  1320. $EntParty5=$rowC5['EntParty5'];
  1321. $Premi5=$rowC5['Premi5'];
  1322. $Div=$rowC5['Div'];
  1323. $RemarksAgent5 = $rowC5['RemarksAgent5'];
  1324.  
  1325. $rowC6=sqlsrv_fetch_array($resultC6);
  1326. $Nominal6=$rowC6['Nominal6'];
  1327. $InputDate6=$rowC6['InputDate6'];
  1328. $TypeCost6=$rowC6['TypeCost6'];
  1329. $EntDate6=$rowC6['EntDate6'];
  1330. $EntParty6=$rowC6['EntParty6'];
  1331. $Premi6=$rowC6['Premi6'];
  1332. $Div =$rowC6['Div'];
  1333. $RemarksAgent6 = $rowC6['RemarksAgent6'];
  1334.  
  1335. $rowC7=sqlsrv_fetch_array($resultC7);
  1336. $Nominal7=$rowC7['Nominal7'];
  1337. $InputDate7=$rowC7['InputDate7'];
  1338. $TypeCost7=$rowC7['TypeCost7'];
  1339. $EntDate7=$rowC7['EntDate7'];
  1340. $EntParty7=$rowC7['EntParty7'];
  1341. $Premi7=$rowC7['Premi7'];
  1342. $Div =$rowC7['Div'];
  1343. $RemarksAgent7 = $rowC7['RemarksAgent7'];
  1344.  
  1345. $rowC8=sqlsrv_fetch_array($resultC8);
  1346. $Nominal8=$rowC8['Nominal8'];
  1347. $InputDate8=$rowC8['InputDate8'];
  1348. $TypeCost8=$rowC8['TypeCost8'];
  1349. $EntDate8=$rowC8['EntDate8'];
  1350. $EntParty8=$rowC8['EntParty8'];
  1351. $Premi8=$rowC8['Premi8'];
  1352. $Div =$rowC8['Div'];
  1353. $RemarksAgent8 = $rowC8['RemarksAgent8'];
  1354.  
  1355. $rowC9=sqlsrv_fetch_array($resultC9);
  1356. $Nominal9=$rowC9['Nominal9'];
  1357. $InputDate9=$rowC9['InputDate9'];
  1358. $TypeCost9=$rowC9['TypeCost9'];
  1359. $EntDate9=$rowC9['EntDate9'];
  1360. $EntParty9=$rowC9['EntParty9'];
  1361. $Premi9=$rowC9['Premi9'];
  1362. $Div =$rowC9['Div'];
  1363. $RemarksAgent9 = $rowC9['RemarksAgent9'];
  1364.  
  1365. $rowC10=sqlsrv_fetch_array($resultC10);
  1366. $Nominal10=$rowC10['Nominal10'];
  1367. $InputDate10=$rowC10['InputDate10'];
  1368. $TypeCost10=$rowC10['TypeCost10'];
  1369. $EntDate10=$rowC10['EntDate10'];
  1370. $EntParty10=$rowC10['EntParty10'];
  1371. $Premi10=$rowC10['Premi10'];
  1372. $Div =$rowC10['Div'];
  1373. $RemarksAgent10 = $rowC10['RemarksAgent10'];
  1374.  
  1375. }
  1376. else
  1377. {
  1378. $userID1="";
  1379. $Nominal1="";
  1380. $InputDate1="";
  1381. $TypeCost1="";
  1382. $EntDate1="";
  1383. $EntParty1="";
  1384. $Premi1="";
  1385. $Div="";
  1386. $RemarksAgent1="";
  1387.  
  1388. $userID2="";
  1389. $Nominal2="";
  1390. $InputDate2="";
  1391. $TypeCost2="";
  1392. $EntDate2="";
  1393. $EntParty2="";
  1394. $Premi2="";
  1395. $Div="";
  1396. $RemarksAgent2="";
  1397.  
  1398. $userID3="";
  1399. $Nominal3="";
  1400. $InputDate3="";
  1401. $TypeCost3="";
  1402. $EntDate3="";
  1403. $EntParty3="";
  1404. $Premi3="";
  1405. $Div="";
  1406. $RemarksAgent3="";
  1407.  
  1408. $userID4="";
  1409. $Nominal4="";
  1410. $InputDate4="";
  1411. $TypeCost4="";
  1412. $EntDate4="";
  1413. $EntParty4="";
  1414. $Premi4="";
  1415. $Div="";
  1416. $RemarksAgent4="";
  1417.  
  1418. $userID5="";
  1419. $Nominal5="";
  1420. $InputDate5="";
  1421. $TypeCost5="";
  1422. $EntDate5="";
  1423. $EntParty5="";
  1424. $Premi5="";
  1425. $Div="";
  1426. $RemarksAgent5="";
  1427.  
  1428. $userID6="";
  1429. $Nominal6="";
  1430. $InputDate6="";
  1431. $TypeCost6="";
  1432. $EntDate6="";
  1433. $EntParty6="";
  1434. $Premi6="";
  1435. $Div="";
  1436. $RemarksAgent6="";
  1437.  
  1438. $userID7="";
  1439. $Nominal7="";
  1440. $InputDate7="";
  1441. $TypeCost7="";
  1442. $EntDate7="";
  1443. $EntParty7="";
  1444. $Premi7="";
  1445. $Div="";
  1446. $RemarksAgent7="";
  1447.  
  1448. $userID8="";
  1449. $Nominal8="";
  1450. $InputDate8="";
  1451. $TypeCost8="";
  1452. $EntDate8="";
  1453. $EntParty8="";
  1454. $Premi8="";
  1455. $Div="";
  1456. $RemarksAgent8="";
  1457.  
  1458. $userID9="";
  1459. $Nominal9="";
  1460. $InputDate9="";
  1461. $TypeCost9="";
  1462. $EntDate9="";
  1463. $EntParty9="";
  1464. $Premi9="";
  1465. $Div="";
  1466. $RemarksAgent9="";
  1467.  
  1468. $userID10="";
  1469. $Nominal10="";
  1470. $InputDate10="";
  1471. $TypeCost10="";
  1472. $EntDate10="";
  1473. $EntParty10="";
  1474. $Premi10="";
  1475. $Div="";
  1476. $RemarksAgent10="";
  1477.  
  1478.  
  1479. }
  1480. ?>
  1481.  
  1482. <?php
  1483. $queryW = "select Name from Branch where Branch not in ('00','01')";
  1484. $resultW = sqlsrv_query($conn2, $queryW);
  1485. ?>
  1486.  
  1487. <div class="frameBasic">
  1488. <div class="frameInputFloat floatLeft backgroundGrey col80 padding20 height250 textCenter ">
  1489. <div class="frameTitle">
  1490. <?php
  1491. if (!isset($_GET['IdEnt']))
  1492. {
  1493. ?>
  1494. <h3 class="fontSize1">Input Request</h3>
  1495. <?php
  1496. }
  1497. elseif (isset($_GET['IdEnt']))
  1498. {
  1499. ?>
  1500. <h3 class="fontSize1">Edit Request</h3>
  1501. <?php
  1502. }
  1503. ?>
  1504. <div class="margine"></div>
  1505. </div>
  1506. <div class="margine2"></div>
  1507.  
  1508.  
  1509. <form name="form_1" action="ent_input" method="post" onsubmit="return
  1510. <input type="hidden" name="IdEnt" value="<?php echo $IdEnt ?>">
  1511. <table class="wew width100" >
  1512. <tr>
  1513. <th class="contentdata fontSize08 textCenter">Division</th>
  1514. </tr>
  1515.  
  1516. <tr>
  1517. <td class="contentdata fontSize08">
  1518. <select name="Div" class="selectinput2 textinputdasar">
  1519. <option value="0">--Select Division--</option>
  1520. <?php
  1521. while($rowW = sqlsrv_fetch_array($resultW))
  1522. {
  1523. ?>
  1524. <option value="<?php echo $rowW ['Name']?>" <?php echo $rowW ['Name'] == $Div?"selected":"" ?>><?php echo $rowW ['Name'] ?></option> <?php
  1525. }
  1526. ?>
  1527. </select>
  1528. <div class="margine1"></div>
  1529. </td>
  1530.  
  1531.  
  1532. <form name="form_1" action="ent_input" method="post" onsubmit="return
  1533. <input type="hidden" name="IdEnt" value="<?php echo $IdEnt ?>">
  1534. <table class="contentdata">
  1535. <th class="contentdata fontSize08 textCenter">Type Cost Representation</th>
  1536. <th class="contentdata fontSize08 textCenter">Entertainment Date</th>
  1537. <th class="contentdata fontSize08 textCenter">Nominal (Rp)</th>
  1538. <th class="contentdata fontSize08 textCenter">Entertainment Party</th>
  1539. <th class="contentdata fontSize08 textCenter">Premium Prospects (Rp)</th>
  1540. <th class="contentdata fontSize08 textCenter">Remarks</th>
  1541. </tr>
  1542. <tr>
  1543. <td class="contentdata fontSize07">
  1544. <select name="TypeCost1" class="selectinput">
  1545. <option value="0">--Select Type Cost Representation--</option>
  1546. <option value="Jamuan Makan" class="option1" <?php echo $TypeCost1 == strtoupper("Jamuan Makan")?"selected":"" ?>>Jamuan Makan</option>
  1547. <option value="Hadiah" class="option1" <?php echo $TypeCost1 == strtoupper("Hadiah")?"selected":"" ?>>Hadiah</option>
  1548. <option value="Uang Kas" class="option1" <?php echo $TypeCost1 == strtoupper("Uang Kas")?"selected":"" ?>>Uang Kas</option>
  1549. <option value="Hiburan" class="option1" <?php echo $TypeCost1 == strtoupper("Hiburan")?"selected":"" ?>>Hiburan</option>
  1550. <option value="Olah Raga" class="option1" <?php echo $TypeCost1 == strtoupper("Olah Raga")?"selected":"" ?>>Olah Raga</option>
  1551. <option value="Sumbangan/Amal" class="option1" <?php echo $TypeCost1 == strtoupper("Sumbangan/Amal")?"selected":"" ?>>Sumbangan/Amal</option>
  1552. <option value="Lain-Lain" class="option1" <?php echo $TypeCost1 == strtoupper("Lain-Lain")?"selected":"" ?>>Lain-Lain</option>
  1553. </select>
  1554. <div class="margine1"></div></td>
  1555.  
  1556. <td class="contentdata fontSize07"><input type="text" name="EntDate1" id="date1" class="textinputdasar fontSize09 marginLeft1" placeholder="Entertainment Date" value="<?php echo $EntDate1 ?>" required><div class="margine1"></div></td>
  1557.  
  1558. <td class="contentdata fontSize07"><input type="text" name="Nominal1" class="textinputdasar fontSize09 marginRight1" placeholder="Nominal" required onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Nominal1 ?>" required><div class="margine1"></div></td>
  1559.  
  1560. <td class="contentdata fontSize07"><input type="text" name="EntParty1" class="textinputdasar fontSize09" placeholder="Entertainment Party" value="<?php echo $EntParty1 ?>" required><div class="margine1"></div></td>
  1561.  
  1562. <td class="contentdata fontSize07"><input type="text" name="Premi1" class="textinputdasar fontSize09 marginLeft1" placeholder="Premium Prospects" required onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Premi1 ?>" required>
  1563. <div class="margine1"></div></td>
  1564.  
  1565. <td class="contentdata fontSize07"><textarea name="RemarksAgent1" class="textinputdasar width250 fontSize09" placeholder="Remarks"><?php echo $RemarksAgent1 ?></textarea>
  1566.  
  1567. <div class="margine1"></div></td>
  1568. </tr>
  1569. <tr>
  1570. <td class="contentdata fontSize07">
  1571. <select name="TypeCost2" class="selectinput">
  1572. <option value="0">--Select Type Cost Representation--</option>
  1573. <option value="Jamuan Makan" class="option1" <?php echo $TypeCost2 == strtoupper("Jamuan Makan")?"selected":"" ?>>Jamuan Makan</option>
  1574. <option value="Hadiah" class="option1" <?php echo $TypeCost2 == strtoupper("Hadiah")?"selected":"" ?>>Hadiah</option>
  1575. <option value="Uang Kas" class="option1" <?php echo $TypeCost2 == strtoupper("Uang Kas")?"selected":"" ?>>Uang Kas</option>
  1576. <option value="Hiburan" class="option1" <?php echo $TypeCost2 == strtoupper("Hiburan")?"selected":"" ?>>Hiburan</option>
  1577. <option value="Olah Raga" class="option1" <?php echo $TypeCost2 == strtoupper("Olah Raga")?"selected":"" ?>>Olah Raga</option>
  1578. <option value="Sumbangan/Amal" class="option1" <?php echo $TypeCost2 == strtoupper("Sumbangan/Amal")?"selected":"" ?>>Sumbangan/Amal</option>
  1579. <option value="Lain-Lain" class="option1" <?php echo $TypeCost2 == strtoupper("Lain-Lain")?"selected":"" ?>>Lain-Lain</option>
  1580. </select>
  1581. <div class="margine1"></div></td>
  1582.  
  1583. <td class="contentdata fontSize07"><input type="text" name="EntDate2" id="date2" class="textinputdasar fontSize09 marginLeft1" placeholder="Entertainment Date" value="<?php echo $EntDate2 ?>"><div class="margine1"></div></td>
  1584.  
  1585. <td class="contentdata fontSize07"><input type="text" name="Nominal2" class="textinputdasar fontSize09 marginRight1" placeholder="Nominal"onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Nominal2 ?>"><div class="margine1"></div></td>
  1586.  
  1587. <td class="contentdata fontSize07"><input type="text" name="EntParty2" class="textinputdasar fontSize09" placeholder="Entertainment Party" value="<?php echo $EntParty2 ?>"><div class="margine1"></div></td>
  1588.  
  1589. <td class="contentdata fontSize07"><input type="text" name="Premi2" class="textinputdasar fontSize09 marginLeft1" placeholder="Premium Prospects" onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Premi2 ?>">
  1590. <div class="margine1"></div></td>
  1591.  
  1592. <td class="contentdata fontSize07"><textarea name="RemarksAgent2" class="textinputdasar width250 fontSize09" placeholder="Remarks"><?php echo $RemarksAgent2 ?></textarea><div class="margine1"></div></td>
  1593. </tr>
  1594. <tr>
  1595. <td class="contentdata fontSize07">
  1596. <select name="TypeCost3" class="selectinput">
  1597. <option value="0">--Select Type Cost Representation--</option>
  1598. <option value="Jamuan Makan" class="option1" <?php echo $TypeCost3 == strtoupper("Jamuan Makan")?"selected":"" ?>>Jamuan Makan</option>
  1599. <option value="Hadiah" class="option1" <?php echo $TypeCost3 == strtoupper("Hadiah")?"selected":"" ?>>Hadiah</option>
  1600. <option value="Uang Kas" class="option1" <?php echo $TypeCost3 == strtoupper("Uang Kas")?"selected":"" ?>>Uang Kas</option>
  1601. <option value="Hiburan" class="option1" <?php echo $TypeCost3 == strtoupper("Hiburan")?"selected":"" ?>>Hiburan</option>
  1602. <option value="Olah Raga" class="option1" <?php echo $TypeCost3 == strtoupper("Olah Raga")?"selected":"" ?>>Olah Raga</option>
  1603. <option value="Sumbangan/Amal" class="option1" <?php echo $TypeCost3 == strtoupper("Sumbangan/Amal")?"selected":"" ?>>Sumbangan/Amal</option>
  1604. <option value="Lain-Lain" class="option1" <?php echo $TypeCost3 == strtoupper("Lain-Lain")?"selected":"" ?>>Lain-Lain</option>
  1605. </select>
  1606. <div class="margine1"></div></td>
  1607.  
  1608. <td class="contentdata fontSize07"><input type="text" name="EntDate3" id="date3" class="textinputdasar fontSize09 marginLeft1" placeholder="Entertainment Date" value="<?php echo $EntDate3 ?>"><div class="margine1"></div></td>
  1609.  
  1610. <td class="contentdata fontSize07"><input type="text" name="Nominal3" class="textinputdasar fontSize09 marginRight1" placeholder="Nominal"onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Nominal3 ?>"><div class="margine1"></div></td>
  1611.  
  1612. <td class="contentdata fontSize07"><input type="text" name="EntParty3" class="textinputdasar fontSize09" placeholder="Entertainment Party" value="<?php echo $EntParty3 ?>"><div class="margine1"></div></td>
  1613.  
  1614. <td class="contentdata fontSize07"><input type="text" name="Premi3" class="textinputdasar fontSize09 marginLeft1" placeholder="Premium Prospects"onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Premi3 ?>">
  1615. <div class="margine1"></div></td>
  1616.  
  1617. <td class="contentdata fontSize07"><textarea name="RemarksAgent3" class="textinputdasar width250 fontSize09" placeholder="Remarks"><?php echo $RemarksAgent3 ?></textarea><div class="margine1"></div></td>
  1618. </tr>
  1619. <tr>
  1620. <td class="contentdata fontSize07">
  1621. <select name="TypeCost4" class="selectinput">
  1622. <option value="0">--Select Type Cost Representation--</option>
  1623. <option value="Jamuan Makan" class="option1" <?php echo $TypeCost4 == strtoupper("Jamuan Makan")?"selected":"" ?>>Jamuan Makan</option>
  1624. <option value="Hadiah" class="option1" <?php echo $TypeCost4 == strtoupper("Hadiah")?"selected":"" ?>>Hadiah</option>
  1625. <option value="Uang Kas" class="option1" <?php echo $TypeCost4 == strtoupper("Uang Kas")?"selected":"" ?>>Uang Kas</option>
  1626. <option value="Hiburan" class="option1" <?php echo $TypeCost4 == strtoupper("Hiburan")?"selected":"" ?>>Hiburan</option>
  1627. <option value="Olah Raga" class="option1" <?php echo $TypeCost4 == strtoupper("Olah Raga")?"selected":"" ?>>Olah Raga</option>
  1628. <option value="Sumbangan/Amal" class="option1" <?php echo $TypeCost4 == strtoupper("Sumbangan/Amal")?"selected":"" ?>>Sumbangan/Amal</option>
  1629. <option value="Lain-Lain" class="option1" <?php echo $TypeCost4 == strtoupper("Lain-Lain")?"selected":"" ?>>Lain-Lain</option>
  1630. </select>
  1631. <div class="margine1"></div></td>
  1632.  
  1633. <td class="contentdata fontSize07"><input type="text" name="EntDate4" id="date4" class="textinputdasar fontSize09 marginLeft1" placeholder="Entertainment Date" value="<?php echo $EntDate4 ?>"><div class="margine1"></div></td>
  1634.  
  1635. <td class="contentdata fontSize07"><input type="text" name="Nominal4" class="textinputdasar fontSize09 marginRight1" placeholder="Nominal"onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Nominal4 ?>"><div class="margine1"></div></td>
  1636.  
  1637. <td class="contentdata fontSize07"><input type="text" name="EntParty4" class="textinputdasar fontSize09" placeholder="Entertainment Party" value="<?php echo $EntParty4 ?>"><div class="margine1"></div></td>
  1638.  
  1639. <td class="contentdata fontSize07"><input type="text" name="Premi4" class="textinputdasar fontSize09 marginLeft1" placeholder="Premium Prospects"onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Premi4 ?>">
  1640. <div class="margine1"></div></td>
  1641.  
  1642. <td class="contentdata fontSize07"><textarea name="RemarksAgent4" class="textinputdasar width250 fontSize09" placeholder="Remarks"><?php echo $RemarksAgent4 ?></textarea><div class="margine1"></div></td>
  1643. </tr>
  1644. <tr>
  1645. <td class="contentdata fontSize07">
  1646. <select name="TypeCost5" class="selectinput">
  1647. <option value="0">--Select Type Cost Representation--</option>
  1648. <option value="Jamuan Makan" class="option1" <?php echo $TypeCost5 == strtoupper("Jamuan Makan")?"selected":"" ?>>Jamuan Makan</option>
  1649. <option value="Hadiah" class="option1" <?php echo $TypeCost5 == strtoupper("Hadiah")?"selected":"" ?>>Hadiah</option>
  1650. <option value="Uang Kas" class="option1" <?php echo $TypeCost5 == strtoupper("Uang Kas")?"selected":"" ?>>Uang Kas</option>
  1651. <option value="Hiburan" class="option1" <?php echo $TypeCost5 == strtoupper("Hiburan")?"selected":"" ?>>Hiburan</option>
  1652. <option value="Olah Raga" class="option1" <?php echo $TypeCost5 == strtoupper("Olah Raga")?"selected":"" ?>>Olah Raga</option>
  1653. <option value="Sumbangan/Amal" class="option1" <?php echo $TypeCost5 == strtoupper("Sumbangan/Amal")?"selected":"" ?>>Sumbangan/Amal</option>
  1654. <option value="Lain-Lain" class="option1" <?php echo $TypeCost5 == strtoupper("Lain-Lain")?"selected":"" ?>>Lain-Lain</option>
  1655. </select>
  1656. <div class="margine1"></div></td>
  1657.  
  1658. <td class="contentdata fontSize07"><input type="text" name="EntDate5" id="date5" class="textinputdasar fontSize09 marginLeft1" placeholder="Entertainment Date" value="<?php echo $EntDate5 ?>"><div class="margine1"></div></td>
  1659.  
  1660. <td class="contentdata fontSize07"><input type="text" name="Nominal5" class="textinputdasar fontSize09 marginRight1" placeholder="Nominal"onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Nominal5 ?>"><div class="margine1"></div></td>
  1661.  
  1662. <td class="contentdata fontSize07"><input type="text" name="EntParty5" class="textinputdasar fontSize09" placeholder="Entertainment Party" value="<?php echo $EntParty5 ?>"><div class="margine1"></div></td>
  1663.  
  1664. <td class="contentdata fontSize07"><input type="text" name="Premi5" class="textinputdasar fontSize09 marginLeft1" placeholder="Premium Prospects"onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Premi5 ?>">
  1665. <div class="margine1"></div></td>
  1666.  
  1667. <td class="contentdata fontSize07"><textarea name="RemarksAgent5" class="textinputdasar width250 fontSize09" placeholder="Remarks"><?php echo $RemarksAgent5 ?></textarea><div class="margine1"></div></td>
  1668. </tr>
  1669. <tr>
  1670. <td class="contentdata fontSize07">
  1671. <select name="TypeCost6" class="selectinput">
  1672. <option value="0">--Select Type Cost Representation--</option>
  1673. <option value="Jamuan Makan" class="option1" <?php echo $TypeCost6 == strtoupper("Jamuan Makan")?"selected":"" ?>>Jamuan Makan</option>
  1674. <option value="Hadiah" class="option1" <?php echo $TypeCost6 == strtoupper("Hadiah")?"selected":"" ?>>Hadiah</option>
  1675. <option value="Uang Kas" class="option1" <?php echo $TypeCost6 == strtoupper("Uang Kas")?"selected":"" ?>>Uang Kas</option>
  1676. <option value="Hiburan" class="option1" <?php echo $TypeCost6 == strtoupper("Hiburan")?"selected":"" ?>>Hiburan</option>
  1677. <option value="Olah Raga" class="option1" <?php echo $TypeCost6 == strtoupper("Olah Raga")?"selected":"" ?>>Olah Raga</option>
  1678. <option value="Sumbangan/Amal" class="option1" <?php echo $TypeCost6 == strtoupper("Sumbangan/Amal")?"selected":"" ?>>Sumbangan/Amal</option>
  1679. <option value="Lain-Lain" class="option1" <?php echo $TypeCost6 == strtoupper("Lain-Lain")?"selected":"" ?>>Lain-Lain</option>
  1680. </select>
  1681. <div class="margine1"></div></td>
  1682.  
  1683. <td class="contentdata fontSize07"><input type="text" name="EntDate6" id="date6" class="textinputdasar fontSize09 marginLeft1" placeholder="Entertainment Date" value="<?php echo $EntDate6 ?>"><div class="margine1"></div></td>
  1684.  
  1685. <td class="contentdata fontSize07"><input type="text" name="Nominal6" class="textinputdasar fontSize09 marginRight1" placeholder="Nominal"onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Nominal6 ?>"><div class="margine1"></div></td>
  1686.  
  1687. <td class="contentdata fontSize07"><input type="text" name="EntParty6" class="textinputdasar fontSize09" placeholder="Entertainment Party" value="<?php echo $EntParty6 ?>"><div class="margine1"></div></td>
  1688.  
  1689. <td class="contentdata fontSize07"><input type="text" name="Premi6" class="textinputdasar fontSize09 marginLeft1" placeholder="Premium Prospects"onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Premi6 ?>">
  1690. <div class="margine1"></div></td>
  1691.  
  1692. <td class="contentdata fontSize07"><textarea name="RemarksAgent6" class="textinputdasar width250 fontSize09" placeholder="Remarks"><?php echo $RemarksAgent6 ?></textarea><div class="margine1"></div></td>
  1693. </tr>
  1694. <tr>
  1695. <td class="contentdata fontSize07">
  1696. <select name="TypeCost7" class="selectinput">
  1697. <option value="0">--Select Type Cost Representation--</option>
  1698. <option value="Jamuan Makan" class="option1" <?php echo $TypeCost7 == strtoupper("Jamuan Makan")?"selected":"" ?>>Jamuan Makan</option>
  1699. <option value="Hadiah" class="option1" <?php echo $TypeCost7 == strtoupper("Hadiah")?"selected":"" ?>>Hadiah</option>
  1700. <option value="Uang Kas" class="option1" <?php echo $TypeCost7 == strtoupper("Uang Kas")?"selected":"" ?>>Uang Kas</option>
  1701. <option value="Hiburan" class="option1" <?php echo $TypeCost7 == strtoupper("Hiburan")?"selected":"" ?>>Hiburan</option>
  1702. <option value="Olah Raga" class="option1" <?php echo $TypeCost7 == strtoupper("Olah Raga")?"selected":"" ?>>Olah Raga</option>
  1703. <option value="Sumbangan/Amal" class="option1" <?php echo $TypeCost7 == strtoupper("Sumbangan/Amal")?"selected":"" ?>>Sumbangan/Amal</option>
  1704. <option value="Lain-Lain" class="option1" <?php echo $TypeCost7 == strtoupper("Lain-Lain")?"selected":"" ?>>Lain-Lain</option>
  1705. </select>
  1706. <div class="margine1"></div></td>
  1707.  
  1708. <td class="contentdata fontSize07"><input type="text" name="EntDate7" id="date7" class="textinputdasar fontSize09 marginLeft1" placeholder="Entertainment Date" value="<?php echo $EntDate7 ?>"><div class="margine1"></div></td>
  1709.  
  1710. <td class="contentdata fontSize07"><input type="text" name="Nominal7" class="textinputdasar fontSize09 marginRight1" placeholder="Nominal"onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Nominal7 ?>"><div class="margine1"></div></td>
  1711.  
  1712. <td class="contentdata fontSize07"><input type="text" name="EntParty7" class="textinputdasar fontSize09" placeholder="Entertainment Party" value="<?php echo $EntParty7 ?>"><div class="margine1"></div></td>
  1713.  
  1714. <td class="contentdata fontSize07"><input type="text" name="Premi7" class="textinputdasar fontSize09 marginLeft1" placeholder="Premium Prospects"onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Premi7 ?>">
  1715. <div class="margine1"></div></td>
  1716.  
  1717. <td class="contentdata fontSize07"><textarea name="RemarksAgent7" class="textinputdasar width250 fontSize09" placeholder="Remarks"><?php echo $RemarksAgent7 ?></textarea><div class="margine1"></div></td>
  1718. </tr>
  1719. <tr>
  1720. <td class="contentdata fontSize07">
  1721. <select name="TypeCost8" class="selectinput">
  1722. <option value="0">--Select Type Cost Representation--</option>
  1723. <option value="Jamuan Makan" class="option1" <?php echo $TypeCost8 == strtoupper("Jamuan Makan")?"selected":"" ?>>Jamuan Makan</option>
  1724. <option value="Hadiah" class="option1" <?php echo $TypeCost8 == strtoupper("Hadiah")?"selected":"" ?>>Hadiah</option>
  1725. <option value="Uang Kas" class="option1" <?php echo $TypeCost8 == strtoupper("Uang Kas")?"selected":"" ?>>Uang Kas</option>
  1726. <option value="Hiburan" class="option1" <?php echo $TypeCost8 == strtoupper("Hiburan")?"selected":"" ?>>Hiburan</option>
  1727. <option value="Olah Raga" class="option1" <?php echo $TypeCost8 == strtoupper("Olah Raga")?"selected":"" ?>>Olah Raga</option>
  1728. <option value="Sumbangan/Amal" class="option1" <?php echo $TypeCost8 == strtoupper("Sumbangan/Amal")?"selected":"" ?>>Sumbangan/Amal</option>
  1729. <option value="Lain-Lain" class="option1" <?php echo $TypeCost8 == strtoupper("Lain-Lain")?"selected":"" ?>>Lain-Lain</option>
  1730. </select>
  1731. <div class="margine1"></div></td>
  1732.  
  1733. <td class="contentdata fontSize07"><input type="text" name="EntDate8" id="date8" class="textinputdasar fontSize09 marginLeft1" placeholder="Entertainment Date" value="<?php echo $EntDate8 ?>"><div class="margine1"></div></td>
  1734.  
  1735. <td class="contentdata fontSize07"><input type="text" name="Nominal8" class="textinputdasar fontSize09 marginRight1" placeholder="Nominal" onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Nominal8 ?>"><div class="margine1"></div></td>
  1736.  
  1737. <td class="contentdata fontSize07"><input type="text" name="EntParty8" class="textinputdasar fontSize09" placeholder="Entertainment Party" value="<?php echo $EntParty8 ?>"><div class="margine1"></div></td>
  1738.  
  1739. <td class="contentdata fontSize07"><input type="text" name="Premi8" class="textinputdasar fontSize09 marginLeft1" placeholder="Premium Prospects"onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Premi8 ?>">
  1740. <div class="margine1"></div></td>
  1741.  
  1742. <td class="contentdata fontSize07"><textarea name="RemarksAgent8" class="textinputdasar width250 fontSize09" placeholder="Remarks"><?php echo $RemarksAgent8 ?></textarea><div class="margine1"></div></td>
  1743. </tr>
  1744. <tr>
  1745. <td class="contentdata fontSize07">
  1746. <select name="TypeCost9" class="selectinput">
  1747. <option value="0">--Select Type Cost Representation--</option>
  1748. <option value="Jamuan Makan" class="option1" <?php echo $TypeCost9 == strtoupper("Jamuan Makan")?"selected":"" ?>>Jamuan Makan</option>
  1749. <option value="Hadiah" class="option1" <?php echo $TypeCost9 == strtoupper("Hadiah")?"selected":"" ?>>Hadiah</option>
  1750. <option value="Uang Kas" class="option1" <?php echo $TypeCost9 == strtoupper("Uang Kas")?"selected":"" ?>>Uang Kas</option>
  1751. <option value="Hiburan" class="option1" <?php echo $TypeCost9 == strtoupper("Hiburan")?"selected":"" ?>>Hiburan</option>
  1752. <option value="Olah Raga" class="option1" <?php echo $TypeCost9 == strtoupper("Olah Raga")?"selected":"" ?>>Olah Raga</option>
  1753. <option value="Sumbangan/Amal" class="option1" <?php echo $TypeCost9 == strtoupper("Sumbangan/Amal")?"selected":"" ?>>Sumbangan/Amal</option>
  1754. <option value="Lain-Lain" class="option1" <?php echo $TypeCost9 == strtoupper("Lain-Lain")?"selected":"" ?>>Lain-Lain</option>
  1755. </select>
  1756. <div class="margine1"></div></td>
  1757.  
  1758. <td class="contentdata fontSize07"><input type="text" name="EntDate9" id="date9" class="textinputdasar fontSize09 marginLeft1" placeholder="Entertainment Date" value="<?php echo $EntDate9 ?>"><div class="margine1"></div></td>
  1759.  
  1760. <td class="contentdata fontSize07"><input type="text" name="Nominal9" class="textinputdasar fontSize09 marginRight1" placeholder="Nominal"onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Nominal9 ?>"><div class="margine1"></div></td>
  1761.  
  1762. <td class="contentdata fontSize07"><input type="text" name="EntParty9" class="textinputdasar fontSize09" placeholder="Entertainment Party" value="<?php echo $EntParty9 ?>"><div class="margine1"></div></td>
  1763.  
  1764. <td class="contentdata fontSize07"><input type="text" name="Premi9" class="textinputdasar fontSize09 marginLeft1" placeholder="Premium Prospects"onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Premi9 ?>">
  1765. <div class="margine1"></div></td>
  1766.  
  1767. <td class="contentdata fontSize07"><textarea name="RemarksAgent9" class="textinputdasar width250 fontSize09" placeholder="Remarks"><?php echo $RemarksAgent9 ?></textarea><div class="margine1"></div></td>
  1768. </tr>
  1769. <tr>
  1770. <td class="contentdata fontSize07">
  1771. <select name="TypeCost10" class="selectinput">
  1772. <option value="0">--Select Type Cost Representation--</option>
  1773. <option value="Jamuan Makan" class="option1" <?php echo $TypeCost10 == strtoupper("Jamuan Makan")?"selected":"" ?>>Jamuan Makan</option>
  1774. <option value="Hadiah" class="option1" <?php echo $TypeCost10 == strtoupper("Hadiah")?"selected":"" ?>>Hadiah</option>
  1775. <option value="Uang Kas" class="option1" <?php echo $TypeCost10 == strtoupper("Uang Kas")?"selected":"" ?>>Uang Kas</option>
  1776. <option value="Hiburan" class="option1" <?php echo $TypeCost10 == strtoupper("Hiburan")?"selected":"" ?>>Hiburan</option>
  1777. <option value="Olah Raga" class="option1" <?php echo $TypeCost10 == strtoupper("Olah Raga")?"selected":"" ?>>Olah Raga</option>
  1778. <option value="Sumbangan/Amal" class="option1" <?php echo $TypeCost10 == strtoupper("Sumbangan/Amal")?"selected":"" ?>>Sumbangan/Amal</option>
  1779. <option value="Lain-Lain" class="option1" <?php echo $TypeCost10 == strtoupper("Lain-Lain")?"selected":"" ?>>Lain-Lain</option>
  1780. </select>
  1781. <div class="margine1"></div></td>
  1782.  
  1783. <td class="contentdata fontSize07"><input type="text" name="EntDate10" id="date10" class="textinputdasar fontSize09 marginLeft1" placeholder="Entertainment Date"value="<?php echo $EntDate10 ?>"><div class="margine1"></div></td>
  1784.  
  1785. <td class="contentdata fontSize07"><input type="text" name="Nominal10" class="textinputdasar fontSize09 marginRight1" placeholder="Nominal"onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Nominal10 ?>"><div class="margine1"></div></td>
  1786.  
  1787. <td class="contentdata fontSize07"><input type="text" name="EntParty10" class="textinputdasar fontSize09" placeholder="Entertainment Party" value="<?php echo $EntParty10 ?>"><div class="margine1"></div></td>
  1788.  
  1789. <td class="contentdata fontSize07"><input type="text" name="Premi10" class="textinputdasar fontSize09 marginLeft1" placeholder="Premium Prospects"onkeyup="javascript:this.value=Comma(this.value)" value="<?php echo $Premi10 ?>">
  1790. <div class="margine1"></div></td>
  1791.  
  1792. <td class="contentdata fontSize07"><textarea name="RemarksAgent10" class="textinputdasar width250 fontSize09" placeholder="Remarks"><?php echo $RemarksAgent10 ?></textarea><div class="margine1"></div></td>
  1793. </tr>
  1794.  
  1795. </form>
  1796.  
  1797. </table>
  1798. <div class="margine2"></div>
  1799.  
  1800. <?php
  1801. if(!isset($_GET['IdEnt']))
  1802. {
  1803. ?>
  1804. <input type="submit" name="cmdSubmit" class="buttonLink fontSize09" value="Submit Data">
  1805. <?php
  1806. }
  1807. elseif (isset($_GET['IdEnt']))
  1808. {
  1809. ?>
  1810. <input type="submit" name="cmdEdit" class="buttonLink fontSize09" value="Edit Data">
  1811. <?php
  1812. }
  1813. ?>
  1814.  
  1815. </div>
  1816.  
  1817. <div class="margine"></div>
  1818. </div>
  1819. </div>
  1820.  
  1821. <?php
  1822. include ('footer.php');
  1823. ?>
  1824. </body>
  1825. </html>
  1826.  
  1827. <script src="js/chosen.jquery.min.js"></script>
  1828. <script src="js/bootstrap-datepicker.js"></script>
  1829. <script type="text/javascript">
  1830. $('.chosen-select').chosen({allow_single_deselect:true});
  1831. $('#date1').datepicker({
  1832. format: "dd/mm/yyyy",
  1833. //endDate: "<?php echo date('d/m/Y') ?>",
  1834. todayBtn: true,
  1835. autoclose: true,
  1836. todayHighlight: true
  1837. });
  1838. </script>
  1839. <script type="text/javascript">
  1840. $('.chosen-select').chosen({allow_single_deselect:true});
  1841. $('#date2').datepicker({
  1842. format: "dd/mm/yyyy",
  1843. //endDate: "<?php echo date('d/m/Y') ?>",
  1844. todayBtn: true,
  1845. autoclose: true,
  1846. todayHighlight: true
  1847. });
  1848. </script>
  1849. <script type="text/javascript">
  1850. $('.chosen-select').chosen({allow_single_deselect:true});
  1851. $('#date3').datepicker({
  1852. format: "dd/mm/yyyy",
  1853. //endDate: "<?php echo date('d/m/Y') ?>",
  1854. todayBtn: true,
  1855. autoclose: true,
  1856. todayHighlight: true
  1857. });
  1858. </script>
  1859. <script type="text/javascript">
  1860. $('.chosen-select').chosen({allow_single_deselect:true});
  1861. $('#date4').datepicker({
  1862. format: "dd/mm/yyyy",
  1863. //endDate: "<?php echo date('d/m/Y') ?>",
  1864. todayBtn: true,
  1865. autoclose: true,
  1866. todayHighlight: true
  1867. });
  1868. </script>
  1869. <script type="text/javascript">
  1870. $('.chosen-select').chosen({allow_single_deselect:true});
  1871. $('#date5').datepicker({
  1872. format: "dd/mm/yyyy",
  1873. //endDate: "<?php echo date('d/m/Y') ?>",
  1874. todayBtn: true,
  1875. autoclose: true,
  1876. todayHighlight: true
  1877. });
  1878. </script>
  1879. <script type="text/javascript">
  1880. $('.chosen-select').chosen({allow_single_deselect:true});
  1881. $('#date6').datepicker({
  1882. format: "dd/mm/yyyy",
  1883. //endDate: "<?php echo date('d/m/Y') ?>",
  1884. todayBtn: true,
  1885. autoclose: true,
  1886. todayHighlight: true
  1887. });
  1888. </script>
  1889. <script type="text/javascript">
  1890. $('.chosen-select').chosen({allow_single_deselect:true});
  1891. $('#date7').datepicker({
  1892. format: "dd/mm/yyyy",
  1893. //endDate: "<?php echo date('d/m/Y') ?>",
  1894. todayBtn: true,
  1895. autoclose: true,
  1896. todayHighlight: true
  1897. });
  1898. </script>
  1899. <script type="text/javascript">
  1900. $('.chosen-select').chosen({allow_single_deselect:true});
  1901. $('#date8').datepicker({
  1902. format: "dd/mm/yyyy",
  1903. //endDate: "<?php echo date('d/m/Y') ?>",
  1904. todayBtn: true,
  1905. autoclose: true,
  1906. todayHighlight: true
  1907. });
  1908. </script>
  1909. <script type="text/javascript">
  1910. $('.chosen-select').chosen({allow_single_deselect:true});
  1911. $('#date9').datepicker({
  1912. format: "dd/mm/yyyy",
  1913. //endDate: "<?php echo date('d/m/Y') ?>",
  1914. todayBtn: true,
  1915. autoclose: true,
  1916. todayHighlight: true
  1917. });
  1918. </script>
  1919. <script type="text/javascript">
  1920. $('.chosen-select').chosen({allow_single_deselect:true});
  1921. $('#date10').datepicker({
  1922. format: "dd/mm/yyyy",
  1923. //endDate: "<?php echo date('d/m/Y') ?>",
  1924. todayBtn: true,
  1925. autoclose: true,
  1926. todayHighlight: true
  1927. });
  1928. </script>
  1929. <link rel="stylesheet" href="css/chosen.css" />
  1930. <link rel="stylesheet" href="css/bootstrap-datepicker.standalone.css" />
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement