public function enviarEmailAprovacaoVenda($id)
{
## Declarando os models usados ##
$model_cliente = new Pedidos_Model_Consultas();
$model_ItemProduto = new Pedidos_Model_Itemproduto();
$model_produto = new Pedidos_Model_Produto();
$util = new Recursos_Util();
$mail = new PHPMailer();
## Dados do Pedido ##
$pedido = $model_produto->buscarPedidosId($id);
$codigo_cliente = $pedido['id_cliente'];
$contrato_app = $pedido['numero_contrato'];
$condicao_pagamento = $pedido['DESCRICAO_CP'];
$forma_pagamento = $pedido['DESCRICAO_FP'];
$data_entrada = $util->converterDataHoraParaBr($pedido['data_aprovacao']);
$data_entrega = $util->converterDataParaBr($pedido['data_entrega']);
$valor_total = $util->formataMoedaReal($pedido['valor_total']);
## Dados dos Itens do Pedido ##
$itenspedido = $model_ItemProduto->buscarItensPedido($id);
## Dados do Cliente ##
$cliente = $model_cliente->buscarClientesId($codigo_cliente);
$nome_cliente = $cliente['RAZAOSOCIAL'];
// $cnpj = $util->mask($cliente['CNPJ'], '##.###.###/####-##');
// $cpf = $util->mask($cliente['CPF'], '###.###.###-##');
$email_cliente = $cliente['EMAIL'];
$endereco = $cliente['ENDERECO'];
$endereconumero = $cliente['ENDERECONUMERO'];
$enderecocomplemento = $cliente['ENDERECOCOMPLEMENTO'];
$enderecobairro = $cliente['BAIRRO'];
$enderecocep = $util->mask($cliente['CEP'], '##.###-###');
$telefone = $cliente['TELEFONE1'];
$celular = $cliente['FAX_CELULAR'];
$cidade = $cliente['DESCRICAO_CIDADE'];
$estado = $cliente['ESTADO'];
## Dados do Vendedor ##
$vendedor = $model_cliente->buscarVendedorCod($pedido['id_vendedor']);
## Variável para o contador ##
$i = 0;
// Define o idoma
// =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
$mail->setLanguage('br', 'library/PHPMailer/language/');
// Define os dados do servidor e tipo de conexão
// =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
$mail->IsSMTP();
// Define que a mensagem será SMTP
$mail->SMTPAuth = true;
// Usa autenticação SMTP? (opcional)
// $mail->Host = "smtp.gmail.com"; // Endereço do servidor SMTP
// $mail->Username = '******'; // Usurio do servidor SMTP
// $mail->Password = '******'; // Senha do servidor SMTP
$mail->Host = "smtp.gmail.com";
// Endereço do servidor SMTP
$mail->Username = '******';
// Usurio do servidor SMTP
$mail->Password = '******';
// Senha do servidor SMTP
$mail->Port = 465;
$mail->SMTPSecure = "ssl";
// sets the prefix to the servier
// sac@danat.com.br
// sac2935
//
// Define o remetente
// =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
$mail->From = "*****@*****.**";
// Seu e-mail
$mail->FromName = "JM Pneus e Renovadora Ltda.";
// Seu nome
// Define os destinatário(s)
// =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
$mail->AddAddress('*****@*****.**', $nome_cliente);
// $mail->AddAddress('*****@*****.**', $nome_cliente);
// $mail->AddBCC('*****@*****.**'); // COPIA OCULTA PARA O EMAIL DA CONTADORA
// $mail->AddBCC('*****@*****.**');
// $mail->AddBCC('*****@*****.**');
// $mail->AddCC('*****@*****.**', 'Ciclano'); // Copia
// Define os dados técnicos da Mensagem
// =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
$mail->IsHTML(true);
// Define que o e-mail será enviado como HTML
$mail->CharSet = 'utf-8';
// Define a mensagem (Texto e Assunto)
// =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
$mail->Subject = "Pedido Nº {$contrato_app} aprovado para produção";
// Assunto da mensagem
## Corpo da Mensagem em HTML##
$mail->Body = "<!doctype html>\n<html xmlns='http://www.w3.org/1999/xhtml' xmlns:v='urn:schemas-microsoft-com:vml' xmlns:o='urn:schemas-microsoft-com:office:office'>\n <head>\n <!-- NAME: RIBBON -->\n <!--[if gte mso 15]>\n <xml>\n <o:OfficeDocumentSettings>\n <o:AllowPNG/>\n <o:PixelsPerInch>117</o:PixelsPerInch>\n </o:OfficeDocumentSettings>\n </xml>\n <![endif]-->\n <meta charset='UTF-8'>\n <meta http-equiv='X-UA-Compatible' content='IE=edge'>\n <meta name='viewport' content='width=device-width, initial-scale=1'>\n <title>*|MC:SUBJECT|*</title>\n\n <style type='text/css'>\n p{\n margin:10px 0;\n padding:0;\n }\n table{\n border-collapse:collapse;\n }\n h1,h2,h3,h4,h5,h6{\n display:block;\n margin:0;\n padding:0;\n }\n img,a img{\n border:0;\n height:auto;\n outline:none;\n text-decoration:none;\n }\n body,#bodyTable,#bodyCell{\n height:100%;\n margin:0;\n padding:0;\n width:100%;\n }\n #outlook a{\n padding:0;\n }\n img{\n -ms-interpolation-mode:bicubic;\n }\n table{\n mso-table-lspace:0pt;\n mso-table-rspace:0pt;\n }\n .ReadMsgBody{\n width:100%;\n }\n .ExternalClass{\n width:100%;\n }\n p,a,li,td,blockquote{\n mso-line-height-rule:exactly;\n }\n a[href^=tel],a[href^=sms]{\n color:inherit;\n cursor:default;\n text-decoration:none;\n }\n p,a,li,td,body,table,blockquote{\n -ms-text-size-adjust:100%;\n -webkit-text-size-adjust:100%;\n }\n .ExternalClass,.ExternalClass p,.ExternalClass td,.ExternalClass div,.ExternalClass span,.ExternalClass font{\n line-height:100%;\n }\n a[x-apple-data-detectors]{\n color:inherit !important;\n text-decoration:none !important;\n font-size:inherit !important;\n font-family:inherit !important;\n font-weight:inherit !important;\n line-height:inherit !important;\n }\n a.mcnButton{\n display:block;\n }\n .mcnImage{\n vertical-align:bottom;\n }\n .mcnTextContent{\n word-break:break-word;\n }\n .mcnTextContent img{\n height:auto !important;\n }\n .mcnDividerBlock{\n table-layout:fixed !important;\n }\n /*\n @tab Page\n @section background style\n @tip Set the background color and top border for your email. You may want to choose colors that match your company's branding.\n */\n body,#bodyTable{\n /*@editable*/background-color:#F2F2F2;\n }\n /*\n @tab Page\n @section background style\n @tip Set the background color and top border for your email. You may want to choose colors that match your company's branding.\n */\n #bodyCell{\n /*@editable*/border-top:0;\n }\n /*\n @tab Page\n @section ribbon style\n @tip Set the color for your email's decorative ribbon.\n */\n #ribbonContainer{\n /*@editable*/background-color:#6DC6DD;\n }\n /*\n @tab Page\n @section email border\n @tip Set the border for your email.\n */\n #templateContainer{\n /*@editable*/border:0;\n }\n /*\n @tab Page\n @section heading 1\n @tip Set the styling for all first-level headings in your emails. These should be the largest of your headings.\n @style heading 1\n */\n h1{\n /*@editable*/color:#202020 !important;\n /*@editable*/font-family:Helvetica;\n /*@editable*/font-size:24px;\n /*@editable*/font-style:normal;\n /*@editable*/font-weight:bold;\n /*@editable*/line-height:125%;\n /*@editable*/letter-spacing:-1px;\n /*@editable*/text-align:left;\n }\n /*\n @tab Page\n @section heading 2\n @tip Set the styling for all second-level headings in your emails.\n @style heading 2\n */\n h2{\n /*@editable*/color:#202020 !important;\n /*@editable*/font-family:Helvetica;\n /*@editable*/font-size:22px;\n /*@editable*/font-style:normal;\n /*@editable*/font-weight:bold;\n /*@editable*/line-height:125%;\n /*@editable*/letter-spacing:-.75px;\n /*@editable*/text-align:left;\n }\n /*\n @tab Page\n @section heading 3\n @tip Set the styling for all third-level headings in your emails.\n @style heading 3\n */\n h3{\n /*@editable*/color:#202020 !important;\n /*@editable*/font-family:Helvetica;\n /*@editable*/font-size:18px;\n /*@editable*/font-style:normal;\n /*@editable*/font-weight:bold;\n /*@editable*/line-height:125%;\n /*@editable*/letter-spacing:-.5px;\n /*@editable*/text-align:left;\n }\n /*\n @tab Page\n @section heading 4\n @tip Set the styling for all fourth-level headings in your emails. These should be the smallest of your headings.\n @style heading 4\n */\n h4{\n /*@editable*/color:#202020 !important;\n /*@editable*/font-family:Helvetica;\n /*@editable*/font-size:16px;\n /*@editable*/font-style:normal;\n /*@editable*/font-weight:bold;\n /*@editable*/line-height:125%;\n /*@editable*/letter-spacing:normal;\n /*@editable*/text-align:left;\n }\n /*\n @tab Preheader\n @section preheader style\n @tip Set the background color and borders for your email's preheader area.\n */\n #templatePreheader{\n /*@editable*/background-color:#FFFFFF;\n /*@editable*/border-top:0;\n /*@editable*/border-bottom:1px solid #EEEEEE;\n }\n /*\n @tab Preheader\n @section preheader text\n @tip Set the styling for your email's preheader text. Choose a size and color that is easy to read.\n */\n .preheaderContainer .mcnTextContent,.preheaderContainer .mcnTextContent p{\n /*@editable*/color:#606060;\n /*@editable*/font-family:Helvetica;\n /*@editable*/font-size:11px;\n /*@editable*/line-height:125%;\n /*@editable*/text-align:left;\n }\n /*\n @tab Preheader\n @section preheader link\n @tip Set the styling for your email's header links. Choose a color that helps them stand out from your text.\n */\n .preheaderContainer .mcnTextContent a{\n /*@editable*/color:#606060;\n /*@editable*/font-weight:normal;\n /*@editable*/text-decoration:underline;\n }\n /*\n @tab Header\n @section header style\n @tip Set the background color and borders for your email's header area.\n */\n #templateHeader{\n /*@editable*/background-color:#F2F2F2;\n /*@editable*/border-top:0;\n /*@editable*/border-bottom:0;\n }\n /*\n @tab Header\n @section header text\n @tip Set the styling for your email's header text. Choose a size and color that is easy to read.\n */\n .headerContainer .mcnTextContent,.headerContainer .mcnTextContent p{\n /*@editable*/color:#606060;\n /*@editable*/font-family:Helvetica;\n /*@editable*/font-size:15px;\n /*@editable*/line-height:150%;\n /*@editable*/text-align:left;\n }\n /*\n @tab Header\n @section header link\n @tip Set the styling for your email's header links. Choose a color that helps them stand out from your text.\n */\n .headerContainer .mcnTextContent a{\n /*@editable*/color:#6DC6DD;\n /*@editable*/font-weight:normal;\n /*@editable*/text-decoration:underline;\n }\n /*\n @tab Body\n @section body style\n @tip Set the background color and borders for your email's body area.\n */\n #templateBody{\n /*@editable*/background-color:#F2F2F2;\n /*@editable*/border-top:0;\n /*@editable*/border-bottom:0;\n }\n /*\n @tab Body\n @section body text\n @tip Set the styling for your email's body text. Choose a size and color that is easy to read.\n */\n .bodyContainer .mcnTextContent,.bodyContainer .mcnTextContent p{\n /*@editable*/color:#606060;\n /*@editable*/font-family:Helvetica;\n /*@editable*/font-size:15px;\n /*@editable*/line-height:150%;\n /*@editable*/text-align:left;\n }\n /*\n @tab Body\n @section body link\n @tip Set the styling for your email's body links. Choose a color that helps them stand out from your text.\n */\n .bodyContainer .mcnTextContent a{\n /*@editable*/color:#6DC6DD;\n /*@editable*/font-weight:normal;\n /*@editable*/text-decoration:underline;\n }\n /*\n @tab Footer\n @section footer style\n @tip Set the background color and borders for your email's footer area.\n */\n #templateFooter{\n /*@editable*/background-color:#F2F2F2;\n /*@editable*/border-top:1px solid #E5E5E5;\n /*@editable*/border-bottom:0;\n }\n /*\n @tab Footer\n @section footer text\n @tip Set the styling for your email's footer text. Choose a size and color that is easy to read.\n */\n .footerContainer .mcnTextContent,.footerContainer .mcnTextContent p{\n /*@editable*/color:#606060;\n /*@editable*/font-family:Helvetica;\n /*@editable*/font-size:11px;\n /*@editable*/line-height:125%;\n /*@editable*/text-align:left;\n }\n /*\n @tab Footer\n @section footer link\n @tip Set the styling for your email's footer links. Choose a color that helps them stand out from your text.\n */\n .footerContainer .mcnTextContent a{\n /*@editable*/color:#606060;\n /*@editable*/font-weight:normal;\n /*@editable*/text-decoration:underline;\n }\n @media only screen and (max-width: 600px){\n body,table,td,p,a,li,blockquote{\n -webkit-text-size-adjust:none !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n body{\n width:100% !important;\n min-width:100% !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n .templateContainer{\n max-width:600px !important;\n width:100% !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n .templateContainer,#templatePreheader,#templateHeader,#templateBody,#templateFooter{\n max-width:600px !important;\n width:100% !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n .flexibleContainer{\n width:100% !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n .mcnImage{\n height:auto !important;\n width:100% !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n .mcnShareContent,.mcnCaptionTopContent,.mcnCaptionBottomContent,.mcnTextContentContainer,.mcnBoxedTextContentContainer,.mcnImageGroupContentContainer,.mcnCaptionLeftTextContentContainer,.mcnCaptionRightTextContentContainer,.mcnCaptionLeftImageContentContainer,.mcnCaptionRightImageContentContainer,.mcnImageCardLeftTextContentContainer,.mcnImageCardRightTextContentContainer{\n max-width:100% !important;\n width:100% !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n .mcnBoxedTextContentContainer{\n min-width:100% !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n .mcnImageGroupContent{\n padding:9px !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n .mcnCaptionLeftContentOuter .mcnTextContent,.mcnCaptionRightContentOuter .mcnTextContent{\n padding-top:9px !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n .mcnImageCardTopImageContent,.mcnCaptionBlockInner .mcnCaptionTopContent:last-child .mcnTextContent{\n padding-top:18px !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n .mcnImageCardBottomImageContent{\n padding-bottom:9px !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n .mcnImageGroupBlockInner{\n padding-top:0 !important;\n padding-bottom:0 !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n .mcnImageGroupBlockOuter{\n padding-top:9px !important;\n padding-bottom:9px !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n .mcnTextContent,.mcnBoxedTextContentColumn{\n padding-right:18px !important;\n padding-left:18px !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n .mcnImageCardLeftImageContent,.mcnImageCardRightImageContent{\n padding-right:18px !important;\n padding-bottom:0 !important;\n padding-left:18px !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n .mcpreview-image-uploader{\n display:none !important;\n width:100% !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n /*\n @tab Mobile Styles\n @section heading 1\n @tip Make the first-level headings larger in size for better readability on small screens.\n */\n h1{\n /*@editable*/font-size:24px !important;\n /*@editable*/line-height:125% !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n /*\n @tab Mobile Styles\n @section heading 2\n @tip Make the second-level headings larger in size for better readability on small screens.\n */\n h2{\n /*@editable*/font-size:20px !important;\n /*@editable*/line-height:125% !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n /*\n @tab Mobile Styles\n @section heading 3\n @tip Make the third-level headings larger in size for better readability on small screens.\n */\n h3{\n /*@editable*/font-size:18px !important;\n /*@editable*/line-height:125% !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n /*\n @tab Mobile Styles\n @section heading 4\n @tip Make the fourth-level headings larger in size for better readability on small screens.\n */\n h4{\n /*@editable*/font-size:16px !important;\n /*@editable*/line-height:125% !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n /*\n @tab Mobile Styles\n @section Boxed Text\n @tip Make the boxed text larger in size for better readability on small screens. We recommend a font size of at least 16px.\n */\n .mcnBoxedTextContentContainer .mcnTextContent,.mcnBoxedTextContentContainer .mcnTextContent p{\n /*@editable*/font-size:18px !important;\n /*@editable*/line-height:125% !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n /*\n @tab Mobile Styles\n @section Preheader Visibility\n @tip Set the visibility of the email's preheader on small screens. You can hide it to save space.\n */\n #templatePreheader{\n /*@editable*/display:block !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n /*\n @tab Mobile Styles\n @section Preheader Text\n @tip Make the preheader text larger in size for better readability on small screens.\n */\n .preheaderContainer .mcnTextContent,.preheaderContainer .mcnTextContent p{\n /*@editable*/font-size:14px !important;\n /*@editable*/line-height:115% !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n /*\n @tab Mobile Styles\n @section Header Text\n @tip Make the header text larger in size for better readability on small screens.\n */\n .headerContainer .mcnTextContent,.headerContainer .mcnTextContent p{\n /*@editable*/font-size:18px !important;\n /*@editable*/line-height:125% !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n /*\n @tab Mobile Styles\n @section Body Text\n @tip Make the body text larger in size for better readability on small screens. We recommend a font size of at least 16px.\n */\n .bodyContainer .mcnTextContent,.bodyContainer .mcnTextContent p{\n /*@editable*/font-size:18px !important;\n /*@editable*/line-height:125% !important;\n }\n\n }\t@media only screen and (max-width: 600px){\n /*\n @tab Mobile Styles\n @section footer text\n @tip Make the body content text larger in size for better readability on small screens.\n */\n .footerContainer .mcnTextContent,.footerContainer .mcnTextContent p{\n /*@editable*/font-size:14px !important;\n /*@editable*/line-height:115% !important;\n }\n\n }</style></head>\n <body leftmargin='0' marginwidth='0' topmargin='0' marginheight='0' offset='0'>\n \n <table align='center' border='0' cellpadding='0' cellspacing='0' height='100%' width='100%' id='bodyTable'>\n <tr>\n <td align='center' valign='top' id='bodyCell'>\n <!-- BEGIN TEMPLATE // -->\n <table border='0' cellpadding='0' cellspacing='0' width='100%'>\n <tr>\n <td align='center' valign='top'>\n <!-- BEGIN PREHEADER // -->\n <table border='0' cellpadding='0' cellspacing='0' width='100%' id='templatePreheader'>\n <tr>\n <td align='center' valign='top'>\n <table border='0' cellpadding='0' cellspacing='0' width='640' class='flexibleContainer'>\n <tr>\n <td valign='top' class='preheaderContainer' style='padding-top:10px; padding-bottom:10px'><table border='0' cellpadding='0' cellspacing='0' width='100%' class='mcnTextBlock'>\n <tbody class='mcnTextBlockOuter'>\n <tr>\n <td valign='top' class='mcnTextBlockInner'>\n\n <table align='left' border='0' cellpadding='0' cellspacing='0' width='392' class='mcnTextContentContainer'>\n <tbody><tr>\n\n <td valign='top' class='mcnTextContent' style='padding-top:9px; padding-left:18px; padding-bottom:9px; padding-right:0;'>\n\n Atenção! Informações de sua compra!\n </td>\n </tr>\n </tbody></table>\n\n <table align='right' border='0' cellpadding='0' cellspacing='0' width='211' class='mcnTextContentContainer'>\n <tbody><tr>\n\n <td valign='top' class='mcnTextContent' style='padding-top:9px; padding-right:18px; padding-bottom:9px; padding-left:0;'>\n\n <a href='http://www.omelhorcaminho.com.br' target='_blank' title='JM Pneus'>JM Pneus e Renovadora Ltda.</a>\n </td>\n </tr>\n </tbody></table>\n\n </td>\n </tr>\n </tbody>\n </table></td>\n </tr>\n </table>\n </td>\n </tr>\n </table>\n <!-- // END PREHEADER -->\n </td>\n </tr>\n <tr>\n <td align='center' valign='top'>\n <table border='0' cellpadding='0' cellspacing='0' width='640' class='templateContainer'>\n <tr>\n <td align='center' valign='top' width='60' id='ribbonContainer'>\n <table border='0' cellpadding='0' cellspacing='0'>\n <tr>\n <td align='center' valign='top' style='padding-top:18px; padding-right:4px; padding-bottom:18px; padding-left:4px;'>\n <img src='http://gallery.mailchimp.com/27aac8a65e64c994c4416d6b8/images/icon_envelope.png' height='40' width='40' class='mcnImage' style='border:0; display:block; line-height:100%; outline:none; text-decoration:none;'>\n </td>\n </tr>\n </table>\n </td>\n <td align='center' valign='top' class='mobilePaddingR9' style='padding-bottom:9px; padding-left:9px;'>\n <table border='0' cellpadding='0' cellspacing='0' width='100%'>\n <tr>\n <td align='center' valign='top' style='padding-top:9px;'>\n <!-- BEGIN HEADER // -->\n <table border='0' cellpadding='0' cellspacing='0' width='100%' id='templateHeader'>\n <tr>\n <td valign='top' class='headerContainer'><table border='0' cellpadding='0' cellspacing='0' width='100%' class='mcnImageBlock' style='min-width:100%;'>\n <tbody class='mcnImageBlockOuter'>\n <tr>\n <td valign='top' style='padding:9px' class='mcnImageBlockInner'>\n <table align='left' width='100%' border='0' cellpadding='0' cellspacing='0' class='mcnImageContentContainer' style='min-width:100%;'>\n <tbody><tr>\n <td class='mcnImageContent' valign='top' style='padding-right: 9px; padding-left: 9px; padding-top: 0; padding-bottom: 0; text-align:center;'>\n\n\n <img align='center' alt='' src='https://gallery.mailchimp.com/12f2dd44047f03156ba43ad7b/images/e5375551-575e-4321-9857-4400f1f17d5a.png' width='80' style='max-width:80px; padding-bottom: 0; display: inline !important; vertical-align: bottom;' class='mcnImage'>\n\n\n </td>\n </tr>\n </tbody></table>\n </td>\n </tr>\n </tbody>\n </table></td>\n </tr>\n </table>\n <!-- // END HEADER -->\n </td>\n </tr>\n <tr>\n <td align='center' valign='top'>\n <!-- BEGIN BODY // -->\n <table border='0' cellpadding='0' cellspacing='0' width='100%' id='templateBody'>\n <tr>\n <td valign='top' class='bodyContainer'><table border='0' cellpadding='0' cellspacing='0' width='100%' class='mcnTextBlock'>\n <tbody class='mcnTextBlockOuter'>\n <tr>\n <td valign='top' class='mcnTextBlockInner'>\n\n <table align='left' border='0' cellpadding='0' cellspacing='0' width='571' class='mcnTextContentContainer'>\n <tbody><tr>\n\n <td valign='top' class='mcnTextContent' style='padding-top:9px; padding-right: 18px; padding-bottom: 9px; padding-left: 18px;'>\n\n <h1><strong>Obrigado por comprar na JM Pneus!</strong></h1>\n\n </td>\n </tr>\n </tbody></table>\n\n </td>\n </tr>\n </tbody>\n </table><table border='0' cellpadding='0' cellspacing='0' width='100%' class='mcnTextBlock'>\n <tbody class='mcnTextBlockOuter'>\n <tr>\n <td valign='top' class='mcnTextBlockInner'>\n\n <table align='left' border='0' cellpadding='0' cellspacing='0' width='571' class='mcnTextContentContainer'>\n <tbody><tr>\n\n <td valign='top' class='mcnTextContent' style='padding-top:9px; padding-right: 18px; padding-bottom: 9px; padding-left: 18px;'>\n\n <div style='text-align: justify;'><strong>Prezado Cliente </strong>" . $nome_cliente . ",<br>\n <br>\n Obrigado por comprar conosco na JM Pneus. Seguem abaixo os dados de seu cadastro. Percebendo algum dado incompleto ou errado, por favor, nos informe: <br>\n <br>\n <strong>Dados Cadastrais</strong><br>\n </div>\n\n <table border='0' cellpadding='0' cellspacing='0' style='width:600px;' width='600'>\n <tbody>\n <tr>\n <td colspan='3'><strong>Nome: </strong>" . $nome_cliente . "</td>\n </tr>\n <tr>\n <td colspan='3'><strong>Endereço: </strong>" . $endereco . " Nº " . $endereconumero . "</td>\n </tr>\n <tr>\n <td><strong>Cidade: </strong>" . $cidade . "</td>\n <td><strong>Estado: </strong>" . $estado . "</td>\n <td><strong>CEP: </strong>" . $enderecocep . "</td>\n </tr>\n <tr>\n <td><strong>Bairro: </strong>" . $enderecobairro . "</td>\n <td><strong>Telefone: </strong>" . $telefone . "</td>\n <td><strong>Celular: </strong>" . $celular . "</td>\n </tr>\n <tr>\n <td colspan='3'><strong>E-mail: </strong>" . $email_cliente . "</td>\n <td> </td>\n <td> </td>\n </tr>\n </tbody>\n </table>\n \n\n <div style='text-align: justify;'>Ao receber esta mensagem, significa que seu pedido já foi recebido e estamos iniciando os trabalhos para atendê-lo com o <strong>máximo de qualidade</strong>.<br>\n <br>\n Abaixo você pode conhecer os detalhes do nosso contrato. Leia atentamente este e-mail. Qualquer dúvida, em relação a seu pedido pode ser esclarecida com o vendedor (contatos logo abaixo) ou no nosso escritório, pelo telefone (091) 3725-1399 ou ainda por e-mail <a href='mailto:jm2000@jmpneus.com.br'>jm2000@jmpneus.com.br</a>.<br>\n <br>\n <strong>Dados do Atendimento</strong><br>\n \n <table border='0' cellpadding='10' cellspacing='0'>\n <tbody>\n <tr>\n <td><strong>Contrato </strong><br>\n " . $id . "</td>\n <td><strong>Pedido </strong><br>\n " . $contrato_app . "</td>\n <td><strong>Data de Entrada </strong><br>\n " . $data_entrada . "</td>\n <td><strong>Data de Entrega </strong><br>\n " . $data_entrega . "</td>\n </tr>\n </tbody>\n </table>\n\n <table border='0' cellpadding='10' cellspacing='0'>\n <tbody>\n <tr>\n <td><strong>Atendido pelo Vendedor </strong><br>\n " . $vendedor['NOME_VENDEDOR'] . " - <strong>Telefones: </strong>" . $vendedor['TELEFONE1'] . " / " . $vendedor['TELEFONE2'] . "</td>\n </tr>\n </tbody>\n </table>\n <br>\n <strong>Dados do Pedido</strong><br>\n \n <table border='1' cellpadding='5' cellspacing=''>\n <thead>\n <tr>\n <th style='text-align: center;'><strong># </strong></th>\n <th style='text-align: center;'><strong>Serviço </strong></th>\n <th style='text-align: center;'><strong>Banda </strong></th>\n <th style='text-align: center;'><strong>Medida </strong></th>\n <th style='text-align: center;'><strong>Marca </strong></th>\n <th style='text-align: center;'><strong>Modelo </strong></th>\n <th style='text-align: center;'><strong>DOT </strong></th>\n <th style='text-align: center;'><strong>Fogo / Série </strong></th>\n <th style='text-align: center;'><strong>Valor </strong></th>\n </tr>\n </thead>\n <tbody>";
foreach ($itenspedido as $todositens) {
$mail->Body .= "<tr>\n <td style='text-align: left;'>" . ++$i . "</td>\n <td style='text-align: left;'>" . $todositens['DESCRICAO_PROCESSO'] . "</td>\n <td style='text-align: left;'>" . $todositens['DESCRICAO_BORRACHA'] . "</td>\n <td style='text-align: left;'>" . $todositens['DESCRICAO_MEDIDA'] . "</td>\n <td style='text-align: left;'>" . $todositens['DESCRICAO_FABRICANTE'] . "</td>\n <td style='text-align: left;'>" . $todositens['DESCRICAO_MODELO'] . "</td>\n <td style='text-align: left;'>" . $todositens['dot'] . "</td>\n <td style='text-align: left;'>" . $todositens['fogo_serie'] . "</td>\n <td style='text-align: left;'>R\$ " . number_format($todositens['valor'], 2, ',', '.') . "</td>\n </tr>";
}
$mail->Body .= "</tbody>\n </table>\n <table border='0' cellpadding='5' cellspacing='0'>\n <tbody>\n <tr>\n <td><strong>Valor do Contrato</strong> <br>\n R\$ " . $valor_total . "</td>\n <td><strong>Forma de Pagamento</strong> <br>\n " . $forma_pagamento . "</td>\n <td><strong>Prazo de Pagamento</strong> <br>\n " . $condicao_pagamento . "</td>\n </tr>\n </tbody>\n </table>\n <br>\n <strong>Dados da Entrega</strong><br>\n <br>\n Será entregue conforme acordado, na data " . $data_entrega . " e no endereço abaixo:<br>\n \n <table border='0' cellpadding='0' cellspacing='0' style='line-height: 20.8px; width: 600px;' width='600'>\n <tbody>\n <tr>\n <td colspan='3'><strong>Endereço: </strong>" . $endereco . " Nº " . $endereconumero . "</td>\n </tr>\n <tr>\n <td><strong>Cidade: </strong>" . $cidade . "</td>\n <td><strong>Estado: </strong>" . $estado . "</td>\n <td><strong>CEP: </strong>" . $enderecocep . "</td>\n </tr>\n <tr>\n <td><strong>Bairro: </strong>" . $enderecobairro . "</td>\n <td><strong>Telefone: </strong>" . $telefone . "</td>\n <td><strong>Celular: </strong>" . $celular . "</td>\n </tr>\n </tbody>\n </table>\n <br>\n <strong>Atenção Sr. Cliente, informações importantes sobre seu contrato:</strong><br>\n <br>\n - Prazo limite para retirada do bem de 90 dias. <br>\n <br>\n - Posterior a isso sua(s) carcaças serão vendidas para custear as despesas de armazenagem, responsabilidade de guarda e dos materiais(energia, mão de obra, matéria prima , etc...) empregados na sua transformação. Não haverá reembolso.<br>\n <br>\n - Prazo de retirada sob pena de cobrança a título de guarda.<br>\n <br>\n - A perda da propriedade está regulada no artigo 1.275 do Código Civil, são elas: alienação, renúncia, abandono, perecimento de coisa, desapropriação.<br>\n <br>\n - Quando um consumidor deixa uma mercadoria em uma oficina ou qualquer estabelecimento para fazer um reparo, troca ou melhoramento , seja ou não em garantia, e não volta para buscá-lo, poder-se-ia pensar que houve um abandono do bem.<br>\n <br>\n - Por outro lado é possível no momento em que o consumidor entregar o produto para reparo, lhe fornecer o recibo da mercadoria com a informação expressa de que haverá um prazo limite para a retirada do produto, sendo que após esta data será cobrado um valor pré-estabelecido a título de guarda do bem.<br>\n <br>\n - É lícita esta cobrança, pois o fornecedor terá despesas e responsabilidades com a guarda do produto em seu estabelecimento. Cumpre observar que o valor a ser cobrado pela guarda deve ser fixado sem excessos, sob pena de se tornar abusiva.</div>\n\n </td>\n </tr>\n </tbody></table>\n\n </td>\n </tr>\n </tbody>\n </table></td>\n </tr>\n </table>\n <!-- // END BODY -->\n </td>\n </tr>\n <tr>\n <td align='center' valign='top'>\n <!-- BEGIN FOOTER // -->\n <table border='0' cellpadding='0' cellspacing='0' width='100%' id='templateFooter'>\n <tr>\n <td valign='top' class='footerContainer' style='padding-bottom:9px;'><table border='0' cellpadding='0' cellspacing='0' width='100%' class='mcnTextBlock'>\n <tbody class='mcnTextBlockOuter'>\n <tr>\n <td valign='top' class='mcnTextBlockInner'>\n\n <table align='left' border='0' cellpadding='0' cellspacing='0' width='571' class='mcnTextContentContainer'>\n <tbody><tr>\n\n <td valign='top' class='mcnTextContent' style='padding-top:9px; padding-right: 18px; padding-bottom: 9px; padding-left: 18px;'>\n\n <em>Copyright © JM Pneus e Renovadora Ltda., Todos os direitos reservados.</em><br>\n Rodovia BR-316, Km 57, S/N, Apeú<br>\n Castanhal - Pará - CEP 68.740-420<br>\n Fone: (091) 3725-1399 E-mail: <a href='mailto:sac@jmpneus.com.br' target='_blank'>sac@jmpneus.com.br</a><br>\n Portal: <a href='http://www.omelhorcaminho.com.br' target='_blank'>www.omelhorcaminho.com.br</a>\n </td>\n </tr>\n </tbody></table>\n\n </td>\n </tr>\n </tbody>\n </table></td>\n </tr>\n </table>\n <!-- // END FOOTER -->\n </td>\n </tr>\n </table>\n </td>\n </tr>\n </table>\n </td>\n </tr>\n </table>\n <!-- // END TEMPLATE -->\n </td>\n </tr>\n </table>\n \n </body>\n </html>";
$mail->AltBody = "Contrato sob nº {$id}, para o cliente: {$nome_cliente}, CPF/CNPJ: {$cnpj}.\r\n";
// Define os anexos (opcional)
// =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
// $mail->AddAttachment($arq_pdf); // Insere um anexo
// $mail->AddAttachment($arq_xml); // Insere um anexo
// Envia o e-mail
$enviado = $mail->Send();
// Limpa os destinatários e os anexos
$mail->ClearAllRecipients();
$mail->ClearAttachments();
// Exibe uma mensagem de resultado
if ($enviado) {
echo "E-mail enviado com sucesso!";
} else {
echo "Não foi possível enviar o e-mail.<br /><br />";
echo "<b>Informações do erro:</b> <br />" . $mail->ErrorInfo;
}
}
