生活sf的点滴日志

基础业务：海关参数，物料管理，税金管理，保证金管理 ，车辆管理，业务预警，账册管理，合作伙伴管理
核心业务：跨境电商进出口，保税业务，报关业务，海关对接，外部系统对接

报关：申报，查验，征税，放行
订单:
台账tt_stock_bill 一对多 tt_stock_record 一对多tt_stock_bill_declare_detail
台账备案序号tt_stock_record
台账申报详情业务表tt_stock_bill_declare 一对多 tt_stock_bill_declare_detail
台账申报业务详情业务详细表tt_stock_bill_declare_detail
核注单：
核注清单表头tt_invt_head
核注清单表体tt_invt_body
核注临时报关单表头tt_invt_cus_head
核注临时报关单表体tt_invt_body
核注清单和台账关系记录表tt_invt_bill
核放单:
核放单表头tt_passport_head
核放单表体tt_passport_list
核放单关联单证tt_passport_acmp
清单结关：
清单结关记录tt_sas_finish
报关:
报关单表头tt_decl_head
报关单表体tt_deal_body

物料管理：
物料管理表tt_material_manage 物料管理要素表tt_material_element
物料归类tm_goods_classification 物料归类要素表tm_goods_classification_element

hs对应要素表tm_hscode_elements HS编码要素关联表 tm_hscode_elements_relation

国别地区：tm_country_area
计量单位：tm_unit_code
币制代码：tm_currency

– 订单
select * from tt_stock_bill where order_no in(“444444”,“333333”) 152831 152832

select * from tt_stock_bill_record where

select * from tt_stock_bill_declare

select * from tt_stock_bill_declare_detail where bill_id = ‘152831’

– 核注单
select * from tt_invt_head where id = ‘1213’

select * from tt_invt_body where head_id = ‘1212’

select * from tt_invt_cus_head where head_id = ‘1212’

select * from tt_invt_cus_body where head_id = ‘1212’

select * from tt_invt_cbec_body where head_id = ‘1212’

– 订单和核注单关系表
select * from tt_invt_bill where bill_id in(“153156”,“152832”)

– 核放单
select * from tt_passport_head

– 报关单
select * from tt_decl_head where invt_head_id = ‘1213’

select * from tt_decl_body

select * from tt_decl_head where create_emp = ‘01415065’ ORDER BY id DESC

入库台账保存：/order/stockBillService/save
tt_stock_bill表插入一条数据，tt_stock_bill_record插入一条数据

入库台账不自动拆弹，选了台账之后调取接口：order/billToInvtBodyService/stockBillInToInvt 把要保存的数据返回给前端，然后点击保存，在请求到后台

入库台账自动拆单：bonded/invtHeadService/billToInvtAutoSplit
核注单表头插入一条数据tt_invt_head，表体tt_invt_body，中间表tt_invt_bill，跨境tt_invt_cbec_body表体，临时报关单表头tt_invt_cus_head，表体tt_invt_cus_body，修改台账状态tt_stock_bill

入库核注单保存到单一：/bonded/invtHeadService/saveOrUpdate

入库核注单保存到本地：bonded/invtHeadService/saveDraft

入库核注单申报：/bonded/invtHeadService/declareInvt

出库台账保存：/order/stockBillService/save
出库台账预配：order/stockBillService/doPreConfiguration
出库台账取消预配：/order/stockBillService/doPreConfiguration 同一个接口用参数：command=preConfiguration 预配，command=cancelpreConfiguration 取消预配
出库台账不自动拆单，选了台账之后调取接口：/order/billToInvtBodyService/stockBillOutToInvt
出库台账自动拆单：/bonded/invtHeadService/billToInvtAutoSplit

select goods_material_code from tt_material_manage where is_delete = 0 group by goods_material_code HAVING count(1) >1

预配数量：出口暂用库存的数量
预扣数量：出口实际减库存的数量
实增数量:进口的申报数量
实减(实扣)数量:出口的申报数量
库存数量：实际库存的数量
可申报数量：(reserve_qty - damage_qty - freeze_qty - prepare_distribution - prevd_redc_qty)
库存数量-破损数量-冻结数量-预配数量-预扣数量

批量添加的时候，表头id能合成id，表体不能生成id，其他的值确能带过来

https://www.cnblogs.com/java-zzl/p/9739750.html

深关通目录：/nfsc/IBU_SDM_CORE/sdm
单一窗口目录：/nfsc/IBU_SDM_CORE/customs/HN/Sas

发送：writer
回执：reader
单一窗口目录：OutBox—待发送数据的文件夹 SendBox—发送完毕数据的文件夹
InBox—接收回执数据/校验失败说明的文件夹 FailBox—校验失败的文件夹

select country_code as 国别代码,country_name as 国别名称,country_digit_code as 数字代码 from tm_country_area where is_del = 0 ORDER BY id DESC

select unitcode as 单位编码 ,unitname as 单位名称 from tm_unit_code where delete_flag = 0 ORDER BY id asc

select currency_code as 货币代码 ,currency_name as 中文名称,ori_customs_code as 原报关单代码,ori_inspection_code as 原报检代码 from tm_currency where is_del = 0 ORDER BY id desc

