FM / controllers

/var/www/verywell.gr/server/delivery/api/controllers/

/var/www/verywell.gr/server/delivery/api/controllers

Name	Size	Mode	Actions
account/	-	0755	rm
tableReserv/	-	0755	rm
auth.controller.js	13187	0644	edit dl rm
branch.controller.js	32443	0644	edit dl rm
branchReview.controller.js	5975	0644	edit dl rm
category.controller.js	5521	0644	edit dl rm
company.controller.js	22632	0644	edit dl rm
companyReview.controller.js	6396	0644	edit dl rm
companyTypes.controller.js	2765	0644	edit dl rm
countryCodes.controller.js	2648	0644	edit dl rm
delivery.controller.js	7624	0644	edit dl rm
deliveryTypes.controller.js	2397	0644	edit dl rm
driver.controller.js	4603	0644	edit dl rm
language.controller.js	2709	0644	edit dl rm
order.controller.js	40326	0644	edit dl rm
orderCancelCause.controller.js	3460	0644	edit dl rm
payTypes.controller.js	2329	0644	edit dl rm
permission.controller.js	2605	0644	edit dl rm
plan.controller.js	3630	0644	edit dl rm
planConfig.controller.js	3465	0644	edit dl rm
product.controller.js	25793	0644	edit dl rm
productGroups.controller.js	6618	0644	edit dl rm
productReview.controller.js	5992	0644	edit dl rm
productTypeFeatures.controller.js	2713	0644	edit dl rm
productTypes.controller.js	4154	0644	edit dl rm
role.controller.js	4012	0644	edit dl rm
room.controller.js	3457	0644	edit dl rm
table.controller.js	15495	0644	edit dl rm
user.controller.js	22213	0644	edit dl rm
userCart.controller.js	7231	0644	edit dl rm
waiter.controller.js	6173	0644	edit dl rm

Edit: /var/www/verywell.gr/server/delivery/api/controllers/waiter.controller.js (6173B)

module.exports = function ({ db }) {
	this.Statistic = async (req, res, next) => {
		logger.child({ path: req.path, request: req.query }).info()
		try {
			let t1 = performance.now()

const { uid, range } = req.query
			if (!uid) throw new BadRequest({ lang: req.user?.languageCode })

let date
			let waiter
			let list = []
			let whereOrders = {}

switch (range) {
				case DATE.RANGE.HOUR:
					date = getDateByDateRange(DATE.RANGE.HOUR)
					whereOrders['createdAt'] = {
						[db.Sequelize.Op.between]: [date.begin, date.end]
					}

waiter = await db.user.findOne({
						where: { uid },
						include: [
							{
								model: db.order,
								foreginKey: 'userId',
								as: 'waiterOrders',
								where: whereOrders
							}
						]
					})
					if (!waiter) throw new NotFound({ lang: req.user?.languageCode })
					if (!waiter.waiterOrders || !waiter.waiterOrders.length === 0)
						throw new NotFound({ lang: req.user?.languageCode })

for (let i = 0; i < 60; i++) {
						let dt = new Date(date.end)
						dt.setMinutes(dt.getMinutes() - i)
						dt.setSeconds(0)
						dt.setMilliseconds(0)

list.push({
							idx: 59 - i,
							name: dt.getMinutes(),
							date: dt,
							complete: waiter.waiterOrders.filter(
								(x) =>
									x.status == ORDER_STATUS.COMPLETE &&
									x.createdAt.getMinutes() == dt.getMinutes()
							).length,
							cancel: waiter.waiterOrders.filter(
								(x) =>
									x.status == ORDER_STATUS.CANCEL &&
									x.createdAt.getMinutes() == dt.getMinutes()
							).length
						})
					}
					break
				case DATE.RANGE.DAY:
					date = getDateByDateRange(DATE.RANGE.DAY)
					whereOrders['createdAt'] = {
						[db.Sequelize.Op.between]: [date.begin, date.end]
					}

const hours = hoursList(req.user.languageCode)
					for (let i = 0; i < hours.length; i++) {
						let dt = new Date(date.end)
						dt.setHours(dt.getHours() - i)
						dt.setMinutes(0)
						dt.setSeconds(0)
						dt.setMilliseconds(0)

list.push({
							idx: hours.length - 1 - i,
							name: hours[dt.getHours()],
							date: dt,
							complete: waiter.waiterOrders.filter(
								(x) =>
									x.status == ORDER_STATUS.COMPLETE &&
									x.createdAt.getUTCHours() == dt.getUTCHours()
							).length,
							cancel: waiter.waiterOrders.filter(
								(x) =>
									x.status == ORDER_STATUS.CANCEL &&
									x.createdAt.getUTCHours() == dt.getUTCHours()
							).length
						})
					}
					break
				case DATE.RANGE.WEEK:
					date = getDateByDateRange(DATE.RANGE.WEEK)
					whereOrders['createdAt'] = {
						[db.Sequelize.Op.between]: [date.begin, date.end]
					}

const days = daysOfWeekList(req.user.languageCode)
					for (let i = 0; i < days.length; i++) {
						let dt = new Date(date.end)
						dt.setDate(dt.getDate() - i)
						dt.setMinutes(0)
						dt.setSeconds(0)
						dt.setMilliseconds(0)

list.push({
							idx: days.length - 1 - i,
							name: days[dt.getDay()],
							date: dt,
							complete: waiter.waiterOrders.filter(
								(x) =>
									x.status == ORDER_STATUS.COMPLETE &&
									x.createdAt.getDate() == dt.getDate()
							).length,
							cancel: waiter.waiterOrders.filter(
								(x) =>
									x.status == ORDER_STATUS.CANCEL &&
									x.createdAt.getDate() == dt.getDate()
							).length
						})
					}
					break
				case DATE.RANGE.MONTH:
					date = getDateByDateRange(DATE.RANGE.MONTH)
					whereOrders['createdAt'] = {
						[db.Sequelize.Op.between]: [date.begin, date.end]
					}

for (let i = 0; i <= 30; i++) {
						let dt = new Date(date.end)
						dt.setDate(dt.getDate() - i)
						dt.setMinutes(0)
						dt.setSeconds(0)
						dt.setMilliseconds(0)

list.push({
							idx: 30 - i,
							name: dt.getDate(),
							date: dt,
							complete: waiter.waiterOrders.filter(
								(x) =>
									x.status == ORDER_STATUS.COMPLETE &&
									x.createdAt.getDate() == dt.getDate()
							).length,
							cancel: waiter.waiterOrders.filter(
								(x) =>
									x.status == ORDER_STATUS.CANCEL &&
									x.createdAt.getDate() == dt.getDate()
							).length
						})
					}
					break
			}

const time = performance.now() - t1
			return res.status(200).json({
				all: waiter.waiterOrders.length,
				complete: waiter.waiterOrders.filter((x) => x.status === ORDER_STATUS.COMPLETE)
					.length,
				cancel: waiter.waiterOrders.filter((x) => x.status === ORDER_STATUS.CANCEL).length,
				list,
				date,
				range,
				time
			})
		} catch (err) {
			next(err)
		}
	}
}