public function get($plantID)
{
$SeasonsForPlant = PlantSeason::where('plant_id', '=', $plantID)->get();
$seasonArray = array();
$translatedSeasonArray = array();
foreach ($SeasonsForPlant as $season) {
$seasonArray[] = Seasons::where('id', '=', $season['season_id'])->get()[0]['season'];
}
foreach ($seasonArray as $season) {
if (array_search($season, $this->translationsArray)) {
$translatedSeasonArray[] = array_search($season, $this->translationsArray);
}
}
return $translatedSeasonArray;
}
/**
* Display a listing of the resource.
* GET /seasons
*
* @return Response
*/
public function index()
{
if (Auth::check()) {
$currentPage = "ViewSeasons_LI";
$mainMenu = "SEASONS_MENU_MAIN";
$season_data = Seasons::where('franchisee_id', '=', Session::get('franchiseId'))->orderBy('id', '=', 'DESC')->get();
for ($i = 0; $i < sizeof($season_data); $i++) {
$user_data = User::where('id', '=', $season_data[$i]['created_by'])->get();
$user_data = $user_data[0];
$season_data[$i]['created_by_name'] = $user_data['first_name'] . $user_data['last_name'];
}
$viewdata = array('currentPage', 'mainMenu', 'season_data');
return View::make('pages.seasons.seasonview', compact($viewdata));
}
}
public function checkBatchExistBySeasonIdLocationId()
{
$inputs = Input::all();
$startDate = new carbon();
$season_data = Seasons::where('id', '=', $inputs['season_id'])->get();
$season_data = $season_data[0];
$startDate = $startDate->createFromFormat('Y-m-d', $season_data['start_date']);
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;
}
//converting to string to time (24hr format)
$timeString = $inputs['startTime'];
$timestamp = strtotime($timeString);
$startTime24Hours = date('H:i:s', $timestamp);
$timeString = $inputs['endTime'];
$timestamp = strtotime($timeString);
$endTime24Hours = date('H:i:s', $timestamp);
$batch_data = Batches::where('season_id', '=', $inputs['season_id'])->where('location_id', '=', $inputs['location_id'])->where('start_date', '=', $startDate->toDateString())->select('preferred_time', 'preferred_end_time')->get();
/*$batch_data2=Batches::where('season_id','=',$inputs['season_id'])
->where('location_id','=',$inputs['location_id'])
->where('start_date','=',$startDate->toDateString())
//->whereRaw('"preferred_time" >"'.$startTime24Hours.'"')
// ->whereRaw('"preferred_end_time" < "'.$endTime24Hours.'"')
->whereBetween('preferred_end_time',array($startTime24Hours,$endTime24Hours))
->orWhereBetween('preferred_time',array($startTime24Hours,$endTime24Hours))
->get();
*/
$flag = 'notexist';
$input_start_time = new carbon();
$input_end_time = new carbon();
$input_start_time = $input_start_time->createFromFormat('H:i:s', $startTime24Hours);
$input_end_time = $input_end_time->createFromFormat('H:i:s', $endTime24Hours);
if ($input_start_time->lt($input_end_time)) {
for ($i = 0; $i < count($batch_data); $i++) {
$batch_start_time = new carbon();
$batch_start_time = $batch_start_time->createFromFormat('H:i:s', $batch_data[$i]['preferred_time']);
$batch_end_time = $batch_start_time->createFromFormat('H:i:s', $batch_data[$i]['preferred_end_time']);
if ($input_start_time->eq($batch_start_time) && $input_end_time->eq($batch_end_time)) {
$flag = 'exist';
}
if ($input_start_time->lt($batch_start_time) && $input_end_time->gt($batch_start_time)) {
$flag = 'exist';
}
if ($input_start_time->eq($batch_start_time) && $input_end_time->lt($batch_end_time)) {
$flag = 'exist';
}
if ($input_start_time->gt($batch_start_time) && $input_end_time->lt($batch_end_time)) {
$flag = 'exist';
}
if ($input_start_time->eq($batch_start_time) && $input_end_time->gt($batch_end_time)) {
$flag = 'exist';
}
if ($input_start_time->gt($batch_start_time) && $input_start_time->lt($batch_end_time)) {
$flag = 'exist';
}
}
} else {
$flag = 'invalid selection';
}
return Response::json(array("status" => 'success', "batch_status" => $flag));
}
