issue: reply option to mark announced publication

Can be unchecked to decrease message visibility.

diff --git a/database.inc.php b/database.inc.php
index b2244b9b0d52db65c180051ec2c24d89edcb27d1..9b65ce6926defaf54b1080ab99db43fc71b9778e 100644 (file)
--- a/database.inc.php
+++ b/database.inc.php
@@ -29,6 +29,9 @@ class DB
                        $params = array_merge($params, $val);
                        return $sql;
                }
                        $params = array_merge($params, $val);
                        return $sql;
                }

+               elseif (is_bool($val)) {
+                       return $val ? 'TRUE' : 'FALSE';
+               }

 
                $params[] = $val;
                return '?';
 
                $params[] = $val;
                return '?';

diff --git a/upload.inc.php b/upload.inc.php
index d87fa2d8f4e3bbcb9d14de3debe11ef970eebe6f..ff4ecd3755aaa7ba695b098ebf78b48187bd9261 100644 (file)
--- a/upload.inc.php
+++ b/upload.inc.php
@@ -84,6 +84,9 @@ function createcomment($input, &$Issue = NULL)
                $reply['raw'] = $body;
                $reply['message'] = messagehtml($body);
        }
                $reply['raw'] = $body;
                $reply['message'] = messagehtml($body);
        }

+       if (isset($input['announce'])) {
+               $reply['announced'] = !!$input['announce'];
+       }

        if ($_FILES and !empty($_FILES['image'])) {
                $target = 'data/upload';
                if (!file_exists($target)) {
        if ($_FILES and !empty($_FILES['image'])) {
                $target = 'data/upload';
                if (!file_exists($target)) {

diff --git a/widget/comments.sql b/widget/comments.sql
index b805a2a33a6fdd89082ddebf6889560b4cffbd34..fc261f82ae0c41f7ffd0416610876e5dfdd40cc0 100644 (file)
--- a/widget/comments.sql
+++ b/widget/comments.sql
@@ -14,6 +14,7 @@ CREATE TABLE comments (
        page       text,
        raw        text,
        message    text,
        page       text,
        raw        text,
        message    text,

+       announced  boolean     NOT NULL DEFAULT TRUE,

        created    timestamptz DEFAULT now(),
        author     text,
        id         serial      NOT NULL PRIMARY KEY
        created    timestamptz DEFAULT now(),
        author     text,
        id         serial      NOT NULL PRIMARY KEY

diff --git a/widget/reply.php b/widget/reply.php
index b740c2a5276722aa8bba0f6482a263af65a7b272..010b1de4dcb90e9e1c0179a7e9da608797917b0e 100644 (file)
--- a/widget/reply.php
+++ b/widget/reply.php
@@ -88,6 +88,21 @@ if ($User->login) {
                );
                print "</p>\n";
        }
                );
                print "</p>\n";
        }

+       {
+               print '<p>';
+               printf(
+                       '<input type="hidden" name="%s" value="" />'
+                       . "Geplaatste berichten zijn hier direct zichtbaar voor bewoners.\n"
+                       . '<input type="checkbox" id="%1$s" name="%1$s" value="%s"%s%s />'
+                       . '<label for="%1$s"> %s</label>'."\n",
+                       'announce',
+                       '1',
+                       ($_POST['announce'] ?? TRUE) ? ' checked' : '',
+                       ' onclick="this.nextSibling.hidden = !this.checked"',
+                       "De eerste regel wordt ook weergegeven op het scherm in de hal."
+               );
+               print "</p>\n";
+       }

        if (isset($Issue)) {
                printf(
                        '<p><label for="%s">%s:</label> '
        if (isset($Issue)) {
                printf(
                        '<p><label for="%s">%s:</label> '