2. PHPRunner General questions
  3. Suggestions and Feedback
This topic is locked

Suggestions and Feedback

 		10/23/2016 4:34:54 AM
PHPRunner General questions
Q
 qaiserikram author

Dear Team
I've had downloaded trial version 27012 few days ago and was testing it. I have to say you have come this far and made it a necessary product for Database Development.

During my testing, new version (27326) is released. I would like to highlight few bugs first.
1. Build 27326 introduces gylphicons bug (most of icons are not visible in PHPRunner interface, but visible in generated pages in browser). I've tried to manually update the font files, css, js from bootstratp official site but that doesn't help. it means problem is related to PHPRunner program itself (maybe the font rendering issue or font gets corrupted)


NOTE : Gylphicons are visible in VM Box under Windows XP SP3 but not visible in Windows 10 Build 10586 with IE 11.
2. You have moved edit selected, delete selected to settings gear for bootstrap for smaller screens compatibility. But this causes issue while editing records (master and child mode). When I select child records on master table's edit page, there are no edit all, save all. save or delete buttons as they are available in previously provided templates (now called html5 compatibility templates)


3.In bootstrap themes, field resize options works in PHPRunner but in generated application, fields lengths are controlled automatically. For example if i want to place 10 fields on list page and use inline add/edit functions, the fields length is not what i've customized in PHPRunner Visual Editor i.e. text field width = 50px, it doesn't have effect in generated application.
4.Read Only fields doesn't show field values if i use dependent fields and autofill values features. For example in above snapshot (master_details edit page), Client's name field is set as dropdown (taking values from clients table).

I've selected country code, currency name, currency code, account no for auto fill values, dependent on Client's name.

I've set country code, currency name, currency code, account no fields as Readonly. Now when i select Client's name, i don't see any values to be inserted in country code, currency name, currency code, account no fields, but when i save, the values are saved in database. They are being saved but not visible, while they were visible in previous version 8.1 series.
5. Readonly fields also don't work in javascript onload calculations. For example, as per my screen shot above I've Balance field. User inputs Debit and Credit and it gets calculated on they fly via javascript onload. If I make balance field as readonly, i can't see balance field value being changed on the fly, though it gets updated after record saved. But when I change to normal number field (non-readonly) balance get updated as soon as user types in debits or credit field boxes.
I hope someone else also have faced these issues, if not, at least I've.
Suggestions
1. In global settings you may add an option (dropdown) for whether to use PHPRunner in compatibility mode, which is current scenario, or to use bootstrap only. So if user opt-in for bootstrap only you give us Bootstrap Editor instead of previous template editor. And when user opt-in for Compatibility mode, you give us both current template editor and the bootstrap theme editor. or you may just simply add customization tool for bootstrap themes, i.e. to customize theme background, navs, buttons, etc (though these can still be customized via custom CSS and developer tools extension of a browser, but that takes much time and not suitable for all users)
2. Offer PHPRunner pro which has all the functionalities of PHPRunner Enterprise except online reports builder. Because not every user needs online reports builder and price for enterprise edition is too high for many of us. So if you offer PHPRunner Standard , PHPRunner Pro and PHPRunner Enterprise with a fraction of prices, you give us variety to chose from and buy.

You may also offer it like this, PHPRunner standard as it was in 8.1 (means no bootstrap), PHPRunner Pro as it is now in 9.0 along with password encryptions and bootstrap editor. PHPRunner Enterprise with bootstrap editor, LDAP and online reports builder etc.



3. Kindly add email, export (pdf, word, excel) and print buttons on view pages, so user can export/email the View page's contents (either customized or default).
I hope someone may find these suggestions helpful too as these seems to me.
Q
 		qaiserikram author 10/23/2016

Temporary Solution for Gylphicons Issue.
After struggling many days, solution given here works like a charm.

Stack Over Flow - Untrusted Font Blocking

I copied the solution from that page and applied it in my pc and now all ghylphicons are visible in PHPRunner program and IE 11 itself.
To disable Untrusted Font Blocking using Registry Editor:
Open Registry Editor (regedit.exe) and go to the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Kernel\

If the MitigationOptions key is not there, right-click and add a new QWORD (64-bit) Value, naming it as MitigationOptions.

To turn this feature off. Type 2000000000000.
IMPORTANT: A computer restart is required for the changes to take effect
S
 		steveh 10/23/2016

For your point 3,the code checks whether the layout is bootstrap and if so suppresses the width style, I've a textarea that only takes up half the width available for instance.
I'll remove the check and see how it looks.
Q
 		qaiserikram author 10/24/2016

Temporary Solution to My Point Number 4 - ReadOnly Values not visible with AutoFill Feature
Issues :

When you select a dropdown value and have chosen autofill some readonly fields, values get filled but not visible on add/edit page.

