package cygx

import (
	"github.com/beego/beego/v2/client/orm"
	"time"
)

type CygxRaiServeCompanyCoverageRate struct {
	ServeCompanyCoverageRateId int       `orm:"column(serve_company_coverage_rate_id);pk" description:"主键ID"`
	CompanyId                  int       `description:"公司ID"`
	CompanyName                string    `description:"公司名称"`
	CreateTime                 time.Time `description:"创建时间"`
	SellerId                   int       `description:"所属销售id"`
	SellerName                 string    `description:"所属销售名称"`
	StartDate                  string    `description:"开始日期"`
	EndDate                    string    `description:"结束日期"`
	ShareSeller                string    `description:"共享销售"`
	ShareSellerId              int       `description:"共享销售员id"`
	GroupId                    int       `description:"销售分组id"`
	ShareGroupId               int       `description:"共享销售分组id"`
	Status                     string    `description:"客户状态"`
	ShareSellerServeCount      int       `description:"服务销售下面的客户总数"`
	ShareTotalServeCount       int       `description:"总的的服务销售客户总数"`
	ShareSellerServeCountRed   int       `description:"服务销售下面的客户标红总数"`
	ShareTotalServeCountRed    int       `description:"总的的服务销售客户标红总数"`
}

// 列表
func GetCygxRaiServeCompanyCoverageRateListByStartDate(startDate, endDate string) (items []*CygxRaiServeCompanyCoverageRate, err error) {
	o := orm.NewOrmUsingDB("hz_cygx")
	sql := `SELECT * FROM cygx_rai_serve_company_coverage_rate   WHERE 1= 1  AND  end_date >= ?  AND  end_date <= ? `
	_, err = o.Raw(sql, startDate, endDate).QueryRows(&items)
	return
}

// 列表
func GetCygxRaiServeCompanyCoverageRateLast(condition string, pars []interface{}, startSize, pageSize int) (items []*CygxRaiServeCompanyCoverageRate, err error) {
	o := orm.NewOrmUsingDB("hz_cygx")
	sql := `SELECT * FROM cygx_rai_serve_company_coverage_rate   WHERE 1= 1   `
	if condition != "" {
		sql += condition
	}
	sql += ` LIMIT ?,?`
	_, err = o.Raw(sql, pars, startSize, pageSize).QueryRows(&items)
	return
}