// ========================================================================== // This is auto-generated by gf cli tool. DO NOT EDIT THIS FILE MANUALLY. // ========================================================================== package internal import ( "context" "database/sql" "github.com/gogf/gf/container/garray" "github.com/gogf/gf/database/gdb" "github.com/gogf/gf/frame/g" "github.com/gogf/gf/frame/gmvc" "github.com/gogf/gf/util/gconv" "strings" "time" model "dashoo.cn/micro/app/model/proj" ) // ProjBusinessDao is the manager for logic model data accessing and custom defined data operations functions management. type ProjBusinessDao struct { gmvc.M // M is the core and embedded struct that inherits all chaining operations from gdb.Model. C projBusinessColumns // C is the short type for Columns, which contains all the column names of Table for convenient usage. DB gdb.DB // DB is the raw underlying database management object. Table string // Table is the underlying table name of the DAO. TableAs string // TableAs is the underlying table alias name of the DAO. } // ProjBusinessColumns defines and stores column names for table proj_business. type projBusinessColumns struct { Id string // 主键 NboCode string // 项目编码 NboName string // 项目名称 NboStatus string // 项目状态 CustId string // 关联客户 CustName string // 客户名称 CustProvinceId string // 所在省ID CustProvince string // 所在省 CustCityId string // 所在市ID CustCity string // 所在市 CustRegionId string // 所在区县ID CustRegion string // 所在区县 ProductLine string // 产品线 NboType string // 项目级别（A 、B 、C 、成交、储备） NboPhase string // 项目阶段（暂不起用） NboSource string // 项目来源 NboBudget string // 项目预算 ApproType string // 审批类型 ApproStatus string // 审批状态（10待提交20审批中30审批通过40审批退回60审批拒绝） ApproInstanceId string // 审批实例ID ContactId string // 关联联系人 ContactName string // 联系人姓名 ContactPostion string // 联系人岗位 ContactTelephone string // 联系人电话 MakerId string // 关联决策人 MakerName string // 决策人姓名 MakerDept string // 决策人部门 MakerPost string // 决策人岗位 MakerTelephone string // 决策人电话 SalesModel string // 销售模式（10直销20经销30代理） SaleId string // 归属销售 SaleName string // 销售姓名 DistributorId string // 经销商/代理商ID DistributorName string // 经销商/代理商名称 BidId string // 客户招标ID BidInfo string // 招标信息 FilingTime string // 项目备案时间 FinalFollowId string // 最新跟进人 FinalFollowName string // 最新跟进人名称 FinalFollowTime string // 最后跟进时间 NextFollowTime string // 下次跟进时间 PlanPurchaseTime string // 计划采购时间 EstTransTime string // 预计成交时间 EstTransPrice string // 预计成交价格 RiskProfile string // 风险情况 Difficulty string // 困难点 Competitor string // 竞争公司 Intervention string // 介入情况 DeptId string // 所属部门ID DeptName string // 所属部门 IsBig string // 是否为大项目 TechnicalSupportName string // 技术支持人员 TechnicalSupportContent string // 技术支持内容 TechnicalSupportTime string // 技术支持时间 CustomerSatisfaction string // 客户满意度 （10很满意、20满意、30较满意、40一般、50不满意） ParentReceiver string // 总部对接人 NboBudgetTime string // 项目预算期限 CapitalSource string // 资金来源 ProductSatisfaction string // 产品/方案满足情况 PurchasingWay string // 采购方式 PurchasingTime string // 采购时间 IsAdoptDashoo string // 是否采纳大数技术参数（上传附件） HistoricalTransactionInfo string // 经销商与客户历史成交信息 DealerSalesId string // 关联经销商销售 DealerSalesName string // 经销商销售人员 DealerSalesContact string // 经销商销售电话/微信 CustomerIntentionFactory string // 客户倾向厂家 Accendant string // 维护部门及人员 ProjConversionTime string // 项目转化时间 ProjConversionReason string // 项目转化原因 Remark string // 备注 CreatedBy string // 创建者 CreatedName string // 创建人 CreatedTime string // 创建时间 UpdatedBy string // 更新者 UpdatedName string // 更新人 UpdatedTime string // 更新时间 DeletedTime string // 删除时间 } var ( // ProjBusiness is globally public accessible object for table proj_business operations. ProjBusiness = ProjBusinessDao{ M: g.DB("default").Model("proj_business").Safe(), DB: g.DB("default"), Table: "proj_business", C: projBusinessColumns{ Id: "id", NboCode: "nbo_code", NboName: "nbo_name", NboStatus: "nbo_status", CustId: "cust_id", CustName: "cust_name", CustProvinceId: "cust_province_id", CustProvince: "cust_province", CustCityId: "cust_city_id", CustCity: "cust_city", CustRegionId: "cust_region_id", CustRegion: "cust_region", ProductLine: "product_line", NboType: "nbo_type", NboPhase: "nbo_phase", NboSource: "nbo_source", NboBudget: "nbo_budget", ApproType: "appro_type", ApproStatus: "appro_status", ApproInstanceId: "appro_instance_id", ContactId: "contact_id", ContactName: "contact_name", ContactPostion: "contact_postion", ContactTelephone: "contact_telephone", MakerId: "maker_id", MakerName: "maker_name", MakerDept: "maker_dept", MakerPost: "maker_post", MakerTelephone: "maker_telephone", SalesModel: "sales_model", SaleId: "sale_id", SaleName: "sale_name", DistributorId: "distributor_id", DistributorName: "distributor_name", BidId: "bid_id", BidInfo: "bid_info", FilingTime: "filing_time", FinalFollowId: "final_follow_id", FinalFollowName: "final_follow_name", FinalFollowTime: "final_follow_time", NextFollowTime: "next_follow_time", PlanPurchaseTime: "plan_purchase_time", EstTransTime: "est_trans_time", EstTransPrice: "est_trans_price", RiskProfile: "risk_profile", Difficulty: "difficulty", Competitor: "competitor", Intervention: "Intervention", DeptId: "dept_id", DeptName: "dept_name", IsBig: "is_big", TechnicalSupportName: "technical_support_name", TechnicalSupportContent: "technical_support_content", TechnicalSupportTime: "technical_support_time", CustomerSatisfaction: "customer_satisfaction", ParentReceiver: "parent_receiver", NboBudgetTime: "nbo_budget_time", CapitalSource: "capital_source", ProductSatisfaction: "product_satisfaction", PurchasingWay: "purchasing_way", PurchasingTime: "purchasing_time", IsAdoptDashoo: "is_adopt_dashoo", HistoricalTransactionInfo: "historical_transaction_info", DealerSalesId: "dealer_sales_id", DealerSalesName: "dealer_sales_name", DealerSalesContact: "dealer_sales_contact", CustomerIntentionFactory: "customer_intention_factory", Accendant: "accendant", ProjConversionTime: "proj_conversion_time", ProjConversionReason: "proj_conversion_reason", Remark: "remark", CreatedBy: "created_by", CreatedName: "created_name", CreatedTime: "created_time", UpdatedBy: "updated_by", UpdatedName: "updated_name", UpdatedTime: "updated_time", DeletedTime: "deleted_time", }, } ) func NewProjBusinessDao(tenant string) ProjBusinessDao { var dao ProjBusinessDao dao = ProjBusinessDao{ M: g.DB(tenant).Model("proj_business").Safe(), DB: g.DB(tenant), Table: "proj_business", C: projBusinessColumns{ Id: "id", NboCode: "nbo_code", NboName: "nbo_name", NboStatus: "nbo_status", CustId: "cust_id", CustName: "cust_name", CustProvinceId: "cust_province_id", CustProvince: "cust_province", CustCityId: "cust_city_id", CustCity: "cust_city", CustRegionId: "cust_region_id", CustRegion: "cust_region", ProductLine: "product_line", NboType: "nbo_type", NboPhase: "nbo_phase", NboSource: "nbo_source", NboBudget: "nbo_budget", ApproType: "appro_type", ApproStatus: "appro_status", ApproInstanceId: "appro_instance_id", ContactId: "contact_id", ContactName: "contact_name", ContactPostion: "contact_postion", ContactTelephone: "contact_telephone", MakerId: "maker_id", MakerName: "maker_name", MakerDept: "maker_dept", MakerPost: "maker_post", MakerTelephone: "maker_telephone", SalesModel: "sales_model", SaleId: "sale_id", SaleName: "sale_name", DistributorId: "distributor_id", DistributorName: "distributor_name", BidId: "bid_id", BidInfo: "bid_info", FilingTime: "filing_time", FinalFollowId: "final_follow_id", FinalFollowName: "final_follow_name", FinalFollowTime: "final_follow_time", NextFollowTime: "next_follow_time", PlanPurchaseTime: "plan_purchase_time", EstTransTime: "est_trans_time", EstTransPrice: "est_trans_price", RiskProfile: "risk_profile", Difficulty: "difficulty", Competitor: "competitor", Intervention: "Intervention", DeptId: "dept_id", DeptName: "dept_name", IsBig: "is_big", TechnicalSupportName: "technical_support_name", TechnicalSupportContent: "technical_support_content", TechnicalSupportTime: "technical_support_time", CustomerSatisfaction: "customer_satisfaction", ParentReceiver: "parent_receiver", NboBudgetTime: "nbo_budget_time", CapitalSource: "capital_source", ProductSatisfaction: "product_satisfaction", PurchasingWay: "purchasing_way", PurchasingTime: "purchasing_time", IsAdoptDashoo: "is_adopt_dashoo", HistoricalTransactionInfo: "historical_transaction_info", DealerSalesId: "dealer_sales_id", DealerSalesName: "dealer_sales_name", DealerSalesContact: "dealer_sales_contact", CustomerIntentionFactory: "customer_intention_factory", Accendant: "accendant", ProjConversionTime: "proj_conversion_time", ProjConversionReason: "proj_conversion_reason", Remark: "remark", CreatedBy: "created_by", CreatedName: "created_name", CreatedTime: "created_time", UpdatedBy: "updated_by", UpdatedName: "updated_name", UpdatedTime: "updated_time", DeletedTime: "deleted_time", }, } return dao } // Ctx is a chaining function, which creates and returns a new DB that is a shallow copy // of current DB object and with given context in it. // Note that this returned DB object can be used only once, so do not assign it to // a global or package variable for long using. func (d *ProjBusinessDao) Ctx(ctx context.Context) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Ctx(ctx), Table: d.Table, TableAs: d.TableAs} } // GetCtx returns the context for current Model. // It returns "context.Background() i"s there's no context previously set. func (d *ProjBusinessDao) GetCtx() context.Context { return d.M.GetCtx() } // As sets an alias name for current table. func (d *ProjBusinessDao) As(as string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.As(as), Table: d.Table, TableAs: as} } // TX sets the transaction for current operation. func (d *ProjBusinessDao) TX(tx *gdb.TX) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.TX(tx), Table: d.Table, TableAs: d.TableAs} } // Master marks the following operation on master node. func (d *ProjBusinessDao) Master() *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Master(), Table: d.Table, TableAs: d.TableAs} } // Slave marks the following operation on slave node. // Note that it makes sense only if there's any slave node configured. func (d *ProjBusinessDao) Slave() *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Slave(), Table: d.Table, TableAs: d.TableAs} } // Args sets custom arguments for model operation. func (d *ProjBusinessDao) Args(args ...interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Args(args...), Table: d.Table, TableAs: d.TableAs} } // Handler calls each of "handlers" on current Model and returns a new Model. // ModelHandler is a function that handles given Model and returns a new Model that is custom modified. func (d *ProjBusinessDao) Handler(handlers ...gdb.ModelHandler) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Handler(handlers...), Table: d.Table, TableAs: d.TableAs} } // LeftJoin does "LEFT JOIN ... ON ..." statement on the model. // The parameter can be joined table and its joined condition, // and also with its alias name, like: // Table("user").LeftJoin("user_detail", "user_detail.uid=user.uid") // Table("user", "u").LeftJoin("user_detail", "ud", "ud.uid=u.uid") func (d *ProjBusinessDao) LeftJoin(table ...string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.LeftJoin(table...), Table: d.Table, TableAs: d.TableAs} } // RightJoin does "RIGHT JOIN ... ON ..." statement on the model. // The parameter
can be joined table and its joined condition, // and also with its alias name, like: // Table("user").RightJoin("user_detail", "user_detail.uid=user.uid") // Table("user", "u").RightJoin("user_detail", "ud", "ud.uid=u.uid") func (d *ProjBusinessDao) RightJoin(table ...string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.RightJoin(table...), Table: d.Table, TableAs: d.TableAs} } // InnerJoin does "INNER JOIN ... ON ..." statement on the model. // The parameter
can be joined table and its joined condition, // and also with its alias name, like: // Table("user").InnerJoin("user_detail", "user_detail.uid=user.uid") // Table("user", "u").InnerJoin("user_detail", "ud", "ud.uid=u.uid") func (d *ProjBusinessDao) InnerJoin(table ...string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.InnerJoin(table...), Table: d.Table, TableAs: d.TableAs} } // Fields sets the operation fields of the model, multiple fields joined using char ','. // The parameter can be type of string/map/*map/struct/*struct. func (d *ProjBusinessDao) Fields(fieldNamesOrMapStruct ...interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Fields(fieldNamesOrMapStruct...), Table: d.Table, TableAs: d.TableAs} } // FieldsEx sets the excluded operation fields of the model, multiple fields joined using char ','. // The parameter can be type of string/map/*map/struct/*struct. func (d *ProjBusinessDao) FieldsEx(fieldNamesOrMapStruct ...interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.FieldsEx(fieldNamesOrMapStruct...), Table: d.Table, TableAs: d.TableAs} } // FieldCount formats and appends commonly used field "COUNT(column)" to the select fields of model. func (d *ProjBusinessDao) FieldCount(column string, as ...string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.FieldCount(column, as...), Table: d.Table, TableAs: d.TableAs} } // FieldSum formats and appends commonly used field "SUM(column)" to the select fields of model. func (d *ProjBusinessDao) FieldSum(column string, as ...string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.FieldSum(column, as...), Table: d.Table, TableAs: d.TableAs} } // FieldMin formats and appends commonly used field "MIN(column)" to the select fields of model. func (d *ProjBusinessDao) FieldMin(column string, as ...string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.FieldMin(column, as...), Table: d.Table, TableAs: d.TableAs} } // FieldMax formats and appends commonly used field "MAX(column)" to the select fields of model. func (d *ProjBusinessDao) FieldMax(column string, as ...string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.FieldMax(column, as...), Table: d.Table, TableAs: d.TableAs} } // FieldAvg formats and appends commonly used field "AVG(column)" to the select fields of model. func (d *ProjBusinessDao) FieldAvg(column string, as ...string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.FieldAvg(column, as...), Table: d.Table, TableAs: d.TableAs} } // Option adds extra operation option for the model. // Deprecated, use separate operations instead. func (d *ProjBusinessDao) Option(option int) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Option(option), Table: d.Table, TableAs: d.TableAs} } // OmitEmpty sets OPTION_OMITEMPTY option for the model, which automatically filers // the data and where attributes for empty values. func (d *ProjBusinessDao) OmitEmpty() *ProjBusinessDao { return &ProjBusinessDao{M: d.M.OmitEmpty(), Table: d.Table, TableAs: d.TableAs} } // OmitEmptyWhere sets optionOmitEmptyWhere option for the model, which automatically filers // the Where/Having parameters for "empty" values. func (d *ProjBusinessDao) OmitEmptyWhere() *ProjBusinessDao { return &ProjBusinessDao{M: d.M.OmitEmptyWhere(), Table: d.Table, TableAs: d.TableAs} } // OmitEmptyData sets optionOmitEmptyData option for the model, which automatically filers // the Data parameters for "empty" values. func (d *ProjBusinessDao) OmitEmptyData() *ProjBusinessDao { return &ProjBusinessDao{M: d.M.OmitEmptyData(), Table: d.Table, TableAs: d.TableAs} } // OmitNil sets optionOmitNil option for the model, which automatically filers // the data and where parameters for "nil" values. func (d *ProjBusinessDao) OmitNil() *ProjBusinessDao { return &ProjBusinessDao{M: d.M.OmitNil(), Table: d.Table, TableAs: d.TableAs} } // OmitNilWhere sets optionOmitNilWhere option for the model, which automatically filers // the Where/Having parameters for "nil" values. func (d *ProjBusinessDao) OmitNilWhere() *ProjBusinessDao { return &ProjBusinessDao{M: d.M.OmitNilWhere(), Table: d.Table, TableAs: d.TableAs} } // OmitNilData sets optionOmitNilData option for the model, which automatically filers // the Data parameters for "nil" values. func (d *ProjBusinessDao) OmitNilData() *ProjBusinessDao { return &ProjBusinessDao{M: d.M.OmitNilData(), Table: d.Table, TableAs: d.TableAs} } // Filter marks filtering the fields which does not exist in the fields of the operated table. // Note that this function supports only single table operations. // Deprecated, filter feature is automatically enabled from GoFrame v1.16.0, it is so no longer used. func (d *ProjBusinessDao) Filter() *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Filter(), Table: d.Table, TableAs: d.TableAs} } // Where sets the condition statement for the model. The parameter can be type of // string/map/gmap/slice/struct/*struct, etc. Note that, if it's called more than one times, // multiple conditions will be joined into where statement using "AND". // Eg: // Where("uid=10000") // Where("uid", 10000) // Where("money>? AND name like ?", 99999, "vip_%") // Where("uid", 1).Where("name", "john") // Where("status IN (?)", g.Slice{1,2,3}) // Where("age IN(?,?)", 18, 50) // Where(User{ Id : 1, UserName : "john"}) func (d *ProjBusinessDao) Where(where interface{}, args ...interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Where(where, args...), Table: d.Table, TableAs: d.TableAs} } // WherePri does the same logic as M.Where except that if the parameter // is a single condition like int/string/float/slice, it treats the condition as the primary // key value. That is, if primary key is "id" and given parameter as "123", the // WherePri function treats the condition as "id=123", but M.Where treats the condition // as string "123". func (d *ProjBusinessDao) WherePri(where interface{}, args ...interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WherePri(where, args...), Table: d.Table, TableAs: d.TableAs} } // Having sets the having statement for the model. // The parameters of this function usage are as the same as function Where. // See Where. func (d *ProjBusinessDao) Having(having interface{}, args ...interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Having(having, args...), Table: d.Table, TableAs: d.TableAs} } // Wheref builds condition string using fmt.Sprintf and arguments. // Note that if the number of "args" is more than the place holder in "format", // the extra "args" will be used as the where condition arguments of the Model. func (d *ProjBusinessDao) Wheref(format string, args ...interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Wheref(format, args...), Table: d.Table, TableAs: d.TableAs} } // WhereLT builds "column < value" statement. func (d *ProjBusinessDao) WhereLT(column string, value interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereLT(column, value), Table: d.Table, TableAs: d.TableAs} } // WhereLTE builds "column <= value" statement. func (d *ProjBusinessDao) WhereLTE(column string, value interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereLTE(column, value), Table: d.Table, TableAs: d.TableAs} } // WhereGT builds "column > value" statement. func (d *ProjBusinessDao) WhereGT(column string, value interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereGT(column, value), Table: d.Table, TableAs: d.TableAs} } // WhereGTE builds "column >= value" statement. func (d *ProjBusinessDao) WhereGTE(column string, value interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereGTE(column, value), Table: d.Table, TableAs: d.TableAs} } // WhereBetween builds "column BETWEEN min AND max" statement. func (d *ProjBusinessDao) WhereBetween(column string, min, max interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereBetween(column, min, max), Table: d.Table, TableAs: d.TableAs} } // WhereLike builds "column LIKE like" statement. func (d *ProjBusinessDao) WhereLike(column string, like interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereLike(column, like), Table: d.Table, TableAs: d.TableAs} } // WhereIn builds "column IN (in)" statement. func (d *ProjBusinessDao) WhereIn(column string, in interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereIn(column, in), Table: d.Table, TableAs: d.TableAs} } // WhereNull builds "columns[0] IS NULL AND columns[1] IS NULL ..." statement. func (d *ProjBusinessDao) WhereNull(columns ...string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereNull(columns...), Table: d.Table, TableAs: d.TableAs} } // WhereNotBetween builds "column NOT BETWEEN min AND max" statement. func (d *ProjBusinessDao) WhereNotBetween(column string, min, max interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereNotBetween(column, min, max), Table: d.Table, TableAs: d.TableAs} } // WhereNotLike builds "column NOT LIKE like" statement. func (d *ProjBusinessDao) WhereNotLike(column string, like interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereNotLike(column, like), Table: d.Table, TableAs: d.TableAs} } // WhereNot builds "column != value" statement. func (d *ProjBusinessDao) WhereNot(column string, value interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereNot(column, value), Table: d.Table, TableAs: d.TableAs} } // WhereNotIn builds "column NOT IN (in)" statement. func (d *ProjBusinessDao) WhereNotIn(column string, in interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereNotIn(column, in), Table: d.Table, TableAs: d.TableAs} } // WhereNotNull builds "columns[0] IS NOT NULL AND columns[1] IS NOT NULL ..." statement. func (d *ProjBusinessDao) WhereNotNull(columns ...string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereNotNull(columns...), Table: d.Table, TableAs: d.TableAs} } // WhereOr adds "OR" condition to the where statement. func (d *ProjBusinessDao) WhereOr(where interface{}, args ...interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereOr(where, args...), Table: d.Table, TableAs: d.TableAs} } // WhereOrf builds "OR" condition string using fmt.Sprintf and arguments. func (d *ProjBusinessDao) WhereOrf(format string, args ...interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereOrf(format, args...), Table: d.Table, TableAs: d.TableAs} } // WhereOrLT builds "column < value" statement in "OR" conditions.. func (d *ProjBusinessDao) WhereOrLT(column string, value interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereOrLT(column, value), Table: d.Table, TableAs: d.TableAs} } // WhereOrLTE builds "column <= value" statement in "OR" conditions.. func (d *ProjBusinessDao) WhereOrLTE(column string, value interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereOrLTE(column, value), Table: d.Table, TableAs: d.TableAs} } // WhereOrGT builds "column > value" statement in "OR" conditions.. func (d *ProjBusinessDao) WhereOrGT(column string, value interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereOrGT(column, value), Table: d.Table, TableAs: d.TableAs} } // WhereOrGTE builds "column >= value" statement in "OR" conditions.. func (d *ProjBusinessDao) WhereOrGTE(column string, value interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereOrGTE(column, value), Table: d.Table, TableAs: d.TableAs} } // WhereOrBetween builds "column BETWEEN min AND max" statement in "OR" conditions. func (d *ProjBusinessDao) WhereOrBetween(column string, min, max interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereOrBetween(column, min, max), Table: d.Table, TableAs: d.TableAs} } // WhereOrLike builds "column LIKE like" statement in "OR" conditions. func (d *ProjBusinessDao) WhereOrLike(column string, like interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereOrLike(column, like), Table: d.Table, TableAs: d.TableAs} } // WhereOrIn builds "column IN (in)" statement in "OR" conditions. func (d *ProjBusinessDao) WhereOrIn(column string, in interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereOrIn(column, in), Table: d.Table, TableAs: d.TableAs} } // WhereOrNull builds "columns[0] IS NULL OR columns[1] IS NULL ..." statement in "OR" conditions. func (d *ProjBusinessDao) WhereOrNull(columns ...string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereOrNull(columns...), Table: d.Table, TableAs: d.TableAs} } // WhereOrNotBetween builds "column NOT BETWEEN min AND max" statement in "OR" conditions. func (d *ProjBusinessDao) WhereOrNotBetween(column string, min, max interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereOrNotBetween(column, min, max), Table: d.Table, TableAs: d.TableAs} } // WhereOrNotLike builds "column NOT LIKE like" statement in "OR" conditions. func (d *ProjBusinessDao) WhereOrNotLike(column string, like interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereOrNotLike(column, like), Table: d.Table, TableAs: d.TableAs} } // WhereOrNotIn builds "column NOT IN (in)" statement. func (d *ProjBusinessDao) WhereOrNotIn(column string, in interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereOrNotIn(column, in), Table: d.Table, TableAs: d.TableAs} } // WhereOrNotNull builds "columns[0] IS NOT NULL OR columns[1] IS NOT NULL ..." statement in "OR" conditions. func (d *ProjBusinessDao) WhereOrNotNull(columns ...string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.WhereOrNotNull(columns...), Table: d.Table, TableAs: d.TableAs} } // Group sets the "GROUP BY" statement for the model. func (d *ProjBusinessDao) Group(groupBy ...string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Group(groupBy...), Table: d.Table, TableAs: d.TableAs} } // And adds "AND" condition to the where statement. // Deprecated, use Where instead. func (d *ProjBusinessDao) And(where interface{}, args ...interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.And(where, args...), Table: d.Table, TableAs: d.TableAs} } // Or adds "OR" condition to the where statement. // Deprecated, use WhereOr instead. func (d *ProjBusinessDao) Or(where interface{}, args ...interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Or(where, args...), Table: d.Table, TableAs: d.TableAs} } // GroupBy sets the "GROUP BY" statement for the model. func (d *ProjBusinessDao) GroupBy(groupBy string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Group(groupBy), Table: d.Table, TableAs: d.TableAs} } // Order sets the "ORDER BY" statement for the model. func (d *ProjBusinessDao) Order(orderBy ...string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Order(orderBy...), Table: d.Table, TableAs: d.TableAs} } // OrderAsc sets the "ORDER BY xxx ASC" statement for the model. func (d *ProjBusinessDao) OrderAsc(column string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.OrderAsc(column), Table: d.Table, TableAs: d.TableAs} } // OrderDesc sets the "ORDER BY xxx DESC" statement for the model. func (d *ProjBusinessDao) OrderDesc(column string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.OrderDesc(column), Table: d.Table, TableAs: d.TableAs} } // OrderRandom sets the "ORDER BY RANDOM()" statement for the model. func (d *ProjBusinessDao) OrderRandom() *ProjBusinessDao { return &ProjBusinessDao{M: d.M.OrderRandom(), Table: d.Table, TableAs: d.TableAs} } // OrderBy is alias of Model.Order. // See Model.Order. // Deprecated, use Order instead. func (d *ProjBusinessDao) OrderBy(orderBy string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Order(orderBy), Table: d.Table, TableAs: d.TableAs} } // Limit sets the "LIMIT" statement for the model. // The parameter can be either one or two number, if passed two number is passed, // it then sets "LIMIT limit[0],limit[1]" statement for the model, or else it sets "LIMIT limit[0]" // statement. func (d *ProjBusinessDao) Limit(limit ...int) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Limit(limit...), Table: d.Table, TableAs: d.TableAs} } // Offset sets the "OFFSET" statement for the model. // It only makes sense for some databases like SQLServer, PostgreSQL, etc. func (d *ProjBusinessDao) Offset(offset int) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Offset(offset), Table: d.Table, TableAs: d.TableAs} } // Distinct forces the query to only return distinct results. func (d *ProjBusinessDao) Distinct() *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Distinct(), Table: d.Table, TableAs: d.TableAs} } // Page sets the paging number for the model. // The parameter is started from 1 for paging. // Note that, it differs that the Limit function start from 0 for "LIMIT" statement. func (d *ProjBusinessDao) Page(page, limit int) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Page(page, limit), Table: d.Table, TableAs: d.TableAs} } // Batch sets the batch operation number for the model. func (d *ProjBusinessDao) Batch(batch int) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Batch(batch), Table: d.Table, TableAs: d.TableAs} } // Cache sets the cache feature for the model. It caches the result of the sql, which means // if there's another same sql request, it just reads and returns the result from cache, it // but not committed and executed into the database. // // If the parameter < 0, which means it clear the cache with given . // If the parameter = 0, which means it never expires. // If the parameter > 0, which means it expires after . // // The optional parameter is used to bind a name to the cache, which means you can later // control the cache like changing the or clearing the cache with specified . // // Note that, the cache feature is disabled if the model is operating on a transaction. func (d *ProjBusinessDao) Cache(duration time.Duration, name ...string) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Cache(duration, name...), Table: d.Table, TableAs: d.TableAs} } // Data sets the operation data for the model. // The parameter can be type of string/map/gmap/slice/struct/*struct, etc. // Eg: // Data("uid=10000") // Data("uid", 10000) // Data(g.Map{"uid": 10000, "name":"john"}) // Data(g.Slice{g.Map{"uid": 10000, "name":"john"}, g.Map{"uid": 20000, "name":"smith"}) func (d *ProjBusinessDao) Data(data ...interface{}) *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Data(data...), Table: d.Table, TableAs: d.TableAs} } // All does "SELECT FROM ..." statement for the model. // It retrieves the records from table and returns the result as []*model.ProjBusiness. // It returns nil if there's no record retrieved with the given conditions from table. // // The optional parameter is the same as the parameter of M.Where function, // see M.Where. func (d *ProjBusinessDao) All(where ...interface{}) ([]*model.ProjBusiness, error) { all, err := d.M.All(where...) if err != nil { return nil, err } var entities []*model.ProjBusiness if err = all.Structs(&entities); err != nil && err != sql.ErrNoRows { return nil, err } return entities, nil } // One retrieves one record from table and returns the result as *model.ProjBusiness. // It returns nil if there's no record retrieved with the given conditions from table. // // The optional parameter is the same as the parameter of M.Where function, // see M.Where. func (d *ProjBusinessDao) One(where ...interface{}) (*model.ProjBusiness, error) { one, err := d.M.One(where...) if err != nil { return nil, err } var entity *model.ProjBusiness if err = one.Struct(&entity); err != nil && err != sql.ErrNoRows { return nil, err } return entity, nil } // FindOne retrieves and returns a single Record by M.WherePri and M.One. // Also see M.WherePri and M.One. func (d *ProjBusinessDao) FindOne(where ...interface{}) (*model.ProjBusiness, error) { one, err := d.M.FindOne(where...) if err != nil { return nil, err } var entity *model.ProjBusiness if err = one.Struct(&entity); err != nil && err != sql.ErrNoRows { return nil, err } return entity, nil } // FindAll retrieves and returns Result by by M.WherePri and M.All. // Also see M.WherePri and M.All. func (d *ProjBusinessDao) FindAll(where ...interface{}) ([]*model.ProjBusiness, error) { all, err := d.M.FindAll(where...) if err != nil { return nil, err } var entities []*model.ProjBusiness if err = all.Structs(&entities); err != nil && err != sql.ErrNoRows { return nil, err } return entities, nil } // Struct retrieves one record from table and converts it into given struct. // The parameter should be type of *struct/**struct. If type **struct is given, // it can create the struct internally during converting. // // The optional parameter is the same as the parameter of Model.Where function, // see Model.Where. // // Note that it returns sql.ErrNoRows if there's no record retrieved with the given conditions // from table and is not nil. // // Eg: // user := new(User) // err := dao.User.Where("id", 1).Struct(user) // // user := (*User)(nil) // err := dao.User.Where("id", 1).Struct(&user) func (d *ProjBusinessDao) Struct(pointer interface{}, where ...interface{}) error { return d.M.Struct(pointer, where...) } // Structs retrieves records from table and converts them into given struct slice. // The parameter should be type of *[]struct/*[]*struct. It can create and fill the struct // slice internally during converting. // // The optional parameter is the same as the parameter of Model.Where function, // see Model.Where. // // Note that it returns sql.ErrNoRows if there's no record retrieved with the given conditions // from table and is not empty. // // Eg: // users := ([]User)(nil) // err := dao.User.Structs(&users) // // users := ([]*User)(nil) // err := dao.User.Structs(&users) func (d *ProjBusinessDao) Structs(pointer interface{}, where ...interface{}) error { return d.M.Structs(pointer, where...) } // Scan automatically calls Struct or Structs function according to the type of parameter . // It calls function Struct if is type of *struct/**struct. // It calls function Structs if is type of *[]struct/*[]*struct. // // The optional parameter is the same as the parameter of Model.Where function, // see Model.Where. // // Note that it returns sql.ErrNoRows if there's no record retrieved and given pointer is not empty or nil. // // Eg: // user := new(User) // err := dao.User.Where("id", 1).Scan(user) // // user := (*User)(nil) // err := dao.User.Where("id", 1).Scan(&user) // // users := ([]User)(nil) // err := dao.User.Scan(&users) // // users := ([]*User)(nil) // err := dao.User.Scan(&users) func (d *ProjBusinessDao) Scan(pointer interface{}, where ...interface{}) error { return d.M.Scan(pointer, where...) } // Chunk iterates the table with given size and callback function. func (d *ProjBusinessDao) Chunk(limit int, callback func(entities []*model.ProjBusiness, err error) bool) { d.M.Chunk(limit, func(result gdb.Result, err error) bool { var entities []*model.ProjBusiness err = result.Structs(&entities) if err == sql.ErrNoRows { return false } return callback(entities, err) }) } // LockUpdate sets the lock for update for current operation. func (d *ProjBusinessDao) LockUpdate() *ProjBusinessDao { return &ProjBusinessDao{M: d.M.LockUpdate(), Table: d.Table, TableAs: d.TableAs} } // LockShared sets the lock in share mode for current operation. func (d *ProjBusinessDao) LockShared() *ProjBusinessDao { return &ProjBusinessDao{M: d.M.LockShared(), Table: d.Table, TableAs: d.TableAs} } // Unscoped enables/disables the soft deleting feature. func (d *ProjBusinessDao) Unscoped() *ProjBusinessDao { return &ProjBusinessDao{M: d.M.Unscoped(), Table: d.Table, TableAs: d.TableAs} } // DataScope enables the DataScope feature. func (d *ProjBusinessDao) DataScope(ctx context.Context, userCol ...string) *ProjBusinessDao { cs := ctx.Value("contextService") dataScope := gconv.Map(gconv.String(gconv.Map(cs)["dataScope"])) if dataScope != nil { tableAs := d.TableAs if d.TableAs != "" { tableAs += "." } userIds, ok := dataScope["userIds"] delete(dataScope, "userIds") var orColumns []string var orValues []interface{} if ok && userIds != "-1" { column := "created_by" if len(userCol) == 1 { column = userCol[0] } if ok, _ := d.M.HasField(column); ok { orColumns = append(orColumns, tableAs+column+" IN (?) ") orValues = append(orValues, userIds) } } // 销售工程师判断 var salesEngineerFlag bool if roles, ok := dataScope["roles"]; ok { arr := garray.NewArrayFrom(roles.([]interface{}), true) if arr.Len() == 1 && arr.Contains("SalesEngineer") { salesEngineerFlag = true } } // 非销售工程师权限加成 if !salesEngineerFlag { bigColumns := "is_big" if ok, _ := d.M.HasField("is_big"); ok { if val, ok := dataScope[bigColumns]; ok && val != "" { orColumns = append(orColumns, tableAs+bigColumns+" = ? ") orValues = append(orValues, val) } delete(dataScope, bigColumns) } var andColumns []string var andValues []interface{} for k, v := range dataScope { if ok, _ := d.M.HasField(k); ok { andColumns = append(andColumns, tableAs+k+" IN (?) ") andValues = append(andValues, v) } } if len(andColumns) > 0 { andWhereSql := strings.Join(andColumns, " AND ") orColumns = append(orColumns, "("+andWhereSql+")") orValues = append(orValues, andValues...) } } whereSql := strings.Join(orColumns, " OR ") return &ProjBusinessDao{M: d.M.Where(whereSql, orValues...).Ctx(ctx), Table: d.Table, TableAs: d.TableAs} } return d }