]> git.mxchange.org Git - friendica-addons.git/blobdiff - dav/main.php
More refactoring, mainly of the addressbook/VCARD-part
[friendica-addons.git] / dav / main.php
index e893203493a7452e934e2751164f0813984626ee..c36d00840a5eac1cd1d8f03b336116a19ca227be 100644 (file)
@@ -30,15 +30,21 @@ function dav_include_files()
 
        require_once (__DIR__ . "/common/calendar.fnk.php");
        require_once (__DIR__ . "/common/calendar_rendering.fnk.php");
+
        require_once (__DIR__ . "/common/dav_caldav_backend_common.inc.php");
        require_once (__DIR__ . "/common/dav_caldav_backend_private.inc.php");
        require_once (__DIR__ . "/common/dav_caldav_backend_virtual.inc.php");
        require_once (__DIR__ . "/common/dav_caldav_root.inc.php");
        require_once (__DIR__ . "/common/dav_user_calendars.inc.php");
+       require_once (__DIR__ . "/common/dav_caldav_calendar_virtual.inc.php");
+       require_once (__DIR__ . "/common/dav_caldav_calendar_private.inc.php");
+
        require_once (__DIR__ . "/common/dav_carddav_root.inc.php");
-       require_once (__DIR__ . "/common/dav_carddav_backend_std.inc.php");
+       require_once (__DIR__ . "/common/dav_carddav_backend_common.inc.php");
+       require_once (__DIR__ . "/common/dav_carddav_backend_virtual.inc.php");
+       require_once (__DIR__ . "/common/dav_carddav_backend_private.inc.php");
        require_once (__DIR__ . "/common/dav_user_addressbooks.inc.php");
-       require_once (__DIR__ . "/common/dav_caldav_calendar_virtual.inc.php");
+
        require_once (__DIR__ . "/common/wdcal_configuration.php");
        require_once (__DIR__ . "/common/wdcal_backend.inc.php");
 
@@ -65,15 +71,19 @@ function dav_init(&$a)
         * ALTER TABLE `photo` ADD INDEX ( `contact-id` )
         */
 
+       ini_set("display_errors", 1);
+       error_reporting(E_ALL);
+
        dav_include_files();
 
-       if (true) {
+       if (false) {
                dbg(true);
                error_reporting(E_ALL);
                ini_set("display_errors", 1);
        }
 
        wdcal_create_std_calendars();
+       wdcal_create_std_addressbooks();
        wdcal_addRequiredHeaders();
 
        if ($a->argc >= 2 && $a->argv[1] == "wdcal") {
@@ -100,8 +110,10 @@ function dav_init(&$a)
 
 
        $server  = dav_create_server();
+
        $browser = new Sabre_DAV_Browser_Plugin();
        $server->addPlugin($browser);
+
        $server->exec();
 
        killme();
@@ -118,52 +130,55 @@ function dav_content()
        }
 
        $x = "";
-
-       if ($a->argv[1] == "settings") {
-               return wdcal_getSettingsPage($a);
-       } elseif ($a->argv[1] == "wdcal") {
-               if (isset($a->argv[2]) && strlen($a->argv[2]) > 0) {
-                       if ($a->argv[2] == "new") {
-                               $o = "";
-                               if (isset($_REQUEST["save"])) {
-                                       check_form_security_token_redirectOnErr($a->get_baseurl() . "/dav/wdcal/", "caledit");
-                                       $ret = wdcal_postEditPage("new", "", $a->user["uid"], $a->timezone, $a->get_baseurl() . "/dav/wdcal/");
-                                       if ($ret["ok"]) notice($ret["msg"]);
-                                       else info($ret["msg"]);
-                                       goaway($a->get_baseurl() . "/dav/wdcal/");
-                               }
-                               $o .= wdcal_getNewPage();
-                               return $o;
-                       } else {
-                               $calendar_id = IntVal($a->argv[2]);
-                               if (isset($a->argv[3]) && $a->argv[3] == "ics-export") {
-                                       wdcal_print_user_ics($calendar_id);
-                               } elseif (isset($a->argv[3]) && $a->argv[3] == "ics-import") {
-                                       return wdcal_import_user_ics($calendar_id);
-                               } elseif (isset($a->argv[3]) && $a->argv[3] > 0) {
-                                       if (isset($a->argv[4]) && $a->argv[4] == "edit") {
-                                               $o = "";
-                                               if (isset($_REQUEST["save"])) {
-                                                       check_form_security_token_redirectOnErr($a->get_baseurl() . "/dav/wdcal/", "caledit");
-                                                       $ret = wdcal_postEditPage($a->argv[3], $a->user["uid"], $a->timezone, $a->get_baseurl() . "/dav/wdcal/");
-                                                       if ($ret["ok"]) notice($ret["msg"]);
-                                                       else info($ret["msg"]);
-                                                       goaway($a->get_baseurl() . "/dav/wdcal/");
+       try {
+               if ($a->argv[1] == "settings") {
+                       return wdcal_getSettingsPage($a);
+               } elseif ($a->argv[1] == "wdcal") {
+                       if (isset($a->argv[2]) && strlen($a->argv[2]) > 0) {
+                               if ($a->argv[2] == "new") {
+                                       $o = "";
+                                       if (isset($_REQUEST["save"])) {
+                                               check_form_security_token_redirectOnErr($a->get_baseurl() . "/dav/wdcal/", "caledit");
+                                               $ret = wdcal_postEditPage("new", "", $a->user["uid"], $a->timezone, $a->get_baseurl() . "/dav/wdcal/");
+                                               if ($ret["ok"]) notice($ret["msg"]);
+                                               else info($ret["msg"]);
+                                               goaway($a->get_baseurl() . "/dav/wdcal/");
+                                       }
+                                       $o .= wdcal_getNewPage();
+                                       return $o;
+                               } else {
+                                       $calendar_id = IntVal($a->argv[2]);
+                                       if (isset($a->argv[3]) && $a->argv[3] == "ics-export") {
+                                               wdcal_print_user_ics($calendar_id);
+                                       } elseif (isset($a->argv[3]) && $a->argv[3] == "ics-import") {
+                                               return wdcal_import_user_ics($calendar_id);
+                                       } elseif (isset($a->argv[3]) && $a->argv[3] > 0) {
+                                               if (isset($a->argv[4]) && $a->argv[4] == "edit") {
+                                                       $o = "";
+                                                       if (isset($_REQUEST["save"])) {
+                                                               check_form_security_token_redirectOnErr($a->get_baseurl() . "/dav/wdcal/", "caledit");
+                                                               $ret = wdcal_postEditPage($a->argv[3], $a->user["uid"], $a->timezone, $a->get_baseurl() . "/dav/wdcal/");
+                                                               if ($ret["ok"]) notice($ret["msg"]);
+                                                               else info($ret["msg"]);
+                                                               goaway($a->get_baseurl() . "/dav/wdcal/");
+                                                       }
+                                                       $o .= wdcal_getEditPage($calendar_id, $a->argv[3]);
+                                                       return $o;
+                                               } else {
+                                                       return wdcal_getDetailPage($calendar_id, $a->argv[3]);
                                                }
-                                               $o .= wdcal_getEditPage($calendar_id, $a->argv[3]);
-                                               return $o;
                                        } else {
-                                               return wdcal_getDetailPage($calendar_id, $a->argv[3]);
+                                               // @TODO Edit Calendar
                                        }
-                               } else {
-                                       // @TODO Edit Calendar
                                }
+                       } else {
+                               $server = dav_create_server(true, true, false);
+                               $cals   = dav_get_current_user_calendars($server, DAV_ACL_READ);
+                               $x      = wdcal_printCalendar($cals, array(), $a->get_baseurl() . "/dav/wdcal/feed/", "week", 0, 200);
                        }
-               } else {
-                       $server = dav_create_server(true, true, false);
-                       $cals   = dav_get_current_user_calendars($server, DAV_ACL_READ);
-                       $x      = wdcal_printCalendar($cals, array(), $a->get_baseurl() . "/dav/wdcal/feed/", "week", 0, 200);
                }
+       } catch (DAVVersionMismatchException $e) {
+               $x = t("The current version of this plugin has not been set up correctly. Please contact the system administrator of your installation of friendica to fix this.");
        }
        return $x;
 }
@@ -208,7 +223,6 @@ function dav_profile_tabs_hook(&$a, &$b)
 }
 
 
-
 /**
  * @param App $a
  * @param object $b
@@ -220,9 +234,9 @@ function dav_cron(&$a, &$b)
        $r = q("SELECT * FROM %s%snotifications WHERE `notified` = 0 AND `alert_date` <= NOW()", CALDAV_SQL_DB, CALDAV_SQL_PREFIX);
        foreach ($r as $not) {
                q("UPDATE %s%snotifications SET `notified` = 1 WHERE `id` = %d", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, $not["id"]);
-               $event = q("SELECT * FROM %s%sjqcalendar WHERE `calendarobject_id` = %d", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, $not["calendarobject_id"]);
-               $calendar = q("SELECT * FROM %s%scalendars WHERE `id` = %d", CALDAV_SQL_DB,CALDAV_SQL_PREFIX, $not["calendar_id"]);
-               $users = array();
+               $event    = q("SELECT * FROM %s%sjqcalendar WHERE `calendarobject_id` = %d", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, $not["calendarobject_id"]);
+               $calendar = q("SELECT * FROM %s%scalendars WHERE `id` = %d", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, $not["calendar_id"]);
+               $users    = array();
                if (count($calendar) != 1 || count($event) == 0) continue;
                switch ($calendar[0]["namespace"]) {
                        case CALDAV_NAMESPACE_PRIVATE:
@@ -232,20 +246,21 @@ function dav_cron(&$a, &$b)
                                break;
                }
                switch ($not["action"]) {
-                       case "email": case "display": // @TODO implement "Display"
+                       case "email":
+                       case "display": // @TODO implement "Display"
                                foreach ($users as $user) {
-                                       $find = array( "%to%" , "%event%", "%url%");
-                                       $repl = array($user["username"], $event[0]["Summary"], $a->get_baseurl() . "/dav/wdcal/" . $calendar[0]["id"] . "/" . $not["calendarobject_id"] . "/");
+                                       $find      = array("%to%", "%event%", "%url%");
+                                       $repl      = array($user["username"], $event[0]["Summary"], $a->get_baseurl() . "/dav/wdcal/" . $calendar[0]["id"] . "/" . $not["calendarobject_id"] . "/");
                                        $text_text = str_replace($find, $repl, "Hi %to%!\n\nThe event \"%event%\" is about to begin:\n%url%");
                                        $text_html = str_replace($find, $repl, "Hi %to%!<br>\n<br>\nThe event \"%event%\" is about to begin:<br>\n<a href='" . "%url%" . "'>%url%</a>");
-                                       $params = array(
-                                               'fromName' => FRIENDICA_PLATFORM,
-                                               'fromEmail' => t('noreply') . '@' . $a->get_hostname(),
-                                               'replyTo' => t('noreply') . '@' . $a->get_hostname(),
-                                               'toEmail' => $user["email"],
-                                               'messageSubject' => t("Notification: " . $event[0]["Summary"]),
-                                               'htmlVersion' => $text_html,
-                                               'textVersion' => $text_text,
+                                       $params    = array(
+                                               'fromName'             => FRIENDICA_PLATFORM,
+                                               'fromEmail'            => t('noreply') . '@' . $a->get_hostname(),
+                                               'replyTo'              => t('noreply') . '@' . $a->get_hostname(),
+                                               'toEmail'              => $user["email"],
+                                               'messageSubject'       => t("Notification: " . $event[0]["Summary"]),
+                                               'htmlVersion'          => $text_html,
+                                               'textVersion'          => $text_text,
                                                'additionalMailHeader' => "",
                                        );
                                        require_once('include/enotify.php');
@@ -257,8 +272,6 @@ function dav_cron(&$a, &$b)
 }
 
 
-
-
 /**
  * @param App $a
  * @param null|object $o
@@ -277,7 +290,10 @@ function dav_plugin_admin_post(&$a = null, &$o = null)
        }
        if (isset($_REQUEST["upgrade"])) {
                $errs = dav_upgrade_tables();
-               if (count($errs) == 0) info(t('The database tables have been updated.') . EOL);
+               if (count($errs) == 0) {
+                       renderAllCalDavEntries();
+                       info(t('The database tables have been updated.') . EOL);
+               }
                else notice(t("An error occurred during the update.") . EOL);
        }
 }
@@ -303,18 +319,30 @@ function dav_plugin_admin(&$a, &$o)
                        $o .= t('Installed');
                        break;
                case 1:
-                       $o .= t('Upgrade needed') . "<br><br><input type='submit' name='upgrade' value='" . t('Upgrade') . "'>";
+                       $o .= "<strong>" . t('Upgrade needed') . "</strong><br>" . t("Please back up all calendar data (the tables beginning with dav_*) before proceeding. While all calendar events <i>should</i> be converted to the new database structure, it's always safe to have a backup. Below, you can have a look at the database-queries that will be made when pressing the 'update'-button.") . "<br><br><input type='submit' name='upgrade' value='" . t('Upgrade') . "'>";
                        break;
                case -1:
                        $o .= t('Not installed') . "<br><br><input type='submit' name='install' value='" . t('Install') . "'>";
                        break;
+               case -2:
+               default:
+                       $o .= t('Unknown') . "<br><br>" . t("Something really went wrong. I cannot recover from this state automatically, sorry. Please go to the database backend, back up the data, and delete all tables beginning with 'dav_' manually. Afterwards, this installation routine should be able to reinitialize the tables automatically.");
+                       break;
        }
        $o .= "<br><br>";
 
        $o .= "<h3>" . t("Troubleshooting") . "</h3>";
        $o .= "<h4>" . t("Manual creation of the database tables:") . "</h4>";
        $o .= "<a href='#' onClick='\$(\"#sqlstatements\").show(); return false;'>" . t("Show SQL-statements") . "</a><blockquote style='display: none;' id='sqlstatements'><pre>";
-       $tables = dav_get_create_statements();
-       foreach ($tables as $t) $o .= escape_tags($t . "\n\n");
+       switch ($dbstatus) {
+               case 1:
+                       $tables = dav_get_update_statements(1);
+                       foreach ($tables as $t) $o .= escape_tags($t . ";\n\n");
+                       break;
+               default:
+                       $tables = dav_get_create_statements();
+                       foreach ($tables as $t) $o .= escape_tags($t . ";\n\n");
+                       break;
+       }
        $o .= "</pre></blockquote>";
 }