jQuery Grid Plugin - jqGridForum

Topic RSS

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

05/09/2014
09:52

Xid

Member

Members

Forum Posts: 3

Member Since:
20/01/2014

Offline

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

08/09/2014
14:16

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

You use a php commertial product.

Please post your question here

http://www.trirand.net/forum

Regards

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
37 Guest(s)

Currently Browsing this Page:
1 Guest(s)