where条件的内容就是判断chanye 和chanpinxian 这俩单选框里面有没有值，如果有值的话，就让F_MKMC = chanye,F_CPXMC = chanpinxian 这样写的话读取不到参数，改成$又只能读取到chanye ${if( a = "1", if( len(quyu) == 0 || quyu = "集团", " SELECT f_gjgsmc,F_ZGSMC, sum(应收账款) 应收账款, sum(未开票应收) 未开票应收, sum(已开票应收) as 已开票应收, sum(超期应收) 超期应收, sum(超期未开票) 超期未开票 from( ( SELECT f_gjgsmc,F_ZGSMC,F_MKMC,F_CPXMC, SUM(f_ysje) / 10000 as 应收账款, SUM(f_wkpje) / 10000 as 未开票应收, (sum(f_kphsje) - sum(f_hkje)) / 10000 as 已开票应收, NULL as 超期应收, NULL as 超期未开票 FROM dwd_db.dwd_pulianyszk WHERE LENGTH(f_srrq) >= 8 AND f_gjgsmc IS NOT NULL AND f_gjgsmc != ' ' and F_GJGS in ('10001','10002','10003','10004') GROUP BY f_gjgsmc,F_ZGSMC,F_MKMC,F_CPXMC ) UNION ALL ( SELECT f_gjgsmc,F_ZGSMC,F_MKMC,F_CPXMC, NULL as 应收账款, NULL as 未开票应收, NULL as 已开票应收, SUM(f_ysje) / 10000 as 超期应收, SUM(f_wkpje) / 10000 as 超期未开票 FROM dwd_db.dwd_pulianyszk WHERE LENGTH(f_srrq) >= 8 AND (CURRENT_DATE - f_srrq::date) > f_yjbz AND f_gjgsmc IS NOT NULL AND f_gjgsmc != ' ' and F_GJGS in ('10001','10002','10003','10004') GROUP BY f_gjgsmc,F_ZGSMC,F_MKMC,F_CPXMC ) ) GROUP BY f_gjgsmc,F_ZGSMC order by f_gjgsmc,F_ZGSMC ", "" ), if( a = "2", "", "" ) ) } |
1min目标场景问卷
立即参与
