From dba54bf8c8f9299d61c05bf3a941708ea399c998 Mon Sep 17 00:00:00 2001
From: ZhuDongming <773644075@qq.com>
Date: Sun, 26 Apr 2020 15:20:22 +0800
Subject: [PATCH] update excel多个工作表导出
---
src/main/java/com/moral/service/impl/AccountServiceImpl.java | 354 ++++++++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 291 insertions(+), 63 deletions(-)
diff --git a/src/main/java/com/moral/service/impl/AccountServiceImpl.java b/src/main/java/com/moral/service/impl/AccountServiceImpl.java
index 4993b3c..fe05269 100644
--- a/src/main/java/com/moral/service/impl/AccountServiceImpl.java
+++ b/src/main/java/com/moral/service/impl/AccountServiceImpl.java
@@ -1,93 +1,321 @@
package com.moral.service.impl;
-import static com.moral.common.bean.Constants.IS_DELETE_FALSE;
-import static com.moral.common.bean.Constants.IS_DELETE_TRUE;
-import static com.moral.common.util.Crypto.md5;
-import static com.moral.common.util.ResourceUtil.getValue;
-import static org.apache.commons.lang3.StringUtils.isNumeric;
-import static org.springframework.util.ObjectUtils.isEmpty;
-
+import java.util.ArrayList;
+import java.util.Date;
import java.util.HashMap;
+import java.util.HashSet;
+import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
+import java.util.Optional;
import java.util.Set;
import javax.annotation.Resource;
+import org.apache.commons.lang3.StringUtils;
+import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;
import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+import org.springframework.util.CollectionUtils;
+import org.springframework.util.ObjectUtils;
+import com.github.pagehelper.PageHelper;
+import com.moral.common.bean.Constants;
+import com.moral.common.bean.PageBean;
import com.moral.common.exception.BusinessException;
+import com.moral.common.util.ResourceUtil;
+import com.moral.common.util.ValidateUtil;
import com.moral.entity.Account;
+import com.moral.entity.Menu;
+import com.moral.entity.Organization;
+import com.moral.entity.Role;
import com.moral.mapper.AccountMapper;
+import com.moral.mapper.OrganizationMapper;
import com.moral.service.AccountService;
import com.moral.service.OrganizationService;
import tk.mybatis.mapper.entity.Example;
+import tk.mybatis.mapper.entity.Example.Criteria;
+
+import static com.moral.common.bean.Constants.IS_DELETE_FALSE;
+import static com.moral.common.bean.Constants.IS_DELETE_TRUE;
+import static com.moral.common.util.ResourceUtil.getValue;
+import static org.apache.commons.lang3.StringUtils.isNumeric;
+import static org.springframework.util.ObjectUtils.isEmpty;
@Service
public class AccountServiceImpl implements AccountService {
+ @Resource
+ private BCryptPasswordEncoder encoder;
- @Resource
- private AccountMapper accountMapper;
+ @Resource
+ private AccountMapper accountMapper;
- @Resource
- private OrganizationService organizationService;
+ @Resource
+ private OrganizationService organizationService;
- @Override
- public Map<String, Object> screenLogin(Map<String, Object> parameters) {
- Map<String, Object> result = new HashMap<String, Object>();
- Example example = new Example(Account.class);
- String password = md5((String) parameters.get("account"));
- example.or().andEqualTo("accountName",parameters.get("account")).andEqualTo("password",password);
- List<Account> accounts = accountMapper.selectByExample(example);
- if (isEmpty(accounts) || accounts.size() != 1) {
- result.put("msg", "���������������������������������");
- } else {
- Account account = accounts.get(0);
- if (IS_DELETE_FALSE.equals(account.getIsDelete())) {
- result.put("msg", "���������������");
- result.put("accountId", account.getId());
- result.put("orgId", account.getOrganizationId());
- } else {
- result.put("msg","���������������������������������������������");
- }
- }
- return result;
- }
+ @Resource
+ private OrganizationMapper organizationMapper;
- @Override
- public List<Account> getAccountLists(String accountName, String password) {
- Example example = new Example(Account.class);
- example.or().andEqualTo("accountName",accountName).andEqualTo("password",password);
- return accountMapper.selectByExample(example);
- }
+ @Override
+ public Map<String, Object> screenLogin(Map<String, Object> parameters) {
+ Map<String, Object> result = new HashMap<String, Object>();
+ Account account = new Account();
+ account.setAccountName((String) parameters.get("account"));
+ String rawPassword = (String) parameters.get("password");
+// account.setPassword(encoder.encode((String) parameters.get("password")));
+ account = accountMapper.selectOne(account);
+ boolean isValid = account == null ? false : encoder.matches(rawPassword, account.getPassword());
+ if (!isValid) {
+ result.put("msg", "���������������������������������");
+ } else {
+ if (IS_DELETE_FALSE.equals(account.getIsDelete())) {
+ result.put("msg", "���������������");
+ result.put("accountId", account.getId());
+ result.put("orgId", account.getOrganizationId());
+ setOrgIdsByAccount(result);
+ } else {
+ result.put("msg", "���������������������������������������������");
+ }
+ }
+ return result;
+ }
- @Override
- public List<Account> getAccountList(String accountName) {
- Example example = new Example(Account.class);
- example.or().andEqualTo("accountName",accountName);
- return accountMapper.selectByExample(example);
- }
+ @Override
+ public Map<String, Object> screenLoginNew(Map<String, Object> parameters) {
+ Map<String, Object> result = new HashMap<String, Object>();
+ Account account = new Account();
+ account.setAccountName((String) parameters.get("account"));
+ String rawPassword = (String) parameters.get("password");
+// account.setPassword(encoder.encode((String) parameters.get("password")));
+ account = accountMapper.selectOne(account);
+ Integer existRole=accountMapper.getScreenRoleByAccountName(account.getAccountName());
+ List<Menu> menuList = accountMapper.getScreenMenuListsByAccountName(account.getAccountName());
+ boolean isValid = account == null ? false : encoder.matches(rawPassword, account.getPassword());
+ if (!isValid) {
+ result.put("msg", "���������������������������������");
+ } else {
+ if (IS_DELETE_FALSE.equals(account.getIsDelete())) {
+ if(existRole!=null) {
+ result.put("msg", "���������������");
+ result.put("accountId", account.getId());
+ result.put("orgId", account.getOrganizationId());
+ result.put("data",menuList);
+ setOrgIdsByAccount(result);
+ }else{
+ result.put("msg", "���������������������");
+ }
+ } else {
+ result.put("msg", "���������������������������������������������");
+ }
+ }
+ return result;
+ }
- @Override
- public void setOrgIdsByAccount(Map<String, Object> parameters) {
- String accountId = (String) parameters.get("accountId");
- accountId = accountId.replaceFirst("-", "");
- if (!isNumeric((String) parameters.get("accountId"))) {
- throw new BusinessException("accountId ������������������");
- }
+ @Override
+ public Account getAccountByAccountName(String accountName) {
+ Account account = new Account();
+ account.setAccountName(accountName);
+ return accountMapper.selectOne(account);
+ }
- Account account = accountMapper.selectByPrimaryKey((Integer.valueOf(accountId)));
- if (isEmpty(account) || IS_DELETE_TRUE.equals(account.getIsDelete())) {
- throw new BusinessException(accountId + ":���������������������");
- }
- Integer orgId = account.getOrganizationId();
- // ���������������������������������������������������������������
-
- if (!(-1 == orgId || getValue("orgId").equals(orgId))) {
- Set<Integer> orgIds = organizationService.getChildOrganizationIds(orgId);
- parameters.put("orgIds", orgIds);
- }
- }
+ @Override
+ public Account getAccountById(Integer id) {
+ return accountMapper.selectByPrimaryKey(id);
+ }
+
+ @Override
+ public void setOrgIdsByAccount(Map<String, Object> parameters) {
+ String accountId = parameters.get("accountId").toString();
+ accountId = accountId.replaceFirst("-", "");
+ if (!isNumeric(accountId)) {
+ throw new BusinessException("accountId ������������������");
+ }
+
+ Account account = accountMapper.selectByPrimaryKey((Integer.valueOf(accountId)));
+ if (isEmpty(account) || IS_DELETE_TRUE.equals(account.getIsDelete())) {
+ throw new BusinessException(accountId + ":���������������������");
+ }
+ Integer orgId = account.getOrganizationId();
+ // ���������������������������������������������������������������
+
+ if (!(-1 == orgId || getValue("orgId").equals(orgId + ""))) {
+ Set<Integer> orgIds = organizationService.getChildOrganizationIds(orgId);
+ parameters.put("orgIds", orgIds);
+ }
+ }
+
+ @Override
+ public PageBean<Account> getAccountListByPage(Map<String, Object> parameters) {
+ Example example = new Example(Account.class);
+ Criteria criteria = example.createCriteria();
+ if (parameters.containsKey("accountName")) {
+ criteria.andLike("accountName", "%" + (String) parameters.get("accountName") + "%");
+ }
+ if (parameters.containsKey("mobile")) {
+ criteria.andLike("mobile", "%" + (String) parameters.get("mobile") + "%");
+ }
+ if (parameters.containsKey("isDelete")) {
+ criteria.andEqualTo("isDelete", parameters.get("isDelete"));
+ }
+ if (parameters.containsKey("sorter")) {
+ example.setOrderByClause((String) parameters.get("sorter"));
+ }
+ PageHelper.startPage(Integer.valueOf((String) parameters.get("pageIndex")), Integer.valueOf((String) parameters.get("pageSize")));
+ List<Account> accounts = accountMapper.selectByExample(example);
+ Set<Integer> organizationIds = new HashSet<Integer>();
+ for (Account account : accounts) {
+ if (!ObjectUtils.isEmpty(account.getOrganizationId())) {
+ organizationIds.add(account.getOrganizationId());
+ }
+ }
+ if (!ObjectUtils.isEmpty(organizationIds)) {
+ example = new Example(Organization.class);
+ example.or().andIn("id", organizationIds);
+ List<Organization> organizations = organizationMapper.selectByExample(example);
+ for (Account account : accounts) {
+ for (Organization organization : organizations) {
+ if (account.getOrganizationId() == organization.getId()) {
+ account.setOrganization(organization);
+ break;
+ }
+ }
+ }
+ }
+
+ return new PageBean<Account>(accounts);
+ }
+
+ @Override
+ @Transactional
+ public Integer saveOrUpdateAccount(Account account) {
+ // ������������
+ if (!StringUtils.isBlank(account.getPassword())) {
+ account.setPassword(encoder.encode(account.getPassword()));
+ }
+ if (ObjectUtils.isEmpty(account.getId())) {
+ account.setIsDelete(Constants.IS_DELETE_FALSE);
+ account.setCreateTime(new Date());
+ account.setPassword(encoder.encode(ResourceUtil.getValue("password")));
+ return accountMapper.insertSelective(account);
+ } else {
+ return accountMapper.updateByPrimaryKeySelective(account);
+ }
+ }
+
+ @Override
+ @Transactional
+ public Integer deleteAccountsByLogic(List<Integer> ids) {
+ Account account = new Account();
+ account.setIsDelete(Constants.IS_DELETE_TRUE);
+ Example example = new Example(Account.class);
+ example.or().andIn("id", ids);
+ return accountMapper.updateByExampleSelective(account, example);
+ }
+
+ @Override
+ public Integer getAccountCountByAccountName(String accountName) {
+ Account account = new Account();
+ account.setAccountName(accountName);
+ return accountMapper.selectCount(account);
+ }
+
+ @Override
+ public Optional<Account> queryAccountByName(String accountName) {
+ Account account = accountMapper.getByAccountName(accountName);
+ return Optional.ofNullable(account);
+ }
+
+ @Override
+ public Account companyLogin(Map<String, Object> parameters) {
+ ValidateUtil.notNull(parameters.get("account"), "param.is.null");
+ ValidateUtil.notNull(parameters.get("password"), "param.is.null");
+ Account account = new Account();
+ account.setIsDelete(Constants.IS_DELETE_FALSE);
+ account.setAccountName(parameters.get("account").toString());
+ account = accountMapper.selectOne(account);
+ if (ObjectUtils.isEmpty(account)) {
+ throw new BusinessException("���������������������������������������");
+ }
+ if (!encoder.matches(parameters.get("password").toString(), account.getPassword())) {
+ throw new BusinessException("���������������������������������");
+ }
+ account.setPassword(parameters.get("password").toString());
+ return account;
+ }
+
+ @Override
+ public Map<String, Object> getOrganizationIdByAccountId(String id) {
+ Integer accountId = Integer.parseInt(id);
+ Map<String, Object> map = accountMapper.getOrganizationIdByAccountId(accountId);
+ return map;
+ }
+
+ @Override
+ public List<Role> getRolesByAccountName(String accountName) {
+ List<Role> roleList = accountMapper.getRolesByAccountName(accountName);
+ return roleList;
+ }
+
+ @Override
+ public Map<String, Object> getMenuListsByAccountName(String accountName) {
+ List<Menu> menuList = accountMapper.getParentMenuListsByAccountName(accountName);
+ Integer organizationId = accountMapper.getByAccountName(accountName).getOrganizationId();
+ Map<String, Object> organizationMap = new LinkedHashMap<>();
+ organizationMap.put("organizationId",organizationId);
+ String email = accountMapper.getEmailByAccountName(accountName);
+ Map<String, Object> mapList = new LinkedHashMap<>();
+ Map<String, Object> appMap = new LinkedHashMap<>();
+ appMap.put("name", "������������������������");
+ appMap.put("description", "������������������������������������������");
+ mapList.put("app", appMap);
+ mapList.put("organization", organizationMap);
+ Map<String, Object> userMap = new LinkedHashMap<>();
+ userMap.put("name", accountName);
+ userMap.put("avatar", "./assets/img/zorro.svg");
+ userMap.put("email", email);
+ mapList.put("user", userMap);
+ Map<String, Object> navigationMap = new LinkedHashMap<>();
+ Map<String, Object> navigationChildMap = new LinkedHashMap<>();
+ navigationChildMap.put("text", "���������");
+ navigationChildMap.put("link", "/dashboard/workplace");
+ navigationChildMap.put("icon", "icon-speedometer");
+ navigationChildMap.put("translate", "dashboard_workplace");
+ List<Map> navigationChildList = new ArrayList<>();
+ navigationChildList.add(navigationChildMap);
+ navigationMap.put("text", "���������");
+ navigationMap.put("translate", "main_navigation");
+ navigationMap.put("group", true);
+ navigationMap.put("children", navigationChildList);
+ Map<String, Object> systemMap = new LinkedHashMap<>();
+ systemMap.put("text", "������������");
+ systemMap.put("group", true);
+ List<Map> systemList = new ArrayList<>();
+ if (!CollectionUtils.isEmpty(menuList)) {
+ for (Menu m : menuList) {
+ Map<String, Object> systemChildMap = new LinkedHashMap<>();
+ systemChildMap.put("text", m.getMenuName());
+ systemChildMap.put("icon", m.getMenuIcon());
+ List<Menu> childMenuLists = accountMapper.getChildMenuIdsByAccountName(accountName, m.getId());
+ List<Map> systemSonList = new ArrayList<>();
+ if (!CollectionUtils.isEmpty(childMenuLists)) {
+ for (Menu childMenu : childMenuLists) {
+ Map<String, Object> systemSonMap = new LinkedHashMap<>();
+ systemSonMap.put("text", childMenu.getMenuName());
+ systemSonMap.put("link", childMenu.getMenuUrl());
+ systemSonList.add(systemSonMap);
+ }
+ }
+ systemChildMap.put("children", systemSonList);
+ systemList.add(systemChildMap);
+ }
+ }
+ systemMap.put("children", systemList);
+ List<Map> list = new ArrayList<>();
+ list.add(navigationMap);
+ list.add(systemMap);
+ mapList.put("menu", list);
+ return mapList;
+ }
}
--
Gitblit v1.8.0