updateQuery("UPDATE `mailboxes` SET `server`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";");
break;
case 'port':
header("Status: 200 OK");
$db->updateQuery("UPDATE `mailboxes` SET `port`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";");
break;
case 'protocol':
header("Status: 200 OK");
$db->updateQuery("UPDATE `mailboxes` SET `protocol`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";");
break;
case 'use-ssl':
header("Status: 200 OK");
$db->updateQuery("UPDATE `mailboxes` SET `use_ssl`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";");
break;
case 'no-valid-cert':
header("Status: 200 OK");
$db->updateQuery("UPDATE `mailboxes` SET `valid_ssl`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";");
break;
case 'username':
header("Status: 200 OK");
$db->updateQuery("UPDATE `mailboxes` SET `username`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";");
break;
case 'password':
header("Status: 200 OK");
$db->updateQuery("UPDATE `mailboxes` SET `password`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";");
break;
default:
header("Status: 400 Wrong Field");
echo 'error';
break;
}
//$db->updateQuery("UPDATE `mailboxes` SET x=y WHERE id=;")
break;
case 'updateMailfolder':
switch($_POST['name']) {
case 'mailaccount':
header("Status: 200 OK");
$db->updateQuery("UPDATE `mailbox-folders` SET `mailbox_id`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";");
break;
case 'mailfolder':
header("Status: 200 OK");
$db->updateQuery("UPDATE `mailbox-folders` SET `folder_name`='" . $_POST['value'] . "' WHERE id=" . $_POST['pk'] . ";");
break;
default:
header("Status: 400 Wrong Field");
echo 'error';
break;
}
break;
case 'addDefaultMailaccount':
header("Status: 200 OK");
$db->insertQuery("INSERT INTO `mailboxes` (`user_id`) VALUES (" . $_POST['user-id'] . ");");
break;
case 'addDefaultMailfolder':
header("Status: 200 OK");
$db->insertQuery("INSERT INTO `mailbox-folders` (`label_id`) VALUES (" . $_POST['label-id'] . ");");
break;
case 'removeMailaccount':
header("Status: 200 OK");
$db->removeQuery("DELETE FROM `mailboxes` WHERE `id` = " . $_POST['id'] . ";");
break;
case 'removeMailboxFolder':
header("Status: 200 OK");
$db->removeQuery("DELETE FROM `mailbox-folders` WHERE `id` = " . $_POST['id'] . ";");
break;
case 'manageMailboxFolder':
header("Status: 200 OK");
/*$boxHtml = 'Account: ';
$boxHtml .= getEditableLink('mailaccount', 'select', $_GET['mfId'], 'Click to change', getMailboxNameFromMailaccountId($_GET['mbId']));
$boxHtml .= '
Folder: ';
$boxHtml .= getEditableLink('mailfolder', 'text', $_GET['mfId'], 'Click to change', getMailboxFolderNameFromId($_GET['mfId'])); // TODO: make this select-box
echo $boxHtml;*/
$editBox = array(
"options" => array(
array(
"type" => "select",
"name" => "account"
),
array(
"type" => "text",
"name" => "Folder"
)
),
"title" => "Mailkonto bearbeiten"
);
echo json_encode($editBox);
break;
case 'getMailAccountsByUid':
header("Status: 200 OK");
$mailboxes = getMailboxesByUserId($_REQUEST['uId'], false);
$mbArray = array();
foreach($mailboxes as $mailbox) {
$mbArray[$mailbox->getId()] = $mailbox->getUsername();
}
$jsonOut = json_encode($mbArray);
echo $jsonOut;
break;
case 'getNewDocumentBox':
$boxHtml = 'Vorlage: ';
$boxHtml .= getEditableLink('document-draft', 'select', 0, 'Click to change', 'Rechnung.odt');
$boxHtml .= '
Dateiname: ';
$boxHtml .= getEditableLink('document-filename', 'text', 0, 'Click to change', 'Neue-Rechnung-09.04.2015.odt');
$documentHandler = new DocumentHandler('NeueRechnung.docx', 'Rechnung.docx');
$valueKeys = $documentHandler->getVariables();
foreach($valueKeys as $key=>$value) {
$boxHtml .= '
' . getEditableLink('template-value-' . $key, 'text', 0, 'Click to change', $value) . $value;
}
$documentHandler->setVal('ADRESSE', 'Moritz Schmidt' . PHP_EOL . 'Fr.-Weinbrenner-Str. 13' . PHP_EOL . '69126 Heidelberg');
$documentHandler->setVal('RECHNUNGSNUMMER', '2015.1');
$documentHandler->setVal('BESCHREIBUNG', 'eine kleine rechnung lol');
$documentHandler->setVal('RECHNUNGTABELLE', 'tabelle idk ollo todo implement!');
$documentHandler->setVal('GESAMTBETRAG', '7€');
$documentHandler->setVal('JAHR', '2015');
//$documentHandler->saveFile();
echo $boxHtml;
break;
default:
header("Status: 400 No Action Defined");
echo 'error';
break;
}
//pa($_POST); // Debug
?>