[Web-erp-svn] SF.net SVN: web-erp:[5722] trunk/Departments.php

[<sam...@us...>]

Revision: 5722
          http://sourceforge.net/p/web-erp/reponame/5722
Author:   samudaya
Date:     2012-10-20 07:28:36 +0000 (Sat, 20 Oct 2012)
Log Message:
-----------
Fixed the problem of Authoriser drop down selection when try to edit a Internal Departments.

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

Modified: trunk/Departments.php
===================================================================
--- trunk/Departments.php	2012-10-20 06:23:32 UTC (rev 5721)
+++ trunk/Departments.php	2012-10-20 07:28:36 UTC (rev 5722)
@@ -7,7 +7,7 @@
 
 include('includes/header.inc');
 echo '<p class="page_title_text"><img src="' . $rootpath . '/css/' . $theme . '/images/magnifier.png" title="' .
-		_('Search') . '" alt="" />' . ' ' . $title . '</p>';
+		_('Top Sales Order Search') . '" alt="" />' . ' ' . $title . '</p>';
 
 if ( isset($_GET['SelectedDepartmentID']) )
 	$SelectedDepartmentID = $_GET['SelectedDepartmentID'];
@@ -159,7 +159,7 @@
 					description,
 					authoriser
 			FROM departments
-			ORDER BY description";
+			ORDER BY departmentid";
 
 	$ErrMsg = _('There are no departments created');
 	$result = DB_query($sql,$db,$ErrMsg);
@@ -208,7 +208,8 @@
 		//editing an existing section
 
 		$sql = "SELECT departmentid,
-						description
+						description,
+						authoriser
 				FROM departments
 				WHERE departmentid='" . $SelectedDepartmentID . "'";
 
@@ -221,6 +222,7 @@
 
 			$_POST['DepartmentID'] = $myrow['departmentid'];
 			$_POST['DepartmentName']  = $myrow['description'];
+			$AuthoriserID			= $myrow['authoriser'];
 
 			echo '<input type="hidden" name="SelectedDepartmentID" value="' . $_POST['DepartmentID'] . '" />';
 			echo '<table class="selection">';
@@ -240,7 +242,7 @@
 	$usersql="SELECT userid FROM www_users";
 	$userresult=DB_query($usersql,$db);
 	while ($myrow=DB_fetch_array($userresult)) {
-		if ($myrow['userid']==$UserID) {
+		if ($myrow['userid']==$AuthoriserID) {
 			echo '<option selected="True" value="'.$myrow['userid'].'">'.$myrow['userid'].'</option>';
 		} else {
 			echo '<option value="'.$myrow['userid'].'">'.$myrow['userid'].'</option>';