<?php
# $Id: 
# http://www.mapbender.org/index.php/Administration
# Copyright (C) 2002 CCGIS 
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2, or (at your option)
# any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.

require_once(dirname(__FILE__)."/../php/mb_validateSession.php");
require_once(dirname(__FILE__)."/../classes/class_json.php");

# SQL abfragen und return

$ajaxResponse = new AjaxResponse($_REQUEST);
$command = $ajaxResponse->getMethod();
$iso_code = $ajaxResponse->getParameter("locale");

if ($command == "isoselect") {
	isoselect($iso_code);
}

function isoselect($iso_code) {
	global $ajaxResponse;
	
	$flag=false;
	
	#is selected language in translations
	$sql = "SELECT locale FROM translations WHERE locale = '". $iso_code ."'";
	$v = array();
	$t = array();
	$res = db_prep_query($sql,$v,$t);
	
	while ($row = db_fetch_array($res)){
		if ($row["locale"]==$iso_code) { $flag = true; }
	}
	
	if ($flag==false) {
		$sql = "INSERT INTO translations( locale, msgid, msgstr ) SELECT '". $iso_code ."' AS locale, msgid, msgid as msgstr FROM translations WHERE locale = 'DE'";
		$v = array();
		$t = array();
		$res = db_prep_query($sql,$v,$t);
	}
	 
	#select translations for selected language
	$localeObj = array();
	$sql = "SELECT trs_id,locale,msgid,msgstr FROM translations WHERE locale = '". $iso_code ."' ORDER BY trs_id ASC";
	$v = array();
	$t = array();
	$res = db_prep_query($sql,$v,$t);
			
	while($row = db_fetch_array($res)){
				array_push($localeObj, array(
					"trs_id" => $row["trs_id"],
					"locale" => $row["locale"],
					"msgid" => $row["msgid"],
					"msgstr" => $row["msgstr"]
				));
	}
	
	if ($flag == false) {
		$message = "No translation found in database. New translation created.";
	} else {
		$message = "Successfully loaded translation from database.";
	}
	
	$ajaxResponse->setMessage($message);
	$ajaxResponse->setResult($localeObj);
	$ajaxResponse->send();
}
	
if ($command == "translate") {
$translations = $ajaxResponse->getParameter("translations");
$count = count($translations);
$datei = fopen(dirname(__FILE__)."/../tmp/translation_". $iso_code . ".sql", "w");
	for ($i=0; $i < $count; $i++) {
		$sql = "UPDATE translations SET msgstr = '" . $translations[$i]->msgstr . "' WHERE msgid = '". $translations[$i]->msgid . "' and locale = '" . $iso_code . "';";
		fwrite($datei, "INSERT INTO translations (locale , msgid, msgstr ) VALUES ('" . $iso_code . "', '" . $translations[$i]->msgid . "', '" . $translations[$i]->msgstr . "');\n");
		$v = array();
		$t = array();
		$res = db_prep_query($sql,$v,$t);
	}
fclose($datei);			
isoselect($iso_code);	
}
?>