Uninote
Uninote
用户根目录
每日点滴
 mynote release
mynote release
r190227

2019-5-22 发布

r190522
SHA-1: 6ceeadd865c1da77a70fa089659dc4e987eca788
* 【更新】- 没有更多内容不要再展示加载更多按钮(更多作者页面)
部署项目:
SHA-1: d70dface130d00ca2e11158f1f162368e5a53f8c
* Gogs/es/sms configs
fastadmin:
SHA-1: efb4346bbb22c78276572c2b0ef35503018123f1
* give exe auth to *.sh
停服、备份、部署、启动、测试
es 部署
短信、邮件
UI2.0
编辑器升级
标签系统
重构
composer
config
-- 分类标签表
DROP TABLE IF EXISTS `artag_classify`;
CREATE TABLE IF NOT EXISTS `artag_classify`(
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `tag` VARCHAR(128) NOT NULL COMMENT '分类标签名',
    `time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `status` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '状态(单选):0=不显示,1=显示',
    PRIMARY KEY(`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章分类标签表管理';
INSERT INTO `artag_classify` (`id`, `tag`, `status`) VALUES ('1', '阅读', '1');
-- 文章标签表
DROP TABLE IF EXISTS `artag`;
CREATE TABLE IF NOT EXISTS `artag`(
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `tag` VARCHAR(128) NOT NULL COMMENT '标签',
    `time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `status` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '状态(单选):0=不显示,1=显示',
    PRIMARY KEY(`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章标签表管理';
-- 用户常用标签表
DROP TABLE IF EXISTS `artag_user`;
CREATE TABLE IF NOT EXISTS `artag_user`(
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `tag` VARCHAR(128) NOT NULL COMMENT '标签',
    `uid` INT UNSIGNED NOT NULL COMMENT '用户ID',
    `time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `status` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '状态(单选):0=不显示,1=显示',
    PRIMARY KEY(`id`),
    KEY `uid` (`uid`),
    KEY `tag` (`tag`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章标签表管理';
-- 文章标签关系表
DROP TABLE IF EXISTS `artag_user_relation`;
CREATE TABLE IF NOT EXISTS `artag_user_relation`(
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `aid` INT UNSIGNED NOT NULL COMMENT '文章ID',
    `tagid` INT UNSIGNED NOT NULL COMMENT '标签ID',
    `time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '状态(单选):0=文章标签,1=用户常用标签',
    PRIMARY KEY(`id`),
    KEY `aid` (`aid`),
    KEY `tagid` (`tagid`),
    UNIQUE KEY `aid_tagid_status` (`aid`, `tagid`,`status`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章标签表管理';
-- 文章分类关系表
DROP TABLE IF EXISTS `artag_classify_relation`;
CREATE TABLE IF NOT EXISTS `artag_classify_relation`(
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `aid` INT UNSIGNED NOT NULL COMMENT '文章ID',
    `artag_classify_id` INT UNSIGNED NOT NULL COMMENT '分类标签ID',
    `time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `status` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '状态(单选):0=不显示,1=显示',
    PRIMARY KEY(`id`),
    KEY `aid` (`aid`),
    KEY `artag_classify_id` (`artag_classify_id`),
    UNIQUE KEY `aid_artag_classify_id` (`aid`, `artag_classify_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章分类关系表管理';
run as www user in /home/www/fastadmin
php think crud -t artag -c mynote/artag -m artag --force=true
php think menu -c mynote/artag --force=true
php think crud -t artag_classify -c mynote/artagclassify -m artagclassify --force=true
php think menu -c mynote/artagclassify --force=true

es

1 删除index(如果有)
DELETE /mynote
2 建立mapping
PUT /mynote
{
    "settings": {
        "analysis": {
            "analyzer": {
                "ik_pinyin_analyzer": {
                    "type":"custom",
                    "tokenizer": "ik_smart",
                    "filter": ["my_pinyin","word_delimiter"]
                }
            },
            "filter": {
                "my_pinyin": {
                  "keep_joined_full_pinyin": "true",
                  "keep_none_chinese_in_first_letter": "false",
                  "lowercase": "true",
                  "keep_original": "false",
                  "keep_first_letter": "false",
                  "trim_whitespace": "true",
                  "type": "pinyin",
                  "keep_none_chinese": "false",
                  "limit_first_letter_length": "16",
                  "keep_full_pinyin": "false"
                }
            }
        }
    },
    "mappings":{
        "article":{
            "properties":{
                "abstract":{
                    "type":"text",
                    "analyzer":"ik_max_word"
                },
                "article_id":{
                    "type":"keyword"
                },
                "content":{
                    "type":"text",
                    "fields":{
                        "pinyin":{
                            "type":"text",
                            "analyzer":"ik_pinyin_analyzer"
                        }
                    },
                    "analyzer":"ik_max_word"
                },
                "id":{
                    "type":"long"
                },
                "recommend":{
                    "type":"byte"
                },
                "sort":{
                    "type":"long"
                },
                "status":{
                    "type":"byte"
                },
                "tag":{
                    "type":"keyword"
                },
                "thum":{
                    "type":"text"
                },
                "time":{
                    "type":"date"
                },
                "title":{
                    "type":"text",
                    "fields":{
                        "keyword":{
                            "type":"keyword"
                        },
                        "pinyin":{
                            "type":"text",
                            "analyzer":"ik_pinyin_analyzer"
                        }
                    },
                    "analyzer":"ik_max_word"
                },
                "updata_time":{
                    "type":"date"
                },
                "username":{
                    "type":"text",
                    "fields":{
                        "keyword":{
                            "type":"keyword"
                        },
                        "pinyin":{
                            "type":"text",
                            "analyzer":"ik_pinyin_analyzer"
                        }
                    },
                    "analyzer":"ik_max_word"
                }
            }
        }
    }
}
3 访问此链接,建立文章索引
http://uninote.com.cn/api/synes
4 搜索测试,查询条件替换红色部分,注意中文搜索测试
GET /mynote/article/_search
{
            "query": {
                "dis_max": {
                    "tie_breaker": 0.7,
                    "boost": 1.2,
                    "queries": [
                        {
                            "bool": {
                                "should": [
                                    {
                                        "multi_match": {
                                            "query": "日志",
                                            "fields": ["content", "content.pinyin", "username", "username.pinyin", "title","title.pinyin"],
                                            "analyzer":"ik_max_word"
                                        }
                                    },
                                    {
                                        "term": {
                                            "tag": {
                                                "value": "日志"
                                            }
                                        }
                                    }
                                ]
                            }
                        }
                    ]
                }
            },
            "highlight": {
                "fields": [
                    {"tag" :{}},
                    {"title" :{}},
                    {"content" :{}},
                    {"username" :{}},
                    {"title.pinyin" :{}},
                    {"content.pinyin" :{}},
                    {"username.pinyin" :{}}
                ]
            },
            "size": 10,
            "from": 0,
            "_source":[
                "highlight", "title", "article_id", "title", "abstract", "thum", "id"
            ]
        }

mynote_mod_article

mynote_res

点赞(0) 阅读(380) 举报
目录
标题