cmd

package
v0.0.0-...-6d8a328 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Dec 1, 2022 License: AGPL-3.0 Imports: 32 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func Execute

func Execute()

func ListAllPrivateFilesByTenantID

func ListAllPrivateFilesByTenantID(db *sql.DB, tenantID uint64) ([]*models.PrivateFile, error)

Types

type OldAssociateAwayLog

type OldAssociateAwayLog struct {
	Id                 uint64      `json:"id"`
	AssociateId        uint64      `json:"associate_id"`
	Reason             int8        `json:"reason"`
	ReasonOther        null.String `json:"reason_other"`
	UntilFurtherNotice bool        `json:"until_further_notice"`
	UntilDate          null.Time   `json:"until_date"`
	StartDate          null.Time   `json:"start_date"`
	WasDeleted         bool        `json:"was_deleted"`
	CreatedTime        time.Time   `json:"created"`
	CreatedById        null.Int    `json:"created_by_id"`
	LastModifiedTime   time.Time   `json:"last_modified"`
	LastModifiedById   null.Int    `json:"last_modified_by_id"`
}

func ListAllAssociateAwayLogs

func ListAllAssociateAwayLogs(db *sql.DB) ([]*OldAssociateAwayLog, error)

type OldAssociateComment

type OldAssociateComment struct {
	Id          uint64 `json:"id"`
	AssociateId uint64 `json:"about_id"`
	CommentId   uint64 `json:"comment_id"`
}

func ListAllAssociateComments

func ListAllAssociateComments(db *sql.DB) ([]*OldAssociateComment, error)

type OldAssociateInsuranceRequirement

type OldAssociateInsuranceRequirement struct {
	Id                     uint64 `json:"id"`
	AssociateId            uint64 `json:"associate_id"`
	InsuranceRequirementId uint64 `json:"insurancerequirement_id"`
}

func ListAllAssociateInsuranceRequirements

func ListAllAssociateInsuranceRequirements(db *sql.DB) ([]*OldAssociateInsuranceRequirement, error)

type OldAssociateSkillSet

type OldAssociateSkillSet struct {
	Id          uint64 `json:"id"`
	AssociateId uint64 `json:"associate_id"`
	SkillSetId  uint64 `json:"skillset_id"`
}

func ListAllAssociateSkillSets

func ListAllAssociateSkillSets(db *sql.DB) ([]*OldAssociateSkillSet, error)

type OldAssociateTag

type OldAssociateTag struct {
	Id          uint64 `json:"id"`
	AssociateId uint64 `json:"associate_id"`
	TagId       uint64 `json:"vehicletype_id"`
}

func ListAllAssociateTags

func ListAllAssociateTags(db *sql.DB) ([]*OldAssociateTag, error)

type OldAssociateVehicleType

type OldAssociateVehicleType struct {
	Id            uint64 `json:"id"`
	AssociateId   uint64 `json:"associate_id"`
	VehicleTypeId uint64 `json:"vehicletype_id"`
}

func ListAllAssociateVehicleTypes

func ListAllAssociateVehicleTypes(db *sql.DB) ([]*OldAssociateVehicleType, error)

type OldBulletinBoardItem

type OldBulletinBoardItem struct {
	Id               uint64    `json:"id"`
	Text             string    `json:"text"`
	CreatedAt        time.Time `json:"created_at"`
	CreatedById      null.Int  `json:"created_by_id,omitempty"`
	CreatedFrom      string    `json:"created_from"`
	LastModifiedAt   time.Time `json:"last_modified_at"`
	LastModifiedById null.Int  `json:"last_modified_by_id,omitempty"`
	LastModifiedFrom string    `json:"last_modified_from"`
	IsArchived       bool      `json:"is_archived"`
}

func ListAllBulletinBoardItems

func ListAllBulletinBoardItems(db *sql.DB) ([]*OldBulletinBoardItem, error)

type OldComment

type OldComment struct {
	Id               uint64      `json:"id"`
	CreatedAt        time.Time   `json:"created_time"`
	CreatedById      null.Int    `json:"created_by_id,omitempty"`
	CreatedFrom      null.String `json:"created_from"`
	LastModifiedAt   time.Time   `json:"last_modified_time"`
	LastModifiedById null.Int    `json:"last_modified_by_id,omitempty"`
	LastModifiedFrom null.String `json:"last_modified_from"`
	Text             string      `json:"text"`
	IsArchived       bool        `json:"is_archived"`
}

func ListAllComments

func ListAllComments(db *sql.DB) ([]*OldComment, error)

type OldHowHearAboutUsItem

type OldHowHearAboutUsItem struct {
	Id             uint64 `json:"id"`
	Uuid           string `json:"uuid"`
	TenantID       uint64 `json:"tenant_id"`
	Text           string `json:"text"`
	SortNumber     int8   `json:"sort_number"`
	IsForAssociate bool   `json:"is_for_associate"`
	IsForCustomer  bool   `json:"is_for_customer"`
	IsForStaff     bool   `json:"is_for_staff"`
	IsForPartner   bool   `json:"is_for_partner"`
	IsArchived     bool   `json:"is_archived"`
}

func ListAllHowHearAboutUsItems

func ListAllHowHearAboutUsItems(oldDb *sql.DB) ([]*OldHowHearAboutUsItem, error)

Function returns a paginated list of all type element items.

type OldOngoingWorkOrder

type OldOngoingWorkOrder struct {
	Id               uint64      `json:"id"`
	State            string      `json:"state"`
	AssociateId      null.Int    `json:"associate_id"`
	CustomerId       uint64      `json:"customer_id"`
	CreatedAt        time.Time   `json:"created_at"`
	CreatedById      null.Int    `json:"created_by_id"`
	CreatedFrom      null.String `json:"created_from"`
	LastModifiedAt   time.Time   `json:"last_modified_at"`
	LastModifiedById null.Int    `json:"last_modified_by_id"`
	LastModifiedFrom null.String `json:"last_modified_from"`
}

func ListAllOngoingWorkOrders

func ListAllOngoingWorkOrders(db *sql.DB) ([]*OldOngoingWorkOrder, error)

type OldOngoingWorkOrderComment

type OldOngoingWorkOrderComment struct {
	Id                 uint64    `json:"id"`
	CreatedAt          time.Time `json:"created_at"`
	OngoingWorkOrderId uint64    `json:"about_id"`
	CommentId          uint64    `json:"comment_id"`
}

