用户如何获取两个时间戳之间的对象

How to get objects between two timestamps by an user

本文关键字：时间戳 两个 之间 对象 获取 用户 何获取      更新时间：2023-09-26

对于在一天内创建了两个或多个对象（createdAt）的用户，我想循环浏览我的所有对象。（00:00:00-23:59:59）一天的历元：86400秒）。我想在一年内的所有日子里都这样做。这可能吗？如何实现？

结果可以是在同一天创建了两个或多个对象的用户数组。

我建立了一个Firebase数据库，其中包含以下结构：

{ "-KFNn8CA5QdxuhJaaatw" : { "some" : "data", "createdAt" : 1460704940, "points" : 0, "userKey" : 1 }, -KFNn8CA5QdxuhJW11tw" : { "some" : "data", "createdAt" : 1460704940, "points" : 0, "userKey" : 1 }, -KFNn8CA5QdxuhJW66tw" : { "some" : "data", "createdAt" : 1460704940, "points" : 0, "userKey" : 3 }, -KFNn8CA5QdxuhJW6123w" : { "some" : "data", "createdAt" : 1460704940, "points" : 0, "userKey" : 5 } ..... }

这就是我得到的：

var arr = {
    "-KFNn8CA5QdxuhJaaatw" : {
        "some" : "data",
        "createdAt" : 1460704940,
        "points" : 0,
        "userKey" : 1
    },
    "-KFNn8CA5QdxuhJW11tw" : {
        "some" : "data",
        "createdAt" : 1460704940,
        "points" : 0,
        "userKey" : 1
    },
    "-KFNn8CA5QdxuhJW66tw" : {
        "some" : "data",
        "createdAt" : 1460704940,
        "points" : 0,
        "userKey" : 3
    },
    "-KFNn8CA5QdxuhJW6123w" : {
        "some" : "data",
        "createdAt" : 1460704940,
        "points" : 0,
        "userKey" : 5
    }
};
// keeps a reference of the last object a user created
var dict = {};
// using an object, so we get distinct values
var userKeys = {};
// getting a list of objects ordered by creation time
var objs = Object.keys(arr).map(function (k) {
        return arr[k];
    });
objs.sort(function (a, b) {
    return a.createdAt - b.createdAt;
});
objs.forEach(function (obj) {
    // if dict holds an object for this user, compare if they were created in the same day
    if (dict[obj.userKey]) {
        if (inSameDay(dict[obj.userKey].createdAt, obj.createdAt)) {
            userKeys[obj.userKey] = true;
        }
    }
    // store the object the user created last
    dict[obj.userKey] = obj;
});
// get ids as an array
var users = Object.keys(userKeys);
// compare if two datetimes are in the same day
function inSameDay(t1, t2) {
    var d1 = new Date(t1 * 1000);
    var d2 = new Date(t2 * 1000);
    return d1.getFullYear() == d2.getFullYear() &&
    d1.getMonth() == d2.getMonth() &&
    d1.getDate() == d2.getDate();
}

最后，users数组将包含在同一天创建了两个对象的用户的密钥。

如果你想获得比你要求的更多的信息，可以创建一个数据结构，根据你想查询的数据进行分组，这样就很容易得到你想要的任何结果。这里有一个例子：

// this is an object containing all the data
// grouped by userKey and date
var data = {}
Object.keys(arr).forEach(function (key) {
    var obj = arr[key];
    var userData = data[obj.userKey];
    if (!userData) {
        data[obj.userKey] = (userData = {});
    }
    var date = new Date(obj.createdAt * 1000);
    var dateString = date.getFullYear() + '/' + (date.getMonth() + 1) + '/' + date.getDate();
    var dateData = userData[dateString];
    if (!dateData) {
        userData[dateString] = (dateData = []);
    }
    dateData.push(obj);
});
// this is an array of userKeys for users with
// two or more items created per day
var users = Object.keys(data)
    .filter(function (userKey) {
        var dates = Object.keys(data[userKey]);
        for (var i = 0; i < dates.length; i++) {
            if (data[userKey][dates[i]].length >= 2)
                return true;
        }
        return false;
    });
// and this is their data
var dataOfUsers = {};
users.forEach(function (userKey) {
    dataOfUsers[userKey] = data[userKey];
});
相关文章：