Attachment 718 Details for Bug 1796 – Code for testing the bug

Steema Issues Database

Note: This database is for bugs and wishes only. For technical support help, if you are a customer please visit our online forums;
otherwise you can use StackOverflow.
Before using this bug-tracker we recommend a look at this document, Steema Bug Fixing Policy.

Code for testing the bug

steema_bug.php (text/plain), 4.73 KB, created by Jayme Jeffman on 2017-02-22 09:06:17 EST

(hide)

Description:

Filename:

MIME Type:

Creator: Jayme Jeffman

Created: 2017-02-22 09:06:17 EST

Size: 4.73 KB

patch

obsolete

><?php
> require "../../../TeeChart/sources/libTeeChart.php"; // Please change the path to your server configuration
> echo 'Bug test on Series::AddXY(X,Y) when X is a datetime value ' ;
> $myconn = oci_connect ( 'scott', 'tiger' , '<put your database alias>', 'UTF8' ); // , 'UTF8'
> if($myconn){
> echo 'Database connected ';
> $query = "SELECT
> TO_DATE('2017-02-21 '||LPAD(floor(dbms_random.value(1,23)),2,'0')||':00:00','yyyy-mm-dd hh24:mi:ss') as \"DateTime\"
> ,dbms_random.value(1,1000) AS \"Value\"
> FROM emp
> ORDER BY 1";
> /* The query above has produced the result
>
> DateTime Value
> -------- ----------
> 21/02/17 | 36,22417599363154034249430761191086202984
> 21/02/17 | 939,050932712273081747156702453927007765
> 21/02/17 | 66,30268231669319520382562613850342936765
> 21/02/17 | 990,88988261309141129381290675088796866
> 21/02/17 | 252,7208228999164127845527871787031687
> 21/02/17 | 372,177033066411689788848248546958427652
> 21/02/17 | 670,297660308266335012813864384792396698
> 21/02/17 | 326,796883873306524759483243164353912582
> 21/02/17 | 349,196079996301337022906354121160159067
> 21/02/17 | 943,396795442935115280112685126460693133
> 21/02/17 | 430,571747696456911178612746910514144808
> 21/02/17 | 437,629339403838728061821150824702012221
> 21/02/17 | 989,371894739617425572382394164650584703
> 21/02/17 | 422,942670088729252749074209400600892727
>
> 14 lines selected.
>
> So as the Date Time value is constant we need to change the query to give
> the complete DateTime values
> */
> $query = "SELECT
> TO_CHAR(TO_DATE('2017-02-21 '||LPAD(floor(dbms_random.value(1,23)),2,'0')||':00:00','yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss') as \"DateTime\"
> ,dbms_random.value(1,1000) AS \"Value\"
> FROM emp";
> /* So now we have got DateTime values as needed
> 2017-02-21 10:00:00 | 591,486996579436091000377693125320845806
> 2017-02-21 11:00:00 | 368,460016432934966079584408101249136203
> 2017-02-21 06:00:00 | 279,593678893800941747034416052036284042
> 2017-02-21 19:00:00 | 81,83458395943664944214456055490706202376
> 2017-02-21 05:00:00 | 686,578932184691256002101371846375637466
> 2017-02-21 02:00:00 | 959,922424159032207518612312628828129854
> 2017-02-21 01:00:00 | 615,969883097359088031942091517947684371
> 2017-02-21 13:00:00 | 198,874158955132877069986263728652080193
> 2017-02-21 16:00:00 | 729,389294887961056633858821861401465069
> 2017-02-21 15:00:00 | 836,638044280001441732146060337824249098
> 2017-02-21 22:00:00 | 289,747077343583017348549901506824409172
> 2017-02-21 20:00:00 | 938,057847655920309990719903196067787185
> 2017-02-21 12:00:00 | 80,96344218812401210167196846775179156687
> 2017-02-21 12:00:00 | 606,347361571242562127564460918661291575
>
> No matter there are values on the same DateTime thus we can use them
> for the purpose of showing the issue at Series::AddXY.
> */
>
> $stmt = oci_parse($myconn, $query );
> if($stmt){
> echo $query.' ';
> $r = oci_execute($stmt);
> if($r){
> // Create the TChart object
> $tchart = new TChart(800,450);
> $tchart->getAspect()->setView3D(true);
> $tchart->getChart()->getAspect()->setChart3DPercent(5);
>
> $tchart->getAxes()->setVisible(true);
> $tchart->getLegend()->setLegendStyle(1);
> $tchart->getLegend()->setAlignment(3) ; // Bottom
> $tchart->getChart()->getAxes()->getBottom()->getLabels()->setAngle(90);
> $tchart->getChart()->getAxes()->getBottom()->getLabels()->setRoundFirstLabel(false);
> $tchart->getChart()->getAxes()->getBottom()->getLabels()->setDateTimeFormat('Y-m-d H');
> $tchart->getAxes()->getBottom()->setAutomatic(true);
> $tchart->getAxes()->getBottom()->setIncrement(3600.0); // Increment eh numero de segundos !!!!
>
> $line = new Line($tchart->getChart());
> $tchart->getChart()->getSeries(0)->getXValues()->setDateTime(true); // Eixo X sÃ£o DateTime
> $line->getLinePen()->setWidth(3);
>
> while(($row = oci_fetch_array($stmt, OCI_ASSOC)) != false ){
> echo $row["DateTime"].' | '. $row["Value"].' ';
> $thetime = DateTime::createFromFormat('Y-m-d H:i:s', $row["DateTime"]);
> if($thetime) $tchart->getChart()->getSeries(0)->addXY( $thetime->getTimestamp() , $row["Value"] );
> }
>
> $tchart->render("bug_test.png") ;
> echo '<img src="bug_test.png" alt="" />';
> }
> oci_free_statement($stmt);
> }
>
> }
> ?>

Actions: View

Attachments on bug 1796: 718 | 719 | 720