package overseas_custom

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

// 海外客户销售
type OverseasCustomerSale struct {
	OverseasCustomSellerId int       `orm:"column(overseas_custorm_seller_id);pk"`
	SellerId               int       `description:"销售id"`
	CreateTime             time.Time `description:"创建时间"`
}

// 海外客户销售
type OverseasCustomerSaleView struct {
	SellerId int    `description:"销售id"`
	RealName string `description:"销售姓名"`
}

func (m *OverseasCustomerSale) Create() (err error) {
	o := orm.NewOrm()
	id, err := o.Insert(m)
	if err != nil {
		return
	}
	m.OverseasCustomSellerId = int(id)
	return
}

func (m *OverseasCustomerSale) Delete() (err error) {
	o := orm.NewOrm()
	sql := ` DELETE FROM overseas_custom_seller WHERE seller_id=? `
	_, err = o.Raw(sql, m.SellerId).Exec()
	return
}

func (m *OverseasCustomerSale) TableName() string {
	return "overseas_custom_seller"
}

// OverseasCustomerSaleSaveReq 保存销售
type OverseasCustomerSaleSaveReq struct {
	AddSellerIdArr []int `description:"新增销售id,数组"`
	DelSellerIdArr []int `description:"删除销售id,数组"`
}

func (m *OverseasCustomerSale) GetOverseasCustomerSaleAll() (list []*OverseasCustomerSaleView, err error) {
	o := orm.NewOrm()
	sql := ` SELECT a.*,b.real_name FROM overseas_custom_seller AS a
			INNER JOIN admin AS b ON a.seller_id=b.admin_id `
	_, err = o.Raw(sql).QueryRows(&list)
	return
}

type AdminItem struct {
	AdminId   int    `description:"系统用户id"`
	AdminName string `description:"系统用户名称"`
	RealName  string `description:"系统用户姓名"`
	Mobile    string `description:"手机号"`
}

func (m *OverseasCustomerSale) HandelOverseasCustomerSale(sellerId, isOverseas int) (err error) {
	o := orm.NewOrm()
	sellerItem := new(AdminItem)
	sql := ` SELECT * FROM admin WHERE admin_id=? `
	err = o.Raw(sql, sellerId).QueryRow(&sellerItem)
	if err != nil {
		return err
	}
	if sellerItem.Mobile == "13065778668" {
		sql = ` UPDATE company_product SET is_overseas = ? WHERE seller_id=? AND company_id IN (SELECT company_id FROM company WHERE region_type='国内') `
		_, err = o.Raw(sql, isOverseas, sellerId).Exec()
		return err
	}
	return err
}