Admin Control Panel v2.0

✎ Editing: RefillModel.php ← Back

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class RefillModel extends Model
{
    use HasFactory;

protected $table = 'refill';

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

static public function getRecord($request)
    {
        $return = self::select('refill.*','users.name')
            ->join('users', 'users.id', '=', 'refill.user_id');
            //Search start
            if(!empty($request->get('id')))
            {
                $return = $return->where('refill.id','=', $request->get('id'));    
            }

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

if(!empty($request->get('title')))
            {
                $return = $return->where('refill.title','like','%'.$request->get('title').'%');    
            }

if(!empty($request->get('price')))
            {
                $return = $return->where('refill.price','like','%'.$request->get('price').'%');    
            }

if(!empty($request->get('status'))) 
            {
                  $status = $request->get('status');
                  if ($request->status == '1000') 
                  {
                      $status = '0';
                  }

$return = $return->where('refill.status', '=', $status);
            }

//Search end

$return = $return->where('refill.is_delete', '=', 0)
                ->orderBy('refill.id', 'desc')
                ->paginate(50);

return $return;
    }

static public function getRecordUser($user_id)
    {
        return self::select('refill.*')
                    ->join('users', 'users.id', '=', 'refill.user_id')
                    ->where('refill.user_id', '=', $user_id)
                    ->orderBy('refill.id', 'desc')
                    ->paginate(20);
    }

public function getImageIcon()
    {
        if(!empty($this->image_icon) && file_exists('upload/refill/'.$this->image_icon))
        {
            return url('upload/refill/'.$this->image_icon);
        }
        else
        {
            //return url('assets/icons/profile.png');
            return "";
        }
    }

public function getUserName() {
        return $this->belongsTo(User::class, "user_id");
    }

static public function totalRefillCount() {
        return self::select('refill.*')->where('refill.is_delete', '=', '0')->count();
    }
}

Cancel