function getAreaTypeList($parm)
{
//if(empty($parm['type_id'])) return;
$parm['type_id'] = isset($parm['type_id']) ? $parm['type_id'] : 0;
$parm['area_id'] = isset($parm['area_id']) ? $parm['area_id'] : 0;
$Osql = "sort_order DESC";
$field = "id,type_name,type_set,add_time,type_url,type_nid,parent_id,area_id";
//查询条件
$Lsql = "{$parm['limit']}";
$pc = D('Aacategory')->where("parent_id={$parm['type_id']} AND area_id={$parm['area_id']}")->count('id');
if ($pc > 0) {
$map['is_hiden'] = 0;
$map['parent_id'] = $parm['type_id'];
$map['area_id'] = $parm['area_id'];
$data = D('Aacategory')->field($field)->where($map)->order($Osql)->limit($Lsql)->select();
} elseif (!isset($parm['notself'])) {
$map['is_hiden'] = 0;
$map['parent_id'] = D('Aacategory')->getFieldById($parm['type_id'], 'parent_id');
$map['area_id'] = $parm['area_id'];
$data = D('Aacategory')->field($field)->where($map)->order($Osql)->limit($Lsql)->select();
}
//链接处理
$typefix = get_type_leve_area_nid($parm['type_id'], $parm['area_id']);
$typeu = $typefix[0];
$suffix = C("URL_HTML_SUFFIX");
foreach ($data as $key => $v) {
if ($v['type_set'] == 2) {
if (empty($v['type_url'])) {
$data[$key]['turl'] = "javascript:alert('请在后台添加此栏目链接');";
} else {
$data[$key]['turl'] = $v['type_url'];
}
} elseif ($v['parent_id'] == 0 && count($typefix) == 1) {
$data[$key]['turl'] = MU("Home/{$v['type_nid']}/index", "typelist", array("id" => $v['id'], "suffix" => $suffix));
} else {
$data[$key]['turl'] = MU("Home/{$typeu}/{$v['type_nid']}", "typelist", array("id" => $v['id'], "suffix" => $suffix));
}
}
$row = array();
$row = $data;
return $row;
}
function getTypeList($parm)
{
//if(empty($parm['type_id'])) return;
$Osql = "sort_order DESC";
//查询条件
$Lsql = "{$parm['limit']}";
$pc = getCategoryCountByParentId($parm['type_id']);
if ($pc > 0) {
$map['is_hiden'] = 0;
$map['parent_id'] = $parm['type_id'];
$data = getCategoryByCondition($map, $Osql, $Lsql);
} elseif (!isset($parm['notself'])) {
$map['is_hiden'] = 0;
$mycat = getCategoryById($parm['type_id']);
$map['parent_id'] = $mycat['parent_id'];
$data = getCategoryByCondition($map, $Osql, $Lsql);
}
//链接处理
$typefix = get_type_leve_nid($parm['type_id']);
$typeu = $typefix[0];
$suffix = C("URL_HTML_SUFFIX");
foreach ($data as $key => $v) {
if ($v['type_set'] == 2) {
if (empty($v['type_url'])) {
$data[$key]['turl'] = "javascript:alert('请在后台添加此栏目链接');";
} else {
$data[$key]['turl'] = $v['type_url'];
}
} elseif ($parm['type_id'] == 0 || $v['parent_id'] == 0 && count($typefix) == 1) {
$data[$key]['turl'] = MU("Home/{$v['type_nid']}/index", "typelist", array("suffix" => $suffix));
} else {
$data[$key]['turl'] = MU("Home/{$typeu}/{$v['type_nid']}", "typelist", array("suffix" => $suffix));
}
}
$row = array();
$row = $data;
return $row;
}
function zwgetArticleList($parm)
{
if (empty($parm['type_id'])) {
return;
}
//$map['type_id'] = $parm['type_id'];
$type_id = intval($parm['type_id']);
$Allid = M("article_category")->field("id")->where("parent_id = {$type_id}")->select();
$newlist = array();
array_push($newlist, $parm['type_id']);
foreach ($Allid as $ka => $v) {
array_push($newlist, $v["id"]);
}
$map['type_id'] = array("in", $newlist);
$Osql = "sort_order desc,id DESC";
//id DESC,
$field = "id,title,art_set,art_time,art_url,art_img,art_info";
//查询条件
if ($parm['pagesize']) {
//分页处理
import("ORG.Util.Page");
$count = M('article')->where($map)->count('id');
$p = new Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
//分页处理
} else {
$page = "";
$Lsql = "{$parm['limit']}";
}
$data = M('article')->field($field)->where($map)->order($Osql)->limit($Lsql)->select();
$suffix = C("URL_HTML_SUFFIX");
$typefix = get_type_leve_nid($type_id);
$typeu = implode("/", $typefix);
foreach ($data as $key => $v) {
if ($v['art_set'] == 1) {
$data[$key]['arturl'] = stripos($v['art_url'], "http://") === false ? "http://" . $v['art_url'] : $v['art_url'];
} else {
$data[$key]['arturl'] = MU("Home/{$typeu}", "article", array("id" => $v['id'], "suffix" => $suffix));
}
}
$row = array();
$row['list'] = $data;
$row['page'] = $page;
return $row;
}
function getArticleList($parm)
{
if (empty($parm['type_id'])) {
return;
}
$map['type_id'] = $parm['type_id'];
$Osql = "id DESC";
$field = "id,title,art_set,art_time,art_url";
if ($parm["need_content"]) {
$field .= ",art_content";
}
//查询条件
if ($parm['pagesize']) {
//分页处理
import("ORG.Util.Page");
$count = M('article')->where($map)->count('id');
$depr = C('URL_PATHINFO_DEPR');
$cur_url = GetCurUrl();
if (preg_match("/\\/l\\/([a-zA-z-]+)\\/([\\w\\/]*)\\?l=([a-zA-z-]+)/", $cur_url) === 1) {
$cur_url = preg_replace("/\\?l=([a-zA-z-]+)/", "", $cur_url);
}
$p = new Page($count, $parm['pagesize'], '', preg_replace(array('/.html\\/l\\/([a-zA-z-]+)\\/\\d*/', '/.html\\/\\d+/'), array('.html?l=' . LANG_SET, '.html'), ltrim($cur_url, $depr)));
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
//分页处理
} else {
$page = "";
$Lsql = "{$parm['limit']}";
}
$data = M('article')->field($field)->where($map)->order($Osql)->limit($Lsql)->select();
$suffix = C("URL_HTML_SUFFIX");
$typefix = get_type_leve_nid($map['type_id']);
$typeu = implode("/", $typefix);
foreach ($data as $key => $v) {
if ($v['art_set'] == 1) {
$data[$key]['arturl'] = stripos($v['art_url'], "http://") === false ? "http://" . $v['art_url'] : $v['art_url'];
} else {
$data[$key]['arturl'] = MU("Home/{$typeu}", "article", array("id" => $v['id'], "suffix" => $suffix));
}
}
$row = array();
$row['list'] = $data;
$row['page'] = $page;
return $row;
}
function getTBorrowList($parm = array())
{
/* hycd if(empty($parm['map'])) return;
$map = $parm['map'];
$orderby = $parm['orderby'];
if($parm['pagesize'])
{
import( "ORG.Util.Page" );
$count = M("transfer_borrow_info b")->where($map)->count("b.id");
$p = new \Org\Util\Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
}else{
$page = "";
$Lsql = "{$parm['limit']}";
}
$pre = C("DB_PREFIX");
$suffix =C("URL_HTML_SUFFIX");
$field = "b.id,b.borrow_name,b.borrow_status,b.borrow_money,b.repayment_type,b.min_month,b.transfer_out,b.transfer_back,b.transfer_total,b.per_transfer,b.borrow_interest_rate,b.borrow_duration,b.increase_rate,b.reward_rate,b.deadline,b.is_show,m.province,m.city,m.area,m.user_name,m.id as uid,m.credits,m.customer_name,b.borrow_type,b.b_img,b.add_time,b.collect_day,b.danbao,b.online_time";
$list = M("transfer_borrow_info b")->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->where($map)->order($orderby)->limit($Lsql)->select();
print_r($list);
$areaList = getarea();
foreach($list as $key => $v)
{
$list[$key]['location'] = $areaList[$v['province']].$areaList[$v['city']];
$list[$key]['progress'] = getfloatvalue( $v['transfer_out'] / $v['transfer_total'] * 100, 2);
$list[$key]['need'] = getfloatvalue(($v['transfer_total'] - $v['transfer_out'])*$v['per_transfer'], 2 );
$list[$key]['burl'] = MU("Home/invest_transfer", "invest_transfer",array("id" => $v['id'],"suffix" => $suffix));
$temp=floor(("{$v['collect_day']}"*3600*24-time()+"{$v['add_time']}")/3600/24);
$list[$key]['leftdays'] = "{$temp}".'天以上';
$list[$key]['now'] = time();
$list[$key]['borrow_times'] = count(M('transfer_borrow_investor') -> where("borrow_id = {$list[$key]['id']}") ->select());
$list[$key]['investornum'] = M('transfer_borrow_investor')->where("borrow_id={$v['id']}")->count("id");
if($v['danbao']!=0 ){
$list[$key]['danbaoid'] = intval($v['danbao']);
$danbao = M('article')->field('id,title')->where("type_id=7 and id={$v['danbao']}")->find();
$list[$key]['danbao']=$danbao['title'];//担保机构
}else{
$list[$key]['danbao']='暂无担保机构';//担保机构
}
//收益率
$monthData['month_times'] = 12;
$monthData['account'] = $v['borrow_money'];
$monthData['year_apr'] = $v['borrow_interest_rate'];
$monthData['type'] = "all";
$repay_detail = CompoundMonth($monthData);
if($v['borrow_duration']==1){
$list[$key]['shouyi'] = $v['borrow_interest_rate'];
}else{
$list[$key]['shouyi'] = $repay_detail['shouyi'];
}
//收益率结束
}
$row = array();
$row['list'] = $list;
$row['page'] = $page;
return $row;*/
if (empty($parm['map'])) {
return;
}
$map = $parm['map'];
$orderby = $parm['orderby'];
if ($parm['pagesize']) {
//分页处理
import("ORG.Util.Page");
$count = M('borrow_info b')->where($map)->count('b.id');
echo $count;
$p = new \Org\Util\Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
//分页处理
} else {
$page = "";
$Lsql = "{$parm['limit']}";
}
$pre = C('DB_PREFIX');
$suffix = C("URL_HTML_SUFFIX");
$field = "b.id,b.borrow_name,b.borrow_type,b.reward_type,b.borrow_times,b.borrow_status,b.borrow_money,b.borrow_use,b.repayment_type,b.borrow_interest_rate,b.borrow_duration,b.collect_time,b.add_time,b.province,b.has_borrow,b.has_vouch,b.city,b.area,b.reward_type,b.reward_num,b.password,m.user_name,m.id as uid,m.credits,m.customer_name,b.is_tuijian,b.deadline,b.danbao,b.borrow_info,b.risk_control,b.borrow_btype";
$list = M('borrow_info b')->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->where($map)->order($orderby)->limit($Lsql)->select();
$areaList = getArea();
foreach ($list as $key => $v) {
$list[$key]['location'] = $areaList[$v['province']] . $areaList[$v['city']];
$list[$key]['biao'] = $v['borrow_times'];
$list[$key]['need'] = $v['borrow_money'] - $v['has_borrow'];
$list[$key]['leftdays'] = getLeftTime($v['collect_time']);
$list[$key]['bollprogress'] = getFloatValue($v['has_borrow'] / $v['borrow_money'] * 86.90000000000001, 2);
$list[$key]['progress'] = getFloatValue($v['has_borrow'] / $v['borrow_money'] * 100);
$list[$key]['vouch_progress'] = getFloatValue($v['has_vouch'] / $v['borrow_money'] * 100, 2);
$list[$key]['burl'] = MU("Home/invest", "invest", array("id" => $v['id'], "suffix" => $suffix));
//新加
$list[$key]['lefttime'] = $v['collect_time'] - time();
if ($v['deadline'] == 0) {
$endTime = strtotime(date("Y-m-d", time()));
if ($v['repayment_type'] == 1) {
$list[$key]['repaytime'] = strtotime("+{$v['borrow_duration']} day", $endTime);
} else {
$list[$key]['repaytime'] = strtotime("+{$v['borrow_duration']} month", $endTime);
}
} else {
$list[$key]['repaytime'] = $v['deadline'];
//还款时间
}
$list[$key]['publishtime'] = $v['add_time'] + 60 * 60 * 24 * 3;
//预计发标时间=添加时间+1天
if ($v['danbao'] != 0) {
$danbao = M('article')->field("id,title")->where("type_id =7 and id ={$v['danbao']}")->find();
$list[$key]['danbao'] = $danbao['title'];
//担保机构
} else {
$list[$key]['danbao'] = '暂无担保机构';
//担保机构
}
}
$row = array();
$row['list'] = $list;
$row['page'] = $page;
return $row;
}
function getTBorrowList($parm = array())
{
if (empty($parm['map'])) {
return;
}
$map = $parm['map'];
$orderby = $parm['orderby'];
//dump($parm['pagesize']);die;
if ($parm['pagesize']) {
import("ORG.Util.Page");
$count = M("transfer_borrow_info b")->where($map)->count("b.id");
$p = new Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
} else {
$page = "";
$Lsql = "{$parm['limit']}";
}
$pre = C("DB_PREFIX");
$suffix = C("URL_HTML_SUFFIX");
//dump($suffix);die;
$field = "b.id,b.borrow_name,b.borrow_status,b.borrow_money,b.repayment_type,b.min_month,b.transfer_out,b.transfer_back,b.transfer_total,b.per_transfer,b.borrow_interest_rate,b.borrow_duration,b.increase_rate,b.reward_rate,b.deadline,b.is_show,m.province,m.city,m.area,m.user_name,m.id as uid,m.credits,m.customer_name,b.borrow_type,b.b_img,b.add_time,b.collect_day,b.danbao,b.stock_type";
$list = M("transfer_borrow_info b")->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->where($map)->order($orderby)->limit($Lsql)->select();
$areaList = getarea();
//(国家、省、市、县。。)
//dump($areaList);die;
foreach ($list as $key => $v) {
//($list是android那边需要的数据)
$list[$key]['location'] = $areaList[$v['province']] . $areaList[$v['city']];
$list[$key]['progress'] = getfloatvalue($v['transfer_out'] / $v['transfer_total'] * 100, 2);
$list[$key]['need'] = getfloatvalue(($v['transfer_total'] - $v['transfer_out']) * $v['per_transfer'], 2);
$list[$key]['burl'] = MU("Home/invest_transfer", "invest_transfer", array("id" => $v['id'], "suffix" => $suffix));
$temp = floor(("{$v['collect_day']}" * 3600 * 24 - time() + "{$v['add_time']}") / 3600 / 24);
$list[$key]['leftdays'] = "{$temp}" . '天以上';
$list[$key]['now'] = time();
$list[$key]['borrow_times'] = count(M('transfer_borrow_investor')->where("borrow_id = {$list[$key]['id']}")->select());
if ($v['danbao'] != 0) {
$list[$key]['danbaoid'] = intval($v['danbao']);
$danbao = M('article')->field('id,title')->where("type_id=7 and id={$v['danbao']}")->find();
$list[$key]['danbao'] = $danbao['title'];
//担保机构
} else {
$list[$key]['danbao'] = '暂无担保机构';
//担保机构
}
}
$row = array();
$row['list'] = $list;
$row['page'] = $page;
return $row;
}
public function doEditWaitverify()
{
$m = D(ucfirst($this->getActionName()));
if (false === $m->create()) {
$this->error($m->getError());
}
$vm = M('borrow_info')->field('id,borrow_name,reward_num,borrow_money,capital_name,borrow_duration,repayment_type,borrow_interest_rate,borrow_uid,borrow_status,borrow_type,first_verify_time,password,updata,danbao,vouch_money,money_collect,can_auto')->find($m->id);
$rate_lixt = explode("|", $this->glo['rate_lixi']);
$borrow_duration = explode("|", $this->glo['borrow_duration']);
$borrow_duration_day = explode("|", $this->glo['borrow_duration_day']);
if (floatval($_POST['borrow_interest_rate']) > $rate_lixt[1] || floatval($_POST['borrow_interest_rate']) < $rate_lixt[0]) {
$this->error("提交的借款利率不在允许范围，请重试", 0);
exit;
}
if ($m->repayment_type == '1' && ($m->borrow_duration > $borrow_duration_day[1] || $m->borrow_duration < $borrow_duration_day[0])) {
$this->error("提交的借款期限不在允许范围，请去网站设置处重新设置系统参数", 0);
exit;
}
if ($m->repayment_type != '1' && ($m->borrow_duration > $borrow_duration[1] || $m->borrow_duration < $borrow_duration[0])) {
$this->error("提交的借款期限不在允许范围，请去网站设置处重新设置系统参数", 0);
exit;
}
////////////////////图片编辑///////////////////////
if (!empty($_POST['swfimglist'])) {
foreach ($_POST['swfimglist'] as $key => $v) {
$row[$key]['img'] = substr($v, 1);
$row[$key]['info'] = $_POST['picinfo'][$key];
}
$m->updata = serialize($row);
}
////////////////////图片编辑///////////////////////
if ($vm['borrow_status'] != 2 && $m->borrow_status == 2) {
//新标提醒
//newTip($m->id);
MTip('chk8', $vm['borrow_uid'], $m->id);
//自动投标
if ($m->borrow_type == 1) {
memberLimitLog($vm['borrow_uid'], 1, -$m->borrow_money, $info = "{$m->id}号标初审通过");
} elseif ($m->borrow_type == 2) {
memberLimitLog($vm['borrow_uid'], 2, -$m->borrow_money, $info = "{$m->id}号标初审通过");
}
$vss = M("members")->field("user_phone,user_name")->where("id = {$vm['borrow_uid']}")->find();
SMStip("firstV", $vss['user_phone'], array("#USERANEM#", "ID"), array($vss['user_name'], $m->id));
}
//if($m->borrow_status==2) $m->collect_time = strtotime("+ {$m->collect_day} days");
if ($m->borrow_status == 2) {
$m->collect_time = strtotime("+ {$m->collect_day} days");
$m->reward_num = $_POST['reward_num'];
//$m->is_tuijian = 1;
}
$m->money_invest_place = intval($_POST['money_invest_place']);
$m->borrow_interest = getBorrowInterest($m->repayment_type, $m->borrow_money, $m->borrow_duration, $m->borrow_interest_rate);
//保存当前数据对象
if ($m->borrow_status == 2 || $m->borrow_status == 1) {
$m->first_verify_time = time();
} else {
unset($m->first_verify_time);
}
unset($m->borrow_uid);
$bs = intval($_POST['borrow_status']);
//新加接口数据准备
$toId = M('member_to')->where(array('username' => array('like', $vm['capital_name'])))->getField('id');
if (empty($toId)) {
$toId = M('member_to')->add(array('username' => $vm['capital_name']));
}
//按天到期还款、一次性还款 4
//按月分期还款 3
//每月还息到期还本 1
$lilv = array(1 => 4, 5 => 4, 2 => 3, 4 => 1);
$yottarr = array('subject_id' => $m->id, 'is_test' => '0', 'type' => 0, 'name' => $m->borrow_name, 'borrow_type' => '1', 'desc' => $m->borrow_info, 'reward' => $vm['reward_num'], 'reward_type' => '1', 'url' => MU("Home/invest", "invest", array("id" => $m->id, "suffix" => C("URL_HTML_SUFFIX")), true), 'borrow_username' => $toId, 'account' => $m->borrow_money, 'period' => $m->borrow_duration, 'period_type' => 1 == $m->repayment_type ? 1 : 0, 'apr' => $m->borrow_interest_rate, 'repay_style' => $lilv[$m->repayment_type], 'status' => '2', 'addtime' => time());
//结束新加
if ($result = $m->save()) {
//保存成功
if (2 == $bs && $this->yott()) {
$yott = new yott();
$res = json_decode($yott->createP2p($yottarr));
//记录日志
M('yott_log')->add(array('dateline' => time(), 'apitype' => 'createp2p', 'apidata' => json_encode($yottarr), 'code' => $res->code, 'msg' => $res->msg));
}
if ($bs == 2 || $bs == 1) {
$verify_info['borrow_id'] = intval($_POST['id']);
$verify_info['deal_info'] = text($_POST['deal_info']);
$verify_info['deal_user'] = $this->admin_id;
$verify_info['deal_time'] = time();
$verify_info['deal_status'] = $bs;
if ($vm['first_verify_time'] > 0) {
M('borrow_verify')->save($verify_info);
} else {
M('borrow_verify')->add($verify_info);
}
}
if ($vm['borrow_status'] != 2 && $_POST['borrow_status'] == 2 && $vm['can_auto'] == 1 && empty($vm['password']) == true) {
if ($vm['borrow_type'] != 3) {
autoInvest(intval($_POST['id']));
}
}
//if($vm['borrow_status']<>2 && $_POST['borrow_status']==2)) autoInvest(intval($_POST['id']));
alogs("doEditWait", $result, 1, '初审操作成功！');
//管理员操作日志
//成功提示
$this->assign('jumpUrl', __URL__ . "/" . session('listaction'));
$this->success(L('修改成功'));
} else {
alogs("doEditWait", $result, 0, '初审操作失败！');
//管理员操作日志
//失败提示
$this->error(L('修改失败'));
}
}
public function news_list_add()
{
$jsoncode = file_get_contents("php://input");
$arr = array();
$arr = json_decode($jsoncode, true);
// $arr['gtype'] = 0;
// $arr['num'] = 4;
// $arr['id'] = 98;
if (is_array($arr) && !empty($arr['id']) && isset($arr['gtype']) && !empty($arr['num'])) {
$gtype = $arr['gtype'];
$id = intval($arr['id']);
$num = intval($arr['num']);
} else {
$gtype = 2;
$num = 7;
}
// $listid = M('article_category')->where("type_name = '行业新闻'")->getField('id');
$listid = 2;
if ($gtype == 1) {
//往大查询
$list = M('article')->where("type_id = {$listid} and id > {$id} ")->order('id asc')->limit("{$num}")->select();
} elseif ($gtype == 0) {
//往小查询
$list = M('article')->where("type_id = {$listid} and id < {$id} ")->order('id desc')->limit("{$num}")->select();
} elseif ($gtype == 2) {
//
$list = M('article')->where("type_id = {$listid} ")->order('id desc')->limit("{$num}")->select();
}
$newlist = array();
$map['type_id'] = array("in", $newlist);
$suffix = C("URL_HTML_SUFFIX");
$typefix = get_type_leve_nid($map['type_id']);
$typeu = implode("/", $typefix);
// var_dump($list);die();
foreach ($list as $key => $v) {
$_list[$key]['id'] = $v['id'];
$_list[$key]['title'] = $v['title'];
$_list[$key]['art_time'] = date("Y-m-d", $v['art_time']);
$_list[$key]['arturl'] = "peizi.taoweikeji.com" . MU("Home/{$typeu}", "article", array("id" => $v['id'], "suffix" => $suffix));
$_list[$key]['content'] = str_replace(' ', '', strip_tags($v['art_content']));
}
$m_list['list'] = $_list;
if (is_array($m_list['list'])) {
ajaxmsg($m_list);
} else {
ajaxmsg();
}
}
protected function getWdzjBorrowList($parm = array())
{
if (empty($parm['map'])) {
return;
}
$pagesize = intval($_GET['pagesize']);
$dateline = $_GET['date'];
$parm['pagesize'] = $pagesize ? $pagesize : 10;
$map = $parm['map'];
if ($this->is_date($dateline)) {
$start = strtotime($dateline);
$end = $start + 86400;
$timespan = $start . "," . $end;
$map['first_verify_time'] = array("between", $timespan);
}
$orderby = $parm['orderby'];
$searchMap = array();
$searchMap['stock_type'] = array("1" => "天天盈", "2" => "月月盈", '4' => "打新宝");
//关联目前的还款类型
$searchMap['repayments'] = array(1 => 1, 2 => 2, 3 => 5, 4 => 1, 5 => 1);
$result = array();
$count = M('borrow_info')->where($map)->count('id');
$page = (int) $_GET['page'];
$page = $page ? $page : 1;
$offset = $parm['pagesize'] * ($page - 1);
$result['totalPage'] = ceil($count / $parm['pagesize']);
$result['totalCount'] = $count;
$result['currentPage'] = $page;
$result['totalAmount'] = (int) M('borrow_info')->where($map)->sum('borrow_money');
$Lsql = "{$offset},{$parm['pagesize']}";
$suffix = C("URL_HTML_SUFFIX");
$field = "id as projectId,borrow_name as title,has_borrow,borrow_duration as deadline,borrow_interest_rate as interestRate,reward_num as reward,borrow_money as amount,repayment_type,stock_type,capital_name,full_time,first_verify_time,borrow_info as amountUsedDesc";
$list = M('borrow_info')->field($field)->where($map)->order($orderby)->limit($Lsql)->select();
foreach ($list as &$v) {
$toId = M('member_to')->where(array('username' => array('like', $v['capital_name'])))->getField('id');
if (empty($toId)) {
$toId = M('member_to')->add(array('username' => $v['capital_name']));
}
$progress = $v['has_borrow'] / $v['amount'] * 100;
$v['interestRate'] = $v['interestRate'] . '%';
$v['schedule'] = $progress > 50 ? floor($progress) : ceil($progress);
//增加floor
$v['deadlineUnit'] = 1 == $v['repayment_type'] ? '天' : '月';
$v['type'] = '抵押标';
//$v['type']= $searchMap['stock_type'][$v['stock_type']];
$v['repaymentType'] = $searchMap['repayments'][$v['repayment_type']];
$v['subscribes'] = $this->investRecord($v['projectId']);
$v['province'] = '';
$v['city'] = '';
$v['userName'] = $toId;
$v['userAvatarUrl'] = '';
$v['revenue'] = '';
$v['loanUrl'] = MU("Home/invest", "invest", array("id" => $v['projectId'], "suffix" => $suffix), true);
if (100 == $progress && empty($v['full_time'])) {
$tmp = end($v['subscribes']);
$full_time = $tmp['addDate'];
} else {
$full_time = date('Y-m-d H:i:s', $v['full_time']);
}
$v['successTime'] = $full_time;
$v['publishTime'] = date('Y-m-d H:i:s', $v['first_verify_time']);
unset($v['has_borrow'], $v['repayment_type'], $v['capital_name'], $v['stock_type'], $v['user_name'], $v['full_time'], $v['first_verify_time']);
}
$result['borrowList'] = $list;
return $result;
}
