厦门轨道项目

来自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

https://120.42.49.156

文档

文件:厦门轨道交通信息化二期(资产一体化) TAX INTERFACE 20180508.xlsx 文件:VPN系统登录步骤V1.4.pdf 登陆地址改为https://120.42.49.156

开发环境

http://172.16.150.20/SAIBZ5Studio/app51/sysindexview.jsp?DEVSLNSYS=1&srfparentdeid=3692fadd0f3b4823181a99ab1fb5753d&srfparenttype=DER1N&srfder1nid=DER1N_PSDEVSLNSYS_PSDEVSLNSYS_MAINPSDEVSLNSYSID&srfparentkey=556B42BB-4D3C-4941-AB40-12580C8F17C3&srfkeys=075CD220-31AC-47D5-AC1E-5F421C583EE6

账号 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

Xiamenguidao service.PNG

http://10.4.173.105:10010/BASE

http://10.4.173.105:10040/vat

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/ ,打开远程桌面

Railway publish01.PNG

  • 进入应用程序目录D:\server\tomcat_10040_vat\webapps 将xxx.war复制到这里并解压覆盖原有内容.然后删除xxx.war

Railway publish06.PNG Railway publish05.PNG

  • 复制D:\server\configs\vat中的配置文件到D:\server\tomcat_10040_vat\webapps\vat\WEB-INF\classes 更新配置

Railway publish02.PNG Railway publish03.PNG

  • 进入服务.重启DELOITTE_VAT服务

Railway publish04.PNG

webservice



  • 合同接口:
测试环境: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
  • 科目余额表 税务系统 GetCUXTAXGLBALANCESVPage 根据期间,获取科目余额数据

Xm kemuyueduizhao.png

测试: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
{"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);

用户组织机构

Vat2.0 user org.jpg

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;
  • 再次同步,保证前后数据量不变

清单

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中体现
  • 打印设备定义

打印设备定义.jpg

  • 打印服务器

打印服务器.png

  • 打印终端,注意这里的终端标识天ukey上的编码

打印终端.jpg

开具报文

<?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"}

INITfapiao.PNG

配置取数任务

然后LTS里配置一个任务

任务参数是 {"inf":"CrIntSta"}

86400000ms

哦,好像那个java代码现不用改了,那个是当时测试用的,只要在vat里按税号配置就行
 
我截图给你看卡
 
在这个菜单里配置
还有就是要把服务器对外ip给百望
 
他们要设置ip白名单
 
你本地也已修改下这个测试类,测试接口连通性
 
com.deloitte.tms.vat.vat.util.Test.java

SpringAnnotationJobRunner

Bw jinxiang.png

{"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

文件:厦门-UUV接口服务调用说明V1.0.docx

var b = new Base64();  
var str = b.encode(username);  
window.location.href = "http://10.4.173.105/BASE/XMLogin?token="+str;
	<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.xml

eclipse maven install Java heap space

不能执行clean,如果执行了clean,将项目删除重新导入.项目会被重新编译.便已完成后再maven -install


http://www.cnblogs.com/qlwang/p/8203610.html 这个不行


这个也不行

Customer maven install.PNG Customer maven install jvm.PNG

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.InvoiceReqTrxList

qipachengxu

/*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;