<?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(); }