<?PHP 
//*****************************************************************************
//* 
//* プログラム名：め〜るNiポン！V2
//* プログラムID：USERM102.php
//* 機能        ：回答確認
//* 
//*****************************************************************************
header("Content-type: text/html; charset=Shift_JIS");

//***************************
//*　インクルードファイル
//***************************
include("./include/dbcon2.inc");
$strSQL = "SELECT * FROM mst_kanri WHERE angou = '" . $dkey . "'";
$objRec = pg_exec($strSQL);
if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
	exit;
}
$PHP_POST_DB_NAME=pg_result($objRec,0,"db_name");

include("./include/dbcon.inc");
include("./include/jcode.phps");

//***************************
//*　メイン処理
//***************************
$strSQL = "SELECT * FROM answer_data WHERE mail_id = " . $key;
$objRec = pg_exec($strSQL);
if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)d");
		exit;
}
if(pg_numrows($objRec)!=0){
		$objData = pg_fetch_object($objRec,0);
		$SYORI_MODE = $objData->name50_nm;
}

//回答文言を取得
if($ans==0){
		$ans_name="未読者";
}elseif($ans==99){
		$ans_name="既読者";
}elseif($ans==100){
		$ans_name="未送信";
}else{
		$strSQL = "SELECT * FROM answer_data WHERE mail_id = " . $key;
		$objRecSet = pg_exec($strSQL);
		if($objRecSet==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}

		$objData = pg_fetch_object($objRecSet,0);
		for($intIdx = 1; $intIdx <= $objData->select_nm; $intIdx++){
				if($ans==pg_result($objRecSet, 0, "name" . $intIdx . "_id")){
					$ans_name=jcodeconvert(pg_result($objRecSet, 0, "name" . $intIdx . "_nm"),1,2);
					break;
				}
		}
}

