var Manager = db.Manager
var Device = db.Device
var Dealer = db.Dealer
var Agent = db.Agent
var MyUser = db.MyUser

var devices = () => Device.find().toArray()
var dealers = () => Dealer.find()
var managers = () => Manager.find()

var getManagerByDevice = (logicalCode) => {
    var device = Device.find({'logicalCode': logicalCode})[0]
    var dealer = Dealer.find({'_id': ObjectId(device.ownerId)})[0]
    var agent = Agent.find({'_id': ObjectId(dealer.agentId)})[0]
    return Manager.find({'_id':  ObjectId(agent.managerId)})[0]
}

var getManagerByDealer = (aMap) => {
    var dealer = Dealer.find(aMap)[0]
}

var groupDeviceByDealer = () => _.groupBy(devices, function(_){ return _['ownerId'] })

var getLatestUser = () => MyUser.find({}).sort({'last_login': -1})