时间范围和该工人以往添加记录重复性校验

zhangqian

2024-04-28 067650e77790adeb5222b7736649cb5b6b016162

 models/worker_position.go

@@ -23,12 +23,14 @@
   }
   WorkerPositionSearch struct {
      WorkerPosition
      Order    string
      PageNum  int
      PageSize int
      Orm      *gorm.DB
      Preload  bool
      Keyword  string
      Order                string
      PageNum              int
      PageSize             int
      Orm                  *gorm.DB
      Preload              bool
      Keyword              string
      OverlappingDateStart string
      OverlappingDateEnd   string
   }
)

@@ -85,6 +87,12 @@
   return slf
}

func (slf *WorkerPositionSearch) SetOverlappingDate(startDate string, endDate string) *WorkerPositionSearch {
   slf.OverlappingDateStart = startDate
   slf.OverlappingDateEnd = endDate
   return slf
}

func (slf *WorkerPositionSearch) build() *gorm.DB {
   var db = slf.Orm.Table(slf.TableName())

@@ -117,6 +125,10 @@
      db = db.Model(&WorkerPosition{}).Preload("Worker")
   }

   if slf.OverlappingDateStart != "" && slf.OverlappingDateEnd != "" {
      db = db.Where("start_date <=  ? and end_date >= ?", slf.OverlappingDateEnd, slf.OverlappingDateStart)
   }

   return db
}