colleague / study-project · Files

<?php
/**
 * 同事圈信息表
 * User: 代军
 * Date: 2017-04-24
 */

namespace Common\Service;

use Common\Common\AttachOperation;
use Common\Common\Config;
use Common\Common\Constant;
use Common\Common\Help;
use Common\Common\Integral;
use Common\Common\User;
use Common\Model\AttachmentModel;
use Common\Model\CircleModel;
use Common\Model\CountModel;
use Common\Model\HistoryModel;
use Common\Model\LikeModel;
use Common\Model\LogModel;
use Common\Model\RightModel;
use Common\Model\SceneModel;
use VcySDK\Service;

class CircleService extends AbstractService
{

    // 审核中
    const AUDIT_ING = 0;
    // 审核通过
    const AUDIT_OK = 1;
    // 审核驳回
    const AUDIT_NO = 2;


    // 系统审核
    const AUDIT_SYSTEM_TYPE = 1;

    // 后台审核
    const AUDIT_ADMIN_TYPE = 2;


    // 话题最大字符长度
    const FONT_CIRCLE_LENGTH = 1000;

    // 评论最大字符长度
    const FONT_COMMENT_LENGTH = 140;

    // 附件最大个数
    const AT_MAX_MUN = 9;

    // 开启匿名评论
    const ANONYMOUS_OPEN = 2;
    // 关闭匿名评论
    const ANONYMOUS_CLOSE = 1;

    // 匿名评论
    const ANONYMOUS_YES = 1;
    // 非匿名评论
    const ANONYMOUS_NO = 2;

    // 管理后台设置开启匿名评论
    const ADMIN_ANONYMOUS_OPEN = 1;

    // 管理后台设置关闭匿名评论
    const ADMIN_ANONYMOUS_CLOSE = 2;

    // 当前用户不是是发起人
    const UN_SPONSOR = 0;

    // 当前用户是发起人
    const SPONSOR = 1;

    // 当前用户没有点过赞
    const UN_LIKE = 0;

    // 当前用户点过赞
    const LIKE = 1;

    // 当前用户不能删除
    const UN_DEL = 0;

    // 当前用户可删除
    const DEL = 1;

    // 含有附件
    const HAVE_ATTACH = 1;

    // 话题搜索全部
    const CIRCLE = 3;


    // 话题被回复类型
    const CIRCLE_REPLY_TYPE = 1;

    // 回复话题类型
    const CIRCLE_RESTORE_TYPE = 2;

    // 首次
    const  COMMENT_FIRST = 1;

    // 同事圈话题发布审核开关键名
    const WORKMATE_CHECK_KEY = 'release';
    // 同事圈评论发布审核开关键名
    const WORKMATE_COMMENT_CHECK_KEY = 'comment';
    // 匿名评论开关键名
    const WORKMATE_COMMENT_ANONYMOUS = 'anonymous';

    /**
     * 附件数据库操作类实例
     *
     * @type null|
     */
    protected $_d_att = null;

    /**
     * 点赞操作类实例
     *
     * @type null|
     */
    protected $_d_like = null;

    /**
     * 统计操作类实例
     *
     * @type null|
     */
    protected $_d_count = null;

    /**
     * 积分日志操作实例化
     *
     * @type null|
     */
    protected $_d_log = null;

    /**
     * 话题回复历史记录表
     *
     * @type null|
     */
    protected $_d_history = null;


    /**
     * 话题权限表
     * @var RightModel|null
     */
    protected $_d_right = null;

    /*
     * @var SceneModel|null
     */
    protected $_d_scene = null;


    // 构造方法
    public function __construct()
    {
        $this->_d = new CircleModel();

        $this->_d_att = new AttachmentModel();

        $this->_d_like = new LikeModel();

        $this->_d_count = new CountModel();

        $this->_d_log = new LogModel();

        $this->_d_history = new HistoryModel();

        $this->_d_right = new RightModel();

        $this->_d_scene = new SceneModel();


        parent::__construct();
    }

    /**
     * 格式化后台帖子列表数据
     *
     * @param $list
     *
     * @return bool
     */
    public function format_list_data(&$list)
    {

        if (empty($list)) {
            return true;
        }

        // 取出列表的用户ID集合
        $uids = array_column($list, 'uid');

        // 查询用户集合数据
        $member = new User();
        $user_list = $member->listByConds(['memUids' => $uids], 1, count($uids));

        // 获取已查询到UID列表
        $uid_list = array_column($user_list['list'], 'memUid');

        // 获取全部用户列表
        $this->user_list($user_list['list'], $uids, $uid_list);
        $user_list['list'] = array_combine_by_key($user_list['list'], 'memUid');

        // 获取帖子ID集合
        $ids = array_column($list, 'id');

        // 获取点赞总数
        $like_data = $this->_d_like->get_like_total($ids);
        // 将点赞数据转换成以帖子ID为key的二维数组
        $like_data = array_combine_by_key($like_data, 'cid');

        // 获取通过审核评论数
        $comment_ok_list = $this->_d->get_comment_num($ids, self::AUDIT_OK);
        // 将评论数据转换成以帖子ID为key的二维数组
        $comment_ok_data = array_combine_by_key($comment_ok_list, 'pid');

        // 获取待审核评论数
        $commont_ing_list = $this->_d->get_comment_num($ids, self::AUDIT_ING);
        // 将评论数据转换成以帖子ID为key的二维数组
        $commont_ing_data = array_combine_by_key($commont_ing_list, 'pid');

        // 循环给列表中字段赋值
        foreach ($list as &$v) {

            // 获取用户所在的所有部门
            $res_dpNames = array_column($user_list['list'][$v['uid']]['dpName'], 'dpName');
            $dpNames = '';
            if (!empty($res_dpNames)) {
                $dpNames = implode(';', $res_dpNames);
            }
            $v['dpName'] = $dpNames;
            $v['username'] = empty($v['uid']) ? '管理员' : strval($user_list['list'][$v['uid']]['memUsername']);
            $v['like_total'] = intval($like_data[$v['id']]['total']);
            $v['commont_ok_total'] = intval($comment_ok_data[$v['id']]['total']);
            $v['commont_ing_total'] = intval($commont_ing_data[$v['id']]['total']);
            $v['audit_state'] = intval($v['audit_state']);
            $v['id'] = intval($v['id']);
            $v['audit_time'] = strval($v['a_time']);
            $v['audit_name'] = strval($v['audit_uname']);
            // 清除多余数据
            unset(
                $v['a_time'],
                $v['audit_type'],
                $v['is_attach'],
                $v['pid'],
                $v['domain'],
                $v['status'],
                $v['updated'],
                $v['deleted']
            );
        }

        return true;
    }

    /**
     * 后台审核话题推送消息
     *
     * @param $data 话题详情
     * @param $param 审核参数
     * @param $user  审核人信息
     *
     * @return bool
     */
    public function send_replies_msg_admin($data, $param, $user)
    {
        // 初始化类型
        $msg_type = 0;

        // 初始化消息参数
        $msg_params = [];
        $msg_params['description'] = $data['content'];
        $msg_params['User'] = $user['eaRealname'];
        $msg_params['uids'] = [['memID' => $data['uid']]];
        $msg_params['id'] = $param['id'];

        if (self::AUDIT_OK == $param['audit_state']) {
            // 回帖审核通过
            $msg_type = self::MSG_REPLIES_ADOPT;

        } else {
            if (self::AUDIT_NO == $param['audit_state']) {
                // 回帖审核驳回
                $msg_type = self::MSG_REPLIES_REFUSE;
            }
        }

        $this->send_msg($msg_params, $msg_type);

        return true;

    }

    /**
     * 后台审核评论推送消息
     *
     * @param $data 评论详情
     * @param $param 审核参数
     * @param $user  审核人信息
     *
     * @return bool
     */
    public function send_comment_msg_admin($data, $param, $user)
    {
        // 初始化类型
        $msg_type = 0;

        // 初始化消息参数
        $msg_params = [];
        $msg_params['description'] = $data['content'];
        $msg_params['User'] = $user['eaRealname'];
        $msg_params['uids'] = [['memID' => $data['uid']]];
        $msg_params['id'] = $data['id'];

        if (self::AUDIT_OK == $param['audit_state']) {

            // 评论审核通过
            $msg_type = self::MSG_COMMENT_ADOPT;
            // 如果是回帖的评论
            if ($data['type'] == Constant::CIRCLE_COMMENT_TOPIC_TYPE) {
                $msg_type = self::MSG_CIRCLE_TOPIC_COMMENT_ADOPT;
            }

            $msg_params['id'] = $data['pid'];

        } else {
            if (self::AUDIT_NO == $param['audit_state']) {
                // 评论审核驳回
                $msg_type = self::MSG_COMMENT_REFUSE;
            }
        }

        $this->send_msg($msg_params, $msg_type);

        // 给话题发布人推送消息
        if (self::AUDIT_OK == $param['audit_state']) {

            $msg_type = self::MSG_COMMENT;
            // 如果是回帖的评论
            if ($data['type'] == Constant::CIRCLE_COMMENT_TOPIC_TYPE) {
                $msg_type = self::MSG_TOPIC_COMMENT;
            }

            // 查询评论对应的话题信息
            $h_data = $this->get($data['pid']);

            // 初始化为匿名
            $user_info['memUsername'] = Constant::SETTING_ANONYMOUS_NAME;

            // 如果没有匿名评论
            if (self::ANONYMOUS_NO == $data['is_anonymous']) {
                // 获取用户详情
                $user_info = User::instance()->getByUid($data['uid']);
            }

            $msg_params = [];
            $msg_params['description'] = $data['content'];
            $msg_params['name'] = $user_info['memUsername'];
            $msg_params['uids'] = [['memID' => $h_data['uid']]];
            $msg_params['id'] = $data['pid'];

            $this->send_msg($msg_params, $msg_type);
        }

        return true;

    }


