public function ruleDeleted($rid) { $form = DBUtil::findUnique(DBUtil::$TABLE_ORDER_FORM, array(":rid" => $rid)); pdo_delete(DBUtil::$TABLE_ORDER_ITEM, array("fid" => $form['id'])); pdo_delete(DBUtil::$TABLE_ORDER_ORDER, array("fid" => $form['id'])); pdo_delete(DBUtil::$TABLE_ORDER_FORM, array('id' => $form['id'])); }
public function ruleDeleted($rid) { $egg = DBUtil::findUnique(DBUtil::$TABLE_EGG, array(":rid" => $rid)); pdo_delete(DBUtil::$TABLE_EGG_USER, array("egid" => $egg['id'])); pdo_delete(DBUtil::$TABLE_EGG_PRIZE, array("egid" => $egg['id'])); pdo_delete(DBUtil::$TABLE_EGG_RECORD, array("egid" => $egg['id'])); pdo_delete(DBUtil::$TABLE_EGG_SHARE, array("egid" => $egg['id'])); }
public function ruleDeleted($rid) { $wkj = DBUtil::findUnique(DBUtil::$TABLE_WKJ, array(":rid" => $rid)); pdo_delete(DBUtil::$TABLE_WKJ_FIREND, array("kid" => $wkj['id'])); pdo_delete(DBUtil::$TABLE_WKJ_USER, array("kid" => $wkj['id'])); }
/** * author: weizan012 QQ:800083075 * 绑定用户 */ public function doMobileBindUser() { global $_W, $_GPC; $egid = $_GPC['egid']; $tel = $_GPC['tel']; $uname = $_GPC['uname']; $openid = $this->getOpenId(); $user = DBUtil::findUnique(DBUtil::$TABLE_EGG_USER, array(":egid" => $egid, ":openid" => $openid)); $res = array(); if (empty($user)) { $res['code'] = 500; $res['msg'] = "用户不存在"; die(json_encode($res)); } DBUtil::updateById(DBUtil::$TABLE_EGG_USER, array('tel' => $tel, 'uname' => $uname), $user['id']); $res['code'] = 200; die(json_encode($res)); }
$notify = new Notify_pub(); $notify->saveData($input); $data = $notify->getData(); $ordersetting = DBUtil::findUnique(DBUtil::$TABLE_ORDER_SETTING, array(":appid" => $data['appid'])); if (empty($data)) { $notify->setReturnParameter("return_code", "FAIL"); $notify->setReturnParameter("return_msg", "通用订单参数格式校验错误"); WeUtility::logging('info', "通用订单回复参数格式校验错误"); exit($notify->createXml()); } if ($data['result_code'] != 'SUCCESS' || $data['return_code'] != 'SUCCESS') { $notify->setReturnParameter("return_code", "FAIL"); $notify->setReturnParameter("return_msg", "通用订单参数格式校验错误"); WeUtility::logging('info', "通用订单回复参数格式校验错误"); exit($notify->createXml()); } //更新表订单信息 WeUtility::logging('info', "通知订单更新"); if ($notify->checkSign($ordersetting['shkey'])) { DBUtil::update(DBUtil::$TABLE_ORDER_ORDER, array("status" => 3, 'paytime' => TIMESTAMP), array("outno" => $data['out_trade_no'])); $order = DBUtil::findUnique(DBUtil::$TABLE_ORDER_ORDER, array(":outno" => $data['out_trade_no'])); $notify->setReturnParameter("return_code", "SUCCESS"); $notify->setReturnParameter("return_msg", "OK"); exit($notify->createXml()); } else { $notify->setReturnParameter("return_code", "FAIL"); $notify->setReturnParameter("return_msg", "通用订单签名校验错误"); WeUtility::logging('info', "通用订单签名校验错误"); exit($notify->createXml()); } WeUtility::logging('info', "通用订单更新回复数据" . $data);
/** * author: 微赞 * @return bool * 查找模板消息 */ public function findTemplateSetting() { $ordertempalte = DBUtil::findUnique(DBUtil::$TABLE_ORDER_TEMPLATE, array(':weid' => $this->weid)); return $ordertempalte; }
* @url http://www.cninone.com/ */ error_reporting(1); define('IN_MOBILE', true); define("MON_WKJ", "mon_wkj"); require '../../framework/bootstrap.inc.php'; require_once "WxPayPubHelper/WxPayPubHelper.php"; require_once "monUtil.class.php"; require_once "dbutil.class.php"; $input = file_get_contents('php://input'); WeUtility::logging('info', "微砍价异步通知数据" . $input); //WeUtility::logging('info',"商户key数据".$kjsetting); $notify = new Notify_pub(); $notify->saveData($input); $data = $notify->getData(); $kjsetting = DBUtil::findUnique(DBUtil::$TABLE_WKJ_SETTING, array(":appid" => $data['appid'])); if (empty($data)) { $notify->setReturnParameter("return_code", "FAIL"); $notify->setReturnParameter("return_msg", "参数格式校验错误"); WeUtility::logging('info', "微砍价回复参数格式校验错误"); exit($notify->createXml()); } if ($data['result_code'] != 'SUCCESS' || $data['return_code'] != 'SUCCESS') { $notify->setReturnParameter("return_code", "FAIL"); $notify->setReturnParameter("return_msg", "参数格式校验错误"); WeUtility::logging('info', "微砍价回复参数格式校验错误"); exit($notify->createXml()); } //更新表订单信息 WeUtility::logging('info', "通知订单更新"); if ($notify->checkSign($kjsetting['shkey'])) {
public function findKJsetting() { $kjsetting = DBUtil::findUnique(DBUtil::$TABLE_WKJ_SETTING, array(":weid" => $this->weid)); return $kjsetting; }