升级V3.2.4指南

从V3.2.3版本与V3.2.4版本相关步骤，相关数据库脚本更新如下：

1、数据库

更新文件：

src/main/resources/db/migration/upgrade/mysql/V3.2__upgrade.sql（这里只提供mysql的升级脚本、DB2/Oracle查找对应目录下的脚本更新)

-- 指定脚本运行的数据库
use ${database};

-- 2024-09-27 增加系统定制表（用于系统标题、logo、favicon）
create table sys_custom
(
   id                   varchar(40) not null comment '定制id',
   name                 varchar(50) comment '系统名称',
   title                varchar(50) comment '浏览器标题',
   login_name           varchar(50) comment '登录名称',
   banner               mediumtext comment '系统banner',
   favicon              text comment '系统favicon',
   create_by            varchar(40) comment '创建者',
   create_time          datetime comment '创建时间',
   update_by            varchar(40) comment '更新者',
   update_time          datetime comment '更新时间',
   primary key (id)
);
alter table sys_custom comment '定制标题、banner等信息';
-- 初始化默认配置脚本
INSERT INTO sys_custom (id,name,title,login_name,banner,favicon,create_by,create_time) VALUES ('1839203673165033472',' | 基础框架','卓信数据-基础框架','基础框架-登录','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJQAAAAgCAYAAAD0Z1G3AAAAAXNSR0IArs4c6QAAAERlWElmTU0AKgAAAAgAAYdpAAQAAAABAAAAGgAAAAAAA6ABAAMAAAABAAEAAKACAAQAAAABAAAAlKADAAQAAAABAAAAIAAAAABc8CVTAAANC0lEQVR4Ae2aCZRXVRnAGRVEUGQJWQRHBNESXBMVQUFzJU1TE1M8KmW5G2REAmFZ2cn1lKAm7pkLHDjiAmQdoNgSoyJRFEQYUBZBRUtAkH6/x7ty582bgWFmAOX/nfObe9/d73e/991733+KatWQrF+/fmeaPghOTDmMsCnUhiCfEvkAXoe/wDiYUlRUtJqwIAUN1KqFIe0F18Hr8AlURtZReDncCu2hqKDTHVQDLP6ecDUshuqQ/9LI3dByB1XpjjttFv0gmAyfwuaI5daCHmwVaDyGa8D0uB0N9HTYOaXgtbZjU6vy4rDI3ZnfCGi0iXl6XpoNY2EyvAKLYCVnJppJtrf6PDcDz16d4GTw7OU4J8A6+BjeAev/DV6FNbRh+wX5PGsAIzgRNnVOepsy/WGPLZkr9erCxTAb8uR/JI6Bs6HOlvRRqLMdaIDFOwzcqsqTZWRcAvWqY7i0UwdOgrmQJ26TGm9viG+S1dF9oY2a1AAL1hRegTxxYZ+G5jUxBtptCDfBOBgLU+FNWAF6S/ufAgfURP+FNqtZAyyUB56fQZ547Xexd6rmbitszv6gERwMveBFeBm6wlYdSzxQ+vYi4QvQME7fVNwxQ5nzbZq+Wds6ZT0q2Hep8mkbu1Q0Bso4bm/tW3RMqajtMnl0si+8B1nRM9xYpsI2SmAsLeA0aLCNhuA3uf1B7zkfdoVdsuSNjTI/hKFQHPKJ+33vAXgEShlJVEZDOAs6wUBYCOeCt+SesBscCHr1G6CM0dpWWmYW4ej02XE7l/YVYL6XqsoJlfpAnjjR3AFWrocvTmn0cXikqMnEJ2aYwHMp78WzZ0XPpr6g3YI2iHvM8AJi+nkhPQ5Jb5Xme4F5AZTB4HnWzzFHwWWgPA+560X6MeBus8D2CTUk+61IknFV6PriwaYNO4De2XSeF8MPvP7n5O3oSepEvR2Vowjzds2kX8GzFxk/qbjtfD3Kf4n4cXA56X4+CbKCyFR4GyZBO9gTlI5ge4NgOlwDyuQK1iusYwgdv/jZxjHEffNYqzPoNYsstNnCJFpQeA5kb25XMLh7NrshCtKWA7gPuvgIz9HG9YRbVRjHbXT4DXAMMxjDt7ZkALTjb5fFUDeq7ze0x9Ln8wk/ifKMqstZ9OlCqRPPLG9BY3gIekJscGG9wkKTnUgJfw+Gp8DfThXLen5cm4ZrCM0/FtrCcngPFMtqiJfCE9ABvgyO1/Qp0B/83bUH6ECCWPfP0Bp6bpaHSpW1FxXOglhhPCbWOspIJcXJHgNOTtHKt4X4ATWMYbcqDMCz2rOwH6hkxTkGeZRIMARDORNjmmmBVMeeQTUm5UkogXhLDPVD+5ZT3gANRk+1BL4E4ZzlGmsY70Mz2BsU+5HQ1odpXI8Y9FCbeDdYBfat19N4wviJJvU/M/pyDSqdYBMqnAC94QhwcmEARBOZy1+tvaoSlFXVdqpSvypj0Hj8bwqV+w9YCrGoN9v34OrLszPsDkGOJdI3PBAugtvhIWgD5ckojPK3ZrJmvQhcrxEQDIpo0u8wwtVwCvirwuVgn5eCvzq4xqafC12hH+iRLGe69Ry/humzDsY5rATX37aX5hoUA2tL5s1wBqiAPPGNmAm/YkK+AdUqjMHF+Sbofm1/CjxLX9n9W0UeRN7Z0BIWgG57PmXLGAhl9yGvGyhjwXnkCmVd8G7g1qVnngfP0G7WWEguJct4WlgqZePDHkRdEBcjkbSfh3nIrofGeSToWcqTt8ygDb3K/XCBj+B21giGw9fgHNAIFI3bOWgwyljm5EugeFjX0/0IPiDdb4oHELeO6UeAXnAaHA6XU+ZJwrJCxXYwGso70c8j7w44BOxgi4X6fifxNhLEASZCQj/wVpIVfzy+MirXjOdp2UI8O/6HoV5Udg+es3Oz3IcQpMTyPLQBb2TedLLiuAaHdkNIWhPwNlUZOSuqfxsVP4J30gY6EnrjOxm88peHC+yYd4I7YTn4i8LjsAjOAL9H2b4S1nYY8ZeTlNIHf9vyluc81c1Q8DOG9cT2nWfQjWWWBpL58FAbrgQnlJWPSRgOh0I9qJIhRQrMNSjabw1hsE7gDfgPrAbH51vhpOvDaxDEPP8Hy6t1kAFpWZU9JiSmoe1ljTYYlMbhl3fFcipslQ+pWO+4MJe0j9igriW/azmcQ3rQc2xQfpjtBLNA6QjNwQWsSMaFcVCoLXgDHAj+amDd88FvU73AXzc0OvPeT0P1tX86B9fkXtAQYxnPQzAoDUjCGqmXlQE/WOl6B8FPYCcbTkW3ORr6w2u4Nd301pD2dBLGsY74YBgDzcEt4d+gXAi6YkVXfArMhQNhEmj4viS/IWwHJ0OQPxG5GtzGnoNW8JkwVxfiIhKs9wKoCw35cVBf4lljIsQSXrZbSXTsinWVkGfoVlZK6NOPxW47oZz5bkmO00N2nlg26MP88+CXENpoTPyPoHwEncGX5nRIjIjQ+qYpjvU7EPTvceB2sO7xMA9OAEW9fQX6wihQilygMyFrTBrPVTCMiXp+2ZryEp2pSG8Uju8RWAoa9y1QhOJVmMoL4rnEs4KKUClBoQ2JuxjOMaS50AOZ1+uEejqVVMqgTEemQgsYBhq5fWhIQdqGSBp6E3oagpGb3AA0RPv+F6xI447RccyFiqQlmYMh7jcubzv/ZA7TmY+L7pnwHPgq2NcD0AWOhjkwj3J+NL2f+K9BuZc0x65oQOrYs1ZvWExef8oPJq7UhwHgurQC5SJwjmthqBl3QLBIoonczN/7aGxreaW0WzRfVKT77EKCC6liHJve6bvQC3rARHCxgtQmUhweCFW0ooKcg4YRxBckHEZDWqmQ/vcjYTy0TjNsbzno0YKuPltkyncnXQ/pQVhDDOK4DwMNaiaUQCwXUlfDfox5O9as+EJozPafzbfNOrAbOH/FPpomsQ23rwnEXXDr/5g+NCbrxU7C7Y+sIv9Y7kaeNcDLwBfO8scYR5yzhhbE8pYVZYYVsuJe6UBrVOgj9wxlp+T5m5SeaB8YAOE8Q3T9q2Deoz6k4iGxM3SI8AziJcPz03UQxPnp8hMhPjlkECYLTvhMlLaA+L4WJowP3WOSBjakPxaVr2y0hAp6Y9v3COL8FMd/RBJbv34koQtbStI86zcyg9C59oAZEIvz0Rgscx7EZ0fPyMEgLGKZo8Ez0nxwnTxvKS9sCJLfEz3vBSak6d/TQ/kGh7fO9hy4A1ziw9YWBqbneRnegSEwHrrDCaAkiiG8E74Njt1tzXPL3bAS9ArNoQ9vnQY0krie2LnJQ6RZviUcBVnZO0rwLVRx1xM2idLj6IM8LAbLxuLWoYdwjE9CYrCEsczhYVWckBPXS13AGOL2g1fKFldvbqWHgHNVToPuVD+T8CpwPPeAc1dXL5LnDvAUeC5S16Guu4UG/z7oAU+F3aExBNk1RLTGMZAVLbFGvRTtZz3U30nzDbsFgmgM4TZhmvFLHDyhXmwgxG8bj8ltJIQXpGX1aENMzBH7CLIwLX9DSEjDUCYei+eVCoW6+4G3RKVDhYXJpIwearaFkdhDbUjJ/7uQZG+I6vN5CGN8l3gf6Ad684mgmP878D8PWsIcUKaDaX+AMN9JxDU2RS+c9fSWC2Ut83091HUwGWKL0wpt4Cre8GXEa0J82zxsF6eNhzdcL2NeT/A8oEdaC/Php/AMeNZSMb8gOgP6gwvmS6DH/QAs9xJY1sn2JarBXAO+cZZ7BR6EPuCh2zdQcQx6qYvBM4rnl5EwHfqBerPupsRx6zHU7aa8kG0570Xg2c0+HeNKeA1GQyzq5VrQG62D1fAItAW9zwgoSedu2eNgKPwcnibd9t3ujiccBENI8/kJ4upyFqhfvdnv0/ihhB7+p4G6DV5Mj6YX1Yslb0ZXGtKis+JHNg+O9ZKC1fiHNl3lvaF9SrO4edL0QM3At7xJnJcXp8yeaVnfOhWYK+T5f0mtoQUEhZRXtgFl2kB8Acgtm5dIPT1uQ2gM5Y4prku5plAMfhtUB9atH5cJcdLrQO3oWZ1qAGWEdPN8OSot1PMF0oPan+OpGzfCs57N9I27Gg/FMA7yxA97N0OpRY8bLcQLGiijAQzGt+Ik8NtGvDfymIhpb8JdcCps0ZtbpuNCwhdGA7kuH0PZnRkeCZ6v3GMbQlbc7z0jeC5xP50Ks8EzwNuwgj3Zvb3Kwngcp2ccb02toC24nx8Iz8FdnhUIC7KNNZBrUGFMLKT7vgvoB8YLoTP4SWHjXslDJC5qOCB6CF0Bi1M8gC8DD8we7DxEejC0vHu7fWnIej0PsU2heYqGFM4RtvsujIXhMBNj8uBakO1AAxUaVHZ86RZ3AOkdoAt0gn1BA/PgZnuVapPyeaJhesPR2DQWPd9fQS/oTWwBRqR3LMh2poEqLz5G5i1DL9YGWkPLKPSDox7Na7rex7Jha9LTaCxeNWUJuF26hZbAfHgLlhe2M7TwOZH/A1RrvoYx645OAAAAAElFTkSuQmCC','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJoAAABACAIAAABtOPkJAAAUk0lEQVR4Ae2cB3AcVZrHO86MNMrZliVbso2zMcYEl5dkohdYOAxUnWGv6ggHLNRx7JILliq4JdYWvjMcsc7ALRgwy5HOgMEYimQccMRB2BbOylma0Ol+rbba7RlJsN6RPJLVHrdev37x+78vvO+9fqJlWcLQNVgoIA2Wjgz1w6bAEJyDahwoydwb1ICrCkRBEPk/dPVKgWSBM2Ja9WGzOmRVtunbm43d7WZd1GyKGhFTFDqVuyJaGaqUF5CKU+WxGVJZUB4elPMCcmqy9KBXMvfXS/HomkIdulXRoq+sM1bURLe06Hs6rHpNjBiCZVqCaB3izS5yiKIEk6qimKmYxanCuAx1Rq4yM1+ZmKVk+4cUBzRzxVkXyfrhL2DtatOX7dc+3K+tqNNqIoJuiYJpeqp27O14q9sWuvxzWBZoRdHK8YlTs+RfF6tnD/NPzlbUYxjW/oYTfHa2GIsqw/+7V9/YZGg6XAg2ABmPnAfc3oKgaytVgC3PkOcUyfPKAifmKT7JjjzWrn6Fc2+b8ZfKyKuV2uZW09RNQTTjxWkcAKACYF0cB3K2OOFnj4KDie2nzmQ8S0JRQLhypHrNaP/UHKWTkeOKHLwR/QRn1LCW7I3M3xb9stYwDVDsnR0dbGRBEiXRzFKEgCJnB6Q0RfCJVqZspStClio2ala7YdXrom5JrZrQFrXaIkaTicqVwWt0uvBv49WrR/myjiWd2h9w1oSM+VvCz+3QG8KGYBqHuCqWS0DRtnR8spzlF48LWuOy5LKgNClTzPNLRalyuirJouWTJFkS4DvNFBgUDBTTspqjVmPU2t9hbGo2d7aZmxv1rR2yZkrnFZj3T02dnmsDfCxcfQ7nxkb9vnXhDw7opo7BCpbxF+oTWapIklicKk3PFmcXylNy1OMy5MKApHRJ2fhsPcVoJriaO1qNNXX6x9WWaJlzR8jl6YqiiJJl+WUxVRGDipCuipmqGDiCCnqqOAni+xbOb2uiv18bXlFnCUa0BzWJdpN9qjIlQ7pgmDSnWJmUrWb6EuMwwH5uipqrarXPq6LfNIgVYSUU1f2WniqaGT6xKEUalaGWBsXx6SLznNJUOZUJUBJA8vc0oQ/h/OxA5NY1UaSfoEd6aKIEyzBxnFcqXVjiL0/vK5GIqbSlWX9vd+SNPeamJkvHnBYM23qSJIR/mmqVpPsnpVlnFiizCpTxmUoAUT4wr76Cc3Vt9IZV4e8bBUEPd0cZdKR8XIb0T+XqvDLfyDSlH6YVKNpdrfqindHnd2q7WjHHOiW/YxJ3Ws4+n1zi12cX+f5hhDqrQIWDu2t5Usf1CZwVzcaNq8PLq3VB65YvpYCqzC1Rbp8UOD5b6WcBB2N+V6vN3xL5vEZHm6OacT61GbgwRF2QTUHBvsr0WWcUiNePVmYP86FokxrAwxuXeDjbNPNfV7Yv3CUIGnwJS8SQQxkWlG4b57v2uEDO0ZtC1IXN7+s1vInId0MU6sOGZgltmlgdEepCxsYWa1dE8gvWOXnmTeNSpuep/SA8DsflCJ8SDCdj/8WK0G3r9PYwto8ej+XEbOWRaYHflPqOsL19nw3DuDZsVIWEH5r15QciUU2YOypw3ghfcCCwaYLh3NCg//bb0IZGQzAQs7F8eXyO8h8nBc4oSl4sY0YL7Lu7jeUdY0K2Mjzlb58zxRTX94+JXF4yLGvh9giSyp6WxGE5OVd56qTArwoHDJYQ3y8LYzNlfsx5BsSVyBG3rl57r8pgHhDr97HkEanyw1P9AwtLL34DRXcmDE486u/s1Xe2Yf0wAfCKWTHFp/xhou/iUr+XQEPhvqBAwuDc02Z8UqXba5a2e929cOCpc0uVfx4bcKOGAn1HgYTBuape29YuCobWuVblNJgZnVKWJt80VsFv13d9GCrZpUBi4MRQWFGnN0ditoOIgiz/ZoR0cv5AMn9c0gzEQGIs26aItb7JsgwcoV4iSKVB9YqRasI9eJFIZNOmTa2trbJsu3lN0/T7/ZMmTUpPT/dWn1Thn376ad26dWzlYdeEYRg0+OSTTy4oKEhsIxMDZx3zbs12sNjLJq7XTpRn5llTc9TEtpjSampq7rnnnvXr16uqXbiu68XFxc8999yMGTMSXleiCvz000/vuOMOTdMkSQLOnJychQsXnnPOOYkq3yknAXBi025p0utCzE9wfHaxp2X5/L5Tc6X0xKMpQI7q6mpAdWkBrlDKfUzCAGOuo6MjGmVGbl+pqan0wgkn8H6EcMKEuD23txjrG3W05qpGs65DEw5Ntu1VzEyfMC4T3dwFcOJajbxiZc1bHo+Mem9MsoVpHs12W0XY++jG/52Bw4jys2WBYn3EWFevf11vrqjV1zWyN0cJ2+5ZjCGmKKwgKoKEQjMV1Tc1UxqX2VdLmD/b1GMzwS+FM6RbSNRPDkSXVgubmo2ajs7lX6YlVhRGtH+yL10RiwNWWYYyLdOcmi1Pzmat/+hzDCJu165d+/btQ7hhQwUCARilqKiovLwcidcL6pgtTU1NO3fubGhoICPynKu0tHT48OG9Z0Tsb9++fceOHWTHOhs9evTkyZOxfXqpy31FIw8cOLB79+7Gxsa2trZwOBwMBmlzWloadtOoUaN6r/rn4WzTrG9rtb/u1j6t1neHZS2CimLTVacRK6qSImb45PJUa2auPCNfmZ4tjQiyR4sXhwSL29Z+DqCoPvzww3fffff777/fv38/8EAsR0oD50knnXTVVVedeeaZ3Urpurq6t956a+nSpRs3bmxubsZ4JhlXSUnJlClTLrvsMqwYqBzfIzI+88wzb7755t69e8EV2xv4qYiqHTs8Posbs2fPnpdeeumzzz778ccfGYWoW6deMvp8vvz8/NNOO+2aa66h5W6W2ACd7Onq0IyP94b/8cvW/L+2CH9pEl6uE16qFhZWCS/VCq80BBc1n/x/zSxtfrA7vKNF13Q21PXThdE/ffp0b08YtitWrPBWDyGeeuopSOBNFhPGHobu3lxOeO3atZdeeim8GJPefcQuveuuu2CgmLzw8bXXXhuvFBlD8Ja3QBr28ccfe7PDzRdeeKFbRU8BGD2mp95CeuTOimZ9wdbQW/vMqg486njvnEmIhFDNCshn5Uu/Hs5ivcwHQOyN66nuoxi/Zs2aJ598sra21mkDVJgzZ05KSspXX331+eefAzbxSOBHH330hBNOGDNmjNtUWOTuu++G1m4MqJMAebt58+aWlhbigW3+/PmZmZm33367FyQY+vXXX4e+bl4nAJ957fCYtzxS+IIFC5YsWeK+YkwMGzYMzobFQRrB67xiwv3CCy8gIbqVut3Ayc7VN3+K/Hkblo4pGLrtg+WHVSapmX5ldqH02zLf2cOUDN/R14tu5+MDy5cvhwpu/M0333zjjTfyWFVV9cQTT1RWVsJhEAuVBindZND9xRdf9GJ54okn/ulPf2JGC1nffvvt++67D6YkPbkQqmedddapp57qZK+vr3/jjTfa29vd0ij8lFNOAZXVq1d7G+MmcAOI6C1btmRnZyOTQ6EQzUCYP/jggyNHjmRwgB9hXjnpv/76a6yBCRMmuNndQCyc7bq5YGv4sS0ajh7BxGR1UmJks2VS+sME/6Ul6kDcVw6hocv48eMh2S233AKbEoDcDpu65ECMf/DBB+4jnHfbbbedf/75Tsx11133zTffvPrqq84jI+OTTz5x4ayoqNi2bZubl8Dll1/+8MMPI2aRB1TaC6K5ubmPPPIIAwIuhPVRnFQ6duxYBg1I007UtgsnFpYjJLx1OeHD4MR8/fcNofnbjXAYpnTGAnhKfp9/3kjpjkmBCXxgMECu008/vaysDC502gtBQQI7EyChHdYm8uqMM86YNWsWVobbJyQtRpP7SGKsEoYCZO20hCTMIvct/Lpq1So4yTGvgBPSu28LCwvRo1jCxFxwwQVXXHEFgt19GxPAqkLmE8mYAy3MqK1btyK6Ea04v+BF6vJmIZn30Q0fBs8rO8L/WaGHNbB0t/lIPp//d2OUP04NDCymxCN66623PvTQQwx5p7cYuk4YYkEjJCdiECGM/mP4O2kQpF7CwStIWod2joHjsoiTHtIjXVGiPIK06/ThkUivSxZWAzMmHk7G+Dt5GXDvvPPOhg0bGFW4vXBKu8movScI3TQEDsG5tl6fX6F3RJ1PD7qsG4mvdpQ/Hh/ISm5N6e2SE6b/N910Exbva6+9Bt9g9UBuOMkrXZnhwTEw8bx585xcTAkc2NwCmfB5JyTQlDTcSQYA2CMg5MCJZIaD3fJJw+WWwzjwPrrxTgDuxxR6/PHHXduNeAqn/UxLaAC98KIbk919PAgn+8Lf2hX5EevJ5suuS+SzdfHmseqAw9LpAFL0kksuwaAFNrwBqC5k7w8//IBhArpOGvjvvffeu+iiizIyMoiBn1xO5REsUX6IQcwTHkELygIkmHEHAyiODnaKwgAmPfzqPKICYTIsaucRtUp6Jxx//+6774DTxZKKUBY33HDDtGnTMKqZmWAwx+eKjzkIZ2WL/tF+zYh6sCStKJ9dwNc/hzg4Pn9yxsAxSFQoiyJEGILZ7NmzsUJpLQyK4cpk3J05INZI4MAJJGg7F2zygq5r7IAijE4hwMYdTUzAdQ6QEa3swolgf/rpp3E7YJ2ynLJ48eJeaOUdYSTD5EZsYBUThq2//PLLnmyfmDIPQsUnV1VRfHVI2q4EFhMTJYtvuLrkbteLAfAXuYpl/8UXXxCAsZCKF198MaYjsouB7zhc3G5MnDiRSYvzCPUxR1euXOnoSO6PPfYYHDlz5kyGCPPC559/HlBxvPEK1XvvvffiV3LyYl7BTF7zFZ8UVgw2ERNWJIRbY3yARjo1Oq8YRnijKJCmvv/++8yIYgR1jEZwCzwIZ5oqBCXvHh9Yk4FhMu0ciFdeXh4SEgHl2jVMP5C048aNgzuRXUhCp18jRoyYO3euqx0hEw45uAGTxEkAO15//fXAjKiEa90CeQt43skfzHr11Vczhlz7FuAxTblIjGalcK+t5JTv3GktfiJX2GKR3XnnnS+//DJig6FALvK6iAK8I/y9JRwMk4irPmTMXdYkvNIoLKy2PXkHf/XnLW3lY1snTfLc4QBYytsZOAB3j7eFSCf8cEg/b7KYMNYma8gQ3ZuRMABceeWV3bpdnBKysrJwSjDvjMkIByMVwDWmIpqHXeZMWpxXyHZGmJsdMwc73OtgcktAnjPJYei4Mcj/+++/H6nuZncDB7kzJyDNK/cvb9Qb2p0ZpyNhja/qzcU/RX43PsUtKxkC0AKWYkQ7U0YYDmkJybxtg6YPPPAAQvKjjz5ynHPQGtkFSFywL15f5CqFxAsu9qk8++yzzGSWLVuGtET0OZKQ6igW6wZNfO6558bDBqGZ9sDxixYtYsIKK4MQIgFVjfccojMQKYQGYwyzDOA2GMxACLxZMGA5hYy0ivIZcHiP8fjTGMp0WJzxB5bofseidgshcIiFW6Pm79eEXqzkc8xw16e1KFJldIa6YIZvTkk3qwfegvozDF3oML1CEVIvAToPmeKB4S20g42QWogsZBSeAS7YC0S7Te/tCPAjAMlFIU4VaE2sX8dv4E0ZE4bW2GLUSKsAibocDBgWlEP7uQNGDDsSj+2GaebACcbYRDSVwokBQqfBJKMc4l0d4dZ+CE6icLv/y3ehL/hYmg9s7e2yDo8qEzKlB6cFLi31J3wTl9uOoUBCKHAYnJTIToM71oY+ZRcO35lgCOF557LkgqB8/Rj1xrH+EZwfMnQlKwVi4aSd21v0BzdGFu+3wnxAZX881LlrRJSQDKcVSIB6TqGalzK0ayQZIe0GTprZGjX+Z2f0v3aYW1o4z4nFTjaRoEfZ0KWkB9RZ+fIVJdLsYWpJEJ9YMvbqmG1T93BCDuBb36D9947o2/vMfSEWy1j7BFQWPiX2d6UHfFMyzPOHyecVKcdlKJzhNARrMoyhHuF0GqcZ1so6bfFufUmVUdkh6ngBWTizf5ytxYFN4vAUeUqW+KtcaaZ95ofM9/HJuTkhGWjdD234GTidFkQMa1OjsfSAtuSA+UOL1YhOxRmos7jNFgVbiSqqWuy3RqcJU3OV6Zkiy6LDU6X8gDwgDq9kkxMGHysp/UDuvq7iF8HpNqI6ZKyu05dVm9/U6RWtVosuGiyrQgeYlT3T+HdZc5CM7FRlTKowMV0oz1DGp0ulafb5XRy0laJ0eoCPKt1oJkchs+miTRM4+o228HUbR0YNDqHyt8Hp4MphEHvbzY1N+re1+qp6fUdIrmnXOjgAhAHu7GchAMC25aTmK1aequcG5OKgNC5dKgpIHAeV5bMPUIOO7N/k3nfTWcMSGiNm2LBP7ONDmqaosLfdiJpC2DQL/OLYDNuay0/hy4tBwZter5DLgr88gLHbHDEr24zNTfraRmN7m7WtSa+Oiu2WrLFay8crNqTwLjLZPjtRtgxJMAIy5wqBq5irCgHZGhkU81gbl8QCv1SQIgZkkSVmMM7xyUFVIgFmlkNsUDE4S1ywiEhR7AFDmRHDDBkCp1Y3RYyGqC0jOFKmOmRWR/GkwIJmJfjZx3yJnO5VFlRGpcuTs5TRmUq+nx3CaP9f3t0BkPJIuLPbbkFHDsA70GHCuBWt+o+t5s5WY39EQtES365bGgpXYueqjYcNBRS2Z7SdAYgK2LLEbJYjDxkKQVlIU0S/KKB97d2ujAeQs715tmAHXZ99wJNIiCUfzZTDltBucjCQJRqRVMkuijNTCxSjNChw7OaYNKU8DfEgF6ZwimrnCOu2DwM/MmFwxpCCVRhkGoKuusPaHzJqw2ZNmIB9b4gYLZrZHDVbokJElE2OM7WhhYc50LKTWezT/DmWtgt0ewTYl3tGMWFOPVUNLVXisESJs21z/UJBiowKLAwIhX52/0rDUqVcP0xsy/OD+TsLGdy3voKzW6rhO2bBBk5FPIZ1W0jCcKi3IyM3xguSmR88HVTsw4vlQSY6uyVir5H9CmevLRl6mQAKJPVO9gT07xgrYgjOQQX4EJxDcA4qCgyqzvw/RojQLMESS7cAAAAASUVORK5CYII=','admin',now());

