@section('ticket-bar')
active
@stop
@section('overdue')
class="active"
@stop
@section('content')
<?php
if (Auth::user()->role == 'agent') {
$dept = App\Model\helpdesk\Agent\Department::where('name', '=', Auth::user()->primary_dpt)->first();
$tickets = App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->where('dept_id', '=', $dept->id)->orderBy('id', 'DESC')->paginate(20);
} else {
$tickets = App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->orderBy('id', 'DESC')->paginate(20);
}
?>
<!-- Main content -->
<div class="box box-primary">
<div class="box-header with-border">
<h3 class="box-title">Overdue </h3> <small>{!! $tickets->total() !!} tickets</small>
</div><!-- /.box-header -->
@if(Session::has('success'))
<div class="alert alert-success alert-dismissable">
<i class="fa fa-check-circle"> </i>
<b> Success </b>
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
{{Session::get('success')}}
</div>
@endif
<small class="label pull-right bg-green">{{count($myticket) }}</small>
</a>
</li>
<li>
<a href="{{url('unassigned')}}">
<i class="fa fa-th"></i> <span>{!! Lang::get('lang.unassigned') !!}</span>
<small class="label pull-right bg-green">{{count($unassigned)}}</small>
</a>
</li>
<li>
<a href="{{url('trash')}}">
<i class="fa fa-trash-o"></i> <span>{!! Lang::get('lang.trash') !!}</span>
<?php
$deleted = App\Model\helpdesk\Ticket\Tickets::where('status', '5')->get();
?>
<small class="label pull-right bg-green">{{count($deleted)}}</small>
</a>
</li>
<li class="header">{!! Lang::get('lang.Updates') !!}</li>
<li>
<?php
$update = App\Model\helpdesk\Utility\Version_Check::where('id', '=', 1)->first();
if ($update->current_version == $update->new_version) {
?>
<a href="{!! URL::route('checkupdate') !!}" id="checkUpdate">
<span>{!! Lang::get('lang.no_new_updates') !!}!</span><br/>
<br/>
<i class="fa fa-inbox"></i> <span>{!! Lang::get('lang.check_for_updates') !!}.</span>
@stop
@section('content')
<?php
if (Auth::user()->role == 'agent') {
$dept = App\Model\helpdesk\Agent\Department::where('name', '=', Auth::user()->primary_dpt)->first();
$tickets = App\Model\helpdesk\Ticket\Tickets::where('assigned_to', '=', 0)->where('dept_id', '=', $dept->id)->where('status', '1')->orderBy('id', 'DESC')->paginate(20);
} else {
$tickets = App\Model\helpdesk\Ticket\Tickets::where('assigned_to', '=', 0)->where('status', '1')->orderBy('id', 'DESC')->paginate(20);
}
?>
<!-- Main content -->
<div class="box box-info">
<div class="box-header with-border">
<?php
$counted = count(App\Model\helpdesk\Ticket\Tickets::where('assigned_to', '=', 0)->get());
?>
<h3 class="box-title">{!! Lang::get('lang.unassigned') !!} </h3> <small id="title_refresh"> {!! $tickets->total() !!} {!! Lang::get('lang.tickets') !!}</small>
</div><!-- /.box-header -->
@if(Session::has('success'))
<div class="alert alert-success alert-dismissable">
<i class="fa fa-check-circle"> </i>
<b> Success </b>
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
{{Session::get('success')}}
</div>
@endif
<!-- failure message -->
@if(Session::has('fails'))
<div class="alert alert-danger alert-dismissable">
<i class="fa fa-ban"> </i>
<tr>
<td colspan="2" bgcolor="#FFFFFF">
<!-- Start - Quick overview table -->
<!-- Quick overview table title -->
<p style="padding: 25px 0px 20px 0px; margin: 0; font-size: 18px; color: #333; font-weight: bold; font-family: Arial, Helvetica, sans-serif; text-align: center;">
Overview
</p>
<?php
foreach ($depts as $dept) {
$created = DB::table('tickets')->select('created_at')->where('dept_id', '=', $dept->id)->where('team_id', '=', $team_id)->where('created_at', 'LIKE', '%' . $day1 . '%')->count();
$closed = DB::table('tickets')->where('dept_id', '=', $dept->id)->where('team_id', '=', $team_id)->where('closed_at', 'LIKE', '%' . $day1 . '%')->count();
$inprogress = App\Model\helpdesk\Ticket\Tickets::where('dept_id', '=', $dept->id)->where('team_id', '=', $team_id)->where('status', '=', 1)->count();
$overdues = App\Model\helpdesk\Ticket\Tickets::where('dept_id', '=', $dept->id)->where('team_id', '=', $team_id)->where('status', '=', 1)->get();
$i = 0;
foreach ($overdues as $overdue) {
$sla_plan = App\Model\helpdesk\Manage\Sla_plan::where('id', '=', $overdue->sla)->first();
$ovdate = $overdue->created_at;
$new_date = date_add($ovdate, date_interval_create_from_date_string($sla_plan->grace_period)) . '<br/><br/>';
if (date('Y-m-d H:i:s') > $new_date) {
$i++;
}
}
?>
<!-- Overview Table -->
<table align="center" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #333;" width="500" border="0" cellspacing="0" cellpadding="10">
<tr >
<td align="center" bgcolor="#FFF2D9" colspan="2" style="border: 1px solid #F1DDDD; ">
<span style="font-size: 18px; color: #158CCA;"><strong>{!! $dept->name !!}</strong></span>
<th>{!! Lang::get('lang.department') !!}</th>
<th>{!! Lang::get('lang.opened') !!}</th>
<th>{!! Lang::get('lang.resolved') !!}</th>
<th>{!! Lang::get('lang.closed') !!}</th>
<th>{!! Lang::get('lang.deleted') !!}</th>
</tr>
<?php
$departments = App\Model\helpdesk\Agent\Department::all();
?>
@foreach($departments as $department)
<?php
$open = App\Model\helpdesk\Ticket\Tickets::where('dept_id', '=', $department->id)->where('status', '=', 1)->count();
$resolve = App\Model\helpdesk\Ticket\Tickets::where('dept_id', '=', $department->id)->where('status', '=', 2)->count();
$close = App\Model\helpdesk\Ticket\Tickets::where('dept_id', '=', $department->id)->where('status', '=', 3)->count();
$delete = App\Model\helpdesk\Ticket\Tickets::where('dept_id', '=', $department->id)->where('status', '=', 5)->count();
?>
<tr>
<td>{!! $department->name !!}</td>
<td>{!! $open !!}</td>
<td>{!! $resolve !!}</td>
<td>{!! $close !!}</td>
<td>{!! $delete !!}</td>
</tr>
@endforeach
</table>
</div>
</div>
@section('ticket-bar')
active
@stop
@section('open')
class="active"
@stop
@section('content')
<?php
if (Auth::user()->role == 'agent') {
$dept = App\Model\helpdesk\Agent\Department::where('name', '=', Auth::user()->primary_dpt)->first();
$tickets = App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->where('isanswered', '=', 0)->where('assigned_to', '=', 0)->where('dept_id', '=', $dept->id)->orderBy('id', 'DESC')->paginate(20);
} else {
$tickets = App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->where('isanswered', '=', 0)->where('assigned_to', '=', 0)->orderBy('id', 'DESC')->paginate(20);
}
?>
<!-- Main content -->
<div class="box box-primary">
<div class="box-header with-border">
<h3 class="box-title">{!! Lang::get('lang.open') !!} </h3> <small id="title_refresh">{!! $tickets->total() !!} {!! Lang::get('lang.tickets') !!}</small>
<div class="box-tools pull-right">
<div class="has-feedback">
</div>
</div>
</div><!-- /.box-header -->
@if(Session::has('success'))
<div class="alert alert-success alert-dismissable">
<i class="fa fa-check-circle"> </i> <b> Success </b>
@section('ticket-bar')
active
@stop
@section('inbox')
class="active"
@stop
@section('content')
<?php
$dept = App\Model\helpdesk\Agent\Department::where('name', '=', $id)->first();
if (Auth::user()->role == 'agent') {
$tickets = App\Model\helpdesk\Ticket\Tickets::where('status', '=', '2')->where('dept_id', '=', $dept->id)->orderBy('id', 'DESC')->paginate(20);
} else {
$tickets = App\Model\helpdesk\Ticket\Tickets::where('status', '=', '2')->where('dept_id', '=', $dept->id)->orderBy('id', 'DESC')->paginate(20);
}
?>
<!-- Main content -->
<div class="box box-primary">
<div class="box-header with-border">
<h3 class="box-title">Inbox </h3> <small>{!! $tickets->total() !!} tickets</small>
</div><!-- /.box-header -->
@if(Session::has('success'))
<div class="alert alert-success alert-dismissable">
<i class="fa fa-check-circle"> </i> <b> Success </b>
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
{{Session::get('success')}}
</div>
@endif
<!-- failure message -->
<i class="fa fa-trash-o"></i> <span>{!! Lang::get('lang.trash') !!}</span>
<?php
$deleted = App\Model\helpdesk\Ticket\Tickets::where('status', '5')->get();
?>
<small class="label pull-right bg-green">{{count($deleted)}}</small>
</a>
</li>
<li class="header">{!! Lang::get('lang.Departments') !!}</li>
<?php
$depts = App\Model\helpdesk\Agent\Department::all();
foreach ($depts as $dept) {
$open = App\Model\helpdesk\Ticket\Tickets::where('status', '=', '1')->where('assigned_to', '=', 0)->where('dept_id', '=', $dept->id)->get();
$open = count($open);
$underprocess = App\Model\helpdesk\Ticket\Tickets::where('status', '=', '1')->where('assigned_to', '>', 0)->where('dept_id', '=', $dept->id)->get();
$underprocess = count($underprocess);
$closed = App\Model\helpdesk\Ticket\Tickets::where('status', '=', '2')->where('dept_id', '=', $dept->id)->get();
$closed = count($closed);
// $underprocess = 0;
// foreach ($inbox as $ticket4) {
// if ($ticket4->assigned_to == null) {
// } else {
// $underprocess++;
// }
// }
if (Auth::user()->role == 'admin') {
?>
<li class="treeview">
<a href="#">
<i class="fa fa-folder-open"></i> <span>{!! $dept->name !!}</span> <i class="fa fa-angle-left pull-right"></i>
</a>
<ul class="treeview-menu">
@section('ticket-bar')
active
@stop
@section('myticket')
class="active"
@stop
@section('content')
<?php
if (Auth::user()->role == 'agent') {
$dept = App\Model\helpdesk\Agent\Department::where('name', '=', Auth::user()->primary_dpt)->first();
$tickets = App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->where('assigned_to', '=', Auth::user()->id)->orderBy('id', 'ASC')->paginate(20);
} else {
$tickets = App\Model\helpdesk\Ticket\Tickets::where('status', '=', 1)->where('assigned_to', '=', Auth::user()->id)->orderBy('id', 'ASC')->paginate(20);
}
?>
<!-- Main content -->
<div class="box box-primary">
<div class="box-header with-border">
<h3 class="box-title">{!! Lang::get('lang.my_tickets') !!}</h3> <small id="title_refresh">{!! $tickets->total() !!} {!! Lang::get('lang.tickets') !!}</small>
</div><!-- /.box-header -->
@if(Session::has('success'))
<div class="alert alert-success alert-dismissable">
<i class="fa fa-check-circle"> </i> <b> Success </b>
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
{{Session::get('success')}}
</div>
@endif
<!-- failure message -->
$deleted = App\Model\helpdesk\Ticket\Tickets::where('status', '5')->get();
?>
<small class="label pull-right bg-green">{{count($deleted)}}</small>
</a>
</li>
<li class="header">DEPARTMENTS</li>
<?php
$depts = App\Model\helpdesk\Agent\Department::all();
foreach ($depts as $dept) {
$open = App\Model\helpdesk\Ticket\Tickets::where('status', '=', '1')->where('dept_id', '=', $dept->id)->get();
$open = count($open);
// dd($open);
$closed = App\Model\helpdesk\Ticket\Tickets::where('status', '=', '2' || '3')->where('dept_id', '=', $dept->id)->get();
$closed = count($closed);
// dd($closed);
$underprocess = App\Model\helpdesk\Ticket\Tickets::where('status', '=', '2' || '3')->where('assigned_to', '=', '0')->get();
$underprocess = count($underprocess);
// dd($underprocess);
$underprocess = 0;
foreach ($inbox as $ticket4) {
if ($ticket4->assigned_to == null) {
} else {
$underprocess++;
}
}
if (Auth::user()->role == 'admin') {
?>
<li class="treeview">
<a href="#">
<i class="fa fa-folder-open"></i> <span>{!! $dept->name !!}</span> <i class="fa fa-angle-left pull-right"></i>
</a>
<li class="active"><a href="{!! URL::route('ticket2') !!}">{!! Lang::get('lang.my_tickets') !!}</a></li>
</ol>
</div>
@stop
@section('myticket')
class="active"
@stop
@section('content')
<!-- Main content -->
<div id="content" class="site-content col-md-12">
<?php
$open = App\Model\helpdesk\Ticket\Tickets::where('user_id', '=', Auth::user()->id)->where('status', '=', 1)->orderBy('id', 'DESC')->paginate(20);
?>
<?php
$close = App\Model\helpdesk\Ticket\Tickets::where('user_id', '=', Auth::user()->id)->whereIn('status', [2, 3])->orderBy('id', 'DESC')->paginate(20);
?>
<div class="nav-tabs-custom">
<ul class="nav nav-tabs">
<li class="active"><a href="#tab_1" data-toggle="tab" aria-expanded="true">{!! Lang::get('lang.opened') !!} <small class="label bg-orange">{!! $open->total() !!}</small></a></li>
<li class=""><a href="#tab_2" data-toggle="tab" aria-expanded="false">{!! Lang::get('lang.closed') !!} <small class="label bg-green">{!! $close->total() !!}</small></a></li>
</ul>
<div class="tab-content">
<div class="tab-pane active" id="tab_1">
{!! Form::open(['route'=>'select_all','method'=>'post']) !!}
<div class="mailbox-controls">
<!-- Check all button -->
<!-- table -->
<table class="table table-hover table-striped">
<thead>
<th>
</th>
<th>{!! Lang::get('lang.subject') !!}</th>
<th>{!! Lang::get('lang.ticket_id') !!}</th>
<th>{!! Lang::get('lang.priority') !!}</th>
<th>{!! Lang::get('lang.from') !!}</th>
<th>{!! Lang::get('lang.last_replier') !!}</th>
<th>{!! Lang::get('lang.assigned_to') !!}</th>
<th>{!! Lang::get('lang.last_activity') !!}</th>
</thead>
<tbody id="hello">
<?php
$tickets = App\Model\helpdesk\Ticket\Tickets::where('user_id', '=', $users->id)->where('status', '=', '5')->orderBy('id', 'DESC')->paginate(20);
?>
@foreach ($tickets as $ticket)
<tr <?php
if ($ticket->seen_by == null) {
?>
style="color:green;" <?php
}
?>
>
<td ><input type="checkbox" class="icheckbox_flat-blue" name="select_all[]" value="{{$ticket->id}}"/></td>
<?php
// collaborators
$collaborators = App\Model\helpdesk\Ticket\Ticket_Collaborator::where('ticket_id', '=', $ticket->id)->get();
$collab = count($collaborators);
// title
@stop
@section('breadcrumb')
<div class="site-hero clearfix">
<ol class="breadcrumb breadcrumb-custom">
<li class="text">{!! Lang::get('lang.you_are_here') !!}: </li>
<li><a href="#">{!! Lang::get('lang.home') !!}</a></li>
<li class="active">{!! Lang::get('lang.ticket_status') !!}</li>
</ol>
</div>
@stop
@section('content')
<?php
$tickets = App\Model\helpdesk\Ticket\Tickets::where('id', '=', \Crypt::decrypt($id))->first();
$thread = App\Model\helpdesk\Ticket\Ticket_Thread::where('ticket_id', '=', \Crypt::decrypt($id))->first();
//$user = App\User::where('id','=',$id1)->first();
?>
<!-- Main content -->
<div class="box box-primary">
<div class="box-header">
<section class="content-header"><h3 class="box-title"><i class="fa fa-user"> </i> {{$thread->title}} </h3> ( {{$tickets->ticket_number}} )
</section>
<div class="pull-right">
<!-- <button type="button" class="btn btn-default"><i class="fa fa-edit" style="color:green;"> </i> Edit</button> -->
{{-- <button type="button" class="btn btn-default"><i class="fa fa-print" style="color:blue;"> </i> {!! link_to_route('ticket.print','Print',[$tickets->id]) !!}</button> --}}
<!-- </div> -->
<div class="btn-group">