"应对可以通过路径访问，但是不在列表中展示，和机要贴有区别。包含如下几部分数据库帖子表（article）添加字段帖子是否展示 articleDisplayable, 默认展示修改 repository.json { 'name': 'articleDisplayable', 'type': ' ...."

qiankunpingtai
荆棘从死亡中来，死亡又包含着新生。
乾坤万联程序 Sym • 0 回帖 • 1K 浏览 • 5 年前

添加帖子是否展示的功能（一）数据保存和修改

应对可以通过路径访问，但是不在列表中展示，和机要贴有区别。
包含如下几部分

数据库

帖子表（article）添加字段帖子是否展示 articleDisplayable, 默认展示

修改 repository.json

        {
          "name": "articleDisplayable",
          "type": "int",
          "description": "帖子是否展示,0不展示，1展示"
        }

已存在的数据库手动添加列

alter table symphony_article add articleDisplayable int(11) NOT NULL DEFAULT 1 COMMENT '帖子是否展示,0不展示，1展示';

实体类

Article.java实体类添加属性

    /**
     * Key of article dispalyable.
     */
    public static final String ARTICLE_DISPLAYABLE = "articleDisplayable";

    // articleDisplayable constants
    /**
     * create by: qiankunpingtai
     * create time: 2019/5/14 22:42
     * website：https://qiankunpingtai.cn
     * description:
     * 不展示false
     * 展示true
     */
    public static final Integer ARTICLE_DISPLAYABLE_NOT =0 ;
    public static final Integer ARTICLE_DISPLAYABLE_YES = 1;
    // articleDisplayable es and algolia constants
    /**
     * create by: qiankunpingtai
     * create time: 2019/5/14 22:42
     * website：https://qiankunpingtai.cn
     * description:
     * 0 删除
     * 1 创建
     * 2 更新
     * 3 不操作
     */
    public static final String ARTICLE_DISPLAYABLE_INDEX_OPT="articleDisplayableIndexOpt";
    public static final String ARTICLE_DISPLAYABLE_INDEX_OPT_DELETE = "0";
    public static final String ARTICLE_DISPLAYABLE_INDEX_OPT_ADD = "1";
    public static final String ARTICLE_DISPLAYABLE_INDEX_OPT_UPDATE = "2";
    public static final String ARTICLE_DISPLAYABLE_INDEX_OPT_NOTHING = "3";

页面显示文本配置

lang_zh_CN.properties 添加

displayableLabel=允许展示

lang_en_US.properties 添加

displayableLabel=Allow to display

页面

管理员界面

./skins/classic/admin/article.ftl

<div class="fn__flex">
    <label>
        <div>${qnaOfferPointLabel}</div>
        <input type="text" name="articleQnAOfferPoint" value="${article.articleQnAOfferPoint?c}"/>
    </label>
    <#--添加是否列表展示的控制-->
    <label class="mid">
        <div>${displayableLabel}</div>
        <select id="articleDisplayable" name="articleDisplayable">
            <option value="1"<#if 1==article.articleDisplayable> selected</#if>>${yesLabel}</option>
            <option value="0"<#if 0==article.articleDisplayable> selected</#if>>${noLabel}</option>
        </select>
    </label>
</div>

./skins/mobile/admin/article.ftl

<label for="articleId">${pushLabel} Email  ${sortLabel}</label>
<input type="number" id="articlePushOrder" name="articlePushOrder" value="${article.articlePushOrder}" />
<#--添加是否列表展示的控制-->
<label>${displayableLabel}</label>
<select id="articleDisplayable" name="articleDisplayable">
    <option value="1"<#if 1==article.articleDisplayable> selected</#if>>${yesLabel}</option>
    <option value="0"<#if 0==article.articleDisplayable> selected</#if>>${noLabel}</option>
</select>

发帖界面

./skins/classic/home/post.ftl

<#if permissions["commonAddArticleAnonymous"].permissionGrant && articleType != 2 && articleType != 5>
<label class="article-anonymous">${anonymousLabel}<input<#if requisite> readonly disabled</#if>
        <#if article??> disabled="disabled"<#if 1 == article.articleAnonymous> checked</#if></#if>
        type="checkbox" id="articleAnonymous"></label>
</#if>
<#--添加是否列表展示的控制-->
<label class="article-anonymous">&nbsp;  ${displayableLabel}<input
        <#if (article?? && (1==article.articleDisplayable)) || !article??> checked="checked"</#if> type="checkbox" id="articleDisplayable"></label>

./skins/mobile/home/post.ftl

<#if permissions["commonAddArticleAnonymous"].permissionGrant && articleType != 2 && articleType != 5>
    <label class="article-anonymous">&nbsp;  ${anonymousLabel}<input
        <#if article??> disabled="disabled"<#if 1 == article.articleAnonymous> checked</#if></#if>
        type="checkbox" id="articleAnonymous"></label>
</#if>
<#--添加是否列表展示的控制-->
<label class="article-anonymous">&nbsp;  ${displayableLabel}<input
        <#if (article?? && (1==article.articleDisplayable)) || !article??> checked="checked"</#if>
                        type="checkbox" id="articleDisplayable"></label>

`add-article.js`

add: function (csrfToken, it) {
......

       /**
         * create by: qiankunpingtai
         * create time: 2019/5/14 18:11
         * website：https://qiankunpingtai.cn
         * description:
         * 添加是否在列表中展示项
         */
      var requestJSONObject = {
        articleTitle: $('#articleTitle').val().replace(/(^\s*)|(\s*$)/g, ''),
        articleContent: this.editor.getValue(),
        articleTags: articleTags,
        articleCommentable: $('#articleCommentable').prop('checked'),
        articleNotifyFollowers: $('#articleNotifyFollowers').prop('checked'),
        articleType: articleType,
        articleDisplayable: Boolean($('#articleDisplayable').prop('checked'))?1:0
      }

......
}

`add-article.min.js`

add: function (e, a) {
......
            var r = {
                articleTitle: $("#articleTitle").val().replace(/(^\s*)|(\s*$)/g, ""),
                articleContent: this.editor.getValue(),
                articleTags: i,
                articleCommentable: $("#articleCommentable").prop("checked"),
                articleNotifyFollowers: $("#articleNotifyFollowers").prop("checked"),
                articleType: t,
                articleDisplayable: Boolean($('#articleDisplayable').prop('checked'))?1:0
            };
......
}

后台处理

保存

/admin/article/

修改AdminProcessor.java
保存方法，从 json 中获取数据

    @RequestProcessing(value = "/admin/article/{articleId}", method = HttpMethod.POST)
    @Before({StopwatchStartAdvice.class, PermissionCheck.class})
    @After({PermissionGrant.class, StopwatchEndAdvice.class})
    public void updateArticle(final RequestContext context) {
        final String articleId = context.pathVar("articleId");
        final HttpServletRequest request = context.getRequest();

        final AbstractFreeMarkerRenderer renderer = new SkinRenderer(context, "admin/article.ftl");
        final Map<String, Object> dataModel = renderer.getDataModel();

        JSONObject article = articleQueryService.getArticle(articleId);

        final Enumeration<String> parameterNames = request.getParameterNames();
        while (parameterNames.hasMoreElements()) {
            final String name = parameterNames.nextElement();
            final String value = context.param(name);
            /**
             * create by: qiankunpingtai
             * create time: 2019/5/14 22:45
             * website：https://qiankunpingtai.cn
             * description:
             * int类型，值由字符串更新为int
             */
            if (name.equals(Article.ARTICLE_REWARD_POINT)
                    || name.equals(Article.ARTICLE_QNA_OFFER_POINT)
                    || name.equals(Article.ARTICLE_STATUS)
                    || name.equals(Article.ARTICLE_TYPE)
                    || name.equals(Article.ARTICLE_THANK_CNT)
                    || name.equals(Article.ARTICLE_GOOD_CNT)
                    || name.equals(Article.ARTICLE_BAD_CNT)
                    || name.equals(Article.ARTICLE_PERFECT)
                    || name.equals(Article.ARTICLE_ANONYMOUS_VIEW)
                    || name.equals(Article.ARTICLE_PUSH_ORDER)
                    ||name.equals(Article.ARTICLE_DISPLAYABLE)) {
                article.put(name, Integer.valueOf(value));
            } else {
                article.put(name, value);
            }
        }

        final String articleTags = Tag.formatTags(article.optString(Article.ARTICLE_TAGS));
        article.put(Article.ARTICLE_TAGS, articleTags);

        articleMgmtService.updateArticleByAdmin(articleId, article);
        operationMgmtService.addOperation(Operation.newOperation(request, Operation.OPERATION_CODE_C_UPDATE_ARTICLE, articleId));

        article = articleQueryService.getArticle(articleId);
        String title = article.optString(Article.ARTICLE_TITLE);
        title = Escapes.escapeHTML(title);
        article.put(Article.ARTICLE_TITLE, title);
        dataModel.put(Article.ARTICLE, article);
        /**
         * create by: qiankunpingtai
         * create time: 2019/5/15 10:45
         * website：https://qiankunpingtai.cn
         * description:
         * 如果是不在列表中显示的帖子，直接跳过
         */
        final Integer articleDisplayable = article.optInt(Article.ARTICLE_DISPLAYABLE);
        if(Article.ARTICLE_DISPLAYABLE_YES.equals(articleDisplayable)){
            updateArticleSearchIndex(article);
        }

        dataModelService.fillHeaderAndFooter(context, dataModel);
    }

/article

修改ArticleProcessor.java

    @RequestProcessing(value = "/article", method = HttpMethod.POST)
    @Before({StopwatchStartAdvice.class, LoginCheck.class, CSRFCheck.class, ArticleAddValidation.class, PermissionCheck.class})
    @After(StopwatchEndAdvice.class)
    public void addArticle(final RequestContext context) {
        context.renderJSON();

        final HttpServletRequest request = context.getRequest();
        final JSONObject requestJSONObject = context.requestJSON();
        final String articleTitle = requestJSONObject.optString(Article.ARTICLE_TITLE);
        String articleTags = requestJSONObject.optString(Article.ARTICLE_TAGS);
        final String articleContent = requestJSONObject.optString(Article.ARTICLE_CONTENT);
        final boolean articleCommentable = requestJSONObject.optBoolean(Article.ARTICLE_COMMENTABLE, true);
        final int articleType = requestJSONObject.optInt(Article.ARTICLE_TYPE, Article.ARTICLE_TYPE_C_NORMAL);
        final String articleRewardContent = requestJSONObject.optString(Article.ARTICLE_REWARD_CONTENT);
        final int articleRewardPoint = requestJSONObject.optInt(Article.ARTICLE_REWARD_POINT);
        final int articleQnAOfferPoint = requestJSONObject.optInt(Article.ARTICLE_QNA_OFFER_POINT);
        final String ip = Requests.getRemoteAddr(request);
        final String ua = Headers.getHeader(request, Common.USER_AGENT, "");
        final boolean isAnonymous = requestJSONObject.optBoolean(Article.ARTICLE_ANONYMOUS, false);
        final int articleAnonymous = isAnonymous ? Article.ARTICLE_ANONYMOUS_C_ANONYMOUS : Article.ARTICLE_ANONYMOUS_C_PUBLIC;
        final boolean articleNotifyFollowers = requestJSONObject.optBoolean(Article.ARTICLE_T_NOTIFY_FOLLOWERS);
        /**
         * create by: qiankunpingtai
         * create time: 2019/5/14 18:11
         * website：https://qiankunpingtai.cn
         * description:
         * 添加是否在列表中展示项
         */
        final Integer articleDisplayable = requestJSONObject.optInt(Article.ARTICLE_DISPLAYABLE,Article.ARTICLE_DISPLAYABLE_YES);

        final JSONObject article = new JSONObject();
        article.put(Article.ARTICLE_TITLE, articleTitle);
        article.put(Article.ARTICLE_CONTENT, articleContent);
        article.put(Article.ARTICLE_EDITOR_TYPE, 0);
        article.put(Article.ARTICLE_COMMENTABLE, articleCommentable);
        article.put(Article.ARTICLE_TYPE, articleType);
        article.put(Article.ARTICLE_REWARD_CONTENT, articleRewardContent);
        article.put(Article.ARTICLE_REWARD_POINT, articleRewardPoint);
        article.put(Article.ARTICLE_QNA_OFFER_POINT, articleQnAOfferPoint);
        article.put(Article.ARTICLE_IP, "");
        if (StringUtils.isNotBlank(ip)) {
            article.put(Article.ARTICLE_IP, ip);
        }
        article.put(Article.ARTICLE_UA, ua);
        article.put(Article.ARTICLE_ANONYMOUS, articleAnonymous);
        article.put(Article.ARTICLE_T_NOTIFY_FOLLOWERS, articleNotifyFollowers);
        /**
         * create by: qiankunpingtai
         * create time: 2019/5/14 18:11
         * website：https://qiankunpingtai.cn
         * description:
         * 添加是否在列表中展示项
         */
        article.put(Article.ARTICLE_DISPLAYABLE, articleDisplayable);

        try {
            final JSONObject currentUser = Sessions.getUser();

            article.put(Article.ARTICLE_AUTHOR_ID, currentUser.optString(Keys.OBJECT_ID));

            if (!Role.ROLE_ID_C_ADMIN.equals(currentUser.optString(User.USER_ROLE))) {
                articleTags = articleMgmtService.filterReservedTags(articleTags);
            }

            if (Article.ARTICLE_TYPE_C_DISCUSSION == articleType && StringUtils.isBlank(articleTags)) {
                articleTags = "机要";
            }

            if (Article.ARTICLE_TYPE_C_THOUGHT == articleType && StringUtils.isBlank(articleTags)) {
                articleTags = "思绪";
            }

            article.put(Article.ARTICLE_TAGS, articleTags);

            final String articleId = articleMgmtService.addArticle(article);

            context.renderJSONValue(Keys.STATUS_CODE, StatusCodes.SUCC);
            context.renderJSONValue(Article.ARTICLE_T_ID, articleId);
        } catch (final ServiceException e) {
            final String msg = e.getMessage();
            LOGGER.log(Level.ERROR, "Adds article [title=" + articleTitle + "] failed: {0}", e.getMessage());

            context.renderMsg(msg);
            context.renderJSONValue(Keys.STATUS_CODE, StatusCodes.ERR);
        }
    }

/article/{id}