public function index()
 {
     $parm = array();
     //$Map  = ' b.borrow_status = 2 and b.is_show=1 and b.transfer_total > b.transfer_out';
     $Map = 'b.is_show=1 ';
     $parm['map'] = $Map;
     $parm['orderby'] = "b.is_show desc,b.id DESC";
     $parm['pagesize'] = 8;
     $listTBorrow = getTBorrowList($parm);
     if ($this->isAjax()) {
         $string = '';
         foreach ($listTBorrow['list'] as $vb) {
             $string .= '<a href="' . getInvestUrl($vb['id']) . '">
                     <div class="biao_box">
                      <h4><div class="title_img" style="float:left;margin-top:4px">' . getIco($vb) . '</div>
                         <div style="float:left;text-align:left">' . cnsubstr($vb['borrow_name'], 5) . '</div></h4><table>
                         <tr>
                             <td>融资金额:' . MFormt($vb['borrow_money']) . '元</td>
                             <td>融资期限:' . $vb['borrow_duration'];
             $string .= $vb['repayment_type'] == 1 ? '天' : '个月';
             $string .= '</tr><tr><td>年化利率:' . $vb['borrow_interest_rate'] . '%/';
             $string .= $vb['repayment_type'] == 1 ? '天' : '年';
             $string .= '</td><td><span class="progress"> <span class="precent" style="width":' . $vb['progress'] . '></span></span>
              </td></tr></table> </div> </a>';
         }
         echo $string;
     } else {
         $this->assign("listTBorrow", $listTBorrow);
         $this->display();
     }
 }
示例#2
0
 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();
 }
示例#3
0
 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();
     }
 }
示例#4
0
 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****************************/
 }
示例#5
0
 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);
 }
示例#6
0
 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()
 {
     static $newpars;
     $Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
     $per = C('DB_PREFIX');
     $curl = $_SERVER['REQUEST_URI'];
     $urlarr = parse_url($curl);
     parse_str($urlarr['query'], $surl);
     //array获取当前链接参数,2.
     $urlArr = array('borrow_type', 'interest_rate', '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['interest_rate'] = array("all" => "不限制", "0-10" => "10%以下", "10-15" => "10%-15%", "20-100" => "20%以上");
     $searchMap['borrow_duration'] = array("all" => "不限制", "0-3" => "3个月以内", "4-6" => "3-6个月", "7-12" => "6-12个月", "13-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_type':
                     $search["b.borrow_type"] = intval($_GET[$v]);
                     break;
                 case 'interest_rate':
                     $barr = explode("-", text($_GET[$v]));
                     $search["b.borrow_interest_rate"] = array("between", $barr);
                     break;
                 default:
                     $barr = explode("-", text($_GET[$v]));
                     $search["b." . $v] = array("between", $barr);
                     break;
             }
         }
     }
     //searchMap
     $search['b.is_show'] = array("in", '0,1');
     $search['b.borrow_status'] = array('neq', '3');
     $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);
     }
     $parm['map'] = $search;
     $parm['pagesize'] = 9;
     $parm['orderby'] = "b.is_tuijian desc,b.is_show desc,b.progress asc";
     $list = getTBorrowList($parm);
     $this->assign("Sorder", $Sorder);
     $this->assign("searchUrl", $searchUrl);
     $this->assign("searchMap", $searchMap);
     $this->assign("Bconfig", $Bconfig);
     $this->assign("list", $list);
     $this->display();
 }
示例#8
0
 /**
  * 普通标列表
  * 
  */
 public function index()
 {
     static $newpars;
     $Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
     $per = C('DB_PREFIX');
     $curl = $_SERVER['REQUEST_URI'];
     $urlarr = parse_url($curl);
     parse_str($urlarr['query'], $surl);
     //array获取当前链接参数,2.
     //$urlArr = array('borrow_status','borrow_duration','leve');
     $urlArr = array('borrow_status', 'interest_rate', 'borrow_duration', 'scale', '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['deadline'] = strtotime("deadline");
     $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['scale'] = array("all" => "不限制", "0-1000000" => "0-100万", "1000000-3000000" => "100-300万", "3000000-5000000" => "300-500万", "5000000-10000000" => "500万以上");
     $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 'scale':
                     $barr = explode("-", text($_GET[$v]));
                     $search["bi.borrow_money"] = array("between", $barr);
                     break;
                 case 'borrow_status':
                     $search["bi." . $v] = intval($_GET[$v]);
                     break;
                 case 'interest_rate':
                     $barr = explode("-", text($_GET[$v]));
                     $search["b.borrow_interest_rate"] = array("between", $barr);
                     break;
                 default:
                     $barr = explode("-", text($_GET[$v]));
                     $search["bi." . $v] = array("between", $barr);
                     break;
             }
         }
     }
     if ($search['bi.borrow_status'] == 0) {
         $search['bi.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);
     }
     $parm['map'] = $search;
     $parm['pagesize'] = 10;
     //排序
     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'] = "bi.borrow_status asc,bi.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 = getTBorrowList($parm);
     //dump(M()->getlastsql());die;
     $this->assign("Sorder", $Sorder);
     $this->assign("searchUrl", $searchUrl);
     $this->assign("searchMap", $searchMap);
     $this->assign("Bconfig", $Bconfig);
     $this->assign("list", $list);
     $this->display();
 }
示例#9
0
 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****************************/
 }
示例#10
0
 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****************************/
 }
示例#11
0
 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();
 }