方维3.4专业P2P网络贷款借贷系统投资理财平台网站源码

<?php // +---------------------------------------------------------------------- // | Fanwe 方维p2p借贷系统 // +---------------------------------------------------------------------- // | Copyright (c) 2011 http://www.fanwe.com All rights reserved. // +---------------------------------------------------------------------- // | Author: 云淡风轻(88522820@qq.com) // +---------------------------------------------------------------------- /** * 获取指定的投标 */ function get_deal($id=0,$is_effect=1) { $time = TIME_UTC; if($is_effect == 1) { $ext = " and is_effect = 1 "; } if($id==0) //有ID时不自动获取 { return false; /*$sql = "select id from ".DB_PREFIX."deal where is_effect = 1 and is_delete = 0 "; if($cate_id>0) { $ids =load_auto_cache("deal_sub_parent_cate_ids",array("cate_id"=>$cate_id)); $sql .= " and cate_id in (".implode(",",$ids).")"; } $sql.=" order by sort desc"; $deal = $GLOBALS['db']->getRow($sql); */ } else{ $deal = $GLOBALS['db']->getRow("select * from ".DB_PREFIX."deal where id = ".intval($id)." and is_delete <> 1 $ext"); } if($deal) { if($deal['deal_status']!=3 && $deal['deal_status']!=5) { $temp_data =syn_deal_status($deal['id']); $deal = array_merge($deal,$temp_data); } format_deal_item($deal); } return $deal; } /** * 获取正在进行的投标列表 */ function get_deal_list($limit="",$cate_id=0, $where='',$orderby = '',$user_name='',$user_pwd='',$is_all=false) { $time = TIME_UTC; $count_sql = "select count(*) from ".DB_PREFIX."deal where 1=1 "; if($is_all==false) $count_sql.=" and is_effect = 1 and is_delete = 0 "; if(es_cookie::get("shop_sort_field")=="ulevel"){ $extfield = ",(SELECT u.level_id FROM fanwe_user u WHERE u.id=user_id ) as ulevel"; } $sql = "select *,start_time as last_time,(load_money/borrow_amount*100) as progress_point,(start_time + enddate*24*3600 - ".$time.") as remain_time $extfield from ".DB_PREFIX."deal where 1 = 1 "; if($is_all==false) $sql.=" and is_effect = 1 and is_delete = 0 "; if($cate_id>0) { $ids =load_auto_cache("deal_sub_parent_cate_ids",array("cate_id"=>$cate_id)); $sql .= " and cate_id in (".implode(",",$ids).")"; $count_sql .= " and cate_id in (".implode(",",$ids).")"; } if($where != '') { $sql.=" and ".$where; $count_sql.=" and ".$where; } if($orderby=='') $sql.=" order by sort desc "; else $sql.=" order by ".$orderby; if($limit!=""){ $sql .=" limit ".$limit; } $deals_count = $GLOBALS['db']->getOne($count_sql); if($deals_count > 0){ $deals = $GLOBALS['db']->getAll($sql); //echo $sql; if($deals) { foreach($deals as $k=>$deal) { format_deal_item($deal,$user_name,$user_pwd); $deals[$k] = $deal; } } } else{ $deals = array(); } return array('list'=>$deals,'count'=>$deals_count); } function format_deal_item(&$deal,$user_name="",$user_pwd=""){ //判断是否已经开始 $deal['is_wait'] = 0; if($deal['start_time'] > TIME_UTC){ $deal['is_wait'] = 1; $deal['remain_time'] = $deal['start_time'] - TIME_UTC; } else{ $deal['remain_time'] = $deal['start_time'] + $deal['enddate']*24*3600 - TIME_UTC; } //当为天的时候 if($deal['repay_time_type'] == 0){ $true_repay_time = 1; } else{ $true_repay_time = $deal['repay_time']; } if(trim($deal['titlecolor']) != ''){ $deal['color_name'] = "<span style='color:#".$deal['titlecolor']."'>".$deal['name']."</span>"; } else{ $deal['color_name'] = $deal['name']; } $jkr['user_name'] = $GLOBALS['db']->getOne("select user_name,id from ".DB_PREFIX."user where id=".$deal['user_id']); $deal['uname'] = $jkr['user_name']; //格式化数据 if($deal['apart_borrow_amount']) $deal['borrow_amount_format'] = format_price($deal['apart_borrow_amount']/10000)."万"; else $deal['borrow_amount_format'] = format_price($deal['borrow_amount']/10000)."万"; $deal['load_money_format'] = format_price($deal['load_money']/10000)."万"; $deal['rate_foramt'] = number_format($deal['rate'],2); $deal['create_time_format'] = to_date($deal['create_time'],'Y-m-d'); //$deal['borrow_amount_format_w'] = format_price($deal['borrow_amount']/10000)."万"; $deal['rate_foramt_w'] = number_format($deal['rate'],2)."%"; $deal_repay_rs = deal_repay_money($deal); //本息还款金额 $deal['month_repay_money'] = $deal_repay_rs['month_repay_money']; //最后一期还款 $deal['last_month_repay_money'] = $deal_repay_rs['last_month_repay_money']; $deal['month_repay_money_format'] = format_price($deal['month_repay_money']); //到期还本息管理费 $deal['month_manage_money'] = $deal['borrow_amount']*(float)$deal['manage_fee']/100; $deal['month_manage_money_format'] = format_price($deal['month_manage_money']); //总的多少管理费 if($deal['repay_time_type']==1) $deal['all_manage_money'] = $deal['month_manage_money'] * $deal["repay_time"]; else $deal['all_manage_money'] = $deal['month_manage_money'] ; if(is_last_repay($deal['loantype'])){ $deal['true_month_repay_money'] = $deal['month_repay_money'] + $deal['all_manage_money']; $deal['true_last_month_repay_money'] = $deal['last_month_repay_money'] + $deal['all_manage_money']; } else{ $deal['true_month_repay_money'] = $deal['month_repay_money'] + $deal['month_manage_money']; $deal['true_last_month_repay_money'] = $deal['last_month_repay_money'] + $deal['month_manage_money']; } $deal['true_month_repay_money_format'] = format_price($deal['true_month_repay_money']); //还需多少钱 $deal['need_money'] = format_price($deal['borrow_amount'] - $deal['load_money']); //百分比 $deal['progress_point'] = $deal['load_money']/$deal['borrow_amount']*100; $deal['user'] = get_user("*",$deal['user_id']); if($deal['cate_id'] > 0){ $deal['cate_info'] = $GLOBALS['db']->getRow("select id,name,brief,uname,icon from ".DB_PREFIX."deal_cate where id = ".$deal['cate_id']." and is_effect = 1 and is_delete = 0",false); } if($deal['type_id'] > 0){ $deal['type_info'] = get_loantype_info($deal['type_id']); if($deal['deal_status'] == 0){ $deal['need_credit'] = 0; //0不需要材料，1需要材料 $credits = unserialize($deal['type_info']['credits']); $user_credit = get_user_credit_file($deal['user_id']); foreach($credits as $kk=>$vv){ if($user_credit[$vv]['passed']==0){ $deal['need_credit'] += 1; } } } } if($deal['agency_id'] > 0){ $deal['agency_info'] = get_user("*",$deal['agency_id']); if($deal['agency_info']['view_info']!=""){ $deal['agency_info']['view_info_list'] = unserialize($deal['agency_info']['view_info']); } } if($deal['deal_status'] <> 1 || $deal['remain_time'] <= 0){ $deal['remain_time_format'] = "0".$GLOBALS['lang']['DAY']."0".$GLOBALS['lang']['HOUR']."0".$GLOBALS['lang']['MIN']; } else{ $deal['remain_time_format'] = remain_time($deal['remain_time']); } $deal['min_loan_money_format'] = format_price($deal['min_loan_money']); if($deal['uloadtype'] == 1){ if($deal['buy_count'] == 0) $deal['buy_portion'] = 0; else $deal['buy_portion'] = intval($deal['load_money']/$deal['min_loan_money']); $deal['need_portion'] = intval(($deal['borrow_amount'] - $deal['load_money']) / $deal['min_loan_money']); } if($deal['deal_status']>=4){ //总的必须还多少本息 $deal['remain_repay_money'] = $deal_repay_rs['remain_repay_money']; //还有多少需要还 $deal['need_remain_repay_money'] = floatval($deal['remain_repay_money']) - floatval($deal['repay_money']); //还款进度条 if($deal['remain_repay_money'] > 0) { $deal['repay_progress_point'] = $deal['repay_money']/$deal['remain_repay_money']*100; if($dea