PHP DB_test::getData方法代码示例

 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;
 }

 public function readHelpList()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $msgstart = $arr_body['msgstart'] + 0;
     $msgdisplay = $arr_body['msgdisplay'] + 0;
     if ($msgstart < 0) {
         $msgstart = 0;
     }
     $query = "select  1 from web_help order by fd_help_no ";
     $db->query($query);
     $msgallcount = $db->nf();
     $query = "select fd_help_id as helpid ,fd_help_name as helpname,fd_help_contect as helpcontent,\n\t          fd_help_date as helpdate from web_help order by fd_help_no limit {$msgstart}, {$msgdisplay}  ";
     $db->query($query);
     $msgdiscount = $db->nf();
     $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
     $arr_message = array("result" => "success", "message" => "读取成功！");
     $retcode = "0";
     //反馈状态 0 成功 200 自定义错误
     $arr_msg['msgbody']['msgallcount'] = $msgallcount;
     $arr_msg['msgbody']['msgdiscount'] = $msgdiscount + $msgstart;
     $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;
 }

 public function readKuaiDicmpList()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $apptype = trim($arr_body['apptype']);
     $appversion = trim($arr_body['appversion']);
     $query = "select fd_kdcompany_id as comid,fd_kdcompany_no as com,fd_kdcompany_name as comname\n\t\t         ,fd_kdcompany_api as apitype,fd_kdcompany_pic as comlogo ,fd_kdcompany_phone as comphone from \n\t             tb_kdcompany where fd_kdcompany_active = '1' order by fd_kdcompany_api desc";
     //只显示激活的列表
     $db->query($query);
     $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
     if (!$arr_msg) {
         $arr_message = array("result" => "failure", "message" => "列表为空!");
         $retcode = "200";
         //反馈状态 0 成功 200 自定义错误
     } else {
         $arr_message = array("result" => "success", "message" => "读取成功!");
         $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;
 }

 public function readKuaibkcardLists()
 {
     $authorId = trim($this->arr_channelinfo['authorid']);
     $query = "SELECT fd_bkcardid AS bkcardid, fd_bkcardno AS bkcardno, fd_bkcardbankid AS bkcardbankid, fd_bkcardbankcode AS bkcardbankcode, fd_bkcardbank AS bkcardbank, CONCAT('bank', CAST(fd_bkcardbankid AS CHAR), '.png') AS bkcardbanklogo, fd_bkcardbankman AS bkcardbankman, fd_bkcardbankphone AS bkcardbankphone, fd_bkcardyxmonth AS bkcardyxmonth, fd_bkcardyxyear AS bkcardyxyear, fd_bkcardcvv AS bkcardcvv, fd_bkcardidcard AS bkcardidcard, fd_bkcardisdefault AS bkcardisdefault, fd_bkcardcardtype AS bkcardcardtype FROM tb_author_quickpaycard WHERE fd_bkauthorid = " . $authorId;
     $db = new DB_test();
     $db->query($query);
     $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
     if (!$arr_msg) {
         $arr_message = array("result" => "failure", "message" => "您还没绑定过快捷银行卡!");
         $retcode = "200";
         //反馈状态 0 成功 200 自定义错误
     } else {
         $arr_message = array("result" => "success", "message" => "读取成功!");
         $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;
 }

 public function readOrderlist()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     //$paycardid = trim(GetPayCalcuInfo::readpaycardid($arr_body['paycardid'])); //插卡器
     $authorid = trim($arr_channelinfo['authorid']);
     //操作者
     $msgstart = trim($arr_body['msgstart']) + 0;
     $msgdisplay = trim($arr_body['msgdisplay']) + 0;
     $paytype = trim($arr_body['paytype']);
     $arr_state = array("请求交易", "交易成功", "交易取消", "无效状态");
     // $arr_state = auto_charset($arr_state, 'utf-8', 'gbk');
     $arr_orderstate = array("订单处理", "确认收款", "已发货", "已完成");
     $arr_state = auto_charset($arr_state, 'utf-8', 'gbk');
     $arr_orderstate = auto_charset($arr_orderstate, 'utf-8', 'gbk');
     if ($msgstart < 0) {
         $msgstart = 0;
     }
     $query = "select  1 from  tb_orderglist where  fd_orderlist_authorid = '{$authorid}' and" . "  (fd_orderlist_payrq = '00' )";
     $db->query($query);
     $msgallcount = $db->nf();
     $query = "select fd_orderlist_bkordernumber as orderno,\n                fd_orderlist_produrename as orderprodurename,\n\t\t\t\t  fd_orderlist_num as ordernum,\n\t\t\t\t   fd_orderlist_price as orderprice,\n\t\t\t\t   fd_orderlist_ordermoney as  ordermoney,\n\t\t\t\t   fd_orderlist_promoney as  promoney,\n\t\t\t\t   fd_orderlist_yunmoney as  yunmoney,\n\t\t\t\t   fd_orderlist_shaddress as ordershaddress,\n\t\t\t\t   fd_orderlist_shman as ordershman,\n\t\t\t\t   fd_orderlist_wlno as wlno,\n\t\t\t\t   fd_orderlist_wlcompanyid as kdcomanyid,\n\t\t\t\t  fd_orderlist_shphone as ordershphone,case\n                when fd_orderlist_payrq ='01' then '" . $arr_state[0] . "'\n        when fd_orderlist_payrq ='00' then '" . $arr_state[1] . "'" . "when fd_orderlist_payrq ='03' then '" . $arr_state[2] . "'\n        else '" . $arr_state[4] . "' END  orderpaystatus ,case\n        when fd_orderlist_state ='0' then '" . $arr_ofstate[0] . "'\n        when fd_orderlist_state ='1' then '" . $arr_ofstate[1] . "'" . "when fd_orderlist_state ='2' then '" . $arr_ofstate[2] . "'\n        else '" . $arr_ofstate[3] . "' END  orderstate from  tb_orderglist where\n\t\t\t\t\t\t\t\t\t fd_orderlist_authorid = '{$authorid}'\n\t\t\t\tand  (fd_orderlist_payrq = '00') order by fd_orderlist_id desc limit {$msgstart},{$msgdisplay} ";
     $db->query($query);
     $msgdiscount = $db->nf();
     $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
     if (!$arr_msg) {
         $arr_message = array("result" => "failure", "message" => "没有数据!");
         $retcode = "200";
         //反馈状态 0 成功 200 自定义错误
     } else {
         $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']['msgallcount'] = $msgallcount;
     $arr_msg['msgbody']['msgdiscount'] = $msgdiscount + $msgstart;
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }

 public function readMenuModule()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $paycardkey = $arr_body['paycardkey'];
     $authorid = $arr_channelinfo['authorid'];
     $appversion = $arr_body['appversion'] + 0;
     $query = "select fd_appmnu_id as mnuid,fd_appmnu_no as mnuno, fd_appmnu_name as mnuname,\n\t\t\t\tfd_appmnu_pic as mnupic,fd_appmnu_order as mnuorder, fd_appmnu_url as mnuurl ,\n\t\t\t\tfd_appmnu_version as mnuversion,fd_amtype_id as mnutypeid,\n\t\t\t\tfd_amtype_name as mnutypename,\n\t\t\t\tcase\n              when fd_appmnuc_count is null then '0'\n              else fd_appmnuc_count  END  pointnum,\n\t\t\t\tfd_appmnu_isconst as mnuisconst\n\t\t\t\tfrom tb_appmenu  join tb_appmenutype on  fd_amtype_id = fd_appmnu_amtypeid\n\t\t\t\tleft join tb_appmenucout on fd_appmnu_id = fd_appmnuc_appmnuid\n\t\t\t\tand fd_appmnuc_authorid = '{$authorid}'  where fd_appmenu_active = '1' order by fd_appmnu_order\n\t\t\t\t";
     $db->query($query);
     $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
     $arr_one = $db->get_one($query);
     $version = $arr_one['mnuversion'];
     if ($version > $appversion) {
         $arr_message = array("result" => "success", "message" => "有新的功能更新哦！", "version" => $version, "isnew" => '1');
         $retcode = "0";
         //反馈状态 0 成功 200 自定义错误
     } else {
         $arr_message = array("result" => "success", "message" => "目前功能最新", "version" => $version, "isnew" => '0');
         $arr_msg = "";
         $retcode = "0";
         //反馈状态 0 成功 200 自定义错误
     }
     $arr_msg['msgbody']['result'] = $arr_message['result'];
     $arr_msg['msgbody']['message'] = $arr_message['message'];
     $arr_msg['msgbody']['version'] = $arr_message['version'];
     $arr_msg['msgbody']['isnew'] = $arr_message['isnew'];
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }

	function getPassenger()
	{
		
		$authorid = trim($this->arr_channelinfo['authorid']);									// 必填
		$type = trim($this->arr_body['type']);													// 必填
		if($authorid != "")
		{
			if($type == "1")																	// 读取乘机人
			{
				$sql = "SELECT id, name, card_type AS cardType, card_id AS cardId, phone AS phoneNumber, type AS passengerType, gender FROM ctrip_airticket_passenger WHERE is_active = 1 AND user_id = " . $authorid;
			}
			else if($type == "2")																// 读取联系人
			{
				$sql = "SELECT id, name, phone AS phoneNumber FROM ctrip_airticket_contacter WHERE is_active = 1 AND user_id = " . $authorid;
			}
		}
		if(isset($sql))
		{
			$db = new DB_test();
			$db->query($sql);
			$arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
			$retcode = "0";
			$arr_message = array("result" => "success", "message" => "");
			if($db->num_rows() == 0)
			{
				$retcode = "200";
			$arr_message = array("result" => "fail", "message" => "没有保存过相关信息");
			}
		}
		else
		{
			$arr_message = array("result" => "fail", "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;
	}

 public function readQQRechangelist()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     //$paycardid = trim(GetPayCalcuInfo::readpaycardid($arr_body['paycardid'])); //插卡器
     $authorid = trim($arr_channelinfo['authorid']);
     //操作者
     $msgstart = trim($arr_body['msgstart']) + 0;
     $msgdisplay = trim($arr_body['msgdisplay']) + 0;
     $paytype = trim($arr_body['paytype']);
     $arr_state = array("请求交易", "交易成功", "交易取消", "无效状态");
     // $arr_state = auto_charset($arr_state, 'utf-8', 'gbk');
     $arr_ofstate = array("充值成功", "正在充值", "充值失败", "充值失败");
     $arr_state = auto_charset($arr_state, 'utf-8', 'gbk');
     $arr_ofstate = auto_charset($arr_ofstate, 'utf-8', 'gbk');
     if ($msgstart < 0) {
         $msgstart = 0;
     }
     $query = "select  1 from  tb_qqrechargelist where  fd_mrclist_authorid = '{$authorid}' and" . "  (fd_mrclist_payrq = '00' )";
     $db->query($query);
     $msgallcount = $db->nf();
     $query = "select fd_mrclist_bkordernumber as listno,\n                fd_mrclist_rechamoney as rechamoney,\n\t\t\t\t  fd_mrclist_paymoney as rechapaymoney,\n\t\t\t\t   fd_mrclist_qqprov as rechaqqprov,\n\t\t\t\t   fd_mrclist_bankcardno as  rechabkcardno,\n\t\t\t\t   fd_mrclist_paydate as rechadatetime,\n\t\t\t\t   fd_mrclist_state as rechastate,\n\t\t\t\t  fd_mrclist_qq as rechaqq,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  state ,case\n        when fd_mrclist_ofstate ='1' then '" . $arr_ofstate[0] . "'\n        when fd_mrclist_ofstate ='-1' then '" . $arr_ofstate[1] . "'" . "when fd_mrclist_ofstate ='1007' then '" . $arr_ofstate[2] . "'\n        else '" . $arr_ofstate[3] . "' END  ofstate from  tb_qqrechargelist where\n\t\t\t\t\t\t\t\t\t fd_mrclist_authorid = '{$authorid}'\n\t\t\t\tand  (fd_mrclist_payrq = '00') order by fd_mrclist_id desc limit {$msgstart},{$msgdisplay} ";
     $db->query($query);
     $msgdiscount = $db->nf();
     $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
     if (!$arr_msg) {
         $arr_message = array("result" => "failure", "message" => "没有数据!");
         $retcode = "200";
         //反馈状态 0 成功 200 自定义错误
     } else {
         $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']['msgallcount'] = $msgallcount;
     $arr_msg['msgbody']['msgdiscount'] = $msgdiscount + $msgstart;
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }

 public function readAccglistdetail()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $acctypeid = trim($arr_body['acctypeid']);
     $authorid = trim($arr_channelinfo['authorid']);
     $msgstart = trim($arr_body['msgstart']) + 0;
     $msgdisplay = trim($arr_body['msgdisplay']) + 0;
     //echo var_dump($arr_body);
     $accyear = substr(trim($arr_body['accmonth']), 0, 4);
     $accmonth = str_replace($accyear, "", $arr_body['accmonth']);
     if ($acctypeid == 'coupon') {
         $wherequery1 = " and 1=2";
     }
     if ($acctypeid == 'recharge') {
         $wherequery2 = " and 1=2";
     }
     if ($msgdisplay == 0) {
         $msgdisplay = 100;
     }
     $paytype = '充值';
     $paytype = u2g($paytype);
     $paytype3 = '订单支付';
     $paytype3 = u2g($paytype);
     $paytype1 = '购买抵用券';
     $paytype1 = u2g($paytype1);
     $paystate = '交易完成';
     $paystate = u2g($paystate);
     $query = "select * from (select fd_accglist_bkordernumber as accglistno," . " case \n        when fd_accglist_paytype ='coupon' then '购买抵用券'\n        when fd_accglist_paytype ='creditcard' then '信用卡还款'" . "when fd_accglist_paytype ='recharge' then   '" . $paytype . "'" . "when fd_accglist_paytype ='pay' then       '还贷款'" . "when fd_accglist_paytype ='order' then '" . $paytype3 . "'" . "when fd_accglist_paytype ='tfmg' then '转账汇款'\n        else '其他业务' END  accgpaymode," . " \n\t\t\t\t                    fd_accglist_datetime as accglistdate , fd_accglist_id as  accglistid ,\n\t\t\t\t                    (fd_accglist_money) as accglistmoney,'" . $paystate . "' as accgstate,'' as accgtype,'' as accgmemo ," . " 'testbank' as accgcardbank,'testno' as accgcardno   \n\t\t\t\t\t\t\t        from tb_authoraccountglist where year(fd_accglist_datetime) = '{$accyear}' and \n\t\t\t\t\t\t\t\t\tmonth(fd_accglist_datetime) = '{$accmonth}' and fd_accglist_authorid='{$authorid}' {$wherequery1} \n\t\t\t\t              " . " union all  select fd_couponsale_bkordernumber as couponno,'" . $paytype1 . "' as accgpaymode ,fd_couponsale_datetime as coupondate," . "fd_couponsale_id as couponid, CONCAT_WS('=',CONCAT_WS('*',(fd_couponsale_money/fd_coupon_money),fd_coupon_money),fd_couponsale_money+0) as couponmoney,'" . $paystate . "','' as accgtype,'' as accgmemo ,'testbank' as accgcardbank,'testno' as accgcardno \n\t\t\t                from \n\t\t\t       tb_couponsale left join tb_coupon on fd_coupon_id =fd_couponsale_couponid where fd_couponsale_authorid = '{$authorid}' and fd_couponsale_payrq = '00' and fd_couponsale_isagentpay = '0'" . " and year(fd_couponsale_datetime) = '{$accyear}' and \n\t\t\t\t\t\t\t\t\tmonth(fd_couponsale_datetime) = '{$accmonth}' {$wherequery2}) as a order by accglistdate desc ";
     $db->query($query);
     $msgallcount = $db->nf();
     //$query = " $query  limit $msgstart,$msgdisplay ";
     //$db->query($query);
     $msgdiscount = $db->nf();
     //  echo $query;
     //  echo $query;
     $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
     $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']['msgallcount'] = $msgallcount;
     $arr_msg['msgbody']['msgdiscount'] = $msgdiscount + $msgstart;
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }

 public function getOrderHistory()
 {
     $retcode = "200";
     $arr_message = array("result" => "fail", "message" => "操作出现异常，请稍后再试！");
     $authorid = trim($this->arr_channelinfo['authorid']);
     if ($authorid > 0) {
         $arr_body = $this->arr_body;
         $start = intval(trim($arr_body['msgstart']));
         $start = $start > 0 ? $start : 0;
         $count = intval(trim($arr_body['msgdisplay']));
         $count = $count > 0 ? $count : 8;
         $db = new DB_test();
         $query = "SELECT fd_grclist_bkntno AS bkntno, fd_grclist_gameuserid AS account, fd_grclist_gamecardnum AS quantity, fd_grclist_gamename AS gamename, fd_grclist_state, fd_grclist_paymoney AS totalPrice, fd_grclist_datetime AS completeTime FROM tb_gamerechargelist WHERE fd_grclist_authorid = {$authorid} AND fd_grclist_state = 1 LIMIT {$start}, {$count}";
         $db->query($query);
         $retcode = "0";
         if ($db->nf() > 0) {
             $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
             $arr_message = array("result" => "success", "message" => "获取成功");
         } else {
             $arr_message = array("result" => "success", "message" => "没有数据");
         }
     } else {
         $arr_message = array("result" => "fail", "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;
 }

 public function couponSalelist()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $authorid = $arr_channelinfo['authorid'];
     $msgstart = trim($arr_body['msgstart']) + 0;
     $msgdisplay = trim($arr_body['msgdisplay']) + 0;
     if ($msgdisplay == 0) {
         $msgdisplay = 100;
     }
     $query = "select fd_couponsale_bkordernumber as couponno,CONCAT_WS('=',CONCAT_WS('*',(fd_couponsale_money/fd_coupon_money),fd_coupon_money),fd_couponsale_money+0) as couponmoney " . ",\n\t\t\t                 fd_couponsale_datetime as coupondate,fd_couponsale_paycardid as paycardid,\n\t\t\t\t\t\t\t fd_couponsale_id as couponid ,fd_couponsale_memo as couponmemo,fd_couponsale_creditcardbank as couponbank,fd_couponsale_creditcardno as couponcardno from \n\t\t\t       tb_couponsale left join tb_coupon on fd_coupon_id =fd_couponsale_couponid where fd_couponsale_authorid = '{$authorid}' and fd_couponsale_payrq = '00' order by fd_couponsale_datetime desc ";
     //只显示购买的抵用券历史
     $db->query($query);
     $msgallcount = $db->nf();
     $query = " {$query} limit {$msgstart},{$msgdisplay}";
     $db->query($query);
     $msgdiscount = $db->nf();
     //echo $query;
     $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
     //echo var_dump($arr_msg);
     if ($arr_msg == "") {
         $arr_message = array("result" => "failure", "message" => "还没有优惠券记录!");
         $retcode = "200";
         //反馈状态 0 成功 200 自定义错误
     } else {
         $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']['msgallcount'] = $msgallcount;
     $arr_msg['msgbody']['msgdiscount'] = $msgdiscount + $msgstart;
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }

	public function GetRoomAmenity()
	{
		$sql = "SELECT name AS amenity FROM ctrip_hotel_baseinfo_room_amenity";
		
		$db = new DB_test();
		$db->query($sql);
		
		if($db->nf() > 0)
		{
			$arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
			$arr_message = array("result" => "success", "message" => "成功获取数据");
		}
		else
		{
			$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;
	}

 public function payagentfenrunlistdetail()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     //$paycardid = trim(GetPayCalcuInfo::readpaycardid($arr_body['paycardid'])); //插卡器
     $authorid = trim($arr_channelinfo['authorid']);
     //操作者
     $agentid = trim($arr_channelinfo['agentid']);
     //代理商id
     $querytype = trim($arr_body['querytype']);
     //支付类型id
     $querywhere = trim($arr_body['querywhere']);
     //充值金额
     $appfunid = trim($arr_body['appfunid']);
     //充值金额
     $querywhere1 = " and fd_frlist_paydate like '%{$querywhere}%'";
     $query = "select fd_amtype_id as appfunid, fd_appmnu_name as appfunname,\n                 sum(fd_frlist_paymoney) as paymoney,sum(fd_frlist_payfee) as payfee,sum(fd_frlist_cusfee) as fenrun\n             from tb_cus_fenrunglist left  join tb_appmenu on fd_appmnu_no = fd_frlist_paytype\n             left join tb_appmenutype on fd_amtype_id = fd_appmnu_amtypeid\n               where fd_frlist_payrq = '00' and fd_frlist_sdcrid<100\n              {$querywhere1} and fd_frlist_cusid = '{$agentid}' and fd_appmnu_amtypeid = '{$appfunid}'\n              group by fd_appmnu_amtypeid order by\n              fd_appmnu_id\n     ";
     $db->query($query);
     $query = "select fd_amtype_id as appfunid, fd_appmnu_name as appfunname,\n                 sum(fd_frlist_paymoney) as paymoney,sum(fd_frlist_payfee) as payfee,sum(fd_frlist_cusfee) as fenrun\n             from tb_cus_fenrunglist left  join tb_appmenu on fd_appmnu_no = fd_frlist_paytype\n             left join tb_appmenutype on fd_amtype_id = fd_appmnu_amtypeid\n               where fd_frlist_payrq = '00' and fd_frlist_sdcrid<100\n              {$querywhere1} and fd_frlist_cusid = '{$agentid}' and fd_appmnu_amtypeid = '{$appfunid}'\n              group by fd_appmnu_id order by\n              fd_appmnu_id\n     ";
     $db->query($query);
     $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
     if (!$arr_msg) {
         $arr_message = array("result" => "failure", "message" => "没有数据!");
         $retcode = "200";
         //反馈状态 0 成功 200 自定义错误
     } else {
         $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']['totalfenrun'] = 0;
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }

 public function readshoucardList()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $paytype = trim($arr_body['paytype']);
     $authorid = trim($arr_channelinfo['authorid']);
     //操作者
     //$appversion = trim($arr_body['appversion']);
     $query = "select ''  as shoucardid,fd_bank_id  as bankid,fd_agpm_shoucardno as shoucardno,fd_agpm_shoucardbank as shoucardbank,fd_agpm_shoucardman as shoucardman,fd_agpm_shoucardmobile as shoucardmobile, '" . $paytype . "' as paytype from \n\t\t\t      tb_agentpaymoneylist left join tb_bank on fd_bank_name = fd_agpm_shoucardbank where fd_agpm_paytype = '{$paytype}' and fd_agpm_authorid = '{$authorid}'  and fd_agpm_shoucardno <>'' group by fd_agpm_shoucardno,fd_agpm_shoucardbank, fd_agpm_shoucardman,fd_agpm_shoucardmobile";
     //只显示激活的银行列表
     $db->query($query);
     $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
     if (!$arr_msg) {
         $arr_message = array("result" => "failure", "message" => "银行账户历史记录为空!");
         $retcode = "200";
         //反馈状态 0 成功 200 自定义错误
     } else {
         $arr_message = array("result" => "success", "message" => "读取成功!");
         $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;
 }

 public function ReadMobileRechangeList()
 {
     $authorId = trim($this->arr_channelinfo['authorid']);
     // 用户ID
     if ($authorId == "") {
         ErrorReponse::reponError(array('retcode' => '200', 'retmsg' => '用户信息异常'));
     }
     $pageStart = trim($this->arr_body['msgstart']) + 0;
     $pageCount = trim($this->arr_body['msgdisplay']) + 0;
     $pageCount = $pageCount > 0 ? $pageCount : 8;
     $query = "SELECT fd_mrclist_rechamoney AS rechamoney, fd_mrclist_paymoney AS rechapaymoney, \n\t\t\t\tfd_mrclist_mobileprov AS rechamobileprov,  fd_mrclist_bankcardno AS rechabkcardno, \n\t\t\t\tfd_mrclist_paydate AS rechadatetime, fd_mrclist_rechaphone AS rechamobile \n\t\t\t\tFROM tb_mobilerechargelist \n\t\t\t\tWHERE fd_mrclist_authorid = '{$authorId}' AND fd_mrclist_payrq = '00' \n\t\t\t\tORDER BY fd_mrclist_paydate DESC LIMIT {$pageStart}, {$pageCount}";
     $db = new DB_test();
     $db->query($query);
     $msgBody = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
     if (!$msgBody) {
         $arr_message = array("result" => "fail", "message" => "您还未使用过手机充值业务!");
         $retcode = "200";
     } else {
         $arr_message = array("result" => "success", "message" => "");
         $retcode = "0";
     }
     $msgBody['msgbody']['result'] = $arr_message['result'];
     $msgBody['msgbody']['message'] = $arr_message['message'];
     $returnvalue = array("msgbody" => $msgBody['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }