home/autoph/public_html/projects/Rating-AutoHub/app/Models/Auth.php 0000644 00000010631 15025015730 0021334 0 ustar 00 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);
}
}