/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
echo "<pre>";
echo "harsha";
$enrolledCustomers = StudentClasses::getEnrolledCustomers();
print_r($enrolledCustomers);
exit;
$data = array("customerName" => "Prasath Aru");
Mail::send('emails.account.customer', $data, function ($msg) {
$email = '*****@*****.**';
$msg->from('*****@*****.**', 'The Little Gym');
$msg->to($email, "Prasath Arumugam")->subject('Test mail');
});
exit;
/* $batchEndDate = Batches::select('end_date')->where("id","=", 2)->get();
print_r($batchEndDate['0']->end_date); */
$batches = BatchSchedule::where('batch_id', '=', '2')->whereBetween('schedule_date', array('2016-1-1', '2016-3-31'))->count();
//->get();
echo $batches;
}
public function checkmultiPayOrderDate()
{
$inputs = Input::all();
$batch_data = Batches::find($inputs['batchid']);
$eachClassCost = $batch_data->class_amount;
$startdate = new carbon();
$enddate = new carbon();
$startdate = $startdate->createFromFormat('m/d/Y', $inputs['startdate']);
$enddate = $enddate->createFromFormat('m/d/Y', $inputs['enddate']);
if (isset($inputs['multipayAmount1'])) {
$firstPayWeeksNo = $inputs['multipayAmount1'] / $eachClassCost;
}
if (isset($inputs['multipayAmount2'])) {
$secondPayWeeksNo = $inputs['multipayAmount2'] / $eachClassCost;
}
if (isset($inputs['multipayAmount3'])) {
$thirdPayWeeksNo = $inputs['multipayAmount3'] / $eachClassCost;
}
if (isset($inputs['multipayAmount4'])) {
$fourthPayWeeksNo = $inputs['multipayAmount4'] / $eachClassCost;
}
//$totalweekNo=$firstPayWeeksNo+$secondPayWeeksNo+$thirdPayWeeksNo+$fourthPayWeeksNo;
$batch_data = BatchSchedule::where('batch_id', '=', $inputs['batchid'])->where('franchisee_id', '=', Session::get('franchiseId'))->where('season_id', '=', $inputs['seasonid'])->whereBetween('schedule_date', array($startdate->toDateString(), $enddate->toDateString()))->where('holiday', '!=', 1)->orderBy('id')->get();
$firstPayWeeksNo = $firstPayWeeksNo - 1;
if (isset($inputs['multipayAmount2'])) {
$secondPayWeeksNo = $secondPayWeeksNo + $firstPayWeeksNo;
}
if (isset($inputs['multipayAmount3'])) {
$thirdPayWeeksNo = $secondPayWeeksNo + $thirdPayWeeksNo;
}
if (isset($inputs['multipayAmount4'])) {
$fourthPayWeeksNo = $thirdPayWeeksNo + $fourthPayWeeksNo;
}
$presentdate = new carbon();
$presentdate = $presentdate->now();
$secondPaymentDate = new carbon();
$thirdPaymentDate = new carbon();
$fourthPaymentDate = new carbon();
if (isset($inputs['multipayAmount2'])) {
$secondPaymentDate = $secondPaymentDate->createFromFormat('Y-m-d', $batch_data[$firstPayWeeksNo]['schedule_date']);
}
if (isset($inputs['multipayAmount3'])) {
$thirdPaymentDate = $thirdPaymentDate->createFromFormat('Y-m-d', $batch_data[$secondPayWeeksNo]['schedule_date']);
}
if (isset($inputs['multipayAmount4'])) {
$fourthPaymentDate = $fourthPaymentDate->createFromFormat('Y-m-d', $batch_data[$thirdPayWeeksNo]['schedule_date']);
}
if (isset($inputs['multipayAmount4'])) {
if ($presentdate->gt($fourthPaymentDate)) {
return Response::json(array('status' => 'four'));
}
}
if (isset($inputs['multipayAmount3'])) {
if ($presentdate->gt($thirdPaymentDate)) {
return Response::json(array('status' => 'three'));
}
}
if (isset($inputs['multipayAmount2'])) {
if ($presentdate->gt($secondPaymentDate)) {
return Response::json(array('status' => 'two', 'date' => $secondPaymentDate));
}
}
//return Response::json(array('status'=>$batch_data));
}
static function deleteBatchScheduleById($batchId)
{
return BatchSchedule::where('batch_id', '=', $batchId)->delete();
}
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'));
}
}