six910dbi

type Address struct {
	ID         int64  `json:"id"`
	Address    string `json:"address"`
	City       string `json:"city"`
	State      string `json:"state"`
	Zip        string `json:"zip"`
	County     string `json:"county"`
	Country    string `json:"country"`
	Type       string `json:"type"`
	CustomerID int64  `json:"customerId"`
}

type Cart struct {
	ID          int64     `json:"id"`
	StoreID     int64     `json:"storeId"`
	CustomerID  int64     `json:"customerId"`
	IPAddress   string    `json:"ipAddress"`
	UserInfo    string    `json:"userInfo"`
	DateEntered time.Time `json:"entered"`
	DateUpdated time.Time `json:"updated"`
}

type CartItem struct {
	ID        int64 `json:"id"`
	Quantity  int64 `json:"quantity"`
	CartID    int64 `json:"cartId"`
	ProductID int64 `json:"productId"`
}

type Category struct {
	ID               int64  `json:"id"`
	Name             string `json:"name"`
	Description      string `json:"desc"`
	Image            string `json:"image"`
	Thumbnail        string `json:"thumbnail"`
	StoreID          int64  `json:"storeId"`
	ParentCategoryID int64  `json:"parentCategoryId"`
}

type Customer struct {
	ID            int64     `json:"id"`
	Email         string    `json:"email"`
	ResetPassword bool      `json:"resetPassword"`
	FirstName     string    `json:"firstName"`
	LastName      string    `json:"lastName"`
	Company       string    `json:"company"`
	City          string    `json:"city"`
	State         string    `json:"state"`
	Zip           string    `json:"zip"`
	Phone         string    `json:"phone"`
	DateEntered   time.Time `json:"entered"`
	DateUpdated   time.Time `json:"updated"`
	StoreID       int64     `json:"storeId"`
}

type DataStoreWriteLock struct {
	ID                 int64     `json:"id"`
	DataStoreName      string    `json:"dataStoreName"`
	Locked             bool      `json:"locked"`
	LockedInstanceName string    `json:"lockedInstanceName"`
	LockedTime         time.Time `json:"lockedTime"`
	LockedByUser       string    `json:"lockedByUser"`
	StoreID            int64     `json:"storeId"`
}

type Distributor struct {
	ID          int64  `json:"id"`
	Company     string `json:"company"`
	ContactName string `json:"contactName"`
	Phone       string `json:"phone"`
	StoreID     int64  `json:"storeId"`
}

type ExcludedSubRegion struct {
	ID               int64 `json:"id"`
	RegionID         int64 `json:"regionId"`
	ShippingMethodID int64 `json:"shippingMethodId"`
	SubRegionID      int64 `json:"subRegionId"`
}

type IncludedSubRegion struct {
	ID               int64 `json:"id"`
	RegionID         int64 `json:"regionId"`
	ShippingMethodID int64 `json:"shippingMethodId"`
	SubRegionID      int64 `json:"subRegionId"`
}

type Instances struct {
	InstanceName  string    `json:"instanceName"`
	ReloadDate    time.Time `json:"reloadDate"`
	StoreID       int64     `json:"storeId"`
	DataStoreName string    `json:"dataStoreName"`
}

type Insurance struct {
	ID             int64   `json:"id"`
	Cost           float64 `json:"cost"`
	MinOrderAmount float64 `json:"minOrderAmount"`
	MaxOrderAmount float64 `json:"maxOrderAmount"`
	StoreID        int64   `json:"storeId"`
}

type LocalAccount struct {
	UserName    string    `json:"username"`
	Password    string    `json:"password"`
	Enabled     bool      `json:"enabled"`
	Role        string    `json:"role"`
	DateEntered time.Time `json:"entered"`
	DateUpdated time.Time `json:"updated"`
	StoreID     int64     `json:"storeId"`
	CustomerID  int64     `json:"customerId"`
}

type LocalDataStore struct {
	StoreID       int64     `json:"storeId"`
	DataStoreName string    `json:"dataStoreName"`
	Reload        bool      `json:"reload"`
	ReloadDate    time.Time `json:"reloadDate"`
}

