public function all()
 {
     if (\KodeInfo\Utilities\Utils::isDepartmentAdmin(Auth::user()->id)) {
         $department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
         $department = Department::where('id', $department_admin->department_id)->first();
         $company = Company::where('id', $department->company_id)->first();
         $messages = CannedMessages::where('company_id', $company->id)->where('department_id', $department->id)->orderBy('id', 'desc')->get();
     } elseif (\KodeInfo\Utilities\Utils::isOperator(Auth::user()->id)) {
         $department_admin = OperatorsDepartment::where('user_id', Auth::user()->id)->first();
         $department = Department::where('id', $department_admin->department_id)->first();
         $company = Company::where('id', $department->company_id)->first();
         $messages = CannedMessages::where('company_id', $company->id)->where('department_id', $department->id)->where('operator_id', Auth::user()->id)->orderBy('id', 'desc')->get();
     } else {
         $messages = CannedMessages::orderBy('id', 'desc')->get();
     }
     foreach ($messages as $message) {
         $operator = User::find($message->operator_id);
         $department = Department::find($message->department_id);
         $company = Company::find($message->company_id);
         $message->operator = $operator;
         $message->department = $department;
         $message->company = $company;
     }
     $this->data['messages'] = $messages;
     return View::make('canned_messages.all', $this->data);
 }
 public function account()
 {
     $doctor = Doctor::where('user_id', Session::get('user.id'))->first();
     $hospital_id = $doctor->department->hospital_id;
     $default_department = $doctor->department_id;
     $departments = Department::where('hospital_id', $hospital_id)->get();
     $render_data = array('name' => $doctor->name, 'photo' => $doctor->photo, 'title' => $doctor->title, 'specialty' => strip_tags($doctor->specialty), 'description' => strip_tags($doctor->description), 'default_department' => $doctor->department_id, 'departments' => $departments, 'top_photo' => Session::get('doctor.photo'));
     return View::make('doctor.account', $render_data);
 }
