theater.controller.js 2.62 KB
Newer Older
Kim, Subin's avatar
Kim, Subin committed
1
import { Theater, TheaterType } from "../db/index.js";
2
3

const getTheaterInfo = async (req, res) => {
Jiwon Yoon's avatar
Jiwon Yoon committed
4
    const { theaterName } = req.body
5
6
    try {
        const theaterInfo = await Theater.findOne({
Jiwon Yoon's avatar
Jiwon Yoon committed
7
8
            where: { theaterName: String(theaterName) },
            attributes: ['theaterName', 'rows', 'columns']
9
10
11
        })
        // console.log("theaterInfo====",theaterInfo)
        return res.json(theaterInfo)
Jiwon Yoon's avatar
Jiwon Yoon committed
12
13
14
15
    } catch (error){
        console.log(error)
    }
}
Kim, Subin's avatar
theater    
Kim, Subin committed
16
17
const getAll = async (req, res) => {
    try {
Kim, Subin's avatar
Kim, Subin committed
18
        const findList = await Theater.findAll({ attributes: { exclude: ['createdAt', 'updatedAt'] }, include: [ TheaterType ], order: [['theaterName']] })
Kim, Subin's avatar
theater    
Kim, Subin committed
19
        return res.json(findList)
20
21
22
23
24
    } catch (error) {
        return res.status(500).send(error.message || "상영관 정보 가져오는 중 에러 발생")
    }
}

Kim, Subin's avatar
Kim, Subin committed
25
26
27
28
29
30
31
32
33
34
35
const getOne = async (req, res) => {
    try {
        const { theaterId } = req.params
        const find = await Theater.findOne({ where: { id: theaterId } , attributes: { exclude: ['createdAt', 'updatedAt'] } })
        if (!find) throw new Error("해당 정보를 찾지 못했습니다.");
        return res.json(find)
    } catch (error) {
        return res.status(500).send(error.message || "상영관 정보 가져오는 중 에러 발생")
    }
}

Kim, Subin's avatar
theater    
Kim, Subin committed
36
37
const getTypes = async (req, res) => {
    try {
Kim, Subin's avatar
Kim, Subin committed
38
        const findTypes = await TheaterType.findAll({ attributes: { exclude: ['createdAt', 'updatedAt'] } })
Kim, Subin's avatar
theater    
Kim, Subin committed
39
40
41
42
43
44
45
46
        return res.json(findTypes)
    } catch (error) {
        return res.status(500).send(error.message || "상영관 정보 가져오는 중 에러 발생")
    }
}

const submit = async (req, res) => {
    try {
Kim, Subin's avatar
Kim, Subin committed
47
        const { id, theatertypeId, theaterName, rows, columns } = req.body
Kim, Subin's avatar
theater    
Kim, Subin committed
48
        let response = null
Kim, Subin's avatar
Kim, Subin committed
49
50
        if (id) response = await Theater.update({ theatertypeId, theaterName, rows, columns }, { where: { id: id } })
        else response = await Theater.create({ theatertypeId, theaterName, rows, columns })
Kim, Subin's avatar
theater    
Kim, Subin committed
51
52
53
54
55
56
57
58
        return res.json(response)
    } catch (error) {
        return res.status(500).send(error.message || "상영관 정보 저장 중 에러 발생")
    }
}

const remove = async (req, res) => {
    try {
Kim, Subin's avatar
Kim, Subin committed
59
60
61
62
        const { theaterId } = req.params
        const delNum = await Theater.destroy({ where: { id: theaterId } })
        if (delNum) res.json(delNum)
        else throw new Error("해당 정보를 서버에서 삭제하는데 실패했습니다.");
Kim, Subin's avatar
theater    
Kim, Subin committed
63
64
65
66
67
68
69
    } catch (error) {
        return res.status(500).send(error.message || "상영관 정보 삭제 중 에러 발생")
    }
}

export default {
    getAll,
Kim, Subin's avatar
Kim, Subin committed
70
    getOne,
Kim, Subin's avatar
theater    
Kim, Subin committed
71
72
    getTypes,
    submit,
Jiwon Yoon's avatar
Jiwon Yoon committed
73
74
75
    remove,
    getTheaterInfo
}