File manager - Edit - /home/autoph/public_html/projects/tickets-autohub/app/Models/Role.php
Back
<?php namespace App\Models; use Illuminate\Database\Eloquent\Factories\HasFactory; use Illuminate\Database\Eloquent\Model; use Illuminate\Support\Facades\DB; use Illuminate\Support\Facades\Auth; class Role extends Model { use HasFactory; public function getRolesQuery(){ return "SELECT %s FROM roles WHERE 1 %s %s %s %s "; } public function getRoles($array_data){ $fields = " * "; $query = sprintf( $this->getRolesQuery(), $fields, $array_data['search'], $array_data['where'], $array_data['sort'], $array_data['offset_limit'] ); // dd($query); 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); } public Static function UserRole(){ $user_id = Auth::user()->id; return DB::table('assigned_roles')->where('entity_id', $user_id)->select('role_id')->get(); } // public Static function usersByRole() // { // $role_id_array =[1,4];//technical list employee // // $res = DB::table('companies')->whereIn('id', $com_id_array) ->select('id', 'comp_name') ->get(); // return DB::table('assigned_roles')->whereIn('role_id',$role_id_array) // ->select('role_id','entity_id as user_id', DB::raw("CONCAT(users.f_name, ' ', users.l_name) AS fullname"),'users.position') // ->leftJoin('users','users.id','=','assigned_roles.entity_id')->orderBy('fullname','asc')->get(); // } public Static function usersByRole() { $role_id_array =[1,4];//technical list employee // $res = DB::table('companies')->whereIn('id', $com_id_array) ->select('id', 'comp_name') ->get(); $res = DB::table('assigned_roles')->whereIn('role_id',$role_id_array) ->select('role_id','entity_id as user_id', DB::raw("CONCAT(REPLACE(users.f_name,'ñ','ñ'), ' ', REPLACE(users.l_name,'ñ','ñ')) AS fullname"),'users.position') ->leftJoin('users','users.id','=','assigned_roles.entity_id') ->where('users.active',1) ->where('users.department_id',Auth::user()->department_id)->orderBy('fullname','asc')->get(); $data = []; if($res){ foreach($res as $row) { if($row->user_id == Auth::user()->id){ $row->fullname = 'You'; } $data[] = $row; } } return $data; } }
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings