看板地图后端部署记录
一、后端代码部署步骤1、安装 jdk-8u221-windows-x64 ,mysql-installer-community-5.7.28.0,Navicat15 ,Redis2、后端代码idea 命令打包:mvn clean package -D maven.test.skip=true -P prod运行:java -Dfile.encoding=utf-8 -jar C:\Users\Ad
·
一、后端代码部署步骤
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 )
更多推荐
已为社区贡献1条内容
所有评论(0)