2. PHPRunner General questions
  3. [SOLVED]  Permissions not applied when export / print
This topic is locked
[SOLVED]

 Permissions not applied when export / print

 		8/4/2010 4:32:53 AM
PHPRunner General questions
A
 alab author

Hi,
After having browsed the forum for hours, I still haven't found the solution to my prob, so here is the description:

  • I am using PHPRunner 5.2 (excellent sofwtare btw, that I will recommend without any hesitation)
  • I have set-up a dynamic persmission on my tables / reports
  • Permissions are working very well in all List / View / Add / Edit pages
  • But Permissions are not applied when I try to Export to Excel or Print-friendly/whole report <=> I see records that I should not see
    I have tried to display the SQL Querry (both $strSQL and $strWhereClause) in the "Before SQL Query" event, and it looks fine.
    Is there anything I have missed in my configuration ?
    Thanks for help !!
    AD
A
 		ann 8/4/2010

Hi,
thank you for pointing me to this bug.

We will fix it in the next version of PHPRunner.
To make your pages working open source/rprint.php file, find the line:

$sqlGroupBy = $gQuery->GroupByToSql();



and add just after:

$strSecuritySql = SecuritySQL("Search", $strTableName);

$gsqlWhereExpr = whereAdd($gsqlWhereExpr, $strSecuritySql);



Then open and rebuild project
A
 		alab author 8/4/2010

Hi,
Just tried your fix and it worked just like a charm, thanks for your reactivity, excellent support!
AD
N
 		nitinjainDevClub member 9/4/2010



Hi,
thank you for pointing me to this bug.

We will fix it in the next version of PHPRunner.
To make your pages working open source/rptint.php file, find the line:

$sqlGroupBy = $gQuery->GroupByToSql();



and add just after:

$strSecuritySql = SecuritySQL("Search", $strTableName);

$gsqlWhereExpr = whereAdd($gsqlWhereExpr, $strSecuritySql);



Then open and rebuild project



Hi Ann,
The same error is continuing in Report Export Pages also.
Regards
Nitin Jain
A
 		ann 9/10/2010

Nitin,
this fix should work for export also.
N
 		nitinjainDevClub member 9/10/2010

Hi Ann,
The fix is not working for the report export page. All the records are getting displayed for printing.
Regards
Nitin Jain
A
 		ann 9/10/2010

Nitin,
It's difficult to tell you what's happening.

I recommend you to contact support directly providing all required files.