<?PHP 
//*****************************************************************************
//* 
//* プログラム名：め〜るNiポン！V2
//* プログラムID：MAIN0000.php
//* 機能				：メイン
//* 
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");


include("./include/smarty.conf");
include("./include/session_start.inc");
include("./include/SessionChk.inc");

session_unregister("ADD_SYAIN_CD");


//表示名称を取得
//$strSQL = "SELECT disp_name FROM mst_disp WHERE disp_id = 1";
//$objRecSet = pg_exec($strSQL);
//if($objRecSet==false){
//    echo("SQL実行に失敗しました(SELECT)");
//    exit;
//}
//$objData = pg_fetch_object($objRecSet, 0);
//$stDisp_Name = mb_convert_encoding($objData->disp_name, "EUC-JP", "ASCII,JIS,UTF-8,EUC-JP,SJIS");

//********** ヘッダー処理 **********//
include("./include/headr_data.inc");

//********** カレンダー処理 **********//
include("./include/dbcon.inc");

$date = getdate();
$year = $date["year"];
$month = $date["mon"];
if ($month < 10){
	$month = "0".$month;
}
$day = $date["mday"];
if ($day < 10){
	$day = "0".$day;
}

$clender=array("#FDDFFD","#ccffcc","#ccffcc","#ccffcc","#ccffcc","#ccffcc","#CCF8FB","#FFFF66");
$schedule=array("#FDDFFD","#FFFFFF","#FFFFFF","#FFFFFF","#FFFFFF","#FFFFFF","#CCF8FB","#FFFF66");

//基準日取得
if(trim($main_year) == "" && trim($main_mon)=="" && trim($strMainDate)==""){
	$main_year=date("Y");
	$main_mon=date("n");
}else{
	if ($strMainDate!=""){
			$main_year=substr($strMainDate, 0, 4);
			$main_mon=substr($strMainDate, 4, 2);
	}
}

//*** 表示年 ***//
$Year_Data = "";
for ($intI = $main_year-1 ; $intI <= $main_year+1 ; $intI++) {
		$Year_Data .= "<option value=".$intI;
		if ($main_year==$intI){
				$Year_Data .= " selected";
		}
		$Year_Data .= ">".$intI."年</option>";
}
$o_smarty->assign('Year_Data',$Year_Data);


//*** 表示月 ***//
$Month_Data = "";
for ($intI = 1 ; $intI <= 12 ; $intI++) {
		$Month_Data .= "<option value=".sprintf('%02d', $intI);
		if ($main_mon == $intI){
				$Month_Data .= " selected";
		}
		$Month_Data .= ">".$intI."月</option>";
}
$o_smarty->assign('Month_Data',$Month_Data);

$strDispDate[0]=date("Ymd", mktime (0,0,0,$main_mon-1,"01",$main_year));
$strDispDate[1]=date("Y").date("m")."01";
$strDispDate[2]=date("Ymd", mktime (0,0,0,$main_mon+1,"01",$main_year));

$o_smarty->assign('Before_Month',$strDispDate[0]);
$o_smarty->assign('Now_Month'   ,$strDispDate[1]);
$o_smarty->assign('Next_Month'  ,$strDispDate[2]);

//*** カレンダー作成 ***/
//MAX日付取得
$main_day="01";
$dateMax=date("j", mktime (0,0,0,$main_mon+1,$main_day-1,$main_year));

//カレンダー空白数(前)
$intbefor=date("w", mktime (0,0,0,$main_mon,$main_day,$main_year));

//カレンダー空白数(後)
$intafter=date("w", mktime (0,0,0,$main_mon,$dateMax,$main_year));
$intafter=6-$intafter;

//ループ基準日取得
$strWkDate=date("Y/m/d", mktime (0,0,0,$main_mon,$main_day-$intbefor,$main_year));
list($chk_year,$chk_mon,$chk_day)=split("/", $strWkDate);

for($intCnt = 0; $intCnt < $intbefor+$dateMax+$intafter ; $intCnt++) {
		$strWkDate=date("Y/m/d", mktime (0,0,0,$chk_mon,$chk_day+$intCnt,$chk_year));
		$strcalender[$intCnt]=$strWkDate;
}

//テーブル作成
$strCalData = array();
$intRow     = 0;
$intCol     = 0;

