Example #1
0
$this->user = $auth->auth;
$tpl->set_var("uname", $this->user["uname"]);
$tpl->set_var("today", date("F j, Y"));
// must have atleast TM-VIEW access
$pageType = "%%%%1%%%%%";
if (!checkPerms($this->user["userType"], $pageType)) {
    header("Location: Unauthorized.php" . $this->sess->url(""));
    exit;
}
$tpl->set_block(report, LGUBLK, lguBlk);
$db = new DB_RPTS();
$sql = "select * from MunicipalityCity order by description;";
$db->query($sql);
for ($i = 0; $db->next_record(); $i++) {
    $tpl->set_var($db->Record);
    $tpl->parse(lguBlk, LGUBLK, true);
}
if ($municipalityCityID) {
    $tpl->set_var("selected_municipalityCityID_" . $municipalityCityID, "selected");
} else {
    $tpl->set_var("selected_municipalityCityID_" . $municipalityCityID, "");
}
if ($startMM) {
    $tpl->set_var("selected_startMM_" . $startMM, "selected");
} else {
    $tpl->set_var("selected_startMM_" . startMM, "");
}
if ($endMM) {
    $tpl->set_var("selected_endMM_" . $endMM, "selected");
} else {
    $tpl->set_var("selected_endMM_" . $endMM, "");
<?
include_once("web/prepend.php");
 include_once('web/panachart.php');

$tpl=new rpts_Template();
$tpl->set_file(array(report=>"Form.htm"));

$db = new DB_SelectLGU("erpts-test");
$db->query("SELECT * FROM Barangay ORDER BY description");
$tpl->set_block(report,BRGY,bBlk);
if($db->num_rows()>0){
	for($r=0;$db->next_record();$r++){
		$tpl->set_var(barangayID,$db->f("barangayID"));
		$tpl->set_var(barangayName,$db->f("description"));
		$tpl->parse(bBlk,BRGY,true);
	}
}
$tpl->set_var(fileName,$PHP_SELF);

if($isSubmit){

  
 $db = new DB_SelectLGU("erpts-test");

if($brgyID==0)
 $sql ="SELECT ".ucwords($classification)."ActualUses.code as description, sum( ".ucwords($classification).".marketValue ) as total
		FROM AFS
		INNER JOIN ".ucwords($classification)."
		USING ( afsID ) 
		INNER  JOIN ".ucwords($classification)."ActualUses ON ".ucwords($classification).".actualUse = ".ucwords($classification)."ActualUses.".$classification."ActualUsesID
		GROUP  BY ( ".$classification."ActualUsesID )";
Example #3
0
//echo ceil(count($buffer)/$rowPerPage)."<br>";
$tpl->set_block(report, PAGE, pageBlk);
$tpl->set_block(PAGE, ROW, rowBlk);
$tpl->set_block(PAGE, ROW1, row1Blk);
$pages = ceil(count($buffer) / $rowPerPage);
$tpl->set_var("pages", $pages * 2);
for ($h = 1; $h <= $pages; $h++) {
    $tpl->set_var("sheet1", ($h - 1) * 2 + 1);
    $tpl->set_var("sheet2", ($h - 1) * 2 + 2);
    for ($i = $iStart; $i < count($buffer) && floor($i / $h) < $rowPerPage; $i++) {
        $ypos = $ypos - 18;
        $ypos1 = $ypos1 - 18;
        $tpl->set_var($buffer[$i]);
        $tpl->set_var(ypos, $ypos);
        $tpl->set_var(ypos1, $ypos1);
        $tpl->parse(rowBlk, ROW, true);
    }
    $iStart = $i;
    #echo("row=".$i."<br>");
    for ($j = $jStart; $j < count($buffer) && floor($j / $h) < $rowPerPage; $j++) {
        $yposx = $yposx - 18;
        $yposx1 = $yposx1 - 18;
        $tpl->set_var($buffer[$j]);
        $tpl->set_var(ypos, $yposx);
        $tpl->set_var(ypos1, $yposx1);
        $tpl->parse(row1Blk, ROW1, true);
    }
    $jStart = $j;
    #echo("row1=".$i."<br>");
    $tpl->parse(pageBlk, PAGE, true);
    $tpl->set_var(rowBlk, "");