public function join_room($room_id)
{
global $db;
$sql = $db->prepare("INSERT INTO user_in_room(`user_id`, `room_id`) VALUES(?, ?)");
$success = $sql->execute(array($this->user_id, $room_id));
if ($success && $sql->rowCount()) {
$new_room = Room::get($room_id);
$this->rooms_list[] = $new_room;
return $new_room;
}
return false;
}
$cal = new Calendar();
$book = new Booking();
$room = new Room();
$smartyType = "www";
$month = $request->GetVar('month', 'post');
$year = $request->GetVar('year', 'post');
$view = $request->GetVar('view', 'post');
$step = $request->GetVar('step', 'post');
//print "view:". $view ." year: ".$year ."month: " .$month;
$smarty->assign('tpl_navstep', $step);
$smarty->assign('tpl_navmonth', $month);
$smarty->assign('tpl_navyear', $year);
$smarty->assign('tpl_view', $view);
$smarty->assign('tpl_years', $cal->getdates());
// get rooms
$rooms = $room->get();
/*$monthName = $cal -> returnMonthName($month);
$prevMonth = $cal -> previous_month($month, $year, false, false);
$displayyear = $year;
*/
if ($step !== '') {
if ($month == 12) {
$nextmonth = 1;
$tmpyear = $year + 1;
$displayyear = $year . '/' . $tmpyear;
} else {
$nextmonth = $month + 1;
}
$monthName = $monthName . '/' . $cal->returnMonthName($nextmonth);
$smarty->assign('tpl_step', 'false');
$smarty->assign('tpl_cal', $cal->GetHalfMonth($year, $month, 0));
*/
$smartyType = "www";
include_once "../includes/default.inc.php";
$auth->is_authenticated();
include_once 'roomclass.inc.php';
include_once 'roomcategoryclass.inc.php';
$room = new Room();
$roomcat = new RoomCategory();
$smarty->assign("tpl_title", "Zimmerverwaltung");
$smarty->assign('tpl_nav', 'settings');
$smarty->assign('tpl_subnav', 'syssettings');
$smarty->assign('tpl_subnav2', 'rooms');
if ($request->GetVar('frm_roomid', 'post') !== $request->undefined) {
if ($request->GetVar('frm_action', 'post') == 'edit') {
$smarty->assign('tpl_roomcat', $roomcat->Getall());
$smarty->assign('tpl_editid', $request->GetVar('frm_roomid', 'post'));
} else {
if ($request->GetVar('frm_action', 'post') == 'addnew') {
$smarty->assign('tpl_roomcat', $roomcat->Getall());
$smarty->assign('tpl_addnew', 'true');
} else {
if ($request->GetVar('frm_action', 'post') == 'del') {
$room->del($request->GetVar('frm_roomid', 'post'));
} else {
$check = $room->saveupdate();
}
}
}
}
$smarty->assign('tpl_room', $room->get());
$smarty->display('rooms.tpl');
/**
* Save room open status, public or private, and the password.
*/
function room_open_status_save()
{
$res = array();
if ($_POST['id'] && ($_POST['open'] == 'true' || $_POST['open'] == 'false') && isset($_POST['password'])) {
$db = sr_pdo();
if ($room = Room::get($db, $_POST['id'])) {
$room->is_open = $_POST['open'] == 'true' ? 1 : 0;
$room->password = $_POST['password'];
$room->save($db);
$res['result'] = 0;
} else {
$res['result'] = 2;
$res['msg'] = "Couldn't find the room";
}
} else {
$res['result'] = 1;
$res['msg'] = "Invalid request";
}
echo json_encode($res);
}
exit_with_status_code(400);
} else {
$room = Room::create($_REQUEST['name'], $_REQUEST['admin_id']);
if ($room) {
echo 'Room successfully created.';
exit_with_status_code(201);
} else {
echo 'Error creating room';
exit_with_status_code(400);
}
}
case 'PUT':
echo 'Operation not supported';
exit_with_status_code(405);
case 'GET':
$rooms = Room::get();
if ($rooms) {
foreach ($rooms as $room) {
echo $room->to_json();
}
exit_with_status_code(200);
} else {
echo 'Error getting rooms.';
exit_with_status_code(500);
}
case 'DELETE':
echo 'Cannot delete all rooms at once.';
default:
exit_with_status_code(405);
}
}
/**
* GET /rooms/{room_id}/files/{file_id}
* ファイル情報を取得.
*
* 引数0：room_id
* 引数1：file_id
* 引数2：create_download_url ダウンロードする為のURLを生成するか 30 秒間だけダウンロード可能なURLを生成します.
*/
public function fetchRoomFile()
{
$query_parameters = array('create_download_url' => isset($this->args[2]) ? $this->args[2] : null);
$query_parameters = self::filteringParameters($query_parameters);
$this->loadModel('Chatwork.Room');
$results = Room::get(array('room_id' => $this->args[0], 'action' => 'files', 'file_id' => $this->args[1], 'query_parameters' => $query_parameters));
$this->out(print_r($results, true));
}
