<%@ page contentType="text/html; charset=utf-8" %><%@ include file="init.jsp" %><%

//객체
MCal cal = new MCal();
HstvScheduleDao schedule = new HstvScheduleDao();
BoardDao board = new BoardDao();
PostDao post = new PostDao();
HolidayDao holiday = new HolidayDao();

String date = (!"".equals(f.get("s_date")) ? f.get("s_date") : m.time("yyyyMM")) + "01";
String lastDate = m.time("yyyyMMdd", cal.getMonthLastDate(date));
String d = m.rs("d", m.time("yyyy-MM-dd", date));
String pDate = m.time("yyyyMM", m.addDate("M", -1, m.time("yyyyMMdd", d)));
String nDate = m.time("yyyyMM", m.addDate("M", 1, m.time("yyyyMMdd", d)));

//목록
DataSet scheduleList = schedule.find("site_id = " + siteId + " AND schedule_date BETWEEN '" + date + "' AND '" + lastDate + "' AND status = 1", "*", "id ASC, schedule_date ASC");
Hashtable<String, DataSet> hashSchedule = new Hashtable<String, DataSet>();
while(scheduleList.next()) {
	scheduleList.put("cal_img_block", !"".equals(scheduleList.s("cal_img")));
	scheduleList.put("cal_img_url", !"".equals(scheduleList.s("cal_img")) ? m.getUploadUrl(scheduleList.s("cal_img")) : "");
	//공개여부
	if("".equals(scheduleList.s("start_date")) && "".equals(scheduleList.s("end_date"))) {
		scheduleList.put("ing_block", true);

	} else {
		if(!"".equals(scheduleList.s("start_date")) && !"".equals(scheduleList.s("end_date"))) {
			if(m.diffDate("S", scheduleList.s("start_date") , m.time("yyyyMMddHHmmss")) >= 0 && m.diffDate("S", m.time("yyyyMMddHHmmss"), scheduleList.s("end_date")) >= 0) {
				scheduleList.put("ing_block", true);
			} else {
				if(m.diffDate("S", scheduleList.s("start_date") , m.time("yyyyMMddHHmmss")) < 0) { scheduleList.put("01_block", true); }
				if(m.diffDate("S", m.time("yyyyMMddHHmmss"), scheduleList.s("end_date")) < 0) { scheduleList.put("02_block", true); }
				scheduleList.put("ing_block", false);
			}
		} else if(!"".equals(scheduleList.s("start_date")) && "".equals(scheduleList.s("end_date"))) {
			if(m.diffDate("S", scheduleList.s("start_date") , m.time("yyyyMMddHHmmss")) < 0) { 
				scheduleList.put("01_block", true);
				scheduleList.put("ing_block", false);
			} else {
				scheduleList.put("ing_block", true);
			}
		} else if("".equals(scheduleList.s("end_date")) && !"".equals(scheduleList.s("end_date"))) {
			if(m.diffDate("S", m.time("yyyyMMddHHmmss"), scheduleList.s("end_date")) < 0) { 
				scheduleList.put("02_block", true);
				scheduleList.put("ing_block", false);
			} else {
				scheduleList.put("ing_block", true);
			}
		}
	}

	DataSet tmp = new DataSet();
	tmp.addRow(scheduleList.getRow());

	if(!hashSchedule.containsKey(scheduleList.s("schedule_date"))) {
		hashSchedule.put(scheduleList.s("schedule_date"), tmp);
	}
}

DataSet list = cal.getMonthDays(d);
int i = 0, size = list.size();
while(list.next()) {

	list.put("subject_conv", "");
	list.put("youtube_block", false);
	list.put("url", "");
	list.put("on", "");
	list.put("cal_img_url", "");
	list.put("cal_img_block", false);
	list.put("list_block", false);
	list.put("ing_block", false);
	list.put("01_block", false);
	list.put("02_block", false);
	list.put("holiday_block", false);
	list.put("holiday_subject", "");

	DataSet tmp = hashSchedule.containsKey(list.s("date").replace("-", "")) ? hashSchedule.get(list.s("date").replace("-", "")) : null;
	if(tmp != null) {

		list.put("subject_conv", m.cutString(tmp.s("subject"), 30));
		list.put("youtube_block", true);
		list.put("on", "on");
		list.put("url", tmp.s("url"));
		list.put("cal_img_url", tmp.s("cal_img_url"));
		list.put("cal_img_block", tmp.s("cal_img_block"));
		list.put("ing_block", tmp.s("ing_block"));
		list.put("01_block", tmp.s("01_block"));
		list.put("02_block", tmp.s("02_block"));
		list.put("list_block", schedule.findCount("site_id = " + siteId + " AND schedule_date = '" + list.s("date").replace("-", "") + "' AND status = 1") > 1);
	}

	if(holiday.findCount("date ='" + list.s("date").replace("-", "") + "' AND status != -1") > 0) {
		DataSet holidayInfo = holiday.find("date ='" + list.s("date").replace("-", "") + "' AND status != -1");
		if(holidayInfo.next()) {
			list.put("holiday_block", true);
			list.put("holiday_subject", holidayInfo.s("subject"));
		}
	}

	i++;
	list.put("1_block", false);
	list.put("2_block", false);
	list.put("3_block", false);
	list.put(list.s("type") + "_block", true);

	list.put("day", list.b("2_block") ? m.time("d", list.s("date")) : "");
	list.put("tr", list.i("weeknum") == 7 && i < size ? "</tr><tr>" : "");
	list.put("date_conv", list.s("date").replace("-", ""));
}

