PHP DB_test::insert方法代码示例

 public function authorMenuCount()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $appmnuid = $arr_body['appmnuid'];
     $authorid = $arr_channelinfo['authorid'];
     $query = "select fd_appmnuc_count as count from tb_appmenucout where fd_appmnuc_authorid = '{$authorid}'\n                and fd_appmnuc_appmnuid = '{$appmnuid}' ";
     $db->query($query);
     if ($db->nf()) {
         $arr_val = $db->get_one($query);
         $count = $arr_val['count'];
         $querywhere = "  fd_appmnuc_authorid = '{$authorid}'\n                and fd_appmnuc_appmnuid = '{$appmnuid}'";
         $dateArray['fd_appmnuc_count'] = $count + 1;
         $db->update("tb_appmenucout", $dateArray, $querywhere);
     } else {
         $dateArray['fd_appmnuc_authorid'] = $authorid;
         $dateArray['fd_appmnuc_appmnuid'] = $appmnuid;
         $dateArray['fd_appmnuc_count'] = $memo;
         $db->insert("tb_appmenucout", $dateArray);
     }
     $listid = $db->insert_id();
     //取出刚插入的记录的主关键值的id
     $arr_message = array("result" => "success", "message" => "插入数据成功!", "retcode" => "0");
     $retcode = "0";
     //反馈状态 0 成功 200 自定义错误
     $arr_msg['msgbody']['result'] = $arr_message['result'];
     $arr_msg['msgbody']['message'] = $arr_message['message'];
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }

 function payOrderRq()
 {
     global $weburl;
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $authorid = trim($arr_channelinfo['authorid']);
     $paytype = 'orderbuy';
     $orderpaytypeid = trim($arr_body['orderpaytypeid']);
     $orderprodureid = trim($arr_body['orderprodureid']);
     //支付类型id
     $ordernum = trim($arr_body['ordernum']);
     //充值金额
     $orderprice = trim(u2g($arr_body['orderprice']));
     //实际支付金额
     $ordermoney = trim(u2g($arr_body['ordermoney']));
     //订单金额
     $ordershaddressid = trim($arr_body['ordershaddressid']);
     //手机所属地区
     $oredershaddress = trim(u2g($arr_body['oredershaddress']));
     //银行卡号
     $ordershman = trim(u2g($arr_body['ordershman']));
     //银行卡关联id tb_banckcard.fd_bankcard_id
     $ordershphone = trim(u2g($arr_body['ordershphone']));
     //认证信息
     $orderfucardno = trim(u2g($arr_body['orderfucardno']));
     //认证信息
     $orderfucardbank = trim(u2g($arr_body['orderfucardbank']));
     //认证信息
     $ordermemo = trim(u2g($arr_body['ordermemo']));
     //认证信息
     $agentno = trim(u2g($arr_body['agentno']));
     //认证信息
     $orderpaytype = trim($arr_body['paytype']);
     $promoney = trim(u2g($arr_body['promoney']));
     //认证信息
     $yunmoney = trim(u2g($arr_body['yunmoney']));
     //认证信息
     $produrename = trim(u2g($arr_body['produrename']));
     $bkmoney = $ordermoney;
     //promoney+yunmoney
     $rechabkcardno = makeorderno("orderglist", "orderlist", "orl");
     $arr_bkinfo = BankPayInfo::bankpayorder($authorid, $paycardid, $bkmoney, $orderfucardno);
     $bkntno = trim($arr_bkinfo['bkntno']);
     $sdcrid = trim($arr_bkinfo['sdcrid']);
     if ($agentno != "") {
         // $cusid =$this->checkcusagentno($agentno);
         $query = "select fd_cus_id as cusid from tb_customer where fd_cus_no = '{$agentno}'";
         if ($db->execute($query)) {
             $arr_cusinfo = $db->get_one($query);
             $cusid = $arr_cusinfo['cusid'];
         } else {
             $arr_message = array("result" => "failure", "message" => "对不起，您填写的代理商代号错误，请重新填写!");
             $retcode = "200";
             //反馈状态 0 成功 200 自定义错误
             $arr_msg['msgbody']['result'] = $arr_message['result'];
             $arr_msg['msgbody']['message'] = $arr_message['message'];
             $arr_msg['msgbody']['bkntno'] = $bkntno;
             $returnvalue = array("msgbody" => $arr_msg['msgbody']);
             $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
             return $returnval;
             exit;
         }
     }
     $datetime = date("Y-m-d H:i:s");
     $date = date("Y-m-d");
     //$bkmoney  =
     $bkorderNumber = trim($arr_bkinfo['bkorderNumber']);
     $datadetailArray['fd_orderlist_paytype'] = $paytype;
     $datadetailArray['fd_orderlist_no'] = $listno;
     $datadetailArray['fd_orderlist_authorid'] = $authorid;
     $datadetailArray['fd_orderlist_bkntno'] = $bkntno;
     $datadetailArray['fd_orderlist_date'] = $date;
     $datadetailArray['fd_orderlist_payrq'] = '01';
     //刚请求的交易码状态为01
     $datadetailArray['fd_orderlist_bkordernumber'] = $bkorderNumber;
     $datadetailArray['fd_orderlist_sdcrid'] = $sdcrid;
     $datadetailArray['fd_orderlist_produreid'] = $orderprodureid;
     $datadetailArray['fd_orderlist_produrename'] = $produrename;
     $datadetailArray['fd_orderlist_cusid'] = $cusid;
     //分润代理商
     $datadetailArray['fd_orderlist_num'] = $ordernum;
     $datadetailArray['fd_orderlist_price'] = $orderprice;
     $datadetailArray['fd_orderlist_promoney'] = $promoney;
     $datadetailArray['fd_orderlist_yunmoney'] = $yunmoney;
     $datadetailArray['fd_orderlist_ordermoney'] = $ordermoney;
     $datadetailArray['fd_orderlist_shaddressid'] = $ordershaddressid;
     $datadetailArray['fd_orderlist_shaddress'] = $oredershaddress;
     $datadetailArray['fd_orderlist_shman'] = $ordershman;
     $datadetailArray['fd_orderlist_shphone'] = $ordershphone;
     $datadetailArray['fd_orderlist_fucardno'] = $orderfucardno;
     $datadetailArray['fd_orderlist_fucardbank'] = $orderfucardbank;
     $datadetailArray['fd_orderlist_memo'] = $ordermemo;
     $datadetailArray['fd_orderlist_datetime'] = $datetime;
     $datadetailArray['fd_orderlist_agentno'] = $agentno;
     $db->insert("tb_orderglist", $datadetailArray);
     $listid = $db->insert_id();
     $arr_message = array("result" => "success", "message" => "请求交易码成功!");
     $retcode = "0";
//.........这里部分代码省略.........

 function RechaMoneyRq()
 {
     global $weburl;
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $authorid = trim($arr_channelinfo['authorid']);
     $paytype = 'qqrecharge';
     $paycardid = trim($arr_body['paycardid']);
     $paytypeid = trim($arr_body['rechapaytypeid']);
     //支付类型id
     $rechamoney = trim($arr_body['rechamoney']);
     //充值金额
     $rechapaymoney = trim(u2g($arr_body['rechapaymoney']));
     //实际支付金额
     $rechaqq = trim(u2g($arr_body['rechaqq']));
     //充值手机号码
     $qqhasrechamoney = $this->readQQhasRechamoney($rechaqq);
     $allqqremoney = $qqhasrechamoney + $rechamoney;
     if ($allqqremoney > 5000) {
         $retcode = "200";
         $arr_msg['msgbody']['result'] = "failure";
         $arr_msg['msgbody']['message'] = "对不起，每个QQ号码每天累计充值Q币数不能大于5000!";
         $returnvalue = array("msgbody" => $arr_msg['msgbody']);
         $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
         return $returnval;
     }
     $rechaqqprov = trim($arr_body['rechaqqprov']);
     //手机所属地区
     $rechabkcardno = trim(u2g($arr_body['rechabkcardno']));
     //银行卡号
     $rechabkcardid = trim($arr_body['rechabkcardid']);
     //银行卡关联id tb_banckcard.fd_bankcard_id
     $merReserved = trim(u2g($arr_body['merReserved']));
     //认证信息
     // $current = trim($arr_body['current']); //币种
     // $paycardid = trim(GetPayCalcuInfo::readpaycardid($paycardid)); //刷卡器设备号
     $arr_paycard = GetPayCalcuInfo::readpaycardid($arr_body['paycardid'], $authorid);
     //刷卡器设备号
     $paycardid = $arr_paycard['paycardid'];
     //刷卡器id
     $cusid = trim($arr_paycard['cusid']);
     //代理商
     $paycardkey = trim($arr_paycard['paycardkey']);
     //刷卡器key
     //$feebankid = getbankid($shoucardbank); //获得银行id返回string
     $onepayfee = $this->readRechacostmoney($rechamoney);
     $payfee = $onepayfee * $rechamoney;
     //金额也就是数量
     $bkmoney = $rechapaymoney;
     $arr_bkinfo = BankPayInfo::bankpayorder($authorid, $paycardid, $bkmoney, $rechabkcardno);
     $bkntno = trim($arr_bkinfo['bkntno']);
     $sdcrid = trim($arr_bkinfo['sdcrid']);
     $sdcrpayfee = substr($arr_bkinfo['sdcrpayfee'], 0, -1);
     //银联收取明盛浮动费率
     $sdcrpayfeemoney = $bkmoney * $sdcrpayfee / 100 > $arr_bkinfo['minsdcrpayfee'] ? $bkmoney * $sdcrpayfee / 100 : $arr_bkinfo['minsdcrpayfee'];
     $paydate = date("Y-m-d H:i:s");
     $today = date("Ymd");
     //$bkmoney  =
     $bkorderNumber = trim($arr_bkinfo['bkorderNumber']);
     $listno = makeorderno("qqrechargelist", "mrclist", "mrc");
     $datadetailArray['fd_mrclist_no'] = $listno;
     $datadetailArray['fd_mrclist_paycardid'] = $paycardid;
     $datadetailArray['fd_mrclist_authorid'] = $authorid;
     $datadetailArray['fd_mrclist_bkntno'] = $bkntno;
     $datadetailArray['fd_mrclist_paydate'] = $paydate;
     $datadetailArray['fd_mrclist_payrq'] = '01';
     //刚请求的交易码状态为01
     $datadetailArray['fd_mrclist_paytypeid'] = $paytypeid;
     //手机充值支付类型 跟paytype 无任何关系
     $datadetailArray['fd_mrclist_paytype'] = $paytype;
     //业务类型
     $datadetailArray['fd_mrclist_bkordernumber'] = $bkorderNumber;
     $datadetailArray['fd_mrclist_sdcrpayfeemoney'] = $sdcrpayfeemoney;
     $datadetailArray['fd_mrclist_sdcrid'] = $sdcrid;
     $datadetailArray['fd_mrclist_rechamoney'] = $rechamoney;
     $datadetailArray['fd_mrclist_bkmoney'] = $bkmoney;
     $datadetailArray['fd_mrclist_qq'] = $rechaqq;
     $datadetailArray['fd_mrclist_paymoney'] = $rechapaymoney;
     $datadetailArray['fd_mrclist_payfee'] = $payfee;
     $datadetailArray['fd_mrclist_qqprov'] = u2g($rechaqqprov);
     $datadetailArray['fd_mrclist_bankcardno'] = $rechabkcardno;
     $datadetailArray['fd_mrclist_bankcardid'] = $rechabkcardid;
     $datadetailArray['fd_mrclist_bankcardbank'] = $rechabkcardname;
     $datadetailArray['fd_mrclist_date'] = $today;
     $datadetailArray['fd_mrclist_datetime'] = $paydate;
     $datadetailArray['fd_mrclist_cusid'] = $cusid;
     $db->insert("tb_qqrechargelist", $datadetailArray);
     $listid = $db->insert_id();
     //$listid = $db->insert_id();
     // $method = 'in';
     // $method = u2g($method);
     //$gettrue = AgentPayglist :: insertPayglist($this->reqxmlcontext, $bkntno, $listid, $ccgno, $paytype, $method, $arr_feeinfo);
     $arr_message = array("result" => "success", "message" => "请求交易码成功!");
     $retcode = "0";
     //反馈状态 0 成功 200 自定义错误
     $arr_msg['msgbody']['result'] = $arr_message['result'];
     $arr_msg['msgbody']['message'] = $arr_message['message'];
     $arr_msg['msgbody']['bkntno'] = $bkntno;
//.........这里部分代码省略.........

	
}*/
foreach ($arr_coupbkntno as $val) {
    if (checkagpminfo::checkagpmbkntno($val)) {
        foreach ($arr_coupval[$val] as $key => $value) {
            $query = "update tb_agentpaymoneylist set fd_agpm_" . $key . " = '{$value}' where fd_agpm_bkntno = '{$val}'";
            $db->query($query);
            //echo $query."</br>";
        }
    } else {
        foreach ($arr_coupval[$val] as $key => $value) {
            $apmgkey = "fd_agpm_" . $key;
            $arr_insert[$i][$apmgkey] = $value;
        }
        foreach ($arr_insert as $dataArray) {
            $db->insert('tb_agentpaymoneylist', $dataArray);
        }
        //$query = "insert into  tb_agentpaymoneylist set fd_agpm_".$key." = '$value'";
        //$db->query($query);
    }
    $i++;
}
class checkagpminfo
{
    public static function checkagpmbkntno($bkntno)
    {
        $db = new DB_test();
        $query = "select fd_agpm_bkntno as bkntno  from tb_agentpaymoneylist where fd_agpm_bkntno = '{$bkntno}'";
        //$query="select fd_agpm_bkntno as bkntno  from tb_agentpaymoneylist where fd_agpm_bkntno = '201308212125170033372'";
        $db->query($query);
        if ($db->nf()) {

 public function YiBaoPayFeedback($payResult, $orderId)
 {
     if ($payResult["r1_Code"] == "1") {
         $db = new DB_test();
         $query = "update  tb_transfermoneyglist set fd_tfmglist_payrq ='00' ,fd_tfmglist_paydate = NOW(), fd_tfmglist_bkntno = '" . $payResult['r2_TrxId'] . "'  where fd_tfmglist_bkordernumber = '{$orderId}'";
         $db->query($query);
         $query = "update  tb_agentpaymoneylist set fd_agpm_payrq = '00', fd_agpm_bkntno = '" . $payResult['r2_TrxId'] . "'  where fd_agpm_bkordernumber = '{$orderId}'";
         $db->query($query);
         $query = "select 1 from tb_cus_fenrunglist where 1 and  fd_frlist_bkordernumber = '" . $orderId . "' limit 1";
         if ($db->execute($query)) {
         } else {
             $query = "SELECT fd_tfmglist_authorid AS authorid, fd_author_cusid AS cusid, fd_tfmglist_paycardid AS paycardid, fd_tfmglist_paydate AS paydate, fd_tfmglist_paymoney AS paymoney, fd_tfmglist_payfee AS payfee, fd_tfmglist_sdcrpayfeemoney AS sdcrpayfeemoney, fd_tfmglist_paytype AS paytype, fd_tfmglist_sdcrpayfeemoney FROM tb_transfermoneyglist WHERE fd_tfmglist_bkordernumber = '{$orderId}'";
             if ($db->execute($query)) {
                 $arr_info = $db->get_one($query);
                 $cusfee = 0;
                 $tfbfenrun = 0;
                 $cusfeeResult = getcusfenrun::get_cusfenrun($arr_info['cusid'], $arr_info['paytype'], $arr_info['payMoney'], $arr_info['fd_tfmglist_sdcrpayfeemoney'], $arr_info['fd_tfmglist_payfee'], 0, date("Y-m-d"), null, null);
                 $cusfee = $cusfeeResult["cusfee"];
                 $tfbfenrun = $arr_cusfee['tfbfenrun'];
                 unset($dateArray);
                 $dateArray['fd_frlist_authorid'] = $arr_info['authorid'];
                 $dateArray['fd_frlist_cusid'] = $arr_info['cusid'];
                 $dateArray['fd_frlist_paycardid'] = $arr_info['paycardid'];
                 $dateArray['fd_frlist_paydate'] = $arr_info['paydate'];
                 $dateArray['fd_frlist_paymoney'] = $arr_info['paymoney'];
                 $dateArray['fd_frlist_payfee'] = $arr_info['payfee'];
                 $dateArray['fd_frlist_cusfee'] = $cusfee;
                 $dateArray['fd_frlist_bkordernumber'] = $orderId;
                 $dateArray['fd_frlist_payrq'] = '00';
                 $dateArray['fd_frlist_paytype'] = $arr_info['paytype'];
                 $dateArray['fd_frlist_sdcrid'] = 3;
                 $dateArray['fd_frlist_sdcrpayfeemoney'] = $arr_info['sdcrpayfeemoney'];
                 $dateArray['fd_frlist_tfbfenrun'] = $tfbfenrun;
                 $dateArray['fd_frlist_datetime'] = date("Y-m-d H:i:s");
                 $db->insert("tb_cus_fenrunglist", $dateArray);
             }
         }
     }
 }

 private function customerProfit($orderInDB)
 {
     $logger = Logger::getLogger('gamerecharge');
     $logger->debug("start customerProfit");
     if (is_array($orderInDB) && count($orderInDB) == 1 && $orderInDB[0]['fd_grclist_cusid'] != null) {
         $profitArray = array();
         $profitArray['fd_frlist_authorid'] = $orderInDB[0]['fd_grclist_authorid'];
         $profitArray['fd_frlist_cusid'] = $orderInDB[0]['fd_grclist_cusid'];
         $profitArray['fd_frlist_paycardid'] = $orderInDB[0]['fd_grclist_paycardid'];
         $profitArray['fd_frlist_paydate'] = date("Ymd");
         $profitArray['fd_frlist_paymoney'] = $orderInDB[0]['fd_grclist_paymoney'];
         $profitArray['fd_frlist_payfee'] = $orderInDB[0]['fd_grclist_payfee'];
         $profitArray['fd_frlist_cusfee'] = $orderInDB[0]['fd_grclist_payfee'] * 0.27;
         $profitArray['fd_frlist_bkordernumber'] = $orderInDB[0]['fd_grclist_bkordernumber'];
         $profitArray['fd_frlist_payrq'] = '00';
         $profitArray['fd_frlist_paytype'] = 'game';
         $profitArray['fd_frlist_datetime'] = date("Y-m-d H:i:s");
         $profitArray['fd_frlist_ifjsfenrun'] = 0;
         $profitArray['fd_frlist_sdcrid'] = $orderInDB[0]['fd_grclist_sdcrid'];
         $logger->debug("process customerProfit : " . print_r($profitArray, true));
         $db = new DB_test();
         $db->insert("tb_cus_fenrunglist", $profitArray);
         $logger->info("complete customerProfit : " . print_r($profitArray, true));
     }
 }

 function payagentOrderRq()
 {
     global $weburl;
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $authorid = trim($arr_channelinfo['authorid']);
     $agentid = trim($arr_channelinfo['agentid']);
     $paytype = 'agentbuy';
     $orderprodureid = trim($arr_body['orderprodureid']);
     //支付类型id
     $ordernum = trim($arr_body['ordernum']);
     //充值金额
     $orderprice = trim(u2g($arr_body['orderprice']));
     //实际支付金额
     $ordermoney = trim(u2g($arr_body['ordermoney']));
     //订单金额
     $orderfucardno = trim(u2g($arr_body['orderfucardno']));
     //认证信息
     $orderfucardbank = trim(u2g($arr_body['orderfucardbank']));
     //认证信息
     $ordermemo = trim(u2g($arr_body['ordermemo']));
     //认证信息
     $agentno = trim(u2g($arr_body['agentno']));
     //认证信息
     $arr_paycard = GetPayCalcuInfo::readpaycardid($arr_body['paycardid'], $authorid);
     //刷卡器设备号
     $paycardid = $arr_paycard['paycardid'];
     //刷卡器id
     $cusid = trim($arr_paycard['cusid']);
     //代理商
     $ordermemo = "自订刷卡器" . $ordernum;
     $bkmoney = $ordermoney;
     //promoney+yunmoney
     $paymoney = $ordermoney;
     $listno = makeorderno("salelist", "selt", "xs");
     $arr_bkinfo = BankPayInfo::bankpayorder($authorid, $paycardid, $bkmoney, $orderfucardno);
     $bkntno = trim($arr_bkinfo['bkntno']);
     $sdcrid = trim($arr_bkinfo['sdcrid']);
     $datetime = date("Y-m-d H:i:s");
     $date = date("Y-m-d");
     $bkorderNumber = trim($arr_bkinfo['bkorderNumber']);
     $type = "app";
     //自订
     $datadetailArray['fd_selt_paytype'] = $paytype;
     $datadetailArray['fd_selt_no'] = $listno;
     $datadetailArray['fd_selt_authorid'] = $authorid;
     $datadetailArray['fd_selt_bkntno'] = $bkntno;
     $datadetailArray['fd_selt_date'] = $date;
     $datadetailArray['fd_selt_payrq'] = '01';
     //刚请求的交易码状态为01
     $datadetailArray['fd_selt_bkordernumber'] = $bkorderNumber;
     $datadetailArray['fd_selt_sdcrid'] = $sdcrid;
     $datadetailArray['fd_selt_produreid'] = $orderprodureid;
     $datadetailArray['fd_selt_allquantity'] = $ordernum;
     $datadetailArray['fd_selt_saleprice'] = $orderprice;
     $datadetailArray['fd_selt_fucardno'] = $orderfucardno;
     $datadetailArray['fd_selt_fucardbank'] = $orderfucardbank;
     $datadetailArray['fd_selt_memo'] = u2g($ordermemo);
     $datadetailArray['fd_selt_datetime'] = $datetime;
     $datadetailArray['fd_selt_cusid'] = $agentid;
     //代理商id
     $datadetailArray['fd_selt_paymoney'] = $paymoney;
     //代理商id
     $datadetailArray['fd_selt_authorid'] = $authorid;
     //代理商id
     $datadetailArray['fd_selt_type'] = $type;
     $datadetailArray['fd_selt_skfs'] = '5';
     //在线支付
     $db->insert("tb_salelist", $datadetailArray);
     $listid = $db->insert_id();
     $arr_message = array("result" => "success", "message" => "请求交易码成功!");
     $retcode = "0";
     //反馈状态 0 成功 200 自定义错误
     $arr_msg['msgbody']['result'] = $arr_message['result'];
     $arr_msg['msgbody']['message'] = $arr_message['message'];
     $arr_msg['msgbody']['bkntno'] = $bkntno;
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }