tp分页

z1643586107

于 2019-11-19 23:46:37 发布

阅读量146

点赞数

分类专栏： php 文章标签： tp5分页

本文链接：https://blog.csdn.net/z1643586107/article/details/103153825

版权

php 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

tp5 分页

动态举报管理

发布时间

查询重置

<?php if($user_info){ ?> {foreach $user_info as $user_row}

数据列表

选项发布者ID 发布者昵称发布地区文字内容举报次数发布时间操作

{$user_row.mem_id}

{$user_row.nickname}

{$user_row.city}

{$user_row.content|substr=0,40}

数据列表
	{$user_row.mem_id}	{$user_row.nickname}	{$user_row.city}	{$user_row.content\|substr=0,40}	{$user_row.report_count}	{$user_row.create_time}	详情删除 {/if} `</div> </td> </tr> {/foreach} <?php } ?> </tbody> <tfoot> <th colspan="11"> <span id="checkall" checked><input type="checkbox" class="layui-btn" ></span>全选 <div class="layui-input-inline" id="acut"> <select name="num"> <option value="">批量操作</option> <option value="2" >删除</option> </select> </div> <button id='batch_btn' class="layui-btn" > 确定 </button> </th> </tfoot> </table> </div> </div> </div>`

{$user_row.report_count}

{$user_row.create_time}

详情删除 {/if}

            </div>
          </td>
        </tr>
        {/foreach}
        <?php } ?>
        </tbody>
        <tfoot>
        <th colspan="11">
          <span id="checkall" checked><input type="checkbox" class="layui-btn" ></span>全选
          <div class="layui-input-inline" id="acut">
            <select name="num">
              <option value="">批量操作</option>
              <option value="2" >删除</option>
            </select>
          </div>
          <button  id='batch_btn' class="layui-btn" >
            确定
          </button>
        </th>
        </tfoot>
      </table>
    </div>
  </div>
</div>

