<?php
	
/**
 * BMZ Autobrokers
 *
 * @author inffus.com
 * @version 1.0
 * @copyright Inffus, 2019
 * @link http://www.bmz.com.br
*/

setlocale(LC_ALL,'pt_BR');

ini_set('display_errors',-1); 
error_reporting(E_ERROR | E_PARSE );	

	
header('Content-type: application/json');

/**
 * Include e Riquire CMS
 */
require_once('../../../application/include_dao.php');

//start new transaction
$transaction = new Transaction();

$veiculo = new Veiculo();

$autobrokerAlias = $_GET['autobroker'];

if($autobrokerAlias!=''){

	$autobroker = DAOFactory::getAutobrokerDAO()->queryByAlias($autobrokerAlias);
	
	if(is_numeric($autobroker[0]->idAutobroker)){ 
		$condAutobroker = ' and v.idAutobroker="'.$autobroker[0]->idAutobroker.'" '; 
	}else{
		$condAutobroker = '';
	}
}

$veiculo = DAOFactory::getVeiculoDAO()->relTable(' SELECT 
													
													*,
													idVeiculo as idVeiculo,
													m.nome as idMarca,
													a.file as capa,
													v.alias as alias,
													v.idAlbum as idAlbum,
													mol.nome as modelo,
													m.idMarca as km,
													ab.nome as bluetooth,
													ab.cidade as bancos,
													ab.estado as rodas,
													v.observacoes as observacoes 
													
													FROM Veiculo v 
													INNER JOIN albumMidia a ON (v.idAlbum=a.idAlbum) 
													INNER JOIN Marca m ON (v.idMarca=m.idMarca)
													INNER JOIN Modelo mol ON (v.idModelo=mol.idModelo)
													INNER JOIN autobroker ab ON (ab.idAutobroker=v.idAutobroker) 
													
													WHERE v.status=1 and a.ordem=0 ');


echo json_encode($veiculo);

//commit transaction
$transaction->commit();


?>