Admin Control Panel v2.0

✎ Editing: ContactUsModel.php ← Back

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Request;
class ContactUsModel extends Model
{
    use HasFactory;

protected $table = 'contact_us';

static public function getSingle($id)
    {
        return self::find($id);
    }

static public function getRecord()
    {
        $return = self::select('contact_us.*');

if(!empty(Request::get('id')))
                {
                    $return = $return->where('id', '=', Request::get('id'));
                }

if(!empty(Request::get('name')))
                {
                    $return = $return->where('name', 'like', '%'.Request::get('name').'%');
                }

if(!empty(Request::get('email')))
                {
                    $return = $return->where('email', 'like', '%'.Request::get('email').'%');
                }

if(!empty(Request::get('subject')))
                {
                    $return = $return->where('subject', 'like', '%'.Request::get('subject').'%');
                }

$return = $return->orderBy('id', 'desc')
                    ->paginate(100);

return $return;

}

Cancel