本文整理汇总了PHP中getDetailedTableInfo2函数的典型用法代码示例。如果您正苦于以下问题：PHP getDetailedTableInfo2函数的具体用法？PHP getDetailedTableInfo2怎么用？PHP getDetailedTableInfo2使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了getDetailedTableInfo2函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: if
if($id) {
echo "<option value=\"".getDetailedTableInfo2("vl_users","id='$id'","role")."\">".getDetailedTableInfo2("vl_users","id='$id'","role")."</option>";
} else {
echo "<option value=\"\" selected=\"selected\">Select Role</option>";
}
?>
<option value="Lab Technologist">Lab Technologist</option>
<option value="Lab Manager">Lab Manager</option>
<option value="Other">Other</option>
</select></td>
</tr>
<? if($id && $option!="remove") { ?>
<tr>
<td>Last Login</td>
<td><?php
echo $id ? getFormattedDate(getDetailedTableInfo2("vl_users", "id='{$id}'", "lastLogin")) : "Unavailable";
?>
</td>
</tr>
<? } ?>
</table></td>
</tr>
<tr>
<td style="border-top:1px solid #cccccc; padding-top:10px">
<input type="submit" name="button" id="button" value=" Save " />
<? if($task=="modify") { ?>
<button type="button" id="button" name="button" value="button" onclick="document.location.href='?act=users&nav=configuration'"> Cancel </button>
<input name="id" type="hidden" id="id" value="<?php
echo $id;
?>
">
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.users.php
示例2: logResultOverride
/**
* function to log result overrides
*/
function logResultOverride($sampleID,$worksheetID,$result) {
global $datetime,$trailSessionUser;
//validate
$sampleID=validate($sampleID);
$worksheetID=validate($worksheetID);
$result=validate($result);
$id=0;
$id=getDetailedTableInfo2("vl_results_override","sampleID='$sampleID' and worksheetID='$worksheetID'","id");
//avoid duplicates
if(!$id) {
//insert into vl_results_override
mysqlquery("insert into vl_results_override
(sampleID,worksheetID,result,created,createdby)
values
('$sampleID','$worksheetID','$result','$datetime','$trailSessionUser')");
} else {
//log table change
logTableChange("vl_results_override","result",$id,getDetailedTableInfo2("vl_results_override","id='$id'","result"),$result);
//update vl_results_override
mysqlquery("update vl_results_override set result='$result' where id='$id'");
}
}
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:27，代码来源:functions.samples.php
示例3:
</tr>
</table>
</td>
<td style="padding: 0px 0px 0px 10px" align="right">Value:</td>
<td style="padding:0px 0px 0px 5px"><input type="text" name="suspectedTreatmentFailureValue" id="suspectedTreatmentFailureValue" value="<?php
echo $suspectedTreatmentFailureValue;
?>
" class="search_pre" size="7" maxlength="10" /></td>
<td align="right">Sample Type:</td>
<td style="padding:0px 0px 0px 5px">
<select name="suspectedTreatmentFailureSampleTypeID" id="suspectedTreatmentFailureSampleTypeID" class="search">
<?
$query=0;
$query=mysqlquery("select * from vl_appendix_sampletype order by position");
if($suspectedTreatmentFailureSampleTypeID) {
echo "<option value=\"$suspectedTreatmentFailureSampleTypeID\" selected=\"selected\">".getDetailedTableInfo2("vl_appendix_sampletype","id='$suspectedTreatmentFailureSampleTypeID' limit 1","appendix")."</option>";
} else {
echo "<option value=\"\" selected=\"selected\">Select Sample Type</option>";
}
if(mysqlnumrows($query)) {
while($q=mysqlfetcharray($query)) {
echo "<option value=\"$q[id]\">$q[appendix]</option>";
}
}
?>
</select>
</td>
</tr>
</table>
</div>
</fieldset>
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.samples.modify.deprecated.php
示例4: getDetailedTableInfo2
<td width="70%"><input type="text" name="appendix" id="appendix" class="search" size="25" value="<?php
echo $id ? getDetailedTableInfo2("vl_appendix_tbtreatmentphase", "id='{$id}'", "appendix") : "";
?>
"></td>
</tr>
<tr>
<td>Position</td>
<td><select name="position" id="position" class="search">
<?
//get max number of records
$position=0;
if(!$id) {
$position=getDetailedTableInfo3("vl_appendix_tbtreatmentphase","appendix!=''","count(id)","num");
$position+=1;
} else {
$position=getDetailedTableInfo2("vl_appendix_tbtreatmentphase","id='$id'","position");
}
echo "<option value=\"$position\" selected=\"selected\">$position</option>";
for($j=1;$j<=50;$j++) {
echo "<option value=\"$j\">$j</option>";
}
?>
</select></td>
</tr>
</table></td>
</tr>
<tr>
<td style="border-top:1px solid #cccccc; padding-top:10px">
<input type="submit" name="button" id="button" value=" Save " />
<? if($task=="modify") { ?>
<button type="button" id="button" name="button" value="button" onclick="document.location.href='?act=atbtreatmentphase&nav=configuration'"> Cancel </button>
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.appendix.tbtreatmentphase.php
示例5: mysqlnumrows
</td>
<td class="<?php
echo $count < mysqlnumrows($xquery) ? "vl_tdstandard" : "vl_tdnoborder";
?>
" align="center"><a <?php
echo $sampleURL;
?>
><?php
echo number_format((double) $numberSamples);
?>
</a></td>
<td class="<?php
echo $count < mysqlnumrows($xquery) ? "vl_tdstandard" : "vl_tdnoborder";
?>
"><?php
echo getDetailedTableInfo2("vl_facilities", "id='" . getDetailedTableInfo2("vl_samples", "patientID='{$q['id']}'", "facilityID") . "'", "facility");
?>
</td>
<td class="<?php
echo $count < mysqlnumrows($xquery) ? "vl_tdstandard" : "vl_tdnoborder";
?>
"><div class="vls_grey" style="padding:3px 0px 0px 0px"><a href="/samples/manage.patients/modify/<?php
echo $q["id"];
?>
/">Edit Patient Information</a></div></td>
</tr>
<? } ?>
</table>
</div>
</td>
</tr>
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.samples.patients.manage.php
示例6: getDetailedTableInfo2
</strong><br /><a href="?act=facilities&districtID=<?php
echo $districtID;
?>
&nav=configuration">Return to previous page</a></td>
</tr>
</table>
<? } ?>
</td>
<td width="35%" valign="top" style="padding:3px 0px 0px 12px">
<div>
<table border="0" align="center" cellpadding="0" cellspacing="0" style="border:1px solid #d5d5d5" width="100%">
<tr>
<td style="padding:10px"><table width="100%" border="0" class="vl">
<tr>
<td><strong>MANAGE FACILITIES IN <?php
echo getDetailedTableInfo2("vl_districts", "id='{$districtID}'", "district");
?>
DISTRICT</strong></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td bgcolor="#d5d5d5" style="padding:10px">Create, Delete or Manage Facilities</td>
</tr>
</table></td>
</tr>
</table>
</div>
<div style="padding:10px 0px 0px 0px">
<script Language="JavaScript" Type="text/javascript">
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.facilities.php
示例7: logDownloadedVLClinicalForms
/**
* log search query
* @param: $refNumber
*/
function logDownloadedVLClinicalForms($refNumber) {
global $datetime,$trailSessionUser;
if(!getDetailedTableInfo2("vl_logs_downloadedclinicalforms","refNumber='$refNumber' limit 1","id")) {
mysqlquery("insert into vl_logs_downloadedclinicalforms
(refNumber,created,createdby)
values
('$refNumber','$datetime','$trailSessionUser')");
}
}
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:13，代码来源:functions.debug.php
示例8: getDetailedTableInfo2
$result=0;
$result=getVLResult($machineType,$worksheetID,$sampleReferenceNumber,$factor);
//dispatch details
$scheduledDate=0;
$scheduledDate=getDetailedTableInfo2("vl_logs_samplerepeats","sampleID='$sampleID' and oldWorksheetID='$worksheetID' limit 1","created");
$by=0;
$by=getDetailedTableInfo2("vl_logs_samplerepeats","sampleID='$sampleID' and oldWorksheetID='$worksheetID' limit 1","createdby");
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table border="0" cellspacing="0" cellpadding="0" class="vl">
<tr>
<td class="tab_active">FORM: <?php
echo getDetailedTableInfo2("vl_samples", "id='{$sampleID}'", "formNumber");
?>
</td>
</tr>
</table></td>
</tr>
<tr>
<td style="border:1px solid #CCCCFF; padding:20px">
<table width="100%" border="0" class="vl">
<tr>
<td>
<div style="height: 280px; overflow: auto; padding:3px">
<table width="92%" border="0" class="vl">
<tr>
<td>
<fieldset style="width: 100%">
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.preview.results.repeat.scheduled.php
示例9: month
$query=0;
$query=mysqlquery("select distinct month(a.created) theMonth,year(a.created) theYear,a.facilityID facilityID,
CASE
WHEN (round(datediff(now(),b.dateOfBirth)/365)<5 or b.dateOfBirth='0000-00-00') then 1
WHEN round(datediff(now(),b.dateOfBirth)/365)>=5 and round(datediff(now(),b.dateOfBirth)/365)<=9 then 2
WHEN round(datediff(now(),b.dateOfBirth)/365)>=10 and round(datediff(now(),b.dateOfBirth)/365)<=18 then 3
WHEN round(datediff(now(),b.dateOfBirth)/365)>=19 and round(datediff(now(),b.dateOfBirth)/365)<=25 then 4
WHEN round(datediff(now(),b.dateOfBirth)/365)>=26 then 5
END theAgeCategory
from vl_samples a,vl_patients b where a.patientID=b.id order by a.created");
if(mysqlnumrows($query)) {
//sample type IDs
$dbsSampleTypeID=0;
$dbsSampleTypeID=getDetailedTableInfo2("vl_appendix_sampletype","appendix='DBS' limit 1","id");
$plasmaSampleTypeID=0;
$plasmaSampleTypeID=getDetailedTableInfo2("vl_appendix_sampletype","appendix='Plasma' limit 1","id");
$array=array();
while($q=mysqlfetcharray($query)) {
//process last portion of output based on age category
switch($q["theAgeCategory"]) {
case 1: //age is < 5
//samples_received
echo "$q[theMonth], $q[theYear], $q[facilityID], $q[theAgeCategory], ".getDetailedTableInfo3("vl_samples a,vl_patients b","a.patientID=b.id and month(a.created)='$q[theMonth]' and year(a.created)='$q[theYear]' and a.facilityID='$q[facilityID]' and (round(datediff(now(),b.dateOfBirth)/365)<5 or b.dateOfBirth='0000-00-00')","count(a.id)","num")."<br>";
break;
case 2: //age >= 5 && age <= 9
//samples_received
echo "$q[theMonth], $q[theYear], $q[facilityID], $q[theAgeCategory], ".getDetailedTableInfo3("vl_samples a,vl_patients b","a.patientID=b.id and month(a.created)='$q[theMonth]' and year(a.created)='$q[theYear]' and a.facilityID='$q[facilityID]' and round(datediff(now(),b.dateOfBirth)/365)>=5 and round(datediff(now(),b.dateOfBirth)/365)<=9 and b.dateOfBirth!='0000-00-00'","count(a.id)","num")."<br>";
break;
case 3: //age >= 10 && age <= 18
//samples_received
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:index.test.php
示例10:
<fieldset style="width: 100%">
<legend><strong>PATIENT SAMPLES</strong></legend>
<div style="padding:5px 0px 0px 0px">
<table width="100%" border="0" class="vl" cellspacing="0" cellpadding="0">
<tr>
<td width="20%" class="vl_tdsub"><strong>Form #</strong></td>
<td width="20%" class="vl_tdsub"><strong>Sample Reference #</strong></td>
<td width="20%" class="vl_tdsub"><strong>Status</strong></td>
<td width="40%" class="vl_tdsub"><strong>Date Captured</strong></td>
</tr>
<?
$count=0;
while($q=mysqlfetcharray($query)) {
$count+=1;
$status=0;
$status=getDetailedTableInfo2("vl_samples_verify","sampleID='$q[id]'","outcome");
if($count<$num) {
echo "<tr>
<td class=\"vl_tdstandard\">$q[formNumber]</td>
<td class=\"vl_tdstandard\"><a href=\"/verify/find.and.edit/$q[id]/1/\">$q[vlSampleID]</a></td>
<td class=\"vl_tdstandard\">".($status?$status:"Pending")."</td>
<td class=\"vl_tdstandard\">".getFormattedDate($q["created"])." at ".getFormattedTimeLessS($q["created"])."</td>
</tr>";
} else {
echo "<tr>
<td class=\"vl_tdnoborder\">$q[formNumber]</td>
<td class=\"vl_tdnoborder\"><a href=\"/verify/find.and.edit/$q[id]/1/\">$q[vlSampleID]</a></td>
<td class=\"vl_tdnoborder\">".($status?$status:"Pending")."</td>
<td class=\"vl_tdnoborder\">".getFormattedDate($q["created"])." at ".getFormattedTimeLessS($q["created"])."</td>
</tr>";
}
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.preview.samples.php
示例11: echo
<td class="vl_error">There are No Results matching the Search Criteria <strong><?php
echo $searchQuery;
?>
</strong>!</td>
</tr>
</table>
<?
} else {
?>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td class="vl_error">No <?php
echo $machineType;
?>
Results Found<?php
echo ($facilityID || $worksheetID ? " within " : "") . ($facilityID && !$worksheetID ? getDetailedTableInfo2("vl_facilities", "id='{$facilityID}' limit 1", "facility") . " Facility" : "") . (!$facilityID && $worksheetID ? getDetailedTableInfo2("vl_samples_worksheetcredentials", "id='{$worksheetID}' limit 1", "worksheetReferenceNumber") . " Worksheet" : "") . ($facilityID && $worksheetID ? getDetailedTableInfo2("vl_facilities", "id='{$facilityID}' limit 1", "facility") . " Facility and " . getDetailedTableInfo2("vl_samples_worksheetcredentials", "id='{$worksheetID}' limit 1", "worksheetReferenceNumber") . " Worksheet" : "");
?>
</td>
</tr>
</table>
<?
}
}
?>
</div>
</td>
</tr>
</table>
<!-- End Printed/Not Printed Items -->
</td>
</tr>
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.results.default.php
示例12:
echo "<option value=\"$q[id]\">$q[hub]</option>";
}
}
?>
</select>
</td>
</tr>
<tr>
<td>District</td>
<td>
<select name="districtID" id="districtID" class="search">
<?
$query=0;
$query=mysqlquery("select * from vl_districts order by district");
if($districtID) {
echo "<option value=\"$districtID\" selected=\"selected\">".getDetailedTableInfo2("vl_districts","id='$districtID'","district")."</option>";
} else {
echo "<option value=\"\" selected=\"selected\">Select District</option>";
}
if(mysqlnumrows($query)) {
while($q=mysqlfetcharray($query)) {
echo "<option value=\"$q[id]\">$q[district]</option>";
}
}
?>
</select>
</td>
</tr>
<tr>
<td>Date Received <font class="vl_red">*</font></td>
<td>
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.envelopes.modify.php
示例13: while
$count=0;
$q=array();
while($q=mysqlfetcharray($query)) {
$count+=1;
$patientID=0;
$patientID=getDetailedTableInfo2("vl_samples","id='$q[sampleID]'","patientID");
$artNumber=0;
$artNumber=getDetailedTableInfo2("vl_patients","id='$patientID'","artNumber");
$otherID=0;
$otherID=getDetailedTableInfo2("vl_patients","id='$patientID'","otherID");
$sampleID=0;
$sampleID=getDetailedTableInfo2("vl_samples","id='$q[sampleID]'","vlSampleID");
$created=0;
$created=getDetailedTableInfo2("vl_samples_verify","sampleID='$q[sampleID]'","created");
$createdby=0;
$createdby=getDetailedTableInfo2("vl_samples_verify","sampleID='$q[sampleID]'","createdby");
?>
<tr>
<td class="<?php
echo $count < $num ? "vl_tdstandard" : "vl_tdnoborder";
?>
">
<div><strong><?php
echo $artNumber ? "ART Number" : "";
echo $artNumber && $otherID ? "/" : "";
echo $otherID ? "OtherID" : "";
?>
:</strong> <?php
echo $artNumber ? $artNumber : "";
echo $artNumber && $otherID ? "/" : "";
echo $otherID ? $otherID : "";
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.samples.repeat.php
示例14: getDetailedTableInfo2
<td style="padding:5px 0px; border-bottom: 1px solid #efefef"><?php
echo $activeTB;
?>
</td>
</tr>
<tr>
<td style="padding:5px 0px; border-bottom: 1px solid #efefef"><strong>TB Treatment Phase</strong></td>
<td style="padding:5px 0px; border-bottom: 1px solid #efefef"><?php
echo getDetailedTableInfo2("vl_appendix_tbtreatmentphase", "id='{$tbTreatmentPhase}' limit 1", "appendix");
?>
</td>
</tr>
<tr>
<td style="padding:5px 0px"><strong>ARV Adherence</strong></td>
<td style="padding:5px 0px"><?php
echo getDetailedTableInfo2("vl_appendix_arvadherence", "id='{$arvAdherence}' limit 1", "appendix");
?>
</td>
</tr>
</table>
</div>
</fieldset>
</td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td><img src="/images/spacer.gif" width="10" height="10" /></td>
</tr>
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.verify.preview.php
示例15: getDetailedTableInfo2
echo $id ? getDetailedTableInfo2("vl_admins", "id='{$id}'", "email") : "";
?>
"></td>
</tr>
<tr>
<td>Phone</td>
<td><input type="text" name="phone" id="phone" class="search" size="25" value="<?php
echo $id ? getDetailedTableInfo2("vl_admins", "id='{$id}'", "phone") : "+";
?>
"></td>
</tr>
<? if($id && $option!="remove") { ?>
<tr>
<td>Last Login</td>
<td><?php
echo $id ? getFormattedDate(getDetailedTableInfo2("vl_admins", "id='{$id}'", "login")) : "Unavailable";
?>
</td>
</tr>
<? } ?>
</table></td>
</tr>
<tr>
<td style="border-top:1px solid #cccccc; padding-top:10px">
<input type="submit" name="button" id="button" value=" Save " />
<? if($task=="modify") { ?>
<button type="button" id="button" name="button" value="button" onclick="document.location.href='?act=admins&nav=configuration'"> Cancel </button>
<input name="id" type="hidden" id="id" value="<?php
echo $id;
?>
">
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.admins.php
示例16: mysqlnumrows
<td class="<?php
echo $count < mysqlnumrows($xquery) ? "vl_tdstandard" : "vl_tdnoborder";
?>
">
<div>Clinical Request Form # <?php
echo $q["refNumber"];
?>
</div>
<div style="padding:5px 0px 0px 0px" class="vls_grey"><strong><?php
echo number_format((double) getDetailedTableInfo3("vl_forms_clinicalrequest", "refNumber='{$q['refNumber']}'", "count(id)", "num"));
?>
</strong> (<?php
echo getDetailedTableInfo2("vl_forms_clinicalrequest", "refNumber='{$q['refNumber']}' order by formNumber asc limit 1", "formNumber");
?>
to <?php
echo getDetailedTableInfo2("vl_forms_clinicalrequest", "refNumber='{$q['refNumber']}' order by formNumber desc limit 1", "formNumber");
?>
)</div>
</td>
<!--<td class="<?php
echo $count < mysqlnumrows($xquery) ? "vl_tdstandard" : "vl_tdnoborder";
?>
"><div class="vls_grey" style="padding:3px 0px 0px 0px"><a href="/downloads.forms/Clinical.Request.Form.<?php
echo $q["refNumber"];
?>
.pdf" target="_blank">Download Batch Form</a> :: <a href="#" onclick="iDisplayMessage('/generateforms/preview/<?php
echo $q["refNumber"];
?>
/')">View/Download Individual Forms</a></div></td>-->
</tr>
<? } ?>
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:tpl.generateforms.search.php
示例17: if
:: <a href="/verify/" class="vll_grey">Verify Samples</a>
<? } ?>
<? if(getDetailedTableInfo2("vl_users_permissions","userID='".getUserID($trailSessionUser)."' and permission='worksheets' limit 1","id")) { ?>
:: <a href="/worksheets/" class="vll_grey">Worksheets</a>
<? } ?>
<? if(getDetailedTableInfo2("vl_users_permissions","userID='".getUserID($trailSessionUser)."' and permission='generateForms' limit 1","id")) { ?>
:: <a href="/generateforms/" class="vll_grey">Generate Forms</a>
<? } ?>
<? if(getDetailedTableInfo2("vl_users_permissions","userID='".getUserID($trailSessionUser)."' and permission='results' limit 1","id")) { ?>
:: <a href="/results/" class="vll_grey">Results</a>
<? } ?>
<? if(getDetailedTableInfo2("vl_users_permissions","userID='".getUserID($trailSessionUser)."' and permission='results' limit 1","id")) { ?>
:: <a href="/results_new/" class="vll_grey">Results (Browser Printing)</a>
<? } ?>
<? if(getDetailedTableInfo2("vl_users_permissions","userID='".getUserID($trailSessionUser)."' and permission='reports' limit 1","id") ||
getDetailedTableInfo2("vl_users_permissions","userID='".getUserID($trailSessionUser)."' and permission='reportsQC' limit 1","id")) { ?>
:: <a href="/reports/" class="vll_grey">Reports</a></td>
<? } ?>
</tr>
<tr>
<td align="center">
<table width="90%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top">
<!-- Begin Center Table -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" bgcolor="#FFFFFF" style="padding:20px 30px"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:index.php
示例18: alterUserSetting
/**
* function to change a user's setting
* @param: $userID
* @param: $setting
* @param: $value
*/
function alterUserSetting($userID,$setting,$value) {
//globals
global $datetime,$trailSessionUser;
//does user have a setting account?
$query=0;
$query=mysqlquery("select * from vl_users_settings where userID='$userID'");
if(mysqlnumrows($query)) {
//log table change
logTableChange("vl_users_settings","$setting",getDetailedTableInfo2("vl_users_settings","userID='$userID'","id"),getDetailedTableInfo2("vl_users_settings","userID='$userID'","$setting"),$value);
//update
mysqlquery("update vl_users_settings set $setting='$value' where userID='$userID'");
} else {
//insert
mysqlquery("insert into vl_users_settings
(userID,$setting,created,createdby)
values
('$userID','$value','$datetime','$trailSessionUser')");
}
}
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:26，代码来源:functions.user.php
示例19:
* task 6: remove facilities for which there are no samples
* task 7: remove regimen which have no samples
* task 8: remove treatment lines which have no samples or regimen
* task 9: match the districtID and hubID within vl_samples to the facility within vl_facilities
* task 10: remove facilities with no samples
* task 11: populate vl_results_merged
*/
//task 11: populate vl_results_merged, begin with abbott
$query=0;
$query=mysqlquery("select * from vl_results_abbott");
if(mysqlnumrows($query)) {
while($q=mysqlfetcharray($query)) {
//factor
$factor=0;
$factor=getDetailedTableInfo2("vl_results_multiplicationfactor","worksheetID='$q[worksheetID]' limit 1","factor");
if(!$factor) {
$factor=1;
}
//alphanumeric result
$resultAlphanumeric=0;
$resultAlphanumeric=getVLResult("abbott",$q["worksheetID"],$q["sampleID"],$factor);
//numeric result
$resultNumeric=0;
$resultNumeric=getVLNumericResultOnly($resultAlphanumeric);
mysqlquery("insert ignore into vl_results_merged
(machine,worksheetID,vlSampleID,resultAlphanumeric,
resultNumeric,created,createdby)
values
('abbott','$q[worksheetID]','$q[sampleID]','$resultAlphanumeric',
'$resultNumeric','$q[created]','$q[createdby]')");
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:index.oneoffs.abbott.php
示例20: date
date(created)>='2015-12-27'
group by vlSampleID having num=1");
if(mysqlnumrows($query)) {
while($q=mysqlfetcharray($query)) {
//get the id
$id=0;
$id=getDetailedTableInfo2("vl_results_override","sampleID='$q[vlSampleID]' and date(created)>='2015-12-27' order by created desc limit 1","id");
//log and remove record
logDataRemoval("delete from vl_results_override where id='$id'");
mysqlquery("delete from vl_results_override where id='$id'");
}
}
*/
//task 4: a procedure to override key abbott results
$query=0;
$query=mysqlquery("select sampleID, count(id) num, max(created) dateCreated from vl_results_abbott
where
result='3119 A no clot exit detected error was encountered by the Liquid Handler.' and
sampleID not in (select sampleID from vl_results_override)
group by sampleID having num>1 order by num desc");
if(mysqlnumrows($query)) {
while($q=mysqlfetcharray($query)) {
//log result override
logResultOverride($q["sampleID"],getDetailedTableInfo2("vl_results_abbott","sampleID='$q[sampleID]' and created='$q[dateCreated]' limit 1","worksheetID"),$default_resultFailureNewSampleMessage);
}
}
//task 5: fix a result typo
mysqlquery("update vl_results_override set result='There is No Result Given. The Test Failed the Quality Control Criteria. We advise you send a new sample.' where result='There is No Result Given. The Test Failed the Quality Control Criteria. We advise you send a a new sample.'");
?>
开发者ID:CHAIUganda，项目名称:ViralLoad，代码行数:31，代码来源:index.oneoffs.overrides.php
注：本文中的getDetailedTableInfo2函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论