timetable.controller.js

import { TimeTable } from "../db/index.js";
import sequelize from 'sequelize'
const { Op } = sequelize

const submit = async (req, res) => {
    try {
        console.log("req.body==", req.body)
        const { theater, runtime } = req.body
        const result = theater.filter(async (theater) => {
            const startDate = getDate(theater.start)
            const endDate = getDate(theater.start, runtime)
            // const isTimeTable = await TimeTable.findAll({
            //     where: {
            //         [Op.and]: [
            //             { theater: theater.theater },
            //             {
            //                 [Op.and]: [
            //                     { start_date: { [Op.lte]: endDate } },
            //                     { end_date: { [Op.gte]: startDate } }
            //                 ]
            //             }
            //         ]
            //     }
            // })
            // [Op.or]: [{ [Op.and]: [{ start_date: { [Op.gt]: startDate } }, { start_date: { [Op.gt]: endDate } }] },
            // { [Op.and]: [{ end_date: { [Op.lt]: startDate } }, { end_date: { [Op.lt]: endDate } }] }]
            console.log("isTimeTable==", isTimeTable)
            return isTimeTable
        })
        console.log("result==", result)
    } catch (error) {
        return res.status(500).send(error.message || "상영시간표 저장 중 에러 발생")
    }
}

const getDate = (string, runtime = 0) => {
    const arr = string.split(':')
    const date = new Date(0, 0, 0, Number(arr[0]), Number(arr[1]) + runtime)
    // console.log("custom==", date.toString())
    return date
}

export default {
    submit
}