models

package
v0.0.0-...-ce900e0 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Oct 31, 2018 License: Apache-2.0 Imports: 15 Imported by: 0

Documentation

Index

Constants

View Source 
const C_SQL_EQUIPMENTOVERVIEW = "SELECT collect_date, customer_no, customer_name, dtu_no, meter_address, meter_type_no, meter_type, gateway_no, gateway_desc, need_rows, rows, (rows/need_rows*100) as rate FROM v_equipment_overview " +
	"WHERE collect_date BETWEEN '%s' and '%s' ORDER BY customer_no, collect_date, dtu_no, meter_address"
View Source 
const C_SQL_TERMINAL_TRACE = `` /* 197-byte string literal not displayed */
View Source 
const C_SQL_TERMINAL_TRACE_ROWS = "" /* 157-byte string literal not displayed */
View Source 
const C_SQL_TOTALCOLLECTRATE = "" /* 203-byte string literal not displayed */
View Source 
const C_SQL_TOTALCOLLECTRATE_ROWS = "" /* 151-byte string literal not displayed */
View Source 
const C_SQL_TOTALDTUROWS = "SELECT ct.collect_date, ct.dtu_no, ct.meter_address, dt.need_rows, ct.`rows`, (ct.`rows`/ dt.need_rows * 100) as rate FROM collect_total_dtu_rows as ct " +
	"LEFT JOIN gdkxdl.v_equipment_dtu_config as dt ON ct.dtu_no = dt.dtu_no " +
	"WHERE ct.collect_date BETWEEN '%s' and '%s' and ct.dtu_no like '%s%%' and ct.meter_address = %s"

Variables

This section is empty.

Functions

func BackendConfBatchDelete 

func BackendConfBatchDelete(ids []int) (int64, error)

delete

func BackendConfTBName 

func BackendConfTBName() string

func BackendUserTBName 

func BackendUserTBName() string

获取 BackendUser 对应的表名称

func EquipmentCustomerBatchDelete 

func EquipmentCustomerBatchDelete(ids []int) (int64, error)

func EquipmentCustomerTBName 

func EquipmentCustomerTBName() string

func EquipmentDtuConfigBatchDelete 

func EquipmentDtuConfigBatchDelete(ids []int) (int64, error)

delete

func EquipmentDtuConfigCount 

func EquipmentDtuConfigCount() int64

func EquipmentDtuConfigTBName 

func EquipmentDtuConfigTBName() string

DTU配置

func EquipmentGatewayBatchDelete 

func EquipmentGatewayBatchDelete(ids []int) (int64, error)

func EquipmentGatewayTBName 

func EquipmentGatewayTBName() string

设备网关通道

func EquipmentMeterAddrConfigBatchDelete 

func EquipmentMeterAddrConfigBatchDelete(ids []int) (int64, error)

delete

func EquipmentMeterAddrConfigTBName 

func EquipmentMeterAddrConfigTBName() string

func EquipmentMeterConfigBatchDelete 

func EquipmentMeterConfigBatchDelete(ids []int) (int64, error)

delete

func EquipmentMeterConfigCount 

func EquipmentMeterConfigCount() int64

获取电表数

func EquipmentMeterConfigFieldBatchDelete 

func EquipmentMeterConfigFieldBatchDelete(ids []int) (int64, error)

delete

func EquipmentMeterConfigFieldTBName 

func EquipmentMeterConfigFieldTBName() string

func EquipmentMeterConfigTBName 

func EquipmentMeterConfigTBName() string

func EquipmentMeterRomConfigBatchDelete 

func EquipmentMeterRomConfigBatchDelete(ids []int) (int64, error)

delete

func EquipmentMeterRomConfigTBName 

func EquipmentMeterRomConfigTBName() string

func EquipmentMeterTypeAdd 

func EquipmentMeterTypeAdd(meterType *EquipmentMeterType) (int64, error)

func EquipmentMeterTypeBatchDelete 

func EquipmentMeterTypeBatchDelete(ids []int) (int64, error)

func EquipmentMeterTypeTBName 

func EquipmentMeterTypeTBName() string

func EquipmentRoomBatchDelete 

func EquipmentRoomBatchDelete(ids []int) (int64, error)

func EquipmentRoomTBName 

func EquipmentRoomTBName() string

func EquipmentSimCardsBatchDelete 

func EquipmentSimCardsBatchDelete(ids []int) (int64, error)

func EquipmentSimCardsTBName 

func EquipmentSimCardsTBName() string

func EquipmentTableConfigBatchDelete 

func EquipmentTableConfigBatchDelete(ids []int) (int64, error)

func EquipmentTableConfigTBName 

func EquipmentTableConfigTBName() string

func EquipmentVendorBatchDelete 

func EquipmentVendorBatchDelete(ids []int) (int64, error)

func EquipmentVendorTBName 

func EquipmentVendorTBName() string

设备供应商

func GetCustomerForMeter 

func GetCustomerForMeter() (string, error)

func LoginTraceAdd 

func LoginTraceAdd(_user string, _remote_add string, _login_time time.Time) error

func LoginTraceTBName 

func LoginTraceTBName() string

func ResourceTBName 

func ResourceTBName() string

获取 Resource 对应的表名称

func RoleBackendUserRelTBName 

func RoleBackendUserRelTBName() string

角色与用户多对多关系表

func RoleBatchDelete 

func RoleBatchDelete(ids []int) (int64, error)

批量删除

func RoleResourceRelTBName 

func RoleResourceRelTBName() string

角色与资源多对多关系表

func RoleTBName 

func RoleTBName() string

获取 Role 对应的表名称

func SystemValBatchDelete 

func SystemValBatchDelete(ids []int) (int64, error)

func SystemValTBName 

func SystemValTBName() string

func TableName 

func TableName(name string) string

下面是统一的表名管理

func TrafficSync 

func TrafficSync() (int64, error)

与移动物联网进行数据同步

Types

type BackendConf 

type BackendConf struct {
	Id         int       `form:"Id"`
	AppName    string    `orm:"column(appname)" form:"AppName"`
	AppVersion string    `orm:"column(appversion)" form:"AppVersion"`
	Deploy     string    `orm:"column(deploy)"  form:"Deploy"`
	ConfigText string    `orm:"column(configtext)" form:"ConfigText"`
	Used       int       `orm:"column(tag)" form:"Used"`
	CreateUser string    `orm:"column(createuser)" form:"CreateUser"`
	CreateDate time.Time `orm:"column(createdate)" form:"CreateDate"`
	ChangeUser string    `orm:"column(changeuser)" form:"ChangeUser"`
	ChangeDate time.Time `orm:"column(changedate)" form:"ChangeDate"`
}

func BackendConfDataList 

func BackendConfDataList(params *BackendConfQueryParam) []*BackendConf

func BackendConfPageList 

func BackendConfPageList(params *BackendConfQueryParam) ([]*BackendConf, int64)

func (*BackendConf) TableName 

func (this *BackendConf) TableName() string

type BackendConfQueryParam 

type BackendConfQueryParam struct {
	BaseQueryParam
	AppName string
	Used    string //为空不查询，有值精确查询
}

type BackendUser 

type BackendUser struct {
	Id                 int
	RealName           string `orm:"size(32)"`
	UserName           string `orm:"size(24)"`
	UserPwd            string `json:"-"`
	IsSuper            bool
	Status             int
	Mobile             string                `orm:"size(16)"`
	Email              string                `orm:"size(256)"`
	Avatar             string                `orm:"size(256)"`
	RoleIds            []int                 `orm:"-" form:"RoleIds"`
	RoleBackendUserRel []*RoleBackendUserRel `orm:"reverse(many)"` // 设置一对多的反向关系
	ResourceUrlForList []string              `orm:"-"`
}

func BackendUserOne 

func BackendUserOne(id int) (*BackendUser, error)

根据id获取单条

func BackendUserOneByUserName 

func BackendUserOneByUserName(username, userpwd string) (*BackendUser, error)

根据用户名密码获取单条

func BackendUserPageList 

func BackendUserPageList(params *BackendUserQueryParam) ([]*BackendUser, int64)

获取分页数据

func (*BackendUser) TableName 

func (a *BackendUser) TableName() string

type BackendUserQueryParam 

type BackendUserQueryParam struct {
	BaseQueryParam
	UserNameLike string //模糊查询
	RealNameLike string //模糊查询
	Mobile       string //精确查询
	SearchStatus string //为空不查询，有值精确查询
}

type BaseQueryParam 

type BaseQueryParam struct {
	Sort   string `json:"sort"`
	Order  string `json:"order"`
	Offset int64  `json:"offset"`
	Limit  int    `json:"limit"`
}

type CollectBaseInfo 

type CollectBaseInfo struct {
	CollectTime          time.Time `orm:"column(collect_time)"`
	DTU_no               string    `orm:"column(dtu_no)"`
	MeterAddress         int       `orm:"column(meter_address)"`
	A_electricity        float64   `orm:"digits(12);decimals(4);column(a_electricity)"`
	B_electricity        float64   `orm:"digits(12);decimals(4);column(b_electricity)"`
	C_electricity        float64   `orm:"digits(12);decimals(4);column(c_electricity)"`
	A_power_factor       float64   `orm:"digits(12);decimals(4);column(a_power_factor)"`
	B_power_factor       float64   `orm:"digits(12);decimals(4);column(b_power_factor)"`
	C_power_factor       float64   `orm:"digits(12);decimals(4);column(c_power_factor)"`
	Total_power_factor   float64   `orm:"digits(12);decimals(4);column(total_power_factor)"`
	Total_p_at_ee        float64   `orm:"digits(12);decimals(4);column(total_p_at_ee)"`
	Total_r_at_ee        float64   `orm:"digits(12);decimals(4);column(total_r_at_ee)"`
	Total_ap_a_ee        float64   `orm:"digits(12);decimals(4);column(total_ap_a_ee)"`
	Total_ap_reat_ee     float64   `orm:"digits(12);decimals(4);column(total_ap_reat_ee)"`
	A_voltage            float64   `orm:"digits(12);decimals(4);column(a_voltage)"`
	B_voltage            float64   `orm:"digits(12);decimals(4);column(b_voltage)"`
	C_voltage            float64   `orm:"digits(12);decimals(4);column(c_voltage)"`
	Total_ap_power       float64   `orm:"digits(12);decimals(4);column(total_ap_power)"`
	A_ap_power           float64   `orm:"digits(12);decimals(4);column(a_ap_power)"`
	B_ap_power           float64   `orm:"digits(12);decimals(4);column(b_ap_power)"`
	C_ap_power           float64   `orm:"digits(12);decimals(4);column(c_ap_power)"`
	Total_reactive_power float64   `orm:"digits(12);decimals(4);column(total_reactive_power)"`
	A_reactive_power     float64   `orm:"digits(12);decimals(4);column(a_reactive_power)"`
	B_reactive_power     float64   `orm:"digits(12);decimals(4);column(b_reactive_power)"`
	C_reactive_power     float64   `orm:"digits(12);decimals(4);column(c_reactive_power)"`
	Total_active_power   float64   `orm:"digits(12);decimals(4);column(total_active_power)"`
	A_active_power       float64   `orm:"digits(12);decimals(4);column(a_active_power)"`
	B_active_power       float64   `orm:"digits(12);decimals(4);column(b_active_power)"`
	C_active_power       float64   `orm:"digits(12);decimals(4);column(c_active_power)"`
	Total_p_reat_ee      float64   `orm:"digits(12);decimals(4);column(total_p_reat_ee)"`
	Total_r_reat_ee      float64   `orm:"digits(12);decimals(4);column(total_r_reat_ee)"`
	Total_at_ee          float64   `orm:"digits(12);decimals(4);column(total_at_ee)"`
	Frequency            float64   `orm:"digits(12);decimals(4);column(frequency)"`
	Uab_line_voltage     float64   `orm:"digits(12);decimals(4);column(uab_line_voltage)"`
	Ubc_line_voltage     float64   `orm:"digits(12);decimals(4);column(ubc_line_voltage)"`
	Uac_line_voltage     float64   `orm:"digits(12);decimals(4);column(uac_line_voltage)"`
}

func CollectBaseInfoDataList 

func CollectBaseInfoDataList(params *CollectBaseInfoQueryParam) []*CollectBaseInfo

func CollectBaseInfoPageList 

