goodcars_wxapp/application/api/controller/Shop.php

<?php


namespace app\api\controller;


use app\admin\model\Attribute;
use app\admin\model\Label;
use app\api\model\Category;
use app\api\model\ShopUserOld;
use app\api\model\StoreEvaluate;
use app\api\model\StoreOrder;
use app\api\model\StoreProduct;
use app\admin\model\store\StoreProductAttribute;
use app\api\model\StoreSeckill;
use app\common\controller\Api;
use app\api\model\ShopUser;
class Shop extends Api
{
    protected $noNeedLogin =[ 'attribute','attribute_xh','label','category','store_list'];//都需要登录

    //获取分类
    public function category(){
        $where = ['status' => 'normal'];
        $where['pid']=0;//商家下面的分类

        $list = Category::where($where)
            //->field('id,name,type')
            ->with('catelist')
            ->field('id,name,pid')
            ->order('weigh desc,id desc')
            ->select();
        $this->result('ok', $list, 1);
    }

    /**
     * 申请成为商家
     *
     * @ApiTitle    (申请成为商家)
     * @ApiSummary  (申请成为商家)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name="user-token", type="string", required=true, description="请求的Token")
     * @ApiRoute    (/api/shop/apply_shop)
     * @ApiParams   (name="user_id", type="int", required=true, description="用户user_id")
     * @ApiParams   (name="shop_user_id", type="int", required=true, description="商户申请id")
     */
    public function apply_shop(){
        $userId = $this->request->param('user_id');
        $shop_user_id=$this->request->param('shop_user_id');
        $get_is=ShopUser::where(['mid'=>$userId])->find();
        if(!empty($get_is)){
            if ($get_is['status']==0){
                $this->result('您提交的资料正在审核，请耐心等待',$get_is,'101');
            }elseif ($get_is['status']=='1' || $get_is['status']=='4'|| $get_is['status']=='5'){
                $this->result('您已经成为商家',$get_is,'103');
            }else{
                if (empty($shop_user_id)){//如果不是提交修改
                    $this->result('您提交的资料审核失败，请重新修改',$get_is,'102');
                }
            }
        }
        $post_array=$this->request->post();
        $name=$post_array['name'];//姓名
        $shopname=$post_array['shopname'];//店铺姓名
        $phone=$post_array['phone'];//手机号
        $effect_city=$post_array['effect_city'];//管理省市
        $city=$post_array['city'];//商家所在省市区
        $address=$post_array['address'];

        $cate_id=$post_array['cate_id'];//分类id
        $cate_top_id=$post_array['cate_top_id'];//分类id
        $type_id=$post_array['type_id'];//商店类型1个人，2车商，3  4s店



        $image=str_replace(config('site.siteUrl'),'',$post_array['image']);
        $images=str_replace(config('site.siteUrl'),'',$post_array['images']);
        if (empty($name) || empty($phone) || empty($effect_city) || empty($city)|| empty($address) || empty($cate_id) ){
            $this->result('数据丢失');
        }
        $time=time();
        $date=[
            'mid'=>$userId,
            'shopname'=>$shopname,
            'name'=>$name,
            'phone'=>$phone,
            'cate_id'=>$cate_id,
            'cate_top_id'=>$cate_top_id,
            'type_id'=>$type_id,
            'effect_city'=>$effect_city,
            'city'=>$city,
            'address'=>$address,
            'status'=>0,
            'image'=>$image,
            'images'=>$images,
            'updatetime'=>$time
        ];
        if (!empty($shop_user_id)){
            ShopUser::where('id',$shop_user_id)->update($date);
            $this->result('申请已经重新提交，等待审核', $shop_user_id, 1);
        }else{
            $date['createtime']=$time;
            if(ShopUser::insert($date)){		//添加数据
                $bid = ShopUser::getLastInsID();	//成功后跳转界面
                $this->result('申请已经提交，等待审核', $bid, 1);
            }else{
                $this->result('申请失败，请重新提交');
            }
        }
    }
    /**
     * 商家信息
     *
     * @ApiTitle    (商家信息)
     * @ApiSummary  (商家信息)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name="user-token", type="string", required=true, description="请求的Token")
     * @ApiRoute    (/api/shop/shop_info)
     * @ApiParams   (name="user_id", type="int", required=true, description="用户user_id")
     * @ApiParams   (name="type", type="int", required=true, description="1-查询返回个人信息 2-提交修改个人信息")
     * @ApiParams   (name="shop_user_id", type="int", required=true, description="商户申请id")
     */
    public function shop_info(){
        $userId = $this->request->post('user_id');
        $type = $this->request->post('type');
        $shop_user_id=$this->request->post('shop_user_id');
        if (empty($userId)){
            $this->result('系统错误，刷新重试');
        }
        if (!$type) {
            $type=1;
        }
        $get_is=ShopUser::where(['mid'=>$userId])->find();
        if(!empty($get_is)){
            if ($get_is['status']==0){
                $this->result('您提交的资料正在审核，请耐心等待',$get_is,'101');
            }elseif ($get_is['status']=='1' || $get_is['status']=='4' || $get_is['status']=='5'){
                if ($type==1){
                    $this->result('SUCCESS', $get_is, 1);
                }else{


                    $post_array=$this->request->post();
                    $name=$post_array['name'];//姓名
                    $phone=$post_array['phone'];//手机号
                    $city=$post_array['city'];//商家所在省市区
                  //  $effect_city=$post_array['effect_city'];//商家所在省市区
                    $address=$post_array['address'];
                    $image=str_replace(config('site.siteUrl'),'',$post_array['image']);
                    $images=str_replace(config('site.siteUrl'),'',$post_array['images']);
                    $time=time();
                    $date=[
                        'name'=>$name,
                        'phone'=>$phone,
                        'city'=>$city,
                        'address'=>$address,
                        'status'=>4,
                        'image'=>$image,
                        'images'=>$images,
                        'updatetime'=>$time
                    ];
                    if (!empty($post_array['effect_city'])){
                        $date['effect_city']=$post_array['effect_city'];
                    }

                    ShopUser::where(['mid'=>$userId])->update($date);


                    $image=str_replace(config('site.siteUrl').'/',"/",$get_is['image']);//商品图片
                    $images=str_replace(config('site.siteUrl').'/',"/",$get_is['images']);//商品图片
                    $image=str_replace(config('site.siteUrl'),"/",$image);//商品图片
                    $images=str_replace(config('site.siteUrl'),"/",$images);//商品图片


                    $insert=[
                        'suser_id'=>$get_is['id'],
                        'shopname'=>$get_is['shopname'],
                        'name'=>$get_is['name'],
                        'phone'=>$get_is['phone'],
                        'city'=>$get_is['city'],
                        'description'=>$get_is['description'],
                        'effect_city'=> $get_is['effect_city'],
                        'address'=>$get_is['address'],
                        'status'=>$get_is['status'],
                        'image'=>$image,
                        'images'=>implode(',',$images),
                        'updatetime'=>$time,
                        'createtime'=>$time
                    ];
                    ShopUserOld::insert($insert);

                 //   StoreProduct::where('suser_id',$shop_user_id)->update(['is_show'=>0]);
                    $this->result('申请已经重新提交，等待审核', $shop_user_id, 1);
                }
            }else{
                $this->result('您提交的资料审核失败，请重新修改',$get_is,'102');
            }
        }else{
            $this->result('您不是商家，请先去申请入驻');
        }

    }
    /**
     * 商品列表
     *
     * @ApiTitle    (商品列表)
     * @ApiSummary  (商品列表)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name="user-token", type="string", required=true, description="请求的Token")
     * @ApiRoute    (/api/shop/store_list)
     * @ApiParams   (name="user_id", type="int", required=true, description="用户user_id")
     * @ApiParams   (name="suser_id", type="int", required=true, description="商家id")
     */
    public function store_list(){
        $userId = $this->request->post('user_id');
        $suser_id= $this->request->post('suser_id');
        $search = $this->request->post('search');
        $cate_id = $this->request->post('cate_id');//分类id
        $where['is_del']=array('eq',0);
        if (!empty($suser_id)){
            $where['suser_id']=$suser_id;
        }
        if (!empty($search)){
            $where['store_name']=array('like','%'.$search.'%');
        }
        if (!empty($cate_id)){
            $where['cate_id']=$cate_id;
        }
        $list=StoreProduct::where($where)->field('id,slider_image,image,store_name,deposit_price,price,false as shop_show,cate_top_id ')->order('id desc')->select();
        foreach ($list as $k=>$v){
            $v['shop_show']=false;
        }

        $this->result('success', $list, 1);
    }
    //获取筛选条件
    public function attribute(){
        $cate_top_id = $this->request->post('cate_top_id');
        if (empty($cate_top_id)){
            $cate_top_id='0';
        }
        if ($cate_top_id=='17'){
            $whereArr['cate_top_id'] = array('in',['0','17']);
        }
        if ($cate_top_id=='18'){
            $whereArr['cate_top_id'] = array('in',['0','18']);
        }

        $whereArr['pid'] = array('eq',0);
        $whereArr['id'] = array('neq','4');
        $list = Attribute::where('status',1)
            ->where($whereArr)

            ->with('attlist')
            ->order('weigh desc,id desc')
            ->select();
        $this->result('SUCCESS', $list, 1);
    }
    //获取标签
    public function label(){
        $cate_top_id = $this->request->post('cate_top_id');
        if (empty($cate_top_id)){
            $cate_top_id='0';
        }
        if ($cate_top_id=='17'){
            $whereArr['cate_top_id'] = array('in',['0','17']);
        }
        if ($cate_top_id=='18'){
            $whereArr['cate_top_id'] = array('in',['0','18']);
        }
        if ($cate_top_id=='15'){
            $whereArr['cate_top_id'] = array('in',['0','15']);
        }


        $list = Label::where('status',1)
            ->field('id,name')
            ->order('weigh desc,id desc')
            ->select();
        $this->result('SUCCESS', $list, 1);
    }
    //获取筛选条件---型号
    public function attribute_xh(){
        $pid = $this->request->post('pid');
        $whereArr['pid'] = array('eq',$pid);

        $list =  Attribute::where('status',1)
            ->where($whereArr)
            ->order('weigh desc,id desc')
            ->select();
        $this->result('SUCCESS', $list, 1);
    }
    /**
     * 商品添加
     *
     * @ApiTitle    (商品添加)
     * @ApiSummary  (商品添加)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name="user-token", type="string", required=true, description="请求的Token")
     * @ApiRoute    (/api/shop/store_add)
     * @ApiParams   (name="user_id", type="int", required=true, description="用户user_id")
     * @ApiParams   (name="type", type="int", required=true, description="1添加 2修改")
     * @ApiParams   (name="store_id", type="int", required=true, description="商品id")
     */
    public function  store_add(){
        $userId = $this->request->post('user_id');
        $type = $this->request->post('type');
        $store_id = $this->request->post('store_id');
        if ($type==2 && empty($store_id)){
            $this->result('系统错误，刷新重试');
        }
        $get_is=ShopUser::where(['mid'=>$userId])->find();

        if(!empty($get_is)){
            if($get_is['status']!='1'){
                $this->result('您提交的信息正在审核，现在无法发布商品');
            }else{
                if (empty($type)){
                    $type=1;
                }
                $time=time();
                $post=$this->request->post('',null,null);
                $insert['car_number']=mt_rand('1000000','9999999');


                $insert['suser_id']=$post['suser_id'];//商家id
                $insert['store_name']=$post['store_name'];//商品名称
                $insert['store_info']=$post['store_info'];//商品简介

//                if ($post['cate_top_id']=='14') {
//                    $insert['car_info'] = $post['car_info'];//车况
//                }
                $image=str_replace(config('site.siteUrl'),"/",$post['image']);//商品图片
                $slider_image=str_replace(config('site.siteUrl'),"/",$post['slider_image']);//商品图片
                $mp4=str_replace(config('site.siteUrl'),"/",$post['mp4']);//商品图片


//
//                $image=str_replace('http://car.xoxoso.com/'.'/',"/",$image);//商品图片
//                $slider_image=str_replace('http://car.xoxoso.com/'.'/',"/",$slider_image);//商品图片
//                $mp4=str_replace('http://car.xoxoso.com/'.'/',"/",$mp4);//商品图片


                $insert['image']=str_replace('//u',"/u",$image);//商品图片
                $insert['slider_image']=str_replace('//u',"/u",$slider_image);//商品图片
                $insert['mp4']=str_replace('//u'.'/',"/u",$mp4);//视频


                $insert['cate_id']=$post['cate_id'];//商品分类
                $insert['cate_top_id']=$post['cate_top_id'];//商品上级分类
                $insert['one_commission']=empty($post['one_commission'])?'0':$post['one_commission'];;//商品一级分销比例
                $insert['two_commission']=empty($post['two_commission'])?'0':$post['two_commission'];;//商品二级分销比例

                if (($insert['one_commission']+  $insert['two_commission'])>=100){
                    $this->result('佣金比例最高100');
                }
                $insert['price']=$post['price'];//商品价格
                $insert['deposit_price']=$post['deposit_price'];//商品定金
                $insert['special_price']=$post['special_price'];//商品市场价
                $insert['stock']=$post['stock'];//商品库存
                $insert['is_show']=$post['is_show'];//上下架状态 0 下架 1上架
                $insert['is_seckill']=empty($post['is_seckill'])?'0':$post['is_seckill'];//上下架状态 0 下架 1上架
                $insert['description']=$post['description'];//商品描述
                $insert['feight_id']=$post['feight_id'];//邮费id
                $insert['updatetime']=$time;//修改时间


                $label=$this->request->post('label');
                if (!empty($label)){
                    $insert['label']=$label;//标签
                }
                $car_start_date=$this->request->post('car_start_date');
                if (!empty($car_start_date)){
                    $insert['car_start_date']=$car_start_date;//上牌日期
                }
                $car_distance=$this->request->post('car_distance');
                if (!empty($car_distance)){
                    $insert['car_distance']=$car_distance;//标签
                }
                if ($type==1){
                    $insert['createtime']=$time;
                    if(StoreProduct::insert($insert)){		//添加数据
                        $bid = StoreProduct::getLastInsID();	//成功后跳转界面
                        $insert_seckill['store_id']=$bid;
                        $insert_seckill['sort']='1';
                        $insert_seckill['is_hot']='0';
                        $insert_seckill['sales']='0';
                        $insert_seckill['add_time']=time();
                        $insert_seckill['price']=empty($post['seckill_price'])?date('Y-m-d'):$post['seckill_price'];
                        $insert_seckill['stock']=empty($post['seckill_stock'])?'0':$post['seckill_stock'];
                        $insert_seckill['start_time']=empty($post['seckill_start_time'])?date('Y-m-d'):$post['seckill_start_time'];
                        $insert_seckill['time_id']=empty($post['seckill_time_id'])?'0':$post['seckill_time_id'];
                        if (empty($post['is_seckill'])){
                            $insert_seckill['is_show']='0';
                        }else{
                            $insert_seckill['is_show']='1';
                        }
                        StoreSeckill::insert($insert_seckill);
                        if ($post['cate_top_id']=='14'){
                            if (!empty($post['attribute'])){
                                $attribute=$post['attribute'];
                                $attribute_array=explode(',',$attribute);
                                $insert_attr['suser_id']=$post['suser_id'];//商家id
                                $insert_attr['pro_id']=$bid;
                                foreach ($attribute_array as $k=>$v){
                                    $a=explode(':',$v);
                                    if (!empty($a)){
                                        $insert_attr['attribute_id']=$a['0'];
                                        if (empty($a['1'])){
                                            $insert_attr['attribute_list_id']=0;
                                            $insert_attr['attribute_list_value']=$a['2'];
                                        }else{
                                            $insert_attr['attribute_list_id']=$a['1'];
                                            $insert_attr['attribute_list_value']=$a['2'];
                                        }
                                        $insert_attr['createtime']=$insert_attr['updatetime']=time();
                                        StoreProductAttribute::insert($insert_attr);
                                        if ($a['0']==4 && empty($insert['store_name'])){
                                            $get_a = Attribute::where('id',$a['1'])->field('name')->find();
                                            if (!empty($a['2'])){
                                                $get_b = Attribute::where('id',$a['2'])->field('name')->find();
                                                $store_name=$get_a['name'].' '.$get_b['name'];
                                            }else{
                                                $store_name=$get_a['name'];
                                            }

                                            $save = StoreProduct::where('id', $bid)
                                                ->update(['store_name'=>$store_name]);
                                        }
                                    }

                                }
                            }
                        }
                        $this->result('SUCCESS', $bid, 1);
                    }else{
                        $this->result('发布失败，稍后重试');
                    }
                }else{
                    $save = StoreProduct::where('id', $store_id)
                        ->update($insert);
                    $insert_seckill['price']=empty($post['seckill_price'])?date('Y-m-d'):$post['seckill_price'];
                    $insert_seckill['stock']=empty($post['seckill_stock'])?'0':$post['seckill_stock'];
                    $insert_seckill['start_time']=empty($post['seckill_start_time'])?date('Y-m-d'):$post['seckill_start_time'];
                    $insert_seckill['time_id']=empty($post['seckill_time_id'])?'0':$post['seckill_time_id'];
                    if (empty($post['is_seckill'])){
                        $insert_seckill['is_show']='0';
                    }else{
                        $insert_seckill['is_show']='1';
                    }
                    $get_seck=  StoreSeckill::where('store_id', $store_id)->find();
                    if (empty($get_seck)){
                        $insert_seckill['store_id']=$store_id;
                        $insert_seckill['sort']='1';
                        $insert_seckill['is_hot']='0';
                        $insert_seckill['sales']='0';
                        $insert_seckill['add_time']=time();
                        StoreSeckill::insert($insert_seckill);
                    }else{
                        StoreSeckill::where('store_id', $store_id)->update($insert_seckill);
                    }


                    if ($post['cate_top_id']=='14') {
                        $attribute=$post['attribute'];
                        $attribute_array=explode(',',$attribute);
                        $insert_attr['suser_id']=$post['suser_id'];//商家id
                        $insert_attr['pro_id']=$store_id;
                        StoreProductAttribute::where('pro_id',$store_id)->delete();
                        if (!empty($attribute_array)){
                            foreach ($attribute_array as $k=>$v){
                                $a=explode(':',$v);
                                if (!empty($a)){
                                    $insert_attr['attribute_id']=$a['0'];
                                    if (empty($a['1'])){
                                        $insert_attr['attribute_list_id']=0;
                                        $insert_attr['attribute_list_value']=$a['2'];
                                    }else{
                                        $insert_attr['attribute_list_id']=$a['1'];
                                        $insert_attr['attribute_list_value']=$a['2'];
                                    }
                                    $insert_attr['createtime']=$insert_attr['updatetime']=time();
                                    StoreProductAttribute::insert($insert_attr);
                                    if ($a['0']==4 && empty($insert['store_name'])){
                                        $get_a = Attribute::where('id',$a['1'])->field('name')->find();
                                        if (!empty($a['2'])){
                                            $get_b = Attribute::where('id',$a['2'])->field('name')->find();
                                            $store_name=$get_a['name'].' '.$get_b['name'];
                                        }else{
                                            $store_name=$get_a['name'];
                                        }

                                        $save = StoreProduct::where('id', $store_id)
                                            ->update(['store_name'=>$store_name]);
                                    }
                                }

                            }
                        }




                    }
                    $this->result('SUCCESS'.$post['is_seckill'], $store_id, 1);
                }
            }
        }else{
            $this->result('您不是商家，无法发布商品');
        }
    }

