'use strict';
module.exports = {
	/**
	 * 获取我收藏的广场帖子
	 * @url client/bbs/pub/getMySquareCollection 前端调用的url参数地址
	 * data 请求参数
	 * @param {String} params1  参数1
	 */
	main: async (event) => {
		let { data = {}, userInfo, util, filterResponse, originalParam } = event;
		let { customUtil, uniID, config, pubFun, vk, db, _ } = util;
		let { uid } = data;
		let res = { code: 0, msg: "" };
		// 业务逻辑开始-----------------------------------------------------------

		// 要关联取出 评论条数
		let dbName = "user-bbs-star";
		res = await vk.baseDao.selects({
			dbName,
			data,
			getMain: false, // 是否只返回rows数据
			pageIndex: data.pageNo, // 当前第几页
			pageSize: data.pageSize, // 每页条数
			whereJson: {
				user_id: uid
			},
			sortArr: [
				{ "name": "_add_time", "type": "desc" }
			],
			foreignDB: [{
				dbName: "bbs_article",
				localKey: "posts_id",
				foreignKey: "_id",
				as: "posts",
				limit: 1,
				fieldJson: {
					content: true,
					uid: true,
					category_id: true,
					images: true,
					_add_time: true,
					like_count: true
				}
			}, {
				dbName: "user-bbs-tumbup",
				localKey: "posts_id",
				foreignKey: "posts_id",
				as: "tumbups",
				fieldJson: { _id: true }
			}, {
				dbName: "user-bbs-tumbup",
				localKey: "posts_id",
				foreignKey: "posts_id",
				as: "tumbup",
				fieldJson: { _id: true },
				whereJson: {
					user_id: uid
				},
				limit: 1,
			}, {
				dbName: "bbs_comments",
				localKey: "posts_id",
				foreignKey: "aid",
				as: "comments",
				foreignDB: [{
					dbName: "uni-id-users",
					localKey: "uid",
					foreignKey: "_id",
					as: "user",
					fieldJson: { nickname: true, avatar: true },
					limit: 1,
				}]
			}, {
				dbName: "uni-id-users",
				localKey: "poster_id",
				foreignKey: "_id",
				as: "poster",
				fieldJson: { nickname: true, avatar: true },
				limit: 1,
			}]
		});

		// 业务逻辑结束-----------------------------------------------------------
		return res;
	}
}