func CollectBaseInfoPageList(params *CollectBaseInfoQueryParam) ([]*CollectBaseInfo, int64)

type CollectBaseInfoQueryParam 

type CollectBaseInfoQueryParam struct {
	BaseQueryParam
	CollectTime  string
	DTU_no       string
	MeterAddress string
}

type CollectCountOfMonth 

type CollectCountOfMonth struct {
	CollectTime string `orm:"column(collect_date)"`
	Rows        int    `orm:"column(rows)"`
}

func GetCollectRowsOfMonth 

func GetCollectRowsOfMonth() ([]*CollectCountOfMonth, error)

取月采集数量

type CompanyItem 

type CompanyItem struct {
	Name        string     `json:"name"`
	DtuItemList []*DtuItem `json:"children"`
}

type CustomerForMeter 

type CustomerForMeter struct {
	CustomerName string `orm:"column(customer_name)"`
	DTU_no       string `orm:"column(dtu_no)"`
	MeterAddress int    `orm:"column(meter_address)"`
	MeterTypeNO  string `orm:"column(meter_type_no)"`
	LoopName     string `orm:"column(loop_name)"`
}

func CustomerForMeterDataList 

func CustomerForMeterDataList() ([]*CustomerForMeter, error)

type CustomerZone 

type CustomerZone struct {
	CustomerNO   string  `orm:"column(customer_no)"`
	CustomerName string  `orm:"column(customer_name)"`
	Zone         string  `orm:"column(zone)"`
	Longitude    float64 `orm:"digits(12);decimals(6);column(longitude)"`
	Latitude     float64 `orm:"digits(12);decimals(6);column(latitude)"`
	Num          int     `orm:"column(num)"`
}

func GetCustomerZone 

func GetCustomerZone() ([]*CustomerZone, error)

获取客户分布

type DtuItem 

type DtuItem struct {
	Name          string       `json:"name"`
	MeterItemList []*MeterItem `json:"children"`
}

type DtuRowOfDay 

type DtuRowOfDay struct {
	DTU_no       string `orm:"column(dtu_no)"`
	MeterAddress int    `orm:"column(meter_address)"`
	//MeterTypeNO  string    `orm:"column(meter_type_no)"`
	//MeterType    string    `orm:"column(meter_type)"`
	//GatewayNO    string    `orm:"column(gateway_no)"`
	//GatewayDesc  string    `orm:"column(gateway_desc)"`
	CollectTime time.Time `orm:"column(collect_time)"`
	DayRows     int       `orm:"column(day_rows)"`
	Rows        int       `orm:"column(rows)"`
}

func GetDtuRowsTodayList 

func GetDtuRowsTodayList() ([]*DtuRowOfDay, error)

今日采集进度查询

type EquipmentCustomer 

type EquipmentCustomer struct {
	Id           int       `orm:"column(id)" form:"Id"`
	CustomerNO   string    `orm:"column(customer_no)" form:"CustomerNO"`
	CustomerName string    `orm:"column(customer_name)" form:"CustomerName"`
	CustomerDesc string    `orm:"column(customer_desc)" form:"CustomerDesc"`
	Contacts     string    `orm:"column(contacts)" form:"Contacts"`
	Phone        string    `orm:"column(phone)" form:"Phone"`
	Address      string    `orm:"column(address)" form:"Address"`
	Zone         string    `orm:"column(zone)" form:"Zone"`
	Longitude    float64   `orm:"digits(12);decimals(6);column(longitude)" form:"Longitude"`
	Latitude     float64   `orm:"digits(12);decimals(6);column(latitude)" form:"Latitude"`
	Used         int       `orm:"column(tag)" form:"Used"`
	CreateUser   string    `orm:"column(createuser)" form:"CreateUser"`
	CreateDate   time.Time `orm:"auto_now_add;type(datetime);column(createdate)" form:"CreateDate"`
	ChangeUser   string    `orm:"column(changeuser)" form:"ChangeUser"`
	ChangeDate   time.Time `orm:"auto_now;type(datetime);column(changedate)" form:"ChangeDate"`
}

func EquipmentCustomerDataList 

func EquipmentCustomerDataList(params *EquipmentCustomerQueryParam) []*EquipmentCustomer

func EquipmentCustomerOne 

func EquipmentCustomerOne(id int) (*EquipmentCustomer, error)

func EquipmentCustomerPageList 

func EquipmentCustomerPageList(params *EquipmentCustomerQueryParam) ([]*EquipmentCustomer, int64)

func (*EquipmentCustomer) TableName 

func (this *EquipmentCustomer) TableName() string

type EquipmentCustomerQueryParam 

type EquipmentCustomerQueryParam struct {
	BaseQueryParam
	CustomerNO   string
	CustomerName string
	Used         string
}

type EquipmentDtuConfig 

type EquipmentDtuConfig struct {
	Id           int       `orm:"column(id)" form:"Id"`
	DTU_no       string    `orm:"column(dtu_no)" form:"DTU_no"`
	Room_no      string    `orm:"column(room_no)" form:"Room_no"`
	Sim_no       string    `orm:"column(sim_no)" form:"Sim_no"`
	TimeInterval int       `orm:"column(time_interval)" form:"TimeInterval"`
	Used         int       `orm:"column(tag)" form:"Used"`
	CreateUser   string    `orm:"column(createuser)" form:"CreateUser"`
	CreateDate   time.Time `orm:"auto_now_add;type(datetime);column(createdate)" form:"CreateDate"`
	ChangeUser   string    `orm:"column(changeuser)" form:"ChangeUser"`
	ChangeDate   time.Time `orm:"auto_now;type(datetime);column(changedate)" form:"ChangeDate"`
}

func EquipmentDtuConfigDataList 

func EquipmentDtuConfigDataList(params *EquipmentDtuConfigQueryParam) []*EquipmentDtuConfig

func EquipmentDtuConfigOne 

func EquipmentDtuConfigOne(id int) (*EquipmentDtuConfig, error)

func EquipmentDtuConfigPageList 

func EquipmentDtuConfigPageList(params *EquipmentDtuConfigQueryParam) ([]*EquipmentDtuConfig, int64)

func (*EquipmentDtuConfig) TableName 

func (this *EquipmentDtuConfig) TableName() string

type EquipmentDtuConfigQueryParam 

