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