    /**
     * 后台审核帖子推送消息
     *
     * @param $data 话题详情
     * @param $params 审核参数
     * @param $user  审核人信息
     *
     * @return bool
     */
    public function send_msg_admin($data, $params, $user)
    {
        $msg_type = 0;
        if (self::AUDIT_OK == $params['audit_state']) {
            // 帖子审核通过
            $msg_type = self::MSG_CIRCLE_ADOPT;
            // 回帖类型
            if (Constant::CIRCLE_REPLIES_TOPIC_TYPE == $data['type']) {
                $msg_type = self::MSG_REPLIES_ADOPT;
            }
        } else {
            if (self::AUDIT_NO == $params['audit_state']) {

                // 帖子审核驳回
                $msg_type = self::MSG_CIRCLE_REFUSE;
                // 回帖类型
                if (Constant::CIRCLE_REPLIES_TOPIC_TYPE == $data['type']) {
                    $msg_type = self::MSG_REPLIES_REFUSE;
                }
            }
        }

        $msg_params = [];
        $msg_params['description'] = $data['content'];
        $msg_params['User'] = $user['eaRealname'];
        $msg_params['uids'] = [['memID' => $data['uid']]];
        $msg_params['id'] = $data['id'];

        $this->send_msg($msg_params, $msg_type);

        return true;
    }

    /**
     * 后台审核话题推送消息
     *
     * @param $data 话题详情
     * @param $params 审核参数
     * @param $user  审核人信息
     *
     * @return bool
     */
    public function send_msg_topic_admin($data, $params, $user)
    {
        $msg_type = 0;
        if (self::AUDIT_OK == $params['audit_state']) {
            // 话题审核通过
            $msg_type = self::MSG_CIRCLE_TOPIC_ADOPT;
        } else {
            if (self::AUDIT_NO == $params['audit_state']) {
                // 话题审核驳回
                $msg_type = self::MSG_CIRCLE_TOPIC_REFUSE;
            }
        }

        $msg_params = [];
        $msg_params['description'] = $data['content'];
        $msg_params['title'] = $data['title'];
        $msg_params['User'] = $user['eaRealname'];
        $msg_params['uids'] = [['memID' => $data['uid']]];
        $msg_params['id'] = $data['id'];

        $this->send_msg($msg_params, $msg_type);

        return true;
    }

    /**
     * 根据用户名获取用户ID集合
     *
     * @param $uname
     *
     * @return array
     */
    public function get_uids_by_uname($uname)
    {
        // 根据发帖人姓名查询发帖人ID
        $member = new User(Service::instance());
        $user_list = $member->listByConds(['memUsername' => $uname, 'memSubscribeStatus' => 1]);

        $uids = [];
        // 如果获取的用户信息不为空
        if (!empty($user_list)) {
            // 将用户数组 转换成 以用户ID为值的一维数组
            $uids = array_column($user_list['list'], 'memUid');
        }

        return $uids;
    }

    /**
     * 组装后台帖子列表查询条件
     *
     * @param $params 传入参数
     *
     * @return Array
     */
    public function get_where_conds($params)
    {
        // 标识主帖
        $where['pid'] = 0;

        // 如果发帖人搜索条件不为空
        if (!empty($params['username'])) {
            $where['username like ?'] = '%' . $params['username'] . '%';
        }

        // 如果帖子状态搜索条件存在
        if (intval($params['audit_state']) < self::CIRCLE) {
            $where['audit_state'] = $params['audit_state'];
        }

        // 时间区间
        if ($params['start_time']) {
            $where['created >= ?'] = $params['start_time'];
        }
        if ($params['end_time']) {
            $where['created <= ?'] = $params['end_time'];
        }

        return $where;
    }

    /**
     * 格式化后台帖子评论列表数据
     *
     * @param $list
     *
     * @return bool
     */
    public function format_comment_list_data(&$list)
    {
        if (!empty($list)) {

            // 取出列表的用户ID集合
            $uids = array_column($list, 'uid');

            // 查询用户集合数据
            $member = new User(Service::instance());
            $user_list = $member->listByConds(['memUids' => $uids], 1, count($uids));

            // 将用户数据转换成以用户ID为key的二维数组
            $user_data = array_combine_by_key($user_list['list'], 'memUid');

            // 获取评论ID集合
            $ids = array_column($list, 'id');
            // 获取点赞总数
            $like_data = $this->_d_like->get_like_total($ids);
            // 将点赞数据转换成以评论ID为key的二维数组
            $like_data = array_combine_by_key($like_data, 'cid');

            // 循环给列表中字段赋值
            foreach ($list as &$v) {
                $v['username'] = strval($user_data[$v['uid']]['memUsername']);
                $v['avatar'] = strval($user_data[$v['uid']]['memFace']);
                $v['like_total'] = intval($like_data[$v['id']]['total']);
                // 清除多余数据
                unset(
                    $v['domain'],
                    $v['status'],
                    $v['updated'],
                    $v['deleted']
                );
            }
        }

        return true;
    }


    /**
     * 格式化帖子详情
     *
     * @param $data
     *
     * @return mixed
     */
    public function format_detail(&$data)
    {
        // 获取发帖人用户名及头像
        $member = new User();
        $user_data = $member->getByUid($data['uid']);

        $data['username'] = $user_data['memUsername'];
        $data['avatar'] = $user_data['memFace'];
        $data['department'] = implode(';', array_column($user_data['dpName'], 'dpName'));

        // 获取帖子图片附件数据
        $images = [];
        // 如果帖子含有附件
        if ($data['is_attach'] == self::HAVE_ATTACH) {
            // 查询附件
            $attach_list = $this->_d_att->list_by_conds(['cid' => $data['id']]);
            // 格式化图片数据
            $image_list = $this->format_att_images($attach_list);
            $images = $image_list[$data['id']];
        }
        $data['images'] = $images;
        // 获取点赞以及评论数量
        $like_total = 0;  // 点赞总数
        $commont_ok_total = 0; // 评论审核通过数
        $commont_no_total = 0; // 评论审核驳回数
        $commont_ing_total = 0; // 评论待审核数

        // 如果主贴已审核通过
        if ($data['audit_state'] == self::AUDIT_OK) {

            // 查询帖子点赞总数
            $like_total = $this->_d_like->count_by_conds(['cid' => $data['id']]);
            // 查询评论审核通过数
            $commont_ok_total = $this->_d->count_by_conds(['pid' => $data['id'], 'audit_state' => self::AUDIT_OK]);
            // 查询评论审核驳回数
            $commont_no_total = $this->_d->count_by_conds(['pid' => $data['id'], 'audit_state' => self::AUDIT_NO]);
            // 查询评论待审核数
            $commont_ing_total = $this->_d->count_by_conds([
                'pid' => $data['id'],
                'audit_state' => self::AUDIT_ING
            ]);
        }

        $data['id'] = intval($data['id']);
        $data['audit_state'] = intval($data['audit_state']);
        // 给额外参数赋值
        $data['like_total'] = $like_total;
        $data['commont_ok_total'] = $commont_ok_total;
        $data['commont_no_total'] = $commont_no_total;
        $data['commont_ing_total'] = $commont_ing_total;
        $data['content'] = $this->Enter($data['content']);


        // 删除多余数据
        unset(
            $data['pid'],
            $data['audit_type'],
            $data['uid'],
            $data['is_attach'],
            $data['audit_uid'],
            $data['domain'],
            $data['status'],
            $data['updated'],
            $data['deleted']

        );

        return $data;
    }

    /*
    * 【微信端】发布朋友圈验证数据是否合法
    * @param array $params
    *                  + String content 发布内容
    *                  + Array images  图片列表
    *                              + String atId 附件ID
    *                              + String atFilename 附件名称
    *                              + String atFilesize 附件大小
    *                              + String uid 当前用户UID
    * @return bool
    */
    public function publish_validate($params = [], $uid = '')
    {
        // 如果是外部人员
        if (empty($uid)) {

            E('_EMPTY_MEM_CIRCLE');
        }

        // 是否匿名
        if (isset($params['is_anonymous']) && (!$params['is_anonymous'] || !in_array($params['is_anonymous'], [self::ANONYMOUS_YES, self::ANONYMOUS_NO]))) {

            E('_ERR_ANONYMOUS_NO');
        }

        // 是否允许匿名
        $settingData = Config::instance()->getCacheData();
        if (self::ADMIN_ANONYMOUS_CLOSE == $settingData['anonymous'] && self::ANONYMOUS_YES == $params['is_anonymous']) {

            E('_ERR_ADMIN_ANONYMOUS_CLOSE');
        }

        $content = raddslashes($params['content']);
        // 如果内容为空
        if (empty($content)) {

            E('_EMPTY_CONTENT');
        }

        // 如果内容存在且字段内容大于1000个字
        if (!empty($content) && get_str_len($content) > self::FONT_CIRCLE_LENGTH) {

            E('_ERR_CONTENT_MAX');
        }

        // 如果存在图片且最大个数大于指定个数
        if (!empty($params['images']) && count(array_column($params['images'], 'atId')) > self::AT_MAX_MUN) {

            E('_ERR_IMG_MAX_MUN');
        }

        return true;
    }

