<?php 
//*****************************************************************************
//* 
//* プログラム名：アドレス帳
//* プログラムID：ADR001.php
//* 機能        ：社内アドレス帳
//* 作成者      ：
//* 
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");

//***************************
//*　インクルードファイル
//***************************
include("./include/session_start.inc");
include("./include/SessionChk.inc");
include('./include/smarty.conf');
include("./inc/header.inc");
include("./inc/STRING.inc");

//**** ＤＢ接続 ****//
include("./include/dbcon.inc");

//アドレス帳カナ検索
if ($add_search ==1){
		$str_add="ア%/イ%/ウ%/エ%/オ%";
}elseif($add_search ==2){
		$str_add="カ%/キ%/ク%/ケ%/コ%/ガ%/ギ%/グ%/ゲ%/ゴ%";
}elseif($add_search ==3){
		$str_add="サ%/シ%/ス%/セ%/ソ%/ザ%/ジ%/ズ%/ゼ%/ゾ%";
}elseif($add_search ==4){
		$str_add="タ%/チ%/ツ%/テ%/ト%/ダ%/ヂ%/ヅ%/デ%/ド%";
}elseif($add_search ==5){
		$str_add="ナ%/ニ%/ヌ%/ネ%/ノ%";
}elseif($add_search ==6){
		$str_add="ハ%/ヒ%/フ%/ヘ%/ホ%/バ%/ビ%/ブ%/ベ%/ボ%/パ%/ピ%/プ%/ペ%/ポ%";
}elseif($add_search ==7){
		$str_add="マ%/ミ%/ム%/メ%/モ%";
}elseif($add_search ==8){
		$str_add="ヤ%/ユ%/ヨ%";
}elseif($add_search ==9){
		$str_add="ラ%/リ%/ル%/レ%/ロ%";
}elseif($add_search ==10){
		$str_add="ワ%/ヲ%/ン%";
}else{
		$str_add="";
}

if ($str_add!=""){
		$str_add=" and ((name_kn_sei Like '".str_replace("/","') or (name_kn_sei Like '",$str_add)."'))";
}

if ((empty($bumon)) && $intsts !=1){
		//個人設定情報取得
		$strSQLkojin="Select addr_syanai,addr_tori From paddress_tbl Where syain_cd='$PHP_SYAIN_CD'";
		$objReckojin = pg_exec($strSQLkojin);
		if($objReckojin==false)
		{
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}

		if (pg_numrows($objReckojin)>0)
		{
			$objRecData = pg_fetch_object($objReckojin, 0);
			$bumon=$objRecData->addr_syanai;
		}
		else
		{
			$bumon=0;
		}
}

//部門情報取得
$strSQLbumon="Select syozoku_cd,bumon_name From mst_bumon Where del_flg=0 Order By disp_rank";
$objRecbumon = pg_exec($strSQLbumon);
if($objRecbumon==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}

if ($bumon==0){
		//社員情報取得
		$strSQL="Select syain_cd,name_kj_sei,name_kj_mei,mail_addr,yubin_no,addr_pref,addr_city, ".
						"addr_banti,addr_apart,tel_no,keitai_no ".
						"From syain_tbl ".
						"Where del_flg=true ".$str_add." Order By disp_rank ";
		$objRecSet = pg_exec($strSQL);
		if($objRecSet==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
		}
}elseif ($bumon==99){
		$strSQL="SELECT mygroup FROM kojinset_tbl Where syain_cd='$PHP_SYAIN_CD' ";
		$objRecSet = pg_exec($strSQL);
		if($objRecSet==false){
				echo("SQL実行に失敗しました(SELECT)");
				exit;
		}
		if (pg_numrows($objRecSet)>0){
				$objRecData = pg_fetch_object($objRecSet, 0);
				$strData=split("/", $objRecData->mygroup);
				$strsel=$objRecData->mygroup;
		}
		$strsel=$PHP_SYAIN_CD."/".$strsel;
		$strData=split("/", $strsel);
}else{
		$strSQL="Select syain_tbl.syain_cd,name_kj_sei,name_kj_mei,mail_addr,yubin_no,addr_pref,addr_city, ".
				"addr_banti,addr_apart,tel_no,keitai_no ".
				"From syain_tbl,syozoku_tbl,mst_bumon ".
				"Where syain_tbl.syain_cd=syozoku_tbl.syain_cd and mst_bumon.syozoku_cd =$bumon and syozoku_tbl.syozoku_cd=mst_bumon.syozoku_cd and syain_tbl.del_flg=true ".
				$str_add." Order By syain_tbl.disp_rank ";
		$objRecSet = pg_exec($strSQL);
		if($objRecSet==false){
			echo("SQL実行に失敗しました(SELECT)");
			exit;
		}
}

// グループ
// MYグループ
if($bumon==99){
		$PhpGrup[0] = "<option value=99 selected>-ＭＹグループ-</option>";
}else{
		$PhpGrup[0] = "<option value=99>-ＭＹグループ-</option>";
}

// 全グループ
if($bumon==0){
		$PhpGrup[1] = "<option value=0 selected>-全部門-</option>";
}else{
		$PhpGrup[1] = "<option value=0>-全部門-</option>";
}

