/** * 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]));