Day03

机构管理

统一启动就有一个超级租户（系统运营方），有个超级管理员。拥有所有权限。
机构入驻进来需要一个超级管理员，拥有租户所有套餐的所有权限。
创建部门
创建员工:分配权限 （这个租户拥有的权限）

代码生成

表设计

代码生成

strategy.setInclude(new String[]{"t_department", "t_employee","t_meal","t_menu",
        "t_permission","t_role","t_tenant","t_tenant_type"}); // 需要生成的表

分页+高级查询+关联查询

后台：
Domain

Mapper.xml

<sql id="whereSql">
    <where>
        <if test="keyword!=null and keyword!=''">

             and t.companyName like concat('%',#{keyword},"%")
        </if>
    </where>
</sql>
<!--List<Tenant> loadPageList(Page<Tenant> page, TenantQuery query);-->
<select id="loadPageList" resultMap="TenantMap">
    SELECT
        t.*, type.id tid,
        type. NAME tname,
      e.id eid,e.realName
    FROM
        t_tenant t
    LEFT JOIN t_tenant_type type ON t.tenant_type = type.id
    LEFT JOIN t_employee e on t.admin_id = e.id
    <include refid="whereSql"></include>
</select>

<resultMap id="TenantMap" type="Tenant">
    <id column="id" property="id" />
    <result column="tenant_type" property="tenantType" />
    <result column="companyName" property="companyName" />
    <result column="companyNum" property="companyNum" />
    <result column="registerTime" property="registerTime" />
    <result column="state" property="state" />
    <result column="address" property="address" />
    <result column="logo" property="logo" />
    <result column="admin_id" property="adminId" />

    <!-- 机构类型多对一关联-->
    <association property="type" javaType="TenantType">
        <id column="tid" property="id" />
        <result column="tname" property="name" />
    </association>

    <!--管理员的关联查询-->
    <association property="admin" javaType="Employee">
        <id column="eid" property="id" />
        <result column="realName" property="realName" />
    </association>
</resultMap>

删除

service

Mapper.xml

机构入驻

前台传递参数

后台实现

package org.hhw.hrm.service.impl;

import org.hhw.hrm.domain.Employee;
import org.hhw.hrm.domain.Tenant;
import org.hhw.hrm.mapper.EmployeeMapper;
import org.hhw.hrm.mapper.TenantMapper;
import org.hhw.hrm.service.ITenantService;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.io.Serializable;
import java.util.Date;

@Service
public class TenantServiceImpl extends ServiceImpl<TenantMapper, Tenant> implements ITenantService {

    @Autowired
    private TenantMapper tenantMapper;
    @Autowired
    private EmployeeMapper employeeMapper;
    @Override
    public boolean insert(Tenant tenant) {
        //保存公司管理员信息-没有租户id
        Employee admin = entity.getAdmin();
        admin.setInputTime(new Date()); //输入时间
        admin.setState(0); // 正常
        admin.setType(1); //是否是租户管理员
        employeeMapper.insert(admin);
        System.out.println(admin.getId()+"iiii");

        //保存公司信息-要返回自增id
        entity.setAdminId(admin.getId());
        tenantMapper.insert(entity);

        System.out.println(entity.getId()+"jjjj");
        //修改管理员的租户id
        admin.setTenantId(entity.getId());
        employeeMapper.updateById(admin);        //添加套餐中间表
        tenantMapper.saveTenantMeals(tenant.getMealsMap());
        return true;
    }

    @Override
    public boolean deleteById(Serializable id) {

        //删除机构
        tenantMapper.deleteById(id);
        //删除管理员
        Wrapper<Employee> wapper = new EntityWrapper<>();
        wapper.eq("tenant_id",id);
        employeeMapper.delete(wapper);
        //删除中间表
        tenantMapper.removeTenantMeal(id);
        return true;
    }

    @Override
    public boolean updateById(Tenant tenant) {
        // 修改机构
        tenantMapper.updateById(tenant);
        //修改管理员
        employeeMapper.updateById(tenant.getAdminUser());
        //修改中间表-先删除后添加
        tenantMapper.removeTenantMeal(tenant.getId());
        tenantMapper.saveTenantMeals(tenant.getMealsMap());
        return true;
    }
}

package org.hhw.hrm.mapper;

import org.hhw.hrm.domain.Tenant;
import com.baomidou.mybatisplus.mapper.BaseMapper;

import java.io.Serializable;
import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author yhptest
 * @since 2019-09-02
 */
public interface TenantMapper extends BaseMapper<Tenant> {

    /**
     * 保存机构所对应的套餐的中间表信息
     * @param mealsMap
     */
    void saveTenantMeals(List<Map<String, Long>> mealsMap);

    /**
     * 删除中间表
     * @param id
     */
    void removeTenantMeal(Serializable id);
}

<!--void saveTenantMeals(List<Map<String, Long>> mealsMap);-->
<insert id="saveTenantMeals" parameterType="arrayList">
    insert into t_tenant_meal(tenant_id,meal_id) VALUES
    <foreach collection="list" separator="," item="item">
        (#{item.tenantId},#{item.mealId})
    </foreach>
</insert>

<!--void removeTenantMeal(Serializable id);-->
<delete id="removeTenantMeal" parameterType="long">
    DELETE  from t_tenant_meal where tenant_id =#{id}
</delete>