+----------------------------------------------------------------------------------------------- */ declare (strict_types = 1); namespace app\api\model; use think\facade\Db; use think\Model; class Comment extends Model { //列表 function datalist($param=[],$where=[]) { $rows = empty($param['limit']) ? get_config('app.page_size') : $param['limit']; $order = empty($param['order']) ? 'id desc' : $param['order']; try { $list = self::where($where) ->order($order) ->paginate(['list_rows'=> $rows]) ->each(function ($item, $key) use($param){ $item['create_times'] = time_trans($item['create_time']); if($item['update_time']>0){ $item['update_times'] = ',最后编辑时间:'.time_trans($item['update_time']); } else{ $item['update_times'] = ''; } $item['thumb'] = Db::name('Admin')->where(['id' => $item['admin_id']])->value('thumb'); $item['name'] = Db::name('Admin')->where(['id' => $item['admin_id']])->value('name'); $to_names = Db::name('Admin')->where([['id', 'in', $item['to_uids']]])->column('name'); if (empty($to_names)) { $item['to_names'] = '-'; } else { $item['to_names'] = implode(',', $to_names); } $item['read'] = 0; if($item['admin_id'] == $param['admin_id']){ $item['read'] = 2; } else{ $count = Db::name('CommentRead')->where(['comment_id' => $item['id'],'admin_id' => $param['admin_id']])->count(); if($count>0){ $item['read'] = 1; } } if($item['pid']>0){ $pcomment = Db::name('Comment')->where('id','=',$item['pid'])->find(); $padmin_id =$pcomment['admin_id']; $item['padmin'] =Db::name('Admin')->where('id','=',$padmin_id)->value('name'); $item['ptimes'] =time_trans($pcomment['create_time']); $item['pcontent'] = $pcomment['content']; } return $item; }); return $list; } catch(\Exception $e) { return ['code' => 1, 'data' => [], 'msg' => $e->getMessage()]; } } }