break; case 4: getActualUses("PlantsTrees", $tpl); break; default: break; } $tpl->set_var("selected" . $propertyType, "selected"); $tpl->set_var(startYear, $startYY); $tpl->set_var(endYear, $endYY); } else { $tpl->set_var(startYear, date("Y")); $tpl->set_var(endYear, date("Y")); //$tpl->set_block(report,ACTUALUSE,aBlk); //$db->query("Select * from LandActualUses"); getActualUses("Land", $tpl); } $tpl->set_var("Session", $sess->url("")); $tpl->pparse(report, report); page_close(); function getActualUses($var, &$tpl) { if ($var == "") { return; } $db = new DB_RPTS(); $sql = "SELECT * FROM " . $var . "ActualUses ORDER BY " . $var . "ActualUses.description ASC "; $tpl->set_block(report, ACTUALUSE, aBlk); $db->query($sql); $firstChar = strtolower(substr($var, 0, 1)); $restOfTheString = substr($var, 1);
} else { $tpl->set_var("selected_endMM_" . $endMM, ""); } if ($propertyType) { switch ($propertyType) { case 1: getActualUses("Land", $tpl); break; case 2: getActualUses("ImprovementsBuildings", $tpl); break; case 3: getActualUses("Machineries", $tpl); break; case 4: getActualUses("PlantsTrees", $tpl); break; default: break; } $tpl->set_var("selected" . $propertyType, "selected"); $tpl->set_var(startYear, $startYY); $tpl->set_var(endYear, $endYY); } else { $tpl->set_var(startYear, "2003"); $tpl->set_var(endYear, "2003"); $tpl->set_block(report, ACTUALUSE, aBlk); } $tpl->set_var("Session", $sess->url("")); $tpl->pparse(report, report); page_close();