<?php
namespace app\controllers\channelApi;
use app\models\common\WeChatPay;
use Illuminate\Support\Facades\DB;
use Yii;
use app\models\common\Config;
use app\models\common\Store;
use app\models\common\Order;
use app\models\common\CallbackOrder;
use app\models\common\Message;
use app\models\common\Power;
use app\models\common\Member;
use app\models\common\Printing;
use app\models\common\Good;
use app\models\common\WeChat;
use app\models\common\Voice;
class InStoreController extends CommonController{
    //快餐下订单
    public function actionSaveFastOrder() {
        $request = Yii::$app->request;
        $result=axios_request();
        $item=3;
        if($request->isGet){
            return $this->result(2, '请求异常');
        }
        $now=time();
        $userId=$this->wqData['userId'];
        $uniacid=$this->wqData['uniacid'];
        $appType = $this->wqData['appType'];
        $user=(new \yii\db\Query())
            ->from('{{%ybwm_member}}')
            ->where('id=:id',[':id'=>$userId])->one();
        if ($user['isBlack'] == 1) {
            return $this->result(2, '账号异常,请联系管理员！！！');
        }
        $moneyData = Order::getCarMoney($userId, $result['storeId'],3);
        $originalMoney=$moneyData['originalMoney'];
        $data['vipDiscount']=bcsub($originalMoney,$moneyData['goodsMoney'],2);//会员优惠金额
        $data['originMoney'] = $moneyData['goodsMoney']; //商品金额
        $data['people'] = $result['people']; //人数
        $data['goodsNum'] = $moneyData['goodsNum']; //商品数量
        $data['outTradeNo'] = date("YmdHis") . rand(111111, 999999);
        $data['storeId'] = $result['storeId'];
        $data['userId'] = $userId;
        $data['state'] = 1;
        $data['origin'] = $appType;
        $data['isOut'] = $result['isOut']?:1;//1店内就餐2打包带走

        if($data['isOut']==1){
            $tablewareMoney=0;
        }else{
            $fastSet = Config::getStoreSet('fastSet', $result['storeId']);
            $boxType=$fastSet['boxType']?:2;
            if($boxType==1){
                //按单
                $tablewareMoney=$fastSet['boxMoney']?:0;
            }else{
                $tablewareMoney=$moneyData['boxMoney'];
            }
        }
        $data['newMoney']=Order::newReduction($this->wqData['userId'],$result['storeId'])?:0;//新客
        $data['tablewareMoney'] =$tablewareMoney; //餐具费
        $data['money'] = bcadd($data['originMoney'], $data['tablewareMoney'], 2);
        $reduce=Order::reduce($result['storeId'],$this->wqData['userId'],$data['originMoney'],3);//满减
        $data['preferentialMoney']=$reduce['money']?:0;
        $data['money']=bcsub($data['money'],$reduce['money'],2);//减去满减
        if($data['newMoney']>0){
            $data['money']=bcsub($data['money'],$data['newMoney'],2)?:0.01;
            //echo "减去新客之后的钱".$moneyArr['goodsMoney'];
        }

        $data['platformCouponPreferential']=0;
        $data['couponPreferential']=0;
        if($result['couponId']){
            $data['couponId']=json_encode($result['couponId']);
            if($result['couponId']['store']){
                $storeCoupon=(new \yii\db\Query())
                    ->select('type,money,discount,goodsType,goodsArr')
                    ->from('{{%ybwm_user_coupon}}')
                    ->where('id=:id AND state=2',[':id'=>$result['couponId']['store']])->one();
                if(!$storeCoupon){
                    return $this->result(2, '优惠券不存在或已使用');
                }

                if($storeCoupon['type']==1){
                    $data['couponPreferential']=$storeCoupon['money'];
                    $data['money']=bcsub($data['money'],$storeCoupon['money'],2)>0?bcsub($data['money'],$storeCoupon['money'],2):0.01;
                }else{
                    $data['couponPreferential']=Member::couponMoney($userId,$result['storeId'],$result['couponId']['store'],3);
                    $data['money']=bcsub($data['money'],$data['couponPreferential'],2)>0?bcsub($data['money'],$data['couponPreferential'],2):0.01;
                }
            }
            if($result['couponId']['platform']){
                $platformCoupon=(new \yii\db\Query())
                    ->select('type,money,discount,goodsType,goodsArr')
                    ->from('{{%ybwm_user_coupon}}')
                    ->where('id=:id AND state=2',[':id'=>$result['couponId']['platform']])->one();
                if(!$platformCoupon){
                    return $this->result(2, '优惠券不存在或已使用');
                }
                if($platformCoupon['subsidy']){
                    $data['subsidy']=$platformCoupon['subsidy'];//补贴
                }
                if($platformCoupon['type']==1){
                    $data['platformCouponPreferential']=$platformCoupon['money'];
                    $data['money']=bcsub($data['money'],$platformCoupon['money'],2)>0?bcsub($data['money'],$platformCoupon['money'],2):0.01;
                }else{
                    $data['platformCouponPreferential']=Member::couponMoney($userId,$result['storeId'],$result['couponId']['platform'],3);
                    $data['money']=bcsub($data['money'],$data['platformCouponPreferential'],2)>0?bcsub($data['money'],$data['platformCouponPreferential'],2):0.01;
                }
            }
        }
        $data['uniacid'] = $uniacid;
        //    $data['eatType'] = $result['eatType'] ?: 1;//1.餐前支付2餐后支付
        $data['createdAt'] = $now;
        $data['userNote'] = $result['userNote']; //备注
        $data['orderMode'] = 2;
        $transaction = Yii::$app->db->beginTransaction();   //开始事务
        $res =Yii::$app->db->createCommand()->insert('{{%ybwm_instore_order}}', $data)->execute();
        $orderId = Yii::$app->db->getLastInsertID();
        if ($res) {
            $arr = (new \yii\db\Query())
                ->from('{{%ybwm_shop_car}}')
                ->where('userId=:userId AND storeId=:storeId AND item=:item', [':item'=>$item,':userId' => $userId, ':storeId' => $result['storeId']])->all();
            for ($j = 0; $j < count($arr); $j++) {
                $orderGood = [];
                $discountOrderGood = [];
                $discountNum=$arr[$j]['discountNum'];//活动商品
                $originalNum=$arr[$j]['num']-$arr[$j]['discountNum'];//原价商品
                if($discountNum){
                    $discountOrderGood['goodsId'] = $arr[$j]['goodsId'];
                    $discountOrderGood['attribute'] = $arr[$j]['attribute']?:'';
                    $discountOrderGood['data'] = $arr[$j]['groupName']?:'';
                    $discountOrderGood['material'] = $arr[$j]['materialName']?:'';
                    $discountOrderGood['orderId'] = $orderId;
                    $discountOrderGood['name'] = $arr[$j]['name'];
                    $discountOrderGood['num'] = $discountNum;
                    $discountOrderGood['icon'] = $arr[$j]['icon'];
                    $discountOrderGood['storeId'] = $result['storeId'];
                    $discountOrderGood['uniacid'] = $uniacid;
                    $discountOrderGood['createdAt'] = $now;
                    $discountOrderGood['item'] = $item;
                    $discountOrderGood['isActivity'] = $arr[$j]['discountType']?:0;
                    $discountOrderGood['money'] = $arr[$j]['discountPrice'];
                    $discountOrderGoodsRes=Yii::$app->db->createCommand()->insert('{{%ybwm_order_goods}}', $discountOrderGood)->execute();
                    if(!$discountOrderGoodsRes){
                        $transaction->rollBack();//事务回滚
                        return $this->result(2, '下单失败','订单商品表插入失败');
                    }
                }
                if($originalNum){
                    $orderGood['goodsId'] = $arr[$j]['goodsId'];
                    $orderGood['attribute'] = $arr[$j]['attribute']?:'';
                    $orderGood['data'] = $arr[$j]['groupName']?:'';
                    $orderGood['material'] = $arr[$j]['materialName']?:'';
                    $orderGood['orderId'] = $orderId;
                    $orderGood['name'] = $arr[$j]['name'];
                    $orderGood['num'] = $originalNum;
                    $orderGood['icon'] = $arr[$j]['icon'];
                    $orderGood['storeId'] = $result['storeId'];
                    $orderGood['uniacid'] = $uniacid;
                    $orderGood['createdAt'] = $now;
                    $orderGood['item'] = $item;
                    $orderGood['money'] = $arr[$j]['money'];
                    $orderGoodsRes=Yii::$app->db->createCommand()->insert('{{%ybwm_order_goods}}', $orderGood)->execute();
                    if(!$orderGoodsRes){
                        $transaction->rollBack();//事务回滚
                        return $this->result(2, '下单失败','订单商品表插入失败');
                    }
                }
            }
            Yii::$app->db->createCommand()->delete('{{%ybwm_shop_car}}',['item'=>$item,'userId'=>$this->wqData['userId'],'storeId'=>$result['storeId']])->execute();
            if($result['couponId']){
                if($result['couponId']['store']){
                    $useCoupon = Yii::$app->db->createCommand()->update('{{%ybwm_user_coupon}}', ['state'=>1,'useTime'=>$now], 'id=:id', ['id' =>$result['couponId']['store']])->execute();
                    if(!$useCoupon){
                        $transaction->rollBack();//事务回滚
                        return $this->result(2, '下单失败','优惠券修改失败');
                    }
                }
                if($result['couponId']['platform']){
                    $platformUseCoupon = Yii::$app->db->createCommand()->update('{{%ybwm_user_coupon}}', ['state'=>1,'useTime'=>$now], 'id=:id', ['id' =>$result['couponId']['platform']])->execute();
                    if(!$platformUseCoupon){
                        $transaction->rollBack();//事务回滚
                        return $this->result(2, '下单失败','优惠券修改失败');
                    }
                }

            }
            WeChatPay::reporting($orderId,'CREATE_DEAL',3);
            $transaction->commit();
            return $this->result(1, '成功', $orderId);
        } else {
            return $this->result(2, '失败');
        }
    }

