-- 文件上传接口
DELETE FROM t_openapi_custom_sort WHERE FID = 1722549145908159488;
INSERT INTO t_openapi_custom_sort(FID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (1722549145908159488,{ts'2023-07-05  00:00:00'},1547107182208928768,'1',{ts'2023-07-05  00:00:00'},1722549145908159488,'C',1547107182208928768,'bei_uploadfile');

DELETE FROM t_openapi_custom_sort_l WHERE FPKID = '3DKJX5=DK0E3';
INSERT INTO t_openapi_custom_sort_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1722549145908159488,'3DKJX5=DK0E3','zh_CN','文件上传');
DELETE FROM t_openapi_custom_sort_l WHERE FPKID = '3DKJX5=DK0E4';
INSERT INTO t_openapi_custom_sort_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1722549145908159488,'3DKJX5=DK0E4','zh_TW','文件上傳');



delete from t_openapi_ext where FENTRYID =  '1722591729284063235' ;
insert into t_openapi_ext ( FID, FENTRYID, FSEQ, FEXT_VALUE, FEXT_KEY) values ( '1722591729200288768', '1722591729284063235', '1', ' ', 'hiddenplugin');
delete from t_open_apiservice_L where fpkid =  '3DKRVG+4+OJV' ;
insert into t_open_apiservice_L ( fid, fname, fdiscription, flocaleid, fpkid) values ( '1722591729200288768', '文件上传单文件服务器', ' ', 'zh_CN', '3DKRVG+4+OJV');
delete from t_open_apiservice_L where fpkid =  '3DKRVG+4+OJW' ;
insert into t_open_apiservice_L ( fid, fname, fdiscription, flocaleid, fpkid) values ( '1722591729200288768', '文件上傳單文件服務器', ' ', 'zh_TW', '3DKRVG+4+OJW');
delete from t_open_apiservice where FID =  '1722591729200288768' ;
insert into t_open_apiservice ( FAPISERVICETYPE, FADDEDINFO, FAPIDEFTYPE, FORG_AUTHOR_FILTER, FOPERATION, FORDER_BY_HIDE, FMASTERID, FMUSTPARAM, FSTDMODIFYTIME, FCREATETIME, FPRESCRIPT, ISFAILCONTINUE, FREQTYPE, FISVID, FALLOWGUEST, FBIZOBJECT, FDISABLERID, FOUTPUTPARAM, FCU_LIMIT_TAC, FFILTERPARAM, FIS_ONLY_THIRDAPP_AUTH, FISOUTPARAWITHOUTSTATUS, FREPTYPE, FPRESCRIPT_TAG, FISDYOBJRESULT, FCOSMICVER, FMODIFIERID, FPLUGIN, FWSMETHODNAME, FURLFORMAT, FCHECK_REPEAT_REQ, FCUSTOMMETHOD, FISFAILCONTINUE, FINPUTPARAM, FISKSQL, FSELECTPARAM, FCONTENTTYPE, FMETHODNAME, FENABLE, FISDESENSITIZE, FVERSION, FID, FIS_SYS_API, FNAMESPACE, FADDEDINFO_TAG, FURL, FDISABLEDATE, FSAVEOPERATION, FSTATUS, FCUSTOMSORT, FNUMBER, FMESSAGETYPE, FMODIFYTIME, FCLASSNAME, FAPPID, FHTTPMETHOD, FCREATORID) values ( '2', ' ', '2', '0', NULL, ' ', '1722591729200288768', ' ',{ts'2023-07-05 17:26:06'},{ts'2023-07-05 17:21:14'}, ' ', '1', NULL, 'kingdee', '0', ' ', NULL, 'uploadFileResponse', '0', ' ', '1', '0', NULL, NULL, '0', '5.0.024', '1547107182208928768', ' ', ' ', '/v2/bei/openapi/bei/fileupload/uploadFile', '0', NULL, '0', 'uploadFile', '0', ' ', '0', 'uploadFile', '1', ' ', '2', '1722591729200288768', '0', 'http://openapi.webapi.bei.tmc.kd', NULL, NULL, NULL, NULL, 'C', '1722549145908159488', 'openapi/bei/fileupload/uploadFile', NULL,{ts'2023-07-05 17:26:06'}, 'kd.tmc.bei.webapi.openapi.FileUploadController', '/LSWHQ7US+Q6', '1', '1547107182208928768');
delete from t_open_apiheaderentry where FENTRYID =  '1722591729284063232' ;
insert into t_open_apiheaderentry ( FID, FHEADERNAME, FENTRYID, FSEQ, FHEADERDES, FHEADERVALUE) values ( '1722591729200288768', 'Content-Type', '1722591729284063232', '1', '内容格式', 'application/json');
delete from t_open_apiheaderentry where FENTRYID =  '1722591729284063233' ;
insert into t_open_apiheaderentry ( FID, FHEADERNAME, FENTRYID, FSEQ, FHEADERDES, FHEADERVALUE) values ( '1722591729200288768', 'accesstoken', '1722591729284063233', '2', '请求令牌', '获取的accesstoken值');
delete from t_open_apiheaderentry where FENTRYID =  '1722591729284063234' ;
insert into t_open_apiheaderentry ( FID, FHEADERNAME, FENTRYID, FSEQ, FHEADERDES, FHEADERVALUE) values ( '1722591729200288768', 'Idempotency-Key', '1722591729284063234', '3', '非必传参数，防止接口被重复调用', '唯一的requestId');
delete from t_open_apirespentry where FENTRYID =  '1722591367961550848' ;
insert into t_open_apirespentry ( FID, FRESPPARAMTYPE, FENTRYID, FIS_RESP_CUSTOM, FRESPEXAMPLE, FRESPPARAMNAME, FRESPPARAMMUST, FIS_RESP_MUL_VALUE, FPARENTENTRYID, FSEQ, FRESP_DATA_MODEL, FRESP_LEVEL, FRESPDES, FRESPOBJPROPNAME) values ( '1722591729200288768', 'boolean', '1722591367961550848', '0', 'false', 'status', '1', '0', '0', '1', ' ', '1', '状态：true - 成功, false - 失败', ' ');
delete from t_open_apirespentry where FENTRYID =  '1722591367961662464' ;
insert into t_open_apirespentry ( FID, FRESPPARAMTYPE, FENTRYID, FIS_RESP_CUSTOM, FRESPEXAMPLE, FRESPPARAMNAME, FRESPPARAMMUST, FIS_RESP_MUL_VALUE, FPARENTENTRYID, FSEQ, FRESP_DATA_MODEL, FRESP_LEVEL, FRESPDES, FRESPOBJPROPNAME) values ( '1722591729200288768', 'String', '1722591367961662464', '0', '"A9TBu"', 'errorCode', '0', '0', '0', '2', ' ', '1', '错误代码', ' ');
delete from t_open_apirespentry where FENTRYID =  '1722591367969939456' ;
insert into t_open_apirespentry ( FID, FRESPPARAMTYPE, FENTRYID, FIS_RESP_CUSTOM, FRESPEXAMPLE, FRESPPARAMNAME, FRESPPARAMMUST, FIS_RESP_MUL_VALUE, FPARENTENTRYID, FSEQ, FRESP_DATA_MODEL, FRESP_LEVEL, FRESPDES, FRESPOBJPROPNAME) values ( '1722591729200288768', 'String', '1722591367969939456', '0', '"RWaeF"', 'message', '0', '0', '0', '3', ' ', '1', '错误信息', ' ');
delete from t_open_apirespentry where FENTRYID =  '1722591367970051072' ;
insert into t_open_apirespentry ( FID, FRESPPARAMTYPE, FENTRYID, FIS_RESP_CUSTOM, FRESPEXAMPLE, FRESPPARAMNAME, FRESPPARAMMUST, FIS_RESP_MUL_VALUE, FPARENTENTRYID, FSEQ, FRESP_DATA_MODEL, FRESP_LEVEL, FRESPDES, FRESPOBJPROPNAME) values ( '1722591729200288768', 'String', '1722591367970051072', '0', '"w7lBn"', 'data', '0', '0', '0', '4', ' ', '1', '上传后的url', ' ');
delete from t_open_apibodyentry where FENTRYID =  '1722591367944885248' ;
insert into t_open_apibodyentry ( FID, FEXAMPLE, FBODY_DATA_MODEL, FENTRYID, FIS_UNIQUE_KEY, FOBJPROPNAME, FIS_MUL_VALUE, FIS_BODY_CUSTOM, FBODY_LEVEL, FMUST, FPARAMTYPE, FPARENTENTRYID, FBODYPARAMDES, FSEQ, FDEFAULTVALUE, FPARAMNAME) values ( '1722591729200288768', '-', ' ', '1722591367944885248', '0', ' ', '0', '0', '1', '0', 'OpenApiFile', '0', '文件流', '1', ' ', 'file');

