#spring.profiles.active=dev
spring.profiles.active=sap
#spring.profiles.active=prod
server.port=8080
#server.servlet.context-path=/spms
server.tomcat.uri-encoding=UTF-8

spring.resources.static-locations = classpath:templates/,classpath:static/
spring.mvc.view.prefix=
spring.mvc.view.suffix=.html
spring.thymeleaf.prefix=classpath:static/
spring.main.allow-bean-definition-overriding=true

pagehelper.helper-dialect=oracle
pagehelper.params=count=countSql
pagehelper.reasonable=true
pagehelper.support-methods-arguments=true

spring.datasource.name=druidDataSource
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.druid.driver-class-name=oracle.jdbc.OracleDriver
spring.jpa.show-sql=true

# \u63a7\u5236\u53f0\u6253\u5370\u6570\u636e\u5e93\u6267\u884c\u8bed\u53e5\u548c\u5165\u53c2\u6570\u636e\uff0c\u90e8\u7f72\u751f\u4ea7\u7cfb\u7edf\u53ef\u6ce8\u91ca\u6389\u0089
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
mybatis-plus.configuration.call-setters-on-nulls=true
mybatis.configuration.call-setters-on-nulls=true

#spring.datasource.url=jdbc:oracle:thin:@192.168.106.91:1521:spms
#spring.datasource.username=spms
#spring.datasource.password=Stdspms2020
#spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
#spring.datasource.max-idle=10
#spring.datasource.max-wait=10000
#spring.datasource.min-idle=5
#spring.datasource.initial-size=5

spring.jackson.date-format=yyyy-MM-dd HH:mm:ss
spring.jackson.time-zone=GMT+8

#spring.datasource.druid.url=jdbc:mysql://127.0.0.1:3306/spms_prod?useUnicode=true&useSSL=false&characterEncoding=utf8
#spring.datasource.druid.username=root
#spring.datasource.druid.password=root

# CentOS Mysql database
#spring.datasource.druid.url=jdbc:mysql://192.168.106.90:3306/spms_prod?useUnicode=true&useSSL=false&characterEncoding=utf8
#spring.datasource.druid.username=spms
#spring.datasource.druid.password=Spms2020

# IBM Cloud Mysql database
#spring.datasource.druid.url=jdbc:mysql://sl-us-south-1-portal.37.dblayer.com:61510/spms?useUnicode=true&useSSL=false&characterEncoding=utf8
#spring.datasource.druid.username=admin
#spring.datasource.druid.password=OQJRUURHAMXVHVAA

# \u914d\u7f6e\u76d1\u63a7\u7edf\u8ba1\u62e6\u622a\u7684filters\uff0c\u53bb\u6389\u540e\u76d1\u63a7\u754c\u9762SQL\u65e0\u6cd5\u8fdb\u884c\u7edf\u8ba1\uff0c\u2019wall\u2019\u7528\u4e8e\u9632\u706b\u5899
spring.datasource.druid.filters=stat,wall,log4j,config
# \u5f00\u53d1\u73af\u5883 Oracle \u914d\u7f6e\u53c2\u6570
spring.datasource.druid.url=jdbc:oracle:thin:@192.168.106.91:1521:spms
spring.datasource.druid.username=spms
spring.datasource.druid.password=Stdspms2020

# \u6d4b\u8bd5\u73af\u5883 Oracle \u914d\u7f6e\u53c2\u6570
#spring.datasource.druid.url=jdbc:oracle:thin:@192.168.106.91:1521:spms
#spring.datasource.druid.username=stqspms
#spring.datasource.druid.password=Stqspms2020

# \u751f\u4ea7\u73af\u5883 Oracle \u914d\u7f6e\u53c2\u6570
#spring.datasource.druid.url=jdbc:oracle:thin:@192.168.106.98:1521:spms
#spring.datasource.druid.username=spms
#spring.datasource.druid.password=Stpspms2020

spring.datasource.druid.max-active=100
spring.datasource.druid.initial-size=1
spring.datasource.druid.max-wait=60000
spring.datasource.druid.min-idle=1
spring.datasource.druid.time-between-eviction-runs-millis=60000
spring.datasource.druid.min-evictable-idle-time-millis=300000
spring.datasource.druid.validation-query=SELECT 'X' FROM DUAL
spring.datasource.druid.test-while-idle=true
spring.datasource.druid.test-on-borrow=false
spring.datasource.druid.test-on-return=false
spring.datasource.druid.pool-prepared-statements=true
spring.datasource.druid.max-open-prepared-statements=50
spring.datasource.druid.max-pool-prepared-statement-per-connection-size=20


swagger.enabled=true

#\u5f00\u53d1\u6d4b\u8bd5\u73af\u5883\uff0c\u5bf9\u5e94SAP\u7684\u6d4b\u8bd5\u73af\u5883 - MQ\u914d\u7f6eIN
project.mq.host=192.168.106.36
project.mq.queue=IBM.SERVICE.POSUPDATA.REQUESTER.IN

#\u751f\u4ea7\u73af\u5883\uff0c\u5bf9\u5e94SAP\u7684\u751f\u4ea7\u73af\u5883\uff1b
#project.mq.host=192.168.106.33
#project.mq.queue=IBM.SERVICE.POSUPDATA.REQUESTER.IN
project.mq.port=1415
project.mq.queue-manager=PIP_IN
project.mq.channel=SVRCONN_GW_IN
project.mq.username=
project.mq.password=
project.mq.ccsid=1208
project.mq.receive-timeout=60000


