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