getRow("select subscribe from t_webuser where s_openid='$oid'")["subscribe"]; if (intval($guanzhu)<1) { $wx=new wxsk; $user = json_decode($wx->getusermsg($oid), TRUE); if ($user["subscribe"] == 1) { $db->query("update t_webuser set subscribe=1 where i_myid=$myid"); } else { Header("Location:guanzhu.php?mode=$mode&coupon_bycheckid=$coupon_bycheckid&send_coupon_staff_id=$send_coupon_staff_id&send_coupon_staff_name=$send_coupon_staff_name&n=$myid"); exit; } } $db=new DB; $oid=$_SESSION['oid']; $rowvip=$db->getRow("select * from t_vip a left join t_vip_type b on a.i_viptype_id=b.i_viptype_id where a.i_myid='$myid'"); if(!$rowvip) { $k=$db->getRow("select max(i_vip_id) as aa from t_vip")['aa']; $s_vip_no='E'.sprintf('%05s', "$k"); while($db->getRow("select 1 from t_vip where s_vip_no='$s_vip_no'")) { $k=$k+1; $s_vip_no='E'.sprintf('%05s', "$k"); } if($db->query("INSERT INTO t_vip set s_vip_no='$s_vip_no',s_vip_name='$s_vip_no',s_sex='男',i_shop_id='0',i_viptype_id='1',d_create = now(),i_myid='$myid'")){ $db->query("update t_webuser set i_newvip=2 where i_myid='$myid'"); //关注领券 $vipcouponBase = new VipcouponBase(); $vipcouponBase->handOutBySubscribe($myid); } $rowvip=$db->getRow("select * from t_vip a left join t_vip_type b on a.i_viptype_id=b.i_viptype_id where a.i_myid='$myid'"); } $_SESSION['vipid']=$rowvip['i_vip_id']; $myfname=MyWx::MYCNAME; $myphone=MyWx::PHONE; $vipimg="/img/".$rowvip['s_img']; $s_vip_no=$rowvip["s_vip_no"]; if($rowvip['i_delete_flag']==1) $s_vip_no=$s_vip_no."(禁用)"; if($rowvip['i_delete_flag']==2) $s_vip_no=$s_vip_no."(挂失)"; $f_money=''.substr($rowvip["f_money"],0,-3).''.substr($rowvip["f_money"],-3).""; $f_smedmoney=''.substr($rowvip["f_sendmoney"],0,-3).''.substr($rowvip["f_sendmoney"],-3).""; $i_credit=$rowvip["i_credit"]; $wx=new wxsk; $sign=$wx->getsign(); //客户资料没有时必须录入资料 if(empty($rowvip['s_vip_name']) || empty($rowvip['s_vip_phone'])){ Header("Location:vip_register.php?mode=$mode&coupon_bycheckid=$coupon_bycheckid&n=$myid"); exit; } $get_coupon_res = [];//领券失败 //订单支付领券 if($mode == 'get_coupon' && !empty($coupon_bycheckid)){ $vipcouponBase = new VipcouponBase(); $get_coupon_res = $vipcouponBase->handoutByCheck($coupon_bycheckid,$rowvip['i_vip_id'],'send'); } //员工发放领券 if($mode == 'get_staff_coupon' && !empty($coupon_bycheckid) && !empty($send_coupon_staff_id) && !empty($send_coupon_staff_name)){ $vipcouponBase = new VipcouponBase(); $get_coupon_res = $vipcouponBase->handoutByStaff('send',$coupon_bycheckid,$rowvip['i_vip_id'],$send_coupon_staff_id,$send_coupon_staff_name); } $get_coupon_res = json_encode($get_coupon_res); $s_vip_name = $rowvip['s_vip_name']; $s_vip_phone = $rowvip['s_vip_phone']; $show_vip_phone = substr($s_vip_phone, 0, 3).'****'.substr($s_vip_phone, 7); //自由充值最低金额 $limit_money=floatval($db->checksystemValue("VIP_LIMIT_CHARGE")); //首次充值最低金额 $first_money=floatval($db->checksystemValue("VIP_FIRST_CHARGE")); //累计充值金额，为0表示没有充值过 $addmoney=$rowvip['f_addedmoney']; //优惠券数量 $vipCoupontCount = $db->getObj("select count(*) as count from t_vipcoupon where i_vip_id = '".(int)$rowvip['i_vip_id']."' and stats=1"); //存酒相关 $cjdata = mysqli_fetch_all($db->query("select a.*,c.s_shop_name,c.s_save_client,DATE_SUB(a.d_exp_date,INTERVAL 12 HOUR) d_exp_dates from t_save a left join t_vip b on a.i_vip_id=b.i_vip_id left join t_shop c on c.i_shop_id=a.i_shop_id where a.d_exp_date > CURDATE() and b.i_vip_id='".$rowvip['i_vip_id']."' and i_current_flag=0" ),true); ?> "/>
0 ?$rowvip['s_viptype_name'] : '电子会员卡'; ?>
自助绑定
办理实体会员卡，绑定微信享更多功能及优惠
贵宾卡号
会员余额
 0 ? sprintf('%.2f',$rowvip['f_sendmoney']) : "0.00";?>
积分
0 ? sprintf('%.2f',$rowvip['i_credit']) : "0.00";?>
优惠券
count) && (int)$vipCoupontCount->count > 0 ? (int)$vipCoupontCount->count : 0; ?>
存酒
0 ? count($cjdata) : 0;?>
扫码
充值

会员系统使用说明:

1、在本公司的所有店内均可出示此卡在前台扫描二维码识别后，使用会员帐户消费或积分兑换消费；

2、可通过使用上面的“快速扫码买单”直接扫描前台帐单二唯码，选择会员帐户余额、积分或者微信钱包买单；

3、直接扫描上面的二维码推荐朋友加入会员(或直接把本页面分享推荐给朋友/圈)，会有惊喜哦；

4、点击会员卡下面的余额、积分、优惠券可查看相关详情。