<?PHP  
//*****************************************************************************
//* 
//* プログラム名：配信処理画面
//* プログラムID：SEND0010.php
//* 機能        ：配信処理
//* 
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
include("./include/session_start.inc");
include("./include/SessionChk.inc");

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

$Comment_tel = jcodeconvert($Mail_Keitai, 1, 3);
$Comment_pc = jcodeconvert($Mail_PC, 1, 3);

//***************************
//* メイン処理
//***************************
//添付ファイル容量チェック
$tmp_flg=0;
if($_FILES['f_attach']['name']!=""){
	if($_FILES['f_attach']['size'] > 2000000){
		$tmp_flg=1; //２Ｍ以上は送信しない
	}else{
		$tmp_flg=0; //２Ｍ以下は送信する
	}
}
//$tmp_flg=1;
if($tmp_flg==0){
	//表示項目名を取得
	$strSQL = "SELECT disp_id, disp_name FROM mst_disp WHERE disp_id = '6'";
	$objRecSet = pg_exec($strSQL);
	if($objRecSet==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	$objData = pg_fetch_object($objRecSet,0);
	$strDisp_Name = JcodeConvert($objData->disp_name, 1, 1);
	//日付
	$strDate = $_REQUEST["date_yyyy"].$_REQUEST["date_mm"].$_REQUEST["date_dd"];
	if (is_numeric($strDate)==false || strlen($strDate) != 8) {
		$strDate = "";
	}
	//時間
	$strTime = $_REQUEST["time_hh"].$_REQUEST["time_mm"];
	if (is_numeric($strTime)==false || strlen($strTime) != 4 || $strDate == "") {
		$strTime = "";
	}
	//件名
	if($_REQUEST["tei"]=="on"){
		$strKenmei = "(〒)".$strDisp_Name.":".$_REQUEST["kenmei"];
	}else{
		$strKenmei = "(〒)".$_REQUEST["kenmei"];
	}
	$strKenmei = JcodeConvert($strKenmei, 1, 1);
	//本文
	$strText = JcodeConvert($_REQUEST["text"], 1, 1);
	//アラームフラグ
	if((int)$_REQUEST["alarm_flg"] == 1){
 		//内容
 		//アラーム用
		$strMes = $_REQUEST["date_yyyy"]."年".intval(substr($_REQUEST["date_mm"],0,2))."月".intval(substr($_REQUEST["date_dd"],0,2))."日";
		if ($strTime != "") {
			$strMes = $strMes.intval(substr($_REQUEST["time_hh"],0,2))."時".intval(substr($_REQUEST["time_mm"],0,2))."分";
		}
		$strAlarm_Text = "'「".JcodeConvert($strKenmei, 1, 1)."の開催日：".$strMes."」の日時が近づいております。詳細は下記ＵＲＬをご覧ください。"."'";
		//件名
		if($_REQUEST["tei"]=="on"){
			$strKenmei2 = "(〒お知らせ)".$strDisp_Name.":".$_REQUEST["kenmei"];
		}else{
			$strKenmei2 = "(〒お知らせ)".$_REQUEST["kenmei"];
		}
	}
	//送信日時
	$strSubmitTime = date("YmdHis");
	if (strlen($strSubmitTime) == 12) {
		$strSubmitTime = "20".$strSubmitTime;
	}
	//送信者アドレス,名前
	$strSQL = "SELECT name_kj_sei, name_kj_mei, pc_mail_addr, mail_addr FROM syain_tbl ".
			  "WHERE syain_cd = ".$PHP_POST_SYAIN_CD." " .
			  "ORDER BY 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=$objData->name_kj_sei." ".$objData->name_kj_mei;
	//ドメイン
	$strDomeName=getDomain();
	//メールID？
	$strSQL = "SELECT Max(mail_id) as Max_id FROM mail_data";
	$objRecSet = pg_exec($strSQL);
	$Max_id = pg_result($objRecSet,0,"Max_id");
	if($objRecSet==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	$Max_mail = ($Max_id + 1);
	$Max_id = "'".($Max_id + 1)."'";
	//乱数取得----------
	$num = 1;
	while ($num >= 1){
		$strArray = array(0,1,2,3,4,5,6,7,8,9,a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z);
		$angou = "";
		for ($i = 0; $i < (10 - (int)$_REQUEST["view_flg"]); $i++){
		  $tmp_num = rand(0, 51);
		  $angou .= $strArray[$tmp_num];
		}
		$sql = "SELECT * FROM mail_data";
		$sql .= " WHERE angou_id = '".$angou."'";
		$rtn = pg_exec($sql);
		if($rtn == false){
		  echo "SQLの実行に失敗しました。(#1)";
		  exit;
		}
		$num = pg_numrows($rtn);
	}


	//2011/09/28 データ削除
	$strSQL = "DELETE FROM mail_data WHERE mail_id=".$Max_id;
	//echo $strSQL."<hr>";
	$objRec = pg_exec($strSQL);
	if($objRec==false){
			echo("SQL実行に失敗しました(DELETE)");
			exit;
	}
	
	//アラームデータ削除
	$strSQL = "DELETE FROM alarm_data WHERE mail_id=".$Max_id;
	$objRec = pg_exec($strSQL);
	if($objRec==false){
			echo("SQL実行に失敗しました(DELETE)");
			exit;
	}
	
	//メールＩＮＦＯ削除
	$strSQL = "DELETE FROM mail_info WHERE mail_id=".$Max_id;
	$objRec = pg_exec($strSQL);
	if($objRec==false){
			echo("SQL実行に失敗しました(DELETE)");
			exit;
	}
	
	//メールＩＮＦ2Ｏ削除
	$strSQL = "DELETE FROM mail_info2 WHERE mail_info2.mail_id = ".$Max_id;
	$objRecSet = pg_exec($strSQL);
	if($objRecSet==false){
			echo("SQL実行に失敗しました(DELETE)");
			exit;
	}
	
	//メール回答情報削除
	$strSQL = "DELETE FROM answer_data WHERE mail_id=".$Max_id;
	$objRec = pg_exec($strSQL);
	if($objRec==false){
			echo("SQL実行に失敗しました(DELETE)");
			exit;
	}

	//既読・未読自動再配信情報削除
	$strSQL = "DELETE FROM kidok_data WHERE mail_id=".$Max_id;
	$objRec = pg_exec($strSQL);
	if($objRec==false){
			echo("SQL実行に失敗しました(DELETE)");
			exit;
	}

	//配信機種情報削除
	$strSQL = "DELETE FROM mail_send_tbl WHERE mail_id=".$Max_id;
	$objRec = pg_exec($strSQL);
	if($objRec==false){
			echo("SQL実行に失敗しました(DELETE)");
			exit;
	}

	//メールデータ作成
	$strSQL = "INSERT INTO mail_data (" .
			  "mail_id, " .
			  "angou_id, " .
			  "message_date, " .
			  "message_time, " .
			  "subject_name, " .
			  "contents, " .
			  "admin_cd, " .
			  "send_date, " .
			  "send_type, " .
			  "send_alarm)" .
			  "VALUES (" .
			  $Max_id.", " .
			  "'".$angou."', " .
			  "'".$strDate."', " .
			  "'".$strTime."', " .
			  "'".addslashes($strKenmei)."'".", " .
			  "'".addslashes($strText)."'". ", " .
			  $PHP_POST_SYAIN_CD.", " .
			  "'".$strSubmitTime."', " .
			  (int)$_REQUEST["SendType"].", " .
			  (int)$_REQUEST["alarm_flg"].") ";
	$objRecSet = pg_exec($strSQL);
	if($objRecSet==false){
			echo $strSQL."<hr>";
			echo("SQL実行に失敗しました(INSERT)");
			exit;
	}
	//送信日時設定
	if($_REQUEST["NowSend"] == "on"){
		//日付
		$strDay = $_REQUEST["send_yyyy"].$_REQUEST["send_mm"].$_REQUEST["send_dd"];
		if (is_numeric($strDay)==false || strlen($strDay) != 8 ) {
			$strDay = "";
		}
		//時間
		$strKtime = $_REQUEST["send_hh"].$_REQUEST["send_time_mm"];
		if (is_numeric($strKtime)==false || strlen($strKtime) != 4 || $strDay == ""){
			$strKtime = "";
		}
		$strSQL="UPDATE mail_data SET " .
		  		"reserva_flg = 1, " .
		  		"reserva_date = '".$strDay."', " .
		  		"reserva_time = '".$strKtime."' " .
		  		"WHERE mail_id = ".$Max_id;
	}else{
		$strSQL="UPDATE mail_data SET " .
		  		"reserva_flg = 0," .
		  		"reserva_date = ''," .
		  		"reserva_time = '' " .
		  		"WHERE mail_id = ".$Max_id;
	}
	$objRecSet = pg_exec($strSQL);
	if($objRecSet==false){
	  echo("SQL実行に失敗しました(INSERT)");
	  exit;
	}
	//アラームデータ
	if($_REQUEST["alarm_flg"] == "1"){
		//日付
		$strDay = $_REQUEST["alarm_yyyy"].$_REQUEST["alarm_mm"].$_REQUEST["alarm_dd"];
		if (is_numeric($strDay)==false || strlen($strDay) != 8) {
			$strDay = "";
		}
		//時間
		$strAtime = $_REQUEST["alarm_hh"].$_REQUEST["alarm_time_mm"];
		if (is_numeric($strAtime)==false || strlen($strAtime) != 4 || $strDay == ""){
			$strAtime = "";
		}
		$strSQL = "INSERT INTO alarm_data (" .
				  "mail_id, " .
				  "message_date, " .
				  "message_time, " .
				  "subject_name, " .
				  "contents, " .
				  "admin_cd, " .
				  "send_date, " .
				  "send_flg, " .
				  "answer_id) " .
				  "VALUES (" .
				  $Max_id.", " .
				  "'".$strDay."', " .
				  "'".$strAtime."', " .
				  "'".$strKenmei2."', " .
				  $strAlarm_Text.", " .
				  $PHP_POST_SYAIN_CD.", " .
				  "Null, " .
				  "0, " .
				  (int)$_REQUEST["alarm_id"].") ";
		$objRecSet = pg_exec($strSQL);
		if($objRecSet==false){
			echo("SQL実行に失敗しました(INSERT)");
			exit;
		}
	}
	//既読者への自動再送信設定
	if($_REQUEST["kidok"] == "on"){
		//日付
		$strDay = $_REQUEST["kidok_yyyy"].$_REQUEST["kidok_mm"].$_REQUEST["kidok_dd"];
		if (is_numeric($strDay)==false || strlen($strDay) != 8) {
			$strDay = "";
		}
		//時間
		$strKtime = $_REQUEST["kidok_hh"].$_REQUEST["kidok_time_mm"];
		if (is_numeric($strKtime)==false || strlen($strKtime) != 4 || $strDay == "") {
			$strKtime = "";
		}
		$strSQL = "INSERT INTO kidok_data (" .
				  "mail_id, " .
				  "check_id, " .
				  "message_date, " .
				  "message_time, " .
				  "send_date, " .
				  "send_flg) " .
				  "VALUES (" .
				  $Max_id.", " .
				  "99, " .
				  "'".$strDay."', " .
				  "'".$strKtime."', " .
				  "Null".", " .
				  "0) ";
		$objRecSet = pg_exec($strSQL);
		if($objRecSet==false){
			echo("SQL実行に失敗しました(INSERT)");
			exit;
		}
	}
	//未読者への自動再送信設定
	if($_REQUEST["midok"] == "on"){
		//日付
		$strDay = $_REQUEST["kidok_yyyy"].$_REQUEST["kidok_mm"].$_REQUEST["kidok_dd"];
		if (is_numeric($strDay)==false || strlen($strDay) != 8) {
			$strDay = "";
		}
		//時間
		$strKtime = $_REQUEST["kidok_hh"].$_REQUEST["kidok_time_mm"];
		if (is_numeric($strKtime)==false || strlen($strKtime) != 4 || $strDay == "") {
			$strKtime = "";
		}
		$strSQL = "INSERT INTO kidok_data (" .
				  "mail_id, " .
				  "check_id, " .
				  "message_date, " .
				  "message_time, " .
				  "send_date, " .
				  "send_flg) " .
				  "VALUES (" .
				  $Max_id.", " .
				  "0, " .
				  "'".$strDay."', " .
				  "'".$strKtime."', " .
				  "Null".", " .
				  "0) ";		
		$objRecSet = pg_exec($strSQL);
		if($objRecSet==false){
			echo("SQL実行に失敗しました(INSERT)");
			exit;
		}
	}
	//回答期限
	$limit_date = $_REQUEST["limit_yyyy"].$_REQUEST["limit_mm"].$_REQUEST["limit_dd"].$_REQUEST["limit_time_hh"].$_REQUEST["limit_time_mm"];
	if(is_numeric($limit_date) == true && strlen($limit_date) == 12){
		$strSQL = "INSERT INTO res_time_tbl (" .
				  "mail_id, " .
				  "angou_id, " .
				  "date) " .
				  "VALUES (" .
				  $Max_id.", " .
				  "'".$angou."', " .
				  "'".$limit_date. "') ";
		$objRecSet = pg_exec($strSQL);
		if($objRecSet==false){
			echo("SQL実行に失敗しました(INSERT)");
			exit;
		}
	}
	//回答方法選択
	$sql = "SELECT * FROM mst_answer";
	$sql .= " WHERE pattern_id = '".$_REQUEST["pattern_id"]."'" ;
	$sql .= " ORDER BY pattern_id";
	$rtn = pg_exec($sql);
	if($rtn == false){
	  echo("SQL実行に失敗しました(SELECT)");
	  exit;
	}
	$objData = pg_fetch_object($rtn,0);
	for($intIdx = 1; $intIdx <= $objData->select_nm; $intIdx++){
		$name_nm[$intIdx]=pg_result($rtn, 0, "name".$intIdx."_nm");
	}
	$strSQL = "INSERT INTO answer_data (mail_id, select_nm";
	for ($intIdx = 1; $intIdx <= $objData->select_nm; $intIdx++){
		$strSQL .= ", name".$intIdx."_id, name".$intIdx."_nm";
	}
	$strSQL .= ") values ( $Max_id, $objData->select_nm";
	for ($intIdx = 1; $intIdx <= $objData->select_nm; $intIdx++){
		$strSQL .= ", $intIdx, '$name_nm[$intIdx]'";
	}
	$strSQL .= ")";
	$objRecSet = pg_exec($strSQL);
	if($objRecSet==false){
		echo("SQL実行に失敗しました(INSERT)");
		exit;
	}

	if($_REQUEST["radSendPtn"] == "1"){
	//個人配信
		$strWhere="";
		$strData=split(",", $_REQUEST["Send_User"]);
		for ($intIdx = 0; $intIdx < count($strData) - 1; $intIdx++){
			if ($strWhere == ""){
				$strWhere = " syain_cd = '".$strData[$intIdx]."' ";
			}else{
				$strWhere .= " OR syain_cd = '".$strData[$intIdx]."' ";
			}
		}
		$strSQL  = "SELECT * FROM syain_tbl ";
		$strSQL .= "WHERE ".$strWhere;
	}elseif($_REQUEST["radSendPtn"] == "2"){
	//グループ配信
		$strWhere="";
		$strData=split("/", $_REQUEST["group_id"]);
		for ($intIdx = 1; $intIdx < count($strData) - 1; $intIdx++){
			if ($strWhere==""){
				$strWhere="AND (group_info.group_id='".$strData[$intIdx]."'";
			}else{
				$strWhere=$strWhere." or group_info.group_id='".$strData[$intIdx]."'";
			}
		}
		$strWhere=$strWhere.")";
		$strSQL = "SELECT syain_tbl.syain_cd, syain_tbl.angou_cd, syain_tbl.mail_addr, syain_tbl.pc_mail_addr, name_kj_sei, name_kj_mei " .
				  "FROM group_info , syain_tbl " .
				  "WHERE syain_tbl.syain_cd = group_info.syain_cd " .
				  $strWhere." group by syain_tbl.syain_cd, syain_tbl.angou_cd, syain_tbl.mail_addr, syain_tbl.pc_mail_addr,name_kj_sei, name_kj_mei " .
				  "ORDER BY syain_tbl.syain_cd";
	}
	$objRecSet = pg_exec($strSQL);
	if($objRecSet==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	} 
}

?>
<!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="./style.css" rel="stylesheet" type="text/css">

<TITLE>送信中</TITLE>
<script language="javascript">
function pageJump(){
		document.frm.action = "SEND0020.php";
		document.frm.method="POST";
		document.frm.submit();
}
</script>
</HEAD>
<?PHP   if($tmp_flg==0){ ?>
<BODY onload="pageJump();" bgcolor="White">
<?PHP   }else{ ?>
<BODY bgcolor="White">
<?PHP   } ?>

<?PHP  
//ヘッダー
//include("./include/header.inc");
?>
<?PHP   if($tmp_flg==0){ ?>
<br>
<br>
<br>
<center>
<B><FONT color=blue size=5>送信中です。しばらく待ちください。</FONT></B>
<br>
<form name="temp">
<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   } ?>
<?PHP  
if($tmp_flg==0){
	$intRoop=1;
	
	$Mail_Nasi=0;
	$arrayToAdd = array();
	$logFrom = array(); //log配列初期化
	$logTo = array();
	$logType = array();
	$logDate = array();
	$intCountLog=0;
	for ($intCount = 0; $intCount<pg_numrows($objRecSet);){
		$Header="";//ヘッダー部クリア
		$objData = pg_fetch_object($objRecSet, $intCount);
		$strTo = $objData->pc_mail_addr;
		$strToMob= $objData->mail_addr;
		$strSendName=$objData->name_kj_sei.$objData->name_kj_mei;

		if($_REQUEST["SendType"] == "0"){
			if($objData->pc_mail_addr=="" && $objData->mail_addr==""){
					$Mail_Nasi=1;					//PCか携帯メールアドレスが未登録の人
					$SendRes = 3;
			}elseif($objData->pc_mail_addr=="" && $objData->mail_addr!=""){
				$SendRes = 1;
			}elseif($objData->pc_mail_addr!="" && $objData->mail_addr==""){
				$SendRes = 2;
			}elseif($objData->pc_mail_addr!="" && $objData->mail_addr!=""){
				$SendRes = 0;
			}
		}elseif($_REQUEST["SendType"] == "1"){
			if($objData->mail_addr==""){
				$Mail_Nasi=1;					//携帯メールアドレスが未登録の人
				$SendRes = 3;
			}else{
				$SendRes = 1;
			}
		}elseif($_REQUEST["SendType"] == "2"){
			if($objData->pc_mail_addr==""){
				$Mail_Nasi=1;					//PCメールアドレスが未登録の人
				$SendRes = 3;
			}else{
				$SendRes = 2;
			}
		}
		$strSubject = "=?iso-2022-jp?B?".base64_encode(jcodeconvert(stripslashes($strKenmei), 0, 3))."?=";
		$strComment = $PHP_POST_DB_USER_NAME."の皆様(".$strSendName."様)へ\n\n下記のアドレスからメール内容を確認してください。\n".
								$PONV2_URL_HEAD."USER0000.php?m=".$angou .
								"&s=" .$objData->angou_cd."&d=" .$PHP_POST_DB_ANGOU. "\n\n";
		$strComment = jcodeconvert($strComment, 1, 3);
		$Header="";//ヘッダー部クリア
		$Header1 = "";
		
		if($_REQUEST["NowSend"] != "on"){
			if($_REQUEST["SendType"] == "0" || $_REQUEST["SendType"] == "1"){
				if($strToMob!=""){
					$intBool2 = mail($strToMob,$strSubject,$strComment.$Comment_tel.$koukokuTEL.jcodeconvert(group_admin_addr($strSubmitAdd), 1, 3),$Header1,"-f ".$NOREPLY_ADDR);//携帯に送信
					$logFrom[$intCountLog] = $strSubmitAdd;
					$logTo[$intCountLog] = $strToMob;
					$logType[$intCountLog] = 1;
					$logDate[$intCountLog] = date("YmdHi");
					$intCountLog+=1;
				}
				$intBool2 = true;
			}else{
				$intBool2 = true;
			}
		}else{
			$intBool2 = true;
		}
		$Header="";//ヘッダー部クリア
	
		//PEARのmimeクラス設定
		$mime = new Mail_mime("\r\n");
		$mime->_build_params['text_charset'] = 'iso-2022-jp'; //本文テキストの文字コードをJISに設定する
		//本文のテキストの指定
		$mime->setTXTBody($strComment);
		
		//添付ファイル
		if ($f_attach) {
				//添付ファイルの指定
				//$mime->addAttachment($_FILES['f_attach']['tmp_name'], $_FILES['f_attach']['type'], mb_convert_encoding($_FILES['f_attach']['name'],"SJIS","UTF-8"));
				$mime->addAttachment($_FILES['f_attach']['tmp_name'], $_FILES['f_attach']['type'], jcodeconvert($_FILES['f_attach']['name'], 1, 3));
		}
	
		//メールボディの取得
		$strComment = $mime->get();
	
		//メールヘッダの取得
		$Headers = $mime->headers($Headers);
		
		//メールヘッダの配列を文字列に組み立てる
		while (list($key,$val)=each($Headers)) {
			$Header .= $key.": ".$val."\r\n";
		}
		if($_REQUEST["NowSend"] != "on"){
			if($_REQUEST["SendType"] == "0" || $_REQUEST["SendType"] == "2"){
				if($strTo!=""){
					$intBool = mail($strTo, $strSubject, $strComment.$Comment_pc.$koukokuPC.jcodeconvert(group_admin_addr($strSubmitAdd), 1, 3),$Header,"-f ".$NOREPLY_ADDR);//PCに送信
					$logFrom[$intCountLog] = $strSubmitAdd;
					$logTo[$intCountLog] = $strToMob;
					$logType[$intCountLog] = 0;
					$logDate[$intCountLog] = date("YmdHi");
					
					$intCountLog+=1;
				}
				$intBool = true;
			}else{
				$intBool = true;
			}
		}else{
			$intBool = true;
		}
		if($intBool && $intBool2){
			if($Mail_Nasi != 1){
				$objData = pg_fetch_object($objRecSet, $intCount);
				$strSQL = "INSERT INTO mail_info (".
				"mail_id, " .
				"syain_cd, " .
				"check_flg) " .
				"VALUES (" .
				$Max_id.", " .
				"'".$objData->syain_cd."', " .
				"0)";
				$objInsRet = pg_exec($strSQL);
				if($objInsRet==false){
					echo $strSQL;
					echo("SQL実行に失敗しました(INSERT)");
					exit;
				}
			}else{
				$objData = pg_fetch_object($objRecSet, $intCount);
				$strSQL = "INSERT INTO mail_info (".
					"mail_id, " .
					"syain_cd, " .
					"check_flg) " .
					"VALUES (" .
					$Max_id.", " .
					"'".$objData->syain_cd."', " .
					"100)";
				$objInsRet = pg_exec($strSQL);
				if($objInsRet==false){
					echo $strSQL;
					echo("SQL実行に失敗しました(INSERT)");
					exit;
				}
			}
			//送信機種保存
			$strSQL = "INSERT INTO mail_send_tbl (" .
				"mail_id, " .
				"syain_cd, " .
				"send_flg) " .
				  "VALUES (" .
				$Max_id.", " .
				"'".$objData->syain_cd."', " .
				$SendRes.")";
			$objInsRet = pg_exec($strSQL);
			if($objInsRet==false){
				echo("SQL実行に失敗しました(INSERT)");
				exit;
			}
		}
		
		$intCount=$intCount+1;					//何人に送ったか
		$Mail_Nasi=0;//初期化


		//echo $intCountLog." 通おくったぜ　べいべ！<br>";
		echo "<script language='javascript'>";
		echo "document.getElementById('maxcount').innerHTML ='".pg_numrows($objRecSet)."';";
		echo "document.getElementById('count').innerHTML ='".$intCount."';";
		echo "</script>";
		ob_flush();
		flush();
		
	}
	if($PHP_POST_DB_FLG==6){
		func_point_decrement($PHP_POST_SYAIN_ID,$intCount,0); //ポイント減算
		func_LogInput($PHP_POST_SYAIN_ID,$logFrom,$logTo,$logType,$logDate,$intCountLog);
	}
}
?>
<FORM name='frm' action="SEND0000.php" method="POST">
<input type="hidden" name="alarm_flg"  value="<?PHP   echo $_REQUEST["alarm_flg"]; ?>">
<input type="hidden" name="SendType"   value="<?PHP   echo $_REQUEST["SendType"] ?>">
<input type="hidden" name="radSendPtn" value="<?PHP   echo $_REQUEST["radSendPtn"] ?>">
<input type="hidden" name="group_id"   value="<?PHP   echo $_REQUEST["group_id"] ?>">
<input type="hidden" name="Send_User"  value="<?PHP   echo $_REQUEST["Send_User"] ?>">

<input type="hidden" name="date_yyyy" value="<?PHP   echo $_REQUEST["date_yyyy"] ?>">
<input type="hidden" name="date_mm"   value="<?PHP   echo $_REQUEST["date_mm"] ?>">
<input type="hidden" name="date_dd"   value="<?PHP   echo $_REQUEST["date_dd"] ?>">
<input type="hidden" name="time_hh"   value="<?PHP   echo $_REQUEST["time_hh"] ?>">
<input type="hidden" name="time_mm"   value="<?PHP   echo $_REQUEST["time_mm"] ?>">

<input type="hidden" name="kidok_yyyy"    value="<?PHP   echo $_REQUEST["kidok_yyyy"] ?>">
<input type="hidden" name="kidok_mm"      value="<?PHP   echo $_REQUEST["kidok_mm"] ?>">
<input type="hidden" name="kidok_dd"      value="<?PHP   echo $_REQUEST["kidok_dd"] ?>">
<input type="hidden" name="kidok_hh"      value="<?PHP   echo $_REQUEST["kidok_hh"] ?>">
<input type="hidden" name="kidok_time_mm" value="<?PHP   echo $_REQUEST["kidok_time_mm"] ?>">
<input type="hidden" name="kidok"         value="<?PHP   echo $_REQUEST["kidok"] ?>">
<input type="hidden" name="midok"         value="<?PHP   echo $_REQUEST["midok"] ?>">

<input type="hidden" name="send_yyyy"    value="<?PHP   echo $_REQUEST["send_yyyy"] ?>">
<input type="hidden" name="send_mm"      value="<?PHP   echo $_REQUEST["send_mm"] ?>">
<input type="hidden" name="send_dd"      value="<?PHP   echo $_REQUEST["send_dd"] ?>">
<input type="hidden" name="send_hh"      value="<?PHP   echo $_REQUEST["send_hh"] ?>">
<input type="hidden" name="send_time_mm" value="<?PHP   echo $_REQUEST["send_time_mm"] ?>">
<input type="hidden" name="NowSend"      value="<?PHP   echo $_REQUEST["NowSend"] ?>">

<input type="hidden" name="radSend"    value="<?PHP   echo $_REQUEST["SendType"] ?>">
<input type="hidden" name="TITLE"      value="<?PHP   echo $_REQUEST["kenmei"] ?>">
<input type="hidden" name="rad_tei"    value="<?PHP   echo $_REQUEST["tei"] ?>">
<input type="hidden" name="MAIL_TEXT"  value="<?PHP   echo $_REQUEST["text"] ?>">
<input type="hidden" name="pattern_id" value="<?PHP   echo $_REQUEST["pattern_id"] ?>">

<input type="hidden" name="limit_yyyy"    value="<?PHP   echo $_REQUEST["limit_yyyy"] ?>">
<input type="hidden" name="limit_mm"      value="<?PHP   echo $_REQUEST["limit_mm"] ?>">
<input type="hidden" name="limit_dd"      value="<?PHP   echo $_REQUEST["limit_dd"] ?>">
<input type="hidden" name="limit_time_hh" value="<?PHP   echo $_REQUEST["limit_time_hh"] ?>">
<input type="hidden" name="limit_time_mm" value="<?PHP   echo $_REQUEST["limit_time_mm"] ?>">

<input type="hidden" name="view_flg" value="<?PHP   echo $_REQUEST["view_flg"] ?>">
<CENTER>
<TABLE border=0 cellspacing="0" cellpadding="3" width="544">
  <TR>
    <TD ALIGN="CENTER">
	<?PHP   if($tmp_flg==0){ ?>

	<?PHP   }else{ ?>
	<INPUT type="submit" name="submit_btn" value="戻　る">
	<?PHP   } ?>
    </TD>
  </TR>
</TABLE>
<br>

<div align="center">
</div>

<br>
<TABLE border=1 bordercolor="#008080" width="544">
<TBODY>
<?PHP   if($tmp_flg==0){ ?>

<?PHP   }else{ ?>
  <TR>
    <TD bgcolor="#FFCC99"><CENTER><FONT size="5">ファイルサイズが２Ｍを超えています。<BR>
  　添付ファイル容量<?PHP   echo $_FILES['f_attach']['size'] ?>バイト</FONT></CENTER></TD>
  </TR>
<?PHP   } ?>
</TBODY>
</TABLE>
<BR>
<BR>
<BR>
</CENTER>
</BODY>
</HTML>