-- 添加系统配置菜单、视频组件菜单
INSERT INTO sys_permission (id,name,parent_id,`type`,icon,url,component,perms,is_route,is_use,is_visible,is_search,sort_num,remark,is_deleted,create_by,create_time) VALUES ('1840279450182823937','视频组件','44e2db3602e2428cbb0f2f98f1bc066d','0','link','/demo/dplayer','demo/DplayerDemo','demo.dplayer',NULL,1,1,NULL,50,'',NULL,'admin',now());
INSERT INTO sys_permission (id,name,parent_id,`type`,icon,url,component,perms,is_route,is_use,is_visible,is_search,sort_num,remark,is_deleted,create_by,create_time) VALUES ('1839936315072712706','保存','1839936201939750913','1','','','','SysCustom:Save',NULL,1,1,NULL,10,'',NULL,'admin',now());
INSERT INTO sys_permission (id,name,parent_id,`type`,icon,url,component,perms,is_route,is_use,is_visible,is_search,sort_num,remark,is_deleted,create_by,create_time) VALUES ('1839936201939750913','系统配置','ac62ef18339d48c0b0e3b13a31a54ac7','0','configuration','/admin/sysCustom','admin/SysCustom','SysCustom:View',NULL,1,1,NULL,70,'',NULL,'admin',now());