function department_list($id = null)
{
    if ($id) {
        $dept = new Department($id);
        $list = new Department();
        $list->where('parent_id', $id);
        $list->order_by('orders', 'asc');
        $list->get();
        child_personnel(0, $id, $dept->title);
        foreach ($list as $key_tmp => $tmp) {
            department_list($tmp->id);
        }
    }
}
Exemple #4
0
 static function getUniCompany()
 {
     $company_id = 0;
     if (\KodeInfo\Utilities\Utils::isDepartmentAdmin(Auth::user()->id)) {
         $department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
         $department = Department::where('id', $department_admin->department_id)->first();
         $company_id = $department->company_id;
     } elseif (\KodeInfo\Utilities\Utils::isOperator(Auth::user()->id)) {
         $department_admin = OperatorsDepartment::where('user_id', Auth::user()->id)->first();
         $department = Department::where('id', $department_admin->department_id)->first();
         $company_id = $department->company_id;
     }
     return $company_id;
 }
 public function getProfile()
 {
     if (Auth::check()) {
         $title = "Cambiar Perfil";
         $department = Department::all();
         $user = User::where('id', '=', Auth::id())->first();
         $id = $user->state;
         $userDep = Department::where('id', '=', $id)->pluck('nombre');
         if (!empty($user) && $user != "" && !is_null($user)) {
             return View::make('user.profile')->with('title', $title)->with('user', $user)->with('department', $department)->with('userDep', $userDep);
         }
     } else {
         Session::flash('error', 'Debe iniciar sesión para acceder a esta área');
         return Redirect::to('inicio/login');
     }
 }
 /**
  * Update the department
  *
  * @param $id
  */
 public function updateAction($id)
 {
     $department = Department::find($id);
     $validation = Validator::make(Input::all(), Department::$rules);
     if (!$validation->passes()) {
         return Redirect::route('departments.edit', $id)->withInput()->withErrors($validation)->with('message', 'There were validation errors.');
     }
     /**
      * Check name duplicates
      */
     if (count(Department::where('name', Input::get('name'))->where('id', '!=', $id)->get())) {
         return Redirect::route('departments.edit', $id)->withInput()->with('message', 'This department already exists.');
     }
     $department->update(Input::all());
     $department->save();
     return Redirect::route('departments.show', $id);
 }
 static function getUpdatedFields($is_fake = false, $ticket_id = 0, $msg_id = 0)
 {
     if (!$is_fake) {
         $ticket = Tickets::where('id', $ticket_id)->first();
         $thread_message = ThreadMessages::where('id', $msg_id)->first();
         $ticket_attachment = TicketAttachments::where('message_id', $msg_id)->first();
         $customer = User::where('id', $ticket->customer_id)->first();
         $operator = User::where('id', $ticket->operator_id)->first();
         $company = Company::where('id', $ticket->company_id)->first();
         $department = Department::where('id', $ticket->department_id)->first();
         $receiver = Input::get('user_id') == $ticket->operator_id ? $customer : $operator;
         $mailer_extra = ['ticket_id' => $ticket->id, 'ticket_subject' => $ticket->subject, 'ticket_description' => $ticket->description, 'ticket_status' => $ticket->status, 'ticket_status_txt' => self::resolveStatus($ticket->status), 'ticket_priority' => $ticket->priority, 'ticket_priority_txt' => self::resolveStatus($ticket->priority), 'company_name' => $company->name, 'company_description' => $company->description, 'company_domain' => $company->domain, 'company_logo' => $company->logo, 'department_name' => $department->name, 'has_attachment' => $ticket_attachment->has_attachment, 'attachment_path' => $ticket_attachment->attachment_path, 'updated_message' => $thread_message->message, 'receiver_name' => $receiver->name, 'receiver_email' => $receiver->email];
     } else {
         $mailer_extra = ['ticket_id' => 1, 'ticket_subject' => "How can i use contact us form", 'ticket_description' => "Hi , Sir how can i use contact us form", 'ticket_status' => 1, 'ticket_status_txt' => self::resolveStatus(1), 'ticket_priority' => 1, 'ticket_priority_txt' => self::resolveStatus(1), 'company_name' => "KODEINFO", 'company_description' => "We are a small and dedicated team of designers/developers. This is our web design and development focused blog.We focus on pushing the boundaries of standards based web technologies.", 'company_domain' => "http://www.kodeinfo.com", 'company_logo' => "http://kodeinfo.com/img/shortlogo.png", 'department_name' => "General Queries", 'has_attachment' => false, 'attachment_path' => "", 'updated_message' => "This is a updated message from customer/operator", 'receiver_name' => "Imran", 'receiver_email' => "*****@*****.**"];
     }
     return $mailer_extra;
 }
 /**
  * Store a newly created resource in storage.
  * POST /department
  *
  * @return Response
  */
 public function store()
 {
     $validator = Validator::make(Input::all(), Department::$rules);
     $row = Department::where('id_dept', '=', Input::get('id_dept'));
     if ($validator->fails()) {
         return Redirect::to('department')->withErrors($validator)->withInput(Input::all());
     } else {
         if (Department::where('id_dept', '=', Input::get('id_dept'))->exists()) {
             $department = Department::find(Input::get('id_dept'));
             $department->nm_dept = Input::get('nm_dept');
             $department->save();
             Session::flash('message', 'Successfully updated Department!');
             return Redirect::to('department');
         } else {
             $department = new Department();
             $department->id_dept = Input::get('id_dept');
             $department->nm_dept = Input::get('nm_dept');
             $department->save();
             Session::flash('message', 'Successfully created Department!');
             return Redirect::to('department');
         }
     }
     //
 }
 public function ticketsRefresh()
 {
     if (Input::get('company_id', 0) > 0 && Input::get('department_id', 0) > 0) {
         $tickets = Tickets::orderBy('priority', 'desc')->where('company_id', Input::get('company_id'))->where('department_id', Input::get('department_id'))->get();
     } else {
         $tickets = Tickets::orderBy('priority', 'desc')->get();
     }
     $tickets_arr = [];
     foreach ($tickets as $ticket) {
         $ticket->customer = User::where('id', $ticket->customer_id)->first();
         $ticket->company = Company::where('id', $ticket->company_id)->first();
         $ticket->department = Department::where('id', $ticket->department_id)->first();
         if ($ticket->operator_id > 0) {
             $ticket->operator = User::where('id', $ticket->operator_id)->first();
         }
         $single_ticket = [];
         $single_ticket[] = $ticket->id;
         $single_ticket[] = isset($ticket->company) ? $ticket->company->name : trans('msgs.none');
         $single_ticket[] = isset($ticket->department) ? $ticket->department->name : trans('msgs.none');
         $single_ticket[] = isset($ticket->customer) ? $ticket->customer->name : trans('msgs.none');
         $single_ticket[] = isset($ticket->customer) ? $ticket->customer->email : trans('msgs.none');
         $single_ticket[] = $ticket->subject;
         $single_ticket[] = isset($ticket->operator) ? $ticket->operator->name : trans('msgs.none');
         if ($ticket->priority == Tickets::PRIORITY_LOW) {
             $single_ticket[] = '<td ><label class="label label-primary" > ' . trans("msgs.low") . ' </label ></td >';
         }
         if ($ticket->priority == Tickets::PRIORITY_MEDIUM) {
             $single_ticket[] = '<td><label class="label label-primary">' . trans("msgs.medium") . '</label></td>';
         }
         if ($ticket->priority == Tickets::PRIORITY_HIGH) {
             $single_ticket[] = '<td><label class="label label-warning">' . trans("msgs.high") . '</label></td>';
         }
         if ($ticket->priority == Tickets::PRIORITY_URGENT) {
             $single_ticket[] = '<td><label class="label label-danger">' . trans("msgs.urgent") . '</label></td>';
         }
         if ($ticket->status == Tickets::TICKET_NEW) {
             $single_ticket[] = '<td><label class="label label-warning">' . trans("msgs.new") . '</label></td>';
         }
         if ($ticket->status == Tickets::TICKET_PENDING) {
             $single_ticket[] = '<td><label class="label label-primary">' . trans("msgs.pending") . '</label></td>';
         }
         if ($ticket->status == Tickets::TICKET_RESOLVED) {
             $single_ticket[] = '<td><label class="label label-success">' . trans("msgs.resolved") . '</label></td>';
         }
         if (!isset($ticket->operator)) {
             $single_ticket[] = '<td><a href="/tickets/read/' . $ticket->thread_id . '" class="btn btn-success btn-sm"> <i class="icon-checkmark4"></i> ' . trans("msgs.accept") . ' </a></td>';
         }
         if (isset($ticket->operator) && $ticket->operator->id == Auth::user()->id) {
             $single_ticket[] = '<td><a href="/tickets/read/' . $ticket->thread_id . '" class="btn btn-success btn-sm"> <i class="icon-checkmark4"></i> ' . trans("msgs.reply") . ' </a></td>';
         }
         if (isset($ticket->operator) && $ticket->operator->id != Auth::user()->id) {
             $single_ticket[] = '<td><a disabled class="btn btn-success btn-sm"> <i class="icon-lock3"></i> ' . trans("msgs.accept") . ' </a></td>';
         }
         $single_ticket[] = '<td><a href="/tickets/transfer/' . $ticket->id . '" class="btn btn-warning btn-sm"> <i class="icon-share3"></i> ' . trans("msgs.transfer") . ' </a></td>';
         $single_ticket[] = '<td><a href="/tickets/delete/' . $ticket->thread_id . '" class="btn btn-danger btn-sm"> <i class="icon-remove3"></i> ' . trans("msgs.delete") . ' </a></td>';
         $tickets_arr[] = $single_ticket;
     }
     return json_encode(['aaData' => $tickets_arr]);
 }
 public function postPropReports()
 {
     $filter = 'go';
     $dept = Input::get('deptid');
     $category = Input::get('category');
     if ($dept == "*") {
         $deptpdf = "*";
     } else {
         $deptpdf = Department::where('id', $dept)->pluck('id');
     }
     if ($category == "*") {
         $categorypdf = "*";
     } else {
         $categorypdf = PropertyCategory::where('id', $category)->pluck('id');
     }
     Session::put('deptpdf', $deptpdf);
     Session::put('categorypdf', $categorypdf);
     $matchThese = array();
     if ($dept != "*") {
         //If true insert this to variable
         $matchThese = array_add($matchThese, 'dept_id', $dept);
         /***********Add Array*****************/
         //If user chooses from dropdown
         if ($category != "*") {
             //If true insert this to variable
             $matchThese = array_add($matchThese, 'cat_id', $category);
             $query = PropertiesUser::where($matchThese)->get();
         } else {
             //All Categoryy
             $query = PropertiesUser::where($matchThese)->get();
         }
         /***********End Add Array*****************/
     } else {
         //All Department
         /*************Add Array***************/
         if ($category != "*") {
             //If true insert this to variable
             $matchThese = array_add($matchThese, 'cat_id', $category);
             $query = PropertiesUser::where($matchThese)->get();
         } else {
             $query = PropertiesUser::all();
         }
         /************End Add Array****************/
     }
     //end of first if statement
     $audit = AuditTrail::create(['user_id' => Auth::id(), 'role' => 'Property Management Admin', 'action' => 'filtered the property reports.']);
     return View::make('prop.prop-reports')->with('query', $query)->with('filter', $filter);
 }
 public function get_departments_ajax()
 {
     $store_id = Input::get('store_id');
     $departments = Department::where('store_id', $store_id)->get();
     $first_department = 0;
     foreach ($departments as $department) {
         $first_department = $department->id;
         break;
     }
     $departments_data = array();
     foreach ($departments as $department) {
         $data = array();
         $data['id'] = $department->id;
         $data['name'] = $department->name;
         $data['shelves'] = Shelf::where('department_id', $department->id)->get()->toArray();
         array_push($departments_data, $data);
     }
     $response_code = 200;
     $response = Response::json($departments_data, $response_code);
     return $response;
 }
 public function all()
 {
     $online_users = OnlineUsers::all();
     foreach ($online_users as $user) {
         $user->user = User::find($user->user_id);
         if ($user->operator_id > 0) {
             $user->operator = User::find($user->operator_id);
         }
     }
     if (\KodeInfo\Utilities\Utils::isDepartmentAdmin(Auth::user()->id)) {
         $department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
         $this->data['department'] = Department::where('id', $department_admin->department_id)->first();
         $this->data["company"] = Company::where('id', $this->data['department']->company_id)->first();
     } elseif (\KodeInfo\Utilities\Utils::isOperator(Auth::user()->id)) {
         $department_operator = OperatorsDepartment::where('user_id', Auth::user()->id)->first();
         $this->data['department'] = Department::where('id', $department_operator->department_id)->first();
         $this->data["company"] = Company::where('id', $this->data['department']->company_id)->first();
     }
     $this->data['online_users'] = $online_users;
     return View::make('conversations.all', $this->data);
 }
 public function delete($company_id)
 {
     $departments = Department::where('company_id', $company_id)->get();
     if (Config::get('site-config.is_demo') && $company_id == 1) {
         Session::flash('error_msg', 'Demo : Feature is disabled');
         return Redirect::to('/dashboard');
     }
     foreach ($departments as $department) {
         if (!empty($department)) {
             $tickets = Tickets::where('department_id', $department->id)->get();
             //Delete tickets
             foreach ($tickets as $ticket) {
                 TicketAttachments::where('thread_id', $ticket->id)->delete();
                 MessageThread::where('id', $ticket->thread_id)->delete();
                 ThreadMessages::where('thread_id', $ticket->thread_id)->delete();
             }
             Tickets::where('department_id', $department->id)->delete();
             //Delete Chat and Conversations
             $online_users = OnlineUsers::where('department_id', $department->id)->get();
             foreach ($online_users as $online_user) {
                 MessageThread::where('id', $online_user->thread_id)->delete();
                 ThreadMessages::where('thread_id', $online_user->thread_id)->delete();
             }
             OnlineUsers::where('department_id', $department->id)->delete();
             $closed_conversations = ClosedConversations::where('department_id', $department->id)->get();
             foreach ($closed_conversations as $closed_conversation) {
                 MessageThread::where('id', $closed_conversation->thread_id)->delete();
                 ThreadMessages::where('thread_id', $closed_conversation->thread_id)->delete();
             }
             ClosedConversations::where('department_id', $department->id)->delete();
             $operators = OperatorsDepartment::where('department_id', $department->id)->lists('user_id');
             if (sizeof($operators) > 0) {
                 User::whereIn('id', $operators)->delete();
                 UsersGroups::whereIn('user_id', $operators)->delete();
             }
             OperatorsDepartment::where('department_id', $department->id)->delete();
             $department_admin = DepartmentAdmins::where('department_id', $department->id)->first();
             if (!empty($department_admin)) {
                 UsersGroups::where('user_id', $department_admin->user_id)->delete();
                 User::where("id", $department_admin->user_id)->delete();
                 CompanyDepartmentAdmins::where("user_id", $department_admin->user_id)->delete();
                 CannedMessages::where('operator_id', $operators)->delete();
             }
         }
         DepartmentAdmins::where('department_id', $department->id)->delete();
         Department::where('id', $department->id)->delete();
     }
     $company = Company::where('id', $company_id)->first();
     RecentActivities::createActivity("Company <a href='/companies/all'>" . $company->name . "</a> deleted by User Name " . Auth::user()->name . " User ID " . Auth::user()->id);
     Company::where('id', $company_id)->delete();
     Session::flash('success_msg', trans('msgs.company_deleted_success'));
     return Redirect::to('/companies/all');
 }
 public function online()
 {
     if (\KodeInfo\Utilities\Utils::isDepartmentAdmin(Auth::user()->id)) {
         $department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
         $department = Department::where('id', $department_admin->department_id)->first();
         $user_ids = OperatorsDepartment::where('department_id', $department->id)->lists('user_id');
     } else {
         $group = Groups::where("name", "operator")->first();
         $user_ids = UsersGroups::where("group_id", $group->id)->lists("user_id");
     }
     if (sizeof($user_ids) > 0) {
         $this->data["operators"] = User::whereIn("id", $user_ids)->where("is_online", 1)->get();
     } else {
         $this->data["operators"] = [];
     }
     foreach ($this->data["operators"] as $operator) {
         $department_id = OperatorsDepartment::where('user_id', $operator->id)->pluck("department_id");
         $department = Department::find($department_id);
         $company = Company::find($department->company_id);
         $operator->department = $department;
         $operator->company = $company;
     }
     $this->data['permissions'] = Permissions::all();
     $this->data['departments'] = Department::all();
     return View::make('operators.all', $this->data);
 }
Exemple #15
0
 public function getDepartmentCodeById($depid)
 {
     $rs = Department::where('department_id', '=', $depid)->get()->toArray();
     $code = $rs[0]['department_code'];
     return $code;
 }
 public function checkNewMessages()
 {
     $v_data = ["user_id" => Input::get('user_id'), "thread_id" => Input::get('thread_id'), "company_id" => Input::get('company_id'), "last_message_id" => Input::get('last_message_id')];
     $v_rules = ["user_id" => 'required', "thread_id" => 'required', "company_id" => 'required', "last_message_id" => 'required'];
     //Check any operators online from company_id
     //Check if we have any messages from user_id , thread_id
     $v = Validator::make($v_data, $v_rules);
     $response['is_online'] = false;
     if ($v->passes()) {
         //check any operator online
         $response['is_online'] = Company::operatorsOnline(Input::get('company_id'));
         $response['success_msg'] = "";
         $company = Company::find(Input::get('company_id'));
         $response['departments'] = Department::where('company_id', Input::get('company_id'))->get();
         foreach ($response['departments'] as $department) {
             $department_admin = DepartmentAdmins::where('department_id', $department->id)->first();
             $status = trans('msgs._offline_');
             $admin = User::where('id', $company->user_id)->first();
             if (!empty($admin)) {
                 if ($admin->is_online == 1) {
                     $status = trans('msgs._online_');
                 }
             }
             if (!empty($department_admin)) {
                 $user = User::where('id', $department_admin->user_id)->first();
                 if (!empty($user) && $user->is_online == 1) {
                     $status = trans('msgs._online_');
                 }
             }
             $operators = OperatorsDepartment::where('department_id', $department->id)->get();
             foreach ($operators as $operator) {
                 if (sizeof(User::where('id', $operator->user_id)->get()) > 0) {
                     $user = User::find($operator->user_id);
                     if ($user->is_online == 1) {
                         $status = trans('msgs._online_');
                     }
                 }
             }
             $department->name = $department->name . $status;
         }
         if (Input::has('token') && sizeof(OnlineUsers::where('token', Input::get('token'))->get()) > 0) {
             $token = Input::get('token');
             $response['token'] = $token;
             $online_user = OnlineUsers::where('token', $token)->first();
             $response['in_conversation'] = 1;
             $response['conversation_closed'] = 0;
             $response['thread_id'] = $online_user->thread_id;
             $thread_geo_info = ThreadGeoInfo::where('thread_id', $online_user->thread_id)->first();
             $this->fillPage(Input::get('page'), $thread_geo_info);
             $response['user_id'] = $online_user->user_id;
             $response['messages'] = MessageThread::getClientMessages($online_user->thread_id, Input::get('last_message_id'));
         } else {
             $response['in_conversation'] = 0;
             $response['token'] = "";
             $response['messages'] = [];
             $response['conversation_closed'] = 0;
             //Is conversation already closed
             if (sizeof(ClosedConversations::where('thread_id', Input::get('thread_id'))->get()) > 0) {
                 $response['success_msg'] = trans('msgs.thanks_for_contacting_support');
                 $response['token'] = 0;
                 $response['in_conversation'] = 1;
                 $response['conversation_closed'] = 1;
                 $response['thread_id'] = 0;
                 $response['user_id'] = 0;
             }
         }
     }
     return $this->send($response);
 }
 /**
  * function name : delete
  * edit data Department
  * get
  */
 public function delete($id)
 {
     if (Auth::check()) {
         $result = Department::where('department_id', $id)->delete();
         if ($result) {
             return Redirect::to('admin/departments')->with('success_message', 'ลบข้อมูลเรียบร้อยแล้ว');
         } else {
             return Redirect::to('admin/departments')->with('error_message', 'ไม่สามารถลบข้อมูลได้ กรุณาแจ้งผู้ดูแลระบบ');
         }
     } else {
         return View::make('users.index');
     }
 }
@extends('layouts.base')

@section('content')
<div class="row">
	<div class="col-md-12">

		<div class="row">
			<h1>
				Review Employee Evaluation<br>
				<small><a href="{{ route('profile', $perf->user->id) }}">
					{{ $perf->user->formatName(':ln, :fn :mi') }}<br>
					<?php 
$department = Department::where('id', $perf->dept_id)->get();
?>
				      	 @foreach ($department as $d)
				      	 	{{$d->name}}
				      	 @endforeach

				</a>
				</small>
			</h1>
		</div>

		<div class="row">
			<h2>Utilization</h2>
		</div>

			<form method="post" autocomplete="off" novalidate>
				<input type="hidden" name="id" value="{{ $perf->id }}">

				<div class="row">
Exemple #19
0
 function update()
 {
     $this->filter_access('Departement', 'roled_edit', 'departments/index');
     $dept = new Department();
     $dept->where('dept_id', $this->input->post('id'))->update('dept_name', $this->input->post('dept_name'));
     $this->session->set_flashdata('message', 'Department Update successfuly.');
     redirect('departments/');
 }
 public function postLeavesList()
 {
     $dept = Input::get('deptid');
     if ($dept == "*") {
         $users = User::orderBy('lastname')->get();
         $deptid = "*";
     } else {
         $users = User::where('department_id', $dept)->orderBy('lastname', 'desc')->get();
         $deptid = Department::where('id', $dept)->get();
     }
     return View::make('emp.leaves-list')->with('users', $users)->with('deptid', $deptid);
 }
 public function getPerfReportsPdf()
 {
     $deptL = Session::get('deptpdf');
     $sem = Session::get('sempdf');
     $year = Session::get('yearpdf');
     if ($deptL == 'All') {
         $deptL = '*';
     }
     //------------------------------
     if ($sem == 'All') {
         $sem = '*';
     }
     $users = 'Performance';
     $matchThese = array();
     //If user chooses from dropdown
     if ($deptL != "*") {
         //If true insert this to variable
         $matchThese = array_add($matchThese, 'dept_id', $deptL);
         /***********Add Array*****************/
         //If user chooses from dropdown
         if ($sem != "*") {
             //If true insert this to variable
             $matchThese = array_add($matchThese, 'semester', $sem);
             if ($year != "All") {
                 $matchThese = array_add($matchThese, 'year', $year);
                 $query = $users::where($matchThese)->orderBy('overall', 'desc')->get();
             } else {
                 $query = $users::where($matchThese)->orderBy('overall', 'desc')->get();
             }
         } else {
             //===========Else of Semester
             if ($year != "All") {
                 $matchThese = array_add($matchThese, 'year', $year);
                 $query = $users::where($matchThese)->orderBy('overall', 'desc')->get();
             } else {
                 //===========Else of Year
                 $query = $users::where($matchThese)->orderBy('overall', 'desc')->get();
             }
             $query = $users::where($matchThese)->orderBy('overall', 'desc')->get();
         }
         /***********End Add Array*****************/
     } else {
         //===========Else of Department
         /*************Add Array***************/
         if ($sem != "*") {
             //If true insert this to variable
             $matchThese = array_add($matchThese, 'semester', $sem);
             if ($year != "All") {
                 $matchThese = array_add($matchThese, 'year', $year);
                 $query = $users::where($matchThese)->orderBy('overall', 'desc')->get();
             } else {
                 $query = $users::where($matchThese)->orderBy('overall', 'desc')->get();
             }
         } else {
             //===========Else of Semester
             if ($year != "All") {
                 $matchThese = array_add($matchThese, 'year', $year);
                 $query = $users::where($matchThese)->orderBy('overall', 'desc')->get();
             } else {
                 //===========Else of Year
                 $query = $users::all();
             }
         }
         /************End Add Array****************/
     }
     Fpdf::AddPage();
     Fpdf::PageNo();
     Fpdf::AliasNbPages();
     Fpdf::Image('img/dap.jpg', 10, 5, 150);
     Fpdf::Ln(5);
     Fpdf::SetFont('Arial', 'B', 8);
     Fpdf::Cell(300, 20, 'Date Generated: ' . date("Y/m/d"), 0, 2, 'C', 0);
     Fpdf::Cell(30, 10, 'Performance Results', 0, 2, 'C', 0);
     if ($deptL == '*') {
         Fpdf::Cell(22, 10, 'Department: All', 0, 2, 'C', 0);
     } else {
         $filterDepartment = Department::where('id', $deptL)->first();
         Fpdf::Cell(30, 10, 'Department: ' . $filterDepartment->name, 0, 2, 'C', 0);
     }
     //------------------------------
     if ($sem == '*') {
         Fpdf::Cell(22, 10, 'Semester: All', 0, 2, 'C', 0);
     } else {
         Fpdf::Cell(30, 10, 'Semester: ' . $sem, 0, 2, 'C', 0);
     }
     if ($year == 'All') {
         Fpdf::Cell(30, 10, 'Year: All', 0, 2, 'C', 0);
     } else {
         Fpdf::Cell(30, 10, 'Year: ' . $year, 0, 2, 'C', 0);
     }
     Fpdf::SetFont('Arial', 'B', 5.5);
     Fpdf::Cell(5, 5, 'Id', 1, 0, 'C', 0);
     Fpdf::Cell(24.5, 5, 'Employee Name', 1, 0, 'C', 0);
     Fpdf::Cell(24.5, 5, 'Department', 1, 0, 'C', 0);
     Fpdf::SetFillColor(51, 51, 225);
     Fpdf::SetTextColor(0, 0, 0);
     Fpdf::Cell(25, 5, 'Utilities', 1, 0, 'C', true);
     Fpdf::Cell(25, 5, 'Quality of Work', 1, 0, 'C', true);
     Fpdf::Cell(30, 5, 'Potential for future performance', 1, 0, 'C', true);
     Fpdf::SetFillColor(96, 96, 96);
     Fpdf::Cell(25, 5, 'Overall Rating', 1, 0, 'C', true);
     Fpdf::Cell(15, 5, 'Semester', 1, 0, 'C', 0);
     Fpdf::Cell(16, 5, 'Year', 1, 0, 'C', 0);
     Fpdf::Ln();
     foreach ($query as $perf) {
         Fpdf::Cell(5, 5, $perf->user->id, 1, 0, 'C', 0);
         Fpdf::Cell(24.5, 5, $perf->user->formatName(':ln, :fn :mi'), 1, 0, 'C', 0);
         $department = Department::where('id', $perf->dept_id)->first();
         Fpdf::Cell(24.5, 5, $department->name, 1, 0, 'C', 0);
         Fpdf::SetFillColor(204, 229, 225);
         Fpdf::Cell(5, 5, $perf->utilities, 1, 0, 'C', true);
         Fpdf::Cell(20, 5, $perf->equivalent('utilities')->description, 1, 0, 'C', true);
         Fpdf::Cell(5, 5, $perf->workQuality, 1, 0, 'C', true);
         Fpdf::Cell(20, 5, $perf->equivalent('workQuality')->description, 1, 0, 'C', true);
         Fpdf::Cell(5, 5, $perf->potential, 1, 0, 'C', true);
         Fpdf::Cell(25, 5, $perf->equivalent('potential')->description, 1, 0, 'C', true);
         $u = $perf->utilities;
         $qow = $perf->workQuality;
         $pffp = $perf->potential;
         $overall = number_format(($u + $qow + $pffp) / 3, 2);
         $rating = ParRatingsRef::where('upper_limit', '>=', $overall)->where('lower_limit', '<=', $overall)->first();
         $overpercent = number_format($overall / 6 * 100, 2);
         Fpdf::SetFillColor(192, 192, 192);
         Fpdf::Cell(20, 5, $overall, 1, 0, 'C', true);
         Fpdf::Cell(5, 5, $rating->adjectival, 1, 0, 'C', true);
         Fpdf::Cell(15, 5, $perf->semester, 1, 0, 'C', 0);
         Fpdf::Cell(16, 5, $perf->year, 1, 0, 'C', 0);
         Fpdf::Ln();
     }
     Fpdf::SetY(-30.5);
     Fpdf::SetFont('Arial', 'I', 6);
     Fpdf::SetTextColor(0, 0, 0);
     Fpdf::Cell(0, 10, 'Page ' . Fpdf::PageNo() . "/{nb}", 0, 0, 'C');
     Fpdf::Output();
     exit;
     Session::forget('deptpdf');
     Session::forget('sempdf');
     Session::forget('yearpdf');
 }
 public function all()
 {
     $user_ids = [];
     if (\KodeInfo\Utilities\Utils::isDepartmentAdmin(Auth::user()->id)) {
         $department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
         $department = Department::where('id', $department_admin->department_id)->first();
         $department_ids = Department::where('company_id', $department->company_id)->lists('id');
         $user_ids = DepartmentAdmins::whereIn('department_id', $department_ids)->lists('user_id');
     } elseif (\KodeInfo\Utilities\Utils::isOperator(Auth::user()->id)) {
         $department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
         $department = Department::where('id', $department_admin->department_id)->first();
         $department_ids = Department::where('company_id', $department->company_id)->lists('id');
         $user_ids = DepartmentAdmins::whereIn('department_id', $department_ids)->lists('user_id');
     } else {
         $group = Groups::where("name", "department-admin")->first();
         $user_ids = UsersGroups::where("group_id", $group->id)->lists("user_id");
     }
     if (sizeof($user_ids) > 0) {
         $this->data["admins"] = User::whereIn("id", $user_ids)->orderBy('id', 'desc')->get();
     } else {
         $this->data["admins"] = [];
     }
     foreach ($this->data["admins"] as $admin) {
         $department_admin = DepartmentAdmins::where('user_id', $admin->id)->first();
         if (!empty($department_admin)) {
             $admin->department = Department::find($department_admin->department_id);
         }
         $company_id = CompanyDepartmentAdmins::where("user_id", $admin->id)->pluck('company_id');
         $admin->company = Company::find($company_id);
     }
     return View::make('department_admins.all', $this->data);
 }
 public function change_zipcode()
 {
     $zipcode = Input::get('zipcode');
     $store = StoreLocation::where('zipcode', $zipcode)->first();
     if (!$store) {
         $response_array = array('success' => 'false', 'error_code' => '403', 'error' => 'No nearby stores found.');
         $response_code = 200;
         if (Request::format() == 'html') {
             Session::put('zipcode', $zipcode);
             Session::put('store_id', 0);
             return Redirect::to('/store/0');
         } else {
             $response = Response::json($response_array, $response_code);
             return $response;
         }
     } else {
         $user = User::find($this->user_id);
         $user->zipcode = $zipcode;
         $user->save();
         if (Request::format() == 'html') {
             Session::put('zipcode', $zipcode);
             Session::put('store_id', $store->store_id);
         }
         $slot = Slot::where('store_id', $store->store_id)->select('start_time', 'end_time')->first();
         if (!$slot) {
             $slot = 'No Slots Available';
         }
         $response_array['success'] = 'true';
         $default_store_id = $store->store_id;
         $response_array['store'] = $store->toArray();
         $response_array['store']['delivery_slot'] = $slot;
         $response_array['store']['depatments'] = Department::where('store_id', $default_store_id)->get()->toArray();
         $response_array['user'] = $user->toArray();
         $response_array['stores_all'] = DB::table('stores')->leftJoin('store_locations', 'stores.id', '=', 'store_locations.store_id')->leftJoin('slots', 'stores.id', '=', 'slots.store_id')->where('store_locations.zipcode', $user->zipcode)->select('stores.*', 'store_locations.store_id', 'slots.start_time', 'slots.end_time')->get();
         if (Request::format() == 'html') {
             return Redirect::to('/store/' . $store->store_id);
         } else {
             $response_code = 200;
             $response = Response::json($response_array, $response_code);
             return $response;
         }
     }
 }
 public function all()
 {
     $tickets = Tickets::orderBy('priority', 'desc')->where('customer_id', Auth::user()->id)->get();
     foreach ($tickets as $ticket) {
         $ticket->customer = User::where('id', $ticket->customer_id)->first();
         $ticket->company = Company::where('id', $ticket->company_id)->first();
         $ticket->department = Department::where('id', $ticket->department_id)->first();
         if ($ticket->operator_id > 0) {
             $ticket->operator = User::where('id', $ticket->operator_id)->first();
         }
     }
     $this->data['tickets'] = $tickets;
     return View::make('tickets.customers_all', $this->data);
 }
 public function all()
 {
     $customer_ids = [];
     if (\KodeInfo\Utilities\Utils::isDepartmentAdmin(Auth::user()->id)) {
         $department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
         $department = Department::where('id', $department_admin->department_id)->first();
         $customer_ids = CompanyCustomers::where("company_id", $department->company_id)->lists('customer_id');
     } elseif (\KodeInfo\Utilities\Utils::isOperator(Auth::user()->id)) {
         $department_admin = OperatorsDepartment::where('user_id', Auth::user()->id)->first();
         $department = Department::where('id', $department_admin->department_id)->first();
         $customer_ids = CompanyCustomers::where("company_id", $department->company_id)->lists('customer_id');
     } else {
         $customer_ids = CompanyCustomers::lists('customer_id');
     }
     if (sizeof($customer_ids) > 0) {
         $this->data["customers"] = User::whereIn("id", $customer_ids)->orderBy('id', 'desc')->get();
     } else {
         $this->data["customers"] = [];
     }
     foreach ($this->data["customers"] as $customer) {
         $company_id = CompanyCustomers::where("customer_id", $customer->id)->pluck('company_id');
         $customer->company = Company::find($company_id);
         $customer->all_ticket_count = Tickets::where('customer_id', $customer->id)->count();
         $customer->pending_ticket_count = Tickets::where('customer_id', $customer->id)->where('status', Tickets::TICKET_PENDING)->count();
         $customer->resolved_ticket_count = Tickets::where('customer_id', $customer->id)->where('status', Tickets::TICKET_RESOLVED)->count();
     }
     return View::make('customers.all', $this->data);
 }
