echo getInvestUrl($vb["id"]); ?> " target="_blank" title="<?php echo $vb["borrow_name"]; ?> "><?php echo cnsubstr($vb["borrow_name"], 17); ?> </a> </span> <span class="ui-list-field fn-left num text-right w90 pr30">预计<em class="value"><?php echo $vb["borrow_interest_rate"]; ?> </em>%</span> <span class="ui-list-field fn-left num text-right w130 pr30"><em class="value"><?php echo getMoneyFormt($vb["borrow_money"]); ?> </em>元</span> <span class="ui-list-field fn-left num text-right w70 pr30"><em class="value"><?php echo $vb["borrow_duration"]; ?> </em><?php if ($vb["repayment_type"] == 1) { ?> 天<?php } else { ?> 个月<?php } ?> </span>
public function getBorrowerInfo($bid) { $db = core::db()->getConnect('CAILAI', true); $filed = "bi.borrow_uid,mi.sex,mi.age,mi.education,mi.marry,fi.fin_monthin,m.user_email,m.customer_name,fi.fin_car,m.integral,mi.zy,mm.credit_limit,mi.province,mi.city,mm.account_money,mm.back_money,mm.money_collect,mm.money_freeze "; $sql = sprintf("SELECT {$filed} FROM`lzh_borrow_info` bi LEFT JOIN lzh_members m ON m.id = bi.borrow_uid LEFT JOIN lzh_member_financial_info fi ON bi.borrow_uid=fi.uid LEFT JOIN `lzh_member_info` mi ON mi.uid=bi.borrow_uid LEFT JOIN `lzh_member_money` mm ON mm.uid=bi.borrow_uid WHERE bi.id=%s", $bid); $zw = $db->query($sql, "array "); $borrow_uid = $zw['borrow_uid']; unset($zw['borrow_uid']); $zw['fin_monthin'] = getMoneyFormt($zw['fin_monthin']); $zw['integral'] = (int) $zw['integral']; $zw['credit_limit'] = (double) $zw['credit_limit']; if ($zw['fin_car'] == NULL) { $zw['fin_car'] = '未填写'; } //借款次数相关 $sql2 = sprintf("SELECT `borrow_status`, COUNT(id) AS num,SUM(borrow_money) AS money,SUM(repayment_money) AS repayment_money FROM `lzh_borrow_info` WHERE borrow_uid = %s GROUP BY borrow_status ", $borrow_uid); $zw2 = $db->query($sql2); while ($row = $db->fetchArray($zw2)) { $borrowCount[$row['borrow_status']] = $row; } //借出情况相关 $field3 = "status,count(id) as num,sum(investor_capital) as investor_capital,sum(reward_money) as reward_money,sum(investor_interest) as investor_interest,sum(receive_capital) as receive_capital,sum(receive_interest) as receive_interest,sum(invest_fee) as invest_fee"; $sql3 = sprintf("SELECT {$field3} FROM `lzh_borrow_investor` WHERE investor_uid = %s GROUP BY STATUS ", $borrow_uid); $zw3 = $db->query($sql3); $_reward_money = 0; while ($v = $db->fetchArray($zw3)) { $investStatus[$v['status']] = $v; $_reward_money += floatval($v['reward_money']); } $rowtj['jkze'] = getFloatValue(floatval($borrowCount[6]['money'] + $borrowCount[7]['money'] + $borrowCount[8]['money'] + $borrowCount[9]['money']), 2); //借款总额 $rowtj['jcze'] = getFloatValue(floatval($investStatus[4]['investor_capital']), 2); //借出总额 $rowtj['ysze'] = getFloatValue(floatval($investStatus[4]['receive_capital']), 2); //应收总额 $rowtj['yhze'] = getFloatValue(floatval($borrowCount[6]['repayment_money'] + $borrowCount[7]['repayment_money'] + $borrowCount[8]['repayment_money'] + $borrowCount[9]['repayment_money']), 2); //应还总额 $data2['yhze'] = getMoneyFormt(getFloatValue(floatval($borrowCount[6]['repayment_money'] + $borrowCount[7]['repayment_money'] + $borrowCount[8]['repayment_money'] + $borrowCount[9]['repayment_money']), 2)); //应还总额 $data2['dhze'] = getMoneyFormt(getFloatValue($rowtj['jkze'] - $rowtj['yhze'], 2)); //待还总额 $data2['jcze'] = getMoneyFormt(getFloatValue(floatval($investStatus[4]['investor_capital']), 2)); //借出总额 $data2['ysze'] = getMoneyFormt(getFloatValue(floatval($investStatus[4]['receive_capital']), 2)); //应收总额 $data2['dsze'] = getMoneyFormt(getFloatValue($rowtj['jcze'] - $rowtj['ysze'], 2)); //待收总额 $data2['fz'] = getMoneyFormt(getFloatValue($rowtj['jcze'] - $rowtj['jkze'], 2)); $data2['jkcgcs'] = (int) ($borrowCount[6]['num'] + $borrowCount[7]['num'] + $borrowCount[8]['num'] + $borrowCount[9]['num']); //借款成功次数 $data2['zcze'] = getMoneyFormt(getFloatValue(floatval($zw['account_money'] + $zw['back_money'] + $zw['money_collect'] + $zw['money_freeze']), 2)); //资产总额 //还款情况相关 $field4 = "status,sort_order,borrow_id,sum(capital) as capital,sum(interest) as interest"; $sql4 = sprintf("SELECT {$field4} FROM `lzh_investor_detail` WHERE borrow_uid = %s GROUP BY sort_order, borrow_id ", $borrow_uid); $zw4 = $db->query($sql4); while ($v = $db->fetchArray($zw4)) { // $repaymentStatus[$v['status']]['capital']+=$v['capital'];//当前状态下的数金额 // $repaymentStatus[$v['status']]['interest']+=$v['interest'];//当前状态下的数金额 $repaymentStatus[$v['status']]['num']++; //当前状态下的总笔数 } $data2['repayment1'] = (int) $repaymentStatus[1]['num']; //正常还款次数: $data2['repayment3'] = (int) $repaymentStatus[3]['num']; //迟还次数: $data2['repayment2'] = (int) $repaymentStatus[2]['num']; //提前还款次数:: $data2['repayment6'] = (int) $repaymentStatus[6]['num']; //待还款笔数: $data2['repayment4'] = (int) $repaymentStatus[4]['num']; //网站代还次数::: $data2['repayment5'] = (int) $repaymentStatus[5]['num']; //逾期还款笔数:: $areaList = getArea(); $data2['location'] = $areaList[$zw['province']] . $areaList[$zw['city']]; unset($zw['province'], $zw['city']); $zz = array_merge($zw, $data2); return $zz; }
public function borrowerinfo() { $jsoncode = file_get_contents("php://input"); $arr = array(); $arr = json_decode($jsoncode, true); if (!is_array($arr) || empty($arr) || empty($arr['id'])) { ajaxmsg("查询错误", 0); } $pre = C('DB_PREFIX'); $id = intval($arr['id']); $Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php"); $borrow_id = $arr['id']; $borrowinfo = M("borrow_info bi")->field('bi.borrow_uid')->where('bi.id=' . $borrow_id)->find(); //$member['m.id']=$borrowinfo['borrow_uid']; //var_dump($member['id']);die; $memberinfo = M("members m")->field("m.id,m.customer_name,m.user_name,m.credits,fi.fin_monthin,fi.fin_car,mi.*,mm.credit_limit,mm.account_money,mm.back_money,mm.money_collect,mm.money_freeze")->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(); if (!$memberinfo) { $memberinfo['credits'] = 0; } $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']; //var_dump($memberinfo['zcze']);die; $list['sex'] = $memberinfo['sex']; $list['age'] = getAgeName($memberinfo['age']); $list['education'] = $memberinfo['education']; $list['marry'] = $memberinfo['marry']; $list['fin_monthin'] = getMoneyFormt($memberinfo['fin_monthin']); $list['user_email'] = $memberinfo['user_email']; $list['customer_name'] = $memberinfo['customer_name']; $list['fin_car'] = $memberinfo['fin_car']; $list['integral'] = $memberinfo['integral']; $list['credit_limit'] = $memberinfo['credit_limit']; $list['zy'] = $memberinfo['zy']; $list['location'] = $memberinfo['location']; $list['zcze'] = getMoneyFormt($memberinfo['zcze']); $capitalinfo = getMemberBorrowScan($borrowinfo['borrow_uid']); //var_dump($capitalinfo['tj']);die; //$list['zcze']=getMoneyFormt($capitalinfo['tj']['dhze']); $list['dhze'] = getMoneyFormt($capitalinfo['tj']['dhze']); $list['yhze'] = getMoneyFormt($capitalinfo['tj']['yhze']); $list['jcze'] = getMoneyFormt($capitalinfo['tj']['jcze']); $list['dsze'] = getMoneyFormt($capitalinfo['tj']['dsze']); //$list['zcze']=getMoneyFormt($capitalinfo['tj']['dhze']); $list['ysze'] = getMoneyFormt($capitalinfo['tj']['ysze']); //$list['zcze']=getMoneyFormt($capitalinfo['tj']['dhze']); if ($capitalinfo['tj']['fz'] < 0) { $list['fz'] = getMoneyFormt($capitalinfo['tj']['fz']); } $list['fz'] = getMoneyFormt($capitalinfo['tj']['fz']); $list['jkcgcs'] = $capitalinfo['tj']['jkcgcs']; $list['ontime_num'] = $capitalinfo['repayment']['1']['num']; $list['late_num'] = $capitalinfo['repayment']['3']['num']; $list['ahead_num'] = $capitalinfo['repayment']['2']['num']; $list['replace_num'] = $capitalinfo['repayment']['4']['num']; $list['overdue_num'] = $capitalinfo['repayment']['5']['num']; ajaxmsg($list); // var_dump($capitalinfo);die; // var_dump($list);die; }