statistic_main_ajax.php

Go to the documentation of this file.

<?php

class statistic_main_ajax extends ajaxListComponent
{
    protected $_aColumns = array( 'container1' => array(    // field , table,         visible, multilanguage, ident
                                        array( 'oxtitle', 'oxstat', 1, 0, 0 ),
                                        array( 'oxid',    'oxstat', 0, 0, 1 )
                                        ),
                                    'container2' => array(
                                        array( 'oxtitle',  'oxstat', 1, 0, 0 ),
                                        array( 'oxid',    'oxstat', 0, 0, 1 )
                                        )
                                );

    protected function _getData( $sCountQ, $sQ )
    {
        $aResponse['startIndex'] = $this->_getStartIndex();
        $aResponse['sort'] = '_' . $this->_getSortCol();
        $aResponse['dir']  = $this->_getSortDir();

        // all possible reports
        $aReports = oxSession::getVar( "allstat_reports" );
        $sSynchId = oxConfig::getParameter( "synchoxid" );
        $sOxId    = oxConfig::getParameter( "oxid" );

        $sStatId = $sSynchId?$sSynchId:$sOxId;
        $oStat = oxNew( 'oxstatistic' );
        $oStat->load( $sStatId );
        $aStatData = unserialize( $oStat->oxstatistics__oxvalue->value );

        $aData = array();
        $iCnt = 0;
        $oStr = getStr();

        // filter data
        $aFilter = oxConfig::getParameter( "aFilter" );
        $sFilter = (is_array( $aFilter ) && isset( $aFilter['_0'] ) )? $oStr->preg_replace( '/^\*/', '%', $aFilter['_0'] ) : null;

        foreach ( $aReports as $oReport ) {

            if ( $sSynchId ) {
                if ( is_array($aStatData) && in_array( $oReport->filename, $aStatData ) )
                    continue;
            } else {
                if ( !is_array( $aStatData ) ||  !in_array( $oReport->filename, $aStatData ) )
                    continue;
            }

            // checking filter
            if ( $sFilter && !$oStr->preg_match( "/^" . preg_quote( $sFilter ) . "/i", $oReport->name) ) {
                continue;
            }

            $aData[$iCnt]['_0'] = $oReport->name;
            $aData[$iCnt]['_1'] = $oReport->filename;
            $iCnt++;
        }

        // ordering ...
        if ( oxConfig::getParameter( "dir" ) ) {
            if ( 'asc' == oxConfig::getParameter( "dir" ) )
                usort( $aData, array( $this, "sortAsc" ) );
            else
                usort( $aData, array( $this, "sortDesc" ) );
        } else {
            usort( $aData, array( $this, "sortAsc" ) );
        }

        $aResponse['records'] = $aData;
        $aResponse['totalRecords'] = count( $aReports );

        return $aResponse;


    }

    public function sortAsc( $oOne, $oSec )
    {
        if ( $oOne['_0'] == $oSec['_0'] ) {
            return 0;
        }
        return ( $oOne['_0'] < $oSec['_0'] ) ? -1 : 1;
    }

    public function sortDesc( $oOne, $oSec )
    {
        if ( $oOne['_0'] == $oSec['_0'] ) {
            return 0;
        }
        return ( $oOne['_0'] > $oSec['_0'] ) ? -1 : 1;
    }


    public function removeReportFromList()
    {
        $aReports = oxSession::getVar( "allstat_reports" );
        $soxId    = oxConfig::getParameter( 'oxid');

        // assigning all items
        if ( oxConfig::getParameter( 'all' ) ) {
            $aStats = array();
            foreach ( $aReports as $oRep ) {
                $aStats[] = $oRep->filename;
            }
        } else {
            $aStats = $this->_getActionIds( 'oxstat.oxid' );
        }

        $oStat = oxNew( 'oxstatistic' );
        if ( is_array( $aStats ) && $oStat->load( $soxId ) ) {
            $aStatData = $oStat->getReports();

            // additional check
            foreach ( $aReports as $oRep ) {
                if ( in_array( $oRep->filename, $aStats ) && ($iPos = array_search( $oRep->filename, $aStatData ) ) !== false )
                    unset( $aStatData[$iPos] );
            }

            $oStat->setReports( $aStatData );
            $oStat->save();
        }
    }

    public function addReportToList()
    {
        $aReports = oxSession::getVar( "allstat_reports" );
        $soxId    = oxConfig::getParameter( 'synchoxid' );

        // assigning all items
        if ( oxConfig::getParameter( 'all' ) ) {
            $aStats = array();
            foreach ( $aReports as $oRep ) {
                $aStats[] = $oRep->filename;
            }
        } else {
            $aStats = $this->_getActionIds( 'oxstat.oxid' );
        }

        $oStat = oxNew( 'oxstatistic' );
        if ( $oStat->load( $soxId ) ) {
            $aStatData = (array) $oStat->getReports();


            // additional check
            foreach ( $aReports as $oRep ) {
                if ( in_array( $oRep->filename, $aStats ) && !in_array( $oRep->filename, $aStatData ) )
                    $aStatData[] = $oRep->filename;
            }

            $oStat->setReports( $aStatData );
            $oStat->save();
        }
    }
}