# # # # # # # require "settings.php"; require "libs/ext.lib.php"; require_lib("validate"); if (isset($_GET['addcontact'])) { $OUTPUT = AddContact($_GET); $OUTPUT .= printCust($_GET); } else { # show current stock $OUTPUT = printCust($_GET); } require "template.php"; # show stock function printCust($_GET) { # get vars foreach ($_GET as $key => $value) { ${$key} = $value; } if (isset($filter) && !isset($all)) { $sqlfilter = " AND lower({$filter}) LIKE lower('%{$fval}%')"; $show = true; } else { $filter = ""; $fval = "";
# # # # # # # require "settings.php"; require "libs/ext.lib.php"; require_lib("validate"); if (isset($_GET['addcontact'])) { $OUTPUT = AddContact(); $OUTPUT .= printCust(); } else { # show current stock $OUTPUT = printCust(); } require "template.php"; # show stock function printCust() { # Set up table to display in $printCust = "\r\n\t\t\t\t\t<center>\r\n\t\t\t\t\t<h3>Current Customers</h3>\r\n\t\t\t\t\t<table border='1' cellpadding='3' cellspacing='0'>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<th>Department</th>\r\n\t\t\t\t\t\t\t<th>Acc no.</th>\r\n\t\t\t\t\t\t\t<th>Surname/Company</th>\r\n\t\t\t\t\t\t\t<th>Business Tel</th>\r\n\t\t\t\t\t\t\t<th>Home Tel</th>\r\n\t\t\t\t\t\t\t<th>Category</th>\r\n\t\t\t\t\t\t\t<th>Classification</th>\r\n\t\t\t\t\t\t\t<th>Balance</th>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t"; # Query server $tot = 0; $i = 0; # connect to database db_connect(); $sql = "SELECT cusnum,deptname,accno,surname,bustel,tel,catname,classname FROM customers WHERE div = '" . USER_DIV . "' OR ddiv = '" . USER_DIV . "' ORDER BY accno ASC"; $custRslt = db_exec($sql) or errDie("Unable to retrieve Customers from database."); if (pg_numrows($custRslt) < 1) {
function export() { $OUT = clean_html(printCust()); require_lib("xls"); StreamXLS("CustomerList", $OUT); }