X-Git-Url: https://git.bts.cx/cx.git/blobdiff_plain/6e68608aecb6a542b9c75a13afd5002aeb7bc0f1..refs/heads/mainline:/cx/lib/posts.php?ds=inline diff --git a/cx/lib/posts.php b/cx/lib/posts.php index d07f999..7b13166 100644 --- a/cx/lib/posts.php +++ b/cx/lib/posts.php @@ -2,12 +2,16 @@ cx_require('lib', 'db.php'); cx_require('lib', 'setup.php'); -cx_require('third_party', 'parsedown', 'Parsedown.php'); +cx_require('lib', 'markdown.php'); -function mk_markdown($markdown) { - static $Parsedown = new Parsedown(); +class PostMetadata { + public $hero_image; + public $hero_image_alt; - return $Parsedown->text($markdown); + public function __construct($dict) { + $this->hero_image = isset($dict['post_hero_image']) ? $dict['post_hero_image'] : null; + $this->hero_image_alt = isset($dict['post_hero_image_alt']) ? $dict['post_hero_image_alt'] : null; + } } class Post { @@ -15,6 +19,7 @@ class Post { public $title; public $slug; public $date; + public $is_draft; public $data; public $html_content; public $html_excerpt; @@ -24,15 +29,32 @@ class Post { $this->title = $dict['post_title']; $this->slug = $dict['post_slug']; $this->date = $dict['post_date']; + $this->is_draft = $dict['post_is_draft']; $this->data = $dict['post_data']; - $this->html_content = mk_markdown($this->data); + $this->html_content = cx_markdown_generate_html($this->data); $this->html_excerpt = null; // Read more... $segments = explode('---', $this->data, 2); if (count($segments) > 1) { - $this->html_excerpt = mk_markdown($segments[0]); + $this->html_excerpt = cx_markdown_generate_html($segments[0]); + } + } + + public function get_metadata() { + $data = []; + + $doc = new DOMDocument(); + $doc->loadHTML($this->html_content); + + $image_tag = $doc->getElementsByTagName('img')[0]; + + if ($image_tag != null) { + $data['post_hero_image'] = $image_tag->getAttribute('src'); + $data['post_hero_image_alt'] = htmlspecialchars($image_tag->getAttribute('alt')); } + + return new PostMetadata($data); } } @@ -49,7 +71,7 @@ function cx_post_make_slug($title) { return $slug; } -function cx_posts_add_post($site_id, $title, $slug, $date, $data) { +function cx_posts_add_post($site_id, $title, $slug, $date, $draft, $data) { $creation_time = $update_time = time(); if ($slug == null) { @@ -67,14 +89,15 @@ function cx_posts_add_post($site_id, $title, $slug, $date, $data) { post_slug, post_date, post_is_page, + post_is_draft, post_title, post_data, post_data_version) - VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?);'; - cx_db_exec($sql, $site_id, $creation_time, $update_time, $slug, $date, false, $title, $data, 1); + VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);'; + cx_db_exec($sql, $site_id, $creation_time, $update_time, $slug, $date, false, $draft, $title, $data, 1); } -function cx_posts_update_post($post_id, $title, $slug, $date, $data) { +function cx_posts_update_post($post_id, $title, $slug, $date, $draft, $data) { $update_time = time(); if ($slug == null) { @@ -89,11 +112,12 @@ function cx_posts_update_post($post_id, $title, $slug, $date, $data) { SET post_update_time = ?, post_slug = ?, post_date = ?, + post_is_draft = ?, post_title = ?, post_data = ? WHERE post_id == ?;'; //LIMIT 1;'; - cx_db_exec($sql, $update_time, $slug, $date , $title, $data, $post_id); + cx_db_exec($sql, $update_time, $slug, $date, $draft, $title, $data, $post_id); } function cx_posts_delete_post($post_id) { @@ -103,20 +127,30 @@ function cx_posts_delete_post($post_id) { cx_db_exec($sql, $post_id); } -function cx_posts_get(int $limit = 0) { +function cx_posts_get(int $limit = 0, int $offset = 0, bool $include_drafts = false) { $sql = 'SELECT post_id, post_slug, post_date, + post_is_draft, post_title, post_data FROM posts - WHERE post_is_page==FALSE - ORDER BY post_date DESC'; + WHERE post_is_page == FALSE'; + + if ($include_drafts == false) { + $sql .= ' AND post_is_draft == FALSE'; + } + + $sql .= ' ORDER BY post_date DESC'; if ($limit > 0) { $sql .= ' LIMIT ' . $limit; } + + if ($offset > 0) { + $sql .= ' OFFSET ' . $offset; + } $sql .= ';'; @@ -131,6 +165,7 @@ function cx_posts_find_post($post_id) { post_id, post_slug, post_date, + post_is_draft, post_title, post_data FROM posts @@ -165,10 +200,12 @@ function cx_pages_get() { post_id, post_slug, post_date, + post_is_draft, post_title, post_data FROM posts WHERE post_is_page == TRUE + AND post_is_draft == FALSE ORDER BY post_creation_time DESC;'; foreach (cx_db_query($sql) as $post) { @@ -186,6 +223,7 @@ cx_setup_register(1, function() { post_slug STRING, post_date INTEGER, post_is_page BOOLEAN, + post_is_draft BOOLEAN, post_title STRING, post_data BLOB, post_data_version INTEGER,