type Order struct {
	ID                int64     `json:"id"`
	OrderDate         time.Time `json:"orderDate"`
	Updated           time.Time `json:"updated"`
	Status            string    `json:"status"`
	Subtotal          float64   `json:"subTotal"`
	ShippingHandling  float64   `json:"shippingHandling"`
	Insurance         float64   `json:"insurance"`
	Taxes             float64   `json:"taxes"`
	Total             float64   `json:"total"`
	OrderNumber       string    `json:"orderNumber"`
	OrderType         string    `json:"orderType"`
	Pickup            bool      `json:"pickup"`
	Username          string    `json:"username"`
	CustomerName      string    `json:"customerName"`
	CustomerID        int64     `json:"customerId"`
	BillingAddress    string    `json:"billingAddress"`
	BillingAddressID  int64     `json:"billingAddressId"`
	ShippingAddress   string    `json:"shippingAddress"`
	ShippingAddressID int64     `json:"shippingAddressId"`
	StoreID           int64     `json:"storeId"`
}

type OrderComment struct {
	ID       int64  `json:"id"`
	Comment  string `json:"comment"`
	Username string `json:"username"`
	OrderID  int64  `json:"orderId"`
}

type OrderItem struct {
	ID               int64  `json:"id"`
	Quantity         int64  `json:"quantity"`
	BackOrdered      bool   `json:"backOrdered"`
	Dropship         bool   `json:"dropship"`
	ProductName      string `json:"productName"`
	ProductShortDesc string `json:"productShortDesc"`
	ProductID        int64  `json:"productId"`
	OrderID          int64  `json:"orderId"`
}

type OrderTransaction struct {
	ID              int64     `json:"id"`
	DateEntered     time.Time `json:"entered"`
	TransactionID   string    `json:"transactionId"`
	Type            string    `json:"type"`
	Method          string    `json:"method"`
	Amount          float64   `json:"amount"`
	Approval        string    `json:"approval"`
	ReferenceNumber string    `json:"referenceNumber"`
	Avs             string    `json:"avs"`
	ResponseMessage string    `json:"responseMessage"`
	ResponseCode    string    `json:"responseCode"`
	Gwid            int64     `json:"gwid"`
	Success         bool      `json:"success"`
	OrderID         int64     `json:"orderId"`
}

type PaymentGateway struct {
	ID             int64  `json:"id"`
	CheckoutURL    string `json:"checkoutUrl"`
	PostOrderURL   string `json:"postOrderUrl"`
	LogoURL        string `json:"logoUrl"`
	ClientID       string `json:"clientId"`
	ClientKey      string `json:"clientKey"`
	StorePluginsID int64  `json:"storePluginsId"`
}

type Plugins struct {
	ID               int64   `json:"id"`
	PluginName       string  `json:"pluginName"`
	Developer        string  `json:"developer"`
	ContactPhone     string  `json:"contactPhone"`
	DeveloperAddress string  `json:"developerAddress"`
	Fee              float64 `json:"fee"`
	Enabled          bool    `json:"enabled"`
	Category         string  `json:"category"`
	ActivateURL      string  `json:"activateUrl"`
	OauthRedirectURL string  `json:"oauthRedirectUrl"`
	IsPGW            bool    `json:"isPgw"`
}

