<?php
$page_title = 'Barangay System';
$stylesheet_link = 'style';
require 'path.php';
init_cobalt();
require 'header.php';
require_once 'subclasses/service.php';
$dbh_service = new service();
$dbh_service->execute_query("SELECT bulletin_name,bulletin_description,file_document FROM bulletin WHERE category='information' ");
$result = $dbh_service->result;
?>
<main>
<section class="body-layout">
<h3><center>Your registration will go through verification process<br>
we will just notify when you are officially registered to the system
<h3></center>
<br>
<a href="main.php"><center>Continue</center></a>
</main>
<?php
require 'footer.php';
?>
<?php
$page_title = 'Barangay System';
$stylesheet_link = 'style';
require 'path.php';
init_cobalt();
require 'header1.php';
require_once 'subclasses/service.php';
$dbh_service = new service();
$dbh_service->execute_query("SELECT bulletin_name,bulletin_description,file_document FROM bulletin WHERE category='Education' OR 'Health' ");
$result = $dbh_service->result;
?>
<main>
<div class="block-body">
<center><h1>Education</h1></center>
<!--<table border=3 width='1000px' >-->
<?php
while ($row = $result->fetch_assoc()) {
extract($row);
echo "<div class='home-layout home'>";
echo "<div class='descript'>";
echo "<h2>{$bulletin_name}</h2>";
echo "<img class='homeimg' src='../../tmp/{$file_document}' >";
echo "<p class='proj-descript'>{$bulletin_description}<br></p>";
echo "</div>";
echo "</div>";
}
?>
<!--<?php
<?php
$page_title = 'Barangay System';
$stylesheet_link = 'style';
require 'path.php';
init_cobalt();
require 'header1.php';
require_once 'subclasses/service.php';
$dbh_service = new service();
$dbh_service->execute_query("SELECT bulletin_id, bulletin_name,bulletin_description,file_document FROM bulletin WHERE category='information' ");
$result = $dbh_service->result;
$dbh_service->execute_query("SELECT bulletin_id,file_document FROM bulletin WHERE category='Main Event' ORDER BY bulletin_id DESC ");
$result1 = $dbh_service->result;
?>
<main>
<div class="block-body">
<center><font size='25px'>EVENTS</font></center>
<center><div class="main-headline">
<?php
if ($row1 = $result1->fetch_assoc()) {
echo "<img width='800px' class='headline' src='../../tmp/{$row1['file_document']}'>";
}
?>
<!--<img width='800px' class="headline" src='event.jpg'>-->
</div></center><br><br>
<!--<table border=3 width='1000px' >-->
<?php
while ($row = $result->fetch_assoc()) {
extract($row);
<?php
$page_title = 'Barangay System';
$stylesheet_link = 'style';
require 'path.php';
init_cobalt();
require 'header1.php';
require_once 'subclasses/service.php';
$dbh_service = new service();
$dbh_service->execute_query("SELECT bulletin_name,bulletin_description,file_document FROM bulletin WHERE bulletin_id = '{$_GET['b']}'");
$result = $dbh_service->result;
?>
<main>
<div class="block-body">
<center><font size='25px'>EVENTS</font></center><br/><br/>
<?php
while ($row = $result->fetch_assoc()) {
extract($row);
echo "<h2>{$bulletin_name}</h2><br/>";
echo "<img class='showimg' src='../../tmp/{$file_document}'/><br><br><br>";
echo "<p>{$bulletin_description}<br></p>";
}
?>
<!--</table>-->
</div>
<?php
$page_title = 'Barangay System';
$stylesheet_link = 'style';
require 'path.php';
init_cobalt();
require 'header1.php';
require_once 'subclasses/service.php';
$dbh_service = new service();
$dbh_service->execute_query("SELECT s.service_name, r.service_requirement FROM service s JOIN requirement r ON s.service_id = r.service_id WHERE is_offered='yes'");
$result = $dbh_service->result;
$service_requirements = array();
while ($row = $result->fetch_assoc()) {
$service_requirements[] = $row;
}
$dbh_service->execute_query("SELECT DISTINCT service_name, service_description FROM service WHERE is_offered='yes'");
$result = $dbh_service->result;
$services = array();
while ($row = $result->fetch_assoc()) {
$services[] = $row;
}
?>
<main>
<section class="body-layout">
<center><h1>List of Documents</h1></center><br/><br/>
<center><table class="doctable">
<?php
echo "<tr class='doctable'>";
echo "<th class='doctable'>Service Name</th>";
echo "<th class='doctable'>Service Requirement</th>";
echo "<th class='doctable'>Serviced Description</th></tr>";
foreach ($services as $row) {
<?php
$page_title = 'Barangay System';
$stylesheet_link = 'style';
require 'header1.php';
require 'path.php';
init_cobalt();
require_once 'subclasses/service.php';
$dbh_service = new service();
$dbh_service->execute_query("SELECT service_requirement,requirement_service_name FROM requirement WHERE requirement_service_name='1' ");
$result = $dbh_service->result;
?>
<main>
<section class="body-layout" style="height:410px;">
<h2>Requirements</h2>
<table border='2'>
<?php
while ($row = $result->fetch_assoc()) {
extract($row);
echo "<tr>";
echo "<td>{$service_requirement}</td>";
echo "</tr>";
}
?>
</table>
</section>
</main>
<?php
require 'footer.php';
<?php
$page_title = 'Barangay System';
$stylesheet_link = 'style';
require 'path.php';
init_cobalt();
require_once 'subclasses/service.php';
$dbh_service = new service();
$dbh_service->execute_query("SELECT bulletin_id,file_document FROM bulletin WHERE category='Main Event' AND is_show='Yes' ORDER BY bulletin_id DESC ");
$result1 = $dbh_service->result;
echo "<div class='headevent' onload='start()'>";
$fd = 0;
while ($row1 = $result1->fetch_assoc()) {
$fd++;
$size = sizeof($row1);
$num = $fd;
echo "<a href='showmore.php?b={$row1['bulletin_id']}'><img width='800px' class='headline' id='headline{$num}' src='../../tmp/{$row1['file_document']}'></a>";
echo $num;
}
echo "</div>";
?>
<!DOCTYPE html>
<html>
<head>
<title><?php
echo $page_title;
?>
</title>
<!--link rel="stylesheet" type="text/css" href="css/style_about.css"/-->
<?php
$page_title = 'Barangay System';
$stylesheet_link = 'style';
require 'path.php';
init_cobalt();
require 'header1.php';
require_once 'subclasses/service.php';
$dbh_service = new service();
$dbh_service->execute_query("SELECT bulletin_id,bulletin_name,bulletin_description,file_document FROM bulletin WHERE category in ('education','health') ");
$result = $dbh_service->result;
?>
<main>
<div class="block-body">
<center><h1>Education</h1></center>
<!--<table border=3 width='1000px' >-->
<?php
while ($row = $result->fetch_assoc()) {
extract($row);
if (strlen($bulletin_description) < 100) {
//do nothing
} else {
$bulletin_description = substr($bulletin_description, 0, 99);
$bulletin_description .= "…";
$bulletin_description .= '<p><a href="showmore.php?b=' . $bulletin_id . '">[Show more]</a></p>';
}
echo "<div class='home-layout home'>";
echo "<div class='descript'>";
echo "<h2>{$bulletin_name}</h2>";
echo "<img class='homeimg' src='../../tmp/{$file_document}' >";