2、后端升级

2.1、waf-parent依赖升级

后端只要将pom.xml中引用waf-parent版本改为3.2.4即可，启动后测试功能是否正常

  • 依赖更新
<parent>
    <groupId>com.wiseda.waf</groupId>
    <artifactId>waf-parent</artifactId>
    <version>3.2.4</version>
</parent>
  • ymal配置更新

因网页中显示系统的小图标favicon在没登录前就需要访问，这里通过配置匿名接口来取消认证

# 配置匿名访问接口
waf.server.exclusions: ${WAF_SERVER_EXCLUSIONS:/v3/waf/sysCustom/favicon}

3、前端升级

具体的更新可以去对照waf-web的更新

3.1、mutation-types.js

文件目录：src/store/mutation-types.js，常量定义，用于没有配置的默认值

// 在系统未配置时，显示在banner后面的系统名称
export const SYS_NAME = '基础框架'
// 在系统未配置时，浏览器标题
export const SYS_TITLE = '卓信数据-基础框架'
// 在系统未配置时，登录页面标题
export const LOGIN_NAME = '基础框架-登录'

3.2、user.js

文件目录：src/store/modules/user.js

import { SYS_NAME, SYS_TITLE, LOGIN_NAME } from '@/store/mutation-types'

// 设置定制信息
SET_CUSTOM_INFO: (state, customInfo) => {
    state.sysName = customInfo.name || SYS_NAME
    state.sysTitle = customInfo.title || SYS_TITLE
    state.loginName = customInfo.loginName || LOGIN_NAME
}

