imp_yunwei/查询表单配置的sql.txt

使用说明：在使用的时候请修改sql中"采购入库"的内容，修改内容为界面上的模块名称
SELECT 
    form_data."main_table_name" AS 表名,
    form_data."header" AS 模块名,
    ic."item_name" AS 字段名,
    ic."item_show_name" AS 字段名称,
    CASE WHEN ic."data_type" = 1 THEN '字符串' 
     WHEN ic."data_type" = 2 THEN '整数类型'
    WHEN ic."data_type" = 3 THEN '时间类型'
    WHEN ic."data_type" = 4 THEN '小数类型'
    WHEN ic."data_type" = 5 THEN '文本类型' 
    WHEN ic."data_type" = 6 THEN '开关类型'
    WHEN ic."data_type" = 7 THEN '下拉框' END 类型,
    CASE WHEN ic."is_must_fill" = 1 THEN '必填' ELSE '' END AS 是否必填,
    ic."expression_decimal_digit" AS 小数位数,
    dd."dic_name" AS 数据字典,
    fcg."eval_script" AS 必填条件组,
COALESCE(fc_match."id", fc_empty."id") AS 调取id,
COALESCE(fc_match."show_name", fc_empty."show_name") AS 调取名称,
    COALESCE(fc_match."fetch_sql", fc_empty."fetch_sql") AS 相关调取sql
FROM SGGMIIP."item_config" ic 
LEFT JOIN SGGMIIP."data_dic" dd ON ic."dic_id" = dd."id" 
LEFT JOIN (
    SELECT 
        fc_temp."id",
        fc_temp."parent_id", 
        fc_temp."main_table_name", 
        fc_temp."header",
        fc_temp."del_flag"
    FROM SGGMIIP."form_config" fc_temp
    WHERE fc_temp."del_flag" = '0'
    START WITH fc_temp."parent_id" = '0' AND fc_temp."header" = '采购入库'
    CONNECT BY PRIOR fc_temp."id" = fc_temp."parent_id"
) form_data ON ic."form_config_id" = form_data."id" 
LEFT JOIN SGGMIIP."form_condition_group" fcg ON fcg."id" = ic."is_must_fill_condition_id"
LEFT JOIN SGGMIIP."fetch_config" fc_match ON (
    ic."item_name" = fc_match."target_field" 
    AND fc_match."target_form_id" LIKE '%' || ic."form_config_id" || '%'
)LEFT JOIN SGGMIIP."fetch_config" fc_empty ON (
    ic."item_name" = fc_empty."target_field" 
    AND IFNULL(fc_empty."target_form_id", '') = ''
    AND fc_match."target_field" IS NULL
)
WHERE form_data."id" IS NOT NULL
ORDER BY ic."show_order";