|
|
<?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')]; |
|
|
} |
|
|
|
|
|
} |