    //我的快餐订单
    public function actionMyFastOrder() {
        $result=axios_request();
        $page=$result['page']?:1;
        $size=$result['size']?:10;
        $state=$result['state'];
        $table=(new \yii\db\Query())
            ->select(['a.id','a.money','a.callNo','a.goodsNum','a.isOut','a.payMode','a.createdAt','a.state','a.userNote','s.name as storeName','s.icon as storeIcon','s.storeTel','a.storeId'])
            ->from('{{%ybwm_instore_order}} as a')
            ->join('LEFT JOIN', '{{%ybwm_store}} as s', 's.id = a.storeId')
            ->where('a.uniacid=:uniacid AND a.deleteAt=0 AND a.userDeleteAt=0 AND a.userId=:userId AND orderMode=2',[':uniacid'=>$this->wqData['uniacid'],':userId'=>$this->wqData['userId']]);
        if($state==1){
            $table->andWhere('a.state=3');
        }
        if($state==2){
            $table->andWhere('a.state=4');
        }
        $table->offset(($page - 1) * $size)->limit($size);
        $res=$table->orderby('id desc')->all();
        for($i=0;$i<count($res);$i++){
            $goods=(new \yii\db\Query())
                ->from('{{%ybwm_order_goods}}')
                ->where('orderId=:orderId AND item=3',[':orderId'=>$res[$i]['id']])->all();
            $res[$i]['goodsArr']=$goods;
            $res[$i]['isTk']=2;
            if($res[$i]['state']==2){
                $res[$i]['isTk']=1;
            }
        }
        return $this->result(1,'成功',$res);
    }
    //快餐订单详情
    public function actionFastOrderInfo() {
        $result=axios_request();
        $id=$result['id'];
        $res=(new \yii\db\Query())
            ->select(['a.vipDiscount','a.id','a.money','a.preferentialMoney','a.platformCouponPreferential','a.couponPreferential','a.outTradeNo','a.payMode','a.tablewareMoney','a.callNo','a.goodsNum','a.isOut','a.payMode','a.createdAt','a.state','a.userNote','s.name as storeName','s.icon as storeIcon','s.storeTel','s.address as storeAddress','s.lat as storeLat','s.lng as storeLng','a.storeId'])
            ->from('{{%ybwm_instore_order}} as a')
            ->join('LEFT JOIN', '{{%ybwm_store}} as s', 's.id = a.storeId')
            ->where('a.id=:id',[':id'=>$id])->one();
        $goods=(new \yii\db\Query())
            ->from('{{%ybwm_order_goods}}')
            ->where('orderId=:orderId AND item=3',[':orderId'=>$id])->all();
        $res['goodsArr']=$goods;
        return $this->result(1,'成功',$res);
    }
    //快餐取消订单//
    public function actionRefundFast() {
        $request = Yii::$app->request;
        $result=axios_request();
        if($request->isGet){
            return $this->result(2, '请求异常');
        }
        $res = Order::fastCancel($result['orderId']);
        if($res===true){
            return $this->result(1,'成功');
        }else{
            return $this->result(2,'失败',$res);
        }
    }
    //桌子详情
    public function actionTableInfo() {
        $result=axios_request();
        $tableId=$result['tableId'];
        $list=(new \yii\db\Query())
            ->select('a.id,a.manyType,a.userId,a.state,a.name,t.name as typeName,e.name as areaName,a.storeId')
            ->from('{{%ybwm_table}} as a')
            ->join('LEFT JOIN', '{{%ybwm_table_type}} as t', 't.id = a.typeId')
            ->join('LEFT JOIN', '{{%ybwm_table_area}} as e', 'e.id = a.areaId')
            ->where('a.id=:id',[':id'=>$tableId])->one();
        $system = Config::getSystemSet('instoreSet', $this->wqData['uniacid']);
        $storeSet = Config::getStoreSet('instoreSet', $list['storeId']);
        $waitTime = $system['closeTime'] ?: 15;
        $time = time() - 60 * $waitTime;
        $clearTime = $storeSet['closeTime'] ?: 3;
        $clearTime = time() - 60 * $clearTime;
        $res =Yii::$app->db->createCommand()->update('{{%ybwm_instore_order}}', ['state' =>4],'eatType=1 AND tableId=:tableId AND state=1 AND createdAt<:time AND orderMode=1', ['tableId'=>$tableId,'time'=>$time])->execute();

        if ($res AND $system['autoClose']==1) {
            Yii::$app->db->createCommand()->update('{{%ybwm_table}}', ['state' =>1,'userId'=>0],'id=:id', ['id'=>$tableId])->execute();
        }
        $clearOrder=(new \yii\db\Query())
            ->select('id,state,createdAt')
            ->from('{{%ybwm_instore_order}}')
            ->where('tableId=:tableId AND eatType=1',[':tableId'=>$tableId])->orderBy('id desc')->one();
        if($clearOrder['state']==2 AND $clearOrder['createdAt']<$clearTime AND $storeSet['autoClose']==1){
            Order::inStoreCheckOut($clearOrder['id']);
        }

        $systemDistance = $system['distance'] ?: 500;

//        $sql = "SELECT a.manyType,a.userId,a.state,a.number,a.storeId,b.name as typeName FROM " . tablename('ybo2o_table') . " a" . " left join " . tablename("ybo2o_table_type") . " b on b.id=a.typeId  where a.id=" . $_GPC['id'];
//        $list = pdo_fetch($sql);
        if (!$list) {
            $this->result(1, '餐桌信息有误');
        }
        $store =(new \yii\db\Query())
            ->from('{{%ybwm_store}}')
            ->where('id=:id',[':id'=>$list['storeId']])->one();
        if ($result['lat'] AND $system['distanceOpen'] == 1) {
            $distance = getDistance($result['lat'], $result['lng'], $store['lat'], $store['lng']);
            if ($distance * 100 > $systemDistance) {
                return $this->result(2, '距离商家太远,无法下单');
            }
        }
        $order =(new \yii\db\Query())
            ->from('{{%ybwm_instore_order}}')
            ->where('tableId=:tableId AND state in (1,2)',[':tableId'=>$tableId])->orderBy('id desc')->one();
        $instoreSet = Config::getStoreSet('instoreSet', $list['storeId']);
        if($instoreSet['orderMode']==2){
            $order=false;
        }
        if($order){
            $goods=(new \yii\db\Query())
                ->from('{{%ybwm_order_goods}}')
                ->where('orderId=:orderId AND item=2 AND addType=2',[':orderId'=>$order['id']])->all();
            $order['goodsArr']=$goods;
            $order['storeSet'] = Config::getStoreSet('instoreSet', $res['storeId']);
            $addGoodsArr=[];
            $addNum=(new \yii\db\Query())
                ->select('addNum')
                ->from('{{%ybwm_order_goods}}')
                ->where('orderId=:orderId AND addType=1 AND item=2',[':orderId'=>$order['id']])->orderBy('addNum desc')->one();
            if($addNum){
                for($i=1;$i<=$addNum['addNum'];$i++){
                    $addGoods=(new \yii\db\Query())
                        ->from('{{%ybwm_order_goods}}')
                        ->where('orderId=:orderId AND addNum=:addNum AND addType=1 AND item=2',[':orderId'=>$order['id'],':addNum'=>$i])->orderBy('id desc')->all();
                    $addGoodsArr[] = $addGoods;
                }
            }
            $order['addGoods'] = $addGoodsArr;
        }

        $list['orderInfo'] = $order;
        if (!$list['userId']) {
            Yii::$app->db->createCommand()->update('{{%ybwm_table}}', ['state' =>2,'userId'=>$this->wqData['userId']],'id=:id', ['id'=>$tableId])->execute();
        }
        return $this->result(1, '成功', $list);
    }
    //堂食下订单
    public function actionSaveInStoreOrder() {
        $request = Yii::$app->request;
        $result=axios_request();
        //test数据 start
        $result['tableId'] = 21;
        $result['storeId'] = 14;
        $result['people'] = 1;
        $result['userNote'] = '微辣！微辣！微辣！';
        $result['people'] = 1;
        $result['people'] = 1;
        //test数据 end


        $item=2;
//        if($request->isGet){
//            return $this->result(2, '请求异常');
//        }
        $tableTypeInfo=(new \yii\db\Query())
            ->from('{{%ybwm_table}} a')
            ->leftJoin('{{%ybwm_table_type}} b','a.typeId=b.id')
            ->where(['a.id'=>$result['tableId']])->one();
        if($result['people']>$tableTypeInfo['maxNum']){
            return $this->result(2, '超过桌台类型人数限制');
        }
        $tableTypeInfo=(new \yii\db\Query())
            ->from('{{%ybwm_table}} a')
            ->leftJoin('{{%ybwm_table_type}} b','a.typeId=b.id')
            ->where(['a.id'=>$result['tableId']])->one();
        if($result['people']>$tableTypeInfo['maxNum']){
            return $this->result(2, '超过桌台类型人数限制');
        }
        $now=time();
        $userId=$this->wqData['userId'];
        $uniacid=$this->wqData['uniacid'];
        $appType=$this->wqData['appType'];
        $user=(new \yii\db\Query())
            ->from('{{%ybwm_member}}')
            ->where('id=:id',[':id'=>$userId])->one();
        if ($user['isBlack'] == 1) {
            return $this->result(2, '账号异常,请联系管理员！！！');
        }
        $storeSet = Config::getStoreSet('instoreSet', $result['storeId']);
        $moneyData = Order::getCarMoney($userId, $result['storeId'],2,$result['tableId']);
        $originalMoney=$moneyData['originalMoney'];
        $data['vipDiscount']=bcsub($originalMoney,$moneyData['goodsMoney'],2);//会员优惠金额
        $data['originMoney'] = $moneyData['goodsMoney']; //商品金额
        $data['people'] = $result['people']; //人数
        $data['goodsNum'] = $moneyData['goodsNum']; //商品数量
        $data['outTradeNo'] = date("YmdHis") . rand(111111, 999999);
        $data['storeId'] = $result['storeId'];
        $data['userId'] = $userId;
        $data['state'] = 1;
        $data['origin'] = $appType;
        if($storeSet['payMode']==2 AND $storeSet['receiving']==1){
            $data['state'] = 2;
            $data['receiptAt']=time();
        }
        if($storeSet['serviceType']==2){//按桌台收取
            $data['tablewareMoney'] = $storeSet['serviceMoney']; //桌台费
            $data['tablewareNum']=1;
        }else{
            //按人数收取
            $data['tablewareNum']=$result['people'];
            $data['tablewareMoney'] = bcmul($storeSet['serviceMoney'], $result['people'], 2); //桌台费
        }
        $data['money'] = bcadd($data['originMoney'], $data['tablewareMoney'], 2);
        $reduce=Order::reduce($result['storeId'],$this->wqData['userId'],$data['originMoney'],2);//满减
        $data['preferentialMoney']=$reduce['money']?:0;
        $data['money']=0.01;//bcsub($data['money'],$reduce['money'],2);//减去满减
        $data['platformCouponPreferential']=0;
        $data['couponPreferential']=0;
        if($result['couponId']){
            $data['couponId']=json_encode($result['couponId']);
            if($result['couponId']['store']){
                $storeCoupon=(new \yii\db\Query())
                    ->select('type,money,discount,goodsType,goodsArr')
                    ->from('{{%ybwm_user_coupon}}')
                    ->where('id=:id AND state=2',[':id'=>$result['couponId']['store']])->one();
                if(!$storeCoupon){
                    return $this->result(2, '优惠券不存在或已使用');
                }

                if($storeCoupon['type']==1){
                    $data['couponPreferential']=$storeCoupon['money'];
                    $data['money']=bcsub($data['money'],$storeCoupon['money'],2)>0?bcsub($data['money'],$storeCoupon['money'],2):0.01;
                }else{
                    $data['couponPreferential']=Member::couponMoney($userId,$result['storeId'],$result['couponId']['store'],2,$result['tableId']);
                    $data['money']=bcsub($data['money'],$data['couponPreferential'],2)>0?bcsub($data['money'],$data['couponPreferential'],2):0.01;
                }
            }

            if($result['couponId']['platform']){
                $platformCoupon=(new \yii\db\Query())
                    ->select('type,money,discount,goodsType,goodsArr')
                    ->from('{{%ybwm_user_coupon}}')
                    ->where('id=:id AND state=2',[':id'=>$result['couponId']['platform']])->one();
                if(!$platformCoupon){
                    return $this->result(2, '优惠券不存在或已使用');
                }
                if($platformCoupon['subsidy']){
                    $data['subsidy']=$platformCoupon['subsidy'];//补贴
                }
                if($platformCoupon['type']==1){
                    $data['platformCouponPreferential']=$platformCoupon['money'];
                    $data['money']=bcsub($data['money'],$platformCoupon['money'],2)>0?bcsub($data['money'],$platformCoupon['money'],2):0.01;
                }else{
                    $data['platformCouponPreferential']=Member::couponMoney($userId,$result['storeId'],$result['couponId']['platform'],2,$result['tableId']);
                    $data['money']=bcsub($data['money'],$data['platformCouponPreferential'],2)>0?bcsub($data['money'],$data['platformCouponPreferential'],2):0.01;
                }
            }
        }


        $tableInfo=(new \yii\db\Query())
            ->select('a.name,t.name as typeName,e.name as areaName,t.minNum,t.maxNum')
            ->from('{{%ybwm_table}} as a')
            ->join('LEFT JOIN', '{{%ybwm_table_type}} as t', 't.id = a.typeId')
            ->join('LEFT JOIN', '{{%ybwm_table_area}} as e', 'e.id = a.areaId')
            ->where('a.id=:id',[':id'=>$result['tableId']])->one();
        $data['uniacid'] = $uniacid;
        $data['eatType'] = $result['eatType'] ?: 1;
        $data['createdAt'] = time();
        $data['regionName'] = $tableInfo['areaName']; //桌子区域类型
        $data['typeName'] = $tableInfo['typeName'] . "(" . $tableInfo['minNum'] . "-" . $tableInfo['maxNum'] . ")"; //桌子分类名称
        $data['number'] = $tableInfo['name']; //餐桌编号
        $data['userNote'] = $result['userNote']; //备注
        $data['tableId'] = $result['tableId']; //桌子id
        $transaction = Yii::$app->db->beginTransaction();   //开始事务
        $res =Yii::$app->db->createCommand()->insert('{{%ybwm_instore_order}}', $data)->execute();
        $orderId = Yii::$app->db->getLastInsertID();
        if ($res) {
            if($storeSet['orderMode']==2){
                $arr = (new \yii\db\Query())
                    ->from('{{%ybwm_shop_car}}')
                    ->where('userId=:userId AND tableId=:tableId AND storeId=:storeId AND item=:item', [':userId'=>$userId,':item'=>$item,':tableId' => $result['tableId'], ':storeId' => $result['storeId']])->all();
            }else{
                $arr = (new \yii\db\Query())
                    ->from('{{%ybwm_shop_car}}')
                    ->where('tableId=:tableId AND storeId=:storeId AND item=:item', [':item'=>$item,':tableId' => $result['tableId'], ':storeId' => $result['storeId']])->all();
            }
//            if(!$arr){
//                $transaction->rollBack();//事务回滚
//                return $this->result(2, '下单失败','购物车商品异常');
//            }
            $arr = [
                [
                    'discountNum' => 1,
                    'num' => 20,
                    'goodsId' => 115,
                    'groupId' => 0,
                    'money' => 0.01,
                    'groupName' => '家常炒菜1',
                    'attribute' => '',
                    'materialName' => '',
                    'name' => '家常炒菜',
                    'icon' => 'http://s883i38834.vicp.fun/web/static/yb_wm/8/2024/03/15/202403151651341480.png',
                    'discountType' => 0.00,
                    'discountPrice' => 0.00,
                ],
            ];


            for ($j = 0; $j < count($arr); $j++) {
                $orderGood = [];
                $discountOrderGood = [];
                $discountNum=$arr[$j]['discountNum'];//活动商品数量
                $originalNum=$arr[$j]['num']-$arr[$j]['discountNum'];//原价商品数量
                if($discountNum){
                    $discountOrderGood['goodsId'] = $arr[$j]['goodsId'];
                    $discountOrderGood['attribute'] = $arr[$j]['attribute']?:'';
                    $discountOrderGood['data'] = $arr[$j]['groupName']?:'';
                    $discountOrderGood['material'] = $arr[$j]['materialName']?:'';
                    $discountOrderGood['orderId'] = $orderId;
                    $discountOrderGood['name'] = $arr[$j]['name'];
                    $discountOrderGood['num'] = $discountNum;
                    $discountOrderGood['icon'] = $arr[$j]['icon'];
                    $discountOrderGood['storeId'] = $result['storeId'];
                    $discountOrderGood['uniacid'] = $uniacid;
                    $discountOrderGood['createdAt'] = $now;
                    $discountOrderGood['item'] = $item;
                    $discountOrderGood['isActivity'] = $arr[$j]['discountType']?:0;
                    $discountOrderGood['money'] = $arr[$j]['discountPrice'];
                    $discountOrderGoodsRes=Yii::$app->db->createCommand()->insert('{{%ybwm_order_goods}}', $discountOrderGood)->execute();
                    if(!$discountOrderGoodsRes){
                        $transaction->rollBack();//事务回滚
                        return $this->result(2, '下单失败','订单商品表插入失败');
                    }
                    $comboGoodsArr=(new \yii\db\Query())->from('{{%ybwm_core_goods}}')->select('comboGoodsArr')->where(['id'=>$arr[$j]['goodsId']])->one();
                    if($comboGoodsArr = json_decode($comboGoodsArr['comboGoodsArr'],true)){
                        foreach ($comboGoodsArr as $v){
                            $discountOrderGoodOne['groupId'] = 0;
                            $discountOrderGoodOne['goodsId'] = $v['id'];
                            $discountOrderGoodOne['attribute'] = '';
                            $discountOrderGoodOne['data'] = '';
                            $discountOrderGoodOne['material'] = '';
                            $discountOrderGoodOne['orderId'] = $orderId;
                            $discountOrderGoodOne['name'] = $v['name'];
                            $discountOrderGoodOne['num'] = $v['num'];
                            $discountOrderGoodOne['icon'] = $v['icon'];
                            $discountOrderGoodOne['storeId'] = $v['storeId'];
                            $discountOrderGoodOne['uniacid'] = $uniacid;
                            $discountOrderGoodOne['createdAt'] = $now;
                            $discountOrderGoodOne['item'] = $item;
                            $discountOrderGoodOne['isActivity'] = 0;
                            $discountOrderGoodOne['money'] = 0;
                            $discountOrderGoodsResOne=Yii::$app->db->createCommand()->insert('{{%ybwm_order_goods}}', $discountOrderGoodOne)->execute();
                            if(!$discountOrderGoodsResOne){
                                $transaction->rollBack();//事务回滚
                                return $this->result(2, '下单失败','订单商品表插入失败');
                            }
                        }
                    }
                }
                if($originalNum){
                    $orderGood['goodsId'] = $arr[$j]['goodsId'];
                    $orderGood['attribute'] = $arr[$j]['attribute']?:'';
                    $orderGood['data'] = $arr[$j]['groupName']?:'';
                    $orderGood['material'] = $arr[$j]['materialName']?:'';
                    $orderGood['orderId'] = $orderId;
                    $orderGood['name'] = $arr[$j]['name'];
                    $orderGood['num'] = $originalNum;
                    $orderGood['icon'] = $arr[$j]['icon'];
                    $orderGood['storeId'] = $result['storeId'];
                    $orderGood['uniacid'] = $uniacid;
                    $orderGood['createdAt'] = $now;
                    $orderGood['item'] = $item;
                    $orderGood['money'] = $arr[$j]['money'];
                    $orderGoodsRes=Yii::$app->db->createCommand()->insert('{{%ybwm_order_goods}}', $orderGood)->execute();
                    if(!$orderGoodsRes){
                        $transaction->rollBack();//事务回滚
                        return $this->result(2, '下单失败','订单商品表插入失败');
                    }
                    $comboGoodsArr=(new \yii\db\Query())->from('{{%ybwm_core_goods}}')->select('comboGoodsArr')->where(['id'=>$arr[$j]['goodsId']])->one();
                    if($comboGoodsArr = json_decode($comboGoodsArr['comboGoodsArr'],true)){
                        foreach ($comboGoodsArr as $v){
                            $discountOrderGoodOne['groupId'] = 0;
                            $discountOrderGoodOne['goodsId'] = $v['id'];
                            $discountOrderGoodOne['attribute'] = '';
                            $discountOrderGoodOne['data'] = '';
                            $discountOrderGoodOne['material'] = '';
                            $discountOrderGoodOne['orderId'] = $orderId;
                            $discountOrderGoodOne['name'] = $v['name'];
                            $discountOrderGoodOne['num'] = $v['num'];
                            $discountOrderGoodOne['icon'] = $v['icon'];
                            $discountOrderGoodOne['storeId'] = $v['storeId'];
                            $discountOrderGoodOne['uniacid'] = $uniacid;
                            $discountOrderGoodOne['createdAt'] = $now;
                            $discountOrderGoodOne['item'] = $item;
                            $discountOrderGoodOne['isActivity'] = 0;
                            $discountOrderGoodOne['money'] = 0;
                            $discountOrderGoodsResOne=Yii::$app->db->createCommand()->insert('{{%ybwm_order_goods}}', $discountOrderGoodOne)->execute();
                            if(!$discountOrderGoodsResOne){
                                $transaction->rollBack();//事务回滚
                                return $this->result(2, '下单失败','订单商品表插入失败');
                            }
                        }
                    }
                }
            }
            if($storeSet['orderMode']==2){
                Yii::$app->db->createCommand()->delete('{{%ybwm_shop_car}}',['item'=>$item,'tableId'=>$result['tableId'],'userId'=>$this->wqData['userId'],'storeId'=>$result['storeId']])->execute();
            }else{
                Yii::$app->db->createCommand()->delete('{{%ybwm_shop_car}}',['item'=>$item,'tableId'=>$result['tableId'],'storeId'=>$result['storeId']])->execute();
            }
            if($data['eatType'] == 2){
                Order::reduceStock($orderId,1,2);
                Order::instoreVoice($orderId, 'inNewOrder');
                Message::newInStoreOrder($orderId);
            }
            if ($data['eatType'] == 2 AND $data['state']==2) {
                Printing::orderPrint($orderId,2);
                Message::inStoreOrder($orderId);
                Yii::$app->db->createCommand()->update('{{%ybwm_table}}',['state'=>3],['id'=>$result['tableId']])->execute();
            }

            if($result['couponId']){
                if($result['couponId']['store']){
                    $useCoupon = Yii::$app->db->createCommand()->update('{{%ybwm_user_coupon}}', ['state'=>1,'useTime'=>$now], 'id=:id', ['id' =>$result['couponId']['store']])->execute();
                    if(!$useCoupon){
                        $transaction->rollBack();//事务回滚
                        return $this->result(2, '下单失败','优惠券修改失败');
                    }
                }
                if($result['couponId']['platform']){
                    $platformUseCoupon = Yii::$app->db->createCommand()->update('{{%ybwm_user_coupon}}', ['state'=>1,'useTime'=>$now], 'id=:id', ['id' =>$result['couponId']['platform']])->execute();
                    if(!$platformUseCoupon){
                        $transaction->rollBack();//事务回滚
                        return $this->result(2, '下单失败','优惠券修改失败');
                    }
                }
            }
            WeChatPay::reporting($orderId,'CREATE_DEAL',3);
            $transaction->commit();
            return $this->result(1, '成功', $orderId);
        } else {
            return $this->result(2, '失败');
        }
    }

