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>
Example #2
0
 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;
 }