<?php 
//*****************************************************************************
//* 
//* プログラム名：個人情報DB設定処理（削除）
//* プログラムID：CON008_5
//* 機能        ：個人情報をDB設定する
//* 作成者      ：
//* 
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");

//***************************
//*インクルードファイル
//***************************
include("./include/session_start.inc");			//セッション開始
include("./include/SessionChk.inc");				//セッションチェック
include("./include/dbcon.inc");							//ＤＢ接続

if ($syain_code==$PHP_SYAIN_CD){
		$intGmflg=2;
}else{
	//決裁使用してますか？
		$strSQL_CHK = "SELECT name FROM sub_menu_TBL WHERE url = 'FLO001.php'";
		$rsRec_CHK = pg_exec($strSQL_CHK);
		if(pg_numrows($rsRec_CHK) > 0) {
				//決裁者確認
				$strSqlChk = "SELECT sinsei_syubetu FROM kessaisya_tbl Where kessaisya_cd1 = '$syain_code' or kessaisya_cd2 = '$syain_code' ".
											"	or kessaisya_cd3 = '$syain_code' or kessaisya_cd4 = '$syain_code' or kessaisya_cd3 = '$syain_code'";
				$rsResultChk = pg_exec($pg_con,$strSqlChk);
				if (pg_numrows($rsResultChk) > 0){
						$intGmflg=1;
				}else{
						$intGmflg=0;
				}
		}
}

