当前位置: 首页>>代码示例>>PHP>>正文


PHP DB_test::get_all方法代码示例

本文整理汇总了PHP中DB_test::get_all方法的典型用法代码示例。如果您正苦于以下问题:PHP DB_test::get_all方法的具体用法?PHP DB_test::get_all怎么用?PHP DB_test::get_all使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在DB_test的用法示例。


在下文中一共展示了DB_test::get_all方法的10个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: validateUser

 public function validateUser()
 {
     $retcode = "200";
     $arr_message = array("result" => "fail", "message" => "操作出现异常,请稍后再试!");
     $db = new DB_test();
     $phonenumber = trim($this->arr_body['phonenumber']);
     $query = "SELECT fd_author_id FROM tb_author WHERE fd_author_username = '" . $phonenumber . "'";
     $authorid = $db->get_all($query);
     if ($authorid != 0 && count($authorid) > 0) {
         $authorid = $authorid[0]["fd_author_id"];
         $query = "SELECT Q.fd_question_contect  AS que, A.fd_answer AS answer \n\t\t\t\t\tFROM tb_safeguard_secque_useranswer AS A \n\t\t\t\t\tINNER JOIN tb_safeguard_secque AS Q ON A.fd_question_id = Q.fd_question_id \n\t\t\t\t\tWHERE A.fd_author_id = " . $authorid;
         $db->query($query);
         $retcode = "0";
         if ($db->nf() > 0) {
             $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
             $arr_msg['msgbody']['authorid'] = $authorid;
             $arr_message = array("result" => "success", "message" => "成功获取密保问题");
         } else {
             $retcode = "200";
             $arr_message = array("result" => "failure", "message" => "您还未设置过密保问题");
         }
     } else {
         $retcode = "200";
         $arr_message = array("result" => "failure", "message" => "该手机号还未注册过通付宝账号");
     }
     $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;
 }
开发者ID:Xiaoyuyexi,项目名称:client-server,代码行数:31,代码来源:ApiSafeGuard.php

示例2: RelateAgent

	public function RelateAgent($authorId, $agentCode)
	{
$logger = Logger::getLogger('AuthorInfo');
$logger->info("开始绑定代理商 : authorId : $authorId, agentCode : $agentCode");
		$db = new DB_test();
		$query = "SELECT fd_cus_id FROM tb_customer WHERE fd_cus_no = '$agentCode'";
$logger->debug("开始绑定代理商 : query : $query");
		$agentId = $db->get_all($query);
		if(!is_array($agentId) || count($agentId) != 1)
		{
$logger->debug("开始绑定代理商 : return 0");
			return 0;
		}
		else
		{
			$query = "UPDATE tb_author SET fd_author_bdagentno = '$agentCode', fd_author_bdagentid = " . $agentId[0]["fd_cus_id"] . ", fd_author_bdagenttime = NOW() WHERE fd_author_id = $authorId";
$logger->debug("开始绑定代理商 : query : $query");
			$db->query($query);
			return 1;
		}
	}
开发者ID:nonenull,项目名称:doc,代码行数:21,代码来源:register.php

