IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_OPENAPI_CUSTOM_SORT')
 delete from t_openapi_custom_sort where fid =  1682515326966793216 ;
IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_OPENAPI_CUSTOM_SORT')
 INSERT INTO t_openapi_custom_sort(fid, fnumber, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fremark)
VALUES(1682515326966793216, 'cm_taskmanage', 'C', 1565339001752164352, 1565339001752164352, '1', {ts'2023-05-11 00:00:00'}, {ts'2023-05-11 00:00:00'}, 1682515326966793216, '企业绩效云-合并报表-任务管理');
IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_OPENAPI_CUSTOM_SORT_L')
 DELETE FROM t_openapi_custom_sort_l WHERE FPKID = '39NRRDPC222A';
IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_OPENAPI_CUSTOM_SORT_L')
 INSERT INTO t_openapi_custom_sort_l(fpkid, fid, flocaleid, fname) VALUES('39NRRDPC222A', 1682515326966793216, 'zh_CN', '任务管理');

IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_OPENAPI_ERRORCODEENTRY')
 delete from t_openapi_errorcodeentry where FENTRYID = 1695567022961818624;
IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_OPENAPI_ERRORCODEENTRY')
 insert into t_openapi_errorcodeentry ( FID, FERRORCODEDESC, FPARENTENTRYID, FERRORCODE, FENTRYID, FSEQ) values ( 1683414966528492544, '开始日期为空', 0, 'cm.100001', 1695567022961818624, '1');
IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_OPENAPI_ERRORCODEENTRY')
 delete from t_openapi_errorcodeentry where FENTRYID = 1695606238840109056;
IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_OPENAPI_ERRORCODEENTRY')
 insert into t_openapi_errorcodeentry ( FID, FERRORCODEDESC, FPARENTENTRYID, FERRORCODE, FENTRYID, FSEQ) values ( 1683414966528492544, '程序错误', 0, 'cm.100002', 1695606238840109056, '2');

delete from t_open_apiservice_L where fpkid =  '39S1V1BZY1P1' ;
insert into t_open_apiservice_L ( fid, fname, fdiscription, flocaleid, fpkid) values ( 1683414966528492544, '查询任务实例', '查询任务实例：返回任务开启时间在指定时间范围内的的任务实例列表信息', 'zh_CN', '39S1V1BZY1P1');

