tony on Rowid subgrid and export PDF(excel,...)

Mon, 08 Sep 2014 14:16:35 +0300

Hello,

You use a php commertial product.

Please post your question here

http://www.trirand.net/forum

Regards

Xid on Rowid subgrid and export PDF(excel,...)

Fri, 05 Sep 2014 09:52:55 +0300

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.....0kwx4j.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 :

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

jQuery Grid Plugin - jqGrid - Topic: Rowid subgrid and export PDF(excel,...)

tony on Rowid subgrid and export PDF(excel,...)

Xid on Rowid subgrid and export PDF(excel,...)