Esempio n. 1
0
}
/********************************************
	  MOSTRAR TABELA COM NOTAS VINDAS DE $_POST
	********************************************/
if (getenv("REQUEST_METHOD") == "POST") {
    if (isset($_POST['mes_ref'], $_POST['ano_ref'])) {
        $mes = $_POST['mes_ref'] == "" ? "nulo" : $_POST['mes_ref'];
        $ano = $_POST['ano_ref'] <= Date('Y') || $_POST['ano_ref'] >= 2012 ? $_POST['ano_ref'] : Date('Y');
        $tpl->MESNOME = strtoupper(getMesNome($mes, false));
        $tpl->ANO = $ano;
        $sql_cont = "SELECT id FROM daee_contratos";
        $query_cont = mysql_query($sql_cont);
        $qtd = 0;
        $i = 0;
        $rel = new Relatorio();
        $rel->setUdds();
        $udds = $rel->udds;
        $cores = $rel->cores;
        $tipos = $rel->ucTipos;
        if (mysql_num_rows($query_cont) > 0) {
            while ($res = mysql_fetch_array($query_cont)) {
                $contrato = new Contrato($res['id']);
                $notas = $contrato->getFaltaNotas($mes, $ano);
                if ($notas[0]['ucid'] != null) {
                    $qtd += count($notas);
                    foreach ($notas as $nota) {
                        $consTipo = $nota['tipo'];
                        $tpl->UO = $udds[$nota['uo']];
                        $tpl->AUTOS = $contrato->geraNome();
                        $tpl->UC = "<b>" . $nota['rgi'] . "</b> - [ <small>" . $nota['endereco'] . "</small> ]";
                        $tpl->UC .= "<br /><small><font color='" . $cores[$consTipo] . "'>" . $tipos[$consTipo] . "</font></small>";