public function daijin_index()
{
$GLOBALS['tmpl']->caching = true;
$GLOBALS['tmpl']->cache_lifetime = 600;
//代金券首页缓存10分钟
$cache_id = md5(MODULE_NAME . ACTION_NAME . $GLOBALS['deal_city']['id']);
if (!$GLOBALS['tmpl']->is_cached('daijin_index.html', $cache_id)) {
make_deal_cate_js();
make_deal_region_js();
$result = load_auto_cache("byouhui_filter_nav_cache", array('city_id' => $GLOBALS['deal_city']['id']));
$GLOBALS['tmpl']->assign("cate_list", $result['cate_list']);
$GLOBALS['tmpl']->assign("area_list", $result['area_list']);
//输出右侧的优惠列表
$result = search_youhui_list(5, 0, "", "", false, "", $GLOBALS['deal_city']['id']);
$daijin_list = $result['list'];
$GLOBALS['tmpl']->assign("daijin_list", $daijin_list);
$right_daijin_html = $GLOBALS['tmpl']->fetch("index/index_right_daijin.html");
$GLOBALS['tmpl']->assign("right_daijin_html", $right_daijin_html);
//输出右侧商家
$city_ids = load_auto_cache("deal_city_belone_ids", array("city_id" => intval($GLOBALS['deal_city']['id'])));
if ($city_ids) {
$store_list = $GLOBALS['db']->getAll("SELECT * FROM " . DB_PREFIX . "supplier_location use index(avg_point) WHERE city_id in(" . implode(",", $city_ids) . ") and is_effect = 1 order by avg_point desc limit 5");
} else {
$store_list = $GLOBALS['db']->getAll("SELECT * FROM " . DB_PREFIX . "supplier_location use index(avg_point) WHERE is_effect = 1 order by avg_point desc limit 5");
}
$GLOBALS['tmpl']->assign("store_list", $store_list);
$right_store_html = $GLOBALS['tmpl']->fetch("index/index_right_store.html");
$GLOBALS['tmpl']->assign("right_store_html", $right_store_html);
//输出左侧推荐分类
$recommend_cate = $GLOBALS['db']->getAll("select id,name from " . DB_PREFIX . "deal_cate where rec_daijin = 1 order by sort desc");
$recommend_cate_html = "";
foreach ($recommend_cate as $cate) {
$daijin_list = search_youhui_list(8, $cate['id'], "", "", false, "", $GLOBALS['deal_city']['id']);
$daijin_list = $daijin_list['list'];
$GLOBALS['tmpl']->assign("daijin_list", $daijin_list);
$scate_list = $GLOBALS['db']->getAll("select t.* from " . DB_PREFIX . "deal_cate_type as t left join " . DB_PREFIX . "deal_cate_type_link as l on l.deal_cate_type_id = t.id where t.is_recommend = 1 and l.cate_id = " . $cate['id'] . " order by sort desc");
$GLOBALS['tmpl']->assign("scate_list", $scate_list);
$GLOBALS['tmpl']->assign("bcate_item", $cate);
$recommend_cate_html .= $GLOBALS['tmpl']->fetch("inc/recommend_cate_daijin.html");
}
$GLOBALS['tmpl']->assign("recommend_cate_html", $recommend_cate_html);
}
$GLOBALS['tmpl']->display("daijin_index.html", $cache_id);
}
public function index()
{
$GLOBALS['tmpl']->caching = true;
$GLOBALS['tmpl']->cache_lifetime = 600;
//首页缓存10分钟
$cache_id = md5(MODULE_NAME . ACTION_NAME . $GLOBALS['deal_city']['id']);
if (!$GLOBALS['tmpl']->is_cached('index.html', $cache_id)) {
//输出商城分类
$cate_tree = get_cate_tree(0, 1);
$GLOBALS['tmpl']->assign("cate_tree", $cate_tree);
make_deal_cate_js();
make_deal_region_js();
$result = load_auto_cache("store_filter_nav_cache", array('city_id' => $GLOBALS['deal_city']['id']));
$GLOBALS['tmpl']->assign("cate_list", $result['cate_list']);
$GLOBALS['tmpl']->assign("area_list", $result['area_list']);
//获取推荐品牌
$brand_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "brand order by sort limit 24");
$GLOBALS['tmpl']->assign("brand_list", $brand_list);
//输出公告
$notice_list = get_notice(0, array(0, 1));
$GLOBALS['tmpl']->assign("notice_list", $notice_list);
/**
//获取推荐的大分类
$bcate_list = load_dynamic_cache("INDEX_RECOMMEND_BCATE");
if($bcate_list===false)
{
$bcate_list = $GLOBALS['db']->getAll("select * from ".DB_PREFIX."deal_cate where is_effect = 1 and is_delete = 0 and recommend = 1 order by sort desc limit 8");
set_dynamic_cache("INDEX_RECOMMEND_BCATE",$bcate_list);
}
* **/
$city_id = $GLOBALS['deal_city']['id'];
$shop_cates = $GLOBALS['db']->getAll("select * from tb_shop_cate where grade = 0 and recommend=1 and is_delete=0 order by sort desc");
if (!empty($shop_cates)) {
foreach ($shop_cates as $index => $shop_cate) {
$shop_cates[$index]['goods'] = $GLOBALS['db']->getAll("select * from tb_deal where city_id = {$city_id} and is_effect = 1 and is_delete = 0 and p_shop_cate_id = " . $shop_cate['id'] . " order by sort limit 10");
$shop_cates[$index]['sub_cates'] = $GLOBALS['db']->getAll("select * from tb_shop_cate where is_effect = 1 and is_delete = 0 and pid= " . $shop_cate['id'] . " order by sort desc limit 8");
$shop_cates[$index]['index'] = $index + 1;
}
$GLOBALS['tmpl']->assign("shop_cates", $shop_cates);
}
//输出精品商圈广告位
$sql = "select adv_id from " . DB_PREFIX . "adv where adv_id like '精品商圈广告位%'";
$adv_list = $GLOBALS['db']->getAll($sql);
$GLOBALS['tmpl']->assign("adv_list", $adv_list);
$city_ids = load_auto_cache("deal_city_belone_ids", array("city_id" => intval($GLOBALS['deal_city']['id'])));
if ($city_ids) {
$store_list = $GLOBALS['db']->getAll("SELECT * FROM " . DB_PREFIX . "supplier_location use index (search_idx1, is_verify) WHERE is_recommend=1 AND city_id in(" . implode(",", $city_ids) . ") and is_effect = 1 order by is_verify desc,sort desc limit 0," . app_conf("INDEX_SUPPLIER_COUNT"));
} else {
$store_list = $GLOBALS['db']->getAll("SELECT * FROM " . DB_PREFIX . "supplier_location use index (search_idx1, is_verify) WHERE is_recommend=1 AND is_effect = 1 order by is_verify desc,sort desc limit 0," . app_conf("INDEX_SUPPLIER_COUNT"));
}
$bcate_list = load_dynamic_cache("INDEX_RECOMMEND_BCATE");
$GLOBALS['tmpl']->assign("bcate_list", $bcate_list);
$GLOBALS['tmpl']->assign("store_list", $store_list);
$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]);
}
}
$now = get_gmtime();
$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);
}
$GLOBALS['tmpl']->display("index.html", $cache_id);
}
