|
|
<?php |
|
|
namespace app\common\model; |
|
|
use think\Db; |
|
|
|
|
|
class Comment extends Base { |
|
|
|
|
|
protected $name = 'comment'; |
|
|
|
|
|
|
|
|
protected $createTime = ''; |
|
|
protected $updateTime = ''; |
|
|
|
|
|
|
|
|
protected $auto = []; |
|
|
protected $insert = []; |
|
|
protected $update = []; |
|
|
|
|
|
public function getCommentStatusTextAttr($val,$data) |
|
|
{ |
|
|
$arr = [0=>lang('disable'),1=>lang('enable')]; |
|
|
return $arr[$data['comment_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); |
|
|
} |
|
|
$limit_str = ($limit * ($page-1) + $start) .",".$limit; |
|
|
if($totalshow==1) { |
|
|
$total = $this->where($where)->count(); |
|
|
} |
|
|
$list = Db::name('Comment')->field($field)->where($where)->order($order)->limit($limit_str)->select(); |
|
|
|
|
|
$user_ids=[]; |
|
|
foreach($list as $k=>$v){ |
|
|
$list[$k]['user_portrait'] = mac_get_user_portrait($v['user_id']); |
|
|
$list[$k]['comment_content'] = mac_restore_htmlfilter($list[$k]['comment_content']); |
|
|
|
|
|
$where2=[]; |
|
|
$where2['comment_pid'] = $v['comment_id']; |
|
|
$where2['comment_status'] = ['eq',1]; |
|
|
$sub = Db::name('Comment')->where($where2)->order($order)->select(); |
|
|
$list[$k]['sub'] = $sub; |
|
|
foreach($sub as $k2=>$v2){ |
|
|
$list[$k]['sub'][$k2]['user_portrait'] = mac_get_user_portrait($v2['user_id']); |
|
|
$list[$k]['sub'][$k2]['comment_content'] = mac_restore_htmlfilter($list[$k]['sub'][$k2]['comment_content']); |
|
|
} |
|
|
$list[$k]['data'] = []; |
|
|
if($v['comment_mid'] == 1){ |
|
|
$where3=[]; |
|
|
$where3['vod_id'] = ['eq',$v['comment_rid']]; |
|
|
$vod = model('Vod')->infoData($where3); |
|
|
$list[$k]['data'] = $vod['info']; |
|
|
} |
|
|
elseif($v['comment_mid'] == 2){ |
|
|
$where3=[]; |
|
|
$where3['art_id'] = ['eq',$v['comment_rid']]; |
|
|
$vod = model('Art')->infoData($where3); |
|
|
$list[$k]['data'] = $vod['info']; |
|
|
} |
|
|
elseif($v['comment_mid'] == 3){ |
|
|
$where3=[]; |
|
|
$where3['topic_id'] = ['eq',$v['comment_rid']]; |
|
|
$vod = model('Topic')->infoData($where3); |
|
|
$list[$k]['data'] = $vod['info']; |
|
|
} |
|
|
elseif($v['comment_mid'] == 8){ |
|
|
$where3=[]; |
|
|
$where3['actor_id'] = ['eq',$v['comment_rid']]; |
|
|
$vod = model('Actor')->infoData($where3); |
|
|
$list[$k]['data'] = $vod['info']; |
|
|
} |
|
|
elseif($v['comment_mid'] == 9){ |
|
|
$where3=[]; |
|
|
$where3['role_id'] = ['eq',$v['comment_rid']]; |
|
|
$vod = model('Role')->infoData($where3); |
|
|
$list[$k]['data'] = $vod['info']; |
|
|
} |
|
|
elseif($v['comment_mid'] == 11){ |
|
|
$where3=[]; |
|
|
$where3['website_id'] = ['eq',$v['comment_rid']]; |
|
|
$vod = model('Website')->infoData($where3); |
|
|
$list[$k]['data'] = $vod['info']; |
|
|
} |
|
|
} |
|
|
|
|
|
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']; |
|
|
$paging = $lp['paging']; |
|
|
$start = intval(abs($lp['start'])); |
|
|
$num = intval(abs($lp['num'])); |
|
|
$rid = intval(abs($lp['rid'])); |
|
|
$pid = intval(abs($lp['pid'])); |
|
|
$mid = intval(abs($lp['mid'])); |
|
|
$uid = intval(abs($lp['uid'])); |
|
|
$half = intval(abs($lp['half'])); |
|
|
$pageurl = $lp['pageurl']; |
|
|
$page = 1; |
|
|
$where = []; |
|
|
|
|
|
if(empty($num)){ |
|
|
$num = 20; |
|
|
} |
|
|
if($start>1){ |
|
|
$start--; |
|
|
} |
|
|
if (!in_array($mid, ['1','2','3','8','9'])) { |
|
|
|
|
|
} |
|
|
|
|
|
if(!in_array($paging, ['yes', 'no'])) { |
|
|
$paging = 'no'; |
|
|
} |
|
|
|
|
|
if($paging=='yes') { |
|
|
$param = mac_param_url(); |
|
|
if(!empty($param['mid'])){ |
|
|
$mid = $param['mid']; |
|
|
} |
|
|
if(!empty($param['rid'])){ |
|
|
$rid = $param['rid']; |
|
|
} |
|
|
if(!empty($param['pid'])){ |
|
|
$pid = $param['pid']; |
|
|
} |
|
|
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 = 'comment/index'; |
|
|
} |
|
|
$param['page'] = 'PAGELINK'; |
|
|
$pageurl = mac_url($pageurl,$param); |
|
|
} |
|
|
|
|
|
$where['comment_status'] = ['eq',1]; |
|
|
$where['comment_pid'] = ['eq',0]; |
|
|
|
|
|
if(!empty($rid)){ |
|
|
$where['comment_rid'] = ['eq',$rid]; |
|
|
} |
|
|
if(!empty($pid)){ |
|
|
$where['comment_pid'] = ['eq',$pid]; |
|
|
} |
|
|
if(!empty($uid)){ |
|
|
$where['user_id'] = ['eq',$uid]; |
|
|
} |
|
|
if(!empty($mid)){ |
|
|
$where['comment_mid'] = ['eq',$mid]; |
|
|
} |
|
|
|
|
|
if(!in_array($by, ['id', 'time','up','down'])) { |
|
|
$by = 'time'; |
|
|
} |
|
|
if(!in_array($order, ['asc', 'desc'])) { |
|
|
$order = 'desc'; |
|
|
} |
|
|
$order= 'comment_'.$by .' ' . $order; |
|
|
|
|
|
$cach_name = $GLOBALS['config']['app']['cache_flag']. '_' .md5('comment_listcache_'.join('&',$where).'_'.$order.'_'.$page.'_'.$num.'_'.$start); |
|
|
|
|
|
$res = $this->listData($where,$order,$page,$num,$start); |
|
|
$res['pageurl'] = $pageurl; |
|
|
$res['half'] = $half; |
|
|
return $res; |
|
|
|
|
|
} |
|
|
|
|
|
public function infoData($where,$field='*') |
|
|
{ |
|
|
if(empty($where) || !is_array($where)){ |
|
|
return ['code'=>1001,'msg'=>lang('param_err')]; |
|
|
} |
|
|
$info = $this->field($field)->where($where)->find(); |
|
|
|
|
|
if(empty($info)){ |
|
|
return ['code'=>1002,'msg'=>lang('obtain_err')]; |
|
|
} |
|
|
$info = $info->toArray(); |
|
|
|
|
|
return ['code'=>1,'msg'=>lang('obtain_ok'),'info'=>$info]; |
|
|
} |
|
|
|
|
|
public function saveData($data) |
|
|
{ |
|
|
$validate = \think\Loader::validate('Comment'); |
|
|
if(!$validate->check($data)){ |
|
|
return ['code'=>1001,'msg'=>lang('param_err').'：'.$validate->getError() ]; |
|
|
} |
|
|
|
|
|
|
|
|
$filter_fields = [ |
|
|
'comment_name', |
|
|
'comment_content', |
|
|
]; |
|
|
foreach ($filter_fields as $filter_field) { |
|
|
if (!isset($data[$filter_field])) { |
|
|
continue; |
|
|
} |
|
|
$data[$filter_field] = mac_filter_xss($data[$filter_field]); |
|
|
} |
|
|
|
|
|
if(!empty($data['comment_id'])){ |
|
|
$where=[]; |
|
|
$where['comment_id'] = ['eq',$data['comment_id']]; |
|
|
$res = $this->allowField(true)->where($where)->update($data); |
|
|
} |
|
|
else{ |
|
|
$data['comment_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) |
|
|
{ |
|
|
$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'=>1001,'msg'=>lang('set_err').'：'.$this->getError() ]; |
|
|
} |
|
|
return ['code'=>1,'msg'=>lang('set_ok')]; |
|
|
} |
|
|
|
|
|
} |
