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