Challenge_Contest/routes/router.js

var express = require('express');
var router = express.Router();
var mysql = require('../model/mysql');
const _mysqluser = ["183.36.25.93", "registration"]; //用戶數據庫信息
const crypto = require('crypto');

router.route('/user').post(async function (req, res) {
    const signUpData = [];
    const reqData = req.body;
    console.log("用户报名数据：", reqData);
    signUpData.unshift(_mysqluser[0], _mysqluser[1], "insert_registrations",  reqData.uploadUrl, "",reqData.type,reqData.idCard);
    let insertSign = await mysql.usselect(signUpData, function (data) {
        console.log("signUpData", data);
    });
    const uuid = crypto.randomUUID();

    let userData = JSON.parse(reqData.user);
    console.log("userData",userData);
    const insertUser = await userData.map(item => {
        const userList = [];
        userList.unshift(_mysqluser[0], _mysqluser[1], "insert_registration_users", item.name, item.gender, item.ethnicity, item.birthdate, item.email, item.id_number, item.group, item.grade, item.school, item.schoolRegion, item.phone, uuid);
        mysql.usselect(userList, function (data) {
            console.log("insertUser", data);
        });
    });
    console.log("用户报名成功", insertUser,insertSign);
    res.send({ status: 'ok', message: '用户报名成功' });
});



module.exports = router;