Example #1
0
@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>
            {{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">&times;</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> 
Example #4
0
   
  <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>
Example #6
0
@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">&times;</button>
            {{Session::get('success')}}
        </div>
        @endif
        <!-- failure message -->
Example #8
0
                                                <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">&times;</button>
            {{Session::get('success')}}
        </div>
        @endif
        <!-- failure message -->
Example #10
0
$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 -->
Example #12
0
						        <!-- 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">