看板地图后端部署记录

一、后端代码部署步骤

1、安装 jdk-8u221-windows-x64 ，mysql-installer-community-5.7.28.0，Navicat15 ，Redis

2、

后端代码idea 命令打包：

mvn clean package -D maven.test.skip=true -P prod

指定jdk版本 打包

步骤1   set JAVA_HOME=C:/Program Files/Java/jdk1.8.0_212

步骤2  mvn clean package -D maven.test.skip=true -P prod

运行：

java -Dfile.encoding=utf-8 -jar C:\Users\Administrator\Desktop\ruoyi-admin.jar

前端:

# 打包正式环境
npm run build:prod

3、nginx 拷贝解压后

浏览器内网输入地址：localhost:70

nginx 配置文件内容

#user  nobody;
worker_processes  1;

#error_log  logs/error.log;
#error_log  logs/error.log  notice;
#error_log  logs/error.log  info;

#pid        logs/nginx.pid;


events {
    worker_connections  1024;
}


http {
    include       mime.types;
    default_type  application/octet-stream;

    #log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
    #                  '$status $body_bytes_sent "$http_referer" '
    #                  '"$http_user_agent" "$http_x_forwarded_for"';

    #access_log  logs/access.log  main;

    sendfile        on;
    #tcp_nopush     on;

    #keepalive_timeout  0;
    keepalive_timeout  65;

    #gzip  on;

    server {
        listen       70;
        server_name  127.0.0.1;

        #charset koi8-r;

        #access_log  logs/host.access.log  main;

        location / {
            root   html;
            index  index.html index.htm;	
        }
	 
 

        #error_page  404              /404.html;

        # redirect server error pages to the static page /50x.html
        #
        error_page   500 502 503 504  /50x.html;
        location = /50x.html {
            root   html;
        }

        # proxy the PHP scripts to Apache listening on 127.0.0.1:80
        #
        #location ~ \.php$ {
        #    proxy_pass   http://127.0.0.1;
        #}

        # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
        #
        #location ~ \.php$ {
        #    root           html;
        #    fastcgi_pass   127.0.0.1:9000;
        #    fastcgi_index  index.php;
        #    fastcgi_param  SCRIPT_FILENAME  /scripts$fastcgi_script_name;
        #    include        fastcgi_params;
        #}

        # deny access to .htaccess files, if Apache's document root
        # concurs with nginx's one
        #
        #location ~ /\.ht {
        #    deny  all;
        #}
    }


    # another virtual host using mix of IP-, name-, and port-based configuration
    #
    #server {
    #    listen       8000;
    #    listen       somename:8080;
    #    server_name  somename  alias  another.alias;

    #    location / {
    #        root   html;
    #        index  index.html index.htm;
    #    }
    #}


    # HTTPS server
    #
    #server {
    #    listen       443 ssl;
    #    server_name  localhost;

    #    ssl_certificate      cert.pem;
    #    ssl_certificate_key  cert.key;

    #    ssl_session_cache    shared:SSL:1m;
    #    ssl_session_timeout  5m;

    #    ssl_ciphers  HIGH:!aNULL:!MD5;
    #    ssl_prefer_server_ciphers  on;

    #    location / {
    #        root   html;
    #        index  index.html index.htm;
    #    }
    #}

}

 sql修改记录

 
 
----  应收单分录  判断  应交日期 和 账期开始日期 大于15天的数据
  select  a.* from   (  select datediff(DD,CFPaymentDate,CFBeginDate)    as  chaday  ,fid , CFBeginDate  开始日期,  CFPaymentDate 应交日期  from  CT_ACC_ReceiveBillEntry  )  a  where a.chaday>15

   
----将应收账单应交日期不对的(应交日期提前开始日期超出15天的)更新为正确
   update  CT_ACC_ReceiveBillEntry set  CFPaymentDate= dateadd(day,-15,CFBeginDate)   from  CT_ACC_ReceiveBillEntry  where  fid  in  (    select  a.fid from   (  select datediff(DD,CFPaymentDate,CFBeginDate)    as  chaday  ,fid , CFBeginDate  开始日期,  CFPaymentDate 应交日期  from  CT_ACC_ReceiveBillEntry  )  a  where a.chaday>15  )



----  收款单分录
  
select  a.* from   (  select datediff(DD,CFPaymentDate,CFBeginDate)    as  chaday  ,fid , CFBeginDate  开始日期,  CFPaymentDate 应交日期  from  CT_ACC_PaymentBillEntry  )  a  where a.chaday>15

----将收款单分录应交日期不对的(应交日期提前开始日期超出15天的)更新为正确

   update  CT_ACC_PaymentBillEntry set  CFPaymentDate= dateadd(day,-15,CFBeginDate)   from  CT_ACC_PaymentBillEntry  where  fid  in  (    select  a.fid from   (  select datediff(DD,CFPaymentDate,CFBeginDate)    as  chaday  ,fid , CFBeginDate  开始日期,  CFPaymentDate 应交日期  from  CT_ACC_PaymentBillEntry  )  a  where a.chaday>15  )