API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 14th, 2019
111
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 155.69 KB | None | 0 0
raw download clone embed print report
  1. public function payment_success($invoice)
  2. {
  3.  
  4. //var_dump($this->session->userdata($invoice));
  5. //var_dump($this->session->userdata('bkash_amount_single'));
  6.  
  7. //die('chffhccccc fc ');
  8. if($this->session->userdata('bkash_amount_single')) {
  9. $bkash_data = $this->session->userdata('bkash_amount_single');
  10. $count = count($bkash_data);
  11. $payment_record_ids = '';
  12. for ($y=0; $y<$count; $y++)
  13. {
  14. $sessionData = $this->session->userdata($invoice);
  15. $amount = $bkash_data[$y];
  16. $tnx_data = $sessionData['transation_id'];
  17. $tnx_data = explode(',', $tnx_data);
  18. $tnx_id = $tnx_data[$y];
  19. $invoiceNum = filter_var($invoice, FILTER_SANITIZE_NUMBER_INT);
  20.  
  21. if (count($this->session->userdata('courseEnrollmentInvoiceId' . $invoiceNum)) > 1) {
  22.  
  23.  
  24. // amount check //
  25.  
  26. // if(!($sessionData['amount_with_tax']>=$sessionData['amount']))
  27. // {
  28. // echo 'invalid amount request not accepted, sorry please try again';
  29. // exit;
  30. // }
  31.  
  32. $circularData = $this->db->select('program_circular.academic_year,program_student_information.program_study_center_id')
  33. ->from('program_student_information')
  34. ->join('program_circular', 'program_student_information.program_circular_id=program_circular.program_circular_id')
  35. ->where('program_student_information.program_student_information_id', $sessionData['student_id'])->get()->row();
  36.  
  37. $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();
  38.  
  39. $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();
  40.  
  41.  
  42.  
  43.  
  44.  
  45.  
  46. $payment_record_data['student_id'] = $sessionData['student_id'];
  47. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  48. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  49. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  50. $payment_record_data['service_id'] = 17;
  51. $payment_record_data['school_id'] = $school->school_id;
  52. if ($sessionData['circular_id'] == 37) {
  53. $payment_record_data['academic_year'] = 2019;
  54. $payment_record_data['program_circular_id'] = 59;
  55. } else {
  56. $payment_record_data['academic_year'] = $circularData->academic_year;
  57. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  58. }
  59. if ($sessionData['circular_id'] == 35) {
  60. $payment_record_data['semester'] = 2;
  61. }
  62. if ($sessionData['circular_id'] == 57) {
  63. $payment_record_data['semester'] = 2;
  64. }
  65.  
  66. // $payment_record_data['academic_year'] = $circularData->academic_year;
  67. // $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  68. $payment_record_data['program_id'] = $sessionData['program_id'];
  69. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  70. $payment_record_data['invoice_id'] = $invoiceNum;
  71. $payment_record_data['paid_amount'] = $amount;
  72. $payment_record_data['transaction_id'] = $tnx_id;
  73. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  74. $payment_record_data['create_date'] = date('Y/m/d');
  75.  
  76.  
  77. /*echo '<pre>';
  78. print_r($payment_record_data);
  79. echo '</pre>';
  80. exit;*/
  81.  
  82. $insertId = $this->common_model->save('payment_record', $payment_record_data);
  83. if ($insertId <> 0) {
  84. if ($y==($count-1)){
  85. $payment_record_ids .= $insertId.',';
  86. $payment_record_ids = trim($payment_record_ids, ',');
  87. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  88. $dataStudentCourse['courses_id'] = $sessionData['checkedCourses'];
  89. $dataStudentCourse['payment_record_id'] = $payment_record_ids;
  90. $dataStudentCourse['term_year'] = $this->session->userdata('admission_for' . ($sessionData['student_id'] - 1));
  91. $dataStudentCourse['application_date'] = date('Y') . '-' . date('m') . '-' . date('d');
  92. $dataStudentCourse['course_enrollment'] = 1;
  93.  
  94. $this->common_model->save('student_course_info', $dataStudentCourse);
  95. //For Email and sms
  96. $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();
  97. $this->email($email_id->email, 'You have successfully requested for Course Enrollment at Bangladesh Open University');
  98.  
  99. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Course Enrollment at Bangladesh Open University");
  100.  
  101.  
  102. $successData['amount'] = $sessionData['amount_with_tax'];
  103. $successData['service_name'] = $sessionData['service_name'];
  104.  
  105. $this->load->view('success_payment', $successData);
  106.  
  107. $this->session->unset_userdata('courseEnrollmentInvoiceId' . $invoiceNum);
  108. }else{
  109. $payment_record_ids .= $insertId.',';
  110. }
  111.  
  112.  
  113.  
  114. }
  115.  
  116. // echo '<pre>';
  117. // print_r($sessionData);
  118. // echo '</pre>';
  119. // echo '<pre>',print_r($this->session->all_userdata()),'</pre>';
  120. } elseif (count($this->session->userdata('registrationData' . $invoiceNum)) > 1) {
  121. /*echo '<pre>',print_r($this->session->all_userdata()),'</pre>';
  122. exit;*/
  123. $sessionAllData = $this->session->userdata('registrationData' . $invoiceNum);
  124.  
  125.  
  126. $data['student_name_bangla'] = $sessionAllData['student_name_bangla'];
  127. $data['student_name_english'] = $sessionAllData['student_name_english'];
  128. $data['fathers_name_bangla'] = $sessionAllData['fathers_name_bangla'];
  129. $data['fathers_name_english'] = $sessionAllData['fathers_name_english'];
  130. $data['mothers_name_bangla'] = $sessionAllData['mothers_name_bangla'];
  131. $data['mothers_name_english'] = $sessionAllData['mothers_name_english'];
  132. $data['photo'] = $sessionAllData['photo'];
  133. $data['signature'] = $sessionAllData['signature'];
  134. $data['legal_guardian_name'] = $sessionAllData['legal_guardian_name'];
  135. $data['date_of_birth'] = strtotime($sessionAllData['date_of_birth']);
  136. $data['place_of_birth'] = $sessionAllData['place_of_birth'];
  137. $data['marital_status'] = $sessionAllData['marital_status'];
  138. $data['gender'] = $sessionAllData['gender'];
  139. $data['quota_id'] = $sessionAllData['quota_id'];
  140. $data['national_id'] = $sessionAllData['national_id'];
  141. $data['nationality'] = $sessionAllData['nationality'];
  142. $data['present_village'] = $sessionAllData['present_village'];
  143. $data['present_post_office'] = $sessionAllData['present_post_office'];
  144. $data['present_post_code'] = $sessionAllData['present_post_code'];
  145. $data['present_district_id'] = $sessionAllData['present_district_id'];
  146. $data['present_upazilla_id'] = $sessionAllData['present_upazilla_id'];
  147. $data['permanent_village'] = $sessionAllData['permanent_village'];
  148. $data['permanent_post_office'] = $sessionAllData['permanent_post_office'];
  149. $data['permanent_post_code'] = $sessionAllData['permanent_post_code'];
  150. $data['permanent_district_id'] = $sessionAllData['permanent_district_id'];
  151. $data['permanent_upazilla_id'] = $sessionAllData['permanent_upazilla_id'];
  152. $data['quota_id'] = $sessionAllData['quota_id'];
  153. $data['mobile_number'] = $sessionAllData['mobile_number'];
  154. $data['email'] = $sessionAllData['email'];
  155. $data['job_experience'] = $sessionAllData['job_experience'];
  156. $data['blood_group'] = $sessionAllData['blood_group'];
  157. $data['direct_admissionCheck'] = $sessionAllData['direct_admissionCheck'];
  158. // $data['academic_history'] = $this->session->userdata('academic_history'.$invoiceNum);
  159. /*echo '<pre>',print_r($data),'</pre>';
  160. exit;*/
  161.  
  162. $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();
  163.  
  164. $data['academic_history'] = $academic_history->academic_history;
  165. $data['additional_documents_name'] = $academic_history->additional_documents_name;
  166. $data['additional_documents_file_location'] = $academic_history->additional_documents_file_location;
  167.  
  168. $explodeAdmissionFor = explode('#', $sessionAllData['admission_for']);
  169. if (count($explodeAdmissionFor) > 0) {
  170. if ($explodeAdmissionFor[1] == 'semester')
  171. $admissionFor = $explodeAdmissionFor[0] . '#semister';
  172. else
  173. $admissionFor = $sessionAllData['admission_for'];
  174. } else {
  175. $admissionFor = $sessionAllData['admission_for'];
  176. }
  177. $data['admission_for'] = $admissionFor;
  178. $this->db->insert('user_student', $data);
  179. $id = mysqli_insert_id();
  180.  
  181. if ($id <> 0 && $id <> '') {
  182. //admission data in session
  183. $sessionData2['admission_for' . $id] = $sessionAllData['admission_for'];
  184. $this->session->set_userdata($sessionData2);
  185. //end admission data in session
  186.  
  187. //program info
  188. $password = $this->common_model->get_password(6);
  189. $data1['user_student_id'] = $id;
  190. $data1['program_circular_id'] = $sessionAllData['program_circular_id'];
  191. $data1['program_study_center_id'] = $sessionAllData['program_study_center_id'];
  192. $data1['test_venue'] = $sessionAllData['test_venue'];
  193. $data1['program_group_id'] = $sessionAllData['program_group_id'];
  194. $data1['application_date'] = strtotime(date("m/d/Y H:i:s", time()));
  195. $data1['student_id'] = $id;
  196. $data1['password'] = md5($password);
  197. $data1['student_activity_status'] = 1;
  198.  
  199. $this->db->insert('program_student_information', $data1);
  200. $id2 = mysqli_insert_id();
  201. //email_for_temporary_id
  202. //sms_for_temporary_id
  203. $email = $sessionAllData['email'];
  204. $mobile_no = $sessionAllData['mobile_number'];
  205.  
  206. $this->communication_model->email_for_temporary_id($email, $id2, $password);
  207. $this->communication_model->sms_for_temporary_id($mobile_no, $id2, $password);
  208.  
  209. $data2['user_id'] = $id2;
  210. $data2['user_type'] = 'student';
  211. $data2['ip'] = $this->common_model->get_ip();
  212. $data2['login_time'] = strtotime(date("m/d/Y H:i:s", time()));
  213. $this->db->insert('security_user_session', $data2);
  214. $session_id = mysqli_insert_id();
  215.  
  216. $this->session->set_userdata('student', '1');
  217. $this->session->set_userdata('security_user_session_id', $session_id);
  218. $this->session->set_userdata('program_student_information_id', $id2);
  219.  
  220.  
  221. $circularData = $this->common_model->get_fixed_data('program_id,degree_group_id,academic_year', 'program_circular_id', $sessionAllData['program_circular_id'], 'program_circular');
  222.  
  223. $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();
  224.  
  225. //$school = $this->db->select('school.school_id')->from('program')->join('school','program.school_id=school.school_id')->get()->row();
  226. $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();
  227.  
  228. $payment_record_data['student_id'] = $id2;
  229. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  230. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  231. $payment_record_data['program_study_center_id'] = $sessionAllData['program_study_center_id'];
  232. $payment_record_data['service_id'] = 16;
  233. $payment_record_data['school_id'] = $school->school_id;
  234. $payment_record_data['academic_year'] = $circularData[0]->academic_year;
  235. $payment_record_data['program_id'] = $circularData[0]->program_id;
  236. $payment_record_data['program_group_id'] = $circularData[0]->degree_group_id;
  237. $payment_record_data['program_circular_id'] = $sessionAllData['program_circular_id'];
  238. $payment_record_data['invoice_id'] = $invoiceNum;
  239. // $payment_record_data['paid_amount'] = $sessionAllData['amount_with_tax'];
  240. $payment_record_data['paid_amount'] = $amount;
  241. $payment_record_data['transaction_id'] = $tnx_id;
  242. $payment_record_data['payment_method'] = $sessionAllData['payment_method'];
  243. $payment_record_data['create_date'] = date('Y/m/d');
  244.  
  245. $insertId = $this->common_model->save('payment_record', $payment_record_data);
  246.  
  247. if ($insertId <> 0) {
  248. $this->session->unset_userdata('registrationData' . $invoiceNum);
  249. // $this->session->unset_userdata('academic_history'.$invoiceNum);
  250. redirect(base_url() . 'student/student_private', 'refresh');
  251. }
  252. //redirect(base_url() . 'student/student_private/course_fee' , 'refresh');
  253. } else {
  254. echo 'sorry something is wrong please try again ';
  255. }
  256. } elseif (count($this->session->userdata('reExamInvoiceId' . $invoiceNum)) > 1) {
  257. // echo '<pre>';
  258. // print_r($this->session->userdata('reExamInvoiceId'.$invoice));
  259. // echo '</pre>';
  260. $sessionData = $this->session->userdata('reExamInvoiceId' . $invoiceNum);
  261.  
  262. /*$data['student_id'] = $sessionData['student_id'];
  263. $data['service_id'] = '3';
  264. $data['program_id'] = $sessionData['program_id'];
  265. $data['program_group_id'] = $sessionData['group_id'];
  266. $data['program_circular_id'] = $sessionData['circular_id'];
  267. $data['invoice_id'] = $invoiceNum;
  268. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  269. $data['paid_amount'] = $sessionData['amount'];
  270. $data['transaction_id'] = $sessionData['transation_id'];
  271. $data['payment_method'] = $sessionData['payment_method'];
  272. $data['create_date'] = date('Y/m/d');*/
  273.  
  274.  
  275. $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();
  276.  
  277. $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();
  278.  
  279. $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();
  280.  
  281. $payment_record_data['student_id'] = $sessionData['student_id'];
  282. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  283. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  284. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  285. $payment_record_data['service_id'] = 3;
  286. $payment_record_data['school_id'] = $school->school_id;
  287. $payment_record_data['academic_year'] = $circularData->academic_year;
  288. $payment_record_data['program_id'] = $sessionData['program_id'];
  289. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  290. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  291. $payment_record_data['invoice_id'] = $invoiceNum;
  292. $payment_record_data['paid_amount'] = $amount;
  293. $payment_record_data['transaction_id'] = $tnx_id;
  294. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  295. $payment_record_data['create_date'] = date('Y/m/d');
  296.  
  297.  
  298. $insertId = $this->common_model->save('payment_record', $data);
  299. if ($insertId <> 0) {
  300. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  301. $dataStudentCourse['service_id'] = 3;
  302. $dataStudentCourse['create_date'] = date('Y/m/d');
  303. $dataStudentCourse['approval_status'] = 0;
  304. $dataStudentCourse['payment_record_id'] = $insertId;
  305.  
  306. $additional_information = array('courses' => $sessionData['checkedCourses']);
  307.  
  308. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  309.  
  310. $this->common_model->save('service_application_form', $dataStudentCourse);
  311.  
  312.  
  313. //For Email and sms
  314. $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();
  315. $this->email($email_id->email, 'You have successfully requested for Re-exam Service at Bangladesh Open University');
  316. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Re-exam Service at Bangladesh Open University");
  317.  
  318.  
  319. $successData['amount'] = $sessionData['amount_with_tax'];
  320. $successData['service_name'] = $sessionData['service_name'];
  321.  
  322. $this->load->view('success_payment', $successData);
  323.  
  324. $this->session->unset_userdata('reExamInvoiceId' . $invoiceNum);
  325. }
  326. } elseif (count($this->session->userdata('testimonialInvoiceId' . $invoiceNum)) > 1) {
  327. $sessionData = $this->session->userdata('testimonialInvoiceId' . $invoiceNum);
  328.  
  329. /*$data['student_id'] = $sessionData['student_id'];
  330. $data['service_id'] = 4;
  331. $data['program_id'] = $sessionData['program_id'];
  332. $data['program_group_id'] = $sessionData['group_id'];
  333. $data['program_circular_id'] = $sessionData['circular_id'];
  334. $data['invoice_id'] = $invoiceNum;
  335. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  336. $data['paid_amount'] = $sessionData['amount'];
  337. $data['transaction_id'] = $sessionData['transation_id'];
  338. $data['payment_method'] = $sessionData['payment_method'];
  339. $data['create_date'] = date('Y/m/d');*/
  340.  
  341.  
  342. $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();
  343.  
  344. $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();
  345.  
  346. $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();
  347.  
  348. $payment_record_data['student_id'] = $sessionData['student_id'];
  349. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  350. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  351. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  352. $payment_record_data['service_id'] = 4;
  353. $payment_record_data['school_id'] = $school->school_id;
  354. $payment_record_data['academic_year'] = $circularData->academic_year;
  355. $payment_record_data['program_id'] = $sessionData['program_id'];
  356. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  357. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  358. $payment_record_data['invoice_id'] = $invoiceNum;
  359. $payment_record_data['paid_amount'] = $amount;
  360. $payment_record_data['transaction_id'] = $tnx_id;
  361. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  362. $payment_record_data['create_date'] = date('Y/m/d');
  363.  
  364.  
  365. $insertId = $this->common_model->save('payment_record', $payment_record_data);
  366. if ($insertId <> 0) {
  367. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  368. $dataStudentCourse['service_id'] = 4;
  369. $dataStudentCourse['create_date'] = date('Y/m/d');
  370. $dataStudentCourse['approval_status'] = 0;
  371. $dataStudentCourse['payment_record_id'] = $insertId;
  372.  
  373. $additional_information = array('gpa' => $sessionData['gpa'], 'year_of_passed' => $sessionData['year_of_passed']);
  374.  
  375. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  376.  
  377. /*echo '<pre>';
  378. print_r($dataStudentCourse);
  379. echo '</pre>';
  380. exit;*/
  381.  
  382. $this->common_model->save('service_application_form', $dataStudentCourse);
  383.  
  384. //For Email and sms
  385. $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();
  386. $this->email($email_id->email, 'You have successfully requested for Testimonial Service at Bangladesh Open University');
  387.  
  388. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Testimonial Service at Bangladesh Open University");
  389.  
  390.  
  391. $successData['amount'] = $sessionData['amount_with_tax'];
  392. $successData['service_name'] = $sessionData['service_name'];
  393.  
  394. $this->load->view('success_payment', $successData);
  395.  
  396. $this->session->unset_userdata('testimonialInvoiceId' . $invoiceNum);
  397. }
  398. } elseif (count($this->session->userdata('provisional_certificateInvoiceId' . $invoiceNum)) > 1) {
  399. $sessionData = $this->session->userdata('provisional_certificateInvoiceId' . $invoiceNum);
  400.  
  401. /*$data['student_id'] = $sessionData['student_id'];
  402. $data['service_id'] = 6;
  403. $data['program_id'] = $sessionData['program_id'];
  404. $data['program_group_id'] = $sessionData['group_id'];
  405. $data['program_circular_id'] = $sessionData['circular_id'];
  406. $data['invoice_id'] = $invoiceNum;
  407. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  408. $data['paid_amount'] = $sessionData['amount'];
  409. $data['transaction_id'] = $sessionData['transation_id'];
  410. $data['payment_method'] = $sessionData['payment_method'];
  411. $data['create_date'] = date('Y/m/d');*/
  412.  
  413.  
  414. $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();
  415.  
  416. $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();
  417.  
  418. $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();
  419.  
  420. $payment_record_data['student_id'] = $sessionData['student_id'];
  421. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  422. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  423. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  424. $payment_record_data['service_id'] = 6;
  425. $payment_record_data['school_id'] = $school->school_id;
  426. $payment_record_data['academic_year'] = $circularData->academic_year;
  427. $payment_record_data['program_id'] = $sessionData['program_id'];
  428. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  429. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  430. $payment_record_data['invoice_id'] = $invoiceNum;
  431. $payment_record_data['paid_amount'] = $amount;
  432. $payment_record_data['transaction_id'] = $tnx_id;
  433. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  434. $payment_record_data['create_date'] = date('Y/m/d');
  435.  
  436. $insertId = $this->common_model->save('payment_record', $data);
  437. if ($insertId <> 0) {
  438. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  439. $dataStudentCourse['service_id'] = 6;
  440. $dataStudentCourse['create_date'] = date('Y/m/d');
  441. $dataStudentCourse['approval_status'] = 0;
  442. $dataStudentCourse['payment_record_id'] = $insertId;
  443.  
  444. $additional_information = array('year_of_passed' => $sessionData['year_of_passed'], 'exam_name' => $sessionData['exam_name'], 'result' => $sessionData['result']);
  445.  
  446. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  447.  
  448. $this->common_model->save('service_application_form', $dataStudentCourse);
  449.  
  450. //For Email and sms
  451. $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();
  452. $this->email($email_id->email, 'You have successfully requested for Provisional Certificate Service at Bangladesh Open University');
  453.  
  454. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Provisional Certificate Service at Bangladesh Open University");
  455.  
  456.  
  457. $successData['amount'] = $sessionData['amount_with_tax'];
  458. $successData['service_name'] = $sessionData['service_name'];
  459.  
  460. $this->load->view('success_payment', $successData);
  461.  
  462. $this->session->unset_userdata('provisional_certificateInvoiceId' . $invoiceNum);
  463. }
  464. } elseif (count($this->session->userdata('convocationInvoiceId' . $invoiceNum)) > 1) {
  465. $sessionData = $this->session->userdata('convocationInvoiceId' . $invoiceNum);
  466. $sessionFileData = $this->session->userdata('convocationFileInvoiceId' . $invoiceNum);
  467.  
  468. /*$data['student_id'] = $sessionData['student_id'];
  469. $data['service_id'] = 11;
  470. $data['program_id'] = $sessionData['program_id'];
  471. $data['program_group_id'] = $sessionData['group_id'];
  472. $data['program_circular_id'] = $sessionData['circular_id'];
  473. $data['invoice_id'] = $invoiceNum;
  474. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  475. $data['paid_amount'] = $sessionData['amount'];
  476. $data['transaction_id'] = $sessionData['transation_id'];
  477. $data['payment_method'] = $sessionData['payment_method'];
  478. $data['create_date'] = date('Y/m/d');*/
  479.  
  480.  
  481. $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();
  482.  
  483. $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();
  484.  
  485. $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();
  486.  
  487. $payment_record_data['student_id'] = $sessionData['student_id'];
  488. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  489. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  490. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  491. $payment_record_data['service_id'] = 11;
  492. $payment_record_data['school_id'] = $school->school_id;
  493. $payment_record_data['academic_year'] = $circularData->academic_year;
  494. $payment_record_data['program_id'] = $sessionData['program_id'];
  495. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  496. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  497. $payment_record_data['invoice_id'] = $invoiceNum;
  498. $payment_record_data['paid_amount'] = $amount;
  499. $payment_record_data['transaction_id'] = $tnx_id;
  500. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  501. $payment_record_data['create_date'] = date('Y/m/d');
  502.  
  503.  
  504. $insertId = $this->common_model->save('payment_record', $data);
  505. if ($insertId <> 0) {
  506. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  507. $dataStudentCourse['service_id'] = 11;
  508. $dataStudentCourse['create_date'] = date('Y/m/d');
  509. $dataStudentCourse['approval_status'] = 0;
  510. $dataStudentCourse['payment_record_id'] = $insertId;
  511.  
  512. $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]);
  513.  
  514. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  515.  
  516. $this->common_model->save('service_application_form', $dataStudentCourse);
  517.  
  518. //For Email and sms
  519. $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();
  520. $this->email($email_id->email, 'You have successfully requested for Convocation Service at Bangladesh Open University');
  521.  
  522. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Convocation Service at Bangladesh Open University");
  523.  
  524.  
  525. $successData['amount'] = $sessionData['amount_with_tax'];
  526. $successData['service_name'] = $sessionData['service_name'];
  527. $this->load->view('success_payment', $successData);
  528.  
  529. $this->session->unset_userdata('convocationInvoiceId' . $invoiceNum);
  530. $this->session->unset_userdata('convocationFileInvoiceId' . $invoiceNum);
  531. }
  532. } elseif (count($this->session->userdata('name_correctionInvoiceId' . $invoiceNum)) > 1) {
  533. $sessionData = $this->session->userdata('name_correctionInvoiceId' . $invoiceNum);
  534. $sessionFileData = $this->session->userdata('name_correctionFileInvoiceId' . $invoiceNum);
  535.  
  536. /*$data['student_id'] = $sessionData['student_id'];
  537. $data['service_id'] = 12;
  538. $data['program_id'] = $sessionData['program_id'];
  539. $data['program_group_id'] = $sessionData['group_id'];
  540. $data['program_circular_id'] = $sessionData['circular_id'];
  541. $data['invoice_id'] = $invoiceNum;
  542. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  543. $data['paid_amount'] = $sessionData['amount'];
  544. $data['transaction_id'] = $sessionData['transation_id'];
  545. $data['payment_method'] = $sessionData['payment_method'];
  546. $data['create_date'] = date('Y/m/d');*/
  547.  
  548.  
  549. $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();
  550.  
  551. $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();
  552.  
  553. $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();
  554.  
  555. $payment_record_data['student_id'] = $sessionData['student_id'];
  556. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  557. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  558. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  559. $payment_record_data['service_id'] = 12;
  560. $payment_record_data['school_id'] = $school->school_id;
  561. $payment_record_data['academic_year'] = $circularData->academic_year;
  562. $payment_record_data['program_id'] = $sessionData['program_id'];
  563. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  564. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  565. $payment_record_data['invoice_id'] = $invoiceNum;
  566. $payment_record_data['paid_amount'] = $amount;
  567. $payment_record_data['transaction_id'] = $tnx_id;
  568. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  569. $payment_record_data['create_date'] = date('Y/m/d');
  570.  
  571.  
  572. $insertId = $this->common_model->save('payment_record', $data);
  573. if ($insertId <> 0) {
  574. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  575. $dataStudentCourse['service_id'] = 12;
  576. $dataStudentCourse['create_date'] = date('Y/m/d');
  577. $dataStudentCourse['approval_status'] = 0;
  578. $dataStudentCourse['payment_record_id'] = $insertId;
  579.  
  580. $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]);
  581.  
  582. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  583.  
  584. $this->common_model->save('service_application_form', $dataStudentCourse);
  585.  
  586. //For Email and sms
  587. $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();
  588. $this->email($email_id->email, 'You have successfully requested for Name Correction Service at Bangladesh Open University');
  589.  
  590. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Name Correction Service at Bangladesh Open University");
  591.  
  592.  
  593. $successData['amount'] = $sessionData['amount_with_tax'];
  594. $successData['service_name'] = $sessionData['service_name'];
  595. $this->load->view('success_payment', $successData);
  596.  
  597. $this->session->unset_userdata('name_correctionInvoiceId' . $invoiceNum);
  598. $this->session->unset_userdata('name_correctionFileInvoiceId' . $invoiceNum);
  599. }
  600. } elseif (count($this->session->userdata('migrationInvoiceId' . $invoiceNum)) > 1) {
  601. $sessionData = $this->session->userdata('migrationInvoiceId' . $invoiceNum);
  602.  
  603. /*$data['student_id'] = $sessionData['student_id'];
  604. $data['service_id'] = 14;
  605. $data['program_id'] = $sessionData['program_id'];
  606. $data['program_group_id'] = $sessionData['group_id'];
  607. $data['program_circular_id'] = $sessionData['circular_id'];
  608. $data['invoice_id'] = $invoiceNum;
  609. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  610. $data['paid_amount'] = $sessionData['amount'];
  611. $data['transaction_id'] = $sessionData['transation_id'];
  612. $data['payment_method'] = $sessionData['payment_method'];
  613. $data['create_date'] = date('Y/m/d');*/
  614.  
  615.  
  616. $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();
  617.  
  618. $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();
  619.  
  620. $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();
  621.  
  622. $payment_record_data['student_id'] = $sessionData['student_id'];
  623. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  624. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  625. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  626. $payment_record_data['service_id'] = 14;
  627. $payment_record_data['school_id'] = $school->school_id;
  628. $payment_record_data['academic_year'] = $circularData->academic_year;
  629. $payment_record_data['program_id'] = $sessionData['program_id'];
  630. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  631. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  632. $payment_record_data['invoice_id'] = $invoiceNum;
  633. $payment_record_data['paid_amount'] = $amount;
  634. $payment_record_data['transaction_id'] = $tnx_id;
  635. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  636. $payment_record_data['create_date'] = date('Y/m/d');
  637.  
  638.  
  639. $insertId = $this->common_model->save('payment_record', $data);
  640. if ($insertId <> 0) {
  641. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  642. $dataStudentCourse['service_id'] = 14;
  643. $dataStudentCourse['create_date'] = date('Y/m/d');
  644. $dataStudentCourse['approval_status'] = 0;
  645. $dataStudentCourse['payment_record_id'] = $insertId;
  646.  
  647. $additional_information = array('exam_you_have_passed' => $sessionData['exam_you_have_passed'], 'which_date' => $sessionData['which_date'], 'reason_of_leave' => $sessionData['reason_of_leave']);
  648.  
  649. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  650.  
  651. $this->common_model->save('service_application_form', $dataStudentCourse);
  652.  
  653. //For Email and sms
  654. $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();
  655. $this->email($email_id->email, 'You have successfully requested for Migration Service at Bangladesh Open University');
  656.  
  657. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Migration Service at Bangladesh Open University");
  658.  
  659.  
  660. $successData['amount'] = $sessionData['amount_with_tax'];
  661. $successData['service_name'] = $sessionData['service_name'];
  662. $this->load->view('success_payment', $successData);
  663.  
  664.  
  665. $this->session->unset_userdata('migrationInvoiceId' . $invoiceNum);
  666. }
  667. } elseif (count($this->session->userdata('study_centerInvoiceId' . $invoiceNum)) > 1) {
  668. $sessionData = $this->session->userdata('study_centerInvoiceId' . $invoiceNum);
  669.  
  670. /*$data['student_id'] = $sessionData['student_id'];
  671. $data['service_id'] = 13;
  672. $data['program_id'] = $sessionData['program_id'];
  673. $data['program_group_id'] = $sessionData['group_id'];
  674. $data['program_circular_id'] = $sessionData['circular_id'];
  675. $data['invoice_id'] = $invoiceNum;
  676. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  677. $data['paid_amount'] = $sessionData['amount'];
  678. $data['transaction_id'] = $sessionData['transation_id'];
  679. $data['payment_method'] = $sessionData['payment_method'];
  680. $data['create_date'] = date('Y/m/d');*/
  681.  
  682.  
  683. $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();
  684.  
  685. $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();
  686.  
  687. $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();
  688.  
  689. $payment_record_data['student_id'] = $sessionData['student_id'];
  690. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  691. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  692. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  693. $payment_record_data['service_id'] = 13;
  694. $payment_record_data['school_id'] = $school->school_id;
  695. $payment_record_data['academic_year'] = $circularData->academic_year;
  696. $payment_record_data['program_id'] = $sessionData['program_id'];
  697. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  698. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  699. $payment_record_data['invoice_id'] = $invoiceNum;
  700. $payment_record_data['paid_amount'] = $amount;
  701. $payment_record_data['transaction_id'] = $tnx_id;
  702. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  703. $payment_record_data['create_date'] = date('Y/m/d');
  704.  
  705.  
  706. $insertId = $this->common_model->save('payment_record', $data);
  707. if ($insertId <> 0) {
  708. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  709. $dataStudentCourse['service_id'] = 13;
  710. $dataStudentCourse['create_date'] = date('Y/m/d');
  711. $dataStudentCourse['approval_status'] = 0;
  712. $dataStudentCourse['payment_record_id'] = $insertId;
  713.  
  714. $additional_information = array('exam_name' => $sessionData['exam_name'], 'study_center' => $sessionData['study_center'], 'reason_of_transfer' => $sessionData['reason_of_transfer']);
  715.  
  716. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  717.  
  718. $this->common_model->save('service_application_form', $dataStudentCourse);
  719.  
  720. //For Email and sms
  721. $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();
  722. $this->email($email_id->email, 'You have successfully requested for Study Center Transfer Service at Bangladesh Open University');
  723.  
  724. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Study Center Transfer Service at Bangladesh Open University");
  725.  
  726.  
  727. $successData['amount'] = $sessionData['amount_with_tax'];
  728. $successData['service_name'] = $sessionData['service_name'];
  729. $this->load->view('success_payment', $successData);
  730.  
  731.  
  732. $this->session->unset_userdata('study_centerInvoiceId' . $invoiceNum);
  733. }
  734. } elseif (count($this->session->userdata('ans_script_reevaluation_applyInvoiceId' . $invoiceNum)) > 1) {
  735. $sessionData = $this->session->userdata('ans_script_reevaluation_applyInvoiceId' . $invoiceNum);
  736.  
  737. /*$data['student_id'] = $sessionData['student_id'];
  738. $data['service_id'] = 5;
  739. $data['program_id'] = $sessionData['program_id'];
  740. $data['program_group_id'] = $sessionData['group_id'];
  741. $data['program_circular_id'] = $sessionData['circular_id'];
  742. $data['invoice_id'] = $invoiceNum;
  743. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  744. $data['paid_amount'] = $sessionData['amount'];
  745. $data['transaction_id'] = $sessionData['transation_id'];
  746. $data['payment_method'] = $sessionData['payment_method'];
  747. $data['create_date'] = date('Y/m/d');*/
  748.  
  749.  
  750. $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();
  751.  
  752. $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();
  753.  
  754. $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();
  755.  
  756. $payment_record_data['student_id'] = $sessionData['student_id'];
  757. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  758. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  759. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  760. $payment_record_data['service_id'] = 5;
  761. $payment_record_data['school_id'] = $school->school_id;
  762. $payment_record_data['academic_year'] = $circularData->academic_year;
  763. $payment_record_data['program_id'] = $sessionData['program_id'];
  764. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  765. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  766. $payment_record_data['invoice_id'] = $invoiceNum;
  767. $payment_record_data['paid_amount'] = $amount;
  768. $payment_record_data['transaction_id'] = $tnx_id;
  769. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  770. $payment_record_data['create_date'] = date('Y/m/d');
  771.  
  772.  
  773. $insertId = $this->common_model->save('payment_record', $data);
  774. if ($insertId <> 0) {
  775. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  776. $dataStudentCourse['service_id'] = 5;
  777. $dataStudentCourse['create_date'] = date('Y/m/d');
  778. $dataStudentCourse['approval_status'] = 0;
  779. $dataStudentCourse['payment_record_id'] = $insertId;
  780.  
  781. /*Cause*/
  782. $cause = array_filter($sessionData['cause']);
  783. $causeArr = array();
  784. for ($i = 0; $i < count($cause); $i++) {
  785. $causeArr[] = $cause[$i];
  786. }
  787. /*Cause*/
  788.  
  789. $additional_information = array('exam_hall' => $sessionData['exam_hall'], 'semister' => $sessionData['semister'], 'exam_year' => $sessionData['exam_year'], 'courses' => $sessionData['checkedCourses'], 'cause' => $causeArr);
  790.  
  791. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  792.  
  793. $this->common_model->save('service_application_form', $dataStudentCourse);
  794.  
  795. //For Email and sms
  796. $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();
  797. $this->email($email_id->email, 'You have successfully requested for Answer Script Re-evaluation Service at Bangladesh Open University');
  798.  
  799. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Answer Script Re-evaluation Service at Bangladesh Open University");
  800.  
  801.  
  802. $successData['amount'] = $sessionData['amount_with_tax'];
  803. $successData['service_name'] = $sessionData['service_name'];
  804. $this->load->view('success_payment', $successData);
  805.  
  806.  
  807. $this->session->unset_userdata('ans_script_reevaluation_applyInvoiceId' . $invoiceNum);
  808. }
  809. } elseif (count($this->session->userdata('main_certificateInvoiceId' . $invoiceNum)) > 1) {
  810. $sessionData = $this->session->userdata('main_certificateInvoiceId' . $invoiceNum);
  811.  
  812. /*$data['student_id'] = $sessionData['student_id'];
  813. $data['service_id'] = 7;
  814. $data['program_id'] = $sessionData['program_id'];
  815. $data['program_group_id'] = $sessionData['group_id'];
  816. $data['program_circular_id'] = $sessionData['circular_id'];
  817. $data['invoice_id'] = $invoiceNum;
  818. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  819. $data['paid_amount'] = $sessionData['amount'];
  820. $data['transaction_id'] = $sessionData['transation_id'];
  821. $data['payment_method'] = $sessionData['payment_method'];
  822. $data['create_date'] = date('Y/m/d');*/
  823.  
  824.  
  825. $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();
  826.  
  827. $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();
  828.  
  829. $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();
  830.  
  831. $payment_record_data['student_id'] = $sessionData['student_id'];
  832. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  833. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  834. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  835. $payment_record_data['service_id'] = 7;
  836. $payment_record_data['school_id'] = $school->school_id;
  837. $payment_record_data['academic_year'] = $circularData->academic_year;
  838. $payment_record_data['program_id'] = $sessionData['program_id'];
  839. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  840. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  841. $payment_record_data['invoice_id'] = $invoiceNum;
  842. $payment_record_data['paid_amount'] = $amount;
  843. $payment_record_data['transaction_id'] = $tnx_id;
  844. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  845. $payment_record_data['create_date'] = date('Y/m/d');
  846.  
  847.  
  848. $insertId = $this->common_model->save('payment_record', $data);
  849. if ($insertId <> 0) {
  850. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  851. $dataStudentCourse['service_id'] = 7;
  852. $dataStudentCourse['create_date'] = date('Y/m/d');
  853. $dataStudentCourse['approval_status'] = 0;
  854. $dataStudentCourse['payment_record_id'] = $insertId;
  855.  
  856. $additional_information = array('year_of_passed' => $sessionData['year_of_passed'], 'exam_name' => $sessionData['exam_name'], 'result' => $sessionData['result']);
  857.  
  858. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  859.  
  860. $this->common_model->save('service_application_form', $dataStudentCourse);
  861.  
  862. //For Email and sms
  863. $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();
  864. $this->email($email_id->email, 'You have successfully requested for Main Certificate Service at Bangladesh Open University');
  865.  
  866. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Main Certificate Service at Bangladesh Open University");
  867.  
  868.  
  869. $successData['amount'] = $sessionData['amount_with_tax'];
  870. $successData['service_name'] = $sessionData['service_name'];
  871. $this->load->view('success_payment', $successData);
  872.  
  873.  
  874. $this->session->unset_userdata('main_certificateInvoiceId' . $invoiceNum);
  875. }
  876. } elseif (count($this->session->userdata('certificate_verificationInvoiceId' . $invoiceNum)) > 1) {
  877. $sessionData = $this->session->userdata('certificate_verificationInvoiceId' . $invoiceNum);
  878.  
  879. /*$data['student_id'] = $sessionData['student_id'];
  880. $data['service_id'] = 9;
  881. $data['program_id'] = $sessionData['program_id'];
  882. $data['program_group_id'] = $sessionData['group_id'];
  883. $data['program_circular_id'] = $sessionData['circular_id'];
  884. $data['invoice_id'] = $invoiceNum;
  885. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  886. $data['paid_amount'] = $sessionData['amount'];
  887. $data['transaction_id'] = $sessionData['transation_id'];
  888. $data['payment_method'] = $sessionData['payment_method'];
  889. $data['create_date'] = date('Y/m/d');*/
  890.  
  891.  
  892. $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();
  893.  
  894. $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();
  895.  
  896. $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();
  897.  
  898. $payment_record_data['student_id'] = $sessionData['student_id'];
  899. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  900. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  901. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  902. $payment_record_data['service_id'] = 9;
  903. $payment_record_data['school_id'] = $school->school_id;
  904. $payment_record_data['academic_year'] = $circularData->academic_year;
  905. $payment_record_data['program_id'] = $sessionData['program_id'];
  906. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  907. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  908. $payment_record_data['invoice_id'] = $invoiceNum;
  909. $payment_record_data['paid_amount'] = $amount;
  910. $payment_record_data['transaction_id'] = $tnx_id;
  911. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  912. $payment_record_data['create_date'] = date('Y/m/d');
  913.  
  914.  
  915. $insertId = $this->common_model->save('payment_record', $data);
  916. if ($insertId <> 0) {
  917. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  918. $dataStudentCourse['service_id'] = 9;
  919. $dataStudentCourse['create_date'] = date('Y/m/d');
  920. $dataStudentCourse['approval_status'] = 0;
  921. $dataStudentCourse['payment_record_id'] = $insertId;
  922.  
  923. $additional_information = array('year_of_passed' => $sessionData['year_of_passed'], 'exam_name' => $sessionData['exam_name'], 'result' => $sessionData['result']);
  924.  
  925. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  926.  
  927. $this->common_model->save('service_application_form', $dataStudentCourse);
  928.  
  929. //For Email and sms
  930. $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();
  931. $this->email($email_id->email, 'You have successfully requested for Certificate Verification Service at Bangladesh Open University');
  932.  
  933. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Certificate Verification Service at Bangladesh Open University");
  934.  
  935.  
  936. $successData['amount'] = $sessionData['amount_with_tax'];
  937. $successData['service_name'] = $sessionData['service_name'];
  938. $this->load->view('success_payment', $successData);
  939.  
  940.  
  941. $this->session->unset_userdata('certificate_verificationInvoiceId' . $invoiceNum);
  942. }
  943. } elseif (count($this->session->userdata('duplicate_provisional_applyInvoiceId' . $invoiceNum)) > 1) {
  944. $sessionData = $this->session->userdata('duplicate_provisional_applyInvoiceId' . $invoiceNum);
  945.  
  946. /*$data['student_id'] = $sessionData['student_id'];
  947. $data['service_id'] = 8;
  948. $data['program_id'] = $sessionData['program_id'];
  949. $data['program_group_id'] = $sessionData['group_id'];
  950. $data['program_circular_id'] = $sessionData['circular_id'];
  951. $data['invoice_id'] = $invoiceNum;
  952. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  953. $data['paid_amount'] = $sessionData['amount'];
  954. $data['transaction_id'] = $sessionData['transation_id'];
  955. $data['payment_method'] = $sessionData['payment_method'];
  956. $data['create_date'] = date('Y/m/d');*/
  957.  
  958.  
  959. $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();
  960.  
  961. $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();
  962.  
  963. $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();
  964.  
  965. $payment_record_data['student_id'] = $sessionData['student_id'];
  966. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  967. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  968. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  969. $payment_record_data['service_id'] = 8;
  970. $payment_record_data['school_id'] = $school->school_id;
  971. $payment_record_data['academic_year'] = $circularData->academic_year;
  972. $payment_record_data['program_id'] = $sessionData['program_id'];
  973. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  974. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  975. $payment_record_data['invoice_id'] = $invoiceNum;
  976. $payment_record_data['paid_amount'] = $amount;
  977. $payment_record_data['transaction_id'] = $tnx_id;
  978. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  979. $payment_record_data['create_date'] = date('Y/m/d');
  980.  
  981.  
  982. $insertId = $this->common_model->save('payment_record', $data);
  983. if ($insertId <> 0) {
  984. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  985. $dataStudentCourse['service_id'] = 8;
  986. $dataStudentCourse['create_date'] = date('Y/m/d');
  987. $dataStudentCourse['approval_status'] = 0;
  988. $dataStudentCourse['payment_record_id'] = $insertId;
  989.  
  990. $additional_information = array('year_of_passed' => $sessionData['year_of_passed'], 'exam_name' => $sessionData['exam_name'], 'result' => $sessionData['result']);
  991.  
  992. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  993.  
  994. $this->common_model->save('service_application_form', $dataStudentCourse);
  995.  
  996. //For Email and sms
  997. $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();
  998. $this->email($email_id->email, 'You have successfully requested for Duplicate provisional Certificate Service at Bangladesh Open University');
  999.  
  1000. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Duplicate provisional Certificate Service at Bangladesh Open University");
  1001.  
  1002. $successData['amount'] = $sessionData['amount_with_tax'];
  1003. $successData['service_name'] = $sessionData['service_name'];
  1004. $this->load->view('success_payment', $successData);
  1005.  
  1006.  
  1007. $this->session->unset_userdata('duplicate_provisional_applyInvoiceId' . $invoiceNum);
  1008. }
  1009. } elseif (count($this->session->userdata('duplicate_main_applyInvoiceId' . $invoiceNum)) > 1) {
  1010. $sessionData = $this->session->userdata('duplicate_main_applyInvoiceId' . $invoiceNum);
  1011.  
  1012. /*$data['student_id'] = $sessionData['student_id'];
  1013. $data['service_id'] = 10;
  1014. $data['program_id'] = $sessionData['program_id'];
  1015. $data['program_group_id'] = $sessionData['group_id'];
  1016. $data['program_circular_id'] = $sessionData['circular_id'];
  1017. $data['invoice_id'] = $invoiceNum;
  1018. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  1019. $data['paid_amount'] = $sessionData['amount'];
  1020. $data['transaction_id'] = $sessionData['transation_id'];
  1021. $data['payment_method'] = $sessionData['payment_method'];
  1022. $data['create_date'] = date('Y/m/d');*/
  1023.  
  1024.  
  1025. $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();
  1026.  
  1027. $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();
  1028.  
  1029. $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();
  1030.  
  1031. $payment_record_data['student_id'] = $sessionData['student_id'];
  1032. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  1033. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  1034. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  1035. $payment_record_data['service_id'] = 10;
  1036. $payment_record_data['school_id'] = $school->school_id;
  1037. $payment_record_data['academic_year'] = $circularData->academic_year;
  1038. $payment_record_data['program_id'] = $sessionData['program_id'];
  1039. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  1040. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  1041. $payment_record_data['invoice_id'] = $invoiceNum;
  1042. $payment_record_data['paid_amount'] = $amount;
  1043. $payment_record_data['transaction_id'] = $tnx_id;
  1044. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  1045. $payment_record_data['create_date'] = date('Y/m/d');
  1046.  
  1047.  
  1048. $insertId = $this->common_model->save('payment_record', $data);
  1049. if ($insertId <> 0) {
  1050. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  1051. $dataStudentCourse['service_id'] = 10;
  1052. $dataStudentCourse['create_date'] = date('Y/m/d');
  1053. $dataStudentCourse['approval_status'] = 0;
  1054. $dataStudentCourse['payment_record_id'] = $insertId;
  1055.  
  1056. $additional_information = array('year_of_passed' => $sessionData['year_of_passed'], 'exam_name' => $sessionData['exam_name'], 'result' => $sessionData['result']);
  1057.  
  1058. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  1059.  
  1060. $this->common_model->save('service_application_form', $dataStudentCourse);
  1061.  
  1062.  
  1063. //For Email and sms
  1064. $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();
  1065. $this->email($email_id->email, 'You have successfully requested for Duplicate Main Certificate Service at Bangladesh Open University');
  1066.  
  1067. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Duplicate Main Certificate Service at Bangladesh Open University");
  1068.  
  1069. $successData['amount'] = $sessionData['amount_with_tax'];
  1070. $successData['service_name'] = $sessionData['service_name'];
  1071. $this->load->view('success_payment', $successData);
  1072.  
  1073.  
  1074. $this->session->unset_userdata('duplicate_main_applyInvoiceId' . $invoiceNum);
  1075. }
  1076. }
  1077. }
  1078. }else{
  1079.  
  1080.  
  1081. // if($_GET['status']=='success'){
  1082. // $amount = round(intval($this->session->userdata($invoice)['amount'])+((intval($this->session->userdata($invoice)['amount'])*1.8)/100));
  1083.  
  1084. // $this->session->sess_destroy();
  1085. //echo '<pre>',print_r($this->session->all_userdata()),'</pre>';
  1086.  
  1087. //echo count($this->session->userdata('registrationData'.$invoiceNum));
  1088.  
  1089. /*echo '<pre>',print_r($this->session->all_userdata()),'</pre>';
  1090. exit;*/
  1091. $invoiceNum = filter_var($invoice, FILTER_SANITIZE_NUMBER_INT);
  1092.  
  1093. if (count($this->session->userdata('courseEnrollmentInvoiceId' . $invoiceNum)) > 1) {
  1094.  
  1095. $sessionData = $this->session->userdata($invoice);
  1096.  
  1097. // amount check //
  1098.  
  1099. // if(!($sessionData['amount_with_tax']>=$sessionData['amount']))
  1100. // {
  1101. // echo 'invalid amount request not accepted, sorry please try again';
  1102. // exit;
  1103. // }
  1104. //
  1105.  
  1106. /*$data['student_id'] = $sessionData['student_id'];
  1107. // $data['service_id'] = '2';
  1108. $data['program_id'] = $sessionData['program_id'];
  1109. $data['program_group_id'] = $sessionData['group_id'];
  1110. $data['program_circular_id'] = $sessionData['circular_id'];
  1111. $data['invoice_id'] = $invoiceNum;
  1112. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  1113. $data['paid_amount'] = $sessionData['amount'];
  1114. $data['transaction_id'] = $sessionData['transation_id'];
  1115. $data['payment_method'] = $sessionData['payment_method'];
  1116. $data['create_date'] = date('Y/m/d');*/
  1117.  
  1118.  
  1119. $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();
  1120.  
  1121. $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();
  1122.  
  1123. $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();
  1124.  
  1125. $payment_record_data['student_id'] = $sessionData['student_id'];
  1126. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  1127. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  1128. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  1129. $payment_record_data['service_id'] = 17;
  1130. $payment_record_data['school_id'] = $school->school_id;
  1131. if ($sessionData['circular_id'] == 37) {
  1132. $payment_record_data['academic_year'] = 2019;
  1133. $payment_record_data['program_circular_id'] = 59;
  1134. } else {
  1135. $payment_record_data['academic_year'] = $circularData->academic_year;
  1136. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  1137. }
  1138. if ($sessionData['circular_id'] == 35) {
  1139. $payment_record_data['semester'] = 2;
  1140. }
  1141. if ($sessionData['circular_id'] == 57) {
  1142. $payment_record_data['semester'] = 2;
  1143. }
  1144.  
  1145. // $payment_record_data['academic_year'] = $circularData->academic_year;
  1146. // $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  1147. $payment_record_data['program_id'] = $sessionData['program_id'];
  1148. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  1149. $payment_record_data['invoice_id'] = $invoiceNum;
  1150. $payment_record_data['paid_amount'] = $sessionData['amount'];
  1151. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  1152. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  1153. $payment_record_data['create_date'] = date('Y/m/d');
  1154.  
  1155.  
  1156. /*echo '<pre>';
  1157. print_r($payment_record_data);
  1158. echo '</pre>';
  1159. exit;*/
  1160.  
  1161. $insertId = $this->common_model->save('payment_record', $payment_record_data);
  1162. if ($insertId <> 0) {
  1163. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  1164. $dataStudentCourse['courses_id'] = $sessionData['checkedCourses'];
  1165. $dataStudentCourse['payment_record_id'] = $insertId;
  1166. $dataStudentCourse['term_year'] = $this->session->userdata('admission_for' . ($sessionData['student_id'] - 1));
  1167. $dataStudentCourse['application_date'] = date('Y') . '-' . date('m') . '-' . date('d');
  1168. $dataStudentCourse['course_enrollment'] = 1;
  1169.  
  1170. $this->common_model->save('student_course_info', $dataStudentCourse);
  1171.  
  1172. //For Email and sms
  1173. $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();
  1174. $this->email($email_id->email, 'You have successfully requested for Course Enrollment at Bangladesh Open University');
  1175.  
  1176. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Course Enrollment at Bangladesh Open University");
  1177.  
  1178.  
  1179. $successData['amount'] = $sessionData['amount_with_tax'];
  1180. $successData['service_name'] = $sessionData['service_name'];
  1181.  
  1182. $this->load->view('success_payment', $successData);
  1183.  
  1184. $this->session->unset_userdata('courseEnrollmentInvoiceId' . $invoiceNum);
  1185. }
  1186.  
  1187. // echo '<pre>';
  1188. // print_r($sessionData);
  1189. // echo '</pre>';
  1190. // echo '<pre>',print_r($this->session->all_userdata()),'</pre>';
  1191. } elseif (count($this->session->userdata('registrationData' . $invoiceNum)) > 1) {
  1192. /*echo '<pre>',print_r($this->session->all_userdata()),'</pre>';
  1193. exit;*/
  1194. $sessionAllData = $this->session->userdata('registrationData' . $invoiceNum);
  1195.  
  1196.  
  1197. $data['student_name_bangla'] = $sessionAllData['student_name_bangla'];
  1198. $data['student_name_english'] = $sessionAllData['student_name_english'];
  1199. $data['fathers_name_bangla'] = $sessionAllData['fathers_name_bangla'];
  1200. $data['fathers_name_english'] = $sessionAllData['fathers_name_english'];
  1201. $data['mothers_name_bangla'] = $sessionAllData['mothers_name_bangla'];
  1202. $data['mothers_name_english'] = $sessionAllData['mothers_name_english'];
  1203. $data['photo'] = $sessionAllData['photo'];
  1204. $data['signature'] = $sessionAllData['signature'];
  1205. $data['legal_guardian_name'] = $sessionAllData['legal_guardian_name'];
  1206. $data['date_of_birth'] = strtotime($sessionAllData['date_of_birth']);
  1207. $data['place_of_birth'] = $sessionAllData['place_of_birth'];
  1208. $data['marital_status'] = $sessionAllData['marital_status'];
  1209. $data['gender'] = $sessionAllData['gender'];
  1210. $data['quota_id'] = $sessionAllData['quota_id'];
  1211. $data['national_id'] = $sessionAllData['national_id'];
  1212. $data['nationality'] = $sessionAllData['nationality'];
  1213. $data['present_village'] = $sessionAllData['present_village'];
  1214. $data['present_post_office'] = $sessionAllData['present_post_office'];
  1215. $data['present_post_code'] = $sessionAllData['present_post_code'];
  1216. $data['present_district_id'] = $sessionAllData['present_district_id'];
  1217. $data['present_upazilla_id'] = $sessionAllData['present_upazilla_id'];
  1218. $data['permanent_village'] = $sessionAllData['permanent_village'];
  1219. $data['permanent_post_office'] = $sessionAllData['permanent_post_office'];
  1220. $data['permanent_post_code'] = $sessionAllData['permanent_post_code'];
  1221. $data['permanent_district_id'] = $sessionAllData['permanent_district_id'];
  1222. $data['permanent_upazilla_id'] = $sessionAllData['permanent_upazilla_id'];
  1223. $data['quota_id'] = $sessionAllData['quota_id'];
  1224. $data['mobile_number'] = $sessionAllData['mobile_number'];
  1225. $data['email'] = $sessionAllData['email'];
  1226. $data['job_experience'] = $sessionAllData['job_experience'];
  1227. $data['blood_group'] = $sessionAllData['blood_group'];
  1228. $data['direct_admissionCheck'] = $sessionAllData['direct_admissionCheck'];
  1229. // $data['academic_history'] = $this->session->userdata('academic_history'.$invoiceNum);
  1230. /*echo '<pre>',print_r($data),'</pre>';
  1231. exit;*/
  1232.  
  1233. $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();
  1234.  
  1235. $data['academic_history'] = $academic_history->academic_history;
  1236. $data['additional_documents_name'] = $academic_history->additional_documents_name;
  1237. $data['additional_documents_file_location'] = $academic_history->additional_documents_file_location;
  1238.  
  1239. $explodeAdmissionFor = explode('#', $sessionAllData['admission_for']);
  1240. if (count($explodeAdmissionFor) > 0) {
  1241. if ($explodeAdmissionFor[1] == 'semester')
  1242. $admissionFor = $explodeAdmissionFor[0] . '#semister';
  1243. else
  1244. $admissionFor = $sessionAllData['admission_for'];
  1245. } else {
  1246. $admissionFor = $sessionAllData['admission_for'];
  1247. }
  1248. $data['admission_for'] = $admissionFor;
  1249. $this->db->insert('user_student', $data);
  1250. $id = mysqli_insert_id();
  1251.  
  1252. if ($id <> 0 && $id <> '') {
  1253. //admission data in session
  1254. $sessionData2['admission_for' . $id] = $sessionAllData['admission_for'];
  1255. $this->session->set_userdata($sessionData2);
  1256. //end admission data in session
  1257.  
  1258. //program info
  1259. $password = $this->common_model->get_password(6);
  1260. $data1['user_student_id'] = $id;
  1261. $data1['program_circular_id'] = $sessionAllData['program_circular_id'];
  1262. $data1['program_study_center_id'] = $sessionAllData['program_study_center_id'];
  1263. $data1['test_venue'] = $sessionAllData['test_venue'];
  1264. $data1['program_group_id'] = $sessionAllData['program_group_id'];
  1265. $data1['application_date'] = strtotime(date("m/d/Y H:i:s", time()));
  1266. $data1['student_id'] = $id;
  1267. $data1['password'] = md5($password);
  1268. $data1['student_activity_status'] = 1;
  1269.  
  1270. $this->db->insert('program_student_information', $data1);
  1271. $id2 = mysqli_insert_id();
  1272. //email_for_temporary_id
  1273. //sms_for_temporary_id
  1274. $email = $sessionAllData['email'];
  1275. $mobile_no = $sessionAllData['mobile_number'];
  1276.  
  1277. $this->communication_model->email_for_temporary_id($email, $id2, $password);
  1278. $this->communication_model->sms_for_temporary_id($mobile_no, $id2, $password);
  1279.  
  1280. $data2['user_id'] = $id2;
  1281. $data2['user_type'] = 'student';
  1282. $data2['ip'] = $this->common_model->get_ip();
  1283. $data2['login_time'] = strtotime(date("m/d/Y H:i:s", time()));
  1284. $this->db->insert('security_user_session', $data2);
  1285. $session_id = mysqli_insert_id();
  1286.  
  1287. $this->session->set_userdata('student', '1');
  1288. $this->session->set_userdata('security_user_session_id', $session_id);
  1289. $this->session->set_userdata('program_student_information_id', $id2);
  1290.  
  1291.  
  1292. $circularData = $this->common_model->get_fixed_data('program_id,degree_group_id,academic_year', 'program_circular_id', $sessionAllData['program_circular_id'], 'program_circular');
  1293.  
  1294. $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();
  1295.  
  1296. //$school = $this->db->select('school.school_id')->from('program')->join('school','program.school_id=school.school_id')->get()->row();
  1297. $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();
  1298.  
  1299. $payment_record_data['student_id'] = $id2;
  1300. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  1301. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  1302. $payment_record_data['program_study_center_id'] = $sessionAllData['program_study_center_id'];
  1303. $payment_record_data['service_id'] = 16;
  1304. $payment_record_data['school_id'] = $school->school_id;
  1305. $payment_record_data['academic_year'] = $circularData[0]->academic_year;
  1306. $payment_record_data['program_id'] = $circularData[0]->program_id;
  1307. $payment_record_data['program_group_id'] = $circularData[0]->degree_group_id;
  1308. $payment_record_data['program_circular_id'] = $sessionAllData['program_circular_id'];
  1309. $payment_record_data['invoice_id'] = $invoiceNum;
  1310. // $payment_record_data['paid_amount'] = $sessionAllData['amount_with_tax'];
  1311. $payment_record_data['paid_amount'] = $sessionAllData['amount'];
  1312. $payment_record_data['transaction_id'] = $sessionAllData['transation_id'];
  1313. $payment_record_data['payment_method'] = $sessionAllData['payment_method'];
  1314. $payment_record_data['create_date'] = date('Y/m/d');
  1315.  
  1316. $insertId = $this->common_model->save('payment_record', $payment_record_data);
  1317.  
  1318. if ($insertId <> 0) {
  1319. $this->session->unset_userdata('registrationData' . $invoiceNum);
  1320. // $this->session->unset_userdata('academic_history'.$invoiceNum);
  1321. redirect(base_url() . 'student/student_private', 'refresh');
  1322. }
  1323. //redirect(base_url() . 'student/student_private/course_fee' , 'refresh');
  1324. } else {
  1325. echo 'sorry something is wrong please try again ';
  1326. }
  1327. } elseif (count($this->session->userdata('reExamInvoiceId' . $invoiceNum)) > 1) {
  1328. // echo '<pre>';
  1329. // print_r($this->session->userdata('reExamInvoiceId'.$invoice));
  1330. // echo '</pre>';
  1331. $sessionData = $this->session->userdata('reExamInvoiceId' . $invoiceNum);
  1332.  
  1333. /*$data['student_id'] = $sessionData['student_id'];
  1334. $data['service_id'] = '3';
  1335. $data['program_id'] = $sessionData['program_id'];
  1336. $data['program_group_id'] = $sessionData['group_id'];
  1337. $data['program_circular_id'] = $sessionData['circular_id'];
  1338. $data['invoice_id'] = $invoiceNum;
  1339. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  1340. $data['paid_amount'] = $sessionData['amount'];
  1341. $data['transaction_id'] = $sessionData['transation_id'];
  1342. $data['payment_method'] = $sessionData['payment_method'];
  1343. $data['create_date'] = date('Y/m/d');*/
  1344.  
  1345.  
  1346. $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();
  1347.  
  1348. $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();
  1349.  
  1350. $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();
  1351.  
  1352. $payment_record_data['student_id'] = $sessionData['student_id'];
  1353. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  1354. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  1355. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  1356. $payment_record_data['service_id'] = 3;
  1357. $payment_record_data['school_id'] = $school->school_id;
  1358. $payment_record_data['academic_year'] = $circularData->academic_year;
  1359. $payment_record_data['program_id'] = $sessionData['program_id'];
  1360. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  1361. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  1362. $payment_record_data['invoice_id'] = $invoiceNum;
  1363. $payment_record_data['paid_amount'] = $sessionData['amount'];
  1364. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  1365. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  1366. $payment_record_data['create_date'] = date('Y/m/d');
  1367.  
  1368.  
  1369. $insertId = $this->common_model->save('payment_record', $data);
  1370. if ($insertId <> 0) {
  1371. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  1372. $dataStudentCourse['service_id'] = 3;
  1373. $dataStudentCourse['create_date'] = date('Y/m/d');
  1374. $dataStudentCourse['approval_status'] = 0;
  1375. $dataStudentCourse['payment_record_id'] = $insertId;
  1376.  
  1377. $additional_information = array('courses' => $sessionData['checkedCourses']);
  1378.  
  1379. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  1380.  
  1381. $this->common_model->save('service_application_form', $dataStudentCourse);
  1382.  
  1383.  
  1384. //For Email and sms
  1385. $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();
  1386. $this->email($email_id->email, 'You have successfully requested for Re-exam Service at Bangladesh Open University');
  1387. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Re-exam Service at Bangladesh Open University");
  1388.  
  1389.  
  1390. $successData['amount'] = $sessionData['amount_with_tax'];
  1391. $successData['service_name'] = $sessionData['service_name'];
  1392.  
  1393. $this->load->view('success_payment', $successData);
  1394.  
  1395. $this->session->unset_userdata('reExamInvoiceId' . $invoiceNum);
  1396. }
  1397. } elseif (count($this->session->userdata('testimonialInvoiceId' . $invoiceNum)) > 1) {
  1398. $sessionData = $this->session->userdata('testimonialInvoiceId' . $invoiceNum);
  1399.  
  1400. /*$data['student_id'] = $sessionData['student_id'];
  1401. $data['service_id'] = 4;
  1402. $data['program_id'] = $sessionData['program_id'];
  1403. $data['program_group_id'] = $sessionData['group_id'];
  1404. $data['program_circular_id'] = $sessionData['circular_id'];
  1405. $data['invoice_id'] = $invoiceNum;
  1406. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  1407. $data['paid_amount'] = $sessionData['amount'];
  1408. $data['transaction_id'] = $sessionData['transation_id'];
  1409. $data['payment_method'] = $sessionData['payment_method'];
  1410. $data['create_date'] = date('Y/m/d');*/
  1411.  
  1412.  
  1413. $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();
  1414.  
  1415. $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();
  1416.  
  1417. $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();
  1418.  
  1419. $payment_record_data['student_id'] = $sessionData['student_id'];
  1420. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  1421. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  1422. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  1423. $payment_record_data['service_id'] = 4;
  1424. $payment_record_data['school_id'] = $school->school_id;
  1425. $payment_record_data['academic_year'] = $circularData->academic_year;
  1426. $payment_record_data['program_id'] = $sessionData['program_id'];
  1427. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  1428. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  1429. $payment_record_data['invoice_id'] = $invoiceNum;
  1430. $payment_record_data['paid_amount'] = $sessionData['amount'];
  1431. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  1432. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  1433. $payment_record_data['create_date'] = date('Y/m/d');
  1434.  
  1435.  
  1436. $insertId = $this->common_model->save('payment_record', $payment_record_data);
  1437. if ($insertId <> 0) {
  1438. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  1439. $dataStudentCourse['service_id'] = 4;
  1440. $dataStudentCourse['create_date'] = date('Y/m/d');
  1441. $dataStudentCourse['approval_status'] = 0;
  1442. $dataStudentCourse['payment_record_id'] = $insertId;
  1443.  
  1444. $additional_information = array('gpa' => $sessionData['gpa'], 'year_of_passed' => $sessionData['year_of_passed']);
  1445.  
  1446. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  1447.  
  1448. /*echo '<pre>';
  1449. print_r($dataStudentCourse);
  1450. echo '</pre>';
  1451. exit;*/
  1452.  
  1453. $this->common_model->save('service_application_form', $dataStudentCourse);
  1454.  
  1455. //For Email and sms
  1456. $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();
  1457. $this->email($email_id->email, 'You have successfully requested for Testimonial Service at Bangladesh Open University');
  1458.  
  1459. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Testimonial Service at Bangladesh Open University");
  1460.  
  1461.  
  1462. $successData['amount'] = $sessionData['amount_with_tax'];
  1463. $successData['service_name'] = $sessionData['service_name'];
  1464.  
  1465. $this->load->view('success_payment', $successData);
  1466.  
  1467. $this->session->unset_userdata('testimonialInvoiceId' . $invoiceNum);
  1468. }
  1469. } elseif (count($this->session->userdata('provisional_certificateInvoiceId' . $invoiceNum)) > 1) {
  1470. $sessionData = $this->session->userdata('provisional_certificateInvoiceId' . $invoiceNum);
  1471.  
  1472. /*$data['student_id'] = $sessionData['student_id'];
  1473. $data['service_id'] = 6;
  1474. $data['program_id'] = $sessionData['program_id'];
  1475. $data['program_group_id'] = $sessionData['group_id'];
  1476. $data['program_circular_id'] = $sessionData['circular_id'];
  1477. $data['invoice_id'] = $invoiceNum;
  1478. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  1479. $data['paid_amount'] = $sessionData['amount'];
  1480. $data['transaction_id'] = $sessionData['transation_id'];
  1481. $data['payment_method'] = $sessionData['payment_method'];
  1482. $data['create_date'] = date('Y/m/d');*/
  1483.  
  1484.  
  1485. $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();
  1486.  
  1487. $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();
  1488.  
  1489. $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();
  1490.  
  1491. $payment_record_data['student_id'] = $sessionData['student_id'];
  1492. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  1493. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  1494. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  1495. $payment_record_data['service_id'] = 6;
  1496. $payment_record_data['school_id'] = $school->school_id;
  1497. $payment_record_data['academic_year'] = $circularData->academic_year;
  1498. $payment_record_data['program_id'] = $sessionData['program_id'];
  1499. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  1500. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  1501. $payment_record_data['invoice_id'] = $invoiceNum;
  1502. $payment_record_data['paid_amount'] = $sessionData['amount'];
  1503. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  1504. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  1505. $payment_record_data['create_date'] = date('Y/m/d');
  1506.  
  1507.  
  1508. $insertId = $this->common_model->save('payment_record', $data);
  1509. if ($insertId <> 0) {
  1510. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  1511. $dataStudentCourse['service_id'] = 6;
  1512. $dataStudentCourse['create_date'] = date('Y/m/d');
  1513. $dataStudentCourse['approval_status'] = 0;
  1514. $dataStudentCourse['payment_record_id'] = $insertId;
  1515.  
  1516. $additional_information = array('year_of_passed' => $sessionData['year_of_passed'], 'exam_name' => $sessionData['exam_name'], 'result' => $sessionData['result']);
  1517.  
  1518. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  1519.  
  1520. $this->common_model->save('service_application_form', $dataStudentCourse);
  1521.  
  1522. //For Email and sms
  1523. $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();
  1524. $this->email($email_id->email, 'You have successfully requested for Provisional Certificate Service at Bangladesh Open University');
  1525.  
  1526. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Provisional Certificate Service at Bangladesh Open University");
  1527.  
  1528.  
  1529. $successData['amount'] = $sessionData['amount_with_tax'];
  1530. $successData['service_name'] = $sessionData['service_name'];
  1531.  
  1532. $this->load->view('success_payment', $successData);
  1533.  
  1534. $this->session->unset_userdata('provisional_certificateInvoiceId' . $invoiceNum);
  1535. }
  1536. } elseif (count($this->session->userdata('convocationInvoiceId' . $invoiceNum)) > 1) {
  1537. $sessionData = $this->session->userdata('convocationInvoiceId' . $invoiceNum);
  1538. $sessionFileData = $this->session->userdata('convocationFileInvoiceId' . $invoiceNum);
  1539.  
  1540. /*$data['student_id'] = $sessionData['student_id'];
  1541. $data['service_id'] = 11;
  1542. $data['program_id'] = $sessionData['program_id'];
  1543. $data['program_group_id'] = $sessionData['group_id'];
  1544. $data['program_circular_id'] = $sessionData['circular_id'];
  1545. $data['invoice_id'] = $invoiceNum;
  1546. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  1547. $data['paid_amount'] = $sessionData['amount'];
  1548. $data['transaction_id'] = $sessionData['transation_id'];
  1549. $data['payment_method'] = $sessionData['payment_method'];
  1550. $data['create_date'] = date('Y/m/d');*/
  1551.  
  1552.  
  1553. $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();
  1554.  
  1555. $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();
  1556.  
  1557. $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();
  1558.  
  1559. $payment_record_data['student_id'] = $sessionData['student_id'];
  1560. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  1561. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  1562. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  1563. $payment_record_data['service_id'] = 11;
  1564. $payment_record_data['school_id'] = $school->school_id;
  1565. $payment_record_data['academic_year'] = $circularData->academic_year;
  1566. $payment_record_data['program_id'] = $sessionData['program_id'];
  1567. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  1568. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  1569. $payment_record_data['invoice_id'] = $invoiceNum;
  1570. $payment_record_data['paid_amount'] = $sessionData['amount'];
  1571. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  1572. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  1573. $payment_record_data['create_date'] = date('Y/m/d');
  1574.  
  1575.  
  1576. $insertId = $this->common_model->save('payment_record', $data);
  1577. if ($insertId <> 0) {
  1578. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  1579. $dataStudentCourse['service_id'] = 11;
  1580. $dataStudentCourse['create_date'] = date('Y/m/d');
  1581. $dataStudentCourse['approval_status'] = 0;
  1582. $dataStudentCourse['payment_record_id'] = $insertId;
  1583.  
  1584. $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]);
  1585.  
  1586. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  1587.  
  1588. $this->common_model->save('service_application_form', $dataStudentCourse);
  1589.  
  1590. //For Email and sms
  1591. $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();
  1592. $this->email($email_id->email, 'You have successfully requested for Convocation Service at Bangladesh Open University');
  1593.  
  1594. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Convocation Service at Bangladesh Open University");
  1595.  
  1596.  
  1597. $successData['amount'] = $sessionData['amount_with_tax'];
  1598. $successData['service_name'] = $sessionData['service_name'];
  1599. $this->load->view('success_payment', $successData);
  1600.  
  1601. $this->session->unset_userdata('convocationInvoiceId' . $invoiceNum);
  1602. $this->session->unset_userdata('convocationFileInvoiceId' . $invoiceNum);
  1603. }
  1604. } elseif (count($this->session->userdata('name_correctionInvoiceId' . $invoiceNum)) > 1) {
  1605. $sessionData = $this->session->userdata('name_correctionInvoiceId' . $invoiceNum);
  1606. $sessionFileData = $this->session->userdata('name_correctionFileInvoiceId' . $invoiceNum);
  1607.  
  1608. /*$data['student_id'] = $sessionData['student_id'];
  1609. $data['service_id'] = 12;
  1610. $data['program_id'] = $sessionData['program_id'];
  1611. $data['program_group_id'] = $sessionData['group_id'];
  1612. $data['program_circular_id'] = $sessionData['circular_id'];
  1613. $data['invoice_id'] = $invoiceNum;
  1614. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  1615. $data['paid_amount'] = $sessionData['amount'];
  1616. $data['transaction_id'] = $sessionData['transation_id'];
  1617. $data['payment_method'] = $sessionData['payment_method'];
  1618. $data['create_date'] = date('Y/m/d');*/
  1619.  
  1620.  
  1621. $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();
  1622.  
  1623. $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();
  1624.  
  1625. $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();
  1626.  
  1627. $payment_record_data['student_id'] = $sessionData['student_id'];
  1628. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  1629. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  1630. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  1631. $payment_record_data['service_id'] = 12;
  1632. $payment_record_data['school_id'] = $school->school_id;
  1633. $payment_record_data['academic_year'] = $circularData->academic_year;
  1634. $payment_record_data['program_id'] = $sessionData['program_id'];
  1635. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  1636. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  1637. $payment_record_data['invoice_id'] = $invoiceNum;
  1638. $payment_record_data['paid_amount'] = $sessionData['amount'];
  1639. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  1640. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  1641. $payment_record_data['create_date'] = date('Y/m/d');
  1642.  
  1643.  
  1644. $insertId = $this->common_model->save('payment_record', $data);
  1645. if ($insertId <> 0) {
  1646. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  1647. $dataStudentCourse['service_id'] = 12;
  1648. $dataStudentCourse['create_date'] = date('Y/m/d');
  1649. $dataStudentCourse['approval_status'] = 0;
  1650. $dataStudentCourse['payment_record_id'] = $insertId;
  1651.  
  1652. $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]);
  1653.  
  1654. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  1655.  
  1656. $this->common_model->save('service_application_form', $dataStudentCourse);
  1657.  
  1658. //For Email and sms
  1659. $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();
  1660. $this->email($email_id->email, 'You have successfully requested for Name Correction Service at Bangladesh Open University');
  1661.  
  1662. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Name Correction Service at Bangladesh Open University");
  1663.  
  1664.  
  1665. $successData['amount'] = $sessionData['amount_with_tax'];
  1666. $successData['service_name'] = $sessionData['service_name'];
  1667. $this->load->view('success_payment', $successData);
  1668.  
  1669. $this->session->unset_userdata('name_correctionInvoiceId' . $invoiceNum);
  1670. $this->session->unset_userdata('name_correctionFileInvoiceId' . $invoiceNum);
  1671. }
  1672. } elseif (count($this->session->userdata('migrationInvoiceId' . $invoiceNum)) > 1) {
  1673. $sessionData = $this->session->userdata('migrationInvoiceId' . $invoiceNum);
  1674.  
  1675. /*$data['student_id'] = $sessionData['student_id'];
  1676. $data['service_id'] = 14;
  1677. $data['program_id'] = $sessionData['program_id'];
  1678. $data['program_group_id'] = $sessionData['group_id'];
  1679. $data['program_circular_id'] = $sessionData['circular_id'];
  1680. $data['invoice_id'] = $invoiceNum;
  1681. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  1682. $data['paid_amount'] = $sessionData['amount'];
  1683. $data['transaction_id'] = $sessionData['transation_id'];
  1684. $data['payment_method'] = $sessionData['payment_method'];
  1685. $data['create_date'] = date('Y/m/d');*/
  1686.  
  1687.  
  1688. $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();
  1689.  
  1690. $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();
  1691.  
  1692. $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();
  1693.  
  1694. $payment_record_data['student_id'] = $sessionData['student_id'];
  1695. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  1696. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  1697. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  1698. $payment_record_data['service_id'] = 14;
  1699. $payment_record_data['school_id'] = $school->school_id;
  1700. $payment_record_data['academic_year'] = $circularData->academic_year;
  1701. $payment_record_data['program_id'] = $sessionData['program_id'];
  1702. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  1703. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  1704. $payment_record_data['invoice_id'] = $invoiceNum;
  1705. $payment_record_data['paid_amount'] = $sessionData['amount'];
  1706. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  1707. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  1708. $payment_record_data['create_date'] = date('Y/m/d');
  1709.  
  1710.  
  1711. $insertId = $this->common_model->save('payment_record', $data);
  1712. if ($insertId <> 0) {
  1713. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  1714. $dataStudentCourse['service_id'] = 14;
  1715. $dataStudentCourse['create_date'] = date('Y/m/d');
  1716. $dataStudentCourse['approval_status'] = 0;
  1717. $dataStudentCourse['payment_record_id'] = $insertId;
  1718.  
  1719. $additional_information = array('exam_you_have_passed' => $sessionData['exam_you_have_passed'], 'which_date' => $sessionData['which_date'], 'reason_of_leave' => $sessionData['reason_of_leave']);
  1720.  
  1721. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  1722.  
  1723. $this->common_model->save('service_application_form', $dataStudentCourse);
  1724.  
  1725. //For Email and sms
  1726. $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();
  1727. $this->email($email_id->email, 'You have successfully requested for Migration Service at Bangladesh Open University');
  1728.  
  1729. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Migration Service at Bangladesh Open University");
  1730.  
  1731.  
  1732. $successData['amount'] = $sessionData['amount_with_tax'];
  1733. $successData['service_name'] = $sessionData['service_name'];
  1734. $this->load->view('success_payment', $successData);
  1735.  
  1736.  
  1737. $this->session->unset_userdata('migrationInvoiceId' . $invoiceNum);
  1738. }
  1739. } elseif (count($this->session->userdata('study_centerInvoiceId' . $invoiceNum)) > 1) {
  1740. $sessionData = $this->session->userdata('study_centerInvoiceId' . $invoiceNum);
  1741.  
  1742. /*$data['student_id'] = $sessionData['student_id'];
  1743. $data['service_id'] = 13;
  1744. $data['program_id'] = $sessionData['program_id'];
  1745. $data['program_group_id'] = $sessionData['group_id'];
  1746. $data['program_circular_id'] = $sessionData['circular_id'];
  1747. $data['invoice_id'] = $invoiceNum;
  1748. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  1749. $data['paid_amount'] = $sessionData['amount'];
  1750. $data['transaction_id'] = $sessionData['transation_id'];
  1751. $data['payment_method'] = $sessionData['payment_method'];
  1752. $data['create_date'] = date('Y/m/d');*/
  1753.  
  1754.  
  1755. $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();
  1756.  
  1757. $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();
  1758.  
  1759. $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();
  1760.  
  1761. $payment_record_data['student_id'] = $sessionData['student_id'];
  1762. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  1763. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  1764. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  1765. $payment_record_data['service_id'] = 13;
  1766. $payment_record_data['school_id'] = $school->school_id;
  1767. $payment_record_data['academic_year'] = $circularData->academic_year;
  1768. $payment_record_data['program_id'] = $sessionData['program_id'];
  1769. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  1770. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  1771. $payment_record_data['invoice_id'] = $invoiceNum;
  1772. $payment_record_data['paid_amount'] = $sessionData['amount'];
  1773. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  1774. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  1775. $payment_record_data['create_date'] = date('Y/m/d');
  1776.  
  1777.  
  1778. $insertId = $this->common_model->save('payment_record', $data);
  1779. if ($insertId <> 0) {
  1780. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  1781. $dataStudentCourse['service_id'] = 13;
  1782. $dataStudentCourse['create_date'] = date('Y/m/d');
  1783. $dataStudentCourse['approval_status'] = 0;
  1784. $dataStudentCourse['payment_record_id'] = $insertId;
  1785.  
  1786. $additional_information = array('exam_name' => $sessionData['exam_name'], 'study_center' => $sessionData['study_center'], 'reason_of_transfer' => $sessionData['reason_of_transfer']);
  1787.  
  1788. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  1789.  
  1790. $this->common_model->save('service_application_form', $dataStudentCourse);
  1791.  
  1792. //For Email and sms
  1793. $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();
  1794. $this->email($email_id->email, 'You have successfully requested for Study Center Transfer Service at Bangladesh Open University');
  1795.  
  1796. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Study Center Transfer Service at Bangladesh Open University");
  1797.  
  1798.  
  1799. $successData['amount'] = $sessionData['amount_with_tax'];
  1800. $successData['service_name'] = $sessionData['service_name'];
  1801. $this->load->view('success_payment', $successData);
  1802.  
  1803.  
  1804. $this->session->unset_userdata('study_centerInvoiceId' . $invoiceNum);
  1805. }
  1806. } elseif (count($this->session->userdata('ans_script_reevaluation_applyInvoiceId' . $invoiceNum)) > 1) {
  1807. $sessionData = $this->session->userdata('ans_script_reevaluation_applyInvoiceId' . $invoiceNum);
  1808.  
  1809. /*$data['student_id'] = $sessionData['student_id'];
  1810. $data['service_id'] = 5;
  1811. $data['program_id'] = $sessionData['program_id'];
  1812. $data['program_group_id'] = $sessionData['group_id'];
  1813. $data['program_circular_id'] = $sessionData['circular_id'];
  1814. $data['invoice_id'] = $invoiceNum;
  1815. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  1816. $data['paid_amount'] = $sessionData['amount'];
  1817. $data['transaction_id'] = $sessionData['transation_id'];
  1818. $data['payment_method'] = $sessionData['payment_method'];
  1819. $data['create_date'] = date('Y/m/d');*/
  1820.  
  1821.  
  1822. $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();
  1823.  
  1824. $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();
  1825.  
  1826. $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();
  1827.  
  1828. $payment_record_data['student_id'] = $sessionData['student_id'];
  1829. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  1830. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  1831. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  1832. $payment_record_data['service_id'] = 5;
  1833. $payment_record_data['school_id'] = $school->school_id;
  1834. $payment_record_data['academic_year'] = $circularData->academic_year;
  1835. $payment_record_data['program_id'] = $sessionData['program_id'];
  1836. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  1837. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  1838. $payment_record_data['invoice_id'] = $invoiceNum;
  1839. $payment_record_data['paid_amount'] = $sessionData['amount'];
  1840. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  1841. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  1842. $payment_record_data['create_date'] = date('Y/m/d');
  1843.  
  1844.  
  1845. $insertId = $this->common_model->save('payment_record', $data);
  1846. if ($insertId <> 0) {
  1847. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  1848. $dataStudentCourse['service_id'] = 5;
  1849. $dataStudentCourse['create_date'] = date('Y/m/d');
  1850. $dataStudentCourse['approval_status'] = 0;
  1851. $dataStudentCourse['payment_record_id'] = $insertId;
  1852.  
  1853. /*Cause*/
  1854. $cause = array_filter($sessionData['cause']);
  1855. $causeArr = array();
  1856. for ($i = 0; $i < count($cause); $i++) {
  1857. $causeArr[] = $cause[$i];
  1858. }
  1859. /*Cause*/
  1860.  
  1861. $additional_information = array('exam_hall' => $sessionData['exam_hall'], 'semister' => $sessionData['semister'], 'exam_year' => $sessionData['exam_year'], 'courses' => $sessionData['checkedCourses'], 'cause' => $causeArr);
  1862.  
  1863. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  1864.  
  1865. $this->common_model->save('service_application_form', $dataStudentCourse);
  1866.  
  1867. //For Email and sms
  1868. $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();
  1869. $this->email($email_id->email, 'You have successfully requested for Answer Script Re-evaluation Service at Bangladesh Open University');
  1870.  
  1871. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Answer Script Re-evaluation Service at Bangladesh Open University");
  1872.  
  1873.  
  1874. $successData['amount'] = $sessionData['amount_with_tax'];
  1875. $successData['service_name'] = $sessionData['service_name'];
  1876. $this->load->view('success_payment', $successData);
  1877.  
  1878.  
  1879. $this->session->unset_userdata('ans_script_reevaluation_applyInvoiceId' . $invoiceNum);
  1880. }
  1881. } elseif (count($this->session->userdata('main_certificateInvoiceId' . $invoiceNum)) > 1) {
  1882. $sessionData = $this->session->userdata('main_certificateInvoiceId' . $invoiceNum);
  1883.  
  1884. /*$data['student_id'] = $sessionData['student_id'];
  1885. $data['service_id'] = 7;
  1886. $data['program_id'] = $sessionData['program_id'];
  1887. $data['program_group_id'] = $sessionData['group_id'];
  1888. $data['program_circular_id'] = $sessionData['circular_id'];
  1889. $data['invoice_id'] = $invoiceNum;
  1890. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  1891. $data['paid_amount'] = $sessionData['amount'];
  1892. $data['transaction_id'] = $sessionData['transation_id'];
  1893. $data['payment_method'] = $sessionData['payment_method'];
  1894. $data['create_date'] = date('Y/m/d');*/
  1895.  
  1896.  
  1897. $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();
  1898.  
  1899. $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();
  1900.  
  1901. $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();
  1902.  
  1903. $payment_record_data['student_id'] = $sessionData['student_id'];
  1904. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  1905. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  1906. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  1907. $payment_record_data['service_id'] = 7;
  1908. $payment_record_data['school_id'] = $school->school_id;
  1909. $payment_record_data['academic_year'] = $circularData->academic_year;
  1910. $payment_record_data['program_id'] = $sessionData['program_id'];
  1911. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  1912. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  1913. $payment_record_data['invoice_id'] = $invoiceNum;
  1914. $payment_record_data['paid_amount'] = $sessionData['amount'];
  1915. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  1916. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  1917. $payment_record_data['create_date'] = date('Y/m/d');
  1918.  
  1919.  
  1920. $insertId = $this->common_model->save('payment_record', $data);
  1921. if ($insertId <> 0) {
  1922. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  1923. $dataStudentCourse['service_id'] = 7;
  1924. $dataStudentCourse['create_date'] = date('Y/m/d');
  1925. $dataStudentCourse['approval_status'] = 0;
  1926. $dataStudentCourse['payment_record_id'] = $insertId;
  1927.  
  1928. $additional_information = array('year_of_passed' => $sessionData['year_of_passed'], 'exam_name' => $sessionData['exam_name'], 'result' => $sessionData['result']);
  1929.  
  1930. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  1931.  
  1932. $this->common_model->save('service_application_form', $dataStudentCourse);
  1933.  
  1934. //For Email and sms
  1935. $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();
  1936. $this->email($email_id->email, 'You have successfully requested for Main Certificate Service at Bangladesh Open University');
  1937.  
  1938. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Main Certificate Service at Bangladesh Open University");
  1939.  
  1940.  
  1941. $successData['amount'] = $sessionData['amount_with_tax'];
  1942. $successData['service_name'] = $sessionData['service_name'];
  1943. $this->load->view('success_payment', $successData);
  1944.  
  1945.  
  1946. $this->session->unset_userdata('main_certificateInvoiceId' . $invoiceNum);
  1947. }
  1948. } elseif (count($this->session->userdata('certificate_verificationInvoiceId' . $invoiceNum)) > 1) {
  1949. $sessionData = $this->session->userdata('certificate_verificationInvoiceId' . $invoiceNum);
  1950.  
  1951. /*$data['student_id'] = $sessionData['student_id'];
  1952. $data['service_id'] = 9;
  1953. $data['program_id'] = $sessionData['program_id'];
  1954. $data['program_group_id'] = $sessionData['group_id'];
  1955. $data['program_circular_id'] = $sessionData['circular_id'];
  1956. $data['invoice_id'] = $invoiceNum;
  1957. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  1958. $data['paid_amount'] = $sessionData['amount'];
  1959. $data['transaction_id'] = $sessionData['transation_id'];
  1960. $data['payment_method'] = $sessionData['payment_method'];
  1961. $data['create_date'] = date('Y/m/d');*/
  1962.  
  1963.  
  1964. $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();
  1965.  
  1966. $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();
  1967.  
  1968. $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();
  1969.  
  1970. $payment_record_data['student_id'] = $sessionData['student_id'];
  1971. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  1972. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  1973. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  1974. $payment_record_data['service_id'] = 9;
  1975. $payment_record_data['school_id'] = $school->school_id;
  1976. $payment_record_data['academic_year'] = $circularData->academic_year;
  1977. $payment_record_data['program_id'] = $sessionData['program_id'];
  1978. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  1979. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  1980. $payment_record_data['invoice_id'] = $invoiceNum;
  1981. $payment_record_data['paid_amount'] = $sessionData['amount'];
  1982. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  1983. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  1984. $payment_record_data['create_date'] = date('Y/m/d');
  1985.  
  1986.  
  1987. $insertId = $this->common_model->save('payment_record', $data);
  1988. if ($insertId <> 0) {
  1989. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  1990. $dataStudentCourse['service_id'] = 9;
  1991. $dataStudentCourse['create_date'] = date('Y/m/d');
  1992. $dataStudentCourse['approval_status'] = 0;
  1993. $dataStudentCourse['payment_record_id'] = $insertId;
  1994.  
  1995. $additional_information = array('year_of_passed' => $sessionData['year_of_passed'], 'exam_name' => $sessionData['exam_name'], 'result' => $sessionData['result']);
  1996.  
  1997. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  1998.  
  1999. $this->common_model->save('service_application_form', $dataStudentCourse);
  2000.  
  2001. //For Email and sms
  2002. $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();
  2003. $this->email($email_id->email, 'You have successfully requested for Certificate Verification Service at Bangladesh Open University');
  2004.  
  2005. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Certificate Verification Service at Bangladesh Open University");
  2006.  
  2007.  
  2008. $successData['amount'] = $sessionData['amount_with_tax'];
  2009. $successData['service_name'] = $sessionData['service_name'];
  2010. $this->load->view('success_payment', $successData);
  2011.  
  2012.  
  2013. $this->session->unset_userdata('certificate_verificationInvoiceId' . $invoiceNum);
  2014. }
  2015. } elseif (count($this->session->userdata('duplicate_provisional_applyInvoiceId' . $invoiceNum)) > 1) {
  2016. $sessionData = $this->session->userdata('duplicate_provisional_applyInvoiceId' . $invoiceNum);
  2017.  
  2018. /*$data['student_id'] = $sessionData['student_id'];
  2019. $data['service_id'] = 8;
  2020. $data['program_id'] = $sessionData['program_id'];
  2021. $data['program_group_id'] = $sessionData['group_id'];
  2022. $data['program_circular_id'] = $sessionData['circular_id'];
  2023. $data['invoice_id'] = $invoiceNum;
  2024. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  2025. $data['paid_amount'] = $sessionData['amount'];
  2026. $data['transaction_id'] = $sessionData['transation_id'];
  2027. $data['payment_method'] = $sessionData['payment_method'];
  2028. $data['create_date'] = date('Y/m/d');*/
  2029.  
  2030.  
  2031. $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();
  2032.  
  2033. $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();
  2034.  
  2035. $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();
  2036.  
  2037. $payment_record_data['student_id'] = $sessionData['student_id'];
  2038. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  2039. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  2040. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  2041. $payment_record_data['service_id'] = 8;
  2042. $payment_record_data['school_id'] = $school->school_id;
  2043. $payment_record_data['academic_year'] = $circularData->academic_year;
  2044. $payment_record_data['program_id'] = $sessionData['program_id'];
  2045. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  2046. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  2047. $payment_record_data['invoice_id'] = $invoiceNum;
  2048. $payment_record_data['paid_amount'] = $sessionData['amount'];
  2049. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  2050. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  2051. $payment_record_data['create_date'] = date('Y/m/d');
  2052.  
  2053.  
  2054. $insertId = $this->common_model->save('payment_record', $data);
  2055. if ($insertId <> 0) {
  2056. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  2057. $dataStudentCourse['service_id'] = 8;
  2058. $dataStudentCourse['create_date'] = date('Y/m/d');
  2059. $dataStudentCourse['approval_status'] = 0;
  2060. $dataStudentCourse['payment_record_id'] = $insertId;
  2061.  
  2062. $additional_information = array('year_of_passed' => $sessionData['year_of_passed'], 'exam_name' => $sessionData['exam_name'], 'result' => $sessionData['result']);
  2063.  
  2064. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  2065.  
  2066. $this->common_model->save('service_application_form', $dataStudentCourse);
  2067.  
  2068. //For Email and sms
  2069. $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();
  2070. $this->email($email_id->email, 'You have successfully requested for Duplicate provisional Certificate Service at Bangladesh Open University');
  2071.  
  2072. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Duplicate provisional Certificate Service at Bangladesh Open University");
  2073.  
  2074. $successData['amount'] = $sessionData['amount_with_tax'];
  2075. $successData['service_name'] = $sessionData['service_name'];
  2076. $this->load->view('success_payment', $successData);
  2077.  
  2078.  
  2079. $this->session->unset_userdata('duplicate_provisional_applyInvoiceId' . $invoiceNum);
  2080. }
  2081. } elseif (count($this->session->userdata('duplicate_main_applyInvoiceId' . $invoiceNum)) > 1) {
  2082. $sessionData = $this->session->userdata('duplicate_main_applyInvoiceId' . $invoiceNum);
  2083.  
  2084. /*$data['student_id'] = $sessionData['student_id'];
  2085. $data['service_id'] = 10;
  2086. $data['program_id'] = $sessionData['program_id'];
  2087. $data['program_group_id'] = $sessionData['group_id'];
  2088. $data['program_circular_id'] = $sessionData['circular_id'];
  2089. $data['invoice_id'] = $invoiceNum;
  2090. // $data['paid_amount'] = $sessionData['amount_with_tax'];
  2091. $data['paid_amount'] = $sessionData['amount'];
  2092. $data['transaction_id'] = $sessionData['transation_id'];
  2093. $data['payment_method'] = $sessionData['payment_method'];
  2094. $data['create_date'] = date('Y/m/d');*/
  2095.  
  2096.  
  2097. $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();
  2098.  
  2099. $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();
  2100.  
  2101. $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();
  2102.  
  2103. $payment_record_data['student_id'] = $sessionData['student_id'];
  2104. $payment_record_data['program_rrc_id'] = $rc_src->program_rrc_id;
  2105. $payment_record_data['program_src_id'] = $rc_src->program_src_id;
  2106. $payment_record_data['program_study_center_id'] = $circularData->program_study_center_id;
  2107. $payment_record_data['service_id'] = 10;
  2108. $payment_record_data['school_id'] = $school->school_id;
  2109. $payment_record_data['academic_year'] = $circularData->academic_year;
  2110. $payment_record_data['program_id'] = $sessionData['program_id'];
  2111. $payment_record_data['program_group_id'] = $sessionData['group_id'];
  2112. $payment_record_data['program_circular_id'] = $sessionData['circular_id'];
  2113. $payment_record_data['invoice_id'] = $invoiceNum;
  2114. $payment_record_data['paid_amount'] = $sessionData['amount'];
  2115. $payment_record_data['transaction_id'] = $sessionData['transation_id'];
  2116. $payment_record_data['payment_method'] = $sessionData['payment_method'];
  2117. $payment_record_data['create_date'] = date('Y/m/d');
  2118.  
  2119.  
  2120. $insertId = $this->common_model->save('payment_record', $data);
  2121. if ($insertId <> 0) {
  2122. $dataStudentCourse['student_id'] = $sessionData['student_id'];
  2123. $dataStudentCourse['service_id'] = 10;
  2124. $dataStudentCourse['create_date'] = date('Y/m/d');
  2125. $dataStudentCourse['approval_status'] = 0;
  2126. $dataStudentCourse['payment_record_id'] = $insertId;
  2127.  
  2128. $additional_information = array('year_of_passed' => $sessionData['year_of_passed'], 'exam_name' => $sessionData['exam_name'], 'result' => $sessionData['result']);
  2129.  
  2130. $dataStudentCourse['additional_information'] = json_encode($additional_information);
  2131.  
  2132. $this->common_model->save('service_application_form', $dataStudentCourse);
  2133.  
  2134.  
  2135. //For Email and sms
  2136. $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();
  2137. $this->email($email_id->email, 'You have successfully requested for Duplicate Main Certificate Service at Bangladesh Open University');
  2138.  
  2139. $this->communication_model->sms_for_services($email_id->mobile_number, "You have successfully requested for Duplicate Main Certificate Service at Bangladesh Open University");
  2140.  
  2141. $successData['amount'] = $sessionData['amount_with_tax'];
  2142. $successData['service_name'] = $sessionData['service_name'];
  2143. $this->load->view('success_payment', $successData);
  2144.  
  2145.  
  2146. $this->session->unset_userdata('duplicate_main_applyInvoiceId' . $invoiceNum);
  2147. }
  2148. }
  2149. }
  2150.  
  2151.  
  2152. /*}*/
  2153. }
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!