public function postMovimientoult() { //recibir los parametros y enviarlos al modelo, ahi ejecutar el query $averia = null; if (Input::hasFile('file_averia')) { if (Input::file('file_averia')->isValid()) { $file = Input::file('file_averia'); $tmpArchivo = $file->getRealPath(); $file = file($tmpArchivo); $con = 0; $averia = ""; foreach ($file as $f) { $con++; if ($con > 1) { $averia .= "," . trim($f); } } $averia = substr($averia, 1); } } $averiau = Input::get('txt_cod_actu'); $checkFecha = Input::get('check_fecha'); $reporte = Input::get('slct_reporte'); $checkAveria = Input::get('check_averia'); $checkAveriaU = Input::get('check_averia_u'); $fechaIni = Input::get('fecha_ini'); $fechaFin = Input::get('fecha_fin'); $detalle = Input::get('slct_detalle_observacion'); $pendiente = Input::get('slct_pendiente'); $checkDetalleAgenda = false; $total = GestionMovimiento::getGestionMovimiento_ult($checkFecha, $checkAveria, $checkAveriaU, $reporte, $fechaIni, $fechaFin, $averia, $averiau, $pendiente); $output = "<table>"; $con = 0; foreach ($total as $t) { $con++; if ($con == 1) { $output .= "<tr>"; foreach ($t as $key => $value) { $output .= "<th>"; $output .= $key; $output .= "</th>"; } $output .= "</tr>"; } $output .= "<tr>"; foreach ($t as $key => $value) { $output .= "<td>"; $output .= $value; $output .= "</td>"; } $output .= "</tr>"; } $output .= "</table>"; $filename = Helpers::convert_to_file_excel('reporte_ult_movimientos'); $headers = array('Pragma' => 'public', 'Expires' => 'public', 'Cache-Control' => 'must-revalidate, post-check=0, pre-check=0', 'Cache-Control' => 'private', 'Content-Type' => 'application/vnd.ms-excel', 'charset' => 'utf-8', 'Content-Disposition' => 'attachment; filename=' . $filename, 'Content-Transfer-Encoding' => ' binary'); return Response::make($output, 200, $headers); }