#\u5f00\u53d1\u6d4b\u8bd5\u73af\u5883-MQ\u914d\u7f6eOUT
project.mq.out.host=192.168.106.36
project.mq.out.queue=SUNDA.SPMS.DATA.TEST01

#\u751f\u4ea7\u73af\u5883\uff0c\u5bf9\u5e94SAP\u7684\u751f\u4ea7\u73af\u5883\uff1b
#project.mq.out.host=192.168.106.34
#project.mq.out.queue=SUNDA.SPMS.DATA.CN01
project.mq.out.port=1418
project.mq.out.queue-manager=PIP_OUT
project.mq.out.channel=SVRCONN_GW_OUT
project.mq.out.username=
project.mq.out.password=
project.mq.out.ccsid=1208
project.mq.out.receive-timeout=60000

#\u7f13\u5b58\u8bbe\u7f6e
#spring.cache.ehcache.config=classpath:echcache.xml

# SAP\u5f00\u53d1\u6d4b\u8bd5\u73af\u5883;\u901a\u8fc7 Http \u534f\u8bae\u6765\u5b9e\u73b0 RPC - \u8fdc\u7a0b\u8fc7\u7a0b\u8c03\u7528
feign.client.url = http://esb.sunda.top/
#\u8bf7\u6c42\u8fde\u63a5\u7684\u8d85\u65f6\u65f6\u95f4
feign.client.config.default.connect-timeout=180000
#\u8bf7\u6c42\u5904\u7406\u7684\u8d85\u65f6\u65f6\u95f4
feign.client.config.default.read-timeout=900000

# SAP\u751f\u4ea7\u73af\u5883;\u901a\u8fc7 Http \u534f\u8bae\u6765\u5b9e\u73b0 RPC - \u8fdc\u7a0b\u8fc7\u7a0b\u8c03\u7528
#feign.client.url = http://192.168.106.42:9998/


# SPMS \u7cfb\u7edf\u63d0\u4f9b\u7ed9 OA \u7cfb\u7edf\u901a\u884c\u8bc1
oa.token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJleHAiOjE2MTc3NTY2NjJ9.Z5DGPyA10VBF1WC77GprP-Llv-O8ySHhmRUGV-h7tU0

# \u5f00\u53d1\u6d4b\u8bd5\u73af\u5883 OA \u5ba1\u6279\u6d41\u5bf9\u5e94\u6d41\u7a0bID
oa.workflow.id0703=580
oa.workflow.id1201=589
oa.workflow.id3601=592
oa.workflow.id0915=520
oa.workflow.id3302=668

oa.workflow.id3168=653
oa.workflow.id0733=651

#\u4e34\u65f6\u7d27\u6025\u5904\u7406\u65b9\u6848\uff0c\u5c06\u6a21\u677f\u6587\u4ef6\u653e\u5230\u670d\u52a1\u5668\u8def\u5f84
template.file.path=/root/spms-templates
excelCache.file.path=/root/spms-templates/ExcelCache


# \u751f\u4ea7\u73af\u5883 OA \u5ba1\u6279\u6d41\u5bf9\u5e94\u6d41\u7a0bID
#oa.workflow.id0703=240
#oa.workflow.id1201=262
#oa.workflow.id3601=353
#oa.workflow.id0915=520


# \u914d\u7f6e\u90ae\u4ef6\u670d\u52a1\u5668\u7684\u5730\u5740
spring.mail.host=smtp.263.net
# \u914d\u7f6e\u90ae\u4ef6\u670d\u52a1\u5668\u7684\u7aef\u53e3
spring.mail.port=25
# \u53d1\u9001\u4eba
spring.mail.sender=Sunda_SPMS@sunda.com
# \u914d\u7f6e\u7528\u6237\u7684\u8d26\u53f7
spring.mail.username=Sunda_SPMS@sunda.com
# \u914d\u7f6e\u7528\u6237\u7684\u5bc6\u7801\uff08\u5373\u7533\u8bf7\u5230\u7684\u6388\u6743\u7801\uff1a263.net\u5185\u8bbe\u7f6e-\u8d26\u53f7\u5b89\u5168-\u5ba2\u6237\u7aef\u6388\u6743\u7801\uff0c\u5f00\u542f\u540e\u81ea\u52a8\u751f\u6210\uff09
spring.mail.password=BE9d5E0E987a9c9B
# \u914d\u7f6e\u9ed8\u8ba4\u7f16\u7801
spring.mail.default-encoding=UTF-8
# SSL \u8fde\u63a5\u914d\u7f6e
spring.mail.properties.mail.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory
# \u5f00\u542f debug\uff0c\u8fd9\u6837\u65b9\u4fbf\u5f00\u53d1\u8005\u67e5\u770b\u90ae\u4ef6\u53d1\u9001\u65e5\u5fd7
spring.mail.properties.mail.debug=true

spring.redis.host=192.168.106.92
spring.redis.port=6379
spring.redis.password=Sunda2013@
#spring.redis.database=0

#SAP\u88c5\u7bb1\u5355client
zxd.sap.client=SAP-530

#\u5f53\u524d\u7cfb\u7edf\u5206\u652f\u5bf9\u5e94\u7684SAPclient\uff1a\u975eIPO\u96c6\u56e2=300\uff1bIPO\u96c6\u56e2=310\uff1b\u9676\u74f7\u96c6\u56e2=320
sap.client=SAP-500