if ($intGmflg==0){
		//社員テーブルから削除
		$strSql = "UPDATE syain_tbl SET del_flg=false WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//管理者テーブル,出社状況テーブル,状況テーブル,所属テーブルから削除
		$strSql = "DELETE FROM attend_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//アラーム
		$strSql = "DELETE FROM alarm_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//個人設定
		$strSql = "DELETE FROM kojin_data_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		$strSql = "DELETE FROM kojinset_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//個人アドレス
		$strSql = "DELETE FROM mail_address_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//メール設定
		$strSql = "DELETE FROM mail_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//受信メール削除
		$strTempPath="temp/".$PHP_FOLDER_NAME."/mail/";
		$strSQL="Select * from mail_get_tbl Where syain_cd='$syain_code'";
		$objRec = pg_exec($strSQL);
		for ($intCnt=0; $intCnt < pg_numrows($objRec); $intCnt++){ 
				$objData = pg_fetch_object($objRec, $intCnt);
				//添付ファイル名取得
				$strSQLtemp= "Select *  from mail_temp_tbl where syain_cd = '$syain_code' and mail_id='".$objData->mail_id."'";
				$objRectemp = pg_exec($strSQLtemp);
				if($objRectemp==false){
						echo("SQL実行に失敗しました(SELECT)");
						exit;
				}
				for ($inttmpCnt=0; $inttmpCnt < pg_numrows($objRectemp); $inttmpCnt++){ 
						$objTemp = pg_fetch_object($objRectemp, $inttmpCnt);
						$del_file=$syain_cd."-".$objTemp->temp_index."-".$objTemp->mail_id;
						if(file_exists($strTempPath.$del_file)){
								unlink($strTempPath.$del_file);  
						}
				}

				//添付メールテーブル削除
				$strSql = "DELETE FROM mail_temp_tbl WHERE syain_cd='$syain_code' and mail_id='".$objData->mail_id."'";
				$rsResult = pg_exec($pg_con,$strSql);

				//受信メール削除
				$strSql = "DELETE FROM mail_get_tbl WHERE syain_cd='$syain_code' and mail_id='".$objData->mail_id."'";
				$rsResult = pg_exec($pg_con,$strSql);
			
		}

		//送信メール削除
		$strSQL="Select * from mail_send_tbl Where syain_cd='$syain_code'";
		$objRec = pg_exec($strSQL);
		for ($intCnt=0; $intCnt < pg_numrows($objRec); $intCnt++){ 
				$objData = pg_fetch_object($objRec, $intCnt);

				$filename1=$objData->filename1;
				$filename2=$objData->filename2;
				$filename3=$objData->filename3;
				
				$strSQLseq= "delete from mail_send_tbl where syain_cd='$syain_code' and send_date='".$objData->send_date."'";
				$objRecseq = pg_exec($strSQLseq);
				if($objRecseq==false){
							echo("SQL実行に失敗しました(SELECT)");
							exit;
				}
				$strTempPath="temp/".$PHP_FOLDER_NAME."/mail_send/";
				if ($filename1!=""){
						if(file_exists($strTempPath.$filename1)){
								unlink($strTempPath.$filename1);  
						}
				}
				if ($filename2!=""){
						if(file_exists($strTempPath.$filename2)){
								unlink($strTempPath.$filename2);  
						}
				}
				if ($filename3!=""){
						if(file_exists($strTempPath.$filename3)){
								unlink($strTempPath.$filename3);  
						}
				}
		}

		//メモ帳
		$strSql = "DELETE FROM memo_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//マイメモ
		$strSql = "DELETE FROM mymemo_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//掲示板既読確認
		$strSql = "DELETE FROM pbbs_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//営業日報既読確認
		$strSql = "DELETE FROM peigyou_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//電子会議室既読確認
		$strSql = "DELETE FROM pkaigi_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//電子会議室既読確認
		$strSql = "DELETE FROM pmeet_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//スケジュール
		$strSql = "DELETE FROM schedule_tbl WHERE disp_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//所属
		$strSql = "DELETE FROM syozoku_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//転送設定
		$strSql = "DELETE FROM tel_trans_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//電話メモ
		$strSql = "DELETE FROM telmemo_tbl WHERE to_code='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//取引先初期表示
		$strSql = "DELETE FROM tori_group_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//取引先初期表示
		$strSql = "DELETE FROM tori_group_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);

		//マイ資料
		$strSQL="Select * from mst_folder Where folder_kind='$syain_code'";
		$objRec = pg_exec($strSQL);
		$strTempPath="temp/".$PHP_FOLDER_NAME."/siryou/";
		for ($intCnt=0; $intCnt < pg_numrows($objRec); $intCnt++){ 
				$objData = pg_fetch_object($objRec, $intCnt);
				//ファイル情報取得
				$strSql="SELECT * FROM mysiryo_tbl WHERE folder_seq =".$objData->seq;
				$objRec = pg_exec($strSql);
				if($objRec==false){
						echo("SQL実行に失敗しました(SELECT)");
						exit;
				}
				for ($intj = 0; $intj < pg_numrows($objRec); $intj++) {
						$objData = pg_fetch_object($objRec, $intj);
						$Siryo_Seq[$intj]=$objData->seq;
						$Siryo_Name[$intj]=$objData->filename;
				}

				//ファイルの削除
				for ($intj = 0; $intj < count($Siryo_Seq); $intj++) {
						$strSql = "DELETE FROM mysiryo_tbl WHERE seq = $Siryo_Seq[$intj]";
						$objRecSet = pg_exec($strSql);
						if($objRecSet==false){
								echo("SQL実行に失敗しました(delete)");
								exit;
						}
						if(file_exists($strTempPath.$Siryo_Name[$intj])){
								unlink($strTempPath.$Siryo_Name[$intj]);
								//$Res = unlink($strTempPath.$Siryo_Name[$intj]);
						}
				}

				$strSQL="DELETE FROM mst_folder WHERE seq=".$objData->seq;
				$objDelData = pg_exec($strSQL);
				if($objDelData==false){
						echo("SQL実行に失敗しました(削除)");
						exit;
				}
		}
		//共有フォルダロック解除
		$strSQL="Select * from mysiryo_tbl Where lock_flg='$syain_code'";
		$objRec = pg_exec($strSQL);
		for ($intCnt=0; $intCnt < pg_numrows($objRec); $intCnt++){ 
				$objData = pg_fetch_object($objRec, $intCnt);
				//ファイル情報取得
				$strSqlUp = "UPDATE mysiryo_tbl SET ";
				$strSqlUp .= "lock_flg= '' ";
				$strSqlUp .= "WHERE lock_flg = '$syain_code'";

				$objRecUP = pg_exec($strSqlUp);
				if($objRecUP==false){
						echo("SQL実行に失敗しました(SELECT)");
						exit;
				}
		}
		//タイムカード
		$strSql = "DELETE FROM tim_tbl WHERE syain_cd='$syain_code'";
		$rsResult = pg_exec($pg_con,$strSql);
}


?>
<!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">
<SCRIPT LANGUAGE="JAVASCRIPT">
<!--
function load_screen(intGmflg){
	if (intGmflg==1){
		document.e_gru.action = "CON008_3.php";
	}else if(intGmflg==2){
		document.e_gru.action = "CON008_4.php";
	}else{
		document.e_gru.action = "CON008.php";
	}
	document.e_gru.method="POST";
	document.e_gru.submit();
}
-->
</SCRIPT>
</HEAD>
<BODY onLoad="return load_screen(<?php  echo $intGmflg; ?>);">
<form name="e_gru">
</form>
</BODY>
</HTML>