DistroHard/Controllers/editDBController.js

const {
    updateData,
    Processor,
    selectDataAllFiltr,
    Vendor,
    selectDataAll,
    selectDataOne,
    VideoCard,
    DistroLinux,
    ProcessorStatusOnLinux,
    VideoCardStatusOnLinux,
} = require("./dataBase");

function editProc(req, res) {
    const procID = req.params.procID;
    Vendor.findAll()
        .then((vendors) => {
            Processor.findOne({ where: { id: procID } }).then((proc) => {
                Vendor.findByPk(proc.vendor_id).then((vendor) => {
                    DistroLinux.findAll().then((linux) =>
                        res.render("Edit.hbs", {
                            obj: proc,
                            linux: linux,
                            vendor: vendors,
                            venID: vendor.companyName,
                        })
                    );
                });
            });
        })
        .catch((err) => console.log(err));
}
function editVideoCard(req, res) {
    const videoCardID = req.params.videoCardID;
    Vendor.findAll()
        .then((vendors) => {
            VideoCard.findOne({ where: { id: videoCardID } }).then(
                (videoCard) => {
                    Vendor.findByPk(videoCard.vendor_id).then((vendor) => {
                        DistroLinux.findAll().then((linux) =>
                            res.render("Edit.hbs", {
                                obj: videoCard,
                                linux: linux,
                                vendor: vendors,
                                venID: vendor.companyName,
                            })
                        );
                    });
                }
            );
        })
        .catch((err) => console.log(err));
}

function postEditProc(req, res) {
    if (!req.body) return res.sendStatus(400);
    console.log(req.body);
    console.log(req.params);
    Processor.update(
        {
            modelName: req.body.modelName,
            vendor_id: req.body.Vendor,
        },
        {
            where: {
                id: req.params.procID,
            },
        }
    )
        .then(() => {
            if (req.body.LinuxStatus !== null) {
                ProcessorStatusOnLinux.findOne({
                    where: {
                        Processor_id: req.params.procID,
                        DistLinux_id: req.body.linuxVendor,
                    },
                }).then((PSOL) => {
                    if (PSOL !== null) {
                        ProcessorStatusOnLinux.update(
                            { Status: req.body.linuxStatus },
                            {
                                where: {
                                    Processor_id: req.params.procID,
                                    DistLinux_id: req.body.linuxVendor,
                                },
                            }
                        );
                    } else {
                        ProcessorStatusOnLinux.create({
                            Processor_id: req.params.procID,
                            DistLinux_id: req.body.linuxVendor,
                            Status: req.body.linuxStatus,
                        });
                    }
                });
            }
        })
        .then(() => res.redirect("/dataBase/hards"));
}
function postEditVideoCard(req, res) {
    if (!req.body) return res.sendStatus(400);
    console.log(req.body);
    console.log(req.params);
    VideoCard.update(
        {
            modelName: req.body.modelName,
            vendor_id: req.body.Vendor,
        },
        {
            where: {
                id: req.params.videoCardID,
            },
        }
    )
        .then(() => {
            if (req.body.LinuxStatus !== null) {
                VideoCardStatusOnLinux.findOne({
                    where: {
                        VideoCard_id: req.params.videoCardID,
                        DistLinux_id: req.body.linuxVendor,
                    },
                }).then((PSOL) => {
                    if (PSOL !== null) {
                        VideoCardStatusOnLinux.update(
                            { Status: req.body.linuxStatus },
                            {
                                where: {
                                    VideoCard_id: req.params.videoCardID,
                                    DistLinux_id: req.body.linuxVendor,
                                },
                            }
                        );
                    } else {
                        VideoCardStatusOnLinux.create({
                            VideoCard_id: req.params.videoCardID,
                            DistLinux_id: req.body.linuxVendor,
                            Status: req.body.linuxStatus,
                        });
                    }
                });
            }
        })
        .then(() => res.redirect("/dataBase/hards"));
}

module.exports = {
    editProc,
    editVideoCard,
    postEditProc,
    postEditVideoCard,
};