<?phcars("../common.php");

if($_POST[id] == '' && $_GET[id] == '' ){
header("Location: ".$_SERVER['HTTP_REFERER']);
}
if($_GET[id]){
	$_POST = $_GET;
}

//全データを読み込むSQL文を組み立てます
$con = mysql_connect($DBSERVER, $DBUSER, $DBPASSWORD);
//MySQL読み込み時の文字コードを設定
mysql_query("set names UTF-8");
//データベースを選択します
$selectdb = mysql_select_db($DBNAME, $con);

if($_POST[select_mode] == 'kousin'){
foreach ($_POST[id] as $id) {
$sql = 'UPDATE `es_list` SET `expiration` = 3 , `Datetime_Edit` = NOW( ) WHERE `Id` = '.$id.' LIMIT 1 ';
$rst = mysql_query($sql, $con);
}
//echo $sql;
//
header("Location: ".$_SERVER['HTTP_REFERER']);
}

if($_POST[select_mode] == 'koukai'){
foreach ($_POST[id] as $id) {
$sql = 'UPDATE `es_list` SET `expiration` = 3 , `Portal_Flug` = 1 , `Datetime_Edit` = NOW( ) WHERE `Id` = '.$id.' AND `Custom_Flug` = 0 LIMIT 1 ';
$rst = mysql_query($sql, $con);

}
//echo $sql;
//
header("Location: ".$_SERVER['HTTP_REFERER']);
}

if($_POST[select_mode] == 'hikoukai'){
foreach ($_POST[id] as $id) {
$sql = 'UPDATE `es_list` SET `Portal_Flug` = 0 , `Portal_Top_Flug` = 0 WHERE `Id` = '.$id.' LIMIT 1 ';
$rst = mysql_query($sql, $con);
}
header("Location: ".$_SERVER['HTTP_REFERER']);
}

if($_POST[select_mode] == 'po_koukai'){
foreach ($_POST[id] as $id) {
$sql = 'UPDATE `es_list` SET `expiration` = 3 , `Portal_Flug` = 1 , `Portal_Top_Flug` = 1, `Datetime_Edit` = NOW( ) WHERE `Id` = '.$id.' AND `Custom_Flug` = 0 LIMIT 1 ';
$rst = mysql_query($sql, $con);
}
header("Location: ".$_SERVER['HTTP_REFERER']);
}

if($_POST[select_mode] == 'po_hikoukai'){
foreach ($_POST[id] as $id) {
$sql = 'UPDATE `es_list` SET `Portal_Top_Flug` = 0 WHERE `Id` = '.$id.' LIMIT 1 ';
$rst = mysql_query($sql, $con);
}
header("Location: ".$_SERVER['HTTP_REFERER']);
}


if($_POST[select_mode] == 'hp_koukai'){
foreach ($_POST[id] as $id) {
$sql = 'UPDATE `es_list` SET `expiration` = 3 , `Kiriwake_Flug` = 1 WHERE `Id` = '.$id.' LIMIT 1 ';
$rst = mysql_query($sql, $con);
//echo $sql;

}
header("Location: ".$_SERVER['HTTP_REFERER']);
}

if($_POST[select_mode] == 'hp_hikoukai'){
foreach ($_POST[id] as $id) {
$sql = 'UPDATE `es_list` SET `Kiriwake_Flug` = 0 , `Kiriwake_Top_Flug` = 0 , `Area_pickup_Flug` = 0 WHERE `Id` = '.$id.' LIMIT 1 ';
$rst = mysql_query($sql, $con);
}
header("Location: ".$_SERVER['HTTP_REFERER']);
}

if($_POST[select_mode] == 'hp_koukai_top'){
foreach ($_POST[id] as $id) {
$sql = 'UPDATE `es_list` SET `expiration` = 3 , `Kiriwake_Flug` = 1 ,  `Kiriwake_Top_Flug` = 1 WHERE `Id` = '.$id.' LIMIT 1 ';
$rst = mysql_query($sql, $con);
}
header("Location: ".$_SERVER['HTTP_REFERER']);
}

if($_POST[select_mode] == 'hp_hikoukai_top'){
foreach ($_POST[id] as $id) {
$sql = 'UPDATE `es_list` SET `Kiriwake_Top_Flug` = 0 WHERE `Id` = '.$id.' LIMIT 1 ';
$rst = mysql_query($sql, $con);
}
header("Location: ".$_SERVER['HTTP_REFERER']);
}

