厦门轨道项目
来自ling
目录
常用代码
rm -rf /app/apache-tomcat-8081/webapps/vat.tar.gz tar -zcvf /app/apache-tomcat-8081/webapps/vat.tar.gz --exclude=/app/apache-tomcat-8081/webapps/vat/WEB-INF/lib --exclude=/app/apache-tomcat-8081/webapps/vat/WEB-INF/classes /app/apache-tomcat-8081/webapps/vat
文档
文件:厦门轨道交通信息化二期（资产一体化） TAX INTERFACE 20180508.xlsx 文件:VPN系统登录步骤V1.4.pdf 登陆地址改为https://120.42.49.156
开发环境
账号 kj或xmlena
[系统版本库信息]
后台服务[增值税系统后台]
<服务项目（USR）>[http://172.16.150.103/svn/1c1bcc4f11/Insight_Tax/VAT/b_2.0.0.xiamenrail20180419/srv_vat_usr]
<服务项目（PUB）>[http://172.16.150.103/svn/r_0c590868/Insight_Tax/VAT/b_2.0.0.xiamenrail20180419/srv_vat_pub]
<WEB项目（USR）>[http://172.16.150.103/svn/1c1bcc4f11/Insight_Tax/VAT/b_2.0.0.xiamenrail20180419/vat]
<解决方案项目（PUB）>[http://172.16.150.103/svn/r_0c590868/Insight_Tax/VAT/b_2.0.0.xiamenrail20180419/sln_vat]
前端应用[增值税系统前台]
<应用（用户）>[http://172.16.150.103/svn/1c1bcc4f11/Insight_Tax/VAT/b_2.0.0.xiamenrail20180419/app_vat_usr]
<应用（发布）>[http://172.16.150.103/svn/r_0c590868/Insight_Tax/VAT/b_2.0.0.xiamenrail20180419/app_vat_pub]
[开发数据库实例]
MySQL
<路径>[jdbc:mysql://172.16.150.80:3306/a4cfe11ac9?autoReconnect=true&useUnicode=true&characterEncoding=GB2312&useOldAliasMetadataBehavior=true]
<账户>[a4cfe11ac9]
<密码>[@363B41@])
Oracle
<路径>[jdbc:oracle:thin:@172.16.150.75:1521:xe]
<账户>[dtt10]
<密码>[dtt10])
[应用服务器地址]
服务器01
<路径>[http://172.16.150.163:8081])
[应用地址]
前端应用[增值税系统前台]
<路径>[服务器地址/服务路径/vat]登录界面变更
客户环境安装
环境信息
cj_wangxun1/Wangxun0419
您好：
已在堡垒机上设置好您的账号：cj_wangxun1 初使密码：a.12345678-->Wangxun0419，可以登录https://10.3.71.32/ 进行访问，具体操作可以参考附件《用堡垒机登录服务器远程桌面》。
在云平台中已设好如下服务器：
i-A75BD5F9 税务管理系统正式环境应用服务器 10.4.173.108
i-616255D6 税务管理系统正式环境数据库服务器 10.4.173.107
i-50C9A4C4 税务管理系统预发环境 10.4.173.106
i-2C6F2D3A 税务管理系统测试环境 10.4.173.105
均已关联到堡垒机对应账号中。
云平台服务器的相关设置可以参考附件《WINDOWS服务器防火墙管理》、《云平台服务器基础操作》、《服务器安全设置说明 V1.1》测试环境
应用(tomcat)：
- BASE 10.4.173.105:10010/BASE
- VAT 10.4.173.105:10040/VAT
- LTS 10.4.173.105:10050
- RPT 10.4.173.105:10030/rpt
- MIS 10.4.173.105:10060/mis
数据库（oracle）
base 10.4.173.105:1521:orcl user/password : TMS_BASE/TMS_BASE
Vat 10.4.173.105:1521:orcl user/password : TMS_VAT/TMS_VAT
LTS 10.4.173.105:1521:orcl user/password : lts/lts
RPT 10.4.173.105:1521:orcl user/password : TMS_RPT/TMS_RPT
MIS 10.4.173.105:1521:orcl user/password : TMS_MIS/TMS_MIS
预发环境
应用(tomcat)：
- BASE 10.4.173.106:10010/BASE
- VAT 10.4.173.106:10040/VAT
- LTS 10.4.173.106:10050
- RPT 10.4.173.106:10030/rpt
- MIS 10.4.173.106:10060/mis
数据库（oracle）
base 10.4.173.106:1521:orcl user/password : TMS_BASE/TMS_BASE
Vat 10.4.173.106:1521:orcl user/password : TMS_VAT/TMS_VAT
LTS 10.4.173.106:1521:orcl user/password : lts/lts
RPT 10.4.173.106:1521:orcl user/password : TMS_RPT/TMS_RPT
MIS 10.4.173.106:1521:orcl user/password : TMS_MIS/TMS_MIS
正式环境
应用(tomcat)：
- BASE 10.4.173.108:10010/BASE
- VAT 10.4.173.108:10040/VAT
- LTS 10.4.173.108:10050
- RPT 10.4.173.108:10030/rpt
- MIS 10.4.173.108:10060/mis
数据库（oracle）
base 10.4.173.107:1521:orcl user/password : TMS_BASE/TMS_BASE
Vat 10.4.173.107:1521:orcl user/password : TMS_VAT/TMS_VAT
LTS 10.4.173.107:1521:orcl user/password : lts/lts
RPT 10.4.173.107:1521:orcl user/password : TMS_RPT/TMS_RPT
MIS 10.4.173.107:1521:orcl user/password : TMS_MIS/TMS_MIS
数据库安装
sqlplus / as sysdba alter user sys identified by "a.12345678"
TABLESPACE
create TABLESPACE DELOITTE_TMS logging datafile 'C:\app\Administrator\oradata\orcl\DELOITTE_TMS.dbf'size 500M autoextend on next 500M maxsize unlimited extent management local segment space management auto;
TMS_BASE 执行执行base对应的建表语句 执行的顺序为 ibz.sql ----->应用vat_table.sql ----->应用vat_view.
create user TMS_BASE identified by TMS_BASE default tablespace DELOITTE_TMS;
grant connect,resource to TMS_BASE;
grant dba to TMS_BASE;LTS
create user lts identified by lts default tablespace DELOITTE_TMS;
grant connect,resource to lts;
grant dba to lts;RPT
create user TMS_RPT identified by TMS_RPT default tablespace DELOITTE_TMS;
grant connect,resource to TMS_RPT;
grant dba to TMS_RPT;TMS_VAT
create user TMS_VAT identified by TMS_VAT default tablespace DELOITTE_TMS;
grant connect,resource to TMS_VAT;
grant dba to TMS_VAT;TMS_MIS
create user TMS_MIS identified by TMS_MIS default tablespace DELOITTE_TMS;
grant connect,resource to TMS_MIS;
grant dba to TMS_MIS;sqlplus / as sysdba
create TABLESPACE DELOITTE_TMS logging datafile 'C:\app\Administrator\oradata\orcl\DELOITTE_TMS.dbf'size 500M autoextend on next 500M maxsize unlimited extent management local segment space management auto;
create user TMS_BASE identified by TMS_BASE default tablespace DELOITTE_TMS;
grant connect,resource to TMS_BASE;
grant dba to TMS_BASE;
create user LTS identified by LTS default tablespace DELOITTE_TMS;
grant connect,resource to LTS;
grant dba to LTS;
create user TMS_RPT identified by TMS_RPT default tablespace DELOITTE_TMS;
grant connect,resource to TMS_RPT;
grant dba to TMS_RPT;
create user TMS_VAT identified by TMS_VAT default tablespace DELOITTE_TMS;
grant connect,resource to TMS_VAT;
grant dba to TMS_VAT;
create user TMS_MIS identified by TMS_MIS default tablespace DELOITTE_TMS;
grant connect,resource to TMS_MIS;
grant dba to TMS_MIS;密码过期
sqlplus / as sysdba ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; alter user TMS_BASE identified by TMS_BASE; alter user LTS identified by LTS; alter user TMS_RPT identified by TMS_RPT ; alter user TMS_VAT identified by TMS_VAT; alter user TMS_MIS identified by TMS_MIS ;
服务安装
安装脚本示例文件:Dtt server boot.rar 更多参考Gts交接#winsw方式运行项目 Tomcat配置#正确 Tomcat配置#修改服务启动内存tomcat8w.exe
http://10.4.173.105:10010/BASE
http://10.4.173.105:10060/misTax/
初始化
ibizutil/initsystemenv.jsp update T_SRFLOGINACCOUNT set ISENABLE =1
登录系统
ibizutil/installrtdata.jsp
服务发布
以105环境vat发布为例,其他环境和系统类似
- 更新代码
- 删除maven目录repository\com\deloitte\tms\vat
- maven install 打包为xxx.war
- 登录堡垒机https://10.3.71.32/ ,打开远程桌面
- 进入应用程序目录D:\server\tomcat_10040_vat\webapps 将xxx.war复制到这里并解压覆盖原有内容.然后删除xxx.war
- 复制D:\server\configs\vat中的配置文件到D:\server\tomcat_10040_vat\webapps\vat\WEB-INF\classes 更新配置
- 进入服务.重启DELOITTE_VAT服务
webservice
- 进项费用单据接口(增,删,改)：http://10.4.173.105/vat/soapService/vatCRexpence?wsdl
- 申请单接口：http://10.4.173.105/vat/soapService/syncCRReqData?wsdl
- 红冲作废接口：http://10.4.173.105/vat/soapService/syncCRCreditReqData?wsdl
- 根据最后更新时间，获取客户主信息接口 http://10.4.173.21:801/Services/OracleERP/CUXARCONCUSTOMVService.asmx http://10.4.156.16:800/Services/OracleERP/CUXARCONCUSTOMVService.asmx
- 根据最后更新时间，获取客户地址信息接口 http://10.4.173.21:801/Services/OracleERP/CUXARCONCUSTADDVService.asmx http://10.4.156.16:800/Services/OracleERP/CUXARCONCUSTADDVService.asmx
- 根据最后更新时间，获取客户银行信息接口 http://10.4.173.21:801/Services/OracleERP/CUXARCONCUSTBANKVService.asmx http://10.4.156.16:800/Services/OracleERP/CUXARCONCUSTBANKVService.asmx
- 合同接口：
测试环境：http://10.4.173.79:901/BiztalkContractGet.asmx 正式环境：http://10.4.173.42:901/BiztalkContractGet.asmx
ContractProcess#process
- 更新费用单据状态--状态是已过账
测试环境：http://10.4.173.21:801/Services/OracleERP/CUXTAXAPINVOICEVService.asmx 正式环境：http://10.4.156.16:800/Services/OracleERP/CUXTAXAPINVOICEVService.asmx
USRtMSVATCRExpenceHEditViewEditFormHandler-->CRExpenceProcess
- B2-调用税务管理系统费用单据关联发票界面（郑） http://192.168.0.115:10040/vat/XMLogin?token=aWJ6YWRtaW4=&forward=vat/jsp/creditinvoicemgt/tmsvatcrexpenceheditview.jsp?srfkey=7720ce24-10fd-4a96-927a-4a57efbc8a68
- 费用单据删除USRTMSVATCRExpeInvovatSysGridViewGridHandler#onRemove释放发票,USRTMSVATCRExpenceHService#releasePolH
- 科目余额表 税务系统 GetCUXTAXGLBALANCESVPage 根据期间，获取科目余额数据
测试：http://10.4.173.21:801/Services/OracleERP/CUXTAXGLBALANCESVService.asmx 正式：http://10.4.156.16:800/Services/OracleERP/CUXTAXGLBALANCESVService.asmx
TrialBalanceProcess process=new TrialBalanceProcess();
process.trialBalanceProcess();
{"inf":"trialBalanceProcess","sys":"","period":"2018-06"}
- A5-手工开票申请发票信息回传（郑）
USRTmsVATDrInvPolHService.issueInvoice-->ReqInvoiceInfoProcess
- 用户组织机构 测试:http://10.3.51.21:804/Services/UUVUserServices.asmx 正式:http://10.3.51.22:804/Services/UUVUserServices.asmx
{"inf":"xiamen_org_all","sys":""} {"inf":"xiamen_org_t+7","sys":""} {"inf":"xiamen_user_all","sys":""} {"inf":"xiamen_user_t+7","sys":""}
new XiaMenRailWayUserProcess().processUser(beginDate, endDate);
new XiaMenRailWayOrgProcess().processOrg(beginDate, endDate);
- http://10.4.173.79:901/BiztalkContractSet.asmx B3-税务管理系统回写费用单据关联发票结果（郑）
用户组织机构
select * from T_BASEORG t;
select * from t_baseuser t;
select * from t_base_orgdept;
select * from t_base_dept;
select * from t_base_role;
select * from t_base_role_member;
select * from t_base_user_dept_org;
select * from t_base_user_org;
select * from t_srforg;
select * from t_srforguser;
select * from T_SRFORGSECTOR t
select * from T_SRFORGSECUSER t
select * from t_srforguserlevel;
select * from t_srfuser;
select * from t_srfloginaccount;
select * from t_srfuserrole;- 删除子系统的机构数据
delete from t_baseorg; delete from t_srforg;
- 保证手工录入的数据的机构名称不要和正式数据相同(界面修改并保存会同步到子系统)
- 同步机构数据
select count(1) from T_BASEORG t ORDER BY T.CREATEDATE ASC; select count(1) from t_srforg t ORDER BY T.CREATEDATE ASC;
- 再次同步,保证前后数据量不变
清单
- 进项费用单据接口 测试:http://10.4.173.106/vat/soapService/vatCRexpence 正式:http://10.4.173.108/vat/soapService/vatCRexpence
- 申请单接口 测试:http://10.4.173.106/vat/soapService/syncCRReqData 正式:http://10.4.173.108/vat/soapService/syncCRReqData
- 红冲作废申请单接口 测试:http://10.4.173.106/vat/soapService/syncCRCreditReqData 正式:http://10.4.173.108/vat/soapService/syncCRCreditReqData
- 基础信息接口 测试:http://10.4.173.106/vat/soapService/baseInfo 正式:http://10.4.173.108/vat/soapService/baseInfo
lts配置
- 添加支持参考添加lts支持
- lts.tasktracker.cluster-name=rnd_cluster 必须为 rnd_cluster
- SpringAnnotationJobRunner中实线对应inf的调用
{"inf":"RegisteClient","sys":""}
- lts.tasktracker.node-group 表示节点类型,规则建议为 vat_ip_port
百旺接口
助手 客户端
--eureka.instance.perferIpAddress=true --eureka.instance.hostname=10.101.18.244 --eureka.instance.instance-id=10.101.18.244:10080
--eureka.instance.perferIpAddress=true --eureka.instance.hostname=${spring.cloud.client.ipAddress} --eureka.instance.instance-id=${spring.cloud.client.ipAddress}:${server.port}
eureka.instance.prefer-ip-address: true
eureka.instance.instance-id: ${spring.cloud.client.ipAddress}:${server.port}
助手 服务端
正式: http://10.4.173.109:9008/SKServer
http://10.4.176.15:9008/SKServer XMGDCW/GD123456 终端号码:33498200005237 纳税人名称:厦门轨道集团测试/915000007471502986 bw_client_10080 10.1.23.144:10080 bw_server_10070 10.4.173.105:10070
10.1.23.144/administrator/215215215
http://10.4.173.105:10070/ http://10.1.23.144:10080/swagger-ui.html
--eureka.instance.perferIpAddress=true --eureka.instance.hostname=10.4.173.108 --eureka.instance.instance-id=10.4.173.108:10070
税控服务器ip地址变化
D:\server\bw_server_10070\winsw.xml
中的配置不知道需要改不
打印服务器和终端配置
- 所有配置和助手服务端没关系,服务器助手在taxurl.properties中体现
- 打印设备定义
- 打印服务器
- 打印终端,注意这里的终端标识天ukey上的编码
开具报文
<?xml version="1.0" encoding="utf-8"?>
<business id="10008" comment="发票开具">
<body yylxdm="1">
<kpzdbs>33498200005237</kpzdbs>
<fplxdm>004</fplxdm>
<fpqqlsh>d2879ea6-17cd-4a26-b9ea-153eb555ce6a</fpqqlsh>
<kplx>0</kplx>
<tspz>00</tspz>
<xhdwsbh>915000007471502988</xhdwsbh>
<xhdwmc>厦门轨道集团测试</xhdwmc>
<xhdwdzdh>厦门市思明区厦禾路1236-1238号 0592-2365589</xhdwdzdh>
<xhdwyhzh>厦门银行总行营业部 83300121050000117</xhdwyhzh>
<ghdwsbh>123456789012345679</ghdwsbh>
<ghdwmc>厦门钢之亿贸易发展有限公司</ghdwmc>
<ghdwdzdh>世纪大道120号 021-296742</ghdwdzdh>
<ghdwyhzh>中国工商银行上海分行 12345</ghdwyhzh>
<qdbz>0</qdbz>
<zsfs>0</zsfs>
<fyxm count="1">
<group xh="1">
<fphxz>0</fphxz>
<spmc>标书费用</spmc>
<spsm/>
<ggxh/>
<dw/>
<spsl/>
<dj/>
<je>106</je>
<sl>0.06</sl>
<se>6</se>
<hsbz>1</hsbz>
<spbm>304990000000000001</spbm>
<zxbm/>
<yhzcbs/>
<lslbs/>
<zzstsgl/>
</group>
</fyxm>
<hjje>100</hjje>
<hjse>6</hjse>
<jshj>106</jshj>
<kce/>
<bz/>
<skr/>
<fhr/>
<kpr>超级管理员</kpr>
<tzdbh/>
<yfpdm/>
<yfphm/>
</body>
</business>mantis
0005285: 小税种增加组织切换功能
以下两个问题，导致小税种无法选择到组织：
- BASE同步至小税种的组织，ENABLE全部=0；
- T_BASE_USER_DEPT_ORG没有同步；
进项接口
http://www.ip138.com 可获取对外ip
accessid:ChinaRailway19Th
密钥：%$$#)G)CLh`o4gx9u`zn
正式授权账户：xm_gdjt 密钥：@xbg0+vdIpIqsXqz(YkM
税号（taxno）：91130681695855178T
名称：中铁十八局集团第一工程有限公司涿州机械厂
可测试接口内容
1、初始化
2、取数
3、取数结果反馈
4、确认抵扣申请（用一张已认证过的专票测试，发票代码：1300162130 发票号码：07585479）
5、抵扣结果反馈
6、获取全票面
7、获取系统时间文件:02增值税发票进项管理平台接口协议说明V2.0.7.pdf 文件:百望云-进项通道平台-对外服务接口规范V2.1.docx
配置基本信息
有个 BaiwangInterfaceUtil.java 类，里面有2个参数
/**通道id*/ private static String AccessKeyID = "Baiwang_SupplyChain"; /**通道加密密钥*/ private static String AccessKeySecret = "yHXe)nLy$1Hx8AsFyVPc";
这个要跟百望确认下账号是哪个
重置数据
此任务只需要在上线时执行一次
任务参数是 {"inf":"initIF"}
配置取数任务
然后LTS里配置一个任务
任务参数是 {"inf":"CrIntSta"}
86400000ms
哦，好像那个java代码现不用改了，那个是当时测试用的，只要在vat里按税号配置就行
我截图给你看卡
在这个菜单里配置
还有就是要把服务器对外ip给百望
他们要设置ip白名单
你本地也已修改下这个测试类，测试接口连通性
com.deloitte.tms.vat.vat.util.Test.javaSpringAnnotationJobRunner
{"Success":false,"Code":"006","Message":"IP不在授权范围内：183.250.211.37"}
Caused by: java.security.cert.CertificateException: No subject alternative names matching IP address 60.205.132.83 found
进项发票获取流程
sc.setConditon(TMSVATCRIntSta.FIELD_ISUPDATEDINFORM, YesNoCodeListModel.ITEM_1); sc.setConditon(TMSVATCRIntSta.FIELD_ISSUCCESS, YesNoCodeListModel.ITEM_1);
0005699: 发票抵扣管理，发送抵扣后，状态一直在处理中
- 设置
enableDedu = 1 #0=Baiwang, 1=Daxiang crTunnel = 0
- 抵扣的数据
SELECT m1.* FROM V_TMS_VAT_CR_DEDU_L m1 WHERE L_PARENT_ID IS NOT NULL AND IS_PROCESSING = 1 AND PROCESS_RESULT = 0 AND TASKNO IS NOT NULL
- 发送抵扣确认
USRTMSVATCRDeduHService#sentToOrigAccou USRTMSVATCRDeduHService#sendValidDedu crInvPolInterface#applyDedu
- 获取抵扣结果
USRtMSVATCRDeduHGridViewGridHandler#deduResult crInvPolInterface#deductibleResult
- 问题查找
选择有发票的数据,断点打以下位置 CrInPolHInterface#applyDedu
进项的sql
select t.BILLING_DATE,t.CLAIM_DEDUCTION_STATUS,t.DEDUCTION_STATUS
from T_TMS_VAT_CR_INV_POL_H t where t.BILLING_DATE between to_date('2018-10-01','yyyy-mm-dd') and to_date('2018-10-31','yyyy-mm-dd');
select t.POST_STATUS,t.DEDUCTION_STATUS
from T_TMS_VAT_CR_INV_POL_H t where t.BILLING_DATE between to_date('2018-10-01','yyyy-mm-dd') and to_date('2018-10-31','yyyy-mm-dd');
select t.POST_STATUS,t.DEDUCTION_STATUS
from T_TMS_VAT_CR_INV_POL_H t where t.BILLING_DATE between to_date('2018-11-01','yyyy-mm-dd') and to_date('2018-11-30','yyyy-mm-dd');
select t.IS_CENT_DEDUCT,t.IS_COLLECT,t.PERIOD_NAME from T_TMS_VAT_CR_DEDU_H t;
select t.POST_STATUS , DEDUCTION_STATUS,TMS_INVOICE_STATE,t.BILLING_DATE,t.TMS_VAT_CR_INV_POL_HTYPE from V_TMS_VAT_CR_INV_POL_H t
where t.POST_STATUS=1 and t.DEDUCTION_STATUS=0
and (t.TMS_INVOICE_STATE=0 or t.TMS_INVOICE_STATE is null) and t.BILLING_DATE >= to_date('2018-10-01','yyyy-mm-dd')
and t.TMS_VAT_CR_INV_POL_HTYPE='01';
select t.POST_STATUS , DEDUCTION_STATUS,TMS_INVOICE_STATE,t.BILLING_DATE,t.TMS_VAT_CR_INV_POL_HTYPE,t.POST_DATE from V_TMS_VAT_CR_INV_POL_H t
where t.BILLING_DATE between to_date('2018-10-01','yyyy-mm-dd') and to_date('2018-10-31','yyyy-mm-dd')
and t.TMS_VAT_CR_INV_POL_HTYPE='01'
and (t.PURCHASER_NAME = (select BASE_TAX_PAYERNAME from T_BASE_TAX_PAYER where BASE_TAX_PAYERID = '04A6F7D0-1D6D-4B2E-B878-21C17A71A004')
OR t.PURCHASER_TAX_NO = (select TAX_PAYER_CODE from T_BASE_TAX_PAYER where BASE_TAX_PAYERID = '04A6F7D0-1D6D-4B2E-B878-21C17A71A004'))
and t.POST_STATUS=0
;
select t.POST_STATUS , DEDUCTION_STATUS,TMS_INVOICE_STATE,t.BILLING_DATE,t.TMS_VAT_CR_INV_POL_HTYPE,t.POST_DATE from V_TMS_VAT_CR_INV_POL_H t
where t.POST_DATE is not null;
select * from V_TMS_VAT_CR_INV_POL_H t where t.POST_STATUS=1 and t.DEDUCTION_STATUS=0
and (t.TMS_INVOICE_STATE=0 or t.TMS_INVOICE_STATE is null) and t.BILLING_DATE >= ? and t.TMS_VAT_CR_INV_POL_HTYPE='01'
and t.BILLING_DATE >= ? and t.POST_DATE >= ? and t.POST_DATE < ?
and (t.PURCHASER_NAME = (select BASE_TAX_PAYERNAME from T_BASE_TAX_PAYER where BASE_TAX_PAYERID = ?)
OR t.PURCHASER_TAX_NO = (select TAX_PAYER_CODE from T_BASE_TAX_PAYER where BASE_TAX_PAYERID = ?));
/* [0] null ==> (2017-11-13)
[1] null ==> (2017-07-01)
[2] null ==> (2018-10-01)
[3] null ==> (2018-11-01)
[4] null ==> (04A6F7D0-1D6D-4B2E-B878-21C17A71A004)
[5] null ==> (04A6F7D0-1D6D-4B2E-B878-21C17A71A004)
10:26:01.291 [http-nio-20010-exec-7] DEBUG net.ibizsys.paas.service.ServiceBase - 作业 耗时[11]
10:26:01.292 [http-nio-20010-exec-7] DEBUG net.ibizsys.paas.dao.DAOBase - SQL*/
select * from V_TMS_VAT_CR_INV_POL_H t where t.POST_STATUS=0 and t.DEDUCTION_STATUS=0
and (t.TMS_INVOICE_STATE=0 or t.TMS_INVOICE_STATE is null) and t.BILLING_DATE >= ?
and EXISTS(select * from T_TMS_VAT_RULE_AUTODED where TAX_PAYER_CODE=t.sales_tax_no and
(case when (PURCHASER_TAX_PAYERID is null or PURCHASER_TAX_PAYERID='')
then t.BASE_TAX_PAYERID else PURCHASER_TAX_PAYERID end)= t.BASE_TAX_PAYERID )
and t.TMS_VAT_CR_INV_POL_HTYPE in ('01','02','03') and t.BILLING_DATE >= ? and t.POST_DATE >= ?
and t.POST_DATE < ? and (t.PURCHASER_NAME = (select BASE_TAX_PAYERNAME from T_BASE_TAX_PAYER where BASE_TAX_PAYERID = ?)
OR t.PURCHASER_TAX_NO = (select TAX_PAYER_CODE from T_BASE_TAX_PAYER where BASE_TAX_PAYERID = ?))
/*[0] null ==> (2017-11-13)
[1] null ==> (2017-07-01)
[2] null ==> (2018-10-01)
[3] null ==> (2018-11-01)
[4] null ==> (04A6F7D0-1D6D-4B2E-B878-21C17A71A004)
[5] null ==> (04A6F7D0-1D6D-4B2E-B878-21C17A71A004) */修改的代码
- USRTmsDrInvoiceManLService.java
- USRTmsVATDrInvPolHService 发票号码代码库存不存在提示
- 手工申请单 USRTmsDrInvoiceBatchReqHService
- tMSDRInvoiceReqHEditViewApproverController.js
手工申请单
- USRTmsDrInvoiceBatchReqHService#generateTMSDRInvoiceReqHByBatchreq
sql
alter table T_ORG_PRINT_REL add WEB_SERVICE_URL VARCHAR2(100);
alter table T_ORG_PRINT_REL add equipment_type VARCHAR2(100);
alter table T_ORG_PRINT_REL add IP_ADDRESS VARCHAR2(100);
alter table T_ORG_PRINT_REL add FAPIAO_TYPE VARCHAR2(100);
alter table T_ORG_PRINT_REL add PORT VARCHAR2(100);
alter table T_ORG_PRINT_REL add ORG_CODE VARCHAR2(100);
alter table T_ORG_PRINT_REL add TERMINAL_SERIAL_NO VARCHAR2(100);alter table T_TMS_DR_INVOICE_BATCH_REQ_L modify qty_of_pre_invoice FLOAT;
手工开票申请数据导入模板自定义
- ExportFilePageReqHXM
sso
- html中引用js文件文件:Base64.rar
- 加密用户名并跳转vat
var b = new Base64(); var str = b.encode(username); window.location.href = "http://10.4.173.105/BASE/XMLogin?token="+str;
- 代码参考XMLoginServlet
- web.xml配置
<servlet>
<servlet-name>XMLoginServlet</servlet-name>
<servlet-class>com.deloitte.tms.vat.web.XMLoginServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>XMLoginServlet</servlet-name>
<url-pattern>/XMLogin</url-pattern>
</servlet-mapping>数据同步
- 输出和输入的文件默认目录在 C:\APP\ADMINISTRATOR\ADMIN\ORCL\DPDUMP
- 视图不能覆盖，所以先通过工具清空目标数据库的视图
expdp TMS_BASE/TMS_BASE@ORCL schemas=TMS_BASE dumpfile =TMS_BASE.dmp logfile=TMS_BASE.log impdp TMS_BASE/TMS_BASE@ORCL dumpfile =TMS_BASE.dmp logfile=TMS_BASE.log table_exists_action=replace
expdp TMS_VAT/TMS_VAT@ORCL schemas=TMS_VAT dumpfile =TMS_VAT.dmp logfile=TMS_VAT.log impdp TMS_VAT/TMS_VAT@ORCL dumpfile =TMS_VAT.dmp logfile=TMS_VAT.log table_exists_action=replace
expdp TMS_MIS/TMS_MIS@ORCL schemas=TMS_MIS dumpfile =TMS_MIS.dmp logfile=TMS_MIS.log impdp TMS_MIS/TMS_MIS@ORCL dumpfile =TMS_MIS.dmp logfile=TMS_MIS.log table_exists_action=replace
vpn
@bo.wang VPN账号：cj_wangb 密码：a.123456 VPN网址：https://vpn.xmgdjt.com.cn
问题解决
80端口占用
设置World Wide Web Publishing Service为手工启动
无法telnet
oracle 11g断网安装时，没有检测net的功能，所以安装完后，netstat -an 发现自动监听的是127.0.0.1:1521，这样安装完成后，其他的主机根本无法连接，是什么原因呢？
1、修改C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN的tnsnames.ora
localhost 改为 IP
重启，没效果
2、修改同目录的listener.ora
localhost 改为 IP
重启lisenter，OK
BaseWebContext
srv_vat_usr/src/main/java/com/deloitte/tms/vat/vat/home/controller/USRDashboardController.java
srv_vat_usr/src/main/java/com/deloitte/tms/vat/vat/util/BaseUtil.java
vat/src/main/webapp/WEB-INF/web.xmleclipse maven install Java heap space
不能执行clean,如果执行了clean,将项目删除重新导入.项目会被重新编译.便已完成后再maven -install
http://www.cnblogs.com/qlwang/p/8203610.html 这个不行
这个也不行
tomcat8 To prevent a memory leak, the JDBC Driver has been forcibly unregistered
https://blog.csdn.net/hjun01/article/details/42266925
1 counts of IllegalAnnotationExceptions java.sql.Timestamp does not have a no-arg default constructor
将Timestamp类型改为Date类型
Caused by: com.sun.xml.bind.v2.runtime.IllegalAnnotationsException: 1 counts of IllegalAnnotationExceptions
java.sql.Timestamp does not have a no-arg default constructor.
this problem is related to the following location:
at java.sql.Timestamp
at public java.sql.Timestamp com.deloitte.tms.vat.webservice.model.InvoiceReqH.getInvoiceReqDate()
at com.deloitte.tms.vat.webservice.model.InvoiceReqH
at private java.util.List com.deloitte.tms.vat.webservice.CRInvReqDataRequest.serviceDataList
at com.deloitte.tms.vat.webservice.CRInvReqDataRequest
at private com.deloitte.tms.vat.webservice.CRInvReqDataRequest com.deloitte.tms.vat.webservice.jaxws_asm.InvoiceReqTrxList.arg2
at com.deloitte.tms.vat.webservice.jaxws_asm.InvoiceReqTrxListqipachengxu
/*alter table T_TMS_DR_INVOICE_MAN_L modify inventory_item_qty FLOAT(20);;
alter table T_TMS_DR_INVOICE_MAN_L add inventory_item_qty_barkup FLOAT(20);
update T_TMS_DR_INVOICE_MAN_L set inventory_item_qty_barkup=inventory_item_qty;
select inventory_item_qty_barkup,inventory_item_qty from T_TMS_DR_INVOICE_MAN_L;
update T_TMS_DR_INVOICE_MAN_L set inventory_item_qty = null;
update T_TMS_DR_INVOICE_MAN_L set inventory_item_qty =inventory_item_qty_barkup;
*/
alter table T_TMS_DR_INVOICE_MAN_L add inventory_item_qty_barkup float(*);;
update T_TMS_DR_INVOICE_MAN_L set inventory_item_qty_barkup=inventory_item_qty;
update T_TMS_DR_INVOICE_MAN_L set inventory_item_qty = null;
alter table T_TMS_DR_INVOICE_MAN_L modify inventory_item_qty NUMBER(38,6);
update T_TMS_DR_INVOICE_MAN_L set inventory_item_qty =inventory_item_qty_barkup;
select t.TOTAL_AMOUNT,t.TOTAL_TAX,t.AMOUNT_TAX from T_TMS_VAT_DR_INV_POL_H t where t.TMS_VAT_DR_INV_POL_HID='a1a6fff4-546d-46b3-abc5-16d405fdebd2';
--a1a6fff4-546d-46b3-abc5-16d405fdebd2
select t.ACCTD_AMOUNT_CR,t.TMS_AMOUNT,t.TAX from T_TMS_VAT_DR_INV_POL_L t where t.TMS_VAT_DR_INV_POL_HID='a1a6fff4-546d-46b3-abc5-16d405fdebd2';
select t.ACCTD_AMOUNT_CR,t.VAT_AMOUNT,t.INVOICE_AMOUNT from T_TMS_DR_INVOICE_MAN_L t;
--
alter table T_TMS_VAT_DR_INV_POL_H add TOTAL_AMOUNT_BARKUP float(*);
alter table T_TMS_VAT_DR_INV_POL_H add TOTAL_TAX_BARKUP float(*);
alter table T_TMS_VAT_DR_INV_POL_H add AMOUNT_TAX_BARKUP float(*);
update T_TMS_VAT_DR_INV_POL_H set TOTAL_AMOUNT_BARKUP=TOTAL_AMOUNT;
update T_TMS_VAT_DR_INV_POL_H set TOTAL_TAX_BARKUP=TOTAL_TAX;
update T_TMS_VAT_DR_INV_POL_H set AMOUNT_TAX_BARKUP=AMOUNT_TAX;
update T_TMS_VAT_DR_INV_POL_H set TOTAL_AMOUNT = null;
update T_TMS_VAT_DR_INV_POL_H set TOTAL_TAX = null;
update T_TMS_VAT_DR_INV_POL_H set AMOUNT_TAX = null;
alter table T_TMS_VAT_DR_INV_POL_H modify TOTAL_AMOUNT NUMBER(38,2);
alter table T_TMS_VAT_DR_INV_POL_H modify TOTAL_TAX NUMBER(38,2);
alter table T_TMS_VAT_DR_INV_POL_H modify AMOUNT_TAX NUMBER(38,2);
update T_TMS_VAT_DR_INV_POL_H set TOTAL_AMOUNT =TOTAL_AMOUNT_BARKUP;
update T_TMS_VAT_DR_INV_POL_H set TOTAL_TAX =TOTAL_TAX_BARKUP;
update T_TMS_VAT_DR_INV_POL_H set AMOUNT_TAX =AMOUNT_TAX_BARKUP;
--
alter table T_TMS_VAT_DR_INV_POL_L add ACCTD_AMOUNT_CR_BARKUP float(*);
alter table T_TMS_VAT_DR_INV_POL_L add TMS_AMOUNT_TAX_BARKUP float(*);
alter table T_TMS_VAT_DR_INV_POL_L add TAX_BARKUP float(*);
update T_TMS_VAT_DR_INV_POL_L set ACCTD_AMOUNT_CR_BARKUP=ACCTD_AMOUNT_CR;
update T_TMS_VAT_DR_INV_POL_L set TMS_AMOUNT_TAX_BARKUP=TMS_AMOUNT;
update T_TMS_VAT_DR_INV_POL_L set TAX_BARKUP=TAX;
update T_TMS_VAT_DR_INV_POL_L set ACCTD_AMOUNT_CR = null;
update T_TMS_VAT_DR_INV_POL_L set TMS_AMOUNT = null;
update T_TMS_VAT_DR_INV_POL_L set TAX = null;
alter table T_TMS_VAT_DR_INV_POL_L modify ACCTD_AMOUNT_CR NUMBER(38,2);
alter table T_TMS_VAT_DR_INV_POL_L modify TMS_AMOUNT NUMBER(38,2);
alter table T_TMS_VAT_DR_INV_POL_L modify TAX NUMBER(38,2);
update T_TMS_VAT_DR_INV_POL_L set ACCTD_AMOUNT_CR =ACCTD_AMOUNT_CR_BARKUP;
update T_TMS_VAT_DR_INV_POL_L set TMS_AMOUNT =TMS_AMOUNT_TAX_BARKUP;
update T_TMS_VAT_DR_INV_POL_L set TAX =TAX_BARKUP;
--
alter table T_TMS_DR_INVOICE_MAN_L add ACCTD_AMOUNT_CR_BARKUP float(*);
alter table T_TMS_DR_INVOICE_MAN_L add VAT_AMOUNT_BARKUP float(*);
alter table T_TMS_DR_INVOICE_MAN_L add INVOICE_AMOUNT_BARKUP float(*);
update T_TMS_DR_INVOICE_MAN_L set ACCTD_AMOUNT_CR_BARKUP=ACCTD_AMOUNT_CR;
update T_TMS_DR_INVOICE_MAN_L set VAT_AMOUNT_BARKUP=VAT_AMOUNT;
update T_TMS_DR_INVOICE_MAN_L set INVOICE_AMOUNT_BARKUP=INVOICE_AMOUNT;
update T_TMS_DR_INVOICE_MAN_L set ACCTD_AMOUNT_CR = null;
update T_TMS_DR_INVOICE_MAN_L set VAT_AMOUNT = null;
update T_TMS_DR_INVOICE_MAN_L set INVOICE_AMOUNT = null;
alter table T_TMS_DR_INVOICE_MAN_L modify ACCTD_AMOUNT_CR NUMBER(38,2);
alter table T_TMS_DR_INVOICE_MAN_L modify VAT_AMOUNT NUMBER(38,2);
alter table T_TMS_DR_INVOICE_MAN_L modify INVOICE_AMOUNT NUMBER(38,2);
update T_TMS_DR_INVOICE_MAN_L set ACCTD_AMOUNT_CR =ACCTD_AMOUNT_CR_BARKUP;
update T_TMS_DR_INVOICE_MAN_L set VAT_AMOUNT =VAT_AMOUNT_BARKUP;
update T_TMS_DR_INVOICE_MAN_L set INVOICE_AMOUNT =INVOICE_AMOUNT_BARKUP;