$intKaigyo=6;
for($intI = 0; $intI < count($strcalender) ; $intI++) {
		list($chk_year,$chk_mon,$chk_day)=split("/", $strcalender[$intI]);
		$intYoubi=date("w", mktime (0,0,0,$chk_mon,$chk_day,$chk_year));

		//テーブル開始
		if (($intI % 7 == 0) && ($intI!=0)){
				$intRow = $intRow + 1;
				$intCol = 0;
		}

		//日付表示
		if ($chk_mon==$main_mon){
				//日付編集
				if (substr($chk_mon,0,1) == 0){
					$input_mon = substr($chk_mon,1,1);
				}else{
					$input_mon = $chk_mon;
				}
				if (substr($chk_day,0,1) == 0){
					$input_day = substr($chk_day,1,1);
				}else{
					$input_day = $chk_day;
				}
				$strCalData[$intRow][$intCol]  = $chk_day;
				//$strCalData[$intRow][$intCol] .= '&nbsp;<a href="#" onclick="return kojin_send('.$chk_year.$chk_mon.$chk_day.')"><img src="./img/icon_kojin.gif" alt="個人配信" border=0></a>';
				//$strCalData[$intRow][$intCol] .= '&nbsp;<a href="#" onclick="return group_send('.$chk_year.$chk_mon.$chk_day.')"><img src="./img/icon_ikkatu.gif" alt="一括配信" border=0></a>';
				$strCalData[$intRow][$intCol] .= '&nbsp;<a href="#" onclick="return mail_send('.$chk_year.$chk_mon.$chk_day.')"><img src="./img/icon_ikkatu.gif" alt="メール配信" border=0></a>';
				$strCalData[$intRow][$intCol] .= '<ul>';

				//*** め〜るNiポン！データ取得 ***
				$strSQL  = "SELECT ";
				$strSQL .= " mail_data.mail_id     , ";
				$strSQL .= " message_time, ";
				$strSQL .= " send_date   , ";
				$strSQL .= " subject_name, ";
				$strSQL .= " reserva_flg,   ";
				$strSQL .= " name50_nm   ";
				$strSQL .= "FROM ";
				$strSQL .= " mail_data  ";
				$strSQL .= "LEFT JOIN ";
				$strSQL .= " answer_data ";
				$strSQL .= "ON ";
				$strSQL .= " mail_data.mail_id = answer_data.mail_id ";
				$strSQL .= "WHERE  ";
				$strSQL .= " message_date = '".$chk_year.$chk_mon.$chk_day."' OR";
				$strSQL .= " (";
				$strSQL .= " (send_date >='".$chk_year.$chk_mon.$chk_day."0000' and send_date <='".$chk_year.$chk_mon.$chk_day."9999') AND ";
				$strSQL .= " message_date = '' AND ";
				$strSQL .= " reserva_flg  = 0      ";
				$strSQL .= " ) OR ";
				$strSQL .= "(";
				$strSQL .= " reserva_date = '".$chk_year.$chk_mon.$chk_day."' AND ";
				$strSQL .= " message_date = '' AND ";
				$strSQL .= " reserva_flg  = 1";
				$strSQL .= ")";
				$strSQL .= "ORDER BY ";
				$strSQL .= " Mail_id DESC";
				$objRecSet = pg_exec($strSQL);
				if($objRecSet==false){
						echo("SQL実行に失敗しました(SELECT)");
						exit;
				}
				$intData = pg_numrows($objRecSet);
				for ($intDtCnt = 0; $intDtCnt < $intData; $intDtCnt++) {
						$objRecData = pg_fetch_object($objRecSet, $intDtCnt);
						//表示内容編集
						if($objRecData->reserva_flg==1){
								$Reserva="(未送)";
						}else{
								$Reserva="";
						}
						$strDisp="";
						if (trim($objRecData->message_time)!=""){
								$strDisp=substr($objRecData->message_time, 0, 2).":".substr($objRecData->message_time, 2, 2)." ";
						}
						$strDisp=$strDisp.str_replace("(〒)","",$objRecData->subject_name);
						$strCalData[$intRow][$intCol] .= '<li><a href="#" onclick="return Detail_Disp('."'".$objRecData->mail_id."','".$objRecData->name50_nm."');".'">'.$strDisp;
						switch ($objRecData->name50_nm) {
							case "SC":
									$strCalData[$intRow][$intCol] .= '<br>（スケジュール調整）';
									break;
							case "QU":
									$strCalData[$intRow][$intCol] .= '<br>（アンケート）';
									break;
							case "DM":
									$strCalData[$intRow][$intCol] .= '<br>（お知らせ配信）';
									break;
							default:
									break;
						}
						$strCalData[$intRow][$intCol] .= '</a>'.$Reserva.'</li>';
				}

				$strCalData[$intRow][$intCol] .= '</ul>';

		}else{
				$strCalData[$intRow][$intCol] = "";
		}
		$intCol = $intCol+1;
}

$o_smarty->assign('strCalData',$strCalData);

$o_smarty->display('MAIN0000.tpl');

?>