/** 人员类型查询接口 */
-- 单据头
DELETE FROM T_OPEN_APISERVICE WHERE FID = 1317213002189017088;
INSERT INTO T_OPEN_APISERVICE(FAPISERVICETYPE,FCUSTOMMETHOD,FOPERATION,FMASTERID,FCONTENTTYPE,FCREATETIME,FENABLE,FREQTYPE,FDISABLERID,FBIZOBJECT,FALLOWGUEST,FID,FDISABLEDATE,FURL,FSTATUS,FNUMBER,FREPTYPE,FMESSAGETYPE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FAPPID,FURLFORMAT,FHTTPMETHOD,FCREATORID) VALUES ('0',' ','query',1317213002189017088,'0',{ts'2021-12-21  00:00:00'},'1',NULL,NULL,'bos_usertype','0',1317213002189017088,NULL,NULL,'C','bos_usertype_query',NULL,NULL,1,' ',{ts'2021-12-21  00:00:00'},'83bfebc8000037ac','/sys/bos_usertype/query','0',1);

DELETE FROM t_open_apiservice_l WHERE FID = 1317213002189017088;
DELETE FROM t_open_apiservice_l WHERE FPKID = '23SMKNGPCPZG';
INSERT INTO t_open_apiservice_l(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (1317213002189017088,'根据条件查询人员类型的详细信息。示例：/kapi/sys/bos_usertype/query?select=id,number,name,category,enable&filter=category EQ ''2'' and enable EQ ''1''&orderby=number','23SMKNGPCPZG','zh_CN','人员类型查询接口');

-- 请求头
DELETE FROM T_OPEN_APIHEADERENTRY WHERE FID = 1317213002189017088;
DELETE FROM T_OPEN_APIHEADERENTRY WHERE FENTRYID = 1317213008723721216;
INSERT INTO T_OPEN_APIHEADERENTRY(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERVALUE,FHEADERDES) VALUES (1317213002189017088,'Content-Type',1317213008723721216,1,'application/json','内容格式');
DELETE FROM T_OPEN_APIHEADERENTRY WHERE FENTRYID = 1317213008723721217;
INSERT INTO T_OPEN_APIHEADERENTRY(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERVALUE,FHEADERDES) VALUES (1317213002189017088,'accesstoken',1317213008723721217,2,'获取的accesstoken值','请求令牌');

-- 请求体
DELETE FROM T_OPEN_APIQUERYPARAMENTRY WHERE FID = 1317213002189017088;
DELETE FROM T_OPEN_APIQUERYPARAMENTRY WHERE FENTRYID = 1317213008723742722;
INSERT INTO T_OPEN_APIQUERYPARAMENTRY(FID,FURLPARAMTYPE,FURLPARAMEXAMPLE,FURLPARAMMUST,FURLPARAMNAME,FENTRYID,FSEQ,FURLPARAMDES) VALUES (1317213002189017088,'String','2','0','category',1317213008723742722,1,'类别：1（内部人员）；2（商务伙伴用户）');
DELETE FROM T_OPEN_APIQUERYPARAMENTRY WHERE FENTRYID = 1317213008723742723;
INSERT INTO T_OPEN_APIQUERYPARAMENTRY(FID,FURLPARAMTYPE,FURLPARAMEXAMPLE,FURLPARAMMUST,FURLPARAMNAME,FENTRYID,FSEQ,FURLPARAMDES) VALUES (1317213002189017088,'String','1','0','enable',1317213008723742723,2,'使用状态：1（可用）；0（禁用）');

-- 返回结果
DELETE FROM T_OPEN_APIRESPENTRY WHERE FID = 1317213002189017088;
DELETE FROM T_OPEN_APIRESPENTRY WHERE FENTRYID = 1317213005083086848;
INSERT INTO T_OPEN_APIRESPENTRY(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1317213002189017088,'id','1','Long',0,1317213005083086848,1,'2','id');
DELETE FROM T_OPEN_APIRESPENTRY WHERE FENTRYID = 1317213005083065345;
INSERT INTO T_OPEN_APIRESPENTRY(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1317213002189017088,'number','1','String',0,1317213005083065345,2,'PT02','编码');
DELETE FROM T_OPEN_APIRESPENTRY WHERE FENTRYID = 1317213005083086849;
INSERT INTO T_OPEN_APIRESPENTRY(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1317213002189017088,'name','1','String',0,1317213005083086849,3,'客户','名称');
DELETE FROM T_OPEN_APIRESPENTRY WHERE FENTRYID = 1317213005083065346;
INSERT INTO T_OPEN_APIRESPENTRY(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1317213002189017088,'category','1','String',0,1317213005083065346,4,'2','类别');
DELETE FROM T_OPEN_APIRESPENTRY WHERE FENTRYID = 1317213005083086850;
INSERT INTO T_OPEN_APIRESPENTRY(FID,FRESPPARAMNAME,FRESPPARAMMUST,FRESPPARAMTYPE,FPARENTENTRYID,FENTRYID,FSEQ,FRESPEXAMPLE,FRESPDES) VALUES (1317213002189017088,'enable','1','String',0,1317213005083086850,5,'1','使用状态：1（可用）；0（禁用）');
