package suppliercertsub

import (
	"strconv"

	. "dashoo.cn/backend/api/mydb"
	"dashoo.cn/utils"
	. "dashoo.cn/utils/db"
	"github.com/go-xorm/xorm"
)

type OilSupplierCertSubService struct {
	MyServiceBase
}

func GetOilSupplierCertSubService(xormEngine *xorm.Engine) *OilSupplierCertSubService {
	s := new(OilSupplierCertSubService)
	s.DBE = xormEngine
	return s
}

////获取待审核业务列表
//func (s *OilSupplierCertSubService) GetWaitAuditBusinesslist(pageIndex, itemsPerPage int64, order string, certsub, orgsetting string, where string) (int64, []OilSupplierCertSub) {
//	var err error
//	var total int64
//	if where == "" {
//		where = " 1=1 "
//	}
//	//获取总记录数
//	sqlCount := `select count(*) from ` + certsub + ` a
//	left join ` + orgsetting + ` b on a.SubClassId=b.ClassId and a.SupplierTypeCode = b.SupplierTypeCode
//	left join Base_User c on b.OrganizeId = c.DepartmentId
//	where ` + where
//	var sql string
//	sql = `select a.*
//	from ` + certsub + ` a
//	left join ` + orgsetting + ` b on a.SubClassId=b.ClassId and a.SupplierTypeCode = b.SupplierTypeCode
//	left join Base_User c on b.OrganizeId = c.DepartmentId
//	where ` + where + ` order by ` + order +
//		` limit ` + utils.ToStr((pageIndex-1)*itemsPerPage) + "," + utils.ToStr(itemsPerPage)
//
//	List := make([]OilSupplierCertSub, 0)
//	utils.DBE.Sql(sql).Find(&List)
//
//	resultsSlice, err := s.DBE.Query(sqlCount)
//	LogError(err)
//	if len(resultsSlice) > 0 {
//		results := resultsSlice[0]
//		for _, value := range results {
//			total, err = strconv.ParseInt(string(value), 10, 64)
//			LogError(err)
//			break
//		}
//	}
//	return total, List
//}

//获取待审核业务列表
func (s *OilSupplierCertSubService) GetWaitAuditBusinesslist(pageIndex, itemsPerPage int64, order string, certsub, orgsetting string, where string) (int64, []OilSupplierCertSub) {
	var err error
	var total int64
	if where == "" {
		where = " 1=1 "
	}
	//获取总记录数
	sqlCount := `select count(*) from ` + certsub + ` a
	where ` + where
	var sql string
	sql = `select a.*
	from ` + certsub + ` a
	where ` + where + ` order by ` + order +
		` limit ` + utils.ToStr((pageIndex-1)*itemsPerPage) + "," + utils.ToStr(itemsPerPage)

	List := make([]OilSupplierCertSub, 0)
	utils.DBE.Sql(sql).Find(&List)

	resultsSlice, err := s.DBE.Query(sqlCount)
	LogError(err)
	if len(resultsSlice) > 0 {
		results := resultsSlice[0]
		for _, value := range results {
			total, err = strconv.ParseInt(string(value), 10, 64)
			LogError(err)
			break
		}
	}
	return total, List
}