2. PHPRunner General questions
  3. Create Customized Second Menu on List Pages?
This topic is locked

Create Customized Second Menu on List Pages?

 		12/24/2010 10:35:40 AM
PHPRunner General questions
V
 vksharma author

I am not sure how this can be done:
I have 5 tables all linked to Table A. Suppose other tables are Table B,C,D,E,F

Table A is the Master Table and other 5 tables store the other related records.
The MainPage that loads, shows a List of records in the Master Table, with links to Table B,C,D,E,F inline.
Now when the user clicks on the inline hyperlinks to these tables, the page view changes. Now to Change to the other table, one has to first click on "Back to Master Table" on the top, then search for the record which was being edited, and then click on the hyperlink for the other table.
So in all, to edit all the tables, one has to always go back to the main page, search for the same record (out of a huge list ) and then select the other link.
So when viewing the records for Tables B,C,D,E,F, can the links to these tables be added on the top of the page so that user stays on the same master record itself and not keep on jumping to the main page again and again.
Is this possible? or is there any other alternative of doing this?

I hope i am able to convey myself clearly.
I wanted that when the other Tables (Table B,C,D,E,F) are being viewed or edited, the user should not go back to the mainpage (which lists around 50-60 records. The selected record gets lost. One has to search again for the same). He should be able to directly jump to the other tables of the selected main record.
Menu is also an option, but when you click on the Menu link for Tables B,C,D,E,F, it lists down all the records.
Best Regards

VK Sharma
V
 		vksharma author 12/26/2010

Hi,
Now i am beginning to think, this cannnot be done via PHPRunner. Not a single reply.
Can somebody at least reply back and tell me whether its possible to do this or not?
Regards

VK



I am not sure how this can be done:
I have 5 tables all linked to Table A. Suppose other tables are Table B,C,D,E,F

Table A is the Master Table and other 5 tables store the other related records.
The MainPage that loads, shows a List of records in the Master Table, with links to Table B,C,D,E,F inline.
Now when the user clicks on the inline hyperlinks to these tables, the page view changes. Now to Change to the other table, one has to first click on "Back to Master Table" on the top, then search for the record which was being edited, and then click on the hyperlink for the other table.
So in all, to edit all the tables, one has to always go back to the main page, search for the same record (out of a huge list ) and then select the other link.
So when viewing the records for Tables B,C,D,E,F, can the links to these tables be added on the top of the page so that user stays on the same master record itself and not keep on jumping to the main page again and again.
Is this possible? or is there any other alternative of doing this?

I hope i am able to convey myself clearly.
I wanted that when the other Tables (Table B,C,D,E,F) are being viewed or edited, the user should not go back to the mainpage (which lists around 50-60 records. The selected record gets lost. One has to search again for the same). He should be able to directly jump to the other tables of the selected main record.
Menu is also an option, but when you click on the Menu link for Tables B,C,D,E,F, it lists down all the records.
Best Regards

VK Sharma
V
 		vksharma author 12/26/2010

Hi,
Now i am beginning to think, this cannnot be done via PHPRunner. Not a single reply.
Can somebody at least reply back and tell me whether its possible to do this or not?
Regards

VK
J
 		Jane 12/27/2010

Hi,
you can create these links manually in eh custom events (Insert PHP code snippet option on theVisual Editor tab).

Here is just a sample:

global $strTableName;

if (@$_SESSION[$strTableName."_masterkey1"])

echo "<a href=\"C_list.php?mastertable=A&masterkey1=".$_SESSION[$strTableName."_masterkey1"]."\">Link to C</a>";


Also you can turn on 'show detail tables' option on the add, edit, view pages on theTable link properties dialog on theDatasource tables tab and edit records from all detail tables on the same master add/edit/view page.
V
 		vksharma author 12/27/2010

Thanks. It seems to be working fine. But partially. Links to Table B,C,D,E,F are working fine. But the "Back to Master Table" takes it back to the main page whare the complete list of records is there. I tried the same snippet for Table A, but it does not seem to work.
How can i redirect the user to the Table A record with a specific record only? Or can i redirect to the search page with the primary key filled in?
V
 		velveteen 12/27/2010



So when viewing the records for Tables B,C,D,E,F, can the links to these tables be added on the top of the page so that user stays on the same master record itself and not keep on jumping to the main page again and again.


You can edit the masterlist file in Visual Editor or you can use iframe if you just need to display the master table in your detail tables.
V
 		vksharma author 12/27/2010

Thanks velveteen,
But solution provided by Jane is working fine, except for the Table A records.

When the user is on list page of Tables B,C,D,E,F, i want the user to directly be able to jump to the Table A showing only the specific record.
Regards
J
 		Jane 12/28/2010

Hi,
you can change 'back to list' links on another pages manually and point it to the main page.

Actual code is dependent on your database structure.
You can publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with detail description of what you want to achieve and I'll help you with sample code.
V
 		vksharma author 12/28/2010

Hi Jane,
Project uploaded. But it shows "Account is awaiting verification. We have sent you the verification instructions to your email address.".
However no mail was recieved in the email account.
Regards