<?php 
//*****************************************************************************
//* 
//* プログラム名：ＴｏＤｏ
//* プログラムID：TDL900.php
//* 機能        ：ＴｏＤｏ 更新処理
//* 作成者      ：
//* 
//*****************************************************************************

header("Content-type: text/html; charset=EUC-JP");

include("include/session_start.inc");
include("include/SessionChk.inc");


include('./include/smarty.conf');
$strDBinc="include/dbcon.inc";
include($strDBinc);

include("inc/mail_add.inc");
include("inc/subRepURI.inc");

$strSQL="";
$objRec="null";

//共通
//20081008 get→post
/*
$txtCTGName = mb_convert_encoding(subRepURI($txtCTGName), "EUC-JP", "auto");
$txtTodo = mb_convert_encoding(subRepURI($txtTodo), "EUC-JP", "auto");
$txtNaiyo = mb_convert_encoding(subRepURI($txtNaiyo), "EUC-JP", "auto");
*/

$txtCTGName = mb_convert_encoding($txtCTGName, "eucjp-win", "auto");
$txtTodo = mb_convert_encoding($txtTodo, "eucjp-win", "auto");
$txtNaiyo = mb_convert_encoding($txtNaiyo, "eucjp-win", "auto");

//アラーム
if($radALM == 1){
	$alarm = $alarm_y.$alarm_m.$alarm_d.$alarm_h."00";
}else{
	$alarm = "";
}

//カテゴリ新規作成
if($radCTG == 1){
	//番号設定
	$strSQL = "select * from mst_todo_category where syain_cd ='".$PHP_SYAIN_CD."' order by category_syubetu desc";
	$objRec = pg_exec($strSQL);
	if($objRec == false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if (pg_numrows($objRec) > 0){
		$objNo = pg_fetch_object($objRec, 0);
		$seqCTG = ($objNo->category_syubetu) + 1;
	}else{
		$seqCTG = 1;
	}
	
	//カテゴリ登録
	$strSQL = "insert into mst_todo_category (syain_cd, category_syubetu, category_name) values('".$PHP_SYAIN_CD."', ".$seqCTG.", '".addslashes($txtCTGName)."')";
	$objRec = pg_exec($strSQL);
	if($objRec == false){
		echo("SQL実行に失敗しました(INSERT)");
		exit;
	}
	//ムームデータに番号上書き
	$selCTG_0 = $seqCTG;
}

//カテゴリ　共有の場合は0で！
if(trim($stradd) != "/"){
	$selCTG_0 = 0;
	//自分は抜いておけ！
	//$stradd = str_replace("/".$PHP_SYAIN_CD."/", "/", $stradd)
}

//期間
if($chkKikan == 1){
	$kikan_S = $start_y.$start_m.$start_d.$start_h."00";
	$kikan_E = $end_y.$end_m.$end_d.$end_h."00";	
}else{
	$kikan_S = "";
	$kikan_E = "";
}

//重要度


//新規
if($mode == 1){
	//番号取得
	$strSQL = "select seq from todo_tbl order by seq desc";
	$objRec = pg_exec($strSQL);
	if($objRec == false){
		echo("SQL実行に失敗しました(SELECT)");
		exit;
	}
	if (pg_numrows($objRec) > 0){
		$objNo = pg_fetch_object($objRec, 0);
		$seqNo = ($objNo->seq) + 1;
	}else{
		$seqNo = 1;
	}

	if($stradd != "/"){
		$stradd = "/".$stradd;
	}

	//いんさーと
	$strSQL = "insert into todo_tbl ";
	$strSQL .= "(seq, sakusei_cd, category_id, todo_name, start_date, end_date, kikan_flg, juyodo, naiyo, kyoyu_menber, alarm_date, sinchoku, biko, end_flg) ";
	$strSQL .= "values(".$seqNo.", '".$PHP_SYAIN_CD."', ".$selCTG_0.", '".addslashes($txtTodo)."', '".$kikan_S."', '".$kikan_E."', ".$chkKikan.", ".$hidImp.", '".addslashes($txtNaiyo)."', '".$stradd."' ,'".$alarm."', ".$progress.", '', 0)";
	$objRec = pg_exec($strSQL);
	if($objRec == false){
		echo("SQL実行に失敗しました(INSERT)");
		exit;
	}
	$seq = $seqNo;

//修正
}else if($mode == 2){
	if($stradd != "/"){
		$stradd = "/".$stradd;
	}

	$strEND = " ";
	if((int)$progress != 100){
		$strEND = ", end_flg = 0 ";
	}
	//あっぷでーと
	$strSQL = "update todo_tbl set ";
	$strSQL .= "category_id = ".$selCTG_0.", todo_name = '".addslashes($txtTodo)."', start_date = '".$kikan_S."', end_date = '".$kikan_E."', ";
	$strSQL .= "kikan_flg = ".$chkKikan.", juyodo = ".$hidImp.", naiyo = '".addslashes($txtNaiyo)."', kyoyu_menber = '".$stradd."', alarm_date = '".$alarm."', sinchoku = ".$progress.$strEND;
	$strSQL .= "where seq = ".$seq;
	$objRec = pg_exec($strSQL);
	if($objRec == false){
		echo("SQL実行に失敗しました(UPDATE)");
		exit;
	}

}

//アラーム登録
//配信対象者設定
$temp = $stradd;
if(strpos($temp,"/".$PHP_SYAIN_CD."/") === false ){
	$temp = "/".$PHP_SYAIN_CD.$temp;
}
$sendArr = split("/",$temp);
//一旦全部消す！！
if(subMailDel($seq,2) == false){
	echo ("SQL実行に失敗しました(DELETE)");
	exit;
}
//消してからインサート
if($radALM == 1){
	$strContent[0] = "ToDoアラーム通知です\n";
	$strContent[0] .= "ToDo名：".addslashes($txtTodo);

	$strContent[1] = "ToDoアラーム通知です\n";
	$strContent[1] .= "ToDo名：".addslashes($txtTodo);

	for($i=1;$i<=count($sendArr);$i++){
		if(trim($sendArr[$i]) == ""){
			break;
		}
		
		//インサート
		if(subMailIns($seq,2,4,$sendArr[$i],$alarm,$strContent) == false){
			echo ("SQL実行に失敗しました(INSERT)");
			exit;
		}
		
	}
}

exit;
?>