type EquipmentDtuConfigQueryParam struct {
	BaseQueryParam
	DTU_no  string
	Room_no string
	Sim_no  string
	Used    string //为空不查询，有值精确查询
}

type EquipmentGateway 

type EquipmentGateway struct {
	Id          int       `orm:"column(id)" form:"Id"`
	GatewayNO   string    `orm:"column(gateway_no)" form:"GatewayNO"`
	GatewayDesc string    `orm:"column(gateway_desc)" form:"GatewayDesc"`
	Used        int       `orm:"column(tag)" form:"Used"`
	CreateUser  string    `orm:"column(createuser)" form:"CreateUser"`
	CreateDate  time.Time `orm:"auto_now_add;type(datetime);column(createdate)" form:"CreateDate"`
	ChangeUser  string    `orm:"column(changeuser)" form:"ChangeUser"`
	ChangeDate  time.Time `orm:"auto_now;type(datetime);column(changedate)" form:"ChangeDate"`
}

func EquipmentGatewayDataList 

func EquipmentGatewayDataList(params *EquipmentGatewayQueryParam) []*EquipmentGateway

func EquipmentGatewayOne 

func EquipmentGatewayOne(id int) (*EquipmentGateway, error)

func EquipmentGatewayPageList 

func EquipmentGatewayPageList(params *EquipmentGatewayQueryParam) ([]*EquipmentGateway, int64)

func (*EquipmentGateway) TableName 

func (this *EquipmentGateway) TableName() string

type EquipmentGatewayQueryParam 

type EquipmentGatewayQueryParam struct {
	BaseQueryParam
	GatewayNO   string
	GatewayDesc string
	Used        string
}

type EquipmentMeterAddrConfig 

type EquipmentMeterAddrConfig struct {
	Id               int       `orm:"column(id)" form:"Id"`
	MeterTypeNO      string    `orm:"column(meter_type_no)" form:"MeterTypeNO"`
	SegmentStartAddr int       `orm:"column(segment_start_addr)" form:"SegmentStartAddr"`
	SegmentLen       int       `orm:"column(segment_len)" form:"SegmentLen"`
	SegmentNO        int       `orm:"column(segment_no)" form:"SegmentNO"`
	Used             int       `orm:"column(tag)" form:"Used"`
	CreateUser       string    `orm:"column(createuser)" form:"CreateUser"`
	CreateDate       time.Time `orm:"auto_now_add;type(datetime);column(createdate)" form:"CreateDate"`
	ChangeUser       string    `orm:"column(changeuser)" form:"ChangeUser"`
	ChangeDate       time.Time `orm:"auto_now;type(datetime);column(changedate)" form:"ChangeDate"`
}

func EquipmentMeterAddrConfigDataList 

func EquipmentMeterAddrConfigDataList(params *EquipmentMeterAddrConfigQueryParam) []*EquipmentMeterAddrConfig

func EquipmentMeterAddrConfigOne 

func EquipmentMeterAddrConfigOne(id int) (*EquipmentMeterAddrConfig, error)

func EquipmentMeterAddrConfigPageList 

func EquipmentMeterAddrConfigPageList(params *EquipmentMeterAddrConfigQueryParam) ([]*EquipmentMeterAddrConfig, int64)

func (*EquipmentMeterAddrConfig) TableName 

func (this *EquipmentMeterAddrConfig) TableName() string

type EquipmentMeterAddrConfigQueryParam 

type EquipmentMeterAddrConfigQueryParam struct {
	BaseQueryParam
	MeterTypeNO string
	Used        string //为空不查询，有值精确查询
}

type EquipmentMeterConfig 

type EquipmentMeterConfig struct {
	Id             int       `orm:"column(id)" form:"Id"`
	DTU_no         string    `orm:"column(dtu_no)" form:"DTU_no"`
	MeterAddress   int       `orm:"column(meter_address)" form:"MeterAddress"`
	MeterTypeNO    string    `orm:"column(meter_type_no)" form:"MeterTypeNO"`
	GatewayNO      string    `orm:"column(gateway_no)" form:"GatewayNO"`
	GatewayQzone   int       `orm:"column(gateway_qzone); null" form:"GatewayQzone"`
	GatewayAddress int       `orm:"column(gateway_address); null" form:"GatewayAddress"`
	GatewaySite    int       `orm:"column(gateway_site); null" form:"GatewaySite"`
	LoopName       string    `orm:"column(loop_name)" form:"LoopName"`
	Pt             int       `orm:"column(pt)" form:"Pt"`
	Ct             int       `orm:"column(ct)" form:"Ct"`
	Used           int       `orm:"column(tag)" form:"Used"`
	CreateUser     string    `orm:"column(createuser)" form:"CreateUser"`
	CreateDate     time.Time `orm:"auto_now_add;type(datetime);column(createdate)" form:"CreateDate"`
	ChangeUser     string    `orm:"column(changeuser)" form:"ChangeUser"`
	ChangeDate     time.Time `orm:"auto_now;type(datetime);column(changedate)" form:"ChangeDate"`
}

func EquipmentMeterConfigDataList 

func EquipmentMeterConfigDataList(params *EquipmentMeterConfigQueryParam) []*EquipmentMeterConfig

func EquipmentMeterConfigOne 

func EquipmentMeterConfigOne(id int) (*EquipmentMeterConfig, error)

func EquipmentMeterConfigPageList 

func EquipmentMeterConfigPageList(params *EquipmentMeterConfigQueryParam) ([]*EquipmentMeterConfig, int64)

func (*EquipmentMeterConfig) TableName 

func (this *EquipmentMeterConfig) TableName() string

type EquipmentMeterConfigField 

type EquipmentMeterConfigField struct {
	Id           int       `orm:"column(id)" form:"Id"`
	DTU_no       string    `orm:"column(dtu_no)" form:"DTU_no"`
	MeterAddress int       `orm:"column(meter_address)" form:"MeterAddress"`
	MeterTypeNO  string    `orm:"column(meter_type_no)" form:"MeterTypeNO"`
	GatewayNO    string    `orm:"column(gateway_no)" form:"GatewayNO"`
	DsAddr       int       `orm:"column(ds_addr)" form:"DsAddr"`
	FieldName    string    `orm:"column(field_name)" form:"FieldName"`
	Used         int       `orm:"column(tag)" form:"Used"`
	CreateUser   string    `orm:"column(createuser)" form:"CreateUser"`
	CreateDate   time.Time `orm:"auto_now_add;type(datetime);column(createdate)" form:"CreateDate"`
	ChangeUser   string    `orm:"column(changeuser)" form:"ChangeUser"`
	ChangeDate   time.Time `orm:"auto_now;type(datetime);column(changedate)" form:"ChangeDate"`
}

