bztang-admin/app/frontend/models/Order.php

<?php
/**
 * Created by PhpStorm.
 * Author:  
 * Date: 2017/4/6
 * Time: 下午4:35
 */
namespace app\frontend\models;

use Carbon\Carbon;
use Illuminate\Database\Eloquent\Builder;

/**
 * Class Order
 * @package app\frontend\models
 * @property Member belongsToMember
 * @property Carbon finish_time
 * @property int refund_id
 */
class Order extends \app\common\models\Order
{
    protected $appends = ['dispatch_type_name', 'status_name', 'pay_type_name', 'button_models'];
    protected $hidden = [
        'uniacid',
        'is_deleted',
        'is_member_deleted',
//        'create_time',
//        'pay_time',
//        'send_time',
//        'finish_time',
        'uid',
        'cancel_time',
        'created_at',
        'updated_at',
        'deleted_at',
        'hasOneDispatchType',
    ];
    public function scopeDetail($query){
        return $query->with(['hasManyOrderGoods'=>function($query){
            return $query->detail();
        }])->select(['id','uid','order_sn','price','goods_price','create_time','finish_time','pay_time','send_time','cancel_time','dispatch_type_id','pay_type_id','status','refund_id','dispatch_price','deduction_price']);
    }

    public function scopeKeywordSearch($query, $keyword)
    {

        if (empty($keyword)) {
            return $query;
        }

        $query->leftJoin('yz_order_address','yz_order_address.order_id', '=', 'yz_order.id');

        $query->join('yz_order_goods','yz_order_goods.order_id', '=', 'yz_order.id');


        $query->where(function ($where) use ($keyword) {
            return $where->where('yz_order_address.mobile', 'like', '%' . $keyword . '%')
                ->orWhere('yz_order_address.realname', 'like', '%' . $keyword . '%')
                ->orWhere('yz_order_goods.title', 'like', '%' . $keyword . '%')
                ->orWhere('yz_order.order_sn','like',"%{$keyword}%");
        });
        //$query->addSelect('yz_order.*');

        return $query;

    }


    /**
     * 订单列表
     * @return $this
     */
    public function scopeOrders($query)
    {

        return $query->with([
            'hasManyOrderGoods'=> function($query){
                return $query->with(['hasOneComment' => function($comment_query){
                    $comment_query->select('id','order_id','goods_id','level','content');
                }])->select(['id','order_id','goods_id', 'refund_id', 'is_refund','goods_price','total','price', 'payment_amount','thumb','title','goods_option_id','goods_option_title','comment_status','comment_id','vip_price']);
            },
            'hasOnePayType',
            'process',
            'address' => self::addressBuilder(),
        ])->orderBy('yz_order.id','desc');
    }

    private static function addressBuilder()
    {
        return function ($query) {
            return $query->select('address', 'mobile', 'realname', 'order_id');
        };
    }

    public function getDispatchTypeNameAttribute()
    {
        $name = $this->hasOneDispatchType ? $this->hasOneDispatchType->name : '';
        if ($name == '快递') {
            $name = \Setting::get('shop.lang.zh_cn.order.express')?:'快递';
        }
        return $name;
    }

    public function belongsToMember()
    {
        return $this->belongsTo(app('OrderManager')->make('Member'), 'uid', 'uid');
    }

    public function belongsToOrderGoods()
    {
        return $this->belongsTo(app('OrderManager')->make('OrderGoods'), 'id', 'order_id');
    }

    public function orderGoodsBuilder($status)
    {
        $operator = [];
        if ($status == 0) {
            $operator['operator'] = '=';
            $operator['status'] = 0;
        } else {
            $operator['operator'] = '>';
            $operator['status'] = 0;
        }
        return function ($query) use ($operator) {
            return $query->with('hasOneComment')->where('comment_status', $operator['operator'], $operator['status']);
        };
    }

    public static function getMyCommentList($status)
    {
        $operator = [];
        if ($status == 0) {
            $operator['operator'] = '=';
            $operator['status'] = 0;
        } else {
            $operator['operator'] = '>';
            $operator['status'] = 0;
        }
        return self::whereHas('hasManyOrderGoods', function($query) use ($operator){
                return $query->where('comment_status', $operator['operator'], $operator['status']);
            })
            ->with([
                'hasManyOrderGoods' => self::orderGoodsBuilder($status)
            ])->where('status', 3)->orderBy('id', 'desc')->get();
    }
    public static function getMyCommentListPaginate($status,$page,$pageSize)
    {
        $operator = [];
        if ($status == 0) {
            $operator['operator'] = '=';
            $operator['status'] = 0;
        } else {
            $operator['operator'] = '>';
            $operator['status'] = 0;
        }
        return self::whereHas('hasManyOrderGoods', function($query) use ($operator){
            return $query->where('comment_status', $operator['operator'], $operator['status']);
        })
            ->with([
                'hasManyOrderGoods' => self::orderGoodsBuilder($status)
            ])->where('status', 3)->orderBy('id', 'desc')->paginate($pageSize,['*'],'page',$page);
    }

    /**
     * 关系链 指定商品
     *
     * @param $uid
     * @return \Illuminate\Database\Eloquent\Collection|static[]
     */
    public static function getOrderListByUid($uid)
    {
        return self::select(['*'])
            ->where('status','>=',1)
            ->where('status','<=',3)
            ->with(['hasManyOrderGoods'=>function($query){
                return $query->select(['*']);
            }])
            ->get();
    }


    public static function boot()
    {
        parent::boot();

        self::addGlobalScope(function(Builder $query){
            return $query->uid();
        });
    }

    /**
     * @return array
     * @throws \app\common\exceptions\AppException
     */
    public function getOperationsSetting()
    {
        if (Member::current()->uid == $this->uid) {
            $operationsSettings = \app\common\modules\shop\OrderFrontendButtonConfig::current()->get('order_frontend_button');
            $operations = array_values(collect($operationsSettings)->where('plugin_id',$this->plugin_id)->sortByDesc('weight')->all());
            if (empty($operations)) {//没找到用plugin_id为0的
                $operations = array_values(collect($operationsSettings)->where('plugin_id',0)->sortByDesc('weight')->all());
            }
            return $operations;
//            //return app('OrderManager')->setting('member_order_operations')[$this->statusCode] ?: [];
//
//            $arr = app('OrderManager')->setting('member_order_operations')[$this->statusCode] ?: [];
//
//            if ($this->statusCode == 'waitSend' && !in_array('app\frontend\modules\order\operations\member\ExpeditingDelivery',$arr) && in_array($this->plugin_id,[0,92])) {
//                array_push($arr,'app\frontend\modules\order\operations\member\ExpeditingDelivery');
//            }
//            return $arr;
        }
        return [];
    }

    /**
     * 订单状态汉字 （因为前端不想显示锁定字样，所以在前端模型重写这个）
     * @return string
     */
    public function getStatusNameAttribute()
    {
        if (!$this->isClose() && $this->currentProcess()) {
            return $this->currentProcess()->status_name;
        }
        $statusName = $this->getStatusService()->getStatusName();
//        if ($this->isPending()) {
//            $statusName .= ' : 锁定';
//        }

        return $statusName;
    }
}