index.js

require('dotenv').config();

const ldap = require('ldapjs');
const passwordhasher = require('password-hasher');
const { Client } = require('pg')

const pgclient = new Client()
const generator = require('generate-password');
let LDAPClient = ldap.createClient({
    url: 'ldap://10.244.138.150'
})
LDAPClient.bind("cn=admin, dc=utdmaker, dc=space", `password`, (err) => {
    AddUserToGroup('testboi','3D Printing', LDAPClient);
    if (err) {
        console.warn(err);
        return;
    }
    pgclient.connect()
    pgclient.query('SELECT * from fixed_members', (err, res) => {
        //console.log(err ? err.stack : res.rows[0]) // Hello World!
        if (err) {
            return 0;
        }
        res.rows.forEach(({ firstname, lastname, netid, email, legacydata }, index) => {
            const password = generator.generate({
                length: 10,
                numbers: true
            });
            if (firstname !== null && lastname !== null && netid !== null && email !== null && firstname == "Cameron" ) {
                console.log(`Sending an email to: ${email}`)
                console.log(`Hey ${firstname}, This message is letting you know that you have been succesfully onboarded as a UTDesign Makerspace Member. Here are your login credentials:\nusername: ${netid}\npassword: ${password}`)
                const LDAPPerson = {
                    displayName: `${firstname} ${lastname}`,
                    sn: lastname,
                    cn: netid,
                    givenName: firstname,
                    homeDirectory: `/home/${netid}`,
                    objectClass: [
                        "inetOrgPerson",
                        "posixAccount",
                        "top"
                    ],
                    userPassword: passwordhasher.formatRFC2307(passwordhasher.createHash('sha', password, new Buffer('83d88386463f0625', 'hex'))),
                    uid: netid,
                    uidNumber: 10003 + index,
                    gidNumber: 34657

                }
                LDAPClient.add(`uid=${netid}, dc=utdmaker, dc=space`, LDAPPerson , (err) => {
                    //console.log(LDAPPerson)
                    console.log(err == null ? "": err)
                })
                if(legacydata == "3dprinting"){
                    AddUserToGroup(LDAPPerson.uid, '3D Printing', LDAPClient);
                }
                
                
            }
        })
        pgclient.end()
    })


});

function AddUserToGroup(uid, cn, client) {
    var change = new ldap.Change({
        operation: 'add',
        modification: {
            memberUid: uid
        }
    });

    client.modify(`cn=${cn},dc=utdmaker,dc=space`, change, (err) => {
        console.log(err == null ? "" : err );
    })
}