<?php

class admin_translator_model extends Model {
    
    
    public function getTranslations() {
        $langs = $this->query("select * from azonics_languages where language_status<>'0';");
        
        if (sizeof($langs)>0) {
            foreach ($langs as $row) {
                $code = $row->language_code;
                $result[$code] = $this->query("select * from azonics_translations where translation_status<>'0' and translation_language='".$code."' order by translation_name asc;");
            }
        }
        
        return $result;
    }
    
    
    public function getLanguages() {
        $result = $this->query("select * from azonics_languages where language_status<>'0';");
        return $result;
    }
    
    
    public function loadTranslation() {
        $translation_id = $this->escapeString($_REQUEST['id']);
        $row = $this->query("select * from azonics_translations where translation_id='".$translation_id."';");
        return $row[0];
    }
    
    
    public function saveTranslation() {
        $data = $this->escapeArray($_REQUEST);
        
        if ($data['translation_id']!='') {
            $this->execute("update azonics_translations set "
                    . "translation_name='".$data['translation_name']."', "
                    . "translation_language='".$data['translation_value_text']."', "
                    . "translation_text='".$data['translation_value_num']."' where translation_id='".$data['translation_id']."';");
            
            return true;
        }
        else {
            $this->execute("insert into azonics_translations set "
                    . "translation_name='".$data['translation_name']."', "
                    . "translation_language='".$data['translation_language']."', "
                    . "translation_text='".$data['translation_text']."', "
                    . "translation_status='1', "
                    . "translation_user_id='".$_SESSION['admin_user']->admin_id."';");
            
            return true;
        }
    }
    
    
    public function deleteTranslation() {
        $translation_id = $this->escapeString($_REQUEST['id']);
        $this->execute("update azonics_translations set translation_status='0' where translation_id='".$translation_id."';");
        return true;
    }
    
    
    public function saveTranslate() {
        $data = $this->escapeArray($_REQUEST);
        
        $this->execute("update azonics_translations set "
                . "translation_text='".$data['text']."' where "
                . "translation_name='".$data['key']."' and "
                . "translation_language='".$data['code']."';");
        
        return true;
    }
    
    
}