SUM(regular) as regular, SUM(regular_overtime) as regular_overtime, SUM(regular_overtime_night_diff) as regular_overtime_night_diff, SUM(regular_night_differential) as regular_night_differential, SUM(rest_day) as rest_day, SUM(rest_day_overtime) as rest_day_overtime, SUM(rest_day_overtime_night_diff) as rest_day_overtime_night_diff, SUM(rest_day_night_differential) as rest_day_night_differential, SUM(rest_day_special_holiday) as rest_day_special_holiday, SUM(rest_day_special_holiday_overtime) as rest_day_special_holiday_overtime, SUM(rest_day_special_holiday_overtime_night_diff) as rest_day_special_holiday_overtime_night_diff, SUM(rest_day_special_holiday_night_diff) as rest_day_special_holiday_night_diff, SUM(rest_day_legal_holiday) as rest_day_legal_holiday, SUM(rest_day_legal_holiday_overtime) as rest_day_legal_holiday_overtime, SUM(rest_day_legal_holiday_overtime_night_diff) as rest_day_legal_holiday_overtime_night_diff, SUM(rest_day_legal_holiday_night_diff) as rest_day_legal_holiday_night_diff, SUM(special_holiday) as special_holiday, SUM(special_holiday_overtime) as special_holiday_overtime, SUM(special_holiday_overtime_night_diff) as special_holiday_overtime_night_diff, SUM(special_holiday_night_diff) as special_holiday_night_diff, SUM(legal_holiday) as legal_holiday, SUM(legal_holiday_overtime) as legal_holiday_overtime, SUM(legal_holiday_overtime_night_diff) as legal_holiday_overtime_night_diff, SUM(legal_holiday_night_diff) as legal_holiday_night_diff'))->where('employee_id', $employeeId)->whereBetween('daydate', [$cutOffDateFrom, $cutOffDateTo])->first(); //dd($summary); $userGroups = DB::table('users_groups')->where('user_id', $userId)->first(); //$userGroups = DB::table('users_groups')->where('user_id', Auth::user()->id)->first(); if (!empty($userGroups)) { $groups = DB::table('groups')->where('id', (int) $userGroups->group_id)->first(); } $currentUser = Sentry::getUser(); //$employeeId = Session::get('userEmployeeId'); //$employeeInfo[0]->id $company = Company::find($employeeInfo[0]->company_id); $department = Department::find($employeeInfo[0]->department_id); $jobTitle = JobTitle::find($employeeInfo[0]->position_id); $manager = ''; $manager = Employee::where('id', '=', $employeeInfo[0]->manager_id)->first(); if (!empty($manager)) { $managerFullname = $manager->firstname . ', ' . $manager->lastname; } else { $managerFullname = ''; } $employees = DB::table('employees')->where('manager_id', $employeeInfo[0]->id)->orWhere('supervisor_id', $employeeInfo[0]->id)->get(); $employeeArr[0] = ''; foreach ($employees as $employee) { $employeeArr[$employee->id] = $employee->firstname . ', ' . $employee->lastname; } //$getSchedule = DB::table('employee_schedule')->where('employee_id', $employee->id)->where('schedule_date', trim($currentDate))->get(); //$getWorkShiftByDayOfTheWeek = DB::table('work_shift')->where('employee_id', $employee->id)->where('name_of_day', $dayOfTheWeek)->where('shift', $shift)->get(); ?>
@extends('layouts.admin.default') @section('content') <?php $jobTitleCount = JobTitle::count(); $jobTitles = JobTitle::paginate(10); $jobTitleDelete = JobTitle::find($id); $message = Session::get('message'); ?> <div class="page-container"> <div class="row" style="padding-bottom:20px;"> <div class="col-md-2 clearfix"> <aside class="sidebar"> <nav class="sidebar-nav"> <ul id="menu"> <li> <a href="{{ url('/admin/dashboard') }}"> <span class="sidebar-nav-item-icon fa fa-tachometer fa-lg"></span> <span class="sidebar-nav-item">Dashboard</span> </a> </li> <li> <a href="#"> <span class="sidebar-nav-item-icon fa fa-users fa-lg"></span> <span class="sidebar-nav-item">Employees</span>
})); //DELETE: EXISTING COMPANY Route::get('/admin/jobtitle/delete/{id}', array('as' => 'adminDeleteJobTitle', 'uses' => function ($id) { $id = (int) $id; $employeeId = Session::get('userEmployeeId'); $userId = Session::get('userId'); $employee = new Employee(); $employeeInfo = $employee->getEmployeeInfoById($employeeId); //return 'Update Company'; return View::make('admin.jobtitledelete', array('id' => $id, 'employeeInfo' => $employeeInfo)); })); //DELETE: EXISTING COMPANY Route::post('/admin/jobtitle/delete/{id}', array('as' => 'adminProcessDeleteJobTitle', 'uses' => function ($id) { $data = Input::all(); $id = (int) $id; $JobTitle = JobTitle::find($id); if ($JobTitle->delete()) { $message = 'Deleted Successfully.'; return Redirect::route('adminNewJobTitle')->with('message', $message); } })); //----------------------- Ibyang's Routes ------------------------ // //routes for Group Module //route to edit group details page Route::get('/editgroup/{id}', 'GroupController@editgroup'); //route for delete groups page Route::delete('/destroygroup/{id}', 'GroupController@destroygroup'); Route::get('/getGroups', 'GroupController@index'); Route::post('/createGroup', 'GroupController@handleCreate'); Route::get('/getGroup', 'GroupController@createGroup'); //routes for Permissions Module
@extends('layouts.admin.default') @section('content') <?php $jobTitleCount = JobTitle::count(); $jobTitles = JobTitle::paginate(10); $jobTitleEdit = JobTitle::find($id); $message = Session::get('message'); ?> <div class="page-container"> <div class="row" style="padding-bottom:20px;"> <div class="col-md-2 clearfix"> <aside class="sidebar"> <nav class="sidebar-nav"> <ul id="menu"> <li> <a href="{{ url('/admin/dashboard') }}"> <span class="sidebar-nav-item-icon fa fa-tachometer fa-lg"></span> <span class="sidebar-nav-item">Dashboard</span> </a> </li> <li> <a href="#"> <span class="sidebar-nav-item-icon fa fa-users fa-lg"></span> <span class="sidebar-nav-item">Employees</span>