基于javaweb+mysql的ssm餐厅点餐收银管理系统(java+ssm+jsp+bootstrap+mysql+redis)

基于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数据库;

技术栈

  1. 后端:Spring+SpringMVC+Mybatis 2. 前端:JSP+Bootstrap+jQuery

使用说明

  1. 使用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

请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值