type Product struct {
	ID                    int64     `json:"id"`
	Sku                   string    `json:"sku"`
	Gtin                  string    `json:"gtin"`
	Name                  string    `json:"name"`
	ShortDesc             string    `json:"shortDesc"`
	Desc                  string    `json:"desc"`
	Cost                  float64   `json:"cost"`
	Msrp                  float64   `json:"msrp"`
	Map                   float64   `json:"map"`
	Price                 float64   `json:"price"`
	SalePrice             float64   `json:"salePrice"`
	Currency              string    `json:"currency"`
	Manufacturer          string    `json:"manufacturer"`
	Stock                 int64     `json:"stock"`
	StockAlert            int64     `json:"stockAlert"`
	Weight                float64   `json:"weight"`
	Width                 float64   `json:"width"`
	Height                float64   `json:"height"`
	Depth                 float64   `json:"depth"`
	ShippingMarkup        float64   `json:"shippingMarkup"`
	Visible               bool      `json:"visible"`
	Searchable            bool      `json:"searchable"`
	MultiBox              bool      `json:"multibox"`
	ShipSeperately        bool      `json:"shipSeperately"`
	FreeShipping          bool      `json:"freeShipping"`
	Promoted              bool      `json:"promoted"`
	Dropship              bool      `json:"dropship"`
	SpecialProcessing     bool      `json:"specialProcessing"`
	SpecialProcessingType string    `json:"specialProcessingType"`
	Size                  string    `json:"size"`
	Color                 string    `json:"color"`
	Thumbnail             string    `json:"thumbnail"`
	Image1                string    `json:"image1"`
	Image2                string    `json:"image2"`
	Image3                string    `json:"image3"`
	Image4                string    `json:"image4"`
	DistributorID         int64     `json:"distributorId"`
	StoreID               int64     `json:"storeId"`
	ParentProductID       int64     `json:"parentProductId"`
	DateEntered           time.Time `json:"entered"`
	DateUpdated           time.Time `json:"updated"`
}

type ProductCategory struct {
	CategoryID int64 `json:"categoryId"`
	ProductID  int64 `json:"productId"`
}

type Region struct {
	ID         int64  `json:"id"`
	RegionCode string `json:"regionCode"`
	Name       string `json:"name"`
	StoreID    int64  `json:"storeId"`
}

type Security struct {
	ID      int64 `json:"id"`
	OauthOn bool  `json:"oauthOn"`
}

type Shipment struct {
	ID               int64     `json:"id"`
	Status           string    `json:"status"`
	Boxes            int64     `json:"boxes"`
	ShippingHandling float64   `json:"shippingHandling"`
	Insurance        float64   `json:"insurance"`
	CreateDate       time.Time `json:"createDate"`
	Updated          time.Time `json:"updated"`
	OrderID          int64     `json:"orderId"`
}

type ShipmentBox struct {
	ID                int64     `json:"id"`
	BoxNumber         int64     `json:"boxNumber"`
	Dropship          bool      `json:"dropship"`
	Cost              float64   `json:"cost"`
	Insurance         float64   `json:"insurance"`
	Weight            float64   `json:"weight"`
	Width             float64   `json:"width"`
	Height            float64   `json:"height"`
	Depth             float64   `json:"depth"`
	TrackingNumber    string    `json:"trackingNumber"`
	ShippingAddress   string    `json:"shippingAddress"`
	ShipDate          time.Time `json:"shipDate"`
	Updated           time.Time `json:"updated"`
	ShippingMethodID  int64     `json:"shippingMethodId"`
	ShippingAddressID int64     `json:"shippingAddressId"`
	ShipmentID        int64     `json:"shipmentId"`
}

type ShipmentItem struct {
	ID            int64     `json:"id"`
	Quantity      int64     `json:"quantity"`
	Updated       time.Time `json:"updated"`
	OrderItemID   int64     `json:"orderItemId"`
	ShipmentBoxID int64     `json:"shipmentBoxId"`
	ShipmentID    int64     `json:"shipmentId"`
}

type ShippingCarrier struct {
	ID      int64  `json:"id"`
	Carrier string `json:"carrier"`
	Type    string `json:"type"`
	StoreID int64  `json:"storeId"`
}

type ShippingMethod struct {
	ID                int64   `json:"id"`
	Name              string  `json:"name"`
	Cost              float64 `json:"cost"`
	MaxWeight         int64   `json:"maxWeight"`
	Handling          float64 `json:"handling"`
	MinOrderAmount    float64 `json:"minOrderAmount"`
	MaxOrderAmount    float64 `json:"maxOrderAmount"`
	StoreID           int64   `json:"storeId"`
	RegionID          int64   `json:"regionId"`
	ShippingCarrierID int64   `json:"shippingCarrierId"`
	InsuranceID       int64   `json:"insuranceId"`
}