<?php /** * Created by PhpStorm. * User: zeng152330 * Date: 2018/12/3 * Time: 16:01 */ namespace app\admin\controller; use think\Db; class ReportController extends BaseController { /** * 动态列表 * @param int $page * @return mixed * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException */ public function dynamicList($page = 1) { if ($page < 1) { $page = 1; } $mem_id = isset($_GET['mem_id']) ? $_GET['mem_id'] : ''; $name = isset($_GET['name']) ? $_GET['name'] : ''; $start_time = isset($_GET['start_time']) ? $_GET['start_time']: ''; $end_time = isset($_GET['end_time']) ? $_GET['end_time'] : ''; $where = []; if ($mem_id != '') { $where['m.id'] = ['=', $mem_id]; } if ($name != '') { $where['m.nickname'] = ['like', '%' . $name . '%']; } if ($start_time != '' && $end_time != '') { $tmp1 = strtotime(date('Y-m-d 00:00:00',strtotime($start_time))); $tmp2 = strtotime(date('Y-m-d 23:59:59',strtotime($end_time))); $where['p.create_time'] = ['BETWEEN', [$tmp1, $tmp2]]; } elseif ($start_time == '' && $end_time != '') { $tmp2 = strtotime(date('Y-m-d 23:59:59',strtotime($end_time))); $where['p.create_time'] = ['<', $tmp2]; } elseif ($end_time == '' && $start_time != '') { $tmp1 = strtotime(date('Y-m-d 00:00:00',strtotime($start_time))); $where['p.create_time'] = ['>', $tmp1]; } $offset = 10; $count = Db::name('report r') ->join('publication p','r.content_id = p.id') ->join('member m','m.id=p.mem_id') ->where($where) ->where('r.report_type=1') ->count('distinct(p.id)'); $pages = ceil($count / $offset); $pre = ($page - 1) * $offset; $sql = "select count(re.id) from t_report re where re.content_id =p.id and re.report_type=1 "; $ids = Db::name('report r') ->join('publication p','r.content_id = p.id') ->join('member m','m.id=p.mem_id') ->distinct(true) ->field('p.id') ->where($where) ->where('r.report_type=1') ->select(); if (count($ids) > 0) { $arr = array_column($ids,'id'); $id = implode(',',$arr); } else { $id =0; } $user_info = Db::name('member m,t_publication p') ->field("m.id as mem_id,m.nickname,p.id,p.city,p.content,p.create_time,({$sql}) as report_count") ->where($where) ->where("m.id=p.mem_id and p.id in ($id)") ->order('report_count desc') ->limit($pre, $offset) ->select(); if (count($user_info) > 0) { foreach ($user_info as $key=>$value) { $user_info[$key]['create_time'] = date('Y-m-d H:i:s', $value['create_time']); } } $this->assign('pages', $pages); $this->assign('count', $count); $this->assign('user_info', $user_info); $this->assign([ 'page' => $page, 'count' => $count, 'search_id' =>$mem_id, 'search_name' => $name, 'search_start_time' => $start_time, 'search_end_time' => $end_time, ]); return $this->fetch(); } /** * Notes:动态举报详情 * Auther: 秦汉 * Date: 2018/12/7 * @param $id * @param int $page * @return mixed */ public function reportDynamicList($id, $page = 1) { if ($page < 1) { $page = 1; } $mem_id = input('post.id'); $offset = 5; $count = Db::name('report') ->where(['content_id' => $id,'report_type' => 1]) ->count("id"); $pages = ceil($count / $offset); $pre = ($page - 1) * $offset; $info = Db::name('report r, t_member m') ->field("m.nickname,m.mobile,m.head_pic,r.id,r.report_style,r.report_time,r.reason") ->where(" r.content_id= {$id} and r.report_type=1 and r.report_userid = m.id") ->order('r.report_time desc') ->limit($pre, $offset) ->select(); if (count($info) > 0) { foreach ($info as $key => $value) { $info[$key]['head_pic'] = 'http://'.$_SERVER['HTTP_HOST'].uploadName().$value['head_pic']; } } $this->assign('id', $id); $this->assign('pages', $pages); $this->assign('count', $count); $this->assign('info', $info); $this->assign([ 'page' => $page, 'count' => $count, ]); return $this->fetch(); } /** *删除动态 */ public function delDynamic() { $publication_id = input('post.id'); //删除我的动态同时删除相关的评论,相关的点赞,相关的举报,相关的收藏 Db::startTrans(); try{ Db::name('publication')->delete([$publication_id]); Db::name('publication_comment')->where(['publication_id'=>['in',$publication_id]])->delete(); Db::name('publication_point')->where(['publication_id'=>['in',$publication_id]])->delete(); Db::name('publication_collect')->where(['publication_id'=>['in',$publication_id]])->delete(); Db::name('report')->where(['content_id'=>['in',$publication_id],'report_type'=>1])->delete(); Db::commit(); return 1; }catch (\Exception $e) { // 回滚事务 Db::rollback(); return 0; } } /** * 批量删除动态 * @return int * @throws \think\Exception * @throws \think\exception\PDOException */ public function batchDynamic() { $arr = input('post.'); $ids = implode(',', $arr['arr']); Db::name('publication')->delete($ids); Db::name('publication_comment')->where(['publication_id'=>['in',$ids]])->delete(); Db::name('publication_point')->where(['publication_id'=>['in',$ids]])->delete(); Db::name('publication_collect')->where(['publication_id'=>['in',$ids]])->delete(); Db::name('report')->where(['content_id'=>['in',$ids],'report_type'=>1])->delete(); return 0; } /** * 动态详情 * @return mixed * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException */ public function dynamicInfo($id = '') { $info = Db::name('member m,t_publication p') ->field("m.nickname,m.head_pic,p.id,p.city,p.content,p.filename,p.create_time") ->where("m.id=p.mem_id and p.id=$id") ->find(); $info['head_pic'] = 'http://'.$_SERVER['HTTP_HOST'].uploadName().$info['head_pic']; $info['create_time'] = date('Y-m-d H:i:s', $info['create_time']); $point_total = Db::name('publication_point')->where('publication_id',$id)->count('id'); $info['point_count'] = $point_total; if (!empty($info['filename'])) { $array =explode(';', $info['filename']); foreach ($array as $key => $value) { $array[$key] = 'http://'.$_SERVER['HTTP_HOST'].uploadName().$value; } $info['filename'] = $array; } $comments = $this->comment($id); $count = Db::name('publication_comment t') ->join('member m','t.form_userid=m.id','left') ->where('t.publication_id',$id) ->count('t.id'); $page = 1; $this->assign('info', $info); $this->assign('count', $count); $this->assign('page', $page); $this->assign('id', $id); $this->assign('comments', $comments); return $this->fetch(); } /** * 查询评论 * @param int $id * @param int $pre * @param int $offset * @return false|\PDOStatement|string|\think\Collection * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException */ public function comment($id, $pre = 0, $offset = 5) { $comments = Db::name('publication_comment t') ->join('member m','t.form_userid=m.id','left') ->field("m.nickname,m.head_pic,t.id ,t.publication_id,t.form_userid,t.to_userid,t.content,t.create_time,t.status,t.comment_type") ->where('t.publication_id',$id) ->order('t.create_time desc') ->limit($pre, $offset) ->select(); if(count($comments) > 0) { foreach ($comments as $key => $val) { $comments[$key]['create_time'] = date('Y-m-d H:i:s'); $comments[$key]['head_pic'] = 'http://'.$_SERVER['HTTP_HOST'].uploadName().$val['head_pic']; } } return $comments; } /** * 评论翻页 * @return mixed * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException */ public function comPage() { $id = isset($_POST['id']) ? $_POST['id'] : ''; $page = isset($_POST['page']) ? $_POST['page'] : ''; $pre = ($page - 1) * 5; $com_page = $this->comment($id, $pre); $con_html = $this->comHtml($com_page); return $con_html; } /** * 评论页面 * @param $com * @return string */ public function comHtml($com) { $html_str = ''; foreach ($com as $key => $value) { $html_str .= '

'; $html_str .= '

'; $html_str .= ' ' . $value['nickname'] . ''; $html_str .= '' . $value['create_time'] . ''; $html_str .= ''; $html_str .= ''; $html_str .= '

'; $html_str .= '

' . $value['content'] . '

'; $html_str .= '

'; } return $html_str; } /** * 删除评论 * @return int * @throws \think\Exception * @throws \think\exception\PDOException */ public function delComments() { $id = input('post.com_id'); //删除我的动态同时删除相关的评论,相关的点赞,相关的举报,相关的收藏 Db::startTrans(); try{ Db::name('publication_comment')->where(['id'=>$id])->delete(); Db::name('report')->where(['content_id'=>$id,'report_type'=>2])->delete(); Db::commit(); return 1; }catch (\Exception $e) { // 回滚事务 Db::rollback(); return 0; } } /** * 评论详情 * @param int $page * @return mixed * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException */ public function commentList($page = 1) { if ($page < 1) { $page = 1; } $mem_id = isset($_GET['mem_id']) ? $_GET['mem_id'] : ''; $name = isset($_GET['name']) ? $_GET['name'] : ''; $start_time = isset($_GET['start_time']) ? $_GET['start_time']: ''; $end_time = isset($_GET['end_time']) ? $_GET['end_time'] : ''; $where = []; if ($mem_id != '') { $where['m.id'] = ['=', $mem_id]; } if ($name != '') { $where['m.nickname'] = ['like', '%' . $name . '%']; } if ($start_time != '' && $end_time != '') { $tmp1 = strtotime(date('Y-m-d 00:00:00',strtotime($start_time))); $tmp2 = strtotime(date('Y-m-d 23:59:59',strtotime($end_time))); $where['p.create_time'] = ['BETWEEN', [$tmp1, $tmp2]]; } elseif ($start_time == '' && $end_time != '') { $tmp2 = strtotime(date('Y-m-d 23:59:59',strtotime($end_time))); $where['p.create_time'] = ['<', $tmp2]; } elseif ($end_time == '' && $start_time != '') { $tmp1 = strtotime(date('Y-m-d 00:00:00',strtotime($start_time))); $where['p.create_time'] = ['>', $tmp1]; } $offset = 10; $count = Db::name('report r') ->join('publication_comment p','r.content_id = p.id') ->join('member m','m.id=p.form_userid') ->where($where) ->where('r.report_type=2') ->count('distinct(p.id)'); $pages = ceil($count / $offset); $pre = ($page - 1) * $offset; $sql = "select count(re.id) from t_report re where re.content_id =p.id and re.report_type=2 "; $ids = Db::name('report r') ->join('publication_comment p','r.content_id = p.id') ->join('member m','m.id=p.form_userid') ->distinct(true) ->field('p.id') ->where($where) ->where('r.report_type=2') ->select(); if (count($ids) > 0) { $arr = array_column($ids,'id'); $id = implode(',',$arr); } else { $id =0; } $user_info = Db::name('member m,t_publication_comment p') ->field("m.id as mem_id,m.nickname,p.id,p.content,p.create_time,({$sql}) as report_count") ->where($where) ->where("m.id=p.form_userid and p.id in ($id)") ->order('report_count desc') ->limit($pre, $offset) ->select(); if (count($user_info) > 0) { foreach ($user_info as $key=>$value) { $user_info[$key]['create_time'] = date('Y-m-d H:i:s', $value['create_time']); } } $this->assign('pages', $pages); $this->assign('count', $count); $this->assign('user_info', $user_info); $this->assign([ 'page' => $page, 'count' => $count, 'search_id' =>$mem_id, 'search_name' => $name, 'search_start_time' => $start_time, 'search_end_time' => $end_time, ]); return $this->fetch(); } /** * Notes: 评论举报 * Auther: 秦汉 * Date: 2018/12/7 * @param $id * @param int $page * @return mixed */ public function reportCommentList($id, $page = 1) { if ($page < 1) { $page = 1; } $mem_id = input('post.id'); $offset = 5; $count = Db::name('report') ->where(['content_id' => $id,'report_type' => 2]) ->count("id"); $pages = ceil($count / $offset); $pre = ($page - 1) * $offset; $info = Db::name('report r, t_member m') ->field("m.nickname,m.mobile,m.head_pic,r.id,r.report_style,r.report_time,r.reason") ->where(" r.content_id= {$id} and r.report_type=2 and r.report_userid = m.id") ->order('r.report_time desc') ->limit($pre, $offset) ->select(); if (count($info) > 0) { foreach ($info as $key => $value) { $info[$key]['head_pic'] = 'http://'.$_SERVER['HTTP_HOST'].uploadName().$value['head_pic']; } } $this->assign('id', $id); $this->assign('pages', $pages); $this->assign('count', $count); $this->assign('info', $info); $this->assign([ 'page' => $page, 'count' => $count, ]); return $this->fetch(); } /** * 动态详情 * @return mixed * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException */ public function commentInfo($id = '') { $publication_id = Db::name('publication_comment')->where('id',$id)->value('publication_id'); $info = Db::name('member m,t_publication p') ->field("m.nickname,m.head_pic,p.id,p.city,p.content,p.filename,p.create_time") ->where("m.id=p.mem_id and p.id=$publication_id ") ->find(); $info['head_pic'] = 'http://'.$_SERVER['HTTP_HOST'].uploadName().$info['head_pic']; $info['create_time'] = date('Y-m-d H:i:s', $info['create_time']); $point_total = Db::name('publication_point')->where('publication_id',$publication_id)->count('id'); $info['point_count'] = $point_total; if (!empty($info['filename'])) { $array =explode(';', $info['filename']); foreach ($array as $key => $value) { $array[$key] = 'http://'.$_SERVER['HTTP_HOST'].uploadName().$value; } $info['filename'] = $array; } $comments = $this->comment($id); $count = Db::name('publication_comment t') ->join('member m','t.form_userid=m.id','left') ->where('t.publication_id',$id) ->count('t.id'); $page = 1; $this->assign('info', $info); $this->assign('count', $count); $this->assign('page', $page); $this->assign('id', $id); $this->assign('comments', $comments); return $this->fetch(); } /** *删除评价 */ public function delComment() { $comment_id = input('post.id'); //删除我的动态同时删除相关的评论,相关的点赞,相关的举报,相关的收藏 Db::startTrans(); try{ Db::name('publication_comment')->where(['id'=>['in',$comment_id]])->delete(); Db::name('report')->where(['content_id'=>['in',$comment_id],'report_type'=>2])->delete(); Db::commit(); return 1; }catch (\Exception $e) { // 回滚事务 Db::rollback(); return 0; } } /** * 批量删除动态 * @return int * @throws \think\Exception * @throws \think\exception\PDOException */ public function batchComment() { $arr = input('post.'); $ids = implode(',', $arr['arr']); Db::name('publication_comment')->where(['id'=>['in',$ids]])->delete(); Db::name('report')->where(['content_id'=>['in',$ids],'report_type'=>2])->delete(); return 0; } }