--连接配置
DELETE FROM t_isc_database_link WHERE FID = 2050099602497294336;
INSERT INTO t_isc_database_link(FATTR_E1_ENP,FISV,FSERVER_PORT,FPASSWORD,FICID,FMASTERID,FIERP_PROXY_USER,FCREATETIME,FUSER,FENABLE,FMAX_TPS,FLICENSE_INFO,FNEWPWD_ENP,FID,FCURRENT_ACCOUNT_ID,FHTTP_PROTOCAL,FEAS_SERVICE,FSTATUS,FSOURCE_SYSTEM,FDATABASE_TYPE,FWEB_APP,FNUMBER,FATTR_E2_ENP,FSERVER_IP,FMODIFYTIME,FDUM_LINK,FAPPSECRET_NEW_ENP) VALUES ('d@f*g:SGVsbG8=AUYhUipolqa9u8sADR6qAx+E29hCnWfKra2RwYXNzd29yZA==','kingdee.fi','443',' ','zh_CN',2050099602497294336,0,{ts'2024-09-29  00:00:00'},' ','1',100,'free','d@f*g:SGVsbG8=AUYhUipolqa9u8sADR6qAx+E29hCnWfKra2RwYXNzd29yZA==',2050099602497294336,'1150100171577623552','https','/isc/proxy/','C',0,'CloudHub',' ','yzj','d@f*g:SGVsbG8=AUYhUipolqa9u8sADR6qAx+E29hCnWfKra2RwYXNzd29yZA==','www.yunzhijia.com',{ts'2024-12-09  00:00:00'},'0DOAHG1AUTNN','d@f*g:SGVsbG8=AUYhUipolqa9u8sADR6qAx+E29hCnWfKra2RwYXNzd29yZA==');
DELETE FROM t_isc_database_link_l WHERE FPKID = '4ETU=QOX31JF';
INSERT INTO t_isc_database_link_l(FID,FPKID,FLOCALEID,FNAME) VALUES (2050099602497294336,'4ETU=QOX31JF','zh_CN','云之家');

--数据源
DELETE FROM t_isc_datasource WHERE FID = 2050099739835584512;
INSERT INTO t_isc_datasource(FID,FTYPE,FISV,FCONNECTION_TYPE,FMASTERID,FSTATUS,FNUMBER,FNAME,FLAST_MODIFIED_TIME,FCREATED_TIME,FENABLE,FMQLINK,FREMARK,FPRESET,FDBLINK) VALUES (2050099739835584512,'jdbc','kingdee.fi','CloudHub',2050099739835584512,'C','yzj','云之家',{ts'2024-12-09  00:00:00'},{ts'2024-09-29  00:00:00'},'1',0,' ','0',2050099602497294336);
DELETE FROM t_isc_datasource_l WHERE FPKID = '4ETUAQQ2GNDC';
INSERT INTO t_isc_datasource_l(FID,FPKID,FLOCALEID,FNAME) VALUES (2050099739835584512,'4ETUAQQ2GNDC','zh_CN','云之家');

--webapi
DELETE FROM t_iscb_apic_webapi WHERE FID = 2050101168776237056;
INSERT INTO t_iscb_apic_webapi(FID,FMETHOD,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FURL_PREFIX,FURL_PATH,FOPENAPI_VERSION,FENABLE,FMODIFIERID,FINVOKE_SCRIPT_TAG,FMODIFYTIME,FCONN_TYPE) VALUES (2050101168776237056,'POST',2050101168776237056,'C','yzj_createtodo','云之家待办发送',2050099739835584512,'https://www.yunzhijia.com:443','/gateway/newtodo/open/generatetodo.json','2','1',1924583610208651264,'var url = $$("#{$website}/gateway/newtodo/open/generatetodo.json?accessToken=#{$urlParam.accessToken}");var head = {"Content-Type":"application/json; charset=utf-8","Accept":"application/json"};var dataStr = String.FormatJson($body);return HttpAccess(url, "POST", dataStr, "UTF-8", null, head, 0).result;',{ts'2024-12-12  00:00:00'},'0DOAHG1AUTNN');
DELETE FROM t_iscb_apic_webapi WHERE FID = 2076227455257224192;
INSERT INTO t_iscb_apic_webapi(FID,FMETHOD,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FURL_PREFIX,FURL_PATH,FOPENAPI_VERSION,FENABLE,FMODIFIERID,FINVOKE_SCRIPT_TAG,FMODIFYTIME,FCONN_TYPE) VALUES (2076227455257224192,'POST',2076227455257224192,'C','yzj_accessToken','yzj_accessToken',2050099739835584512,'https://www.yunzhijia.com:443','/gateway/oauth2/token/getAccessToken','2','1',1924583610208651264,'var url = $$("#{$website}/gateway/oauth2/token/getAccessToken");var head = {"Content-Type":"application/json; charset=utf-8","Accept":"application/json"};var dataStr = String.FormatJson($body);return HttpAccess(url, "POST", dataStr, "UTF-8", null, head, 0).result;',{ts'2024-12-12  00:00:00'},'0DOAHG1AUTNN');
DELETE FROM t_iscb_apic_webapi_l WHERE FPKID = '4ETUL4TYO60R';
INSERT INTO t_iscb_apic_webapi_l(FID,FPKID,FLOCALEID,FNAME) VALUES (2050101168776237056,'4ETUL4TYO60R','zh_CN','云之家待办发送');
DELETE FROM t_iscb_apic_webapi_l WHERE FPKID = '4I0/5Z3H28GM';
INSERT INTO t_iscb_apic_webapi_l(FID,FPKID,FLOCALEID,FNAME) VALUES (2076227455257224192,'4I0/5Z3H28GM','zh_CN','yzj_accessToken');


DELETE FROM t_iscb_web_url_params WHERE FENTRYID = 2092241120192164864;
INSERT INTO t_iscb_web_url_params(FID,FURL_PARAM_NAME,FENTRYID,FSEQ,FURL_PARAM_VALUE) VALUES (2050101168776237056,'accessToken',2092241120192164864,1,' ');

DELETE FROM t_iscb_web_req_header WHERE FENTRYID = 2050101168876900352;
INSERT INTO t_iscb_web_req_header(FID,FREQ_H_PARAM_NAME,FENTRYID,FSEQ,FREQ_H_PARAM_VALUE) VALUES (2050101168776237056,'Content-Type',2050101168876900352,1,'application/json; charset=utf-8');
DELETE FROM t_iscb_web_req_header WHERE FENTRYID = 2050101168876900353;
INSERT INTO t_iscb_web_req_header(FID,FREQ_H_PARAM_NAME,FENTRYID,FSEQ,FREQ_H_PARAM_VALUE) VALUES (2050101168776237056,'Accept',2050101168876900353,2,'application/json');
DELETE FROM t_iscb_web_req_header WHERE FENTRYID = 2076227455282390016;
INSERT INTO t_iscb_web_req_header(FID,FREQ_H_PARAM_NAME,FENTRYID,FSEQ,FREQ_H_PARAM_VALUE) VALUES (2076227455257224192,'Content-Type',2076227455282390016,1,'application/json; charset=utf-8');
DELETE FROM t_iscb_web_req_header WHERE FENTRYID = 2076227455282390017;
INSERT INTO t_iscb_web_req_header(FID,FREQ_H_PARAM_NAME,FENTRYID,FSEQ,FREQ_H_PARAM_VALUE) VALUES (2076227455257224192,'Accept',2076227455282390017,2,'application/json');

