Radicore Forum: Transaction Patterns » Output 3

Home » RADICORE development » Transaction Patterns » Output 3 - _cm_output_multi()

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

Re: Output 3 - _cm_output_multi() [message #7633 is a reply to message #7632]

Tue, 10 August 2021 06:34

htManager
Messages: 434
Registered: May 2014

Senior Member

Sorry for confusing you. Probably this is because of my knowledge and the language. Sorry.

I try to explain it better:

The LIST2 screen has the outer entity orga_spiele which holds all the games/matches. The inner entity is orga_spiele_anwesenheit which holds the team members. In the team members table are fields where I can choose if the member participates in this match or not. Additionally there is a field where I can choose the position of the player in the game.

The OUTPUT3 task has the name orga_spiele_anwesenheit_einzel_position and is defined as subclass of orga_spiele and extends orga_spiele (as defined in the orga_spiele_anwesenheit_einzel_position.class.inc).

In the orga_spiele_anwesenheit_einzel_position(output3).php my $table_id is 'orga_spiele_anwesenheit_einzel_position' and $sql_from is 'orga_spiele' with two LEFT JOINS on related tables for getting information for the title.

If I now press the OUTPUT3 task in the LIST2 screen $where in _cm_initialise() in orga_spiele_anwesenheit_einzel_position.class.inc passes down the primary key fields and the primary key values of the inner table not of the outer table. The $selection string passes (correctly) down all selected occurences of the inner table (orga_spiele_anwesenheit).

I have a primary key consisting of 6 fields and the fields are normally different in each table as you advised in one of your articles to make it easier to identify the table fields. I use the following code to change the $where string in _cm_initialise() of orga_spiele_anwesenheit_einzel_position.class.inc:

$where = str_replace('spiele_anwesenheit_verbaende_art_id=', 'verbaende_art_id=', $where);
$where = ..... (for all 6 fields)

This works fine.

In the _cm_output_multi() method I am accessing the inner table (orga_spiele_anwesenheit) again to get the available players for the different positions. For better understanding I attached the output3 pdf file. Maybe you can better see what is wrong in my logic. As you can see each multi zone contains the available team members for this position.

Attachment: Output3.pdf
(Size: 330.83KB, Downloaded 285 times)

Report message to a moderator

[Message index]

		Output 3 - _cm_output_multi() By: htManager on Tue, 03 August 2021 16:14
		Re: Output 3 - _cm_output_multi() By: htManager on Wed, 04 August 2021 05:21
		Re: Output 3 - _cm_output_multi() By: AJM on Wed, 04 August 2021 05:22
		Re: Output 3 - _cm_output_multi() By: htManager on Wed, 04 August 2021 06:19
		Re: Output 3 - _cm_output_multi() By: AJM on Thu, 05 August 2021 04:57
		Re: Output 3 - _cm_output_multi() By: AJM on Thu, 05 August 2021 05:03
		Re: Output 3 - _cm_output_multi() By: htManager on Thu, 05 August 2021 11:50
		Re: Output 3 - _cm_output_multi() By: AJM on Thu, 05 August 2021 13:46
		Re: Output 3 - _cm_output_multi() By: htManager on Fri, 06 August 2021 05:06
		Re: Output 3 - _cm_output_multi() By: AJM on Sat, 07 August 2021 05:16
		Re: Output 3 - _cm_output_multi() By: htManager on Sat, 07 August 2021 05:45
		Re: Output 3 - _cm_output_multi() By: AJM on Sun, 08 August 2021 06:00
		Re: Output 3 - _cm_output_multi() By: htManager on Sun, 08 August 2021 07:31
		Re: Output 3 - _cm_output_multi() By: htManager on Mon, 09 August 2021 04:07
		Re: Output 3 - _cm_output_multi() By: AJM on Tue, 10 August 2021 04:33
		Re: Output 3 - _cm_output_multi() By: htManager on Tue, 10 August 2021 06:34
		Re: Output 3 - _cm_output_multi() By: AJM on Wed, 11 August 2021 05:04
		Re: Output 3 - _cm_output_multi() By: htManager on Wed, 11 August 2021 16:09
		Re: Output 3 - _cm_output_multi() By: AJM on Thu, 12 August 2021 05:04
		Re: Output 3 - _cm_output_multi() By: htManager on Sat, 14 August 2021 04:26
		Re: Output 3 - _cm_output_multi() By: AJM on Sat, 14 August 2021 04:56
		Re: Output 3 - _cm_output_multi() By: htManager on Tue, 17 August 2021 06:54
		Re: Output 3 - _cm_output_multi() By: htManager on Mon, 30 August 2021 09:52
		Re: Output 3 - _cm_output_multi() By: AJM on Tue, 31 August 2021 04:52
		Re: Output 3 - _cm_output_multi() By: htManager on Thu, 02 September 2021 11:34
		Re: Output 3 - _cm_output_multi() By: AJM on Fri, 03 September 2021 04:48
		Re: Output 3 - _cm_output_multi() By: htManager on Sun, 24 October 2021 05:40
		Re: Output 3 - _cm_output_multi() By: AJM on Mon, 25 October 2021 04:47
		Re: Output 3 - _cm_output_multi() By: htManager on Mon, 25 October 2021 06:36
		Re: Output 3 - _cm_output_multi() By: AJM on Tue, 26 October 2021 04:37
		Re: Output 3 - _cm_output_multi() By: htManager on Tue, 26 October 2021 06:29
		Re: Output 3 - _cm_output_multi() By: AJM on Wed, 27 October 2021 04:37

Previous Topic:	POPUP3 not working
Next Topic:	Tree structure with more than one table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Nov 24 20:00:07 EST 2024

Total time taken to generate the page: 0.01417 seconds