Variables | |
| global | $aTitles |
| $aDataX = array() | |
| $aDataY = array() | |
| $sTime_from = date( "Y-m-d H:i:s", strtotime( oxConfig::getParameter( "time_from"))) | |
| $sTime_to = date( "Y-m-d H:i:s", strtotime( oxConfig::getParameter( "time_to"))) | |
| $sSQL | |
| $rs = oxDb::getDb()->execute( $sSQL) | |
| else | $graph = new PieGraph(600, 600) |
| $bplot = new PiePlot3D($aDataX) | |
| $iUserCount = 0 | |
| $aDataY [$iCtr] = " - ".$aDataX[$iCtr]." Kund." | |
| $aDataX = array() |
| $aDataY[$iCtr] = " - ".$aDataX[$iCtr]." Kund." |
| $aDataY = array() |
| global $aTitles |
| $bplot = new PiePlot3D($aDataX) |
| else $graph = new PieGraph(600, 600) |
| $iUserCount = 0 |
| $rs = oxDb::getDb()->execute( $sSQL) |
| $sSQL |
Initial value:
"SELECT oxgroups.oxtitle, count(oxuser.oxid) FROM oxobject2group, oxuser, oxgroups WHERE oxobject2group.oxobjectid = oxuser.oxid AND oxobject2group.oxgroupsid = oxgroups.oxid GROUP BY oxobject2group.oxgroupsid ORDER BY oxobject2group.oxgroupsid"
| $sTime_from = date( "Y-m-d H:i:s", strtotime( oxConfig::getParameter( "time_from"))) |
| $sTime_to = date( "Y-m-d H:i:s", strtotime( oxConfig::getParameter( "time_to"))) |
1.5.5