2021-01-21

最新推荐文章于 2024-09-24 09:50:23 发布

djq8080

最新推荐文章于 2024-09-24 09:50:23 发布

阅读量87

点赞数

文章标签： mysql

本文链接：https://blog.csdn.net/djq8080/article/details/112966379

版权

mybatis sql查询语句

<select id="queryDetailByElderId" resultType="org.jeecg.modules.cost.pojo.CostBillingDetailPojo">
        SELECT
            t1.id AS elderId,
            t1.elder_number AS elderNumber,
            t1.`name` AS elderName,
            ROUND( DATEDIFF( CURDATE(), t1.birthday ) / 365.5 ) AS age,
            IF( t1.sex = '1', '男', '女' ) AS sex,
            t1.organization_id AS orgId,
            t2.house_type AS area,
            t2.billing_start_date AS startDate,
            t2.maturity_date AS maturityDate,
            t3.nurse_name AS nurseName,
            t3.marked_name AS markedName,
            CONCAT( o1.`name`, '/', o2.floor, 'F/', o2.`name`, '房/', o3.`name` ) AS beds
        FROM
            enter_elder_info t1
            LEFT JOIN enter_elder_checkin t2 ON t1.id = t2.elder_id
            LEFT JOIN nurse_level t3 ON t2.nurse_level_id = t3.id
            LEFT JOIN org_building o1 ON t2.building_id = o1.id
            LEFT JOIN org_room o2 ON t2.room_id = o2.id
            LEFT JOIN org_bed o3 ON t2.bed_id = o3.id
        WHERE
            t1.id = #{elderId} AND t1.del_flag = '0'
    </select>