[Web-erp-svn] SF.net SVN: web-erp:[7072] trunk/StockClone.php

[<te...@us...>]

Revision: 7072
          http://sourceforge.net/p/web-erp/reponame/7072
Author:   tehonu
Date:     2015-01-07 07:33:13 +0000 (Wed, 07 Jan 2015)
Log Message:
-----------
StockClone now also clones the long description translations as well

Modified Paths:
--------------
    trunk/StockClone.php

Modified: trunk/StockClone.php
===================================================================
--- trunk/StockClone.php	2015-01-07 06:50:58 UTC (rev 7071)
+++ trunk/StockClone.php	2015-01-07 07:33:13 UTC (rev 7072)
@@ -324,7 +324,15 @@
 					if (count($ItemDescriptionLanguagesArray)>0){
 						foreach ($ItemDescriptionLanguagesArray as $LanguageId) {
 							if ($LanguageId!=''){
-								$result = DB_query("INSERT INTO stockdescriptiontranslations VALUES('" . $_POST['StockID'] . "','" . $LanguageId . "', '" . $_POST['Description_' . str_replace('.','_',$LanguageId)] . "')",$ErrMsg,$DbgMsg,true);
+								$result = DB_query("INSERT INTO stockdescriptiontranslations (stockid,
+																							language_id,
+																							descriptiontranslation,
+																							longdescriptiontranslation)
+													VALUES('" . $StockID . "','" . 
+																$LanguageId . "', '" . 
+																$_POST['Description_' . str_replace('.','_',$LanguageId)]  . "', '" . 
+																$_POST['LongDescription_' . str_replace('.','_',$LanguageId)]. 
+																"')",$ErrMsg,$DbgMsg,true);
 							}
 						}
 					}
@@ -633,7 +641,11 @@
 	$_POST['Pansize'] = $myrow['pansize'];
 	$_POST['ShrinkFactor'] = $myrow['shrinkfactor'];
 
-	$sql = "SELECT descriptiontranslation, language_id FROM stockdescriptiontranslations WHERE stockid='" . $selectedStockID . "' AND (";
+	$sql = "SELECT descriptiontranslation, 
+					longdescriptiontranslation, 
+					language_id 
+			FROM stockdescriptiontranslations 
+			WHERE stockid='" . $selectedStockID . "' AND (";
 	foreach ($ItemDescriptionLanguagesArray as $LanguageId) {
 		$sql .= "language_id='" . $LanguageId ."' OR ";
 	}
@@ -641,6 +653,7 @@
 	$result = DB_query($sql);
 	while ($myrow = DB_fetch_array($result)){
 		$_POST['Description_' . str_replace('.','_',$myrow['language_id'])] = $myrow['descriptiontranslation'];
+		$_POST['LongDescription_' . str_replace('.','_',$myrow['language_id'])] = $myrow['longdescriptiontranslation'];
 	}
 
 }