public function all($params)
{
$params['order'] = isset($params['order']) ? $params['order'] : ['display_name|ASC'];
$roles = Role::select("roles.*");
$roles = parent::execute($roles, $params);
return $roles;
}
public function all($params)
{
$params['order'] = isset($params['order']) ? $params['order'] : ['name|ASC'];
$companies = $this->query();
$companies = parent::execute($companies, $params);
return $companies;
}
public function all($params)
{
$params['order'] = isset($params['order']) ? $params['order'] : ['display_name|ASC'];
$group_types = GroupType::select("group_types.*");
$group_types = parent::execute($group_types, $params);
return $group_types;
}
public function all($params)
{
$params['order'] = isset($params['order']) ? $params['order'] : ['id|ASC'];
$priorities = Priority::select("priorities.*");
$priorities = parent::execute($priorities, $params);
return $priorities;
}
public function all($params)
{
$params['order'] = isset($params['order']) ? $params['order'] : ['display_name|ASC'];
$permissions = Permission::select("permissions.*");
$permissions = parent::execute($permissions, $params);
return $permissions;
}
public function all($params)
{
$params['order'] = isset($params['order']) ? $params['order'] : ['last_name|ASC', 'first_name|ASC'];
$contacts = $this->query($params);
$contacts = parent::execute($contacts, $params);
return $contacts;
}
public function all($params)
{
$params['order'] = isset($params['order']) ? $params['order'] : ['id|ASC'];
$statuses = Status::select("statuses.*");
$statuses = parent::execute($statuses, $params);
return $statuses;
}
public function all($params)
{
$params['order'] = isset($params['order']) ? $params['order'] : ['name|ASC'];
$escalation_profiles = EscalationProfile::select("escalation_profiles.*");
$escalation_profiles = parent::execute($escalation_profiles, $params);
return $escalation_profiles;
}
public function all($params)
{
$params['order'] = isset($params['order']) ? $params['order'] : ['last_name|ASC', 'first_name|ASC'];
$users = Person::select("people.*");
$users = parent::execute($users, $params);
return $users;
}
public function all($params)
{
$params['order'] = isset($params['order']) ? $params['order'] : ['tickets.id|DESC'];
$tickets = $this->query();
$tickets->where("tickets.status_id", "!=", TICKET_DRAFT_STATUS_ID);
$tickets = parent::execute($tickets, $params);
return $tickets;
}
public function all($params)
{
$params['order'] = isset($params['order']) ? $params['order'] : ['hotels.rating|ASC'];
$users = Hotel::select("hotels.*");
$users->leftJoin('companies', 'companies.id', '=', 'hotels.company_id');
$users = parent::execute($users, $params);
return $users;
}
public function all($params)
{
$params['order'] = isset($params['order']) ? $params['order'] : ['activity_log.created_at|DESC'];
$activities = Activity::select("activity_log.*");
$activities->leftJoin('users', 'users.id', '=', 'activity_log.user_id');
$activities->leftJoin('company_person', 'company_person.id', '=', 'activity_log.contact_id');
$activities->leftJoin('people', 'people.id', '=', 'company_person.person_id');
$activities->leftJoin('companies', 'companies.id', '=', 'company_person.company_id');
$activities = parent::execute($activities, $params);
return $activities;
}
public function all($params)
{
$params['order'] = isset($params['order']) ? $params['order'] : ['id|DESC'];
$posts = Post::select("posts.*");
$posts->leftJoin('tickets', 'posts.ticket_id', '=', 'tickets.id');
$posts->where("posts.status_id", "!=", POST_DRAFT_STATUS_ID);
if (!Auth::user()->active_contact->isE80()) {
$posts->where("posts.status_id", "!=", POST_PRIVATE_STATUS_ID);
$posts->where("tickets.company_id", "=", Auth::user()->active_contact->company_id);
}
$posts = parent::execute($posts, $params);
return $posts;
}
public function all($params)
{
$params['order'] = isset($params['order']) ? $params['order'] : ['services.id|DESC'];
$services = Service::select("services.*");
$services->leftJoin("companies", "companies.id", "=", "services.company_id");
$services->leftJoin("company_person as internal_contact", "internal_contact.id", "=", "services.internal_contact_id");
$services->leftJoin("company_person as external_contact", "external_contact.id", "=", "services.external_contact_id");
$services->leftJoin('people as internals', 'internal_contact.person_id', '=', 'internals.id');
$services->leftJoin('people as externals', 'external_contact.person_id', '=', 'externals.id');
$services->leftJoin('hotels', 'hotels.id', '=', 'services.hotel_id');
$services = parent::execute($services, $params);
return $services;
}
