stakeholder.js

const fs = require("fs");

module.exports = {
    loginStakeHolderPage: (req, res) => {
        res.render("login-StakeHolder.ejs", {
            title: "Welcome to Manak Art | Login as a StakeHolder",
            message: "",
        });
    },
    loginStakeHolder: (req, res) => {
        let entered_username = req.body.username;
        let entered_password = req.body.password;
        let loginquery =
            "SELECT * FROM stakeholders WHERE user_name = '" +
            entered_username +
            "' ";
        let message = "";
        db.query(loginquery, (err, result) => {
            if (err) {
                return res.status(500).send(err);
            }
            if (result.length > 0) {
                if (result[0].password == entered_password) {
                    req.session.userId = result[0].id;
                    console.log(req.route.path);
                    if (result[0].is_investor === 2) {
                        loadUserLoginDashboard(result[0], req.session.userId, res, true);
                    } else {
                        res.render("view-LoginResponsePage.ejs", {
                            title: "Welcome to Manak Art | Logon as a StakeHolder",
                            StakeHolder: result[0],
                            sessionId: req.session.userId,
                            message: "Login Successful",
                        });
                    }
                } else {
                    loadUserLoginDashboard("", req.session.userId, res, true);
                    res.render("view-LoginResponsePage.ejs", {
                        title: "Welcome to Manak Art | Logon as a StakeHolder",
                        StakeHolder: "",
                        message:
                            "Invalid user_name and/or password. Kindly enter valid user_name/password",
                    });
                }
            } else {
                loadUserLoginDashboard("", req.session.userId, res, true);
                // res.render('view-LoginResponsePage.ejs', {
                //  title: 'Welcome to Manak Art | Logon as a StakeHolder'
                //  ,StakeHolder: ''
                //  ,message: 'Invalid user_name and/or password. Kindly enter valid user_name/password'
                // });
            }
        });
    },
    registerStakeHolderPage: (req, res) => {
        res.render("register-StakeHolder.ejs", {
            title: "Welcome to Manak Art | Signup as a new StakeHolder",
            message: "Register as a new StakeHolder",
        });
    },
    registerStakeHolder: (req, res) => {
        let message = "";
        let entered_first_name = req.body.first_name;
        let entered_last_name = req.body.last_name;
        let entered_username = req.body.username;
        let entered_password = req.body.password;
        let entered_email = req.body.email;
        let entered_is_invester = 0;
        if (req.body.is_investor === "investor") {
            entered_is_invester = 1;
        } else if (req.body.is_investor === "config") {
            entered_is_invester = 2;
        }
        let loginPasswordValidateQuery =
            "SELECT * FROM `stakeholders` WHERE user_name = '" +
            entered_username +
            "'";

        db.query(loginPasswordValidateQuery, (err, result) => {
            if (err) {
                return res.status(500).send("error in query");
            }
            if (result.length > 0) {
                loadUserLoginDashboard("", req.session.userId, res, false);
                // message = 'StakeHolder already registered. Please retry again.';
                // res.render('register-StakeHolder.ejs', {
                //     message,
                //  StakeHolders: result,
                //     title: 'Welcome to Manak Art | Register as a new StakeHolder'
                // });
            } else {
                // if (req.body.is_investor === "investor") {
                //  entered_is_invester = 1;
                // } else if (req.body.is_investor === "config") {
                //  entered_is_invester = 2;
                // }
                // send the stake holder's details to the database
                let insert_query =
                    "INSERT INTO `stakeholders` (first_name, last_name, user_name, password, email, is_investor) VALUES ('" +
                    entered_first_name +
                    "', '" +
                    entered_last_name +
                    "', '" +
                    entered_username +
                    "', '" +
                    entered_password +
                    "', '" +
                    entered_email +
                    "', '" +
                    entered_is_invester +
                    "')";
                db.query(insert_query, (err, result) => {
                    if (err) {
                        return res.status(500).send("error in insert query");
                    }
                    let enteredRecordQuery =
                        "SELECT * FROM `stakeholders` WHERE user_name = '" +
                        entered_username +
                        "'";
                    db.query(enteredRecordQuery, (err, enteredRecordQuery) => {
                        if (err) {
                            return res.status(500).send("error query");
                        }
                        req.session.userId = enteredRecordQuery[0];

                        loadUserLoginDashboard(
                            enteredRecordQuery[0],
                            req.session.userId,
                            res,
                            false,
                        );
                        // if(enteredRecordQuery[0].is_investor === 1) {
                        //     res.render('investor', {
                        //         title: 'Welcome to Manak Art | Welcome Investor.'
                        //         ,StakeHolders: enteredRecordQuery
                        //         ,sessionId: req.session.userId
                        //         ,message: 'Welcome Investor!!'
                        //     });
                        // }
                        // else {
                        //     res.render('register-StakeHolderResponse', {
                        //         title: 'Welcome to Manak Art | StakeHolder successfully registered.'
                        //         ,StakeHolders: enteredRecordQuery
                        //         ,sessionId: req.session.userId
                        //         ,message: 'Stake Holder successfully registered :-)'
                        //     });
                        // }
                    });
                });
            }
        });
    },
    // editStakeHolderPage: (req, res) => {
    //  let stakeHolderId = req.params.id;
    //  let query =
    //      "SELECT * FROM `stakeholders` WHERE id = '" + stakeHolderId + "' ";
    //  db.query(query, (err, result) => {
    //      if (err) {
    //          return res.status(500).send(err);
    //      }
    //      res.render("edit-StakeHolder.ejs", {
    //          title: "Edit Stake Holder",
    //          StakeHolder: result[0],
    //          message: "",
    //      });
    //  });
    // },
    // infoPaintingPage: (req, res) => {
    // let painting_owner_id = req.params.owner_id;
    // let paint_id = req.params.painting_id;
    // //let query = "SELECT PaintersGallery.owner_id, PaintersGallery.painter_name, PaintersGallery.gallery_name, PaintersGallery.address, PaintingInfo.painting_id, PaintingInfo.painting_snapshot, PaintingInfo.painting_name, PaintingInfo.year_of_completion, PaintingInfo.medium_of_painting, PaintingInfo.painting_length, PaintingInfo.painting_width FROM `PaintersGallery` INNER JOIN `PaintingInfo` ON PaintersGallery.owner_id = PaintingInfo.owner_id AND PaintingInfo.painting_id = '" + paint_id + "' ";
    // let query = "SELECT * FROM `PaintersGallery` WHERE owner_id = '" + painting_owner_id + "' "
    // db.query(query, (err, result) => {
    // if (err) {
    // return res.status(500).send(err);
    // }
    // res.render('info-Painting.ejs', {
    // title: 'Painting Info'
    // ,_painting: result
    // ,message: 'Information on painting'
    // });
    // });
    // },
    // viewPaintingPage: (req, res) => {
    // let paint_id = req.params.painting_id;
    // let query = "SELECT  * FROM `PaintingInfo` WHERE painting_id = '" + paint_id + "' ";
    // db.query(query, (err, result) => {
    // if (err) {
    // return res.status(500).send(err);
    // }
    // //res.setHeader('Content-Type', 'text/html');
    // res.render('view-Painting.ejs', {
    // title: 'Painting View'
    // ,_painting: result
    // ,message: 'Painting View'
    // });
    // });
    // },
    // editStakeHolder: (req, res) => {
    //  //     let stakeHolderId = req.params.id;
    //  //   let first_name = req.body.first_name;
    //  //  let last_name = req.body.last_name;

    //  // let query = "UPDATE `StakeHolders` SET `first_name` = '" + first_name + "', `last_name` = '" + last_name + "' WHERE `stakeHolderId`.`id` = '" + stakeHolderId + "'";
    //  // db.query(query, (err, result) => {
    //  //   if (err) {
    //  //     return res.status(500).send(err);
    //  //  }
    //  res.redirect("/");
    //  //});
    // },
    logoutUser: (req, res) => {
        res.session.destroy(err => {
            if (err) {
                return res.redirect("/");
            }
            res.clearCookie(SESS_NAME);
            res.redirect("/login");
        });
    },
};

