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") {
}
}
}
