$readerExcel->getActiveSheet()->setCellValue('E7', $header['Celular']); $readerExcel->getActiveSheet()->setCellValue('E8', $header['Email']); $total = 0; $initialIndex = 11; foreach ($detail as $row) { $readerExcel->getActiveSheet()->setCellValue('A' . $initialIndex, $row['Referencia']); $readerExcel->getActiveSheet()->setCellValue('B' . $initialIndex, $row['Nombre']); $readerExcel->getActiveSheet()->setCellValue('C' . $initialIndex, $row['CantidadProducto']); $readerExcel->getActiveSheet()->setCellValue('D' . $initialIndex, $row['Precio']); $readerExcel->getActiveSheet()->setCellValue('E' . $initialIndex, $row['PrecioTotalProducto']); $total += intval($row['PrecioTotalProducto']); $initialIndex++; } $initialIndex += 2; $readerExcel->getActiveSheet()->setCellValue('E' . $initialIndex, $total); $readerExcel->getActiveSheet()->setCellValue('A' . $initialIndex++, "TOTAL"); $fileReport = 'orden_' . date("dmY") . $id; header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); header('Content-Disposition: attachment;filename="' . $fileReport . '.xls"'); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($readerExcel, 'Excel2007'); if ($ac === 'D') { $objWriter->save('php://output'); } else { $objWriter->save('../emailOrders/' . $fileReport . '.xls'); $mailReport = new ReportMail(); // $mailReport->sendReportMail($fileReport . '.xls', $resultInsert); $mailReport->sendReportMail($fileReport . '.xls', __FILE__); } exit; }
<?php require_once '../reports/ReportMail.php'; $mailReport = new ReportMail(); $peticion = json_decode(filter_input(INPUT_POST, 'peticion')); $msg = 'Mi nombre es: ' . $peticion->data->name . '\\nemail: ' . $peticion->data->email . '\\n\\n' . $peticion->data->message; $asunto = $peticion->data->subject; $resp = $mailReport->sendMail($msg, $asunto); die;