require_once '../../../../config/config_path.php';
require_once '../../../../config/config_gerais.php';
require_once PERFIL_PACKAGE . 'controller/PerfilPrint.class.php';
require_once PERFIL_PACKAGE . 'controller/TextBuilder.class.php';
require_once PERFIL_PACKAGE . 'controller/TextBuilder_EN.class.php';
require_once PERFIL_PACKAGE . 'controller/TextBuilder_ES.class.php';
require_once PERFIL_PACKAGE . 'Block.class.php';
//require_once $comPath . "util/protect_sql_injection.php";
if (empty($_SERVER['HTTP_X_REQUESTED_WITH']) || strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) != 'xmlhttprequest') {
    header("Location: {$path_dir}404");
}
$cidade = $_POST["city"];
$lang = $_POST["lang"];
//$pagina = (int) $_POST["page"];
//unset($_POST["page"]);
$perfil = new PerfilPrint($cidade);
TextBuilder::$idMunicipio = $perfil->getCityId();
//TextBuilder::$nomeMunicipio = mb_convert_case($perfil->getCityName(), MB_CASE_TITLE, "UTF-8");
TextBuilder::$nomeMunicipio = $perfil->getCityName();
TextBuilder::$ufMunicipio = $perfil->getUfName();
TextBuilder::$print = false;
TextBuilder_EN::$idMunicipio = $perfil->getCityId();
//TextBuilder_EN::$nomeMunicipio = mb_convert_case($perfil->getCityName(), MB_CASE_TITLE, "UTF-8");
TextBuilder_EN::$nomeMunicipio = $perfil->getCityName();
TextBuilder_EN::$ufMunicipio = $perfil->getUfName();
TextBuilder_EN::$print = false;
TextBuilder_ES::$idMunicipio = $perfil->getCityId();
//TextBuilder_EN::$nomeMunicipio = mb_convert_case($perfil->getCityName(), MB_CASE_TITLE, "UTF-8");
TextBuilder_ES::$nomeMunicipio = $perfil->getCityName();
TextBuilder_ES::$ufMunicipio = $perfil->getUfName();
TextBuilder_ES::$print = false;
 public function drawBoxes($lang)
 {
     TextBuilder::$bd = new bd();
     TextBuilder_EN::$bd = new bd();
     TextBuilder_ES::$bd = new bd();
     $carac_mun = PerfilPrint::getCaracteristicas(TextBuilder::$idMunicipio);
     //IDHM
     $pop = TextBuilder::getVariaveis_table(TextBuilder::$idMunicipio, "PESOTOT");
     //IDHM_R
     $micro_meso = PerfilPrint::getMicroMeso(TextBuilder::$idMunicipio, "PESOTOT");
     //IDHM_R
     $idhm = TextBuilder::getVariaveis_table(TextBuilder::$idMunicipio, "IDHM");
     //IDHM_R
     if ($lang == "pt") {
         $tabela = new BlockTabela("Caracterização do território", 2, 4);
         //$tabela->setManual("link", $path_dir."atlas/tabela/nulo/mapa/municipal/filtro/municipio/{$this->nomeCru}/indicador/idhm-2010");
         $tabela->addBox("Área", str_replace(".", ",", $carac_mun[0]["area"]) . " km²");
         $tabela->addBox("IDHM 2010", str_replace(".", ",", number_format($idhm[2]["valor"], 3)));
         $tabela->addBox("Faixa do IDHM", Formulas::getSituacaoIDH($idhm, $lang));
         $tabela->addBox("População (Censo 2010)", $pop[2]["valor"] . " hab.");
         $tabela->addBox("Densidade demográfica", str_replace(".", ",", $carac_mun[0]["densidade"]) . " hab/km²");
         $tabela->addBox("Ano de instalação", $carac_mun[0]["anoinst"]);
         $tabela->addBox("Microrregião", $micro_meso[0]["micro"]);
         $tabela->addBox("Mesorregião", $micro_meso[0]["meso"]);
     } else {
         if ($lang == "en") {
             $tabela = new BlockTabela("Characterization of the territory", 2, 4);
             //$tabela->setManual("link", $path_dir."atlas/tabela/nulo/mapa/municipal/filtro/municipio/{$this->nomeCru}/indicador/idhm-2010");
             $tabela->addBox("Area", str_replace(".", ",", $carac_mun[0]["area"]) . " km²");
             $tabela->addBox("MHDI 2010", str_replace(".", ",", number_format($idhm[2]["valor"], 3)));
             $tabela->addBox("MHDI category", Formulas::getSituacaoIDH($idhm, $lang));
             $tabela->addBox("Population (Census of 2000)", $pop[2]["valor"] . " Inhabitants");
             $tabela->addBox("Population density", str_replace(".", ",", $carac_mun[0]["densidade"]) . " inhabitants/km²");
             $tabela->addBox("Year of Establishment", $carac_mun[0]["anoinst"]);
             $tabela->addBox("Microregion", $micro_meso[0]["micro"]);
             $tabela->addBox("Mesoregion", $micro_meso[0]["meso"]);
         } else {
             if ($lang == "es") {
                 $tabela = new BlockTabela("Caracterización del territorio", 2, 4);
                 //$tabela->setManual("link", $path_dir."atlas/tabela/nulo/mapa/municipal/filtro/municipio/{$this->nomeCru}/indicador/idhm-2010");
                 $tabela->addBox("Area", str_replace(".", ",", $carac_mun[0]["area"]) . " km²");
                 $tabela->addBox("IDHM 2010", str_replace(".", ",", number_format($idhm[2]["valor"], 3)));
                 $tabela->addBox("Nivel de IDHM", Formulas::getSituacaoIDH($idhm, $lang));
                 $tabela->addBox("Población (censo 2010)", $pop[2]["valor"] . " hab.");
                 $tabela->addBox("Densidad demográfica", str_replace(".", ",", $carac_mun[0]["densidade"]) . " hab/km²");
                 $tabela->addBox("Año de fundación", $carac_mun[0]["anoinst"]);
                 $tabela->addBox("Microrregión", $micro_meso[0]["micro"]);
                 $tabela->addBox("Mesorregión", $micro_meso[0]["meso"]);
             }
         }
     }
     $tabela->draw();
 }
<?php

header('Content-Type: text/html; charset=utf-8');
ob_start();
/*
 require_once 'config/conexao.class.php';
 require_once 'com/mobiliti/consulta/bd.class.php';
 require_once 'com/mobiliti/display/IDisplayTemplate.class.php';
 require_once 'com/mobiliti/display/BlockTabela.class.php';
 require_once 'com/mobiliti/display/Block.class.php';
 require_once 'com/mobiliti/util/protect_sql_injection.php';
* 
*/
set_include_path(get_include_path() . PATH_SEPARATOR . "system/modules/perfil/");
require_once 'controller/PerfilPrint.class.php';
$perfil = new PerfilPrint($MunicipioPefil);
?>

<script type="text/javascript">

    $(document).ready(function()
    {
        $('#toolTipPrint').tooltip({html:true, delay: 500});
        $('#toolTipDown').tooltip({html:true, delay: 500});
       // readyGo();
    });
    
</script>

<div id="content">
    <div class="containerPerfilTopPrint">