    //我的店内订单
    public function actionMyInStoreOrder() {
        $result=axios_request();
        $page=$result['page']?:1;
        $size=$result['size']?:10;
        $state=$result['state'];
        $table=(new \yii\db\Query())
            ->select(['a.id','a.eatType','a.money','a.people','a.typeName','a.number','a.callNo','a.goodsNum','a.isOut','a.payMode','a.createdAt','a.state','a.userNote','s.name as storeName','s.icon as storeIcon','s.storeTel','a.storeId'])
            ->from('{{%ybwm_instore_order}} as a')
            ->join('LEFT JOIN', '{{%ybwm_store}} as s', 's.id = a.storeId')
            ->where('a.uniacid=:uniacid AND a.deleteAt=0 AND a.userDeleteAt=0 AND a.userId=:userId AND a.orderMode=1',[':uniacid'=>$this->wqData['uniacid'],':userId'=>$this->wqData['userId']]);
        if($state==1){
            $table->andWhere('a.state=1');
        }
        if($state==2){
            $table->andWhere('a.state=3');
        }
        if($state==3){
            $table->andWhere('a.state=4');
        }
        $table->offset(($page - 1) * $size)->limit($size);
        $res=$table->orderby('id desc')->all();
        for($i=0;$i<count($res);$i++){
            $goods=(new \yii\db\Query())
                ->from('{{%ybwm_order_goods}}')
                ->where('orderId=:orderId AND item=2',[':orderId'=>$res[$i]['id']])->all();
            $res[$i]['goodsArr']=$goods;
            $res[$i]['isTk']=2;
            if($res[$i]['state']==2){
                $res[$i]['isTk']=1;
            }
        }
        return $this->result(1,'成功',$res);
    }
    //订单详情
    public function actionInStoreOrderInfo() {
        $result=axios_request();
        $id=$result['id'];
        $res=(new \yii\db\Query())
            ->select(['a.vipDiscount','a.id','a.preferentialMoney','a.platformCouponPreferential','a.couponPreferential','a.money','a.eatType','a.tableId','a.typeName','a.number','a.people','a.outTradeNo','a.payMode','a.tablewareMoney','a.callNo','a.goodsNum','a.isOut','a.payMode','a.createdAt','a.state','a.userNote','s.name as storeName','s.icon as storeIcon','s.storeTel','a.storeId'])
            ->from('{{%ybwm_instore_order}} as a')
            ->join('LEFT JOIN', '{{%ybwm_store}} as s', 's.id = a.storeId')
            ->where('a.id=:id',[':id'=>$id])->one();
        $goods=(new \yii\db\Query())
            ->from('{{%ybwm_order_goods}}')
            ->where('orderId=:orderId AND item=2 AND addType=2',[':orderId'=>$id])->all();
        $res['goodsArr']=$goods;
        $res['storeSet'] = Config::getStoreSet('instoreSet', $res['storeId']);
        $addGoodsArr=[];
        $addNum=(new \yii\db\Query())
            ->select('addNum')
            ->from('{{%ybwm_order_goods}}')
            ->where('orderId=:orderId AND addType=1 AND item=2',[':orderId'=>$id])->orderBy('addNum desc')->one();
        if($addNum){
            for($i=1;$i<=$addNum['addNum'];$i++){
                $addGoods=(new \yii\db\Query())
                    ->from('{{%ybwm_order_goods}}')
                    ->where('orderId=:orderId AND addNum=:addNum AND addType=1 AND item=2',[':orderId'=>$id,':addNum'=>$i])->orderBy('id desc')->all();
                $addGoodsArr[] = $addGoods;
            }
        }
        $res['addGoods'] = $addGoodsArr;
        $system = Config::getStoreSet('instoreSet',$res['storeId']);
        $res['onLine']=$system['onLine'];
        return $this->result(1,'成功',$res);
    }
    //获取活码详细
    public function actionGetCodeInfo() {
        $result=axios_request();
        $data=$result['data'];
        if($data['type']=='fastOrder'){
            //快餐
            return $this->result(1,'成功',['type'=>$data['type'],'storeId'=>$data['id']]);
        }
        if($data['type']=='cashier'){
            //收银
            return $this->result(1,'成功',['type'=>$data['type'],'storeId'=>$data['id']]);
        }
        if($data['type']=='goods'){
            //点餐页
            return $this->result(1,'成功',['type'=>$data['type'],'storeId'=>$data['id']]);
        }
        //桌子
        $code=(new \yii\db\Query())
            ->select('data')
            ->from('{{%ybwm_code}}')
            ->where('id=:id',[':id'=>$data['id']])->one();
        if(!$code['data']){
            return $this->result(2,'该码未绑定参数');
        }
        return $this->result(1,'成功',json_decode($code['data'],true));
    }
    //判断购物车必选品
    public function actionShopCarRequire() {
        $result=axios_request();
        $item=$result['item'];
        if($item==1){
            $goodsType=1;
        }else{
            $goodsType=2;
        }
        $tableId=$result['tableId']?:0;
        $userId=$this->wqData['userId'];
        $typeId=Good::getGoodSData($this->wqData['uniacid'],$result['storeId'],$this->wqData['userId'],$goodsType,1);
        $requireId=array_column($typeId,'id');
        $storeModeSet = Config::getStoreSet($result['storeId'], $this->wqData['uniacid']);
        $multiplayerMode = $storeModeSet['orderMode'];

        for($i=0;$i<count($requireId);$i++){
            if($multiplayerMode==2){
                $res=(new \yii\db\Query())
                    ->from('{{%ybwm_shop_car}} as a')
                    ->join('LEFT JOIN', '{{%ybwm_core_goods}} as s', 's.id = a.goodsId')
                    ->where(['a.tableId'=>$tableId,'a.item'=>$item,'s.typePid'=>$requireId[$i],'a.userId' => $userId,'a.storeId' => $result['storeId']])
                    ->one();
            }else{
                $res=(new \yii\db\Query())
                    ->from('{{%ybwm_shop_car}} as a')
                    ->join('LEFT JOIN', '{{%ybwm_core_goods}} as s', 's.id = a.goodsId')
                    ->where(['a.tableId'=>$tableId,'a.item'=>$item,'s.typePid'=>$requireId[$i],'a.storeId' => $result['storeId']])
                    ->one();
            }

            if(!$res){
                return $this->result(2,'请添加必选品');
            }
        }
        return $this->result(1,'成功');

    }
    //我的购物车
    public function actionMyInStoreCar() {
        $result=axios_request();
        $tableId=$result['tableId']?:0;
        $uniacid=$this->wqData['uniacid'];
        $userId=$this->wqData['userId'];
        $time = time() - 60 * 60 * 2;
        Yii::$app->db->createCommand()->delete('{{%ybwm_shop_car}}', 'tableId=:tableId AND storeId=:storeId AND item=2 AND createdAt<:createdAt',[':tableId' => $tableId, ':storeId' => $result['storeId'], ':createdAt' => $time])->execute();
        $storeModeSet = Config::getStoreSet($result['storeId'], $uniacid);
        $multiplayerMode = $storeModeSet['orderMode'];
        if ($multiplayerMode == 2) {
            //拼桌模式
            $userList=(new \yii\db\Query())
                ->select('userId')
                ->from('{{%ybwm_shop_car}}')
                ->where(['tableId' => $tableId,'userId'=>$userId, 'storeId' => $result['storeId'], 'item' =>2])
                ->groupBy('userId')
                ->all();
        } else {
            $userList=(new \yii\db\Query())
                ->select('userId')
                ->from('{{%ybwm_shop_car}}')
                ->where(['tableId' => $tableId,'storeId' => $result['storeId'], 'item' =>2])
                ->groupBy('userId')
                ->all();
        }
        $table=(new \yii\db\Query())
            ->select('a.name,t.name as typeName,a.userId,a.state,a.storeId')
            ->from('{{%ybwm_table}} as a')
            ->join('LEFT JOIN', '{{%ybwm_table_type}} as t', 't.id = a.typeId')
            ->where(['a.id'=>$tableId])
            ->one();
        if ($table['userId'] == 0) {
            Yii::$app->db->createCommand()->delete('{{%ybwm_table}}', ['state' => 2, 'userId' => $userId],['id' => $tableId])->execute();
        }
        $data['table'] = $table;
        $data['money'] = 0;

        for ($u = 0; $u < count($userList); $u++) {
            $data2 = [];
            $user=(new \yii\db\Query())
                ->select('userName,portrait')
                ->from('{{%ybwm_member}}')
                ->where(['id'=>$userList[$u]['userId']])
                ->one();
            $data2['userName'] = $user['userName'];
            $data2['portrait'] = $user['portrait'];
            $list =(new \yii\db\Query())
                ->from('{{%ybwm_shop_car}}')
                ->where(['userId' => $userList[$u]['userId'], 'tableId' => $tableId, 'storeId' => $result['storeId'], 'item' => 2])
                ->all();
            for ($i = 0; $i < count($list); $i++) {
                $data['money'] = (float) bcadd(bcmul($list[$i]['money'], $list[$i]['num'], 2), $data['money'], 2);
//                $goodsArr['name'] = $list[$i]['name'];
//                $goodsArr['goodsId'] = $list[$i]['goodsId'];
//                $goodsArr['groupId'] = $list[$i]['groupId'];
//                $goodsArr['num'] = $list[$i]['num'];
//                $goodsArr['price'] = $list[$i]['money'];
//                $goodsArr['icon'] = $list[$i]['icon'];
//                $goodsArr['groupName'] = $list[$i]['groupName'];
//                $goodsArr['material'] = $list[$i]['material'];
//                $goodsArr['attribute'] = $list[$i]['attribute'];
//                $goodsArr['isSpec'] = $list[$i]['goodsId'] ? 1 : 2;
//                $goodsArr['id'] = $list[$i]['id'];
                $data2['goodsArr'][] = $list[$i];
            }
            $data['userInfo'][] = $data2;
        }
        return $this->result(1,'成功',$data);
    }

