<?php
namespace app\controllers\channelApi;
use Illuminate\Support\Facades\DB;
use Yii;
use app\models\common\Config;
use app\models\common\Power;
class PayVipController extends CommonController{
    public $enableCsrfValidation = false;
    function init(){
        parent::init();
        $power=Power::getPayPower($this->wqData['uniacid'],'payVip');
        if(!$power){
            echo json_encode(['code'=>2,'msg'=>'暂无权限']);die;
        }
    }
    //会员下订单
    public function actionVipOrder()
    {
        $request = Yii::$app->request;
        $result=axios_request();
        $userId=$this->wqData['userId'];
        $uniacid=$this->wqData['uniacid'];
        if($request->isGet){
            return $this->result(2,'请求异常');
        }
        $first=(new \yii\db\Query())
            ->from('{{%ybwm_user_vip_order}}')
            ->where('userId=:userId AND state=2',[':userId'=>$userId])->one();
        if($first){
            $data['first'] = 2;
        }else{
            $data['first'] = 1;
        }
        $set=Config::getSystemSet('payVip',$uniacid);
        $dayArr=$set['dayArr'];
        for($i=0;$i<count($dayArr);$i++){
            if($dayArr[$i]['day']==$result['day']){
                if($data['first']==1 AND $dayArr[$i]['first']==1){
                    $money=$dayArr[$i]['firstMoney'];
                }else{
                    $money=$dayArr[$i]['money'];
                }
                continue;
            }
        }
        if(!isset($money)){
            return $this->result(2, '参数有误');
        }

        $data['userId'] = $userId;
        $data['money'] = $money;
        $data['day'] = $result['day'];
        $data['outTradeNo'] = date("YmdHis") . rand(111111, 999999);
        $data['state'] = 1;
        $data['createdAt'] = time();
        $data['uniacid'] = $uniacid;

        $order = Yii::$app->db->createCommand()->insert('{{%ybwm_user_vip_order}}', $data)->execute();
        $orderId = Yii::$app->db->getLastInsertID();
        if ($order) {
            return $this->result(1, '成功', $orderId);
        } else {
            return $this->result(2, '失败');
        }
    }
    //购买记录
    public function actionMyOrder(){
        $userId=$this->wqData['userId'];
        $result=axios_request();
        $page=$result['page']?:1;
        $size=$result['size']?:10;
        $table=(new \yii\db\Query())
            ->select('day,money,outTradeNo')
            ->from('{{%ybwm_user_vip_order}}')
            ->where('userId=:userId AND state=2',[':userId'=>$userId]);
        $table->offset(($page - 1) * $size)->limit($size);
        $res=$table->orderby('id desc')->all();
        for($i=0;$i<count($res);$i++){
            $res[$i]['payModeName']=$this->payMode[$res[$i]['payMode']];
        }
        return $this->result(1, '成功', $res);
    }
    //权益列表
    public function actionRightsList(){
        $table=(new \yii\db\Query())
            ->select('id,name,icon')
            ->from('{{%ybwm_core_category}}')
            ->where(['deleteAt'=>0,'display'=>1,'uniacid'=>$this->wqData['uniacid'],'item'=>11]);
        $list=$table
            ->orderBy('sort asc,id desc')
            ->all();
        return $this->result(1, '成功',$list);
    }
    //会员详情
    public function actionVipInfo(){
        $uniacid=$this->wqData['uniacid'];
        $userId=$this->wqData['userId'];
        $user = (new \yii\db\Query())
            ->from('{{%ybwm_member}}')
            ->where('id=:id',[':id'=>$this->wqData['userId']])->one();
        $data['vipEndTime']=$user['vipEndTime'];
        if($user['vipEndTime']==0){
            $data['state']=1;
        }
        if($user['vipEndTime']>time()){
            $data['state']=2;
        }
        if($user['vipEndTime']<time() AND $user['vipEndTime']!=0){
            $data['state']=3;
        }
        $payVipRebate=Config::getSystemSet('payVipRebate',$uniacid);
        $data['payVipRebate']=$payVipRebate;
        $payVipRebateCoupon=$payVipRebate['couponArr'];
        $payVipRebateCouponInfo=(new \yii\db\Query())
            ->from('{{%ybwm_coupon}}')
            ->where(['in','id',$payVipRebateCoupon])->all();
        for($i=0;$i<count($payVipRebateCouponInfo);$i++){
            $payVipRebateCouponInfo[$i]['explain']='';
            if($payVipRebateCouponInfo[$i]['storeType']==1){
                $payVipRebateCouponInfo[$i]['explain'] .='单店可用,';
            }elseif($payVipRebateCouponInfo[$i]['storeType']==2){
                $payVipRebateCouponInfo[$i]['explain'] .='全部门店可用,';
            }else{
                $payVipRebateCouponInfo[$i]['explain'] .='部分门店可用,';
            }
            if($payVipRebateCouponInfo[$i]['goodsType']==1){
                $payVipRebateCouponInfo[$i]['explain'] .='全部商品可用,';
            }elseif($payVipRebateCouponInfo[$i]['goodsType']==2){
                $payVipRebateCouponInfo[$i]['explain'] .='指定商品可用,';
            }elseif($payVipRebateCouponInfo[$i]['goodsType']==3){
                $payVipRebateCouponInfo[$i]['explain'] .='指定商品不可用,';
            }else{
                $payVipRebateCouponInfo[$i]['explain'] .='指定分类商品可用,';
            }
            $useType=json_decode($payVipRebateCouponInfo[$i]['useType'],true);
            if(in_array('1',$useType)){
                $payVipRebateCouponInfo[$i]['explain'] .='外卖可用';
            }
            if(in_array('2',$useType)){
                $payVipRebateCouponInfo[$i]['explain'] .='堂食可用';
            }
            if(in_array('3',$useType)){
                $payVipRebateCouponInfo[$i]['explain'] .='快餐可用';
            }
        }
        $data['payVipRebate']['couponInfo']=$payVipRebateCouponInfo;
        $couponMoney = (new \yii\db\Query())
            ->from('{{%ybwm_coupon}}')
            ->where(['in','id',$payVipRebateCoupon])->sum('money');
        $payVipCycleRebate=Config::getSystemSet('payVipCycleRebate',$uniacid);
        $data['payVipCycleRebate']=$payVipCycleRebate;
        if($payVipCycleRebate['open']==1){
            $payVipCycleRebateCoupon=$payVipCycleRebate['couponArr'];
            $payVipCycleRebateCouponInfo=(new \yii\db\Query())
                ->from('{{%ybwm_coupon}}')
                ->where(['in','id',$payVipCycleRebateCoupon])->all();

            for($i=0;$i<count($payVipCycleRebateCouponInfo);$i++){
                $payVipCycleRebateCouponInfo[$i]['explain']='';
                if($payVipCycleRebateCouponInfo[$i]['storeType']==1){
                    $payVipCycleRebateCouponInfo[$i]['explain'] .='单店可用,';
                }elseif($payVipCycleRebateCouponInfo[$i]['storeType']==2){
                    $payVipCycleRebateCouponInfo[$i]['explain'] .='全部门店可用,';
                }else{
                    $payVipCycleRebateCouponInfo[$i]['explain'] .='部分门店可用,';
                }
                if($payVipCycleRebateCouponInfo[$i]['goodsType']==1){
                    $payVipCycleRebateCouponInfo[$i]['explain'] .='全部商品可用,';
                }elseif($payVipCycleRebateCouponInfo[$i]['goodsType']==2){
                    $payVipCycleRebateCouponInfo[$i]['explain'] .='指定商品可用,';
                }elseif($payVipCycleRebateCouponInfo[$i]['goodsType']==3){
                    $payVipCycleRebateCouponInfo[$i]['explain'] .='指定商品不可用,';
                }else{
                    $payVipCycleRebateCouponInfo[$i]['explain'] .='指定分类商品可用,';
                }
                $useType=json_decode($payVipCycleRebateCouponInfo[$i]['useType'],true);
                if(in_array('1',$useType)){
                    $payVipCycleRebateCouponInfo[$i]['explain'] .='外卖可用';
                }
                if(in_array('2',$useType)){
                    $payVipCycleRebateCouponInfo[$i]['explain'] .='堂食可用';
                }
                if(in_array('3',$useType)){
                    $payVipCycleRebateCouponInfo[$i]['explain'] .='快餐可用';
                }
            }
            $data['payVipCycleRebate']['couponInfo']=$payVipCycleRebateCouponInfo;

            $couponMoney += (new \yii\db\Query())
                ->from('{{%ybwm_coupon}}')
                ->where(['in','id',$payVipCycleRebateCoupon])->sum('money');
        }
        $data['economizeMoney']=$couponMoney?:0;
        $data['cumulative']=(new \yii\db\Query())
            ->from('{{%ybwm_user_coupon}}')
            ->where('userId=:userId AND receiveType=13',[':userId'=>$userId])->sum('money')?:0;//累计节省
        $wait=(new \yii\db\Query())
            ->select('count(id) as count,sum(money) as money')
            ->from('{{%ybwm_user_coupon}}')
            ->where('userId=:userId AND receiveType=13 AND state=2 AND useEndTime>'.time(),[':userId'=>$userId])->one();
        $data['waitNum']=$wait['count']?:0;//待使用数量
        $data['waitMoney']=$wait['money']?:0;//可节省金额
        $use=(new \yii\db\Query())
            ->select('count(id) as count,sum(money) as money')
            ->from('{{%ybwm_user_coupon}}')
            ->where('userId=:userId AND receiveType=13 AND state=1',[':userId'=>$userId])->one();
        $data['alreadyNum']=$use['count']?:0;//已使用数量
        $data['alreadyMoney']=$use['money']?:0;//已经节省金额
        return $this->result(1, '成功',$data);
    }
}