//갤러리형 목록
ListManager lm = new ListManager();
lm.setRequest(request);
lm.setListNum(9);
lm.setTable(schedule.table + " a ");
lm.setFields("a.*");
lm.addWhere("a.status = 1");
lm.addWhere("a.site_id = " + siteId);
lm.addWhere("a.schedule_date <= '" + m.time("yyyyMMdd") + "'");
lm.setOrderBy("a.schedule_date DESC");

//포매팅
DataSet glist = lm.getDataSet();
while(glist.next()) {
	glist.put("youtube_block", !"".equals(glist.s("url")));
	glist.put("hour_block", glist.i("hour") != 0);
	glist.put("minute_block", glist.i("minute") != 0);
	glist.put("hstv_img_url", !"".equals(glist.s("hstv_img")) ? m.getUploadUrl(glist.s("hstv_img")) : "");
	glist.put("schedule_date_conv", m.time("yyyy.MM.dd", glist.s("schedule_date")));

	//공개여부
	if("".equals(glist.s("start_date")) && "".equals(glist.s("end_date"))) {
		glist.put("ing_block", true);

	} else {
		if(!"".equals(glist.s("start_date")) && !"".equals(glist.s("end_date"))) {
			if(m.diffDate("S", glist.s("start_date") , m.time("yyyyMMddHHmmss")) >= 0 && m.diffDate("S", m.time("yyyyMMddHHmmss"), glist.s("end_date")) >= 0) {
				glist.put("ing_block", true);
			} else {
				if(m.diffDate("S", glist.s("start_date") , m.time("yyyyMMddHHmmss")) < 0) { glist.put("01_block", true); }
				if(m.diffDate("S", m.time("yyyyMMddHHmmss"), glist.s("end_date")) < 0) { glist.put("02_block", true); }
				glist.put("ing_block", false);
			}
		} else if(!"".equals(glist.s("start_date")) && "".equals(glist.s("end_date"))) {
			if(m.diffDate("S", glist.s("start_date") , m.time("yyyyMMddHHmmss")) < 0) { 
				glist.put("01_block", true);
				glist.put("ing_block", false);
			} else {
				glist.put("ing_block", true);
			}
		} else if("".equals(glist.s("end_date")) && !"".equals(glist.s("end_date"))) {
			if(m.diffDate("S", m.time("yyyyMMddHHmmss"), glist.s("end_date")) < 0) { 
				glist.put("02_block", true);
				glist.put("ing_block", false);
			} else {
				glist.put("ing_block", true);
			}
		}
	}
}


//한솔티비 공지사항
DataSet noticeList = post.query(
	"SELECT p.* "
	+ " FROM " + board.table + " a "
	+ " INNER JOIN " + post.table + " p ON a.id = p.board_id AND p.status = 1 AND p.depth = 'A' "
	+ " WHERE a.code = 'hstvnotice' AND a.site_id = " + siteId + " AND p.display_yn = 'Y'"
	+ " ORDER BY p.reg_date DESC, p.thread ASC, p.depth ASC "
	,5
);

while(noticeList.next()) {
	noticeList.put("reg_date_conv", m.time("yyyy.MM.dd", noticeList.s("reg_date")));
}

//출력
p.setLayout("hstv");
p.setBody("hstv.hstv");
p.setVar("query", m.qs("s_date"));
p.setVar("type_query", m.qs("type"));

p.setVar("p_name", siteId == 94 ? "" : "한솔TV");
p.setVar("p_subname", siteId == 94 ? "" : "한솔TV");

p.setLoop("list", list);
p.setVar("n_date", nDate);
p.setVar("p_date", pDate);
p.setVar("select_date", m.time("yyyy", date) + "년 " + m.time("MM", date) + "월 특강일정");
//p.setVar("s_date", date);

p.setLoop("notice_list", noticeList);

p.setLoop("glist", glist);
p.setVar("pagebar", lm.getPaging());
p.setVar("type", m.rs("type", "c"));

p.display();

%>