tmrwatch/models/downloadedplan.go

package models
                                
import (
	"time"
)



type DownloadedPlan struct {
    ID            int64     `xorm:"'id' bigint(20) pk autoincr"`
    PastureID     int64     `xorm:"'pastureid' bigint(20) not null"`
    MyDate        time.Time `xorm:"'mydate' datetime not null comment('计划日期')"`
    ProjName      string    `xorm:"'projname' varchar(30) comment('计划编号')"`
    DataCaptureNo int       `xorm:"'datacaptureno' int(11) comment('设备编号')"`
    TmrID         int64     `xorm:"'tmrid' bigint(20) comment('tmr主键')"`
    TmrtName      string    `xorm:"'tmrtname' varchar(20) comment('tmr名称')"`
    HaveButton    bool      `xorm:"'havebutton' tinyint(1) default 0 comment('是否开始执行')"`
    InButtonType  int       `xorm:"'inbuttontype' int(11) default 0 comment('按钮类型')"`
    PlanTime      string    `xorm:"'plantime' varchar(50) comment('计划时分')"`
    InTime        time.Time `xorm:"'intime' datetime comment('开始执行时间')"`
    CompletedTime time.Time `xorm:"'completedtime' datetime comment('结束执行时间')"`
    // ProcessTime   string    `xorm:"'processtime' time comment('过程时间')"`
    IsCompleted   int       `xorm:"'iscompleted' tinyint(4) default 0 comment('是否已完成')"`
    LpPlanType    int       `xorm:"'lpplantype' int(11) default 0 comment('计算模式')"`
    Times         int       `xorm:"'times' int(11) default 0 comment('班次')"`
    Sort          int       `xorm:"'sort' int(11) default 0 comment('顺序')"`
    Remark        string    `xorm:"'remark' varchar(50) comment('备注')"`
    ItemNum       int       `xorm:"'itemnum' int(11) comment('添加饲料种类数')"`
    OutItems      int       `xorm:"'outitems' int(11) comment('发料牛舍数')"`
    FeedPName     string    `xorm:"'feedpname' varchar(200) comment('牛舍列表')"`
    FeedPCount    int       `xorm:"'feedpcount' int(11) default 0 comment('牛头数')"`
    Pid           int64     `xorm:"'pid' bigint(20) comment('发料计划编号')"`
    TempID        int64     `xorm:"'tempid' bigint(20) comment('配方id')"`
    TempletName   string    `xorm:"'templetname' varchar(50) comment('配方模版名称')"`
    PtsTempID     int64     `xorm:"'ptstempid' bigint(20) comment('补料配方id')"`
    PtsTempletName string   `xorm:"'ptstempletname' varchar(50) comment('补料配方模版名称')"`
    ThoWeight     string    `xorm:"'thoweight' char(20) comment('配方理论干物质')"`
    FpWeight      string    `xorm:"'fpweight' char(20) comment('配方总重')"`
    LWeight       float64   `xorm:"'lweight' decimal(38,2) comment('应做料总量')"`
    IWeight       int       `xorm:"'iweight' int(11) comment('实际做料总量')"`
    OWeight       int       `xorm:"'oweight' int(11) comment('实发料重量')"`
    TVersion      int       `xorm:"'tversion' int(11) default 0 comment('配方版本')"`
    PtVersion     int       `xorm:"'ptversion' int(11) default 0 comment('补料配方版本')"`
    Enable        int       `xorm:"'enable' tinyint(4) default 1 comment('是否启用')"`
    IsUse         int       `xorm:"'isUse' int(11) default 0 comment('是否使用')"`
    OldTmrID      int64     `xorm:"'oldtmrid' bigint(20)"`
    DriverID      int64     `xorm:"'driverId' bigint(20) comment('驾驶员')"`
    Artificial    bool      `xorm:"'artificial' tinyint(1) not null default 0 comment('手动完成')"`
}

func (d *DownloadedPlan) TableName() string {
    return "downloadedplan"
}


