chuyu/application/api/controller/Order.php

<?php

namespace app\api\controller;

use app\admin\model\Cannelorder;
use app\admin\model\Evaluate;
use app\admin\model\Pay;
use app\admin\model\RecoveryBill;
use app\admin\model\Recoveryorder;
use app\admin\model\Good;
use app\admin\model\Goodcard;
use app\admin\model\Goodorder;
use app\admin\model\Tableware;
use app\admin\model\TablewareBill;
use app\admin\model\TablewareOrder;
use app\admin\model\Useradress;
use app\admin\model\UserRelations;
use app\common\controller\Api;
use EasyWeChat\Factory;
use think\Db;
use think\Exception;
use think\exception\ErrorException;

class Order extends Api
{
    protected $noNeedLogin = [];
    protected $noNeedRight = ['*'];
    /**
     * 餐具订单
     */
    public function create_order(){
        $user = $this->auth->id;
        $input = input();
        $tableware_model  = new Tableware();
        $addres_model = new Useradress();
        $user_relationes_model = new UserRelations();
        $address_id = $input['address_id'];
        $b_user_id = $user_relationes_model->where('c_user_id',$user)->where('b_level',3)->field('b_user_id,status')->find();
        if(empty($b_user_id)){
            $this->error('联系管理人员添加配送员');
        }
        if($b_user_id['status']==0){
            $user_relationes_model->save(['status'=>1],['c_user_id'=>$user,'b_level'=>3]);
        }
        $b_user_info = user_info($b_user_id['b_user_id']);
        $address_info = $addres_model->where('id',$address_id)->find();
        if(empty($input['tableware_id'])){
            $this->error('餐具信息不能为空');
        }
        $tableware_info = $tableware_model->where('id',$input['tableware_id'])->where('state',1)->find();
        $image = explode(',',$tableware_info['showimages']);
        if(empty($tableware_info)){
            $this->error('餐具信息错误');
        }
        if($input['num']<1){
            $this->error('下单餐具数量不能小于1');
        }
        if($tableware_info['stock']<$input['num']){
            $this->error('库存不足');
        }

        $order_no =order_no($user);
        $data =[
            'order_no'=>$order_no,
            'c_user_id'=>$user,
            'c_username'=>$this->auth->username,
            'c_mobile'=>$this->auth->mobile,
            'tableware_id'=>$input['tableware_id'],
            'tableware_name'=>$tableware_info['tableware_name'],
            'tableware_image'=>$image[0],
            'number'=>$input['num'],
            'price'=>$tableware_info['price'],
            'order_money'=>$input['num']*$tableware_info['price'],
            'create_time'=>time(),
            'city'=>city_name($address_info['province_id']).city_name($address_info['city_id']).city_name($address_info['area_id']),
            'address'=>$address_info['address'],
            'order_desc'=>$input['order_desc'],
            'delivery_status'=>1,
            'status'=>2,
            'b_user_id'=>$b_user_id['b_user_id'],
            'b_username'=>$b_user_info['username'],
            'b_mobile'=>$b_user_info['mobile'],
            'admin_id'=>$tableware_info['admin_id'],
            'admin_name'=>Db::name('admin')->where('id',$tableware_info['admin_id'])->value('nickname')
        ];
        $tableware_order_model = new TablewareOrder();

        Db::startTrans();
        try {
            $tableware_order_model->insertGetId($data);
            $tableware_model->isUpdate(true,['id'=>$input['tableware_id']])->save(['stock'=>$tableware_info['stock']-$input['num']]);
            Db::commit();
            $this->success('订单创建成功');
        }catch (Exception $e){
            Db::rollback();
            $this->error('订单为创建失败，重新下单');
        }
    }

