mirror of
https://github.com/ellite/Wallos.git
synced 2026-07-31 10:16:03 -04:00
0fef9597ef
fix: don't use mbstring feat: sort graphs on the statistics page by usage feat: lifetime subscriptions feat: allow multiple filters on the settings page feat: filter by notification status fix: migrations using double quotes feat: rework icons fix: open 3 dot menu abone for the subscriptions at the bottom fix: ntfy notifications with strange chars
75 lines
2.5 KiB
PHP
75 lines
2.5 KiB
PHP
<?php
|
|
require_once '../../includes/connect_endpoint.php';
|
|
require_once '../../includes/validate_endpoint.php';
|
|
|
|
$postData = file_get_contents("php://input");
|
|
$data = json_decode($postData, true);
|
|
|
|
$currentDate = new DateTime();
|
|
$currentDateString = $currentDate->format('Y-m-d');
|
|
|
|
$cycles = array();
|
|
$query = "SELECT * FROM cycles";
|
|
$result = $db->query($query);
|
|
while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
|
|
$cycleId = $row['id'];
|
|
$cycles[$cycleId] = $row;
|
|
}
|
|
|
|
$subscriptionId = $data["id"];
|
|
$query = "SELECT * FROM subscriptions WHERE id = :id AND user_id = :user_id AND auto_renew = 0 AND cycle != 5";
|
|
$stmt = $db->prepare($query);
|
|
$stmt->bindValue(':id', $subscriptionId, SQLITE3_INTEGER);
|
|
$stmt->bindValue(':user_id', $userId, SQLITE3_INTEGER);
|
|
$result = $stmt->execute();
|
|
$subscriptionToRenew = $result->fetchArray(SQLITE3_ASSOC);
|
|
if ($subscriptionToRenew === false) {
|
|
die(json_encode([
|
|
"success" => false,
|
|
"message" => translate("error", $i18n)
|
|
]));
|
|
}
|
|
|
|
$nextPaymentDate = new DateTime($subscriptionToRenew['next_payment']);
|
|
$frequency = $subscriptionToRenew['frequency'];
|
|
$cycle = $cycles[$subscriptionToRenew['cycle']]['name'];
|
|
|
|
// Calculate the interval to add based on the cycle
|
|
$intervalSpec = "P";
|
|
if ($cycle == 'Daily') {
|
|
$intervalSpec .= "{$frequency}D";
|
|
} elseif ($cycle === 'Weekly') {
|
|
$intervalSpec .= "{$frequency}W";
|
|
} elseif ($cycle === 'Monthly') {
|
|
$intervalSpec .= "{$frequency}M";
|
|
} elseif ($cycle === 'Yearly') {
|
|
$intervalSpec .= "{$frequency}Y";
|
|
}
|
|
|
|
$interval = new DateInterval($intervalSpec);
|
|
|
|
// Add intervals until the next payment date is in the future and after current next payment date
|
|
while ($nextPaymentDate < $currentDate || $nextPaymentDate == new DateTime($subscriptionToRenew['next_payment'])) {
|
|
$nextPaymentDate->add($interval);
|
|
}
|
|
|
|
// Update the subscription's next_payment date
|
|
$updateQuery = "UPDATE subscriptions SET next_payment = :nextPaymentDate WHERE id = :subscriptionId";
|
|
$updateStmt = $db->prepare($updateQuery);
|
|
$updateStmt->bindValue(':nextPaymentDate', $nextPaymentDate->format('Y-m-d'));
|
|
$updateStmt->bindValue(':subscriptionId', $subscriptionId);
|
|
$updateStmt->execute();
|
|
|
|
if ($updateStmt->execute()) {
|
|
$response = [
|
|
"success" => true,
|
|
"message" => translate('success', $i18n),
|
|
"id" => $subscriptionId
|
|
];
|
|
echo json_encode($response);
|
|
} else {
|
|
die(json_encode([
|
|
"success" => false,
|
|
"message" => translate("error", $i18n)
|
|
]));
|
|
} |