    /**
     * 【微信端】 发布朋友圈
     *
     * @param array $params
     *                  + String content 发布内容
     *                  + Array images  图片列表
     *                              + String atId 附件ID
     *                              + String atFilename 附件名称
     *                              + String atFilesize 附件大小
     * @param Array $user 用户信息
     * @param String $release 是否开启话题审核
     *
     * @return array|bool
     */
    public function insert_data($params = [], $user = [], $release = '')
    {

        // 积分返回数据
        $circle_data = [];

        try {
            $this->start_trans();
            // 重新组装数据
            $data = [
                'pid' => isset($params['pid']) ? $params['pid'] : 0,
                'type' => isset($params['type']) ? $params['type'] : Constant::CIRCLE_NOTE_TYPE,
                'sc_id' => isset($params['sc_id']) ? $params['sc_id'] : 0,
                'uid' => $user['memUid'],
                'username' => $user['memUsername'],
                'content' => $params['content'],
                'is_attach' => !empty($params['images']) ? CircleModel::ATTACH : CircleModel::NOT_ATTACH,
                'is_anonymous' => isset($params['is_anonymous']) ? $params['is_anonymous'] : self::ANONYMOUS_NO
            ];

            // 如果未开启审核
            if (empty($release)) {

                $data = array_merge($data, [
                    'audit_state' => self::AUDIT_OK,
                    'audit_time' => MILLI_TIME,
                    'audit_type' => self::AUDIT_SYSTEM_TYPE
                ]);
            }

            // 写入数据到朋友圈
            $id = $this->_d->insert($data);

            // 附件数据初始化
            $att_data = [];
            // 遍历图片数组
            foreach ($params['images'] as $key => $v) {
                // 组装附件数据
                $att_data[] = [
                    'cid' => $id,
                    'atid' => $v['atId']
                ];
            }

            // 插入多条数据到附件表
            $this->_d_att->insert_all($att_data);

            $this->commit();
        } catch (\Think\Exception $e) {
            \Think\Log::record($e);
            // 事务回滚
            $this->_set_error($e->getMessage(), $e->getCode());
            $this->rollback();

            return false;
        } catch (\Exception $e) {

            \Think\Log::record($e);
            $this->_set_error($e->getMessage(), $e->getCode());
            // 事务回滚
            $this->rollback();

            return false;
        }

        // 组装发送消息数据
        $msg_data = [
            'uids' => [
                ['memID' => $user['memUid']]
            ],
            'id' => $id,
            'description' => $params['content']
        ];

        // 未开启审核功能
        if (empty($release)) {
            // 查询条件
            $condition = ['uid' => $user['memUid']];

            // 统计话题数
            $total = $this->_d_count->count_by_conds($condition);

            if (empty($total)) {

                $this->_d_count->insert($condition);
            }

            // 更新话题数
            $this->_d_count->update_by_total($user['memUid'], CountModel::CIRCLE_TOTAL);
            // 发布积分
            $circle_data = $this->push_circle_total($id, $user['memUid']);
        } else {
            // 默认帖子类型
            $msg_type = self::MSG_CIRCLE_PUBLISH;

            // 回帖类型
            if (Constant::CIRCLE_REPLIES_TOPIC_TYPE == $params['type']) {
                $msg_type = self::MSG_REPLIES_PUBLISH;
            }
            // 发送消息
            $this->send_msg($msg_data, $msg_type);
        }

        $list = $this->msg_list($circle_data);

        return [
            'id' => $id,
            'data' => $list
        ];
    }

    /**
     * 【微信端】格式化帖子列表
     *
     * @param array $data 列表数据
     * @param string $uid 当前用户UID
     * @param int $type 类型 默认帖子 =0 话题=1
     * @return array
     */
    public function circle_list_format($data = [], $uid = '')
    {
        // 实例化
        $list = [];
        if (empty($data)) {

            return $list;
        }

        // 取出列表的用户ID集合
        $uids = array_column($data, 'uid');

        // 查询用户集合数据
        $member = new User(Service::instance());
        $user_list = $member->listByConds(['memUids' => $uids], 1, count($uids));

        // 获取已查询到UID列表
        $uid_list = array_column($user_list['list'], 'memUid');
        // 获取全部用户列表
        $this->user_list($user_list['list'], $uids, $uid_list);
        $user_data = array_column($user_list['list'], null, 'memUid');

        $ids = array_column($data, 'id');

        // 获取点赞总数
        $like_data = $this->_d_like->get_like_total($ids);
        $like_data = array_column($like_data, null, 'cid');

        // 获取通过审核评论数
        $comment_ok_list = $this->_d->get_comment_num($ids, self::AUDIT_OK);
        $comment_ok_data = array_column($comment_ok_list, null, 'pid');

        // 获取当前用户点过赞的列表
        $like_list = $this->_d_like->list_by_conds(['uid' => $uid]);
        // 当前用户点过赞的ID
        $my_likes = array_unique(array_column($like_list, 'cid'));

        // 获取所有附件列表
        $att_all_list = $this->_d_att->list_by_conds(['cid' => $ids]);
        // 获取图片列表
        $images = $this->format_att_images($att_all_list);

        // 实例化配置表
        $configClass = new Config();
        $setting = $configClass->getCacheData();
        // 获取场景列表
        $scene_list = [];
        if (!empty($setting['scene_list'])) {
            $scene_list = array_column($setting['scene_list'], null, 'sc_id');
        }

        // 遍历数据
        foreach ($data as $v) {

            $list[] = [
                'id' => intval($v['id']),
                'content' => $this->Enter($v['content']),
                'title' => $v['title'],
                'sc_title' => $scene_list ? strval($scene_list[$v['sc_id']]['title']) : '',
                'uid' => strval($v['uid']),
                'username' => strval($user_data[$v['uid']]['memUsername']),
                'avatar' => strval($user_data[$v['uid']]['memFace']),
                'is_anonymous' => intval($v['is_anonymous']),
                'cover_url' => $v['cover_id'] ? imgUrlReal($v['cover_id']) : '',
                'like_total' => intval($like_data[$v['id']]['total']),
                'comment_total' => intval($comment_ok_data[$v['id']]['total']),
                'is_del' => $uid != $v['uid'] ? self::UN_DEL : self::DEL,
                'is_like' => in_array($v['id'], $my_likes) ? self::LIKE : self::UN_LIKE,
                'images' => !empty($images[$v['id']]) ? $images[$v['id']] : [],
                'created' => !empty($v['audit_time']) ? $this->get_time($v['audit_time']) : $this->get_time($v['created'])
            ];
        }

        return $list;
    }

    /**
     * 【微信端】 格式化前端话题详情
     *
     * @param array $data 详情数据
     * @param string $uid 当前用户UID
     *
     * @return array
     */
    public function format_info($data = [], $uid = '')
    {

        // 初始化详情
        $info = [];

        if (empty($data)) {

            return $info;
        }

        // 查询用户集合数据
        $user = User::instance();
        $user_info = $user->getByUid($data['uid']);

        // 获取所有附件列表
        $att_list = $this->_d_att->list_by_conds(['cid' => $data['id']]);
        // 获取图片列表
        $images = $this->format_att_images($att_list);

        // 查看当前用户是否点赞过
        $like_total = $this->_d_like->count_by_conds(['uid' => $uid, 'cid' => $data['id']]);

        // 排序参数
        $order_by = ['created' => 'DESC'];
        // 获取当前点赞列表
        $like_list = $this->_d_like->list_by_conds(['cid' => $data['id']], self::DEFAULT_LIMIT, $order_by);

        // 初始化点赞列表
        $mem_users = [];
        // 如果有人点赞
        if (!empty($like_list)) {
            // 获取点赞人员UIDS
            $mem_uids = array_unique(array_filter(array_column($like_list, 'uid')));
            // 格式化人员列表
            $mem_list = $this->format_user($mem_uids);

            // 获取点赞列表
            foreach ($like_list as $v) {

                $mem_users[] = [
                    'uid' => strval($v['uid']),
                    'username' => strval($mem_list[$v['uid']]['username']),
                    'avatar' => strval($mem_list[$v['uid']]['avatar'])
                ];
            }
        }

        // 获取收藏状态 xtong 2017年06月02日
        $url = rpcUrl('/Public/Rpc/Collection/CollectionStatus');

        $params = [
            'uid' => $uid,
            'app' => 'workmate',
            'dataId' => $data['id']
        ];
        $res = \Com\Rpc::phprpc($url)->invoke('Index', $params);

        // 场景数据
        $setting = Config::instance()->getCacheData();
        $scene_list = array_column($setting['scene_list'], null, 'sc_id');
        // 场景
        $sc_title = !empty($scene_list[$data['sc_id']]) ? $scene_list[$data['sc_id']]['title'] : '';

        // 组装详情
        $info = [
            'id' => intval($data['id']),
            'content' => $this->Enter($data['content']),
            'sc_id' => rintval($data['sc_id']),
            'sc_title' => $sc_title,
            'uid' => strval($data['uid']),
            'username' => strval($user_info['memUsername']),
            'is_anonymous' => intval($data['is_anonymous']),
            'avatar' => strval($user_info['memFace']),
            'like_total' => intval($this->_d_like->count_by_conds(['cid' => $data['id']], self::DEFAULT_LIMIT)),
            'like_list' => $mem_users,
            'is_del' => $uid != $data['uid'] ? self::UN_DEL : self::DEL,
            'is_like' => $like_total ? self::LIKE : self::UN_LIKE,
            'images' => !empty($images) ? $images[$data['id']] : [],
            'created' => !empty($data['audit_time']) ? $this->get_time($data['audit_time']) : $this->get_time($data['created']),
            'is_collect' => json_decode($res, true)['collection'] ? rintval(json_decode($res, true)['collection']) : 0,
            'comment_anonymous' => rintval($data['comment_anonymous']),
            'replies_status' => intval($data['audit_state']),
            'audit_name' => strval($data['audit_uname']),
            'audit_time' => intval($data['audit_time']),
        ];

        return $info;
    }

    /**
     * 【微信端】 获取评论列表
     *
     * @param array $conditions 查询条件
     * @param array $page_option 分页参数
     * @param array $order_by 排序字段
     *
     * @return mixed
     */
    public function list_by_comment($conditions = [], $page_option = [], $order_by = [])
    {

        // 如果没有话题ID
        if (empty($conditions['pid'])) {

            return [];
        }

        return $this->_d->list_by_comment($conditions, $page_option, $order_by);
    }

