[Weberp-cvs] SF.net SVN: web-erp:[3705] trunk

[<tim...@us...>]

Revision: 3705
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3705&view=rev
Author:   tim_schofield
Date:     2010-09-05 13:08:32 +0000 (Sun, 05 Sep 2010)

Log Message:
-----------
Show authorised, notes, and receipt fields correctly. Changed to use DB_fetch_array() rather than DB_fetch_row().

Modified Paths:
--------------
    trunk/PcAssignCashToTab.php
    trunk/doc/Change.log.html

Modified: trunk/PcAssignCashToTab.php
===================================================================
--- trunk/PcAssignCashToTab.php	2010-09-05 10:36:19 UTC (rev 3704)
+++ trunk/PcAssignCashToTab.php	2010-09-05 13:08:32 UTC (rev 3705)
@@ -217,7 +217,7 @@
 
 		$k=0; //row colour counter
 
-	while ($myrow = DB_fetch_row($result)) {
+	while ($myrow = DB_fetch_array($result)) {
 		if ($k==1){
 			echo '<tr class="EvenTableRows">';
 			$k=0;
@@ -237,28 +237,28 @@
 			$Description['0']='ASSIGNCASH';
 		}
 
-		if (($myrow['5'] == "0000-00-00") and ($Description['0'] == 'ASSIGNCASH')){
+		if (($myrow['authorized'] == "0000-00-00") and ($Description['0'] == 'ASSIGNCASH')){
 			// only cash assignations NOT authorized can be modified or deleted
-			echo "<td>".ConvertSQLDate($myrow['2'])."</td>
+			echo "<td>".ConvertSQLDate($myrow['date'])."</td>
 				<td>".$Description['0']."</td>
-				<td class=number>".number_format($myrow['4'],2)."</td>
-				<td>".ConvertSQLDate($myrow['5'])."</td>
-				<td>".$myrow['7']."</td>
-				<td>".$myrow['8']."</td>
-				<td><a href='".$_SERVER['PHP_SELF'] . '?' . SID ."SelectedIndex=".$myrow['0']."&SelectedTabs=" .
+				<td class=number>".number_format($myrow['amount'],2)."</td>
+				<td>".ConvertSQLDate($myrow['authorized'])."</td>
+				<td>".$myrow['notes']."</td>
+				<td>".$myrow['receipt']."</td>
+				<td><a href='".$_SERVER['PHP_SELF'] . '?' . SID ."SelectedIndex=".$myrow['counterindex']."&SelectedTabs=" .
 					$SelectedTabs . "&Days=" . $Days . "&edit=yes'>" . _('Edit') . "</td>
-				<td><a href='".$_SERVER['PHP_SELF'] . '?' . SID ."SelectedIndex=".$myrow['0']."&SelectedTabs=" .
+				<td><a href='".$_SERVER['PHP_SELF'] . '?' . SID ."SelectedIndex=".$myrow['counterindex']."&SelectedTabs=" .
 					$SelectedTabs . "&Days=" . $Days . "&delete=yes' onclick=\"return confirm('" .
 						_('Are you sure you wish to delete this code and the expense it may have set up?') . "');\">" .
 							_('Delete') . "</td>
 				</tr>";
 		}else{
-			echo "<td>".ConvertSQLDate($myrow['2'])."</td>
+			echo "<td>".ConvertSQLDate($myrow['date'])."</td>
 				<td>".$Description['0']."</td>
-				<td class=number>".number_format($myrow['4'],2)."</td>
-				<td>".ConvertSQLDate($myrow['5'])."</td>
-				<td>".ConvertSQLDate($myrow['5'])."</td>
-				<td>".$myrow['7']."</td>
+				<td class=number>".number_format($myrow['amount'],2)."</td>
+				<td>".ConvertSQLDate($myrow['authorized'])."</td>
+				<td>".$myrow['notes']."</td>
+				<td>".$myrow['receipt']."</td>
 				</tr>";
 		}
 	}

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-09-05 10:36:19 UTC (rev 3704)
+++ trunk/doc/Change.log.html	2010-09-05 13:08:32 UTC (rev 3705)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>05/09/10 Tim: PcAssignCashToTab.php - Show authorised, notes, and receipt fields correctly. Changed to use DB_fetch_array() rather than DB_fetch_row().</p>
 <p>05/09/10 Tim: PDFStockTransListing.php - List stock transactions by transaction type.</p>
 <p>05/09/10 Ricard: upgrade3.11.1-3.12.sql - Database changes required for changes to report writer.</p>
 <p>31/08/10 Tim: StockLocTransfer.php - Change quantity input field to have more than 5 digits</p>


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.