Radicore Forum - RDF feed
https://forum.radicore.org/index.php
Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7361&th=3447#msg_7361
........| | | | | |
Line 1 x x x o x o
Line 2 x o x x x o
...
The pipes are the headings 90° rotated. So I could generate my (Pivot-table) report on one page.]]>htManager2019-09-30T13:55:17-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7362&th=3447#msg_7362
AJM2019-10-01T08:42:13-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7364&th=3447#msg_7364
AJM2019-10-01T13:49:28-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7365&th=3447#msg_7365
htManager2019-10-02T09:33:29-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7366&th=3447#msg_7366
https://www.tonymarston.net/php-mysql/output-to-pdf.html#col umn.widths.list you will see that it is possible for column labels to overflow onto the next line if the text is too wide for the cell width. It is also possible to insert the "\n" (newline) character between each letter to force it to overflow. Unfortunately I cannot see a way to rotate the text through 90 degrees, so you will still read it vertically.]]>AJM2019-10-03T09:26:20-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7369&th=3447#msg_7369
htManager2019-10-04T09:11:02-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7370&th=3447#msg_7370
In my pdf the 0 is always the presence of the first player in the first match. I think that I have to correct my SQL query in the controller script. Where can I dump the query result best?]]>htManager2019-10-05T15:51:38-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7371&th=3447#msg_7371
_cm_formatData() method which is the last method to be called before the data is passed to the PDF processor.]]>AJM2019-10-06T07:51:04-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7377&th=3447#msg_7377
1. In the _cm_initialise() method I query my table to find all relevant players and insert these as an array in $GLOBALS['']
2. In the _cm_formatData() method I now can investigate if the player was present or not present at the match. I do this with x or blank.
What I do not know is where to place best the code for the 90° heading variables as you told me with the "\n" character. I have seen that I can create the headings with variables like $structure['body']['fields'][] = array('spiele_anwesenheit_status_ausgabe' => $GLOBALS['Spielername01']);
The problem is that obviously the report structure file is called before the _cm_initialise() method so that the variable $GLOBALS['Spielername01'] is empty. The UML diagrams don't show the output pattern sequences. Can you tell me how I can solve this problem?]]>htManager2019-10-18T16:38:37-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7378&th=3447#msg_7378
https://www.tonymarston.net/php-mysql/output-to-pdf.html#tit le.contents - scroll down until you see you see the keyword "<text>" and the option for "%%<text>".]]>AJM2019-10-19T08:21:45-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7379&th=3447#msg_7379
In my controller script I first call a method in one of my library inc files and there I run the query to get the number of colums and there I can create the labels. All this data I write to §GLOBALS so that I can read in the values in the report structure file.]]>htManager2019-10-19T12:21:42-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7381&th=3447#msg_7381
AJM2019-10-20T09:02:19-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7382&th=3447#msg_7382
Do you have a documentation about the sequences of the methods?]]>htManager2019-10-21T08:53:52-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7383&th=3447#msg_7383
1) The report structure file is read into memory during execution of the initsession() function.
2) The following methods are called: $dbobject->initialise(), $dbobject->getExtraData(), $dbobject->getData_serial().
3) The PDF object is instantiated and the $pdf->outputPDF_ListView() method is called which has the following steps:
3.1) Call the $dbobject->_cm_pre_output() method.
3.2) Call the $pdf->listView() method which has the following steps:
3.2.1) Call $dbobject->fetchRow().
3.2.2) Call $dbobject->_cm_post_fetchRow().
3.3.3) Call $pdf->listView_print().
3.3.4) Call $dbobject->_cm_formatData().
3.3.5) Call $pdf->listView_assemble_row() for each column.
3.3.6) Call $pdf->printRow() to output the row to the PDF document, which calls the following at the start of each page:
3.3.6.1) Call $dbobject->_cm_ListView_header()
3.3.6.2) Call $pdf->Header() to print the page heading.
3.3.6.3) Output the column labels.
While testing this I discovered that the ability to use dynamic column labels was not available, so I have amended std.pdf_list.class.inc (which is attached) to add this ability. To use this feature you need to do the following:
a) In your report structure file change the column label from a literal to '%%id' where 'id' is the label identity.
b) In your object's _cm_ListView_header() method (see step 3.3.6.1 above) insert code similar to the following:
This will then enable the step at 3.3.6.3 (which I have amended) to replace '%%id' with 'whatever'.
Try it and see.]]>AJM2019-10-22T11:14:14-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7384&th=3447#msg_7384
htManager2019-10-23T20:53:25-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7385&th=3447#msg_7385
AJM2019-10-25T08:37:07-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7386&th=3447#msg_7386
http://forum.radicore.org/index.php?t=getfile&id=558& ;]]>htManager2019-10-25T11:49:26-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7387&th=3447#msg_7387
AJM2019-10-26T08:45:59-00:00Re: Output2 - Options / 90° cell rotation
https://forum.radicore.org/index.phpindex.php?t=rview&goto=7394&th=3447#msg_7394
My problem now is that I have the same value in all coloumns.
In the cm_formatData() method I can collect the data for the row by an array. But how to send them to the report? Is there a possibility such as for the header columns like "$this->dynamic_column_headings = array('id' => 'whatever');"?
But I think I do not know how it definitely works. In my report body there is always the same field specified. So it should be always the same value....