<?php
	include "../../../../common.php";

	$tmenu_ = "학술"; // theme.menu.php 에서 세팅한 이 페이지의 대메뉴명을 입력합니다.
	$g5['title'] = "학술활동 프로그램"; //커스텀페이지의 타이틀을 입력합니다.
	$title_view = "no"; //항상 false 로 유지하십시오. 이 라인을 절대 수정,삭제 하지 마십시오.

	include_once(G5_THEME_PATH.'/head.php'); //그누보드의 공통 상단을 연결합니다.
	include_once('header.php'); //회사소개의 공통 상단을 연결합니다.

	$sql_common = " from c_program_ws ";
	
	$datetime = date("Y-m-d");
	
	$sql_search = " where flag = 1 and listup = 'Y' and period2 < '{$datetime}' and deleted='N' ";

	if ($stx) {
		$sql_search .= " and ( ";
		switch ($sfl) {
			default :
				$sql_search .= " ({$sfl} = '{$stx}') ";
				break;
		}
		$sql_search .= " ) ";
	}
	
	if (!$sst) {
		$sst = "period1";
		$sod = "desc";
	}
	
	$sql_order = " order by {$sst} {$sod} ";
	
	$sql = " select count(*) as cnt {$sql_common} {$sql_search} {$sql_order} ";
	$row = sql_fetch($sql);
	$total_count = $row['cnt'];
	
	$rows = 20;
	$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
	if ($page < 1) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
	$from_record = ($page - 1) * $rows; // 시작 열을 구함

	$sql = " select * {$sql_common} {$sql_search} {$sql_order} limit {$from_record}, {$rows} ";
	$result = sql_query($sql);
	
	$group_year_result = sql_query("select * {$sql_common} where flag = 1 and listup = 'Y' and period2 < '{$datetime}' group by year order by year desc ;");
?>


<div id="sub_tit">
	<div class="path">
		<li><a href="/"><span class="ic-home"><i></i></span></a></li>
		<li><?php echo lang($tmenu_)?></li>
		<li><?php echo lang($g5['title'])?></li>
	</div>
	<div class="title"><?php echo lang($tmenu_)?></div>
	<p class="normal_txt"></p>
</div>


	<section class="scontents">

		<?php
			include_once(G5_THEME_PATH.'/lnb.php');
		?>



		<div class="bg_vline"></div>
		<p class="eng"><?php echo lang("학술활동 프로그램"); ?></p>
		<p class="stitle"></p>

    <div class="top-cate type1">
      <ul class="tablize split">
        <li><a href="<?php echo G5_THEME_URL;?>/html/activities/01.php"><?php echo lang("학술활동 프로그램"); ?></a></li>
        <li class="on"><a href="<?php echo G5_THEME_URL;?>/html/activities/01-1.php"><?php echo lang("지난 학술활동 프로그램"); ?></a></li>
      </ul>
    </div>

    <div class="top-cate type3">
      <ul class="tablize split">
        <li <?php if(!$stx) { ?>class="on"<?php } ?>><a href="01-1.php">ALL</a></li>
        <?php for($i=0; $year=sql_fetch_array($group_year_result); $i++) { ?>
        <li <?php if($stx == $year['year']) { ?>class="on"<?php } ?>><a href="01-1.php?sfl=year&stx=<?php echo $year['year']; ?>"><?php echo $year['year']; ?></a></li>
        <?php } ?>
      </ul>
    </div>


    <div class="activities__listup">
      <ul>
        <?php
        for($i=0; $row=sql_fetch_array($result); $i++) {
        $addon2 = sql_fetch("select * from c_program_ws_addon where idproid = '{$row[idproid]}' and type = 'organizers' limit 1;");
        ?>		
        <li>
            <div class="activity__img">
		    <?php if($row['filename2']) { ?>
		    <a href="<?php echo G5_THEME_URL;?>/html/activities/activities01_read.php?id=<?php echo $row['id']; ?>&page=<?php echo $page; ?>"><img src="/data/upload/program/ws_poster_<?php echo sprintf("%07d",$row[id]); ?>" border="0" /></a>
            <?}?>
            </div>
            <div class="activity__title">  
            <p class="title"><b><a class="link" href="<?php echo G5_THEME_URL;?>/html/activities/activities01_read.php?id=<?php echo $row['id']; ?>&page=<?php echo $page; ?>" target="_self"><?php echo $row['title']; ?></a></b></p>
			<ul>
				<li>
					<p class="place"><span>Place</span><?php echo $row['location']; ?></p>
				</li>
				<li>
					<p class="date"><span>Date</span><?php echo $row['period1']; ?>~<?php echo $row['period2']; ?></p>
				</li>
				<li>
					<p class="program"><span>Program</span><?php echo $row['program']; ?></p>
				</li>
				<li>
				<p class="organizer"><span>Organizer</span><?php echo $addon2['firstname']; ?> <?php echo $addon2['middlename']; ?> <?php echo $addon2['lastname']; ?><?php if($addon2['affiliation']) { ?> (<?php echo $addon2['affiliation']; ?>)<?php } ?></p>
				</li>
			</ul>            
            </div>  
        </li>
      <?php } ?>
      <?php if($i==0) { ?>
      	  <li><p class="title"><?php echo lang("자료가 없습니다."); ?></p></li>
      <?php } ?> 
      </ul>
    </div>


  <center>
    <br><br><br>
    <?php echo get_paging(G5_IS_MOBILE ? $config['cf_mobile_pages'] : $config['cf_write_pages'], $page, $total_page, '?'.$qstr.'&amp;page='); ?> 
  </center>



	</section>



<?php
	include_once('tail.php'); //회사소개의 공통 하단을 연결합니다.
	include_once(G5_THEME_PATH.'/tail.php'); //그누보드의 공통 상단을 연결합니다.
?>