    /**
     * 商品详情
     *
     * @ApiTitle    (商品详情)
     * @ApiSummary  (商品详情)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name="user-token", type="string", required=true, description="请求的Token")
     * @ApiRoute    (/api/shop/store_info)
     * @ApiParams   (name="suser_id", type="int", required=true, description="suser_id")
     * @ApiParams   (name="store_id", type="int", required=true, description="商品id")//
     */
    public function  store_info(){

        $store_id = $this->request->post('store_id');
        $suser_id = $this->request->post('suser_id');
        if (empty($store_id)){
            $this->result('系统错误，刷新重试');
        }
        $where['id']=$store_id;
        $where['suser_id']=$suser_id;
        $where['is_del']=array('eq',0);
        $get=StoreProduct::where($where)->with(['storeseckill','storeseckill.seckilltime','attribute'])->find();
        if (empty($get)){
            $this->result('商品不存在');
        }

        $list = Attribute::where('status',1)
            ->where(['pid'=>0])
            ->with('attlist')
            ->order('weigh desc,id desc')
            ->select();

        if (!empty($list)){
            $pro_list['id']='';
            $pro_list['attribute_list_id']='';
            $pro_list['attribute_list_value']='';
            foreach ($list as $k=>$v){
                $pro=StoreProductAttribute::where('pro_id',$store_id)->with('attribute')->where('attribute_id',$v['id'])->find();
                if (!empty($pro)){
                    $list[$k]['pro']=$pro;
                }else{
                    $list[$k]['pro']=$pro_list;
                }
            }
        }

        $get['attribute_list']=$list;

        $label_array=[];
        if (!empty($get['label'])){
            foreach ($get['label'] as $k=>$v){
                $list = Label::where('id',$v)
                    ->field('id,name')
                    ->find();
                $label_array[]=$list;
            }
        }
        if (!empty($get['attribute'])){
            foreach ($get['attribute'] as $k=>$v){
                if ($v['attribute_id']=='4'){
                    if (!empty($v['attribute_list_value'])){
                        $a = Attribute::where(['id'=>$v['attribute_list_value']])
                            ->find();
                        $get['xinghao']=$a;
                    }
                }
            }
        }
        $get['label']=$label_array;
        $this->result('SUCCESS',$get,1);
    }
    /**
     * 商品删除
     *
     * @ApiTitle    (商品删除)
     * @ApiSummary  (商品删除)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name="user-token", type="string", required=true, description="请求的Token")
     * @ApiRoute    (/api/shop/store_del)
     * @ApiParams   (name="suser_id", type="int", required=true, description="suser_id")
     * @ApiParams   (name="store_id", type="int", required=true, description="商品id")//
     */
    public function  store_del(){
        $store_id = $this->request->post('store_id');
        $suser_id = $this->request->post('suser_id');
        if (empty($store_id)){
            $this->result('系统错误，刷新重试');
        }
        $where['id']=$store_id;
        $where['suser_id']=$suser_id;
        $where['is_del']=array('eq',0);
        $get=StoreProduct::where($where)->field('id')->find();
        if (empty($get)){
            $this->result('商品不存在');
        }
        $insert['is_del']=1;//修改时间
        $insert['updatetime']=time();//修改时间
        $save = StoreProduct::where('id', $store_id)
            ->update($insert);
         StoreSeckill::where('store_id', $store_id)
            ->update(['is_del'=>'1']);

        $this->result('SUCCESS', $store_id, 1);
    }