DELETE FROM t_iscb_web_req_body WHERE FENTRYID = 2076314087356441600;
INSERT INTO t_iscb_web_req_body(FID,FREQ_B_PARAM_NAME,FREQ_B_PARAM_VALUE,FPARENTENTRYID,FREQ_B_PARAM_TYPE,FENTRYID,FSEQ,FREQ_B_PARAM_DESC,FREQ_B_PARAM_EXAMPLE) VALUES (2076227455257224192,'scope','app',0,'string',2076314087356441600,2,'授权级别（"app"）',' ');
DELETE FROM t_iscb_web_req_body WHERE FENTRYID = 2076314091710129152;
INSERT INTO t_iscb_web_req_body(FID,FREQ_B_PARAM_NAME,FREQ_B_PARAM_VALUE,FPARENTENTRYID,FREQ_B_PARAM_TYPE,FENTRYID,FSEQ,FREQ_B_PARAM_DESC,FREQ_B_PARAM_EXAMPLE) VALUES (2076227455257224192,'secret',' ',0,'string',2076314091710129152,3,'密钥',' ');
DELETE FROM t_iscb_web_req_body WHERE FENTRYID = 2076313794644353024;
INSERT INTO t_iscb_web_req_body(FID,FREQ_B_PARAM_NAME,FREQ_B_PARAM_VALUE,FPARENTENTRYID,FREQ_B_PARAM_TYPE,FENTRYID,FSEQ,FREQ_B_PARAM_DESC,FREQ_B_PARAM_EXAMPLE) VALUES (2076227455257224192,'appId',' ',0,'string',2076313794644353024,1,'轻应用id',' ');
DELETE FROM t_iscb_web_req_body WHERE FENTRYID = 2076317662547280896;
INSERT INTO t_iscb_web_req_body(FID,FREQ_B_PARAM_NAME,FREQ_B_PARAM_VALUE,FPARENTENTRYID,FREQ_B_PARAM_TYPE,FENTRYID,FSEQ,FREQ_B_PARAM_DESC,FREQ_B_PARAM_EXAMPLE) VALUES (2050101168776237056,'appId',' ',0,'string',2076317662547280896,1,' ',' ');
DELETE FROM t_iscb_web_req_body WHERE FENTRYID = 2076314093740172288;
INSERT INTO t_iscb_web_req_body(FID,FREQ_B_PARAM_NAME,FREQ_B_PARAM_VALUE,FPARENTENTRYID,FREQ_B_PARAM_TYPE,FENTRYID,FSEQ,FREQ_B_PARAM_DESC,FREQ_B_PARAM_EXAMPLE) VALUES (2076227455257224192,'timestamp',' ',0,'long',2076314093740172288,4,' ',' ');
DELETE FROM t_iscb_web_req_body WHERE FENTRYID = 2076317664334061568;
INSERT INTO t_iscb_web_req_body(FID,FREQ_B_PARAM_NAME,FREQ_B_PARAM_VALUE,FPARENTENTRYID,FREQ_B_PARAM_TYPE,FENTRYID,FSEQ,FREQ_B_PARAM_DESC,FREQ_B_PARAM_EXAMPLE) VALUES (2050101168776237056,'sourceId',' ',0,'string',2076317664334061568,2,' ',' ');
DELETE FROM t_iscb_web_req_body WHERE FENTRYID = 2076317666867414016;
INSERT INTO t_iscb_web_req_body(FID,FREQ_B_PARAM_NAME,FREQ_B_PARAM_VALUE,FPARENTENTRYID,FREQ_B_PARAM_TYPE,FENTRYID,FSEQ,FREQ_B_PARAM_DESC,FREQ_B_PARAM_EXAMPLE) VALUES (2050101168776237056,'sync',' ',0,'boolean',2076317666867414016,3,'是否同步，true:同步;false:异步',' ');
DELETE FROM t_iscb_web_req_body WHERE FENTRYID = 2076317668578697216;
INSERT INTO t_iscb_web_req_body(FID,FREQ_B_PARAM_NAME,FREQ_B_PARAM_VALUE,FPARENTENTRYID,FREQ_B_PARAM_TYPE,FENTRYID,FSEQ,FREQ_B_PARAM_DESC,FREQ_B_PARAM_EXAMPLE) VALUES (2050101168776237056,'todoType','0',0,'int',2076317668578697216,4,'0：待办；1：待审批','0');
DELETE FROM t_iscb_web_req_body WHERE FENTRYID = 2076317671330160640;
INSERT INTO t_iscb_web_req_body(FID,FREQ_B_PARAM_NAME,FREQ_B_PARAM_VALUE,FPARENTENTRYID,FREQ_B_PARAM_TYPE,FENTRYID,FSEQ,FREQ_B_PARAM_DESC,FREQ_B_PARAM_EXAMPLE) VALUES (2050101168776237056,'url',' ',0,'string',2076317671330160640,5,' ',' ');
DELETE FROM t_iscb_web_req_body WHERE FENTRYID = 2076319552878157824;
INSERT INTO t_iscb_web_req_body(FID,FREQ_B_PARAM_NAME,FREQ_B_PARAM_VALUE,FPARENTENTRYID,FREQ_B_PARAM_TYPE,FENTRYID,FSEQ,FREQ_B_PARAM_DESC,FREQ_B_PARAM_EXAMPLE) VALUES (2050101168776237056,'content',' ',0,'string',2076319552878157824,6,' ',' ');
DELETE FROM t_iscb_web_req_body WHERE FENTRYID = 2076319556829185024;
INSERT INTO t_iscb_web_req_body(FID,FREQ_B_PARAM_NAME,FREQ_B_PARAM_VALUE,FPARENTENTRYID,FREQ_B_PARAM_TYPE,FENTRYID,FSEQ,FREQ_B_PARAM_DESC,FREQ_B_PARAM_EXAMPLE) VALUES (2050101168776237056,'title',' ',0,'string',2076319556829185024,7,' ',' ');
DELETE FROM t_iscb_web_req_body WHERE FENTRYID = 2076319664530530304;
INSERT INTO t_iscb_web_req_body(FID,FREQ_B_PARAM_NAME,FREQ_B_PARAM_VALUE,FPARENTENTRYID,FREQ_B_PARAM_TYPE,FENTRYID,FSEQ,FREQ_B_PARAM_DESC,FREQ_B_PARAM_EXAMPLE) VALUES (2050101168776237056,'itemtitle',' ',0,'string',2076319664530530304,8,' ',' ');
DELETE FROM t_iscb_web_req_body WHERE FENTRYID = 2076319748928308224;
INSERT INTO t_iscb_web_req_body(FID,FREQ_B_PARAM_NAME,FREQ_B_PARAM_VALUE,FPARENTENTRYID,FREQ_B_PARAM_TYPE,FENTRYID,FSEQ,FREQ_B_PARAM_DESC,FREQ_B_PARAM_EXAMPLE) VALUES (2050101168776237056,'headImg',' ',0,'string',2076319748928308224,9,'待办消息图标icon',' ');
DELETE FROM t_iscb_web_req_body WHERE FENTRYID = 2076319804377014272;
INSERT INTO t_iscb_web_req_body(FID,FREQ_B_PARAM_NAME,FREQ_B_PARAM_VALUE,FPARENTENTRYID,FREQ_B_PARAM_TYPE,FENTRYID,FSEQ,FREQ_B_PARAM_DESC,FREQ_B_PARAM_EXAMPLE) VALUES (2050101168776237056,'senderId',' ',0,'string',2076319804377014272,10,' ',' ');
DELETE FROM t_iscb_web_req_body WHERE FENTRYID = 2092714726378514432;
INSERT INTO t_iscb_web_req_body(FID,FREQ_B_PARAM_NAME,FREQ_B_PARAM_VALUE,FPARENTENTRYID,FREQ_B_PARAM_TYPE,FENTRYID,FSEQ,FREQ_B_PARAM_DESC,FREQ_B_PARAM_EXAMPLE) VALUES (2050101168776237056,'params',' ',0,'unknown',2092714726378514432,11,'用户oid',' ');
