Admin Control Panel v2.0

✎ Editing: OrderRefillModel.php ← Back

<?php

namespace App\Models;

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

class OrderRefillModel extends Model
{
    use HasFactory;

protected $table = 'order_refill';

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

static public function getOrderRefill($id)
    {
        $user                = OrderRefillModel::find($id);
        $data['id']          = $user->id;
        $data['user_id']     = !empty($user->user_id) ? $user->user_id : '';
        $data['refill_id']   = !empty($user->refill_id) ? $user->refill_id : '';
        $data['total_refill']= !empty($user->total_refill) ? $user->total_refill : '0';
        $data['payment_type']= !empty($user->payment_type) ? $user->payment_type : '0';
        $data['timestamp']   = strtotime($user->created_at);
        return $data;        
    }

static public function getRecord($request)
    {
        $return = self::select('order_refill.*','buy.name  as buyname', 'users.name')
          ->join('users as buy', 'buy.id', '=', 'order_refill.user_id')
          ->join('users', 'users.id', '=', 'order_refill.refill_id');

// Search start
            if(!empty($request->get('id')))
            {
                $return = $return->where('order_refill.id','=', $request->get('id'));    
            }

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

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

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

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

$return = $return->where('order_refill.payment_type', '=', $payment_type);
            }
            // Search end

$return = $return->orderBy('order_refill.id', 'desc')
                ->paginate(5);

return $return;
    }

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

static public function getRecordOrder($user_id)
    {
        return self::select('order_refill.*', 'refill.title', 'refill.ar_title', 'refill.price', 'refill.image_icon')
                    ->join('users', 'users.id', '=', 'order_refill.user_id')
                    ->join('refill', 'refill.id', '=', 'order_refill.refill_id')
                    ->where('order_refill.user_id', '=', $user_id)
                    ->orderBy('order_refill.id', 'desc')
                    ->paginate(5);
    }

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 "";
        }
    }

}

Cancel