MNP200_m.php 6.01 KB

Raw Blame History Permalink

<?php
//*****************************************************************************
//*
//* プログラム名：アンケート(携帯電話)
//* プログラムID：MNP100_m.php
//* 機能        ：詳細画面
//* 作成者      ：
//*
//*****************************************************************************
header("Content-type: text/html; charset=Shift_JIS");

//*** 広告 ***//
include("include_m/Advertisement.inc");

//*** 共通処理 ***//
include("include_m/CommonProcess.inc");

//*** アンケート ***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'MNP010.php'";
$rsRecset = pg_exec($strMenuSQL);
$PHP_TITLE_NAME=mb_convert_encoding(pg_result($rsRecset,0,"name"), "SJIS", "EUC-JP");

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=Shift_JIS">
<TITLE>E-グルPro(<?php  echo $PHP_TITLE_NAME; ?>)</TITLE>
</HEAD>
<BODY>
<form Method="GET" action="MNP192_m.php">
<center>
<?php  echo $PHP_TITLE_NAME; ?><br>
<?php  echo $strName; ?>
<HR width="100%">
<?php  echo $koukokuTEL; ?>
</center>
<?php
	//メニュー表示
	include("include_m/CommonMenuReturn.inc");
?>
<HR width="100%">
<a href="MNP020_m.php?intPage=<?php  echo $intPage ?>&<?php  echo $PHP_Argument ?>"accesskey="1"><?php  echo Get_Num("1"); ?>作成一覧へ</A><br>
<br>
<?php

$strSQL  = "SELECT ";
$strSQL .= " mnp_kihon_tbl.mail_id      ,";
$strSQL .= " mnp_kihon_tbl.mail_subject ,";
$strSQL .= " mnp_kihon_tbl.mail_body    ,";
$strSQL .= " mnp_kihon_tbl.send_syain_cd,";
$strSQL .= " mnp_kihon_tbl.send_mode    ,";
$strSQL .= " mnp_kihon_tbl.send_date    ,";
$strSQL .= " mnp_kihon_tbl.send_time    ,";
$strSQL .= " mnp_kihon_tbl.ans_type     ,";
$strSQL .= " mnp_kihon_tbl.ans_limit    ,";
$strSQL .= " mnp_kihon_tbl.disp_mode    ,";
$strSQL .= " syain_tbl.name_kj_sei      ,";
$strSQL .= " syain_tbl.name_kj_mei       ";
$strSQL .= "FROM";
$strSQL .= " syain_tbl    , ";
$strSQL .= " mnp_kihon_tbl  ";
$strSQL .= "WHERE";
$strSQL .= " syain_tbl.syain_cd    = mnp_kihon_tbl.send_syain_cd AND ";
$strSQL .= " mnp_kihon_tbl.mail_id = ".$_REQUEST["mail_id"]." ";
$objRec = pg_exec($strSQL);
if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
}
$objData = pg_fetch_object($objRec, 0);
$Detail_Data[0]  = $objData->mail_id;
$Detail_Data[1]  = mb_convert_encoding($objData->mail_subject, "SJIS", "EUC-JP" );
$Detail_Data[2]  = str_replace ("\n", "<BR>" , mb_convert_encoding($objData->mail_body, "SJIS", "EUC-JP" ));
$Detail_Data[2]  = str_replace ("\t", "　　" , $Detail_Data[2]);
$Detail_Data[2]  = str_replace (" ", "&nbsp;", $Detail_Data[2]);
$Detail_Data[2]  = ereg_replace("(https?|ftp|news)(://[[:alnum:]\+\$\;\?\.%,!#~*/:@&=_-]+)","<a href=\"\\1\\2\" target=\"_blank\">\\1\\2</a>",$Detail_Data[2]);
$Detail_Data[3]  = mb_convert_encoding($objData->send_syain_cd, "SJIS", "EUC-JP" );
$Detail_Data[4]  = mb_convert_encoding($objData->send_mode, "SJIS", "EUC-JP" );
$Detail_Data[5]  = mb_convert_encoding($objData->send_date, "SJIS", "EUC-JP" );
$Detail_Data[6]  = mb_convert_encoding($objData->send_time, "SJIS", "EUC-JP" );
$Detail_Data[7]  = mb_convert_encoding($objData->ans_type, "SJIS", "EUC-JP" );
$Detail_Data[8]  = mb_convert_encoding($objData->ans_limit, "SJIS", "EUC-JP" );
$Detail_Data[9]  = mb_convert_encoding($objData->disp_mode, "SJIS", "EUC-JP" );
$Detail_Data[10] = mb_convert_encoding($objData->name_kj_sei." ".$objData->name_kj_mei, "SJIS", "EUC-JP" );


