web_server/src/main/java/thyyxxk/webserver/dao/his/scheduled/DailyPatientCountDao.java

package thyyxxk.webserver.dao.his.scheduled;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import thyyxxk.webserver.entity.scheduled.DailyPatientCount;

@Mapper
public interface DailyPatientCountDao {
    @Select("select inHospCount=((select count(1) from zy_actpatient with(nolock) where inpatient_no not like 'JT%')- " +
            "(select count(1) from zy_actpatient a with(nolock),yz_act_order b where a.inpatient_no not like 'JT%' " +
            "and a.inpatient_no=b.inpatient_no and a.admiss_times=b.admiss_times and b.status_flag > '2' and " +
            "isnull(b.group_no,'00' )='00' and b.order_code in ('06026','06053','05973'))), " +
            "admissCount=(select count(1) from zy_actpatient with(nolock) where datediff(day,admiss_date,getdate())=1), " +
            "dismissCount=((select count(1) from yz_act_order with(nolock) where status_flag > '2' and " +
            "datediff(day,start_time,getdate())=1 and isnull(group_no,'00' )='00' and order_code in ('06026','06053')) " +
            "+ (select count(1) from yz_inact_order with(nolock) where status_flag > '2' and " +
            "datediff(day,start_time,getdate())=1 and isnull(group_no,'00' )='00' and order_code in ('06026','06053'))), " +
            "deadCount=((select count(1) from yz_act_order with(nolock) where status_flag > '2' and " +
            "datediff(day,start_time,getdate())=1 and isnull(group_no,'00' )='00' and order_code='05973') + " +
            "(select count(1) from yz_inact_order with(nolock) where status_flag > '2' and " +
            "datediff(day,start_time,getdate())=1 and isnull(group_no,'00' )='00' and order_code='05973'))," + 
            "heavyCount=(select count(1) from yz_act_order with(nolock) where status_flag!='5' " +
            "and isnull(group_no,'00' )='00' and order_code='05888'), " +
            "dangerCount=(select count(1) from yz_act_order with(nolock) where status_flag!='5' " +
            "and isnull(group_no,'00' )='00' and order_code='05887'), " +
            "operationCount=(select count(1) from op_record with(nolock) where status!='d' and datediff(day,op_datetime,getdate())=1), " +
            "clinicCount=(select count(1) from mzy_reqrec with(nolock) where datediff(day,visit_date,getdate())=1), " +
            "rescueCount=((select count(1) from yz_act_order with(nolock) where status_flag > '2' and " +
            "datediff(day,start_time,getdate())=1 and isnull(group_no,'00' )='00' and order_code in " +
            "('05202','04311','08893','08894','01535','01537','05243','02628','05240','05242','05241','04313','01446','06383', " +
            "'08897','08898','05011','01445','04312','08895','08896')) " +
            "+ (select count(1) from yz_inact_order with(nolock) where status_flag > '2' and " +
            "datediff(day,start_time,getdate())=1 and isnull(group_no,'00' )='00' and order_code in " +
            "('05202','04311','08893','08894','01535','01537','05243','02628','05240','05242','05241','04313','01446','06383', " +
            "'08897','08898','05011','01445','04312','08895','08896')))")
    DailyPatientCount selectDailyCount();
}