File manager - Edit - /home/autoph/public_html/projects/Rating-AutoHub/app/Models/Auth.php
Back
<?php namespace App\Models; use Illuminate\Database\Eloquent\Factories\HasFactory; use Illuminate\Database\Eloquent\Model; use Illuminate\Support\Facades\DB; class Auth extends Model { use HasFactory; public function getQuestions(){ return count(Questions::all()); } public function getTemplates(){ return count(Template::all()); } public function getSystems(){ return count(System::all()); } public function getQuestionnaires(){ return count(Questionnaire::all()); } public function reports($array_data){ } public function getCompanyQuery(){ return "SELECT %s FROM companies WHERE 1 AND `status` = 1 AND `active` = 1 %s %s %s %s "; } public function getCompanies($array_data){ $fields = " * "; $query = sprintf( $this->getCompanyQuery(), $fields, $array_data['search'], $array_data['where'], $array_data['sort'], $array_data['offset_limit'] ); return DB::select($query); } public function getCompaniesCount($array_data){ $fields = " COUNT(1) as Count "; $query = sprintf( $this->getCompanyQuery(), $fields, '', $array_data['where'], '', '' ); return DB::select($query); } public function getCompaniesFilteredCount($array_data){ $fields = " COUNT(1) as FilteredCount "; $query = sprintf( $this->getCompanyQuery(), $fields, $array_data['search'], $array_data['where'], '', '' ); return DB::select($query); } public function getEmailsQuery(){ return "SELECT %s FROM email_responses INNER JOIN users `u` on `u`.`id` = email_responses.user WHERE 1 %s %s %s %s "; } public function getEmails($array_data){ // dd($array_data); $fields = " `email_responses`.`id`, CONCAT(`u`.`f_name`, ' ', `u`.`l_name`) as `user_name`, `email_responses`.`email`, `email_responses`.`created_at`, `email_responses`.`status` "; $query = sprintf( $this->getEmailsQuery(), $fields, $array_data['search'], $array_data['where'], $array_data['sort'], $array_data['offset_limit'] ); return DB::select($query); } public function getEmailsCount($array_data){ $fields = " COUNT(1) as Count "; $query = sprintf( $this->getEmailsQuery(), $fields, '', $array_data['where'], '', '' ); return DB::select($query); } public function getEmailsFilteredCount($array_data){ $fields = " COUNT(1) as FilteredCount "; $query = sprintf( $this->getEmailsQuery(), $fields, $array_data['search'], $array_data['where'], '', '' ); return DB::select($query); } public function getRolesQuery(){ return "SELECT %s FROM `roles` WHERE 1 %s %s %s %s "; } public function getRoles($array_data){ $fields = " `roles`.`id`, `roles`.`name`, `roles`.`title` "; $query = sprintf( $this->getRolesQuery(), $fields, $array_data['search'], $array_data['where'], $array_data['sort'], $array_data['offset_limit'] ); return DB::select($query); } public function getRolesCount($array_data){ $fields = " COUNT(1) as Count "; $query = sprintf( $this->getRolesQuery(), $fields, '', $array_data['where'], '', '' ); return DB::select($query); } public function getRolesFilteredCount($array_data){ $fields = " COUNT(1) as FilteredCount "; $query = sprintf( $this->getRolesQuery(), $fields, $array_data['search'], $array_data['where'], '', '' ); return DB::select($query); } }
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings