<?PHP  
//*****************************************************************************
//* 
//* プログラム名：グループ送信配信画面(講義情報配信 流用)
//* プログラムID：group_sendmail.php
//* 機能        ：入力されたグループ情報をメールで送信(流用元 入力された講義情報をメールで送信する)
//* 作成者      ：Y.Fusimi(MTC)(Y.Ogawa(MTC))
//* 
//*****************************************************************************
header("Content-type: text/html; charset=Shift_JIS");
	$date_yyyy = $_GET['d_y'];
	$date_mm = $_GET['d_m'];
	$date_dd = $_GET['d_d'];
	$time_hh = $_GET['t_h'];
	$time_mm = $_GET['t_m'];
	$kidok_yyyy = $_GET['k_y'];
	$kidok_mm = $_GET['k_m'];
	$kidok_dd = $_GET['k_d'];
	$kidok_hh = $_GET['k_h'];
	$kidok_time_mm = $_GET['k_t_m'];
	$kidok = $_GET['kk'];
	$midok = $_GET['mk'];
	$send_yyyy = $_GET['s_y'];
	$send_mm = $_GET['s_m'];
	$send_dd = $_GET['s_d'];
	$send_hh = $_GET['s_h'];
	$send_time_mm = $_GET['s_t_m'];
	$NowSend = $_GET['NS'];
	$group_dat = $_GET['g_d'];
	$SendType = $_GET['ST'];
	$kenmei = $_GET['ken'];
	$tei = $_GET['tei'];
	$text = $_GET['text'];
	$pattern_id = $_GET['p'];
	$ALARM_YEAR = $_GET['a_y'];
	$ALARM_MONTH = $_GET['a_m'];
	$ALARM_DAY = $_GET['a_d'];
	$ALARM_HOUR = $_GET['a_h'];
	$ALARM_MINUTE = $_GET['a_t_m'];
	$ALARM = $_GET['ALM'];
	$ALARM_FLG = $_GET['ALM_F'];
	$group_id = $_GET['g_id'];
	$submit_on = $_GET['sub_on'];
	$KENMEI = $_GET['KEN'];
	$GROUP2 = $_GET['GR2'];
	$dkey = $_GET['dkey'];
	$limit_yyyy = $_GET['l_y'];
	$limit_mm = $_GET['l_m'];
	$limit_dd = $_GET['l_d'];
	$limit_time_hh = $_GET['l_h'];
	$limit_time_mm = $_GET['l_mm'];
	$SYAIN_CD= $_GET['SYAIN_CD'];
	$PHP_SYAIN_CD = $_GET['PHP_SYAIN_CD'];
	$PHP_POST_SYAIN_CD = $_GET['PHP_SYAIN_CD'];
	$PHP_DB_NAME = $_GET['PHP_DB_NAME'];
	$PHP_POST_DB_FLG = $_GET['PHP_POST_DB_FLG'];
	$PHP_POST_DB_USER_NAME = $_GET['PHP_POST_DB_USER_NAME'];
	$POST_DB_PEY_FLG = $PHP_POST_DB_FLG;
	$PHP_POST_DB_ANGOU=$dkey;

	if($date_dd=="" || $date_dd=="null"){$date_yyyy="";}
	if($kidok_mm=="" || $kidok_mm=="null"){$kidok_yyyy="";}
	if($send_mm=="" || $send_mm=="null"){$send_yyyy="";}
	if($ALARM_MONTH=="" || $ALARM_MONTH=="null"){$ALARM_YEAR="";}