for ($intCnt = 0; $intCnt < pg_numrows($objRecbumon) ; $intCnt++){
		$objData = pg_fetch_object($objRecbumon, $intCnt);
		if ($objData->syozoku_cd == $bumon){
			$PhpGrup[$intCnt + 2] = "<option value=".$objData->syozoku_cd. " selected>".$objData->bumon_name."</option>";
		}else{
			$PhpGrup[$intCnt + 2] = "<option value=".$objData->syozoku_cd.">".$objData->bumon_name."</option>";
		}
}

// 検索
$PhpSearch = "";
$strDispKeyWord = array("全て","ア","カ(ガ)","サ(ザ)","タ(ダ)","ナ","ハ(バ・パ)","マ","ヤ","ラ","ワ");
for ($search_cnt = 0; $search_cnt < 11; $search_cnt++){
		//if($add_search == $search_cnt){
		//	$PhpSearch = $PhpSearch . "<span class=Normalfont>".$strDispKeyWord[$search_cnt]."／</span>";
		//	$PhpSearch = $PhpSearch.$strDispKeyWord[$search_cnt]."／";
		//}else{
		//	$PhpSearch = $PhpSearch . "<span class=Normalfont><a href=javascript:search(".$search_cnt.");>".$strDispKeyWord[$search_cnt]."</a>／<span>";
		//	$PhpSearch = $PhpSearch."<a href='javascript:search(".$search_cnt.");'>".$strDispKeyWord[$search_cnt]."</a>／";
		//}
		$PhpSearch = $PhpSearch."<a href='javascript:search(".$search_cnt.");'>".$strDispKeyWord[$search_cnt]."</a>／";
}
$PhpAddS = $add_search;

// 一覧
if ($bumon==99){
		for ($intCnt = 0; $intCnt < count($strData)-1; $intCnt++){
				$strSQL="Select syain_cd,name_kj_sei,name_kj_mei,mail_addr,yubin_no,addr_pref,addr_city, ".
								"addr_banti,addr_apart,tel_no,keitai_no ".
								"From syain_tbl ".
								"Where syain_cd='".$strData[$intCnt]."' and del_flg=true ".$str_add;
				$objRecSet = pg_exec($strSQL);
				if($objRecSet==false){
					echo("SQL実行に失敗しました(SELECT)");
					exit;
				}

				if (pg_numrows($objRecSet) >0){
					$objData = pg_fetch_object($objRecSet, 0);

					if ($objData->mail_addr=="@"){
							$strMail="";
					}else{
							$strMail=$objData->mail_addr;
					}

					if ($objData->tel_no=="--"){
							$strtel_no="";
					}else{
							$strtel_no=$objData->tel_no;
					}

					if ($objData->keitai_no=="--"){
							$strkeitai_no="";
					}else{
							$strkeitai_no=$objData->keitai_no;
					}

					// 氏名
					$PhpName[$intCnt]   = "<a href=javascript:syanai('".$objData->syain_cd."')>".$objData->name_kj_sei."　". $objData->name_kj_mei."</A>";
					$PhpSeq[$intCnt]=$objData->syain_cd ;

					// アドレス
					$PhpAddr_E[$intCnt] = "<A HREF=javascript:mailchk('".$objData->mail_addr."');><span class=Normalfont>".$strMail."</span></A>";

					// 電話番号
					$PhpTel[$intCnt]    = $strtel_no;

					// 携帯番号
					$PhpK_Tel[$intCnt]  = $strkeitai_no;

					// 住所
					$PhpAddr[$intCnt]   = "〒". $objData->yubin_no."　".$objData->addr_pref."　".$objData->addr_city."　".$objData->addr_banti."　".$objData->addr_apart;
				}
		}
}else{
		for ($intCnt = 0; $intCnt < pg_numrows($objRecSet) ; $intCnt++){
				$objData = pg_fetch_object($objRecSet, $intCnt);
				if ($objData->mail_addr=="@"){
					$strMail="";
				}else{
					$strMail=$objData->mail_addr;
				}

				if ($objData->tel_no=="--"){
					$strtel_no="";
				}else{
					$strtel_no=$objData->tel_no;
				}

				if ($objData->keitai_no=="--"){
					$strkeitai_no="";
				}else{
					$strkeitai_no=$objData->keitai_no;
				}

				// 氏名
				$PhpName[$intCnt]   = "<a href=javascript:syanai('".$objData->syain_cd."')>".$objData->name_kj_sei."　". $objData->name_kj_mei."</A>";
				$PhpSeq[$intCnt]=$objData->syain_cd ;

				// アドレス
				$PhpAddr_E[$intCnt] = "<A HREF=javascript:mailchk('".$objData->mail_addr."');><span class=Normalfont>".$strMail."</span></A>";

				// 電話番号
				$PhpTel[$intCnt]    = $strtel_no;

				// 携帯番号
				$PhpK_Tel[$intCnt]  = $strkeitai_no;

				// 住所
				$PhpAddr[$intCnt]   = "〒". $objData->yubin_no."　".$objData->addr_pref."　".$objData->addr_city."　".$objData->addr_banti."　".$objData->addr_apart;
		}
}

$o_smarty->assign('PhpName',$PhpName);
$o_smarty->assign('PhpAddr_E',$PhpAddr_E);
$o_smarty->assign('PhpTel',$PhpTel);
$o_smarty->assign('PhpK_Tel',$PhpK_Tel);
$o_smarty->assign('PhpAddr',$PhpAddr);
$o_smarty->assign('PhpAddS',$PhpAddS);
$o_smarty->assign('PhpSeq',$PhpSeq);
$o_smarty->display('ADR001-2.tpl');

?>