public function index()
{
$GLOBALS['tmpl']->caching = true;
$GLOBALS['tmpl']->cache_lifetime = 600;
//首页缓存10分钟
$cache_id = md5(MODULE_NAME . ACTION_NAME);
if (!$GLOBALS['tmpl']->is_cached("page/index.html", $cache_id)) {
make_deal_cate_js();
make_delivery_region_js();
change_deal_status();
//获取首页显示白条
//$deal_list = get_deal_list(20,0,"publish_wait =0 AND deal_status in (1,2,4) and is_index_show = 1 "," deal_status ASC, is_recommend DESC,sort DESC,id DESC");
$list = $GLOBALS["db"]->getRow("select * from " . DB_PREFIX . "deal_show where show_left = 1 order by sort desc limit 0,1");
$list["l_time"] = floor((TIME_UTC - $list["create_time"]) / 60);
$GLOBALS['tmpl']->assign("deal_list", $list);
$list1 = $GLOBALS["db"]->getAll("select * from " . DB_PREFIX . "deal_show where show_left = 0 order by sort desc");
foreach ($list1 as $k => $v) {
$list1[$k]["l_time"] = floor((TIME_UTC - $v["create_time"]) / 60);
}
$GLOBALS['tmpl']->assign("deal_list1", $list1);
/*白条类型*/
$loan_type_list = load_auto_cache("deal_loan_type_list");
foreach ($loan_type_list as $k => $v) {
if ($v['credits'] != "") {
$loan_type_list[$k]['credits'] = unserialize($v['credits']);
if (!is_array($loan_type_list[$k]['credits'])) {
$loan_type_list[$k]['credits'] = array();
}
} else {
$loan_type_list[$k]['credits'] = array();
}
}
$GLOBALS['tmpl']->assign('loan_type_list', $loan_type_list);
/*白条金额*/
$debit_conf = $GLOBALS["db"]->getOne("select borrow_amount_cfg from " . DB_PREFIX . "debit_conf");
$debit_conf = unserialize($debit_conf);
$GLOBALS['tmpl']->assign("debit", $debit_conf);
/*月份*/
$level_list = load_auto_cache("level");
$replay_list = $level_list["repaytime_list"];
$GLOBALS['tmpl']->assign("replay_list", reset($replay_list));
}
$GLOBALS['tmpl']->display("debit/debit_index.html", $cache_id);
}
public function index()
{
$GLOBALS['tmpl']->caching = true;
$GLOBALS['tmpl']->cache_lifetime = 600;
//首页缓存10分钟
$cache_id = md5(MODULE_NAME . ACTION_NAME);
if (!$GLOBALS['tmpl']->is_cached("page/index.html", $cache_id)) {
make_deal_cate_js();
make_delivery_region_js();
change_deal_status();
//开始输出友情链接
$f_link_group = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "link_group where is_effect = 1 order by sort desc");
foreach ($f_link_group as $k => $v) {
$g_links = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "link where is_effect = 1 and show_index = 1 and group_id = " . $v['id'] . " order by sort desc");
if ($g_links) {
foreach ($g_links as $kk => $vv) {
if (substr($vv['url'], 0, 7) == 'http://') {
$g_links[$kk]['url'] = str_replace("http://", "", $vv['url']);
}
}
$f_link_group[$k]['links'] = $g_links;
} else {
unset($f_link_group[$k]);
}
}
//最新借款列表
$deal_list = get_deal_list(11, 0, "publish_wait =0 AND deal_status in(1,2,4) ", " deal_status ASC,is_recommend DESC,sort DESC,id DESC");
$GLOBALS['tmpl']->assign("deal_list", $deal_list['list']);
//输出最新转让
$transfer_list = get_transfer_list(11, " and d.deal_status >= 4 ", '', '', " d.create_time DESC , dlt.id DESC ");
$GLOBALS['tmpl']->assign('transfer_list', $transfer_list['list']);
//输出公告
$notice_list = get_notice(7);
$GLOBALS['tmpl']->assign("notice_list", $notice_list);
//输出公司动态
$art_id = $GLOBALS['db']->getOne("SELECT id FROM " . DB_PREFIX . "article_cate where title='公司动态'");
if ($art_id > 0) {
$compnay_active_list = get_article_list(5, $art_id);
$GLOBALS['tmpl']->assign("art_id", $art_id);
$GLOBALS['tmpl']->assign("compnay_active_list", $compnay_active_list['list']);
}
//投资排行
//天
$now_time = to_timespan(to_date(TIME_UTC, "Y-m-d"), "Y-m-d");
$day_load_top_list = $GLOBALS['db']->getAll("SELECT * FROM (SELECT user_name,sum(money) as total_money FROM " . DB_PREFIX . "deal_load where create_time >= " . $now_time . " group by user_id ORDER BY total_money DESC) as tmp LIMIT 5");
//周
$week_time = to_timespan(to_date(TIME_UTC - to_date(TIME_UTC, "w") * 24 * 3600, "Y-m-d"), "Y-m-d");
$week_load_top_list = $GLOBALS['db']->getAll("SELECT * FROM (SELECT user_name,sum(money) as total_money FROM " . DB_PREFIX . "deal_load where create_time >= " . $week_time . " group by user_id ORDER BY total_money DESC) as tmp LIMIT 5 ");
//月
$month_time = to_timespan(to_date(TIME_UTC, "Y-m") . "-01", "Y-m-d");
$month_load_top_list = $GLOBALS['db']->getAll("SELECT * FROM (SELECT user_name,sum(money) as total_money FROM " . DB_PREFIX . "deal_load where create_time >= " . $month_time . " group by user_id ORDER BY total_money DESC) as tmp LIMIT 5");
$GLOBALS['tmpl']->assign("day_load_top_list", $day_load_top_list);
$GLOBALS['tmpl']->assign("week_load_top_list", $week_load_top_list);
$GLOBALS['tmpl']->assign("month_load_top_list", $month_load_top_list);
//收益排名
$load_repay_list = $GLOBALS['db']->getAll("SELECT us.*,u.user_name FROM " . DB_PREFIX . "user_sta us LEFT JOIN " . DB_PREFIX . "user u ON us.user_id=u.id WHERE u.is_effect =1 and u.is_delete=0 and us.load_earnings > 0 ORDER BY us.load_earnings DESC LIMIT 5");
$GLOBALS['tmpl']->assign("load_repay_list", $load_repay_list);
//使用技巧
$use_tech_list = get_article_list(12, 6);
$GLOBALS['tmpl']->assign("use_tech_list", $use_tech_list);
$now = TIME_UTC;
$vote = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "vote where is_effect = 1 and begin_time < " . $now . " and (end_time = 0 or end_time > " . $now . ") order by sort desc limit 1");
$GLOBALS['tmpl']->assign("vote", $vote);
$GLOBALS['tmpl']->assign("f_link_data", $f_link_group);
//累计投资金额
$stats['total_load'] = $GLOBALS['db']->getOne("SELECT sum(money) FROM " . DB_PREFIX . "deal_load where is_repay= 0 ");
$stats['total_load_format'] = format_conf_count(number_format($stats['total_load'], 2));
//成交笔数
$stats['deal_total_count'] = $GLOBALS['db']->getOne("SELECT count(*) FROM " . DB_PREFIX . "deal where deal_status >=4 ");
//累计创造收益
$stats['total_rate'] = $GLOBALS['db']->getOne("SELECT sum(repay_money-self_money) FROM " . DB_PREFIX . "deal_load_repay where has_repay = 1 ");
$stats['total_rate_format'] = format_conf_count(number_format($stats['total_rate'], 2));
//本息保证金（元）
$stats['total_bzh'] = $GLOBALS['db']->getOne("SELECT sum(guarantor_real_freezen_amt+real_freezen_amt) FROM " . DB_PREFIX . "deal where deal_status= 4 ");
$stats['total_bzh_format'] = format_conf_count(number_format($stats['total_bzh'], 2));
//待收资金（元）
$stats['total_repay'] = $GLOBALS['db']->getOne("SELECT sum(repay_money) FROM " . DB_PREFIX . "deal_load_repay where has_repay = 1 ");
$stats['total_repay_format'] = format_conf_count(number_format($stats['total_repay'], 2));
//待投资金（元）
$statsU = $GLOBALS['db']->getRow("SELECT sum(money) as total_usermoney ,count(*) total_user FROM " . DB_PREFIX . "user where is_effect = 1 and is_delete=0 ");
$stats['total_usermoney'] = $statsU['total_usermoney'];
$stats['total_usermoney_format'] = format_conf_count(number_format($stats['total_usermoney'], 2));
$stats['total_user'] = $statsU['total_user'];
$GLOBALS['tmpl']->assign("stats", $stats);
//格式化统计代码
$VIRTUAL_MONEY_1_FORMAT = format_conf_count(floatval(trim(app_conf("VIRTUAL_MONEY_1"))) + $stats['total_load']);
$VIRTUAL_MONEY_2_FORMAT = format_conf_count(floatval(trim(app_conf("VIRTUAL_MONEY_2"))) + $stats['total_rate']);
$VIRTUAL_MONEY_3_FORMAT = format_conf_count(floatval(trim(app_conf("VIRTUAL_MONEY_3"))) + $stats['total_bzh']);
$GLOBALS['tmpl']->assign("VIRTUAL_MONEY_1_FORMAT", $VIRTUAL_MONEY_1_FORMAT);
$GLOBALS['tmpl']->assign("VIRTUAL_MONEY_2_FORMAT", $VIRTUAL_MONEY_2_FORMAT);
$GLOBALS['tmpl']->assign("VIRTUAL_MONEY_3_FORMAT", $VIRTUAL_MONEY_3_FORMAT);
$GLOBALS['tmpl']->assign("show_site_titile", 1);
}
$GLOBALS['tmpl']->display("page/index.html", $cache_id);
}
public function index()
{
$GLOBALS['tmpl']->caching = true;
$GLOBALS['tmpl']->cache_lifetime = 600;
//首页缓存10分钟
$cache_id = md5(MODULE_NAME . ACTION_NAME);
if (!$GLOBALS['tmpl']->is_cached("page/index.html", $cache_id)) {
make_deal_cate_js();
make_delivery_region_js();
change_deal_status();
//借款预告列表
$advance_deal_list = get_deal_list(5, 0, "publish_wait =0 AND deal_status =1 AND is_advance=1 AND start_time >" . TIME_UTC, " deal_status ASC, is_recommend DESC,sort DESC,id DESC");
$GLOBALS['tmpl']->assign("advance_deal_list", $advance_deal_list['list']);
//最新借款列表
$deal_list = get_deal_list(11, 0, "publish_wait =0 AND deal_status in(1,2,4) AND start_time <=" . TIME_UTC, " deal_status ASC, is_recommend DESC,sort DESC,id DESC");
$GLOBALS['tmpl']->assign("deal_list", $deal_list['list']);
//输出最新转让
$transfer_list = get_transfer_list(11, " and d.deal_status >= 4 ", '', '', " d.create_time DESC , dlt.id DESC ");
$GLOBALS['tmpl']->assign('transfer_list', $transfer_list['list']);
//输出公告
$notice_list = get_notice(0);
$GLOBALS['tmpl']->assign("notice_list", $notice_list);
//输出公司动态
$art_id = $GLOBALS['db']->getOne("SELECT id FROM " . DB_PREFIX . "article_cate where title='公司动态'");
if ($art_id > 0) {
$compnay_active_list = get_article_list(5, $art_id);
$GLOBALS['tmpl']->assign("art_id", $art_id);
$GLOBALS['tmpl']->assign("compnay_active_list", $compnay_active_list['list']);
}
//输出媒体报道
$mtbd_id = $GLOBALS['db']->getOne("SELECT id FROM " . DB_PREFIX . "article_cate where title='媒体报道'");
if ($mtbd_id > 0) {
$mtbd_list = get_article_list(5, $mtbd_id);
foreach ($mtbd_list['list'] as $k => $v) {
$mtbd_list['list'][$k]['contents'] = msubstr($mtbd_list['list'][$k]['content'], 0, 25);
}
$GLOBALS['tmpl']->assign("mtbd_id", $mtbd_id);
$GLOBALS['tmpl']->assign("mtbd_list", $mtbd_list['list']);
}
//投资排行
//天
$now_time = to_timespan(to_date(TIME_UTC, "Y-m-d"), "Y-m-d");
$day_load_top_list = $GLOBALS['db']->getAll("SELECT * FROM (SELECT user_name,sum(money) as total_money FROM " . DB_PREFIX . "deal_load where create_time >= " . $now_time . " group by user_id ORDER BY total_money DESC) as tmp LIMIT 10");
//周
$week_time = to_timespan(to_date(TIME_UTC - to_date(TIME_UTC, "w") * 24 * 3600, "Y-m-d"), "Y-m-d");
$week_load_top_list = $GLOBALS['db']->getAll("SELECT * FROM (SELECT user_name,sum(money) as total_money FROM " . DB_PREFIX . "deal_load where create_time >= " . $week_time . " group by user_id ORDER BY total_money DESC) as tmp LIMIT 10 ");
//月
$month_time = to_timespan(to_date(TIME_UTC, "Y-m") . "-01", "Y-m-d");
$month_load_top_list = $GLOBALS['db']->getAll("SELECT * FROM (SELECT user_name,sum(money) as total_money FROM " . DB_PREFIX . "deal_load where create_time >= " . $month_time . " group by user_id ORDER BY total_money DESC) as tmp LIMIT 10");
$GLOBALS['tmpl']->assign("day_load_top_list", $day_load_top_list);
$GLOBALS['tmpl']->assign("week_load_top_list", $week_load_top_list);
$GLOBALS['tmpl']->assign("month_load_top_list", $month_load_top_list);
//收益排名
$load_repay_list = $GLOBALS['db']->getAll("SELECT us.*,u.user_name FROM " . DB_PREFIX . "user_sta us LEFT JOIN " . DB_PREFIX . "user u ON us.user_id=u.id WHERE u.is_effect =1 and u.is_delete=0 and us.load_earnings > 0 ORDER BY us.load_earnings DESC LIMIT 5");
$GLOBALS['tmpl']->assign("load_repay_list", $load_repay_list);
//使用技巧
$use_tech_list = get_article_list(12, 6);
$GLOBALS['tmpl']->assign("use_tech_list", $use_tech_list);
$now = TIME_UTC;
$vote = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "vote where is_effect = 1 and begin_time < " . $now . " and (end_time = 0 or end_time > " . $now . ") order by sort desc limit 1");
$GLOBALS['tmpl']->assign("vote", $vote);
//累计投资金额
$stats['total_load'] = $GLOBALS['db']->getOne("SELECT sum(money) FROM " . DB_PREFIX . "deal_load where is_repay= 0 ");
$stats['total_load_format'] = format_conf_count(number_format($stats['total_load'], 2));
//成交笔数
$stats['deal_total_count'] = $GLOBALS['db']->getOne("SELECT count(*) FROM " . DB_PREFIX . "deal where deal_status >=4 ");
//累计创造收益
$stats['total_rate'] = $GLOBALS['db']->getOne("SELECT sum(true_interest_money + impose_money + true_reward_money - true_manage_money - true_manage_interest_money) FROM " . DB_PREFIX . "deal_load_repay where has_repay = 1 ");
$stats['total_rate'] += $GLOBALS['db']->getOne("SELECT sum(rebate_money) FROM " . DB_PREFIX . "deal_load where is_has_loans = 1 ");
//加上返利
$stats['total_rate'] -= $GLOBALS['db']->getOne("SELECT sum(fee_amount) FROM " . DB_PREFIX . "payment_notice WHERE is_paid =1 ");
//减去充值手续费
$stats['total_rate'] -= $GLOBALS['db']->getOne("SELECT sum(fee) FROM " . DB_PREFIX . "user_carry WHERE status =1 ");
//减去提现手续费
$stats['total_rate'] += $GLOBALS['db']->getOne("SELECT sum(money) FROM " . DB_PREFIX . "referrals WHERE pay_time >0 ");
//加上邀请返利
$stats['total_rate_format'] = format_conf_count(number_format($stats['total_rate'], 2));
//本息保证金（元）
$stats['total_bzh'] = $GLOBALS['db']->getOne("SELECT sum(guarantor_real_freezen_amt+real_freezen_amt) FROM " . DB_PREFIX . "deal where deal_status= 4 ");
$stats['total_bzh_format'] = format_conf_count(number_format($stats['total_bzh'], 2));
//待收资金（元）
$stats['total_repay'] = $GLOBALS['db']->getOne("SELECT sum(repay_money) FROM " . DB_PREFIX . "deal_load_repay where has_repay = 1 ");
$stats['total_repay_format'] = format_conf_count(number_format($stats['total_repay'], 2));
//待投资金（元）
$statsU = $GLOBALS['db']->getRow("SELECT sum(money) as total_usermoney ,count(*) total_user FROM " . DB_PREFIX . "user where is_effect = 1 and is_delete=0 ");
$stats['total_usermoney'] = $statsU['total_usermoney'];
$stats['total_usermoney_format'] = format_conf_count(number_format($stats['total_usermoney'], 2));
$stats['total_user'] = $statsU['total_user'];
$GLOBALS['tmpl']->assign("stats", $stats);
//格式化统计代码
$VIRTUAL_MONEY_1_FORMAT = format_conf_count(floatval(trim(app_conf("VIRTUAL_MONEY_1"))) + $stats['total_load']);
$VIRTUAL_MONEY_2_FORMAT = format_conf_count(floatval(trim(app_conf("VIRTUAL_MONEY_2"))) + $stats['total_rate']);
$VIRTUAL_MONEY_3_FORMAT = format_conf_count(floatval(trim(app_conf("VIRTUAL_MONEY_3"))) + $stats['total_bzh']);
$GLOBALS['tmpl']->assign("VIRTUAL_MONEY_1_FORMAT", $VIRTUAL_MONEY_1_FORMAT);
$GLOBALS['tmpl']->assign("VIRTUAL_MONEY_2_FORMAT", $VIRTUAL_MONEY_2_FORMAT);
$GLOBALS['tmpl']->assign("VIRTUAL_MONEY_3_FORMAT", $VIRTUAL_MONEY_3_FORMAT);
$GLOBALS['tmpl']->assign("show_site_titile", 1);
}
$GLOBALS['tmpl']->display("page/index.html", $cache_id);
}