    /**
     * 订单列表
     *
     * @ApiTitle    (订单列表)
     * @ApiSummary  (订单列表)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name="user-token", type="string", required=true, description="请求的Token")
     * @ApiRoute    ( /api/shop/order_list)
     * @ApiParams   (name="suser_id", type="int", required=true, description="suser_id")
     * @ApiParams   (name="type", type="int", required=true, description="all 全部")订单状态（-1 : 申请退款 -2 : 退货成功 0：待付款，1：待发货（已付款）；2：待收货（已发货）；3：已收货（确认收货，待评价）；4：已评价；-1：已退款）
     */
    public function  order_list(){
        $suser_id = $this->request->post('suser_id');
        $search = $this->request->post('search');
        if (empty($suser_id)){
            $this->result('系统错误，刷新重试');
        }

        $type = $this->request->post('type');
        if (empty($type)){
            $type=0;
        }
        if (!empty($search)){
            $where['store_name']=array('like','%'.$search.'%');
        }
        if ($type==14){
            $where['cate_id']=14;//定金订单，是车辆的
            $where['status']=['in',['3','4']];
        }else{
            $where['cate_id']=15;
            if ($type=='1'){
                $where['status']=['eq','1'];
            }elseif($type=='2'){
                $where['status']=['eq','2'];
            }elseif($type=='3'){
                $where['status']=['in',['3','4']];
            }elseif($type=='-1'){
                $where['status']=['in',['-1','-2','-3','-4','-5']];
            }
        }

        $where['suser_id']=$suser_id;
        $where['is_del']=0;
        $where['is_system_del']=0;
        $get_order=StoreOrder::where($where)
            ->where('status','neq','9')
            ->with(['member','product'])
            ->field('id,order_id,total_price,total_num,freight_price,mid,suser_id,store_product_id,prepay_id,status,mark,delivery_id,delivery_name,commission_price')
            ->order('id','desc')
            ->select();
        $this->result('SUCCESS', $get_order, 1);
    }


