/home/kueuepay/public_html/app/Models/SupportTicket.php
<?php

namespace App\Models;

use App\Constants\SupportTicketConst;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Factories\HasFactory;

class SupportTicket extends Model
{
    use HasFactory;

    protected $guarded = ['id'];

    protected $with = [
        'user',
        'attachments'
    ];

    protected $appends = ['stringStatus'];

    protected $casts = [
        'id'                => 'integer',
        'user_id'           => 'integer',
        'token'             => 'string',
        'type'              => 'string',
        'name'              => 'string',
        'email'             => 'string',
        'desc'              => 'string',
        'subject'           => 'string',
        'status'            => 'integer',
        'created_at'        => 'datetime',
        'updated_at'        => 'datetime',
    ];
    public function authSolution() {
        $data = [
            'class'     => "",
            'foreign'   => "",
        ];

        if(get_auth_guard() == 'web') {
            $data = [
                'class'     => User::class,
                'foreign'   => "user_id",
            ];
        }
        return (object) $data;
    }

    public function scopeAuthTickets($query) {
        $foreign_key = $this->authSolution()->foreign;
        return $query->where($foreign_key,auth()->user()->id);
    }

    public function user() {
        return $this->belongsTo(User::class);
    }

    

    public function getCreatorAttribute() {
        if($this->type == SupportTicketConst::TYPE_USER) {
            return $this->user()->first();
        }else if($this->type == SupportTicketConst::TYPE_AGENT) {
            return $this->agent()->first();
        }
        return null;
    }

    public function attachments() {
        return $this->hasMany(SupportTicketAttachment::class);
    }

    public function conversations() {
        return $this->hasMany(SupportChat::class,"support_ticket_id");
    }

    public function scopePending($query) {
        return $query->where("status",SupportTicketConst::PENDING)->orWhere("status",SupportTicketConst::DEFAULT);
    }

    public function scopeActive($query) {
        return $query->where("status",SupportTicketConst::ACTIVE);
    }

    public function scopeSolved($query) {
        return $query->where("status",SupportTicketConst::SOLVED);
    }

    public function scopeNotSolved($query,$token) {
        $query->where('token',$token)->where('status','!=',SupportTicketConst::SOLVED);
    }

    public function getStringStatusAttribute() {
        $status = $this->status;
        
        $data = [
            'class' => "",
            'value' => "",
        ];
        if($status == SupportTicketConst::ACTIVE) {
            $data = [
                'class'     => "badge badge--info",
                'value'     => __("Active"),
            ];
        }else if($status == SupportTicketConst::DEFAULT) {
            $data = [
                'class'     => "badge badge--warning",
                'value'     => __("Default"),
            ];
        }else if($status == SupportTicketConst::PENDING) {
            $data = [
                'class'     => "badge badge--warning",
                'value'     => __("Pending"),
            ];
        }else if($status == SupportTicketConst::SOLVED) {
            $data = [
                'class'     => "badge badge--success",
                'value'     => __("Solved"),
            ];
        }

        return (object) $data;
    }
}
Path: home/kueuepay/public_html/app/Models
User Registration
top

In the digital age, privacy concerns have become increasingly paramount, prompting the European Union to enact the General Data Protection Regulation (GDPR) in 2018. Among its many provisions, GDPR sets strict guidelines for the collection and processing of personal data, including the use of cookies on websites. Privacy Policy