public function create()
{
$data['title'] = "Create Vpn";
$data['company'] = Company::find($id);
$data['company']->company_id = $data['company']->id;
return view('equipment/create', $data);
}
static function operatorsOnline($company_id)
{
$response = 0;
$department_admin_ids = CompanyDepartmentAdmins::where('company_id', $company_id)->lists('user_id');
$company = Company::find($company_id);
$user = User::find($company->user_id);
if ($user->is_online == 1) {
return 1;
} else {
foreach ($department_admin_ids as $admin_id) {
if ($response == 0) {
$user = User::find($admin_id);
if ($user->is_online == 1) {
return 1;
} else {
$department_admin = DepartmentAdmins::where('user_id', $admin_id)->first();
if (!empty($department_admin)) {
$operators_ids = OperatorsDepartment::where('department_id', $department_admin->department_id)->lists('user_id');
foreach ($operators_ids as $operators_id) {
if (sizeof(User::where('id', $operators_id)->get()) > 0) {
$user = User::find($operators_id);
if ($user->is_online == 1) {
return 1;
}
}
}
}
}
}
}
}
return $response;
}
public function getViewCompany($company_id)
{
$sql = "SELECT al.*, wrk.date_hired, wrk.date_finished, occ.title\n\t\t\t\tFROM alumni AS al\n\t\t\t\tINNER JOIN work_experience AS wrk\n\t\t\t\tON wrk.alumni_id = al.id\n\t\t\t\tINNER JOIN company AS com\n\t\t\t\tON com.id = wrk.company_id\n\t\t\t\tINNER JOIN occupation AS occ\n\t\t\t\tON occ.id = wrk.occupation_id\n\t\t\t\tWHERE com.id = ?";
$company = Company::find($company_id);
$employees = DB::select($sql, array($company_id));
return View::make('admin.view_company')->with('company', $company)->with('employees', $employees);
}
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);
}
/**
* Create a new User instance.
*
* @param Object $request
* @return Response
*/
public static function addUser()
{
$app = \Slim\Slim::getInstance();
$request = (object) $app->request->post();
//validate input
$validata = $app->validata;
$validator = $validata::key('email', $validata::email()->notEmpty())->key('first_name', $validata::stringType()->notEmpty())->key('last_name', $validata::stringType()->notEmpty())->key('password', $validata::stringType()->notEmpty())->key('company', $validata::intVal())->key('city', $validata::stringType()->notEmpty())->key('province', $validata::stringType()->notEmpty())->key('zip_code', $validata::stringType()->notEmpty())->key('address', $validata::stringType()->notEmpty());
$errors = array();
try {
$validator->assert((array) $request);
} catch (\InvalidArgumentException $e) {
$errors = $e->findMessages(array('email' => '{{name}} must be a valid email', 'first_name' => '{{name}} is required', 'last_name' => '{{name}} is required', 'password' => 'Password is required', 'company' => 'Company is required', 'city' => 'City is required', 'province' => 'State/Province is required', 'address' => 'Address is required', 'zip_code' => 'Zipcode is required'));
}
if ($validator->validate((array) $request)) {
if (!PasswordController::isValid($request->password, $request->email)) {
$app->halt('400', json_encode("Password Formart Wrong"));
}
if (!Company::find($request->company)) {
$app->halt('400', json_encode("Company does not exist"));
}
if (self::isExist($request->email)) {
$app->response->setStatus(400);
return json_encode("Email already taken");
}
$user = new User();
//$user->name = $request->name;
$user->email = $request->email;
$user->password = PasswordController::encryptPassword($request->password);
$user->first_name = $request->first_name;
$user->last_name = $request->last_name;
if (isset($request->phone)) {
$user->phone = $request->phone;
}
$user->city = $request->city;
$user->address = $request->address;
$user->province = $request->province;
$user->zip_code = $request->zip_code;
$user->country = $request->country;
$user->active = 0;
$user->save();
$app->response->setStatus(200);
//send confirm email
if ($user->id) {
$user->companies()->attach($request->company);
$link = WEBSITELINK . '/' . self::$active_api . openssl_encrypt($user->id, 'AES-256-CBC', self::$pass, 0, self::$iv);
EmailController::newUserConfirmation($user->id, $request->password, $link);
}
return $user->id;
} else {
$app->response->setStatus(400);
$return = [];
foreach (array_values($errors) as $key => $error) {
if ($error != "") {
array_push($return, array("code" => $key, "data" => $error));
}
}
return json_encode($return);
}
}
public static function apiAll()
{
if (!Auth::user()->isAdmin()) {
return [Company::find(Auth::user()["company_id"])];
} else {
return Company::all();
}
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id)
{
$company = Company::find($id);
$input = Input::all();
$company->update($input);
$company->save();
return Redirect::to('admins/companies');
}
public function dashboard($companies)
{
if (!Auth::check() or $companies != Auth::user()->company_id) {
return Redirect::home();
}
$company = Company::find($companies);
$products = $company->products;
$products->load('orders');
return View::make('companies.dashboard', compact('products'));
}
public function update()
{
$company = User::find(Auth::user()->id)->company;
$company = Company::find($company->id);
$input = Input::all();
$company->company_name = $input['company_name'];
$company->company_address = $input['company_address'];
$company->save();
return Redirect::action('company.index');
}
public function testSave()
{
$c = new Company();
$c->name = 'Model Persister Company 2';
$c->save();
$this->assertNotNull($c->id);
$c->name = 'Model Persister Company 2 updated';
$c->save();
$c2 = Company::find($c->id);
$this->assertEquals($c2->name, 'Model Persister Company 2 updated');
}
/**
* Display the specified resource.
* GET /orders/{id}
*
* @param int $id
* @return Response
*/
public function show($company, $order)
{
if (is_numeric($order)) {
$orders = Company::findOrFail($company)->orders->find($order);
$offers = Offer::where('order_id', '=', $order)->where('provider_id', '=', Auth::user()->provider_id)->get();
$company = Company::find($company);
$interval = calculate_time_interval($orders->start_date, $orders->end_date);
$dates = extract_dates($orders->start_date, $interval);
$offer_dates = array_pluck($offers, 'date');
}
return View::make('orders.show', compact('offer_dates', 'offers', 'orders', 'company', 'interval', 'dates', 'start_at'));
}
public function getList()
{
if (!empty($_REQUEST['uid'])) {
$uid = (int) $_REQUEST['uid'];
$where = array(array('uid', '=', $uid));
$companyClass = new Company();
$companyList = $companyClass->find($where);
foreach ($companyList as $k => $company) {
$companyList[$k] = $this->parse($company);
}
return $companyList;
}
}
public function initialize()
{
// Company
$company = new Select('companyid', Company::find(), array('using' => array('id', 'name')));
$company->setLabel('Empresa');
$this->add($company);
$number = new Text('name');
$number->setLabel('Número de Torre');
$number->addValidators(array(new PresenceOf(array('message' => 'Debe ingresar un numero de torre'))));
$this->add($number);
//añadimos un botón de tipo submit
$submit = $this->add(new Submit('save', array('class' => 'btn btn-success')));
}
public function sendInvoice($invoice_id, $company_id)
{
$contact = Company::find((int) $company_id);
if ($contact) {
$put_url = '/sales_invoices/' . $invoice_id . '/send_invoice.json';
$put_data = '{email:' . $contact->email . '}';
try {
$this->patchRequest($put_url, $put_data);
} catch (Exception $e) {
error_log($e->getMessage());
die;
}
}
}
public function testFind()
{
$cq = EQM::queryByPrimary(Company::class, 2);
$cm = Company::find(2);
$this->assertEquals($cq->id, $cm->id);
$this->assertEquals($cq->name, $cm->name);
$pq = EQM::queryByPrimary(Project::class, '2_2_PROJECT');
$pm = Project::find('2_2_PROJECT');
$this->assertEquals($pq->id, $pm->id);
$this->assertEquals($pq->name, $pm->name);
$paq = EQM::queryByPrimary(ProjectActivity::class, ['id' => 100, 'projectId' => '2_2_PROJECT']);
$pam = ProjectActivity::find(['id' => 100, 'projectId' => '2_2_PROJECT']);
$this->assertEquals($paq->id, $pam->id);
$this->assertEquals($paq->name, $pam->name);
}
public function initialize()
{
// Company
$company = new Select('companyid', Company::find(), array('using' => array('id', 'name')));
$company->setLabel('Company');
$this->add($company);
$tower = new Select('towerid', array('0' => 'Select a tower'));
$tower->setLabel('Tower');
$this->add($tower);
$name = new Text('name');
$name->setLabel('Apartment Name');
$name->addValidators(array(new PresenceOf(array('message' => 'You must enter an apartment name'))));
$this->add($name);
//añadimos un botón de tipo submit
$submit = $this->add(new Submit('save', array('class' => 'btn btn-success')));
}
public function getCustomers($company_id)
{
$customer_ids = CompanyCustomers::where('company_id', $company_id)->lists('customer_id');
$customers = [];
if (sizeof($customer_ids) > 0) {
$customers = User::whereIn('id', $customer_ids)->get();
}
foreach ($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();
}
$this->data['customers'] = $customers;
return View::make('companies.customers', $this->data);
}
protected function saveModel($venue = false)
{
if (Input::get('id')) {
$venue = Venue::find(Input::get('id'));
}
if (!$venue) {
$venue = new Venue();
}
$venue->name = Input::get('name');
$venue->indoor_or_outdoor = Input::get('indoor_or_outdoor');
$venue->name_of_hall = Input::get('name_of_hall');
$venue->capacity = Input::get('capacity');
$venue->dimension_height = Input::get('dimension_height');
$venue->dimension_width = Input::get('dimension_width');
$venue->dimension_length = Input::get('dimension_length');
$venue->rigging_capacity = Input::get('rigging_capacity');
$venue->notes = Input::get('notes');
$address = $venue->address()->first() ?: new Address();
$country = Country::where('name', Input::get('country'))->first();
$address->country()->associate($country);
$address->address = Input::get('address_address');
$address->postal_code = Input::get('address_postal_code');
$address->city = Input::get('address_city');
$address->state_province = Input::get('address_state_province');
$address->phone = Input::get('address_phone');
$address->fax = Input::get('address_fax');
$address->email = Input::get('address_email');
$address->website = Input::get('address_website');
$address->save();
$venue->address()->associate($address);
$venue->save();
$venue->save();
if (Input::get('company_id')) {
$venue->companies()->detach(Company::find(Input::get('company_id')));
$venue->companies()->attach(Company::find(Input::get('company_id')));
}
if (Input::get('contact_id')) {
$venue->contacts()->detach(Contact::find(Input::get('contact_id')));
$venue->contacts()->attach(Contact::find(Input::get('contact_id')));
}
return $venue;
}
protected function saveModel($company = false)
{
if (Input::get('id')) {
$company = Company::find(Input::get('id'));
}
if (!$company) {
$company = new Company();
}
$company->name = Input::get('name');
$company->type = Input::get('type');
$company->references = Input::get('references');
$company->bank_details = Input::get('bank_details');
$company->tax_number = Input::get('tax_number');
$company->notes = Input::get('notes');
$address = $company->address()->first() ?: new Address();
$country = Country::where('id', Input::get('country'))->first();
$address->country()->associate($country);
$address->address = Input::get('address_address');
$address->postal_code = Input::get('address_postal_code');
$address->city = Input::get('address_city');
$address->state_province = Input::get('address_state_province');
$address->phone = Input::get('address_phone');
$address->fax = Input::get('address_fax');
$address->email = Input::get('address_email');
$address->website = Input::get('address_website');
$address->save();
$company->address()->associate($address);
$company->save();
if (Input::get('venue_id')) {
$company->venues()->detach(Venue::find(Input::get('venue_id')));
$company->venues()->attach(Venue::find(Input::get('venue_id')));
}
if (Input::get('contact_id')) {
$company->contacts()->detach(Contact::find(Input::get('contact_id')));
$company->contacts()->attach(Contact::find(Input::get('contact_id')));
}
if (Input::get('event_id')) {
$company->events()->detach(Events::find(Input::get('event_id')));
$company->events()->attach(Events::find(Input::get('event_id')));
}
return $company;
}
/**
* Searches for company
*/
public function searchAction()
{
$numberPage = 1;
if ($this->request->isPost()) {
$query = Criteria::fromInput($this->di, "Company", $_POST);
$this->persistent->parameters = $query->getParams();
} else {
$numberPage = $this->request->getQuery("page", "int");
}
$parameters = $this->persistent->parameters;
if (!is_array($parameters)) {
$parameters = array();
}
$parameters["order"] = "id";
$company = Company::find($parameters);
if (count($company) == 0) {
$this->flash->notice("The search did not find any company");
return $this->dispatcher->forward(array("controller" => "company", "action" => "index"));
}
$paginator = new Paginator(array("data" => $company, "limit" => 10, "page" => $numberPage));
$this->view->page = $paginator->getPaginate();
}
function update($id = FALSE, $getview = FALSE)
{
if ($_POST) {
unset($_POST['send']);
unset($_POST['_wysihtml5_mode']);
unset($_POST['files']);
$id = $_POST['id'];
$view = FALSE;
if (isset($_POST['view'])) {
$view = $_POST['view'];
}
unset($_POST['view']);
if ($_POST['status'] == "Paid") {
$_POST['paid_date'] = date('Y-m-d', time());
}
$estimate = Invoice::find($id);
$estimate->update_attributes($_POST);
if (!$estimate) {
$this->session->set_flashdata('message', 'error:' . $this->lang->line('messages_save_estimate_error'));
} else {
$this->session->set_flashdata('message', 'success:' . $this->lang->line('messages_save_estimate_success'));
}
redirect('estimates/view/' . $id);
} else {
$this->view_data['estimate'] = Invoice::find($id);
$this->view_data['projects'] = Project::all();
$this->view_data['companies'] = Company::find('all', array('conditions' => array('inactive=?', '0')));
if ($getview == "view") {
$this->view_data['view'] = "true";
}
$this->theme_view = 'modal';
$this->view_data['title'] = $this->lang->line('application_edit_estimate');
$this->view_data['form_action'] = 'estimates/update';
$this->content_view = 'estimates/_estimate';
}
}
/**
* Display the specified offer.
*
* @param int $id
* @return Response
*/
public function show($companies, $orders)
{
$offers = Offer::where('order_id', '=', $orders)->where('provider_id', '=', Auth::user()->provider_id)->get();
$company = Company::find($companies);
return View::make('offers.show', compact('offers', 'company'));
}
//$summaries = Summary::where('employee_id', $employeeId)->whereBetween('daydate', [$cutOffDateFrom, $cutOffDateTo])->get();
$summary = DB::table('employee_summary')->select(DB::raw('SUM(lates) as lates, SUM(undertime) as undertime, SUM(absent) as absent, SUM(paid_sick_leave) as paid_sick_leave, SUM(paid_vacation_leave) as paid_vacation_leave, SUM(leave_without_pay) as leave_without_pay, SUM(maternity_leave) as maternity_leave, SUM(paternity_leave) as paternity_leave,
SUM(regular) as regular, SUM(regular_overtime) as regular_overtime, SUM(regular_overtime_night_diff) as regular_overtime_night_diff, SUM(regular_night_differential) as regular_night_differential, SUM(rest_day) as rest_day, SUM(rest_day_overtime) as rest_day_overtime, SUM(rest_day_overtime_night_diff) as rest_day_overtime_night_diff, SUM(rest_day_night_differential) as rest_day_night_differential,
SUM(rest_day_special_holiday) as rest_day_special_holiday, SUM(rest_day_special_holiday_overtime) as rest_day_special_holiday_overtime, SUM(rest_day_special_holiday_overtime_night_diff) as rest_day_special_holiday_overtime_night_diff, SUM(rest_day_special_holiday_night_diff) as rest_day_special_holiday_night_diff, SUM(rest_day_legal_holiday) as rest_day_legal_holiday, SUM(rest_day_legal_holiday_overtime) as rest_day_legal_holiday_overtime,
SUM(rest_day_legal_holiday_overtime_night_diff) as rest_day_legal_holiday_overtime_night_diff, SUM(rest_day_legal_holiday_night_diff) as rest_day_legal_holiday_night_diff, SUM(special_holiday) as special_holiday, SUM(special_holiday_overtime) as special_holiday_overtime, SUM(special_holiday_overtime_night_diff) as special_holiday_overtime_night_diff, SUM(special_holiday_night_diff) as special_holiday_night_diff, SUM(legal_holiday) as legal_holiday,
SUM(legal_holiday_overtime) as legal_holiday_overtime, SUM(legal_holiday_overtime_night_diff) as legal_holiday_overtime_night_diff, SUM(legal_holiday_night_diff) as legal_holiday_night_diff'))->where('employee_id', $employeeId)->whereBetween('daydate', [$cutOffDateFrom, $cutOffDateTo])->first();
//dd($summary);
$userGroups = DB::table('users_groups')->where('user_id', $userId)->first();
//$userGroups = DB::table('users_groups')->where('user_id', Auth::user()->id)->first();
if (!empty($userGroups)) {
$groups = DB::table('groups')->where('id', (int) $userGroups->group_id)->first();
}
$currentUser = Sentry::getUser();
//$employeeId = Session::get('userEmployeeId');
//$employeeInfo[0]->id
$company = Company::find($employeeInfo[0]->company_id);
$department = Department::find($employeeInfo[0]->department_id);
$jobTitle = JobTitle::find($employeeInfo[0]->position_id);
$manager = '';
$manager = Employee::where('id', '=', $employeeInfo[0]->manager_id)->first();
if (!empty($manager)) {
$managerFullname = $manager->firstname . ', ' . $manager->lastname;
} else {
$managerFullname = '';
}
$employees = DB::table('employees')->where('manager_id', $employeeInfo[0]->id)->orWhere('supervisor_id', $employeeInfo[0]->id)->get();
$employeeArr[0] = '';
foreach ($employees as $employee) {
$employeeArr[$employee->id] = $employee->firstname . ', ' . $employee->lastname;
}
//$getSchedule = DB::table('employee_schedule')->where('employee_id', $employee->id)->where('schedule_date', trim($currentDate))->get();
//DELETE: EXISTING COMPANY
Route::get('/admin/company/delete/{id}', array('as' => 'adminDeleteCompany', 'uses' => function ($id) {
$id = (int) $id;
$employeeId = Session::get('userEmployeeId');
$userId = Session::get('userId');
$employee = new Employee();
$employeeInfo = $employee->getEmployeeInfoById($employeeId);
//return 'Update Company';
return View::make('admin.companydelete', array('id' => $id, 'employeeInfo' => $employeeInfo));
//return Redirect::route('updateCompany', array('id' => $id));
}));
//DELETE: EXISTING COMPANY
Route::post('/admin/company/delete/{id}', array('as' => 'adminProcessDeleteCompany', 'uses' => function ($id) {
$data = Input::all();
$id = (int) $id;
$company = Company::find($id);
if ($company->delete()) {
$message = 'Deleted Successfully.';
return Redirect::route('adminNewCompany')->with('message', $message);
}
}));
//CREATE: NEW DEPARTMENT
Route::get('/admin/department/new', array('as' => 'adminNewDepartment', 'uses' => function () {
//return 'Add Department';
$employeeId = Session::get('userEmployeeId');
$userId = Session::get('userId');
$employee = new Employee();
$employeeInfo = $employee->getEmployeeInfoById($employeeId);
return View::make('admin.departmentnew', ['employeeInfo' => $employeeInfo]);
}));
//CREATE: NEW DEPARTMENT
public function company_valid($company_name)
{
$company = new Company();
$company_exists = false;
$data = $company->find("first", array("contain" => false, "field" => "Company.id", "joins" => array(array('table' => 'admins_companies', 'alias' => 'AdminsCompany', 'type' => 'LEFT', 'conditions' => "AdminsCompany.company_id=Company.id")), "conditions" => array("AdminsCompany.admin_id" => $this->admin_id, "Company.name" => $company_name)));
if (!empty($data)) {
$company_exists = true;
$this->company_name = $company_name;
$this->company_id = $data["Company"]["id"];
$this->admin_id = $this->admin_id;
} else {
$this->sheet_errors[] = "Company " . $company_name . " is not assigned to you.";
}
return $company_exists;
}
public function findCompanyNameByCode($comp_code = null)
{
//function to find all company name
App::import("Model", "Company");
$model = new Company();
$query = $model->find('all', array('fields' => array('comp_name'), 'conditions' => array('Company.comp_code' => $comp_code)));
if (empty($query)) {
return 0;
} else {
return $query[0]['Company']['comp_name'];
}
}
function update($id = FALSE, $getview = FALSE)
{
if ($_POST) {
unset($_POST['send']);
unset($_POST['_wysihtml5_mode']);
unset($_POST['files']);
$config['upload_path'] = './files/media/';
$config['encrypt_name'] = TRUE;
$config['allowed_types'] = '*';
$this->load->library('upload', $config);
if ($this->upload->do_upload()) {
$data = array('upload_data' => $this->upload->data());
if ($_POST['attachment_description'] == "") {
$_POST['attachment_description'] = $data['upload_data']['orig_name'];
}
$_POST['attachment'] = $data['upload_data']['file_name'];
}
$id = $_POST['id'];
$expense = Expense::find_by_id($id);
$expense->update_attributes($_POST);
if (!$expense) {
$this->session->set_flashdata('message', 'error:' . $this->lang->line('messages_save_expense_error'));
} else {
$this->session->set_flashdata('message', 'success:' . $this->lang->line('messages_save_expense_success'));
}
redirect('expenses');
} else {
$this->view_data['next_reference'] = Expense::last();
$this->view_data['expense'] = Expense::find_by_id($id);
$this->view_data['projects'] = Project::all();
$this->view_data['core_settings'] = Setting::first();
$this->view_data['companies'] = Company::find('all', array('conditions' => array('inactive=?', '0')));
$this->theme_view = 'modal';
$this->view_data['categories'] = Expense::find_by_sql("select category from expenses group by category");
$this->view_data['title'] = $this->lang->line('application_create_expense');
$this->view_data['form_action'] = 'expenses/update';
$this->content_view = 'expenses/_expense';
}
}
@extends('layouts.admin.default')
@section('content')
<?php
$companyCount = Company::count();
$companies = Company::paginate(10);
$companyEdit = Company::find($id);
$message = Session::get('message');
?>
<div class="page-container">
<div class="row" style="padding-bottom:20px;">
<div class="col-md-2 clearfix">
<aside class="sidebar">
<nav class="sidebar-nav">
<ul id="menu">
<li>
<a href="{{ url('/admin/dashboard') }}">
<span class="sidebar-nav-item-icon fa fa-tachometer fa-lg"></span>
<span class="sidebar-nav-item">Dashboard</span>
</a>
</li>
<li>
<a href="#">
<span class="sidebar-nav-item-icon fa fa-users fa-lg"></span>
<span class="sidebar-nav-item">Employees</span>
function view($id = FALSE)
{
$this->view_data['submenu'] = array($this->lang->line('application_back') => 'clients');
$this->view_data['company'] = Company::find($id);
$this->view_data['invoices'] = Invoice::find('all', array('conditions' => array('estimate != ? AND company_id = ? AND estimate_status != ?', 1, $id, 'Declined')));
$this->content_view = 'clients/view';
}
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);
}
