Gecko [ ifk.uw.edu.pl ]

Name	Size	Permission
Gettext	[ DIR ]	drwxr-xr-x
ChoiceFormat.php	6.14 KB	-rw-r--r--
CultureInfo.php	12.32 KB	-rw-r--r--
IMessageSource.php	3.72 KB	-rw-r--r--
MessageCache.php	3.91 KB	-rw-r--r--
MessageFormat.php	5.9 KB	-rw-r--r--
MessageSource.php	8.17 KB	-rw-r--r--
MessageSource_Database.php	9.43 KB	-rw-r--r--
MessageSource_PHP.php	10.21 KB	-rw-r--r--
MessageSource_XLIFF.php	13.12 KB	-rw-r--r--
MessageSource_gettext.php	11.11 KB	-rw-r--r--
TCache_Lite.php	13.58 KB	-rw-r--r--
TMessageSourceIOException.php	702 B	-rw-r--r--

Code Editor : MessageSource_Database.php

<?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/}
 *
 */

namespace Prado\I18N\core;

use PDO;
use Prado\Data\TDataSourceConfig;
use Prado\Exceptions\TConfigurationException;
use Prado\Prado;

/**
 * MessageSource_Database class.
 *
 * Retrive the message translation from a database.
 *
 * See the MessageSource::factory() method to instantiate this class.
 *
 */
class MessageSource_Database extends MessageSource
{
	private $_connID = '';
	private $_conn;

/**
	 * Constructor.
	 * Create a new message source using a Database
	 * @param string $source Database datasource, in PEAR's DB DSN format.
	 * @see MessageSource::factory();
	 */
	public function __construct($source)
	{
		$this->_connID = (string) $source;
	}

/**
	 * @return \Prado\Data\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 $connectionID the module ID for TDataSourceConfig
	 * @throws TConfigurationException if module ID is invalid or empty
	 * @return \Prado\Data\TDbConnection the created DB connection
	 */
	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 $variant 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 = [];

foreach ($dataReader as $row) {
			$result[$row['source']] = [$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 $source 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 $variant catalogue+variant
	 * @return bool 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 catalogue name
	 * @return array list of all variants for this catalogue.
	 */
	protected function getCatalogueList($catalogue)
	{
		$variants = explode('_', $this->culture);

$catalogues = [$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 [$cat_id, $variant, $count];
	}

/**
	 * Update the catalogue last modified time.
	 * @param mixed $cat_id
	 * @param mixed $variant
	 * @return bool 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 $catalogue the catalogue to add to
	 * @return bool true if saved successfuly, false otherwise.
	 */
	public function save($catalogue = 'messages')
	{
		$messages = $this->untranslated;

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

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

if ($details) {
			[$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(':dateadded', $time, PDO::PARAM_INT);
		foreach ($messages as $message) {
			if (empty($message)) {
				continue;
			}
			$count++;
			$inserted++;
			$command->bindParameter(':source', $message, PDO::PARAM_STR);
			$command->execute();
		}
		if ($inserted > 0) {
			$this->updateCatalogueTime($cat_id, $variant);
		}

return $inserted > 0;
	}

/**
	 * Delete a particular message from the specified catalogue.
	 * @param string $message the source message to delete.
	 * @param string $catalogue the catalogue to delete from.
	 * @return bool true if deleted, false otherwise.
	 */
	public function delete($message, $catalogue = 'messages')
	{
		$details = $this->getCatalogueDetails($catalogue);
		if ($details) {
			[$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 $text the source string.
	 * @param string $target the new translation string.
	 * @param string $comments comments
	 * @param string $catalogue the catalogue of the translation.
	 * @return bool true if translation was updated, false otherwise.
	 */
	public function update($text, $target, $comments, $catalogue = 'messages')
	{
		$details = $this->getCatalogueDetails($catalogue);
		if ($details) {
			[$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
	 */
	public function catalogues()
	{
		$command = $this->getDBConnection()->createCommand('SELECT name FROM catalogue ORDER BY name');
		$dataReader = $command->query();

$result = [];

foreach ($dataReader as $row) {
			$details = explode('.', $row[0]);
			if (!isset($details[1])) {
				$details[1] = null;
			}

$result[] = $details;
		}

return $result;
	}
}

${this.title}

Code Editor : MessageSource_Database.php