detail.php 5.89 KB

Raw Blame History Permalink

<?php
header("Content-type: text/html; charset=EUC-JP");

//セッション開始
require_once("./include/session_start.inc");

include("./include/dbcon_group.inc");
$strSQL  = "select ";
$strSQL .= "mst_group.group_id,";
$strSQL .= "mst_group.group_pass,";
$strSQL .= "mst_group.db_name,";
$strSQL .= "mst_group.folder_name,";
$strSQL .= "mst_group.group_name,";
$strSQL .= "mst_group.mode_flg,";
$strSQL .= "mst_group.mobile_flg,";
$strSQL .= "max_count,";
$strSQL .= "max_size ,";
$strSQL .= "stop_flg ,";
$strSQL .= "cont_end_date ,";
$strSQL .= "cont_memo  ";
$strSQL .= "from mst_group,maxuser_tbl ";
$strSQL .= "WHERE mst_group.folder_name=maxuser_tbl.group_id ";
$strSQL .= "AND mst_group.group_id='$key_name'";
$objRec = pg_exec($strSQL);
$objfetch      = pg_fetch_object($objRec, 0);
$group_id      = $objfetch->group_id;
$group_pass    = $objfetch->group_pass;
$db_name       = $objfetch->db_name;
$folder_name   = $objfetch->folder_name;
$group_name    = $objfetch->group_name;
$mode_flg      = $objfetch->mode_flg;
$mobile_flg    = $objfetch->mobile_flg;
$max_count     = $objfetch->max_count;
$max_size      = $objfetch->max_size;
$stop_flg      = $objfetch->stop_flg;
$cont_end_date = $objfetch->cont_end_date;
$cont_memo     = $objfetch->cont_memo;


$strSQL  = "select *";
$strSQL .= "from mst_keiyaku ";
$strSQL .= "WHERE group_id='$folder_name'";
$objRec = pg_exec($strSQL);
if (pg_numrows($objRec)>0){
		$objfetch     = pg_fetch_object($objRec, 0);
		$keiyaku_date = $objfetch->keiyaku_date;
		$keiyaku_plan = $objfetch->keiyaku_plan;
		$pay_plan     = $objfetch->pay_plan;
		$keizoku_nm   = $objfetch->keizoku_nm;
		$pay_date   = $objfetch->pay_date;
}

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-JP">
<meta http-equiv="Content-Style-Type" content="text/css">
<link rel="stylesheet" type="text/css" href="basefont.css">
<TITLE>E-グルPro　超管理画面</TITLE>
<script language="JavaScript" type="text/JavaScript">
<!--
function Touroku(intSts){
		document.frm.intSts.value=intSts;
		document.frm.action = "detail_reg.php";
		document.frm.method = "POST";
		document.frm.submit();
}
//-->
</script>

</HEAD>
<body>
<form name="frm">
■管理情報
<br>
<table border="0">
	<tr>
		<td>グループＩＤ：</td>
		<td><input type="text" name="group_id" value="<?php echo $group_id; ?>"></td>
	</tr>
	<tr>
		<td>グループＰＷ：</td>
		<td><input type="text" name="group_pass" value="<?php echo $group_pass; ?>"></td>
	</tr>
	<tr>
		<td>ＤＢ名：</td>
		<td><input type="text" name="db_name" value="<?php echo $db_name; ?>"></td>
	</tr>
	<tr>
		<td>フォルダ名：</td>
		<td><input type="text" name="folder_name" value="<?php echo $folder_name; ?>"></td>
	</tr>
	<tr>
		<td>グループ名：</td>
		<td><input type="text" name="group_name" value="<?php echo $group_name; ?>"></td>
	</tr>
	<tr>
		<td>モード：</td>
		<td><input type="text" name="mode_flg" value="<?php echo $mode_flg; ?>">（0：有料版）</td>
	</tr>
	<tr>
		<td>携帯利用可否：</td>
		<td><input type="text" name="mobile_flg" value="<?php echo $mobile_flg; ?>">（1：利用しない,2：退会）</td>
	</tr>
	<tr>
		<td>利用人数：</td>
		<td><input type="text" name="max_count" value="<?php echo $max_count; ?>"></td>
	</tr>
	<tr>
		<td>最大容量：</td>
		<td><input type="text" name="max_size" value="<?php echo $max_size; ?>"> ＭＢ</td>
	</tr>
	<tr>
		<td>利用停止フラグ：</td>
		<td><input type="text" name="stop_flg" value="<?php echo $stop_flg; ?>"> （0：利用中、1：強制停止）</td>
	</tr>
	<tr>
		<td>契約終了日：</td>
		<td><input type="text" name="cont_end_date" value="<?php echo $cont_end_date; ?>"></td>
	</tr>
	<tr>
		<td>メモ：</td>
		<td><TEXTAREA  name="cont_memo" rows=3 cols=20><?php echo $cont_memo; ?></TEXTAREA></td>
	</tr>
