| | |
|---|
| | | |
|---|
| | | @Transactional(readOnly = true) |
|---|
| | | public Map<String, Object> upgradeApplication(Long id) { |
|---|
| | | Map<String, Object> application = one("select * from upgrade_application where deleted = 0 and id = ?", id, "升级申请不存在"); |
|---|
| | | Map<String, Object> application = one(""" |
|---|
| | | select a.*, t.id_card_no as talent_id_card_no |
|---|
| | | from upgrade_application a |
|---|
| | | left join talent_user t on t.id = a.talent_id and t.deleted = 0 |
|---|
| | | where a.deleted = 0 and a.id = ? |
|---|
| | | """, id, "升级申请不存在"); |
|---|
| | | application.put("honors", query(""" |
|---|
| | | select id, honor_name, obtained_date, proof_file_id, sort_no |
|---|
| | | from upgrade_application_honor where application_id = ? order by sort_no, id |
|---|
