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

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

Revision: 3723
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3723&view=rev
Author:   tim_schofield
Date:     2010-09-10 10:11:54 +0000 (Fri, 10 Sep 2010)

Log Message:
-----------
Layout improvements

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

Modified: trunk/PeriodsInquiry.php
===================================================================
--- trunk/PeriodsInquiry.php	2010-09-08 21:41:50 UTC (rev 3722)
+++ trunk/PeriodsInquiry.php	2010-09-10 10:11:54 UTC (rev 3723)
@@ -19,39 +19,61 @@
 $ErrMsg =  _('No periods were returned by the SQL because');
 $PeriodsResult = DB_query($SQL,$db,$ErrMsg);
 
+	echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/transactions.png" title="' . $title . '" alt="">' . ' '
+		. $title . '</p>';
 
 /*show a table of the orders returned by the SQL */
 
-echo '<table cellpadding=2 colspan=2>';
+$NumberOfPeriods = DB_num_rows($PeriodsResult);
+$PeriodsInTable = round($NumberOfPeriods/3,0);
 
 $TableHeader = '<tr><th>' . _('Period Number') . '</th>
 			<th>' . _('Date of Last Day') . '</th>
 		</tr>';
-
+echo '<table><tr>';
+for ($i=0;$i<2;$i++) {
+	echo '<td>';
+	echo '<table cellpadding=2 colspan=2 class=selection>';
+	echo $TableHeader;
+	$k=0;
+	for ($j=0; $j<$PeriodsInTable;$j++) {
+		$myrow=DB_fetch_array($PeriodsResult);
+		if ($k==1){
+			echo '<tr class="EvenTableRows">';
+			$k=0;
+		} else {
+			echo '<tr class="OddTableRows">';
+			$k++;
+		}
+		$FormatedLastDate = ConvertSQLDate($myrow['lastdate_in_period']);
+		echo "<td>".$myrow['periodno']."</td>
+			<td>".$FormatedLastDate."</td>
+			</tr>";
+	}
+	echo '</table>';
+	echo '</td>';
+}
+echo '<td>';
+echo '<table cellpadding=2 colspan=2 class=selection>';
 echo $TableHeader;
-
-$j = 1;
-$k=0; //row colour counter
+$k = 0; //row colour counter
 while ($myrow=DB_fetch_array($PeriodsResult)) {
-       if ($k==1){
-              echo '<tr class="EvenTableRows">';
-              $k=0;
-       } else {
-              echo '<tr class="OddTableRows">';
-              $k++;
-       }
-
-       $FormatedLastDate = ConvertSQLDate($myrow['lastdate_in_period']);
-       printf("<td><font size=2>%s</td>
-		<td>%s</td>
-		</tr>",
-		$myrow['periodno'],
-		$FormatedLastDate);
-
+	if ($k==1){
+		echo '<tr class="EvenTableRows">';
+		$k=0;
+	} else {
+		echo '<tr class="OddTableRows">';
+		$k++;
+	}
+	$FormatedLastDate = ConvertSQLDate($myrow['lastdate_in_period']);
+	echo "<td>".$myrow['periodno']."</td>
+		<td>".$FormatedLastDate."</td>
+		</tr>";
 }
+echo '</table>';
+echo '</td>';
+echo '</tr></table>';
 //end of while loop
 
-echo '</table>';
-
 include('includes/footer.inc');
 ?>

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-09-08 21:41:50 UTC (rev 3722)
+++ trunk/doc/Change.log.html	2010-09-10 10:11:54 UTC (rev 3723)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>10/09/10 Tim: PeriodsInquiry.php - Layout improvements</p>
 <p>08/09/10 Tim: PDFTopItems.php - Correct the sql quoting</p>
 <p>08/09/10 Tim: PDFSuppTransListing.php - Screen layout improvements. Correct the sql quoting</p>
 <p>08/09/10 Tim: PDFStockTransfer.php - Correct the sql quoting</p>


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