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;
}
$s_vip_name = $rowvip['s_vip_name'];
$s_vip_phone = $rowvip['s_vip_phone'];
$vip_type_id = $rowvip['i_viptype_id'];
//充值
$vipcouponOftype = $db->getall("select a.* ,b.* from t_vip_getmoney as a left join t_vipcoupon_tc as b on a.i_coupon_type_id = b.i_coupon_tc_id where a.i_viptype_id = '".(int)$vip_type_id."' and a.i_online=1");
//var_dump($vipcouponOftype);
?>