RevisionTranslations.php

<?php
/* This script is to review the item description translations. */

include('includes/session.php');

$Title = _('Review Translated Descriptions');// Screen identificator.
$ViewTopic= 'Inventory';// Filename's id in ManualContents.php's TOC.
$BookMark = 'ReviewTranslatedDescriptions';// Anchor's id in the manual's html document.
include('includes/header.php');
echo '<p class="page_title_text"><img alt="" src="'.$RootPath.'/css/'.$Theme.
	'/images/maintenance.png" title="' .// Title icon.
	_('Review Translated Descriptions') . '" />' .// Icon title.
	_('Review Translated Descriptions') . '</p>';// Page title.

include('includes/SQL_CommonFunctions.inc');

//update database if update pressed
if(isset($_POST['Submit'])) {
	for ($i=1;$i<count($_POST);$i++) { //loop through the returned translations

		if(isset($_POST['Revised' . $i]) AND ($_POST['Revised' . $i] == '1')) {
			$sqlUpdate="UPDATE stockdescriptiontranslations
						SET needsrevision = '0',
							descriptiontranslation = '". $_POST['DescriptionTranslation' .$i] ."',
							longdescriptiontranslation = '". $_POST['LongDescriptionTranslation' .$i] ."'
						WHERE stockid = '". $_POST['StockID' .$i] ."'
							AND language_id = '". $_POST['LanguageID' .$i] ."'";
			$ResultUpdate = DB_Query($sqlUpdate,'', '', true);
			prnMsg($_POST['StockID' .$i] . ' ' . _('descriptions') . ' ' .  _('in') . ' ' . $_POST['LanguageID' .$i] . ' ' . _('have been updated'),'success');
		}
	}
}

echo '<form method="post" action="' . htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '">';
echo '<div>';
echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';

echo '<table class="selection">
		<tr>
			<th colspan="7">' . _('Translations to revise') .'</th>
		</tr>';

$sql = "SELECT stockdescriptiontranslations.stockid,
				stockmaster.description,
				stockmaster.longdescription,
				stockdescriptiontranslations.language_id,
				stockdescriptiontranslations.descriptiontranslation,
				stockdescriptiontranslations.longdescriptiontranslation
		FROM stockdescriptiontranslations, stockmaster
		WHERE stockdescriptiontranslations.stockid = stockmaster.stockid
			AND stockdescriptiontranslations.needsrevision = '1'
		ORDER BY stockdescriptiontranslations.stockid,
				stockdescriptiontranslations.language_id";

$result = DB_query($sql);

echo '<tr>
	<th>' . _('Code') . '</th>
	<th>' . _('Language') . '</th>
	<th>' . _('Part Description (short)') . '</th>
	<th>' . _('Part Description (long)') . '</th>
	<th>' . _('Revised?') . '</th>
</tr>';

$i=1;
while($myrow=DB_fetch_array($result)) {

	echo '<tr class="striped_row">
		<td>' . $myrow['stockid'] . '</td>
		<td>' . $_SESSION['Language']. '</td>
		<td>' . $myrow['description'] . '</td>
		<td>' . nl2br($myrow['longdescription']) . '</td>
		<td>&nbsp;</td>
		</tr>';// nl2br: Inserts HTML line breaks before all newlines in a string.

	echo '<tr class="striped_row">
		<td>&nbsp;</td>
		<td>' . $myrow['language_id'] . '</td>';

	echo '<td><input class="text" maxlength="50" name="DescriptionTranslation' . $i .'" size="52" type="text" value="'. $myrow['descriptiontranslation'] .'" /></td>
		<td><textarea name="LongDescriptionTranslation' . $i .'" cols="70" rows="5">'. $myrow['longdescriptiontranslation'] .'" </textarea></td>';

	echo '<td>
			<input name="Revised' . $i . '" type="checkbox" value="1" />
			<input name="StockID' . $i . '" type="hidden" value="' . $myrow['stockid'] . '" />
			<input name="LanguageID' . $i . '" type="hidden" value="' . $myrow['language_id'] . '" />
		</td>
		</tr>';
	$i++;

} //end of looping

echo '</table>
		<br />
		<div class="centre">
			<input type="submit" name="Submit" value="' . _('Update') . '" /></div>
		</div>
	</form>';

include('includes/footer.php');
?>