type DownloadPlanDtl1 struct {
    ID               int64     `xorm:"'id' bigint(20) pk autoincr"`
    PastureID        int64     `xorm:"'pastureid' bigint(20) not null"`
    Pid              int64     `xorm:"'pid' bigint(20) not null comment('计划id')"`
    Flpid            int64     `xorm:"'flpid' bigint(20) comment('发料计划的主id')"`
    Fid              int64     `xorm:"'fid' bigint(20) not null comment('饲料id')"`
    LWeight          float64   `xorm:"'lweight' decimal(20,2) not null comment('理论重量')"`
    Sort             int       `xorm:"'sort' int(11) not null default 0 comment('顺序')"`
    LastActualWeight float64   `xorm:"'lastactualweight' decimal(10,2) comment('上次重量')"`
    ActualWeight     float64   `xorm:"'actualweight' decimal(10,2) comment('实际重量')"`
    ActualWeightMinus float64  `xorm:"'actualweightminus' decimal(10,2) comment('实际重量')"`
    HaveButton       bool      `xorm:"'havebuttom' tinyint(1) default 0 comment('是否操作')"`
    BeginTime        time.Time `xorm:"'begintime' datetime comment('操作开始时间')"`
    InTime           time.Time `xorm:"'intime' datetime comment('操作结束时间')"`
    ButtonType       int       `xorm:"'buttontype' int(11) default 0 comment('操作类型')"`
    OptDevice        int64     `xorm:"'optdevice' bigint(20) comment('操作车id')"`
    FeedCode         string    `xorm:"'feedcode' varchar(50) comment('饲料编码')"`
    FName            string    `xorm:"'fname' varchar(120) comment('饲料名称')"`
    FeedSort         int       `xorm:"'feedsort' int(11) default 0 comment('饲料顺序')"`
    FeedAllowRatio   float32   `xorm:"'feedallowratio' float default 0 comment('饲料允许误差率')"`
    StirDelay        int       `xorm:"'stirdelay' int(11) default 0 comment('搅拌延时(分钟)')"`
    FWeight          float64   `xorm:"'fweight' decimal(10,3) comment('配方明细量')"`
    TmrLoadName      string    `xorm:"'tmrloadname' varchar(150) comment('相同饲料顺序在tmr车上的显示名称')"`
    DryFeed          float64   `xorm:"'dryfeed' decimal(38,2) comment('饲料干物质')"`
    PriceFeed        float64   `xorm:"'pricefeed' decimal(38,2) comment('饲料单价')"`
    OutWeight        int       `xorm:"'outweight' int(11) comment('人工确认出库量')"`
    ErrRatio         float64   `xorm:"'errratio' decimal(38,2)"`
    Date             time.Time `xorm:"'date' date not null"`
    ButtonSucc       int       `xorm:"'buttonsucc' tinyint(4)"`
    Type             int       `xorm:"'type' tinyint(4) default 0 comment('类型')"`
    Deviation        int       `xorm:"'deviation' int(11) comment('搅拌延时值允许延时偏差')"`
    XxwFeedCode      string    `xorm:"'xxwFeedCode' varchar(100)"`
}

func (d *DownloadPlanDtl1) TableName() string {
    return "downloadplandtl1"
}

// 如果需要定义索引，可以添加以下方法
func (d *DownloadPlanDtl1) TableIndex() [][]string {
    return [][]string{
        {"pastureid", "flpid", "fid", "date", "pid"},
        {"fid"},
        {"date"},
        {"pid", "pastureid"},
        {"pastureid", "flpid", "type", "date"},
        {"pastureid", "intime", "date"},
    }
}

// 复合主键配置（XORM对复合主键支持有限，这里提供一种方式）
func (d *DownloadPlanDtl1) PrimaryKeys() []string {
    return []string{"id", "pastureid", "date"}
}

// 或者使用ID作为主键，其他作为唯一索引
func (d *DownloadPlanDtl1) Id() int64 {
    return d.ID
}