    //关闭堂食订单
    public function actionCloseInOrder() {
        $result=axios_request();
        $order = (new \yii\db\Query())
            ->from('{{%ybwm_instore_order}}')
            ->where(['id' => $result['orderId']])
            ->one();
        if ($order['state'] != 1) {
            return $this->result(2, '订单状态异常');
        }
        $res =Order::inStoreClose($result['orderId']);
        //$res =Yii::$app->db->createCommand()->update('{{%ybwm_instore_order}}',['state'=>4], ['id' => $result['orderId']])->execute();
        if ($res) {
            return $this->result(1, '成功');
        } else {
            return $this->result(2, '失败');
        }
    }
    //加菜
    public function actionAddFood(){
        $request = Yii::$app->request;
        $result=axios_request();
        $userId=$this->wqData['userId'];
        $uniacid=$this->wqData['uniacid'];
        $now=time();
        if($request->isGet){
            return $this->result(2, '请求异常');
        }
        $order =(new \yii\db\Query())
            ->from('{{%ybwm_instore_order}}')
            ->where(['id' => $result['orderId']])
            ->one();
        $orderGoods =(new \yii\db\Query())
            ->select('addNum')
            ->from('{{%ybwm_order_goods}}')
            ->where(['orderId' => $result['orderId'],'addType'=>1,'item'=>2])
            ->orderBy('addNum desc')
            ->one();
        $addNum=$orderGoods['addNum']?:0;
        if($order['state'] > 2) {
            return $this->result(2, '订单状态异常');
        }
        if($order['eatType'] == 1) {
            return $this->result(2, '餐前支付不允许加菜');
        }
        $moneyData = Order::getCarMoney($userId, $order['storeId'],2,$order['tableId']);
        $arr = (new \yii\db\Query())
            ->from('{{%ybwm_shop_car}}')
            ->where('tableId=:tableId AND userId=:userId AND storeId=:storeId AND item=:item', [':tableId'=>$order['tableId'],':item'=>2,':userId' => $userId, ':storeId' => $order['storeId']])->all();
        // var_dump($arr);die;
        $goodsIdArr = [];
        for ($j = 0; $j < count($arr); $j++) {
            $orderGood = [];
            $orderGood['goodsId'] = $arr[$j]['goodsId'];
            $orderGood['attribute'] = $arr[$j]['attribute']?:'';
            $orderGood['data'] = $arr[$j]['groupName']?:'';
            $orderGood['material'] = $arr[$j]['materialName']?:'';
            $orderGood['orderId'] = $result['orderId'];
            $orderGood['name'] = $arr[$j]['name'];
            $orderGood['num'] = $arr[$j]['num'];
            $orderGood['icon'] = $arr[$j]['icon'];
            $orderGood['storeId'] = $order['storeId'];
            $orderGood['uniacid'] = $uniacid;
            $orderGood['item'] = 2;
            $orderGood['createdAt'] = $now;
            $orderGood['money'] = $arr[$j]['money'];
            $orderGood['addType'] = 1;
            $orderGood['addNum'] = $addNum+1;
            Yii::$app->db->createCommand()->insert('{{%ybwm_order_goods}}', $orderGood)->execute();
            $goodsIdArr[]= Yii::$app->db->getLastInsertID();
            $comboGoodsArr=(new \yii\db\Query())->from('{{%ybwm_core_goods}}')->select('comboGoodsArr')->where(['id'=>$arr[$j]['goodsId']])->one();
            if($comboGoodsArr = json_decode($comboGoodsArr['comboGoodsArr'],true)){
                foreach ($comboGoodsArr as $v){
                    $discountOrderGoodOne['groupId'] = 0;
                    $discountOrderGoodOne['goodsId'] = $v['id'];
                    $discountOrderGoodOne['attribute'] = '';
                    $discountOrderGoodOne['data'] = '';
                    $discountOrderGoodOne['material'] = '';
                    $discountOrderGoodOne['orderId'] = $result['orderId'];
                    $discountOrderGoodOne['name'] = $v['name'];
                    $discountOrderGoodOne['num'] = $v['num'];
                    $discountOrderGoodOne['icon'] = $v['icon'];
                    $discountOrderGoodOne['storeId'] = $v['storeId'];
                    $discountOrderGoodOne['uniacid'] = $uniacid;
                    $discountOrderGoodOne['createdAt'] = $now;
                    $discountOrderGoodOne['item'] = 2;
                    $discountOrderGoodOne['isActivity'] = 0;
                    $discountOrderGoodOne['money'] = 0;
                    $discountOrderGoodsResOne=Yii::$app->db->createCommand()->insert('{{%ybwm_order_goods}}', $discountOrderGoodOne)->execute();
                    if(!$discountOrderGoodsResOne){
                        return $this->result(2, '下单失败','订单商品表插入失败');
                    }
                    $goodsIdArr[]= Yii::$app->db->getLastInsertID();
                }
            }
        }
        Printing::instoreOrderPrint($order['id'],$support=2,$goodsIdArr);
        $storeSet = Config::getStoreSet('instoreSet', $order['storeId']);
        if($storeSet['orderMode']==2){
            Yii::$app->db->createCommand()->delete('{{%ybwm_shop_car}}',['item'=>2,'tableId'=>$order['tableId'],'userId'=>$this->wqData['userId'],'storeId'=>$order['storeId']])->execute();
        }else{
            Yii::$app->db->createCommand()->delete('{{%ybwm_shop_car}}',['item'=>2,'tableId'=>$order['tableId'],'storeId'=>$order['storeId']])->execute();
        }
        Yii::$app->db->createCommand()->update('{{%ybwm_instore_order}}',['money'=>new \yii\db\Expression('money +'.$moneyData['goodsMoney']),'originMoney'=>new \yii\db\Expression('originMoney +'.$moneyData['goodsMoney']),'goodsNum'=>new \yii\db\Expression('goodsNum +'.$moneyData['goodsNum'])],['id'=>$result['orderId']])->execute();
        //   pdo_update('ybo2o_instore_order', array('money +=' => $moneyData['goodsMoney'], 'goodsNum +=' => $moneyData['goodsNum']), array('id' => $result['orderId']));
        return $this->result(1, '成功', $result['orderId']);
    }


}