ruoyi设置数据权限

CREATE TABLE IF NOT EXISTS `testtab` (
  `id` int(11) NOT NULL COMMENT 'id',
  `admin_id` int(11) NOT NULL COMMENT 'admn_id',
  `val1` varchar(200) NOT NULL COMMENT '字段1',
  `val2` date NOT NULL COMMENT '字段2',
  `user_id` int(20) DEFAULT NULL,
  `dept_id` int(20) DEFAULT NULL
)

@DataScope(deptAlias = “t”,userAlias = “t”)

package com.ruoyi.system.service.impl;

import java.util.List;

import com.ruoyi.common.annotation.DataScope;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.ruoyi.system.mapper.TesttabMapper;
import com.ruoyi.system.domain.Testtab;
import com.ruoyi.system.service.ITesttabService;
import com.ruoyi.common.core.text.Convert;


@Service
public class TesttabServiceImpl implements ITesttabService 
{
    @Autowired
    private TesttabMapper testtabMapper;

    
    @Override
    public Testtab selectTesttabById(Long id)
    {
        return testtabMapper.selectTesttabById(id);
    }

    
    @Override
   //     注意看这里。。
    @DataScope(deptAlias = "t",userAlias = "t")
  
    public List selectTesttabList(Testtab testtab)
    {
        return testtabMapper.selectTesttabList(testtab);
    }

    
    @Override
    public int insertTesttab(Testtab testtab)
    {
        return testtabMapper.insertTesttab(testtab);
    }

    
    @Override
    public int updateTesttab(Testtab testtab)
    {
        return testtabMapper.updateTesttab(testtab);
    }

    
    @Override
    public int deleteTesttabByIds(String ids)
    {
        return testtabMapper.deleteTesttabByIds(Convert.toStrArray(ids));
    }

    
    @Override
    public int deleteTesttabById(Long id)
    {
        return testtabMapper.deleteTesttabById(id);
    }
}

添加${params.dataScope}

    
    
        
        
        
        
        
        
    

    
        select id, admin_id, val1, val2, user_id, dept_id from testtab t
    

    
        
        
          1=1
        

         and admin_id = #{adminId}
             and val1 = #{val1}
             and val2 = #{val2}
             and user_id = #{userId}
             and dept_id = #{deptId}
        ${params.dataScope}
    
    
    
        
        where id = #{id}
    
        
    
        insert into testtab
        
            admin_id,
            val1,
            val2,
            user_id,
            dept_id,
         
        
            #{adminId},
            #{val1},
            #{val2},
            #{userId},
            #{deptId},
         
    

    
        update testtab
        
            admin_id = #{adminId},
            val1 = #{val1},
            val2 = #{val2},
            user_id = #{userId},
            dept_id = #{deptId},
        
        where id = #{id}
    

    
        delete from testtab where id = #{id}
    

    
        delete from testtab where id in 
        
            #{id}
        
    

注意表名称后添加表别名

添加这一步主要是保存时能默认用户和用户所在的部门

package com.ruoyi.system.controller;

import java.util.List;
import org.apache.shiro.authz.annotation.RequiresPermissions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.system.domain.Testtab;
import com.ruoyi.system.service.ITesttabService;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;


@Controller
@RequestMapping("/system/testtab")
public class TesttabController extends BaseController
{
    private String prefix = "system/testtab";

    @Autowired
    private ITesttabService testtabService;

    @RequiresPermissions("system:testtab:view")
    @GetMapping()
    public String testtab()
    {
        return prefix + "/testtab";
    }

    
    @RequiresPermissions("system:testtab:list")
    @PostMapping("/list")
    @ResponseBody
    public TableDataInfo list(Testtab testtab)
    {
        startPage();
        List list = testtabService.selectTesttabList(testtab);
        return getDataTable(list);
    }

    
    @RequiresPermissions("system:testtab:export")
    @Log(title = "测试的", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    @ResponseBody
    public AjaxResult export(Testtab testtab)
    {
        List list = testtabService.selectTesttabList(testtab);
        ExcelUtil util = new ExcelUtil(Testtab.class);
        return util.exportExcel(list, "测试的数据");
    }

    
    @GetMapping("/add")
    public String add()
    {
        return prefix + "/add";
    }

    
    @RequiresPermissions("system:testtab:add")
    @Log(title = "测试的", businessType = BusinessType.INSERT)
    @PostMapping("/add")
    @ResponseBody
    public AjaxResult addSave(Testtab testtab)
    {

        long xxx=  getSysUser().getUserId();
        testtab.setUserId(xxx);
        long yyy = getSysUser().getDeptId();
        testtab.setDeptId(yyy);
        return toAjax(testtabService.insertTesttab(testtab));
    }

    
    @RequiresPermissions("system:testtab:edit")
    @GetMapping("/edit/{id}")
    public String edit(@PathVariable("id") Long id, ModelMap mmap)
    {
        Testtab testtab = testtabService.selectTesttabById(id);


        mmap.put("testtab", testtab);
        return prefix + "/edit";
    }

    
    @RequiresPermissions("system:testtab:edit")
    @Log(title = "测试的", businessType = BusinessType.UPDATE)
    @PostMapping("/edit")
    @ResponseBody
    public AjaxResult editSave(Testtab testtab)
    {
        long xxx=  getSysUser().getUserId();
        logger.debug(xxx+"USERID");

        testtab.setUserId(xxx);
        testtab.setDeptId(yyy);



        return toAjax(testtabService.updateTesttab(testtab));
    }

    
    @RequiresPermissions("system:testtab:remove")
    @Log(title = "测试的", businessType = BusinessType.DELETE)
    @PostMapping( "/remove")
    @ResponseBody
    public AjaxResult remove(String ids)
    {
        return toAjax(testtabService.deleteTesttabByIds(ids));
    }
}

删除dept_id与user_id

Options
取消 user_id，dept_id显示