LIST3010.php 7.02 KB

Raw Blame History Permalink

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

//***************************
//*　インクルードファイル
//***************************
include("./include/getDomain.inc");
include("./include/jcode.phps");
include("./include/session_start.inc");
include("./include/SessionChk.inc");
include("./include/dbcon.inc");
include("./include/mime.php");
include("./include/point.inc");
include("./include/logget.inc");
include("./include/mtcnews.inc");

//mtcnews.incから取得
$Comment_tel = jcodeconvert($Mail_Keitai, 1, 3);
$Comment_pc  = jcodeconvert($Mail_PC, 1, 3);

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=EUC-JP">
<META http-equiv="Content-Style-Type" content="text/css">
<link href="./css/style.css" rel="stylesheet" type="text/css">
<TITLE>送信中</TITLE>
<script language="javascript">
function pageJump(){
		document.frm.action = "LIST3011.php";
		document.frm.method="POST";
		document.frm.submit();
}
</script>
</HEAD>
<BODY onload="pageJump();">
<?PHP
//ヘッダー
include("./include/header.inc");
?>
<br>
<br>
<br>
<center>
<B><FONT color=blue size=5>送信中です。しばらく待ちください。</FONT></B>
<br>
<form name="frm">
<table>
<tr>
<br>
<br>
<td><FONT size=5><div id="maxcount"></div></FONT></td>
<td><FONT size=5>件中</FONT></td>
<td><FONT size=5><div id="count"></div></FONT></td>
<td><FONT size=5>件送信しました。</FONT></td>
<tr>
</table>
<br>
<B><FONT color=red size=5>※この画面で何か操作しますと、処理が正常におこなわれません。</FONT></B>
<br>
</form>
<br>
</center>
<?PHP

//***************************
//* メイン処理
//***************************

//送信日時
$strSubmitTime = date("Ymdhis");

if (strlen($strSubmitTime) == 12) {
	$strSubmitTime = "20" . $strSubmitTime;
}

$strYear   = substr($strSubmitTime, 0, 4);
$strMonth  = substr($strSubmitTime, 4, 2);
$strDay    = substr($strSubmitTime, 6, 2);
$strHour   = substr($strSubmitTime, 8, 2);
$strMinute = substr($strSubmitTime, 10, 2);

//送信者アドレス,名前
$strSQL  = "SELECT ";
$strSQL .= " * ";
$strSQL .= "FROM ";
$strSQL .= " syain_tbl ";
$strSQL .= "WHERE ";
$strSQL .= " syain_cd = " . $_SESSION["PHP_POST_SYAIN_CD"]. " ";
$strSQL .= "ORDER BY";
$strSQL .= " syain_cd";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
		echo("SQL実行に失敗しました(INSERT)");
		exit;
}
$objData = pg_fetch_object($objRecSet, 0);
$strSubmitAdd = $objData->pc_mail_addr;
if($strSubmitAdd==""){//pcメルアドが無かったら
		$objData = pg_fetch_object($objRecSet, 0);
		$strSubmitAdd = $objData->mail_addr;
		if($strSubmitAdd==""){//どちらのメルアドも無かったら
				$strSQL = "SELECT * FROM mst_dmain";
				$objRecSet = pg_exec($strSQL);
				if($objRecSet==false){
						echo("SQL実行に失敗しました(INSERT)");
						exit;
				}
				$objData = pg_fetch_object($objRecSet, 0);
				$strSubmitAdd = $objData->mail_addr;
		}
}
$strSubmitName=$strSubmitName=$objData->name_kj_sei . " " . $objData->name_kj_mei;

//ドメイン
$strDomeName=getDomain();

//********** メール情報取得 **********//
$strSQL  = "SELECT ";
$strSQL .= " * ";
$strSQL .= "FROM ";
$strSQL .= " mail_data ";
$strSQL .= "WHERE ";
$strSQL .= " mail_id = " . (int)$_POST["mail_id"];
$objRec = pg_exec($strSQL);
if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
}
$objData = pg_fetch_object($objRec, 0);
$Angou_id      = $objData->angou_id;
$Mail_date     = $objData->message_date;
$Mail_time     = $objData->message_time;
$Subject_name  = "[再]";
$Subject_name .= $objData->subject_name;
$Contents      = $objData->contents;
$Send_type     = $objData->send_type;

