| | |
| | | <id column="community_name" property="communityName" /> |
| | | <id column="logo" property="logo" /> |
| | | <id column="contacts" property="contacts" /> |
| | | <id column="id_card" property="idCard" /> |
| | | <id column="phone" property="phone" /> |
| | | <id column="address" property="address" /> |
| | | <id column="address" property="address" /> |
| | |
| | | <id column="created_by" property="createdBy" /> |
| | | <id column="updated_at" property="updatedAt" /> |
| | | <id column="updated_by" property="updatedBy" /> |
| | | <id column="area_code" property="areaCode" /> |
| | | <id column="service_range" property="serviceRange" /> |
| | | <id column="mobile_phone" property="mobilePhone" /> |
| | | <id column="audit_type" property="auditType" /> |
| | | <id column="audit_opinion" property="auditOpinion" /> |
| | | </resultMap> |
| | | |
| | | <!-- 通用查询结果列 --> |
| | | <sql id="Base_Column_List"> |
| | | id,`name`,community_id,community_name,logo,contacts,id_card,phone,address,lat,lon,begin_at,end_at, |
| | | id,`name`,community_id,community_name,logo,contacts,phone,address,lat,lon,begin_at,end_at, |
| | | period,introduction,business_status,user_id,consultation_volume,is_del,created_at,created_by,updated_at, |
| | | updated_by,area_code,service_range,mobile_phone,detailed_address |
| | | updated_by,detailed_address |
| | | </sql> |
| | | <select id="pageMerchant" resultType="com.panzhihua.common.model.vos.community.convenient.JinhuiConvenientMerchantVO"> |
| | | SELECT ccm.*, su.account, su.status AS accountStatus |
| | |
| | | </if> |
| | | <if test="item.communityId != null and item.communityId != 0"> |
| | | AND ccm.community_id = ${item.communityId} |
| | | </if> |
| | | <if test="item.areaCode != null and item.areaCode != ''"> |
| | | AND ccm.area_code = ${item.areaCode} |
| | | </if> |
| | | <if test="item.businessStatus != null"> |
| | | AND ccm.business_status = #{item.businessStatus} |
| | |
| | | </if> |
| | | <if test="item.contacts != null and item.contacts != '' "> |
| | | contacts, |
| | | </if> |
| | | <if test="item.idCard != null and item.idCard != '' "> |
| | | id_card, |
| | | </if> |
| | | <if test="item.phone != null and item.phone != '' "> |
| | | phone, |
| | |
| | | <if test="item.updatedBy != null and item.updatedBy != '' "> |
| | | updated_by, |
| | | </if> |
| | | <if test="item.areaCode != null and item.areaCode != '' "> |
| | | area_code, |
| | | </if> |
| | | <if test="item.mobilePhone != null and item.mobilePhone != '' "> |
| | | mobile_phone, |
| | | </if> |
| | | <if test="item.serviceRange != null and item.serviceRange != '' "> |
| | | service_range, |
| | | </if> |
| | | <if test="item.sale != null and item.sale != '' "> |
| | | sale, |
| | | </if> |
| | |
| | | </if> |
| | | <if test="item.contacts != null and item.contacts != '' "> |
| | | #{item.contacts}, |
| | | </if> |
| | | <if test="item.idCard != null and item.idCard != '' "> |
| | | #{item.idCard}, |
| | | </if> |
| | | <if test="item.phone != null and item.phone != '' "> |
| | | #{item.phone}, |
| | |
| | | <if test="item.updatedBy != null and item.updatedBy != '' "> |
| | | #{item.updatedBy}, |
| | | </if> |
| | | <if test="item.areaCode != null and item.areaCode != '' "> |
| | | #{item.areaCode}, |
| | | </if> |
| | | <if test="item.mobilePhone != null and item.mobilePhone != '' "> |
| | | #{item.mobilePhone}, |
| | | </if> |
| | | <if test="item.serviceRange != null and item.serviceRange != '' "> |
| | | #{item.serviceRange}, |
| | | </if> |
| | | <if test="item.sale != null and item.sale != '' "> |
| | | #{item.sale}, |
| | | </if> |
| | |
| | | </if> |
| | | <if test="item.contacts != null and item.contacts != '' "> |
| | | contacts=#{item.contacts}, |
| | | </if> |
| | | <if test="item.idCard != null and item.idCard != '' "> |
| | | id_card=#{item.idCard}, |
| | | </if> |
| | | <if test="item.phone != null and item.phone != '' "> |
| | | phone=#{item.phone}, |
| | |
| | | </if> |
| | | <if test="item.updatedBy != null and item.updatedBy != '' "> |
| | | updated_by=#{item.updatedBy}, |
| | | </if> |
| | | <if test="item.areaCode != null and item.areaCode != '' "> |
| | | area_code=#{item.areaCode}, |
| | | </if> |
| | | <if test="item.mobilePhone != null and item.mobilePhone != '' "> |
| | | mobile_phone=#{item.mobilePhone}, |
| | | </if> |
| | | <if test="item.serviceRange != null and item.serviceRange != '' "> |
| | | service_range=#{item.serviceRange}, |
| | | </if> |
| | | <if test="item.sale != null and item.sale != '' "> |
| | | sale=#{item.sale}, |