</table>
<input type="button" value="登録実行！！" onclick="Touroku(1);">
<hr>
■契約情報
<br>
<table border="0">
	<tr>
		<td>契約日</td>
		<td><input type="text" name="keiyaku_date" value="<?php echo $keiyaku_date; ?>"></td>
	</tr>
	<tr>
		<td>契約プラン</td>
		<td><input type="text" name="keiyaku_plan" value="<?php echo $keiyaku_plan; ?>">(0:フル、1:個別)</td>
	</tr>
	<tr>
		<td>支払いプラン</td>
		<td><input type="text" name="pay_plan" value="<?php echo $pay_plan; ?>">(0:半年払い、1:月払い)</td>
	</tr>
	<tr>
		<td>更新回数</td>
		<td><input type="text" name="keizoku_nm" value="<?php echo $keizoku_nm; ?>"></td>
	</tr>
	<tr>
		<td>次回支払日</td>
		<td><input type="text" name="pay_date" value="<?php echo $pay_date; ?>"></td>
	</tr>
</table>
<input type="button" value="登録実行！！" onclick="Touroku(1);">
<hr>
■メニュー選択（オリジナル名で表示してます）
<br>
<table border="0">
	<tr>
		<td></td>
		<td></td>
		<td>削除</td>
	</tr>
<?php
//メニューテンプレ取得
/*
if( !$pg_con=pg_connect("host=localhost dbname=org_e-gru_pro_master user=pgsqladmin password=pgsqladmin") ) {
	print "Error : connect to localhost<br>";
	exit;
}
$strSQL = "select main_menu_tbl.index_no as mainindex, main_menu_tbl.name, main_menu_tbl.org_name as mainname, main_menu_tbl.sub_menu_num, main_menu_tbl.disp_flg, ";
$strSQL .= "sub_menu_tbl.main_index, sub_menu_tbl.index_no as subindex, sub_menu_tbl.name, sub_menu_tbl.org_name as subname, sub_menu_tbl.url, sub_menu_tbl.img, sub_menu_tbl.disp_flg ";
$strSQL .= "from main_menu_tbl join sub_menu_tbl on sub_menu_tbl.main_index = main_menu_tbl.index_no ";
$strSQL .= "order by main_menu_tbl.index_no, sub_menu_tbl.index_no";
$objRec = pg_exec($strSQL);
for ($i=0; $i < pg_numrows($objRec); $i++){
	$objfetch = pg_fetch_object($objRec, $i);
?>
	<tr>
		<td><?php echo $objfetch->mainname; ?></td>
		<td><?php echo $objfetch->subname; ?></td>
		<td><input type="checkbox" name="menu_del[]" value="<?php echo $objfetch->main_index; ?>/<?php echo $objfetch->subindex; ?>"></td>
	</tr>
<?php
}
*/
?>
</table>
<input type="button" value="登録実行！！" onclick="Touroku(2);">
<input type="hidden" name="intSts" value="">
<input type="hidden" name="key_name" value="<?php echo $key_name;?>">
</form>
</body>
</HTML>