public function jk()
{
$parm['pagesize'] = 15;
$parm['type_id'] = 255;
$list = getArticleList($parm);
$this->assign("list", $list['list']);
$this->assign("f_type", C('FEEDBACK_TYPE'));
$this->display();
}
public function index()
{
//网站公告
$parm['type_id'] = 1;
$parm['limit'] = 8;
$this->assign("noticeList", getArticleList($parm));
$per = C('DB_PREFIX');
$page_size = C('HOME_SHOP_PAGE_SIZE');
$Market = M('market_goods');
import("ORG.Util.Page");
$condition = "is_sys=1";
$count = $Market->where($condition)->count();
$Page = new Page($count, $page_size);
$show = $Page->show();
$list = M('market_goods')->where($condition)->order("order_sn DESC")->limit($Page->firstRow . ', ' . $Page->listRows)->select();
$list_log = M('market_log l')->field("l.*,m.user_name")->join("{$per}members m ON m.id=l.uid")->where("l.type=1")->order("l.price DESC")->limit(10)->select();
//dump($list_log);exit;
$this->assign("list", $list);
$this->assign("list_log", $list_log);
$this->assign('pagebar', $show);
$this->display();
}
public function news()
{
//热点跟踪
$parm['type_id'] = 35;
$parm['limit'] = 10;
$redian = getArticleList($parm);
//dump($redian);die;
$this->assign("redian", $redian);
//焦点
$parm['type_id'] = 36;
$parm['limit'] = 10;
$focus = getArticleList($parm);
$this->assign("focus", $focus);
//平台公告
$parm['type_id'] = 9;
$parm['limit'] = 10;
$this->assign("noticeList", getArticleList($parm));
//配资课堂
$parm['type_id'] = 38;
$parm['limit'] = 10;
$this->assign("classroom", getArticleList($parm));
$this->display();
}
public function index()
{
$parm['type_id'] = 2;
$parm['pagesize'] = 8;
$list = getArticleList($parm);
if ($this->isAjax()) {
$string = '';
foreach ($list['list'] as $vn) {
$string .= '<div class="new_list">
<a href="' . $vn['arturl'] . '">
<div class="new_right">
<h3>' . cnsubstr($vn['title'], 23) . '</h3>
<em>日期' . date("Y-m-d", $vn['art_time']) . '</em>
</div>
</a>
</div>';
}
echo $string;
} else {
$this->assign("noticeList", $list);
$this->display();
}
}
public function donate()
{
$per = C('DB_PREFIX');
//网站公告
$parmart['pagesize'] = 8;
$parmart['type_id'] = 182;
$listnotic = getArticleList($parmart);
//媒体报道
$media['pagesize'] = 8;
$media['type_id'] = 303;
$listmedia = getArticleList($media);
//论坛精华
$bbsbest['pagesize'] = 8;
$bbsbest['type_id'] = 184;
$listbbsbest = getArticleList($bbsbest);
//最新投标
$newinvest = M('borrow_investor i')->field("i.investor_capital,m.user_name")->join("{$per}members m ON m.id=i.investor_uid")->order('i.id DESC')->limit(20)->select();
$this->assign("newinvest", $newinvest);
//最新满标
$newsucc = M('borrow_info b')->field("b.borrow_money,m.user_name")->join("{$per}members m ON m.id=b.borrow_uid")->where("b.borrow_status=3")->order('i.id DESC')->limit(20)->select();
$this->assign("newsucc", $newsucc);
$this->assign("listnotic", $listnotic['list']);
$this->assign("listmedia", $listmedia['list']);
$this->assign("listbbsbest", $listbbsbest['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 invest_ad()
{
$invest = M("amount_top")->select();
//$ad = M('article')->limit(5)->select();
$parm['type_id'] = 37;
$parm['pagesize'] = '5';
$ad = getArticleList($parm);
$ad = $ad['list'];
//echo "<pre/>";var_dump($ad);
//$this->assign("noticeList",getArticleList($parm));
return array($invest, $ad);
}
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****************************/
}
<div class="m-t-10">
<p class="text-black">还款方式</p>
<p class="text-success"><?php echo ($Bconfig['REPAYMENT_TYPE'][$vb['repayment_type']]); ?></p>
</div>
</div>
</div>
</div></div><?php endforeach; endif; else: echo "" ;endif; ?>
</div>
<div class="pages badoo"><?php echo ($list["page"]); ?></div>
<!-- Left // -->
</div>
<?php $parm = array(); $parm['type_id'] = 392; $parm['limit'] = 6; $questionList = getArticleList($parm); $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'); $recentPayList = $nearlylist['list']; ?>
<div id="right">
<!-- Right -->
<div id="rb1">
<div id="rb1_upper">
<div id="rb1_upper_l"></div>
<div id="rb1_upper_r"><h3>诚 一站式金融服务平台</h3><p>低风险，收益率适中投资理财服务</p></div>
</div>
<div class="rb1_bo1">
<h4>诚信担保</h4>
<p>- 所有的投资项目均有第三方担保</p>
<p>- 100%本金和收益保障</p>
</div>
<div class="rb1_bo2">
<h4>轻松愉快的投资过程</h4>
?>
</a>
<span><?php
echo date("m-d", $va["art_time"]);
?>
</span>
</li><?php
}
}
} else {
echo "";
}
?>
<!-- </marquee> -->
<!-- <?php
$xlist = getArticleList(array("type_id" => 37, "pagesize" => 4));
foreach ($xlist['list'] as $kx => $va) {
?>
<li></a>
<span>{$va.art_time|date="m-d",###}</span></li>
<?php
}
$noticeList = NULL;
?>
-->
</ul>
</div>
</div>
</div>
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****************************/
}
$articleRightRank = addslashes(getArticleRightRank($cateid));
//精彩视频带图片
$articleRightVsPic = addslashes(getArticlePicList('11,88,12,91,92,18,85', 3, 10, 'hits', 'DESC', 80, 50, 0, 0, 3, 1, 0, 0, 1));
//精彩视频不带图片
$articleRightVsTxt = addslashes(getArticleList('11,88,12,91,92,18,85', 6, 20, 'hits', 'DESC', 0, 3, 1, 2, 0, 1));
//重点阅读1
$recommendTxtHot1 = addslashes(getArticleList(0, 1, 36, 'order', 'ASC', 1, 3, 0, 0, 0, 0, 0, 0, 0, 1));
//重点阅读2
$recommendTxtHot2 = addslashes(getArticleList(0, 2, 25, 'order', 'ASC', 1, 3, 0, 1, 0, 0, 0, 1, 0, 1));
//重点阅读图片
$recommendPic = addslashes(getArticlePicList(0, 3, 20, 'order', 'ASC', 80, 60, 0, 1, 3, 1, 0));
//重点阅读列表
// $recommendTxtList = addslashes(getArticleList($cateid, 11, 40, 'order', 'ASC', 1, 3, 1, 5, 0, 0,1 ));
$recommendTxtList = addslashes(getArticleList(0, 11, 40, 'order', 'ASC', 1, 3, 1, 5, 0, 0, 1, 0, 0, 1));
//最受关注
$articleTopList = addslashes(getArticleList(0, 2, 36, 'order', 'ASC', 2, 3, 1, 0, 1, 0, 0, 0, 0, 1));
//2009-8-14 20:40:31
$MyArticle = new Article();
$MyArticle->CateId = $cateid;
$MyArticle->Count = 100;
$MyArticle->TitleCount = 100;
$MyArticle->OrderBy = 'Order';
$MyArticle->OrderSort = 'ASC';
$MyArticle->LiClass = 'seli';
$MyArticle->LiClassId = $upid;
//当前栏目文章列表、标题
$articleList = $MyArticle->getArticleList();
$articleTitle = $MyArticle->getCateTitle();
$MyArticle->CateId = TOPURL;
$MyArticle->LiClass = '';
$MyArticle->Flag = 1;
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 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 tool2()
{
if ($_POST) {
// var_dump($_POST);exit();
$amount = round(floatval($_POST['amount']), 2);
//投资金额
$date_limit = intval($_POST['date_limit']);
//投资期限
$rate = floatval($_POST['rate']);
//投资利率
$reward_rate = floatval($_POST['reward_rate']);
//借款奖励
$invest_manage = floatval($_POST['invest_manage']);
//利息管理费
$rate_type = intval($_POST['rate_type']) == 2 ? 2 : 1;
//投资利率：1：年利率；2：日利率
$date_type = intval($_POST['date_type']) == 2 ? 2 : 1;
//投资类型：1：月；2：日
$repayment_type = intval($_POST['repayment_type']);
if ($repayment_type != 1 && $rate_type == 2) {
$rate = $rate * 365;
}
if ($repayment_type == 1 && $rate_type == 1) {
$rate = $rate / 365;
}
$repay_detail['reward_money'] = round($amount * $reward_rate / 100, 2);
$repay_detail['invest_money'] = $amount - $repay_detail['reward_money'];
switch ($repayment_type) {
case '1':
//按天到期还款
$repay_detail['repayment_money'] = round($amount * ($rate * $date_limit * (100 - $invest_manage) / 100 + 100) / 100, 2);
$repay_detail['interest'] = $repay_detail['repayment_money'] - $amount;
$repay_detail['day_apr'] = round(($repay_detail['repayment_money'] - $repay_detail['invest_money']) * 100 / ($repay_detail['invest_money'] * $date_limit), 2);
$repay_detail['year_apr'] = round($repay_detail['day_apr'] * 365, 2);
$repay_detail['month_apr'] = round($repay_detail['day_apr'] * 365 / 12, 2);
break;
case '4':
//到期还本息
$repay_detail['repayment_money'] = round($amount + $amount * ($date_limit * $rate / 12 / 100) * (100 - $invest_manage) / 100, 2);
$repay_detail['interest'] = $repay_detail['repayment_money'] - $amount;
$repay_detail['month_apr'] = round(($repay_detail['repayment_money'] - $repay_detail['invest_money']) * 100 / ($repay_detail['invest_money'] * $date_limit), 2);
$repay_detail['year_apr'] = round($repay_detail['month_apr'] * 12, 2);
$repay_detail['day_apr'] = round($repay_detail['month_apr'] * 12 / 365, 2);
break;
case '3':
//每月还息到期还本
$repay_detail['repayment_money'] = round($amount * ($rate * $date_limit * (100 - $invest_manage) / 100 / 12 + 100) / 100, 2);
$repay_detail['interest'] = $repay_detail['repayment_money'] - $amount;
$repay_detail['month_apr'] = round(($repay_detail['repayment_money'] - $repay_detail['invest_money']) * 100 / ($repay_detail['invest_money'] * $date_limit), 2);
$repay_detail['year_apr'] = round($repay_detail['month_apr'] * 12, 2);
$repay_detail['day_apr'] = round($repay_detail['month_apr'] * 12 / 365, 2);
$interest = round($amount * $rate * (100 - $invest_manage) / 100 / 12 / 100, 2);
//利息等于应还金额乘月利率
$repay = $repay_detail['repayment_money'];
for ($i = 0; $i < $date_limit; $i++) {
if ($i + 1 == $date_limit) {
$capital = $amount;
//本金只在最后一个月还，本金等于借款金额除季度
$repay = $interest + $capital;
} else {
$capital = 0;
$repay = $repay - $interest;
}
$_result[$i]['repayment_money'] = $interest + $capital;
$_result[$i]['interest'] = $interest;
$_result[$i]['capital'] = $capital;
$_result[$i]['last_money'] = $repay;
}
break;
case '5':
//先息后本
$repay_detail['interest'] = round($amount * ($rate / 12 / 100) * $date_limit * ((100 - $invest_manage) / 100), 2);
$repay_detail['invest_money'] -= $repay_detail['interest'];
$repay_detail['repayment_money'] = $amount;
$repay_detail['month_apr'] = round(($repay_detail['repayment_money'] - $repay_detail['invest_money']) * 100 / ($repay_detail['invest_money'] * $date_limit), 2);
$repay_detail['year_apr'] = round($repay_detail['month_apr'] * 12, 2);
$repay_detail['day_apr'] = round($repay_detail['month_apr'] * 12 / 365, 2);
break;
case '2':
//按月分期还款
//按月分期还款
default:
$month_apr = $rate / (12 * 100);
$_li = pow(1 + $month_apr, $date_limit);
$repayment = $_li != 1 ? round($amount * ($month_apr * $_li) / ($_li - 1), 2) : round($amount / $date_limit, 2);
$repay_detail['repayment_money'] = round(($repayment * $date_limit - $amount) * (100 - $invest_manage) / 100 + $amount, 2);
$repay_detail['interest'] = $repay_detail['repayment_money'] - $amount;
$repay = $repay_detail['repayment_money'];
for ($i = 0; $i < $date_limit; $i++) {
if ($i == 0) {
$interest = round($amount * $month_apr, 2);
} else {
$_lu = pow(1 + $month_apr, $i);
$interest = round(($amount * $month_apr - $repayment) * $_lu + $repayment, 2);
}
$fee = $interest * $invest_manage / 100;
$_result[$i]['repayment_money'] = getFloatValue($repayment - $fee, 2);
$_result[$i]['interest'] = getFloatValue($interest - $fee, 2);
$_result[$i]['capital'] = getFloatValue($repayment - $interest, 2);
if ($i + 1 != $date_limit) {
$repay = $repay - $_result[$i]['repayment_money'];
} else {
$repay = 0;
}
$_result[$i]['last_money'] = $repay;
}
$month_apr2 = ($repay_detail['repayment_money'] - $repay_detail['invest_money']) / ($repay_detail['invest_money'] * $date_limit);
$rekursiv = 0.001;
for ($i = 0; $i < 100; $i++) {
$_li2 = pow(1 + $month_apr2, $date_limit);
$repay = $repay_detail['invest_money'] * $date_limit * ($month_apr2 * $_li2) / ($_li2 - 1);
if ($repay < $repay_detail['repayment_money'] * 0.99999) {
$month_apr2 += $rekursiv;
} elseif ($repay > $repay_detail['repayment_money'] * 1.00001) {
$month_apr2 -= $rekursiv * 0.9;
$rekursiv *= 0.1;
} else {
break;
}
}
$repay_detail['month_apr'] = round($month_apr2 * 100, 2);
$repay_detail['year_apr'] = round($repay_detail['month_apr'] * 12, 2);
$repay_detail['day_apr'] = round($repay_detail['month_apr'] * 12 / 365, 2);
break;
}
$repay_detail['total_interest'] = round($repay_detail['repayment_money'] - $repay_detail['invest_money'], 2);
$this->assign('repayment_type', $repayment_type);
$this->assign('month', $date_limit);
$this->assign('repay_list', $_result);
$this->assign('repay_detail', $repay_detail);
$data['html'] = $this->fetch('tool2_res');
exit(json_encode($data));
}
//网站公告
$parm['type_id'] = 321;
$parm['limit'] = 8;
$this->assign("noticeList", getArticleList($parm));
$this->assign("leftlist", array(1 => array("turl" => "/tools/tool2.html", "type_name" => "投资计算器"), 0 => array("turl" => "/tools/tool.html", "type_name" => "借款计算器")));
$this->display();
}
public function index()
{
$is_subsite = false;
$typeinfo = get_type_infos();
if (intval($typeinfo['typeid']) < 1) {
$typeinfo = get_area_type_infos($this->siteInfo['id']);
$is_subsite = true;
}
$typeid = $typeinfo['typeid'];
$typeset = $typeinfo['typeset'];
//left
$listparm['type_id'] = $typeid;
$listparm['limit'] = 10;
if ($is_subsite === false) {
$leftlist = getTypeList($listparm);
} else {
$listparm['area_id'] = $this->siteInfo['id'];
$leftlist = getAreaTypeList($listparm);
}
$this->assign("leftlist", $leftlist);
$this->assign("cid", $typeid);
if ($typeset == 1) {
$parm['pagesize'] = 10;
$parm['type_id'] = $typeid;
if ($is_subsite === false) {
$list = getArticleList($parm);
$vo = D('Acategory')->find($typeid);
if ($vo['parent_id'] != 0) {
$this->assign('cname', D('Acategory')->getFieldById($vo['parent_id'], 'type_name'));
} else {
$this->assign('cname', $vo['type_name']);
}
} else {
$vo = D('Aacategory')->find($typeid);
if ($vo['parent_id'] != 0) {
$this->assign('cname', D('Aacategory')->getFieldById($vo['parent_id'], 'type_name'));
} else {
$this->assign('cname', $vo['type_name']);
}
$parm['area_id'] = $this->siteInfo['id'];
$list = getAreaArticleList($parm);
}
$this->assign("vo", $vo);
$this->assign("list", $list['list']);
$this->assign("pagebar", $list['page']);
} else {
if ($is_subsite === false) {
$vo = D('Acategory')->find($typeid);
if ($vo['parent_id'] != 0) {
$this->assign('cname', D('Acategory')->getFieldById($vo['parent_id'], 'type_name'));
} else {
$this->assign('cname', $vo['type_name']);
}
} else {
$vo = D('Aacategory')->find($typeid);
if ($vo['parent_id'] != 0) {
$this->assign('cname', D('Aacategory')->getFieldById($vo['parent_id'], 'type_name'));
} else {
$this->assign('cname', $vo['type_name']);
}
}
$this->assign("vo", $vo);
}
$this->display($typeinfo['templet']);
}
public function index()
{
$is_subsite = false;
$typeinfo = get_type_infos();
if (intval($typeinfo['typeid']) < 1) {
$typeinfo = get_area_type_infos($this->siteInfo['id']);
$is_subsite = true;
}
$typeid = $typeinfo['typeid'];
$typeset = $typeinfo['typeset'];
//left
$listparm['type_id'] = $typeid;
//$typeinfo = Array ( [typeset] => 1 [templet] => list_index [typeid] => 37 )
$listparm['limit'] = 20;
if ($is_subsite === false) {
$leftlist = getTypeListActa($listparm);
} else {
$listparm['area_id'] = $this->siteInfo['id'];
$leftlist = getAreaTypeList($listparm);
}
$this->assign("leftlist", $leftlist);
$this->assign("cid", $typeid);
if ($typeset == 1) {
$parm['pagesize'] = 15;
$parm['type_id'] = $typeid;
if ($is_subsite === false) {
$list = getArticleList($parm);
$vo = D('Acategory')->find($typeid);
if ($vo['parent_id'] != 0) {
$this->assign('cname', D('Acategory')->getFieldById($vo['parent_id'], 'type_name'));
} else {
$this->assign('cname', $vo['type_name']);
}
} else {
$vo = D('Aacategory')->find($typeid);
if ($vo['parent_id'] != 0) {
$this->assign('cname', D('Aacategory')->getFieldById($vo['parent_id'], 'type_name'));
} else {
$this->assign('cname', $vo['type_name']);
}
$parm['area_id'] = $this->siteInfo['id'];
$list = getAreaArticleList($parm);
}
$this->assign("vo", $vo);
$this->assign("list", $list['list']);
$this->assign("pagebar", $list['page']);
} else {
if ($is_subsite === false) {
$vo = D('Acategory')->find($typeid);
if ($vo['parent_id'] != 0) {
$this->assign('cname', D('Acategory')->getFieldById($vo['parent_id'], 'type_name'));
} else {
$this->assign('cname', $vo['type_name']);
}
} else {
$vo = D('Aacategory')->find($typeid);
if ($vo['parent_id'] != 0) {
$this->assign('cname', D('Aacategory')->getFieldById($vo['parent_id'], 'type_name'));
} else {
$this->assign('cname', $vo['type_name']);
}
}
$this->assign("vo", $vo);
}
// 新增改动左侧菜单高亮
$active_bar = '';
if (!empty($vo) && isset($vo['type_nid'])) {
$active_bar = $vo['type_nid'];
}
$this->assign("active_bar", $active_bar);
// 政策法规特殊处理
$is_zcfg = 0;
if (!empty($vo) && isset($vo['type_nid']) && $vo['type_nid'] == 'zcfg') {
$is_zcfg = 1;
}
$this->assign("is_zcfg", $is_zcfg);
$this->display($typeinfo['templet']);
}
</li>
<?php
}
$noticeList = NULL;
?>
</ul>
</div>
</div>
<div class="clearfix w1180">
<div class="float-left fb-home-box fb-home-boxP15 fb-home-w821">
<h4 class="fb-home-H4 clearfix"><span>新闻中心</span><a href="/p2p/index.php/home/help?news" target="_blank" title="更多新闻">更多></a></h4>
<div class="fb-home-mediaReport1 clearfix">
<ul>
<?php
$jishu = 1;
$xlist = getArticleList(array("type_id" => 2, "limit" => 20));
foreach ($xlist['list'] as $kx => $va) {
if ($va . art_img != "" && $jishu <= 4) {
?>
<li>
<a href="<?php
echo $va["arturl"];
?>
" title="<?php
echo $va["title"];
?>
" target="_blank"><div class="pot"><img src="/<?php
echo $va["art_img"];
?>
" width="208" height="126" alt="<?php
