c2b

type BlastFile struct {
	ID            uint      `gorm:"primaryKey;autoIncrement"`
	ReferenceName string    `gorm:"index;type:varchar(50);not null;unique"`
	FileName      string    `gorm:"index;type:varchar(50);not null"`
	UploaderNames string    `gorm:"index;type:varchar(50);not null"`
	TotalMsisdn   int32     `gorm:"index;type:int(10);not null"`
	UploadedAt    time.Time `gorm:"autoCreateTime"`
}

type BlastReport struct {
	ID            uint      `gorm:"primaryKey;autoIncrement"`
	Originator    string    `gorm:"index;type:varchar(25);not null"`
	Initiator     string    `gorm:"index;type:varchar(50);not null"`
	Source        string    `gorm:"index;type:varchar(20);not null"`
	BlastFile     string    `gorm:"index;type:varchar(50)"`
	Message       string    `gorm:"type:text(500);not null"`
	TotalExported int32     `gorm:"index;type:int(10);not null;default:0"`
	ExportFilter  []byte    `gorm:"type:json;"`
	CreatedAt     time.Time `gorm:"autoCreateTime"`
}

type Options struct {
	PublishChannel   string
	RedisKeyPrefix   string
	SQLDB            *gorm.DB
	RedisDB          *redis.Client
	Logger           grpclog.LoggerV2
	AuthAPI          auth.API
	PaginationHasher *hashids.HashID
}

type PaymentMpesa struct {
	PaymentID         uint      `gorm:"primaryKey;autoIncrement"`
	TransactionType   string    `gorm:"type:varchar(50);not null"`
	TransactionID     string    `gorm:"type:varchar(50);not null;unique"`
	MSISDN            string    `gorm:"index;type:varchar(15);not null"`
	Names             string    `gorm:"type:varchar(50)"`
	ReferenceNumber   string    `gorm:"index;type:varchar(20)"`
	Amount            float32   `gorm:"type:float(10);not null"`
	OrgAccountBalance float32   `gorm:"type:float(10)"`
	BusinessShortCode int32     `gorm:"index;type:varchar(10);not null"`
	TransactionTime   time.Time `gorm:"autoCreateTime"`
	CreateTime        time.Time `gorm:"autoCreateTime"`
	Processed         bool      `gorm:"type:tinyint(1);not null"`
}

type QueueBulk struct {
	RecordID         uint      `gorm:"primaryKey;autoIncrement;column:RecordID"`
	Originator       string    `gorm:"index;type:varchar(25);not null;default:'20453';column:Originator"`
	Destination      string    `gorm:"index;type:varchar(15);not null;column:Destination"`
	Message          string    `gorm:"type:text(500);column:Message"`
	MessageTimeStamp time.Time `gorm:"type:timestamp;default:CURRENT_TIMESTAMP;column:MessageTimeStamp"`
	MessageDirection string    `gorm:"type:varchar(5);column:MessageTimeStamp"`
	SMSCID           string    `gorm:"index;type:varchar(20);column:SMSCID"`
	Command          bool      `gorm:"type:varchar(20);column:command"`
}

type Scopes struct {
	UserID    string         `gorm:"primaryKey;type:varchar(15)"`
	Scopes    []byte         `gorm:"type:json"`
	CreatedAt time.Time      `gorm:"autoCreateTime"`
	UpdatedAt time.Time      `gorm:"autoCreateTime"`
	DeletedAt gorm.DeletedAt `gorm:"index"`
}

type Stat struct {
	StatID            uint           `gorm:"primaryKey;autoIncrement"`
	ShortCode         string         `gorm:"index;type:varchar(20);not null"`
	AccountName       string         `gorm:"index;type:varchar(20);not null"`
	Date              string         `gorm:"index;type:varchar(10);not null"`
	TotalTransactions int32          `gorm:"type:int(10);not null"`
	TotalAmount       float32        `gorm:"type:float(12);not null"`
	CreatedAt         time.Time      `gorm:"autoCreateTime"`
	UpdatedAt         time.Time      `gorm:"autoCreateTime"`
	DeletedAt         gorm.DeletedAt `gorm:"index"`
}

type UploadedFileData struct {
	ID        uint      `gorm:"primaryKey;autoIncrement"`
	Msisdn    string    `gorm:"index;type:varchar(15);not null"`
	FileID    string    `gorm:"index;type:varchar(10);not null"`
	CreatedAt time.Time `gorm:"autoCreateTime"`
}