function get_Schedule($id, $ident)
{
global $globalDebug;
// Get schedule here, so it's done only one time
$Connection = new Connection();
$dbc = $Connection->db;
$Spotter = new Spotter($dbc);
$Schedule = new Schedule($dbc);
$Translation = new Translation($dbc);
$operator = $Spotter->getOperator($ident);
if ($Schedule->checkSchedule($operator) == 0) {
$operator = $Translation->checkTranslation($ident);
if ($Schedule->checkSchedule($operator) == 0) {
$schedule = $Schedule->fetchSchedule($operator);
if (count($schedule) > 0) {
if ($globalDebug) {
echo "-> Schedule info for " . $operator . " (" . $ident . ")\n";
}
$this->all_flights[$id] = array_merge($this->all_flights[$id], array('departure_airport_time' => $schedule['DepartureTime']));
$this->all_flights[$id] = array_merge($this->all_flights[$id], array('arrival_airport_time' => $schedule['ArrivalTime']));
// FIXME : Check if route schedule = route from DB
if ($schedule['DepartureAirportIATA'] != '') {
if ($this->all_flights[$id]['departure_airport'] != $Spotter->getAirportIcao($schedule['DepartureAirportIATA'])) {
$airport_icao = $Spotter->getAirportIcao($schedule['DepartureAirportIATA']);
if ($airport_icao != '') {
$this->all_flights[$id]['departure_airport'] = $airport_icao;
if ($globalDebug) {
echo "-> Change departure airport to " . $airport_icao . " for " . $ident . "\n";
}
}
}
}
if ($schedule['ArrivalAirportIATA'] != '') {
if ($this->all_flights[$id]['arrival_airport'] != $Spotter->getAirportIcao($schedule['ArrivalAirportIATA'])) {
$airport_icao = $Spotter->getAirportIcao($schedule['ArrivalAirportIATA']);
if ($airport_icao != '') {
$this->all_flights[$id]['arrival_airport'] = $airport_icao;
if ($globalDebug) {
echo "-> Change arrival airport to " . $airport_icao . " for " . $ident . "\n";
}
}
}
}
$Schedule->addSchedule($operator, $this->all_flights[$id]['departure_airport'], $this->all_flights[$id]['departure_airport_time'], $this->all_flights[$id]['arrival_airport'], $this->all_flights[$id]['arrival_airport_time'], $schedule['Source']);
}
}
}
//$Connection->db = null;
}
static function get_Schedule($id, $ident)
{
global $globalDebug;
// Get schedule here, so it's done only one time
$operator = Spotter::getOperator($ident);
if (Schedule::checkSchedule($operator) == 0) {
$operator = Translation::checkTranslation($ident);
if (Schedule::checkSchedule($operator) == 0) {
$schedule = Schedule::fetchSchedule($operator);
if (count($schedule) > 0) {
if ($globalDebug) {
echo "-> Schedule info for " . $operator . " (" . $ident . ")\n";
}
self::$all_flights[$id] = array_merge(self::$all_flights[$id], array('departure_airport_time' => $schedule['DepartureTime']));
self::$all_flights[$id] = array_merge(self::$all_flights[$id], array('arrival_airport_time' => $schedule['ArrivalTime']));
// FIXME : Check if route schedule = route from DB
if ($schedule['DepartureAirportIATA'] != '') {
if (self::$all_flights[$id]['departure_airport'] != Spotter::getAirportIcao($schedule['DepartureAirportIATA'])) {
$airport_icao = Spotter::getAirportIcao($schedule['DepartureAirportIATA']);
if ($airport_icao != '') {
self::$all_flights[$id]['departure_airport'] = $airport_icao;
if ($globalDebug) {
echo "-> Change departure airport to " . $airport_icao . " for " . $ident . "\n";
}
}
}
}
if ($schedule['ArrivalAirportIATA'] != '') {
if (self::$all_flights[$id]['arrival_airport'] != Spotter::getAirportIcao($schedule['ArrivalAirportIATA'])) {
$airport_icao = Spotter::getAirportIcao($schedule['ArrivalAirportIATA']);
if ($airport_icao != '') {
self::$all_flights[$id]['arrival_airport'] = $airport_icao;
if ($globalDebug) {
echo "-> Change arrival airport to " . $airport_icao . " for " . $ident . "\n";
}
}
}
}
Schedule::addSchedule($operator, self::$all_flights[$id]['departure_airport'], self::$all_flights[$id]['departure_airport_time'], self::$all_flights[$id]['arrival_airport'], self::$all_flights[$id]['arrival_airport_time'], $schedule['Source']);
}
}
}
}
Route::get('/employee/clocking', array('before' => 'auth', 'as' => 'employeeTimesheet', 'uses' => 'EmployeesController@showEmployeeTimesheet'));
Route::post('/employee/clocking', array('as' => 'timeClocking', 'uses' => function () {
$data = Input::all();
echo Session::put('timeclocking', $data['timeclocking']);
$workShift = new Workshift();
$getWorkShift = $workShift->getWorkShiftByEmployeeId(Auth::user()->employee_id);
$todayDate = date('Y-m-d');
$holiday = new Holiday();
$getHolidayByDate = $holiday->getHolidayByDate($todayDate);
//var_dump($employeeClocking);
//$employeeId = Auth::user()->employee_id;
//$workShift = DB::table('work_shift')->where('employee_id', $employeeId)->get();
$timesheet = new Timesheet();
$getTimesheetById = $timesheet->getTimesheetById(Auth::user()->employee_id, date('Y-m-d'));
$schedule = new Schedule();
$hasSchedule = $schedule->checkSchedule(Auth::user()->employee_id, date('Y-m-d'));
$getSchedule = $schedule->getSchedule(Auth::user()->employee_id, date('Y-m-d'));
//Deduction Model
$deduction = new Deduction();
$hasNightShiftStartTimeThreshold = true;
$nightShiftStartTimeThreshold = 5;
//It should be bigger;
//get schedule
//Check if there is assign schedule today
//if ( $hasSchedule && strtotime($getSchedule[0]->start_time) !== strtotime('00:00:00')) {
if ($hasSchedule && strtotime($getSchedule[0]->start_time) !== '') {
$hasTodaySchedule = true;
} else {
//check workShift table default schedule if no schedule in the schedule table
$hasTodaySchedule = false;
}
function hasSchedule()
{
$employeeId = Session::get('userEmployeeId');
$userId = Session::get('userId');
$schedule = new Schedule();
$hasSchedule = $schedule->checkSchedule($employeeId, date('Y-m-d'));
$getSchedule = $schedule->getSchedule($employeeId, date('Y-m-d'));
if ($hasSchedule && strtotime($getSchedule[0]->start_time) !== '') {
return true;
} else {
//check workShift table default schedule if no schedule in the schedule table
return false;
}
}
public function showAdminEmployeeTimesheet()
{
$employeeId = Session::get('userEmployeeId');
//$employeeId = Auth::user()->employee_id;
$currentDate = date('Y-m-d');
$employee = new Employee();
$employeeInfo = $employee->getEmployeeInfoById($employeeId);
$workShift = new Workshift();
$employeeWorkShift = $workShift->getWorkShiftByEmployeeId($employeeId);
$timesheet = new Timesheet();
$employeeTimesheet = $timesheet->getAllRows($employeeId);
$getTimesheetById = $timesheet->getTimesheetById($employeeId, $currentDate);
$timesheetPerMonth = $timesheet->getTimesheetPerMonth($employeeId, Session::get('dayDateArr'));
$schedule = new Schedule();
$checkSchedule = $schedule->checkSchedule($employeeId, $currentDate);
$getSchedule = $schedule->getSchedule($employeeId, $currentDate);
//Admin view
return View::make('employees.admin.clocking', ['employeeInfo' => $employeeInfo, 'employeeWorkShift' => $employeeWorkShift, 'employeeTimesheet' => $employeeTimesheet, 'getTimesheetById' => $getTimesheetById, 'timesheetPerMonth' => $timesheetPerMonth]);
}
public function ajaxCheck($request, $response)
{
$content = $request->c;
header("Content-Type: text/html; charset=GBK");
if (empty($content)) {
echo 'empty content';
exit;
} else {
$content = mb_convert_encoding($content, 'gbk', 'UTF-8');
$result = '';
$schedule = Schedule::checkSchedule($content);
if (isset($schedule['error']) && !empty($schedule['error'])) {
$result = '0';
foreach ($schedule['error'] as $value) {
$result .= $value;
$result .= "<br/>";
}
} else {
if (isset($schedule['right']) && !empty($schedule['right'])) {
$result = '1';
foreach ($schedule['right'] as $value) {
$value[0] = str_replace(',', ' ', $value[0]);
$result .= str_replace("({$value['1']})", '', $value[0]);
$result .= "<br/>";
}
}
}
echo $result;
exit;
}
}
public function doLogin()
{
/**
* @Todo: Server side validation
*/
$employeeno = Input::get('employeeno');
$password = Input::get('password');
/*$data['employeeno'] = $employeeno;
$data['password'] = $password;
$rules = array(
'employee_number' => 'required',
'password' => 'required'
);
$validator = Validator::make($data, $rules);
if ( $validator->fails() ) {
$messages = $validator->messages();
return Redirect::to('users/login')->withErrors($validator);
} else {*/
/*$userdata = array(
'employee_number' => $employeeno,
'password' => $password
);*/
// Login credentials
$credentials = array('employee_number' => $employeeno, 'password' => $password);
try {
// Authenticate the user
$user = Sentry::authenticate($credentials, false);
/*if($user){
return Redirect::to('/employee/clocking');
} else {
return View::make('users.index'); //Return back to login page
}*/
//if ( Auth::attempt($userdata) ) {
if ($user) {
// validation successful!
// redirect them to the secure section or whatever
// return Redirect::to('secure');
// for now we'll just echo success (even though echoing in a controller is bad)
//echo 'SUCCESS!';
//return $user->employee_id;
Session::put('userEmployeeId', $user->employee_id);
Session::put('userId', $user->id);
Session::put('email', $user->email);
$user['employeeId'] = $user->employee_id;
/*$emplooyeeSetting = new Setting;
$getEmployeeSettingByEmployeeId = $emplooyeeSetting->getEmployeeSettingByEmployeeId();
return dd($getEmployeeSettingByEmployeeId); //If no setting found the result will be NULL
break;*/
$employee = new Employee();
$employeeInfo = $employee->getEmployeeInfoById($user['employeeId']);
$workShift = new Workshift();
//$employeeWorkShift = $workShift->getWorkShiftByEmployeeId($user['employeeId']);
//$dayOfTheWeek = date('l', strtotime($dayDate));
//$getWorkShiftByDayOfTheWeek = $workShift->getWorkShiftByDayOfTheWeek($employeeInfo[0]->id, $dayOfTheWeek);
$adminCutoff = new AdminCutoff();
$adminCutoffConfig = new Cutoffsetting();
$getAllCutoffSetting = $adminCutoffConfig->getAllCutoffSetting();
$cutoff['id'] = $adminCutoff->getCutoffbyYearMonth()->id;
$cutoff['year'] = $adminCutoff->getCutoffbyYearMonth()->year;
$cutoff['month'] = $adminCutoff->getCutoffbyYearMonth()->month;
$cutoff['type'] = $adminCutoff->getCutoffbyYearMonth()->cutoff_type;
$cutoff['dateFrom'][1] = $adminCutoff->getCutoffbyYearMonth()->cutoff_date_from_1;
$cutoff['dateTo'][1] = $adminCutoff->getCutoffbyYearMonth()->cutoff_date_to_1;
$cutoff['dateFrom'][2] = $adminCutoff->getCutoffbyYearMonth()->cutoff_date_from_2;
$cutoff['dateTo'][2] = $adminCutoff->getCutoffbyYearMonth()->cutoff_date_to_2;
$cutoffConfig['cutoff_type'] = $getAllCutoffSetting[0]->cutoff_type;
$cutoffConfig['cutoff_options'] = $getAllCutoffSetting[0]->cutoff_options;
$currentDate = date('Y-m-d');
$currentMonth = date('M');
$currentCutoff = '';
$getSchedule = '';
if ($cutoff['type'] === 'Monthly') {
// Monthly
} elseif ($cutoff['type'] === 'Semi Monthly') {
if ($cutoffConfig['cutoff_options'] === 1) {
// 1st and 2nd cutoff same within the month
// 1st and 2nd cutoff same within the month
//return 'debug.io';
//exit;
$currentDate = date('Y-m-d');
//1st CutOff - e.g 11-25
$startTime1 = strtotime($cutoff['dateFrom'][1]);
$endTime1 = strtotime($cutoff['dateTo'][1]);
// Loop between timestamps, 1 day at a time
//$cutoffArr1 = array();
$cutoffArr1[] = date('Y-m-d', $startTime1);
do {
$startTime1 = strtotime('+1 day', $startTime1);
$cutoffArr1[] = date('Y-m-d', $startTime1);
} while ($startTime1 < $endTime1);
//return $cutoffArr1;
if (in_array($currentDate, $cutoffArr1)) {
$currentCutoff = 1;
}
//2nd CutOff - e.g 26-10
$startTime2 = strtotime($cutoff['dateFrom'][2]);
$endTime2 = strtotime($cutoff['dateTo'][2]);
// Loop between timestamps, 1 day at a time
//$cutoffArr2 = array();
$cutoffArr2[] = date('Y-m-d', $startTime2);
do {
$startTime2 = strtotime('+1 day', $startTime2);
$cutoffArr2[] = date('Y-m-d', $startTime2);
} while ($startTime2 < $endTime2);
//return dd($cutoffArr2);
if (in_array($currentDate, $cutoffArr2)) {
$currentCutoff = 2;
}
} elseif ($cutoffConfig['cutoff_options'] === 2) {
// 2nd cutoff overlap next month
//http://stackoverflow.com/questions/10633879/current-date-minus-4-month
//http://stackoverflow.com/questions/8912780/get-the-last-day-of-the-month3455634556
//http://www.brightcherry.co.uk/scribbles/php-adding-and-subtracting-dates/
//http://stevekostrey.com/php-dates-add-and-subtract-months-really/
//$lastMonthDays = date('t', strtotime("-1 month"));
//$lastMonth = date('Y-m-d', strtotime("-". $lastMonthDays ."days"));
//$currentDate = strtotime('-1 month' , strtotime($currentDate));
//$currentDate = date('Y-m-d' , $$currentDate);
//1st CutOff - e.g 11-25
$startTime1 = strtotime($cutoff['dateFrom'][1]);
$endTime1 = strtotime($cutoff['dateTo'][1]);
// Loop between timestamps, 1 day at a time
//$cutoffArr1 = array();
$cutoffArr1[] = date('Y-m-d', $startTime1);
do {
$startTime1 = strtotime('+1 day', $startTime1);
$cutoffArr1[] = date('Y-m-d', $startTime1);
} while ($startTime1 < $endTime1);
if (in_array($currentDate, $cutoffArr1)) {
$currentCutoff = 1;
}
// /return $currentMonth.' - '.$cutoff['month'];
//$currentMonth
//$cutoff['month'] = $adminCutoff->getCutoffbyYearMonth()->month;
//$cutoff['type'] = $adminCutoff->getCutoffbyYearMonth()->cutoff_type;
//$cutoff['dateFrom'][1] = $adminCutoff->getCutoffbyYearMonth()->cutoff_date_from_1;
//$cutoff['dateTo'][1] = $adminCutoff->getCutoffbyYearMonth()->cutoff_date_to_1;
//$cutoff['dateFrom'][2] = $adminCutoff->getCutoffbyYearMonth()->cutoff_date_from_2;
//$cutoff['dateTo'][2] = $adminCutoff->getCutoffbyYearMonth()->cutoff_date_to_2;
if (strtotime($currentDate) !== strtotime($cutoff['dateFrom'][1]) || strtotime($currentDate) >= strtotime($cutoff['dateFrom'][1])) {
//$lastMonth = date('M', strtotime('-1 month'));
//$cutoff['month'] = $lastMonth;
/*$cutoff['dateFrom'][2] = strtotime('-1 month' , strtotime($cutoff['dateFrom'][2]));
$cutoff['dateFrom'][2] = date('Y-m-d' , $cutoff['dateFrom'][2]);
$cutoff['dateTo'][2] = strtotime('-1 month' , strtotime($cutoff['dateTo'][2]));
$cutoff['dateTo'][2] = date('Y-m-d' , $cutoff['dateTo'][2]);*/
$cutoff['dateFrom'][2] = $adminCutoff->getCutoffbyYearMonth()->cutoff_date_from_2;
$cutoff['dateTo'][2] = $adminCutoff->getCutoffbyYearMonth()->cutoff_date_to_2;
//return 'true';
}
//return strtotime($currentDate). ' - ' .strtotime($cutoff['dateFrom'][1]);
//die();
//2nd CutOff - e.g 26-10
$startTime2 = strtotime($cutoff['dateFrom'][2]);
$endTime2 = strtotime($cutoff['dateTo'][2]);
// Loop between timestamps, 1 day at a time
//$cutoffArr2 = array();
$cutoffArr2[] = date('Y-m-d', $startTime2);
do {
$startTime2 = strtotime('+1 day', $startTime2);
$cutoffArr2[] = date('Y-m-d', $startTime2);
} while ($startTime2 < $endTime2);
if (in_array($currentDate, $cutoffArr2)) {
$currentCutoff = 2;
}
}
}
/*return $currentCutoff;
die();*/
//return dd( 'Current Cutoff: '. $currentCutoff.' From '.$cutoff['dateFrom'][2] .' - To:'. $cutoff['dateTo'][2] );
//die();
$schedule = new Schedule();
$workShift = new Workshift();
if ($currentCutoff === 1) {
////1st CutOff - e.g 11-25
//Check employee timesheet table if has the current date.
$getDayDateResult = DB::table('employee_timesheet')->where('employee_id', $employeeInfo[0]->id)->where('daydate', $currentDate)->get();
if (empty($getDayDateResult)) {
foreach ($cutoffArr1 as $dayDate) {
//return dd(date('l', strtotime($dayDate)));
$dayOfTheWeek = date('l', strtotime($dayDate));
$checkSchedule = $schedule->checkSchedule($employeeInfo[0]->id, $dayDate);
$getSchedule = $schedule->getSchedule($employeeInfo[0]->id, $dayDate);
//$employeeWorkShift = $workShift->getWorkShiftByEmployeeId($employeeInfo[0]->id);
$getWorkShiftByDayOfTheWeek = $workShift->getWorkShiftByDayOfTheWeek($employeeInfo[0]->id, $dayOfTheWeek, 1);
if ($checkSchedule) {
$schedule['start_time'] = date('H:i:s', strtotime($getSchedule[0]->start_time));
$schedule['end_time'] = date('H:i:s', strtotime($getSchedule[0]->end_time));
} elseif (!$checkSchedule) {
if (!empty($getWorkShiftByDayOfTheWeek)) {
$schedule['start_time'] = date('H:i:s', strtotime($getWorkShiftByDayOfTheWeek[0]->start_time));
$schedule['end_time'] = date('H:i:s', strtotime($getWorkShiftByDayOfTheWeek[0]->end_time));
} else {
$schedule['start_time'] = '';
$schedule['end_time'] = '';
}
}
$timesheetId = DB::table('employee_timesheet')->insertGetId(array('employee_id' => $employeeInfo[0]->id, 'daydate' => $dayDate, 'schedule_in' => $schedule['start_time'], 'schedule_out' => $schedule['end_time'], 'night_shift_time_out' => 0, 'clocking_status' => 'open'));
for ($i = 1; $i <= 3; $i++) {
DB::table('overtime')->insert(array('employee_id' => $employeeInfo[0]->id, 'timesheet_id' => $timesheetId, 'seq_no' => $i, 'shift' => $i));
}
DB::table('employee_summary')->insert(array('employee_id' => $employeeInfo[0]->id, 'daydate' => $dayDate));
}
} else {
foreach ($cutoffArr1 as $dayDate) {
//return 'debug.io';
//return dd(date('l', strtotime($dayDate)));
$dayOfTheWeek = date('l', strtotime($dayDate));
$checkSchedule = $schedule->checkSchedule($employeeInfo[0]->id, $dayDate);
$getSchedule = $schedule->getSchedule($employeeInfo[0]->id, $dayDate);
//$employeeWorkShift = $workShift->getWorkShiftByEmployeeId($employeeInfo[0]->id);
$getWorkShiftByDayOfTheWeek = $workShift->getWorkShiftByDayOfTheWeek($employeeInfo[0]->id, $dayOfTheWeek, 1);
if ($checkSchedule) {
$schedule['start_time'] = date('H:i:s', strtotime($getSchedule[0]->start_time));
$schedule['end_time'] = date('H:i:s', strtotime($getSchedule[0]->end_time));
} elseif (!$checkSchedule) {
if (!empty($getWorkShiftByDayOfTheWeek)) {
$schedule['start_time'] = date('H:i:s', strtotime($getWorkShiftByDayOfTheWeek[0]->start_time));
$schedule['end_time'] = date('H:i:s', strtotime($getWorkShiftByDayOfTheWeek[0]->end_time));
} else {
$schedule['start_time'] = '';
$schedule['end_time'] = '';
}
}
DB::table('employee_timesheet')->where('employee_id', $employeeInfo[0]->id)->where('daydate', $dayDate)->update(array('schedule_in' => $schedule['start_time'], 'schedule_out' => $schedule['end_time']));
}
}
Session::put('debug', 'debug');
//echo Session::get('isLoginCheck');
Session::put('employeesInfo', $employeeInfo);
/*if( !empty($employeeWorkShift) ) {
Session::put('employeeWorkShift', $employeeWorkShift); //check this out
}*/
if (!empty($getWorkShiftByDayOfTheWeek)) {
Session::put('getWorkShiftByDayOfTheWeek', $getWorkShiftByDayOfTheWeek);
//check this out
}
Session::put('dayDateArr', $cutoffArr1);
return Redirect::route('employeeTimesheet');
} elseif ($currentCutoff === 2) {
////1st CutOff - e.g 26-10
//Check employee timesheet table if has the current date.
$getDayDateResult = DB::table('employee_timesheet')->where('employee_id', $employeeInfo[0]->id)->where('daydate', $currentDate)->get();
//return dd($getDayDateResult);
if (empty($getDayDateResult)) {
foreach ($cutoffArr2 as $dayDate) {
//return dd(date('l', strtotime($dayDate)));
$dayOfTheWeek = date('l', strtotime($dayDate));
$checkSchedule = $schedule->checkSchedule($employeeInfo[0]->id, $dayDate);
$getSchedule = $schedule->getSchedule($employeeInfo[0]->id, $dayDate);
//$employeeWorkShift = $workShift->getWorkShiftByEmployeeId($employeeInfo[0]->id);
$getWorkShiftByDayOfTheWeek = $workShift->getWorkShiftByDayOfTheWeek($employeeInfo[0]->id, $dayOfTheWeek, 1);
if ($checkSchedule) {
$schedule['start_time'] = date('H:i:s', strtotime($getSchedule[0]->start_time));
$schedule['end_time'] = date('H:i:s', strtotime($getSchedule[0]->end_time));
} elseif (!$checkSchedule) {
if (!empty($getWorkShiftByDayOfTheWeek)) {
$schedule['start_time'] = date('H:i:s', strtotime($getWorkShiftByDayOfTheWeek[0]->start_time));
$schedule['end_time'] = date('H:i:s', strtotime($getWorkShiftByDayOfTheWeek[0]->end_time));
} else {
$schedule['start_time'] = '';
$schedule['end_time'] = '';
}
}
$timesheetId = DB::table('employee_timesheet')->insertGetId(array('employee_id' => $employeeInfo[0]->id, 'daydate' => $dayDate, 'schedule_in' => $schedule['start_time'], 'schedule_out' => $schedule['end_time'], 'night_shift_time_out' => 0, 'clocking_status' => 'open'));
for ($i = 1; $i <= 3; $i++) {
DB::table('overtime')->insert(array('employee_id' => $employeeInfo[0]->id, 'timesheet_id' => $timesheetId, 'seq_no' => $i, 'shift' => $i));
}
DB::table('employee_summary')->insert(array('employee_id' => $employeeInfo[0]->id, 'daydate' => $dayDate));
}
} else {
foreach ($cutoffArr2 as $dayDate) {
//$getDayDateResult = DB::table('employee_timesheet')->where('employee_id', $employeeInfo[0]->id)->where('daydate', $currentDate)->get();
//return dd($getDayDateResult);
$dayOfTheWeek = date('l', strtotime($dayDate));
$checkSchedule = $schedule->checkSchedule($employeeInfo[0]->id, $dayDate);
$getSchedule = $schedule->getSchedule($employeeInfo[0]->id, $dayDate);
//$employeeWorkShift = $workShift->getWorkShiftByEmployeeId($employeeInfo[0]->id);
$getWorkShiftByDayOfTheWeek = $workShift->getWorkShiftByDayOfTheWeek($employeeInfo[0]->id, $dayOfTheWeek, 1);
if ($checkSchedule) {
$schedule['start_time'] = date('H:i:s', strtotime($getSchedule[0]->start_time));
$schedule['end_time'] = date('H:i:s', strtotime($getSchedule[0]->end_time));
} elseif (!$checkSchedule) {
if (!empty($getWorkShiftByDayOfTheWeek)) {
$schedule['start_time'] = date('H:i:s', strtotime($getWorkShiftByDayOfTheWeek[0]->start_time));
$schedule['end_time'] = date('H:i:s', strtotime($getWorkShiftByDayOfTheWeek[0]->end_time));
} else {
$schedule['start_time'] = '';
$schedule['end_time'] = '';
}
}
DB::table('employee_timesheet')->where('employee_id', $employeeInfo[0]->id)->where('daydate', $dayDate)->update(array('schedule_in' => $schedule['start_time'], 'schedule_out' => $schedule['end_time']));
}
}
Session::put('debug', 'debug');
//echo Session::get('isLoginCheck');
Session::put('employeesInfo', $employeeInfo);
/*if( !empty($employeeWorkShift) ) {
Session::put('employeeWorkShift', $employeeWorkShift); //check this out
}*/
if (!empty($getWorkShiftByDayOfTheWeek)) {
Session::put('getWorkShiftByDayOfTheWeek', $getWorkShiftByDayOfTheWeek);
//check this out
}
Session::put('dayDateArr', $cutoffArr2);
return Redirect::route('employeeTimesheet');
}
//return Redirect::route( 'employeeTimesheet');
}
/*else {
//validation not successful, send back to form
return Redirect::to('users.index'); //Return back to login page
}*/
} catch (Cartalyst\Sentry\Users\LoginRequiredException $e) {
$getMessages = 'Login field is required.';
return Redirect::to('users/login')->withErrors(array('login' => $getMessages));
} catch (Cartalyst\Sentry\Users\PasswordRequiredException $e) {
$getMessages = 'Password field is required.';
return Redirect::to('users/login')->withErrors(array('login' => $getMessages));
} catch (Cartalyst\Sentry\Users\WrongPasswordException $e) {
$getMessages = 'Wrong password, try again.';
return Redirect::to('users/login')->withErrors($getMessages);
} catch (Cartalyst\Sentry\Users\UserNotFoundException $e) {
$getMessages = 'User was not found.';
return Redirect::to('users/login')->withErrors(array('login' => $getMessages));
} catch (Cartalyst\Sentry\Users\UserNotActivatedException $e) {
$getMessages = 'User is not activated.';
return Redirect::to('users/login')->withErrors(array('login' => $getMessages));
}
}