FM / reception

/home/techb158/ileadtechnology.com/SSM/app/Models/reception/

/home/techb158/ileadtechnology.com/SSM/app/Models/reception

Name	Size	Mode	Actions
CallLog.php	3837	0644	edit dl rm
Complaint.php	3658	0644	edit dl rm
Enquiry.php	4199	0644	edit dl rm
EnquiryDetail.php	1732	0644	edit dl rm
EnquiryFollowUp.php	1589	0644	edit dl rm
GatePass.php	3170	0644	edit dl rm
PostalRecord.php	3203	0644	edit dl rm
VisitorLog.php	3544	0644	edit dl rm
VisitorMessage.php	1898	0644	edit dl rm

Edit: /home/techb158/ileadtechnology.com/SSM/app/Models/reception/VisitorMessage.php (1898B)

<?php

namespace App\Models\Reception;

use Illuminate\Database\Eloquent\Model;
use Spatie\Activitylog\Traits\LogsActivity;

class VisitorMessage extends Model
{
    use LogsActivity;

protected $fillable = [
                            'name',
                            'email',
                            'contact_number',
                            'subject',
                            'message',
                            'options'
                        ];
    protected $casts = ['options' => 'array'];
    protected $primaryKey = 'id';
    protected $table = 'visitor_messages';
    protected static $logName = 'visitor_message';
    protected static $logFillable = true;
    protected static $logOnlyDirty = true;
    protected static $ignoreChangedAttributes = ['updated_at'];

public function getOption(string $option)
    {
        return array_get($this->options, $option);
    }

public function scopeFilterById($q, $id)
    {
        if (! $id) {
            return $q;
        }

return $q->where('id', '=', $id);
    }
    
    public function scopeFilterByName($q, $name, $strict = 0)
    {
        if (! $name) {
            return $q;
        }

return ($strict) ? $q->where('name', '=', $name) : $q->where('name', 'like', '%'.$name.'%');
    }
    
    public function scopeFilterByEmail($q, $email, $strict = 0)
    {
        if (! $email) {
            return $q;
        }

return ($strict) ? $q->where('email', '=', $email) : $q->where('email', 'like', '%'.$email.'%');
    }

public function scopeDateBetween($q, $dates)
    {
        if ((! $dates['start_date'] || ! $dates['end_date']) && $dates['start_date'] <= $dates['end_date']) {
            return $q;
        }

return $q->where('created_at', '>=', getStartOfDate($dates['start_date']))->where('created_at', '<=', getEndOfDate($dates['end_date']));
    }
}

'array']; protected $primaryKey = 'id'; protected $table = 'visitor_messages'; protected static $logName = 'visitor_message'; protected static $logFillable = true; protected static $logOnlyDirty = true; protected static $ignoreChangedAttributes = ['updated_at']; public function getOption(string $option) { return array_get($this->options, $option); } public function scopeFilterById($q, $id) { if (! $id) { return $q; } return $q->where('id', '=', $id); } public function scopeFilterByName($q, $name, $strict = 0) { if (! $name) { return $q; } return ($strict) ? $q->where('name', '=', $name) : $q->where('name', 'like', '%'.$name.'%'); } public function scopeFilterByEmail($q, $email, $strict = 0) { if (! $email) { return $q; } return ($strict) ? $q->where('email', '=', $email) : $q->where('email', 'like', '%'.$email.'%'); } public function scopeDateBetween($q, $dates) { if ((! $dates['start_date'] || ! $dates['end_date']) && $dates['start_date'] <= $dates['end_date']) { return $q; } return $q->where('created_at', '>=', getStartOfDate($dates['start_date']))->where('created_at', '<=', getEndOfDate($dates['end_date'])); } }