zccy/app/models/store/StoreExchangeOrder.php

<?php
/**
 *
 * @author: xaboy<365615158@qq.com>
 * @day: 2017/12/18
 */

namespace app\models\store;

use crmeb\basic\BaseModel;
use crmeb\traits\ModelTrait;

/**
 * TODO 秒杀产品Model
 * Class StoreSeckill
 * @package app\models\store
 */
class StoreExchangeOrder extends BaseModel
{
    /**
     * 数据表主键
     * @var string
     */
    protected $pk = 'id';

    /**
     * 模型名称
     * @var string
     */
    protected $name = 'store_exchange_order';
    use ModelTrait;


    public static function getUserOrderSearchList($uid, $type, $page, $limit, $search)
    {
        if ($search) {
            $order = self::searchUserOrder($uid, $search) ?: [];
            $list = $order == false ? [] : [$order];
        } else {
            $list = self::getUserOrderList($uid, $type, $page, $limit);
        }
        foreach ($list as $k => $order) {
            $list[$k]['order'] = StoreOrder::get($order['oid']);
            $list[$k]['cart_info'] = StoreOrderCartInfo::where('oid', $order['oid'])
                ->where('cart_id', $order['cart_id'])
                ->value('cart_info');
            if (is_string($list[$k]['cart_info'])) $list[$k]['cart_info'] = json_decode($list[$k]['cart_info'], true);
        }
        return $list;
    }

    public static function searchUserOrder($uid, $order_id)
    {
        $order = self::where('uid|gift_uid', $uid)->where('order_id', $order_id)->where('is_del', 0)
            ->order('add_time DESC')->select();
        if (!$order)
            return false;
        else
            return $order;

    }

    public static function getUserOrderList($uid, $status = '', $page = 0, $limit = 8)
    {
        if ($page) $list = self::statusByWhere($status, $uid)->where('is_del', 0)->where('uid|gift_uid', $uid)
            ->order('add_time DESC')->page((int)$page, (int)$limit)->select()->toArray();
        else  $list = self::statusByWhere($status, $uid)->where('is_del', 0)->where('uid|gift_uid', $uid)
            ->order('add_time DESC')->page((int)$page, (int)$limit)->select()->toArray();
        return $list;
    }

    public static function statusByWhere($status, $uid = 0, $model = null)
    {
        if ($model == null) $model = new self;
        if ('' === $status)
            return $model;
        else if ($status == 0)//待使用
            return $model->where('status', 0)->where('refund_status', 0);
        else if ($status == 1)//已使用
            return $model->where('status', 1)->where('refund_status', 0);
        else if ($status == -1)//退款中
            return $model->where('refund_status', 1);
        else if ($status == -2)//已退款
            return $model->where('refund_status', 2);
        else if ($status == -3)//退款
            return $model->where('refund_status', 'IN', '1,2');
        else
            return $model;
    }
}