| | |
| | | /** |
| | | * 部门电话 |
| | | */ |
| | | @TableField(exist = false) |
| | | @ApiModelProperty("部门电话") |
| | | private String contactNumber; |
| | | |
| | |
| | | <select id="selectByKeyWord" resultMap="OrganizationChartResult"> |
| | | <include refid="selectOrganizationChartVo"/> |
| | | where organization_name like concat('%', #{keyWord}, '%') or #{keyWord} like concat('%', organization_name, '%') |
| | | or detailed_address like concat('%', #{keyWord}, '%') or #{keyWord} like concat('%', detailed_address, '%') |
| | | or resume like concat('%', #{keyWord}, '%') or #{keyWord} like concat('%', resume, '%') |
| | | or((detailed_address like concat('%', #{keyWord}, '%') or #{keyWord} like concat('%', detailed_address, '%')) and TRIM(detailed_address) != '') |
| | | or((resume like concat('%', #{keyWord}, '%') or #{keyWord} like concat('%', resume, '%')) and TRIM(resume) != '' ) |
| | | </select> |
| | | |
| | | <select id="selectByCode" resultMap="OrganizationChartResult"> |