home/autoph/public_html/projects/Rating-AutoHub/app/Models/User.php 0000644 00000004531 15025015637 0021361 0 ustar 00
*/
protected $fillable = [
'asa_id',
'f_name',
'l_name',
'email',
'password',
'comp_id',
'type'
];
/**
* The attributes that should be hidden for serialization.
*
* @var array
*/
protected $hidden = [
'password',
'remember_token',
];
/**
* The attributes that should be cast.
*
* @var array
*/
protected $casts = [
'email_verified_at' => 'datetime',
];
public function getUsersQuery(){
$id = Auth::user()->id;
return "SELECT %s
FROM `users`
WHERE 1
AND `id` != $id
%s
%s
%s
%s
";
}
public function getUsers($array_data){
$fields = " `users`.`id`, `users`.`f_name`, `users`.`l_name` ";
$query = sprintf(
$this->getUsersQuery(),
$fields,
$array_data['search'],
$array_data['where'],
$array_data['sort'],
$array_data['offset_limit']
);
return DB::select($query);
}
public function getUsersCount($array_data){
$fields = " COUNT(1) as Count ";
$query = sprintf(
$this->getUsersQuery(),
$fields,
'',
$array_data['where'],
'',
''
);
return DB::select($query);
}
public function getUsersFilteredCount($array_data){
$fields = " COUNT(1) as FilteredCount ";
$query = sprintf(
$this->getUsersQuery(),
$fields,
$array_data['search'],
$array_data['where'],
'',
''
);
return DB::select($query);
}
}