public function detail()
{
$pre = C('DB_PREFIX');
$id = intval($_GET['id']);
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
//合同ID
if ($this->uid) {
$res = M("members")->field("usrid")->where("id=" . $this->uid)->find();
if (!empty($res["usrid"])) {
$hetong = 1;
} else {
$hetong = 0;
}
$this->assign("hetong", $hetong);
$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 = 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);
// echo "<pre/>";print_r($borrowinfo);
$this->assign("vo", $borrowinfo);
//底部那些图片
$bottominfo = unserialize($borrowinfo['updata']);
foreach ($bottominfo as $v) {
$arr[] = $v['info'];
}
$this->bottom = $arr;
$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'];
$memberinfo['user_name2'] = get_secure_str($memberinfo['user_name']);
$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);
//借款者信息补充20150727lj
$charge = M("borrow_detail")->where("bid=" . $id)->find();
$this->charge = $charge;
//左边列表
$left = $this->invest_ad();
//近期还款的投标
//$time1 = microtime(true)*1000;
$history = getDurationCount($borrowinfo['borrow_uid']);
$this->assign("history", $history);
//investinfo
$fieldx = "bi.investor_capitalinfotal,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));
//echo "<pre>";print_r(getMinfo($borrowinfo['borrow_uid'],true));echo "</pre>";exit;
//$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 downfile()
{
$per = C('DB_PREFIX');
$borrow_config = (require C("APP_ROOT") . "Conf/borrow_config.php");
//$invest_id=intval($_GET['id']);
$borrow_id = intval($_GET['id']);
$binfo = M('borrow_info bi')->field('bi.id,bi.repayment_type,bi.borrow_duration,bi.borrow_uid,bi.borrow_type,bi.borrow_use,bi.borrow_money,bi.full_time,bi.add_time,bi.borrow_interest_rate,bi.deadline,bi.second_verify_time,bi.collect_time,mi.real_name')->join("{$per}member_info mi ON bi.danbao=mi.uid")->find($borrow_id);
//echo "<pre>";print_r($binfo);echo "</pre>";exit;
$mBorrow = M("members m")->join("{$per}member_info mi ON mi.uid=m.id")->field('mi.real_name,m.user_name,mi.idcard')->where("m.id={$binfo['borrow_uid']}")->find();
//echo "<pre>";print_r($mBorrow);echo "</pre>";exit;
//if(!is_array($iinfo)||!is_array($binfo)||!is_array($mBorrow)||!is_array($mInvest)) exit;
$detail = M('investor_detail d')->field('d.borrow_id,d.investor_uid,d.borrow_uid,d.capital,sum(d.capital+d.interest-d.interest_fee) benxi,d.total')->where("d.borrow_id={$iinfo['borrow_id']} and d.invest_id ={$iinfo['id']}")->group('d.investor_uid')->find();
//$detailinfo = M('investor_detail d')->join("{$per}borrow_investor bi ON bi.id=d.invest_id")->join("{$per}members m ON m.id=d.investor_uid")->field('d.borrow_id,d.investor_uid,d.borrow_uid,d.capital,sum(d.capital+d.interest-d.interest_fee) benxi,d.total,m.user_name,bi.investor_capital,bi.add_time')->where("d.borrow_id={$iinfo['borrow_id']} and d.invest_id ={$iinfo['id']}")->group('d.investor_uid')->find();
$detailinfo = M('investor_detail d')->field('d.borrow_id,d.investor_uid,d.borrow_uid,(d.capital+d.interest-d.interest_fee) benxi,d.capital,d.interest,d.interest_fee,d.sort_order,d.deadline')->where("d.borrow_id={$iinfo['borrow_id']} and d.invest_id ={$iinfo['id']}")->select();
$time = M('borrow_investor')->field('id,add_time')->where("borrow_id={$iinfo['borrow_id']} order by add_time asc")->limit(1)->find();
if ($binfo['repayment_type'] == 1) {
$deadline_last = strtotime("+{$binfo['borrow_duration']} day", $time['add_time']);
} else {
$deadline_last = strtotime("+{$binfo['borrow_duration']} month", $time['add_time']);
}
$this->assign('deadline_last', $deadline_last);
$this->assign('detailinfo', $detailinfo);
$this->assign('detail', $detail);
$type1 = $this->gloconf['BORROW_USE'];
$binfo['borrow_use'] = $type1[$binfo['borrow_use']];
$ht = M('hetong')->field('hetong_img,name,dizhi,tel')->find();
$this->assign("ht", $ht);
$type = $borrow_config['REPAYMENT_TYPE'];
//echo $binfo['repayment_type'];
$binfo['repayment_name'] = $type[$binfo['repayment_type']];
$iinfo['repay'] = getFloatValue(($iinfo['investor_capital'] + $iinfo['investor_interest']) / $binfo['borrow_duration'], 2);
$this->assign("bid", "bytp2pD");
//print_r($type);
$this->assign('iinfo', $iinfo);
//---------------------add by whh--------------------
if (isset($binfo['second_verify_time'])) {
if ($binfo['second_verify_time'] == 0) {
$binfo['second_verify_time'] = $binfo['first_verify_time'];
}
$binfo['second_verify_time2'] = date('Y年m月d日', $binfo['second_verify_time']);
$binfo['second_verify_time4'] = date('d', $binfo['second_verify_time']);
if ($binfo['repayment_type'] == 1) {
//日标
$binfo['second_verify_time3'] = date('Y年m月d日', $binfo['second_verify_time'] + $binfo['borrow_duration'] * 86400);
} else {
//月
$month = $binfo['borrow_duration'];
$binfo['second_verify_time3'] = date('Y年m月d日', strtotime(" +{$month} month", $binfo['second_verify_time']));
}
}
switch ($binfo['repayment_type']) {
case "2":
//1按月分期还款
$binfo['repayment_type2'] = 1;
//等额本息
break;
case "4":
//2每月还息到期还本
$binfo['repayment_type2'] = 2;
//按月结息
break;
default:
case "5":
//3一次性还款
$binfo['repayment_type2'] = 3;
//到期本息两清
break;
default:
$binfo['repayment_type2'] = 4;
break;
}
//--------------------------------------------------
$this->assign('binfo', $binfo);
$mBorrow['user_name2'] = get_secure_str($mBorrow['user_name']);
$this->assign('mBorrow', $mBorrow);
$this->assign('mInvest', $mInvest);
$this->assign('borrow_id', $borrow_id);
$this->assign('borrow_user', $_GET['borrow_user']);
// 新增投资人信息
$invests = $this->getInvestRecord($borrow_id);
if (is_array($invests)) {
foreach ($invests as $key => $val) {
//存在参数borrow_user 那么只显示自己相关的
if (isset($_GET['uid']) && !empty($_GET['uid']) && $_GET['uid'] != $val['user_id']) {
unset($invests[$key]);
continue;
}
$invests[$key]['user_name2'] = get_secure_str($val['user_name']);
//增加身份证以及姓名
$addinfo = M('member_info')->field('idcard,real_name')->where("uid={$val[user_id]}")->select();
$invests[$key]['idcard'] = isset($addinfo[0]['idcard']) ? $addinfo[0]['idcard'] : '';
$invests[$key]['real_name'] = isset($addinfo[0]['real_name']) ? $addinfo[0]['real_name'] : '';
unset($addinfo);
}
}
$this->assign('invests', $invests);
// 新增借款详情
$bdetail = M("borrow_info")->field('*')->find($borrow_id);
$this->assign('bdetail', $bdetail);
// 格式化日期
$bpaydate = array('start' => date('Y年m年d日', $binfo['collect_time']), 'end' => date('Y年m年d日', $binfo['deadline']), 'full' => date('Y年m年d日', $binfo['full_time'] ? $binfo['full_time'] : $bdetail['first_verify_time']), 'month' => date('d日', $binfo['deadline']));
$this->assign('bpaydate', $bpaydate);
if (isset($_GET['debug'])) {
echo '<pre>';
echo '借款人信息：';
echo '<pre>';
print_r($binfo);
echo '<pre>';
echo '投资人信息：';
echo '<pre>';
print_r($this->getInvestRecord($borrow_id));
echo '<pre>';
echo '其他信息：';
echo '<pre>';
print_r($bdetail);
}
$detail_list = M('investor_detail')->field(true)->where("invest_id={$invest_id}")->select();
$this->assign("detail_list", $detail_list);
//echo "<pre>";print_r($binfo);echo "</pre>";exit;
$this->display("index");
exit;
Vendor('Mpdf.mpdf');
$mpdf = new mPDF('UTF-8', 'A4', '', '', 15, 15, 4, 15);
$mpdf->useAdobeCJK = true;
$mpdf->SetAutoFont(AUTOFONT_ALL);
$mpdf->SetDisplayMode('fullpage');
$mpdf->SetAutoFont();
$mpdf->SetHTMLFooter(' >>{PAGENO}<<');
$mpdf->WriteHTML($this->fetch('index'));
$mpdf->Output('zgtrbao.pdf', 'I');
exit;
$this->display("index");
//$html = $this->fetch('index');
//$this->mypdf->writeHTML($html, true, false, true, false, '');
//$this->mypdf->MultiCell(0, 5, "ssssssssssssssssssssssssssssssss", 0, 'J', 0, 2, '', '', true, 0, false);
//路径,x坐标,y坐标,图片宽度,图片高度（''表示自适应）,网址,
//$mask = $this->mypdf->Image($this->pdfPath.'images/alpha.png', 130, 0, 100, '', '', '', '', false, 100, '', true);
//$this->mypdf->Image($this->pdfPath.'images/image_with_alpha.png', 130, 0, 60, 60, '', '', '', false, 10, '', true, $mask);//出图的,放在后面图就在上层，放在前面图就在下层
//$this->mypdf->Image($this->pdfPath.'images/236.png', 130, 200, 50, 50, '', '', '', false, 10, '', true,$html);//出图的,放在后面图就在上层，放在前面图就在下层
// ---------------------------------------------------------
//Close and output PDF document
//$this->mypdf->Output('jiedaihetong.pdf', 'I');
}
