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'); }