static function cancelBatchEstimate($id) { return Estimate::where('id', '=', $id)->update('is_cancelled', '1'); }
public function enrollKid2() { $inputs = Input::all(); //return Response::json(array('status'=>'success','inputs'=>$inputs)); $getEstimateDetails = Estimate::where('estimate_master_no', '=', $inputs['estimate_master_no'])->where('is_cancelled', '!=', '1')->where('franchise_id', '=', Session::get('franchiseId'))->get(); //** checking if it is a one batch **// //return Response::json(array('status'=>'success','inputs'=>count($getEstimateDetails))); //return Response::json(array('status'=>'success','inputs'=>$inputs)); if (count($getEstimateDetails) == 1) { if ($inputs['paymentOptionsRadio'] == 'singlepay') { $studentClasses['classId'] = $getEstimateDetails[0]['class_id']; $studentClasses['batchId'] = $getEstimateDetails[0]['batch_id']; $studentClasses['studentId'] = $getEstimateDetails[0]['student_id']; $studentClasses['selected_sessions'] = $getEstimateDetails[0]['no_of_opted_classes']; $studentClasses['seasonId'] = $getEstimateDetails[0]['season_id']; $singleBatchstartDate = Carbon::createFromFormat('Y-m-d', $getEstimateDetails[0]['enroll_start_date']); $studentClasses['enrollment_start_date'] = $getEstimateDetails[0]['enroll_start_date']; $studentClasses['enrollment_end_date'] = $getEstimateDetails[0]['enroll_end_date']; $singleBatchendDate = Carbon::createFromFormat('Y-m-d', $getEstimateDetails[0]['enroll_end_date']); $insertDataToStudentClassTable = StudentClasses::addStudentClass($studentClasses); } elseif ($inputs['paymentOptionsRadio'] == "bipay") { //return Response::json(array('status'=>'success','inputs'=>$inputs)); $studentClasses['classId'] = $getEstimateDetails[0]['class_id']; $studentClasses['batchId'] = $getEstimateDetails[0]['batch_id']; $studentClasses['studentId'] = $getEstimateDetails[0]['student_id']; $studentClasses['seasonId'] = $getEstimateDetails[0]['season_id']; //return Response:: json(array('status'=>'success')); $first_selected_session = 0; $second_selected_session = 0; if ($getEstimateDetails[0]['no_of_opted_classes'] % 2 == 0) { //return Response::json(array('status'=>'success','inputs'=>$inputs)); $first_selected_session = $getEstimateDetails[0]['no_of_opted_classes'] / 2; $second_selected_session = $getEstimateDetails[0]['no_of_opted_classes'] / 2; } else { // return Response::json(array('status'=>'success','inputs'=>$getEstimateDetails[0]['no_of_opted_classes']/2)); $first_selected_session = (int) ($getEstimateDetails[0]['no_of_opted_classes'] / 2); $second_selected_session = (int) ($getEstimateDetails[0]['no_of_opted_classes'] / 2) + 1; } $batch_data = BatchSchedule::where('batch_id', '=', $getEstimateDetails[0]['batch_id'])->where('schedule_date', '>=', $getEstimateDetails[0]['enroll_start_date'])->where('holiday', '!=', 1)->orderBy('id')->take($getEstimateDetails[0]['no_of_opted_classes'])->get(); for ($i = 1; $i <= 2; $i++) { if ($i == 1) { $studentClasses['selected_sessions'] = $first_selected_session; $singleBatchstartDate = Carbon::createFromFormat('Y-m-d', $batch_data[0]['schedule_date']); $studentClasses['enrollment_start_date'] = $batch_data[0]['schedule_date']; $studentClasses['enrollment_end_date'] = $batch_data[$first_selected_session - 1]['schedule_date']; $singleBatchendDate = Carbon::createFromFormat('Y-m-d', $getEstimateDetails[$first_selected_session - 1]['enroll_end_date']); $insertDataToStudentClassTable = StudentClasses::addStudentClass($studentClasses); } else { if ($i == 2) { $studentClasses['selected_sessions'] = $second_selected_session; $studentClasses['enrollment_start_date'] = $batch_data[$first_selected_session]['schedule_date']; $studentClasses['enrollment_end_date'] = $batch_data[count($batch_data) - 1]['schedule_date']; $studentClasses['status'] = 'pending'; $insertDataToStudentClassTable = StudentClasses::addStudentClass($studentClasses); } } } } elseif ($inputs['paymentOptionsRadio'] == "multipay") { } } elseif (count($getEstimateDetails) == 2) { if ($inputs['paymentOptionsRadio'] == "Singlepay") { } elseif ($inputs['paymentOptionsRadio'] == "bipay") { // return Response::json(array('status'=>'success','inputs'=>$inputs)); $batch_data[0] = BatchSchedule::where('batch_id', '=', $getEstimateDetails[0]['batch_id'])->where('schedule_date', '>=', $getEstimateDetails[0]['enroll_start_date'])->where('holiday', '!=', 1)->orderBy('id')->take($getEstimateDetails[0]['no_of_opted_classes'])->get(); $batch_data[1] = BatchSchedule::where('batch_id', '=', $getEstimateDetails[1]['batch_id'])->where('schedule_date', '>=', $getEstimateDetails[1]['enroll_start_date'])->where('holiday', '!=', 1)->orderBy('id')->take($getEstimateDetails[1]['no_of_opted_classes'])->get(); if (((int) $inputs['bipaybatch1availablesession'] + (int) $inputs['bipaybatch2availablesession']) % 2 == 0) { $firstpayment_no = ((int) $inputs['bipaybatch1availablesession'] + (int) $inputs['bipaybatch2availablesession']) / 2; $secondpayment_no = ((int) $inputs['bipaybatch1availablesession'] + (int) $inputs['bipaybatch2availablesession']) / 2; } else { $firstpayment_no = (int) (((int) $inputs['bipaybatch1availablesession'] + (int) $inputs['bipaybatch2availablesession']) / 2); $secondpayment_no = (int) (((int) $inputs['bipaybatch1availablesession'] + (int) $inputs['bipaybatch2availablesession']) / 2) + 1; } if ((int) $getEstimateDetails[0]['no_of_opted_classes'] == $firstpayment_no) { for ($i = 0; $i < 2; $i++) { $studentClasses[$i]['classId'] = $getEstimateDetails[$i]['class_id']; $studentClasses[$i]['batchId'] = $getEstimateDetails[$i]['batch_id']; $studentClasses[$i]['studentId'] = $getEstimateDetails[$i]['student_id']; $studentClasses[$i]['seasonId'] = $getEstimateDetails[$i]['season_id']; $studentClasses[$i]['selected_sessions'] = $getEstimateDetails[$i]['no_of_opted_classes']; if ($i == 0) { $firstBatchStartDate = Carbon::createFromFormat('Y-m-d', $getEstimateDetails[$i]['enroll_start_date']); $firstBatchEndDate = Carbon::createFromFormat('Y-m-d', $getEstimateDetails[$i]['enroll_end_date']); } $studentClasses[$i]['enrollment_start_date'] = $getEstimateDetails[$i]['enroll_start_date']; $studentClasses[$i]['enrollment_end_date'] = $getEstimateDetails[$i]['enroll_end_date']; if ($i == 0) { $student_class1 = StudentClasses::addStudentClass($studentClasses[$i]); } else { $studentClasses[$i]['status'] = 'pending'; $student_class2 = StudentClasses::addStudentClass($studentClasses[$i]); } } } else { if ((int) $getEstimateDetails[0]['no_of_opted_classes'] < $firstpayment_no) { //return Response::json(array('status'=>'success','inputs'=>$inputs)); for ($i = 0; $i < 3; $i++) { if ($i == 0) { $studentClasses[$i]['classId'] = $getEstimateDetails[$i]['class_id']; $studentClasses[$i]['batchId'] = $getEstimateDetails[$i]['batch_id']; $studentClasses[$i]['studentId'] = $getEstimateDetails[$i]['student_id']; $studentClasses[$i]['seasonId'] = $getEstimateDetails[$i]['season_id']; $studentClasses[$i]['selected_sessions'] = $getEstimateDetails[$i]['no_of_opted_classes']; $studentClasses[$i]['enrollment_start_date'] = $getEstimateDetails[$i]['enroll_start_date']; $studentClasses[$i]['enrollment_end_date'] = $getEstimateDetails[$i]['enroll_end_date']; $student_class1 = StudentClasses::addStudentClass($studentClasses[$i]); } else { $studentClasses[$i]['classId'] = $getEstimateDetails[1]['class_id']; $studentClasses[$i]['batchId'] = $getEstimateDetails[1]['batch_id']; $studentClasses[$i]['studentId'] = $getEstimateDetails[1]['student_id']; $studentClasses[$i]['seasonId'] = $getEstimateDetails[1]['season_id']; if ($i == 1) { $second_session = $firstpayment_no - $studentClasses[0]['selected_sessions']; $studentClasses[$i]['selected_sessions'] = $second_session; $studentClasses[$i]['enrollment_start_date'] = $batch_data[1][0]['schedule_date']; $studentClasses[$i]['enrollment_end_date'] = $batch_data[1][$second_session - 1]['schedule_date']; $student_class2 = StudentClasses::addStudentClass($studentClasses[$i]); // return Response::json(array('status'=>'success','inputs'=>$inputs)); } if ($i == 2) { $studentClasses[$i]['selected_sessions'] = $secondpayment_no; $studentClasses[$i]['enrollment_start_date'] = $batch_data[1][$second_session]['schedule_date']; $studentClasses[$i]['enrollment_end_date'] = $batch_data[1][count($batch_data[1]) - 1]['schedule_date']; $studentClasses[$i]['status'] = 'pending'; $student_class3 = StudentClasses::addStudentClass($studentClasses[$i]); } } } } else { if ((int) $getEstimateDetails[0]['no_of_opted_classes'] > $firstpayment_no) { for ($i = 1; $i <= 3; $i++) { if ($i == 1) { $studentClasses[1]['classId'] = $getEstimateDetails[0]['class_id']; $studentClasses[1]['batchId'] = $getEstimateDetails[0]['batch_id']; $studentClasses[1]['studentId'] = $getEstimateDetails[0]['student_id']; $studentClasses[1]['seasonId'] = $getEstimateDetails[0]['season_id']; $studentClasses[1]['selected_sessions'] = $firstpayment_no; $studentClasses[1]['enrollment_start_date'] = $getEstimateDetails[0]['enroll_start_date']; $studentClasses[1]['enrollment_end_date'] = $batch_data[0][$firstpayment_no - 1]['schedule_date']; $student_class1 = StudentClasses::addStudentClass($studentClasses[1]); } else { if ($i == 2) { $studentClasses[1]['selected_sessions'] = count($batch_data[0]) - $firstpayment_no; $studentClasses[1]['enrollment_start_date'] = $batch_data[0][$firstpayment_no]['schedule_date']; $studentClasses[1]['enrollment_end_date'] = $batch_data[0][count($batch_data[0]) - 1]['schedule_date']; $studentClasses[1]['status'] = 'pending'; $student_class2 = StudentClasses::addStudentClass($studentClasses[1]); } else { if ($i == 3) { $studentClasses[2]['classId'] = $getEstimateDetails[1]['class_id']; $studentClasses[2]['batchId'] = $getEstimateDetails[1]['batch_id']; $studentClasses[2]['studentId'] = $getEstimateDetails[1]['student_id']; $studentClasses[2]['seasonId'] = $getEstimateDetails[1]['season_id']; $studentClasses[2]['selected_sessions'] = count($batch_data[1]); $studentClasses[2]['enrollment_start_date'] = $getEstimateDetails[1]['enroll_start_date']; $studentClasses[2]['enrollment_end_date'] = $batch_data[1][count($batch_data[1]) - 1]['schedule_date']; $studentClasses[2]['status'] = 'pending'; $student_class3 = StudentClasses::addStudentClass($studentClasses[2]); } } } } } } } return Response::json(array('status' => 'success', 'inputs' => $inputs)); } elseif ($inputs['paymentOptionsRadio'] == "multipay") { //multipay } } elseif (count($getEstimateDetails) == 3) { if ($inputs['paymentOptionsRadio'] == "singlepay") { //$insertDataToStudentClassTable = StudentClasses::addStudentClass($inputs); } elseif ($inputs['paymentOptionsRadio'] == "bipay") { $batch_data[0] = BatchSchedule::where('batch_id', '=', $getEstimateDetails[0]['batch_id'])->where('schedule_date', '>=', $getEstimateDetails[0]['enroll_start_date'])->where('holiday', '!=', 1)->orderBy('id')->take($getEstimateDetails[0]['no_of_opted_classes'])->get(); $batch_data[1] = BatchSchedule::where('batch_id', '=', $getEstimateDetails[1]['batch_id'])->where('schedule_date', '>=', $getEstimateDetails[1]['enroll_start_date'])->where('holiday', '!=', 1)->orderBy('id')->take($getEstimateDetails[1]['no_of_opted_classes'])->get(); $batch_data[2] = BatchSchedule::where('batch_id', '=', $getEstimateDetails[2]['batch_id'])->where('schedule_date', '>=', $getEstimateDetails[2]['enroll_start_date'])->where('holiday', '!=', 1)->orderBy('id')->take($getEstimateDetails[2]['no_of_opted_classes'])->get(); if (((int) $inputs['bipaybatch1availablesession'] + (int) $inputs['bipaybatch2availablesession'] + $inputs['bipaybatch3availablesession']) % 2 == 0) { $firstpayment_no = (int) ($inputs['bipaybatch1availablesession'] + $inputs['bipaybatch2availablesession'] + $inputs['bipaybatch3availablesession']) / 2; $secondpayment_no = (int) ($inputs['bipaybatch1availablesession'] + $inputs['bipaybatch2availablesession'] + $inputs['bipaybatch3availablesession']) / 2; } else { $firstpayment_no = (int) (($inputs['bipaybatch1availablesession'] + $inputs['bipaybatch2availablesession'] + $inputs['bipaybatch3availablesession']) / 2); $secondpayment_no = (int) (($inputs['bipaybatch1availablesession'] + $inputs['bipaybatch2availablesession'] + $inputs['bipaybatch3availablesession']) / 2) + 1; } if ((int) $getEstimateDetails[0]['no_of_opted_classes'] + (int) $getEstimateDetails[1]['no_of_opted_classes'] < $firstpayment_no) { for ($i = 0; $i <= 3; $i++) { if ($i != 3) { $studentClasses[$i]['classId'] = $getEstimateDetails[$i]['class_id']; $studentClasses[$i]['batchId'] = $getEstimateDetails[$i]['batch_id']; $studentClasses[$i]['studentId'] = $getEstimateDetails[$i]['student_id']; $studentClasses[$i]['seasonId'] = $getEstimateDetails[$i]['season_id']; $studentClasses[$i]['enrollment_start_date'] = $batch_data[$i][0]['schedule_date']; if ($i != 2) { $studentClasses[$i]['selected_sessions'] = $getEstimateDetails[$i]['no_of_opted_classes']; $studentClasses[$i]['enrollment_end_date'] = $batch_data[$i][count($batch_data[$i]) - 1]['schedule_date']; if ($i == 0) { $student_class1 = StudentClasses::addStudentClass($studentClasses[$i]); } else { if ($i == 1) { $student_class2 = StudentClasses::addStudentClass($studentClasses[$i]); } } } else { if ($i == 2) { $studentClasses[$i]['selected_sessions'] = $firstpayment_no - ($studentClasses[0]['selected_sessions'] + $studentClasses[1]['selected_sessions']); $studentClasses[$i]['enrollment_end_date'] = $batch_data[$i][$firstpayment_no - ($studentClasses[0]['selected_sessions'] + $studentClasses[1]['selected_sessions']) - 1]['schedule_date']; $student_class3 = StudentClasses::addStudentClass($studentClasses[$i]); } } } else { if ($i == 3) { $studentClasses[2]['selected_sessions'] = $secondpayment_no; $studentClasses[2]['enrollment_start_date'] = $batch_data[2][$firstpayment_no - ($studentClasses[0]['selected_sessions'] + $studentClasses[1]['selected_sessions'])]['schedule_date']; $studentClasses[2]['enrollment_end_date'] = $batch_data[2][count($batch_data[2]) - 1]['schedule_date']; $studentClasses[2]['status'] = 'pending'; $student_class4 = StudentClasses::addStudentClass($studentClasses[2]); return Response::json(array('status' => 'success', 'inputs' => $inputs, 'first' => $firstpayment_no, 'second' => $secondpayment_no)); } } } } else { if ((int) $getEstimateDetails[0]['no_of_opted_classes'] + (int) $getEstimateDetails[1]['no_of_opted_classes'] == $firstpayment_no) { for ($i = 0; $i < 3; $i++) { if ($i != 2) { $studentClasses[$i]['classId'] = $getEstimateDetails[$i]['class_id']; $studentClasses[$i]['batchId'] = $getEstimateDetails[$i]['batch_id']; $studentClasses[$i]['studentId'] = $getEstimateDetails[$i]['student_id']; $studentClasses[$i]['seasonId'] = $getEstimateDetails[$i]['season_id']; $studentClasses[$i]['enrollment_start_date'] = $batch_data[$i][0]['schedule_date']; $studentClasses[$i]['enrollment_end_date'] = $batch_data[count($batch_data[$i]) - 1]['schedule_date']; $studentClasses[$i]['selected_sessions'] = count($batch_data[$i]); if ($i == 1) { $student_class1 = StudentClasses::addStudentClass($studentClasses[$i]); } else { if ($i == 2) { $student_class2 = StudentClasses::addStudentClass($studentClasses[$i]); } } } else { $studentClasses[$i]['classId'] = $getEstimateDetails[$i]['class_id']; $studentClasses[$i]['batchId'] = $getEstimateDetails[$i]['batch_id']; $studentClasses[$i]['studentId'] = $getEstimateDetails[$i]['student_id']; $studentClasses[$i]['seasonId'] = $getEstimateDetails[$i]['season_id']; $studentClasses[$i]['enrollment_start_date'] = $batch_data[$i][0]['schedule_date']; $studentClasses[$i]['enrollment_end_date'] = $batch_data[count($batch_data[$i]) - 1]['schedule_date']; $studentClasses[$i]['selected_sessions'] = count($batch_data[$i]); } } } } } elseif ($inputs['paymentOptionsRadio'] == "multipay") { } } }