huizhen/app/admin/model/diagnosis/DiagnosisOrder.php

<?php

/**
 *
 * @author: xaboy<365615158@qq.com>
 * @day: 2017/11/02
 */

namespace app\admin\model\diagnosis;

use app\admin\model\store\StoreProduct;
use app\admin\model\system\SystemAdmin;
use app\models\article\ArticleContent;
use crmeb\traits\ModelTrait;
use crmeb\basic\BaseModel;
use think\model\concern\SoftDelete;

/**
 * 图文管理 Model
 * Class WechatNews
 * @package app\admin\model\wechat
 */
class DiagnosisOrder extends BaseModel
{

    use ModelTrait;

    protected $pk = 'id';

    protected $name = 'diagnosis_order';

    protected $autoWriteTimestamp = true;
    use SoftDelete;
    protected $deleteTime = 'delete_time';

    public static function list($where)
    {
        $model = self::alias('a')
            ->field('a.*,b.nickname,c.nickname as re_nickname')
            ->leftJoin('user b', 'a.uid = b.uid')
            ->leftJoin('user c', 'a.order_receiving = c.uid')
            ->order('a.id DESC');

        if ($where['name'])$model->where('a.uid|b.nickname' , 'like', '%'.$where['name'].'%');
        if ($where['order_id'])$model->where('a.order_id' , 'like', '%'.$where['order_id'].'%');
        if ($where['rece'])$model->where('a.order_receiving|c.nickname' , 'like', '%'.$where['rece'].'%');
        if ($where['type'])$model->where('type' , $where['type']);
        if (isset($where['data']) && $where['data'] !== '') {
            $model = self::getModelTime($where, $model,   'create_time');
        }
        $data['count'] = $model->count();
        if ($where['page'] && $where['limit']){
            $model->page($where['page'], $where['limit']);
        }else{
            $model->page(20, 1);
        }


        $list = $model->select()->toArray();
        foreach ($list as &$item)
        {
            if ($item['paid'] == 0) $item['paid'] = '未支付';
            if ($item['paid'] == 1) $item['paid'] = '已支付';
            if ($item['pay_type'] == 1) $item['pay_type'] = '余额';
            if ($item['pay_type'] == 2) $item['pay_type'] = '微信';
            if ($item['pay_type'] == 3) $item['pay_type'] = '支付宝';
            $item['cate'] = implode(',',DiagnosisCate::where('id', 'in', $item['cate_id'])->column('name'));
            if ($item['status'] == 0){
                $item['status'] = '待接单';
            }elseif ($item['status'] == 1){
                $item['status'] = '已接单';
            }elseif ($item['status'] == 2){
                $item['status'] = '已完成';
            }elseif ($item['status'] == -1){
                $item['status'] = '已过期';
            }elseif ($item['status'] == -2){
                if ($item['refund_status'] == 0){
                    $item['status'] = '待退款';
                }elseif ($item['refund_status'] == 1){
                    $item['status'] = '已退款';
                }

            }
            if ($item['type'] == 1){
                $item['type'] = '陪诊';
            }elseif ($item['type'] == 2){
                $item['type'] = '代办';
            }
        }
        $data['data'] = $list;
        return $data;

    }
}