Admin Control Panel v2.0

✎ Editing: ProductOrderModel.php ← Back

<?php

namespace App\Models;

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

class ProductOrderModel extends Model
{
    use HasFactory;

protected $table = 'product_order';

static public function getSingle($id)
    {
        return self::find($id);
    }
    
    static public function getProductOrder($id)
    {
        $user                 = ProductOrderModel::find($id);
        $data['id']           = $user->id;
        $data['user_id']      = !empty($user->user_id) ? $user->user_id : '';
        $data['product_id']   = !empty($user->product_id) ? $user->product_id : '';
        $data['total']        = !empty($user->total) ? $user->total : '0';
        $data['payment_type'] = !empty($user->payment_type) ? $user->payment_type : '0';
        $data['total_qty']    = !empty($user->total_qty) ? $user->total_qty : '0';
        $data['timestamp']    = strtotime($user->created_at);
        return $data;        
    }

static public function getRecord($request)
    {
        $return = self::select('product_order.*','buy.name as buyname', 'product.title','users.name as stationname')
            ->join('users as buy', 'buy.id', '=', 'product_order.user_id')
            ->join('product', 'product.id', '=', 'product_order.product_id')
            ->join('users', 'users.id', '=', 'product.user_id');
            
            // Search start
            if(!empty($request->get('id')))
            {
                $return = $return->where('product_order.id','=', $request->get('id'));    
            }

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

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

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

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

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

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

return $return;
    }

}

Cancel