<?php

include "config.php";
include "includes/db.php";

$path_parts = ( isset($_GET['path']) )? pathinfo($_GET['path']) : redir();

if ( $path_parts['filename'] == 'sitemap' ) {
	$content = getSecao( Array( 
		'limit' 		=> 500 , 
		'dirname' 		=> $path_parts['dirname'],
		'image_default' => $config->image_default,
		'order'			=> '' 
		) );

	header("Content-type: text/xml");

	include "templates/sitemap.php";
} else if ( $path_parts['filename'] == 'rss' ) {
	$content = getSecao( Array( 
		'limit' 		=> 500 , 
		'dirname' 		=> $path_parts['dirname'],
		'image_default' => $config->image_default,
		'order'			=> '' 
		) );

	header("Content-type: text/xml");

	include "templates/rss.php";
} else if ( $content = getPub( $path_parts + Array('image_default' => $config->image_default ) ) ) {
	include "templates/news.php";
} else {
	$content = getSecao( Array( 
		'limit' 		=> 15, 
		'dirname' 		=> $path_parts['filename'],
		'image_default' => $config->image_default,
		'order'			=> 'DESC'
		) );
	
	if ($content) {
		include "templates/main.php";
	} else {
		redir();
	}
}

function getSecao( $params = Array() )
{
	$params['not_id'] = ( empty($params['not_id']) )? 0 : $params['not_id'];
	$params['order'] = ( empty($params['order']) )? '' : $params['order'];

	$result = mysql_query("
		SELECT 
			*,
			IF(imagem_representativa = '','{$params['image_default']}',imagem_representativa) AS imagem_representativa,
			'{$params['image_default']}' AS meta_imagem,
			DATE_FORMAT(noticias.publicacao,'%Y-%m-%d') AS data_publicado,
			secao.nome AS title_1,
			'Notícias' AS title_2,
			secao.nome AS secao,
			secao.nome AS meta_description,
			secao.slug AS secao_slug,
			CONCAT( secao.slug , '/' ) AS meta_url,
			CONCAT( noticias.slug , '.html' ) AS url
		FROM 
			noticias 
			INNER JOIN 
				secao 
			ON noticias.id_secao = secao.id 
		WHERE
			secao.slug = '{$params['dirname']}' AND 
			noticias.ativo = 1 AND 
			noticias.id != {$params['not_id']}
		ORDER BY 
			publicacao {$params['order']}
		LIMIT
			{$params['limit']}
	");

	$content = Array();

	if ( mysql_num_rows( $result ) > 0 ) {
		
		while( $row = mysql_fetch_array( $result , MYSQL_ASSOC ) ) $content[] = $row;

		return $content;

	} else {
		return false;
	}
}

function getPub( $params = Array() )
{
	$result = mysql_query("
		SELECT 
			*,
			noticias.id AS id_noticia,
			IF(imagem_representativa = '','{$params['image_default']}',imagem_representativa) AS imagem_representativa,
			IF(imagem_representativa = '','{$params['image_default']}',imagem_representativa) AS meta_imagem,
			noticias.titulo AS title_1,
			noticias.resumo AS meta_description,
			DATE_FORMAT(noticias.publicacao,'%d/%m/%Y') AS data_publicado,
			secao.nome AS title_2,
			secao.nome AS secao,
			secao.slug AS secao_slug,
			CONCAT( secao.slug , '/' , noticias.slug , '.html' ) AS meta_url,
			CONCAT( noticias.slug , '.html' ) AS url
		FROM 
			noticias 
			INNER JOIN 
				secao 
			ON noticias.id_secao = secao.id 
		WHERE 
			noticias.slug = '{$params['filename']}' AND 
			secao.slug = '{$params['dirname']}'AND 
			noticias.ativo = 1
	");

	$content = Array(
		0 		=> Array(),
		'related' 	=> Array()
	);

	if ( mysql_num_rows( $result ) > 0 ) {
		
		while( $row = mysql_fetch_array( $result , MYSQL_ASSOC ) ) $content[0] = $row;

		$content['related'] = getSecao( Array( 
			'limit' => 2, 
			'dirname' => $params['dirname'],
			'image_default' => $params['image_default'],
			'not_id' => $content[0]['id_noticia'],
			'order'			=> 'DESC'
			) );
		
		return $content;

	} else {
		return false;
	}
}

function redir()
{
	header('Location: https://www.sermelhor.com.br/');
	die();
}