基于javaweb+mysql的ssm餐厅点餐收银管理系统(java+ssm+jsp+bootstrap+mysql+redis)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM餐厅点餐收银管理系统(java+ssm+jsp+bootstrap+mysql+redis)
项目介绍
用于餐厅的收银管理系统,包含了四个模块 1.桌位模块 桌位模块主要是用于管理桌位的模块,包括点菜到结账的流程 将桌位人数设置为0
可以滞空当前桌位
2.账单模块 账单模块记录了每一天的帐单汇总,同时提供了年月日账单的统计,在日账单内可以查看当日的所有消费详情,还提供了按日期或日期区间搜索账单的功能
3.日常维护模块 提供了桌位菜单用户供应商的配置功能,也就是增删改查
添加菜品时,添加酒水类时,可以选择进货内的酒水,这样的话在结账后若客人点了该酒水,会将销售信息记录在酒水库存内的销售信息里
4.酒水库存模块 查看添加酒水的进销存信息
管理员角色包含以下功能:
登录,查看桌位,开桌,点菜,结账,查看账单,添加菜品,查看菜品,桌位维护,添加桌位,添加账号,查看账号,添加供应商,进货信息管理,添加进货信息等功能。
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.数据库:MySql 5.7版本; 6.是否Maven项目:否; 7.Redis数据库;
技术栈
- 后端:Spring+SpringMVC+Mybatis 2. 前端:JSP+Bootstrap+jQuery
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中applicationcontext-mybatis.xml配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入localhost:8080/login.html 登录 管理员账号/密码:admin/adminadmin
//今日账单
@RequestMapping("/todayBill.html")
public String showTodayBill(HttpSession session, Model model, DeskBillPager pager, BillSummaryPager bpager){
if(session.getAttribute("user")==null){//权限控制
return "redirect:login.html";
}
int totalCount=deskBillService.getCount(new Date());//查询当天账单总条数
bpager.setOpr("today");//设置查询类型
bpager.setFirstData(0);
bpager.setPageSize(1);
pager.setBillDate(new Date());//设置日期为当天
pager.setTotalCount(totalCount);//设置总数
pager.setPageSize(PagerTools.deskBillPagerSize);//设置每一页数据量
pager.count();//格式化数据
model.addAttribute("billSummarys", deskBillService.getBillSummarys(bpager));//当天账单汇总
List<Deskbill> deskBills=deskBillService.getDekBills(pager);//分页查询
pager.setList(deskBills);//将数据保存在pager对象内
model.addAttribute("deskBillpager", pager);
return "/bill/bill";
}
//ajax加载桌位账单详情
@RequestMapping("/getBillDetail.do")
@ResponseBody
public Object getBillDetail(Deskbill deskbill){
List<DeskInfo_detail> deskInfo_details=null;
if(deskbill!=null){
deskInfo_details=deskBillService.getDeskInfo_detailByDeskBillId(deskbill.getId());
}
return JSON.toJSONString(deskInfo_details);
}
//日账单
@RequestMapping("/dateBill.html")
public String showDateBill(HttpSession session,Model model,BillSummaryPager bpager){
if(session.getAttribute("user")==null){//权限控制
return "redirect:login.html";
}
if(bpager.getBeginDate()!=null && bpager.getEndDate()==null){//当只填写了开始日期时单独查询这天的账单
bpager.setOpr("otherday");
bpager.setOthDate(bpager.getBeginDate());
bpager.setTotalCount(1);//给pager设置总数据量
@Controller
public class UserController {
@Autowired
private UserService userService;
@ResponseBody
@RequestMapping("/addUser.do")
public Object addUser(User user){
return JSON.toJSONString(userService.addUser(user));
}
@RequestMapping("/showUserList.do")
public ModelAndView showUserList(ModelAndView modelAndView, Pager pager){
pager.setPageSize(PagerTools.deskBillPagerSize);
pager.setTotalCount(userService.getTotalCount(pager));
pager.count();
pager.setList(userService.showUserList(pager));
modelAndView.addObject("pager",pager);
modelAndView.setViewName("/daily/user/userList");
return modelAndView;
}
@RequestMapping("/delUserById.do")
@ResponseBody
public Object delUserById(User user){
return JSON.toJSONString(userService.delUserById(user));
if("".equals(pager.getOpr()) || pager.getOpr()==null){
modelAndView.addObject("provider",providerService.getProviderList(pager).get(0));
modelAndView.setViewName("daily/provider/updateProvider");
}else{
pager.setList(providerService.getProviderList(pager));
modelAndView.setViewName("daily/provider/providerList");
modelAndView.addObject("pager",pager);
}
return modelAndView;
}
//删除供应商
@RequestMapping("/delProviderById.do")
@ResponseBody
public Object delProviderById(Pager pager){
return JSON.toJSONString(providerService.delProviderById(pager));
}
//更改供应商
@RequestMapping("/updateProvider.do")
@ResponseBody
public Object updateProvider(Provider provider){
return JSON.toJSONString(providerService.updateProvider(provider));
}
}
}
//ajax验证菜品名是否存在
@ResponseBody
@RequestMapping("/dishNameIsExist.do")
public Object dishNameIsExist(@RequestParam(required = false) String dishName) {
boolean existFlag = false;
if (dishName != "" && dishName != null) {
existFlag = dishService.isExist(dishName);
}
if (existFlag) {
return JSON.toJSONString("0");//存在该菜品
}
return JSON.toJSONString("1");//不存在该菜品
}
//加载菜品列表
@ResponseBody
@RequestMapping("/dishList.do")
public ModelAndView dishList(Pager pager, ModelAndView modelAndView,
@RequestParam(required = false) String dishName) {
if (dishName == null || "".equals(dishName)) {//如果没有输入查询名字则当作opr=allDish
pager.setOpr("allDish");
}
modelAndView.setViewName("/daily/dish/dishList");
Dishes dishes = Dishes.getDishes();
pager.setPageSize(PagerTools.delDishListPagerSize);
if (dishes.getAllDishCount() == 0) {
if(redisUtil.getList("allDishes")==null){
redisUtil.addList("allDishes",dishService.getDish());
}
dishes.setAllDish(redisUtil.getList("allDishes"));
}
pager.setTotalCount(dishes.getAllDishCount());
if ("serchDish".equals(pager.getOpr())) {//优先查询
pager.setPageSize(dishes.getAllDishCount());//搜索时把所有菜品全部查出
System.out.println("~~~~~~~~~~~~~~~~~~~~~~" + dishName);
}
pager.count();
List<Dish> list = dishes.getAllDish(pager);
if ("serchDish".equals(pager.getOpr())) {//优先查询
List<Dish> serchList = new ArrayList<Dish>();
if (dishName != null && !"".equals(dishName)) {
System.out.println("~~~~~~~~查找相同菜品的数据~~~~~~~~~~");
for (Dish dish : list) {
if(dish.getDishName().contains(dishName)){
System.out.println("~~~~~~~~~~~找到与"+dishName+"相似的菜品~~~~~~~~~~~");
@Controller
public class DeskBillController {
@Autowired
private DeskBillService deskBillService;
@Resource(name="redisUtil")
private RedisUtil redisUtil;
@Autowired
private DeskService deskService;
// ajax结账
@RequestMapping("/pay.do")
@ResponseBody
public Object pay(Deskbill deskBill) {
deskBill.setBillCode(BillCodeUtil.getBillCode());// 设置账单编号为当前毫秒数
deskBillService.addDeskBill(deskBill);//添加账单
int deskBillId=deskBill.getId();//得到本次账单的id
int deskId=deskBill.getDeskId();//得到该账单所属的桌位id
Desk desk=deskService.getDeskById(deskId+"");//查询该ID的桌位
String deskCode=desk.getDeskCode();//得到桌位编号
//从缓存取出菜单列表,并且遍历账单列表一条一条插入账单详情
List<DeskInfo_detail> deskDishes=redisUtil.getList(deskCode);//取出菜单列表
if(deskDishes!=null){
for (DeskInfo_detail deskInfo_detail : deskDishes) {
if(deskInfo_detail.getDrinkBillCode()!=null && !deskInfo_detail.getDrinkBillCode().equals("")){//增加销售信息
deskBillService.sellDrink(deskInfo_detail.getDrinkBillCode(),deskInfo_detail.getDishNum());
}
deskInfo_detail.setDeskBillId(deskBillId);
deskBillService.addDeskBillDetail(deskInfo_detail);
}
//滞空桌位号码,删除缓存内数据
redisUtil.del(deskCode);//删除缓存数据
desk.setStatus(1);
//删除桌位
@ResponseBody
@RequestMapping("/delDesk.do")
public Object delDesk(@RequestParam(required=false) String id){
int data=deskService.delDesk(id);
return JSON.toJSONString(data);
}
//更改桌位
@ResponseBody
@RequestMapping("/alertDesk.do")
public Object delDesk(Desk desk){
boolean data=deskService.updateDesk(desk);
return JSON.toJSONString(data?"1":"0");
}
}
return JSON.toJSONString(deskDish);
}
//更改桌位状态
@RequestMapping("/changeStatus.do")
@ResponseBody
public Object changeDeskStatus(Desk desk){
boolean flag=false;
if(desk!=null){
if(desk.getStatus()!=null && desk.getStatus()!=2 ){
desk.setStatus(2);
flag=deskService.updateDeskStatus(desk);
}else{
return JSON.toJSONString("OK");
}
}
if(flag){
return JSON.toJSONString("OK");
}else{
return JSON.toJSONString("NO");
}
}
//更改桌位
@RequestMapping("/changeDesk.do")
@ResponseBody
public Object changeDesk(Desk desk){
boolean flag=deskService.updateDesk(desk);
String str="";
if(flag){
str="true";
}else{
str="false";
}
return JSON.toJSONString(str);
}
//更改菜品
@RequestMapping("/updateDish.do")
@ResponseBody
public Object updateDish(DeskInfo_detail deskInfo_detail,@RequestParam(required=false)String deskCode){
List<DeskInfo_detail> deskDish=redisUtil.getList(deskCode);
for (int i = 0; i < deskDish.size(); i++) {
if(deskDish.get(i).getDishName().equals(deskInfo_detail.getDishName())){//找到相同的菜品
String newContent=deskInfo_detail.getContent();//得到新的备注
@RequestMapping(value="login.html",method=RequestMethod.GET)
public String showLogin(){
return "login";
}
//处理登录
@RequestMapping(value="login.html",method=RequestMethod.POST)
public String doLogin(User user,HttpSession session,Model model){
User logUser=userService.login(user);
if(logUser!=null){
session.setAttribute("user", logUser);
return "redirect:desklist.html?show=desk";
}else{
model.addAttribute("error", "账号和密码不匹配");
return "login";
}
}
//处理注销
@RequestMapping(value="/logout.html")
public String logout(HttpSession session){
session.invalidate();
return "redirect:login.html";
}
}
/**
* 日志增强
*/
public class AdviceLog {
private static final Logger log=Logger.getLogger(AdviceLog.class);
/**
* 前置增强
Dishes dishes = Dishes.getDishes();
pager.setPageSize(PagerTools.delDishListPagerSize);
if (dishes.getAllDishCount() == 0) {
if(redisUtil.getList("allDishes")==null){
redisUtil.addList("allDishes",dishService.getDish());
}
dishes.setAllDish(redisUtil.getList("allDishes"));
}
pager.setTotalCount(dishes.getAllDishCount());
if ("serchDish".equals(pager.getOpr())) {//优先查询
pager.setPageSize(dishes.getAllDishCount());//搜索时把所有菜品全部查出
System.out.println("~~~~~~~~~~~~~~~~~~~~~~" + dishName);
}
pager.count();
List<Dish> list = dishes.getAllDish(pager);
if ("serchDish".equals(pager.getOpr())) {//优先查询
List<Dish> serchList = new ArrayList<Dish>();
if (dishName != null && !"".equals(dishName)) {
System.out.println("~~~~~~~~查找相同菜品的数据~~~~~~~~~~");
for (Dish dish : list) {
if(dish.getDishName().contains(dishName)){
System.out.println("~~~~~~~~~~~找到与"+dishName+"相似的菜品~~~~~~~~~~~");
serchList.add(dish);
}
}
pager.setList(serchList);
}
} else {
pager.setList(list);
}
modelAndView.addObject("pager", pager);
return modelAndView;
}
//ajax删除菜品
@ResponseBody
@RequestMapping("/delDishFromMenu.do")
public Object delDish(@RequestParam(required = false)String id){
System.out.println("~~~~~~~~~~~~~~开始删除Dish~~~~~~~~~~~~~~~");
boolean delFlag=false;
System.out.println("~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~id="+id);
if(id!=null && !"".equals(id)){
System.out.println("~~~~~~~~~~~~~~~进入删除~~~~~~~~~~~~~~~~");
delFlag=dishService.delDishById(id);
}
if(delFlag){//删除成功
System.out.println("~~~~~~~~~~~~~~删除Dish成功~~~~~~~~~~~~~~~");
redisUtil.del("allDishes");//刷新redis
return "/desk/deskinfo";
}
//ajax点菜
@RequestMapping("/selectDish.do")
@ResponseBody
public Object selectDish(DeskInfo_detail deskInfo_detail,@RequestParam(required=false)String deskCode){
List<DeskInfo_detail> deskDish=redisUtil.getList(deskCode);
if(deskDish==null){
deskDish=new ArrayList<DeskInfo_detail>();
System.out.println("------------------------------新建桌位号"+deskCode+"菜单列表------------------------------");
}
boolean addFlag=true;//标记是否有相同的菜品,默认为true表名不存在相同菜名
for (int i = 0; i < deskDish.size(); i++) {
if(deskDish.get(i).getDishName().equals(deskInfo_detail.getDishName())){//如果存在相同的菜品
int oldNum=deskDish.get(i).getDishNum();//得到原来的数目
String newContent=deskInfo_detail.getContent();
int newNum=oldNum+deskInfo_detail.getDishNum();//将新添加的数目和原来的数目相加得到新数目
deskDish.get(i).setDishNum(newNum);//修改数目
deskDish.get(i).setCost(newNum*deskDish.get(i).getPrice());//修改小计
deskDish.get(i).setContent(newContent);
addFlag=false;//存在相同的,将标记设置为false
break;
}
}
if(addFlag){//如果不存在相同的菜品,addFlag的值为true
deskDish.add(deskInfo_detail);
}
redisUtil.addList(deskCode, deskDish);//更新缓存
return JSON.toJSONString(deskDish);
}
//更改桌位状态
@RequestMapping("/changeStatus.do")
@ResponseBody
public Object changeDeskStatus(Desk desk){
boolean flag=false;
if(desk!=null){
if(desk.getStatus()!=null && desk.getStatus()!=2 ){
desk.setStatus(2);
flag=deskService.updateDeskStatus(desk);
}else{
return JSON.toJSONString("OK");
}
}
if(flag){
return JSON.toJSONString("OK");
}else{
return JSON.toJSONString("NO");
}
}
@Controller
public class DrinkController {
@Autowired
private ProviderService providerService;
@RequestMapping("/drink.html")
public String drink(HttpSession session) {
if(session.getAttribute("user")==null){//权限控制
return "redirect:login.html";
}
return "/drink/drink";
}
//加载供应下拉列表
@RequestMapping("/loadProviderSelect.do")
@ResponseBody
public Object loadProviderSelect() {
return JSON.toJSONString(providerService.getProvider());
}
//加载进货信息
@RequestMapping("/loadDrinkBill.do")
@ResponseBody
public ModelAndView loadDrinkBill(ModelAndView modelAndView, DrinkBillPager pager) {
int totalCount = providerService.getDrinkBillCount(pager);
if (totalCount != 0) {
pager.setTotalCount(totalCount);
} else {
pager.setTotalCount(1);
}
pager.setPageSize(PagerTools.drinkBillPagerSize);
pager.count();
pager.setList(providerService.getDrinkBill(pager));
modelAndView.addObject("pager", pager);
modelAndView.setViewName("/drink/ajaxJinhuoList");
return modelAndView;
}
//加载进货信息
@RequestMapping("/loadDrinkBillCode.do")
@ResponseBody
public Object loadDrinkBillCode(DrinkBillPager pager) {
int totalCount = providerService.getDrinkBillCount(pager);
if (totalCount != 0) {
pager.setTotalCount(totalCount);
} else {
return JSON.toJSONString(providerService.updateProvider(provider));
}
}
@Controller
public class UserController {
@Autowired
private UserService userService;
@ResponseBody
@RequestMapping("/addUser.do")
public Object addUser(User user){
return JSON.toJSONString(userService.addUser(user));
}
@RequestMapping("/showUserList.do")
public ModelAndView showUserList(ModelAndView modelAndView, Pager pager){
pager.setPageSize(PagerTools.deskBillPagerSize);
pager.setTotalCount(userService.getTotalCount(pager));
pager.count();
pager.setList(userService.showUserList(pager));
modelAndView.addObject("pager",pager);
modelAndView.setViewName("/daily/user/userList");
return modelAndView;
}
@RequestMapping("/delUserById.do")
@ResponseBody
public Object delUserById(User user){
return JSON.toJSONString(userService.delUserById(user));
}
@RequestMapping("/updateUser.do")
@ResponseBody
public Object addProvider(Provider provider){
return JSON.toJSONString(providerService.addProvider(provider));
}
//验证供应商是否存在
@RequestMapping("/isProExist.do")
@ResponseBody
public Object isProExist(@RequestParam(required = false) String proName){
return JSON.toJSONString(providerService.isProExist(proName));
}
//加载供应商列表
@RequestMapping("/showProviderList.do")
public ModelAndView showProviderList(ModelAndView modelAndView,Pager pager){
pager.setTotalCount(providerService.getTotalCount(pager));
pager.setPageSize(3);
pager.count();
if("".equals(pager.getOpr()) || pager.getOpr()==null){
modelAndView.addObject("provider",providerService.getProviderList(pager).get(0));
modelAndView.setViewName("daily/provider/updateProvider");
}else{
pager.setList(providerService.getProviderList(pager));
modelAndView.setViewName("daily/provider/providerList");
modelAndView.addObject("pager",pager);
}
return modelAndView;
}
//删除供应商
@RequestMapping("/delProviderById.do")
@ResponseBody
public Object delProviderById(Pager pager){
return JSON.toJSONString(providerService.delProviderById(pager));
}
//更改供应商
@RequestMapping("/updateProvider.do")
@ResponseBody
public Object updateProvider(Provider provider){
return JSON.toJSONString(providerService.updateProvider(provider));
}
}
@Controller
public class DeskController {
@Autowired
private DeskService deskService;
@Resource(name="redisUtil")
private RedisUtil redisUtil;
@Autowired
private DishMapper dishMapper;
//显示桌位列表页面
@RequestMapping(value="/desklist.html")
public String showDeskList(Model model, HttpSession session, @RequestParam(required=false)String show){
if(session.getAttribute("user")==null){//权限控制
return "redirect:login.html";
}
List<Desk> desks=deskService.getDesks();
model.addAttribute("desks", desks);
if(!"desk".equals(show)){
return "redirect:desklist.html?show=desk";
}else{
return "/desk/desklist";
}
}
//桌位详情页面
@RequestMapping(value="/deskinfo.html")
public String showDeskInfo(@RequestParam(required=false)String id,Model model,HttpSession session){
if(session.getAttribute("user")==null){//权限控制
return "redirect:login.html";
}
Desk desk=null;
int status=0;
String deskCode=null;
if(id!=null && id!=""){
desk=deskService.getDeskById(id);
@RequestMapping("/delDesk.do")
public Object delDesk(@RequestParam(required=false) String id){
int data=deskService.delDesk(id);
return JSON.toJSONString(data);
}
//更改桌位
@ResponseBody
@RequestMapping("/alertDesk.do")
public Object delDesk(Desk desk){
boolean data=deskService.updateDesk(desk);
return JSON.toJSONString(data?"1":"0");
}
}
@Controller
public class DeskBillController {
@Autowired
private DeskBillService deskBillService;
@Resource(name="redisUtil")
private RedisUtil redisUtil;
bpager.setTotalCount(billSummaryCount);//给pager设置总数据量
bpager.setPageSize(PagerTools.billSummaryPagerSize);//设置页面大小
bpager.count();//格式化数据
}
bpager.setList(deskBillService.getBillSummarys(bpager));
model.addAttribute("bpager", bpager);
return "/bill/datebill";
}
//日详情
@ResponseBody
@RequestMapping("/ajax")
public ModelAndView ajax(ModelAndView m,DeskBillPager dpager,BillSummaryPager bpager){
int totalCount=deskBillService.getCount(dpager.getBillDate());//查询当天账单总条数
bpager.setOpr("otherday");//设置查询类型
bpager.setFirstData(0);
bpager.setPageSize(1);
dpager.setTotalCount(totalCount);//设置总数
dpager.setPageSize(PagerTools.deskBillPagerSize);//设置每一页数据量
dpager.count();//格式化数据
Map map=new HashMap();
map.put("billSummarys", deskBillService.getBillSummarys(bpager));//当天账单汇总
List<Deskbill> deskBills=deskBillService.getDekBills(dpager);//分页查询
dpager.setList(deskBills);//将数据保存在pager对象内
m.setViewName("/bill/dateDetail");
map.put("deskBillpager", dpager);
m.addAllObjects(map);
m.addObject("a", "CHANGEX");
return m;
}
//ajax查看账单曲线
@RequestMapping("/chart.do")
@ResponseBody
public Object showDateChart(BillSummaryPager bpager){
List<BillSummary> billSummarys=deskBillService.getBillSummarys(bpager);
return JSON.toJSONString(billSummarys);
};
//月账单
@RequestMapping("/monthBill.html")
public String showMonthBill(HttpSession session,Model model,BillSummaryPager bpager){
if(session.getAttribute("user")==null){//权限控制
return "redirect:login.html";
}
bpager.setOpr("month");
int billSummaryCount=deskBillService.getBillSummaryCount(bpager);//得到总数据量
bpager.setTotalCount(billSummaryCount);//给pager设置总数据量
bpager.setPageSize(PagerTools.billSummaryPagerSize);//设置页面大小
model.addAttribute("bpager", bpager);
return "/bill/datebill";
}
//日详情
@ResponseBody
@RequestMapping("/ajax")
public ModelAndView ajax(ModelAndView m,DeskBillPager dpager,BillSummaryPager bpager){
int totalCount=deskBillService.getCount(dpager.getBillDate());//查询当天账单总条数
bpager.setOpr("otherday");//设置查询类型
bpager.setFirstData(0);
bpager.setPageSize(1);
dpager.setTotalCount(totalCount);//设置总数
dpager.setPageSize(PagerTools.deskBillPagerSize);//设置每一页数据量
dpager.count();//格式化数据
Map map=new HashMap();
map.put("billSummarys", deskBillService.getBillSummarys(bpager));//当天账单汇总
List<Deskbill> deskBills=deskBillService.getDekBills(dpager);//分页查询
dpager.setList(deskBills);//将数据保存在pager对象内
m.setViewName("/bill/dateDetail");
map.put("deskBillpager", dpager);
m.addAllObjects(map);
m.addObject("a", "CHANGEX");
return m;
}
//ajax查看账单曲线
@RequestMapping("/chart.do")
@ResponseBody
public Object showDateChart(BillSummaryPager bpager){
List<BillSummary> billSummarys=deskBillService.getBillSummarys(bpager);
return JSON.toJSONString(billSummarys);
};
//月账单
@RequestMapping("/monthBill.html")
public String showMonthBill(HttpSession session,Model model,BillSummaryPager bpager){
if(session.getAttribute("user")==null){//权限控制
return "redirect:login.html";
}
bpager.setOpr("month");
}
bpager.setOpr("month");
int billSummaryCount=deskBillService.getBillSummaryCount(bpager);//得到总数据量
bpager.setTotalCount(billSummaryCount);//给pager设置总数据量
bpager.setPageSize(PagerTools.billSummaryPagerSize);//设置页面大小
bpager.count();//格式化数据
bpager.setList(deskBillService.getBillSummarys(bpager));
model.addAttribute("bpager", bpager);
return "/bill/monthbill";
}
//年账单
@RequestMapping("/yearBill.html")
public String showYearBill(HttpSession session, Model model, BillSummaryPager bpager){
if(session.getAttribute("user")==null){//权限控制
return "redirect:login.html";
}
bpager.setOpr("year");
int billSummaryCount=deskBillService.getBillSummaryCount(bpager);//得到总数据量
bpager.setTotalCount(billSummaryCount);//给pager设置总数据量
bpager.setPageSize(PagerTools.billSummaryPagerSize);//设置页面大小
bpager.count();//格式化数据
bpager.setList(deskBillService.getBillSummarys(bpager));
model.addAttribute("bpager", bpager);
return "/bill/yearbill";
}
}
@Controller