| | <?php |
| | namespace app\admin\controller; |
| | use think\Cache; |
| | use think\Db; |
| |
|
| | class Vod extends Base |
| | { |
| | public function __construct() |
| | { |
| | parent::__construct(); |
| | } |
| |
|
| | public function data() |
| | { |
| | $param = input(); |
| | $param['page'] = intval($param['page']) <1 ? 1 : $param['page']; |
| | $param['limit'] = intval($param['limit']) <1 ? $this->_pagesize : $param['limit']; |
| |
|
| | $where = []; |
| | if(!empty($param['type'])){ |
| | $where['type_id|type_id_1'] = ['eq',$param['type']]; |
| | } |
| | if(!empty($param['level'])){ |
| | $where['vod_level'] = ['eq',$param['level']]; |
| | } |
| | if(in_array($param['status'],['0','1'])){ |
| | $where['vod_status'] = ['eq',$param['status']]; |
| | } |
| | if(in_array($param['copyright'],['0','1'])){ |
| | $where['vod_copyright'] = ['eq',$param['copyright']]; |
| | } |
| | if(in_array($param['isend'],['0','1'])){ |
| | $where['vod_isend'] = ['eq',$param['isend']]; |
| | } |
| | if(!empty($param['lock'])){ |
| | $where['vod_lock'] = ['eq',$param['lock']]; |
| | } |
| | if(!empty($param['state'])){ |
| | $where['vod_state'] = ['eq',$param['state']]; |
| | } |
| | if(!empty($param['area'])){ |
| | $where['vod_area'] = ['eq',$param['area']]; |
| | } |
| | if(!empty($param['lang'])){ |
| | $where['vod_lang'] = ['eq',$param['lang']]; |
| | } |
| | if(in_array($param['plot'],['0','1'])){ |
| | $where['vod_plot'] = ['eq',$param['plot']]; |
| | } |
| |
|
| | if(!empty($param['url'])){ |
| | if($param['url']==1){ |
| | $where['vod_play_url'] = ''; |
| | } |
| | } |
| | if(!empty($param['points'])){ |
| | $where['vod_points_play|vod_points_down'] = ['gt', 0]; |
| | } |
| | if(!empty($param['pic'])){ |
| | if($param['pic'] == '1'){ |
| | $where['vod_pic'] = ['eq','']; |
| | } |
| | elseif($param['pic'] == '2'){ |
| | $where['vod_pic'] = ['like','http%']; |
| | } |
| | elseif($param['pic'] == '3'){ |
| | $where['vod_pic'] = ['like','%#err%']; |
| | } |
| | } |
| | if(!empty($param['weekday'])){ |
| | $where['vod_weekday'] = ['like','%'.$param['weekday'].'%']; |
| | } |
| | if(!empty($param['wd'])){ |
| | $param['wd'] = urldecode($param['wd']); |
| | $param['wd'] = mac_filter_xss($param['wd']); |
| | $where['vod_name|vod_actor|vod_sub'] = ['like','%'.$param['wd'].'%']; |
| | } |
| | if(!empty($param['player'])){ |
| | if($param['player']=='no'){ |
| | $where['vod_play_from'] = [['eq', ''], ['eq', 'no'], 'or']; |
| | } |
| | else { |
| | $where['vod_play_from'] = ['like', '%' . $param['player'] . '%']; |
| | } |
| | } |
| | if(!empty($param['downer'])){ |
| | if($param['downer']=='no'){ |
| | $where['vod_down_from'] = [['eq', ''], ['eq', 'no'], 'or']; |
| | } |
| | else { |
| | $where['vod_down_from'] = ['like', '%' . $param['downer'] . '%']; |
| | } |
| | } |
| | if(!empty($param['server'])){ |
| | $where['vod_play_server|vod_down_server'] = ['like','%'.$param['server'].'%']; |
| | } |
| | $order='vod_time desc'; |
| | if(in_array($param['order'],['vod_id','vod_hits','vod_hits_month','vod_hits_week','vod_hits_day'])){ |
| | $order = $param['order'] .' desc'; |
| | } |
| |
|
| | if(!empty($param['repeat'])){ |
| | if(!empty($param['cache'])){ |
| | model('Vod')->createRepeatCache(); |
| | return $this->success(lang('update_ok')); |
| | } |
| |
|
| | if($param['page'] ==1){ |
| | |
| | $cacheResult = Cache::get('vod_repeat_table_created_time',0); |
| | |
| | if( $cacheResult == 0 || time() - $cacheResult > 604800){ |
| | model('Vod')->createRepeatCache(); |
| | } |
| | } |
| | $order='vod_name asc'; |
| | $res = model('Vod')->listRepeatData($where,$order,$param['page'],$param['limit']); |
| | } |
| | else{ |
| | $res = model('Vod')->listData($where,$order,$param['page'],$param['limit']); |
| | } |
| |
|
| |
|
| | foreach($res['list'] as $k=>&$v){ |
| | $v['ismake'] = 1; |
| | if($GLOBALS['config']['view']['vod_detail'] >0 && $v['vod_time_make'] < $v['vod_time']){ |
| | $v['ismake'] = 0; |
| | } |
| | } |
| |
|
| | $this->assign('list',$res['list']); |
| | $this->assign('total',$res['total']); |
| | $this->assign('page',$res['page']); |
| | $this->assign('limit',$res['limit']); |
| |
|
| | $param['page'] = '{page}'; |
| | $param['limit'] = '{limit}'; |
| | $this->assign('param',$param); |
| |
|
| | |
| | $type_tree = model('Type')->getCache('type_tree'); |
| | $this->assign('type_tree',$type_tree); |
| |
|
| | |
| | $this->assignBaseListByConfig(); |
| | $this->assign('title',lang('admin/vod/title')); |
| | return $this->fetch('admin@vod/index'); |
| | } |
| |
|
| | public function batch() |
| | { |
| | $param = input(); |
| | if (!empty($param)) { |
| |
|
| | mac_echo('<style type="text/css">body{font-size:12px;color: #333333;line-height:21px;}span{font-weight:bold;color:#FF0000}</style>'); |
| |
|
| | if(empty($param['ck_del']) && empty($param['ck_level']) && empty($param['ck_status']) && empty($param['ck_lock']) && empty($param['ck_hits']) |
| | && empty($param['ck_points']) && empty($param['ck_copyright']) |
| | ){ |
| | return $this->error(lang('param_err')); |
| | } |
| |
|
| |
|
| | if($param['ck_del']==2 && empty($param['player'])){ |
| | return $this->error(lang('admin/vod/del_play_must_select_play')); |
| | } |
| | if($param['ck_del']==3 && empty($param['downer'])){ |
| | return $this->error(lang('admin/vod/del_down_must_select_down')); |
| | } |
| |
|
| | $where = []; |
| | if(!empty($param['type'])){ |
| | $where['type_id'] = ['eq',$param['type']]; |
| | } |
| | if(!empty($param['level'])){ |
| | $where['vod_level'] = ['eq',$param['level']]; |
| | } |
| | if(in_array($param['status'],['0','1'])){ |
| | $where['vod_status'] = ['eq',$param['status']]; |
| | } |
| | if(in_array($param['copyright'],['0','1'])){ |
| | $where['vod_copyright'] = ['eq',$param['copyright']]; |
| | } |
| | if(in_array($param['isend'],['0','1'])){ |
| | $where['vod_isend'] = ['eq',$param['isend']]; |
| | } |
| |
|
| | if(!empty($param['lock'])){ |
| | $where['vod_lock'] = ['eq',$param['lock']]; |
| | } |
| | if(!empty($param['state'])){ |
| | $where['vod_state'] = ['eq',$param['state']]; |
| | } |
| |
|
| | if(!empty($param['area'])){ |
| | $where['vod_area'] = ['eq',$param['area']]; |
| | } |
| | if(!empty($param['lang'])){ |
| | $where['vod_lang'] = ['eq',$param['lang']]; |
| | } |
| |
|
| | if(!empty($param['url'])){ |
| | if($param['url']==1){ |
| | $where['vod_play_url'] = ''; |
| | } |
| | } |
| | if(!empty($param['pic'])){ |
| | if($param['pic'] == '1'){ |
| | $where['vod_pic'] = ['eq','']; |
| | } |
| | elseif($param['pic'] == '2'){ |
| | $where['vod_pic'] = ['like','http%']; |
| | } |
| | elseif($param['pic'] == '3'){ |
| | $where['vod_pic'] = ['like','%#err%']; |
| | } |
| | } |
| | if(!empty($param['wd'])){ |
| | $param['wd'] = htmlspecialchars(urldecode($param['wd'])); |
| | $where['vod_name'] = ['like','%'.$param['wd'].'%']; |
| | } |
| |
|
| | if(!empty($param['weekday'])){ |
| | $where['vod_weekday'] = ['like','%'.$param['weekday'].'%']; |
| | } |
| |
|
| | if(!empty($param['player'])){ |
| | if($param['player']=='no'){ |
| | $where['vod_play_from'] = [['eq', ''], ['eq', 'no'], 'or']; |
| | } |
| | else { |
| | $where['vod_play_from'] = ['like', '%' . $param['player'] . '%']; |
| | } |
| | } |
| | if(!empty($param['downer'])){ |
| | if($param['downer']=='no'){ |
| | $where['vod_down_from'] = [['eq', ''], ['eq', 'no'], 'or']; |
| | } |
| | else { |
| | $where['vod_down_from'] = ['like', '%' . $param['downer'] . '%']; |
| | } |
| | } |
| |
|
| | if($param['ck_del'] == 1){ |
| | $res = model('Vod')->delData($where); |
| | mac_echo(lang('multi_del_ok')); |
| | mac_jump( url('vod/batch') ,3); |
| | exit; |
| | } |
| |
|
| |
|
| | if(empty($param['page'])){ |
| | $param['page'] = 1; |
| | } |
| | if(empty($param['limit'])){ |
| | $param['limit'] = 100; |
| | } |
| | if(empty($param['total'])) { |
| | $param['total'] = model('Vod')->countData($where); |
| | $param['page_count'] = ceil($param['total'] / $param['limit']); |
| | } |
| |
|
| | if($param['page'] > $param['page_count']) { |
| | mac_echo(lang('multi_opt_ok')); |
| | mac_jump( url('vod/batch') ,3); |
| | exit; |
| | } |
| | mac_echo( "<font color=red>".lang('admin/batch_tip',[$param['total'],$param['limit'],$param['page_count'],$param['page']])."</font>"); |
| |
|
| | $page = $param['page_count'] - $param['page'] + 1; |
| | $order='vod_id desc'; |
| | $res = model('Vod')->listData($where,$order,$page,$param['limit']); |
| |
|
| | foreach($res['list'] as $k=>$v){ |
| | $where2 = []; |
| | $where2['vod_id'] = $v['vod_id']; |
| |
|
| | $update = []; |
| | $des = $v['vod_id'].','.$v['vod_name']; |
| |
|
| | if(!empty($param['ck_level']) && !empty($param['val_level'])){ |
| | $update['vod_level'] = $param['val_level']; |
| | $des .= ' '.lang('level').'：'.$param['val_level'].'；'; |
| | } |
| | if(!empty($param['ck_status']) && isset($param['val_status'])){ |
| | $update['vod_status'] = $param['val_status']; |
| | $des .= ' '.lang('status').'：'.($param['val_status'] ==1 ? '['.lang('reviewed').']':'['.lang('reviewed_not').']') .'；'; |
| | } |
| | if(!empty($param['ck_copyright']) && isset($param['val_copyright'])){ |
| | $update['vod_copyright'] = $param['val_copyright']; |
| | $des .= ' '.lang('copyright').'：'.($param['val_copyright'] ==1 ? '['.lang('open').']':'['.lang('close').'') .'；'; |
| | } |
| | if(!empty($param['ck_lock']) && isset($param['val_lock'])){ |
| | $update['vod_lock'] = $param['val_lock']; |
| | $des .= ' '.lang('lock').'：'.($param['val_lock']==1 ? '['.lang('lock').']':'['.lang('unlock').']').'；'; |
| | } |
| | if(!empty($param['ck_hits']) && $param['val_hits_min']!='' && $param['val_hits_max']!='' ){ |
| | $update['vod_hits'] = rand($param['val_hits_min'],$param['val_hits_max']); |
| | $des .= ' '.lang('hits').'：'.$update['vod_hits'].'；'; |
| | } |
| | if(!empty($param['ck_points']) && $param['val_points_play']!='' ){ |
| | $update['vod_points_play'] = $param['val_points_play']; |
| | $des .= ' '.lang('points_play').'：'.$param['val_points_play'].'；'; |
| | } |
| | if(!empty($param['ck_points']) && $param['val_points_down']!='' ){ |
| | $update['vod_points_down'] = $param['val_points_down']; |
| | $des .= ' '.lang('points_down').'：'.$param['val_points_down'].'；'; |
| | } |
| |
|
| | if($param['ck_del'] == 2 || $param['ck_del'] ==3){ |
| | if($param['ck_del']==2) { |
| | $pre = 'vod_play'; |
| | $par = 'player'; |
| | $des .= ' '.lang('play_group').'：'; |
| | } |
| | elseif($param['ck_del']==3){ |
| | $pre = 'vod_down'; |
| | $par='downer'; |
| | $des .= ' '.lang('down_group').'：'; |
| | } |
| |
|
| |
|
| | if($param[$par] == $v[$pre.'_from']){ |
| | $update[$pre.'_from'] = ''; |
| | $update[$pre.'_server'] = ''; |
| | $update[$pre.'_note'] = ''; |
| | $update[$pre.'_url'] = ''; |
| | $des .= lang('del_empty').'；'; |
| | } |
| | else{ |
| | $vod_from_arr = explode('$$$',$v[$pre.'_from']); |
| | $vod_server_arr = explode('$$$',$v[$pre.'_server']); |
| | $vod_note_arr = explode('$$$',$v[$pre.'_note']); |
| | $vod_url_arr = explode('$$$',$v[$pre.'_url']); |
| |
|
| | $key = array_search($param[$par],$vod_from_arr); |
| | if($key!==false){ |
| | unset($vod_from_arr[$key]); |
| | unset($vod_server_arr[$key]); |
| | unset($vod_note_arr[$key]); |
| | unset($vod_url_arr[$key]); |
| |
|
| | $update[$pre.'_from'] = join('$$$',$vod_from_arr); |
| | $update[$pre.'_server'] = join('$$$',$vod_server_arr); |
| | $update[$pre.'_note'] = join('$$$',$vod_note_arr); |
| | $update[$pre.'_url'] = join('$$$',$vod_url_arr); |
| | $des .= lang('del'). '；'; |
| | } |
| | else{ |
| | $des .= lang('jump_over').'；'; |
| | } |
| | } |
| | } |
| |
|
| | mac_echo($des); |
| | $res2 = model('Vod')->where($where2)->update($update); |
| |
|
| | } |
| | $param['page']++; |
| | $url = url('vod/batch') .'?'. http_build_query($param); |
| | mac_jump( $url ,3); |
| | exit; |
| | } |
| |
|
| | |
| | $type_tree = model('Type')->getCache('type_tree'); |
| | $this->assign('type_tree',$type_tree); |
| |
|
| | |
| | $this->assignBaseListByConfig(); |
| | $this->assign('title',lang('admin/vod/title')); |
| | return $this->fetch('admin@vod/batch'); |
| | } |
| |
|
| | public function info() |
| | { |
| | if (Request()->isPost()) { |
| | $param = input('post.'); |
| | $res = model('Vod')->saveData($param); |
| | if($res['code']>1){ |
| | return $this->error($res['msg']); |
| | } |
| | return $this->success($res['msg']); |
| | } |
| |
|
| | $id = input('id'); |
| | $where=[]; |
| | $where['vod_id'] = $id; |
| | $res = model('Vod')->infoData($where); |
| |
|
| |
|
| | $info = $res['info']; |
| | $this->assign('info',$info); |
| |
|
| | |
| | $type_tree = model('Type')->getCache('type_tree'); |
| | $this->assign('type_tree',$type_tree); |
| |
|
| | |
| | $config = config('maccms.app'); |
| | $area_list = explode(',',$config['vod_area']); |
| | $lang_list = explode(',',$config['vod_lang']); |
| | $this->assign('area_list',$area_list); |
| | $this->assign('lang_list',$lang_list); |
| |
|
| | |
| | $group_list = model('Group')->getCache('group_list'); |
| | $this->assign('group_list',$group_list); |
| |
|
| | |
| | $this->assignBaseListByConfig(); |
| |
|
| | |
| | $this->assign('vod_play_list',(array)$info['vod_play_list']); |
| | $this->assign('vod_down_list',(array)$info['vod_down_list']); |
| | $this->assign('vod_plot_list',(array)$info['vod_plot_list']); |
| |
|
| |
|
| | $this->assign('title',lang('admin/vod/title')); |
| | return $this->fetch('admin@vod/info'); |
| | } |
| |
|
| | public function iplot() |
| | { |
| | if (Request()->isPost()) { |
| | $param = input('post.'); |
| | $res = model('Vod')->savePlot($param); |
| | if($res['code']>1){ |
| | return $this->error($res['msg']); |
| | } |
| | return $this->success($res['msg']); |
| | } |
| |
|
| | $id = input('id'); |
| | $where=[]; |
| | $where['vod_id'] = $id; |
| | $res = model('Vod')->infoData($where); |
| |
|
| |
|
| | $info = $res['info']; |
| | $this->assign('info',$info); |
| | $this->assign('vod_plot_list',$info['vod_plot_list']); |
| |
|
| |
|
| | $this->assign('title',lang('admin/vod/plot/title')); |
| | return $this->fetch('admin@vod/iplot'); |
| | } |
| |
|
| | public function del() |
| | { |
| | $param = input(); |
| | $ids = $param['ids']; |
| |
|
| | if(!empty($ids)){ |
| | $where=[]; |
| | $where['vod_id'] = ['in',$ids]; |
| | $res = model('Vod')->delData($where); |
| | if($res['code']>1){ |
| | return $this->error($res['msg']); |
| | } |
| | Cache::rm('vod_repeat_table_created_time'); |
| | return $this->success($res['msg']); |
| | } |
| | elseif(!empty($param['repeat'])){ |
| | if($param['retain']=='max') { |
| | |
| | $sql = 'DELETE FROM '.config('database.prefix').'vod WHERE vod_id IN ( |
| | SELECT * FROM ( |
| | SELECT v1.vod_id |
| | FROM '.config('database.prefix').'vod v1 |
| | INNER JOIN '.config('database.prefix').'vod v2 |
| | ON v1.vod_name = v2.vod_name AND v1.vod_id < v2.vod_id |
| | ) tmp |
| | )'; |
| | } else { |
| | |
| | $sql = 'DELETE FROM '.config('database.prefix').'vod WHERE vod_id IN ( |
| | SELECT * FROM ( |
| | SELECT v1.vod_id |
| | FROM '.config('database.prefix').'vod v1 |
| | INNER JOIN '.config('database.prefix').'vod v2 |
| | ON v1.vod_name = v2.vod_name AND v1.vod_id > v2.vod_id |
| | ) tmp |
| | )'; |
| | } |
| |
|
| | $res = model('Vod')->execute($sql); |
| | if($res===false){ |
| | return $this->success(lang('del_err')); |
| | } |
| | Cache::rm('vod_repeat_table_created_time'); |
| | return $this->success(lang('del_ok')); |
| | } |
| | return $this->error(lang('param_err')); |
| | } |
| |
|
| | public function field() |
| | { |
| | $param = input(); |
| | $ids = $param['ids']; |
| | $col = $param['col']; |
| | $val = $param['val']; |
| | $start = $param['start']; |
| | $end = $param['end']; |
| |
|
| | if ($col == 'type_id' && $val==''){ |
| | return $this->error("请选择分类提交"); |
| | } |
| |
|
| | if(!empty($ids) && in_array($col,['vod_status','vod_lock','vod_level','vod_hits','type_id','vod_copyright'])){ |
| | $where=[]; |
| | $where['vod_id'] = ['in',$ids]; |
| | $update = []; |
| | if(empty($start)) { |
| | $update[$col] = $val; |
| | if($col == 'type_id'){ |
| | $type_list = model('Type')->getCache(); |
| | $id1 = intval($type_list[$val]['type_pid']); |
| | $update['type_id_1'] = $id1; |
| | } |
| | $res = model('Vod')->fieldData($where, $update); |
| | } |
| | else{ |
| | if(empty($end)){$end = 9999;} |
| | $ids = explode(',',$ids); |
| | foreach($ids as $k=>$v){ |
| | $val = rand($start,$end); |
| | $where['vod_id'] = ['eq',$v]; |
| | $update[$col] = $val; |
| | $res = model('Vod')->fieldData($where, $update); |
| | } |
| | } |
| | if($res['code']>1){ |
| | return $this->error($res['msg']); |
| | } |
| | return $this->success($res['msg']); |
| | } |
| | return $this->error(lang('param_err')); |
| | } |
| |
|
| | public function updateToday() |
| | { |
| | $param = input(); |
| | $flag = $param['flag']; |
| | $res = model('Vod')->updateToday($flag); |
| | return json($res); |
| | } |
| |
|
| | private function assignBaseListByConfig() { |
| | $player_list = config('vodplayer'); |
| | $downer_list = config('voddowner'); |
| | $server_list = config('vodserver'); |
| | $player_list = mac_multisort($player_list,'sort',SORT_DESC,'status','1'); |
| | $downer_list = mac_multisort($downer_list,'sort',SORT_DESC,'status','1'); |
| | $server_list = mac_multisort($server_list,'sort',SORT_DESC,'status','1'); |
| | $this->assign('player_list',$player_list); |
| | $this->assign('downer_list',$downer_list); |
| | $this->assign('server_list',$server_list); |
| | } |
| | } |
| |
|