type Six910DB interface {
	//sets security level to local or oauth using GoAuth2
	AddSecurity(s *Security) (bool, int64)
	UpdateSecurity(s *Security) bool
	GetSecurity() *Security
	DeleteSecurity() bool

	//stores
	AddStore(s *Store) (bool, int64)
	UpdateStore(s *Store) bool
	GetStore(sname string) *Store
	GetLocalStore() *Store
	GetStoreID(id int64) *Store
	GetStoreCount() int64
	GetStoreByLocal(localDomain string) *Store
	DeleteStore(id int64) bool

	//customer
	AddCustomer(c *Customer) (bool, int64)
	UpdateCustomer(c *Customer) bool
	GetCustomer(email string, storeID int64) *Customer
	GetCustomerID(id int64) *Customer
	GetCustomerList(storeID int64) *[]Customer
	DeleteCustomer(id int64) bool

	//Local Accounts when oauth not used
	AddLocalAccount(a *LocalAccount) bool
	UpdateLocalAccount(a *LocalAccount) bool
	GetLocalAccount(username string, storeID int64) *LocalAccount
	GetLocalAccountList(store int64) *[]LocalAccount
	DeleteLocalAccount(username string, storeID int64) bool

	//distributors
	AddDistributor(d *Distributor) (bool, int64)
	UpdateDistributor(d *Distributor) bool
	GetDistributor(id int64) *Distributor
	GetDistributorList(store int64) *[]Distributor
	DeleteDistributor(id int64) bool

	//Cart
	AddCart(c *Cart) (bool, int64)
	UpdateCart(c *Cart) bool
	GetCart(cid int64) *Cart
	DeleteCart(id int64) bool

	//cart item
	AddCartItem(ci *CartItem) (bool, int64)
	UpdateCartItem(ci *CartItem) bool
	GetCarItem(cartID int64, prodID int64) *CartItem
	GetCartItemList(cartID int64) *[]CartItem
	DeleteCartItem(id int64) bool

	//address
	AddAddress(a *Address) (bool, int64)
	UpdateAddress(a *Address) bool
	GetAddress(id int64) *Address
	GetAddressList(cid int64) *[]Address
	DeleteAddress(id int64) bool

	//category
	AddCategory(c *Category) (bool, int64)
	UpdateCategory(c *Category) bool
	GetCategory(id int64) *Category
	GetCategoryList(storeID int64) *[]Category
	GetSubCategoryList(catID int64) *[]Category
	DeleteCategory(id int64) bool

	//shipping method
	AddShippingMethod(s *ShippingMethod) (bool, int64)
	UpdateShippingMethod(s *ShippingMethod) bool
	GetShippingMethod(id int64) *ShippingMethod
	GetShippingMethodList(storeID int64) *[]ShippingMethod
	DeleteShippingMethod(id int64) bool

	//shipping insurance
	AddInsurance(i *Insurance) (bool, int64)
	UpdateInsurance(i *Insurance) bool
	GetInsurance(id int64) *Insurance
	GetInsuranceList(storeID int64) *[]Insurance
	DeleteInsurance(id int64) bool

	//product
	AddProduct(p *Product) (bool, int64)
	UpdateProduct(p *Product) bool
	GetProductByID(id int64) *Product
	GetProductsByName(name string, storeID int64, start int64, end int64) *[]Product
	GetProductsByCaterory(catID int64, start int64, end int64) *[]Product
	GetProductList(storeID int64, start int64, end int64) *[]Product
	DeleteProduct(id int64) bool

	//Geographic Regions
	AddRegion(r *Region) (bool, int64)
	UpdateRegion(r *Region) bool
	GetRegion(id int64) *Region
	GetRegionList(storeID int64) *[]Region
	DeleteRegion(id int64) bool

	//Geographic Sub Regions
	AddSubRegion(s *SubRegion) (bool, int64)
	UpdateSubRegion(s *SubRegion) bool
	GetSubRegion(id int64) *SubRegion
	GetSubRegionList(regionID int64) *[]SubRegion
	DeleteSubRegion(id int64) bool

	//excluded sub regions
	AddExcludedSubRegion(e *ExcludedSubRegion) (bool, int64)
	UpdateExcludedSubRegion(e *ExcludedSubRegion) bool
	GetExcludedSubRegion(id int64) *ExcludedSubRegion
	GetExcludedSubRegionList(regionID int64) *[]ExcludedSubRegion
	DeleteExcludedSubRegion(id int64) bool

	//included sub regions
	AddIncludedSubRegion(e *IncludedSubRegion) (bool, int64)
	UpdateIncludedSubRegion(e *IncludedSubRegion) bool
	GetIncludedSubRegion(id int64) *IncludedSubRegion
	GetIncludedSubRegionList(regionID int64) *[]IncludedSubRegion
	DeleteIncludedSubRegion(id int64) bool

	//limit exclusions and inclusions to a zip code
	AddZoneZip(z *ZoneZip) (bool, int64)
	GetZoneZipListByExclusion(exID int64) *[]ZoneZip
	GetZoneZipListByInclusion(incID int64) *[]ZoneZip
	DeleteZoneZip(id int64) bool

	//product category
	AddProductCategory(pc *ProductCategory) bool
	DeleteProductCategory(pc *ProductCategory) bool

	//Orders
	AddOrder(o *Order) (bool, int64)
	UpdateOrder(o *Order) bool
	GetOrder(id int64) *Order
	GetOrderList(cid int64, storeID int64) *[]Order
	DeleteOrder(id int64) bool

	//Order Items
	AddOrderItem(i *OrderItem) (bool, int64)
	UpdateOrderItem(i *OrderItem) bool
	GetOrderItem(id int64) *OrderItem
	GetOrderItemList(orderID int64) *[]OrderItem
	DeleteOrderItem(id int64) bool

	//Order Comments
	AddOrderComments(c *OrderComment) (bool, int64)
	GetOrderCommentList(orderID int64) *[]OrderComment

	//Order Payment Transactions
	AddOrderTransaction(t *OrderTransaction) (bool, int64)
	GetOrderTransactionList(orderID int64) *[]OrderTransaction

	//shipment
	AddShipment(s *Shipment) (bool, int64)
	UpdateShipment(s *Shipment) bool
	GetShipment(id int64) *Shipment
	GetShipmentList(orderID int64) *[]Shipment
	DeleteShipment(id int64) bool

	//shipment boxes
	AddShipmentBox(sb *ShipmentBox) (bool, int64)
	UpdateShipmentBox(sb *ShipmentBox) bool
	GetShipmentBox(id int64) *ShipmentBox
	GetShipmentBoxList(shipmentID int64) *[]ShipmentBox
	DeleteShipmentBox(id int64) bool

	//Shipment Items in box
	AddShipmentItem(si *ShipmentItem) (bool, int64)
	UpdateShipmentItem(si *ShipmentItem) bool
	GetShipmentItem(id int64) *ShipmentItem
	GetShipmentItemList(shipmentID int64) *[]ShipmentItem
	GetShipmentItemListByBox(boxNumber int64, shipmentID int64) *[]ShipmentItem
	DeleteShipmentItem(id int64) bool

	//Global Plugins
	AddPlugin(p *Plugins) (bool, int64)
	UpdatePlugin(p *Plugins) bool
	GetPlugin(id int64) *Plugins
	GetPluginList(start int64, end int64) *[]Plugins
	DeletePlugin(id int64) bool

	//store plugins installed
	AddStorePlugin(sp *StorePlugins) (bool, int64)
	UpdateStorePlugin(sp *StorePlugins) bool
	GetStorePlugin(id int64) *StorePlugins
	GetStorePluginList(storeID int64) *[]StorePlugins
	DeleteStorePlugin(id int64) bool

	//Plugins that are payment gateways
	AddPaymentGateway(pgw *PaymentGateway) (bool, int64)
	UpdatePaymentGateway(pgw *PaymentGateway) bool
	GetPaymentGateway(id int64) *PaymentGateway
	GetPaymentGateways(storeID int64) *[]PaymentGateway
	DeletePaymentGateway(id int64) bool

	//store shipment carrier like UPS and FEDex
	AddShippingCarrier(c *ShippingCarrier) (bool, int64)
	UpdateShippingCarrier(c *ShippingCarrier) bool
	GetShippingCarrier(id int64) *ShippingCarrier
	GetShippingCarrierList(storeID int64) *[]ShippingCarrier
	DeleteShippingCarrier(id int64) bool

	//----------------start datastore------------------------------------
	//this gets called when a node start up and add only if it doesn't already exist
	AddLocalDatastore(d *LocalDataStore) bool

	//This get get called when a change is made to a datastore from a node in the cluster
	//Or after all reloads have completed and then get set to Reload = false
	UpdateLocalDatastore(d *LocalDataStore) bool

	//This gets call by cluster nodes to see if there are pending reload
	GetLocalDatastore(storeID int64, dataStoreName string) *LocalDataStore

	//---------------------start instance--------------------
	// this gets called when each instance is started and added only if never added before
	//The instance name is pulled from Docker or an manually entered env variable
	AddInstance(i *Instances) bool

	//This gets called after instance gets reloaded
	UpdateInstance(i *Instances) bool

	//Gets called before updating an instance
	GetInstance(name string, dataStoreName string, storeID int64) *Instances

	//-------------------start write lock-------------
	//gets called after UI makes changes to one of the datastores
	//If the datastore already exists, the Update method is called from within add
	AddDataStoreWriteLock(w *DataStoreWriteLock) (bool, int64)
	UpdateDataStoreWriteLock(w *DataStoreWriteLock) bool

	//gets called from within the add method and by any node trying to update a datastore
	GetDataStoreWriteLock(dataStore string, storeID int64) *DataStoreWriteLock
}

