public function init()
{
if (!$GLOBALS['user_info']) {
if ($_REQUEST['ajax'] == 1) {
ajax_return(array("status" => 0, "info" => "请先登录"));
} else {
es_session::set('before_login', $_SERVER['REQUEST_URI']);
app_redirect(url("index", "user#login"));
}
}
$id = intval($_REQUEST['id']);
$this->space_user = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user where id = " . $id . " and is_effect= 1 and is_delete = 0");
$user_id = intval($GLOBALS['user_info']['id']);
if (!$this->space_user) {
showErr($GLOBALS['lang']['USER_NOT_EXISTS']);
}
$focus_data = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user_focus where focus_user_id = " . $user_id . " and focused_user_id = " . $this->space_user['id']);
if ($focus_data) {
$this->space_user['focused'] = 1;
}
$province_str = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "region_conf where id = " . $this->space_user['province_id']);
$city_str = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "region_conf where id = " . $this->space_user['city_id']);
if ($province_str . $city_str == '') {
$user_location = $GLOBALS['lang']['LOCATION_NULL'];
} else {
$user_location = $province_str . " " . $city_str;
}
$this->space_user['fav_count'] = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "topic where user_id = " . $this->space_user['id'] . " and fav_id <> 0");
$this->space_user['user_location'] = $user_location;
$this->space_user['group_name'] = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "user_group where id = " . $this->space_user['group_id'] . " ");
$GLOBALS['tmpl']->assign("space_user", $this->space_user);
$GLOBALS['tmpl']->assign('user_statics', sys_user_status($id, true));
}
public function index()
{
$root = array();
$email = strim($GLOBALS['request']['email']);
//用户名或邮箱
$pwd = strim($GLOBALS['request']['pwd']);
//密码
$id = intval($GLOBALS['request']['id']);
//$user_id = intval($GLOBALS['user_info']['id']);
//检查用户,用户密码
$user = user_check($email, $pwd);
$user_id = intval($user['id']);
if ($user_id > 0) {
require APP_ROOT_PATH . 'app/Lib/deal.php';
$root['user_login_status'] = 1;
$root['response_code'] = 1;
//充值已支付
$root['incharge_count'] = $GLOBALS['db']->getOne("SELECT sum(money) FROM " . DB_PREFIX . "payment_notice where is_paid = 1 and user_id = " . $user_id . " ");
$root['incharge_count'] = format_price($root['incharge_count']);
//提现成功
$root['carry_money'] = $GLOBALS['db']->getOne("SELECT sum(money) FROM " . DB_PREFIX . "user_carry where status = 1 and user_id = " . $user_id . " ");
$root['carry_money'] = format_price($root['carry_money']);
//已付管理费
$root['true_repay_manage_money'] = $GLOBALS['db']->getOne("SELECT sum(true_repay_manage_money) FROM " . DB_PREFIX . "deal_load_repay where has_repay = 1 and user_id = " . $user_id . " ");
$root['true_repay_manage_money'] = format_price($root['true_repay_manage_money']);
$user_statistics = sys_user_status($user_id);
$root['user_statistics'] = $user_statistics;
} else {
$root['response_code'] = 0;
$root['show_err'] = "未登录";
$root['user_login_status'] = 0;
}
$root['program_title'] = "理财统计";
output($root);
}
public function index()
{
$root = array();
$id = intval($GLOBALS['request']['id']);
$deal = get_deal($id);
//send_deal_contract_email($id,$deal,$deal['user_id']); //发送电子协议邮件
$root['deal'] = $deal;
//借款列表
$load_list = $GLOBALS['db']->getAll("SELECT deal_id,user_id,user_name,money,is_auto,create_time FROM " . DB_PREFIX . "deal_load WHERE deal_id = " . $id);
$u_info = get_user("*", $deal['user_id']);
//可用额度
$can_use_quota = get_can_use_quota($deal['user_id']);
$root['can_use_quota'] = $can_use_quota;
$credit_file = get_user_credit_file($deal['user_id']);
$deal['is_faved'] = 0;
/*
if($GLOBALS['user_info']){
$deal['is_faved'] = $GLOBALS['db']->getOne("SELECT count(*) FROM ".DB_PREFIX."deal_collect WHERE deal_id = ".$id." AND user_id=".intval($GLOBALS['user_info']['id']));
if($deal['deal_status'] >=4){
//还款列表
$loan_repay_list = get_deal_load_list($deal);
$root['loan_repay_list']= $loan_repay_list;
foreach($load_list as $k=>$v){
$load_list[$k]['remain_money'] = $v['money'] - $GLOBALS['db']->getOne("SELECT sum(self_money) FROM ".DB_PREFIX."deal_load_repay WHERE user_id=".$v['user_id']." AND deal_id=".$id);
if($load_list[$k]['remain_money'] <=0){
$load_list[$k]['remain_money'] = 0;
$load_list[$k]['status'] = 1;
}
}
}
}*/
$user_statics = sys_user_status($deal['user_id'], true);
$root['user_statics'] = $user_statics;
//借款笔数
$root['load_list'] = $load_list;
$root['credit_file'] = $credit_file;
$root['u_info'] = $u_info;
//工作认证是否过期
$root['expire'] = user_info_expire($u_info);
//留言
$message_list = $GLOBALS['db']->getAll("SELECT title,content,a.create_time,rel_id,a.user_id,a.is_effect,b.user_name FROM " . DB_PREFIX . "message as a left join " . DB_PREFIX . "user as b on a.user_id = b.id WHERE rel_id = " . $id);
$root['message'] = $message_list;
//seo
if ($deal['type_match_row']) {
$seo_title = $deal['seo_title'] != '' ? $deal['seo_title'] : $deal['type_match_row'] . " - " . $deal['name'];
} else {
$seo_title = $deal['seo_title'] != '' ? $deal['seo_title'] : $deal['name'];
}
$root['page_title'] = $seo_title;
$seo_keyword = $deal['seo_keyword'] != '' ? $deal['seo_keyword'] : $deal['type_match_row'] . "," . $deal['name'];
$root['page_keyword'] = $seo_keyword;
$seo_description = $deal['seo_description'] != '' ? $deal['seo_description'] : $deal['name'];
$root['seo_description'] = $seo_description;
output($root);
}
function index()
{
$user_statics = sys_user_status($GLOBALS['user_info']['id']);
$GLOBALS['tmpl']->assign("user_statics", $user_statics);
$GLOBALS['tmpl']->assign("page_title", $GLOBALS['lang']['UC_EARNINGS']);
$GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_earnings.html");
$GLOBALS['tmpl']->display("page/uc.html");
}
function index()
{
$user_statics = sys_user_status($GLOBALS['user_info']['id']);
$user_statics['all_load_money'] = $user_statics['load_earnings'] + $user_statics['reward_money'] + $user_statics['load_tq_impose'] + $user_statics['load_yq_impose'] + $user_statics['rebate_money'] + $user_statics['referrals_money'] - $user_statics['carry_fee_money'] - $user_statics['incharge_fee_money'];
$GLOBALS['tmpl']->assign("user_statics", $user_statics);
$GLOBALS['tmpl']->assign("page_title", $GLOBALS['lang']['UC_EARNINGS']);
$GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_earnings.html");
$GLOBALS['tmpl']->display("page/uc.html");
}
function index()
{
$user_statics = sys_user_status($GLOBALS['user_info']['id']);
$GLOBALS['tmpl']->assign("user_statics", $user_statics);
$GLOBALS['tmpl']->assign("page_title", $GLOBALS['lang']['UC_EARNINGS']);
$load = $GLOBALS['db']->getRow("SELECT sum(money) as total_money FROM " . DB_PREFIX . "deal_load WHERE user_id=" . intval($GLOBALS['user_info']['id']));
$GLOBALS['tmpl']->assign("load", $load);
$GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_earnings.html");
$GLOBALS['tmpl']->display("page/uc.html");
}
function stepone()
{
//检查是否有发布的但是未确认投标的标
if ($GLOBALS['db']->getOne("SELECT * FROM " . DB_PREFIX . "deal WHERE is_delete=0 and publish_wait=1 and user_id=" . $GLOBALS['user_info']['id']) > 0) {
app_redirect(url("index", "borrow#steptwo"));
}
//判断账户信用是否足够
if ($GLOBALS['user_info']['point'] < 0) {
showErr("信用太低，无法借款");
}
$GLOBALS['tmpl']->assign('page_title', $GLOBALS['lang']['APPLY_BORROW']);
$user_statics = sys_user_status($GLOBALS['user_info']['id']);
$GLOBALS['tmpl']->assign("user_statics", $user_statics);
$typeid = intval($_REQUEST['typeid']);
$GLOBALS['tmpl']->assign("typeid", $typeid);
$agreement = app_conf('BORROW_AGREEMENT');
$GLOBALS['tmpl']->assign("agreement", $agreement);
$loan_type_list = load_auto_cache("deal_loan_type_list");
$GLOBALS['tmpl']->assign("loan_type_list", $loan_type_list);
$level = $GLOBALS['db']->getOneCached("SELECT name FROM " . DB_PREFIX . "user_level WHERE id=" . intval($GLOBALS['user_info']['level_id']));
$GLOBALS['tmpl']->assign("level", $level);
$level_list = load_auto_cache("level");
$GLOBALS['tmpl']->assign("level_list", $level_list);
//可用额度
$can_use_quota = get_can_use_quota($GLOBALS['user_info']['id']);
$GLOBALS['tmpl']->assign('can_use_quota', $can_use_quota);
$deal = $GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "deal WHERE (is_delete=2 or is_delete=3) AND user_id=" . $GLOBALS['user_info']['id']);
$GLOBALS['tmpl']->assign("deal", $deal);
$user_view_infos = $GLOBALS['user_info']['view_info'];
$user_view_infos = unserialize($user_view_infos);
$user_view_infoss = array();
$deal_view_info = unserialize($deal['view_info']);
foreach ($user_view_infos as $k => $v) {
//会员自己传的或者管理员勾选的 才会显示
if (intval($v['is_user']) == 1 || isset($deal_view_info[$k])) {
$user_view_infoss[$k] = $v;
$user_view_infoss[$k]['key'] = $k;
if (isset($deal_view_info[$k])) {
$user_view_infoss[$k]['is_selected'] = 1;
}
}
}
$GLOBALS['tmpl']->assign("user_view_info", $user_view_infoss);
//担保机构
$agency_list = $GLOBALS['db']->getAll("SELECT * FROM " . DB_PREFIX . "deal_agency WHERE is_effect = 1");
$GLOBALS['tmpl']->assign("agency_list", $agency_list);
$inc_file = "inc/borrow/stepone.html";
$GLOBALS['tmpl']->assign('inc_file', $inc_file);
$GLOBALS['tmpl']->display("page/borrow_step.html");
}
public function init_user()
{
$this->user_data = $GLOBALS['user_info'];
$province_str = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "region_conf where id = " . $this->user_data['province_id']);
$city_str = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "region_conf where id = " . $this->user_data['city_id']);
if ($province_str . $city_str == '') {
$user_location = $GLOBALS['lang']['LOCATION_NULL'];
} else {
$user_location = $province_str . " " . $city_str;
}
$this->user_data['fav_count'] = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "topic where user_id = " . $this->user_data['id'] . " and fav_id <> 0");
$this->user_data['user_location'] = $user_location;
$this->user_data['group_name'] = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "user_group where id = " . $this->user_data['group_id'] . " ");
$this->user_data['user_statics'] = sys_user_status($GLOBALS['user_info']['id'], false);
$GLOBALS['tmpl']->assign('user_statics', $this->user_data['user_statics']);
}
public function index()
{
$root = array();
$id = intval($GLOBALS['request']['id']);
$deal = get_deal($id);
//send_deal_contract_email($id,$deal,$deal['user_id']); //发送电子协议邮件
$root['deal'] = $deal;
//借款列表
$load_list = $GLOBALS['db']->getAll("SELECT deal_id,user_id,user_name,money,is_auto,create_time FROM " . DB_PREFIX . "deal_load WHERE deal_id = " . $id);
$u_info = get_user("*", $deal['user_id']);
//可用额度
$can_use_quota = get_can_use_quota($deal['user_id']);
$root['can_use_quota'] = $can_use_quota;
$credit_file = get_user_credit_file($deal['user_id']);
$deal['is_faved'] = 0;
$user_statics = sys_user_status($deal['user_id'], true);
$root['user_statics'] = $user_statics;
//借款笔数
$root['load_list'] = $load_list;
$root['credit_file'] = $credit_file;
$root['u_info'] = $u_info;
//工作认证是否过期
$root['expire'] = user_info_expire($u_info);
//留言
$message_list = $GLOBALS['db']->getAll("SELECT a.title,a.content,a.create_time,a.rel_id,a.user_id,a.is_effect,b.user_name FROM " . DB_PREFIX . "message as a left join " . DB_PREFIX . "user as b on a.user_id = b.id WHERE a.rel_id = " . $id);
$root['message'] = $message_list;
//seo
if ($deal['type_match_row']) {
$seo_title = $deal['seo_title'] != '' ? $deal['seo_title'] : $deal['type_match_row'] . " - " . $deal['name'];
} else {
$seo_title = $deal['seo_title'] != '' ? $deal['seo_title'] : $deal['name'];
}
$root['page_title'] = $seo_title;
$seo_keyword = $deal['seo_keyword'] != '' ? $deal['seo_keyword'] : $deal['type_match_row'] . "," . $deal['name'];
$root['page_keyword'] = $seo_keyword;
$seo_description = $deal['seo_description'] != '' ? $deal['seo_description'] : $deal['name'];
$root['seo_description'] = $seo_description;
$root['program_title'] = "详细信息";
output($root);
}
function preview()
{
$deal['id'] = 'XXX';
$deal_loan_type_list = load_auto_cache("deal_loan_type_list");
if (intval($_REQUEST['quota']) == 1) {
$deal = $GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "deal_quota_submit WHERE status=1 and user_id = " . $GLOBALS['user_info']['id'] . " ORDER BY id DESC");
$type_id = intval($deal['type_id']);
$deal['rate_foramt'] = number_format($deal['rate'], 2);
$data['view_info'] = unserialize($deal['view_info']);
if ($deal['cate_id'] > 0) {
$deal['cate_info'] = $GLOBALS['db']->getRowCached("select id,name,brief,uname,icon from " . DB_PREFIX . "deal_cate where id = " . $deal['cate_id'] . " and is_effect = 1 and is_delete = 0");
}
$deal['repay_time'] = strim($_REQUEST['repay_time']);
$deal['repay_time_type'] = 1;
} else {
$deal['name'] = strim($_REQUEST['borrowtitle']);
$type_id = intval($_REQUEST['borrowtype']);
$deal['repay_time_type'] = intval($_REQUEST['repaytime_type']);
$deal['rate_foramt'] = number_format(strim($_REQUEST['apr']), 2);
$deal['repay_time'] = strim($_REQUEST['repaytime']);
$icon_type = strim($_REQUEST['imgtype']);
$icon_type_arr = array('upload' => 1, 'userImg' => 2, 'systemImg' => 3);
$data['icon_type'] = $icon_type_arr[$icon_type];
switch ($data['icon_type']) {
case 1:
$deal['icon'] = replace_public(strim($_REQUEST['icon']));
break;
case 2:
$deal['icon'] = replace_public(get_user_avatar($GLOBALS['user_info']['id'], 'big'));
break;
case 3:
$deal['icon'] = $GLOBALS['db']->getOneCached("SELECT icon FROM " . DB_PREFIX . "deal_loan_type WHERE id=" . intval($_REQUEST['systemimgpath']));
}
$deal['description'] = replace_public(valid_str(bstrim($_REQUEST['borrowdesc'])));
$user_view_info = $GLOBALS['user_info']['view_info'];
$user_view_info = unserialize($user_view_info);
$new_view_info_arr = array();
for ($i = 1; $i <= intval($_REQUEST['file_upload_count']); $i++) {
$img_info = array();
$img = replace_public(strim($_REQUEST['file_' . $i]));
if ($img != "") {
$img_info['name'] = strim($_REQUEST['file_name_' . $i]);
$img_info['img'] = $img;
$img_info['is_user'] = 1;
$user_view_info[] = $img_info;
$ss = $user_view_info;
end($ss);
$key = key($ss);
$new_view_info_arr[$key] = $img_info;
}
}
$data['view_info'] = array();
foreach ($_REQUEST['file_key'] as $k => $v) {
if (isset($user_view_info[$v])) {
$data['view_info'][$v] = $user_view_info[$v];
}
}
foreach ($new_view_info_arr as $k => $v) {
$data['view_info'][$k] = $v;
}
if ($deal['cate_id'] > 0) {
$deal['cate_info']['name'] = "借款预览标";
}
}
$deal['borrow_amount'] = strim($_REQUEST['borrowamount']);
$deal['borrow_amount_format'] = format_price($deal['borrow_amount'] / 10000) . "万";
$GLOBALS['tmpl']->assign('view_info_list', $data['view_info']);
unset($data['view_info']);
foreach ($deal_loan_type_list as $k => $v) {
if ($v['id'] == $type_id) {
$deal['type_info'] = $v;
}
}
$deal['min_loan_money'] = 50;
$deal['need_money'] = $deal['borrow_amount_format'];
//本息还款金额
$deal['month_repay_money'] = format_price(pl_it_formula($deal['borrow_amount'], strim($deal['rate']) / 12 / 100, $deal['repay_time']));
if ($deal['agency_id'] > 0) {
$deal['agency_info'] = $GLOBALS['db']->getRowCached("select * from " . DB_PREFIX . "deal_agency where id = " . $deal['agency_id'] . " and is_effect = 1");
}
$deal['progress_point'] = 0;
$deal['buy_count'] = 0;
$deal['voffice'] = 1;
$deal['vjobtype'] = 1;
$deal['is_delete'] = 2;
$u_info = get_user("*", $GLOBALS['user_info']['id']);
$GLOBALS['tmpl']->assign("u_info", $u_info);
$can_use_quota = get_can_use_quota($GLOBALS['user_info']['id']);
$GLOBALS['tmpl']->assign('can_use_quota', $can_use_quota);
$credit_file = get_user_credit_file($GLOBALS['user_info']['id'], $u_info);
$GLOBALS['tmpl']->assign("credit_file", $credit_file);
$user_statics = sys_user_status($GLOBALS['user_info']['id'], true);
$GLOBALS['tmpl']->assign("user_statics", $user_statics);
$seo_title = $deal['seo_title'] != '' ? $deal['seo_title'] : $deal['type_match_row'] . " - " . $deal['name'];
$GLOBALS['tmpl']->assign("page_title", $seo_title);
$seo_keyword = $deal['seo_keyword'] != '' ? $deal['seo_keyword'] : $deal['type_match_row'] . "," . $deal['name'];
$GLOBALS['tmpl']->assign("page_keyword", $seo_keyword . ",");
$seo_description = $deal['seo_description'] != '' ? $deal['seo_description'] : $deal['name'];
$GLOBALS['tmpl']->assign("seo_description", $seo_description . ",");
$GLOBALS['tmpl']->assign("deal", $deal);
$GLOBALS['tmpl']->display("page/deal.html");
}
public function detail()
{
/*if(!$GLOBALS['user_info']){
app_redirect(url("index","user#login"));
}*/
set_gopreview();
$id = intval($_REQUEST['id']);
$deal_id = $GLOBALS['db']->getOne("SELECT deal_id FROM " . DB_PREFIX . "deal_load_transfer WHERE id=" . $id);
if ($deal_id == 0) {
echo "不存在的债权";
die;
}
$deal = get_deal($deal_id);
syn_transfer_status($id);
$deal['yq_count'] = $GLOBALS['db']->getOne("SELECT count(*) FROM " . DB_PREFIX . "deal_repay WHERE has_repay = 1 and deal_id=" . $deal_id . " AND status >= 2");
$GLOBALS['tmpl']->assign('deal', $deal);
//借款列表
$load_list = $GLOBALS['db']->getAll("SELECT deal_id,user_id,user_name,money,is_auto,create_time FROM " . DB_PREFIX . "deal_load WHERE deal_id = " . $deal_id);
$u_info = get_user("*", $deal['user_id']);
if ($deal['view_info'] != "") {
$view_info_list = unserialize($deal['view_info']);
$GLOBALS['tmpl']->assign('view_info_list', $view_info_list);
}
//可用额度
$can_use_quota = get_can_use_quota($deal['user_id']);
$GLOBALS['tmpl']->assign('can_use_quota', $can_use_quota);
$credit_file = get_user_credit_file($deal['user_id']);
$deal['is_faved'] = 0;
if ($GLOBALS['user_info']) {
if ($u_info['user_type'] == 1) {
$company = $GLOBALS['db']->getRowCached("SELECT * FROM " . DB_PREFIX . "user_company WHERE user_id=" . $u_info['id']);
}
if ($deal['deal_status'] >= 4) {
//还款列表
$loan_repay_list = get_deal_load_list($deal);
$GLOBALS['tmpl']->assign("loan_repay_list", $loan_repay_list);
if ($loan_repay_list) {
$temp_self_money_list = $GLOBALS['db']->getAllCached("SELECT sum(self_money) as total_money,u_key FROM " . DB_PREFIX . "deal_load_repay WHERE has_repay=1 AND deal_id=" . $id . " group by u_key ");
$self_money_list = array();
foreach ($temp_self_money_list as $k => $v) {
$self_money_list[$v['u_key']] = $v['total_money'];
}
foreach ($load_list as $k => $v) {
$load_list[$k]['remain_money'] = $v['money'] - $self_money_list[$k];
if ($load_list[$k]['remain_money'] <= 0) {
$load_list[$k]['remain_money'] = 0;
$load_list[$k]['status'] = 1;
}
}
}
}
$user_statics = sys_user_status($deal['user_id'], true);
$GLOBALS['tmpl']->assign("user_statics", $user_statics);
$GLOBALS['tmpl']->assign("company", $company);
}
$GLOBALS['tmpl']->assign("load_list", $load_list);
$GLOBALS['tmpl']->assign("credit_file", $credit_file);
$GLOBALS['tmpl']->assign("u_info", $u_info);
//工作认证是否过期
$GLOBALS['tmpl']->assign('expire', user_info_expire($u_info));
//留言
require APP_ROOT_PATH . 'app/Lib/message.php';
require APP_ROOT_PATH . 'app/Lib/page.php';
$rel_table = 'transfer';
$message_type = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "message_type where type_name='" . $rel_table . "'");
$condition = "rel_table = '" . $rel_table . "' and rel_id = " . $id;
if (app_conf("USER_MESSAGE_AUTO_EFFECT") == 0) {
$condition .= " and user_id = " . intval($GLOBALS['user_info']['id']);
} else {
if ($message_type['is_effect'] == 0) {
$condition .= " and user_id = " . intval($GLOBALS['user_info']['id']);
}
}
//message_form 变量输出
$GLOBALS['tmpl']->assign('rel_id', $id);
$GLOBALS['tmpl']->assign('rel_table', $rel_table);
//分页
$page = intval($_REQUEST['p']);
if ($page == 0) {
$page = 1;
}
$limit = ($page - 1) * app_conf("PAGE_SIZE") . "," . app_conf("PAGE_SIZE");
$msg_condition = $condition . " AND is_effect = 1 ";
$message = get_message_list($limit, $msg_condition);
$page = new Page($message['count'], app_conf("PAGE_SIZE"));
//初始化分页对象
$p = $page->show();
$GLOBALS['tmpl']->assign('pages', $p);
foreach ($message['list'] as $k => $v) {
$msg_sub = get_message_list("", "pid=" . $v['id'], false);
$message['list'][$k]["sub"] = $msg_sub["list"];
}
$GLOBALS['tmpl']->assign("message_list", $message['list']);
//==================================================
$condition = ' AND dlt.id=' . $id . ' AND d.deal_status >= 4 and d.is_effect=1 and d.is_delete=0 and d.repay_time_type =1 and d.publish_wait=0 ';
$union_sql = " LEFT JOIN " . DB_PREFIX . "deal_load_transfer dlt ON dlt.deal_id = dl.deal_id ";
$transfer = get_transfer($union_sql, $condition);
$GLOBALS['tmpl']->assign('transfer', $transfer);
if ($deal['type_match_row']) {
$seo_title = $deal['seo_title'] != '' ? $deal['seo_title'] : $deal['type_match_row'] . " - " . $deal['name'];
} else {
$seo_title = $deal['seo_title'] != '' ? $deal['seo_title'] : $deal['name'];
}
$GLOBALS['tmpl']->assign("page_title", $GLOBALS['lang']['TRANSFER'] . " - " . $seo_title);
$seo_keyword = $deal['seo_keyword'] != '' ? $deal['seo_keyword'] : $deal['type_match_row'] . "," . $deal['name'];
$GLOBALS['tmpl']->assign("page_keyword", $GLOBALS['lang']['TRANSFER'] . "," . $seo_keyword . ",");
$seo_description = $deal['seo_description'] != '' ? $deal['seo_description'] : $deal['name'];
$GLOBALS['tmpl']->assign("seo_description", $GLOBALS['lang']['TRANSFER'] . "," . $seo_description . ",");
$GLOBALS['tmpl']->assign("deal", $deal);
$GLOBALS['tmpl']->display("page/transfer.html");
}
public function index()
{
$this->init_user();
$user_info = $this->user_data;
$user_info["total_money"] = number_format(floatval($user_info["money"]) + floatval($user_info["lock_money"]), 2);
$user_info["lock_money"] = number_format(floatval($user_info["lock_money"]), 2);
$ajax = intval($_REQUEST['ajax']);
if ($ajax == 0) {
$this->init_main();
}
$user_id = intval($GLOBALS['user_info']['id']);
/***统计***/
$user_statics = sys_user_status($GLOBALS['user_info']['id'], true);
$user_statics["load_earnings"] = number_format(floatval($user_statics["load_earnings"]), 2);
//$user_info["load_wait_repay_amount"] = 0;
$user_statics["need_repay_amount"] = floatval($user_statics["need_repay_amount"]) + floatval($user_statics["need_manage_amount"]);
//待收本金
$user_statics["load_wait_self_money"] = number_format(floatval($user_statics["load_wait_self_money"]), 2);
//待收收益
$user_statics["load_wait_earnings"] = number_format(floatval($user_statics["load_wait_earnings"]), 2);
$user_statics["ltotal_money"] = number_format(floatval($user_statics["load_wait_repay_money"]) + floatval($user_statics["load_repay_money"]), 2);
$user_statics["money"] = number_format(floatval($user_info["money"]), 2);
$user_statics["load_repay_money"] = number_format(floatval($user_statics["load_repay_money"]), 2);
$user_statics["load_wait_repay_money"] = number_format(floatval($user_statics["load_wait_repay_money"]), 2);
$user_statics["need_repay_amount"] = number_format(floatval($user_statics["need_repay_amount"]), 2);
//投标中的
$invest_sql = "SELECT count(*) as l_count,sum(money) as l_money FROM " . DB_PREFIX . "deal_load dl LEFT JOIN " . DB_PREFIX . "deal d ON dl.deal_id = d.id WHERE dl.user_id=" . $user_id . " and d.deal_status in(1,2) group by dl.user_id";
$invest = $GLOBALS['db']->getRowCached($invest_sql);
$user_statics["invest_count"] = $invest["l_count"];
$user_statics["invest_money"] = number_format($invest["l_money"], 2);
$user_statics["total_money"] = number_format(round($invest_sql["money"], 2) + round($user_statics["load_wait_repay_money"], 2) + round($user_statics["load_repay_money"], 2), 2);
//本月
$this_wait_deals = $this->get_loadlist($user_id, " AND DATE_FORMAT(FROM_UNIXTIME(repay_time),'%Y年%m月') = date_format(curdate(),'%Y年%m月')");
$user_statics["this_month_money"] = 0.0;
$user_statics["this_month_count"] = 0;
foreach ($this_wait_deals as $k => $v) {
$user_statics["this_month_money"] += $v["repay_money"];
$user_statics["this_month_count"]++;
}
//下月
$next_wait_deals = $this->get_loadlist($user_id, " AND DATE_FORMAT(FROM_UNIXTIME(repay_time),'%Y年%m月') = date_format(DATE_ADD(curdate(), INTERVAL 1 MONTH),'%Y年%m月')");
$user_statics["next_month_money"] = 0.0;
$user_statics["next_month_count"] = 0;
foreach ($next_wait_deals as $k => $v) {
$user_statics["next_month_money"] += $v["repay_money"];
$user_statics["next_month_count"]++;
}
//本年
$year_wait_deals = $this->get_loadlist($user_id, " AND DATE_FORMAT(FROM_UNIXTIME(repay_time),'%Y') = DATE_FORMAT(curdate(),'%Y')");
$user_statics["year_money"] = 0.0;
$user_statics["year_count"] = 0;
foreach ($year_wait_deals as $k => $v) {
$user_statics["year_money"] += $v["repay_money"];
$user_statics["year_count"]++;
}
//$user_statics["total_invest_money"] = number_format($user_statics["this_month_money"]+$user_statics["next_month_money"]+$user_statics["year_money"],2);
$user_statics["year_money"] = number_format(round($user_statics["year_money"], 2), 2);
$user_statics["this_month_money"] = number_format(round($user_statics["this_month_money"], 2), 2);
$user_statics["next_month_money"] = number_format(round($user_statics["next_month_money"], 2), 2);
//总计
$all_wait_deals = $this->get_loadlist($user_id, '');
$user_statics["total_invest_money"] = 0.0;
$user_statics["total_invest_count"] = 0;
foreach ($all_wait_deals as $k => $v) {
$user_statics["total_invest_money"] += $v["repay_money"];
$user_statics["total_invest_count"]++;
}
$user_statics["total_invest_money"] = number_format($user_statics["total_invest_money"], 2);
//$user_statics["total_invest_count"] = $user_statics["this_month_count"]+$user_statics["next_month_count"]+$user_statics["year_count"];
$load_list_sql = "SELECT * FROM " . DB_PREFIX . "deal_load WHERE user_id = " . $GLOBALS['user_info']['id'] . " ORDER BY id DESC limit 0,4";
//最近交易
$load_list = $GLOBALS['db']->getAllCached($load_list_sql);
$GLOBALS['tmpl']->assign("load_list", $load_list);
//$user_statics["total_money"] = number_format(floatval($user_info["load_wait_repay_money"]) - floatval($user_info["need_repay_amount"]));
$GLOBALS['tmpl']->assign("user_statics", $user_statics);
//最近六个月投资记录
$month = array();
//select month(FROM_UNIXTIME(time)) from table_name group by month(FROM_UNIXTIME(time))
$result['lend'] = $GLOBALS['db']->getAllCached("SELECT count(*) as l_count,sum(money) as l_money,DATE_FORMAT(FROM_UNIXTIME(dl.create_time),'%Y年%m月') as l_month FROM " . DB_PREFIX . "deal_load dl LEFT JOIN " . DB_PREFIX . "deal d ON dl.deal_id = d.id WHERE dl.is_repay = 0 AND dl.user_id=" . $user_id . " and d.deal_status in(1,2,4,5) group by DATE_FORMAT(FROM_UNIXTIME(dl.create_time),'%Y年%m月')");
$months[0]["time"] = to_date(next_replay_month(TIME_UTC, -5), 'Y年m月');
$months[1]["time"] = to_date(next_replay_month(TIME_UTC, -4), 'Y年m月');
$months[2]["time"] = to_date(next_replay_month(TIME_UTC, -3), 'Y年m月');
$months[3]["time"] = to_date(next_replay_month(TIME_UTC, -2), 'Y年m月');
$months[4]["time"] = to_date(next_replay_month(TIME_UTC, -1), 'Y年m月');
$months[5]["time"] = to_date(TIME_UTC, 'Y年m月');
$max_money = 100;
foreach ($result['lend'] as $k => $v) {
if (round($max_money) < round($v["l_money"])) {
$max_money = $v["l_money"];
}
foreach ($months as $kk => $vv) {
if ($vv["time"] == $v["l_month"]) {
$months[$kk]["l_money"] = $v["l_money"];
$months[$kk]["show_money"] = number_format(floatval($v["l_money"]), 2);
}
}
}
foreach ($months as $k => $v) {
$months[$k]["height"] = $v["l_money"] / $max_money * 325;
$months[$k]["bottom"] = $v["l_money"] / $max_money * 325 + 35;
}
$GLOBALS['tmpl']->assign("max_money", $max_money);
$GLOBALS['tmpl']->assign("months", $months);
/***右侧统计结束***/
$GLOBALS['tmpl']->assign("user_data", $user_info);
if ($ajax == 0) {
$GLOBALS['tmpl']->assign("page_title", $GLOBALS['lang']['UC_CENTER_INDEX']);
$GLOBALS['tmpl']->assign("post_title", $GLOBALS['lang']['UC_CENTER_INDEX']);
$GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_center_index.html");
$GLOBALS['tmpl']->display("page/uc.html");
} else {
header("Content-Type:text/html; charset=utf-8");
echo $GLOBALS['tmpl']->fetch("inc/topic_col_list.html");
}
}
function getUCInrepayRepayBorrowMoney($id)
{
$id = intval($id);
$root = array();
$root["status"] = 0;
//0:出错;1:正确;
if ($id == 0) {
$root["show_err"] = "操作失败！";
return $root;
}
$deal = get_deal($id);
if (!$deal) {
$root["show_err"] = "借款不存在！";
return $root;
}
if ($deal['user_id'] != $GLOBALS['user_info']['id']) {
$root["show_err"] = "不属于你的借款！";
return $root;
}
if ($deal['deal_status'] != 4) {
$root["show_err"] = "借款不是还款状态！";
return $root;
}
$time = TIME_UTC;
$impose_money = 0;
//还了几期了
$has_repay_count = $GLOBALS['db']->getOne("SELECT count(*) FROM " . DB_PREFIX . "deal_repay WHERE deal_id=" . $id);
//计算罚息
$loan_list = get_deal_load_list($deal);
$k_repay_time = 0;
foreach ($loan_list as $k => $v) {
if ($k > $has_repay_count - 1) {
if ($k_repay_time == 0) {
$k_repay_time = $v['repay_day'];
}
$impose_money += $v['impose_money'];
}
}
if ($impose_money > 0) {
$root["show_err"] = "请将逾期未还的借款还完才可以进行此操作！";
return $root;
}
//月利率
$rate = $deal['rate'] / 12 / 100;
$impose_money = 0;
//计算剩多少本金
$benjin = $deal['borrow_amount'];
if ($deal['loantype'] == 0) {
//等额本息的时候才通过公式计算剩余多少本金
for ($i = 1; $i <= $has_repay_count; $i++) {
$benjin = $benjin - ($deal['month_repay_money'] - $benjin * $rate);
}
$impose_money = ($benjin - $deal['month_repay_money'] + $benjin * $rate) * (double) trim(app_conf('COMPENSATE_FEE')) / 100;
$total_repay_money = $benjin + $benjin * $rate;
} elseif ($deal['loantype'] == 1) {
//每月付息，到期还本
$impose_money = $benjin * (double) trim(app_conf('COMPENSATE_FEE')) / 100;
$total_repay_money = $benjin + $deal['month_repay_money'];
} elseif ($deal['loantype'] == 2) {
//到期还本息
$impose_money += $benjin * (double) trim(app_conf('COMPENSATE_FEE')) / 100;
$total_repay_money = $benjin + $benjin * $rate;
//计算应缴多罚息 多少管理费
$now_ym = to_date($time, "Y-m");
$i = 0;
foreach ($loan_list as $k => $v) {
++$i;
if ($now_ym == to_date($v['repay_day'], "Y-m")) {
$deal['month_manage_money'] = $benjin * trim(app_conf('MANAGE_FEE')) / 100 * $i;
}
}
}
$GLOBALS['tmpl']->assign("impose_money", $impose_money);
$GLOBALS['tmpl']->assign("total_repay_money", $total_repay_money);
$true_total_repay_money = $total_repay_money + $impose_money + $deal['month_manage_money'];
if ($total_repay_money + $impose_money + $deal['month_manage_money'] > $GLOBALS['user_info']['money']) {
$root["show_err"] = "对不起，您的余额不足！";
return $root;
}
//录入到提前还款列表
$inrepay_data['deal_id'] = $id;
$inrepay_data['user_id'] = $GLOBALS['user_info']['id'];
$inrepay_data['repay_money'] = round($total_repay_money);
$inrepay_data['impose_money'] = round($impose_money, 2);
$inrepay_data['manage_money'] = round($deal['month_manage_money']);
$inrepay_data['repay_time'] = $k_repay_time;
$inrepay_data['true_repay_time'] = $time;
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_inrepay_repay", $inrepay_data, "INSERT");
$inrepay_id = $GLOBALS['db']->insert_id();
if ($inrepay_id == 0) {
$root["show_err"] = "对不起，数据处理失败，请联系客服！";
return $root;
}
//录入还款列表
$after_time = $GLOBALS['db']->getOne("SELECT repay_time FROM " . DB_PREFIX . "deal_repay WHERE deal_id=" . $id . " ORDER BY repay_time DESC");
if ($after_time == "") {
$after_time = $deal['repay_start_time'];
}
$temp_ids[] = array();
for ($i = 0; $i < $deal['repay_time'] - $has_repay_count; $i++) {
$repay_data['id'] = $v['repay_id'];
$repay_data['has_repay'] = 1;
$repay_data['deal_id'] = $id;
$repay_data['user_id'] = $GLOBALS['user_info']['id'];
$repay_data['repay_time'] = $after_time = next_replay_month($after_time);
$repay_data['true_repay_time'] = $time;
$repay_data['status'] = 0;
if ($i == 0) {
$repay_data['repay_money'] = round($deal['month_repay_money'], 2);
$repay_data['impose_money'] = round($impose_money, 2);
$repay_data['manage_money'] = round($deal['month_manage_money']);
} else {
if ($deal['loantype'] == 0) {
//等额本息
$repay_data['repay_money'] = $benjin / ($deal['repay_time'] - $has_repay_count);
} elseif ($deal['loantype'] == 1) {
//每月还息
if ($i + 1 == $deal['repay_time'] - $has_repay_count) {
$repay_data['repay_money'] = $benjin;
} else {
$repay_data['repay_money'] = 0;
}
} elseif ($deal['loantype'] == 2) {
//每月还息
if ($i + 1 == $deal['repay_time'] - $has_repay_count) {
$repay_data['repay_money'] = $benjin;
} else {
$repay_data['repay_money'] = 0;
}
}
$repay_data['impose_money'] = 0;
$repay_data['manage_money'] = 0;
}
$deal_repay_id = $v['repay_id'];
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_repay", $repay_data, "UPDATE", "id=" . $deal_repay_id);
//假如出错 删除掉原来的以插入的数据
if ($GLOBALS['db']->affected_rows() == 0) {
if ($temp_ids) {
$GLOBALS['db']->query("UPDATE " . DB_PREFIX . "deal_repay set has_repay = 0 WHERE id in (" . implode(",", $temp_ids) . ")");
}
$root["show_err"] = "对不起，处理数据失败请联系客服！";
return $root;
} else {
$temp_ids[] = $deal_repay_id;
}
}
//更新用户账户资金记录
require APP_ROOT_PATH . 'system/libs/user.php';
modify_account(array("money" => -round($impose_money)), $GLOBALS['user_info']['id'], "标:" . $deal['id'] . ",提前还款违约金");
modify_account(array("money" => -round($total_repay_money + $deal['month_manage_money'], 2)), $GLOBALS['user_info']['id'], "标:" . $deal['id'] . ",提前还款");
//用户获得额度
modify_account(array("quota" => trim(app_conf('USER_REPAY_QUOTA'))), $GLOBALS['user_info']['id'], "标:" . $deal['id'] . ",还清借款获得额度");
$content = "您好，您在" . app_conf("SHOP_TITLE") . "的借款 “<a href=\"" . $deal['url'] . "\">" . $deal['name'] . "</a>”成功提前还款" . number_format($true_total_repay_money, 2) . "元，";
$content .= "其中违约金为:" . number_format($impose_money, 2) . "元,本笔借款已还款完毕！";
send_user_msg("", $content, 0, $GLOBALS['user_info']['id'], $time, 0, true, 8);
//短信通知
if (app_conf("SMS_ON") == 1 && app_conf('SMS_SEND_REPAY') == 1) {
$sms_content = "尊敬的" . app_conf("SHOP_TITLE") . "用户" . $GLOBALS['user_info']['user_name'] . "，您成功提前还款" . number_format($true_total_repay_money, 2) . "元，其中违约金为:" . number_format($impose_money, 2) . "元,感谢您的关注和支持。【" . app_conf("SHOP_TITLE") . "】";
$msg_data['dest'] = $GLOBALS['user_info']['mobile'];
$msg_data['send_type'] = 0;
$msg_data['title'] = $msg_data['content'] = addslashes($sms_content);
$msg_data['send_time'] = 0;
$msg_data['is_send'] = 0;
$msg_data['create_time'] = $time;
$msg_data['user_id'] = $GLOBALS['user_info']['id'];
$msg_data['is_html'] = 0;
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_msg_list", $msg_data);
//插入
}
//判断获取的信用是否超过限制
if ($GLOBALS['db']->getOne("SELECT sum(point) FROM " . DB_PREFIX . "user_log WHERE (log_info='标:" . $deal['id'] . ",还清借款' or log_info='还清借款') AND user_id=" . $GLOBALS['user_info']['id']) < (int) trim(app_conf('REPAY_SUCCESS_LIMIT'))) {
//获取上一次还款时间
$befor_repay_time = $GLOBALS['db']->getOne("SELECT MAX(log_time) FROM " . DB_PREFIX . "user_log WHERE (log_info='标:" . $deal['id'] . ",还清借款' or log_info='还清借款') AND user_id=" . $GLOBALS['user_info']['id']);
$day = ceil(($time - $befor_repay_time) / 24 / 3600);
//当天数大于等于间隔时间 获得信用
if ($day >= (int) trim(app_conf('REPAY_SUCCESS_DAY'))) {
modify_account(array("point" => trim(app_conf('REPAY_SUCCESS_POINT'))), $GLOBALS['user_info']['id'], "标:" . $deal['id'] . ",还清借款");
}
//用户获得额度
modify_account(array("quota" => trim(app_conf('USER_REPAY_QUOTA'))), $GLOBALS['user_info']['id'], "标:" . $deal['id'] . ",还清借款获得额度");
}
syn_deal_status($id);
sys_user_status($GLOBALS['user_info']['id'], false, true);
//用户回款
$user_loan_list = get_deal_user_load_list($deal);
foreach ($user_loan_list as $lllk => $lllv) {
foreach ($lllv as $kk => $vv) {
//本金
$user_self_money = 0;
//本息
$user_repay_money = 0;
//违约金
$user_impose_money = 0;
//管理费
$user_manage_money = 0;
$in_user_id = $vv['user_id'];
//判断是否转让了债权
if ($vv['t_user_id'] > 0) {
$in_user_id = $vv['t_user_id'];
$loan_user_info['user_name'] = $vv['user_name'];
$loan_user_info['t_email'] = $vv['email'];
$loan_user_info['t_mobile'] = $vv['mobile'];
} else {
$loan_user_info['user_name'] = $vv['t_user_name'];
$loan_user_info['t_email'] = $vv['t_email'];
$loan_user_info['t_mobile'] = $vv['t_mobile'];
}
//借入者已还款，但是没打款到借出用户中心
if ($vv['has_repay'] == 0) {
$user_load_data['deal_id'] = $v['deal_id'];
$user_load_data['user_id'] = $v['user_id'];
$user_load_data['repay_time'] = $vv['repay_day'];
$user_load_data['true_repay_time'] = $time;
$user_load_data['is_site_repay'] = 0;
$user_load_data['status'] = 0;
//小于提前还款按正常还款
if ($vv['repay_day'] < $k_repay_time) {
//等额本息的时候才通过公式计算剩余多少本金
$user_load_data['self_money'] = $vv['self_money'];
$user_load_data['repay_money'] = $vv['month_repay_money'];
$user_load_data['manage_money'] = $vv['month_manage_money'];
$user_load_data['impose_money'] = $vv['impose_money'];
if ($vv['status'] > 0) {
$user_load_data['status'] = $vv['status'] - 1;
}
$content = "您好，您在" . app_conf("SHOP_TITLE") . "的投标 “<a href=\"" . $deal['url'] . "\">" . $deal['name'] . "</a>”成功还款" . number_format($vv['month_repay_money'] + $vv['impose_money'], 2) . "元，";
$unext_loan = $user_loan_list[$kk + 1];
if ($unext_loan) {
$content .= "本笔投标的下个还款日为" . to_date($unext_loan['repay_day'], "Y年m月d日") . "，需要本息" . number_format($unext_loan['month_repay_money'], 2) . "元。";
}
$user_self_money += (double) $user_load_data['self_money'];
if ($user_load_data['impose_money'] != 0 || $user_load_data['manage_money'] != 0 || $user_load_data['repay_money'] != 0) {
//更新用户账户资金记录
modify_account(array("money" => $user_load_data['impose_money']), $in_user_id, "标:" . $deal['id'] . ",期:" . ($kk + 1) . ",逾期罚息");
modify_account(array("money" => -$user_load_data['manage_money']), $in_user_id, "标:" . $deal['id'] . ",期:" . ($kk + 1) . ",投标管理费");
modify_account(array("money" => $user_load_data['repay_money']), $in_user_id, "标:" . $deal['id'] . ",期:" . ($kk + 1) . ",回报本息");
$msg_conf = get_user_msg_conf($in_user_id);
//站内信
if ($msg_conf['sms_bidrepaid'] == 1) {
send_user_msg("", $content, 0, $in_user_id, $time, 0, true, 9);
}
//邮件
if ($msg_conf['mail_bidrepaid'] == 1) {
}
}
} else {
if ($vv['repay_day'] == $k_repay_time) {
if ($deal['loantype'] == 0) {
//等额本息的时候才通过公式计算剩余多少本金
$user_load_data['self_money'] = $vv['month_repay_money'] - get_benjin($kk, $deal['repay_time'], $v['money'], $vv['month_repay_money'], $deal['rate']) * $deal['rate'] / 12 / 100;
$user_load_data['impose_money'] = ($user_load_data['self_money'] - $vv['month_repay_money'] + $user_load_data['self_money'] * $v['rate']) * (double) trim(app_conf('COMPENSATE_FEE')) / 100;
} elseif ($deal['loantype'] == 1) {
//每月还息，到期还本
$user_load_data['self_money'] = $vv['money'];
$user_load_data['impose_money'] = $vv['money'] * floatval(trim($deal['compensate_fee'])) / 100;
} elseif ($deal['loantype'] == 2) {
//每月还息，到期还本
$user_load_data['self_money'] = $vv['money'];
$user_load_data['impose_money'] = $vv['money'] * floatval(trim($deal['compensate_fee'])) / 100;
}
$user_self_money += (double) $user_load_data['self_money'];
if ($deal['loantype'] == 0) {
//等额本息的时候才通过公式计算剩余多少本金
$user_load_data['repay_money'] = $vv['month_repay_money'];
$user_load_data['manage_money'] = $vv['month_manage_money'];
} elseif ($deal['loantype'] == 1) {
$user_load_data['repay_money'] = $vv['month_repay_money'] + $v['money'];
$user_load_data['manage_money'] = $vv['month_manage_money'];
} elseif ($deal['loantype'] == 2) {
$user_load_data['repay_money'] = $vv['money'];
$user_load_data['manage_money'] = $vv['money'] * floatval(trim($deal['user_loan_manage_fee'])) / 100 * ($kk + 1);
}
$user_repay_k = $kk + 1;
} else {
//其他月份
//等额本息
if ($deal['loantype'] == 0) {
if ($user_self_money == 0) {
$user_load_data['self_money'] = $vv['month_repay_money'] - get_benjin($kk, $deal['repay_time'], $v['money'], $vv['month_repay_money'], $deal['rate']) * $deal['rate'] / 12 / 100;
$user_load_data['impose_money'] = ($user_load_data['self_money'] - $vv['month_repay_money'] + $user_load_data['self_money'] * $v['rate']) * (double) trim(app_conf('COMPENSATE_FEE')) / 100;
} else {
$user_load_data['self_money'] = $user_load_data['repay_money'] = ($v['money'] - $user_self_money) / ($v['repay_time'] - $user_repay_k);
$user_load_data['manage_money'] = 0;
$user_load_data['impose_money'] = 0;
}
} elseif ($deal['loantype'] == 1) {
if ($user_self_money == 0) {
$user_self_money = $user_load_data['self_money'] = $v['money'];
$user_load_data['repay_money'] = $vv['month_repay_money'] + $v['money'];
$user_load_data['impose_money'] = $vv['money'] * floatval(trim($deal['compensate_fee'])) / 100;
$user_load_data['manage_money'] = $vv['month_manage_money'];
} else {
$user_load_data['self_money'] = $user_load_data['repay_money'] = 0;
$user_load_data['manage_money'] = 0;
$user_load_data['impose_money'] = 0;
}
} elseif ($deal['loantype'] == 2) {
if ($user_self_money == 0) {
$user_self_money = $user_load_data['self_money'] = $v['money'];
$user_load_data['repay_money'] = $vv['month_repay_money'] + $v['money'];
$user_load_data['impose_money'] = $vv['money'] * floatval(trim($deal['compensate_fee'])) / 100;
$user_load_data['manage_money'] = $vv['money'] * floatval(trim($deal['user_loan_manage_fee'])) / 100 * ($kk + 1);
} else {
$user_load_data['self_money'] = $user_load_data['repay_money'] = 0;
$user_load_data['manage_money'] = 0;
$user_load_data['impose_money'] = 0;
}
}
}
$user_repay_money += (double) $user_load_data['repay_money'];
$user_impose_money += (double) $user_load_data['impose_money'];
$user_manage_money += (double) $user_load_data['manage_money'];
$user_load_data['l_key'] = $kk;
$user_load_data['u_key'] = $k;
}
$user_load_data['has_repay'] = 1;
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_load_repay", $user_load_data, "INSERT");
}
if ($user_repay_money > 0) {
$all_repay_money = number_format($GLOBALS['db']->getOne("SELECT (sum(repay_money)-sum(self_money) + sum(impose_money)) as shouyi FROM " . DB_PREFIX . "deal_load_repay WHERE deal_id=" . $v['deal_id'] . " AND user_id=" . $v['user_id']), 2);
$all_impose_money = number_format($GLOBALS['db']->getOne("SELECT sum(impose_money) FROM " . DB_PREFIX . "deal_load_repay WHERE deal_id=" . $v['deal_id'] . " AND user_id=" . $v['user_id']), 2);
$content = "您好，您在" . app_conf("SHOP_TITLE") . "的投标 “<a href=\"" . $deal['url'] . "\">" . $deal['name'] . "</a>”提前还款,";
$content .= "本次投标共获得收益:" . $all_repay_money . "元,其中违约金为:" . $all_impose_money . "元,本次投标已回款完毕！";
//更新用户账户资金记录
modify_account(array("money" => $user_impose_money), $in_user_id, "标:" . $deal['id'] . ",违约金");
modify_account(array("money" => -$user_manage_money), $in_user_id, "标:" . $deal['id'] . ",投标管理费");
modify_account(array("money" => $user_repay_money), $in_user_id, "标:" . $deal['id'] . ",回报本息");
$msg_conf = get_user_msg_conf($in_user_id);
//短信通知
if (app_conf("SMS_ON") == 1 && app_conf('SMS_REPAY_TOUSER_ON') == 1) {
$tmpl = $GLOBALS['db']->getRowCached("select * from " . DB_PREFIX . "msg_template where name = 'TPL_DEAL_LOAD_REPAY_SMS'");
$tmpl_content = $tmpl['content'];
$notice['user_name'] = $loan_user_info['user_name'];
$notice['deal_name'] = $deal['sub_name'];
$notice['deal_url'] = $deal['url'];
$notice['site_name'] = app_conf("SHOP_TITLE");
$notice['repay_money'] = $vv['month_repay_money'] + $vv['impose_money'];
$notice['all_repay_money'] = $all_repay_money;
$notice['impose_money'] = $all_impose_money;
$GLOBALS['tmpl']->assign("notice", $notice);
$sms_content = $GLOBALS['tmpl']->fetch("str:" . $tmpl_content);
$msg_data['dest'] = $loan_user_info['mobile'];
$msg_data['send_type'] = 0;
$msg_data['title'] = $msg_data['content'] = addslashes($sms_content);
$msg_data['send_time'] = 0;
$msg_data['is_send'] = 0;
$msg_data['create_time'] = $time;
$msg_data['user_id'] = $in_user_id;
$msg_data['is_html'] = 0;
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_msg_list", $msg_data);
//插入
}
//站内信
if ($msg_conf['sms_bidrepaid'] == 1) {
send_user_msg("", $content, 0, $in_user_id, $time, 0, true, 9);
}
//邮件
if ($msg_conf['mail_bidrepaid'] == 1 && app_conf('MAIL_ON') == 1) {
$tmpl = $GLOBALS['db']->getRowCached("select * from " . DB_PREFIX . "msg_template where name = 'TPL_DEAL_LOAD_REPAY_EMAIL'");
$tmpl_content = $tmpl['content'];
$notice['user_name'] = $loan_user_info['user_name'];
$notice['deal_name'] = $deal['sub_name'];
$notice['deal_url'] = $deal['url'];
$notice['site_name'] = app_conf("SHOP_TITLE");
$notice['site_url'] = SITE_DOMAIN . APP_ROOT;
$notice['help_url'] = SITE_DOMAIN . url("index", "helpcenter");
$notice['msg_cof_setting_url'] = SITE_DOMAIN . url("index", "uc_msg#setting");
$notice['repay_money'] = $vv['month_repay_money'] + $vv['impose_money'];
$notice['all_repay_money'] = $all_repay_money;
$notice['impose_money'] = $all_impose_money;
$GLOBALS['tmpl']->assign("notice", $notice);
$msg = $GLOBALS['tmpl']->fetch("str:" . $tmpl_content);
$msg_data['dest'] = $loan_user_info['email'];
$msg_data['send_type'] = 1;
$msg_data['title'] = "“" . $deal['name'] . "”回款通知";
$msg_data['content'] = addslashes($msg);
$msg_data['send_time'] = 0;
$msg_data['is_send'] = 0;
$msg_data['create_time'] = $time;
$msg_data['user_id'] = $in_user_id;
$msg_data['is_html'] = $tmpl['is_html'];
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_msg_list", $msg_data);
//插入
}
}
}
}
$root["status"] = 1;
//0:出错;1:正确;
$root["show_err"] = "操作成功!";
return $root;
}
/**
* 更新 用户回款 计划数据
* @param unknown_type $deal_id
* @param unknown_type $deal_repay_id
*/
function syn_deal_repay_status($deal_id, $deal_repay_id)
{
//has_repay 0未收到还款，1已收到还款
$deal_id = intval($deal_id);
$deal_repay_id = intval($deal_repay_id);
$deal = $GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "deal WHERE id=" . $deal_id);
$deal['url'] = url("index", "deal", array("id" => $deal['id']));
$deal["user"] = $GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "user WHERE id=" . $deal['user_id']);
//未还款记录数
$sql = "select count(*) from " . DB_PREFIX . "deal_load_repay where has_repay = 0 and deal_id = " . $deal_id . " and repay_id = " . $deal_repay_id;
$has_repay_0 = $GLOBALS['db']->getOne($sql);
//已经还款记录数
$sql = "select count(*) from " . DB_PREFIX . "deal_load_repay where has_repay = 1 and deal_id = " . $deal_id . " and repay_id = " . $deal_repay_id;
$has_repay_1 = $GLOBALS['db']->getOne($sql);
//第几期
$kk = $GLOBALS['db']->getOne("select l_key from " . DB_PREFIX . "deal_load_repay where deal_id = " . $deal_id . " and repay_id = " . $deal_repay_id);
//has_repay 0未还,1已还 2部分还款
if ($has_repay_0 == 0 && $has_repay_1 == 0 || $has_repay_0 == 0 && $has_repay_1 > 0) {
$deal_rs_sql = "select sum(true_interest_money) as total_true_interest_money," . "sum(true_self_money) as total_true_self_money," . "sum(true_repay_money) as total_true_repay_money," . "sum(true_repay_manage_money) as total_true_repay_manage_money," . "sum(repay_manage_impose_money) as total_repay_manage_impose_money, " . "sum(impose_money) as total_impose_money " . "from " . DB_PREFIX . "deal_load_repay where deal_id = " . $deal_id . " and repay_id = " . $deal_repay_id;
$deal_rs = $GLOBALS['db']->getRow($deal_rs_sql);
$last_Rs = $GLOBALS['db']->getRow("SELECT `status`,`true_repay_time`,`repay_time` from " . DB_PREFIX . "deal_load_repay where deal_id = " . $deal_id . " and repay_id = " . $deal_repay_id . " ORDER BY `true_repay_time` DESC");
$deal_repay_data['true_repay_money'] = $deal_rs['total_true_repay_money'];
$deal_repay_data['true_manage_money'] = $deal_rs['total_true_repay_manage_money'];
$deal_repay_data['manage_impose_money'] = $deal_rs['total_repay_manage_impose_money'];
$deal_repay_data['true_self_repay'] = $deal_rs['total_true_self_money'];
$deal_repay_data['impose_money'] = $deal_rs['total_impose_money'];
$deal_repay_data['true_interest_money'] = $deal_rs['total_true_interest_money'];
$deal_repay_data['true_repay_time'] = $last_Rs['true_repay_time'];
$deal_repay_data['true_repay_date'] = to_date($last_Rs['true_repay_time']);
$deal_repay_data['status'] = $last_Rs['status'];
$deal_repay_data['has_repay'] = 1;
//返佣金额
$rebate_rs = get_rebate_fee($deal['user_id'], "borrow");
$deal_repay_data['true_manage_money_rebate'] = floatval($deal_repay_data['true_manage_money']) * floatval($rebate_rs['rebate']) / 100;
$true_manage_money_rebate = $deal_repay_data['true_manage_money'] * floatval($rebate_rs['rebate']) / 100;
//借款者返佣
if ($true_manage_money_rebate != 0) {
/*ok*/
$reback_memo = sprintf($GLOBALS['lang']["BORROW_REBATE_LOG"], $deal["url"], $deal["name"], $deal["user"]["user_name"], intval($kk) + 1);
reback_rebate_money($deal['user_id'], $true_manage_money_rebate, "borrow", $reback_memo);
}
require_once APP_ROOT_PATH . "system/libs/user.php";
if ($last_Rs['status'] > 1) {
$impose_day = ceil(($last_Rs['true_repay_time'] - $last_Rs['repay_time'] + 24 * 3600 - 1) / 24 / 3600);
//VIP降级-逾期还款
$type = 2;
$type_info = 5;
$resultdate = syn_user_vip($deal['user_id'], $type, $type_info);
if ($impose_day < app_conf('YZ_IMPSE_DAY')) {
modify_account(array("point" => trim(app_conf('IMPOSE_POINT'))), $deal['user_id'], "[<a href='" . $deal['url'] . "' target='_blank'>" . $deal['name'] . "</a>],第" . ($kk + 1) . "期,逾期还款", 11);
$repay_update_data['status'] = 2;
} else {
modify_account(array("point" => trim(app_conf('YZ_IMPOSE_POINT'))), $deal['user_id'], "[<a href='" . $deal['url'] . "' target='_blank'>" . $deal['name'] . "</a>],第" . ($kk + 1) . "期,严重逾期", 11);
$repay_update_data['status'] = 3;
}
} elseif ($last_Rs['status'] == 1) {
//VIP升级 -正常还款
$type = 1;
$type_info = 3;
$resultdate = syn_user_vip($deal['user_id'], $type, $type_info);
} elseif ($last_Rs['status'] == 0) {
//VIP升级 -提前还款
$type = 1;
$type_info = 4;
$resultdate = syn_user_vip($deal['user_id'], $type, $type_info);
}
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_repay", $deal_repay_data, "UPDATE", "id = " . $deal_repay_id);
$last_repay_key = $kk;
//判断本借款是否还款完毕
if ($GLOBALS['db']->getOne("SELECT count(*) FROM " . DB_PREFIX . "deal_repay WHERE deal_id=" . $deal['id'] . " and l_key=" . $last_repay_key . " AND has_repay <> 1 ") == 0) {
//全部还完
if ($GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "deal_repay WHERE deal_id=" . $deal['id'] . " and has_repay=0 ") == 0) {
//判断获取的信用是否超过限制
if ($GLOBALS['db']->getOne("SELECT sum(point) FROM " . DB_PREFIX . "user_point_log WHERE `type`=6 AND user_id=" . $deal['user_id']) < (int) trim(app_conf('REPAY_SUCCESS_LIMIT'))) {
//获取上一次还款时间
$befor_repay_time = $GLOBALS['db']->getOne("SELECT MAX(create_time) FROM " . DB_PREFIX . "user_point_log WHERE `type`=6 AND user_id=" . $deal['user_id']);
$day = ceil(($last_Rs['true_repay_time'] - $befor_repay_time) / 24 / 3600);
//当天数大于等于间隔时间 获得信用
if ($day >= (int) trim(app_conf('REPAY_SUCCESS_DAY'))) {
modify_account(array("point" => trim(app_conf('REPAY_SUCCESS_POINT'))), $deal['user_id'], "[<a href='" . $deal['url'] . "' target='_blank'>" . $deal['name'] . "</a>],还清借款", 4);
}
}
//用户获得额度
modify_account(array("quota" => trim(app_conf('USER_REPAY_QUOTA'))), $deal['user_id'], "[<a href='" . $deal['url'] . "' target='_blank'>" . $deal['name'] . "</a>],还清借款获得额度", 4);
}
}
sys_user_status(intval($GLOBALS['user_info']['id']), false, true);
syn_deal_status($deal_id);
syn_transfer_status(0, $deal_id);
} else {
if ($has_repay_0 > 0 && $has_repay_1 == 0) {
$sql = "update " . DB_PREFIX . "deal_repay set has_repay = 0 where id = " . $deal_repay_id;
} else {
$sql = "update " . DB_PREFIX . "deal_repay set has_repay = 2 where id = " . $deal_repay_id;
}
}
$GLOBALS['db']->query($sql);
}
function getUCInrepayRepayBorrowMoney($id)
{
$id = intval($id);
$root = array();
$root["status"] = 0;
//0:出错;1:正确;
if ($id == 0) {
$root["show_err"] = "操作失败！";
return $root;
}
$deal = get_deal($id);
if (!$deal) {
$root["show_err"] = "借款不存在！";
return $root;
}
if ($deal['user_id'] != $GLOBALS['user_info']['id']) {
$root["show_err"] = "不属于你的借款！";
return $root;
}
if ($deal['deal_status'] != 4) {
$root["show_err"] = "借款不是还款状态！";
return $root;
}
$time = TIME_UTC;
$impose_money = 0;
//是否有部分还款的
$repay_count_ing = $GLOBALS['db']->getOne("SELECT count(*) FROM " . DB_PREFIX . "deal_repay WHERE has_repay=2 and deal_id=" . $id);
if ($repay_count_ing) {
$root["show_err"] = "请将部分还款的借款还完才可以进行此操作！";
return $root;
}
//计算罚息
$loan_list = get_deal_load_list($deal);
$k_repay_key = -1;
$k_repay_time = 0;
foreach ($loan_list as $k => $v) {
if ($v['has_repay'] == 0) {
if ($k_repay_key == -1) {
$k_repay_key = $v['l_key'];
$k_repay_time = $v['repay_day'];
}
$impose_money += $v['impose_money'];
}
}
if ($impose_money > 0) {
$root["show_err"] = "请将逾期未还的借款还完才可以进行此操作！";
return $root;
}
if ($deal['ips_bill_no'] != "") {
$root["status"] = 2;
$root["jump"] = APP_ROOT . '/index.php?ctl=collocation&act=RepaymentNewTrade&deal_id=' . $deal['id'] . '&l_key=all&from=' . $GLOBALS['request']['from'];
$root['jump'] = str_replace("/mapi", "", SITE_DOMAIN . $root['jump']);
return $root;
}
//还了几期了
$has_repay_count = $GLOBALS['db']->getOne("SELECT count(*) FROM " . DB_PREFIX . "deal_repay WHERE has_repay=1 and deal_id=" . $id);
$loaninfo['deal'] = $deal;
$loaninfo['loanlist'] = $loan_list;
$inrepay_info = inrepay_repay($loaninfo, $has_repay_count);
$true_repay_money = (double) $inrepay_info['true_repay_money'];
$true_self_money = (double) $inrepay_info['true_self_money'];
$impose_money = (double) $inrepay_info['impose_money'];
$true_manage_money = (double) $inrepay_info['true_manage_money'];
$true_total_repay_money = $true_repay_money + $impose_money + $true_manage_money;
if ($true_total_repay_money > $GLOBALS['user_info']['money']) {
$root["show_err"] = "对不起，您的余额不足！";
return $root;
}
//录入到提前还款列表
$inrepay_data['deal_id'] = $id;
$inrepay_data['user_id'] = $GLOBALS['user_info']['id'];
$inrepay_data['repay_money'] = $true_repay_money;
$inrepay_data['self_money'] = $true_self_money;
$inrepay_data['impose_money'] = $impose_money;
$inrepay_data['manage_money'] = $true_manage_money;
$inrepay_data['repay_time'] = $k_repay_time;
$inrepay_data['true_repay_time'] = $time;
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_inrepay_repay", $inrepay_data, "INSERT");
$inrepay_id = $GLOBALS['db']->insert_id();
if ($inrepay_id == 0) {
$root["show_err"] = "对不起，数据处理失败，请联系客服！";
return $root;
}
//录入还款列表
$wait_repay_list = $GLOBALS['db']->getAll("SELECT * FROM " . DB_PREFIX . "deal_repay WHERE deal_id=" . $id . " and has_repay=0 ORDER BY l_key ASC");
$temp_ids = array();
foreach ($wait_repay_list as $k => $v) {
$repay_data = array();
$repay_data['has_repay'] = 1;
$repay_data['true_repay_time'] = $time;
$repay_data['true_repay_date'] = to_date($time);
$repay_data['status'] = 0;
if ($k_repay_key == $v['l_key']) {
$repay_data['true_repay_money'] = $true_repay_money;
$repay_data['impose_money'] = $impose_money;
$repay_data['true_manage_money'] = $true_manage_money;
$repay_data['true_self_money'] = $true_self_money;
$repay_data['true_interest_money'] = $true_repay_money - $true_self_money;
}
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_repay", $repay_data, "UPDATE", "id=" . $v['id']);
//假如出错 删除掉原来的以插入的数据
if ($GLOBALS['db']->affected_rows() == 0) {
if (count($temp_ids) > 0) {
$GLOBALS['db']->query("UPDATE " . DB_PREFIX . "deal_repay SET has_repay=0 WHERE id in " . implode(",", $temp_ids) . "");
make_repay_plan($deal);
}
$root["show_err"] = "对不起，处理数据失败请联系客服！";
return $root;
} else {
$temp_ids[] = $v['id'];
}
}
if (count($temp_ids) == 0) {
$root["show_err"] = "对不起，处理数据失败请联系客服！";
return $root;
}
//更新用户账户资金记录
require APP_ROOT_PATH . 'system/libs/user.php';
modify_account(array("money" => -round($impose_money, 2)), $GLOBALS['user_info']['id'], "[<a href='" . $deal['url'] . "' target='_blank'>" . $deal['name'] . "</a>],提前还款违约金", 6);
modify_account(array("money" => -round($true_manage_money, 2)), $GLOBALS['user_info']['id'], "[<a href='" . $deal['url'] . "' target='_blank'>" . $deal['name'] . "</a>],提前还款管理费", 10);
modify_account(array("money" => -round($true_repay_money, 2)), $GLOBALS['user_info']['id'], "[<a href='" . $deal['url'] . "' target='_blank'>" . $deal['name'] . "</a>],提前还款本息", 6);
//用户获得额度
modify_account(array("quota" => trim(app_conf('USER_REPAY_QUOTA'))), $GLOBALS['user_info']['id'], "[<a href='" . $deal['url'] . "' target='_blank'>" . $deal['name'] . "</a>],还清借款获得额度", 6);
//判断获取的信用是否超过限制
if ($GLOBALS['db']->getOne("SELECT sum(point) FROM " . DB_PREFIX . "user_point_log WHERE `type`=6 AND user_id=" . $GLOBALS['user_info']['id']) < (int) trim(app_conf('REPAY_SUCCESS_LIMIT'))) {
//获取上一次还款时间
$befor_repay_time = $GLOBALS['db']->getOne("SELECT MAX(create_time) FROM " . DB_PREFIX . "user_point_log WHERE `type`=6 AND user_id=" . $GLOBALS['user_info']['id']);
$day = ceil(($time - $befor_repay_time) / 24 / 3600);
//当天数大于等于间隔时间 获得信用
if ($day >= (int) trim(app_conf('REPAY_SUCCESS_DAY'))) {
modify_account(array("point" => trim(app_conf('REPAY_SUCCESS_POINT'))), $GLOBALS['user_info']['id'], "[<a href='" . $deal['url'] . "' target='_blank'>" . $deal['name'] . "</a>],还清借款", 6);
}
}
//用户回款
/**
* 获取某一期的用户还款列表
* array $deal_info 借款信息
* int $user_id 用户ID 为0代表全部
* int $lkey 第几期 -1 全部
* int $ukey 第几个投标人 -1 全部
* int $true_time 真实还款时间
* int $get_type 0 全部 1代表未还的 2 代表已还的
* int $r_type = 0; 返回类型; 1:只返回一个数组; $result['item']
* string $limit; 查询限制数量; 0,20 $result['count']
*/
$user_loan_list = get_deal_user_load_list($deal, 0, -1, -1, $time, 1, 0, '');
foreach ($user_loan_list as $lllk => $lllv) {
//循环用户
//本金
$user_self_money = 0;
//本息
$user_repay_money = 0;
//违约金
$user_impose_money = 0;
//管理费
$user_manage_money = 0;
foreach ($lllv as $kk => $vv) {
//循环期数
$in_user_id = $vv['user_id'];
//判断是否转让了债权
if ((int) $vv['t_user_id'] == 0) {
$loan_user_info['user_name'] = $vv['user_name'];
$loan_user_info['email'] = $vv['email'];
$loan_user_info['mobile'] = $vv['mobile'];
} else {
$in_user_id = $vv['t_user_id'];
$loan_user_info['user_name'] = $vv['t_user_name'];
$loan_user_info['email'] = $vv['t_email'];
$loan_user_info['mobile'] = $vv['t_mobile'];
}
$user_load_data = array();
$user_load_data['true_repay_time'] = $time;
$user_load_data['true_repay_date'] = to_date($time);
$user_load_data['is_site_repay'] = 0;
$user_load_data['status'] = 0;
if ($k_repay_key == $vv['l_key']) {
$loadinfo['deal']['rate'] = $deal['rate'];
$loadinfo['deal']['loantype'] = $deal['loantype'];
$loadinfo['deal']['repay_time'] = $deal['repay_time'];
$loadinfo['deal']['borrow_amount'] = $vv['money'];
$loadinfo['deal']['repay_start_time'] = $deal['repay_start_time'];
$loadinfo['deal']['month_manage_money'] = $vv['manage_money'];
$loadinfo['deal']['month_repay_money'] = $vv['month_repay_money'];
$loadinfo['deal']['compensate_fee'] = $deal['compensate_fee'];
if ($deal['repay_time_type'] == 1) {
$loadinfo['deal']['all_manage_money'] = $vv['manage_money'];
} else {
$loadinfo['deal']['all_manage_money'] = $vv['manage_money'] * $deal['repay_time'];
}
$loadinfo['deal']['repay_time_type'] = $deal['repay_time_type'];
$user_load_rs = inrepay_repay($loadinfo, $has_repay_count);
$user_load_data['true_repay_money'] = $user_load_rs['true_repay_money'];
$user_load_data['true_self_money'] = $user_load_rs['true_self_money'];
$user_load_data['impose_money'] = $user_load_rs['impose_money'];
$user_load_data['true_interest_money'] = $user_load_rs['true_repay_money'] - $user_load_rs['true_self_money'];
$user_load_data['true_manage_money'] = $user_load_rs['true_manage_money'];
$user_load_data['true_repay_manage_money'] = $true_manage_money / count($user_loan_list);
$user_self_money = $user_load_data['true_self_money'];
$user_repay_money = $user_load_data['true_repay_money'];
$user_impose_money = $user_load_data['impose_money'];
$user_manage_money = $user_load_data['true_manage_money'];
}
$user_load_data['has_repay'] = 1;
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_load_repay", $user_load_data, "UPDATE", "id=" . $vv['id']);
}
if ($user_repay_money > 0 || $user_impose_money > 0 || $user_manage_money > 0) {
$all_repay_money = number_format($GLOBALS['db']->getOne("SELECT (sum(repay_money)-sum(self_money) + sum(impose_money)) as shouyi FROM " . DB_PREFIX . "deal_load_repay WHERE has_repay = 1 and deal_id=" . $v['deal_id'] . " AND user_id=" . $v['user_id']), 2);
$all_impose_money = number_format($GLOBALS['db']->getOne("SELECT sum(impose_money) FROM " . DB_PREFIX . "deal_load_repay WHERE has_repay = 1 and deal_id=" . $v['deal_id'] . " AND user_id=" . $v['user_id']), 2);
$content = "您好，您在" . app_conf("SHOP_TITLE") . "的投标 “<a href=\"" . $deal['url'] . "\">" . $deal['name'] . "</a>”提前还款,";
$content .= "本次投标共获得收益:" . $all_repay_money . "元,其中违约金为:" . $all_impose_money . "元,本次投标已回款完毕！";
//更新用户账户资金记录
modify_account(array("money" => $user_repay_money), $in_user_id, "[<a href='" . $deal['url'] . "' target='_blank'>" . $deal['name'] . "</a>],回报本息", 5);
modify_account(array("money" => $user_impose_money), $in_user_id, "[<a href='" . $deal['url'] . "' target='_blank'>" . $deal['name'] . "</a>],提前回收违约金", 7);
modify_account(array("money" => -$user_manage_money), $in_user_id, "[<a href='" . $deal['url'] . "' target='_blank'>" . $deal['name'] . "</a>],投标管理费", 20);
$msg_conf = get_user_msg_conf($in_user_id);
//短信通知
if (app_conf("SMS_ON") == 1 && app_conf('SMS_REPAY_TOUSER_ON') == 1) {
$tmpl = $GLOBALS['db']->getRowCached("select * from " . DB_PREFIX . "msg_template where name = 'TPL_DEAL_LOAD_REPAY_SMS'");
$tmpl_content = $tmpl['content'];
$notice['user_name'] = $loan_user_info['user_name'];
$notice['deal_name'] = $deal['sub_name'];
$notice['deal_url'] = $deal['url'];
$notice['site_name'] = app_conf("SHOP_TITLE");
$notice['repay_money'] = $vv['month_repay_money'] + $vv['impose_money'];
$notice['all_repay_money'] = $all_repay_money;
$notice['impose_money'] = $all_impose_money;
$GLOBALS['tmpl']->assign("notice", $notice);
$sms_content = $GLOBALS['tmpl']->fetch("str:" . $tmpl_content);
$msg_data['dest'] = $loan_user_info['mobile'];
$msg_data['send_type'] = 0;
$msg_data['title'] = $msg_data['content'] = addslashes($sms_content);
$msg_data['send_time'] = 0;
$msg_data['is_send'] = 0;
$msg_data['create_time'] = $time;
$msg_data['user_id'] = $in_user_id;
$msg_data['is_html'] = 0;
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_msg_list", $msg_data);
//插入
}
//站内信
if ($msg_conf['sms_bidrepaid'] == 1) {
send_user_msg("", $content, 0, $in_user_id, $time, 0, true, 9);
}
//邮件
if ($msg_conf['mail_bidrepaid'] == 1 && app_conf('MAIL_ON') == 1) {
$tmpl = $GLOBALS['db']->getRowCached("select * from " . DB_PREFIX . "msg_template where name = 'TPL_DEAL_LOAD_REPAY_EMAIL'");
$tmpl_content = $tmpl['content'];
$notice['user_name'] = $loan_user_info['user_name'];
$notice['deal_name'] = $deal['sub_name'];
$notice['deal_url'] = $deal['url'];
$notice['site_name'] = app_conf("SHOP_TITLE");
$notice['site_url'] = SITE_DOMAIN . APP_ROOT;
$notice['help_url'] = SITE_DOMAIN . url("index", "helpcenter");
$notice['msg_cof_setting_url'] = SITE_DOMAIN . url("index", "uc_msg#setting");
$notice['repay_money'] = $vv['month_repay_money'] + $vv['impose_money'];
$notice['all_repay_money'] = $all_repay_money;
$notice['impose_money'] = $all_impose_money;
$GLOBALS['tmpl']->assign("notice", $notice);
$msg = $GLOBALS['tmpl']->fetch("str:" . $tmpl_content);
$msg_data['dest'] = $loan_user_info['email'];
$msg_data['send_type'] = 1;
$msg_data['title'] = "“" . $deal['name'] . "”回款通知";
$msg_data['content'] = addslashes($msg);
$msg_data['send_time'] = 0;
$msg_data['is_send'] = 0;
$msg_data['create_time'] = $time;
$msg_data['user_id'] = $in_user_id;
$msg_data['is_html'] = $tmpl['is_html'];
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_msg_list", $msg_data);
//插入
}
}
}
$content = "您好，您在" . app_conf("SHOP_TITLE") . "的借款 “<a href=\"" . $deal['url'] . "\">" . $deal['name'] . "</a>”成功提前还款" . number_format($true_total_repay_money, 2) . "元，";
$content .= "其中违约金为:" . number_format($impose_money, 2) . "元,本笔借款已还款完毕！";
send_user_msg("", $content, 0, $GLOBALS['user_info']['id'], $time, 0, true, 8);
//短信通知
if (app_conf("SMS_ON") == 1 && app_conf('SMS_SEND_REPAY') == 1) {
//$sms_content = "尊敬的".app_conf("SHOP_TITLE")."用户".$GLOBALS['user_info']['user_name']."，您成功提前还款".number_format($true_total_repay_money,2)."元，其中违约金为:".number_format($impose_money,2)."元,感谢您的关注和支持。【".app_conf("SHOP_TITLE")."】";
$tmpl = $GLOBALS['db']->getRowCached("select * from " . DB_PREFIX . "msg_template where name = 'TPL_SMS_REPAY_SUCCESS_MSG'");
$tmpl_content = $tmpl['content'];
$notice['user_name'] = $GLOBALS['user_info']['user_name'];
$notice['deal_name'] = $deal['sub_name'];
$notice['site_name'] = app_conf("SHOP_TITLE");
$notice['index'] = $has_repay_count + 1;
$notice['status'] = "成功提前";
$notice['all_money'] = number_format($true_total_repay_money, 2);
$notice['repay_money'] = number_format($true_repay_money, 2);
$notice['impose_money'] = number_format($impose_money, 2);
$notice['manage_money'] = number_format($true_manage_money, 2);
$notice['manage_impose_money'] = 0;
$GLOBALS['tmpl']->assign("notice", $notice);
$msg = $GLOBALS['tmpl']->fetch("str:" . $tmpl_content);
$msg_data['dest'] = $GLOBALS['user_info']['mobile'];
$msg_data['send_type'] = 0;
$msg_data['title'] = "提前还款短信通知";
$msg_data['content'] = $msg;
$msg_data['send_time'] = 0;
$msg_data['is_send'] = 0;
$msg_data['create_time'] = $time;
$msg_data['user_id'] = $GLOBALS['user_info']['id'];
$msg_data['is_html'] = 0;
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_msg_list", $msg_data);
//插入
}
syn_deal_status($id);
sys_user_status($GLOBALS['user_info']['id'], false, true);
$root["status"] = 1;
//0:出错;1:正确;
$root["show_err"] = "操作成功!";
return $root;
}
public function mborrow_stat()
{
$user_statics = sys_user_status($GLOBALS['user_info']['id'], false, true);
$GLOBALS['tmpl']->assign("user_statics", $user_statics);
$GLOBALS['tmpl']->assign("page_title", $GLOBALS['lang']['UC_DEAL_BORROW_STAT']);
$GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_deal_borrow_stat.html");
$GLOBALS['tmpl']->display("uc_deal_mborrow_stat.html");
}
function stepone()
{
//检查是否有发布的但是未确认投标的标
if ($GLOBALS['db']->getOne("SELECT * FROM " . DB_PREFIX . "deal WHERE is_delete=0 and publish_wait=1 and user_id=" . $GLOBALS['user_info']['id']) > 0) {
app_redirect(url("index", "borrow#steptwo"));
}
//判断账户信用是否足够
if ($GLOBALS['user_info']['point'] < 0) {
showErr("信用太低，无法借款");
}
$GLOBALS['tmpl']->assign('page_title', $GLOBALS['lang']['APPLY_BORROW']);
$user_statics = sys_user_status($GLOBALS['user_info']['id']);
$GLOBALS['tmpl']->assign("user_statics", $user_statics);
$typeid = intval($_REQUEST['typeid']);
$GLOBALS['tmpl']->assign("typeid", $typeid);
$agreement = app_conf('BORROW_AGREEMENT');
$GLOBALS['tmpl']->assign("agreement", $agreement);
$loan_type_list = load_auto_cache("deal_loan_type_list");
$GLOBALS['tmpl']->assign("loan_type_list", $loan_type_list);
$loantype_list = load_auto_cache("loantype_list");
$GLOBALS['tmpl']->assign("loantype_list", $loantype_list);
$level = $GLOBALS['db']->getOne("SELECT name FROM " . DB_PREFIX . "user_level WHERE id=" . intval($GLOBALS['user_info']['level_id']));
$GLOBALS['tmpl']->assign("level", $level);
//VIP会员 借款管理费
$load_mfee = $GLOBALS['db']->getOne("SELECT v.load_mfee FROM " . DB_PREFIX . "vip_setting v LEFT JOIN " . DB_PREFIX . "user u ON u.vip_id=v.vip_id where u.vip_state=1 and v.is_effect=1 and u.id='" . $GLOBALS['user_info']['id'] . "'");
if ($load_mfee) {
$manage_fee = $load_mfee;
} else {
$manage_fee = app_conf("MANAGE_FEE");
}
$GLOBALS['tmpl']->assign('manage_fee', $manage_fee);
$level_list = load_auto_cache("level");
$GLOBALS['tmpl']->assign("level_list", $level_list);
$has_day_type = 0;
foreach ($level_list as $k => $v) {
if ($v[1] == 0) {
$has_day_type = 1;
}
}
$GLOBALS['tmpl']->assign("has_day_type", $has_day_type);
//可用额度
$can_use_quota = get_can_use_quota($GLOBALS['user_info']['id']);
$GLOBALS['tmpl']->assign('can_use_quota', $can_use_quota);
$deal = $GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "deal WHERE (is_delete=2 or is_delete=3) AND user_id=" . $GLOBALS['user_info']['id']);
$GLOBALS['tmpl']->assign("deal", $deal);
$user_view_infos = $GLOBALS['user_info']['view_info'];
$user_view_infos = unserialize($user_view_infos);
$user_view_infoss = array();
$deal_view_info = unserialize($deal['view_info']);
foreach ($user_view_infos as $k => $v) {
//会员自己传的或者管理员勾选的 才会显示
if (intval($v['is_user']) == 1 || isset($deal_view_info[$k])) {
$user_view_infoss[$k] = $v;
$user_view_infoss[$k]['key'] = $k;
if (isset($deal_view_info[$k])) {
$user_view_infoss[$k]['is_selected'] = 1;
}
}
}
$GLOBALS['tmpl']->assign("user_view_info", $user_view_infoss);
//担保机构
$agency_list = $GLOBALS['db']->getAll("SELECT * FROM " . DB_PREFIX . "user WHERE is_effect = 1 AND user_type=2 ");
$GLOBALS['tmpl']->assign("agency_list", $agency_list);
$json_data = $level_list['repaytime_list'][$GLOBALS['user_info']['level_id']];
$GLOBALS['tmpl']->assign('json_data', json_encode($json_data));
$inc_file = "inc/borrow/stepone.html";
$GLOBALS['tmpl']->assign('inc_file', $inc_file);
$GLOBALS['tmpl']->display("page/borrow_step.html");
}
public function index()
{
$root = array();
//set_gopreview();
$deal_id = intval($GLOBALS['request']['id']);
$root['deal_id'] = $deal_id;
if ($deal_id == 0) {
echo "不存在的债权";
die;
}
$deal = get_deal($deal_id);
//syn_transfer_status($id);
$deal['yq_count'] = $GLOBALS['db']->getOne("SELECT count(*) FROM " . DB_PREFIX . "deal_repay WHERE has_repay = 1 and deal_id=" . $deal_id . " AND status >= 2");
$root['deal'] = $deal;
//借款列表
$load_list = $GLOBALS['db']->getAll("SELECT deal_id,user_id,user_name,money,is_auto,create_time FROM " . DB_PREFIX . "deal_load WHERE deal_id = " . $deal_id);
$u_info = get_user("*", $deal['user_id']);
//可用额度
$can_use_quota = get_can_use_quota($deal['user_id']);
$root['can_use_quota'] = $can_use_quota;
$credit_file = get_user_credit_file($deal['user_id']);
$deal['is_faved'] = 0;
$user_statics = sys_user_status($deal['user_id'], true);
$root['user_statics'] = $user_statics;
$root['load_list'] = $load_list;
$root['credit_file'] = $credit_file;
$root['u_info'] = $u_info;
//工作认证是否过期
$root['expire'] = user_info_expire($u_info);
//留言
$message_list = $GLOBALS['db']->getAll("SELECT title,content,a.create_time,rel_id,a.user_id,a.is_effect,b.user_name FROM " . DB_PREFIX . "message as a left join " . DB_PREFIX . "user as b on a.user_id = b.id WHERE rel_id = " . $id);
$root['message'] = $message_list;
/*
//分页
$page = intval($_REQUEST['p']);
if($page==0)
$page = 1;
$limit = (($page-1)*app_conf("PAGE_SIZE")).",".app_conf("PAGE_SIZE");
$msg_condition = $condition." AND is_effect = 1 ";
$message = get_message_list($limit,$msg_condition);
$page = new Page($message['count'],app_conf("PAGE_SIZE")); //初始化分页对象
$p = $page->show();
$root['pages']= $p;
*/
foreach ($message['list'] as $k => $v) {
$msg_sub = get_message_list("", "pid=" . $v['id'], false);
$message['list'][$k]["sub"] = $msg_sub["list"];
}
$root['message_list'] = $message['list'];
$condition = ' AND dlt.id=' . $id . ' AND d.deal_status >= 4 and d.is_effect=1 and d.is_delete=0 and d.repay_time_type =1 and d.publish_wait=0 ';
$union_sql = " LEFT JOIN " . DB_PREFIX . "deal_load_transfer dlt ON dlt.deal_id = dl.deal_id ";
$transfer = get_transfer($union_sql, $condition);
$root['transfer'] = $transfer;
if ($deal['type_match_row']) {
$seo_title = $deal['seo_title'] != '' ? $deal['seo_title'] : $deal['type_match_row'] . " - " . $deal['name'];
} else {
$seo_title = $deal['seo_title'] != '' ? $deal['seo_title'] : $deal['name'];
}
$root['page_title'] = $seo_title;
$seo_keyword = $deal['seo_keyword'] != '' ? $deal['seo_keyword'] : $deal['type_match_row'] . "," . $deal['name'];
$root['page_keyword'] = $seo_keyword;
$seo_description = $deal['seo_description'] != '' ? $deal['seo_description'] : $deal['name'];
$root['seo_description'] = $seo_description;
output($root);
}