nizongfeng
/
XMWXC
1
0
Fork 0
Code Issues 0 Pull Requests 0 Releases 0 Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
2 Commits
1 Branch
29 MiB
 
 
 
 
 
Branch: master
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
XMWXC/wechat/ceshi/jssdk/lotteryinfo.php

358 lines
15 KiB
Raw Permalink Blame History 

  1. <?php

  2. header("Content-type:text/html; charset=utf-8");

  3. require_once '../Common/Config.php';

  4. require_once '../Common/Function.php';

  5. require_once "jssdk.php";

  6. $pdo = new PDO("sqlsrv:Server=".HOST.";Database=".DB, USER, PASSWORD);//5.6版本pdo连接sqlsrv

  7. if ($_POST){

  8. 	$openid= htmlspecialchars($_POST['openid']);

  9. 	$fromOpenid=htmlspecialchars($_POST['fromOpenid']);

  10. 	$tel=htmlspecialchars($_POST['tel']);

  11. 	/* $openid="oCVcbv1udkL4iZm-t1h8YMrMDSyU2";

  12. 	$tel="13025822222";

  13. 	$fromOpenid=''; */

  14. 	$sql="SELECT id FROM lottery_user WHERE openId='".$openid."'";

  15. 	

  16. 	$result=$pdo->query($sql);

  17. 	$rowset = $result->fetchAll(PDO::FETCH_ASSOC);

  18. 	$errinfo=$pdo->errorInfo();

  19. 	if (!$rowset){

  20. 		$sql="SELECT TOP 1 id,lotteryCode FROM lottery_code";

  21. 		$result=$pdo->query($sql);

  22. 		$rowset = $result->fetchAll(PDO::FETCH_ASSOC);

  23. 		$errinfo=$pdo->errorInfo();

  24. 		if ($errinfo[0] =="00000"){

  25. 			$lotteryCode=$rowset[0]['lotteryCode'];

  26. 			$id=$rowset[0]['id'];

  27. 			//$id=2;

  28. 			$sql="INSERT INTO lottery_user(openId,tel,createtime) VALUES('".$openid."','".$tel."','".date("Y-m-d H:i:s",time())."')";

  29. 			$result=$pdo->exec($sql);

  30. 			$sql="INSERT INTO  lottery_friends(openId,friendsOpenId,lotteryCode,createtime) VALUES('".$openid."','".$fromOpenid."',".$lotteryCode.",'".date("Y-m-d H:i:s",time())."')";

  31. 			

  32. 	    	$result=$pdo->exec($sql);

  33. 			$sql="DELETE FROM lottery_code WHERE id=".$id;

  34. 			$result1=$pdo->exec($sql);

  35. 			if ($result && $result1 !==false){

  36. 				echo json_encode(array("errorcode"=>0,"errorinfo"=>"报名成功"));

  37. 				if ($fromOpenid !=''){

  38. 					$fsql="SELECT id FROM lottery_user WHERE openId='".$fromOpenid."'";

  39. 					$fresult=$pdo->query($fsql);

  40. 					$frowset = $fresult->fetchAll(PDO::FETCH_ASSOC);

  41. 					$errinfo=$pdo->errorInfo();

  42. 					if ($frowset){

  43. 						$icodesql="SELECT TOP 1 id,lotteryCode FROM lottery_code";

  44. 						$icoderesult=$pdo->query($icodesql);

  45. 						$icoderowset = $icoderesult->fetchAll(PDO::FETCH_ASSOC);

  46. 						//$icodeerrinfo=$pdo->errorInfo();

  47. 						if ($icoderowset){

  48. 							$iid=$icoderowset[0]['id'];

  49. 							$icode=$icoderowset[0]['lotteryCode'];

  50. 							$isql="INSERT INTO  lottery_friends(openId,lotteryCode,createtime) VALUES('".$fromOpenid."',".$icode.",'".date("Y-m-d H:i:s",time())."')";

  51. 							$iresult=$pdo->exec($isql);

  52. 							$dsql="DELETE FROM lottery_code WHERE id=".$iid;

  53. 							$iresult=$pdo->exec($dsql);

  54. 						}

  55. 						

  56. 					}

  57. 				}

  58. 				exit;

  59. 			}else{

  60. 				echo json_encode(array("errorcode"=>1,"errorinfo"=>"报名失败"));exit;

  61. 			}

  62. 		}else{

  63. 			echo json_encode(array("errorcode"=>2,"errorinfo"=>"抽奖码已发完"));exit;

  64. 		}

  65. 	}else{

  66. 		echo json_encode(array("errorcode"=>3,"errorinfo"=>"微信号已经报名"));exit;

  67. 	}

  68. }

  69. if (isset($_GET['openId'])){

  70. 	$openId=$_GET['openId'];

  71. 	//$openId="oCVcbv1udkL4iZm-t1h8YMrMDSyU";

  72. 	$sql="SELECT id,tel,sharTimeLine,lotteryCode FROM lottery_user WHERE openId='{$openId}'";

  73. 	

  74. 	//$pdo=new PDO("mysql:host=".HOST.";dbname=".DB,USER,PASSWORD); //7.0版本pdo连接mysql

  75. 	$result=$pdo->query($sql);

  76. 	$rowset = $result->fetchAll(PDO::FETCH_ASSOC);

  77. 	$errinfo=$pdo->errorInfo();

  78. 	if($rowset){

  79. 		$htmlTel=$rowset[0]['tel'];

  80. 		

  81. 		$codeSql="SELECT lotteryCode FROM lottery_friends WHERE openId='{$openId}'";

  82. 		

  83. 		//$pdo=new PDO("mysql:host=".HOST.";dbname=".DB,USER,PASSWORD); //7.0版本pdo连接mysql

  84. 		$codeResult=$pdo->query($codeSql);

  85. 		$codeRowset = $codeResult->fetchAll(PDO::FETCH_ASSOC);

  86. 		if ($codeRowset){

  87. 			$htmlCode="";

  88. 			foreach ($codeRowset as $v){

  89. 				$htmlCode.=$v['lotteryCode'].",";

  90. 			}

  91. 			 $htmlCode=rtrim($htmlCode,",");

  92. 		}

  93. 		//$htmlCode=$rowset[0]['lotteryCode'];

  94. 		$sharTimeLine=$rowset[0]['sharTimeLine'];

  95. 		$updateId=$rowset[0]['id'];

  96. 		$jssdk = new JSSDK(APPID, APPSECRET);

  97. 		$signPackage = $jssdk->GetSignPackage();

  98. 		

  99. 		$news = array(

  100. 				"Title" =>"【免费巴士自由行】千岛湖、普陀山共10名额 蜘蛛出行请你玩",

  101. 				"Description"=>"【蜘蛛出行微信上线啦~】千岛湖、普陀山巴士自由行各5个免单名额相送！关注我们预定安全舒适便捷的巴士出行 : D",

  102. 				"PicUrl" =>'https://mmbiz.qlogo.cn/mmbiz/xVqMASLIx1nE5XSsicXcM1znAqdS9rBA8W1GgS55lnu0fRR1AgsyzRiaTb5ANLVhrtdQ6FFEjFpypPVuylpH1kVQ/0?wx_fmt=jpeg',

  103. 				"Url" =>'http://xmwxc.zhizhuchuxing.cn/wechat/jssdk/activity.php');

  104. 		$sharfriendArr=array("url"=>'http://xmwxc.zhizhuchuxing.cn/wechat/jssdk/activity.php?fromOpenId='.$openId);

  105. 	}else {

  106. 		$infoUrl="http://".$_SERVER['HTTP_HOST']."/wechat/jssdk/activity.php?openId=".$openId;

  107. 		Header("Location: $infoUrl");

  108. 		exit();

  109. 	}

  110. 	

  111. }else if(!isset($_GET['code'])){

  112. 	$selfUrl=urlencode("http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']);

  113. 	$getCodeUrl="https://open.weixin.qq.com/connect/oauth2/authorize?appid=".APPID."&redirect_uri=".$selfUrl."&response_type=code&scope=snsapi_base&state=STATE#wechat_redirect";

  114. 	Header("Location: $getCodeUrl");

  115. 	exit();

  116. }else{

  117. 	$code=$_GET['code'];

  118. 	$getOpenidUrl="https://api.weixin.qq.com/sns/oauth2/access_token?appid=".APPID."&secret=".APPSECRET."&code=".$code."&grant_type=authorization_code";

  119. 	$response=http_request($getOpenidUrl);

  120. 	$openIdObj=json_decode($response);

  121. 	$openId=$openIdObj->openid;

  122. 	$url="http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']."&openId=".$openId;

  123. 	Header("Location: $url");

  124. 	exit;

  125. }

  126. ?>

  127. <!DOCTYPE html>

  128. <html>

  129. 	<head>

  130. 		<meta charset="UTF-8">

  131. 		<meta content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0" name="viewport" />

  132. 		<title></title>

  133. 		<style>

  134. 			*{margin:0px;padding: 0px;font-family: "黑体";}

  135. 			.tishi2{width:100%;text-align: center;font-size:18px;line-height: 30px;margin-bottom:20px;}

  136. 			.page2moblie,.page2choujiang{width:100%;text-align: center;margin-bottom:5px;}

  137. 			.page2moblie span,.page2choujiang span{font-size: 16px;}

  138. 			.kjtime{width:100%;text-align: center;font-size: 18px;margin-top:20px;}

  139. 			.kjtime2{width:100%;text-align: center;font-size: 18px;margin-top:5px;margin-bottom: 10px;}

  140. 			.anniu2{width:90%;margin:auto;text-align: center;height: 35px;line-height: 35px;font-size: 18px;color: #FFFFFF;background: #33d6b0;margin-bottom: 10px;margin-top:15px;}

  141. 			.tishi3{margin-left:5%;font-weight: bold;text-align: left;margin-top:17px;}

  142. 			.tishi4{width:90%;margin:auto;font-size: 14px;margin-top:10px;line-height: 22px;}

  143. 			.zhizhulogo{width:100%;height: 136px;}

  144. 			.black{position: absolute;top:0;left: 0;background: #000000;opacity: 0.4;width:100%;}

  145. 			.tishi5{position: absolute;top:175px;left: 0;right: 0;margin:auto;background: #FFFFFF;width:66%;border-radius:5px;padding: 10px;padding-top:30px;padding-bottom:30px;font-size:15px;display: none;}

  146. 			.x{position: absolute;top:5px;right:5px; height: 20px;width:20px;text-align: center;line-height: 21px;font-size: 21px;background:#FF7E00;color:#FFFFFF;border-radius:2px;}

  147. 			.erweima{width:180px;margin-top:10px;}

  148. 		</style>

  149. 	</head>

  150. 	<body id="body">

  151. 		<div style="position: relative;">

  152. 			<div class="page2" id="page2">

  153. 				<div class="tishi2">

  154. 					<div style="margin-bottom:5px;width:90%;margin:auto;padding-top:85px;">您已成功参与蜘蛛出行免单活动!</div>

  155. 					<div style="text-align: center; font-size:15px;"><a href="http://mp.weixin.qq.com/s?__biz=MzIwNjI0MDAwOQ==&mid=502857775&idx=2&sn=1d04e2f10383af14cdd1a8481353e9ef&scene=1&srcid=05187fCeBZFiQD8IUOgrRN1R#rd" style="color: #33d6b0;">点击选择奖品>></a></div>

  156. 					

  157. 					<!--<div>免费千岛湖巴士自由行共5名额</div>

  158. 					<div style="font-size: 14px;">上海出发 不含住宿及门票</div>

  159. 					<div>免费普陀山巴士自由行共5名额</div>

  160. 					<div style="font-size: 14px;">上海出发 不含住宿及门票</div>-->

  161. 					<!--<a href="http://mp.weixin.qq.com/s?__biz=MzIwNjI0MDAwOQ==&mid=502857775&idx=2&sn=1d04e2f10383af14cdd1a8481353e9ef&scene=0&previewkey=m65GKbcndwwmEE8v%2FfjGRcwqSljwj2bfCUaCyDofEow%3D#wechat_redirect">

  162. 						<img style="height: 277px;width:100%;" src="img/lotop.png"/>

  163. 					</a>-->

  164. 				</div>

  165. 				<div class="page2moblie" style="margin-bottom:63px;">

  166. 					<span>手机号：</span>

  167. 					<span id="moblienum2"><?php echo $htmlTel; ?></span>

  168. 				</div>

  169. 				<div id="cjm">

  170. 				

  171. 				<div class="page2choujiang">

  172. 						<div style="margin-bottom:20px;">你的抽奖码：</div>

  173. 						<div id="choujiangma" style="width:90%;margin-left:5%;padding-right:5%; word-wrap: break-word; word-break: break-all;"><?php echo $htmlCode;?></div>

  174. 					</div>

  175. 				<?php 

  176. 				/* foreach ($codeRowset as $v){

  177. 					echo "<div class='page2choujiang'><span>抽奖码：</span><span>".$v['lotteryCode']."</span></div>";

  178. 				} */

  179. 				?>

  180. 				</div>

  181. 				<div class="anniu2" id="anniu2">多要一个抽奖码</div>

  182. 				<!--<div class="anniu2" id="anniu3">再拿一个大红包</div>-->

  183. 				<div class="tishi3" style="margin-top:30px;">开奖时间：</div>

  184. 				<div class="tishi4" >2016年5月23日 周一 18：00</div>

  185. 				<div class="tishi3">温馨提示：</div>

  186. 				<div class="tishi4" >长按下方二维码关注我们，获取中奖提醒；若开奖时未关注蜘蛛出行，中奖视为无效。</div>

  187. 			<!--	<div class="tishi4" >2.点击上方[再拿一个大红包]，成功邀请2位好友参与，奖励一个大红包！红包数量有限，先到先得哦！</div>-->

  188. 				<div style="margin:0 auto;text-align: center;">

  189. 					<img class="erweima" src="../Public/images/erweima.jpg" alt="" />

  190. 					<img class="zhizhulogo" style="width:300px;" src="../Public/images/zhizhulogo.png" alt="" />

  191. 				</div>

  192. 			</div>

  193. 			<div class="black" id="black"></div>

  194. 			<div class="tishi5" id="tishi5">

  195. 				<div class="x" id="x">×</div>

  196. 				<div id="content"></div>

  197. 			</div>

  198. 		</div>

  199. 	</body>

  200. 	<script>

  201. 		var anniu3=document.getElementById("anniu3");

  202. 		var anniu2=document.getElementById("anniu2");

  203. 		var tishi5=document.getElementById("tishi5");

  204. 		var black=document.getElementById("black");

  205. 		var body=document.getElementById("body");

  206. 		var x=document.getElementById("x");

  207. 		var content=document.getElementById("content");

  208. 		var H=document.documentElement.clientHeight;

  209. 		

  210. 		black.style.height=H+"px";

  211. 		black.style.display="none";

  212. 		var banmove=function(ev){ev.preventDefault();}

  213. 		anniu2.onclick=function(){

  214. 			window.scrollTo(0,0);

  215. 			body.addEventListener("touchmove",banmove);

  216. 			body.style.height=H+'px';

  217. 			body.style.overflow="hidden";

  218. 			black.style.display="block";

  219. 			tishi5.style.display="block";

  220. 			content.innerHTML="点击右上角【···】，选择【分享朋友圈】，分享成功，您即多获得一个抽奖码；<br>选择【发送给朋友】每邀请一位好友报名成功，再额外获得一个抽奖码！"

  221. 		}

  222. 		/* anniu3.onclick=function(){

  223. 			body.style.overflow="hidden";

  224. 			black.style.display="block";

  225. 			tishi5.style.display="block";

  226. 			content.innerHTML="点击右上角【···】，选择【发送给朋友】邀请两位好友报名成功，您即可领取红包！共190份红包，先到先得！"

  227. 		} */

  228. 		x.onclick=function(){

  229. 			body.removeEventListener("touchmove",banmove);

  230. 			tishi5.style.display="none";

  231. 			black.style.display="none";

  232. 			body.style.overflow="scroll";

  233. 		}

  234. 	</script>

  235. 	

  236. 	<script src="http://res.wx.qq.com/open/js/jweixin-1.0.0.js"></script>

  237. 	<script src="../Public/js/jquery-1.12.3.min.js"></script>

  238. <script>

  239.   /*

  240.    * 注意：

  241.    * 1. 所有的JS接口只能在公众号绑定的域名下调用，公众号开发者需要先登录微信公众平台进入“公众号设置”的“功能设置”里填写“JS接口安全域名”。

  242.    * 2. 如果发现在 Android 不能分享自定义内容，请到官网下载最新的包覆盖安装，Android 自定义分享接口需升级至 6.0.2.58 版本及以上。

  243.    * 3. 常见问题及完整 JS-SDK 文档地址：http://mp.weixin.qq.com/wiki/7/aaa137b55fb2e0456bf8dd9148dd613f.html

  244.    *

  245.    * 开发中遇到问题详见文档“附录5-常见错误及解决办法”解决，如仍未能解决可通过以下渠道反馈：

  246.    * 邮箱地址：weixin-open@qq.com

  247.    * 邮件主题：【微信JS-SDK反馈】具体问题

  248.    * 邮件内容说明：用简明的语言描述问题所在，并交代清楚遇到该问题的场景，可附上截屏图片，微信团队会尽快处理你的反馈。

  249.    */

  250.   wx.config({

  251.     debug: false,

  252.     appId: '<?php echo $signPackage["appId"];?>',

  253.     timestamp: <?php echo $signPackage["timestamp"];?>,

  254.     nonceStr: '<?php echo $signPackage["nonceStr"];?>',

  255.     signature: '<?php echo $signPackage["signature"];?>',

  256.     jsApiList: [

  257.       // 所有要调用的 API 都要加到这个列表中

  258.       //'checkJsApi',

  259.       'onMenuShareTimeline',

  260.       'onMenuShareAppMessage'

  261.     ]

  262.   });

  263.   wx.ready(function () {

  264. 

  265. 	//检查是否支持jsApi

  266. 	/*   wx.checkJsApi({

  267. 	      jsApiList: [

  268. 	          'onMenuShareTimeline',

  269. 	          'onMenuShareAppMessage'

  270. 	         

  271. 

  272. 	      ],

  273. 	      success: function (res) {

  274. 	          //alert(1);

  275. 	          alert(JSON.stringify(res));

  276. 	      }

  277. 	  }); */

  278. 

  279. 

  280.     // 在这里调用 API

  281. 

  282. 	  wx.onMenuShareTimeline({ //分享到朋友圈

  283.       title: '<?php echo $news['Title'];?>',

  284.       link: '<?php echo $news['Url'];?>',

  285.       imgUrl: '<?php echo $news['PicUrl'];?>',

  286.       trigger: function (res) {

  287.         // 不要尝试在trigger中使用ajax异步请求修改本次分享的内容，因为客户端分享操作是一个同步操作，这时候使用ajax的回包会还没有返回

  288.         // alert('用户点击分享到朋友圈');

  289.     	  

  290.       },

  291.       success: function (res) {

  292.     	   		alert("分享成功");

  293.     	   		var url="http://xmwxc.zhizhuchuxing.cn/wechat/jssdk/lottery.php";

  294.     			$.ajax({  

  295.     				type:'post',

  296.     				async:false,

  297.     				cache:false,

  298.     				data:{

  299.         				method:"shareTimeLine",

  300.         				sharTimeLine:<?php echo $sharTimeLine;?>,

  301.         				updateId:<?php echo $updateId;?>,

  302.         				openId:'<?php echo $openId;?>'

  303.         			},

  304.     				url : url,

  305.     				success  : function(data) {

  306.     					window.location.href = "http://xmwxc.zhizhuchuxing.cn/wechat/jssdk/lotteryinfo.php?openId=<?php echo $openId;?>";

  307.     				},  

  308.     				error : function() {  

  309.     					alert('fail');  

  310.     				}  

  311.     			});

  312.       },

  313.       cancel: function (res) {

  314.          alert('已取消');

  315.       },

  316.       fail: function (res) {

  317.         // alert(JSON.stringify(res));

  318.       }

  319.     });

  320. 

  321. 

  322. 

  323. 	  wx.onMenuShareAppMessage({ //分享给朋友

  324. 	      title: '<?php echo $news['Title'];?>',

  325. 	      desc: '<?php echo $news['Description'];?>',

  326. 	      link: '<?php echo $sharfriendArr['url']?>',

  327. 	      imgUrl: '<?php echo $news['PicUrl'];?>',

  328. 	      trigger: function (res) {

  329. 	        // 不要尝试在trigger中使用ajax异步请求修改本次分享的内容，因为客户端分享操作是一个同步操作，这时候使用ajax的回包会还没有返回

  330. 	        // alert('用户点击发送给朋友');

  331. 	      },

  332. 	      success: function (res) {

  333. 	         alert('已分享');

  334. 	    	  //alert(JSON.stringify(res));

  335. 	      },

  336. 	      cancel: function (res) {

  337. 	        // alert('已取消');

  338. 	      },

  339. 	      fail: function (res) {

  340. 	        // alert(JSON.stringify(res));

  341. 	      }

  342. 	    });

  343. 	  /* wx.hideMenuItems({

  344. 

  345. 		    menuList: [

  346. 				'menuItem:share:appMessage',

  347. 				'menuItem:share:timeline',

  348. 				'menuItem:copyUrl'

  349. 			] // 要隐藏的菜单项，只能隐藏“传播类”和“保护类”按钮，所有menu项见附录3

  350. 

  351. 		}); */

  352. 

  353.   });  

  354. 

  355.   

  356. </script>

  357. </html>