    /**
     * 订单详情
     *
     * @ApiTitle    (订单详情)
     * @ApiSummary  (订单详情)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name="user-token", type="string", required=true, description="请求的Token")
     * @ApiRoute    (/api/shop/order_info)
     * @ApiParams   (name="user_id", type="int", required=true, description="用户user_id")
     * @ApiParams   (name="order_id", type="int", required=true, description="订单编号 id"
     */
    public function  order_info(){

        $user_id = $this->request->post('user_id');
        $id = $this->request->post('order_id');
        $suser_id = $this->request->post('suser_id');

//        $where['mid']=$user_id;
        $where['id']=$id;
        $where['suser_id']=$suser_id;
        $where['is_del']=0;
        $where['is_system_del']=0;
        $get_order=StoreOrder::where($where)
            ->with(['product','express','refundexpress'])
            //->field('id,order_id,total_price,total_num,freight_price,mid,suser_id,store_product_id,prepay_id,type')
            ->find();
        if (empty($get_order)){
            $this->result('此订单已删除');
        }

        $this->result('success',$get_order,1);
    }
    /**
     * 订单发货
     * @ApiTitle    (订单发货)
     * @ApiSummary  (订单发货)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name="user-token", type="string", required=true, description="请求的Token")
     * @ApiRoute    (/api/shop/order_deliver)
     * @ApiParams   (name="user_id", type="int", required=true, description="用户user_id")
     * @ApiParams   (name="order_id", type="int", required=true, description="订单编号 id")
     */
    public function  order_deliver(){
        $user_id = $this->request->post('user_id');
        $id = $this->request->post('order_id');
        $suser_id = $this->request->post('suser_id');
        $delivery_name = $this->request->post('delivery_name');
        $delivery_id = $this->request->post('delivery_id');


      //  $where['mid']=$user_id;
        $where['suser_id']=$suser_id;
        $where['id']=$id;
        $where['is_del']=0;
        $where['is_system_del']=0;
        $where['status']=['in',['1','2','-3']];
       // dump($where);
        $get_order=StoreOrder::where($where)
            ->field('id,status,delivery_id')
            ->find();
       // echo $get_order->getLastSql();
        if (empty($get_order)){
            $this->result('此订单不能操作发货');
        }

        if (!empty($delivery_name) && !empty($delivery_id)){
            StoreOrder::where(['id' => $id])->update(['delivery_name'=>$delivery_name,'delivery_id'=>$delivery_id,'status'=>'2']);
        }


        $this->result('success',$get_order,1);
    }
    /**
     * 退款处理
     * @ApiTitle    (退款处理)
     * @ApiSummary  (退款处理)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name="user-token", type="string", required=true, description="请求的Token")
     * @ApiRoute    (/api/shop/order_refund)
     * @ApiParams   (name="user_id", type="int", required=true, description="用户user_id")
     * @ApiParams   (name="order_id", type="int", required=true, description="订单编号 id")
     */
    public function  order_refund(){
        $user_id = $this->request->post('user_id');
        $id = $this->request->post('order_id');
        $suser_id = $this->request->post('suser_id');
        $refund_reason= $this->request->post('refund_reason');
        $refund_status = $this->request->post('refund_status');


       // $where['mid']=$user_id;
        $where['suser_id']=$suser_id;
        $where['id']=$id;
        $where['id']=$id;
        $where['is_del']=0;
        $where['is_system_del']=0;
        $where['status']=['in',['-1','-2','-3','-4']];
        $get_order=StoreOrder::where($where)
            ->field('id,status,refund_status,refund_type,order_id,pay_price,refund_price')
            ->find();
        if (empty($get_order)){
            $this->result('此订单不能再次进行退款操作');
        }


        if ($refund_status==1  || $refund_status==3){
            if ($get_order['refund_status'] !='4'){
                StoreOrder::where(['id' => $id])->update(['refund_status'=>$refund_status,'refund_reason'=>$refund_reason,'status'=>0-$refund_status]);
                $this->result('success',$get_order,1);
            }
        }elseif($refund_status==2){
            if ($get_order['refund_type']=='0'){
                if ($get_order['refund_status'] !='4'){
                    StoreOrder::where(['id' => $id])->update(['refund_status'=>$refund_status,'refund_reason'=>$refund_reason,'status'=>0-$refund_status]);
                    $this->result('success',$get_order,1);
                }
            }else{
                if ($get_order['refund_status'] !='5'){
                    $reoderSn=$get_order['order_id'];//订单编号
                    //获取支付金额
                    $money =$get_order['pay_price'];
                    $wx = new WxPay();//实例化微信支付控制器

                    $body = '订单号' . $get_order['order_id'];//支付说明
                    $out_trade_no = $reoderSn;//订单号
                    $total_fee = $money * 100;//支付金额(乘以100)
                    $refund_fee=$get_order['refund_price']*100;
                    $order = $wx->wxrefund($out_trade_no,date('YmdHis').time(),$total_fee,$refund_fee);
                    // dump($order);
                    if(($order['return_code']=='SUCCESS') && ($order['result_code']=='SUCCESS')){
                        StoreOrder::where(['id' => $id])->update(['refund_status'=>'5','refund_reason'=>$refund_reason,'status'=>'-5']);
                        $this->result('success',$get_order,1);
                    }else if(($order['return_code']=='FAIL') || $order['result_code']=='FAIL' ){
                        $reason = (empty($order['err_code_des'])?$order['return_msg']:$order['err_code_des']);

                        $this->result('退款失败',$reason);
                    }else{
                        $this->result('退款失败');
                    }
                }
            }
        }elseif($refund_status=5){
            if ($get_order['refund_status'] !='5'){
                $reoderSn=$get_order['order_id'];//订单编号
                //获取支付金额
                $money =$get_order['pay_price'];
                $wx = new WxPay();//实例化微信支付控制器

                $body = '订单号' . $get_order['order_id'];//支付说明
                $out_trade_no = $reoderSn;//订单号
                $total_fee = $money * 100;//支付金额(乘以100)
                $refund_fee=$get_order['refund_price']*100;
                $order = $wx->wxrefund($out_trade_no,date('YmdHis').time(),$total_fee,$refund_fee);
                // dump($order);
                if(($order['return_code']=='SUCCESS') && ($order['result_code']=='SUCCESS')){
                    StoreOrder::where(['id' => $id])->update(['refund_status'=>$refund_status,'refund_reason'=>$refund_reason,'status'=>0-$refund_status]);
                    $this->result('success',$get_order,1);
                }else if(($order['return_code']=='FAIL') || $order['result_code']=='FAIL' ){
                    $reason = (empty($order['err_code_des'])?$order['return_msg']:$order['err_code_des']);

                    $this->result('退款失败',$reason);
                }else{
                    $this->result('退款失败');
                }
            }
            $this->result('退款失败');
        }

    }
    /**
     * 订单评价
     * @ApiTitle    (订单评价)
     * @ApiSummary  (订单评价)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name="user-token", type="string", required=true, description="请求的Token")
     * @ApiRoute    (/api/shop/order_evaluate)
     * @ApiParams   (name="user_id", type="int", required=true, description="用户user_id")
     * @ApiParams   (name="order_id", type="int", required=true, description="订单编号 id")
     */
    public function  order_evaluate(){
        $user_id = $this->request->post('user_id');
        $id = $this->request->post('order_id');
        $suser_id = $this->request->post('suser_id');

        $get= StoreEvaluate::where('order_id',$id)->with(['member','reply','shopuser'])->where('pid','0')->find();
//        $huifu=[];
        if (!empty($get)){
            $get['add_time']=$get['createtime'];
//            $huifu=StoreEvaluate::where('order_id',$id)->where('pid',$get['id'])->where('mid','0')->find();
        }
//        $get['huifu']=$huifu;
        $this->result('success',$get,1);
    }
    /**
     * 订单评价回复
     * @ApiTitle    (订单评价回复)
     * @ApiSummary  (订单评价回复)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name="user-token", type="string", required=true, description="请求的Token")
     * @ApiRoute    (/api/shop/order_evaluate_huifu)
     * @ApiParams   (name="user_id", type="int", required=true, description="用户user_id")
     * @ApiParams   (name="order_id", type="int", required=true, description="订单编号 id")
     */
    public function  order_evaluate_huifu(){
        $user_id = $this->request->post('user_id');
        $id = $this->request->post('order_id');
        $evaluate_id = $this->request->post('evaluate_id');
        $content= $this->request->post('content');

        $get= StoreEvaluate::where('order_id',$id)->where('pid','0')->where('id',$evaluate_id)->find();
        StoreEvaluate::where('order_id',$id)->where('pid',$get['id'])->delete();
        $insert['mid']='';
        $insert['store_id']=$get['store_id'];
        $insert['order_id']=$get['order_id'];
        $insert['suser_id']=$get['suser_id'];
        $insert['xj']='0';
        $insert['content']=$content;
        $insert['pid']=$get['id'];
        $insert['status']=1;
        $insert['createtime']=$insert['updatetime']=time();
        StoreEvaluate::insert($insert);

        $this->result('success',$get,1);
    }


