<?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{"user"} <> "") {
		$strtablename  = "usermaster";
		$strtablenamej = GetList($tabledata,$strtablename);
	} elseif($_POST{"tenpo"} <> "") {
		$strtablename  = $company."shozokumaster";
		$strtablenamej = GetList($tabledata,$strtablename);
	} elseif($_POST{"staff"} <> "") {
		$strtablename  = $company."staff";
		$strtablenamej = GetList($tabledata,$strtablename);
	} elseif($_POST{"cust"} <> "") {
		$strtablename  = "customer";
		$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 as no";$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
		if(($userdata["supplyerid2"] <> "") AND (strstr($foreignkey[0][3],"companykind"))) {$strwhere .= " AND companyid in(".$userdata["supplyerid2"].")";} //企業指定がある場合は企業コードから絞る
		if(($userdata["brand"] <> "") AND ($column_data[$i][0] == "brand")) {$strwhere .= " AND code in(".$userdata["brand"].")";} //ブランド指定がある場合は企業コードから絞る
		$foreign_key_data{$column_data[$i][0]} = dbselect($foreignkey[0][2].",".$foreignkey[0][4],$strtablenameplus.$foreignkey[0][1],$strwhere,$foreignkey[0][4],-1);
Testecho($column_data[$i][0].$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 '%".trim(mb_convert_kana($_POST{"sw_".$column_data[$i][0]},"RNAKV"))."%'" ;
			$strsqlwhere .= " or ".$column_data[$i][0]." like '%".trim(mb_convert_kana($_POST{"sw_".$column_data[$i][0]},"rnak"))."%')" ;
		}
	}
}
//活鮮のみ商品カテゴリ変更　いい方法を模索すること
if(($userdata["companyid"] ==  "katsusen") or (substr($strselectdata,0,1) == "S")){
//var_dump($foreign_key_data);
	$foreign_key_data{"shohin_kubun1"} = dbselect("cname,code","`".$company."code`","codekind = 109 and code > 0","code",-1);
}
//該当テーブルの全カラム情報を取得
$column_info = dbselect("null_,Field_ ,key_,default_ ,extra_ ,char_size,type_","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初期キャラサイズ/7型
	$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],$column_info[$i][6]);
}


//データ表示
if(GetListData($tabledata,$strtablename,3) <> "") { $strsql = " and ".GetListData($tabledata,$strtablename,3);}
if(($userdata["supplyerid2"] <> "") and ($strtablename == $company."shohinmaster")) {
	$strsqlwhere .= " AND makercode in(".$userdata["supplyerid2"].")" ;
} elseif(($userdata["brand"] <> "") and ($strtablename == $company."shozokumaster")) {
	$strsqlwhere .= " AND brand in(".$userdata["brand"].")" ;
}

$strsqldownload = "SELECT * FROM `$strtablename` WHERE 1=1 ".$strsqlwhere.$strsql." ORDER BY 1";
$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]))."\",";
			$strtitledata .= "\"";
			if(count($foreign_key_data{$column_data[$i][0]}) > 0) {
				For($n = 0; $n < count($foreign_key_data{$column_data[$i][0]}); $n++) {
					$strtitledata .= $foreign_key_data{$column_data[$i][0]}[$n][1];
					$strtitledata .= ":";
					$strtitledata .= $foreign_key_data{$column_data[$i][0]}[$n][0];
					$strtitledata .= "\n";
				}
			}
			$strtitledata .= "\",";
			if($userdata["roleid"] == 1) {$strtitledata2 .= $column_data[$i][0].",";  }
		} else {
			//必須項目以外
		}
	}
	echo "\n";
	//凡例出力
	if($_POST["hanrei"] <> "") {
		echo Sjis($strtitledata2)."\n";
		echo Sjis($strtitledata)."\n";
	}
//	$strsqldownload = "SELECT * FROM `$strtablename` ORDER BY 1,2";
	$result=@mysql_query($strsqldownload,$my_con);
	while ($data = mysql_fetch_array($result)) {
		For ($i = 0;$i < count($column_data);$i++) {
			if((int)$column_data[$i][3] <3 ){
				//コード変換出力
				if($_POST["henkan"] == "") {
					//コードで出力
					echo Sprint($data{$column_data[$i][0]});
				} else {
					//コード変換で出力
					$str = $data{$column_data[$i][0]};
					if(count($foreign_key_data{$column_data[$i][0]}) > 0){
						//コード有り
						echo Sprint($str.".".GetListData($foreign_key_data{$column_data[$i][0]},$data{$column_data[$i][0]},0));
					} else {
						//コード無し
						echo Sprint($str);
					}
				}
			} 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 < 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 .= "'".sqlinjection2($_POST{$column_data[$i][0]},-1)."' ";
			}
		} else {
			//必須項目以外
		}
	}
	$strsqlupdate .= ",creater,createdate) values( ".$strsqlupdate2.",'".$userdata["tid"]."',now())";
	$result2=mysql_query($strsqlupdate,$my_con);
	$errcode =mysql_errno();if ($errcode==0) $okcount++;
	Testecho ($y." ERR = $errcode :ROWS = ".mysql_affected_rows()." ". $strsqlupdate);  #debug
mysql_sql_log($strsqlupdate,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
	if($errcode == 1062) {
		$errmsg = "既に同じコードが登録されています<br>\n";$errcount++;
	}

	if($_POST{"tablename"} == "usermaster") {
	//ユーザーマスターだけ複数テーブル書き込み 
		$strsqlupdate  = "INSERT INTO loginmaster (`tid`, `tpassword`, `yukoflg`, `createdate`) values ('".trim($_POST["tid"])."','".md5("1234567890")."','".trim($_POST["yukoflg_temp"])."',now());";
		$result2=mysql_query($strsqlupdate,$my_con);
		$errcode =mysql_errno();if ($errcode==0) $okcount++;
		Testecho ($y." ERR = $errcode :ROWS = ".mysql_affected_rows()." ". $strsqlupdate);  #debug
mysql_sql_log($strsqlupdate,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

		$strsqlupdate ="INSERT INTO userrole  (`tid`, `roleid`, `companyid`, `gyotaiid`) values ('".trim($_POST["tid"])."','".trim($_POST["roleid_temp"])."','".$userdata["hcompanyid"]."','1');";
		$result2=mysql_query($strsqlupdate,$my_con);
		$errcode =mysql_errno();if ($errcode==0) $okcount++;
		Testecho ($y." ERR = $errcode :ROWS = ".mysql_affected_rows()." ". $strsqlupdate);  #debug
mysql_sql_log($strsqlupdate,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

		$strsqlupdate="update `usermaster`  set companyid = companyid_temp where tid ='".trim($_POST["tid"])."' LIMIT 1";
		$result2=mysql_query($strsqlupdate,$my_con);
		$errcode =mysql_errno();if ($errcode==0) ;
		Testecho ($y."  $errcode ".$strsqlupdate);  #debug
	}

} 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 .= "'".sqlinjection2($_POST{$column_data[$i][0]},-1)."' ";
				}
			}
		} else {
			//必須項目以外
		}
	}
	$strsqlupdate .= " WHERE ".$strsqlupdate2." limit 1";
//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 :ROWS = ".mysql_affected_rows()." ". $strsqlupdate);  #debug
mysql_sql_log($strsqlupdate,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

	$strsqlupdate = "UPDATE `".$strtablename."` SET updater = '".$userdata["tid"]."',updatedate =now()";
	$strsqlupdate .= " WHERE ".$strsqlupdate2." limit 1";
	$result2=mysql_query($strsqlupdate,$my_con);
	$errcode =mysql_errno();if ($errcode==0) $okcount++;
	Testecho ($y." ERR = $errcode :ROWS = ".mysql_affected_rows()." ". $strsqlupdate);  #debug
mysql_sql_log($strsqlupdate,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

	if($_POST{"tablename"} == "usermaster") {
	//ユーザーマスターだけ複数テーブル書き込み 
		$strsqlupdate  = "UPDATE loginmaster SET `yukoflg` = '".trim($_POST["yukoflg_temp"])."' WHERE `tid` = '".trim($_POST["tid_old"])."' LIMIT 1";
		$result2=mysql_query($strsqlupdate,$my_con);
		$errcode =mysql_errno();if ($errcode==0) $okcount++;
		Testecho ($y." ERR = $errcode :ROWS = ".mysql_affected_rows()." ". $strsqlupdate);  #debug
mysql_sql_log($strsqlupdate,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

		$strsqlupdate ="UPDATE userrole SET  `roleid` = '".trim($_POST["roleid_temp"])."', `companyid` = '".$userdata["hcompanyid"]."' WHERE `tid` = '".trim($_POST["tid_old"])."' LIMIT 1";
		$result2=mysql_query($strsqlupdate,$my_con);
		$errcode =mysql_errno();if ($errcode==0) $okcount++;
		Testecho ($y." ERR = $errcode :ROWS = ".mysql_affected_rows()." ". $strsqlupdate);  #debug
mysql_sql_log($strsqlupdate,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

		$strsqlupdate="update `usermaster`  set companyid = companyid_temp where tid ='".trim($_POST["tid_old"])."' LIMIT 1";
		$result2=mysql_query($strsqlupdate,$my_con);
		$errcode =mysql_errno();if ($errcode==0) ;
		Testecho ($y."  $errcode ".$strsqlupdate);  #debug
	}

} elseif($_POST[delete3]<>"") {
	$strsqlupdate = "DELETE FROM `".$strtablename."` ";
	For ($i = 0;$i < count($column_data);$i++) {
		if((int)$column_data[$i][3] < 3 ){
			//必須項目＋詳細
			if ($i == 0) {
				$strsqlupdate2 = "`".$column_data[$i][0]."` = '".$_POST{$column_data[$i][0]."_old"}."'"; 
			} else {
			}
		} else {
			//必須項目以外
		}
	}
	$strsqlupdate .= " WHERE ".$strsqlupdate2." Limit 1";
//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 :ROWS = ".mysql_affected_rows()." ". $strsqlupdate);  #debug
mysql_sql_log($strsqlupdate,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

	if($_POST{"tablename"} == "usermaster") {
	//ユーザーマスターだけ複数テーブル書き込み 
		$strsqlupdate  = "DELETE FROM loginmaster  WHERE `tid` = '".trim($_POST["tid_old"])."' LIMIT 1";
		$result2=mysql_query($strsqlupdate,$my_con);
		$errcode =mysql_errno();if ($errcode==0) $okcount++;
		Testecho ($y." ERR = $errcode :ROWS = ".mysql_affected_rows()." ". $strsqlupdate);  #debug
mysql_sql_log($strsqlupdate,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

		$strsqlupdate ="DELETE FROM userrole  WHERE `tid` = '".trim($_POST["tid_old"])."' LIMIT 1";
		$result2=mysql_query($strsqlupdate,$my_con);
		$errcode =mysql_errno();if ($errcode==0) $okcount++;
		Testecho ($y." ERR = $errcode :ROWS = ".mysql_affected_rows()." ". $strsqlupdate);  #debug
mysql_sql_log($strsqlupdate,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
	}
}
//商品画像
if (($_POST[insert]<>"") or ($_POST[update]<>"")) {
	if($_FILES['userfile']['name'] <> "") {
		//ファイル名の移動先の指定
		$strimagefile = "00".$_POST[shohincd_old].date("Gis").substr($_FILES['userfile']['name'],-4);
		$filename = $imagebase.$imagehtml.$strimagefile;
		move_uploaded_file($_FILES['userfile']['tmp_name'],$filename);

		if($_FILES['userfile']['tmp_name'] == ""){
			//ファイル無し
			$errmsg = "<H2><P>アップロードファイルを指定してください<P></H2>";
			$errcount++;
		} elseif(($_POST[shohincd] == "new") and ($_POST[shohincd] == "")){
			//ファイル無し
			$errmsg = "<H2><P>商品を選択してください<P></H2>";
			$errcount++;
		} else {
			if($_POST[insert] <> "") { $strcode = $_POST[shohincd];} else {$strcode = $_POST[shohincd_old]; }
			$strsqlimage = "UPDATE `".$company."shohinmaster` set shohin_string1 = '".$strimagefile."'  WHERE shohincd = '".$strcode."'";
			$resultimage=mysql_query($strsqlimage,$my_con);
			$errcode =mysql_errno();if ($errcode==0) $okcount++;
mysql_sql_log($strsqlimage,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
			Testecho ($y." 商品マスター画像登録 ROWS=".mysql_affected_rows()." $errcode ".$strsqlimage);  #debug
		}
		system("chmod 644 /var/www/vhosts/logigate.jp/httpdocs/ff/images2/*.jpg");
	}
}

//検索用語格納・商品所属マスタ
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":
		if(($_POST[update]<>"") or ($_POST[select]<>"") or ($_POST[insert]<>"")) {
			$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
			}
		}
		//商品マスタより紐付けテーブルを作成する。
		if($settingdata["shozokushohin_all_cr"] == 1){
			$strsqlx = "TRUNCATE TABLE `".$company."shozokushohin`;";
			$result=mysql_query($strsqlx,$my_con);
			Testecho ($y."ROWS = ".mysql_affected_rows()."紐付けテーブル削除".$strsqlx);  #debug

			$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);
			Testecho ($y."ROWS = ".mysql_affected_rows()."紐付けテーブル作成".$strsqlx);  #debug
			UpdateShohinLevel($company,1);
		}
		break;

	case $company."shohinmaster":
		//検索用語を更新する
		$strsqlsw = "SELECT shohincd,shohincd2,shohinmei,shohinmei2 FROM `".$company."shohinmaster`";
		if($company <> "xxx") {
			$strsqlsw = "SELECT shohincd,shohincd2,shohinmei,shohinmei2 FROM `".$company."shohinmaster` WHERE shohincd='".$_POST["shohincd_old"]."'";
		} else {
			$strsqlsw = "SELECT shohincd,shohincd2,shohinmei,shohinmei2 FROM `".$company."shohinmaster`";
		}
		$result=@mysql_query($strsqlsw,$my_con);
		if(($_POST[update]<>"") or ($_POST[select]<>"") or ($_POST[insert]<>"") or ($company <> "body_")) {
			while ($data = mysql_fetch_array($result)) {
				//検索用語
				$sw = mb_convert_kana($data['shohinmei'].$data['shohinmei2'],'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
			}
		} elseif($company == "body_") {
			while ($data = mysql_fetch_array($result)) {
				//検索用語
				$sw = mb_convert_kana($data['shohinmei'].$data['shohinmei2'],'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
			}
		}

		//新規商品のロケーションデータを作成する 
		if ($_POST["insert"] <> "") {
			$shohincenter = dbselect("distinct(centerid)","`".$company."comeinfix`",-1,-1,-1);
			Testecho("SC".$strsqldbselect.sizeof($shohincenter));
			For($ii = 0;$ii < sizeof($shohincenter) ; $ii++) {
				$strsqlx = "INSERT INTO `".$company."shohinlocation`(`loccode`,`honbuid`,`centerid`,`shohincd`,`creater`,`createdatetime`) SELECT shohincd,1,'".$shohincenter[$ii][0]."',shohincd,'".$userdata["tid"]."',now() FROM `".$company."shohinmaster` where shohincd='".$_POST["shohincd_old"]."' limit 1";
				$result2=mysql_query($strsqlx,$my_con);
				Testecho ($y."ROWS = ".mysql_affected_rows()."商品ロケーション作成T ".$strsqlx);  #debug
			}
			//商品マスタより紐付けテーブルを作成する
			if($settingdata["shozokushohin_all_cr"] == 1){
				//紐付け再作成
				$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 AND shohincd='".$_POST["shohincd"]."'";
				$result=mysql_query($strsqlx,$my_con);
				Testecho ($y."紐付けテーブルIMPORT".$strsqlx);  #debug
			}
		} elseif($_POST[update] <> "") {
			//商品マスタより紐付けテーブルを作成する
			if($settingdata["shozokushohin_all_cr"] == 1){
				//紐付け再作成
				$strsqlx = "TRUNCATE TABLE `".$company."shozokushohin`;";
				$strsqlx = "DELETE FROM `".$company."shozokushohin` WHERE shohincd='".$_POST["shohincd_old"]."'";
				$result=mysql_query($strsqlx,$my_con);
				Testecho ($y."ROWS = ".mysql_affected_rows()."紐付けテーブル削除".$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 AND shohincd='".$_POST["shohincd_old"]."'";
				$result=mysql_query($strsqlx,$my_con);
				Testecho ($y."紐付けテーブルIMPORT".$strsqlx);  #debug
			}
			//商品ロケーションテーブルを再作成する
			if($settingdata["shohinlocation_all_c"] == 1){
			//	$strsqlx = "TRUNCATE TABLE `".$company."shohinlocation`";
				$strsqlx = "DELETE FROM `".$company."shohinlocation` where shohincd='".$_POST["shohincd_old"]."'";
				$result=mysql_query($strsqlx,$my_con);
				Testecho ($y."ROWS = ".mysql_affected_rows()."　Locationテーブル削除".$strsqlx);  #debug

				$strsqlsw = "SELECT shohincd FROM `".$company."shohinmaster` where shohincd='".$_POST["shohincd_old"]."'";
				Testecho ($y."リスト".$strsqlsw);  #debug
				$resultsw=@mysql_query($strsqlsw,$my_con);
				while ($data = mysql_fetch_array($resultsw)) {
					//センターの取得
					$shohincenter = dbselect("distinct(centerid)","`".$company."comeinfix`","shohincd='".$data['shohincd']."'",-1,-1);
					//検索用語
					Testecho("SC".$strsqldbselect.sizeof($shohincenter));
					For($ii = 0;$ii < sizeof($shohincenter) ; $ii++) {
						$strsqlx = "INSERT INTO `".$company."shohinlocation`(`loccode`,`honbuid`,`centerid`,`shohincd`,`creater`,`createdatetime`) SELECT shohincd,1,'".$shohincenter[$ii][0]."',shohincd,'".$userdata["tid"]."',now() FROM `".$company."shohinmaster` WHERE shohincd = '".$data['shohincd']."'";
						$resultlc=mysql_query($strsqlx,$my_con);
						Testecho ($y."ROWS = ".mysql_affected_rows()."商品ロケーション作成T".$strsqlx);  #debug
					}
				}

			}
		}
		if($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

/*			$strsqlx = "update `body_shohinmaster` set searchword = concat(shohincd,ifnull(shohincd2,''),shohinmei,ifnull(shohinmei2,''))";
			$result=mysql_query($strsqlx,$my_con);
			Testecho ($y."サーチ".$strsqlx);  #debug
*/
//期間限定
/*				$strsqlx = "update body_shozokushohin as a,body_shohinmaster as b set nohinprice = price_sell where a.shohincd = b.shohincd;";
			$result=mysql_query($strsqlx,$my_con);
	Testecho ($y." ERR = $errcode :ROWS = ".mysql_affected_rows()." ". $strsqlx);  #debug
			$strsqlx = "update body_ordersheet as a,body_shohinmaster as b set orderprice = price_sell where a.shohincd = b.shohincd;";
			$result=mysql_query($strsqlx,$my_con);
	Testecho ($y." ERR = $errcode :ROWS = ".mysql_affected_rows()." ". $strsqlx);  #debug
			$strsqlx = "update body_comeinfix as a,body_shohinmaster as b set comeinprice = price_buy,comeinpricetotal  = price_buy * comeinfixqty where a.shohincd = b.shohincd and comeinprice > 0;";
			$result=mysql_query($strsqlx,$my_con);
	Testecho ($y." ERR = $errcode :ROWS = ".mysql_affected_rows()." ". $strsqlx);  #debug
			$strsqlx = "update body_salesdetail as a,body_shohinmaster as b set price_piece = price_sell,price_total = price_sell * shukkaqty where a.shohincd = b.shohincd and salesdetailflg < 5;";
			$result=mysql_query($strsqlx,$my_con);
	Testecho ($y." ERR = $errcode :ROWS = ".mysql_affected_rows()." ". $strsqlx);  #debug
			$strsqlx = "update body_shukka  as a,body_shohinmaster as b set price_piece = price_sell,price_total = price_sell * shukkaqty where a.shohincd = b.shohincd;";
			$result=mysql_query($strsqlx,$my_con);
	Testecho ($y." ERR = $errcode :ROWS = ".mysql_affected_rows()." ". $strsqlx);  #debug
			$strsqlx = "update body_shukkafix  as a,body_shohinmaster as b set price_piece = price_sell,price_total = price_sell * shukkaqty where a.shohincd = b.shohincd;";
			$result=mysql_query($strsqlx,$my_con);
	Testecho ($y." ERR = $errcode :ROWS = ".mysql_affected_rows()." ". $strsqlx);  #debug
			$strsqlx = "update body_directsupply  as a,body_shohinmaster as b set price_piece = price_sell,price_total = price_sell * shukkaqty where a.shohincd = b.shohincd and ordeid > 0;";
			$result=mysql_query($strsqlx,$my_con);
	Testecho ($y." ERR = $errcode :ROWS = ".mysql_affected_rows()." ". $strsqlx);  #debug
*/
		} else {
		//	UpdateShohinLevel($company,1);
		}
		//	UpdateShohinLevel($company,1);
		break;
	case $company."shozokumasterxxx":
		if($_POST[update] <> "") {
			$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;

	case "usermaster":
		if($_POST[select] == "yes") {
			//編集モードのときだけ ユーザーロールを格納
			$strsqlupdate="update `usermaster` as a ,`userrole` as b set a.roleid_temp = b.roleid  where a.tid = b.tid";
			$result2=mysql_query($strsqlupdate,$my_con);
			$errcode =mysql_errno();if ($errcode==0) ;
			Testecho ($y."  $errcode ".$strsqlupdate);  #debug
		}
		break;
	case $company."staff":
			$strsqlupdate="update `".$company."staff` SET searchword = concat(staffid,staff_name,ifnull(staff_name_kana,'')) ";
			$result2=mysql_query($strsqlupdate,$my_con);
			$errcode =mysql_errno();if ($errcode==0) ;
			Testecho ($y."  $errcode ".$strsqlupdate);  #debug
		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 = "";//キャンセル
	$strbutton7 = " disabled";//編集終了
} elseif($_POST[select] == "yes") { //mode=3表示
 	$strbutton1 = " disabled";//新規登録
	$strbutton2 = " disabled";//複写
	$strbutton3 = " disabled";//登録
	$strbutton4 = "";//更新
	$strbutton5 = "";//削除
	$strbutton6 = "";//キャンセル
	$strbutton7 = " disabled";//編集終了
} else { //mode=1未選択
	$strbutton1 = "";//新規登録、キャンセル
	$strbutton2 = " disabled";//複写
	$strbutton3 = " disabled";//登録
	$strbutton4 = " disabled";//更新
	$strbutton5 = " disabled";//削除
	$strbutton6 = " disabled";//キャンセル
	$strbutton7 = "";//編集終了
}
if($userdata["roleid"] == 15) {  //センター権限は編集OFF
	$strbutton1 = " disabled";//新規登録、キャンセル
	$strbutton2 = " disabled";//複写
	$strbutton3 = " disabled";//登録
	$strbutton4 = " disabled";//更新
	$strbutton5 = " disabled";//削除
	$strbutton6 = " disabled";//キャンセル
	$strbutton7 = "";//編集終了
}

?><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,#a1510a {
	border: 2px solid darkkhaki ;
	background:palegoldenrod ;
}
#tabblock2,#a1510b {
	border: 2px solid deepskyblue;
	background:paleturquoise ;
}
#tabblock3,#a1510c {
	border: 2px solid palevioletred;
	background:#ffdddd ;
}
#tabblock1,#tabblock2,#tabblock3 {
	margin: 0 auto;
	text-align: left;
	height: 550px; overflow: auto !important;float :left;
	width: 850px;
}
#a1510a,#a1510b,#a1510c {
	font-size: 16px;
	padding: 3px;
	margin:3px;
}
<?php if(($_POST[disp] <> "") or ($_POST[update] <> "") or ($_POST[delete3] <> "") or ($_POST[clear] <> "") or ($_POST[first] <> "") or ($_POST[insert] <> "")) { //一覧表示時は更新フィールドを縮める ?>
#masterediter3{
	height: 60px; overflow: auto !important; clear: left;
}
<?php } ?>
.col1{width:250px;min-height:23px;height:auto !important;padding:2px;margin:0px;border-top:1px solid #a9a9a9;border-left :2px solid #a9a9a9;border-right :2px solid white;border-bottom :0px solid palegoldenrod;		float:left;display: inline-block;}
.col2{width:450px;min-height:23px;height:auto !important;padding:2px;margin:0px;border-top:1px solid #a9a9a9;border-left:2px solid #a9a9a9;border-right :2px solid white;border-bottom :0px solid palegoldenrod;		float:none;display: inline-block;}
.col3{width:450px;min-height:23px;height:auto !important;padding:2px;margin:0px;border-top:1px solid darkorange;border-left:2px solid darkorange;border-right :2px solid darkorange;border-bottom :0px solid palegoldenrod;		float:none;display: inline-block;background-color: khaki;}
</style>
<?php title(); ?>
</head>
<script type="text/javascript">
<!--
function submitForm( page ,order ) {
  form = document.FormGetSubmit
  form.pagenum.value= page
  FormGetSubmit.submit()
}
function submitFormDelete(v2) {
	backToTop();

	document.getElementById('fade').style.display='block';
	if (confirm("＜＜■■■ 警 告 ■■■＞＞\nマスターデータの1件を削除しようとしています！\n表示されているこの１件を削除しても良いですか？\n過去1年間にこのデータが使用されている場合は、データの不整合が発生します。\n削除を実行する場合はOKを、削除しない場合はキャンセルを押して下さい。")){ 
		form = document.editmain;
		form.delete3.value= '削 除'
		form.submit();
	} else {
	}
	document.getElementById('fade').style.display='none';
}
-->
</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>
	<input type="hidden" name="first" value="first">
	<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="user" class="box1"<?php if($company <> "body_") { echo "disabled";} ?>></BR>
	</span>
	<span class="border1box">
	<br>
	<input type="submit" value="サプライヤーマスター" name="maker" class="box1" <?php if($userdata["kengen"] > 10) { echo "disabled";} ?>></BR>
	</span>
	<span class="border1box">
	<br>
	<input type="submit" value="店舗マスター" name="tenpo" class="box1" <?php if($userdata["kengen"] > 10) { echo "disabled";} ?>></BR>
	</span>
	<span class="border1box">
	<br>
	<input type="submit" value="顧客マスター" name="cust" class="box1" <?php if($company <> "nagase_") { echo "disabled";} ?>> </BR>
	</span>
<?php
if($company == "body_") {
?>
	<span class="border1box">
	<br>
	<input type="submit" value="セラピストマスター" name="staff" 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">
<a name="#editmode"></a>
<form enctype="multipart/form-data" action="1510.php#editmode" method="post" name="editmain" target="_top">
<?php 		
	echo "<input type=\"hidden\" value=\"".$strtablename."\" name=\"tablename\">\n"; 
	echo "<input type=\"hidden\" value=\"".$_POST["pagenum"]."\" name=\"pagenum\">\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="button" onClick="submitFormDelete('00'); return true;" value="削　除"  name="delete2" class="box1" <?php echo $strbutton5; ?> >
<input type="hidden" name="delete3"        value="">
<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 echo $strbutton7; ?>>
<?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="a1510a">必須項目</a>
	<a onClick="i.display=(this.checked?'':'none');j.display=(this.checked?'':'block');k.display=(this.checked?'':'none');" id="a1510b">詳細</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";
			//新規でキーのときはSELECT無し
			if(($_POST[insertnew] <> "") and ($column_info_data{$column_data[$i][0]}[1] == "PRI")) {
				$foreign_key_data{$column_data[$i][0]} = null; 
			}
			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 = ""; 
				}
				if($column_info_data{$column_data[$i][0]}[7] == "text") {
					echo "<div class=\"col2\"><TEXTAREA rows=8 cols = 60 name=\"".$column_data[$i][0]."\">".$data{$column_data[$i][0]}."</TEXTAREA>\n</div>\n";
				} else {
					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]."\">";
				if(count($foreign_key_data{$column_data[$i][0]}) > 0) {
					For($n = 0; $n < count($foreign_key_data{$column_data[$i][0]}); $n++) {
						if($foreign_key_data{$column_data[$i][0]}[$n][1] == $data{$column_data[$i][0]}) {
							$strselected2 = " SELECTED style=\"color:#000000; background-color:#f5deb3\"";
						} else {
							$strselected2 = "";
						}
						$strcase2 .= "<option ".$strselected2."value=\"".$foreign_key_data{$column_data[$i][0]}[$n][1]."\">[".$foreign_key_data{$column_data[$i][0]}[$n][1]."] ";
						$strcase2 .= $foreign_key_data{$column_data[$i][0]}[$n][0];
						$strcase2 .= "</option>\n";
					}
				}
				$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;
	}
}
if (($_POST[tablename] == $company."shohinmaster") and ((int)$settingdata["shohin_image"] == 1)) { //
	echo "<div class=\"col1\">商品画像</div>";
	echo "<div class=\"col2\"><input name=\"userfile\" type=\"file\" size=\"35\" >";
	if ($data["shohin_string1"] <> "") {
		echo "<IMG SRC = \"".$imagehtml.$data["shohin_string1"]."\">";
	}
	echo "</div>";

}
?>

	</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>
<form action="1510.php#disptable" method="post" name="EDIT2" target="_top" STYLE="margin: 0px;">
<a name="#disptable"></a>
<div id ="masterediter1">
<?php
echo "<input type=\"hidden\" value=\"".$_POST["pagenum"]."\" name=\"pagenum\">\n";
//更新情報
	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">
<input type="checkbox" name = "hanrei" value = "Y" >凡例を出力
<input type="checkbox" name = "henkan" value = "Y" checked>コードを変換
</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);

	if($maxrow <= ($pageset * ($page  - 1))) {
		$limit = " LIMIT 0,$pageset";
		$page = 1;
	}
	//１ページ分
	$strsql .= $limit;
	$result=@mysql_query($strsql,$my_con);

	echo "該当件数 ".$maxrow." 件";
?>
<table id="data-table">
<form action="1510.php#editmode" method="post" name="EDIT3" target="_top">
<INPUT type="hidden" name="disp2"        value="page">
<?php 
	echo "<input type=\"hidden\" value=\"".$_POST["pagenum"]."\" name=\"pagenum\">\n";
	//カラム行
	$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++) {
		if(count($foreign_key_data[mysql_field_name($result, $i)]) > 0) {
		// $strhead .="	<th>".GetList2($columndata,mysql_field_name($result, $i))."CD</th>\n";
		}
		$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 >".$data[$i]." : ".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 リストを表示する
?>
<?php if(($_POST[disp2] <> "") or ($_POST[insertnew] <> "")) { ?>
<SCRIPT LANGUAGE="JavaScript">
<!--
i=document.getElementById('tabblock1').style;
j=document.getElementById('tabblock2').style;
k=document.getElementById('tabblock3').style;
-->
</SCRIPT>
<?php } ?>
<FORM METHOD="POST" name="FormGetSubmit" action="1510.php#disptable">
<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();
/*------------------------------------------------------------
 *  関数名 : sqlinjection2
 *  返却値 : インジェクション対策された値
 *  引数   : (1) str:POSTされた値
 *  引数   : (2) str:予備
 *  説明   : POSTされた値をインジェクション対策する
 *  使用例 : sqlinjection2($_POST["memo"],-1);
 *------------------------------------------------------------
 */
function sqlinjection2(
	$string,
	$yobi)
{
	$string = trim($string);
	$string = str_replace("'","’",$string);  //全角変換
	$string = str_replace(",","",$string);  //削除
	$string = str_replace("\\","",$string);  //削除
	$string = str_replace("\"","",$string);  //削除
	$string = str_replace("%","％",$string);  //全角変換
	$string = htmlspecialchars($string);
	$string = stripslashes($string);
	$string = mysql_real_escape_string($string);
	return $string;
}

Testecho($maxrow.$strsql);
?>