客户管理系统
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
zhangqian
2023-08-11 ae6883ce426727efca4facab973d814ae66c69c2 
 model/saleChance.go


@@ -3,44 +3,44 @@


import (


   "aps_crm/pkg/mysqlx"


   "gorm.io/gorm"


   "time"


)




type (


   SaleChance struct {


      Id                 int       `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"`


      Name               string    `json:"name" gorm:"column:name;type:varchar(255);comment:公司名称"`


      Number             string    `json:"number" gorm:"column:number;type:varchar(255);comment:销售线索编号"`


      ContactId          int       `json:"contact_id" gorm:"column:contact_id;type:int(11);comment:联系人ID"`


      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"`


      SaleStageId        int       `json:"sale_stage_id" gorm:"column:sale_stage_id;type:int(11);comment:商机阶段ID"`


      MemberId           int       `json:"member_id" gorm:"column:member_id;type:int(11);comment:销售负责人ID"`


      RegularCustomersId int       `json:"regular_customers_id" gorm:"column:regular_customers_id;type:int(11);comment:常客ID"`


      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"`


      Budget             float64   `json:"budget" gorm:"column:budget;type:decimal(10,2);comment:预算"`


      ProjectedAmount    float64   `json:"projected_amount" gorm:"column:projected_amount;type:decimal(10,2);comment:预计金额"`


      Currency           int       `json:"currency" gorm:"column:currency;type:int(11);comment:币种"`


      ExpectedTime       time.Time `json:"expected_time" gorm:"column:expected_time;type:datetime;comment:预计成交时间"`


      StatusId           int       `json:"status_id" gorm:"column:status_id;type:int(11);comment:状态ID"`


      PainPoints         string    `json:"pain_points" gorm:"column:pain_points;type:text;comment:痛点"`


      WhetherEstablished string    `json:"whether_established" gorm:"column:whether_established;type:text;comment:是否成立"`


      CapitalBudget      string    `json:"capital_budget" gorm:"column:capital_budget;type:text;comment:资金预算"`


      KeyMaker           string    `json:"key_maker" gorm:"column:key_maker;type:text;comment:关键人"`


      KeyFactors         string    `json:"key_factors" gorm:"column:key_factors;type:text;comment:关键因素"`


      Process            string    `json:"process" gorm:"column:process;type:text;comment:决策流程"`


      Solutions          string    `json:"solutions" gorm:"column:solutions;type:text;comment:竞争对手解决方案"`


      Advantages         string    `json:"advantages" gorm:"column:advantages;type:text;comment:竞争优势"`


      Disadvantages      string    `json:"disadvantages" gorm:"column:disadvantages;type:text;comment:竞争劣势"`


      Opportunities      string    `json:"opportunities" gorm:"column:opportunities;type:text;comment:竞争机会"`


      Threats            string    `json:"threats" gorm:"column:threats;type:text;comment:竞争威胁"`


      DetailAddress      string    `json:"detail_address" gorm:"column:detail_address;type:text;comment:详细地址"`


      Remark             string    `json:"remark" gorm:"column:remark;type:text;comment:备注"`


      Contact            Contact   `json:"contact" gorm:"foreignKey:ContactId;references:Id"`


      Client             Client    `json:"client" gorm:"foreignKey:ClientId;references:Id"`


      SalesSources       SalesSources


      Id                    int                    `json:"id" gorm:"column:id;primary_key;AUTO_INCREMENT"`


      Name                  string                 `json:"name" gorm:"column:name;type:varchar(255);comment:公司名称"`


      Number                string                 `json:"number" gorm:"column:number;type:varchar(255);comment:销售线索编号"`


      ContactId             int                    `json:"contact_id" gorm:"column:contact_id;type:int(11);comment:联系人ID"`


      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"`


      SaleStageId           int                    `json:"sale_stage_id" gorm:"column:sale_stage_id;type:int(11);comment:商机阶段ID"`


      MemberId              int                    `json:"member_id" gorm:"column:member_id;type:int(11);comment:销售负责人ID"`


      RegularCustomersId    int                    `json:"regular_customers_id" gorm:"column:regular_customers_id;type:int(11);comment:常客ID"`


      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"`


      Budget                float64                `json:"budget" gorm:"column:budget;type:decimal(10,2);comment:预算"`


      ProjectedAmount       float64                `json:"projected_amount" gorm:"column:projected_amount;type:decimal(10,2);comment:预计金额"`


      Currency              int                    `json:"currency" gorm:"column:currency;type:int(11);comment:币种"`


      ExpectedTime          *CustomTime            `json:"expected_time" gorm:"column:expected_time;type:datetime;comment:预计成交时间"`


      StatusId              int                    `json:"status_id" gorm:"column:status_id;type:int(11);comment:状态ID"`


      PainPoints            string                 `json:"pain_points" gorm:"column:pain_points;type:text;comment:痛点"`


      WhetherEstablished    string                 `json:"whether_established" gorm:"column:whether_established;type:text;comment:是否成立"`


      CapitalBudget         string                 `json:"capital_budget" gorm:"column:capital_budget;type:text;comment:资金预算"`


      KeyMaker              string                 `json:"key_maker" gorm:"column:key_maker;type:text;comment:关键人"`


      KeyFactors            string                 `json:"key_factors" gorm:"column:key_factors;type:text;comment:关键因素"`


      Process               string                 `json:"process" gorm:"column:process;type:text;comment:决策流程"`


      Solutions             string                 `json:"solutions" gorm:"column:solutions;type:text;comment:竞争对手解决方案"`


      Advantages            string                 `json:"advantages" gorm:"column:advantages;type:text;comment:竞争优势"`


      Disadvantages         string                 `json:"disadvantages" gorm:"column:disadvantages;type:text;comment:竞争劣势"`


      Opportunities         string                 `json:"opportunities" gorm:"column:opportunities;type:text;comment:竞争机会"`


      Threats               string                 `json:"threats" gorm:"column:threats;type:text;comment:竞争威胁"`


      DetailAddress         string                 `json:"detail_address" gorm:"column:detail_address;type:text;comment:详细地址"`


      Remark                string                 `json:"remark" gorm:"column:remark;type:text;comment:备注"`


      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


      Address


      gorm.Model `json:"-"`


   }


@@ -114,7 +114,7 @@


      db = db.Limit(slf.PageSize).Offset((slf.PageNum - 1) * slf.PageSize)


   }




   err := db.Preload("Client").Preload("Contact").Find(&records).Error


   err := db.Preload("CollectionProjections").Preload("Client").Preload("Contact").Find(&records).Error


   return records, total, err


}




@@ -141,4 +141,4 @@


func (slf *SaleChanceSearch) SetOrder(order string) *SaleChanceSearch {


   slf.OrderBy = order


   return slf


}


}