package model

import (
	"git.getensh.com/common/gopkgsv2/database"
	"gorm.io/gorm"
)

type Ads11Model interface {
	Get(db *gorm.DB) (*Ads11, error)
	List(db *gorm.DB) ([]P07Table, error)
	List1(db *gorm.DB) ([]Ads11, error)
	Count(db *gorm.DB) (int64, error)
	Update(db *gorm.DB, values interface{}) error
	Insert(db *gorm.DB, datab []Ads11) error
}

type Ads11 struct {
	ID int64 `gorm:"column:id" json:"id"`
	Source string `gorm:"column:source" json:"source"`
	ThirdBrandId string `gorm:"column:third_brand_id" json:"third_brand_id"`
	ThirdBrandName string `gorm:"column:third_brand_name" json:"third_brand_name"`
	ThirdSeriesId string `gorm:"column:third_series_id" json:"third_series_id"`
	ThirdSeriesName string `gorm:"column:third_series_name" json:"third_series_name"`
	ThirdStyleId string `gorm:"column:third_style_id" json:"third_style_id"`
	ThirdStyleName string `gorm:"column:third_style_name" json:"third_style_name"`
	ThirdMaker string `gorm:"column:third_maker" json:"third_maker"`
	ModelYear string `gorm:"column:model_year" json:"model_year"`
	StyleId string `gorm:"column:style_id" json:"style_id"`
	CreatedAt int64 `gorm:"column:created_at" json:"created_at"`
	UpdatedAt int64 `gorm:"column:updated_at" json:"updated_at"`
}

type P07Table struct {
	Price      string `gorm:"column:price"        json:"price"       form:"price"`
	BrandId    string `gorm:"column:brand_id"     json:"brand_id"    form:"brand_id"`
	BrandName  string `gorm:"column:brand_name"   json:"brand_name"  form:"brand_name"`
	ModelYear  string `gorm:"column:model_year"   json:"model_year"  form:"model_year"`
	SeriesId   string `gorm:"column:series_id"    json:"series_id"   form:"series_id"`
	MakerId    string `gorm:"column:maker_id"     json:"maker_id"    form:"maker_id"`
	Maker      string `gorm:"column:maker"        json:"maker"       form:"maker"`
	SeriesImg  string `gorm:"column:series_img"   json:"series_img"  form:"series_img"`
	SeriesName string `gorm:"column:series_name"  json:"series_name" form:"series_name"`
	StyleId    string `gorm:"column:style_id"     json:"style_id"    form:"style_id"`
	StyleName  string `gorm:"column:style_name"   json:"style_name"  form:"style_name"`
}

type defaultAds11Model struct {
	tableName string
	fields    string
}

func NewAds11Model() Ads11Model {
	return &defaultAds11Model{
		tableName: "db_adm_ads.t_adm_ads11",
		fields:    "id, source, third_brand_id, third_brand_name, third_series_id, third_series_name, third_style_id, third_style_name, third_maker, model_year, style_id, created_at, updated_at",
	}
}

func (d *defaultAds11Model) Get(db *gorm.DB) (*Ads11, error) {
	var res Ads11
	err := database.Get(db, &res, database.Option{
		TableName: d.tableName,
		Fields:    d.fields,
	})

	return &res, err
}

func (d *defaultAds11Model) List1(db *gorm.DB) ([]Ads11, error) {
	var res []Ads11
	err := database.List(db, &res, database.Option{
		TableName: d.tableName,
		Fields:    d.fields,
	})

	return res, err
}

func (d *defaultAds11Model) List(db *gorm.DB) ([]P07Table, error) {
	var res []P07Table
	err := database.List(db, &res, database.Option{
		TableName: d.tableName + " AS t1",
		Fields:    "price,brand_id,brand_name,t1.model_year,series_id,maker_id,maker,series_name,t1.style_id,style_name",
		Joins:     []string{"left join db_adm_ads.t_adm_ads5 as t2 on t1.style_id = t2.style_id"},
	})

	return res, err
}

func (d *defaultAds11Model) Count(db *gorm.DB) (int64, error) {
	return database.Count(db, database.Option{
		TableName: d.tableName,
	})
}

func (d *defaultAds11Model) Update(db *gorm.DB, values interface{}) error {
	return database.Update(db, values, database.Option{
		TableName: d.tableName,
	})
}

func (d *defaultAds11Model) Insert(db *gorm.DB, data []Ads11) error {
	return database.Create(db, data, database.Option{
		TableName: d.tableName,
	})
}