standardize the use of unix eol; use svn properties to enforce native eol

1 files changed, 323 insertions, 323 deletions

diff --git a/framework/I18N/core/MessageSource_Database.php b/framework/I18N/core/MessageSource_Database.php
index 3ccea61b..549d1c40 100644
--- a/framework/I18N/core/MessageSource_Database.php
+++ b/framework/I18N/core/MessageSource_Database.php
@@ -1,323 +1,323 @@
-<?php

-/**

- * MessageSource_Database class file.

- *

- * This program is free software; you can redistribute it and/or modify

- * it under the terms of the BSD License.

- *

- * Copyright(c) 2004 by Qiang Xue. All rights reserved.

- *

- * To contact the author write to {@link mailto:qiang.xue@gmail.com Qiang Xue}

- * The latest version of PRADO can be obtained from:

- * {@link http://prado.sourceforge.net/}

- *

- * @package System.I18N.core

- */

-

-/**

- * Get the MessageSource class file.

- */

-require_once(dirname(__FILE__).'/MessageSource.php');

-

-/**

- * MessageSource_Database class.

- *

- * Retrive the message translation from a database.

- *

- * See the MessageSource::factory() method to instantiate this class.

- *

- * @package System.I18N.core

- */

-class MessageSource_Database extends MessageSource

-{

-	private $_connID='';

-	private $_conn;

-

-	/**

-	 * Constructor.

-	 * Create a new message source using a Database

-	 * @param string MySQL datasource, in PEAR's DB DSN format.

-	 * @see MessageSource::factory();

-	 */

-	function __construct($source)

-	{

-		$this->_connID= (string)$source;

-	}

-

-	/**

-	 * @return TDbConnection the database connection that may be used to retrieve messages.

-	 */

-	public function getDbConnection()

-	{

-		if($this->_conn===null)

-		{

-			$this->_conn=$this->createDbConnection($this->_connID);

-			$this->_conn->setActive(true);

-		}

-		return $this->_conn;

-	}

-

-	/**

-	 * Creates the DB connection.

-	 * @param string the module ID for TDataSourceConfig

-	 * @return TDbConnection the created DB connection

-	 * @throws TConfigurationException if module ID is invalid or empty

-	 */

-	protected function createDbConnection($connectionID)

-	{

-		if($connectionID!=='')

-		{

-			$conn=Prado::getApplication()->getModule($connectionID);

-			if($conn instanceof TDataSourceConfig)

-				return $conn->getDbConnection();

-			else

-				throw new TConfigurationException('messagesource_connectionid_invalid',$connectionID);

-		}

-		else

-			throw new TConfigurationException('messagesource_connectionid_required');

-	}

-

-	/**

-	 * Get an array of messages for a particular catalogue and cultural

-	 * variant.

-	 * @param string the catalogue name + variant

-	 * @return array translation messages.

-	 */

-	protected function &loadData($variant)

-	{

-		$command=$this->getDBConnection()->createCommand(

-			'SELECT t.id, t.source, t.target, t.comments

-				FROM trans_unit t, catalogue c

-				WHERE c.cat_id =  t.cat_id

-					AND c.name = :variant

-				ORDER BY id ASC');

-		$command->bindParameter(':variant',$variant,PDO::PARAM_STR);

-		$dataReader=$command->query();

-

-		$result = array();

-

-		foreach ($dataReader as $row)

-			$result[$row['source']] = array($row['target'],$row['id'],$row['comments']);

-

-		return $result;

-	}

-	

-	/**

-	 * Get the last modified unix-time for this particular catalogue+variant.

-	 * We need to query the database to get the date_modified.

-	 * @param string catalogue+variant

-	 * @return int last modified in unix-time format.

-	 */

-	protected function getLastModified($source)

-	{

-		$command=$this->getDBConnection()->createCommand(

-			'SELECT date_modified FROM catalogue WHERE name = :source');

-		$command->bindParameter(':source',$source,PDO::PARAM_STR);

-		$result=$command->queryScalar();

-		return $result ? $result : 0;

-	}

-

-

-	/**

-	 * Check if a particular catalogue+variant exists in the database.

-	 * @param string catalogue+variant

-	 * @return boolean true if the catalogue+variant is in the database,

-	 * false otherwise.

-	 */

-	protected function isValidSource($variant)

-	{

-		$command=$this->getDBConnection()->createCommand(

-			'SELECT COUNT(*) FROM catalogue WHERE name = :variant');

-		$command->bindParameter(':variant',$variant,PDO::PARAM_STR);

-		return $command->queryScalar()==1;

-	}

-

-	/**

-	 * Get all the variants of a particular catalogue.

-	 * @param string catalogue name

-	 * @return array list of all variants for this catalogue.

-	 */

-	protected function getCatalogueList($catalogue)

-	{

-		$variants = explode('_',$this->culture);

-

-		$catalogues = array($catalogue);

-

-		$variant = null;

-

-		for($i = 0, $k = count($variants); $i < $k; ++$i)

-		{

-			if(isset($variants[$i]{0}))

-			{

-				$variant .= ($variant)?'_'.$variants[$i]:$variants[$i];

-				$catalogues[] = $catalogue.'.'.$variant;

-			}

-		}

-		return array_reverse($catalogues);

-	}

-

-	/**

-	 * Retrive catalogue details, array($cat_id, $variant, $count).

-	 * @param string catalogue

-	 * @return array catalogue details, array($cat_id, $variant, $count).

-	 */

-	private function getCatalogueDetails($catalogue='messages')

-	{

-		if(empty($catalogue))

-			$catalogue = 'messages';

-

-		$variant = $catalogue.'.'.$this->culture;

-

-		$command=$this->getDBConnection()->createCommand(

-			'SELECT cat_id FROM catalogue WHERE name = :variant');

-		$command->bindParameter(':variant',$variant,PDO::PARAM_STR);

-		$cat_id=$command->queryScalar();

-

-		if ($cat_id===null) return false;

-

-		$command=$this->getDBConnection()->createCommand(

-			'SELECT COUNT(msg_id) FROM trans_unit WHERE cat_id = :catid ');

-		$command->bindParameter(':catid',$cat_id,PDO::PARAM_INT);

-		$count=$command->queryScalar();

-

-		return array($cat_id, $variant, $count);

-	}

-

-	/**

-	 * Update the catalogue last modified time.

-	 * @return boolean true if updated, false otherwise.

-	 */

-	private function updateCatalogueTime($cat_id, $variant)

-	{

-		$time = time();

-		$command=$this->getDBConnection()->createCommand(

-			'UPDATE catalogue SET date_modified = :moddate WHERE cat_id = :catid');

-		$command->bindParameter(':moddate',$time,PDO::PARAM_INT);

-		$command->bindParameter(':catid',$cat_id,PDO::PARAM_INT);

-		$result=$command->execute();

-

-		if(!empty($this->cache))

-			$this->cache->clean($variant, $this->culture);

-

-		return $result;

-	}

-

-	/**

-	 * Save the list of untranslated blocks to the translation source.

-	 * If the translation was not found, you should add those

-	 * strings to the translation source via the <b>append()</b> method.

-	 * @param string the catalogue to add to

-	 * @return boolean true if saved successfuly, false otherwise.

-	 */

-	function save($catalogue='messages')

-	{

-		$messages = $this->untranslated;

-

-		if(count($messages) <= 0) return false;

-

-		$details = $this->getCatalogueDetails($catalogue);

-

-		if($details)

-			list($cat_id, $variant, $count) = $details;

-		else

-			return false;

-

-		if($cat_id <= 0) return false;

-		$inserted = 0;

-

-		$time = time();

-

-		$command=$this->getDBConnection()->createCommand(

-			'INSERT INTO trans_unit (cat_id,id,source,date_added) VALUES (:catid,:id,:source,:dateadded)');

-		$command->bindParameter(':catid',$cat_id,PDO::PARAM_INT);

-		$command->bindParameter(':id',$count,PDO::PARAM_INT);

-		$command->bindParameter(':source',$message,PDO::PARAM_STR);

-		$command->bindParameter(':dateadded',$time,PDO::PARAM_INT);

-		foreach($messages as $message)

-		{

-			if (empty($message)) continue;

-			$count++; $inserted++;

-			$command->execute();

-		}

-		if($inserted > 0)

-			$this->updateCatalogueTime($cat_id, $variant);

-

-		return $inserted > 0;

-	}

-

-	/**

-	 * Delete a particular message from the specified catalogue.

-	 * @param string the source message to delete.

-	 * @param string the catalogue to delete from.

-	 * @return boolean true if deleted, false otherwise.

-	 */

-	function delete($message, $catalogue='messages')

-	{

-		$details = $this->getCatalogueDetails($catalogue);

-		if($details)

-			list($cat_id, $variant, $count) = $details;

-		else

-			return false;

-

-		$command=$this->getDBConnection()->createCommand(

-			'DELETE FROM trans_unit WHERE cat_id = :catid AND source = :message');

-		$command->bindParameter(':catid',$cat_id,PDO::PARAM_INT);

-		$command->bindParameter(':message',$message,PDO::PARAM_STR);

-

-		return ($command->execute()==1) ? $this->updateCatalogueTime($cat_id, $variant) : false;

-

-	}

-

-	/**

-	 * Update the translation.

-	 * @param string the source string.

-	 * @param string the new translation string.

-	 * @param string comments

-	 * @param string the catalogue of the translation.

-	 * @return boolean true if translation was updated, false otherwise.

-	 */

-	function update($text, $target, $comments, $catalogue='messages')

-	{

-		$details = $this->getCatalogueDetails($catalogue);

-		if($details)

-			list($cat_id, $variant, $count) = $details;

-		else

-			return false;

-

-		$time = time();

-		$command=$this->getDBConnection()->createCommand(

-			'UPDATE trans_unit SET target = :target, comments = :comments, date_modified = :datemod

-					WHERE cat_id = :catid AND source = :source');

-		$command->bindParameter(':target',$target,PDO::PARAM_STR);

-		$command->bindParameter(':comments',$comments,PDO::PARAM_STR);

-		$command->bindParameter(':datemod',$time,PDO::PARAM_INT);

-		$command->bindParameter(':catid',$cat_id,PDO::PARAM_INT);

-		$command->bindParameter(':source',$text,PDO::PARAM_STR);

-

-		return ($command->execute()==1) ? $this->updateCatalogueTime($cat_id, $variant) : false;

-	}

-

-	/**

-	 * Returns a list of catalogue as key and all it variants as value.

-	 * @return array list of catalogues

-	 */

-	function catalogues()

-	{

-		$command=$this->getDBConnection()->createCommand( 'SELECT name FROM catalogue ORDER BY name');

-		$dataReader=$command->query();

-

-		$result = array();

-

-		foreach ($dataReader as $row)

-		{

-			$details = explode('.',$row[0]);

-			if(!isset($details[1])) $details[1] = null;

-

-			$result[] = $details;

-		}

-

-		return $result;

-	}

-

-}

-?>

+<?php
+/**
+ * MessageSource_Database class file.
+ *
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the BSD License.
+ *
+ * Copyright(c) 2004 by Qiang Xue. All rights reserved.
+ *
+ * To contact the author write to {@link mailto:qiang.xue@gmail.com Qiang Xue}
+ * The latest version of PRADO can be obtained from:
+ * {@link http://prado.sourceforge.net/}
+ *
+ * @package System.I18N.core
+ */
+
+/**
+ * Get the MessageSource class file.
+ */
+require_once(dirname(__FILE__).'/MessageSource.php');
+
+/**
+ * MessageSource_Database class.
+ *
+ * Retrive the message translation from a database.
+ *
+ * See the MessageSource::factory() method to instantiate this class.
+ *
+ * @package System.I18N.core
+ */
+class MessageSource_Database extends MessageSource
+{
+	private $_connID='';
+	private $_conn;
+
+	/**
+	 * Constructor.
+	 * Create a new message source using a Database
+	 * @param string MySQL datasource, in PEAR's DB DSN format.
+	 * @see MessageSource::factory();
+	 */
+	function __construct($source)
+	{
+		$this->_connID= (string)$source;
+	}
+
+	/**
+	 * @return TDbConnection the database connection that may be used to retrieve messages.
+	 */
+	public function getDbConnection()
+	{
+		if($this->_conn===null)
+		{
+			$this->_conn=$this->createDbConnection($this->_connID);
+			$this->_conn->setActive(true);
+		}
+		return $this->_conn;
+	}
+
+	/**
+	 * Creates the DB connection.
+	 * @param string the module ID for TDataSourceConfig
+	 * @return TDbConnection the created DB connection
+	 * @throws TConfigurationException if module ID is invalid or empty
+	 */
+	protected function createDbConnection($connectionID)
+	{
+		if($connectionID!=='')
+		{
+			$conn=Prado::getApplication()->getModule($connectionID);
+			if($conn instanceof TDataSourceConfig)
+				return $conn->getDbConnection();
+			else
+				throw new TConfigurationException('messagesource_connectionid_invalid',$connectionID);
+		}
+		else
+			throw new TConfigurationException('messagesource_connectionid_required');
+	}
+
+	/**
+	 * Get an array of messages for a particular catalogue and cultural
+	 * variant.
+	 * @param string the catalogue name + variant
+	 * @return array translation messages.
+	 */
+	protected function &loadData($variant)
+	{
+		$command=$this->getDBConnection()->createCommand(
+			'SELECT t.id, t.source, t.target, t.comments
+				FROM trans_unit t, catalogue c
+				WHERE c.cat_id =  t.cat_id
+					AND c.name = :variant
+				ORDER BY id ASC');
+		$command->bindParameter(':variant',$variant,PDO::PARAM_STR);
+		$dataReader=$command->query();
+
+		$result = array();
+
+		foreach ($dataReader as $row)
+			$result[$row['source']] = array($row['target'],$row['id'],$row['comments']);
+
+		return $result;
+	}
+	
+	/**
+	 * Get the last modified unix-time for this particular catalogue+variant.
+	 * We need to query the database to get the date_modified.
+	 * @param string catalogue+variant
+	 * @return int last modified in unix-time format.
+	 */
+	protected function getLastModified($source)
+	{
+		$command=$this->getDBConnection()->createCommand(
+			'SELECT date_modified FROM catalogue WHERE name = :source');
+		$command->bindParameter(':source',$source,PDO::PARAM_STR);
+		$result=$command->queryScalar();
+		return $result ? $result : 0;
+	}
+
+
+	/**
+	 * Check if a particular catalogue+variant exists in the database.
+	 * @param string catalogue+variant
+	 * @return boolean true if the catalogue+variant is in the database,
+	 * false otherwise.
+	 */
+	protected function isValidSource($variant)
+	{
+		$command=$this->getDBConnection()->createCommand(
+			'SELECT COUNT(*) FROM catalogue WHERE name = :variant');
+		$command->bindParameter(':variant',$variant,PDO::PARAM_STR);
+		return $command->queryScalar()==1;
+	}
+
+	/**
+	 * Get all the variants of a particular catalogue.
+	 * @param string catalogue name
+	 * @return array list of all variants for this catalogue.
+	 */
+	protected function getCatalogueList($catalogue)
+	{
+		$variants = explode('_',$this->culture);
+
+		$catalogues = array($catalogue);
+
+		$variant = null;
+
+		for($i = 0, $k = count($variants); $i < $k; ++$i)
+		{
+			if(isset($variants[$i]{0}))
+			{
+				$variant .= ($variant)?'_'.$variants[$i]:$variants[$i];
+				$catalogues[] = $catalogue.'.'.$variant;
+			}
+		}
+		return array_reverse($catalogues);
+	}
+
+	/**
+	 * Retrive catalogue details, array($cat_id, $variant, $count).
+	 * @param string catalogue
+	 * @return array catalogue details, array($cat_id, $variant, $count).
+	 */
+	private function getCatalogueDetails($catalogue='messages')
+	{
+		if(empty($catalogue))
+			$catalogue = 'messages';
+
+		$variant = $catalogue.'.'.$this->culture;
+
+		$command=$this->getDBConnection()->createCommand(
+			'SELECT cat_id FROM catalogue WHERE name = :variant');
+		$command->bindParameter(':variant',$variant,PDO::PARAM_STR);
+		$cat_id=$command->queryScalar();
+
+		if ($cat_id===null) return false;
+
+		$command=$this->getDBConnection()->createCommand(
+			'SELECT COUNT(msg_id) FROM trans_unit WHERE cat_id = :catid ');
+		$command->bindParameter(':catid',$cat_id,PDO::PARAM_INT);
+		$count=$command->queryScalar();
+
+		return array($cat_id, $variant, $count);
+	}
+
+	/**
+	 * Update the catalogue last modified time.
+	 * @return boolean true if updated, false otherwise.
+	 */
+	private function updateCatalogueTime($cat_id, $variant)
+	{
+		$time = time();
+		$command=$this->getDBConnection()->createCommand(
+			'UPDATE catalogue SET date_modified = :moddate WHERE cat_id = :catid');
+		$command->bindParameter(':moddate',$time,PDO::PARAM_INT);
+		$command->bindParameter(':catid',$cat_id,PDO::PARAM_INT);
+		$result=$command->execute();
+
+		if(!empty($this->cache))
+			$this->cache->clean($variant, $this->culture);
+
+		return $result;
+	}
+
+	/**
+	 * Save the list of untranslated blocks to the translation source.
+	 * If the translation was not found, you should add those
+	 * strings to the translation source via the <b>append()</b> method.
+	 * @param string the catalogue to add to
+	 * @return boolean true if saved successfuly, false otherwise.
+	 */
+	function save($catalogue='messages')
+	{
+		$messages = $this->untranslated;
+
+		if(count($messages) <= 0) return false;
+
+		$details = $this->getCatalogueDetails($catalogue);
+
+		if($details)
+			list($cat_id, $variant, $count) = $details;
+		else
+			return false;
+
+		if($cat_id <= 0) return false;
+		$inserted = 0;
+
+		$time = time();
+
+		$command=$this->getDBConnection()->createCommand(
+			'INSERT INTO trans_unit (cat_id,id,source,date_added) VALUES (:catid,:id,:source,:dateadded)');
+		$command->bindParameter(':catid',$cat_id,PDO::PARAM_INT);
+		$command->bindParameter(':id',$count,PDO::PARAM_INT);
+		$command->bindParameter(':source',$message,PDO::PARAM_STR);
+		$command->bindParameter(':dateadded',$time,PDO::PARAM_INT);
+		foreach($messages as $message)
+		{
+			if (empty($message)) continue;
+			$count++; $inserted++;
+			$command->execute();
+		}
+		if($inserted > 0)
+			$this->updateCatalogueTime($cat_id, $variant);
+
+		return $inserted > 0;
+	}
+
+	/**
+	 * Delete a particular message from the specified catalogue.
+	 * @param string the source message to delete.
+	 * @param string the catalogue to delete from.
+	 * @return boolean true if deleted, false otherwise.
+	 */
+	function delete($message, $catalogue='messages')
+	{
+		$details = $this->getCatalogueDetails($catalogue);
+		if($details)
+			list($cat_id, $variant, $count) = $details;
+		else
+			return false;
+
+		$command=$this->getDBConnection()->createCommand(
+			'DELETE FROM trans_unit WHERE cat_id = :catid AND source = :message');
+		$command->bindParameter(':catid',$cat_id,PDO::PARAM_INT);
+		$command->bindParameter(':message',$message,PDO::PARAM_STR);
+
+		return ($command->execute()==1) ? $this->updateCatalogueTime($cat_id, $variant) : false;
+
+	}
+
+	/**
+	 * Update the translation.
+	 * @param string the source string.
+	 * @param string the new translation string.
+	 * @param string comments
+	 * @param string the catalogue of the translation.
+	 * @return boolean true if translation was updated, false otherwise.
+	 */
+	function update($text, $target, $comments, $catalogue='messages')
+	{
+		$details = $this->getCatalogueDetails($catalogue);
+		if($details)
+			list($cat_id, $variant, $count) = $details;
+		else
+			return false;
+
+		$time = time();
+		$command=$this->getDBConnection()->createCommand(
+			'UPDATE trans_unit SET target = :target, comments = :comments, date_modified = :datemod
+					WHERE cat_id = :catid AND source = :source');
+		$command->bindParameter(':target',$target,PDO::PARAM_STR);
+		$command->bindParameter(':comments',$comments,PDO::PARAM_STR);
+		$command->bindParameter(':datemod',$time,PDO::PARAM_INT);
+		$command->bindParameter(':catid',$cat_id,PDO::PARAM_INT);
+		$command->bindParameter(':source',$text,PDO::PARAM_STR);
+
+		return ($command->execute()==1) ? $this->updateCatalogueTime($cat_id, $variant) : false;
+	}
+
+	/**
+	 * Returns a list of catalogue as key and all it variants as value.
+	 * @return array list of catalogues
+	 */
+	function catalogues()
+	{
+		$command=$this->getDBConnection()->createCommand( 'SELECT name FROM catalogue ORDER BY name');
+		$dataReader=$command->query();
+
+		$result = array();
+
+		foreach ($dataReader as $row)
+		{
+			$details = explode('.',$row[0]);
+			if(!isset($details[1])) $details[1] = null;
+
+			$result[] = $details;
+		}
+
+		return $result;
+	}
+
+}
+?>