Hence no values are visible, therefore, no calculation on the fly on add and edit pages
Solution:
Open C:\Program Files (x86)\PHPRunner9.0\source\include\common\runnerJS\Control.js (Build 27326)

Go to Line No 1010

there is a code which ends on Line No 1032 and here is the that code

setValue: function( val, triggerEvent, updContext ) {

var readOnly = this.isReadonly();
if ( this.valueElem instanceof jQuery ) {

if ( readOnly ) {

this.makeReadWrite();

}
this.valueElem.val( val );
if ( triggerEvent === true ) {

this.fireEvent("change", updContext);

}
if ( readOnly ) {

this.makeReadWrite();

}
return true;

}
return false;

},


Replace that code with this one (i've taken that code from installation of Build 27012)
setValue: function( val, triggerEvent, updContext ) {

if ( this.valueElem instanceof jQuery ) {

this.valueElem.val( val );
if ( triggerEvent === true ) {

this.fireEvent("change", updContext);

}

return true;

}
return false;

},
Now do a full build and problem is resolved.

I don't know whether this is the actual fix, but it fixes the problem
Now autofill values get populated and are visible on add/edit pages. On the fly calculation starts working too and balance gets updated (while balance field is a readonly field)
romaldus 10/24/2016



Temporary Solution to My Point Number 4 - ReadOnly Values not visible with AutoFill Feature
Issues :

When you select a dropdown value and have chosen autofill some readonly fields, values get filled but not visible on add/edit page.

Hence no values are visible, therefore, no calculation on the fly on add and edit pages
Solution:
Open C:\Program Files (x86)\PHPRunner9.0\source\include\common\runnerJS\Control.js (Build 27326)

Go to Line No 1010

there is a code which ends on Line No 1032 and here is the that code

setValue: function( val, triggerEvent, updContext ) {

var readOnly = this.isReadonly();
if ( this.valueElem instanceof jQuery ) {

if ( readOnly ) {

this.makeReadWrite();

}
this.valueElem.val( val );
if ( triggerEvent === true ) {

this.fireEvent("change", updContext);

}
if ( readOnly ) {

this.makeReadWrite();

}
return true;

}
return false;

},


Replace that code with this one (i've taken that code from installation of Build 27012)
setValue: function( val, triggerEvent, updContext ) {

if ( this.valueElem instanceof jQuery ) {

this.valueElem.val( val );
if ( triggerEvent === true ) {

this.fireEvent("change", updContext);

}

return true;

}
return false;

},
Now do a full build and problem is resolved.

I don't know whether this is the actual fix, but it fixes the problem
Now autofill values get populated and are visible on add/edit pages. On the fly calculation starts working too and balance gets updated (while balance field is a readonly field)


i have the same issue with phprunner build 27326.
Q
 		qaiserikram author 10/24/2016



i have the same issue with phprunner build 27326.


@romaldus! Have you resolved the issue by applying the fix as I suggested?
romaldus 10/24/2016



@romaldus! Have you resolved the issue by applying the fix as I suggested?


For some reason, i have to uninstall build 27326 and switch back to build 27012. I'm working on a large project where many forms depends on autofill in read only fields.

Q
 		qaiserikram author 10/25/2016



For some reason, i have to uninstall build 27326 and switch back to build 27012. I'm working on a large project where many forms depends on autofill in read only fields.


You can do what you seems to be important and right to you. But I didn't switched back to previous version, instead I replaced the code and My project is working fine as it should be. You may give it a try.

Just backup your project and they try and I am sure nothing will be wrong.
Q
 		qaiserikram author 10/30/2016



You have moved edit selected, delete selected to settings gear for bootstrap for smaller screens compatibility. But this causes issue while editing records (master and child mode). When I select child records on master table's edit page, there are no edit all, save all. save or delete buttons as they are available in previously provided templates (now called html5 compatibility templates)


As per my point number 2. relating to No Edit Selected, Delete buttons on Master-Detail Edit page, I've had a workaround to fix this.
Open file : C:\Program Files (x86)\PHPRunner9.0\templates\bricks\bsedit_details.htm
Replace the code from Line no 26 to Line no 32 with this
{BEGIN detailsedit##@shortDetailsTable##_link}

<button type="button" class="btn btn-xs btn-info" {$detailsedit##@shortDetailsTable##_attrs}>##message EDIT##</button>

{END detailsedit##@shortDetailsTable##_link}
{BEGIN detailsdelete##@shortDetailsTable##_link}

<button type="button" class="btn btn-xs btn-info" {$detailsdelete##@shortDetailsTable##_attrs}>##message DELETE##</button>

{END detailsdelete##@shortDetailsTable##_link}
In the above code, i've only replaced the class "btn btn-xs btn-info bs-invisible-button" with "class="btn btn-xs btn-info" and now I am able to Edit all selected records on Master-Details Edit Page while using BootStrap Layouts.