LineSong_Web/usersRouter.js at main · LineSong/LineSong_Web · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
const express = require('express');
const userDBC = require('./usersDBC');
const router = express.Router();


function formatDateTime(dateTimeString) {
    const date = new Date(dateTimeString);

    const year = date.getFullYear();
    const month = String(date.getMonth() + 1).padStart(2, '0'); // 월은 0부터 시작하므로 +1
    const day = String(date.getDate()).padStart(2, '0');
    const hours = String(date.getHours()).padStart(2, '0');
    const minutes = String(date.getMinutes()).padStart(2, '0');
    const seconds = String(date.getSeconds()).padStart(2, '0');

    return `${year}-${month}-${day} ${hours}:${minutes}:${seconds}`;
}

function formatRecipt(Receipt){
    let ReceiptRes;
    if (Receipt === null) {
        ReceiptRes = "대기";  // You can change this to whatever suits your needs
    } else if (Receipt === 1) {
        ReceiptRes = "완료";
    } else if (Receipt === 0) {
        ReceiptRes = "불가";
    }

    return ReceiptRes;
}

router.get('/getUsers', async (req, res)=>
{
    let res_get_users =
    {
        status_code : 500,
        users : []
    };

    try
    {
        const rows = await userDBC.getUsers(); // DB에서 데이터 가져옴
        res_get_users.status_code = 200;
        if(rows.length > 0)
        {
            rows.forEach((user)=>
            {
                res_get_users.users.push
                ({
                    Alphabet : user.Alphabet,
                    ID : user.ID,
                    Major : user.Major,
                    Name : user.Name,
                    Time : formatDateTime(user.Time),
                    Membership : user.Membership,
                    NUID : user.NUID,
                    Receipt :formatRecipt(user.Receipt),
                });
            });
        }
        else
        {
            console.log('사용자 없음');
        }
    }
    catch(error)
    {
        console.log(error.message);
    }
    finally
    {
        res.json(res_get_users);
    }
});

router.post('/Received/:ID', async (req, res) => {
    const res_signup = {
        status_code: 500
    };

    try {
        const userId = req.params.ID;  // URL에서 사용자 ID를 가져옴
        const rows = await userDBC.Received(userId);

        if (rows.affectedRows > 0) {
            res_signup.status_code = 200;
        } else {
            res_signup.status_code = 201;
        }
    } catch (err) {
        console.log(err.message);
    } finally {
        res.json(res_signup);
    }
});

router.post('/NotReceived/:ID', async (req, res) => {
    const res_signup = {
        status_code: 500
    };

    try {
        const userId = req.params.ID;  // URL에서 사용자 ID를 가져옴
        const rows = await userDBC.NotReceived(userId);

        if (rows.affectedRows > 0) {
            res_signup.status_code = 200;
        } else {
            res_signup.status_code = 201;
        }
    } catch (err) {
        console.log(err.message);
    } finally {
        res.json(res_signup);
    }
});


// router.post('/insertUser', async(req, res)=>{
//     const res_signup = {
//         status_code : 500
//     };

//     try{
//         const {Id, Major, Name, Time} =  req.body;
//         const rows = await userDBC.insertUser([Id, Major, Name, Time]);
//         if(rows.affectedRows > 0){
//             res_signup.status_code = 200;
//         }else{
//             res_signup.status_code = 201;
//         }
//     }catch(err)
//     {
//         console.log(err.message);
//     }finally{
//         res.json(res_signup);
//     }
// });

// router.post('/deleteUser', async(req, res)=>{
//     const res_delete_user = {
//         status_code : 500
//     };

//     try{
//         const {Id} =  req.body;
//         const rows = await userDBC.deleteUser([Id]);
//         if(rows.affectedRows > 0){
//             res_delete_user.status_code = 200;
//         }else{
//             res_delete_user.status_code = 201;
//         }
//     }catch(err)
//     {
//         console.log(err.message);
//     }finally{
//         res.json(res_delete_user);
//     }
// });

// router.post('/updateUser', async(req, res)=>{
//     const res_update_user = {
//         status_code : 500
//     };

//     try{
//         const {Id, Major, Name, Time} =  req.body;
//         const rows = await userDBC.updateUser(Id, Major, Name, Time);
//         if(rows.affectedRows > 0){
//             res_update_user.status_code = 200;
//         }else{
//             res_update_user.status_code = 201;
//         }
//     }catch(err)
//     {
//         console.log(err.message);
//     }finally{
//         res.json(res_update_user);
//     }
// });

module.exports = router; // 이 라우터를 외부로 보냄