='".$_SESSION['inDateFrom']." 00:00:00' and DRD_AUDIT_DATE<='".$_SESSION['inDateTo']." 23:59:59' union select DRD_VALUE,DRD_AUDIT_DATE from seg_dev_resources_det_his where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$_GET['dev']." and DRD_AUDIT_DATE>='".$_SESSION['inDateFrom']." 00:00:00' and DRD_AUDIT_DATE<='".$_SESSION['inDateTo']." 23:59:59') tb order by DRD_AUDIT_DATE"); else $wynik = mysql_query("select DRD_VALUE,DRD_AUDIT_DATE from viw_dev_resources_det where DRD_RESOURCES_DETAIL=210 and DRD_DRS_ID=".$_GET['dev']." and DRD_AUDIT_DATE>='".$_SESSION['inDateFrom']." 00:00:00' and DRD_AUDIT_DATE<='".$_SESSION['inDateTo']." 23:59:59' order by DRD_AUDIT_DATE"); if($wynik)while ($r = mysql_fetch_array($wynik)) { $res[]=array( 'water_value' => $r["DRD_VALUE"], 'water_time' => $r["TM"], 'water_audit' => $r["DRD_AUDIT_DATE"], 'water_x' =>'' ); $x[] = ''; $y[] = -($r["DRD_VALUE"]); } unset($_SESSION['site404chart_array']); unset($_SESSION['site402chart_x']); unset($_SESSION['site402chart_y']); $_SESSION['site404chart_array']=$res; $_SESSION['site402chart_x']=$x; $_SESSION['site402chart_y']=$y; } /* Create and populate the pData object */ $MyData = new pData(); $MyData->addPoints($_SESSION['site402chart_x'],"Labels"); $MyData->addPoints($_SESSION['site402chart_y'],"VALUE"); $MyData->setAxisDisplay(0,AXIS_FORMAT_CURRENCY); $MyData->setSerieDescription("Labels","Time"); $MyData->setAbscissa("Labels"); $MyData->setPalette("VALUE",array("R"=>55,"G"=>91,"B"=>127)); /* Create the pChart object */ //$myPicture = new pImage(700,230,$MyData); $myPicture = new pImage(960,500,$MyData); $myPicture->drawGradientArea(0,0,960,500,DIRECTION_VERTICAL,array("StartR"=>220,"StartG"=>220,"StartB"=>220,"EndR"=>255,"EndG"=>255,"EndB"=>255,"Alpha"=>100)); $myPicture->drawRectangle(0,0,959,499,array("R"=>200,"G"=>200,"B"=>200)); /* Write the picture title */ $myPicture->setFontProperties(array("FontName"=>"./fonts/calibri.ttf","FontSize"=>11)); $myPicture->drawText(390,40,$lab_Field_site404_002,array("FontSize"=>16,"Align"=>TEXT_ALIGN_BOTTOMLEFT)); /* Do some cosmetic and draw the chart */ $myPicture->setGraphArea(60,60,930,460); $myPicture->drawFilledRectangle(60,60,930,460,array("R"=>255,"G"=>255,"B"=>255,"Surrounding"=>-200,"Alpha"=>10)); $myPicture->drawScale(array("GridR"=>180,"GridG"=>180,"GridB"=>180)); /* Draw a spline chart on top */ $myPicture->setFontProperties(array("FontName"=>"./fonts/pf_arma_five.ttf","FontSize"=>6)); //$myPicture->drawFilledSplineChart(); $myPicture->drawSplineChart(); $myPicture->setShadow(FALSE); /* Write the chart legend */ //$myPicture->drawLegend(643,210,array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_HORIZONTAL)); /* Render the picture (choose the best way) */ $myPicture->Render($fileName); ?>
