CMS系统升级到最新版-七弈智慧-七弈国象-连接七弈智慧人生

首页 / 日常工作杂记/ 前端

CMS系统升级到最新版

2025-05-21 16:37:53 阅读（418）

明空的版本更新很快，所以抽时间把版本更新到最新版

一数据库

新的数据库跟老数据库有所不同，所以本次的第一步工作是数据库同步

将线上的老数据库与本地的老版数据库同步一下
将新数据库表的结构同步到老数据库里
将新数据库里几个新增的表的数据同步过来
- 应当就是几个sys起头的表（具体可以自己观察）
  - sys_app
  - sys_config
  - sys_notice
  - sys_role
  - sys_user
改动flag表里的数据type都为1

二 css改动以及logo替换

整体css背景以及个性化列表还有广告的问题新增一个，这样不用改main.css

server\app\public\template\default\css\user.css

把所有搜索到了

<main class="bg-f2f2f2
改为：

<main class="bg-primary

新增user.css：

/* 增加一个主色调*/
.bg-primary {
    background-color: #066D52
}

/** 头图的连接 **/
.swiper-slide a {
    display: block;
    width: 100%;
    height: 100%;
    object-fit: cover;
}
/* 一级列表项 */
.article-cont ul li::before {
    content: "\265B"; /* 使用Unicode字符表示国象后 */
    margin-right: 5px; /* 可以根据需要调整图标与文本之间的间距 */
  }
  
  /* 二级列表项 */
  .article-cont ul ul li::before {
    content: "\265E"; /* 使用Unicode字符表示国象马 */
    margin-right: 5px;
  }
  
  /* 三级列表项 */
  .article-cont ul ul ul li::before {
    content: "\265F"; /* 使用Unicode字符表示国象兵 */
    margin-right: 5px;
  }
  
  
  /* 广告 */
  .ad {
    max-width: 100%; /* 设置最大宽度为100% */
  }

logo.svg的替换

三代码改动

头图不能点击的问题

server\app\modules\home\view\default\index.html

                    <div class="swiper mySwiper">
                        <div class="swiper-wrapper">
                            {{each slide}}
                            <div class="swiper-slide">
                                <a href="{{$value.path}}/article-{{$value.id}}.html" title="{{$value.title}}">
                                    <img src="{{$value.img}}" title="{{$value.title}}" alt="{{$value.title}}">
                                    <!-- <h3 class="carousel-title">{{$value.title}}</h3> -->
                                </a>
                            </div>
                            {{/each}}
                        </div>

server\app\modules\home\view\default\common\meta.html 这个文件改成这样

<meta name="viewport" content="width=device-width, initial-scale=1"/>
    <meta property="og:type" content="article" />
    <meta property="og:image" content="{{base_url}}/img/logo.svg"/>
    <meta property="og:url" content="http://{{site.domain}}"/>
    <meta name="author" content="{{site.name}}"/>
    <link rel="shortcut icon" href="{{base_url}}/img/favicon.png" type="image/x-icon" />
    <link rel="stylesheet" href="{{base_url}}/css/saduo@1.0.9.css"/>
    <link rel="stylesheet" href="{{base_url}}/css/swiper.min.css"/>
    <link rel="stylesheet" href="{{base_url}}/css/main.css"/>
    <link rel="stylesheet" href="{{base_url}}/css/prism.css"/>
    <link rel="stylesheet" href="{{base_url}}/css/user.css"/>

以及ad读取值的一个问题

搜索所有frag.ad 然后改成下面这个

                <!-- 广告 -->
                <section class="ad mb-20 bg-fff">
                    <!-- {{frag.ad.name}} -->
                    {{@ frag.ad}}
                </section>

title写上文章的标题

D:\git\server\cms\server\app\modules\home\view\default\article.html
还要取消掉导读

                    <!-- <section class="introduction pd-10 border-6 mb-20 mt-20 lh-25 f-14 bg-f2f2f2">
                        「导读」{{@ article.description}}
                    </section> -->

<html>

<head>
    <meta charset="utf-8">
    <title> {{article.title}}-{{site.name}}-{{site.title}}</title>
    {{include './common/meta.html'}}