func EquipmentMeterConfigFieldDataList 

func EquipmentMeterConfigFieldDataList(params *EquipmentMeterConfigFieldQueryParam) []*EquipmentMeterConfigField

func EquipmentMeterConfigFieldOne 

func EquipmentMeterConfigFieldOne(id int) (*EquipmentMeterConfigField, error)

func EquipmentMeterConfigFieldPageList 

func EquipmentMeterConfigFieldPageList(params *EquipmentMeterConfigFieldQueryParam) ([]*EquipmentMeterConfigField, int64)

func (*EquipmentMeterConfigField) TableName 

func (this *EquipmentMeterConfigField) TableName() string

type EquipmentMeterConfigFieldQueryParam 

type EquipmentMeterConfigFieldQueryParam struct {
	BaseQueryParam
	DTU_no       string
	MeterAddress string
	Used         string //为空不查询，有值精确查询
}

type EquipmentMeterConfigQueryParam 

type EquipmentMeterConfigQueryParam struct {
	BaseQueryParam
	DTU_no       string
	MeterAddress string
	MeterTypeNO  string
	Used         string //为空不查询，有值精确查询
}

type EquipmentMeterRomConfig 

type EquipmentMeterRomConfig struct {
	Id             int       `orm:"column(id)" form:"Id"`
	MeterTypeNO    string    `orm:"column(meter_type_no)" form:"MeterTypeNO"`
	AddressSort    int       `orm:"column(address_sort)" form:"AddressSort"`
	RomAddress     string    `orm:"column(rom_address)" form:"RomAddress"`
	RomName        string    `orm:"column(rom_name)" form:"RomName"`
	Units          string    `orm:"column(units)" form:"Units"`
	DataType       string    `orm:"column(data_type)" form:"DataType"`
	SegmentNO      int       `orm:"column(segment_no)" form:"SegmentNO"`
	Offset         int       `orm:"column(offset)" form:"Offset"`
	Needpt         int       `orm:"column(need_pt)" form:"Needpt"`
	Needct         int       `orm:"column(need_ct)" form:"Needct"`
	Calcfactor     float64   `orm:"digits(12);decimals(4);column(calcfactor)" form:"Calcfactor"`
	Msbbit         int       `orm:"column(msb_bit)" form:"Msbbit"`
	BigEndian      int       `orm:"column(bigendian)" form:"BigEndian"`
	Bytelength     int       `orm:"column(byte_length)" form:"Bytelength"`
	FunctionTable1 string    `orm:"column(function_table1)" form:"FunctionTable1"`
	FunctionTable2 string    `orm:"column(function_table2)" form:"FunctionTable2"`
	FunctionTable3 string    `orm:"column(function_table3)" form:"FunctionTable3"`
	FunctionField  string    `orm:"column(function_field)" form:"FunctionField"`
	Used           int       `orm:"column(tag)" form:"Used"`
	CreateUser     string    `orm:"column(createuser)" form:"CreateUser"`
	CreateDate     time.Time `orm:"auto_now_add;type(datetime);column(createdate)" form:"CreateDate"`
	ChangeUser     string    `orm:"column(changeuser)" form:"ChangeUser"`
	ChangeDate     time.Time `orm:"auto_now;type(datetime);column(changedate)" form:"ChangeDate"`
}

func EquipmentMeterRomConfigDataList 

func EquipmentMeterRomConfigDataList(params *EquipmentMeterRomConfigQueryParam) []*EquipmentMeterRomConfig

func EquipmentMeterRomConfigOne 

func EquipmentMeterRomConfigOne(id int) (*EquipmentMeterRomConfig, error)

func EquipmentMeterRomConfigPageList 

func EquipmentMeterRomConfigPageList(params *EquipmentMeterRomConfigQueryParam) ([]*EquipmentMeterRomConfig, int64)

func (*EquipmentMeterRomConfig) TableName 

func (this *EquipmentMeterRomConfig) TableName() string

type EquipmentMeterRomConfigQueryParam 

type EquipmentMeterRomConfigQueryParam struct {
	BaseQueryParam
	MeterTypeNO string
	Used        string //为空不查询，有值精确查询
}

type EquipmentMeterType 

type EquipmentMeterType struct {
	Id          int       `orm:"column(id)" form:"Id"`
	MeterTypeNO string    `orm:"column(meter_type_no)" form:"MeterTypeNO"`
	MeterType   string    `orm:"column(meter_type)" form:"MeterType"`
	VendorNO    string    `orm:"column(vendor_no)" form:"VendorNO"`
	PtAddress   string    `orm:"column(pt_address)" form:"PtAddress"`
	CtAddress   string    `orm:"column(ct_address)" form:"CtAddress"`
	ThreePhase  int       `orm:"column(three_phase)" form:"ThreePhase"`
	Used        int       `orm:"column(tag)" form:"Used"`
	CreateUser  string    `orm:"column(createuser)" form:"CreateUser"`
	CreateDate  time.Time `orm:"auto_now_add;type(datetime);column(createdate)" form:"CreateDate"`
	ChangeUser  string    `orm:"column(changeuser)" form:"ChangeUser"`
	ChangeDate  time.Time `orm:"auto_now;type(datetime);column(changedate)" form:"ChangeDate"`
}

func EquipmentMeterTypeOne 

func EquipmentMeterTypeOne(id int) (*EquipmentMeterType, error)

func EquipmentMeterTypeSelect 

func EquipmentMeterTypeSelect(params *EquipmentMeterTypeQueryParam) ([]*EquipmentMeterType, error)

func (*EquipmentMeterType) TableName 

func (this *EquipmentMeterType) TableName() string

func (*EquipmentMeterType) Update 

func (this *EquipmentMeterType) Update(fields ...string) error

type EquipmentMeterTypeGrid 

