public function index()
{
//
$currentPage = "COURSES";
$mainMenu = "COURSES_MAIN";
$inputs = Input::all();
if (isset($inputs['className']) && isset($inputs['franchiseeCourse'])) {
/* echo '<pre>';
print_r($inputs);
exit(); */
$classadd = Classes::addClasses($inputs);
if ($classadd == "exists") {
Session::flash('error', "Sorry, Class you are trying to add already exists");
} elseif (!$classadd) {
Session::flash('error', "Sorry, Class Could not be added at the moment.");
} else {
Session::flash('msg', "Class added successfully.");
}
}
$courseList = CoursesMaster::getCoursesList();
//$classesMaster = ClassesMaster::getClassesMasterForDropDown();
$franchiseeCourses = Courses::getFranchiseCoursesList(Session::get('franchiseId'));
$classes = Classes::getAllClasses(1);
return View::make('pages.classes.classes', compact('classesMaster', 'classes', 'courseList', 'franchiseeCourses', 'currentPage', 'mainMenu'));
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function view($id)
{
if (Auth::check()) {
$currentPage = "STUDENTS_LIST";
$mainMenu = "STUDENTS_MAIN";
$student = Students::getStudentById($id);
$franchiseeCourses = Courses::getFranchiseCoursesList(Session::get('franchiseId'));
$studentEnrollments = StudentClasses::getStudentEnrollments($id);
$paymentDues = PaymentDues::getAllPaymentDuesByStudent($id);
$customermembership = CustomerMembership::getCustomerMembership($student['0']->customer_id);
$scheduledIntroVisits = IntroVisit::getIntrovisitByStudentId($id);
$discountEligibility = StudentClasses::discount($id, $student['0']->customer_id);
//$paidDue= PaymentDues::getAllPaymentsMade($id);
//$Due=PaymentDues::getAllDue($id);
//for paid payment
/* on hold for changing enrollment
$paidAmountdata= PaymentDues::getAllPaymentsMade($id);
for($i=0;$i<count($paidAmountdata);$i++){
$studentclasssectiondata= Classes::getstudentclasses($paidAmountdata[$i]['class_id']);
$paidAmountdata[$i]['class_name']=$studentclasssectiondata[0]['class_name'];
$user_Data=User::getUsersByUserId($paidAmountdata[$i]['created_by']);
$paidAmountdata[$i]['receivedname']=$user_Data[0]['first_name'].$user_Data[0]['last_name'];
$order_data= Orders::getOrderDetailsbyPaydueId($paidAmountdata[$i]['id']);
$paidAmountdata[$i]['printurl']= url().'/orders/print/'.Crypt::encrypt($order_data[0]['id']);
}
*/
/*
$paidAmountdata= Orders::getAllPaymentsMade($id);
for($i=0;$i<count($paidAmountdata);$i++){
$studentClassdata=StudentClasses::getStudentClassbyId($paidAmountdata[$i]['student_classes_id']);
$paidAmountdata[$i]['enrollment_start_date']=$studentClassdata[0]['enrollment_start_date'];
$paidAmountdata[$i]['enrollment_end_date']=$studentClassdata[0]['enrollment_end_date'];
$paidAmountdata[$i]['selected_sessions']=$studentClassdata[0]['selected_sessions'];
$studentclasssectiondata= Classes::getstudentclasses($studentClassdata[0]['class_id']);
$paidAmountdata[$i]['class_name']=$studentclasssectiondata[0]['class_name'];
$user_Data=User::getUsersByUserId($paidAmountdata[$i]['created_by']);
$paidAmountdata[$i]['receivedname']=$user_Data[0]['first_name'].$user_Data[0]['last_name'];
$paidAmountdata[$i]['printurl']= url().'/orders/print/'.Crypt::encrypt($paidAmountdata[0]['id']);
}
*
*/
//for dues
// $order_due_data=Orders::getpendingPaymentsid($id);
$order_due_data = PaymentDues::getAllDuebyStudentId($id);
// $dueAmountdata=PaymentDues::getAllDue($id);
for ($i = 0; $i < count($order_due_data); $i++) {
$studentclasssectiondata = Classes::getstudentclasses($order_due_data[0]['class_id']);
$order_due_data[$i]['class_name'] = $studentclasssectiondata[0]['class_name'];
$user_Data = User::getUsersByUserId($order_due_data[$i]['created_by']);
$order_due_data[$i]['receivedname'] = $user_Data[0]['first_name'] . $user_Data[0]['last_name'];
}
//getting values for present Discount for enrollment
$discount_second_child = 0;
$discount_second_class = 0;
$discount_second_child_elligible = 0;
$discount_second_class_elligible = 0;
$count = 0;
$DiscountApprove = Discounts::where('franchisee_id', '=', Session::get('franchiseId'))->first();
if ($DiscountApprove['discount_second_child_approve'] == 1) {
$discount_second_child_elligible = 1;
$discount_second_child = $DiscountApprove['discount_second_child'];
}
if ($DiscountApprove['discount_second_class_approve'] == 1) {
$discount_second_class_elligible = 1;
$discount_second_class = $DiscountApprove['discount_second_class'];
}
if ($discount_second_class_elligible) {
$classes_count = StudentClasses::where('student_id', '=', $student[0]['id'])->where('status', '=', 'enrolled')->count();
if ($classes_count > 1) {
$discount_second_class_elligible = 1;
} else {
$discount_second_class_elligible = 0;
}
}
if ($discount_second_child_elligible) {
$student_ids = Students::where('customer_id', '=', $student[0]['customer_id'])->select('id')->get()->toArray();
for ($i = 0; $i < count($student_ids); $i++) {
if (StudentClasses::where('student_id', '=', $student_ids[$i]['id'])->where('status', '=', 'enrolled')->exists()) {
$count++;
}
}
//$discount_second_class_elligible=($count>1)?1:0;
if ($count > 1) {
$discount_second_class_elligible = 1;
} else {
$discount_second_class_elligible = 0;
}
}
$discountEnrollmentData = Discounts::getEnrollmentDiscontByFranchiseId();
$dataToView = array("student", 'currentPage', 'mainMenu', 'franchiseeCourses', 'discountEnrollmentData', 'discount_second_class_elligible', 'discount_second_child_elligible', 'discount_second_child', 'discount_second_class', 'studentEnrollments', 'customermembership', 'paymentDues', 'scheduledIntroVisits', 'introvisit', 'discountEligibility', 'paidAmountdata', 'order_due_data');
return View::make('pages.students.details', compact($dataToView));
} else {
return Redirect::to("/");
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
//
if (Auth::check()) {
$currentPage = "CLASSES";
$mainMenu = "COURSES_MAIN";
$inputs = Input::all();
if (isset($inputs['startTime'])) {
//$startDate = //date('Y-m-d', strtotime($season_data['end_date']));
$season_data = Seasons::where('id', '=', $inputs['selectSeason'])->get();
$season_data = $season_data[0];
$startDate = new Carbon();
$endDate = new Carbon();
$startDate = $startDate->createFromFormat('Y-m-d', $season_data['start_date']);
$endDate = $endDate->createFromFormat('Y-m-d', $season_data['end_date']);
//taking season start date, end date and making calculation to start to specific day(MON,TUE...)
switch ($inputs['day']) {
case 0:
break;
case 1:
$startDate->addDays(1);
break;
case 2:
$startDate->addDays(2);
break;
case 3:
$startDate->addDays(3);
break;
case 4:
$startDate->addDays(4);
break;
case 5:
$startDate->addDays(5);
break;
case 6:
$startDate->addDays(6);
break;
}
switch ($inputs['day']) {
case 0:
$endDate->subDays(6);
break;
case 1:
$endDate->subDays(5);
break;
case 2:
$endDate->subDays(4);
break;
case 3:
$endDate->subDays(3);
break;
case 4:
$endDate->subDays(2);
break;
case 5:
$endDate->subDays(1);
break;
case 6:
break;
}
$date = $startDate->day;
$yr = $startDate->year;
$month = $startDate->month;
$inputs['startDate'] = $date . '-' . $month . '-' . $yr;
$courseId = $inputs['franchiseeCourse'];
$classId = $inputs['className'];
$startTime = $inputs['startTime'];
$endTime = $inputs['endTime'];
$leadInstructor = $inputs['leadInstructor'];
$alternateInstructor = $inputs['alternateInstructor'];
$day = date('N', strtotime($inputs['startDate']));
if (date('m', strtotime($inputs['startDate'])) >= 1 && date('m', strtotime($inputs['startDate'])) <= 1) {
$endDateYear = date('Y', strtotime($inputs['startDate']));
} else {
$endDateYear = date('Y', strtotime($inputs['startDate']));
$endDateYear = $endDateYear + 1;
}
/*
echo $startDate.' = '.$endDate ;//Year.'-03-31';
exit();
*/
$months = getMonthsBetweenDates($startDate, $endDate);
//Year.'-03-31');
/*
echo "<pre>";
print_r($months);
echo "</pre>";
exit();
*/
$i = 0;
foreach ($months as $month) {
$yearAndMonth = explode('-', $month['month']);
$daysFound[$i] = getDaysFromMonth($yearAndMonth['1'], $yearAndMonth['0'], $day);
$i++;
}
$timeString = date('Y-m-d', strtotime($inputs['startDate'])) . $inputs['startTime'];
$timestamp = strtotime($timeString);
$startTime24Hours = date('H:i:s', $timestamp);
$timeString = $endDateYear . '-3-5 ' . $inputs['endTime'];
$timestamp = strtotime($timeString);
$endTime24Hours = date('H:i:s', $timestamp);
$batchSlug = Courses::getBatchID($courseId, $classId, $startDate, null, $inputs['selectSeason']);
$inputBatch['batchName'] = $batchSlug;
$inputBatch['classId'] = $classId;
$inputBatch['courseId'] = $courseId;
$inputBatch['startDate'] = $startDate->toDateString();
$inputBatch['endDate'] = $endDate->toDateString();
$inputBatch['season_id'] = $inputs['selectSeason'];
$inputBatch['preferredTime'] = $startTime24Hours;
$inputBatch['preferredEndTime'] = $endTime24Hours;
$inputBatch['leadInstructor'] = $leadInstructor;
$inputBatch['alternateInstructor'] = $alternateInstructor;
$inputBatch['location_id'] = $inputs['seasonLocation'];
//$inputBatch['classAmount']=$inputs['eachClassAmount'];
$newBatch = Batches::addBatches($inputBatch);
/*
$days = 1;
foreach($daysFound as $monthdays){
foreach($monthdays as $dayFound){
if($days <= 40){
$batchScheduleInput['batchId'] = $newBatch->id;
$batchScheduleInput['seasonId'] = $inputs['selectSeason'];
$batchScheduleInput['scheduleDate'] = $dayFound;
$batchScheduleInput['startTime'] = $startTime24Hours;
$batchScheduleInput['endTime'] = $endTime24Hours;
$batchScheduleInput['scheduleType']= 'class';
BatchSchedule::addSchedule($batchScheduleInput);
}
$days++;
}
}
*/
//calculating dates and adding all the dates to batchschedule for new batch
$batch_schedule = new BatchSchedule();
do {
$batchScheduleInput['batchId'] = $newBatch->id;
$batchScheduleInput['seasonId'] = $inputs['selectSeason'];
$batchScheduleInput['scheduleDate'] = $startDate->toDateString();
$batchScheduleInput['startTime'] = $startTime24Hours;
$batchScheduleInput['endTime'] = $endTime24Hours;
$batchScheduleInput['scheduleType'] = 'class';
BatchSchedule::addSchedule($batchScheduleInput);
$startDate->addDays(7);
} while ($startDate->eq($endDate) == FALSE);
//for last date
$batchScheduleInput['batchId'] = $newBatch->id;
$batchScheduleInput['seasonId'] = $inputs['selectSeason'];
$batchScheduleInput['scheduleDate'] = $startDate->toDateString();
$batchScheduleInput['startTime'] = $startTime24Hours;
$batchScheduleInput['endTime'] = $endTime24Hours;
$batchScheduleInput['scheduleType'] = 'class';
BatchSchedule::addSchedule($batchScheduleInput);
//check for holidays if exists make
if (Holidays::where('season_id', '=', $inputs['selectSeason'])->count() > 0) {
$holiday_data = Holidays::where('season_id', '=', $inputs['selectSeason'])->select('startdate', 'enddate')->get();
for ($i = 0; $i < count($holiday_data); $i++) {
DB::table('batch_schedule')->where('batch_id', '=', $newBatch->id)->whereBetween('schedule_date', array($holiday_data[$i]['startdate'], $holiday_data[$i]['enddate']))->update(array('holiday' => 1));
}
}
Session::flash('msg', "Batch added successfully.");
return Redirect::to('batches');
}
$franchiseeId = Session::get('franchiseId');
$season_display_data = Seasons::where('franchisee_id', '=', Session::get('franchiseId'))->orderBy('id', 'DESC')->get();
if (isset($season_display_data[0])) {
$s_id = $season_display_data[0]['id'];
$batches = Batches::getAllBatchesDatabySeasonId($franchiseeId, $s_id);
for ($i = 0; $i < count($batches); $i++) {
$batches[$i]['preferred_time'] = date("H:i", strtotime($batches[$i]['preferred_time']));
$batches[$i]['preferred_end_time'] = date("H:i", strtotime($batches[$i]['preferred_end_time']));
$location_data = Location::where('id', '=', $batches[$i]['location_id'])->get();
$batches[$i]['location_name'] = $location_data[0]['location_name'];
$batches[$i]['created'] = date("Y-m-d", strtotime($batches[$i]['created_at']));
$batches[$i]['day'] = date('l', strtotime($batches[$i]['start_date']));
if ($batches[$i]['lead_instructor'] != '') {
$user_data = User::find($batches[$i]['lead_instructor']);
$batches[$i]['instructor_name'] = $user_data['first_name'] . '' . $user_data['last_name'];
} else {
$batches[$i]['instructor_name'] = '';
}
$batches[$i]['count'] = StudentClasses::where('batch_id', '=', $batches[$i]['id'])->count();
}
}
$courseList = Courses::getFranchiseCoursesList($franchiseeId);
$franchiseeCourses = Courses::getFranchiseCoursesList(Session::get('franchiseId'));
$Instructors = User::getInstructors();
$dataToView = array('batches', 'courseList', 'currentPage', 'mainMenu', 'franchiseeCourses', 'mondays', 'Instructors');
return View::make('pages.batches.batchesfinal', compact($dataToView));
} else {
return Redirect::to("/");
}
}
