Firebase实时数据库查询

Question

我有一个firebase数据库，员工数据的结构如下。我还有一个用户表，它具有'Company ID'属性。每次用户登录时，我都希望获取与用户“公司ID”匹配的所有员工。是否有可能实现这使用firebase数据库规则或我必须写一些查询。

Employee: 
{
  "[phone]" : {
    "admin" : true,
    "companyId" : "C1",
    "depId" : "D5",
    "designation" : "D1",
    "dob" : "2019-04-02T18:30:00.000Z",
    "doj" : "2019-04-18T18:30:00.000Z",
    "empEmail" : "[e-mail]",
    "empId" : "E4",
    "empPhone" : "[phone]",
    "first_name" : "Nishanth",
    "gender" : "male",
    "last_name" : "K",
    "manager" : "M2",
    "type" : "permanent"
  },
  "[phone]" : {
    "admin" : true,
    "companyId" : "C2",
    "depId" : "D1",
    "designation" : "Software engineer",
    "dob" : "1991-07-31T18:30:00.000Z",
    "doj" : "2018-07-24T18:30:00.000Z",
    "empEmail" : "[e-mail]",
    "empId" : "E10",
    "empPhone" : "[phone]",
    "first_name" : "Arpit",
    "gender" : "male",
    "last_name" : "Srivastava",
    "manager" : "M1",
    "type" : "PERMANANENT"
  },
  "[phone]" : {
    "admin" : false,
    "companyId" : "C1",
    "companyName" : "Zetwerk",
    "depId" : "D1",
    "depName" : "Engineering",
    "empEmail" : "[e-mail]",
    "empId" : "E1",
    "empPhone" : "[phone]",
    "firebaseId" : "-LbNvaKFjqaaMl_JbNxd",
    "first_name" : "Dhanalakshmi",
    "type" : "contract"
  },
  "[phone]" : {
    "companyId" : "C1",
    "depId" : "D2",
    "empEmail" : "[e-mail]",
    "empId" : "E3",
    "empPhone" : "[phone]",
    "firebaseId" : "-LbNbABScOEzl-sMFE1u",
    "first_name" : "Sagar",
    "type" : "permanent"
  },
  "[phone]" : {
    "admin" : true,
    "companyId" : "C1",
    "depId" : "D6",
    "designation" : "SDE",
    "dob" : "2019-04-23T18:30:00.000Z",
    "doj" : "2019-04-02T18:30:00.000Z",
    "empEmail" : "[e-mail]",
    "empId" : "Z002",
    "empPhone" : "[phone]",
    "first_name" : "Sai",
    "gender" : "male",
    "last_name" : "Kumar",
    "type" : "permanent"
  }
}


User:
 "1":{
  "Name" : "Nishant Gupta",
  "companyId" : "C1",
  "role" : "admin"
} 

Answer 1

您确实必须使用查询，如下所示。我假设您在前端知道用户的companyID；

  var db = firebase.database();

  var userCompanyId = 'C1';  //you'll probably get this value from the user profile

  db.ref('Employee')
    .orderByChild('companyId')
    .equalTo(userCompanyId)   
    .once('value', function(dataSnapshot) {
      dataSnapshot.forEach(function(childSnapshot) {
        var childKey = childSnapshot.key;
        var childData = childSnapshot.val();
        console.log('childKey : ', childKey);
        console.log('childData : ', childData);
      });
    });