models/i18n/translator.php
public function getStats( $instance, $parent_instance )
	{
		$parent_instance_sql     = '';
		$parent_instance_sub_sql = 'm.instance = ? OR t.instance = ?';
		if ( $parent_instance )
		{
			$parent_instance_sql = ' OR instance IS NULL ';
			$parent_instance_sub_sql = '( m.instance = ? OR m.instance IS NULL ) AND ( t.instance = ? OR t.instance IS NULL )';
		}

		$sql = <<<TRANSLATIONS
SELECT
	l.english_name,
	l.lang,
	lc.local_name AS name,
	@lang 			:= l.lang AS lang,
	@translated 	:= (SELECT COUNT(*) FROM i18n_translations WHERE ( instance = ? $parent_instance_sql ) AND lang = @lang AND translation != '' AND translation IS NOT NULL ) AS total_translated,
	@total 			:=  (SELECT COUNT(DISTINCT(m.id)) FROM i18n_messages m LEFT JOIN i18n_translations t ON m.id=t.id_message AND t.lang = @lang WHERE $parent_instance_sub_sql ) AS total,
	ROUND( ( @translated / @total) * 100, 2 ) AS percent,
	( @total - @translated ) AS missing
FROM
	i18n_languages l
	LEFT JOIN i18n_language_codes lc ON l.lang = lc.l10n
ORDER BY
	percent DESC, english_name ASC
TRANSLATIONS;

		return $this->GetArray( $sql, array(
		                                   'tag' => 'Get current stats',
		                                   $instance,
		                                   $instance,
		                                   $instance,
		                                   $instance,
		                                   $instance
		                              ) );
	}
public function getStats( $instance, $parent_instance )
	{
		$parent_instance_sql     = '';
		$parent_instance_sub_sql = 'm.instance = ? OR t.instance = ?';
		if ( $parent_instance )
		{
			$parent_instance_sql = ' OR instance IS NULL ';
			$parent_instance_sub_sql = '( m.instance = ? OR m.instance IS NULL ) AND ( t.instance = ? OR t.instance IS NULL )';
		}

		$sql = <<<TRANSLATIONS
SELECT
	l.english_name,
	l.lang,
	lc.local_name AS name,
	@lang 			:= l.lang AS lang,
	@translated 	:= (SELECT COUNT(*) FROM i18n_translations WHERE ( instance = ? $parent_instance_sql ) AND lang = @lang AND translation != '' AND translation IS NOT NULL ) AS total_translated,
	@total 			:=  (SELECT COUNT(DISTINCT(m.id)) FROM i18n_messages m LEFT JOIN i18n_translations t ON m.id=t.id_message AND t.lang = @lang WHERE $parent_instance_sub_sql ) AS total,
	ROUND( ( @translated / @total) * 100, 2 ) AS percent,
	( @total - @translated ) AS missing
FROM
	i18n_languages l
	LEFT JOIN i18n_language_codes lc ON l.lang = lc.l10n
ORDER BY
	percent DESC, english_name ASC
TRANSLATIONS;

		return $this->GetArray( $sql, array(
		                                   'tag' => 'Get current stats',
		                                   $instance,
		                                   $instance,
		                                   $instance,
		                                   $instance,
		                                   $instance
		                              ) );
	}
public function getStats ( $ instance , $ parent_instance ) { $ parent_instance_sql = '' ; $ parent_instance_sub_sql = 'm.instance = ? OR t.instance = ?' ; if ( $ parent_instance ) { $ parent_instance_sql = ' OR instance IS NULL ' ; $ parent_instance_sub_sql = '( m.instance = ? OR m.instance IS NULL ) AND ( t.instance = ? OR t.instance IS NULL )' ; } $ sql =  <<<TRANSLATIONS
SELECT
	l.english_name,
	l.lang,
	lc.local_name AS name,
	@lang 			:= l.lang AS lang,
	@translated 	:= (SELECT COUNT(*) FROM i18n_translations WHERE ( instance = ? $parent_instance_sql ) AND lang = @lang AND translation != '' AND translation IS NOT NULL ) AS total_translated,
	@total 			:=  (SELECT COUNT(DISTINCT(m.id)) FROM i18n_messages m LEFT JOIN i18n_translations t ON m.id=t.id_message AND t.lang = @lang WHERE $parent_instance_sub_sql ) AS total,
	ROUND( ( @translated / @total) * 100, 2 ) AS percent,
	( @total - @translated ) AS missing
FROM
	i18n_languages l
	LEFT JOIN i18n_language_codes lc ON l.lang = lc.l10n
ORDER BY
	percent DESC, english_name ASC
TRANSLATIONS ; return $ this -> GetArray ( $ sql , array ( 'tag' => 'Get current stats' , $ instance , $ instance , $ instance , $ instance , $ instance ) ) ; }
Get stats of translations.

@return array
Get stats of translations .