if($_POST[select_mode] == 'hp_koukai_ap'){
foreach ($_POST[id] as $id) {
$sql = 'UPDATE `es_list` SET `expiration` = 3 , `Area_pickup_Flug` = 1 , `Kiriwake_Flug` = 1 WHERE `Id` = '.$id.' LIMIT 1 ';
$rst = mysql_query($sql, $con);
}
header("Location: ".$_SERVER['HTTP_REFERER']);
}

if($_POST[select_mode] == 'hp_hikoukai_ap'){
foreach ($_POST[id] as $id) {
$sql = 'UPDATE `es_list` SET `Area_pickup_Flug` = 0 WHERE `Id` = '.$id.' LIMIT 1 ';
$rst = mysql_query($sql, $con);
}
header("Location: ".$_SERVER['HTTP_REFERER']);
}

if($_POST[select_mode] == 'hp_hikoukai_custom'){
foreach ($_POST[id] as $id) {
$sql = 'UPDATE `es_list` SET `Custom_Flug` = 1 , `Portal_Flug` = 0 , `Portal_Top_Flug` = 0  WHERE `Id` = '.$id.' LIMIT 1 ';
$rst = mysql_query($sql, $con);
}
header("Location: ".$_SERVER['HTTP_REFERER']);
}

if($_POST[select_mode] == 'hp_koukai_custom'){
foreach ($_POST[id] as $id) {
$sql = 'UPDATE `es_list` SET `expiration` = 3 , `Custom_Flug` = 0  WHERE `Id` = '.$id.' LIMIT 1 ';
$rst = mysql_query($sql, $con);
}
header("Location: ".$_SERVER['HTTP_REFERER']);
}

if($_POST['del'] == "ok"){

if (!is_array($_POST[id])) {
$array_id[] = $_POST[id];
}else{
$array_id = $_POST[id];
}

foreach ($array_id as $id) {

$sql = '
UPDATE `es_list` SET 
`expiration` = 0 WHERE `Id` = '.$id.' LIMIT 1 ;
';
//echo $sql;
$rst = mysql_query($sql, $con);

}
header("Location: ".$_POST[url]);

}
?>
<!DOCtype html PUBLIC "-//W3C//Dtd XHTML 1.0 transitional//EN" "http://www.w3.org/tr/xhtml1/Dtd/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="ja" xml:lang="ja">
<head>
<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Script-type" content="text/javascript" />
<meta http-equiv="Content-Style-type" content="text/css" />
<meta http-equiv="Pragma" content="no-cache">
<meta http-equiv="Cache-Control" content="no-cache">
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE8; IE=EmulateIE9">
<title>物件登録画面</title>
<link href="css/editer.css" rel="stylesheet" type="text/css">
<link href="../SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="lib/jq/jquery.js"></script>
<script type="text/javascript" src="lib/jquery.validation.js"></script>
<script type="text/javascript" src="lib/defult.js"></script>
<script src="../SpryAssets/SpryMenuBar.js" type="text/javascript"></script>

</head>
<body >
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td rowspan="2">&nbsp;</td>
<td width="950"><div class="header"><a href="/"><img src="img/header.gif" width="950" /></a><span class="header"></span></div></td>
<td rowspan="2">&nbsp;</td>
</tr>
<tr>
<td height="50"></td>
</tr>
</table><br><br><br>
	<table width="250" border="0" cellspacing="5" cellpadding="0" align="center">
				<tr>
					<td colspan="2"><p>削除したデータは戻すことはできません。<br />
							削除してよろしいですか？</p></td>
				</tr>
				<tr>
					<td>
					<form action="" method="post" enctype="multipart/form-data" name="form1" id="form1">
                    
							<input name="del" type="hidden" value="ok" />
							<? 
							if (!is_array($_POST[id])) {
								$array_id[] = $_POST[id];
								}else{
								$array_id = $_POST[id];
								}
								
								foreach ($array_id as $id) {
								?>
							<input name="id[]" type="hidden" value="" />
							<? }?>
							<input name="url" type="hidden" value="" />
								<input class="btn" type="submit" name="button" id="button" value="削除" />
				  </form></td>
					<td>
						<a class="cansel a:hover" href="">戻る</a></td>
				</tr>
			</table>

</body>
</html>