| New file |
| | |
| | | package com.java110.common.dao; |
| | | |
| | | |
| | | import com.java110.utils.exception.DAOException; |
| | | 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 java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * 审核人员组件内部之间使用,没有给外围系统提供服务能力 |
| | | * 审核人员服务接口类,要求全部以字符串传输,方便微服务化 |
| | | * 新建客户,修改客户,删除客户,查询客户等功能 |
| | | * |
| | | * Created by wuxw on 2016/12/27. |
| | | */ |
| | | public interface IAuditUserServiceDao { |
| | | |
| | | /** |
| | | * 保存 审核人员信息 |
| | | * @param businessAuditUserInfo 审核人员信息 封装 |
| | | * @throws DAOException 操作数据库异常 |
| | | */ |
| | | void saveBusinessAuditUserInfo(Map businessAuditUserInfo) throws DAOException; |
| | | |
| | | |
| | | |
| | | /** |
| | | * 查询审核人员信息(business过程) |
| | | * 根据bId 查询审核人员信息 |
| | | * @param info bId 信息 |
| | | * @return 审核人员信息 |
| | | * @throws DAOException DAO异常 |
| | | */ |
| | | List<Map> getBusinessAuditUserInfo(Map info) throws DAOException; |
| | | |
| | | |
| | | |
| | | |
| | | /** |
| | | * 保存 审核人员信息 Business数据到 Instance中 |
| | | * @param info |
| | | * @throws DAOException DAO异常 |
| | | */ |
| | | void saveAuditUserInfoInstance(Map info) throws DAOException; |
| | | |
| | | |
| | | |
| | | |
| | | /** |
| | | * 查询审核人员信息(instance过程) |
| | | * 根据bId 查询审核人员信息 |
| | | * @param info bId 信息 |
| | | * @return 审核人员信息 |
| | | * @throws DAOException DAO异常 |
| | | */ |
| | | List<Map> getAuditUserInfo(Map info) throws DAOException; |
| | | |
| | | |
| | | |
| | | /** |
| | | * 修改审核人员信息 |
| | | * @param info 修改信息 |
| | | * @throws DAOException DAO异常 |
| | | */ |
| | | void updateAuditUserInfoInstance(Map info) throws DAOException; |
| | | |
| | | |
| | | /** |
| | | * 查询审核人员总数 |
| | | * |
| | | * @param info 审核人员信息 |
| | | * @return 审核人员数量 |
| | | */ |
| | | int queryAuditUsersCount(Map info); |
| | | |
| | | } |
| New file |
| | |
| | | package com.java110.common.dao.impl; |
| | | |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.java110.common.dao.IAuditUserServiceDao; |
| | | import com.java110.core.base.dao.BaseServiceDao; |
| | | import com.java110.utils.constant.ResponseConstant; |
| | | import com.java110.utils.exception.DAOException; |
| | | import com.java110.utils.util.DateUtil; |
| | | import org.slf4j.Logger; |
| | | import org.slf4j.LoggerFactory; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * 审核人员服务 与数据库交互 |
| | | * Created by wuxw on 2017/4/5. |
| | | */ |
| | | @Service("auditUserServiceDaoImpl") |
| | | //@Transactional |
| | | public class AuditUserServiceDaoImpl extends BaseServiceDao implements IAuditUserServiceDao { |
| | | |
| | | private static Logger logger = LoggerFactory.getLogger(AuditUserServiceDaoImpl.class); |
| | | |
| | | /** |
| | | * 审核人员信息封装 |
| | | * |
| | | * @param businessAuditUserInfo 审核人员信息 封装 |
| | | * @throws DAOException DAO异常 |
| | | */ |
| | | @Override |
| | | public void saveBusinessAuditUserInfo(Map businessAuditUserInfo) throws DAOException { |
| | | businessAuditUserInfo.put("month", DateUtil.getCurrentMonth()); |
| | | // 查询business_user 数据是否已经存在 |
| | | logger.debug("保存审核人员信息 入参 businessAuditUserInfo : {}", businessAuditUserInfo); |
| | | int saveFlag = sqlSessionTemplate.insert("auditUserServiceDaoImpl.saveBusinessAuditUserInfo", businessAuditUserInfo); |
| | | |
| | | if (saveFlag < 1) { |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR, "保存审核人员数据失败:" + JSONObject.toJSONString(businessAuditUserInfo)); |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 查询审核人员信息 |
| | | * |
| | | * @param info bId 信息 |
| | | * @return 审核人员信息 |
| | | * @throws DAOException DAO异常 |
| | | */ |
| | | @Override |
| | | public List<Map> getBusinessAuditUserInfo(Map info) throws DAOException { |
| | | |
| | | logger.debug("查询审核人员信息 入参 info : {}", info); |
| | | |
| | | List<Map> businessAuditUserInfos = sqlSessionTemplate.selectList("auditUserServiceDaoImpl.getBusinessAuditUserInfo", info); |
| | | |
| | | return businessAuditUserInfos; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 保存审核人员信息 到 instance |
| | | * |
| | | * @param info bId 信息 |
| | | * @throws DAOException DAO异常 |
| | | */ |
| | | @Override |
| | | public void saveAuditUserInfoInstance(Map info) throws DAOException { |
| | | logger.debug("保存审核人员信息Instance 入参 info : {}", info); |
| | | |
| | | int saveFlag = sqlSessionTemplate.insert("auditUserServiceDaoImpl.saveAuditUserInfoInstance", info); |
| | | |
| | | if (saveFlag < 1) { |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR, "保存审核人员信息Instance数据失败:" + JSONObject.toJSONString(info)); |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 查询审核人员信息(instance) |
| | | * |
| | | * @param info bId 信息 |
| | | * @return List<Map> |
| | | * @throws DAOException DAO异常 |
| | | */ |
| | | @Override |
| | | public List<Map> getAuditUserInfo(Map info) throws DAOException { |
| | | logger.debug("查询审核人员信息 入参 info : {}", info); |
| | | |
| | | List<Map> businessAuditUserInfos = sqlSessionTemplate.selectList("auditUserServiceDaoImpl.getAuditUserInfo", info); |
| | | |
| | | return businessAuditUserInfos; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 修改审核人员信息 |
| | | * |
| | | * @param info 修改信息 |
| | | * @throws DAOException DAO异常 |
| | | */ |
| | | @Override |
| | | public void updateAuditUserInfoInstance(Map info) throws DAOException { |
| | | logger.debug("修改审核人员信息Instance 入参 info : {}", info); |
| | | |
| | | int saveFlag = sqlSessionTemplate.update("auditUserServiceDaoImpl.updateAuditUserInfoInstance", info); |
| | | |
| | | if (saveFlag < 1) { |
| | | throw new DAOException(ResponseConstant.RESULT_PARAM_ERROR, "修改审核人员信息Instance数据失败:" + JSONObject.toJSONString(info)); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 查询审核人员数量 |
| | | * |
| | | * @param info 审核人员信息 |
| | | * @return 审核人员数量 |
| | | */ |
| | | @Override |
| | | public int queryAuditUsersCount(Map info) { |
| | | logger.debug("查询审核人员数据 入参 info : {}", info); |
| | | |
| | | List<Map> businessAuditUserInfos = sqlSessionTemplate.selectList("auditUserServiceDaoImpl.queryAuditUsersCount", info); |
| | | if (businessAuditUserInfos.size() < 1) { |
| | | return 0; |
| | | } |
| | | |
| | | return Integer.parseInt(businessAuditUserInfos.get(0).get("count").toString()); |
| | | } |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | package com.java110.common.listener; |
| | | |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.java110.common.dao.IAuditUserServiceDao; |
| | | import com.java110.entity.center.Business; |
| | | import com.java110.event.service.AbstractBusinessServiceDataFlowListener; |
| | | import com.java110.utils.constant.ResponseConstant; |
| | | import com.java110.utils.constant.StatusConstant; |
| | | import com.java110.utils.exception.ListenerExecuteException; |
| | | import org.slf4j.Logger; |
| | | import org.slf4j.LoggerFactory; |
| | | |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * 审核人员 服务侦听 父类 |
| | | * Created by wuxw on 2018/7/4. |
| | | */ |
| | | public abstract class AbstractAuditUserBusinessServiceDataFlowListener extends AbstractBusinessServiceDataFlowListener { |
| | | private static Logger logger = LoggerFactory.getLogger(AbstractAuditUserBusinessServiceDataFlowListener.class); |
| | | |
| | | |
| | | /** |
| | | * 获取 DAO工具类 |
| | | * |
| | | * @return |
| | | */ |
| | | public abstract IAuditUserServiceDao getAuditUserServiceDaoImpl(); |
| | | |
| | | /** |
| | | * 刷新 businessAuditUserInfo 数据 |
| | | * 主要将 数据库 中字段和 接口传递字段建立关系 |
| | | * |
| | | * @param businessAuditUserInfo |
| | | */ |
| | | protected void flushBusinessAuditUserInfo(Map businessAuditUserInfo, String statusCd) { |
| | | businessAuditUserInfo.put("newBId", businessAuditUserInfo.get("b_id")); |
| | | businessAuditUserInfo.put("objCode", businessAuditUserInfo.get("obj_code")); |
| | | businessAuditUserInfo.put("auditUserId", businessAuditUserInfo.get("audit_user_id")); |
| | | businessAuditUserInfo.put("operate", businessAuditUserInfo.get("operate")); |
| | | businessAuditUserInfo.put("storeId", businessAuditUserInfo.get("store_id")); |
| | | businessAuditUserInfo.put("userName", businessAuditUserInfo.get("user_name")); |
| | | businessAuditUserInfo.put("userId", businessAuditUserInfo.get("user_id")); |
| | | businessAuditUserInfo.put("auditLink", businessAuditUserInfo.get("audit_link")); |
| | | businessAuditUserInfo.remove("bId"); |
| | | businessAuditUserInfo.put("statusCd", statusCd); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 当修改数据时,查询instance表中的数据 自动保存删除数据到business中 |
| | | * |
| | | * @param businessAuditUser 审核人员信息 |
| | | */ |
| | | protected void autoSaveDelBusinessAuditUser(Business business, JSONObject businessAuditUser) { |
| | | //自动插入DEL |
| | | Map info = new HashMap(); |
| | | info.put("auditUserId", businessAuditUser.getString("auditUserId")); |
| | | info.put("statusCd", StatusConstant.STATUS_CD_VALID); |
| | | List<Map> currentAuditUserInfos = getAuditUserServiceDaoImpl().getAuditUserInfo(info); |
| | | if (currentAuditUserInfos == null || currentAuditUserInfos.size() != 1) { |
| | | throw new ListenerExecuteException(ResponseConstant.RESULT_PARAM_ERROR, "未找到需要修改数据信息,入参错误或数据有问题,请检查" + info); |
| | | } |
| | | |
| | | Map currentAuditUserInfo = currentAuditUserInfos.get(0); |
| | | |
| | | currentAuditUserInfo.put("bId", business.getbId()); |
| | | |
| | | currentAuditUserInfo.put("objCode", currentAuditUserInfo.get("obj_code")); |
| | | currentAuditUserInfo.put("auditUserId", currentAuditUserInfo.get("audit_user_id")); |
| | | currentAuditUserInfo.put("operate", currentAuditUserInfo.get("operate")); |
| | | currentAuditUserInfo.put("storeId", currentAuditUserInfo.get("store_id")); |
| | | currentAuditUserInfo.put("userName", currentAuditUserInfo.get("user_name")); |
| | | currentAuditUserInfo.put("userId", currentAuditUserInfo.get("user_id")); |
| | | currentAuditUserInfo.put("auditLink", currentAuditUserInfo.get("audit_link")); |
| | | |
| | | |
| | | currentAuditUserInfo.put("operate", StatusConstant.OPERATE_DEL); |
| | | getAuditUserServiceDaoImpl().saveBusinessAuditUserInfo(currentAuditUserInfo); |
| | | } |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | package com.java110.common.listener; |
| | | |
| | | import com.alibaba.fastjson.JSONArray; |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.java110.common.dao.IAuditUserServiceDao; |
| | | import com.java110.core.annotation.Java110Listener; |
| | | import com.java110.core.context.DataFlowContext; |
| | | import com.java110.entity.center.Business; |
| | | import com.java110.utils.constant.BusinessTypeConstant; |
| | | import com.java110.utils.constant.ResponseConstant; |
| | | import com.java110.utils.constant.StatusConstant; |
| | | import com.java110.utils.exception.ListenerExecuteException; |
| | | import com.java110.utils.util.Assert; |
| | | import org.slf4j.Logger; |
| | | import org.slf4j.LoggerFactory; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * 删除审核人员信息 侦听 |
| | | * <p> |
| | | * 处理节点 |
| | | * 1、businessAuditUser:{} 审核人员基本信息节点 |
| | | * 2、businessAuditUserAttr:[{}] 审核人员属性信息节点 |
| | | * 3、businessAuditUserPhoto:[{}] 审核人员照片信息节点 |
| | | * 4、businessAuditUserCerdentials:[{}] 审核人员证件信息节点 |
| | | * 协议地址 :https://github.com/java110/MicroCommunity/wiki/%E5%88%A0%E9%99%A4%E5%95%86%E6%88%B7%E4%BF%A1%E6%81%AF-%E5%8D%8F%E8%AE%AE |
| | | * Created by wuxw on 2018/5/18. |
| | | */ |
| | | @Java110Listener("deleteAuditUserInfoListener") |
| | | @Transactional |
| | | public class DeleteAuditUserInfoListener extends AbstractAuditUserBusinessServiceDataFlowListener { |
| | | |
| | | private final static Logger logger = LoggerFactory.getLogger(DeleteAuditUserInfoListener.class); |
| | | @Autowired |
| | | IAuditUserServiceDao auditUserServiceDaoImpl; |
| | | |
| | | @Override |
| | | public int getOrder() { |
| | | return 3; |
| | | } |
| | | |
| | | @Override |
| | | public String getBusinessTypeCd() { |
| | | return BusinessTypeConstant.BUSINESS_TYPE_DELETE_AUDIT_USER; |
| | | } |
| | | |
| | | /** |
| | | * 根据删除信息 查出Instance表中数据 保存至business表 (状态写DEL) 方便撤单时直接更新回去 |
| | | * |
| | | * @param dataFlowContext 数据对象 |
| | | * @param business 当前业务对象 |
| | | */ |
| | | @Override |
| | | protected void doSaveBusiness(DataFlowContext dataFlowContext, Business business) { |
| | | JSONObject data = business.getDatas(); |
| | | |
| | | Assert.notEmpty(data, "没有datas 节点,或没有子节点需要处理"); |
| | | |
| | | //处理 businessAuditUser 节点 |
| | | if (data.containsKey("businessAuditUser")) { |
| | | //处理 businessAuditUser 节点 |
| | | if (data.containsKey("businessAuditUser")) { |
| | | Object _obj = data.get("businessAuditUser"); |
| | | JSONArray businessAuditUsers = null; |
| | | if (_obj instanceof JSONObject) { |
| | | businessAuditUsers = new JSONArray(); |
| | | businessAuditUsers.add(_obj); |
| | | } else { |
| | | businessAuditUsers = (JSONArray) _obj; |
| | | } |
| | | //JSONObject businessAuditUser = data.getJSONObject("businessAuditUser"); |
| | | for (int _auditUserIndex = 0; _auditUserIndex < businessAuditUsers.size(); _auditUserIndex++) { |
| | | JSONObject businessAuditUser = businessAuditUsers.getJSONObject(_auditUserIndex); |
| | | doBusinessAuditUser(business, businessAuditUser); |
| | | if (_obj instanceof JSONObject) { |
| | | dataFlowContext.addParamOut("auditUserId", businessAuditUser.getString("auditUserId")); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | } |
| | | |
| | | /** |
| | | * 删除 instance数据 |
| | | * |
| | | * @param dataFlowContext 数据对象 |
| | | * @param business 当前业务对象 |
| | | */ |
| | | @Override |
| | | protected void doBusinessToInstance(DataFlowContext dataFlowContext, Business business) { |
| | | String bId = business.getbId(); |
| | | //Assert.hasLength(bId,"请求报文中没有包含 bId"); |
| | | |
| | | //审核人员信息 |
| | | Map info = new HashMap(); |
| | | info.put("bId", business.getbId()); |
| | | info.put("operate", StatusConstant.OPERATE_DEL); |
| | | |
| | | //审核人员信息 |
| | | List<Map> businessAuditUserInfos = auditUserServiceDaoImpl.getBusinessAuditUserInfo(info); |
| | | if (businessAuditUserInfos != null && businessAuditUserInfos.size() > 0) { |
| | | for (int _auditUserIndex = 0; _auditUserIndex < businessAuditUserInfos.size(); _auditUserIndex++) { |
| | | Map businessAuditUserInfo = businessAuditUserInfos.get(_auditUserIndex); |
| | | flushBusinessAuditUserInfo(businessAuditUserInfo, StatusConstant.STATUS_CD_INVALID); |
| | | auditUserServiceDaoImpl.updateAuditUserInfoInstance(businessAuditUserInfo); |
| | | dataFlowContext.addParamOut("auditUserId", businessAuditUserInfo.get("audit_user_id")); |
| | | } |
| | | } |
| | | |
| | | } |
| | | |
| | | /** |
| | | * 撤单 |
| | | * 从business表中查询到DEL的数据 将instance中的数据更新回来 |
| | | * |
| | | * @param dataFlowContext 数据对象 |
| | | * @param business 当前业务对象 |
| | | */ |
| | | @Override |
| | | protected void doRecover(DataFlowContext dataFlowContext, Business business) { |
| | | String bId = business.getbId(); |
| | | //Assert.hasLength(bId,"请求报文中没有包含 bId"); |
| | | Map info = new HashMap(); |
| | | info.put("bId", bId); |
| | | info.put("statusCd", StatusConstant.STATUS_CD_INVALID); |
| | | |
| | | Map delInfo = new HashMap(); |
| | | delInfo.put("bId", business.getbId()); |
| | | delInfo.put("operate", StatusConstant.OPERATE_DEL); |
| | | //审核人员信息 |
| | | List<Map> auditUserInfo = auditUserServiceDaoImpl.getAuditUserInfo(info); |
| | | if (auditUserInfo != null && auditUserInfo.size() > 0) { |
| | | |
| | | //审核人员信息 |
| | | List<Map> businessAuditUserInfos = auditUserServiceDaoImpl.getBusinessAuditUserInfo(delInfo); |
| | | //除非程序出错了,这里不会为空 |
| | | if (businessAuditUserInfos == null || businessAuditUserInfos.size() == 0) { |
| | | throw new ListenerExecuteException(ResponseConstant.RESULT_CODE_INNER_ERROR, "撤单失败(auditUser),程序内部异常,请检查! " + delInfo); |
| | | } |
| | | for (int _auditUserIndex = 0; _auditUserIndex < businessAuditUserInfos.size(); _auditUserIndex++) { |
| | | Map businessAuditUserInfo = businessAuditUserInfos.get(_auditUserIndex); |
| | | flushBusinessAuditUserInfo(businessAuditUserInfo, StatusConstant.STATUS_CD_VALID); |
| | | auditUserServiceDaoImpl.updateAuditUserInfoInstance(businessAuditUserInfo); |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 处理 businessAuditUser 节点 |
| | | * |
| | | * @param business 总的数据节点 |
| | | * @param businessAuditUser 审核人员节点 |
| | | */ |
| | | private void doBusinessAuditUser(Business business, JSONObject businessAuditUser) { |
| | | |
| | | Assert.jsonObjectHaveKey(businessAuditUser, "auditUserId", "businessAuditUser 节点下没有包含 auditUserId 节点"); |
| | | |
| | | if (businessAuditUser.getString("auditUserId").startsWith("-")) { |
| | | throw new ListenerExecuteException(ResponseConstant.RESULT_PARAM_ERROR, "auditUserId 错误,不能自动生成(必须已经存在的auditUserId)" + businessAuditUser); |
| | | } |
| | | //自动插入DEL |
| | | autoSaveDelBusinessAuditUser(business, businessAuditUser); |
| | | } |
| | | |
| | | public IAuditUserServiceDao getAuditUserServiceDaoImpl() { |
| | | return auditUserServiceDaoImpl; |
| | | } |
| | | |
| | | public void setAuditUserServiceDaoImpl(IAuditUserServiceDao auditUserServiceDaoImpl) { |
| | | this.auditUserServiceDaoImpl = auditUserServiceDaoImpl; |
| | | } |
| | | } |
| New file |
| | |
| | | package com.java110.common.listener; |
| | | |
| | | import com.alibaba.fastjson.JSONArray; |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.java110.common.dao.IAuditUserServiceDao; |
| | | import com.java110.core.annotation.Java110Listener; |
| | | import com.java110.core.context.DataFlowContext; |
| | | import com.java110.core.factory.GenerateCodeFactory; |
| | | import com.java110.entity.center.Business; |
| | | import com.java110.utils.constant.BusinessTypeConstant; |
| | | import com.java110.utils.constant.StatusConstant; |
| | | import com.java110.utils.util.Assert; |
| | | import org.slf4j.Logger; |
| | | import org.slf4j.LoggerFactory; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * 保存 审核人员信息 侦听 |
| | | * Created by wuxw on 2018/5/18. |
| | | */ |
| | | @Java110Listener("saveAuditUserInfoListener") |
| | | @Transactional |
| | | public class SaveAuditUserInfoListener extends AbstractAuditUserBusinessServiceDataFlowListener { |
| | | |
| | | private static Logger logger = LoggerFactory.getLogger(SaveAuditUserInfoListener.class); |
| | | |
| | | @Autowired |
| | | private IAuditUserServiceDao auditUserServiceDaoImpl; |
| | | |
| | | @Override |
| | | public int getOrder() { |
| | | return 0; |
| | | } |
| | | |
| | | @Override |
| | | public String getBusinessTypeCd() { |
| | | return BusinessTypeConstant.BUSINESS_TYPE_SAVE_AUDIT_USER; |
| | | } |
| | | |
| | | /** |
| | | * 保存审核人员信息 business 表中 |
| | | * |
| | | * @param dataFlowContext 数据对象 |
| | | * @param business 当前业务对象 |
| | | */ |
| | | @Override |
| | | protected void doSaveBusiness(DataFlowContext dataFlowContext, Business business) { |
| | | JSONObject data = business.getDatas(); |
| | | Assert.notEmpty(data, "没有datas 节点,或没有子节点需要处理"); |
| | | |
| | | //处理 businessAuditUser 节点 |
| | | if (data.containsKey("businessAuditUser")) { |
| | | Object bObj = data.get("businessAuditUser"); |
| | | JSONArray businessAuditUsers = null; |
| | | if (bObj instanceof JSONObject) { |
| | | businessAuditUsers = new JSONArray(); |
| | | businessAuditUsers.add(bObj); |
| | | } else { |
| | | businessAuditUsers = (JSONArray) bObj; |
| | | } |
| | | //JSONObject businessAuditUser = data.getJSONObject("businessAuditUser"); |
| | | for (int bAuditUserIndex = 0; bAuditUserIndex < businessAuditUsers.size(); bAuditUserIndex++) { |
| | | JSONObject businessAuditUser = businessAuditUsers.getJSONObject(bAuditUserIndex); |
| | | doBusinessAuditUser(business, businessAuditUser); |
| | | if (bObj instanceof JSONObject) { |
| | | dataFlowContext.addParamOut("auditUserId", businessAuditUser.getString("auditUserId")); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * business 数据转移到 instance |
| | | * |
| | | * @param dataFlowContext 数据对象 |
| | | * @param business 当前业务对象 |
| | | */ |
| | | @Override |
| | | protected void doBusinessToInstance(DataFlowContext dataFlowContext, Business business) { |
| | | JSONObject data = business.getDatas(); |
| | | |
| | | Map info = new HashMap(); |
| | | info.put("bId", business.getbId()); |
| | | info.put("operate", StatusConstant.OPERATE_ADD); |
| | | |
| | | //审核人员信息 |
| | | List<Map> businessAuditUserInfo = auditUserServiceDaoImpl.getBusinessAuditUserInfo(info); |
| | | if (businessAuditUserInfo != null && businessAuditUserInfo.size() > 0) { |
| | | reFreshShareColumn(info, businessAuditUserInfo.get(0)); |
| | | auditUserServiceDaoImpl.saveAuditUserInfoInstance(info); |
| | | if (businessAuditUserInfo.size() == 1) { |
| | | dataFlowContext.addParamOut("auditUserId", businessAuditUserInfo.get(0).get("audit_user_id")); |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 刷 分片字段 |
| | | * |
| | | * @param info 查询对象 |
| | | * @param businessInfo 小区ID |
| | | */ |
| | | private void reFreshShareColumn(Map info, Map businessInfo) { |
| | | |
| | | if (info.containsKey("storeId")) { |
| | | return; |
| | | } |
| | | |
| | | if (!businessInfo.containsKey("store_id")) { |
| | | return; |
| | | } |
| | | |
| | | info.put("storeId", businessInfo.get("store_id")); |
| | | } |
| | | |
| | | /** |
| | | * 撤单 |
| | | * |
| | | * @param dataFlowContext 数据对象 |
| | | * @param business 当前业务对象 |
| | | */ |
| | | @Override |
| | | protected void doRecover(DataFlowContext dataFlowContext, Business business) { |
| | | String bId = business.getbId(); |
| | | //Assert.hasLength(bId,"请求报文中没有包含 bId"); |
| | | Map info = new HashMap(); |
| | | info.put("bId", bId); |
| | | info.put("statusCd", StatusConstant.STATUS_CD_VALID); |
| | | Map paramIn = new HashMap(); |
| | | paramIn.put("bId", bId); |
| | | paramIn.put("statusCd", StatusConstant.STATUS_CD_INVALID); |
| | | //审核人员信息 |
| | | List<Map> auditUserInfo = auditUserServiceDaoImpl.getAuditUserInfo(info); |
| | | if (auditUserInfo != null && auditUserInfo.size() > 0) { |
| | | reFreshShareColumn(paramIn, auditUserInfo.get(0)); |
| | | auditUserServiceDaoImpl.updateAuditUserInfoInstance(paramIn); |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 处理 businessAuditUser 节点 |
| | | * |
| | | * @param business 总的数据节点 |
| | | * @param businessAuditUser 审核人员节点 |
| | | */ |
| | | private void doBusinessAuditUser(Business business, JSONObject businessAuditUser) { |
| | | |
| | | Assert.jsonObjectHaveKey(businessAuditUser, "auditUserId", "businessAuditUser 节点下没有包含 auditUserId 节点"); |
| | | |
| | | if (businessAuditUser.getString("auditUserId").startsWith("-")) { |
| | | //刷新缓存 |
| | | //flushAuditUserId(business.getDatas()); |
| | | |
| | | businessAuditUser.put("auditUserId", GenerateCodeFactory.getGeneratorId(GenerateCodeFactory.CODE_PREFIX_auditUserId)); |
| | | |
| | | } |
| | | |
| | | businessAuditUser.put("bId", business.getbId()); |
| | | businessAuditUser.put("operate", StatusConstant.OPERATE_ADD); |
| | | //保存审核人员信息 |
| | | auditUserServiceDaoImpl.saveBusinessAuditUserInfo(businessAuditUser); |
| | | |
| | | } |
| | | |
| | | public IAuditUserServiceDao getAuditUserServiceDaoImpl() { |
| | | return auditUserServiceDaoImpl; |
| | | } |
| | | |
| | | public void setAuditUserServiceDaoImpl(IAuditUserServiceDao auditUserServiceDaoImpl) { |
| | | this.auditUserServiceDaoImpl = auditUserServiceDaoImpl; |
| | | } |
| | | } |
| New file |
| | |
| | | package com.java110.common.listener; |
| | | |
| | | import com.alibaba.fastjson.JSONArray; |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.java110.common.dao.IAuditUserServiceDao; |
| | | import com.java110.core.annotation.Java110Listener; |
| | | import com.java110.core.context.DataFlowContext; |
| | | import com.java110.entity.center.Business; |
| | | import com.java110.utils.constant.BusinessTypeConstant; |
| | | import com.java110.utils.constant.ResponseConstant; |
| | | import com.java110.utils.constant.StatusConstant; |
| | | import com.java110.utils.exception.ListenerExecuteException; |
| | | import com.java110.utils.util.Assert; |
| | | import org.slf4j.Logger; |
| | | import org.slf4j.LoggerFactory; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * 修改审核人员信息 侦听 |
| | | * <p> |
| | | * 处理节点 |
| | | * 1、businessAuditUser:{} 审核人员基本信息节点 |
| | | * 2、businessAuditUserAttr:[{}] 审核人员属性信息节点 |
| | | * 3、businessAuditUserPhoto:[{}] 审核人员照片信息节点 |
| | | * 4、businessAuditUserCerdentials:[{}] 审核人员证件信息节点 |
| | | * 协议地址 :https://github.com/java110/MicroCommunity/wiki/%E4%BF%AE%E6%94%B9%E5%95%86%E6%88%B7%E4%BF%A1%E6%81%AF-%E5%8D%8F%E8%AE%AE |
| | | * Created by wuxw on 2018/5/18. |
| | | */ |
| | | @Java110Listener("updateAuditUserInfoListener") |
| | | @Transactional |
| | | public class UpdateAuditUserInfoListener extends AbstractAuditUserBusinessServiceDataFlowListener { |
| | | |
| | | private static Logger logger = LoggerFactory.getLogger(UpdateAuditUserInfoListener.class); |
| | | @Autowired |
| | | private IAuditUserServiceDao auditUserServiceDaoImpl; |
| | | |
| | | @Override |
| | | public int getOrder() { |
| | | return 2; |
| | | } |
| | | |
| | | @Override |
| | | public String getBusinessTypeCd() { |
| | | return BusinessTypeConstant.BUSINESS_TYPE_UPDATE_AUDIT_USER; |
| | | } |
| | | |
| | | /** |
| | | * business过程 |
| | | * |
| | | * @param dataFlowContext 上下文对象 |
| | | * @param business 业务对象 |
| | | */ |
| | | @Override |
| | | protected void doSaveBusiness(DataFlowContext dataFlowContext, Business business) { |
| | | |
| | | JSONObject data = business.getDatas(); |
| | | |
| | | Assert.notEmpty(data, "没有datas 节点,或没有子节点需要处理"); |
| | | |
| | | //处理 businessAuditUser 节点 |
| | | if (data.containsKey("businessAuditUser")) { |
| | | //处理 businessAuditUser 节点 |
| | | if (data.containsKey("businessAuditUser")) { |
| | | Object _obj = data.get("businessAuditUser"); |
| | | JSONArray businessAuditUsers = null; |
| | | if (_obj instanceof JSONObject) { |
| | | businessAuditUsers = new JSONArray(); |
| | | businessAuditUsers.add(_obj); |
| | | } else { |
| | | businessAuditUsers = (JSONArray) _obj; |
| | | } |
| | | //JSONObject businessAuditUser = data.getJSONObject("businessAuditUser"); |
| | | for (int _auditUserIndex = 0; _auditUserIndex < businessAuditUsers.size(); _auditUserIndex++) { |
| | | JSONObject businessAuditUser = businessAuditUsers.getJSONObject(_auditUserIndex); |
| | | doBusinessAuditUser(business, businessAuditUser); |
| | | if (_obj instanceof JSONObject) { |
| | | dataFlowContext.addParamOut("auditUserId", businessAuditUser.getString("auditUserId")); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * business to instance 过程 |
| | | * |
| | | * @param dataFlowContext 数据对象 |
| | | * @param business 当前业务对象 |
| | | */ |
| | | @Override |
| | | protected void doBusinessToInstance(DataFlowContext dataFlowContext, Business business) { |
| | | |
| | | JSONObject data = business.getDatas(); |
| | | |
| | | Map info = new HashMap(); |
| | | info.put("bId", business.getbId()); |
| | | info.put("operate", StatusConstant.OPERATE_ADD); |
| | | |
| | | //审核人员信息 |
| | | List<Map> businessAuditUserInfos = auditUserServiceDaoImpl.getBusinessAuditUserInfo(info); |
| | | if (businessAuditUserInfos != null && businessAuditUserInfos.size() > 0) { |
| | | for (int _auditUserIndex = 0; _auditUserIndex < businessAuditUserInfos.size(); _auditUserIndex++) { |
| | | Map businessAuditUserInfo = businessAuditUserInfos.get(_auditUserIndex); |
| | | flushBusinessAuditUserInfo(businessAuditUserInfo, StatusConstant.STATUS_CD_VALID); |
| | | auditUserServiceDaoImpl.updateAuditUserInfoInstance(businessAuditUserInfo); |
| | | if (businessAuditUserInfo.size() == 1) { |
| | | dataFlowContext.addParamOut("auditUserId", businessAuditUserInfo.get("audit_user_id")); |
| | | } |
| | | } |
| | | } |
| | | |
| | | } |
| | | |
| | | /** |
| | | * 撤单 |
| | | * |
| | | * @param dataFlowContext 数据对象 |
| | | * @param business 当前业务对象 |
| | | */ |
| | | @Override |
| | | protected void doRecover(DataFlowContext dataFlowContext, Business business) { |
| | | |
| | | String bId = business.getbId(); |
| | | //Assert.hasLength(bId,"请求报文中没有包含 bId"); |
| | | Map info = new HashMap(); |
| | | info.put("bId", bId); |
| | | info.put("statusCd", StatusConstant.STATUS_CD_VALID); |
| | | Map delInfo = new HashMap(); |
| | | delInfo.put("bId", business.getbId()); |
| | | delInfo.put("operate", StatusConstant.OPERATE_DEL); |
| | | //审核人员信息 |
| | | List<Map> auditUserInfo = auditUserServiceDaoImpl.getAuditUserInfo(info); |
| | | if (auditUserInfo != null && auditUserInfo.size() > 0) { |
| | | |
| | | //审核人员信息 |
| | | List<Map> businessAuditUserInfos = auditUserServiceDaoImpl.getBusinessAuditUserInfo(delInfo); |
| | | //除非程序出错了,这里不会为空 |
| | | if (businessAuditUserInfos == null || businessAuditUserInfos.size() == 0) { |
| | | throw new ListenerExecuteException(ResponseConstant.RESULT_CODE_INNER_ERROR, "撤单失败(auditUser),程序内部异常,请检查! " + delInfo); |
| | | } |
| | | for (int _auditUserIndex = 0; _auditUserIndex < businessAuditUserInfos.size(); _auditUserIndex++) { |
| | | Map businessAuditUserInfo = businessAuditUserInfos.get(_auditUserIndex); |
| | | flushBusinessAuditUserInfo(businessAuditUserInfo, StatusConstant.STATUS_CD_VALID); |
| | | auditUserServiceDaoImpl.updateAuditUserInfoInstance(businessAuditUserInfo); |
| | | } |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 处理 businessAuditUser 节点 |
| | | * |
| | | * @param business 总的数据节点 |
| | | * @param businessAuditUser 审核人员节点 |
| | | */ |
| | | private void doBusinessAuditUser(Business business, JSONObject businessAuditUser) { |
| | | |
| | | Assert.jsonObjectHaveKey(businessAuditUser, "auditUserId", "businessAuditUser 节点下没有包含 auditUserId 节点"); |
| | | |
| | | if (businessAuditUser.getString("auditUserId").startsWith("-")) { |
| | | throw new ListenerExecuteException(ResponseConstant.RESULT_PARAM_ERROR, "auditUserId 错误,不能自动生成(必须已经存在的auditUserId)" + businessAuditUser); |
| | | } |
| | | //自动保存DEL |
| | | autoSaveDelBusinessAuditUser(business, businessAuditUser); |
| | | |
| | | businessAuditUser.put("bId", business.getbId()); |
| | | businessAuditUser.put("operate", StatusConstant.OPERATE_ADD); |
| | | //保存审核人员信息 |
| | | auditUserServiceDaoImpl.saveBusinessAuditUserInfo(businessAuditUser); |
| | | |
| | | } |
| | | |
| | | |
| | | public IAuditUserServiceDao getAuditUserServiceDaoImpl() { |
| | | return auditUserServiceDaoImpl; |
| | | } |
| | | |
| | | public void setAuditUserServiceDaoImpl(IAuditUserServiceDao auditUserServiceDaoImpl) { |
| | | this.auditUserServiceDaoImpl = auditUserServiceDaoImpl; |
| | | } |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | package com.java110.common.smo.impl; |
| | | |
| | | |
| | | import com.java110.common.dao.IAuditUserServiceDao; |
| | | import com.java110.core.base.smo.BaseServiceSMO; |
| | | import com.java110.core.smo.auditUser.IAuditUserInnerServiceSMO; |
| | | import com.java110.core.smo.user.IUserInnerServiceSMO; |
| | | import com.java110.dto.PageDto; |
| | | import com.java110.dto.UserDto; |
| | | import com.java110.dto.auditUser.AuditUserDto; |
| | | import com.java110.utils.util.BeanConvertUtil; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.RequestBody; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * @ClassName FloorInnerServiceSMOImpl |
| | | * @Description 审核人员内部服务实现类 |
| | | * @Author wuxw |
| | | * @Date 2019/4/24 9:20 |
| | | * @Version 1.0 |
| | | * add by wuxw 2019/4/24 |
| | | **/ |
| | | @RestController |
| | | public class AuditUserInnerServiceSMOImpl extends BaseServiceSMO implements IAuditUserInnerServiceSMO { |
| | | |
| | | @Autowired |
| | | private IAuditUserServiceDao auditUserServiceDaoImpl; |
| | | |
| | | @Autowired |
| | | private IUserInnerServiceSMO userInnerServiceSMOImpl; |
| | | |
| | | @Override |
| | | public List<AuditUserDto> queryAuditUsers(@RequestBody AuditUserDto auditUserDto) { |
| | | |
| | | //校验是否传了 分页信息 |
| | | |
| | | int page = auditUserDto.getPage(); |
| | | |
| | | if (page != PageDto.DEFAULT_PAGE) { |
| | | auditUserDto.setPage((page - 1) * auditUserDto.getRow()); |
| | | } |
| | | |
| | | List<AuditUserDto> auditUsers = BeanConvertUtil.covertBeanList(auditUserServiceDaoImpl.getAuditUserInfo(BeanConvertUtil.beanCovertMap(auditUserDto)), AuditUserDto.class); |
| | | |
| | | if (auditUsers == null || auditUsers.size() == 0) { |
| | | return auditUsers; |
| | | } |
| | | |
| | | String[] userIds = getUserIds(auditUsers); |
| | | //根据 userId 查询用户信息 |
| | | List<UserDto> users = userInnerServiceSMOImpl.getUserInfo(userIds); |
| | | |
| | | for (AuditUserDto auditUser : auditUsers) { |
| | | refreshAuditUser(auditUser, users); |
| | | } |
| | | return auditUsers; |
| | | } |
| | | |
| | | /** |
| | | * 从用户列表中查询用户,将用户中的信息 刷新到 floor对象中 |
| | | * |
| | | * @param auditUser 小区审核人员信息 |
| | | * @param users 用户列表 |
| | | */ |
| | | private void refreshAuditUser(AuditUserDto auditUser, List<UserDto> users) { |
| | | for (UserDto user : users) { |
| | | if (auditUser.getUserId().equals(user.getUserId())) { |
| | | BeanConvertUtil.covertBean(user, auditUser); |
| | | } |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 获取批量userId |
| | | * |
| | | * @param auditUsers 小区楼信息 |
| | | * @return 批量userIds 信息 |
| | | */ |
| | | private String[] getUserIds(List<AuditUserDto> auditUsers) { |
| | | List<String> userIds = new ArrayList<String>(); |
| | | for (AuditUserDto auditUser : auditUsers) { |
| | | userIds.add(auditUser.getUserId()); |
| | | } |
| | | |
| | | return userIds.toArray(new String[userIds.size()]); |
| | | } |
| | | |
| | | @Override |
| | | public int queryAuditUsersCount(@RequestBody AuditUserDto auditUserDto) { |
| | | return auditUserServiceDaoImpl.queryAuditUsersCount(BeanConvertUtil.beanCovertMap(auditUserDto)); |
| | | } |
| | | |
| | | public IAuditUserServiceDao getAuditUserServiceDaoImpl() { |
| | | return auditUserServiceDaoImpl; |
| | | } |
| | | |
| | | public void setAuditUserServiceDaoImpl(IAuditUserServiceDao auditUserServiceDaoImpl) { |
| | | this.auditUserServiceDaoImpl = auditUserServiceDaoImpl; |
| | | } |
| | | |
| | | public IUserInnerServiceSMO getUserInnerServiceSMOImpl() { |
| | | return userInnerServiceSMOImpl; |
| | | } |
| | | |
| | | public void setUserInnerServiceSMOImpl(IUserInnerServiceSMO userInnerServiceSMOImpl) { |
| | | this.userInnerServiceSMOImpl = userInnerServiceSMOImpl; |
| | | } |
| | | } |
| New file |
| | |
| | | |
| | | |
| | | **1\. 删除审核人员** |
| | | ###### 接口功能 |
| | | > API服务做删除审核人员时调用该接口 |
| | | |
| | | ###### URL |
| | | > [http://auditUser-service/auditUserApi/service](http://auditUser-service/auditUserApi/service) |
| | | |
| | | ###### 支持格式 |
| | | > JSON |
| | | |
| | | ###### HTTP请求方式 |
| | | > POST |
| | | |
| | | ###### 协议接口 |
| | | |父元素名称|参数名称|约束|类型|长度|描述|取值说明| |
| | | | :-: | :-: | :-: | :-: | :-: | :-: | :-:| |
| | | |-|orders|1|Object|-|订单节点|-| |
| | | |-|business|1|Array|-|业务节点|-| |
| | | |
| | | ###### orders |
| | | |父元素名称|参数名称|约束|类型|长度|描述|取值说明| |
| | | | :-: | :-: | :-: | :-: | :-: | :-: | :-: | |
| | | |-|orders|1|Object|-|订单节点|-| |
| | | |orders|appId|1|String|10|系统ID|由中心服务提供| |
| | | |orders|transactionId|1|String|30|交互流水|appId+'00'+YYYYMMDD+10位序列| |
| | | |orders|userId|1|String|30|用户ID|已有用户ID| |
| | | |orders|orderTypeCd|1|String|4|订单类型|查看订单类型说明| |
| | | |orders|requestTime|1|String|14|请求时间|YYYYMMDDhhmmss| |
| | | |orders|remark|1|String|200|备注|备注| |
| | | |orders|sign|?|String|64|签名|查看加密说明| |
| | | |orders|attrs|?|Array|-|订单属性|-| |
| | | |attrs|specCd|1|String|12|规格编码|由中心服务提供| |
| | | |attrs|value|1|String|50|属性值|-| |
| | | |orders|response|1|Object|-|返回结果节点|-| |
| | | |response|code|1|String|4|返回状态|查看状态说明| |
| | | |response|message|1|String|200|返回状态描述|-| |
| | | |
| | | ###### business |
| | | |父元素名称|参数名称|约束|类型|长度|描述|取值说明| |
| | | | :-: | :-: | :-: | :-: | :-: | :-: | :-: | |
| | | |-|business|?|Array|-|业务节点|-| |
| | | |business|businessTypeCd|1|String|12|业务类型编码|500100030002| |
| | | |business|datas|1|Object|-|数据节点|不同的服务下的节点不一样| |
| | | |datas|businessAuditUserInfo|1|Object|-|小区成员|小区成员| |
| | | |businessAuditUserInfo|auditUserId|1|String|30|-|-| |
| | | |
| | | |
| | | ###### 返回协议 |
| | | |
| | | 当http返回状态不为200 时请求处理失败 body内容为失败的原因 |
| | | |
| | | 当http返回状态为200时请求处理成功,body内容为返回内容, |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | ###### 举例 |
| | | > 地址:[http://auditUser-service/auditUserApi/service](http://auditUser-service/auditUserApi/service) |
| | | |
| | | ``` javascript |
| | | 请求头信息: |
| | | Content-Type:application/json |
| | | |
| | | 请求报文: |
| | | |
| | | { |
| | | "orders": { |
| | | "appId": "外系统ID,分配得到", |
| | | "transactionId": "100000000020180409224736000001", |
| | | "userId": "用户ID", |
| | | "orderTypeCd": "订单类型,查询,受理", |
| | | "requestTime": "20180409224736", |
| | | "remark": "备注", |
| | | "sign": "这个服务是否要求MD5签名", |
| | | "businessType":"I", |
| | | "attrs": [{ |
| | | "specCd": "配置的字段ID", |
| | | "value": "具体值" |
| | | }] |
| | | }, |
| | | "business": { |
| | | "businessTypeCd": "160200050001", |
| | | "bId":"1234567892", |
| | | "remark": "备注", |
| | | "datas": { |
| | | "businessAuditUserInfo": { |
| | | "auditUserId":"填写存在的值" |
| | | } |
| | | }, |
| | | "attrs": [{ |
| | | "specCd": "配置的字段ID", |
| | | "value": "具体值" |
| | | }] |
| | | } |
| | | } |
| | | |
| | | 返回报文: |
| | | { |
| | | "orderTypeCd": "D", |
| | | "response": { |
| | | "code": "0000", |
| | | "message": "成功" |
| | | }, |
| | | "responseTime": "20190418102004", |
| | | "bId": "202019041810750003", |
| | | "businessType": "B", |
| | | "transactionId": "3a5a411ec65a4c3f895935638aa1d2bc", |
| | | "dataFlowId": "44fde86d39ce46f4b4aab5f6b14f3947" |
| | | } |
| | | |
| | | ``` |
| New file |
| | |
| | | |
| | | |
| | | **1\. 保存审核人员** |
| | | ###### 接口功能 |
| | | > API服务做保存审核人员时调用该接口 |
| | | |
| | | ###### URL |
| | | > [http://auditUser-service/auditUserApi/service](http://auditUser-service/auditUserApi/service) |
| | | |
| | | ###### 支持格式 |
| | | > JSON |
| | | |
| | | ###### HTTP请求方式 |
| | | > POST |
| | | |
| | | ###### 协议接口 |
| | | |父元素名称|参数名称|约束|类型|长度|描述|取值说明| |
| | | | :-: | :-: | :-: | :-: | :-: | :-: | :-:| |
| | | |-|orders|1|Object|-|订单节点|-| |
| | | |-|business|1|Array|-|业务节点|-| |
| | | |
| | | ###### orders |
| | | |父元素名称|参数名称|约束|类型|长度|描述|取值说明| |
| | | | :-: | :-: | :-: | :-: | :-: | :-: | :-: | |
| | | |-|orders|1|Object|-|订单节点|-| |
| | | |orders|appId|1|String|10|系统ID|由中心服务提供| |
| | | |orders|transactionId|1|String|30|交互流水|appId+'00'+YYYYMMDD+10位序列| |
| | | |orders|userId|1|String|30|用户ID|已有用户ID| |
| | | |orders|orderTypeCd|1|String|4|订单类型|查看订单类型说明| |
| | | |orders|requestTime|1|String|14|请求时间|YYYYMMDDhhmmss| |
| | | |orders|remark|1|String|200|备注|备注| |
| | | |orders|sign|?|String|64|签名|查看加密说明| |
| | | |orders|attrs|?|Array|-|订单属性|-| |
| | | |attrs|specCd|1|String|12|规格编码|由中心服务提供| |
| | | |attrs|value|1|String|50|属性值|-| |
| | | |orders|response|1|Object|-|返回结果节点|-| |
| | | |response|code|1|String|4|返回状态|查看状态说明| |
| | | |response|message|1|String|200|返回状态描述|-| |
| | | |
| | | ###### business |
| | | |父元素名称|参数名称|约束|类型|长度|描述|取值说明| |
| | | | :-: | :-: | :-: | :-: | :-: | :-: | :-: | |
| | | |-|business|?|Array|-|业务节点|-| |
| | | |business|businessTypeCd|1|String|12|业务类型编码|500100030002| |
| | | |business|datas|1|Object|-|数据节点|不同的服务下的节点不一样| |
| | | |datas|businessAuditUserInfo|1|Object|-|小区成员|小区成员| |
| | | |businessAuditUserInfo|objCode|1|String|30|-|-| |
| | | |businessAuditUserInfo|auditUserId|1|String|30|-|-| |
| | | |businessAuditUserInfo|storeId|1|String|30|-|-| |
| | | |businessAuditUserInfo|userName|1|String|30|-|-| |
| | | |businessAuditUserInfo|userId|1|String|30|-|-| |
| | | |businessAuditUserInfo|auditLink|1|String|30|-|-| |
| | | |
| | | |
| | | ###### 返回协议 |
| | | |
| | | 当http返回状态不为200 时请求处理失败 body内容为失败的原因 |
| | | |
| | | 当http返回状态为200时请求处理成功,body内容为返回内容, |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | ###### 举例 |
| | | > 地址:[http://auditUser-service/auditUserApi/service](http://auditUser-service/auditUserApi/service) |
| | | |
| | | ``` javascript |
| | | 请求头信息: |
| | | Content-Type:application/json |
| | | |
| | | 请求报文: |
| | | |
| | | { |
| | | "orders": { |
| | | "appId": "外系统ID,分配得到", |
| | | "transactionId": "100000000020180409224736000001", |
| | | "userId": "用户ID", |
| | | "orderTypeCd": "订单类型,查询,受理", |
| | | "requestTime": "20180409224736", |
| | | "remark": "备注", |
| | | "sign": "这个服务是否要求MD5签名", |
| | | "businessType":"I", |
| | | "attrs": [{ |
| | | "specCd": "配置的字段ID", |
| | | "value": "具体值" |
| | | }] |
| | | }, |
| | | "business": { |
| | | "businessTypeCd": "160200030001", |
| | | "bId":"1234567892", |
| | | "remark": "备注", |
| | | "datas": { |
| | | "businessAuditUserInfo": { |
| | | "objCode":"填写具体值", |
| | | "auditUserId":"填写具体值", |
| | | "storeId":"填写具体值", |
| | | "userName":"填写具体值", |
| | | "userId":"填写具体值", |
| | | "auditLink":"填写具体值" |
| | | } |
| | | }, |
| | | "attrs": [{ |
| | | "specCd": "配置的字段ID", |
| | | "value": "具体值" |
| | | }] |
| | | } |
| | | } |
| | | |
| | | 返回报文: |
| | | { |
| | | "orderTypeCd": "D", |
| | | "response": { |
| | | "code": "0000", |
| | | "message": "成功" |
| | | }, |
| | | "responseTime": "20190418102004", |
| | | "bId": "202019041810750003", |
| | | "businessType": "B", |
| | | "transactionId": "3a5a411ec65a4c3f895935638aa1d2bc", |
| | | "dataFlowId": "44fde86d39ce46f4b4aab5f6b14f3947" |
| | | } |
| | | |
| | | ``` |
| New file |
| | |
| | | |
| | | |
| | | **1\. 修改审核人员** |
| | | ###### 接口功能 |
| | | > API服务做修改审核人员时调用该接口 |
| | | |
| | | ###### URL |
| | | > [http://auditUser-service/auditUserApi/service](http://auditUser-service/auditUserApi/service) |
| | | |
| | | ###### 支持格式 |
| | | > JSON |
| | | |
| | | ###### HTTP请求方式 |
| | | > POST |
| | | |
| | | ###### 协议接口 |
| | | |父元素名称|参数名称|约束|类型|长度|描述|取值说明| |
| | | | :-: | :-: | :-: | :-: | :-: | :-: | :-:| |
| | | |-|orders|1|Object|-|订单节点|-| |
| | | |-|business|1|Array|-|业务节点|-| |
| | | |
| | | ###### orders |
| | | |父元素名称|参数名称|约束|类型|长度|描述|取值说明| |
| | | | :-: | :-: | :-: | :-: | :-: | :-: | :-: | |
| | | |-|orders|1|Object|-|订单节点|-| |
| | | |orders|appId|1|String|10|系统ID|由中心服务提供| |
| | | |orders|transactionId|1|String|30|交互流水|appId+'00'+YYYYMMDD+10位序列| |
| | | |orders|userId|1|String|30|用户ID|已有用户ID| |
| | | |orders|orderTypeCd|1|String|4|订单类型|查看订单类型说明| |
| | | |orders|requestTime|1|String|14|请求时间|YYYYMMDDhhmmss| |
| | | |orders|remark|1|String|200|备注|备注| |
| | | |orders|sign|?|String|64|签名|查看加密说明| |
| | | |orders|attrs|?|Array|-|订单属性|-| |
| | | |attrs|specCd|1|String|12|规格编码|由中心服务提供| |
| | | |attrs|value|1|String|50|属性值|-| |
| | | |orders|response|1|Object|-|返回结果节点|-| |
| | | |response|code|1|String|4|返回状态|查看状态说明| |
| | | |response|message|1|String|200|返回状态描述|-| |
| | | |
| | | ###### business |
| | | |父元素名称|参数名称|约束|类型|长度|描述|取值说明| |
| | | | :-: | :-: | :-: | :-: | :-: | :-: | :-: | |
| | | |-|business|?|Array|-|业务节点|-| |
| | | |business|businessTypeCd|1|String|12|业务类型编码|500100030002| |
| | | |business|datas|1|Object|-|数据节点|不同的服务下的节点不一样| |
| | | |datas|businessAuditUserInfo|1|Object|-|小区成员|小区成员| |
| | | |businessAuditUserInfo|objCode|1|String|30|-|-| |
| | | |businessAuditUserInfo|auditUserId|1|String|30|-|-| |
| | | |businessAuditUserInfo|storeId|1|String|30|-|-| |
| | | |businessAuditUserInfo|userName|1|String|30|-|-| |
| | | |businessAuditUserInfo|userId|1|String|30|-|-| |
| | | |businessAuditUserInfo|auditLink|1|String|30|-|-| |
| | | |
| | | |
| | | ###### 返回协议 |
| | | |
| | | 当http返回状态不为200 时请求处理失败 body内容为失败的原因 |
| | | |
| | | 当http返回状态为200时请求处理成功,body内容为返回内容, |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | ###### 举例 |
| | | > 地址:[http://auditUser-service/auditUserApi/service](http://auditUser-service/auditUserApi/service) |
| | | |
| | | ``` javascript |
| | | 请求头信息: |
| | | Content-Type:application/json |
| | | |
| | | 请求报文: |
| | | |
| | | { |
| | | "orders": { |
| | | "appId": "外系统ID,分配得到", |
| | | "transactionId": "100000000020180409224736000001", |
| | | "userId": "用户ID", |
| | | "orderTypeCd": "订单类型,查询,受理", |
| | | "requestTime": "20180409224736", |
| | | "remark": "备注", |
| | | "sign": "这个服务是否要求MD5签名", |
| | | "businessType":"I", |
| | | "attrs": [{ |
| | | "specCd": "配置的字段ID", |
| | | "value": "具体值" |
| | | }] |
| | | }, |
| | | "business": { |
| | | "businessTypeCd": "160200040001", |
| | | "bId":"1234567892", |
| | | "remark": "备注", |
| | | "datas": { |
| | | "businessAuditUserInfo": { |
| | | "objCode":"填写具体值", |
| | | "auditUserId":"填写具体值", |
| | | "storeId":"填写具体值", |
| | | "userName":"填写具体值", |
| | | "userId":"填写具体值", |
| | | "auditLink":"填写具体值" |
| | | } |
| | | }, |
| | | "attrs": [{ |
| | | "specCd": "配置的字段ID", |
| | | "value": "具体值" |
| | | }] |
| | | } |
| | | } |
| | | |
| | | 返回报文: |
| | | { |
| | | "orderTypeCd": "D", |
| | | "response": { |
| | | "code": "0000", |
| | | "message": "成功" |
| | | }, |
| | | "responseTime": "20190418102004", |
| | | "bId": "202019041810750003", |
| | | "businessType": "B", |
| | | "transactionId": "3a5a411ec65a4c3f895935638aa1d2bc", |
| | | "dataFlowId": "44fde86d39ce46f4b4aab5f6b14f3947" |
| | | } |
| | | |
| | | ``` |
| New file |
| | |
| | | package com.java110.dto.auditUser; |
| | | |
| | | import com.java110.dto.PageDto; |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * @ClassName FloorDto |
| | | * @Description 审核人员数据层封装 |
| | | * @Author wuxw |
| | | * @Date 2019/4/24 8:52 |
| | | * @Version 1.0 |
| | | * add by wuxw 2019/4/24 |
| | | **/ |
| | | public class AuditUserDto extends PageDto implements Serializable { |
| | | |
| | | private String objCode; |
| | | private String auditUserId; |
| | | private String storeId; |
| | | private String userName; |
| | | private String userId; |
| | | private String auditLink; |
| | | |
| | | |
| | | private Date createTime; |
| | | |
| | | private String statusCd = "0"; |
| | | |
| | | |
| | | public String getObjCode() { |
| | | return objCode; |
| | | } |
| | | |
| | | public void setObjCode(String objCode) { |
| | | this.objCode = objCode; |
| | | } |
| | | |
| | | public String getAuditUserId() { |
| | | return auditUserId; |
| | | } |
| | | |
| | | public void setAuditUserId(String auditUserId) { |
| | | this.auditUserId = auditUserId; |
| | | } |
| | | |
| | | public String getStoreId() { |
| | | return storeId; |
| | | } |
| | | |
| | | public void setStoreId(String storeId) { |
| | | this.storeId = storeId; |
| | | } |
| | | |
| | | public String getUserName() { |
| | | return userName; |
| | | } |
| | | |
| | | public void setUserName(String userName) { |
| | | this.userName = userName; |
| | | } |
| | | |
| | | public String getUserId() { |
| | | return userId; |
| | | } |
| | | |
| | | public void setUserId(String userId) { |
| | | this.userId = userId; |
| | | } |
| | | |
| | | public String getAuditLink() { |
| | | return auditLink; |
| | | } |
| | | |
| | | public void setAuditLink(String auditLink) { |
| | | this.auditLink = auditLink; |
| | | } |
| | | |
| | | |
| | | public Date getCreateTime() { |
| | | return createTime; |
| | | } |
| | | |
| | | public void setCreateTime(Date createTime) { |
| | | this.createTime = createTime; |
| | | } |
| | | |
| | | public String getStatusCd() { |
| | | return statusCd; |
| | | } |
| | | |
| | | public void setStatusCd(String statusCd) { |
| | | this.statusCd = statusCd; |
| | | } |
| | | } |
| | |
| | | */ |
| | | public class AuditUser implements Serializable { |
| | | |
| | | private String auditUserId; |
| | | |
| | | // 审核用户ID |
| | | private String userId; |
| | | |
| | |
| | | public void setUserName(String userName) { |
| | | this.userName = userName; |
| | | } |
| | | |
| | | public String getAuditUserId() { |
| | | return auditUserId; |
| | | } |
| | | |
| | | public void setAuditUserId(String auditUserId) { |
| | | this.auditUserId = auditUserId; |
| | | } |
| | | } |
| New file |
| | |
| | | package com.java110; |
| | | |
| | | |
| | | import com.java110.code.*; |
| | | |
| | | import java.util.HashMap; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * Hello world! |
| | | */ |
| | | public class AuditUserGeneratorApplication { |
| | | |
| | | protected AuditUserGeneratorApplication() { |
| | | // prevents calls from subclass |
| | | throw new UnsupportedOperationException(); |
| | | } |
| | | |
| | | /** |
| | | * 代码生成器 入口方法 |
| | | * 此处生成的mapper文件包含过程表和实例表的sql,所以要求两张表的特殊字段也要写上 |
| | | * BusinessTypeCd |
| | | * @param args 参数 |
| | | */ |
| | | public static void main(String[] args) { |
| | | Data data = new Data(); |
| | | data.setId("auditUserId"); |
| | | data.setName("auditUser"); |
| | | data.setDesc("审核人员"); |
| | | data.setShareParam("storeId"); |
| | | data.setShareColumn("store_id"); |
| | | data.setNewBusinessTypeCd("BUSINESS_TYPE_SAVE_AUDIT_USER"); |
| | | data.setUpdateBusinessTypeCd("BUSINESS_TYPE_UPDATE_AUDIT_USER"); |
| | | data.setDeleteBusinessTypeCd("BUSINESS_TYPE_DELETE_AUDIT_USER"); |
| | | data.setNewBusinessTypeCdValue("160200030001"); |
| | | data.setUpdateBusinessTypeCdValue("160200040001"); |
| | | data.setDeleteBusinessTypeCdValue("160200050001"); |
| | | data.setBusinessTableName("business_audit_user"); |
| | | data.setTableName("audit_user"); |
| | | Map<String, String> param = new HashMap<String, String>(); |
| | | param.put("auditUserId", "audit_user_id"); //map的key为你自定义的字段名就是驼峰命名法的那个,value为数据库表的字段名 |
| | | param.put("storeId", "store_id"); |
| | | param.put("userId", "user_id"); |
| | | param.put("userName", "user_name"); |
| | | param.put("auditLink", "audit_link"); |
| | | param.put("objCode", "obj_code"); |
| | | param.put("statusCd", "status_cd"); |
| | | param.put("operate", "operate"); |
| | | param.put("bId", "b_id"); |
| | | data.setParams(param); |
| | | GeneratorSaveInfoListener generatorSaveInfoListener = new GeneratorSaveInfoListener(); |
| | | generatorSaveInfoListener.generator(data); |
| | | |
| | | GeneratorAbstractBussiness generatorAbstractBussiness = new GeneratorAbstractBussiness(); |
| | | generatorAbstractBussiness.generator(data); |
| | | |
| | | GeneratorIServiceDaoListener generatorIServiceDaoListener = new GeneratorIServiceDaoListener(); |
| | | generatorIServiceDaoListener.generator(data); |
| | | |
| | | GeneratorServiceDaoImplListener generatorServiceDaoImplListener = new GeneratorServiceDaoImplListener(); |
| | | generatorServiceDaoImplListener.generator(data); |
| | | |
| | | GeneratorServiceDaoImplMapperListener generatorServiceDaoImplMapperListener = null; |
| | | generatorServiceDaoImplMapperListener = new GeneratorServiceDaoImplMapperListener(); |
| | | generatorServiceDaoImplMapperListener.generator(data); |
| | | |
| | | GeneratorUpdateInfoListener generatorUpdateInfoListener = new GeneratorUpdateInfoListener(); |
| | | generatorUpdateInfoListener.generator(data); |
| | | |
| | | GeneratorDeleteInfoListener generatorDeleteInfoListener = new GeneratorDeleteInfoListener(); |
| | | generatorDeleteInfoListener.generator(data); |
| | | |
| | | GeneratorInnerServiceSMOImpl generatorInnerServiceSMOImpl = new GeneratorInnerServiceSMOImpl(); |
| | | generatorInnerServiceSMOImpl.generator(data); |
| | | |
| | | GeneratorDtoBean generatorDtoBean = new GeneratorDtoBean(); |
| | | generatorDtoBean.generator(data); |
| | | |
| | | GeneratorIInnerServiceSMO generatorIInnerServiceSMO = new GeneratorIInnerServiceSMO(); |
| | | generatorIInnerServiceSMO.generator(data); |
| | | } |
| | | } |
| New file |
| | |
| | | { |
| | | "templateName":"物品管理", |
| | | "templateCode":"resourceStore", |
| | | "templateKey":"resId", |
| | | "templateKeyName":"物品ID", |
| | | "searchCode": "resName", |
| | | "searchName": "物品名称", |
| | | "conditions": [ |
| | | |
| | | { |
| | | "name": "物品ID", |
| | | "inputType": "input", |
| | | "code": "resId", |
| | | "whereCondition": "equal" |
| | | }, |
| | | { |
| | | "name": "物品名称", |
| | | "inputType": "input", |
| | | "code": "resName", |
| | | "whereCondition": "equal" |
| | | }, |
| | | { |
| | | "name": "物品编码", |
| | | "inputType": "input", |
| | | "code": "resCode", |
| | | "whereCondition": "equal" |
| | | } |
| | | ], |
| | | "columns":[ |
| | | { |
| | | "code":"resName", |
| | | "cnCode":"物品名称", |
| | | "desc":"必填,请填写物品名称", |
| | | "required":true, |
| | | "hasDefaultValue":false, |
| | | "inputType":"input", |
| | | "limit":"maxin", |
| | | "limitParam":"2,100", |
| | | "limitErrInfo":"物品名称长度为2至100", |
| | | "show": true |
| | | }, |
| | | { |
| | | "code":"resCode", |
| | | "cnCode":"物品编码", |
| | | "desc":"必填,请填写物品编码", |
| | | "required":true, |
| | | "hasDefaultValue":false, |
| | | "inputType":"input", |
| | | "limit":"maxin", |
| | | "limitParam":"2,50", |
| | | "limitErrInfo":"物品编码必须在2至50字符之间", |
| | | "show": true |
| | | }, |
| | | { |
| | | "code":"price", |
| | | "cnCode":"物品价格", |
| | | "desc":"必填,请填写物品价格", |
| | | "required":true, |
| | | "hasDefaultValue":false, |
| | | "inputType":"input", |
| | | "limit":"money", |
| | | "limitParam":"", |
| | | "limitErrInfo":"物品价格格式错误", |
| | | "show": true |
| | | }, |
| | | { |
| | | "code":"stock", |
| | | "cnCode":"物品库存", |
| | | "desc":"必填,请填写物品库存", |
| | | "required":true, |
| | | "hasDefaultValue":false, |
| | | "inputType":"input", |
| | | "limit":"num", |
| | | "limitParam":"", |
| | | "limitErrInfo":"物品库存不是有效数字", |
| | | "show": true |
| | | }, |
| | | { |
| | | "code":"description", |
| | | "cnCode":"描述", |
| | | "desc":"必填,请填写描述", |
| | | "required":true, |
| | | "hasDefaultValue":false, |
| | | "inputType":"textarea", |
| | | "limit":"maxLength", |
| | | "limitParam":"200", |
| | | "limitErrInfo":"描述不能为空", |
| | | "show": false |
| | | } |
| | | ] |
| | | } |
| | |
| | | { |
| | | "templateName":"物品管理", |
| | | "templateName":"审核人员", |
| | | "templateCode":"resourceStore", |
| | | "templateKey":"resId", |
| | | "templateKeyName":"物品ID", |
| | |
| | | public static final String CODE_PREFIX_orgId = "84"; |
| | | public static final String CODE_PREFIX_relId = "84"; |
| | | public static final String CODE_PREFIX_resId = "85"; |
| | | public static final String CODE_PREFIX_auditUserId = "86"; |
| | | |
| | | |
| | | |
| New file |
| | |
| | | package com.java110.core.smo.auditUser; |
| | | |
| | | import com.java110.core.feign.FeignConfiguration; |
| | | import com.java110.dto.auditUser.AuditUserDto; |
| | | import org.springframework.cloud.openfeign.FeignClient; |
| | | import org.springframework.web.bind.annotation.RequestBody; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RequestMethod; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * @ClassName IAuditUserInnerServiceSMO |
| | | * @Description 审核人员接口类 |
| | | * @Author wuxw |
| | | * @Date 2019/4/24 9:04 |
| | | * @Version 1.0 |
| | | * add by wuxw 2019/4/24 |
| | | **/ |
| | | @FeignClient(name = "common-service", configuration = {FeignConfiguration.class}) |
| | | @RequestMapping("/auditUserApi") |
| | | public interface IAuditUserInnerServiceSMO { |
| | | |
| | | /** |
| | | * <p>查询小区楼信息</p> |
| | | * |
| | | * @param auditUserDto 数据对象分享 |
| | | * @return AuditUserDto 对象数据 |
| | | */ |
| | | @RequestMapping(value = "/queryAuditUsers", method = RequestMethod.POST) |
| | | List<AuditUserDto> queryAuditUsers(@RequestBody AuditUserDto auditUserDto); |
| | | |
| | | /** |
| | | * 查询<p>小区楼</p>总记录数 |
| | | * |
| | | * @param auditUserDto 数据对象分享 |
| | | * @return 小区下的小区楼记录数 |
| | | */ |
| | | @RequestMapping(value = "/queryAuditUsersCount", method = RequestMethod.POST) |
| | | int queryAuditUsersCount(@RequestBody AuditUserDto auditUserDto); |
| | | } |
| | |
| | | import org.springframework.web.bind.annotation.RequestBody; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RequestMethod; |
| | | import org.springframework.web.bind.annotation.ResponseBody; |
| | | |
| | | import java.util.List; |
| | | |
| New file |
| | |
| | | create table audit_user( |
| | | `audit_user_id` varchar(30) NOT NULL COMMENT '审核ID', |
| | | `b_id` varchar(30) NOT NULL COMMENT '业务Id', |
| | | `store_id` varchar(30) NOT NULL COMMENT '商户ID,用来做分区', |
| | | `user_id` varchar(100) NOT NULL COMMENT '审核用户ID', |
| | | `user_name` varchar(100) NOT NULL COMMENT '审核用户名称', |
| | | `audit_link` varchar(64) NOT NULL COMMENT '审核环节,建t_dict表 如部门经理审核 , 财务审核 ,采购人员采购', |
| | | `obj_code` varchar(64) NOT NULL COMMENT '流程对象编码,如采购申请 resource_enter', |
| | | `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| | | `status_cd` varchar(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考t_dict表,0, 在用 1失效', |
| | | KEY `idx_audit_user_id` (`audit_user_id`) |
| | | ); |
| | | |
| | | CREATE TABLE `business_audit_user` ( |
| | | `audit_user_id` varchar(30) NOT NULL COMMENT '审核ID', |
| | | `b_id` varchar(30) NOT NULL COMMENT '业务Id', |
| | | `store_id` varchar(30) NOT NULL COMMENT '商户ID,用来做分区', |
| | | `user_id` varchar(100) NOT NULL COMMENT '审核用户ID', |
| | | `user_name` varchar(100) NOT NULL COMMENT '审核用户名称', |
| | | `audit_link` varchar(64) NOT NULL COMMENT '审核环节,建t_dict表 如部门经理审核 , 财务审核 ,采购人员采购', |
| | | `obj_code` varchar(64) NOT NULL COMMENT '流程对象编码,如采购申请 resource_enter', |
| | | `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', |
| | | `operate` varchar(4) NOT NULL COMMENT '数据状态,添加ADD,修改MOD 删除DEL' |
| | | ); |
| New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8" ?> |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="auditUserServiceDaoImpl"> |
| | | |
| | | <!-- 保存审核人员信息 add by wuxw 2018-07-03 --> |
| | | <insert id="saveBusinessAuditUserInfo" parameterType="Map"> |
| | | insert into business_audit_user( |
| | | obj_code,audit_user_id,operate,store_id,user_name,b_id,user_id,audit_link |
| | | ) values ( |
| | | #{objCode},#{auditUserId},#{operate},#{storeId},#{userName},#{bId},#{userId},#{auditLink} |
| | | ) |
| | | </insert> |
| | | |
| | | |
| | | <!-- 查询审核人员信息(Business) add by wuxw 2018-07-03 --> |
| | | <select id="getBusinessAuditUserInfo" parameterType="Map" resultType="Map"> |
| | | select t.obj_code,t.obj_code objCode,t.audit_user_id,t.audit_user_id auditUserId,t.operate,t.store_id,t.store_id storeId,t.user_name,t.user_name userName,t.b_id,t.b_id bId,t.user_id,t.user_id userId,t.audit_link,t.audit_link auditLink |
| | | from business_audit_user t |
| | | where 1 =1 |
| | | <if test="objCode !=null and objCode != ''"> |
| | | and t.obj_code= #{objCode} |
| | | </if> |
| | | <if test="auditUserId !=null and auditUserId != ''"> |
| | | and t.audit_user_id= #{auditUserId} |
| | | </if> |
| | | <if test="operate !=null and operate != ''"> |
| | | and t.operate= #{operate} |
| | | </if> |
| | | <if test="storeId !=null and storeId != ''"> |
| | | and t.store_id= #{storeId} |
| | | </if> |
| | | <if test="userName !=null and userName != ''"> |
| | | and t.user_name= #{userName} |
| | | </if> |
| | | <if test="bId !=null and bId != ''"> |
| | | and t.b_id= #{bId} |
| | | </if> |
| | | <if test="userId !=null and userId != ''"> |
| | | and t.user_id= #{userId} |
| | | </if> |
| | | <if test="auditLink !=null and auditLink != ''"> |
| | | and t.audit_link= #{auditLink} |
| | | </if> |
| | | |
| | | </select> |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | <!-- 保存审核人员信息至 instance表中 add by wuxw 2018-07-03 --> |
| | | <insert id="saveAuditUserInfoInstance" parameterType="Map"> |
| | | insert into audit_user( |
| | | obj_code,audit_user_id,status_cd,store_id,user_name,b_id,user_id,audit_link |
| | | ) select t.obj_code,t.audit_user_id,'0',t.store_id,t.user_name,t.b_id,t.user_id,t.audit_link from business_audit_user t where 1=1 |
| | | <if test="objCode !=null and objCode != ''"> |
| | | and t.obj_code= #{objCode} |
| | | </if> |
| | | <if test="auditUserId !=null and auditUserId != ''"> |
| | | and t.audit_user_id= #{auditUserId} |
| | | </if> |
| | | and t.operate= 'ADD' |
| | | <if test="storeId !=null and storeId != ''"> |
| | | and t.store_id= #{storeId} |
| | | </if> |
| | | <if test="userName !=null and userName != ''"> |
| | | and t.user_name= #{userName} |
| | | </if> |
| | | <if test="bId !=null and bId != ''"> |
| | | and t.b_id= #{bId} |
| | | </if> |
| | | <if test="userId !=null and userId != ''"> |
| | | and t.user_id= #{userId} |
| | | </if> |
| | | <if test="auditLink !=null and auditLink != ''"> |
| | | and t.audit_link= #{auditLink} |
| | | </if> |
| | | |
| | | </insert> |
| | | |
| | | |
| | | |
| | | <!-- 查询审核人员信息 add by wuxw 2018-07-03 --> |
| | | <select id="getAuditUserInfo" parameterType="Map" resultType="Map"> |
| | | select t.obj_code,t.obj_code objCode,t.audit_user_id,t.audit_user_id auditUserId,t.status_cd,t.status_cd statusCd,t.store_id,t.store_id storeId,t.user_name,t.user_name userName,t.b_id,t.b_id bId,t.user_id,t.user_id userId,t.audit_link,t.audit_link auditLink |
| | | from audit_user t |
| | | where 1 =1 |
| | | <if test="objCode !=null and objCode != ''"> |
| | | and t.obj_code= #{objCode} |
| | | </if> |
| | | <if test="auditUserId !=null and auditUserId != ''"> |
| | | and t.audit_user_id= #{auditUserId} |
| | | </if> |
| | | <if test="statusCd !=null and statusCd != ''"> |
| | | and t.status_cd= #{statusCd} |
| | | </if> |
| | | <if test="storeId !=null and storeId != ''"> |
| | | and t.store_id= #{storeId} |
| | | </if> |
| | | <if test="userName !=null and userName != ''"> |
| | | and t.user_name= #{userName} |
| | | </if> |
| | | <if test="bId !=null and bId != ''"> |
| | | and t.b_id= #{bId} |
| | | </if> |
| | | <if test="userId !=null and userId != ''"> |
| | | and t.user_id= #{userId} |
| | | </if> |
| | | <if test="auditLink !=null and auditLink != ''"> |
| | | and t.audit_link= #{auditLink} |
| | | </if> |
| | | <if test="page != -1 and page != null "> |
| | | limit #{page}, #{row} |
| | | </if> |
| | | |
| | | </select> |
| | | |
| | | |
| | | |
| | | |
| | | <!-- 修改审核人员信息 add by wuxw 2018-07-03 --> |
| | | <update id="updateAuditUserInfoInstance" parameterType="Map"> |
| | | update audit_user t set t.status_cd = #{statusCd} |
| | | <if test="newBId != null and newBId != ''"> |
| | | ,t.b_id = #{newBId} |
| | | </if> |
| | | <if test="objCode !=null and objCode != ''"> |
| | | , t.obj_code= #{objCode} |
| | | </if> |
| | | <if test="storeId !=null and storeId != ''"> |
| | | , t.store_id= #{storeId} |
| | | </if> |
| | | <if test="userName !=null and userName != ''"> |
| | | , t.user_name= #{userName} |
| | | </if> |
| | | <if test="userId !=null and userId != ''"> |
| | | , t.user_id= #{userId} |
| | | </if> |
| | | <if test="auditLink !=null and auditLink != ''"> |
| | | , t.audit_link= #{auditLink} |
| | | </if> |
| | | where 1=1 <if test="auditUserId !=null and auditUserId != ''"> |
| | | and t.audit_user_id= #{auditUserId} |
| | | </if> |
| | | <if test="bId !=null and bId != ''"> |
| | | and t.b_id= #{bId} |
| | | </if> |
| | | |
| | | </update> |
| | | |
| | | <!-- 查询审核人员数量 add by wuxw 2018-07-03 --> |
| | | <select id="queryAuditUsersCount" parameterType="Map" resultType="Map"> |
| | | select count(1) count |
| | | from audit_user t |
| | | where 1 =1 |
| | | <if test="objCode !=null and objCode != ''"> |
| | | and t.obj_code= #{objCode} |
| | | </if> |
| | | <if test="auditUserId !=null and auditUserId != ''"> |
| | | and t.audit_user_id= #{auditUserId} |
| | | </if> |
| | | <if test="statusCd !=null and statusCd != ''"> |
| | | and t.status_cd= #{statusCd} |
| | | </if> |
| | | <if test="storeId !=null and storeId != ''"> |
| | | and t.store_id= #{storeId} |
| | | </if> |
| | | <if test="userName !=null and userName != ''"> |
| | | and t.user_name= #{userName} |
| | | </if> |
| | | <if test="bId !=null and bId != ''"> |
| | | and t.b_id= #{bId} |
| | | </if> |
| | | <if test="userId !=null and userId != ''"> |
| | | and t.user_id= #{userId} |
| | | </if> |
| | | <if test="auditLink !=null and auditLink != ''"> |
| | | and t.audit_link= #{auditLink} |
| | | </if> |
| | | |
| | | |
| | | </select> |
| | | |
| | | </mapper> |
| | |
| | | public static final String BUSINESS_TYPE_DELETE_RESOURCE_STORE ="150200050001"; |
| | | |
| | | |
| | | /** |
| | | * 保存 审核用户 |
| | | * 14开头 3保存 |
| | | */ |
| | | public static final String BUSINESS_TYPE_SAVE_AUDIT_USER="160200030001"; |
| | | |
| | | /** |
| | | * 修改 审核用户 |
| | | */ |
| | | public static final String BUSINESS_TYPE_UPDATE_AUDIT_USER="160200040001"; |
| | | /** |
| | | * 删除 审核用户 |
| | | */ |
| | | public static final String BUSINESS_TYPE_DELETE_AUDIT_USER ="160200050001"; |
| | | |
| | | |
| | | } |