| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667 |
- package company
- import (
- "github.com/beego/beego/v2/client/orm"
- "time"
- )
- type CompanyProduct struct {
- CompanyProductId int `orm:"column(company_product_id);pk" description:"客户产品id"`
- CompanyId int `description:"客户id"`
- ProductId int `description:"产品id"`
- ProductName string `description:"产品名称"`
- CompanyName string `description:"客户名称"`
- Source string `description:"来源"`
- Reasons string `description:"新增理由"`
- Status string `description:"客户状态"`
- IndustryId int `description:"行业id"`
- IndustryName string `description:"行业名称"`
- SellerId int `description:"销售id"`
- SellerName string `description:"销售名称"`
- GroupId int `description:"销售分组id"`
- DepartmentId int `description:"销售部门id"`
- IsSuspend int `description:"1:暂停,0:启用"`
- SuspendTime time.Time `description:"暂停启用时间"`
- TryOutTime time.Time `description:"正式转试用时间"`
- RenewalReason string `description:"正式转试用后的续约情况说明"`
- RenewalTodo string `description:"未续约说明中的待办事项说明"`
- LastDescriptionTime time.Time `description:"上次添加说明时间"`
- RenewalIntention int `description:"是否勾选无续约意向,1:确认,0:未确认"`
- ApproveStatus string `description:"审批状态:'审批中','通过','驳回'"`
- FreezeTime time.Time `description:"冻结时间"`
- FreezeReason time.Time `description:"冻结理由"`
- Remark string `description:"备注信息"`
- CreateTime time.Time `description:"创建时间"`
- ModifyTime time.Time `description:"修改时间"`
- StartDate string `description:"开始日期"`
- EndDate string `description:"结束日期"`
- ContractEndDate time.Time `description:"合同结束日期"`
- LoseReason string `description:"流失原因"`
- LossTime time.Time `description:"流失时间"`
- CompanyType string `description:"客户类型"`
- OpenCode string `description:"开放给第三方的编码，不让第三方定位我们的客户信息"`
- Scale string `description:"管理规模，空不填，1：:50亿以下，2：50~100亿，3：100亿以上。"`
- ViewTotal int `description:"总阅读次数"`
- RoadShowTotal int `description:"累计路演次数"`
- LastViewTime time.Time `description:"最后一次阅读时间"`
- PackageType int `description:"套餐类型"`
- IsFormal int `description:"是否已经转正式，0是没有转正式，1是已经转过正式"`
- TodoStatus string `description:"任务处理状态；枚举值：'无任务','未完成','已完成'"`
- TodoCreateTime time.Time `description:"任务创建时间"`
- TodoApproveTime time.Time `description:"任务审批时间"`
- TryStage int `description:"试用客户子标签：1未分类、2 推进、3 跟踪、4 预备"`
- TryOutDayTotal int `description:"客户总试用天数"`
- CloseReason string `description:"关闭原因"`
- CloseTime time.Time `description:"关闭时间"`
- OverseasLabel int `description:"海外客户试用子标签：1未分类、2 推进、3 跟踪、4 预备、"`
- IsOverseas int `description:"是否显示在海外客户0:显示,1:不显示"`
- }
- func GetCompanyProductByCompanyIdAndProductId(companyId, productId int) (item *CompanyProduct, err error) {
- o := orm.NewOrmUsingDB("weekly_report")
- sql := `SELECT b.* FROM company AS a
- INNER JOIN company_product AS b ON a.company_id=b.company_id
- WHERE a.company_id=? AND b.product_id=? LIMIT 1 `
- err = o.Raw(sql, companyId, productId).QueryRow(&item)
- return
- }
|
