// Copyright 2019 getensh.com. All rights reserved. // Use of this source code is governed by getensh.com. package park_space import ( "context" "encoding/json" "fmt" "git.getensh.com/common/gopkgs/database" "git.getensh.com/common/gopkgs/logger" "go.uber.org/zap" "google.golang.org/grpc/status" "property-garden/errors" "property-garden/impl/v1/charge_utils" dbmodel "property-garden/model" pb_v1 "property-garden/pb/v1" "property-garden/utils" ) func getHouseholdInfos(uids []int64, dbname string) (map[int64]dbmodel.THouseApprovedGarden, error) { p := dbmodel.NewHouseApprovedGarden(dbname) ret := map[int64]dbmodel.THouseApprovedGarden{} if len(uids) == 0 { return ret, nil } where := map[string]interface{}{ "uid in": uids, } list, err := p.List(database.DB(), where, nil, -1, -1) if err != nil { return nil, errors.DataBaseError } for _, v := range list { ret[v.Uid] = v } return ret, nil } func getHouseholdHouseIds(uid int64, dbname string) ([]int64, error) { where := map[string]interface{}{ "uid": uid, } h := dbmodel.NewHouseApprovedGarden(dbname) hlist, err := h.List(database.DB(), where, nil, -1, -1) if err != nil { return nil, errors.DataBaseError } hids := make([]int64, len(hlist)) for i, v := range hlist { hids[i] = v.HouseId } return hids, nil } func GetVehicleInfos(ids []int64, dbname string) (map[int64]dbmodel.TVehicle, error) { ret := map[int64]dbmodel.TVehicle{} if len(ids) == 0 { return ret, nil } p := dbmodel.NewVehicle(dbname) where := map[string]interface{}{ "id in": ids, } list, err := p.List(database.DB(), where, nil, -1, -1) if err != nil { return nil, errors.DataBaseError } for _, v := range list { ret[v.ID] = v } return ret, nil } // func ParkSpaceList(ctx context.Context, req *pb_v1.ParkSpaceListRequest) (reply *pb_v1.ParkSpaceListReply, err error) { reply = &pb_v1.ParkSpaceListReply{} // 捕获各个task中的异常并返回给调用者 defer func() { if r := recover(); r != nil { err = fmt.Errorf("%+v", r) e := &status.Status{} if er := json.Unmarshal([]byte(err.Error()), e); er != nil { logger.Error("err", zap.String("system_err", err.Error()), zap.Stack("stacktrace")) } } }() if req.GardenId < 1 { return nil, errors.ParamsError } if req.Page == 0 { req.Page = 1 } if req.PageSize == 0 { req.PageSize = 10 } dbname := utils.GetGardenDbName(req.GardenId) p := dbmodel.NewSpacePark(dbname) where := map[string]interface{}{ //"garden_id":req.GardenId, } if req.SpaceType > 0 { where["space_type"] = req.SpaceType } if req.ParkId > 0 { where["park_id"] = req.ParkId } if req.SpaceNumber != "" { where["space_number"] = req.SpaceNumber } if req.HouseId > 0 { where["house_id"] = req.HouseId } or := map[string]interface{}{} if req.BindType == BindTypeRent { or["bind_status"] = SpaceBindStatusEmpty if req.BindSpaceId > 0 { or["id"] = req.BindSpaceId } } // 查找业主购买的车位 if req.BindType == BindTypeSell { if req.HouseholdUid < 0 { return nil, status.Error(10003, "搜索已售车位,业主uid不能为空") } hids, err := getHouseholdHouseIds(req.HouseholdUid, dbname) if err != nil { return nil, err } if len(hids) == 0 { return nil, status.Error(10003, "未找到该业主房屋") } where["house_id in"] = hids } reply.Page = req.Page reply.Total, err = p.Count(database.DB(), where, or) if err != nil { return nil, errors.DataBaseError } if reply.Total == 0 { return reply, nil } list, err := p.List(database.DB(), where, or, int(req.Page), int(req.PageSize)) if err != nil { return nil, errors.DataBaseError } reply.List = make([]*pb_v1.ParkSpaceItem, len(list)) houseIds := []int64{} vehicleIds := []int64{} for _, v := range list { if v.HouseId > 0 { houseIds = append(houseIds, v.HouseId) } if v.VehicleId > 0 { vehicleIds = append(vehicleIds, v.VehicleId) } } houseInfoM, err := charge_utils.GetHouseInfos(houseIds, dbname) if err != nil { return nil, err } vehicleInfoM, err := GetVehicleInfos(vehicleIds, dbname) if err != nil { return nil, err } for i, v := range list { reply.List[i] = &pb_v1.ParkSpaceItem{ Id: v.ID, SpaceNumber: v.SpaceNumber, SpaceType: v.SpaceType, SpaceArea: v.SpaceArea, ParkId: v.ParkId, ParkType: v.ParkType, ParkNumber: v.ParkNumber, ParkName: v.ParkName, Comment: v.Comment, HouseId: v.HouseId, Status: v.Status, HouseName: fmt.Sprintf("%v-%v-%v", houseInfoM[v.HouseId].BuildingNumber, houseInfoM[v.HouseId].UnitNumber, houseInfoM[v.HouseId].HouseNumber), CreatedAt: v.CreatedAt.Format("2006-01-02 15:04:05"), } if v.Status == SpaceStatusRent && v.VehicleId > 0 { reply.List[i].PlateNo = vehicleInfoM[v.VehicleId].PlateNo } } return reply, nil }