<?php
	require_once('check_login.php');

	$code_list = "";

	if(!empty($_POST["room_id"])){
		foreach($_POST["room_id"] as $key => $room_id){
			$typeid = "STORAGE";
			
			//update record
			$sql = "update room set code = ?, status = ?, master_room_id = ?, typeid = ?, lastupby = ?, lastupdate = ? where id = ?";
			$parameters = array($_POST["code"][$key], $_POST["room_status"][$key], $_POST["master_room_id"][$key], $typeid, $_SESSION['cmsloginid'], $nowdate, $room_id);
			bind_pdo($sql, $parameters);

            activity_log('room_modify.php', 'update query', $input = array('sql' => $sql, 'parameters' => $parameters), $data_before = array(), $data_after = array(), $step = 1);

			$code_list .= $_POST["code"][$key].", ";
		}

		$code_list = substr_replace($code_list ,"",-2);


		update_master_room_total_number();

		echo "<script>alert('倉庫單位: ".$code_list." 已更新。'); window.location.href='room_index.php?".htmlspecialchars_decode ($_POST["last_url_parameter"])."';</script>";
	}else{
		echo "<script>alert('請選擇要更新的倉庫單位。'); window.location.href='room_index.php?".htmlspecialchars_decode ($_POST["last_url_parameter"])."';</script>";
	}