public function readAuBkCardInfo()
{
$db = new DB_test();
$arr_header = $this->arr_header;
$arr_body = $this->arr_body;
$arr_channelinfo = $this->arr_channelinfo;
$authorid = trim($arr_channelinfo['authorid']);
$arr_message = array("error_id" => "0", "result" => "success", "message" => "读取成功");
$retcode = "0";
//反馈状态 0 成功 200 自定义错误
$query = "select * from tb_author where fd_author_id = '{$authorid}'";
$db->query($query);
if ($db->nf()) {
$db->next_record();
$arr_msg['msgbody']['aushoucardman'] = g2u($db->f(fd_author_shoucardman));
$arr_msg['msgbody']['aushoucardphone'] = $db->f(fd_author_shoucardphone);
$arr_msg['msgbody']['aushoucardno'] = $db->f(fd_author_shoucardno);
$arr_msg['msgbody']['aushoucardbank'] = g2u($db->f(fd_author_shoucardbank));
$arr_msg['msgbody']['aushoucardstate'] = $db->f(fd_author_shoucardstate) + 0;
} else {
$arr_message = array("error_id" => "1", "result" => "failure", "message" => "用户信息已失效，请重新登录");
$retcode = "200";
//反馈状态 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 get_upath($path, $type = 'u')
{
$path = SYS_WIN ? g2u($path) : $path;
if ('r' == $type) {
$path = substr($path, strlen(REAL_ROOT_PATH) - 1);
}
if ('u' == $type) {
$path = substr($path, strlen(REAL_USER_PATH) - 1);
}
return str_replace('//', '/', $path);
}
$data['statusCode'] = 200;
$data['message'] = '<font color="green">新建成功：</font><font color="red">' . g2u(basename($name)) . '</font><br />';
} else {
$data['statusCode'] = 300;
$data['message'] = '<font color="blue">新建失败：</font><font color="red">错误原因未知</font><br />';
}
}
} elseif ('dir' == $type) {
if (is_dir($name)) {
$data['statusCode'] = 300;
$data['message'] = '<font color="blue">新建失败：</font><font color="red">目录已存在</font><br />';
} else {
$result = (bool) @mkdir($name, 0755);
if ($result) {
$data['statusCode'] = 200;
$data['message'] = '<font color="green">新建成功：</font><font color="red">' . g2u(basename($name)) . '</font><br />';
} else {
$data['statusCode'] = 300;
$data['message'] = '<font color="blue">新建失败：</font><font color="red">错误原因未知</font><br />';
}
}
} else {
$data['statusCode'] = 300;
$data['message'] = '<font color="blue">操作失败：</font><font color="red">未知操作指令</font><br />';
}
$data['message'] .= '<font color="green">执行耗时：</font><font color="red">' . G('_run_start', '_run_end', 6) . ' 秒</font><br />';
exit(json_encode($data));
} elseif ('imageview' == $action) {
$file = u2g(trim($_REQUEST['file']));
require INC_ROOT . 'Image.class.php';
$Image = new Image();
public function orderPayReq()
{
$db = new DB_test();
$arr_header = $this->arr_header;
$arr_body = $this->arr_body;
$arr_channelinfo = $this->arr_channelinfo;
$orderid = g2u(trim($arr_body['orderid']));
$orderno = g2u(trim($arr_body['orderno']));
$paymoney = trim($arr_body['paymoney'] + 0);
$fucardno = g2u(trim($arr_body['bankcardno']));
$bankname = g2u(trim($arr_body['bankname']));
$authorid = g2u(trim($arr_channelinfo['authorid']));
//$paycardid = u2g(trim(GetPayCalcuInfo::readpaycardid($arr_body['paycardid']))); //银行类型
$arr_message = array("result" => "success", "message" => "成功获取订单交易流水号!");
$arr_msg['msgbody']['result'] = $arr_message['result'];
$arr_msg['msgbody']['message'] = $arr_message['message'];
$bkmoney = $paymoney;
$arr_bkinfo = BankPayInfo::bankpayorder($authorid, $paycardid, $paymoney, $fucardno);
$bkntno = trim($arr_bkinfo['bkntno']);
$arr_feeinfo['bkordernumber'] = $bkorderNumber = $arr_bkinfo['bkorderNumber'];
$arr_feeinfo['sdcrid'] = $sdcrid = trim($arr_bkinfo['sdcrid']);
$sdcrpayfee = substr($arr_bkinfo['sdcrpayfee'], 0, -1);
//银联收取明盛浮动费率
$arr_feeinfo['sdcrpayfeemoney'] = $sdcrpayfeemoney = $bkmoney * $sdcrpayfee / 100 > $arr_bkinfo['minsdcrpayfee'] ? $bkmoney * $sdcrpayfee / 100 : $arr_bkinfo['minsdcrpayfee'];
$paytype = 'order';
$arr_msg['msgbody']['bkntno'] = $bkntno;
$ccgno = makeorderno("orderpayglist", "oplist", "opg");
$query = "insert into tb_orderpayglist(\n\t\t\t\t\t\t\t\t\tfd_oplist_no\t\t\t,fd_oplist_paycardid\t\t,fd_oplist_authorid\t,\n\t\t\t\t\t\t fd_oplist_paydate\t\t,fd_oplist_orderid \t\t,fd_oplist_fucardno\t,\n\t\t\t\t\t\t fd_oplist_bkntno\t\t,fd_oplist_payrq ,fd_oplist_paytype ,\n\t\t\t\t\t\t fd_oplist_current\t\t,fd_oplist_paymoney\t\t ,fd_oplist_payfee\t\t,\n\t\t\t\t\t\t fd_oplist_money\t\t,fd_oplist_orderno ,fd_oplist_shopid ,\n\t\t\t\t\t\t fd_oplist_fucardbank\t\t,fd_oplist_fucardmobile,\n\t\t\t\t\t\t fd_oplist_fucardman ,fd_oplist_feebankid ,fd_oplist_state ," . "fd_oplist_bkorderNumber,fd_oplist_sdcrid\t\t,fd_oplist_sdcrpayfeemoney \t\n\t\t\t\t\t\t )values\n\t\t\t\t\t\t\t\t ('{$ccgno}'\t\t,'{$paycardid}'\t,'{$authorid}'\t\t,\n\t\t\t\t\t\t\t\t '{$paydate}'\t\t,'{$orderid}'\t\t,'{$fucardno}'\t\t,\n\t\t\t\t\t\t\t\t '{$bkntno}'\t\t,'01'\t\t\t,'{$paytype}'\t\t\t,\n\t\t\t\t\t\t\t\t '{$current}'\t\t,'{$paymoney}'\t,'{$payfee}'\t\t\t,\n\t\t\t\t\t\t\t\t '{$paymoney}'\t\t,'{$orderno}'\t\t,'{$shopid}'\t\t\t,\n\t\t\t\t\t\t\t\t '{$fucardbank}'\t,'{$fucardmobile}',\n\t\t\t\t\t\t\t\t '{$fucardman}'\t\t,'{$feebankid}'\t,'0'," . "'{$bkorderNumber}' ,'{$sdcrid}' \t\t, '{$sdcrpayfeemoney}')";
$db->query($query);
$returnvalue = array("msgbody" => $arr_msg['msgbody']);
$retcode = "0";
//反馈状态 0 成功 200 自定义错误
$returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
return $returnval;
}
public function qqrecharge($qq, $cardnum)
{
$userid = "A942987";
// 商户编号
$userpws = md5("tfbao20140603");
//密码md5(******);
$userpws1 = "tfbao20140603";
//密码md5(******);
$cardid = "220612";
//快充值编号
$cardnum = $cardnum + 0;
//充值面额 1,2,4,6,10，20，30，50，100，300
$mctype = "";
//慢充使用参数 此处不用
$sporder_id = "tfb" . time();
//商家订单号 （自定义设置）
$sporder_time = date("YmdHis");
$game_userid = $qq;
//qq号码
$game_srv = "";
//游戏使用到
$game_area = "";
//游戏使用到
$md5_str = strtoupper(md5($userid . $userpws . $cardid . $cardnum . $sporder_id . $sporder_time . $game_userid . "OFCARD"));
$ret_url = "";
//可以返回空
$version = '6.0';
//默认等于6.0即可
$gourl = "http://api2.ofpay.com/onlineorder.do?userid={$userid}&userpws={$userpws}&cardid={$cardid}&cardnum={$cardnum}&sporder_id={$sporder_id}&sporder_time={$sporder_time}&game_userid={$game_userid}&game_area={$game_area}&game_srv={$game_srv}&md5_str={$md5_str}&ret_url=&version=6.0";
$result = $this->getcontent($gourl);
$arr_xml = $this->Publiccls->xml_to_array($result);
$arr_xml['ofreqcontent'] = $gourl;
$arr_xml['ofanscontent'] = $result;
// echo $arr_xml['orderinfo']['retcode'];
$file = "../../" . CONST_LOGDIR . "/" . date('Y-m-d') . "qq充值-log" . ".txt";
$filehandle = fopen($file, "a");
fwrite($filehandle, "\r\n======qq充值响应内容：\r\n" . $gourl . "\r\n\r\n返回值:" . serialize($arr_xml) . "\r\n\r\n" . g2u($result) . "<!----结束------------>\r\n\r\n\r\n");
fclose($filehandle);
return $arr_xml;
}
public function readQueryCardMoney()
{
$db = new DB_test();
$arr_header = $this->arr_header;
$arr_body = $this->arr_body;
$arr_channelinfo = $this->arr_channelinfo;
$bankcardno = $arr_body['bankcardno'];
$bankid = $arr_body['bankid'];
$bankname = $arr_body['bankname'];
$lastfour = substr($bankcardno, -4);
$query = "select fd_bank_sendmesage as smsmsg ,fd_bank_smsphone as smsphone from \n\t\t\t tb_bank where fd_bank_id = '{$bankid}'";
//只显示激活的银行列表
$db->query($query);
if ($db->nf()) {
$db->next_record();
$smsmsg = $db->f('smsmsg');
$smsphone = $db->f('smsphone');
}
if (!$db->nf()) {
$arr_message = array("result" => "failure", "message" => "暂不支持该银行手机查询余额业务", "retcode" => "200");
$retcode = "200";
//反馈状态 0 成功 200 自定义错误
} else {
$arr_message = array("result" => "success", "message" => "成功获取余额查询短信码!", "retcode" => "0");
$retcode = "0";
//反馈状态 0 成功 200 自定义错误
}
$smsmsg = str_replace("%f", $lastfour, $smsmsg);
$arr_msg['msgbody']['result'] = $arr_message['result'];
$arr_msg['msgbody']['message'] = $arr_message['message'];
$arr_msg['msgbody']['smsmsg'] = g2u($smsmsg);
$arr_msg['msgbody']['smsphone'] = $smsphone;
$returnvalue = array("msgbody" => $arr_msg['msgbody']);
$returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
return $returnval;
}
$vstate = $db->f(fd_saler_state);
$vpaycardnum = paycardnum($vid);
if ($vstate == 0) {
$vstate = "初始";
} else {
if ($vstate == 1) {
$vstate = "正常";
} else {
if ($vstate == -1) {
$vstate = "冻结";
}
}
}
$vstate = $vstate;
$vedit = '<a class="edit" onclick="edit(' . $vid . ')">编辑</a><a class="del" onclick="del(' . $vid . ')">删除</a>';
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $vtruename, $vidcard, $vpaycardnum, $vsalerlevel, $vstate, $vusername, $vphone, g2u($vedit));
}
} else {
$vmembernum = "暂无数据";
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $vtruename, $vidcard, $vpaycardnum, $vsalerlevel, $vstate, $vusername, $vphone, $vedit);
}
$returnarray['sEcho'] = intval($sEcho);
$returnarray['iTotalRecords'] = $totoalcount;
$returnarray['iTotalDisplayRecords'] = $totoalcount;
$returnarray['aaData'] = $arr_list;
$returnvalue = json_encode($returnarray);
echo json_encode($returnarray);
//显示帐户列表
function paycardnum($salerid)
{
$db = new DB_test();
if ($db->nf()) {
while ($db->next_record()) {
$bank_name = g2u($db->f(fd_bank_name));
$paycardkey = $db->f(fd_paycard_key);
$cardno = $db->f(fd_authorbkcard_no);
$cardname = g2u($db->f(fd_authorbkcard_cardname));
$ckr = g2u($db->f(fd_authorbkcard_ckr));
$creditmoney = $db->f(fd_authorbkcard_creditmoney);
$zdr = g2u($db->f(fd_authorbkcard_zdr));
$hkr = g2u($db->f(fd_authorbkcard_hkr));
$mxq = $db->f(fd_authorbkcard_mxq);
$txr = $db->f(fd_authorbkcard_txr);
$dqr = $db->f(fd_authorbkcard_dqr);
$activetime = $db->f(fd_authorbkcard_activetime);
$datetime = $db->f(fd_authorbkcard_datetime);
$txr = g2u($arr_name[$txr]);
if (!$paycardkey) {
$paycardkey = "未绑定刷卡器";
}
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $bank_name, g2u($paycardkey), $cardno, $cardname, $ckr, $creditmoney, $zdr, $hkr, $mxq, $txr, $dqr, $activetime, $datetime);
}
} else {
$vmember = "暂无数据";
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $bank_name, g2u($paycardkey), $cardno, $cardname, $ckr, $creditmoney, $zdr, $hkr, $mxq, $txr, $dqr, $activetime, $datetime);
}
$returnarray['sEcho'] = intval($sEcho);
$returnarray['iTotalRecords'] = $totoalcount;
$returnarray['iTotalDisplayRecords'] = $totoalcount;
$returnarray['aaData'] = $arr_list;
$returnvalue = json_encode($returnarray);
echo json_encode($returnarray);
if($key==$zhunub-1){
$dharray.=']}';
}else{
$dharray.=']},';
}
}else{
if($zhudh['type']==1){
$type='url';
}else{
$type='key';
}
if($key==$zhunub-1){
$dharray.='{"type":"'.$leixin[$zhudh['type']].'","name":"'.g2u($zhudh['title']).'","'.$type.'":"'.g2u($zhudh['content']).'"}';
}else{
$dharray.='{"type":"'.$leixin[$zhudh['type']].'","name":"'.g2u($zhudh['title']).'","'.$type.'":"'.g2u($zhudh['content']).'"},';
}
}
}
$dharray.=']}';
echo $dharray;
}
function u2g($a) {
return is_array($a) ? array_map('u2g', $a) : diconv($a, 'UTF-8', CHARSET);
}
function g2u($a) {
return is_array($a) ? array_map('g2u', $a) : diconv($a, CHARSET, 'UTF-8');
}
}
$vtype = trim($vtype);
$cardsmoney = $cardmoney * $vmembernum;
$ordersmoney = $ordermoney * $vallquanity;
$downcardsmoney = $upcardmoney * $vdownmembernum;
$downordersmoney = $upordermoney * $valldownquanity;
$allmoney = 0;
$allmoney = $cardsmoney + $ordersmoney + $downcardsmoney + $downordersmoney;
//if($j==1) $money=$upmoney;
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $beginmonth, $vtruename, $vtype, $vmembernum, $cardsmoney, $vallquanity, $ordersmoney, $vdownmembernum, $downcardsmoney, $valldownquanity, $downordersmoney, $allmoney);
}
}
}
if ($arr_list == "") {
$vmembernum = "";
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $beginmonth, $vtruename, $vtype, $vsharesaler, $vzjl, $vtype, $vsharesaler, $vzjl, g2u($vmembernum), $cardsmoney, $vallquanity, $ordersmoney);
}
$returnarray['sEcho'] = intval($sEcho);
$returnarray['iTotalRecords'] = $totoalcount;
$returnarray['iTotalDisplayRecords'] = $totoalcount;
$returnarray['aaData'] = $arr_list;
$returnvalue = json_encode($returnarray);
echo json_encode($returnarray);
//显示帐户列表
function selectsaler($sharesalerid)
{
$db = new DB_test();
//显示帐户选择列表
$query = "select * from web_saler where fd_saler_id='{$sharesalerid}'";
$db->query($query);
if ($db->nf()) {
$article = $Db->Fetch($Db->ThisQuery("SELECT * FROM `" . $db_prefix . "collect` WHERE `id` = " . intval($ccid) . ""));
//$idurl=stripslashes($article['idurl']);
//$cc_bid=stripslashes($article['cc_bid']);
//$ccurl=str_replace("[ID]",$cc_bid,$idurl);
$article['charset'] == "gb2312" ? $bodys = g2u(ovovgetfile($cc_lurl)) : ($bodys = ovovgetfile($cc_lurl));
$body_ruler = getrole("</head>||</body>", $article['charset']);
//字符编码
preg_match("/" . $body_ruler . "/iU", $bodys, $bdtt);
echo "<textarea name=\"textarea\" id=\"textarea\" cols=\"92\" rows=\"22\">" . $bdtt[1] . "</textarea>";
break;
case 'viewbody2':
$ccid = intval(trim($_GET['ccid']));
$cc_curl = trim($_GET['cc_curl']);
$article = $Db->Fetch($Db->ThisQuery("SELECT * FROM `" . $db_prefix . "collect` WHERE `id` = " . intval($ccid) . ""));
//echo getfile($cc_curl);
$article['charset'] == "gb2312" ? $bodys = g2u(ovovgetfile($cc_curl)) : ($bodys = ovovgetfile($cc_curl));
$body_ruler = getrole("</head>||</body>", $article['charset']);
//字符编码
preg_match("/" . $body_ruler . "/iU", $bodys, $bdtt);
echo "<textarea name=\"textarea\" id=\"textarea\" cols=\"92\" rows=\"22\">" . $bdtt[1] . "</textarea>";
break;
case 'do_setadd2':
//保存第二步
$cccharset = htmlspecialchars(trim($_POST['cccharset']));
$liebiaoid = intval(trim($_POST['liebiaoid']));
$cc_url = trim($_POST['cc_url']);
$cc_bid = htmlspecialchars(trim($_POST['cc_bid']));
$cc_eid = htmlspecialchars(trim($_POST['cc_eid']));
$cc_buno = intval(trim($_POST['cc_buno']));
$url_list = htmlspecialchars(trim($_POST['url_list']));
if (empty($cc_url) || empty($liebiaoid)) {
$vofanli = "";
$selectarray = array("赠送账户", "充值账户");
$query = "select * from web_memfanlilist\n left join tb_organmem on fd_organmem_id = fd_fanlilist_memberid where fd_fanlilist_state='{$state}' \n {$sWhere} ";
$db->query($query);
//echo $query;
$totoalcount = $db->nf() + 0;
$query .= " limit {$iDisplayStart},{$iDisplayLength} ";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$memberid = $db->f(fd_organmem_id);
$vmember = g2u($db->f(fd_organmem_comnpany));
$s_month = $db->f(fd_fanlilist_month);
$vfanli = $db->f(fd_fanlilist_fanli) + 0;
//echo $vfanli;
$vaccount = $db->f(fd_fanlilist_account);
$vfanli = $vfanli . "<input type='hidden' value='" . $vfanli . "' name='arr_fanli[]'>\n\t <input type='hidden' value='" . $memberid . "' name='arr_memberid[]'>\n\t\t\t\t\t\t <input type='hidden' value='" . $s_month . "' name='arr_month[]'>";
$account = makeselect($selectarray, $vaccount, $selectarray);
$account = "<select name='arr_account[]' >" . g2u($account) . "</select>";
$arr_list[] = array("DT_RowId" => $vmember, "DT_RowClass" => "", $s_month, $vmember, $vfanli, $account);
}
} else {
$vmember = "暂无数据";
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", "", "", "", "");
}
$returnarray['sEcho'] = intval($sEcho);
$returnarray['iTotalRecords'] = $totoalcount;
$returnarray['iTotalDisplayRecords'] = $totoalcount;
$returnarray['aaData'] = $arr_list;
$returnvalue = json_encode($returnarray);
echo json_encode($returnarray);
$paycardid = $db->f(fd_paycard_id);
if ($salepaycardbackstate[$paycardid]['state'] == "9") {
$batches = $db->f(fd_paycard_batches);
$paycardkey = $db->f(fd_paycard_key);
$stockprice = $db->f(fd_paycard_stockprice);
$suppname = g2u($db->f(fd_product_suppname));
$productname = g2u($db->f(fd_product_name));
$scope = $db->f(fd_paycard_scope);
if ($scope == "creditcard") {
$scope = "信用卡";
}
if ($scope == "bankcard") {
$scope = "储蓄卡";
}
$action = "<span style='cursor:pointer;color:blue;' onclick='changestate({$paycardid})'>重新出售</span>";
$arr_list[$count] = array("DT_RowId" => $vid, "DT_RowClass" => "", g2u($action), $paycardid, $batches, $paycardkey, $suppname, $productname, $stockprice, g2u($scope), $salepaycardbackstate[$paycardid]['date'], g2u($salepaycardbackstate[$paycardid]['memo']));
}
}
} else {
$vmember = "暂无数据";
}
if (!$arr_list) {
$arr_list[$count] = array("DT_RowId" => $vid, "DT_RowClass" => "", "", "", "", "", "", "", "", "", "", "");
}
$returnarray['sEcho'] = intval($sEcho);
$returnarray['iTotalRecords'] = $totoalcount;
$returnarray['iTotalDisplayRecords'] = $totoalcount;
$returnarray['aaData'] = $arr_list;
$returnvalue = json_encode($returnarray);
echo json_encode($returnarray);
function getsalepaycardbackstate()
}
$query = "SELECT * FROM `tb_payfeelist`\nleft join tb_paycard on fd_paycard_id=fd_payfee_paycardid \nwhere fd_payfee_tabname='{$tabname}' {$sWhere}";
$db->query($query);
$totoalcount = $db->nf() + 0;
$count = 0;
$query = "{$query} limit {$iDisplayStart},{$iDisplayLength} ";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$vid = $db->f(fd_payfee_id);
//idºÅ
$vpayfeeno = $db->f(fd_payfee_no);
//idºÅ
$vpaycardid = $db->f(fd_paycard_no);
$vaddmoney = $db->f(fd_payfee_addmoney);
$vlessmoney = $db->f(fd_payfee_lessmoney);
$vpaymode = g2u($db->f(fd_payfee_paymode));
$vtime = $db->f(fd_payfee_datetime);
$vpaymemo = g2u($db->f(fd_payfee_memo));
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $vpayfeeno, $vpaycardid, $vaddmoney, $vpaymode, $vtime);
}
} else {
$vmembernum = "ÔÝÎÞÊý¾Ý";
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $vpayfeeno, $vpaycardid, $vaddmoney, $vpaymode, $vtime);
}
$returnarray['sEcho'] = intval($sEcho);
$returnarray['iTotalRecords'] = $totoalcount;
$returnarray['iTotalDisplayRecords'] = $totoalcount;
$returnarray['aaData'] = $arr_list;
$returnvalue = json_encode($returnarray);
echo json_encode($returnarray);
$vperent = g2u($vperent);
$vinitialmoney = $vinitialmoney . "/" . $vsalemoney;
if ($vtype == 1) {
$vtype = "网导员";
} else {
if ($vtype == 2) {
$vtype = "网导经理";
}
}
$vtype = g2u($vtype);
$vedit = '<a class="edit" onclick="edit(' . $vid . ')"> </a> <a class="del" onclick="del(' . $vid . ')"> </a>';
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $vtruename, $vidcard, $vtype, $vsharesaler, $vzjl, $vno, $vinitialmoney, $vperent, $vstate, $vmember, $vedit);
}
} else {
$vmember = "暂无数据";
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $vtruename, $vidcard, $vtype, $vsharesaler, $vzjl, $vno, $vstate, $vno, $vstate, g2u($vmember), $vedit);
}
$returnarray['sEcho'] = intval($sEcho);
$returnarray['iTotalRecords'] = $totoalcount;
$returnarray['iTotalDisplayRecords'] = $totoalcount;
$returnarray['aaData'] = $arr_list;
$returnvalue = json_encode($returnarray);
echo json_encode($returnarray);
//显示帐户列表
function selectsalercard($sharesalerid)
{
$db = new DB_test();
//显示帐户选择列表
$query = "select * from web_saler where fd_saler_id='{$sharesalerid}'";
$db->query($query);
if ($db->nf()) {
}
if ($defeedirct == "f") {
$defeedirct = "付款方";
} else {
$defeedirct = "收款方";
}
if ($mode == "fix") {
$mode = "固定费率";
} else {
$mode = "浮动费率";
}
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $scdmset_name, $auindustry_name, $authornum, g2u($scope), $arrivename, g2u($defeedirct), g2u($mode), $fixfee, $fee, $minfee, $maxfee);
}
} else {
$vmember = "暂无数据";
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $scdmset_name, $auindustry_name, $authornum, g2u($scope), $arrivename, g2u($defeedirct), g2u($mode), $fixfee, $fee, $minfee, $maxfee);
}
}
$returnarray['sEcho'] = intval($sEcho);
$returnarray['iTotalRecords'] = $totoalcount;
$returnarray['iTotalDisplayRecords'] = $totoalcount;
$returnarray['aaData'] = $arr_list;
$returnvalue = json_encode($returnarray);
echo json_encode($returnarray);
function getauthormeal($type)
{
$db = new db_test();
$query = 'select fd_author_' . $type . ',count(fd_author_' . $type . ') as authornum from tb_author group by fd_author_' . $type . '';
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$sWhere .= " AND ";
}
$sWhere .= $aColumns[$i] . " LIKE '%" . trim(${$s_s}) . "%' ";
}
}
$query = "SELECT * FROM `tb_authoraccountglist`\nleft join tb_paycard on fd_paycard_id=fd_accglist_paycardid \nwhere fd_accglist_authorid='{$authorid}' {$sWhere}";
$db->query($query);
$totoalcount = $db->nf() + 0;
$count = 0;
$query = "{$query} limit {$iDisplayStart},{$iDisplayLength} ";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$vid = $db->f(fd_accglist_no);
//idºÅ
$vpaycardid = $db->f(fd_paycard_key);
$vaddmoney = $db->f(fd_accglist_money);
$vpaymode = g2u($db->f(fd_accglist_paytype));
$vtime = $db->f(fd_accglist_datetime);
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $vid, g2u($vtype), $vpaycardid, $vaddmoney, $vpaymode, $vtime);
}
} else {
$vmembernum = "ÔÝÎÞÊý¾Ý";
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $vid, $vtype, $vpaycardid, $vaddmoney, $vpaymode, $vtime);
}
$returnarray['sEcho'] = intval($sEcho);
$returnarray['iTotalRecords'] = $totoalcount;
$returnarray['iTotalDisplayRecords'] = $totoalcount;
$returnarray['aaData'] = $arr_list;
$returnvalue = json_encode($returnarray);
echo json_encode($returnarray);
<?php
require "../include/common.inc.php";
require "../include/json.php";
header('Content-Type:text/html;charset=utf-8');
$db = new db_test();
$query = "select * from web_i_procahotshop where fd_phs_areaid = '{$areaid}' ";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$fd_phs_procaid = $db->f(fd_phs_procaid);
$fd_phs_procaname = g2u($db->f(fd_phs_procaname));
$select[] = array("id" => $fd_phs_procaid, "title" => $fd_phs_procaname);
}
}
if (empty($select)) {
$select[] = array("id" => "", "title" => "");
}
echo json_encode($select);
$vtype = "网导员";
} else {
if ($vtype == 2) {
$vtype = "网导经理";
}
}
$vtype = g2u($vtype);
$cardsmoney = $cardmoney * $vmembernum;
$ordersmoney = $ordermoney * $vallquanity;
//if($j==1) $money=$upmoney;
$vedit = '<a class="edit" onclick="edit(' . $vid . ')"> </a><a class="del" onclick="del(' . $vid . ')"> </a>';
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $beginmonth, $vtruename, $vtype, $vsharesaler, $vzjl, $vmembernum, $cardsmoney, $vallquanity, $ordersmoney);
}
} else {
$vmembernum = "暂无数据";
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $beginmonth, $vzjl, $vtruename, $vidcard, $vtype, $vsharesaler, g2u($vmembernum), $vstate, $vusername, $vedit);
}
$returnarray['sEcho'] = intval($sEcho);
$returnarray['iTotalRecords'] = $totoalcount;
$returnarray['iTotalDisplayRecords'] = $totoalcount;
$returnarray['aaData'] = $arr_list;
$returnvalue = json_encode($returnarray);
echo json_encode($returnarray);
//显示帐户列表
function selectsaler($sharesalerid)
{
$db = new DB_test();
//显示帐户选择列表
$query = "select * from web_saler where fd_saler_id='{$sharesalerid}'";
$db->query($query);
if ($db->nf()) {
$query = "select * from web_test_interface where fd_interface_id ='{$interface_id}'";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
//$interface_id = $db->f(fd_interface_id);
$interface_no = $db->f(fd_interface_no);
$interface_name = $db->f(fd_interface_name);
$interface_url = $db->f(fd_interface_apinamefunc);
$apiname = g2u($db->f(fd_interface_demo));
}
}
$query = "select * from web_test_interface where fd_interface_active = 1 order by fd_interface_sortorder,fd_interface_no asc";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$arr_dept_easyname[] = $db->f(fd_interface_no) . g2u($db->f(fd_interface_name));
$arr_dept_id[] = $db->f(fd_interface_id);
}
}
// echo $interface_id;
$interface_id = makeselect($arr_dept_easyname, $interface_id, $arr_dept_id);
//生成选择菜单的函数
function makeselect($arritem, $hadselected, $arry)
{
for ($i = 0; $i < count($arritem); $i++) {
if ($hadselected == $arry[$i]) {
$x .= "<option selected value='{$arry[$i]}'>" . $arritem[$i] . "</option>";
} else {
$x .= "<option value='{$arry[$i]}'>" . $arritem[$i] . "</option>";
}
}
$paymoney = $db->f(paymoney);
$paytype = $db->f(paytype);
$newspaydata = $db->f(newspaydata);
$everymoney = $db->f(everymoney) + 0;
$everycounts = $db->f(everycounts) + 0;
$neverymoney = $db->f(neverymoney) + 0;
$nallmoney = $db->f(nallmoney) + 0;
if (!$allname) {
$allname = "该刷卡器未销售!";
}
$url = 'checkauthorbank';
$paycardkey = '<a href="#" onclick="checkdetail(this,\'' . $paycardid . '\',\'' . $url . '\')" style="color:blue;">' . $paycardkey . '</a>';
$url = '../report/consp_data';
$paycardcount = '<a href="#" onclick="checkdetail(this,\'' . $paycardid . '\',\'' . $url . '\')" style="color:blue;">' . $paycardcount . '</a>';
$paymoney = '<a href="#" onclick="checkdetail(this,\'' . $paycardid . '\',\'' . $url . '\')" style="color:blue;">' . $paymoney . '</a>';
$arr_list[$count] = array("DT_RowId" => $vid, "DT_RowClass" => "", g2u($paycardkey), $everymoney, $everycounts, $neverymoney, $nallmoney, g2u($allname), g2u($paycardcount), g2u($paymoney), $newspaydata);
$arr_paytype = explode(",", $paytype);
$arr_paytype = array_unique($arr_paytype);
foreach ($arr_paytype as $value) {
$new_data[$paycardid][$value]['paymoney'] = $arr_data[$paycardid][$value]['paymoney'];
$new_data[$paycardid][$value]['paycardcount'] = $arr_data[$paycardid][$value]['paycardcount'];
}
foreach ($arr_appmnu as $key => $v) {
$arr_list[$count][] = $new_data[$paycardid][$key]['paymoney'];
$arr_list[$count][] = $new_data[$paycardid][$key]['paycardcount'];
}
//array_push($arr_list,);
$strpaytype = "";
$count++;
}
} else {
public function readAuthorInfo()
{
$db = new DB_test();
$arr_header = $this->arr_header;
$arr_body = $this->arr_body;
$arr_channelinfo = $this->arr_channelinfo;
$authorid = trim($arr_channelinfo['authorid']);
$arr_message = array("error_id" => "0", "result" => "success", "message" => "读取成功");
$retcode = "0";
//反馈状态 0 成功 200 自定义错误
$query = "select * from tb_author where fd_author_id = '{$authorid}'";
$db->query($query);
if ($db->nf()) {
$db->next_record();
$arr_msg['msgbody']['autruename'] = g2u($db->f(fd_author_truename));
$arr_msg['msgbody']['autrueidcard'] = $db->f(fd_author_idcard);
$arr_msg['msgbody']['auemail'] = $db->f(fd_author_email);
$arr_msg['msgbody']['aumobile'] = $db->f(fd_author_mobile);
$arr_msg['msgbody']['isagentid'] = $db->f(fd_author_cusid);
$isagentid = $arr_msg['msgbody']['isagentid'];
if ($arr_msg['msgbody']['isagentid'] > 0) {
$query = "select * from tb_customer where fd_cus_id = '{$isagentid}'";
if ($db->execute($query)) {
$arr_merinfo = $db->get_one($query);
}
$arr_msg['msgbody']['agentcompany'] = $arr_merinfo['fd_cus_allname'];
$arr_msg['msgbody']['agentarea'] = $arr_merinfo['fd_cus_address'];
$arr_msg['msgbody']['agentaddress'] = $arr_merinfo['fd_cus_shaddress'];
$arr_msg['msgbody']['agentmanphone'] = $arr_merinfo['fd_cus_manphone'];
$arr_msg['msgbody']['agentfax'] = $arr_merinfo['fd_cus_fax'];
$arr_msg['msgbody']['agenthttime'] = $arr_merinfo['fd_cus_htbegintime'] . " - " . $arr_merinfo['fd_cus_htendtime'];
$arr_msg['msgbody']['agentbzmoney'] = $arr_merinfo['fd_cus_bzmoney'];
}
} else {
$arr_message = array("error_id" => "1", "result" => "failure", "message" => "用户信息已失效，请重新登录");
$retcode = "200";
//反馈状态 0 成功 200 自定义错误
}
if ($arr_message['error_id'] == '0') {
$arr_picinfo1 = readAuthorupicinfo("1", $authorid);
$arr_picinfo2 = readAuthorupicinfo("2", $authorid);
$arr_picinfo[] = array_merge($arr_picinfo1, $arr_picinfo2);
$arr_msg['msgbody'][] = $arr_picinfo1['msgchild'];
$arr_msg['msgbody'][] = $arr_picinfo2['msgchild'];
}
$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 static function getauthorusername($authorid)
{
$db = new DB_test();
$query = "select fd_author_state as state,fd_author_truename as truename,fd_author_username as username," . " fd_author_memid as memid,fd_author_shoucardno as shoucardno,fd_author_shoucardman as shoucardman," . " fd_author_shoucardphone as shoucardmobile,fd_author_shoucardbank as shoucardbank from" . " tb_author where fd_author_id = '{$authorid}' ";
if ($db->execute($query)) {
$arr_author = $db->get_one($query);
$authortruename = g2u($arr_author['username']);
}
return $arr_author;
}
$arr_checked[$value] = "checked";
}
}
$query = "SELECT * FROM `tb_paycard`\nleft join tb_product on fd_product_id=fd_paycard_product \nwhere fd_paycard_product='{$productid}' and fd_paycard_cusid='{$cusid}' {$wherepaycard} {$sWhere}";
$db->query($query);
$totoalcount = $db->nf() + 0;
$count = 0;
$query = "{$query} limit {$iDisplayStart},{$iDisplayLength} ";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$vpaycardid = $db->f(fd_paycard_id);
//idºÅ
$vpaycardkey = trim($db->f(fd_paycard_key));
//idºÅ
$vsuppname = g2u($db->f(fd_product_suppname));
$vbatches = $db->f(fd_paycard_batches);
$saleprice = $db->f(fd_paycard_saleprice);
if ($arr_checked) {
$check = $arr_checked[$vpaycardid];
}
$vedit = '<input type="checkbox" name="arr_paycardid[]" value="' . $vpaycardid . '" ' . $check . ' onclick="checkone(\'' . $vpaycardid . '\',this)" class="checkpaycard" >';
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $vbatches, $vpaycardkey, $saleprice, $vsuppname, $vedit);
}
} else {
$vmembernum = "ÔÝÎÞÊý¾Ý";
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $vbatches, $vpaycardid, $saleprice, $vsuppname, $vedit);
}
$returnarray['sEcho'] = intval($sEcho);
$returnarray['iTotalRecords'] = $totoalcount;
$returnarray['iTotalDisplayRecords'] = $totoalcount;
<?php
require "../include/common.inc.php";
require "../include/json.php";
header('Content-Type:text/html;charset=utf-8');
$db = new db_test();
$prov = u2g(unescape($prov));
$query = "select fd_china_city as city from tb_china where fd_china_prov = '{$prov}'\n group by fd_china_city order by fd_china_areacode asc";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$arr_city_code = g2u($db->f(city));
$arr_city_name = g2u($db->f(city));
$select[] = array("id" => $arr_city_code, "title" => $arr_city_name);
}
}
if (empty($select)) {
$select[] = array("id" => "", "title" => "");
}
echo json_encode($select);
$visnewcard = $db->f(fd_paycard_isnew);
$vpaycardtype = $db->f(fd_paycard_scope);
$authortruename = g2u($db->f(fd_author_truename));
$authormobile = $db->f(fd_author_mobile);
if ($vstatus == 1) {
$vstatus = "";
} else {
$vstatus = "";
}
if ($vpaycardtype == "creditcard") {
$vpaycardtype = "ÐÅÓÿ¨";
} elseif ($vpaycardtype == "bankcard") {
$vpaycardtype = "´¢Ð";
}
$visnewcard = $visnewcard ? "" : "";
$vstatus = g2u($vstatus);
$checkall = '<INPUT type=checkbox class=checkbox value=' . $vid . ' rel=arr_paycard name=arr_list[]>';
$vedit = '<a href="paycardmsg.php?listid=' . $vid . '" class="edit" >ÉóºË</a>';
$count++;
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $checkall, $count, $vno, g2u($vpaycardtype), $authortruename, $authormobile, $vtruename, $vbankname, $vdatetime, $vstatus, "", "", g2u($visnewcard), g2u($vedit));
}
} else {
$vmember = "ÔÝÎÞÊý¾Ý";
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $checkall, $count, $vid, $vpaycardtype, $authormobile, $vtruename, $vtruename, $vbankname, $vdatetime, $vstatus, $visnewcard, "", "", $vedit);
}
$returnarray['sEcho'] = intval($sEcho);
$returnarray['iTotalRecords'] = $totoalcount;
$returnarray['iTotalDisplayRecords'] = $totoalcount;
$returnarray['aaData'] = $arr_list;
$returnvalue = json_encode($returnarray);
echo json_encode($returnarray);
$getmemodgname = g2u($db->f(fd_getmemberglide_odgname));
$getmemidgname = g2u($db->f(fd_getmemberglide_idgname));
$getmemmemo = g2u($db->f(fd_getmemberglide_memo));
$getmemodg = $db->f(fd_getmemberglide_odg);
$getmemidg = $db->f(fd_getmemberglide_idg);
$getmemid = $db->f(fd_getmemberglide_memid);
$getmemonewsname = g2u(getnewssaler($getmemodg));
//被抢注现在名
$getmeminewsname = g2u(getnewssaler($getmemidg));
//抢注现在名
$query = "select fd_organmem_comnpany,fd_organmem_mobile from tb_organmem where fd_organmem_id='{$getmemid}'";
$db2->query($query);
if ($db2->nf()) {
$db2->next_record();
$getmemcompany = g2u($db2->f(fd_organmem_comnpany));
$getmemmobile = g2u($db2->f(fd_organmem_mobile));
}
$getcompanybile = $getmemcompany . "({$getmemmobile})";
//$vedit = ' <b class="editable_select" > Edit me!</b>';
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $getcompanybile, $getmemidgname, $getmeminewsname, $getmemodgname, $getmemonewsname, $getmemmemo, $getmemdate);
}
} else {
$vmember = "暂无数据";
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", "", "", "", "", "", "");
}
$returnarray['sEcho'] = intval($sEcho);
$returnarray['iTotalRecords'] = $totoalcount;
$returnarray['iTotalDisplayRecords'] = $totoalcount;
$returnarray['aaData'] = $arr_list;
$returnvalue = json_encode($returnarray);
echo json_encode($returnarray);
<?php
header('Content-Type: application/x-www-form-urlencoded');
header('Content-Type: text/html;charset=gb2312');
require "../include/common.inc.php";
require_once '../include/json.php';
$db = new db_test();
$query = "select * from web_adminlog where fd_log_listid='{$log_shopid}'";
$db->query($query);
$totoalcount = $db->nf() + 0;
if ($db->nf()) {
while ($db->next_record()) {
$zcpeopleid = $db->f(d_log_czpeopleid);
$zcpeople = $db->f(fd_log_czpeole);
$zctime = $db->f(fd_log_cztime);
$czsql = $db->f(fd_log_sql);
$zctype = $db->f(fd_log_cztype);
$zcpeople = "<span id='{$zcpeopleid}'>{$zcpeople}</span>";
$arr_list[] = array($zcpeople, $zctype, $czsql, $zctime, $vmember);
}
} else {
$vmember = "ÔÝÎÞÊý¾Ý";
$arr_list[] = array($zcpeople, $zctype, $czsql, $zctime, g2u($vmember));
}
$returnarray['sEcho'] = intval($sEcho);
$returnarray['iTotalRecords'] = $totoalcount;
$returnarray['iTotalDisplayRecords'] = $totoalcount;
$returnarray['aaData'] = $arr_list;
$returnvalue = json_encode($returnarray);
echo json_encode($returnarray);
$file['encode_selected']['UTF-8'] = 'selected="selected"';
$file['encode_selected']['GB2312'] = '';
}
//
$textarea = array();
$textarea['main']['width'] = C('EDIT_CONF.EDITOR_CONF.WIDTH') - 35;
$textarea['main']['height'] = C('EDIT_CONF.EDITOR_CONF.HEIGHT') - 250;
$textarea['edit']['width'] = $textarea['main']['width'] - 10;
$textarea['edit']['height'] = $textarea['main']['height'] - 10;
$textarea['language'] = $file['language'] ? $file['language'] : 'text';
$textarea['content'] = '';
foreach ($file['content'] as $key => $val) {
if ('UTF-8' == $file['encode'] || 'UTF-8 BOM' == $file['encode']) {
$textarea['content'] .= htmlspecialchars($val);
} elseif ('GB2312' == $file['encode']) {
$textarea['content'] .= g2u(htmlspecialchars($val));
} else {
$textarea['content'] .= htmlspecialchars($val);
}
}
print <<<END
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>WebFTP 编辑器</title>
<link href="static/css/edit.css" media="screen" rel="stylesheet" type="text/css" />
<script type="text/javascript">
var editfile = '{$file['file_utf']}';
var mainwidth = '{$textarea['main']['width']}';
var mainheight = '{$textarea['main']['height']}';
} else {
$newdate = date("Y-m", time());
$querydate = "date_format(fd_agpm_paydate,'%Y-%m')='{$newdate}'";
$querydate1 = "date_format(fd_pmreq_reqdatetime,'%Y-%m')='{$newdate}'";
}
if ($arr_type[0] == "use") {
$query = "select \n\tcase \n when fd_agpm_paytype ='coupon' then '购买抵用券'\n when fd_agpm_paytype ='creditcard' then '信用卡还款'\n when fd_agpm_paytype ='recharge' then '充值'\n when fd_agpm_paytype ='repay' then '还贷款'\n when fd_agpm_paytype ='order' then '订单付款'\n when fd_agpm_paytype ='tfmg' then '转账汇款'\n else '其他业务' END paytype,\n\t\tcase \n when fd_agpm_payrq ='01' then '<font color=blue>请求交易</font>'\n when fd_agpm_payrq ='00' then '<font color=green>交易完成</font>'\n when fd_agpm_payrq ='03' then '<font color=red>交易取消</font>'\n else '无效状态' END payrq,\n\tfd_paycard_key as paycardkey,\n\tfd_agpm_paymoney as paymoney,\n\tfd_agpm_payfee as payfee,\n\tfd_agpm_paydate as paydate\n\t from tb_agentpaymoneylist\n\tleft join tb_paycard on fd_agpm_paycardid=fd_paycard_id\n\twhere fd_agpm_authorid='{$authorid}' and {$querydate} and fd_agpm_payrq='00'\n\tand fd_paycard_scope ='{$scope}'";
$db->query($query);
$totoalcount = $db->nf() + 0;
$query = "{$query} limit {$iDisplayStart},{$iDisplayLength} ";
$db->query($query);
if ($db->nf()) {
while ($db->next_record()) {
$paycardkey = $db->f(paycardkey);
$paytype = g2u($db->f(paytype));
$payrq = g2u($db->f(payrq));
$paymoney = $db->f(paymoney);
$paydate = $db->f(paydate);
$payfee = $db->f(payfee);
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $paycardkey, $paytype, $payrq, $paydate, $paymoney, $payfee);
}
} else {
$vmember = "暂无数据";
$arr_list[] = array("DT_RowId" => $vid, "DT_RowClass" => "", $paycardkey, $paytype, $payrq, $paydate, $paymoney, $payfee);
}
} else {
$query = "select \n\t\tdate_format(fd_pmreq_reqdatetime,'%Y-%m-%d') as reqdatetime ,\n\t\tfd_pmreq_repmoney as repmoney , fd_pmreq_reqmoney as reqmoney\n\t\t\n\t from tb_slotcardmoneyreq \n\t left join tb_slotcardmoneyset on fd_scdmset_id=fd_pmreq_paymsetid\n\twhere fd_pmreq_authorid='{$authorid}' and fd_pmreq_paymsetid='{$scdmsetid}' and {$querydate1} and fd_pmreq_state <>'0' and fd_scdmset_scope='{$scope}'\n\t";
$db->query($query);
$totoalcount = $db->nf() + 0;
$query = "{$query} limit {$iDisplayStart},{$iDisplayLength} ";
$db->query($query);