type EquipmentMeterTypeGrid struct {
	Id          int
	MeterTypeNO string
	MeterType   string
	VendorNO    string
	VendorDesc  string
	PtAddress   string
	CtAddress   string
	ThreePhase  int

	Used       int
	CreateUser string
	CreateDate time.Time
	ChangeUser string
	ChangeDate time.Time
}

func EquipmentMeterTypeDataList 

func EquipmentMeterTypeDataList(params *EquipmentMeterTypeQueryParam) []*EquipmentMeterTypeGrid

func EquipmentMeterTypePageList 

func EquipmentMeterTypePageList(params *EquipmentMeterTypeQueryParam) ([]*EquipmentMeterTypeGrid, int64)

type EquipmentMeterTypeQueryParam 

type EquipmentMeterTypeQueryParam struct {
	BaseQueryParam
	MeterTypeNO string
	MeterType   string
	Used        string //为空不查询，有值精确查询
}

type EquipmentOverview 

type EquipmentOverview struct {
	CollectDate  time.Time `orm:"column(collect_date)"`
	CustomerNO   string    `orm:"column(customer_no)"`
	CustomerName string    `orm:"column(customer_name)" `
	DTU_no       string    `orm:"column(dtu_no)"`
	MeterAddress int       `orm:"column(meter_address)"`
	MeterTypeNO  string    `orm:"column(meter_type_no)" `
	MeterType    string    `orm:"column(meter_type)"`
	GatewayNO    string    `orm:"column(gateway_no)" `
	GatewayDesc  string    `orm:"column(gateway_desc)" `
	NeedRows     float64   `orm:"digits(12);decimals(0);column(need_rows)"`
	Rows         int       `orm:"column(rows)"`
	Rate         float64   `orm:"digits(12);decimals(2);column(rate)"`
}

func EquipmentOverviewDataList 

func EquipmentOverviewDataList(params *EquipmentOverviewQueryParam) []*EquipmentOverview

func EquipmentOverviewPageList 

func EquipmentOverviewPageList(params *EquipmentOverviewQueryParam) ([]*EquipmentOverview, int64)

type EquipmentOverviewQueryParam 

type EquipmentOverviewQueryParam struct {
	BaseQueryParam
	CollectDate string
}

type EquipmentRoom 

type EquipmentRoom struct {
	Id           int       `orm:"column(id)" form:"Id"`
	RoomNO       string    `orm:"column(room_no)" form:"RoomNO"`
	RoomName     string    `orm:"column(room_name)" form:"RoomName"`
	CustomerNO   string    `orm:"column(customer_no)" form:"CustomerNO"`
	CustomerName string    `orm:"-" `
	Used         int       `orm:"column(tag)" form:"Used"`
	CreateUser   string    `orm:"column(createuser)" form:"CreateUser"`
	CreateDate   time.Time `orm:"auto_now_add;type(datetime);column(createdate)" form:"CreateDate"`
	ChangeUser   string    `orm:"column(changeuser)" form:"ChangeUser"`
	ChangeDate   time.Time `orm:"auto_now;type(datetime);column(changedate)" form:"ChangeDate"`
}

func EquipmentRoomDataList 

func EquipmentRoomDataList(params *EquipmentRoomQueryParam) []*EquipmentRoom

func EquipmentRoomOne 

func EquipmentRoomOne(id int) (*EquipmentRoom, error)

func EquipmentRoomPageList 

func EquipmentRoomPageList(params *EquipmentRoomQueryParam) ([]*EquipmentRoom, int64)

func (*EquipmentRoom) TableName 

func (this *EquipmentRoom) TableName() string

type EquipmentRoomQueryParam 

type EquipmentRoomQueryParam struct {
	BaseQueryParam
	RoomNO   string
	RoomName string
	Used     string
}

type EquipmentSimCards 

type EquipmentSimCards struct {
	Id               int64     `orm:"column(id)" form:"Id"`
	Sim_no           string    `orm:"column(sim_no)" form:"Sim_no"`
	Iccid            string    `orm:"column(ICCID)" form:"Iccid"`
	TotalTraffic     float64   `orm:"digits(12);decimals(2);column(totaltraffic)" form:"TotalTraffic"`
	UseTraffic       float64   `orm:"digits(12);decimals(2);column(usetraffic)" form:"UseTraffic"`
	RemainTraffic    float64   `orm:"digits(12);decimals(2);column(remaintraffic)" form:"RemainTraffic"`
	TrafficSyncTime  time.Time `orm:"column(trafficsynctime)" form:"TrafficSyncTime"`
	PackageStartTime time.Time `orm:"column(packagestarttime)" form:"PackageStartTime"`
	PackageStopTime  time.Time `orm:"column(packagestoptime)" form:"PackageStopTime"`
	Used             int       `orm:"column(tag)" form:"Used"`
	CreateUser       string    `orm:"column(createuser)" form:"CreateUser"`
	CreateDate       time.Time `orm:"auto_now_add;type(datetime);column(createdate)" form:"CreateDate"`
	ChangeUser       string    `orm:"column(changeuser)" form:"ChangeUser"`
	ChangeDate       time.Time `orm:"auto_now;type(datetime);column(changedate)" form:"ChangeDate"`
}

func EquipmentSimCardsDataList 

func EquipmentSimCardsDataList(params *EquipmentSimCardsQueryParam) []*EquipmentSimCards

func EquipmentSimCardsOne 

func EquipmentSimCardsOne(id int64) (*EquipmentSimCards, error)

func EquipmentSimCardsPageList 

func EquipmentSimCardsPageList(params *EquipmentSimCardsQueryParam) ([]*EquipmentSimCards, int64)

func (*EquipmentSimCards) TableName 

func (this *EquipmentSimCards) TableName() string

type EquipmentSimCardsQueryParam 

type EquipmentSimCardsQueryParam struct {
	BaseQueryParam
	Sim_no string
	Used   string //为空不查询，有值精确查询
}

type EquipmentTableConfig 

