| | |
| | | ClientId int `json:"client_id" gorm:"column:client_id;type:int(11);comment:客户ID"` |
| | | SalesSourcesId int `json:"sales_sources_id" gorm:"column:sales_sources_id;type:int(11);comment:商机来源ID"` |
| | | SaleTypeId int `json:"sale_type_id" gorm:"column:sale_type_id;type:int(11);comment:商机类型ID"` |
| | | SaleType SaleType `json:"sale_type" ` |
| | | SaleStageId int `json:"sale_stage_id" gorm:"column:sale_stage_id;type:int(11);comment:商机阶段ID"` |
| | | SaleStage SaleStage `json:"sale_stage" gorm:"foreignKey:SaleStageId;references:Id"` |
| | | MemberId int `json:"member_id" gorm:"column:member_id;type:int(11);comment:销售负责人ID"` |
| | | Member User `json:"member" gorm:"foreignKey:MemberId"` |
| | | RegularCustomersId int `json:"regular_customers_id" gorm:"column:regular_customers_id;type:int(11);comment:常客ID"` |
| | | RegularCustomers RegularCustomers `json:"regular_customers"` |
| | | Competitors string `json:"competitors" gorm:"column:competitors;type:varchar(255);comment:竞争对手"` |
| | | PossibilitiesId int `json:"possibilities_id" gorm:"column:possibilities_id;type:int(11);comment:可能性ID"` |
| | | Possibility Possibility `json:"possibility" gorm:"foreignKey:PossibilitiesId;references:Id"` |
| | |
| | | Contact Contact `json:"contact" gorm:"foreignKey:ContactId;references:Id"` |
| | | Client Client `json:"client" gorm:"foreignKey:ClientId;references:Id"` |
| | | CollectionProjections []CollectionProjection `json:"collection_projections" gorm:"foreignKey:SaleChanceId"` |
| | | SalesSources SalesSources |
| | | SalesSources SalesSources `json:"sales_sources"` |
| | | Address |
| | | gorm.Model `json:"-"` |
| | | } |
| | |
| | | db = db.Limit(slf.PageSize).Offset((slf.PageNum - 1) * slf.PageSize) |
| | | } |
| | | |
| | | err := db.Preload("SalesSources").Preload("Member").Preload("SaleStage").Preload("Possibility").Preload("CollectionProjections").Preload("Client").Preload("Contact").Find(&records).Error |
| | | err := db.Preload("SaleType").Preload("RegularCustomers").Preload("SalesSources").Preload("Member").Preload("SaleStage").Preload("Possibility").Preload("CollectionProjections").Preload("Client").Preload("Contact").Order("id desc").Find(&records).Error |
| | | return records, total, err |
| | | } |
| | | |