} else { if ($_SESSION['resources_data']["requests_working_pos"] == sizeof($_SESSION['resources_data']["requests_working_on"])-1) { $auto_dec = TRUE; } else { $auto_inc = TRUE; } } } } if (Request::submitted('do_delete_requests') && get_config('RESOURCES_ALLOW_DELETE_REQUESTS') && getGlobalPerms($GLOBALS['user']->id) == 'admin'){ $requests_marked_to_kill = Request::quotedArray('requests_marked_to_kill'); if (is_array($requests_marked_to_kill)){ foreach($requests_marked_to_kill as $rid){ $req_obj = new RoomRequest($rid); $count += ($req_obj->delete() != 0); unset($_SESSION['resources_data']["requests_open"][$rid]); foreach($_SESSION['resources_data']['requests_working_on'] as $number => $rwo){ if ($rwo['request_id'] == $rid){ unset($_SESSION['resources_data']['requests_working_on'][$number]); break; } } } $_SESSION['resources_data']['requests_working_pos'] = 0; $_SESSION['resources_data']['requests_working_on'] = array_values($_SESSION['resources_data']['requests_working_on']); $msg->addMsg(45, array($count)); } } if (Request::submitted('suppose_decline_request')) {
function killDateAssign($termin_id) { if (!$termin_id) { return; } $query = "SELECT assign_id FROM resources_assign LEFT JOIN resources_objects USING (resource_id) LEFT JOIN resources_categories USING (category_id) WHERE assign_user_id = ? AND resources_categories.is_room = 1"; $statement = DBManager::get()->prepare($query); $statement->execute(array($termin_id)); while ($assign_id = $statement->fetchColumn()) { AssignObject::Factory($assign_id)->delete(); } $query = "SELECT request_id FROM resources_requests WHERE termin_id = ?"; $statement = DBManager::get()->prepare($query); $statement->execute(array($termin_id)); while ($request_id = $statement->fetchColumn()) { $killRequest = new RoomRequest ($request_id); $killRequest->delete(); } }
function deleteRequests() { $column = $this->object_type == 'sem' ? 'seminar_id' : 'termin_id'; $query = "SELECT request_id FROM resources_requests WHERE :column = :value"; $statement = DBManager::get()->prepare($query); $statement->bindValue(':column', $column, StudipPDO::PARAM_COLUMN); $statement->bindValue(':value', $this->range_id); $statement->execute(); while ($request_id = $statement->fetchColumn()) { $killRequest = new RoomRequest($request_id); $killRequest->delete(); } }
static function deleteSingleDate($id, $ex_termin) { if (Config::get()->RESOURCES_ENABLE) { // delete resource assignment, if any $killAssign = AssignObject::Factory(self::getAssignID($id)); $killAssign->delete(); if ($request_id = self::getRequestID($id)) { $rr = new RoomRequest($request_id); $rr->delete(); } } // Prepare query that deletes all entries for a given termin id // from a given table $query = "DELETE FROM :table WHERE termin_id = :termin_id"; $statement = DBManager::get()->prepare($query); $statement->bindValue(':termin_id', $id); // Execute statement for the termin itself (ex_termin if neccessary) $statement->bindValue(':table', $ex_termin ? 'ex_termine' : 'termine', StudipPDO::PARAM_COLUMN); $statement->execute(); // Execute statement for themen_termine $statement->bindValue(':table', 'themen_termine', StudipPDO::PARAM_COLUMN); $statement->execute(); // Execute statement for termin_related_persons $query = "DELETE FROM termin_related_persons WHERE range_id = :termin_id"; $statement = DBManager::get()->prepare($query); $statement->bindValue(':termin_id', $id); $statement->execute(); return true; }