func ListAllOngoingWorkOrderComments

func ListAllOngoingWorkOrderComments(db *sql.DB) ([]*OldOngoingWorkOrderComment, error)

type OldPartnerComment

type OldPartnerComment struct {
	Id        uint64 `json:"id"`
	PartnerId uint64 `json:"about_id"`
	CommentId uint64 `json:"comment_id"`
}

func ListAllPartnerComments

func ListAllPartnerComments(db *sql.DB) ([]*OldPartnerComment, error)

type OldPrivateFile

type OldPrivateFile struct {
	Id                       uint64      `json:"id"`
	DataFile                 string      `json:"data_file"`
	Title                    string      `json:"title"`
	Description              string      `json:"description"`
	IsArchived               bool        `json:"is_archived"`
	IndexedText              null.String `json:"indexed_text"`
	CreatedAt                time.Time   `json:"created_at"`
	CreatedFrom              null.String `json:"created_from"`
	CreatedFromIsPublic      bool        `json:"created_from_is_public"`
	CreatedById              null.Int    `json:"created_by_id"`
	LastModifiedAt           time.Time   `json:"last_modified_at"`
	LastModifiedFrom         null.String `json:"last_modified_from"`
	LastModifiedFromIsPublic bool        `json:"last_modified_from_is_public"`
	LastModifiedById         null.Int    `json:"last_modified_by_id"`
	AssociateId              null.Int    `json:"associate_id"`
	CustomerId               null.Int    `json:"customer_id"`
	PartnerId                null.Int    `json:"partner_id"`
	StaffId                  null.Int    `json:"staff_id"`
	WorkOrderId              null.Int    `json:"work_order_id"`
}

func ListAllOldPrivateFiles

func ListAllOldPrivateFiles(db *sql.DB) ([]*OldPrivateFile, error)

type OldSkillSet

type OldSkillSet struct {
	Id          uint64 `json:"id"`
	Category    string `json:"category"`
	SubCategory string `json:"sub_category"`
	Description string `json:"description"`
	IsArchived  bool   `json:"is_archived"`
	OldId       uint64 `json:"old_id"`
}

func ListAllSkillSets

func ListAllSkillSets(db *sql.DB) ([]*OldSkillSet, error)

type OldSkillSetInsuranceRequirement

type OldSkillSetInsuranceRequirement struct {
	Id                     uint64 `json:"id"`
	SkillSetId             uint64 `json:"skill_set_id"`
	InsuranceRequirementId uint64 `json:"insurance_requirement_id"`
}

func ListAllSkillSetInsuranceRequirements

func ListAllSkillSetInsuranceRequirements(db *sql.DB) ([]*OldSkillSetInsuranceRequirement, error)

type OldTenant

type OldTenant struct {
	Id                      uint64          `json:"id"`
	SchemaName              string          `json:"schema_name"`
	Created                 time.Time       `json:"created"`
	LastModified            time.Time       `json:"last_modified"`
	AlternateName           string          `json:"alternate_name"`
	Description             string          `json:"description"`
	Name                    string          `json:"name"`
	Url                     sql.NullString  `json:"url"`
	AreaServed              sql.NullString  `json:"area_served"`
	AvailableLanguage       sql.NullString  `json:"available_language"`
	ContactType             sql.NullString  `json:"contact_type"`
	Email                   sql.NullString  `json:"email"`
	FaxNumber               sql.NullString  `json:"fax_number"`
	Telephone               sql.NullString  `json:"telephone"`
	TelephoneTypeOf         int8            `json:"telephone_type_of"`
	TelephoneExtension      sql.NullString  `json:"telephone_extension"`
	OtherTelephone          sql.NullString  `json:"other_telephone"`
	OtherTelephoneExtension sql.NullString  `json:"other_telephone_extension"`
	OtherTelephoneTypeOf    int8            `json:"other_telephone_type_of"`
	AddressCountry          string          `json:"address_country"`
	AddressRegion           string          `json:"address_region"`
	AddressLocality         string          `json:"address_locality"`
	PostOfficeBoxNumber     string          `json:"post_office_box_number"`
	PostalCode              string          `json:"postal_code"`
	StreetAddress           string          `json:"street_address"`
	StreetAddressExtra      string          `json:"street_address_extra"`
	Elevation               sql.NullFloat64 `json:"elevation"`
	Latitude                sql.NullFloat64 `json:"latitude"`
	Longitude               sql.NullFloat64 `json:"longitude"`
	TimezoneName            string          `json:"timestamp_name"`
	IsArchived              bool            `json:"is_archived"`
}

func ListAllTenants

func ListAllTenants(db *sql.DB) ([]*OldTenant, error)

Function returns a paginated list of all type element items.

type OldUActivitySheetItem

type OldUActivitySheetItem struct {
	Id           uint64      `json:"id"`
	Comment      string      `json:"comment"`
	CreatedAt    time.Time   `json:"created_at"`
	CreatedFrom  null.String `json:"created_from"`
	CreatedById  null.Int    `json:"created_by_id"`
	AssociateId  uint64      `json:"associate_id"`
	JobId        null.Int    `json:"job_id"`
	State        string      `json:"state"`
	OngoingJobId null.Int    `json:"ongoing_job_id"`
}

func ListAllActivitySheetItems

func ListAllActivitySheetItems(db *sql.DB) ([]*OldUActivitySheetItem, error)

type OldUAssociate