<body class="bg-f8f8f8">

搜索所有的[详情] 改为【详情】
搜索所有tag标签改为专题

几个碎片的值在footer.html的连接

cms\server\app\modules\home\view\default\common\footer.html

<footer class="pd-20">
    <div class="footer main center pd-20">
        <div class="row justify-between">
            {{@ frag['footer-fe']}}
            {{@ frag['footer-chess']}}
            {{@ frag['footer-7yi']}}
            {{@ frag['footer-guanyu']}}
        </div>
        <p class="mt-30 text-c f-14">©copyright {{site.name}}{{site.json.siteSubtitle}}</p>
        {{@ frag.copyright}}
        {{@ frag.record}}
    </div>
</footer>

<!-- 返回顶部 -->
<span class="backtop none">
    <svg data-v-2a8a074a="" width="20" height="20" viewBox="0 0 20 20" fill="none" xmlns="http://www.w3.org/2000/svg" class=""><path data-v-2a8a074a="" fill-rule="evenodd" clip-rule="evenodd" d="M5.00806 3.0625C4.70158 3.0625 4.45312 3.31095 4.45312 3.61743C4.45312 3.92391 4.70158 4.17236 5.00806 4.17236H14.9968C15.3033 4.17236 15.5518 3.92391 15.5518 3.61743C15.5518 3.31095 15.3033 3.0625 14.9968 3.0625H5.00806ZM10.3948 5.9997C10.1781 5.78297 9.82676 5.78297 9.61005 5.9997L6.07849 9.53126C5.86176 9.74797 5.86176 10.0993 6.07849 10.316C6.2952 10.5328 6.64656 10.5328 6.86327 10.316L9.44751 7.73182V17.3809C9.44751 17.6873 9.69596 17.9358 10.0024 17.9358C10.3089 17.9358 10.5574 17.6873 10.5574 17.3809V7.73182L13.1416 10.316C13.3583 10.5328 13.7097 10.5328 13.9264 10.316C14.1431 10.0993 14.1431 9.74797 13.9264 9.53126L10.3948 5.9997Z" fill="#515767" stroke="#515767" stroke-width="0.5"></path></svg>
</span>

四上传服务器：

数据库
- 本地数据库同步到线上会有一个问题。主要是线上版本的问题，线上是5.7,本地是8.1 主要是一个类型需要改成线上支持的类型，导出数据库为sql后，使用编辑器替换一下就行了
  - ```
  'utf8mb4_0900_ai_ci
  
  全部替换成
  
  utf8mb4_unicode_ci
```
端口配置
- 需要的4000
上传代码
- git代码到服务器上，在服务器运行
- ```
npm i

npm run prd 
```

接口页面--全局数据：

site-> {"id":1,"name":"七弈智慧","domain":"doc.7yi.link","email":"13346163791@qq.com","wx":null,"icp":"浙ICP备2023022652号-1","code":"","json":{"siteSubtitle":"• 工作室"},"title":"七弈国象-连接七弈智慧人生","keywords":"国际象棋,棋谱,pgn,","description":"国际象棋站","createdAt":null,"updatedAt":"2025-04-14T01:07:55.000Z","template":null,"appid":null,"secret":null}

111-->• 工作室

