$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;