const loadUserLoginDashboard = (queryResult, sessionId, res, isLogin) => {
    let renderPage = "";
    let titleMessage = "Welcome to Manak Art | ";
    let messageTxt = "";
    if (sessionId) {
        if (queryResult.is_investor === 1) {
            renderPage += "dashboardArtInvestor";
            titleMessage += "Welcome Investor!!";
            messageTxt += "Welcome Investor!!";

        } else if (queryResult.is_investor === 2) {
            if (queryResult.user_name === "PaintingApprover") {
                renderPage += "approverPaintings";
                titleMessage += "Welcome Approver!!";
                messageTxt += "Welcome Approver!!";
            }
            else {
                renderPage += "dashboardDatabaseListing";
                titleMessage += "Welcome Admin!!";
                messageTxt += "Welcome Admin!!";
            }
        } else {
            renderPage += "dashboardArtFacilitator";
            titleMessage += "Welcome Art Facilitator!!";
            messageTxt += "Stake Holder successfully registered!!";
        }
    } else {
        sessionId = -1;
        renderPage += "view-LoginResponsePage.ejs";
        if (isLogin === true) {
            titleMessage += "Logon Screen";
            messageTxt = "Invalid user_name and/or password. Kindly enter valid user_name/password";
        } else {
            titleMessage += "Register Screen";
            messageTxt += "User already registered. Please retry again";
        }
    }

    res.render(renderPage, {
        title: titleMessage,
        StakeHolder: queryResult,
        sessionId: sessionId,
        message: messageTxt
    });
};