Admin Control Panel v2.0

✎ Editing: ProductOrderItemModel.php ← Back

<?php

namespace App\Models;

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

class ProductOrderItemModel extends Model
{
    use HasFactory;

protected $table = 'product_order_item';

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

static public function getProductOrderItem($id)
    {
        $user                 = ProductOrderItemModel::find($id);
        $data['id']           = $user->id;
        $data['user_id']      = !empty($user->user_id) ? $user->user_id : '';
        $data['product_order_id']   = !empty($user->product_order_id) ? $user->product_order_id : '';
        $data['price']        = !empty($user->price) ? $user->price : '0';
        $data['qty']          = !empty($user->qty) ? $user->qty : '0';
        $data['timestamp']    = strtotime($user->created_at);
        return $data;        
    }

static public function getSingleOrdersItems($id, $request, $pagi = 0)
    {

$return = self::select('product_order_item.*', 'users.name')
            ->join('users','users.id','=','product_order_item.user_id');

if(!empty($pagi))
            {
                $return = $return->orderBy('product_order_item.id','desc');
                $return = $return->where('product_order_item.product_order_id','=',$id)->get();
            }
            else
            {
                $return = $return->orderBy('product_order_item.id','desc');
                $return = $return->where('product_order_item.product_order_id','=',$id)->paginate(40);    
            }
            
            return $return;
    }
}

Cancel