app巡检详情sql调整

guoshilong

2023-04-04 feec81bbad5f53e0352ac6c7037ff115c5946d33

app巡检详情sql调整

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/mapper/PatrolRecordMapper.xml

@@ -21,6 +21,7 @@
        <result property="patrolTime" column="update_time"/>
        <result property="phone" column="phone"/>
        <result property="toUserId" column="create_user"/>
        <result property="toUserName" column="real_name"/>

        <result column="create_user" property="createUser"/>
        <result column="create_dept" property="createDept"/>
@@ -66,7 +67,8 @@

    <select id="getByTaskIdAndItemId" resultMap="selectPatrolRecordList">
        SELECT r.id,r.patrol_type,r.device_ids,r.images,r.content,r.status,r.item_id,r.task_id,r.update_time,
                    c.name groupName,c.id groupId,c.items_name itemsName,c.description
                    c.name groupName,c.id groupId,c.items_name itemsName,c.description,
                    u.real_name
        FROM BLADEX.SM_PATROL_RECORD r
        LEFT JOIN
        (SELECT g.ID,g.NAME,a.id itemId, a.items_name,description FROM
@@ -80,6 +82,7 @@

        ON c.itemId = r.item_id
        LEFT JOIN BLADEX.SM_PATROL_TASK t ON t.id = r.task_id
        LEFT JOIN BLADE_USER u ON u.id = r.create_user
        where r.task_id = #{taskId}
    </select>
    <select id="getPatrolRecordVO" resultMap="selectPatrolRecordList">

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/vo/PatrolRecordVO.java

@@ -41,6 +41,10 @@
     */
    private String toUserId;
    /**
     * 巡查人名
     */
    private String toUserName;
    /**
     * 联系方式
     */
    private String phone;