    /**
     * 【微信端】 格式化前端回帖列表
     *
     * @param array $data 列表数据
     * @param string $uid 当前用户UID
     *
     * @return array
     */
    public function replies_list_format($data = [], $uid = '')
    {
        // 实例化
        $list = [];
        if (empty($data)) {

            return $list;
        }

        // 取出列表的用户ID集合
        $uids = array_column($data, 'uid');

        // 查询用户集合数据
        $member = new User(Service::instance());
        $user_list = $member->listByConds(['memUids' => $uids], 1, count($uids));

        // 获取已查询到UID列表
        $uid_list = array_column($user_list['list'], 'memUid');
        // 获取全部用户列表
        $this->user_list($user_list['list'], $uids, $uid_list);
        $user_data = array_column($user_list['list'], null, 'memUid');

        $ids = array_column($data, 'id');

        // 获取点赞总数
        $like_data = $this->_d_like->get_like_total($ids);
        $like_data = array_column($like_data, null, 'cid');

        // 获取当前用户点过赞的列表
        $like_list = $this->_d_like->list_by_conds(['uid' => $uid]);
        // 当前用户点过赞的ID
        $my_likes = array_unique(array_column($like_list, 'cid'));

        // 场景数据
        $setting = Config::instance()->getCacheData();
        $scene_list = array_column($setting['scene_list'], null, 'sc_id');

        // 遍历数据
        foreach ($data as $v) {
            // 评论数
            $comment_total = $this->_d->count_by_conds(['pid' => $v['id'], 'type' => [Constant::CIRCLE_NOTE_COMMENT, Constant::CIRCLE_COMMENT_TOPIC_TYPE], 'audit_state' => self::AUDIT_OK]);
            // 场景
            $sc_title = !empty($scene_list[$v['sc_id']]) ? $scene_list[$v['sc_id']]['title'] : '';

            // 附件列表
            $att_list = $this->_d_att->list_by_conds(['cid' => $v['id']]);
            // 获取图片列表
            $images = $this->format_att_images($att_list);

            // 匿名评论
            if (self::ANONYMOUS_YES == $v['is_anonymous']) {
                $username = '';
                $avatar = '';
            } else {
                $username = strval($user_data[$v['uid']]['memUsername']);
                $avatar = strval($user_data[$v['uid']]['memFace']);
            }

            $list[] = [
                'id' => intval($v['id']),
                'sc_id' => rintval($v['sc_id']),
                'sc_title' => $sc_title,
                'uid' => strval($v['uid']),
                'username' => $username,
                'avatar' => $avatar,
                'user_sex' => $user_data[$v['uid']]['memGender'],
                'is_anonymous' => rintval($v['is_anonymous']),
                'content' => $this->Enter($v['content']),
                'like_total' => intval($like_data[$v['id']]['total']),
                'comment_total' => rintval($comment_total),
                'is_del' => $uid != $v['uid'] ? self::UN_DEL : self::DEL,
                'is_like' => in_array($v['id'], $my_likes) ? self::LIKE : self::UN_LIKE,
                'images' => !empty($images) ? $images[$v['id']] : [],
                'created' => !empty($v['audit_time']) ? $this->get_time($v['audit_time']) : $this->get_time($v['created'])
            ];
        }

        return $list;
    }

    /**
     * 【微信端】 格式化前端评论列表
     *
     * @param array $data 列表数据
     * @param string $uid 当前用户UID
     *
     * @return array
     */
    public function commont_list_format($data = [], $uid = '')
    {
        // 实例化
        $list = [];
        if (empty($data)) {

            return $list;
        }

        // 取出列表的用户ID集合
        $uids = array_column($data, 'uid');

        // 查询用户集合数据
        $member = new User(Service::instance());
        $user_list = $member->listByConds(['memUids' => $uids], 1, count($uids));

        // 获取已查询到UID列表
        $uid_list = array_column($user_list['list'], 'memUid');
        // 获取全部用户列表
        $this->user_list($user_list['list'], $uids, $uid_list);
        $user_data = array_column($user_list['list'], null, 'memUid');

        // 获取当前用户点过赞的列表
        $like_list = $this->_d_like->list_by_conds(['uid' => $uid]);
        // 当前用户点过赞的ID
        $my_likes = array_unique(array_column($like_list, 'cid'));

        // 遍历数据
        foreach ($data as $v) {

            // 匿名评论
            if (self::ANONYMOUS_YES == $v['is_anonymous']) {
                $username = '';
                $avatar = '';
            } else {
                $username = strval($user_data[$v['uid']]['memUsername']);
                $avatar = strval($user_data[$v['uid']]['memFace']);
            }

            $list[] = [
                'id' => intval($v['id']),
                'uid' => strval($v['uid']),
                'username' => $username,
                'avatar' => $avatar,
                'user_sex' => $user_data[$v['uid']]['memGender'],
                'is_anonymous' => rintval($v['is_anonymous']),
                'content' => $this->Enter($v['content']),
                'like_total' => intval($v['like_total']),
                'is_del' => $uid != $v['uid'] ? self::UN_DEL : self::DEL,
                'is_like' => in_array($v['id'], $my_likes) ? self::LIKE : self::UN_LIKE,
                'created' => !empty($v['audit_time']) ? $this->get_time($v['audit_time']) : $this->get_time($v['created'])
            ];
        }

        return $list;
    }

    /**
     * 【微信端】 格式化我的朋友圈详情
     *
     * @param array $data 详情数据
     *
     * @return array
     */
    public function format_my_circle($data = [])
    {

        // 初始化详情
        $info = [];

        if (empty($data)) {

            return $info;
        }

        // 查询用户集合数据
        $user = User::instance();
        $user_info = $user->getByUid($data['uid']);

        // 获取所有附件列表
        $att_list = $this->_d_att->list_by_conds(['cid' => $data['id']]);

        // 获取图片列表
        $images = $this->format_att_images($att_list);

        // 处理在开启审核装换为关闭审核的状态时停留的页面刷新无审核人情况
        $audit_name = $data['audit_uname'];
        $audit_time = $data['audit_time'];
        if (self::AUDIT_OK == $data['audit_state'] && empty($audit_name)) {
            $audit_name = '已被系统审核';
            $audit_time = MILLI_TIME;
        }

        // 组装详情
        $info = [
            'content' => $this->Enter($data['content']),
            'uid' => strval($data['uid']),
            'username' => strval($user_info['memUsername']),
            'avatar' => strval($user_info['memFace']),
            'images' => !empty($images) ? $images[$data['id']] : [],
            'created' => $this->get_time($data['created']),
            'circle_status' => intval($data['audit_state']),
            'audit_name' => $audit_name,
            'audit_time' => $audit_time,
            'type' => intval($data['type'])
        ];

        return $info;
    }

    /**
     * 【微信端】删除评论
     *
     * @param string $id 评论或者话题ID
     * @param string $uid 当前用户UID
     *
     * @return bool
     */
    public function del_comment($id = '', $uid = '')
    {

        // 如果ID为空
        if (empty($id)) {

            $this->_set_error('_EMPTY_COMMENT_ID');

            return false;
        }

        // 获取当前是否可以删除
        $info = $this->_d->get_by_conds(
            [
                'id' => $id,
                'pid > ?' => CircleModel::CIRCLE_PID
            ]
        );

        // 如果信息不存在
        if (!$info) {

            $this->_set_error('_EMPTY_ID_INFO');

            return false;
        }

        // 如果信息没有权限
        if ($info['uid'] != $uid) {

            $this->_set_error('_ERR_ID_NOT_AUTH_DEL');

            return false;
        }

        // 删除评论
        $this->_d->delete($id);

        return true;
    }

    /**
     * 【微信端】删除话题
     *
     * @param string $id 评论或者话题ID
     * @param string $uid 当前用户UID
     *
     * @return bool
     */
    public function del_circle($id = '', $uid = '')
    {
        // 如果ID为空
        if (empty($id)) {

            $this->_set_error('_EMPTY_CIRCLE_ID');

            return false;
        }

        // 获取当前是否可以删除
        $info = $this->_d->get($id);

        // 如果信息不存在
        if (!$info) {

            $this->_set_error('_EMPTY_ID_INFO');

            return false;
        }

        // 如果信息没有权限
        if ($info['uid'] != $uid) {

            $this->_set_error('_ERR_ID_NOT_AUTH_DEL');

            return false;
        }

        // 获取需要删除的附件ID
        $del_attach_ids = [];
        if ($info['is_attach']) {
            $del_attach = $this->_d_att->list_by_conds(['cid' => $id], [], [], 'atid');
            $del_attach_ids = array_column($del_attach, 'atid');
        }

        // 话题下的评论IDS集合
        $ids = [];
        // 如果是话题
        if (Constant::CIRCLE_TOPIC_TYPE == $info['type']) {
            // 获取话题回帖IDS
            $list = $this->_d->get_by_conds(['pid' => $id]);
            $ids = array_column($list, 'id');
        }

        // 删除话题
        try {

            // 开始事务
            $this->_d->start_trans();

            // 删除话题
            $this->_d->delete($id);

            // 删除评论
            $this->_d->delete_by_conds(['pid' => $id]);

            // 删除话题下回帖的评论
            if (!empty($ids)) {
                $this->_d->delete_by_conds(['pid' => $ids]);
            }

            // 删除附件表数据
            $this->_d_att->delete_by_conds(['cid' => $id]);

            // 删除点赞
            $this->_d_like->delete_by_conds(['cid' => $id]);

            // 提交事务
            $this->_d->commit();

        } catch (\Think\Exception $e) {
            \Think\Log::record($e);
            // 事务回滚
            $this->_set_error($e->getMessage(), $e->getCode());
            $this->_d->rollback();

            return false;

        } catch (\Exception $e) {

            \Think\Log::record($e);
            $this->_set_error($e->getMessage(), $e->getCode());
            // 事务回滚
            $this->_d->rollback();

            return false;
        }

        // 从UC服务器删除附件文件
        if (!empty($del_attach_ids)) {

            $attach_serv = new AttachOperation();
            $attach_serv->delete_attach(
                APP_DIR,
                'circle',
                [$id]
            );
        }

        return true;
    }

    /**
     * 【微信端】发布评论
     *
     * @param array $params
     *                  + string pid 话题ID
     *                  + string content 评论内容
     * @param array $user 当前用户
     * @param int $comment 是否开启评论审核
     *
     * @return bool|array
     */
    public function push_comment($params = [], $user = [], $comment = '')
    {

        // 初始化消息
        $msg = [];

        // 如果是外部人员
        if (empty($user['memUid'])) {

            E('_EMPTY_MEM_COMMENT');
        }

        // 评论状态
        if (!$params['is_anonymous'] || !in_array($params['is_anonymous'], [self::ANONYMOUS_YES, self::ANONYMOUS_NO])) {

            E('_ERR_COMMENT_ANONYMOUS_ERR');
        }

        // 如果话题ID为空
        if (empty($params['pid'])) {

            E('_EMPTY_ID');
        }

        // 获取话题详情
        $info = $this->_d->get($params['pid']);

        // 详情不存在
        if (empty($info)) {

            E('_EMPTY_CIRCLE_INFO');
        }

        // 是否允许匿名
        $settingData = Config::instance()->getCacheData();

        if (self::ADMIN_ANONYMOUS_CLOSE == $settingData['anonymous_comment'] && self::ANONYMOUS_YES == $params['is_anonymous']) {

            E('_ERR_ADMIN_ANONYMOUS_CLOSE');
        }

        // 去除html标签以及换行标签
        $content = strip_tags($params['content']);

        // 如果内容为空
        if (empty($content)) {

            E('_EMPTY_COMMENT_CONTENT');
        }

        // 组装数组
        $data = [
            'pid' => $params['pid'],
            'uid' => $user['memUid'],
            'type' => isset($params['type']) ? $params['type'] : Constant::CIRCLE_NOTE_TYPE,
            'content' => $content,
            'username' => $user['memUsername'],
            'is_anonymous' => $params['is_anonymous']
        ];

        // 如果未开启评论审核
        if (empty($comment)) {

            $data = array_merge($data,
                [
                    'audit_state' => self::AUDIT_OK,
                    'audit_time' => MILLI_TIME,
                    'audit_type' => self::AUDIT_SYSTEM_TYPE
                ]);
        }

        // 写入评论
        $comment_id = $this->_d->insert($data);

        // 组装发送消息数据
        $msg_data = [
            'uids' => [
                ['memID' => $user['memUid']]
            ],
            'id' => $comment_id,
            'description' => $params['content']
        ];

        // 如果未开启评论审核
        if (empty($comment)) {
            // 更新话题统计数据
            $this->update_comment_total($info, $user);

            // 组装给发起人发送消息数据
            $msg_circle_data = [
                'uids' => [
                    ['memID' => $info['uid']]
                ],
                'id' => $params['pid'],
                'description' => $params['content'],
                'name' => $user['memUsername']
            ];

            // 添加积分
            $msg = $this->integral($info, $user['memUid']);

            // 如果是匿名评论
            if (self::ANONYMOUS_YES == $params['is_anonymous']) {
                $msg_circle_data['name'] = Constant::SETTING_ANONYMOUS_NAME;
            }

            // 帖子的评论
            $msg_type = self::MSG_COMMENT;
            // 话题回帖的评论
            if ($params['type'] == Constant::CIRCLE_COMMENT_TOPIC_TYPE) {
                $msg_type = self::MSG_TOPIC_COMMENT;
            }

            // 给发布话题人发送消息
            $this->send_msg($msg_circle_data, $msg_type);
        } else {
            // 默认帖子的评论
            $msg_type = self::MSG_COMMENT_PUBLISH;
            // 回帖类型
            if ($params['type'] == Constant::CIRCLE_COMMENT_TOPIC_TYPE) {
                $msg_type = self::MSG_REPLIES_COMMENT_PUBLISH;
            }

            // 给评论人发送消息
            $this->send_msg($msg_data, $msg_type);
        }

        $list = $this->msg_list($msg);

        return [
            'id' => $comment_id,
            'data' => $list
        ];
    }

    /**
     * 更新话题被回复个数以及次数
     *
     * @param array $info 详情
     * @param array $user 用户信息
     *
     * @return bool
     */
    public function update_comment_total($info = [], $user = [])
    {

        // 话题被回复
        if ($info['pid'] == CircleModel::CIRCLE_PID) {

            // 拼接发布人是否评论的条件
            $replies = [
                'uid' => $info['uid']
            ];

            // 发布人是否评论过
            $replies_total = $this->_d_count->count_by_conds($replies);

            // 如果没有评论过
            if (empty($replies_total)) {

                $this->_d_count->insert($replies);
            }

            // 统计条件
            $reply_cond = [
                'pid' => $info['id'],
                'uid' => $info['uid'],
                'type' => self::CIRCLE_REPLY_TYPE
            ];

            // 话题被回复写入记录
            $this->_d_history->insert($reply_cond);

            // 更新话题被回复次数
            $this->_d_count->update_by_total($info['uid'], CountModel::REPLIES_TOTAL);

            // 拼接评论人是否评论的条件
            $reply = [
                'uid' => $user['memUid']
            ];

            // 评论人是否评论过
            $reply_total = $this->_d_count->count_by_conds($reply);

            // 如果没有评论过
            if (empty($reply_total)) {

                $this->_d_count->insert($reply);
            }

            $restore_cond = [
                'pid' => $info['id'],
                'uid' => $user['memUid'],
                'type' => self::CIRCLE_RESTORE_TYPE,
                'post_man' => $info['uid']
            ];

            // 查询回复话题数
            $restore_total = $this->_d_history->count_by_conds($restore_cond);

            // 如果回复个数等于1则更新
            if (empty($restore_total)) {

                // 更新回复话题个数
                $this->_d_count->update_by_total($user['memUid'], CountModel::REPLY_NUM);
            }

            // 写入回复话题记录
            $this->_d_history->insert($restore_cond);

            // 更新回复话题次数
            $this->_d_count->update_by_total($user['memUid'], CountModel::REPLY_TOTAL);
        }

        return true;
    }

    /**
     * 【微信端】获取评论列表
     *
     * @param array $params
     *                  + string limit 每页条少条
     *                  + string page 当前第几页
     *                  + string pid 话题ID
     * @param array $uid 当前用户UID
     *
     * @return array
     */
    public function get_comment_list($params = [], $uid = '', $type = Constant::CIRCLE_REPLIES_TOPIC_TYPE)
    {

        // 每页条数
        $params['limit'] = empty($params['limit']) ? self::DEFAULT_LIMIT : (int)$params['limit'];
        $params['page'] = empty($params['page']) ? 1 : $params['page'];
        list($start, $limit, $page) = page_limit($params['page'], $params['limit']);

        // 初始化查询条件
        $conditions = [
            'pid' => $params['id'],
            'audit_state' => self::AUDIT_OK,
            'type' => $type
        ];
        // 评论总数
        $total = $this->_d->count_by_conds($conditions);

        $list = [];
        if ($total) {
            // 分页参数
            $page_option = [$start, $limit];
            // 评论列表
            $data = $this->_d->list_by_comment($conditions, $page_option, [], 'id,content,type,sc_id,uid,created,username,audit_time,is_anonymous');

            // 回帖
            if (Constant::CIRCLE_REPLIES_TOPIC_TYPE == $type) {
                // 格式化回帖列表
                $list = $this->replies_list_format($data, $uid);
            } elseif (Constant::CIRCLE_COMMENT_TOPIC_TYPE == $type) { // 话题评论
                // 格式化评论列表
                $list = $this->commont_list_format($data, $uid);
            } elseif (Constant::CIRCLE_NOTE_COMMENT == $type) {       //帖子评论
                // 格式化评论列表
                $list = $this->commont_list_format($data, $uid);
            }
        }

        return [
            'total' => intval($total),
            'limit' => intval($limit),
            'page' => intval($page),
            'list' => $list
        ];
    }

    /**
     * 【后台】获取评论列表
     *
     * @param array $params
     *                  + string limit 每页条少条
     *                  + string page 当前第几页
     *                  + string pid 话题ID
     *                  + string audit_state 评论状态
     *
     * @return array
     */
    public function get_comment_admin_list($params = [])
    {

        // 每页条数
        $params['limit'] = empty($params['limit']) ? self::DEFAULT_LIMIT : (int)$params['limit'];
        $params['page'] = empty($params['page']) ? 1 : $params['page'];

        list($start, $limit, $page) = page_limit($params['page'], $params['limit']);

        // 分页参数
        $page_option = [
            $start,
            $limit,
        ];

        // 初始化查询条件
        $conditions = [
            'pid' => $params['id'],
            'audit_state' => $params['audit_state']
        ];

        // 获取评论总数
        $total = $this->_d->count_by_conds($conditions);

        // 获取评论列表
        $list = [];
        if ($total > 0) {

            $data = $this->_d->list_by_comment($conditions, $page_option, [],
                'id,content,is_anonymous,uid,audit_state,audit_time,audit_uname,audit_uid,username,created');

            // 取出列表的用户ID集合
            $uids = array_column($data, 'uid');

            // 查询用户集合数据
            $member = new User(Service::instance());
            $user_list = $member->listByConds(['memUids' => $uids], 1, count($uids));

            // 获取已查询到UID列表
            $uid_list = array_column($user_list['list'], 'memUid');

            // 将用户数据转换成以用户ID为key的二维数组
            $user_data = array_combine_by_key($user_list['list'], 'memUid');

            // 获取全部用户列表
            $this->user_list($user_list['list'], $uids, $uid_list);

            // 遍历数据
            foreach ($data as $key => $v) {

                $array = [
                    'id' => intval($v['id']),
                    'content' => $this->Enter($v['content']),
                    'username' => strval($user_data[$v['uid']]['memUsername']),
                    'avatar' => strval($user_data[$v['uid']]['memFace']),
                    'audit_state' => intval($v['audit_state']),
                    'audit_time' => strval($v['audit_time']),
                    'audit_uname' => strval($v['audit_uname']),
                    'audit_uid' => strval($v['audit_uid']),
                    'created' => $v['created'],
                    'like_total' => intval($v['like_total']),
                    'is_anonymous' => $v['is_anonymous'],
                    'user_sex' => $user_data[$v['uid']]['memGender']
                ];

                // 为匿名评论时
                if (self::ANONYMOUS_YES == $array['is_anonymous']) {
                    $array['username'] = '';
                    $array['avatar'] = '';
                }

                $list[] = $array;
            }
        }

        return [
            'total' => intval($total),
            'limit' => intval($limit),
            'page' => intval($page),
            'list' => $list,
        ];
    }

    /**
     * 【后台】获取话题评论列表
     *
     * @param array $params
     *                  + string limit 每页条少条
     *                  + string page 当前第几页
     *                  + string pid 话题ID
     *                  + string audit_state 评论状态
     *
     * @return array
     */
    public function get_topic_comment_admin_list($params = [])
    {

        // 每页条数
        $params['limit'] = empty($params['limit']) ? self::DEFAULT_LIMIT : (int)$params['limit'];
        $params['page'] = empty($params['page']) ? 1 : $params['page'];

        list($start, $limit, $page) = page_limit($params['page'], $params['limit']);

        // 分页参数
        $page_option = [
            $start,
            $limit,
        ];

        // 初始化查询条件
        $conditions = [
            'pid' => $params['id'],
            'audit_state' => $params['audit_state'],
            'type' => Constant::CIRCLE_REPLIES_TOPIC_TYPE
        ];

        // 获取评论总数
        $total = $this->_d->count_by_conds($conditions);

        // 获取评论列表
        $list = [];
        if ($total > 0) {

            $data = $this->_d->list_by_comment($conditions, $page_option, [],
                'id,content,is_anonymous,uid,audit_state,audit_time,audit_uname,audit_uid,username,is_attach,sc_id,created');

            // 取出列表的用户ID集合
            $uids = array_column($data, 'uid');

            // 查询用户集合数据
            $member = new User(Service::instance());
            $user_list = $member->listByConds(['memUids' => $uids], 1, count($uids));

            // 获取已查询到UID列表
            $uid_list = array_column($user_list['list'], 'memUid');

            // 将用户数据转换成以用户ID为key的二维数组
            $user_data = array_combine_by_key($user_list['list'], 'memUid');

            // 获取全部用户列表
            $this->user_list($user_list['list'], $uids, $uid_list);

            // 获取回帖附件集合
            $attrModel = new AttachmentModel();
            $attrData = $attrModel->list_by_conds(['cid' => array_column($data, 'id')]);
            $newAttrData = [];
            foreach ($attrData as $key => $value) {
                $newAttrData[$value['cid']][]['url'] = imgUrl($value['atid']);
            }

            // 场景
            $sceneModel = new SceneModel();
            $sceneData = $sceneModel->list_by_conds(['sc_id' => array_column($data, 'sc_id')]);
            $sceneData = array_column($sceneData, 'title', 'sc_id');

            // 遍历数据
            foreach ($data as $key => $v) {

                $array = [
                    'id' => intval($v['id']),
                    'content' => $this->Enter($v['content']),
                    'username' => strval($user_data[$v['uid']]['memUsername']),
                    'avatar' => strval($user_data[$v['uid']]['memFace']),
                    'audit_state' => intval($v['audit_state']),
                    'audit_time' => strval($v['audit_time']),
                    'audit_uname' => strval($v['audit_uname']),
                    'audit_uid' => strval($v['audit_uid']),
                    'created' => $v['created'],
                    'like_total' => intval($v['like_total']),
                    'is_anonymous' => $v['is_anonymous'],
                    'user_sex' => $user_data[$v['uid']]['memGender'],
                    'images' => $newAttrData[$v['id']] ?? [],
                    'sc_id' => $v['sc_id'],
                    'sc_values' => $sceneData[$v['sc_id']] ?? '',
                    'department' => implode(';', array_column($user_data[$v['uid']]['dpName'], 'dpName'))
                ];

                // 为匿名评论时
                if (self::ANONYMOUS_YES == $array['is_anonymous']) {
                    $array['username'] = '';
                    $array['avatar'] = '';
                }

                $list[] = $array;
            }
        }

        return [
            'total' => intval($total),
            'limit' => intval($limit),
            'page' => intval($page),
            'list' => $list,
        ];
    }

    /**
     * 【微信端】获取话题列表
     *
     * @param array $params
     *                  + string limit 每页条少条
     *                  + string page 当前第几页
     * @param array $uid 当前用户UID
     * @return array
     */
    public function get_circle_list($params = [], $uid = '')
    {

        // 每页条数
        $params['limit'] = empty($params['limit']) ? self::DEFAULT_LIMIT : (int)$params['limit'];
        $params['page'] = empty($params['page']) ? 1 : $params['page'];
        list($start, $limit, $page) = page_limit($params['page'], $params['limit']);

        // 初始化查询条件
        $conditions = [
            'pid' => CircleModel::CIRCLE_PID,
            'audit_state' => self::AUDIT_OK,
            'type' => Constant::CIRCLE_NOTE_TYPE
        ];

        // 用户ID，如果不为空查询"我的帖子"数据
        if (isset($params['uid']) && $params['uid']) {

            $conditions['uid'] = $params['uid'];
        }

        // 获取帖子总数
        $total = $this->_d->count_by_conds($conditions);

        $list = [];
        if ($total) {
            // 分页参数
            $page_option = [$start, $limit];
            // 排序参数
            $order_by = ['audit_time' => 'DESC'];

            // 获取帖子列表
            $data = $this->_d->list_by_conds($conditions, $page_option, $order_by);
            // 格式化数据
            $list = $this->replies_list_format($data, $uid);
        }

        return [
            'total' => intval($total),
            'limit' => intval($limit),
            'page' => intval($page),
            'list' => $list
        ];
    }

    /**
     * 【微信端】我发布的话题列表
     *
     * @param array $params
     *                  + string limit 每页条少条
     *                  + string page 当前第几页
     * @param array $user 当前用户信息
     * @return array
     */
    public function my_topic_list($params = [], $user = [])
    {

        // 每页条数
        $params['limit'] = empty($params['limit']) ? self::DEFAULT_LIMIT : (int)$params['limit'];
        $params['page'] = empty($params['page']) ? 1 : $params['page'];
        list($start, $limit, $page) = page_limit($params['page'], $params['limit']);

        // 分页参数
        $page_option = [
            $start,
            $limit,
        ];


        // 排序参数
        $order_by = [
            'audit_time' => 'DESC'
        ];

        // 初始化查询条件
        $conditions = [
            'pid' => CircleModel::CIRCLE_PID,
            'audit_state' => self::AUDIT_OK,
            'type' => Constant::CIRCLE_TOPIC_TYPE,
            'uid' => $user['memUid']
        ];

        // 获取话题总数
        $total = $this->_d->count_by_conds($conditions);

        // 获取话题列表
        $data = $this->_d->list_by_conds($conditions, $page_option, $order_by);

        // 格式化数据
        $list = $this->circle_list_format($data, $user['memUid']);

        return [
            'total' => intval($total),
            'limit' => intval($limit),
            'page' => intval($page),
            'list' => $list,
        ];
    }

    /**
     * 【微信端】获取话题列表
     *
     * @param array $params
     *                  + string limit 每页条少条
     *                  + string page 当前第几页
     * @param array $user 当前用户信息
     * @return array
     */
    public function get_topic_list($params = [], $user = [])
    {

        // 每页条数
        $params['limit'] = empty($params['limit']) ? self::DEFAULT_LIMIT : (int)$params['limit'];
        $params['page'] = empty($params['page']) ? 1 : $params['page'];
        list($start, $limit, $page) = page_limit($params['page'], $params['limit']);

        // 分页参数
        $page_option = [
            $start,
            $limit,
        ];

        // 获取用户标签ID
        $tagIds = [];
        $tagsInfo = User::instance()->getTagsByUserId($user['memUid']);
        if (!empty($tagsInfo)) {
            $userTagInfo = isset($tagsInfo['userTagList']) ? array_column($tagsInfo['userTagList'], 'tagId') : [];
            $departTagInfo = isset($tagsInfo['departTagList']) ? array_column($tagsInfo['departTagList'], 'tagId') : [];
            $tagIds = array_unique(array_merge($userTagInfo, $departTagInfo));
        }

        // 获取当前用户所在部门和父级部门IDS集合
        $dp_ids = Help::instance()->get_user_dp_list($user);

        $params_right = [
            'cd_id' => $dp_ids,
            'uid' => $user['memUid'],
            'job' => $user['job']['jobId'],
            'role' => $user['role']['roleId'],
            'tag_id' => $tagIds
        ];

        // 获取权限列表
        $right_list = $this->_d_right->list_topic_by_conds($params_right);

        $circle_ids = [];
        if (!empty($right_list)) {
            $circle_ids = array_unique(array_column($right_list, 'circle_id'));
        }

        // 排序参数
        $order_by = [
            'audit_time' => 'DESC'
        ];

        // 初始化查询条件
        $conditions = [
            'pid' => CircleModel::CIRCLE_PID,
            'audit_state' => self::AUDIT_OK,
            'type' => Constant::CIRCLE_TOPIC_TYPE,
            'id' => $circle_ids
        ];

        // 获取话题总数
        $count = $this->_d->topic_count_by_conds($conditions);

        // 获取话题列表
        $data = $this->_d->topic_list_by_conds($conditions, $page_option, $order_by);

        // 格式化数据
        $list = $this->circle_list_format($data, $user['memUid']);

        return [
            'total' => intval($count['total']),
            'limit' => intval($limit),
            'page' => intval($page),
            'list' => $list,
        ];
    }


    /**
     * 【微信端】获取我的评论详情
     *
     * @param string $c_id 评论ID
     * @param array $user 当前用户信息
     *
     * @return bool|array
     */
    public function get_comment_my_info($c_id = '', $user = [])
    {

        // 如果ID为空
        if (empty($c_id)) {

            $this->_set_error('_EMPTY_COMMENT_ID');

            return false;
        }

        // 获取详情
        $info = $this->_d->get_by_conds(['id' => $c_id, 'pid > ?' => CircleModel::CIRCLE_PID]);

        // 详情不存在
        if (empty($info)) {

            $this->_set_error('_EMPTY_ID_INFO');

            return false;
        }

        return [
            'id' => intval($info['id']),
            'pid' => intval($info['pid']),
            'uid' => strval($info['uid']),
            'username' => strval($info['username']),
            'avatar' => strval($user['memFace']),
            'content' => strval($info['content']),
            'created' => !empty($info['audit_time']) ? $this->get_time($info['audit_time']) : $this->get_time($info['created']),
            'reply_status' => intval($info['audit_state']),
            'audit_name' => strval($info['audit_uname']),
            'audit_time' => intval($info['audit_time']),
        ];
    }

    /**
     * 更新收藏状态
     *
     * @param string $ids 数据ID，逗号分割的字符串
     *
     */
    public function update_collection($ids)
    {

        $url = rpcUrl('/Public/Rpc/Collection/CollectionUpdate');

        $params = [
            'uid' => '',
            'app' => 'workmate',
            'dataId' => $ids
        ];

        $res = \Com\Rpc::phprpc($url)->invoke('Index', $params);

        return $res;
    }

    /**
     * 更新积分
     *
     * @param array $circle_list
     * @param string $uid
     */
    public function integral($circle = [], $uid = '')
    {
        // 发布话题用户记录详情
        $info = $this->_d_count->get_by_conds(['uid' => $circle['uid']]);

        // 话题被评论KEY
        $was_comment_key = 'workmate_' . $circle['id'] . '_' . rand(0, 9999);

        // 话题被评论KEY
        $comment_key = 'workmate_' . $circle['id'] . '_' . rand(0, 9999);

        // 实例积分
        $service = new Integral();

        // 统计条件
        $restore_cond = [
            'pid' => $circle['id'],
            'uid' => $uid,
            'type' => self::CIRCLE_RESTORE_TYPE
        ];

        // 查询回复话题数
        $restore_total = $this->_d_history->count_by_conds($restore_cond);

        // 当前用户的评论话数以及次数
        $reply_info = $this->_d_count->get_by_conds(['uid' => $uid]);

        $was_comment[] = [
            'triggerKey' => 'number',
            'value' => intval($info['replies_total']),
            'remark' => '话题被评论次数'
        ];

        // 初始化
        $comment[] = [
            'triggerKey' => 'number',
            'value' => intval($reply_info['reply_total']),
            'remark' => '评论话题次数'
        ];

        // 话题被评论个数
        if ($restore_total == self::COMMENT_FIRST) {

            // 话题被评论个数
            $conds = [
                'post_man' => $info['uid'],
                'type' => self::CIRCLE_RESTORE_TYPE
            ];
            $list = $this->_d_history->list_by_conds($conds, null, [], 'uid');

            $uids = array_unique(array_column($list, 'uid'));

            $was_comment[] = [
                'triggerKey' => 'was_comment_num',
                'value' => count($uids),
                'remark' => '话题被评论个数'
            ];

            // 话题被评论个数
            $comment[] = [
                'triggerKey' => 'comment_business_num',
                'value' => intval($reply_info['reply_num']),
                'remark' => '评论话题个数'
            ];
        }

        // 话题被评论积分规则
        $Integral_data = [
            'memUid' => $circle['uid'],
            'businessKey' => 'colleague_circle',
            'businessAct' => 'was_comment',
            'businessId' => $was_comment_key,
            'triggerTypes' => $was_comment
        ];

        // 添加积分规则
        $service->integralChange($Integral_data);

        // 评论话题积分规则
        $reply_data = [
            'memUid' => $uid,
            'businessKey' => 'colleague_circle',
            'businessAct' => 'comment',
            'businessId' => $comment_key,
            'triggerTypes' => $comment
        ];

        $msg = $service->integralChange($reply_data);

        // 话题被评论日志数据
        $was_comment = [
            'uid' => $circle['uid'],
            'pid' => $circle['id'],
            'businessId' => $was_comment_key
        ];

        // 话题被评论日志
        $this->_d_log->insert($was_comment);

        // 评论话题日志数据
        $comment = [
            'uid' => $uid,
            'pid' => $circle['id'],
            'businessId' => $comment_key
        ];

        // 评论话题日志
        $this->_d_log->insert($comment);

        return $msg;
    }

    /**
     * 发送统计话题发布规则
     *
     * @param string $id 发布话题ID
     * @param string $uid 发布者UID
     *
     * @return mixed
     */
    public function push_circle_total($id = '', $uid = '')
    {

        // 发布话题KRY
        $push_key = 'workmate_' . $id . '_' . rand(0, 9999);

        // 查询条件
        $condition = ['uid' => $uid];

        // 获取我操作的详情
        $info = $this->_d_count->get_by_conds($condition);

        // 实例积分
        $service = new Integral();

        // 发布话题分规则
        $Integral_data = [
            'memUid' => $uid,
            'businessKey' => 'colleague_circle',
            'businessAct' => 'push',
            'businessId' => $push_key,
            'triggerTypes' => [
                [
                    'triggerKey' => 'number',
                    'value' => intval($info['circle_total']),
                    'remark' => '话题发布次数'
                ]
            ]
        ];

        // 添加积分规则
        $data = $service->integralChange($Integral_data);

        // 发布话题题日志数据
        $comment = [
            'uid' => $uid,
            'pid' => $id,
            'businessId' => $push_key
        ];

        // 发布话题日志
        $this->_d_log->insert($comment);

        return $data;
    }

    /**
     * 同事圈-后台  添加话题
     * @param array $params
     * @param array $user
     * @return int|\Think\mixed
     */
    public function add_new_topic($params = [], $user = [])
    {
        //话题权限 数据
        $right_data = $params['right'];

        unset($params['right']);

        //话题标识
        $circle_data['type'] = Constant::CIRCLE_TOPIC_TYPE;

        // 附件判断
        if (!empty($params['images'])) {
            $attach_Data = $params['images'];
            unset($params['images']);
            $circle_data['is_attach'] = Constant::CIRCLE_ATTACH_ID;
        }

        $circle_data['audit_time'] = MILLI_TIME;
        $circle_data['audit_type'] = self::AUDIT_SYSTEM_TYPE;
        $circle_data['audit_state'] = self::AUDIT_OK;

        //组装话题数据
        $circleData = array_merge($params, $circle_data);

        //话题id
        $cid = 0;
        try {
            //开启事务
            $this->start_trans();

            //话题数据入库
            $cid = $this->_d->insert($circleData);
            // 指定权限数组
            $right_data_all = [];

            // 如果不是全公司
            if (empty($params['is_all'])) {

                // 获取人员
                if (isset($right_data['user_arr']) && !empty($right_data['user_arr'])) {
                    // 遍历人员权限
                    foreach ($right_data['user_arr'] as $v) {

                        $right_data_all[] = [
                            'circle_id' => $cid,
                            'uid' => $v['memID'],
                            'cd_id' => '',
                            'tag_id' => '',
                            'job_id' => '',
                            'role_id' => ''
                        ];
                    }
                }

                // 遍历部门权限
                if (isset($right_data['dp_arr']) && !empty($right_data['dp_arr'])) {

                    foreach ($right_data['dp_arr'] as $v) {

                        $right_data_all[] = [
                            'circle_id' => $cid,
                            'uid' => '',
                            'cd_id' => $v['dpID'],
                            'tag_id' => '',
                            'job_id' => '',
                            'role_id' => ''
                        ];
                    }
                }

                // 遍历标签权限
                if (isset($right_data['tag_arr']) && !empty($right_data['tag_arr'])) {

                    foreach ($right_data['tag_arr'] as $v) {

                        $right_data_all[] = [
                            'circle_id' => $cid,
                            'uid' => '',
                            'cd_id' => '',
                            'tag_id' => $v['tagID'],
                            'job_id' => '',
                            'role_id' => ''
                        ];
                    }
                }

                // 遍历岗位权限
                if (isset($right_data['job_arr']) && !empty($right_data['job_arr'])) {

                    foreach ($right_data['job_arr'] as $v) {

                        $right_data_all[] = [
                            'circle_id' => $cid,
                            'uid' => '',
                            'cd_id' => '',
                            'tag_id' => '',
                            'job_id' => $v['jobID'],
                            'role_id' => ''
                        ];
                    }
                }

                // 遍历角色权限
                if (isset($right_data['role_arr']) && !empty($right_data['role_arr'])) {

                    foreach ($right_data['role_arr'] as $v) {

                        $right_data_all[] = [
                            'circle_id' => $cid,
                            'uid' => '',
                            'cd_id' => '',
                            'tag_id' => '',
                            'job_id' => '',
                            'role_id' => $v['roleID']
                        ];
                    }
                }
            }

            // 如果指定有权限数据
            if (!empty($right_data_all)) {
                $this->_d_right->insert_all($right_data_all);
            }

            $attachData = [];
            //存在附件，数据入库
            if ($circleData['is_attach'] == Constant::CIRCLE_ATTACH_ID) {
                // 遍历图片数组
                foreach ($attach_Data as $v) {

                    // 组装附件数据
                    $attachData[] = [
                        'cid' => $cid,
                        'atid' => $v
                    ];
                }
                // 插入数据到附件表
                $this->_d_att->insert_all($attachData);
            }

            $this->commit();
        } catch (\Exception $e) {
            $this->rollback();
            E('_ERR_DATA_SAVE');
        }

        return $cid;
    }

    /**
     * 同事圈-手机端  话题详情数据格式
     * @param array $data
     * @param string $uid
     * @return array
     */
    public
    function format_info_topic($data = [], $uid = '')
    {
        // 初始化详情
        $info = [];

        if (empty($data)) {
            return $info;
        }

        // 查询用户集合数据
        $user = User::instance();
        $user_info = $user->getByUid($data['uid']);

        // 获取所有附件列表
        $att_list = $this->_d_att->list_by_conds(['cid' => $data['id']]);

        // 获取图片列表
        $images = $this->format_att_images($att_list);

        // 查看当前用户是否点赞过
        $like_total = $this->_d_like->count_by_conds(['uid' => $uid, 'cid' => $data['id']]);

        // 排序参数
        $order_by = [
            'created' => 'DESC'
        ];

        // 获取当前点赞列表
        $like_list = $this->_d_like->list_by_conds(['cid' => $data['id']], self::DEFAULT_LIMIT, $order_by);

        // 初始化点赞列表
        $mem_users = [];

        // 如果有人点赞
        if (!empty($like_list)) {

            // 获取点赞人员UIDS
            $mem_uids = array_unique(array_filter(array_column($like_list, 'uid')));

            // 格式化人员列表
            $mem_list = $this->format_user($mem_uids);

            // 获取点赞列表
            foreach ($like_list as $key => $v) {

                $mem_users[] = [
                    'username' => strval($mem_list[$v['uid']]['username']),
                    'avatar' => strval($mem_list[$v['uid']]['avatar']),
                    'uid' => strval($v['uid'])
                ];
            }
        }

        // 获取收藏状态
        $url = rpcUrl('/Public/Rpc/Collection/CollectionStatus');

        $params = [
            'uid' => $uid,
            'app' => 'workmate',
            'dataId' => $data['id']
        ];

        $res = \Com\Rpc::phprpc($url)->invoke('Index', $params);

        $sc_title = $this->_d_scene->get($data['sc_id']);

        // 组装详情
        $info = [
            'id' => intval($data['id']),
            'uid' => strval($data['uid']),
            'title' => strval($data['title']),
            'content' => $this->Enter($data['content']),
            'username' => strval($user_info['memUsername']),
            'avatar' => strval($user_info['memFace']),
            'sc_id' => intval($data['sc_id']),
            'sc_title' => strval($sc_title['title']),
            'cover_id' => strval($data['cover_id']),
            'audit_name' => $data['audit_uname'],
            'audit_time' => $data['audit_time'],
            'is_all' => intval($data['is_all']),
            'is_anonymous' => intval($data['is_anonymous']),
            'like_total' => intval($this->_d_like->count_by_conds(['cid' => $data['id']], self::DEFAULT_LIMIT)),
            'like_list' => $mem_users,
            'is_del' => $uid != $data['uid'] ? self::UN_DEL : self::DEL,
            'is_like' => $like_total ? self::LIKE : self::UN_LIKE,
            'images' => !empty($images) ? $images[$data['id']] : [],
            'created' => !empty($data['audit_time']) ? $this->get_time($data['audit_time']) : $this->get_time($data['created']),
            'is_collect' => json_decode($res, true)['collection'],
            'comment_anonymous' => $data['comment_anonymous'],
            'topic_status' => intval($data['audit_state']),
        ];

        return $info;
    }


    /**
     * 朋友圈-移动端 发布话题
     * @param array $params
     * @param array $user
     * @param string $release
     * @return array
     */
    public
    function publish_new_topic($params = [], $user = [], $release = '')
    {

        try {
            $this->start_trans();

            // 组装数据
            $data = [
                'type' => Constant::CIRCLE_TOPIC_TYPE,
                'uid' => $user['memUid'],
                'username' => $user['memUsername'],
                'title' => $params['title'],
                'content' => $params['content'],
                'is_attach' => !empty($params['images']) ? CircleModel::ATTACH : CircleModel::NOT_ATTACH,
                'is_all' => $params['is_all'],
                'cover_id' => $params['cover_id'],
                'sc_id' => $params ['sc_id'],
                'is_anonymous' => $params['is_anonymous']
            ];

            // 如果未开启审核
            if (empty($release)) {
                $data = array_merge($data, [
                    'audit_state' => self::AUDIT_OK,
                    'audit_time' => MILLI_TIME,
                    'audit_type' => self::AUDIT_SYSTEM_TYPE
                ]);
            }

            // 写入数据到朋友圈
            $id = $this->_d->insert($data);

            // 话题权限数据
            $rightData = [];
            if (empty($params['is_all'])) {
                foreach ($user['dpName'] as $key => $v) {
                    //部门  遍历
                    $rightData[] = [
                        'circle_id' => $id,
                        'uid' => '',
                        'cd_id' => $v['dpId'],
                    ];
                }
                $this->_d_right->insert_all($rightData);
            }

            // 附件数据初始化
            $att_data = [];
            if ($params['images']) {
                // 遍历图片数组
                foreach ($params['images'] as $key => $v) {
                    // 组装附件数据
                    $att_data[] = [
                        'cid' => $id,
                        'atid' => $v['atId']
                    ];
                }

                // 插入多条数据到附件表
                $this->_d_att->insert_all($att_data);

            }

            $this->commit();
        } catch (\Think\Exception $e) {
            \Think\Log::record($e);
            // 事务回滚
            $this->_set_error($e->getMessage(), $e->getCode());
            $this->rollback();

            return false;
        } catch (\Exception $e) {

            \Think\Log::record($e);
            $this->_set_error($e->getMessage(), $e->getCode());
            // 事务回滚
            $this->rollback();

            return false;
        }
        // 组装发送消息数据
        $msg_data = [
            'uids' => [
                ['memID' => $user['memUid']]
            ],
            'id' => $id,
            'title' => $params['title']
        ];
        // 开启审核功能
        if (!empty($release)) {
            // 默认帖子类型
            $msg_type = self::MSG_TOPIC_PUBLISH;
            // 发送消息
            $this->send_msg($msg_data, $msg_type);
        }

        return ['id' => $id];
    }

    /**
     * 格式化后台帖子列表数据
     *
     * @param $list
     * @return bool
     */
    public
    function format_list_workmate(&$list)
    {

        if (empty($list)) {
            return true;
        }

        // 取出列表的用户ID集合
        $uids = array_column($list, 'uid');

        // 查询用户集合数据
        $member = new User();
        $user_list = $member->listByConds(['memUids' => $uids], 1, count($uids));

        // 获取已查询到UID列表
        $uid_list = array_column($user_list['list'], 'memUid');

        // 获取全部用户列表
        $this->user_list($user_list['list'], $uids, $uid_list);
        $user_list['list'] = array_combine_by_key($user_list['list'], 'memUid');

        // 获取帖子ID集合
        $ids = array_column($list, 'id');

        // 获取点赞总数
        $like_data = $this->_d_like->get_like_total($ids);
        // 将点赞数据转换成以帖子ID为key的二维数组
        $like_data = array_combine_by_key($like_data, 'cid');

        // 获取通过审核评论数
        $comment_ok_list = $this->_d->get_comment_num($ids, self::AUDIT_OK);
        // 将评论数据转换成以帖子ID为key的二维数组
        $comment_ok_data = array_combine_by_key($comment_ok_list, 'pid');

        // 获取待审核评论数
        $commont_ing_list = $this->_d->get_comment_num($ids, self::AUDIT_ING);
        // 将评论数据转换成以帖子ID为key的二维数组
        $commont_ing_data = array_combine_by_key($commont_ing_list, 'pid');

        // 循环给列表中字段赋值
        foreach ($list as &$v) {

            // 获取用户所在的所有部门
            $res_dpNames = array_column($user_list['list'][$v['uid']]['dpName'], 'dpName');
            $dpNames = '';
            if (!empty($res_dpNames)) {
                $dpNames = implode(';', $res_dpNames);
            }
            $v['dpName'] = $dpNames;
            $v['username'] = empty($v['uid']) ? '员圈小助手' : strval($user_list['list'][$v['uid']]['memUsername']);
            $v['like_total'] = intval($like_data[$v['id']]['total']);
            $v['commont_ok_total'] = intval($comment_ok_data[$v['id']]['total']);
            $v['commont_ing_total'] = intval($commont_ing_data[$v['id']]['total']);
            $v['audit_state'] = intval($v['audit_state']);
            $v['id'] = intval($v['id']);
            $v['audit_time'] = strval($v['a_time']);
            // 清除多余数据
            unset(
                $v['a_time'],
                $v['audit_type'],
                $v['is_attach'],
                $v['pid'],
                $v['domain'],
                $v['status'],
                $v['updated'],
                $v['deleted'],
                $v['type'],
                $v['is_all'],
                $v['cover_id'],
                $v['sc_id'],
                $v['title'],
                $v['comment_anonymous'],
                $v['audit_uid'],
                $v['audit_uname'],
                $v['uid']
            );
        }

        return true;
    }
}