From: <ex...@us...> - 2013-12-27 03:42:42
|
Revision: 6520 http://sourceforge.net/p/web-erp/reponame/6520 Author: exsonqu Date: 2013-12-27 03:42:39 +0000 (Fri, 27 Dec 2013) Log Message: ----------- 27/12/13 Thumb: Fixed the stock location will loss problem when move to StockAdjustmentsControlled.php interface in StockAdjustments.php. Modified Paths: -------------- trunk/StockAdjustments.php Modified: trunk/StockAdjustments.php =================================================================== --- trunk/StockAdjustments.php 2013-12-26 18:45:22 UTC (rev 6519) +++ trunk/StockAdjustments.php 2013-12-27 03:42:39 UTC (rev 6520) @@ -77,8 +77,24 @@ if (isset($_POST['Narrative'])){ $_SESSION['Adjustment' . $identifier]->Narrative = $_POST['Narrative']; } + +$sql = "SELECT loccode, locationname FROM locations"; +$resultStkLocs = DB_query($sql,$db); +$LocationList=array(); +while ($myrow=DB_fetch_array($resultStkLocs)){ + $LocationList[$myrow['loccode']]=$myrow['locationname']; +} + if (isset($_POST['StockLocation'])){ $_SESSION['Adjustment' . $identifier]->StockLocation = $_POST['StockLocation']; +}else{ + if(empty($_SESSION['Adjustment' . $identifier]->StockLocation)){ + if(empty($_SESSION['UserStockLocation'])){ + $_SESSION['Adjustment' . $identifier]->StockLocation=key(reset($LocationList)); + }else{ + $_SESSION['Adjustment' . $identifier]->StockLocation=$_SESSION['UserStockLocation']; + } + } } if (isset($_POST['Quantity'])){ if ($_POST['Quantity']=='' OR !is_numeric(filter_number_format($_POST['Quantity']))){ @@ -90,6 +106,9 @@ if($_POST['Quantity'] != 0){//To prevent from serilised quantity changing to zero $_SESSION['Adjustment' . $identifier]->Quantity = filter_number_format($_POST['Quantity']); } +if(isset($_GET['OldIdentifier'])){ + $_SESSION['Adjustment'.$identifier]->StockLocation=$_SESSION['Adjustment'.$_GET['OldIdentifier']]->StockLocation; +} echo '<p class="page_title_text"><img src="'.$RootPath.'/css/'.$Theme.'/images/supplier.png" title="' . _('Inventory Adjustment') . '" alt="" />' . ' ' . _('Inventory Adjustment') . '</p>'; @@ -120,7 +139,7 @@ echo '<tr> <td>' . $myrow[0] . '</td> <td>' . $myrow[1] . '</td> - <td><a href="StockAdjustments.php?StockID='.$myrow[0].'&Description='.$myrow[1].'">' . _('Adjust') . '</a> + <td><a href="StockAdjustments.php?StockID='.$myrow[0].'&Description='.$myrow[1].'&OldIdentifier='.$identifier.'">' . _('Adjust') . '</a> </tr>'; } echo '</table>'; @@ -285,7 +304,6 @@ $ErrMsg = _('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' ._('The location stock record could not be updated because'); $DbgMsg = _('The following SQL to update the stock record was used'); - $Result = DB_query($SQL, $db, $ErrMsg, $DbgMsg, true); if ($_SESSION['CompanyRecord']['gllink_stock']==1 AND $_SESSION['Adjustment' . $identifier]->StandardCost > 0){ @@ -424,23 +442,13 @@ </tr>'; } -echo '<tr><td>' . _('Adjustment to Stock At Location').':</td> - <td><select name="StockLocation"> '; - -$sql = "SELECT loccode, locationname FROM locations"; -$resultStkLocs = DB_query($sql,$db); -while ($myrow=DB_fetch_array($resultStkLocs)){ - if (isset($_SESSION['Adjustment' . $identifier]->StockLocation)){ - if ($myrow['loccode'] == $_SESSION['Adjustment' . $identifier]->StockLocation){ - echo '<option selected="selected" value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>'; - } else { - echo '<option value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>'; - } - } elseif ($myrow['loccode']==$_SESSION['UserStockLocation']){ - echo '<option selected="selected" value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>'; - $_POST['StockLocation']=$myrow['loccode']; +echo '<tr><td>'. _('Adjustment to Stock At Location').':</td> + <td><select name="StockLocation" onchange="submit();"> '; +foreach ($LocationList as $Loccode=>$Locationname){ + if ($Loccode == $_SESSION['Adjustment' . $identifier]->StockLocation){ + echo '<option selected="selected" value="' . $Loccode . '">' . $Locationname . '</option>'; } else { - echo '<option value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>'; + echo '<option value="' . $Loccode . '">' . $Locationname . '</option>'; } } |