Untitled
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