-- SELECT expression added to both the list and echo queries of existing pickers.
|
-- z is the existing main-document resource alias. No user input is interpolated.
|
(SELECT COALESCE(jsonb_agg(jsonb_build_object(
|
'kanwu_zixiang_id', kd.f_id,
|
'kanwu_shenqing_id', ka.f_id,
|
'wenjian_id', ka.wenjian_id,
|
'banben_id', ka.banben_id,
|
'wenjian_bianhao', ka.wenjian_bianhao,
|
'wenjian_mingcheng', ka.wenjian_mingcheng,
|
'banbenhao', ka.banbenhao,
|
'kanwu_weizhi', kd.kanwu_weizhi,
|
'kanwu_neirong', kd.kanwu_neirong,
|
'xiugai_jianyi', kd.xiugai_jianyi,
|
'kanwu_yuanyin', kd.kanwu_yuanyin,
|
'fujian', COALESCE(NULLIF(kd.fujian, '')::jsonb, '[]'::jsonb),
|
'shifou_yichuli', COALESCE(NULLIF(kd.shifou_yichuli, ''), 'no')
|
) ORDER BY ka.shenqing_riqi, ka.f_id, kd.f_id), '[]'::jsonb)::text
|
FROM dms_wenjian_kanwu_shenqing ka
|
JOIN dms_wenjian_kanwu_shenqing_zixiang kd
|
ON kd.f_foreign_id = ka.f_id AND kd.f_tenant_id = ka.f_tenant_id
|
WHERE ka.f_tenant_id = z.f_tenant_id
|
AND ka.f_flow_state = 2
|
AND ka.f_delete_mark IS NULL AND kd.f_delete_mark IS NULL
|
AND ka.wenjian_id = z.f_id
|
) AS kanwu_mingxi
|
