{% extends theme/author.html %}

{% block title %}{{ $author['name'] }} - Our Cool Site {% 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($category = $categoriesQuery -> fetchArray(SQLITE3_ASSOC)){
	%}
	<li class="nav-item">
		<a href="{{ $basehost }}/{{ $category['slug'] }}/" class="nav-link {% if($currentCategory == $category['slug']) { %}active{% } %}">
			{{ $category['name'] }}
		</a>
	</li>
	{%
		}
	%}
</ul>
{% endblock %}

{% block authorimage %}<img src="{{ $basehost }}/data/images/thumb-300-{{ $author["image"] }}" alt="image">{% endblock %}

{% block content %}
<h3>{{ $author["name"] }}</h3>
{{ $author["bio"] }}
{% endblock %}

{% block pagetitle %}{{ $author["name"] }}{% endblock %}

{% block authortotalposts %}Total posts ({{ $author["articlescount"] }}){% endblock %}

{% block authorlinkedin %}{{ $author["linkedin"] }}{% endblock %}

{% block author_articles %}
{%
	$authorArticlesQuery = $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.author_id = " . $author["id"] . " ORDER BY articles.created DESC");
	
	while($authorArticle = $authorArticlesQuery -> fetchArray(SQLITE3_ASSOC)){
%}
<div class="single-overview-news">
	<div class="row align-items-center">
		<div class="col-lg-4">
			<div class="overview-news-image">
				<a href="{{ $basehost }}/{{ $authorArticle['category_slug'] }}/{{ $authorArticle['slug'] }}.html">
					<img src="{{ $basehost }}/data/images/thumb-610-{{ $authorArticle["image"] }}" alt="image">
				</a>
			</div>
		</div>

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

{% endblock %}