summaryrefslogtreecommitdiff
path: root/src/server/api/endpoints/aggregation/posts
diff options
context:
space:
mode:
authorsyuilo <syuilotan@yahoo.co.jp>2018-04-08 02:30:37 +0900
committersyuilo <syuilotan@yahoo.co.jp>2018-04-08 02:30:37 +0900
commita1b490afa756a71b9cef4afa424575bc223bc612 (patch)
tree06de4d839e17b1e08e0891542af7360c701a154a /src/server/api/endpoints/aggregation/posts
parentMerge pull request #1392 from syuilo/greenkeeper/element-ui-2.3.3 (diff)
downloadsharkey-a1b490afa756a71b9cef4afa424575bc223bc612.tar.gz
sharkey-a1b490afa756a71b9cef4afa424575bc223bc612.tar.bz2
sharkey-a1b490afa756a71b9cef4afa424575bc223bc612.zip
Post --> Note
Closes #1411
Diffstat (limited to 'src/server/api/endpoints/aggregation/posts')
-rw-r--r--src/server/api/endpoints/aggregation/posts/reaction.ts76
-rw-r--r--src/server/api/endpoints/aggregation/posts/reactions.ts72
-rw-r--r--src/server/api/endpoints/aggregation/posts/reply.ts75
-rw-r--r--src/server/api/endpoints/aggregation/posts/repost.ts75
4 files changed, 0 insertions, 298 deletions
diff --git a/src/server/api/endpoints/aggregation/posts/reaction.ts b/src/server/api/endpoints/aggregation/posts/reaction.ts
deleted file mode 100644
index e622745337..0000000000
--- a/src/server/api/endpoints/aggregation/posts/reaction.ts
+++ /dev/null
@@ -1,76 +0,0 @@
-/**
- * Module dependencies
- */
-import $ from 'cafy';
-import Post from '../../../../../models/post';
-import Reaction from '../../../../../models/post-reaction';
-
-/**
- * Aggregate reaction of a post
- *
- * @param {any} params
- * @return {Promise<any>}
- */
-module.exports = (params) => new Promise(async (res, rej) => {
- // Get 'postId' parameter
- const [postId, postIdErr] = $(params.postId).id().$;
- if (postIdErr) return rej('invalid postId param');
-
- // Lookup post
- const post = await Post.findOne({
- _id: postId
- });
-
- if (post === null) {
- return rej('post not found');
- }
-
- const datas = await Reaction
- .aggregate([
- { $match: { postId: post._id } },
- { $project: {
- createdAt: { $add: ['$createdAt', 9 * 60 * 60 * 1000] } // Convert into JST
- }},
- { $project: {
- date: {
- year: { $year: '$createdAt' },
- month: { $month: '$createdAt' },
- day: { $dayOfMonth: '$createdAt' }
- }
- }},
- { $group: {
- _id: '$date',
- count: { $sum: 1 }
- }}
- ]);
-
- datas.forEach(data => {
- data.date = data._id;
- delete data._id;
- });
-
- const graph = [];
-
- for (let i = 0; i < 30; i++) {
- const 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()
- },
- count: 0
- });
- }
- }
-
- res(graph);
-});
diff --git a/src/server/api/endpoints/aggregation/posts/reactions.ts b/src/server/api/endpoints/aggregation/posts/reactions.ts
deleted file mode 100644
index 5f23e296fd..0000000000
--- a/src/server/api/endpoints/aggregation/posts/reactions.ts
+++ /dev/null
@@ -1,72 +0,0 @@
-/**
- * Module dependencies
- */
-import $ from 'cafy';
-import Post from '../../../../../models/post';
-import Reaction from '../../../../../models/post-reaction';
-
-/**
- * Aggregate reactions of a post
- *
- * @param {any} params
- * @return {Promise<any>}
- */
-module.exports = (params) => new Promise(async (res, rej) => {
- // Get 'postId' parameter
- const [postId, postIdErr] = $(params.postId).id().$;
- if (postIdErr) return rej('invalid postId param');
-
- // Lookup post
- const post = await Post.findOne({
- _id: postId
- });
-
- if (post === null) {
- return rej('post not found');
- }
-
- const startTime = new Date(new Date().setMonth(new Date().getMonth() - 1));
-
- const reactions = await Reaction
- .find({
- postId: post._id,
- $or: [
- { deletedAt: { $exists: false } },
- { deletedAt: { $gt: startTime } }
- ]
- }, {
- sort: {
- _id: -1
- },
- fields: {
- _id: false,
- postId: false
- }
- });
-
- const graph = [];
-
- for (let i = 0; i < 30; i++) {
- let day = new Date(new Date().setDate(new Date().getDate() - i));
- day = new Date(day.setMilliseconds(999));
- day = new Date(day.setSeconds(59));
- day = new Date(day.setMinutes(59));
- day = new Date(day.setHours(23));
- // day = day.getTime();
-
- const count = reactions.filter(r =>
- r.createdAt < day && (r.deletedAt == null || r.deletedAt > day)
- ).length;
-
- graph.push({
- date: {
- year: day.getFullYear(),
- month: day.getMonth() + 1, // In JavaScript, month is zero-based.
- day: day.getDate()
- },
- count: count
- });
- }
-
- res(graph);
-});
diff --git a/src/server/api/endpoints/aggregation/posts/reply.ts b/src/server/api/endpoints/aggregation/posts/reply.ts
deleted file mode 100644
index c76191e86b..0000000000
--- a/src/server/api/endpoints/aggregation/posts/reply.ts
+++ /dev/null
@@ -1,75 +0,0 @@
-/**
- * Module dependencies
- */
-import $ from 'cafy';
-import Post from '../../../../../models/post';
-
-/**
- * Aggregate reply of a post
- *
- * @param {any} params
- * @return {Promise<any>}
- */
-module.exports = (params) => new Promise(async (res, rej) => {
- // Get 'postId' parameter
- const [postId, postIdErr] = $(params.postId).id().$;
- if (postIdErr) return rej('invalid postId param');
-
- // Lookup post
- const post = await Post.findOne({
- _id: postId
- });
-
- if (post === null) {
- return rej('post not found');
- }
-
- const datas = await Post
- .aggregate([
- { $match: { reply: post._id } },
- { $project: {
- createdAt: { $add: ['$createdAt', 9 * 60 * 60 * 1000] } // Convert into JST
- }},
- { $project: {
- date: {
- year: { $year: '$createdAt' },
- month: { $month: '$createdAt' },
- day: { $dayOfMonth: '$createdAt' }
- }
- }},
- { $group: {
- _id: '$date',
- count: { $sum: 1 }
- }}
- ]);
-
- datas.forEach(data => {
- data.date = data._id;
- delete data._id;
- });
-
- const graph = [];
-
- for (let i = 0; i < 30; i++) {
- const 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()
- },
- count: 0
- });
- }
- }
-
- res(graph);
-});
diff --git a/src/server/api/endpoints/aggregation/posts/repost.ts b/src/server/api/endpoints/aggregation/posts/repost.ts
deleted file mode 100644
index a203605ebf..0000000000
--- a/src/server/api/endpoints/aggregation/posts/repost.ts
+++ /dev/null
@@ -1,75 +0,0 @@
-/**
- * Module dependencies
- */
-import $ from 'cafy';
-import Post from '../../../../../models/post';
-
-/**
- * Aggregate repost of a post
- *
- * @param {any} params
- * @return {Promise<any>}
- */
-module.exports = (params) => new Promise(async (res, rej) => {
- // Get 'postId' parameter
- const [postId, postIdErr] = $(params.postId).id().$;
- if (postIdErr) return rej('invalid postId param');
-
- // Lookup post
- const post = await Post.findOne({
- _id: postId
- });
-
- if (post === null) {
- return rej('post not found');
- }
-
- const datas = await Post
- .aggregate([
- { $match: { repostId: post._id } },
- { $project: {
- createdAt: { $add: ['$createdAt', 9 * 60 * 60 * 1000] } // Convert into JST
- }},
- { $project: {
- date: {
- year: { $year: '$createdAt' },
- month: { $month: '$createdAt' },
- day: { $dayOfMonth: '$createdAt' }
- }
- }},
- { $group: {
- _id: '$date',
- count: { $sum: 1 }
- }}
- ]);
-
- datas.forEach(data => {
- data.date = data._id;
- delete data._id;
- });
-
- const graph = [];
-
- for (let i = 0; i < 30; i++) {
- const 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()
- },
- count: 0
- });
- }
- }
-
- res(graph);
-});