| | |
| | | <id column="introduction" property="introduction" /> |
| | | <id column="business_status" property="businessStatus" /> |
| | | <id column="user_id" property="userId" /> |
| | | <id column="consultation_volume" property="consultationVolume" /> |
| | | <id column="view_num" property="viewNum" /> |
| | | <id column="is_del" property="isDel" /> |
| | | <id column="created_at" property="createdAt" /> |
| | | <id column="created_by" property="createdBy" /> |
| | |
| | | <!-- 通用查询结果列 --> |
| | | <sql id="Base_Column_List"> |
| | | 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, |
| | | period,introduction,business_status,user_id,is_del,created_at,created_by,updated_at, |
| | | updated_by,detailed_address |
| | | </sql> |
| | | <select id="pageMerchant" resultType="com.panzhihua.common.model.vos.community.convenient.JinhuiConvenientMerchantVO"> |
| | |
| | | <if test="item.userId != null and item.userId != '' "> |
| | | user_id, |
| | | </if> |
| | | <if test="item.consultationVolume != null and item.consultationVolume != '' "> |
| | | consultation_volume, |
| | | </if> |
| | | <if test="item.viewNum != null and item.viewNum != '' "> |
| | | view_num, |
| | | </if> |
| | | <if test="item.isDel != null and item.isDel != '' "> |
| | | is_del, |
| | | </if> |
| | |
| | | </if> |
| | | <if test="item.updatedBy != null and item.updatedBy != '' "> |
| | | updated_by, |
| | | </if> |
| | | <if test="item.sale != null and item.sale != '' "> |
| | | sale, |
| | | </if> |
| | | <if test="item.saleVolume != null and item.saleVolume != '' "> |
| | | sale_volume, |
| | | </if> |
| | | <if test="item.convenientType != null and item.convenientType != '' "> |
| | | convenient_type, |
| | |
| | | <if test="item.userId != null and item.userId != '' "> |
| | | #{item.userId}, |
| | | </if> |
| | | <if test="item.consultationVolume != null and item.consultationVolume != '' "> |
| | | #{item.consultationVolume}, |
| | | </if> |
| | | <if test="item.viewNum != null and item.viewNum != '' "> |
| | | #{item.viewNum}, |
| | | </if> |
| | | <if test="item.isDel != null and item.isDel != '' "> |
| | | #{item.isDel}, |
| | | </if> |
| | |
| | | </if> |
| | | <if test="item.updatedBy != null and item.updatedBy != '' "> |
| | | #{item.updatedBy}, |
| | | </if> |
| | | <if test="item.sale != null and item.sale != '' "> |
| | | #{item.sale}, |
| | | </if> |
| | | <if test="item.saleVolume != null and item.saleVolume != '' "> |
| | | #{item.saleVolume}, |
| | | </if> |
| | | <if test="item.convenientType != null and item.convenientType != '' "> |
| | | #{item.convenientType}, |
| | |
| | | <if test="item.userId != null and item.userId != '' "> |
| | | user_id=#{item.userId}, |
| | | </if> |
| | | <if test="item.consultationVolume != null and item.consultationVolume != '' "> |
| | | consultation_volume=#{item.consultationVolume}, |
| | | </if> |
| | | <if test="item.viewNum != null and item.viewNum != '' "> |
| | | view_num=#{item.viewNum}, |
| | | </if> |
| | | <if test="item.isDel != null and item.isDel != '' "> |
| | | is_del=#{item.isDel}, |
| | | </if> |
| | |
| | | </if> |
| | | <if test="item.updatedBy != null and item.updatedBy != '' "> |
| | | updated_by=#{item.updatedBy}, |
| | | </if> |
| | | <if test="item.sale != null and item.sale != '' "> |
| | | sale=#{item.sale}, |
| | | </if> |
| | | <if test="item.saleVolume != null and item.saleVolume != '' "> |
| | | sale_volume=#{item.saleVolume}, |
| | | </if> |
| | | <if test="item.convenientType != null and item.convenientType != '' "> |
| | | convenient_type=#{item.convenientType}, |