package com.mes.md.service.impl;
|
|
import com.github.yulichang.base.MPJBaseServiceImpl;
|
import com.github.yulichang.toolkit.JoinWrappers;
|
import com.mes.md.entity.*;
|
import com.mes.md.mapper.AccountMapper;
|
import com.mes.md.mapper.RoleMapper;
|
import com.mes.md.service.AccountService;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* <p>
|
* 账户表 服务实现类
|
* </p>
|
*
|
* @author yanzhixin
|
* @since 2024-09-03
|
*/
|
@Slf4j
|
@Service
|
public class AccountServiceImpl extends MPJBaseServiceImpl<AccountMapper, Account> implements AccountService {
|
|
@Autowired
|
RoleMapper roleMapper;
|
/**
|
* 输入账户密码 返回权限
|
* @return
|
*/
|
@Override
|
public Map<String, Object> selectAccount(String account, String password){
|
//返回结果 用户权限
|
Map<String, Object> accountRole=new HashMap<>();
|
//验证通过的用户 权限内容
|
List<Map<String,Object>> username=baseMapper.selectJoinMaps(JoinWrappers.lambda(Account.class)
|
.selectAll(Account.class)
|
.selectAs(Role::getRoleName,"role_name")
|
.selectAs(Role::getRoleNumber,"role_number")
|
.selectAs(Role::getRemark,"role_remark")
|
.selectAs(RoleMenu::getId,"role_menu_id")
|
.selectAs(RoleMenu::getMenuId,"menu_id")
|
.selectAs(RoleMenu::getPageId,"page_id")
|
.selectAs(RoleMenu::getMenuSequence,"remark")
|
.selectAs(Menu::getMenuName,"menu_name")
|
.selectAs(Menu::getMenuNumber,"menu_number")
|
.selectAs(Menu::getRemark,"menu_remark")
|
.selectAs(Page::getPageName,"page_name")
|
.selectAs(Page::getPageNumber,"page_number")
|
.selectAs(Page::getPageUrl,"page_url")
|
.innerJoin(Role.class,on->on.eq(Role::getId,Account::getRoleId))
|
.innerJoin(RoleMenu.class,on->on.eq(RoleMenu::getRoleId,Role::getId))
|
.innerJoin(Menu.class, on->on.eq(Menu::getId,RoleMenu::getMenuId))
|
.innerJoin(Page.class, on->on.eq(Page::getId,RoleMenu::getPageId))
|
.eq(Account::getAccount,account)
|
.eq(Account::getPassword, password)
|
);
|
|
List<String> keyMenus=new ArrayList<>();//菜单顺序
|
//Map<String, Object> menus=new HashMap<>();//菜单内容页
|
|
if (username.size()>0){
|
Map<String,Object> frist=username.get(0);
|
//账户信息
|
accountRole.put("id",frist.get("id").toString());
|
accountRole.put("user_name",frist.get("user_name").toString());
|
accountRole.put("account",frist.get("account").toString());
|
accountRole.put("role_id",frist.get("role_id").toString());
|
for (Map<String,Object> item:username){
|
if(keyMenus.contains(item.get("menu_id").toString())){
|
//存在此菜单
|
int index=keyMenus.indexOf(item.get("menu_id").toString());
|
List<Map<String, Object>> thisMenus= (List<Map<String, Object>>) accountRole.get("menus");
|
Map<String, Object> thisMenu=(Map<String, Object>)thisMenus.get(index);
|
List<Map<String, Object>> thisPages= (List<Map<String, Object>>) thisMenu.get("pages");
|
//添加页面组
|
Map<String, Object> page=new HashMap<>();//页面
|
page.put("page_id",item.get("page_id"));
|
page.put("page_name",item.get("page_name"));
|
page.put("page_number",item.get("page_number"));
|
page.put("page_url",item.get("page_url"));
|
page.put("menu_sequence",item.get("menu_sequence"));
|
thisPages.add(page);
|
thisMenu.put("pages",thisPages);
|
thisMenus.set(index,thisMenu);
|
accountRole.put("menus",thisMenus);
|
}else if(keyMenus.size()>0&&!keyMenus.contains(item.get("menu_id").toString())){
|
//不存在此菜单
|
keyMenus.add(item.get("menu_id").toString());
|
List<Map<String, Object>> thisMenus= (List<Map<String, Object>>) accountRole.get("menus");
|
Map<String, Object> thisMenu=new HashMap<>();
|
thisMenu.put("menu_id",item.get("menu_id"));
|
thisMenu.put("menu_name",item.get("menu_name"));
|
thisMenu.put("menu_number",item.get("menu_number"));
|
thisMenu.put("menu_remark",item.get("menu_remark"));
|
List<Map<String, Object>> thisPages= new ArrayList<>();
|
//添加页面组
|
Map<String, Object> page=new HashMap<>();//页面
|
page.put("page_id",item.get("page_id"));
|
page.put("page_name",item.get("page_name"));
|
page.put("page_number",item.get("page_number"));
|
page.put("page_url",item.get("page_url"));
|
page.put("menu_sequence",item.get("menu_sequence"));
|
thisPages.add(page);
|
thisMenu.put("pages",thisPages);
|
thisMenus.add(thisMenu);
|
accountRole.put("menus",thisMenus);
|
}else{
|
keyMenus.add(item.get("menu_id").toString());
|
//添加菜单组 不存在此带单则添加
|
List<Map<String, Object>> menus=new ArrayList<>();//菜单组
|
Map<String, Object> menu=new HashMap<>(); //菜单
|
menu.put("menu_id",item.get("menu_id"));
|
menu.put("menu_name",item.get("menu_name"));
|
menu.put("menu_number",item.get("menu_number"));
|
menu.put("menu_remark",item.get("menu_remark"));
|
//添加页面组
|
List<Map<String, Object>> pages=new ArrayList<>();//页面组
|
Map<String, Object> page=new HashMap<>();//页面
|
page.put("page_id",item.get("page_id"));
|
page.put("page_name",item.get("page_name"));
|
page.put("page_number",item.get("page_number"));
|
page.put("page_url",item.get("page_url"));
|
page.put("menu_sequence",item.get("menu_sequence"));
|
pages.add(page);
|
menu.put("pages",pages);
|
menus.add(menu);
|
accountRole.put("menus",menus);
|
}
|
}
|
}
|
return accountRole;
|
}
|
/**
|
* 查询所有账户
|
* @return
|
*/
|
@Override
|
public List<Map<String, Object>> findAccounts(){
|
return baseMapper.selectJoinMaps(JoinWrappers.lambda(Account.class)
|
.selectAll()
|
.selectAs(Role::getRoleName,"role_name")
|
.leftJoin(Role.class, on -> on.eq(Role::getId, Account::getRoleId))
|
.orderByAsc(Account::getId));
|
}
|
|
/**
|
* 添加账户
|
* @return
|
*/
|
@Override
|
public int addAccount(Account account){
|
|
return baseMapper.insert(account);
|
}
|
/**
|
* 修改账户
|
* @return
|
*/
|
@Override
|
public int updateAccount(Account account){
|
return baseMapper.updateById(account);
|
}
|
/**
|
* 删除账户
|
* @return
|
*/
|
@Override
|
public int deleteAccount(Account account){
|
return baseMapper.deleteById(account);
|
}
|
}
|
