package com.happy.service.impl;

import com.happy.Model.*;
import com.happy.dao.ElecDao;
import com.happy.dao.WaterDao;
import com.happy.service.WaterService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service("WaterService")
public class WaterServiceImpl implements WaterService {

    @Autowired
    public WaterDao waterDao;

    public List<Build_water> getbuild(int page, int rows){
        return waterDao.getbuild(page, rows);
    }

    public int findPageTotal(){
        return waterDao.findPageTotal();
    }

    public List<Build_water> findAllN(String s1) {
        StringBuffer sql = new StringBuffer("select * from build_water where 1=1 ");
        if (s1 != null && !s1.equals("")) {
            sql.append(s1);
        }
        return this.waterDao.findAll(sql.toString());
    }

    public int total(String s1){
        StringBuffer sql = new StringBuffer("select count(*) from build_water where 1=1 ");
        if (s1 != null && !s1.equals("")) {
            sql.append(s1);
        }
        return this.waterDao.total(sql.toString());
    }

    public int updateBuild(Build_water build_water){
        return this.waterDao.updateBuild(build_water);
    }

    public int delBuild(int id){
        return this.waterDao.delBuild(id);
    }

    public int addBuild(Build_water build_water){
        return this.waterDao.addBuild(build_water);
    }

    public List<Users> queryMoney(int page, int rows, String s1){
        return this.waterDao.queryMoney(page, rows, s1);
    }

    public int findUsersTotal(String s1){
        return this.waterDao.findUsersTotal(s1);
    }

    public List<Recharge> chargeRecord(String s1){
        StringBuffer sql = new StringBuffer("select * from recharge where pay_state=2 ");
        if (s1 != null && !s1.equals("")) {
            sql.append(s1);
        }
        System.out.println(sql);
        return this.waterDao.chargeRecord(sql.toString());
    }

    public int chargeTotal(String s1){
        StringBuffer sql = new StringBuffer("select count(*) from recharge where pay_state=2 ");
        if (s1 != null && !s1.equals("")) {
            sql.append(s1);
        }
        return this.waterDao.total(sql.toString());
    }

    public int findComTotal(String sqlx){
        StringBuffer sql = new StringBuffer("select count(*) from consume a, build_water b where a.device_code=b.user_id ");
        if (sqlx != null && !sqlx.equals("")) {
            sql.append(sqlx);
        }
        return this.waterDao.findComTotal(sql.toString());
    }

    public List<Consume> findCom(String s1){
        StringBuffer sql = new StringBuffer("select a.stu_number, a.user_name, a.use_amount, a.use_size, b.build, b.dom, a.begin_time from consume a, build_water b where a.device_code=b.user_id ");
        if (s1 != null && !s1.equals("")) {
            sql.append(s1);
        }
        System.out.println(sql);
        return this.waterDao.findCom(sql.toString());
    }

    public int insertPrice(Price price){
        return this.waterDao.insertPrice(price);
    }

    public int passPrice(String time2){
        return this.waterDao.passPrice(time2);
    }

    public List<Price> queryPrice(int page, int rows){
        return this.waterDao.queryPrice(page, rows);
    }

    public int findPriceTotal(){
        return waterDao.findPriceTotal();
    }

    public List<Admin> queryAdmin(int page, int rows, String s1){
        return this.waterDao.queryAdmin(page, rows, s1);
    }

    public int findAdminTotal(String s1){
        return this.waterDao.findAdminTotal(s1);
    }

    public List<Admin> queryAdminByNum(String number){
        return waterDao.queryAdminByNum(number);
    }

    public int addAdmin(Admin admin){
        return waterDao.addAdmin(admin);
    }

    public int delAdmin(int id){
        return waterDao.delAdmin(id);
    }

    public int updateAdmin(Admin admin){
        return waterDao.updateAdmin(admin);
    }

    public List<Admin> login(String number, String password){
        return waterDao.login(number, password);
    }

    public List<Recharge> findErrorPayByNo(int page, int rows){
        return waterDao.findErrorPayByNo(page, rows);
    }

    public int findErrorPayTotal(){
        return waterDao.findErrorPayTotal();
    }

    public int updateErrorWaterPay(int id){
        return waterDao.updateErrorWaterPay(id);
    }

    public List<Recharge_elc> findErrorElcPayByNo(int page, int rows){
        return waterDao.findErrorElcPayByNo(page, rows);
    }

    public int findErrorElecTotal(){
        return waterDao.findErrorElecTotal();
    }

    public int updateErrorElecPay(int id){
        return waterDao.updateErrorElecPay(id);
    }

    public List<ErrorWaterPay> queryErrorPay(String s1, String s2){
        return waterDao.queryErrorPay(s1, s2);
    }

    public int queryErrorwaterTotal(String s1, String s3){
        return waterDao.queryErrorwaterTotal(s1, s3);
    }

    public List<Build_water> queryByUserId(String sqlx){
        return waterDao.queryByUserId(sqlx);
    }

    public List<Recharge> queryByTime(String sql){
        return waterDao.queryByTime(sql);
    }

    public int queryReTotal(String sql){
        return waterDao.queryReTotal(sql);
    }

    public long queryReOther(String sql){
        return waterDao.queryReOther(sql);
    }
}