105 lines
3.0 KiB
PHP
105 lines
3.0 KiB
PHP
<?php
|
|
|
|
class CalendarEvent
|
|
{
|
|
private $db;
|
|
|
|
public function __construct()
|
|
{
|
|
$this->db = Database::getInstance()->getConnection();
|
|
$this->initTable();
|
|
}
|
|
|
|
private function initTable()
|
|
{
|
|
$sql = "CREATE TABLE IF NOT EXISTS calendar_events (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
user_id INTEGER NOT NULL,
|
|
title TEXT NOT NULL,
|
|
content TEXT,
|
|
event_date DATE NOT NULL,
|
|
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
|
|
FOREIGN KEY (user_id) REFERENCES users(id)
|
|
)";
|
|
|
|
try {
|
|
$this->db->exec($sql);
|
|
} catch (PDOException $e) {
|
|
// Tabela już istnieje
|
|
}
|
|
}
|
|
|
|
public function getByMonth($userId, $month)
|
|
{
|
|
$stmt = $this->db->prepare("
|
|
SELECT * FROM calendar_events
|
|
WHERE user_id = ? AND strftime('%Y-%m', event_date) = ?
|
|
ORDER BY event_date ASC, id ASC
|
|
");
|
|
$stmt->execute([$userId, $month]);
|
|
return $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getByDate($userId, $date)
|
|
{
|
|
$stmt = $this->db->prepare("
|
|
SELECT * FROM calendar_events
|
|
WHERE user_id = ? AND event_date = ?
|
|
ORDER BY id ASC
|
|
");
|
|
$stmt->execute([$userId, $date]);
|
|
return $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function getById($id, $userId)
|
|
{
|
|
$stmt = $this->db->prepare("
|
|
SELECT * FROM calendar_events
|
|
WHERE id = ? AND user_id = ?
|
|
");
|
|
$stmt->execute([$id, $userId]);
|
|
return $stmt->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
public function create($userId, $title, $content, $eventDate)
|
|
{
|
|
$stmt = $this->db->prepare("
|
|
INSERT INTO calendar_events (user_id, title, content, event_date)
|
|
VALUES (?, ?, ?, ?)
|
|
");
|
|
return $stmt->execute([$userId, $title, $content, $eventDate]);
|
|
}
|
|
|
|
public function update($id, $userId, $title, $content, $eventDate)
|
|
{
|
|
$stmt = $this->db->prepare("
|
|
UPDATE calendar_events
|
|
SET title = ?, content = ?, event_date = ?, updated_at = CURRENT_TIMESTAMP
|
|
WHERE id = ? AND user_id = ?
|
|
");
|
|
return $stmt->execute([$title, $content, $eventDate, $id, $userId]);
|
|
}
|
|
|
|
public function delete($id, $userId)
|
|
{
|
|
$stmt = $this->db->prepare("
|
|
DELETE FROM calendar_events
|
|
WHERE id = ? AND user_id = ?
|
|
");
|
|
return $stmt->execute([$id, $userId]);
|
|
}
|
|
|
|
public function countByDateRange($userId, $startDate, $endDate)
|
|
{
|
|
$stmt = $this->db->prepare("
|
|
SELECT COUNT(*) AS count
|
|
FROM calendar_events
|
|
WHERE user_id = ? AND event_date BETWEEN ? AND ?
|
|
");
|
|
$stmt->execute([$userId, $startDate, $endDate]);
|
|
$result = $stmt->fetch(PDO::FETCH_ASSOC);
|
|
return (int)$result['count'];
|
|
}
|
|
}
|