public function add_new_class_franchise() { $currentPage = "CLASSES_FRANCHISE"; $mainMenu = "CLASSES_MAIN"; $franchiseeCourses = Courses::where('franchisee_id', '=', Session::get('franchiseId'))->get(); $franchiseeBaseprice = ClassBasePrice::getBasePricebyFranchiseeId(); $getAllClassesForFranchise = Classes::getAllClassesForFranchise(); for ($i = 0; $i < sizeof($getAllClassesForFranchise); $i++) { $courseMasterId = Courses::where('id', '=', $getAllClassesForFranchise[$i]['course_id'])->get(); $courseMasterId = $courseMasterId[0]; $courseName = CoursesMaster::where('id', '=', $courseMasterId['master_course_id'])->get(); $courseName = $courseName[0]; $getAllClassesForFranchise[$i]['course_name'] = $courseName['course_name']; $getBasePrice = ClassBasePrice::where('base_price_no', '=', $getAllClassesForFranchise[$i]['base_price_no'])->get(); $getBasePrice = ClassBasePrice::where('base_price_no', '=', $getAllClassesForFranchise[$i]['base_price_no'])->get(); //$getBasePrice = $getBasePrice[0]; if ($getAllClassesForFranchise[$i]['base_price_no'] == 0) { $getAllClassesForFranchise[$i]['base_price'] = ''; } else { $getAllClassesForFranchise[$i]['base_price'] = $getBasePrice[0]['base_price']; } } //return $getAllClassesForFranchise; return View::make('pages.classes.add_new_class_franchise', compact('currentPage', 'mainMenu', 'franchiseeCourses', 'franchiseeBaseprice', 'getAllClassesForFranchise')); }
static function updateClassesBasePrice($data) { //return $data; if ($data['BasePriceNo'] == 0) { return true; } else { $update = ClassBasePrice::where('base_price_no', '=', $data['BasePriceNo'])->update(array('base_price' => $data['BasePrice'])); return $update; } }
public static function updatebaseprice() { if (Auth::check()) { $inputs = Input::all(); ClassBasePrice::where('id', '=', $inputs['baseprice_id'])->update(array('base_price' => $inputs['base_price'], 'updated_by' => Session::get('userId'))); return Response::json(array('status' => 'success')); } }
}); 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(); //
public function getBatchRemainingClassesByBatchId() { $inputs = Input::all(); $batchClassesData = BatchSchedule::where('franchisee_id', '=', Session::get('franchiseId'))->where('batch_id', '=', $inputs['batchId'])->whereDate('schedule_date', '>=', $inputs['preferredStartDate'])->get(); $batchClassesCount = count($batchClassesData); $lastEndDate = $batchClassesData[$batchClassesCount - 1]['schedule_date']; $date = Carbon::now(); $date = $date->createFromFormat('Y-m-d', $lastEndDate); $date = $date->next(Carbon::MONDAY); //getting the batch cost from batch class //$class_data= ClassBasePrice::where('base_price_no','=',Batches::find($inputs['batchId'])->classes()->base_price_no)->select('base_price')->get(); //$classAmount=$batch_data->class_amount; $base_price_no = Batches::find($inputs['batchId'])->classes()->select('base_price_no')->get(); $base_price = ClassBasePrice::where('base_price_no', '=', $base_price_no[0]['base_price_no'])->get(); $base_price = $base_price[0]['base_price']; if ($batchClassesCount) { return Response::json(array('status' => 'success', 'classCount' => $batchClassesCount, 'lastdate' => $date->toDateString(), 'classAmount' => $base_price, 'enrollment_end_date' => $batchClassesData[count($batchClassesData) - 1]['schedule_date'], 'enrollment_start_date' => $batchClassesData[0]['schedule_date'])); } else { return Response::json(array('status' => 'failure')); } }