type EquipmentTableConfig struct {
	Id             int       `orm:"column(id)" form:"Id"`
	FieldName      string    `orm:"column(field_name)" form:"FieldName"`
	FieldDesc      string    `orm:"column(field_desc)" form:"FieldDesc"`
	FunctionTable1 string    `orm:"column(function_table1)" form:"FunctionTable1"`
	FunctionTable2 string    `orm:"column(function_table2)" form:"FunctionTable2"`
	FunctionTable3 string    `orm:"column(function_table3)" form:"FunctionTable3"`
	Used           int       `orm:"column(tag)" form:"Used"`
	CreateUser     string    `orm:"column(createuser)" form:"CreateUser"`
	CreateDate     time.Time `orm:"auto_now_add;type(datetime);column(createdate)" form:"CreateDate"`
	ChangeUser     string    `orm:"column(changeuser)" form:"ChangeUser"`
	ChangeDate     time.Time `orm:"auto_now;type(datetime);column(changedate)" form:"ChangeDate"`
}

func EquipmentTableConfigDataList 

func EquipmentTableConfigDataList(params *EquipmentTableConfigQueryParam) []*EquipmentTableConfig

func EquipmentTableConfigOne 

func EquipmentTableConfigOne(id int) (*EquipmentTableConfig, error)

func EquipmentTableConfigPageList 

func EquipmentTableConfigPageList(params *EquipmentTableConfigQueryParam) ([]*EquipmentTableConfig, int64)

func (*EquipmentTableConfig) TableName 

func (this *EquipmentTableConfig) TableName() string

type EquipmentTableConfigQueryParam 

type EquipmentTableConfigQueryParam struct {
	BaseQueryParam
	FieldName string
	FieldDesc string
	Used      string
}

type EquipmentVendor 

type EquipmentVendor struct {
	Id         int       `orm:"column(id)" form:"Id"`
	VendorNO   string    `orm:"column(vendor_no)" form:"VendorNO"`
	VendorDesc string    `orm:"column(vendor_desc)" form:"VendorDesc"`
	Used       int       `orm:"column(tag)" form:"Used"`
	CreateUser string    `orm:"column(createuser)" form:"CreateUser"`
	CreateDate time.Time `orm:"auto_now_add;type(datetime);column(createdate)" form:"CreateDate"`
	ChangeUser string    `orm:"column(changeuser)" form:"ChangeUser"`
	ChangeDate time.Time `orm:"auto_now;type(datetime);column(changedate)" form:"ChangeDate"`
}

func EquipmentVendorDataList 

func EquipmentVendorDataList(params *EquipmentVendorQueryParam) []*EquipmentVendor

func EquipmentVendorOne 

func EquipmentVendorOne(id int) (*EquipmentVendor, error)

func EquipmentVendorPageList 

func EquipmentVendorPageList(params *EquipmentVendorQueryParam) ([]*EquipmentVendor, int64)

func (*EquipmentVendor) TableName 

func (this *EquipmentVendor) TableName() string

type EquipmentVendorQueryParam 

type EquipmentVendorQueryParam struct {
	BaseQueryParam
	VendorNO   string
	VendorDesc string
	Used       string
}

type JsonResult 

type JsonResult struct {
	Code enums.JsonResultCode `json:"code"`
	Msg  string               `json:"msg"`
	Obj  interface{}          `json:"obj"`
}

type LoginTrace 

type LoginTrace struct {
	Id         int64     `orm:"column(id)" form:"Id"`
	UserName   string    `orm:"column(user)" form:"UserName"`
	RemoteAddr string    `orm:"column(remoteAddr)" form:"RemoteAddr"`
	LoginTime  time.Time `orm:"column(loginTime)" form:"LoginTime"`
}

func LoginTraceDataList 

func LoginTraceDataList(params *LoginTraceQueryParam) []*LoginTrace

func LoginTracePageList 

func LoginTracePageList(params *LoginTraceQueryParam) ([]*LoginTrace, int64)

func (*LoginTrace) TableName 

func (this *LoginTrace) TableName() string

type LoginTraceQueryParam 

type LoginTraceQueryParam struct {
	BaseQueryParam
	UserName string
}

type MeterItem 

type MeterItem struct {
	Name string `json:"name"`
	Desc string `json:"desc"`
}

type OverviewToday 

type OverviewToday struct {
	TypeID   int    `orm:"column(type_id)"`
	TypeNO   int    `orm:"column(type_no)"`
	TypeDesc string `orm:"colnum(type_desc)"`
	Num      int    `orm:"column(num)"`
	DayRows  int    `orm:"column(day_rows)"`
	Rows     int    `orm:"column(rows)"`
}

func GetOverviewToday 

func GetOverviewToday(choiceDate string) ([]*OverviewToday, error)

获取概述信息

type Resource 

type Resource struct {
	Id              int
	Name            string    `orm:"size(64)"`
	Parent          *Resource `orm:"null;rel(fk)"` // RelForeignKey relation
	Rtype           int
	Seq             int
	Sons            []*Resource        `orm:"reverse(many)"` // fk 的反向关系
	SonNum          int                `orm:"-"`
	Icon            string             `orm:"size(32)"`
	LinkUrl         string             `orm:"-"`
	UrlFor          string             `orm:"size(256)" Json:"-"`
	HtmlDisabled    int                `orm:"-"`             //在html里应用时是否可用
	Level           int                `orm:"-"`             //第几级，从0开始
	RoleResourceRel []*RoleResourceRel `orm:"reverse(many)"` // 设置一对多的反向关系
}

Resource 权限控制资源表

func ResourceOne 

func ResourceOne(id int) (*Resource, error)

func ResourceTreeGrid 

func ResourceTreeGrid() []*Resource

Resource 获取treegrid顺序的列表

func ResourceTreeGrid4Parent 

func ResourceTreeGrid4Parent(id int) []*Resource

ResourceTreeGrid4Parent 获取可以成为某个节点父节点的列表

func ResourceTreeGridByUserId 

func ResourceTreeGridByUserId(backuserid, maxrtype int) []*Resource

根据用户获取有权管理的资源列表，并整理成teegrid格式

func (*Resource) TableName 

func (a *Resource) TableName() string

type Role 

type Role struct {
	Id                 int    `form:"id"`
	Name               string `form:"Name"`
	Seq                int
	RoleResourceRel    []*RoleResourceRel    `orm:"reverse(many)" json:"-"` // 设置一对多的反向关系
	RoleBackendUserRel []*RoleBackendUserRel `orm:"reverse(many)" json:"-"` // 设置一对多的反向关系
}

用户角色

func RoleDataList 

