public function update($cachename)
{
global $_G;
$sys = true;
//$syn = false,代表不写入缓存,每次都读取
if (strpos($cachename, '_cate') !== false) {
$tmp = explode('_', $cachename);
$cate = new cate($tmp[0], $tmp[0]);
$cache_data = $cate->get_cate();
$this->set($cachename, $cache_data, true, 1);
return $cache_data;
}
switch ($cachename) {
case 'all_channel':
$all_channel = DB::fetch_all("SELECT * FROM " . DB::table('channel') . " ORDER BY `sort` DESC,fid ASC ", 'fid');
$tmp = array();
foreach ($all_channel as $k => $v) {
$v[org_url] = $v[url];
$v[url] = '/index.php?fid=' . $v[fid];
$tmp['k' . $k] = $v;
}
$cache_data = $tmp;
break;
case 'channels':
$all_channel = DB::fetch_all("SELECT * FROM " . DB::table('channel') . " ORDER BY `sort` DESC,fid ASC ", 'fid');
$channel = array();
//一级
foreach ($all_channel as $k => $v) {
if ($v[fup] == 0) {
//$v[count] = getcount('goods'," AND fid = ".$v[fid]);
$v[org_url] = $v[url];
$v[url] = '/index.php?fid=' . $v[fid];
$channel[$k] = $v;
}
}
//二级
$tmps = $all_channel;
foreach ($channel as $k => $v) {
$sub = array();
$fid_in = array();
unset($tmps[$v[fid]]);
foreach ($all_channel as $kk => $vv) {
if ($vv['fup'] == $k) {
//$vv[count] = getcount('goods'," AND fid = ".$vv[fid]);
$vv[org_url] = $vv[url];
$vv[url] = '/index.php?fid=' . $vv[fid];
$sub[$kk] = $vv;
//二级栏目
$fid_in2 = array();
unset($tmps[$vv[fid]]);
foreach ($all_channel as $k3 => $v3) {
if ($v3['fup'] == $kk) {
$v3[org_url] = $v3[url];
$v3[url] = '/index.php?fid=' . $v3[fid];
//$v3[count] = getcount('goods'," AND fid = ".$v3[fid]);
unset($tmps[$v3[fid]]);
$sub[$kk]['sub'][$k3] = $v3;
//三级栏目
$fid_in2[] = $v3['fid'];
$fid_in[] = $v3['fid'];
$sub[$kk]['sub'][$k3]['fid_in'] = $v3['fid'];
}
}
$fid_in[] = $vv['fid'];
$fid_in2[] = $vv['fid'];
$sub[$kk]['fid_in'] = implode(',', $fid_in2);
}
}
$fid_in[] = $v['fid'];
$channel[$k]['fid_in'] = implode(',', $fid_in);
if ($sub) {
$channel[$k]['sub'] = $sub;
}
}
if (count($tmps) > 0) {
foreach ($tmps as $k => $v) {
if (!array_key_exists($k)) {
$v[fid_in] = $v[fid];
$channel[$k] = $v;
}
}
}
$cache_data = $channel;
break;
case 'setting':
set_setting('time', TIMESTAMP);
$st = DB::fetch_all("SELECT * FROM " . DB::table('setting'));
foreach ($st as $k => $v) {
$setting[$v['name']] = $v['value'];
}
if ($setting['qq']) {
$setting['qq'] = explode(',', $setting['qq']);
}
if ($setting['flag']) {
$setting['flag'] = explode(',', $setting['flag']);
$setting['flag'] = array_filter($setting['flag']);
}
if ($setting['shop_tag']) {
$setting['shop_tag'] = explode(',', $setting['shop_tag']);
$setting['shop_tag'] = array_filter($setting['shop_tag']);
}
if ($setting['goods_tag']) {
$setting['goods_tag'] = explode(',', $setting['goods_tag']);
$setting['goods_tag'] = array_filter($setting['goods_tag']);
}
if ($setting['article_tag']) {
$setting['article_tag'] = explode(',', $setting['article_tag']);
$setting['article_tag'] = array_filter($setting['article_tag']);
}
if ($setting['filter_field']) {
$setting['filter_field'] = explode(',', $setting['filter_field']);
}
if ($setting['shiyong_status']) {
$setting['shiyong_status'] = explode(',', $setting['shiyong_status']);
}
if ($setting['duihuan_status']) {
$setting['duihuan_status'] = explode(',', $setting['duihuan_status']);
}
if ($setting['shiyong_tags']) {
$setting['shiyong_tags'] = explode(',', $setting['shiyong_tags']);
}
if ($setting['activity_tags']) {
$setting['activity_tags'] = explode(',', $setting['activity_tags']);
}
if ($setting['style_tags']) {
$setting['style_tags'] = explode(',', $setting['style_tags']);
}
if ($setting['movie_tags']) {
$setting['movie_tags'] = explode(',', $setting['movie_tags']);
}
if ($setting['zj_tags']) {
$setting['zj_tags'] = explode(',', $setting['zj_tags']);
}
if ($setting['shishang_flag']) {
$setting['shishang_flag'] = explode(',', $setting['shishang_flag']);
}
if ($setting['tags']) {
$setting['tags'] = explode(',', $setting['tags']);
$tags = array();
foreach ($setting['tags'] as $k => $v) {
$uname = urlencode_utf8($v);
$tags[$uname] = $v;
}
$setting['tags'] = $tags;
}
if ($setting['sign_jf']) {
$setting['sign_jf'] = (array) dunserialize($setting['sign_jf']);
}
if ($setting['sign_tb']) {
$setting['sign_tb'] = (array) dunserialize($setting['sign_tb']);
}
if ($setting['syn_table']) {
$setting['syn_table'] = explode(',', $setting['syn_table']);
}
if ($setting['syn_domain']) {
$setting['syn_domain'] = explode("\r\n", $setting['syn_domain']);
}
if ($setting['uz_tag']) {
$setting['uz_tag'] = explode(',', $setting['uz_tag']);
}
if ($setting['uz_type']) {
$setting['uz_type'] = explode(',', $setting['uz_type']);
}
$setting['time'] = TIMESTAMP;
if ($setting['email']) {
$setting['email'] = (array) dunserialize($setting['email']);
}
$cache_data = $setting;
break;
case 'friend_link':
//友情链接
$friend_link = DB::fetch_all("SELECT * FROM " . DB::table('friend_link') . " ORDER BY sort DESC,id DESC", 'id');
foreach ($friend_link as $k => $v) {
$friend_link[$k]['dateline'] = dgmdate($v['dateline'], 'u');
}
$cache_data = $friend_link;
break;
case 'pics_type':
$cache_data = DB::fetch_all("SELECT * FROM " . DB::table('pics_type') . " ORDER BY id DESC", 'id');
break;
case 'pics':
$pics_type = DB::fetch_all("SELECT * FROM " . DB::table('pics_type') . " ORDER BY id DESC", 'id');
$pics_tmp = DB::fetch_all("SELECT * FROM " . DB::table('pics') . " ORDER BY sort ASC,id DESC ", 'id');
$pics = array();
foreach ($pics_type as $k => $v) {
$pics[$k] = array();
foreach ($pics_tmp as $k1 => $v1) {
$v1['org_dateline'] = $v1['dateline'];
$v1['dateline'] = dgmdate($v1['dateline'], 'u');
if ($v1['fup'] == $k) {
$pics[$k][$k1] = $v1;
}
}
}
$cache_data = set_key($pics);
break;
case 'ad':
$ad = DB::fetch_all("SELECT * FROM " . DB::table('ad') . " ORDER BY id DESC ", 'id');
foreach ($ad as $k => $v) {
$ad[$k]['org_dateline'] = $v[dateline];
$ad[$k]['dateline'] = dgmdate($v[dateline], 'u');
$ad[$k]['start_time'] = dgmdate($v[start_time], 'dt');
$ad[$k]['end_time'] = dgmdate($v[end_time], 'dt');
$ad[$k]['show'] = false;
$ad[$k]['show_html'] = '';
//先判断是否在显示时间内
$show = 0;
if ($v['start_time'] < TIMESTAMP && ($v['end_time'] == 0 || $v['end_time'] > TIMESTAMP)) {
$show = 1;
}
if ($show == true && $v['hide'] == 0) {
$html = '';
if ($v['type'] == 1) {
$html = $v['content'];
} elseif ($v['type'] == 2) {
$width = $v['width'] > 0 ? "width='" . $v['width'] . "'" : '';
$height = $v['height'] > 0 ? "height='" . $v['height'] . "'" : '';
$img = "<img class='ads_" . $k . "' src='" . $v['picurl'] . "' " . $width . "" . $height . " />";
if ($v['url']) {
$target = $v['target'] == 1 ? "target='_blank'" : '';
$html = "<a href='" . $v['url'] . "' " . $target . " >" . $img . "</a>";
} else {
$html = $img;
}
} else {
$html = $v['html'];
}
if (!empty($html)) {
$ad[$k]['show'] = true;
$ad[$k]['show_html'] = $html;
} else {
$ad[$k]['show_html'] = '';
}
}
}
$cache_data = set_key($ad);
break;
case 'goods_cate':
$cate = new cate('goods', 'goods');
$cache_data = $cate->get_cate();
break;
case 'shop':
$shop = DB::fetch_all("SELECT * FROM " . DB::table('shop') . " ORDER BY sort DESC,id DESC", 'id');
foreach ($shop as $k => $v) {
$shop[$k] = parse('shop', $v);
}
$cache_data = $shop;
break;
case 'shop_cate':
$cate = new cate('shop', 'shop');
$cache_data = $cate->get_cate();
break;
case 'prize':
$rs = DB::fetch_all("SELECT * FROM " . DB::table('prize') . " ORDER BY sort DESC ,id DESC ", 'id');
foreach ($rs as $k => $v) {
//统计每个分类,还未中奖的中奖码..
$rs[$k][num] = $rs[$k][count] = getcount('ticket', "prizeid = " . $v[id] . " AND is_use=0");
$rs[$k][total] = getcount('ticket', "prizeid = " . $v[id]);
}
$cache_data = $rs;
break;
case 'table':
$cache_data = update_table();
break;
case 'group':
$rs = DB::fetch_all("SELECT * FROM " . DB::table('group') . " ORDER BY id ASC", 'id');
foreach ($rs as $k => $v) {
$rs[$k][power] = dunserialize($v['power']);
}
$cache_data = $rs;
break;
case 'rank':
$rs = DB::fetch_all("SELECT * FROM " . DB::table('rank') . " ORDER BY id ASC", 'id');
$cache_data = $rs;
break;
default:
$sys = false;
$cache_data = '';
break;
}
if ($sys == true) {
$this->set($cachename, $cache_data, true, 1);
}
return $cache_data;
}
function cate_del()
{
$cate = new cate(__CLASS__);
$cate->del();
}
function cate_del()
{
require_once libfile('class/cate');
$cate = new cate(__CLASS__, __CLASS__);
$cate->del();
}
public function cate($id)
{
if (Request::ajax()) {
$limit = Request::get('limit');
$data = Request::get('data');
$sort = Request::get('sort');
$list = Request::get('list');
$model = book::where('cate_id', $id)->where('publishing_date', '<', date('y-m-d'))->orderBy('publishing_date', 'DESC');
$model = HomeController::sort($model, $sort)->paginate($limit);
return view('front.partials.list_book_item_info_page', ['data' => $model, 'list' => $list]);
}
$bestsellers = book::where('publishing_date', '<', date('y-m-d'))->orderBy('qty_saled', 'DESC')->paginate(5);
$cate_name = cate::where('id', $id)->first()->name;
return view('front.xemthem', ['data' => $bestsellers, 'name' => $cate_name]);
}