    /**
     * 账单列表
     *
     * @ApiTitle    (账单列表)
     * @ApiSummary  (账单列表)
     * @ApiMethod   (POST)
     * @ApiHeaders  (name="user-token", type="string", required=true, description="请求的Token")
     * @ApiRoute    ( /api/shop/take_order_list)
     * @ApiParams   (name="suser_id", type="int", required=true, description="suser_id")
     * @ApiParams   (name="mouth", type="int", required=true, description="本月")
     */
    function getthemonth($date)
    {

        $firstday = date('Y-m-01', strtotime($date));

        $lastday = date('Y-m-d', strtotime("$firstday +1 month -1 day"));

        return array($firstday, $lastday);

    }
    public function  take_order_list(){
        $suser_id = $this->request->post('suser_id');
        if (empty($suser_id)){
            $this->result('系统错误，刷新重试');
        }

        $mouth = $this->request->post('mouth');
        $type= $this->request->post('type');
        if (empty($mouth) || $mouth=='本月'){
            $mouth=date('Y-m');
        }
        if ($type=='年'){
            $start=$mouth.'-01-01';
            $end=$mouth.'-12-31';


           $s= strtotime($start.'00:00:00');
           $e=strtotime($end.'23:59:59');
           $where['take_time'] = array('between',$s.",".$e);

        }
        if ($type=='月'){
            $time_array=$this->getthemonth($mouth);
            $start=$time_array['0'];
            $end=$time_array['1'];
            $s= strtotime($start.'00:00:00');
            $e=strtotime($end.'23:59:59');
            $where['take_time'] = array('between',$s.",".$e);
        }
        if ($type=='日'){
            $s= strtotime($mouth.'00:00:00');
            $e=strtotime($mouth.'23:59:59');
            $where['take_time'] = array('between',$s.",".$e);
        }





        $where['suser_id']=$suser_id;
        $where['status']=['in',['3','4']];
        $where1['take_time']=['neq',''];

        $get_order=StoreOrder::where($where)
            ->with(['member'])
            ->where($where1)
            ->field('id,order_id,take_time,mid,suser_id,pay_price,commission_price')
            ->order('take_time','desc')
            ->select();

        $get_num=StoreOrder::where($where)
            ->where($where1)
            ->field('sum(pay_price-commission_price) as order_price,count(*) as order_num')
            ->find();
        foreach ($get_order as $k=>$v){
            $get_order[$k]['take_date']=date('Y-m-d',$v['take_time']);
        }
        $this->result('SUCCESS', ['list'=>$get_order,'num'=>$get_num], 1);
    }



}