public function fromPot(Translations $pot, LocaleEntity $locale)
    {
        $cn = $this->app->make(EntityManager::class)->getConnection();
        $po = clone $pot;
        $po->setLanguage($locale->getID());
        $numPlurals = $locale->getPluralCount();
        $searchQuery = $cn->prepare('
            select
                CommunityTranslationTranslations.*
            from
                CommunityTranslationTranslatables
                inner join CommunityTranslationTranslations on CommunityTranslationTranslatables.id = CommunityTranslationTranslations.translatable
            where
                CommunityTranslationTranslations.locale = ' . $cn->quote($locale->getID()) . '
                and CommunityTranslationTranslations.current = 1
                and CommunityTranslationTranslatables.hash = ?
            limit 1
        ')->getWrappedStatement();
        foreach ($po as $translationKey => $translation) {
            $plural = $translation->getPlural();
            $hash = md5(($plural === '') ? $translationKey : "$translationKey\005$plural");
            $searchQuery->execute([$hash]);
            $row = $searchQuery->fetch();
            $searchQuery->closeCursor();
            if ($row !== false) {
                $translation->setTranslation($row['text0']);
                if ($plural !== '') {
                    switch ($numPlurals) {
                        case 6:
                            $translation->setPluralTranslation($row['text5'], 4);
                            /* @noinspection PhpMissingBreakStatementInspection */
                        case 5:
                            $translation->setPluralTranslation($row['text4'], 3);
                            /* @noinspection PhpMissingBreakStatementInspection */
                        case 4:
                            $translation->setPluralTranslation($row['text3'], 2);
                            /* @noinspection PhpMissingBreakStatementInspection */
                        case 3:
                            $translation->setPluralTranslation($row['text2'], 1);
                            /* @noinspection PhpMissingBreakStatementInspection */
                        case 2:
                            $translation->setPluralTranslation($row['text1'], 0);
                            /* @noinspection PhpMissingBreakStatementInspection */
                            break;
                    }
                }
            }
        }

        return $po;
    }
public function fromPot(Translations $pot, LocaleEntity $locale)
    {
        $cn = $this->app->make(EntityManager::class)->getConnection();
        $po = clone $pot;
        $po->setLanguage($locale->getID());
        $numPlurals = $locale->getPluralCount();
        $searchQuery = $cn->prepare('
            select
                CommunityTranslationTranslations.*
            from
                CommunityTranslationTranslatables
                inner join CommunityTranslationTranslations on CommunityTranslationTranslatables.id = CommunityTranslationTranslations.translatable
            where
                CommunityTranslationTranslations.locale = ' . $cn->quote($locale->getID()) . '
                and CommunityTranslationTranslations.current = 1
                and CommunityTranslationTranslatables.hash = ?
            limit 1
        ')->getWrappedStatement();
        foreach ($po as $translationKey => $translation) {
            $plural = $translation->getPlural();
            $hash = md5(($plural === '') ? $translationKey : "$translationKey\005$plural");
            $searchQuery->execute([$hash]);
            $row = $searchQuery->fetch();
            $searchQuery->closeCursor();
            if ($row !== false) {
                $translation->setTranslation($row['text0']);
                if ($plural !== '') {
                    switch ($numPlurals) {
                        case 6:
                            $translation->setPluralTranslation($row['text5'], 4);
                            /* @noinspection PhpMissingBreakStatementInspection */
                        case 5:
                            $translation->setPluralTranslation($row['text4'], 3);
                            /* @noinspection PhpMissingBreakStatementInspection */
                        case 4:
                            $translation->setPluralTranslation($row['text3'], 2);
                            /* @noinspection PhpMissingBreakStatementInspection */
                        case 3:
                            $translation->setPluralTranslation($row['text2'], 1);
                            /* @noinspection PhpMissingBreakStatementInspection */
                        case 2:
                            $translation->setPluralTranslation($row['text1'], 0);
                            /* @noinspection PhpMissingBreakStatementInspection */
                            break;
                    }
                }
            }
        }

        return $po;
    }
public function fromPot ( Translations $ pot , LocaleEntity $ locale ) { $ cn = $ this -> app -> make ( EntityManager :: class ) -> getConnection ( ) ; $ po = clone $ pot ; $ po -> setLanguage ( $ locale -> getID ( ) ) ; $ numPlurals = $ locale -> getPluralCount ( ) ; $ searchQuery = $ cn -> prepare ( '
            select
                CommunityTranslationTranslations.*
            from
                CommunityTranslationTranslatables
                inner join CommunityTranslationTranslations on CommunityTranslationTranslatables.id = CommunityTranslationTranslations.translatable
            where
                CommunityTranslationTranslations.locale = ' . $ cn -> quote ( $ locale -> getID ( ) ) . '
                and CommunityTranslationTranslations.current = 1
                and CommunityTranslationTranslatables.hash = ?
            limit 1
        ' ) -> getWrappedStatement ( ) ; foreach ( $ po as $ translationKey => $ translation ) { $ plural = $ translation -> getPlural ( ) ; $ hash = md5 ( ( $ plural === '' ) ? $ translationKey : "$translationKey\005$plural" ) ; $ searchQuery -> execute ( [ $ hash ] ) ; $ row = $ searchQuery -> fetch ( ) ; $ searchQuery -> closeCursor ( ) ; if ( $ row !== false ) { $ translation -> setTranslation ( $ row [ 'text0' ] ) ; if ( $ plural !== '' ) { switch ( $ numPlurals ) { case 6 : $ translation -> setPluralTranslation ( $ row [ 'text5' ] , 4 ) ; /* @noinspection PhpMissingBreakStatementInspection */ case 5 : $ translation -> setPluralTranslation ( $ row [ 'text4' ] , 3 ) ; /* @noinspection PhpMissingBreakStatementInspection */ case 4 : $ translation -> setPluralTranslation ( $ row [ 'text3' ] , 2 ) ; /* @noinspection PhpMissingBreakStatementInspection */ case 3 : $ translation -> setPluralTranslation ( $ row [ 'text2' ] , 1 ) ; /* @noinspection PhpMissingBreakStatementInspection */ case 2 : $ translation -> setPluralTranslation ( $ row [ 'text1' ] , 0 ) ; /* @noinspection PhpMissingBreakStatementInspection */ break ; } } } } return $ po ; }
Fill in the translations for a specific locale.

@param Translations $translations
@param LocaleEntity $locale

@return Translations
Fill in the translations for a specific locale .