芝麻web文件管理V1.00

编辑当前文件:/home/digitalh/yeahea.digitalhubbd.com/app/Models/Ticket.php

<?php

namespace App\Models;

use App\Common\Attachable;
use App\Common\Repliable;
use Illuminate\Support\Facades\Auth;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\SoftDeletes;

class Ticket extends BaseModel
{
    use HasFactory, SoftDeletes, Repliable, Attachable;

const STATUS_NEW = 1;         //Default
    const STATUS_OPEN = 2;
    const STATUS_PENDING = 3;
    const STATUS_SOLVED = 4;
    const STATUS_CLOSED = 5;
    const STATUS_SPAM = 6;

const PRIORITY_LOW = 1;    //Default
    const PRIORITY_NORMAL = 2;
    const PRIORITY_HIGH = 3;
    const PRIORITY_CRITICAL = 4;

/**
     * The database table used by the model.
     *
     * @var string
     */
    protected $table = 'tickets';

/**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'shop_id',
        'user_id',
        'status',
        'category_id',
        'priority',
        'subject',
        'message',
        'assigned_to',
    ];

/**
     * Get the shop associated with the model.
     */
    public function shop()
    {
        return $this->belongsTo(Shop::class)->withDefault([
            'name' => trans('app.vendor_not_available'),
        ]);
    }

/**
     * Get the user associated with the model.
     */
    public function user()
    {
        return $this->belongsTo(User::class)->withDefault();
    }

/**
     * Get the ticket category associated with the model.
     */
    public function category()
    {
        return $this->belongsTo(TicketCategory::class, 'category_id');
    }

/**
     * Get the ticket assigned to associated with the model.
     */
    public function assignedTo()
    {
        return $this->belongsTo(User::class, 'assigned_to');
    }

/**
 * Scope a query to only include records from the users shop.
 *
 * @return \Illuminate\Database\Eloquent\Builder
 */
 public function scopeAssignedToMe($query)
 {
 return $query->where('assigned_to', Auth::id())->where('status', '<', self::STATUS_SOLVED);
 }

/**
 * Scope a query to only include records from the users shop.
 *
 * @return \Illuminate\Database\Eloquent\Builder
 */
 public function scopeUnAssigned($query)
 {
 return $query->where('assign_id', null)->where('status', '<', self::STATUS_SOLVED);
 }

/**
 * Scope a query to only include records from the users shop.
 *
 * @return \Illuminate\Database\Eloquent\Builder
 */
 public function scopeOpen($query)
 {
 return $query->where('status', '<', self::STATUS_SOLVED);
 }

/**
     * Scope a query to only include records from the users shop.
     *
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeClosed($query)
    {
        return $query->where('status', '>=', self::STATUS_SOLVED);
    }

/**
     * Scope a query to only include records that have the given status.
     *
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeStatusOf($query, $status)
    {
        return $query->where('status', $status);
    }

/**
     * Scope a query to only include records that have the given priority.
     *
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopePriorityOf($query, $priority)
    {
        return $query->where('priority', $priority);
    }

/**
     * Scope a query to only include records from the users shop.
     *
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeCreatedByMe($query)
    {
        return $query->where('user_id', Auth::id());
    }

/**
     * Scope a query to only include records from the users shop.
     *
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeArchived($query)
    {
        return $query->onlyTrashed();
    }

public function statusName()
 {
 switch ($this->status) {
 case static::STATUS_NEW:
 return '' . trans('app.statuses.new') . '';

case static::STATUS_OPEN:
 return '' . trans('app.statuses.open') . '';

case static::STATUS_PENDING:
 return '' . trans('app.statuses.pending') . '';

case static::STATUS_SOLVED:
 return '' . trans('app.statuses.solved') . '';

case static::STATUS_CLOSED:
 return '' . trans('app.statuses.closed') . '';

case static::STATUS_SPAM:
 return '' . trans('app.statuses.spam') . '';
 }
 }

public function priorityLevel()
 {
 switch ($this->priority) {
 case static::PRIORITY_LOW:
 return '' . trans('app.priorities.low') . '';

case static::PRIORITY_NORMAL:
 return '' . trans('app.priorities.normal') . '';

case static::PRIORITY_HIGH:
 return '' . trans('app.priorities.high') . '';

case static::PRIORITY_CRITICAL:
 return '' . trans('app.priorities.critical') . '';
 }
 }
}

芝麻web文件管理V1.00

Oops! Page not found.