<?php  //マスタ設定
if ($_POST[dl] ==""){
	header('pragma: no-cache');
	header("Cache-Control: no-cache, must-revalidate");
}
include "func.cgi";
myopen();

//再チェック
SecurityCheck();
PostData();
FunctionUseCheck2();
//UpdateShohinLevel($company,2);

//１ページ数
$pageset = 20;
$j = $pageset*($_POST[pagenum]  - 1);
//テーブル情報
$tabledata = dbselect("tablenamej,tablename,key_,where_","mastertable",-1,-1,-1);

//選択しているテーブル
if ($_POST["tablename"] <> "") {
	$strtablename  = $_POST["tablename"];
	$strtablenamej = GetList($tabledata,$strtablename,0);
	//レコード選択時
	if ($_POST["select"] == "yes") {
		For ($i = 1;$i <= $pageset;$i++) {
			if($_POST{"edit".($i + $j)} <> "") {
				$strselectdata  = $_POST{"key".($i + $j)};
			}
		}
	}
} else {
	//初回選択時
	For ($i = 0;$i < count($tabledata);$i++) {
		if($_POST{"edit".$i} <> "") {
			$strtablename  = $tabledata[$i][1];
			$strtablenamej = $tabledata[$i][0];
		}
	}
	//初回選択前は空
	if($_POST{"shohin"} <> "") {
		$strtablename  = $company."shohinmaster";
		$strtablenamej = GetList($tabledata,$strtablename);
	} elseif($_POST{"maker"} <> "") {
		$strtablename  = "company";
		$strtablenamej = GetList($tabledata,$strtablename);
	} elseif($_POST{"tenpo"} <> "") {
		$strtablename  = $company."shozokumaster";
		$strtablenamej = GetList($tabledata,$strtablename);
	}
}


//カラム一覧
$columndata = dbselect("feildnamej,feildname_,ex","tablecolumn",-1,-1,-1);
//レコードの指定
if ($_POST[pagenum] == "") {
	$page = 1;
} else {
	$page = (int)$_POST[pagenum];
}

//データ取得数
$limit = " LIMIT ".($pageset*($page  - 1)).",$pageset";

//表示項目
//該当テーブルの全カラムリストを取得
$column_data = dbselect("columnname,search_column,disp_select,tab_block,hankaku","tableedit","tablename ='".$strtablename."'","tab_block,disp_order,tableeditid",-1);
Testecho ($strsqldbselect);
$strdcolumn = "1";$j = 0;
For ($i = 0;$i < count($column_data);$i++) {
	if($column_data[$i][2] == "1") {  //disp_select = 1 リスト表示用カラム
		//リスト用SELECT句作成
		$strdcolumn .= ",".$column_data[$i][0];
	}

	//外部キー情報を取得
	$foreignkey = dbselect("honbucompany,foreigntable,foreignname,foreignwhere,foreignkey","tablecolumn","feildname_ ='".$column_data[$i][0]."' and foreigntable is not null",-1,-1);
//Testecho($strsqldbselect);
	//外部キーがあればリストを格納
	if(count($foreignkey) == 1) {
		if($foreignkey[0][0] == 1) {$strtablenameplus = $company;} else {$strtablenameplus ="";}  //本部名をテーブルに付加する
		if($foreignkey[0][3] == "") {$strwhere = -1;} else {$strwhere = $foreignkey[0][3];}  //条件文ないときは-1
		$foreign_key_data{$column_data[$i][0]} = dbselect($foreignkey[0][2].",".$foreignkey[0][4],$strtablenameplus.$foreignkey[0][1],$strwhere,-1,-1);
//estecho($strsqldbselect);$j++;
	}

	//検索で使用するカラムリスト
	if($column_data[$i][1] == "1") {  //search_column = 1 検索で使用するカラム
		
		$search_column_data[] = $column_data[$i][0];
		//検索ボックスに値があれば
		if($_POST{"sw_".$column_data[$i][0]} <> "") {
			$strsqlwhere .= " and ".$column_data[$i][0]." like '%".$_POST{"sw_".$column_data[$i][0]}."%'" ;
		}
	}
}

