package com.happy.service.impl;

import com.happy.Model.Booking;
import com.happy.dao.BookDao;
import com.happy.dto.IPage;
import com.happy.service.BookService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;

@Service("BookService")
public class BookImplService implements BookService {

    @Resource
    public BookDao bookDao;

    @Override
    public int insertBooking(Booking book) {
        return bookDao.insertBooking(book);
    }

    @Override
    public int updateBooking(Booking book) {
        return bookDao.updateBooking(book);
    }

    @Override
    public int delBooking(int id) {
        return bookDao.delBooking(id);
    }

    @Override
    public Booking getById(int id) {
        return bookDao.getById(id);
    }

    @Override
    public IPage<Booking> queryPage(String sqlx, int page, int rows) {
        IPage<Booking> iPage = new IPage();
        List<Booking> bookList = bookDao.queryPage(sqlx,page,rows);
        int total = bookDao.queryTotal(sqlx);
        iPage.setPageList(bookList);
        iPage.setPage(page);
        iPage.setTotalPage( (int)Math.ceil((double)total/rows));
        iPage.setRows(rows);
        iPage.setTotal(total);
        return iPage;
    }

    @Override
    public List<Booking> queryList(String sqlx) {
        return bookDao.queryList(sqlx);
    }

    @Override
    public Booking getOen(String sqlx){
        List<Booking> list = bookDao.queryList(sqlx);
        if(list!=null && list.size()>0) return list.get(0);
        return null;
    }
}