Exemple #26
0
 public static function getCompanyDepartments($company_id)
 {
     $departments = Department::where("company_id", $company_id)->get();
     return $departments;
 }
 public function single_department()
 {
     $store_id = Request::segment(2);
     $department_id = Request::segment(4);
     $department = Department::where('id', $department_id)->where('store_id', $store_id)->first();
     if (!$department) {
         if (Request::format() == 'html') {
             // Not Found Page
             die;
         } else {
             $response_array = array('success' => 'false', 'error_code' => '401', 'error' => 'Department not found in the choosen store');
             $response_code = 200;
             $response = Response::json($response_array, $response_code);
             return $response;
         }
     }
     $department_data = $department->toArray();
     $shelves_data = array();
     $shelves = Shelf::where('department_id', $department_id)->orderBy('name')->get();
     foreach ($shelves as $shelf) {
         $shelf_data = $shelf->toArray();
         $shelf_data['products'] = array();
         $products = Product::where('shelf_id', $shelf->id)->where('store_id', $store_id)->limit(8)->orderBy('total_sale', 'desc')->get();
         foreach ($products as $product) {
             $shelf_product = $product->toarray();
             array_push($shelf_data['products'], $shelf_product);
         }
         array_push($shelves_data, $shelf_data);
     }
     $response_array['department'] = $department_data;
     $response_array['department']['shelves'] = $shelves_data;
     if (Request::format() == 'html') {
         Session::put('store_id', $store_id);
         return View::make('department')->with('data', $response_array)->with('store', $this->store)->with('departments', $this->departments)->with('zipcode', $this->zipcode)->with('city', $this->city)->with('stores', $this->stores);
     } else {
         $response_array['success'] = 'true';
         $response_code = 200;
         $response = Response::json($response_array, $response_code);
         return $response;
     }
 }
 function index()
 {
     if (\KodeInfo\Utilities\Utils::isCustomer(Auth::user()->id)) {
         return Redirect::to('/tickets/customer/all');
     }
     $past_hr = \Carbon\Carbon::now()->subHour();
     $today = \Carbon\Carbon::now()->subDay();
     $this_week = \Carbon\Carbon::now()->subWeek();
     $this_month = \Carbon\Carbon::now()->subMonth();
     if (\KodeInfo\Utilities\Utils::isDepartmentAdmin(Auth::user()->id)) {
         $department_admin = DepartmentAdmins::where('user_id', Auth::user()->id)->first();
         $department = Department::where('id', $department_admin->department_id)->first();
         $company = Company::where('id', $department->company_id)->first();
         $this->data['tickets_past_hr'] = DB::table('tickets')->where('requested_on', '>', $past_hr)->where('company_id', $company->id)->where('department_id', $department->id)->count();
         $this->data['tickets_today'] = DB::table('tickets')->where('requested_on', '>', $today)->where('company_id', $company->id)->where('department_id', $department->id)->count();
         $this->data['tickets_this_week'] = DB::table('tickets')->where('requested_on', '>', $this_week)->where('company_id', $company->id)->where('department_id', $department->id)->count();
         $this->data['tickets_this_month'] = DB::table('tickets')->where('requested_on', '>', $this_month)->where('company_id', $company->id)->where('department_id', $department->id)->count();
         $this->data['tickets_total'] = sizeof(DB::table('tickets')->get());
         $department->all_tickets = sizeof(DB::table('tickets')->where('department_id', $department->id)->get());
         $department->pending_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_PENDING)->where('department_id', $department->id)->get());
         $department->resolved_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_RESOLVED)->where('department_id', $department->id)->get());
         $operator_ids = OperatorsDepartment::where('department_id', $department->id)->lists('user_id');
         if (sizeof($operator_ids) > 0) {
             $department->operators_online = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 1)->get());
             $department->operators_offline = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 0)->get());
         } else {
             $department->operators_online = 0;
             $department->operators_offline = 0;
         }
         $this->data['department_stats'] = $department;
     } elseif (\KodeInfo\Utilities\Utils::isOperator(Auth::user()->id)) {
         $department_operator = OperatorsDepartment::where('user_id', Auth::user()->id)->first();
         $department = Department::where('id', $department_operator->department_id)->first();
         $company = Company::where('id', $department->company_id)->first();
         $this->data['tickets_past_hr'] = DB::table('tickets')->where('requested_on', '>', $past_hr)->where('company_id', $company->id)->where('department_id', $department->id)->count();
         $this->data['tickets_today'] = DB::table('tickets')->where('requested_on', '>', $today)->where('company_id', $company->id)->where('department_id', $department->id)->count();
         $this->data['tickets_this_week'] = DB::table('tickets')->where('requested_on', '>', $this_week)->where('company_id', $company->id)->where('department_id', $department->id)->count();
         $this->data['tickets_this_month'] = DB::table('tickets')->where('requested_on', '>', $this_month)->where('company_id', $company->id)->where('department_id', $department->id)->count();
         $this->data['tickets_total'] = sizeof(DB::table('tickets')->get());
         $department->all_tickets = sizeof(DB::table('tickets')->where('department_id', $department->id)->get());
         $department->pending_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_PENDING)->where('department_id', $department->id)->get());
         $department->resolved_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_RESOLVED)->where('department_id', $department->id)->get());
         $operator_ids = OperatorsDepartment::where('department_id', $department->id)->lists('user_id');
         if (sizeof($operator_ids) > 0) {
             $department->operators_online = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 1)->get());
             $department->operators_offline = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 0)->get());
         } else {
             $department->operators_online = 0;
             $department->operators_offline = 0;
         }
         $this->data['department_stats'] = $department;
     } else {
         $this->data['tickets_past_hr'] = DB::table('tickets')->where('requested_on', '>', $past_hr)->count();
         $this->data['tickets_today'] = DB::table('tickets')->where('requested_on', '>', $today)->count();
         $this->data['tickets_this_week'] = DB::table('tickets')->where('requested_on', '>', $this_week)->count();
         $this->data['tickets_this_month'] = DB::table('tickets')->where('requested_on', '>', $this_month)->count();
         $this->data['tickets_total'] = sizeof(DB::table('tickets')->get());
         $companies = Company::all();
         foreach ($companies as $company) {
             $departments = Department::where('company_id', $company->id)->get();
             foreach ($departments as $department) {
                 $department->all_tickets = sizeof(DB::table('tickets')->where('department_id', $department->id)->get());
                 $department->pending_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_PENDING)->where('department_id', $department->id)->get());
                 $department->resolved_tickets = sizeof(DB::table('tickets')->where('status', Tickets::TICKET_RESOLVED)->where('department_id', $department->id)->get());
                 $operator_ids = OperatorsDepartment::where('department_id', $department->id)->lists('user_id');
                 if (sizeof($operator_ids) > 0) {
                     $department->operators_online = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 1)->get());
                     $department->operators_offline = sizeof(User::whereIn('id', $operator_ids)->where("is_online", 0)->get());
                 } else {
                     $department->operators_online = 0;
                     $department->operators_offline = 0;
                 }
             }
             $company->departments = $departments;
         }
         $this->data['department_stats'] = $companies;
     }
     return View::make('index', $this->data);
 }
						{{ Form::twbsText('Height: ', 'height', ['fromModel' => $user], ['maxlength' => '30']) }}

					</div>

					<div class="col-md-3">
						{{ Form::twbsText('Weight: ', 'weight', ['fromModel' => $user], ['maxlength' => '30']) }}

					</div>
					<div class="col-md-3">
						{{ Form::twbsText('Citizenship: ', 'citizenship', ['fromModel' => $user], ['maxlength' => '30']) }}

					</div>
				</div>
				<?php 
