{% extends theme/category.html %}

{% block title %} {{ $category['name'] }} - Browsing Category page {% endblock %}

{% block navigation %}
<ul class="navbar-nav">
	<li class="nav-item">
		<a href="{{ $basehost }}" class="nav-link {% if(!$currentCategory) { %}active{% } %}">
			Home
		</a>
	</li>
	{%
		$categoriesQuery = $db->query("SELECT * FROM `categories` ORDER BY `order` ASC");
		while($categoryNav = $categoriesQuery -> fetchArray(SQLITE3_ASSOC)){
	%}
	<li class="nav-item">
		<a href="{{ $basehost }}/{{ $categoryNav['slug'] }}/" class="nav-link {% if($currentCategory == $categoryNav['slug']) { %}active{% } %}">
			{{ $categoryNav['name'] }}
		</a>
	</li>
	{%
		}
	%}
</ul>
{% endblock %}

{% block categoryname %} {{ $category['name'] }} {% endblock %}

{% block content %}
{%
	$articleCounter = 0;
	$categoryArticlesQuery = $db->query("select articles.id, articles.category_id, articles.slug as slug, articles.title as title, articles.excerpt as excerpt, articles.image as image, articles.created as created, authors.name as authorname, authors.linkedin as linkedin, authors.slug as authorslug, categories.name as category_name, categories.slug as category_slug from articles, authors, categories where articles.author_id = authors.id and articles.category_id = categories.id and articles.category_id = " . $category["id"] . " ORDER BY articles.created DESC");
	
		while($categoryArticle = $categoryArticlesQuery -> fetchArray(SQLITE3_ASSOC)){
		$articleCounter++;
%}

{%
	if($articleCounter <= 4){
%}

<!-- first 4 -->
<div class="col-lg-6">
	<div class="single-overview-news">
		<div class="overview-news-image">
			<a href="{{ $basehost }}/{{ $categoryArticle['category_slug'] }}/{{ $categoryArticle['slug'] }}.html">
				<img src="{{ $basehost }}/data/images/thumb-610-{{ $categoryArticle["image"] }}" alt="image">
			</a>
		</div>

		<div class="overview-news-content">
			<span>{{ $categoryArticle['category_name'] }}</span>
			<h3>
				<a href="{{ $basehost }}/{{ $categoryArticle['category_slug'] }}/{{ $categoryArticle['slug'] }}.html">{{ $categoryArticle['title'] }}</a>
			</h3>
			<p><a href="{{ $basehost }}/author/{{ $categoryArticle['authorslug'] }}/">{{ $categoryArticle['authorname'] }}</a> / {{ date("d F, Y", strtotime($categoryArticle['created'])) }}</p>
		</div>
	</div>
</div>
<!-- first 4 -->

{%
	} else {
%}

<!-- not first 4 -->
<div class="single-overview-news">
	<div class="row align-items-center">
		<div class="col-lg-4">
			<div class="overview-news-image">
				<a href="{{ $basehost }}/{{ $categoryArticle['category_slug'] }}/{{ $categoryArticle['slug'] }}.html">
					<img src="{{ $basehost }}/data/images/thumb-610-{{ $categoryArticle["image"] }}" alt="image">
				</a>
			</div>
		</div>

		<div class="col-lg-8">
			<div class="overview-news-content mt-0">
				<span>{{ $categoryArticle['category_name'] }}</span>
				<h3>
					<a href="{{ $basehost }}/{{ $categoryArticle['category_slug'] }}/{{ $categoryArticle['slug'] }}.html">{{ $categoryArticle['title'] }}</a>
				</h3>
				<p>{{ $categoryArticle['excerpt'] }}</p>
				<p>{{ date("d F, Y", strtotime($categoryArticle['created'])) }}</p>
			</div>
		</div>
	</div>
</div>
<!-- not first 4 -->

{%
	}
%}


{%
	}
	
	if(!$articleCounter) {
%}
<p>No articles yet in this category.</p>
{%
	}
%}
{% endblock %}