package dao

import (
	"github.com/druidcaesa/gotool"
	"ulink-admin/frame"
	"ulink-admin/modules/car/models/model"
	"ulink-admin/modules/car/models/req"
	"ulink-admin/pkg/base"
	"ulink-admin/pkg/page"
)

type DriverDao struct {
	base.BaseDao
}

// Page 查询驾驶员分页数据
func (this DriverDao) Page(query *req.DriverQuery, list interface{}) int64 {
	session := this.GetSession().Table(model.Driver{}.TableName())

	if query.Id > 0 {
		session.And("id = ?", query.Id)
	}
	if !gotool.StrUtils.HasEmpty(query.Label) {
		session.And("label like concat('%', ?, '%')", query.Label)
	}
	if !gotool.StrUtils.HasEmpty(query.Photo) {
		session.And("photo = ?", query.Photo)
	}
	if !gotool.StrUtils.HasEmpty(query.IdCard) {
		session.And("id_card = ?", query.IdCard)
	}
	if !gotool.StrUtils.HasEmpty(query.ServiceNo) {
		session.And("service_no = ?", query.ServiceNo)
	}
	if !gotool.StrUtils.HasEmpty(query.Card) {
		session.And("card = ?", query.Card)
	}
	if query.Sex > 0 {
		session.And("sex = ?", query.Sex)
	}
	if !gotool.StrUtils.HasEmpty(query.CarNo) {
		session.And("car_no = ?", query.CarNo)
	}
	if !gotool.StrUtils.HasEmpty(query.JobNo) {
		session.And("job_no = ?", query.JobNo)
	}
	if !gotool.StrUtils.HasEmpty(query.DriverNo) {
		session.And("driver_no = ?", query.DriverNo)
	}
	if !gotool.StrUtils.HasEmpty(query.DriverType) {
		session.And("driver_type = ?", query.DriverType)
	}
	if !gotool.StrUtils.HasEmpty(query.GiveDate) {
		session.And("give_date = ?", query.GiveDate)
	}
	if !gotool.StrUtils.HasEmpty(query.Phone) {
		session.And("phone = ?", query.Phone)
	}
	if !gotool.StrUtils.HasEmpty(query.Address) {
		session.And("address = ?", query.Address)
	}
	if query.Status > 0 {
		session.And("status = ?", query.Status)
	}
	if query.EntryType > 0 {
		session.And("entry_type = ?", query.EntryType)
	}
	if !gotool.StrUtils.HasEmpty(query.Level) {
		session.And("level = ?", query.Level)
	}
	if query.CompanyId > 0 {
		session.And("company_id = ?", query.CompanyId)
	}
	if !gotool.StrUtils.HasEmpty(query.RecordNo) {
		session.And("record_no = ?", query.RecordNo)
	}
	if !gotool.StrUtils.HasEmpty(query.FirstDate) {
		session.And("first_date = ?", query.FirstDate)
	}
	if !gotool.StrUtils.HasEmpty(query.EntryDate) {
		session.And("entry_date = ?", query.EntryDate)
	}
	if !gotool.StrUtils.HasEmpty(query.ValidStart) {
		session.And("valid_start = ?", query.ValidStart)
	}
	if !gotool.StrUtils.HasEmpty(query.ValidEnd) {
		session.And("valid_end = ?", query.ValidEnd)
	}
	if !gotool.StrUtils.HasEmpty(query.ChangeDate) {
		session.And("change_date = ?", query.ChangeDate)
	}
	if query.IsTrain > 0 {
		session.And("is_train = ?", query.IsTrain)
	}
	if query.IsSign > 0 {
		session.And("is_sign = ?", query.IsSign)
	}
	if query.IsFull > 0 {
		session.And("is_full = ?", query.IsFull)
	}
	if query.IsCheck > 0 {
		session.And("is_check = ?", query.IsCheck)
	}
	if !gotool.StrUtils.HasEmpty(query.Remark) {
		session.And("remark = ?", query.Remark)
	}
	if !gotool.StrUtils.HasEmpty(query.CreateBy) {
		session.And("create_by = ?", query.CreateBy)
	}
	if !gotool.StrUtils.HasEmpty(query.UpdateBy) {
		session.And("update_by = ?", query.UpdateBy)
	}
	if !gotool.StrUtils.HasEmpty(query.BeginTime) {
		session.And("date_format(u.create_time,'%y%m%d') >= date_format(?,'%y%m%d')", query.BeginTime)
	}
	if !gotool.StrUtils.HasEmpty(query.EndTime) {
		session.And("date_format(u.create_time,'%y%m%d') <= date_format(?,'%y%m%d')", query.EndTime)
	}
	session.Desc("id")
	total, err := session.Limit(query.PageSize, page.StartSize(query.PageNum, query.PageSize)).FindAndCount(list)
	if err != nil {
		frame.Throw(frame.SQL_CODE, "数据查询错误"+err.Error())
	}
	return total
}

