public function index()
{
$root = array();
$root['response_code'] = 1;
//print_r($GLOBALS['db_conf']); exit;
$root['kf_phone'] = $GLOBALS['m_config']['kf_phone'];
//客服电话
$root['kf_email'] = $GLOBALS['m_config']['kf_email'];
//客服邮箱
//$pattern = "/<img([^>]*)\/>/i";
//$replacement = "<img width=300 $1 />";
//$goods['goods_desc'] = preg_replace($pattern, $replacement, get_abs_img_root($goods['goods_desc']));
//关于我们(填文章ID)
$root['about_info'] = intval($GLOBALS['m_config']['about_info']);
$root['version'] = VERSION;
//接口版本号int
$root['page_size'] = PAGE_SIZE;
//默认分页大小
$root['program_title'] = $GLOBALS['m_config']['program_title'];
$root['site_domain'] = str_replace("/mapi", "", SITE_DOMAIN . APP_ROOT);
//站点域名;
$root['site_domain'] = str_replace("http://", "", $root['site_domain']);
//站点域名;
$root['site_domain'] = str_replace("https://", "", $root['site_domain']);
//站点域名;
//$root['newslist'] = $GLOBALS['m_config']['newslist'];
//累计投资金额
$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);
$root['virtual_money_1'] = strip_tags($GLOBALS['db_conf']['VIRTUAL_MONEY_1'] + $stats['total_load']);
//虚拟的累计成交额;
$root['virtual_money_2'] = strip_tags($GLOBALS['db_conf']['VIRTUAL_MONEY_2'] + $stats['total_rate']);
//虚拟的累计创造收益;
$root['virtual_money_3'] = strip_tags($GLOBALS['db_conf']['VIRTUAL_MONEY_3'] + $stats['total_bzh']);
//虚拟的本息保障金;
$index_list = $GLOBALS['cache']->get("MOBILE_INDEX_ADVS");
if (true || $index_list === false) {
$advs = $GLOBALS['db']->getAll(" select * from " . DB_PREFIX . "m_adv where status = 1 order by sort desc ");
$adv_list = array();
$deal_list = array();
$condition = "-1";
foreach ($advs as $k => $v) {
if ($v['page'] == 'top') {
/*
$adv_list[]['id'] = $v['id'];
$adv_list[]['name'] = $v['name'];
if ($v['page'] == 'top' && $v['img'] != ''){
$adv_list[]['img'] = get_abs_img_root(get_spec_image($v['img'],640,240,1));
}else{
$adv_list[]['img'] = '';
}
$adv_list[]['type'] = $v['type'];
$adv_list[]['open_url_type'] = $v['open_url_type'];
$adv_list[]['data'] = $v['data'];
*/
if ($v['img'] != '') {
$v['img'] = get_abs_img_root(get_spec_image($v['img'], 640, 240, 1));
}
$adv_list[] = $v;
} else {
/*
$deal_list[]['id'] = $v['id'];
$deal_list[]['name'] = $v['name'];
$deal_list[]['img'] = '';
$deal_list[]['type'] = $v['type'];
$deal_list[]['open_url_type'] = $v['open_url_type'];
$deal_list[]['data'] = $v['data'];
*/
//$v['img'] = '';
//$deal_list[] = $v;
$condition .= "," . intval($v['data']);
}
}
//$condition = " id in (".$condition.")";
//publish_wait 0:已审核 1:等待审核;deal_status 0待等材料，1进行中，2满标，3流标，4还款中，5已还清
$condition = " publish_wait = 0 AND deal_status in (1,2,4,5)";
require APP_ROOT_PATH . 'app/Lib/deal.php';
$limit = "0,5";
$orderby = "deal_status ASC,sort DESC,id DESC";
//print_r($limit);
//print_r($condition);
$result = get_deal_list($limit, 0, $condition, $orderby);
$index_list['adv_list'] = $adv_list;
$index_list['deal_list'] = $result['list'];
$GLOBALS['cache']->set("MOBILE_INDEX_ADVS", $index_list);
}
$root['index_list'] = $index_list;
$root['deal_cate_list'] = getDealCateArray();
//分类
if (strim($GLOBALS['m_config']['sina_app_key']) != "" && strim($GLOBALS['m_config']['sina_app_secret']) != "") {
$root['api_sina'] = 1;
$root['sina_app_key'] = $GLOBALS['m_config']['sina_app_key'];
$root['sina_app_secret'] = $GLOBALS['m_config']['sina_app_secret'];
$root['sina_bind_url'] = $GLOBALS['m_config']['sina_bind_url'];
}
if (strim($GLOBALS['m_config']['tencent_app_key']) != "" && strim($GLOBALS['m_config']['tencent_app_secret']) != "") {
$root['api_tencent'] = 1;
$root['tencent_app_key'] = $GLOBALS['m_config']['tencent_app_key'];
$root['tencent_app_secret'] = $GLOBALS['m_config']['tencent_app_secret'];
$root['tencent_bind_url'] = $GLOBALS['m_config']['tencent_bind_url'];
}
output($root);
}
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);
}
