public function tdetail()
{
if ($_GET['type'] == 'commentlist') {
//评论
$cmap['tid'] = intval($_GET['id']);
$clist = getCommentList($cmap, 5);
$this->assign("commentlist", $clist['list']);
$this->assign("commentpagebar", $clist['page']);
$this->assign("commentcount", $clist['count']);
$data['html'] = $this->fetch('commentlist');
exit(json_encode($data));
}
$pre = C('DB_PREFIX');
$id = intval($_GET['id']);
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
//合同ID
if ($this->uid) {
$invs = M('borrow_investor')->field('id')->where("borrow_id={$id} AND (investor_uid={$this->uid})")->find();
if ($invs['id'] > 0) {
$invsx = $invs['id'];
} elseif (!is_array($invs)) {
$invsx = 'no';
}
} else {
$invsx = 'login';
}
$this->assign("invid", $invsx);
//合同ID
//borrowinfo
//$borrowinfo = M("borrow_info")->field(true)->find($id);
$borrowinfo = M("borrow_info bi")->field('bi.*,ac.title,ac.id as aid')->join('lzh_article ac on ac.id= bi.danbao')->where('bi.id=' . $id)->find();
if (!is_array($borrowinfo) || $borrowinfo['borrow_status'] == 0 && $this->uid != $borrowinfo['borrow_uid']) {
$this->error("数据有误");
}
$borrowinfo['biao'] = $borrowinfo['borrow_times'];
$borrowinfo['need'] = $borrowinfo['borrow_money'] - $borrowinfo['has_borrow'];
$borrowinfo['lefttime'] = $borrowinfo['collect_time'] - time();
$borrowinfo['progress'] = getFloatValue($borrowinfo['has_borrow'] / $borrowinfo['borrow_money'] * 100, 2);
$this->assign("vo", $borrowinfo);
$memberinfo = M("members m")->field("m.id,m.customer_name,m.customer_id,m.user_name,m.reg_time,m.credits,fi.*,mi.*,mm.*")->join("{$pre}member_financial_info fi ON fi.uid = m.id")->join("{$pre}member_info mi ON mi.uid = m.id")->join("{$pre}member_money mm ON mm.uid = m.id")->where("m.id={$borrowinfo['borrow_uid']}")->find();
$areaList = getArea();
$memberinfo['location'] = $areaList[$memberinfo['province']] . $areaList[$memberinfo['city']];
$memberinfo['location_now'] = $areaList[$memberinfo['province_now']] . $areaList[$memberinfo['city_now']];
$memberinfo['zcze'] = $memberinfo['account_money'] + $memberinfo['back_money'] + $memberinfo['money_collect'] + $memberinfo['money_freeze'];
$this->assign("minfo", $memberinfo);
//data_list
$data_list = M("member_data_info")->field('type,add_time,count(status) as num,sum(deal_credits) as credits')->where("uid={$borrowinfo['borrow_uid']} AND status=1")->group('type')->select();
$this->assign("data_list", $data_list);
//data_list
// 投资记录
$this->investRecord($id);
$this->assign('borrow_id', $id);
//近期还款的投标
//$time1 = microtime(true)*1000;
$history = getDurationCount($borrowinfo['borrow_uid']);
$this->assign("history", $history);
//$time2 = microtime(true)*1000;
//echo $time2-$time1;
//investinfo
$fieldx = "bi.investor_capital,bi.add_time,m.user_name,bi.is_auto";
$investinfo = M("borrow_investor bi")->field($fieldx)->join("{$pre}members m ON bi.investor_uid = m.id")->limit(10)->where("bi.borrow_id={$id}")->order("bi.id DESC")->select();
$this->assign("investinfo", $investinfo);
//investinfo
//帐户资金情况
$this->assign("investInfo", getMinfo($this->uid, true));
$this->assign("mainfo", getMinfo($borrowinfo['borrow_uid'], true));
$this->assign("capitalinfo", getMemberBorrowScan($borrowinfo['borrow_uid']));
//帐户资金情况
//展示资料
$show_list = M("member_borrow_show")->where("uid={$borrowinfo['borrow_uid']}")->order('sort DESC')->select();
$this->assign("show_list", $show_list);
//展示资料
//上传资料类型
$upload_type = FilterUploadType(FS("Webconfig/integration"));
$this->assign("upload_type", $upload_type);
// 上传资料所有类型
//评论
$cmap['tid'] = $id;
$clist = getCommentList($cmap, 5);
$this->assign("Bconfig", $Bconfig);
$this->assign("gloconf", $this->gloconf);
$this->assign("commentlist", $clist['list']);
$this->assign("commentpagebar", $clist['page']);
$this->assign("commentcount", $clist['count']);
$this->display();
}
public function detail()
{
$vminfo = M('members')->field("user_leve,time_limit")->find($this->uid);
if (!($vminfo['user_leve'] > 0 && $vminfo['time_limit'] > time())) {
$this->error("请先通过VIP审核再投资", __APP__ . "/member/vip/invest");
}
if ($_GET['type'] == 'commentlist') {
//评论
$cmap['tid'] = intval($_GET['id']);
$clist = getCommentList($cmap, 5);
$this->assign("commentlist", $clist['list']);
$this->assign("commentpagebar", $clist['page']);
$this->assign("commentcount", $clist['count']);
$data['html'] = $this->fetch('commentlist');
exit(json_encode($data));
}
$pre = C('DB_PREFIX');
$id = intval($_GET['id']);
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
//合同ID
if ($this->uid) {
$invs = M('borrow_investor')->field('id')->where("borrow_id={$id} AND (investor_uid={$this->uid} OR borrow_uid={$this->uid})")->find();
if ($invs['id'] > 0) {
$invsx = $invs['id'];
} elseif (!is_array($invs)) {
$invsx = 'no';
}
} else {
$invsx = 'login';
}
$this->assign("invid", $invsx);
//合同ID
//borrowinfo
$borrowinfo = M("borrow_info")->field(true)->find($id);
if (!is_array($borrowinfo) || $borrowinfo['borrow_status'] == 0 && $this->uid != $borrowinfo['borrow_uid']) {
$this->error("数据有误");
}
$borrowinfo['biao'] = $borrowinfo['borrow_times'];
$borrowinfo['need'] = $borrowinfo['borrow_money'] - $borrowinfo['has_borrow'];
$borrowinfo['lefttime'] = $borrowinfo['collect_time'] - time();
$borrowinfo['progress'] = getFloatValue($borrowinfo['has_borrow'] / $borrowinfo['borrow_money'] * 100, 2);
$borrowinfo['vouch_progress'] = getFloatValue($borrowinfo['has_vouch'] / $borrowinfo['borrow_money'] * 100, 2);
$borrowinfo['vouch_need'] = $borrowinfo['borrow_money'] - $borrowinfo['has_vouch'];
$this->assign("vo", $borrowinfo);
//borrowinfo
//此标借款利息还款相关情况
if ($borrowinfo['repayment_type'] == 2) {
$money = 100;
$rate = $borrowinfo['borrow_interest_rate'];
$month = $borrowinfo['borrow_duration'];
$monthData['money'] = $money;
$monthData['year_apr'] = $rate;
$monthData['duration'] = $month;
$monthData['type'] = "all";
$repay_detail = EqualMonth($monthData);
$this->assign('repay_detail', $repay_detail);
} elseif ($borrowinfo['repayment_type'] == 3) {
$money = 100;
$rate = $borrowinfo['borrow_interest_rate'];
$month = $borrowinfo['borrow_duration'];
$monthData['account'] = $money;
$monthData['year_apr'] = $rate;
$monthData['month_times'] = $month;
$monthData['type'] = "all";
$repay_detail = EqualSeason($monthData);
$this->assign('repay_detail', $repay_detail);
} elseif ($borrowinfo['repayment_type'] == 4) {
$money = 100;
$rate = $borrowinfo['borrow_interest_rate'];
$month = $borrowinfo['borrow_duration'];
$parm['month_times'] = $month;
$parm['account'] = $money;
$parm['year_apr'] = $rate;
$parm['type'] = "all";
$repay_detail = EqualEndMonth($parm);
$repay_detail['repayment_money'] = $repay_detail['repayment_account'];
$this->assign("repay_detail", $repay_detail);
} elseif ($borrowinfo['repayment_type'] == 1) {
$repay_detail['repayment_money'] = getFloatValue(100 + 100 * $borrowinfo['borrow_interest_rate'] * $borrowinfo['borrow_duration'] / 100, 2);
$this->assign('repay_detail', $repay_detail);
}
//此标借款利息还款相关情况
//memberinfo
$memberinfo = M("members m")->field("m.id,m.customer_name,m.customer_id,m.user_name,m.reg_time,m.credits,fi.*,mi.*")->join("{$pre}member_financial_info fi ON fi.uid = m.id")->join("{$pre}member_info mi ON mi.uid = m.id")->where("m.id={$borrowinfo['borrow_uid']}")->find();
$areaList = getArea();
$memberinfo['location'] = $areaList[$memberinfo['province']] . $areaList[$memberinfo['city']];
$memberinfo['location_now'] = $areaList[$memberinfo['province_now']] . $areaList[$memberinfo['city_now']];
$this->assign("minfo", $memberinfo);
//memberinfo
//vouch_list
$vouch_list = M("borrow_vouch")->field(true)->where("borrow_id={$id}")->select();
$this->assign("vouch_list", $vouch_list);
$this->assign("Vstatus", array(0 => '担保中', 1 => "担保完成"));
//vouch_list
//data_list
$data_list = M("member_data_info")->field('type,add_time,count(status) as num,sum(deal_credits) as credits')->where("uid={$borrowinfo['borrow_uid']} AND status=1")->group('type')->select();
$this->assign("data_list", $data_list);
//data_list
//paying_list
$paying_list = getMemberBorrow($borrowinfo['borrow_uid']);
$this->assign("paying_list", $paying_list);
//paying_list
//近期还款的投标
//$time1 = microtime(true)*1000;
$history = getDurationCount($borrowinfo['borrow_uid']);
$this->assign("history", $history);
//$time2 = microtime(true)*1000;
//echo $time2-$time1;
//investinfo
$fieldx = "bi.investor_capital,bi.add_time,m.user_name,bi.is_auto";
$investinfo = M("borrow_investor bi")->field($fieldx)->join("{$pre}members m ON bi.investor_uid = m.id")->where("bi.borrow_id={$id}")->order("bi.id DESC")->select();
$this->assign("investinfo", $investinfo);
//investinfo
//帐户资金情况
$this->assign("mainfo", getMinfo($borrowinfo['borrow_uid'], true));
$this->assign("capitalinfo", getMemberBorrowScan($borrowinfo['borrow_uid']));
//帐户资金情况
//评论
$cmap['tid'] = $id;
$cmap['is_audit'] = 1;
//审核通过的评论
$clist = getCommentList($cmap, 5);
$this->assign("Bconfig", $Bconfig);
$this->assign("commentlist", $clist['list']);
$this->assign("commentpagebar", $clist['page']);
$this->assign("commentcount", $clist['count']);
$this->display();
}
