public function index(Holiday $holiday)
{
if (!Entrust::can('manage_holiday')) {
return redirect('/dashboard')->withErrors(config('constants.NA'));
}
$holidays = Holiday::all();
$col_data = array();
$col_heads = array(trans('messages.Option'), trans('messages.Date'), trans('messages.Description'));
$col_heads = Helper::putCustomHeads($this->form, $col_heads);
$col_ids = Helper::getCustomColId($this->form);
$values = Helper::fetchCustomValues($this->form);
foreach ($holidays as $holiday) {
$cols = array('<div class="btn-group btn-group-xs">' . '<a href="/holiday/' . $holiday->id . '/edit" class="btn btn-default btn-xs"> <i class="fa fa-edit"></i></a> ' . delete_form(['holiday.destroy', $holiday->id]) . '</div>', Helper::showDate($holiday->date), $holiday->holiday_description);
$id = $holiday->id;
foreach ($col_ids as $col_id) {
array_push($cols, isset($values[$id][$col_id]) ? $values[$id][$col_id] : '');
}
$col_data[] = $cols;
}
Helper::writeResult($col_data);
$assets = ['mutidatepicker'];
$data = ['col_heads' => $col_heads, 'assets' => $assets];
return view('holiday.index', $data);
}
public function index(Request $request)
{
$start_date = $request->input('start_date') ?: date('Y-m-d', strtotime('-30 days'));
$end_date = $request->input('end_date') ?: date('Y-m-d', strtotime(date('Y-m-d')));
if (Entrust::hasRole('user')) {
return redirect('/')->withErrors(config('constants.NA'));
}
$user_count = \App\User::with('roles')->whereHas('roles', function ($query) {
$query->whereName('user');
})->where('created_at', '>=', $start_date)->where('created_at', '<=', $end_date)->count();
$staff_count = \App\User::with('roles')->whereHas('roles', function ($query) {
$query->where('name', '!=', 'user');
})->where('created_at', '>=', $start_date)->where('created_at', '<=', $end_date)->count();
$ticket_count = \App\Ticket::where('created_at', '>=', $start_date)->where('created_at', '<=', $end_date)->count();
$closed_ticket_count = \App\Ticket::where('ticket_status', '=', 'close')->where('created_at', '>=', $start_date)->where('created_at', '<=', $end_date)->count();
$closed_ticket_percentage = $ticket_count > 0 ? round($closed_ticket_count / $ticket_count * 100, 2) : 0;
$ticket_status_stats = \App\Ticket::select('ticket_status', DB::raw('count(*) as total'))->where('created_at', '>=', $start_date)->where('created_at', '<=', $end_date)->groupBy('ticket_status')->get();
$status_stats = array();
foreach ($ticket_status_stats as $stat) {
$status_stats[] = array('label' => Helper::toWord($stat->ticket_status), 'value' => $stat->total);
}
$ticket_priority_stats = \App\Ticket::select('ticket_priority', DB::raw('count(*) as total'))->where('created_at', '>=', $start_date)->where('created_at', '<=', $end_date)->groupBy('ticket_priority')->get();
$priority_stats = array();
foreach ($ticket_priority_stats as $stat) {
$priority_stats[] = array('label' => Helper::toWord($stat->ticket_priority), 'value' => $stat->total);
}
$ticket_type_status = \App\Ticket::select('ticket_type_id', DB::raw('count(*) as total'))->where('created_at', '>=', $start_date)->where('created_at', '<=', $end_date)->groupBy('ticket_type_id')->get();
$type_stats = array();
foreach ($ticket_type_status as $stat) {
$type_stats[] = array('label' => Helper::toWord($stat->TicketType->ticket_type_name), 'value' => $stat->total);
}
$ticket_department_stats = \App\Ticket::select('department_id', DB::raw('count(*) as total'))->where('created_at', '>=', $start_date)->where('created_at', '<=', $end_date)->groupBy('department_id')->get();
$department_stats = array();
foreach ($ticket_department_stats as $stat) {
$department_stats[] = array('label' => Helper::toWord($stat->Department->department_name), 'value' => $stat->total);
}
$users = \App\User::with('roles')->whereHas('roles', function ($query) {
$query->where('name', '!=', 'user');
})->where('id', '!=', Auth::user()->id)->get();
$user_list = array();
foreach ($users as $user) {
$user_list[$user->id] = $user->name . ' (Department : ' . $user->Profile->Department->department_name . ')';
}
$query = DB::table('activity_log')->join('users', 'users.id', '=', 'activity_log.user_id')->select(DB::raw('name,activity_log.created_at AS created_at,text,user_id'));
if (!Entrust::hasRole('admin')) {
$query->where('user_id', '=', Auth::user()->id);
}
$activities = $query->latest()->limit(100)->get();
$holidays = \App\Holiday::all();
$todos = \App\Todo::where('user_id', '=', Auth::user()->id)->orWhere(function ($query) {
$query->where('user_id', '!=', Auth::user()->id)->where('visibility', '=', 'public');
})->get();
$events = array();
foreach ($holidays as $holiday) {
$start = $holiday->date;
$title = 'Holiday: ' . $holiday->holiday_description;
$color = '#1e5400';
$events[] = array('title' => $title, 'start' => $start, 'color' => $color);
}
foreach ($todos as $todo) {
$start = $todo->date;
$title = 'To do: ' . $todo->todo_title . ' ' . $todo->todo_description;
$color = '#ff0000';
$url = '/todo/' . $todo->id . '/edit';
$events[] = array('title' => $title, 'start' => $start, 'color' => $color, 'url' => $url);
}
$colors = ['#5CB85C', '#FFD600', '#D10D0D', '#1A89E8', '#458b00', '#f85931', '#ce1836', '#009989', '#00688b', '#8b1a1a'];
shuffle($colors);
$status_colors = $colors;
shuffle($colors);
$priority_colors = $colors;
shuffle($colors);
$type_colors = $colors;
shuffle($colors);
$department_colors = $colors;
$assets = ['calendar', 'graph'];
return view('dashboard', compact('user_count', 'staff_count', 'assets', 'activities', 'user_list', 'holidays', 'events', 'ticket_count', 'closed_ticket_percentage', 'status_stats', 'priority_stats', 'type_stats', 'department_stats', 'status_colors', 'priority_colors', 'type_colors', 'department_colors', 'start_date', 'end_date'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$holidays = Holiday::all();
return view('pages.index_holiday', compact('holidays'));
}
public function getHolidays()
{
return Holiday::all();
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$holidays = Holiday::all();
return View('holidays.index')->with('holidays', $holidays);
}