<?php

namespace Yajny\Member\Models;

use Illuminate\Database\Eloquent\Model;
use Yajny\Member\Traits\MemberScopes;
use Yajny\Traits\HasCurrency;

class UserReferralSales extends Model
{
    //

    use MemberScopes, HasCurrency;

    protected $table = 'user_referrer_sales';
    protected $primaryKey = 'id';
    public $dateColumn = 'created_at';
    public $directTable = 'user_referrer_sales';

    protected $fillable = [

    ];

    // columns to be copied from Sale table to here
    public $copyColumns = [
        'store_id','order_amount','currency','transaction_time','status','local_order_amount','currency_rate'
    ];

    private $currencyConversionFields = [
        'order_amount', 'referral_amount'
    ];

    public function user(){
        return $this->hasOne('Yajny\Member\Models\Member','user_id','user_id');
    }

    public function shopper(){
        return $this->belongsTo('Yajny\Member\Models\Member','shopper_id','user_id');
    }


    public function store(){
        return $this->hasOne('Yajny\Models\Store','id','store_id');
    }

    public function sale(){
        return $this->hasOne('Yajny\Models\Sale','id','sales_id');
    }

    public function user_sale()
    {
        return $this->hasOne('Yajny\Models\UserSale','sales_id','sales_id');
    }


    public function scopeOrderBySale($q){

        return  $q->orderBy($this->primaryKey,'DESC');
     }


}