API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
138
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 72.39 KB | None | 0 0
raw download clone embed print report
  1. public function dbbl_action_new($action, $invoice)
  2. {
  3. $str = "java -jar /var/www/html/DBBLECOM2LIVE/ecomm_merchant.jar /var/www/html/DBBLECOM2LIVE/merchant.properties -c " . $_POST['trans_id'] . " " . $_SERVER['REMOTE_ADDR'];
  4.  
  5. exec($str, $outputArray);
  6.  
  7.  
  8. $firstExplode = explode(':', $outputArray[9]);
  9. $secondExplode = explode('-', $firstExplode[1]);
  10. $finalSessionInvoiceId = $secondExplode[1];
  11.  
  12. $invoiceNo =filter_var($invoice, FILTER_SANITIZE_NUMBER_INT);
  13. $std_id=substr($invoiceNo,0,strlen($invoiceNo)-10);
  14.  
  15. $check = $this->db->where(['student_id' => $std_id, 'transection_id' => $_POST['trans_id']])->get('dbbl_new');
  16.  
  17. if ($check->num_rows()>0){
  18. $dbblData = $check->row();
  19. $this->db->where('id', $dbblData->id);
  20. $this->db->update('dbbl_new', array('dbbl_data'=>json_encode($outputArray), 'update_date' => date('Y-m-d')));
  21. }
  22.  
  23.  
  24. /*echo $insertId;
  25. exit;*/
  26.  
  27.  
  28. $invoiceNum = filter_var($finalSessionInvoiceId, FILTER_SANITIZE_NUMBER_INT);
  29.  
  30. $transaction['transation_id'] = $_POST['trans_id'];
  31. $transaction['payment_method'] = 'dbbl';
  32. // $transaction['amount_with_tax'] = $this->session->userdata($finalSessionInvoiceId)['amount'];
  33. $transaction['amount_with_tax'] = filter_var($outputArray[6], FILTER_SANITIZE_NUMBER_INT) / 100;
  34. $sessionData[$finalSessionInvoiceId] = $this->session->userdata($finalSessionInvoiceId);
  35.  
  36. //$this->session->unset_userdata($finalSessionInvoiceId);
  37.  
  38. $data[$finalSessionInvoiceId] = array_merge($sessionData[$finalSessionInvoiceId], $transaction);
  39. $this->session->set_userdata($data);
  40.  
  41.  
  42. //-----------------Load Success Message------------------
  43. $invoice = $finalSessionInvoiceId;
  44.  
  45. $invoiceNum = filter_var($invoice, FILTER_SANITIZE_NUMBER_INT);
  46.  
  47. if (count($data['courseEnrollmentInvoiceId' . $invoiceNum]) > 1) {
  48.  
  49. //$sessionData = $this->session->userdata($invoice);
  50.  
  51. // amount check //
  52.  
  53. // if(!($sessionData['amount_with_tax']>=$sessionData['amount']))
  54. // {
  55. // echo 'invalid amount request not accepted, sorry please try again';
  56. // exit;
  57. // }
  58. //
  59.  
  60. /*$data['student_id'] = $sessionData['student_id'];
  61. // $data['service_id'] = '2';
  62. $data['program_id'] = $sessionData['program_id'];
  63. $data['program_group_id'] = $sessionData['group_id'];
  64. $data['program_circular_id'] = $sessionData['circular_id'];
  65. $data['invoice_id'] = $invoiceNum;
  66. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  67. $data['paid_amount'] = $sessionData['amount'];
  68. $data['transaction_id'] = $sessionData['transation_id'];
  69. $data['payment_method'] = $sessionData['payment_method'];
  70. $data['create_date'] = date('Y/m/d');*/
  71.  
  72.  
  73. $circularData = $this->db->select('program_circular.academic_year,program_student_information.program_study_center_id')->from('program_student_information')->join('program_circular', 'program_student_information.program_circular_id=program_circular.program_circular_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  74.  
  75. $rc_src = $this->db->select('program_src.program_src_id,program_rrc.program_rrc_id')->from('program_study_center')->join('program_src', 'program_study_center.program_src_id=program_src.program_src_id')->join('program_rrc', 'program_src.program_rrc_id=program_rrc.program_rrc_id')->where('program_study_center_id', $circularData->program_study_center_id)->get()->row();
  76.  
  77. $school = $this->db->select('school.school_id')->from('program')->join('school', 'program.school_id=school.school_id')->where('program.program_id', $sessionData['program_id'])->get()->row();
  78.  
  79. $payment_record_data['student_id'] = $sessionData['student_id'];
  80. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  81. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  82. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  83. $payment_record_data['service_id'] = 17;
  84. $payment_record_data['school_id'] = $school->school_id;
  85. $payment_record_data['academic_year'] = $circularData->academic_year;
  86. $payment_record_data['program_id'] = $sessionData['program_id'];
  87. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  88. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  89. $payment_record_data['invoice_id'] = $invoiceNum;
  90. $payment_record_data['paid_amount'] = $sessionData['amount'];
  91. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  92. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  93. $payment_record_data['create_date'] = date('Y/m/d');
  94.  
  95.  
  96. /*echo '<pre>';
  97. print_r($payment_record_data);
  98. echo '</pre>';
  99. exit;*/
  100.  
  101. $insertId = $this->common_model->save('payment_record', $payment_record_data);
  102. if ($insertId <> 0) {
  103. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  104. $dataStudentCourse['courses_id'] = $sessionData['checkedCourses'];
  105. $dataStudentCourse['payment_record_id'] = $insertId;
  106. $dataStudentCourse['term_year'] = $this->session->userdata('admission_for' . ($sessionData['student_id'] - 1));
  107. $dataStudentCourse['application_date'] = date('Y') . '-' . date('m') . '-' . date('d');
  108. $dataStudentCourse['course_enrollment'] = 1;
  109.  
  110. $this->common_model->save('student_course_info', $dataStudentCourse);
  111.  
  112. //For Email and sms
  113. $email_id = $this->db->select('user_student.email,user_student.mobile_number')->from('user_student')->join('program_student_information', 'program_student_information.user_student_id=user_student.user_student_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  114. $this->email($email_id->email, 'You have successfully requested for Course Enrollment at Bangladesh Open University');
  115.  
  116. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Course Enrollment at Bangladesh Open University");
  117.  
  118.  
  119. $successData['amount'] = $sessionData['amount_with_tax'];
  120. $successData['service_name'] = $sessionData['service_name'];
  121.  
  122. $this->load->view('success_payment', $successData);
  123.  
  124. $this->session->unset_userdata('courseEnrollmentInvoiceId' . $invoiceNum);
  125. }
  126.  
  127. // echo '<pre>';
  128. // print_r($sessionData);
  129. // echo '</pre>';
  130. // echo '<pre>',print_r($this->session->all_userdata()),'</pre>';
  131. } elseif (count($data['registrationData' . $invoiceNum]) > 1) {
  132. /*echo '<pre>',print_r($this->session->all_userdata()),'</pre>';
  133. exit;*/
  134. $sessionAllData = $data['registrationData' . $invoiceNum];
  135.  
  136.  
  137. $data['student_name_bangla'] = $sessionAllData['student_name_bangla'];
  138. $data['student_name_english'] = $sessionAllData['student_name_english'];
  139. $data['fathers_name_bangla'] = $sessionAllData['fathers_name_bangla'];
  140. $data['fathers_name_english'] = $sessionAllData['fathers_name_english'];
  141. $data['mothers_name_bangla'] = $sessionAllData['mothers_name_bangla'];
  142. $data['mothers_name_english'] = $sessionAllData['mothers_name_english'];
  143. $data['photo'] = $sessionAllData['photo'];
  144. $data['signature'] = $sessionAllData['signature'];
  145. $data['legal_guardian_name'] = $sessionAllData['legal_guardian_name'];
  146. $data['date_of_birth'] = strtotime($sessionAllData['date_of_birth']);
  147. $data['place_of_birth'] = $sessionAllData['place_of_birth'];
  148. $data['marital_status'] = $sessionAllData['marital_status'];
  149. $data['gender'] = $sessionAllData['gender'];
  150. $data['quota_id'] = $sessionAllData['quota_id'];
  151. $data['national_id'] = $sessionAllData['national_id'];
  152. $data['nationality'] = $sessionAllData['nationality'];
  153. $data['present_village'] = $sessionAllData['present_village'];
  154. $data['present_post_office'] = $sessionAllData['present_post_office'];
  155. $data['present_post_code'] = $sessionAllData['present_post_code'];
  156. $data['present_district_id'] = $sessionAllData['present_district_id'];
  157. $data['present_upazilla_id'] = $sessionAllData['present_upazilla_id'];
  158. $data['permanent_village'] = $sessionAllData['permanent_village'];
  159. $data['permanent_post_office'] = $sessionAllData['permanent_post_office'];
  160. $data['permanent_post_code'] = $sessionAllData['permanent_post_code'];
  161. $data['permanent_district_id'] = $sessionAllData['permanent_district_id'];
  162. $data['permanent_upazilla_id'] = $sessionAllData['permanent_upazilla_id'];
  163. $data['quota_id'] = $sessionAllData['quota_id'];
  164. $data['mobile_number'] = $sessionAllData['mobile_number'];
  165. $data['email'] = $sessionAllData['email'];
  166. $data['job_experience'] = $sessionAllData['job_experience'];
  167. $data['blood_group'] = $sessionAllData['blood_group'];
  168. $data['direct_admissionCheck'] = $sessionAllData['direct_admissionCheck'];
  169. // $data['academic_history'] = $this->session->userdata('academic_history'.$invoiceNum);
  170. /*echo '<pre>',print_r($data),'</pre>';
  171. exit;*/
  172.  
  173. $academic_history = $this->db->select('academic_history,additional_documents_name,additional_documents_file_location')->from('student_registration_temporary_data')->where('invoice_number', $invoiceNum)->get()->row();
  174.  
  175. $data['academic_history'] = $academic_history->academic_history;
  176. $data['additional_documents_name'] = $academic_history->additional_documents_name;
  177. $data['additional_documents_file_location'] = $academic_history->additional_documents_file_location;
  178.  
  179. $explodeAdmissionFor = explode('#', $sessionAllData['admission_for']);
  180. if (count($explodeAdmissionFor) > 0) {
  181. if ($explodeAdmissionFor[1] == 'semester')
  182. $admissionFor = $explodeAdmissionFor[0] . '#semister';
  183. else
  184. $admissionFor = $sessionAllData['admission_for'];
  185. } else {
  186. $admissionFor = $sessionAllData['admission_for'];
  187. }
  188. $data['admission_for'] = $admissionFor;
  189. $this->db->insert('user_student', $data);
  190. $id = mysqli_insert_id();
  191.  
  192. if ($id <> 0 && $id <> '') {
  193. //admission data in session
  194. $sessionData2['admission_for' . $id] = $sessionAllData['admission_for'];
  195. $this->session->set_userdata($sessionData2);
  196. //end admission data in session
  197.  
  198. //program info
  199. $password = $this->common_model->get_password(6);
  200. $data1['user_student_id'] = $id;
  201. $data1['program_circular_id'] = $sessionAllData['program_circular_id'];
  202. $data1['program_study_center_id'] = $sessionAllData['program_study_center_id'];
  203. $data1['test_venue'] = $sessionAllData['test_venue'];
  204. $data1['program_group_id'] = $sessionAllData['program_group_id'];
  205. $data1['application_date'] = strtotime(date("m/d/Y H:i:s", time()));
  206. $data1['student_id'] = $id;
  207. $data1['password'] = md5($password);
  208. $data1['student_activity_status'] = 1;
  209.  
  210. $this->db->insert('program_student_information', $data1);
  211. $id2 = mysqli_insert_id();
  212. //email_for_temporary_id
  213. //sms_for_temporary_id
  214. $email = $sessionAllData['email'];
  215. $mobile_no = $sessionAllData['mobile_number'];
  216.  
  217. $this->communication_model->email_for_temporary_id($email, $id2, $password);
  218. $this->communication_model->sms_for_temporary_id($mobile_no, $id2, $password);
  219.  
  220. $data2['user_id'] = $id2;
  221. $data2['user_type'] = 'student';
  222. $data2['ip'] = $this->common_model->get_ip();
  223. $data2['login_time'] = strtotime(date("m/d/Y H:i:s", time()));
  224. $this->db->insert('security_user_session', $data2);
  225. $session_id = mysqli_insert_id();
  226.  
  227. $this->session->set_userdata('student', '1');
  228. $this->session->set_userdata('security_user_session_id', $session_id);
  229. $this->session->set_userdata('program_student_information_id', $id2);
  230.  
  231.  
  232. $circularData = $this->common_model->get_fixed_data('program_id,degree_group_id,academic_year', 'program_circular_id', $sessionAllData['program_circular_id'], 'program_circular');
  233.  
  234. $rc_src = $this->db->select('program_src.program_src_id,program_rrc.program_rrc_id')->from('program_study_center')->join('program_src', 'program_study_center.program_src_id=program_src.program_src_id')->join('program_rrc', 'program_src.program_rrc_id=program_rrc.program_rrc_id')->where('program_study_center_id', $sessionAllData['program_study_center_id'])->get()->row();
  235.  
  236. //$school = $this->db->select('school.school_id')->from('program')->join('school','program.school_id=school.school_id')->get()->row();
  237. $school = $this->db->select('school.school_id')->from('program')->join('school', 'program.school_id=school.school_id')->where('program.program_id', $circularData[0]->program_id)->get()->row();
  238.  
  239. $payment_record_data['student_id'] = $id2;
  240. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  241. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  242. $payment_record_data['program_study_center_id'] = $sessionAllData['program_study_center_id'];
  243. $payment_record_data['service_id'] = 16;
  244. $payment_record_data['school_id'] = $school->school_id;
  245. $payment_record_data['academic_year'] = $circularData[0]->academic_year;
  246. $payment_record_data['program_id'] = $circularData[0]->program_id;
  247. $payment_record_data['program_group_id'] = $circularData[0]->degree_group_id;
  248. $payment_record_data['program_circular_id'] = $sessionAllData['program_circular_id'];
  249. $payment_record_data['invoice_id'] = $invoiceNum;
  250. // $payment_record_data['paid_amount'] = $sessionAllData['amount_with_tax'];
  251. $payment_record_data['paid_amount'] = $sessionAllData['amount'];
  252. $payment_record_data['transaction_id'] = $sessionAllData['transation_id'];
  253. $payment_record_data['payment_method'] = $sessionAllData['payment_method'];
  254. $payment_record_data['create_date'] = date('Y/m/d');
  255.  
  256. $insertId = $this->common_model->save('payment_record', $payment_record_data);
  257.  
  258. if ($insertId <> 0) {
  259. //$this->session->unset_userdata('registrationData' . $invoiceNum);
  260. // $this->session->unset_userdata('academic_history'.$invoiceNum);
  261. redirect(base_url() . 'student/student_private', 'refresh');
  262. }
  263. //redirect(base_url() . 'student/student_private/course_fee' , 'refresh');
  264. } else {
  265. echo 'sorry something is wrong please try again ';
  266. }
  267. } elseif (count($data['reExamInvoiceId' . $invoiceNum]) > 1) {
  268. // echo '<pre>';
  269. // print_r($this->session->userdata('reExamInvoiceId'.$invoice));
  270. // echo '</pre>';
  271. $sessionData = $data['reExamInvoiceId' . $invoiceNum];
  272.  
  273. /*$data['student_id'] = $sessionData['student_id'];
  274. $data['service_id'] = '3';
  275. $data['program_id'] = $sessionData['program_id'];
  276. $data['program_group_id'] = $sessionData['group_id'];
  277. $data['program_circular_id'] = $sessionData['circular_id'];
  278. $data['invoice_id'] = $invoiceNum;
  279. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  280. $data['paid_amount'] = $sessionData['amount'];
  281. $data['transaction_id'] = $sessionData['transation_id'];
  282. $data['payment_method'] = $sessionData['payment_method'];
  283. $data['create_date'] = date('Y/m/d');*/
  284.  
  285.  
  286. $circularData = $this->db->select('program_circular.academic_year,program_student_information.program_study_center_id')->from('program_student_information')->join('program_circular', 'program_student_information.program_circular_id=program_circular.program_circular_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  287.  
  288. $rc_src = $this->db->select('program_src.program_src_id,program_rrc.program_rrc_id')->from('program_study_center')->join('program_src', 'program_study_center.program_src_id=program_src.program_src_id')->join('program_rrc', 'program_src.program_rrc_id=program_rrc.program_rrc_id')->where('program_study_center_id', $circularData->program_study_center_id)->get()->row();
  289.  
  290. $school = $this->db->select('school.school_id')->from('program')->join('school', 'program.school_id=school.school_id')->where('program.program_id', $sessionData['program_id'])->get()->row();
  291.  
  292. $payment_record_data['student_id'] = $sessionData['student_id'];
  293. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  294. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  295. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  296. $payment_record_data['service_id'] = 3;
  297. $payment_record_data['school_id'] = $school->school_id;
  298. $payment_record_data['academic_year'] = $circularData->academic_year;
  299. $payment_record_data['program_id'] = $sessionData['program_id'];
  300. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  301. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  302. $payment_record_data['invoice_id'] = $invoiceNum;
  303. $payment_record_data['paid_amount'] = $sessionData['amount'];
  304. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  305. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  306. $payment_record_data['create_date'] = date('Y/m/d');
  307.  
  308.  
  309. $insertId = $this->common_model->save('payment_record', $data);
  310. if ($insertId <> 0) {
  311. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  312. $dataStudentCourse['service_id'] = 3;
  313. $dataStudentCourse['create_date'] = date('Y/m/d');
  314. $dataStudentCourse['approval_status'] = 0;
  315. $dataStudentCourse['payment_record_id'] = $insertId;
  316.  
  317. $additional_information = array('courses' => $sessionData['checkedCourses']);
  318.  
  319. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  320.  
  321. $this->common_model->save('service_application_form', $dataStudentCourse);
  322.  
  323.  
  324. //For Email and sms
  325. $email_id = $this->db->select('user_student.email,user_student.mobile_number')->from('user_student')->join('program_student_information', 'program_student_information.user_student_id=user_student.user_student_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  326. $this->email($email_id->email, 'You have successfully requested for Re-exam Service at Bangladesh Open University');
  327. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Re-exam Service at Bangladesh Open University");
  328.  
  329.  
  330. $successData['amount'] = $sessionData['amount_with_tax'];
  331. $successData['service_name'] = $sessionData['service_name'];
  332.  
  333. $this->load->view('success_payment', $successData);
  334. }
  335. } elseif (count($data['testimonialInvoiceId' . $invoiceNum]) > 1) {
  336. $sessionData = $data['testimonialInvoiceId' . $invoiceNum];
  337.  
  338. /*$data['student_id'] = $sessionData['student_id'];
  339. $data['service_id'] = 4;
  340. $data['program_id'] = $sessionData['program_id'];
  341. $data['program_group_id'] = $sessionData['group_id'];
  342. $data['program_circular_id'] = $sessionData['circular_id'];
  343. $data['invoice_id'] = $invoiceNum;
  344. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  345. $data['paid_amount'] = $sessionData['amount'];
  346. $data['transaction_id'] = $sessionData['transation_id'];
  347. $data['payment_method'] = $sessionData['payment_method'];
  348. $data['create_date'] = date('Y/m/d');*/
  349.  
  350.  
  351. $circularData = $this->db->select('program_circular.academic_year,program_student_information.program_study_center_id')->from('program_student_information')->join('program_circular', 'program_student_information.program_circular_id=program_circular.program_circular_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  352.  
  353. $rc_src = $this->db->select('program_src.program_src_id,program_rrc.program_rrc_id')->from('program_study_center')->join('program_src', 'program_study_center.program_src_id=program_src.program_src_id')->join('program_rrc', 'program_src.program_rrc_id=program_rrc.program_rrc_id')->where('program_study_center_id', $circularData->program_study_center_id)->get()->row();
  354.  
  355. $school = $this->db->select('school.school_id')->from('program')->join('school', 'program.school_id=school.school_id')->where('program.program_id', $sessionData['program_id'])->get()->row();
  356.  
  357. $payment_record_data['student_id'] = $sessionData['student_id'];
  358. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  359. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  360. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  361. $payment_record_data['service_id'] = 4;
  362. $payment_record_data['school_id'] = $school->school_id;
  363. $payment_record_data['academic_year'] = $circularData->academic_year;
  364. $payment_record_data['program_id'] = $sessionData['program_id'];
  365. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  366. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  367. $payment_record_data['invoice_id'] = $invoiceNum;
  368. $payment_record_data['paid_amount'] = $sessionData['amount'];
  369. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  370. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  371. $payment_record_data['create_date'] = date('Y/m/d');
  372.  
  373.  
  374. $insertId = $this->common_model->save('payment_record', $payment_record_data);
  375. if ($insertId <> 0) {
  376. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  377. $dataStudentCourse['service_id'] = 4;
  378. $dataStudentCourse['create_date'] = date('Y/m/d');
  379. $dataStudentCourse['approval_status'] = 0;
  380. $dataStudentCourse['payment_record_id'] = $insertId;
  381.  
  382. $additional_information = array('gpa' => $sessionData['gpa'], 'year_of_passed' => $sessionData['year_of_passed']);
  383.  
  384. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  385.  
  386. /*echo '<pre>';
  387. print_r($dataStudentCourse);
  388. echo '</pre>';
  389. exit;*/
  390.  
  391. $this->common_model->save('service_application_form', $dataStudentCourse);
  392.  
  393. //For Email and sms
  394. $email_id = $this->db->select('user_student.email,user_student.mobile_number')->from('user_student')->join('program_student_information', 'program_student_information.user_student_id=user_student.user_student_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  395. $this->email($email_id->email, 'You have successfully requested for Testimonial Service at Bangladesh Open University');
  396.  
  397. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Testimonial Service at Bangladesh Open University");
  398.  
  399.  
  400. $successData['amount'] = $sessionData['amount_with_tax'];
  401. $successData['service_name'] = $sessionData['service_name'];
  402.  
  403. $this->load->view('success_payment', $successData);
  404. }
  405. } elseif (count($data['provisional_certificateInvoiceId' . $invoiceNum]) > 1) {
  406. $sessionData = $data['provisional_certificateInvoiceId' . $invoiceNum];
  407.  
  408. /*$data['student_id'] = $sessionData['student_id'];
  409. $data['service_id'] = 6;
  410. $data['program_id'] = $sessionData['program_id'];
  411. $data['program_group_id'] = $sessionData['group_id'];
  412. $data['program_circular_id'] = $sessionData['circular_id'];
  413. $data['invoice_id'] = $invoiceNum;
  414. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  415. $data['paid_amount'] = $sessionData['amount'];
  416. $data['transaction_id'] = $sessionData['transation_id'];
  417. $data['payment_method'] = $sessionData['payment_method'];
  418. $data['create_date'] = date('Y/m/d');*/
  419.  
  420.  
  421. $circularData = $this->db->select('program_circular.academic_year,program_student_information.program_study_center_id')->from('program_student_information')->join('program_circular', 'program_student_information.program_circular_id=program_circular.program_circular_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  422.  
  423. $rc_src = $this->db->select('program_src.program_src_id,program_rrc.program_rrc_id')->from('program_study_center')->join('program_src', 'program_study_center.program_src_id=program_src.program_src_id')->join('program_rrc', 'program_src.program_rrc_id=program_rrc.program_rrc_id')->where('program_study_center_id', $circularData->program_study_center_id)->get()->row();
  424.  
  425. $school = $this->db->select('school.school_id')->from('program')->join('school', 'program.school_id=school.school_id')->where('program.program_id', $sessionData['program_id'])->get()->row();
  426.  
  427. $payment_record_data['student_id'] = $sessionData['student_id'];
  428. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  429. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  430. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  431. $payment_record_data['service_id'] = 6;
  432. $payment_record_data['school_id'] = $school->school_id;
  433. $payment_record_data['academic_year'] = $circularData->academic_year;
  434. $payment_record_data['program_id'] = $sessionData['program_id'];
  435. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  436. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  437. $payment_record_data['invoice_id'] = $invoiceNum;
  438. $payment_record_data['paid_amount'] = $sessionData['amount'];
  439. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  440. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  441. $payment_record_data['create_date'] = date('Y/m/d');
  442.  
  443.  
  444. $insertId = $this->common_model->save('payment_record', $data);
  445. if ($insertId <> 0) {
  446. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  447. $dataStudentCourse['service_id'] = 6;
  448. $dataStudentCourse['create_date'] = date('Y/m/d');
  449. $dataStudentCourse['approval_status'] = 0;
  450. $dataStudentCourse['payment_record_id'] = $insertId;
  451.  
  452. $additional_information = array('year_of_passed' => $sessionData['year_of_passed'], 'exam_name' => $sessionData['exam_name'], 'result' => $sessionData['result']);
  453.  
  454. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  455.  
  456. $this->common_model->save('service_application_form', $dataStudentCourse);
  457.  
  458. //For Email and sms
  459. $email_id = $this->db->select('user_student.email,user_student.mobile_number')->from('user_student')->join('program_student_information', 'program_student_information.user_student_id=user_student.user_student_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  460. $this->email($email_id->email, 'You have successfully requested for Provisional Certificate Service at Bangladesh Open University');
  461.  
  462. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Provisional Certificate Service at Bangladesh Open University");
  463.  
  464.  
  465. $successData['amount'] = $sessionData['amount_with_tax'];
  466. $successData['service_name'] = $sessionData['service_name'];
  467.  
  468. $this->load->view('success_payment', $successData);
  469. }
  470. } elseif (count($data['convocationInvoiceId' . $invoiceNum]) > 1) {
  471. $sessionData = $data['convocationInvoiceId' . $invoiceNum];
  472. $sessionFileData = $data['convocationFileInvoiceId' . $invoiceNum];
  473.  
  474. /*$data['student_id'] = $sessionData['student_id'];
  475. $data['service_id'] = 11;
  476. $data['program_id'] = $sessionData['program_id'];
  477. $data['program_group_id'] = $sessionData['group_id'];
  478. $data['program_circular_id'] = $sessionData['circular_id'];
  479. $data['invoice_id'] = $invoiceNum;
  480. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  481. $data['paid_amount'] = $sessionData['amount'];
  482. $data['transaction_id'] = $sessionData['transation_id'];
  483. $data['payment_method'] = $sessionData['payment_method'];
  484. $data['create_date'] = date('Y/m/d');*/
  485.  
  486.  
  487. $circularData = $this->db->select('program_circular.academic_year,program_student_information.program_study_center_id')->from('program_student_information')->join('program_circular', 'program_student_information.program_circular_id=program_circular.program_circular_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  488.  
  489. $rc_src = $this->db->select('program_src.program_src_id,program_rrc.program_rrc_id')->from('program_study_center')->join('program_src', 'program_study_center.program_src_id=program_src.program_src_id')->join('program_rrc', 'program_src.program_rrc_id=program_rrc.program_rrc_id')->where('program_study_center_id', $circularData->program_study_center_id)->get()->row();
  490.  
  491. $school = $this->db->select('school.school_id')->from('program')->join('school', 'program.school_id=school.school_id')->where('program.program_id', $sessionData['program_id'])->get()->row();
  492.  
  493. $payment_record_data['student_id'] = $sessionData['student_id'];
  494. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  495. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  496. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  497. $payment_record_data['service_id'] = 11;
  498. $payment_record_data['school_id'] = $school->school_id;
  499. $payment_record_data['academic_year'] = $circularData->academic_year;
  500. $payment_record_data['program_id'] = $sessionData['program_id'];
  501. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  502. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  503. $payment_record_data['invoice_id'] = $invoiceNum;
  504. $payment_record_data['paid_amount'] = $sessionData['amount'];
  505. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  506. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  507. $payment_record_data['create_date'] = date('Y/m/d');
  508.  
  509.  
  510. $insertId = $this->common_model->save('payment_record', $data);
  511. if ($insertId <> 0) {
  512. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  513. $dataStudentCourse['service_id'] = 11;
  514. $dataStudentCourse['create_date'] = date('Y/m/d');
  515. $dataStudentCourse['approval_status'] = 0;
  516. $dataStudentCourse['payment_record_id'] = $insertId;
  517.  
  518. $additional_information = array('degree_name' => $sessionData['degree_name'], 'year_of_passed' => $sessionData['year_of_passed'], 'division_gpa' => $sessionData['division_gpa'], 'image' => $sessionFileData[0], 'id_card' => $sessionFileData[1], 'provisional_certificate' => $sessionFileData[2]);
  519.  
  520. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  521.  
  522. $this->common_model->save('service_application_form', $dataStudentCourse);
  523.  
  524. //For Email and sms
  525. $email_id = $this->db->select('user_student.email,user_student.mobile_number')->from('user_student')->join('program_student_information', 'program_student_information.user_student_id=user_student.user_student_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  526. $this->email($email_id->email, 'You have successfully requested for Convocation Service at Bangladesh Open University');
  527.  
  528. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Convocation Service at Bangladesh Open University");
  529.  
  530. $successData['amount'] = $sessionData['amount_with_tax'];
  531. $successData['service_name'] = $sessionData['service_name'];
  532. $this->load->view('success_payment', $successData);
  533. }
  534. } elseif (count($data['name_correctionInvoiceId' . $invoiceNum]) > 1) {
  535. $sessionData = $data['name_correctionInvoiceId' . $invoiceNum];
  536. $sessionFileData = $data['name_correctionFileInvoiceId' . $invoiceNum];
  537.  
  538. /*$data['student_id'] = $sessionData['student_id'];
  539. $data['service_id'] = 12;
  540. $data['program_id'] = $sessionData['program_id'];
  541. $data['program_group_id'] = $sessionData['group_id'];
  542. $data['program_circular_id'] = $sessionData['circular_id'];
  543. $data['invoice_id'] = $invoiceNum;
  544. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  545. $data['paid_amount'] = $sessionData['amount'];
  546. $data['transaction_id'] = $sessionData['transation_id'];
  547. $data['payment_method'] = $sessionData['payment_method'];
  548. $data['create_date'] = date('Y/m/d');*/
  549.  
  550.  
  551. $circularData = $this->db->select('program_circular.academic_year,program_student_information.program_study_center_id')->from('program_student_information')->join('program_circular', 'program_student_information.program_circular_id=program_circular.program_circular_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  552.  
  553. $rc_src = $this->db->select('program_src.program_src_id,program_rrc.program_rrc_id')->from('program_study_center')->join('program_src', 'program_study_center.program_src_id=program_src.program_src_id')->join('program_rrc', 'program_src.program_rrc_id=program_rrc.program_rrc_id')->where('program_study_center_id', $circularData->program_study_center_id)->get()->row();
  554.  
  555. $school = $this->db->select('school.school_id')->from('program')->join('school', 'program.school_id=school.school_id')->where('program.program_id', $sessionData['program_id'])->get()->row();
  556.  
  557. $payment_record_data['student_id'] = $sessionData['student_id'];
  558. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  559. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  560. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  561. $payment_record_data['service_id'] = 12;
  562. $payment_record_data['school_id'] = $school->school_id;
  563. $payment_record_data['academic_year'] = $circularData->academic_year;
  564. $payment_record_data['program_id'] = $sessionData['program_id'];
  565. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  566. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  567. $payment_record_data['invoice_id'] = $invoiceNum;
  568. $payment_record_data['paid_amount'] = $sessionData['amount'];
  569. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  570. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  571. $payment_record_data['create_date'] = date('Y/m/d');
  572.  
  573.  
  574. $insertId = $this->common_model->save('payment_record', $data);
  575. if ($insertId <> 0) {
  576. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  577. $dataStudentCourse['service_id'] = 12;
  578. $dataStudentCourse['create_date'] = date('Y/m/d');
  579. $dataStudentCourse['approval_status'] = 0;
  580. $dataStudentCourse['payment_record_id'] = $insertId;
  581.  
  582. $additional_information = array('year_of_passing' => $sessionData['year_of_passing'], 'exam_passed' => $sessionData['exam_passed'], 'result' => $sessionData['result'], 'correction' => $sessionData['correction'], 'student_name' => $sessionData['student_name'], 'father_name' => $sessionData['father_name'], 'mother_name' => $sessionData['mother_name'], 'date_of_birth' => $sessionData['date_of_birth'], 'birth_reg' => $sessionFileData[0], 'jsc_cer' => $sessionFileData[1], 'ssc_cer' => $sessionFileData[2]);
  583.  
  584. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  585.  
  586. $this->common_model->save('service_application_form', $dataStudentCourse);
  587.  
  588. //For Email and sms
  589. $email_id = $this->db->select('user_student.email,user_student.mobile_number')->from('user_student')->join('program_student_information', 'program_student_information.user_student_id=user_student.user_student_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  590. $this->email($email_id->email, 'You have successfully requested for Name Correction Service at Bangladesh Open University');
  591.  
  592. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Name Correction Service at Bangladesh Open University");
  593.  
  594.  
  595. $successData['amount'] = $sessionData['amount_with_tax'];
  596. $successData['service_name'] = $sessionData['service_name'];
  597. $this->load->view('success_payment', $successData);
  598. }
  599. } elseif (count($data['migrationInvoiceId' . $invoiceNum]) > 1) {
  600. $sessionData = $data['migrationInvoiceId' . $invoiceNum];
  601.  
  602. /*$data['student_id'] = $sessionData['student_id'];
  603. $data['service_id'] = 14;
  604. $data['program_id'] = $sessionData['program_id'];
  605. $data['program_group_id'] = $sessionData['group_id'];
  606. $data['program_circular_id'] = $sessionData['circular_id'];
  607. $data['invoice_id'] = $invoiceNum;
  608. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  609. $data['paid_amount'] = $sessionData['amount'];
  610. $data['transaction_id'] = $sessionData['transation_id'];
  611. $data['payment_method'] = $sessionData['payment_method'];
  612. $data['create_date'] = date('Y/m/d');*/
  613.  
  614.  
  615. $circularData = $this->db->select('program_circular.academic_year,program_student_information.program_study_center_id')->from('program_student_information')->join('program_circular', 'program_student_information.program_circular_id=program_circular.program_circular_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  616.  
  617. $rc_src = $this->db->select('program_src.program_src_id,program_rrc.program_rrc_id')->from('program_study_center')->join('program_src', 'program_study_center.program_src_id=program_src.program_src_id')->join('program_rrc', 'program_src.program_rrc_id=program_rrc.program_rrc_id')->where('program_study_center_id', $circularData->program_study_center_id)->get()->row();
  618.  
  619. $school = $this->db->select('school.school_id')->from('program')->join('school', 'program.school_id=school.school_id')->where('program.program_id', $sessionData['program_id'])->get()->row();
  620.  
  621. $payment_record_data['student_id'] = $sessionData['student_id'];
  622. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  623. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  624. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  625. $payment_record_data['service_id'] = 14;
  626. $payment_record_data['school_id'] = $school->school_id;
  627. $payment_record_data['academic_year'] = $circularData->academic_year;
  628. $payment_record_data['program_id'] = $sessionData['program_id'];
  629. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  630. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  631. $payment_record_data['invoice_id'] = $invoiceNum;
  632. $payment_record_data['paid_amount'] = $sessionData['amount'];
  633. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  634. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  635. $payment_record_data['create_date'] = date('Y/m/d');
  636.  
  637.  
  638. $insertId = $this->common_model->save('payment_record', $data);
  639. if ($insertId <> 0) {
  640. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  641. $dataStudentCourse['service_id'] = 14;
  642. $dataStudentCourse['create_date'] = date('Y/m/d');
  643. $dataStudentCourse['approval_status'] = 0;
  644. $dataStudentCourse['payment_record_id'] = $insertId;
  645.  
  646. $additional_information = array('exam_you_have_passed' => $sessionData['exam_you_have_passed'], 'which_date' => $sessionData['which_date'], 'reason_of_leave' => $sessionData['reason_of_leave']);
  647.  
  648. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  649.  
  650. $this->common_model->save('service_application_form', $dataStudentCourse);
  651.  
  652. //For Email and sms
  653. $email_id = $this->db->select('user_student.email,user_student.mobile_number')->from('user_student')->join('program_student_information', 'program_student_information.user_student_id=user_student.user_student_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  654. $this->email($email_id->email, 'You have successfully requested for Migration Service at Bangladesh Open University');
  655.  
  656. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Migration Service at Bangladesh Open University");
  657.  
  658.  
  659. $successData['amount'] = $sessionData['amount_with_tax'];
  660. $successData['service_name'] = $sessionData['service_name'];
  661. $this->load->view('success_payment', $successData);
  662. }
  663. } elseif (count($data['study_centerInvoiceId' . $invoiceNum]) > 1) {
  664. $sessionData = $data['study_centerInvoiceId' . $invoiceNum];
  665.  
  666. /*$data['student_id'] = $sessionData['student_id'];
  667. $data['service_id'] = 13;
  668. $data['program_id'] = $sessionData['program_id'];
  669. $data['program_group_id'] = $sessionData['group_id'];
  670. $data['program_circular_id'] = $sessionData['circular_id'];
  671. $data['invoice_id'] = $invoiceNum;
  672. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  673. $data['paid_amount'] = $sessionData['amount'];
  674. $data['transaction_id'] = $sessionData['transation_id'];
  675. $data['payment_method'] = $sessionData['payment_method'];
  676. $data['create_date'] = date('Y/m/d');*/
  677.  
  678.  
  679. $circularData = $this->db->select('program_circular.academic_year,program_student_information.program_study_center_id')->from('program_student_information')->join('program_circular', 'program_student_information.program_circular_id=program_circular.program_circular_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  680.  
  681. $rc_src = $this->db->select('program_src.program_src_id,program_rrc.program_rrc_id')->from('program_study_center')->join('program_src', 'program_study_center.program_src_id=program_src.program_src_id')->join('program_rrc', 'program_src.program_rrc_id=program_rrc.program_rrc_id')->where('program_study_center_id', $circularData->program_study_center_id)->get()->row();
  682.  
  683. $school = $this->db->select('school.school_id')->from('program')->join('school', 'program.school_id=school.school_id')->where('program.program_id', $sessionData['program_id'])->get()->row();
  684.  
  685. $payment_record_data['student_id'] = $sessionData['student_id'];
  686. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  687. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  688. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  689. $payment_record_data['service_id'] = 13;
  690. $payment_record_data['school_id'] = $school->school_id;
  691. $payment_record_data['academic_year'] = $circularData->academic_year;
  692. $payment_record_data['program_id'] = $sessionData['program_id'];
  693. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  694. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  695. $payment_record_data['invoice_id'] = $invoiceNum;
  696. $payment_record_data['paid_amount'] = $sessionData['amount'];
  697. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  698. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  699. $payment_record_data['create_date'] = date('Y/m/d');
  700.  
  701.  
  702. $insertId = $this->common_model->save('payment_record', $data);
  703. if ($insertId <> 0) {
  704. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  705. $dataStudentCourse['service_id'] = 13;
  706. $dataStudentCourse['create_date'] = date('Y/m/d');
  707. $dataStudentCourse['approval_status'] = 0;
  708. $dataStudentCourse['payment_record_id'] = $insertId;
  709.  
  710. $additional_information = array('exam_name' => $sessionData['exam_name'], 'study_center' => $sessionData['study_center'], 'reason_of_transfer' => $sessionData['reason_of_transfer']);
  711.  
  712. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  713.  
  714. $this->common_model->save('service_application_form', $dataStudentCourse);
  715.  
  716. //For Email and sms
  717. $email_id = $this->db->select('user_student.email,user_student.mobile_number')->from('user_student')->join('program_student_information', 'program_student_information.user_student_id=user_student.user_student_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  718. $this->email($email_id->email, 'You have successfully requested for Study Center Transfer Service at Bangladesh Open University');
  719.  
  720. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Study Center Transfer Service at Bangladesh Open University");
  721.  
  722.  
  723. $successData['amount'] = $sessionData['amount_with_tax'];
  724. $successData['service_name'] = $sessionData['service_name'];
  725. $this->load->view('success_payment', $successData);
  726. }
  727. } elseif (count($data['ans_script_reevaluation_applyInvoiceId' . $invoiceNum]) > 1) {
  728. $sessionData = $data['ans_script_reevaluation_applyInvoiceId' . $invoiceNum];
  729.  
  730. /*$data['student_id'] = $sessionData['student_id'];
  731. $data['service_id'] = 5;
  732. $data['program_id'] = $sessionData['program_id'];
  733. $data['program_group_id'] = $sessionData['group_id'];
  734. $data['program_circular_id'] = $sessionData['circular_id'];
  735. $data['invoice_id'] = $invoiceNum;
  736. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  737. $data['paid_amount'] = $sessionData['amount'];
  738. $data['transaction_id'] = $sessionData['transation_id'];
  739. $data['payment_method'] = $sessionData['payment_method'];
  740. $data['create_date'] = date('Y/m/d');*/
  741.  
  742.  
  743. $circularData = $this->db->select('program_circular.academic_year,program_student_information.program_study_center_id')->from('program_student_information')->join('program_circular', 'program_student_information.program_circular_id=program_circular.program_circular_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  744.  
  745. $rc_src = $this->db->select('program_src.program_src_id,program_rrc.program_rrc_id')->from('program_study_center')->join('program_src', 'program_study_center.program_src_id=program_src.program_src_id')->join('program_rrc', 'program_src.program_rrc_id=program_rrc.program_rrc_id')->where('program_study_center_id', $circularData->program_study_center_id)->get()->row();
  746.  
  747. $school = $this->db->select('school.school_id')->from('program')->join('school', 'program.school_id=school.school_id')->where('program.program_id', $sessionData['program_id'])->get()->row();
  748.  
  749. $payment_record_data['student_id'] = $sessionData['student_id'];
  750. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  751. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  752. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  753. $payment_record_data['service_id'] = 5;
  754. $payment_record_data['school_id'] = $school->school_id;
  755. $payment_record_data['academic_year'] = $circularData->academic_year;
  756. $payment_record_data['program_id'] = $sessionData['program_id'];
  757. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  758. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  759. $payment_record_data['invoice_id'] = $invoiceNum;
  760. $payment_record_data['paid_amount'] = $sessionData['amount'];
  761. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  762. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  763. $payment_record_data['create_date'] = date('Y/m/d');
  764.  
  765.  
  766. $insertId = $this->common_model->save('payment_record', $data);
  767. if ($insertId <> 0) {
  768. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  769. $dataStudentCourse['service_id'] = 5;
  770. $dataStudentCourse['create_date'] = date('Y/m/d');
  771. $dataStudentCourse['approval_status'] = 0;
  772. $dataStudentCourse['payment_record_id'] = $insertId;
  773.  
  774. /*Cause*/
  775. $cause = array_filter($sessionData['cause']);
  776. $causeArr = array();
  777. for ($i = 0; $i < count($cause); $i++) {
  778. $causeArr[] = $cause[$i];
  779. }
  780. /*Cause*/
  781.  
  782. $additional_information = array('exam_hall' => $sessionData['exam_hall'], 'semister' => $sessionData['semister'], 'exam_year' => $sessionData['exam_year'], 'courses' => $sessionData['checkedCourses'], 'cause' => $causeArr);
  783.  
  784. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  785.  
  786. $this->common_model->save('service_application_form', $dataStudentCourse);
  787.  
  788. //For Email and sms
  789. $email_id = $this->db->select('user_student.email,user_student.mobile_number')->from('user_student')->join('program_student_information', 'program_student_information.user_student_id=user_student.user_student_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  790. $this->email($email_id->email, 'You have successfully requested for Answer Script Re-evaluation Service at Bangladesh Open University');
  791.  
  792. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Answer Script Re-evaluation Service at Bangladesh Open University");
  793.  
  794.  
  795. $successData['amount'] = $sessionData['amount_with_tax'];
  796. $successData['service_name'] = $sessionData['service_name'];
  797. $this->load->view('success_payment', $successData);
  798. }
  799. } elseif (count($data['main_certificateInvoiceId' . $invoiceNum]) > 1) {
  800. $sessionData = $data['main_certificateInvoiceId' . $invoiceNum];
  801.  
  802. /*$data['student_id'] = $sessionData['student_id'];
  803. $data['service_id'] = 7;
  804. $data['program_id'] = $sessionData['program_id'];
  805. $data['program_group_id'] = $sessionData['group_id'];
  806. $data['program_circular_id'] = $sessionData['circular_id'];
  807. $data['invoice_id'] = $invoiceNum;
  808. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  809. $data['paid_amount'] = $sessionData['amount'];
  810. $data['transaction_id'] = $sessionData['transation_id'];
  811. $data['payment_method'] = $sessionData['payment_method'];
  812. $data['create_date'] = date('Y/m/d');*/
  813.  
  814.  
  815. $circularData = $this->db->select('program_circular.academic_year,program_student_information.program_study_center_id')->from('program_student_information')->join('program_circular', 'program_student_information.program_circular_id=program_circular.program_circular_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  816.  
  817. $rc_src = $this->db->select('program_src.program_src_id,program_rrc.program_rrc_id')->from('program_study_center')->join('program_src', 'program_study_center.program_src_id=program_src.program_src_id')->join('program_rrc', 'program_src.program_rrc_id=program_rrc.program_rrc_id')->where('program_study_center_id', $circularData->program_study_center_id)->get()->row();
  818.  
  819. $school = $this->db->select('school.school_id')->from('program')->join('school', 'program.school_id=school.school_id')->where('program.program_id', $sessionData['program_id'])->get()->row();
  820.  
  821. $payment_record_data['student_id'] = $sessionData['student_id'];
  822. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  823. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  824. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  825. $payment_record_data['service_id'] = 7;
  826. $payment_record_data['school_id'] = $school->school_id;
  827. $payment_record_data['academic_year'] = $circularData->academic_year;
  828. $payment_record_data['program_id'] = $sessionData['program_id'];
  829. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  830. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  831. $payment_record_data['invoice_id'] = $invoiceNum;
  832. $payment_record_data['paid_amount'] = $sessionData['amount'];
  833. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  834. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  835. $payment_record_data['create_date'] = date('Y/m/d');
  836.  
  837.  
  838. $insertId = $this->common_model->save('payment_record', $data);
  839. if ($insertId <> 0) {
  840. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  841. $dataStudentCourse['service_id'] = 7;
  842. $dataStudentCourse['create_date'] = date('Y/m/d');
  843. $dataStudentCourse['approval_status'] = 0;
  844. $dataStudentCourse['payment_record_id'] = $insertId;
  845.  
  846. $additional_information = array('year_of_passed' => $sessionData['year_of_passed'], 'exam_name' => $sessionData['exam_name'], 'result' => $sessionData['result']);
  847.  
  848. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  849.  
  850. $this->common_model->save('service_application_form', $dataStudentCourse);
  851.  
  852. //For Email and sms
  853. $email_id = $this->db->select('user_student.email,user_student.mobile_number')->from('user_student')->join('program_student_information', 'program_student_information.user_student_id=user_student.user_student_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  854. $this->email($email_id->email, 'You have successfully requested for Main Certificate Service at Bangladesh Open University');
  855.  
  856. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Main Certificate Service at Bangladesh Open University");
  857.  
  858.  
  859. $successData['amount'] = $sessionData['amount_with_tax'];
  860. $successData['service_name'] = $sessionData['service_name'];
  861. $this->load->view('success_payment', $successData);
  862. }
  863. } elseif (count($data['certificate_verificationInvoiceId' . $invoiceNum]) > 1) {
  864. $sessionData = $data['certificate_verificationInvoiceId' . $invoiceNum];
  865.  
  866. /*$data['student_id'] = $sessionData['student_id'];
  867. $data['service_id'] = 9;
  868. $data['program_id'] = $sessionData['program_id'];
  869. $data['program_group_id'] = $sessionData['group_id'];
  870. $data['program_circular_id'] = $sessionData['circular_id'];
  871. $data['invoice_id'] = $invoiceNum;
  872. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  873. $data['paid_amount'] = $sessionData['amount'];
  874. $data['transaction_id'] = $sessionData['transation_id'];
  875. $data['payment_method'] = $sessionData['payment_method'];
  876. $data['create_date'] = date('Y/m/d');*/
  877.  
  878.  
  879. $circularData = $this->db->select('program_circular.academic_year,program_student_information.program_study_center_id')->from('program_student_information')->join('program_circular', 'program_student_information.program_circular_id=program_circular.program_circular_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  880.  
  881. $rc_src = $this->db->select('program_src.program_src_id,program_rrc.program_rrc_id')->from('program_study_center')->join('program_src', 'program_study_center.program_src_id=program_src.program_src_id')->join('program_rrc', 'program_src.program_rrc_id=program_rrc.program_rrc_id')->where('program_study_center_id', $circularData->program_study_center_id)->get()->row();
  882.  
  883. $school = $this->db->select('school.school_id')->from('program')->join('school', 'program.school_id=school.school_id')->where('program.program_id', $sessionData['program_id'])->get()->row();
  884.  
  885. $payment_record_data['student_id'] = $sessionData['student_id'];
  886. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  887. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  888. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  889. $payment_record_data['service_id'] = 9;
  890. $payment_record_data['school_id'] = $school->school_id;
  891. $payment_record_data['academic_year'] = $circularData->academic_year;
  892. $payment_record_data['program_id'] = $sessionData['program_id'];
  893. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  894. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  895. $payment_record_data['invoice_id'] = $invoiceNum;
  896. $payment_record_data['paid_amount'] = $sessionData['amount'];
  897. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  898. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  899. $payment_record_data['create_date'] = date('Y/m/d');
  900.  
  901.  
  902. $insertId = $this->common_model->save('payment_record', $data);
  903. if ($insertId <> 0) {
  904. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  905. $dataStudentCourse['service_id'] = 9;
  906. $dataStudentCourse['create_date'] = date('Y/m/d');
  907. $dataStudentCourse['approval_status'] = 0;
  908. $dataStudentCourse['payment_record_id'] = $insertId;
  909.  
  910. $additional_information = array('year_of_passed' => $sessionData['year_of_passed'], 'exam_name' => $sessionData['exam_name'], 'result' => $sessionData['result']);
  911.  
  912. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  913.  
  914. $this->common_model->save('service_application_form', $dataStudentCourse);
  915.  
  916. //For Email and sms
  917. $email_id = $this->db->select('user_student.email,user_student.mobile_number')->from('user_student')->join('program_student_information', 'program_student_information.user_student_id=user_student.user_student_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  918. $this->email($email_id->email, 'You have successfully requested for Certificate Verification Service at Bangladesh Open University');
  919.  
  920. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Certificate Verification Service at Bangladesh Open University");
  921.  
  922.  
  923. $successData['amount'] = $sessionData['amount_with_tax'];
  924. $successData['service_name'] = $sessionData['service_name'];
  925. $this->load->view('success_payment', $successData);
  926. }
  927. } elseif (count($data['duplicate_provisional_applyInvoiceId' . $invoiceNum]) > 1) {
  928. $sessionData = $data['duplicate_provisional_applyInvoiceId' . $invoiceNum];
  929.  
  930. /*$data['student_id'] = $sessionData['student_id'];
  931. $data['service_id'] = 8;
  932. $data['program_id'] = $sessionData['program_id'];
  933. $data['program_group_id'] = $sessionData['group_id'];
  934. $data['program_circular_id'] = $sessionData['circular_id'];
  935. $data['invoice_id'] = $invoiceNum;
  936. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  937. $data['paid_amount'] = $sessionData['amount'];
  938. $data['transaction_id'] = $sessionData['transation_id'];
  939. $data['payment_method'] = $sessionData['payment_method'];
  940. $data['create_date'] = date('Y/m/d');*/
  941.  
  942.  
  943. $circularData = $this->db->select('program_circular.academic_year,program_student_information.program_study_center_id')->from('program_student_information')->join('program_circular', 'program_student_information.program_circular_id=program_circular.program_circular_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  944.  
  945. $rc_src = $this->db->select('program_src.program_src_id,program_rrc.program_rrc_id')->from('program_study_center')->join('program_src', 'program_study_center.program_src_id=program_src.program_src_id')->join('program_rrc', 'program_src.program_rrc_id=program_rrc.program_rrc_id')->where('program_study_center_id', $circularData->program_study_center_id)->get()->row();
  946.  
  947. $school = $this->db->select('school.school_id')->from('program')->join('school', 'program.school_id=school.school_id')->where('program.program_id', $sessionData['program_id'])->get()->row();
  948.  
  949. $payment_record_data['student_id'] = $sessionData['student_id'];
  950. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  951. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  952. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  953. $payment_record_data['service_id'] = 8;
  954. $payment_record_data['school_id'] = $school->school_id;
  955. $payment_record_data['academic_year'] = $circularData->academic_year;
  956. $payment_record_data['program_id'] = $sessionData['program_id'];
  957. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  958. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  959. $payment_record_data['invoice_id'] = $invoiceNum;
  960. $payment_record_data['paid_amount'] = $sessionData['amount'];
  961. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  962. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  963. $payment_record_data['create_date'] = date('Y/m/d');
  964.  
  965.  
  966. $insertId = $this->common_model->save('payment_record', $data);
  967. if ($insertId <> 0) {
  968. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  969. $dataStudentCourse['service_id'] = 8;
  970. $dataStudentCourse['create_date'] = date('Y/m/d');
  971. $dataStudentCourse['approval_status'] = 0;
  972. $dataStudentCourse['payment_record_id'] = $insertId;
  973.  
  974. $additional_information = array('year_of_passed' => $sessionData['year_of_passed'], 'exam_name' => $sessionData['exam_name'], 'result' => $sessionData['result']);
  975.  
  976. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  977.  
  978. $this->common_model->save('service_application_form', $dataStudentCourse);
  979.  
  980. //For Email and sms
  981. $email_id = $this->db->select('user_student.email,user_student.mobile_number')->from('user_student')->join('program_student_information', 'program_student_information.user_student_id=user_student.user_student_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  982. $this->email($email_id->email, 'You have successfully requested for Duplicate provisional Certificate Service at Bangladesh Open University');
  983.  
  984. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Duplicate provisional Certificate Service at Bangladesh Open University");
  985.  
  986. $successData['amount'] = $sessionData['amount_with_tax'];
  987. $successData['service_name'] = $sessionData['service_name'];
  988. $this->load->view('success_payment', $successData);
  989. }
  990. } elseif (count($data['duplicate_main_applyInvoiceId' . $invoiceNum]) > 1) {
  991. $sessionData = $data['duplicate_main_applyInvoiceId' . $invoiceNum];
  992.  
  993. /*$data['student_id'] = $sessionData['student_id'];
  994. $data['service_id'] = 10;
  995. $data['program_id'] = $sessionData['program_id'];
  996. $data['program_group_id'] = $sessionData['group_id'];
  997. $data['program_circular_id'] = $sessionData['circular_id'];
  998. $data['invoice_id'] = $invoiceNum;
  999. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  1000. $data['paid_amount'] = $sessionData['amount'];
  1001. $data['transaction_id'] = $sessionData['transation_id'];
  1002. $data['payment_method'] = $sessionData['payment_method'];
  1003. $data['create_date'] = date('Y/m/d');*/
  1004.  
  1005.  
  1006. $circularData = $this->db->select('program_circular.academic_year,program_student_information.program_study_center_id')->from('program_student_information')->join('program_circular', 'program_student_information.program_circular_id=program_circular.program_circular_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  1007.  
  1008. $rc_src = $this->db->select('program_src.program_src_id,program_rrc.program_rrc_id')->from('program_study_center')->join('program_src', 'program_study_center.program_src_id=program_src.program_src_id')->join('program_rrc', 'program_src.program_rrc_id=program_rrc.program_rrc_id')->where('program_study_center_id', $circularData->program_study_center_id)->get()->row();
  1009.  
  1010. $school = $this->db->select('school.school_id')->from('program')->join('school', 'program.school_id=school.school_id')->where('program.program_id', $sessionData['program_id'])->get()->row();
  1011.  
  1012. $payment_record_data['student_id'] = $sessionData['student_id'];
  1013. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  1014. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  1015. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  1016. $payment_record_data['service_id'] = 10;
  1017. $payment_record_data['school_id'] = $school->school_id;
  1018. $payment_record_data['academic_year'] = $circularData->academic_year;
  1019. $payment_record_data['program_id'] = $sessionData['program_id'];
  1020. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  1021. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  1022. $payment_record_data['invoice_id'] = $invoiceNum;
  1023. $payment_record_data['paid_amount'] = $sessionData['amount'];
  1024. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  1025. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  1026. $payment_record_data['create_date'] = date('Y/m/d');
  1027.  
  1028.  
  1029. $insertId = $this->common_model->save('payment_record', $data);
  1030. if ($insertId <> 0) {
  1031. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  1032. $dataStudentCourse['service_id'] = 10;
  1033. $dataStudentCourse['create_date'] = date('Y/m/d');
  1034. $dataStudentCourse['approval_status'] = 0;
  1035. $dataStudentCourse['payment_record_id'] = $insertId;
  1036.  
  1037. $additional_information = array('year_of_passed' => $sessionData['year_of_passed'], 'exam_name' => $sessionData['exam_name'], 'result' => $sessionData['result']);
  1038.  
  1039. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  1040.  
  1041. $this->common_model->save('service_application_form', $dataStudentCourse);
  1042.  
  1043. //For Email and sms
  1044. $email_id = $this->db->select('user_student.email,user_student.mobile_number')->from('user_student')->join('program_student_information', 'program_student_information.user_student_id=user_student.user_student_id')->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  1045. $this->email($email_id->email, 'You have successfully requested for Duplicate Main Certificate Service at Bangladesh Open University');
  1046.  
  1047. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Duplicate Main Certificate Service at Bangladesh Open University");
  1048.  
  1049. $successData['amount'] = $sessionData['amount_with_tax'];
  1050. $successData['service_name'] = $sessionData['service_name'];
  1051. $this->load->view('success_payment', $successData);
  1052. }
  1053. }
  1054. //redirect(base_url() . 'student/student_private/payment_success/' . $finalSessionInvoiceId, 'refresh');
  1055. }
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!