Exemplos de DBUtil::findUnique em PHP

Exemplo n.º 1

Arquivo: module.php Projeto: eduNeusoft/weixin

 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']));
 }

Exemplo n.º 2

Arquivo: module.php Projeto: wisemyth/weizan

 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']));
 }

Exemplo n.º 3

Arquivo: module.php Projeto: ChainBoy/wxfx

 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']));
 }

Exemplo n.º 4

Arquivo: site.php Projeto: eduNeusoft/weixin

 /**
  * 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));
 }

Exemplo n.º 5

Arquivo: notify.php Projeto: aspnmy/weizan

$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);

Exemplo n.º 6

Arquivo: site.php Projeto: aspnmy/weizan

 /**
  * author: 微赞
  * @return bool
  * 查找模板消息
  */
 public function findTemplateSetting()
 {
     $ordertempalte = DBUtil::findUnique(DBUtil::$TABLE_ORDER_TEMPLATE, array(':weid' => $this->weid));
     return $ordertempalte;
 }

Exemplo n.º 7

Arquivo: notify.php Projeto: ChainBoy/wxfx

 * @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'])) {

Exemplo n.º 8

Arquivo: site.php Projeto: ChainBoy/wxfx

 public function findKJsetting()
 {
     $kjsetting = DBUtil::findUnique(DBUtil::$TABLE_WKJ_SETTING, array(":weid" => $this->weid));
     return $kjsetting;
 }