diff options
| author | syuilo <syuilotan@yahoo.co.jp> | 2017-03-03 19:52:36 +0900 |
|---|---|---|
| committer | syuilo <syuilotan@yahoo.co.jp> | 2017-03-03 19:52:36 +0900 |
| commit | 970843acd429e62c884c780601fae317a6a0fabb (patch) | |
| tree | 03a5d532d5b30758311d9069519d24f23bc209c7 /src/api/endpoints/aggregation/users/post.js | |
| parent | wip (diff) | |
| download | misskey-970843acd429e62c884c780601fae317a6a0fabb.tar.gz misskey-970843acd429e62c884c780601fae317a6a0fabb.tar.bz2 misskey-970843acd429e62c884c780601fae317a6a0fabb.zip | |
done
Diffstat (limited to 'src/api/endpoints/aggregation/users/post.js')
| -rw-r--r-- | src/api/endpoints/aggregation/users/post.js | 116 |
1 files changed, 0 insertions, 116 deletions
diff --git a/src/api/endpoints/aggregation/users/post.js b/src/api/endpoints/aggregation/users/post.js deleted file mode 100644 index 01082801e4..0000000000 --- a/src/api/endpoints/aggregation/users/post.js +++ /dev/null @@ -1,116 +0,0 @@ -'use strict'; - -/** - * Module dependencies - */ -import * as mongo from 'mongodb'; -import User from '../../../models/user'; -import Post from '../../../models/post'; - -/** - * Aggregate post of a user - * - * @param {any} params - * @return {Promise<any>} - */ -module.exports = (params) => - new Promise(async (res, rej) => -{ - // Get 'user_id' parameter - const userId = params.user_id; - if (userId === undefined || userId === null) { - return rej('user_id is required'); - } - - // Lookup user - const user = await User.findOne({ - _id: new mongo.ObjectID(userId) - }, { - fields: { - _id: true - } - }); - - if (user === null) { - return rej('user not found'); - } - - const datas = await Post - .aggregate([ - { $match: { user_id: user._id } }, - { $project: { - repost_id: '$repost_id', - reply_to_id: '$reply_to_id', - created_at: { $add: ['$created_at', 9 * 60 * 60 * 1000] } // Convert into JST - }}, - { $project: { - date: { - year: { $year: '$created_at' }, - month: { $month: '$created_at' }, - day: { $dayOfMonth: '$created_at' } - }, - type: { - $cond: { - if: { $ne: ['$repost_id', null] }, - then: 'repost', - else: { - $cond: { - if: { $ne: ['$reply_to_id', null] }, - then: 'reply', - else: 'post' - } - } - } - }} - }, - { $group: { _id: { - date: '$date', - type: '$type' - }, count: { $sum: 1 } } }, - { $group: { - _id: '$_id.date', - data: { $addToSet: { - type: '$_id.type', - count: '$count' - }} - } } - ]); - - datas.forEach(data => { - data.date = data._id; - delete data._id; - - data.posts = (data.data.filter(x => x.type == 'post')[0] || { count: 0 }).count; - data.reposts = (data.data.filter(x => x.type == 'repost')[0] || { count: 0 }).count; - data.replies = (data.data.filter(x => x.type == 'reply')[0] || { count: 0 }).count; - - delete data.data; - }); - - const graph = []; - - for (let i = 0; i < 30; i++) { - let day = new Date(new Date().setDate(new Date().getDate() - i)); - - const data = datas.filter(d => - d.date.year == day.getFullYear() && d.date.month == day.getMonth() + 1 && d.date.day == day.getDate() - )[0]; - - if (data) { - graph.push(data) - } else { - graph.push({ - date: { - year: day.getFullYear(), - month: day.getMonth() + 1, // In JavaScript, month is zero-based. - day: day.getDate() - }, - posts: 0, - reposts: 0, - replies: 0 - }) - }; - } - - res(graph); -}); |