| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736 |
- <?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(in_array($param['role'],['0','1'])){
- $roleVodIds = Db::name('role')->where('role_rid', '>', 0)->group('role_rid')->column('role_rid');
- if($param['role'] == '1'){
- // 有角色数据
- if(!empty($roleVodIds)){
- $where['vod_id'] = ['in', $roleVodIds];
- } else {
- // 如果没有任何角色数据,设置一个不可能匹配的条件
- $where['vod_id'] = ['eq', 0];
- }
- } else {
- // 无角色数据
- if(!empty($roleVodIds)){
- $where['vod_id'] = ['not in', $roleVodIds];
- }
- }
- }
- 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'].'%'];
- }
- if (!empty($param['recycle'])) {
- $where['vod_recycle_time'] = ['>', 0];
- }
- $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);
- //缓存时间超过7天和没有创建过缓存都会重建缓存
- 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']);
- }
- // 批量查询哪些视频有角色数据
- $vodIds = array_column($res['list'], 'vod_id');
- $vodIdsWithRole = [];
- $vodSeoStatusMap = [];
- if (!empty($vodIds)) {
- $roleData = Db::name('role')
- ->where('role_rid', 'in', $vodIds)
- ->where('role_rid', '>', 0)
- ->group('role_rid')
- ->column('role_rid');
- $vodIdsWithRole = array_flip($roleData); // 转为键值对,方便快速查找
- $seoRows = Db::name('seo_ai_result')
- ->field('seo_obj_id,seo_status')
- ->where('seo_mid', 1)
- ->where('seo_obj_id', 'in', $vodIds)
- ->where('seo_status', 'in', [1, 2])
- ->select();
- foreach ((array)$seoRows as $seoRow) {
- $vodSeoStatusMap[intval($seoRow['seo_obj_id'])] = intval($seoRow['seo_status']);
- }
- }
- 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;
- }
- // 标记是否有角色数据
- $v['vod_role'] = isset($vodIdsWithRole[$v['vod_id']]) ? 1 : 0;
- $v['seo_ai_status'] = isset($vodSeoStatusMap[$v['vod_id']]) ? intval($vodSeoStatusMap[$v['vod_id']]) : 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);
- $queryString = '?' . http_build_query($param);
- $this->assign('query_string',$queryString);
- //分类
- $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']) && empty($param['ck_type']) && empty($param['ck_tag']) && empty($param['ck_play'])
- && empty($param['ck_replace'])
- ){
- 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 = $this->vodBatchFilterWhere($param);
- if($param['ck_del'] == 1){
- $res = model('Vod')->recycleData($where);
- mac_echo($res['code'] == 1 ? lang('recycle_ok') : $res['msg']);
- mac_jump( url('vod/batch') ,3);
- exit;
- }
- if($param['ck_del'] == 4){
- $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(!empty($param['ck_type']) && !empty($param['val_type'])){
- $update['type_id'] = intval($param['val_type']);
- $type_list = model('Type')->getCache();
- if(isset($type_list[$update['type_id']])){
- $id1 = intval($type_list[$update['type_id']]['type_pid']);
- $update['type_id_1'] = $id1;
- }
- $des .= ' '.lang('type').':'.$update['type_id'].';';
- }
- // 新增:批量修改标签
- if(!empty($param['ck_tag']) && !empty($param['val_tag'])){
- $update['vod_tag'] = mac_filter_xss($param['val_tag']);
- $des .= ' '.lang('tag').':'.$update['vod_tag'].';';
- }
- // 新增:批量修改播放源
- if(!empty($param['ck_play']) && !empty($param['val_play'])){
- $update['vod_play_from'] = $param['val_play'];
- $des .= ' '.lang('play_group').':'.$param['val_play'].';';
- }
- // 新增:批量替换功能
- if(!empty($param['ck_replace']) && !empty($param['replace_field']) && isset($param['replace_search'])){
- $field = $param['replace_field'];
- $replaceres = $this->batch_replace($field,$v,$param['replace_search'],$param['replace_with'],'vod');
- if(isset($replaceres[$field])) $update[$field] = $replaceres[$field];
- if(!empty($replaceres['des'])) $des .= $replaceres['des'];
- }
- 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');
- }
- /**
- * 与批量操作页筛选条件一致(用于导出)
- */
- private function vodBatchFilterWhere(&$param)
- {
- $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 (in_array($param['plot'] ?? '', ['0', '1'])) {
- $where['vod_plot'] = ['eq', $param['plot']];
- }
- if (in_array($param['role'] ?? '', ['0', '1'])) {
- $roleVodIds = Db::name('role')->where('role_rid', '>', 0)->group('role_rid')->column('role_rid');
- if ($param['role'] == '1') {
- if (!empty($roleVodIds)) {
- $where['vod_id'] = ['in', $roleVodIds];
- } else {
- $where['vod_id'] = ['eq', 0];
- }
- } else {
- if (!empty($roleVodIds)) {
- $where['vod_id'] = ['not in', $roleVodIds];
- }
- }
- }
- 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['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 (!empty($param['server'])) {
- $where['vod_play_server|vod_down_server'] = ['like', '%' . $param['server'] . '%'];
- }
- if (!empty($param['recycle'])) {
- $where['vod_recycle_time'] = ['>', 0];
- }
- return $where;
- }
- public function exportData()
- {
- $param = input();
- $where = $this->vodBatchFilterWhere($param);
- $this->base_export($param,'vod',$where);
- }
- public function importData()
- {
- $this->base_import('vod');
- }
- 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;
- $where['_recycle'] = 'all';
- $res = model('Vod')->infoData($where);
- $info = $res['info'];
- $this->assign('info',$info);
- $seoAiStatus = 0;
- if (!empty($info['vod_id'])) {
- $seoAi = model('SeoAiResult')->getByObject(1, intval($info['vod_id']));
- if (!empty($seoAi)) {
- $seoAiStatus = intval($seoAi['seo_status']);
- }
- }
- $this->assign('seo_ai_status', $seoAiStatus);
- //分类
- $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 aiSeoGenerate()
- {
- if (!Request()->isPost()) {
- return json(['code' => 0, 'msg' => lang('illegal_request'), 'data' => []]);
- }
- $id = intval(input('post.id'));
- if ($id <= 0) {
- return json(['code' => 0, 'msg' => lang('param_err'), 'data' => []]);
- }
- try {
- $res = \app\common\util\SeoAi::generateByMidObj(1, $id);
- } catch (\Exception $e) {
- \think\Log::error('AI SEO generate failed (vod_id=' . $id . '): ' . $e->getMessage());
- return json(['code' => 0, 'msg' => $e->getMessage(), 'data' => []]);
- }
- if (empty($res['code']) || intval($res['code']) !== 1) {
- return json(['code' => 0, 'msg' => isset($res['msg']) ? $res['msg'] : lang('save_err'), 'data' => []]);
- }
- return json(['code' => 1, 'msg' => lang('save_ok'), 'data' => isset($res['data']) ? $res['data'] : []]);
- }
- 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;
- $where['_recycle'] = 'all';
- $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 restore()
- {
- $param = input();
- $ids = $param['ids'];
- if (empty($ids)) {
- return $this->error(lang('param_err'));
- }
- $where = ['vod_id' => ['in', $ids]];
- $res = model('Vod')->restoreData($where);
- if ($res['code'] > 1) {
- return $this->error($res['msg']);
- }
- Cache::rm('vod_repeat_table_created_time');
- return $this->success($res['msg']);
- }
- public function del()
- {
- $param = input();
- $ids = $param['ids'];
- $purge = !empty($param['purge']);
- if(!empty($ids)){
- $where=[];
- $where['vod_id'] = ['in',$ids];
- if ($purge) {
- $res = model('Vod')->delData($where);
- } else {
- $res = model('Vod')->recycleData($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') {
- // 保留最大ID - 先用子查询找出要保留的ID
- $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 {
- // 保留最小ID - 先用子查询找出要保留的ID
- $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);
- }
- }
|