<body>
<?
if($_SESSION["userid"]!=""):
$db_conn = mysql_connect(localhost,$_SESSION["dbuser"],$_SESSION["dbpass"]) or mysql_error();
mysql_select_db($_SESSION["dbname"],$db_conn) or mysql_error();
echo "<table><tr valign=\"top\"><td rowspan=\"2\">";
//container of questions
$widconn->query_class($dbname2,$_SESSION[cat],$_SESSION[ques]);
echo "</td>";
echo "<td valign=\"top\">";
if(isset($_SESSION[ques]) || $_POST[q_submit]):
$widconn->query_cat($dbname,$dbname2,$_POST[sdate],$_POST[edate],$_POST[sel_brgy]);
endif;
echo "</tr>";
echo "</table>";
echo "<br><br>";
//upon setting filters, set the necessary sessions here
if($_POST[q_submit]):
// set the session for start date and end date
if($_SESSION[filter]==1):
$queryconn->querycrit($dbname,$dbname2,$_POST[sdate],$_POST[edate],$_POST[sel_brgy],$_POST[sel_fp_method]);
elseif($_SESSION[filter]==2): //summary tables
echo "<table style=\"font-family: arial\">";
echo "<tr valign='top' align='center' style=\"background-color: #666666;color: #FFFF66;text-align: center;font-weight: bold;font-size:16pt;\"><td colspan='3'>QUERY BROWSER v2 -- Report Generator for Health Programs and Indicators</td></tr>";
echo "<tr valign='top' align='center' style=\"background-color: #666666;color: #FFFF66;text-align: left;font-weight: bold;font-size:13px;\"><td colspan='3'>DIRECTIONS: 1. Select Classification 2. Select Queries 3. Set the Filters 4. Click SUBMIT and download the REPORT</td></tr>";
echo "<tr valign='top' align='center' style=\"background-color: #666666;color: #FFFF66;text-align: left;font-weight: bold;font-size:13px;\"><td colspan='3'>This version includes FHSIS 2012 new indicators for maternal care, child care and family planning programs. You may access the old QB version <a href='../chits_query_2008/index.php' target='new'>here</a>.</td></tr>";
echo "<tr valign='top' align='center' style=\"background-color: #666666;color: #FFFF66;text-align: left;font-weight: bold;font-size:13px;\"><td colspan='3'>To access SPASMS Data Analytics click <a href='../site/spasmsda/spasmsda.php' target='_blank'>here</a>.</td></tr>";
echo "<tr valign='top' align='center' style=\"background-color: #666666;color: #FFFF66;text-align: left;font-weight: bold;font-size:13px;\"><td colspan='3'>To access Monitoring and Evaluation (Statistics) click <a href='../site/me/' target='_blank'>here</a>.</td></tr>";
echo "<tr valign='top' align='center' style=\"background-color: #666666;color: #FFFF66;text-align: left;font-weight: bold;font-size:13px;\"><td colspan='3'>You may access the PCB Electronic Forms <a href='../site/philhealth/index.php' target='_blank'>here</a>.</td></tr>";
echo "<tr valign='top' align='center' style=\"background-color: #666666;color: #FFFF66;text-align: left;font-weight: bold;font-size:13px;\"><td colspan='3'>You may access the Family Folder Master List <a href='../site/familyfolder/familyfolder.php' target='_blank'>here</a>.</td></tr>";
echo "<tr valign=\"top\"><td rowspan=\"2\">";
//container of questions
echo "<td>";
$widconn->query_class($dbname2, $_SESSION[cat], $_SESSION[ques]);
echo "<br><br>";
if (isset($_SESSION[ques]) || $_POST[q_submit]) {
unset($_SESSION["arr_px_labels"]);
$widconn->query_cat($dbname, $dbname2, $_POST[sdate], $_POST[edate], $_POST[sel_brgy], $_POST[sel_hidden_value]);
}
echo "</td>";
//echo "<td valign=\"top\">";
/*if(isset($_SESSION[ques]) || $_POST[q_submit]):
$widconn->query_cat($dbname,$dbname2,$_POST[sdate],$_POST[edate],$_POST[sel_brgy]);
endif; */
echo "<td>";
//upon setting filters, set the necessary sessions here
if ($_POST[q_submit]) {
//$queryconn->clean_db();
// set the session for start date and end date
if ($_SESSION[filter] == 1) {
$queryconn->querycrit($dbname, $dbname2, $_POST[sdate], $_POST[edate], $_POST[sel_brgy], $_POST[sel_fp_method]);
} elseif ($_SESSION[filter] == 2) {
//summary tables
