15 Commits

8 changed files with 599 additions and 1056 deletions

View File

@@ -35,7 +35,7 @@ COMMENT ON TABLE municipalities IS 'Configuration Per Municipality (Tenant) usin
-- --------------------------------------------------------------------- -- ---------------------------------------------------------------------
-- Block 3: Table "contributions" -- Block 3: Table "contributions"
-- Citizen and Administration Contributions as Points, Lines, and -- Aitizen and Administration Contributions as Points, Lines, and
-- Polygons stored together in one mixed-geometry Column. -- Polygons stored together in one mixed-geometry Column.
-- --------------------------------------------------------------------- -- ---------------------------------------------------------------------
CREATE TABLE contributions ( CREATE TABLE contributions (

View File

@@ -1,183 +0,0 @@
-- =====================================================================
-- Migration 009: Tasks Module — Tasks with Reward System
-- =====================================================================
-- ---------------------------------------------------------------------
-- Block 1: Tasks Table
-- Stores Tasks with Geometry, Moderation and Completion.
-- Status Flow from pending to rejected or approved to completed to verified
-- ---------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS tasks (
task_id SERIAL PRIMARY KEY,
municipality_id INTEGER NOT NULL REFERENCES municipalities(municipality_id),
geom GEOMETRY(Geometry, 4326) NOT NULL,
geom_type VARCHAR(10) NOT NULL CHECK (geom_type IN ('point', 'line', 'polygon')),
category VARCHAR(50) NOT NULL,
title VARCHAR(200) NOT NULL,
description TEXT DEFAULT '',
points_reward INTEGER NOT NULL DEFAULT 25,
author_name VARCHAR(100) NOT NULL,
browser_id VARCHAR(36),
photo_path VARCHAR(255),
status VARCHAR(20) NOT NULL DEFAULT 'pending'
CHECK (status IN ('pending', 'rejected', 'approved', 'completed', 'verified')),
address VARCHAR(255),
-- Completion Fields empty before completed
completed_by_name VARCHAR(100),
completed_by_browser VARCHAR(36),
completion_photo VARCHAR(255),
completion_comment TEXT,
completed_at TIMESTAMP,
-- Counters updated via Triggers
likes_count INTEGER NOT NULL DEFAULT 0,
dislikes_count INTEGER NOT NULL DEFAULT 0,
comment_count INTEGER NOT NULL DEFAULT 0,
created_at TIMESTAMP NOT NULL DEFAULT NOW(),
updated_at TIMESTAMP NOT NULL DEFAULT NOW()
);
CREATE INDEX idx_tasks_municipality ON tasks(municipality_id);
CREATE INDEX idx_tasks_status ON tasks(status);
CREATE INDEX idx_tasks_category ON tasks(category);
-- ---------------------------------------------------------------------
-- Block 2: Citizen Points Table
-- One Row per Completion. Leaderboard via SUM and GROUP BY.
-- ---------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS user_points (
points_id SERIAL PRIMARY KEY,
municipality_id INTEGER NOT NULL REFERENCES municipalities(municipality_id),
user_name VARCHAR(100) NOT NULL,
points INTEGER NOT NULL DEFAULT 25,
task_id INTEGER NOT NULL REFERENCES tasks(task_id) ON DELETE CASCADE,
created_at TIMESTAMP NOT NULL DEFAULT NOW()
);
CREATE INDEX idx_user_points_municipality ON user_points(municipality_id);
CREATE INDEX idx_user_points_user ON user_points(user_name);
-- ---------------------------------------------------------------------
-- Block 3: Adapts Votes Table for Tasks
-- Either contribution_id OR task_id
-- ---------------------------------------------------------------------
ALTER TABLE votes
ADD COLUMN task_id INTEGER REFERENCES tasks(task_id) ON DELETE CASCADE;
CREATE INDEX idx_votes_task ON votes(task_id);
-- Unique Vote per Browser per Task
ALTER TABLE votes
ADD CONSTRAINT votes_task_browser_unique
UNIQUE (task_id, browser_id);
-- ---------------------------------------------------------------------
-- Block 4: Adapts Comments Table for Tasks
-- Either contribution_id OR task_id
-- ---------------------------------------------------------------------
ALTER TABLE comments
ADD COLUMN task_id INTEGER REFERENCES tasks(task_id) ON DELETE CASCADE;
CREATE INDEX idx_comments_task ON comments(task_id);
-- ---------------------------------------------------------------------
-- Block 5: Trigger Updated Timestamp for Tasks
-- ---------------------------------------------------------------------
CREATE TRIGGER set_tasks_updated_at
BEFORE UPDATE ON tasks
FOR EACH ROW
EXECUTE FUNCTION set_updated_at();
-- ---------------------------------------------------------------------
-- Block 6: Trigger Vote Counts for Tasks
-- Mirrors Pattern from Contributions.
-- ---------------------------------------------------------------------
CREATE OR REPLACE FUNCTION update_task_vote_counts()
RETURNS TRIGGER AS $$
BEGIN
IF TG_OP = 'INSERT' OR TG_OP = 'UPDATE' THEN
IF NEW.task_id IS NOT NULL THEN
UPDATE tasks SET
likes_count = (SELECT COUNT(*) FROM votes WHERE task_id = NEW.task_id AND vote_type = 'like'),
dislikes_count = (SELECT COUNT(*) FROM votes WHERE task_id = NEW.task_id AND vote_type = 'dislike')
WHERE task_id = NEW.task_id;
END IF;
END IF;
IF TG_OP = 'DELETE' OR (TG_OP = 'UPDATE' AND OLD.task_id IS NOT NULL) THEN
UPDATE tasks SET
likes_count = (SELECT COUNT(*) FROM votes WHERE task_id = OLD.task_id AND vote_type = 'like'),
dislikes_count = (SELECT COUNT(*) FROM votes WHERE task_id = OLD.task_id AND vote_type = 'dislike')
WHERE task_id = OLD.task_id;
END IF;
RETURN NULL;
END;
$$ LANGUAGE plpgsql;
DROP TRIGGER IF EXISTS trigger_update_task_vote_counts ON votes;
CREATE TRIGGER trigger_update_task_vote_counts
AFTER INSERT OR DELETE OR UPDATE ON votes
FOR EACH ROW
EXECUTE FUNCTION update_task_vote_counts();
-- ---------------------------------------------------------------------
-- Block 7: Trigger Comment Count for Tasks
-- Mirrors Pattern from Contributions.
-- ---------------------------------------------------------------------
CREATE OR REPLACE FUNCTION update_task_comment_count()
RETURNS TRIGGER AS $$
BEGIN
IF TG_OP = 'INSERT' OR TG_OP = 'UPDATE' THEN
IF NEW.task_id IS NOT NULL THEN
UPDATE tasks
SET comment_count = (
SELECT COUNT(*) FROM comments
WHERE task_id = NEW.task_id AND status = 'approved'
)
WHERE task_id = NEW.task_id;
END IF;
END IF;
IF TG_OP = 'DELETE' OR (TG_OP = 'UPDATE' AND OLD.task_id IS NOT NULL) THEN
UPDATE tasks
SET comment_count = (
SELECT COUNT(*) FROM comments
WHERE task_id = OLD.task_id AND status = 'approved'
)
WHERE task_id = OLD.task_id;
END IF;
RETURN NULL;
END;
$$ LANGUAGE plpgsql;
DROP TRIGGER IF EXISTS trigger_update_task_comment_count ON comments;
CREATE TRIGGER trigger_update_task_comment_count
AFTER INSERT OR DELETE OR UPDATE OF status ON comments
FOR EACH ROW
EXECUTE FUNCTION update_task_comment_count();
-- ---------------------------------------------------------------------
-- Block 8: Views for QGIS
-- ---------------------------------------------------------------------
CREATE OR REPLACE VIEW tasks_points AS
SELECT * FROM tasks WHERE geom_type = 'point';
CREATE OR REPLACE VIEW tasks_lines AS
SELECT * FROM tasks WHERE geom_type = 'line';
CREATE OR REPLACE VIEW tasks_polygons AS
SELECT * FROM tasks WHERE geom_type = 'polygon';

View File

@@ -17,7 +17,7 @@ require_once __DIR__ . '/db.php';
// --------------------------------------------------------------------- // ---------------------------------------------------------------------
// Reads Action Parameter and Routes to correct Handler // Read Action Parameter and Route to correct Handler
// --------------------------------------------------------------------- // ---------------------------------------------------------------------
$input = get_input(); $input = get_input();
$action = $input['action'] ?? ''; $action = $input['action'] ?? '';
@@ -59,27 +59,6 @@ switch ($action) {
case 'update_comment': case 'update_comment':
handle_update_comment($input); handle_update_comment($input);
break; break;
case 'read_tasks':
handle_read_tasks($input);
break;
case 'create_task':
handle_create_task($input);
break;
case 'update_task':
handle_update_task($input);
break;
case 'delete_task':
handle_delete_task($input);
break;
case 'complete_task':
handle_complete_task($input);
break;
case 'verify_task':
handle_verify_task($input);
break;
case 'read_leaderboard':
handle_read_leaderboard($input);
break;
default: default:
error_response('Unknown Action. Supported Actions are read, create, update, delete, vote.'); error_response('Unknown Action. Supported Actions are read, create, update, delete, vote.');
} }
@@ -356,8 +335,8 @@ function handle_delete($input) {
// --------------------------------------------------------------------- // ---------------------------------------------------------------------
// VOTE: Likes or Dislikes Contributions or Tasks // VOTE: Likes or Dislikes a Contribution
// Required: contribution_id or task_id, voter_name, vote_type // Required: contribution_id, voter_name, vote_type
// Database Trigger automatically updates Likes and Dislikes Count // Database Trigger automatically updates Likes and Dislikes Count
// UNIQUE Constraint prevents duplicate Votes per Voter. // UNIQUE Constraint prevents duplicate Votes per Voter.
// --------------------------------------------------------------------- // ---------------------------------------------------------------------
@@ -365,7 +344,7 @@ function handle_vote($input) {
$pdo = get_db(); $pdo = get_db();
// Validates Input // Validates Input
$missing = validate_required($input, ['voter_name', 'vote_type']); $missing = validate_required($input, ['contribution_id', 'voter_name', 'vote_type']);
if (!empty($missing)) { if (!empty($missing)) {
error_response('Missing Fields: ' . implode(', ', $missing)); error_response('Missing Fields: ' . implode(', ', $missing));
} }
@@ -376,6 +355,13 @@ function handle_vote($input) {
error_response('Invalid vote_type. Must be: ' . implode(', ', $valid_vote_types)); error_response('Invalid vote_type. Must be: ' . implode(', ', $valid_vote_types));
} }
// Checks if Contribution exists
$stmt = $pdo->prepare("SELECT contribution_id FROM contributions WHERE contribution_id = :id");
$stmt->execute([':id' => $input['contribution_id']]);
if (!$stmt->fetch()) {
error_response('Contribution not found.', 404);
}
// Prepared SQL Statement // Prepared SQL Statement
try { try {
// Checks if Voter already voted on this Contribution // Checks if Voter already voted on this Contribution
@@ -384,39 +370,11 @@ function handle_vote($input) {
error_response('Browser ID required for Voting.'); error_response('Browser ID required for Voting.');
} }
// Determines Vote Type $stmt = $pdo->prepare("
$is_task = isset($input['task_id']) && $input['task_id'] !== ''; SELECT vote_id, vote_type FROM votes
WHERE contribution_id = :cid AND browser_id = :bid
if ($is_task) { ");
// Checks for Tasks $stmt->execute([':cid' => $input['contribution_id'], ':bid' => $browser_id]);
$stmt = $pdo->prepare("SELECT task_id FROM tasks WHERE task_id = :id");
$stmt->execute([':id' => $input['task_id']]);
if (!$stmt->fetch()) {
error_response('Task not found.', 404);
}
// Checks if Browser already voted on Task
$stmt = $pdo->prepare("
SELECT vote_id, vote_type FROM votes
WHERE task_id = :id AND browser_id = :bid
");
$stmt->execute([':id' => $input['task_id'], ':bid' => $browser_id]);
} else {
// Checks for Contributions
$stmt = $pdo->prepare("SELECT contribution_id FROM contributions WHERE contribution_id = :id");
$stmt->execute([':id' => $input['contribution_id']]);
if (!$stmt->fetch()) {
error_response('Contribution not found.', 404);
}
// Checks if Browser already voted on Contribution
$stmt = $pdo->prepare("
SELECT vote_id, vote_type FROM votes
WHERE contribution_id = :id AND browser_id = :bid
");
$stmt->execute([':id' => $input['contribution_id'], ':bid' => $browser_id]);
}
$existing = $stmt->fetch(); $existing = $stmt->fetch();
if ($existing) { if ($existing) {
@@ -426,47 +384,35 @@ function handle_vote($input) {
$stmt->execute([':vid' => $existing['vote_id']]); $stmt->execute([':vid' => $existing['vote_id']]);
json_response(['message' => 'Vote removed.', 'action' => 'removed']); json_response(['message' => 'Vote removed.', 'action' => 'removed']);
} else { } else {
// Different Vote Type — Removes old Vote before Inserting new one // Different Vote Type — Switches Vote
$stmt = $pdo->prepare("DELETE FROM votes WHERE vote_id = :vid"); $stmt = $pdo->prepare("DELETE FROM votes WHERE vote_id = :vid");
$stmt->execute([':vid' => $existing['vote_id']]); $stmt->execute([':vid' => $existing['vote_id']]);
$this_insert = true;
$stmt = $pdo->prepare("
INSERT INTO votes (contribution_id, voter_name, vote_type, browser_id)
VALUES (:cid, :voter, :vtype, :bid)
");
$stmt->execute([
':cid' => $input['contribution_id'],
':voter' => $input['voter_name'],
':vtype' => $input['vote_type'],
':bid' => $browser_id
]);
json_response(['message' => 'Vote changed.', 'action' => 'changed'], 200);
} }
} else { } else {
// No existing Vote — Inserts Vote // No existing Vote — Inserts Vote
$this_insert = true; $stmt = $pdo->prepare("
}
if (!empty($this_insert)) {
if ($is_task) {
$stmt = $pdo->prepare("
INSERT INTO votes (task_id, voter_name, vote_type, browser_id)
VALUES (:id, :voter, :vtype, :bid)
");
$stmt->execute([
':id' => $input['task_id'],
':voter' => $input['voter_name'],
':vtype' => $input['vote_type'],
':bid' => $browser_id
]);
} else {
$stmt = $pdo->prepare("
INSERT INTO votes (contribution_id, voter_name, vote_type, browser_id) INSERT INTO votes (contribution_id, voter_name, vote_type, browser_id)
VALUES (:id, :voter, :vtype, :bid) VALUES (:cid, :voter, :vtype, :bid)
"); ");
$stmt->execute([ $stmt->execute([
':id' => $input['contribution_id'], ':cid' => $input['contribution_id'],
':voter' => $input['voter_name'], ':voter' => $input['voter_name'],
':vtype' => $input['vote_type'], ':vtype' => $input['vote_type'],
':bid' => $browser_id ':bid' => $browser_id
]); ]);
} json_response(['message' => 'Vote recorded.', 'action' => 'created'], 201);
// Returns changed or created
if ($existing) {
json_response(['message' => 'Vote changed.', 'action' => 'changed'], 200);
} else {
json_response(['message' => 'Vote recorded.', 'action' => 'created'], 201);
}
} }
} catch (PDOException $e) { } catch (PDOException $e) {
@@ -619,40 +565,26 @@ function handle_photo_upload($file) {
// ===================================================================== // =====================================================================
// --------------------------------------------------------------------- // ---------------------------------------------------------------------
// READ COMMENTS: Loads Comments for Contributions or Tasks // READ COMMENTS: Loads Comments for a Contribution
// Returns Comments sorted by Date (oldest first) // Returns Comments sorted by Date (newest first)
// Required: contribution_id or task_id // Required: contribution_id
// --------------------------------------------------------------------- // ---------------------------------------------------------------------
function handle_read_comments($input) { function handle_read_comments($input) {
$pdo = get_db(); $pdo = get_db();
// Checks for contribution_id or task_id $missing = validate_required($input, ['contribution_id']);
if (empty($input['contribution_id']) && empty($input['task_id'])) { if (!empty($missing)) {
error_response('Either contribution_id or task_id is required.'); error_response('Missing Fields: ' . implode(', ', $missing));
} }
// Determines Vote Type
$is_task = isset($input['task_id']) && $input['task_id'] !== '';
try { try {
if ($is_task) { $stmt = $pdo->prepare("
$stmt = $pdo->prepare(" SELECT comment_id, contribution_id, author_name, browser_id, content, status, created_at
SELECT comment_id, task_id, author_name, browser_id, content, status, created_at FROM comments
FROM comments WHERE contribution_id = :cid AND status = 'approved'
WHERE task_id = :id AND status = 'approved' ORDER BY created_at ASC
ORDER BY created_at ASC ");
"); $stmt->execute([':cid' => $input['contribution_id']]);
} else {
$stmt = $pdo->prepare("
SELECT comment_id, contribution_id, author_name, browser_id, content, status, created_at
FROM comments
WHERE contribution_id = :id AND status = 'approved'
ORDER BY created_at ASC
");
}
// Prepared Statement
$stmt->execute([':id' => $is_task ? $input['task_id'] : $input['contribution_id']]);
$comments = $stmt->fetchAll(); $comments = $stmt->fetchAll();
json_response(['comments' => $comments, 'count' => count($comments)]); json_response(['comments' => $comments, 'count' => count($comments)]);
@@ -664,56 +596,37 @@ function handle_read_comments($input) {
// --------------------------------------------------------------------- // ---------------------------------------------------------------------
// CREATE COMMENT: Adds Comments Contributions or Tasks // CREATE COMMENT: Adds Comments to Contributions
// Required: author_name, content, contribution_id or task_id // Required: contribution_id, author_name, content
// Optional: browser_id // Optional: browser_id
// --------------------------------------------------------------------- // ---------------------------------------------------------------------
function handle_create_comment($input) { function handle_create_comment($input) {
$pdo = get_db(); $pdo = get_db();
$missing = validate_required($input, ['author_name', 'content']); $missing = validate_required($input, ['contribution_id', 'author_name', 'content']);
if (!empty($missing)) { if (!empty($missing)) {
error_response('Missing Fields: ' . implode(', ', $missing)); error_response('Missing Fields: ' . implode(', ', $missing));
} }
// Checks for contribution_id or task_id // Validates Content Length
if (empty($input['contribution_id']) && empty($input['task_id'])) {
error_response('Either contribution_id or task_id is required.');
}
// Validates Length
if (strlen($input['content']) > 1000) { if (strlen($input['content']) > 1000) {
error_response('Comment too long. Maximum 1000 Characters.'); error_response('Comment too long. Maximum 1000 Characters.');
} }
// Determines Comment Type // Checks if Contribution exists
$is_task = isset($input['task_id']) && $input['task_id'] !== ''; $stmt = $pdo->prepare("SELECT contribution_id FROM contributions WHERE contribution_id = :id");
$stmt->execute([':id' => $input['contribution_id']]);
if ($is_task) { if (!$stmt->fetch()) {
// Checks for Tasks error_response('Contribution not found.', 404);
$stmt = $pdo->prepare("SELECT task_id FROM tasks WHERE task_id = :id");
$stmt->execute([':id' => $input['task_id']]);
if (!$stmt->fetch()) {
error_response('Task not found.', 404);
}
} else {
// Checks for Contributions
$stmt = $pdo->prepare("SELECT contribution_id FROM contributions WHERE contribution_id = :id");
$stmt->execute([':id' => $input['contribution_id']]);
if (!$stmt->fetch()) {
error_response('Contribution not found.', 404);
}
} }
// Prepared Statement
try { try {
$stmt = $pdo->prepare(" $stmt = $pdo->prepare("
INSERT INTO comments (contribution_id, task_id, author_name, browser_id, content) INSERT INTO comments (contribution_id, author_name, browser_id, content)
VALUES (:cid, :tid, :author, :bid, :content) VALUES (:cid, :author, :bid, :content)
"); ");
$stmt->execute([ $stmt->execute([
':cid' => $is_task ? null : $input['contribution_id'], ':cid' => $input['contribution_id'],
':tid' => $is_task ? $input['task_id'] : null,
':author' => $input['author_name'], ':author' => $input['author_name'],
':bid' => $input['browser_id'] ?? null, ':bid' => $input['browser_id'] ?? null,
':content' => $input['content'] ':content' => $input['content']
@@ -796,387 +709,4 @@ function handle_update_comment($input) {
} catch (PDOException $e) { } catch (PDOException $e) {
error_response('Database Error: ' . $e->getMessage(), 500); error_response('Database Error: ' . $e->getMessage(), 500);
} }
} }
// =====================================================================
// Action Handlers for Tasks
// =====================================================================
// ---------------------------------------------------------------------
// READ TASKS: Loads Tasks as GeoJSON FeatureCollection
// Required: municipality_id
// Optional: status, browser_id
// ---------------------------------------------------------------------
function handle_read_tasks($input) {
$pdo = get_db();
$missing = validate_required($input, ['municipality_id']);
if (!empty($missing)) {
error_response('Missing Fields: ' . implode(', ', $missing));
}
$sql = "SELECT *, ST_AsGeoJSON(geom) AS geojson
FROM tasks
WHERE municipality_id = :mid";
$params = [':mid' => $input['municipality_id']];
// Status Filter
$status = $input['status'] ?? 'visible';
if ($status === 'visible') {
$sql .= " AND status IN ('open', 'completed', 'verified')";
} elseif ($status !== 'all') {
$sql .= " AND status = :status";
$params[':status'] = $status;
}
$sql .= " ORDER BY created_at DESC";
try {
$stmt = $pdo->prepare($sql);
$stmt->execute($params);
$rows = $stmt->fetchAll();
} catch (PDOException $e) {
error_response('Database Error: ' . $e->getMessage(), 500);
}
// Builds GeoJSON FeatureCollection
$features = [];
foreach ($rows as $row) {
$geometry = json_decode($row['geojson']);
unset($row['geom'], $row['geojson']);
$features[] = [
'type' => 'Feature',
'geometry' => $geometry,
'properties' => $row
];
}
$result = [
'type' => 'FeatureCollection',
'features' => $features
];
// User Votes for Tasks
$browser_id = $input['browser_id'] ?? '';
if ($browser_id !== '') {
$stmt = $pdo->prepare("
SELECT task_id, vote_type FROM votes
WHERE browser_id = :bid AND task_id IS NOT NULL
");
$stmt->execute([':bid' => $browser_id]);
$user_votes = [];
foreach ($stmt->fetchAll() as $v) {
$user_votes[$v['task_id']] = $v['vote_type'];
}
$result['user_votes'] = $user_votes;
}
json_response($result);
}
// ---------------------------------------------------------------------
// CREATE TASK: Inserts new Task with optional Photo
// Required: municipality_id, geom, geom_type, category, title, author_name
// Optional: description, browser_id, photo
// ---------------------------------------------------------------------
function handle_create_task($input) {
$pdo = get_db();
$missing = validate_required($input, [
'municipality_id', 'geom', 'geom_type', 'category', 'title', 'author_name'
]);
if (!empty($missing)) {
error_response('Missing Fields: ' . implode(', ', $missing));
}
$valid_geom_types = ['point', 'line', 'polygon'];
if (!in_array($input['geom_type'], $valid_geom_types)) {
error_response('Invalid Geometry Type.');
}
$geojson = json_decode($input['geom']);
if (!$geojson || !isset($geojson->type)) {
error_response('Invalid GeoJSON.');
}
// Handles optional Photo Upload
$photo_path = null;
if (isset($_FILES['photo']) && $_FILES['photo']['error'] === UPLOAD_ERR_OK) {
$photo_path = handle_photo_upload($_FILES['photo']);
if (!$photo_path) {
error_response('Photo Upload failed. JPG, PNG, GIF and WebP up to 5 MB.');
}
}
try {
$stmt = $pdo->prepare("
INSERT INTO tasks
(municipality_id, geom, geom_type, category, title, description, author_name, browser_id, photo_path)
VALUES
(:mid, ST_SetSRID(ST_GeomFromGeoJSON(:geom), 4326), :geom_type,
:category, :title, :description, :author_name, :browser_id, :photo_path)
");
$stmt->execute([
':mid' => $input['municipality_id'],
':geom' => $input['geom'],
':geom_type' => $input['geom_type'],
':category' => $input['category'],
':title' => $input['title'],
':description' => $input['description'] ?? '',
':author_name' => $input['author_name'],
':browser_id' => $input['browser_id'] ?? null,
':photo_path' => $photo_path
]);
json_response([
'message' => 'Task created successfully.',
'task_id' => (int) $pdo->lastInsertId()
], 201);
} catch (PDOException $e) {
error_response('Database Error: ' . $e->getMessage(), 500);
}
}
// ---------------------------------------------------------------------
// UPDATE TASK: Updates existing Tasks or Status
// Required: task_id
// Optional: category, title, description, status, address
// ---------------------------------------------------------------------
function handle_update_task($input) {
$pdo = get_db();
$missing = validate_required($input, ['task_id']);
if (!empty($missing)) {
error_response('Missing Fields: ' . implode(', ', $missing));
}
$updatable = ['category', 'title', 'description', 'status', 'address'];
$set = [];
$params = [':id' => $input['task_id']];
foreach ($updatable as $field) {
if (isset($input[$field]) && $input[$field] !== '') {
$set[] = "$field = :$field";
$params[":$field"] = $input[$field];
}
}
if (empty($set)) {
error_response('No Fields to update.');
}
if (isset($params[':status'])) {
$valid = ['pending', 'rejected', 'open', 'completed', 'verified'];
if (!in_array($params[':status'], $valid)) {
error_response('Invalid Status.');
}
}
try {
$stmt = $pdo->prepare("UPDATE tasks SET " . implode(', ', $set) . " WHERE task_id = :id");
$stmt->execute($params);
json_response(['message' => 'Task updated successfully.']);
} catch (PDOException $e) {
error_response('Database Error: ' . $e->getMessage(), 500);
}
}
// ---------------------------------------------------------------------
// DELETE TASK: Removes existing Tasks
// Required: task_id
// ---------------------------------------------------------------------
function handle_delete_task($input) {
$pdo = get_db();
$missing = validate_required($input, ['task_id']);
if (!empty($missing)) {
error_response('Missing Fields: ' . implode(', ', $missing));
}
try {
$stmt = $pdo->prepare("DELETE FROM tasks WHERE task_id = :id");
$stmt->execute([':id' => $input['task_id']]);
json_response(['message' => 'Task deleted successfully.']);
} catch (PDOException $e) {
error_response('Database Error: ' . $e->getMessage(), 500);
}
}
// ---------------------------------------------------------------------
// COMPLETE TASK: Completes existing Tasks with Photo Proof
// Required: task_id, author_name, browser_id
// Required File: completion_photo
// Optional: completion_comment
// ---------------------------------------------------------------------
function handle_complete_task($input) {
$pdo = get_db();
$missing = validate_required($input, ['task_id', 'author_name', 'browser_id']);
if (!empty($missing)) {
error_response('Missing Fields: ' . implode(', ', $missing));
}
// Checks if Task exists and is open
$stmt = $pdo->prepare("SELECT task_id, status FROM tasks WHERE task_id = :id");
$stmt->execute([':id' => $input['task_id']]);
$task = $stmt->fetch();
if (!$task) {
error_response('Task not found.', 404);
}
if ($task['status'] !== 'open') {
error_response('Task is not available for Completion.');
}
// Handles required Completion Photo
if (!isset($_FILES['completion_photo']) || $_FILES['completion_photo']['error'] !== UPLOAD_ERR_OK) {
error_response('Completion Photo is required.');
}
$photo_path = handle_photo_upload($_FILES['completion_photo']);
if (!$photo_path) {
error_response('Photo Upload failed. JPG, PNG, GIF and WebP up to 5 MB.');
}
try {
$stmt = $pdo->prepare("
UPDATE tasks SET
status = 'completed',
completed_by_name = :name,
completed_by_browser = :browser,
completion_photo = :photo,
completion_comment = :comment,
completed_at = NOW()
WHERE task_id = :id
");
$stmt->execute([
':id' => $input['task_id'],
':name' => $input['author_name'],
':browser' => $input['browser_id'],
':photo' => $photo_path,
':comment' => $input['completion_comment'] ?? ''
]);
json_response(['message' => 'Task Completion submitted for Review.']);
} catch (PDOException $e) {
error_response('Database Error: ' . $e->getMessage(), 500);
}
}
// ---------------------------------------------------------------------
// VERIFY TASK: Moderator confirms or rejects Completions
// Required: task_id, action
// Awards Points and sets Status if verified
// Clears Completion Fields, resets Status if rejected
// ---------------------------------------------------------------------
function handle_verify_task($input) {
$pdo = get_db();
$missing = validate_required($input, ['task_id', 'verify_action']);
if (!empty($missing)) {
error_response('Missing Fields: ' . implode(', ', $missing));
}
// Loads Task
$stmt = $pdo->prepare("SELECT * FROM tasks WHERE task_id = :id");
$stmt->execute([':id' => $input['task_id']]);
$task = $stmt->fetch();
if (!$task) {
error_response('Task not found.', 404);
}
if ($task['status'] !== 'completed') {
error_response('Task is not in completed State.');
}
try {
if ($input['verify_action'] === 'verify') {
// Accepts Completion and Awards Points
$stmt = $pdo->prepare("UPDATE tasks SET status = 'verified' WHERE task_id = :id");
$stmt->execute([':id' => $input['task_id']]);
// Awards Points to User
$stmt = $pdo->prepare("
INSERT INTO user_points (municipality_id, user_name, points, task_id)
VALUES (:mid, :name, :points, :tid)
");
$stmt->execute([
':mid' => $task['municipality_id'],
':name' => $task['completed_by_name'],
':points' => $task['points_reward'],
':tid' => $input['task_id']
]);
json_response(['message' => 'Task verified. Points awarded.']);
} elseif ($input['verify_action'] === 'reject') {
// Rejects Completion and Clears Fields
$stmt = $pdo->prepare("
UPDATE tasks SET
status = 'open',
completed_by_name = NULL,
completed_by_browser = NULL,
completion_photo = NULL,
completion_comment = NULL,
completed_at = NULL
WHERE task_id = :id
");
$stmt->execute([':id' => $input['task_id']]);
json_response(['message' => 'Completion rejected. Task is open again.']);
} else {
error_response('Invalid Action. Must be: verify or reject.');
}
} catch (PDOException $e) {
error_response('Database Error: ' . $e->getMessage(), 500);
}
}
// ---------------------------------------------------------------------
// READ LEADERBOARD: Returns Citizen Leaderboard
// Required: municipality_id
// Optional: limit
// ---------------------------------------------------------------------
function handle_read_leaderboard($input) {
$pdo = get_db();
$missing = validate_required($input, ['municipality_id']);
if (!empty($missing)) {
error_response('Missing Fields: ' . implode(', ', $missing));
}
$limit = min((int)($input['limit'] ?? 10), 50);
try {
$stmt = $pdo->prepare("
SELECT user_name,
SUM(points) AS total_points,
COUNT(*) AS tasks_completed
FROM user_points
WHERE municipality_id = :mid
GROUP BY user_name
ORDER BY total_points DESC
LIMIT :lim
");
$stmt->bindValue(':mid', $input['municipality_id'], PDO::PARAM_INT);
$stmt->bindValue(':lim', $limit, PDO::PARAM_INT);
$stmt->execute();
json_response(['leaderboard' => $stmt->fetchAll()]);
} catch (PDOException $e) {
error_response('Database Error: ' . $e->getMessage(), 500);
}
}

View File

@@ -110,22 +110,4 @@ function get_categories() {
'industry' => ['label' => 'Industrie', 'faIcon' => 'fa-industry', 'color' => '#7030A0'], 'industry' => ['label' => 'Industrie', 'faIcon' => 'fa-industry', 'color' => '#7030A0'],
'other' => ['label' => 'Sonstiges', 'faIcon' => 'fa-thumbtack', 'color' => '#7F7F7F'], 'other' => ['label' => 'Sonstiges', 'faIcon' => 'fa-thumbtack', 'color' => '#7F7F7F'],
]; ];
}
// ---------------------------------------------------------------------
// Task Category Definitions
// Returns associative Array of Task Category Keys to Labels, Icons,
// and Colors. Shared between Citizen Participation Portal and
// Moderation Page.
// ToDo: Move to Database Table.
// ---------------------------------------------------------------------
function get_task_categories() {
return [
'repair' => ['label' => 'Reparatur', 'faIcon' => 'fa-wrench', 'color' => '#C00000'],
'social' => ['label' => 'Nachbarschaft', 'faIcon' => 'fa-people-group', 'color' => '#E65100'],
'safety' => ['label' => 'Sicherheit', 'faIcon' => 'fa-shield-halved', 'color' => '#FFC000'],
'greenery' => ['label' => 'Grünpflege', 'faIcon' => 'fa-leaf', 'color' => '#92D050'],
'cleanup' => ['label' => 'Sauberkeit', 'faIcon' => 'fa-broom', 'color' => '#0070C0'],
'other_task' => ['label' => 'Sonstiges', 'faIcon' => 'fa-clipboard-check','color' => '#7F7F7F'],
];
} }

View File

@@ -130,71 +130,30 @@ $news_items = $stmt->fetchAll();
<!-- Sidebar Tab Icons --> <!-- Sidebar Tab Icons -->
<div class="leaflet-sidebar-tabs"> <div class="leaflet-sidebar-tabs">
<ul role="tablist"> <ul role="tablist">
<li><a href="#tab-contributions" role="tab" title="Hinweise"><i class="fa-solid fa-clipboard-list"></i></a></li> <li><a href="#tab-home" role="tab"><i class="fa-solid fa-house"></i></a></li>
<li><a href="#tab-tasks" role="tab" title="Aufgaben"><i class="fa-solid fa-clipboard-check"></i></a></li> <li><a href="#tab-list" role="tab"><i class="fa-solid fa-list"></i></a></li>
<li><a href="#tab-list" role="tab" title="Beiträge"><i class="fa-solid fa-list"></i></a></li> <li><a href="#tab-news" role="tab"><i class="fa-solid fa-newspaper"></i></a></li>
<li><a href="#tab-news" role="tab" title="Neuigkeiten"><i class="fa-solid fa-newspaper"></i></a></li> <li><a href="#tab-help" role="tab"><i class="fa-solid fa-circle-question"></i></a></li>
<li><a href="#tab-help" role="tab" title="Hilfe"><i class="fa-solid fa-circle-question"></i></a></li>
</ul> </ul>
</div> </div>
<!-- Sidebar Tab Content --> <!-- Sidebar Tab Content -->
<div class="leaflet-sidebar-content"> <div class="leaflet-sidebar-content">
<!-- Contributions Tab --> <!-- Home Tab -->
<div class="leaflet-sidebar-pane" id="tab-contributions"> <div class="leaflet-sidebar-pane" id="tab-home">
<h2 class="leaflet-sidebar-header"> <h2 class="leaflet-sidebar-header">
Hinweise Start
<span class="leaflet-sidebar-close"><i class="fa-solid fa-xmark"></i></span> <span class="leaflet-sidebar-close"><i class="fa-solid fa-xmark"></i></span>
</h2> </h2>
<div class="sidebar-body"> <div class="sidebar-body">
<p>Verwenden Sie die Karte, um <strong>Hinweise</strong> für die Stadtverwaltung hinzuzufügen oder bestehende Hinweise zu betrachten, bewerten und kommentieren</p> <p>Willkommen beim Bürgerbeteiligungsportal <strong><?= htmlspecialchars($municipality['name']) ?></strong>.</p>
<p>Verwenden Sie die Karte, um Hinweise für die Stadtverwaltung hinzuzufügen oder bestehende Beiträge zu betrachten, zu bewerten und zu kommentieren.</p>
<h3>Kategorien</h3> <h3>Kategorien</h3>
<div id="category-filter"> <div id="category-filter">
<!-- populated by app.js --> <!-- Category Filter Checkboxes — populated by app.js -->
</div> </div>
<p id="stats-container"></p>
<!-- populated by app.js -->
</div>
</div>
<!-- Tasks Tab -->
<div class="leaflet-sidebar-pane" id="tab-tasks">
<h2 class="leaflet-sidebar-header">
Aufgaben
<span class="leaflet-sidebar-close"><i class="fa-solid fa-xmark"></i></span>
</h2>
<div class="sidebar-body">
<p>Verwenden Sie die Karte, um <strong>Aufgaben</strong> für die Gemeinschaft hinzuzufügen oder bestehende Aufgaben zu betrachten, bewerten und kommentieren.</p>
<h3>Kategorien</h3>
<div id="task-category-filter">
<!-- populated by app.js -->
</div>
<p id="task-stats-container">
<!-- populated by app.js -->
</p>
<div class="task-filter-row">
<select id="task-status-filter" class="form-input" onchange="updateTasksList()" style="margin-bottom:8px;">
<option value="open">Offene Aufgaben</option>
<option value="all">Alle Aufgaben</option>
<option value="completed">Wartend auf Prüfung</option>
<option value="verified">Erledigte Aufgaben</option>
</select>
</div>
<!-- Leaderboard -->
<div id="leaderboard-container" class="leaderboard-box">
<h3>Rangliste</h3>
<div id="leaderboard-list"></div>
<button class="btn btn-secondary leaderboard-more-btn" onclick="showFullLeaderboard()">
Vollständige Rangliste
</button>
</div>
</div> </div>
</div> </div>
@@ -209,10 +168,10 @@ $news_items = $stmt->fetchAll();
<input type="text" id="list-search-input" placeholder="Beiträge durchsuchen..." class="form-input"> <input type="text" id="list-search-input" placeholder="Beiträge durchsuchen..." class="form-input">
</div> </div>
<div id="contributions-list"> <div id="contributions-list">
<!-- populated by app.js --> <!-- Contribution Cards — populated by app.js -->
</div> </div>
</div> </div>
</div> </div>
<!-- News Tab --> <!-- News Tab -->
<div class="leaflet-sidebar-pane" id="tab-news"> <div class="leaflet-sidebar-pane" id="tab-news">
@@ -221,18 +180,21 @@ $news_items = $stmt->fetchAll();
<span class="leaflet-sidebar-close"><i class="fa-solid fa-xmark"></i></span> <span class="leaflet-sidebar-close"><i class="fa-solid fa-xmark"></i></span>
</h2> </h2>
<div class="sidebar-body"> <div class="sidebar-body">
<!-- News Search -->
<div class="list-search"> <div class="list-search">
<input type="text" id="news-search-input" placeholder="Neuigkeiten durchsuchen..." class="form-input" oninput="filterNews()"> <input type="text" id="news-search-input" placeholder="Neuigkeiten durchsuchen..." class="form-input" oninput="filterNews()">
</div> </div>
<!-- News Items Container -->
<div id="news-list"> <div id="news-list">
<?php if (empty($news_items)): ?> <?php if (empty($news_items)): ?>
<p style="text-align:center;color:#999;padding:20px;">Noch keine Neuigkeiten veröffentlicht.</p> <p class="empty-state">Noch keine Neuigkeiten veröffentlicht.</p>
<?php else: ?> <?php else: ?>
<?php foreach ($news_items as $news): ?> <?php foreach ($news_items as $news): ?>
<div class="news-item" <div class="news-item"
data-title="<?= htmlspecialchars(strtolower($news['title'])) ?>" data-title="<?= htmlspecialchars(strtolower($news['title'])) ?>"
data-content="<?= htmlspecialchars(strtolower($news['content'])) ?>" data-content="<?= htmlspecialchars(strtolower($news['content'])) ?>"
data-author="<?= htmlspecialchars(strtolower($news['author_name'])) ?>"> data-author="<?= htmlspecialchars(strtolower($news['author_name'])) ?>">
<h3><?= htmlspecialchars($news['title']) ?></h3> <h3><?= htmlspecialchars($news['title']) ?></h3>
<p><?= nl2br(htmlspecialchars($news['content'])) ?></p> <p><?= nl2br(htmlspecialchars($news['content'])) ?></p>
<span class="news-date"> <span class="news-date">
@@ -246,7 +208,7 @@ $news_items = $stmt->fetchAll();
</div> </div>
</div> </div>
<!-- Help Tab --> <!-- Help Tab -->
<div class="leaflet-sidebar-pane" id="tab-help"> <div class="leaflet-sidebar-pane" id="tab-help">
<h2 class="leaflet-sidebar-header"> <h2 class="leaflet-sidebar-header">
Hilfe Hilfe
@@ -273,16 +235,12 @@ $news_items = $stmt->fetchAll();
<h3><i class="fa-solid fa-comments"></i> Kommentieren</h3> <h3><i class="fa-solid fa-comments"></i> Kommentieren</h3>
<p>Gerne können Sie Ihre Meinung zu bestehenden Beiträgen auch durch die Kommentarfunktion äußern.</p> <p>Gerne können Sie Ihre Meinung zu bestehenden Beiträgen auch durch die Kommentarfunktion äußern.</p>
<h3><i class="fa-solid fa-clipboard-check"></i> Aufgaben erledigen</h3>
<p>Klicken Sie auf eine offene Aufgabe und melden Sie die Erledigung mit einem Foto-Nachweis.</p>
<h3><i class="fa-solid fa-magnifying-glass"></i> Suchen</h3> <h3><i class="fa-solid fa-magnifying-glass"></i> Suchen</h3>
<p>Verwenden Sie die Adresssuche rechts, um schnell den richtigen Ort auf der Mitmachkarte zu finden.</p> <p>Verwenden Sie die Adresssuche rechts, um schnell den richtigen Ort auf der Mitmachkarte zu finden.</p>
</div> </div>
</div> </div>
</div> </div>
</div> </div>
<!-- Leaflet Map --> <!-- Leaflet Map -->
@@ -351,7 +309,7 @@ $news_items = $stmt->fetchAll();
<!-- ============================================================= --> <!-- ============================================================= -->
<div id="create-modal" class="modal-overlay" style="display:none;"> <div id="create-modal" class="modal-overlay" style="display:none;">
<div class="modal-content"> <div class="modal-content">
<h2><i class="fa-solid fa-plus-circle"></i> Beitrag</h2> <h2><i class="fa-solid fa-pencil"></i> Beitrag hinzufügen</h2>
<div class="form-group"> <div class="form-group">
<label for="create-category">Kategorie</label> <label for="create-category">Kategorie</label>
@@ -439,7 +397,6 @@ $news_items = $stmt->fetchAll();
// Category Definitions from Database // Category Definitions from Database
const CATEGORIES = <?= json_encode(get_categories(), JSON_UNESCAPED_UNICODE) ?>; const CATEGORIES = <?= json_encode(get_categories(), JSON_UNESCAPED_UNICODE) ?>;
const TASK_CATEGORIES = <?= json_encode(get_task_categories(), JSON_UNESCAPED_UNICODE) ?>;
// Admin Status from PHP Session // Admin Status from PHP Session
const IS_ADMIN = <?= (function_exists('is_admin') && is_admin()) ? 'true' : 'false' ?>; const IS_ADMIN = <?= (function_exists('is_admin') && is_admin()) ? 'true' : 'false' ?>;

View File

@@ -88,9 +88,9 @@ basemapCartoDB.addTo(map);
// Layer Control // Layer Control
const basemaps = { const basemaps = {
'<i class="fa-solid fa-map" style="color:#404040;"></i> Hintergrundkarte (farbe)': basemapOSM, // 'Hintergrundkarte': basemapOSM,
'<i class="fa-solid fa-map" style="color:#404040;"></i> Hintergrundkarte (grau)': basemapCartoDB, 'Hintergrundkarte': basemapCartoDB,
'<i class="fa-solid fa-satellite" style="color:#404040;"></i> Satellitenbild': basemapSatellite, 'Satellitenbild': basemapSatellite,
}; };
const overlays = {}; // Populated later with Contribution Layers const overlays = {}; // Populated later with Contribution Layers
@@ -100,6 +100,16 @@ const layerControl = L.control.layers(basemaps, overlays, {
collapsed: true collapsed: true
}).addTo(map); }).addTo(map);
// Adds styled Header to Layer Control Dropdown
var layerControlContainer = layerControl.getContainer();
var layerList = layerControlContainer.querySelector('.leaflet-control-layers-list');
if (layerList) {
var header = document.createElement('div');
header.className = 'layer-control-header';
header.innerHTML = '<i class="fa-solid fa-layer-group"></i> Layerauswahl';
layerList.parentNode.insertBefore(header, layerList);
}
// ===================================================================== // =====================================================================
// Block 4: Map Controls // Block 4: Map Controls
@@ -111,11 +121,11 @@ L.control.zoom({
}).addTo(map); }).addTo(map);
// Scale Bar // Scale Bar
L.control.scale({ // L.control.scale({
position: 'bottomright', // position: 'bottomright',
maxWidth: 200, // maxWidth: 200,
imperial: false // imperial: false
}).addTo(map); // }).addTo(map);
// Fullscreen Button // Fullscreen Button
L.control.fullscreen({ L.control.fullscreen({
@@ -220,6 +230,21 @@ sidebar = L.control.sidebar({
position: 'left' position: 'left'
}).addTo(map); }).addTo(map);
// Hides Map Controls on Mobile while Sidebar is open
sidebar.on('content', function () {
if (window.innerWidth < 769) {
document.querySelectorAll('.leaflet-top.leaflet-right').forEach(function (el) {
el.style.display = 'none';
});
}
});
sidebar.on('closing', function () {
document.querySelectorAll('.leaflet-top.leaflet-right').forEach(function (el) {
el.style.display = '';
});
});
// ===================================================================== // =====================================================================
// Block 6: Geoman Drawing Tools and CRUD Trigger // Block 6: Geoman Drawing Tools and CRUD Trigger
@@ -243,6 +268,40 @@ map.pm.addControls({
map.pm.setLang('de'); map.pm.setLang('de');
// Overwrites Geoman German Translations for User-friendly Labels
map.pm.setLang('custom', {
tooltips: {
placeMarker: 'Punkt setzen mit Klick',
firstVertex: 'Ersten Punkt setzen mit Klick',
continueLine: 'Nächsten Punkt setzen mit Klick',
finishLine: 'Beenden mit Klick auf letzten Punkt',
finishPoly: 'Beenden mit Klick auf ersten Punkt',
finishRect: 'Beenden mit Klick'
},
actions: {
finish: 'Beenden',
cancel: 'Abbrechen',
removeLastVertex: 'Letzten Punkt löschen'
},
buttonTitles: {
drawMarkerButton: 'Punkt zeichnen',
drawPolyButton: 'Fläche zeichnen',
drawLineButton: 'Linie zeichnen',
drawCircleButton: 'Kreis zeichnen',
drawRectButton: 'Rechteck zeichnen',
editButton: 'Objekte bearbeiten',
dragButton: 'Objekte verschieben',
cutButton: 'Objekte ausschneiden',
deleteButton: 'Objekte löschen',
drawCircleMarkerButton: 'Kreismarker zeichnen',
snappingButton: 'Einrasten',
pinningButton: 'Fixieren',
rotateButton: 'Objekte drehen',
drawTextButton: 'Text zeichnen'
}
});
// Captures drawn Geometry and opens the Create Modal // Captures drawn Geometry and opens the Create Modal
map.on('pm:create', function (e) { map.on('pm:create', function (e) {
const geojson = e.layer.toGeoJSON().geometry; const geojson = e.layer.toGeoJSON().geometry;
@@ -343,10 +402,10 @@ function loadContributions() {
onEachFeature: bindFeaturePopup onEachFeature: bindFeaturePopup
}).addTo(map); }).addTo(map);
layerControl.addOverlay(contributionsLayer, '<i class="fa-solid fa-map-pin" style="color:#C00000;"></i> Beiträge'); layerControl.addOverlay(contributionsLayer, 'Bürgerbeiträge');
// Update Sidebar List and Statistics // Update Sidebar List and Statistics
updateContributionsList(); updateContributionsList();
updateStatistics(); buildCategoryFilter();
}); });
} }
@@ -473,11 +532,25 @@ function buildPopupHtml(feature) {
function bindFeaturePopup(feature, layer) { function bindFeaturePopup(feature, layer) {
const cat = CATEGORIES[feature.properties.category] || CATEGORIES.other; const cat = CATEGORIES[feature.properties.category] || CATEGORIES.other;
// Dynamic Popup — rebuilt every Time the Popup opens // Popup Options — Mobile narrower with Header/Footer Padding
layer.bindPopup(function () { return buildPopupHtml(feature); }, { maxWidth: 320, minWidth: 240 }); var mobile = window.innerWidth < 769;
var opts = {
maxWidth: mobile ? 280 : 320,
minWidth: mobile ? 200 : 240,
maxHeight: mobile ? 280 : 400,
autoPanPaddingTopLeft: L.point(mobile ? 50 : 75, mobile ? 75 : 75),
autoPanPaddingBottomRight: L.point(mobile ? 60 : 85, mobile ? 50 : 75),
className: 'contribution-popup'
};
// Loads Comments when Popup opens // Dynamic Popup — rebuilt every Time the Popup opens
layer.bindPopup(function () { return buildPopupHtml(feature); }, opts);
// Closes Sidebar on Mobile and loads Comments when Popup opens
layer.on('popupopen', function () { layer.on('popupopen', function () {
if (window.innerWidth < 769) {
sidebar.close();
}
loadComments(feature.properties.contribution_id); loadComments(feature.properties.contribution_id);
}); });
@@ -766,7 +839,7 @@ function updateContributionsList() {
// Builds HTML // Builds HTML
if (filtered.length === 0) { if (filtered.length === 0) {
container.innerHTML = '<p style="text-align:center;color:#999;padding:20px;">Keine Beiträge gefunden.</p>'; container.innerHTML = '<p class="empty-state">Keine Beiträge gefunden.</p>';
return; return;
} }
@@ -830,22 +903,33 @@ document.getElementById('list-search-input').addEventListener('input', function
// Block 12: Sidebar Category Filter and Statistics // Block 12: Sidebar Category Filter and Statistics
// ===================================================================== // =====================================================================
// Builds Category Filter Checkboxes // Builds Category Filter Checkboxes with Counts
function buildCategoryFilter() { function buildCategoryFilter() {
const container = document.getElementById('category-filter'); const container = document.getElementById('category-filter');
const counts = {};
contributionsData.forEach(function (f) {
const cat = f.properties.category;
counts[cat] = (counts[cat] || 0) + 1;
});
const total = contributionsData.length;
let html = ''; let html = '';
for (const key in CATEGORIES) { for (const key in CATEGORIES) {
const cat = CATEGORIES[key]; const cat = CATEGORIES[key];
const checked = activeFilters.indexOf(key) !== -1 ? 'checked' : ''; const checked = activeFilters.indexOf(key) !== -1 ? 'checked' : '';
const count = counts[key] || 0;
html += '' + html += '<label style="display:flex;align-items:center;gap:8px;margin-bottom:6px;cursor:pointer;font-size:0.85rem;color:var(--color-text-secondary)">' +
'<label style="display:flex;align-items:center;gap:8px;margin-bottom:6px;cursor:pointer;">' + '<input type="checkbox" value="' + key + '" ' + checked + ' onchange="toggleCategoryFilter(this)">' +
'<input type="checkbox" value="' + key + '" ' + checked + ' onchange="toggleCategoryFilter(this)">' + categoryIcon(cat) +
'<span>' + categoryIcon(cat) + ' ' + cat.label + '</span>' + '<span>' + cat.label + ' (' + count + ')</span>' +
'</label>'; '</label>';
} }
html += '<p style="margin-top:10px;font-size:0.85rem;color:var(--color-text-secondary)"><strong>' + total + '</strong> Beiträge insgesamt</p>';
container.innerHTML = html; container.innerHTML = html;
} }
@@ -892,34 +976,6 @@ function toggleCategoryFilter(checkbox) {
updateContributionsList(); updateContributionsList();
} }
// Updates Statistics in Home Tab
function updateStatistics() {
const container = document.getElementById('stats-container');
const total = contributionsData.length;
// Counts per Category
// const counts = {};
// contributionsData.forEach(function (f) {
// const cat = f.properties.category;
// counts[cat] = (counts[cat] || 0) + 1;
// });
let html = '<p style="font-size:0.8rem;"><strong>' + total + '</strong> Hinweise insgesamt</p>';
// for (const key in CATEGORIES) {
// const cat = CATEGORIES[key];
// const count = counts[key] || 0;
// if (count > 0) {
// html += '<div style="display:flex;align-items:center;gap:8px;margin:4px 0;font-size:0.8rem;">' +
// categoryIcon(cat) + ' ' +
// cat.label + ': ' + count +
// '</div>';
// }
// }
container.innerHTML = html;
}
// ===================================================================== // =====================================================================
// Block 13: Modals — Welcome, Login, Info, Privacy, Imprint // Block 13: Modals — Welcome, Login, Info, Privacy, Imprint
@@ -957,6 +1013,11 @@ function submitLogin() {
document.cookie = 'webgis_user=' + encodeURIComponent(name) + ';path=/;max-age=31536000;SameSite=Lax'; document.cookie = 'webgis_user=' + encodeURIComponent(name) + ';path=/;max-age=31536000;SameSite=Lax';
document.getElementById('login-modal').style.display = 'none'; document.getElementById('login-modal').style.display = 'none';
// Starts Onboarding Tour on first Login
if (!localStorage.getItem('webgis_onboarding_done')) {
setTimeout(function () { startTour(); }, 500);
}
// Open Create Modal if Geometry is pending // Open Create Modal if Geometry is pending
if (drawnGeometry) { if (drawnGeometry) {
document.getElementById('create-geom').value = JSON.stringify(drawnGeometry); document.getElementById('create-geom').value = JSON.stringify(drawnGeometry);
@@ -967,6 +1028,11 @@ function submitLogin() {
function skipLogin() { function skipLogin() {
document.getElementById('login-modal').style.display = 'none'; document.getElementById('login-modal').style.display = 'none';
// Starts Onboarding Tour on first Login
if (!localStorage.getItem('webgis_onboarding_done')) {
setTimeout(function () { startTour(); }, 500);
}
} }
// Info Modal // Info Modal
@@ -1034,7 +1100,7 @@ function escapeHtml(text) {
// Returns a colored Font Awesome Icon HTML String for a Category // Returns a colored Font Awesome Icon HTML String for a Category
function categoryIcon(cat) { function categoryIcon(cat) {
return '<i class="fa-solid ' + cat.faIcon + '" style="color:' + cat.color + ';"></i>'; return '<i class="fa-solid ' + cat.faIcon + ' fa-fw" style="color:' + cat.color + ';"></i>';
} }
// Reverse Geocodes Coordinates and saves Address to Contribution via API // Reverse Geocodes Coordinates and saves Address to Contribution via API
@@ -1160,7 +1226,24 @@ function deleteComment(commentId, contributionId) {
}); });
} }
// Toggles Photo Visibility in Popup // Pans Map if Popup behind Header
function recenterPopup() {
map.eachLayer(function (layer) {
if (layer.getPopup && layer.getPopup() && layer.isPopupOpen()) {
var popupEl = layer.getPopup().getElement();
if (!popupEl) return;
var padding = window.innerWidth < 769 ? 75 : 75;
var popupTop = popupEl.getBoundingClientRect().top;
var mapTop = document.getElementById('map').getBoundingClientRect().top;
var diff = popupTop - mapTop - padding;
if (diff < 0) {
map.panBy([0, diff], { animate: true, duration: 0.3 });
}
}
});
}
// Toggles Photo Visibility in Popup and updates Popup Position
function togglePhoto(contributionId) { function togglePhoto(contributionId) {
const container = document.getElementById('photo-container-' + contributionId); const container = document.getElementById('photo-container-' + contributionId);
const label = document.getElementById('photo-label-' + contributionId); const label = document.getElementById('photo-label-' + contributionId);
@@ -1173,9 +1256,11 @@ function togglePhoto(contributionId) {
container.style.display = 'none'; container.style.display = 'none';
label.textContent = 'Foto anzeigen'; label.textContent = 'Foto anzeigen';
} }
setTimeout(recenterPopup, 150);
} }
// Toggles Comments Section Visibility in Popup // Toggles Comments Section Visibility in Popup and updates Popup Position
function toggleComments(contributionId) { function toggleComments(contributionId) {
const section = document.getElementById('comments-section-' + contributionId); const section = document.getElementById('comments-section-' + contributionId);
const toggle = document.getElementById('comments-toggle-' + contributionId); const toggle = document.getElementById('comments-toggle-' + contributionId);
@@ -1192,6 +1277,8 @@ function toggleComments(contributionId) {
toggle.classList.remove('fa-chevron-up'); toggle.classList.remove('fa-chevron-up');
toggle.classList.add('fa-chevron-down'); toggle.classList.add('fa-chevron-down');
} }
setTimeout(recenterPopup, 150);
} }

View File

@@ -1,6 +1,7 @@
// ===================================================================== // =====================================================================
// WebGIS Citizen Participation Portal — Onboarding Tour // WebGIS Citizen Participation Portal — Onboarding Tour
// Guides Users through the Participation Portal // Guides Users through the Participation Portal.
// On Mobile centered Overlays. On Desktop attached to User Interface.
// ===================================================================== // =====================================================================
@@ -8,76 +9,30 @@
// Block 1: Onboarding Configuration // Block 1: Onboarding Configuration
// ================================================================= // =================================================================
// ONBOARDING_MODE — Controls when the Tutorial is shown:
const ONBOARDING_MODE = 'once';
// 'once' — Shown on first Visit, stored in localStorage
// 'session' — Shown per Browser Session, stored in sessionStorage
// 'always' — Shows always, nothing stored
// Prevents double Initialization // Prevents double Initialization
let onboardingStarted = false; let onboardingStarted = false;
// Detects Mobile Viewport
// ================================================================= function isMobile() {
// Block 2: Tour Initialization return window.innerWidth < 769;
// =================================================================
function initOnboardingTour() {
// Checks if Tutorial should be shown based on Onboarding Mode
if (ONBOARDING_MODE === 'once' && localStorage.getItem('webgis_onboarding_done')) {
return;
}
if (ONBOARDING_MODE === 'session' && sessionStorage.getItem('webgis_onboarding_done')) {
return;
}
// Waits for Welcome and Login Modals to be closed
waitForModalsToClose(function () {
setTimeout(startTour, 600);
});
} }
// ================================================================= // =================================================================
// Block 3: Modal Watcher — Starts Tour other Welcome and Login Modals closed // Block 2: Tour Definition
// ================================================================= // =================================================================
function waitForModalsToClose(callback) { function startTour(manual) {
const welcomeModal = document.getElementById('welcome-modal');
const loginModal = document.getElementById('login-modal');
const checkInterval = setInterval(function () {
const welcomeHidden = !welcomeModal || welcomeModal.style.display === 'none' || welcomeModal.style.display === '';
const loginHidden = !loginModal || loginModal.style.display === 'none' || loginModal.style.display === '';
if (welcomeHidden && loginHidden) {
clearInterval(checkInterval);
callback();
}
}, 300);
// Safety Timeout
setTimeout(function () {
clearInterval(checkInterval);
callback();
}, 30000);
}
// =================================================================
// Block 4: Tour Definition
// =================================================================
function startTour() {
// Prevents double Start // Prevents double Start
if (onboardingStarted) return; if (onboardingStarted) return;
onboardingStarted = true; onboardingStarted = true;
const mobile = isMobile();
const tour = new Shepherd.Tour({ const tour = new Shepherd.Tour({
useModalOverlay: true, useModalOverlay: !mobile,
defaultStepOptions: { defaultStepOptions: {
cancelIcon: { enabled: true }, cancelIcon: { enabled: false },
scrollTo: false, scrollTo: false,
classes: 'onboarding-step', classes: 'onboarding-step',
popperOptions: { popperOptions: {
@@ -89,46 +44,54 @@ function startTour() {
}); });
// -----------------------------------------------------------------
// Step 1: Welcome — Skip Timer at automatic Start
// ----------------------------------------------------------------- // -----------------------------------------------------------------
// Step 1: Welcome var welcomeButtons = [
// ----------------------------------------------------------------- {
text: 'Überspringen',
action: tour.cancel,
classes: 'shepherd-button-secondary' + (manual ? '' : ' skip-btn-locked')
},
{
text: 'Los geht\'s <i class="fa-solid fa-arrow-right"></i>',
action: tour.next,
classes: 'shepherd-button-primary'
}
];
tour.addStep({ tour.addStep({
id: 'welcome', id: 'welcome',
title: '<i class="fa-solid fa-hand-wave"></i> Wilkommen bei der Mitmachkarte!', title: '<i class="fa-solid fa-hand-wave"></i> Willkommen bei der Mitmachkarte!',
text: 'Dieses interaktive Tutorial zeigt Ihnen die Kernfunktionen der Mitmachkarte.' + text: 'Dieses <strong>interaktive Tutorial</strong> zeigt Ihnen die Kernfunktionen der Mitmachkarte.' +
'<br><br><span style="font-size:0.8rem;color:var(--color-text-secondary);">Sie können das Tutorial jederzeit durch den Hilfe-Tab der Seitenleiste wiederholen.</span>', '<br><br><span style="color:var(--color-text-secondary);">Sie können das Tutorial jederzeit über den Hilfe-Tab der Seitenleiste wiederholen.</span>',
buttons: [ buttons: welcomeButtons,
{ when: {
text: 'Überspringen', show: function () {
action: tour.cancel, if (manual) return;
classes: 'shepherd-button-secondary'
}, // Locks Skip Button with Progress Bar for 5 Seconds
{ var skipBtn = document.querySelector('.skip-btn-locked');
text: 'Los geht\'s <i class="fa-solid fa-arrow-right"></i>', if (!skipBtn) return;
action: tour.next, skipBtn.disabled = true;
classes: 'shepherd-button-primary' skipBtn.style.pointerEvents = 'none';
setTimeout(function () {
skipBtn.disabled = false;
skipBtn.style.pointerEvents = '';
skipBtn.classList.remove('skip-btn-locked');
}, 5000);
} }
] }
}); });
// ----------------------------------------------------------------- // -----------------------------------------------------------------
// Step 2: Drawing Tools // Step 2: Drawing Tools
// ----------------------------------------------------------------- // -----------------------------------------------------------------
tour.addStep({ var drawingStep = {
id: 'drawing-tools', id: 'drawing-tools',
title: '<i class="fa-solid fa-pencil"></i> Beitrag hinzufügen', title: '<i class="fa-solid fa-pencil"></i> Beitrag hinzufügen',
text: 'Verwenden Sie die <strong>Zeichenwerkzeuge</strong>, um Hinweise, Anregungen und Vorschläge auf der Mitmachkarte als Punkte, Linien oder Flächen hinzuzufügen.',
attachTo: {
element: '.leaflet-pm-toolbar',
on: 'left'
},
beforeShowPromise: function () {
return new Promise(function (resolve) {
sidebar.close();
setTimeout(resolve, 300);
});
},
buttons: [ buttons: [
{ {
text: '<i class="fa-solid fa-arrow-left"></i> Zurück', text: '<i class="fa-solid fa-arrow-left"></i> Zurück',
@@ -141,20 +104,32 @@ function startTour() {
classes: 'shepherd-button-primary' classes: 'shepherd-button-primary'
} }
] ]
}); };
if (mobile) {
drawingStep.text = 'Verwenden Sie die <strong>Zeichenwerkzeuge</strong> ' +
'<i class="fa-solid fa-location-dot"></i> ' +
'rechts, um Hinweise als Punkte, Linien oder Flächen hinzuzufügen.';
} else {
drawingStep.text = 'Verwenden Sie die <strong>Zeichenwerkzeuge</strong>, um Hinweise, Anregungen und Vorschläge auf der Mitmachkarte als Punkte, Linien oder Flächen hinzuzufügen.';
drawingStep.attachTo = { element: '.leaflet-pm-toolbar', on: 'left' };
drawingStep.beforeShowPromise = function () {
return new Promise(function (resolve) {
sidebar.close();
setTimeout(resolve, 300);
});
};
}
tour.addStep(drawingStep);
// ----------------------------------------------------------------- // -----------------------------------------------------------------
// Step 3: Address Search // Step 3: Address Search
// ----------------------------------------------------------------- // -----------------------------------------------------------------
tour.addStep({ var searchStep = {
id: 'address-search', id: 'address-search',
title: '<i class="fa-solid fa-magnifying-glass"></i> Adresssuche', title: '<i class="fa-solid fa-magnifying-glass"></i> Adresssuche',
text: 'Verwenden Sie die <strong>Adresssuche</strong>, um schnell den richtigen Ort auf der Mitmachkarte zu finden.',
attachTo: {
element: '.leaflet-control-geocoder',
on: 'left'
},
buttons: [ buttons: [
{ {
text: '<i class="fa-solid fa-arrow-left"></i> Zurück', text: '<i class="fa-solid fa-arrow-left"></i> Zurück',
@@ -167,20 +142,25 @@ function startTour() {
classes: 'shepherd-button-primary' classes: 'shepherd-button-primary'
} }
] ]
}); };
if (mobile) {
searchStep.text = 'Verwenden Sie die <strong>Adresssuche</strong> ' +
'<i class="fa-solid fa-magnifying-glass"></i> rechts, um schnell den richtigen Ort auf der Mitmachkarte zu finden.';
} else {
searchStep.text = 'Verwenden Sie die <strong>Adresssuche</strong>, um schnell den richtigen Ort auf der Mitmachkarte zu finden.';
searchStep.attachTo = { element: '.leaflet-control-geocoder', on: 'left' };
}
tour.addStep(searchStep);
// ----------------------------------------------------------------- // -----------------------------------------------------------------
// Step 4: Layer Control // Step 4: Layer Control
// ----------------------------------------------------------------- // -----------------------------------------------------------------
tour.addStep({ var layerStep = {
id: 'layer-control', id: 'layer-control',
title: '<i class="fa-solid fa-layer-group"></i> Kartenansicht', title: '<i class="fa-solid fa-layer-group"></i> Kartenansicht',
text: 'Wechseln Sie zwischen verschiedenen <strong>Hintergrundkarten</strong> und <strong>Satellitenbildern</strong>.',
attachTo: {
element: '.leaflet-control-layers',
on: 'left'
},
buttons: [ buttons: [
{ {
text: '<i class="fa-solid fa-arrow-left"></i> Zurück', text: '<i class="fa-solid fa-arrow-left"></i> Zurück',
@@ -193,26 +173,25 @@ function startTour() {
classes: 'shepherd-button-primary' classes: 'shepherd-button-primary'
} }
] ]
}); };
if (mobile) {
layerStep.text = 'Wechseln Sie über das <strong>Layer-Symbol</strong> ' +
'<i class="fa-solid fa-layer-group"></i> oben rechts zwischen verschiedenen Hintergrundkarten und Satellitenbildern.';
} else {
layerStep.text = 'Wechseln Sie zwischen verschiedenen <strong>Hintergrundkarten</strong> und <strong>Satellitenbildern</strong>.';
layerStep.attachTo = { element: '.leaflet-control-layers', on: 'left' };
}
tour.addStep(layerStep);
// ----------------------------------------------------------------- // -----------------------------------------------------------------
// Step 5: Sidebar // Step 5: Sidebar
// ----------------------------------------------------------------- // -----------------------------------------------------------------
tour.addStep({ var sidebarStep = {
id: 'sidebar', id: 'sidebar',
title: '<i class="fa-solid fa-bars"></i> Seitenleiste', title: '<i class="fa-solid fa-bars"></i> Seitenleiste',
text: 'In der Seitenleiste finden Sie <strong>Hilfestellungen</strong>, <strong>Listenansichten</strong> und <strong>Neuigkeiten</strong>.',
attachTo: {
element: '#sidebar',
on: 'right'
},
beforeShowPromise: function () {
return new Promise(function (resolve) {
sidebar.open('tab-help');
setTimeout(resolve, 400);
});
},
buttons: [ buttons: [
{ {
text: '<i class="fa-solid fa-arrow-left"></i> Zurück', text: '<i class="fa-solid fa-arrow-left"></i> Zurück',
@@ -220,58 +199,106 @@ function startTour() {
classes: 'shepherd-button-secondary' classes: 'shepherd-button-secondary'
}, },
{ {
text: 'Tutorial abschließen <i class="fa-solid fa-check"></i>', text: 'Abschließen <i class="fa-solid fa-check"></i>',
action: tour.next, action: tour.next,
classes: 'shepherd-button-primary' classes: 'shepherd-button-primary'
} }
] ]
}); };
if (mobile) {
sidebarStep.text = 'In der <strong>Seitenleiste</strong> ' +
'<i class="fa-solid fa-house"></i> ' +
'links finden Sie Hilfestellungen, Listenansichten und Neuigkeiten.';
} else {
sidebarStep.text = 'In der <strong>Seitenleiste</strong> finden Sie Hilfestellungen, Listenansichten und Neuigkeiten.';
sidebarStep.attachTo = { element: '#sidebar', on: 'right' };
sidebarStep.beforeShowPromise = function () {
return new Promise(function (resolve) {
sidebar.open('tab-help');
setTimeout(resolve, 400);
});
};
}
tour.addStep(sidebarStep);
// ----------------------------------------------------------------- // -----------------------------------------------------------------
// Completion and Cancellation // Completion and Cancellation — shows Drawing Arrow
// ----------------------------------------------------------------- // -----------------------------------------------------------------
tour.on('complete', function () { function onTourEnd() {
markOnboardingDone();
onboardingStarted = false; onboardingStarted = false;
}); if (mobile) sidebar.close();
tour.on('cancel', function () { // Shows Arrow Hint
markOnboardingDone(); if (!localStorage.getItem('webgis_onboarding_done')) {
onboardingStarted = false; localStorage.setItem('webgis_onboarding_done', 'true');
}); showDrawingArrow();
}
}
tour.on('complete', onTourEnd);
tour.on('cancel', onTourEnd);
tour.start(); tour.start();
} }
// ================================================================= // =================================================================
// Marks Onboarding as completed // Drawing Arrow — Points to Geoman Toolbar after Tour
// ================================================================= // =================================================================
function markOnboardingDone() { function showDrawingArrow() {
if (ONBOARDING_MODE === 'once') { var hint = document.createElement('div');
localStorage.setItem('webgis_onboarding_done', 'true'); hint.id = 'drawing-hint-arrow';
} else if (ONBOARDING_MODE === 'session') { hint.innerHTML = '<span class="drawing-hint-label">' +
sessionStorage.setItem('webgis_onboarding_done', 'true'); '<i class="fa-solid fa-pencil"></i> Beitrag hinzufügen' +
'</span>' +
'<span class="drawing-hint-chevrons">' +
'<i class="fa-solid fa-chevron-right"></i>' +
'<i class="fa-solid fa-chevron-right"></i>' +
'</span>';
document.body.appendChild(hint);
// Positions Hint centered on Geoman Toolbar
function positionHint() {
var toolbar = document.querySelector('.leaflet-pm-toolbar');
if (!toolbar) { removeDrawingArrow(); return; }
var rect = toolbar.getBoundingClientRect();
var hintHeight = hint.offsetHeight || 32;
hint.style.top = (rect.top + (rect.height / 2) - (hintHeight / 2)) + 'px';
hint.style.right = (window.innerWidth - rect.left + 10) + 'px';
}
positionHint();
window.addEventListener('resize', positionHint);
var timeout = setTimeout(removeDrawingArrow, 60000);
map.on('pm:globaldrawmodetoggled', function onDraw() {
clearTimeout(timeout);
removeDrawingArrow();
map.off('pm:globaldrawmodetoggled', onDraw);
window.removeEventListener('resize', positionHint);
});
}
function removeDrawingArrow() {
var arrow = document.getElementById('drawing-hint-arrow');
if (arrow) {
arrow.classList.add('fade-out');
setTimeout(function () { arrow.remove(); }, 300);
} }
} }
// ================================================================= // =================================================================
// Manual Tour Restart // Manual Tour Restart (from Info Modal or Help Tab)
// ================================================================= // =================================================================
function restartOnboarding() { function restartOnboarding() {
localStorage.removeItem('webgis_onboarding_done');
sessionStorage.removeItem('webgis_onboarding_done');
onboardingStarted = false; onboardingStarted = false;
startTour(); startTour(true);
} }
// =================================================================
// Auto-Start on Page Load
// =================================================================
initOnboardingTour();

View File

@@ -263,6 +263,10 @@ select.form-input { cursor: pointer; }
font-family: var(--font-body) !important; font-family: var(--font-body) !important;
} }
.swal2-container {
z-index: 3000 !important;
}
/* ----------------------------------------------------------------- /* -----------------------------------------------------------------
3.7 Warning Notices 3.7 Warning Notices
@@ -431,6 +435,69 @@ select.form-input { cursor: pointer; }
border-radius: 4px; border-radius: 4px;
} }
/* Layer Control Expanded Dropdown */
.leaflet-control-layers-expanded {
padding: 0 !important;
background: var(--color-surface) !important;
font-family: var(--font-body) !important;
border-radius: 10px !important;
box-shadow: 0 4px 16px rgba(0, 0, 0, 0.15) !important;
border: 1px solid var(--color-border) !important;
min-width: 220px;
}
.leaflet-control-layers-list {
padding: 8px 0;
}
.leaflet-control-layers-separator {
border-top: 1px solid var(--color-border) !important;
margin: 4px 12px !important;
}
.leaflet-control-layers label {
display: flex !important;
align-items: center !important;
gap: 8px !important;
padding: 8px 16px !important;
margin: 0 !important;
cursor: pointer !important;
font-size: 0.83rem !important;
color: var(--color-text) !important;
transition: background var(--transition-fast);
}
.leaflet-control-layers label:hover {
background: var(--color-bg) !important;
}
.leaflet-control-layers input[type="radio"],
.leaflet-control-layers input[type="checkbox"] {
accent-color: var(--color-primary);
width: 16px;
height: 16px;
cursor: pointer;
flex-shrink: 0;
}
/* Layer Control Header — only visible when expanded */
.layer-control-header {
background: var(--color-primary);
color: white;
font-family: var(--font-body);
font-size: 0.85rem;
font-weight: 600;
padding: 10px 16px;
display: none;
align-items: center;
gap: 8px;
border-radius: 10px 10px 0 0;
}
.leaflet-control-layers-expanded .layer-control-header {
display: flex;
}
/* ----------------------------------------------------------------- /* -----------------------------------------------------------------
4.3 Sidebar Overrides 4.3 Sidebar Overrides
@@ -464,6 +531,7 @@ select.form-input { cursor: pointer; }
margin-bottom: var(--space-sm); margin-bottom: var(--space-sm);
line-height: 1.5; line-height: 1.5;
color: var(--color-text-secondary); color: var(--color-text-secondary);
font-size: 0.85rem;
} }
@@ -694,8 +762,6 @@ select.form-input { cursor: pointer; }
} }
.popup-comments-list { .popup-comments-list {
max-height: 150px;
overflow-y: auto;
margin-top: var(--space-sm); margin-top: var(--space-sm);
} }
@@ -874,6 +940,97 @@ select.form-input { cursor: pointer; }
transform: translate(-50%, -50%) !important; transform: translate(-50%, -50%) !important;
} }
/* -----------------------------------------------------------------
4.10 Skip Button Progress Bar (Onboarding)
----------------------------------------------------------------- */
.skip-btn-locked {
position: relative;
overflow: hidden;
opacity: 0.6;
}
.skip-btn-locked::after {
content: '';
position: absolute;
top: 0;
left: 0;
height: 100%;
width: 0%;
background: rgba(0, 0, 0, 0.12);
border-radius: 6px;
animation: skip-fill 5s linear forwards;
pointer-events: none;
}
@keyframes skip-fill {
from { width: 0%; }
to { width: 100%; opacity: 0; }
}
/* -----------------------------------------------------------------
4.11 Drawing Hint Arrow after Onboarding
----------------------------------------------------------------- */
#drawing-hint-arrow {
position: fixed;
z-index: 1500;
display: flex;
align-items: center;
gap: 4px;
pointer-events: none;
animation: hint-fade-in 400ms ease;
transition: opacity 300ms ease;
}
#drawing-hint-arrow.fade-out {
opacity: 0;
}
.drawing-hint-label {
background: var(--color-primary);
color: white;
font-family: var(--font-body);
font-size: 0.78rem;
font-weight: 600;
padding: 6px 14px;
border-radius: 20px;
white-space: nowrap;
box-shadow: 0 2px 10px rgba(0, 0, 0, 0.2);
display: flex;
align-items: center;
gap: 6px;
}
.drawing-hint-chevrons {
display: flex;
gap: 0;
color: var(--color-primary);
font-size: 1.2rem;
font-weight: 900;
filter: drop-shadow(0 1px 3px rgba(0, 0, 0, 0.2));
}
.drawing-hint-chevrons i:nth-child(1) {
animation: chevron-pulse 1.2s ease-in-out infinite;
opacity: 0.4;
}
.drawing-hint-chevrons i:nth-child(2) {
animation: chevron-pulse 1.2s ease-in-out 0.3s infinite;
opacity: 0.7;
}
@keyframes chevron-pulse {
0%, 100% { transform: translateX(0); opacity: 0.3; }
50% { transform: translateX(3px); opacity: 1; }
}
@keyframes hint-fade-in {
from { opacity: 0; transform: translateX(-10px); }
to { opacity: 1; transform: translateX(0); }
}
/* Mobile */ /* Mobile */
@media (max-width: 768px) { @media (max-width: 768px) {
.shepherd-element { max-width: 300px !important; } .shepherd-element { max-width: 300px !important; }
@@ -881,72 +1038,6 @@ select.form-input { cursor: pointer; }
} }
/* -----------------------------------------------------------------
4.10 Create Type Toggle (Contribution or Task)
----------------------------------------------------------------- */
.create-type-toggle {
display: flex;
gap: 8px;
}
.create-type-btn {
flex: 1;
padding: 10px;
border: 2px solid var(--color-border);
border-radius: 8px;
background: var(--color-surface);
cursor: pointer;
font-family: var(--font-body);
font-size: 0.85rem;
font-weight: 600;
color: var(--color-text-secondary);
transition: all var(--transition-fast);
display: flex;
align-items: center;
justify-content: center;
gap: 6px;
}
.create-type-btn:hover { border-color: var(--color-primary); color: var(--color-primary); }
.create-type-btn.active { border-color: var(--color-primary); background: var(--color-primary-light); color: var(--color-primary); }
/* -----------------------------------------------------------------
4.11 Leaderboard (Sidebar Tasks Tab)
----------------------------------------------------------------- */
.leaderboard-box {
background: var(--color-surface);
border: 1px solid var(--color-border);
border-radius: 8px;
padding: var(--space-md);
margin-bottom: var(--space-md);
}
.leaderboard-box h3 { margin-top: 0 !important; }
.leaderboard-entry {
display: flex;
align-items: center;
gap: var(--space-sm);
padding: 6px 0;
font-size: 0.85rem;
border-bottom: 1px solid #f0f0f0;
}
.leaderboard-entry:last-child { border-bottom: none; }
.leaderboard-rank { font-size: 1rem; width: 28px; text-align: center; }
.leaderboard-name { flex: 1; font-weight: 600; }
.leaderboard-points { color: var(--color-primary); font-weight: 600; }
.leaderboard-more-btn {
width: 100%;
margin-top: var(--space-sm);
font-size: 0.8rem !important;
min-height: 32px !important;
padding: 4px 12px !important;
}
/* ================================================================= /* =================================================================
SECTION 5: Admin-specific Styles (admin.php) SECTION 5: Admin-specific Styles (admin.php)
================================================================= */ ================================================================= */
@@ -1314,8 +1405,60 @@ select.form-input { cursor: pointer; }
/* Legal */ /* Legal */
.page-content-box { padding: 20px; } .page-content-box { padding: 20px; }
.page-container { padding: 0 8px; } .page-container { padding: 0 8px; }
/* ---------------------------------------------------------
6.1 Prevents iOS Auto-Zoom on Inputs
--------------------------------------------------------- */
input, textarea, select {
font-size: 16px !important;
}
/* ---------------------------------------------------------
6.2 Popup Content Height Limit on Mobile
--------------------------------------------------------- */
.leaflet-popup-content {
max-height: 50vh;
max-width: 33vh;
overflow-y: auto;
}
/* ---------------------------------------------------------
6.3 Removes Admin Button Offset in Hambueger Menu
--------------------------------------------------------- */
.nav-btn-admin {
margin-left: 0;
}
.header-nav.open .nav-btn {
width: 100%;
justify-content: flex-start;
}
/* ---------------------------------------------------------
6.4 Larger Popup Close Button for Touch
--------------------------------------------------------- */
.leaflet-popup-close-button {
font-size: 22px !important;
width: 30px !important;
height: 30px !important;
display: flex !important;
align-items: center;
justify-content: center;
padding: 0 !important;
right: 4px !important;
top: 4px !important;
}
} }
@media (min-width: 769px) { @media (min-width: 769px) {
:root { --map-side-padding: 8px; } :root { --map-side-padding: 8px; }
} }