include("../include/dbcon2.inc");
	$strSQL = "SELECT * " .
			  "FROM mst_kanri " .
			  "WHERE angou = '" . $dkey . "'";
			  
	$objRecSet = pg_exec($strSQL);
	if($objRecSet==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	$kanriflg=pg_result($objRecSet,0,"kanriflg");
	if($kanriflg==9){	 
		 $PHP_POST_DB_FLG_KOUKOKU=0;
	}else{
		 $PHP_POST_DB_FLG_KOUKOKU=1;
	}
//***************************
//*　インクルードファイル
//***************************
include("../include/getWeekDay.inc");
include("../include/getDomain.inc");
include("../include/dbset.inc");
include("../include/dbcon.inc");
include("../include/jcode.phps");
include("../include/mime.php");
include("../include/mpoint.inc");
include("../include/mlogget.inc");
include("../../include/mtcnews.inc");

//$Comment_tel = "このメールはメール配信システム「め〜るNiポン！」より配信されています"."\n".
//	"詳細はこちらをご覧ください"."\n".
//	"↓↓↓↓↓↓"."\n".
//	"http://125.206.112.127/mail_ni_pon/reg/user/m_info.html"."\n";
//$Comment_tel = jcodeconvert($Comment_tel, 2, 3);
$Comment_tel = jcodeconvert($Mail_Keitai, 1, 3);



//$Comment_pc  = "このメールはメール配信システム「め〜るNiポン！」より配信されています"."\n".
//	"詳細はこちらをご覧ください"."\n".
//	"↓↓↓↓↓↓"."\n".
//	"http://www.media-tek.co.jp/mail_ni_pon/"."\n";
//$Comment_pc = jcodeconvert($Comment_pc, 2, 3);
$Comment_pc = jcodeconvert($Mail_PC, 1, 3);

if($PHP_POST_DB_FLG_KOUKOKU==0){
	$koukokuTEL = "";
	$koukokuPC = "";
}else{
	//広告
//	require '../../afm_f.php';
//	$koukokuTEL = jcodeconvert(AFFTEL(1), 0, 2);
//	$koukokuPC = jcodeconvert(AFFPC(1),0,2);
}

//$koukokuPC .= "\n";
//$koukokuPC .= "--PR------------------------------------------------------------------\n";
//$koukokuPC .= "　　　あなたのグループもめ〜るNiポン！を使ってみませんか？\n";
//$koukokuPC .= "　　　　　無料でご利用いただけます。\n";
//$koukokuPC .= "　　　　　　　　http://www.media-tek.co.jp/mail_ni_pon/\n";
//$koukokuPC .= "------------------------------------------------------------------PR--\n";
//$koukokuPC = jcodeconvert($koukokuPC,0,2);

$KAKUTYOU_NASI	=0; //拡張機能なしの場合
$KAKUTYOU_ALARM	=1; //拡張機能（アラーム）追加時
$KAKUTYOU_TENPU =2; //拡張機能（添付ファイル）追加時
$KAKUTYOU_ALL =9; //拡張機能（全て）追加時
//***************************
//*　初期処理
//***************************
$objConn			= null;	//接続オブジェクト
$objRecSet			= null;	//レコードセットオブジェクト
$objInsRet			= null;	//レコードセットオブジェクト

$strSQL				= "";	//SQL文

$intmail_id			= 0;
$strDate			= "";	//日付
$strTime			= "";	//時間
$strGroup2_id		= "";	//グループ2ID
$strGroup1_id		= "";	//グループ1ID
$strKenmei			= "";	//件名
$strText			= "";	//本文
$strSubmitTime		= "";	//送信日時
$strSubmitAdd		= "";	//送信者アドレス
$strSubmitName		= "";	//送信者(管理者)の名前
$strDomeName		= "";	//ドメイン
$yes_name			= "";	//YESの返事の名前
$no_name			= "";	//NOの返事の名前

$intMailCount		= 0;
$intGroupCount		= 0;

$strMail_Date		= "";
$strMail_Group2		= "";
$strMail_Group1		= "";
$strMail_Kenmei		= "";
$strMail_Text		= "";

$strTo				= "";
$strTo				= "";
$strA_flg			= 0;
$strAlarm_Text      = "";
    	
$intDisp_Count		= 0;
$strDisp_Name		= "";	//表示項目名

//***************************
//* 管理者情報 
//***************************
$strSQL = "SELECT syain_cd FROM mail_admin";
$objAdmRec = pg_exec($strSQL);
if($objAdmRec==false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
}
if (pg_numrows($objAdmRec)>0){
		$objAdmData = pg_fetch_object($objAdmRec, 0);
		$PHP_POST_SYAIN_CD = $objAdmData->syain_cd;
}else{
		echo '<HTML>';
		echo '<HEAD>';
		echo '<META http-equiv="Content-Type" content="text/html; charset=Shift_JIS">';
		echo '<TITLE>め〜るNiポン！</TITLE>';
		echo '</HEAD>';
		echo '<BODY>';
		echo '<form>';
		echo "管理者を設定してください。";
		echo "</form>";
		echo "</BODY>";
		echo "</HTML>";
		exit;
}

//***************************
//* メイン処理
//***************************
//添付ファイル容量チェック
$tmp_flg=0;
if($_FILES['f_attach']['name']!=""){
	if($_FILES['f_attach']['size'] > 2000000){
		$tmp_flg=1; //２Ｍ以上は送信しない
	}else{
		$tmp_flg=0; //２Ｍ以下は送信する
	}
}

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, 0, 1);
    
    //日付
    if($date_mm==""){$date_yyyy="";}
    $strDate = $date_yyyy . $date_mm . $date_dd;
    if (is_numeric($strDate)==false) {
    	$strDate = "''";
    }else{
    	$strDate = "'" . $strDate . "'";
    }

    
    //時間
    $strTime = $time_hh . $time_mm;

    if (is_numeric($strTime)==false) {
    	$strTime = "";
    }else{
    	$strTime = "'" . $strTime . "'";
    }
	
	$syain_max=count($SYAIN_CD);
    //個人データ
    for($i=0;$i<$syain_max;$i++){
        $strSyain_cd[$i] = $SYAIN_CD[$i];
        if ($strSyain_cd[$i]=="") {
        	$strSyain_cd[$i] = "";
        }else{
        	$strSyain_cd[$i] = JcodeConvert($strSyain_cd[$i], 1, 1);
        }
    }

    //件名
    $strKenmei = "(〒)";
    if($tei=="on"){
    	$strKenmei .= JcodeConvert($strDisp_Name,0,2) . ":" . $kenmei;
    }else{
    	$strKenmei .= $kenmei;
    }
    if ($strKenmei == "") {
    	$strKenmei = "";
    }else{
    	$strKenmei = JcodeConvert($strKenmei, 0, 1);
    }

//    $strKenmei = "";
    //本文
    $strText = $text;
    if ($strText == "") {
    	$strText = "";
    }else{
    	$strText = JcodeConvert($strText, 0, 1);
    }
//    $strText = "";
    //管理者ID
    $strKanri=$PHP_POST_SYAIN_CD;
    
    //拡張フラグ
//    if($PHP_POST_DB_FLG==$KAKUTYOU_ALARM or $PHP_POST_DB_FLG==$KAKUTYOU_ALL){
    	//アラームフラグ
    	if($ALARM_FLG==1){
    		$strA_flg = 1;
    		//内容
    		//アラーム用
            $strMes = $date_yyyy . "年" . intval(substr($date_mm,0,2)) . "月" . intval(substr($date_dd,0,2)) . "日";
            if ($strTime!="") {
            	$strMes = $strMes . intval(substr($time_hh,0,2)) . "時" . intval(substr($time_mm,0,2)) . "分";
            }
    		$strAlarm_Text = "'「" . JcodeConvert($strKenmei, 0, 2) . "の開催日：" . $strMes . "」の日時が近づいております。詳細は下記ＵＲＬをご覧ください。" . "'";
			$strAlarm_Text = JcodeConvert($strAlarm_Text, 0, 1);
    		//件名
            $strKenmei2 = "(〒お知らせ)";
            if($tei=="on"){
            	$strKenmei2 .= JcodeConvert($strDisp_Name,0,2) . ":" . $kenmei;
            }else{
            	$strKenmei2 .= $kenmei;
            }
            $strKenmei2 = JcodeConvert($strKenmei2,0,1);
    	}