func RoleDataList(params *RoleQueryParam) []*Role

获取角色列表

func RoleOne 

func RoleOne(id int) (*Role, error)

func RolePageList 

func RolePageList(params *RoleQueryParam) ([]*Role, int64)

获取分页数据

func (*Role) TableName 

func (a *Role) TableName() string

type RoleBackendUserRel 

type RoleBackendUserRel struct {
	Id          int
	Role        *Role        `orm:"rel(fk)"`  //外键
	BackendUser *BackendUser `orm:"rel(fk)" ` // 外键
	Created     time.Time    `orm:"auto_now_add;type(datetime)"`
}

角色与用户关系

func (*RoleBackendUserRel) TableName 

func (this *RoleBackendUserRel) TableName() string

type RoleQueryParam 

type RoleQueryParam struct {
	BaseQueryParam
	NameLike string
}

type RoleResourceRel 

type RoleResourceRel struct {
	Id       int
	Role     *Role     `orm:"rel(fk)"`  //外键
	Resource *Resource `orm:"rel(fk)" ` //外键
	Created  time.Time `orm:"auto_now_add;type(datetime)"`
}

角色与资源关系表

func (*RoleResourceRel) TableName 

func (this *RoleResourceRel) TableName() string

type RootItem 

type RootItem struct {
	Name            string         `json:"name"`
	CompanyItemList []*CompanyItem `json:"children"`
}

type SendMessage 

type SendMessage struct {
	Message string `json:"message"`
}

type SystemVal 

type SystemVal struct {
	Id         int       `orm:"column(id)" form:"Id"`
	Code       string    `orm:"column(code)" form:"Code"`
	Desc       string    `orm:"column(desc)" form:"Desc"`
	Value      string    `orm:"column(value)" form:"Value"`
	UpLimit    string    `orm:"column(uplimit)" form:"UpLimit"`
	Step       string    `orm:"column(step)" form:"Step"`
	Used       int       `orm:"column(tag)" form:"Used"`
	CreateUser string    `orm:"column(createuser)" form:"CreateUser"`
	CreateDate time.Time `orm:"auto_now_add;type(datetime);column(createdate)" form:"CreateDate"`
	ChangeUser string    `orm:"column(changeuser)" form:"ChangeUser"`
	ChangeDate time.Time `orm:"auto_now;type(datetime);column(changedate)" form:"ChangeDate"`
}

func SystemValDataList 

func SystemValDataList(params *SystemValQueryParam) []*SystemVal

func SystemValOne 

func SystemValOne(id int) (*SystemVal, error)

func SystemValPageList 

func SystemValPageList(params *SystemValQueryParam) ([]*SystemVal, int64)

func (*SystemVal) TableName 

func (this *SystemVal) TableName() string

type SystemValQueryParam 

type SystemValQueryParam struct {
	BaseQueryParam
	Code string
	Desc string
	Used string //为空不查询，有值精确查询
}

type TerminalTrace 

type TerminalTrace struct {
	CollectTime   time.Time `orm:"column(collect_time)"`
	DTU_no        string    `orm:"column(dtu_no)"`
	MeterAddress  int       `orm:"column(meter_address)"`
	RemoteAddress string    `orm:"column(remote_address)"`
	Linked        int       `orm:"column(linked)"`
}

func TerminalTracePageList 

func TerminalTracePageList(params *TerminalTraceQueryParam) ([]*TerminalTrace, int64)

type TerminalTraceQueryParam 

type TerminalTraceQueryParam struct {
	BaseQueryParam
	CollectTime  string
	DTU_no       string
	MeterAddress string
}

type TotalActivePowerMinute 

type TotalActivePowerMinute struct {
	CollectTime      time.Time `orm:"column(collect_time)"`
	DTU_no           string    `orm:"column(dtu_no)"`
	MeterAddress     int       `orm:"column(meter_address)"`
	TotalActivePower float64   `orm:"digits(12);decimals(4);column(total_active_power)"`
}

func TotalActivePowerMinuteDataList 

func TotalActivePowerMinuteDataList(params *TotalActivePowerMinuteQueryParam) []*TotalActivePowerMinute

func TotalActivePowerMinutePageList 

func TotalActivePowerMinutePageList(params *TotalActivePowerMinuteQueryParam) ([]*TotalActivePowerMinute, int64)

type TotalActivePowerMinuteQueryParam 

type TotalActivePowerMinuteQueryParam struct {
	BaseQueryParam
	CollectTime  string
	DTU_no       string
	MeterAddress string
}

type TotalCollectRate 

type TotalCollectRate struct {
	CollectDate  time.Time `orm:"column(collect_date)"`
	CustomerNO   string    `orm:"column(customer_no)"`
	CustomerName string    `orm:"column(customer_name)"`
	Num          int       `orm:"column(num)"`
	NeedRows     float64   `orm:"digits(12);decimals(0);column(need_rows)"`
	Rows         int       `orm:"column(rows)"`
	Rate         float64   `orm:"digits(12);decimals(2);column(rate)"`
}

func TotalCollectRatePageList 

func TotalCollectRatePageList(params *TotalCollectRateQueryParam) ([]*TotalCollectRate, int64)

type TotalCollectRateQueryParam 

type TotalCollectRateQueryParam struct {
	BaseQueryParam
	CollectDate  string
	CustomerNO   string
	CustomerName string
}

type TotalDtuRows 

type TotalDtuRows struct {
	CollectDate  time.Time `orm:"column(collect_date)"`
	DTU_no       string    `orm:"column(dtu_no)"`
	MeterAddress int       `orm:"column(meter_address)"`
	NeedRows     float64   `orm:"digits(12);decimals(0);column(need_rows)"`
	Rows         int       `orm:"column(rows)"`
	Rate         float64   `orm:"digits(12);decimals(2);column(rate)"`
}

func TotalDtuRowsDataList 

func TotalDtuRowsDataList(params *TotalDtuRowsQueryParam) []*TotalDtuRows

func TotalDtuRowsPageList 

func TotalDtuRowsPageList(params *TotalDtuRowsQueryParam) ([]*TotalDtuRows, int64)

type TotalDtuRowsQueryParam 

type TotalDtuRowsQueryParam struct {
	BaseQueryParam
	CollectDate  string
	DTU_no       string
	MeterAddress string
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.