查看接口调用量：
grep ‘rpc call method finish.’ stdout.log | awk -F “[” ‘{print $3,$5}’|awk -F “]” ‘{print $1,$2}’|awk ‘{print $1,$4}’|awk ‘{c[$1]++;t[$1]+=$2;avg[$1]=t[$1]/c[$1]}END{for (i in c) print c[i],avg[i],i}’ | sort -rn -k 1|head

9610:B2C
9710:B2B
9810:B2B出口至海外仓
1210:保税B2C跨境出口

avaliable_qty = (reserve_qty - damage_qty - freeze_qty - prepare_distribution - prevd_redc_qty)

可申报数量 = 库存数量 - 破损数量 - 冻结数量 - 预配数量 - 预扣数量
库存数量 = 实增数量 - 实扣数量

法一单位：海关税则管理中的计量单位
法二单位：企业约定合同中的计量单位

核注报文：
commom回执：返回预录入编号和企业内部编号
invt201：分2个回执文件，第一个返回清单编号，第二个放回报文invt101内容和一些信息
invt211：处理物料数量监控处理，实增和实减
invt202：生成报关单统一编号

业务申报表报文：

台账：创建进境备案清单(核注清单-生成报关单) decl_type = 3 生成核注：报关单类型 为 进境备案清单
创建进境备案清单(核注清单-不生成报关单)

  商品价格=实际支付金额-运杂费-代扣税款+非现金抵扣金额
  
  
  http://hszx.zsport.com.cn/

record_seq 账册项号—备案序号

select * from (select id,tenant,enterprise_material_code,hs_code,LENGTH(gmodel)-LENGTH(REPLACE(gmodel,‘|’,‘’))+1 as ca from tt_material_manage where is_delete = 0) a

LEFT JOIN (select hs_code,count(1) as cb from tm_hscode_elements_relation group by hs_code) b
on a.hs_code = b.hs_code
where a.ca != b.cb;

select * from tt_material_element where id in (
SELECT min(id) mid FROM tt_material_element group by parent_id)
and element_name != ‘品牌类型’

select * from tt_material_manage where id in(select parent_id from tt_material_element where id in (
SELECT min(id) mid FROM tt_material_element group by parent_id)
and element_name != ‘品牌类型’) and is_delete = 0

非保业务；

截止日期：2023-02-32 18:00:00

入区
核放入库数量：
select sum(b.dcl_qty) from tt_unbonded_passport_head a LEFT JOIN tt_unbonded_passport_body b on a.id = b.head_id
where a.is_del = 0 and b.is_del = 0 and a.status = 4 and passport_type = ‘1’ and a.create_time <‘2023-02-32 18:00:00’;
计算：8159+1500 = 9659 8659 + 1500 = 10159 ----1500是FG2938202302001861单子已过卡之后又失败了，所以要计算上

明细计算：select sum(prevd_inc_qty) '预增',sum(actl_inc_qty) as '实增' from tt_materials_out_in_detail where tenant = 'IBU-SDM-CORE-SF-FEIBAO' and create_time <'2023-02-32 18:00:00' ;
	6657+3000+2 = 9659    10157 + 

出区
核放入库数量：
select sum(b.dcl_qty) from tt_unbonded_passport_head a LEFT JOIN tt_unbonded_passport_body b on a.id = b.head_id
where a.is_del = 0 and b.is_del = 0 and a.status = 4 and passport_type = ‘2’ a.create_time <‘2023-02-32 18:00:00’;
计算 3926.00000+400 = 4326 —400 FG2938202212000136 单子已过卡之后又失败了，所以要计算上

明细：
	select sum(prevd_redc_qty) as '预扣',sum(actl_redc_qty) '实扣' from tt_materials_out_in_detail where tenant = 'IBU-SDM-CORE-SF-FEIBAO' and create_time <'2023-02-32 18:00:00'  ;
	计算：3806+ 520 = 4326    ----520是没有的

出入库
入区：select sum(b.in_out_amount) from tt_unbonded_in_out_stock_head a LEFT JOIN tt_unbonded_in_out_stock_body b on a.id = b.head_id
where a.is_del = 0 and b.is_del = 0 and a.status = ‘d’;
出：select sum(b.in_out_amount) from tt_unbonded_in_out_stock_head a LEFT JOIN tt_unbonded_in_out_stock_body b on a.id = b.head_id
where a.is_del = 0 and b.is_del = 0 and a.status = ‘f’;

select * from tt_bonded_task_summary where file_type in(‘UNBONDED_MAN10001_RCV’,‘UNBONDED_MAN10001_RCV2’) and deal_msg like ‘%失败%’ and deal_time <“2023-02-32 18:00:00”;

select * from tl_operation_log where item_code = ‘MaterialMonitor’ and record_id = 243443 and create_emp != ‘system’ and create_time <“2023-02-32 18:00:00” ;

实增：入库（出入单计算）：12757- 2600 = 10157    --- 2600是F29380000021202212210000000001这个出入库单任务失败
实际（物料数量监控）：10659-502 = 10157     ---502是实增数量被【42079232】修改了


实扣：出库（出入单计算）：3926 - 20 - 100 = 3806   
实际（物料数量监控）：3806  

库存数量（出入库计算）：10157 - 3806 = 6351
实际（物料数量监控）8953 -2-1700-900 = 6351  

非保物料数量监控实增：502被业务改了，要减去
				实扣：没有被修改，无影响
				库存数量：被修改要减去-2-1700-900