-- 电子对账单上传接口
delete from t_openapi_ext where FENTRYID =  '1671015561871976448' ;
insert into t_openapi_ext ( FID, FENTRYID, FSEQ, FEXT_VALUE, FEXT_KEY) values ( '1671015543878288384', '1671015561871976448', '1', ' ', 'hiddenplugin');
delete from t_open_apiservice_L where fpkid =  '388O1TLV9WT1' ;
insert into t_open_apiservice_L ( fid, fname, fdiscription, flocaleid, fpkid) values ( '1671015543878288384', '电子对账单文件流导入接口', 'ElecStatementFileInfo中有3个属性String fileName;  （文件名） boolean isCover;（是否覆盖）  byte[] fileData;（字节流）', 'zh_CN', '388O1TLV9WT1');
delete from t_open_apiservice_L where fpkid =  '388O1TLV9WT2' ;
insert into t_open_apiservice_L ( fid, fname, fdiscription, flocaleid, fpkid) values ( '1671015543878288384', '電子對賬單文件流導入接口', 'ElecStatementFileInfo中有3個屬性String fileName;  （文件名） boolean isCover;（是否覆蓋）  byte[] fileData;（字節流）', 'zh_TW', '388O1TLV9WT2');
delete from t_open_apiservice where FID =  '1671015543878288384' ;
insert into t_open_apiservice ( FAPISERVICETYPE, FADDEDINFO, FAPIDEFTYPE, FORG_AUTHOR_FILTER, FOPERATION, FORDER_BY_HIDE, FMASTERID, FMUSTPARAM, FSTDMODIFYTIME, FCREATETIME, FPRESCRIPT, ISFAILCONTINUE, FREQTYPE, FISVID, FALLOWGUEST, FBIZOBJECT, FDISABLERID, FOUTPUTPARAM, FCU_LIMIT_TAC, FFILTERPARAM, FIS_ONLY_THIRDAPP_AUTH, FISOUTPARAWITHOUTSTATUS, FREPTYPE, FPRESCRIPT_TAG, FISDYOBJRESULT, FCOSMICVER, FMODIFIERID, FPLUGIN, FWSMETHODNAME, FURLFORMAT, FCHECK_REPEAT_REQ, FCUSTOMMETHOD, FISFAILCONTINUE, FINPUTPARAM, FISKSQL, FSELECTPARAM, FCONTENTTYPE, FMETHODNAME, FENABLE, FISDESENSITIZE, FVERSION, FID, FIS_SYS_API, FNAMESPACE, FADDEDINFO_TAG, FURL, FDISABLEDATE, FSAVEOPERATION, FSTATUS, FCUSTOMSORT, FNUMBER, FMESSAGETYPE, FMODIFYTIME, FCLASSNAME, FAPPID, FHTTPMETHOD, FCREATORID) values ( '2', ' ', '2', '0', NULL, ' ', '1671015543878288384', ' ',{ts'2023-07-12 13:54:12'},{ts'2023-04-25 09:19:46'}, ' ', '1', NULL, 'kingdee', '0', ' ', NULL, 'uploadFileResponse', '0', ' ', '1', '0', NULL, NULL, '0', '5.0.018', '1547107182208928768', ' ', ' ', '/v2/bei/openapi/bei/elecstatement/uploadFile', '0', NULL, '0', 'uploadFile', '0', ' ', '0', 'uploadFile', '1', ' ', '2', '1671015543878288384', '0', 'http://openapi.webapi.bei.tmc.kd', NULL, NULL, NULL, NULL, 'C', '1671124987060391936', 'openapi/bei/elecstatement/uploadFile', NULL,{ts'2023-07-12 13:54:12'}, 'kd.tmc.bei.webapi.openapi.ElecStatementFileUploadController', '/LSWHQ7US+Q6', '1', '1547107182208928768');
delete from t_open_apiheaderentry where FENTRYID =  '1727506016343741440' ;
insert into t_open_apiheaderentry ( FID, FHEADERNAME, FENTRYID, FSEQ, FHEADERDES, FHEADERVALUE) values ( '1671015543878288384', 'Content-Type', '1727506016343741440', '1', '内容格式', 'application/json');
delete from t_open_apiheaderentry where FENTRYID =  '1727506016343741441' ;
insert into t_open_apiheaderentry ( FID, FHEADERNAME, FENTRYID, FSEQ, FHEADERDES, FHEADERVALUE) values ( '1671015543878288384', 'accesstoken', '1727506016343741441', '2', '请求令牌', '获取的accesstoken值');
delete from t_open_apiheaderentry where FENTRYID =  '1727506016343741442' ;
insert into t_open_apiheaderentry ( FID, FHEADERNAME, FENTRYID, FSEQ, FHEADERDES, FHEADERVALUE) values ( '1671015543878288384', 'Idempotency-Key', '1727506016343741442', '3', '非必传参数，防止接口被重复调用', '唯一的requestId');
delete from t_open_apirespentry where FENTRYID =  '1727505492055741440' ;
insert into t_open_apirespentry ( FID, FRESPPARAMTYPE, FENTRYID, FIS_RESP_CUSTOM, FRESPEXAMPLE, FRESPPARAMNAME, FRESPPARAMMUST, FIS_RESP_MUL_VALUE, FPARENTENTRYID, FSEQ, FRESP_DATA_MODEL, FRESP_LEVEL, FRESPDES, FRESPOBJPROPNAME) values ( '1671015543878288384', 'boolean', '1727505492055741440', '0', 'false', 'status', '1', '0', '0', '1', ' ', '1', '状态：true - 成功, false - 失败', ' ');
delete from t_open_apirespentry where FENTRYID =  '1727505492055742464' ;
insert into t_open_apirespentry ( FID, FRESPPARAMTYPE, FENTRYID, FIS_RESP_CUSTOM, FRESPEXAMPLE, FRESPPARAMNAME, FRESPPARAMMUST, FIS_RESP_MUL_VALUE, FPARENTENTRYID, FSEQ, FRESP_DATA_MODEL, FRESP_LEVEL, FRESPDES, FRESPOBJPROPNAME) values ( '1671015543878288384', 'String', '1727505492055742464', '0', '"nzCHP"', 'errorCode', '0', '0', '0', '2', ' ', '1', '错误代码', ' ');
delete from t_open_apirespentry where FENTRYID =  '1727505492064130048' ;
insert into t_open_apirespentry ( FID, FRESPPARAMTYPE, FENTRYID, FIS_RESP_CUSTOM, FRESPEXAMPLE, FRESPPARAMNAME, FRESPPARAMMUST, FIS_RESP_MUL_VALUE, FPARENTENTRYID, FSEQ, FRESP_DATA_MODEL, FRESP_LEVEL, FRESPDES, FRESPOBJPROPNAME) values ( '1671015543878288384', 'String', '1727505492064130048', '0', '"ct472"', 'message', '0', '0', '0', '3', ' ', '1', '错误信息', ' ');
delete from t_open_apirespentry where FENTRYID =  '1727505492064131072' ;
insert into t_open_apirespentry ( FID, FRESPPARAMTYPE, FENTRYID, FIS_RESP_CUSTOM, FRESPEXAMPLE, FRESPPARAMNAME, FRESPPARAMMUST, FIS_RESP_MUL_VALUE, FPARENTENTRYID, FSEQ, FRESP_DATA_MODEL, FRESP_LEVEL, FRESPDES, FRESPOBJPROPNAME) values ( '1671015543878288384', 'String', '1727505492064131072', '0', '"We7KP"', 'data', '0', '0', '0', '4', ' ', '1', 'data', ' ');
delete from t_open_apibodyentry where FENTRYID =  '1727505492047353856' ;
insert into t_open_apibodyentry ( FID, FEXAMPLE, FBODY_DATA_MODEL, FENTRYID, FIS_UNIQUE_KEY, FOBJPROPNAME, FIS_MUL_VALUE, FIS_BODY_CUSTOM, FBODY_LEVEL, FMUST, FPARAMTYPE, FPARENTENTRYID, FBODYPARAMDES, FSEQ, FDEFAULTVALUE, FPARAMNAME) values ( '1671015543878288384', '-', ' ', '1727505492047353856', '0', ' ', '1', '0', '1', '0', 'List<ElecStatementFileInfo>', '0', '文件流', '1', ' ', 'datas');