    /**
     * @return void
     * 我的厨余餐具订单
     */
    public function me_tab_order(){
        $page = input('page',1);
        $mon = input('date',date('Y-m'));
        $user = $this->auth->id;
        $tableware_model = new TablewareOrder();
        $tableware_bill_model = new TablewareBill();
        $date = getMonthRange($mon);
        $is_have = $tableware_bill_model->whereBetween('date',[strtotime($date['sdate']),strtotime($date['edate'])])->where('c_user_id',$user)->find();
        $list = $tableware_model->whereBetween('create_time',[strtotime($date['sdate']),strtotime($date['edate'])])->where('c_user_id',$user)->paginate('5','',['page'=>$page]);
        $sate = 1;
        $data['bill']=[];
        if($is_have){
            if($is_have['status']==1) {
                $sate = 2;
            }
            if($is_have['status']==2) {
                $sate = 3;
            }
            $data['bill']=$is_have;
        }
        $data['list']=$list;
        $data['sate']=$sate;
        $this->success('月份订单',$data);
    }

    /**
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * 餐具订单
     */
    public function tab_order(){
        $user_id = $this->auth->id;
        $page = input('page',1);
        $tableware_order_model = new TablewareOrder();
        $info = $tableware_order_model->where('c_user_id',$user_id)->paginate('5','',['page'=>$page]);
        $this->success('餐具配送订单',$info);
    }
    /**
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * 餐具订单
     */
    public function tab_order_info(){
        $user_id = $this->auth->id;
        $tab_id = input('order_id');
        $tableware_order_model = new TablewareOrder();
        $info = $tableware_order_model->where('c_user_id',$user_id)->where('id',$tab_id)->find();
        $this->success('餐具配送订单',$info);
    }

    /**
     * @return void
     *商城商品加入购物车
     */
    public function good_card(){
        $good_model = new Good();
        $good_cart_model = new Goodcard();
        $user_id = $this->auth->id;
        $good_id = input('id');
        $num = input('num',0);
        if(empty($good_id)){
            $this->error('商品信息不能为空');
        }
        $good_info = $good_model->where('id',$good_id)->field('stock,name,goodimgaes,price')->find();
        $image = explode(',',$good_info['goodimgaes']);
        if($num<1){
            if($num>$good_info['num']){
                $this->error('库存不足');
            }
            $this->error('数量不能小于1');
        }
        $is_have = $good_cart_model->where(array('user_id'=>$user_id,'good_id'=>$good_id))->find();
        if($is_have){
            $good_cart_model->isUpdate(true,['user_id'=>$user_id,'good_id'=>$good_id])->save(['num'=>$is_have['num']+$num]);
        }else {
            $data = [
                'good_id' => $good_id,
                'good_name' => $good_info['name'],
                'good_image' => $image[0],
                'price' => $good_info['price'],
                'num' => $num,
                'create_time' => time(),
                'user_id' => $user_id
            ];

            $good_cart_model->insert($data);
        }
        $this->success('加入购物车成功');
    }

    /**
     * @return void
     *商品下单
     */
    public function create_good_order(){
        $user_id = $this->auth->id;
        $goods_model = new Good();
        $good_order_order = new Goodorder();
        $address_model = new Useradress();
        $score=input('score',0);
        $good_id = input('good_id');
        $address_id = input('address_id');
        $address_info = $address_model->where('id',$address_id)->where('user_id',$user_id)->find();
        if(empty($good_id)){
            $this->error('商品信息不能为空');
        }
        $good_info  = $goods_model->where('id',$good_id)->find();
        $image = explode(',',$good_info['goodimgaes']);
        $num = input('num');
        if($num<1){
            if($num>$good_info['num']){
                $this->error('库存不足');
            }
            $this->error('数量不能小于1');
        }
        $order_no  = order_no($user_id);

        $data = [
            'good_id'=>$good_id,
            'user_id'=>$user_id,
            'order_no'=>$order_no,
            'good_name'=>$good_info['name'],
            'good_image'=>$image[0],
            'price'=>$good_info['price'],
            'num'=>$num,
            'total'=>$good_info['price']*$num,
            'status'=>1,
            'pay_no'=>pay_no($user_id),
            'realname'=>$this->auth->username,
            'phone'=>$this->auth->mobile,
            'city'=>city_name($address_info['province_id']).city_name('city_ic').city_name('area_id'),
            'address'=>$address_info['address'],
            'create_time'=>time(),
        ];
        if($score>=config('site.score_cash_offset')){
            $user_collont = new User();
            $user_collont->add_score_log($user_id,$score,2,'商城购物消耗');
            $data['total']=$data['total']-$score/config('site.score_cash_offset');
            if($data['total']<=0){
                $data['total']=0.01;
            }

        }
        $good_order_order->insert($data);
        $pay = [
            'pay_no'=>$data['pay_no'],
            'status'=>1,
            'user_id'=>$user_id,
            'username'=> $this->auth->username,
            'price'=>$data['total'],
            'create_time'=>time()
        ];
        $pay_model = new Pay();
        $pay_model->insert($pay);
        $this->success('订单创建成功',['pay'=>$data['pay_no']]);
    }

