Spring Boot图书管理系统项目实战-7.借阅图书
导航：
pre： 6.图书管理
next：8.续借图书
只挑重点的讲，具体的请看项目源码。
1.项目源码
2.页面设计
2.1 bookBorrow.html
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<title>借阅图书</title>
<link rel="stylesheet" href="/static/layui/css/layui.css" th:href="@{/static/layui/css/layui.css}">
</head>
<body>
<!-- 内容主体区域 -->
<div>
<!--<div class="demoTable" style="padding: 15px">
搜索：
<div class="layui-inline">
<input class="layui-input" id="find" autocomplete="off">
</div>
<button class="layui-btn" data-type="reload" id="queryRole">搜索</button>
</div>-->
<div>
<div class="search-div">
<div class="">
<div class="layui-inline">
<label class="layui-form-label">读者编码：</label>
<div class="layui-input-inline">
<input class="layui-input" id="readerCode" name="readerCode" autocomplete="off">
</div>
</div>
<div class="layui-inline">
<label class="layui-form-label">ISBN：</label>
<div class="layui-input-inline">
<input class="layui-input" id="isbn" name="isbn" autocomplete="off">
</div>
</div>
<button class="layui-btn" data-type="reload" id="search">搜索</button>
</div>
</div>
<table id="tb-book" lay-filter="tb-book"></table>
</div>
<table id="tb_bookBorrow" lay-filter="tb_bookBorrow"></table>
</div>
<!--编辑表单-->
<script type="text/html" id="book-toolbar">
<div class="layui-btn-container">
<button class="layui-btn layui-btn-sm" lay-event="add"><i class="layui-icon"></i>新增</button>
<button class="layui-btn layui-btn-sm layui-btn-danger" lay-event="remove"><i class="layui-icon"></i>删除
</button>
<button class="layui-btn layui-btn-sm" lay-event="refresh"><i class="layui-icon"></i>刷新
</button>
</div>
<!--<div class="layui-btn-container">
<button class="layui-btn layui-btn-sm" lay-event="getCheckData">获取选中行数据</button>
<button class="layui-btn layui-btn-sm" lay-event="getCheckLength">获取选中数目</button>
<button class="layui-btn layui-btn-sm" lay-event="isAll">验证是否全选</button>
</div>-->
</script>
<script type="text/html" id="barOps">
<a class="layui-btn layui-btn-sm" lay-event="edit"><i class="layui-icon"></i> </a>
</script>
<script src="/static/js/jquery-1.11.3.min.js" th:src="@{/static/js/jquery-1.11.3.min.js}"></script>
<script src="/static/layui/layui.all.js" th:src="@{static/layui/layui.all.js}"></script>
<script src="/static/js/util.js" th:src="@{/static/js/util.js}"></script>
<!--ctx-->
<script th:replace="~{fragment::ctx}"/>
<script>
var element, layer, laydate, table, form,userTable;
function reload(){
userTable.reload();
}
$(function () {
// 使用模块
layui.use(['element', 'layer', 'laydate', 'table', 'form'], function () {
element = layui.element;
layer = layui.layer;
laydate = layui.laydate;
table = layui.table;
form = layui.form;
});
element.on('tab(demo)', function(data){
var src=$(".layui-tab-item.layui-show").find("iframe").attr("src");
$(".layui-tab-item.layui-show").find("iframe").attr("src",src);
});
//第一个实例
userTable = table.render({
elem: '#tb_bookBorrow'
, height: 515
, url: ctx+'api/bookBorrow/getPageResult' //数据接口
, page: true //开启分页
, toolbar: '#book-toolbar'
/*,request: {
pageName: 'pageNo' //页码的参数名称，默认：page
,limitName: 'pageSize' //每页数据量的参数名，默认：limit
}
, response: {
statusName: 'code', //规定返回的状态码字段为code
statusCode: 200 //规定成功的状态码为200，默认为0
}
, parseData: function (res) {
return {
"code": res.code, //解析接口状态
"msg": res.msg, //解析提示文本
"count": res.records, //解析数据长度
"data": res.rows //解析数据列表
}
}*/
, cols: [
[ //表头
{type: 'checkbox', fixed: 'left'}
, {field: 'id', title: 'ID', width: 80, sort: true, fixed: 'left',hide:true}
, {field: 'borrowStatus', title: '状态', width: 80,templet:showStatus}
, {field: 'readerCode', title: '读者编码', width: 160}
, {field: 'readerName', title: '读者姓名', width: 160}
, {field: 'readerSex', title: '读者性别', width: 120}
, {field: 'readerPhone', title: '读者电话', width: 160}
, {field: 'bookIsbn', title: '图书ISBN', width: 160}
, {field: 'bookName', title: '图书名称', width: 160}
, {field: 'bookAuthor', title: '图书作者', width: 120}
, {field: 'bookCategory', title: '图书分类', width: 120}
, {field: 'bookLocation', title: '图书位置', width: 180}
, {field: 'bookTotal', title: '图书数量', width: 120}
, {field: 'bookLeft', title: '图书剩余', width: 120}
, {field: 'borrowDate', title: '借阅日期', width: 120,templet:'<div>{{ layui.util.toDateString(d.borrowDate, "yyyy-MM-dd") }}</div>'}
, {field: 'returnDate', title: '应还日期', width: 120,templet:'<div>{{ layui.util.toDateString(d.returnDate, "yyyy-MM-dd") }}</div>'}
, {field: 'borrowDays', title: '借阅天数', width: 120}
, {field: 'remark', title: '备注', width: 180}
, {fixed: 'right', title: '操作', toolbar: '#barOps', width: 120}
]
]
});
//工具栏事件
table.on('toolbar(tb_bookBorrow)', function (obj) {
var checkStatus = table.checkStatus(obj.config.id);
var checkData = checkStatus.data;
var ids = [];
switch (obj.event) {
// 新增
case 'add':
cleanForm("#saveBook");
top.layer.open({
type: 2,
offset: '10px',
title: "新增借阅",
area: ['800px', '680px'],
content: ['bookBorrowAdd']
});
break;
// 删除
case 'remove':
if (checkData.length == 0) {
layer.alert('请选择要操作的行');
} else {
layer.confirm('确定要删除吗？', function (index) {
for (var i = 0; i < checkData.length; i++) {
ids.push(checkData[i].id);
}
//layer.alert(JSON.stringify(ids));
$.ajax({
url: ctx+'api/bookBorrow/remove',
type: 'POST',
contentType: "application/json",
dataType: "json",
data: JSON.stringify(ids),
success: function (result) {
if (result.code == 200) {
setTimeout(function () {
layer.closeAll();//关闭所有的弹出层
userTable.reload();
}, 300);
}else {
layer.msg("操作失败！", {icon: 5});
}
}
});
});
}
break;
case 'refresh':
userTable.reload();
break;
case 'getCheckData':
layer.alert(JSON.stringify(data));
break;
case 'getCheckLength':
var data = checkStatus.data;
layer.msg('选中了：' + data.length + ' 个');
break;
case 'isAll':
layer.msg(checkStatus.isAll ? '全选' : '未全选')
break;
}
;
});
// 监听工具条
table.on('tool(tb_bookBorrow)', function (obj) {
var data = obj.data;
// 修改
if (obj.event === 'edit') {
top.layer.open({
type: 2,
offset: '10px',
title: "修改借阅",
area: ['800px', '680px'],
content: [ctx+'bookBorrowEdit/'+data.id]
});
}
});
// 搜索
$('#search').click(function () {
var readerCode = $('#readerCode').val();
var isbn = $('#isbn').val();
table.reload('tb_bookBorrow', {
url: ctx+'api/bookBorrow/getPageResult'
,where: {
readerCode:readerCode,isbn:isbn
}
,page: {
curr: 1
}
});
});
});
// 借阅状态
function showStatus(data) {
var status = data.borrowStatus;
var result;
if (status == 0) {
result = '<a class="" style="color:#FF5722">未还</a>';
}
if (status == 1) {
result = '<a class="" style="color:#009688">已还</a>';
}
if (status == 2) {
result = '<a class="" style="color:#FF5722">逾期</a>';
}
return result;
}
</script>
</body>
</html>3.借阅管理service
/**
* @Description: 借阅图书服务
* @Author laoxu
* @Date 2020/1/12
**/
@Service
public class BookBorrowService extends AbstractService {
public void add(BookBorrowVO entity) {
//String username = SecurityUtil.getLoginUser();
insert("bookBorrowMapper.insert",entity);
}
public void modify(BookBorrowVO entity) {
update("bookBorrowMapper.update",entity);
}
public void remove(Long id) {
delete("bookBorrowMapper.delete",id);
}
public void removes(Long[] ids) {
delete("bookBorrowMapper.deletes",ids);
}
public void returnBook(Map<String, Object> param) {
delete("bookBorrowMapper.return",param);
}
public BookBorrowVO get(Long id) {
return selectOne("bookBorrowMapper.select",id);
}
public List<BookBorrow> getParentList(Long id) {
return selectList("bookBorrowMapper.selectParentList",id);
}
public int count(Map<String, Object> param) {
return selectOne("bookBorrowMapper.count",param);
}
public List<BookBorrow> getList(Map<String, Object> param) {
return selectList("bookBorrowMapper.selectList",param);
}
public List<BookBorrowVO> getPageResult(Map<String, Object> param) {
return selectList("bookBorrowMapper.selectPageResult",param);
}
public int checkBorrow(BookBorrowVO entity){
return selectOne("bookBorrowMapper.countBorrow",entity);
}
public int getBorrowCount(String date){
return selectOne("bookBorrowMapper.selectBorrowCount",date);
}
public int getReturnCount(String date){
return selectOne("bookBorrowMapper.selectReturnCount",date);
}
}
4.借阅管理controller
/**
* @Description: 借阅图书控制器
* @Author laoxu
* @Date 2020/1/12 23:24
**/
@RestController
@RequestMapping("/api/bookBorrow")
public class BookBorrowController {
@Autowired
BookBorrowService bookBorrowService;
@Autowired
BookReaderService bookReaderService;
@Autowired
BookService bookService;
/**
* 保存（新增/修改）
*
* @param entity
* @return
*/
@PostMapping("/save")
public Result<String> modify(@RequestBody BookBorrowVO entity) {
Long id = entity.getId();
if(id!=null){
bookBorrowService.modify(entity);
}else{
Map<String,Object> param = new HashMap<>();
param.put("isbn",entity.getBookIsbn());
param.put("code",entity.getReaderCode());
//1.检查读者编号是否存在
if(bookReaderService.count(param)==0){
return ResultUtil.fail("读者不存在！");
}
//2.检查图书编号是否存在
if(bookService.count(param)==0){
return ResultUtil.fail("图书不存在！");
}
//3.检查该读者是否已经借过此书
int count = bookBorrowService.checkBorrow(entity);
if(count>0){
return ResultUtil.fail("您已借过该图书！");
}
//4.检查图书剩余
Book book = bookService.getByIsbn(entity.getBookIsbn());
int leftNumber = book.getLeftNumber();
if(leftNumber<1){
return ResultUtil.fail("图书剩余数量为0！");
}
//5.扣减图书剩余
book.setLeftNumber(leftNumber-1);
bookService.modify(book);
//6.保存借阅记录
bookBorrowService.add(entity);
}
return ResultUtil.ok();
}
@PostMapping("/remove")
public Result<String> remove(@RequestBody Long[] ids) {
bookBorrowService.removes(ids);
return ResultUtil.ok();
}
/**
* 归还
* @param ids
* @return
*/
@PostMapping("/return")
@Transactional
public Result<String> returnBook(@RequestBody Long[] ids) {
// 1.增加图书库存
Book entity = null;
for (Long id: ids) {
entity = bookService.getByIsbn(bookBorrowService.get(id).getBookIsbn());
entity.setLeftNumber(entity.getLeftNumber()+1);
bookService.modify(entity);
}
// 2.更新借阅状态
Map<String,Object> param = new HashMap<>();
param.put("ids", ids);
param.put("borrowStatus",1);
bookBorrowService.returnBook(param);
return ResultUtil.ok();
}
@GetMapping("/get")
public Result<BookBorrowVO> get(@RequestParam("id") Long id) {
BookBorrowVO entity = bookBorrowService.get(id);
return ResultUtil.ok(entity);
}
@GetMapping("/getPageResult")
public ResultBean<List<BookBorrowVO>> getPageResult(
@RequestParam(required = false) Integer[] borrowStatus,
@RequestParam(required = false) String readerCode,
@RequestParam(required = false) String isbn,
@RequestParam(defaultValue = "1") Integer page,
@RequestParam(defaultValue = "10") Integer limit) {
Map<String, Object> param = new HashMap<>();
// 统计记录数
int totalRows = bookBorrowService.count(param);
// 计算起始行号
int offset = (page - 1) * limit;
int rows = limit;
param.put("offset", offset);
param.put("rows", rows);
param.put("borrowStatus",borrowStatus);
param.put("readerCode",readerCode);
param.put("isbn",isbn);
// 获取当前页结果集
List<BookBorrowVO> entities = bookBorrowService.getPageResult(param);
ResultBean result = new ResultBean(0, "查询成功", totalRows, entities);
return result;
}
@GetMapping("/getBorrowStat")
public Result<Map<String,Object>> getBorrowStat(){
Map<String,Object> map = new HashMap<>();
List<String> days = DateUtil.getDaysBetwwen(6);
map.put("columnName",days);
BorrowStatVO borrowVO = new BorrowStatVO();
BorrowStatVO returnVO = new BorrowStatVO();
borrowVO.setName("借");
returnVO.setName("还");
borrowVO.setType("bar");
returnVO.setType("bar");
List<Integer> borrowData = new ArrayList<>();
List<Integer> returnData = new ArrayList<>();
for (String day:days) {
borrowData.add(bookBorrowService.getBorrowCount(day));
returnData.add(bookBorrowService.getReturnCount(day));
}
borrowVO.setData(borrowData);
returnVO.setData(returnData);
List<BorrowStatVO> list = new ArrayList<>();
list.add(borrowVO);
list.add(returnVO);
map.put("columnValue",list);
return ResultUtil.ok(map);
}
}