delete from t_open_apiservice where FID = 1683414966528492544;
insert into t_open_apiservice ( FAPISERVICETYPE, FADDEDINFO, FAPIDEFTYPE, FOPERATION, FORDER_BY_HIDE, FMASTERID, FMUSTPARAM, FCREATETIME, FPRESCRIPT, ISFAILCONTINUE, FREQTYPE, FISVID, FALLOWGUEST, FBIZOBJECT, FDISABLERID, FOUTPUTPARAM, FCU_LIMIT_TAC, FFILTERPARAM, FISOUTPARAWITHOUTSTATUS, FREPTYPE, FPRESCRIPT_TAG, FISDYOBJRESULT, FMODIFIERID, FPLUGIN, FWSMETHODNAME, FURLFORMAT, FCUSTOMMETHOD, FISFAILCONTINUE, FINPUTPARAM, FISKSQL, FSELECTPARAM, FCONTENTTYPE, FMETHODNAME, FENABLE, FVERSION, FID, FNAMESPACE, FADDEDINFO_TAG, FURL, FDISABLEDATE, FSAVEOPERATION, FSTATUS, FCUSTOMSORT, FNUMBER, FMESSAGETYPE, FMODIFYTIME, FCLASSNAME, FAPPID, FHTTPMETHOD, FCREATORID) values ( '2', ' ', '2', NULL, ' ', 1683414966528492544, ' ', {ts'2023-05-12 00:00:00'}, ' ', '1', NULL, 'kingdee', '0', ' ', NULL, 'getTaskResponse', '0', ' ', '0', NULL, NULL, '0', 1565339001752164352, NULL, ' ', '/v2/cm/taskmanage/getTask', NULL, '0', 'getTask', '0', ' ', '0', 'getTask', '1', '2', 1683414966528492544, 'http://controller.webapi.bcm.fi.kd', NULL, NULL, NULL, NULL, 'C', 1682515326966793216, 'taskmanage/getTask', NULL, {ts'2023-05-12 00:00:00'}, 'kd.fi.bcm.webapi.taskmanage.controller.TaskManageController', '11H66HLOX4IC', '1', 1565339001752164352);
delete from t_open_apiheaderentry where FENTRYID = 1695567022961817600;
insert into t_open_apiheaderentry ( FID, FHEADERNAME, FENTRYID, FSEQ, FHEADERDES, FHEADERVALUE) values ( 1683414966528492544, 'Content-Type', 1695567022961817600, 1, '内容格式', 'application/json');
delete from t_open_apiheaderentry where FENTRYID = 1695567022961817601;
insert into t_open_apiheaderentry ( FID, FHEADERNAME, FENTRYID, FSEQ, FHEADERDES, FHEADERVALUE) values ( 1683414966528492544, 'accesstoken', 1695567022961817601, 2, '请求令牌', '获取的accesstoken值');
delete from t_open_apiheaderentry where FENTRYID = 1695567022961817602;
insert into t_open_apiheaderentry ( FID, FHEADERNAME, FENTRYID, FSEQ, FHEADERDES, FHEADERVALUE) values ( 1683414966528492544, 'Idempotency-Key', 1695567022961817602, 3, '可选参数，幂等性参数requestId', '1685327261952');
delete from t_open_apirespentry where FENTRYID = 1695566366737792001;
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 ( 1683414966528492544, 'boolean', 1695566366737792001, '0', 'false', 'status', '1', '0', 0, 1, ' ', '1', '状态：true - 成功, false - 失败', ' ');
delete from t_open_apirespentry where FENTRYID = 1695566366746179584;
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 ( 1683414966528492544, 'String', 1695566366746179584, '0', '"x43C4"', 'errorCode', '0', '0', 0, 2, ' ', '1', '错误代码', ' ');
delete from t_open_apirespentry where FENTRYID = 1695566366746180608;
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 ( 1683414966528492544, 'String', 1695566366746180608, '0', '"vEt2m"', 'message', '0', '0', 0, 3, ' ', '1', '错误信息', ' ');
delete from t_open_apirespentry where FENTRYID = 1695566366746179585;
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 ( 1683414966528492544, 'TaskRecordResult', 1695566366746179585, '0', '-', 'data', '0', '0', 0, 4, ' ', '1', 'data', ' ');
delete from t_open_apirespentry where FENTRYID = 1695566366746180609;
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 ( 1683414966528492544, 'Integer', 1695566366746180609, '0', '10', 'totalSize', '0', '0', 1695566366746179585, 5, ' ', '2', '总记录数', ' ');
delete from t_open_apirespentry where FENTRYID = 1695566366746179586;
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 ( 1683414966528492544, 'Integer', 1695566366746179586, '0', '1', 'totalPage', '0', '0', 1695566366746179585, 6, ' ', '2', '总页数', ' ');
delete from t_open_apirespentry where FENTRYID = 1695566366746180610;
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 ( 1683414966528492544, 'List<TaskRecord>', 1695566366746180610, '0', '-', 'tasks', '0', '1', 1695566366746179585, 7, ' ', '2', '任务实例记录', ' ');
delete from t_open_apirespentry where FENTRYID = 1695566366754568192;
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 ( 1683414966528492544, 'Long', 1695566366754568192, '0', '"1657313604422097920"', 'taskId', '0', '0', 1695566366746180610, 8, ' ', '3', '任务ID', ' ');
delete from t_open_apirespentry where FENTRYID = 1695566366754569216;
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 ( 1683414966528492544, 'String', 1695566366754569216, '0', '"合并任务"', 'taskName', '0', '0', 1695566366746180610, 9, ' ', '3', '任务名称', ' ');
delete from t_open_apirespentry where FENTRYID = 1695566366754568193;
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 ( 1683414966528492544, 'Date', 1695566366754568193, '0', '"2023-01-01 00:00:00"', 'taskBeginTime', '0', '0', 1695566366746180610, 10, ' ', '3', '任务开启时间', ' ');
delete from t_open_apirespentry where FENTRYID = 1695566366762957824;
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 ( 1683414966528492544, 'Date', 1695566366762957824, '0', '"2023-02-01 00:00:00"', 'taskEndTime', '0', '0', 1695566366746180610, 11, ' ', '3', '任务结束时间', ' ');
delete from t_open_apirespentry where FENTRYID = 1695566366762956800;
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 ( 1683414966528492544, 'String', 1695566366762956800, '0', '"月报"', 'scenarioName', '0', '0', 1695566366746180610, 12, ' ', '3', '情景', ' ');
delete from t_open_apirespentry where FENTRYID = 1695566366762957825;
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 ( 1683414966528492544, 'String', 1695566366762957825, '0', '"2023年"', 'yearName', '0', '0', 1695566366746180610, 13, ' ', '3', '财年', ' ');
delete from t_open_apirespentry where FENTRYID = 1695566366762956801;
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 ( 1683414966528492544, 'String', 1695566366762956801, '0', '"1月"', 'periodName', '0', '0', 1695566366746180610, 14, ' ', '3', '期间', ' ');
delete from t_open_apibodyentry where FENTRYID = 1695566366729402368;
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 ( 1683414966528492544, '-', ' ', 1695566366729402368, '0', ' ', '0', '0', '1', '1', 'TaskRecordQueryParam', 0, '任务实例查询参数', 1, ' ', 'param');
delete from t_open_apibodyentry where FENTRYID = 1695566366729403392;
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 ( 1683414966528492544, '"2023-01-01 00:00:00"', ' ', 1695566366729403392, '0', ' ', '0', '0', '2', '1', 'Date', 1695566366729402368, '开始日期', 2, ' ', 'beginDate');
delete from t_open_apibodyentry where FENTRYID = 1695566366737790976;
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 ( 1683414966528492544, '"2023-02-01 00:00:00"', ' ', 1695566366737790976, '0', ' ', '0', '0', '2', '0', 'Date', 1695566366729402368, '结束日期', 3, ' ', 'endDate');
delete from t_open_apibodyentry where FENTRYID = 1695566366737792000;
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 ( 1683414966528492544, '1', ' ', 1695566366737792000, '0', ' ', '0', '0', '2', '0', 'Integer', 1695566366729402368, '页数', 4, ' ', 'pageIndex');
delete from t_open_apibodyentry where FENTRYID = 1695566366737790977;
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 ( 1683414966528492544, '1000', ' ', 1695566366737790977, '0', ' ', '0', '0', '2', '0', 'Integer', 1695566366729402368, '每页大小', 5, ' ', 'pageSize');