//    }
    
    //送信日時
    $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 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();
    
    $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);
    
        for ($i = 0; $i < 10; $i++){
          $tmp_num = rand(0, 51);
          $strTmp = $strTmp . $strArray[$tmp_num];
        }
    	
        $angou = $strTmp;
        $sql = "SELECT * FROM mail_data";
        $sql .= " WHERE angou_id = '$angou'";
        $rtn = pg_exec($pg_con, $sql);
        if($rtn == false){
          echo "SQLの実行に失敗しました。(#1)";
          exit;
        }
        $num = pg_numrows($rtn);
    }
    $strAngou_id = "'" . $angou . "'";
    
    if($strTime!=""){		//時、分が入っているかどうか
        $strSQL = "INSERT INTO mail_data (" .
        		  "mail_id, " .
        		  "angou_id, " .
        		  "message_date, " .
        		  "message_time, " .
        		  "subject_name, " .
        		  "contents, " .
        		  "admin_cd, " .
        		  "send_date, " .
        		  "send_alarm)" .
        		  "VALUES (" .
                  $Max_id . ", " .
                  $strAngou_id . ", " .
                  $strDate . ", " .
                  $strTime . ", " .
                  "'" . $strKenmei . "'" . ", " .
                  "'" . $strText . "'". ", " .
                  $strKanri . ", '" .
                  $strSubmitTime . "', " .
                  $strA_flg . ") ";
    }else{
       $strSQL = "INSERT INTO mail_data (" .
        		  "mail_id, " .
        		  "angou_id, " .
        		  "message_date, " .
        		  "subject_name, " .
        		  "contents, " .
        		  "admin_cd, " .
        		  "send_date, " .
        		  "send_alarm)" .
        		  "VALUES (" .
                  $Max_id . ", " .
                  $strAngou_id . ", " .
                  $strDate . ", " .
                  "'" . $strKenmei . "'" . ", " .
                  "'" . $strText . "'". ", " .
                  $strKanri . ", '" .
                  $strSubmitTime . "', " .
                  $strA_flg . ") ";
    }
    $objRecSet = pg_exec($strSQL);
    if($objRecSet==false){
        echo("SQL実行に失敗しました(INSERT)");
        exit;
    }

	//送信日時設定
    if($NowSend=="on"){
		$NowSendFlg=1;
    	//日付
    	$strDay="";
        $strDay = $send_yyyy . $send_mm . $send_dd;
        if (is_numeric($strDay)==false) {
        	$strDay = "";
        }else{
        	$strDay = "'" . $strDay . "'";
        }
    	//時間
    	$strKtime = $send_hh . $send_time_mm;
        if (is_numeric($strKtime)==false) {
        	$strKtime = "";
        }else{
        	$strKtime = "'" . $strKtime . "'";
        }
        
			$strSQL="UPDATE mail_data SET " .
			  	    "reserva_flg = " . $NowSendFlg . ", " .
			  	    "reserva_date = " . $strDay . ", " .
			  	    "reserva_time = " . $strKtime . " " .
			  	    "WHERE mail_id = " . $Max_id;

			$objRecSet = pg_exec($strSQL);
			if($objRecSet==false){
			  echo("SQL実行に失敗しました(INSERT)");
			  exit;
			}
    }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;
			}

    	  $NowSendFlg=0;
    	  $strDay ="";
    	  $strKtime="";
    }
    
    //アラームデータ
