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