package models

import (
	"fmt"
	"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.QueryTable(uc.TableName()).Filter("userId", userId).All(&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()
	sql := fmt.Sprintf("delete from "+uc.TableName()+" where userId='%s' and plateNo='%s'", userId, plateNo)
	result, err := o.Raw(sql).Exec()
	if err != nil {
		return 0, err
	}
	return result.RowsAffected()
}