| | |
| | | <!-- 通用查询映射结果 --> |
| | | <resultMap id="BaseResultMap" type="com.ruoyi.basic.pojo.CustomerContact"> |
| | | <id column="id" property="id" /> |
| | | <result column="contact_name" property="contactName" /> |
| | | <result column="phone" property="phone" /> |
| | | <result column="contact_person" property="contactPerson" /> |
| | | <result column="contact_phone" property="contactPhone" /> |
| | | <result column="customer_id" property="customerId" /> |
| | | <result column="dept_id" property="deptId" /> |
| | | <result column="create_user" property="createUser" /> |
| | |
| | | FROM customer_contact cc |
| | | <where> |
| | | cc.del_flag = 0 |
| | | <if test="customerContactDto.contactName != null and customerContactDto.contactName !=''"> |
| | | and cc.contact_name = #{customerContactDto.contactName} |
| | | <if test="customerContactDto.contactPerson != null and customerContactDto.contactPerson !=''"> |
| | | and cc.contact_person = #{customerContactDto.contactPerson} |
| | | </if> |
| | | <if test="customerContactDto.phone != null and customerContactDto.phone !=''"> |
| | | and cc.phone = #{customerContactDto.phone} |
| | | <if test="customerContactDto.contactPhone != null and customerContactDto.contactPhone !=''"> |
| | | and cc.contact_phone = #{customerContactDto.contactPhone} |
| | | </if> |
| | | </where> |
| | | </select> |