69 lines
2.4 KiB
JavaScript
69 lines
2.4 KiB
JavaScript
const db = require("../models");
|
|
const API = require('../helper/API_Response');
|
|
const db_helper = require("../helper/db_helper");
|
|
const helper = require("../helper/helper");
|
|
const { Acronyms, Certificate } = require("../models");
|
|
|
|
exports.get_survey = async (req, res) => {
|
|
const input = await helper.decryptRequest(req.body.data);
|
|
var already = await db_helper.selectByWhere("TakeSurvey", {
|
|
user_id: input.user_id,
|
|
cohort_id: input.cohort_id,
|
|
});
|
|
res.status(200).send(API._200(await already));
|
|
};
|
|
exports.survey_domain = async (req, res) => {
|
|
const input = await helper.decryptRequest(req.body.data);
|
|
const result = await db.sequelize.query(
|
|
"select id,domin_name from domains where certi_id in(select certi_id from cohorts where id= :cohort_id)",
|
|
{ replacements: { cohort_id: input.cohort_id } }
|
|
)
|
|
.then(function (data) {
|
|
return Array.from(new Set(data));
|
|
});
|
|
res.status(200).send(API._200(await result));
|
|
};
|
|
exports.take_survey = async (req, res) => {
|
|
const input = await helper.decryptRequest(req.body.data);
|
|
var already = await db_helper.selectByWhere("TakeSurvey", {
|
|
user_id: input.user_id,
|
|
cohort_id: input.cohort_id,
|
|
});
|
|
if (already.length <= 0)
|
|
res.status(200).send(API._200(await db_helper.addData("TakeSurvey", input)));
|
|
else {
|
|
input.id = already[0].id;
|
|
res.status(200).send(API._200(await db_helper.update("TakeSurvey", input)));
|
|
}
|
|
};
|
|
exports.add = async (req, res) => {
|
|
const input = await helper.decryptRequest(req.body.data);
|
|
res.status(200).send(API._200(await db_helper.addData('Acronyms', input)));
|
|
};
|
|
exports.all = async (req, res) => {
|
|
const all = await Acronyms.findAll({
|
|
where: {
|
|
status: 0,
|
|
},
|
|
include: [{
|
|
model: Certificate,
|
|
attributes: ["id", "certificate_name"],
|
|
},
|
|
],
|
|
});
|
|
res.status(200).send(API._200(await all));
|
|
};
|
|
exports.byid = async (req, res) => {
|
|
const input = await helper.decryptRequest(req.body.data);
|
|
res.status(200).send(API._200(await db_helper.byId('Acronyms', input.id)));
|
|
};
|
|
exports.delete = async (req, res) => {
|
|
const input = await helper.decryptRequest(req.body.data);
|
|
res.status(200).send(API._200(await db_helper.statusChange('Acronyms', input.id)));
|
|
|
|
};
|
|
exports.update = async (req, res) => {
|
|
const input = await helper.decryptRequest(req.body.data);
|
|
res.status(200).send(API._200(await db_helper.update('Acronyms', input)));
|
|
};
|