MiFaZhan
38 lines
1.5 KiB
Go
38 lines
1.5 KiB
Go
package trafficusage
|
|
|
|
import (
|
|
"context"
|
|
"git.5iot.com/iotlcm-public/iotlcm-admin-svr/internal/dao"
|
|
|
|
"github.com/gogf/gf/v2/database/gdb"
|
|
)
|
|
|
|
func trafficUsageEligibleCardModel(ctx context.Context) *gdb.Model {
|
|
cardTable := dao.TSimCardInfo.Table()
|
|
deptTable := dao.SysDept.Table()
|
|
cardColumns := dao.TSimCardInfo.Columns()
|
|
deptColumns := dao.SysDept.Columns()
|
|
|
|
return dao.TSimCardInfo.Ctx(ctx).
|
|
InnerJoin(deptTable, cardTable+"."+cardColumns.DeptId+" = "+deptTable+"."+deptColumns.DeptId+" AND "+cardTable+"."+cardColumns.TenantId+" = "+deptTable+"."+deptColumns.TenantId).
|
|
Where(cardTable+"."+cardColumns.Iccid+" <> ?", "").
|
|
Where(cardTable+"."+cardColumns.ChanKey+" <> ?", "").
|
|
Where(cardTable+"."+cardColumns.CurrentPackageCode+" <> ?", "").
|
|
WhereNull(deptTable + "." + deptColumns.DeletedAt)
|
|
}
|
|
|
|
func trafficUsageCardFields() []string {
|
|
cardTable := dao.TSimCardInfo.Table()
|
|
columns := dao.TSimCardInfo.Columns()
|
|
return []string{
|
|
cardTable + "." + columns.Id + " AS " + columns.Id,
|
|
cardTable + "." + columns.Iccid + " AS " + columns.Iccid,
|
|
cardTable + "." + columns.Imsi + " AS " + columns.Imsi,
|
|
cardTable + "." + columns.Msisdn + " AS " + columns.Msisdn,
|
|
cardTable + "." + columns.ChanKey + " AS " + columns.ChanKey,
|
|
cardTable + "." + columns.CurrentPackageCode + " AS " + columns.CurrentPackageCode,
|
|
cardTable + "." + columns.FlowPoolCode + " AS " + columns.FlowPoolCode,
|
|
cardTable + "." + columns.IsFlowPool + " AS " + columns.IsFlowPool,
|
|
}
|
|
}
|