| | <?php |
| | namespace app\common\model; |
| | use think\Db; |
| | use think\Cache; |
| | use app\common\util\Pinyin; |
| |
|
| | class Actor extends Base { |
| | |
| | protected $name = 'actor'; |
| |
|
| | |
| | protected $createTime = ''; |
| | protected $updateTime = ''; |
| |
|
| | |
| | protected $auto = []; |
| | protected $insert = []; |
| | protected $update = []; |
| |
|
| | public function getActorStatusTextAttr($val,$data) |
| | { |
| | $arr = [0=>lang('disable'),1=>lang('enable')]; |
| | return $arr[$data['actor_status']]; |
| | } |
| |
|
| | public function countData($where) |
| | { |
| | $total = $this->where($where)->count(); |
| | return $total; |
| | } |
| |
|
| | public function listData($where,$order,$page=1,$limit=20,$start=0,$field='*',$addition=1,$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); |
| | } |
| | $where2=''; |
| | if(!empty($where['_string'])){ |
| | $where2 = $where['_string']; |
| | unset($where['_string']); |
| | } |
| |
|
| | $limit_str = ($limit * ($page-1) + $start) .",".$limit; |
| | if($totalshow==1) { |
| | $total = $this->where($where)->count(); |
| | } |
| | $list = Db::name('Actor')->field($field)->where($where)->where($where2)->orderRaw($order)->limit($limit_str)->select(); |
| | |
| | $type_list = model('Type')->getCache('type_list'); |
| |
|
| | foreach($list as $k=>$v){ |
| | if($addition==1){ |
| | if(!empty($v['type_id'])) { |
| | $list[$k]['type'] = $type_list[$v['type_id']]; |
| | $list[$k]['type_1'] = $type_list[$list[$k]['type']['type_pid']]; |
| | } |
| | } |
| | } |
| | 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']; |
| | $type = $lp['type']; |
| | $ids = $lp['ids']; |
| | $paging = $lp['paging']; |
| | $pageurl = $lp['pageurl']; |
| | $level = $lp['level']; |
| | $wd = $lp['wd']; |
| | $name = $lp['name']; |
| | $area = $lp['area']; |
| | $letter = $lp['letter']; |
| | $sex = $lp['sex']; |
| | $starsign = $lp['starsign']; |
| | $blood = $lp['blood']; |
| | $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']; |
| | $typenot = $lp['typenot']; |
| | $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'])) { |
| | |
| | } |
| | 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['sex'])){ |
| | $sex = $param['sex']; |
| | } |
| | if(!empty($param['area'])) { |
| | $area = $param['area']; |
| | } |
| | if(!empty($param['starsign'])){ |
| | $starsign = $param['starsign']; |
| | } |
| | if(!empty($param['blood'])){ |
| | $blood = $param['blood']; |
| | } |
| |
|
| | if(!empty($param['wd'])) { |
| | $wd = $param['wd']; |
| | } |
| | 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 = 'actor/type'; |
| | } |
| | $param['page'] = 'PAGELINK'; |
| | if($pageurl=='actor/type' || $pageurl=='actor/show'){ |
| | $type = intval( $GLOBALS['type_id'] ); |
| | $type_list = model('Type')->getCache('type_list'); |
| | $type_info = $type_list[$type]; |
| | $flag='type'; |
| | if($pageurl == 'actor/show'){ |
| | $flag='show'; |
| | } |
| | $pageurl = mac_url_type($type_info,$param,$flag); |
| | } |
| | else{ |
| | $pageurl = mac_url($pageurl,$param); |
| | } |
| |
|
| | } |
| |
|
| | $where['actor_status'] = ['eq',1]; |
| | if(!empty($level)) { |
| | if($level=='all'){ |
| | $level = '1,2,3,4,5,6,7,8,9'; |
| | } |
| | $where['actor_level'] = ['in',explode(',',$level)]; |
| | } |
| | if(!empty($ids)) { |
| | if($ids!='all'){ |
| | $where['actor_id'] = ['in',explode(',',$ids)]; |
| | } |
| | } |
| | if(!empty($not)){ |
| | $where['actor_id'] = ['not in',explode(',',$not)]; |
| | } |
| | if(!empty($sex)){ |
| | $where['actor_sex'] = ['eq',$sex]; |
| | } |
| | 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['actor_letter'] = ['in',explode(',',$letter)]; |
| | } |
| |
|
| | if(!empty($timeadd)){ |
| | $s = intval(strtotime($timeadd)); |
| | $where['actor_time_add'] =['gt',$s]; |
| | } |
| | if(!empty($timehits)){ |
| | $s = intval(strtotime($timehits)); |
| | $where['actor_time_hits'] =['gt',$s]; |
| | } |
| | if(!empty($time)){ |
| | $s = intval(strtotime($time)); |
| | $where['actor_time'] =['gt',$s]; |
| | } |
| | if(!empty($type)) { |
| | if($type=='current'){ |
| | $type = intval( $GLOBALS['type_id'] ); |
| | } |
| | if($type!='all') { |
| | $tmp_arr = explode(',', $type); |
| | $type_list = model('Type')->getCache('type_list'); |
| | $type = []; |
| | foreach ($type_list as $k2 => $v2) { |
| | if (in_array($v2['type_id'] . '', $tmp_arr) || in_array($v2['type_pid'] . '', $tmp_arr)) { |
| | $type[] = $v2['type_id']; |
| | } |
| | } |
| | $type = array_unique($type); |
| | $where['type_id'] = ['in', implode(',', $type)]; |
| | } |
| | } |
| | if(!empty($typenot)){ |
| | $where['type_id'] = ['not in',$typenot]; |
| | } |
| | if(!empty($tid)) { |
| | $where['type_id|type_id_1'] = ['eq',$tid]; |
| | } |
| | if(!empty($hitsmonth)){ |
| | $tmp = explode(' ',$hitsmonth); |
| | if(count($tmp)==1){ |
| | $where['actor_hits_month'] = ['gt', $tmp]; |
| | } |
| | else{ |
| | $where['actor_hits_month'] = [$tmp[0],$tmp[1]]; |
| | } |
| | } |
| | if(!empty($hitsweek)){ |
| | $tmp = explode(' ',$hitsweek); |
| | if(count($tmp)==1){ |
| | $where['actor_hits_week'] = ['gt', $tmp]; |
| | } |
| | else{ |
| | $where['actor_hits_week'] = [$tmp[0],$tmp[1]]; |
| | } |
| | } |
| | if(!empty($hitsday)){ |
| | $tmp = explode(' ',$hitsday); |
| | if(count($tmp)==1){ |
| | $where['actor_hits_day'] = ['gt', $tmp]; |
| | } |
| | else{ |
| | $where['actor_hits_day'] = [$tmp[0],$tmp[1]]; |
| | } |
| | } |
| | if(!empty($hits)){ |
| | $tmp = explode(' ',$hits); |
| | if(count($tmp)==1){ |
| | $where['actor_hits'] = ['gt', $tmp]; |
| | } |
| | else{ |
| | $where['actor_hits'] = [$tmp[0],$tmp[1]]; |
| | } |
| | } |
| |
|
| | if(!empty($area)){ |
| | $where['actor_area'] = ['in',explode(',',$area) ]; |
| | } |
| | if(!empty($starsign)){ |
| | $where['actor_starsign'] = ['in',explode(',',$starsign) ]; |
| | } |
| | if(!empty($blood)){ |
| | $where['actor_blood'] = ['in',explode(',',$blood) ]; |
| | } |
| |
|
| | if(!empty($name)){ |
| | $where['actor_name'] = ['in',explode(',',$name) ]; |
| | } |
| | if(!empty($wd)) { |
| | $where['actor_name|actor_en'] = ['like', '%' . $wd . '%']; |
| | } |
| | 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','in'])) { |
| | $by = 'time'; |
| | } |
| | if(!in_array($order, ['asc', 'desc'])) { |
| | $order = 'desc'; |
| | } |
| |
|
| | $where_cache = $where; |
| | if(!empty($randi)){ |
| | unset($where_cache['actor_id']); |
| | $where_cache['order'] = 'rnd'; |
| | } |
| |
|
| |
|
| | if($by=='in' && !empty($name) ){ |
| | $order = ' find_in_set(actor_name, \''.$name.'\' ) '; |
| | } |
| | else{ |
| | if($by=='in' && empty($name) ){ |
| | $by = 'time'; |
| | } |
| | $order= 'actor_'.$by .' ' . $order; |
| | } |
| |
|
| | $cach_name = $GLOBALS['config']['app']['cache_flag']. '_' .md5('actor_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,'*',1,$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']. '_'. 'actor_detail_'.$where['actor_id'][1].'_'.$where['actor_en'][1]; |
| | if($where['actor_id'][0]=='eq' || $where['actor_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['actor_id'])) { |
| | $info = $this->field($field)->where($where)->find(); |
| | if (empty($info)) { |
| | return ['code' => 1002, 'msg' => lang('obtain_err')]; |
| | } |
| | $info = $info->toArray(); |
| | |
| | if (!empty($info['type_id'])) { |
| | $type_list = model('Type')->getCache('type_list'); |
| | $info['type'] = $type_list[$info['type_id']]; |
| | $info['type_1'] = $type_list[$info['type']['type_pid']]; |
| | } |
| | 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('Actor'); |
| | if(!$validate->check($data)){ |
| | return ['code'=>1001,'msg'=>lang('param_err').'：'.$validate->getError() ]; |
| | } |
| |
|
| | $key = 'actor_detail_'.$data['actor_id']; |
| | Cache::rm($key); |
| | $key = 'actor_detail_'.$data['actor_en']; |
| | Cache::rm($key); |
| | $key = 'actor_detail_'.$data['actor_id'].'_'.$data['actor_en']; |
| | Cache::rm($key); |
| |
|
| | $type_list = model('Type')->getCache('type_list'); |
| | $type_info = $type_list[$data['type_id']]; |
| | $data['type_id_1'] = $type_info['type_pid']; |
| |
|
| | if(empty($data['actor_en'])){ |
| | $data['actor_en'] = Pinyin::get($data['actor_name']); |
| | } |
| |
|
| | if(empty($data['actor_letter'])){ |
| | $data['actor_letter'] = strtoupper(substr($data['actor_en'],0,1)); |
| | } |
| |
|
| | if(!empty($data['actor_content'])) { |
| | $pattern_src = '/<img[\s\S]*?src\s*=\s*[\"|\'](.*?)[\"|\'][\s\S]*?>/'; |
| | @preg_match_all($pattern_src, $data['actor_content'], $match_src1); |
| | if (!empty($match_src1)) { |
| | foreach ($match_src1[1] as $v1) { |
| | $v2 = str_replace($GLOBALS['config']['upload']['protocol'] . ':', 'mac:', $v1); |
| | $data['actor_content'] = str_replace($v1, $v2, $data['actor_content']); |
| | } |
| | } |
| | unset($match_src1); |
| | } |
| |
|
| | if(empty($data['actor_blurb'])){ |
| | $data['actor_blurb'] = mac_substring( strip_tags($data['actor_content']) ,100); |
| | } |
| |
|
| | if($data['uptag']==1){ |
| | $data['actor_tag'] = mac_get_tag($data['actor_name'], $data['actor_content']); |
| | } |
| | if($data['uptime']==1){ |
| | $data['actor_time'] = time(); |
| | } |
| | unset($data['uptime']); |
| | unset($data['uptag']); |
| |
|
| | |
| | $filter_fields = [ |
| | 'actor_name', |
| | 'actor_en', |
| | 'actor_alias', |
| | 'actor_color', |
| | 'actor_pic', |
| | 'actor_blurb', |
| | 'actor_remarks', |
| | 'actor_area', |
| | 'actor_height', |
| | 'actor_weight', |
| | 'actor_birthday', |
| | 'actor_birtharea', |
| | 'actor_blood', |
| | 'actor_starsign', |
| | 'actor_school', |
| | 'actor_works', |
| | 'actor_tag', |
| | 'actor_class', |
| | 'actor_tpl', |
| | 'actor_jumpurl', |
| | ]; |
| | foreach ($filter_fields as $filter_field) { |
| | if (!isset($data[$filter_field])) { |
| | continue; |
| | } |
| | $data[$filter_field] = mac_filter_xss($data[$filter_field]); |
| | } |
| |
|
| | if(!empty($data['actor_id'])){ |
| | $where=[]; |
| | $where['actor_id'] = ['eq',$data['actor_id']]; |
| | $res = $this->allowField(true)->where($where)->update($data); |
| | } |
| | else{ |
| | $data['actor_time_add'] = time(); |
| | $data['actor_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['actor_pic']; |
| | if(file_exists($pic) && (substr($pic,0,8) == "./upload") || count( explode("./",$pic) ) ==1){ |
| | unlink($pic); |
| | } |
| | if($GLOBALS['config']['view']['actor_detail'] ==2 ){ |
| | $lnk = mac_url_actor_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,$update) |
| | { |
| | if(!is_array($update)){ |
| | return ['code'=>1001,'msg'=>lang('param_err')]; |
| | } |
| |
|
| | $res = $this->allowField(true)->where($where)->update($update); |
| | if($res===false){ |
| | return ['code'=>1001,'msg'=>lang('set_err').'：'.$this->getError() ]; |
| | } |
| |
|
| | $list = $this->field('actor_id,actor_name,actor_en')->where($where)->select(); |
| | foreach($list as $k=>$v){ |
| | $key = 'actor_detail_'.$v['actor_id']; |
| | Cache::rm($key); |
| | $key = 'actor_detail_'.$v['actor_en']; |
| | Cache::rm($key); |
| | } |
| |
|
| | return ['code'=>1,'msg'=>lang('set_ok')]; |
| | } |
| |
|
| | } |
