Files
cgrates/engine/models.go
Radu Ioan Fericean 7b53d35a7a added alownegative,disabled to accountactions
also started maked for users
2015-09-21 16:29:58 +03:00

482 lines
15 KiB
Go

/*
Rating system designed to be used in VoIP Carriers World
Copyright (C) 2012-2015 ITsysCOM
This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program. If not, see <http://www.gnu.org/licenses/>
*/
package engine
import (
"fmt"
"strings"
"time"
"github.com/cgrates/cgrates/utils"
)
// Structs here are one to one mapping of the tables and fields
// to be used by gorm orm
type TpTiming struct {
Id int64
Tpid string
Tag string `index:"0" re:"\w+\s*,\s*"`
Years string `index:"1" re:"\*any\s*,\s*|(?:\d{1,4};?)+\s*,\s*|\s*,\s*"`
Months string `index:"2" re:"\*any\s*,\s*|(?:\d{1,4};?)+\s*,\s*|\s*,\s*"`
MonthDays string `index:"3" re:"\*any\s*,\s*|(?:\d{1,4};?)+\s*,\s*|\s*,\s*"`
WeekDays string `index:"4" re:"\*any\s*,\s*|(?:\d{1,4};?)+\s*,\s*|\s*,\s*"`
Time string `index:"5" re:"\d{2}:\d{2}:\d{2}|\*asap"`
CreatedAt time.Time
}
type TpDestination struct {
Id int64
Tpid string
Tag string `index:"0" re:"\w+\s*,\s*"`
Prefix string `index:"1" re:"\+?\d+.?\d*"`
CreatedAt time.Time
}
type TpRate struct {
Id int64
Tpid string
Tag string `index:"0" re:"\w+\s*"`
ConnectFee float64 `index:"1" re:"\d+\.*\d*s*"`
Rate float64 `index:"2" re:"\d+\.*\d*s*"`
RateUnit string `index:"3" re:"\d+\.*\d*(ns|us|µs|ms|s|m|h)*\s*"`
RateIncrement string `index:"4" re:"\d+\.*\d*(ns|us|µs|ms|s|m|h)*\s*"`
GroupIntervalStart string `index:"5" re:"\d+\.*\d*(ns|us|µs|ms|s|m|h)*\s*"`
CreatedAt time.Time
}
type TpDestinationRate struct {
Id int64
Tpid string
Tag string `index:"0" re:"\w+\s*"`
DestinationsTag string `index:"1" re:"\w+\s*|\*any"`
RatesTag string `index:"2" re:"\w+\s*"`
RoundingMethod string `index:"3" re:"\*up|\*down|\*middle"`
RoundingDecimals int `index:"4" re:"\d+"`
MaxCost float64 `index:"5" re:"\d+\.*\d*s*"`
MaxCostStrategy string `index:"6" re:"\*free|\*disconnect"`
CreatedAt time.Time
}
type TpRatingPlan struct {
Id int64
Tpid string
Tag string `index:"0" re:"\w+\s*,\s*"`
DestratesTag string `index:"1" re:"\w+\s*,\s*|\*any"`
TimingTag string `index:"2" re:"\w+\s*,\s*|\*any"`
Weight float64 `index:"3" re:"\d+.?\d*"`
CreatedAt time.Time
}
type TpRatingProfile struct {
Id int64
Tpid string
Loadid string
Direction string `index:"0" re:"\*out\s*"`
Tenant string `index:"1" re:"[0-9A-Za-z_\.]+\s*"`
Category string `index:"2" re:"\w+\s*"`
Subject string `index:"3" re:"\*any\s*|(\w+;?)+\s*"`
ActivationTime string `index:"4" re:"\d{4}-\d{2}-\d{2}T\d{2}:\d{2}:\d{2}Z"`
RatingPlanTag string `index:"5" re:"\w+\s*"`
FallbackSubjects string `index:"6" re:"\w+\s*"`
CdrStatQueueIds string `index:"7" re:"\w+\s*"`
CreatedAt time.Time
}
func (rpf *TpRatingProfile) SetRatingProfileId(id string) error {
ids := strings.Split(id, utils.CONCATENATED_KEY_SEP)
if len(ids) != 5 {
return fmt.Errorf("Wrong TP Rating Profile Id: %s", id)
}
rpf.Loadid = ids[0]
rpf.Direction = ids[1]
rpf.Tenant = ids[2]
rpf.Category = ids[3]
rpf.Subject = ids[4]
return nil
}
func (rpf *TpRatingProfile) GetRatingProfileId() string {
return utils.ConcatenatedKey(rpf.Loadid, rpf.Direction, rpf.Tenant, rpf.Category, rpf.Subject)
}
type TpLcrRule struct {
Id int64
Tpid string
Direction string `index:"0" re:""`
Tenant string `index:"1" re:""`
Category string `index:"2" re:""`
Account string `index:"3" re:""`
Subject string `index:"4" re:""`
DestinationTag string `index:"5" re:""`
RpCategory string `index:"6" re:""`
Strategy string `index:"7" re:""`
StrategyParams string `index:"8" re:""`
ActivationTime string `index:"9" re:""`
Weight float64 `index:"10" re:""`
CreatedAt time.Time
}
func (lcr *TpLcrRule) SetLcrRuleId(id string) error {
ids := strings.Split(id, utils.CONCATENATED_KEY_SEP)
if len(ids) != 5 {
return fmt.Errorf("wrong LcrRule Id: %s", id)
}
lcr.Direction = ids[0]
lcr.Tenant = ids[1]
lcr.Category = ids[2]
lcr.Account = ids[3]
lcr.Subject = ids[4]
return nil
}
func (lcr *TpLcrRule) GetLcrRuleId() string {
return utils.LCRKey(lcr.Direction, lcr.Tenant, lcr.Category, lcr.Account, lcr.Subject)
}
type TpAction struct {
Id int64
Tpid string
Tag string `index:"0" re:"\w+\s*"`
Action string `index:"1" re:"\*\w+\s*"`
ExtraParameters string `index:"2" re:"\S+\s*"`
BalanceTag string `index:"3" re:"\w+\s*"`
BalanceType string `index:"4" re:"\*\w+\s*"`
Direction string `index:"5" re:"\*out\s*"`
Category string `index:"6" re:"\*?\w+\s*"`
DestinationTags string `index:"7" re:"\*any|\w+\s*"`
RatingSubject string `index:"8" re:"\w+\s*"`
SharedGroup string `index:"9" re:"[0-9A-Za-z_;]*"`
ExpiryTime string `index:"10" re:"\*\w+\s*|\+\d+[smh]\s*|\d+\s*"`
TimingTags string `index:"11" re:"[0-9A-Za-z_;]*|\*any"`
Units float64 `index:"12" re:"\d+\s*"`
BalanceWeight float64 `index:"13" re:"\d+\.?\d*\s*"`
BalanceDisabled bool `index:"14" re:""`
Weight float64 `index:"15" re:"\d+\.?\d*\s*"`
CreatedAt time.Time
}
type TpActionPlan struct {
Id int64
Tpid string
Tag string `index:"0" re:"\w+\s*,\s*"`
ActionsTag string `index:"1" re:"\w+\s*,\s*"`
TimingTag string `index:"2" re:"\w+\s*,\s*"|\*any`
Weight float64 `index:"3" re:"\d+\.?\d*"`
CreatedAt time.Time
}
type TpActionTrigger struct {
Id int64
Tpid string
Tag string `index:"0" re:"\w+"`
UniqueId string `index:"1" re:"\w+"`
ThresholdType string `index:"2" re:"\*\w+"`
ThresholdValue float64 `index:"3" re:"\d+\.?\d*"`
Recurrent bool `index:"4" re:"true|false"`
MinSleep string `index:"5" re:"\d+[smh]?"`
BalanceTag string `index:"6" re:"\w+\s*"`
BalanceType string `index:"7" re:"\*\w+"`
BalanceDirection string `index:"8" re:"\*out"`
BalanceCategory string `index:"9" re:"\w+|\*any"`
BalanceDestinationTags string `index:"10" re:"\w+|\*any"`
BalanceRatingSubject string `index:"11" re:"\w+|\*any"`
BalanceSharedGroup string `index:"12" re:"\w+|\*any"`
BalanceExpiryTime string `index:"13" re:"\*\w+\s*|\+\d+[smh]\s*|\d+\s*"`
BalanceTimingTags string `index:"14" re:"[0-9A-Za-z_;]*|\*any"`
BalanceWeight float64 `index:"15" re:"\d+\.?\d*"`
MinQueuedItems int `index:"16" re:"\d+"`
ActionsTag string `index:"17" re:"\w+"`
Weight float64 `index:"18" re:"\d+\.?\d*"`
CreatedAt time.Time
}
type TpAccountAction struct {
Id int64
Tpid string
Loadid string
Tenant string `index:"0" re:"\w+\s*"`
Account string `index:"1" re:"(\w+;?)+\s*"`
Direction string `index:"2" re:"\*out\s*"`
ActionPlanTag string `index:"3" re:"\w+\s*"`
ActionTriggersTag string `index:"4" re:"\w+\s*"`
AllowNegative bool `index:"5" re:""`
Disabled bool `index:"6" re:""`
CreatedAt time.Time
}
func (aa *TpAccountAction) SetAccountActionId(id string) error {
ids := strings.Split(id, utils.CONCATENATED_KEY_SEP)
if len(ids) != 4 {
return fmt.Errorf("Wrong TP Account Action Id: %s", id)
}
aa.Loadid = ids[0]
aa.Direction = ids[1]
aa.Tenant = ids[2]
aa.Account = ids[3]
return nil
}
func (aa *TpAccountAction) GetAccountActionId() string {
return utils.AccountKey(aa.Tenant, aa.Account, aa.Direction)
}
type TpSharedGroup struct {
Id int64
Tpid string
Tag string `index:"0" re:"\w+\s*"`
Account string `index:"1" re:"\*?\w+\s*"`
Strategy string `index:"2" re:"\*\w+\s*"`
RatingSubject string `index:"3" re:"\*?\w]+\s*"`
CreatedAt time.Time
}
type TpDerivedCharger struct {
Id int64
Tpid string
Loadid string
Direction string `index:"0" re:"\*out"`
Tenant string `index:"1" re:"[0-9A-Za-z_\.]+\s*"`
Category string `index:"2" re:"\w+\s*"`
Account string `index:"3" re:"\w+\s*"`
Subject string `index:"4" re:"\*any\s*|\w+\s*"`
Runid string `index:"5" re:"\w+\s*"`
RunFilters string `index:"6" re:"[~^]*[0-9A-Za-z_/:().+]+\s*"`
ReqTypeField string `index:"7" re:"\*default\s*|[~^*]*[0-9A-Za-z_/:().+]+\s*"`
DirectionField string `index:"8" re:"\*default\s*|[~^]*[0-9A-Za-z_/:().+]+\s*"`
TenantField string `index:"9" re:"\*default\s*|[~^]*[0-9A-Za-z_/:().+]+\s*"`
CategoryField string `index:"10" re:"\*default\s*|[~^]*[0-9A-Za-z_/:().+]+\s*"`
AccountField string `index:"11" re:"\*default\s*|[~^]*[0-9A-Za-z_/:().+]+\s*"`
SubjectField string `index:"12" re:"\*default\s*|[~^]*[0-9A-Za-z_/:().+]+\s*"`
DestinationField string `index:"13" re:"\*default\s*|[~^]*[0-9A-Za-z_/:().+]+\s*"`
SetupTimeField string `index:"14" re:"\*default\s*|[~^]*[0-9A-Za-z_/:().+]+\s*"`
PddField string `index:"15" re:"\*default\s*|[~^]*[0-9A-Za-z_/:().+]+\s*"`
AnswerTimeField string `index:"16" re:"\*default\s*|[~^]*[0-9A-Za-z_/:().+]+\s*"`
UsageField string `index:"17" re:"\*default\s*|[~^]*[0-9A-Za-z_/:().+]+\s*"`
SupplierField string `index:"18" re:"\*default\s*|[~^]*[0-9A-Za-z_/:().+]+\s*"`
DisconnectCauseField string `index:"19" re:"\*default\s*|[~^]*[0-9A-Za-z_/:().+]+\s*"`
CreatedAt time.Time
}
func (tpdc *TpDerivedCharger) SetDerivedChargersId(id string) error {
ids := strings.Split(id, utils.CONCATENATED_KEY_SEP)
if len(ids) != 6 {
return fmt.Errorf("Wrong TP Derived Charger Id: %s", id)
}
tpdc.Loadid = ids[0]
tpdc.Direction = ids[1]
tpdc.Tenant = ids[2]
tpdc.Category = ids[3]
tpdc.Account = ids[4]
tpdc.Subject = ids[5]
return nil
}
func (tpdc *TpDerivedCharger) GetDerivedChargersId() string {
return utils.ConcatenatedKey(tpdc.Loadid, tpdc.Direction, tpdc.Tenant, tpdc.Category, tpdc.Account, tpdc.Subject)
}
type TpCdrstat struct {
Id int64
Tpid string
Tag string `index:"0" re:""`
QueueLength int `index:"1" re:""`
TimeWindow string `index:"2" re:""`
SaveInterval string `index:"3" re:""`
Metrics string `index:"4" re:""`
SetupInterval string `index:"5" re:""`
Tors string `index:"6" re:""`
CdrHosts string `index:"7" re:""`
CdrSources string `index:"8" re:""`
ReqTypes string `index:"9" re:""`
Directions string `index:"10" re:""`
Tenants string `index:"11" re:""`
Categories string `index:"12" re:""`
Accounts string `index:"13" re:""`
Subjects string `index:"14" re:""`
DestinationIds string `index:"15" re:""`
PddInterval string `index:"16" re:""`
UsageInterval string `index:"17" re:""`
Suppliers string `index:"18" re:""`
DisconnectCauses string `index:"19" re:""`
MediationRunids string `index:"20" re:""`
RatedAccounts string `index:"21" re:""`
RatedSubjects string `index:"22" re:""`
CostInterval string `index:"23" re:""`
ActionTriggers string `index:"24" re:""`
CreatedAt time.Time
}
func (t TpCdrstat) TableName() string {
return utils.TBL_TP_CDR_STATS
}
type TpUser struct {
Id int64
Tpid string
Tenant string `index:"0" re:""`
UserName string `index:"1" re:""`
Masked bool `index:"2" re:""`
AttributeName string `index:"3" re:""`
AttributeValue string `index:"4" re:""`
}
func (tu *TpUser) GetId() string {
return utils.ConcatenatedKey(tu.Tenant, tu.UserName)
}
func (tu *TpUser) SetId(id string) error {
vals := strings.Split(id, utils.CONCATENATED_KEY_SEP)
if len(vals) != 2 {
return utils.ErrInvalidKey
}
tu.Tenant = vals[0]
tu.UserName = vals[1]
return nil
}
type TpAlias struct {
Id int64
Tpid string
Direction string `index:"0" re:""`
Tenant string `index:"1" re:""`
Category string `index:"2" re:""`
Account string `index:"3" re:""`
Subject string `index:"4" re:""`
DestinationId string `index:"5" re:""`
Context string `index:"6" re:""`
Target string `index:"7" re:""`
Original string `index:"8" re:""`
Alias string `index:"9" re:""`
Weight float64 `index:"10" re:""`
}
func (ta *TpAlias) TableName() string {
return "tp_aliases"
}
func (ta *TpAlias) SetId(id string) error {
vals := strings.Split(id, utils.CONCATENATED_KEY_SEP)
if len(vals) != 6 {
return utils.ErrInvalidKey
}
ta.Direction = vals[0]
ta.Tenant = vals[1]
ta.Category = vals[2]
ta.Account = vals[3]
ta.Subject = vals[4]
ta.Context = vals[5]
return nil
}
func (ta *TpAlias) GetId() string {
return utils.ConcatenatedKey(ta.Direction, ta.Tenant, ta.Category, ta.Account, ta.Subject, ta.Context)
}
type TblCdrsPrimary struct {
Id int64
Cgrid string
Tor string
Accid string
Cdrhost string
Cdrsource string
Reqtype string
Direction string
Tenant string
Category string
Account string
Subject string
Destination string
SetupTime time.Time
Pdd float64
AnswerTime time.Time
Usage float64
Supplier string
DisconnectCause string
CreatedAt time.Time
DeletedAt time.Time
}
func (t TblCdrsPrimary) TableName() string {
return utils.TBL_CDRS_PRIMARY
}
type TblCdrsExtra struct {
Id int64
Cgrid string
ExtraFields string
CreatedAt time.Time
DeletedAt time.Time
}
func (t TblCdrsExtra) TableName() string {
return utils.TBL_CDRS_EXTRA
}
type TblCostDetail struct {
Id int64
Cgrid string
Runid string
Tor string
Direction string
Tenant string
Category string
Account string
Subject string
Destination string
Cost float64
Timespans string
CostSource string
CreatedAt time.Time
UpdatedAt time.Time
DeletedAt time.Time
}
func (t TblCostDetail) TableName() string {
return utils.TBL_COST_DETAILS
}
type TblRatedCdr struct {
Id int64
Cgrid string
Runid string
Reqtype string
Direction string
Tenant string
Category string
Account string
Subject string
Destination string
SetupTime time.Time
Pdd float64
AnswerTime time.Time
Usage float64
Supplier string
DisconnectCause string
Cost float64
ExtraInfo string
CreatedAt time.Time
UpdatedAt time.Time
DeletedAt time.Time
}
func (t TblRatedCdr) TableName() string {
return utils.TBL_RATED_CDRS
}