* Start script for cleaning DNA data *

* Access for all users except of guests * @author Gabriele Droege, DNA Bank Network * @version 2.0 * @package Data_Cleaning * @copyright Copyright © 2011 DNA Bank Network http://www.dnabank-network.org
The contents of this file are subject to the Mozilla Public License Version 1.1 * @filesource * @license http://www.mozilla.org/MPL/ MPL */ /** * calling connection to database */ include ("../config/head.php"); /** * calling authorisation script */ include ("../auth.php"); ?> DNA Module - Data Cleaning Tool
"; } else { /******************************************************************************************** * check for incomplete data * * some further restrictions for members of group "project" * * START * *********************************************************************************************/ ?>

Data Cleaning Tool

Sorry, you don't have permission for this site! If you want to search for existing DNA data please use the Search function!

Listed below are empty parameters in your DNA database. If you want to see the individual records please select individual checkboxes and submit "Show details".

ParameterDetailsSelect
DNA Extraction Number: * No entries found empty."; } else { $count = mysqli_num_rows($result1); if($count == 1) { echo "".$count." entry found empty."; } else { echo "".$count. " entries found empty."; } } /* $sql2 = mysql_query("SELECT DISTINCT dnabanknumbers.ID_DNA, dnabanknumbers.Dna_Bank_Number " . ", COUNT(*) AS number FROM dnabanknumbers " . "GROUP BY dnabanknumbers.Dna_Bank_Number HAVING number > 1"); if(!mysql_affected_rows()) { $DNADouble = "true"; echo "
No double entries found."; } else { echo "
Following DNA no. are double recorded:

"; while($roww = mysql_fetch_object($sql2)) { $formDna = $roww->Dna_Bank_Number."; "; echo $formDna; } } */ ?>

"; } // if ($DNADouble != "true") { // echo ""; } ?>
Relation to Voucher: * No entries found empty."; } else { $count = mysqli_num_rows($result); if($count == 1) { echo "".$count." entry found empty."; } else { echo "".$count. " entries found empty."; } } ?> "; } ?>
Voucher data: * No entries found empty."; } else { $count = mysqli_num_rows($result); if($count == 1) { echo "".$count." entry found without voucher data."; } else { echo "".$count. " entries found without voucher data."; } } ?> "; } ?>
Tissue: No entries found empty."; } else { $count = mysqli_num_rows($result); if($count == 1) { echo "".$count." entry found empty."; } else { echo "".$count. " entries found empty."; } } ?> "; } ?>
Preservation: No entries found empty."; } else { $count = mysqli_num_rows($result); if($count == 1) { echo "".$count." entry found empty."; } else { echo "".$count. " entries found empty."; } } ?> "; } ?>
DNA Type: No entries found empty."; } else { $count = mysqli_num_rows($result); if($count == 1) { echo "".$count." entry found empty."; } else { echo "".$count. " entries found empty."; } } ?> "; } ?>
DNA Extraction Method: * No entries found empty."; } else { $count = mysqli_num_rows($result); if($count == 1) { echo "".$count." entry found empty."; } else { echo "".$count. " entries found empty."; } } ?> "; } ?>
DNA Extraction Date: * No entries found empty."; } else { $count = mysqli_num_rows($result); if($count == 1) { echo "".$count." entry found empty."; } else { echo "".$count. " entries found empty."; } } ?> "; } ?>
DNA Extraction Staff: * No entries found empty."; } else { $count = mysqli_num_rows($result); if($count == 1) { echo "".$count." entry found empty."; } else { echo "".$count. " entries found empty."; } } ?> "; } ?>
DNA Purification Method: No entries found empty."; } else { $count = mysqli_num_rows($result); if($count == 1) { echo "".$count." entry found empty."; } else { echo "".$count. " entries found empty."; } } ?> "; } ?>
Ratios of absorbence OD260nm/OD280nm:
OD260nm/OD230nm:
No entries found empty."; } else { $count = mysqli_num_rows($result); if($count == 1) { echo "".$count." entry found empty."; } else { echo "".$count. " entries found empty."; } } echo "
"; $sql = 'SELECT ID_DNA FROM dnabanknumbers WHERE (Absorbance230 = "" OR Absorbance230 IS NULL)'; if (isset($_SESSION['project']) || $_SESSION['project']) { $sql .= " AND Created_Who = '".$log."'"; } $result = mysqli_query($GLOBALS["___mysqli_ston"], $sql); if(!mysqli_affected_rows($GLOBALS["___mysqli_ston"])) { $R230 = "true"; echo "No entries found empty."; } else { $count = mysqli_num_rows($result); if($count == 1) { echo "".$count." entry found empty."; } else { echo "".$count. " entries found empty."; } } ?>

"; } if ($R230 != "true") { echo ""; } ?>
DNA Concentration: No entries found empty."; } else { $count = mysqli_num_rows($result); if($count == 1) { echo "".$count." entry found empty."; } else { echo "".$count. " entries found empty."; } } ?> "; } ?>
DNA Quality Check Date: No entries found empty."; } else { $count = mysqli_num_rows($result); if($count == 1) { echo "".$count." entry found empty."; } else { echo "".$count. " entries found empty."; } } ?> "; } ?>
Location Stock Solution: No entries found empty."; } else { $count = mysqli_num_rows($result); if($count == 1) { echo "".$count." entry found empty."; } else { echo "".$count. " entries found empty."; } } ?> "; } ?>
* Mandatory field, please complete missing data!