# # # # # # # # # # # 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}%')";
# # # # # # # # # # # 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
$contactemail1 = GetVariable("contactemail1"); $contactemail2 = GetVariable("contactemail2"); $contactemail3 = GetVariable("contactemail3"); $contactwebsite = GetVariable("contactwebsite"); $contactcompany = GetVariable("contactcompany"); $contactdepartment = GetVariable("contactdepartment"); /* determine action */ switch ($action) { case 'addcontactform': DisplayContactForm("add", $id); break; case 'editcontactform': DisplayContactForm("edit", $id, $contactid); break; case 'add': AddContact($id, $contactfullname, $contacttitle, $contactaddress1, $contactaddress2, $contactaddress3, $contactcity, $contactstate, $contactcountry, $contactphone1, $contactphone2, $contactphone3, $contactemail1, $contactemail2, $contactemail3, $contactwebsite, $contactcompany, $contactdepartment); break; default: DisplayInstanceControlPanel($id); } /* ------------------------------------ functions ------------------------------------ */ /* -------------------------------------------- */ /* ------- UpdateContact ---------------------- */ /* -------------------------------------------- */ function UpdateContact($id, $contactid, $contactfullname, $contacttitle, $contactaddress1, $contactaddress2, $contactaddress3, $contactcity, $contactstate, $contactcountry, $contactphone1, $contactphone2, $contactphone3, $contactemail1, $contactemail2, $contactemail3, $contactwebsite, $contactcompany, $contactdepartment) { /* perform data checks */ $contactfullname = mysql_real_escape_string($contactfullname); $contacttitle = mysql_real_escape_string($contacttitle); $contactaddress1 = mysql_real_escape_string($contactaddress1); $contactaddress2 = mysql_real_escape_string($contactaddress2);