|
|
<?php |
|
|
namespace app\common\model; |
|
|
use think\Db; |
|
|
use think\Cache; |
|
|
|
|
|
class Extend extends Base { |
|
|
|
|
|
|
|
|
public function dataCount() |
|
|
{ |
|
|
$key = $GLOBALS['config']['app']['cache_flag']. '_'.'data_count'; |
|
|
$data = Cache::get($key); |
|
|
if(empty($data)){ |
|
|
$totay = strtotime(date('Y-m-d')); |
|
|
|
|
|
|
|
|
$where = []; |
|
|
$where['vod_status'] = ['eq',1]; |
|
|
$tmp = model('Vod')->field('type_id_1,type_id,count(vod_id) as cc')->where($where)->group('type_id_1,type_id')->select(); |
|
|
foreach($tmp as $k=>$v){ |
|
|
$data['vod_all'] += intval($v['cc']); |
|
|
$list['type_all_'.$v['type_id']] = $v->toArray(); |
|
|
} |
|
|
|
|
|
$where['vod_time'] = ['egt',$totay]; |
|
|
$tmp = model('Vod')->field('type_id_1,type_id,count(vod_id) as cc')->where($where)->group('type_id_1,type_id')->select(); |
|
|
foreach($tmp as $k=>$v){ |
|
|
$data['vod_today'] += intval($v['cc']); |
|
|
$list['type_today_'.$v['type_id']] = $v->toArray(); |
|
|
} |
|
|
$data['vod_min'] = model('Vod')->min('vod_id'); |
|
|
|
|
|
|
|
|
$where = []; |
|
|
$where['art_status'] = ['eq',1]; |
|
|
$tmp = model('Art')->field('type_id_1,type_id,count(art_id) as cc')->where($where)->group('type_id_1,type_id')->select(); |
|
|
foreach($tmp as $k=>$v){ |
|
|
$data['art_all'] += intval($v['cc']); |
|
|
$list['type_all_'.$v['type_id']] = $v->toArray(); |
|
|
} |
|
|
$where['art_time'] = ['egt',$totay]; |
|
|
$tmp = model('Art')->field('type_id_1,type_id,count(art_id) as cc')->where($where)->group('type_id_1,type_id')->select(); |
|
|
foreach($tmp as $k=>$v){ |
|
|
$data['art_today'] += intval($v['cc']); |
|
|
$list['type_today_'.$v['type_id']] = $v->toArray(); |
|
|
} |
|
|
$data['art_min'] = model('Art')->min('art_id'); |
|
|
|
|
|
|
|
|
foreach($list as $k=>$v) { |
|
|
$data[$k]=$v['cc']; |
|
|
|
|
|
if(strpos($k,'type_all')!==false){ |
|
|
$data['type_all_' . $v['type_id_1']] += $v['cc']; |
|
|
} |
|
|
if(strpos($k,'type_today')!==false){ |
|
|
$data['type_today_' . $v['type_id_1']] += $v['cc']; |
|
|
} |
|
|
} |
|
|
|
|
|
|
|
|
$where = []; |
|
|
$where['topic_status'] = ['eq',1]; |
|
|
$tmp = model('Topic')->where($where)->count(); |
|
|
$data['topic_all'] = $tmp; |
|
|
$where['topic_time'] = ['egt',$totay]; |
|
|
$tmp = model('Topic')->where($where)->count(); |
|
|
$data['topic_today'] = $tmp; |
|
|
$data['tpoic_min'] = model('Topic')->min('topic_id'); |
|
|
|
|
|
|
|
|
|
|
|
$where = []; |
|
|
$where['actor_status'] = ['eq',1]; |
|
|
$tmp = model('Actor')->where($where)->count(); |
|
|
$data['actor_all'] = $tmp; |
|
|
$where['actor_time'] = ['egt',$totay]; |
|
|
$tmp = model('Actor')->where($where)->count(); |
|
|
$data['actor_today'] = $tmp; |
|
|
$data['actor_min'] = model('Actor')->min('actor_id'); |
|
|
|
|
|
|
|
|
$where = []; |
|
|
$where['role_status'] = ['eq',1]; |
|
|
$tmp = model('Role')->where($where)->count(); |
|
|
$data['role_all'] = $tmp; |
|
|
$where['role_time'] = ['egt',$totay]; |
|
|
$tmp = model('Role')->where($where)->count(); |
|
|
$data['role_today'] = $tmp; |
|
|
$data['role_min'] = model('Role')->min('role_id'); |
|
|
|
|
|
|
|
|
$where = []; |
|
|
$where['website_status'] = ['eq',1]; |
|
|
$tmp = model('Website')->where($where)->count(); |
|
|
$data['website_all'] = $tmp; |
|
|
$where['website_time'] = ['egt',$totay]; |
|
|
$tmp = model('Website')->where($where)->count(); |
|
|
$data['website_today'] = $tmp; |
|
|
$data['website_min'] = model('Website')->min('website_id'); |
|
|
|
|
|
Cache::set($key,$data,$GLOBALS['config']['app']['cache_time']); |
|
|
} |
|
|
return $data; |
|
|
} |
|
|
|
|
|
public function areaData($lp) |
|
|
{ |
|
|
$order = $lp['order']; |
|
|
$start = intval(abs($lp['start'])); |
|
|
$num = intval(abs($lp['num'])); |
|
|
$tid = intval($lp['tid']); |
|
|
|
|
|
$config = config('maccms.app'); |
|
|
$data_str = $config['vod_extend_area']; |
|
|
if($tid>0){ |
|
|
$type_list = model('Type')->getCache('tree_list'); |
|
|
$type_info = $type_list[$tid]; |
|
|
if(!empty($type_info)){ |
|
|
$type_extend = json_decode($type_info['type_extend'],true); |
|
|
$data_str = $type_extend['area']; |
|
|
} |
|
|
} |
|
|
|
|
|
if(empty($num)){ |
|
|
$num = 20; |
|
|
} |
|
|
if($start>1){ |
|
|
$start--; |
|
|
} |
|
|
|
|
|
$tmp = explode(',',$data_str); |
|
|
if($order=='desc'){ |
|
|
$tmp = array_reverse($tmp); |
|
|
} |
|
|
$list = []; |
|
|
foreach($tmp as $k=>$v){ |
|
|
if($k>=$start && $k<$num){ |
|
|
$list[] = ['area_name' => $v]; |
|
|
} |
|
|
} |
|
|
|
|
|
$list = array_filter($list); |
|
|
$total = count($list); |
|
|
|
|
|
$cach_name = $GLOBALS['config']['app']['cache_flag']. '_' . md5('area_listcache_'.join('&',$lp).'_'.$order.'_'.$num.'_'.$start); |
|
|
|
|
|
return ['code'=>1,'msg'=>lang('data_list'),'page'=>1,'limit'=>$num,'total'=>$total,'list'=>$list]; |
|
|
} |
|
|
|
|
|
public function langData($lp) |
|
|
{ |
|
|
$order = $lp['order']; |
|
|
$start = intval(abs($lp['start'])); |
|
|
$num = intval(abs($lp['num'])); |
|
|
$tid = intval($lp['tid']); |
|
|
|
|
|
$config = config('maccms.app'); |
|
|
$data_str = $config['vod_extend_lang']; |
|
|
if($tid>0){ |
|
|
$type_list = model('Type')->getCache('tree_list'); |
|
|
$type_info = $type_list[$tid]; |
|
|
if(!empty($type_info)){ |
|
|
$type_extend = json_decode($type_info['type_extend'],true); |
|
|
$data_str = $type_extend['lang']; |
|
|
} |
|
|
} |
|
|
|
|
|
if(empty($num)){ |
|
|
$num = 20; |
|
|
} |
|
|
if($start>1){ |
|
|
$start--; |
|
|
} |
|
|
|
|
|
$tmp = explode(',',$data_str); |
|
|
if($order=='desc'){ |
|
|
$tmp = array_reverse($tmp); |
|
|
} |
|
|
$list = []; |
|
|
foreach($tmp as $k=>$v){ |
|
|
if($k>=$start && $k<$num){ |
|
|
$list[] = ['lang_name' => $v]; |
|
|
} |
|
|
} |
|
|
$list = array_filter($list); |
|
|
$total = count($list); |
|
|
|
|
|
$cach_name = $GLOBALS['config']['app']['cache_flag']. '_' . md5('lang_listcache_'.join('&',$lp).'_'.$order.'_'.$num.'_'.$start); |
|
|
|
|
|
return ['code'=>1,'msg'=>lang('data_list'),'page'=>1,'limit'=>$num,'total'=>$total,'list'=>$list]; |
|
|
} |
|
|
|
|
|
public function classData($lp) |
|
|
{ |
|
|
$order = $lp['order']; |
|
|
$start = intval(abs($lp['start'])); |
|
|
$num = intval(abs($lp['num'])); |
|
|
$tid = intval($lp['tid']); |
|
|
|
|
|
$config = config('maccms.app'); |
|
|
$data_str = $config['vod_extend_class']; |
|
|
if($tid>0){ |
|
|
$type_list = model('Type')->getCache('tree_list'); |
|
|
$type_info = $type_list[$tid]; |
|
|
if(!empty($type_info)){ |
|
|
$type_extend = json_decode($type_info['type_extend'],true); |
|
|
$data_str = $type_extend['class']; |
|
|
} |
|
|
} |
|
|
|
|
|
if(empty($num)){ |
|
|
$num = 20; |
|
|
} |
|
|
if($start>1){ |
|
|
$start--; |
|
|
} |
|
|
|
|
|
$tmp = explode(',',$data_str); |
|
|
if($order=='desc'){ |
|
|
$tmp = array_reverse($tmp); |
|
|
} |
|
|
$list = []; |
|
|
foreach($tmp as $k=>$v){ |
|
|
if($k>=$start && $k<$num){ |
|
|
$list[] = ['class_name' => $v]; |
|
|
} |
|
|
} |
|
|
$list = array_filter($list); |
|
|
$total = count($list); |
|
|
|
|
|
$cach_name = $GLOBALS['config']['app']['cache_flag']. '_' . md5('class_listcache_'.join('&',$lp).'_'.$order.'_'.$num.'_'.$start); |
|
|
|
|
|
return ['code'=>1,'msg'=>lang('data_list'),'page'=>1,'limit'=>$num,'total'=>$total,'list'=>$list]; |
|
|
} |
|
|
|
|
|
public function yearData($lp) |
|
|
{ |
|
|
$order = $lp['order']; |
|
|
$start = intval(abs($lp['start'])); |
|
|
$num = intval(abs($lp['num'])); |
|
|
$tid = intval($lp['tid']); |
|
|
|
|
|
$config = config('maccms.app'); |
|
|
$data_str = $config['vod_extend_year']; |
|
|
if($tid>0){ |
|
|
$type_list = model('Type')->getCache('tree_list'); |
|
|
$type_info = $type_list[$tid]; |
|
|
if(!empty($type_info)){ |
|
|
$type_extend = json_decode($type_info['type_extend'],true); |
|
|
$data_str = $type_extend['year']; |
|
|
} |
|
|
} |
|
|
|
|
|
if(empty($num)){ |
|
|
$num = 20; |
|
|
} |
|
|
if($start>1){ |
|
|
$start--; |
|
|
} |
|
|
|
|
|
$tmp = explode(',',$data_str); |
|
|
if($order=='desc'){ |
|
|
$tmp = array_reverse($tmp); |
|
|
} |
|
|
$list = []; |
|
|
foreach($tmp as $k=>$v){ |
|
|
if($k>=$start && $k<$num){ |
|
|
$list[] = ['year_name' => $v]; |
|
|
} |
|
|
} |
|
|
$list = array_filter($list); |
|
|
$total = count($list); |
|
|
|
|
|
$cach_name = $GLOBALS['config']['app']['cache_flag']. '_' . md5('year_listcache_'.join('&',$lp).'_'.$order.'_'.$num.'_'.$start); |
|
|
|
|
|
return ['code'=>1,'msg'=>lang('data_list'),'page'=>1,'limit'=>$num,'total'=>$total,'list'=>$list]; |
|
|
} |
|
|
|
|
|
public function versionData($lp) |
|
|
{ |
|
|
$order = $lp['order']; |
|
|
$start = intval(abs($lp['start'])); |
|
|
$num = intval(abs($lp['num'])); |
|
|
$tid = intval($lp['tid']); |
|
|
|
|
|
$config = config('maccms.app'); |
|
|
$data_str = $config['vod_extend_version']; |
|
|
if($tid>0){ |
|
|
$type_list = model('Type')->getCache('tree_list'); |
|
|
$type_info = $type_list[$tid]; |
|
|
if(!empty($type_info)){ |
|
|
$type_extend = json_decode($type_info['type_extend'],true); |
|
|
$data_str = $type_extend['version']; |
|
|
} |
|
|
} |
|
|
|
|
|
if(empty($num)){ |
|
|
$num = 20; |
|
|
} |
|
|
if($start>1){ |
|
|
$start--; |
|
|
} |
|
|
|
|
|
$tmp = explode(',',$data_str); |
|
|
if($order=='desc'){ |
|
|
$tmp = array_reverse($tmp); |
|
|
} |
|
|
$list = []; |
|
|
foreach($tmp as $k=>$v){ |
|
|
if($k>=$start && $k<$num){ |
|
|
$list[] = ['version_name' => $v]; |
|
|
} |
|
|
} |
|
|
|
|
|
$list = array_filter($list); |
|
|
$total = count($list); |
|
|
|
|
|
$cach_name = $GLOBALS['config']['app']['cache_flag']. '_' . md5('version_listcache_'.join('&',$lp).'_'.$order.'_'.$num.'_'.$start); |
|
|
|
|
|
return ['code'=>1,'msg'=>lang('data_list'),'page'=>1,'limit'=>$num,'total'=>$total,'list'=>$list]; |
|
|
} |
|
|
|
|
|
public function stateData($lp) |
|
|
{ |
|
|
$order = $lp['order']; |
|
|
$start = intval(abs($lp['start'])); |
|
|
$num = intval(abs($lp['num'])); |
|
|
$tid = intval($lp['tid']); |
|
|
|
|
|
$config = config('maccms.app'); |
|
|
$data_str = $config['vod_extend_state']; |
|
|
if($tid>0){ |
|
|
$type_list = model('Type')->getCache('tree_list'); |
|
|
$type_info = $type_list[$tid]; |
|
|
if(!empty($type_info)){ |
|
|
$type_extend = json_decode($type_info['type_extend'],true); |
|
|
$data_str = $type_extend['state']; |
|
|
} |
|
|
} |
|
|
|
|
|
if (!in_array($order, ['asc', 'desc'])) { |
|
|
$order = 'asc'; |
|
|
} |
|
|
|
|
|
if(empty($num)){ |
|
|
$num = 20; |
|
|
} |
|
|
if($start>1){ |
|
|
$start--; |
|
|
} |
|
|
|
|
|
$tmp = explode(',',$data_str); |
|
|
if($order=='desc'){ |
|
|
$tmp = array_reverse($tmp); |
|
|
} |
|
|
$list = []; |
|
|
foreach($tmp as $k=>$v){ |
|
|
if($k>=$start && $k<$num){ |
|
|
$list[] = ['state_name' => $v]; |
|
|
} |
|
|
} |
|
|
$list = array_filter($list); |
|
|
$total = count($list); |
|
|
|
|
|
$cach_name = $GLOBALS['config']['app']['cache_flag']. '_' . md5('state_listcache_'.join('&',$lp).'_'.$order.'_'.$num.'_'.$start); |
|
|
|
|
|
return ['code'=>1,'msg'=>lang('data_list'),'page'=>1,'limit'=>$num,'total'=>$total,'list'=>$list]; |
|
|
} |
|
|
|
|
|
public function letterData($lp) |
|
|
{ |
|
|
$data_str = 'A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,0-9'; |
|
|
$tmp = explode(',',$data_str); |
|
|
|
|
|
$order = $lp['order']; |
|
|
$start = intval(abs($lp['start'])); |
|
|
$num = intval(abs($lp['num'])); |
|
|
$tid = intval($lp['tid']); |
|
|
|
|
|
if (!in_array($order, ['asc', 'desc'])) { |
|
|
$order = 'asc'; |
|
|
} |
|
|
|
|
|
if(empty($num)){ |
|
|
$num = 20; |
|
|
} |
|
|
if($start>1){ |
|
|
$start--; |
|
|
} |
|
|
|
|
|
if($tid>0){ |
|
|
|
|
|
} |
|
|
|
|
|
if($order=='desc'){ |
|
|
$tmp = array_reverse($tmp); |
|
|
} |
|
|
$list = []; |
|
|
foreach($tmp as $k=>$v){ |
|
|
if($k>=$start && $k<$num){ |
|
|
$list[] = ['letter_name' => $v]; |
|
|
} |
|
|
} |
|
|
|
|
|
$list = array_filter($list); |
|
|
$total = count($list); |
|
|
|
|
|
$cach_name = $GLOBALS['config']['app']['cache_flag']. '_' . md5('letter_listcache_'.join('&',$lp).'_'.$order.'_'.$num.'_'.$start); |
|
|
|
|
|
return ['code'=>1,'msg'=>lang('data_list'),'page'=>1,'limit'=>$num,'total'=>$total,'list'=>$list]; |
|
|
} |
|
|
|
|
|
|
|
|
|
|
|
} |
