Hey guysI need your help
I have actionConsultar() in IncidenciaController that consult a DB (this is part of it)
$chato=Incidencia:: findBySql($sql,[':munchen'=>$val])->all();
$violacion=Incidencia::findBySql($sqlvio,[':munchen'=>$val])->all();
$hd=Incidencia::findBySql($sqlhd,[':munchen'=>$val])->all();
$narco= \app\models\Narcomenudeo::findBySql($sqlnm,[':munchen'=>$val])->all();
$sec= Incidencia::findBySql($sqlsec,[':munchen'=>$val])->all();
$rch= Incidencia::findBySql($sqlrch,[':munchen'=>$val])->all();
$ran=Incidencia::findBySql($sqlran,[':munchen'=>$val])->all();
$rat=Incidencia::findBySql($sqlrat,[':munchen'=>$val])->all();
$rdv=Incidencia::findBySql($sqlrdv,[':munchen'=>$val])->all();
and returns
return $this->render('consulta', ['model' => $model,'muns'=>$dataMunicipio,'val'=>$val,'chato'=>$chato,'mname'=>$mname,'viol'=>$violacion, 'hd'=>$hd,'narco'=>$narco,'sec'=>$sec, 'rch'=>$rch,'ran'=>$ran,'rat'=>$rat,'rdv'=>$rdv,'mes'=>$mes,]);
Then I have consulta view that shows the data in tables.
After that I have to export the data to pptx file.
What I want to know is how to send
$chato,$mname,$viol, $hd, $narco,$sec, $rch,$ran,$rat,$rdv,,
to ExcportController through a button from view. In order to process the information to be useful for phppresentation library.
My current code sends an Id to consult DB again. So Im getting the same data twice, once before view, once after view.
I want to avoid that. Do you know how i can make this process more eficient?
By tha way I have tried
<?=Html::a('Export', ['exportar/consultar', ['id'=>$val, 'incidencia'=>$chato,'mname'=>$mname,'viol'=>$viol, 'hd'=>$hd,'narco'=>$narco,'sec'=>$sec, 'rch'=>$rch,'ran'=>$ran,'rat'=>$rat,'rdv'=>$rdv,]], ['class' => 'btn btn-primary']);
But I get an error that says url is too long.
THNKS EVERYBODY