| | |
| | | import com.java110.utils.constant.ResponseConstant; |
| | | import com.java110.utils.constant.StatusConstant; |
| | | import com.java110.utils.exception.ListenerExecuteException; |
| | | import com.java110.utils.util.DateUtil; |
| | | import org.slf4j.Logger; |
| | | import org.slf4j.LoggerFactory; |
| | | |
| | |
| | | |
| | | currentStoreAttrInfo.put("attrId", currentStoreAttrInfo.get("attr_id")); |
| | | currentStoreAttrInfo.put("operate", currentStoreAttrInfo.get("operate")); |
| | | currentStoreAttrInfo.put("createTime", currentStoreAttrInfo.get("create_time")); |
| | | // currentStoreAttrInfo.put("createTime", currentStoreAttrInfo.get("create_time")); |
| | | currentStoreAttrInfo.put("specCd", currentStoreAttrInfo.get("spec_cd")); |
| | | currentStoreAttrInfo.put("storeId", currentStoreAttrInfo.get("store_id")); |
| | | currentStoreAttrInfo.put("value", currentStoreAttrInfo.get("value")); |
| | | |
| | | |
| | | currentStoreAttrInfo.put("month", DateUtil.getCurrentMonth()); |
| | | currentStoreAttrInfo.put("operate", StatusConstant.OPERATE_DEL); |
| | | getStoreAttrServiceDaoImpl().saveBusinessStoreAttrInfo(currentStoreAttrInfo); |
| | | } |
| | |
| | | <!-- 保存商户属性信息 add by wuxw 2018-07-03 --> |
| | | <insert id="saveBusinessStoreAttrInfo" parameterType="Map"> |
| | | insert into |
| | | business_store_attr(attr_id,operate,create_time,spec_cd,store_id,b_id,value) |
| | | values (#{attrId},#{operate},#{createTime},#{specCd},#{storeId},#{bId},#{value}) |
| | | business_store_attr(attr_id,operate,spec_cd,store_id,b_id,value,month) |
| | | values (#{attrId},#{operate},#{specCd},#{storeId},#{bId},#{value},#{month}) |
| | | </insert> |
| | | |
| | | |
| | | <!-- 查询商户属性信息(Business) add by wuxw 2018-07-03 --> |
| | | <select id="getBusinessStoreAttrInfo" parameterType="Map" resultType="Map"> |
| | | select t.attr_id,t.attr_id attrId,t.operate,t.create_time,t.create_time createTime,t.spec_cd,t.spec_cd |
| | | specCd,t.store_id,t.store_id storeId,t.bId,t.value |
| | | select |
| | | t.attr_id,t.attr_id attrId, |
| | | t.operate, |
| | | t.create_time,t.create_time createTime, |
| | | t.spec_cd,t.spec_cd specCd, |
| | | t.store_id,t.store_id storeId, |
| | | t.b_id,t.b_id bId, |
| | | t.value |
| | | from business_store_attr t |
| | | where 1 =1 |
| | | <if test="attrId !=null and attrId != ''"> |
| | |
| | | and t.store_id= #{storeId} |
| | | </if> |
| | | <if test="bId !=null and bId != ''"> |
| | | and t.bId= #{bId} |
| | | and t.b_id= #{bId} |
| | | </if> |
| | | <if test="value !=null and value != ''"> |
| | | and t.value= #{value} |
| | |
| | | update s_store_attr t set t.status_cd = #{statusCd} |
| | | <if test="newBId != null and newBId != ''"> |
| | | ,t.b_id = #{newBId} |
| | | </if> |
| | | <if test="createTime !=null and createTime != ''"> |
| | | , t.create_time= #{createTime} |
| | | </if> |
| | | <if test="specCd !=null and specCd != ''"> |
| | | , t.spec_cd= #{specCd} |
| | |
| | | <insert id="saveBusinessStoreInfo" parameterType="Map"> |
| | | insert into |
| | | business_store(store_id,b_id,user_id,name,address,tel,store_type_cd,nearby_landmarks,map_x,map_y,month,operate) |
| | | values(#{storeId},#{bId},#{userId},#{name},#{address},#{tel},#{storeTypeCd},#{nearbyLandmarks},#{mapX},#{mapY},#{month},#{operate}) |
| | | values(#{storeId},#{bId},#{userId},#{name},#{address},#{tel},#{storeTypeCd},#{nearByLandmarks},#{mapX},#{mapY},#{month},#{operate}) |
| | | </insert> |
| | | <!-- 保存商户属性信息 add by wuxw 2018-07-03 --> |
| | | <insert id="saveBusinessStoreAttr" parameterType="Map"> |