// List 查询驾驶员分页数据
func (this DriverDao) List(query *req.DriverQuery, list interface{}) {
	session := this.GetSession().Table(model.Driver{}.TableName())

	if query.Id > 0 {
		session.And("id = ?", query.Id)
	}
	if !gotool.StrUtils.HasEmpty(query.Label) {
		session.And("label like concat('%', ?, '%')", query.Label)
	}
	if !gotool.StrUtils.HasEmpty(query.Photo) {
		session.And("photo = ?", query.Photo)
	}
	if !gotool.StrUtils.HasEmpty(query.IdCard) {
		session.And("id_card = ?", query.IdCard)
	}
	if !gotool.StrUtils.HasEmpty(query.ServiceNo) {
		session.And("service_no = ?", query.ServiceNo)
	}
	if !gotool.StrUtils.HasEmpty(query.Card) {
		session.And("card = ?", query.Card)
	}
	if query.Sex > 0 {
		session.And("sex = ?", query.Sex)
	}
	if !gotool.StrUtils.HasEmpty(query.CarNo) {
		session.And("car_no = ?", query.CarNo)
	}
	if !gotool.StrUtils.HasEmpty(query.JobNo) {
		session.And("job_no = ?", query.JobNo)
	}
	if !gotool.StrUtils.HasEmpty(query.DriverNo) {
		session.And("driver_no = ?", query.DriverNo)
	}
	if !gotool.StrUtils.HasEmpty(query.DriverType) {
		session.And("driver_type = ?", query.DriverType)
	}
	if !gotool.StrUtils.HasEmpty(query.GiveDate) {
		session.And("give_date = ?", query.GiveDate)
	}
	if !gotool.StrUtils.HasEmpty(query.Phone) {
		session.And("phone = ?", query.Phone)
	}
	if !gotool.StrUtils.HasEmpty(query.Address) {
		session.And("address = ?", query.Address)
	}
	if query.Status > 0 {
		session.And("status = ?", query.Status)
	}
	if query.EntryType > 0 {
		session.And("entry_type = ?", query.EntryType)
	}
	if !gotool.StrUtils.HasEmpty(query.Level) {
		session.And("level = ?", query.Level)
	}
	if query.CompanyId > 0 {
		session.And("company_id = ?", query.CompanyId)
	}
	if !gotool.StrUtils.HasEmpty(query.RecordNo) {
		session.And("record_no = ?", query.RecordNo)
	}
	if !gotool.StrUtils.HasEmpty(query.FirstDate) {
		session.And("first_date = ?", query.FirstDate)
	}
	if !gotool.StrUtils.HasEmpty(query.EntryDate) {
		session.And("entry_date = ?", query.EntryDate)
	}
	if !gotool.StrUtils.HasEmpty(query.ValidStart) {
		session.And("valid_start = ?", query.ValidStart)
	}
	if !gotool.StrUtils.HasEmpty(query.ValidEnd) {
		session.And("valid_end = ?", query.ValidEnd)
	}
	if !gotool.StrUtils.HasEmpty(query.ChangeDate) {
		session.And("change_date = ?", query.ChangeDate)
	}
	if query.IsTrain > 0 {
		session.And("is_train = ?", query.IsTrain)
	}
	if query.IsSign > 0 {
		session.And("is_sign = ?", query.IsSign)
	}
	if query.IsFull > 0 {
		session.And("is_full = ?", query.IsFull)
	}
	if query.IsCheck > 0 {
		session.And("is_check = ?", query.IsCheck)
	}
	if !gotool.StrUtils.HasEmpty(query.Remark) {
		session.And("remark = ?", query.Remark)
	}
	if !gotool.StrUtils.HasEmpty(query.CreateBy) {
		session.And("create_by = ?", query.CreateBy)
	}
	if !gotool.StrUtils.HasEmpty(query.UpdateBy) {
		session.And("update_by = ?", query.UpdateBy)
	}
	if !gotool.StrUtils.HasEmpty(query.BeginTime) {
		session.And("date_format(u.create_time,'%y%m%d') >= date_format(?,'%y%m%d')", query.BeginTime)
	}
	if !gotool.StrUtils.HasEmpty(query.EndTime) {
		session.And("date_format(u.create_time,'%y%m%d') <= date_format(?,'%y%m%d')", query.EndTime)
	}
	session.Desc("id")
	err := session.Find(list)
	if err != nil {
		frame.Throw(frame.SQL_CODE, "数据查询错误"+err.Error())
	}
}