Documentation ¶
Index ¶
- Constants
- Variables
- type Comment
- func (c *Comment) Create(db db.IDB) error
- func (c *Comment) Delete(db db.IDB) error
- func (c *Comment) FromID(db db.IDB, id int64) (query.IModel, error)
- func (c *Comment) String() string
- func (c *Comment) Table_Column_Types() map[query.Column]string
- func (c *Comment) Table_Column_Values() map[query.Column]interface{}
- func (c *Comment) Table_Columns() []query.Column
- func (c *Comment) Table_InsertColumns() []query.Column
- func (c *Comment) Table_Name() query.TableName
- func (c *Comment) Table_PrimaryKey() query.Column
- func (c *Comment) Table_PrimaryKey_Value() int64
- func (c *Comment) Table_UpdateColumns() []query.Column
- func (c *Comment) Update(db db.IDB) error
- type FiscalYear
- func (r *FiscalYear) Count(db db.IDB) *FiscalYearDALCounter
- func (c *FiscalYear) Create(db db.IDB) error
- func (c *FiscalYear) Delete(db db.IDB) error
- func (c *FiscalYear) FromID(db db.IDB, id int64) (query.IModel, error)
- func (r *FiscalYear) Get(db db.IDB) *FiscalYearDALGetter
- func (r *FiscalYear) Raw(db db.IDB, queryRaw string) ([]*FiscalYear, error)
- func (r *FiscalYear) Select(db db.IDB) *FiscalYearDALSelector
- func (c *FiscalYear) String() string
- func (r *FiscalYear) Sum(db db.IDB, col query.Column) *FiscalYearDALSummer
- func (c *FiscalYear) Table_Column_Types() map[query.Column]string
- func (c *FiscalYear) Table_Columns() []query.Column
- func (c *FiscalYear) Table_InsertColumns() []query.Column
- func (c *FiscalYear) Table_Name() query.TableName
- func (c *FiscalYear) Table_PrimaryKey() query.Column
- func (c *FiscalYear) Table_PrimaryKey_Value() int64
- func (c *FiscalYear) Table_SchemaName() string
- func (c *FiscalYear) Table_UpdateColumns() []query.Column
- func (c *FiscalYear) Update(db db.IDB) error
- type FiscalYearDALCounter
- type FiscalYearDALGetter
- func (r *FiscalYearDALGetter) Alias(alias string) *FiscalYearDALGetter
- func (ds *FiscalYearDALGetter) OrderBy(col query.Column, dir query.OrderDir) *FiscalYearDALGetter
- func (ds *FiscalYearDALGetter) Run() (*FiscalYear, error)
- func (ds *FiscalYearDALGetter) Where(whereParts ...query.WherePart) *FiscalYearDALGetter
- type FiscalYearDALSelector
- func (r *FiscalYearDALSelector) Alias(alias string) *FiscalYearDALSelector
- func (r *FiscalYearDALSelector) Count(fieldName query.Column, fieldAlias string) *FiscalYearDALSelector
- func (r *FiscalYearDALSelector) Limit(limit, offset int64) *FiscalYearDALSelector
- func (r *FiscalYearDALSelector) OrderBy(col query.Column, dir query.OrderDir) *FiscalYearDALSelector
- func (r *FiscalYearDALSelector) Run() ([]*FiscalYear, error)
- func (r *FiscalYearDALSelector) Sum(fieldName query.Column, fieldAlias string) *FiscalYearDALSelector
- func (r *FiscalYearDALSelector) Where(whereParts ...query.WherePart) *FiscalYearDALSelector
- type FiscalYearDALSummer
- type Job
- func (c *Job) Create(db db.IDB) error
- func (c *Job) Delete(db db.IDB) error
- func (c *Job) FromID(db db.IDB, id int64) (query.IModel, error)
- func (c *Job) String() string
- func (c *Job) Table_Column_Types() map[query.Column]string
- func (c *Job) Table_Column_Values() map[query.Column]interface{}
- func (c *Job) Table_Columns() []query.Column
- func (c *Job) Table_InsertColumns() []query.Column
- func (c *Job) Table_Name() query.TableName
- func (c *Job) Table_PrimaryKey() query.Column
- func (c *Job) Table_PrimaryKey_Value() int64
- func (c *Job) Table_UpdateColumns() []query.Column
- func (c *Job) Update(db db.IDB) error
- type JobSales
- func (c *JobSales) Create(db db.IDB) error
- func (c *JobSales) Delete(db db.IDB) error
- func (c *JobSales) FromID(db db.IDB, id int64) (query.IModel, error)
- func (c *JobSales) String() string
- func (c *JobSales) Table_Column_Types() map[query.Column]string
- func (c *JobSales) Table_Column_Values() map[query.Column]interface{}
- func (c *JobSales) Table_Columns() []query.Column
- func (c *JobSales) Table_InsertColumns() []query.Column
- func (c *JobSales) Table_Name() query.TableName
- func (c *JobSales) Table_PrimaryKey() query.Column
- func (c *JobSales) Table_PrimaryKey_Value() int64
- func (c *JobSales) Table_UpdateColumns() []query.Column
- func (c *JobSales) Update(db db.IDB) error
- type TaskBatchSchedule
- func (c *TaskBatchSchedule) Create(db db.IDB) error
- func (c *TaskBatchSchedule) Delete(db db.IDB) error
- func (c *TaskBatchSchedule) FromID(db db.IDB, id int64) (query.IModel, error)
- func (c *TaskBatchSchedule) String() string
- func (c *TaskBatchSchedule) Table_Column_Types() map[query.Column]string
- func (c *TaskBatchSchedule) Table_Columns() []query.Column
- func (c *TaskBatchSchedule) Table_InsertColumns() []query.Column
- func (c *TaskBatchSchedule) Table_Name() query.TableName
- func (c *TaskBatchSchedule) Table_PrimaryKey() query.Column
- func (c *TaskBatchSchedule) Table_PrimaryKey_Value() int64
- func (c *TaskBatchSchedule) Table_SchemaName() string
- func (c *TaskBatchSchedule) Table_UpdateColumns() []query.Column
- func (c *TaskBatchSchedule) Update(db db.IDB) error
Constants ¶
const ( // ListItem_SchemaName is the name of the schema group this model is in ListItem_SchemaName = "rfq" // Comment_TableName Comment_TableName query.TableName = "Comment" // Columns Comment_Column_CommentID query.Column = "CommentID" Comment_Column_DateCreated query.Column = "DateCreated" Comment_Column_IsDeleted query.Column = "IsDeleted" Comment_Column_Content query.Column = "Content" Comment_Column_ObjectType query.Column = "ObjectType" Comment_Column_ObjectID query.Column = "ObjectID" Comment_Column_Name query.Column = "Name" )
const ( // FiscalYear_SchemaName is the name of the schema group this model is in FiscalYear_SchemaName = "rfq" // FiscalYear_TableName is the name of the table FiscalYear_TableName query.TableName = "FiscalYear" // Columns FiscalYear_Column_FiscalYearID query.Column = "FiscalYearID" FiscalYear_Column_FiscalYearKey query.Column = "FiscalYearKey" FiscalYear_Column_Year query.Column = "Year" FiscalYear_Column_DateFrom query.Column = "DateFrom" FiscalYear_Column_DateTo query.Column = "DateTo" FiscalYear_Column_DateCreated query.Column = "DateCreated" FiscalYear_Column_IsDeleted query.Column = "IsDeleted" FiscalYear_Column_TotalFiscalDays query.Column = "TotalFiscalDays" FiscalYear_Column_IsLocked query.Column = "IsLocked" )
const ( Job_TableName query.TableName = "Job" // Columns Job_Column_JobID query.Column = "JobID" Job_Column_DateCreated query.Column = "DateCreated" Job_Column_LastUpdated query.Column = "LastUpdated" Job_Column_IsDeleted query.Column = "IsDeleted" Job_Column_QuoteNumberID query.Column = "QuoteNumberID" Job_Column_CustomerID query.Column = "CustomerID" Job_Column_AwardDate query.Column = "AwardDate" Job_Column_AwardDateString query.Column = "AwardDateString" Job_Column_QuoteID query.Column = "QuoteID" Job_Column_Description query.Column = "Description" Job_Column_CustomerContactID query.Column = "CustomerContactID" Job_Column_Notes query.Column = "Notes" Job_Column_CustomerPO2SentTo query.Column = "CustomerPO2SentTo" Job_Column_ThirdPartyName query.Column = "ThirdPartyName" Job_Column_CustomerPO2Number query.Column = "CustomerPO2Number" Job_Column_BillingAddressZip query.Column = "BillingAddressZip" Job_Column_BillingAddress query.Column = "BillingAddress" Job_Column_BillingAddressState query.Column = "BillingAddressState" Job_Column_CustomerPO1SentTo query.Column = "CustomerPO1SentTo" Job_Column_ProjectCost query.Column = "ProjectCost" Job_Column_CustomerPO1Number query.Column = "CustomerPO1Number" Job_Column_ThirdPartySplitPercent query.Column = "ThirdPartySplitPercent" Job_Column_CommissionTypeID query.Column = "CommissionTypeID" Job_Column_GrossMarginPercent query.Column = "GrossMarginPercent" Job_Column_TotalPrice query.Column = "TotalPrice" Job_Column_IsThirdPartySplit query.Column = "IsThirdPartySplit" Job_Column_GrossProfit query.Column = "GrossProfit" Job_Column_BillingAddressCity query.Column = "BillingAddressCity" Job_Column_RemainingGrossProfit query.Column = "RemainingGrossProfit" Job_Column_IsAddFreight query.Column = "IsAddFreight" Job_Column_JobNumberString query.Column = "JobNumberString" Job_Column_ThirdPartyCommission query.Column = "ThirdPartyCommission" Job_Column_ShippingAddressZip query.Column = "ShippingAddressZip" Job_Column_ShippingAddress query.Column = "ShippingAddress" Job_Column_ShippingAddressCity query.Column = "ShippingAddressCity" Job_Column_ShippingAddressState query.Column = "ShippingAddressState" Job_Column_Sales1 query.Column = "Sales1" Job_Column_BidTypeID query.Column = "BidTypeID" Job_Column_Vendor1ID query.Column = "Vendor1ID" Job_Column_MarketID query.Column = "MarketID" Job_Column_Vendor2ID query.Column = "Vendor2ID" Job_Column_Sales2 query.Column = "Sales2" Job_Column_JEFDate query.Column = "JEFDate" Job_Column_JEFDateString query.Column = "JEFDateString" )
const ( JobSales_TableName query.TableName = "JobSales" JobSales_Column_JobSalesID query.Column = "JobSalesID" JobSales_Column_JobID query.Column = "JobID" JobSales_Column_UserID query.Column = "UserID" JobSales_Column_CommissionPercent query.Column = "CommissionPercent" JobSales_Column_DateCreated query.Column = "DateCreated" JobSales_Column_IsDeleted query.Column = "IsDeleted" JobSales_Column_CommissionDollars query.Column = "CommissionDollars" JobSales_Column_IsHouse query.Column = "IsHouse" )
const ( // TaskBatchSchedule_SchemaName is the name of the schema group this model is in TaskBatchSchedule_SchemaName = "dvc" // TaskBatchSchedule_TableName is the name of the table TaskBatchSchedule_TableName query.TableName = "TaskBatchSchedule" // Columns TaskBatchSchedule_Column_TaskBatchScheduleID query.Column = "TaskBatchScheduleID" TaskBatchSchedule_Column_TaskBatchID query.Column = "TaskBatchID" TaskBatchSchedule_Column_DOM query.Column = "DOM" TaskBatchSchedule_Column_DOW query.Column = "DOW" TaskBatchSchedule_Column_HOD query.Column = "HOD" TaskBatchSchedule_Column_MOH query.Column = "MOH" TaskBatchSchedule_Column_DateCreated query.Column = "DateCreated" TaskBatchSchedule_Column_IsDeleted query.Column = "IsDeleted" TaskBatchSchedule_Column_IsActive query.Column = "IsActive" TaskBatchSchedule_Column_CurrentStatus query.Column = "CurrentStatus" TaskBatchSchedule_Column_LastRunDate query.Column = "LastRunDate" TaskBatchSchedule_Column_LastSuccessDate query.Column = "LastSuccessDate" TaskBatchSchedule_Column_LastErrorDate query.Column = "LastErrorDate" TaskBatchSchedule_Column_NumFailed query.Column = "NumFailed" TaskBatchSchedule_Column_NumFinished query.Column = "NumFinished" TaskBatchSchedule_Column_NumAttempted query.Column = "NumAttempted" )
Variables ¶
var ( // FiscalYear_Columns is a list of all the columns FiscalYear_Columns = []query.Column{ FiscalYear_Column_FiscalYearID, FiscalYear_Column_FiscalYearKey, FiscalYear_Column_Year, FiscalYear_Column_DateFrom, FiscalYear_Column_DateTo, FiscalYear_Column_DateCreated, FiscalYear_Column_IsDeleted, FiscalYear_Column_TotalFiscalDays, FiscalYear_Column_IsLocked} // FiscalYear_Column_Types maps columns to their string types FiscalYear_Column_Types = map[query.Column]string{ FiscalYear_Column_FiscalYearID: "%d", FiscalYear_Column_FiscalYearKey: "%d", FiscalYear_Column_Year: "%d", FiscalYear_Column_DateFrom: "%d", FiscalYear_Column_DateTo: "%d", FiscalYear_Column_DateCreated: "%d", FiscalYear_Column_IsDeleted: "%d", FiscalYear_Column_TotalFiscalDays: "%d", FiscalYear_Column_IsLocked: "%d"} // FiscalYear_UpdateColumns is a list of all update columns for this model FiscalYear_UpdateColumns = []query.Column{FiscalYear_Column_FiscalYearKey, FiscalYear_Column_Year, FiscalYear_Column_DateFrom, FiscalYear_Column_DateTo, FiscalYear_Column_IsDeleted, FiscalYear_Column_TotalFiscalDays, FiscalYear_Column_IsLocked} // FiscalYear_InsertColumns is a list of all insert columns for this model FiscalYear_InsertColumns = []query.Column{FiscalYear_Column_FiscalYearKey, FiscalYear_Column_Year, FiscalYear_Column_DateFrom, FiscalYear_Column_DateTo, FiscalYear_Column_DateCreated, FiscalYear_Column_TotalFiscalDays, FiscalYear_Column_IsLocked} // FiscalYear_PrimaryKey is the name of the table's primary key FiscalYear_PrimaryKey query.Column = "FiscalYearID" )
var ( // TaskBatchSchedule_Columns is a list of all the columns TaskBatchSchedule_Columns = []query.Column{ TaskBatchSchedule_Column_TaskBatchScheduleID, TaskBatchSchedule_Column_TaskBatchID, TaskBatchSchedule_Column_DOM, TaskBatchSchedule_Column_DOW, TaskBatchSchedule_Column_HOD, TaskBatchSchedule_Column_MOH, TaskBatchSchedule_Column_DateCreated, TaskBatchSchedule_Column_IsDeleted, TaskBatchSchedule_Column_IsActive, TaskBatchSchedule_Column_CurrentStatus, TaskBatchSchedule_Column_LastRunDate, TaskBatchSchedule_Column_LastSuccessDate, TaskBatchSchedule_Column_LastErrorDate, TaskBatchSchedule_Column_NumFailed, TaskBatchSchedule_Column_NumFinished, TaskBatchSchedule_Column_NumAttempted} // TaskBatchSchedule_Column_Types maps columns to their string types TaskBatchSchedule_Column_Types = map[query.Column]string{ TaskBatchSchedule_Column_TaskBatchScheduleID: "%d", TaskBatchSchedule_Column_TaskBatchID: "%d", TaskBatchSchedule_Column_DOM: "%d", TaskBatchSchedule_Column_DOW: "%d", TaskBatchSchedule_Column_HOD: "%d", TaskBatchSchedule_Column_MOH: "%d", TaskBatchSchedule_Column_DateCreated: "%d", TaskBatchSchedule_Column_IsDeleted: "%d", TaskBatchSchedule_Column_IsActive: "%d", TaskBatchSchedule_Column_CurrentStatus: "%d", TaskBatchSchedule_Column_LastRunDate: "%d", TaskBatchSchedule_Column_LastSuccessDate: "%d", TaskBatchSchedule_Column_LastErrorDate: "%d", TaskBatchSchedule_Column_NumFailed: "%d", TaskBatchSchedule_Column_NumFinished: "%d", TaskBatchSchedule_Column_NumAttempted: "%d"} // TaskBatchSchedule_UpdateColumns is a list of all update columns for this model TaskBatchSchedule_UpdateColumns = []query.Column{TaskBatchSchedule_Column_TaskBatchID, TaskBatchSchedule_Column_DOM, TaskBatchSchedule_Column_DOW, TaskBatchSchedule_Column_HOD, TaskBatchSchedule_Column_MOH, TaskBatchSchedule_Column_IsDeleted, TaskBatchSchedule_Column_IsActive, TaskBatchSchedule_Column_CurrentStatus, TaskBatchSchedule_Column_LastRunDate, TaskBatchSchedule_Column_LastSuccessDate, TaskBatchSchedule_Column_LastErrorDate, TaskBatchSchedule_Column_NumFailed, TaskBatchSchedule_Column_NumFinished, TaskBatchSchedule_Column_NumAttempted} // TaskBatchSchedule_InsertColumns is a list of all insert columns for this model TaskBatchSchedule_InsertColumns = []query.Column{TaskBatchSchedule_Column_TaskBatchID, TaskBatchSchedule_Column_DOM, TaskBatchSchedule_Column_DOW, TaskBatchSchedule_Column_HOD, TaskBatchSchedule_Column_MOH, TaskBatchSchedule_Column_DateCreated, TaskBatchSchedule_Column_IsActive, TaskBatchSchedule_Column_CurrentStatus, TaskBatchSchedule_Column_LastRunDate, TaskBatchSchedule_Column_LastSuccessDate, TaskBatchSchedule_Column_LastErrorDate, TaskBatchSchedule_Column_NumFailed, TaskBatchSchedule_Column_NumFinished, TaskBatchSchedule_Column_NumAttempted} // TaskBatchSchedule_PrimaryKey is the name of the table's primary key TaskBatchSchedule_PrimaryKey query.Column = "TaskBatchScheduleID" )
Functions ¶
This section is empty.
Types ¶
type Comment ¶
type Comment struct { CommentID int64 `db:"CommentID" json:"CommentID"` DateCreated int64 `db:"DateCreated" json:"DateCreated"` IsDeleted int `db:"IsDeleted" json:"IsDeleted"` Content null.String `db:"Content" json:"Content"` ObjectType int64 `db:"ObjectType" json:"ObjectType"` ObjectID int64 `db:"ObjectID" json:"ObjectID"` Name string `db:"Name" json:"Name"` }
Comment is a `Comment` data model
func (*Comment) Table_Column_Values ¶
func (*Comment) Table_Columns ¶
func (*Comment) Table_InsertColumns ¶
Comment_InsertColumns is a list of all insert columns for this model
func (*Comment) Table_Name ¶
Comment_TableName is the name of the table
func (*Comment) Table_PrimaryKey ¶
Comment_PrimaryKey is the name of the table's primary key
func (*Comment) Table_PrimaryKey_Value ¶
func (*Comment) Table_UpdateColumns ¶
Comment_UpdateColumns is a list of all update columns for this model
type FiscalYear ¶ added in v1.8.45
type FiscalYear struct { FiscalYearID int64 `db:"FiscalYearID" json:"FiscalYearID"` FiscalYearKey int64 `db:"FiscalYearKey" json:"FiscalYearKey"` Year int64 `db:"Year" json:"Year"` DateFrom int64 `db:"DateFrom" json:"DateFrom"` DateTo int64 `db:"DateTo" json:"DateTo"` DateCreated int64 `db:"DateCreated" json:"DateCreated"` IsDeleted int `db:"IsDeleted" json:"IsDeleted"` TotalFiscalDays int64 `db:"TotalFiscalDays" json:"TotalFiscalDays"` IsLocked int64 `db:"IsLocked" json:"IsLocked"` }
FiscalYear is a `FiscalYear` data model
func (*FiscalYear) Count ¶ added in v1.8.45
func (r *FiscalYear) Count(db db.IDB) *FiscalYearDALCounter
func (*FiscalYear) Create ¶ added in v1.8.45
func (c *FiscalYear) Create(db db.IDB) error
Create inserts a FiscalYear record
func (*FiscalYear) Delete ¶ added in v1.8.45
func (c *FiscalYear) Delete(db db.IDB) error
Destroy deletes a FiscalYear record
func (*FiscalYear) Get ¶ added in v1.8.45
func (r *FiscalYear) Get(db db.IDB) *FiscalYearDALGetter
func (*FiscalYear) Raw ¶ added in v1.8.45
func (r *FiscalYear) Raw(db db.IDB, queryRaw string) ([]*FiscalYear, error)
func (*FiscalYear) Select ¶ added in v1.8.45
func (r *FiscalYear) Select(db db.IDB) *FiscalYearDALSelector
func (*FiscalYear) String ¶ added in v1.8.45
func (c *FiscalYear) String() string
String returns a json marshalled string of the object
func (*FiscalYear) Sum ¶ added in v1.8.45
func (r *FiscalYear) Sum(db db.IDB, col query.Column) *FiscalYearDALSummer
func (*FiscalYear) Table_Column_Types ¶ added in v1.8.45
func (c *FiscalYear) Table_Column_Types() map[query.Column]string
Table_ColumnTypes returns a map of tableColumn names with their fmt string types
func (*FiscalYear) Table_Columns ¶ added in v1.8.45
func (c *FiscalYear) Table_Columns() []query.Column
func (*FiscalYear) Table_InsertColumns ¶ added in v1.8.45
func (c *FiscalYear) Table_InsertColumns() []query.Column
Table_InsertColumns is a list of all insert columns for this model
func (*FiscalYear) Table_Name ¶ added in v1.8.45
func (c *FiscalYear) Table_Name() query.TableName
FiscalYear_TableName is the name of the table
func (*FiscalYear) Table_PrimaryKey ¶ added in v1.8.45
func (c *FiscalYear) Table_PrimaryKey() query.Column
Table_PrimaryKey returns the name of this table's primary key
func (*FiscalYear) Table_PrimaryKey_Value ¶ added in v1.8.45
func (c *FiscalYear) Table_PrimaryKey_Value() int64
Table_PrimaryKey_Value returns the value of this table's primary key
func (*FiscalYear) Table_SchemaName ¶ added in v1.8.45
func (c *FiscalYear) Table_SchemaName() string
FiscalYear_SchemaName is the name of this table's schema
func (*FiscalYear) Table_UpdateColumns ¶ added in v1.8.45
func (c *FiscalYear) Table_UpdateColumns() []query.Column
Table_UpdateColumns is a list of all update columns for this model
type FiscalYearDALCounter ¶ added in v1.8.45
type FiscalYearDALCounter struct {
// contains filtered or unexported fields
}
Counter
func (*FiscalYearDALCounter) Alias ¶ added in v1.8.45
func (r *FiscalYearDALCounter) Alias(alias string) *FiscalYearDALCounter
func (*FiscalYearDALCounter) Run ¶ added in v1.8.45
func (ds *FiscalYearDALCounter) Run() (int64, error)
func (*FiscalYearDALCounter) Where ¶ added in v1.8.45
func (ds *FiscalYearDALCounter) Where(whereParts ...query.WherePart) *FiscalYearDALCounter
type FiscalYearDALGetter ¶ added in v1.8.45
type FiscalYearDALGetter struct {
// contains filtered or unexported fields
}
func (*FiscalYearDALGetter) Alias ¶ added in v1.8.45
func (r *FiscalYearDALGetter) Alias(alias string) *FiscalYearDALGetter
func (*FiscalYearDALGetter) OrderBy ¶ added in v1.8.45
func (ds *FiscalYearDALGetter) OrderBy(col query.Column, dir query.OrderDir) *FiscalYearDALGetter
func (*FiscalYearDALGetter) Run ¶ added in v1.8.45
func (ds *FiscalYearDALGetter) Run() (*FiscalYear, error)
func (*FiscalYearDALGetter) Where ¶ added in v1.8.45
func (ds *FiscalYearDALGetter) Where(whereParts ...query.WherePart) *FiscalYearDALGetter
type FiscalYearDALSelector ¶ added in v1.8.45
type FiscalYearDALSelector struct {
// contains filtered or unexported fields
}
func (*FiscalYearDALSelector) Alias ¶ added in v1.8.45
func (r *FiscalYearDALSelector) Alias(alias string) *FiscalYearDALSelector
func (*FiscalYearDALSelector) Count ¶ added in v1.8.45
func (r *FiscalYearDALSelector) Count(fieldName query.Column, fieldAlias string) *FiscalYearDALSelector
func (*FiscalYearDALSelector) Limit ¶ added in v1.8.45
func (r *FiscalYearDALSelector) Limit(limit, offset int64) *FiscalYearDALSelector
func (*FiscalYearDALSelector) OrderBy ¶ added in v1.8.45
func (r *FiscalYearDALSelector) OrderBy(col query.Column, dir query.OrderDir) *FiscalYearDALSelector
func (*FiscalYearDALSelector) Run ¶ added in v1.8.45
func (r *FiscalYearDALSelector) Run() ([]*FiscalYear, error)
func (*FiscalYearDALSelector) Sum ¶ added in v1.8.45
func (r *FiscalYearDALSelector) Sum(fieldName query.Column, fieldAlias string) *FiscalYearDALSelector
func (*FiscalYearDALSelector) Where ¶ added in v1.8.45
func (r *FiscalYearDALSelector) Where(whereParts ...query.WherePart) *FiscalYearDALSelector
type FiscalYearDALSummer ¶ added in v1.8.45
type FiscalYearDALSummer struct {
// contains filtered or unexported fields
}
Summer
func (*FiscalYearDALSummer) Run ¶ added in v1.8.45
func (ds *FiscalYearDALSummer) Run() (float64, error)
func (*FiscalYearDALSummer) Where ¶ added in v1.8.45
func (ds *FiscalYearDALSummer) Where(whereParts ...query.WherePart) *FiscalYearDALSummer
type Job ¶
type Job struct { JobID int64 `db:"JobID" json:"JobID"` DateCreated int64 `db:"DateCreated" json:"DateCreated"` LastUpdated int64 `db:"LastUpdated" json:"LastUpdated"` IsDeleted int `db:"IsDeleted" json:"IsDeleted"` QuoteNumberID int64 `db:"QuoteNumberID" json:"QuoteNumberID"` CustomerID int64 `db:"CustomerID" json:"CustomerID"` AwardDate int64 `db:"AwardDate" json:"AwardDate"` AwardDateString string `db:"AwardDateString" json:"AwardDateString"` QuoteID int64 `db:"QuoteID" json:"QuoteID"` Description string `db:"Description" json:"Description"` CustomerContactID int64 `db:"CustomerContactID" json:"CustomerContactID"` Notes null.String `db:"Notes" json:"Notes"` CustomerPO2SentTo int64 `db:"CustomerPO2SentTo" json:"CustomerPO2SentTo"` ThirdPartyName string `db:"ThirdPartyName" json:"ThirdPartyName"` CustomerPO2Number string `db:"CustomerPO2Number" json:"CustomerPO2Number"` BillingAddressZip string `db:"BillingAddressZip" json:"BillingAddressZip"` BillingAddress string `db:"BillingAddress" json:"BillingAddress"` BillingAddressState string `db:"BillingAddressState" json:"BillingAddressState"` CustomerPO1SentTo int64 `db:"CustomerPO1SentTo" json:"CustomerPO1SentTo"` ProjectCost float64 `db:"ProjectCost" json:"ProjectCost"` CustomerPO1Number string `db:"CustomerPO1Number" json:"CustomerPO1Number"` ThirdPartySplitPercent float64 `db:"ThirdPartySplitPercent" json:"ThirdPartySplitPercent"` CommissionTypeID int64 `db:"CommissionTypeID" json:"CommissionTypeID"` GrossMarginPercent float64 `db:"GrossMarginPercent" json:"GrossMarginPercent"` TotalPrice float64 `db:"TotalPrice" json:"TotalPrice"` IsThirdPartySplit int `db:"IsThirdPartySplit" json:"IsThirdPartySplit"` GrossProfit float64 `db:"GrossProfit" json:"GrossProfit"` BillingAddressCity string `db:"BillingAddressCity" json:"BillingAddressCity"` RemainingGrossProfit float64 `db:"RemainingGrossProfit" json:"RemainingGrossProfit"` IsAddFreight int `db:"IsAddFreight" json:"IsAddFreight"` JobNumberString string `db:"JobNumberString" json:"JobNumberString"` ThirdPartyCommission float64 `db:"ThirdPartyCommission" json:"ThirdPartyCommission"` ShippingAddressZip string `db:"ShippingAddressZip" json:"ShippingAddressZip"` ShippingAddress string `db:"ShippingAddress" json:"ShippingAddress"` ShippingAddressCity string `db:"ShippingAddressCity" json:"ShippingAddressCity"` ShippingAddressState string `db:"ShippingAddressState" json:"ShippingAddressState"` Sales1 string `db:"Sales1" json:"Sales1"` BidTypeID int64 `db:"BidTypeID" json:"BidTypeID"` Vendor1ID int64 `db:"Vendor1ID" json:"Vendor1ID"` MarketID int64 `db:"MarketID" json:"MarketID"` Vendor2ID int64 `db:"Vendor2ID" json:"Vendor2ID"` Sales2 string `db:"Sales2" json:"Sales2"` JEFDate int64 `db:"JEFDate" json:"JEFDate"` JEFDateString string `db:"JEFDateString" json:"JEFDateString"` }
Job is a `Job` data model
func (*Job) Table_Column_Values ¶
func (*Job) Table_Columns ¶
func (*Job) Table_InsertColumns ¶
Comment_InsertColumns is a list of all insert columns for this model TODO
func (*Job) Table_Name ¶
Comment_TableName is the name of the table
func (*Job) Table_PrimaryKey ¶
Comment_PrimaryKey is the name of the table's primary key
func (*Job) Table_PrimaryKey_Value ¶
func (*Job) Table_UpdateColumns ¶
Comment_UpdateColumns is a list of all update columns for this model TODO
type JobSales ¶
type JobSales struct { JobSalesID int64 `db:"JobSalesID" json:"JobSalesID"` JobID int64 `db:"JobID" json:"JobID"` UserID int64 `db:"UserID" json:"UserID"` CommissionPercent float64 `db:"CommissionPercent" json:"CommissionPercent"` DateCreated int64 `db:"DateCreated" json:"DateCreated"` IsDeleted int `db:"IsDeleted" json:"IsDeleted"` CommissionDollars float64 `db:"CommissionDollars" json:"CommissionDollars"` IsHouse int `db:"IsHouse" json:"IsHouse"` }
JobSales is a `JobSales` data model
func (*JobSales) Table_Column_Types ¶
func (*JobSales) Table_Column_Values ¶
func (*JobSales) Table_Columns ¶
func (*JobSales) Table_InsertColumns ¶
Comment_InsertColumns is a list of all insert columns for this model
func (*JobSales) Table_Name ¶
Comment_TableName is the name of the table
func (*JobSales) Table_PrimaryKey ¶
Comment_PrimaryKey is the name of the table's primary key
func (*JobSales) Table_PrimaryKey_Value ¶
func (*JobSales) Table_UpdateColumns ¶
Comment_UpdateColumns is a list of all update columns for this model
type TaskBatchSchedule ¶ added in v1.8.31
type TaskBatchSchedule struct { TaskBatchScheduleID int64 `db:"TaskBatchScheduleID" json:"TaskBatchScheduleID"` TaskBatchID int64 `db:"TaskBatchID" json:"TaskBatchID"` DOM int64 `db:"DOM" json:"DOM"` DOW int64 `db:"DOW" json:"DOW"` HOD int64 `db:"HOD" json:"HOD"` MOH int64 `db:"MOH" json:"MOH"` DateCreated int64 `db:"DateCreated" json:"DateCreated"` IsDeleted int `db:"IsDeleted" json:"IsDeleted"` IsActive int `db:"IsActive" json:"IsActive"` CurrentStatus int `db:"CurrentStatus" json:"CurrentStatus"` LastRunDate int64 `db:"LastRunDate" json:"LastRunDate"` LastSuccessDate int64 `db:"LastSuccessDate" json:"LastSuccessDate"` LastErrorDate int64 `db:"LastErrorDate" json:"LastErrorDate"` NumFailed int64 `db:"NumFailed" json:"NumFailed"` NumFinished int64 `db:"NumFinished" json:"NumFinished"` NumAttempted int64 `db:"NumAttempted" json:"NumAttempted"` }
TaskBatchSchedule is a `TaskBatchSchedule` data model
func (*TaskBatchSchedule) Create ¶ added in v1.8.31
func (c *TaskBatchSchedule) Create(db db.IDB) error
func (*TaskBatchSchedule) Delete ¶ added in v1.8.45
func (c *TaskBatchSchedule) Delete(db db.IDB) error
func (*TaskBatchSchedule) String ¶ added in v1.8.31
func (c *TaskBatchSchedule) String() string
String returns a json marshalled string of the object
func (*TaskBatchSchedule) Table_Column_Types ¶ added in v1.8.31
func (c *TaskBatchSchedule) Table_Column_Types() map[query.Column]string
Table_ColumnTypes returns a map of tableColumn names with their fmt string types
func (*TaskBatchSchedule) Table_Columns ¶ added in v1.8.31
func (c *TaskBatchSchedule) Table_Columns() []query.Column
func (*TaskBatchSchedule) Table_InsertColumns ¶ added in v1.8.31
func (c *TaskBatchSchedule) Table_InsertColumns() []query.Column
Table_InsertColumns is a list of all insert columns for this model
func (*TaskBatchSchedule) Table_Name ¶ added in v1.8.31
func (c *TaskBatchSchedule) Table_Name() query.TableName
TaskBatchSchedule_TableName is the name of the table
func (*TaskBatchSchedule) Table_PrimaryKey ¶ added in v1.8.31
func (c *TaskBatchSchedule) Table_PrimaryKey() query.Column
Table_PrimaryKey returns the name of this table's primary key
func (*TaskBatchSchedule) Table_PrimaryKey_Value ¶ added in v1.8.31
func (c *TaskBatchSchedule) Table_PrimaryKey_Value() int64
Table_PrimaryKey_Value returns the value of this table's primary key
func (*TaskBatchSchedule) Table_SchemaName ¶ added in v1.8.31
func (c *TaskBatchSchedule) Table_SchemaName() string
TaskBatchSchedule_SchemaName is the name of this table's schema
func (*TaskBatchSchedule) Table_UpdateColumns ¶ added in v1.8.31
func (c *TaskBatchSchedule) Table_UpdateColumns() []query.Column
Table_UpdateColumns is a list of all update columns for this model