| | <?php |
| | namespace app\admin\controller; |
| | use think\Db; |
| | use app\common\util\Pinyin; |
| |
|
| | class Art 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['art_level'] = ['eq', $param['level']]; |
| | } |
| | if (in_array($param['status'], ['0', '1'])) { |
| | $where['art_status'] = ['eq', $param['status']]; |
| | } |
| | if (!empty($param['lock'])) { |
| | $where['art_lock'] = ['eq', $param['lock']]; |
| | } |
| | if(!empty($param['pic'])){ |
| | if($param['pic'] == '1'){ |
| | $where['art_pic'] = ['eq','']; |
| | } |
| | elseif($param['pic'] == '2'){ |
| | $where['art_pic'] = ['like','http%']; |
| | } |
| | elseif($param['pic'] == '3'){ |
| | $where['art_pic'] = ['like','%#err%']; |
| | } |
| | } |
| | if(!empty($param['wd'])){ |
| | $param['wd'] = urldecode($param['wd']); |
| | $param['wd'] = mac_filter_xss($param['wd']); |
| | $where['art_name'] = ['like','%'.$param['wd'].'%']; |
| | } |
| |
|
| | if(!empty($param['repeat'])){ |
| | if($param['page'] ==1){ |
| | Db::execute('DROP TABLE IF EXISTS '.config('database.prefix').'tmpart'); |
| | Db::execute('CREATE TABLE `'.config('database.prefix').'tmpart` (`id1` int unsigned DEFAULT NULL, `name1` varchar(1024) NOT NULL DEFAULT \'\') ENGINE=MyISAM'); |
| | Db::execute('INSERT INTO `'.config('database.prefix').'tmpart` (SELECT min(art_id)as id1,art_name as name1 FROM '.config('database.prefix').'art GROUP BY name1 HAVING COUNT(name1)>1)'); |
| | } |
| | $order='art_name asc'; |
| | $res = model('Art')->listRepeatData($where,$order,$param['page'],$param['limit']); |
| | } |
| | else{ |
| | $order='art_time desc'; |
| | $res = model('Art')->listData($where,$order,$param['page'],$param['limit']); |
| | } |
| |
|
| | foreach($res['list'] as $k=>&$v){ |
| | $v['ismake'] = 1; |
| | if($GLOBALS['config']['view']['art_detail'] >0 && $v['art_time_make'] < $v['art_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->assign('title', lang('admin/art/title')); |
| | return $this->fetch('admin@art/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']) ){ |
| | return $this->error(lang('param_err')); |
| | } |
| | $where = []; |
| | if(!empty($param['type'])){ |
| | $where['type_id'] = ['eq',$param['type']]; |
| | } |
| | if(!empty($param['level'])){ |
| | $where['art_level'] = ['eq',$param['level']]; |
| | } |
| | if(in_array($param['status'],['0','1'])){ |
| | $where['art_status'] = ['eq',$param['status']]; |
| | } |
| | if(!empty($param['lock'])){ |
| | $where['art_lock'] = ['eq',$param['lock']]; |
| | } |
| | if(!empty($param['pic'])){ |
| | if($param['pic'] == '1'){ |
| | $where['art_pic'] = ['eq','']; |
| | } |
| | elseif($param['pic'] == '2'){ |
| | $where['art_pic'] = ['like','http%']; |
| | } |
| | elseif($param['pic'] == '3'){ |
| | $where['art_pic'] = ['like','%#err%']; |
| | } |
| | } |
| | if(!empty($param['wd'])){ |
| | $param['wd'] = htmlspecialchars(urldecode($param['wd'])); |
| | $where['art_name'] = ['like','%'.$param['wd'].'%']; |
| | } |
| |
|
| |
|
| | if($param['ck_del'] == 1){ |
| | $res = model('Art')->delData($where); |
| | mac_echo(lang('multi_del_ok')); |
| | mac_jump( url('art/batch') ,3); |
| | exit; |
| | } |
| |
|
| | if(empty($param['page'])){ |
| | $param['page'] = 1; |
| | } |
| | if(empty($param['limit'])){ |
| | $param['limit'] = 100; |
| | } |
| | if(empty($param['total'])) { |
| | $param['total'] = model('Art')->countData($where); |
| | $param['page_count'] = ceil($param['total'] / $param['limit']); |
| | } |
| |
|
| | if($param['page'] > $param['page_count']) { |
| | mac_echo(lang('multi_set_ok')); |
| | mac_jump( url('art/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='art_id desc'; |
| | $res = model('Art')->listData($where,$order,$page,$param['limit']); |
| |
|
| | foreach($res['list'] as $k=>$v){ |
| | $where2 = []; |
| | $where2['art_id'] = $v['art_id']; |
| |
|
| | $update = []; |
| | $des = $v['art_id'].','.$v['art_name']; |
| |
|
| | if(!empty($param['ck_level']) && !empty($param['val_level'])){ |
| | $update['art_level'] = $param['val_level']; |
| | $des .= ' '.lang('level').'：'.$param['val_level'].'；'; |
| | } |
| | if(!empty($param['ck_status']) && isset($param['val_status'])){ |
| | $update['art_status'] = $param['val_status']; |
| | $des .= ' '.lang('status').'：'.($param['val_status'] ==1 ? '['.lang('reviewed').']':'['.lang('reviewed_not').']') .'；'; |
| | } |
| | if(!empty($param['ck_lock']) && isset($param['val_lock'])){ |
| | $update['art_lock'] = $param['val_lock']; |
| | $des .= ' '.lang('lock').'：'.($param['val_lock']==1 ? '['.lang('lock').']':'['.lang('unlock').']').'；'; |
| | } |
| | if(!empty($param['ck_hits']) && !empty($param['val_hits_min']) && !empty($param['val_hits_max']) ){ |
| | $update['art_hits'] = rand($param['val_hits_min'],$param['val_hits_max']); |
| | $des .= ' '.lang('hits').'：'.$update['art_hits'].'；'; |
| | } |
| | mac_echo($des); |
| | $res2 = model('Art')->where($where2)->update($update); |
| |
|
| | } |
| | $param['page']++; |
| | $url = url('art/batch') .'?'. http_build_query($param); |
| | mac_jump( $url ,3); |
| | exit; |
| | } |
| |
|
| | $type_tree = model('Type')->getCache('type_tree'); |
| | $this->assign('type_tree',$type_tree); |
| |
|
| | $this->assign('title',lang('admin/art/title')); |
| | return $this->fetch('admin@art/batch'); |
| | } |
| |
|
| | public function info() |
| | { |
| | if (Request()->isPost()) { |
| | $param = input('post.'); |
| | $res = model('Art')->saveData($param); |
| | if($res['code']>1){ |
| | return $this->error($res['msg']); |
| | } |
| | return $this->success($res['msg']); |
| | } |
| |
|
| | $id = input('id'); |
| | $where=[]; |
| | $where['art_id'] = ['eq',$id]; |
| | $res = model('Art')->infoData($where); |
| |
|
| | $info = $res['info']; |
| | $this->assign('info',$info); |
| | $this->assign('art_page_list',(array)$info['art_page_list']); |
| |
|
| | $type_tree = model('Type')->getCache('type_tree'); |
| | $this->assign('type_tree',$type_tree); |
| |
|
| | $this->assign('title',lang('admin/art/title')); |
| | return $this->fetch('admin@art/info'); |
| | } |
| |
|
| | public function del() |
| | { |
| | $param = input(); |
| | $ids = $param['ids']; |
| |
|
| | if(!empty($ids)){ |
| | $where=[]; |
| | $where['art_id'] = ['in',$ids]; |
| | $res = model('Art')->delData($where); |
| | if($res['code']>1){ |
| | return $this->error($res['msg']); |
| | } |
| | return $this->success($res['msg']); |
| | } |
| | elseif(!empty($param['repeat'])){ |
| | $st = ' not in '; |
| | if($param['retain']=='max'){ |
| | $st=' in '; |
| | } |
| | $sql = 'delete from '.config('database.prefix').'art where art_name in(select name1 from '.config('database.prefix').'tmpart) and art_id '.$st.'(select id1 from '.config('database.prefix').'tmpart)'; |
| | $res = model('Art')->execute($sql); |
| | if($res===false){ |
| | return $this->success(lang('del_err')); |
| | } |
| | 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,['art_status','art_lock','art_level','art_hits','type_id'])){ |
| | $where=[]; |
| | $where['art_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('Art')->fieldData($where, $update); |
| | } |
| | else{ |
| | if(empty($end)){$end = 9999;} |
| | $ids = explode(',',$ids); |
| | foreach($ids as $k=>$v){ |
| | $val = rand($start,$end); |
| | $where['art_id'] = ['eq',$v]; |
| | $update[$col] = $val; |
| | $res = model('Art')->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('Art')->updateToday($flag); |
| | return json($res); |
| | } |
| |
|
| | } |
| |
|
