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 = '******'";
$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;
}
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 A.fd_union_pay_number AS bkntno, A.fd_pro_id AS proId, \n\t\t\t\t\t(A.fd_fact_bill / 100) AS factNumber, (A.fd_total_bill / 100) AS payNumber, IF(A.fd_order_state = 3, 0, 1) AS status, B.fd_company_name AS company, \n\t\t\t\t\tA.fd_complete_time AS completeTime FROM tb_utility_order AS A JOIN tb_utility_product AS B ON A.fd_pro_id = B.fd_company_id \t\n\t\t\t\t\tWHERE A.fd_author_id = {$authorid} AND (A.fd_order_state = 2 || A.fd_order_state = 3) 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" => "没有数据");
}
}
$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;
}