nav-> [{"id":13,"pid":0,"name":"日常工作杂记","pinyin":"richanggongzuozaji","path":"/richanggongzuozaji","sort":4,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0","children":[{"id":14,"pid":13,"name":"前端","pinyin":"qianduan","path":"/richanggongzuozaji/qianduan","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":15,"pid":13,"name":"后端","pinyin":"houduan","path":"/cmsgaijin/houduan","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":16,"pid":13,"name":"总结","pinyin":"zongjie","path":"/kaifariji/zongjie","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":17,"pid":13,"name":"工作计划","pinyin":"gongzuojihua","path":"/cmsgaijin/gongzuojihua","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":22,"pid":13,"name":"炒股养棋","pinyin":"chaoguyangqi","path":"/chaoguyangqi","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":23,"pid":13,"name":"cx13","pinyin":"cx13","path":"/kaifariji/cx13","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":24,"pid":13,"name":"时限学堂","pinyin":"shixianxuetang","path":"/richanggongzuozaji/shixianxuetang","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":25,"pid":13,"name":"运营","pinyin":"yunying","path":"/richanggongzuozaji/yunying","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"}]},{"id":18,"pid":0,"name":"国象练习","pinyin":"guoxianglianxi","path":"/guoxianglianxi","sort":3,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":19,"pid":0,"name":"信息公布","pinyin":"xinxigongbu","path":"/xinxigongbu","sort":6,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0","children":[{"id":20,"pid":19,"name":"业界消息","pinyin":"yejiexiaoxi","path":"/qiyiguoxiang/yejiexiaoxi","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":21,"pid":19,"name":"七弈动态","pinyin":"qiyidongtai","path":"/xinxigongbu/qiyidongtai","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"}]}]

category-> [{"id":13,"pid":0,"name":"日常工作杂记","pinyin":"richanggongzuozaji","path":"/richanggongzuozaji","sort":4,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0","children":[{"id":14,"pid":13,"name":"前端","pinyin":"qianduan","path":"/richanggongzuozaji/qianduan","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":15,"pid":13,"name":"后端","pinyin":"houduan","path":"/cmsgaijin/houduan","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":16,"pid":13,"name":"总结","pinyin":"zongjie","path":"/kaifariji/zongjie","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":17,"pid":13,"name":"工作计划","pinyin":"gongzuojihua","path":"/cmsgaijin/gongzuojihua","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":22,"pid":13,"name":"炒股养棋","pinyin":"chaoguyangqi","path":"/chaoguyangqi","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":23,"pid":13,"name":"cx13","pinyin":"cx13","path":"/kaifariji/cx13","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":24,"pid":13,"name":"时限学堂","pinyin":"shixianxuetang","path":"/richanggongzuozaji/shixianxuetang","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":25,"pid":13,"name":"运营","pinyin":"yunying","path":"/richanggongzuozaji/yunying","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"}]},{"id":14,"pid":13,"name":"前端","pinyin":"qianduan","path":"/richanggongzuozaji/qianduan","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":15,"pid":13,"name":"后端","pinyin":"houduan","path":"/cmsgaijin/houduan","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":16,"pid":13,"name":"总结","pinyin":"zongjie","path":"/kaifariji/zongjie","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":17,"pid":13,"name":"工作计划","pinyin":"gongzuojihua","path":"/cmsgaijin/gongzuojihua","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":18,"pid":0,"name":"国象练习","pinyin":"guoxianglianxi","path":"/guoxianglianxi","sort":3,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":19,"pid":0,"name":"信息公布","pinyin":"xinxigongbu","path":"/xinxigongbu","sort":6,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0","children":[{"id":20,"pid":19,"name":"业界消息","pinyin":"yejiexiaoxi","path":"/qiyiguoxiang/yejiexiaoxi","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":21,"pid":19,"name":"七弈动态","pinyin":"qiyidongtai","path":"/xinxigongbu/qiyidongtai","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"}]},{"id":20,"pid":19,"name":"业界消息","pinyin":"yejiexiaoxi","path":"/qiyiguoxiang/yejiexiaoxi","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":21,"pid":19,"name":"七弈动态","pinyin":"qiyidongtai","path":"/xinxigongbu/qiyidongtai","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":22,"pid":13,"name":"炒股养棋","pinyin":"chaoguyangqi","path":"/chaoguyangqi","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":23,"pid":13,"name":"cx13","pinyin":"cx13","path":"/kaifariji/cx13","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":24,"pid":13,"name":"时限学堂","pinyin":"shixianxuetang","path":"/richanggongzuozaji/shixianxuetang","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":25,"pid":13,"name":"运营","pinyin":"yunying","path":"/richanggongzuozaji/yunying","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"}]

friendlink-> [{"id":1,"title":"七弈国象首页","link":"https://www.7yi.link","sort":0,"createdAt":"2023-07-22T14:59:55.000Z"}]

base_url-> /public/template/default

frag--->{"record":"<p style=\"text-align: center;\"><a href=\"http://beian.miit.gov.cn/\" target=\"_blank\" rel=\"noopener\">浙ICP备2023022652号-1</a></p>","footer-guanyu":"","footer-7yi":"","footer-chess":"","footer-fe":"","chanyue-introduce":"<p>七弈国象：专注于国际象棋开局与战术学习的网站</p>\n<ul>\n<li>国际象棋相关工具开发：<br>\n<ul>\n<li>记谱训练</li>\n<li>识谱工具</li>\n</ul>\n</li>\n<li>国象相关产品\n<ul>\n<li>记录本</li>\n</ul>\n</li>\n<li>电商网站\n<ul>\n<li>畅享一三</li>\n</ul>\n</li>\n<li>通用后台<br>\n<ul>\n<li>7Link通用后台开发系统                                   </li>\n</ul>\n</li>\n</ul>","copyright":"<p style=\"text-align: center;\">杭州七弈智慧科技有限公司版权所有</p>","ad":"<p style=\"text-align: center;\"><a href=\"https://7yi.link/stock/chess/web-mobile/\" target=\"_blank\" rel=\"noopener\"> <img style=\"display: block; margin-left: auto; margin-right: auto; max-width: 100%; height: auto;\" src=\"/public/uploads/default/2023/09/21/1695286791855_mceu_83563456911695286788809.png.png\"> </a></p>\n<p style=\"text-align: center;\"><a href=\"https://7yi.link/stock/chess/web-mobile/\" target=\"_blank\" rel=\"noopener\">开局树学习</a></p>"}

tag--->[{"id":8,"name":"双马防御","path":"shuangmafangyu"},{"id":7,"name":"开发","path":"kaifa"},{"id":6,"name":"伦敦体系","path":"lunduntixi"},{"id":5,"name":"俄罗斯防御","path":"eluosifangyu"},{"id":1,"name":"cms","path":"cms"}]

-----------

position------>[{"id":13,"pid":0,"name":"日常工作杂记","pinyin":"richanggongzuozaji","path":"/richanggongzuozaji","sort":4,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0","children":[{"id":14,"pid":13,"name":"前端","pinyin":"qianduan","path":"/richanggongzuozaji/qianduan","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":15,"pid":13,"name":"后端","pinyin":"houduan","path":"/cmsgaijin/houduan","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":16,"pid":13,"name":"总结","pinyin":"zongjie","path":"/kaifariji/zongjie","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":17,"pid":13,"name":"工作计划","pinyin":"gongzuojihua","path":"/cmsgaijin/gongzuojihua","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":22,"pid":13,"name":"炒股养棋","pinyin":"chaoguyangqi","path":"/chaoguyangqi","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":23,"pid":13,"name":"cx13","pinyin":"cx13","path":"/kaifariji/cx13","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":24,"pid":13,"name":"时限学堂","pinyin":"shixianxuetang","path":"/richanggongzuozaji/shixianxuetang","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},{"id":25,"pid":13,"name":"运营","pinyin":"yunying","path":"/richanggongzuozaji/yunying","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"}]},{"id":14,"pid":13,"name":"前端","pinyin":"qianduan","path":"/richanggongzuozaji/qianduan","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"}]

navSub------>{"cate":{"id":14,"pid":13,"name":"前端","pinyin":"qianduan","path":"/richanggongzuozaji/qianduan","sort":0,"target":"0","status":"0","list_view":"list.html","article_view":"article.html","seo_title":"","seo_keywords":"","seo_description":"","type":"0"},"id":14}

article------>{"id":100,"cid":14,"sub_cid":"","title":"CMS系统升级到最新版","short_title":"","tag_id":"","attr":"","seo_title":"","seo_keywords":"","seo_description":"","source":"","author":"","description":"明空的版本更新很快，所以抽时间把版本更新到最新版","img":"/public/uploads/default/2023/11/09/1699532940524_origin-mceclip0png","content":"<p>明空的版本更新很快，所以抽时间把版本更新到最新版<br><br></p>\n<h3>一数据库</h3>\n<p>新的数据库跟老数据库有所不同，所以本次的第一步工作是数据库同步</p>\n<ul>\n<li>将线上的老数据库与本地的老版数据库同步一下</li>\n<li>将新数据库表的结构同步到老数据库里</li>\n<li>将新数据库里几个新增的表的数据同步过来 \n<ul>\n<li>应当就是几个sys起头的表（具体可以自己观察）\n<ul>\n<li>sys_app</li>\n<li>sys_config</li>\n<li>sys_notice</li>\n<li>sys_role</li>\n<li>sys_user</li>\n</ul>\n</li>\n</ul>\n</li>\n<li>改动flag表里的数据type都为1</li>\n</ul>\n<h3>二 css改动以及logo替换</h3>\n<ul>\n<li>整体css背景  以及个性化列表还有广告的问题新增一个，这样不用改main.css\n<ul>\n<li>server\\app\\public\\template\\default\\css\\user.css</li>\n<li>把所有搜索到了 \n<div>\n<div>\n<pre class=\"language-css\"><code><main class=\"bg-f2f2f2\n改为：\n\n<main class=\"bg-primary </code></pre>\n</div>\n</div>\n</li>\n<li>新增user.css：<br>\n<pre class=\"language-css\"><code>/* 增加一个主色调*/\n.bg-primary {\n background-color: #066D52\n}\n\n/** 头图的连接 **/\n.swiper-slide a {\n display: block;\n width: 100%;\n height: 100%;\n object-fit: cover;\n}\n/* 一级列表项 */\n.article-cont ul li::before {\n content: \"\\265B\"; /* 使用Unicode字符表示国象后 */\n margin-right: 5px; /* 可以根据需要调整图标与文本之间的间距 */\n }\n \n /* 二级列表项 */\n .article-cont ul ul li::before {\n content: \"\\265E\"; /* 使用Unicode字符表示国象马 */\n margin-right: 5px;\n }\n \n /* 三级列表项 */\n .article-cont ul ul ul li::before {\n content: \"\\265F\"; /* 使用Unicode字符表示国象兵 */\n margin-right: 5px;\n }\n \n \n /* 广告 */\n .ad {\n max-width: 100%; /* 设置最大宽度为100% */\n }\n</code></pre>\n</li>\n<li> </li>\n</ul>\n</li>\n<li>logo.svg的替换</li>\n</ul>\n<h3>三代码改动</h3>\n<ul>\n<li>头图不能点击的问题\n<ul>\n<li> server\\app\\modules\\home\\view\\default\\index.html</li>\n<li>\n<pre class=\"language-markup\"><code> <div class=\"swiper mySwiper\">\n <div class=\"swiper-wrapper\">\n {{each slide}}\n <div class=\"swiper-slide\">\n <a href=\"{{$value.path}}/article-{{$value.id}}.html\" title=\"{{$value.title}}\">\n <img src=\"{{$value.img}}\" title=\"{{$value.title}}\" alt=\"{{$value.title}}\">\n \n </a>\n </div>\n {{/each}}\n </div></code></pre>\n</li>\n<li>server\\app\\modules\\home\\view\\default\\common\\meta.html 这个文件改成这样 </li>\n<li>\n<pre class=\"language-markup\"><code><meta name=\"viewport\" content=\"width=device-width, initial-scale=1\"/>\n <meta property=\"og:type\" content=\"article\" />\n <meta property=\"og:image\" content=\"{{base_url}}/img/logo.svg\"/>\n <meta property=\"og:url\" content=\"http://{{site.domain}}\"/>\n <meta name=\"author\" content=\"{{site.name}}\"/>\n <link rel=\"shortcut icon\" href=\"{{base_url}}/img/favicon.png\" type=\"image/x-icon\" />\n <link rel=\"stylesheet\" href=\"{{base_url}}/css/saduo@1.0.9.css\"/>\n <link rel=\"stylesheet\" href=\"{{base_url}}/css/swiper.min.css\"/>\n <link rel=\"stylesheet\" href=\"{{base_url}}/css/main.css\"/>\n <link rel=\"stylesheet\" href=\"{{base_url}}/css/prism.css\"/>\n <link rel=\"stylesheet\" href=\"{{base_url}}/css/user.css\"/></code></pre>\n</li>\n</ul>\n</li>\n<li>以及ad读取值的一个问题<br>\n<ul>\n<li>搜索所有frag.ad 然后改成下面这个</li>\n<li><img src=\"/public/uploads/default/2023/11/09/1699532940524_origin-mceclip0png\"></li>\n<li>\n<pre class=\"language-markup\"><code> \n <section class=\"ad mb-20 bg-fff\">\n \n {{@ frag.ad}}\n </section></code></pre>\n</li>\n</ul>\n</li>\n<li>title写上文章的标题<br><br>\n<ul>\n<li>D:\\git\\server\\cms\\server\\app\\modules\\home\\view\\default\\article.html</li>\n<li>还要取消掉导读</li>\n<li>\n<pre class=\"language-markup\"><code> </code></pre>\n</li>\n</ul>\n</li>\n<li>\n<div class=\"code-toolbar\">\n<pre class=\"line-numbers language-markup\" tabindex=\"0\" data-prismjs-copy=\"复制代码\" data-prismjs-copy-error=\"按Ctrl+C复制\" data-prismjs-copy-success=\"代码已复制！\"><code><html>\n\n<head>\n <meta charset=\"utf-8\">\n <title> {{article.title}}-{{site.name}}-{{site.title}}</title>\n {{include './common/meta.html'}}\n\n<body class=\"bg-f8f8f8\"></code></pre>\n</div>\n</li>\n<li>搜索所有的[详情] 改为【详情】</li>\n<li>搜索所有tag标签改为专题</li>\n<li>几个碎片的值在footer.html的连接\n<ul>\n<li> cms\\server\\app\\modules\\home\\view\\default\\common\\footer.html</li>\n<li> </li>\n<li>\n<pre class=\"language-markup\"><code><footer class=\"pd-20\">\n <div class=\"footer main center pd-20\">\n <div class=\"row justify-between\">\n {{@ frag['footer-fe']}}\n {{@ frag['footer-chess']}}\n {{@ frag['footer-7yi']}}\n {{@ frag['footer-guanyu']}}\n </div>\n <p class=\"mt-30 text-c f-14\">©copyright {{site.name}}{{site.json.siteSubtitle}}</p>\n {{@ frag.copyright}}\n {{@ frag.record}}\n </div>\n</footer>\n\n\n<span class=\"backtop none\">\n <svg data-v-2a8a074a=\"\" width=\"20\" height=\"20\" viewBox=\"0 0 20 20\" fill=\"none\" xmlns=\"http://www.w3.org/2000/svg\" class=\"\"><path data-v-2a8a074a=\"\" fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M5.00806 3.0625C4.70158 3.0625 4.45312 3.31095 4.45312 3.61743C4.45312 3.92391 4.70158 4.17236 5.00806 4.17236H14.9968C15.3033 4.17236 15.5518 3.92391 15.5518 3.61743C15.5518 3.31095 15.3033 3.0625 14.9968 3.0625H5.00806ZM10.3948 5.9997C10.1781 5.78297 9.82676 5.78297 9.61005 5.9997L6.07849 9.53126C5.86176 9.74797 5.86176 10.0993 6.07849 10.316C6.2952 10.5328 6.64656 10.5328 6.86327 10.316L9.44751 7.73182V17.3809C9.44751 17.6873 9.69596 17.9358 10.0024 17.9358C10.3089 17.9358 10.5574 17.6873 10.5574 17.3809V7.73182L13.1416 10.316C13.3583 10.5328 13.7097 10.5328 13.9264 10.316C14.1431 10.0993 14.1431 9.74797 13.9264 9.53126L10.3948 5.9997Z\" fill=\"#515767\" stroke=\"#515767\" stroke-width=\"0.5\"></path></svg>\n</span>\n</code></pre>\n</li>\n</ul>\n</li>\n</ul>\n<h3> </h3>\n<h3> </h3>\n<h3> </h3>\n<h3><br>四上传服务器：</h3>\n<h3> </h3>\n<ul>\n<li>数据库\n<ul>\n<li>本地数据库同步到线上会有一个问题。主要是线上版本的问题，线上是5.7,本地是8.1 主要是一个类型需要改成线上支持的类型，导出数据库为sql后，使用编辑器替换一下就行了\n<ul>\n<li>\n<pre class=\"language-markup\"><code>'utf8mb4_0900_ai_ci\n\n全部替换成\n\nutf8mb4_unicode_ci</code></pre>\n</li>\n</ul>\n</li>\n</ul>\n</li>\n<li>端口配置\n<ul>\n<li>需要的4000</li>\n</ul>\n</li>\n<li>上传代码\n<ul>\n<li>git代码到服务器上，在服务器运行</li>\n<li>\n<pre class=\"language-markup\"><code>npm i\n\nnpm run prd </code></pre>\n</li>\n</ul>\n</li>\n</ul>\n<p> </p>\n<p> </p>","status":0,"pv":418,"link":"","createdAt":"2023-11-09 20:02:37","updatedAt":"2025-05-21 16:37:53","field":{},"tags":[]}

article.tags------>[]

news------>[{"id":252,"title":"ollama运行命令","short_title":"","img":"","createdAt":"2024-11-23T07:55:32.000Z","description":"","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":173,"title":"新网站上线的后续工作预告","short_title":"","img":"","createdAt":"2024-04-11T07:03:05.000Z","description":"","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":154,"title":"Bootstrap框架的css定义说明 ","short_title":"","img":"","createdAt":"2024-01-28T05:11:47.000Z","description":"","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":125,"title":"界面设计要求","short_title":"","img":"/public/uploads/default/2023/12/30/1703937436442_origin-mceclip0png","createdAt":"2023-12-30T08:21:24.000Z","description":"","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":122,"title":"行棋记录验证正则表达式详解","short_title":"","img":"","createdAt":"2023-12-08T12:36:00.000Z","description":"","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":121,"title":"表格数据清洗","short_title":"","img":"","createdAt":"2023-12-07T02:46:21.000Z","description":"","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":114,"title":"开发依赖库说明以及项目配置信息说明","short_title":"","img":"","createdAt":"2023-11-29T01:23:34.000Z","description":"","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":113,"title":"编辑前端项目问题","short_title":"","img":"","createdAt":"2023-11-28T04:57:00.000Z","description":"","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":112,"title":"在线编辑excel","short_title":"","img":"","createdAt":"2023-11-27T09:15:03.000Z","description":"","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":103,"title":"表格结构识别结果说明文档","short_title":"","img":"","createdAt":"2023-11-10T10:00:26.000Z","description":"","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"}]

hot------>[{"id":46,"title":"Cocos Creator自适应宽度组件教程：ScaleWithParentWidth","path":"/cmsgaijin/qianduan"},{"id":100,"title":"CMS系统升级到最新版","path":"/cmsgaijin/qianduan"},{"id":74,"title":"微信小程序的一些问题","path":"/cmsgaijin/qianduan"},{"id":72,"title":"棋谱识别开发记录","path":"/cmsgaijin/qianduan"},{"id":112,"title":"在线编辑excel","path":"/cmsgaijin/qianduan"},{"id":50,"title":"cocos creator发布成微信小程序（非小游戏）","path":"/cmsgaijin/qianduan"},{"id":122,"title":"行棋记录验证正则表达式详解","path":"/cmsgaijin/qianduan"},{"id":17,"title":"七弈国象-研发记录（https://doc.7yi.link)上线","path":"/cmsgaijin/qianduan"},{"id":121,"title":"表格数据清洗","path":"/cmsgaijin/qianduan"},{"id":67,"title":"对禅悦CMS的代码显示功能进行个性化，让它变成自己习惯的风格","path":"/cmsgaijin/qianduan"}]

imgs------>[{"id":125,"title":"界面设计要求","short_title":"","img":"/public/uploads/default/2023/12/30/1703937436442_origin-mceclip0png","createdAt":"2023-12-30T08:21:24.000Z","description":"","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":100,"title":"CMS系统升级到最新版","short_title":"","img":"/public/uploads/default/2023/11/09/1699532940524_origin-mceclip0png","createdAt":"2023-11-09T12:02:37.000Z","description":"明空的版本更新很快，所以抽时间把版本更新到最新版","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":78,"title":"一次快乐的bug修改","short_title":"","img":"/public/uploads/default/2023/11/01/1698823694419_mceclip0.png.png","createdAt":"2023-10-31T23:26:39.000Z","description":"根据标识的位置直接进行了修正。非常感谢","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":75,"title":"首个用户反馈-来自Mr.上官","short_title":"","img":"/public/uploads/default/2023/10/29/1698545436900_mceclip0.jpg.jpg","createdAt":"2023-10-28T18:09:35.000Z","description":"进来以后，并没有感到自己注册成功，","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":74,"title":"微信小程序的一些问题","short_title":"","img":"/public/uploads/default/2023/10/27/1698441878047_mceclip0.jpg.jpg","createdAt":"2023-10-27T13:19:45.000Z","description":"\ndoc网站\n\ndoc网站中的导语不要展现出来了，对于现在快阅读的时代，已经不实用了\n广告宽度没有限制，影响页面内容页面的宽度\n\n\n小程序\n\n微信用户原有接口小程序不许再读取了，提供了让用户修改资料的方式来读取\n用户金币显示先取消，相关逻辑还没上线\n修改资料有问题，会错误判断资料没有修改\n按钮要配上声音\n\n上面这个只盖住了一半\n\n这个需要把动画加上\n完成开局以后在小程序中数据无法提交\nipad界面我的文字显示太小\n用户进入就注册，做到无感注册\n用户资料修改的web小程序内置版\n\n\n \n","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":72,"title":"棋谱识别开发记录","short_title":"","img":"/public/uploads/default/2023/10/25/1698207506409_mceclip0.png.png","createdAt":"2023-10-24T18:22:22.000Z","description":"一准备工作\n\n安装Python\n安装OpenCV\n//更新一下pip 在不翻的情况下，更新不成功\n\npython.exe -m pip install --upgrade pip\n\n//安装一下openCV python版本\npip install opencv-python\n\n安装Tesseract\n\n\n// 安装地址\nhttps://github.com/UB-Mannheim/tesseract/wiki\n\n//安装的时候，注意要选择复选中文的相关库\n\n//在系统环境变量里添加路径\n\nC:\\Pr","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":67,"title":"对禅悦CMS的代码显示功能进行个性化，让它变成自己习惯的风格","short_title":"","img":"/public/uploads/default/2023/10/13/1697179493540_mceclip1.png.png","createdAt":"2023-10-12T22:41:43.000Z","description":"1 要显示行号2 要显示代码复制按钮3 要背景黑色","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":61,"title":"如何在文章里插入其它网站的信息","short_title":"","img":"/public/uploads/default/2023/10/11/1696985332888_mceclip0.png.png","createdAt":"2023-10-10T16:46:42.000Z","description":" ","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":58,"title":"在微信开发工具调试小程序，一直拿不到用户信息","short_title":"","img":"https://res.wx.qq.com/op_res/rm8CjueDGoqfBrYaFIm5tNS8j1LciYO0i-XLEbXGAayNvR1VI_TVu62YeNPLSHICbMP6cmjX_dWagWQdRjXY8w","createdAt":"2023-10-09T19:21:44.000Z","description":"读取到的用户信息一直是微信用户，女原因：2023年8月，在用户隐私协议中没有设置相关信息读取","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"},{"id":47,"title":"cocos creator使用免费的图片打包工具 free texture packer","short_title":"","img":"/public/uploads/default/2023/10/04/1696407725293_mceclip0.png.png","createdAt":"2023-10-04T00:16:52.000Z","description":"简介：\ncocos creator的图集功能很不错，打包的软件一般都是收费的，找到一个网页版的打包网站 free textrue packer网站地址：http://free-tex-packer.com/app/","pinyin":"qianduan","name":"前端","path":"/cmsgaijin/qianduan"}]

pre------>{"id":78,"title":"一次快乐的bug修改","name":"前端","path":"/cmsgaijin/qianduan"}

next------>{"id":103,"title":"表格结构识别结果说明文档","name":"前端","path":"/cmsgaijin/qianduan"}

一 数据库

二 css改动以及logo替换

三 代码改动

四 上传服务器：

接口页面--全局数据：

一数据库

三代码改动

四上传服务器：