event_pay_wx_notify.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322
  1. <?php
  2. define('IN_API', true);
  3. define('CURSCRIPT', 'api');
  4. require '../../../source/class/class_core.php';
  5. require '../../../source/function/function_forum.php';
  6. include 'include/sms_func.php';
  7. if(!$_GET['echostr']){
  8. $_GET['formhash'] = formhash();
  9. }
  10. $discuz = C::app();
  11. $discuz->init();
  12. if(file_exists($xj_event_wxset = DISCUZ_ROOT.'./data/sysdata/cache_xj_event_wxset.php')) {
  13. @include $xj_event_wxset;
  14. }
  15. if(function_exists('file_get_contents')){
  16. $xml = file_get_contents("php://input");
  17. }else{
  18. $xml = $GLOBALS["HTTP_RAW_POST_DATA"];
  19. }
  20. $post = xmlToArray($xml);
  21. $paytype = DB::result_first("SELECT paytype FROM ".DB::table('xj_eventpay_log')." WHERE tradeno='".$post['out_trade_no']."'");
  22. if($paytype == 'appwxpay'){
  23. $apikey = $wxset['open_apikey']; //APIKEY
  24. }elseif($paytype == 'xcxwxpay'){
  25. $apikey = $wxset['xcx_apikey']; //APIKEY
  26. }else{
  27. $apikey = $wxset['apikey']; //APIKEY
  28. }
  29. if(checkSign($post)){
  30. if($post['result_code'] == 'SUCCESS'){
  31. $paylog = DB::fetch_first("SELECT * FROM ".DB::table('xj_eventpay_log')." WHERE tradeno='".$post['out_trade_no']."'");
  32. if($paylog['paystate'] != 3){
  33. $data = array();
  34. $data['paystate'] = 3;
  35. $data['orderid'] = $post['transaction_id'];
  36. $data['pay_time'] = $_G['timestamp'];
  37. $data['notify_time'] = $_G['timestamp'];
  38. DB::update("xj_eventpay_log",$data,"tradeno='".$post['out_trade_no']."'");
  39. $paylog = DB::fetch_first("SELECT applyid,trade_status,uid,tid FROM ".DB::table('xj_eventpay_log')." WHERE tradeno='".$post['out_trade_no']."'");
  40. $tid = $paylog['tid'];
  41. $uid = $paylog['uid'];
  42. $data = array();
  43. $data['pay_state'] = 1;
  44. $data['verify'] = 1;
  45. DB::update("xj_eventapply",$data,"tid=$tid AND uid=$uid");
  46. //邀请的奖励处理
  47. $items = DB::fetch(DB::query("SELECT A.*,B.authorid,B.subject FROM ".DB::table('xj_event')." A LEFT JOIN ".DB::table('forum_thread')." B ON A.tid = B.tid WHERE A.tid = $tid"));
  48. $setting = unserialize($items['setting']);
  49. if($setting['yqjl_jfs']>0){
  50. $apply = DB::fetch_first("SELECT * FROM ".DB::table('xj_eventapply')." WHERE applyid = ".$paylog['applyid']);
  51. if($apply['fromuid'] > 0){
  52. $applynumber = DB::result_first("SELECT SUM(applynumber) FROM ".DB::table('xj_eventapply')." WHERE tid=".$tid." AND uid=".$uid);
  53. $yqjl = array();
  54. $yqjl['tid'] = $tid;
  55. $yqjl['fromuid'] = $apply['fromuid'];
  56. $yqjl['applyuid'] = $uid;
  57. $yqjl['jfs'] = $setting['yqjl_jfs']*$applynumber;
  58. $yqjl['jflx'] = $setting['yqjl_jflx'];
  59. $yqjl['dateline'] = $_G['timestamp'];
  60. DB::insert('xj_event_yqjl_log',$yqjl);
  61. updatemembercount($yqjl['fromuid'],array($yqjl['jflx']=>+$yqjl['jfs']));
  62. $username = DB::result_first("SELECT username FROM ".DB::table('common_member')." WHERE uid=$uid");
  63. $eventtitle = DB::result_first("SELECT subject FROM ".DB::table('forum_thread')." WHERE tid = $tid");
  64. notification_add($yqjl['fromuid'],'system',$username.lang('plugin/xj_event','beiniyaoqinbaomincanjiale').' <a href="forum.php?mod=viewthread&tid='.$tid.'" target="_blank">'.$eventtitle.'</a> '.lang('plugin/xj_event','huodonghuode').$yqjl['jfs'].$_G['setting']['extcredits'][$yqjl['jflx']]['title'].lang('plugin/xj_event','jiangli'));
  65. }
  66. }
  67. paysmssend($tid,$uid);
  68. //通知
  69. $username = DB::result_first("SELECT username FROM ".DB::table('common_member')." WHERE uid=$uid");
  70. if($_G['charset']=='gbk'){
  71. notification_add($items['authorid'], 'system', $username.iconv('UTF-8','GBK','报名参加了你的活动').' <a href="forum.php?mod=viewthread&tid='.$tid.'" target="_blank">'.$items['subject'].'</a> '.iconv('UTF-8','GBK','并已支付活动费用'),array(),0);
  72. }else{
  73. notification_add($items['authorid'], 'system', $username.'报名参加了你的活动 <a href="forum.php?mod=viewthread&tid='.$tid.'" target="_blank">'.$items['subject'].'</a> 并已支付活动费用',array(),0);
  74. }
  75. //微信消息
  76. loadcache('plugin');
  77. if($_G['cache']['plugin']['xj_wxmessage']['wxlogin']){
  78. require_once DISCUZ_ROOT . './source/plugin/xj_wxmessage/class/core.class.php';
  79. $xj_wxmessagecore = new xj_wxmessagecore();
  80. $xj_wxmessagecore->send_eventmessage($uid,$tid,1);
  81. $xj_wxmessagecore->send_eventapplymessage($paylog['applyid'],$items['authorid'],2);
  82. }
  83. }
  84. $return = array();
  85. $return['return_code'] = 'SUCCESS'; //SUCCESS/FAIL SUCCESS表示商户接收通知成功并校验成功
  86. $return['return_msg'] = 'ok'; //返回信息,如非空,为错误原因
  87. }else{
  88. $return = array();
  89. $return['return_code'] = 'FAIL'; //SUCCESS/FAIL SUCCESS表示商户接收通知成功并校验成功
  90. $return['return_msg'] = 'ERROR'; //返回信息,如非空,为错误原因
  91. }
  92. echo arrayToXml($return);
  93. }else{
  94. //调试记录开始
  95. $log_name="./wxpay.txt";//log文件路径
  96. log_result($log_name,"【签名".$apikey."不正确】:\r\n".$xml."\r\n【返回的信息】:".arrayToXml($return)."\r\n");
  97. //调试记录结
  98. exit('error');
  99. }
  100. //调试记录开始
  101. //$log_name="./wxpay.txt";//log文件路径
  102. //log_result($log_name,"【接收到的notify通知】:\r\n".$xml."\r\n【返回的信息】:".arrayToXml($return)."\r\n");
  103. //调试记录结束
  104. /*
  105. $url='http://'.$_SERVER['SERVER_NAME'].$_SERVER["REQUEST_URI"];
  106. $url = str_replace('source/plugin/xj_event/event_pay_wx_notify.php','plugin.php?id=xj_event:wsq_pay_notify',$url);
  107. $return = postxml($url,$xml);
  108. */
  109. function paysmssend($tid,$uid){
  110. global $_G;
  111. //调试记录开始
  112. //$log_name="./alipay.txt";//log文件路径
  113. //log_result($log_name,"【接收到的notify通知】:\r\n".$xml."\r\n【返回的信息】:\r\n");
  114. //调试记录结束
  115. $apply = DB::fetch_first("SELECT * FROM ".DB::table('xj_eventapply')." WHERE first=1 AND tid=$tid AND uid=$uid");
  116. $thread = DB::fetch_first("SELECT authorid,userfield,setting,subject,starttime,event_address FROM ".DB::table('forum_thread')." A,".DB::table('xj_event')." B WHERE A.tid=$tid and A.tid = B.tid");
  117. $setting = unserialize($thread['setting']);
  118. $event_starttime = dgmdate($thread['starttime'],'dt');
  119. if($setting['seccode'] == 1){
  120. $message = cutstr($thread['subject'],30).'活动报名成功,人数:'.$apply['applynumber'].'人 验证码:'.$apply['seccode'].' 活动时间:'.$event_starttime;
  121. $sendtype = '报名验证码短信';
  122. if($_G[charset]=='gbk'){
  123. $message = diconv($message,'UTF-8','GBK');
  124. $sendtype = diconv($sendtype,'UTF-8','GBK');
  125. }
  126. sendsms_vcode($apply['mobile'],$thread['subject'],$apply['applynumber'],$apply['seccode']);
  127. //xjsendsms(array($apply['mobile']),$message,$sendtype);
  128. sendpm($apply['uid'],'',$message,$thread['authorid']);
  129. }elseif($setting['success_sms'] == 1){
  130. sendsms_success($apply['mobile'],$thread['subject'],$event_starttime);
  131. //易活动短信
  132. //$smsuid = DB::result_first("SELECT uid FROM ".DB::table('common_member')." WHERE username='".$setting['event_admin'][0]."'");
  133. //$smsmobile = DB::result_first("SELECT mobile FROM ".DB::table('common_member_profile')." WHERE uid=$smsuid");
  134. //sendsms_notice_yhd($apply['mobile'],$thread['subject'],$event_starttime,$thread['event_address'],$smsmobile);
  135. }
  136. }
  137. function postxml($url,$data){
  138. $ch = curl_init($url);
  139. curl_setopt($ch, CURLOPT_MUTE, 1);
  140. curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
  141. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
  142. curl_setopt($ch, CURLOPT_POST, 1);
  143. curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: text/xml'));
  144. curl_setopt($ch, CURLOPT_POSTFIELDS, "$data");
  145. curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  146. $output = curl_exec($ch);
  147. curl_close($ch);
  148. return $output;
  149. }
  150. /**
  151. * 作用:array转xml
  152. */
  153. function arrayToXml($arr)
  154. {
  155. $xml = "<xml>";
  156. foreach ($arr as $key=>$val)
  157. {
  158. if (is_numeric($val))
  159. {
  160. $xml.="<".$key.">".$val."</".$key.">";
  161. }
  162. else
  163. $xml.="<".$key."><![CDATA[".$val."]]></".$key.">";
  164. }
  165. $xml.="</xml>";
  166. return $xml;
  167. }
  168. /**
  169. * 作用:将xml转为array
  170. */
  171. function xmlToArray($xml)
  172. {
  173. //将XML转为array
  174. $array_data = json_decode(json_encode(simplexml_load_string($xml, 'SimpleXMLElement', LIBXML_NOCDATA)), true);
  175. return $array_data;
  176. }
  177. // 打印log
  178. function log_result($file,$word)
  179. {
  180. $fp = fopen($file,"a");
  181. flock($fp, LOCK_EX) ;
  182. fwrite($fp,"执行日期:".strftime("%Y-%m-%d-%H:%M:%S",time())."\n".$word."\n\n");
  183. flock($fp, LOCK_UN);
  184. fclose($fp);
  185. }
  186. /**
  187. * 作用:格式化参数,签名过程需要使用
  188. */
  189. function formatBizQueryParaMap($paraMap, $urlencode)
  190. {
  191. $buff = "";
  192. ksort($paraMap);
  193. foreach ($paraMap as $k => $v)
  194. {
  195. if($urlencode)
  196. {
  197. $v = urlencode($v);
  198. }
  199. //$buff .= strtolower($k) . "=" . $v . "&";
  200. $buff .= $k . "=" . $v . "&";
  201. }
  202. $reqPar;
  203. if (strlen($buff) > 0)
  204. {
  205. $reqPar = substr($buff, 0, strlen($buff)-1);
  206. }
  207. return $reqPar;
  208. }
  209. //生成签名
  210. function getSign($Obj){
  211. global $apikey;
  212. foreach ($Obj as $k => $v)
  213. {
  214. $Parameters[$k] = $v;
  215. }
  216. //签名步骤一:按字典序排序参数
  217. ksort($Parameters);
  218. $String = formatBizQueryParaMap($Parameters, false);
  219. //echo '【string1】'.$String.'</br>';
  220. //签名步骤二:在string后加入KEY
  221. $String = $String."&key=$apikey";
  222. //echo "【string2】".$String."</br>";
  223. //签名步骤三:MD5加密
  224. $String = md5($String);
  225. //echo "【string3】 ".$String."</br>";
  226. //签名步骤四:所有字符转为大写
  227. $result_ = strtoupper($String);
  228. //echo "【result】 ".$result_."</br>";
  229. return $result_;
  230. }
  231. //验证签名是否正确
  232. function checkSign($xmlarray){
  233. $tmpData = $xmlarray;
  234. unset($tmpData['sign']);
  235. $sign = getSign($tmpData);//本地签名
  236. //调试记录开始
  237. //$log_name="./wxpay.txt";//log文件路径
  238. //log_result($log_name,"【本地签名】:\r\n".$sign."\r\n");
  239. //调试记录结
  240. if ($xmlarray['sign'] == $sign) {
  241. return TRUE;
  242. }
  243. return FALSE;
  244. }
  245. function postXmlCurl($xml,$url,$second=30)
  246. {
  247. //初始化curl
  248. $ch = curl_init();
  249. //设置超时
  250. curl_setopt($ch, CURLOP_TIMEOUT, $second);
  251. //这里设置代理,如果有的话
  252. //curl_setopt($ch,CURLOPT_PROXY, '8.8.8.8');
  253. //curl_setopt($ch,CURLOPT_PROXYPORT, 8080);
  254. curl_setopt($ch,CURLOPT_URL, $url);
  255. curl_setopt($ch,CURLOPT_SSL_VERIFYPEER,FALSE);
  256. curl_setopt($ch,CURLOPT_SSL_VERIFYHOST,FALSE);
  257. //设置header
  258. curl_setopt($ch, CURLOPT_HEADER, FALSE);
  259. //要求结果为字符串且输出到屏幕上
  260. curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
  261. //post提交方式
  262. curl_setopt($ch, CURLOPT_POST, TRUE);
  263. curl_setopt($ch, CURLOPT_POSTFIELDS, $xml);
  264. //运行curl
  265. $data = curl_exec($ch);
  266. curl_close($ch);
  267. //返回结果
  268. if($data)
  269. {
  270. curl_close($ch);
  271. return $data;
  272. }
  273. else
  274. {
  275. $error = curl_errno($ch);
  276. echo "curl error:$error"."<br>";
  277. echo "<a href='http://curl.haxx.se/libcurl/c/libcurl-errors.html'>error view</a></br>";
  278. curl_close($ch);
  279. return false;
  280. }
  281. }
  282. ?>