const getDataDB = (query, params = []) =>
new Promise((resolve, reject) => {
pool.query(query, params, (err, result) => {
if (err) {
reject(err)
}
resolve(result)
})
})
[...document.querySelectorAll('.pgn_a > .pgn')]
.find(el => el.innerHTML === '2') !== undefined
SELECT *
FROM `Vacation` AS `v1`
JOIN `Vacation` AS `v2`
ON `v1`.`DateBegin` <= `v2`.`DateEnd`
AND `v2`.`DateBegin` <= `v1`.`DateEnd`
AND `v1`.`ID_Employee` < `v2`.`ID_Employee`
LEFT JOIN `employee` AS `e1`
ON `e1`.`Id` = `v1`.`ID_Employee`
LEFT JOIN `employee` AS `e2`
ON `e2`.`Id` = `v2`.`ID_Employee`