// 在ssoLogin里调用
ssoLogin({ commit, dispatch, state }) {
    commit('SET_CUSTOM_INFO', data)
}

3.3、index.html

文件目录：public/index.html，移除title的内容，由配置来动态设置

<title></title>

3.4、App.vue

文件目录：src/App.vue

// 在created中设置favicon
created() {
    // 设置系统图标 favicon
    const apiPrefix = process.env.VUE_APP_BASE_API + process.env.VUE_APP_WAF_API
    var link = document.querySelector("link[rel*='icon']") || document.createElement('link');
    link.type = 'image/x-icon';
    link.rel = 'shortcut icon';
    link.href = `${apiPrefix}/sysCustom/favicon`;
    document.getElementsByTagName('head')[0].appendChild(link);
}

3.5、login/index.vue

文件目录：src/views/login/index.vue，从store中获取loginName、sysTitle属性


<h3 class="title">{{loginName}}</h3>

data() {
    loginName: ''
}

created() {
    // 设置系统登录名称
    this.loginName = this.$store.state.user.loginName
    // 设置页面 title
    document.title = this.$store.state.user.sysTitle
}

3.6、TabLayout.vue、HomeLayout.vue

文件目录：src/components/layouts/TabLayout.vue、src/components/layouts/HomeLayout.vue，菜单布局与首页布局设置页面 title

