Skip to content

Wallos: Open-source, self-hostable personal subscription tracker. Visualize your recurring expenses, manage your budget, and save money.

3.8 KB
Raw Blame
<?php
require_once '../../includes/connect_endpoint.php';
require_once '../../includes/validate_endpoint.php';
require_once '../../includes/getdbkeys.php';
require_once '../../includes/subscription_payers.php';
require_once '../../includes/subscription_categories.php';
require_once '../../includes/ical_helper.php';

$postData = file_get_contents("php://input");
$data = json_decode($postData, true);

$id = $data['id'];

$stmt = $db->prepare('SELECT * FROM subscriptions WHERE id = :id AND user_id = :userId');
$stmt->bindParam(':id', $id, SQLITE3_INTEGER);
$stmt->bindParam(':userId', $_SESSION['userId'], SQLITE3_INTEGER);
$result = $stmt->execute();

if ($result === false) {
    die(json_encode([
        'success' => false,
        'message' => "Subscription not found"
    ]));
}

$subscription = $result->fetchArray(SQLITE3_ASSOC); // Fetch the subscription details as an associative array

if ($subscription) {
    $subscription['payer_user'] = payerNamesLabel(getPayersBySubscription($db, [$subscription])[$subscription['id']] ?? [], array_map(fn($m) => $m['name'] ?? '', $members));
    $subscription['category'] = payerNamesLabel(getCategoriesBySubscription($db, [$subscription])[$subscription['id']] ?? [], array_map(fn($c) => $c['name'] ?? '', $categories));
    $subscription['payment_method'] = $payment_methods[$subscription['payment_method_id']]['name'];
    $subscription['currency'] = $currencies[$subscription['currency_id']]['symbol'];
    $subscription['trigger'] = $subscription['notify_days_before'] ? $subscription['notify_days_before'] : 1;
    $subscription['price'] = number_format($subscription['price'], 2);

    // Create ICS from subscription information
    $uid = 'wallos-subscription-' . $subscription['id'] . '@wallos';
    $summary = icalEscape(html_entity_decode($subscription['name'], ENT_QUOTES, 'UTF-8'));
    $notes = icalEscape($subscription['notes']);
    $category = icalEscape($subscription['category']);
    $paymentMethod = icalEscape($subscription['payment_method']);
    $payer = icalEscape($subscription['payer_user']);
    $description = "Price: {$subscription['currency']}{$subscription['price']}\\nCategory: {$category}\\nPayment Method: {$paymentMethod}\\nPayer: {$payer}\\n\\nNotes: {$notes}";

    $dtstamp = gmdate('Ymd\THis\Z');
    $dtstart = (new DateTime($subscription['next_payment']))->format('Ymd');
    $dtend = (new DateTime($subscription['next_payment']))->format('Ymd');
    $location = icalEscape(isset($subscription['url']) ? $subscription['url'] : '');
    $alarm_trigger = '-P' . $subscription['trigger'] . 'D';

    // Notes can now be multi-paragraph Markdown, so these lines (especially
    // DESCRIPTION) can genuinely exceed the RFC 5545 75-octet limit.
    $summaryLine = icalFold('SUMMARY:' . $summary);
    $descriptionLine = icalFold('DESCRIPTION:' . $description);
    $locationLine = icalFold('LOCATION:' . $location);

    $icsContent = <<<ICS
        BEGIN:VCALENDAR
        VERSION:2.0
        PRODID:-//Your Organization//Your Application//EN
        CALSCALE:GREGORIAN
        METHOD:PUBLISH
        BEGIN:VEVENT
        UID:$uid
        DTSTAMP:$dtstamp
        $summaryLine
        $descriptionLine
        DTSTART;VALUE=DATE:$dtstart
        DTEND;VALUE=DATE:$dtend
        $locationLine
        STATUS:CONFIRMED
        TRANSP:OPAQUE
        BEGIN:VALARM
        ACTION:DISPLAY
        DESCRIPTION:Reminder
        TRIGGER:$alarm_trigger
        END:VALARM
        END:VEVENT
        END:VCALENDAR
        ICS;

    echo json_encode([
        'success' => true,
        'ics' => $icsContent,
        'name' => $subscription['name']
    ]);
} else {
    echo json_encode([
        'success' => false,
        'message' => "Subscription not found"
    ]);
}