header('Content-Type: text/html; charset=UTF-8');
include "../../../mate_system/common.php";
define("MAX_ROW", 3);
$titleNames = array("一日体験", "ブライダル", "仲間");
$tableNames = array("taiken_info", "bridal_info", "nakama_info");
$oomidashiNames = array("message_taiken_oomidashi.png", "message_bridal_oomidashi.png", "message_nakama_oomidashi.png");
$urlPaths = array(UPLOAD_URL_TAIKEN, UPLOAD_URL_BRIDAL, UPLOAD_URL_NAKAMA);
$filename = "message.htm";
$fp = @fopen($filename, "r" );
$contents = fread( $fp, filesize( $filename ) );
fclose( $fp );
$func_no = 0;
if(isset($_GET["func_no"]))
{
$func_no = $_GET["func_no"];
}
$sql = sprintf("select NO from %s where VALID_STATUS = 1 order by NO DESC", $tableNames[$func_no]);
$page = 0;
if(isset($_POST["page_data"]))
{
$page = $_POST["page_data"];
}
$con = mysql_logon();
$rtn = mysql_query($sql, $con);
mysql_close($con);
$row = 0;
$row_start = $page * MAX_ROW;
$row_end = $row_start + MAX_ROW;
$lastFlg = TRUE;
$page_data = 0;
while($arr = mysql_fetch_array($rtn))
{
if($page == -1)
{
$listNo[] = $arr["NO"];
if((($row + 1) % MAX_ROW) == 0 && $row > 0)
{
$page_data++;
unset($listNo);
}
}
else
{
if($row_end <= $row)
{
$lastFlg = FALSE;
break;
}
else if($row_start <= $row)
{
$listNo[] = $arr["NO"];
}
}
$row++;
}
if($page == -1)
{
$page = $page_data;
}
$message_data = "";
if(0 < count($listNo))
{
$sql = sprintf("select * from %s where NO in(", $tableNames[$func_no]);
for( $i = 0; $i < count($listNo); $i++ )
{
if($i > 0)
{
$sql = $sql.",";
}
$sql = $sql.$listNo[$i];
}
$sql = $sql.") and VALID_STATUS = 1 order by NO DESC";
$con = mysql_logon();
$rtn = mysql_query($sql, $con);
mysql_close($con);
$row = 0;
while($arr = mysql_fetch_array($rtn))
{
$name = htmlspecialchars($arr["NAME"], ENT_QUOTES);
$title = htmlspecialchars($arr["TITLE"], ENT_QUOTES);
$comment = htmlspecialchars($arr["COMMENT"], ENT_QUOTES);
$message_data = $message_data."
";
if(0 < strlen($arr["PHOTO_FILE_NAME1"]))
{
$message_data = $message_data.sprintf("
", $urlPaths[$func_no].$arr["NO"]."/".$arr["PHOTO_FILE_NAME1"], nl2br($comment), makePhotoFileURL($arr["NO"], $arr["PHOTO_FILE_NAME1"]));
}
else
{
$message_data = $message_data."
\r\n";
}
if(0 < strlen($arr["TITLE"]))
{
$message_data = $message_data.sprintf("
%s
", nl2br($title));
}
$message_data = $message_data.sprintf("
", nl2br($comment));
$message_data = $message_data."
";
$message_data = $message_data.sprintf("
%s
", $name);
$message_data = $message_data."
";
$row++;
}
}
$btn_data = "";
if($lastFlg && $page == 0)
{
$btn_data = "";
}
else if($lastFlg )
{
$btn_data = $btn_data."";
$btn_data = $btn_data."";
}
else if($page == 0)
{
$btn_data = $btn_data."";
$btn_data = $btn_data."";
}
else
{
$btn_data = $btn_data."";
$btn_data = $btn_data."";
$btn_data = $btn_data."";
$btn_data = $btn_data."";
}
$contents = str_replace("", $titleNames[$func_no], $contents);
$contents = str_replace("", $oomidashiNames[$func_no], $contents);
$contents = str_replace("", $func_no, $contents);
$contents = str_replace("", $message_data, $contents);
$contents = str_replace("", $btn_data, $contents);
$contents = str_replace("", $page, $contents);
$contents = str_replace("", sprintf("- %d頁 -", $page + 1), $contents);
print $contents;
//--------------------------------------------------------------------
//更新日付文字列の作成
//--------------------------------------------------------------------
function makeUpdateDateString($update_date)
{
return sprintf("更新日付:%s", $update_date);
}
//--------------------------------------------------------------------
//写真ファイルのサムネイルURLを作成する処理
//--------------------------------------------------------------------
function makePhotoFileURL($no, $photo)
{
global $func_no;
global $urlPaths;
$makeURL = $urlPaths[$func_no].$no."/".$photo;
$parts = pathinfo($makeURL);
$makeURL = $parts['dirname']."/".$parts['filename']."_s.".$parts['extension'];
return $makeURL;
}
?>