    /**
     * @return void
     * @throws \think\exception\DbException
     * 购物车列表
     */
    public function card_list(){
        $page = input('page',1);
        $user_id = $this->auth->id;
        $good_card_model = new Goodcard();
        $list = $good_card_model->alias('c')->join('good g','g.id=c.good_id')->where('user_id',$user_id)->order('id','DESC')->field('c.*,g.price new_price')->paginate('5','',['page'=>$page]);

        $this->success('购物车列表',$list);
    }

    /**
     * @return void
     * 购物车修改
     */
    public function card_save(){
        $crad_id= input('crad_id');
        $num = input('number');
        $good_card_model = new Goodcard();
        Db::startTrans();
        try {
            $good_card_model->save(['num'=>$num],['id'=>$crad_id]);
            Db::commit();
            $this->success('修改成功');

        }catch (ErrorException $e){
            Db::rollback();
            $this->error('修改失败');

        }
    }

    /**
     * @return void
     * 购物车删除
     */
    public function card_delect(){
        $crad_id= input('crad_id');
        $user_id = $this->auth->id;
        $good_card_model = new Goodcard();
        Db::startTrans();
        try {
            $good_card_model->where(array('id'=>$crad_id,'user_id'=>$user_id))->delete();

            Db::commit();
            $this->success('删除成功');

        }catch (ErrorException $e){
            Db::rollback();
            $this->error('删除失败');

        }
    }

    /**
     * @return void
     * 购物车下单
     */
    public function card_order(){
        $good_card_model = new Goodcard();
        $good_model = new Good();
        $goo_order_model = new Goodorder();
        $address_model = new Useradress();
        $user_id = $this->auth->id;
        $card_ids = input('card_ids');
        $address_id = input('address_id');
        $address_info = $address_model->where('id',$address_id)->where('user_id',$user_id)->find();
        $gooo_card_list = $good_card_model->whereIn('id',$card_ids)->select();
        $total = 0;
        $pay_no=pay_no($user_id);
        foreach ($gooo_card_list as &$v){
            $good_info = $good_model->where('id',$v['good_id'])->find();
            $image = explode(',',$good_info['goodimgaes']);
            $data[] = [
                'good_id'=>$good_info['id'],
                'user_id'=>$user_id,
                'order_no'=>order_no($user_id),
                'good_name'=>$good_info['name'],
                'good_image'=>$image[0],
                'price'=>$good_info['price'],
                'num'=>$v['num'],
                'total'=>$good_info['price']*$v['num'],
                'status'=>1,
                'pay_no'=>$pay_no,
                'realname'=>$this->auth->username,
                'phone'=>$this->auth->mobile,
                'city'=>city_name($address_info['province_id']).city_name('city_ic').city_name('area_id'),
                'address'=>$address_info['address'],
                'create_time'=>time(),
            ];
            $total =$total+$good_info['price']*$v['num'];
        }
        $goo_order_model->insertAll($data);
        $score=input('score',0);
        if($score>=config('site.score_cash_offset')){
            $user_collont = new User();
            $user_collont->add_score_log($user_id,$score,2,'商城购物消耗');
            $total=$total-$score/config('site.score_cash_offset');
            if($total<=0){
                $total=0.01;
            }
        }
        $pay = [
            'pay_no'=>$pay_no,
            'status'=>1,
            'user_id'=>$user_id,
            'username'=> $this->auth->username,
            'price'=>$total,
            'create_time'=>time()
        ];
        $pay_model = new Pay();
        $pay_model->insert($pay);
        $good_card_model->whereIn('id',$card_ids)->delete();
        $this->success('下单成功',['pay'=>$pay_no]);
    }