//日付
echo "作成日時：".$Detail_Data[5]." ".$Detail_Data[6]."<br>";
echo "件　　名：".$Detail_Data[1]."(".$Detail_Data[10].")<br>";
echo "内　　容：".$Detail_Data[2]."<br>";

echo '<HR width="100%">';
echo "【回答状況】<br>";

//*****　現在回答数取得　*****//
//未回答数
$strSQL  = "SELECT ";
$strSQL .= " (SELECT COUNT(*) FROM mnp_syain_info AS chk1 WHERE chk1.mail_id=M.mail_id AND chk1.read_flg <> 2) AS n_ans_cnt ";
$strSQL .= "FROM ";
$strSQL .= " mnp_syain_info AS M ";
$strSQL .= "WHERE";
$strSQL .= " M.mail_id=".$_REQUEST["mail_id"]." ";
$strSQL .= "GROUP BY ";
$strSQL .= " M.mail_id";
//echo $strSQL."<hr>";
$objCntRec = pg_exec($strSQL);
if($objCntRec==false){
		echo("SQL実行に失敗しました(SELECT)b");
		exit;
}
$objCntData = pg_fetch_object($objCntRec, 0);

echo "<a href=\"MNP210_m.php?intPage=".$intPage ."&mail_id=".$_REQUEST["mail_id"]."&ans_id=0&".$PHP_Argument."\">未回答　".$objCntData->n_ans_cnt."件</A><br>";

//*****　回答数　*****//
$strSQL  = "SELECT ";
$strSQL .= "  T1.ans_id           , ";
$strSQL .= "  T1.ans_name         , ";
$strSQL .= " (SELECT COUNT(*) FROM mnp_syain_ans AS T2 WHERE T1.mail_id=T2.mail_id AND T1.ans_id = T2.ans_id) AS data_cnt    ";
$strSQL .= "FROM ";
$strSQL .= "  mnp_answer_tbl AS T1 ";
$strSQL .= "WHERE ";
$strSQL .= " T1.mail_id=".$_REQUEST["mail_id"]." ";
$strSQL .= "ORDER BY ";
$strSQL .= "  T1.ans_id   ";
$objRec = pg_exec($strSQL);
if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)b");
		exit;
}
for ($intI=0; $intI < pg_numrows($objRec); $intI++){
		$objData = pg_fetch_object($objRec, $intI);
		$ANS_LIST[$intI][0] = $objData->ans_id;
		$ANS_LIST[$intI][1] = $objData->ans_name;
		$ANS_LIST[$intI][2] = $objData->data_cnt;
}

for($intI = 0; $intI < count($ANS_LIST); $intI++){
		if($ANS_LIST[$intI][2] == 0){
			echo "".mb_convert_encoding($ANS_LIST[$intI][1], "SJIS", "EUC-JP" )."　".$ANS_LIST[$intI][2]."件<br>";
		}else{
			echo "<a href=\"MNP210_m.php?intPage=".$intPage ."&mail_id=".$_REQUEST["mail_id"]."&ans_id=".$ANS_LIST[$intI][0]."&".$PHP_Argument."\">".mb_convert_encoding($ANS_LIST[$intI][1], "SJIS", "EUC-JP" )."　".$ANS_LIST[$intI][2]."件</A><br>";
		}
}

echo '<br><INPUT type="submit" NAME="intsts" value="削除">';

echo "<hr>";

?>


<a href="MNP020_m.php?intPage=<?php  echo $intPage ?>&<?php  echo $PHP_Argument ?>"accesskey="1"><?php  echo Get_Num("1"); ?>作成一覧へ</A><br>
<HR width="100%">
<?php
	//メニュー表示
	include("include_m/CommonMenuReturn.inc");
?>
<INPUT TYPE="hidden" NAME="mail_id"  VALUE="<?php echo $_REQUEST["mail_id"]; ?>">
<INPUT TYPE="hidden" NAME="intPage"  VALUE="<?php echo $intPage ?>">
<?php
	//*** 共通変数取得 ***//
	include("include_m/CommonHidden.inc");
?>
</form>
</BODY>
</HTML>