//for Grand Total
$countBHSQuery = mysqli_query($dbConnect, $countBHSsql . " '{$newSDate}' AND '{$newEDate}'");
$countBHSResult1 = mysqli_fetch_array($countBHSQuery);
if ($countBHSResult1[$countBHSresult] == 0) {
echo "<td align='right'>{$countBHSResult1[$countBHSresult]}</td>";
} else {
echo "<td align='right'><a href='viewname.php?parseString1={$totalPatientPARSE}&parseString2={$countBHSParse}&sDate={$newSDate}&eDate={$newEDate}&count={$countBHSResult1[$countBHSresult]}' target='_blank'>{$countBHSResult1[$countBHSresult]}</a></td>";
}
echo "</tr>";
//Extract all bhs with values
$bhsSQL1 = "SELECT bhs_id, bhs_name, barangay_id FROM m_lib_bhs";
$bhsName = "bhs_name";
$bhsID = "bhs_id";
$bhsSQL2 = "SELECT count(a.patient_id), a.last_modified, b.patient_id, c.family_id, c.barangay_id, d.barangay_id, d.bhs_id, e.bhs_id, e.bhs_name FROM m_lib_sms_px_enroll a JOIN " . "m_family_members b ON b.patient_id = a.patient_id JOIN " . "m_family_address c ON c.family_id = b.family_id JOIN " . "m_lib_bhs_barangay d ON d.barangay_id = c.barangay_id JOIN " . "m_lib_bhs e ON e.bhs_id = d.bhs_id JOIN " . "m_patient f ON f.patient_id = a.patient_id " . "WHERE e.bhs_id =";
$bhsPatient = "count(a.patient_id)";
distribution($s, $e, $bhsSQL1, $bhsName, $bhsID, $bhsSQL2, $bhsPatient, $totalPatientPARSE, $countBHSParse);
//Total Messages
echo "<tr id='end'>";
$totalMessagePARSE = "Total Number of Messages Generated";
echo "<td><ol start='2'><li>{$totalMessagePARSE}</li></ol></td>";
$totalMessageSQL = "SELECT count(DISTINCT sms_id) FROM m_lib_sms_alert WHERE date_format(alert_date, '%Y/%m/%d') BETWEEN ";
$totalMessageROW = "count(DISTINCT sms_id)";
totalCount($s, $e, $totalMessageSQL, $totalMessageROW);
//Grand Total
$totalMessageQuery = mysqli_query($dbConnect, $totalMessageSQL . " '{$newSDate}' AND '{$newEDate}'");
$totalMessageResult = mysqli_fetch_array($totalMessageQuery);
echo "<td align='right'>{$totalMessageResult[$totalMessageROW]}</td>";
echo "</tr>";
// PROGRAM
echo "<tr id='end' class='header'>";
echo "<td><ul type='none' style='margin-left:-15px'><li><span style='padding-right:9px;'>-</span>Distribution Per Program</li></ul></td>";
}
////////////
//define_s("dest","distrib/prog");
$_SESSION['dest'] = $_GET["dest"] ? $_GET["dest"] : $_SESSION['dest'];
$_SESSION['dest'] = $_SESSION['dest'] ? $_SESSION['dest'] : "prog";
$_SESSION['updfirst'] = '';
#server
if ($_GET["version"]) {
$ret = verif_version();
}
if ($_GET["filedate"]) {
$_SESSION['dest'] = $_GET["filedate"];
$ret = give_maj_servermtime();
}
if ($_GET["datapage"]) {
$ret = distribution($_GET["datapage"]);
}
if ($_GET["page"]) {
$ret = give_page();
}
//sourcedir
if ($_GET["gz"]) {
$ret = give_gz();
}
if ($_GET["datapage"] or $_GET["page"]) {
//if($_GET["b64"])$ret=base64_encode($ret);
$ret = str_replace(array('<' . '?php', '?' . '>'), "", $ret);
}
if ($_GET["dir"]) {
scrut_dir_files('../' . $_GET["dir"]);
}
