DELETE FROM t_hrcs_function WHERE FID = 1660799620365898752;
INSERT INTO t_hrcs_function(FID,FISSYSPRESET,FEXAMPLE,FDISABLEDATE,FDEFINE,FDESCRIPTION,FMASTERID,FSTATUS,FFUNSOURCE,FNUMBER,FNAME,FGROUPID,FUNIQUECODE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFUNCDATATYPE,FCREATORID,FDISABLERID,FFUNKEY) VALUES (1660799620365898752,'1','STRING( DATE("2018-08-08") ) , 返回 "2020-08-08"',NULL,'STRING','把任意类型值转换为字符串',1660799620365898752,'C','Platform','103003_S','转换为字符串',1030,'1660799620365898752',{ts'2023-04-11  00:00:00'},1633449423235186688,'1',{ts'2023-04-11  00:00:00'},'String',1633449423235186688,0,'STRING');
DELETE FROM t_hrcs_function WHERE FID = 1660775838578130944;
INSERT INTO t_hrcs_function(FID,FISSYSPRESET,FEXAMPLE,FDISABLEDATE,FDEFINE,FDESCRIPTION,FMASTERID,FSTATUS,FFUNSOURCE,FNUMBER,FNAME,FGROUPID,FUNIQUECODE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFUNCDATATYPE,FCREATORID,FDISABLERID,FFUNKEY) VALUES (1660775838578130944,'1','CONCAT("a", "b", "c") 返回"abc"',NULL,'CONCAT','把传入的字符串数组，拼接成一个完整的字符串返回',1660775838578130944,'C','Platform','103011_S','拼接字符串',1030,'1660775838578130944',{ts'2023-04-11  00:00:00'},1633449423235186688,'1',{ts'2023-04-11  00:00:00'},'String',1633449423235186688,0,'CONCAT');
DELETE FROM t_hrcs_function WHERE FID = 1660782863928280064;
INSERT INTO t_hrcs_function(FID,FISSYSPRESET,FEXAMPLE,FDISABLEDATE,FDEFINE,FDESCRIPTION,FMASTERID,FSTATUS,FFUNSOURCE,FNUMBER,FNAME,FGROUPID,FUNIQUECODE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFUNCDATATYPE,FCREATORID,FDISABLERID,FFUNKEY) VALUES (1660782863928280064,'1','if(a > b, a, b) 如果a大于b，返回a，否则返回b',NULL,'ifcondition','执行条件判断，根据条件判断结果分别输出不同的值',1660782863928280064,'C','Platform','107001_S','按条件取数',1636421427953413120,'1660782863928280064',{ts'2023-04-11  00:00:00'},1633449423235186688,'1',{ts'2023-04-11  00:00:00'},'Object',1633449423235186688,0,'IF');
DELETE FROM t_hrcs_function WHERE FID = 1660788721198317568;
INSERT INTO t_hrcs_function(FID,FISSYSPRESET,FEXAMPLE,FDISABLEDATE,FDEFINE,FDESCRIPTION,FMASTERID,FSTATUS,FFUNSOURCE,FNUMBER,FNAME,FGROUPID,FUNIQUECODE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFUNCDATATYPE,FCREATORID,FDISABLERID,FFUNKEY) VALUES (1660788721198317568,'1','max(1,2) 返回2',NULL,'max','从传入的数值数组中，取最大值返回',1660788721198317568,'C','Platform','107004_S','最大',1636421427953413120,'1660788721198317568',{ts'2023-04-11  00:00:00'},1633449423235186688,'1',{ts'2023-04-11  00:00:00'},'BigDecimal',1633449423235186688,0,'max');
DELETE FROM t_hrcs_function WHERE FID = 1660787754025369600;
INSERT INTO t_hrcs_function(FID,FISSYSPRESET,FEXAMPLE,FDISABLEDATE,FDEFINE,FDESCRIPTION,FMASTERID,FSTATUS,FFUNSOURCE,FNUMBER,FNAME,FGROUPID,FUNIQUECODE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFUNCDATATYPE,FCREATORID,FDISABLERID,FFUNKEY) VALUES (1660787754025369600,'1','min(1,2) 返回 1',NULL,'min','从传入的数值数组中，取最小值返回',1660787754025369600,'C','Platform','107003_S','最小',1636421427953413120,'1660787754025369600',{ts'2023-04-11  00:00:00'},1633449423235186688,'1',{ts'2023-04-11  00:00:00'},'BigDecimal',1633449423235186688,0,'min');
DELETE FROM t_hrcs_function WHERE FID = 1660785591459005440;
INSERT INTO t_hrcs_function(FID,FISSYSPRESET,FEXAMPLE,FDISABLEDATE,FDEFINE,FDESCRIPTION,FMASTERID,FSTATUS,FFUNSOURCE,FNUMBER,FNAME,FGROUPID,FUNIQUECODE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFUNCDATATYPE,FCREATORID,FDISABLERID,FFUNKEY) VALUES (1660785591459005440,'1','sum(1,2) 返回 3',NULL,'sum','合计传入的数值数组',1660785591459005440,'C','Platform','107002_S','合计',1636421427953413120,'1660785591459005440',{ts'2023-04-11  00:00:00'},1633449423235186688,'1',{ts'2023-04-11  00:00:00'},'BigDecimal',1633449423235186688,0,'sum');
DELETE FROM t_hrcs_function WHERE FID = 1660791180931121152;
INSERT INTO t_hrcs_function(FID,FISSYSPRESET,FEXAMPLE,FDISABLEDATE,FDEFINE,FDESCRIPTION,FMASTERID,FSTATUS,FFUNSOURCE,FNUMBER,FNAME,FGROUPID,FUNIQUECODE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFUNCDATATYPE,FCREATORID,FDISABLERID,FFUNKEY) VALUES (1660791180931121152,'1','count(1,2) 返回2; count() 返回0',NULL,'count','对传入的数组计数',1660791180931121152,'C','Platform','107005_S','计数',1636421427953413120,'1660791180931121152',{ts'2023-04-11  00:00:00'},1633449423235186688,'1',{ts'2023-04-11  00:00:00'},'Integer',1633449423235186688,0,'count');
DELETE FROM t_hrcs_function WHERE FID = 1660794148091024384;
INSERT INTO t_hrcs_function(FID,FISSYSPRESET,FEXAMPLE,FDISABLEDATE,FDEFINE,FDESCRIPTION,FMASTERID,FSTATUS,FFUNSOURCE,FNUMBER,FNAME,FGROUPID,FUNIQUECODE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFUNCDATATYPE,FCREATORID,FDISABLERID,FFUNKEY) VALUES (1660794148091024384,'1','avg(1.0, 2.0) 返回1.5',NULL,'avg','对传入的数值数组求和后取平均值',1660794148091024384,'C','Platform','107006_S','平均',1636421427953413120,'1660794148091024384',{ts'2023-04-11  00:00:00'},1633449423235186688,'1',{ts'2023-04-11  00:00:00'},'BigDecimal',1633449423235186688,0,'avg');
DELETE FROM t_hrcs_function WHERE FID = 1660795798868415488;
INSERT INTO t_hrcs_function(FID,FISSYSPRESET,FEXAMPLE,FDISABLEDATE,FDEFINE,FDESCRIPTION,FMASTERID,FSTATUS,FFUNSOURCE,FNUMBER,FNAME,FGROUPID,FUNIQUECODE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FFUNCDATATYPE,FCREATORID,FDISABLERID,FFUNKEY) VALUES (1660795798868415488,'1','EMPTY_TO_INT(null, 0), 则返回0;',NULL,'EMPTYTOINT','如果传入整数为null，则返回默认值；否则返回传入的整数本身',1660795798868415488,'C','Platform','108002_S','空值处理（整数）',1636421558564028416,'1660795798868415488',{ts'2023-04-11  00:00:00'},1633449423235186688,'1',{ts'2023-04-11  00:00:00'},'Integer',1633449423235186688,0,'EMPTY_TO_INT');