public function load($param)
{
$param = array("cate_id" => $param['cate_id']);
$key = $this->build_key(__CLASS__, $param);
$GLOBALS['cache']->set_dir(APP_ROOT_PATH . "public/runtime/data/" . __CLASS__ . "/");
$ids = $GLOBALS['cache']->get($key);
if ($ids === false) {
$param['cate_id'] = intval($GLOBALS['db']->getOne("select id from " . DB_PREFIX . "deal_cate where id = " . intval($param['cate_id'])));
$key = $this->build_key(__CLASS__, $param);
$GLOBALS['cache']->set_dir(APP_ROOT_PATH . "public/runtime/data/" . __CLASS__ . "/");
$ids = $GLOBALS['cache']->get($key);
if ($ids !== false) {
return $ids;
}
$cate_id = $param['cate_id'];
$ids_util = new ChildIds("deal_cate");
$ids = $ids_util->getChildIds($cate_id);
$ids[] = $cate_id;
//开始取出父分类ID
$r_cate_id = $cate_id;
while ($r_cate_id != 0) {
$r_cate_id = $GLOBALS['db']->getOne("select pid from " . DB_PREFIX . "deal_cate where id = " . $r_cate_id);
if ($r_cate_id != 0) {
$ids[] = $r_cate_id;
}
}
$GLOBALS['cache']->set_dir(APP_ROOT_PATH . "public/runtime/data/" . __CLASS__ . "/");
$GLOBALS['cache']->set($key, $ids);
}
return $ids;
}
public function load($param)
{
$key = $this->build_key(__CLASS__, $param);
$GLOBALS['fcache']->set_dir(APP_ROOT_PATH . "public/runtime/data/" . __CLASS__ . "/");
$ids = $GLOBALS['fcache']->get($key);
if ($ids === false) {
$cate_id = intval($param['cate_id']);
$ids_util = new ChildIds("deal_cate");
$ids = $ids_util->getChildIds($cate_id);
$ids[] = $cate_id;
$GLOBALS['fcache']->set_dir(APP_ROOT_PATH . "public/runtime/data/" . __CLASS__ . "/");
$GLOBALS['fcache']->set($key, $ids);
}
return $ids;
}
public function load($param)
{
$param = array();
$key = $this->build_key(__CLASS__, $param);
$GLOBALS['cache']->set_dir(APP_ROOT_PATH . "public/runtime/data/" . __CLASS__ . "/");
$help_list = $GLOBALS['cache']->get($key);
if ($help_list === false) {
$ids_util = new ChildIds("article_cate");
$help_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "article_cate where type_id = 1 and is_delete = 0 and pid=0 order by sort desc limit " . intval(app_conf("HELP_CATE_LIMIT")));
foreach ($help_list as $k => $v) {
$ids = $GLOBALS['cache']->get("CACHE_HELP_ARTICLE_CATE_" . $v['id']);
if ($ids === false) {
$ids = $ids_util->getChildIds($v['id']);
$ids[] = $v['id'];
$GLOBALS['cache']->set("CACHE_HELP_ARTICLE_CATE_" . $v['id'], $ids);
}
$help_cate_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "article where cate_id in (" . implode(",", $ids) . ") and is_delete = 0 order by sort desc limit " . intval(app_conf("HELP_ITEM_LIMIT")));
foreach ($help_cate_list as $kk => $vv) {
if ($vv['rel_url'] != '') {
if (!preg_match("/http:\\/\\//i", $vv['rel_url'])) {
if (substr($vv['rel_url'], 0, 2) == 'u:') {
$help_cate_list[$kk]['url'] = parse_url_tag($vv['rel_url']);
} else {
$help_cate_list[$kk]['url'] = APP_ROOT . "/" . $vv['rel_url'];
}
} else {
$help_cate_list[$kk]['url'] = $vv['rel_url'];
}
$help_cate_list[$kk]['new'] = 1;
} else {
if ($vv['uname'] != '') {
$hurl = url("index", "help#" . $vv['uname']);
} else {
$hurl = url("index", "help#" . $vv['id']);
}
$help_cate_list[$kk]['url'] = $hurl;
}
}
$help_list[$k]['help_list'] = $help_cate_list;
}
$GLOBALS['cache']->set_dir(APP_ROOT_PATH . "public/runtime/data/" . __CLASS__ . "/");
$GLOBALS['cache']->set($key, $help_list);
}
return $help_list;
}
if ($promote_msg['type'] == 1) {
//邮件
$sql = "select u.id,u.email from " . DB_PREFIX . "user as u where u.email <> '' ";
if ($group_id > 0) {
$sql .= " and u.group_id = " . $group_id;
}
$sql .= " and u.id > " . $last_id . " order by u.id asc";
$res = $GLOBALS['db']->getRow($sql);
$dest = $res['email'];
$last_id = $res['id'];
}
break;
case 1:
//订阅
$city_id = intval($promote_msg['send_type_id']);
$ids_util = new ChildIds("deal_city");
$ids = $ids_util->getChildIds($city_id);
$ids[] = $city_id;
$ids_str = implode(",", $ids);
if ($promote_msg['type'] == 0) {
//短信
$sql = "select id,mobile from " . DB_PREFIX . "mobile_list where mobile <> '' and is_effect = 1 ";
if ($city_id > 0) {
$sql .= " and city_id in(" . $ids_str . ") ";
}
$sql .= " and id > " . $last_id . " order by id asc";
$res = $GLOBALS['db']->getRow($sql);
$dest = $res['mobile'];
$last_id = $res['id'];
}
if ($promote_msg['type'] == 1) {
function insert_load_sale_list($para)
{
require_once APP_ROOT_PATH . "app/Lib/shop_init.php";
$cate_id = intval($para['cate_id']);
//输出销售排行
//$sale_list = get_goods_list(intval(app_conf("SALE_LIST")),$cate_id,' buy_type <> 1 and is_shop = 1',' buy_count desc ',false);
//=================
$limit = intval(app_conf("SALE_LIST"));
$where = " buy_type<>1 and is_shop = 1 ";
$orderby = "buy_count desc";
$time = get_gmtime();
$time_condition = ' and (is_shop=1 or shop_cate_id <> 0 ) ';
$sql = "select * from " . DB_PREFIX . "deal where is_effect = 1 and is_delete = 0 " . $time_condition;
if ($cate_id > 0) {
$ids = $GLOBALS['cache']->get("DEAL_SHOP_CATE_BELONE_IDS_" . $cate_id);
if ($ids === false) {
$ids_util = new ChildIds("shop_cate");
$ids = $ids_util->getChildIds($cate_id);
$ids[] = $cate_id;
$GLOBALS['cache']->set("DEAL_SHOP_CATE_BELONE_IDS_" . $cate_id, $ids);
}
$sql .= " and shop_cate_id in (" . implode(",", $ids) . ")";
}
$city_id = intval($GLOBALS['deal_city']['id']);
if ($city_id > 0) {
$ids = $GLOBALS['cache']->get("DEAL_CITY_BELONE_IDS_" . $city_id);
if ($ids === false) {
$ids_util = new ChildIds("deal_city");
$ids = $ids_util->getChildIds($city_id);
$ids[] = $city_id;
//开始取出父地区ID
$r_city_id = $city_id;
while ($r_city_id != 0) {
$r_city_id = $GLOBALS['db']->getOne("select pid from " . DB_PREFIX . "deal_city where id = " . $r_city_id);
if ($r_city_id != 0) {
$ids[] = $r_city_id;
}
}
$GLOBALS['cache']->set("DEAL_CITY_BELONE_IDS_" . $city_id, $ids);
}
$sql .= " and city_id in (" . implode(",", $ids) . ")";
}
if ($where != '') {
$sql .= " and " . $where;
}
if ($orderby == '') {
$sql .= " order by sort desc limit " . $limit;
} else {
$sql .= " order by " . $orderby . " limit " . $limit;
}
$deals = $GLOBALS['db']->getAll($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;
}
}
$sale_list['list'] = $deals;
//==============
$GLOBALS['tmpl']->assign("sale_list", array('title' => $GLOBALS['lang']['SALE_LIST'], 'list' => $sale_list['list'], 'url' => url("shop", 'rec#rsale')));
return $GLOBALS['tmpl']->fetch("inc/insert/load_sale_list.html");
}