$Header1 = "";
$Headers['From']=$strSubmitAdd;
$Headers['X-Mailer']="PHP/".phpversion(); //メール送信プログラムの表示

//********** 未読者取得 **********//
$strSQL  = "SELECT ";
$strSQL .= " syain_tbl.syain_cd    , ";
$strSQL .= " syain_tbl.angou_cd    , ";
$strSQL .= " syain_tbl.mail_addr   , ";
$strSQL .= " syain_tbl.pc_mail_addr, ";
$strSQL .= " syain_tbl.name_kj_sei , ";
$strSQL .= " syain_tbl.name_kj_mei   ";
$strSQL .= "FROM ";
$strSQL .= " mail_info, ";
$strSQL .= " syain_tbl  ";
$strSQL .= "WHERE ";
$strSQL .= " mail_info.syain_cd  = syain_tbl.syain_cd         AND ";
$strSQL .= " mail_info.mail_id   = ".(int)$_POST["mail_id"]." AND ";
$strSQL .= " mail_info.check_flg = 0 ";
$strSQL .= "ORDER BY ";
$strSQL .= " syain_tbl.syain_id ASC ";
$objRec = pg_exec($strSQL);
if($objRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
}
for ($intI = 0; $intI < pg_numrows($objRec); $intI++) {
		$objUsrData = pg_fetch_object($objRec, $intI);

		//*** 宛先情報取得 ***//
		$Mail_Nasi = 0;
		$strAngou  = $objUsrData->angou_cd;
		$strTo     = $objUsrData->pc_mail_addr;
		$strToMob  = $objUsrData->mail_addr;
		$strToName = $objUsrData->name_kj_sei.$objUsrData->name_kj_mei;

$strComment = "";
		$strSubject  = "=?iso-2022-jp?B?" . base64_encode(jcodeconvert($Subject_name, 0, 3)) . "?=";
		$strComment .= $_SESSION["PHP_POST_DB_USER_NAME"]."の皆様(".$strToName."様)へ\n\n下記のアドレスからメール内容を確認してください。\n";
		//$strComment .= "http://" . $strDomeName . "/mail_ni_pon/check_update/mail_check.php?";
		$strComment .= $PONV2_URL_HEAD . "USER0000.php?";
		$strComment .= "m=".$Angou_id."&";
		$strComment .= "s=".$strAngou."&";
		$strComment .= "d=".$_SESSION["PHP_POST_DB_ANGOU"]. "\n\n";

		$strComment  = jcodeconvert($strComment, 1, 3);

		$Header  = "";//ヘッダー部クリア
		$Header1 = "";

		//*****　携帯電話へ送信　*****//
		//PEARのmimeクラス設定
		$mime = new Mail_mime("\r\n");
		$mime->_build_params['text_charset'] = 'iso-2022-jp'; //本文テキストの文字コードをJISに設定する

		//本文のテキストの指定
		$mime->setTXTBody($strComment);
		$strComment = $mime->get();

		$Headers = $mime->headers($Headers);
		while (list($key,$val)=each($Headers)) {
				$Header1 .= $key.": ".$val."\r\n";
		}

		if($Send_type==0 || $Send_type==1){
				if($strToMob!=""){
						$intBool2 = mail($strToMob,$strSubject,$strComment.$Comment_tel.$koukokuTEL,$Header1,"-f ".$strSubmitAdd);//携帯に送信
				}else{
						$intBool2 = true;
				}
		}else{
				$intBool2 = true;
		}

		//*****　ＰＣへ送信　*****//
		//メールボディの取得
		$strComment = $mime->get();

		//メールヘッダの取得
		$Headers = $mime->headers($Headers);

		//メールヘッダの配列を文字列に組み立てる
		while (list($key,$val)=each($Headers)) {
				$Header .= $key.": ".$val."\r\n";
		}

		if($Send_type==0 || $Send_type==2){
				if($strTo!=""){
						$intBool = mail($strTo, $strSubject, $strComment.$Comment_pc.$koukokuPC, $Header,"-f ".$strSubmitAdd);//PCに送信
				}else{
						$intBool = true;
				}
		}else{
				$intBool = true;
		}

		$Max_User = pg_numrows($objRec);
		echo "<script language='javascript'>";
		echo "document.getElementById('maxcount').innerHTML ='".$Max_User."';";
		echo "document.getElementById('count').innerHTML ='".$intI."';";
		echo "</script>";
		ob_flush();
		flush();

}

?>
</BODY>
</HTML>