Radicore Forum: How To » get calculated field from parent table

Home » RADICORE » How To » get calculated field from parent table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

get calculated field from parent table [message #1947]

Mon, 09 February 2009 13:23

ikatz
Messages: 40
Registered: December 2007
Location: Durham, NH

Member

I have a table of people called "person", which lists contact information. I have a table called "staff", which associates a person_id with some job-specific data (their position, work phone number, etc).

For my staff table, Radicore's dictionary calculates a person_name from from the foreign key person_id, and this name appears in all the staff screens instead of the number. This is good.

I would also like to use the person_name value in place of staff_id for all the screens that have staff_id as a foreign key. But, the dict file alone can't do this. What is the best way to accomplish this in Radicore?

I assume I have to do something with an instance of the person table in the _cm_getExtraData method of the staff table's class... but I can't seem to figure it out.

Report message to a moderator

Re: get calculated field from parent table [message #1948 is a reply to message #1947]

Mon, 09 February 2009 17:29

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

Let's see if I've got this straight - you have a table (let's call it 'x') with a foreign key called 'staff_id' which points to an entry on the 'staff' table. The 'staff' table contains a foreign key called 'person_id' which points to an entry on the 'person' table. The 'person' table contains a column called 'person_name'.

This means that when you read a row from table 'x' you want to read table 'staff' then table 'person' in order to fetch the 'person_name' column.

In this case the relationship between the 'person' table and the 'staff' table should be defined in the dictionary so that 'person_name' is the parent field. This means that when an occurrence of the 'staff' table is retrieved the framework will automatically JOIN to the parent 'person' table and bring back the value for 'person_name'.

In your _cm_getExtraData() method for table 'x' you will need code simiar to the following:

Code: [Select all] [Show/ hide]

if (empty($fieldarray['person_name']) AND !empty($fieldarray['staff_id'])) }
    $dbobject =& singleton::getInstance('staff');
    $data = $dbobject->getData("staff_id='{$fieldarray['staff_id']}'");
    $fieldarray['person_name'] = $data[0]['person_name'];
} // if

Try it and see.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: get calculated field from parent table [message #1949 is a reply to message #1948]

Mon, 09 February 2009 19:48

ikatz
Messages: 40
Registered: December 2007
Location: Durham, NH

Member

Aah, that works perfectly.

My mistake was in trying to do this from the staff table's class.

Report message to a moderator

Re: get calculated field from parent table [message #1950 is a reply to message #1949]

Tue, 10 February 2009 05:10

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

It's no good putting the right code in the wrong place. Sad

The big trick is knowing what code to put where so that it gets executed at the right time. Once you have mastered that you will find that anything is possible with the Radicore framework. Smile

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Previous Topic:	How to make a list2 on a non existing child table
Next Topic:	Dynamically generate pdf layout?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Jul 10 07:04:41 EDT 2025

Total time taken to generate the page: 0.19193 seconds