public function modify() { convert_req($_REQUEST); $id = $_REQUEST['id']; $s_account_info = es_session::get("account_info"); $location_ids = $s_account_info['location_ids']; $info = $GLOBALS['db']->getRow(" SELECT * FROM " . DB_PREFIX . "supplier_location WHERE id = " . intval($id) . " and id in (" . implode(",", $s_account_info['location_ids']) . ")"); if (!$info) { showErr("门店不存在或者没有编辑该门店的权限"); } $info['city_name'] = get_deal_city_name(intval($info['city_id'])); $area_list = $GLOBALS['db']->getAll("SELECT * FROM " . DB_PREFIX . "area where city_id=" . intval($info['city_id'])); foreach ($area_list as $k => $v) { if ($GLOBALS['db']->getOne("SELECT count(*) FROM " . DB_PREFIX . "supplier_location_area_link where area_id=" . $v['id'] . " and location_id = " . $id)) { $area_list[$k]['checked'] = true; } } $s_account_info = es_session::get("account_info"); $location_ids = $s_account_info['location_ids']; if (count($location_ids) == 2) { $history_back = url("biz"); } else { $history_back = url("biz", "profile#modify"); } $GLOBALS['tmpl']->assign("history_back", $history_back); $GLOBALS['tmpl']->assign("info", $info); $GLOBALS['tmpl']->assign("area_list", $area_list); $GLOBALS['tmpl']->display("biz/biz_location_modify.html"); }
public function index() { require_once APP_ROOT_PATH . "system/model/topic.php"; global_run(); init_app_page(); $GLOBALS['tmpl']->assign("wrap_type", "1"); //宽屏展示 $GLOBALS['tmpl']->assign("no_nav", true); //无分类下拉 convert_req($_REQUEST); $title = $GLOBALS['lang']['DISCOVER']; $site_nav[] = array('name' => $GLOBALS['lang']['HOME_PAGE'], 'url' => url("index")); $site_nav[] = array('name' => $title, 'url' => url("index", "discover")); $GLOBALS['tmpl']->assign("site_nav", $site_nav); $cid = intval($_REQUEST['cid']); $cate_name = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "topic_tag_cate where id = " . $cid); $GLOBALS['tmpl']->assign("cid", $cid); $tag = strim($_REQUEST['tag']); if ($tag) { $GLOBALS['tmpl']->assign("tag", $tag); } if ($GLOBALS['kw']) { $GLOBALS['tmpl']->assign("tag", $GLOBALS['kw']); } if ($cate_name) { $title = $title . $cate_name; } if ($tag) { $title = $title . $tag; } $GLOBALS['tmpl']->assign("page_title", $title); $GLOBALS['tmpl']->assign("page_keyword", $title . ","); $GLOBALS['tmpl']->assign("page_description", $title . ","); if ($cid == 0) { $tag_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "topic_tag where is_recommend = 1 order by sort desc limit 10"); } else { $tag_list = $GLOBALS['db']->getAll("select t.* from " . DB_PREFIX . "topic_tag as t left join " . DB_PREFIX . "topic_tag_cate_link as l on l.tag_id = t.id where l.cate_id = " . $cid . " order by t.sort desc limit 10"); } $GLOBALS['tmpl']->assign("tag_list", $tag_list); $cate_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "topic_tag_cate where showin_web = 1 order by sort desc limit 7"); $GLOBALS['tmpl']->assign("cate_list", $cate_list); $page = intval($_REQUEST['p']); if ($page == 0) { $page = 1; } $GLOBALS['tmpl']->assign("page", $page); $condition = ' is_effect = 1 and is_delete = 0 '; $param['cid'] = $cid; $param['tag'] = $tag; $param_condition = build_topic_filter_condition($param); $condition .= " " . $param_condition; $condition .= " and fav_id = 0 and relay_id = 0 and has_image = 1 and type in ('share','sharedeal','shareyouhui','shareevent') "; $sql = "select count(*) from " . DB_PREFIX . "topic where " . $condition; $count = $GLOBALS['db']->getOne($sql); $page_size = PIN_PAGE_SIZE; $page = new Page($count, $page_size); //初始化分页对象 $p = $page->show(); $GLOBALS['tmpl']->assign('pages', $p); $remain_count = $count - ($page - 1) * $page_size; //从当前页算起剩余的数量 $remain_page = ceil($remain_count / $page_size); //剩余的页数 if ($remain_page == 1) { //末页 $step_size = ceil($remain_count / PIN_SECTOR); } else { $step_size = ceil(PIN_PAGE_SIZE / PIN_SECTOR); } $GLOBALS['tmpl']->assign('step_size', $step_size); $GLOBALS['tmpl']->display("discover.html"); }
public function index() { convert_req($_REQUEST); $_REQUEST['cid'] = intval($_REQUEST['cid']); $keyword = addslashes(htmlspecialchars(trim($_REQUEST['keyword']))); $GLOBALS['tmpl']->assign("keyword", $keyword); $url_param = array("cid" => $_REQUEST['cid'], "aid" => intval($_REQUEST['aid']), "tid" => intval($_REQUEST['tid']), "qid" => intval($_REQUEST['qid']), "keyword" => $keyword); if (intval($_REQUEST['is_redirect']) == 1) { app_redirect(url("youhui", "fcate", $url_param)); } $quan_id = intval($_REQUEST['qid']); // $city_id = intval($GLOBALS['deal_city']['id']); //分页 $page = intval($_REQUEST['p']); if ($page == 0) { $page = 1; } $limit = ($page - 1) * app_conf("DEAL_PAGE_SIZE") . "," . app_conf("DEAL_PAGE_SIZE"); $cid = intval($_REQUEST['cid']); if ($cid == 0) { $uname = addslashes(trim($_REQUEST['cid'])); } $cate_item = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "deal_cate where id = " . $cid . " or (uname = '" . $uname . "' and uname <> '')"); $free_youhui_list = get_free_youhui_list(5, intval($cate_item['id']), " is_recommend = 1 ", ""); $GLOBALS['tmpl']->assign("free_youhui_list", $free_youhui_list['list']); $condition = " 1=1 "; //条件 unset($url_param['keyword']); $sub_nav[] = array("name" => $GLOBALS['lang']['FREE_YOUHUI'], "url" => url("youhui", "fcate", $url_param), "current" => 1); $sub_nav[] = array("name" => $GLOBALS['lang']['NEED_BUY_YOUHUI'], "url" => url("youhui", "ycate", $url_param), "current" => 0); $sub_nav[] = array("name" => $GLOBALS['lang']['TUAN'], "url" => url("youhui", "tuan", $url_param), "current" => 0); $GLOBALS['tmpl']->assign("sub_nav", $sub_nav); $GLOBALS['tmpl']->assign("url_param", $url_param); //将变量输出到模板 $seo_title = $GLOBALS['lang']['FREE_YOUHUI']; $seo_keyword = $GLOBALS['lang']['FREE_YOUHUI']; $seo_description = $GLOBALS['lang']['FREE_YOUHUI']; $cache_param = array("city_id" => $city_id, "cid" => $cate_item['id'], "tid" => $url_param['tid'], "aid" => $url_param['aid'], "qid" => $url_param['qid']); $result = load_auto_cache("fyouhui_filter_nav_cache", $cache_param); //输出行政区 $append_seo = ""; $area_id = intval($_REQUEST['aid']); if ($area_id > 0) { $area_name = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "area where id = " . $area_id); $append_seo = $area_name; if ($quan_id > 0) { $kw_unicode = str_to_unicode_string($area_name); //有筛选 $condition .= " and (match(locate_match) against('" . $kw_unicode . "' IN BOOLEAN MODE)) "; } else { $ids = load_auto_cache("deal_quan_ids", array("quan_id" => $area_id)); $quan_list = $GLOBALS['db']->getAll("select `name` from " . DB_PREFIX . "area where id in (" . implode(",", $ids) . ")"); $unicode_quans = array(); foreach ($quan_list as $k => $v) { $unicode_quans[] = str_to_unicode_string($v['name']); } $kw_unicode = implode(" ", $unicode_quans); $condition .= " and (match(locate_match) against('" . $kw_unicode . "' IN BOOLEAN MODE))"; } } $GLOBALS['tmpl']->assign("area_list", $result['area_list']); if ($area_id > 0) { //输出商圈 if ($quan_id > 0) { $area_name = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "area where id = " . $quan_id); $kw_unicode = str_to_unicode_string($area_name); //有筛选 $condition .= " and (match(locate_match) against('" . $kw_unicode . "' IN BOOLEAN MODE)) "; $append_seo = $append_seo . $area_name; } $GLOBALS['tmpl']->assign("quan_list", $result['quan_list']); } //输出分类 $cate_id = $cate_item['id']; $GLOBALS['tmpl']->assign("cate_list", $result['cate_list']); //输出小分类 $deal_type_id = intval($_REQUEST['tid']); $deal_cate_id = $cate_id; if ($deal_cate_id > 0) { $GLOBALS['tmpl']->assign("scate_list", $result['scate_list']); if ($append_seo != "") { $append_seo .= " - "; } $append_seo .= $cate_item['name']; } if ($deal_type_id > 0) { $deal_type_name = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "deal_cate_type where id = " . $deal_type_id); $deal_type_name_unicode = str_to_unicode_string($deal_type_name); $condition .= " and (match(deal_cate_match) against('" . $deal_type_name_unicode . "' IN BOOLEAN MODE)) "; $append_seo .= $deal_type_name; } $seo_title = $append_seo . $seo_title; $seo_keyword = $append_seo . $seo_keyword; $seo_description = $append_seo . $seo_keyword; if ($keyword) { $kws_div = div_str($keyword); foreach ($kws_div as $k => $item) { $kw[$k] = str_to_unicode_string($item); } $ukeyword = implode(" ", $kw); $condition .= " and (match(name_match) against('" . $ukeyword . "' IN BOOLEAN MODE) or name like '%" . $keyword . "%') "; $seo_title = $keyword . " - " . $seo_title; } $result = get_free_youhui_list($limit, $cate_id, $condition, ""); $GLOBALS['tmpl']->assign("list", $result['list']); $page = new Page($result['count'], app_conf("DEAL_PAGE_SIZE")); //初始化分页对象 $p = $page->show(); $GLOBALS['tmpl']->assign('pages', $p); // $site_nav[] = array('name' => $GLOBALS['lang']['HOME_PAGE'], 'url' => url("index", "index")); $site_nav[] = array('name' => $GLOBALS['lang']['FREE_YOUHUI'], 'url' => url("youhui", "fcate")); if ($_GET['model'] == "app") { echo json_encode(array('ret' => 1)); } else { $GLOBALS['tmpl']->assign("site_nav", $site_nav); $GLOBALS['tmpl']->assign("page_title", $seo_title); $GLOBALS['tmpl']->assign("page_keyword", $seo_keyword . ","); $GLOBALS['tmpl']->assign("page_description", $seo_description . ","); $GLOBALS['tmpl']->display("youhui_fcate.html"); } }
function insert_load_filter_goods_list() { convert_req($_REQUEST); //获取当前页的团购商品列表 //分页 $page = intval($_REQUEST['p']); if ($page == 0) { $page = 1; } $limit = ($page - 1) * app_conf("DEAL_PAGE_SIZE") . "," . app_conf("DEAL_PAGE_SIZE"); $id = intval($_REQUEST['id']); if ($id == 0) { $uname = addslashes(trim($_REQUEST['id'])); } $cate_item = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "shop_cate where id = " . $id . " or (uname = '" . $uname . "' and uname <> '')"); $condition = " d.buy_type<>1 "; //条件 $url_param = array("id" => addslashes(trim($_REQUEST['id'])), "b" => intval($_REQUEST['b']), "min_price" => doubleval($_REQUEST['min_price']), "max_price" => doubleval($_REQUEST['max_price'])); $filter_req = $_REQUEST['f']; //筛选数组 if (count($filter_req) > 0) { foreach ($filter_req as $k => $v) { $url_param['f[' . $k . ']'] = $v; } } if (intval($_REQUEST['is_redirect']) == 1) { app_redirect(url("shop", "cate", $url_param)); } $GLOBALS['tmpl']->assign("url_param", $url_param); //将变量输出到模板 $ids = load_auto_cache("shop_sub_parent_cate_ids", array("cate_id" => intval($cate_item['id']))); $add_title = ""; //输出品牌 $brand_id = intval($_REQUEST['b']); if ($brand_id > 0) { $condition .= " and d.brand_id = " . $brand_id; $add_title .= $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "brand where id = " . $brand_id); } $brand_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "brand where shop_cate_id in (" . implode(",", $ids) . ")"); $brand_list[] = array("name" => $GLOBALS['lang']['ALL'], "id" => 0); foreach ($brand_list as $k => $v) { if ($brand_id == $v['id']) { $brand_list[$k]['act'] = 1; } $tmp_url_param = $url_param; $tmp_url_param['b'] = $v['id']; $brand_list[$k]['url'] = url("shop", "cate#index", $tmp_url_param); } $GLOBALS['tmpl']->assign("brand_list", $brand_list); //输出属性筛选 $join_str = ""; $unicode_tags = array(); if ($filter_req) { foreach ($filter_req as $k => $v) { $k = intval($k); $filter_req[$k] = trim(addslashes(urldecode($v))); if ($filter_req[$k] != '' && $filter_req[$k] != 'all') { if ($add_title != '') { $add_title .= " - "; } $add_title .= $filter_req[$k]; $unicode_tags[] = "+" . str_to_unicode_string($filter_req[$k]); } } } if (count($unicode_tags) > 0) { $kw_unicode = implode(" ", $unicode_tags); //有筛选 $condition .= " and (match(d.tag_match) against('" . $kw_unicode . "' IN BOOLEAN MODE))"; } $filter_group = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "filter_group where is_effect = 1 and cate_id in (" . implode(",", $ids) . ") order by sort desc"); foreach ($filter_group as $k => $v) { $filter_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "filter where filter_group_id = " . $v['id'] . " limit 20"); $filter_list[] = array("name" => $GLOBALS['lang']['ALL'], "id" => 0); foreach ($filter_list as $kk => $vv) { if ($filter_req[$v['id']] == $vv['name']) { $filter_list[$kk]['act'] = 1; } if ($vv['id'] == 0) { $url_name = 'all'; } else { $url_name = $vv['name']; } if (($filter_req[$v['id']] == 'all' || $filter_req[$v['id']] == '') && $url_name == 'all') { $filter_list[$kk]['act'] = 1; } $tmp_url_param = $url_param; $tmp_url_param["f[" . $v['id'] . "]"] = $url_name; $filter_list[$kk]['url'] = url("shop", "cate#index", $tmp_url_param); } $filter_group[$k]['filter_list'] = $filter_list; } $GLOBALS['tmpl']->assign("filter_group", $filter_group); //输出价格区间 $min_price = doubleval($_REQUEST['min_price']); $max_price = doubleval($_REQUEST['max_price']); $GLOBALS['tmpl']->assign("min_price", $min_price); $GLOBALS['tmpl']->assign("max_price", $max_price); if ($min_price > 0) { $condition .= " and d.current_price >= " . $min_price; } if ($max_price > 0) { $condition .= " and d.current_price <= " . $max_price; } $sort_field = es_cookie::get("shop_sort_field") ? es_cookie::get("shop_sort_field") : "sort"; $sort_type = es_cookie::get("shop_sort_type") ? es_cookie::get("shop_sort_type") : "desc"; $GLOBALS['tmpl']->assign('sort_field', $sort_field); $GLOBALS['tmpl']->assign('sort_type', $sort_type); $result = search_goods_list($limit, intval($cate_item['id']), $condition, "d." . $sort_field . " " . $sort_type, false, $join_str); $GLOBALS['tmpl']->assign("list", $result['list']); $page = new Page($result['count'], app_conf("DEAL_PAGE_SIZE")); //初始化分页对象 $p = $page->show(); $GLOBALS['tmpl']->assign('pages', $p); $GLOBALS['tmpl']->assign("cate_id", $cate_item['id']); if (es_cookie::get("list_type") === null) { $list_type = app_conf("LIST_TYPE"); } else { $list_type = intval(es_cookie::get("list_type")); } $GLOBALS['tmpl']->assign("list_type", $list_type); return $GLOBALS['tmpl']->fetch("inc/insert/load_filter_goods_list.html"); }
function convert_req(&$req) { foreach ($req as $k => $v) { if (is_array($v)) { convert_req($req[$k]); } else { if (!is_u8($v)) { $req[$k] = iconv("gbk", "utf-8", $v); } } } }
public function pick() { $url_param = array("id" => addslashes(trim($_REQUEST['id'])), "b" => intval($_REQUEST['b']), "min_price" => doubleval($_REQUEST['min_price']), "max_price" => doubleval($_REQUEST['max_price']), "keyword" => addslashes(trim($_REQUEST['keyword']))); $filter_req = $_REQUEST['f']; //筛选数组 if (count($filter_req) > 0) { foreach ($filter_req as $k => $v) { $url_param['f[' . $k . ']'] = $v; } } if (intval($_REQUEST['is_redirect']) == 1) { app_redirect(url("shop", "ss#pick", $url_param)); } //输出商城分类 $cate_tree = get_cate_tree(); $all_cate_tree = get_cate_tree(0, 1); $GLOBALS['tmpl']->assign("cate_tree", $cate_tree); $GLOBALS['tmpl']->assign("all_cate_tree", $all_cate_tree); convert_req($_REQUEST); //获取当前页的团购商品列表 //分页 $page = intval($_REQUEST['p']); if ($page == 0) { $page = 1; } $limit = ($page - 1) * app_conf("DEAL_PAGE_SIZE") . "," . app_conf("DEAL_PAGE_SIZE"); $id = intval($_REQUEST['id']); if ($id == 0) { $uname = addslashes(trim($_REQUEST['id'])); } $cate_item = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "shop_cate where id = " . $id . " or (uname = '" . $uname . "' and uname <> '')"); $condition = " d.buy_type<>1 "; //条件 $ids = load_auto_cache("shop_sub_cate_ids", array("cate_id" => intval($cate_item['id']))); $add_title = ""; //输出品牌 $brand_id = intval($_REQUEST['b']); if ($brand_id > 0) { $condition .= " and d.brand_id = " . $brand_id; $add_title .= $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "brand where id = " . $brand_id); $GLOBALS['tmpl']->assign("brand_id", $brand_id); } $brand_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "brand order by sort desc"); $GLOBALS['tmpl']->assign("brand_list", $brand_list); //输出属性筛选 $filter_req = $_REQUEST['f']; $join_str = ""; $unicode_tags = array(); foreach ($filter_req as $k => $v) { $filter_req[$k] = trim(addslashes(urldecode($v))); if ($filter_req[$k] != '' && $filter_req[$k] != 'all') { if ($add_title != '') { $add_title .= " - "; } $add_title .= $filter_req[$k]; // //联表及条件 // $join_str.=" left join ".DB_PREFIX."deal_filter as df_".$k." on d.id=df_".$k.".deal_id and df_".$k.".filter_group_id = ".$k; // $condition.=" and df_".$k.".filter like '%".$filter_req[$k]."%' "; $unicode_tags[] = "+" . str_to_unicode_string($filter_req[$k]); } } if (count($unicode_tags) > 0) { $kw_unicode = implode(" ", $unicode_tags); //有筛选 $condition .= " and (match(d.tag_match) against('" . $kw_unicode . "' IN BOOLEAN MODE))"; } if (intval($_REQUEST['id']) != 0) { $filter_group = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "filter_group where is_effect = 1 and cate_id in (" . implode(",", $ids) . ") order by sort desc"); foreach ($filter_group as $k => $v) { $filter_group[$k]['value'] = $filter_req[$v['id']]; } $GLOBALS['tmpl']->assign("filter_group", $filter_group); } //输出价格区间 $min_price = doubleval($_REQUEST['min_price']); $max_price = doubleval($_REQUEST['max_price']); $GLOBALS['tmpl']->assign("min_price", $min_price); $GLOBALS['tmpl']->assign("max_price", $max_price); if ($min_price > 0) { $condition .= " and d.current_price >= " . $min_price; } if ($max_price > 0) { $condition .= " and d.current_price <= " . $max_price; } $sort_field = es_cookie::get("shop_sort_field") ? es_cookie::get("shop_sort_field") : "sort"; $sort_type = es_cookie::get("shop_sort_type") ? es_cookie::get("shop_sort_type") : "desc"; $GLOBALS['tmpl']->assign('sort_field', $sort_field); $GLOBALS['tmpl']->assign('sort_type', $sort_type); if (es_cookie::get("list_type") === null) { $list_type = app_conf("LIST_TYPE"); } else { $list_type = intval(es_cookie::get("list_type")); } $GLOBALS['tmpl']->assign("list_type", $list_type); $kw = addslashes(htmlspecialchars(trim($_REQUEST['keyword']))); if ($kw != '') { $GLOBALS['tmpl']->assign('keyword', $kw); if ($add_title != '') { $add_title .= "-"; } $add_title .= $kw; $kws_div = div_str($kw); foreach ($kws_div as $k => $item) { $kws[$k] = str_to_unicode_string($item); } $ukeyword = implode(" ", $kws); $condition .= " and (match(d.tag_match,d.name_match,d.locate_match,d.shop_cate_match) against('" . $ukeyword . "' IN BOOLEAN MODE))"; //$condition.=" and (d.name like '%".$kw."%' or d.sub_name like '%".$kw."%' or d.brief like '%".$kw."%' or d.description like '%".$kw."%')"; } if ($add_title != '') { $add_title .= "-"; } $add_title .= $GLOBALS['lang']['GOODS_SEARCH']; $result = search_goods_list($limit, intval($cate_item['id']), $condition, "d." . $sort_field . " " . $sort_type, false, $join_str); $GLOBALS['tmpl']->assign("list", $result['list']); $page = new Page($result['count'], app_conf("DEAL_PAGE_SIZE")); //初始化分页对象 $p = $page->show(); $GLOBALS['tmpl']->assign('pages', $p); $GLOBALS['tmpl']->assign("cate_id", $cate_item['id']); $GLOBALS['tmpl']->assign("page_title", $add_title . $cate_item['name']); $GLOBALS['tmpl']->assign("page_keyword", $add_title . $cate_item['name'] . ","); $GLOBALS['tmpl']->assign("page_description", $add_title . $cate_item['name'] . ","); $GLOBALS['tmpl']->assign("filter", true); //显示筛选框 $GLOBALS['tmpl']->assign("show_list", true); $GLOBALS['tmpl']->display("ss_index.html"); }
public function index() { convert_req($_REQUEST); $_REQUEST['cid'] = intval($_REQUEST['cid']); $keyword = addslashes(htmlspecialchars(trim($_REQUEST['keyword']))); $GLOBALS['tmpl']->assign("keyword", $keyword); $url_param = array("cid" => $_REQUEST['cid'], "aid" => intval($_REQUEST['aid']), "tid" => intval($_REQUEST['tid']), "qid" => intval($_REQUEST['qid']), "min_price" => doubleval($_REQUEST['min_price']), "max_price" => doubleval($_REQUEST['max_price']), "keyword" => $keyword); if (intval($_REQUEST['is_redirect']) == 1) { app_redirect(url("youhui", "ycate", $url_param)); } $site_nav[] = array('name' => $GLOBALS['lang']['HOME_PAGE'], 'url' => url("index", "index")); $site_nav[] = array('name' => $GLOBALS['lang']['NEED_BUY_YOUHUI'], 'url' => url("youhui", "ycate#index")); $GLOBALS['tmpl']->assign("site_nav", $site_nav); //输出当前的site_nav //输出热卖 $res = search_youhui_list(app_conf("SIDE_DEAL_COUNT"), 0, "", "d.buy_count desc", true, ""); $GLOBALS['tmpl']->assign("hot_sale_list", $res['list']); $seo_title = $GLOBALS['lang']['NEED_BUY_YOUHUI']; $seo_keyword = $GLOBALS['lang']['NEED_BUY_YOUHUI']; $seo_description = $GLOBALS['lang']['NEED_BUY_YOUHUI']; // $city_id = intval($GLOBALS['deal_city']['id']); //分页 $page = intval($_REQUEST['p']); if ($page == 0) { $page = 1; } $limit = ($page - 1) * app_conf("DEAL_PAGE_SIZE") . "," . app_conf("DEAL_PAGE_SIZE"); $id = intval($_REQUEST['cid']); if ($id == 0) { $uname = addslashes(trim($_REQUEST['id'])); } $cate_item = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "deal_cate where id = " . $id . " or (uname = '" . $uname . "' and uname <> '')"); $condition = " d.is_shop = 2 "; //条件 $tp_url_param = $url_param; unset($tp_url_param['min_price']); unset($tp_url_param['max_price']); unset($tp_url_param['keyword']); $sub_nav[] = array("name" => $GLOBALS['lang']['FREE_YOUHUI'], "url" => url("youhui", "fcate", $tp_url_param), "current" => 0); $sub_nav[] = array("name" => $GLOBALS['lang']['NEED_BUY_YOUHUI'], "url" => url("youhui", "ycate", $tp_url_param), "current" => 1); $sub_nav[] = array("name" => $GLOBALS['lang']['TUAN'], "url" => url("youhui", "tuan", $tp_url_param), "current" => 0); $GLOBALS['tmpl']->assign("sub_nav", $sub_nav); $GLOBALS['tmpl']->assign("url_param", $tp_url_param); //将变量输出到模板 $ids = load_auto_cache("deal_sub_cate_ids", array("cate_id" => intval($cate_item['id']))); $cache_param = array("city_id" => $city_id, "cid" => $cate_item['id'], "tid" => $url_param['tid'], "aid" => $url_param['aid'], "qid" => $url_param['qid']); $result = load_auto_cache("byouhui_filter_nav_cache", $cache_param); //输出大区 $append_seo = ""; $area_id = intval($_REQUEST['aid']); $quan_id = intval($_REQUEST['qid']); if ($area_id > 0) { $area_name = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "area where id = " . $area_id); $append_seo .= $area_name; if ($quan_id > 0) { $kw_unicode = str_to_unicode_string($area_name); //有筛选 $condition .= " and (match(d.locate_match) against('" . $kw_unicode . "' IN BOOLEAN MODE))"; } else { $ids = load_auto_cache("deal_quan_ids", array("quan_id" => $area_id)); $quan_list = $GLOBALS['db']->getAll("select `name` from " . DB_PREFIX . "area where id in (" . implode(",", $ids) . ")"); $unicode_quans = array(); foreach ($quan_list as $k => $v) { $unicode_quans[] = str_to_unicode_string($v['name']); } $kw_unicode = implode(" ", $unicode_quans); $condition .= " and (match(locate_match) against('" . $kw_unicode . "' IN BOOLEAN MODE))"; } } $GLOBALS['tmpl']->assign("area_list", $result['area_list']); if ($area_id > 0) { //输出商圈 if ($quan_id > 0) { $area_name = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "area where id = " . $quan_id); $kw_unicode = str_to_unicode_string($area_name); //有筛选 $condition .= " and (match(d.locate_match) against('" . $kw_unicode . "' IN BOOLEAN MODE)) "; $append_seo = $append_seo . $area_name; } $GLOBALS['tmpl']->assign("quan_list", $result['quan_list']); } //输出分类 $cate_id = $cate_item['id']; $GLOBALS['tmpl']->assign("cate_list", $result['cate_list']); //输出小分类 $deal_type_id = intval($_REQUEST['tid']); $deal_cate_id = $cate_item['id']; $deal_quan_id = $area_id; if ($deal_cate_id > 0) { $GLOBALS['tmpl']->assign("scate_list", $result['scate_list']); if ($append_seo != "") { $append_seo .= " - "; } $append_seo .= $cate_item['name']; } //输出价格区间 $min_price = doubleval($_REQUEST['min_price']); $max_price = doubleval($_REQUEST['max_price']); $GLOBALS['tmpl']->assign("min_price", $min_price); $GLOBALS['tmpl']->assign("max_price", $max_price); if ($min_price > 0) { $condition .= " and d.current_price >= " . $min_price; } if ($max_price > 0) { $condition .= " and d.current_price <= " . $max_price; } $sort_field = es_cookie::get("shop_sort_field") ? es_cookie::get("shop_sort_field") : "sort"; $sort_type = es_cookie::get("shop_sort_type") ? es_cookie::get("shop_sort_type") : "desc"; if ($sort_field != "update_time" && $sort_field != "current_price" && $sort_field != "buy_count" && $sort_field != "avg_point" && $sort_field != "sort") { $sort_field = "sort"; } if ($sort_type != "desc" && $sort_type != "asc") { $sort_type = "desc"; } $GLOBALS['tmpl']->assign('sort_field', $sort_field); $GLOBALS['tmpl']->assign('sort_type', $sort_type); if ($deal_type_id > 0) { $deal_type_name = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "deal_cate_type where id = " . $deal_type_id); $deal_type_name_unicode = str_to_unicode_string($deal_type_name); $condition .= " and (match(d.deal_cate_match) against('" . $deal_type_name_unicode . "' IN BOOLEAN MODE)) "; $append_seo .= $deal_type_name; } $seo_title = $append_seo . $seo_title; $seo_keyword = $append_seo . $seo_keyword; $seo_description = $append_seo . $seo_keyword; if ($keyword) { $kws_div = div_str($keyword); foreach ($kws_div as $k => $item) { $kw[$k] = str_to_unicode_string($item); } $ukeyword = implode(" ", $kw); $condition .= " and (match(d.name_match) against('" . $ukeyword . "' IN BOOLEAN MODE) or d.name like '%" . $keyword . "%') "; $seo_title = $keyword . " - " . $seo_title; } $result = search_youhui_list($limit, intval($cate_item['id']), $condition, "d." . $sort_field . " " . $sort_type, false, ""); $GLOBALS['tmpl']->assign("list", $result['list']); $page = new Page($result['count'], app_conf("DEAL_PAGE_SIZE")); //初始化分页对象 $p = $page->show(); $GLOBALS['tmpl']->assign('pages', $p); $GLOBALS['tmpl']->assign("cate_id", $cate_item['id']); // $GLOBALS['tmpl']->assign("page_title", $seo_title); $GLOBALS['tmpl']->assign("page_keyword", $seo_keyword); $GLOBALS['tmpl']->assign("page_description", $seo_description); $GLOBALS['tmpl']->display("youhui_ycate.html"); }
public function index() { convert_req($_REQUEST); $_REQUEST['cid'] = intval($_REQUEST['cid']); $keyword = addslashes(htmlspecialchars(trim($_REQUEST['keyword']))); //获取当前页的团购商品列表 require_once APP_ROOT_PATH . 'app/Lib/page.php'; $city_id = intval($GLOBALS['deal_city']['id']); //分页 $page = intval($_REQUEST['p']); if ($page == 0) { $page = 1; } $limit = ($page - 1) * app_conf("DEAL_PAGE_SIZE") . "," . app_conf("DEAL_PAGE_SIZE"); $cate_list = load_auto_cache("cache_deal_cate"); $cid = intval($_REQUEST['cid']); $uname = addslashes(trim($_REQUEST['cid'])); //$cate_item = $GLOBALS['db']->getRow("select * from ".DB_PREFIX."deal_cate where id = ".$cid." or (uname = '".$uname."' and uname <> '')"); $cate_item = $cate_list[$cid]; $condition = " 1=1 "; //条件 $base_param = $url_param = array("cid" => $_REQUEST['cid'], "aid" => intval($_REQUEST['aid']), "tid" => intval($_REQUEST['tid']), "qid" => intval($_REQUEST['qid']), "keyword" => $keyword, "minprice" => $minprice = doubleval($_REQUEST['minprice']) > 0 ? doubleval($_REQUEST['minprice']) : 0, "maxprice" => $maxprice = doubleval($_REQUEST['maxprice']) > 0 ? doubleval($_REQUEST['maxprice']) : 0); //组装分组筛选 if ($_REQUEST['g'] && is_array($_REQUEST['g'])) { foreach ($_REQUEST['g'] as $k => $v) { $url_param["g[" . $k . "]"] = addslashes(trim($v)); } } if (intval($_REQUEST['is_redirect']) == 1) { app_redirect(url("youhui", "store", $url_param)); } $GLOBALS['tmpl']->assign("url_param", $url_param); //将变量输出到模板 unset($url_param['keyword']); unset($url_param['minprice']); unset($url_param['maxprice']); $cache_param = $url_param; $cache_param['cid'] = $cate_item['id']; $cache_param['city_id'] = $city_id; $result = load_auto_cache("store_filter_nav_cache", $cache_param); $filter_url_param = $base_param; $filter_url_param['has_tuan'] = intval($_REQUEST['has_tuan']); $filter_url_param['has_daijin'] = intval($_REQUEST['has_daijin']); $filter_url_param['has_youhui'] = intval($_REQUEST['has_youhui']); $filter_url_param['has_event'] = intval($_REQUEST['has_event']); $filter_url_param['has_goods'] = intval($_REQUEST['has_goods']); $filter_url_param['is_verify'] = intval($_REQUEST['is_verify']); $GLOBALS['tmpl']->assign("filter_url_param", $filter_url_param); $tmpfilter_url_param = $filter_url_param; if ($filter_url_param['has_tuan'] == 1) { $tmpfilter_url_param['has_tuan'] = 0; } else { $tmpfilter_url_param['has_tuan'] = 1; } $filter_url['has_tuan'] = url("youhui", "store", $tmpfilter_url_param); $tmpfilter_url_param = $filter_url_param; if ($filter_url_param['has_daijin'] == 1) { $tmpfilter_url_param['has_daijin'] = 0; } else { $tmpfilter_url_param['has_daijin'] = 1; } $filter_url['has_daijin'] = url("youhui", "store", $tmpfilter_url_param); $tmpfilter_url_param = $filter_url_param; if ($filter_url_param['has_youhui'] == 1) { $tmpfilter_url_param['has_youhui'] = 0; } else { $tmpfilter_url_param['has_youhui'] = 1; } $filter_url['has_youhui'] = url("youhui", "store", $tmpfilter_url_param); $tmpfilter_url_param = $filter_url_param; if ($filter_url_param['has_event'] == 1) { $tmpfilter_url_param['has_event'] = 0; } else { $tmpfilter_url_param['has_event'] = 1; } $filter_url['has_event'] = url("youhui", "store", $tmpfilter_url_param); $tmpfilter_url_param = $filter_url_param; if ($filter_url_param['has_goods'] == 1) { $tmpfilter_url_param['has_goods'] = 0; } else { $tmpfilter_url_param['has_goods'] = 1; } $filter_url['has_goods'] = url("youhui", "store", $tmpfilter_url_param); $tmpfilter_url_param = $filter_url_param; if ($filter_url_param['is_verify'] == 1) { $tmpfilter_url_param['is_verify'] = 0; } else { $tmpfilter_url_param['is_verify'] = 1; } $filter_url['is_verify'] = url("youhui", "store", $tmpfilter_url_param); $GLOBALS['tmpl']->assign("filter_url", $filter_url); //输出大区 $seo_title = $GLOBALS['lang']['STORE_LIST']; $seo_keyword = $GLOBALS['lang']['STORE_LIST']; $seo_description = $GLOBALS['lang']['STORE_LIST']; $append_seo = ""; $area_id = intval($_REQUEST['aid']); $quan_id = intval($_REQUEST['qid']); $area_result = load_auto_cache("cache_area", array("city_id" => $GLOBALS['deal_city']['id'])); if ($area_id > 0) { // $area_name = $GLOBALS['db']->getOne("select name from ".DB_PREFIX."area where id = ".$area_id); $area_name = $area_result[$area_id]['name']; $append_seo = $area_name; if ($quan_id > 0) { $kw_unicode = str_to_unicode_string($area_name); //有筛选 $condition .= " and (match(locate_match) against('" . $kw_unicode . "' IN BOOLEAN MODE))"; } else { $ids = load_auto_cache("deal_quan_ids", array("quan_id" => $area_id)); //$quan_list = $GLOBALS['db']->getAll("select `name` from ".DB_PREFIX."area where id in (".implode(",",$ids).")"); $unicode_quans = array(); foreach ($ids as $k => $v) { $unicode_quans[] = str_to_unicode_string($area_result[$v]['name']); } $kw_unicode = implode(" ", $unicode_quans); $condition .= " and (match(locate_match) against('" . $kw_unicode . "' IN BOOLEAN MODE))"; } } $GLOBALS['tmpl']->assign("area_list", $result['area_list']); if ($area_id > 0) { //输出商圈 if ($quan_id > 0) { // $area_name = $GLOBALS['db']->getOne("select name from ".DB_PREFIX."area where id = ".$quan_id); $area_name = $area_result[$quan_id]['name']; $kw_unicode = str_to_unicode_string($area_name); //有筛选 $condition .= " and (match(locate_match) against('" . $kw_unicode . "' IN BOOLEAN MODE)) "; $append_seo = $append_seo . $area_name; } $GLOBALS['tmpl']->assign("quan_list", $result['quan_list']); } //输出分类 $cate_id = $cate_item['id']; $GLOBALS['tmpl']->assign("cate_list", $result['cate_list']); //输出小分类 $deal_type_id = intval($_REQUEST['tid']); $deal_cate_id = $cate_id; if ($deal_cate_id > 0) { $GLOBALS['tmpl']->assign("scate_list", $result['scate_list']); $GLOBALS['tmpl']->assign("tag_group", $result['tag_group']); //$deal_cate_name = $GLOBALS['db']->getOne("select name from ".DB_PREFIX."deal_cate where id = ".$deal_cate_id); $deal_cate_name = $cate_list[$deal_cate_id]['name']; $deal_cate_name_unicode = str_to_unicode_string($deal_cate_name); $condition .= " and (match(deal_cate_match) against('" . $deal_cate_name_unicode . "' IN BOOLEAN MODE)) "; $cate_condition = " (match(deal_cate_match) against('" . $deal_cate_name_unicode . "' IN BOOLEAN MODE)) "; if ($append_seo != "") { $append_seo .= " - "; } $append_seo .= $cate_item['name']; } if ($deal_type_id > 0) { $type_list = load_auto_cache("cache_deal_cate_type", array("cate_id" => $deal_cate_id)); // $deal_type_name = $GLOBALS['db']->getOne("select name from ".DB_PREFIX."deal_cate_type where id = ".$deal_type_id); $deal_type_name = $type_list[$deal_type_id]['name']; $deal_type_name_unicode = str_to_unicode_string($deal_type_name); $condition .= " and (match(deal_cate_match) against('" . $deal_type_name_unicode . "' IN BOOLEAN MODE)) "; $append_seo .= $deal_type_name; } $seo_title = $append_seo . $seo_title; $seo_keyword = $append_seo . $seo_keyword; $seo_description = $append_seo . $seo_keyword; $supplier_id = intval($_REQUEST['id']); if ($supplier_id > 0) { $supplier_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "supplier where id = " . $supplier_id); if ($supplier_info) { $GLOBALS['tmpl']->assign("supplier_info", $supplier_info); $condition .= " and supplier_id = " . $supplier_id; } } $url_param['tag'] = addslashes($_REQUEST['tag']); if ($url_param['tag']) { $kw_unicode = str_to_unicode_string($url_param['tag']); //有筛选 $condition .= " and (match(tags_match) against('" . $kw_unicode . "' IN BOOLEAN MODE))"; } if ($_REQUEST['g'] && is_array($_REQUEST['g'])) { foreach ($_REQUEST['g'] as $k => $v) { if (trim($v) != "") { $kw_unicode = str_to_unicode_string($v); $condition .= " and (match(tags_match) against('" . $kw_unicode . "' IN BOOLEAN MODE))"; } } } if ($keyword) { $GLOBALS['tmpl']->assign("keyword", $keyword); $kws_div = div_str($keyword); foreach ($kws_div as $k => $item) { $kw[$k] = str_to_unicode_string($item); } $kw_unicode = implode(" ", $kw); //有筛选 $condition .= " and (locate_match_row like '%" . $keyword . "%' or name like '%" . $keyword . "%') "; } if ($minprice > 0) { $condition .= " and ref_avg_price >= " . $minprice; $GLOBALS['tmpl']->assign("minprice", round($minprice)); } if ($maxprice > 0) { $condition .= " and ref_avg_price <= " . $maxprice; $GLOBALS['tmpl']->assign("maxprice", round($maxprice)); } if ($filter_url_param['has_tuan'] > 0) { $condition .= " and tuan_count > 0 "; } if ($filter_url_param['has_daijin'] > 0) { $condition .= " and daijin_count > 0 "; } if ($filter_url_param['has_youhui'] > 0) { $condition .= " and youhui_count > 0 "; } if ($filter_url_param['has_event'] > 0) { $condition .= " and event_count > 0 "; } if ($filter_url_param['has_goods'] > 0) { $condition .= " and shop_count > 0 "; } if ($filter_url_param['is_verify'] > 0) { $condition .= " and is_verify = 1 "; } $sort_field = es_cookie::get("store_sort_field"); $sort_type = es_cookie::get("store_sort_type"); if ($sort_type != "desc" && $sort_type != "asc") { $sort_type = "desc"; } if ($sort_field != "default" && $sort_field != "dp_count" && $sort_field != "avg_point" && $sort_field != "ref_avg_price") { $sort_field = "default"; } if ($sort_field == 'default') { $sortby = " sort desc, id desc,is_verify desc,dp_count desc "; } else { $sortby = $sort_field . " " . $sort_type; } $GLOBALS['tmpl']->assign('sort_field', $sort_field); $GLOBALS['tmpl']->assign('sort_type', $sort_type); $result = get_store_list($limit, 0, $condition, $sortby, false); $GLOBALS['tmpl']->assign("list", $result['list']); $page = new Page($result['count'], app_conf("DEAL_PAGE_SIZE")); //初始化分页对象 $p = $page->show(); $GLOBALS['tmpl']->assign('pages', $p); $site_nav[] = array('name' => $GLOBALS['lang']['HOME_PAGE'], 'url' => url("index", "index")); $site_nav[] = array('name' => $GLOBALS['lang']['STORE_LIST'], 'url' => url("youhui", "store")); $GLOBALS['tmpl']->assign("site_nav", $site_nav); //输出最新加入的商家 $new_stores = get_store_list(5, 0, $cate_condition, " id desc ", false, false); $GLOBALS['tmpl']->assign("new_stores", $new_stores['list']); if (trim($cate_condition) != '') { $rec_stores = get_store_list(5, 0, $cate_condition . " and is_recommend = 1 ", " id desc ", false, false); } else { $rec_stores = get_store_list(5, 0, " is_recommend = 1 ", " id desc ", false, false); } $GLOBALS['tmpl']->assign("rec_stores", $rec_stores['list']); $GLOBALS['tmpl']->assign("page_title", $seo_title); $GLOBALS['tmpl']->assign("page_keyword", $seo_keyword . ","); $GLOBALS['tmpl']->assign("page_description", $seo_description . ","); $GLOBALS['tmpl']->display("store_index.html"); }
if (!file_exists(APP_ROOT_PATH . 'public/runtime/app/tpl_caches/biz/')) { mkdir(APP_ROOT_PATH . 'public/runtime/app/tpl_caches/biz/', 0777); } if (!file_exists(APP_ROOT_PATH . 'public/runtime/app/tpl_compiled/biz/')) { mkdir(APP_ROOT_PATH . 'public/runtime/app/tpl_compiled/biz/', 0777); } $GLOBALS['tmpl']->cache_dir = APP_ROOT_PATH . 'public/runtime/app/tpl_caches/biz'; $GLOBALS['tmpl']->compile_dir = APP_ROOT_PATH . 'public/runtime/app/tpl_compiled/biz'; $GLOBALS['tmpl']->template_dir = APP_ROOT_PATH . 'app/Tpl/biz'; //定义模板路径 $tmpl_path = SITE_DOMAIN . APP_ROOT . "/app/Tpl/"; $GLOBALS['tmpl']->assign("TMPL", $tmpl_path . "biz"); $GLOBALS['tmpl']->assign("TMPL_REAL", APP_ROOT_PATH . "app/Tpl/biz"); $GLOBALS['tmpl']->assign("APP_INDEX", APP_INDEX); $GLOBALS['tmpl']->assign("APP_ROOT", APP_ROOT); convert_req($_REQUEST); //为main应用解析url if (app_conf("URL_MODEL") == 1) { //重写模式 $current_url = APP_ROOT . "/biz"; $rewrite_param = strim($_REQUEST['rewrite_param']); $rewrite_param = str_replace(array("\"", "'"), array("", ""), $rewrite_param); $rewrite_param = explode("/", $rewrite_param); foreach ($rewrite_param as $k => $param_item) { if ($param_item != '') { $rewrite_param_array[] = $param_item; } } foreach ($rewrite_param_array as $k => $v) { if ($k == 0) { //解析ctl
public function search() { //获取可以相关的用户 $user_list = get_rand_user(4); $user_id = intval($GLOBALS['user_info']['id']); $ids = array(0); foreach ($user_list as $k => $v) { $ids[] = $v['id']; } $focus_data = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "user_focus where focus_user_id = " . $user_id . " and focused_user_id in (" . implode(",", $ids) . ")"); foreach ($user_list as $k => $v) { foreach ($focus_data as $kk => $vv) { if ($vv['focused_user_id'] == $v['id']) { $user_list[$k]['focused'] = 1; break; } } if ($v['city_id'] != 0 && $v['city_id'] == $GLOBALS['deal_city']['id']) { $user_list[$k]['same_city'] = 1; } else { $user_list[$k]['same_city'] = 0; } } $GLOBALS['tmpl']->assign("user_list", $user_list); convert_req($_REQUEST); $type = intval($_REQUEST['type']); $filter = intval($_REQUEST['filter']); $keyword = addslashes(htmlspecialchars(trim($_REQUEST['keyword']))); $GLOBALS['tmpl']->assign("keyword", $keyword); $GLOBALS['tmpl']->assign("type", $type); $GLOBALS['tmpl']->assign("filter", $filter); $url_param = array("type" => $type, "filter" => $filter, "keyword" => $keyword); if ($type == 0) { unset($url_param['type']); } if ($filter == 0) { unset($url_param['filter']); } if (intval($_REQUEST['is_redirect']) == 1) { if ($type > 0) { app_redirect(url("shop", "topic#search", $url_param)); } else { app_redirect(url("shop", "topic#search", $url_param)); } } $type_navs = array(array("type" => 0, "name" => $GLOBALS['lang']['TOPIC_TYPE_ALL']), array("type" => 1, "name" => $GLOBALS['lang']['TOPIC_TYPE_DEAL']), array("type" => 2, "name" => $GLOBALS['lang']['TOPIC_TYPE_STORE']), array("type" => 3, "name" => $GLOBALS['lang']['TOPIC_TYPE_RECOMMEND'])); foreach ($type_navs as $k => $v) { $tmp_url_param = $url_param; if ($v['type'] != 0) { $tmp_url_param['type'] = $v['type']; } else { unset($tmp_url_param['type']); } $type_navs[$k]['url'] = url("shop", "topic#search", $tmp_url_param); if ($v['type'] == $type) { $type_navs[$k]['act'] = true; } } $filter_navs = array(array("filter" => 0, "name" => $GLOBALS['lang']['TOPIC_FILTER_ALL']), array("filter" => 1, "name" => $GLOBALS['lang']['TOPIC_FILTER_MYFOCUS']), array("filter" => 2, "name" => $GLOBALS['lang']['TOPIC_FILTER_DAREN']), array("filter" => 3, "name" => $GLOBALS['lang']['TOPIC_FILTER_MERCHANT'])); foreach ($filter_navs as $k => $v) { $tmp_url_param = $url_param; if ($v['filter'] != 0) { $tmp_url_param['filter'] = $v['filter']; } else { unset($tmp_url_param['filter']); } $filter_navs[$k]['url'] = url("shop", "topic#search", $tmp_url_param); if ($v['filter'] == $filter) { $filter_navs[$k]['act'] = true; } } $condition = " 1=1 "; if ($type == 0) { //所有分享 $condition .= ""; $search_title = $GLOBALS['lang']['TOPIC_TYPE_ALL']; } elseif ($type == 1) { $condition .= " and (t.type='tuancomment' or t.type='shopcomment' or t.type='youhuicomment' ) "; $search_title = $GLOBALS['lang']['TOPIC_TYPE_DEAL']; } elseif ($type == 2) { $condition .= " and t.type='slocationcomment' "; $search_title = $GLOBALS['lang']['TOPIC_TYPE_STORE']; } elseif ($type == 3) { $condition .= " and t.title like '" . $keyword . "' "; $search_title = $GLOBALS['lang']['TOPIC_TYPE_RECOMMEND']; } if ($filter == 0) { //全部 //$search_title.= " - ".$GLOBALS['lang']['TOPIC_FILTER_ALL']; } elseif ($filter == 1) { $search_title .= " - " . $GLOBALS['lang']['TOPIC_FILTER_MYFOCUS']; $condition .= " and uf.focus_user_id = " . intval($GLOBALS['user_info']['id']); } elseif ($filter == 2) { $search_title .= " - " . $GLOBALS['lang']['TOPIC_FILTER_DAREN']; $condition .= " and u.is_daren = 1 "; } elseif ($filter == 3) { $search_title .= " - " . $GLOBALS['lang']['TOPIC_FILTER_MERCHANT']; $condition .= " and u.is_merchant = 1 "; } if ($keyword) { $search_title .= " - " . $keyword; $kws_div = div_str($keyword); foreach ($kws_div as $k => $item) { $kw[$k] = str_to_unicode_string($item); } $ukeyword = implode(" ", $kw); $condition .= " and match(t.keyword_match) against('" . $ukeyword . "' IN BOOLEAN MODE) "; } $GLOBALS['tmpl']->assign("kws_div", $kws_div); $GLOBALS['tmpl']->assign("page_title", $search_title); $GLOBALS['tmpl']->assign("page_keyword", $search_title . ","); $GLOBALS['tmpl']->assign("page_description", $search_title . ","); //分页 $page = intval($_REQUEST['p']); if ($page == 0) { $page = 1; } $limit = ($page - 1) * app_conf("PAGE_SIZE") . "," . app_conf("PAGE_SIZE"); // $result = get_topic_list($limit,$condition,"",$kws_div); $orderby = 't.create_time desc'; $condition = " and " . $condition; $list = $GLOBALS['db']->getAll("select t.* from " . DB_PREFIX . "topic as t left join " . DB_PREFIX . "user as u on t.user_id = u.id left join " . DB_PREFIX . "user_focus as uf on uf.focused_user_id = t.user_id where t.is_effect = 1 and t.is_delete = 0 " . $condition . " group by t.id order by " . $orderby . " limit " . $limit); $total = $GLOBALS['db']->getOne("select count(distinct(t.id)) from " . DB_PREFIX . "topic as t left join " . DB_PREFIX . "user as u on t.user_id = u.id left join " . DB_PREFIX . "user_focus as uf on uf.focused_user_id = t.user_id where t.is_effect = 1 and t.is_delete = 0 " . $condition); foreach ($list as $k => $v) { $list[$k] = get_topic_item($v, $kws_div); if (msubstr(preg_replace("/<[^>]+>/i", "", $list[$k]['content']), 0, 50) != preg_replace("/<[^>]+>/i", "", $list[$k]['content'])) { $list[$k]['short_content'] = msubstr(preg_replace("/<[^>]+>/i", "", $list[$k]['content']), 0, 50); } else { $list[$k]['short_content'] = preg_replace("/<br[^>]+>/i", "", $list[$k]['content']); } if ($list[$k]['origin']) { if (msubstr(preg_replace("/<[^>]+>/i", "", $list[$k]['origin']['content']), 0, 50) != preg_replace("/<[^>]+>/i", "", $list[$k]['origin']['content'])) { $list[$k]['origin']['short_content'] = msubstr(preg_replace("/<[^>]+>/i", "", $list[$k]['origin']['content']), 0, 50); } else { $list[$k]['origin']['short_content'] = preg_replace("/<br[^>]+>/i", "", $list[$k]['origin']['content']); } } } $result = array('list' => $list, 'total' => $total); if ($result['total'] > 0) { if (check_ipop_limit(get_client_ip(), "topic_search", 10, $keyword)) { $GLOBALS['db']->query("update " . DB_PREFIX . "topic_tag set count = count + 1 where name = '" . $keyword . "'"); } } //$result['list'] = div_to_col($result['list']); $GLOBALS['tmpl']->assign("topic_list", $result['list']); $page = new Page($result['total'], app_conf("PAGE_SIZE")); //初始化分页对象 $p = $page->show(); $GLOBALS['tmpl']->assign('pages', $p); $GLOBALS['tmpl']->assign('user_auth', get_user_auth()); $list_html = load_topic_list(); //$list_html = decode_topic_without_img($GLOBALS['tmpl']->fetch("inc/topic_col_list.html")); $GLOBALS['tmpl']->assign("list_html", $list_html); $GLOBALS['tmpl']->assign("type_navs", $type_navs); $GLOBALS['tmpl']->assign("filter_navs", $filter_navs); $res = load_dynamic_cache("topic_search_hot"); if ($res === false) { $res['hot_tag_list'] = $GLOBALS['db']->getAll("select name,color from " . DB_PREFIX . "topic_tag where is_recommend = 1 order by sort desc, count desc limit 10"); $res['hot_title_list'] = $GLOBALS['db']->getAll("select name,color from " . DB_PREFIX . "topic_title where is_recommend = 1 order by sort desc,count desc limit 10"); set_dynamic_cache("topic_search_hot", $res); } //输出搜索热词 $GLOBALS['tmpl']->assign("hot_tag_list", $res['hot_tag_list']); $GLOBALS['tmpl']->assign("hot_title_list", $res['hot_title_list']); //输出推荐分享 $recommend_topic = load_auto_cache("recommend_uc_topic"); $GLOBALS['tmpl']->assign("recommend_topic", $recommend_topic); $GLOBALS['tmpl']->display("topic_search.html"); }
public function index() { convert_req($_REQUEST); $_REQUEST['cid'] = intval($_REQUEST['cid']); $keyword = addslashes(htmlspecialchars(trim($_REQUEST['keyword']))); $GLOBALS['tmpl']->assign("keyword", $keyword); $url_param = array("cid" => addslashes(trim($_REQUEST['cid'])), "aid" => intval($_REQUEST['aid']), "qid" => intval($_REQUEST['qid']), "keyword" => $keyword); if (intval($_REQUEST['is_redirect']) == 1) { app_redirect(url("youhui", "event", $url_param)); } $site_nav[] = array('name' => $GLOBALS['lang']['HOME_PAGE'], 'url' => url("index", "index")); $site_nav[] = array('name' => $GLOBALS['lang']['YOUHUI_EVENT'], 'url' => url("youhui", "event#index")); $GLOBALS['tmpl']->assign("site_nav", $site_nav); //输出当前的site_nav //输出热卖 $seo_title = $GLOBALS['lang']['YOUHUI_EVENT']; $seo_keyword = $GLOBALS['lang']['YOUHUI_EVENT']; $seo_description = $GLOBALS['lang']['YOUHUI_EVENT']; // $city_id = intval($GLOBALS['deal_city']['id']); $quan_id = intval($_REQUEST['qid']); //分页 $page = intval($_REQUEST['p']); if ($page == 0) { $page = 1; } $limit = ($page - 1) * app_conf("DEAL_PAGE_SIZE") . "," . app_conf("DEAL_PAGE_SIZE"); if ($_REQUEST['plat'] == APP_PLAT) { $num = empty($_POST['num']) ? 12 : $_POST['num']; // page size $prepage = empty($_POST['prepage']) ? 0 : $_POST['prepage']; $start = $prepage * $num + 0; $limit = $start . "," . $num; } $id = intval($_REQUEST['cid']); $cate_item = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "event_cate where id = " . $id); $condition = " 1=1 "; //条件 $tp_url_param = $url_param; unset($tp_url_param['keyword']); $sub_nav[] = array("name" => $GLOBALS['lang']['YOUHUI_EVENT'], "url" => url("youhui", "event", $tp_url_param), "current" => 1); $GLOBALS['tmpl']->assign("sub_nav", $sub_nav); $GLOBALS['tmpl']->assign("url_param", $tp_url_param); //将变量输出到模板 $append_seo = ""; //输出大区 $area_id = intval($_REQUEST['aid']); if ($area_id > 0) { $area_name = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "area where id = " . $area_id); $append_seo .= $area_name; if ($quan_id > 0) { $kw_unicode = str_to_unicode_string($area_name); //有筛选 $condition .= " and (match(locate_match) against('" . $kw_unicode . "' IN BOOLEAN MODE))"; } else { $ids = load_auto_cache("deal_quan_ids", array("quan_id" => $area_id)); $quan_list = $GLOBALS['db']->getAll("select `name` from " . DB_PREFIX . "area where id in (" . implode(",", $ids) . ")"); $unicode_quans = array(); foreach ($quan_list as $k => $v) { $unicode_quans[] = str_to_unicode_string($v['name']); } $kw_unicode = implode(" ", $unicode_quans); $condition .= " and (match(locate_match) against('" . $kw_unicode . "' IN BOOLEAN MODE))"; } } $area_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "area where city_id = " . $city_id . " and pid = 0 order by sort desc"); $area_list[] = array("name" => $GLOBALS['lang']['ALL'], "id" => 0); foreach ($area_list as $k => $v) { if ($area_id == $v['id']) { $area_list[$k]['act'] = 1; } $tmp_url_param = $url_param; unset($tmp_url_param['qid']); $tmp_url_param['aid'] = $v['id']; $area_list[$k]['url'] = url("youhui", "event", $tmp_url_param); } $GLOBALS['tmpl']->assign("area_list", $area_list); if ($area_id > 0) { //输出商圈 if ($quan_id > 0) { $area_name = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "area where id = " . $quan_id); $kw_unicode = str_to_unicode_string($area_name); //有筛选 $condition .= " and (match(locate_match) against('" . $kw_unicode . "' IN BOOLEAN MODE)) "; $append_seo = $append_seo . $area_name; } $quan_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "area where city_id = " . $city_id . " and pid = " . $area_id . " order by sort desc"); $quan_list[] = array("name" => $GLOBALS['lang']['ALL'], "id" => 0); foreach ($quan_list as $k => $v) { if ($quan_id == $v['id']) { $quan_list[$k]['act'] = 1; } $tmp_url_param = $url_param; $tmp_url_param['qid'] = $v['id']; $quan_list[$k]['url'] = url("youhui", "event", $tmp_url_param); } $GLOBALS['tmpl']->assign("quan_list", $quan_list); } //输出分类 $cate_id = $cate_item['id']; $cate_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "event_cate where is_effect = 1 order by sort desc"); $cate_list[] = array("name" => $GLOBALS['lang']['ALL'], "cid" => 0); foreach ($cate_list as $k => $v) { if ($cate_id == $v['id']) { $cate_list[$k]['act'] = 1; } $tmp_url_param = $url_param; $tmp_url_param['cid'] = $v['id']; $cate_list[$k]['url'] = url("youhui", "event", $tmp_url_param); } $GLOBALS['tmpl']->assign("cate_list", $cate_list); $deal_cate_id = $cate_item['id']; $deal_quan_id = $area_id; if ($deal_cate_id > 0) { $append_seo .= $cate_item['name']; } $sort_field = es_cookie::get("event_sort_field") ? es_cookie::get("event_sort_field") : "sort"; $sort_type = es_cookie::get("event_sort_type") ? es_cookie::get("event_sort_type") : "desc"; if ($sort_field != "event_end_time" && $sort_field != "submit_count" && $sort_field != "sort") { $sort_field = "sort"; } if ($sort_type != "desc" && $sort_type != "asc") { $sort_type = "desc"; } $GLOBALS['tmpl']->assign('sort_field', $sort_field); $GLOBALS['tmpl']->assign('sort_type', $sort_type); $sort_by = $sort_field . " " . $sort_type; $seo_title = $append_seo . $seo_title; $seo_keyword = $append_seo . $seo_keyword; $seo_description = $append_seo . $seo_keyword; if ($keyword) { $kws_div = div_str($keyword); foreach ($kws_div as $k => $item) { $kw[$k] = str_to_unicode_string($item); } $ukeyword = implode(" ", $kw); $condition .= " and (match(name_match) against('" . $ukeyword . "' IN BOOLEAN MODE) or name like '%" . $keyword . "%') "; $seo_title = $keyword . " - " . $seo_title; } $result = search_event_list($limit, intval($cate_item['id']), $city_id, $condition, $sort_by); if ($_REQUEST['plat'] == APP_PLAT) { foreach ($result['list'] as $i => $v) { $result['list'][$i]['lng'] = !empty($v['xpoint']) ? $v['xpoint'] : '119.025595'; $result['list'][$i]['lat'] = !empty($v['ypoint']) ? $v['ypoint'] : '33.596043'; } $ret = array('ret' => '0', 'hb_list' => $result['list'], 'num' => $num, 'page' => $prepage + 1); array_recursive($ret, 'strval'); echo json_encode($ret); exit; } $GLOBALS['tmpl']->assign("list", $result['list']); $page = new Page($result['count'], app_conf("DEAL_PAGE_SIZE")); //初始化分页对象 $p = $page->show(); $GLOBALS['tmpl']->assign('pages', $p); $GLOBALS['tmpl']->assign("cate_id", $cate_item['id']); // $GLOBALS['tmpl']->assign("page_title", $seo_title); $GLOBALS['tmpl']->assign("page_keyword", $seo_keyword); $GLOBALS['tmpl']->assign("page_description", $seo_description); $GLOBALS['tmpl']->display("youhui_event.html"); }
public function index() { convert_req($_REQUEST); $title = $GLOBALS['lang']['DISCOVER']; $site_nav[] = array('name' => $GLOBALS['lang']['HOME_PAGE'], 'url' => APP_ROOT . "/"); $site_nav[] = array('name' => $title, 'url' => url("shop", "discover")); $GLOBALS['tmpl']->assign("site_nav", $site_nav); $cid = intval($_REQUEST['cid']); $cate_name = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "topic_tag_cate where id = " . $cid); $GLOBALS['tmpl']->assign("cid", $cid); $tag = addslashes(htmlspecialchars(trim($_REQUEST['tag']))); $GLOBALS['tmpl']->assign("tag", $tag); if ($cate_name) { $title = $title . $cate_name; } if ($tag) { $title = $title . $tag; } $GLOBALS['tmpl']->assign("page_title", $title); $GLOBALS['tmpl']->assign("page_keyword", $title . ","); $GLOBALS['tmpl']->assign("page_description", $title . ","); if ($cid == 0) { $tag_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "topic_tag where is_recommend = 1 order by sort desc limit 10"); } else { $tag_list = $GLOBALS['db']->getAll("select t.* from " . DB_PREFIX . "topic_tag as t left join " . DB_PREFIX . "topic_tag_cate_link as l on l.tag_id = t.id where l.cate_id = " . $cid . " order by t.sort desc limit 10"); } $GLOBALS['tmpl']->assign("tag_list", $tag_list); $cate_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "topic_tag_cate where showin_web = 1 order by sort desc limit 7"); $GLOBALS['tmpl']->assign("cate_list", $cate_list); $page = intval($_REQUEST['p']); if ($page == 0) { $page = 1; } $GLOBALS['tmpl']->assign("page", $page); if ($cid > 0) { if ($cate_name) { $unicode_cate_name = str_to_unicode_string($cate_name); $condition .= " and match(cate_match) against('" . $unicode_cate_name . "' IN BOOLEAN MODE) "; } } if ($tag != "") { $unicode_tag = str_to_unicode_string($tag); $condition .= " and match(keyword_match) against('" . $unicode_tag . "' IN BOOLEAN MODE) "; } $sql = "select count(*) from " . DB_PREFIX . "topic where is_effect = 1 and is_delete = 0 and fav_id = 0 and relay_id = 0 and type in ('share','sharetuan','sharegoods','sharefyouhui','sharebyouhui','shareevent') " . $condition; $count = $GLOBALS['db']->getOne($sql); $page_size = PAGE_SIZE; $page = new Page($count, $page_size); //初始化分页对象 $p = $page->show(); $GLOBALS['tmpl']->assign('pages', $p); $remain_count = $count - ($page - 1) * $page_size; //从当前页算起剩余的数量 $remain_page = ceil($remain_count / $page_size); //剩余的页数 if ($remain_page == 1) { //末页 $step_size = ceil($remain_count / SECTOR); } else { $step_size = ceil(PAGE_SIZE / SECTOR); } $GLOBALS['tmpl']->assign('step_size', $step_size); $GLOBALS['tmpl']->display("discover_index.html"); }