/**
* 获得用户余额
* @param int $user_id
* @param int $user_type
* @return
* * pMerCode 6 “平台”账号 否 由IPS颁发的商户号
pErrCode 4 返回状态 否 0000成功； 9999失败；
pErrMsg 100 返回信息 否 状态0000：成功 除此乊外：反馈实际原因
pIpsAcctNo 30 IPS账户号 否 查询时提交
pBalance 10 可用余额 否 带正负符号，带小数点，最多保留两位小数
pLock 10 冻结余额 否 带正负符号，带小数点，最多保留两位小数
pNeedstl 10 未结算余额 否 带正负符号，带小数点，最多保留两位小数
*/
function GetIpsUserMoney($user_id, $user_type = 0)
{
$class_name = getCollName();
require_once APP_ROOT_PATH . "system/collocation/" . $class_name . "_collocation.php";
$collocation_class = $class_name . "_collocation";
$collocation_object = new $collocation_class();
$result = $collocation_object->QueryForAccBalance($user_id, $user_type);
return $result;
}
public function relation_export_csv($page = 1)
{
set_time_limit(0);
$limit = ($page - 1) * intval(app_conf("BATCH_PAGE_SIZE")) . "," . intval(app_conf("BATCH_PAGE_SIZE"));
if (isset($_REQUEST['id']) && intval(strim($_REQUEST['id'])) > 0) {
} else {
return;
}
if ($limit) {
$limit = " limit " . $limit;
}
$className = getCollName();
//环迅
if (strtolower($className) == "ips") {
$condition = " where 1=1 ";
$condition .= " and t.pid = " . intval(strim($_REQUEST['id']));
$GLOBALS['tmpl']->assign('id', intval(strim($_REQUEST['id'])));
$sql = "select t.*,t.id as mid,l.* from " . DB_PREFIX . "ips_transfer_detail as t LEFT JOIN " . DB_PREFIX . "ips_transfer it on t.pid = it.id\r\n\tLEFT JOIN " . DB_PREFIX . "deal_load l on l.deal_id = it.deal_id ";
$count_sql = "select count(*) from " . DB_PREFIX . "ips_transfer_detail as t \r\n\t\t\tLEFT JOIN " . DB_PREFIX . "ips_transfer it on t.pid = it.id\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal_load l on l.deal_id = it.deal_id ";
$list = $GLOBALS['db']->getAll($sql . $condition . $limit);
//取得满足条件的记录数
$list_count = $GLOBALS['db']->getOne($count_sql . $condition);
//print_r($count);die;
//$name=$this->getActionName();
} elseif (strtolower($className) == "yeepay") {
$condition = " where bizType = 'TENDER' and is_complete_transaction = 1 and t.code ='1' and is_callback = 1 ";
$condition .= " and t.id = " . intval(strim($_REQUEST['id']));
$GLOBALS['tmpl']->assign('id', intval(strim($_REQUEST['id'])));
$sql = "select t.*,t.id as mid,l.*,u.user_name, 'Y' as pStatus,FROM_UNIXTIME(t.update_time,'%Y-%m-%d') as pIpsDetailTime,\r\n\t\t\trequestNo as pIpsDetailBillNo,l.money as pTrdAmt,fee as pIpsFee\r\n\t\t\t from " . DB_PREFIX . "yeepay_cp_transaction as t\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal_load l on l.deal_id = t.tenderOrderNo and l.pMerBillNo = t.requestNo \r\n\t\t\tleft join " . DB_PREFIX . "user u on u.id = t.platformUserNo ";
$count_sql = "select count(*) from " . DB_PREFIX . "yeepay_cp_transaction as t \r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal_load l on l.deal_id = t.tenderOrderNo and l.pMerBillNo = t.requestNo \r\n\t\t\tleft join " . DB_PREFIX . "user u on u.id = t.platformUserNo ";
$list = $GLOBALS['db']->getAll($sql . $condition . $limit);
//取得满足条件的记录数
$list_count = $GLOBALS['db']->getOne($count_sql . $condition);
} elseif (strtolower($className) == "baofoo") {
$condition = " where action_type = '2' and t.code ='CSD000' and is_callback = 1 ";
$condition .= " and t.id = " . intval(strim($_REQUEST['id']));
$GLOBALS['tmpl']->assign('id', intval(strim($_REQUEST['id'])));
$sql = "select t.*,t.id as mid,l.*,u.user_name,FROM_UNIXTIME(req_time/1000,'%Y-%m-%d') as pIpsDetailTime,\r\n\t\t\torder_id as pIpsDetailBillNo,l.money as pTrdAmt,fee as pIpsFee,'Y' as pStatus\r\n\t\t\t from " . DB_PREFIX . "baofoo_business as t\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal_load l on l.deal_id = t.cus_id and l.pMerBillNo = t.order_id \r\n\t\t\tleft join " . DB_PREFIX . "user u on u.id = t.load_user_id ";
$count_sql = "select count(*) from " . DB_PREFIX . "baofoo_business as t \r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal_load l on l.deal_id = t.cus_id and l.pMerBillNo = t.order_id \r\n\t\t\tleft join " . DB_PREFIX . "user u on u.id = t.load_user_id ";
$list = $GLOBALS['db']->getAll($sql . $condition . $limit);
//取得满足条件的记录数
$list_count = $GLOBALS['db']->getOne($count_sql . $condition);
//print_r($count);die;
//$name=$this->getActionName();
}
if ($list) {
register_shutdown_function(array(&$this, 'relation_export_csv'), $page + 1);
$list_value = array('id' => '""', 'user_name' => '""', 'pTrdAmt' => '""', 'pStatus' => '""', 'pIpsDetailTime' => '""');
if ($page == 1) {
$content = iconv("utf-8", "gbk", "编号,投资人,交易金额,转账状态,明细处理时间");
$content = $content . "\n";
}
foreach ($list as $k => $v) {
$list_value["id"] = '"' . iconv('utf-8', 'gbk', $v["mid"]) . '"';
$list_value["user_name"] = '"' . iconv('utf-8', 'gbk', $v["user_name"]) . '"';
$list_value["pTrdAmt"] = '"' . iconv('utf-8', 'gbk', $v["pTrdAmt"]) . '"';
if (strim($v["pStatus"])) {
$list_value["pStatus"] = '"' . iconv('utf-8', 'gbk', l("P_TRANSFER_STATUS_" . $v["pStatus"])) . '"';
} else {
$list_value["pStatus"] = "";
}
$list_value["pIpsDetailTime"] = '"' . iconv('utf-8', 'gbk', $v["pIpsDetailTime"]) . '"';
$content .= implode(",", $list_value) . "\n";
}
header("Content-Disposition: attachment; filename=order_list.csv");
echo $content;
} else {
if ($page == 1) {
$this->error(L("NO_RESULT"));
}
}
}
function SincerityGoldUnfreeze()
{
$user_id = intval(strim($_REQUEST['user_id']));
$user_type = intval(strim($_REQUEST['user_type']));
$freezeRequestNo = floatval(strim($_REQUEST['freezeRequestNo']));
$deal_id = intval(strim($_REQUEST['deal_id']));
$pTrdBnkCode = strim($_REQUEST['pTrdBnkCode']);
$data = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user where id = " . $user_id);
if (empty($data)) {
showErr('用户不存在', 0);
} else {
if (!empty($data['ips_acct_no'])) {
$class_name = getCollName();
require_once APP_ROOT_PATH . "system/collocation/" . $class_name . "_collocation.php";
$collocation_class = $class_name . "_collocation";
$collocation_object = new $collocation_class();
$collocation_object->set_mobile_sys();
$collocation_code = $collocation_object->SincerityGoldUnfreeze($user_id, $user_type, $freezeRequestNo, $deal_id, $pTrdBnkCode);
print_r($collocation_code);
} else {
showErr('该用户还未申请过资金托管帐户', 0);
}
}
}
public function bank()
{
$bank_list = $GLOBALS['db']->getAll("SELECT ub.*,b.icon FROM " . DB_PREFIX . "user_bank ub left join " . DB_PREFIX . "bank b on ub.bank_id=b.id where user_id=" . intval($GLOBALS['user_info']['id']) . " ORDER BY id ASC");
foreach ($bank_list as $k => $v) {
$bank_list[$k]['bankcode'] = str_replace(" ", "", $v['bankcard']);
}
$GLOBALS['tmpl']->assign("bank_list", $bank_list);
make_delivery_region_js();
if (app_conf("OPEN_IPS") > 0) {
if (strtolower(getCollName()) == "yeepay") {
$yee_bank = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "yeepay_bind_bank_card where is_callback =1 and code =1 and platformUserNo = " . intval($GLOBALS['user_info']['id']));
$GLOBALS['tmpl']->assign("yee_bank", $yee_bank);
$GLOBALS['tmpl']->assign("is_yee", 1);
}
//手续费
$fee_config = load_auto_cache("user_carry_config");
$json_fee = array();
foreach ($fee_config as $k => $v) {
$json_fee[] = $v;
if ($v['fee_type'] == 1) {
$fee_config[$k]['fee_format'] = $v['fee'] . "%";
} else {
$fee_config[$k]['fee_format'] = format_price($v['fee']);
}
}
$GLOBALS['tmpl']->assign("fee_config", $fee_config);
$GLOBALS['tmpl']->assign("json_fee", json_encode($json_fee));
}
$GLOBALS['tmpl']->assign("page_title", $GLOBALS['lang']['UC_CARRY']);
$GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_money_carry_bank.html");
$GLOBALS['tmpl']->display("page/uc.html");
}
public function transfer_export_csv($page = 1)
{
set_time_limit(0);
$limit = ($page - 1) * intval(app_conf("BATCH_PAGE_SIZE")) . "," . intval(app_conf("BATCH_PAGE_SIZE"));
$start_time = strim($_REQUEST['start_time']);
$end_time = strim($_REQUEST['end_time']);
$d = explode('-', $start_time);
if (isset($_REQUEST['start_time']) && $start_time != "" && checkdate($d[1], $d[2], $d[0]) == false) {
$this->error("开始时间不是有效的时间格式:{$start_time}(yyyy-mm-dd)");
exit;
}
$d = explode('-', $end_time);
if (isset($_REQUEST['end_time']) && strim($end_time) != "" && checkdate($d[1], $d[2], $d[0]) == false) {
$this->error("结束时间不是有效的时间格式:{$end_time}(yyyy-mm-dd)");
exit;
}
if ($start_time != "" && strim($end_time) != "" && to_timespan($start_time) > to_timespan($end_time)) {
$this->error('开始时间不能大于结束时间:' . $start_time . '至' . $end_time);
exit;
}
if ($limit) {
$limit = " limit " . $limit;
}
$className = getCollName();
//环迅
if (strtolower($className) == "ips") {
$where = " where pErrCode ='MG00000F' ";
if (isset($_REQUEST['user_name']) && intval(strim($_REQUEST['user_name'])) >= 0) {
$where .= " and u.user_name like '%" . strim($_REQUEST['user_name']) . "%'";
}
if (strim($start_time) != "") {
$where .= " and UNIX_TIMESTAMP(pDwDate) >=" . to_timespan(strim($start_time));
}
if (strim($end_time) != "") {
$where .= " and UNIX_TIMESTAMP(pDwDate) <=" . to_timespan(strim($end_time));
}
$list = $GLOBALS['db']->getAll("select a.*,u.user_name from " . DB_PREFIX . "ips_do_dw_trade a left join " . DB_PREFIX . "user u on a.user_id = u.id " . $where . $limit);
$list_count = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "ips_do_dw_trade " . $where);
foreach ($list as $k => $v) {
$list[$k]["user_type"] = l('P_USER_TYPE_' . $v["user_type"]);
$list[$k]["pAcctType"] = l('P_ACCT_TYPE_' . $v["pAcctType"]);
$list[$k]["pOutType"] = l('P_OUT_TYPE_' . $v["pOutType"]);
$list[$k]["pIpsFeeType"] = l('P_IPS_FEE_TYPE_' . $v["pIpsFeeType"]);
}
} elseif (strtolower($className) == "yeepay") {
$where = " where yw.code ='1' and yw.is_callback = 1 ";
if (isset($_REQUEST['user_name']) && intval(strim($_REQUEST['user_name'])) >= 0) {
$where .= " and u.user_name like '%" . strim($_REQUEST['user_name']) . "%'";
}
if (strim($start_time) != "") {
$where .= " and yw.create_time >=" . to_timespan(strim($start_time));
}
if (strim($end_time) != "") {
$where .= " and yw.create_time <=" . to_timespan(strim($end_time));
}
$y_sql = "select yw.id, requestNo as pIpsBillNo,u.real_name as pRealName,u.user_name,u.user_type,1 as pOutType,\r\n\t\t\tFROM_UNIXTIME(yw.create_time ,'%Y-%m-%d')as pDwDate,amount as pTrdAmt,fee as pMerFee , \r\n\t\t\tu.idno as pIdentNo,\r\n\t\t\tcase when feeMode ='PLATFORM' then 1 else 2 end as pIpsFeeType\r\n\t\t\t from " . DB_PREFIX . "yeepay_withdraw yw left join " . DB_PREFIX . "user u on yw.platformUserNo = u.id " . $where . $limit;
$list = $GLOBALS['db']->getAll($y_sql);
$list_count = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "yeepay_withdraw yw left join " . DB_PREFIX . "user u on yw.platformUserNo = u.id " . $where);
foreach ($list as $k => $v) {
$list[$k]["user_type"] = l('P_USER_TYPE_' . $v["user_type"]);
$list[$k]["pAcctType"] = l('P_ACCT_TYPE_' . $v["pAcctType"]);
$list[$k]["pOutType"] = l('P_OUT_TYPE_' . $v["pOutType"]);
$list[$k]["pIpsFeeType"] = l('P_IPS_FEE_TYPE_' . $v["pIpsFeeType"]);
}
} elseif (strtolower($className) == "baofoo") {
$where = " where yw.code ='CSD000' and yw.is_callback = 1 ";
if (isset($_REQUEST['user_name']) && intval(strim($_REQUEST['user_name'])) >= 0) {
$where .= " and u.user_name like '%" . strim($_REQUEST['user_name']) . "%'";
}
if (strim($start_time) != "") {
$where .= " and yw.create_time >=" . to_timespan(strim($start_time));
}
if (strim($end_time) != "") {
$where .= " and yw.create_time <=" . to_timespan(strim($end_time));
}
$y_sql = "select yw.id, order_id as pIpsBillNo,u.real_name as pRealName,u.user_name,u.user_type,1 as pOutType,\r\n\t\t\tFROM_UNIXTIME(yw.create_time ,'%Y-%m-%d')as pDwDate,amount as pTrdAmt,fee as pMerFee , \r\n\t\t\tu.idno as pIdentNo,\r\n\t\t\tfee_taken_on as pIpsFeeType\r\n\t\t\t from " . DB_PREFIX . "baofoo_fo_charge yw left join " . DB_PREFIX . "user u on yw.user_id = u.id " . $where . $limit;
$list = $GLOBALS['db']->getAll($y_sql);
$list_count = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "baofoo_fo_charge yw left join " . DB_PREFIX . "user u on yw.user_id = u.id " . $where);
foreach ($list as $k => $v) {
$list[$k]["user_type"] = l('P_USER_TYPE_' . $v["user_type"]);
$list[$k]["pAcctType"] = l('P_ACCT_TYPE_' . $v["pAcctType"]);
$list[$k]["pOutType"] = l('P_OUT_TYPE_' . $v["pOutType"]);
$list[$k]["pIpsFeeType"] = l('P_IPS_FEE_TYPE_' . $v["pIpsFeeType"]);
}
}
if ($list) {
register_shutdown_function(array(&$this, 'transfer_export_csv'), $page + 1);
$list_value_old = array('id' => '""', 'user_name' => '""', 'user_type' => '""', 'pOutType' => '""', 'pIdentNo' => '""', 'pRealName' => '""', 'pDwDate' => '""', 'pTrdAmt' => '""', 'pMerFee' => '""', 'pIpsFeeType' => '""');
if ($page == 1) {
$content = iconv("utf-8", "gbk", "编号,用户名,用户类型,提现模式,证件号码,姓名,提现日期,交易金额,平台手续费,手续费支付方");
$content = $content . "\n";
}
foreach ($list as $k => $v) {
$list_value = $list_value_old;
$list_value["user_name"] = '"' . iconv('utf-8', 'gbk', $v["user_name"]) . '"';
$list_value["id"] = '"' . iconv('utf-8', 'gbk', $v["id"]) . '"';
$list_value["user_type"] = '"' . iconv('utf-8', 'gbk', $v["user_type"]) . '"';
$list_value["pOutType"] = '"' . iconv('utf-8', 'gbk', $v["pOutType"]) . '"';
$list_value["pIdentNo"] = '"' . iconv('utf-8', 'gbk', $v["pIdentNo"]) . '"';
$list_value["pRealName"] = '"' . iconv('utf-8', 'gbk', $v["pRealName"]) . '"';
$list_value["pDwDate"] = '"' . iconv('utf-8', 'gbk', $v["pDwDate"]) . '"';
$list_value["pMerFee"] = '"' . iconv('utf-8', 'gbk', $v["pMerFee"]) . '"';
$list_value["pTrdAmt"] = '"' . iconv('utf-8', 'gbk', $v["pTrdAmt"]) . '"';
$list_value["pIpsFeeType"] = '"' . iconv('utf-8', 'gbk', $v["pIpsFeeType"]) . '"';
$content .= implode(",", $list_value) . "\n";
}
header("Content-Disposition: attachment; filename=order_list.csv");
echo $content;
} else {
if ($page == 1) {
$this->error(L("NO_RESULT"));
}
}
}
public function back_export_csv($page = 1)
{
set_time_limit(0);
$limit = ($page - 1) * intval(app_conf("BATCH_PAGE_SIZE")) . "," . intval(app_conf("BATCH_PAGE_SIZE"));
$start_time = strim($_REQUEST['start_time']);
$end_time = strim($_REQUEST['end_time']);
$d = explode('-', $start_time);
if (isset($_REQUEST['start_time']) && $start_time != "" && checkdate($d[1], $d[2], $d[0]) == false) {
$this->error("开始时间不是有效的时间格式:{$start_time}(yyyy-mm-dd)");
exit;
}
$d = explode('-', $end_time);
if (isset($_REQUEST['end_time']) && strim($end_time) != "" && checkdate($d[1], $d[2], $d[0]) == false) {
$this->error("结束时间不是有效的时间格式:{$end_time}(yyyy-mm-dd)");
exit;
}
if ($start_time != "" && strim($end_time) != "" && to_timespan($start_time) > to_timespan($end_time)) {
$this->error('开始时间不能大于结束时间:' . $start_time . '至' . $end_time);
exit;
}
$page = intval($_REQUEST['p']);
if ($page == 0) {
$page = 1;
}
$limit = ($page - 1) * app_conf("PAGE_SIZE") . "," . app_conf("PAGE_SIZE");
if ($limit) {
$limit = " limit " . $limit;
}
$className = getCollName();
//环迅
if (strtolower($className) == "ips") {
$condition = " where pStatus = 'Y'";
if (strim($_REQUEST['pBidNo']) != '') {
$condition .= " and dl.id like '%" . strim($_REQUEST['pBidNo']) . "%'";
}
if (strim($_REQUEST['deal_name']) != '') {
$condition .= " and dl.name like '%" . strim($_REQUEST['deal_name']) . "%'";
}
if (strim($_REQUEST['user_name']) != '') {
$condition .= " and u.user_name like '%" . strim($_REQUEST['user_name']) . "%'";
}
if (strim($start_time) != "") {
$condition .= " and r.repay_time >=" . to_timespan(strim($start_time));
}
if (strim($end_time) != "") {
$condition .= " and r.repay_time <=" . to_timespan(strim($end_time));
}
$sql = "select d.*,r.*,deal_t.pBidNo,d.id as mid ,u.user_name,dl.name as deal_name from " . DB_PREFIX . "ips_repayment_new_trade_detail as d\r\n\t\t\tleft JOIN " . DB_PREFIX . "deal_load_repay r on r.id = d.deal_load_repay_id\r\n\t\t\tleft JOIN " . DB_PREFIX . "deal dl on dl.id = r.deal_id\r\n\t\t\tleft join " . DB_PREFIX . "user u on u.id = dl.user_id\r\n\t\t\tleft JOIN " . DB_PREFIX . "ips_repayment_new_trade deal_t on deal_t.id = d.pid";
$count_sql = "select count(*) from " . DB_PREFIX . "ips_repayment_new_trade_detail as d\r\n\t\t\tleft JOIN " . DB_PREFIX . "deal_load_repay r on r.id = d.deal_load_repay_id\r\n\t\t\tleft JOIN " . DB_PREFIX . "deal dl on dl.id = r.deal_id\r\n\t\t\tleft join " . DB_PREFIX . "user u on u.id = dl.user_id";
$list = $GLOBALS['db']->getAll($sql . $condition . " order by d.id desc" . $limit);
//取得满足条件的记录数
$list_count = $GLOBALS['db']->getOne($count_sql . $condition);
} elseif (strtolower($className) == "yeepay") {
$condition = " where deal_t.bizType = 'REPAYMENT' and deal_t.is_complete_transaction = 1 and deal_t.code ='1' and deal_t.is_callback = 1 ";
if (strim($_REQUEST['pBidNo']) != '') {
$condition .= " and dl.id like '%" . strim($_REQUEST['pBidNo']) . "%'";
}
if (strim($_REQUEST['deal_name']) != '') {
$condition .= " and dl.name like '%" . strim($_REQUEST['deal_name']) . "%'";
}
if (strim($_REQUEST['user_name']) != '') {
$condition .= " and u.user_name like '%" . strim($_REQUEST['user_name']) . "%'";
}
if (strim($start_time) != "") {
$condition .= " and r.repay_time >=" . to_timespan(strim($start_time));
}
if (strim($end_time) != "") {
$condition .= " and r.repay_time <=" . to_timespan(strim($end_time));
}
$sql = "select d.*,r.*,deal_t.tenderOrderNo as pBidNo,d.id as mid ,u.user_name,dl.name as deal_name \r\n\t\t\tfrom " . DB_PREFIX . "yeepay_cp_transaction_detail as d\r\n\t\t\tleft JOIN " . DB_PREFIX . "deal_load_repay r on r.id = d.deal_load_repay_id\r\n\t\t\tleft JOIN " . DB_PREFIX . "deal dl on dl.id = r.deal_id\r\n\t\t\tleft join " . DB_PREFIX . "user u on u.id = dl.user_id\r\n\t\t\tleft JOIN " . DB_PREFIX . "yeepay_cp_transaction deal_t on deal_t.id = d.pid";
$count_sql = "select count(*) \r\n\t\t\tfrom " . DB_PREFIX . "yeepay_cp_transaction_detail as d\r\n\t\t\tleft JOIN " . DB_PREFIX . "deal_load_repay r on r.id = d.deal_load_repay_id\r\n\t\t\tleft JOIN " . DB_PREFIX . "deal dl on dl.id = r.deal_id\r\n\t\t\tleft join " . DB_PREFIX . "user u on u.id = dl.user_id\r\n\t\t\tleft JOIN " . DB_PREFIX . "yeepay_cp_transaction deal_t on deal_t.id = d.pid";
$list = $GLOBALS['db']->getAll($sql . $condition . " order by d.id desc" . $limit);
//取得满足条件的记录数
$list_count = $GLOBALS['db']->getOne($count_sql . $condition);
} elseif (strtolower($className) == "baofoo") {
$condition = " where 1=1 ";
if (strim($_REQUEST['pBidNo']) != '') {
$condition .= " and dl.id like '%" . strim($_REQUEST['pBidNo']) . "%'";
}
if (strim($_REQUEST['deal_name']) != '') {
$condition .= " and dl.name like '%" . strim($_REQUEST['deal_name']) . "%'";
}
if (strim($_REQUEST['user_name']) != '') {
$condition .= " and u.user_name like '%" . strim($_REQUEST['user_name']) . "%'";
}
if (strim($start_time) != "") {
$condition .= " and r.repay_time >=" . to_timespan(strim($start_time));
}
if (strim($end_time) != "") {
$condition .= " and r.repay_time <=" . to_timespan(strim($end_time));
}
$sql = "select d.*,r.*,deal_t.cus_id as pBidNo,d.id as mid ,u.user_name,dl.name as deal_name \r\n\t\t\tfrom " . DB_PREFIX . "baofoo_business_detail as d\r\n\t\t\tleft JOIN " . DB_PREFIX . "deal_load_repay r on r.id = d.deal_load_repay_id\r\n\t\t\tleft JOIN " . DB_PREFIX . "deal dl on dl.id = r.deal_id\r\n\t\t\tleft join " . DB_PREFIX . "user u on u.id = dl.user_id\r\n\t\t\tleft JOIN " . DB_PREFIX . "baofoo_business deal_t on deal_t.id = d.pid";
$count_sql = "select count(*) \r\n\t\t\tfrom " . DB_PREFIX . "baofoo_business_detail as d\r\n\t\t\tleft JOIN " . DB_PREFIX . "deal_load_repay r on r.id = d.deal_load_repay_id\r\n\t\t\tleft JOIN " . DB_PREFIX . "deal dl on dl.id = r.deal_id\r\n\t\t\tleft join " . DB_PREFIX . "user u on u.id = dl.user_id";
$list = $GLOBALS['db']->getAll($sql . $condition . " order by d.id desc" . $limit);
//取得满足条件的记录数
$list_count = $GLOBALS['db']->getOne($count_sql . $condition);
}
foreach ($list as $k => $v) {
if ($v["status"] == 0) {
$v["status"] = "提前";
}
if ($v["status"] == 1) {
$v["status"] = "准时";
}
if ($v["status"] == 2) {
$v["status"] = "逾期";
}
if ($v["status"] == 3) {
$v["status"] = "严重逾期";
}
$list[$k]["status"] = $v["status"];
}
if ($list) {
register_shutdown_function(array(&$this, 'deal_export_csv'), $page + 1);
$list_value = array('mid' => '""', 'pBidNo' => '""', 'deal_name' => '""', 'user_name' => '""', 'repay_time' => '""', 'true_repay_time' => '""', 'repay_money' => '""', 'true_manage_money' => '""', 'true_manage_interest_money' => '""', 'impose_money' => '""', 'status' => '""');
if ($page == 1) {
$content = iconv("utf-8", "gbk", "编号,标号,贷款名称,投标人,还款日,实际还款日,已收本息,管理费,利息管理费,罚息/违约金,状态");
$content = $content . "\n";
}
foreach ($list as $k => $v) {
$list_value["mid"] = '"' . iconv('utf-8', 'gbk', $v["mid"]) . '"';
$list_value["pBidNo"] = '"' . iconv('utf-8', 'gbk', $v["pBidNo"]) . '"';
$list_value["deal_name"] = '"' . iconv('utf-8', 'gbk', $v["deal_name"]) . '"';
$list_value["user_name"] = '"' . iconv('utf-8', 'gbk', $v["user_name"]) . '"';
$list_value["repay_time"] = '"' . iconv('utf-8', 'gbk', to_date($v["repay_time"], "Y-m-d")) . '"';
$list_value["true_repay_time"] = '"' . iconv('utf-8', 'gbk', to_date($v["true_repay_time"], "Y-m-d")) . '"';
$list_value["repay_money"] = '"' . iconv('utf-8', 'gbk', $v["repay_money"]) . '"';
$list_value["true_manage_money"] = '"' . iconv('utf-8', 'gbk', $v["true_manage_money"]) . '"';
$list_value["impose_money"] = '"' . iconv('utf-8', 'gbk', $v["impose_money"]) . '"';
$list_value["true_manage_interest_money"] = '"' . iconv('utf-8', 'gbk', $v["true_manage_interest_money"]) . '"';
$list_value["impose_money"] = '"' . iconv('utf-8', 'gbk', $v["impose_money"]) . '"';
$list_value["status"] = '"' . iconv('utf-8', 'gbk', $v["status"]) . '"';
$content .= implode(",", $list_value) . "\n";
}
header("Content-Disposition: attachment; filename=order_list.csv");
echo $content;
} else {
if ($page == 1) {
$this->error(L("NO_RESULT"));
}
}
}
/**
* 解冻保证金
* @param int $deal_id 标的号
* @param int $pUnfreezenType 解冻类型 否 1#解冻借款方；2#解冻担保方
* @param float $money 解冻金额;默认为0时，则解冻所有未解冻的金额
* @return string
*/
function GuaranteeUnfreeze()
{
$pTransferType = intval(strim($_REQUEST['pTransferType']));
$deal_id = intval(strim($_REQUEST['deal_id']));
$money = floatval($_REQUEST['money']);
require_once APP_ROOT_PATH . "app/Lib/deal_func.php";
$deal = get_deal($deal_id);
// $GLOBALS['db']->getRow("select * from ".DB_PREFIX."deal where id = ".$deal_id);
if (!empty($deal)) {
if (!empty($deal['ips_bill_no'])) {
$class_name = getCollName();
require_once APP_ROOT_PATH . "system/collocation/" . $class_name . "_collocation.php";
$collocation_class = $class_name . "_collocation";
$collocation_object = new $collocation_class();
$collocation_code = $collocation_object->GuaranteeUnfreeze($deal_id, $pTransferType, $money);
print_r($collocation_code);
} else {
showErr('该标未发布登记:' . $deal['ips_bill_no'], 0);
}
} else {
showErr('标的ID不存在:' . $deal_id, 0);
}
}
public function ips_transfer_view()
{
$GLOBALS['tmpl']->assign("page_title", "债权转让明细");
$page = intval($_REQUEST['p']);
if ($page == 0) {
$page = 1;
}
$limit = ($page - 1) * app_conf("PAGE_SIZE") . "," . app_conf("PAGE_SIZE");
if ($limit) {
$limit = " limit " . $limit;
}
if (isset($_REQUEST['id']) && intval(strim($_REQUEST['id'])) > 0) {
//$condition .= " and t.pid = ".intval(strim($_REQUEST['id']));
$GLOBALS['tmpl']->assign('id', intval(strim($_REQUEST['id'])));
} else {
return;
//$this->error (l("INVALID_OPERATION"),$ajax);
}
$className = getCollName();
//环迅
if (strtolower($className) == "ips") {
$p_sql = "select dlt.* from " . DB_PREFIX . "ips_transfer as t\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal as d on d.id = t.deal_id\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal_load_transfer as dlt on dlt.id = t.ref_data\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = d.user_id\r\n\t\t\tleft join " . DB_PREFIX . "user tu on tu.id = dlt.t_user_id\r\n\t\t\twhere t.pTransferType = 4 and t.id = " . intval($_REQUEST['id']);
$load_info = $GLOBALS['db']->getRow($p_sql);
if (!$load_info) {
$this->error(l("INVALID_OPERATION"), $ajax);
}
$condition = " and ((dlr.user_id = " . $GLOBALS["user_info"]["id"] . " and dlr.t_user_id = 0 ) or dlr.t_user_id =" . $GLOBALS["user_info"]["id"] . ")";
$sql = "select dlr.*,d.name as deal_name,u.user_name,tu.user_name as t_user_name from " . DB_PREFIX . "deal_load_repay as dlr LEFT JOIN " . DB_PREFIX . "user as u on u.id = dlr.user_id left join " . DB_PREFIX . "user as tu on tu.id = dlr.t_user_id left join " . DB_PREFIX . "deal as d on dlr.deal_id = d.id where dlr.load_id =" . intval($load_info['load_id']) . " and dlr.user_id =" . intval($load_info['user_id']) . " and dlr.deal_id = " . $load_info["deal_id"];
$count_sql = "select count(*) from " . DB_PREFIX . "deal_load_repay as dlr LEFT JOIN " . DB_PREFIX . "user as u on u.id = dlr.user_id \r\n\t\t\tleft join " . DB_PREFIX . "user as tu on tu.id = dlr.t_user_id \r\n\t\t\tleft join " . DB_PREFIX . "deal as d on dlr.deal_id = d.id where dlr.load_id =" . intval($load_info['load_id']) . " and dlr.user_id =" . intval($load_info['user_id']) . " and dlr.deal_id = " . $load_info["deal_id"];
$list = $GLOBALS['db']->getAll($sql . $condition . $limit);
//取得满足条件的记录数
$list_count = $GLOBALS['db']->getOne($count_sql . $condition);
} elseif (strtolower($className) == "yeepay") {
$p_sql = "select dlt.* from " . DB_PREFIX . "yeepay_cp_transaction as t\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal as d on d.id = t.tenderOrderNo\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal_load_transfer as dlt on dlt.id = t.transfer_id\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = d.user_id\r\n\t\t\tleft join " . DB_PREFIX . "user tu on tu.id = dlt.t_user_id\r\n\t\t\twhere t.bizType = 'CREDIT_ASSIGNMENT' and t.id = " . intval($_REQUEST['id']);
$load_info = $GLOBALS['db']->getRow($p_sql);
if (!$load_info) {
$this->error(l("INVALID_OPERATION"), $ajax);
}
$condition = " and ((dlr.user_id = " . $GLOBALS["user_info"]["id"] . " and dlr.t_user_id = 0 ) or dlr.t_user_id =" . $GLOBALS["user_info"]["id"] . ")";
$sql = "select dlr.*,d.name as deal_name,u.user_name,tu.user_name as t_user_name \r\n\t\t\tfrom " . DB_PREFIX . "deal_load_repay as dlr \r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = dlr.user_id \r\n\t\t\tleft join " . DB_PREFIX . "user as tu on tu.id = dlr.t_user_id \r\n\t\t\tleft join " . DB_PREFIX . "deal as d on dlr.deal_id = d.id \r\n\t\t\twhere dlr.load_id =" . intval($load_info['load_id']) . " and dlr.user_id =" . intval($load_info['user_id']) . " \r\n\t\t\tand dlr.deal_id = " . $load_info["deal_id"];
//print_r($sql);die;
$count_sql = "select count(*) from " . DB_PREFIX . "deal_load_repay as dlr \r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = dlr.user_id \r\n\t\t\tleft join " . DB_PREFIX . "user as tu on tu.id = dlr.t_user_id \r\n\t\t\tleft join " . DB_PREFIX . "deal as d on dlr.deal_id = d.id \r\n\t\t\twhere dlr.load_id =" . intval($load_info['load_id']) . " and dlr.user_id =" . intval($load_info['user_id']) . " \r\n\t\t\tand dlr.deal_id = " . $load_info["deal_id"];
$list = $GLOBALS['db']->getAll($sql . $condition . $limit);
//取得满足条件的记录数
$list_count = $GLOBALS['db']->getOne($count_sql . $condition);
} elseif (strtolower($className) == "baofoo") {
$p_sql = "select dlt.* from " . DB_PREFIX . "baofoo_acct_trans as t\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal_load_transfer as dlt on dlt.id = t.ref_id\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal as d on d.id = dlt.deal_id\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = d.user_id\r\n\t\t\tleft join " . DB_PREFIX . "user tu on tu.id = dlt.t_user_id\r\n\t\t\twhere t.code = 'CSD000' and t.ref_type = 1 and t.id = " . intval($_REQUEST['id']);
$load_info = $GLOBALS['db']->getRow($p_sql);
if (!$load_info) {
$this->error(l("INVALID_OPERATION"), $ajax);
}
$condition = " and ((dlr.user_id = " . $GLOBALS["user_info"]["id"] . " and dlr.t_user_id = 0 ) or dlr.t_user_id =" . $GLOBALS["user_info"]["id"] . ")";
$sql = "select dlr.*,d.name as deal_name,u.user_name,tu.user_name as t_user_name \r\n\t\t\tfrom " . DB_PREFIX . "deal_load_repay as dlr \r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = dlr.user_id \r\n\t\t\tleft join " . DB_PREFIX . "user as tu on tu.id = dlr.t_user_id \r\n\t\t\tleft join " . DB_PREFIX . "deal as d on dlr.deal_id = d.id \r\n\t\t\twhere dlr.load_id =" . intval($load_info['load_id']) . " and dlr.user_id =" . intval($load_info['user_id']) . " \r\n\t\t\tand dlr.deal_id = " . $load_info["deal_id"];
//print_r($sql);die;
$count_sql = "select count(*) from " . DB_PREFIX . "deal_load_repay as dlr \r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = dlr.user_id \r\n\t\t\tleft join " . DB_PREFIX . "user as tu on tu.id = dlr.t_user_id \r\n\t\t\tleft join " . DB_PREFIX . "deal as d on dlr.deal_id = d.id \r\n\t\t\twhere dlr.load_id =" . intval($load_info['load_id']) . " and dlr.user_id =" . intval($load_info['user_id']) . " \r\n\t\t\tand dlr.deal_id = " . $load_info["deal_id"];
$list = $GLOBALS['db']->getAll($sql . $condition . $limit);
//取得满足条件的记录数
$list_count = $GLOBALS['db']->getOne($count_sql . $condition);
}
foreach ($list as $k => $v) {
$list[$k]["ll_key"] = $v["l_key"] + 1;
}
$page = new Page($list_count, app_conf("PAGE_SIZE"));
//初始化分页对象
$p = $page->show();
$GLOBALS['tmpl']->assign('pages', $p);
$GLOBALS['tmpl']->assign('list', $list);
$GLOBALS['tmpl']->assign("start_time", $start_time);
$GLOBALS['tmpl']->assign("end_time", $end_time);
$GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_ips_ips_transfer_view.html");
$GLOBALS['tmpl']->display("page/uc.html");
}
public function relation_export_csv($page = 1)
{
set_time_limit(0);
$limit = ($page - 1) * intval(app_conf("BATCH_PAGE_SIZE")) . "," . intval(app_conf("BATCH_PAGE_SIZE"));
if ($limit) {
$limit = " limit " . $limit;
}
if (isset($_REQUEST['id']) && intval(strim($_REQUEST['id'])) > 0) {
//$condition .= " and t.pid = ".intval(strim($_REQUEST['id']));
$GLOBALS['tmpl']->assign('id', intval(strim($_REQUEST['id'])));
} else {
return;
//$this->error (l("INVALID_OPERATION"),$ajax);
}
$className = getCollName();
//环迅
if (strtolower($className) == "ips") {
$p_sql = "select dlt.* from " . DB_PREFIX . "ips_transfer as t\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal as d on d.id = t.deal_id\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal_load_transfer as dlt on dlt.id = t.ref_data\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = d.user_id\r\n\t\t\tleft join " . DB_PREFIX . "user tu on tu.id = dlt.t_user_id\r\n\t\t\twhere t.pTransferType = 4 and t.id = " . intval($_REQUEST['id']);
$load_info = $GLOBALS['db']->getRow($p_sql);
if (!$load_info) {
$this->error(l("INVALID_OPERATION"), $ajax);
}
$sql = "select dlr.*,d.name as deal_name,u.user_name,tu.user_name as t_user_name from " . DB_PREFIX . "deal_load_repay as dlr LEFT JOIN " . DB_PREFIX . "user as u on u.id = dlr.user_id left join " . DB_PREFIX . "user as tu on tu.id = dlr.t_user_id left join " . DB_PREFIX . "deal as d on dlr.deal_id = d.id where dlr.load_id =" . intval($load_info['load_id']) . " and dlr.user_id =" . intval($load_info['user_id']) . " and dlr.deal_id = " . $load_info["deal_id"];
$count_sql = "select count(*) from " . DB_PREFIX . "deal_load_repay as dlr LEFT JOIN " . DB_PREFIX . "user as u on u.id = dlr.user_id \r\n\t\t\tleft join " . DB_PREFIX . "user as tu on tu.id = dlr.t_user_id \r\n\t\t\tleft join " . DB_PREFIX . "deal as d on dlr.deal_id = d.id where dlr.load_id =" . intval($load_info['load_id']) . " and dlr.user_id =" . intval($load_info['user_id']) . " and dlr.deal_id = " . $load_info["deal_id"];
$list = $GLOBALS['db']->getAll($sql . $condition . " order by dlr.id desc " . $limit);
//取得满足条件的记录数
$list_count = $GLOBALS['db']->getOne($count_sql . $condition);
} elseif (strtolower($className) == "yeepay") {
$p_sql = "select dlt.* from " . DB_PREFIX . "yeepay_cp_transaction as t\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal as d on d.id = t.tenderOrderNo\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal_load_transfer as dlt on dlt.id = t.transfer_id\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = d.user_id\r\n\t\t\tleft join " . DB_PREFIX . "user tu on tu.id = dlt.t_user_id\r\n\t\t\twhere t.bizType = 'CREDIT_ASSIGNMENT' and t.id = " . intval($_REQUEST['id']);
$load_info = $GLOBALS['db']->getRow($p_sql);
if (!$load_info) {
$this->error(l("INVALID_OPERATION"), $ajax);
}
$sql = "select dlr.*,d.name as deal_name,u.user_name,tu.user_name as t_user_name \r\n\t\t\tfrom " . DB_PREFIX . "deal_load_repay as dlr \r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = dlr.user_id \r\n\t\t\tleft join " . DB_PREFIX . "user as tu on tu.id = dlr.t_user_id \r\n\t\t\tleft join " . DB_PREFIX . "deal as d on dlr.deal_id = d.id \r\n\t\t\twhere dlr.load_id =" . intval($load_info['load_id']) . " and dlr.user_id =" . intval($load_info['user_id']) . " \r\n\t\t\tand dlr.deal_id = " . $load_info["deal_id"];
//print_r($sql);die;
$count_sql = "select count(*) from " . DB_PREFIX . "deal_load_repay as dlr \r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = dlr.user_id \r\n\t\t\tleft join " . DB_PREFIX . "user as tu on tu.id = dlr.t_user_id \r\n\t\t\tleft join " . DB_PREFIX . "deal as d on dlr.deal_id = d.id \r\n\t\t\twhere dlr.load_id =" . intval($load_info['load_id']) . " and dlr.user_id =" . intval($load_info['user_id']) . " \r\n\t\t\tand dlr.deal_id = " . $load_info["deal_id"];
$list = $GLOBALS['db']->getAll($sql . $condition . " order by dlr.id desc " . $limit);
//取得满足条件的记录数
$list_count = $GLOBALS['db']->getOne($count_sql . $condition);
} elseif (strtolower($className) == "baofoo") {
$p_sql = "select dlt.* from " . DB_PREFIX . "baofoo_acct_trans as t\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal_load_transfer as dlt on dlt.id = t.ref_id\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal as d on d.id = dlt.deal_id\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = d.user_id\r\n\t\t\tleft join " . DB_PREFIX . "user tu on tu.id = dlt.t_user_id\r\n\t\t\twhere t.code = 'CSD000' and t.ref_type = 1 and t.id = " . intval($_REQUEST['id']);
$load_info = $GLOBALS['db']->getRow($p_sql);
if (!$load_info) {
$this->error(l("INVALID_OPERATION"), $ajax);
}
$sql = "select dlr.*,d.name as deal_name,u.user_name,tu.user_name as t_user_name \r\n\t\t\tfrom " . DB_PREFIX . "deal_load_repay as dlr \r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = dlr.user_id \r\n\t\t\tleft join " . DB_PREFIX . "user as tu on tu.id = dlr.t_user_id \r\n\t\t\tleft join " . DB_PREFIX . "deal as d on dlr.deal_id = d.id \r\n\t\t\twhere dlr.load_id =" . intval($load_info['load_id']) . " and dlr.user_id =" . intval($load_info['user_id']) . " \r\n\t\t\tand dlr.deal_id = " . $load_info["deal_id"];
//print_r($sql);die;
$count_sql = "select count(*) from " . DB_PREFIX . "deal_load_repay as dlr \r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = dlr.user_id \r\n\t\t\tleft join " . DB_PREFIX . "user as tu on tu.id = dlr.t_user_id \r\n\t\t\tleft join " . DB_PREFIX . "deal as d on dlr.deal_id = d.id \r\n\t\t\twhere dlr.load_id =" . intval($load_info['load_id']) . " and dlr.user_id =" . intval($load_info['user_id']) . " \r\n\t\t\tand dlr.deal_id = " . $load_info["deal_id"];
$list = $GLOBALS['db']->getAll($sql . $condition . " order by dlr.id desc " . $limit);
//取得满足条件的记录数
$list_count = $GLOBALS['db']->getOne($count_sql . $condition);
}
foreach ($list as $k => $v) {
$list[$k]["ll_key"] = $list[$k]["l_key"] + 1;
$list[$k]["uu_key"] = $list[$k]["u_key"] + 1;
}
if ($list) {
register_shutdown_function(array(&$this, 'relation_export_csv'), $page + 1);
$list_value = array('id' => '""', 'deal_name' => '""', 'self_money' => '""', 'repay_money' => '""', 'manage_money' => '""', 'manage_interest_money' => '""', 'impose_money' => '""', 'repay_time' => '""', 'true_repay_time' => '""', 'status' => '""', 'is_site_repay' => '""', 'l_key' => '""', 'u_key' => '""', 'has_repay' => '""', 'repay_manage_money' => '""', 'repay_manage_impose_money' => '""', 'user_name' => '""', 't_user_name' => '""');
if ($page == 1) {
$content = iconv("utf-8", "gbk", "编号,借款名称,本金,还款金额,管理费,利息管理费,罚息,还款日,实际还款时间,还款状态,付款方式,还款期号,还款顺序,订单状态,从借款者均摊下来的管理费,接入者均摊下来的逾期管理费,投标人,承接人");
$content = $content . "\n";
}
foreach ($list as $k => $v) {
$list_value["id"] = '"' . iconv('utf-8', 'gbk', $v["id"]) . '"';
$list_value["deal_name"] = '"' . iconv('utf-8', 'gbk', M("deal")->where(" id=" . strim($v['deal_id']))->getField("name")) . '"';
$list_value["self_money"] = '"' . iconv('utf-8', 'gbk', $v["self_money"]) . '"';
$list_value["repay_money"] = '"' . iconv('utf-8', 'gbk', $v["repay_money"]) . '"';
$list_value["manage_money"] = '"' . iconv('utf-8', 'gbk', $v["manage_money"]) . '"';
$list_value["impose_money"] = '"' . iconv('utf-8', 'gbk', $v["impose_money"]) . '"';
$list_value["repay_time"] = '"' . iconv('utf-8', 'gbk', $v["repay_time"]) . '"';
$list_value["true_repay_time"] = '"' . iconv('utf-8', 'gbk', $v["true_repay_time"]) . '"';
if ($v['status'] != '') {
$list_value["status"] = '"' . iconv('utf-8', 'gbk', l("REPAY_STATUS_" . strim($v['status']))) . '"';
} else {
$list_value["status"] = "";
}
if ($v['is_site_repay'] != '') {
$list_value["is_site_repay"] = '"' . iconv('utf-8', 'gbk', l("IS_SITE_REPAY_" . strim($v['is_site_repay']))) . '"';
} else {
$list_value["is_site_repay"] = "";
}
$list_value["l_key"] = '"' . iconv('utf-8', 'gbk', $v["l_key"]) . '"';
$list_value["u_key"] = '"' . iconv('utf-8', 'gbk', $v["u_key"]) . '"';
if ($v['has_repay'] != '') {
$list_value["has_repay"] = '"' . iconv('utf-8', 'gbk', l("HAS_REPAY_" . strim($v['has_repay']))) . '"';
} else {
$list_value["has_repay"] = "";
}
$list_value["repay_manage_money"] = '"' . iconv('utf-8', 'gbk', $v["repay_manage_money"]) . '"';
$list_value["repay_manage_impose_money"] = '"' . iconv('utf-8', 'gbk', $v["repay_manage_impose_money"]) . '"';
$list_value["user_name"] = '"' . iconv('utf-8', 'gbk', $v["user_name"]) . '"';
$list_value["t_user_name"] = '"' . iconv('utf-8', 'gbk', $v["t_user_name"]) . '"';
$list_value["msg"] = '"' . iconv('utf-8', 'gbk', $v["msg"]) . '"';
$content .= implode(",", $list_value) . "\n";
}
header("Content-Disposition: attachment; filename=order_list.csv");
echo $content;
} else {
if ($page == 1) {
$this->error(L("NO_RESULT"));
}
}
}
