Documentation ¶
Index ¶
- func Execute()
- func ListAllPrivateFilesByTenantID(db *sql.DB, tenantID uint64) ([]*models.PrivateFile, error)
- type OldAssociateAwayLog
- type OldAssociateComment
- type OldAssociateInsuranceRequirement
- type OldAssociateSkillSet
- type OldAssociateTag
- type OldAssociateVehicleType
- type OldBulletinBoardItem
- type OldComment
- type OldHowHearAboutUsItem
- type OldOngoingWorkOrder
- type OldOngoingWorkOrderComment
- type OldPartnerComment
- type OldPrivateFile
- type OldSkillSet
- type OldSkillSetInsuranceRequirement
- type OldTenant
- type OldUActivitySheetItem
- type OldUAssociate
- type OldUCustomer
- type OldUCustomerComment
- type OldUCustomerTag
- type OldUInsuranceRequirement
- type OldUPartner
- type OldUStaff
- type OldUStaffComment
- type OldUStaffTag
- type OldUTag
- type OldUTaskItem
- type OldUVehicleType
- type OldUWorkOrderDeposit
- type OldUWorkOrderServiceFee
- type OldUser
- type OldUserGroup
- type OldWorkOrder
- type OldWorkOrderComment
- type OldWorkOrderInvoice
- type OldWorkOrderSkillSet
- type OldWorkOrderTag
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
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"` }
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"` }
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 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"` }
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)
Source Files ¶
- bleve.go
- change_password.go
- create_tenant.go
- create_user.go
- etl_activity_sheet_item.go
- etl_associate.go
- etl_associate_away_log.go
- etl_associate_comment.go
- etl_associate_insurance_requirement.go
- etl_associate_skill_set.go
- etl_associate_tag.go
- etl_associate_vehicle_type.go
- etl_bulletin_board_item.go
- etl_comment.go
- etl_customer.go
- etl_customer_comment.go
- etl_customer_tag.go
- etl_how_hear_about_us_item.go
- etl_insurance_requirement.go
- etl_ongoing_work_order.go
- etl_ongoing_work_order_comment.go
- etl_partner.go
- etl_partner_comment.go
- etl_private_file_download_to_tmp_dir.go
- etl_private_file_upload_from_tmp_dir.go
- etl_skill_set.go
- etl_skill_set_insurance_requirement.go
- etl_staff.go
- etl_staff_comment.go
- etl_staff_tag.go
- etl_staff_type_of.go
- etl_tag.go
- etl_task_item.go
- etl_tenant.go
- etl_user.go
- etl_user_group.go
- etl_vehicle_type.go
- etl_work_order.go
- etl_work_order_comment.go
- etl_work_order_deposit.go
- etl_work_order_invoice.go
- etl_work_order_service_fee.go
- etl_work_order_skill_set.go
- etl_work_order_tag.go
- root.go
- serve.go
- version.go
- work.go
Click to show internal directories.
Click to hide internal directories.