Source for file new_People.php

Documentation is available at new_People.php

  1. <?php
  2. /**
  3. * Input new people (lab staff, customers, providers)
  4. * <br/><br/>
  5. * Access to all user except of guests
  6. * @author Gabriele Droege, DNA Bank Network <contact@dnabank-network.org>
  7. * @version 2.0
  8. * @package Input
  9. * @copyright Copyright © 2011 DNA Bank Network http://www.dnabank-network.org<br>The contents of this file are subject to the Mozilla Public License Version 1.1
  10. * @filesource
  11. * @license http://www.mozilla.org/MPL/ MPL
  12. */
  13.  
  14.     /**
  15.     * calling connection to database
  16.     */
  17.     include ("../config/head.php");
  18.  
  19.     /**
  20.     * calling authorisation script
  21.     */
  22.     include ("../auth.php");
  23. ?>
  24. <html>
  25.  
  26. <head>
  27. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  28. <title>DNA Module - Staff and Customer Administration</title>
  29. <link rel="stylesheet" type="text/css" href="../format.css">
  30. <SCRIPT LANGUAGE="JavaScript1.1" src="../Functions.js"></SCRIPT>
  31. <NOSCRIPT>Please enable Javascript!</NOSCRIPT>
  32.  
  33. </head>
  34. <body>
  35. <div align="center">
  36. <?php 
  37.   /**
  38.   * including navigation menu
  39.   */
  40. include("../tablenavi.php"); ?>
  41. <form name="formular" method="POST" action="new_People.php"> 
  42. <table id="tablemain" class="main">
  43.     <tr>
  44.   <td id="tdLogo"><a href="<?php echo $Path_Wiki."/Features#Input"; ?>" target="_blank"><img border="0" src="../images/Logo-Wiki.png" height="78"></a></td>
  45.           <td>
  46.         <h1>Staff and Customer Administration</h1></td>
  47.     <td id="tdLogo2"><?php echo $Path_Logo; ?></td>
  48.     </tr>
  49.   <tr>
  50.   <td colspan="3"><?php
  51.     echo "Logged in as: ";
  52.     $log = $_SESSION["log"];
  53.     echo $log;
  54.  
  55.     ?></td>
  56. </tr>
  57. <?php if (isset($_SESSION['guest']) || $_SESSION['guest']) {
  58.     /********************************************************************************************
  59.     * Guests don't have permission for entering new DNA data                                    *
  60.     *********************************************************************************************/
  61. echo "<tr><td colspan='3'><span class='error'>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!</span></td></tr>"; }
  62.  
  63. else { ?>
  64.  
  65.  
  66.  
  67. <tr><td colspan="3" valign="top">
  68. <table border="0" id="table2"><tr><td colspan="2"><b>Please make use of search function before entering new person.</b></td></tr>
  69. <tr><td id="DescriptionBlack">Person</td><td>
  70. <?php build_select_list("formPeople",
  71.                       "SELECT DISTINCT ID_People, Name_All FROM people
  72.                       ORDER BY Name_All", $formPeople); ?></td></tr>
  73. <tr><td id="DescriptionBlack"></td><td id="tdbutton"><input type="submit" value="Show details" name="formSubmitPreview" class="button"/></td>    </tr>    
  74.  
  75. <?php
  76.  
  77. $Current_Date = date('Y-m-d H:i:s');  
  78. if($formSubmitSave2) {
  79. $sqltest = "SELECT * from people where Email = '$formEmail'";
  80. $resulttest = mysql_query($sqltest);
  81.  
  82. $Name_All = $formSurname;
  83. if($formForename != "") { $Name_All .= ", ".$formForename; }
  84.  
  85. if(mysql_num_rows($resulttest) > 0) {
  86.  
  87. $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', ExtractionStaff = '$formExtraction', Provider = '$formProvider', Customer = '$formCustomer2', Updated_When = '$Current_Date', Updated_Who = '$log' WHERE Email = '$formEmail'";
  88. $resultupdate = mysql_query($sqlupdate); 
  89.  
  90. ###############################################Error resultupdate####################################################
  91.  
  92. if(!$resultupdate)
  93.      { 
  94.   $msg = $sqlupdate."\n";
  95.   $msg .= "####Error resultupdate####";
  96.   trigger_error($msg, E_USER_ERROR);
  97.   include ("../config/Errorreport.php"); 
  98.   $error = "true"; } 
  99.          
  100. #########################################################################################################  
  101. if($resultupdate) {  echo "<tr><td colspan='2' align='right'><div class='search'><span class='fine'>Data have been saved.</span></div></td></tr>";  }
  102.  
  103. }
  104.  
  105. else {
  106.  
  107. $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, ExtractionStaff, 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','$formExtraction','$formProvider','$formCustomer2','$log')";
  108. $resultinsert = mysql_query($sqlinsert); 
  109.  
  110. ###############################################Error insert2####################################################
  111.  
  112.  
  113. if(!$resultinsert)
  114.      { 
  115.   $msg = $sqlinsert."\n";
  116.   $msg .= "####Error insert2####";
  117.   trigger_error($msg, E_USER_ERROR);
  118.   include ("../config/Errorreport.php"); 
  119.   $error = "true"; } 
  120.          
  121. #########################################################################################################  
  122. } 
  123. if($resultinsert) {  echo "<tr><td colspan='2' align='right'><div class='search'><span class='fine'>Data have been saved.</span></div></td></tr>";  }
  124.  
  125. }
  126.  
  127.  
  128.  
  129.  
  130. if($formSubmitPreview or $formSubmitEditView or $formSubmitSave2) {
  131.  
  132. $sql = "SELECT * from people WHERE ID_People = '$formPeople'";
  133. $result = mysql_query($sql);
  134. while($row = mysql_fetch_object($result)) {
  135. echo '<tr><td colspan="2">';
  136.   if($formSubmitEditView) { echo '<div class="geography2">'; }
  137.   echo '<table width="90%"><tr><td colspan="4"><hr /></td></tr>
  138.   <tr><td id="DescriptionGreen">Form of address</td><td>';
  139.   if($formSubmitEditView) { echo '<select name="formFormOfAddress" id="InputLong"><option value="">------</option>
  140.       <option value="Mr"'; if($row->FormOfAddress == "Mr") { echo ' selected'; }
  141.       echo '>Mr</option><option value="Mrs"'; if($row->FormOfAddress == "Mrs") { echo ' selected'; }
  142.       echo '>Mrs</option><option value="Ms"'; if($row->FormOfAddress == "Ms") { echo ' selected'; }
  143.       echo '>Ms</option></select>';   }
  144.   else { echo $row->FormOfAddress; }
  145.   echo '</td><td id="DescriptionGreen">Title</td><td>';
  146.   if($formSubmitEditView) { echo '<input type="text" name="formTitle" id="InputLong" value="'.$row->Title.'">'; }
  147.   else { echo $row->Title; }
  148.   echo '</td></tr>
  149.   <tr><td id="DescriptionGreen">Family name</td><td>';
  150.   if($formSubmitEditView) { echo '<input type="text" name="formSurname" id="InputLong" value="'.$row->Surname.'">'; }
  151.   else { echo $row->Surname; }
  152.   echo '</td><td id="DescriptionGreen">First name</td><td>';
  153.   if($formSubmitEditView) { echo '<input type="text" name="formForename" id="InputLong" value="'.$row->Forename.'">'; }
  154.   else { echo $row->Forename; }
  155.   echo '</td></tr>
  156.   <tr><td id="DescriptionGreen">Email</td><td>';
  157.   if($formSubmitEditView) { echo '<input type="text" name="formEmail" id="InputLong" value="'.$row->Email.'">'; }
  158.   else { echo $row->Email; }
  159.   echo '</td><td id="DescriptionGreen">Phone</td><td>';
  160.   if($formSubmitEditView) { echo '<input type="text" name="formPhone" id="InputLong" value="'.$row->Phone.'">'; }
  161.   else { echo $row->Phone; }
  162.   echo '</td></tr>
  163.   <tr><td><b>Billing Address *</b></td><td></td><td colspan="2"><b>Address for delivery (if other than the billing address)</b></td></tr>
  164.   <tr><td id="DescriptionGreen">Institution</td><td>';
  165.   if($formSubmitEditView) { echo '<input type="text" name="formInstitut" id="InputLong" value="'.$row->Institut.'">'; }
  166.   else { echo $row->Institut; }
  167.   echo '</td><td id="DescriptionGreen">Institution</td><td>';
  168.   if($formSubmitEditView) { echo '<input type="text" name="formInstitut2" id="InputLong" value="'.$row->Institut_Delivery.'">'; }
  169.   else { echo $row->Institut_Delivery; }
  170.   echo '</td></tr>
  171.   <tr><td id="DescriptionGreen">Division</td><td>';
  172.   if($formSubmitEditView) { echo '<input type="text" name="formDivision" id="InputLong" value="'.$row->Division.'">'; }
  173.   else { echo $row->Division; }
  174.   echo '</td><td id="DescriptionGreen">Division</td><td>';
  175.   if($formSubmitEditView) { echo '<input type="text" name="formDivision2" id="InputLong" value="'.$row->Division_Delivery.'">'; }
  176.   else { echo $row->Division_Delivery; }
  177.   echo '</td></tr>
  178.   <tr><td id="DescriptionGreen">Street/P.O. Box</td><td>';
  179.   if($formSubmitEditView) { echo '<input type="text" name="formStreet" id="InputLong" value="'.$row->Street.'">'; }
  180.   else { echo $row->Street; }
  181.   echo '</td><td id="DescriptionGreen">Street/P.O. Box</td><td>';
  182.   if($formSubmitEditView) { echo '<input type="text" name="formStreet2" id="InputLong" value="'.$row->Street_Delivery.'">'; }
  183.   else { echo $row->Street_Delivery; }
  184.   echo '</td></tr>
  185.   <tr><td id="DescriptionGreen">Postal Code</td><td>';
  186.   if($formSubmitEditView) { echo '<input type="text" name="formPostal_Code" id="InputLong" value="'.$row->Postal_Code.'">'; }
  187.   else { echo $row->Postal_Code; }
  188.   echo '</td><td id="DescriptionGreen">Postal Code</td><td>';
  189.   if($formSubmitEditView) { echo '<input type="text" name="formPostal_Code2" id="InputLong" value="'.$row->Postal_Code_Delivery.'">'; }
  190.   else { echo $row->Postal_Code_Delivery; }
  191.   echo '</td></tr>
  192.   <tr><td id="DescriptionGreen">Location/City</td><td>';
  193.   if($formSubmitEditView) { echo '<input type="text" name="formCity" id="InputLong" value="'.$row->City.'">'; }
  194.   else { echo $row->City; }
  195.   echo '</td><td id="DescriptionGreen">Location/City</td><td>';
  196.   if($formSubmitEditView) { echo '<input type="text" name="formCity2" id="InputLong" value="'.$row->City_Delivery.'">'; }
  197.   else { echo $row->City_Delivery; }
  198.   echo '</td></tr>
  199.   <tr><td id="DescriptionGreen">Country</td><td>';
  200.   if($formSubmitEditView) { echo '<input type="text" name="formCountry" id="InputLong" value="'.$row->Country.'">'; }
  201.   else { echo $row->Country; }
  202.   echo '</td><td id="DescriptionGreen">Country</td><td>';
  203.   if($formSubmitEditView) { echo '<input type="text" name="formCountry2" id="InputLong" value="'.$row->Country_Delivery.'">'; }
  204.   else { echo $row->Country_Delivery; }
  205.   echo '</td></tr>
  206.   <tr><td id="DescriptionGreen">Notes</td><td>';
  207.   if($formSubmitEditView) { echo '<textarea name="formNotes" id="InputLong">'.$row->Remarks.'</textarea>'; }
  208.   else { echo $row->Remarks; }
  209.   echo '</td><td colspan="2"><b>Extraction Staff <input type="checkbox" name="formExtraction" value="yes" ';
  210.   if($row->ExtractionStaff == "yes") { echo "checked"; }
  211.   if(!$formSubmitEditView) { echo ' disabled'; }
  212.   echo '/> Provider <input type="checkbox" name="formProvider" value="yes" ';
  213.   if($row->Provider == "yes") { echo "checked"; }
  214.   if(!$formSubmitEditView) { echo ' disabled'; }
  215.   echo '/> Customer <input type="checkbox" name="formCustomer2" value="yes" ';
  216.   if($row->Customer == "yes") { echo "checked"; }
  217.   if(!$formSubmitEditView) { echo ' disabled'; }
  218.   echo '/></b></td></tr>
  219.   <tr><td></td><td id="tdbutton">';
  220.   if($formSubmitEditView) { echo '<input type="submit" name="formSubmitSave2" else value="Save" class="button">'; }
  221.   else { echo '<input type="submit" name="formSubmitEditView" else value="Edit" class="button">'; }
  222.   echo '</td><td colspan="2"></td></tr>
  223. <tr><td colspan="4"><hr /></td></tr></table>';
  224. if($formSubmitEditView) { echo '</div>'; }
  225. echo '</td></tr>';
  226.  
  227. }
  228.  
  229. }
  230.  
  231.  
  232.  
  233. if(!$formSubmitEditView) { ?>
  234.  
  235.  
  236. <tr><td id="DescriptionBlack"><b>Add new Person</b></td><td><input type="checkbox" id="checkbox" name="NewPerson" onclick="document.getElementById('hiddenPerson').style.display = this.checked == true ? 'none':'block';document.getElementById('hiddenPerson').style.display = this.checked == true ? 'block':'none';" value="NewPerson" 
  237. <?php if($formSubmitSave) { echo " checked";  }?>> </td></tr>
  238.  
  239. <?php } // if(!$formSubmitEditView)
  240.  ?>
  241.  
  242. <tr><td colspan="2">
  243.   <div class="geography2" <?php if($formSubmitSave) { echo 'style="display:true;"'; } else { echo 'style="display:none;"'; } ?> id="hiddenPerson">
  244.   <table border="0" width="90%">
  245.   <tr><td colspan="4" align="center">
  246.  
  247.  
  248. <?php 
  249.  
  250.  
  251. if($formSubmitSave and $_POST['importcustomerdata'] != "") {
  252. $Explode = explode(";", $_POST['importcustomerdata']); 
  253.  
  254. $sqltest = "SELECT * from people where Email = '$Explode[4]'";
  255. $resulttest = mysql_query($sqltest);
  256. if(mysql_num_rows($resulttest) > 0) 
  257. { echo "<span class='error'>Person already exist in database (Email: ".$Explode[4]."). You can edit details and group membership.</span>";
  258. while($row = mysql_fetch_object($resulttest))
  259. { 
  260. $ImportFormOfAddress = $row->FormOfAddress;
  261. $ImportTitle = $row->Title;
  262. $ImportSurname = $row->Surname;
  263. $ImportForename = $row->Forename;
  264. $ImportEmail = $row->Email;
  265. $ImportInstitut = $row->Institut;
  266. $ImportDivision = $row->Division;
  267. $ImportStreet = $row->Street;
  268. $ImportCity = $row->City;
  269. $ImportPostal_Code = $row->Postal_Code;
  270. $ImportCountry = $row->Country;
  271. $ImportInstitut_Delivery = $row->Institut_Delivery;
  272. $ImportDivision_Delivery = $row->Division_Delivery;
  273. $ImportStreet_Delivery = $row->Street_Delivery;
  274. $ImportCity_Delivery = $row->City_Delivery;
  275. $ImportPostal_Code_Delivery = $row->Postal_Code_Delivery;
  276. $ImportCountry_Delivery = $row->Country_Delivery;
  277. $ImportRemarks = $row->Remarks;
  278. $ImportExtractionStaff = $row->ExtractionStaff;
  279. $ImportProvider = $row->Provider;
  280. $ImportCustomer = $row->Customer;  } }
  281.  
  282. else {
  283. $ImportFormOfAddress = $Explode[0];
  284. $ImportTitle = $Explode[1];
  285. $ImportSurname = $Explode[2];
  286. $ImportForename = $Explode[3];
  287. $ImportEmail = $Explode[4];
  288. $ImportInstitut = $Explode[5];
  289. $ImportDivision = $Explode[6];
  290. $ImportStreet = $Explode[7];
  291. $ImportCity = $Explode[8];
  292. $ImportPostal_Code = $Explode[9];
  293. $ImportCountry = $Explode[10];
  294. $ImportInstitut_Delivery = $Explode[11];
  295. $ImportDivision_Delivery = $Explode[12];
  296. $ImportStreet_Delivery = $Explode[13];
  297. $ImportCity_Delivery = $Explode[14];
  298. $ImportPostal_Code_Delivery = $Explode[15];
  299. $ImportCountry_Delivery = $Explode[16];
  300. $ImportRemarks = $Explode[17];
  301. $ImportCustomer = 'yes'; }
  302.  
  303. }
  304.  
  305. if($formSubmitSave and $_POST['importcustomerdata'] == "") {
  306.  
  307. $sqltest = "SELECT * from people where Email = '$formEmail'";
  308. $resulttest = mysql_query($sqltest);
  309.  
  310. if(mysql_num_rows($resulttest) > 0) 
  311. { echo "<span class='error'>Person already exist in database (Email: ".$formEmail."). You can edit details and group membership.</span>"; }
  312.  
  313. else { 
  314.  
  315. $Name_All = $formSurname;
  316. if($formForename != "") { $Name_All .= ", ".$formForename; }
  317.  
  318. $sql = "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, ExtractionStaff, 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','$formExtraction','$formProvider','$formCustomer2','$log')";
  319. echo $sql;
  320. $result = mysql_query($sql);
  321.  
  322. ###############################################Error insert1####################################################
  323.  
  324.  
  325. if(!$result)
  326.      { 
  327.   $msg = $sql."\n";
  328.   $msg .= "####Error insert####";
  329.   trigger_error($msg, E_USER_ERROR);
  330.   include ("../config/Errorreport.php"); 
  331.   $error = "true"; } 
  332.          
  333. #########################################################################################################  
  334. if($result) {  echo "<div class='search'><span class='fine'>Data have been saved.</span></div>";  }
  335.   }
  336.  
  337. }
  338.  
  339.  
  340.  ?>
  341. </td></tr>
  342. <?php if(!$formSubmitEditView) { ?>
  343.   <tr><td colspan="4"><hr /></td></tr>
  344.   <tr><td id="DescriptionBlack">Form of address</td><td><select name="formFormOfAddress" id="InputLong"><option value="">------</option>
  345.       <option value="Mr" <?php if($formSubmitSave and $ImportFormOfAddress == "Mr") { echo ' selected'; }?>>Mr</option><option value="Mrs" <?php if($formSubmitSave and $ImportFormOfAddress == "Mrs") { echo ' selected'; }?>>Mrs</option><option value="Ms" <?php if($formSubmitSave and $ImportFormOfAddress == "Ms") { echo ' selected'; }?>>Ms</option></select>
  346.       </td><td id="DescriptionBlack">Title</td><td><input type="text" name="formTitle" id="InputLong" value="<?php if($formSubmitSave and $ImportTitle != "") { echo $ImportTitle; }?>"/></td></tr>
  347.       <tr><td id="DescriptionBlack">Family name</td><td><input type="text" name="formSurname" id="InputLong" value="<?php if($formSubmitSave and $ImportSurname != "") { echo $ImportSurname; }?>"></td><td id="DescriptionBlack">First name</td><td><input type="text" name="formForename" id="InputLong" value="<?php if($formSubmitSave and $ImportForename != "") { echo $ImportForename; }?>"></td></tr>
  348.       <tr><td id="DescriptionBlack">Email</td><td><input type="text" name="formEmail" id="InputLong" value="<?php if($formSubmitSave and $ImportEmail != "") { echo $ImportEmail; }?>"></td><td id="DescriptionBlack">Phone</td><td><input type="text" name="formPhone" id="InputLong"/></td></tr>
  349.       <tr><td id="DescriptionBlack"><b>Billing Address *</b></td><td></td><td colspan="2"><b>Address for delivery (if other than the billing address)</b></td></tr>
  350.       <tr><td id="DescriptionBlack">Institution</td><td><input type="text" name="formInstitut" id="InputLong" value="<?php if($formSubmitSave and $ImportInstitut != "") { echo $ImportInstitut; }?>"></td><td id="DescriptionBlack">Institution</td><td><input type="text" name="formInstitut2" id="InputLong" value="<?php if($formSubmitSave and $ImportInstitut_Delivery != "") { echo $ImportInstitut_Delivery; }?>"></td></tr>
  351.       <tr><td id="DescriptionBlack">Division</td><td><input type="text" name="formDivision" id="InputLong" value="<?php if($formSubmitSave and $ImportDivision != "") { echo $ImportDivision; }?>"></td><td id="DescriptionBlack">Division</td><td><input type="text" name="formDivision2" id="InputLong" value="<?php if($formSubmitSave and $ImportDivision_Delivery != "") { echo $ImportDivision_Delivery; }?>"></td></tr>
  352.       <tr><td id="DescriptionBlack">Street/P.O. Box</td><td><input type="text" name="formStreet" id="InputLong" value="<?php if($formSubmitSave and $ImportStreet != "") { echo $ImportStreet; }?>"></td><td id="DescriptionBlack">Street/P.O. Box</td><td><input type="text" name="formStreet2" id="InputLong" value="<?php if($formSubmitSave and $ImportStreet_Delivery != "") { echo $ImportStreet_Delivery; }?>"></td></tr>
  353.       <tr><td id="DescriptionBlack">Postal Code</td><td><input type="text" name="formPostal_Code" id="InputLong" value="<?php if($formSubmitSave and $ImportPostal_Code != "") { echo $ImportPostal_Code; }?>"></td><td id="DescriptionBlack">Postal Code</td><td><input type="text" name="formPostal_Code2" id="InputLong" value="<?php if($formSubmitSave and $ImportPostal_Code_Delivery != "") { echo $ImportPostal_Code_Delivery; }?>"></td></tr>
  354.       <tr><td id="DescriptionBlack">Location/City</td><td><input type="text" name="formCity" id="InputLong" value="<?php if($formSubmitSave and $ImportCity != "") { echo $ImportCity; }?>"></td><td id="DescriptionBlack">Location/City</td><td><input type="text" name="formCity2" id="InputLong" value="<?php if($formSubmitSave and $ImportCity_Delivery != "") { echo $ImportCity_Delivery; }?>"></td></tr>
  355.       <tr><td id="DescriptionBlack">Country</td><td><input type="text" name="formCountry" id="InputLong" value="<?php if($formSubmitSave and $ImportCountry != "") { echo $ImportCountry; }?>"></td><td id="DescriptionBlack">Country</td><td><input type="text" name="formCountry2" id="InputLong" value="<?php if($formSubmitSave and $ImportCountry_Delivery != "") { echo $ImportCountry_Delivery; }?>"></td></tr>
  356.       <tr><td id="DescriptionBlack">Notes</td><td><textarea name="formNotes" id="InputLong"><?php if($formSubmitSave and $ImportRemarks != "") { echo $ImportRemarks; }?></textarea></td><td colspan="2"><b>Extraction Staff <input type='checkbox' name='formExtraction' value='yes' <?php if($formSubmitSave and $ImportExtractionStaff == "yes") { echo "checked"; }?>> Provider <input type='checkbox' name='formProvider' value='yes' <?php if($formSubmitSave and $ImportProvider == "yes") { echo "checked"; }?>> Customer <input type='checkbox' name='formCustomer2' value='yes' <?php if($formSubmitSave and $ImportCustomer == "yes") { echo "checked"; }?>></b></td></tr>
  357.       <tr><td id="DescriptionBlack"><span class="fine">Import customer data from Preorder Email</span></td><td><input type="text" name="importcustomerdata" id="InputLong"></td><td><span title="Preorder Emails via the Webportal of the DNA Bank Network contain two txt-attachments, one with DNA numbers and another with Customer data. Please open the PreorderCustomer-txt file and copy first line completely into the text field adjacent. Further information is available in the Wiki."><b>Help</b></span></td></tr>
  358.       <tr><td></td><td id="tdbutton"><input type="submit" <?php if($formSubmitSave) { echo 'name="formSubmitSave2" value="Save"'; } else { echo 'name="formSubmitSave" value="Check database"'; } ?>  class="button"></td><td colspan="2"></td></tr>
  359.  
  360. <?php } ?>
  361.  
  362.   </table>
  363.   </div>
  364. </td></tr>
  365. </table>
  366. </td></tr>
  367. <tr><td colspan="2" height="15" align="right">After finishing close this window and reload the other site.</td><td><input type="submit" id="button" name="formSubmitClose" value="Close Form" style="float:right" onclick="window.close();"></td></tr>
  368. <?php } ?>
  369. </table>
  370. <?php
  371.     /**
  372.     * including footer
  373.     */
  374.     include("../footer.php"); ?> 
  375. </form>
  376. </div>
  377. </body>
  378. </html>

Documentation generated on Tue, 29 Nov 2011 10:44:57 +0100 by phpDocumentor 1.4.3