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

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

Revision: 3657
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3657&view=rev
Author:   tim_schofield
Date:     2010-07-22 12:15:25 +0000 (Thu, 22 Jul 2010)

Log Message:
-----------
New script that provides a simple list of assets and their properties.

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

Added Paths:
-----------
    trunk/FixedAssetList.php

Added: trunk/FixedAssetList.php
===================================================================
--- trunk/FixedAssetList.php	                        (rev 0)
+++ trunk/FixedAssetList.php	2010-07-22 12:15:25 UTC (rev 3657)
@@ -0,0 +1,46 @@
+<?php
+$PageSecurity = 11;
+
+include('includes/session.inc');
+$title = _('Fixed Asset Properties List');
+include('includes/header.inc');
+echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/maintenance.png" title="' .
+	 _('Search') . '" alt="">' . ' ' . $title;
+
+$sql='SELECT stockmaster.stockid,
+			assetmanager.serialno,
+			stockmaster.description,
+			stockcatproperties.label,
+			stockitemproperties.value
+		FROM assetmanager
+		LEFT JOIN stockmaster
+			ON assetmanager.stockid=stockmaster.stockid
+		LEFT JOIN stockcatproperties
+			ON stockmaster.categoryid=stockcatproperties.categoryid
+		LEFT JOIN stockitemproperties
+			ON stockcatproperties.stkcatpropid=stockitemproperties.stkcatpropid
+		WHERE stockmaster.stockid=stockitemproperties.stockid
+		ORDER BY assetmanager.serialno,stockmaster.stockid';
+
+$result=DB_query($sql, $db);
+echo '<table class=selection>';
+echo '<tr>';
+echo '<th>'._('Asset Type').'</th>';
+echo '<th>'._('Asset Reference').'</th>';
+echo '<th>'._('Description').'</th>';
+echo '<th>'._('Depreciation %').'</th>';
+echo '</tr>';
+while ($myrow=DB_fetch_array($result)) {
+	if ($myrow['value']!='Straight Line') {
+		echo '<tr>';
+		echo '<td>'.$myrow['description'].'</td>
+			<td>'.$myrow['serialno'].'</td>
+			<td>'.$myrow['label'].'</td>
+			<td class=number>'.$myrow['value'].'%</td>';
+		echo '</tr>';
+	}
+}
+echo '</table>';
+
+include('includes/footer.inc');
+?>
\ No newline at end of file

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-07-22 12:14:57 UTC (rev 3656)
+++ trunk/doc/Change.log.html	2010-07-22 12:15:25 UTC (rev 3657)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>22/07/10 Simon Peter Otandeka: FixedAssetList.php - New script that provides a simple list of assets and their properties.</p>
 <p>22/07/10 Tim: FixedAssetJournal.php - Corrections to depreciation calculation layout changes, and sql quoting</p>
 <p>22/07/10 Tim: SalesGraph.php - Update to latest phplot, add in choice of graph types layout changes, and sql quoting</p>
 <p>20/07/10 Tim: PcAuthoriseExpenses.php - Layout changes, and sql quoting</p>

Modified: trunk/index.php
===================================================================
--- trunk/index.php	2010-07-22 12:14:57 UTC (rev 3656)
+++ trunk/index.php	2010-07-22 12:15:25 UTC (rev 3657)
@@ -1285,6 +1285,11 @@
 							</tr>
 							<tr>
 							<td class="menu_group_item">
+								<?php echo '<p>&bull; <a href="' . $rootpath . '/FixedAssetList.php?' . sid . '">' . _('List Asset properties') . '</a></p>'; ?>
+							</td>
+							</tr>
+							<tr>
+							<td class="menu_group_item">
 								<?php echo GetRptLinks('fa'); ?>
 							</td>
 							</tr>


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