| | |
| | | BankAccount BankAccount `gorm:"foreignKey:BankAccountId" json:"bankAccount"` |
| | | Remark string `gorm:"column:remark;type:varchar(255);not null;default '';comment:备注" json:"remark"` // 备注 |
| | | FileId int `gorm:"column:file_id;type:int;not null;default 0;comment:附件id" json:"fileId"` // 附件id |
| | | gorm.Model `json:"-"` |
| | | CrmModel |
| | | } |
| | | |
| | | // ReceiptSearch 收款单搜索条件 |
| | | ReceiptSearch struct { |
| | | Receipt |
| | | Orm *gorm.DB |
| | | QueryClass constvar.ReceiptQueryClass |
| | | KeywordType constvar.ReceiptKeywordType |
| | | Keyword string |
| | | PageNum int |
| | | PageSize int |
| | | Orm *gorm.DB |
| | | QueryClass constvar.ReceiptQueryClass |
| | | KeywordType constvar.ReceiptKeywordType |
| | | Keyword string |
| | | PageNum int |
| | | PageSize int |
| | | PrincipalIds []int |
| | | } |
| | | ) |
| | | |
| | | func (Receipt) TableName() string { |
| | | func (slf *Receipt) TableName() string { |
| | | return "receipt" |
| | | } |
| | | |
| | | func (slf *Receipt) AfterFind(db *gorm.DB) (err error) { |
| | | err = slf.CrmModel.AfterFind(db) |
| | | if slf.CrmModel.ID == 0 { |
| | | slf.CrmModel.ID = uint(slf.Id) |
| | | } |
| | | slf.CrmModel.SetNumber(constvar.NumberPrefixOfReceipt) |
| | | return nil |
| | | } |
| | | |
| | | func NewReceiptSearch() *ReceiptSearch { |
| | |
| | | return slf |
| | | } |
| | | |
| | | func (slf *ReceiptSearch) SetPrincipalIds(principalIds []int) *ReceiptSearch { |
| | | slf.PrincipalIds = principalIds |
| | | return slf |
| | | } |
| | | |
| | | func (slf *ReceiptSearch) SetPage(page, size int) *ReceiptSearch { |
| | | slf.PageNum, slf.PageSize = page, size |
| | | return slf |
| | |
| | | } |
| | | if slf.SourceId != 0 { |
| | | db = db.Where("source_id = ?", slf.SourceId) |
| | | } |
| | | if slf.ClientId != 0 { |
| | | db = db.Where("client_id = ?", slf.ClientId) |
| | | } |
| | | if len(slf.PrincipalIds) != 0 { |
| | | db = db.Where("principal_id in ?", slf.PrincipalIds) |
| | | } |
| | | |
| | | return db |
| | |
| | | |
| | | func (slf *ReceiptSearch) SetId(id int) *ReceiptSearch { |
| | | slf.Id = id |
| | | return slf |
| | | } |
| | | |
| | | func (slf *ReceiptSearch) SetClientId(clientId int) *ReceiptSearch { |
| | | slf.ClientId = clientId |
| | | return slf |
| | | } |
| | | |
| | |
| | | db = db.Limit(slf.PageSize).Offset((slf.PageNum - 1) * slf.PageSize) |
| | | } |
| | | |
| | | err := db.Preload("Principal").Preload("Client").Find(&records).Error |
| | | err := db.Preload("Principal").Preload("Client").Preload("PaymentType").Preload("BankAccount").Order("created_at desc").Find(&records).Error |
| | | return records, total, err |
| | | } |
| | | |