function get_side_deal($deal_id) { $city = get_current_deal_city(); $city_id = $city['id']; $side_deal_list = get_deal_list_show(app_conf("SIDE_DEAL_COUNT"), intval($GLOBALS['deal_cate_id']), $city_id, array(DEAL_ONLINE), "id<>" . $deal_id . " and buy_type <> 1 "); return $side_deal_list['list']; }
public function all() { $city_name = trim(addslashes($_REQUEST['city'])); if ($city_name) { $deal_city = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "deal_city where uname='' and is_effect = 1 and is_delete = 0"); } if (!$deal_city) { $deal_city = get_current_deal_city(); } es_cookie::set("deal_city", $deal_city['id']); app_redirect(url("index")); }
function get_supplier_list($limit, $cate_id = 0, $city_id = 0, $where = '') { $condition = " is_effect = 1 "; if ($cate_id > 0) { $ids = load_auto_cache("deal_sub_parent_cate_ids", array("cate_id" => $cate_id)); $condition .= " and cate_id in (" . implode(",", $ids) . ")"; } if ($city_id == 0) { $city = get_current_deal_city(); $city_id = $city['id']; } if ($city_id > 0) { $ids = load_auto_cache("deal_city_belone_ids", array("city_id" => $city_id)); if ($ids) { $condition .= " and city_id in (" . implode(",", $ids) . ")"; } } if ($where != '') { $condition .= " and " . $where; } $sql = "select * from " . DB_PREFIX . "supplier where " . $condition . " order by sort desc limit " . $limit; $count_sql = "select count(*) from " . DB_PREFIX . "supplier where " . $condition; $suppliers = $GLOBALS['db']->getAll($sql); $suppliers_count = $GLOBALS['db']->getOne($count_sql); foreach ($suppliers as $k => $v) { $suppliers[$k]['url'] = url("shop", "brand", array("id" => $v['id'])); $main_location = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "supplier_location where supplier_id = " . $v['id'] . " and is_main = 1"); $suppliers[$k]['tel'] = $main_location['tel']; $suppliers[$k]['address'] = $main_location['address']; $suppliers[$k]['contact'] = $main_location['contact']; $suppliers[$k]['brief'] = $main_location['brief']; $suppliers[$k]['deal_count'] = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "deal where supplier_id = " . $v['id'] . " and is_effect = 1 and is_delete = 0 and buy_type <> 1 and time_status > 0"); $max_price = $GLOBALS['db']->getOne("select max(current_price) from " . DB_PREFIX . "deal where supplier_id = " . $v['id'] . " and is_effect = 1 and is_delete = 0 and buy_type <> 1"); $min_price = $GLOBALS['db']->getOne("select min(current_price) from " . DB_PREFIX . "deal where supplier_id = " . $v['id'] . " and is_effect = 1 and is_delete = 0 and buy_type <> 1"); if ($max_price == $min_price) { $suppliers[$k]['deal_price'] = format_price($max_price); } else { $suppliers[$k]['deal_price'] = format_price($min_price) . " - " . format_price($max_price); } $suppliers[$k]['comment_count'] = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "message where rel_table='supplier' and rel_id = " . $v['id']); $suppliers[$k]['comment1_count'] = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "message where rel_table='supplier' and rel_id = " . $v['id'] . " and point = 1"); //差 $suppliers[$k]['comment2_count'] = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "message where rel_table='supplier' and rel_id = " . $v['id'] . " and point = 2"); //中 $suppliers[$k]['comment3_count'] = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "message where rel_table='supplier' and rel_id = " . $v['id'] . " and point = 3"); //好 } return array('list' => $suppliers, 'count' => $suppliers_count); }
public function index() { $rss = new UniversalFeedCreator(); $rss->useCached(); // use cached version if age<1 hour $rss->title = app_conf("SHOP_TITLE") . " - " . app_conf("SHOP_SEO_TITLE"); $rss->description = app_conf("SHOP_SEO_TITLE"); //optional $rss->descriptionTruncSize = 500; $rss->descriptionHtmlSyndicated = true; $rss->link = get_domain() . APP_ROOT; $rss->syndicationURL = get_domain() . APP_ROOT; //optional $image->descriptionTruncSize = 500; $image->descriptionHtmlSyndicated = true; $domain = app_conf("PUBLIC_DOMAIN_ROOT") == '' ? get_domain() . $GLOBALS['IMG_APP_ROOT'] : app_conf("PUBLIC_DOMAIN_ROOT"); $city = get_current_deal_city(); $city_id = $city['id']; $deal_list = get_deal_list(app_conf("DEAL_PAGE_SIZE"), 0, 0, array(DEAL_ONLINE), " buy_type <> 1 or ( is_shop = 1 and is_effect =1 and is_delete = 0 and buy_type <> 1)"); $deal_list = $deal_list['list']; foreach ($deal_list as $data) { $item = new FeedItem(); if ($data['uname'] != '') { $gurl = url("shop", "goods", array("id" => $data['uname'])); } else { $gurl = url("shop", "goods", array("id" => $data['id'])); } $data['url'] = $gurl; $item->title = msubstr($data['name'], 0, 30); $item->link = get_domain() . $data['url']; $data['description'] = str_replace($GLOBALS['IMG_APP_ROOT'] . "./public/", $domain . "/public/", $data['description']); $data['description'] = str_replace("./public/", $domain . "/public/", $data['description']); $data['img'] = str_replace("./public/", $domain . "/public/", $data['img']); $item->description = "<img src='" . $data['img'] . "' /><br />" . $data['brief'] . "<br /> <a href='" . get_domain() . $data['url'] . "' target='_blank' >" . $GLOBALS['lang']['VIEW_DETAIL'] . "</a>"; //optional $item->descriptionTruncSize = 500; $item->descriptionHtmlSyndicated = true; if ($data['end_time'] != 0) { $item->date = date('r', $data['end_time']); } $item->source = $data['url']; $item->author = app_conf("SHOP_TITLE"); $rss->addItem($item); } $rss->saveFeed($format = "RSS0.91", $filename = APP_ROOT_PATH . "public/runtime/app/tpl_caches/rss.xml"); }
public function addmail() { $ajax = intval($_REQUEST['ajax']); if (!check_ipop_limit(get_client_ip(), "subscribe#addmail", intval(app_conf("SUBMIT_DELAY")), 0)) { showErr($GLOBALS['lang']['SUBMIT_TOO_FAST'], $ajax); } if (trim($_REQUEST['email']) == '') { showErr($GLOBALS['lang']['EMAIL_EMPTY_TIP'], $ajax); } if (!check_email($_REQUEST['email'])) { showErr($GLOBALS['lang']['EMAIL_FORMAT_ERROR_TIP'], $ajax); } if ($_REQUEST['othercity'] && trim($_REQUEST['othercity']) != '') { //提交其他城市 $other_city = htmlspecialchars(addslashes($_REQUEST['othercity'])); $other_city_item = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "deal_city where name = '" . $other_city . "'"); if ($other_city_item) { $city_id = $other_city_item['id']; } else { $new_city['name'] = $other_city; $new_city['pid'] = $GLOBALS['db']->getOne("select id from " . DB_PREFIX . "deal_city where pid = 0"); $GLOBALS['db']->autoExecute(DB_PREFIX . "deal_city", $new_city); $city_id = $GLOBALS['db']->insert_id(); } } elseif (intval($_REQUEST['cityid']) != 0) { $city_id = intval($_REQUEST['cityid']); } else { $city_item = get_current_deal_city(); $city_id = $city_item['id']; } $mail_item['mail_address'] = addslashes(trim(htmlspecialchars($_REQUEST['email']))); $mail_item['city_id'] = $city_id; $mail_item['is_effect'] = 1; if ($GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "mail_list where mail_address='" . $mail_item['mail_address'] . "'") == 0) { //没有订阅过 $GLOBALS['db']->autoExecute(DB_PREFIX . "mail_list", $mail_item); } showSuccess($GLOBALS['lang']['SUBSCRIBE_SUCCESS'], $ajax); }
/** * 获取正在团购的产品列表 */ function get_deal_list_show($limit, $cate_id = 0, $city_id = 0, $type = array(DEAL_ONLINE, DEAL_HISTORY, DEAL_NOTICE), $where = '', $orderby = '') { $time = get_gmtime(); $time_condition = ' and is_shop = 0 and ( 1<>1 '; if (in_array(DEAL_ONLINE, $type)) { //进行中的团购 $time_condition .= " or ((" . $time . ">= begin_time or begin_time = 0) and (" . $time . "<end_time or end_time = 0) and buy_status <> 2) "; } if (in_array(DEAL_HISTORY, $type)) { //往期团购 $time_condition .= " or ((" . $time . ">=end_time and end_time <> 0) or buy_status = 2) "; } if (in_array(DEAL_NOTICE, $type)) { //预告 $time_condition .= " or ((" . $time . " < begin_time and begin_time <> 0 and notice = 1)) "; } $time_condition .= ')'; $count_sql = "select count(*) from " . DB_PREFIX . "deal where is_effect = 1 and is_delete = 0 " . $time_condition; $sql = "select * from " . DB_PREFIX . "deal where is_effect = 1 and is_delete = 0 " . $time_condition; if ($cate_id > 0) { $ids = load_auto_cache("deal_sub_parent_cate_ids", array("cate_id" => $cate_id)); $sql .= " and cate_id in (" . implode(",", $ids) . ")"; $count_sql .= " and cate_id in (" . implode(",", $ids) . ")"; } if ($city_id == 0) { $city = get_current_deal_city(); $city_id = $city['id']; } if ($city_id > 0) { $ids = load_auto_cache("deal_city_belone_ids", array("city_id" => $city_id)); $sql .= " and city_id in (" . implode(",", $ids) . ")"; $count_sql .= " and city_id in (" . implode(",", $ids) . ")"; } if ($where != '') { $sql .= " and " . $where; $count_sql .= " and " . $where; } if ($orderby == '') { $sql .= " order by sort desc limit " . $limit; } else { $sql .= " order by " . $orderby . " limit " . $limit; } $deals = $GLOBALS['db']->getAll($sql); $deals_count = $GLOBALS['db']->getOne($count_sql); if ($deals) { foreach ($deals as $k => $deal) { //格式化数据 $deal['begin_time_format'] = to_date($deal['begin_time']); $deal['end_time_format'] = to_date($deal['end_time']); $deal['origin_price_format'] = format_price($deal['origin_price']); $deal['current_price_format'] = format_price($deal['current_price']); $deal['success_time_format'] = to_date($deal['success_time']); if ($deal['origin_price'] > 0 && floatval($deal['discount']) == 0) { //手动折扣 $deal['save_price'] = $deal['origin_price'] - $deal['current_price']; } else { $deal['save_price'] = $deal['origin_price'] * ((10 - $deal['discount']) / 10); } if ($deal['origin_price'] > 0 && floatval($deal['discount']) == 0) { $deal['discount'] = round($deal['current_price'] / $deal['origin_price'] * 10, 2); } $deal['discount'] = round($deal['discount'], 2); $deal['save_price_format'] = format_price($deal['save_price']); if ($deal['uname'] != '') { $durl = url("tuan", "deal", array("id" => $deal['uname'])); } else { $durl = url("tuan", "deal", array("id" => $deal['id'])); } $deal['url'] = $durl; $deal['deal_success_num'] = sprintf($GLOBALS['lang']['SUCCESS_BUY_COUNT'], $deal['buy_count']); $deal['current_bought'] = $deal['buy_count']; if ($deal['buy_status'] == 0) { $deal['success_less'] = sprintf($GLOBALS['lang']['SUCCESS_LESS_BUY_COUNT'], $deal['min_bought'] - $deal['buy_count']); } $deals[$k] = $deal; } } return array('list' => $deals, 'count' => $deals_count); }
public function index2() { $quan_id = intval($GLOBALS['request']['quan_id']); //商圈ID $city_id = intval($GLOBALS['request']['city_id']); $city_name = strim($GLOBALS['request']['city_name']); //城市分类ID //print_r($GLOBALS['request']); $root = array(); $root['return'] = 1; $city_list = $GLOBALS['db']->getAll("select *from " . DB_PREFIX . "deal_city where is_effect=1 and is_delete=0 order by id asc"); $root['city_list'] = $city_list; if ($city_id > 0) { /*当前城市商圈*/ $indexs_quan = $GLOBALS['cache']->get("MOBILE_INDEX2_QUAN_" . intval($GLOBALS['city_id'])); if ($indexs_quan === false) { $indexs_quan = $GLOBALS['db']->getAll("select id,name from " . DB_PREFIX . "area where pid=0 and city_id=" . $city_id . " order by sort desc"); } if ($indexs_quan) { $root['quans'] = $indexs_quan; } else { $root['quans'] = array(); } $root['quan_id'] = $quan_id; /*城市列表*/ /*当前城市热门团购(正在团购 的推荐商品)*/ $time = get_gmtime(); $condition = " is_effect = 1 and is_delete = 0 and is_shop = 0 and (" . $time . ">= begin_time or begin_time = 0) and (" . $time . "< end_time or end_time = 0) and buy_status <> 2"; if ($city_id == 0) { $city = get_current_deal_city(); $city_id = $city['id']; } if ($city_id > 0) { $ids = load_auto_cache("deal_city_belone_ids", array("city_id" => $city_id)); if ($ids) { $condition .= " and city_id in (" . implode(",", $ids) . ")"; } } if ($quan_id > 0) { $ids = load_auto_cache("deal_quan_ids", array("quan_id" => $quan_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))"; } $sql = "select id,name,sub_name,icon,origin_price,current_price,buy_count from " . DB_PREFIX . "deal where " . $condition . " order by is_recommend desc,sort desc limit 20"; $deal_list = $GLOBALS['db']->getAll($sql); $taday_begin = to_timespan(to_date(get_gmtime(), 'Y-m-d')); $taday_end = $taday_begin * 24 * 60 * 60; foreach ($deal_list as $k => $v) { $deal_list[$k]['current_price'] = round($v['current_price'], 2); $deal_list[$k]['origin_price'] = round($v['origin_price'], 2); $deal_list[$k]['icon'] = get_abs_img_root(get_spec_image($v['icon'], 300, 181, 0)); if ($v['begin_time'] > 0 && ($taday_begin < $v['begin_time'] && $v['begin_time'] < $taday_end)) { $deal_list[$k]['is_taday'] = 1; } else { if ($v['begin_time'] == 0 && ($taday_begin < $v['create_time'] && $v['create_time'] < $taday_end)) { $deal_list[$k]['is_taday'] = 1; } else { $deal_list[$k]['is_taday'] = 0; } } unset($deal_list[$k]['begin_time'], $deal_list[$k]['create_time']); } if ($deal_list) { $root['deal_list'] = $deal_list; } else { $root['deal_list'] = array(); } } else { $root['quans'] = array(); $root['quan_id'] = 0; $root['deal_list'] = array(); } $root['city_name'] = $city_name; $root['page_title'] = "选择城市"; output($root); }
public function index() { $GLOBALS['tmpl']->caching = true; $cache_id = md5(MODULE_NAME . ACTION_NAME . $GLOBALS['deal_city']['id']); if (!$GLOBALS['tmpl']->is_cached('mall.html', $cache_id)) { //输出商城分类 $cate_tree = get_cate_tree(0, 1); $top_count = 0; foreach ($cate_tree as $k => $v) { if ($v['level'] == 0) { $top_count++; } // if($top_count>6) // { // $cate_tree[$k]['is_hide'] = 1; // } } $GLOBALS['tmpl']->assign("cate_tree", $cate_tree); //获取推荐 $hot_list = get_goods_list(intval(app_conf("REC_HOT_LIMIT")), 0, " is_hot = 1 and buy_type <> 1", "", false); $best_list = get_goods_list(intval(app_conf("REC_BEST_LIMIT")), 0, " is_best = 1 and buy_type <> 1 ", "", false); $new_list = get_goods_list(intval(app_conf("REC_NEW_LIMIT")), 0, " is_new = 1 and buy_type <> 1 ", "", false); $GLOBALS['tmpl']->assign("inc_var", array('title' => $GLOBALS['lang']['HOT_LIST'], 'list' => $hot_list['list'], 'url' => url("shop", "rec#rhot"))); $hot_span_goods_html = $GLOBALS['tmpl']->fetch("inc/span_goods.html"); $GLOBALS['tmpl']->assign("hot_span_goods_html", $hot_span_goods_html); $GLOBALS['tmpl']->assign("inc_var", array('title' => $GLOBALS['lang']['BEST_LIST'], 'list' => $best_list['list'], 'url' => url("shop", "rec#rbest"))); $best_span_goods_html = $GLOBALS['tmpl']->fetch("inc/span_goods.html"); $GLOBALS['tmpl']->assign("best_span_goods_html", $best_span_goods_html); $GLOBALS['tmpl']->assign("inc_var", array('title' => $GLOBALS['lang']['NEW_LIST'], 'list' => $new_list['list'], 'url' => url("shop", "rec#rnew"))); $new_span_goods_html = $GLOBALS['tmpl']->fetch("inc/span_goods.html"); $GLOBALS['tmpl']->assign("new_span_goods_html", $new_span_goods_html); $recommend_cate = $GLOBALS['db']->getAll("select id,name,uname from " . DB_PREFIX . "shop_cate where grade = 0 order by sort desc"); //输出分类商品 $recommend_cate_html = ""; foreach ($recommend_cate as $cate => $catev) { require_once APP_ROOT_PATH . "system/utils/child.php"; $ids_util = new child("shop_cate"); $ids = $ids_util->getChildIds($catev['id']); $ids[] = $catev['id']; $brand_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "brand where shop_cate_id in (" . implode(",", $ids) . ") limit 8"); foreach ($brand_list as $kk => $brand_item) { $brand_list[$kk]['url'] = url("shop", "brand#index", array("id" => $brand_item['id'])); } //商城推荐分类列表 $time = get_gmtime(); $count_sql = "select count(*) from " . DB_PREFIX . "deal where is_effect = 1 and is_delete = 0 and p_shop_cate_id=" . $catev['id']; $sql = "select * from " . DB_PREFIX . "deal where is_effect = 1 and is_delete = 0 and p_shop_cate_id=" . $catev['id']; $city = get_current_deal_city(); $city_id = $city['id']; if ($city_id > 0) { $ids = load_auto_cache("deal_city_belone_ids", array("city_id" => $city_id)); if ($ids) { $sql .= " and city_id in (" . implode(",", $ids) . ")"; $count_sql .= " and city_id in (" . implode(",", $ids) . ")"; } } $sql .= " and buy_type <> 1 "; $count_sql .= " and buy_type <> 1 "; $sql .= " order by sort desc limit 10 "; $deals = $GLOBALS['db']->getAll($sql); $deals_count = $GLOBALS['db']->getOne($count_sql); if ($deals) { foreach ($deals as $k => $deal) { if ($deal['buy_type'] == 1) { $module = "exchange"; } else { $module = "goods"; } if ($deal['uname'] != '') { $durl = url("shop", $module, array("id" => $deal['uname'])); } else { $durl = url("shop", $module, array("id" => $deal['id'])); } $deal['url'] = $durl; $deals[$k] = $deal; } } $cate_list = array('list' => $deals, 'count' => $deals_count); //$cate_list=$catev['id']; //$cate_list['sd'] = get_goods_list(intval(app_conf("REC_CATE_GOODS_LIMIT")),$catev['id']," buy_type <> 1 ","",false); $cate_title = $catev['name']; if ($catev['uname'] != "") { $curl = url("shop", "cate#index", array("id" => $catev['uname'])); } else { $curl = url("shop", "cate#index", array("id" => $catev['id'])); } $GLOBALS['tmpl']->assign("inc_var", array('id' => $catev['id'], 'brand_list' => $brand_list, 'title' => $cate_title, 'list' => $cate_list['list'], 'url' => $curl)); $recommend_cate_html .= $GLOBALS['tmpl']->fetch("inc/recommend_cate_goods.html"); } $GLOBALS['tmpl']->assign("recommend_cate_html", $recommend_cate_html); $GLOBALS['tmpl']->assign("page_title", app_conf("MALL_SHOP_TITLE")); $GLOBALS['tmpl']->assign("page_keyword", app_conf("MALL_SHOP_TITLE")); $GLOBALS['tmpl']->assign("page_description", app_conf("MALL_SHOP_TITLE")); //输出商城公告 $notice_list = get_notice(0, array(0, 2)); $GLOBALS['tmpl']->assign("notice_list", $notice_list); } $GLOBALS['tmpl']->display("mall.html", $cache_id); }
public function index() { $cur_city_id = intval($GLOBALS['request']['cur_city_id']); if ($cur_city_id == 0) { $deal_city = get_current_deal_city(); //默认城市id //print_r($deal_city); exit; $cur_city_id = $deal_city['id']; $city_name = $deal_city['name']; } else { $city_name = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "deal_city where id = " . $cur_city_id); } $root = array(); $root['return'] = 1; $root['city_id'] = $cur_city_id; $root['city_name'] = $city_name; $root['catalog_id'] = intval($GLOBALS['m_config']['catalog_id']); //团购,优惠券默认分类id $root['catalog_id_name'] = $GLOBALS['m_config']['catalog_id_name']; $root['shop_cate_id'] = intval($GLOBALS['m_config']['shop_cate_id']); //商城默认分类id $root['shop_cate_id_name'] = $GLOBALS['m_config']['shop_cate_id_name']; $root['event_cate_id'] = intval($GLOBALS['m_config']['event_cate_id']); //活动默认分类id $root['event_cate_id_name'] = $GLOBALS['m_config']['event_cate_id_name']; $root['citylist'] = getCityArray(); //$root['cataloglist'] = getCatalogArray(); //$root['cataloglistsearch'] = getCatalogArraySearch(); $root['region_version'] = intval($GLOBALS['m_config']['region_version']); //当前配送地区的数据版本(如果大于客户端的版本号,则客户端在选择,配送地区时会提示升级),int 数字类型 $root['only_one_delivery'] = intval($GLOBALS['m_config']['only_one_delivery']); //1:会员只有一个配送地址;0:会员可以有多个配送地址 $root['kf_phone'] = $GLOBALS['m_config']['kf_phone']; //客服电话 $root['kf_email'] = $GLOBALS['m_config']['kf_email']; //客服邮箱 $root['about_info'] = $GLOBALS['m_config']['about_info']; $root['version'] = VERSION; //接口版本号int $root['page_size'] = PAGE_SIZE; //默认分页大小 $root['has_region'] = intval($GLOBALS['m_config']['has_region']); $root['newslist'] = $GLOBALS['m_config']['newslist']; $root['program_title'] = $GLOBALS['m_config']['program_title']; $root['addr_tlist'] = $GLOBALS['m_config']['addr_tlist']; //保存地址标题 //$root['adv_youhui'] = m_adv_youhui($cur_city_id); $root['quanlist'] = getQuanArray($cur_city_id); //商圈列表 $root['deal_cate_list'] = getDealCateArray(); //优惠券分类 $root['index_logo'] = get_abs_img_root($GLOBALS['m_config']['index_logo']); 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); }
function m_search_youhui_list($limit, $cate_id = 0, $where = '', $orderby = '', $city_id = 0, $field_append = "") { if ($city_id == 0) { $city = get_current_deal_city(); $city_id = $city['id']; } $count_sql = "select count(*) from " . DB_PREFIX . "deal "; $sql = "select * {$field_append} from " . DB_PREFIX . "deal "; $time = get_gmtime(); $time_condition = ' and (end_time = 0 or end_time > ' . $time . ') '; $count_sql .= " where is_effect = 1 and is_delete = 0 and is_shop = 2 " . $time_condition; $sql .= " where is_effect = 1 and is_delete = 0 and is_shop = 2 " . $time_condition; if ($cate_id > 0) { $ids = load_auto_cache("deal_sub_cate_ids", array("cate_id" => $cate_id)); $sql .= " and cate_id in (" . implode(",", $ids) . ")"; $count_sql .= " and cate_id in (" . implode(",", $ids) . ")"; } if ($city_id > 0) { $ids = load_auto_cache("deal_city_belone_ids", array("city_id" => $city_id)); if ($ids) { $sql .= " and city_id in (" . implode(",", $ids) . ")"; $count_sql .= " and city_id in (" . implode(",", $ids) . ")"; } } $merchant_id = intval($GLOBALS['request']['merchant_id']); if ($merchant_id > 0) { $deal_ids = $GLOBALS['db']->getOne("select group_concat(deal_id) from " . DB_PREFIX . "deal_location_link where location_id = " . $merchant_id); if ($deal_ids) { $sql .= " and id in (" . $deal_ids . ")"; $count_sql .= " and id in (" . $deal_ids . ")"; } else { $sql .= " and id = 0 "; $count_sql .= " and id = 0 "; } } if ($where != '') { $sql .= " and " . $where; $count_sql .= " and " . $where; } if ($orderby == '') { $sql .= " order by sort desc limit " . $limit; } else { $sql .= " order by " . $orderby . " limit " . $limit; } $deals = $GLOBALS['db']->getAll($sql); $deals_count = $GLOBALS['db']->getOne($count_sql); if ($deals) { foreach ($deals as $k => $deal) { //格式化数据 $deal['origin_price_format'] = format_price($deal['origin_price']); $deal['current_price_format'] = format_price($deal['current_price']); if ($deal['origin_price'] > 0 && floatval($deal['discount']) == 0) { //手动折扣 $deal['save_price'] = $deal['origin_price'] - $deal['current_price']; } else { $deal['save_price'] = $deal['origin_price'] * ((10 - $deal['discount']) / 10); } if ($deal['origin_price'] > 0 && floatval($deal['discount']) == 0) { $deal['discount'] = round($deal['current_price'] / $deal['origin_price'] * 10, 2); } $deal['discount'] = round($deal['discount'], 2); $deal['save_price_format'] = format_price($deal['save_price']); if ($deal['uname'] != '') { $durl = url("youhui", "ydetail", array("id" => $deal['uname'])); } else { $durl = url("youhui", "ydetail", array("id" => $deal['id'])); } $deal['url'] = $durl; $deals[$k] = $deal; } } $res = array('list' => $deals, 'count' => $deals_count); return $res; }
/** * 搜索活动列表 */ function search_event_list($limit, $cate_id = 0, $city_id = 0, $where = '', $orderby = '', $cached = false) { $key = md5("EVENT_" . $limit . $cate_id . $city_id . $where . $orderby); if ($cached) { $res = $GLOBALS['cache']->get($key); } else { $res = false; } if ($res === false) { $count_sql = "select count(*) from " . DB_PREFIX . "event "; $sql = "select * from " . DB_PREFIX . "event "; $count_sql .= " where is_effect = 1 "; $sql .= " where is_effect = 1 "; if ($cate_id > 0) { $sql .= " and cate_id = " . $cate_id . " "; $count_sql .= " and cate_id = " . $cate_id . " "; } if ($city_id == 0) { $city = get_current_deal_city(); $city_id = $city['id']; } if ($city_id > 0) { $ids = load_auto_cache("deal_city_belone_ids", array("city_id" => $city_id)); if ($ids) { $sql .= " and city_id in (" . implode(",", $ids) . ")"; $count_sql .= " and city_id in (" . implode(",", $ids) . ")"; } } if ($where != '') { $sql .= " and " . $where; $count_sql .= " and " . $where; } if ($orderby == '') { $sql .= " order by is_recommend desc,sort desc "; } else { $sql .= " order by is_recommend desc," . $orderby . " "; } if ($limit != "") { $sql .= " limit " . $limit . " "; } $events = $GLOBALS['db']->getAll($sql); $events_count = $GLOBALS['db']->getOne($count_sql); $res = array('list' => $events, 'count' => $events_count); $GLOBALS['cache']->set($key, $res); } return $res; }
/** * 获取指定的团购产品 */ function get_referral_deal($id = 0, $cate_id = 0, $city_id = 0) { $time = get_gmtime(); if ($id > 0) { $deal = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "deal where id = " . intval($id) . " and is_referral = 1 and is_effect = 1 and is_delete = 0 and (" . $time . ">= begin_time or begin_time = 0 or notice = 1) "); } if (!$deal) { $sql = "select * from " . DB_PREFIX . "deal where is_referral = 1 and is_effect = 1 and is_delete = 0 and buy_type <> 1 and (" . $time . ">= begin_time or begin_time = 0 or notice = 1) and (" . $time . "<end_time or end_time = 0) and buy_status <> 2 "; if ($cate_id > 0) { $ids = load_auto_cache("deal_sub_parent_cate_ids", array("cate_id" => $cate_id)); $sql .= " and cate_id in (" . implode(",", $ids) . ")"; } if ($city_id == 0) { $city = get_current_deal_city(); $city_id = $city['id']; } if ($city_id > 0) { $ids = load_auto_cache("deal_city_belone_ids", array("city_id" => $city_id)); if ($ids) { $sql .= " and city_id in (" . implode(",", $ids) . ")"; } } $sql .= " order by sort desc"; $deal = $GLOBALS['db']->getRow($sql); } if ($deal) { if ($deal['time_status'] == 0 && $deal['begin_time'] == 0 || $deal['begin_time'] < get_gmtime()) { syn_deal_status($deal['id']); $deal = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "deal where is_referral = 1 and id = " . $deal['id'] . " and is_effect = 1 and is_delete = 0"); } //格式化数据 $deal['begin_time_format'] = to_date($deal['begin_time']); $deal['end_time_format'] = to_date($deal['end_time']); $deal['origin_price_format'] = format_price($deal['origin_price']); $deal['current_price_format'] = format_price($deal['current_price']); $deal['success_time_format'] = to_date($deal['success_time']); if ($deal['origin_price'] > 0 && floatval($deal['discount']) == 0) { //手动折扣 $deal['save_price'] = $deal['origin_price'] - $deal['current_price']; } else { $deal['save_price'] = $deal['origin_price'] * ((10 - $deal['discount']) / 10); } if ($deal['origin_price'] > 0 && floatval($deal['discount']) == 0) { $deal['discount'] = round($deal['current_price'] / $deal['origin_price'] * 10, 2); } $deal['discount'] = round($deal['discount'], 2); $deal['save_price_format'] = format_price($deal['save_price']); $deal['deal_success_num'] = sprintf($GLOBALS['lang']['SUCCESS_BUY_COUNT'], $deal['buy_count']); $deal['current_bought'] = $deal['buy_count']; if ($deal['buy_status'] == 0) { $deal['success_less'] = sprintf($GLOBALS['lang']['SUCCESS_LESS_BUY_COUNT'], $deal['min_bought'] - $deal['buy_count']); } $deal['success_time_tip'] = sprintf($GLOBALS['lang']['SUCCESS_TIME_TIP'], $deal['success_time_format'], $deal['min_bought']); //团购图片集 $img_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "deal_gallery where deal_id=" . intval($deal['id']) . " order by sort asc"); $deal['image_list'] = $img_list; //商户信息 $deal['supplier_info'] = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "supplier where id = " . intval($deal['supplier_id'])); $deal['supplier_address_info'] = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "supplier_location where supplier_id = " . intval($deal['supplier_id']) . " and is_main = 1"); //属性列表 $deal_attrs_res = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "deal_attr where deal_id = " . intval($deal['id']) . " order by id asc"); if ($deal_attrs_res) { foreach ($deal_attrs_res as $k => $v) { $deal_attr[$v['goods_type_attr_id']]['name'] = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "goods_type_attr where id = " . intval($v['goods_type_attr_id'])); $deal_attr[$v['goods_type_attr_id']]['attrs'][] = $v; } $deal['deal_attr_list'] = $deal_attr; } if ($deal['uname'] != '') { $durl = url("tuan", "deal", array("id" => $deal['uname'])); } else { $durl = url("tuan", "deal", array("id" => $deal['id'])); } $deal['share_url'] = get_domain() . $durl; if ($GLOBALS['user_info']) { if (app_conf("URL_MODEL") == 0) { $deal['share_url'] .= "&r=" . base64_encode(intval($GLOBALS['user_info']['id'])); } else { $deal['share_url'] .= "?r=" . base64_encode(intval($GLOBALS['user_info']['id'])); } } } return $deal; }
/** * 获取产品列表 */ function search_goods_list($limit, $cate_id = 0, $where = '', $orderby = '', $cached = true, $join_str = '') { $key = md5($limit . $cate_id . $where . $orderby . $join_str); if ($cached) { $res = $GLOBALS['cache']->get($key); } else { $res = false; } if ($res === false) { $count_sql = "select count(*) from " . DB_PREFIX . "deal as d"; $sql = "select d.* from " . DB_PREFIX . "deal as d "; if ($join_str != '') { $count_sql .= $join_str; $sql .= $join_str; } $time = get_gmtime(); $time_condition = ' and (d.is_shop=1 or d.shop_cate_id <> 0 ) '; $count_sql .= " where d.is_effect = 1 and d.is_delete = 0 " . $time_condition; $sql .= " where d.is_effect = 1 and d.is_delete = 0 " . $time_condition; if ($cate_id > 0) { $ids = load_auto_cache("shop_sub_cate_ids", array("cate_id" => $cate_id)); $sql .= " and d.shop_cate_id in (" . implode(",", $ids) . ")"; $count_sql .= " and d.shop_cate_id in (" . implode(",", $ids) . ")"; } $city = get_current_deal_city(); $city_id = $city['id']; if ($city_id > 0) { $ids = load_auto_cache("deal_city_belone_ids", array("city_id" => $city_id)); if ($ids) { $sql .= " and city_id in (" . implode(",", $ids) . ")"; $count_sql .= " and city_id in (" . implode(",", $ids) . ")"; } } if ($where != '') { $sql .= " and " . $where; $count_sql .= " and " . $where; } if ($orderby == '') { $sql .= " order by d.sort desc limit " . $limit; } else { $sql .= " order by " . $orderby . " limit " . $limit; } $deals = $GLOBALS['db']->getAll($sql); $deals_count = $GLOBALS['db']->getOne($count_sql); if ($deals) { foreach ($deals as $k => $deal) { //格式化数据 $deal['origin_price_format'] = format_price($deal['origin_price']); $deal['current_price_format'] = format_price($deal['current_price']); if ($deal['origin_price'] > 0 && floatval($deal['discount']) == 0) { //手动折扣 $deal['save_price'] = $deal['origin_price'] - $deal['current_price']; } else { $deal['save_price'] = $deal['origin_price'] * ((10 - $deal['discount']) / 10); } if ($deal['origin_price'] > 0 && floatval($deal['discount']) == 0) { $deal['discount'] = round($deal['current_price'] / $deal['origin_price'] * 10, 2); } $deal['discount'] = round($deal['discount'], 2); $deal['save_price_format'] = format_price($deal['save_price']); if ($deal['uname'] != '') { $durl = url("shop", "goods", array("id" => $deal['uname'])); } else { $durl = url("shop", "goods", array("id" => $deal['id'])); } $deal['url'] = $durl; $deals[$k] = $deal; } } $res = array('list' => $deals, 'count' => $deals_count); $GLOBALS['cache']->set($key, $res); } return $res; }
if (!file_exists(APP_ROOT_PATH . 'public/runtime/app/')) { mkdir(APP_ROOT_PATH . 'public/runtime/app/', 0777); } //处理城市 //$city_count = $GLOBALS['db']->getOne("select count(id) from ".DB_PREFIX."deal_city where is_effect = 1 and is_delete = 0"); $city_name = trim(addslashes($_REQUEST['city'])); $deal_city = ''; if ($city_name) { if ($city_name == 'all') { $deal_city = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "deal_city where pid = 0"); } else { $deal_city = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "deal_city where uname='" . $city_name . "' and is_effect = 1 and is_delete = 0"); } } if (!$deal_city) { $deal_city = get_current_deal_city(); } es_cookie::set("deal_city", $deal_city['id'], 24 * 3600 * 30); $GLOBALS['tmpl']->assign("deal_city", $deal_city); //输出城市 $deal_city_list = get_deal_citys(); $GLOBALS['tmpl']->assign("deal_city_list", $deal_city_list['ls']); $GLOBALS['tmpl']->assign("deal_city_list_zm", $deal_city_list['zm']); $GLOBALS['tmpl']->assign("shop_info", get_shop_info()); $GLOBALS['tmpl']->assign("deal_city", $deal_city); $GLOBALS['tmpl']->assign("show_city_title", true); if (count($deal_city_list['ls']) > 1) { $GLOBALS['tmpl']->assign("city_title", $deal_city['name']); } //输出根路径 $GLOBALS['tmpl']->assign("APP_ROOT", APP_ROOT);