smart_intersectionV2.0/server/dao/capture_vehicles.go

package dao

import (
	"server/global"
)

type CaptureVehicles struct {
	global.GVA_MODEL
	CameraId    int    `json:"cameraId" form:"cameraId" gorm:"comment:'摄像头id'"`
	SLicense    string `json:"sLicense" form:"sLicense" gorm:"comment:'车牌号'"`
	VehicleType int    `json:"vehicleType" form:"vehicleType" gorm:"comment:'车辆类型'"`
	CaptureTime string `json:"captureTime" form:"captureTime" gorm:"comment:'抓拍时间'"`
}

func (CaptureVehicles) TableName() string {
	return "capture_vehicles"
}

func QueryCaptureVehiclesList(limit, offset, vehicleType int, sLicense string) (captureVehicles []CaptureVehicles, total int64, err error) {
	db := global.GVA_DB.Model(&CaptureVehicles{})

	if vehicleType != 0 {
		db = db.Where("vehicle_type = ?", vehicleType)
	}

	if sLicense != "" {
		db = db.Where("s_license like ?", "%"+sLicense+"%")
	}

	err = db.Count(&total).Error
	if err != nil {
		return
	}
	err = db.Limit(limit).Offset(offset).Find(&captureVehicles).Error
	return
}