/** * @param App $a * @return string */ function wdcal_getSettingsPage(&$a) { if (!local_user()) { notice(t('Permission denied.') . EOL); return ''; } if (isset($_REQUEST["save"])) { check_form_security_token_redirectOnErr('/dav/settings/', 'calprop'); set_pconfig($a->user["uid"], "dav", "dateformat", $_REQUEST["wdcal_date_format"]); info(t('The new values have been saved.')); } if (isset($_REQUEST["save_cals"])) { check_form_security_token_redirectOnErr('/dav/settings/', 'calprop'); $r = q("SELECT * FROM %s%scalendars WHERE `namespace` = " . CALDAV_NAMESPACE_PRIVATE . " AND `namespace_id` = %d", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, IntVal($a->user["uid"])); foreach ($r as $cal) { $backend = wdcal_calendar_factory($cal["namespace"], $cal["namespace_id"], $cal["uri"], $cal); $change_sql = ""; $col = substr($_REQUEST["color"][$cal["id"]], 1); if (strtolower($col) != strtolower($cal["calendarcolor"])) { $change_sql .= ", `calendarcolor` = '" . dbesc($col) . "'"; } if (!is_subclass_of($backend, "Sabre_CalDAV_Backend_Virtual")) { if ($_REQUEST["uri"][$cal["id"]] != $cal["uri"]) { $change_sql .= ", `uri` = '" . dbesc($_REQUEST["uri"][$cal["id"]]) . "'"; } if ($_REQUEST["name"][$cal["id"]] != $cal["displayname"]) { $change_sql .= ", `displayname` = '" . dbesc($_REQUEST["name"][$cal["id"]]) . "'"; } } if ($change_sql != "") { q("UPDATE %s%scalendars SET `ctag` = `ctag` + 1 {$change_sql} WHERE `id` = %d AND `namespace_id` = %d AND `namespace_id` = %d", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, $cal["id"], CALDAV_NAMESPACE_PRIVATE, IntVal($a->user["uid"])); info(t('The calendar has been updated.')); } } if (isset($_REQUEST["uri"]["new"]) && $_REQUEST["uri"]["new"] != "" && $_REQUEST["name"]["new"] && $_REQUEST["name"]["new"] != "") { $order = q("SELECT MAX(`calendarorder`) ord FROM %s%scalendars WHERE `namespace_id` = %d AND `namespace_id` = %d", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, CALDAV_NAMESPACE_PRIVATE, IntVal($a->user["uid"])); $neworder = $order[0]["ord"] + 1; q("INSERT INTO %s%scalendars (`namespace`, `namespace_id`, `calendarorder`, `calendarcolor`, `displayname`, `timezone`, `uri`, `has_vevent`, `ctag`)\n\t\t\t\tVALUES (%d, %d, %d, '%s', '%s', '%s', '%s', 1, 1)", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, CALDAV_NAMESPACE_PRIVATE, IntVal($a->user["uid"]), $neworder, dbesc(strtolower(substr($_REQUEST["color"]["new"], 1))), dbesc($_REQUEST["name"]["new"]), dbesc($a->timezone), dbesc($_REQUEST["uri"]["new"])); info(t('The new calendar has been created.')); } } if (isset($_REQUEST["remove_cal"])) { check_form_security_token_redirectOnErr('/dav/settings/', 'del_cal', 't'); $c = q("SELECT * FROM %s%scalendars WHERE `id` = %d AND `namespace_id` = %d AND `namespace_id` = %d", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, IntVal($_REQUEST["remove_cal"]), CALDAV_NAMESPACE_PRIVATE, IntVal($a->user["uid"])); if (count($c) != 1) { killme(); } $calobjs = q("SELECT `id` FROM %s%scalendarobjects WHERE `calendar_id` = %d", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, IntVal($_REQUEST["remove_cal"])); $newcal = q("SELECT * FROM %s%scalendars WHERE `id` != %d AND `namespace_id` = %d AND `namespace_id` = %d ORDER BY `calendarcolor` LIMIT 0,1", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, IntVal($_REQUEST["remove_cal"]), CALDAV_NAMESPACE_PRIVATE, IntVal($a->user["uid"])); if (count($newcal) != 1) { killme(); } q("UPDATE %s%scalendarobjects SET `calendar_id` = %d WHERE `calendar_id` = %d", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, IntVal($newcal[0]["id"]), IntVal($c[0]["id"])); foreach ($calobjs as $calobj) { renderCalDavEntry_calobj_id($calobj["id"]); } q("DELETE FROM %s%scalendars WHERE `id` = %s", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, IntVal($_REQUEST["remove_cal"])); q("UPDATE %s%scalendars SET `ctag` = `ctag` + 1 WHERE `id` = " . CALDAV_SQL_DB, CALDAV_SQL_PREFIX, $newcal[0]["id"]); info(t('The calendar has been deleted.')); } $o = ""; $o .= "<a href='" . $a->get_baseurl() . "/dav/wdcal/'>" . t("Go back to the calendar") . "</a><br><br>"; $o .= '<h3>' . t('Calendar Settings') . '</h3>'; $current_format = wdcal_local::getInstanceByUser($a->user["uid"]); $o .= '<form method="POST" action="' . $a->get_baseurl() . '/dav/settings/">'; $o .= "<input type='hidden' name='form_security_token' value='" . get_form_security_token('calprop') . "'>\n"; $o .= '<label for="wdcal_date_format">' . t('Date format') . ':</label><select name="wdcal_date_format" id="wdcal_date_format" size="1">'; $classes = wdcal_local::getInstanceClasses(); foreach ($classes as $c) { $o .= '<option value="' . $c::getID() . '" '; if ($c::getID() == $current_format::getID()) { $o .= 'selected'; } $o .= '>' . escape_tags($c::getName()) . '</option>'; } $o .= '</select><br>'; $o .= '<label for="wdcal_time_zone">' . t('Time zone') . ':</label><input id="wdcal_time_zone" value="' . $a->timezone . '" disabled><br>'; $o .= '<input type="submit" name="save" value="' . t('Save') . '">'; $o .= '</form>'; $o .= '<br><br><h3>' . t('Calendars') . '</h3>'; $o .= '<form method="POST" action="' . $a->get_baseurl() . '/dav/settings/">'; $o .= "<input type='hidden' name='form_security_token' value='" . get_form_security_token('calprop') . "'>\n"; $o .= "<table><tr><th>Type</th><th>Color</th><th>Name</th><th>URI (for CalDAV)</th><th>ICS</th></tr>"; $r = q("SELECT * FROM %s%scalendars WHERE `namespace` = " . CALDAV_NAMESPACE_PRIVATE . " AND `namespace_id` = %d", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, IntVal($a->user["uid"])); $private_max = 0; $num_non_virtual = 0; foreach ($r as $x) { $backend = wdcal_calendar_factory($x["namespace"], $x["namespace_id"], $x["uri"], $x); if (!is_subclass_of($backend, "Sabre_CalDAV_Backend_Virtual")) { $num_non_virtual++; } } foreach ($r as $x) { $p = explode("private-", $x["uri"]); if (count($p) == 2 && $p[1] > $private_max) { $private_max = $p[1]; } $backend = wdcal_calendar_factory($x["namespace"], $x["namespace_id"], $x["uri"], $x); $disabled = is_subclass_of($backend, "Sabre_CalDAV_Backend_Virtual") ? "disabled" : ""; $o .= "<tr>"; $o .= "<td style='padding: 2px;'>" . escape_tags($backend->getBackendTypeName()) . "</td>"; $o .= "<td style='padding: 2px; text-align: center;'><input style='margin-left: 10px; width: 70px;' class='cal_color' name='color[" . $x["id"] . "]' id='cal_color_" . $x["id"] . "' value='#" . (strlen($x["calendarcolor"]) != 6 ? "5858ff" : escape_tags($x["calendarcolor"])) . "'></td>"; $o .= "<td style='padding: 2px;'><input style='margin-left: 10px;' name='name[" . $x["id"] . "]' value='" . escape_tags($x["displayname"]) . "' {$disabled}></td>"; $o .= "<td style='padding: 2px;'><input style='margin-left: 10px; width: 150px;' name='uri[" . $x["id"] . "]' value='" . escape_tags($x["uri"]) . "' {$disabled}></td>"; $o .= "<td style='padding: 2px;'><a href='" . $a->get_baseurl() . "/dav/wdcal/" . $x["id"] . "/ics-export/'>Export</a>"; if (!is_subclass_of($backend, "Sabre_CalDAV_Backend_Virtual") && $num_non_virtual > 1) { $o .= " / <a href='" . $a->get_baseurl() . "/dav/wdcal/" . $x["id"] . "/ics-import/'>Import</a>"; } $o .= "</td>"; $o .= "<td style='padding: 2px; padding-left: 50px;'>"; if (!is_subclass_of($backend, "Sabre_CalDAV_Backend_Virtual") && $num_non_virtual > 1) { $o .= "<a href='" . $a->get_baseurl() . "/dav/settings/?remove_cal=" . $x["id"] . "&t=" . get_form_security_token("del_cal") . "' class='delete_cal'>Delete</a>"; } $o .= "</td>\n"; $o .= "</tr>\n"; } $private_max++; $o .= "<tr class='cal_add_row' style='display: none;'>"; $o .= "<td style='padding: 2px;'>" . escape_tags(Sabre_CalDAV_Backend_Private::getBackendTypeName()) . "</td>"; $o .= "<td style='padding: 2px; text-align: center;'><input style='margin-left: 10px; width: 70px;' class='cal_color' name='color[new]' id='cal_color_new' value='#5858ff'></td>"; $o .= "<td style='padding: 2px;'><input style='margin-left: 10px;' name='name[new]' value='Another calendar'></td>"; $o .= "<td style='padding: 2px;'><input style='margin-left: 10px; width: 150px;' name='uri[new]' value='private-{$private_max}'></td>"; $o .= "<td></td><td></td>"; $o .= "</tr>\n"; $o .= "</table>"; $o .= "<div style='text-align: center;'>[<a href='#' class='calendar_add_caller'>" . t("Create a new calendar") . "</a>]</div>"; $o .= '<input type="submit" name="save_cals" value="' . t('Save') . '">'; $o .= '</form>'; $baseurl = $a->get_baseurl(); $o .= "<script>\$(function() {\n\t\twdcal_edit_calendars_start('" . $current_format->dateformat_datepicker_js() . "', '{$baseurl}/dav/');\n\t});</script>"; $o .= "<br><h3>" . t("Limitations") . "</h3>"; $o .= "- The native friendica events are embedded as read-only, half-transparent in the calendar.<br>"; $o .= "<br><h3>" . t("Warning") . "</h3>"; $o .= "This plugin still is in a very early stage of development. Expect major bugs!<br>"; $o .= "<br><h3>" . t("Synchronization (iPhone, Thunderbird Lightning, Android, ...)") . "</h3>"; $o .= 'This plugin enables synchronization of your dates and contacts with CalDAV- and CardDAV-enabled programs or devices.<br> As an example, the instructions how to set up two-way synchronization with an iPhone/iPodTouch are provided below.<br> Unfortunately, Android does not have native support for CalDAV or CardDAV, so an app has to be installed.<br> On desktops, the Lightning-extension to Mozilla Thunderbird should be able to use this plugin as a backend.<br><br>'; $o .= '<h4>' . t('Synchronizing this calendar with the iPhone') . '</h4>'; $o .= "<ul>\n\t<li>Go to the settings</li>\n\t<li>Mail, contacts, settings</li>\n\t<li>Add a new account</li>\n\t<li>Other...</li>\n\t<li>Calendar -> CalDAV-Account</li>\n\t<li><b>Server:</b> " . $a->get_baseurl() . "/dav/ / <b>Username/Password:</b> <em>the same as your friendica-login</em></li>\n\t</ul>"; $o .= '<h4>' . t('Synchronizing your Friendica-Contacts with the iPhone') . '</h4>'; $o .= "<ul>\n\t<li>Go to the settings</li>\n\t<li>Mail, contacts, settings</li>\n\t<li>Add a new account</li>\n\t<li>Other...</li>\n\t<li>Contacts -> CardDAV-Account</li>\n\t<li><b>Server:</b> " . $a->get_baseurl() . "/dav/ / <b>Username/Password:</b> <em>the same as your friendica-login</em></li>\n\t</ul>"; return $o; }
/** * Deletes an existing calendar object. * * @param string $calendarId * @param string $objectUri * @throws Sabre_DAV_Exception_NotFound * @return void */ function deleteCalendarObject($calendarId, $objectUri) { $r = q("SELECT `id` FROM %s%scalendarobjects WHERE `calendar_id` = %d AND `uri` = '%s'", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, IntVal($calendarId), dbesc($objectUri)); if (count($r) == 0) { throw new Sabre_DAV_Exception_NotFound(); } q("DELETE FROM %s%scalendarobjects WHERE `calendar_id` = %d AND `uri` = '%s'", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, IntVal($calendarId), dbesc($objectUri)); $this->increaseCalendarCtag($calendarId); renderCalDavEntry_calobj_id($r[0]["id"]); }