| | |
| | | package com.java110.store.dao.impl; |
| | | |
| | | import com.java110.common.log.LoggerEngine; |
| | | import com.java110.common.util.Assert; |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.java110.common.constant.ResponseConstant; |
| | | import com.java110.common.exception.DAOException; |
| | | import com.java110.core.base.dao.BaseServiceDao; |
| | | import com.java110.entity.merchant.BoMerchant; |
| | | import com.java110.entity.merchant.BoMerchantAttr; |
| | | import com.java110.entity.merchant.Merchant; |
| | | import com.java110.entity.merchant.MerchantAttr; |
| | | import com.java110.store.dao.IStoreServiceDao; |
| | | import org.slf4j.Logger; |
| | | import org.slf4j.LoggerFactory; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * 商户服务 与数据库交互 |
| | | * Created by wuxw on 2017/4/5. |
| | | */ |
| | | @Service("storeServiceDaoImpl") |
| | | @Transactional |
| | | //@Transactional |
| | | public class StoreServiceDaoImpl extends BaseServiceDao implements IStoreServiceDao { |
| | | |
| | | private final static Logger logger = LoggerFactory.getLogger(StoreServiceDaoImpl.class); |
| | | |
| | | /** |
| | | * 商户信息封装 |
| | | * @param businessStoreInfo 商户信息 封装 |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public void saveBusinessStoreInfo(Map businessStoreInfo) throws DAOException { |
| | | // 查询business_user 数据是否已经存在 |
| | | logger.debug("保存商户信息 入参 businessStoreInfo : {}",businessStoreInfo); |
| | | int saveFlag = sqlSessionTemplate.insert("storeServiceDaoImpl.saveBusinessStoreInfo",businessStoreInfo); |
| | | |
| | | if(saveFlag < 1){ |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"保存商户数据失败:"+ JSONObject.toJSONString(businessStoreInfo)); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 商户属性信息分装 |
| | | * @param businessStoreAttr 商户属性信息封装 |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public void saveBusinessStoreAttr(Map businessStoreAttr) throws DAOException { |
| | | // 查询business_user 数据是否已经存在 |
| | | logger.debug("保存商户属性信息 入参 businessStoreAttr : {}",businessStoreAttr); |
| | | |
| | | int saveFlag = sqlSessionTemplate.insert("storeServiceDaoImpl.saveBusinessStoreAttr",businessStoreAttr); |
| | | |
| | | if(saveFlag < 1){ |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"保存商户属性数据失败:"+ JSONObject.toJSONString(businessStoreAttr)); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 保存商户照片信息 |
| | | * @param businessStorePhoto 商户照片 |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public void saveBusinessStorePhoto(Map businessStorePhoto) throws DAOException { |
| | | |
| | | logger.debug("保存商户照片信息 入参 businessStorePhoto : {}",businessStorePhoto); |
| | | |
| | | int saveFlag = sqlSessionTemplate.insert("storeServiceDaoImpl.saveBusinessStorePhoto",businessStorePhoto); |
| | | |
| | | if(saveFlag < 1){ |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"保存商户照片数据失败:"+ JSONObject.toJSONString(businessStorePhoto)); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 保存商户证件信息 |
| | | * @param businessStoreCerdentials 商户证件 |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public void saveBusinessStoreCerdentials(Map businessStoreCerdentials) throws DAOException { |
| | | logger.debug("保存商户证件信息 入参 businessStoreCerdentials : {}",businessStoreCerdentials); |
| | | |
| | | int saveFlag = sqlSessionTemplate.insert("storeServiceDaoImpl.saveBusinessStoreCerdentials",businessStoreCerdentials); |
| | | |
| | | if(saveFlag < 1){ |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"保存商户证件数据失败:"+ JSONObject.toJSONString(businessStoreCerdentials)); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 查询商户信息 |
| | | * @param info bId 信息 |
| | | * @return 商户信息 |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public Map getBusinessStoreInfo(Map info) throws DAOException { |
| | | |
| | | logger.debug("查询商户信息 入参 info : {}",info); |
| | | |
| | | List<Map> businessStoreInfos = sqlSessionTemplate.selectList("storeServiceDaoImpl.getBusinessStoreInfo",info); |
| | | if(businessStoreInfos == null){ |
| | | return null; |
| | | } |
| | | if(businessStoreInfos.size() >1){ |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"根据条件查询有多条数据,数据异常,请检查:businessStoreInfos,"+ JSONObject.toJSONString(info)); |
| | | } |
| | | |
| | | return businessStoreInfos.get(0); |
| | | } |
| | | |
| | | /** |
| | | * 查询商户属性 |
| | | * @param info bId 信息 |
| | | * @return 商户属性 |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public List<Map> getBusinessStoreAttrs(Map info) throws DAOException { |
| | | logger.debug("查询商户属性信息 入参 info : {}",info); |
| | | |
| | | List<Map> businessStoreAttrs = sqlSessionTemplate.selectList("storeServiceDaoImpl.getBusinessStoreAttrs",info); |
| | | |
| | | return businessStoreAttrs; |
| | | } |
| | | |
| | | /** |
| | | * 查询商户照片 |
| | | * @param info bId 信息 |
| | | * @return |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public List<Map> getBusinessStorePhoto(Map info) throws DAOException { |
| | | logger.debug("查询商户照片信息 入参 info : {}",info); |
| | | |
| | | List<Map> businessStorePhotos = sqlSessionTemplate.selectList("storeServiceDaoImpl.getBusinessStorePhoto",info); |
| | | |
| | | return businessStorePhotos; |
| | | } |
| | | |
| | | /** |
| | | * 查询商户证件 |
| | | * @param info bId 信息 |
| | | * @return |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public List<Map> getBusinessStoreCerdentials(Map info) throws DAOException { |
| | | logger.debug("查询商户证件信息 入参 info : {}",info); |
| | | |
| | | List<Map> businessStoreCerdentialses = sqlSessionTemplate.selectList("storeServiceDaoImpl.getBusinessStoreCerdentials",info); |
| | | |
| | | return businessStoreCerdentialses; |
| | | } |
| | | |
| | | /** |
| | | * 保存商户信息 到 instance |
| | | * @param info bId 信息 |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public void saveStoreInfoInstance(Map info) throws DAOException { |
| | | logger.debug("保存商户信息Instance 入参 info : {}",info); |
| | | |
| | | int saveFlag = sqlSessionTemplate.insert("storeServiceDaoImpl.saveStoreInfoInstance",info); |
| | | |
| | | if(saveFlag < 1){ |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"保存商户信息Instance数据失败:"+ JSONObject.toJSONString(info)); |
| | | } |
| | | } |
| | | |
| | | @Override |
| | | public void saveStoreAttrsInstance(Map info) throws DAOException { |
| | | logger.debug("保存商户属性信息Instance 入参 info : {}",info); |
| | | |
| | | int saveFlag = sqlSessionTemplate.insert("storeServiceDaoImpl.saveStoreAttrsInstance",info); |
| | | |
| | | if(saveFlag < 1){ |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"保存商户属性信息Instance数据失败:"+ JSONObject.toJSONString(info)); |
| | | } |
| | | } |
| | | |
| | | @Override |
| | | public void saveStorePhotoInstance(Map info) throws DAOException { |
| | | logger.debug("保存商户照片信息Instance 入参 info : {}",info); |
| | | |
| | | int saveFlag = sqlSessionTemplate.insert("storeServiceDaoImpl.saveStorePhotoInstance",info); |
| | | |
| | | if(saveFlag < 1){ |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"保存商户照片信息Instance数据失败:"+ JSONObject.toJSONString(info)); |
| | | } |
| | | } |
| | | |
| | | @Override |
| | | public void saveStoreCerdentialsInstance(Map info) throws DAOException { |
| | | logger.debug("保存商户证件信息Instance 入参 info : {}",info); |
| | | |
| | | int saveFlag = sqlSessionTemplate.insert("storeServiceDaoImpl.saveStoreCerdentialsInstance",info); |
| | | |
| | | if(saveFlag < 1){ |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"保存商户证件信息Instance数据失败:"+ JSONObject.toJSONString(info)); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 查询商户信息(instance) |
| | | * @param info bId 信息 |
| | | * @return |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public Map getStoreInfo(Map info) throws DAOException { |
| | | logger.debug("查询商户信息 入参 info : {}",info); |
| | | |
| | | List<Map> businessStoreInfos = sqlSessionTemplate.selectList("storeServiceDaoImpl.getStoreInfo",info); |
| | | if(businessStoreInfos == null){ |
| | | return null; |
| | | } |
| | | if(businessStoreInfos.size() >1){ |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"根据条件查询有多条数据,数据异常,请检查:getStoreInfo,"+ JSONObject.toJSONString(info)); |
| | | } |
| | | |
| | | return businessStoreInfos.get(0); |
| | | } |
| | | |
| | | /** |
| | | * 商户属性查询(instance) |
| | | * @param info bId 信息 |
| | | * @return |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public List<Map> getStoreAttrs(Map info) throws DAOException { |
| | | logger.debug("查询商户属性信息 入参 info : {}",info); |
| | | |
| | | List<Map> storeAttrs = sqlSessionTemplate.selectList("storeServiceDaoImpl.getStoreAttrs",info); |
| | | |
| | | return storeAttrs; |
| | | } |
| | | |
| | | /** |
| | | * 商户照片查询(instance) |
| | | * @param info bId 信息 |
| | | * @return |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public List<Map> getStorePhoto(Map info) throws DAOException { |
| | | logger.debug("查询商户照片信息 入参 info : {}",info); |
| | | |
| | | List<Map> storePhotos = sqlSessionTemplate.selectList("storeServiceDaoImpl.getStorePhoto",info); |
| | | |
| | | return storePhotos; |
| | | } |
| | | |
| | | /** |
| | | * 商户证件查询(instance) |
| | | * @param info bId 信息 |
| | | * @return |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public List<Map> getStoreCerdentials(Map info) throws DAOException { |
| | | logger.debug("查询商户证件信息 入参 info : {}",info); |
| | | |
| | | List<Map> storeCerdentialses = sqlSessionTemplate.selectList("storeServiceDaoImpl.getStoreCerdentials",info); |
| | | |
| | | return storeCerdentialses; |
| | | } |
| | | |
| | | /** |
| | | * 修改商户信息 |
| | | * @param info 修改信息 |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public void updateStoreInfoInstance(Map info) throws DAOException { |
| | | logger.debug("修改商户信息Instance 入参 info : {}",info); |
| | | |
| | | int saveFlag = sqlSessionTemplate.update("storeServiceDaoImpl.updateStoreInfoInstance",info); |
| | | |
| | | if(saveFlag < 1){ |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"修改商户信息Instance数据失败:"+ JSONObject.toJSONString(info)); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 修改商户属性信息(instance) |
| | | * @param info 修改信息 |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public void updateStoreAttrInstance(Map info) throws DAOException { |
| | | logger.debug("修改商户属性信息Instance 入参 info : {}",info); |
| | | |
| | | int saveFlag = sqlSessionTemplate.update("storeServiceDaoImpl.updateStoreAttrInstance",info); |
| | | |
| | | if(saveFlag < 1){ |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"修改商户属性信息Instance数据失败:"+ JSONObject.toJSONString(info)); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 修改 商户照片信息 |
| | | * @param info 修改信息 |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public void updateStorePhotoInstance(Map info) throws DAOException { |
| | | logger.debug("修改商户照片信息Instance 入参 info : {}",info); |
| | | |
| | | int saveFlag = sqlSessionTemplate.update("storeServiceDaoImpl.updateStorePhotoInstance",info); |
| | | |
| | | if(saveFlag < 1){ |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"修改商户照片信息Instance数据失败:"+ JSONObject.toJSONString(info)); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 修改商户证件信息 |
| | | * @param info 修改信息 |
| | | * @throws DAOException |
| | | */ |
| | | @Override |
| | | public void updateStoreCerdentailsInstance(Map info) throws DAOException { |
| | | logger.debug("修改商户证件信息Instance 入参 info : {}",info); |
| | | |
| | | int saveFlag = sqlSessionTemplate.update("storeServiceDaoImpl.updateStoreCerdentailsInstance",info); |
| | | |
| | | if(saveFlag < 1){ |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR,"修改商户证件信息Instance数据失败:"+ JSONObject.toJSONString(info)); |
| | | } |
| | | } |
| | | } |