Merge remote-tracking branch 'origin/master'
| | |
| | | sa.id,sa.candidate_no candidateNo, |
| | | ke.exam_type examType,ke.start_time startTime,ke.end_time endTime,ke.exam_name examName, |
| | | bu.real_name realName,bu.cardid idCardNo,ifnull(bu.sex,0) sex,bu.avatar myPicture, |
| | | bd.dept_name deptName,"保安证" applyCard |
| | | bd.dept_name deptName,"保安证" applyCard, |
| | | er.exam_room_name examRoomName,er.address,er.exam_room_no examRoomNo |
| | | FROM |
| | | sys_apply sa |
| | | left join |
| | |
| | | blade_dept bd |
| | | on |
| | | bd.id = bu.dept_id |
| | | left join |
| | | exam_room er |
| | | on |
| | | er.id = ke.exam_room_id |
| | | WHERE |
| | | sa.id = #{apply.id} |
| | | </select> |
| | |
| | | */ |
| | | private String address; |
| | | |
| | | /** |
| | | * 考场名称 |
| | | */ |
| | | private String examRoomName; |
| | | |
| | | /** |
| | | * 考场号 |
| | | */ |
| | | private String examRoomNo; |
| | | |
| | | } |
| | |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | private Date auditTime; |
| | | |
| | | /** |
| | | * 考场号id |
| | | */ |
| | | @TableField("exam_room_id") |
| | | private Integer examRoomId; |
| | | |
| | | |
| | | } |
| | |
| | | @TableField("reason_for_leav") |
| | | private String reasonForLeav; |
| | | |
| | | private String holdv; |
| | | |
| | | @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | private Date holdvtime; |
| | | |
| | | /** |
| | | * 是否缴纳保险 0:是 1:否 |
| | | */ |
| | | private Integer insurance; |
| | | |
| | | } |