<?

//
//　斉藤美術館お知らせ表示
//


///////////////////////////////////////////////////////////////////////////
//	Encording
///////////////////////////////////////////////////////////////////////////
//header("Content-Type: text/plain; charset=EUC-JP");


/* 内部文字エンコーディングをSJISに設定 */
//mb_internal_encoding('EUC-JP');
//mb_regex_encoding('EUC-JP');
//mb_http_output('EUC-JP');


/* 配列で検出順を設定 */
$ary[] = 'SJIS';
$ary[] = 'JIS';
$ary[] = 'EUC-JP';
$ary[] = 'UTF-8';
$ary[] = 'ASCII';
mb_detect_order($ary);

///////////////////////////////////////////////////////////////////////////

//require_once '/usr/local/lib/php/Smarty/Smarty.class.php';
require_once '../Smarty/libs/Smarty.class.php';

///////////////////////////////////////////////////////////////////////////

//DB接続文字列
define("DBCONNECTSTRING","host=localhost dbname=autoupdate_db port=5432 user=autoupdate password=7f1AVGcl options='--client_encoding=EUC_JP'");

///////////////////////////////////////////////////////////////////////////

//IMAGE PATH
define("IMAGEDIR","images/");
define("TOPICSINITIAL","topics");
define("TOPICSIMAGEDIR","img/topics/");
define("SITECD","16");
///////////////////////////////////////////////////////////////////////////

//データベースコネクション
$con = pg_connect(DBCONNECTSTRING);
$thistime = time();

///////////////////////////////////////////////////////////////////////////
//Smarty
$tmp = new Smarty;

///////////////////////////////////////////////////////////////////////////
$data = array();
$list = isset($_GET['list']) ? $_GET['list'] : NULL;
$cd   = isset($_GET['cd']) ? $_GET['cd'] : NULL;


if($list == "") { 
	$data['time'] = date("Y",$thistime);
} else {
	$data['time'] = $list;
}

if($list == "") {
	$list =  date("Y",$thistime);
}

$data['nextyear'] = $list + 1;
$data['lastyear'] = $list - 1;
$data['nextyearflg'] = false;
$data['lastyearflg'] = false;
$data['max'] = 5;

///////////////////////////////////////////////////////////////////////////

$sql = "SELECT * FROM Tbl_Contents WHERE (flg <> '1' OR flg IS NULL) and site_cd =" . SITECD . " ORDER BY run DESC,cd DESC";
$result = pg_exec($sql);

if(pg_numrows($result) != 0){
	
	$events = pg_fetch_all($result);
	$j = $k = 0;
	for($i =0;$i < count($events) ;$i++){
		
		if($events[$i]['runstart'] != "") {
			$startdate = explode('-',$events[$i]['runstart']);
			$startdate2 = mktime(0,0,0,$startdate[1],$startdate[2],$startdate[0]);
		} else {
			$startdate  = 0;
			$startdate2 = 0;
		}
		
		if($events[$i]['runend'] != "") {
			$enddate = explode('-',$events[$i]['runend']);
			$enddate2 = mktime(0,0,0,$enddate[1],$enddate[2] + 1,$enddate[0]);
		} else {
			$enddate  = 0;
			$enddate2 = 0;
		}
			
		if(($events[$i]['runstart'] == '' || $thistime > $startdate2) &&
			($events[$i]['runend'] == '' || $thistime < $enddate2) ){
//---------------------------------------------------------------------------

			$topicsdate = explode('-',$events[$i]['run']);
			$topicsdate1[$i] = mktime(0,0,0,$topicsdate[1],$topicsdate[2],$topicsdate[0]);
			$topicsdate2[$i] = date("Y.n.j",$topicsdate1[$i]);
			$topicsdate3[$i] = date("Y",$topicsdate1[$i]);
			
			//年別リスト
			
			if($topicsdate3[$i] == $list){
				$data['listcd'][$j] = $events[$i]['cd'];
				$data['listrun'][$j] = $topicsdate2[$i];
				$data['listtitle'][$j] = $events[$i]['title1'];
				$j++;
			}
			
			
			if($list != "" && $topicsdate3[$i] == $data['nextyear']){
				$data['nextyearflg'] = true;
			}
			
			if($list != "" && $topicsdate3[$i] == $data['lastyear']){
				$data['lastyearflg'] = true;
			}
			
				
				//個別記事
				if($cd == $events[$i]['cd']){
					$data['run'] = $topicsdate2[$i];
					$data['title'] = $events[$i]['title1'];
					$data['msg'] = nl2br($events[$i]['msg1']);
					$data['alt'] = $events[$i]['title1'];
					$data['link'] = $events[$i]['link1'];
					if($events[$i]['image']){$data['image'] = 'http://ad.appa-net.com/'.TOPICSIMAGEDIR.$events[$i]['image'];	}
					if($events[$i]['image2']){$data['image2'] = 'http://ad.appa-net.com/'.TOPICSIMAGEDIR.$events[$i]['image2'];	}
					if($events[$i]['image3']){$data['image3'] = 'http://ad.appa-net.com/'.TOPICSIMAGEDIR.$events[$i]['image3'];	}
				}
				
				//トップ記事
				elseif($cd == "" && $k == 0 && $list == ""){
					$k++;
					$data['cd'] = $events[$i]['cd'];
					$data['run'] = $topicsdate2[$i];
					$data['title'] = $events[$i]['title1'];
					$data['msg'] = nl2br($events[$i]['msg1']);
					$data['msg'] = nl2br($events[$i]['msg1']);
					$data['alt'] = $events[$i]['title1'];
					$data['link'] = $events[$i]['link1'];
					if($events[$i]['image']){$data['image'] = 'http://ad.appa-net.com/'.TOPICSIMAGEDIR.$events[$i]['image'];	}
					if($events[$i]['image2']){$data['image2'] = 'http://ad.appa-net.com/'.TOPICSIMAGEDIR.$events[$i]['image2'];	}
					if($events[$i]['image3']){$data['image3'] = 'http://ad.appa-net.com/'.TOPICSIMAGEDIR.$events[$i]['image3'];	}
				}
//---------------------------------------------------------------------------
		}
	}
	$data['loop'] = $j;
	$data['list'] = $list;
	
	$tmp->assign("cgi_url",$_SERVER['PHP_SELF']);
	$tmp->assign("data",$data);

	if($k != "" || $cd != ""){
		$tmp->display("topics.html");
	}
	elseif($list != ""){
		$tmp->display("list.html");
	}
	pg_close();
}

?>