1   2   3   4   5   6   7   8   9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  47  48  49  50  51  52  53  54  55  56  57  58  59  60  61  62  63  64  65  66  67  68  69  70  71  72  73  74  75  76  77  78  79  80  81  82  83  84  85  86  87  88  89  90  91  92  93  94  95  96  97  98  99 100 101 102 103 104 105 106 107 108 109 

<?php
/* --------------------------------------------------------------
   LegalTextVersionHelper.inc.php 2018-05-15
   Gambio GmbH
   http://www.gambio.de
   Copyright (c) 2018 Gambio GmbH
   Released under the GNU General Public License (Version 2)
   [http://www.gnu.org/licenses/gpl-2.0.html]
   --------------------------------------------------------------
*/

/**
 * Class LegalTextVersionHelper
 *
 * This class provides methods in order to get the legal text version of a legal text like eg. the privacy text.
 *
 * @category   System
 * @package    Agreement
 */
class LegalTextVersionHelper
{
    /**
     * @var \CI_DB_query_builder
     */
    private $queryBuilder;
    
    
    /**
     * LegalTextVersionHelper constructor.
     *
     * @param \CI_DB_query_builder $queryBuilder
     */
    public function __construct(CI_DB_query_builder $queryBuilder)
    {
        $this->queryBuilder = $queryBuilder;
    }
    
    
    /**
     * Returns the privacy text version by the provided language ID.
     *
     * @param \IdType $languageId Language ID.
     *
     * @return string Privacy text version
     */
    public function getPrivacyTextVersionByLanguageId(IdType $languageId)
    {
        return $this->queryBuilder->select('content_version')
                                  ->from('content_manager')
                                  ->where('content_group', 2)
                                  ->where('languages_id', $languageId)
                                  ->get()
                                  ->result()[0]->content_version;
    }
    
    
    /**
     * Returns the AGB text version by the provided language ID.
     *
     * @param \IdType $languageId Language ID.
     *
     * @return string AGB text version
     */
    public function getAGBTextVersionByLanguageId(IdType $languageId)
    {
        return $this->queryBuilder->select('content_version')
                                  ->from('content_manager')
                                  ->where('content_group', 3)
                                  ->where('languages_id', $languageId)
                                  ->get()
                                  ->result()[0]->content_version;
    }
    
    
    /**
     * Returns the withdrawal text version by the provided language ID.
     *
     * @param \IdType $languageId Language ID.
     *
     * @return string Withdrawal text version
     */
    public function getWithdrawalTextVersionByLanguageId(IdType $languageId)
    {
        return $this->queryBuilder->select('content_version')
                                  ->from('content_manager')
                                  ->where('content_group', 3889895)
                                  ->where('languages_id', $languageId)
                                  ->get()
                                  ->result()[0]->content_version;
    }
    
    
    /**
     * Returns the transport text version by the provided language ID.
     *
     * @param \IdType $languageId Language ID.
     *
     * @return string Transport text version
     */
    public function getTransportTextVersionByLanguageId(IdType $languageId)
    {
        return $this->queryBuilder->select('content_version')
                                  ->from('content_manager')
                                  ->where('content_group', 3210123)
                                  ->where('languages_id', $languageId)
                                  ->get()
                                  ->result()[0]->content_version;
    }
}