FM / controllers

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

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

Name	Size	Mode	Actions
tableReserv/	-	0755	rm
userAccount/	-	0755	rm
auth.controller.js	12306	0644	edit dl rm
branch.controller.js	25187	0644	edit dl rm
branchReview.controller.js	5620	0644	edit dl rm
category.controller.js	5521	0644	edit dl rm
company.controller.js	20595	0644	edit dl rm
companyReview.controller.js	5773	0644	edit dl rm
companyTypes.controller.js	2722	0644	edit dl rm
countryCodes.controller.js	2648	0644	edit dl rm
delivery.controller.js	7470	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	31301	0644	edit dl rm
orderCancelCause.controller.js	3460	0644	edit dl rm
payTypes.controller.js	2278	0644	edit dl rm
permission.controller.js	2605	0644	edit dl rm
product.controller.js	25793	0644	edit dl rm
productGroups.controller.js	6568	0644	edit dl rm
productReview.controller.js	5233	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	21794	0644	edit dl rm
userCart.controller.js	7231	0644	edit dl rm
waiter.controller.js	6173	0644	edit dl rm

Edit: /var/www/qr4y.gr/server/delivery/api/controllers/productReview.controller.js (5233B)

const logger = require('../../logger')({ service: 'api' })
const { NotFound, BadRequest } = require('../responseModels/errors')
const { isSet, isEmpty, minLength, isPhone, isEmail } = require('../utils/validator.util')

module.exports = function ({ db }) {
	this.List = async (req, res, next) => {
		logger.child({ path: req.path, request: req.query }).info()
		try {
			let t1 = performance.now()
			const { isVerified, userId, productId, limit, page } = req.query
			let where = {}

if (userId) {
				where['userId'] = parseInt(userId)
			}
			if (productId) {
				where['productId'] = parseInt(productId)
			}
			if (typeof isVerified === 'undefined') {
				where['isVerified'] = true
			} else {
				where['isVerified'] = isVerified
			}

let offset = page > 0 ? (page - 1) * (limit || 10) : 0
			const { count, rows } = await db.productReview.findAndCountAll({
				where,
				offset,
				limit: parseInt(limit) || 10
			})
			const time = performance.now() - t1
			return res.status(200).json({ list: rows, count, time, page })
		} catch (err) {
			next(err)
		}
	}
	this.Details = async (req, res, next) => {
		logger.child({ path: req.path, request: req.params }).info()
		try {
			const { uid } = req.params
			const review = await db.productReview.findOne({ where: { uid } })

return res.status(200).json(review)
		} catch (err) {
			next(err)
		}
	}
	this.Accept = async (req, res, next) => {
		logger.child({ path: req.path, request: req.body }).info()
		let transaction = null
		try {
			const { uid } = req.body

if(!isSet(uid) || isEmpty(uid)){
				throw new BadRequest({ lang: req.user?.languageCode })
			}

transaction = await db.sequelize.transaction()
			const review = await db.productReview.findOne({ where: { uid } })
			review.isVerified = true
			await review.save()
			await calculateProductRating(review.productId)
			await transaction.commit()

return res.status(200).json({ status: 'success', uid })
		} catch (err) {
			transaction?.rollback()
			next(err)
		}
	}
	this.Create = async (req, res, next) => {
		logger.child({ path: req.path, request: req.body }).info()
		try {
			const { productUid, text, rating } = req.body

if(!isSet(productUid) || isEmpty(productUid)){
				throw new BadRequest({ lang: req.user?.languageCode })
			}
			if(!isSet(text) || isEmpty(text)){
				throw new BadRequest({ lang: req.user?.languageCode })
			}
			if(!isSet(rating)){
				throw new BadRequest({ lang: req.user?.languageCode })
			}

let product = await db.product.findOne({
				where: { uid: productUid }
			})
			const review = await db.productReview.create({
				productId: product.id,
				userId: req.user.id,
				text,
				rating
			})
			// Расчет рейтинга не нужен. Расчет будет после подтверждения. 
			return res.status(200).json({ success: 'success', uid: review.uid })
		} catch (err) {
			next(err)
		}
	}
	this.Edit = async (req, res, next) => {
		logger.child({ path: req.path, request: req.body }).info()
		let transaction = null
		try {
			const { uid, rating, text } = req.body

if(!isSet(uid) || isEmpty(uid)){
				throw new BadRequest({ lang: req.user?.languageCode })
			}
			if(!isSet(text) || isEmpty(text)){
				throw new BadRequest({ lang: req.user?.languageCode })
			}
			if(!isSet(rating)){
				throw new BadRequest({ lang: req.user?.languageCode })
			}

transaction = await db.sequelize.transaction()
			let review = await db.productReview.findOne({ where: { uid } })

if (rating != review.rating || text != review.text) {
				review.isVerified = false
			}

review.rating = rating
			review.text = text

await review.save()
			await calculateProductRating(review.productId)
			await transaction.commit()

return res.status(200).json(review)
		} catch (err) {
			transaction?.rollback()
			next(err)
		}
	}
	this.Delete = async (req, res, next) => {
		logger.child({ path: req.path, request: req.body }).info()
		let transaction = null
		try {
			const { uid } = req.body

if(!isSet(uid) || isEmpty(uid)){
				throw new BadRequest({ lang: req.user?.languageCode })
			}

transaction = await db.sequelize.transaction()
			const review = await db.productReview.findOne({ where: { uid } })
			
			const productId = review.productId
			const isVerified = review.isVerified

await review.destroy()
			// если отзыв был проверен то пересчитать рейтинг
			if(isVerified) await calculateProductRating(productId)
			await transaction.commit()

return res.status(200).json({ status: 'success', uid })
		} catch (err) {
			transaction?.rollback()
			next(err)
		}
	}

async function calculateProductRating(productId) {
		let product = await db.product.findOne({ where: { id: productId } })
		if(!product){
			throw new NotFound({ lang: req.user?.languageCode })
		}

const reviews = await db.productReview.findAll({
			where: { productId: productId, isVerified: true }
		})

if (reviews.length > 0) {			
			product.rating =
				reviews.reduce((previousValue, review) => {
					return (previousValue ? previousValue : 0) + (review ? review.rating : 0)
				}, 0) / reviews.length
		} else {
			product.rating = 0
		}

await product.save()
	}
}

cmd: