PHP Room::delete方法代码示例

function doDelete()
{
    @($id = $_POST['selector']);
    $key = count($id);
    //multi delete using checkbox as a selector
    for ($i = 0; $i < $key; $i++) {
        $room = new Room();
        $room->delete($id[$i]);
    }
    message("Room(s) already Deleted!", "info");
    redirect('index.php');
}

function room_action_room()
{
    global $_, $myUser;
    //Erreur dans les droits sinon!
    $myUser->loadRight();
    switch ($_['action']) {
        case 'room_add_room':
            $right_toverify = isset($_['id']) ? 'u' : 'c';
            if ($myUser->can('room', $right_toverify)) {
                $room = new Room();
                if ($right_toverify == "u") {
                    $room = $room->load(array("id" => $_['id']));
                }
                $room->setName($_['nameRoom']);
                $room->setDescription($_['descriptionRoom']);
                $room->save();
                header('location:setting.php?section=room');
            } else {
                header('location:setting.php?section=room&error=Vous n\'avez pas le droit de faire ça!');
            }
            break;
        case 'room_delete_room':
            if ($myUser->can('room', 'd')) {
                $roomManager = new Room();
                $roomManager->delete(array('id' => $_['id']));
                header('location:setting.php?section=room');
            } else {
                header('location:setting.php?section=room&error=Vous n\'avez pas le droit de faire ça!');
            }
            break;
    }
}

 public function update($group_id)
 {
     $this->load->library('form_validation');
     $this->form_validation->set_rules('room[name]', 'lang:admin_rooms_form_field_name', 'required');
     $this->form_validation->set_rules('room[time_begin]', 'lang:admin_rooms_form_field_time_begin', 'required|callback__is_time');
     $this->form_validation->set_rules('room[time_end]', 'lang:admin_rooms_form_field_time_end', 'required|callback__is_time|callback__is_later_time');
     $this->form_validation->set_rules('room[time_day]', 'lang:admin_rooms_form_field_time_day', 'required|callback__is_day');
     $this->form_validation->set_rules('room[capacity]', 'lang:admin_rooms_form_field_capacity', 'required|integer|greater_than[0]');
     $this->form_validation->set_rules('room_id', 'room_id', 'required');
     $this->form_validation->set_message('_is_time', $this->lang->line('admin_rooms_form_error_message_is_time'));
     $this->form_validation->set_message('_is_day', $this->lang->line('admin_rooms_form_error_message_is_day'));
     $this->form_validation->set_message('_is_later_time', $this->lang->line('admin_rooms_form_error_message_is_later_time'));
     if ($this->form_validation->run()) {
         $room_id = intval($this->input->post('room_id'));
         $room = new Room();
         $room->get_by_id($room_id);
         if ($room->exists()) {
             $room_data = $this->input->post('room');
             $room->from_array($room_data, array('name', 'time_day'));
             $room->time_begin = $this->time_to_int($room_data['time_begin']);
             $room->time_end = $this->time_to_int($room_data['time_end']);
             $room->capacity = intval($room_data['capacity']);
             $this->_transaction_isolation();
             $this->db->trans_begin();
             if (trim($room_data['teachers_plain']) != '') {
                 $room->teachers_plain = trim($room_data['teachers_plain']);
             } else {
                 $room->teachers_plain = NULL;
             }
             $current_teachers = $room->teacher->get();
             $room->delete($current_teachers->all);
             $teachers = new Teacher();
             if (is_array($room_data['teachers']) && count($room_data['teachers'])) {
                 foreach ($room_data['teachers'] as $teacher_id) {
                     $teachers->or_where('id', $teacher_id);
                 }
                 $teachers->get();
             }
             if ($room->save(array($teachers->all)) && $this->db->trans_status()) {
                 $this->db->trans_commit();
                 $this->messages->add_message('lang:admin_rooms_flash_message_save_successful', Messages::MESSAGE_TYPE_SUCCESS);
                 $this->_action_success();
                 $room->group->get();
                 $this->output->set_internal_value('course_id', $room->group->course_id);
             } else {
                 $this->db->trans_rollback();
                 $this->messages->add_message('lang:admin_rooms_flash_message_save_failed', Messages::MESSAGE_TYPE_ERROR);
             }
         } else {
             $this->messages->add_message('lang:admin_rooms_error_room_not_found', Messages::MESSAGE_TYPE_ERROR);
         }
         redirect(create_internal_url('admin_rooms/index/' . $group_id));
     } else {
         $this->edit($group_id);
     }
 }

<?php

require_once 'KodiCmd.class.php';
// Suppression de la table du plugin
$table = new KodiCmd();
//$table->drop();
$execQuery = $table->query('DROP TABLE yana_plugin_kodi');
$table_configuration = new configuration();
$table_configuration->getAll();
$table_configuration->remove('plugin_kodiCmd_api_url_kodi');
$table_configuration->remove('plugin_kodiCmd_api_timeout_kodi');
$table_configuration->remove('plugin_kodiCmd_api_recognition_status');
// suppression de la piece KODI
$table_room = new Room();
$table_room->delete(array('name' => 'KODI'));
// Recuperation de l'id et Suppression de la section
$table_section = new Section();
$id_section = $table_section->load(array("label" => "kodi"))->getId();
$table_section->delete(array('label' => 'kodi'));
// suppression des droits correspondant à la section
$table_right = new Right();
$table_right->delete(array('section' => $id_section));

 public static function Room($type, $data)
 {
     require_once 'room.class.php';
     $class = new Room();
     $status = false;
     $class->setData($data);
     switch ($type) {
         case 'add':
             $status = $class->add();
             break;
         case 'update':
             $status = $class->update();
             break;
         case 'delete':
             $status = $class->delete();
             break;
         case 'getsingle':
             $status = $class->getsingle();
             break;
         case 'getpage':
             $status = $class->getpage();
             break;
         case 'search':
             $status = $class->search();
             break;
         default:
             break;
     }
     if ($status) {
         wp_send_json_success($status);
     } else {
         wp_send_json_error($class->error);
     }
 }

                     } else {
                         echo 'Error updating room.';
                         exit_with_status_code(400);
                     }
                 }
             case 'GET':
                 $room = Room::get($room_id);
                 if ($room) {
                     echo $room->to_json();
                     exit_with_status_code(200);
                 } else {
                     echo 'Room not found.';
                     exit_with_status_code(404);
                 }
             case 'DELETE':
                 $result = Room::delete($room_id);
                 if ($result) {
                     echo 'Successfully deleted room';
                     exit_with_status_code(200);
                 } else {
                     echo 'The room you are attempting to delete doesn\'t exist';
                     exit_with_status_code(404);
                 }
             default:
                 exit_with_status_code(405);
         }
     }
 } else {
     switch ($verb) {
         case 'POST':
             if (!isset($_REQUEST['name']) || !isset($_REQUEST['admin_id'])) {

        $result = $obj_room->update($user);
        if ($result > 0) {
            Header("Location: " . $_SERVER['PHP_SELF'] . "?id=" . $id);
            exit;
        } else {
            setEventMessage('<div class="error">' . $obj_room->error . '</div>');
            $action = 'editroom';
        }
    } else {
        $action = 'editroom';
    }
} else {
    if ($action == 'confirm_deleteroom' && $confirm == 'yes' && $user->rights->place->write) {
        $ret = $obj_room->fetch($roomid);
        if ($ret) {
            $result = $obj_room->delete($user);
            if ($result > 0) {
                setEventMessage($langs->trans('RoomDeleted'));
                Header("Location: " . $_SERVER['PHP_SELF'] . "?id=" . $id);
                exit;
            } else {
                setEventMessage('<div class="error">' . $obj_room->error . '</div>');
                $action = '';
            }
        } else {
            setEventMessage('<div class="error">' . $obj_room->error . '</div>');
            $action = '';
        }
        header('Location: ' . $_SERVER["PHP_SELF"] . '?id=' . $object->id);
        exit;
    }