webOffice_alt/ajax.php

<?php
// AJAX handling

// Includes
require('includes/config.inc.php');
require('includes/database.inc.php');
require('includes/functions.inc.php');
require('includes/document.inc.php');
require('includes/label.inc.php');
require('includes/mailbox.inc.php');
require('includes/mailboxfolder.inc.php');
require('includes/documenthandler.inc.php');

$db = new Database($CONFIG['dbHost'], $CONFIG['dbUser'], $CONFIG['dbPassword'], $CONFIG['dbDatabase']);

switch($_REQUEST['action']) {
    case 'updateMailaccounts':
        switch($_POST['name']) {
            case 'hostname':
                header("Status: 200 OK");
                $db->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;

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

        $editBox = array(
            "options"   => array(
                array(
                    "type"  => "select",
                    "name"  => "account",
                    "value" => Mailbox::getMailboxNameFromMailaccountId($_GET['mbId'])
                ),
                array(
                    "type"  => "text",
                    "name"  => "folder",
                    "value" => MailboxFolder::getMailboxFolderNameFromId($_GET['mfId'])
                )
            ),
            "title"     => "Mailkonto bearbeiten"
        );

        echo json_encode($editBox);

        break;
    case 'getMailAccountsByUid':
        header("Status: 200 OK");
        $mailboxes = Mailbox::getMailboxesByUserId($_REQUEST['uId']);
        $mbArray = array();
        foreach($mailboxes as $mailbox) {
            $mbArray[$mailbox->getId()] = $mailbox->getUsername();
        }
        echo json_encode($mbArray);
        break;
    case 'getNewDocumentBox':
        $boxHtml = 'Vorlage: ';
        $boxHtml .= getEditableLink('document-draft', 'select', 0, 'Click to change', 'Rechnung.odt');
        $boxHtml .= '<br>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 .= '<br>' . 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;
    case 'getMailboxStatus':
        $mailbox = Mailbox::getMailboxById($_REQUEST['mailboxId'], true);
        $mailboxStatus = array(
            "connected" => $mailbox->getConnected()
        );
        echo json_encode($mailboxStatus);
        break;
    default:
        header("Status: 400 No Action Defined");
        echo 'error';
        break;
}

//pa($_POST); // Debug

?>