[Web-erp-svn] SF.net SVN: web-erp:[5898] trunk

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

Revision: 5898
          http://sourceforge.net/p/web-erp/reponame/5898
Author:   tehonu
Date:     2013-05-10 08:17:53 +0000 (Fri, 10 May 2013)
Log Message:
-----------
Pak Ricard: Change Sales Category name to VARCHAR(50)

Modified Paths:
--------------
    trunk/SalesCategories.php
    trunk/sql/mysql/upgrade4.10-4.11.sql

Modified: trunk/SalesCategories.php
===================================================================
--- trunk/SalesCategories.php	2013-05-09 09:58:48 UTC (rev 5897)
+++ trunk/SalesCategories.php	2013-05-10 08:17:53 UTC (rev 5898)
@@ -77,9 +77,9 @@
 
 	//first off validate inputs sensible
 
-	if (mb_strlen($_POST['SalesCatName']) >20 OR trim($_POST['SalesCatName'])=='') {
+	if (mb_strlen($_POST['SalesCatName']) >50 OR trim($_POST['SalesCatName'])=='') {
 		$InputError = 1;
-		prnMsg(_('The Sales category description must be twenty characters or less long'),'error');
+		prnMsg(_('The Sales category description must be fifty characters or less long'),'error');
 	}
 
 	if (isset($SelectedCategory) and $InputError !=1 ) {
@@ -318,7 +318,7 @@
 echo '<table class="selection">';
 echo '<tr><th colspan="2">' . $FormCaps . '</th></tr>';
 echo '<tr><td>' . _('Category Name') . ':</td>
-            <td><input type="text" name="SalesCatName" size="20" maxlength="20" value="' . $_POST['SalesCatName'] . '" /></td></tr>';
+            <td><input type="text" name="SalesCatName" size="50" maxlength="50" value="' . $_POST['SalesCatName'] . '" /></td></tr>';
 // Image upload only if we have a selected category
 if (isset($SelectedCategory)) {
 	echo '<tr><td>'. _('Image File (.jpg)') . ':</td>

Modified: trunk/sql/mysql/upgrade4.10-4.11.sql
===================================================================
--- trunk/sql/mysql/upgrade4.10-4.11.sql	2013-05-09 09:58:48 UTC (rev 5897)
+++ trunk/sql/mysql/upgrade4.10-4.11.sql	2013-05-10 08:17:53 UTC (rev 5898)
@@ -17,3 +17,6 @@
 
 ALTER TABLE  `currencies` ADD  `webcart` TINYINT( 1 ) NOT NULL DEFAULT  '1' COMMENT  'If 1 shown in weberp cart. if 0 no show';
 
+ALTER TABLE  `salescat` CHANGE  `salescatname`  `salescatname` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
+
+