diff options
Diffstat (limited to 'main/survey/app/Controllers/LanguageController.php')
| -rw-r--r-- | main/survey/app/Controllers/LanguageController.php | 196 |
1 files changed, 196 insertions, 0 deletions
diff --git a/main/survey/app/Controllers/LanguageController.php b/main/survey/app/Controllers/LanguageController.php new file mode 100644 index 0000000..ab47a41 --- /dev/null +++ b/main/survey/app/Controllers/LanguageController.php @@ -0,0 +1,196 @@ +<?php
+/***************************************
+ * Description:
+ * Autor: Robert Šmalc
+ * Created date: 18.02.2016
+ *****************************************/
+
+namespace App\Controllers;
+
+use SurveyInfo;
+
+class LanguageController extends Controller
+{
+ public function __construct()
+ {
+ parent::getGlobalVariables();
+ }
+
+ /************************************************
+ * Get instance
+ ************************************************/
+ private static $_instance;
+
+ public static function getInstance()
+ {
+ if (self::$_instance)
+ return self::$_instance;
+
+ return new LanguageController();
+ }
+
+ /************************************************
+ * Osnovne jezikovne datoteke
+ *
+ * @param $anketa
+ * @return
+ ************************************************/
+ public static function getLanguageFile()
+ {
+ global $lang;
+
+ if (get('anketa') > 0) {
+ SurveyInfo::getInstance()->SurveyInit(get('anketa'));
+ $row = SurveyInfo::getInstance()->getSurveyRow();
+
+ $jezik = $row['lang_resp'];
+
+ } else {
+ $sql = sisplet_query("SELECT value FROM misc WHERE what = 'SurveyLang_resp'");
+ $row = mysqli_fetch_array($sql);
+
+ $jezik = $row['value'];
+ }
+
+ $file = lang_path($jezik);
+
+ if (@include($file)) {
+ $_SESSION['langX'] = lang_path($jezik, 1);
+ }
+ }
+
+
+ /**
+ * inicializacija multilang ankete. nastavljen mora biti usr_id ali $_GET[language]
+ *
+ */
+ public function multilang_init()
+ {
+ global $lang;
+
+ // mamo prebran cookie in user id, spremenimo language ce je treba -- multilanguage podpora je vezana na usr_id
+ $row = SurveyInfo::getInstance()->getSurveyRow();
+ if ($row['multilang'] == 1) {
+ if (isset($_GET['language'])) { // jezik podan preko GETa (podan je ze v linku ali spremenimo v previewu)
+
+ if (!empty(get('usr_id'))) { // (v bazo se shrani v displayintroduction - z ostalimi sistemskimi) (usr_id se ni postavljen)
+ $sqll = sisplet_query("SELECT lang_id FROM srv_language WHERE ank_id='" . get('anketa') . "' AND lang_id='$_GET[language]'");
+ $rowl = mysqli_fetch_array($sqll);
+ save('lang_id', $rowl['lang_id']);
+ } else { // v GETu, ko lahko v previewu spreminjamo jezik na strani (usr_id je ze postavljen)
+ $sql1 = sisplet_query("SELECT s.id FROM srv_spremenljivka s, srv_grupa g WHERE s.variable='language' AND s.gru_id=g.id AND g.ank_id='" . get('anketa') . "'");
+ $row1 = mysqli_fetch_array($sql1);
+ if ($row1['id'] > 0)
+ $sql1 = sisplet_query("UPDATE srv_data_text" . get('db_table') . " dt SET text='$_GET[language]' WHERE spr_id='$row1[id]' AND usr_id='" . get('usr_id') . "'");
+ save('lang_id', $_GET['language']);
+ }
+
+ } elseif (isset($_POST['language'])) { // jezik podan v POSTu (ce si ga user spremeni na prvi strani)
+
+ $sql1 = sisplet_query("SELECT s.id FROM srv_spremenljivka s, srv_grupa g WHERE s.variable='language' AND s.gru_id=g.id AND g.ank_id='" . get('anketa') . "'");
+ $row1 = mysqli_fetch_array($sql1);
+ if ($row1['id'] > 0)
+ $sql1 = sisplet_query("UPDATE srv_data_text" . get('db_table') . " dt SET text='$_POST[language]' WHERE spr_id='$row1[id]' AND usr_id='" . get('usr_id') . "'");
+ save('lang_id', $_POST['language']);
+
+ } else { // jezik je ze shranjen v bazi, ga preberemo (naslednje strani)
+
+ $sqll = sisplet_query("SELECT text FROM srv_data_text" . get('db_table') . " dt, srv_spremenljivka s WHERE dt.spr_id=s.id AND s.variable='language' AND dt.usr_id='" . get('usr_id') . "'");
+ $rowl = mysqli_fetch_array($sqll);
+ $sqll = sisplet_query("SELECT lang_id FROM srv_language WHERE ank_id='" . get('anketa') . "' AND lang_id='$rowl[text]'");
+ $rowl = mysqli_fetch_array($sqll);
+ save('lang_id', $rowl['lang_id']);
+
+ }
+
+ if (get('lang_id') == null) { // ni bil podan preko GETa in ni shranjen v bazi -- priredimo default jezik
+ $_GET['language'] = self::$lang['id']; // to damo samo zato, da se shrani ID default jezika v bazo, namesto -1 (ker pri default jeziku ne podamo nič preko URLja)
+ // get('lang_id') mora se vedno ostati null !
+
+ } else { // zamenjamo jezik
+ $file = lang_path(get('lang_id'));
+ if (@include($file))
+ $_SESSION['langX'] = lang_path(get('lang_id'), 1);
+ }
+ }
+
+ }
+
+
+ /**
+ * prevod za srv_spremenljivka
+ */
+ public static function srv_language_spremenljivka($spremenljivka)
+ {
+ if (get('lang_id') != null) {
+
+ $sqll = sisplet_query("SELECT * FROM srv_language_spremenljivka WHERE ank_id='" . get('anketa') . "' AND spr_id='$spremenljivka' AND lang_id='" . get('lang_id') . "'");
+ $rowl = mysqli_fetch_array($sqll);
+
+ return $rowl;
+ }
+
+ return false;
+ }
+
+ /**
+ * vrne prevod za srv_vrednost
+ *
+ * @param mixed $vrednost
+ */
+ public function srv_language_vrednost($vrednost, $naslov2=false)
+ {
+
+ if (get('lang_id') != null) {
+
+ $sqll = sisplet_query("SELECT naslov, naslov2 FROM srv_language_vrednost WHERE ank_id='" . get('anketa') . "' AND vre_id='$vrednost' AND lang_id='" . get('lang_id') . "'");
+ $rowl = mysqli_fetch_array($sqll);
+
+ if($naslov2){
+ if ($rowl['naslov2'] != '')
+ return $rowl['naslov2'];
+ }
+ elseif ($rowl['naslov'] != ''){
+ return $rowl['naslov'];
+ }
+ }
+
+ return false;
+ }
+
+ /**
+ * vrne prevod za srv_grid
+ *
+ * @param mixed $vrednost
+ */
+ public static function srv_language_grid($spremenljivka, $grid)
+ {
+ if (get('lang_id') != null) {
+
+ $sqll = sisplet_query("SELECT naslov FROM srv_language_grid WHERE ank_id='" . get('anketa') . "' AND spr_id='$spremenljivka' AND grd_id='$grid' AND lang_id='" . get('lang_id') . "'");
+ $rowl = mysqli_fetch_array($sqll);
+
+ if ($rowl['naslov'] != '') return $rowl['naslov'];
+ }
+
+ return false;
+ }
+
+ /**
+ * vrne prevod podnaslova za dvojno tabelo
+ *
+ */
+ public static function srv_language_grid_podnaslov($spremenljivka, $grid)
+ {
+ if (get('lang_id') != null) {
+
+ $sqll = sisplet_query("SELECT podnaslov FROM srv_language_grid WHERE ank_id='" . get('anketa') . "' AND spr_id='$spremenljivka' AND grd_id='$grid' AND lang_id='" . get('lang_id') . "'");
+ $rowl = mysqli_fetch_array($sqll);
+
+ if ($rowl['podnaslov'] != '') return $rowl['podnaslov'];
+ }
+
+ return false;
+ }
+
+}
\ No newline at end of file |