package manage

import (
	"fmt"
	"strconv"
	"vamicro/iotData-service/model"
	"vamicro/iotData-service/serializer"
)

type ListDeviceService struct {
	BatteryStart string `form:"batteryStart" json:"batteryStart"` //电量左区间
	BatteryEnd   string `form:"batteryEnd" json:"batteryEnd"`     //电量👉区间
	SN           string `form:"sn" json:"sn"`                     //设备编码
	Page         int    `form:"page" json:"page"`                 //页码
	PageSize     int    `form:"pageSize" json:"pageSize"`         //分页大小
}

func (service *ListDeviceService) List() serializer.Response {
	devices := []model.Device{}

	var total int64
	code := 200
	db := model.DB.Table("devices")
	if service.SN != "" {
		obj := model.DrawZone{}
		err := obj.FindByName(service.SN)
		if err == nil {
			return serializer.Response{
				Status: 200,
				Msg:    "zone",
				Data:   obj,
			}
		} else {
			fmt.Println("find zone error:::", err)
		}
		db = db.Where("sn like ?", "%"+service.SN+"%")
	}
	start, _ := strconv.Atoi(service.BatteryStart)
	end, _ := strconv.Atoi(service.BatteryEnd)

	if service.BatteryStart != "" && service.BatteryEnd != "" {
		db = db.Where("battery BETWEEN ? AND ?", start, end)
	} else if service.BatteryStart != "" {
		db = db.Where("battery >= ?", start)
	} else if service.BatteryEnd != "" {
		db = db.Where("battery <= ?", end)
	}

	if err := db.Count(&total).Error; err != nil {
		code = 30001
		return serializer.Response{
			Status: code,
			Msg:    "数据库错误 count",
			Error:  err.Error(),
		}
	}
	if service.PageSize == 0 && service.Page == 0 {
		if err := db.Find(&devices).Error; err != nil {
			code = 30001
			return serializer.Response{
				Status: code,
				Msg:    "数据库错误",
				Error:  err.Error(),
			}
		}
	} else {
		if err := db.Limit(service.PageSize).Offset((service.Page - 1) * service.PageSize).Find(&devices).Error; err != nil {
			code = 30001
			return serializer.Response{
				Status: code,
				Msg:    "数据库错误",
				Error:  err.Error(),
			}
		}
	}
	return serializer.BuildListResponse(serializer.BuildDevicesRsp(devices), uint(total))
}