<?php 
//*****************************************************************************
//* 
//* プログラム名：アドレス帳
//* プログラムID：ADR002.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 (empty($tori_group)){
	//個人設定情報取得
	$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);
		$tori_group=$objRecData->addr_tori;
	}else{
		$tori_group=99;
	}
}

//アドレス帳カナ検索
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 ((tori_name_kn Like '".str_replace("/","') or (tori_name_kn Like '",$str_add)."'))";
}

//取引先グループ取得
$strSQLgroup="Select group_seq,group_name From torihiki_group_tbl Order By disp_rank";
$objRecgroup = pg_exec($strSQLgroup);
if($objRecgroup==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}

//取引先情報取得
$strSQL="Select seq,tori_name,tori_name_kn,tori_email,addr_pref,addr_city,addr_banti,addr_apart,tel_no,fax_no ".
				"From torihiki_tbl ".
				"Where tori_group=$tori_group and del_flg=true ".$str_add." Order By tori_name_kn,seq ";
$objRecSet = pg_exec($strSQL);
if($objRecSet==false){
	echo("SQL実行に失敗しました(SELECT)");
	exit;
}

$PhpGrup[0] = "<option value=99>未設定</option>";
for ($intCnt = 0; $intCnt < pg_numrows($objRecgroup); $intCnt++){
		$objData = pg_fetch_object($objRecgroup, $intCnt);
		if ($objData->group_seq == $tori_group){
			$PhpGrup[$intCnt + 1] = "<option value=".$objData->group_seq." selected>".$objData->group_name."</option>";
		}else{
			$PhpGrup[$intCnt + 1] = "<option value=".$objData->group_seq.">".$objData->group_name."</option>";
		}
}

$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>／";
}	

for ($intCnt = 0; $intCnt < pg_numrows($objRecSet) ; $intCnt++){
		$objData = pg_fetch_object($objRecSet, $intCnt);
		
		if ($objData->tori_email=="@"){
			$strMail="";
		}else{
			$strMail=$objData->tori_email;
		}

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

		if ($objData->fax_no=="--"){
			$strFAX_no="";
		}else{
			$strFAX=$objData->fax_no;
		}

		// 氏名
		$PhpName[$intCnt]   = "<a href=javascript:torihiki(".$objData->seq.")>".$objData->tori_name."</A>";

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

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

		// FAX番号
		$PhpFax[$intCnt]    = $strFAX;

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

$o_smarty->assign('PhpSearch',$PhpSearch);
$o_smarty->assign('PhpGrup',$PhpGrup);
$o_smarty->assign('PhpAddS',$PhpAddS);

//	$o_smarty->assign('PhpName',$PhpName);
//	$o_smarty->assign('PhpAddr_E',$PhpAddr_E);
//	$o_smarty->assign('PhpTel',$PhpTel);
//	$o_smarty->assign('PhpFax',$PhpFax);
//	$o_smarty->assign('PhpAddr',$PhpAddr);
$o_smarty->display('ADR001-1.tpl');

?>