# # # # # # # # # require "settings.php"; $pure = isset($_GET["xls"]); # show asset ledger if (isset($_GET["type"]) && $_GET["type"] == "p") { $OUTPUT = prevAssetLedg($pure); } else { $OUTPUT = AssetLedg($pure); } if (isset($_GET["xls"])) { require_lib("xls"); $OUTPUT = clean_html($OUTPUT); StreamXLS("Assets", $OUTPUT); } require "template.php"; # show stock function AssetLedg($pure = false) { extract($_REQUEST); $fields = array(); $fields["group_id"] = 0; $fields["type_id"] = 0; extract($fields, EXTR_SKIP);
#The full software license can be found here: #http://www.accounting-123.com/a.php?a=153/GPLv3 # # # # # # # # # # # require "../settings.php"; # show asset ledger $OUTPUT = AssetLedg(); require "../template.php"; # show stock function AssetLedg() { # Set up table to display in $Assets = "\r\n\t<h3>Asset Ledger</h3>\r\n\t<table border=0 cellpadding='" . TMPL_tblCellPadding . "' cellspacing='" . TMPL_tblCellSpacing . "'>\r\n\t<tr><th>Group</th><th>Serial</th><th>Location</th><th>Description</th><th>Date Bought</th><th>Date Added</th><th>Cost Amount</th><th>Net Value</th></tr>"; db_connect(); $i = 0; $tot = 0; $totnet = 0; $Sl = "SELECT * FROM assets WHERE div = '" . USER_DIV . "' ORDER BY serial"; $Rs = db_exec($Sl) or errDie("Unable to retrieve Asset Ledger from database."); if (pg_numrows($Rs) < 1) { return "<li>There are no Assets recorded on Cubit."; }