| | <?php |
| | namespace app\common\model; |
| | use think\Db; |
| | use think\Cache; |
| | use app\common\util\Pinyin; |
| |
|
| | class Topic extends Base { |
| | |
| | protected $name = 'topic'; |
| |
|
| | |
| | protected $createTime = ''; |
| | protected $updateTime = ''; |
| | protected $autoWriteTimestamp = true; |
| |
|
| | |
| | protected $auto = []; |
| | protected $insert = []; |
| | protected $update = []; |
| |
|
| | public function getTopicStatusTextAttr($val,$data) |
| | { |
| | $arr = [0=>lang('disable'),1=>lang('enable')]; |
| | return $arr[$data['topic_status']]; |
| | } |
| |
|
| | public function countData($where) |
| | { |
| | $total = $this->where($where)->count(); |
| | return $total; |
| | } |
| |
|
| | public function listData($where,$order,$page=1,$limit=20,$start=0,$field='*',$totalshow=1) |
| | { |
| | $page = $page > 0 ? (int)$page : 1; |
| | $limit = $limit ? (int)$limit : 20; |
| | $start = $start ? (int)$start : 0; |
| | if(!is_array($where)){ |
| | $where = json_decode($where,true); |
| | } |
| | $limit_str = ($limit * ($page-1) + $start) .",".$limit; |
| | if($totalshow==1) { |
| | $total = $this->where($where)->count(); |
| | } |
| | $tmp = Db::name('Topic')->where($where)->order($order)->limit($limit_str)->select(); |
| |
|
| | $list = []; |
| | foreach($tmp as $k=>$v){ |
| | $list[$v['topic_id']] = $v; |
| | } |
| |
|
| | return ['code'=>1,'msg'=>lang('data_list'),'page'=>$page,'pagecount'=>ceil($total/$limit),'limit'=>$limit,'total'=>$total,'list'=>$list]; |
| | } |
| |
|
| |
|
| | public function listCacheData($lp) |
| | { |
| | if (!is_array($lp)) { |
| | $lp = json_decode($lp, true); |
| | } |
| |
|
| | $order = $lp['order']; |
| | $by = $lp['by']; |
| | $ids = $lp['ids']; |
| | $paging = $lp['paging']; |
| | $pageurl = $lp['pageurl']; |
| | $level = $lp['level']; |
| | $letter = $lp['letter']; |
| | $tag = $lp['tag']; |
| | $class = $lp['class']; |
| | $start = intval(abs($lp['start'])); |
| | $num = intval(abs($lp['num'])); |
| | $half = intval(abs($lp['half'])); |
| | $timeadd = $lp['timeadd']; |
| | $timehits = $lp['timehits']; |
| | $time = $lp['time']; |
| | $hitsmonth = $lp['hitsmonth']; |
| | $hitsweek = $lp['hitsweek']; |
| | $hitsday = $lp['hitsday']; |
| | $hits = $lp['hits']; |
| | $not = $lp['not']; |
| | $cachetime = $lp['cachetime']; |
| |
|
| | $page = 1; |
| | $where = []; |
| | $totalshow = 0; |
| |
|
| | if(empty($num)){ |
| | $num = 20; |
| | } |
| | if($start>1){ |
| | $start--; |
| | } |
| |
|
| | if(!in_array($paging, ['yes', 'no'])) { |
| | $paging = 'no'; |
| | } |
| | $param = mac_param_url(); |
| | if($paging=='yes') { |
| | $param = mac_search_len_check($param); |
| | $totalshow = 1; |
| | if (!empty($param['id'])) { |
| | $ids = intval($param['id']); |
| | } |
| | if(!empty($param['ids'])){ |
| | $ids = $param['ids']; |
| | } |
| | if(!empty($param['level'])) { |
| | if($param['level']=='all'){ |
| | $level = '1,2,3,4,5,6,7,8,9'; |
| | } |
| | else{ |
| | $level = $param['level']; |
| | } |
| | } |
| | if(!empty($param['letter'])) { |
| | $letter = $param['letter']; |
| | } |
| | if(!empty($param['wd'])) { |
| | $wd = $param['wd']; |
| | } |
| | if(!empty($param['tag'])) { |
| | $tag = $param['tag']; |
| | } |
| | if(!empty($param['class'])) { |
| | $class = $param['class']; |
| | } |
| | if(!empty($param['by'])){ |
| | $by = $param['by']; |
| | } |
| | if(!empty($param['order'])){ |
| | $order = $param['order']; |
| | } |
| | if(!empty($param['page'])){ |
| | $page = intval($param['page']); |
| | } |
| | foreach($param as $k=>$v){ |
| | if(empty($v)){ |
| | unset($param[$k]); |
| | } |
| | } |
| | if(empty($pageurl)){ |
| | $pageurl = 'topic/index'; |
| | } |
| | $param['page'] = 'PAGELINK'; |
| | $pageurl = mac_url($pageurl,$param); |
| |
|
| | } |
| |
|
| | $where['topic_status'] = ['eq',1]; |
| | if(!empty($level)) { |
| | $where['topic_level'] = ['in',explode(',',$level)]; |
| | } |
| | if(!empty($ids)) { |
| | if($ids!='all'){ |
| | $where['topic_id'] = ['in',explode(',',$ids)]; |
| | } |
| | } |
| | if(!empty($not)){ |
| | $where['topic_id'] = ['not in',explode(',',$not)]; |
| | } |
| | if(!empty($letter)){ |
| | if(substr($letter,0,1)=='0' && substr($letter,2,1)=='9'){ |
| | $letter='0,1,2,3,4,5,6,7,8,9'; |
| | } |
| | $where['topic_letter'] = ['in',explode(',',$letter)]; |
| | } |
| | if(!empty($timeadd)){ |
| | $s = intval(strtotime($timeadd)); |
| | $where['topic_time_add'] =['gt',$s]; |
| | } |
| | if(!empty($timehits)){ |
| | $s = intval(strtotime($timehits)); |
| | $where['topic_time_hits'] =['gt',$s]; |
| | } |
| | if(!empty($time)){ |
| | $s = intval(strtotime($time)); |
| | $where['topic_time'] =['gt',$s]; |
| | } |
| | if(!empty($hitsmonth)){ |
| | $tmp = explode(' ',$hitsmonth); |
| | if(count($tmp)==1){ |
| | $where['topic_hits_month'] = ['gt', $tmp]; |
| | } |
| | else{ |
| | $where['topic_hits_month'] = [$tmp[0],$tmp[1]]; |
| | } |
| | } |
| | if(!empty($hitsweek)){ |
| | $tmp = explode(' ',$hitsweek); |
| | if(count($tmp)==1){ |
| | $where['topic_hits_week'] = ['gt', $tmp]; |
| | } |
| | else{ |
| | $where['topic_hits_week'] = [$tmp[0],$tmp[1]]; |
| | } |
| | } |
| | if(!empty($hitsday)){ |
| | $tmp = explode(' ',$hitsday); |
| | if(count($tmp)==1){ |
| | $where['topic_hits_day'] = ['gt', $tmp]; |
| | } |
| | else{ |
| | $where['topic_hits_day'] = [$tmp[0],$tmp[1]]; |
| | } |
| | } |
| | if(!empty($hits)){ |
| | $tmp = explode(' ',$hits); |
| | if(count($tmp)==1){ |
| | $where['topic_hits'] = ['gt', $tmp]; |
| | } |
| | else{ |
| | $where['topic_hits'] = [$tmp[0],$tmp[1]]; |
| | } |
| | } |
| |
|
| | if(!empty($wd)) { |
| | $where['topic_name|topic_en|topic_sub'] = ['like', '%' . $wd . '%']; |
| | } |
| | if(!empty($tag)) { |
| | $where['topic_tag'] = ['like', mac_like_arr($tag),'OR']; |
| | } |
| | if(!empty($class)) { |
| | $where['topic_type'] = ['like', mac_like_arr($class),'OR']; |
| | } |
| | if($by=='rnd'){ |
| | $data_count = $this->countData($where); |
| | $page_total = floor($data_count / $lp['num']) + 1; |
| | if($data_count < $lp['num']){ |
| | $lp['num'] = $data_count; |
| | } |
| | $randi = @mt_rand(1, $page_total); |
| | $page = $randi; |
| | $by = 'hits_week'; |
| | $order = 'desc'; |
| | } |
| |
|
| | if(!in_array($by, ['id', 'time','time_add','score','hits','hits_day','hits_week','hits_month','up','down','level','rnd'])) { |
| | $by = 'time'; |
| | } |
| | if(!in_array($order, ['asc', 'desc'])) { |
| | $order = 'desc'; |
| | } |
| | $order= 'topic_'.$by .' ' . $order; |
| | $where_cache = $where; |
| | if(!empty($randi)){ |
| | unset($where_cache['topic_id']); |
| | $where_cache['order'] = 'rnd'; |
| | } |
| |
|
| | $cach_name = $GLOBALS['config']['app']['cache_flag']. '_' .md5('topic_listcache_'.http_build_query($where_cache).'_'.$order.'_'.$page.'_'.$num.'_'.$start.'_'.$pageurl); |
| | $res = Cache::get($cach_name); |
| | if(empty($cachetime)){ |
| | $cachetime = $GLOBALS['config']['app']['cache_time']; |
| | } |
| | if($GLOBALS['config']['app']['cache_core']==0 || empty($res)) { |
| | $res = $this->listData($where,$order,$page,$num,$start,'*',$totalshow); |
| | if($GLOBALS['config']['app']['cache_core']==1) { |
| | Cache::set($cach_name, $res, $cachetime); |
| | } |
| | } |
| | $res['pageurl'] = $pageurl; |
| | $res['half'] = $half; |
| | return $res; |
| | } |
| |
|
| | public function infoData($where,$field='*',$cache=0) |
| | { |
| | if(empty($where) || !is_array($where)){ |
| | return ['code'=>1001,'msg'=>lang('param_err')]; |
| | } |
| | $data_cache = false; |
| | $key = $GLOBALS['config']['app']['cache_flag']. '_'.'topic_detail_'.$where['topic_id'][1].'_'.$where['topic_en'][1]; |
| | if($where['topic_id'][0]=='eq' || $where['topic_en'][0]=='eq'){ |
| | $data_cache = true; |
| | } |
| | if($GLOBALS['config']['app']['cache_core']==1 && $data_cache) { |
| | $info = Cache::get($key); |
| | } |
| | if($GLOBALS['config']['app']['cache_core']==0 || $cache==0 || empty($info['topic_id']) ) { |
| | $info = $this->field($field)->where($where)->find(); |
| | if (empty($info)) { |
| | return ['code' => 1002, 'msg' => lang('obtain_err')]; |
| | } |
| | $info = $info->toArray(); |
| | if (!empty($info['topic_extend'])) { |
| | $info['topic_extend'] = json_decode($info['topic_extend'], true); |
| | } else { |
| | $info['topic_extend'] = json_decode('{"type":"","area":"","lang":"","year":"","star":"","director":"","state":"","version":""}', true); |
| | } |
| | $info['vod_list'] = []; |
| | $info['art_list'] = []; |
| |
|
| | if (!empty($info['topic_rel_vod'])) { |
| | $where = []; |
| | $where['vod_id'] = ['in', $info['topic_rel_vod']]; |
| | $where['vod_status'] = ['eq', 1]; |
| | $order = 'vod_time desc'; |
| | $field = '*'; |
| | $res = model('Vod')->listData($where, $order, 1, 999, 0, $field); |
| | if ($res['code'] == 1) { |
| | $info['vod_list'] = $res['list']; |
| | } |
| | } |
| | if (!empty($info['topic_rel_art'])) { |
| | $where = []; |
| | $where['art_id'] = ['in', $info['topic_rel_art']]; |
| | $where['art_status'] = ['eq', 1]; |
| | $order = 'art_time desc'; |
| | $field = '*'; |
| | $res = model('Art')->listData($where, $order, 1, 999, 0, $field); |
| | if ($res['code'] == 1) { |
| | $info['art_list'] = $res['list']; |
| | } |
| | } |
| |
|
| | if (!empty($info['topic_tag'])) { |
| | $where=[]; |
| | $where['vod_tag'] = ['like', mac_like_arr($info['topic_tag']),'OR']; |
| | $where['vod_status'] = ['eq', 1]; |
| | $order = 'vod_time desc'; |
| | $field = '*'; |
| | $res = model('Vod')->listData($where, $order, 1, 999, 0, $field); |
| | if ($res['code'] == 1) { |
| | $info['vod_list'] = array_merge($info['vod_list'],$res['list']); |
| | } |
| |
|
| | $where=[]; |
| | $where['art_tag'] = ['like', mac_like_arr($info['topic_tag']),'OR']; |
| | $where['art_status'] = ['eq', 1]; |
| | $order = 'art_time desc'; |
| | $field = '*'; |
| | $res = model('Art')->listData($where, $order, 1, 999, 0, $field); |
| | if ($res['code'] == 1) { |
| | $info['art_list'] = array_merge($info['art_list'],$res['list']); |
| | } |
| | } |
| | if($GLOBALS['config']['app']['cache_core']==1 && $data_cache && $cache==1) { |
| | Cache::set($key, $info); |
| | } |
| | } |
| | return ['code'=>1,'msg'=>lang('obtain_ok'),'info'=>$info]; |
| | } |
| |
|
| | public function saveData($data) |
| | { |
| | $validate = \think\Loader::validate('Topic'); |
| | if(!$validate->check($data)){ |
| | return ['code'=>1001,'msg'=>lang('param_err').'：'.$validate->getError() ]; |
| | } |
| | $key = 'topic_detail_'.$data['topic_id']; |
| | Cache::rm($key); |
| | $key = 'topic_detail_'.$data['topic_en']; |
| | Cache::rm($key); |
| | $key = 'topic_detail_'.$data['topic_id'].'_'.$data['topic_en']; |
| | Cache::rm($key); |
| |
|
| |
|
| | if(empty($data['topic_extend'])){ |
| | $data['topic_extend'] = ''; |
| | } |
| | if(empty($data['topic_en'])){ |
| | $data['topic_en'] = Pinyin::get($data['topic_name']); |
| | } |
| |
|
| | if(!empty($data['topic_content'])) { |
| | $pattern_src = '/<img[\s\S]*?src\s*=\s*[\"|\'](.*?)[\"|\'][\s\S]*?>/'; |
| | @preg_match_all($pattern_src, $data['topic_content'], $match_src1); |
| | if (!empty($match_src1)) { |
| | foreach ($match_src1[1] as $v1) { |
| | $v2 = str_replace($GLOBALS['config']['upload']['protocol'] . ':', 'mac:', $v1); |
| | $data['topic_content'] = str_replace($v1, $v2, $data['topic_content']); |
| | } |
| | } |
| | unset($match_src1); |
| | } |
| |
|
| | if(empty($data['topic_blurb'])){ |
| | $data['topic_blurb'] = mac_substring( strip_tags($data['topic_content']) ,100); |
| | } |
| |
|
| | if($data['uptime']==1){ |
| | $data['topic_time'] = time(); |
| | } |
| | unset($data['uptime']); |
| |
|
| | |
| | $filter_fields = [ |
| | 'topic_name', |
| | 'topic_en', |
| | 'topic_sub', |
| | 'topic_color', |
| | 'topic_tpl', |
| | 'topic_type', |
| | 'topic_pic', |
| | 'topic_pic_thumb', |
| | 'topic_pic_slide', |
| | 'topic_key', |
| | 'topic_des', |
| | 'topic_title', |
| | 'topic_blurb', |
| | 'topic_remarks', |
| | 'topic_tag', |
| | 'topic_rel_vod', |
| | 'topic_rel_art', |
| | 'topic_content', |
| | 'topic_extend', |
| | ]; |
| | foreach ($filter_fields as $filter_field) { |
| | if (!isset($data[$filter_field])) { |
| | continue; |
| | } |
| | $data[$filter_field] = mac_filter_xss($data[$filter_field]); |
| | } |
| |
|
| | if(!empty($data['topic_id'])){ |
| | $where=[]; |
| | $where['topic_id'] = ['eq',$data['topic_id']]; |
| | $res = $this->allowField(true)->where($where)->update($data); |
| | } |
| | else{ |
| | $data['topic_time_add'] = time(); |
| | $data['topic_time'] = time(); |
| | $res = $this->allowField(true)->insert($data); |
| | } |
| | if(false === $res){ |
| | return ['code'=>1002,'msg'=>lang('save_err').'：'.$this->getError() ]; |
| | } |
| | return ['code'=>1,'msg'=>lang('save_ok')]; |
| | } |
| |
|
| | public function delData($where) |
| | { |
| | $list = $this->listData($where,'',1,9999); |
| | if($list['code'] !==1){ |
| | return ['code'=>1001,'msg'=>lang('del_err').'：'.$this->getError() ]; |
| | } |
| | $path = './'; |
| | foreach($list['list'] as $k=>$v){ |
| | $pic = $path.$v['topic_pic']; |
| | if(file_exists($pic) && (substr($pic,0,8) == "./upload") || count( explode("./",$pic) ) ==1){ |
| | unlink($pic); |
| | } |
| | $pic = $path.$v['topic_pic_thumb']; |
| | if(file_exists($pic) && (substr($pic,0,8) == "./upload") || count( explode("./",$pic) ) ==1){ |
| | unlink($pic); |
| | } |
| | $pic = $path.$v['topic_pic_slide']; |
| | if(file_exists($pic) && (substr($pic,0,8) == "./upload") || count( explode("./",$pic) ) ==1){ |
| | unlink($pic); |
| | } |
| | if($GLOBALS['config']['view']['topic_detail'] ==2 ){ |
| | $lnk = mac_url_topic_detail($v); |
| | $lnk = reset_html_filename($lnk); |
| | if(file_exists($lnk)){ |
| | unlink($lnk); |
| | } |
| | } |
| | } |
| | $res = $this->where($where)->delete(); |
| | if($res===false){ |
| | return ['code'=>1001,'msg'=>lang('del_err').'：'.$this->getError() ]; |
| | } |
| | return ['code'=>1,'msg'=>lang('del_ok')]; |
| | } |
| |
|
| | public function fieldData($where,$col,$val) |
| | { |
| | if(!isset($col) || !isset($val)){ |
| | return ['code'=>1001,'msg'=>lang('param_err')]; |
| | } |
| |
|
| | $data = []; |
| | $data[$col] = $val; |
| | $res = $this->allowField(true)->where($where)->update($data); |
| | if($res===false){ |
| | return ['code'=>1002,'msg'=>lang('set_err').'：'.$this->getError() ]; |
| | } |
| |
|
| | $list = $this->field('topic_id,topic_name,topic_en')->where($where)->select(); |
| | foreach($list as $k=>$v){ |
| | $key = 'topic_detail_'.$v['topic_id']; |
| | Cache::rm($key); |
| | $key = 'topic_detail_'.$v['topic_en']; |
| | Cache::rm($key); |
| | } |
| |
|
| | return ['code'=>1,'msg'=>lang('set_ok')]; |
| | } |
| |
|
| |
|
| |
|
| | } |
