| | |
|---|
| | | @Select("select name from sys_user where user_id=#{createBy}") |
|---|
| | | String selectNameByUserId(Long createBy); |
|---|
| | | |
|---|
| | | @Update("update sys_user u set u.is_partymember=0 where u.id_card=#{idCard}") |
|---|
| | | void updateUserIsPartymember(String idCard); |
|---|
| | | @Update("update sys_user u set u.is_partymember=0 where u.phone=#{phone}") |
|---|
| | | void updateUserIsPartymember(String phone); |
|---|
| | | |
|---|
| | | @Select("<script> " + "SELECT\n" + "o.`name` orgName,\n" + "m.org_id,\n" + "m.id_card,\n" + "m.`id`,\n" |
|---|
| | | + "u.phone,\n" + "m.`name`,\n" + "m.photo_path,\n" + "TIMESTAMPDIFF(\n" + "YEAR,\n" + "m.employment_time,\n" |
|---|