if ((($SYORI_MODE=="SC") && ($ans!="100") && ($ans!="99") && ($ans!="0")) || (($SYORI_MODE=="QU") && ($ans!="100") && ($ans!="99") && ($ans!="0"))){
		$strSQL  = "SELECT ";
		$strSQL .= " mail_info2.check_flg , ";
		$strSQL .= " mail_info.comment    , ";
		$strSQL .= " syain_tbl.syain_cd   , ";
		$strSQL .= " syain_tbl.name_kj_sei, ";
		$strSQL .= " syain_tbl.name_kj_mei  ";
		$strSQL .= "FROM ";
		$strSQL .= " syain_tbl , ";
		$strSQL .= " mail_info , ";
		$strSQL .= " mail_info2  ";
		$strSQL .= "WHERE";
		$strSQL .= " syain_tbl.syain_cd   = mail_info.syain_cd  AND ";
		$strSQL .= " syain_tbl.syain_cd   = mail_info2.syain_cd AND ";
		$strSQL .= " mail_info.mail_id    = mail_info2.mail_id  AND ";
		$strSQL .= " mail_info.mail_id    = ".$key. "           AND ";
		$strSQL .= " mail_info2.mail_id   = ".$key. "           AND ";
		$strSQL .= " mail_info2.check_flg = ".$ans. " ";
		$strSQL .= "ORDER BY ";
		$strSQL .= " syain_tbl.name_kn_sei, ";
		$strSQL .= " syain_tbl.name_kn_mei, ";
		$strSQL .= " syain_tbl.syain_cd ASC ";
		$objRecSet = pg_exec($strSQL);
		if($objRecSet==false){
		    echo("SQL実行に失敗しました(SELECT)");
		    exit;
		}
		for ($intI = 0; $intI < pg_numrows($objRecSet); $intI++) {
				$syain_cd[$intI] = pg_result($objRecSet,$intI,"syain_cd");
				$name_kj[$intI] = jcodeconvert(pg_result($objRecSet,$intI,"name_kj_sei"),1,2) . jcodeconvert(pg_result($objRecSet,$intI,"name_kj_mei"),1,2);
				if(pg_result($objRecSet,$intI,"comment")!=""){
						$Com_mark[$intI] = "○";
				}else{
						$Com_mark[$intI] = "　";
				}
		}
}else{
		$SetIdx = 0;

		$strSQL  = "SELECT ";
		$strSQL .= " Mail_info.Check_flg, ";
		$strSQL .= " Mail_info.comment, ";
		$strSQL .= " Syain_tbl.syain_cd, ";
		$strSQL .= " Syain_tbl.name_kj_sei, ";
		$strSQL .= " Syain_tbl.name_kj_mei ";
		$strSQL .= "FROM Mail_info, Syain_tbl ";
		$strSQL .= "WHERE (Mail_info.Mail_id = " . $key . " ";
		$strSQL .= "AND Mail_info.Check_flg = " . $ans . ") ";
		$strSQL .= "AND Syain_tbl.syain_cd = Mail_info.syain_cd ";
		$strSQL .= "ORDER BY Mail_info.check_flg , Syain_tbl.name_kn_sei, Syain_tbl.name_kn_mei, Syain_tbl.syain_cd ASC";
		//echo $strSQL;
		$objRecSet = pg_exec($strSQL);
		if($objRecSet==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
		}
		for ($intI = 0; $intI < pg_numrows($objRecSet); $intI++) {
				$ChkFlg = "";

				$objData = pg_fetch_object($objRecSet,$intI);
				
				if (($SYORI_MODE=="SC") && ($ans=="99")){
						$strSQL  = "SELECT ";
						$strSQL .= " * ";
						$strSQL .= "FROM ";
						$strSQL .= " mail_info2 ";
						$strSQL .= "WHERE";
						$strSQL .= " syain_cd  = ".$objData->syain_cd. " AND ";
						$strSQL .= " mail_id   = ".$key. "                   ";
						$objChkRec = pg_exec($strSQL);
						if($objChkRec==false){
								echo("SQL実行に失敗しました(SELECT)");
								exit;
						}
						if(pg_numrows($objChkRec)!=0){
								$ChkFlg = "";
						}else{
								$ChkFlg = "1";
						}
				}else{
						$ChkFlg = "1";
				}

				//echo $ChkFlg."　".jcodeconvert($objData->name_kj_sei,1,2) . jcodeconvert($objData->name_kj_mei,1,2)."<br>";
				if ($ChkFlg=="1"){
						$syain_cd[$SetIdx] = $objData->syain_cd;
						$name_kj[$SetIdx]  = jcodeconvert($objData->name_kj_sei,1,2) . jcodeconvert($objData->name_kj_mei,1,2);
						if($objData->comment!=""){
									$Com_mark[$SetIdx] = "○";
						}else{
									$Com_mark[$SetIdx] = "　";
						}
						$SetIdx = $SetIdx+1;
				}
		}
}

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=Shift_JIS">
<TITLE>配信情報</TITLE>
</HEAD>
<BODY>
<FORM>
<center>
<FONT color=blue size=5>め〜るNiポン(携帯版)</FONT><br>
<HR width="100%">
</center>
【<?PHP  echo $ans_name ?>】<BR><BR>
<?PHP 	for($intI = 0; $intI <= count($syain_cd); $intI++){	?>
				<?PHP  echo $name_kj[$intI] ?>　
				<?PHP  if($Com_mark[$intI]!="　"){ ?>
					<A HREF="USERM103.php?key=<?PHP  echo $key ?>&s_cd=<?PHP  echo $syain_cd[$intI]?>&ans=<?PHP  echo $ans ?>&dkey=<?PHP  echo $dkey ?>&PHP_syain_cd=<?PHP  echo $PHP_syain_cd ?>&PHP_DB_NAME=<?PHP  echo $PHP_DB_NAME ?>&PHP_POST_DB_FLG=<?PHP  echo $PHP_POST_DB_FLG ?>"><?PHP  echo $Com_mark[$intI] ?></A>
				<?PHP  } ?>
				<BR>
<?PHP 	}	?>
<BR>
</FORM>
</BODY>
</HTML>