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
$_SESSION[smonth] = $_POST[smonth];
$_SESSION[emonth] = $_POST[emonth];
$sdate = strftime("%m/%d/%Y",mktime(0,0,0,$_POST[smonth],1,$_POST[year]));
$edate = strftime("%m/%d/%Y",mktime(0,0,0,($_POST[emonth]+1),0,$_POST[year]));
$queryconn->querycrit($dbname,$dbname2,$sdate,$edate,$_POST[brgy],0); //the fifth argument when set to zero, means that there is no form present in the query box
elseif($_SESSION[filter]==3): //quarterly tables
$arr_start_end = array('1'=>array('01/01','03/31'),'2'=>array('04/30','06/30'),'3'=>array('07/31','09/30'),'4'=>array('10/01','12/31'));
$sdate = $arr_start_end[$_POST[sel_quarter]][0].'/'.$_POST[year];
$edate = $arr_start_end[$_POST[sel_quarter]][1].'/'.$_POST[year];
$_SESSION[quarter] = $_POST[sel_quarter];
echo "<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]);
}
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
$_SESSION[smonth] = $_POST[smonth];
$_SESSION[emonth] = $_POST[emonth];
$sdate = strftime("%m/%d/%Y", mktime(0, 0, 0, $_POST[smonth], 1, $_POST[year]));
$edate = strftime("%m/%d/%Y", mktime(0, 0, 0, $_POST[emonth] + 1, 0, $_POST[year]));
$queryconn->querycrit($dbname, $dbname2, $sdate, $edate, $_POST[brgy], 0);
//the fifth argument when set to zero, means that there is no form present in the query box
} elseif ($_SESSION[filter] == 3) {
//quarterly tables
$arr_start_end = array('1' => array('01/01', '03/31'), '2' => array('04/30', '06/30'), '3' => array('07/31', '09/30'), '4' => array('10/01', '12/31'));
$sdate = $arr_start_end[$_POST[sel_quarter]][0] . '/' . $_POST[year];
$edate = $arr_start_end[$_POST[sel_quarter]][1] . '/' . $_POST[year];
$_SESSION[quarter] = $_POST[sel_quarter];
$_SESSION[year] = $_POST[year];