Hi all :),
Â
I’m trying to do such a thing :
Â
I have a “main grid”, when I click a row, a second grid show me de details. The two grids are on a different PHP=> this part is working. I based my work on this : http://www.teleosmedia.com/dev/oldanlytics/documentation/html/_2v90kwx4j.htm
But! When I try to export the detail grid I get only the titles and empty data. I have notice that rowid was null when I do such a thing. Don’t know why. (When the detail is generated it is ok).
Receiving rowid from main grid :
if(isset ($_REQUEST[“CustomerID”])){
   $rowid=jqgridUtils::Strip($_REQUEST[“CustomerID”]);
   //$_REQUEST[“CustomerID”] = $rowid;
}
else
{
   if(!isset($rowid))
   {
      $rowid = “0”;
   }
}
Â
==> ok when click on main grid
==> null when PDF.
Â
The thing is : I’m using rowid in my request :
|
1 |
$grid2->SelectCommand = "SELECT t_fichePat.*, concat(atd_listepathisto.nom,' ',atd_listepathisto.pren) as NomPatient,fc_labelcaisse.nom as NomLabel, ((fc_reportpatient.SoldeP-(select Sum(ModifSolde)          from fc_fichepatient          where IdPatient=(select idPatient from fc_Totaux where IdTotaux= ".$rowid.")          and idService=(select idUS from fc_Totaux where IdTotaux= ".$rowid.")          and dateFiche>= t_fichePat.dateFiche          and ID>= t_fichePat.ID          order by dateFiche desc, ID desc))+ModifSolde) as Solde FROM fc_fichepatient as t_fichePat               INNER JOIN atd_listepathisto ON atd_listepathisto.AdmNr=t_fichePat.IdPatient INNER JOIN fc_labelcaisse ON fc_labelcaisse.id=t_fichePat.label INNER JOIN fc_reportpatient ON fc_reportpatient.IdPatient=t_fichePat.IdPatient WHERE t_fichePat.IdPatient = (select idPatient from fc_Totaux where IdTotaux= ".$rowid.") AND idService= (select idUS from fc_Totaux where IdTotaux= ".$rowid.")"; |
Please help me, I need this import^^ ![]()
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top