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>
