public function index()
{
$page = intval($_REQUEST['p']);
if ($page == 0) {
$page = 1;
}
$limit = ($page - 1) * app_conf("PAGE_SIZE") . "," . app_conf("PAGE_SIZE");
$user_id = $GLOBALS['user_info']['id'];
$status = isset($_REQUEST['stauts']) ? intval($_REQUEST['stauts']) : 3;
$time = isset($_REQUEST['time']) ? to_timespan($_REQUEST['time'], "Ymd") : "";
$deal_name = strim($_REQUEST['deal_name']);
$condition = "";
if ($deal_name != "") {
$condition .= " and d.name = '" . $deal_name . "' ";
$GLOBALS['tmpl']->assign('deal_name', $deal_name);
}
if ($time != "") {
$condition .= " and dlr.repay_time = " . $time . " ";
$GLOBALS['tmpl']->assign('time', to_date($time, "Y-m-d"));
}
$result = getUcRepayPlan($user_id, $status, $limit, $condition);
if ($result['rs_count'] > 0) {
$page = new Page($result['rs_count'], app_conf("PAGE_SIZE"));
//初始化分页对象
$p = $page->show();
$GLOBALS['tmpl']->assign('pages', $p);
$GLOBALS['tmpl']->assign('list', $result['list']);
}
$GLOBALS['tmpl']->assign("page_title", $GLOBALS['lang']['UC_REPAY_PLAN']);
$GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_repay_plan.html");
$GLOBALS['tmpl']->assign("status", $status);
$GLOBALS['tmpl']->display("page/uc.html");
}
public function index()
{
$this->init_user();
$user_info = $this->user_data;
$ajax = intval($_REQUEST['ajax']);
if ($ajax == 0) {
$this->init_main();
}
$user_id = intval($GLOBALS['user_info']['id']);
/***统计***/
$user_statics = $user_info['user_statics'];
//债券转让统计
$list_sql = "select sum(CASE WHEN `has_repay`=1 THEN self_money ELSE 0 END ) AS `total_self_money` ,sum(CASE WHEN `has_repay`=1 THEN interest_money ELSE 0 END ) AS `total_interest_money`, " . "sum(CASE WHEN `has_repay`=0 THEN self_money ELSE 0 END ) AS `not_self_money` ,sum(CASE WHEN `has_repay`=0 THEN interest_money ELSE 0 END ) AS `not_interest_money`" . " from " . DB_PREFIX . "deal_load_repay dlr left join " . DB_PREFIX . "deal_load dl on dlr.load_id = dl.id where ((dlr.user_id = " . $user_id . " and dlr.t_user_id = 0) or dlr.t_user_id = " . $user_id . ") and (pP2PBillNo ='' or pP2PBillNo is null) ";
//print_r($list_sql);die;
$transfer_info = $GLOBALS['db']->getRow($list_sql);
$user_statics["load_earnings"] = number_format(floatval($user_statics["load_earnings"]) + floatval($transfer_info["total_interest_money"]), 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"] = floatval($transfer_info["load_wait_self_money"]) + floatval($transfer_info["not_self_money"]);
$user_statics["clear_total_money"] = number_format(round($user_statics["load_wait_self_money"], 2) + round($user_info["money"], 2) + round($user_info["lock_money"], 2) - round($user_statics["need_repay_amount"], 2), 2);
$user_statics["load_wait_self_money"] = number_format($user_statics["load_wait_self_money"]);
//待收收益
$user_statics["load_wait_earnings"] = number_format(floatval($transfer_info["load_wait_earnings"]) + floatval($transfer_info["not_interest_money"]), 2);
$user_statics["ltotal_money"] = number_format(floatval($user_statics["load_wait_repay_money"]) + floatval($user_statics["load_repay_money"]), 2);
$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);
$user_statics["money"] = number_format(floatval($user_info["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']->getRow($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);
$user_statics["load_wait_repay_money"] = number_format(floatval($user_statics["load_wait_repay_money"]), 2);
$user_statics["load_repay_money"] = number_format(floatval($user_statics["load_repay_money"]) + floatval($transfer_info["total_self_money"]), 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["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) {
//近期待还款
$day_deal_repay = getUcDealRepay($user_id, 10, "");
//近期待收款
$day_repay_list = getUcRepayPlan($user_id, 3, 10, "");
//推荐的标
require APP_ROOT_PATH . "app/Lib/deal_func.php";
$where = " is_recommend = 1 and deal_status in (0,1,2)";
$deals_list = get_deal_list(10, 0, $where);
foreach ($deals_list['list'] as $k => $v) {
$deals_list['list'][$k]['repay_time_format'] = $v['repay_time'] . "个月";
$deals_list['list'][$k]['start_time_format'] = to_date($v['start_time'], "Y-m-d");
if ($deals_list['list'][$k]['deal_status'] == 0) {
$deals_list['list'][$k]['deal_status_format'] = "待等材料";
} elseif ($deals_list['list'][$k]['deal_status'] == 1) {
$deals_list['list'][$k]['deal_status_format'] = "进行中";
} elseif ($deals_list['list'][$k]['deal_status'] == 2) {
$deals_list['list'][$k]['deal_status_format'] = "满标";
}
}
$GLOBALS['tmpl']->assign('day_deal_repay', $day_deal_repay['list']);
$GLOBALS['tmpl']->assign('day_repay_list', $day_repay_list['list']);
$GLOBALS['tmpl']->assign('deals_list', $deals_list['list']);
$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");
}
}
