protected function getYear()
    {
        $arrYear = array();
        $objYear = \Database::getInstance()->prepare("SELECT
                                                        FROM_UNIXTIME(`tstamp`,'%Y')  AS Y
                                                      , COUNT(`id`) AS SUMDL
                                                      FROM `tl_dlstatdets`
                                                      WHERE 1
                                                      GROUP BY Y
                                                      ORDER BY Y DESC")
                                           ->limit(12)
                                           ->execute();
        $intRows = $objYear->numRows;
        if ($intRows>0)
        {
            while ($objYear->next())
            {
                // Y, formatierte Zahl, unformatierte Zahl
                $arrYear[] = array($objYear->Y, $this->getFormattedNumber($objYear->SUMDL,0),$objYear->SUMDL );
            }
        }

        return $arrYear;
    }
protected function getYear()
    {
        $arrYear = array();
        $objYear = \Database::getInstance()->prepare("SELECT
                                                        FROM_UNIXTIME(`tstamp`,'%Y')  AS Y
                                                      , COUNT(`id`) AS SUMDL
                                                      FROM `tl_dlstatdets`
                                                      WHERE 1
                                                      GROUP BY Y
                                                      ORDER BY Y DESC")
                                           ->limit(12)
                                           ->execute();
        $intRows = $objYear->numRows;
        if ($intRows>0)
        {
            while ($objYear->next())
            {
                // Y, formatierte Zahl, unformatierte Zahl
                $arrYear[] = array($objYear->Y, $this->getFormattedNumber($objYear->SUMDL,0),$objYear->SUMDL );
            }
        }

        return $arrYear;
    }
protected function getYear ( ) { $ arrYear = array ( ) ; $ objYear = \ Database :: getInstance ( ) -> prepare ( "SELECT
                                                        FROM_UNIXTIME(`tstamp`,'%Y')  AS Y
                                                      , COUNT(`id`) AS SUMDL
                                                      FROM `tl_dlstatdets`
                                                      WHERE 1
                                                      GROUP BY Y
                                                      ORDER BY Y DESC" ) -> limit ( 12 ) -> execute ( ) ; $ intRows = $ objYear -> numRows ; if ( $ intRows > 0 ) { while ( $ objYear -> next ( ) ) { // Y, formatierte Zahl, unformatierte Zahl $ arrYear [ ] = array ( $ objYear -> Y , $ this -> getFormattedNumber ( $ objYear -> SUMDL , 0 ) , $ objYear -> SUMDL ) ; } } return $ arrYear ; }
Years Statistic, last 12 years
@return array
Years Statistic last 12 years