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-08-03 13:45:52','留罐记录查询',0,0,'582411315457511424','217',null,null,null,'2021-09-13 09:49:07','admin',null,'datainfo',null,'admin',null,'20210803134552','{"loopBlockList":[],"chartList":[{"row":15,"col":1,"colspan":8,"rowspan":10,"width":"686","height":"301","config":"{\"yAxis\":{\"axisLabel\":{\"textStyle\":{\"color\":\"#333\",\"fontSize\":\"15\"}},\"axisLine\":{\"lineStyle\":{\"color\":\"#333\"}},\"show\":true,\"name\":\"天数\",\"splitLine\":{\"lineStyle\":{\"color\":\"red\",\"width\":1,\"type\":\"solid\"},\"show\":false}},\"xAxis\":{\"splitLine\":{\"lineStyle\":{\"color\":\"red\",\"width\":1,\"type\":\"solid\"},\"show\":false},\"axisLabel\":{\"textStyle\":{\"color\":\"#333\",\"fontSize\":\"15\"},\"rotate\":0,\"interval\":\"auto\"},\"axisLine\":{\"lineStyle\":{\"color\":\"#333\"}},\"data\":[\"衬衫\",\"羊毛衫\",\"雪纺衫\",\"裤子\",\"高跟鞋\",\"袜子\"],\"show\":true,\"name\":\"罐号\"},\"grid\":{\"top\":60,\"left\":60,\"bottom\":60,\"right\":60},\"series\":[{\"areaStyle\":null,\"data\":[5,20,36,10,10,20],\"showSymbol\":true,\"lineStyle\":{\"width\":2},\"symbolSize\":6,\"isArea\":false,\"name\":\"\",\"itemStyle\":{\"color\":\"#2588E4\"},\"step\":false,\"label\":{\"textStyle\":{\"color\":\"black\",\"fontSize\":\"14\",\"fontWeight\":\"bold\"},\"position\":\"top\",\"show\":true},\"type\":\"line\",\"smooth\":true}],\"tooltip\":{\"formatter\":\"{b} : {c}\",\"show\":true,\"textStyle\":{\"color\":\"#fff\",\"fontSize\":18}},\"title\":{\"show\":true,\"top\":0,\"text\":\"留罐时间统计\",\"textStyle\":{\"color\":\"#000000\",\"fontWeight\":\"normal\",\"fontSize\":\"19\"},\"left\":\"left\",\"padding\":[5,20,5,10]}}","url":"","extData":{"dataType":"api","apiStatus":"1","dataId":"592206935541633024","axisX":"name","axisY":"value","series":"type","yText":"","xText":"","dbCode":"staytime","dataId1":"","source":"","target":"","isTiming":false,"intervalTime":"","linkIds":"","chartType":"line.smooth","chartId":"YvApvyilEAQ2oVVH","id":"YvApvyilEAQ2oVVH","run":1},"layer_id":"YvApvyilEAQ2oVVH","offsetX":0,"offsetY":0,"backgroud":{"enabled":"","color":"#fff","image":"","repeat":"repeat"},"virtualCellRange":[[15,1],[15,2],[15,3],[15,4],[15,5],[15,6],[15,7]]}],"area":{"sri":6,"sci":8,"eri":6,"eci":14,"width":705,"height":24},"excel_config_id":"582411315457511424","printConfig":{"paper":"A3","width":297,"height":420,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{"1":{"style":31,"text":"生产留罐记录查询","merge":[1,6],"height":50}}},"1":{"cells":{"8":{"aggregate":"","direction":"right","sort":"default"}}},"2":{"cells":{"1":{"rendered":"Xs6hQyAM0ALkZJac","config":2,"display":"barcode","style":45,"text":"#{tm.url}","merge":[1,3],"height":50},"5":{"style":104,"text":"品种：","merge":[1,0],"height":50,"rendered":"","config":""},"6":{"style":45,"merge":[1,1],"height":50,"rendered":"","config":"","text":"${pz.pz}"}},"height":22},"3":{"cells":{"8":{"text":"${pz.gh}"}}},"4":{"cells":{"1":{"style":107,"text":"罐号","merge":[0,1],"height":25},"3":{"style":107,"text":"入罐时间","merge":[0,2],"height":25},"6":{"style":107,"text":"留罐天数","merge":[0,1],"height":25},"8":{"text":""}}},"5":{"cells":{"1":{"merge":[0,1],"height":25,"style":82,"loopBlock":0,"zonedEdition":0,"text":"#{lg.tankno}"},"2":{"style":83,"loopBlock":0,"zonedEdition":0},"3":{"merge":[0,2],"height":25,"style":82,"loopBlock":0,"zonedEdition":0,"text":"#{lg.time}"},"4":{"style":83,"loopBlock":0,"zonedEdition":0},"5":{"style":83,"loopBlock":0,"zonedEdition":0},"6":{"merge":[0,1],"height":25,"style":82,"loopBlock":0,"zonedEdition":0,"text":"#{lg.saty}"},"7":{"style":83,"loopBlock":0,"zonedEdition":0},"8":{},"9":{},"13":{"text":"","rendered":"","config":""}},"height":31},"6":{"cells":{"1":{"text":"","zonedEdition":0},"8":{"merge":[0,6],"height":25,"text":"","zonedEdition":1},"9":{}},"height":24},"7":{"cells":{"1":{"text":"","zonedEdition":1},"10":{"text":"","rendered":"","config":""}}},"8":{"cells":{"8":{"text":"","rendered":"","config":""}}},"9":{"cells":{"6":{"text":"","rendered":"","config":""},"8":{"text":"","rendered":"","config":""},"10":{"text":"","rendered":"","config":""}}},"10":{"cells":{"8":{"text":"","rendered":"","config":""},"9":{"text":"","rendered":"","config":""},"10":{"text":"","rendered":"","config":""}}},"11":{"cells":{"8":{"text":"","rendered":"","config":""}}},"12":{"cells":{"11":{"text":"","rendered":"","config":""}}},"13":{"cells":{"11":{"text":"","rendered":"","config":""}}},"14":{"cells":{"7":{"style":98,"text":" "}}},"15":{"cells":{"1":{"text":" ","virtual":"YvApvyilEAQ2oVVH"},"2":{"text":" ","virtual":"YvApvyilEAQ2oVVH"},"3":{"text":" ","virtual":"YvApvyilEAQ2oVVH"},"4":{"text":" ","virtual":"YvApvyilEAQ2oVVH"},"5":{"text":" ","virtual":"YvApvyilEAQ2oVVH"},"6":{"text":" ","virtual":"YvApvyilEAQ2oVVH"},"7":{"text":" ","virtual":"YvApvyilEAQ2oVVH"}}},"len":101},"dbexps":[],"dicts":[],"rpbar":{"show":true,"btnList":[]},"freeze":"A1","dataRectWidth":818,"displayConfig":{"1":{"barcodeContent":"#\n","format":"CODE128","width":2,"height":50,"displayValue":false,"text":"jmreport","fontOptions":"","font":"monospace","textAlign":"center","textPosition":"bottom","textMargin":2,"fontSize":20,"background":"#fff","lineColor":"#000","margin":10,"containerWidth":300,"containerHeight":200},"2":{"barcodeContent":"#{tm.url}","format":"CODE128","width":"4","height":39,"displayValue":false,"text":"jmreport","fontOptions":"","font":"monospace","textAlign":"center","textPosition":"bottom","textMargin":2,"fontSize":20,"background":"#fff","lineColor":"#000","margin":10,"containerWidth":400,"containerHeight":39}},"background":false,"name":"sheet1","autofilter":{},"styles":[{"align":"center"},{"align":"center","font":{"name":"Comic Sans MS"}},{"font":{"name":"Comic Sans MS"}},{"align":"center","font":{"name":"Microsoft YaHei"}},{"font":{"name":"Microsoft YaHei"}},{"align":"center","font":{"name":"Microsoft YaHei","size":36}},{"font":{"name":"Microsoft YaHei","size":36}},{"align":"center","font":{"name":"Microsoft YaHei","size":22}},{"font":{"name":"Microsoft YaHei","size":22}},{"border":{"top":["thin","#000"],"left":["thin","#000"]}},{"align":"center","font":{"name":"Microsoft YaHei","size":22},"border":{"top":["thin","#000"],"bottom":["thin","#000"]}},{"border":{"top":["thin","#000"]}},{"border":{"top":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"left":["thin","#000"]}},{"border":{"bottom":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"right":["thin","#000"]}},{"border":{"top":["thick","#000"],"left":["thick","#000"]}},{"align":"center","font":{"name":"Microsoft YaHei","size":22},"border":{"top":["thick","#000"],"bottom":["thick","#000"]}},{"border":{"top":["thick","#000"]}},{"border":{"top":["thick","#000"],"right":["thick","#000"]}},{"border":{"bottom":["thick","#000"],"left":["thick","#000"]}},{"border":{"bottom":["thick","#000"]}},{"border":{"bottom":["thick","#000"],"right":["thick","#000"]}},{"border":{"top":["thick","#000"],"left":["thick","#000"]},"align":"center"},{"border":{"top":["thick","#000"],"left":["thick","#000"]},"align":"center","font":{"size":24}},{"font":{"size":24}},{"border":{"top":["thick","#000"],"left":["thick","#000"]},"align":"center","font":{"size":22}},{"font":{"size":22}},{"border":{"top":["thick","#000"],"left":["thick","#000"]},"align":"center","font":{"size":22,"bold":true}},{"font":{"size":22,"bold":true}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":22,"bold":true}},{"border":{"top":["thick","#000"],"bottom":["thick","#000"],"left":["thick","#000"],"right":["thick","#000"]},"align":"center","font":{"size":22,"bold":true}},{"border":{"top":["thick","#000"],"bottom":["thick","#000"],"left":["thick","#000"],"right":["thick","#000"]},"align":"center","font":{"size":22,"bold":false}},{"font":{"size":22,"bold":false}},{"border":{"bottom":["thin","#538136"],"top":["thin","#538136"],"left":["thin","#538136"],"right":["thin","#538136"]}},{"border":{"top":["thick","#538136"],"bottom":["thick","#538136"],"left":["thick","#538136"],"right":["thick","#538136"]}},{"border":{"top":["thick","#000100"],"bottom":["thick","#000100"],"left":["thick","#000100"],"right":["thick","#000100"]}},{"bgcolor":"#7030a0"},{"bgcolor":"#7030a0","border":{"top":["thick","#ffffff"],"bottom":["thick","#ffffff"],"left":["thick","#ffffff"]}},{"bgcolor":"#7030a0","border":{"top":["thick","#ffffff"],"bottom":["thick","#ffffff"]}},{"bgcolor":"#7030a0","border":{"top":["thick","#ffffff"],"bottom":["thick","#ffffff"],"right":["thick","#ffffff"]}},{"bgcolor":"#7030a0","border":{"bottom":["thick","#ffffff"],"top":["thick","#ffffff"],"left":["thick","#ffffff"],"right":["thick","#ffffff"]}},{"bgcolor":"#7030a0","border":{"bottom":["thick","#000100"],"top":["thick","#000100"],"left":["thick","#000100"],"right":["thick","#000100"]}},{"bgcolor":"#7030a0","border":{"left":["thick","#ffffff"]}},{"bgcolor":"#7030a0","border":{"right":["thick","#ffffff"]}},{"border":{"top":["thick","#000100"],"bottom":["thick","#000100"],"left":["thick","#000100"],"right":["thick","#000100"]},"font":{"size":12}},{"font":{"size":12}},{"bgcolor":"#7030a0","border":{"bottom":["thick","#ffffff"],"top":["thick","#ffffff"],"left":["thick","#ffffff"],"right":["thick","#ffffff"]},"font":{"size":12}},{"bgcolor":"#7030a0","border":{"bottom":["thick","#ffffff"],"top":["thick","#ffffff"],"left":["thick","#ffffff"],"right":["thick","#ffffff"]},"font":{"size":11}},{"font":{"size":11}},{"bgcolor":"#7030a0","border":{"bottom":["thick","#ffffff"],"top":["thick","#ffffff"],"left":["thick","#ffffff"],"right":["thick","#ffffff"]},"font":{"size":11,"bold":true}},{"font":{"size":11,"bold":true}},{"bgcolor":"#7030a0","border":{"bottom":["thick","#ffffff"],"top":["thick","#ffffff"],"left":["thick","#ffffff"],"right":["thick","#ffffff"]},"font":{"size":11,"bold":true},"color":"#ffffff"},{"font":{"size":11,"bold":true},"color":"#ffffff"},{"bgcolor":"#7030a0","border":{"bottom":["thick","#ffffff"],"top":["thick","#ffffff"],"left":["thick","#ffffff"],"right":["thick","#ffffff"]},"font":{"size":11,"bold":true},"color":"#ffffff","align":"center"},{"font":{"size":12},"border":{"top":["thick","#ffffff"],"left":["thick","#ffffff"]}},{"font":{"size":12},"border":{"top":["thick","#ffffff"]}},{"font":{"size":12},"border":{"top":["thick","#ffffff"],"right":["thick","#ffffff"]}},{"font":{"size":12},"border":{"left":["thick","#ffffff"]}},{"font":{"size":12},"border":{"right":["thick","#ffffff"]}},{"bgcolor":"#7030a0","border":{"left":["thick","#ffffff"]},"font":{"size":11,"bold":true},"color":"#ffffff","align":"center"},{"bgcolor":"#7030a0","border":{"right":["thick","#ffffff"]},"font":{"size":11,"bold":true},"color":"#ffffff","align":"center"},{"font":{"size":11},"border":{"bottom":["thick","#ffffff"],"left":["thick","#ffffff"]}},{"font":{"size":11},"border":{"bottom":["thick","#ffffff"]}},{"font":{"size":11},"border":{"bottom":["thick","#ffffff"],"right":["thick","#ffffff"]}},{"font":{"size":12},"border":{"top":["thick","#000100"],"left":["thick","#000100"]}},{"font":{"size":12},"border":{"top":["thick","#000100"]}},{"font":{"size":12},"border":{"top":["thick","#000100"],"right":["thick","#000100"]}},{"font":{"size":12},"border":{"left":["thick","#000100"]}},{"font":{"size":12},"border":{"right":["thick","#000100"]}},{"bgcolor":"#7030a0","border":{"left":["thick","#000100"]},"font":{"size":11,"bold":true},"color":"#ffffff","align":"center"},{"bgcolor":"#7030a0","border":{"right":["thick","#000100"]},"font":{"size":11,"bold":true},"color":"#ffffff","align":"center"},{"font":{"size":11},"border":{"bottom":["thick","#000100"],"left":["thick","#000100"]}},{"font":{"size":11},"border":{"bottom":["thick","#000100"]}},{"font":{"size":11},"border":{"bottom":["thick","#000100"],"right":["thick","#000100"]}},{"font":{"size":11},"border":{"bottom":["thick","#000100"],"top":["thick","#000100"],"left":["thick","#000100"],"right":["thick","#000100"]}},{"bgcolor":"#7030a0","border":{"top":["thick","#000100"]},"font":{"size":11,"bold":true},"color":"#ffffff","align":"center"},{"bgcolor":"#7030a0","border":{"top":["thick","#ffffff"]},"font":{"size":11,"bold":true},"color":"#ffffff","align":"center"},{"font":{"bold":true}},{"font":{"size":16},"border":{"top":["thick","#000100"]}},{"font":{"size":16}},{"font":{"size":16},"border":{"top":["thick","#000100"]},"align":"center"},{"font":{"size":11},"border":{"bottom":["thick","#000100"],"top":["thick","#000100"],"left":["thick","#000100"],"right":["thick","#000100"]},"color":"#000100"},{"font":{"size":11},"color":"#000100"},{"font":{"size":14},"border":{"top":["thick","#000100"]},"align":"center"},{"font":{"size":14}},{"font":{"size":12},"border":{"right":["thin","#000"]}},{"font":{"size":14},"border":{"right":["thin","#000"]},"align":"center"},{"font":{"size":14},"border":{"right":["thin","#000"]}},{"font":{"size":12},"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"font":{"size":14},"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"font":{"size":14},"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"font":{"size":12},"border":{"bottom":["thin","#000100"],"top":["thin","#000100"],"left":["thin","#000100"],"right":["thin","#000100"]}},{"font":{"size":14},"border":{"bottom":["thin","#000100"],"top":["thin","#000100"],"left":["thin","#000100"],"right":["thin","#000100"]},"align":"center"},{"font":{"size":14},"border":{"bottom":["thin","#000100"],"top":["thin","#000100"],"left":["thin","#000100"],"right":["thin","#000100"]}},{"font":{"size":14},"border":{"bottom":["thick","#000100"],"top":["thick","#000100"],"left":["thick","#000100"],"right":["thick","#000100"]},"align":"center"},{"font":{"size":14},"border":{"bottom":["thick","#000100"],"top":["thick","#000100"],"left":["thick","#000100"],"right":["thick","#000100"]}},{"border":{"right":["thick","#000100"]}},{"border":{"right":["thin","#000"]}},{"border":{"right":["thick","#000"]}},{"bgcolor":"#7030a0","border":{"left":["thick","#000"]},"font":{"size":11,"bold":true},"color":"#ffffff","align":"center"},{"font":{"size":14,"bold":true},"border":{"bottom":["thick","#000100"],"top":["thick","#000100"],"left":["thick","#000100"],"right":["thick","#000100"]},"align":"center"},{"font":{"size":14,"bold":false},"border":{"bottom":["thick","#000100"],"top":["thick","#000100"],"left":["thick","#000100"],"right":["thick","#000100"]},"align":"center"},{"font":{"bold":false}},{"font":{"size":12,"bold":false},"border":{"bottom":["thick","#000100"],"top":["thick","#000100"],"left":["thick","#000100"],"right":["thick","#000100"]},"align":"center"},{"font":{"bold":false,"size":12}},{"bgcolor":"#7030a0","border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"size":11,"bold":true},"color":"#ffffff","align":"center"},{"bgcolor":"#7030a0","border":{"top":["thick","#000"],"bottom":["thick","#000"],"left":["thick","#000"],"right":["thick","#000"]},"font":{"size":11,"bold":true},"color":"#ffffff","align":"center"},{"bgcolor":"#7030a0","font":{"size":11,"bold":true},"color":"#ffffff","align":"center"},{}],"validations":[],"cols":{"0":{"width":13},"8":{"width":105},"len":50},"merges":["B1:H2","B3:E4","F3:F4","G3:H4","B5:C5","D5:F5","G5:H5","B6:C6","D6:F6","G6:H6","I7:O7"]}',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 ('tm','条码','1','2021-08-03 16:57:15','1',null,'','582460515406794752','582411315457511424',null,'0','2021-09-02 15:30:08',null,'admin','http://127.0.0.1/fbpt/StayTankRecordingA?TanknoOrBatchNumber=${TanknoOrBatchNumber}&MixingWine=${MixingWine}','',null,'admin',null,null,null,'0','',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-08-03 16:57:15','String',0,null,'url',null,'582460584063356928',null,null,'admin','582460515406794752',null,null,null,'url',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-08-03 16:57:15','582460515406794752','TanknoOrBatchNumber',1,null,null,'',null,'582460515687813120',0,null,'admin',null,null,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-08-03 16:57:15','582460515406794752','MixingWine',2,null,null,'',null,'582460515801059328',0,null,'admin',null,null,null,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 ('pz','品种','0','2021-09-02 15:21:21','1',null,'','586327597525454848','582411315457511424',null,'0','2021-09-02 15:30:08',null,'admin','http://127.0.0.1/fbpt/ObtionOrigin?TanknoOrBatchNumber='${tanknoid}'','',null,'admin',null,null,null,'0','',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-09-02 15:21:21','string',0,null,'gh',null,'593308086890614784',null,null,'admin','586327597525454848',null,null,null,'gh',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-09-02 15:21:21','string',1,null,'pz',null,'593308086915780608',null,null,'admin','586327597525454848',null,null,null,'pz',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-09-02 15:21:21','586327597525454848','tanknoid',1,'string',null,'F27',null,'592165588755501056',1,null,'admin','输入罐号或批次号',null,null,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 ('staytime','留罐图示','1','2021-09-02 14:52:02','1',null,'','592206935541633024','582411315457511424',null,'0','2021-09-02 15:30:08',null,'admin','http://127.0.0.1/fbpt/staytime?TanknoOrBatchNumber=‘${TanknoOrBatchNumber}’','',null,'admin',null,null,null,'0','',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-09-02 14:52:02','string',0,null,'name',null,'592206935818457088',null,null,'admin','592206935541633024',null,null,null,'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-09-02 14:52:02','string',1,null,'value',null,'592206935885565952',null,null,'admin','592206935541633024',null,null,null,'value',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-09-02 14:52:02','592206935541633024','TanknoOrBatchNumber',1,null,null,'',null,'592207011752136704',0,null,'admin','查询',null,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-09-02 14:52:02','592206935541633024','‘TanknoOrBatchNumber’',2,null,null,'',null,'593300709441228800',0,null,'admin',null,null,null,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 ('lg','留罐数据','1','2021-09-02 15:30:08','1',null,'','593310294210203648','582411315457511424',null,'1','2021-09-02 15:30:08',null,'admin','http://127.0.0.1/fbpt/StayTankRecordingB?TanknoOrBatchNumber='${TanknoOrBatchNumber}'','',null,null,null,null,null,'0','',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-09-02 15:30:08','String',0,null,'saty',null,'593310294277312512',null,null,'admin','593310294210203648',null,null,null,'saty',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-09-02 15:30:08','String',1,null,'tankno',null,'593310294319255552',null,null,'admin','593310294210203648',null,null,null,'tankno',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-09-02 15:30:08','String',2,null,'time',null,'593310294340227072',null,null,'admin','593310294210203648',null,null,null,'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-09-02 15:30:08','String',3,null,'tanknoid',null,'593310294373781504',null,null,'admin','593310294210203648',null,null,null,'tanknoid',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-09-02 15:30:08','593310294210203648','TanknoOrBatchNumber',1,null,null,'',null,'593310294407335936',0,null,'admin',null,null,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-09-02 15:30:08','593310294210203648','MixingWine',2,null,null,'',null,'593310294449278976',0,null,'admin',null,null,null,null);

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-09-13 13:39:52','[生产]橡木桶管理数据',0,0,'597268648750174208','102',null,null,null,'2021-09-14 10:57:29','admin',null,'printinfo',null,'admin',null,'20210913133951','{"loopBlockList":[],"area":{"sri":16,"sci":4,"eri":16,"eci":4,"width":128,"height":25},"excel_config_id":"597268648750174208","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"landscape"},"zonedEditionList":[],"rows":{"1":{"cells":{"1":{"merge":[2,10],"height":75,"text":"储酒过程橡木桶状态报表","style":9}}},"2":{"cells":{}},"3":{"cells":{}},"4":{"cells":{"1":{"text":"记录名称：","style":17},"2":{"style":17,"text":"${oskm.operationrecordname}","merge":[0,1],"height":36},"4":{"text":"导入罐号：","style":17},"5":{"text":"${oskm.tin}","style":17},"6":{"style":17,"text":"统一编号：","merge":[0,2],"height":36},"9":{"merge":[0,2],"height":36,"style":17,"text":"${oskm.obm}"},"12":{"text":""}},"height":36},"5":{"cells":{"1":{"text":"批次状态：","style":17},"2":{"merge":[0,1],"height":36,"style":17,"text":"${oskm.state}"},"4":{"text":"橡木桶使用数量：","style":17},"5":{"style":17,"text":"${oskm.xmtnumber}"},"6":{"text":"备注：","style":17},"7":{"merge":[0,4],"height":36,"style":17,"text":"${oskm.remark}"}},"height":36},"6":{"cells":{"1":{"text":"序号","style":15},"2":{"text":"橡木桶编号","style":15},"3":{"text":"入桶时间","style":15},"4":{"text":"出桶时间","style":15},"5":{"text":"导出罐","style":15},"6":{"text":"温度","style":15},"7":{"text":"湿度","style":15},"8":{"text":"卫生状况","style":11},"9":{"text":"状态","style":15},"10":{"text":"备注","style":15,"merge":[0,1],"height":25}}},"7":{"cells":{"1":{"style":10,"text":"#{oskz.remark2}"},"2":{"style":10,"text":"#{oskz.tbh}"},"3":{"style":10,"text":"#{oskz.intime}"},"4":{"style":10,"text":"#{oskz.outtime}"},"5":{"style":10,"text":"#{oskz.tout}"},"6":{"style":10,"text":"#{oskz.temperature}"},"7":{"style":10,"text":"#{oskz.humidity}"},"8":{"style":10,"text":"#{oskz.healthconditions}"},"9":{"style":10,"text":"#{oskz.state}"},"10":{"merge":[0,1],"height":34,"style":10,"text":"#{oskz.remark}"}},"height":40},"8":{"cells":{"1":{"text":"辅料信息","style":26,"merge":[0,10],"height":25}}},"9":{"cells":{"1":{"text":"橡木桶","style":15},"2":{"merge":[0,1],"height":25,"text":"辅料名称","style":15},"4":{"text":"辅料用量","style":15},"5":{"merge":[0,2],"height":25,"text":"操作时间","style":15},"8":{"text":"操作人","style":15},"9":{"merge":[0,2],"height":25,"text":"备注","style":15}}},"10":{"cells":{"1":{"style":10,"text":"#{xmtfl.oakid}"},"2":{"style":10,"text":"#{xmtfl.supplementarymaterialname}","merge":[0,1],"height":25},"4":{"style":10,"text":"#{xmtfl.supplementarymaterialdosage}"},"5":{"style":10,"text":"#{xmtfl.operatetime}","merge":[0,2],"height":25},"8":{"style":10,"text":"#{xmtfl.operationuser}"},"9":{"style":10,"text":"#{xmtfl.remark}","merge":[0,2],"height":25}}},"len":100},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[]},"freeze":"A1","dataRectWidth":991,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"align":"center"},{"align":"center","font":{"size":18}},{"font":{"size":18}},{"align":"center","font":{"size":18,"bold":true}},{"font":{"size":18,"bold":true}},{"align":"center","font":{"size":22,"bold":true}},{"font":{"size":22,"bold":true}},{"align":"center","font":{"size":16,"bold":true}},{"font":{"size":16,"bold":true}},{"align":"center","font":{"size":18,"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"]},"font":{"bold":true}},{"font":{"bold":true}},{"align":"center","font":{"bold":true}},{},{"align":"center","font":{"bold":true},"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"align":"center","font":{"bold":false},"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"]},"font":{"bold":false}},{"font":{"bold":false}},{"bgcolor":"#756f6f"},{"bgcolor":"#afabac"},{"bgcolor":"#7f7f7f"},{"bgcolor":"#7f7f7f","border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"]}},{"bgcolor":"#7f7f7f","border":{"top":["thin","#000"],"bottom":["thin","#000"]}},{"bgcolor":"#7f7f7f","border":{"top":["thin","#000"],"bottom":["thin","#000"],"right":["thin","#000"]}},{"bgcolor":"#7f7f7f","border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"]},"align":"center"},{"bgcolor":"#7f7f7f","border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"]},"align":"center","font":{"bold":true}}],"validations":[],"cols":{"0":{"width":29},"1":{"width":90},"2":{"width":135},"3":{"width":135},"4":{"width":128},"5":{"width":60},"6":{"width":60},"7":{"width":70},"8":{"width":70},"9":{"width":114},"11":{"width":100},"len":50},"merges":["B2:L4","C5:D5","G5:I5","J5:L5","C6:D6","H6:L6","K7:L7","K8:L8","B9:L9","C10:D10","F10:H10","J10:L10","C11:D11","F11:H11","J11:L11"]}',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 ('oskm','橡木桶母表','0','2021-09-13 16:33:15','1',null,'','597295354944901120','597268648750174208',null,'0','2021-09-13 16:33:15',null,'admin','http://127.0.0.1:20218/jm/oskreport/OskStatusM?id='${id}'&xId='${xid}'','',null,'admin',null,null,null,'0','',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-09-13 16:33:15','String',0,null,'searchvalue',null,'597295355133644800',null,null,'admin','597295354944901120',null,null,null,'searchvalue',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-09-13 16:33:15','String',1,null,'createby',null,'597295355200753664',null,null,'admin','597295354944901120',null,null,null,'createby',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-09-13 16:33:15','String',2,null,'createtime',null,'597295355225919488',null,null,'admin','597295354944901120',null,null,null,'createtime',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-09-13 16:33:15','String',3,null,'updateby',null,'597295355255279616',null,null,'admin','597295354944901120',null,null,null,'updateby',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-09-13 16:33:15','String',4,null,'updatetime',null,'597295355284639744',null,null,'admin','597295354944901120',null,null,null,'updatetime',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-09-13 16:33:15','String',5,null,'remark',null,'597295355313999872',null,null,'admin','597295354944901120',null,null,null,'remark',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-09-13 16:33:15','String',6,null,'params',null,'597295355343360000',null,null,'admin','597295354944901120',null,null,null,'params',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-09-13 16:33:15','String',7,null,'id',null,'597295355368525824',null,null,'admin','597295354944901120',null,null,null,'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-09-13 16:33:15','String',8,null,'obm',null,'597295355397885952',null,null,'admin','597295354944901120',null,null,null,'obm',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-09-13 16:33:15','String',9,null,'tin','select tank_details_id as 'value', tank_number as 'text' from prod_add_tank_details','597295355427246080',null,null,'admin','597295354944901120',null,null,null,'tin',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-09-13 16:33:15','String',10,null,'xid',null,'597295355456606208',null,null,'admin','597295354944901120',null,null,null,'xid',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-09-13 16:33:15','String',11,null,'xmtnumber',null,'597295355481772032',null,null,'admin','597295354944901120',null,null,null,'xmtnumber',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-09-13 16:33:15','String',12,null,'state',null,'597295355506937856',null,null,'admin','597295354944901120',null,null,null,'state',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-09-13 16:33:15','String',13,null,'operationrecordname',null,'597295355536297984',null,null,'admin','597295354944901120',null,null,null,'operationrecordname',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-09-13 16:33:15','String',14,null,'remark3',null,'597295355561463808',null,null,'admin','597295354944901120',null,null,null,'remark3',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-09-13 16:33:15','String',15,null,'prodoskzflowbackwardlist',null,'597295355590823936',null,null,'admin','597295354944901120',null,null,null,'prodoskzflowbackwardlist',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-09-13 16:33:15','597295354944901120','id',1,null,null,'',null,'597295355657932800',0,null,'admin',null,null,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-09-13 16:33:15','597295354944901120','xid',2,null,null,'',null,'597295355708264448',0,null,'admin',null,null,null,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 ('oskz','橡木桶子表','1','2021-09-13 16:33:33','1',null,'','597296371145068544','597268648750174208',null,'0','2021-09-13 16:33:33',null,'admin','http://127.0.0.1:20218/jm/oskreport/OskStatusZ?id='${id}'&xId='${xid}'','',null,'admin',null,null,null,'0','',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-09-13 16:33:33','String',0,null,'searchvalue',null,'597296371212177408',null,null,'admin','597296371145068544',null,null,null,'searchvalue',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-09-13 16:33:33','String',1,null,'createby',null,'597296371245731840',null,null,'admin','597296371145068544',null,null,null,'createby',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-09-13 16:33:33','String',2,null,'createtime',null,'597296371283480576',null,null,'admin','597296371145068544',null,null,null,'createtime',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-09-13 16:33:33','String',3,null,'updateby',null,'597296371308646400',null,null,'admin','597296371145068544',null,null,null,'updateby',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-09-13 16:33:33','String',4,null,'updatetime',null,'597296371333812224',null,null,'admin','597296371145068544',null,null,null,'updatetime',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-09-13 16:33:33','String',5,null,'remark',null,'597296371363172352',null,null,'admin','597296371145068544',null,null,null,'remark',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-09-13 16:33:33','String',6,null,'params',null,'597296371388338176',null,null,'admin','597296371145068544',null,null,null,'params',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-09-13 16:33:33','String',7,null,'id',null,'597296371421892608',null,null,'admin','597296371145068544',null,null,null,'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-09-13 16:33:33','String',8,null,'mid',null,'597296371447058432',null,null,'admin','597296371145068544',null,null,null,'mid',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-09-13 16:33:33','String',9,null,'tbh','select tank_details_id as 'value', tank_number as 'text' from prod_add_tank_details','597296371480612864',null,null,'admin','597296371145068544',null,null,null,'tbh',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-09-13 16:33:33','String',10,null,'obm',null,'597296371514167296',null,null,'admin','597296371145068544',null,null,null,'obm',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-09-13 16:33:33','String',11,null,'tin','select tank_details_id as 'value', tank_number as 'text' from prod_add_tank_details','597296371539333120',null,null,'admin','597296371145068544',null,null,null,'tin',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-09-13 16:33:33','String',12,null,'tout','select tank_details_id as 'value', tank_number as 'text' from prod_add_tank_details','597296371568693248',null,null,'admin','597296371145068544',null,null,null,'tout',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-09-13 16:33:33','String',13,null,'inxid',null,'597296371593859072',null,null,'admin','597296371145068544',null,null,null,'inxid',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-09-13 16:33:33','String',14,null,'outxid',null,'597296371623219200',null,null,'admin','597296371145068544',null,null,null,'outxid',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-09-13 16:33:33','String',15,null,'intime',null,'597296371660967936',null,null,'admin','597296371145068544',null,null,null,'intime',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-09-13 16:33:33','String',16,null,'outtime',null,'597296371702910976',null,null,'admin','597296371145068544',null,null,null,'outtime',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-09-13 16:33:33','String',17,null,'state',null,'597296371744854016',null,null,'admin','597296371145068544',null,null,null,'state',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-09-13 16:33:33','String',18,null,'remark2',null,'597296371799379968',null,null,'admin','597296371145068544',null,null,null,'remark2',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-09-13 16:33:33','String',19,null,'remark3',null,'597296371841323008',null,null,'admin','597296371145068544',null,null,null,'remark3',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-09-13 16:33:33','String',20,null,'temperature',null,'597296371887460352',null,null,'admin','597296371145068544',null,null,null,'temperature',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-09-13 16:33:33','String',21,null,'humidity',null,'597296371933597696',null,null,'admin','597296371145068544',null,null,null,'humidity',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-09-13 16:33:33','String',22,null,'healthconditions',null,'597296371979735040',null,null,'admin','597296371145068544',null,null,null,'healthconditions',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-09-13 16:33:33','597296371145068544','xid',1,null,null,'',null,'597296372042649600',0,null,'admin',null,null,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-09-13 16:33:33','597296371145068544','id',2,null,null,'',null,'597303192291332096',0,null,'admin',null,null,null,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 ('xmtfl','橡木桶辅料','1','2021-09-14 10:56:45','1',null,'','597576415713120256','597268648750174208',null,'0','2021-09-14 10:56:45',null,'admin','http://127.0.0.1:20218/jm/oskreport/OskStatusF?qid=${qid}&xid=${xid}','',null,'admin',null,null,null,'0','',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-09-14 10:56:45','String',0,null,'searchvalue',null,'597583644059193344',null,null,'admin','597576415713120256',null,null,null,'searchvalue',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-09-14 10:56:45','String',1,null,'createby',null,'597583644193411072',null,null,'admin','597576415713120256',null,null,null,'createby',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-09-14 10:56:45','String',2,null,'createtime',null,'597583644247937024',null,null,'admin','597576415713120256',null,null,null,'createtime',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-09-14 10:56:45','String',3,null,'updateby',null,'597583644289880064',null,null,'admin','597576415713120256',null,null,null,'updateby',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-09-14 10:56:45','String',4,null,'updatetime',null,'597583644327628800',null,null,'admin','597576415713120256',null,null,null,'updatetime',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-09-14 10:56:45','String',5,null,'remark',null,'597583644373766144',null,null,'admin','597576415713120256',null,null,null,'remark',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-09-14 10:56:45','String',6,null,'params',null,'597583644419903488',null,null,'admin','597576415713120256',null,null,null,'params',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-09-14 10:56:45','String',7,null,'prodoakbarrelsupplementarymaterialrecordid',null,'597583644470235136',null,null,'admin','597576415713120256',null,null,null,'prodoakbarrelsupplementarymaterialrecordid',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-09-14 10:56:45','String',8,null,'prodoakbarreldetailsrecordid',null,'597583644520566784',null,null,'admin','597576415713120256',null,null,null,'prodoakbarreldetailsrecordid',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-09-14 10:56:45','String',9,null,'supplementarymaterialname',null,'597583644570898432',null,null,'admin','597576415713120256',null,null,null,'supplementarymaterialname',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-09-14 10:56:45','String',10,null,'supplementarymaterialdosage',null,'597583644625424384',null,null,'admin','597576415713120256',null,null,null,'supplementarymaterialdosage',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-09-14 10:56:45','String',11,null,'operatetime',null,'597583644679950336',null,null,'admin','597576415713120256',null,null,null,'operatetime',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-09-14 10:56:45','String',12,null,'operationuser','select user_id as 'value', user_name as 'text' from sys_user','597583644717699072',null,null,'admin','597576415713120256',null,null,null,'operationuser',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-09-14 10:56:45','String',13,null,'bz1',null,'597583644759642112',null,null,'admin','597576415713120256',null,null,null,'bz1',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-09-14 10:56:45','String',14,null,'bz2',null,'597583644797390848',null,null,'admin','597576415713120256',null,null,null,'bz2',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-09-14 10:56:45','String',15,null,'bz3',null,'597583644847722496',null,null,'admin','597576415713120256',null,null,null,'bz3',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-09-14 10:56:45','String',16,null,'oakid','select tank_details_id as 'value', tank_number as 'text' from prod_add_tank_details','597583644927414272',null,null,'admin','597576415713120256',null,null,null,'oakid',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-09-14 10:56:45','597576415713120256','qid',1,null,null,'',null,'597583645002911744',0,null,'admin',null,null,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-09-14 10:56:45','597576415713120256','xid',2,null,null,'',null,'597583645065826304',0,null,'admin',null,null,null,null);