File Manager

Editing File: /home/cienp/public_html/portal/cron_agnd_pagm.php

<?php

require "includes/conecta.php";
    
    function moeda($valor) {
        $valor = str_replace(",", "", $valor);
        $valor = number_format($valor, 2, ',', '.');
        return $valor;
    }

$dt_atua = date("d/m/Y");
    $dt_pesq = date("Y-m-d");

$sql = "SELECT t.id_tipo_pagm, t.de_tipo_pagm, a.id_agnd_pagm, a.de_titl, a.vl_agnd, c.id_comp, c.nu_oc, f.nm_forn, ";
 $sql .= "DATE_FORMAT(a.dt_agnd, '%d/%m/%Y') as dt_agn2 ";
 $sql .= "FROM ".$pref_tabl."tipo_pagm t, ".$pref_tabl."agnd_pagm a, ".$pref_tabl."comp c, ".$pref_tabl."forn f ";
 $sql .= "WHERE a.id_tipo_pagm = t.id_tipo_pagm ";
 $sql .= "AND a.id_comp = c.id_comp ";
 $sql .= "AND c.id_forn = f.id_forn ";
 $sql .= "AND (a.dt_pagm IS NULL ";
 $sql .= "OR a.dt_pagm = '0000-00-00') ";
 $sql .= "AND a.dt_agnd = '$dt_pesq' ";
 $sql .= "ORDER BY c.nu_oc ";
 $res = mysqli_query($conn, $sql);
 #echo $sql;
 if (mysqli_num_rows($res) > 0) {
 $mensagem = "
 <!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
 <html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"pt-BR\" lang=\"pt-BR\">
 <head>
 <meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">
 <style TYPE='text/css'>
 A {text-decoration: none} 
 A:link {color:'#89211b';} 
 A:visited {color:'#89211b';}
 A:hover {color:'#000000';} 
 </style>
 </head>
 <body>
 
 Informamos que os pagamentos abaixo vencem no dia de hoje: 
 <table cellspacing='0' cellpadding='0'>
 <tr height='35' bgcolor='#b5b5b5'>
 <td width='40' style='border: 1px solid #e7ecea; padding-left: 10px; padding-right: 10px; font-size: 16px; color: #FFF;'>OC/OS N°</td>
 <td width='240' style='border: 1px solid #e7ecea; padding-left: 10px; padding-right: 10px; font-size: 16px; color: #FFF;'>Fornecedor</td>
 <td width='240' style='border: 1px solid #e7ecea; padding-left: 10px; padding-right: 10px; font-size: 16px; color: #FFF;'>Título</td>
 <td width='200' style='border: 1px solid #e7ecea; padding-left: 10px; padding-right: 10px; font-size: 16px; color: #FFF;'>Tipo de Pagamento</td>
 <td width='90' style='border: 1px solid #e7ecea; padding-left: 10px; padding-right: 10px; font-size: 16px; color: #FFF;'>Valor</td>
 </tr>
 ";

while ($linha = mysqli_fetch_array($res)) {
 $linha['vl_agnd'] = moeda ($linha['vl_agnd']);
 $mensagem .= "
 <tr height='30' style='border: 1px solid #e7ecea;'>
 <td style='border: 1px solid #e7ecea; padding-left: 10px; padding-right: 10px; font-size: 16px; color: #7f7f7f;'>$linha[nu_oc]</td>
 <td style='border: 1px solid #e7ecea; padding-left: 10px; padding-right: 10px; font-size: 16px; color: #7f7f7f;'>$linha[nm_forn]</td>
 <td style='border: 1px solid #e7ecea; padding-left: 10px; padding-right: 10px; font-size: 16px; color: #7f7f7f;'>$linha[de_titl]</td>
 <td style='border: 1px solid #e7ecea; padding-left: 10px; padding-right: 10px; font-size: 16px; color: #7f7f7f;'>$linha[de_tipo_pagm]</td>
 <td style='border: 1px solid #e7ecea; padding-left: 10px; padding-right: 10px; font-size: 16px; color: #7f7f7f;' align='right'>R$ $linha[vl_agnd]</td>
 </tr>
 ";
 }

$mensagem .= "
 </table> 
 Atenciosamente, 
 CIEnP 
 Centro de Inovação e Ensaios Pré-Clínicos 
 Setor de Compras
 
 </body>
 </html>
 ";

$snap     = "\n";
        // $from     = "atendimento@commix.com.br";	
        $from     = "compras@cienp.org.br";	
        $boundary = "==Multipart_Boundary_x".md5(time())."x";

$body = stripslashes($mensagem);

// Criamos os cabeçalhos MIME utilizados para separar as partes da mensagem MIME 
        $html  = "--".$boundary.$snap;
        $html .= "Content-Transfer-Encoding: 8bits".$snap;
        $html .= "Content-Type: text/html; charset=\"ISO-8859-1\"".$snap.$snap;
        $html .= $body.$snap;
        $html .= "--".$boundary."--";

// Adiciono os cabeçalhos de um arquivo anexado
        $head  = "MIME-Version: 1.0".$snap; 
        $head .= "From: $from".$snap; 
        $head .= "Return-Path: $from".$snap; 
        $head .= "Reply-to: $from".$snap; 
        $head .= "Bcc:gustavo.ciarallo@cienp.org.br,andre@commix.com.br".$snap; 
        $head .= "Content-type: multipart/alternative; boundary=\"{$boundary}\"".$snap; 
        $head .= $boundary.$snap;

// $to = 'andre@commix.com.br';
        $to = 'financeiro@cienp.org.br';
        $subject = "Agenda de Pagamentos - CIEnP";

$resmm = mail($to, $subject, $html, $head);
    }
?>

Back to Directory File Manager