Guest User

Untitled

a guest
Mar 23rd, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.54 KB | None | 0 0
  1. for($j=0;$j<count($fees_type_arr);$j++){
  2. $month = "N/A";
  3. switch ($fees_type_arr[$j]) {
  4. case 'adm':
  5. $sql_record_data = array(
  6. 'tid' => $tid.$j+1,
  7. 'slip_no' => $slip_no,
  8. 'date_time' => $current_date_time,
  9. 'uid' => $uid,
  10. 'month' => $month,
  11. 'amount' => $admission_fees,
  12. 'fees_type' => 'adm'
  13. );
  14. if($wpdb->insert($record_table, $sql_record_data)){
  15. $ok = 1;
  16. }
  17. else{
  18. $ok = 0;
  19. throw new Exception($wpdb->print_error());
  20. }
  21. break;
  22.  
  23. case "trn":
  24. $sql_record_data = array(
  25. 'tid' => $tid.$j+1,
  26. 'slip_no' => $slip_no,
  27. 'date_time' => $current_date_time,
  28. 'uid' => $uid,
  29. 'month' => $month,
  30. 'amount' => $transport_chg,
  31. 'fees_type' => 'trn'
  32. );
  33. if($wpdb->insert($record_table, $sql_record_data)){
  34. $ok = 1;
  35. }
  36. else{
  37. $ok = 0;
  38. throw new Exception($wpdb->print_error());
  39. }
  40. break;
  41.  
  42. case "ann":
  43. $sql_record_data = array(
  44. 'tid' => $tid.$j+1,
  45. 'slip_no' => $slip_no,
  46. 'date_time' => $current_date_time,
  47. 'uid' => $uid,
  48. 'month' => $month,
  49. 'amount' => $annual_chg,
  50. 'fees_type' => 'ann'
  51. );
  52. if($wpdb->insert($record_table, $sql_record_data)){
  53. $ok = 1;
  54. }
  55. else{
  56. $ok = 0;
  57. throw new Exception($wpdb->print_error());
  58. }
  59. break;
  60.  
  61. case "rec":
  62. $sql_record_data = array(
  63. 'tid' => $tid.$j+1,
  64. 'slip_no' => $slip_no,
  65. 'date_time' => $current_date_time,
  66. 'uid' => $uid,
  67. 'month' => $month,
  68. 'amount' => $recreation_chg,
  69. 'fees_type' => 'rec'
  70. );
  71. if($wpdb->insert($record_table, $sql_record_data)){
  72. $ok = 1;
  73. }
  74. else{
  75. $ok = 0;
  76. throw new Exception($wpdb->print_error());
  77. }
  78. break;
  79. }
  80. }
  81.  
  82. $fees_type_arr = array("adm","ttn","trn","ann","rec");
Add Comment
Please, Sign In to add comment