在hibernate 中通过写一个sql 语句封装一个字段

<property name="yellowday" type="java.lang.Integer" formula="(select datediff(day,t.filldate,
   (select top  1 (t.year+'-'+t.month+'-'+t.day) from t_sys_holiday t
   where t.year+'-'+t.month+'-'+t.day>=
   (select  dateadd(day,(select t.yellowday  from t_pz_db t  where t.rendertype='S' and t.headtype='1'),r.enddate)
   from t_zn_task_reduce r where r.id=id)
   and t.holiday='0')) from t_zn_task_schedule t  where t.momentid=id)">      
        </property>     
            
  <property name="redday" type="java.lang.Integer" formula="(select datediff(day,t.filldate,
   (select top  1 (t.year+'-'+t.month+'-'+t.day) from t_sys_holiday t
   where t.year+'-'+t.month+'-'+t.day>=
   (select  dateadd(day,(select t.redday from t_pz_db t  where t.rendertype='S' and t.headtype='1'),r.enddate)
   from t_zn_task_reduce r where r.id=id)
   and t.holiday='0')) from t_zn_task_schedule t  where t.momentid=id)">            
   </property>