package models

import "github.com/astaxie/beego/orm"

type UserCar struct {
	Id       	string 		`orm:"pk;size(50);column(id)" json:"id"`
	UserId 		string 		`orm:"column(userId)" json:"userId"` //人员id
	PlateNo 	string 		`orm:"column(plateNo)" json:"plateNo"` //车牌号
}

func (uc *UserCar) TableName() string {
	return "user_car"
}

func (uc *UserCar) Insert() (int64,error) {
	o := orm.NewOrm()
	return o.Insert(uc)
}

func (uc *UserCar) GetByUserId(userId string) (all []UserCar,err error) {
	o := orm.NewOrm()
	_, err = o.Raw("select * from ? where userId=?", uc.TableName(), userId).QueryRows(&all)
	if err != nil {
		return nil, err
	}
	return all,nil
}

func (uc *UserCar) Exist(userId string, plateNo string) bool {
	var list []UserCar
	o := orm.NewOrm()
	o.Raw("select * from ? where userId=? and plateNo=?", uc.TableName(), userId, plateNo).QueryRows(&list)
	if len(list) >0 {
		return true
	}
	return false
}

func (uc *UserCar) Delete(userId string, plateNo string) (int64, error) {
	o := orm.NewOrm()
	result, err := o.Raw("delete from ? where userId=? and plateNo=?", uc.TableName(), userId, plateNo).Exec()
	if err != nil {
		return 0, err
	}
	return result.RowsAffected()
}