| | |
| | | |
| | | private Long updateUid; |
| | | |
| | | private Long drillPlanId; |
| | | private Long drillExecuteId; |
| | | |
| | | private String suitable; |
| | | |
| | |
| | | this.updateUid = updateUid; |
| | | } |
| | | |
| | | public Long getDrillPlanId() { |
| | | return drillPlanId; |
| | | public Long getDrillExecuteId() { |
| | | return drillExecuteId; |
| | | } |
| | | |
| | | public void setDrillPlanId(Long drillPlanId) { |
| | | this.drillPlanId = drillPlanId; |
| | | public void setDrillExecuteId(Long drillExecuteId) { |
| | | this.drillExecuteId = drillExecuteId; |
| | | } |
| | | |
| | | public String getSuitable() { |
| | |
| | | ", gmtModitify=" + gmtModitify + |
| | | ", createUid=" + createUid + |
| | | ", updateUid=" + updateUid + |
| | | ", drillPlanId=" + drillPlanId + |
| | | ", drillExecuteId=" + drillExecuteId + |
| | | ", suitable='" + suitable + '\'' + |
| | | ", sufficient='" + sufficient + '\'' + |
| | | ", arrival='" + arrival + '\'' + |
| | |
| | | @TableId(type = IdType.AUTO) |
| | | private Long id; |
| | | |
| | | private Long drillPlanId; |
| | | private Long drillExecuteId; |
| | | |
| | | private String suitable; |
| | | |
| | |
| | | this.id = id; |
| | | } |
| | | |
| | | public Long getDrillPlanId() { |
| | | return drillPlanId; |
| | | public Long getDrillExecuteId() { |
| | | return drillExecuteId; |
| | | } |
| | | |
| | | public void setDrillPlanId(Long drillPlanId) { |
| | | this.drillPlanId = drillPlanId; |
| | | public void setDrillExecuteId(Long drillExecuteId) { |
| | | this.drillExecuteId = drillExecuteId; |
| | | } |
| | | |
| | | public String getSuitable() { |
| | |
| | | public String toString() { |
| | | return "EmergencyDrillEvaluationInfo{" + |
| | | "id=" + id + |
| | | ", drillPlanId=" + drillPlanId + |
| | | ", drillExecuteId=" + drillExecuteId + |
| | | ", suitable='" + suitable + '\'' + |
| | | ", sufficient='" + sufficient + '\'' + |
| | | ", arrival='" + arrival + '\'' + |
| | |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | |
| | | import java.util.Date; |
| | | |
| | | @TableName("emergency_drill_evaluation") |
| | | public class EmergencyDrillEvaluationInfoPageDO { |
| | | |
| | | private String drillName; |
| | | |
| | | private String drillAddress; |
| | | |
| | | private String drillWay; |
| | | |
| | | private String drillLevel; |
| | | |
| | | private Date drillPlanDate; |
| | | |
| | | private Date drillRecordDate; |
| | | |
| | | public String getDrillName() { |
| | | return drillName; |
| | | } |
| | | |
| | | public void setDrillName(String drillName) { |
| | | this.drillName = drillName; |
| | | } |
| | | |
| | | public String getDrillAddress() { |
| | | return drillAddress; |
| | | } |
| | | |
| | | public void setDrillAddress(String drillAddress) { |
| | | this.drillAddress = drillAddress; |
| | | } |
| | | |
| | | public String getDrillWay() { |
| | | return drillWay; |
| | | } |
| | | |
| | | public void setDrillWay(String drillWay) { |
| | | this.drillWay = drillWay; |
| | | } |
| | | |
| | | public String getDrillLevel() { |
| | | return drillLevel; |
| | | } |
| | | |
| | | public void setDrillLevel(String drillLevel) { |
| | | this.drillLevel = drillLevel; |
| | | } |
| | | |
| | | public Date getDrillPlanDate() { |
| | | return drillPlanDate; |
| | | } |
| | | |
| | | public void setDrillPlanDate(Date drillPlanDate) { |
| | | this.drillPlanDate = drillPlanDate; |
| | | } |
| | | |
| | | public Date getDrillRecordDate() { |
| | | return drillRecordDate; |
| | | } |
| | | |
| | | public void setDrillRecordDate(Date drillRecordDate) { |
| | | this.drillRecordDate = drillRecordDate; |
| | | } |
| | | |
| | | @TableId(type = IdType.AUTO) |
| | | private Long id; |
| | | |
| | | private Long drillPlanId; |
| | | private Long drillExecuteId; |
| | | |
| | | |
| | | public Long getId() { |
| | |
| | | this.id = id; |
| | | } |
| | | |
| | | public Long getDrillPlanId() { |
| | | return drillPlanId; |
| | | public Long getDrillExecuteId() { |
| | | return drillExecuteId; |
| | | } |
| | | |
| | | public void setDrillPlanId(Long drillPlanId) { |
| | | this.drillPlanId = drillPlanId; |
| | | public void setDrillExecuteId(Long drillExecuteId) { |
| | | this.drillExecuteId = drillExecuteId; |
| | | } |
| | | |
| | | |
| | |
| | | public String toString() { |
| | | return "EmergencyDrillEvaluationInfo{" + |
| | | "id=" + id + |
| | | ", drillPlanId=" + drillPlanId + |
| | | ", drillExecuteId=" + drillExecuteId + |
| | | '}'; |
| | | } |
| | | } |
| | |
| | | @TableName("emergency_drill_execute") |
| | | public class EmergencyDrillExecuteInfoDetailDO { |
| | | |
| | | private String drillName; |
| | | |
| | | public String getDrillName() { |
| | | return drillName; |
| | | } |
| | | |
| | | public void setDrillName(String drillName) { |
| | | this.drillName = drillName; |
| | | } |
| | | |
| | | @TableId(type = IdType.AUTO) |
| | | private Long id; |
| | | |
| | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | |
| | | import java.util.Date; |
| | | |
| | | @TableName("emergency_drill_execute") |
| | | public class EmergencyDrillExecuteInfoPageDO { |
| | | |
| | | private String drillName; |
| | | |
| | | private String drillAddress; |
| | | |
| | | private String drillWay; |
| | | |
| | | private String drillLevel; |
| | | |
| | | private Date drillPlanDate; |
| | | |
| | | private String emergencyPlanName; |
| | | |
| | | public String getDrillName() { |
| | | return drillName; |
| | | } |
| | | |
| | | public void setDrillName(String drillName) { |
| | | this.drillName = drillName; |
| | | } |
| | | |
| | | public String getDrillAddress() { |
| | | return drillAddress; |
| | | } |
| | | |
| | | public void setDrillAddress(String drillAddress) { |
| | | this.drillAddress = drillAddress; |
| | | } |
| | | |
| | | public String getDrillWay() { |
| | | return drillWay; |
| | | } |
| | | |
| | | public void setDrillWay(String drillWay) { |
| | | this.drillWay = drillWay; |
| | | } |
| | | |
| | | public String getDrillLevel() { |
| | | return drillLevel; |
| | | } |
| | | |
| | | public void setDrillLevel(String drillLevel) { |
| | | this.drillLevel = drillLevel; |
| | | } |
| | | |
| | | public Date getDrillPlanDate() { |
| | | return drillPlanDate; |
| | | } |
| | | |
| | | public void setDrillPlanDate(Date drillPlanDate) { |
| | | this.drillPlanDate = drillPlanDate; |
| | | } |
| | | |
| | | public String getEmergencyPlanName() { |
| | | return emergencyPlanName; |
| | | } |
| | | |
| | | public void setEmergencyPlanName(String emergencyPlanName) { |
| | | this.emergencyPlanName = emergencyPlanName; |
| | | } |
| | | |
| | | @TableId(type = IdType.AUTO) |
| | | private Long id; |
| | | |
| | |
| | | |
| | | private Long id; |
| | | |
| | | private Long drillPlanId; |
| | | private Long drillExecuteId; |
| | | |
| | | private String suitable; |
| | | |
| | |
| | | this.id = id; |
| | | } |
| | | |
| | | public Long getDrillPlanId() { |
| | | return drillPlanId; |
| | | public Long getDrillExecuteId() { |
| | | return drillExecuteId; |
| | | } |
| | | |
| | | public void setDrillPlanId(Long drillPlanId) { |
| | | this.drillPlanId = drillPlanId; |
| | | public void setDrillExecuteId(Long drillExecuteId) { |
| | | this.drillExecuteId = drillExecuteId; |
| | | } |
| | | |
| | | public String getSuitable() { |
| | |
| | | public String toString() { |
| | | return "EmergencyDrillEvaluationReqDTO{" + |
| | | "id=" + id + |
| | | ", drillPlanId=" + drillPlanId + |
| | | ", drillExecuteId=" + drillExecuteId + |
| | | ", suitable='" + suitable + '\'' + |
| | | ", sufficient='" + sufficient + '\'' + |
| | | ", arrival='" + arrival + '\'' + |
| | |
| | | |
| | | private Long id; |
| | | |
| | | private Long drillPlanId; |
| | | private Long drillExecuteId; |
| | | |
| | | private String suitable; |
| | | |
| | |
| | | this.id = id; |
| | | } |
| | | |
| | | public Long getDrillPlanId() { |
| | | return drillPlanId; |
| | | public Long getDrillExecuteId() { |
| | | return drillExecuteId; |
| | | } |
| | | |
| | | public void setDrillPlanId(Long drillPlanId) { |
| | | this.drillPlanId = drillPlanId; |
| | | public void setDrillExecuteId(Long drillExecuteId) { |
| | | this.drillExecuteId = drillExecuteId; |
| | | } |
| | | |
| | | public String getSuitable() { |
| | |
| | | public String toString() { |
| | | return "EmergencyDrillEvaluationDetailRespDTO{" + |
| | | "id=" + id + |
| | | ", drillPlanId=" + drillPlanId + |
| | | ", drillExecuteId=" + drillExecuteId + |
| | | ", suitable='" + suitable + '\'' + |
| | | ", sufficient='" + sufficient + '\'' + |
| | | ", arrival='" + arrival + '\'' + |
| | |
| | | package com.gkhy.safePlatform.emergency.model.dto.resp; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | |
| | | import java.util.Date; |
| | | |
| | | public class EmergencyDrillEvaluationPageRespDTO { |
| | | |
| | | private String drillName; |
| | | |
| | | private String drillAddress; |
| | | |
| | | private String drillWay; |
| | | |
| | | private String drillLevel; |
| | | |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | private Date drillPlanDate; |
| | | |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | private Date drillRecordDate; |
| | | |
| | | public String getDrillName() { |
| | | return drillName; |
| | | } |
| | | |
| | | public void setDrillName(String drillName) { |
| | | this.drillName = drillName; |
| | | } |
| | | |
| | | public String getDrillAddress() { |
| | | return drillAddress; |
| | | } |
| | | |
| | | public void setDrillAddress(String drillAddress) { |
| | | this.drillAddress = drillAddress; |
| | | } |
| | | |
| | | public String getDrillWay() { |
| | | return drillWay; |
| | | } |
| | | |
| | | public void setDrillWay(String drillWay) { |
| | | this.drillWay = drillWay; |
| | | } |
| | | |
| | | public String getDrillLevel() { |
| | | return drillLevel; |
| | | } |
| | | |
| | | public void setDrillLevel(String drillLevel) { |
| | | this.drillLevel = drillLevel; |
| | | } |
| | | |
| | | public Date getDrillPlanDate() { |
| | | return drillPlanDate; |
| | | } |
| | | |
| | | public void setDrillPlanDate(Date drillPlanDate) { |
| | | this.drillPlanDate = drillPlanDate; |
| | | } |
| | | |
| | | public Date getDrillRecordDate() { |
| | | return drillRecordDate; |
| | | } |
| | | |
| | | public void setDrillRecordDate(Date drillRecordDate) { |
| | | this.drillRecordDate = drillRecordDate; |
| | | } |
| | | |
| | | private Long id; |
| | | |
| | | private Long drillPlanId; |
| | | private Long drillExecuteId; |
| | | |
| | | |
| | | public Long getId() { |
| | |
| | | this.id = id; |
| | | } |
| | | |
| | | public Long getDrillPlanId() { |
| | | return drillPlanId; |
| | | public Long getDrillExecuteId() { |
| | | return drillExecuteId; |
| | | } |
| | | |
| | | public void setDrillPlanId(Long drillPlanId) { |
| | | this.drillPlanId = drillPlanId; |
| | | public void setDrillExecuteId(Long drillExecuteId) { |
| | | this.drillExecuteId = drillExecuteId; |
| | | } |
| | | |
| | | |
| | |
| | | public String toString() { |
| | | return "EmergencyDrillEvaluationInfo{" + |
| | | "id=" + id + |
| | | ", drillPlanId=" + drillPlanId + |
| | | ", drillExecuteId=" + drillExecuteId + |
| | | '}'; |
| | | } |
| | | } |
| | |
| | | |
| | | public class EmergencyDrillExecuteDetailRespDTO { |
| | | |
| | | private String drillName; |
| | | |
| | | public String getDrillName() { |
| | | return drillName; |
| | | } |
| | | |
| | | public void setDrillName(String drillName) { |
| | | this.drillName = drillName; |
| | | } |
| | | |
| | | private Long id; |
| | | |
| | | private Boolean status; |
| | |
| | | package com.gkhy.safePlatform.emergency.model.dto.resp; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.gkhy.safePlatform.emergency.model.dto.req.EmergencyDrillExecuteUserReqDTO; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | public class EmergencyDrillExecutePageRespDTO { |
| | | |
| | | private String drillName; |
| | | |
| | | private String drillAddress; |
| | | |
| | | private String drillWay; |
| | | |
| | | private String drillLevel; |
| | | |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | private Date drillPlanDate; |
| | | |
| | | private String emergencyPlanName; |
| | | |
| | | public String getDrillName() { |
| | | return drillName; |
| | | } |
| | | |
| | | public void setDrillName(String drillName) { |
| | | this.drillName = drillName; |
| | | } |
| | | |
| | | public String getDrillAddress() { |
| | | return drillAddress; |
| | | } |
| | | |
| | | public void setDrillAddress(String drillAddress) { |
| | | this.drillAddress = drillAddress; |
| | | } |
| | | |
| | | public String getDrillWay() { |
| | | return drillWay; |
| | | } |
| | | |
| | | public void setDrillWay(String drillWay) { |
| | | this.drillWay = drillWay; |
| | | } |
| | | |
| | | public String getDrillLevel() { |
| | | return drillLevel; |
| | | } |
| | | |
| | | public void setDrillLevel(String drillLevel) { |
| | | this.drillLevel = drillLevel; |
| | | } |
| | | |
| | | public Date getDrillPlanDate() { |
| | | return drillPlanDate; |
| | | } |
| | | |
| | | public void setDrillPlanDate(Date drillPlanDate) { |
| | | this.drillPlanDate = drillPlanDate; |
| | | } |
| | | |
| | | public String getEmergencyPlanName() { |
| | | return emergencyPlanName; |
| | | } |
| | | |
| | | public void setEmergencyPlanName(String emergencyPlanName) { |
| | | this.emergencyPlanName = emergencyPlanName; |
| | | } |
| | | |
| | | private Long id; |
| | | |
| | | private Boolean status; |
| | |
| | | <resultMap type="com.gkhy.safePlatform.emergency.entity.EmergencyDrillEvaluationInfoPageDO" |
| | | id="emergencyDrillEvaluationInfoPageDOResult"> |
| | | <id column="id" property="id" jdbcType="BIGINT"/> |
| | | <result column="drill_plan_id" property="drillPlanId"/> |
| | | <result column="drill_execute_id" property="drillExecuteId"/> |
| | | </resultMap> |
| | | |
| | | <select id="selectEmergencyDrillEvaluationList" resultMap="emergencyDrillEvaluationInfoPageDOResult"> |
| | | select id,`drill_plan_id` from emergency_drill_evaluation where del_flag = 0 |
| | | SELECT |
| | | a.id, |
| | | c.drill_name AS drillName, |
| | | c.drill_address AS drillAddress, |
| | | c.drill_way AS drillWay, |
| | | c.drill_level AS drillLevel, |
| | | c.drill_plan_date AS drillPlanDate, |
| | | b.`drill_record_date` AS drillRecordDate |
| | | FROM |
| | | emergency_drill_evaluation a |
| | | LEFT JOIN emergency_drill_execute b ON a.drill_execute_id = b.id |
| | | LEFT JOIN emergency_drill_plan c ON b.drill_plan_id = c.id |
| | | WHERE |
| | | a.del_flag = 0 |
| | | </select> |
| | | |
| | | <insert id="addEmergencyDrillEvaluation" parameterType="com.gkhy.safePlatform.emergency.entity.EmergencyDrillEvaluationInfo" |
| | |
| | | <if test="gmtModitify != null ">gmt_moditify,</if> |
| | | <if test="createUid != null ">create_uid,</if> |
| | | <if test="updateUid != null ">update_uid,</if> |
| | | <if test="drillPlanId != null ">drill_plan_id,</if> |
| | | <if test="drillExecuteId != null ">drill_execute_id,</if> |
| | | <if test="suitable != null and suitable != ''">`suitable`,</if> |
| | | <if test="sufficient != null and sufficient != ''">`sufficient`,</if> |
| | | <if test="arrival != null and arrival != ''">`arrival`,</if> |
| | |
| | | <if test="gmtModitify != null ">#{gmtModitify},</if> |
| | | <if test="createUid != null ">#{createUid},</if> |
| | | <if test="updateUid != null ">#{updateUid},</if> |
| | | <if test="drillPlanId != null ">#{drillPlanId},</if> |
| | | <if test="drillExecuteId != null ">#{drillExecuteId},</if> |
| | | <if test="suitable != null and suitable != ''">#{suitable},</if> |
| | | <if test="sufficient != null and sufficient != ''">#{sufficient},</if> |
| | | <if test="arrival != null and arrival != ''">#{arrival},</if> |
| | |
| | | |
| | | <resultMap type="com.gkhy.safePlatform.emergency.entity.EmergencyDrillEvaluationInfoDetailDO" id="emergencyDrillEvaluationInfoDetailDOResult"> |
| | | <id column="id" property="id" jdbcType="BIGINT"/> |
| | | <result column="drill_plan_id" property="drillPlanId"/> |
| | | <result column="drill_execute_id" property="drillExecuteId"/> |
| | | <result column="suitable" property="suitable"/> |
| | | <result column="sufficient" property="sufficient"/> |
| | | <result column="arrival" property="arrival"/> |
| | |
| | | </resultMap> |
| | | |
| | | <select id="selectEmergencyDrillEvaluationById" resultMap="emergencyDrillEvaluationInfoDetailDOResult"> |
| | | select id ,`drill_plan_id`,`suitable`,`sufficient`,`arrival`,supplies ,protection ,whole ,division, |
| | | select id ,`drill_execute_id`,`suitable`,`sufficient`,`arrival`,supplies ,protection ,whole ,division, |
| | | effect ,report ,safety ,rescue ,evacuate ,need_modify ,question_and_improve ,modify_content |
| | | from emergency_drill_evaluation |
| | | where del_flag = 0 and id = #{id} |
| | |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="gmtModitify != null ">gmt_moditify = #{gmtModitify},</if> |
| | | <if test="updateUid != null ">update_uid = #{updateUid},</if> |
| | | <if test="drillPlanId != null ">drill_plan_id = #{drillPlanId},</if> |
| | | <if test="drillExecuteId != null ">drill_execute_id = #{drillExecuteId},</if> |
| | | <if test="suitable != null and suitable != ''">suitable = #{suitable},</if> |
| | | <if test="sufficient != null and sufficient != ''">sufficient = #{sufficient},</if> |
| | | <if test="arrival != null and arrival != ''">arrival = #{arrival},</if> |
| | |
| | | </resultMap> |
| | | |
| | | <select id="selectEmergencyDrillExecuteList" resultMap="emergencyDrillExecuteInfoPageDOResult"> |
| | | select id,`status`,`drill_record_date`,`drill_plan_id`,`record_user_uid`,process_desc from emergency_drill_execute where del_flag = 0 |
| | | SELECT |
| | | a.id, |
| | | b.drill_name as drillName, |
| | | b.drill_address as drillAddress, |
| | | b.drill_way as drillWay, |
| | | b.drill_level as drillLevel, |
| | | b.drill_plan_date as drillPlanDate, |
| | | a.`drill_record_date`, |
| | | c.`name` as emergencyPlanName |
| | | FROM |
| | | emergency_drill_execute a |
| | | LEFT JOIN emergency_drill_plan b ON a.drill_plan_id = b.id |
| | | LEFT JOIN emergency_plan c ON b.plan_id = c.id |
| | | WHERE |
| | | a.del_flag = 0 |
| | | </select> |
| | | |
| | | <insert id="addEmergencyDrillExecute" parameterType="com.gkhy.safePlatform.emergency.entity.EmergencyDrillExecuteInfo" |
| | |
| | | </resultMap> |
| | | |
| | | <select id="selectEmergencyDrillExecuteById" resultMap="emergencyDrillExecuteInfoDetailDOResult"> |
| | | select id,`status`,`drill_record_date`,`drill_plan_id`,`record_user_uid`,process_desc from emergency_drill_execute |
| | | where del_flag = 0 and id = #{id} |
| | | SELECT |
| | | a.id, |
| | | a.`status`, |
| | | a.`drill_record_date`, |
| | | a.`drill_plan_id`, |
| | | a.`record_user_uid`, |
| | | a.process_desc, |
| | | b.drill_name AS drillName |
| | | FROM |
| | | emergency_drill_execute a |
| | | LEFT JOIN emergency_drill_plan b ON a.drill_plan_id = b.id |
| | | WHERE |
| | | a.del_flag = 0 |
| | | AND a.id = #{id} |
| | | </select> |
| | | |
| | | <update id="updateEmergencyDrillExecute" parameterType="com.gkhy.safePlatform.emergency.entity.EmergencyDrillExecuteInfo"> |