@PostMapping("/login")
public Result login(@RequestBody User user) {
List list = userService.lambdaQuery()
.eq(User::getNo, user.getNo())
.eq(User::getPassword, user.getPassword()).list();
if (list.size() > 0) {
User user1 = (User) list.get(0);
List menuList = menuService.lambdaQuery().like(Menu::getMenuright, user1.getRoleId()).list();
HashMap res = new HashMap();
res.put("user", user1);
res.put("menu", menuList);
res.put("list", list);
return Result.suc(res);
}
return Result.fail();
}
上面是登录接口
HashMap res = new HashMap();
key:value
出库入库 相关操作
@Autowired
private RecordService recordService;
@Autowired
private GoodsService goodsService;
@PostMapping("/listPage")
public Result listPage(@RequestBody QueryPageParam query) {
HashMap param = query.getParam();
String name = (String) param.get("name");
String goodstype = (String) param.get("goodstype");
String storage = (String) param.get("storage");
String roleId = (String) param.get("roleId");
String userId = (String) param.get("userId");
Page<Record> page = new Page();
page.setCurrent(query.getPageNum());
page.setSize(query.getPageSize());
QueryWrapper<Record> queryWrapper = new QueryWrapper();
queryWrapper.apply(" a.goods=b.id and b.storage=c.id and b.goodsType=d.id ");
if ("2".equals(roleId)) {
// queryWrapper.eq(Record::getUserid,userId);
queryWrapper.apply(" a.userId= " + userId);
}
if (StringUtils.isNotBlank(name) && !"null".equals(name)) {
queryWrapper.like("b.name", name);
}
if (StringUtils.isNotBlank(goodstype) && !"null".equals(goodstype)) {
queryWrapper.eq("d.id", goodstype);
}
if (StringUtils.isNotBlank(storage) && !"null".equals(storage)) {
queryWrapper.eq("c.id", storage);
}
IPage result = recordService.pageCC(page, queryWrapper);
return Result.suc(result.getRecords(), result.getTotal());
}
//新增
@PostMapping("/save")
public Result save(@RequestBody Record record) {
Goods goods = goodsService.getById(record.getGoods());
int n = record.getCount();
//出库
if ("2".equals(record.getAction())) {
n = -n;
record.setCount(n);
}
int num = goods.getCount() + n;
goods.setCount(num);
goodsService.updateById(goods);
return recordService.save(record) ? Result.suc() : Result.fail();
}
----------------------------------------------------------------------------------------------------------------
单表增删改查
@RestController
@RequestMapping("/goods")
public class GoodsController {
@Autowired
private GoodsService goodsService;
//新增
@PostMapping("/save")
public Result save(@RequestBody Goods goods) {
return goodsService.save(goods) ? Result.suc() : Result.fail();
}
//更新
@PostMapping("/update")
public Result update(@RequestBody Goods goods) {
return goodsService.updateById(goods) ? Result.suc() : Result.fail();
}
//删除
@GetMapping("/del")
public Result del(@RequestParam String id) {
return goodsService.removeById(id) ? Result.suc() : Result.fail();
}
@PostMapping("/listPage")
public Result listPage(@RequestBody QueryPageParam query) {
HashMap param = query.getParam();
String name = (String) param.get("name");
String goodstype = (String) param.get("goodstype");
String storage = (String) param.get("storage");
Page<Goods> page = new Page();
page.setCurrent(query.getPageNum());
page.setSize(query.getPageSize());
LambdaQueryWrapper<Goods> lambdaQueryWrapper = new LambdaQueryWrapper();
if (StringUtils.isNotBlank(name) && !"null".equals(name)) {
lambdaQueryWrapper.like(Goods::getName, name);
}
if (StringUtils.isNotBlank(goodstype) && !"null".equals(goodstype)) {
lambdaQueryWrapper.eq(Goods::getGoodstype, goodstype);
}
if (StringUtils.isNotBlank(storage) && !"null".equals(storage)) {
lambdaQueryWrapper.eq(Goods::getStorage, storage);
}
IPage result = goodsService.pageCC(page, lambdaQueryWrapper);
return Result.suc(result.getRecords(), result.getTotal());
}
}
service
public interface GoodsService extends IService<Goods> {
IPage pageCC(IPage<Goods> page, Wrapper wrapper);
}
serviceImpl
@Override
public IPage pageCC(IPage<Storage> page, Wrapper wrapper) {
return storageMapper.pageCC(page, wrapper);
}
Mapper
@Mapper
public interface StorageMapper extends BaseMapper<Storage> {
IPage pageCC(IPage<Storage> page, @Param(Constants.WRAPPER) Wrapper wrapper);
}
Mapper.xml
<?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="com.liush.wms.mapper.StorageMapper">
<select id="pageCC" resultType="com.liush.wms.entity.Storage">
select *
from storage ${ew.customSqlSegment}
</select>
</mapper>