API::api_get_headlines()

Complexity

Conditions	26
Paths	12

Size

Total Lines	162
Code Lines	99

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public static function api_get_headlines($feed_id, $limit, $offset,
                $filter, $is_cat, $show_excerpt, $show_content, $view_mode, $order,
                $include_attachments, $since_id,
                $search = "", $include_nested = false, $sanitize_content = true,
                $force_update = false, $excerpt_length = 100, $check_first_id = false, $skip_first_id_check = false) {

            $pdo = Db::pdo();

            if ($force_update && $feed_id > 0 && is_numeric($feed_id)) {
                // Update the feed if required with some basic flood control

                $sth = $pdo->prepare(
                    "SELECT cache_images,".SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated
						FROM ttrss_feeds WHERE id = ?");
                $sth->execute([$feed_id]);

                if ($row = $sth->fetch()) {
                    $last_updated = strtotime($row["last_updated"]);
                    $cache_images = API::param_to_bool($row["cache_images"]);

                    if (!$cache_images && time() - $last_updated > 120) {
                        RSSUtils::update_rss_feed($feed_id, true);
                    } else {
                        $sth = $pdo->prepare("UPDATE ttrss_feeds SET last_updated = '1970-01-01', last_update_started = '1970-01-01'
							WHERE id = ?");
                        $sth->execute([$feed_id]);
                    }
                }
            }

            $params = array(
                "feed" => $feed_id,
                "limit" => $limit,
                "view_mode" => $view_mode,
                "cat_view" => $is_cat,
                "search" => $search,
                "override_order" => $order,
                "offset" => $offset,
                "since_id" => $since_id,
                "include_children" => $include_nested,
                "check_first_id" => $check_first_id,
                "skip_first_id_check" => $skip_first_id_check
            );

            $qfh_ret = Feeds::queryFeedHeadlines($params);

            $result = $qfh_ret[0];
            $feed_title = $qfh_ret[1];
            $first_id = $qfh_ret[6];

            $headlines = array();

            $headlines_header = array(
                'id' => $feed_id,
                'first_id' => $first_id,
                'is_cat' => $is_cat);

            if (!is_numeric($result)) {
                while ($line = $result->fetch()) {
                    $line["content_preview"] = truncate_string(strip_tags($line["content"]), $excerpt_length);
                    foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_QUERY_HEADLINES) as $p) {
                        $line = $p->hook_query_headlines($line, $excerpt_length, true);
                    }

                    $is_updated = ($line["last_read"] == "" &&
                        ($line["unread"] != "t" && $line["unread"] != "1"));

                    $tags = explode(",", $line["tag_cache"]);

                    $label_cache = $line["label_cache"];
                    $labels = false;

                    if ($label_cache) {
                        $label_cache = json_decode($label_cache, true);

                        if ($label_cache) {
                            if ($label_cache["no-labels"] == 1) {
                                                            $labels = array();
                            } else {
                                                            $labels = $label_cache;
                            }
                        }
                    }

                    if (!is_array($labels)) {
                        $labels = Article::get_article_labels($line["id"]);
                    }

                    $headline_row = array(
                        "id" => (int) $line["id"],
                        "guid" => $line["guid"],
                        "unread" => API::param_to_bool($line["unread"]),
                        "marked" => API::param_to_bool($line["marked"]),
                        "published" => API::param_to_bool($line["published"]),
                        "updated" => (int) strtotime($line["updated"]),
                        "is_updated" => $is_updated,
                        "title" => $line["title"],
                        "link" => $line["link"],
                        "feed_id" => $line["feed_id"] ? $line['feed_id'] : 0,
                        "tags" => $tags,
                    );

                    $enclosures = Article::get_article_enclosures($line['id']);

                    if ($include_attachments) {
                                            $headline_row['attachments'] = $enclosures;
                    }

                    if ($show_excerpt) {
                                            $headline_row["excerpt"] = $line["content_preview"];
                    }

                    if ($show_content) {

                        if ($sanitize_content) {
                            $headline_row["content"] = sanitize(
                                $line["content"],
                                API::param_to_bool($line['hide_images']),
                                false, $line["site_url"], false, $line["id"]);
                        } else {
                            $headline_row["content"] = $line["content"];
                        }
                    }

                    // unify label output to ease parsing
                    if ($labels["no-labels"] == 1) {
                        $labels = array();
                    }

                    $headline_row["labels"] = $labels;

                    $headline_row["feed_title"] = $line["feed_title"] ? $line["feed_title"] : $feed_title;

                    $headline_row["comments_count"] = (int) $line["num_comments"];
                    $headline_row["comments_link"] = $line["comments"];

                    $headline_row["always_display_attachments"] = API::param_to_bool($line["always_display_enclosures"]);

                    $headline_row["author"] = $line["author"];

                    $headline_row["score"] = (int) $line["score"];
                    $headline_row["note"] = $line["note"];
                    $headline_row["lang"] = $line["lang"];

                    foreach (PluginHost::getInstance()->get_hooks(PluginHost::HOOK_RENDER_ARTICLE_API) as $p) {
                        $headline_row = $p->hook_render_article_api(array("headline" => $headline_row));
                    }

                    $headline_row["content"] = DiskCache::rewriteUrls($headline_row['content']);

                    list ($flavor_image, $flavor_stream) = Article::get_article_image($enclosures, $line["content"], $line["site_url"]);

                    $headline_row["flavor_image"] = $flavor_image;
                    $headline_row["flavor_stream"] = $flavor_stream;

                    array_push($headlines, $headline_row);
                }
            } else if (is_numeric($result) && $result == -1) {
                $headlines_header['first_id_changed'] = true;
            }

            return array($headlines, $headlines_header);
    }