report_user_per_group.php

Go to the documentation of this file.

<?php

if ( !class_exists( "report_user_per_group")) {
class Report_user_per_group extends report_base
{
    protected $_sThisTemplate = "report_user_per_group.tpl";

    public function drawReport()
    {
        $sQ = "SELECT 1 FROM oxobject2group, oxuser, oxgroups
               WHERE oxobject2group.oxobjectid = oxuser.oxid AND
               oxobject2group.oxgroupsid = oxgroups.oxid";
        return oxDb::getDb()->getOne( $sQ );
    }

    public function user_per_group()
    {
        $myConfig = $this->getConfig();
        $oDb = oxDb::getDb();

        global $aTitles;

        $aDataX = array();
        $aDataY = array();

        $sSQL = "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";

        $rs = $oDb->execute( $sSQL);
        if ($rs != false && $rs->recordCount() > 0) {
            while (!$rs->EOF) {
                if ( $rs->fields[1]) {
                    $aDataX[] = $rs->fields[1];
                    $aDataY[] = $rs->fields[0];
                }
                $rs->moveNext();
            }
        }

        header ("Content-type: image/png" );

        // New graph with a drop shadow
        if (count($aDataX) > 10)
            $graph = new PieGraph(800, 830);
        else
            $graph = new PieGraph(600, 600);

        $graph->setBackgroundImage( $myConfig->getAbsAdminImageDir()."/reportbgrnd.jpg", BGIMG_FILLFRAME);
        $graph->setShadow();

        // Set title and subtitle
        //$graph->title->set($this->aTitles[$myConfig->getConfigParam( 'iAdminLanguage' ) ]);
        $graph->title->set($this->aTitles[oxLang::getInstance()->getObjectTplLanguage() ]);

        // Use built in font
        $graph->title->setFont(FF_FONT1, FS_BOLD);

        // Create the bar plot
        $bplot = new PiePlot3D($aDataX);

        $bplot->setSize(0.4);
        $bplot->setCenter(0.5, 0.32);

        // explodes all chunks of Pie from center point
        $bplot->explodeAll(10);
        $iUserCount = 0;
        foreach ($aDataX as $iVal)
            $iUserCount += $iVal;
        for ($iCtr = 0; $iCtr < count($aDataX); $iCtr++) {
            $iSLeng = strlen($aDataY[$iCtr]);
            if ($iSLeng > 20) {
                if ($iSLeng > 23)
                    $aDataY[$iCtr] = trim(substr($aDataY[$iCtr], 0, 20))."...";

            }
            $aDataY[$iCtr] .= " - ".$aDataX[$iCtr]." Kund.";
        }
        $bplot->setLegends($aDataY);

        if (count($aDataX) > 10) {
            $graph->legend->pos(0.49, 0.66, 'center');
            $graph->legend->setFont(FF_FONT0, FS_NORMAL);
            $graph->legend->setColumns(4);
        } else {
            $graph->legend->pos(0.49, 0.70, 'center');
            $graph->legend->setFont(FF_FONT1, FS_NORMAL);
            $graph->legend->setColumns(2);
        }

        $graph->add($bplot);

        // Finally output the  image
        $graph->stroke();
    }
}
}