function getBorrowList($parm = array(), $countonly = false)
{
if (empty($parm['map'])) {
return;
}
$map = $parm['map'];
$orderby = $parm['orderby'];
//$map = array_merge($map,$search);
if ($countonly) {
return M('borrow_info b')->where($map)->count('b.id');
}
if ($parm['pagesize']) {
//分页处理
import("ORG.Util.Page");
$count = M('borrow_info b')->where($map)->count('b.id');
$p = new Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
//分页处理
} else {
$page = "";
$Lsql = "{$parm['limit']}";
}
$pre = C('DB_PREFIX');
$suffix = C("URL_HTML_SUFFIX");
$field = "b.id,b.borrow_name,b.borrow_type,b.reward_type,b.borrow_times,b.borrow_status,b.borrow_money,b.borrow_use,b.repayment_type,b.borrow_interest_rate,b.borrow_duration,b.collect_time,b.province,b.has_borrow,b.has_vouch,b.city,b.area,b.reward_type,b.reward_num,b.password,b.borrow_info,m.user_name,m.id as uid,m.credits,m.customer_name,b.is_tuijian,b.pro_provide,b.first_verify_time,b.schedular_time";
if ($parm['hotest']) {
$field .= ",IFNULL(b.`full_time`,0)-IFNULL(bv.`deal_time`,0) finish_time";
$list = M('borrow_info')->alias("b")->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->join("{$pre}borrow_verify bv ON b.id=bv.borrow_id")->where($map)->order($orderby)->limit($Lsql)->select();
} else {
$list = M('borrow_info')->alias("b")->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->where($map)->order($orderby)->limit($Lsql)->select();
}
$areaList = getArea();
foreach ($list as $key => $v) {
$list[$key]['location'] = $areaList[$v['province']] . $areaList[$v['city']];
$list[$key]['biao'] = $v['borrow_times'];
$list[$key]['need'] = $v['borrow_money'] - $v['has_borrow'];
$list[$key]['leftdays'] = getLeftTime($v['collect_time']);
$list[$key]['progress'] = getFloatValue($v['has_borrow'] / $v['borrow_money'] * 100, 2);
$list[$key]['vouch_progress'] = getFloatValue($v['has_vouch'] / $v['borrow_money'] * 100, 2);
$list[$key]['burl'] = MU("Home/invest", "invest", array("id" => $v['id'], "suffix" => $suffix));
$list[$key]['schedular_time'] = trans_date_format($v['schedular_time'], 'Y-m-d');
}
$row = array();
$row['list'] = $list;
$row['page'] = $page;
return $row;
}
function getBorrowList($parm = array())
{
$map = $parm['map'];
$orderby = $parm['orderby'];
if ($parm['pagesize']) {
//分页处理
import("ORG.Util.Page");
$count = M('borrow_info b')->where($map)->count('b.id');
$p = new Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
$row['page']['total'] = ceil($count / $parm['pagesize']);
$row['page']['nowPage'] = isset($_REQUEST['p']) ? $_REQUEST['p'] : 1;
//分页处理
} else {
$page = "";
$Lsql = "{$parm['limit']}";
}
$pre = C('DB_PREFIX');
$suffix = C("URL_HTML_SUFFIX");
$field = "b.id,b.borrow_name,b.borrow_type,b.updata,b.reward_type,b.borrow_times,b.borrow_status,b.borrow_money,b.borrow_use,b.repayment_type,b.borrow_interest_rate,b.borrow_duration,b.collect_time,b.add_time,b.province,b.has_borrow,b.has_vouch,b.city,b.area,b.reward_type,b.reward_num,b.password,m.user_name,m.id as uid,m.credits,m.customer_name,b.is_tuijian,b.deadline,b.danbao,b.borrow_info,b.risk_control";
$list = M('borrow_info b')->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->where($map)->order($orderby)->limit($Lsql)->select();
$areaList = getArea();
foreach ($list as $key => $v) {
$list[$key]['location'] = $areaList[$v['province']] . $areaList[$v['city']];
$list[$key]['biao'] = $v['borrow_times'];
$list[$key]['need'] = $v['borrow_money'] - $v['has_borrow'];
$list[$key]['leftdays'] = getLeftTime($v['collect_time']);
$list[$key]['progress'] = getFloatValue($v['has_borrow'] / $v['borrow_money'] * 100, 2);
$list[$key]['vouch_progress'] = getFloatValue($v['has_vouch'] / $v['borrow_money'] * 100, 2);
$list[$key]['burl'] = MU("M/invest", "invest", array("id" => $v['id'], "suffix" => $suffix));
$img = unserialize($v['updata']);
$list[$key]['image'] = $img['0']['img'];
}
$row['list'] = $list;
return $row;
}
function getBorrowList($parm = array())
{
if (empty($parm['map'])) {
return;
}
$map = $parm['map'];
$orderby = $parm['orderby'] . "borrow_money-has_borrow DESC ,id DESC";
if ($parm['pagesize']) {
//分页处理
import("ORG.Util.Page");
$count = M('borrow_info b')->where($map)->count('b.id');
// return $sql= M()->getLastSql();
// die;
$p = new Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
//分页处理
} else {
$page = "";
$Lsql = "{$parm['limit']}";
}
$pre = C('DB_PREFIX');
$suffix = C("URL_HTML_SUFFIX");
$field = "b.id,b.borrow_name,b.borrow_type,b.reward_type,b.borrow_times,b.borrow_status,b.borrow_money,b.borrow_use,b.repayment_type,b.borrow_min,b.borrow_interest_rate,b.borrow_mortgage_rate,b.borrow_duration,b.collect_time,b.add_time,b.province,b.has_borrow,b.has_vouch,b.city,b.area,b.reward_type,b.reward_num,b.password,m.user_name,m.id as uid,m.credits,m.customer_name,b.is_tuijian,b.deadline,b.danbao,b.borrow_info,b.risk_control,b.toubiao_telephone";
// $field = "b.id,b.borrow_name,b.borrow_type,b.reward_type,b.borrow_times,b.borrow_status,b.borrow_money,b.borrow_use,b.repayment_type,b.borrow_min,b.borrow_interest_rate,b.borrow_duration,b.collect_time,b.add_time,b.province,b.has_borrow,b.has_vouch,b.city,b.area,b.reward_type,b.reward_num,b.password,m.user_name,m.id as uid,m.credits,m.customer_name,b.is_tuijian,b.deadline,b.danbao,b.borrow_info,b.risk_control";
$list = M('borrow_info b')->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->where($map)->order($orderby)->limit($Lsql)->select();
//ORDER BY borrow_money-has_borrow DESC ,id DESC
// echo M()->getLastSql();
// die;
$areaList = getArea();
foreach ($list as $key => $v) {
if (strlen($v['toubiao_telephone']) >= 11) {
$userTelephone = $_SESSION['u_user_name'];
if (strpos($v['toubiao_telephone'], $userTelephone) !== false) {
//此标是否在前端显示
$list[$key]['zw_show'] = 1;
} else {
$list[$key]['zw_show'] = 0;
}
} else {
$list[$key]['zw_show'] = 1;
}
$list[$key]['location'] = $areaList[$v['province']] . $areaList[$v['city']];
$list[$key]['biao'] = $v['borrow_times'];
$list[$key]['need'] = $v['borrow_money'] - $v['has_borrow'];
$list[$key]['leftdays'] = getLeftTime($v['collect_time']);
$list[$key]['progress'] = getFloatValue($v['has_borrow'] / $v['borrow_money'] * 100, 2);
$list[$key]['vouch_progress'] = getFloatValue($v['has_vouch'] / $v['borrow_money'] * 100, 2);
$list[$key]['burl'] = MU("Home/invest", "invest", array("id" => $v['id'], "suffix" => $suffix));
//新加
$list[$key]['lefttime'] = $v['collect_time'] - time();
if ($v['deadline'] == 0) {
$endTime = strtotime(date("Y-m-d", time()));
if ($v['repayment_type'] == 1) {
$list[$key]['repaytime'] = strtotime("+{$v['borrow_duration']} day", $endTime);
} else {
$list[$key]['repaytime'] = strtotime("+{$v['borrow_duration']} month", $endTime);
}
} else {
$list[$key]['repaytime'] = $v['deadline'];
//还款时间
}
$list[$key]['publishtime'] = $v['add_time'] + 60 * 60 * 24 * 3;
//预计发标时间=添加时间+1天
if ($v['danbao'] != 0) {
$danbao = M('article')->field("id,title")->where("type_id =7 and id ={$v['danbao']}")->find();
$list[$key]['danbao'] = $danbao['title'];
//担保机构
} else {
$list[$key]['danbao'] = '暂无担保机构';
//担保机构
}
}
$row = array();
$row['list'] = $list;
$row['page'] = $page;
$row['count'] = $count;
return $row;
}
public function _listFilter($list)
{
session('listaction', ACTION_NAME);
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
$listType = $Bconfig['REPAYMENT_TYPE'];
$BType = $Bconfig['BORROW_TYPE'];
$row = array();
$aUser = get_admin_name();
foreach ($list as $key => $v) {
$v['repayment_type_num'] = $v['repayment_type'];
$v['repayment_type'] = $listType[$v['repayment_type']];
$v['borrow_type'] = $BType[$v['borrow_type']];
if ($v['deadline']) {
$v['overdue'] = getLeftTime($v['deadline']) * -1;
}
if ($v['borrow_status'] == 1 || $v['borrow_status'] == 3 || $v['borrow_status'] == 5) {
$v['deal_uname_2'] = $aUser[$v['deal_user_2']];
$v['deal_uname'] = $aUser[$v['deal_user']];
}
$row[$key] = $v;
}
return $row;
}
function getTBorrowList($parm = array())
{
/* hycd if(empty($parm['map'])) return;
$map = $parm['map'];
$orderby = $parm['orderby'];
if($parm['pagesize'])
{
import( "ORG.Util.Page" );
$count = M("transfer_borrow_info b")->where($map)->count("b.id");
$p = new \Org\Util\Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
}else{
$page = "";
$Lsql = "{$parm['limit']}";
}
$pre = C("DB_PREFIX");
$suffix =C("URL_HTML_SUFFIX");
$field = "b.id,b.borrow_name,b.borrow_status,b.borrow_money,b.repayment_type,b.min_month,b.transfer_out,b.transfer_back,b.transfer_total,b.per_transfer,b.borrow_interest_rate,b.borrow_duration,b.increase_rate,b.reward_rate,b.deadline,b.is_show,m.province,m.city,m.area,m.user_name,m.id as uid,m.credits,m.customer_name,b.borrow_type,b.b_img,b.add_time,b.collect_day,b.danbao,b.online_time";
$list = M("transfer_borrow_info b")->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->where($map)->order($orderby)->limit($Lsql)->select();
print_r($list);
$areaList = getarea();
foreach($list as $key => $v)
{
$list[$key]['location'] = $areaList[$v['province']].$areaList[$v['city']];
$list[$key]['progress'] = getfloatvalue( $v['transfer_out'] / $v['transfer_total'] * 100, 2);
$list[$key]['need'] = getfloatvalue(($v['transfer_total'] - $v['transfer_out'])*$v['per_transfer'], 2 );
$list[$key]['burl'] = MU("Home/invest_transfer", "invest_transfer",array("id" => $v['id'],"suffix" => $suffix));
$temp=floor(("{$v['collect_day']}"*3600*24-time()+"{$v['add_time']}")/3600/24);
$list[$key]['leftdays'] = "{$temp}".'天以上';
$list[$key]['now'] = time();
$list[$key]['borrow_times'] = count(M('transfer_borrow_investor') -> where("borrow_id = {$list[$key]['id']}") ->select());
$list[$key]['investornum'] = M('transfer_borrow_investor')->where("borrow_id={$v['id']}")->count("id");
if($v['danbao']!=0 ){
$list[$key]['danbaoid'] = intval($v['danbao']);
$danbao = M('article')->field('id,title')->where("type_id=7 and id={$v['danbao']}")->find();
$list[$key]['danbao']=$danbao['title'];//担保机构
}else{
$list[$key]['danbao']='暂无担保机构';//担保机构
}
//收益率
$monthData['month_times'] = 12;
$monthData['account'] = $v['borrow_money'];
$monthData['year_apr'] = $v['borrow_interest_rate'];
$monthData['type'] = "all";
$repay_detail = CompoundMonth($monthData);
if($v['borrow_duration']==1){
$list[$key]['shouyi'] = $v['borrow_interest_rate'];
}else{
$list[$key]['shouyi'] = $repay_detail['shouyi'];
}
//收益率结束
}
$row = array();
$row['list'] = $list;
$row['page'] = $page;
return $row;*/
if (empty($parm['map'])) {
return;
}
$map = $parm['map'];
$orderby = $parm['orderby'];
if ($parm['pagesize']) {
//分页处理
import("ORG.Util.Page");
$count = M('borrow_info b')->where($map)->count('b.id');
echo $count;
$p = new \Org\Util\Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
//分页处理
} else {
$page = "";
$Lsql = "{$parm['limit']}";
}
$pre = C('DB_PREFIX');
$suffix = C("URL_HTML_SUFFIX");
$field = "b.id,b.borrow_name,b.borrow_type,b.reward_type,b.borrow_times,b.borrow_status,b.borrow_money,b.borrow_use,b.repayment_type,b.borrow_interest_rate,b.borrow_duration,b.collect_time,b.add_time,b.province,b.has_borrow,b.has_vouch,b.city,b.area,b.reward_type,b.reward_num,b.password,m.user_name,m.id as uid,m.credits,m.customer_name,b.is_tuijian,b.deadline,b.danbao,b.borrow_info,b.risk_control,b.borrow_btype";
$list = M('borrow_info b')->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->where($map)->order($orderby)->limit($Lsql)->select();
$areaList = getArea();
foreach ($list as $key => $v) {
$list[$key]['location'] = $areaList[$v['province']] . $areaList[$v['city']];
$list[$key]['biao'] = $v['borrow_times'];
$list[$key]['need'] = $v['borrow_money'] - $v['has_borrow'];
$list[$key]['leftdays'] = getLeftTime($v['collect_time']);
$list[$key]['bollprogress'] = getFloatValue($v['has_borrow'] / $v['borrow_money'] * 86.90000000000001, 2);
$list[$key]['progress'] = getFloatValue($v['has_borrow'] / $v['borrow_money'] * 100);
$list[$key]['vouch_progress'] = getFloatValue($v['has_vouch'] / $v['borrow_money'] * 100, 2);
$list[$key]['burl'] = MU("Home/invest", "invest", array("id" => $v['id'], "suffix" => $suffix));
//新加
$list[$key]['lefttime'] = $v['collect_time'] - time();
if ($v['deadline'] == 0) {
$endTime = strtotime(date("Y-m-d", time()));
if ($v['repayment_type'] == 1) {
$list[$key]['repaytime'] = strtotime("+{$v['borrow_duration']} day", $endTime);
} else {
$list[$key]['repaytime'] = strtotime("+{$v['borrow_duration']} month", $endTime);
}
} else {
$list[$key]['repaytime'] = $v['deadline'];
//还款时间
}
$list[$key]['publishtime'] = $v['add_time'] + 60 * 60 * 24 * 3;
//预计发标时间=添加时间+1天
if ($v['danbao'] != 0) {
$danbao = M('article')->field("id,title")->where("type_id =7 and id ={$v['danbao']}")->find();
$list[$key]['danbao'] = $danbao['title'];
//担保机构
} else {
$list[$key]['danbao'] = '暂无担保机构';
//担保机构
}
}
$row = array();
$row['list'] = $list;
$row['page'] = $page;
return $row;
}
function getBorrowList($parm = array())
{
if (empty($parm['map'])) {
return;
}
$map = $parm['map'];
$orderby = $parm['orderby'];
if ($parm['pagesize']) {
//分页处理
import("ORG.Util.Page");
//require THINK_PATH.'Lib/Util/page.class.php';
$count = M('borrow_info b')->where($map)->count('b.id');
$p = new Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
//分页处理
} else {
$page = "";
$Lsql = "{$parm['limit']}";
}
$pre = C('DB_PREFIX');
$suffix = C("URL_HTML_SUFFIX");
//$field = "b.id,b.borrow_name,b.topic,b.borrow_type,b.reward_type,b.borrow_times,b.borrow_status,b.borrow_money,b.borrow_use,b.repayment_type,b.borrow_interest_rate,b.borrow_duration,b.collect_time,b.add_time,b.province,b.has_borrow,b.has_vouch,b.city,b.area,b.reward_type,b.reward_num,b.password,m.user_name,m.id as uid,m.credits,m.customer_name,b.is_tuijian,b.deadline,b.danbao,b.borrow_info,b.risk_control";
$field = "b.id,b.borrow_name,b.money_invest_place,b.borrow_type,b.stock_type,b.reward_type,b.borrow_times,b.borrow_status,b.borrow_money,b.borrow_use,b.repayment_type,b.stock_type,b.borrow_interest_rate,b.borrow_duration,b.collect_time,b.add_time,b.province,b.has_borrow,b.has_vouch,b.city,b.area,b.reward_type,b.reward_num,b.password,m.user_name,m.id as uid,m.credits,m.customer_name,b.is_tuijian,b.deadline,b.danbao,b.borrow_info,b.risk_control";
$list = M('borrow_info b')->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->where($map)->order($orderby)->limit($Lsql)->select();
$areaList = getArea();
foreach ($list as $key => $v) {
$list[$key]['location'] = $areaList[$v['province']] . $areaList[$v['city']];
$list[$key]['biao'] = $v['borrow_times'];
$list[$key]['need'] = $v['borrow_money'] - $v['has_borrow'];
$list[$key]['leftdays'] = getLeftTime($v['collect_time']);
$progress = $v['has_borrow'] / $v['borrow_money'] * 100;
$list[$key]['progress'] = $progress > 50 ? floor($progress) : ceil($progress);
//增加floor
//$list[$key]['progress'] = getFloatValue($v['has_borrow']/$v['borrow_money']*100,2);
$list[$key]['vouch_progress'] = getFloatValue($v['has_vouch'] / $v['borrow_money'] * 100, 2);
$list[$key]['burl'] = MU("Home/invest", "invest", array("id" => $v['id'], "suffix" => $suffix));
//新加
$list[$key]['lefttime'] = $v['collect_time'] - time();
if ($v['deadline'] == 0) {
$endTime = strtotime(date("Y-m-d", time()));
if ($v['repayment_type'] == 1) {
$list[$key]['repaytime'] = strtotime("+{$v['borrow_duration']} day", $endTime);
} else {
$list[$key]['repaytime'] = strtotime("+{$v['borrow_duration']} month", $endTime);
}
} else {
$list[$key]['repaytime'] = $v['deadline'];
//还款时间
}
$list[$key]['publishtime'] = $v['add_time'] + 60 * 60 * 24 * 3;
//预计发标时间=添加时间+1天
if ($v['danbao'] != 0) {
$danbao = M('article')->field("id,title")->where("type_id =7 and id ={$v['danbao']}")->find();
$list[$key]['danbao'] = $danbao['title'];
//担保机构
} else {
$list[$key]['danbao'] = '暂无担保机构';
//担保机构
}
}
$row = array();
$row['list'] = $list;
$row['count'] = $count;
$row['page'] = $page;
return $row;
}
function getOrder($parm = array())
{
//echo "387483478";die;
$map = $parm['map'];
$orderby = $parm['orderby'];
if ($parm['pagesize']) {
//分页处理
import("ORG.Util.Page");
$count = M('shares_apply b')->where($map)->count('b.id');
$p = new Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
$row['page']['total'] = ceil($count / $parm['pagesize']);
$row['page']['nowPage'] = isset($_REQUEST['p']) ? $_REQUEST['p'] : 1;
//分页处理
} else {
$page = "";
$Lsql = "{$parm['limit']}";
}
$pre = C('DB_PREFIX');
$suffix = C("URL_HTML_SUFFIX");
$field = "b.id,b.principal,b.manage_fee,b.type_id,b.lever_id,b.shares_money,b.order,b.open,b.alert,b.lever_ratio,b.manage_rate,b.open_ratio,b.alert_ratio,b.surplus_money,b.add_time,b.ip_address,b.status,b.recovery_time,b.already_manage_fee,b.trading_time,b.duration,b.client_user,b.client_pass,b.total_money,b.examine_time,b.deduction_time,b.endtime,b.u_name,b.is_want_open,b.one_manage_fee,b.info,b.stock_admin_id,b.want_open_time,m.user_name,m.id as uid,m.credits,m.customer_name";
$list = M('shares_apply b')->field($field)->join("{$pre}members m ON m.id=b.uid")->where($map)->order($orderby)->limit($Lsql)->select();
//echo M('shares_apply b')->getLastSql();die;
$areaList = getArea();
foreach ($list as $key => $v) {
$list[$key]['location'] = $areaList[$v['province']] . $areaList[$v['city']];
$list[$key]['biao'] = $v['borrow_times'];
$list[$key]['need'] = $v['borrow_money'] - $v['has_borrow'];
$list[$key]['leftdays'] = getLeftTime($v['collect_time']);
$list[$key]['progress'] = getFloatValue($v['has_borrow'] / $v['borrow_money'] * 100, 2);
$list[$key]['vouch_progress'] = getFloatValue($v['has_vouch'] / $v['borrow_money'] * 100, 2);
$list[$key]['burl'] = MU("M/invest", "invest", array("id" => $v['id'], "suffix" => $suffix));
$img = unserialize($v['updata']);
$list[$key]['image'] = $img['0']['img'];
}
$row['list'] = $list;
return $row;
}
function updateArrivalTime($userID, $currentStation, $timestamp, $db)
{
$prevStation = getPreviousStation($userID, $timestamp, $db);
if ($prevStation == '-1') {
return;
}
if ($currentStation == '-1') {
$nextStation = nextStation($userID, $prevStation);
$edge = getEdge($prevStation, $nextStation);
$predictTravelTime = getPredictTravelTime($edge, $db);
if ($predictTravelTime <= 0) {
return;
}
$leftTime = getLeftTime($userID, $nextStation, $predictTravelTime, $timestamp, $db);
storeArrivalTime($userID, $nextStation, $timestamp, $leftTime, $db);
$predictDT = plusSeconds($timestamp, $leftTime);
//echo "<em>Predict</em> userID = $userID Arriving station = $nextStation leftTime = $leftTime predictDT = $predictDT \n ";
} else {
$nextStation = nextStation($userID, $currentStation);
storeArrivalTime($userID, $nextStation, 0, $db);
$cumulativeTime = 0;
for ($iStation = $nextStation; $iStation != $currentStation; $iStation = nextStation($userID, $iStation)) {
$nStation = nextStation($userID, $iStation);
$edge = getEdge($iStation, $nStation);
$predictTravelTime = getPredictTravelTime($edge, $db);
if (isset($predictTravelTime) && $predictTravelTime > 0 && $cumulativeTime >= 0) {
$cumulativeTime += ceil($predictTravelTime);
storeArrivalTime($userID, $nextStation, $timestamp, $cumulativeTime, $db);
$predictDT = plusSeconds($timestamp, $cumulativeTime);
//echo "<em>Predict</em> userID = $userID Arriving station = $iStation cumulativeTime = $cumulativeTime predictDT = $predictDT\n ";
} else {
return;
}
}
}
}
