Untitled

 avatar
unknown
javascript
a year ago
887 B
3
Indexable
exports.countInspectionEachCenterLastTwelveMonths = async (req, res) => {
	let queryString = utils.generateQueryStringWithDate(
		req.query,
		"inspection_date"
	);
	connection.query(
		`SELECT
 			CONCAT( EXTRACT(MONTH FROM inspection_date),"/",EXTRACT(YEAR FROM inspection_date) ) as monthYear,
  			COUNT(*) AS count
		FROM inspections
  		Where ${queryString ? queryString : 1} AND centre_id = ?
		GROUP BY EXTRACT(MONTH FROM inspection_date),EXTRACT(YEAR FROM inspection_date)
		ORDER BY
  			EXTRACT(YEAR FROM inspection_date) DESC, EXTRACT(MONTH FROM inspection_date) DESC
  		Limit 12;`,
		[req.user.centre_id],
		(err, result, fields) => {
			if (err) {
				return res.status(500).json({
					status: "Failed",
					error: err,
				});
			} else {
				return res.status(200).json({
					status: "Success",
					data: result,
				});
			}
		}
	);
};
Editor is loading...
Leave a Comment