peerasak-u · May 14, 2020 02:25 · peerasak-u · May 13, 2020
diff --git a/showtimefilter.js b/showtimefilter.js
 const getShowtimes = () => {
    const spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
    const range = spreadsheet.getSheetByName('ShowTime').getRange('A2:D');
    const values = range.getValues();
    const showtimes = values.filter((val) => val[0]).map(mappingShowTime);

    const incoming = showtimes.filter(isIncoming)
    const showing = showtimes.filter(isShowing)
    const alreayShown = showtimes.filter(wasAlreadyShown)

    return {
        incoming,
        showing,
        alreayShown
    }
 }

 const mappingShowTime = (item) => {
    const now = new Date();
    const hours = now.getHours();
    const mins = now.getMinutes();
    const year = now.getFullYear();
    const month = now.getMonth();  
    const day = now.getDate();
    const time = now.getTime();
      
    const startDate = new Date(item[1]);
    const endDate = new Date(item[2]);
    const sHours = startDate.getHours();
    const sMins = startDate.getMinutes();
      
    const eHours = endDate.getHours();
    const eMins = endDate.getMinutes();

    const startAt = new Date(year, month, day, sHours, sMins, 0 ,0);
    const endAt = new Date(year, month, day, eHours, eMins, 0 ,0);
      
    return {
            agenda: item[0],
            startAt,
            endAt,
            speaker: item[3]
    }
 }
      
 const isIncoming = (showtime) => {
    const now = new Date();
    const time = now.getTime();
    const startTime = showtime.startAt.getTime();
  
    return time < startTime
 }

 const isShowing = (showtime) => {
    const now = new Date();
    const time = now.getTime();
  
    const startTime = showtime.startAt.getTime();
    const endTime = showtime.endAt.getTime();  
  
    return time >= startTime && time <= endTime
 }

 const wasAlreadyShown = (showtime) => {
    const now = new Date();
    const time = now.getTime();
    const endTime = showtime.endAt.getTime();  
  
    return time > endTime
 }

 const doGet = () => {
    const showtimes = getShowtimes()
    return ContentService.createTextOutput(JSON.stringify(showtimes));
 }
	const getShowtimes = () => {
	const spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
	const range = spreadsheet.getSheetByName('ShowTime').getRange('A2:D');
	const values = range.getValues();
	const showtimes = values.filter((val) => val[0]).map(mappingShowTime);

	const incoming = showtimes.filter(isIncoming)
	const showing = showtimes.filter(isShowing)
	const alreayShown = showtimes.filter(wasAlreadyShown)

	return {
	incoming,
	showing,
	alreayShown
	}
	}

	const mappingShowTime = (item) => {
	const now = new Date();
	const hours = now.getHours();
	const mins = now.getMinutes();
	const year = now.getFullYear();
	const month = now.getMonth();
	const day = now.getDate();
	const time = now.getTime();

	const startDate = new Date(item[1]);
	const endDate = new Date(item[2]);
	const sHours = startDate.getHours();
	const sMins = startDate.getMinutes();

	const eHours = endDate.getHours();
	const eMins = endDate.getMinutes();

	const startAt = new Date(year, month, day, sHours, sMins, 0 ,0);
	const endAt = new Date(year, month, day, eHours, eMins, 0 ,0);

	return {
	agenda: item[0],
	startAt,
	endAt,
	speaker: item[3]
	}
	}

	const isIncoming = (showtime) => {
	const now = new Date();
	const time = now.getTime();
	const startTime = showtime.startAt.getTime();

	return time < startTime
	}

	const isShowing = (showtime) => {
	const now = new Date();
	const time = now.getTime();

	const startTime = showtime.startAt.getTime();
	const endTime = showtime.endAt.getTime();

	return time >= startTime && time <= endTime
	}

	const wasAlreadyShown = (showtime) => {
	const now = new Date();
	const time = now.getTime();
	const endTime = showtime.endAt.getTime();

	return time > endTime
	}

	const doGet = () => {
	const showtimes = getShowtimes()
	return ContentService.createTextOutput(JSON.stringify(showtimes));
	}