$position = EmpPos::where('id', $user->pos_id)->get();
$department = Department::where('id', $user->department_id)->get();
?>
				 <div class="row">
				
				@foreach ($department as $d)
					<div class="col-md-4">
						<div class="form-group">
							<label for="department_id" class="control-label">Department</label>
							<select class="form-control" id="department_id" name="department_id">
								<option value="{{ $d->id }}">{{ $d->name }}</option>
								<option value=" ">------------------------------------</option>
								@foreach ($alldepartments as $dept)
								<option value="{{ $dept->id }}">{{ $dept->name}}</option>
								@endforeach

							</select>
 public function getViewResultsPdf($id)
 {
     $result = Performance::find($id);
     $perf = Performance::find($id);
     $user = Performance::find($id);
     $rating = Performance::find($id);
     $u = $perf->utilities;
     $qow = $perf->workQuality;
     $pffp = $perf->potential;
     $overall = number_format(($u + $qow + $pffp) / 3, 2);
     $rating = ParRatingsRef::where('upper_limit', '>=', $overall)->where('lower_limit', '<=', $overall)->first();
     $overpercent = number_format($overall / 6 * 100, 2);
     $department = Department::where('id', $perf->dept_id)->first();
     Fpdf::AddPage();
     Fpdf::PageNo();
     Fpdf::AliasNbPages('{nb}');
     Fpdf::Image('img/dap.jpg', 40, 0, 150);
     Fpdf::Ln(30);
     Fpdf::SetFont('Arial', 'B', 11);
     Fpdf::SetTextColor(0, 0, 0);
     Fpdf::Cell(300, 20, 'Date Generated: ' . date("F j, Y"), 0, 2, 'C', 0);
     Fpdf::SetFont('Arial', 'B', 15);
     Fpdf::Cell(0, 0, 'Performance Evaluation', 0, 1, 'L', 0);
     Fpdf::Ln(8);
     Fpdf::SetFont('Arial', 'B', 11);
     Fpdf::Cell(0, 0, 'Name: ' . $perf->user->formatName(':ln, :fn :mn'), 0, 1, 'L', 0);
     Fpdf::Ln(8);
     Fpdf::Cell(0, 0, 'Department: ' . $department->name, 0, 1, 'L', 0);
     Fpdf::Ln(8);
     Fpdf::Cell(0, 0, 'Semester: ' . $perf->semester, 0, 1, 'L', 0);
     Fpdf::Ln(10);
     Fpdf::SetFont('Arial', '', 20);
     Fpdf::SetDrawColor(224, 224, 224);
     Fpdf::SetFillColor(51, 51, 225);
     Fpdf::SetTextColor(255, 255, 255);
     Fpdf::Cell(110, 10, 'Utilities', 1, 1, 'C', true);
     Fpdf::SetFont('Arial', 'B', 7);
     Fpdf::SetFillColor(204, 229, 225);
     Fpdf::SetTextColor(96, 96, 96);
     Fpdf::Cell(50, 10, 'Intra-group Involvements', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->util1, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('util1')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('util1')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Inter-group Involvements', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->util2, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('util2')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('util2')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Committee Work', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->util3, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('util3')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('util3')->description, 1, 1, 'C', 0);
     Fpdf::SetTextColor(204, 0, 0);
     Fpdf::Cell(50, 10, 'Average Rating', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->util_overall, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('utilities')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('utilities')->description, 1, 1, 'C', 0);
     //Quality of work table
     Fpdf::Ln(10);
     Fpdf::SetFont('Arial', '', 20);
     Fpdf::SetDrawColor(224, 224, 224);
     Fpdf::SetFillColor(51, 51, 225);
     Fpdf::SetTextColor(255, 255, 255);
     Fpdf::Cell(110, 10, 'Quality of Work', 1, 2, 'C', true);
     Fpdf::SetFont('Arial', 'B', 7);
     Fpdf::SetFillColor(204, 229, 225);
     Fpdf::SetTextColor(96, 96, 96);
     Fpdf::Cell(50, 10, 'Relevance to Project/unit objectives', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->qow1, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow1')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow1')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Timeliness', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->qow2, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow2')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow2')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Thoroughness', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->qow3, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow3')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow3')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'High-Rate', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->qow4, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow4')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow4')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Accuracy', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->qow5, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow5')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow5')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Foresight', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->qow6, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow6')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow6')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Neatness and Presentability', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->qow7, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow7')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow7')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Cost-effectiveness', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->qow8, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow8')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow8')->description, 1, 1, 'C', 0);
     Fpdf::SetTextColor(204, 0, 0);
     Fpdf::Cell(50, 10, 'Average Rating', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->qow_overall, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow_overall')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('qow_overall')->description, 1, 1, 'C', 0);
     //Potential for Future Performance table
     Fpdf::Ln(10);
     Fpdf::SetFont('Arial', '', 20);
     Fpdf::SetDrawColor(224, 224, 224);
     Fpdf::SetFillColor(51, 51, 225);
     Fpdf::SetTextColor(255, 255, 255);
     Fpdf::Cell(110, 10, 'Potential for Future Performance', 1, 2, 'C', true);
     Fpdf::SetFont('Arial', 'B', 7);
     Fpdf::SetFillColor(204, 229, 225);
     Fpdf::SetTextColor(96, 96, 96);
     Fpdf::Cell(50, 10, 'Appropriate Expertise', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->pffp1, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp1')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp1')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Professional Interest', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->pffp2, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp2')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp2')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Ability to Learn', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->pffp3, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp3')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp3')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Professional Integrity ', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->pffp4, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp4')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp4')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Work standards ', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->pffp5, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp5')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp5')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Innovativeness ', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->pffp6, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp6')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp6')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Maturity ', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->pffp7, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp7')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp7')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Collaboration ', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->pffp8, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp8')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp8')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Initiative', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->pffp9, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp9')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp9')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Responsiveness', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->pffp10, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp10')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp10')->description, 1, 1, 'C', 0);
     Fpdf::Cell(50, 10, 'Adaptability and Consistent track record ', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->pffp11, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp11')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp11')->description, 1, 1, 'C', 0);
     Fpdf::SetTextColor(204, 0, 0);
     Fpdf::Cell(50, 10, 'Average Rating', 1, 0, 'C', true);
     Fpdf::Cell(20, 10, $result->pffp_overall, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp_overall')->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(20, 10, $perf->equivalent('pffp_overall')->description, 1, 1, 'C', 0);
     //Overall Rating table
     Fpdf::Ln(10);
     Fpdf::SetFont('Arial', '', 20);
     Fpdf::SetDrawColor(224, 224, 224);
     Fpdf::SetFillColor(51, 51, 225);
     Fpdf::SetTextColor(255, 255, 255);
     Fpdf::Cell(140, 10, 'Overall Rating', 1, 2, 'C', true);
     Fpdf::SetFont('Arial', 'B', 7);
     Fpdf::SetFillColor(204, 229, 225);
     Fpdf::SetTextColor(96, 96, 96);
     Fpdf::Cell(30, 10, 'Superior Remarks', 1, 0, 'C', true);
     Fpdf::Cell(110, 10, $perf->comments, 1, 1, 'C', 0);
     Fpdf::Cell(30, 10, 'Overall rating', 1, 0, 'C', true);
     Fpdf::Cell(30, 10, $result->overall, 1, 0, 'C', 0);
     Fpdf::Cell(30, 10, $rating->adjectival, 1, 0, 'C', 0);
     Fpdf::Cell(50, 10, $rating->description, 1, 0, 'C', 0);
     Fpdf::SetY(-35);
     Fpdf::AliasNbPages('{nb}');
     Fpdf::SetFont('Arial', 'I', 10);
     Fpdf::SetTextColor(0, 0, 0);
     Fpdf::Cell(0, 10, 'Page ' . Fpdf::PageNo() . '/{nb}', 0, 0, 'C');
     Fpdf::Output();
     exit;
 }