Esempio n. 1
0
@section('Tickets')
class="active"
@stop

@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">&times;</button>
Esempio n. 2
0
@section('Tickets')
class="active"
@stop

@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">&times;</button>
Esempio n. 3
0
		<td>
			@if($topic->type=='1')
				<span style="color:green">Public</span>
			@else
				<span style="color:red">Private</span>
			@endif
		</td>
		<!-- Priority -->
<?php 
$priority = App\Model\helpdesk\Ticket\Ticket_Priority::where('priority_id', '=', $topic->priority)->first();
?>
		<td>{!! $priority->priority_desc !!}</td>
		<!-- Department -->
<?php 
$dept = App\Model\helpdesk\Agent\Department::where('id', '=', $topic->department)->first();
?>
		<td>{!! $dept->name !!}</td>
		<!-- Last Updated -->
		<td> {!! UTC::usertimezone($topic->updated_at) !!} </td>
		<!-- Deleting Fields -->
		<td>
			{!! Form::open(['route'=>['helptopic.destroy', $topic->id],'method'=>'DELETE']) !!}
			<a href="{{route('helptopic.edit',$topic->id)}}" class="btn btn-info btn-xs btn-flat"><i class="fa fa-trash" style="color:black;"> </i> Edit</a>
				<!-- To pop up a confirm Message -->
				{!! Form::button('<i class="fa fa-trash" style="color:black;"> </i> Delete',
					['type' => 'submit',
					'class'=> 'btn btn-warning btn-xs btn-flat',
					'onclick'=>'return confirm("Are you sure?")'])
				!!}
Esempio n. 4
0
<?php

$date = Date('d-m-Y');
$format = 'Y-m-d';
$day1 = Date($format, strtotime('-1 day' . $date));
$user = App\User::where('id', '=', $user_id)->first();
$dept = App\Model\helpdesk\Agent\Department::where('id', '=', $user->primary_dpt)->first();
$created = DB::table('tickets')->select('created_at')->where('dept_id', '=', $dept->id)->where('created_at', 'LIKE', '%' . $day1 . '%')->count();
$closed = DB::table('tickets')->where('dept_id', '=', $dept->id)->where('closed_at', 'LIKE', '%' . $day1 . '%')->count();
$inprogress = App\Model\helpdesk\Ticket\Tickets::where('dept_id', '=', $dept->id)->where('status', '=', 1)->count();
$overdues = App\Model\helpdesk\Ticket\Tickets::where('dept_id', '=', $dept->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++;
    }
}
// echo "created=".$created."<br/>";
// echo "closed=".$closed."<br/>";
// echo "inprogress=".$inprogress."<br/>";
// echo "overdue=".$i."<br/>";
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>SmoothDeal</title>
Esempio n. 5
0
							<th width="100px">{{Lang::get('lang.priority')}}</th>
							<th width="100px">{{Lang::get('lang.department')}}</th>
							<th width="100px">{{Lang::get('lang.created')}}</th>
							<th width="100px">{{Lang::get('lang.last_updated')}}</th>
							<th width="100px">{{Lang::get('lang.action')}}</th>
						</tr>
						@foreach($emails as $email)
						<tr>
							<td><a href="{{route('emails.edit', $email->id)}}"> {{$email -> email_address }}</a></td>
							<?php 
$priority = App\Model\helpdesk\Ticket\Ticket_Priority::where('priority_id', '=', $email->priority)->first();
?>
							<td>{{  ucfirst($priority->priority_desc) }}</td>
							@if($email->department !== null)
								<?php 
$department = App\Model\helpdesk\Agent\Department::where('id', '=', $email->department)->first();
$dept = $department->name;
?>
							@elseif($email->department == null)
								<?php 
$dept = "";
?>
							@endif
							
							<td>{{ $dept }}</td>
							<td>{{ UTC::usertimezone($email->created_at) }}</td>
							<td>{{ UTC::usertimezone($email->updated_at) }}</td>
							<td>
							{!! Form::open(['route'=>['emails.destroy', $email->id],'method'=>'DELETE']) !!}
							<a href="{{route('emails.edit', $email->id)}}" class="btn btn-info btn-xs btn-flat"><i class="fa fa-edit" style="color:black;"> </i> Edit</a>
							<!-- To pop up a confirm Message -->