public function index()
{
//正在进行的贷款
$parm = array();
$searchMap = array();
$searchMap['b.borrow_status'] = array("in", '2,4,6,7');
$searchMap['b.borrow_type'] = array("neq", '9');
$parm['map'] = $searchMap;
$parm['limit'] = 3;
$parm['orderby'] = "b.borrow_status ASC,b.id DESC";
$listBorrow = getBorrowList($parm);
$this->assign("listBorrow", $listBorrow);
//企业直投列表开始
$parm = array();
$searchMap = array();
$searchMap['bi.borrow_status'] = array("in", '2,4,6,7');
$parm['map'] = $searchMap;
$parm['limit'] = 3;
$listTBorrow = getTBorrowList($parm);
$this->assign("listTBorrow", $listTBorrow);
// 债权转让
$pre = C('DB_PREFIX');
$condition = 'd.status in(2,4) AND b.borrow_status in(2,4,6,7)';
$field = 'd.transfer_price, d.status, d.money, d.total_period, d.period, d.valid, d.id as debt_id, i.id as invest_id,';
$field .= 'i.investor_uid, i.deadline, b.id, b.borrow_name, b.borrow_interest_rate,b.borrow_status,';
$field .= 'b.borrow_duration,m.credits, m.user_name';
$list = M("invest_detb d")->join("{$pre}borrow_investor i ON d.invest_id=i.id")->join("{$pre}borrow_info b ON i.borrow_id = b.id")->join("{$pre}members m ON i.investor_uid=m.id")->field($field)->where($condition)->limit('0,3')->order("d.status asc")->select();
//exit(M()->getlastsql());
$this->assign('list', $list);
$this->display();
}
/**
+----------------------------------------------------------
* 默认操作
+----------------------------------------------------------
*/
public function index()
{
$map['borrow_status'] = 6;
if ($_GET['start_time'] && $_GET['end_time']) {
$_GET['start_time'] = strtotime($_GET['start_time'] . " 00:00:00");
$_GET['end_time'] = strtotime($_GET['end_time'] . " 23:59:59");
if ($_GET['start_time'] < $_GET['end_time']) {
$map['add_time'] = array("between", "{$_GET['start_time']},{$_GET['end_time']}");
$search['start_time'] = $_GET['start_time'];
$search['end_time'] = $_GET['end_time'];
}
}
$map['status'] = 7;
$list = getBorrowList($map, 10);
//echo "<pre>";print_r($list);echo "</pre>";exit;
$this->assign('search', $search);
$this->assign("list", $list['list']);
$this->assign("pagebar", $list['page']);
$this->display();
}
public function index()
{
$maprow = array();
$searchMap['borrow_status'] = array("in", '2,4,6,7');
$parm['map'] = $searchMap;
$parm['pagesize'] = 5;
$sort = "desc";
$parm['orderby'] = "b.borrow_status ASC,b.id DESC";
$list = getBorrowList($parm);
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
if ($this->isAjax()) {
$string = '';
foreach ($list['list'] as $vb) {
$string .= '
<div class="main_box">
<div class="title">
<div class="title_img">' . getIco($vb) . '</div>
<a href="' . getInvestUrl($vb['id']) . '" >' . cnsubstr($vb['borrow_name'], 17) . '</a>
</div>
<div class="box_ner">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td align="left">
<div class="box_ner_nn">
<ul>
<li>金额：<span class="col">' . MFormt($vb['borrow_money']) . '元</span></li>
<li>期限：' . $vb['borrow_duration'];
$string .= $vb['repayment_type'] == 1 ? '天' : '个月';
$string .= '</li>
<li>利率：' . $vb['borrow_interest_rate'] . '%/';
$string .= $vb['repayment_type'] == 1 ? '天' : '年';
$string .= '</li>
<li><span class="jd">进度：</span>
<span class="progress">
<span class="precent" style="width:' . $vb['progress'] . '%;"></span></span></li>
</ul>
</div>
</td>
<td align="center">' . borrow_status($vb['id'], $vb['borrow_status']) . '</td>
</tr>
</table>
</div>
</div>';
}
echo $string;
} else {
///////////////企业直投列表开始 /////////////
$parm = array();
$Map = ' b.borrow_status = 2 and b.is_show=1 and b.transfer_total > b.transfer_out';
$parm['map'] = $Map;
$parm['orderby'] = "b.is_show desc,b.id DESC";
$listTBorrow = getTBorrowList($parm);
$this->assign("listTBorrow", $listTBorrow);
///////////////企业直投列表结束 /////////////
$this->assign('list', $list);
$this->assign('Bconfig', $Bconfig);
$this->display();
}
}
public function index()
{
$curl = $_SERVER['REQUEST_URI'];
$urlarr = parse_url($curl);
parse_str($urlarr['query'], $surl);
//array获取当前链接参数，2.
$urlArr = array('borrow_status', 'borrow_duration', 'stock_type');
$searchMap = array();
//搜索条件
foreach ($urlArr as $v) {
if ($_GET[$v] && $_GET[$v] != 'all') {
switch ($v) {
case 'stock_type':
//$barr = explode("-",text($_GET[$v]));
$searchMap["b.stock_type"] = intval($_GET[$v]);
break;
case 'borrow_status':
$searchMap["b." . $v] = intval($_GET[$v]);
break;
default:
$barr = explode("-", text($_GET[$v]));
$searchMap["b." . $v] = array("between", $barr);
break;
}
}
}
if ($searchMap['b.stock_type'] == 0) {
$searchMap['b.stock_type'] = array("in", "1,2,3");
}
if ($_GET['flag'] == 'day') {
$searchMap['b.stock_type'] = 1;
} else {
if ($_GET['flag'] == 'month') {
$searchMap['b.stock_type'] = 2;
}
}
$maprow = array();
if (!empty($_GET['rate'])) {
$searchMap['borrow_interest_rate'] = array("lt", $_GET['rate']);
}
$searchMap['borrow_status'] = array("in", '2,4,6,7,3');
$parm['map'] = $searchMap;
$parm['pagesize'] = 2;
$sort = "desc";
$parm['orderby'] = "b.borrow_status ASC,b.id DESC";
$list = getBorrowList($parm);
//dump($list);die;
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
if ($this->isAjax()) {
$str = '';
foreach ($list['list'] as $vb) {
$str .= "<div class='box'>";
//$str.="<p class='tit'><a href='/m/invest/detail/id/$vb[id]'>$vb[borrow_name]</a></p>";
$str .= "<p class='tit'>";
if ($vb['stock_type'] == 2) {
$str .= "<img src='/Style/H/qimages/yy.jpg' />";
} else {
$str .= "<img src='/Style/H/qimages/tt.jpg'>";
}
$str .= "<a href='/m/invest/detail/id/{$vb['id']}'>{$vb['borrow_name']}</a></p>";
$str .= "<table cellpadding='0' cellspacing='0' border='0' class='table'>";
$str .= "<tr>";
$str .= "<td>年化收益：</td>";
/*
$str.="<td>$vb[borrow_interest_rate]%/".$vb[repayment_type]==1?'天':'年'."</td>";
$str.="<td>借款期限：</td>";
$str.="<td>".$vb[borrow_duration]." ".$vb['repayment_type']==1?'天':'个月'."</td>";
*/
if ($vb['repayment_type'] == 1) {
$day = '天';
} else {
$day = '年';
}
$str .= "<td>{$vb['borrow_interest_rate']}%/" . $day . "</td>";
$str .= "<td>借款期限：</td>";
if ($vb[repayment_type] == 1) {
$days = '天';
} else {
$days = '个月';
}
$str .= "<td>" . $vb[borrow_duration] . $days . "</td>";
$str .= "</tr><tr>";
$str .= "<td>完成进度：</td>";
$str .= "<td colspan='3'>";
$str .= "<span class='jdt'>";
$str .= "<span class='jd' style='width:" . intval($vb[progress]) . "%'></span>";
$str .= "<strong class='strong'>\n\t\t\t\t\t " . $vb[progress] . "%\n\t\t\t\t\t </strong>\n\t\t\t\t\t</span>\n\t\t\t\t\t</td></tr></table>";
$str .= "<p class='sub'>";
$str .= "借款金额：<strong class='strong'>￥" . $vb[borrow_money] . "</strong>元";
$str .= "<a class='btn-a fr' href='/m/invest/detail/id/{$vb['id']}'>立即投标</a></p></div>";
}
echo $str;
} else {
$this->assign('list', $list);
$this->assign('Bconfig', $Bconfig);
$this->display();
}
}
public function index()
{
static $newpars;
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
$per = C('DB_PREFIX');
//预发标的借款
$parm = array();
$searchMap = array();
$searchMap['b.borrow_status'] = 0;
$searchMap['b.borrow_btype'] = 2;
$parm['map'] = $searchMap;
$parm['limit'] = 8;
$parm['orderby'] = "b.id DESC";
$expectBorrow = getBorrowList($parm);
$this->assign("expectBorrow", $expectBorrow);
//预发标的借款
$curl = $_SERVER['REQUEST_URI'];
$urlarr = parse_url($curl);
parse_str($urlarr['query'], $surl);
//array获取当前链接参数，2.
$urlArr = array('borrow_status', 'borrow_duration', 'leve');
$leveconfig = FS("Webconfig/leveconfig");
foreach ($urlArr as $v) {
$newpars = $surl;
//用新变量避免后面的连接受影响
unset($newpars[$v], $newpars['type'], $newpars['order_sort'], $newpars['orderby']);
//去掉公共参数，对掉当前参数
foreach ($newpars as $skey => $sv) {
if ($sv == "all") {
unset($newpars[$skey]);
}
//去掉"全部"状态的参数,避免地址栏全满
}
$newurl = http_build_query($newpars);
//生成此值的链接,生成必须是即时生成
$searchUrl[$v]['url'] = $newurl;
$searchUrl[$v]['cur'] = empty($_GET[$v]) ? "all" : text($_GET[$v]);
}
$searchMap['borrow_status'] = array("all" => "不限制", "2" => "进行中", "4" => "复审中", "6" => "还款中", "7" => "已完成");
$searchMap['borrow_duration'] = array("all" => "不限制", "0-3" => "3个月以内", "3-6" => "3-6个月", "6-12" => "6-12个月", "12-24" => "12-24个月");
$searchMap['leve'] = array("all" => "不限制", "{$leveconfig['1']['start']}-{$leveconfig['1']['end']}" => "{$leveconfig['1']['name']}", "{$leveconfig['2']['start']}-{$leveconfig['2']['end']}" => "{$leveconfig['2']['name']}", "{$leveconfig['3']['start']}-{$leveconfig['3']['end']}" => "{$leveconfig['3']['name']}", "{$leveconfig['4']['start']}-{$leveconfig['4']['end']}" => "{$leveconfig['4']['name']}", "{$leveconfig['5']['start']}-{$leveconfig['5']['end']}" => "{$leveconfig['5']['name']}", "{$leveconfig['6']['start']}-{$leveconfig['6']['end']}" => "{$leveconfig['6']['name']}", "{$leveconfig['7']['start']}-{$leveconfig['7']['end']}" => "{$leveconfig['7']['name']}");
$search = array();
//搜索条件
foreach ($urlArr as $v) {
if ($_GET[$v] && $_GET[$v] != 'all') {
switch ($v) {
case 'leve':
$barr = explode("-", text($_GET[$v]));
$search["m.credits"] = array("between", $barr);
break;
case 'borrow_status':
$search["b." . $v] = intval($_GET[$v]);
break;
default:
$barr = explode("-", text($_GET[$v]));
$search["b." . $v] = array("between", $barr);
break;
}
}
}
if ($search['b.borrow_status'] == 0) {
$search['b.borrow_status'] = array("in", "2,4,6,7");
}
$str = "%" . urldecode($_REQUEST['searchkeywords']) . "%";
if ($_GET['is_keyword'] == '1') {
$search['m.user_name'] = array("like", $str);
} elseif ($_GET['is_keyword'] == '2') {
$search['b.borrow_name'] = array("like", $str);
}
$search['b.borrow_btype'] = 2;
$parm['map'] = $search;
$parm['pagesize'] = 8;
//排序
strtolower($_GET['sort']) == "asc" ? $sort = "desc" : ($sort = "asc");
unset($surl['orderby'], $surl['sort']);
$orderUrl = http_build_query($surl);
if ($_GET['orderby']) {
//if(strtolower($_GET['orderby'])=="leve") $parm['orderby'] = "m.credits ".text($_GET['sort']);
if (strtolower($_GET['orderby']) == "rate") {
$parm['orderby'] = "b.borrow_interest_rate " . text($_GET['sort']);
} elseif (strtolower($_GET['orderby']) == "borrow_money") {
$parm['orderby'] = "b.borrow_money " . text($_GET['sort']);
} else {
$parm['orderby'] = "b.id DESC";
}
} else {
$parm['orderby'] = "b.borrow_status ASC,b.id DESC";
}
$Sorder['Corderby'] = strtolower(text($_GET['orderby']));
$Sorder['Csort'] = strtolower(text($_GET['sort']));
$Sorder['url'] = $orderUrl;
$Sorder['sort'] = $sort;
$Sorder['orderby'] = text($_GET['orderby']);
//排序
$list = getBorrowList($parm);
//dump(M()->GetLastsql());exit;
$this->assign("Sorder", $Sorder);
$this->assign("searchUrl", $searchUrl);
$this->assign("searchMap", $searchMap);
$this->assign("Bconfig", $Bconfig);
$this->assign("Buse", $this->gloconf['BORROW_USE']);
$this->assign("list", $list);
$this->display();
}
public function index()
{
$per = C('DB_PREFIX');
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
//网站公告
$parm['type_id'] = 26;
$parm['limit'] = 4;
$this->assign("noticeList", getArticleList($parm));
//网站公告
$a = loan_total_info();
//var_dump($a);
$d['a1'] = M('members m')->where($map)->count('m.id');
//假的
$d['a2'] = $a['ordinary_total'];
$d['a3'] = $a['num_total'];
$d['a4'] = $a['has_also'];
$d['a5'] = $a['arrears'];
//var_dump($d);
$this->assign("a1", $d);
//正在进行的贷款
$searchMap = array();
$searchMap['b.borrow_status'] = array("in", '2,4,6,7');
//$searchMap['b.is_tuijian']=array("in",'0,1');
//$searchMap['b.borrow_btype']=1;
$parm = array();
$parm['map'] = $searchMap;
$parm['limit'] = 6;
$parm['orderby'] = "b.borrow_status ASC,b.id DESC";
$listBorrow = getBorrowList($parm);
//var_dump($listBorrow);
$this->assign("listBorrow", $listBorrow);
$searchMap = array();
$searchMap['b.borrow_status'] = array("in", '2,4,6,7');
$searchMap['_string'] = "b.is_tuijian = 1";
$parm = array();
$parm['map'] = $searchMap;
$parm['limit'] = 2;
$parm['_string'] = "b.is_tuijian = 1";
$parm['orderby'] = "b.borrow_status ASC,b.id DESC";
$listBorrow1 = getBorrowList($parm);
$this->assign("listBorrow1", $listBorrow1);
//测试时间获取函数开始
//$date = date("Y-m-d",time());
//$ret = get_date($date,'m');
//dump($ret);exit;
//测试时间获取函数结束
//////////////////////调取数据////////////
$money_log = get_money_log(0);
$borrowOutNum = M("borrow_info")->where("borrow_status in(6,7,8,9)")->count("id");
$transferBorrowOutNum = M("transfer_borrow_info")->count("id");
$mborrowOutNum = $borrowOutNum + $transferBorrowOutNum;
$shouyi = M('borrow_info')->sum('borrow_interest');
$this->assign("shouyi", $shouyi);
$this->assign("mcount", M("members")->count("id"));
$this->assign("mborrowOut", $money_log['17']['money']);
$this->assign("mborrowOutNum", $mborrowOutNum);
//////////////////////调取数据////////////
//正在进行的贷款
///////////////省心宝列表开始 fan 2013-10-21//////////////
$parm = array();
$searchMap = array();
//$searchMap['borrow_status']=2;
//$searchMap['b.on_off']=1;
//$searchMap['b.is_jijin']=0;
//$searchMap['b.is_show'] = array('in','0,1');
$searchMap['b.borrow_status'] = array('neq', '3');
//$searchMap['b.online_time']=array("lt",time());
$parm['map'] = $searchMap;
$parm['limit'] = 3;
//$parm['orderby'] = "b.is_show desc,b.progress asc";
$listTBorrow = getTBorrowList($parm);
$this->assign("listTBorrow", $listTBorrow);
///////////////省心宝列表结束 fan 2013-10-21//////////////
///////////////省心宝列表开始 fan 2014-06-13//////////////
/* hycd $parm = array();
$searchMap = array();
//$searchMap['borrow_status']=2;
//$searchMap['is_tuijian']=0;
$searchMap['on_off']=1;
$searchMap['is_jijin']=1;
$searchMap['b.online_time']=array("lt",time()+300);
$parm['map'] = $searchMap;
$parm['limit'] = 2;
$parm['orderby'] = "b.is_show desc,b.borrow_status ASC,b.borrow_duration ASC,b.online_time desc";
$listFBorrow = getTBorrowList($parm);
$this->assign("listFBorrow",$listFBorrow);
$this->assign('Bconfig',$Bconfig);*/
$searchMap = array();
$searchMap['b.borrow_status'] = array("in", '2,4,6,7');
$searchMap['b.is_tuijian'] = array("in", '0,1');
//$searchMap['b.borrow_btype']=2;
$parm = array();
$parm['map'] = $searchMap;
$parm['limit'] = 2;
$parm['orderby'] = "b.borrow_status ASC,b.id DESC";
$listFBorrow = getTBorrowList($parm);
//var_dump($listBorrow);
$this->assign("listFBorrow", $listFBorrow);
///////////////省心宝列表结束 fan 2014-06-13///////////////
$this->display();
/****************************募集期内标未满,自动流标 新增 2013-03-13****************************/
//流标返回
$mapT = array();
$mapT['collect_time'] = array("lt", time());
$mapT['borrow_status'] = 2;
$tlist = M("borrow_info")->field("id,borrow_uid,borrow_type,borrow_money,first_verify_time,borrow_interest_rate,borrow_duration,repayment_type,collect_day,collect_time")->where($mapT)->select();
if (empty($tlist)) {
exit;
}
foreach ($tlist as $key => $vbx) {
$borrow_id = $vbx['id'];
//流标
$done = false;
$borrowInvestor = D('borrow_investor');
$binfo = M("borrow_info")->field("borrow_type,borrow_money,borrow_uid,borrow_duration,repayment_type")->find($borrow_id);
$investorList = $borrowInvestor->field('id,investor_uid,investor_capital')->where("borrow_id={$borrow_id}")->select();
M('investor_detail')->where("borrow_id={$borrow_id}")->delete();
if ($binfo['borrow_type'] == 1) {
$limit_credit = memberLimitLog($binfo['borrow_uid'], 12, $binfo['borrow_money'], $info = "{$binfo['id']}号标流标");
}
//返回额度
$borrowInvestor->startTrans();
$bstatus = 3;
$upborrow_info = M('borrow_info')->where("id={$borrow_id}")->setField("borrow_status", $bstatus);
//处理借款概要
$buname = M('members')->getFieldById($binfo['borrow_uid'], 'user_name');
//处理借款概要
if (is_array($investorList)) {
$upsummary_res = M('borrow_investor')->where("borrow_id={$borrow_id}")->setField("status", $type);
foreach ($investorList as $v) {
MTip('chk15', $v['investor_uid']);
//sss
$accountMoney_investor = M("member_money")->field(true)->find($v['investor_uid']);
$datamoney_x['uid'] = $v['investor_uid'];
$datamoney_x['type'] = $type == 3 ? 16 : 8;
$datamoney_x['affect_money'] = $v['investor_capital'];
$datamoney_x['account_money'] = $accountMoney_investor['account_money'] + $datamoney_x['affect_money'];
//投标不成功返回充值资金池
$datamoney_x['collect_money'] = $accountMoney_investor['money_collect'];
$datamoney_x['freeze_money'] = $accountMoney_investor['money_freeze'] - $datamoney_x['affect_money'];
$datamoney_x['back_money'] = $accountMoney_investor['back_money'];
//会员帐户
$mmoney_x['money_freeze'] = $datamoney_x['freeze_money'];
$mmoney_x['money_collect'] = $datamoney_x['collect_money'];
$mmoney_x['account_money'] = $datamoney_x['account_money'];
$mmoney_x['back_money'] = $datamoney_x['back_money'];
//会员帐户
$_xstr = $type == 3 ? "复审未通过" : "募集期内标未满,流标";
$datamoney_x['info'] = "第{$borrow_id}号标" . $_xstr . "，返回冻结资金";
$datamoney_x['add_time'] = time();
$datamoney_x['add_ip'] = get_client_ip();
$datamoney_x['target_uid'] = $binfo['borrow_uid'];
$datamoney_x['target_uname'] = $buname;
$moneynewid_x = M('member_moneylog')->add($datamoney_x);
if ($moneynewid_x) {
$bxid = M('member_money')->where("uid={$datamoney_x['uid']}")->save($mmoney_x);
}
}
} else {
$moneynewid_x = true;
$bxid = true;
$upsummary_res = true;
}
if ($moneynewid_x && $upsummary_res && $bxid && $upborrow_info) {
$done = true;
$borrowInvestor->commit();
} else {
$borrowInvestor->rollback();
}
if (!$done) {
continue;
}
MTip('chk11', $vbx['borrow_uid'], $borrow_id);
$verify_info['borrow_id'] = $borrow_id;
$verify_info['deal_info_2'] = text($_POST['deal_info_2']);
$verify_info['deal_user_2'] = 0;
$verify_info['deal_time_2'] = time();
$verify_info['deal_status_2'] = 3;
if ($vbx['first_verify_time'] > 0) {
M('borrow_verify')->save($verify_info);
} else {
M('borrow_verify')->add($verify_info);
}
$vss = M("members")->field("user_phone,user_name")->where("id = {$vbx['borrow_uid']}")->find();
SMStip("refuse", $vss['user_phone'], array("#USERANEM#", "ID"), array($vss['user_name'], $verify_info['borrow_id']));
//@SMStip("refuse",$vss['user_phone'],array("#USERANEM#","ID"),array($vss['user_name'],$verify_info['borrow_id']));
//updateBinfo
$newBinfo = array();
$newBinfo['id'] = $borrow_id;
$newBinfo['borrow_status'] = 3;
$newBinfo['second_verify_time'] = time();
$x = M("borrow_info")->save($newBinfo);
}
/****************************募集期内标未满,自动流标 新增 2013-03-13****************************/
}
public function index()
{
$jsoncode = file_get_contents("php://input");
$arr = array();
$arr = json_decode($jsoncode, true);
// $arr['id'] = 0;
// $arr['type'] = 0;
// $arr['num'] = 3;
// $arr['tid'] = 11;
// $arr['ttype'] = 1;
// $arr['tnum'] = 3;
//普通标翻页
if (is_array($arr) && isset($arr['id']) && isset($arr['type']) && isset($arr['num'])) {
$type = $arr['type'];
$id = intval($arr['id']);
$num = intval($arr['num']);
} else {
$type = 2;
$num = 5;
}
//流转标翻页
if (is_array($arr) && isset($arr['tid']) && isset($arr['ttype']) && isset($arr['tnum'])) {
$ttype = $arr['ttype'];
$tid = intval($arr['tid']);
$tnum = intval($arr['tnum']);
} else {
$ttype = 2;
$tnum = 5;
}
//alogsm("Main",0,1,$jsoncode);
$per = C('DB_PREFIX');
//普通标
if ($type == 1) {
$searchMap['borrow_status'] = array("in", '2,4,6,7');
$searchMap['b.id'] = array("gt", $id);
$parm['map'] = $searchMap;
$parm['limit'] = $num;
$parm['orderby'] = "b.borrow_status ASC,b.id asc";
} elseif ($type == 0) {
$searchMap['borrow_status'] = array("in", '2,4,6,7');
$searchMap['b.id'] = array("lt", $id);
$parm['map'] = $searchMap;
$parm['limit'] = $num;
$parm['orderby'] = "b.borrow_status ASC,b.id DESC";
} else {
$searchMap['borrow_status'] = array("in", '2,4,6,7');
$parm['map'] = $searchMap;
$parm['limit'] = $num;
$parm['orderby'] = "b.borrow_status ASC,b.id DESC";
}
$list = getBorrowList($parm);
//$_list = $list;
foreach ($list['list'] as $key => $v) {
$_list[$key]['uid'] = intval($v['uid']);
$_list[$key]['type'] = getleixing($v);
$_list[$key]['id'] = intval($v['id']);
$_list[$key]['borrow_name'] = $v['borrow_name'];
$_list[$key]['borrow_interest_rate'] = $v['borrow_interest_rate'];
if ($v['repayment_type'] == 1) {
$_list[$key]['borrow_duration'] = $v['borrow_duration'] . "天";
} else {
$_list[$key]['borrow_duration'] = $v['borrow_duration'] . "个月";
}
$_list[$key]['repayment_type'] = $v['repayment_type'];
$_list[$key]['borrow_money'] = $v['borrow_money'];
$_list[$key]['progress'] = $v['progress'];
$_list[$key]['credits'] = $v['credits'];
$_list[$key]['user_name'] = $v['user_name'];
$_list[$key]['imgpath'] = get_avatar(intval($v['uid']));
$_list[$key]['suo'] = empty($v['password']) ? 0 : 1;
//是否定向标
if ($v['reward_type'] == 1) {
$_list[$key]['reward'] = $v['reward_num'] . "%";
} elseif ($v['reward_type'] == 2) {
$_list[$key]['reward'] = $v['reward_num'] . "元";
} else {
$_list[$key]['reward'] = "0";
}
}
$m_list['list'] = $_list;
//企业直投
$parmt = array();
$searchMapt = array();
//$searchMap['borrow_status']=2;
if ($ttype == 1) {
$searchMapt['is_show'] = array('in', '0,1');
$searchMapt['b.id'] = array("gt", $tid);
$parmt['map'] = $searchMapt;
$parmt['limit'] = $tnum;
$parmt['orderby'] = "b.is_show desc,b.id asc";
} elseif ($ttype == 0) {
$searchMapt['is_show'] = array('in', '0,1');
$searchMapt['b.id'] = array("lt", $tid);
$parmt['map'] = $searchMapt;
$parmt['limit'] = $tnum;
$parmt['orderby'] = "b.is_show desc,b.id DESC";
} else {
$searchMapt['is_show'] = array('in', '0,1');
$parmt['map'] = $searchMapt;
$parmt['limit'] = $tnum;
$parmt['orderby'] = "b.is_show desc,b.id DESC";
}
$tlist = getTBorrowList($parmt);
foreach ($tlist['list'] as $key => $v) {
$_tlist[$key]['uid'] = intval($v['uid']);
$_tlist[$key]['type'] = 2;
$_tlist[$key]['id'] = intval($v['id']);
$_tlist[$key]['borrow_name'] = $v['borrow_name'];
$_tlist[$key]['borrow_interest_rate'] = $v['borrow_interest_rate'];
$_tlist[$key]['borrow_duration'] = $v['borrow_duration'] . "个月";
$_tlist[$key]['per_transfer'] = $v['per_transfer'];
$_tlist[$key]['borrow_money'] = $v['borrow_money'];
$_tlist[$key]['progress'] = $v['progress'];
$_tlist[$key]['credits'] = $v['credits'];
$_tlist[$key]['user_name'] = $v['user_name'];
$_tlist[$key]['imgpath'] = get_avatar(intval($v['uid']));
$_tlist[$key]['reward'] = $v['reward_rate'] . "%";
}
$m_list['tlist'] = $_tlist;
echo ajaxmsg($m_list);
}
public function borrowdone()
{
$map['borrow_uid'] = $this->uid;
$map['borrow_status'] = 7;
if ($_GET['start_time8'] && $_GET['end_time8']) {
$_GET['start_time8'] = strtotime($_GET['start_time8'] . " 00:00:00");
$_GET['end_time8'] = strtotime($_GET['end_time8'] . " 23:59:59");
if ($_GET['start_time8'] < $_GET['end_time8']) {
$map['add_time'] = array("between", "{$_GET['start_time8']},{$_GET['end_time8']}");
$search['start_time8'] = $_GET['start_time8'];
$search['end_time8'] = $_GET['end_time8'];
}
}
$list = getBorrowList($map, 10);
$this->assign('search', $search);
$this->assign("list", $list['list']);
$this->assign("pagebar", $list['page']);
$data['html'] = $this->fetch();
exit(json_encode($data));
}
public function index()
{
//访问首页跳转到https
// if($_SERVER['SERVER_PORT'] != '443'){
// header('HTTP/1.1 301 Moved Permanently');
// //$request_uri = isset($_SERVER['REQUEST_URI']) ? $_SERVER['REQUEST_URI'] : '';
// //header('Location: https://www.cailai.com' . $_SERVER['PHP_SELF'] . $request_uri);
// header('Location: https://www.cailai.com/');
// }
$per = C('DB_PREFIX');
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
//网站公告
$parm['type_id'] = 9;
$parm['limit'] = 7;
$this->assign("noticeList", getArticleList($parm));
//网站公告
//统计 2015 07 22
$statictis = M('home_tongji')->find();
$this->statictis = $statictis;
//投资达人列表
$daren = M("amount_top")->select();
$this->daren = $daren;
//新手标
$newbie = M("newbie_bid")->where('logic_del!=9')->find();
$this->gary = $newbie;
//
//转让专区
$map = array();
$map['d.status'] = array("in", "2,4");
$parm = array();
$parm['map'] = $map;
D("DebtBehavior");
$Debt = new DebtBehavior();
$lists = $Debt->listAll($parm, 2, false);
//print_r($lists);
//dump($lists);
//die;
$this->assign("lists", $lists);
///////////////债权转让结束 gwf 2014-10-21//////////////
//新手标开始----201509-08
// $newmatch = array();
// $newmatch['b.logic_del']=array("neq",'9');//逻辑删除 9为 默认删除掉
// //$newmatch['b.is_tuijian']=array("in",'0,1');
// $parm=array();
// $parm['map'] = $newmatch;
// $parm['limit'] = 1;
// $parm['orderby']="b.id DESC";
// $listBorrowNew = getNewBie($parm);
// // dump($listBorrowNew);
// $gary=$listBorrowNew['list']['0'];
// dump($gary);
// array(2) { ["list"]=> array(3) { [0]=> array(5) { ["id"]=> string(1) "3" ["bidname"]=> string(1) "4" ["borrow_uid"]=> string(1) "5" ["bidtime"]=> string(1) "7" ["rate"]=> string(2) "12" } [1]=> array(5) { ["id"]=> string(1) "2" ["bidname"]=> string(1) "3" ["borrow_uid"]=> string(1) "4" ["bidtime"]=> string(1) "7" ["rate"]=> string(2) "12" } [2]=> array(5) { ["id"]=> string(1) "1" ["bidname"]=> string(1) "2" ["borrow_uid"]=> string(1) "3" ["bidtime"]=> string(1) "7" ["rate"]=> string(2) "12" } } ["page"]=> string(0) "" }
//只需在前端遍历数组
//新手标结束----201509-08 lj
//正在进行的贷款
$searchMap = array();
$searchMap['b.borrow_status'] = array("in", '2,4,6,7');
$searchMap['b.is_tuijian'] = array("in", '0,1');
$searchMap['b.borrow_type'] = array("neq", 9);
$searchMap['b.is_new'] = array("eq", 0);
$parm = array();
$parm['map'] = $searchMap;
$parm['limit'] = 10;
//$parm['orderby']="b.borrow_status ASC,b.id DESC";
$listBorrow = getBorrowList($parm);
//dump($listBorrow);die;
$this->assign("listBorrow", $listBorrow);
///////////////企业直投推荐开始 gwf 2014-10-21//////////////
$parm = array();
$searchMap = array();
$parm['limit'] = 1;
$parm['map'] = $searchMap;
$parm['orderby'] = "bi.is_tuijian desc,bi.id desc";
$listTBorrowa = getTBorrowList($parm);
$this->assign("listTBorrowa", $listTBorrowa);
///////////////企业直投推荐开始 gwf 2014-10-21//////////////
///////////////企业直投列表开始 gwf 2014-10-21//////////////
$parm = array();
$searchMap = array();
$searchMap['bi.borrow_status'] = array('neq', '3');
$searchMap['bi.borrow_type'] = array("eq", "9");
$parm['map'] = $searchMap;
$parm['limit'] = 4;
$parm['orderby'] = "bi.id DESC,bi.borrow_status ASC";
$listTBorrow = getTBorrowList($parm);
//dump($listTBorrow);die;
$this->assign("listTBorrow", $listTBorrow);
///////////////企业直投列表结束 gwf 2014-10-21//////////////
$this->display();
/****************************募集期内标未满,自动流标 新增 2013-03-13****************************/
//流标返回
$mapT = array();
$mapT['collect_time'] = array("lt", time());
$mapT['borrow_status'] = 2;
$tlist = M("borrow_info")->field("id,borrow_uid,borrow_type,borrow_money,first_verify_time,borrow_interest_rate,borrow_duration,repayment_type,collect_day,collect_time")->where($mapT)->select();
if (empty($tlist)) {
exit;
}
foreach ($tlist as $key => $vbx) {
$borrow_id = $vbx['id'];
//流标
$done = false;
$borrowInvestor = D('borrow_investor');
$binfo = M("borrow_info")->field("borrow_type,borrow_money,borrow_uid,borrow_duration,repayment_type")->find($borrow_id);
$investorList = $borrowInvestor->field('id,investor_uid,investor_capital')->where("borrow_id={$borrow_id}")->select();
M('investor_detail')->where("borrow_id={$borrow_id}")->delete();
if ($binfo['borrow_type'] == 1) {
$limit_credit = memberLimitLog($binfo['borrow_uid'], 12, $binfo['borrow_money'], $info = "{$binfo['id']}号标流标");
}
//返回额度
$borrowInvestor->startTrans();
$bstatus = 3;
$upborrow_info = M('borrow_info')->where("id={$borrow_id}")->setField("borrow_status", $bstatus);
//处理借款概要
$buname = M('members')->getFieldById($binfo['borrow_uid'], 'user_name');
//处理借款概要
if (is_array($investorList)) {
$upsummary_res = M('borrow_investor')->where("borrow_id={$borrow_id}")->setField("status", $type);
foreach ($investorList as $v) {
MTip('chk15', $v['investor_uid']);
//sss
$accountMoney_investor = M("member_money")->field(true)->find($v['investor_uid']);
$datamoney_x['uid'] = $v['investor_uid'];
$datamoney_x['type'] = $type == 3 ? 16 : 8;
$datamoney_x['affect_money'] = $v['investor_capital'];
$datamoney_x['account_money'] = $accountMoney_investor['account_money'] + $datamoney_x['affect_money'];
//投标不成功返回充值资金池
$datamoney_x['collect_money'] = $accountMoney_investor['money_collect'];
$datamoney_x['freeze_money'] = $accountMoney_investor['money_freeze'] - $datamoney_x['affect_money'];
$datamoney_x['back_money'] = $accountMoney_investor['back_money'];
//会员帐户
$mmoney_x['money_freeze'] = $datamoney_x['freeze_money'];
$mmoney_x['money_collect'] = $datamoney_x['collect_money'];
$mmoney_x['account_money'] = $datamoney_x['account_money'];
$mmoney_x['back_money'] = $datamoney_x['back_money'];
//会员帐户
$_xstr = $type == 3 ? "复审未通过" : "募集期内标未满,流标";
$datamoney_x['info'] = "第{$borrow_id}号标" . $_xstr . "，返回冻结资金";
$datamoney_x['add_time'] = time();
$datamoney_x['add_ip'] = get_client_ip();
$datamoney_x['target_uid'] = $binfo['borrow_uid'];
$datamoney_x['target_uname'] = $buname;
$moneynewid_x = M('member_moneylog')->add($datamoney_x);
if ($moneynewid_x) {
$bxid = M('member_money')->where("uid={$datamoney_x['uid']}")->save($mmoney_x);
}
}
} else {
$moneynewid_x = true;
$bxid = true;
$upsummary_res = true;
}
if ($moneynewid_x && $upsummary_res && $bxid && $upborrow_info) {
$done = true;
$borrowInvestor->commit();
} else {
$borrowInvestor->rollback();
}
if (!$done) {
continue;
}
MTip('chk11', $vbx['borrow_uid'], $borrow_id);
$verify_info['borrow_id'] = $borrow_id;
$verify_info['deal_info_2'] = text($_POST['deal_info_2']);
$verify_info['deal_user_2'] = 0;
$verify_info['deal_time_2'] = time();
$verify_info['deal_status_2'] = 3;
if ($vbx['first_verify_time'] > 0) {
M('borrow_verify')->save($verify_info);
} else {
M('borrow_verify')->add($verify_info);
}
$vss = M("members")->field("user_phone,user_name")->where("id = {$vbx['borrow_uid']}")->find();
SMStip("refuse", $vss['user_phone'], array("#USERANEM#", "ID"), array($vss['user_name'], $verify_info['borrow_id']));
//@SMStip("refuse",$vss['user_phone'],array("#USERANEM#","ID"),array($vss['user_name'],$verify_info['borrow_id']));
//updateBinfo
$newBinfo = array();
$newBinfo['id'] = $borrow_id;
$newBinfo['borrow_status'] = 3;
$newBinfo['second_verify_time'] = time();
$x = M("borrow_info")->save($newBinfo);
}
/****************************募集期内标未满,自动流标 新增 2013-03-13****************************/
}
public function index()
{
$per = C('DB_PREFIX');
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
//网站公告
$parm['type_id'] = 9;
$parm['limit'] = 7;
$this->assign("noticeList", getArticleList($parm));
//网站公告
/*
//正在进行的贷款
$searchMap = array();
$searchMap['borrow_status']=array("in",'2,4,6,7');
$searchMap['is_tuijian']=array("in",'0,1');
$searchMap['deadline']=strtotime("deadline");
$parm=array();
$parm['map'] = $searchMap;
$parm['limit'] = 1;
$parm['orderby']="b.id DESC,b.borrow_status ASC";
$listBorrow = getBorrowList($parm);
$this->assign("listBorrow",$listBorrow);
//散标开始
$Bconfig = require C("APP_ROOT")."Conf/borrow_config.php";
$per = C('DB_PREFIX');
//预发标的借款
$parm=array();
$searchMap = array();
$searchMap['borrow_status']=array("in",'9');
$searchMap['b.borrow_status']=0;
$parm['map'] = $searchMap;
$parm['limit'] = 5;
$parm['orderby']="b.id DESC";
$list = getBorrowList($parm);
//dump($list);die;
$this->assign("list",$list);
///////////////债权转让开始 gwf 2014-10-21//////////////
$map = array();
$map['d.status']=array("in","2,4");
$parm = array();
$parm['map'] = $map;
D("DebtBehavior");
$Debt = new DebtBehavior();
$lists = $Debt->listAll($parm ,3, true);
$this->assign("lists", $lists);
///////////////债权转让结束 gwf 2014-10-21//////////////
///////////////企业直投推荐开始 gwf 2014-10-21//////////////
$parm = array();
$searchMap = array();
$parm['limit'] =1;
$parm['map'] = $searchMap;
$parm['orderby'] = "bi.is_tuijian desc,bi.id desc";
$listTBorrowa = getTBorrowList($parm);
$this->assign("listTBorrowa",$listTBorrowa);
///////////////企业直投推荐开始 gwf 2014-10-21//////////////
*/
//的借款
//还款中的借款总额 @董强
$map = array();
$map['borrow_status'] = array("in", "6,7");
$Repayment = M("borrow_info")->field("SUM(borrow_money) as money")->where($map)->select();
$this->assign("Repayment_money", $Repayment[0]['money']);
//还款中的借款总额 END
//正常还款完成利息总额 @董强
$where = array();
$where['status'] = array("in", "5,6,7");
$Repayment_lx = M("borrow_investor")->field("SUM(investor_interest) as investor_interest")->where($where)->select();
$this->assign("investor_interest", $Repayment_lx[0]['investor_interest']);
//正常还款完成利息总额 END//
$parm = array();
$searchMap = array();
$searchMap['b.borrow_status'] = array('neq', '3');
$searchMap['b.borrow_type'] = array("neq", "9");
$parm['map'] = $searchMap;
$parm['limit'] = 3;
$parm['orderby'] = "b.id DESC";
$list = getBorrowList($parm);
//dump($list);die;
$this->assign("list", $list);
///////////////企业直投列表开始 gwf 2014-10-21//////////////
$parm = array();
$searchMap = array();
$searchMap['bi.borrow_status'] = array('neq', '3');
$searchMap['bi.borrow_type'] = array("eq", "9");
$parm['map'] = $searchMap;
$parm['limit'] = 3;
$parm['orderby'] = "bi.borrow_status ASC";
$listTBorrow = getTBorrowList($parm);
$this->assign("listTBorrow", $listTBorrow);
///////////////企业直投列表结束 gwf 2014-10-21//////////////
$this->display();
/****************************募集期内标未满,自动流标 新增 2013-03-13****************************/
//流标返回
$mapT = array();
$mapT['collect_time'] = array("lt", time());
$mapT['borrow_status'] = 2;
$tlist = M("borrow_info")->field("id,borrow_uid,borrow_type,borrow_money,first_verify_time,borrow_interest_rate,borrow_duration,repayment_type,collect_day,collect_time")->where($mapT)->select();
if (empty($tlist)) {
exit;
}
foreach ($tlist as $key => $vbx) {
$borrow_id = $vbx['id'];
//流标
$done = false;
$borrowInvestor = D('borrow_investor');
$binfo = M("borrow_info")->field("borrow_type,borrow_money,borrow_uid,borrow_duration,repayment_type")->find($borrow_id);
$investorList = $borrowInvestor->field('id,investor_uid,investor_capital')->where("borrow_id={$borrow_id}")->select();
M('investor_detail')->where("borrow_id={$borrow_id}")->delete();
if ($binfo['borrow_type'] == 1) {
$limit_credit = memberLimitLog($binfo['borrow_uid'], 12, $binfo['borrow_money'], $info = "{$binfo['id']}号标流标");
}
//返回额度
$borrowInvestor->startTrans();
$bstatus = 3;
$upborrow_info = M('borrow_info')->where("id={$borrow_id}")->setField("borrow_status", $bstatus);
//处理借款概要
$buname = M('members')->getFieldById($binfo['borrow_uid'], 'user_name');
//处理借款概要
if (is_array($investorList)) {
$upsummary_res = M('borrow_investor')->where("borrow_id={$borrow_id}")->setField("status", $type);
foreach ($investorList as $v) {
MTip('chk15', $v['investor_uid']);
//sss
$accountMoney_investor = M("member_money")->field(true)->find($v['investor_uid']);
$datamoney_x['uid'] = $v['investor_uid'];
$datamoney_x['type'] = $type == 3 ? 16 : 8;
$datamoney_x['affect_money'] = $v['investor_capital'];
$datamoney_x['account_money'] = $accountMoney_investor['account_money'] + $datamoney_x['affect_money'];
//投标不成功返回充值资金池
$datamoney_x['collect_money'] = $accountMoney_investor['money_collect'];
$datamoney_x['freeze_money'] = $accountMoney_investor['money_freeze'] - $datamoney_x['affect_money'];
$datamoney_x['back_money'] = $accountMoney_investor['back_money'];
//会员帐户
$mmoney_x['money_freeze'] = $datamoney_x['freeze_money'];
$mmoney_x['money_collect'] = $datamoney_x['collect_money'];
$mmoney_x['account_money'] = $datamoney_x['account_money'];
$mmoney_x['back_money'] = $datamoney_x['back_money'];
//会员帐户
$_xstr = $type == 3 ? "复审未通过" : "募集期内标未满,流标";
$datamoney_x['info'] = "第{$borrow_id}号标" . $_xstr . "，返回冻结资金";
$datamoney_x['add_time'] = time();
$datamoney_x['add_ip'] = get_client_ip();
$datamoney_x['target_uid'] = $binfo['borrow_uid'];
$datamoney_x['target_uname'] = $buname;
$moneynewid_x = M('member_moneylog')->add($datamoney_x);
if ($moneynewid_x) {
$bxid = M('member_money')->where("uid={$datamoney_x['uid']}")->save($mmoney_x);
}
}
} else {
$moneynewid_x = true;
$bxid = true;
$upsummary_res = true;
}
if ($moneynewid_x && $upsummary_res && $bxid && $upborrow_info) {
$done = true;
$borrowInvestor->commit();
} else {
$borrowInvestor->rollback();
}
if (!$done) {
continue;
}
MTip('chk11', $vbx['borrow_uid'], $borrow_id);
$verify_info['borrow_id'] = $borrow_id;
$verify_info['deal_info_2'] = text($_POST['deal_info_2']);
$verify_info['deal_user_2'] = 0;
$verify_info['deal_time_2'] = time();
$verify_info['deal_status_2'] = 3;
if ($vbx['first_verify_time'] > 0) {
M('borrow_verify')->save($verify_info);
} else {
M('borrow_verify')->add($verify_info);
}
$vss = M("members")->field("user_phone,user_name")->where("id = {$vbx['borrow_uid']}")->find();
SMStip("refuse", $vss['user_phone'], array("#USERANEM#", "ID"), array($vss['user_name'], $verify_info['borrow_id']));
//@SMStip("refuse",$vss['user_phone'],array("#USERANEM#","ID"),array($vss['user_name'],$verify_info['borrow_id']));
//updateBinfo
$newBinfo = array();
$newBinfo['id'] = $borrow_id;
$newBinfo['borrow_status'] = 3;
$newBinfo['second_verify_time'] = time();
$x = M("borrow_info")->save($newBinfo);
}
/****************************募集期内标未满,自动流标 新增 2013-03-13****************************/
}
public function index()
{
// $this->duizhang();
$ucLoing = de_xie($_COOKIE['LoginCookie']);
setcookie('LoginCookie', '', time() - 10 * 60, "/");
$this->assign("uclogin", $ucLoing);
$this->assign("unread", $read = M("inner_msg")->where("uid={$this->uid} AND status=0")->count('id'));
$this->assign("mstatus", M('members_status')->field(true)->find($this->uid));
$danbao = M('borrow_investor')->where("borrow_uid=" . $this->uid)->sum("guar_fee");
$this->assign("danbao", $danbao);
//die(M()->getlastsql());
//echo $danbao;exit;
//查询会员状态
$vip_status = M("members_status as ms")->field("ms.phone_status,ms.id_status,ms.email_status,ms.safequestion_status,lmb.uid")->join("left join lzh_member_banks as lmb on ms.uid=lmb.uid")->where('ms.uid=' . $this->uid)->find();
$this->vip = $vip_status;
$minfo = getMinfo($this->uid, true);
$pin_pass = $minfo['pin_pass'];
$has_pin = empty($pin_pass) ? "no" : "yes";
$this->assign("has_pin", $has_pin);
$this->assign("memberinfo", M('members')->find($this->uid));
$this->assign("memberdetail", M('member_info')->find($this->uid));
$this->assign("minfo", $minfo);
//加上新手标的利息 2015-09-18
$benefit = get_personal_benefit($this->uid);
//dump($benefit);
//查询新手标的代收利息
$newbieinterest = M('newbie_record')->field('interest')->where('investid=' . $this->uid . ' and status=4')->find();
//echo M()->getLastSql();
$benefit['interest_collection'] = $benefit['interest_collection'] + $newbieinterest['interest'];
$this->assign('benefit', $benefit);
//var_dump(get_personal_benefit($this->uid));
$this->assign('out', get_personal_out($this->uid));
$this->assign("bank", M('member_banks')->field('bank_num')->find($this->uid));
$info = getMemberDetail($this->uid);
$this->assign("info", $info);
$this->assign("kflist", get_admin_name());
$list = array();
$pre = C('DB_PREFIX');
$rule = M('ausers u')->field('u.id,u.qq,u.phone')->join("{$pre}members m ON m.customer_id=u.id")->where("u.is_kf =1 and m.customer_id={$minfo['customer_id']}")->select();
foreach ($rule as $key => $v) {
$list[$key]['qq'] = $v['qq'];
$list[$key]['phone'] = $v['phone'];
}
$this->assign("kfs", $list);
$_SX = M('investor_detail')->field('deadline,interest,capital')->where("investor_uid = {$this->uid} AND status=7")->order("deadline ASC")->find();
$lastInvest['gettime'] = $_SX['deadline'];
$lastInvest['interest'] = $_SX['interest'];
$lastInvest['capital'] = $_SX['capital'];
$this->assign("lastInvest", $lastInvest);
$_SX = "";
$_SX = M('investor_detail')->field('deadline,sum(interest) as interest,sum(capital) as capital')->where("borrow_uid = {$this->uid} AND status=7")->group("borrow_id,sort_order")->order("deadline ASC")->find();
$lastBorrow['gettime'] = $_SX['deadline'];
$lastBorrow['interest'] = $_SX['interest'];
$lastBorrow['capital'] = $_SX['capital'];
$this->assign("lastBorrow", $lastBorrow);
$map = array();
$map['uid'] = $this->uid;
$Log_list = getMoneyLog($map, 4);
$this->assign("Log_list", $Log_list['list']);
$this->assign("list", get_personal_count($this->uid));
//以下是我的投资详细
$zwmap['investor_uid'] = $this->uid;
$zwmap['status'] = 4;
$zwmap['Borrow.borrow_type'] = array('neq', 9);
$zwlist = getTenderList($zwmap, 1);
//显示真实姓名
if (is_array($zwlist['list'])) {
foreach ($zwlist['list'] as $zwkey => $zwval) {
$borrow_uid = $zwval['borrow_uid'];
$zwmap = " uid = {$borrow_uid} ";
$real_name = M("member_info")->field('real_name')->where($zwmap)->limit(1)->select();
$zwlist['list'][$zwkey]['real_name'] = $real_name[0]['real_name'];
unset($real_name);
}
}
//曲线走势图
$result = M("month_detail")->where("user_id=" . $this->uid)->find();
//去掉前三个
$res = array_slice($result, 3);
foreach ($res as $key => $value) {
$arr[] = $value;
}
if (max($arr) >= 10000) {
foreach ($arr as $key => $value) {
$brr[] = $value / 10000;
}
$this->char = "万元";
} else {
if (max($arr) >= 1000) {
foreach ($arr as $key => $value) {
$brr[] = $value / 1000;
}
$this->char = "千元";
} else {
if (max($arr) >= 100) {
foreach ($arr as $key => $value) {
$brr[] = $value / 100;
}
$this->char = "百元";
} else {
foreach ($arr as $key => $value) {
$brr[] = $value;
}
$this->char = "元";
}
}
}
if (count($brr) == 0) {
$brr = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
$this->char = "元";
}
$brr = json_encode($brr);
$this->arr = $brr;
//传输到前端
//日历数据 具体日期具体还款
$month = date('m');
$firstday = date('Y-' . $month . '-01 00:00:00');
$firstsec = strtotime(date('Y-' . $month . '-01 00:00:00'));
//零点零分零秒
$lastsec = strtotime(date('Y-m-d 23:59:59', strtotime($firstday . "+1 month -1 day")));
//要查询的月末
$investor_uid = $this->uid;
//借款编号 借款者id 应收本金 应收利息 利息管理费 标的状态 还款时间 逾期罚金 借款者真实姓名
$caldata = M('investor_detail as lid')->field('lid.capital,lid.interest,lid.interest_fee,lid.deadline,lid.expired_money')->join("LEFT JOIN lzh_member_info as lmi on lid.borrow_uid = lmi.uid")->where("lid.investor_uid=" . $investor_uid . " and lid.repayment_time = '0' and lid.deadline>" . $firstsec . " and lid.deadline<" . $lastsec)->order('lid.deadline')->select();
foreach ($caldata as $key => $value) {
$calender[] = array(date('md', $value['deadline']), $value['capital'] + $value['interest'] + $value['expired_money'] - $value['interest_fee']);
}
$temp = array();
foreach ($calender as $key => $value) {
$key = $value['0'];
$temp[$key] = isset($temp[$key]) ? $value['1'] + $temp[$key] : $value['1'];
}
foreach ($temp as $key => $value) {
//$result[] = array('date' => $key, 'money' => $value);
$result[] = array($key => $value);
}
$res = array_slice($result, 15);
foreach ($res as $key => $value) {
foreach ($value as $k => $v) {
$ali[] = $k . '&' . $v;
}
}
$this->ali = json_encode($ali);
//最新日历数据遍历
// echo "<pre/>";var_dump($ali);
//日历结束
//推荐项目
//正在进行的贷款
$searchMap = array();
$searchMap['Borrow.borrow_status'] = array("eq", '2');
$searchMap['Borrow.is_tuijian'] = array("in", '0,1');
$searchMap['Borrow.borrow_type'] = array("neq", 9);
$searchMap['Borrow.is_new'] = array("eq", 0);
$listBorrow = getBorrowList($searchMap, 3);
$this->listBorrow = $listBorrow;
$this->assign("list", $zwlist['list']);
$this->assign("pagebar", $zwlist['page']);
$this->assign('uid', $this->uid);
//我的投资结束
$this->display();
}
public function index()
{
$per = C('DB_PREFIX');
//公司动态
$parm = array();
$parm['type_id'] = 321;
$parm['limit'] = 5;
$parm['need_content'] = true;
$this->assign("noticeList", getArticleList($parm));
/*//行业动态
/*$parm['type_id'] = 398;
$parm['limit'] = 1;
$parm['need_content'] = true;
$this->assign("buzList",getArticleList($parm));*/
//公司动态
$parm['type_id'] = 396;
$parm['limit'] = 5;
$parm['need_content'] = true;
$this->assign("gsdtList", getArticleList($parm));
//行业新闻
/*//粤商动态
$parm['type_id'] = 396;
$parm['limit'] = 17;
$parm['need_content'] = true;
$this->assign("trendList",getArticleList($parm));
//粤商动态*/
/*//最新功能
$parm = array();
$parm['type_id'] = 395;
$parm['limit'] = 8;
$this->assign("newestFunctionList",getArticleList($parm));
//最新功能*/
//常见问题
$parm = array();
$parm['type_id'] = 392;
$parm['limit'] = 6;
$this->assign("questionList", getArticleList($parm));
//常见问题
//首页动态图片新闻
$this->assign("picnew", M("article")->where("is_homepicnews=1 and type_id=396")->order("id desc")->find());
//首页动态图片新闻
//首页行业图片新闻
$this->assign("buzpicnew", M("article")->where("is_homepicnews=1 and type_id=338")->order("id desc")->find());
//首页行业图片新闻
//成功的借款
$parm = array();
$searchMap = array();
$searchMap['b.borrow_status'] = array("in", '6,7');
$parm['map'] = $searchMap;
$parm['limit'] = 3;
$parm['orderby'] = "b.id DESC";
$successBorrow = getBorrowList($parm);
$this->assign("successBorrow", $successBorrow);
//成功的借款
//逾期的借款
$parm = array();
$searchMap = array();
$searchMap['borrow_status'] = 8;
$parm['map'] = $searchMap;
$parm['limit'] = 3;
$parm['orderby'] = "b.id DESC";
$breakBorrow = getBorrowList($parm);
$this->assign("breakBorrow", $breakBorrow);
//逾期的借款
//正在进行的贷款
$searchMap = array();
$searchMap['borrow_status'] = array("in", '2,4,6,7');
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
$parm = array();
date_default_timezone_set('Asia/Shanghai');
$ntime = date('Y-m-d H:i:s');
$searchMap['schedular_time'] = array("LT", $ntime);
$parm['map'] = $searchMap;
$parm['limit'] = 5;
$parm['orderby'] = "b.borrow_status ASC,b.id DESC";
$listBorrow = getBorrowList($parm);
$this->assign("Bconfig", $Bconfig);
$this->assign("listBorrow", $listBorrow);
//正在进行的贷款
//可投标的借款
$searchMap = array();
$searchMap['borrow_status'] = array("in", '2');
$parm = array();
$parm['map'] = $searchMap;
$this->assign("doingnum", getBorrowList($parm, true));
//可投标的借款
//最热借款
$searchMap = array();
$searchMap['borrow_status'] = array("in", '6,7,8,9');
$searchMap['full_time'] = array("gt", 0);
$parm = array();
$parm['map'] = $searchMap;
$parm['limit'] = 10;
$parm['hotest'] = true;
$parm['orderby'] = "IFNULL(b.`full_time`,0)-IFNULL(bv.`deal_time`,0) ASC";
$listBorrowHotest = getBorrowList($parm);
$this->assign("listBorrowHotest", $listBorrowHotest);
//最热借款
//推荐的贷款
$searchMap = array();
$searchMap['borrow_status'] = array("in", '2,4,6,7');
$searchMap['is_tuijian'] = 1;
//$searchMap['collect_time']=array('gt',time());
$parm = array();
$parm['map'] = $searchMap;
$parm['limit'] = 1;
$parm['orderby'] = "b.id DESC";
$listBorrowtj = getBorrowList($parm);
$this->assign("listBorrow_tj", $listBorrowtj);
//推荐的贷款
$this->assign("mcount", M("members")->count("id"));
$this->assign("mborrowOut", M("borrow_info")->where("borrow_status in(6,7,8,9)")->sum("borrow_money"));
$this->assign("mborrowOutNum", M("borrow_info")->where("borrow_status in(6,7,8,9)")->count("id"));
//地区文章列表
$artList = getAreaTypeList(array("limit" => 7, "area_id" => $this->siteInfo['id'], 'type_id' => 0));
$this->assign("newlist", $artList);
//地区文章列表
if ($this->uid) {
$this->assign("m_minfo", M('members')->field('credits')->find($this->uid));
$this->assign("unread", $read = M("inner_msg")->where("uid={$this->uid} AND status=0")->count('id'));
}
//近期投资
$this->assign("recentList", getRecentList(10));
//近期还款
$nearlyStartTime = strtotime("-3 days");
$nearlyStartDate = date('Y-m-d', $nearlyStartTime);
$nearlyEndTime = strtotime("{$nearlyStartDate} 1 month -1 day");
$map = array();
$map['d.status'] = array("neq", 0);
$map['d.deadline'] = array("between", $nearlyStartTime . ',' . $nearlyEndTime);
$nearlylist = getTenderList($map, null, 10, 'd.deadline asc');
$this->assign("recentPayList", $nearlylist['list']);
//////////////////////////排行榜//////////////////
$map = array();
$start = strtotime(date("Y-m-d", time()) . " 00:00:00");
$end = strtotime(date("Y-m-d", time()) . " 23:59:59");
$map['add_time'] = array("between", "{$start},{$end}");
$listPmday = getranklist($map, 10);
$this->assign("pmDay", $listPmday);
$map = array();
$start = strtotime("-7 day", strtotime(date("Y-m-d", time()) . " 00:00:00"));
//strtotime(date("Y-m-d",time())." 00:00:00");
$end = strtotime(date("Y-m-d", time()) . " 23:59:59");
$map['add_time'] = array("between", "{$start},{$end}");
$listPmweek = getranklist($map, 10);
$this->assign("pmWeek", $listPmweek);
$map = array();
$xdat = explode("|", $this->glo['rankDate']);
$start = strtotime($xdat[0] . " 00:00:00");
$end = strtotime($xdat[1] . " 23:59:59");
$map['add_time'] = array("between", "{$start},{$end}");
$listPmMonth = getranklist($map, 10);
$this->assign("pmMonth", $listPmMonth);
//资金统计
$map = array();
$list = M("member_moneylog")->field('type,sum(affect_money) as money')->where($map)->group('type')->select();
$row = array();
$name = C('MONEY_LOG');
foreach ($list as $v) {
$row[$v['type']]['money'] = $v['money'] > 0 ? $v['money'] : $v['money'] * -1;
$row[$v['type']]['name'] = $name[$v['type']];
}
$this->assign('staticslist', $row);
//理财产品
//$financial_arr = getFinancialData();
//$this->assign('financial_arr',$financial_arr);
////////////////////////////////////////////
$this->display();
/****************************募集期内标未满,自动流标 新增 2013-03-13****************************/
//流标返回
$mapT = array();
$mapT['collect_time'] = array("lt", time());
$mapT['borrow_status'] = 2;
$tlist = M("borrow_info")->field("id,borrow_uid,borrow_type,borrow_money,first_verify_time,borrow_interest_rate,borrow_duration,repayment_type,collect_day,collect_time")->where($mapT)->select();
if (empty($tlist)) {
exit;
}
foreach ($tlist as $key => $vbx) {
$borrow_id = $vbx['id'];
//流标
$done = false;
$borrowInvestor = D('borrow_investor');
$binfo = M("borrow_info")->field("borrow_type,borrow_money,borrow_uid,borrow_duration,repayment_type")->find($borrow_id);
$investorList = $borrowInvestor->field('id,investor_uid,investor_capital')->where("borrow_id={$borrow_id}")->select();
M('investor_detail')->where("borrow_id={$borrow_id}")->delete();
if ($binfo['borrow_type'] == 1) {
$limit_credit = memberLimitLog($binfo['borrow_uid'], 12, $binfo['borrow_money'], $info = "{$binfo['id']}号标流标");
}
//返回额度
$borrowInvestor->startTrans();
$bstatus = $type = 3;
$upborrow_info = M('borrow_info')->where("id={$borrow_id}")->setField("borrow_status", $bstatus);
//处理借款概要
$buname = M('members')->getFieldById($binfo['borrow_uid'], 'user_name');
//处理借款概要
if (is_array($investorList)) {
$upsummary_res = M('borrow_investor')->where("borrow_id={$borrow_id}")->setField("status", $type);
foreach ($investorList as $v) {
MTip('chk15', $v['investor_uid'], $borrow_id);
//sss
$accountMoney_investor = M("member_money")->field(true)->find($v['investor_uid']);
$datamoney_x['uid'] = $v['investor_uid'];
$datamoney_x['type'] = 8;
$datamoney_x['affect_money'] = $v['investor_capital'];
$datamoney_x['account_money'] = $accountMoney_investor['account_money'] + $datamoney_x['affect_money'];
$datamoney_x['collect_money'] = $accountMoney_investor['money_collect'];
$datamoney_x['freeze_money'] = $accountMoney_investor['money_freeze'] - $datamoney_x['affect_money'];
//会员帐户
$mmoney_x['money_freeze'] = $datamoney_x['freeze_money'];
$mmoney_x['money_collect'] = $datamoney_x['collect_money'];
$mmoney_x['account_money'] = $datamoney_x['account_money'];
//会员帐户
$_xstr = "募集期内标未满,流标";
$datamoney_x['info'] = "第{$borrow_id}号标" . $_xstr . "，返回冻结资金";
$datamoney_x['add_time'] = time();
$datamoney_x['add_ip'] = get_client_ip();
$datamoney_x['target_uid'] = $binfo['borrow_uid'];
$datamoney_x['target_uname'] = $buname;
$moneynewid_x = M('member_moneylog')->add($datamoney_x);
if ($moneynewid_x) {
$bxid = M('member_money')->where("uid={$datamoney_x['uid']}")->save($mmoney_x);
}
}
} else {
$moneynewid_x = true;
$bxid = true;
$upsummary_res = true;
}
if ($moneynewid_x && $upsummary_res && $bxid && $upborrow_info) {
$done = true;
$borrowInvestor->commit();
} else {
$borrowInvestor->rollback();
}
if (!$done) {
continue;
}
MTip('chk11', $vbx['borrow_uid'], $borrow_id);
$verify_info['borrow_id'] = $borrow_id;
$verify_info['deal_info_2'] = text($_POST['deal_info_2']);
$verify_info['deal_user_2'] = 0;
$verify_info['deal_time_2'] = time();
$verify_info['deal_status_2'] = 3;
if ($vbx['first_verify_time'] > 0) {
M('borrow_verify')->save($verify_info);
} else {
M('borrow_verify')->add($verify_info);
}
$vss = M("members")->field("user_phone,user_name")->where("id = {$vbx['borrow_uid']}")->find();
SMStip("refuse", $vss['user_phone'], array("#USERANEM#", "ID"), array($vss['user_name'], $verify_info['borrow_id']), $verify_info['borrow_id'], array($vbx['borrow_uid']));
//@SMStip("refuse",$vss['user_phone'],array("#USERANEM#","ID"),array($vss['user_name'],$verify_info['borrow_id']));
//updateBinfo
$newBinfo = array();
$newBinfo['id'] = $borrow_id;
$newBinfo['borrow_status'] = 3;
$newBinfo['second_verify_time'] = time();
$x = M("borrow_info")->save($newBinfo);
}
/****************************募集期内标未满,自动流标 新增 2013-03-13****************************/
}
public function ajaxindex()
{
$parm['map'] = $this->getsearch();
$parm['pagesize'] = 5;
$parm['orderby'] = "b.borrow_status ASC,b.id DESC";
$list = getBorrowList($parm);
foreach ($list['list'] as &$v) {
$v['borrow_name'] = msubstr($v['borrow_name'], 0, 18);
}
$result = array('list' => $list['list'], 'pagenum' => $list['count'] ? ceil($list['count'] / $parm['pagesize']) : 1);
$this->ajaxReturn($result, 'JSON');
}
public function index()
{
session('invitation_code', $_GET['i']);
$per = C('DB_PREFIX');
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
//网站公告
$parm['type_id'] = 43;
$parm['limit'] = 7;
$this->assign("noticeList", getArticleList($parm));
unset($parm);
//网站公告
//新闻
$parm['type_id'] = 2;
$parm['limit'] = 6;
$this->assign("newsList", getArticleList($parm));
unset($parm);
//新闻
///////////////散标列表开始//////////////
$searchMap = array();
$searchMap['b.borrow_status'] = array("in", '2,4,6,7');
$searchMap['b.is_tuijian'] = array("in", '0,1');
$parm = array();
$parm['map'] = $searchMap;
$parm['limit'] = 5;
$parm['orderby'] = "b.borrow_status ASC,b.id DESC";
$listBorrow = getBorrowList($parm);
$this->assign("listBorrow", $listBorrow);
///////////////散标列表结束//////////////
///////////////累计会员人数////////////
$members = M('members')->count();
$this->assign("members", $members);
//会员总数
///////////////累计会员人数////////////
///////////////累计配资人数////////////
//$member_num = M("members")->count();
//$this->assign("member_num",$member_num);
///////////////累计配资人数////////////
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
$this->assign("Bconfig", $Bconfig);
//////天天盈//////////////
$searchMap = array();
$searchMap['b.borrow_status'] = array("in", '2,4,6,7');
$searchMap['b.stock_type'] = array("in", '1,2,3,4');
//$searchMap['b.is_tuijian']=array("in",'0,1');
$parm = array();
$parm['map'] = $searchMap;
$parm['limit'] = 5;
$parm['orderby'] = "b.borrow_status asc ,b.first_verify_time desc";
$dayslists = getBorrowList($parm);
$this->assign("dayslists", $dayslists);
$progress = '';
if ($dayslists['list']) {
foreach ($dayslists['list'] as $val) {
$progress[] = (int) $val['progress'];
}
}
$this->assign('progress', $progress ? json_encode($progress) : '');
/**
//月月盈
$searchMap1 = array();
$searchMap1['b.borrow_status']=array("in",'2,4,6,7');
$searchMap1['b.stock_type']=array("eq",'2');
//$searchMap['b.is_tuijian']=array("in",'0,1');
$parm1=array();
$parm1['map'] = $searchMap1;
$parm1['limit'] =2;
$parm1['orderby']="b.borrow_status asc ,b.first_verify_time desc";
$monthlists = getBorrowList($parm1);
$this->assign("monthlists",$monthlists);
**/
///////////////累计配资金额////////////
$borrow_sum = M("borrow_info")->where(array('borrow_status' => array("in", '6,7,9,10')))->sum("borrow_money");
///////////////为客户赚取收益////////////
$investor_profit = M("borrow_info")->where(array('borrow_status' => array("in", '6,7,9,10')))->sum("borrow_interest");
$this->assign("investor_profit", $investor_profit);
///////////////为客户赚取收益////////////
$this->assign("borrow_sum", $borrow_sum);
///////////////累计配资金额////////////
///////////////配资盈利列表////////////
//$shares_list = M("shares_record r")->join("lzh_shares_apply a ON a.id = r.shares_id")->where("r.profit_loss > 0")->field("r.profit_loss,a.principal,a.shares_money,a.u_name")->order("r.add_time DESC")->limit(7)->select();
//$this->assign("shares_list",getRetRate($shares_list));
///////////////配资盈利列表////////////
///媒体报道
$mediaslist = M("media")->where(" is_show = 1 ")->order(" link_order desc ")->limit(14)->select();
$this->assign("mediaslist", $mediaslist);
///////////////配资列表////////////
//$shares_apply = M("shares_apply")->where("status in(2,3,6)")->field("u_name,shares_money,examine_time")->order("examine_time DESC")->limit(20)->select();
//echo M()->getLastSql();exit;
//$this->assign("shares_apply",$shares_apply);
///////////////配资列表////////////
///////////////企业直投列表开始 fan 2013-10-21//////////////
$parm = array();
$searchMap = array();
$searchMap['b.is_show'] = array('in', '0,1');
$searchMap['b.borrow_status'] = array('neq', '3');
$parm['map'] = $searchMap;
$parm['limit'] = 3;
$parm['orderby'] = "b.is_tuijian desc,b.is_show desc,b.progress asc";
$listTBorrow = getTBorrowList($parm);
$this->assign("listTBorrow", $listTBorrow);
///////////////企业直投列表结束 fan 2013-10-21//////////////
if (ListMobile()) {
if ($this->uid && M('members')->where('id=' . $this->uid . ' and ent=1')->count()) {
$redbag = M('redbag')->order('id desc')->where('status=1')->find();
//判断活动是否存在
$rid = $redbag['id'];
if ($rid) {
$usered = M('redbag_list')->where('uid=' . $this->uid . ' and pid=' . $rid)->count();
//判断是否领过红包
if (!$usered) {
$redinfo = M('redbag_list')->order('id asc')->where('uid=0 and pid=' . $rid . ' and status=1')->find();
//判断是否还有剩余红包
if ($redinfo) {
$this->assign('isredbag', true);
}
}
}
}
}
//if($_GET['debug']){
$this->display();
//}else{
// $this->display('indexv');
//}
exit;
/****************************募集期内标未满,自动流标 新增 2013-03-13*************************\***/
//流标返回
$mapT = array();
$mapT['collect_time'] = array("lt", time());
$mapT['borrow_status'] = 2;
$tlist = M("borrow_info")->field("id,borrow_uid,borrow_type,borrow_money,first_verify_time,borrow_interest_rate,borrow_duration,repayment_type,collect_day,collect_time")->where($mapT)->select();
if (empty($tlist)) {
exit;
}
foreach ($tlist as $key => $vbx) {
$borrow_id = $vbx['id'];
//流标
$done = false;
$borrowInvestor = D('borrow_investor');
$binfo = M("borrow_info")->field("borrow_type,borrow_money,borrow_uid,borrow_duration,repayment_type")->find($borrow_id);
$investorList = $borrowInvestor->field('id,investor_uid,investor_capital')->where("borrow_id={$borrow_id}")->select();
M('investor_detail')->where("borrow_id={$borrow_id}")->delete();
if ($binfo['borrow_type'] == 1) {
$limit_credit = memberLimitLog($binfo['borrow_uid'], 12, $binfo['borrow_money'], $info = "{$binfo['id']}号标流标");
}
//返回额度
$borrowInvestor->startTrans();
$bstatus = 3;
$upborrow_info = M('borrow_info')->where("id={$borrow_id}")->setField("borrow_status", $bstatus);
//处理借款概要
$buname = M('members')->getFieldById($binfo['borrow_uid'], 'user_name');
//处理借款概要
if (is_array($investorList)) {
$upsummary_res = M('borrow_investor')->where("borrow_id={$borrow_id}")->setField("status", $type);
foreach ($investorList as $v) {
MTip('chk15', $v['investor_uid']);
//sss
$accountMoney_investor = M("member_money")->field(true)->find($v['investor_uid']);
$datamoney_x['uid'] = $v['investor_uid'];
$datamoney_x['type'] = $type == 3 ? 16 : 8;
$datamoney_x['affect_money'] = $v['investor_capital'];
$datamoney_x['account_money'] = $accountMoney_investor['account_money'] + $datamoney_x['affect_money'];
//投标不成功返回充值资金池
$datamoney_x['collect_money'] = $accountMoney_investor['money_collect'];
$datamoney_x['freeze_money'] = $accountMoney_investor['money_freeze'] - $datamoney_x['affect_money'];
$datamoney_x['back_money'] = $accountMoney_investor['back_money'];
//会员帐户
$mmoney_x['money_freeze'] = $datamoney_x['freeze_money'];
$mmoney_x['money_collect'] = $datamoney_x['collect_money'];
$mmoney_x['account_money'] = $datamoney_x['account_money'];
$mmoney_x['back_money'] = $datamoney_x['back_money'];
//会员帐户
$_xstr = $type == 3 ? "复审未通过" : "募集期内标未满,流标";
$datamoney_x['info'] = "第{$borrow_id}号标" . $_xstr . "，返回冻结资金";
$datamoney_x['add_time'] = time();
$datamoney_x['add_ip'] = get_client_ip();
$datamoney_x['target_uid'] = $binfo['borrow_uid'];
$datamoney_x['target_uname'] = $buname;
$moneynewid_x = M('member_moneylog')->add($datamoney_x);
if ($moneynewid_x) {
$bxid = M('member_money')->where("uid={$datamoney_x['uid']}")->save($mmoney_x);
}
}
} else {
$moneynewid_x = true;
$bxid = true;
$upsummary_res = true;
}
if ($moneynewid_x && $upsummary_res && $bxid && $upborrow_info) {
$done = true;
$borrowInvestor->commit();
} else {
$borrowInvestor->rollback();
}
if (!$done) {
continue;
}
MTip('chk11', $vbx['borrow_uid'], $borrow_id);
$verify_info['borrow_id'] = $borrow_id;
$verify_info['deal_info_2'] = text($_POST['deal_info_2']);
$verify_info['deal_user_2'] = 0;
$verify_info['deal_time_2'] = time();
$verify_info['deal_status_2'] = 3;
if ($vbx['first_verify_time'] > 0) {
M('borrow_verify')->save($verify_info);
} else {
M('borrow_verify')->add($verify_info);
}
$vss = M("members")->field("user_phone,user_name")->where("id = {$vbx['borrow_uid']}")->find();
SMStip("refuse", $vss['user_phone'], array("#USERANEM#", "ID"), array($vss['user_name'], $verify_info['borrow_id']));
//@SMStip("refuse",$vss['user_phone'],array("#USERANEM#","ID"),array($vss['user_name'],$verify_info['borrow_id']));
//updateBinfo
$newBinfo = array();
$newBinfo['id'] = $borrow_id;
$newBinfo['borrow_status'] = 3;
$newBinfo['second_verify_time'] = time();
$x = M("borrow_info")->save($newBinfo);
}
/****************************募集期内标未满,自动流标 新增 2013-03-13****************************/
}
public function index_bak()
{
$jsoncode = file_get_contents("php://input");
$arr = array();
$arr = json_decode($jsoncode, true);
// $datag = get_global_setting();
// $newversion = $datag['apkversion'];
// if(is_array($arr)&&(!empty($arr))&&(!empty($arr['version']))&&((int)$arr['version'])<$newversion){
// $m_list['upversion'] = 1;
// $m_list['path'] = $datag['apkpath'];
// }else{
// $m_list['upversion'] = 0;
// }
//alogsm("Main",0,1,$jsoncode);
$per = C('DB_PREFIX');
//print_r($arr);die();
//普通标翻页
if (is_array($arr) && isset($arr['id']) && isset($arr['type']) && isset($arr['num'])) {
$type = $arr['type'];
$id = intval($arr['id']);
$num = intval($arr['num']);
} else {
$type = 2;
$num = 5;
}
//企业标翻页
if (is_array($arr) && isset($arr['tid']) && isset($arr['ttype']) && isset($arr['tnum'])) {
$ttype = $arr['ttype'];
$tid = intval($arr['tid']);
$tnum = intval($arr['tnum']);
} else {
$ttype = 2;
$tnum = 5;
}
//普通标
if ($type == 1) {
$searchMap['borrow_status'] = array("in", '2,4,6,7');
$searchMap['b.borrow_type'] = array("neq", "9");
$searchMap['b.id'] = array("gt", $id);
$parm['map'] = $searchMap;
$parm['limit'] = $num;
$parm['orderby'] = "b.borrow_status ASC,b.id asc";
} elseif ($type == 0) {
$searchMap['borrow_status'] = array("in", '2,4,6,7');
$searchMap['b.borrow_type'] = array("neq", "9");
$searchMap['b.id'] = array("lt", $id);
$parm['map'] = $searchMap;
$parm['limit'] = $num;
$parm['orderby'] = "b.borrow_status ASC,b.id DESC";
} else {
$searchMap['borrow_status'] = array("in", '2,4,6,7');
$searchMap['b.borrow_type'] = array("neq", "9");
$parm['map'] = $searchMap;
$parm['limit'] = $num;
$parm['orderby'] = "b.borrow_status ASC,b.id DESC";
}
//$searchMap['borrow_status']=array("in",'2,4,6,7');
//$parm['map'] = $searchMap;
//$parm['limit'] = 10;
//$parm['orderby']="b.borrow_status ASC,b.id DESC";
$list = getBorrowList($parm);
//$_list = $list;
foreach ($list['list'] as $key => $v) {
$_list[$key]['uid'] = intval($v['uid']);
$_list[$key]['type'] = getleixing($v);
$_list[$key]['id'] = intval($v['id']);
$_list[$key]['borrow_name'] = $v['borrow_name'];
$_list[$key]['borrow_interest_rate'] = $v['borrow_interest_rate'];
if ($v['repayment_type'] == 1) {
$_list[$key]['borrow_duration'] = $v['borrow_duration'] . "天";
} else {
$_list[$key]['borrow_duration'] = $v['borrow_duration'] . "个月";
}
$_list[$key]['repayment_type'] = $v['repayment_type'];
$_list[$key]['borrow_money'] = $v['borrow_money'];
$_list[$key]['progress'] = $v['progress'];
$_list[$key]['credits'] = $v['credits'];
$_list[$key]['user_name'] = $v['user_name'];
$_list[$key]['imgpath'] = get_avatar(intval($v['uid']));
$_list[$key]['suo'] = empty($v['password']) ? 0 : 1;
//是否定向标
if ($v['reward_type'] == 1) {
$_list[$key]['reward'] = $v['reward_num'] . "%";
} elseif ($v['reward_type'] == 2) {
$_list[$key]['reward'] = $v['reward_num'] . "元";
} else {
$_list[$key]['reward'] = "0";
}
}
$m_list['list'] = $_list;
//企业直投
$parmt = array();
if ($ttype == 1) {
$searchMapt['bi.borrow_status'] = array("in", "2,4,6,7");
$searchMapt['bi.borrow_type'] = 9;
$parmt['map'] = $searchMapt;
$parmt['limit'] = $tnum;
$parmt['orderby'] = "bi.borrow_status ASC,bi.id DESC,bi.add_time DESC";
} elseif ($ttype == 0) {
$searchMapt['bi.borrow_status'] = array("in", "2,4,6,7");
$searchMapt['bi.borrow_type'] = 9;
$parmt['map'] = $searchMapt;
$parmt['limit'] = $tnum;
$parmt['orderby'] = "bi.borrow_status ASC,bi.id DESC,bi.add_time DESC";
} else {
$searchMapt['bi.borrow_status'] = array("in", "2,4,6,7");
$searchMapt['bi.borrow_type'] = 9;
$parmt['map'] = $searchMapt;
$parmt['limit'] = $tnum;
$parmt['orderby'] = "bi.borrow_status ASC,bi.id DESC,bi.add_time DESC";
}
//$searchMapt['bi.borrow_type'] = 9;
//$searchMap['borrow_status']=2;
//$searchMapt['is_show'] = array('in','0,1');
//$searchMapt['bi.borrow_status']=array("in","2,4,6,7");
// $searchMap['b.borrow_status']=0;
// $searchMap['deadline']=strtotime("deadline");
// $search['bi.borrow_status']=array("in","2,4,6,7");
//$searchMap['b.borrow_type'] =9;
//$parmt['map'] = $searchMapt;
//$parmt['limit'] = 10;
//$parmt['orderby'] = "b.is_show desc,b.id DESC";
// $parm['orderby']="bi.borrow_status ASC,bi.id DESC,bi.add_time DESC";
$tlist = getTBorrowList($parmt);
foreach ($tlist['list'] as $key => $v) {
// $_tlist[$key]['uid'] = intval($v['uid']);
// $_tlist[$key]['type'] = 2;
// $_tlist[$key]['id'] = intval($v['id']);
// $_tlist[$key]['borrow_name'] = $v['borrow_name'];
// $_tlist[$key]['borrow_interest_rate'] = $v['borrow_interest_rate'];
// $_tlist[$key]['borrow_duration'] = $v['borrow_duration']."个月";
// $_tlist[$key]['per_transfer'] = $v['per_transfer'];
// $_tlist[$key]['borrow_money'] =$v['borrow_money'];
// $_tlist[$key]['progress'] =$v['progress'];
// $_tlist[$key]['credits'] =$v['credits'];
// $_tlist[$key]['user_name'] =$v['user_name'];
// $_tlist[$key]['imgpath'] =get_avatar(intval($v['uid']));
// $_tlist[$key]['reward'] = $v['reward_rate']."%";
$_tlist[$key]['uid'] = intval($v['uid']);
$_tlist[$key]['type'] = 2;
$_tlist[$key]['id'] = intval($v['id']);
$_tlist[$key]['borrow_name'] = $v['borrow_name'];
$_tlist[$key]['borrow_interest_rate'] = $v['borrow_interest_rate'];
if ($v['repayment_type'] == 1) {
$_tlist[$key]['borrow_duration'] = $v['borrow_duration'] . "天";
} else {
$_tlist[$key]['borrow_duration'] = $v['borrow_duration'] . "个月";
}
$_tlist[$key]['repayment_type'] = $v['repayment_type'];
$_tlist[$key]['borrow_money'] = $v['borrow_money'];
$_tlist[$key]['progress'] = $v['progress'];
$_tlist[$key]['credits'] = $v['credits'];
$_tlist[$key]['user_name'] = $v['user_name'];
$_tlist[$key]['imgpath'] = get_avatar(intval($v['uid']));
$_tlist[$key]['suo'] = empty($v['password']) ? 0 : 1;
//是否定向标
if ($v['reward_type'] == 1) {
$_tlist[$key]['reward'] = $v['reward_num'] . "%";
} elseif ($v['reward_type'] == 2) {
$_tlist[$key]['reward'] = $v['reward_num'] . "元";
} else {
$_tlist[$key]['reward'] = "0";
}
}
//$m_list['tlist']= $_tlist;
//////////////////////////////////////////////债券转让//////////////////////////////////////////////////
// $search1 = array();
// $search1['b.borrow_status']=array("in","2,4,6,7");
// $parm1['map'] = $search1;
// D("DebtBehavior");
// $Debt = new DebtBehavior();
// $dlist = $Debt->listAll($parm1);
// foreach($dlist['data'] as $key =>$v){
// $_dlist[$key]['uid'] = intval($v['uid']);
// $_dlist[$key]['type'] = 9;
// $_dlist[$key]['id'] = intval($v['id']);
// $_dlist[$key]['borrow_name'] = $v['borrow_name'];
// $_dlist[$key]['credits'] =$v['credits'];
// $_dlist[$key]['borrow_interest_rate'] = $v['borrow_interest_rate']."%";
// $_dlist[$key]['transfer_price'] = $v['transfer_price'];
// $_dlist[$key]['money'] =$v['money'];
// $_dlist[$key]['period'] =$v['period'];
// $_dlist[$key]['total_period'] =$v['total_period'];
// $_dlist[$key]['status'] = $v['status'];
// }
// $m_list['dlist']= $_dlist;
echo ajaxmsg($m_list);
//$this->assign("Sorder",$Sorder);
// $this->assign("searchMap",$maprow);
// $this->assign("Bconfig",$Bconfig);
// $this->assign("mainlist",$list);
//$this->display();
}
public function index()
{
static $newpars;
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
$per = C('DB_PREFIX');
//$vminfo = M('members')->field("user_leve,time_limit")->find($this->uid);
$vminfo = M('members')->field("user_leve,time_limit")->find($this->uid);
$mstatus = M('members_status')->field(true)->find($this->uid);
if (!($vminfo['user_leve'] > 0 && $vminfo['time_limit'] > time())) {
$this->error("请先通过VIP审核再投资", __APP__ . "/member/vip");
//return;
}
if ($mstatus['phone_status'] != 1) {
$this->error("请先通过手机认证!", __APP__ . "/member/verify#fragment-2");
//return;
}
//推荐的贷款
$searchMap = array();
$searchMap['borrow_status'] = array("in", '2,4,6,7');
$searchMap['is_tuijian'] = 1;
$parm = array();
$parm['map'] = $searchMap;
$parm['limit'] = 1;
$parm['orderby'] = "b.id DESC";
$listBorrowtj = getBorrowList($parm);
$this->assign("listBorrow_tj", $listBorrowtj);
//推荐的贷款
//可投标的借款
$searchMap = array();
$searchMap['borrow_status'] = array("in", '2');
$parm = array();
$parm['map'] = $searchMap;
$this->assign("doingnum", getBorrowList($parm, true));
//可投标的借款
$urlArr = array('borrow_name', 'borrow_status', 'repayment_type', 'borrow_use', 'money', 'borrow_duration', 'is_reward', 'province', 'city', 'area');
$maprow = array();
$searchMap = array();
foreach ($urlArr as $vs) {
$maprow[$vs] = textPost($_POST[$vs]);
}
$maprow["borrow_status"] = $_GET["_URL_"][3];
//searchMap
if (in_array($maprow['borrow_status'], array(2, 3, 4, 6, 7, 8, 9))) {
if ($maprow['borrow_status'] == 9) {
$searchMap['borrow_status'] = array("in", '2,4,6,7');
} else {
$searchMap['borrow_status'] = $maprow['borrow_status'];
}
} else {
$searchMap['borrow_status'] = array("in", '2,4');
}
if (!empty($maprow['borrow_name'])) {
$searchMap['b.borrow_name'] = array("like", "%{$maprow['borrow_name']}%");
}
if (!empty($maprow['repayment_type'])) {
$searchMap['b.repayment_type'] = array("in", array_map(intval, $maprow['repayment_type']));
}
if (!empty($maprow['borrow_use'])) {
$searchMap['b.borrow_use'] = array("in", array_map(intval, $maprow['borrow_use']));
}
if (!empty($maprow['money'])) {
$moneyarr = explode("-", $maprow['money']);
if (count($moneyarr) > 0) {
if (!empty($moneyarr[1])) {
$searchMap['b.borrow_money'] = array("between", array_map(intval, $moneyarr));
} else {
$searchMap['b.borrow_money'] = array("egt", intval($moneyarr[0]));
}
}
}
if (!empty($maprow['borrow_duration'])) {
$searchMap['b.borrow_duration'] = intval($maprow['borrow_duration']);
}
if (!empty($maprow['is_reward'])) {
$searchMap['b.reward_type'] = array("in", array_map(intval, $maprow['is_reward']));
}
if (!empty($maprow['province'])) {
$searchMap['b.province'] = intval($maprow['province']);
}
if (!empty($maprow['city'])) {
$searchMap['b.city'] = intval($maprow['city']);
}
if (!empty($maprow['area'])) {
$searchMap['b.area'] = intval($maprow['area']);
}
//searchMap
//if(is_array($searchMap['borrow_status'])) $searchMap['collect_time']=array('gt',time());
if ($maprow['borrow_status'] == '') {
$searchMap['borrow_status'] = array("in", '2,4,6,7');
}
date_default_timezone_set('Asia/Shanghai');
$ntime = date('Y-m-d H:i:s');
$searchMap['schedular_time'] = array("LT", $ntime);
$parm['map'] = $searchMap;
$parm['pagesize'] = 12;
//排序
strtolower($_GET['sort']) == "asc" ? $sort = "desc" : ($sort = "asc");
unset($surl['orderby'], $surl['sort']);
$orderUrl = http_build_query($surl);
if ($_GET['orderby']) {
if (strtolower($_GET['orderby']) == "credits") {
$parm['orderby'] = "m.credits " . text($_GET['sort']);
} elseif (strtolower($_GET['orderby']) == "rate") {
$parm['orderby'] = "b.borrow_interest_rate " . text($_GET['sort']);
} elseif (strtolower($_GET['orderby']) == "borrow_money") {
$parm['orderby'] = "b.borrow_money " . text($_GET['sort']);
} else {
$parm['orderby'] = "b.id DESC";
}
} else {
$parm['orderby'] = "b.borrow_status ASC,b.id DESC";
}
$Sorder['Corderby'] = strtolower(text($_GET['orderby']));
$Sorder['Csort'] = strtolower(text($_GET['sort']));
$Sorder['url'] = $orderUrl;
$Sorder['sort'] = $sort;
$Sorder['orderby'] = text($_GET['orderby']);
//排序
$list = getBorrowList($parm);
$this->assign("Sorder", $Sorder);
$this->assign("searchMap", $maprow);
$this->assign("Bconfig", $Bconfig);
$this->assign("list", $list);
if ($maprow['borrow_status'] == 10) {
//逾期黑名单列表
$map = array();
//$map['_string'] = ' (d.repayment_time=0 AND d.deadline<'.time().' AND d.status=7) ';
$map['_string'] = ' (d.repayment_time=0 AND d.status=7) ';
//分页处理
import("ORG.Util.Page");
$xcount = M('investor_detail d')->field("d.id")->where($map)->group('d.borrow_uid')->buildSql();
$newxsql = M()->query("select count(*) as tc from {$xcount} as t");
$count = $newxsql[0]['tc'];
$p = new Page($count, C('ADMIN_PAGE_SIZE'));
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
//分页处理
$field = "count(*) as num,sum(d.capital) as capital_all,d.borrow_uid,d.status,d.total,d.borrow_id,sum(d.interest) as interest,sum(d.substitute_money) as substitute_money,d.deadline";
$buildSql = M('investor_detail d')->field($field)->where($map)->group('d.sort_order,d.borrow_id')->buildSql();
$list = M()->query("select m.user_name,m.credits,m.id as uid,info.real_name,info.sex,info.idcard,info.zy,m.user_email,m.user_phone,b.province,b.city,b.area,count(*) as tc,t.deadline,sum(t.capital_all) as total_expired,t.interest,t.borrow_uid as id,t.borrow_id from {$buildSql} as t left join lzh_members m ON m.id=t.borrow_uid left join lzh_member_info info ON m.id=info.uid left join lzh_borrow_info b ON b.id=t.borrow_id group by t.borrow_uid limit {$Lsql}");
$list = $this->_tendlist($list);
$this->assign("tendbreak", $list);
}
$this->assign("maprow", $maprow);
$this->display();
}
