currentManagerQuery() {
        return new Promise((resolve, reject) => {
            const managerArr = [];
            connection.query('SELECT employees.id, CONCAT(employees.first_name, " ", employees.last_name) AS employee, roles.title FROM employees RIGHT JOIN roles ON employees.role_id = roles.id WHERE employees.id IN (1,2,3,4,5,6)', (err, res) => {
                if (err) throw err;
                res.forEach(manager => {
                    managerArr.push(manager.employee);
                    return err ? reject(err) : resolve(managerArr);
                });
            });
        });
    }
// generate list of all managers, excluding "none"
generate list of all managers, excluding "none"
generate list of all managers excluding " none "
currentManagerQuery() {
        return new Promise((resolve, reject) => {
            const managerArr = [];
            connection.query('SELECT employees.id, CONCAT(employees.first_name, " ", employees.last_name) AS employee, roles.title FROM employees RIGHT JOIN roles ON employees.role_id = roles.id WHERE employees.id IN (1,2,3,4,5,6)', (err, res) => {
                if (err) throw err;
                res.forEach(manager => {
                    managerArr.push(manager.employee);
                    return err ? reject(err) : resolve(managerArr);
                });
            });
        });
    }
currentManagerQuery ( ) { return new Promise ( ( resolve , reject ) => { const managerArr = [ ] ; connection . query ( 'SELECT employees.id, CONCAT(employees.first_name, " ", employees.last_name) AS employee, roles.title FROM employees RIGHT JOIN roles ON employees.role_id = roles.id WHERE employees.id IN (1,2,3,4,5,6)' , ( err , res ) => { if ( err ) throw err ; res . forEach ( manager => { managerArr . push ( manager . employee ) ; return err ? reject ( err ) : resolve ( managerArr ) ; } ) ; } ) ; } ) ; }
generate list of all managers, excluding "none"
generate list of all managers excluding " none "