    /**
     * @return void
     * @throws \think\exception\DbException
     * 我的商城订单
     */
    public function my_shop_goods(){
        $user_id = $this->auth->id;
        $good_model = new Goodorder();
        $page = input('page',1);
        $status = input('status');
        $where = [];
        if(!empty($status)){
            if($status>4){
                $where['status'] = ['in','5,7'];

            }
            else {
                $where['status'] = $status;
            }
        }
        $order_list = $good_model->where('user_id',$user_id)->where($where)->order('id','DESC')->paginate('5','',['page'=>$page]);
        $this->success('我的商城订单',$order_list);
    }

    /**s
     * @return void
     * 首页回收订单
     */
    public function my_recovery_order(){
        $user_id = $this->auth->id;
        $recovery_order_model = new Recoveryorder();
        $user_model = new \app\admin\model\User();
        $order_info = $recovery_order_model->where('c_user_id',$user_id)->order('create_time','DESC')->find();
        $user_info = $user_model->where('id',$order_info['b_user_id'])->field('username,nickname,mobile')->find();
        $order_info['h_name']=$user_info['username'];
        $order_info['mobile']=$user_info['mobile'];
        $this->success('最新回收订单',$order_info);
    }
    /**s
     * @return void
     * 首页回收订单
     */
    public function recovery_order_info(){
        $user_id = $this->auth->id;
        $order_id  = input('order_id');
        $recovery_order_model = new Recoveryorder();
        $user_model = new \app\admin\model\User();
        $order_info = $recovery_order_model->where('c_user_id',$user_id)->where('id',$order_id)->find();
        $user_info = $user_model->where('id',$order_info['b_user_id'])->field('username,nickname,mobile')->find();
        $order_info['h_name']=$user_info['username'];
        $order_info['mobile']=$user_info['mobile'];
        $this->success('回收订单详情',$order_info);
    }
    /**
     * @return void
     * 我的厨余餐具订单
     */
    public function recovery_order_log(){
        $page = input('page',1);
        $mon = input('date',date('Y-m'));
        $user = $this->auth->id;
        $recovery_model = new Recoveryorder();
        $recovery_bill_model = new RecoveryBill();
        $date = getMonthRange($mon);
        $is_have = $recovery_bill_model->whereBetween('date',[strtotime($date['sdate']),strtotime($date['edate'])])->where('c_user_id',$user)->find();
        $list = $recovery_model->whereBetween('create_time',[strtotime($date['sdate']),strtotime($date['edate'])])->where('c_user_id',$user)->paginate('5','',['page'=>$page]);
        $sate = 1;
        $data['bill']=[];
        if($is_have){
            if($is_have['status']==1) {
                $sate = 2;
            }
            if($is_have['status']==2) {
                $sate = 3;
            }
            $data['bill']=$is_have;
        }
        $data['list']=$list;
        $data['sate']=$sate;
        $this->success('月份订单',$data);
    }

    /**
     * @return void
     * 取消订单
     */
    public function  dis_order(){
        $user_id = $this->auth->id;
        $order_id = input('order_id');
        $good_order_model = new Goodorder();
        $status = $good_order_model->where('id',$order_id)->where('user_id',$user_id)->find();
        if($status['status']==1){
            $good_order_model->where('id',$order_id)->where('user_id',$user_id)->delete();
            $this->success('订单已取消');
        }
        if($status['status']==2){
            //退款
            $config = [
                'app_id' => 'wxdc450b7c5d0a0f80',
                'mch_id' => '1635096198',
                'key' => 'e3NkU3L7vmz84H92kfKT5d9qBCOmvdEB',    // API v2 密钥 (注意: 是v2密钥 是v2密钥 是v2密钥)
                'cert_path'          => ROOT_PATH.'public/cert/apiclient_cert.pem', // XXX: 绝对路径！！！！
                'key_path'           => ROOT_PATH.'public/cert/apiclient_key.pem',      // XXX: 绝对路径！！！
                'notify_url' => common_url() . '/api/Notice/tableware_notify',     // 你也可以在下单时单独设置来想覆盖它
            ];

            $app = Factory::payment($config);
            $refund_no = 'TK' . pay_no(999);
            $result = $app->refund->byOutTradeNumber($status['pay_no'], $refund_no, $status['total'], $status['total'], [
                // 可在此处传入其他参数，详细参数见微信支付文档
                'refund_desc' => '退款',
            ]);

            if($result['return_code']=='FAIL'||$result['result_code']=='FAIL'){
                $this->error('退款出错请联系商家');
            }
            $good_order_model->save(['status' => 7], ['id' => $order_id, 'user_id' => $user_id]);
            $this->success('支付金额退回，注意查收');
        }
        if($status['status']==3) {
            $good_order_model->save(['status' => 5], ['id' => $order_id, 'user_id' => $user_id]);
            $this->success('订单已取消等待审核');

        }
    }

    /**
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * 商城订单评价
     */
    public function evaluate(){
        $order_model = new Goodorder();
        $evaluate_model = new Evaluate();
        $user_id = $this->auth->id;
        $order_id = input('order_id');
        $score = input('score',5);
        $images = input('images');
        $evaluate = input('evaluate');
        $order_info = $order_model->where('id',$order_id)->find();
        $data = [
            'user_id'=>$user_id,
            'order_id'=>$order_id,
            'good_id'=>$order_info['good_id'],
            'good_name'=>$order_info['good_name'],
            'order_no'=>$order_info['order_no'],
            'score'=>$score,
            'evaluatetext'=>$evaluate,
            'images'=>$images,
            'create_time'=>time()
        ];
        $evaluate_model->insert($data);
        $order_model->save(['status'=>6],['id'=>$order_id]);
        $this->success('感谢您的评价');

    }

    /**
     * @return void
     *商家注销订单
     */
    public function user_canel_order(){
        $user_id = $this->auth->id;
        $user_relations_model = new Cannelorder();
        $info = $user_relations_model->where('c_user_id',$user_id)->find();
        $this->success('注销回收订单',$info);
    }

    /**
     * @return void
     * 商城订单确认收收货
     */
    public function good_over(){
        $order_id = input('order_id');
        $good_order_model=new Goodorder();
        $good_order_model->save(['status'=>4,'delivery_status'=>4],['id'=>$order_id]);
        $this->success('确定收货快去评价吧');
    }

    /**
     * @return void
     * 餐具订单确定收货
     */
    public function tableware_over(){
        $order_id = input('order_id');
        $good_order_model=new TablewareOrder();
        $good_order_model->save(['status'=>4,'delivery_status'=>4],['id'=>$order_id]);
        $this->success('收到货了');

    }
    public function good_status_num(){
        $good_order_model=new Goodorder();
        $a = $good_order_model->where(array('user_id'=>$this->auth->id,'status'=>2))->count();

        $b = $good_order_model->where(array('user_id'=>$this->auth->id,'status'=>3))->count();

        $c = $good_order_model->where(array('user_id'=>$this->auth->id,'status'=>4))->count();

        $d = $good_order_model->where(array('user_id'=>$this->auth->id,'status'=>5))->count();
        $data =[$a,$b,$c,$d];
        $this->success('状态数量',$data);
    }




}