【模型管理】-模型创建，PG数据库，不支持datediff函数

[dawsongzhao0523]

[dawsongzhao0523]

with t_7 as ( SELECT sys_imp_date, bg, callscount FROM ( SELECT sys_imp_date, bg, DifyUsageSummery_callscount AS callscount FROM ( SELECT DifyUsageSummery_callscount, sys_imp_date, bg, create_date FROM ( SELECT callscount AS DifyUsageSummery_callscount, create_date AS sys_imp_date, bg AS bg, create_date AS create_date FROM ( SELECT * FROM ( SELECT CASE WHEN Temp.bg = '计算设备与服务BG' THEN '算力BG' ELSE Temp.bg END AS bg, Temp.bu, Temp.dep AS department, create_date, Temp.callsCount, Temp.prices, Temp.disUsePeoples, Org.accounts FROM ( SELECT bg, bu, department, COUNT(account) AS accounts FROM fdw_infrajdy.jdy_userinfo WHERE account IS NOT NULL AND bg IS NOT NULL AND status = '在职/在场' AND class = 'E1-内部' GROUP BY bg, bu, department ) AS Org LEFT JOIN ( SELECT split_part(ACC.department, '/', 2) AS bg, split_part(ACC.department, '/', 3) AS bu, ACC.department AS dep, CAST(MSG.created_at AS DATE) AS create_date, COUNT(DISTINCT MSG.ldap_account) AS disUsePeoples, COUNT(MSG.id) AS callsCount, SUM(MSG.total_price) AS prices FROM public.messages AS MSG INNER JOIN public.accounts AS ACC ON ACC.ldap_account = MSG.ldap_account WHERE ACC.department IS NOT NULL AND split_part(ACC.department, '/', 2) <> '' GROUP BY split_part(ACC.department, '/', 2), split_part(ACC.department, '/', 3), department, CAST(MSG.created_at AS DATE) ) AS Temp ON Org.bg = Temp.bg AND Org.bu = Temp.bu AND Temp.dep = Org.department ) AS t WHERE bg IS NOT NULL ) AS DifyUsageSummery ) AS src00_DifyUsageSummery_87be ) AS DifyUsageSummery_0 ) AS DifyUsageSummery_1 ) SELECT callscount FROM t_7 WHERE bg = '整机BG' AND datediff('month', sys_imp_date, CURDATE()) <= 1 limit 1000