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

[<dai...@us...>]

Revision: 5602
          http://web-erp.svn.sourceforge.net/web-erp/?rev=5602&view=rev
Author:   daintree
Date:     2012-08-19 07:04:01 +0000 (Sun, 19 Aug 2012)
Log Message:
-----------


Modified Paths:
--------------
    trunk/SelectCustomer.php
    trunk/doc/Manual/ManualAccountsReceivable.html

Modified: trunk/SelectCustomer.php
===================================================================
--- trunk/SelectCustomer.php	2012-08-15 06:56:02 UTC (rev 5601)
+++ trunk/SelectCustomer.php	2012-08-19 07:04:01 UTC (rev 5602)
@@ -652,7 +652,13 @@
 			}
 		}
 		// Customer Notes
-		$sql = "SELECT * FROM custnotes
+		$sql = "SELECT noteid,
+						debtorno,
+						href,
+						note,
+						date,
+						priority
+				FROM custnotes
 				WHERE debtorno='" . $_SESSION['CustomerID'] . "'
 				ORDER BY date DESC";
 		$result = DB_query($sql, $db);
@@ -677,17 +683,17 @@
 					echo '<tr class="EvenTableRows">';
 					$k = 1;
 				}
-				echo '<td>' . $myrow[4] . '</td>
-					<td>' . $myrow[3] . '</td>
-					<td>' . $myrow[2] . '</td>
-					<td>' . $myrow[5] . '</td>
-					<td><a href="AddCustomerNotes.php?Id=' . $myrow[0] . '&amp;DebtorNo=' . $myrow[1] . '">' . _('Edit') . '</a></td>
-					<td><a href="AddCustomerNotes.php?Id=' . $myrow[0] . '&amp;DebtorNo=' . $myrow[1] . '&amp;delete=1">' . _('Delete') . '</a></td>
+				echo '<td>' . ConvertSQLDate($myrow['date']) . '</td>
+					<td>' . $myrow['note'] . '</td>
+					<td><a href="' . $myrow['href'] . '">' . $myrow['href'] . '</a></td>
+					<td>' . $myrow['priority'] . '</td>
+					<td><a href="AddCustomerNotes.php?Id=' . $myrow['noteid'] . '&amp;DebtorNo=' . $myrow['debtorno'] . '">' . _('Edit') . '</a></td>
+					<td><a href="AddCustomerNotes.php?Id=' . $myrow['noteid'] . '&amp;DebtorNo=' . $myrow['debtorno'] . '&amp;delete=1">' . _('Delete') . '</a></td>
 					</tr>';
 			} //END WHILE LIST LOOP
 			echo '</table>';
 		} else {
-			if ($_SESSION['CustomerID'] != "") {
+			if ($_SESSION['CustomerID'] != '') {
 				echo '<br /><div class="centre"><img src="' . $rootpath . '/css/' . $theme . '/images/note_add.png" title="' . _('Customer Notes') . '" alt="" /><a href="AddCustomerNotes.php?DebtorNo=' . $_SESSION['CustomerID'] . '">' . ' ' . _('Add New Note for this Customer') . '</a></div>';
 			}
 		}

Modified: trunk/doc/Manual/ManualAccountsReceivable.html
===================================================================
--- trunk/doc/Manual/ManualAccountsReceivable.html	2012-08-15 06:56:02 UTC (rev 5601)
+++ trunk/doc/Manual/ManualAccountsReceivable.html	2012-08-19 07:04:01 UTC (rev 5602)
@@ -20,6 +20,8 @@
     <li>Retrospective - de-allocation and re-allocation of receipts or credit notes against charges with re-calculation of differences on exchange and corresponding general ledger journals</li>
 
     <li>Any number of branch - delivery addresses can be added serviced by different sales people with different tax authorities and different areas for sales analysis purposes.</li>
+    
+    <li>Unlimited free form notes can be maintained for each customer and an unlimited number of contacts can be stored against each customer></li>
 </ul><!-- Help Begin: Customers -->
 
 <div class="floatright">
@@ -185,6 +187,10 @@
     <a class="minitext" href="#top">⬆ Top</a>
 </div>
 
+<h2><a id="CustomerNotes">Customer Notes</a></h2>
+
+<p>Customer notes containing any text - a web-link if required and a date can be entered from the Select Customer screen - for the selected customer. The notes are displayed in sequence of priority - so pressing issues appear at the top of the list. These notes might contain information about recent contact with the customer or disputes. There is no checking on the content of the notes and no limit to either the number of notes nor the number of characters that can be used.</p>
+
 <h2>Shippers</h2>
 
 <p>This table is only used as a reference to the method of transportation that the invoice delivery was effected by. The shippers name is what is used in the look ups and the code is a system maintained counter which is stored in the database to reference the freight company used. The consignment note reference can be stored against the transaction in the reference field. In this way a full proof of delivery trail can be maintained.</p>

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