评论设计方案-后端业务实现

悠悠 2022-01-22 07:27 183阅读 0赞

后台效果预览：  
![后台效果预览][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpYW5oZW55dWFu_size_16_color_FFFFFF_t_70]  
一、表设计如下：

///评论表SQL
    CREATE TABLE `web_comment` (
      `com_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '评论id',
      `parent_com_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '评论父id',
      `com_title` varchar(40) NOT NULL DEFAULT '' COMMENT '评论昵称',
      `com_email` varchar(100) NOT NULL DEFAULT '' COMMENT '评论联系邮箱',
      `com_content` varchar(255) NOT NULL DEFAULT '' COMMENT '评论内容',
      `com_reply_status` int(2) NOT NULL DEFAULT '0' COMMENT '评论回复状态：0未回复，1已回复',
      `com_show_status` int(2) NOT NULL DEFAULT '0' COMMENT '评论展示状态：0未审核、1审核通过、2审核不通过',
      `com_ip` char(20) NOT NULL DEFAULT '' COMMENT '评论ip',
      `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
      `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
      PRIMARY KEY (`com_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='评论表';

二、获取数据代码如下

<?php
    namespace app\back\model;
    
    use think\Db;
    
    ///留言表
    class CommentModel
    {
        /// 用于存放子级数据
        private $child = [];
    
        ///获取评论数据
        public function getCommentData(){
            $top_map = [
                'parent_com_id' =>  0
            ];
            ///获取一级评论数据{desc最新的评论显示在顶部}
            $top_comment_data = Db::table('web_comment')->alias('b')->where($top_map)->order('b.com_show_status asc,b.com_reply_status asc,b.update_time desc')->column('b.com_id,b.parent_com_id,b.com_title,b.com_email,b.com_content,b.com_reply_status,b.com_show_status,b.com_ip,b.create_time,b.update_time', 'b.com_id');
    
    
            foreach ($top_comment_data as $k => $v) {
            	///自定义属性
                $top_comment_data[$k]['show_parent_id'] = -1;
                ///转义评论内容
                $top_comment_data[$k]['com_content'] = htmlspecialchars_decode($v['com_content']);
                // 获取二级评论
                $this->child = [];
                $this->getTree($v,$v['com_id']);
                $child_data = $this->child;
    
                ///修正排序，按照评论id降序{小到大}
                if (!empty($child_data)) {
                    // 按评论时间asc排序
                    uasort($child_data, function ($a, $b) {
                        $prev = $a['com_id'] ?? 0;
                        $next = $b['com_id'] ?? 0;
                        if ($prev == $next) {
                            return 0;
                        }
    
                        return ($prev < $next) ? -1 : 1;
                    });
                }
                ///获得子评论数据总数
                $top_comment_data[$k]['son_num'] = count($child_data);
                $top_comment_data[$k]['child'] = $child_data;
            }
    
            return $top_comment_data;
        }
    
        // 递归获取评论树状结构
        private function getTree($data,$show_parent_id)
        {
            $son_map = [
                'parent_com_id' =>  $data['com_id'] ?? -1
            ];
            ///获取当前评论的子级数据
            $child_data = Db::table('web_comment')->where($son_map)->order('com_id desc')->column('com_id,parent_com_id,com_title,com_email,com_content,com_reply_status,com_show_status,com_ip,create_time,update_time', 'com_id');
    
            if (!empty($child_data)) {
                foreach ($child_data as $k => $v) {
                    $v['show_parent_id'] = $show_parent_id;
                    $v['com_content']  = htmlspecialchars_decode($v['com_content']);
                    $this->child[] = $v;
                    $this->getTree($v,$show_parent_id);
                }
            }
        }
    
    
    
    }

三、后台页面数据遍历代码：

<table class="layui-table layui-form">
            <thead>
            <tr>
              <th>评论ID</th>
              <th>父级ID</th>
              <th>昵称</th>
              <th>回复数</th>
              <th>联系邮箱</th>
              <th>内容</th>
              <th>回复状态</th>
              <th>展示状态</th>
              <th>IP</th>
              <th>回复时间</th>
              <th>修改时间</th>
              <th>操作</th>
            </tr>
            </thead>
            <tbody class="x-cate">
            {if condition="empty($indexDataList)"}
            <tr cate-id='0' fid='0' >
              <td colspan="12" style="text-align: center;">
                <h1><font color="#8b0000">暂时没有任何数据</font></h1>
              </td>
            </tr>
            {else /}
            {volist name="indexDataList" id="vo"}
            <tr cate-id='{$vo.com_id}' fid='{$vo.parent_com_id}' >
              <td>{$vo.com_id}</td>
              <td>{$vo.parent_com_id}</td>
              <td>
                {if condition="$vo.son_num > 0"}
                <i class="layui-icon x-show" status='true'></i>
                {/if}
                {$vo.com_title}
              </td>
              <td>{$vo.son_num}</td>
              <td>{$vo.com_email}</td>
              <td>
                {$vo.com_content}
              </td>
              <td class="td-status">
                {eq name="$vo.com_reply_status" value="1"}
                <span class="layui-btn layui-btn-normal layui-btn-mini">已回复</span>
                {else/}
                <span class="layui-btn  layui-btn-warm layui-btn-mini">未回复</span>
                {/eq}
              </td>
              <td class="td-status">
                {if condition="$vo.com_show_status == 0"}
                <span class="layui-btn  layui-btn-warm layui-btn-mini">未审核</span>
                {elseif condition="$vo.com_show_status eq 1"/}
                <span class="layui-btn layui-btn-mini">审核通过</span>
                {else /}
                <span class="layui-btn layui-btn-danger layui-btn-mini">审核不通过</span>
                {/if}
              </td>
              <td>{$vo.com_ip}</td>
              <td>{$vo.create_time}</td>
              <td>{$vo.update_time}</td>
              <td class="td-manage">
                <button class="layui-btn layui-btn-xs"  href="javascript:;" onclick="reply({$vo.com_show_status},{$vo.com_id})">
                  <i class="layui-icon"></i>
                  回复
                </button>
                <br/>
    
                <button class="layui-btn-danger layui-btn layui-btn-xs" href="javascript:;"  onclick="x_admin_show('修改状态','/cusAdmin/leave-review?id={$vo.com_id}&show_status={$vo.com_show_status}',800,700)">
                  <i class="layui-icon"></i>
                  修改状态
                </button>
              </td>
            </tr>
            {volist name="$vo.child" id="son"}
            <tr cate-id='{$son.com_id}' fid='{$son.show_parent_id}' >
              <td>{$son.com_id}</td>
              <td>{$son.parent_com_id}</td>
              <td>
                    
                {$son.com_title}
              </td>
              <td></td>
              <td>{$son.com_email}</td>
              <td>
                {$son.com_content}
              </td>
              <td class="td-status">
                
                
                
                
                
              </td>
              <td class="td-status">
                
                
                
                
                
                
                
              </td>
              <td>{$son.com_ip}</td>
              <td>{$son.create_time}</td>
              <td>{$son.update_time}</td>
              <td class="td-manage">
              </td>
            </tr>
            {/volist}
            {/volist}
            {/if}
    
    
    
            </tbody>
          </table>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3hpYW5oZW55dWFu_size_16_color_FFFFFF_t_70]: /images/20220122/a115fa4eb4f84fa09f0450592dc5b5bc.png