| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201 | <?phpnamespace app\api\controller;use app\common\controller\Api;use think\Db;use think\Exception;class Order extends Api{    protected $noNeedLogin = [];    protected $noNeedRight = '*';    protected $model = null;    public function _initialize()    {        parent::_initialize();        $this->model = Db::name('order');    }    /**     * 列表     * @return void     */    public function getList(){        try {            $status = input('status',0);//状态:1=待支付,2=待处理,3=已完成,4=已取消            $where['user_id'] = $this->auth->id;            if (!empty($status)) {                $where['status'] = $status;            }            $o = 'order';            $st = 'servicetype';            $field = $o.'.id,orderno,server_info,server_images,status,user_mobile,'.$o.'.user_car_number,'.                $o.'.createtime,cancel_time,cancel_reason,pay_fee,appen_fee,finish_time,'.$st.'.title as `service_title`,paytype';            $result = $this->model->alias($o)->field($field)                ->join($st,$st.'.id = '.$o.'.servicetype_id','LEFT')                ->where($where)->order($o.'.createtime desc')->autopage()->select();            if (!empty($result)) {                $statusArr  = [2=>'待处理',3=>'已完成',4=>'已取消'];                $paytypeArr = [1=>'线下',2=>'余额',3=>'微信'];                $timeArr = ['createtime','cancel_time','finish_time'];                foreach ($result as $key => &$value) {                    foreach ($timeArr as $k => $v) {                        $value[$v] = !empty($value[$v]) ? date('Y年m月d日 H:i:s', $value[$v]) : '';                    }                    $value['total_amounts'] = bcadd($value['pay_fee'],$value['appen_fee'],2);                    $value['status_text'] = isset($statusArr[$value['status']]) ? $statusArr[$value['status']] : '';                    $value['paytype_text'] = isset($paytypeArr[$value['paytype']]) ? $paytypeArr[$value['paytype']] : '';                }                $result = list_domain_image($result,['server_images']);            }            $this->success('获取成功', $result);        } catch (Exception $e) {            $this->error($e->getMessage());        }    }    /**     * 详情     * @return void     */    public function getInfo(){        try {            $id = input('id',0);            $payOrderId = input('pay_order_id',0);            if (!empty($payOrderId)) {                $orderWhere['pay_order_id'] = $payOrderId;                $order = Db::name('order')->field('id')->where($orderWhere)->find();                $id = isset($order['id']) ? $order['id'] : 0;            }            $o = 'order';            $st = 'servicetype';            $where[$o.'.user_id'] = $this->auth->id;            $where[$o.'.id'] = $id;            $field = $o.'.id,orderno,server_info,server_images,status,user_mobile,'.$o.'.user_car_number,'.                $o.'.createtime,cancel_time,cancel_reason,pay_fee,appen_fee,finish_time,'.$st.'.title as `service_title`,paytype';            $result = $this->model->alias($o)->field($field)                ->join($st,$st.'.id = '.$o.'.servicetype_id','LEFT')                ->where($where)->find();            if (!empty($result)) {                $statusArr  = [2=>'待处理',3=>'已完成',4=>'已取消'];                $paytypeArr = [1=>'线下',2=>'余额',3=>'微信'];                $timeArr = ['createtime','cancel_time','finish_time'];                foreach ($timeArr as $k => $v) {                    $result[$v] = !empty($result[$v]) ? date('Y年m月d日 H:i:s', $result[$v]) : '';                }                $result['total_amounts'] = bcadd($result['pay_fee'],$result['appen_fee'],2);                $result['status_text'] = isset($statusArr[$result['status']]) ? $statusArr[$result['status']] : '';                $result['paytype_text'] = isset($paytypeArr[$result['paytype']]) ? $paytypeArr[$result['paytype']] : '';                $orderAppenWhere['order_id'] = $id;                $orderAppen = Db::name('order_appen')->where($orderAppenWhere)->select();                $appenList = [];                if (!empty($orderAppen)) {                    foreach ($orderAppen as $key => $value) {                        $appenList[] = [                            'name' => $value['name'],                            'price' => $value['price'],                        ];                    }                }                $result['appen_list'] = $appenList;                $result = info_domain_image($result,['server_images']);            }            $this->success('获取成功', $result);        } catch (Exception $e) {            $this->error($e->getMessage());        }    }    /**     * 核销码     * @return void     */    public function writeOff()    {        try {            $id = $this->request->param('id',0);            $payOrderId = input('pay_order_id',0);            if (!empty($payOrderId)) {                $orderWhere['pay_order_id'] = $payOrderId;                $order = Db::name('order')->field('id')->where($orderWhere)->find();                $id = isset($order['id']) ? $order['id'] : 0;            }            $companyId = $this->auth->company_id;            $userId = $this->auth->id;            $where['id'] = $id;            $where['company_id'] = $companyId;            $where['user_id'] = $userId;            $where['status'] = 2;            $modelData = $this->model->where($where)->find();            if (empty($modelData)) {                throw new Exception('未找到相关信息');            }            $text = 'hexiaoorder_'.$id;            $logo = '';            $filRoute = '/uploads/temp/';            $saveDir = ROOT_PATH.'public/uploads/temp'.DS;            $fileStr = md5('order_'.$id);            $localpng = $saveDir.$fileStr.'.png';            //验证存在直接返回            $userCouponsUrl = $_SERVER['REQUEST_SCHEME'].'://'.$_SERVER['HTTP_HOST'].$filRoute.$fileStr.'.png';            if (!file_exists($localpng)) {                build_qrcode($text, $logo, $saveDir,$fileStr);            }            $result = [                'url' => $userCouponsUrl,            ];            $this->success('获取成功',$result);        } catch (Exception $e) {            $this->error($e->getMessage());        }    }        /**     * 保养列表     * @return void     */    public function upkeepList()    {        try {            $serviceTypeId = input('servicetype_id',0);            $carId = input('car_id',0);            $carNumber = input('car_number','');            $o = 'order';            $st = 'servicetype';            if (!empty($serviceTypeId)) {                $where[$o.'.servicetype_id'] = $serviceTypeId;            }            if (!empty($carId)) {                $where[$o.'.user_car_id'] = $carId;            }            if (empty($carNumber)) {                $where[$o.'.user_car_number'] = $carNumber;            }            $where[$o.'.user_id'] = $this->auth->id;            $where[$o.'.status'] = ['in',[2,3]];//状态:2=待处理,3=已完成,4=已取消            $where[$st.'.baoyang_switch'] = 1;//弹出保养时间:1=是,0=否            $field = $o.'.id,servicetype_id,server_info,finish_time,next_date,next_carlicheng,pay_fee,appen_fee,'.$st.'.title as `service_title`';            $result = $this->model->alias($o)->field($field)                ->join($st,$st.'.id = '.$o.'.servicetype_id','LEFT')                ->where($where)->order($o.'.finish_time desc')->autopage()->select();            if (!empty($result)) {                $timeArr = ['finish_time'];                foreach ($result as $key => &$value) {                    foreach ($timeArr as $k => $v) {                        $value[$v] = !empty($value[$v]) ? date('Y-m-d', $value[$v]) : '';                    }                    $value['total_amounts'] = bcadd($value['pay_fee'],$value['appen_fee'],2);                }            }                        $this->success('获取成功',$result);        } catch (Exception $e) {            $this->error($e->getMessage());        }    }}
 |