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