示例3: foreach

    $msgstart = 0;
}
$all_paymoney = 0;
$query = "select *,case\n        when fd_mrclist_payrq ='01' then '" . $arr_state[0] . "'\n        when fd_mrclist_payrq ='00' then '" . $arr_state[1] . "'" . "when fd_mrclist_payrq ='03' then '" . $arr_state[2] . "'\n        else '" . $arr_state[4] . "' END  fd_mrclist_payrq,\n        fd_mrclist_ofstate,\n       case\n        when fd_mrclist_ofstate ='1' then '<font color=blue>充值成功</font>'\n        when fd_mrclist_ofstate ='-1' then '正在充值'\n        else '<font color=red>充值失败</font>' END  ofstate\n         from  tb_mobilerechargelist\n          left join tb_author  on fd_author_id  = fd_mrclist_authorid\n          left join tb_sendcenter  on fd_sdcr_id  = fd_mrclist_sdcrid\n          where 1\n\t\t\tand  (fd_mrclist_payrq = '00') and fd_mrclist_sdcrid<100  order by fd_mrclist_id desc ";
$db->query($query);
//and fd_agpm_paytype <>'recharge'
$total = $db->num_rows($result);
pageft($total, $displaypg, $url);
if ($firstcount < 0) {
    $firstcount = 0;
}
$count = $firstcount;
$query = "{$query} limit {$firstcount},{$displaypg}";
$rows = $db->num_rows();
if ($db->execute($query)) {
    $arr_val = $db->get_all($query);
}
if (is_array($arr_val)) {
    foreach ($arr_val as $key => $arr_val) {
        $tcount++;
        if ($arr_val['fd_mrclist_ofstate'] != '1') {
            $arr_val['eidt_ofstate'] = '<a href="javascript:void(0);" name="' . $arr_val['fd_mrclist_authorid'] . '" class="eidt_ofstate" rel="' . $arr_val['fd_mrclist_bkntno'] . '">再次充值</a>';
        } else {
            $arr_val['eidt_ofstate'] = "";
        }
        $t->set_var($arr_val);
        $arr_allval['all_paymoney'] += $arr_val['fd_mrclist_paymoney'];
        $arr_allval['all_rechamoney'] += $arr_val['fd_mrclist_rechamoney'];
        $t->parse("headbxbks", "HEADBXBK", true);
    }
} else {
开发者ID:Xiaoyuyexi,项目名称:client-server,代码行数:31,代码来源:mobilerecharge_list.php

示例4: PayFeedback

 public function PayFeedback($payResult, $orderId)
 {
     $now = time();
     $logger = Logger::getLogger('mobilerecharge');
     $logger->info("开始处理手机充值支付后返回数据({$now}) : 订单号({$orderId}), 返回的支付信息" . print_r($payResult, true));
     if ($payResult['orderId'] != "" && $orderId != "" && $payResult['orderId'] != $orderId || $payResult['orderId'] == "" && $orderId == "") {
         $logger->error("处理手机充值支付后返回数据出错({$now}) : 订单号有错误(" . $payResult['orderId'] . "不等于" . $orderId . ")");
         return;
     }
     $orderId = $orderId != "" ? $orderId : $payResult['orderId'];
     $logger->debug("正在处理手机充值支付后返回数据({$now}) : 通付宝订单号({$orderId})");
     if ($payResult['returnCode'] != "1" && $payResult['transNumber'] == "") {
         return;
     }
     $db = new DB_test();
     if ($payResult['returnCode'] == "1") {
         $query = "SELECT fd_mrclist_rechaphone, fd_mrclist_rechamoney, fd_mrclist_authorid, fd_mrclist_cusid, fd_mrclist_paycardid, fd_mrclist_bkmoney, fd_mrclist_payfee, fd_mrclist_cusfee, fd_mrclist_sdcrid FROM tb_mobilerechargelist \n\t\t\tWHERE fd_mrclist_bkordernumber = '" . $orderId . "' AND fd_mrclist_payrq != '00'";
         $dataInDB = $db->get_all($query);
         if (is_array($dataInDB) && count($dataInDB) == 1) {
             $logger->debug("正在处理手机充值支付后返回数据({$now}) : 通过通付宝订单号({$orderId})获取数据" . print_r($dataInDB, true));
             // 给代理商分润
             $query = "SELECT 1 FROM tb_cus_fenrunglist WHERE fd_frlist_bkordernumber = '" . $orderId . "' LIMIT 1";
             $logger->debug("正在处理手机充值支付后返回数据({$now}) : 判断是否需要添加数据到tb_cus_fenrunglist表 " . $query);
             $hasShareInterest = $db->execute($query);
             if (!$hasShareInterest) {
                 $logger->debug("正在处理手机充值支付后返回数据({$now}) : 需要添加数据到tb_cus_fenrunglist表");
                 $query = "INSERT INTO tb_cus_fenrunglist (fd_frlist_authorid, fd_frlist_cusid, fd_frlist_paycardid, fd_frlist_paydate, fd_frlist_paymoney, fd_frlist_payfee, fd_frlist_cusfee, fd_frlist_bkordernumber, fd_frlist_payrq, fd_frlist_paytype, fd_frlist_datetime, fd_frlist_ifjsfenrun, fd_frlist_sdcrid) VALUES (" . $dataInDB[0]['fd_mrclist_authorid'] . ", " . $dataInDB[0]['fd_mrclist_cusid'] . ", '" . $dataInDB[0]['fd_mrclist_paycardid'] . "', NOW(), " . $dataInDB[0]['fd_mrclist_bkmoney'] . ", " . $dataInDB[0]['fd_mrclist_payfee'] . ", " . $dataInDB[0]['fd_mrclist_cusfee'] . ", '" . $orderId . "', '00', 'mobilerecharge', NOW(), 0, '" . $dataInDB[0]['fd_mrclist_sdcrid'] . "');";
                 $db->query($query);
                 $logger->debug("正在处理手机充值支付后返回数据({$now}) : 代理商分润时执行的SQL语句" . $query);
             } else {
                 $logger->debug("正在处理手机充值支付后返回数据({$now}) : 代理商分润时执行的SQL语句");
             }
             $data = array('FUNC' => 'MOBILE_RECHARGE', 'phone' => $dataInDB[0]['fd_mrclist_rechaphone'], 'money' => $dataInDB[0]['fd_mrclist_rechamoney'], 'orderId' => $orderId);
             $logger->info("完成处理手机充值支付后返回数据({$now}) : 发起充值 : " . print_r($data, true));
             AsyncCall($data);
         } else {
             $logger->error("完成处理手机充值支付后返回数据({$now}) : 通过通付宝订单号({$orderId})获取的数据有误 : " . print_r($dataInDB, true));
         }
     }
     // 返回的数据回写进通付宝数据库
     if ($payResult['returnCode'] == "1") {
         if ($payResult['transNumber'] != "") {
             // 支付成功,易宝交易号不为空
             $query = "UPDATE tb_mobilerechargelist SET fd_mrclist_bkntno = '" . $payResult['transNumber'] . "', fd_mrclist_payrq = '00' WHERE fd_mrclist_bkordernumber = '" . $orderId . "'";
         } else {
             // 支付成功,易宝交易号为空
             $query = "UPDATE tb_mobilerechargelist SET fd_mrclist_payrq = '00' WHERE fd_mrclist_bkordernumber = '" . $orderId . "'";
         }
     } else {
         if ($payResult['transNumber'] != "") {
             // 支付不成功,易宝交易号不为空
             $query = "UPDATE tb_mobilerechargelist SET fd_mrclist_bkntno = '" . $payResult['transNumber'] . "' WHERE fd_mrclist_bkordernumber = '" . $orderId . "'";
         }
     }
     $logger->debug("正在处理手机充值支付后返回数据({$now}) : query({$query})");
     if ($query != "") {
         $db->query($query);
     }
     $logger->debug("正在处理手机充值支付后返回数据({$now}) : 通付宝订单号({$orderId})回写进通付宝数据库");
 }
开发者ID:Xiaoyuyexi,项目名称:client-server,代码行数:60,代码来源:mobilerecharge.php

示例5: getmoreFileimg

 function getmoreFileimg($scatid, $dateid, $limitnum = 6)
 {
     global $g_showpic;
     $db = new DB_test();
     if ($dateid) {
         $querywhere = " and fd_cat_dateid='{$dateid}'";
     } else {
         $queryorder = " limit 0,{$limitnum}";
     }
     $query = "select fd_cat_thumurl as thumrul,fd_cat_urllink as urllink,fd_cat_no as no,fd_cat_id as id,fd_cat_url as url,fd_cat_id as id,fd_cat_name as content,fd_cat_display as display from tb_upload_category_list where fd_cat_scatid='{$scatid}' {$querywhere}  order by fd_cat_no asc {$queryorder}";
     if ($db->execute($query)) {
         $arr_yewuval = $db->get_all($query);
     }
     // echo $query;
     return $arr_yewuval;
 }
开发者ID:Xiaoyuyexi,项目名称:client-server,代码行数:16,代码来源:AutogetFileimg.php

示例6: completeOrder

 public function completeOrder()
 {
     $logger = Logger::getLogger('gamerecharge');
     $logger->debug("start completeOrder");
     $authorid = trim($this->arr_channelinfo['authorid']);
     $bkntno = trim($this->arr_body['bkntno']);
     $retcode = "200";
     $arr_message = array("result" => "fail", "message" => "操作出现异常,请稍后再试!");
     $hasReceiveMoney = false;
     if ($authorid != "" && $bkntno != "") {
         $logger->debug("process completeOrder : authorid and bkntno : (" . $authorid . ", " . $bkntno . ")");
         $query = "SELECT *, DATE_FORMAT(fd_grclist_paydate,'%Y%m%d') as fd_grclist_paydate FROM tb_gamerechargelist WHERE fd_grclist_authorid = {$authorid} AND fd_grclist_bkntno = '{$bkntno}'";
         $db = new DB_test();
         $orderInDB = $db->get_all($query);
         if ($orderInDB != 0 && count($orderInDB) > 0) {
             $orderNumber = $orderInDB[0]["fd_grclist_bkordernumber"];
             $orderTime = $orderInDB[0]["fd_grclist_paydate"];
             $logger->debug("process completeOrder : orderNumber : (" . $orderNumber . ")");
             $arr_returninfo = BankPayInfoV2::bankorderquery($authorid, '', $orderNumber, $orderTime);
             $logger->debug("process completeOrder : value from BankPayInfoV2 : (" . $arr_returninfo . ")");
             if (md5($arr_returninfo) == "cace2a1f74fa974808c185f17ef557de") {
                 $retcode = 0;
                 $arr_message = array("result" => "success", "message" => "付款已收到,正在为您充值中!");
                 $hasReceiveMoney = true;
             } else {
                 $arr_message = array("result" => "fail", "message" => $arr_returninfo);
             }
         } else {
             $arr_message = array("result" => "fail", "message" => "输入信息有误");
         }
     } else {
         $arr_message = array("result" => "fail", "message" => "输入信息不完整");
     }
     if ($hasReceiveMoney) {
         $logger->debug("process completeOrder : start ofpay");
         // 开始调用欧飞接口进行充值
         if ($orderInDB != 0 && count($orderInDB) > 0) {
             $cardid = $orderInDB[0]["fd_grclist_gamecardid"];
             $cardnum = $orderInDB[0]["fd_grclist_gamecardnum"];
             $game_userid = $orderInDB[0]["fd_grclist_gameuserid"];
             $game_area = $orderInDB[0]["fd_grclist_gamearea"];
             $game_srv = $orderInDB[0]["fd_grclist_gamesrv"];
             $objOfpayV2 = new OfpayV2();
             $returnvalue = $objOfpayV2->gameRecharge($orderNumber, $cardid, $cardnum, $game_userid, $game_area, $game_srv, &$errMsg);
             $logger->debug("process completeOrder : value from OfpayV2 : (" . $returnvalue . ")");
             if ($errMsg != "") {
                 $arr_message['message'] = $errMsg;
             }
             $query = "UPDATE tb_gamerechargelist SET fd_grclist_state = 1, fd_grclist_datetime = NOW() WHERE fd_grclist_authorid = {$authorid} AND fd_grclist_bkntno = '{$bkntno}'";
             $db->query($query);
             $this->customerProfit($orderInDB);
         }
     }
     $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;
 }
开发者ID:Xiaoyuyexi,项目名称:client-server,代码行数:59,代码来源:ApiGameRecharge.php

示例7: GetGuestRoom

	public function GetGuestRoom()
	{
		$sql = "SELECT id, name, resident, bed_size AS bedSize, url FROM ctrip_hotel_room LEFT JOIN ctrip_hotel_image ON ctrip_hotel_room.name = ctrip_hotel_image.caption WHERE ctrip_hotel_room.hotel_id = 431626 AND ctrip_hotel_image.hotel_id = 431626 ORDER BY id, name";
		
		$db = new DB_test();
		$db->query($sql);
		
		$roomList = $db->get_all($sql);
		
		for($i = 0; $i < count($roomList); $i++)
		{
			$room = array();
			$room["code"] = $roomList[$i]["id"];
			$room["name"] = auto_charset($roomList[$i]["name"], 'gbk', 'utf-8');;
			$room["resident"] = $roomList[$i]["resident"];
			$room["bedSize"] = $roomList[$i]["bedSize"];
			$room["price"] = 124;
			$room["priceCode"] = 121242;
			$room["roomImage"][] = "http://Images4.c-ctrip.com/target/hotel/1000/217/d2e0c48eddbc4daca9137f1da436c948_550_412.jpg";
			$room["roomImage"][] = "http://Images4.c-ctrip.com/target/hotel/1000/83/5cc5832beaff4171aa8c8abb953aab01_550_412.jpg";
			$room["roomImage"][] = "http://Images4.c-ctrip.com/target/hotel/1000/86/71e73bfa996f434bb019d4484e244f00_550_412.jpg";
			$arr_msg['msgbody'][] = $room;
		}
		
		$arr_message = array("result" => "success", "message" => "成功获取数据");
		$retcode = "0";
		
		$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;
	}
开发者ID:nonenull,项目名称:doc,代码行数:35,代码来源:ApiHotel.php

示例8: getAuthorInfo

 private function getAuthorInfo($authorid, $mobile)
 {
     $now = time();
     $logger = Logger::getLogger('AuthorInfo');
     $logger->debug("start getAuthorInfo({$now}) : authorid({$authorid}), mobile({$mobile})");
     if ($authorid != "") {
         $query = "SELECT fd_author_isstop, fd_author_state, fd_author_id, fd_author_password, fd_author_paypassword, fd_author_cusid, fd_author_bdagentid \n\t\t\t\t\tFROM tb_author WHERE fd_author_id = '{$authorid}'";
     } else {
         $query = "SELECT fd_author_isstop, fd_author_state, fd_author_id, fd_author_password, fd_author_paypassword, fd_author_cusid, fd_author_bdagentid \n\t\t\t\t\tFROM tb_author WHERE fd_author_username = '{$mobile}'";
     }
     if ($query != "") {
         $logger->debug("process getAuthorInfo({$now}) : query({$query})");
         $db = new DB_test();
         $result = $db->get_all($query);
         if (!is_array($result) || count($result) != 1) {
             $logger->error("process getAuthorInfo({$now}) : get data from query({$query}), dataInDB(" . print_r($result, true) . ")");
             return null;
         } else {
             $author = array("fd_author_isstop" => $result[0]["fd_author_isstop"], "fd_author_state" => $result[0]["fd_author_state"], "fd_author_id" => $result[0]["fd_author_id"], "fd_author_password" => $result[0]["fd_author_password"], "fd_author_paypassword" => $result[0]["fd_author_paypassword"], "fd_author_bdagentid" => $result[0]["fd_author_bdagentid"], "fd_author_cusid" => $result[0]["fd_author_cusid"] + 0);
             return $author;
         }
     }
     return null;
 }
开发者ID:Xiaoyuyexi,项目名称:client-server,代码行数:24,代码来源:ApiAuthorInfoV2.php

示例9: CheckTransStatus

 public function CheckTransStatus()
 {
     $now = time();
     $logger = Logger::getLogger('mobilerecharge');
     $logger->debug("开始银联支付完成后,检查订单状态({$now})");
     $msgBody = $this->arr_body;
     $transNumber = trim($msgBody['bkntno']);
     $result = trim($msgBody['result']);
     if ($transNumber == "") {
         ErrorReponse::reponError(array('retcode' => '200', 'retmsg' => '账单信息不能为空'));
     }
     $logger->info("正在银联支付完成后,检查订单状态({$now}) : transNumber({$transNumber}), result({$result})");
     $query = "SELECT fd_mrclist_bkordernumber AS orderId, DATE_FORMAT(fd_mrclist_date, '%Y%m%d') AS orderTime FROM tb_mobilerechargelist \n\t\t\t\tWHERE fd_mrclist_bkntno = '{$transNumber}'";
     $logger->debug("正在银联支付完成后,检查订单状态({$now}) : query({$query})");
     $db = new DB_test();
     $dataInDB = $db->get_all($query);
     if (!is_array($dataInDB) || count($dataInDB) != 1) {
         $logger->error("完成银联支付完成后,检查订单状态({$now}) : 数据({$query})有误(" . print_r($dataInDB, true) . ")");
         ErrorReponse::reponError(array('retcode' => '200', 'retmsg' => '账单信息异常'));
     }
     $orderId = $dataInDB[0]['orderId'];
     $orderTime = $dataInDB[0]['orderTime'];
     $logger->debug("正在银联支付完成后,检查订单状态({$now}) : orderId({$orderId}), orderTime({$orderTime})");
     if ($orderId == "" || $orderTime == "") {
         $logger->error("完成银联支付完成后,检查订单状态({$now}) : 订单号异常 orderId({$orderId}), orderTime({$orderTime})");
         ErrorReponse::reponError(array('retcode' => '200', 'retmsg' => '订单号异常'));
     }
     $payResult = BankPayInfoV3::GetTransStatus($orderId, $orderTime);
     $logger->debug("正在银联支付完成后,检查订单状态({$now}) : payResult(" . $payResult . ")");
     $payResult = md5("" . (string) $payResult . "");
     if ($payResult == "cace2a1f74fa974808c185f17ef557de") {
         // bankReturnInfo为00
         $retcode = 0;
         $arr_message = array("result" => "success", "message" => "支付成功,正在为您充值中!");
     } else {
         $arr_message = array("result" => "fail", "message" => "支付失败,如有疑问,请联系客服!");
     }
     MobileRecharge::UpmpPayFeedback($payResult, $orderId);
     $arr_msg['msgbody']['result'] = $arr_message['result'];
     $arr_msg['msgbody']['message'] = $arr_message['message'];
     $logger->info("完成银联支付完成后,检查订单状态({$now}) : msgbody" . print_r($arr_msg['msgbody'], true));
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }
开发者ID:Xiaoyuyexi,项目名称:client-server,代码行数:45,代码来源:ApiMobileRechargeInfoV2.php

示例10: completeOrder

 public function completeOrder()
 {
     $retcode = "200";
     $arr_message = array("result" => "fail", "message" => "操作出现异常,请稍后再试!");
     $logger = Logger::getLogger('utility');
     $logger->debug("start submitOrder");
     $authorid = trim($this->arr_channelinfo['authorid']);
     $arr_body = $this->arr_body;
     $orderid = trim($arr_body['orderid']);
     $bkntno = trim($arr_body['bkntno']);
     $hasReceiveMoney = false;
     $db = new DB_test();
     $query = "SELECT *, DATE_FORMAT(fd_submit_time,'%Y%m%d') as orderTime FROM tb_utility_order WHERE fd_author_id = {$authorid} AND fd_order_id = {$orderid}";
     $orderInDB = $db->get_all($query);
     if ($orderInDB != 0 && count($orderInDB) > 0) {
         $orderNumber = $orderInDB[0]["fd_bkordernumber"];
         $orderTime = $orderInDB[0]["orderTime"];
         $arr_returninfo = BankPayInfoV2::bankorderquery($authorid, '', $orderNumber, $orderTime);
         if (md5($arr_returninfo) == "cace2a1f74fa974808c185f17ef557de") {
             $retcode = 0;
             $arr_message = array("result" => "success", "message" => "付款已收到,正在为您充值中!");
             $hasReceiveMoney = true;
         } else {
             $arr_message = array("result" => "fail", "message" => $arr_returninfo);
         }
     }
     if ($hasReceiveMoney) {
         // interface info
         $usernumber = "7000035";
         $sign = "ae4544eaa21f4575997c12332581e662";
         $inordernumber = "IWEC" . $usernumber . date("YmdHis") . "6543";
         $outordernumber = $orderid;
         $proId = $orderInDB[0]["fd_pro_id"];
         $account = $orderInDB[0]["fd_account_id"];
         $paymoney = $orderInDB[0]["fd_total_bill"];
         $starttime = date("Y-m-d H:i:s");
         $timeout = 30;
         $url = "http://lifeapi.salerwise.com/IWEC/IRechargeList_WEC";
         $yearmonth = "";
         $recordkey = $usernumber . $inordernumber . $outordernumber . $proId . $account . $paymoney . $yearmonth . $starttime . $timeout . $sign;
         $recordkey = md5($recordkey);
         $recordkey = substr($recordkey, 0, 16);
         $recordkey = strtoupper($recordkey);
         $data = array('usernumber' => $usernumber, 'inordernumber' => $inordernumber, 'outordernumber' => $outordernumber, 'proId' => $proId, 'account' => $account, 'paymoney' => $paymoney, 'starttime' => $starttime, 'timeout' => $timeout, 'recordkey' => $recordkey, 'yearmonth' => $yearmonth);
         $ch = curl_init();
         curl_setopt($ch, CURLOPT_URL, $url);
         curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
         curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
         curl_setopt($ch, CURLOPT_POST, 1);
         curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
         $file_contents = curl_exec($ch);
         curl_close($ch);
         $result = false;
         if ($file_contents != "") {
             $file_contents = str_replace("GB2312", "UTF-8", $file_contents);
             $xml = simplexml_load_string($file_contents);
             foreach ($xml->children() as $child) {
                 if ($child->getName() == "result" && (string) $child == "success") {
                     $result = true;
                 }
             }
         }
         $this->customerProfit($orderInDB[0]);
         if ($result) {
             $query = "UPDATE tb_utility_order SET fd_order_state = 3, fd_complete_time = NOW() WHERE fd_author_id = {$authorid} AND fd_order_id = {$orderid}";
             $db->query($query);
             $retcode = "0";
             $arr_message = array("result" => "success", "message" => "提交成功");
         }
     }
     $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;
 }
开发者ID:Xiaoyuyexi,项目名称:client-server,代码行数:76,代码来源:ApiUtility.php


注:本文中的DB_test::get_all方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。