"; } else { ?>

Staff and Customer Administration

Sorry, as a guest you don't have permission for entering new data! If you want to search for existing DNA data please use the Search function!

"; } if($formSubmitPreview or $formSubmitEditView or $formSubmitSave2) { $sql = "SELECT * from people WHERE ID_People = '$formPeople'"; $result = mysqli_query($GLOBALS["___mysqli_ston"], $sql); while($row = mysqli_fetch_object($result)) { echo ''; } } if(!$formSubmitEditView) { ?>

Please make use of search function before entering new person.

Person

0) { $sqlupdate = "UPDATE people SET FormOfAddress = '$formFormOfAddress', Title = '$formTitle', Forename = '$formForename', Surname = '$formSurname', Name_All = '$Name_All', Phone = '$formPhone', Email = '$formEmail', Remarks = '$formNotes', Institut = '$formInstitut', Division = '$formDivision', Street = '$formStreet', City = '$formCity', Postal_Code = '$formPostal_Code', Country = '$formCountry', Institut_Delivery = '$formInstitut2', Division_Delivery = '$formDivision2', Street_Delivery = '$formStreet2', City_Delivery = '$formCity2', Postal_Code_Delivery = '$formPostal_Code2', Country_Delivery = '$formCountry2', Staff = '$formStaff', Provider = '$formProvider', Customer = '$formCustomer2', Updated_When = '$Current_Date', Updated_Who = '$log' WHERE Email = '$formEmail'"; $resultupdate = mysqli_query($GLOBALS["___mysqli_ston"], $sqlupdate); ###############################################Error resultupdate#################################################### if(!$resultupdate) { $msg = $sqlupdate."\n"; $msg .= "####Error resultupdate####"; if($debug == '1') echo $msg; trigger_error($msg, E_USER_ERROR); include ("../config/Errorreport.php"); $error = "true"; } ######################################################################################################### } else { $sqlinsert = "INSERT INTO people (FormOfAddress, Title, Forename, Surname, Phone, Email, Remarks, Name_All, Institut, Division, Street, City, Postal_Code, Country, Institut_Delivery, Division_Delivery, Street_Delivery, City_Delivery, Postal_Code_Delivery, Country_Delivery, Staff, Provider, Customer, Created_Who) VALUES ('$formFormOfAddress','$formTitle','$formForename','$formSurname','$formPhone','$formEmail','$formNotes','$Name_All','$formInstitut','$formDivision','$formStreet','$formCity','$formPostal_Code','$formCountry','$formInstitut2','$formDivision2','$formStreet2','$formCity2','$formPostal_Code2','$formCountry2','$formStaff','$formProvider','$formCustomer2','$log')"; $resultinsert = mysqli_query($GLOBALS["___mysqli_ston"], $sqlinsert); ###############################################Error insert2#################################################### if(!$resultinsert) { $msg = $sqlinsert."\n"; $msg .= "####Error insert2####"; if($debug == '1') echo $msg; trigger_error($msg, E_USER_ERROR); include ("../config/Errorreport.php"); $error = "true"; } ######################################################################################################### } } build_select_list("formPeople", "SELECT DISTINCT ID_People, Name_All FROM people ORDER BY Name_All", $formPeople); ?>

"; include("../config/DataSaved.php"); echo "

'; if($formSubmitEditView) { echo '

'; } echo '


Form of address	'; if($formSubmitEditView) { echo ''; } else { echo $row->FormOfAddress; } echo '	Title	'; if($formSubmitEditView) { echo ''; } else { echo $row->Title; } echo '
Family name	'; if($formSubmitEditView) { echo ''; } else { echo $row->Surname; } echo '	First name	'; if($formSubmitEditView) { echo ''; } else { echo $row->Forename; } echo '
Email	'; if($formSubmitEditView) { echo ''; } else { echo $row->Email; } echo '	Phone	'; if($formSubmitEditView) { echo ''; } else { echo $row->Phone; } echo '
Billing Address *		Address for delivery (if other than the billing address)
Institution	'; if($formSubmitEditView) { echo ''; } else { echo $row->Institut; } echo '	Institution	'; if($formSubmitEditView) { echo ''; } else { echo $row->Institut_Delivery; } echo '
Division	'; if($formSubmitEditView) { echo ''; } else { echo $row->Division; } echo '	Division	'; if($formSubmitEditView) { echo ''; } else { echo $row->Division_Delivery; } echo '
Street/P.O. Box	'; if($formSubmitEditView) { echo ''; } else { echo $row->Street; } echo '	Street/P.O. Box	'; if($formSubmitEditView) { echo ''; } else { echo $row->Street_Delivery; } echo '
Postal Code	'; if($formSubmitEditView) { echo ''; } else { echo $row->Postal_Code; } echo '	Postal Code	'; if($formSubmitEditView) { echo ''; } else { echo $row->Postal_Code_Delivery; } echo '
Location/City	'; if($formSubmitEditView) { echo ''; } else { echo $row->City; } echo '	Location/City	'; if($formSubmitEditView) { echo ''; } else { echo $row->City_Delivery; } echo '
Country	'; if($formSubmitEditView) { echo ''; } else { echo $row->Country; } echo '	Country	'; if($formSubmitEditView) { echo ''; } else { echo $row->Country_Delivery; } echo '
Notes	'; if($formSubmitEditView) { echo ''.$row->Remarks.''; } else { echo $row->Remarks; } echo '	Staff Staff == "yes") { echo "checked"; } if(!$formSubmitEditView) { echo ' disabled'; } echo '/> Provider Provider == "yes") { echo "checked"; } if(!$formSubmitEditView) { echo ' disabled'; } echo '/> Customer Customer == "yes") { echo "checked"; } if(!$formSubmitEditView) { echo ' disabled'; } echo '/>
	'; if($formSubmitEditView) { echo ''; } else { echo ''; } echo '

'; if($formSubmitEditView) { echo '

'; } echo '

Add new Person

id="hiddenPerson">

0) { echo "Person already exist in database (Email: ".$Explode[4]."). You can edit details and group membership."; while($row = mysqli_fetch_object($resulttest)) { $ImportFormOfAddress = $row->FormOfAddress; $ImportTitle = $row->Title; $ImportSurname = $row->Surname; $ImportForename = $row->Forename; $ImportEmail = $row->Email; $ImportInstitut = $row->Institut; $ImportDivision = $row->Division; $ImportStreet = $row->Street; $ImportCity = $row->City; $ImportPostal_Code = $row->Postal_Code; $ImportCountry = $row->Country; $ImportInstitut_Delivery = $row->Institut_Delivery; $ImportDivision_Delivery = $row->Division_Delivery; $ImportStreet_Delivery = $row->Street_Delivery; $ImportCity_Delivery = $row->City_Delivery; $ImportPostal_Code_Delivery = $row->Postal_Code_Delivery; $ImportCountry_Delivery = $row->Country_Delivery; $ImportRemarks = $row->Remarks; $ImportStaff = $row->Staff; $ImportProvider = $row->Provider; $ImportCustomer = $row->Customer; } } else { $ImportFormOfAddress = $Explode[0]; $ImportTitle = $Explode[1]; $ImportSurname = $Explode[2]; $ImportForename = $Explode[3]; $ImportEmail = $Explode[4]; $ImportInstitut = $Explode[5]; $ImportDivision = $Explode[6]; $ImportStreet = $Explode[7]; $ImportCity = $Explode[8]; $ImportPostal_Code = $Explode[9]; $ImportCountry = $Explode[10]; $ImportInstitut_Delivery = $Explode[11]; $ImportDivision_Delivery = $Explode[12]; $ImportStreet_Delivery = $Explode[13]; $ImportCity_Delivery = $Explode[14]; $ImportPostal_Code_Delivery = $Explode[15]; $ImportCountry_Delivery = $Explode[16]; $ImportRemarks = $Explode[17]; $ImportCustomer = 'yes'; } } if($formSubmitSave and $_POST['importcustomerdata'] == "") { { echo "Please enter customer data manually if you don't have a standardised preorder email from the webportal."; } } ?>

Import customer data from Preorder Email		Help

Alternative entry
Form of address		Title	"/>
Family name *	">	First name *	">
Email *	">	Phone
Billing Address *		Address for delivery (if other than the billing address)
Institution	">	Institution	">
Division	">	Division	">
Street/P.O. Box	">	Street/P.O. Box	">
Postal Code	">	Postal Code	">
Location/City	">	Location/City	">
Country	">	Country	">
Notes	<?php if($formSubmitSave and $ImportRemarks != "") { echo $ImportRemarks; }?>	Staff > Provider > Customer > *

After finishing close this window and reload the other site.