type DownloadPlanDtl1Exec struct {
    ID                int64     `xorm:"'id' bigint(20) pk autoincr"`
    PastureID         int64     `xorm:"'pastureid' bigint(20) not null"`
    Pid               int64     `xorm:"'pid' bigint(20) not null comment('计划id')"`
    Flpid             int64     `xorm:"'flpid' bigint(20)"`
    LastActualWeight  float64   `xorm:"'lastactualweight' decimal(10,2) comment('上次重量')"`
    ActualWeight      float64   `xorm:"'actualweight' decimal(10,2) comment('本次重量')"`
    LWeight           float64   `xorm:"'lweight' decimal(16,2) not null comment('理论重量')"`
    ActualWeightMinus float64   `xorm:"'actualweightminus' decimal(10,2) comment('实际重量')"`
    // BeginTime         time.Time `xorm:"'begintime' datetime comment('操作开始时间')"`
    // InTime            time.Time `xorm:"'intime' datetime comment('操作结束时间')"`
    HaveButton        bool      `xorm:"'havebuttom' tinyint(1) not null default 0 comment('是否已操作')"`
    ButtonType        int       `xorm:"'buttontype' int(11) default 0 comment('按钮类型')"`
    OptDevice         int64     `xorm:"'optdevice' bigint(20) comment('操作车id')"`
    Sort              int       `xorm:"'sort' int(11) not null default 0 comment('顺序')"`
    FName             string    `xorm:"'fname' varchar(120) comment('饲料名称')"`
    FCount            int       `xorm:"'fcount' int(11) comment('饲料数')"`
    TmrLoadName       string    `xorm:"'tmrloadname' varchar(120) comment('相同饲料顺序在tmr车上的显示名称')"`
    FeedAllowRatio    float32   `xorm:"'feedallowratio' float default 0 comment('饲料允许误差公斤')"`
    // ProcessTime       string    `xorm:"'processtime' time comment('过程时间')"`
    StirDelay         int       `xorm:"'stirdelay' int(11) default 0 comment('搅拌延时(分钟)')"`
    ButtonSucc        int       `xorm:"'buttonsucc' tinyint(4) default 0"`
    ErrRatio          float64   `xorm:"'errratio' decimal(38,2)"`
    Date              time.Time `xorm:"'date' date not null"`
    Type              int       `xorm:"'type' tinyint(4) default 0 comment('类型')"`
    Deviation         int       `xorm:"'deviation' int(11) comment('搅拌延时值允许延时偏差')"`
    XxwFeedCode       string    `xorm:"'xxwFeedCode' varchar(100)"`
}

func (d *DownloadPlanDtl1Exec) TableName() string {
    return "downloadplandtl1_exec"
}

// 定义索引
func (d *DownloadPlanDtl1Exec) TableIndex() [][]string {
    return [][]string{
        {"pastureid", "pid", "sort", "date", "type"},
        {"pid"},
        {"pastureid", "pid"},
        {"date", "pastureid"},
        {"intime", "pastureid"},
        {"flpid"},
    }
}

// 复合主键配置
func (d *DownloadPlanDtl1Exec) PrimaryKeys() []string {
    return []string{"id", "pastureid", "date"}
}

