From 3a06e3121dd540e7c26fa691b967717a9300731a Mon Sep 17 00:00:00 2001
From: alex <alex@alexloehr.net>
Date: Fri, 11 Jul 2025 08:14:01 +0000
Subject: [PATCH] adding tn by rolle
---
app.js | 43 +++++++++++++++++++++++++++++++++++++++++++
1 files changed, 43 insertions(+), 0 deletions(-)
diff --git a/app.js b/app.js
index d4cc17b..e565153 100644
--- a/app.js
+++ b/app.js
@@ -36,6 +36,7 @@
/////// SEARCH ////////////////////////////////////////////////////////////////
const searchLib = require("./lib/search")
+const {setStatus} = require("./lib/db")
searchLib.doIndex().catch(console.error)
fastify
.get("/api/search/user", async function (req, res) {
@@ -195,6 +196,22 @@
return res.code(404).send({status: "error", msg: "not found"})
}
})
+ .get("/api/kurs/:refId/teilnehmerByRole", async function (req, res) {
+ const {refId} = req.params
+ const {obj_id} = await db.getObjIdFromRefId(refId)
+ let data = await db.getKursTeilnehmerByRole(obj_id)
+ return res.send(data)
+ })
+ .get("/api/kurs/:refId/teilnehmer/:userId", async function (req, res) {
+ const {refId, userId} = req.params
+ let data = await db.getSingleKursTeilnehmer(refId, userId)
+ if (data) {
+ return res.send(data)
+ }
+ else {
+ return res.code(404).send({status: "error", msg: "not found"})
+ }
+ })
// .get("/api/kurs/:refId/teilnehmer/count", async function (req, res) {
// const {refId} = req.params
// let data = await db.getKursTeilnehmerCount(refId)
@@ -206,6 +223,32 @@
// }
// })
+ /** set passed and status for a kurs TN */
+ .post("/api/kurs/:refId/status/:usrId", async function (req, res) {
+ const {refId, usrId} = req.params
+ const {passed, status} = req.body
+ // console.log(88888888888888888888, {refId, usrId, passed, status})
+ if (!refId || !usrId || _.isNil(passed) || _.isNil(status)) {
+ throw {
+ statusCode: 400,
+ status: "error",
+ msg: "argument error"
+ }
+ }
+ try {
+ const {obj_id: course_id} = await db.getObjIdFromRefId(refId)
+ const data = await setStatus(course_id, usrId, passed, status)
+ return res.send(data)
+ } catch (ex) {
+ console.error(ex)
+ const msg = ex.msg ?? ex.message ?? ex.toString()
+ if (ex.statusCode) {
+ return res.code(ex.statusCode).send({status: "error", msg, statusCode: ex.statusCode})
+ }
+ return res.code(500).send({status: "error", msg})
+ }
+ })
+
.delete("/api/kurs/:refId/teilnehmer/:usrId", async function (req, res) {
const {refId, usrId} = req.params
if (!refId || !usrId) throw {status: "error", msg: "refId and usrId requried"}
--
Gitblit v1.8.0