package tmpzcgf

import (
	"dashoo.cn/backend/api/business/oilsupplier/suppliercertsub"
	. "dashoo.cn/backend/api/mydb"
	"github.com/go-xorm/xorm"


)

type TmpCertSession struct {
	MySessionBase
}

type TmpCertEntity struct {

	SupplierCertId			int					"xorm:"
	SupplierTypeCode		string
	AccessRange				string
}

type SubClassId struct{
	id int
}

type AllId struct{
	Id int
}

func GetTmpCertService(session *xorm.Session) *TmpCertSession {
	s := new(TmpCertSession)
	s.Session = session
	return s
}

//获取tmp_zcgf所有Id
func (s *TmpCertSession) GetAllId() []AllId{
	var ids []AllId
	sql := `SELECT
				id
			FROM
				tmp_zcgf`
	s.Session.SQL(sql).Find(&ids)
	return ids
}

//从tmp_zcgf获取一条数据
func (s *TmpCertSession) SelectOne(id int) TmpCertEntity {
	var one TmpCertEntity
	sql := `SELECT
				a.准入范围 AccessRange,
				c.id SupplierCertId,
				c.SupplierTypeCode SupplierTypeCode
			FROM
				tmp_zcgf a
				LEFT JOIN oilsupplier b ON a.企业名称 = b.SupplierName
				JOIN oilsuppliercert c ON b.id = c.SupplierId
				AND a.准入类别 = c.SupplierTypeName
			WHERE
				a.id =` + string(id)
	 s.Session.SQL(sql).Find(&one)
	return one
}


//获取subClassId
func (s *TmpCertSession) GetSubClassId(code string, supplierTypeCode string) int{
	//var subClassName
	var id SubClassId
	var tableName string
	switch supplierTypeCode{
	case "01":
		tableName = "OilGoodsAptitudeClass"
		//subClassName = []goodsaptitudeclass.OilGoodsAptitudeClass
	case "02":
		tableName = "OilBasisBuild"
		//subClassName = []basisbuild.OilBasisBuild
	case "03":
		tableName = "OilTechnologyServiceClass"
		//subClassName = []technologyserviceclass.OilTechnologyServiceClass
	}
	var sql = `SELECT id FROM`+tableName+`WHERE	1 = 1 AND code =`+ code

	s.Session.SQL(sql).Find(&id)
	return id.id

}

func (s *TmpCertSession) InsertSupplierCertSub(sub suppliercertsub.OilSupplierCertSub) error {
	var supplierId = string(sub.SupplierId)
	var	supplierCertId = string(sub.SupplierCertId)
	var	supplierTypeCode = sub.SupplierTypeCode
	var	subClassId = string(sub.SubClassId)
	var	code = sub.Code
	var	name = sub.Name
	sql := `INSERT INTO OilSupplierCertSub ( SupplierId, SupplierCertId, SupplierTypeCode, SubClassId, CODE, NAME )
	VALUES ( ’`	+ supplierId+`‘,‘`+supplierCertId+`','`+supplierTypeCode+`','`+subClassId+`','`+code+`','`+name+`')`

	_,err := s.Session.Query(sql)
	return err
}