PHP Room::get方法代码示例

 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));
 }