File manager - Edit - /home/autoph/public_html/projects/tickets-autohub/app/Models/User.php
Back
<?php namespace App\Models; // use Illuminate\Contracts\Auth\MustVerifyEmail; use Illuminate\Database\Eloquent\Factories\HasFactory; use Illuminate\Database\Eloquent\Relations\BelongsTo; use Illuminate\Foundation\Auth\User as Authenticatable; use Illuminate\Notifications\Notifiable; use Illuminate\Support\Facades\Auth; use Illuminate\Support\Facades\DB; // use Laravel\Sanctum\HasApiTokens; use Laravel\Passport\HasApiTokens; use Silber\Bouncer\Database\HasRolesAndAbilities; // use App\Models\Role; class User extends Authenticatable { private $role_id=null; use HasApiTokens, HasFactory, Notifiable, HasRolesAndAbilities; /** * The attributes that are mass assignable. * * @var array<int, string> */ protected $fillable = [ 'asa_id', 'f_name', 'l_name', 'email', 'position', 'password', 'department_id', 'viber', 'position', 'active', 'status', 'password' ]; /** * The attributes that should be hidden for serialization. * * @var array<int, string> */ protected $hidden = [ 'password', 'remember_token', ]; /** * The attributes that should be cast. * * @var array<string, string> */ 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 = " * "; $query = sprintf( $this->getUsersQuery(), $fields, $array_data['search'], $array_data['where'], $array_data['sort'], $array_data['offset_limit'] ); // dd($query); 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); } public function getCategoriesNotif($dept_id){ $sql = "SELECT * FROM `categories` `ctg` WHERE `ctg`.`dept_id` = $dept_id AND `ctg`.`status` is null AND `ctg`.`sla_id` is null "; return DB::select($sql); } public function department(): BelongsTo { return $this->belongsTo(Department::class); } public function getSupportsReportQuery(){ return "SELECT %s FROM users INNER JOIN ticket_user ON users.id = ticket_user.assigned_to INNER JOIN ticket ON ticket_user.tix_id = ticket.id WHERE 1 %s "; } public function reports($array_data){ $fields = " ticket.*, users.* "; $query = sprintf( $this->getSupportsReportQuery(), $fields, $array_data['where'], ); // dd($query); return DB::select($query); } public function pdf($results, $type){ $data = []; $grpData = new \stdClass(); $grpData->list = $results; $grpData->total = sizeOf($results); array_push($data, $grpData); $report_title = "Supports Masterfile"; $reportData = [ 'data' => $data, 'webpage_title' => "Supports Report", 'report_title' => $report_title, 'table_headers' => ['No.','Ticket No.', 'Support', 'Date Started', 'Date Ended', 'Time Elapsed'], 'table_body' => ['ticket_no','l_name','start_date','end_date','time_elapsed'] ]; return $reportData; } public function getUserRole() { $role_id = DB::table('assigned_roles')->where('entity_id', Auth::user()->id)->first(); $this->role_id = $role_id ? $role_id->role_id : 3 ; return $this->role_id; } }
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings