From: <dai...@us...> - 2014-03-25 08:30:04
|
Revision: 6636 http://sourceforge.net/p/web-erp/reponame/6636 Author: daintree Date: 2014-03-25 08:30:00 +0000 (Tue, 25 Mar 2014) Log Message: ----------- Removed DefaultTheme config parameter Modified Paths: -------------- trunk/CustLoginSetup.php trunk/SuppLoginSetup.php trunk/SystemParameters.php trunk/WWW_Users.php trunk/Z_ChangeStockCode.php trunk/doc/Change.log trunk/includes/session.inc trunk/sql/mysql/upgrade4.11-4.12.sql Modified: trunk/CustLoginSetup.php =================================================================== --- trunk/CustLoginSetup.php 2014-03-25 06:16:08 UTC (rev 6635) +++ trunk/CustLoginSetup.php 2014-03-25 08:30:00 UTC (rev 6636) @@ -242,7 +242,7 @@ if (isset($_POST['Theme']) and $_POST['Theme'] == $ThemeName){ echo '<option selected="selected" value="' . $ThemeName . '">' . $ThemeName . '</option>'; - } else if (!isset($_POST['Theme']) and ($_SESSION['DefaultTheme']==$ThemeName)) { + } else if (!isset($_POST['Theme']) and ($Theme==$ThemeName)) { echo '<option selected="selected" value="' . $ThemeName . '">' . $ThemeName . '</option>'; } else { echo '<option value="' . $ThemeName . '">' . $ThemeName . '</option>'; Modified: trunk/SuppLoginSetup.php =================================================================== --- trunk/SuppLoginSetup.php 2014-03-25 06:16:08 UTC (rev 6635) +++ trunk/SuppLoginSetup.php 2014-03-25 08:30:00 UTC (rev 6636) @@ -260,7 +260,7 @@ if (isset($_POST['Theme']) and $_POST['Theme'] == $ThemeName){ echo '<option selected="selected" value="' . $ThemeName . '">' . $ThemeName . '</option>'; - } else if (!isset($_POST['Theme']) and ($_SESSION['DefaultTheme']==$ThemeName)) { + } else if (!isset($_POST['Theme']) and ($Theme==$ThemeName)) { echo '<option selected="selected" value="' . $ThemeName . '">' . $ThemeName . '</option>'; } else { echo '<option value="' . $ThemeName . '">' . $ThemeName . '</option>'; Modified: trunk/SystemParameters.php =================================================================== --- trunk/SystemParameters.php 2014-03-25 06:16:08 UTC (rev 6635) +++ trunk/SystemParameters.php 2014-03-25 08:30:00 UTC (rev 6636) @@ -108,9 +108,6 @@ if ($_SESSION['DefaultDateFormat'] != $_POST['X_DefaultDateFormat'] ) { $sql[] = "UPDATE config SET confvalue = '".$_POST['X_DefaultDateFormat']."' WHERE confname = 'DefaultDateFormat'"; } - if ($_SESSION['DefaultTheme'] != $_POST['X_DefaultTheme'] ) { - $sql[] = "UPDATE config SET confvalue = '".$_POST['X_DefaultTheme']."' WHERE confname = 'DefaultTheme'"; - } if ($_SESSION['PastDueDays1'] != $_POST['X_PastDueDays1'] ) { $sql[] = "UPDATE config SET confvalue = '".$_POST['X_PastDueDays1']."' WHERE confname = 'PastDueDays1'"; } @@ -380,22 +377,6 @@ </select></td> <td>' . _('The default date format for entry of dates and display.') . '</td></tr>'; -// DefaultTheme -echo '<tr style="outline: 1px solid"><td>' . _('New Users Default Theme') . ':</td> - <td><select name="X_DefaultTheme">'; -$ThemeDirectory = dir('css/'); -while (false != ($ThemeName = $ThemeDirectory->read())){ - if (is_dir("css/$ThemeName") AND $ThemeName != '.' AND $ThemeName != '..' AND $ThemeName != '.svn'){ - if ($_SESSION['DefaultTheme'] == $ThemeName) { - echo '<option selected="selected" value="' . $ThemeName . '">' . $ThemeName . '</option>'; - } else { - echo '<option value="' . $ThemeName . '">' . $ThemeName . '</option>'; - } - } -} -echo '</select></td> - <td>' . _('The default theme is used for new users who have not yet defined the display colour scheme theme of their choice') . '</td></tr>'; - echo '<tr><th colspan="3">' . _('Accounts Receivable/Payable Settings') . '</th></tr>'; // PastDueDays1 Modified: trunk/WWW_Users.php =================================================================== --- trunk/WWW_Users.php 2014-03-25 06:16:08 UTC (rev 6635) +++ trunk/WWW_Users.php 2014-03-25 08:30:00 UTC (rev 6636) @@ -622,7 +622,7 @@ if (isset($_POST['Theme']) AND $_POST['Theme'] == $ThemeName){ echo '<option selected="selected" value="' . $ThemeName . '">' . $ThemeName . '</option>'; - } else if (!isset($_POST['Theme']) AND ($_SESSION['DefaultTheme']==$ThemeName)) { + } else if (!isset($_POST['Theme']) AND ($Theme==$ThemeName)) { echo '<option selected="selected" value="' . $ThemeName . '">' . $ThemeName . '</option>'; } else { echo '<option value="' . $ThemeName . '">' . $ThemeName . '</option>'; Modified: trunk/Z_ChangeStockCode.php =================================================================== --- trunk/Z_ChangeStockCode.php 2014-03-25 06:16:08 UTC (rev 6635) +++ trunk/Z_ChangeStockCode.php 2014-03-25 08:30:00 UTC (rev 6636) @@ -41,6 +41,8 @@ if ($InputError ==0){ // no input errors + + DB_IgnoreForeignKeys($db); $result = DB_Txn_Begin($db); echo '<br />' . _('Adding the new stock master record'); $sql = "INSERT INTO stockmaster (stockid, @@ -109,22 +111,24 @@ ChangeFieldInTable("mrpdemands", "stockid", $_POST['OldStockID'], $_POST['NewStockID'], $db); //check if MRP tables exist before assuming - - $result = DB_query("SELECT COUNT(*) FROM mrpplannedorders",$db,'','',false,false); - if (DB_error_no($db)==0) { - ChangeFieldInTable("mrpplannedorders", "part", $_POST['OldStockID'], $_POST['NewStockID'], $db); + $sql = "SELECT * FROM mrpparameters"; +- $result = DB_query($sql, $db, '', '', false, false); +- if (DB_error_no($db) == 0) { + $result = DB_query("SELECT COUNT(*) FROM mrpplannedorders",$db,'','',false,false); + if (DB_error_no($db)==0) { + ChangeFieldInTable("mrpplannedorders", "part", $_POST['OldStockID'], $_POST['NewStockID'], $db); + } + + $result = DB_query("SELECT * FROM mrprequirements" , $db,'','',false,false); + if (DB_error_no($db)==0){ + ChangeFieldInTable("mrprequirements", "part", $_POST['OldStockID'], $_POST['NewStockID'], $db); + } + + $result = DB_query("SELECT * FROM mrpsupplies" , $db,'','',false,false); + if (DB_error_no($db)==0){ + ChangeFieldInTable("mrpsupplies", "part", $_POST['OldStockID'], $_POST['NewStockID'], $db); + } } - - $result = DB_query("SELECT * FROM mrprequirements" , $db,'','',false,false); - if (DB_error_no($db)==0){ - ChangeFieldInTable("mrprequirements", "part", $_POST['OldStockID'], $_POST['NewStockID'], $db); - } - - $result = DB_query("SELECT * FROM mrpsupplies" , $db,'','',false,false); - if (DB_error_no($db)==0){ - ChangeFieldInTable("mrpsupplies", "part", $_POST['OldStockID'], $_POST['NewStockID'], $db); - } - ChangeFieldInTable("salesanalysis", "stockid", $_POST['OldStockID'], $_POST['NewStockID'], $db); ChangeFieldInTable("orderdeliverydifferenceslog", "stockid", $_POST['OldStockID'], $_POST['NewStockID'], $db); ChangeFieldInTable("prices", "stockid", $_POST['OldStockID'], $_POST['NewStockID'], $db); Modified: trunk/doc/Change.log =================================================================== --- trunk/doc/Change.log 2014-03-25 06:16:08 UTC (rev 6635) +++ trunk/doc/Change.log 2014-03-25 08:30:00 UTC (rev 6636) @@ -1,5 +1,6 @@ webERP Change Log +24/3/14 Phil: Removed DefaultTheme configuration parameter - unecessary as noted by Serafalcon 23/03/14 Exson: Fixed the no defined variable bugs in WorkOrderIssue.php. Reported by Tim. 23/03/14 Exson: Fixed the bug that the search results shows only limited to DisplayRecordsMax which does not make sense due to pagination in WorkOrderIssue.php. 23/03/14 Exson: Fixed that currency name not available in Prices.php. Modified: trunk/includes/session.inc =================================================================== --- trunk/includes/session.inc 2014-03-25 06:16:08 UTC (rev 6635) +++ trunk/includes/session.inc 2014-03-25 08:30:00 UTC (rev 6636) @@ -195,10 +195,6 @@ If (isset($_POST['Theme']) AND ($_SESSION['UsersRealName'] == $_POST['RealName'])) { $_SESSION['Theme'] = $_POST['Theme']; $Theme = $_POST['Theme']; -} elseif (!isset($_SESSION['Theme'])) { - $Theme = $_SESSION['DefaultTheme']; - $_SESSION['Theme'] = $_SESSION['DefaultTheme']; - } else { $Theme = $_SESSION['Theme']; } Modified: trunk/sql/mysql/upgrade4.11-4.12.sql =================================================================== --- trunk/sql/mysql/upgrade4.11-4.12.sql 2014-03-25 06:16:08 UTC (rev 6635) +++ trunk/sql/mysql/upgrade4.11-4.12.sql 2014-03-25 08:30:00 UTC (rev 6636) @@ -1,4 +1,5 @@ INSERT INTO `systypes` (`typeid` ,`typename` ,`typeno`) VALUES ('600', 'Auto Supplier Number', '0'); INSERT INTO config (confname, confvalue) VALUES ('AutoSupplierNo', '0'); +DELETE FROM config WHERE confname='DefaultTheme'; UPDATE config SET confvalue='4.12' WHERE confname='VersionNumber'; |