type OldUAssociate struct {
	Created                              time.Time   `json:"created"`
	LastModified                         time.Time   `json:"last_modified"`
	AlternateName                        null.String `json:"alternate_name"`
	Description                          null.String `json:"description"`
	Name                                 null.String `json:"name"`
	Url                                  null.String `json:"url"`
	AreaServed                           null.String `json:"area_served"`
	AvailableLanguage                    null.String `json:"available_language"`
	ContactType                          null.String `json:"contact_type"`
	Email                                null.String `json:"email"`
	FaxNumber                            null.String `json:"fax_number"`
	ProductSupported                     null.String `json:"product_supported"`
	Telephone                            null.String `json:"telephone"`
	TelephoneTypeOf                      int8        `json:"telephone_type_of"`
	TelephoneExtension                   null.String `json:"telephone_extension"`
	OtherTelephone                       null.String `json:"other_telephone"`
	OtherTelephoneExtension              null.String `json:"other_telephone_extension"`
	OtherTelephoneTypeOf                 int8        `json:"other_telephone_type_of"`
	AddressCountry                       string      `json:"address_country"`
	AddressLocality                      string      `json:"address_locality"`
	AddressRegion                        string      `json:"address_region"`
	PostOfficeBoxNumber                  null.String `json:"post_office_box_number"`
	PostalCode                           null.String `json:"postal_code"`
	StreetAddress                        string      `json:"street_address"`
	StreetAddressExtra                   null.String `json:"street_address_extra"`
	Elevation                            null.Float  `json:"elevation"`
	Latitude                             null.Float  `json:"latitude"`
	Longitude                            null.Float  `json:"longitude"`
	GivenName                            null.String `json:"given_name"`
	MiddleName                           null.String `json:"middle_name"`
	LastName                             null.String `json:"last_name"`
	Birthdate                            null.Time   `json:"birthdate"`
	JoinDate                             null.Time   `json:"join_date"`
	Nationality                          null.String `json:"nationality"`
	Gender                               null.String `json:"gender"`
	TaxId                                null.String `json:"tax_id"`
	Id                                   uint64      `json:"id"`
	IndexedText                          null.String `json:"indexed_text"`
	TypeOf                               int8        `json:"type_of"`
	IsOkToEmail                          bool        `json:"is_ok_to_email"`
	IsOkToText                           bool        `json:"is_ok_to_text"`
	CreatedFrom                          null.String `json:"created_from"`
	CreatedFromIsPublic                  bool        `json:"created_from_is_public"`
	LastModifiedFrom                     null.String `json:"last_modified_from"`
	LastModifiedFromIsPublic             bool        `json:"last_modified_from_is_public"`
	CreatedById                          null.Int    `json:"created_by_id"`
	LastModifiedById                     null.Int    `json:"last_modified_by_id"`
	OwnerId                              null.Int    `json:"owner_id"`
	HowHearOther                         string      `json:"how_hear_other"`
	IsArchived                           bool        `json:"is_archived"`
	HourlySalaryDesired                  null.Int    `json:"hourly_salary_desired"`
	LimitSpecial                         null.String `json:"limit_special"`
	DuesDate                             null.Time   `json:"dues_date"`
	CommercialInsuranceExpiryDate        null.Time   `json:"commercial_insurance_expiry_date"`
	AutoInsuranceExpiryDate              null.Time   `json:"auto_insurance_expiry_date"`
	WsibNumber                           null.String `json:"wsib_number"`
	WsibInsuranceDate                    null.Time   `json:"wsib_insurance_date"`
	PoliceCheck                          null.Time   `json:"police_check"`
	DriversLicenseClass                  null.String `json:"drivers_license_class"`
	HowHearId                            null.Int    `json:"how_hear_id"`
	HowHearOld                           int8        `json:"how_hear_old"`
	OrganizationName                     null.String `json:"organization_name"`
	OrganizationTypeOf                   int8        `json:"organization_type_of"`
	AvatarImageId                        null.Int    `json:"avatar_image_id"`
	ServiceFeeId                         null.Int    `json:"service_fee_id"`
	EmergencyContactName                 null.String `json:"emergency_contact_name"`
	EmergencyContactRelationship         null.String `json:"emergency_contact_relationship"`
	EmergencyContactTelephone            null.String `json:"emergency_contact_telephone"`
	EmergencyContactAlternativeTelephone null.String `json:"emergency_contact_alternative_telephone"`
	BalanceOwingAmount                   float64     `json:"balance_owing_amount"`
}

func ListAllAssociates

func ListAllAssociates(db *sql.DB) ([]*OldUAssociate, error)

type OldUCustomer

type OldUCustomer struct {
	Created                  time.Time   `json:"created"`
	LastModified             time.Time   `json:"last_modified"`
	AlternateName            null.String `json:"alternate_name"`
	Description              null.String `json:"description"`
	Name                     null.String `json:"name"`
	Url                      null.String `json:"url"`
	AreaServed               null.String `json:"area_served"`
	AvailableLanguage        null.String `json:"available_language"`
	ContactType              null.String `json:"contact_type"`
	Email                    null.String `json:"email"`
	FaxNumber                null.String `json:"fax_number"`
	ProductSupported         null.String `json:"product_supported"`
	Telephone                null.String `json:"telephone"`
	TelephoneTypeOf          int8        `json:"telephone_type_of"`
	TelephoneExtension       null.String `json:"telephone_extension"`
	OtherTelephone           null.String `json:"other_telephone"`
	OtherTelephoneExtension  null.String `json:"other_telephone_extension"`
	OtherTelephoneTypeOf     int8        `json:"other_telephone_type_of"`
	AddressCountry           string      `json:"address_country"`
	AddressLocality          string      `json:"address_locality"`
	AddressRegion            string      `json:"address_region"`
	PostOfficeBoxNumber      null.String `json:"post_office_box_number"`
	PostalCode               null.String `json:"postal_code"`
	StreetAddress            string      `json:"street_address"`
	StreetAddressExtra       null.String `json:"street_address_extra"`
	Elevation                null.Float  `json:"elevation"`
	Latitude                 null.Float  `json:"latitude"`
	Longitude                null.Float  `json:"longitude"`
	GivenName                null.String `json:"given_name"`
	MiddleName               null.String `json:"middle_name"`
	LastName                 null.String `json:"last_name"`
	Birthdate                null.Time   `json:"birthdate"`
	JoinDate                 null.Time   `json:"join_date"`
	Nationality              null.String `json:"nationality"`
	Gender                   null.String `json:"gender"`
	TaxId                    null.String `json:"tax_id"`
	Id                       uint64      `json:"id"`
	IndexedText              null.String `json:"indexed_text"`
	TypeOf                   int8        `json:"type_of"`
	IsOkToEmail              bool        `json:"is_ok_to_email"`
	IsOkToText               bool        `json:"is_ok_to_text"`
	IsBusiness               bool        `json:"is_business"`
	IsSenior                 bool        `json:"is_senior"`
	IsSupport                bool        `json:"is_support"`
	JobInfoRead              null.String `json:"job_info_read"`
	CreatedFrom              null.String `json:"created_from"`
	CreatedFromIsPublic      bool        `json:"created_from_is_public"`
	LastModifiedFrom         null.String `json:"last_modified_from"`
	LastModifiedFromIsPublic bool        `json:"last_modified_from_is_public"`
	IsArchived               bool        `json:"is_archived"`
	CreatedById              null.Int    `json:"created_by_id"`
	LastModifiedById         null.Int    `json:"last_modified_by_id"`
	OrganizationId           null.Int    `json:"organization_id"`
	OwnerId                  null.Int    `json:"owner_id"`
	HowHearOther             string      `json:"how_hear_other"`
	IsBlacklisted            bool        `json:"is_blacklisted"`
	DeactivationReason       int8        `json:"deactivation_reason"`
	DeactivationReasonOther  string      `json:"deactivation_reason_other"`
	State                    string      `json:"state"`
	HowHearId                null.Int    `json:"how_hear_id"`
	HowHearOld               int8        `json:"how_hear_old"`
	OrganizationName         null.String `json:"organization_name"`
	OrganizationTypeOf       int8        `json:"organization_type_of"`
	AvatarImageId            null.Int    `json:"avatar_image_id"`
}

func ListAllCustomers

func ListAllCustomers(db *sql.DB) ([]*OldUCustomer, error)

type OldUCustomerComment

type OldUCustomerComment struct {
	Id         uint64    `json:"id"`
	CreatedAt  time.Time `json:"created_at"`
	CustomerId uint64    `json:"customer_id"`
	CommentId  uint64    `json:"comment_id"`
}

func ListAllCustomerComments

func ListAllCustomerComments(db *sql.DB) ([]*OldUCustomerComment, error)

type OldUCustomerTag

type OldUCustomerTag struct {
	Id         uint64 `json:"id"`
	CustomerId uint64 `json:"customer_id"`
	TagId      uint64 `json:"tag_id"`
}

func ListAllCustomerTags

func ListAllCustomerTags(db *sql.DB) ([]*OldUCustomerTag, error)

type OldUInsuranceRequirement

type OldUInsuranceRequirement struct {
	Id          uint64 `json:"id"`
	Text        string `json:"text"`
	Description string `json:"description"`
	IsArchived  bool   `json:"is_archived"`
}

func ListAllInsuranceRequirements

func ListAllInsuranceRequirements(db *sql.DB) ([]*OldUInsuranceRequirement, error)

type OldUPartner

type OldUPartner struct {
	Created                 time.Time   `json:"created"`
	LastModified            time.Time   `json:"last_modified"`
	AlternateName           null.String `json:"alternate_name"`
	Description             null.String `json:"description"`
	Name                    null.String `json:"name"`
	Url                     null.String `json:"url"`
	AreaServed              null.String `json:"area_served"`
	AvailableLanguage       null.String `json:"available_language"`
	ContactType             null.String `json:"contact_type"`
	Email                   null.String `json:"email"`
	FaxNumber               null.String `json:"fax_number"`
	ProductSupported        null.String `json:"product_supported"`
	Telephone               null.String `json:"telephone"`
	TelephoneTypeOf         int8        `json:"telephone_type_of"`
	TelephoneExtension      null.String `json:"telephone_extension"`
	OtherTelephone          null.String `json:"other_telephone"`
	OtherTelephoneExtension null.String `json:"other_telephone_extension"`
	OtherTelephoneTypeOf    int8        `json:"other_telephone_type_of"`
	AddressCountry          string      `json:"address_country"`
	AddressLocality         string      `json:"address_locality"`
	AddressRegion           string      `json:"address_region"`
	PostOfficeBoxNumber     null.String `json:"post_office_box_number"`
	PostalCode              null.String `json:"postal_code"`
	StreetAddress           string      `json:"street_address"`
	StreetAddressExtra      null.String `json:"street_address_extra"`
	Elevation               null.Float  `json:"elevation"`
	Latitude                null.Float  `json:"latitude"`
	Longitude               null.Float  `json:"longitude"`
	GivenName               null.String `json:"given_name"`
	MiddleName              null.String `json:"middle_name"`
	LastName                null.String `json:"last_name"`
	Birthdate               null.Time   `json:"birthdate"`
	JoinDate                null.Time   `json:"join_date"`
	Nationality             null.String `json:"nationality"`
	Gender                  null.String `json:"gender"`
	TaxId                   null.String `json:"tax_id"`
	Id                      uint64      `json:"id"`
	IndexedText             null.String `json:"indexed_text"`
	// TypeOf                   int8            `json:"type_of"`
	IsOkToEmail              bool        `json:"is_ok_to_email"`
	IsOkToText               bool        `json:"is_ok_to_text"`
	CreatedFrom              null.String `json:"created_from"`
	CreatedFromIsPublic      bool        `json:"created_from_is_public"`
	LastModifiedFrom         null.String `json:"last_modified_from"`
	LastModifiedFromIsPublic bool        `json:"last_modified_from_is_public"`
	CreatedById              null.Int    `json:"created_by_id"`
	LastModifiedById         null.Int    `json:"last_modified_by_id"`
	OwnerId                  null.Int    `json:"owner_id"`
	IsArchived               bool        `json:"is_archived"`
	HowHearId                null.Int    `json:"how_hear_id"`
	HowHearOld               int8        `json:"how_hear_old"`
	OrganizationName         null.String `json:"organization_name"`
	OrganizationTypeOf       int8        `json:"organization_type_of"`
	AvatarImageId            null.Int    `json:"avatar_image_id"`
}

func ListAllPartners

func ListAllPartners(db *sql.DB) ([]*OldUPartner, error)

type OldUStaff

type OldUStaff struct {
	Created                              time.Time   `json:"created"`
	LastModified                         time.Time   `json:"last_modified"`
	AvailableLanguage                    null.String `json:"available_language"`
	ContactType                          null.String `json:"contact_type"`
	Email                                null.String `json:"email"`
	FaxNumber                            null.String `json:"fax_number"`
	Telephone                            null.String `json:"telephone"`
	TelephoneTypeOf                      int8        `json:"telephone_type_of"`
	TelephoneExtension                   null.String `json:"telephone_extension"`
	OtherTelephone                       null.String `json:"other_telephone"`
	OtherTelephoneExtension              null.String `json:"other_telephone_extension"`
	OtherTelephoneTypeOf                 int8        `json:"other_telephone_type_of"`
	AddressCountry                       string      `json:"address_country"`
	AddressLocality                      string      `json:"address_locality"`
	AddressRegion                        string      `json:"address_region"`
	PostOfficeBoxNumber                  null.String `json:"post_office_box_number"`
	PostalCode                           null.String `json:"postal_code"`
	StreetAddress                        string      `json:"street_address"`
	StreetAddressExtra                   null.String `json:"street_address_extra"`
	Elevation                            null.Float  `json:"elevation"`
	Latitude                             null.Float  `json:"latitude"`
	Longitude                            null.Float  `json:"longitude"`
	GivenName                            null.String `json:"given_name"`
	MiddleName                           null.String `json:"middle_name"`
	LastName                             null.String `json:"last_name"`
	Birthdate                            null.Time   `json:"birthdate"`
	JoinDate                             null.Time   `json:"join_date"`
	Nationality                          null.String `json:"nationality"`
	Gender                               null.String `json:"gender"`
	TaxId                                null.String `json:"tax_id"`
	Id                                   uint64      `json:"id"`
	IndexedText                          null.String `json:"indexed_text"`
	CreatedFrom                          null.String `json:"created_from"`
	CreatedFromIsPublic                  bool        `json:"created_from_is_public"`
	LastModifiedFrom                     null.String `json:"last_modified_from"`
	LastModifiedFromIsPublic             bool        `json:"last_modified_from_is_public"`
	IsArchived                           bool        `json:"is_archived"`
	CreatedById                          null.Int    `json:"created_by_id"`
	LastModifiedById                     null.Int    `json:"last_modified_by_id"`
	OwnerId                              null.Int    `json:"owner_id"`
	HowHearOther                         null.String `json:"how_hear_other"`
	HowHearId                            null.Int    `json:"how_hear_id"`
	AvatarImageId                        null.Int    `json:"avatar_image_id"`
	PersonalEmail                        null.String `json:"personal_email"`
	EmergencyContactAlternativeTelephone null.String `json:"emergency_contact_alternative_telephone"`
	EmergencyContactName                 null.String `json:"emergency_contact_name"`
	EmergencyContactRelationship         null.String `json:"emergency_contact_relationship"`
	EmergencyContactTelephone            null.String `json:"emergency_contact_telephone"`
	PoliceCheck                          null.Time   `json:"police_check"`
	Description                          null.String `json:"description"`
}

func ListAllStaffs

func ListAllStaffs(db *sql.DB) ([]*OldUStaff, error)

type OldUStaffComment

type OldUStaffComment struct {
	Id        uint64    `json:"id"`
	CreatedAt time.Time `json:"created_at"`
	StaffId   uint64    `json:"staff_id"`
	CommentId uint64    `json:"comment_id"`
}

func ListAllStaffComments

func ListAllStaffComments(db *sql.DB) ([]*OldUStaffComment, error)

type OldUStaffTag

type OldUStaffTag struct {
	Id      uint64 `json:"id"`
	StaffId uint64 `json:"staff_id"`
	TagId   uint64 `json:"tag_id"`
}

func ListAllStaffTags

func ListAllStaffTags(db *sql.DB) ([]*OldUStaffTag, error)

type OldUTag

type OldUTag struct {
	Id          uint64 `json:"id"`
	Text        string `json:"text"`
	Description string `json:"description"`
	IsArchived  bool   `json:"is_archived"`
}

func ListAllTags

func ListAllTags(db *sql.DB) ([]*OldUTag, error)

type OldUTaskItem

type OldUTaskItem struct {
	Id                       uint64      `json:"id"`
	TypeOf                   int8        `json:"type_of"`
	Title                    string      `json:"title"`
	Description              string      `json:"description"`
	DueDate                  time.Time   `json:"due_date"`
	IsClosed                 bool        `json:"is_closed"`
	WasPostponed             bool        `json:"was_postponed"`
	ClosingReason            int8        `json:"closing_reason"`
	ClosingReasonOther       string      `json:"closing_reason_other"`
	CreatedAt                time.Time   `json:"created_at"`
	CreatedFrom              null.String `json:"created_from"`
	CreatedFromIsPublic      null.Bool   `json:"created_from_is_public"`
	CreatedById              null.Int    `json:"created_by_id"`
	LastModifiedAt           time.Time   `json:"last_modified_at"`
	LastModifiedFrom         null.String `json:"last_modified_from"`
	LastModifiedFromIsPublic null.Bool   `json:"last_modified_from_is_public"`
	JobId                    uint64      `json:"job_id"`
	LastModifiedById         null.Int    `json:"last_modified_by_id"`
	OngoingJobId             null.Int    `json:"ongoing_job_id"`
}

func ListAllTaskItems

func ListAllTaskItems(db *sql.DB) ([]*OldUTaskItem, error)

type OldUVehicleType

type OldUVehicleType struct {
	Id          uint64 `json:"id"`
	Text        string `json:"text"`
	Description string `json:"description"`
	IsArchived  bool   `json:"is_archived"`
}

func ListAllVehicleTypes

func ListAllVehicleTypes(db *sql.DB) ([]*OldUVehicleType, error)

type OldUWorkOrderDeposit

type OldUWorkOrderDeposit struct {
	Id                       uint64      `json:"id"`
	PaidAt                   null.Time   `json:"paid_at"`
	DepositMethod            int8        `json:"deposit_method"`
	PaidTo                   null.Int    `json:"paid_to"`
	AmountCurrency           string      `json:"amount_currency"`
	Amount                   float64     `json:"amount"`
	PaidFor                  int8        `json:"paid_for"`
	IsArchived               bool        `json:"is_archived"`
	CreatedAt                time.Time   `json:"created_at"`
	LastModifiedAt           time.Time   `json:"last_modified_at"`
	CreatedById              null.Int    `json:"created_by_id"`
	LastModifiedById         null.Int    `json:"last_modified_by_id"`
	OrderId                  uint64      `json:"order_id"`
	CreatedFrom              null.String `json:"created_from"`
	CreatedFromIsPublic      bool        `json:"created_from_is_public"`
	LastModifiedFrom         null.String `json:"last_modified_from"`
	LastModifiedFromIsPublic bool        `json:"last_modified_from_is_public"`
}

func ListAllWorkOrderDeposits

func ListAllWorkOrderDeposits(db *sql.DB) ([]*OldUWorkOrderDeposit, error)

type OldUWorkOrderServiceFee

