/**
* log new facility, return facilityID
*/
function logNewFacility($facility,$district) {
global $datetime,$user;
//clean up $facility
$facility=validate($facility);
//get/log the districtID
$districtID=0;
$districtID=logNewDistrict($district);
mysqlquery("insert ignore into vl_facilities_temp
(facility)
values
('".trim($facility)."')");
//avoid duplicates
if(!getDetailedTableInfo2("vl_facilities","lower(facility)='".strtolower($facility)."' and districtID='$districtID' limit 1","id")) {
//add new facility
mysqlquery("insert into vl_facilities
(facility,districtID,created,createdby)
values
('".trim($facility)."','$districtID','$datetime','$user')");
//return facilityID
return getDetailedTableInfo2("vl_facilities","createdby='$user' order by id desc limit 1","id");
} else {
//return facilityID
return getDetailedTableInfo2("vl_facilities","lower(facility)='".strtolower($facility)."' and districtID='$districtID' limit 1","id");
}
}
where
id='$sampleID'");
if(mysqlerror())
die("1: ".mysqlerror());
}
}
//update facilities and IPs
for($i=2;$i<=$excelData->sheets[1]['numRows'];$i++) {
//Facility
$facilityID=0;
$facilityID=logNewFacility(trim($excelData->sheets[1]['cells'][$i][1]),trim($excelData->sheets[1]['cells'][$i][2]));
//District
$districtID=0;
$districtID=logNewDistrict(trim($excelData->sheets[1]['cells'][$i][2]));
//Hub
$hubID=0;
$hubID=logNewHub(trim($excelData->sheets[1]['cells'][$i][3]),$facilityID);
//IP
$ipID=0;
$ipID=logNewIP(trim($excelData->sheets[1]['cells'][$i][4]),$facilityID,$hubID);
}
//update regimen
for($i=2;$i<=$excelData->sheets[2]['numRows'];$i++) {
//Current Regimen
$currentRegimenID=0;
$currentRegimenID=logNewCurrentRegimen(trim($excelData->sheets[2]['cells'][$i][1]));
