ADR004.php
3.19 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
<?php
//*****************************************************************************
//*
//* プログラム名：アドレス帳
//* プログラムID：ADR004.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");
//取引先詳細情報
$sql = "SELECT * FROM torihiki_tbl WHERE seq = $seq";
$rtn = pg_exec($pg_con, $sql);
$data = pg_fetch_object($rtn, 0);
$PhpToriName = $data->tori_name;
$PhpToriKana = $data->tori_name_kn;
$PhpToriSihon = $data->tori_sihonkin;
$PhpToriDai = $data->toridai_name__kj_sei . " " . $data->toridai_name__kj_mei;
$PhpToriDaiKana = $data->toridai_name__kn_sei . " " . $data->toridai_name__kn_mei;
$PhpToriHttp = "<a href=".$data->tori_hp_adr." target=\"_blank\">".$data->tori_hp_adr."</a>";
$PhpToriMail = "<a href=mailto:".$data->tori_email.">".$data->tori_email."</a>";
$PhpToriMemo = str_replace("\n", "<br>", $data->tori_memo);
$PhpToriYubin = "〒".$data->tori_yubin_no;
$PhpToriAddr1 = $data->addr_pref;
$PhpToriAddr2 = $data->addr_city;
$PhpToriAddr3 = $data->addr_banti;
$PhpToriAddr4 = $data->addr_apart;
$PhpToriTel = $data->tel_no;
$PhpToriFax = $data->fax_no;
$PhpToriseq= $seq;
//取引先担当者情報
//$strSQL = "SELECT * FROM tantou_tbl WHERE seq = $seq";
//$objToriTan = pg_exec($strSQL);
//if ($objToriTan == false){
// echo "データの取得に失敗しました。";
// exit;
//}
//for ($inti = 0; $inti < pg_numrows($objToriTan); $inti++){
// $objRecData = pg_fetch_object($objToriTan, $inti);
// $PhpTantoName[$inti]=$objRecData->last_name_j.$objRecData->first_name_j;
// $PhpTantophone[$inti]=$objRecData->phone;
// $PhpTantoemail[$inti]=$objRecData->email;
// $PhpTantoyaku[$inti]=$objRecData->yaku;
// $PhpTanto_cd[$inti]=$objRecData->tori_syain_cd;
//}
$o_smarty->assign('PhpToriName',$PhpToriName);
$o_smarty->assign('PhpToriKana',$PhpToriKana);
$o_smarty->assign('PhpToriSihon',$PhpToriSihon);
$o_smarty->assign('PhpToriDai',$PhpToriDai);
$o_smarty->assign('PhpToriDaiKana',$PhpToriDaiKana);
$o_smarty->assign('PhpToriHttp',$PhpToriHttp);
$o_smarty->assign('PhpToriMail',$PhpToriMail);
$o_smarty->assign('PhpToriMemo',$PhpToriMemo);
$o_smarty->assign('PhpToriYubin',$PhpToriYubin);
$o_smarty->assign('PhpToriAddr1',$PhpToriAddr1);
$o_smarty->assign('PhpToriAddr2',$PhpToriAddr2);
$o_smarty->assign('PhpToriAddr3',$PhpToriAddr3);
$o_smarty->assign('PhpToriAddr4',$PhpToriAddr4);
$o_smarty->assign('PhpToriTel',$PhpToriTel);
$o_smarty->assign('PhpToriFax',$PhpToriFax);
$o_smarty->assign('PhpToriseq',$PhpToriseq);
//$o_smarty->assign('PhpTantoName',$PhpTantoName);
//$o_smarty->assign('PhpTantophone',$PhpTantophone);
//$o_smarty->assign('PhpTantoemail',$PhpTantoemail);
//$o_smarty->assign('PhpTantoemail',$PhpTantoemail);
//$o_smarty->assign('PhpTantoyaku',$PhpTantoyaku);
//$o_smarty->assign('PhpTanto_cd',$PhpTanto_cd);
$o_smarty->display('ADR004.tpl');
?>