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 function updateClassesBasePrice()
{
$inputs = Input::all();
$send_details = ClassBasePrice::updateClassesBasePrice($inputs);
if ($send_details) {
return Response::json(array('status' => 'success', $send_details));
} else {
return Response::json(array('status' => 'failure'));
}
}
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'));
}
}
