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; }