insert into jimu_report(api_code,create_time,name,template,del_flag,id,view_count,note,status,thumb,update_time,create_by,api_url,type,css_str,update_by,js_str,code,json_str,api_method) values (null,'2021-11-19 17:15:09','客户入库批次统计',0,0,'621602170534166528','14',null,null,null,'2021-11-23 15:29:10','admin',null,'datainfo',null,'admin',null,'20211119171508','{"loopBlockList":[],"area":{"sri":4,"sci":8,"eri":4,"eci":8,"width":89,"height":25},"excel_config_id":"621602170534166528","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{"0":{"text":"(钢贸)客户入库批次统计","merge":[0,9],"height":25,"style":9}},"height":48},"1":{"cells":{"0":{"text":"序号","style":3},"1":{"text":"仓库","style":3},"2":{"text":"客户","style":3},"3":{"text":"品名","style":3},"4":{"text":"批次号/库位-卡号","style":3},"5":{"text":"规格","style":3},"6":{"text":"入库数量（件）","style":3},"7":{"text":"入库重量(吨)","style":3},"8":{"text":"过磅重量(吨)","style":3},"9":{"text":"完成日期","style":3}}},"2":{"cells":{"0":{"style":5,"text":"#{tSumInBatch_index+1}"},"1":{"text":"#{tSumInBatch.warehouse_name}","style":4},"2":{"text":"#{tSumInBatch.org_name}","style":4},"3":{"text":"#{tSumInBatch.sku_name}","style":5},"4":{"text":"#{tSumInBatch.batch_no}","style":4},"5":{"text":"#{tSumInBatch.net_content}","style":4},"6":{"text":"#{tSumInBatch.total_weight_num}","style":7},"7":{"text":"#{tSumInBatch.total_charge_num}","style":7},"8":{"text":"#{tSumInBatch.total_balance_num}","style":7},"9":{"text":"#{tSumInBatch.over_time}","style":8}}},"3":{"cells":{"0":{"text":"合计","style":3,"merge":[0,5],"height":25},"6":{"text":"=SUM(G3)","style":7},"7":{"text":"=SUM(H3)","style":7},"8":{"text":"=SUM(I3)","style":7},"9":{"text":"/","style":4}}},"4":{"cells":{"5":{}}},"len":100},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[]},"freeze":"A1","dataRectWidth":1215,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"align":"center"},{"align":"center","font":{"bold":true}},{"font":{"bold":true}},{"align":"center","font":{"bold":true},"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","format":"number"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"format":"date"},{"align":"center","font":{"bold":true,"size":16}},{"font":{"bold":true,"size":16}}],"validations":[],"cols":{"0":{"width":27},"2":{"width":181},"4":{"width":235},"5":{"width":208},"6":{"width":97},"7":{"width":95},"8":{"width":89},"9":{"width":83},"len":50},"merges":["A1:J1","A4:F4"]}',null);
insert into jimu_report_db(db_code,db_ch_name,is_list,create_time,db_type,db_key,db_source,id,jimu_report_id,db_dyn_sql,is_page,update_time,tb_db_table_name,create_by,api_url,json_data,db_table_name,update_by,tb_db_key,java_type,java_value,api_method,api_convert,db_source_type) values ('tSumInBatch','(钢贸)客户入库批次统计','1','2021-11-23 15:31:40','0',null,'590799803426234368','621602796135579648','621602170534166528','SELECT
 i.warehouse_name,
 i.org_name,
 d.sku_name,
 d.sku_id skuid,
 d.net_content,
 sum(d.actual_weight_num) total_weight_num,
 sum(d.charge_num) total_charge_num,
 sum(d.balance_num) total_balance_num,
 i.over_time,
 i.org_id customer_id,
 i.warehouse_id,
d.batch_no
FROM
  order_inbound_detail d
JOIN order_inbound i ON d.inbound_id = i.id
LEFT JOIN warehouse_category wc ON i.warehouse_id = wc.warehouse_id
WHERE
  i.is_deleted = 0
AND i.storage_status = 10
AND wc.business_id = 'gangtie'
AND i.org_id NOT IN (165, 105225)
AND i.over_time>='${fromDate}''00:00:00'
AND i.over_time<= '${fromDate}''23:59:59'
GROUP BY
 i.warehouse_id,i.org_id,d.sku_id,
d.batch_no
ORDER BY
 i.warehouse_id,
 i.org_id,
d.batch_no','1','2021-11-23 15:31:40',null,'admin',null,'',null,'admin',null,null,null,null,'','mysql');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-11-23 15:31:40','String',0,null,'batch_no',null,'621602796169134080',null,null,'admin','621602796135579648',null,null,null,'batch_no',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-11-23 15:31:40','String',1,null,'customer_id',null,'621602796211077120',0,null,'admin','621602796135579648',null,null,null,'customer_id',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-11-23 15:31:40','String',2,null,'skuid',null,'621602796219465728',null,null,'admin','621602796135579648',null,null,null,'skuid',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-11-23 15:31:40','String',3,null,'warehouse_id',null,'621602796223660032',null,null,'admin','621602796135579648',null,null,null,'warehouse_id',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-11-23 15:31:40','string',4,4,'仓库',null,'623024128165478400',1,null,'admin','621602796135579648',null,null,null,'warehouse_name',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-11-23 15:31:40','string',5,4,'客户',null,'623024128173867008',1,null,'admin','621602796135579648',null,null,null,'org_name',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-11-23 15:31:40','String',6,null,'sku_name',null,'623024128178061312',null,null,'admin','621602796135579648',null,null,null,'sku_name',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-11-23 15:31:40','String',7,null,'net_content',null,'623025496838176768',null,null,'admin','621602796135579648',null,null,null,'net_content',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-11-23 15:31:40','String',8,null,'over_time',null,'623025496846565376',null,null,'admin','621602796135579648',null,null,null,'over_time',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-11-23 15:31:40','String',9,null,'total_weight_num',null,'623025496850759680',null,null,'admin','621602796135579648',null,null,null,'total_weight_num',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-11-23 15:31:40','String',10,null,'total_charge_num',null,'623025496854953984',null,null,'admin','621602796135579648',null,null,null,'total_charge_num',null,null);
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2021-11-23 15:31:40','String',11,null,'total_balance_num',null,'623025496859148288',null,null,'admin','621602796135579648',null,null,null,'total_balance_num',null,null);
insert into jimu_report_db_param(create_time,jimu_report_head_id,param_name,order_num,widget_type,search_mode,param_value,dict_code,id,search_flag,update_time,create_by,param_txt,update_by,search_format,ext_json) values ('2021-11-23 15:31:40','621602796135579648','fromDate',1,'date',null,'=dateStr('yyyy-MM-dd')',null,'621602796232048640',1,null,'admin','完成时间 (必输):',null,null,null);