Viewing file:  Support.php (1.31 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class Support extends Model
{
protected $fillable = [
'subject',
'user',
'priority',
'end_date',
'ticket_code',
'ticket_created',
'status',
'created_by',
];
public static $priority = [
'Low',
'Medium',
'High',
'Critical',
];
public function createdBy()
{
return $this->hasOne('App\Models\user', 'id', 'ticket_created');
}
public function assignUser()
{
return $this->hasOne('App\Models\user', 'id', 'user');
}
public static $status = [
'Open' => 'Open',
'Close' => 'Close',
'On Hold' => 'On Hold',
];
public static function status() {
$status['Open'] = __ ('Open');
$status['Close'] = __ ('Close');
$status['On Hold'] = __ ('On Hold');
return $status;
}
public function replyUnread()
{
if(\Auth::user()->type == 'employee')
{
return SupportReply:: where('support_id', $this->id)->where('is_read', 0)->where('user', '!=', \Auth::user()->id)->count('id');
}
else
{
return SupportReply:: where('support_id', $this->id)->where('is_read', 0)->count('id');
}
}
}
|