type Store struct {
	ID            int64     `json:"id"`
	Company       string    `json:"company"`
	FirstName     string    `json:"firstName"`
	LastName      string    `json:"lastName"`
	LocalDomain   string    `json:"localDomain"`
	RemoteDomain  string    `json:"remoteDomain"`
	OauthClientID int64     `json:"oauthClientId"`
	OauthSecret   string    `json:"oauthSecret"`
	Email         string    `json:"email"`
	City          string    `json:"city"`
	State         string    `json:"state"`
	Zip           string    `json:"zip"`
	DateEntered   time.Time `json:"entered"`
	DateUpdated   time.Time `json:"updated"`
	StoreName     string    `json:"storeName"`
	StoreSlogan   string    `json:"storeSlogan"`
	Logo          string    `json:"logo"`
	Currency      string    `json:"currency"`
	Enabled       bool      `json:"enabled"`
}

type StorePlugins struct {
	ID               int64     `json:"id"`
	PluginName       string    `json:"pluginName"`
	Category         string    `json:"category"`
	Active           bool      `json:"active"`
	OauthClientID    int64     `json:"oauthClientId"`
	OauthSecret      string    `json:"oauthSecret"`
	OauthRedirectURL string    `json:"oauthRedirectUrl"`
	ActivateURL      string    `json:"activateUrl"`
	APIKey           string    `json:"apiKey"`
	RekeyTryCount    int64     `json:"rekeyTryCount"`
	RekeyDate        time.Time `json:"rekeyDate"`
	IframeURL        string    `json:"iframeUrl"`
	MenuTitle        string    `json:"menuTitle"`
	MenuIconURL      string    `json:"menuIconUrl"`
	IsPGW            bool      `json:"isPgw"`
	PluginID         int64     `json:"pluginId"`
	StoreID          int64     `json:"storeId"`
}

type SubRegion struct {
	ID            int64  `json:"id"`
	SubRegionCode string `json:"subRegionCode"`
	Name          string `json:"name"`
	RegionID      int64  `json:"regionId"`
}

type ZoneZip struct {
	ID                  int64  `json:"id"`
	ZipCode             string `json:"zipCode"`
	IncludedSubRegionID int64  `json:"includedSubRegionId"`
	ExcludedSubRegionID int64  `json:"excludedSubRegionId"`
}