public function checkenrollmentExists() { $inputs = Input::all(); $studentId = $inputs['studentId']; $classId = $inputs['classId']; $enrolledClassForStudent = StudentClasses::where("student_id", "=", $studentId)->where("class_id", "=", $classId)->get(); if (isset($enrolledClassForStudent['0'])) { return Response::json(array("status" => "exist")); } return Response::json(array("status" => "clear")); }
Route::any('getCities', function () { $inputs = Input::all(); $id = $inputs['id']; $countryCode = $inputs['countryCode']; $cities = Cities::getCities($id, $countryCode); return Response::json($cities); }); Route::get('logout', "VaultController@logout"); }); Route::get('/test', function () { $base_price_no = Batches::find(130)->classes()->select('base_price_no')->get(); $base_price_no = $base_price_no[0]['base_price_no']; echo $base_price_no; die; var_dump(ClassBasePrice::where('base_price_no', '=', Batches::find(130)->classes()->base_price_no)->select('base_price')->get()); $classes_count = StudentClasses::where('student_id', '=', 88)->where('status', '=', 'enrolled')->distinct('class_id')->count(); var_dump($classes_count); exit; echo PaymentMaster::max('payment_no'); exit; echo Batches::where('id', '=', '2')->select('class_amount')->get(); exit; $data = IntroVisit::join('students', 'student_id', '=', 'students.id')->where('introvisit.customer_id', '=', '44')->get(); var_dump($data); exit; // for($i=0;$i<count($birthday_data);$i++){ // $customer_data= Customers::where('id','=',$birthday_data[$i]['customer_id'])->get(); // $birthday_data[$i]['customer_name']= $customer_data[0]['customer_name']; // $birthday_data[$i]['membership']= CustomerMembership::where('customer_id','=',$birthday_data[$i]['customer_id'])->count(); // // }
static function getStudentClassbyId($student_class_id) { return StudentClasses::where('id', '=', $student_class_id)->get(); }
public function getBatchData() { $inputs = Input::all(); $franchisee_id = Session::get('franchiseId'); $batch_data = Batches::getAllBatchesbySeasonId($franchisee_id, $inputs['session_id']); for ($i = 0; $i < count($batch_data); $i++) { $batch_data[$i]['preferred_time'] = date("h:i", strtotime($batch_data[$i]['preferred_time'])); $batch_data[$i]['preferred_end_time'] = date("h:i", strtotime($batch_data[$i]['preferred_end_time'])); $location_data = Location::where('id', '=', $batch_data[$i]['location_id'])->get(); $batch_data[$i]['location_name'] = $location_data[0]['location_name']; $batch_data[$i]['created'] = date("Y-m-d", strtotime($batch_data[$i]['created_at'])); $batch_data[$i]['day'] = date('l', strtotime($batch_data[$i]['start_date'])); if ($batch_data[$i]['lead_instructor'] != '') { $user_data = User::find($batch_data[$i]['lead_instructor']); $batch_data[$i]['instructor_name'] = $user_data['first_name'] . '' . $user_data['last_name']; } else { $batch_data[$i]['instructor_name'] = ''; } $batch_data[$i]['count'] = StudentClasses::where('batch_id', '=', $batch_data[$i]['id'])->count(); } if ($batch_data) { return Response::json(array('status' => 'success', 'data' => $batch_data)); } else { return Response::json(array('status', 'failure')); } }