public function GeneraReporte() { ini_set('max_execution_time', 900000); $c = new Client("http://162.243.142.165:8080/jasperserver", "jasperadmin", "jasperadmin"); $c->setRequestTimeout(900000); $controls = array('stateId' => $_POST['estados']); $reporte = $c->reportService()->runReport('/reports/Blank_A4', 'html', null, null, $controls); $estados = State::orderBy('name', 'ASC')->lists('name', 'id'); $user_id = Auth::user()->id; $breadcrumbs = Neighbors::select('neighbors.name as name_ne', 'neighbors.last_name', 'urbanisms.name as name_ur ')->join('neighbors_properties', 'neighbors.id', '=', 'neighbors_properties.neighbors_id')->join('urbanisms', 'neighbors_properties.urbanism_id', '=', 'urbanisms.id')->where('neighbors.user_id', '=', $user_id)->first(); $breadcrumbs_data = $breadcrumbs->name_ne . " " . $breadcrumbs->last_name . " [" . $breadcrumbs->name_ur . "]"; return View::make("dashboard.reports.report", ['reporte' => $reporte, 'breadcrumbs_data' => $breadcrumbs_data]); }
<?php require_once __DIR__ . "/vendor/autoload.php"; use Jaspersoft\Client\Client; $client = new Client("http://localhost:8080/jasperserver", "scanoil", "scanoil", ""); $client->setRequestTimeout(60); $dl_format = 'xls'; $controls = array('REPORT_START_TIME' => $p_start, 'REPORT_END_TIME' => $p_end, 'REPORT_SUPPLIER_ID' => $supplier_id); $report = $client->reportService()->runReport('/reports/ScanOil/supplier/supplier_total_final', $dl_format, null, null, $controls); unset($controls);