Skip to content

Commit

Permalink
feat: implement editing assigned devs of tickets
Browse files Browse the repository at this point in the history
  • Loading branch information
ohjayho committed May 3, 2024
1 parent 4a2ea24 commit fde30c2
Showing 1 changed file with 8 additions and 8 deletions.
16 changes: 8 additions & 8 deletions backend/routes/ticket_devs.js
Original file line number Diff line number Diff line change
@@ -8,17 +8,16 @@ ticketDevsRouter.use(express.json());
ticketDevsRouter.use(cors());

ticketDevsRouter.get("/:ticket_id", (req, res) => {
const devs = `SELECT assigned_dev FROM ticket_devs WHERE ticket_id='${req.params.ticket_id}';`;
const devs = `SELECT * FROM users u JOIN ticket_devs td ON td.ticket_id='${req.params.ticket_id}' WHERE td.assigned_dev = u.id;`;
db.query(devs, (err, data) => {
if (err) return res.json(err);
return res.json(data);
});
});

ticketDevsRouter.post("/", (req, res) => {
const q = `INSERT INTO ticket_devs (ticket_id, assigned_dev) VALUES ?`;
const q = `INSERT IGNORE INTO ticket_devs (ticket_id, assigned_dev) VALUES ?`;
const devs = req.body;
console.log("devs", [devs]);
db.query(q, [devs], (err, data) => {
if (err) {
console.log(err);
@@ -29,12 +28,13 @@ ticketDevsRouter.post("/", (req, res) => {
console.log("devs added successfully!");
});

ticketDevsRouter.put("/:ticket_id", (req, res) => {
const devs = [req.body.map((dev) => dev[1])];
ticketDevsRouter.delete("/:ticket_id", (req, res) => {
const devs = req.body.map((dev) =>
JSON.stringify(dev[1]).replaceAll('"', "'")
);
const ticket_id = req.params.ticket_id;
const q = `UPDATE ticket_devs SET assigned_dev = '${devs}' WHERE ticket_id = '${ticket_id}'`;
console.log(q);
db.query(q, [devs], (err, data) => {
const q = `DELETE FROM ticket_devs WHERE ticket_id = '${ticket_id}' AND assigned_dev NOT IN (${devs})`;
db.query(q, (err, data) => {
if (err) {
console.log(err);
return res.json(err);

0 comments on commit fde30c2

Please sign in to comment.