ADR004_m.php
4.13 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
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
<?php
//*****************************************************************************
//*
//* プログラム名：アドレス帳(携帯電話)
//* プログラムID：ADR004_m.php
//* 機能 ：取引先アドレス詳細
//* 作成者 ：
//*
//*****************************************************************************
header("Content-type: text/html; charset=Shift_JIS");
//*** 広告 ***//
include("include_m/Advertisement.inc");
//*** 共通処理 ***//
include("include_m/CommonProcess.inc");
//*** アドレス情報***
$strMenuSQL = "SELECT name FROM sub_menu_TBL WHERE url = 'ADR001.php'";
$rsRecset = pg_exec($strMenuSQL);
$PHP_TITLE_NAME=mb_convert_encoding(pg_result($rsRecset,0,"name"), "SJIS", "EUC-JP");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=Shift_JIS">
<META http-equiv="Content-Style-Type" content="text/css">
<link rel="stylesheet" type="text/css" href="basefont.css">
<TITLE>E-グルPro(<?php echo $PHP_TITLE_NAME; ?>)</TITLE>
</HEAD>
<BODY>
<form>
<center>
取引先<?php echo $PHP_TITLE_NAME; ?><br>
<?php echo $strName; ?>
<HR width="100%">
<?php echo $koukokuTEL; ?>
</center>
<?php
//メニュー表示
include("include_m/CommonMenuReturn.inc");
?>
<HR width="100%">
<a href="ADR003_m.php?tori_group=<?php echo $tori_group ?>&add_search=<?php echo $add_search ?>&<?php echo $PHP_Argument ?>"accesskey="1"><?php echo Get_Num("1"); ?>取引先アドレス帳</a>
<br><br>
<?php
//取引先情報取得
$strSQL="Select ".
"seq,tori_name,tori_name_kn,toridai_name__kj_sei,toridai_name__kj_mei,toridai_name__kn_sei,".
"toridai_name__kn_mei,tori_sihonkin,tori_hp_adr,tori_email,tori_memo,tori_yubin_no,addr_pref,".
"addr_city,addr_banti,addr_apart,tel_no,fax_no,del_flg,tori_group ".
"From torihiki_tbl Where seq=$seq";
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
$objData = pg_fetch_object($objRec,0);
$strAddres=$objData->addr_pref;
echo "【会社名(漢字)】<br> ".mb_convert_encoding($objData->tori_name , "SJIS", "EUC-JP" )."<br>";
echo "【会社名(カナ)】<br> ".mb_convert_encoding($objData->tori_name_kn , "SJIS", "EUC-JP" )."<br>";
echo "【資本金】<br> ".mb_convert_encoding($objData->tori_sihonkin , "SJIS", "EUC-JP" )."万円<br>";
echo "【代表者名(漢字)】<br> ".mb_convert_encoding($objData->toridai_name__kj_sei.$objData->toridai_name__kj_mei, "SJIS", "EUC-JP" )."<br>";
echo "【代表者名(カナ)】<br> ".mb_convert_encoding($objData->toridai_name__kn_sei.$objData->toridai_name__kn_mei, "SJIS", "EUC-JP" )."<br>";
echo "【ホームページ】<br> ".mb_convert_encoding($objData->tori_hp_adr , "SJIS", "EUC-JP" )."<br>";
echo "【メールアドレス】<br> ";
echo '<a href="mailto:'.mb_convert_encoding($objData->tori_email, "SJIS", "EUC-JP" ).'">'.
mb_convert_encoding($objData->tori_email, "SJIS", "EUC-JP" )."</a><br>";
echo "【メモ】<br>";
$message = str_replace ("\n", "<BR>", mb_convert_encoding($objData->tori_memo, "SJIS", "EUC-JP"));
echo $message."<br>";
echo "【住所】<br>";
echo " 〒".mb_convert_encoding($objData->tori_yubin_no, "SJIS", "EUC-JP" )."<br>";
echo " ".mb_convert_encoding($objData->addr_pref, "SJIS", "EUC-JP" )."<br>";
echo " ".mb_convert_encoding($objData->addr_city, "SJIS", "EUC-JP" )."<br>";
echo " ".mb_convert_encoding($objData->addr_banti, "SJIS", "EUC-JP" )."<br>";
echo " ".mb_convert_encoding($objData->addr_apart, "SJIS", "EUC-JP" )."<br>";
echo "【TEL】<br> ";
if (mb_convert_encoding($objData->tel_no, "SJIS", "EUC-JP" )!="--"){
echo '<a href="tel:'.str_replace("-","",mb_convert_encoding($objData->tel_no, "SJIS", "EUC-JP" )).'">'.
mb_convert_encoding($objData->tel_no, "SJIS", "EUC-JP" )."</a><br>";
}
echo "【FAX】<br> ".mb_convert_encoding($objData->fax_no, "SJIS", "EUC-JP" )."<br>";
?>
<br>
<a href="ADR003_m.php?tori_group=<?php echo $tori_group ?>&add_search=<?php echo $add_search ?>&<?php echo $PHP_Argument ?>"accesskey="1"><?php echo Get_Num("1"); ?>取引先アドレス帳</a>
<HR width="100%">
<?php
//メニュー表示
include("include_m/CommonMenuReturn.inc");
//*** 共通変数取得 ***//
include("include_m/CommonHidden.inc");
?>
</form>
</BODY>
</HTML>