//    if($PHP_POST_DB_FLG==$KAKUTYOU_ALARM or $PHP_POST_DB_FLG==$KAKUTYOU_ALL){
    	if($ALARM_FLG==1){
    		//日付
            $strDay = $ALARM_YEAR . $ALARM_MONTH . $ALARM_DAY;
            if (is_numeric($strDay)==false) {
            	$strDay = "";
            }else{
            	$strDay = "'" . $strDay . "'";
            }
    		//時間
    		$strAtime = $ALARM_HOUR . $ALARM_MINUTE;
            if (is_numeric($strAtime)==false) {
            	$strAtime = "";
            }else{
            	$strAtime = "'" . $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 . ", " .
                      $strKanri . ", " .
                      "Null" . ", " .
                      0 . ", " .
                      $ALARM . ") ";
            $objRecSet = pg_exec($strSQL);
            if($objRecSet==false){
                echo("SQL実行に失敗しました(INSERT)");
                exit;
            }
    	}
//    }
    
    //既読者への自動再送信設定
    if($kidok=="on"){
    	//日付
        $strDay = $kidok_yyyy . $kidok_mm . $kidok_dd;
        if (is_numeric($strDay)==false) {
        	$strDay = "";
        }else{
        	$strDay = "'" . $strDay . "'";
        }
    	//時間
    	$strKtime = $kidok_hh . $kidok_time_mm;
        if (is_numeric($strKtime)==false) {
        	$strKtime = "";
        }else{
        	$strKtime = "'" . $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($midok=="on"){
    	//日付
    	$strDay="";
        $strDay = $kidok_yyyy . $kidok_mm . $kidok_dd;
        if (is_numeric($strDay)==false) {
        	$strDay = "";
        }else{
        	$strDay = "'" . $strDay . "'";
        }
    	//時間
    	$strKtime = $kidok_hh . $kidok_time_mm;
        if (is_numeric($strKtime)==false) {
        	$strKtime = "";
        }else{
        	$strKtime = "'" . $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;
        }
    }
    	
    //*************************
    //      回答方法選択
    //*************************
    
    $sql = "SELECT * FROM mst_answer";
    $sql .= " WHERE pattern_id = '" . $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(trim($limit_yyyy)!="null" && trim($limit_mm)!="null" && trim($limit_dd)!="null" && trim($limit_time_hh)!="null" && trim($limit_time_mm)!="null"){
		$limit_date = $limit_yyyy.$limit_mm.$limit_dd.$limit_time_hh.$limit_time_mm;
		//回答期限セット
		$strSQL = "INSERT INTO res_time_tbl (" .
			"mail_id, " .
			"angou_id, " .
			"date) " .
			"VALUES (" .
			$Max_id . ", " .
			"".$strAngou_id . ", " .
			"'".$limit_date. "') ";
		$objRecSet = pg_exec($strSQL);
		if($objRecSet==false){
			echo("SQL実行に失敗しました(INSERT)");
			exit;
		}
	}


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

	$logFrom = array(); //log配列初期化
	$logTo = array();
	$logType = array();
	$logDate = array();
    for ($intCount = 0; $intCount<$syain_max;){

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

	    	$strSQL = "SELECT angou_cd, mail_addr, pc_mail_addr, name_kj_sei, name_kj_mei " .
        		  "FROM syain_tbl " .
        		  "WHERE syain_cd = " . $strSyain_cd[$intCount] . " " .
        		  "ORDER BY syain_cd";
		    $objRecSet = pg_exec($strSQL);
		    if($objRecSet==false){
		    	   echo("SQL実行に失敗しました(SELECT)");
		    	   exit;
		    }  
		    
		    $objData = pg_fetch_object($objRecSet, 0);
				$strAngou = $objData->angou_cd;
				$strTo = $objData->pc_mail_addr;
				$strToMob= $objData->mail_addr;
				$strToName=$objData->name_kj_sei.$objData->name_kj_mei;
				if($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($SendType==1){
				    	if($objData->mail_addr==""){
				        	$Mail_Nasi=1;					//携帯メールアドレスが未登録の人
				        	$SendRes = 3;
				      }else{
				      	$SendRes = 1;
				      }
				 }elseif($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."の皆様(".jcodeconvert($strToName,0,2)."様)へ\n\n下記のアドレスからメール内容を確認してください。\n" . 
    				  "http://" . $strDomeName . "/mail_ni_pon_v2/USER0000.php?m=" . $angou .
    				  "&s=" .$objData->angou_cd."&d=" .$PHP_POST_DB_ANGOU. "\n\n";

    				  //"http://" . $strDomeName . "/post_ni_pon/check_update/mail_check.php?m=" . $Max_mail .
    				  //"&s=" .$objData->syain_cd."&d=" .$PHP_POST_DB_ANGOU. "\n";
    				  
    	$strComment = jcodeconvert($strComment, 2, 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($NowSend!="on"){
	    	if($SendType==0 || $SendType==1){
	    		$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;
		}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_encode_mimeheader($_FILES['f_attach']['name']));
    		$mime->addAttachment($_FILES['f_attach']['tmp_name'], $_FILES['f_attach']['type'], jcodeconvert($_FILES['f_attach']['name'],0,3));
        }
    
        //メールボディの取得
        $strComment = $mime->get();
    
        //メールヘッダの取得
        $Headers = $mime->headers($Headers);
        
        //メールヘッダの配列を文字列に組み立てる
        while (list($key,$val)=each($Headers)) {
            $Header .= $key.": ".$val."\r\n";
        }
      if($NowSend!="on"){
	    	if($SendType==0 || $SendType==2){
	    		$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;
			}else{
				$intBool = true;
			}
		}else{
			$intBool = true;
		}
    	if($intBool && $intBool2){
    		if($Mail_Nasi != 1){
            	$strSQL = "INSERT INTO mail_info (" . 
        				  "mail_id, " .
        				  "syain_cd, " .
        				  "check_flg) " .
        				  "VALUES (" .
            	          $Max_id . ", " .
            	          "'" . $strSyain_cd[$intCount] . "', " .
            	          "0)";
            	$objInsRet = pg_exec($strSQL);
            	if($objInsRet==false){
            		echo("SQL実行に失敗しました(INSERT)");
            		exit;
            	}
    		}else{
            	$strSQL = "INSERT INTO mail_info (" . 
        				  "mail_id, " .
        				  "syain_cd, " .
        				  "check_flg) " .
        				  "VALUES (" .
            	          $Max_id . ", " .
            	          "'" . $strSyain_cd[$intCount] . "', " .
            	          "100)";
            	$objInsRet = pg_exec($strSQL);
            	if($objInsRet==false){
            		echo("SQL実行に失敗しました(INSERT)");
            		exit;
            	}
			}
			//送信機種保存
      	$strSQL = "INSERT INTO mail_send_tbl (" .
      		      "mail_id, " .
      		      "syain_cd, " .
      		      "send_flg) " .
  				  "VALUES (" .
      	    	  $Max_id . ", " .
      	   		   "'" . $strSyain_cd[$intCount] . "', " .
      	    	  $SendRes.")";
      	$objInsRet = pg_exec($strSQL);
      	if($objInsRet==false){
      		echo("SQL実行に失敗しました(INSERT)");
      		exit;
      	}
    	}
    	$intCount=$intCount+1;					//何人に送ったか
    	$Mail_Nasi=0;//初期化
    }
	if($PHP_POST_DB_FLG==6){
//		$sql = "SELECT * FROM mst_answer";
//		$sql .= " WHERE del_flg = 0";
//		$sql .= " and pattern_id=".$pattern_id."";
//		$rtn = pg_exec($sql);
//		if($rtn == false){
//			echo("SQL実行に失敗しました(SELECT)");
//			exit;
//		}
//		$num = pg_numrows($rtn);
//		$data = pg_fetch_object($rtn, 0);
//		if($data->select_nm!=0){
			func_point_decrement($dkey,$intCount,0); //ポイント減算
//		}
		func_LogInput($dkey,$logFrom,$logTo,$logType,$logDate,$intCountLog);
	}

}
?>

<HTML>
<HEAD>

<TITLE>送信完了</TITLE>
</HEAD>
<BODY bgcolor="White">

<div id="header">
<h1 title="めーるNiポン！">めーるNiポン！</h1>
</div>

<FORM name='frm' action="group_Tran.php" method="get">

<CENTER>
	<?PHP   if($tmp_flg==0){ ?>
    	<A href="../admin/simple_index.php?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_POST_DB_USER_NAME=<?PHP   echo $PHP_POST_DB_USER_NAME ?>">メニューへ戻る</A><br>
	<?PHP   }else{ ?>
		<INPUT type="submit" name="submit" value="戻　る">
	<?PHP   } ?>
<br>
    入力された情報を送信しました。

<BR>
<BR>
</CENTER>
<HR width="100%">
<?PHP  
	echo "<font size=\"2\">[ASP / SaaS 製品情報]<br />".jcodeconvert($Mail_Keitai_news,1,2)."</font>";
?>
<HR width="100%">
<CENTER>
<font color="#666666">Copyright (C) 2004 Media Tech Inc. All rights reserved.</font>
</CENTER>
</form>
</BODY>
</HTML>