接口110
来源:互联网 发布:淘宝编辑供货商 编辑:程序博客网 时间:2024/04/29 10:19
省市区县View CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView CodeView Code
<?phprequire dirname(__FILE__).'/includes/common.inc.php'; //省 $_data = array(); $_sql = "SELECT id,areaId,areaName,sort FROM tb_area WHERE areaType = 1 AND state = 0"; $_result = _query($_sql); while($_rows = _fetch_array($_result)){ $_html = array(); $_html['areaId'] = $_rows['areaId']; $_html['id'] = $_rows['id']; $_html['areaName'] = $_rows['areaName']; $_html['sort'] = $_rows['sort']; $_html = _html($_html); //市 $_city = array(); $_sql2 = "SELECT id,areaName,sort FROM tb_area WHERE areaType = 2 AND state = 0 AND areaId = '{$_html['id']}'"; $_result2 = _query($_sql2); while($_rows2 = _fetch_array($_result2)){ $_html2 = array(); $_html2['id'] = $_rows2['id']; $_html2['areaName'] = $_rows2['areaName']; $_html2['sort'] = $_rows2['sort']; $_html2 = _html($_html2); //县 $_county = array(); $_sql3 = "SELECT id,areaName,sort FROM tb_area WHERE areaType = 3 AND state = 0 AND areaId = '{$_html2['id']}'"; $_result3 = _query($_sql3); while($_rows3 = _fetch_array($_result3)){ $_html3 = array(); $_html3['id'] = $_rows3['id']; $_html3['areaName'] = $_rows3['areaName']; $_html3['sort'] = $_rows3['sort']; $_html3 = _html($_html3); //将信息放入$_county数组 $_county[] = $_html3; } //将区县放入城市打印 $_html2['county'] = $_county; //将城市信息放入$_city数组 $_city[] = $_html2; } //将城市放入省打印 $_html['city'] = $_city; } //将省放入date打印 $_data['$_html'] = $_html; echo _json($_data); _free_result($_result); _free_result($_result2); _free_result($_result3); _close();?>
广告
<?php require dirname(__FILE__).'/includes/common.inc.php'; $_ads = array(); $_data = array(); $_sql = "SELECT id,picName,picImg,picLink FROM tb_picadvert WHERE weizi = 11 AND isFreeze = 1"; $_result = _query($_sql); while ( $_rows = _fetch_array($_result) ) { $_html = array(); $_html['id'] = $_rows['id']; $_html['title'] = $_rows['picName']; $_html['pic'] = 'http://www.easyhunt.cn/' . $_rows['picImg']; $_html['picLink'] = $_rows['picLink']; $_html = _html($_html); $_data[] = $_html; } $_ads['state'] = 0; $_ads['info'] = ''; $_ads['data'] = $_data; echo _json($_ads); _free_result($_result); _close(); ?>
类别和地区
<?php require dirname(__FILE__).'/includes/common.inc.php'; $_clean = array(); $_clean['grade'] = 2 ; $_allKinds = array(); $_data = array(); $_area = array(); $_html = array(); //查出市区县 $_sql = "SELECT id,areaId,areaName,areaType FROM tb_area WHERE areaType IN (2,3,4) AND state = 0 AND areaId > 0 ORDER BY sort ASC"; $_result = _query($_sql); while( $_rows = _fetch_array($_result) ) { $_html['id'] = $_rows['id']; $_html['areaId'] = $_rows['areaId']; $_html['areaName'] = $_rows['areaName']; $_html['areaType'] = $_rows['areaType']; $_html = _html($_html); //装入数组 $_area[] = $_html; } //如果传入的大类有值 if ( $_clean['grade'] > 0 && $_clean['grade'] < 6 ) { $_allKinds['state'] = 0; $_allKinds['info'] = ''; $_category = array(); $_sql4 = "SELECT id,categoryName,categoryId FROM tb_category WHERE grade = '{$_clean['grade']}' AND state = 0 ORDER BY sort ASC"; $_result4 = _query($_sql4); $_html4 = array(); //类型ID和名 while ( $_rows4 = _fetch_array($_result4) ) { $_html4['id'] = $_rows4['id']; $_html4['categoryId'] = $_rows4['categoryId']; $_html4['categoryName'] = $_rows4['categoryName']; $_html4 = _html($_html4); //装入数组 $_category[] = $_html4; } //平级 $_data['category'] = $_category; $_data['area'] = $_area; //放入数组打印 $_allKinds['data'] = $_data; } else { $_allKinds['state'] = 1; $_allKinds['info'] = '参数有误!'; } echo _json($_allKinds); _free_result($_result); _free_result($_result1); _close(); ?>
大类跟地区
<?php require dirname(__FILE__).'/includes/common.inc.php'; $_info = array(); $_data = array(); //大类区县平级 $_clean = array(); $_clean['cityId'] = 1; if ( $_clean['cityId'] > 0 ) { $_info['state'] = 0; $_info['info'] = ''; $_area = array(); $_html2 = array(); $_html2['id'] = '-2'; $_html2['areaId'] = '2'; $_html2['areaName'] = '全部区域'; $_area[] = $_html2; //城市信息 放入数组 $_sql2 = "SELECT id,areaName,areaId FROM tb_earea WHERE areaType IN (3,4) AND state = 0 ORDER BY sort ASC"; $_result2 = _query($_sql2); while ( $_rows2 = _fetch_array($_result2) ) { $_html2['id'] = $_rows2['id']; $_html2['areaId'] = $_rows2['areaId']; $_html2['areaName'] = $_rows2['areaName']; $_html2 = _html($_html2); $_area[] = $_html2; } //城市放入date下 $_data['area'] = $_area; $_bigClass = array(); $_html3 = array(); $_html3['id'] = '-2'; $_html3['categoryName'] = '全部类型'; //查询大类信息 放入数组 $_bigClass[] = $_html3; $_sql3 = "SELECT id,categoryName FROM tb_ecategory WHERE grade = 2 AND categoryId = 0 AND state = 0 ORDER BY sort ASC"; $_result3 = _query($_sql3); while ( $_rows3 = _fetch_array($_result3) ) { $_html3 = array(); $_html3['id'] = $_rows3['id']; $_html3['categoryName'] = $_rows3['categoryName']; $_html3 = _html($_html3); $_bigClass[] = $_html3; } //把大类信息放入大类下边打印出来 $_data['bigClass'] = $_bigClass; // $_info['data'] = $_data; } else { $_info['state'] = 1; $_info['info'] = '参数有误!'; } echo _json($_info); _free_result($_result2); _free_result($_result3); _close();?>
已下单的订单信息 和收获信息的判断
<?php//先判断订单是否存在直接打印出来 再查处订单号如果存在了查询订单下的商品信息 在同过商品查询商品名和图片//在去查找订单下的收货人信息 判断等于空时查找用户表的信息 负责直接打印出信息 require dirname(__FILE__).'/includes/common.inc.php'; $_clean = array(); $_clean['userId'] = 130; $_clean['orderNumber'] = AA175024180182d; $_info = array(); $_data = array(); if ( $_clean['userId'] > 0 && $_clean['orderNumber'] != '' ) { $_info['state'] = 0; $_info['info'] = ''; $_sql = "SELECT orderNumber FROM tb_easyGoodsOrder WHERE orderNumber = '{$_clean['orderNumber']}' LIMIT 1"; $_result = _query($_sql); $_rows = _fetch_array($_result); //查出订单号判断是否有该订单 把结果打印出来 if ( !!$_rows ) { $_data['orderNumber'] = $_rows['orderNumber']; $_data['state'] = 0; $_data['info'] = ''; } else { $_data['state'] = 1; $_data['info'] = '该订单不存在!'; $_info['data'] = $_data; echo _json($_info); die; } //查询出商品订单信息 $_sql1 = "SELECT goodsId,goodsModule,orderDate,goodsMoneyPrice,goodsIntegralPrice,orderBuyCount,goodsPostage FROM tb_easyGoodsOrder WHERE orderNumber = '{$_clean['orderNumber']}' AND orderStatus = 0"; $_result1 = _query($_sql1); $_rows1 = _fetch_array($_result1); $_data = array(); $_data['goodsType'] = $_rows1['goodsType']; $_data['goodsMoneyPrice'] = $_rows1['goodsMoneyPrice']; $_data['goodsIntegralPrice'] = $_rows1['goodsIntegralPrice']; $_data['goodsPostage'] = $_rows1['goodsPostage']; $_data['orderBuyCount'] = $_rows1['orderBuyCount']; $_data['orderDate'] = $_rows1['orderDate']; $_data['id'] = $_rows1['goodsId']; //通过上面查询出商品图品和名字 $_sql2 = "SELECT goodsName,goodsPicture FROM tb_easyGoods WHERE id = '{$_rows1['goodsId']}'"; $_result2 = _query($_sql2); $_rows2 = _fetch_array($_result2); $_data['title'] = $_rows2['goodsName']; $_data['pic'] = 'http://www.easyhunt.cn/' . $_rows2['goodsPicture']; $_data['totalPrice'] = $_data['goodsMoneyPrice'] * $_data['orderBuyCount']; //查询出收获人 电话 地址 等信息 $_sql = "SELECT deliveryName,deliveryAddress,deliveryPhone,deliveryCode FROM tb_easyGoodsOrder WHERE orderNumber = '{$_clean['orderNumber']}'"; $_result = _query($_sql); $_rows = _fetch_array($_result); //如果都为空就从tb_user里面查找出它们的信息 if ( $_rows['deliveryName'] == '' && $_rows['deliveryAddress'] == '' && $_rows['deliveryPhone'] == '' ) { $_sql1 = "SELECT province,theCity,county,address,phone,realName FROM tb_user WHERE id = '{$_clean['userId']}'"; $_result1 = _query($_sql1); $_rows1 = _fetch_array($_result1); $_sqlp = "SELECT areaName FROM tb_earea WHERE id = '{$_rows1['province']}'"; $_resultp = _query($_sqlp); $_rowsp = _fetch_array($_resultp); $_sqlt = "SELECT areaName FROM tb_earea WHERE id = '{$_rows1['theCity']}'"; $_resultt = _query($_sqlt); $_rowst = _fetch_array($_resultt); $_sqlc = "SELECT areaName FROM tb_earea WHERE id = '{$_rows1['county']}'"; $_resultc = _query($_sqlc); $_rowsc = _fetch_array($_resultc); //地址 = 。 。 。 。 。 。 。 $_data['deliveryAddress'] = $_rowsp['areaName'] . $_rowst['areaName'] . $_rowsc['areaName'] . $_rows1['address']; $_data['deliveryPhone'] = $_rows1['phone']; $_data['deliveryName'] = $_rows1['realName']; $_data['deliveryCode'] = ''; //否则它们部位空全部查询出 } elseif ( $_rows['deliveryName'] != '' && $_rows['deliveryAddress'] != '' && $_rows['deliveryPhone'] != '' ) { $_data['deliveryName'] = $_rows['deliveryName']; $_data['deliveryAddress'] = $_rows['deliveryAddress']; $_data['deliveryPhone'] = $_rows['deliveryPhone']; $_data['deliveryCode'] = $_rows['deliveryCode']; } //转义 $_data = _html($_data); $_info['data'] = $_data; } else { $_info['state'] = 1; $_info['info'] = '参数有误!'; } echo _json($_info); _free_result($_result); _free_result($_result1); _free_result($_result2); _close();?>
商品ID 商品数目 生成订单
<?php require dirname(__FILE__).'/includes/common.inc.php'; $_clean = array(); $_clean['userId'] = 130; $_clean['goodsId'] = 566656; $_clean['orderBuyCount'] = 2; $_order = array(); $_data = array(); $_now = date('Y-m-d H:i:s',time()); //如果都有值 if ( $_clean['userId'] != '' && $_clean['goodsId'] != '' && $_clean['orderBuyCount'] > 0 ) { $_order['state'] = 0; $_order['info'] = ''; $_sql = "SELECT * FROM tb_easyGoods WHERE state = 1 AND id = '{$_clean['goodsId']}'"; $_result = _query($_sql); $_rows = _fetch_array($_result); //!非 这个数据在这没有值也就是 通过上面的goodsId没有查到值 所有商品不存在 if (!$_rows) { _free_result($_result); $_data['state'] = 1; $_data['info'] = '该商品不存在!'; $_order['data'] = $_data; echo _json($_order); die; } else { //否则它有值查处库存 如果库存小于商品总数 //查处其他信息 $_html = array(); $_html['goodsInventory'] = $_rows['goodsInventory']; if ( $_html['goodsInventory'] > $_clean['orderBuyCount'] ) { $_html['company'] = $_rows['company']; if ( $_rows['goodsModule'] == 1 ) { $_html['goodsModule'] = "秒杀订单"; } elseif ( $_rows['goodsModule'] == 2 ) { $_html['goodsModule'] = "兑换订单"; } elseif ( $_rows['goodsModule'] == 3 ) { $_html['goodsModule'] = "特惠订单"; } $_html['title'] = $_rows['goodsName']; $_html['goodsMoneyPrice'] = $_rows['goodsMoneyPrice']; $_html['goodsIntegralPrice'] = $_rows['goodsIntegralPrice']; $_html['goodsPostage'] = $_rows['goodsPostage']; $_html['totalMoney'] = $_html['goodsMoneyPrice'] * $_clean['orderBuyCount'] + $_html['goodsPostage'] * $_clean['orderBuyCount']; $_html['totalIntegral'] = $_html['goodsIntegralPrice'] * $_clean['orderBuyCount']; $year_code = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z'); $_data['orderNumber'] = $year_code[intval(date('Y'))-2014].strtoupper(dechex(date('m'))).date('d').substr(time(),-5).substr(microtime(),2,5).sprintf('d',rand(0,99)); //生成订单号 mysql_query("BEGIN"); $flag=0; if ( $_html['totalIntegral'] > 0 ) { _query("INSERT INTO tb_easyGoodsOrder VALUES (null,'{$_rows['goodsModule']}','$_now','来自Android','{$_html['company']}','{$_clean['userId']}','{$_data['orderNumber']}','{$_clean['goodsId']}','{$_html['goodsMoneyPrice']}','{$_html['goodsIntegralPrice']}','{$_html['goodsPostage']}','{$_clean['orderBuyCount']}','{$_html['goodsModule']}','{$_html['totalMoney']}','{$_html['totalIntegral']}',0,'',0,'','','','','','')"); } else { _query("INSERT INTO tb_easyGoodsOrder VALUES (null,'{$_rows['goodsModule']}','$_now','来自Android','{$_html['company']}','{$_clean['userId']}','{$_data['orderNumber']}','{$_clean['goodsId']}','{$_html['goodsMoneyPrice']}','{$_html['goodsIntegralPrice']}','{$_html['goodsPostage']}','{$_clean['orderBuyCount']}','{$_html['goodsModule']}','{$_html['totalMoney']}','{$_html['totalIntegral']}',1,'',0,'','','','','','')"); } _query("UPDATE tb_easyGoods SET goodsInventory = goodsInventory - '{$_clean['orderBuyCount']}' WHERE id = '{$_clean['goodsId']}'"); $flag=1; if( $flag == 1 ){ mysql_query("COMMIT"); $_data['state'] = 0; $_data['info'] = '提交订单成功!'; }else{ mysql_query("ROLLBACK"); $_data['state'] = 2; $_data['info'] = '提交订单失败!'; } } else{ $_data['state'] = 3; $_data['info'] = '库存不足!'; $_order['data'] = $_data; echo _json($_order); die; } } $_order['data'] = $_data; } else { $_order['state'] = 1; $_order['info'] = '参数有误!'; } echo _json($_order); _free_result($_result); _close();?>
用户登录
<?php require dirname(__FILE__).'/includes/common.inc.php'; $_clean = array(); $_clean['userName'] = 8888888888; //这里应该是加密的密码 $_clean['userPwd'] = e10adc3949ba59abbe56e057f20f883e; $_now = date('Y-m-d H:i:s',time()); $_loginInfo = array(); if( $_clean['userName'] != '' && $_clean['userPwd'] != '' ){ $_loginInfo['state'] = 0; $_loginInfo['info'] = ''; $_data = array(); //查出积分和状态 $_sql = "SELECT id,state,identity FROM tb_user WHERE userName = '{$_clean['userName']}' AND userPwd = '{$_clean['userPwd']}' LIMIT 1"; $_result = _query($_sql); $_rows = _fetch_array($_result); if(!!$_rows){ $_html = array(); $_html['id'] = $_rows['id']; $_html['state'] = $_rows['state']; $_html['identity'] = $_rows['identity']; //如果状态为10 未激活 if ( $_html['state'] == 10 ) { $_data['id'] = $_html['id']; $_data['state'] = 10; //错误 未激活 $_data['info'] = '请提交交易密码'; //否则成功 }elseif( $_html['state'] == 0 ){ $_data['info'] = '登录成功'; $_data['state'] = 0; $_data['id'] = $_html['id']; $_data['identity'] = $_html['identity']; } }else{ $_data['state'] = 1; $_data['info'] = '登录失败,用户名或密码错误'; } $_loginInfo['data'] = $_data; }else{ $_loginInfo['state'] = 1; $_loginInfo['info'] = '参数有误'; } echo _json($_loginInfo); _free_result($_result); _close();?>
注册 提交问题 推荐人
<?php require dirname(__FILE__) . '/includes/common.inc.php'; $_clean = array(); $_clean['userName'] = _check($_POST['userName']); $_clean['userPwd'] = _check($_POST['userPwd']); $_clean['userEmail'] = _check($_POST['userEmail']); $_clean['referees'] = _check($_POST['referees']); $_regInfo = array(); $_data = array(); if ( $_clean['userName'] != '' && $_clean['userPwd'] != '' && $_clean['userEmail'] != '' ) { $_regInfo['state'] = 0; $_regInfo['info'] = ''; $_sql1 = "SELECT userName FROM tb_user WHERE userName = '{$_clean['userName']}' LIMIT 1"; $_result1 = _query($_sql1); $_rows1 = _fetch_array($_result1); if( $_rows1 ){ $_data['state'] = 2; $_data['info'] = '对不起,该用户名已注册!'; $_regInfo['data'] = $_data; echo _json($_regInfo); die; } $_now = date('y-m-d H:i:s',time()); if ( $_clean['referees'] == '' ) { $_sql = "INSERT INTO tb_user VALUES (null,'$_now','来自Android','{$_clean['userName']}','{$_clean['userEmail']}','{$_clean['userPwd']}','','','','','','','','','','',1000,1000,0,0,10,0,'',3)"; _query($_sql); } elseif ( $_clean['referees'] != '' ) { $_sql = "INSERT INTO tb_user VALUES (null,'$_now','来自Android','{$_clean['userName']}','{$_clean['userEmail']}','{$_clean['userPwd']}','','','','','','','','','','',1000,1000,0,0,10,0,'{$_clean['referees']}',3)"; _query($_sql); $_sql3 = "SELECT id FROM tb_user WHERE userName = '{$_clean['referees']}'"; $_result3 = _query($_sql3); $_rows3 = _fetch_array($_result3); $_sql5 = "UPDATE tb_user SET integral_easyhunt = integral_easyhunt + 2000 WHERE id = '{$_rows3['id']}'"; _query($_sql5); //推荐人易币增加记录 $_sql4 = "INSERT INTO tb_integralRecord VALUES (NULL,'{$_rows3['id']}','',4,2000,0,'$_now','来自Android')"; _query($_sql4); } if ( _affected_rows() == 1 ) { $_data['state'] = 0; $_data['info'] = '注册成功'; $_sql2 = "SELECT id FROM tb_user WHERE userName = '{$_clean['userName']}'"; $_result2 = _query($_sql2); $_rows2 = _fetch_array($_result2); $_data['id'] = $_rows2['id']; $_sql6 = "INSERT INTO tb_integralRecord VALUES (NULL,'{$_rows2['id']}','',3,2000,0,'$_now','来自Android')"; _query($_sql6); } else { _close(); $_data['state'] = 1; $_data['info'] = '注册失败'; } $_regInfo['data'] = $_data; } else { $_regInfo['state'] = 1; $_regInfo['info'] = '参数有误'; } echo _json($_regInfo);?><?php require dirname(__FILE__).'/includes/common.inc.php'; $_clean = array(); $_clean['userId'] = _check($_POST['userId']); $_clean['tradingPwd'] = _check($_POST['tradingPwd']); $_clean['encryptedQuestion'] = _check($_POST['encryptedQuestion']); $_clean['encryptedAnswer'] = _check($_POST['encryptedAnswer']); $_submitInfo = array(); $_data = array(); if( $_clean['userId'] != '' && $_clean['tradingPwd'] != '' && $_clean['encryptedQuestion'] != '' && $_clean['encryptedAnswer'] != '' ){ $_submitInfo['state'] = 0; $_submitInfo['info'] = ''; $_sql = "UPDATE tb_user SET tradingPwd = '{$_clean['tradingPwd']}', encryptedQuestion = '{$_clean['encryptedQuestion']}', encryptedAnswer = '{$_clean['encryptedAnswer']}', state = 0 WHERE id = '{$_clean['userId']}'"; _query($_sql); if( _affected_rows() == 1 ){ $_data['state'] = 0; $_data['info'] = '提交成功'; }else{ $_data['state'] = 1; $_data['info'] = '提交失败'; } $_submitInfo['data'] = $_data; }else{ $_submitInfo['state'] = 1; $_submitInfo['info'] = '参数有误'; } echo _json($_submitInfo); _close();?>
目录
<?php //目录 require dirname(__FILE__).'/includes/common.inc.php'; $_array = '[{"id":"1","logo":"http://android.wangzhanming.cn/images/dianjiuzhan/interactiveAdvertising.png","type":"","title":"广告互动","curl":"http://android.wangzhanming.cn/dianjiuzhan/advertisingList.php"}, {"id":"2","logo":"http://android.wangzhanming.cn/images/dianjiuzhan/activityParticipation.png","type":"","title":"促销活动","curl":"http://android.wangzhanming.cn/dianjiuzhan/advertisingList.php"}, {"id":"3","logo":"http://android.wangzhanming.cn/images/dianjiuzhan/promoteResearch.png","type":"","title":"宣传调研","curl":"http://android.wangzhanming.cn/dianjiuzhan/advertisingList.php"}, {"id":"4","logo":"http://android.wangzhanming.cn/images/dianjiuzhan/seckill.png","type":"","title":"疯狂秒杀","curl":"http://android.wangzhanming.cn/seckill/seckillList.php"}, {"id":"5","logo":"http://android.wangzhanming.cn/images/dianjiuzhan/storePromotion.png","type":"","title":"商家宣传","curl":"http://android.wangzhanming.cn/dianjiuzhan/advertisingList.php"}, {"id":"6","logo":"http://android.wangzhanming.cn/images/dianjiuzhan/viewAdvertisement.png","type":"","title":"每日抽奖","curl":"http://android.wangzhanming.cn/dianjiuzhan/viewAdvertisement/viewAdvertisementMain.php"} ]'; print_r($_array); ?>
搜索
<?php require dirname(__FILE__).'/includes/common.inc.php'; $_clean = array(); //类型 $_clean['type'] = _check($_POST['type']);//1.DH;2.MS;3.th //内容 $_clean['content'] = _check($_POST['content']); define('SCRIPT','research'); global $_pagesize,$_pagenum; $_productList = array(); if ( $_clean['type'] == '' && $_clean['type'] > 3 && $_clean['type'] < 0 ) { $_productList['state'] = 1; $_productList['info'] = '参数有误!'; //如果类型内容不等于空 }elseif ( $_clean['type'] != '' && $_clean['content'] != '' ) { //查找商品名 $_sql2 = "SELECT goodsName FROM tb_goods"; $_result2 = _query($_sql2); //循环 while($_rows2 = _fetch_array($_result2)){ $_html2 = array(); $_html2['goodsName'] = _html($_rows2['goodsName']); $_true = strpos($_html2['goodsName'],$_clean['content']); if ( !is_bool($_true) ) { $_goodsName = $_html2['goodsName']; $_sql = "SELECT goodsId FROM tb_goods WHERE goodsShow = 1 AND goodsModule = '{$_clean['type']}' AND goodsName = '$_goodsName' ORDER BY goodsId DESC"; _page($_sql,4); $_sql1 = "SELECT goodsId,goodsName,goodsPicture,goodsType,goodsOriginalPrice,goodsMoneyPrice,goodsDeliveryArea,goodsInventory FROM tb_goods WHERE goodsShow = 1 AND goodsModule = '{$_clean['type']}' AND goodsName = '$_goodsName' ORDER BY goodsId DESC LIMIT $_pagenum,$_pagesize"; _sprProduct($_sql1); } } $_productList['data'] = $_data; } echo _json($_productList); _free_result($_result1); _close();?>
提交评论
<?php require dirname(__FILE__).'/includes/common.inc.php'; $_clean = array(); $_clean['phone'] = _check($_POST['phone']); $_clean['title'] = _check($_POST['title']); $_clean['comments'] = _check($_POST['comments']); $_info = array(); $_data = array(); //电话不等于11 if ( $_clean['phone'] > 0 && strlen($_clean['phone']) != 11 && $_clean['title'] != '' && $_clean['comments'] != '' ) { $_info['state'] = 0; $_info['info'] = ''; $_sql = "INSERT INTO tb_submitComments ( phone, title, comments ) VALUES ( '{$_clean['phone']}', '{$_clean['title']}', '{$_clean['comments']}' )"; _query($_sql); if ( _affected_rows() == 1 ) { $_data['state'] = 0; $_data['info'] = '提交成功!'; } else { $_data['state'] = 1; $_data['info'] = '提交失败!'; } $_info['data'] = $_data; } else { $_info['state'] = 1; $_info['info'] = '参数有误!'; } echo _json($_info); _close();?>
点就赚评论
<?php require dirname(__FILE__).'/../includes/common.inc.php'; $_clean = array(); $_clean['userId'] = _check($_POST['userId']); $_clean['adId'] = _check($_POST['adId']); $_clean['content'] = _check($_POST['content']); $_now = date('y-m-d H:i:s',time()); $_info = array(); $_data = array(); // if ( $_clean['userId'] > 0 && $_clean['adId'] > 0 && $_clean['content'] != '' ) { $_info['state'] = 0; $_info['info'] = ''; $_sql1 = "SELECT userName FROM tb_user WHERE id = '{$_clean['userId']}'"; $_result1 = _query($_sql1); $_rows1 = _fetch_array($_result1); $_sql = "INSERT INTO tb_easyAdComments VALUES (null,'{$_clean['userId']}','{$_clean['adId']}','{$_clean['content']}',now(),'来自Android',0,0)"; _query($_sql); if ( _affected_rows() == 1 ) { $_data['state'] = 0; $_data['info'] = '评论成功'; $_data['addTimes'] = $_now; $_data['content'] = $_clean['content']; $_data['userName'] = $_rows1['userName']; } else { $_data['state'] = 1; $_data['info'] = '评论失败'; } $_info['data'] = $_data; } else { $_info['state'] = 1; $_info['info'] = '参数有误!'; } echo _json($_info); _close();?>
页面介绍 已界面显示出来的
<?php require dirname(__FILE__).'/includes/common.inc.php'; $_clean = array(); $_clean['adInfoId'] = 1; $_clean['screenWidth'] = 800; $_data = array(); ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><style type="text/css"> body{ font-size:16px; background:#fff;} dl{ width:<?php echo $_clean['screenWidth']?>px;} dl dd{ width:80%;} dl dd span.a1{ display:block; width:25%; float:left;} dl dd span.a2{ display:block; width:75%; float:left;}</style></head><body><div style="width:<?php echo $_clean['screenWidth']?>px"><?php $_sql = "SELECT brandService,perCapita,preferentialInfo,startDate,endDate,preferentialConditions,parkingEnvironment,theBusGuide,merchantIntroduce FROM tb_adInfo WHERE id = '{$_clean['adInfoId']}'"; $_result = _query($_sql); $_rows = _fetch_array($_result); $_data['brandService'] = $_rows['brandService']; $_data['perCapita'] = $_rows['perCapita']; $_data['preferentialInfo'] = $_rows['preferentialInfo']; $_data['startDate'] = $_rows['startDate']; $_data['endDate'] = $_rows['endDate']; $_data['preferentialConditions'] = $_rows['preferentialConditions']; $_data['parkingEnvironment'] = $_rows['parkingEnvironment']; $_data['theBusGuide'] = $_rows['theBusGuide']; $_data['merchantIntroduce'] = $_rows['merchantIntroduce']; ?> <dl> <dd><span class="a1">招牌服务:</span><span class="a2"><?php echo $_data['brandService']?></span></dd> <dd><span class="a1">人均消费:</span><span class="a2"><?php echo $_data['perCapita']?></span></dd> <dd><span class="a1">优惠信息:</span><span class="a2"><?php echo $_data['preferentialInfo']?></span></dd> <dd><span class="a1">起始日期:</span><span class="a2"><?php echo $_data['startDate']?>至<?php echo $_data['endDate']?></span></dd> <dd><span class="a1">优惠细则:</span><span class="a2"><?php echo $_data['preferentialConditions']?></span></dd> <dd><span class="a1">停车环境:</span><span class="a2"><?php echo $_data['parkingEnvironment']?></span></dd> <dd><span class="a1">公交指南:</span><span class="a2"><?php echo $_data['theBusGuide']?></span></dd> <dd><span class="a1">商户介绍:</span><span class="a2"><?php echo $_data['merchantIntroduce']?></span></dd> </dl> </div></body></html>
<?php require dirname(__FILE__).'/includes/common.inc.php'; $_clean = array(); $_clean['goodsId'] = 2; $_clean['screenWidth'] = 300; $_data = array(); ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><style type="text/css"> body{ font-size:16px; background:#fff;}</style></head><body><div style="width:<?php echo $_clean['screenWidth']?>px">风格豆腐干梵蒂冈<?php $_sql = "SELECT goodsDetails FROM tb_easyGoods WHERE id = '{$_clean['goodsId']}' AND state = 1"; $_result = _query($_sql); $_rows = _fetch_array($_result); $_data = array(); $_data['goodsDetails'] = $_rows['goodsDetails']; echo $_data['goodsDetails']; ?> </div></body></html>
判断是否已经验证 //注意: id是从验证记录里面取得值
<?php require dirname(__FILE__).'/includes/common.inc.php'; //判断商品判断验证为验证 $_clean = array(); $_clean['adInfoId'] = 1; $_clean['userId'] = 1; $_info = array(); $_data = array(); if ( $_clean['adInfoId'] > 0 ) { $_info['state'] = 0; $_info['info'] = ''; $_sql = "SELECT * FROM tb_adInfo WHERE id = '{$_clean['adInfoId']}'"; $_result = _query($_sql); $_rows = _fetch_array($_result); $_data['id'] = $_rows['id']; $_data['title'] = $_rows['merchantName']; $_data['pic'] = "http://www.easyhunt.cn/" . $_rows['merchantPic']; $_data['serviceTelephone'] = $_rows['serviceTelephone']; $_data['businessAddress'] = $_rows['businessAddress']; $_data['totalReward'] = $_rows['totalReward']; $_data['oneReward'] = $_rows['oneReward']; $_data['interval'] = $_rows['interval']; if ( $_clean['userId'] > 0 ) { $_sql1 = "SELECT * FROM tb_adInfoLog WHERE id = (SELECT id FROM tb_adInfoLog WHERE adInfoId = '{$_clean['adInfoId']}' AND userid = '{$_clean['userId']}' ORDER BY id DESC LIMIT 1) AND DATEDIFF(NOW(),addDates) < '{$_data['interval']}'"; $_result1 = _query($_sql1); $_row1 = _num_rows($_result1); if ( $_row1 > 0 ) { $_data['state'] = 1; $_data['info'] = '已验证!'; } else { $_data['state'] = 0; $_data['info'] = '未验证!'; } } elseif ( $_clean['userId'] == '' ) { $_data['state'] = 0; $_data['info'] = '未验证!'; } $_info['data'] = $_data; } else { $_info['state'] = 1; $_info['info'] = '参数有误!'; } echo _json($_info); _free_result($_result); _free_result($_result1); _close();?>
<?php require dirname(__FILE__).'/includes/common.inc.php'; //判断商品判断验证为验证 $_clean = array(); $_clean['adInfoId'] = 1; $_clean['userId'] = 1; $_info = array(); $_data = array(); if ( $_clean['adInfoId'] > 0 ) { $_info['state'] = 0; $_info['info'] = ''; $_sql = "SELECT * FROM tb_adInfo WHERE id = '{$_clean['adInfoId']}'"; $_result = _query($_sql); $_rows = _fetch_array($_result); $_data['id'] = $_rows['id']; $_data['title'] = $_rows['merchantName']; $_data['pic'] = "http://www.easyhunt.cn/" . $_rows['merchantPic']; $_data['serviceTelephone'] = $_rows['serviceTelephone']; $_data['businessAddress'] = $_rows['businessAddress']; $_data['totalReward'] = $_rows['totalReward']; $_data['oneReward'] = $_rows['oneReward']; $_data['interval'] = $_rows['interval']; if ( $_clean['userId'] > 0 ) { //DATEDIFF() 函数返回两个日期之间的天数。 $_sql1 = "SELECT * FROM tb_adInfoLog WHERE id = (SELECT id FROM tb_adInfoLog WHERE adInfoId = '{$_clean['adInfoId']}' AND userid = '{$_clean['userId']}' ORDER BY id DESC LIMIT 1) AND DATEDIFF(NOW(),addDates) < '{$_data['interval']}'";//函数返回两个日期之间的天数小于 浏览之间的天数 $_result1 = _query($_sql1); $_row1 = _num_rows($_result1); if ( $_row1 > 0 ) { $_data['state'] = 1; $_data['info'] = '已验证!'; } else { $_data['state'] = 0; $_data['info'] = '未验证!'; } } elseif ( $_clean['userId'] == '' ) { $_data['state'] = 0; $_data['info'] = '未验证!'; } $_info['data'] = $_data; } else { $_info['state'] = 1; $_info['info'] = '参数有误!'; } echo _json($_info); _free_result($_result); _free_result($_result1); _close();?>
通过地区 查找信息
<?php require dirname(__FILE__).'/../includes/common.inc.php'; //通过地区查找信息 define('SCRIPT','adInfo/djzList'); global $_pagesize,$_pagenum; $_clean = array(); $_clean['cityId'] = _check($_POST['cityId']); $_clean['countyId'] = _check($_POST['countyId']); $_clean['regionId'] = _check($_POST['regionId']); $_clean['bigClassId'] = _check($_POST['bigClassId']); $_clean['smallClassId'] = _check($_POST['smallClassId']); $_clean['advertisingType'] = _check($_POST['advertisingType']); $_list = array(); $_data = array(); if ( $_clean['countyId'] != '' ) { $_countyId = "AND countyId = '{$_clean['countyId']}'"; } if ( $_clean['regionId'] != '' ) { $_regionId = "AND regionId = '{$_clean['regionId']}'"; } if ( $_clean['bigClassId'] != '' ) { $_bigClassId = "AND bigClassId = '{$_clean['bigClassId']}'"; } if ( $_clean['smallClassId'] != '' ) { $_smallClassId = "AND smallClassId = '{$_clean['smallClassId']}'"; } if ( $_clean['advertisingType'] != '' ) { $_advertisingType = "AND advertisingType = '{$_clean['advertisingType']}'"; } if ( $_clean['cityId'] != '' ) { $_list['state'] = 0; $_list['info'] = ''; $_cityId = "AND cityId = '{$_clean['cityId']}'"; $_sql = "SELECT id FROM tb_adInfo WHERE adInfoType = 1 AND State = 1 {$_cityId} {$_countyId} {$_regionId} {$_bigClassId} {$_smallClassId} {$_advertisingType}"; _page($_sql,5); $_sql1 = "SELECT id,buyModule,buyGoodsId,thePrizeId,merchantName,merchantPic,totalReward,oneReward,advertisingType FROM tb_adInfo WHERE adInfoType = 1 AND State = 1 {$_cityId} {$_countyId} {$_regionId} {$_bigClassId} {$_smallClassId} {$_advertisingType} LIMIT $_pagenum,$_pagesize"; $_result1 = _query($_sql1); while($_rows1 = _fetch_array($_result1)) { $_html1 = array(); $_html1['id'] = $_rows1['id']; $_html1['buyModule'] = $_rows1['buyModule']; $_html1['buyGoodsId'] = $_rows1['buyGoodsId']; $_html1['thePrizeId'] = $_rows1['thePrizeId']; $_html1['title'] = $_rows1['merchantName']; $_html1['pic'] = "http://www.easyhunt.cn/" . $_rows1['merchantPic']; $_html1['totalReward'] = $_rows1['totalReward']; $_html1['oneReward'] = $_rows1['oneReward']; $_html1['advertisingType'] = $_rows1['advertisingType']; $_html1 = _html($_html1); $_data[] = $_html1; } $_list['data'] = $_data; } else { $_list['state'] = 1; $_list['info'] = '参数有误!'; } echo _json($_list); _free_result($_result1); _close();?>
<?php require dirname(__FILE__).'/../includes/common.inc.php'; define('SCRIPT','ljz/ljzList'); global $_pagesize,$_pagenum; $_clean = array(); $_clean['cityId'] = _check($_POST['cityId']); $_clean['countyId'] = _check($_POST['countyId']); $_clean['regionId'] = _check($_POST['regionId']); $_clean['bigClassId'] = _check($_POST['bigClassId']); $_clean['smallClassId'] = _check($_POST['smallClassId']); $_clean['advertisingType'] = _check($_POST['advertisingType']); $_list = array(); $_data = array(); if ( $_clean['countyId'] != '' ) { $_countyId = "AND countyId = '{$_clean['countyId']}'"; } if ( $_clean['regionId'] != '' ) { $_regionId = "AND regionId = '{$_clean['regionId']}'"; } if ( $_clean['bigClassId'] != '' ) { $_bigClassId = "AND bigClassId = '{$_clean['bigClassId']}'"; } if ( $_clean['cityId'] != '' ) { $_smallClassId = "AND smallClassId = '{$_clean['smallClassId']}'"; } if ( $_clean['advertisingType'] != '' ) { $_advertisingType = "AND advertisingType = '{$_clean['advertisingType']}'"; } //如果城市不等空 if ( $_clean['cityId'] != '' ) { $_list['state'] = 0; $_list['info'] = ''; $_cityId = "AND cityId = '{$_clean['cityId']}'"; $_sql = "SELECT id FROM tb_adInfo WHERE adInfoType = 2 AND State = 1 {$_cityId} {$_countyId} {$_regionId} {$_bigClassId} {$_smallClassId} {$_advertisingType}"; _page($_sql,5); $_sql1 = "SELECT id,buyModule,buyGoodsId,thePrizeId,merchantName,merchantPic,totalReward,oneReward,advertisingType FROM tb_adInfo WHERE adInfoType = 2 AND State = 1 {$_cityId} {$_countyId} {$_regionId} {$_bigClassId} {$_smallClassId} {$_advertisingType} LIMIT $_pagenum,$_pagesize"; $_result1 = _query($_sql1); while($_rows1 = _fetch_array($_result1)) { $_html1 = array(); $_html1['id'] = $_rows1['id']; $_html1['buyModule'] = $_rows1['buyModule']; $_html1['buyGoodsId'] = $_rows1['buyGoodsId']; $_html1['thePrizeId'] = $_rows1['thePrizeId']; $_html1['title'] = $_rows1['merchantName']; $_html1['pic'] = "http://www.easyhunt.cn/" . $_rows1['merchantPic']; $_html1['totalReward'] = $_rows1['totalReward']; $_html1['oneReward'] = $_rows1['oneReward']; $_html1['advertisingType'] = $_rows1['advertisingType']; $_html1 = _html($_html1); $_data[] = $_html1; } $_list['data'] = $_data; } else { $_list['state'] = 1; $_list['info'] = '参数有误!'; } echo _json($_list); _free_result($_result1); _close();?>
点就赚信息 在线和现场
<?php require dirname(__FILE__).'/includes/common.inc.php'; define('SCRIPT','choujiang/prizeList'); global $_pagesize,$_pagenum; //抽奖方式 抽奖信息 $_clean = array(); $_clean['Lottery'] = 2; $_list = array(); $_data = array(); $_list['state'] = 0; $_list['info'] = ''; if ( $_clean['Lottery'] == 1 ) { $_sql1 = "SELECT id FROM tb_thePrize WHERE Lottery = '{$_clean['Lottery']}' AND State = 1"; _page($_sql1,5); $_sql = "SELECT id,company,thePrizeName,thePrizePic,disIntroduct,totalReward,thePrizeChangeOf,useIntegral FROM tb_thePrize WHERE Lottery = '{$_clean['Lottery']}' AND State = 1 LIMIT $_pagenum,$_pagesize"; $_result = _query($_sql); while ( $_rows = _fetch_array($_result) ) { $_html = array(); $_html['id'] = $_rows['id']; $_html['company'] = $_rows['company']; $_html['title'] = $_rows['thePrizeName']; $_html['pic'] = 'http://www.easyhunt.cn/' . $_rows['thePrizePic']; $_html['disIntroduct'] = $_rows['disIntroduct']; $_html['totalReward'] = $_rows['totalReward']; $_html['thePrizeChangeOf'] = $_rows['thePrizeChangeOf']; if ( $_html["company"] == 0 ) { $_html['useIntegral'] = $_rows["useIntegral"]; } elseif ( $_html["company"]>0 ) { $_html['useIntegral'] = "阅读奖品提供商广告"; } $_html = _html($_html); $_data[] = $_html; } } elseif ( $_clean['Lottery'] == 2 ) { $_sql1 = "SELECT id FROM tb_thePrize WHERE Lottery = '{$_clean['Lottery']}' AND State = 1"; _page($_sql1,5); $_sql = "SELECT id,company,thePrizeName,thePrizePic,totalReward,thePrizeChangeOf,useIntegral FROM tb_thePrize WHERE Lottery = '{$_clean['Lottery']}' AND State = 1 LIMIT $_pagenum,$_pagesize"; $_result = _query($_sql); while ( $_rows = _fetch_array($_result) ) { $_html = array(); $_html['id'] = $_rows['id']; $_html['company'] = $_rows['company']; $_html['title'] = $_rows['thePrizeName']; $_html['pic'] = 'http://www.easyhunt.cn/' . $_rows['thePrizePic']; $_html['totalReward'] = $_rows['totalReward']; $_html['thePrizeChangeOf'] = $_rows['thePrizeChangeOf']; if ( $_html["company"] == 0 ) { $_html['useIntegral'] = $_rows["useIntegral"]; } elseif ( $_html["company"]>0 ) { $_html['useIntegral'] = "阅读奖品提供商广告"; } $_html = _html($_html); $_data[] = $_html; } } elseif ( $_clean['Lottery'] == '' ) { $_sql1 = "SELECT id FROM tb_thePrize WHERE State = 1"; _page($_sql1,5); $_sql = "SELECT id,company,thePrizeName,thePrizePic,totalReward,thePrizeChangeOf,useIntegral FROM tb_thePrize WHERE State = 1 LIMIT $_pagenum,$_pagesize"; $_result = _query($_sql); while ( $_rows = _fetch_array($_result) ) { $_html = array(); $_html['id'] = $_rows['id']; $_html['company'] = $_rows['company']; $_html['title'] = $_rows['thePrizeName']; $_html['pic'] = 'http://www.easyhunt.cn/' . $_rows['thePrizePic']; $_html['totalReward'] = $_rows['totalReward']; $_html['thePrizeChangeOf'] = $_rows['thePrizeChangeOf']; if ( $_html["company"] == 0 ) { $_html['useIntegral'] = $_rows["useIntegral"]; } elseif ( $_html["company"]>0 ) { $_html['useIntegral'] = "阅读奖品提供商广告"; } $_html = _html($_html); $_data[] = $_html; } } $_list['data'] = $_data; echo _json($_list); _free_result($_result); _close(); ?>
商品类别判断和信息
<?php require dirname(__FILE__).'/includes/common.inc.php'; $_clean = array(); $_clean['goodsId'] = 2; $_info = array(); $_data = array(); if ( $_clean['goodsId'] > 0 ) { $_info['state'] = 0; $_info['info'] = ''; $_sql = "SELECT id,goodsPicture,goodsName,methods,goodsModule,goodsDeliveryArea,goodsOriginalPrice,goodsMoneyPrice,goodsIntegralPrice,goodsPostage,goodsInventory FROM tb_easyGoods WHERE id = '{$_clean['goodsId']}' AND state = 1"; $_result = _query($_sql); $_rows = _fetch_array($_result); $_data['id'] = $_rows['id']; $_data['title'] = $_rows['goodsName']; $_data['pic'] = 'http://www.easyhunt.cn/' . $_rows['goodsPicture']; $_data['goodsDeliveryArea'] = $_rows['goodsDeliveryArea']; if ( $_rows['goodsModule'] == 1 ) { switch ( $_rows['methods'] ) { case 1: $_data['methods'] = '在线秒杀'; break; case 2: $_data['methods'] = '现场秒杀'; break; } } elseif ( $_rows['goodsModule'] == 2 ) { switch ( $_rows['methods'] ) { case 1: $_data['methods'] = '在线兑换'; break; case 2: $_data['methods'] = '现场兑换'; break; } } elseif ( $_rows['goodsModule'] == 3 ) { switch ( $_rows['methods'] ) { case 1: $_data['methods'] = '在线抢特惠'; break; case 2: $_data['methods'] = '现场抢特惠'; break; } } $_data['goodsOriginalPrice'] = $_rows['goodsOriginalPrice']; $_data['goodsMoneyPrice'] = $_rows['goodsMoneyPrice']; $_data['goodsIntegralPrice'] = $_rows['goodsIntegralPrice']; $_data['goodsPostage'] = $_rows['goodsPostage']; $_data['goodsInventory'] = $_rows['goodsInventory']; $_info['data'] = $_data; } else { $_info['state'] = 1; $_info['info'] = '参数有误!'; } echo _json($_info); _free_result($_info); _close();?>
//通过方法 大类 小类 城市区域 类别帅选商品
<?php require dirname(__FILE__).'/includes/common.inc.php'; define('SCRIPT','product/list');//通过方法 大类 小类 城市区域 类别帅选商品 global $_pagesize,$_pagenum; $_clean = array(); $_clean['methods'] = 1; $_clean['bigClassId'] = ''; $_clean['cityId'] = 2; $_clean['countyId'] = ''; $_clean['regionId'] = ''; $_clean['smallClassId'] = ''; $_clean['goodsModule'] = 1; //1.秒杀,2.兑换,3.特惠 //如果城市id等于空或 -2全部id if ( $_clean['countyId'] != '' && $_clean['countyId'] != '-2' ) { $_countyId = "AND countyId = '{$_clean['countyId']}'"; } elseif ( $_clean['countyId'] == '-2' && $_clean['countyId'] == '' ) { $_countyId = ''; } if ( $_clean['regionId'] != '' ) { $_regionId = "AND regionId = '{$_clean['regionId']}'"; } elseif ( $_clean['regionId'] == '' ) { $_regionId = ''; } if ( $_clean['bigClassId'] != '' && $_clean['bigClassId'] != '-2' ) { $_bigClassId = "AND bigClassId = '{$_clean['bigClassId']}'"; } elseif ( $_clean['bigClassId'] == '-2' && $_clean['bigClassId'] == '' ) { $_bigClassId = ''; } if ( $_clean['smallClassId'] != '' ) { $_smallClassId = "AND smallClassId = '{$_clean['smallClassId']}'"; } elseif ( $_clean['smallClassId'] == '' ) { $_smallClassId = ''; } if ( $_clean['methods'] == '' ) { $_methods = ""; } elseif ( $_clean['methods'] != '' ) { $_methods = "AND methods = '{$_clean['methods']}'"; } $_seckillList = array(); $_data = array(); if ( $_clean['cityId'] > 0 && $_clean['goodsModule'] > 0 ) { $_seckillList['state'] = 0; $_seckillList['info'] = ''; $_cityId = "AND cityId = '{$_clean['cityId']}'"; $_sql1 = "SELECT id FROM tb_easyGoods WHERE goodsModule = '{$_clean['goodsModule']}' AND state = 1 {$_methods} {$_cityId} {$_countyId} {$_regionId} {$_bigClassId} {$_smallClassId}"; _page($_sql1,5); if ( $_clean['goodsModule'] == 1 ) { $_sql = "SELECT id,goodsName,goodsPicture,goodsMoneyPrice,beginTime,endTime FROM tb_easyGoods WHERE goodsModule = '{$_clean['goodsModule']}' AND state = 1 {$_methods} {$_cityId} {$_countyId} {$_regionId} {$_bigClassId} {$_smallClassId}"; $_result = _query($_sql); while ( $_rows = _fetch_array($_result) ) { $_html = array(); $_html['id'] = $_rows['id']; $_html['title'] = $_rows['goodsName']; $_html['pic'] = 'http://www.easyhunt.cn/' . $_rows['goodsPicture']; $_html['goodsMoneyPrice'] = $_rows['goodsMoneyPrice']; $_html['beginTime'] = $_rows['beginTime']; $_html['endTime'] = $_rows['endTime']; $_html = _html($_html); $_data[] = $_html; } } else { $_sql = "SELECT id,goodsName,goodsPicture,goodsMoneyPrice FROM tb_easyGoods WHERE goodsModule = '{$_clean['goodsModule']}' AND state = 1 {$_methods} {$_cityId} {$_countyId} {$_regionId} {$_bigClassId} {$_smallClassId}"; $_result = _query($_sql); while ( $_rows = _fetch_array($_result) ) { $_html = array(); $_html['id'] = $_rows['id']; $_html['title'] = $_rows['goodsName']; $_html['pic'] = 'http://www.easyhunt.cn/' . $_rows['goodsPicture']; $_html['goodsMoneyPrice'] = $_rows['goodsMoneyPrice']; $_html = _html($_html); $_data[] = $_html; } } $_seckillList['data'] = $_data; } else { $_seckillList['state'] = 1; $_seckillList['info'] = '参数有误!'; } echo _json($_seckillList); _free_result($_result); _close();?>
秒杀时间判断同时打印出信息
<?php require dirname(__FILE__).'/includes/common.inc.php'; $_clean = array(); $_clean['goodsId'] = 3; $_seckillDetail = array(); $_data = array(); if ( $_clean['goodsId'] != '' ) { $_seckillDetail['state'] = 0; $_seckillDetail['info'] = ''; $_now = date('H:i:s',time()); //在这个时间段秒杀 if ( $_now >= '12:00:00' && $_now <= '13:00:00' ) { $_data['state'] = 0; $_data['info'] = '正在秒杀中'; } elseif ( $_now < '12:00:00' ) { $_data['state'] = 1; $_data['info'] = '秒杀时间未到'; } elseif ( $_now > '13:00:00' ) { $_data['state'] = 2; $_data['info'] = '秒杀时间已过'; } $_sql = "SELECT id,goodsName,goodsPicture,goodsOriginalPrice,goodsMoneyPrice,goodsIntegralPrice,goodsPostage,goodsInventory,goodsDeliveryArea,goodsDetails FROM tb_easyGoods WHERE id = '{$_clean['goodsId']}'"; $_result = _query($_sql); $_rows = _fetch_array($_result); $_data['goodsId'] = $_rows['goodsId']; $_data['pic'] = 'http://www.easyhunt.cn/' . $_rows['goodsPicture']; $_data['title'] = $_rows['goodsName']; $_data['goodsOriginalPrice'] = $_rows['goodsOriginalPrice']; $_data['goodsMoneyPrice'] = $_rows['goodsMoneyPrice']; $_data['goodsIntegralPrice'] = $_rows['goodsIntegralPrice']; $_data['goodsPostage'] = $_rows['goodsPostage']; $_data['goodsDeliveryArea'] = $_rows['goodsDeliveryArea']; $_data['goodsInventory'] = $_rows['goodsInventory']; $_data['url'] = "http://www.easyhunt.cn/android/seckill/seckillDetail1.php"; $_data = _html($_data); $_seckillDetail['data'] = $_data; } else { $_seckillDetail['state'] = 1; $_seckillDetail['info'] = '参数有误'; } echo _json($_seckillDetail); _free_result($_result); _close();?>
修改个人信息
<?php require dirname(__FILE__).'/../includes/common.inc.php'; $_clean = array(); $_clean['userId'] = _check($_POST['userId']); $_clean['realName'] = _check($_POST['realName']); $_clean['address'] = _check($_POST['address']); $_clean['qq'] = _check($_POST['qq']); $_clean['province'] = _check($_POST['province']); $_clean['theCity'] = _check($_POST['theCity']); $_clean['county'] = _check($_POST['county']); $_clean['Email'] = _check($_POST['Email']); $_clean['phone'] = _check($_POST['phone']); $_detailUserInfo = array(); $_data = array(); if( $_clean['userId'] != '' ){ $_detailUserInfo['state'] = 0; $_detailUserInfo['info'] = ''; //弱国都为空 查出信息 if( $_clean['realName'] == '' && $_clean['address'] == '' && $_clean['qq'] == '' && $_clean['province'] == '' && $_clean['theCity'] == '' && $_clean['county'] == '' && $_clean['Email'] == '' && $_clean['phone'] == '' ) { $_sql = "SELECT realName,address,qq,province,theCity,county,Email,phone FROM tb_user WHERE id = '{$_clean['userId']}'"; $_result = _query($_sql); $_rows = _fetch_array($_result); $_data = array(); $_data['realName'] = $_rows['realName']; $_data['address'] = $_rows['address']; $_data['qq'] = $_rows['qq']; $_data['province'] = $_rows['province']; $_data['theCity'] = $_rows['theCity']; $_data['county'] = $_rows['county']; $_data['Email'] = $_rows['Email']; $_data['phone'] = $_rows['phone']; $_data = _html($_data); //如果都不为空 更新数据 } elseif ( $_clean['realName'] != '' && $_clean['address'] != '' && $_clean['qq'] != '' && $_clean['province'] != '' && $_clean['theCity'] != '' && $_clean['county'] != '' && $_clean['Email'] != '' && $_clean['phone'] != '' ) { $_sql = "UPDATE tb_user SET realName = '{$_clean['realName']}', province = '{$_clean['province']}', theCity = '{$_clean['theCity']}', county = '{$_clean['county']}', address = '{$_clean['address']}', qq = '{$_clean['qq']}', Email = '{$_clean['Email']}', phone = '{$_clean['phone']}' WHERE id = '{$_clean['userId']}'"; _query($_sql); if( _affected_rows() == 1 ) { $_data['state'] = 0; $_data['info'] = '个人信息提交成功!'; } else { $_data['state'] = 1; $_data['info'] = '个人信息提交失败!'; } } else { $_detailUserInfo['state'] = 2; $_detailUserInfo['info'] = '需要提交的参数不全!'; } }else{ $_detailUserInfo['state'] = 1; $_detailUserInfo['info'] = '会员ID参数有误!'; } $_detailUserInfo['data'] = $_data; echo _json($_detailUserInfo); _free_result($_result); _close(); ?>
查询用户信息和 其他订单的一点信息
<?php require dirname(__FILE__).'/includes/common.inc.php'; $_clean = array(); $_clean['userId'] = 146; $_userInfo = array(); $_data = array(); if ( $_clean['userId'] != '' ) { $_userInfo['state'] = 0; $_userInfo['info'] = ''; $_sql = "SELECT userName,realName,identity,userEmail,integral_easyhunt,cash_easyhunt,address,phone FROM tb_user WHERE id = '{$_clean[userId]}'"; $_result = _query($_sql); $_rows = _fetch_array($_result); $_data['userName'] = $_rows['userName']; $_data['realName'] = $_rows['realName']; $_data['userEmail'] = $_rows['userEmail']; $_data['integral_easyhunt'] = $_rows['integral_easyhunt']; $_data['cash_easyhunt'] = $_rows['cash_easyhunt']; $_data['address'] = $_rows['address']; $_data['phone'] = $_rows['phone']; switch($_rows['identity']){ case 1: $_data['identity'] = '个人会员'; break; case 2: $_data['identity'] = '企业会员'; break; } //未领奖数目 $_sql2 = "SELECT * FROM tb_thePrizeLog WHERE userid = '{$_clean['userId']}' AND category = 1"; $_result2 = _query($_sql2); $_row2 = _num_rows($_result2); $_data['num1'] = $_row2; //未领奖订单数目 $_sql3 = "SELECT * FROM tb_easyGoodsOrder WHERE userid = '{$_clean['userId']}' AND orderStatus = 0 AND goodsModule IN (1,2,3)"; $_result3 = _query($_sql3); $_row3 = _num_rows($_result3); $_data['num2'] = $_row3; $_data = _html($_data); $_userInfo['data'] = $_data; }else { $_userInfo['state'] = 1; $_userInfo['info'] = '参数有误'; } echo _json($_userInfo); _free_result($_result); _close();?>
查询所有省市区
<?php require dirname(__FILE__).'/includes/common.inc.php'; $_area = array(); $_data = array(); $_sql = "SELECT id,areaId,areaName,areaType FROM tb_area WHERE areaType IN (1,2,3) AND state = 0 ORDER BY sort ASC"; $_result = _query($_sql); while( $_rows = _fetch_array($_result) ) { $_html = array(); $_html['id'] = $_rows['id']; $_html['areaId'] = $_rows['areaId']; $_html['areaName'] = $_rows['areaName']; $_html['areaType'] = $_rows['areaType']; $_html = _html($_html); $_data[] = $_html; } $_area['state'] = 0; $_area['info'] = ''; $_area['data'] = $_data; echo _json($_area); _free_result($_result); _close();?>
查出所有订单信息 和商品名
<?php require dirname(__FILE__).'/../includes/common.inc.php'; $_clean = array(); $_clean['userId'] = _check($_POST['userId']); global $_pagesize,$_pagenum; _page("SELECT id FROM tb_easyGoodsOrder WHERE userId = '{$_clean['userId']}' AND orderStatus = 0",5); $_order = array(); $_data = array(); if ( $_clean['userId'] != '' ) { $_order['state'] = 0; $_order['info'] = ''; $_sql = "SELECT * FROM tb_easyGoodsOrder WHERE userId = '{$_clean['userId']}' AND orderStatus = 0 LIMIT $_pagenum,$_pagesize"; $_result = _query($_sql); while( $_rows = _fetch_array($_result) ) { $_html = array(); $_html['goodsId'] = $_rows['goodsId']; $_html['orderDate'] = $_rows['orderDate']; $_html['orderPayIntegral'] = $_rows['orderPayIntegral']; $_html['orderNumber'] = $_rows['orderNumber']; $_html['orderPayMoney'] = $_rows['orderPayMoney']; $_html = _html($_html); $_sql1 = "SELECT * FROM tb_easyGoodsOrder WHERE id = '{$_html['goodsId']}'"; $_result1 = _query($_sql1); $_rows1 = _fetch_array($_result1); $_html['title'] = $_rows1['goodsName']; $_html['pic'] = 'http://www.easyhunt.cn/' . $_rows1['goodsPicture']; $_data[] = $_html; } $_order['data'] = $_data; } else { $_order['state'] = 1; $_order['info'] = '参数有误!'; } echo _json($_order); _free_result($_result); _close();?>
删除订单
<?php require dirname(__FILE__).'/../includes/common.inc.php'; $_clean = array(); $_clean['userId'] = _check($_POST['userId']); $_clean['orderNumber'] = _check($_POST['orderNumber']); $_info = array(); $_data = array(); if ( $_clean['userId'] != '' && $_clean['orderNumber'] != '' ) { $_info['state'] = 0; $_info['info'] = ''; $_sql = "DELETE FROM tb_easyGoodsOrder WHERE orderNumber = '{$_clean['orderNumber']}' AND userId = '{$_clean['userId']}'"; _query($_sql); if ( _affected_rows() == 1 ) { $_data['state'] = 0; $_data['info'] = '删除成功!'; } else { $_data['state'] = 1; $_data['info'] = '删除失败!'; } $_info['data'] = $_data; } else { $_info['state'] = 1; $_info['info'] = '参数有误!'; } echo _json($_info); _close(); ?>
领奖品成功 查找奖品 中奖记录
<?php require dirname(__FILE__).'/../includes/common.inc.php'; $_clean = array(); $_clean['userId'] = _check($_POST['userId']); $_clean['winId'] = _check($_POST['winId']); /*$_clean['userId'] = 1052; $_clean['winId'] = 11;*/ $_winning = array(); $_data = array(); if ( $_clean['userId'] != '' && $_clean['winId'] != '' ) { $_winning['state'] = 0; $_winning['info'] = ''; $_sql = "SELECT thePrizeName FROM tb_thePrize WHERE id = '{$_clean['winId']}'"; $_result = _query($_sql); $_rows = _fetch_array($_result); //中奖记录 $_sql1 = "SELECT State FROM tb_winnRecord WHERE userid = '{$_clean['userId']}' AND thePrizeName = '{$_rows['thePrizeName']}'"; $_result1 = _query($_sql1); $_rows1 = _fetch_array($_result1); if ( $_rows1['State'] == 0 ){ $_sql2 = "UPDATE tb_winnRecord SET State = 1 WHERE userid = '{$_clean['userId']}' AND thePrizeName = '{$_rows['thePrizeName']}'"; _query($_sql2); if ( _affected_rows() == 1 ) { $_data['state'] = 0; $_data['info'] = '领奖成功!'; }else{ $_data['state'] = 1; $_data['info'] = '领奖失败!'; } } $_winning['data'] = $_data; } else { $_winning['state'] = 1; $_winning['info'] = '参数有误!'; } echo _json($_winning); _free_result($_result); _free_result($_result1); _close();?>
账户金额兑换易币
<?php require dirname(__FILE__).'/../includes/common.inc.php'; $_clean = array(); $_clean['userId'] = _check($_POST['userId']); $_clean['yibi'] = _check($_POST['yibi']); /*$_clean['userId'] = 1052; $_clean['yibi'] = 100;*/ $_info = array(); $_data = array(); $_now = date('Y-m-d H:i:s',time()); if ( $_clean['userId'] != '' && $_clean['yibi'] != '' ) { $_info['state'] = 0; $_info['info'] = ''; //账户金额 和易币 $_sql = "SELECT totalSyJf,Cash FROM tb_user WHERE id = '{$_clean['userId']}'"; $_result = _query($_sql); $_rows = _fetch_array($_result); $_html = array(); $_html['totalSyJf'] = $_rows['totalSyJf']; $_html['Cash'] = $_rows['Cash']; $_html = _html($_html); //易币等账户金额*10 $_totalSyJf = $_html['Cash'] * 10; //如果穿过来的易币数大于剩余的金额 就不能转换 if( $_clean['yibi'] > $_totalSyJf ){ $_data['state'] = 1; $_data['info'] = '填写的易币数过多'; $_info['data'] = $_data; echo _json($_info); die; //否则传过来的易币小于账户的 继续进行 }elseif( $_clean['yibi'] <= $_html['totalSyJf'] && $_clean['yibi'] > 0 ){ //易币等自己剩余的加上传过来的 $_html['totalSyJf'] = $_html['totalSyJf'] + $_clean['yibi']; //插入兑换记录 $_sql1 = "INSERT INTO tb_eblog ( userid, ebtime, ebIp, ebway, ebcount, ebflag ) VALUES ( '{$_clean['userId']}', '$_now', '来自Android', '易币兑换', '{$_clean['yibi']}', 1 )"; _query($_sql1); //z账户金额等于 传过来的易币除以10 $_cashAdd = $_clean['yibi'] / 10; //账户等商户减去穿过的值 $_html['Cash'] = $_html['Cash'] - $_cashAdd; //插入账户记录 $_sql2 = "INSERT INTO tb_cashlog ( userid, cashtime, cashIp, cashway, cashCount, cashflag ) VALUES ( '{$_clean['userId']}', '$_now', '来自Android', '易币兑换', '$_cashAdd', 0 )"; _query($_sql2); //更新用户账户 $_sql3 = "UPDATE tb_user SET totalSyJf = '{$_html['totalSyJf']}', Cash = '{$_html['Cash']}' WHERE id = '{$_clean['userId']}'"; _query($_sql3); if( _affected_rows() == 1 ){ $_data['state'] = 0; $_data['info'] = '兑换成功!'; }else{ $_data['state'] = 1; $_data['info'] = '兑换失败!'; } } $_info['data'] = $_data; } else { $_info['state'] = 1; $_info['info'] = '参数有误!'; } echo _json($_info); _free_result($_result); _close();?>
查询中奖信息 按照类别
<?php require dirname(__FILE__).'/../includes/common.inc.php'; //中奖信息 类型 define('SCRIPT','userCenter/userInfo_winning'); global $_pagesize,$_pagenum; $_clean = array(); $_clean['userId'] = _check($_POST['userId']); $_clean['thePrizeType'] = _check($_POST['thePrizeType']); /*$_clean['userId'] = 1052; $_clean['thePrizeType'] = '1';*/ $_winning = array(); if ( $_clean['userId'] > 0 ) { $_winning['state'] = 0; $_winning['info'] = ''; if ( $_clean['thePrizeType'] == '' ) { $_sql1 = "SELECT id FROM tb_winnRecord WHERE userid = '{$_clean['userId']}'"; _page($_sql1,5); $_sql = "SELECT id,addDates,thePrizeName,State FROM tb_winnRecord WHERE userid = '{$_clean['userId']}' ORDER BY state ASC LIMIT $_pagenum,$_pagesize"; _winning($_sql); } elseif ( $_clean['thePrizeType'] == 1 ) { $_sql1 = "SELECT id FROM tb_winnRecord WHERE userid = '{$_clean['userId']}' AND thePrizeType = 1"; _page($_sql1,5); $_sql = "SELECT id,addDates,thePrizeName,State FROM tb_winnRecord WHERE userid = '{$_clean['userId']}' AND thePrizeType = 1 ORDER BY state ASC LIMIT $_pagenum,$_pagesize"; _winning($_sql); } elseif ( $_clean['thePrizeType'] == 2 ) { $_sql1 = "SELECT id FROM tb_winnRecord WHERE userid = '{$_clean['userId']}' AND thePrizeType = 2"; _page($_sql1,5); $_sql = "SELECT id,addDates,thePrizeName,State FROM tb_winnRecord WHERE userid = '{$_clean['userId']}' AND thePrizeType = 2 ORDER BY state ASC LIMIT $_pagenum,$_pagesize"; _winning($_sql); } elseif ( $_clean['thePrizeType'] == 3 ) { $_sql1 = "SELECT id FROM tb_winnRecord WHERE userid = '{$_clean['userId']}' AND thePrizeType = 3"; _page($_sql1,5); $_sql = "SELECT id,addDates,thePrizeName,State FROM tb_winnRecord WHERE userid = '{$_clean['userId']}' AND thePrizeType = 3 ORDER BY state ASC LIMIT $_pagenum,$_pagesize"; _winning($_sql); } $_winning['data'] = $_data; } else { $_winning['state'] = 1; $_winning['info'] = '请输入会员ID'; } echo _json($_winning); _free_result($_result); _close();?>
用户图像上传
<?php require dirname(__FILE__).'/includes/common.inc.php'; $_clean = array(); $_clean['userId'] = 146; $_info = array(); $_data = array(); if ( $_clean['userId'] != '' ) { $_info['state'] = 0; $_info['info'] = ''; mkdir("D:\www\web\php_easyhunt\userimage" . '/'. $_clean['userId'], 0700); $target_path = "D:\www\web\php_easyhunt\userimage" . '/' . $_clean['userId'] . "/";//接收文件目录 $target_path = $target_path . basename( $_FILES['userimage']['name']); if(move_uploaded_file($_FILES['userimage']['tmp_name'], $target_path)) { $_data['state'] = 0; $_data['info'] = '上传成功'; } else{ $_data['state'] = 1; $_date['info'] = '上传失败'; } $_sql = "SELECT Userimage FROM tb_user WHERE id = '{$_clean['userId']}'"; $_result = _query($_sql); $_rows = _fetch_array($_result); unlink("D:\www\web\php_easyhunt" . '/' . $_rows['Userimage'] ); $_picture1 = "userimage/" . $_clean['userId'] . '/' . basename( $_FILES['userimage']['name']); $_sql1 = "UPDATE tb_user SET Userimage = '$_picture1' WHERE id = '{$_clean['userId']}'"; _query($_sql1); $_info['data'] = $_data; } else { $_info['state'] = 1; $_info['info'] = '请输入会员ID'; } echo _json($_info); _free_result($_result); _close();?>
申请提现
<?php require dirname(__FILE__).'/../includes/common.inc.php';//沈婷提现 $_clean = array(); $_clean['userId'] = _check($_POST['userId']); $_clean['casGatName'] = _check($_POST['casGatName']); //名称 $_clean['casGatzh'] = _check($_POST['casGatzh']);//收款帐号 $_clean['casGatType'] = _check($_POST['casGatType']);//收款方式 $_clean['CasBranch'] = _check($_POST['CasBranch']);//分行名称 $_clean['cashMoney'] = _check($_POST['cashMoney']);//申请提现金额 $_now = date('Y-m-d H:i:s',time()); $_info = array(); $_data = array(); if( $_clean['userId'] != '' && $_clean['casGatName'] != '' && $_clean['casGatzh'] != '' && $_clean['casGatType'] != '' && $_clean['CasBranch'] != '' && $_clean['cashMoney'] != '' ){ $_info['state'] = 0; $_info['info'] = ''; $_sql = "INSERT INTO tb_cashApplay ( userid, casGatName, casGatzh, casGatType, CasBranch, cashMoney, applayDate, payDate, cashState, cashNote ) VALUES ( '{$_clean['userId']}', '{$_clean['casGatName']}', '{$_clean['casGatzh']}', '{$_clean['casGatType']}', '{$_clean['CasBranch']}', '{$_clean['cashMoney']}', '$_now', '', 0, '' )"; _query($_sql); if( _affected_rows() == 1 ){ $_data['state'] = 0; $_data['info'] = '申请成功!'; }else{ $_data['state'] = 1; $_data['info'] = '申请失败!'; } $_info['data'] = $_data; } else { $_info['state'] = 1; $_info['info'] = '参数有误!'; } echo _json($_info); _close();?>
密码 交易密码 问题答案修改
<?php require dirname(__FILE__).'/../includes/common.inc.php'; $_clean = array(); $_clean['userId'] = _check($_POST['userId']); $_clean['regPwd'] = _check($_POST['regPwd']); $_clean['newRegPwd'] = _check($_POST['newRegPwd']); $_clean['tradingPwd'] = _check($_POST['tradingPwd']); $_clean['newTradingPwd'] = _check($_POST['newTradingPwd']); $_clean['encryptedQuestion'] = _check($_POST['encryptedQuestion']); $_clean['encryptedAnswer'] = _check($_POST['encryptedAnswer']); $_modify = array(); $_data = array(); if ( $_clean['userId'] > 0 ) { $_modify['state'] = 0; $_modify['info'] = ''; //查找密码和交易密码 $_sql = "SELECT regPwd,tradingPwd FROM tb_user WHERE id = '{$_clean['userId']}' AND state = 0"; $_result = _query($_sql); $_rows = _fetch_array($_result); //如果传过来的密码和新密码不等于空 if ( $_clean['regPwd'] != '' && $_clean['newRegPwd'] != '' && $_clean['tradingPwd'] == '' && $_clean['newTradingPwd'] == '' && $_clean['encryptedQuestion'] == '' && $_clean['encryptedAnswer'] == '' ) { //如果密码等于传过来的密码执行更新 否则失败 if ( $_rows['regPwd'] == $_clean['regPwd'] ) { $_sql1 = "UPDATE tb_user SET regPwd = '{$_clean['newRegPwd']}' WHERE id = '{$_clean['userId']}'"; _query($_sql1); } else { $_data['state'] = 1; $_data['info'] = '旧密码输入不正确!'; $_modify['data'] = $_data; echo _json($_modify); die; } //如果传过来的交易密码和新密码不等于空 执行更新 } elseif ( $_clean['regPwd'] == '' && $_clean['newRegPwd'] == '' && $_clean['tradingPwd'] != '' && $_clean['newTradingPwd'] != '' && $_clean['encryptedQuestion'] == '' && $_clean['encryptedAnswer'] == '' ) { if ( $_rows['tradingPwd'] == $_clean['tradingPwd'] ) { $_sql1 = "UPDATE tb_user SET tradingPwd = '{$_clean['newTradingPwd']}' WHERE id = '{$_clean['userId']}'"; _query($_sql1); } else { $_data['state'] = 2; $_data['info'] = '旧交易密码输入不正确!'; $_modify['data'] = $_data; echo _json($_modify); die; } //否则问题和答和新答案不等于空执行更新 } elseif ( $_clean['regPwd'] == '' && $_clean['newRegPwd'] == '' && $_clean['tradingPwd'] == '' && $_clean['newTradingPwd'] == '' && $_clean['encryptedQuestion'] != '' && $_clean['encryptedAnswer'] != '' ) { $_sql1 = "UPDATE tb_user SET encryptedQuestion = '{$_clean['encryptedQuestion']}', encryptedAnswer = '{$_clean['encryptedAnswer']}' WHERE id = '{$_clean['userId']}'"; } else { $_data['state'] = 2; $_data['info'] = '其余参数有误!'; } if ( _affected_rows() == 1 ) { $_data['state'] = 0; $_data['info'] = '修改成功!'; } else { $_data['state'] = 3; $_data['info'] = '修改失败!'; } $_modify['data'] = $_data; } else { $_modify['state'] = 1; $_modify['info'] = '请输入会员ID'; } echo _json($_modify); _free_result($_result); _close();?>
易币转账
<?php require dirname(__FILE__).'/includes/common.inc.php'; //易币转账 $_clean = array(); $_clean['userId'] = 146; $_clean['userName'] = 123456; $_clean['count'] = 20; $_now = date('Y-m-d H:i:s',time()); $_transferAccounts = array(); $_data = array(); if ( $_clean['userName'] != '' && $_clean['userId'] != '' && $_clean['count'] != '' ) { $_transferAccounts['state'] = 0; $_transferAccounts['info'] = ' '; //要对方的的账户 // 查找易币和账户金额 判断查询的账户是否存在 $_sql = "SELECT id,integral_easyhunt,cash_easyhunt FROM tb_user WHERE userName = '{$_clean['userName']}'"; $_result = _query($_sql); $_rows = _fetch_array($_result); if ( $_rows ) { $_html = array(); $_html['id'] = $_rows['id']; $_html['integral_easyhunt'] = $_rows['integral_easyhunt']; $_html['cash_easyhunt'] = $_rows['cash_easyhunt']; $_html = _html($_html); } else { $_data['state'] = 1; $_data['info'] = '此转账用户不存在!'; $_transferAccounts['data'] = $_data; echo _json($_transferAccounts); die; } //自己的账户金额和易币 $_sql1 = "SELECT cash_easyhunt,integral_easyhunt FROM tb_user WHERE id = '{$_clean['userId']}'"; $_result1 = _query($_sql1); $_rows1 = _fetch_array($_result1); $_html1 = array(); $_html1['cash_easyhunt'] = $_rows1['cash_easyhunt']; $_html1['integral_easyhunt'] = $_rows1['integral_easyhunt']; $_html1 = _html($_html1); //如果自己的账户积分大于等于转出去的账户总数 if ( $_html1['integral_easyhunt'] >= $_clean['count'] ) { //自己的等于减去传出的 $_html1['integral_easyhunt'] = $_html1['integral_easyhunt'] - $_clean['count']; //对方的等于转进来的 $_html['integral_easyhunt'] = $_html['integral_easyhunt'] + $_clean['count']; //自己的账户变动 $_sql2 = "UPDATE tb_user SET integral_easyhunt = '{$_html1['integral_easyhunt']}' WHERE id = '{$_clean['userId']}'"; _query($_sql2); //对方的变动 $_sql3 = "UPDATE tb_user SET integral_easyhunt = '{$_html['integral_easyhunt']}' WHERE id = '{$_html['id']}'"; _query($_sql3); //自己的账户记录 $_sql4 = "INSERT INTO tb_cashAndebLog VALUES (null,1,'{$_clean['userId']}','$_now','来自Android','易币转账','{$_clean['count']}',0)"; _query($_sql4); //自己的账户记录 $_sql5 = "INSERT INTO tb_cashAndebLog VALUES (null,1,'{$_html['id']}','$_now','来自Android','易币转账','{$_clean['count']}',1)"; _query($_sql5); if ( _affected_rows() == 1 ) { $_data['state'] = 0; $_data['info'] = '转账成功!'; } else { $_data['state'] = 3; $_data['info'] = '转账失败!'; } } else { $_data['state'] = 2; $_data['info'] = '易币不足!'; $_transferAccounts['data'] = $_data; echo _json($_transferAccounts); die; } $_transferAccounts['data'] = $_data; } else { $_transferAccounts['state'] = 1; $_transferAccounts['info'] = '参数有误!'; } echo _json($_transferAccounts); _free_result($_result); _free_result($_result1); _close();?>
上传图片
<?php require dirname(__FILE__).'/../includes/common.inc.php'; $_clean = array(); $_clean['userId'] = 146; $_info = array(); $_data = array(); if ( $_clean['userId'] != '' ) { $_info['state'] = 0; $_info['info'] = ''; mkdir("D:\www\web\php_easyhunt\userimage" . '/'. $_clean['userId'], 0700); $target_path = "D:\www\web\php_easyhunt\userimage" . '/' . $_clean['userId'] . "/";//接收文件目录 $target_path = $target_path . basename( $_FILES['userimage']['name']); if(move_uploaded_file($_FILES['userimage']['tmp_name'], $target_path)) { $_data['state'] = 0; $_data['info'] = '上传成功'; } else{ $_data['state'] = 1; $_date['info'] = '上传失败'; } $_sql = "SELECT Userimage FROM tb_user WHERE id = '{$_clean['userId']}'"; $_result = _query($_sql); $_rows = _fetch_array($_result); unlink("D:\www\web\php_easyhunt" . '/' . $_rows['Userimage'] ); $_picture1 = "userimage/" . $_clean['userId'] . '/' . basename( $_FILES['userimage']['name']); $_sql1 = "UPDATE tb_user SET Userimage = '$_picture1' WHERE id = '{$_clean['userId']}'"; _query($_sql1); $_info['data'] = $_data; } else { $_info['state'] = 1; $_info['info'] = '请输入会员ID'; } echo _json($_info); _free_result($_result); _close();?>
订单信息
<?php require dirname(__FILE__).'/includes/common.inc.php'; //用户id 订单号 //先查询出订单表有没有订单 在查询出订单中的信息 在查询出订单表里面的商品信息 在查询订单表的收获等信息 做判断 $_clean = array(); $_clean['userId'] = _check($_POST['userId']); $_clean['orderNumber'] = _check($_POST['orderNumber']); $_info = array(); $_data = array(); if ( $_clean['userId'] > 0 && $_clean['orderNumber'] != '' ) { $_info['state'] = 0; $_info['info'] = ''; $_sql = "SELECT orderNumber FROM tb_easyGoodsOrder WHERE orderNumber = '{$_clean['orderNumber']}' LIMIT 1"; $_result = _query($_sql); $_rows = _fetch_array($_result); if ( !!$_rows ) { $_data['orderNumber'] = $_rows['orderNumber']; $_data['state'] = 0; $_data['info'] = ''; } else { $_data['state'] = 1; $_data['info'] = '该订单不存在!'; $_info['data'] = $_data; echo _json($_info); die; } $_sql1 = "SELECT goodsId,goodsModule,orderDate,goodsMoneyPrice,goodsIntegralPrice,orderBuyCount,goodsPostage FROM tb_easyGoodsOrder WHERE orderNumber = '{$_clean['orderNumber']}' AND orderStatus = 0"; $_result1 = _query($_sql1); $_rows1 = _fetch_array($_result1); $_data = array(); $_data['goodsType'] = $_rows1['goodsType']; $_data['goodsMoneyPrice'] = $_rows1['goodsMoneyPrice']; $_data['goodsIntegralPrice'] = $_rows1['goodsIntegralPrice']; $_data['goodsPostage'] = $_rows1['goodsPostage']; $_data['orderBuyCount'] = $_rows1['orderBuyCount']; $_data['orderDate'] = $_rows1['orderDate']; $_data['id'] = $_rows1['goodsId']; $_sql2 = "SELECT goodsName,goodsPicture FROM tb_easyGoods WHERE id = '{$_rows1['goodsId']}'"; $_result2 = _query($_sql2); $_rows2 = _fetch_array($_result2); $_data['title'] = $_rows2['goodsName']; $_data['pic'] = 'http://www.easyhunt.cn/' . $_rows2['goodsPicture']; $_data['totalPrice'] = $_data['goodsMoneyPrice'] * $_data['orderBuyCount']; $_sql = "SELECT deliveryName,deliveryAddress,deliveryPhone,deliveryCode FROM tb_easyGoodsOrder WHERE orderNumber = '{$_clean['orderNumber']}'"; $_result = _query($_sql); $_rows = _fetch_array($_result); if ( $_rows['deliveryName'] == '' && $_rows['deliveryAddress'] == '' && $_rows['deliveryPhone'] == '' ) { $_sql1 = "SELECT province,theCity,county,address,phone,realName FROM tb_user WHERE id = '{$_clean['userId']}'"; $_result1 = _query($_sql1); $_rows1 = _fetch_array($_result1); $_sqlp = "SELECT areaName FROM tb_earea WHERE id = '{$_rows1['province']}'"; $_resultp = _query($_sqlp); $_rowsp = _fetch_array($_resultp); $_sqlt = "SELECT areaName FROM tb_earea WHERE id = '{$_rows1['theCity']}'"; $_resultt = _query($_sqlt); $_rowst = _fetch_array($_resultt); $_sqlc = "SELECT areaName FROM tb_earea WHERE id = '{$_rows1['county']}'"; $_resultc = _query($_sqlc); $_rowsc = _fetch_array($_resultc); $_data['deliveryAddress'] = $_rowsp['areaName'] . $_rowst['areaName'] . $_rowsc['areaName'] . $_rows1['address']; $_data['deliveryPhone'] = $_rows1['phone']; $_data['deliveryName'] = $_rows1['realName']; $_data['deliveryCode'] = ''; } elseif ( $_rows['deliveryName'] != '' && $_rows['deliveryAddress'] != '' && $_rows['deliveryPhone'] != '' ) { $_data['deliveryName'] = $_rows['deliveryName']; $_data['deliveryAddress'] = $_rows['deliveryAddress']; $_data['deliveryPhone'] = $_rows['deliveryPhone']; $_data['deliveryCode'] = $_rows['deliveryCode']; } $_data = _html($_data); $_info['data'] = $_data; } else { $_info['state'] = 1; $_info['info'] = '参数有误!'; } echo _json($_info); _free_result($_result); _free_result($_result1); _free_result($_result2); _close();?>
抽奖 领取奖项
<?php//抽奖 中奖 require dirname(__FILE__).'/../includes/common.inc.php'; $_clean = array(); $_clean['userId'] = _check($_POST['userId']);//用户ID $_clean['prizeId'] = _check($_POST['prizeId']);//奖品id $_info = array(); $_data = array(); if ( $_clean['userId'] > 0 && $_clean['prizeId'] > 0 ) { $_info['state'] = 0; $_info['info'] = ''; mysql_query("BEGIN"); $flag=0; //插入中奖记录 _query("INSERT INTO tb_thePrizeLog VALUES (null,'{$_clean['userId']}',now(),'来自Android','{$_clean['prizeId']}',1)"); //通过中将ID查找 商家ID $_sql = "SELECT * FROM tb_thePrize WHERE id = '{$_clean['prizeId']}' AND State = 1"; $_result = _query($_sql); $_rows = _fetch_array($_result); $_html = array(); $_html['company'] = $_rows['company']; $_html['useIntegral'] = $_rows['useIntegral'];//在线抽奖中官方奖品抽奖需要的积分 $_html['thePrizeType'] = $_rows['thePrizeType'];//奖品类型 $_html['oneReward'] = $_rows['oneReward'];//单条奖励的分数 $_html['goodsId'] = $_rows['goodsId'];//商品ID $_html = _html($_html); if ( $_html['company'] == 0 ) { //如果商家id等于0 更新账户易币 插入记录集 _query("UPDATE tb_user SET integral_easyhunt = integral_easyhunt - '{$_html['useIntegral']}' WHERE id = '{$_clean['userId']}'"); _query("INSERT INTO tb_cashAndebLog VALUES (null,1,'{$_clean['userId']}',now(),'来自Android','在线抽奖','{$_html['useIntegral']}',0)"); } //如果中奖的是易币 更新账户易币 插入记录集 if ( $_html['thePrizeType'] == 1 ) { _query("UPDATE tb_user SET integral_easyhunt = integral_easyhunt + '{$_html['oneReward']}' WHERE id = '{$_clean['userId']}'"); _query("INSERT INTO tb_cashAndebLog VALUES (null,1,'{$_clean['userId']}',now(),'来自Android','在线抽奖','{$_html['oneReward']}',1)"); } elseif ( $_html['thePrizeType'] == 2 ) { _query("UPDATE tb_user SET cash_easyhunt = cash_easyhunt + '{$_html['oneReward']}' WHERE id = '{$_clean['userId']}'"); _query("INSERT INTO tb_cashAndebLog VALUES (null,2,'{$_clean['userId']}',now(),'来自Android','在线抽奖','{$_html['oneReward']}',1)"); //如果是物品 查出商品现价 可使用易币 商品邮费 } elseif ( $_html['thePrizeType'] == 3 ) { $_sql1 = "SELECT * FROM tb_easyGoods WHERE id = '{$_html['goodsId']}'"; $_result1 = _query($_sql1); $_rows1 = _fetch_array($_result1); $_html1 = array(); $_html1['goodsMoneyPrice'] = $_rows1['goodsMoneyPrice']; $_html1['goodsIntegralPrice'] = $_rows1['goodsIntegralPrice']; $_html1['goodsPostage'] = $_rows1['goodsPostage']; $_html1 = _html($_html1); $year_code = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z'); $_orderNumber = $year_code[intval(date('Y'))-2014].strtoupper(dechex(date('m'))).date('d').substr(time(),-5).substr(microtime(),2,5).sprintf('d',rand(0,99)); //如果都大于0 插入订单 if ( $_html1['goodsMoneyPrice'] > 0 or $_html1['goodsIntegralPrice'] > 0 or $_html1['goodsPostage'] > 0 ) { _query("INSERT INTO tb_easyGoodsOrder VALUES (null,5,now(),'来自Android','{$_html['company']}','{$_clean['userId']}','$_orderNumber','{$_html['goodsId']}','{$_html1['goodsMoneyPrice']}','{$_html1['goodsIntegralPrice']}','{$_html1['goodsPostage']}',1,'抽奖中奖',0,0,0,'抽奖',0,'','','','','','')"); } else { _query("INSERT INTO tb_easyGoodsOrder VALUES (null,5,now(),'来自Android','{$_html['company']}','{$_clean['userId']}','$_orderNumber','{$_html['goodsId']}',0,0,0,1,'抽奖中奖',0,0,1,'抽奖',1,'','','','','','')"); } } //更新抽奖商品的易币数 _query("UPDATE tb_thePrize SET totalReward = totalReward - oneReward WHERE id = '{$_clean['prizeId']}'"); $flag=1; if($flag==1){ mysql_query("COMMIT"); $_data["state"] = 0; $_data['info'] = '领取成功'; }else{ mysql_query("ROLLBACK"); $_data['state'] = 1; $_data['info'] = '领取失败'; } $_info['data'] = $_data; } else { $_info['state'] = 1; $_info['info'] = '参数有误!'; } echo _json($_info); _free_result($_result); _free_result($_result1); _close();?>
秒杀订单
<?php require dirname(__FILE__).'/../includes/common.inc.php'; $_clean = array(); $_clean['userId'] = _check($_POST['userId']); $_clean['goodsId'] = _check($_POST['goodsId']); $_order = array(); $_data = array(); $_now = date('Y-m-d H:i:s',time()); $_now_ymd = date('Y-m-d',time()); $_now_hms = date('H:i:s',time()); $_ymd = explode("-",$_now_ymd); $_ymd_y = $_ymd[0]; $_ymd_m = $_ymd[1]; $_ymd_d = $_ymd[2]; $_ymd = $_ymd_y.$_ymd_m.$_ymd_d; $_hms = explode(":",$_now_hms); $_hms_h = $_hms[0]; $_hms_m = $_hms[1]; $_hms_s = $_hms[2]; $_hms_m1 = $_hms[1] + 45; if( $_hms_m1 >= 60 ){ $_hms_m1 = $_hms_m1 - 60; $_hms_h1 = $_hms[0] + 1; $_now1 = $_now_ymd . ' ' . $_hms_h1 . ':' . $_hms_m1 . ':' . $_hms_s; //有效期 }else{ $_now1 = $_now_ymd . ' ' . $_hms_h . ':' . $_hms_m1 . ':' . $_hms_s; } $_hms = $_hms_h.$_hms_m.$_hms_s; $year_code = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z'); $_data['orderNumber'] = $year_code[intval(date('Y'))-2014].strtoupper(dechex(date('m'))).date('d').substr(time(),-5).substr(microtime(),2,5).sprintf('d',rand(0,99));//生成订单号 $_orderBuyCount = 1;//数量为1 if ( $_clean['userId'] != '' && $_clean['goodsId'] != '' ) { $_order['state'] = 0; $_order['info'] = ''; $_sql = "SELECT companyId,goodsName,goodsType,goodsMoneyPrice,goodsPicture,goodsIntegralPrice,goodsPostage,goodsInventory FROM tb_goods WHERE goodsId = '{$_clean['goodsId']}' AND goodsShow = 1 LIMIT 1"; $_result = _query($_sql); $_rows = _fetch_array($_result); $_html = array(); $_html['companyId'] = $_rows['companyId']; $_html['title'] = $_rows['goodsName']; $_html['goodsType'] = $_rows['goodsType']; $_html['goodsMoneyPrice'] = $_rows['goodsMoneyPrice']; $_html['pic'] = $_rows['goodsPicture']; $_html['goodsIntegralPrice'] = $_rows['goodsIntegralPrice']; $_html['goodsPostage'] = $_rows['goodsPostage']; $_html['goodsInventory'] = $_rows['goodsInventory']; $_html = _html($_html); $_sql2 = "SELECT province,theCity,county,address,phone,realName FROM tb_user WHERE id = '{$_clean['userId']}'"; $_result2 = _query($_sql2); $_rows2 = _fetch_array($_result2); $_html2 = array(); $_html2['province'] = $_rows['province']; $_html2['theCity'] = $_rows['theCity']; $_html2['county'] = $_rows['county']; $_html2['address'] = $_rows['address']; $_html2['phone'] = $_rows['phone']; $_html2['realName'] = $_rows['realName']; $_html2 = _html($_html2); $_data['realName'] = $_html2['realName']; $_data['address'] = $_html2['province'].$_html2['theCity'].$_html2['county'].$_html2['address']; $_data['phone'] = $_html2['phone']; if ( $_now_hms >= '12:00:00' && $_now_hms <= '13:00:00' ) { if ( $_html['goodsInventory'] >= $_orderBuyCount ) { $_sql1 = "INSERT INTO tb_goodsOrder ( companyId, goodsType, orderDate, orderIP, orderNumber, userId, goodsId, goodsName, goodsPicture, goodsMoneyPrice, goodsIntegralPrice, goodsPostage, orderBuyCount, orderNote, orderPayMoney, orderPayIntegral, orderPayWay, orderStatus, orderEffectiveDate, deliveryName, deliveryAddress, deliveryPhone, deliveryCode, courierCompany, courierOrderNo ) VALUES ( '{$_html['companyId']}', '{$_html['goodsType']}', '$_now', '来自Android', '{$_data['orderNumber']}', '{$_clean['userId']}', '{$_clean['goodsId']}', '{$_html['title']}', '{$_html['pic']}', '{$_html['goodsMoneyPrice']}', '{$_html['goodsIntegralPrice']}', '{$_html['goodsPostage']}', 1, '', '', '', '', 0, '$_now1', '{$_data['realName']}', '{$_data['address']}', '{$_data['phone']}', '', '', '' )"; _query($_sql1); if( _affected_rows() == 1 ){ $_data['state'] = 0; $_data['info'] = '订单提交成功!'; }else{ $_data['state'] = 2; $_data['info'] = '订单提交失败!'; } } else { $_data['state'] = 2; $_data['info'] = '库存不足!'; $_order['data'] = $_data; echo _json($_order); die; } } else { $_data['state'] = 1; $_data['info'] = '秒杀时间已过或者秒杀未开始'; $_order['data'] = $_data; echo _json($_order); die; } } else { $_order['state'] = 1; $_order['info'] = '参数有误!'; } $_order['data'] = $_data; echo _json($_order); _free_result($_result); _close();?>
<?php require dirname(__FILE__).'/../includes/common.inc.php'; $_clean = array(); $_clean['userId'] = _check($_POST['userId']); $_clean['goodsId'] = _check($_POST['goodsId']); $_order = array(); $_data = array(); //年月日 时分秒 $_now = date('Y-m-d H:i:s',time()); //年月日 $_now_ymd = date('Y-m-d',time()); //时分秒 $_now_hms = date('H:i:s',time()); //把字符串分割城数组 $_ymd = explode("-",$_now_ymd); $_ymd_y = $_ymd[0]; $_ymd_m = $_ymd[1]; $_ymd_d = $_ymd[2]; $_ymd = $_ymd_y.$_ymd_m.$_ymd_d; $_hms = explode(":",$_now_hms); $_hms_h = $_hms[0]; $_hms_m = $_hms[1]; $_hms_s = $_hms[2]; $_hms_m1 = $_hms[1] + 45; if( $_hms_m1 >= 60 ){ $_hms_m1 = $_hms_m1 - 60; $_hms_h1 = $_hms[0] + 1; $_now1 = $_now_ymd . ' ' . $_hms_h1 . ':' . $_hms_m1 . ':' . $_hms_s; //有效期 }else{ $_now1 = $_now_ymd . ' ' . $_hms_h . ':' . $_hms_m1 . ':' . $_hms_s; } $_hms = $_hms_h.$_hms_m.$_hms_s; $year_code = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z'); $_data['orderNumber'] = $year_code[intval(date('Y'))-2014].strtoupper(dechex(date('m'))).date('d').substr(time(),-5).substr(microtime(),2,5).sprintf('d',rand(0,99));//生成订单号 $_orderBuyCount = 1;//数量为1 if ( $_clean['userId'] != '' && $_clean['goodsId'] != '' ) { $_order['state'] = 0; $_order['info'] = ''; //查找商品 信息 $_sql = "SELECT companyId,goodsName,goodsType,goodsMoneyPrice,goodsPicture,goodsIntegralPrice,goodsPostage,goodsInventory FROM tb_goods WHERE goodsId = '{$_clean['goodsId']}' AND goodsShow = 1 LIMIT 1"; $_result = _query($_sql); $_rows = _fetch_array($_result); $_html = array(); $_html['companyId'] = $_rows['companyId']; $_html['title'] = $_rows['goodsName']; $_html['goodsType'] = $_rows['goodsType']; $_html['goodsMoneyPrice'] = $_rows['goodsMoneyPrice']; $_html['pic'] = $_rows['goodsPicture']; $_html['goodsIntegralPrice'] = $_rows['goodsIntegralPrice']; $_html['goodsPostage'] = $_rows['goodsPostage']; $_html['goodsInventory'] = $_rows['goodsInventory']; $_html = _html($_html); //查找用和的信息 $_sql2 = "SELECT province,theCity,county,address,phone,realName FROM tb_user WHERE id = '{$_clean['userId']}'"; $_result2 = _query($_sql2); $_rows2 = _fetch_array($_result2); $_html2 = array(); $_html2['province'] = $_rows['province']; $_html2['theCity'] = $_rows['theCity']; $_html2['county'] = $_rows['county']; $_html2['address'] = $_rows['address']; $_html2['phone'] = $_rows['phone']; $_html2['realName'] = $_rows['realName']; $_html2 = _html($_html2); $_data['realName'] = $_html2['realName']; $_data['address'] = $_html2['province'].$_html2['theCity'].$_html2['county'].$_html2['address']; $_data['phone'] = $_html2['phone']; //时间的判断 插入订单 if ( $_now_hms >= '12:00:00' && $_now_hms <= '13:00:00' ) { //判断库存 if ( $_html['goodsInventory'] >= $_orderBuyCount ) { //提交订单 $_sql1 = "INSERT INTO tb_goodsOrder ( companyId, goodsType, orderDate, orderIP, orderNumber, userId, goodsId, goodsName, goodsPicture, goodsMoneyPrice, goodsIntegralPrice, goodsPostage, orderBuyCount, orderNote, orderPayMoney, orderPayIntegral, orderPayWay, orderStatus, orderEffectiveDate, deliveryName, deliveryAddress, deliveryPhone, deliveryCode, courierCompany, courierOrderNo ) VALUES ( '{$_html['companyId']}', '{$_html['goodsType']}', '$_now', '来自Android', '{$_data['orderNumber']}', '{$_clean['userId']}', '{$_clean['goodsId']}', '{$_html['title']}', '{$_html['pic']}', '{$_html['goodsMoneyPrice']}', '{$_html['goodsIntegralPrice']}', '{$_html['goodsPostage']}', 1, '', '', '', '', 0, '$_now1', '{$_data['realName']}', '{$_data['address']}', '{$_data['phone']}', '', '', '' )"; _query($_sql1); if( _affected_rows() == 1 ){ $_data['state'] = 0; $_data['info'] = '订单提交成功!'; }else{ $_data['state'] = 2; $_data['info'] = '订单提交失败!'; } } else { $_data['state'] = 2; $_data['info'] = '库存不足!'; $_order['data'] = $_data; echo _json($_order); die; } } else { $_data['state'] = 1; $_data['info'] = '秒杀时间已过或者秒杀未开始'; $_order['data'] = $_data; echo _json($_order); die; } } else { $_order['state'] = 1; $_order['info'] = '参数有误!'; } $_order['data'] = $_data; echo _json($_order); _free_result($_result); _close();?>
订单支付
<?php require dirname(__FILE__).'/includes/common.inc.php'; $_now = date('Y-m-d H:i:s',time()); $_clean = array(); $_clean['userId'] = _check($_POST['userId']); $_clean['orderNumber'] = _check($_POST['orderNumber']); $_clean['deliveryName'] = _check($_POST['deliveryName']); $_clean['deliveryAddress'] = _check($_POST['deliveryAddress']); $_clean['deliveryPhone'] = _check($_POST['deliveryPhone']); $_clean['deliveryCode'] = _check($_POST['deliveryCode']); $_clean['orderPayWay'] = _check($_POST['orderPayWay']); $_orderDetail = array(); $_data = array(); //订单号 支付方式 用户ID if ( $_clean['orderNumber'] != '' && $_clean['orderPayWay'] != '' && $_clean['userId'] != '' ) { $_orderDetail['state'] = 0; $_orderDetail['info'] = ''; //更新数据 _query("UPDATE tb_easyGoodsOrder SET deliveryName = '{$_clean['deliveryName']}',deliveryAddress = '{$_clean['deliveryAddress']}',deliveryPhone = '{$_clean['deliveryPhone']}',deliveryCode = '{$_clean['deliveryCode']}' WHERE orderNumber = '{$_clean['orderNumber']}'"); //查询出订单信息 $_sql2 = "SELECT goodsModule,orderPayMoney,orderPayIntegral,integralPayState FROM tb_easyGoodsOrder WHERE userid = '{$_clean['userId']}' AND orderNumber = '{$_clean['orderNumber']}' AND orderStatus = 0"; $_result2 = _query($_sql2); $_rows2 = _fetch_array($_result2); if ( !$_rows2 ) { _free_result($_result2); $_data['state'] = 1; $_data['info'] = '该订单不存在!'; $_orderDetail['data'] = $_data; echo _json($_orderDetail); die; } else { $_html2 = array(); if ( $_rows2['goodsModule'] == 1 ) { $_html2['goodsModule'] = "秒杀商品支付"; } elseif ( $_rows2['goodsModule'] == 2 ) { $_html2['goodsModule'] = "兑换商品支付"; } elseif ( $_rows2['goodsModule'] == 3 ) { $_html2['goodsModule'] = "特惠购物支付"; } elseif ( $_rows2['goodsModule'] == 4 ) { $_html2['goodsModule'] = "广告商品领取"; } elseif ( $_rows2['goodsModule'] == 5 ) { $_html2['goodsModule'] = "抽奖商品领取"; } $_html2['orderPayMoney'] = $_rows2['orderPayMoney']; $_html2['orderPayIntegral'] = $_rows2['orderPayIntegral']; $_html2['integralPayState'] = $_rows2['integralPayState']; $_html2 = _html($_html2); $_sql3 = "SELECT integral_easyhunt,cash_easyhunt FROM tb_user WHERE id = '{$_clean['userId']}'"; $_result3 = _query($_sql3); $_rows3 = _fetch_array($_result3); $_html3 = array(); $_html3['integral_easyhunt'] = $_rows3['integral_easyhunt']; $_html3['cash_easyhunt'] = $_rows3['cash_easyhunt']; $_html3 = _html($_html3); //如果是预存款 if ( $_clean['orderPayWay'] == '预存款' ) { //如果订单要支付的易币 订单是未付款 if ( $_html2['orderPayIntegral'] > 0 && $_html2['integralPayState'] == 0 ) { //如果账户易币小于要支付的易币 易币不足 if ( $_html3['integral_easyhunt'] < $_html2['orderPayIntegral'] ) { $_data['state'] = 2; $_data['info'] = '易币不足!'; $_orderDetail['data'] = $_data; echo _json($_orderDetail); die; //否则账户小于要支付的账户 存款不足 } elseif ( $_html3['cash_easyhunt'] < $_html2['orderPayMoney'] ) { $_data['state'] = 3; $_data['info'] = '预存款不足!'; $_orderDetail['data'] = $_data; echo _json($_orderDetail); die; } else { mysql_query("BEGIN"); $flag=0; //用户账户变动 _query("UPDATE tb_user SET cash_easyhunt = cash_easyhunt - '{$_html2['orderPayMoney']}',integral_easyhunt = integral_easyhunt - '{$_html2['orderPayIntegral']}' WHERE id = '{$_clean['userId']}'"); // 易币账户记录 _query("INSERT INTO tb_cashAndebLog VALUES (null,1,'{$_clean['userId']}','$_now','来自Android','{$_html2['goodsModule']}','{$_html2['orderPayIntegral']}',0)"); //现金记录 _query("INSERT INTO tb_cashAndebLog VALUES (null,2,'{$_clean['userId']}','$_now','来自Android','{$_html2['goodsModule']}','{$_html2['orderPayMoney']}',0)"); // 支付状态 易币支付状态 支付状态 订单状态和 _query("UPDATE tb_easyGoodsOrder SET integralPayState = 1,orderPayWay = '预存款支付' orderStatus = 1 WHERE orderNumber = '{$_clean['orderNumber']}'"); $flag=1; if($flag==1){ mysql_query("COMMIT"); $_data['state'] = 0; $_data['info'] = '支付成功'; }else{ mysql_query("ROLLBACK"); $_data['state'] = 4; $_data['info'] = '支付失败'; } } } else { //如果存款不足 if ( $_html3['cash_easyhunt'] < $_html2['orderPayMoney'] ) { $_data['state'] = 3; $_data['info'] = '预存款不足!'; $_orderDetail['data'] = $_data; echo _json($_orderDetail); die; } else { mysql_query("BEGIN"); $flag=0; ////用户账户变动 _query("UPDATE tb_user SET cash_easyhunt = cash_easyhunt - '{$_html2['orderPayMoney']}' WHERE id = '{$_clean['userId']}'"); // 易币账户记录 _query("INSERT INTO tb_cashAndebLog VALUES (null,2,'{$_clean['userId']}','$_now','来自Android','{$_html2['goodsModule']}','{$_html2['orderPayMoney']}',0)"); // 态 订单状态和 _query("UPDATE tb_easyGoodsOrder SET orderPayWay = '预存款支付',orderStatus = 1 WHERE orderNumber = '{$_clean['orderNumber']}'"); $flag=1; if($flag==1){ mysql_query("COMMIT"); $_data['state'] = 0; $_data['info'] = '支付成功'; }else{ mysql_query("ROLLBACK"); $_data['state'] = 4; $_data['info'] = '支付失败'; } } } } elseif ( $_clean['orderPayWay'] == '支付宝' ) { } } $_orderDetail['data'] = $_data; } else { $_orderDetail['state'] = 1; $_orderDetail['info'] = '参数有误!'; } echo _json($_orderDetail); _close(); ?>
点就赚来就赚
验证 订单信息
<?php require dirname(__FILE__).'/includes/common.inc.php'; $_clean = array(); $_clean['userId'] = 146; $_clean['adInfoId'] = 2; $_now = date('Y-m-d H:i:s',time()); $_info = array(); $_data = array(); if ( $_clean['userId'] > 0 && $_clean['adInfoId'] > 0 ) { $_info['state'] = 0; $_info['info'] = ''; //查找点就赚信息 $_sql = "SELECT * FROM tb_adInfo WHERE id = '{$_clean['adInfoId']}'"; $_result = _query($_sql); $_rows = _fetch_array($_result); //查找点就赚 id = 在记录表里的信息 如果有值表示已经验证 负责查找点就赚信息 $_sql1 = "SELECT * FROM tb_adInfoLog WHERE id = (SELECT id FROM tb_adInfoLog WHERE adInfoId = '{$_clean['adInfoId']}' AND userid = '{$_clean['userId']}' ORDER BY id DESC LIMIT 1) AND DATEDIFF(NOW(),addDates) < '{$_rows['interval']}'"; $_result1 = _query($_sql1); $_row1 = _num_rows($_result1); if ( $_row1 > 0 ) { $_data['state'] = 1; $_data['info'] = '已验证!'; } else { $_sql2 = "SELECT advertisingType,rewardType,goodsId,totalReward,oneReward FROM tb_adInfo WHERE id = '{$_clean['adInfoId']}' AND State=1"; $_result2 = _query($_sql2); $_rows2 = _fetch_array($_result2); $_html2 = array(); $_html2['advertisingType'] = $_rows2['advertisingType']; $_html2['rewardType'] = $_rows2['rewardType']; $_html2['goodsId'] = $_rows2['goodsId']; $_html2['totalReward'] = $_rows2['totalReward']; $_html2['oneReward'] = $_rows2['oneReward']; $_html2 = _html($_html2); if($_html2['advertisingType']==1){ $operation="广告浏览"; }elseif($_html2['advertisingType']==2){ $operation="促销活动"; }elseif($_html2['advertisingType']==3){ $operation="商家宣传"; } mysql_query("BEGIN"); $flag=0; //添加浏览记录 _query("insert into tb_adInfoLog values(null,'{$_clean['userId']}','{$_clean['adInfoId']}',now(),'来自Android')"); //如果总奖励除以单奖励 大于等于1 继续执行 否则奖励已经发完 if( $_html2['totalReward'] / $_html2['oneReward'] >= 1 ) { if ( $_html2['rewardType'] == 1 ) {//易币 //给会员添加易币奖励 _query("update tb_user set integral_easyhunt = integral_easyhunt + '{$_html2['oneReward']}' where id = '{$_clean['userId']}'"); //添加易币增加的变动记录 _query("insert into tb_cashAndebLog values(null,1,'{$_clean['userId']}',now(),'来自Android','$operation','{$_html2['oneReward']}',1)"); } elseif ( $_html2['rewardType'] == 2 ) {//现金 //给会员添加现金 _query("update tb_user set cash_easyhunt = cash_easyhunt + '{$_html2['oneReward']}' where id = '{$_clean['userId']}'"); //添加现金增加的变动记录 _query("insert into tb_cashAndebLog values(null,2,'{$_clean['userId']}',now(),'来自Android','$operation','{$_html2['oneReward']}',1)"); } elseif ( $_html2['rewardType'] == 3 ) {//实物/现金劵等 查询商品信息 //实物奖励,查询出奖励的实物,添加实物订单 $_result3 = _query("select * from tb_goods where goodsId = '{$_html2['goodsId']}'"); $_rows3 = _fetch_array($_result3); $_html3 = array(); $_html3['company'] = $_rows3["company"]; $_html3['goodsMoneyPrice'] = $_rows3["goodsMoneyPrice"]; $_html3['goodsIntegralPrice'] = $_rows3["goodsIntegralPrice"]; $_html3['goodsPostage'] = $_rows3["goodsPostage"]; //添加广告区订单(点击赚和来就赚) $year_code = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z'); $_orderNumber = $year_code[intval(date('Y'))-2014].strtoupper(dechex(date('m'))).date('d').substr(time(),-5).substr(microtime(),2,5).sprintf('d',rand(0,99)); //如果 价格 邮费等有值 if( $_html3['goodsMoneyPrice'] > 0 or $_html3['goodsIntegralPrice'] > 0 or $_html3['goodsPostage'] > 0 ){ //插入订单 _query("insert into tb_easyGoodsOrder values(null,4,now(),'来自Android','{$_html3['company']}','{$_clean['userId']}','$_orderNumber','{$_html2['goodsId']}','{$_html3['goodsMoneyPrice']}','{$_html3['goodsIntegralPrice']}','{$_html3['goodsPostage']}',1,'浏览广告奖励',0,0,0,'浏览广告',0,'','','','','','')"); }else{ _query("insert into tb_easyGoodsOrder values(null,4,now(),'来自Android','{$_html3['company']}','{$_clean['userId']}','$_orderNumber','{$_html2['goodsId']}',0,0,0,1,'浏览广告奖励',0,0,1,'浏览广告',1,'','','','','','')"); } } }else{ $_data['state'] = 1; $_data['info'] = '奖励已经发放完了'; } $flag=1; if($flag==1){ mysql_query("COMMIT"); $_data["state"] = 0; $_data['info'] = '验证成功'; }else{ mysql_query("ROLLBACK"); $_data["state"] = 1; $_data['info'] = '验证失败'; } } $_info['data'] = $_data; } else { $_info['state'] = 1; $_info['info'] = '参数有误!'; } echo _json($_info); _free_result($_result); _free_result($_result1); _free_result($_result2); _free_result($_result3); _close();?>
0 0