MST1112.php
3.35 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
113
114
115
116
117
118
119
120
<?PHP
//*****************************************************************************
//*
//* プログラム名：め〜るNiポン！V2
//* プログラムID：MST1112.php
//* 機能 ：削除ユーザ確認用
//*
//*****************************************************************************
header("Content-type: text/html; charset=EUC-JP");
//***************************
//* インクルードファイル
//***************************
include('./include/smarty.conf');
include("./include/session_start.inc");
include("./include/SessionChk2.inc");
include("./include/jcode.phps");
//********** ヘッダー処理 **********//
include("./include/headr_data.inc");
//***************************
//* 内部変数
//***************************
include("./include/dbcon.inc");
//ユーザID最後の「,」とる
$user_ids = substr($_POST["del_User_cd"], 0, -1);
//*** ユーザー一覧 ***
$strSQL = "SELECT ";
$strSQL .= " syain_tbl.syain_cd, ";
$strSQL .= " syain_tbl.syain_id, ";
$strSQL .= " syain_tbl.name_kj_sei, ";
$strSQL .= " syain_tbl.name_kj_mei, ";
$strSQL .= " syain_tbl.mail_addr, ";
$strSQL .= " syain_tbl.pc_mail_addr, ";
$strSQL .= " syain_tbl.name_kn_sei, ";
$strSQL .= " syain_tbl.name_kn_mei ";
$strSQL .= "FROM ";
$strSQL .= " syain_tbl LEFT JOIN group_info ON syain_tbl.syain_cd = group_info.syain_cd ";
$strSQL .= "WHERE ";
$strSQL .= " syain_tbl.syain_cd IN(" . $user_ids . ")";
$strSQL .= "GROUP BY ";
$strSQL .= " syain_tbl.syain_cd, ";
$strSQL .= " syain_tbl.syain_id, ";
$strSQL .= " syain_tbl.name_kj_sei, ";
$strSQL .= " syain_tbl.name_kj_mei, ";
$strSQL .= " syain_tbl.mail_addr, ";
$strSQL .= " syain_tbl.pc_mail_addr,";
$strSQL .= " syain_tbl.name_kn_sei, ";
$strSQL .= " syain_tbl.name_kn_mei ";
$strSQL .= "ORDER BY ";
$strSQL .= " syain_tbl.name_kn_sei,";
$strSQL .= " syain_tbl.name_kn_mei,";
$strSQL .= " syain_tbl.syain_cd ";
//echo $strSQL;
//exit;
$objRec = pg_exec($strSQL);
if($objRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
for ($intI = 0; $intI < pg_numrows($objRec); $intI++) {
$objData = pg_fetch_object($objRec, $intI);
//* 氏名 *//
$List_Data[$intI][0] = $objData->name_kj_sei." ".$objData->name_kj_mei;
//* グループ *//
$List_Data[$intI][1] = "";
$strSQL = "SELECT ";
$strSQL .= " group_info.syain_cd,";
$strSQL .= " group_info.group_id,";
$strSQL .= " mst_group.group_name ";
$strSQL .= "FROM ";
$strSQL .= " group_info,";
$strSQL .= " mst_group ";
$strSQL .= "WHERE ";
$strSQL .= " group_info.group_id = mst_group.group_id AND ";
$strSQL .= " group_info.syain_cd = ".$objData->syain_cd." ";
$strSQL .= "ORDER BY ";
$strSQL .= " group_info.syain_cd";
$objGrpRec = pg_exec($strSQL);
if($objGrpRec==false){
echo("SQL実行に失敗しました(SELECT)");
exit;
}
for ($intJ = 0; $intJ < pg_numrows($objGrpRec); $intJ++) {
$objGrpData = pg_fetch_object($objGrpRec, $intJ);
$List_Data[$intI][1] .= $objGrpData->group_name."<br />";
}
if(pg_numrows($objGrpRec) > 0){
}else{
$List_Data[$intI][1] = " ";
}
//* 携帯メールアドレス *//
$List_Data[$intI][2] = $objData->mail_addr;
//* ＰＣメールアドレス *//
$List_Data[$intI][3] = $objData->pc_mail_addr;
}
echo $_POST["Sort_Mode"];
$o_smarty->assign('Sort_Mode', $_POST["Sort_Mode"]);
$o_smarty->assign('Disp_mode', $_POST["Disp_mode"]);
$o_smarty->assign('List_Data', $List_Data);
$o_smarty->assign('user_ids', $user_ids);
$o_smarty->display('MST1112.tpl');
?>