219 lines
64 KiB
SQL
219 lines
64 KiB
SQL
insert into "LOWCODE_FRAME"."LOWCODE_REPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_NAME", "REPORT_CODE", "GROUP_REPORT_ID", "JAVA_CONFIG", "DATA_CONFIG", "TABLE_CONFIG", "DATA_SOURCES_CONFIG", "DATA_SOURCES_CODE") values(1971858622197571586, 1, 1, '2025-09-27 16:45:06', 100, null, '2025-09-27 16:45:06', 0, '大屏-园区-高危作业明细', 'dp_yq_danger_detail', 1971828164688650242, '', 'page,authFalse', 'height,header,menu,index,border', '{"dataOrigin":"1964253329070571521","executeSql":"select Concat(a.sDate,''至'',a.eDate,a.applyDepName,a.UserName,a.Mobile) as ContentText from (\r\n-- 未开始\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\n-- 进行中\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a \r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate < NOW() and a.operationEndDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate < NOW() and a.operationEndDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\n-- 已完成\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a \r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationEndDate > TRUNC(SYSDATE, ''MM'') and a.operationEndDate < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id \r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationEndDate > TRUNC(SYSDATE, ''MM'') and a.operationEndDate < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0) a\r\ninner join LOWCODE_MASTER.SYSTEM_DEPT b on a.APPLYDEPID=b.id\r\n\r\n","optionData":{"optionObj":{"select":[],"from":[],"where":[],"groupBy":"","having":"","orderBy":[]},"customSql":"select Concat(a.sDate,''至'',a.eDate,a.applyDepName,a.UserName,a.Mobile) as ContentText from (\r\n-- 未开始\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\n-- 进行中\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a \r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate < NOW() and a.operationEndDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate < NOW() and a.operationEndDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\n-- 已完成\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a \r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationEndDate > TRUNC(SYSDATE, ''MM'') and a.operationEndDate < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id \r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationEndDate > TRUNC(SYSDATE, ''MM'') and a.operationEndDate < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0) a\r\ninner join LOWCODE_MASTER.SYSTEM_DEPT b on a.APPLYDEPID=b.id\r\n\r\n","aliasObj":{"lc_high_operation":"tbl_lho"},"typeKey":"custom"}}', 'master');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_NAME", "REPORT_CODE", "GROUP_REPORT_ID", "JAVA_CONFIG", "DATA_CONFIG", "TABLE_CONFIG", "DATA_SOURCES_CONFIG", "DATA_SOURCES_CODE") values(1971861929800540163, 1, 1, '2025-09-27 16:58:14', 100, 1, '2025-09-27 16:58:31', 0, '大屏-园区-高危作业统计', 'dp_yq_danger_sum', 1971828164688650242, '', 'page,authFalse', 'height,header,menu,index,border', '{"dataOrigin":"1966390044736434178","executeSql":"select SUM(wks) as wks,SUM(jxz) as jxz,SUM(ywc) as ywc from (\r\nselect COUNT(1) as wks,0 as jxz,0 as ywc from (\r\n-- 未开始\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0 ) a\r\nUNION\r\nselect 0 as wks,COUNT(1) as jxz,0 as ywc from (\r\n-- 进行中\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a \r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate < NOW() and a.operationEndDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate < NOW() and a.operationEndDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0 ) b \r\nUNION\r\n-- 已完成\r\nselect 0 as wks,0 as jxz,COUNT(1) as ywc from (\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a \r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationEndDate > TRUNC(SYSDATE, ''MM'') and a.operationEndDate < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id \r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationEndDate > TRUNC(SYSDATE, ''MM'') and a.operationEndDate < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0) c) x\r\n\r\n\r\n","optionData":{"optionObj":{"select":[],"from":[],"where":[],"groupBy":"","having":"","orderBy":[]},"customSql":"select SUM(wks) as wks,SUM(jxz) as jxz,SUM(ywc) as ywc from (\r\nselect COUNT(1) as wks,0 as jxz,0 as ywc from (\r\n-- 未开始\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0 ) a\r\nUNION\r\nselect 0 as wks,COUNT(1) as jxz,0 as ywc from (\r\n-- 进行中\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a \r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate < NOW() and a.operationEndDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate < NOW() and a.operationEndDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0 ) b \r\nUNION\r\n-- 已完成\r\nselect 0 as wks,0 as jxz,COUNT(1) as ywc from (\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a \r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationEndDate > TRUNC(SYSDATE, ''MM'') and a.operationEndDate < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id \r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationEndDate > TRUNC(SYSDATE, ''MM'') and a.operationEndDate < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0) c) x\r\n\r\n\r\n","aliasObj":{"lc_drill_plan":"tbl_ldp"},"typeKey":"custom"}}', 'master');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_NAME", "REPORT_CODE", "GROUP_REPORT_ID", "JAVA_CONFIG", "DATA_CONFIG", "TABLE_CONFIG", "DATA_SOURCES_CONFIG", "DATA_SOURCES_CODE") values(1971867634188197889, 1, 1, '2025-09-27 17:20:54', 100, 1, '2025-09-27 18:07:33', 0, '大屏-总部-高危作业柱图', 'dp_zb_danger_sum', 1971828164688650242, '', 'page,authFalse', 'height,header,menu,index,border', '{"dataOrigin":"1966394259751907330","executeSql":"select SUM(wks) as wks,SUM(jxz) as jxz,SUM(ywc) as ywc,CAMPUS_INFO.Campus_Name,CAMPUS_INFO.Campus_id from (\r\nselect COUNT(1) as wks,0 as jxz,0 as ywc,a.applyDepId from (\r\n-- 未开始\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0 ) a group by a.applyDepId\r\nUNION\r\nselect 0 as wks,COUNT(1) as jxz,0 as ywc,b.applyDepId from (\r\n-- 进行中\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a \r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate < NOW() and a.operationEndDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate < NOW() and a.operationEndDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0 ) b group by b.applyDepId\r\nUNION\r\n-- 已完成\r\nselect 0 as wks,0 as jxz,COUNT(1) as ywc, c.applyDepId from (\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a \r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationEndDate > TRUNC(SYSDATE, ''MM'') and a.operationEndDate < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id \r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationEndDate > TRUNC(SYSDATE, ''MM'') and a.operationEndDate < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0) c GROUP BY c.applyDepId) x\r\ninner join LOWCODE_MASTER.SYSTEM_DEPT b on x.APPLYDEPID=b.id\r\ninner join LOWCODE_MASTER.CAMPUS_INFO CAMPUS_INFO on b.Campus_id=CAMPUS_INFO.Campus_id\r\nGROUP BY CAMPUS_INFO.Campus_id,CAMPUS_INFO.Campus_Name\r\n\r\n","optionData":{"optionObj":{"select":[],"from":[],"where":[],"groupBy":"","having":"","orderBy":[]},"customSql":"select SUM(wks) as wks,SUM(jxz) as jxz,SUM(ywc) as ywc,CAMPUS_INFO.Campus_Name,CAMPUS_INFO.Campus_id from (\r\nselect COUNT(1) as wks,0 as jxz,0 as ywc,a.applyDepId from (\r\n-- 未开始\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0 ) a group by a.applyDepId\r\nUNION\r\nselect 0 as wks,COUNT(1) as jxz,0 as ywc,b.applyDepId from (\r\n-- 进行中\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a \r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate < NOW() and a.operationEndDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationStartDate < NOW() and a.operationEndDate > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.SDATE < NOW() and a.EDATE > NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0 ) b group by b.applyDepId\r\nUNION\r\n-- 已完成\r\nselect 0 as wks,0 as jxz,COUNT(1) as ywc, c.applyDepId from (\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LIFTING_OPERATION a \r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationEndDate > TRUNC(SYSDATE, ''MM'') and a.operationEndDate < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_HIGH_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id \r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_CONFINED_SPACE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_LAND_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.operationStartDate as sDate,operationEndDate as eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_TEMPORARY_POWER_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.operationEndDate > TRUNC(SYSDATE, ''MM'') and a.operationEndDate < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0\r\nUNION\r\nselect a.id,a.applyDepId,a.applyDepName,a.sDate,a.eDate,b.UserName,b.Mobile from LOWCODE_MASTER.LC_FIRE_OPERATION a\r\ninner join LOWCODE_MASTER.SYSTEM_USERS b on a.CREATE_USER=b.id\r\nwhere a.EDATE > TRUNC(SYSDATE, ''MM'') and a.EDATE < NOW() and a.APPROVESTATUS=2 and a.IS_DELETED=0) c GROUP BY c.applyDepId) x\r\ninner join LOWCODE_MASTER.SYSTEM_DEPT b on x.APPLYDEPID=b.id\r\ninner join LOWCODE_MASTER.CAMPUS_INFO CAMPUS_INFO on b.Campus_id=CAMPUS_INFO.Campus_id\r\nGROUP BY CAMPUS_INFO.Campus_id,CAMPUS_INFO.Campus_Name\r\n\r\n","aliasObj":{"lc_drill_task":"tbl_ldt"},"typeKey":"custom"}}', 'master');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_NAME", "REPORT_CODE", "GROUP_REPORT_ID", "JAVA_CONFIG", "DATA_CONFIG", "TABLE_CONFIG", "DATA_SOURCES_CONFIG", "DATA_SOURCES_CODE") values(1971880166839853058, 1, 1, '2025-09-27 18:10:42', 100, null, '2025-09-27 18:10:42', 0, '大屏-园区-考试培训明细', 'dp_yq_exam_detail', 1971828164688650242, '', 'page,authFalse', 'height,header,menu,index,border', '{"dataOrigin":"1968562717683908610","executeSql":"select a.examName,a.examPeopleNum,a.examDuration,a.examPassRate from LOWCODE_MASTER.LC_EXAM_RECORD a\r\ninner join LOWCODE_MASTER.SYSTEM_DEPT b on a.DEPTID=b.id\r\ninner join LOWCODE_MASTER.CAMPUS_INFO CAMPUS_INFO on b.Campus_id=CAMPUS_INFO.Campus_id\r\nwhere a.examTime > TRUNC(SYSDATE, ''MM'')","optionData":{"optionObj":{"select":[],"from":[],"where":[],"groupBy":"","having":"","orderBy":[]},"customSql":"select a.examName,a.examPeopleNum,a.examDuration,a.examPassRate from LOWCODE_MASTER.LC_EXAM_RECORD a\r\ninner join LOWCODE_MASTER.SYSTEM_DEPT b on a.DEPTID=b.id\r\ninner join LOWCODE_MASTER.CAMPUS_INFO CAMPUS_INFO on b.Campus_id=CAMPUS_INFO.Campus_id\r\nwhere a.examTime > TRUNC(SYSDATE, ''MM'')","aliasObj":{"lc_exam_plan":"tbl_lep"},"typeKey":"custom"}}', 'master');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_NAME", "REPORT_CODE", "GROUP_REPORT_ID", "JAVA_CONFIG", "DATA_CONFIG", "TABLE_CONFIG", "DATA_SOURCES_CONFIG", "DATA_SOURCES_CODE") values(1971883555069927426, 1, 1, '2025-09-27 18:24:10', 100, 1, '2025-09-27 18:47:21', 0, '大屏-总部-考试培训统计', 'dp_zb_exam_sum', 1971828164688650242, '', 'page,authFalse', 'height,header,menu,index,border', '{"dataOrigin":"1968562717683908610","executeSql":"select CAMPUS_INFO.CAMPUS_NAME,SUM(a.examPeopleNum) as examPeopleNum,COUNT(1) as examTimes,SUM(a.examDuration) as examDuration,SUM(a.examPassRate)/COUNT(1)\r\nas examPassRate from LOWCODE_MASTER.LC_EXAM_RECORD a\r\ninner join LOWCODE_MASTER.SYSTEM_DEPT b on a.DEPTID=b.id\r\ninner join LOWCODE_MASTER.CAMPUS_INFO CAMPUS_INFO on b.Campus_id=CAMPUS_INFO.Campus_id\r\nwhere a.examTime > TRUNC(SYSDATE, ''MM'') group by CAMPUS_INFO.CAMPUS_NAME","optionData":{"optionObj":{"select":[],"from":[],"where":[],"groupBy":"","having":"","orderBy":[]},"customSql":"select CAMPUS_INFO.CAMPUS_NAME,SUM(a.examPeopleNum) as examPeopleNum,COUNT(1) as examTimes,SUM(a.examDuration) as examDuration,SUM(a.examPassRate)/COUNT(1)\r\nas examPassRate from LOWCODE_MASTER.LC_EXAM_RECORD a\r\ninner join LOWCODE_MASTER.SYSTEM_DEPT b on a.DEPTID=b.id\r\ninner join LOWCODE_MASTER.CAMPUS_INFO CAMPUS_INFO on b.Campus_id=CAMPUS_INFO.Campus_id\r\nwhere a.examTime > TRUNC(SYSDATE, ''MM'') group by CAMPUS_INFO.CAMPUS_NAME","aliasObj":{"lc_exam_plan":"tbl_lep"},"typeKey":"custom"}}', 'master');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_NAME", "REPORT_CODE", "GROUP_REPORT_ID", "JAVA_CONFIG", "DATA_CONFIG", "TABLE_CONFIG", "DATA_SOURCES_CONFIG", "DATA_SOURCES_CODE") values(1972137114487353346, 1, 1, '2025-09-28 11:11:43', 100, null, '2025-09-28 11:11:43', 0, '大屏-园区-演练明细', 'dp_yq_drill_detail', 1971828164688650242, '', 'page,authFalse', 'height,header,menu,index,border', '{"dataOrigin":"1968562717683908610","executeSql":"select concat(drill_plan_name,''('',dept_name,'')'') as drill_plan_name,drill_time,0 as drill_count from LOWCODE_MASTER.LC_DRILL_TASK a\r\ninner join LOWCODE_MASTER.SYSTEM_DEPT b on a.dept_id=b.id\r\ninner join LOWCODE_MASTER.CAMPUS_INFO CAMPUS_INFO on b.Campus_id=CAMPUS_INFO.Campus_id\r\nwhere (edate between TRUNC(SYSDATE, ''MM'') and ADD_MONTHS(TRUNC(SYSDATE, ''MM''), 1)) or \r\n(sdate between TRUNC(SYSDATE, ''MM'') and ADD_MONTHS(TRUNC(SYSDATE, ''MM''), 1))","optionData":{"optionObj":{"select":[],"from":[],"where":[],"groupBy":"","having":"","orderBy":[]},"customSql":"select concat(drill_plan_name,''('',dept_name,'')'') as drill_plan_name,drill_time,0 as drill_count from LOWCODE_MASTER.LC_DRILL_TASK a\r\ninner join LOWCODE_MASTER.SYSTEM_DEPT b on a.dept_id=b.id\r\ninner join LOWCODE_MASTER.CAMPUS_INFO CAMPUS_INFO on b.Campus_id=CAMPUS_INFO.Campus_id\r\nwhere (edate between TRUNC(SYSDATE, ''MM'') and ADD_MONTHS(TRUNC(SYSDATE, ''MM''), 1)) or \r\n(sdate between TRUNC(SYSDATE, ''MM'') and ADD_MONTHS(TRUNC(SYSDATE, ''MM''), 1))","aliasObj":{"lc_exam_plan":"tbl_lep"},"typeKey":"custom"}}', 'master');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_NAME", "REPORT_CODE", "GROUP_REPORT_ID", "JAVA_CONFIG", "DATA_CONFIG", "TABLE_CONFIG", "DATA_SOURCES_CONFIG", "DATA_SOURCES_CODE") values(1972187030647599107, 1, 1, '2025-09-28 14:30:04', 100, null, '2025-09-28 14:30:04', 0, '大屏-总部-演练统计', 'dp_zb_drill_sum', 1971828164688650242, '', 'page,authFalse', 'height,header,menu,index,border', '{"dataOrigin":"1968562717683908610","executeSql":"select total.Campus_Name,(IFNULL(complate.totalTimes,0)*1.0)/(total.totalTimes*1.0)*100 as rate from (\r\nselect CAMPUS_INFO.Campus_Name,COUNT(1) as totalTimes from LOWCODE_MASTER.LC_DRILL_TASK a\r\ninner join LOWCODE_MASTER.SYSTEM_DEPT b on a.dept_id=b.id\r\ninner join LOWCODE_MASTER.CAMPUS_INFO CAMPUS_INFO on b.Campus_id=CAMPUS_INFO.Campus_id\r\nwhere ((edate between TRUNC(SYSDATE, ''MM'') and ADD_MONTHS(TRUNC(SYSDATE, ''MM''), 1)) or \r\n(sdate between TRUNC(SYSDATE, ''MM'') and ADD_MONTHS(TRUNC(SYSDATE, ''MM''), 1))) GROUP BY CAMPUS_INFO.Campus_Name) total\r\nleft join (\r\nselect CAMPUS_INFO.Campus_Name,COUNT(1) as totalTimes from LOWCODE_MASTER.LC_DRILL_TASK a\r\ninner join LOWCODE_MASTER.SYSTEM_DEPT b on a.dept_id=b.id\r\ninner join LOWCODE_MASTER.CAMPUS_INFO CAMPUS_INFO on b.Campus_id=CAMPUS_INFO.Campus_id\r\nwhere ((edate between TRUNC(SYSDATE, ''MM'') and ADD_MONTHS(TRUNC(SYSDATE, ''MM''), 1)) or \r\n(sdate between TRUNC(SYSDATE, ''MM'') and ADD_MONTHS(TRUNC(SYSDATE, ''MM''), 1))) and TASK_STATUS=3 GROUP BY CAMPUS_INFO.Campus_Name) complate\r\non total.Campus_Name=complate.Campus_Name","optionData":{"optionObj":{"select":[],"from":[],"where":[],"groupBy":"","having":"","orderBy":[]},"customSql":"select total.Campus_Name,(IFNULL(complate.totalTimes,0)*1.0)/(total.totalTimes*1.0)*100 as rate from (\r\nselect CAMPUS_INFO.Campus_Name,COUNT(1) as totalTimes from LOWCODE_MASTER.LC_DRILL_TASK a\r\ninner join LOWCODE_MASTER.SYSTEM_DEPT b on a.dept_id=b.id\r\ninner join LOWCODE_MASTER.CAMPUS_INFO CAMPUS_INFO on b.Campus_id=CAMPUS_INFO.Campus_id\r\nwhere ((edate between TRUNC(SYSDATE, ''MM'') and ADD_MONTHS(TRUNC(SYSDATE, ''MM''), 1)) or \r\n(sdate between TRUNC(SYSDATE, ''MM'') and ADD_MONTHS(TRUNC(SYSDATE, ''MM''), 1))) GROUP BY CAMPUS_INFO.Campus_Name) total\r\nleft join (\r\nselect CAMPUS_INFO.Campus_Name,COUNT(1) as totalTimes from LOWCODE_MASTER.LC_DRILL_TASK a\r\ninner join LOWCODE_MASTER.SYSTEM_DEPT b on a.dept_id=b.id\r\ninner join LOWCODE_MASTER.CAMPUS_INFO CAMPUS_INFO on b.Campus_id=CAMPUS_INFO.Campus_id\r\nwhere ((edate between TRUNC(SYSDATE, ''MM'') and ADD_MONTHS(TRUNC(SYSDATE, ''MM''), 1)) or \r\n(sdate between TRUNC(SYSDATE, ''MM'') and ADD_MONTHS(TRUNC(SYSDATE, ''MM''), 1))) and TASK_STATUS=3 GROUP BY CAMPUS_INFO.Campus_Name) complate\r\non total.Campus_Name=complate.Campus_Name","aliasObj":{"lc_exam_plan":"tbl_lep"},"typeKey":"custom"}}', 'master');
|
|
|
|
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971858622373732354, 1, 1, '2025-09-27 16:45:06', 100, null, null, 0, 1971858622197571586, 'contenttext', '详情', 'String', 1, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''详情'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971858622373732355, 1, 1, '2025-09-27 16:45:06', 100, null, null, 0, 1971858622197571586, 'row_id', '行号', 'BigDecimal', 2, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''行号'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971861929867649026, 1, 1, '2025-09-27 16:58:14', 100, null, null, 0, 1971861929800540163, 'ywc', '已完成', 'Integer', 1, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''已完成'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971861929867649027, 1, 1, '2025-09-27 16:58:14', 100, null, null, 0, 1971861929800540163, 'row_id', '行ID', 'Integer', 2, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''行ID'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971861929867649028, 1, 1, '2025-09-27 16:58:14', 100, null, null, 0, 1971861929800540163, 'jxz', '进行中', 'Integer', 3, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''进行中'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971861929867649029, 1, 1, '2025-09-27 16:58:14', 100, null, null, 0, 1971861929800540163, 'wks', '未开始', 'Integer', 4, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''未开始'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971867634259501057, 1, 1, '2025-09-27 17:20:54', 100, null, null, 0, 1971867634188197889, 'ywc', '已完成', 'Integer', 1, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''已完成'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971867634259501058, 1, 1, '2025-09-27 17:20:54', 100, null, null, 0, 1971867634188197889, 'campus_name', '园区名称', 'String', 2, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''园区名称'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971867634259501059, 1, 1, '2025-09-27 17:20:54', 100, null, null, 0, 1971867634188197889, 'row_id', '行号', 'Integer', 3, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''行号'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971867634259501060, 1, 1, '2025-09-27 17:20:54', 100, null, null, 0, 1971867634188197889, 'jxz', '进行中', 'Integer', 4, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''进行中'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971867634259501061, 1, 1, '2025-09-27 17:20:54', 100, null, null, 0, 1971867634188197889, 'wks', '未开始', 'Integer', 5, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''未开始'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971867634259501062, 1, 1, '2025-09-27 17:20:54', 100, null, null, 0, 1971867634188197889, 'campus_id', '园区ID', 'BigDecimal', 6, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''园区ID'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971880166848241665, 1, 1, '2025-09-27 18:10:42', 100, null, null, 0, 1971880166839853058, 'examname', '考试名称', 'String', 1, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''考试名称'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971880166848241666, 1, 1, '2025-09-27 18:10:42', 100, null, null, 0, 1971880166839853058, 'examduration', '时长', 'Integer', 2, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''时长'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971880166848241667, 1, 1, '2025-09-27 18:10:42', 100, null, null, 0, 1971880166839853058, 'exampeoplenum', '人数', 'Integer', 3, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''人数'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971880166848241668, 1, 1, '2025-09-27 18:10:42', 100, null, null, 0, 1971880166839853058, 'exampassrate', '通过率', 'BigDecimal', 4, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''通过率'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971880166848241669, 1, 1, '2025-09-27 18:10:42', 100, null, null, 0, 1971880166839853058, 'row_id', '行ID', 'BigDecimal', 5, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''行ID'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971883555074121729, 1, 1, '2025-09-27 18:24:10', 100, null, null, 1, 1971883555069927426, 'examduration', '时长', 'Integer', 1, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''时长'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971883555074121730, 1, 1, '2025-09-27 18:24:10', 100, null, null, 1, 1971883555069927426, 'exampeoplenum', '考试人数', 'Integer', 2, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''考试人数'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971883555074121731, 1, 1, '2025-09-27 18:24:10', 100, null, null, 1, 1971883555069927426, 'exampassrate', '通过率', 'BigDecimal', 3, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''通过率'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971883555074121732, 1, 1, '2025-09-27 18:24:10', 100, null, null, 1, 1971883555069927426, 'campus_name', '园区名称', 'String', 4, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''园区名称'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971883555074121733, 1, 1, '2025-09-27 18:24:10', 100, null, null, 1, 1971883555069927426, 'row_id', '行ID', 'Integer', 5, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''行ID'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971889388117860353, 1, 1, '2025-09-27 18:47:21', 100, null, null, 0, 1971883555069927426, 'examduration', '考试时长', 'BigDecimal', 1, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''考试时长'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971889388117860354, 1, 1, '2025-09-27 18:47:21', 100, null, null, 0, 1971883555069927426, 'exampeoplenum', '考试人数', 'BigDecimal', 2, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''考试人数'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971889388117860355, 1, 1, '2025-09-27 18:47:21', 100, null, null, 0, 1971883555069927426, 'exampassrate', '通过率', 'BigDecimal', 3, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''通过率'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971889388117860356, 1, 1, '2025-09-27 18:47:21', 100, null, null, 0, 1971883555069927426, 'examtimes', '考试次数', 'BigDecimal', 4, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''考试次数'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971889388117860357, 1, 1, '2025-09-27 18:47:21', 100, null, null, 0, 1971883555069927426, 'campus_name', '园区名', 'String', 5, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''园区名'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1971889388117860358, 1, 1, '2025-09-27 18:47:21', 100, null, null, 0, 1971883555069927426, 'row_id', '行ID', 'BigDecimal', 6, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''行ID'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1972137114487353347, 1, 1, '2025-09-28 11:11:43', 100, null, null, 0, 1972137114487353346, 'drill_count', '参与人数', 'Integer', 1, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''参与人数'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1972137114487353348, 1, 1, '2025-09-28 11:11:43', 100, null, null, 0, 1972137114487353346, 'drill_plan_name', '演练名称', 'String', 2, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''演练名称'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1972137114487353349, 1, 1, '2025-09-28 11:11:43', 100, null, null, 0, 1972137114487353346, 'row_id', '行ID', 'Integer', 3, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''行ID'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1972137114487353350, 1, 1, '2025-09-28 11:11:43', 100, null, null, 0, 1972137114487353346, 'drill_time', '完成时间', 'DateTime', 4, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''完成时间'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1972187030647599108, 1, 1, '2025-09-28 14:30:04', 100, null, null, 0, 1972187030647599107, 'rate', '完成比例', 'BigDecimal', 1, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''完成比例'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1972187030647599109, 1, 1, '2025-09-28 14:30:04', 100, null, null, 0, 1972187030647599107, 'campus_name', '园区名称', 'String', 2, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''园区名称'',
|
|
//English
|
|
''en'': '''',
|
|
}');
|
|
insert into "LOWCODE_FRAME"."LOWCODE_REPORT_FIELD"("ID", "TENANT_ID", "CREATE_USER", "CREATE_TIME", "CREATE_DEPT", "UPDATE_USER", "UPDATE_TIME", "IS_DELETED", "REPORT_ID", "FIELD_CODE", "FIELD_NAME", "FIELD_TYPE", "SORT_NUM", "QUERY_IS_DB", "QUERY_IS_WEB", "QUERY_MODE", "DICT_CODE", "IS_EXPORT", "IS_SHOW_SORT", "LABEL_I18N") values(1972187030647599110, 1, 1, '2025-09-28 14:30:04', 100, null, null, 0, 1972187030647599107, 'row_id', '行ID', 'BigDecimal', 3, 'N', 'N', 'LIKE', '', 'Y', 'N', 'return {
|
|
//简体中文
|
|
''zh-CN'': ''行ID'',
|
|
//English
|
|
''en'': '''',
|
|
}'); |