//該当テーブルの全カラム情報を取得
$column_info = dbselect("null_,Field_ ,key_,default_ ,extra_ ,char_size ","tableinfo","tablename ='".$strtablename."'","tableinfoid",-1);
//配列に格納
For ($i = 0;$i < count($column_info);$i++) {
	//テキストサイズ
	if ((int)$column_info[$i][5] == 0) {
		$intchar_size = 12;		//ゼロは12を初期値とする
		$intchar_sizemax = 12;		//ゼロは12を初期値とする
	} elseif((int)$column_info[$i][5] > 30) {
		$intchar_size = 30;
		$intchar_sizemax = (int)$column_info[$i][5];
	} else {
		$intchar_size = (int)$column_info[$i][5];
		$intchar_sizemax = (int)$column_info[$i][5];
	}
	//0NULL/1KEY/2DEFALT/3EXTRA/4キャラサイズ/5キャラマックス/6初期キャラサイズ
	$column_info_data{$column_info[$i][1]} = array($column_info[$i][0],$column_info[$i][2],$column_info[$i][3],$column_info[$i][4],$intchar_size,$intchar_sizemax,$column_info[$i][5]);
}


//データ表示
if(GetListData($tabledata,$strtablename,3) <> "") { $strsql = " and ".GetListData($tabledata,$strtablename,3);}
$strsql = "SELECT ".$strdcolumn." FROM `$strtablename` WHERE 1=1 ".$strsqlwhere.$strsql." ORDER BY 1,2";

//編集データ
$strsqledit = "SELECT * FROM `$strtablename` WHERE ".$search_column_data[0]." = '".$strselectdata."' limit 1";

//ダウンロード
if ($_POST[dl] <>""){
	
	$strdate = Sjis(GetList($tabledata,$strtablename).date("Ymd-Gi").".csv");
	header("Content-type: application/octet-stream");
	header("Content-Disposition: attachment; filename=$strdate");
	header("Connection: close");
	ob_end_clean();
/*	$result=@mysql_query($strsql,$my_con);

	$row1 = mysql_num_fields($result);
	//タイトル行の表示
	for ($i=1;$i<$row1;$i++) {
		echo mysql_field_name($result, $i).",";
	}
	echo "\n";
	//タイトル行の表示
	for ($i=0;$i<$row1;$i++) {
		echo Sjis("\"".GetList2($columndata,mysql_field_name($result, $i)))."\",";
	}
	echo "\n";
	while ($row2 = mysql_fetch_array($result)) {
		For ($j=0;$j<$row1;$j++) {
			echo Sprint($row2{$j});
		}
		echo "\n";
	}
*/
	For ($i = 0;$i < count($column_data);$i++) {
		if((int)$column_data[$i][3] <3 ){
			//必須項目＋詳細
			echo Sjis("\"".GetList2($columndata,$column_data[$i][0]))."\",";
		} else {
			//必須項目以外
		}
	}
	echo "\n";
	$strsql = "SELECT * FROM `$strtablename` ORDER BY 1,2";
	$result=@mysql_query($strsql,$my_con);
	while ($data = mysql_fetch_array($result)) {
		For ($i = 0;$i < count($column_data);$i++) {
			if((int)$column_data[$i][3] <3 ){
				echo Sprint($data{$column_data[$i][0]});
			} else {
				//必須項目以外
			}
		}
		echo "\n";
	}

	myclose();
	exit;
}
if ($_POST[disp] <>""){
	$result=@mysql_query($strsql,$my_con);
	//カラム行
	$rows = mysql_num_fields($result);
}

//更新
if($_POST[insert]<>"") {
	$strsqlupdate = "insert into  `".$strtablename."` ( ";
	$strsqlupdate2 = "";
	For ($i = 0;$i < count($column_info);$i++) {
		$strsqlupdate .= $column_info[$i][1];

		if($_POST{$column_info[$i][1]} == "") {
			$strsqlupdate2 .= "null ";
		} else {
			$strsqlupdate2 .= "'".$_POST{$column_info[$i][1]}."' ";
		}
		if ($i<(count($column_info) - 1)) {$strsqlupdate .= ",";$strsqlupdate2 .= ","; }
	}
	$strsqlupdate .= " values( ".$strsqlupdate2;
	$strsqlupdate .= ") ";
Testecho($strsqlupdate); //全項目登録

	$strsqlupdate = "insert into  `".$strtablename."` ( ";
	$strsqlupdate2 = "";
//	for ($i=0;$i<$rows;$i++) {
	For ($i = 0;$i < count($column_data);$i++) {
		if((int)$column_data[$i][3] <3 ){
			//必須項目＋詳細
			if ($i > 0) {$strsqlupdate .= ",";$strsqlupdate2 .= ","; }
			$strsqlupdate .= "`".$column_data[$i][0]."`";

			if($_POST{$column_data[$i][0]} == "") {
				if (GetListData($column_info,$column_data[$i][0],0) == "NO") {
					$strsqlupdate2 .= "''";
				} else {
					$strsqlupdate2 .= "null ";
				}
			} else {
				$strsqlupdate2 .= "'".$_POST{$column_data[$i][0]}."' ";
			}
		} else {
			//必須項目以外
		}
	}
	$strsqlupdate .= ") values( ".$strsqlupdate2.")";
//Testecho($strsqlupdate); //必要項目のみ

//	$strsqlupdate = "insert into `".$strtablename."` (".mysql_field_name($result, 0).") values('".$_POST{"input0"}."') ";
//echo $strsqlupdate ;
	$result2=mysql_query($strsqlupdate,$my_con);
	$errcode =mysql_errno();if ($errcode==0) $okcount++;
	Testecho ($y."  $errcode ".$strsqlupdate);  #debug
mysql_sql_log($strsqlupdate,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

} elseif($_POST[update]<>"") {
	$strsqlupdate = "UPDATE `".$strtablename."` SET ";
	For ($i = 0;$i < count($column_data);$i++) {
		if((int)$column_data[$i][3] < 3 ){
			//必須項目＋詳細
			if ($i > 1) {$strsqlupdate .= ","; }
			if ($i == 0) {
				$strsqlupdate2 = "`".$column_data[$i][0]."` = '".$_POST{$column_data[$i][0]."_old"}."'"; 
			} else {
				$strsqlupdate .= "`".$column_data[$i][0]."` = ";

				if($_POST{$column_data[$i][0]} == "") {
					if (GetListData($column_info,$column_data[$i][0],0) == "NO") {
						$strsqlupdate .= "''";
					} else {
						$strsqlupdate .= "null ";
					}
				} else {
					$strsqlupdate .= "'".$_POST{$column_data[$i][0]}."' ";
				}
			}
		} else {
			//必須項目以外
		}
	}
	$strsqlupdate .= " WHERE ".$strsqlupdate2;
//Testecho($strsqlupdate);

//	$strsqlupdate = "insert into `".$strtablename."` (".mysql_field_name($result, 0).") values('".$_POST{"input0"}."') ";
//echo $strsqlupdate ;
	$result2=mysql_query($strsqlupdate,$my_con);
	$errcode =mysql_errno();if ($errcode==0) $okcount++;
	Testecho ($y."ERR=  $errcode ".$strsqlupdate);  #debug
mysql_sql_log($strsqlupdate,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

}
//検索用語格納・商品所属マスタ
Switch($_POST[tablename]) {
	case $company."shohinmasterx":
		$strsqlsw = "SELECT shohincd,shohinmei,shohincd2,shohinmei2,shohinkana  FROM `".$company."shohinmaster`";
		$result=@mysql_query($strsqlsw,$my_con);
		while ($data = mysql_fetch_array($result)) {
			//検索用語
			$sw = mb_convert_kana($data['shohinmei'],'KV', "UTF-8").mb_convert_kana($data['shohinmei2'],'KV', "UTF-8").mb_convert_kana($data['shohinkana'],'KV', "UTF-8");//名
			$sw = $sw.trim($data['shohincd']).trim($data['shohincd2']); 
			$strsqlsw="update `".$company."shohinmaster` set searchword='$sw' where shohincd='".$data['shohincd']."' limit 1";
			$result2=mysql_query($strsqlsw,$my_con);
			$errcode =mysql_errno();if ($errcode==0) ;
			Testecho ($y."  $errcode ".$strsqlsw);  #debug
		}

		//$strsqlx = "TRUNCATE TABLE `".$company."shohinlocation`;";
		//$result=mysql_query($strsqlx,$my_con);
		$strsqlx = "INSERT INTO `".$company."shohinlocation`(`loccode`,`honbuid`,`centerid`,`shohincd`,`creater`,`createdatetime`) SELECT shohincd,1,'c101',shohincd,'".$userdata["tid"]."',now() FROM `".$company."shohinmaster`";
		$result=mysql_query($strsqlx,$my_con);
		Testecho ($y."商品ロケーション作成T".$strsqlx);  #debug
		break;

	case $company."shozokumaster":
		$strsqlsw = "SELECT shozokuid,shozokuname,shozokukana FROM `".$company."shozokumaster`";
		$result=@mysql_query($strsqlsw,$my_con);
		while ($data = mysql_fetch_array($result)) {
			//検索用語
			$sw = mb_convert_kana($data['shozokuname'],'KV', "UTF-8").mb_convert_kana($data['shozokukana'],'KV', "UTF-8");//名
			$sw = $sw.trim($data['shozokuid']); 
			$strsqlsw="update `".$company."shozokumaster` set search='".$sw."' where shozokuid='".$data['shozokuid']."' limit 1";
			$result2=mysql_query($strsqlsw,$my_con);
			$errcode =mysql_errno();if ($errcode==0) ;
			Testecho ($y."  $errcode ".$strsqlsw);  #debug
		}
		break;

	case $company."shohinmaster":
		$strsqlsw = "SELECT shohincd,shohincd2,concat(shohinmei,shohinmei2) as shohinmei FROM `".$company."shohinmaster`";
		if(($_POST[update]<>"") or ($_POST[insert]<>"")) {
			$result=@mysql_query($strsqlsw,$my_con);
			while ($data = mysql_fetch_array($result)) {
				//検索用語
				$sw = mb_convert_kana($data['shohinmei'],'KV', "UTF-8"); //名
				$sw = mb_convert_encoding($sw, "UTF-8", "UTF-8").trim($data['shohincd'].$data['shohincd2']);  //UTF-8に変換して入れる
				$strsqlsw="update `".$company."shohinmaster` set searchword='$sw' where shohincd='".$data['shohincd']."' limit 1";
				$result2=mysql_query($strsqlsw,$my_con);
				$errcode =mysql_errno();if ($errcode==0) ;
				Testecho ($y."  $errcode ".$strsqlsw);  #debug
				$strsqlx = "INSERT INTO `".$company."shohinlocation`(`loccode`,`honbuid`,`centerid`,`shohincd`,`creater`,`createdatetime`) SELECT shohincd,1,'c101',shohincd,'".$userdata["tid"]."',now() FROM `".$company."shohinmaster` where shohincd='".$data['shohincd']."' limit 1";
				$result2=mysql_query($strsqlx,$my_con);
				Testecho ($y."商品ロケーション作成T ".$strsqlx);  #debug
			}
		}
		//商品マスタより紐付けテーブルを作成する。
		if(($company == "marusho_") or ($company == "xxx")) {
			$strsqlx = "TRUNCATE TABLE `".$company."shozokushohin`;";
			$result=mysql_query($strsqlx,$my_con);
			Testecho ($y."紐付けテーブル削除".$strsqlx);  #debug
			$strsqlx = "INSERT INTO `".$company."shozokushohin`(shozokuid,shohincd,nohinprice ,poplevel2) SELECT shozokuid,shohincd,price_sell ,0 FROM `".$company."shohinmaster` INNER JOIN `".$company."shozokumaster` USING(gyotaiid) where zaiko = 1";
			$result=mysql_query($strsqlx,$my_con);
			Testecho ($y."紐付けテーブルIMPORT".$strsqlx);  #debug

			$strsqlx = "TRUNCATE TABLE `".$company."shohinlocation`;";
			$result=mysql_query($strsqlx,$my_con);
			$strsqlx = "INSERT INTO `".$company."shohinlocation`(`loccode`,`honbuid`,`centerid`,`shohincd`,`creater`,`createdatetime`) SELECT shohincd,1,'c101',shohincd,'".$userdata["tid"]."',now() FROM `".$company."shohinmaster`";
			$result=mysql_query($strsqlx,$my_con);
			Testecho ($y."商品ロケーション作成T".$strsqlx);  #debug
		} elseif($company == "tsukuba_") {
			$strsqlx = "TRUNCATE TABLE `".$company."shohinlocation`;";
			$result=mysql_query($strsqlx,$my_con);
			$strsqlx = "INSERT INTO `".$company."shohinlocation`(`loccode`,`honbuid`,`centerid`,`shohincd`,`creater`,`createdatetime`) SELECT      '-',1,'c101',shohincd,'".$userdata["tid"]."',now() FROM `".$company."shohinmaster`";
			$result=mysql_query($strsqlx,$my_con);
			Testecho ($y."商品ロケーション作成T".$strsqlx);  #debug
		} elseif($company == "body_") {
			$strsqlx = "update `body_shozokushohin` as a,body_shohinmaster as b set a.nohinprice = b.price_buy where a.shohincd = b.shohincd and a.nohinprice != b.price_buy";
			$result=mysql_query($strsqlx,$my_con);
			Testecho ($y."商品ロ価格反映".$strsqlx);  #debug
		}
		UpdateShohinLevel($company,1);
		break;
	case $company."shozokumaster":
		$strsqlsw = "SELECT shozokuid,shozokuname FROM `".$company."shozokumaster`";
		$result=@mysql_query($strsqlsw,$my_con);
		while ($data = mysql_fetch_array($result)) {
			//検索用語
			$sw = mb_convert_kana($data['shozokuname'],'KV', "UTF-8");//名
			$sw = $sw.trim($data['shozokuid']);
			$sw = str_replace("　","",$sw);
			$sw = str_replace(" ","",$sw);
			$strsqlsw="update `".$company."shozokumaster` set search='".$sw."' where shozokuid='".$data['shozokuid']."' limit 1";
			$result2=mysql_query($strsqlsw,$my_con);
			$errcode =mysql_errno();if ($errcode==0) ;
			Testecho ($y."  $errcode ".$strsqlsw);  #debug
		}
		//商品マスタより紐付けテーブルを作成する。
		if($company == "marusho_") {
			$strsqlx = "TRUNCATE TABLE `".$company."shozokushohin`;";
			$result=mysql_query($strsqlx,$my_con);
			$strsqlx = "INSERT INTO `".$company."shozokushohin`(shozokuid,shohincd,nohinprice ,poplevel2) SELECT shozokuid,shohincd,price_sell ,1 FROM `".$company."shohinmaster` INNER JOIN `".$company."shozokumaster` USING(gyotaiid) where zaiko = 1";
			$result=mysql_query($strsqlx,$my_con);
			UpdateShohinLevel($company,1);
		}
		break;
	default:
}
//INSERT INTO body_shozokushohin (shozokuid,shohincd,nohinprice ,poplevel2) SELECT shozokuid,shohincd,price_sell ,0 FROM `body_shohinmaster` INNER JOIN body_shozokumaster USING(gyotaiid) where zaiko = 1
//モード
if(($_POST[insertnew] <> "") or ($_POST[copy] <> "")){
	$strbutton1 = " disabled";//新規登録
	$strbutton2 = " disabled";//複写
	$strbutton3 = "";//登録
	$strbutton4 = " disabled";//更新
	$strbutton5 = " disabled";//削除
	$strbutton6 = "";//キャンセル
} elseif($_POST[select] == "yes") { //mode=3表示
 	$strbutton1 = " disabled";//新規登録
	$strbutton2 = " disabled";//複写
	$strbutton3 = " disabled";//登録
	$strbutton4 = "";//更新
	$strbutton5 = " disabled";//削除
	$strbutton6 = "";//キャンセル
} else { //mode=1未選択
	$strbutton1 = "";//新規登録、キャンセル
	$strbutton2 = " disabled";//複写
	$strbutton3 = " disabled";//登録
	$strbutton4 = " disabled";//更新
	$strbutton5 = " disabled";//削除
	$strbutton6 = " disabled";//キャンセル
}
if($userdata["roleid"] == 5) {  //センター権限は編集OFF
	$strbutton1 = " disabled";//新規登録、キャンセル
	$strbutton2 = " disabled";//複写
	$strbutton3 = " disabled";//登録
	$strbutton4 = " disabled";//更新
	$strbutton5 = " disabled";//削除
	$strbutton6 = " disabled";//キャンセル
}

?><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="css.css" rel="stylesheet" type="text/css">
<style type="text/css">
#tabblock1,#1510a {
	border: 2px solid darkkhaki ;
	background:palegoldenrod ;
}
#tabblock2,#1510b {
	border: 2px solid deepskyblue;
	background:paleturquoise ;
}
#tabblock3,#1510c {
	border: 2px solid palevioletred;
	background:#ffdddd ;
}
#tabblock1,#tabblock2,#tabblock3 {
	margin: 0 auto;
	text-align: left;
	height: 270px; overflow: auto !important; clear: left;
}
#1510a,#1510b,#1510c {
	font-size: 16px;
	padding: 3px;
	margin:3px;
}
.col1{width:240px;height:27px;padding:2px;margin:0px;border-top:1px solid #a9a9a9;border-left:1px solid #a9a9a9;float:left; }
.col2{width:240px;height:27px;padding:2px;margin:0px;border-top:1px solid #a9a9a9;border-right:1px solid #a9a9a9;float:none;}
</style>
<?php title(); ?>
</head>
<SCRIPT LANGUAGE="JavaScript">
<!--
function submitForm( page ,order ) {
  form = document.FormGetSubmit
  form.pagenum.value= page
  FormGetSubmit.submit()
}
-->
</SCRIPT>
<body>
<?php
if ($strtablename == "") {
	$strPHPtitle = "マスター編集";
} else {
	$strPHPtitle = $strtablenamej."編集";
}
Honbutitle3($strPHPtitle,$_SERVER['PHP_SELF']); 

if($strtablename == "") {
?>
<form action="1510.php#fragment-6" method="post" name="DSP" target="_top">
<div id ="masterediter0">
閲覧・編集するテーブルを選択してください。<br>
	<span class="border1box">
	<span class="border1box">
	<br>
		<input type="submit" value="商品マスター" name="shohin" class="box1"></BR>
	</span>
	<span class="border1box">
	<br>
	<input type="submit" value="ユーザーマスター" name="edit1" class="box1" disabled></BR>
	</span>
	<span class="border1box">
	<br>
	<input type="submit" value="サプライヤーマスター" name="maker" class="box1"></BR>
	</span>
	<span class="border1box">
	<br>
	<input type="submit" value="店舗マスター" name="tenpo" class="box1"></BR>
	</span>
<?php
For ($i = 0;$i < count($tabledata);$i++) {
//	echo "<input type=\"submit\" value=\"".$tabledata[$i][0]."\" name=\"edit".$i."\" class=\"box1\"></BR>\n";
}
?>
	</span>
</form>
</div>
<?php
} else {
?>
<div id ="masterediter3">
<form action="1510.php#fragment-6" method="post" name="EDIT" target="_top">
<?php 		
echo "<input type=\"hidden\" value=\"".$strtablename."\" name=\"tablename\">\n"; 
?>
<input type="submit" value="新規登録開始" name="insertnew"    class="box1" <?php echo $strbutton1; ?> >
<input type="submit" value="新規登録"   name="insert" class="box1" <?php echo $strbutton3; ?> >
<input type="submit" value="更　新"   name="update" class="box1" <?php echo $strbutton4; ?> >
<input type="submit" value="削　除"   name="delete" class="box1" <?php echo $strbutton5; ?> >
<input type="submit" value="編集取消"   name="clear"  class="box1" <?php echo $strbutton6; ?> >
<!-- input type="submit" value="複　写"   name="copy"   class="box1" <?php echo $strbutton2; ?> -->
<input type="button" onClick="location.href='1510.php'" value="<?php echo $strtablenamej ?>編集終了" name="button3" class="box1">
<?php
if(($_POST[insertnew] <> "") or ($_POST[copy] <> "") or ($_POST[select] == "yes")) {
?>
<!-- TABS CODE -->
	<a onClick="i.display=(this.checked?'':'block');j.display=(this.checked?'':'none');k.display=(this.checked?'':'none');" id="1510a">必須項目</a>
	<a onClick="i.display=(this.checked?'':'none');j.display=(this.checked?'':'block');k.display=(this.checked?'':'none');" id="1510b">詳細</a>
	<!-- a onClick="i.display=(this.checked?'':'none');j.display=(this.checked?'':'none');k.display=(this.checked?'':'block');" id="1510c">詳細２</a -->
	<DIV id="tabblock1" style="display:block">
<?php
$result=@mysql_query($strsqledit,$my_con);
$data = mysql_fetch_array($result);
$errcode =mysql_errno();if ($errcode <> 0) echo ("  $errcode ".$strsqledit); 

$maxrow=@mysql_num_rows($result);
For ($i = 0;$i < count($column_data);$i++) {
//	echo $column_data[$i][0];
//	echo $data{$column_data[$i][0]};

	if($_POST[insertnew] <> "") { $data{$column_data[$i][0]} = $column_info_data{$column_data[$i][0]}[2];} //新規登録は初期値を入れる
	switch ($column_data[$i][3]) {  //tab_block
		case 1: //必須
			$intPrintSelectList2 = "";
			echo "<div class=\"col1\">";
			echo GetList2($columndata,$column_data[$i][0]);
			echo "<input type=\"hidden\" value=\"".$data{$column_data[$i][0]}."\" name=\"".$column_data[$i][0]."_old\"></div>\n";
			if(count($foreign_key_data{$column_data[$i][0]}) > 0){
				echo "<div class=\"col2\"><SELECT NAME=\"".$column_data[$i][0]."\">";
				PrintSelectList2($foreign_key_data{$column_data[$i][0]},$data{$column_data[$i][0]},0);
				echo "</SELECT></div>\n";
			} else {
$strinputclass = "ZZZ";
				if(((int)$column_data[$i][4] == 1) or ((int)$column_info_data{$column_data[$i][0]}[6] == 0)) { //Tableinfo.char_size =0 or tableedit.hankaku = 1は半角英数のみIMEOFF
					$strinputclass = " class =\"EDIT\" "; 
				} else {
					$strinputclass = ""; 
				}
				//新規以外でキーのときは、編集不可
				if(($_POST[insertnew] == "") and ($column_info_data{$column_data[$i][0]}[1] == "PRI")) {
					$strkey = " disabled "; 
				} else {
					$strkey = ""; 
				}
				echo "<div class=\"col2\"><input type=\"text\" value=\"".$data{$column_data[$i][0]}."\" name=\"".$column_data[$i][0]."\" size = \"".$column_info_data{$column_data[$i][0]}[4]."\" maxlength = \"".$column_info_data{$column_data[$i][0]}[5]."\"".$strinputclass.$strkey."></div>\n";
			}

			break;
		case 2: //詳細
			$intPrintSelectList2 = 1;
			$strcase2 .= "<div class=\"col1\">";
			$strcase2 .= GetList2($columndata,$column_data[$i][0]);
			$strcase2 .= "<input type=\"hidden\" value=\"".$data{$column_data[$i][0]}."\" name=\"".$column_data[$i][0]."_old\"></div>\n";
			if(count($foreign_key_data{$column_data[$i][0]}) > 0){
				$strcase2 .="<div class=\"col2\"><SELECT NAME=\"".$column_data[$i][0]."\">";
				$strcase2 .= PrintSelectList2($foreign_key_data{$column_data[$i][0]},$data{$column_data[$i][0]},0);
				$strcase2 .="</SELECT></div>\n";
			} else {
				if(((int)$column_data[$i][4] == 1) or ((int)$column_info_data{$column_data[$i][0]}[6] == 0)) { //Tableinfo.char_size =0 or tableedit.hankaku = 1は半角英数のみIMEOFF
					$strinputclass = " class =\"EDIT\" "; 
				} else {
					$strinputclass = ""; 
				} 
				$strcase2 .= "<div class=\"col2\"><input type=\"text\" value=\"".$data{$column_data[$i][0]}."\" name=\"".$column_data[$i][0]."\" size = \"".$column_info_data{$column_data[$i][0]}[4]."\" maxlength = \"".$column_info_data{$column_data[$i][0]}[5]."\"".$strinputclass."></div>\n";
			}
			break;
		case 3:  //非表示
			$strcase3 .= "<div class=\"col1\">";
			$strcase3 .= GetList2($columndata,$column_data[$i][0]);
			$strcase3 .= "<input type=\"hidden\" value=\"".$data{$column_data[$i][0]}."\" name=\"".$column_data[$i][0]."_old\"></div>\n";
			$strcase3 .= "<div class=\"col2\"><input type=\"text\" value=\"".$data{$column_data[$i][0]}."\" name=\"".$column_data[$i][0]."\" size = \"".$column_info_data{$column_data[$i][0]}[4]."\" maxlength = \"".$column_info_data{$column_data[$i][0]}[5]."\" ></div>\n";
			break;
		default:
			break;
	}
}
?>
	</DIV>
	<DIV id="tabblock2" style="display:none">
<?php echo $strcase2; ?>
	</DIV>
	<DIV id="tabblock3" style="display:none">
<?php $strcase3; ?>
	</DIV>
<!-- TABS CODE -->
<?php
}
//検索時
For ($i = 0;$i < count($search_column_data);$i++) {
	echo "<input type=\"hidden\" value=\"".$_POST{"sw_".$search_column_data[$i]}."\" name=\"sw_".$search_column_data[$i]."\">\n";
}
?>
</div>
</form>
<div id ="masterediter1">
<form action="1510.php#fragment-6" method="post" name="EDIT" target="_top" STYLE="margin: 0px;">
<?php
//更新情報
	if (($okcount+$errcount)>0) {
		if ($okcount > 0 ){
			$msgok = "$okcount 件のデータを処理しました。";
		}
		if ($errcount > 0 ){
			$msgerr = "処理エラーが $errcount 件有りました。<br>".$errmsg;
		}
		PrintMsg($msgerr,$msgok,650);
	}

	echo "<input type=\"hidden\" value=\"".$strtablename."\" name=\"tablename\">\n";
	For ($i = 0;$i < count($search_column_data);$i++) {
		echo GetList2($columndata,$search_column_data[$i]);
		echo "<input type=\"text\" value=\"".$_POST{"sw_".$search_column_data[$i]}."\" name=\"sw_".$search_column_data[$i]."\" size = \"12\">\n";
	}
?><input type="submit" name="disp2" value="検索" class="box1"><input type="submit" name="dl" value="ダウンロード" class="box1">
</form>
</div>
<div id ="masterediter2">
<?php 
}

//テーブル選択時
if ($strtablename <> ""){
	$result=@mysql_query($strsql,$my_con);
	$errcode =mysql_errno();if ($errcode <> 0) echo ("  $errcode ".$strsql); 
	$maxrow=@mysql_num_rows($result);
	//１ページ分
	$strsql .= $limit;
	$result=@mysql_query($strsql,$my_con);

	echo "該当件数 ".$maxrow." 件";
?>
<table id="data-table">
<form action="1510.php#fragment-6" method="post" name="EDIT" target="_top">
<INPUT type="hidden" name="disp2"        value="page">
<?php 
	//カラム行
	$crows = mysql_num_fields($result);
	echo "<input type=\"hidden\" value=\"".$strtablename."\" name=\"tablename\">\n";
	echo "<input type=\"hidden\" value=\"yes\" name=\"select\">\n";
	echo "<input type=\"hidden\" value=\"".$page."\" name=\"pagenum\">\n";
	echo "<input type=\"hidden\" value=\"".GetListData($tabledata,$strtablename,2)."\" name=\"key\">\n";
	//タイトル行の表示
	$strhead ="	<tr>\n	<th colspan=\"2\">No.</th>\n";
	for ($i = 1;$i<$crows;$i++) {
		$strhead .="	<th>".GetList2($columndata,mysql_field_name($result, $i))."</th>\n";
		echo "<input type=\"hidden\" value=\"".$_POST{"sw_".mysql_field_name($result, $i)}."\" name=\"sw_".mysql_field_name($result, $i)."\" >\n";
	}
	echo "	</tr>";
	$strhead .="	</tr>\n";

	//日本語変換
	echo $strhead;

	$j = $pageset*($page  - 1);
	while ($data = mysql_fetch_array($result)) {
?>
	<tr> 
		<td><?php echo ($j+1);// ?></td>
		<input type="hidden" value="<?php echo $data[1]; ?>" name="key<?php echo ($j+1); ?>">
		<td><input type="submit" value="表示" name="edit<?php echo ($j+1); ?>"></td>
<?php
		for ($i = 1 ;$i < $crows;$i++) {
			if(count($foreign_key_data[mysql_field_name($result, $i)]) > 0) {
				echo "<td >".GetList($foreign_key_data{mysql_field_name($result, $i)},$data[$i])."</td>\n";
			} else {
				echo "<td >".$data[$i]."</td>\n";
			}
		}
?>
	</tr>
<?php 
		$j++;
	}
?>
</form>
</table>
<?php 
	ShowNavBar2($maxrow,$pageset,$page,"75%",1);
?>
</div>





<?php
} //END リストを表示する
?>
<SCRIPT LANGUAGE="JavaScript">
<!--
i=document.getElementById('tabblock1').style;
j=document.getElementById('tabblock2').style;
k=document.getElementById('tabblock3').style;
-->
</SCRIPT>

<FORM METHOD="POST" name="FormGetSubmit" action="1510.php#fragment-6">
<INPUT type="hidden" name="pagenum"        value="">
<INPUT type="hidden" name="tablename"        value="<?php echo $strtablename; ?>">
<INPUT type="hidden" name="disp"        value="page">
<?php
For ($i = 0;$i < count($search_column_data);$i++) {
	echo "<input type=\"hidden\" value=\"".$_POST{"sw_".$search_column_data[$i]}."\" name=\"sw_".$search_column_data[$i]."\">\n";
}
?>
</FORM>
</DIV>
<div  class="floatclear">
</DIV>
<?php Menu4($_SERVER['PHP_SELF']); ?>
</body>
</html>
<?php 
Function Sprint($str) {
	echo "\"".Sjis($str)."\",";
}
//スマートフォンのユーザーエージェント
$ua_list = array(
  'iPhone',    // Apple iPhone
  'iPod',    // Apple iPod touch
  'iPad',    // Apple iPod touch
  'Android',    // Android
  'dream',    // Pre 1.5 Android
  'CUPCAKE',    // 1.5+ Android
  'blackberry',    // blackberry
  'webOS',    // Palm Pre Experimental
  'incognito',    // Other iPhone browser
  'webmate'    // Other iPhone browser
  );

// 結果を初期化
$ua = "スマホではありません。";

for($i=0; $i<sizeof($ua_list); $i++) {
	
  $str = "/".$ua_list[$i]."/i";
  $ret = preg_match($str, $_SERVER['HTTP_USER_AGENT']);

    if($ret != 0 ){
	
      // 結果をセット
      $ua = "スマホの ".$ua_list[$i]. "です。";
      break;
    }
}
//secho $ua.$_SERVER['HTTP_USER_AGENT'];

myclose();
Testecho($strsql);
?>