<?php
include "tupi.inicializar.php";
$codTemplate = "relatorio";
include "tupi.template.inicializar.php";
$codAcesso = 24;
include "tupi.seguranca.php";
//titulo do relatorio
$tpl->TITULO = "Relatório de Contas a Pagar";
$tpl->DATA_RELATORIO = "Data/Hora:" . date("d/m/Y h:i:s");
$oC = new Conta();
$oCR = new ContaRealizado();
$dataRelatorio = $_REQUEST['ano'] . "-" . $_REQUEST['mes'] . "-01";
$dataFimRelatorio = $oCR->ultimoDiaMes($dataRelatorio);
$filtro = array("dataPagamento" => "between '" . $dataRelatorio . "' and '" . $dataFimRelatorio . "'");
$rs = $oCR->getRows(0, 9999, array("dataPagamento" => "ASC"), $filtro);
//$tpl->DATA_ATUAL = date("d/m/Y");
$total = 0;
foreach ($rs as $key => $c) {
$tpl->DESCRICAO = $c->conta->descricao;
$tpl->PARCELA = $c->parcela . "/" . $c->conta->parcelas;
$tpl->VALOR = $oCR->money($c->valorPagamento, "atb");
$tpl->DATA = $oCR->convdata($c->dataPagamento, "mtn");
$total += $c->valorPagamento;
$tpl->block("BLOCK_ITEM_LISTA");
}
$tpl->TOTAL = $oCR->money($total, "atb");
$tpl->DATA_INICIO = $oCR->convdata($dataRelatorio, "mtn");
$tpl->DATA_FIM = $oCR->convdata($dataFimRelatorio, "mtn");
include "tupi.template.finalizar.php";
function enviarEmailsContasAPagar()
{
$hoje = date("Y-m-d");
$hojets = strtotime($hoje);
$this->getById(3);
$ultimoDiats = strtotime($this->data);
$dia = date("Y-m-d", $ultimoDiats);
$i = 1;
$dia = date("Y-m-d", mktime(0, 0, 0, date("m", $ultimoDiats), date("d", $ultimoDiats) + $i, date("Y", $ultimoDiats)));
$i = 2;
$oConta = new ContaRealizado();
$log = "";
while (str_replace("-", "", $dia) <= str_replace("-", "", $hoje)) {
$rs = $oConta->getRows(0, 999, array(), array("dataPagamento" => "='" . $dia . "'"));
$log .= "Contas a pagar para o dia: " . $this->convdata($dia, "mtn") . " <br/>";
$j = 0;
foreach ($rs as $key => $conta) {
$log .= "Conta:" . $conta->conta->descricao . "<br/>Parcela:" . $conta->parcela . "<br/>Valor:" . $oConta->money($conta->valorPagamento, "atb") . "<br/><br/><br/>";
$j++;
}
if ($j > 0) {
$this->mail_html($this->destinatarios, $this->REMETENTE, 'Contas a Pagar', $log);
}
$dia = date("Y-m-d", mktime(0, 0, 0, date("m", $ultimoDiats), date("d", $ultimoDiats) + $i, date("Y", $ultimoDiats)));
$i++;
}
//fim do loop de dias
$this->data = $hoje;
$this->save();
}