// 如果需要使用ID作为主键，可以添加这个方法
func (d *DownloadPlanDtl1Exec) Id() int64 {
    return d.ID
}
type DownloadPlanDtl2 struct {
    ID                int64     `xorm:"'id' bigint(20) pk autoincr"`
    PastureID         int64     `xorm:"'pastureid' bigint(20) not null"`
    Pid               int64     `xorm:"'pid' bigint(20) not null comment('计划id')"`
    Flpid             int64     `xorm:"'flpid' bigint(20) comment('发料计划的主id')"`
    Fbarid            int64     `xorm:"'fbarid' bigint(20) not null comment('牛舍id')"`
    FName             string    `xorm:"'fname' varchar(50) comment('牛舍名称')"`
    LastActualWeight  float64   `xorm:"'lastactualweight' decimal(10,0) comment('上次重量')"`
    ActualWeight      float64   `xorm:"'actualweight' decimal(10,2) comment('本次重量')"`
    LWeight           float64   `xorm:"'lweight' decimal(16,2) comment('理论重量')"`
    LWeightHis        float64   `xorm:"'lweighthis' decimal(10,2) comment('历史理论重量')"`
    RemainLeftW       float64   `xorm:"'remainleftw' decimal(10,2) comment('剩料量')"`
    AllowRW           float64   `xorm:"'allowrw' decimal(10,2) comment('允许分配剩料量')"`
    ActualWeightMinus float64   `xorm:"'actualweightminus' decimal(10,2) comment('实际重量')"`
    Sort              int       `xorm:"'sort' int(11) not null default 0 comment('顺序')"`
    HaveButton        bool      `xorm:"'havebuttom' tinyint(1) default 0 comment('是否操作')"`
    BeginTime         time.Time `xorm:"'begintime' datetime comment('操作开始时间')"`
    BeginTag          string    `xorm:"'begintag' varchar(50) comment('开始标签')"`
    InTime            time.Time `xorm:"'intime' datetime comment('操作完成时间')"`
    EndTag            string    `xorm:"'endtag' varchar(50) comment('结束标签')"`
    ButtonType        int       `xorm:"'buttontype' int(11) default 0 comment('操作按键类型')"`
    OptDevice         int64     `xorm:"'optdevice' bigint(20) comment('操作车id')"`
    CowCount          int       `xorm:"'cowcount' int(11) default 0 comment('牛头数')"`
    CowClassID        int64     `xorm:"'cowclassid' bigint(20) comment('牛只类型id')"`
    CowClassName      string    `xorm:"'cowclassname' varchar(50) comment('类型名称')"`
    BigCowName        string    `xorm:"'bigcowname' varchar(50)"`
    PWeight           float64   `xorm:"'pweight' decimal(10,2) comment('通过加料计算出重量')"`
    CCountRatio       float32   `xorm:"'ccountratio' float default 100 comment('牛头系数')"`
    SumRTime          float32   `xorm:"'sumrtime' float default 0 comment('该班次比例')"`
    FeedTempletID     int64     `xorm:"'feedtempletid' bigint(20) comment('配方模版id')"`
    FeedTempletName   string    `xorm:"'feedtempletname' varchar(20) comment('配方模版名称')"`
    DryWeight         float64   `xorm:"'dryweight' decimal(10,2) comment('配方干物质')"`
    SumWeight         float64   `xorm:"'sumweight' decimal(10,2) comment('配方饲料总重量')"`
    PriceWeight       float64   `xorm:"'priceweight' decimal(10,2) comment('配方单价')"`
    // ProcessTime       string    `xorm:"'processtime' time comment('过程时间')"`
    Fpid              int64     `xorm:"'fpid' bigint(20) comment('栏舍配方id')"`
    UseInBarType      int64     `xorm:"'useinbartype' bigint(20) comment('转投栏舍类型')"`
    Date              time.Time `xorm:"'date' date not null"`
    AllowRatio        int       `xorm:"'allowratio' int(11) comment('栏舍允许误差')"`
    ErrRatio          float64   `xorm:"'errratio' decimal(38,2)"`
    ButtonSucc        int       `xorm:"'buttonsucc' tinyint(4)"`
    Type              int       `xorm:"'type' tinyint(4) default 0 comment('类型')"`
    XxwTempletCode    string    `xorm:"'xxwTempletCode' varchar(100)"`
    XxwBarCode        string    `xorm:"'xxwBarCode' varchar(100)"`
}

func (d *DownloadPlanDtl2) TableName() string {
    return "downloadplandtl2"
}

// 定义索引
func (d *DownloadPlanDtl2) TableIndex() [][]string {
    return [][]string{
        {"fbarid"},
        {"flpid"},
        {"pid"},
        {"intime"},
        {"date"},
        {"pastureid", "pid", "type"},
        {"pastureid", "flpid", "type", "date"},
    }
}

// 复合主键配置
func (d *DownloadPlanDtl2) PrimaryKeys() []string {
    return []string{"id", "pastureid", "date"}
}

// 获取ID的方法
func (d *DownloadPlanDtl2) Id() int64 {
    return d.ID
}