type OldUWorkOrderServiceFee struct {
	Id               uint64    `json:"id"`
	Title            string    `json:"title"`
	Description      string    `json:"description"`
	Percentage       float64   `json:"percentage"`
	CreatedAt        time.Time `json:"created_at"`
	CreatedById      null.Int  `json:"created_by_id,omitempty"`
	LastModifiedAt   time.Time `json:"last_modified_at"`
	LastModifiedById null.Int  `json:"last_modified_by_id,omitempty"`
	IsArchived       bool      `json:"is_archived"`
}

func ListAllWorkOrderServiceFees

func ListAllWorkOrderServiceFees(db *sql.DB) ([]*OldUWorkOrderServiceFee, error)

type OldUser

type OldUser struct {
	Id       uint64        `json:"id"`
	TenantID sql.NullInt64 `json:"franchise_id"`
	// password character varying(128) COLLATE pg_catalog."default" NOT NULL,
	// last_login timestamp with time zone,
	// is_superuser boolean NOT NULL,
	Email      string    `json:"email"`
	FirstName  string    `json:"first_name"`
	LastName   string    `json:"last_name"`
	DateJoined time.Time `json:"date_joined"`
	IsActive   bool      `json:"is_active"`
	// avatar character varying(100) COLLATE pg_catalog."default",
	LastModified time.Time `json:"last_modified"`
	// salt character varying(127) COLLATE pg_catalog."default",
	WasEmailActivated bool `json:"was_email_activated"`
}

func ListAllUsers

func ListAllUsers(db *sql.DB) ([]*OldUser, error)

type OldUserGroup

type OldUserGroup struct {
	Id      uint64 `json:"id"`
	UserId  uint64 `json:"shareduser_id"`
	GroupId uint64 `json:"group_id"`
}

func ListAllUserGroups

func ListAllUserGroups(db *sql.DB) ([]*OldUserGroup, error)

Function returns a paginated list of all type element items.

type OldWorkOrder

type OldWorkOrder struct {
	Id                                        uint64      `json:"id"`
	AssociateId                               null.Int    `json:"associate_id"`
	CustomerId                                uint64      `json:"customer_id"`
	Description                               string      `json:"description"`
	AssignmentDate                            null.Time   `json:"assignment_date"`
	IsOngoing                                 bool        `json:"is_ongoing"`
	IsHomeSupportService                      bool        `json:"is_home_support_service"`
	StartDate                                 time.Time   `json:"start_date"`
	CompletionDate                            null.Time   `json:"completion_date"`
	Hours                                     float64     `json:"hours"`
	TypeOf                                    int8        `json:"type_of"`
	IndexedText                               string      `json:"indexed_text"`
	ClosingReason                             int8        `json:"closing_reason"`
	ClosingReasonOther                        null.String `json:"closing_reason_other"`
	State                                     string      `json:"state"`
	WasJobSatisfactory                        bool        `json:"was_job_satisfactory"`
	WasJobFinishedOnTimeAndOnBudget           bool        `json:"was_job_finished_on_time_and_on_budget"`
	WasAssociatePunctual                      bool        `json:"was_associate_punctual"`
	WasAssociateProfessional                  bool        `json:"was_associate_professional"`
	WouldCustomerReferOurOrganization         bool        `json:"would_customer_refer_our_organization"`
	Score                                     float64     `json:"score"`
	InvoiceDate                               null.Time   `json:"invoice_date"`
	InvoiceQuoteAmountCurrency                string      `json:"invoice_quote_amount_currency"`
	InvoiceQuoteAmount                        float64     `json:"invoice_quote_amount"`
	InvoiceLabourAmountCurrency               string      `json:"invoice_labour_amount_currency"`
	InvoiceLabourAmount                       float64     `json:"invoice_labour_amount"`
	InvoiceMaterialAmountCurrency             string      `json:"invoice_material_amount_currency"`
	InvoiceMaterialAmount                     float64     `json:"invoice_material_amount"`
	InvoiceTaxAmountCurrency                  string      `json:"invoice_tax_amount_currency"`
	InvoiceTaxAmount                          float64     `json:"invoice_tax_amount"`
	InvoiceTotalAmountCurrency                string      `json:"invoice_total_amount_currency"`
	InvoiceTotalAmount                        float64     `json:"invoice_total_amount"`
	InvoiceServiceFeeAmountCurrency           string      `json:"invoice_service_fee_amount_currency"`
	InvoiceServiceFeeAmount                   float64     `json:"invoice_service_fee_amount"`
	InvoiceServiceFeePaymentDate              null.Time   `json:"invoice_service_fee_payment_date"`
	Created                                   time.Time   `json:"created"`
	CreatedById                               null.Int    `json:"created_by_id"`
	CreatedFrom                               null.String `json:"created_from"`
	LastModified                              time.Time   `json:"last_modified"`
	LastModifiedById                          null.Int    `json:"last_modified_by_id"`
	LastModifiedFrom                          null.String `json:"last_modified_from"`
	InvoiceServiceFeeId                       null.Int    `json:"invoice_service_fee_id"`
	LatestPendingTaskId                       null.Int    `json:"latest_pending_task_id"`
	OngoingWorkOrderId                        null.Int    `json:"ongoing_work_order_id"`
	WasSurveyConducted                        bool        `json:"was_survey_conducted"`
	WasThereFinancialsInputted                bool        `json:"was_there_financials_inputted"`
	InvoiceActualServiceFeeAmountPaidCurrency string      `json:"invoice_actual_service_fee_amount_paid_currency"`
	InvoiceActualServiceFeeAmountPaid         float64     `json:"invoice_actual_service_fee_amount_paid"`
	InvoiceBalanceOwingAmountCurrency         string      `json:"invoice_balance_owing_amount_currency"`
	InvoiceBalanceOwingAmount                 float64     `json:"invoice_balance_owing_amount"`
	InvoiceQuotedLabourAmountCurrency         string      `json:"invoice_quoted_labour_amount_currency"`
	InvoiceQuotedLabourAmount                 float64     `json:"invoice_quoted_labour_amount"`
	InvoiceQuotedMaterialAmountCurrency       string      `json:"invoice_quoted_material_amount_currency"`
	InvoiceQuotedMaterialAmount               float64     `json:"invoice_quoted_material_amount"`
	InvoiceTotalQuoteAmountCurrency           string      `json:"invoice_total_quote_amount_currency"`
	InvoiceTotalQuoteAmount                   float64     `json:"invoice_total_quote_amount"`
	Visits                                    int8        `json:"visits"`
	InvoiceIds                                null.String `json:"invoice_ids"`
	NoSurveyConductedReason                   null.Int    `json:"no_survey_conducted_reason"`
	NoSurveyConductedReasonOther              null.String `json:"no_survey_conducted_reason_other"`
	ClonedFromId                              null.Int    `json:"cloned_from_id"`
	InvoiceDepositAmountCurrency              string      `json:"invoice_deposit_amount_currency"`
	InvoiceDepositAmount                      float64     `json:"invoice_deposit_amount"`
	InvoiceOtherCostsAmountCurrency           string      `json:"invoice_other_costs_amount_currency"`
	InvoiceOtherCostsAmount                   float64     `json:"invoice_other_costs_amount"`
	InvoiceQuotedOtherCostsAmountCurrency     string      `json:"invoice_quoted_other_costs_amount_currency"`
	InvoiceQuotedOtherCostsAmount             float64     `json:"invoice_quoted_other_costs_amount"`
	InvoicePaidTo                             null.Int    `json:"invoice_paid_to"`
	InvoiceAmountDueCurrency                  string      `json:"invoice_amount_due_currency"`
	InvoiceAmountDue                          float64     `json:"invoice_amount_due"`
	InvoiceSubTotalAmountCurrency             string      `json:"invoice_sub_total_amount_currency"`
	InvoiceSubTotalAmount                     float64     `json:"invoice_sub_total_amount"`
	ClosingReasonComment                      string      `json:"closing_reason_comment"`
}

