ADR091.php
2.7 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
<?php
//*****************************************************************************
//*
//* プログラム名：取引先情報
//* プログラムID：ADR091.php
//* 機能 ：取引先情報登録･更新
//* 作成者 ：
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
//***************************
//* インクルードファイル
//***************************
include("./include/session_start.inc");
include("./include/SessionChk.inc");
include("./include/jcode.phps");
//**** ＤＢ接続 ****//
include("./include/dbcon.inc");
if (substr($hp_adr,0,7)!="http://"){
$hp_adr="http://".$hp_adr;
}
if($hp_adr=="http://"){
$hp_adr="";
}
include("inc/ADR091.inc");
if ($ToriSeq == 0){
//最大取引先コード取得
$sql = "SELECT MAX(seq) as max_seq FROM torihiki_tbl";
$rtn = pg_exec($pg_con, $sql);
if ($rtn == false){
echo "データの取得に失敗しました。";
exit;
}
$max_seq = pg_result($rtn, 0, "max_seq") + 1;
$sql = "INSERT INTO torihiki_tbl VALUES ( $max_seq, $kaisya_kj, ";
$sql .= "$kaisya_kn, $dai_sei_kj, $dai_mei_kj, $dai_sei_kn, ";
$sql .= "$dai_mei_kn, $sihonkin, $hp_adr, $email, $kaisya_memo, ";
$sql .= "$post, $address1, $address2, $address3, $address4, ";
$sql .= "$tel, $fax, true,$gruop_tori)";
echo $sql;
$rtn = pg_exec($pg_con, $sql);
if ($rtn == false){
echo "取引先の登録に失敗しました。";
exit;
}
$ToriSeq=$max_seq;
}else{
// $sql = "DELETE FROM torihiki_tbl WHERE seq = $ToriSeq ";
// $rtn = pg_exec($pg_con, $sql);
// if ($rtn == false){
// echo "取引先の削除に失敗しました。";
// exit;
// }
// $sql = "INSERT INTO torihiki_tbl VALUES ( $ToriSeq, $kaisya_kj, ";
// $sql .= "$kaisya_kn, $dai_sei_kj, $dai_mei_kj, $dai_sei_kn, ";
// $sql .= "$dai_mei_kn, $sihonkin, $hp_adr, $email, $kaisya_memo, ";
// $sql .= "$post, $address1, $address2, $address3, $address4, ";
// $sql .= "$tel, $fax, true,$gruop_tori)";
$sql = "UPDATE torihiki_tbl SET tori_name = $kaisya_kj, ";
$sql .= "tori_name_kn = $kaisya_kn, toridai_name__kj_sei = $dai_sei_kj, ";
$sql .= "toridai_name__kj_mei = $dai_mei_kj, ";
$sql .= "toridai_name__kn_sei = $dai_sei_kn, ";
$sql .= "toridai_name__kn_mei = $dai_mei_kn, ";
$sql .= "tori_sihonkin = $sihonkin, tori_hp_adr = $hp_adr, ";
$sql .= "tori_email = $email, tori_memo = $kaisya_memo, ";
$sql .= "tori_yubin_no = $post, addr_pref = $address1, ";
$sql .= "addr_city = $address2, addr_banti = $address3, ";
$sql .= "addr_apart = $address4, tel_no = $tel, fax_no = $fax, ";
$sql .= "tori_group = $gruop_tori ";
$sql .= " WHERE seq = $ToriSeq";
echo $sql;
$rtn = pg_exec($pg_con, $sql);
if ($rtn == false){
echo "取引先の変更に失敗しました。";
exit;
}
}
?>