header("Location: /staff/?id=notFound");
exit;
}
$sqltext = "SELECT * FROM contacts,address WHERE contacts.addsid=address.addsid AND contactsid=?";
// print "<br>$sqltext";
$q = $db->select($sqltext, array($_GET['id']), 'i');
$r = $q[0];
$addsid = $r->addsid;
if (isset($_GET['remove']) && $_GET['remove'] == "y" && isset($_GET['id']) && is_numeric($_GET['id'])) {
db_delete("contacts", $_GET['id'], 'contactsid');
header("Location: /contacts/");
exit;
}
if (isset($_GET['go']) && $_GET['go'] == "y") {
// Add to Address table
$addsid = db_updateAddress($_POST, $addsid);
$contactsUpdate = new Contacts();
// Update DB
$contactsUpdate->setContactsid($_GET['id']);
$contactsUpdate->setFname($_POST['fname']);
$contactsUpdate->setSname($_POST['sname']);
$contactsUpdate->setCo_name($_POST['co_name']);
$contactsUpdate->setRole($_POST['role']);
$contactsUpdate->setCustid($_POST['custid']);
$contactsUpdate->setSuppid($_POST['suppid']);
$contactsUpdate->setNotes($_POST['notes']);
$contactsUpdate->updateDB();
header("Location: /contacts/?Updated=" . $result['id']);
exit;
}
$pagetitle = "Edit contact";
$pagetitle = 'Company Details';
$navtitle = 'Home';
$keywords = '';
$description = '';
$addsid = 100;
$fields = array('co_name', 'co_no', 'vat_no', 'colour', 'athenaemail', 'athenaemailpw', 'emailsmtpsrv');
foreach ($fields as $field) {
if (!isset($_POST[$field])) {
$_POST[$field] = '';
}
}
// Check if we have Form Data to process
if (isset($_GET['go']) && $_GET['go'] == "y") {
$logContent = '';
// Update Address table
$addsid = db_updateAddress($_POST, 100);
# Update DB
$ownerUpdate = new Owner();
$ownerUpdate->setOwnerid(100);
$ownerUpdate->setCo_name($_POST['co_name']);
$ownerUpdate->setVat_no($_POST['vat_no']);
$ownerUpdate->setCo_no($_POST['co_no']);
$ownerUpdate->setAthenaemail($_POST['athenaemail']);
$ownerUpdate->setAthenaemailpw($_POST['athenaemailpw']);
$ownerUpdate->setEmailsmtpsrv($_POST['emailsmtpsrv']);
$res = $ownerUpdate->updateDB();
header("Location: index.php?updateOwner=" . $res);
exit;
}
// Define elements for the HTML Header include
$pagetitle = "Edit Your Company Details";
