Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
Rowid subgrid and export PDF(excel,...)
05/09/2014
09:52
Avatar
Xid
Member
Members
Forum Posts: 3
Member Since:
20/01/2014
sp_UserOfflineSmall 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
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall 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.

Forum Timezone: Europe/Sofia

Most Users Ever Online: 496

Currently Online:
32 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information