func ListAllWorkOrders

func ListAllWorkOrders(db *sql.DB) ([]*OldWorkOrder, error)

type OldWorkOrderComment

type OldWorkOrderComment struct {
	Id          uint64    `json:"id"`
	CreatedAt   time.Time `json:"created_at"`
	WorkOrderId uint64    `json:"about_id"`
	CommentId   uint64    `json:"comment_id"`
}

func ListAllWorkOrderComments

func ListAllWorkOrderComments(db *sql.DB) ([]*OldWorkOrderComment, error)

type OldWorkOrderInvoice

type OldWorkOrderInvoice struct {
	OrderId                  uint64      `json:"order_id"`
	IsArchived               bool        `json:"is_archived"`
	InvoiceId                string      `json:"invoice_id"`
	InvoiceDate              time.Time   `json:"invoice_date"`
	AssociateName            string      `json:"associate_name"`
	AssociateTelephone       string      `json:"associate_telephone"`
	ClientName               string      `json:"client_name"`
	ClientTelephone          string      `json:"client_telephone"`
	ClientEmail              null.String `json:"client_email"`
	Line01Qty                int8        `json:"line_01_qty"`
	Line01Desc               string      `json:"line_01_desc"`
	Line01PriceCurrency      string      `json:"line_01_price_currency"`
	Line01Price              float64     `json:"line_01_price"`
	Line01AmountCurrency     string      `json:"line_01_amount_currency"`
	Line01Amount             float64     `json:"line_01_amount"`
	Line02Qty                null.Int    `json:"line_02_qty"` // Make `int8`
	Line02Desc               null.String `json:"line_02_desc"`
	Line02PriceCurrency      null.String `json:"line_02_price_currency"`
	Line02Price              null.Float  `json:"line_02_price"`
	Line02AmountCurrency     null.String `json:"line_02_amount_currency"`
	Line02Amount             null.Float  `json:"line_02_amount"`
	Line03Qty                null.Int    `json:"line_03_qty"` // Make `int8`
	Line03Desc               null.String `json:"line_03_desc"`
	Line03PriceCurrency      null.String `json:"line_03_price_currency"`
	Line03Price              null.Float  `json:"line_03_price"`
	Line03AmountCurrency     null.String `json:"line_03_amount_currency"`
	Line03Amount             null.Float  `json:"line_03_amount"`
	Line04Qty                null.Int    `json:"line_04_qty"` // Make `int8`
	Line04Desc               null.String `json:"line_04_desc"`
	Line04PriceCurrency      null.String `json:"line_04_price_currency"`
	Line04Price              null.Float  `json:"line_04_price"`
	Line04AmountCurrency     null.String `json:"line_04_amount_currency"`
	Line04Amount             null.Float  `json:"line_04_amount"`
	Line05Qty                null.Int    `json:"line_05_qty"` // Make `int8`
	Line05Desc               null.String `json:"line_05_desc"`
	Line05PriceCurrency      null.String `json:"line_05_price_currency"`
	Line05Price              null.Float  `json:"line_05_price"`
	Line05AmountCurrency     null.String `json:"line_05_amount_currency"`
	Line05Amount             null.Float  `json:"line_05_amount"`
	Line06Qty                null.Int    `json:"line_06_qty"` // Make `int8`
	Line06Desc               null.String `json:"line_06_desc"`
	Line06PriceCurrency      null.String `json:"line_06_price_currency"`
	Line06Price              null.Float  `json:"line_06_price"`
	Line06AmountCurrency     null.String `json:"line_06_amount_currency"`
	Line06Amount             null.Float  `json:"line_06_amount"`
	Line07Qty                null.Int    `json:"line_07_qty"` // Make `int8`
	Line07Desc               null.String `json:"line_07_desc"`
	Line07PriceCurrency      null.String `json:"line_07_price_currency"`
	Line07Price              null.Float  `json:"line_07_price"`
	Line07AmountCurrency     null.String `json:"line_07_amount_currency"`
	Line07Amount             null.Float  `json:"line_07_amount"`
	Line08Qty                null.Int    `json:"line_08_qty"` // Make `int8`
	Line08Desc               null.String `json:"line_08_desc"`
	Line08PriceCurrency      null.String `json:"line_08_price_currency"`
	Line08Price              null.Float  `json:"line_08_price"`
	Line08AmountCurrency     null.String `json:"line_08_amount_currency"`
	Line08Amount             null.Float  `json:"line_08_amount"`
	Line09Qty                null.Int    `json:"line_09_qty"` // Make `int8`
	Line09Desc               null.String `json:"line_09_desc"`
	Line09PriceCurrency      null.String `json:"line_09_price_currency"`
	Line09Price              null.Float  `json:"line_09_price"`
	Line09AmountCurrency     null.String `json:"line_09_amount_currency"`
	Line09Amount             null.Float  `json:"line_09_amount"`
	Line10Qty                null.Int    `json:"line_10_qty"` // Make `int8`
	Line10Desc               null.String `json:"line_10_desc"`
	Line10PriceCurrency      null.String `json:"line_10_price_currency"`
	Line10Price              null.Float  `json:"line_10_price"`
	Line10AmountCurrency     null.String `json:"line_10_amount_currency"`
	Line10Amount             null.Float  `json:"line_10_amount"`
	Line11Qty                null.Int    `json:"line_11_qty"` // Make `int8`
	Line11Desc               null.String `json:"line_11_desc"`
	Line11PriceCurrency      null.String `json:"line_11_price_currency"`
	Line11Price              null.Float  `json:"line_11_price"`
	Line11AmountCurrency     null.String `json:"line_11_amount_currency"`
	Line11Amount             null.Float  `json:"line_11_amount"`
	Line12Qty                null.Int    `json:"line_12_qty"` // Make `int8`
	Line12Desc               null.String `json:"line_12_desc"`
	Line12PriceCurrency      null.String `json:"line_12_price_currency"`
	Line12Price              null.Float  `json:"line_12_price"`
	Line12AmountCurrency     null.String `json:"line_12_amount_currency"`
	Line12Amount             null.Float  `json:"line_12_amount"`
	Line13Qty                null.Int    `json:"line_13_qty"` // Make `int8`
	Line13Desc               null.String `json:"line_13_desc"`
	Line13PriceCurrency      null.String `json:"line_13_price_currency"`
	Line13Price              null.Float  `json:"line_13_price"`
	Line13AmountCurrency     null.String `json:"line_13_amount_currency"`
	Line13Amount             null.Float  `json:"line_13_amount"`
	Line14Qty                null.Int    `json:"line_14_qty"` // Make `int8`
	Line14Desc               null.String `json:"line_14_desc"`
	Line14PriceCurrency      null.String `json:"line_14_price_currency"`
	Line14Price              null.Float  `json:"line_14_price"`
	Line14AmountCurrency     null.String `json:"line_14_amount_currency"`
	Line14Amount             null.Float  `json:"line_14_amount"`
	Line15Qty                null.Int    `json:"line_15_qty"` // Make `int8`
	Line15Desc               null.String `json:"line_15_desc"`
	Line15PriceCurrency      null.String `json:"line_15_price_currency"`
	Line15Price              null.Float  `json:"line_15_price"`
	Line15AmountCurrency     null.String `json:"line_15_amount_currency"`
	Line15Amount             null.Float  `json:"line_15_amount"`
	InvoiceQuoteDays         int8        `json:"invoice_quote_days"`
	InvoiceAssociateTax      null.String `json:"invoice_associate_tax"`
	InvoiceQuoteDate         time.Time   `json:"invoice_quote_date"`
	InvoiceCustomersApproval string      `json:"invoice_customers_approval"`
	Line01Notes              null.String `json:"line_01_notes"`
	Line02Notes              null.String `json:"line_02_notes"`
	TotalLabourCurrency      string      `json:"total_labour_currency"`
	TotalLabour              float64     `json:"total_labour"`
	TotalMaterialsCurrency   string      `json:"total_materials_currency"`
	TotalMaterials           float64     `json:"total_materials"`
	OtherCostsCurrency       string      `json:"other_costs_currency"`
	OtherCosts               float64     `json:"other_costs"`
	AmountDueCurrency        string      `json:"amount_due_currency"`
	TaxCurrency              string      `json:"tax_currency"`
	Tax                      float64     `json:"tax"`
	TotalCurrency            string      `json:"total_currency"`
	Total                    float64     `json:"total"`
	DepositCurrency          string      `json:"deposit_currency"`
	PaymentAmountCurrency    string      `json:"payment_amount_currency"`
	PaymentAmount            float64     `json:"payment_amount"`
	PaymentDate              time.Time   `json:"payment_date"`
	IsCash                   bool        `json:"is_cash"`
	IsCheque                 bool        `json:"is_cheque"`
	IsDebit                  bool        `json:"is_debit"`
	IsCredit                 bool        `json:"is_credit"`
	IsOther                  bool        `json:"is_other"`
	ClientSignature          string      `json:"client_signature"`
	AssociateSignDate        time.Time   `json:"associate_sign_date"`
	AssociateSignature       string      `json:"associate_signature"`
	WorkOrderId              uint64      `json:"work_order_id"`
	CreatedAt                time.Time   `json:"created_at"`
	LastModifiedAt           time.Time   `json:"last_modified_at"`
	CreatedById              uint64      `json:"created_by_id"`
	LastModifiedById         uint64      `json:"last_modified_by_id"`
	CreatedFrom              string      `json:"created_from"`
	CreatedFromIsPublic      bool        `json:"created_from_is_public"`
	LastModifiedFrom         string      `json:"last_modified_from"`
	LastModifiedFromIsPublic bool        `json:"last_modified_from_is_public"`
	ClientAddress            string      `json:"client_address"`
	RevisionVersion          int8        `json:"revision_version"`
	Deposit                  float64     `json:"deposit"`
	AmountDue                float64     `json:"amount_due"`
	SubTotal                 float64     `json:"sub_total"`
	SubTotalCurrency         string      `json:"sub_total_currency"`
}

func ListAllWorkOrderInvoices

func ListAllWorkOrderInvoices(db *sql.DB) ([]*OldWorkOrderInvoice, error)

type OldWorkOrderSkillSet

type OldWorkOrderSkillSet struct {
	Id          uint64 `json:"id"`
	WorkOrderId uint64 `json:"workorder_id"`
	SkillSetId  uint64 `json:"skillset_id"`
}

func ListAllWorkOrderSkillSets

func ListAllWorkOrderSkillSets(db *sql.DB) ([]*OldWorkOrderSkillSet, error)

type OldWorkOrderTag

type OldWorkOrderTag struct {
	Id          uint64 `json:"id"`
	WorkOrderId uint64 `json:"workorder_id"`
	TagId       uint64 `json:"tag_id"`
}

func ListAllWorkOrderTags

func ListAllWorkOrderTags(db *sql.DB) ([]*OldWorkOrderTag, error)

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL