function showMdlCol() { $year = null; $month = null; $day = null; $fullDay = strtEndDateMonthDiff(); $today = $fullDay[0]; $dateArr = explode("-", $today); $curyear = $dateArr[0]; $curmonth = $dateArr[1]; $curday = $dateArr[2]; $year = $curyear; $month = $curmonth; $resultCaseReport = mysql_query("select casereportid, casedate from casereport"); while ($rowCaseReport = mysql_fetch_array($resultCaseReport)) { $id = $rowCaseReport['casereportid']; $caseDate = explode("-", $rowCaseReport['casedate']); if (strtotime($rowCaseReport['casedate']) < strtotime($today)) { if ($curday < $caseDate[2]) { $day = $caseDate[2] + 1; } else { $day = $curday; } $updatedate = $year . '-' . $month . '-' . $day; $day = null; mysql_query("update casereport set casedate = '" . $updatedate . "' where casereportid='" . $id . "' ") or die(mysql_error()); } } $resultBulkReport = mysql_query("select createdon,bulkcaseid from bulkcase"); while ($rowBulkReport = mysql_fetch_array($resultBulkReport)) { $id = $rowBulkReport['bulkcaseid']; $caseDate = explode("-", $rowBulkReport['createdon']); if (strtotime($rowBulkReport['createdon']) < strtotime($today)) { if ($curday < $caseDate[2]) { $day = $caseDate[2] + 1; } else { $day = $curday; } $updatedate = $year . '-' . $month . '-' . $day; $day = null; mysql_query("update bulkcase set createdon = '" . $updatedate . "' where bulkcaseid='" . $id . "' ") or die(mysql_error()); } } echo 'Date successfully updated'; }
/* districtkml file create */ $kml = array('<?xml version="1.0" encoding="UTF-8"?>'); $kml[] = '<kml xmlns="http://earth.google.com/kml/2.1">'; $kml[] = ' <Document>'; $kml[] = '<name>MLB.kml</name>'; $kml[] = ' <Style id="downArrowIcon">'; $kml[] = ' <IconStyle>'; $kml[] = ' <Icon>'; $kml[] = '<href>http://www.zyxware.com/projects/healthmonitor/images/districticon.png</href>'; $kml[] = ' </Icon>'; $kml[] = ' </IconStyle>'; $kml[] = ' </Style>'; $kml[] = '<Folder>'; $kml[] = '<name>MLB</name>'; /* find the start and end date */ list($startDate, $endDate) = strtEndDateMonthDiff(); $kmlData = ''; $resultDistrict = mysql_query("SELECT * FROM district"); while ($rowDistrict = mysql_fetch_array($resultDistrict)) { $districtName = $rowDistrict['name']; $kmlData .= '<Placemark>'; $kmlData .= '<description><![CDATA[<table style="border:thin solid #000000;font-size:10px; width:175px;background-color:#E9E9DA"> <tr> <th colspan="3"style="border:thin solid #000000;">' . $districtName . ' </th> </tr> <th style="border:thin solid #000000;"> Disease </th> <th style="border:thin solid #000000;">
function displayContent($authorise, $val) { $userName = $_SESSION['userName']; $strContent = '<h3>List Bulk Case Report</h3>'; $choice = 0; $result = null; switch ($val) { case "1": if (isset($_GET['Datestart'])) { $startdate = getDateToDb($_GET['Datestart']); $enddate = getDateToDb($_GET['Dateclose']); } else { $arrDate = strtEndDateMonthDiff(); $startdate = $arrDate[0]; $enddate = $arrDate[1]; } $filterVal = "createdon between '" . $startdate . "' and '" . $enddate . "' "; $choice = 1; $strContent .= '<h4>Case Reported between ' . getDateFromDb($startdate) . ' and ' . getDateFromDb($enddate) . '</h4>'; break; case "2": $disease = $_GET['cmpDiseaseList']; $filterVal = "bulkcase.diseaseid='" . $disease . "' "; $choice = 2; $resultDis = mysql_query("SELECT name FROM disease where \n\t\t\t\tdiseaseid='" . $disease . "' ") or die(mysql_error()); $row = mysql_fetch_array($resultDis); $strContent .= '<h4>Case Report of ' . $row['name'] . '</h4>'; break; case "3": $district = $_GET['cmpDistrictList']; $filterVal = "bulkcase.districtid='" . $district . "' "; $choice = 3; $resultDist = mysql_query("SELECT name FROM district where \n\t\t\t\tdistrictid='" . $district . "' ") or die(mysql_error()); $row = mysql_fetch_array($resultDist); $strContent .= '<h4>Case Report of ' . $row['name'] . '</h4>'; break; default: $arrDate = strtEndDateMonthDiff(); $startdate = $arrDate[0]; $enddate = $arrDate[1]; $filterVal = " reportedon between '" . $startdate . "' and '" . $enddate . "' "; $choice = 1; $strContent .= '<h4>Case Reported between ' . $startdate . ' and ' . $enddate . '</h4>'; break; } if ($authorise == "GMO") { $userName = $_SESSION['userName']; $resultGmo = mysql_query("SELECT districtid FROM gmo where username='******' ") or die(mysql_error()); $rowGmo = mysql_fetch_array($resultGmo); $districtid = $rowGmo['districtid']; $result = mysql_query("SELECT bulkcaseid, disease.name as diseasename, district.name as \n\t\t\tdistname, reportedcase, fatalcase, createdon\n\t\t\tFROM bulkcase \n\t\t\tLEFT JOIN disease on bulkcase.diseaseid=disease.diseaseid \n\t\t\tLEFT JOIN district on bulkcase.districtid=district.districtid \n\t\t\tLEFT JOIN gmo on bulkcase.districtid=gmo.districtid \n\t\t\tWHERE gmo.districtid='" . $districtid . "' and " . $filterVal . " ") or die(mysql_error()); $paginationQuery = "SELECT bulkcaseid, disease.name as diseasename, district.name as \n\t\t\tdistname, reportedcase, fatalcase, createdon\n\t\t\tFROM bulkcase \n\t\t\tLEFT JOIN disease on bulkcase.diseaseid=disease.diseaseid \n\t\t\tLEFT JOIN district on bulkcase.districtid=district.districtid \n\t\t\tWHERE bulkcase.districtid='" . $districtid . "' and " . $filterVal; } else { if ($authorise == "DAO") { $resultDao = mysql_query("SELECT districtid FROM dao where username='******' "); $rowDao = mysql_fetch_array($resultDao); $districtid = $rowDao['districtid']; $result = mysql_query("SELECT bulkcaseid, disease.name as diseasename, district.name as \n\t\t\tdistname, reportedcase, fatalcase, createdon\n\t\t\tFROM bulkcase \n\t\t\tLEFT JOIN disease on bulkcase.diseaseid=disease.diseaseid\n\t\t\tLEFT JOIN district on bulkcase.districtid=district.districtid \n\t\t\tWHERE bulkcase.districtid='" . $districtid . "' and " . $filterVal . "") or die(mysql_error()); $paginationQuery = "SELECT bulkcaseid, disease.name as diseasename, district.name as \n\t\t\tdistname, reportedcase, fatalcase, createdon\n\t\t\tFROM bulkcase \n\t\t\tLEFT JOIN disease on bulkcase.diseaseid=disease.diseaseid\n\t\t\tLEFT JOIN district on bulkcase.districtid=district.districtid \n\t\t\tWHERE bulkcase.districtid='" . $districtid . "' and " . $filterVal; } else { if ($authorise == "ADMIN") { $result = mysql_query("SELECT bulkcaseid, disease.name as diseasename, district.name as \n\t\t\tdistname, reportedcase, fatalcase, createdon\n\t\t\tFROM bulkcase \n\t\t\tLEFT JOIN disease on bulkcase.diseaseid=disease.diseaseid\n\t\t\tLEFT JOIN district on bulkcase.districtid=district.districtid\n\t\t\tWHERE 1=1 and " . $filterVal . " ") or die(mysql_error()); $paginationQuery = "SELECT bulkcaseid, disease.name as diseasename, district.name as \n\t\t\tdistname, reportedcase, fatalcase, createdon\n\t\t\tFROM bulkcase \n\t\t\tLEFT JOIN disease on bulkcase.diseaseid=disease.diseaseid\n\t\t\tLEFT JOIN district on bulkcase.districtid=district.districtid\n\t\t\tWHERE 1=1 and " . $filterVal; } else { } } } $intResultNum = mysql_num_rows($result); if ($intResultNum > 0) { list($result, $classObj, $dispyListInfo) = classPagination($paginationQuery, $intResultNum); $listData = listCaseReport($authorise, $intResultNum, $result); $strContent .= $listData; $strContent .= '<br /><br />'; $strContent .= $dispyListInfo . '<br />'; $strContent .= $classObj->navigationBar(); } else { $strContent .= "No data is stored in the database or you are not authorised to view this data"; } return $strContent; }
function showContent($authorise, $selectedText, $option) { $strContent = ""; $choice = 0; $dte1 = ""; $dte2 = ""; $curDate = ""; $event = ""; switch ($option) { case "1": $year = $_GET['MYear']; $dte1 = $year . "-" . $selectedText . "-" . "01"; $dte2 = $year . "-" . $selectedText . "-" . "31"; $filterval = "eventtime between '" . $dte1 . "' and '" . $dte2 . "' "; $choice = 1; break; case "2": $curDate = date("d.m.Y"); $arrDate = explode(".", $curDate); $dte1 = $selectedText . "-01-01"; $dte2 = $selectedText . "-12-31"; $filterval = "eventtime between '" . $dte1 . "' and '" . $dte2 . "' "; $choice = 2; break; case "3": if (isset($_GET['Datestart'])) { $startdate = getDateToDb($_GET['Datestart']); $enddate = getDateToDb($_GET['Dateclose']); } else { $arrDate = strtEndDateMonthDiff(); $startdate = $arrDate[0]; $enddate = $arrDate[1]; } $filterval = "eventtime between '" . $startdate . "' and '" . $enddate . "' "; $choice = 3; break; case "4": $filterval = "event like '%" . $selectedText . "' "; $choice = 4; break; default: break; } $result = mysql_query("select * from eventlog where 1=1 and " . $filterval . " ") or die(mysql_error()); $paginationQuery = "select * from eventlog where 1=1 and " . $filterval; $intCount = mysql_num_rows($result); if ($intCount > 0) { if ($choice == 1) { echo '<h4>Report on ' . getMonth($selectedText) . ' ' . $_GET['MYear'] . '</h4><br>'; } else { if ($choice == 2) { echo '<h4>Report For The Year ' . $selectedText . '</h4><br>'; } else { if ($choice == 3) { if (isset($_GET['Datestart'])) { echo '<h4>Report on ' . $_GET['Datestart'] . ' and ' . $_GET['Dateclose'] . '</h4><br>'; } else { echo '<h4>Report on ' . getDateFromDb($startdate) . ' and ' . getDateFromDb($enddate) . '</h4><br>'; } } else { echo '<h4>Report on ' . $selectedText . '</h4><br>'; } } } /* function for pagination */ list($result, $classObj, $dispyListInfo) = classPagination($paginationQuery, $intCount); $listData = listEvent($authorise, $intCount, $result); $strContent .= $listData; $strContent .= '<br /><br />'; $strContent .= $dispyListInfo . '<br />'; $strContent .= $classObj->navigationBar(); } else { $strContent .= "No data is stored in the database or you are not authorised to view this data"; } echo $strContent; }
function displayContent($authorise, $val) { $userName = $_SESSION['userName']; $strContent = '<h3>List Case Report</h3>'; $choice = 0; $result = null; switch ($val) { case "1": if (isset($_GET['Datestart'])) { $startdate = getDateToDb($_GET['Datestart']); $enddate = getDateToDb($_GET['Dateclose']); } else { $arrDate = strtEndDateMonthDiff(); $startdate = $arrDate[0]; $enddate = $arrDate[1]; } $filterVal = "reportedon between '" . $startdate . "' and '" . $enddate . "' "; $choice = 1; $strContent .= '<h4>Case Reported between ' . getDateFromDb($startdate) . ' and ' . getDateFromDb($enddate) . '</h4>'; break; case "2": $disease = $_GET['cmpDiseaseList']; $filterVal = "casereport.diseaseid='" . $disease . "' "; $choice = 2; $resultDis = mysql_query("SELECT name FROM disease where \n\t\t\t\tdiseaseid='" . $disease . "' ") or die(mysql_error()); $row = mysql_fetch_array($resultDis); $strContent .= '<h4>Case Report of ' . $row['name'] . '</h4>'; break; case "3": $district = $_GET['cmpDistrictList']; $filterVal = "casereport.districtid='" . $district . "' "; $choice = 3; $resultDist = mysql_query("SELECT name FROM district where \n\t\t\t\tdistrictid='" . $district . "' ") or die(mysql_error()); $row = mysql_fetch_array($resultDist); $strContent .= '<h4>Case Report of ' . $row['name'] . '</h4>'; break; case "4": $age = explode("-", $_GET['cmpAgeList']); $agest = $age[0]; $ageend = $age[1]; $filterVal = "age between '" . $agest . "' and '" . $ageend . "' "; $choice = 4; $strContent .= '<h4>Case Reported on age, between ' . $agest . ' and ' . $ageend . '</h4>'; break; case "5": $hospital = $_GET['cmpHospitalList']; $filterVal = "casereport.hospitalid='" . $hospital . "' "; $choice = 5; $resultHos = mysql_query("SELECT name FROM hospital where \n\t\t\t\thospitalid='" . $hospital . "' ") or die(mysql_error()); $row = mysql_fetch_array($resultHos); $strContent .= '<h4>Case Report of ' . $row['name'] . '</h4>'; break; default: $arrDate = strtEndDateMonthDiff(); $startdate = $arrDate[0]; $enddate = $arrDate[1]; $filterVal = " reportedon between '" . $startdate . "' and '" . $enddate . "' "; $choice = 1; $strContent .= '<h4>Case Reported between ' . $startdate . ' and ' . $enddate . '</h4>'; break; } if ($authorise == "GMO") { $resultGmo = mysql_query("SELECT districtid FROM gmo where username='******' ") or die(mysql_error()); $rowGmo = mysql_fetch_array($resultGmo); $districtid = $rowGmo['districtid']; $result = mysql_query("SELECT casereportid, casereport.name as pname, age, sex, \n\t\t\tdisease.name as dname, hospital.name as hname, casedate FROM casereport \n\t\t\tLEFT JOIN hospital on casereport.hospitalid=hospital.hospitalid\n\t\t\tLEFT JOIN disease on casereport.diseaseid=disease.diseaseid \n\t\t\tWHERE casereport.districtid='" . $districtid . "' and " . $filterVal . "") or die(mysql_error()); $paginationQuery = "SELECT casereportid, casereport.name as pname, age, sex, \n\t\t\t\t\t\t\t\t\t\t\tdisease.name as dname, hospital.name as hname, casedate FROM casereport \n\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN hospital on casereport.hospitalid=hospital.hospitalid\n\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN disease on casereport.diseaseid=disease.diseaseid \n\t\t\t\t\t\t\t\t\t\t\tWHERE casereport.districtid='" . $districtid . "' and " . $filterVal; } else { if ($authorise == "DAO") { $resultDao = mysql_query("SELECT districtid FROM dao where username='******' "); $rowDao = mysql_fetch_array($resultDao); $districtid = $rowDao['districtid']; $result = mysql_query("SELECT casereportid, casereport.name as pname, age, sex, \n\t\t\tdisease.name as dname, hospital.name as hname, casedate FROM casereport \n\t\t\tLEFT JOIN hospital on casereport.hospitalid=hospital.hospitalid\n\t\t\tLEFT JOIN disease on casereport.diseaseid=disease.diseaseid \n\t\t\tWHERE casereport.districtid='" . $districtid . "' and " . $filterVal . "") or die(mysql_error()); $paginationQuery = "SELECT casereportid, casereport.name as pname, age, sex, \n\t\t\t\t\t\t\t\t\t\t\tdisease.name as dname, hospital.name as hname, casedate FROM casereport \n\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN hospital on casereport.hospitalid=hospital.hospitalid\n\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN disease on casereport.diseaseid=disease.diseaseid \n\t\t\t\t\t\t\t\t\t\t\tWHERE casereport.districtid='" . $districtid . "' and " . $filterVal; } else { if ($authorise == "HOSPITAL") { $resultHos = mysql_query("SELECT hospitalid FROM hospital where username='******' "); $rowHos = mysql_fetch_array($resultHos); $hosId = $rowHos['hospitalid']; $result = mysql_query("SELECT casereportid, casereport.name as pname, age, sex, \n\t\t\tdisease.name as dname,hospital.name as hname, casedate FROM casereport \n\t\t\tLEFT JOIN hospital on casereport.hospitalid=hospital.hospitalid\n\t\t\tLEFT JOIN disease on casereport.diseaseid=disease.diseaseid \n\t\t\tWHERE casereport.hospitalid='" . $hosId . "' and " . $filterVal . " ") or die(mysql_error()); $paginationQuery = "SELECT casereportid, casereport.name as pname, age, sex, \n\t\t\tdisease.name as dname,hospital.name as hname, casedate FROM casereport \n\t\t\tLEFT JOIN hospital on casereport.hospitalid=hospital.hospitalid\n\t\t\tLEFT JOIN disease on casereport.diseaseid=disease.diseaseid \n\t\t\tWHERE casereport.hospitalid='" . $hosId . "' and " . $filterVal; } else { if ($authorise == "ADMIN") { $result = mysql_query("SELECT casereportid, casereport.name as pname, age, sex, \n\t\t\tdisease.name as dname, hospital.name as hname, casedate FROM casereport \n\t\t\tLEFT JOIN hospital on casereport.hospitalid=hospital.hospitalid\n\t\t\tLEFT JOIN disease on casereport.diseaseid=disease.diseaseid \n\t\t\tWHERE " . $filterVal . " ") or die(mysql_error()); $paginationQuery = "SELECT casereportid, casereport.name as pname, age, sex, \n\t\t\t\t\t\t\t\t\t\t\tdisease.name as dname, hospital.name as hname, casedate FROM casereport \n\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN hospital on casereport.hospitalid=hospital.hospitalid\n\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN disease on casereport.diseaseid=disease.diseaseid \n\t\t\t\t\t\t\t\t\t\t\tWHERE " . $filterVal; } else { } } } } $intResultNum = mysql_num_rows($result); if ($intResultNum > 0) { /* function for pagination */ list($result, $classObj, $dispyListInfo) = classPagination($paginationQuery, $intResultNum); $listData = listCaseReport($authorise, $intResultNum, $result); $strContent .= $listData; $strContent .= '<br /><br />'; $strContent .= $dispyListInfo . '<br />'; $strContent .= $classObj->navigationBar(); } else { $strContent .= "No data is stored in the database or you are not authorised to view this data"; } return $strContent; }