protected function deleteUpload($uid)
{
$additionalQuerys = $this->deleteQuerysCreateAdditional($uid);
TableMng::getDb()->autocommit(false);
TableMng::queryMultiple("DELETE FROM SystemUsers WHERE ID = {$uid};\n\t\t\t{$additionalQuerys}\n\t\t\t");
TableMng::getDb()->autocommit(true);
}
/**
* Removes a Message from the Database by the ID given
*
* It also removes the links to this Message in the Tables
* MessageReceivers and MessageManagers.
*
* @param int $id the ID of the message to remove
*/
protected function messageDeleteFromDb($id)
{
try {
TableMng::getDb()->autocommit(false);
$query = sprintf('DELETE FROM MessageMessages WHERE `ID` = %s;
DELETE FROM MessageReceivers WHERE `messageId` = %s;
DELETE FROM MessageManagers WHERE `messageId` = %s;', $id, $id, $id);
TableMng::queryMultiple($query);
TableMng::getDb()->autocommit(true);
} catch (Exception $e) {
$this->_interface->dieError('Konnte die Nachricht nicht löschen!');
}
}
/**
* Changes a Group based on the given data
*/
protected function groupsChange()
{
$query = '';
$changeCounter = 0;
if (isset($_POST['data'])) {
foreach ($_POST['data'] as &$data) {
TableMng::sqlEscape($data);
}
$query = $this->groupsChangeQuery($_POST['data']);
} else {
die(json_encode(array('value' => 'error', 'message' => 'No data given!')));
}
try {
TableMng::getDb()->autocommit(false);
TableMng::queryMultiple($query);
TableMng::getDb()->autocommit(true);
} catch (Exception $e) {
die(json_encode(array('value' => 'error', 'message' => 'Konnte die Query nicht ausführen!')));
}
die(json_encode(array('value' => 'success', 'message' => 'Die Gruppen wurden erfolgreich geändert!')));
}
/**
* Deletes the Message with the Id $messageId
* Also deletes all entries in the tables MessageReceivers and
* MessageManagers that are linked to this Message
* @param id $messageId the message to delete
* @throws Exception if somethings gone wrong
*/
public static function deleteMessage($messageId)
{
$db = TableMng::getDb();
$db->autocommit(false);
$query = sprintf('DELETE FROM MessageMessages WHERE `ID` = %s;
DELETE FROM MessageReceivers WHERE `messageId` = %s;
DELETE FROM MessageManagers WHERE `messageId` = %s;', $messageId, $messageId, $messageId);
TableMng::queryMultiple($query);
$db->autocommit(true);
}
/**
* Pushes the given data to the Database
*
* @param Array $data An Array with the changed TimeModification-Strings
*/
protected function changeDataToDb($data)
{
try {
TableMng::queryMultiple("UPDATE SystemGlobalSettings\n\t\t\t\t\tSET value = '{$data['displayMealsStartdate']}'\n\t\t\t\t\tWHERE name = 'displayMealsStartdate';\n\t\t\t\tUPDATE SystemGlobalSettings\n\t\t\t\t\tSET value = '{$data['displayMealsEnddate']}'\n\t\t\t\t\tWHERE name = 'displayMealsEnddate';\n\t\t\t\tUPDATE SystemGlobalSettings\n\t\t\t\t\tSET value = '{$data['orderEnddate']}'\n\t\t\t\t\tWHERE name = 'orderEnddate';\n\t\t\t\tUPDATE SystemGlobalSettings\n\t\t\t\t\tSET value = '{$data['ordercancelEnddate']}'\n\t\t\t\t\tWHERE name = 'ordercancelEnddate';");
} catch (Exception $e) {
$this->_interface->dieError('Konnte die Daten nicht verändern!' . $e->getMessage());
}
}
/**
* Adds a new group to the DatabaseTable
*
* Requirement: the Parent has childs
*
* @param String $name The name of the new Group
* @param String $parentName The name of the parent-Group
* @todo if multiple parents with this name exist, problem!
*/
protected static function groupAddToNodeWithChildren($name, $parentName)
{
TableMng::getDb()->autocommit(false);
TableMng::queryMultiple("SELECT @myRight := rgt FROM SystemGroups\n\t\t\tWHERE name = '{$parentName}';\n\t\t\tUPDATE SystemGroups SET rgt = rgt + 2 WHERE rgt >= @myRight;\n\t\t\tUPDATE SystemGroups SET lft = lft + 2 WHERE lft >= @myRight;\n\t\t\tINSERT INTO SystemGroups(name, lft, rgt) VALUES('{$name}',\n\t\t\t\t\t\t\t@myRight, @myRight + 1);\n\t\t\t");
TableMng::getDb()->autocommit(true);
}
