<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class Order extends Model
{
    use SoftDeletes;

    protected $fillable = [
        'product_id', 'user_id', 'quantity', 'address','transaction_status','transaction_id' 
    ];

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

    public function product()
    {
        return $this->belongsTo(Product::class, 'product_id');
    }

    public static function getProductOrder($productId, $user_id)
    {
        $date = date('Y-m-d');
        $order = Order::where(array('user_id'=>$user_id, 'product_id'=>$productId))
                // ->whereDate('end_dt', '>=', $date)
                ->orderBy("orders.id","desc")
                ->first();
        if(!empty($order)){
            if($order->end_dt>= $date){
                return 1;
            }
            else{
                return 0;
            }
        }
        else{
            return 0;
        }
    }
}