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'));
}
}
