Documentation ¶
Index ¶
- Constants
- Variables
- type Comment
- func (c *Comment) Create() string
- func (c *Comment) Destroy() string
- func (c *Comment) FromID(id int64) string
- 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() string
- type Job
- func (c *Job) Create() string
- func (c *Job) Destroy() string
- func (c *Job) FromID(id int64) string
- 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() string
- type JobSales
- func (c *JobSales) Create() string
- func (c *JobSales) Destroy() string
- func (c *JobSales) FromID(id int64) string
- 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() string
- type TaskBatchSchedule
- func (c *TaskBatchSchedule) Create() string
- func (c *TaskBatchSchedule) Destroy() string
- func (c *TaskBatchSchedule) FromID(id int64) string
- 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() string
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 ( 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 ( // 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 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() string
Create inserts a TaskBatchSchedule record
func (*TaskBatchSchedule) Destroy ¶ added in v1.8.31
func (c *TaskBatchSchedule) Destroy() string
Destroy deletes a TaskBatchSchedule record
func (*TaskBatchSchedule) FromID ¶ added in v1.8.31
func (c *TaskBatchSchedule) FromID(id int64) string
Select starts a select statement
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
func (*TaskBatchSchedule) Update ¶ added in v1.8.31
func (c *TaskBatchSchedule) Update() string
Update updates a TaskBatchSchedule record