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"); } }