created() {
    // 设置页面 title
    document.title = this.$store.state.user.sysTitle
}

3.7、HeaderBar.vue

文件目录 ：src/components/layouts/components/HeaderBar.vue，设置banner图片地址，设置系统名称

注意： 这个banner跟系统名称的样式或位置根据系统需求自行修改，这里只提供获取定制的sysName、bannerUrl


<div style="display:flex;align-items:center;margin-left:5px;cursor: pointer;">
    <img :src="bannerUrl" style="vertical-align:top;height: 32px;">
    <div class="head_logo_title">{{sysName}}</div>
</div>

import Vue from 'vue'
import { ACCESS_TOKEN } from '@/store/mutation-types'

const apiPrefix = process.env.VUE_APP_BASE_API + process.env.VUE_APP_WAF_API

data() {
	sysName: '',
	bannerUrl: `${apiPrefix}/sysCustom/banner?token=${encodeURIComponent(Vue.ls.get(ACCESS_TOKEN))}`
}
          
created() {
    this.sysName = this.$store.state.user.sysName
}

.head_logo_title{
  margin-left:9px;
  font-weight:bold;
  font-size:18px;
  letter-spacing :5px;
  color: white;
}

3.8、系统配置功能页面

系统配置的功能页面，主要将设计的几个表字段，通过页面来进行维护。

# 文件列表
src/api/admin/sysCustom.js
src/views/admin/SysCustom.vue
上次更新:
编辑者: 李贤伟