public static function create($username, $password) { global $db; if (citizen::username_exists($username)) { return array("status" => "username_exists"); } $db->query("insert into citizen (username,password) values('" . $db->real_escape_string($username) . "', ENCRYPT('" . $db->real_escape_string($password) . "'))"); return new citizen($db->insert_id); }
if (trim($_SESSION['icon_set'] == '')) { $_SESSION['icon_set'] = 'cobalt'; } } $data_con->close_db(); require 'components/get_listview_referrer.php'; init_var($arr_error); init_var($first_field); init_var($goto_region); init_var($goto_skill); if (xsrf_guard()) { init_var($_POST['btn_cancel']); init_var($_POST['btn_submit']); require 'components/query_string_standard.php'; require 'subclasses/citizen.php'; $dbh_citizen = new citizen(); $object_name = 'dbh_citizen'; require 'components/create_form_data_with_upload.php'; extract($arr_form_data); if ($_POST['btn_cancel']) { log_action('Pressed cancel button'); redirect("main.php"); } $file_upload_control_name = "cf_validate_proof_of_id"; $mf_upload_counter_name = "validate_count"; require 'components/upload_generic_mf.php'; $file_upload_control_name = "cf_validate_proof_of_address"; $mf_upload_counter_name = "validate_count"; require 'components/upload_generic_mf.php'; if ($_POST['btn_submit']) { log_action('Pressed submit button');
//Generated by Cobalt, a rapid application development framework. http://cobalt.jvroig.com //Cobalt developed by JV Roig (jvroig@jvroig.com) //**************************************************************************************** require 'path.php'; init_cobalt('Edit citizen'); if (isset($_GET['citizen_id'])) { $citizen_id = urldecode($_GET['citizen_id']); require 'form_data_citizen.php'; } debug("HELLO"); if (xsrf_guard()) { init_var($_POST['btn_cancel']); init_var($_POST['btn_submit']); require 'components/query_string_standard.php'; require 'subclasses/citizen.php'; $dbh_citizen = new citizen(); $object_name = 'dbh_citizen'; require 'components/create_form_data.php'; extract($arr_form_data); if ($_POST['btn_cancel']) { log_action('Pressed cancel button'); redirect("listview_citizen.php?{$query_string}"); } if ($_POST['btn_submit']) { log_action('Pressed submit button'); $message .= $dbh_citizen->sanitize($arr_form_data)->lst_error; extract($arr_form_data); if ($dbh_citizen->check_uniqueness_for_editing($arr_form_data)->is_unique) { //Good, no duplicate in database } else { $message = "Record already exists with the same primary identifiers!";
<?php $page_title = 'Barangay System'; $stylesheet_link = 'style'; require 'path.php'; init_cobalt(); require 'header1.php'; require 'components/get_listview_referrer.php'; $username = $_SESSION['user']; require_once 'subclasses/citizen.php'; $dbh_citizen1 = new citizen(); $citizen = $dbh_citizen1->execute_query("SELECT city FROM citizen WHERE username='******'")->result; extract($citizen->fetch_assoc()); $city_citizen = $city; require_once 'subclasses/school.php'; $dbh_school = new school(); $dbh_school->execute_query("SELECT * FROM school WHERE city = {$city_citizen} && is_evacuation = 'Yes'"); $result1 = $dbh_school->result; ?> <main> <div class="block-body"> <div class="fold-2"> <h3 class="fold-2-head center-obj fold-head">Mga lugar sa Ating Barangay</h3> <hr class="hr"/> <?php //echo $city_citizen; while ($row1 = $result1->fetch_assoc()) { extract($row1); echo '<li>'; echo $school_name; echo '</li>';
<?php if (isset($_POST["username"]) && isset($_POST["password"])) { $response = citizen::login($_POST["username"], $_POST["password"], gf::getClientIP()); if ($response instanceof citizen) { $_SESSION["user"] = serialize($response); die(json_encode(array("status" => "success", "params" => array("displayname" => $response->displayname, "type" => "citizen")))); } elseif ($response["status"] == "username_error") { $response = iwatchadmin::login($_POST["username"], $_POST["password"], gf::getClientIP()); if ($response instanceof iwatchadmin) { $_SESSION["user"] = serialize($response); die(json_encode(array("status" => "success", "params" => array("displayname" => $response->displayname, "type" => "iwatchadmin")))); } elseif ($response["status"] == "username_error") { $response = elected::login($_POST["username"], $_POST["password"], gf::getClientIP()); if ($response instanceof elected) { $_SESSION["user"] = serialize($response); die(json_encode(array("status" => "success", "params" => array("displayname" => $response->displayname, "type" => "elected")))); } else { die(json_encode($response)); } } else { die(json_encode($response)); } } else { die(json_encode($response)); } } else { die(json_encode(array("status", "parameter_required"))); }
<?php if (isset($_POST["username"]) && isset($_POST["password"]) && isset($_POST["email"]) && isset($_POST["tel"])) { $new_user = citizen::create($_POST["username"], $_POST["password"]); if ($new_user instanceof citizen) { $_SESSION["user"] = serialize($new_user); die(json_encode(array("status" => "success", "params" => array("displayname" => $new_user->displayname, "type" => "citizen")))); } else { die(json_encode($new_user)); } } else { die(json_encode(array("status", "parameter_required"))); }
<?php $page_title = 'Barangay System'; $stylesheet_link = 'style'; require 'path.php'; init_cobalt(); require 'header1.php'; require 'components/get_listview_referrer.php'; $username = $_SESSION['user']; require_once 'subclasses/citizen.php'; $dbh_citizen = new citizen(); $citizen = $dbh_citizen->execute_query("SELECT citizen_id,birth_date,birth_place,weight,height,civil_status FROM citizen WHERE username='******'")->result; extract($citizen->fetch_assoc()); ?> <main> <div class="fold-body"> <h3 class="fold-complain-head">Mag-Request ng Barangay ID</h3> <hr class="hr"/> <p class="complain-desc">Patunayang ikaw ay isang mamamayan sa ating barangay.</p> <?php if (xsrf_guard()) { init_var($_POST['btn_cancel']); init_var($_POST['btn_submit']); require 'components/query_string_standard.php'; require 'subclasses/cedula.php'; $dbh_cedula = new cedula(); $object_name = 'dbh_cedula'; require 'components/create_form_data.php'; extract($arr_form_data);
//Generated by Cobalt, a rapid application development framework. http://cobalt.jvroig.com //Cobalt developed by JV Roig (jvroig@jvroig.com) //**************************************************************************************** require 'path.php'; init_cobalt('View citizen'); if (xsrf_guard()) { init_var($_POST['btn_cancel']); init_var($_POST['btn_submit']); if ($_POST['btn_cancel']) { log_action('Pressed cancel button'); redirect("listview_citizen.php"); } if ($_POST['btn_submit']) { log_action('Pressed submit button'); require 'subclasses/citizen.php'; $dbh_citizen = new citizen(); if ($message == "") { log_action('Exported table data to CSV'); $timestamp = date('Y-m-d'); $token = generate_token(0, 'fs'); $csv_name = $token . $_SESSION['user'] . '_citizen_' . $timestamp . '.csv'; $filename = TMP_DIRECTORY . '/' . $csv_name; $csv_contents = $dbh_citizen->export_to_csv(); $csv_file = fopen($filename, "wb"); fwrite($csv_file, $csv_contents); fclose($csv_file); chmod($filename, 0755); $csv_name = urlencode($csv_name); $message = 'CSV file successfully generated: <a href="/' . BASE_DIRECTORY . '/download_generic.php?filename=' . $csv_name . '">Download the CSV file.</a>'; $message_type = 'system'; }
<?php require 'components/get_listview_referrer.php'; require 'subclasses/citizen.php'; $dbh_citizen = new citizen(); $dbh_citizen->set_where("citizen_id='" . quote_smart($citizen_id) . "'"); if ($result = $dbh_citizen->make_query()->result) { $data = $result->fetch_assoc(); extract($data); $data = explode('-', $birth_date); if (count($data) == 3) { $birth_date_year = $data[0]; $birth_date_month = $data[1]; $birth_date_day = $data[2]; } $data = explode('-', $date_registered); if (count($data) == 3) { $date_registered_year = $data[0]; $date_registered_month = $data[1]; $date_registered_day = $data[2]; } } require_once 'subclasses/validate.php'; $dbh_citizen = new validate(); $dbh_citizen->set_fields('proof_of_id, proof_of_address, status'); $dbh_citizen->set_where("citizen_id='" . quote_smart($citizen_id) . "'"); if ($result = $dbh_citizen->make_query()->result) { $num_validate = $dbh_citizen->num_rows; for ($a = 0; $a < $num_validate; $a++) { $data = $result->fetch_row(); $cf_validate_proof_of_id[$a] = $data[0];
require 'path.php'; init_cobalt('Delete citizen'); if (isset($_GET['citizen_id'])) { $citizen_id = urldecode($_GET['citizen_id']); require_once 'form_data_citizen.php'; } if (xsrf_guard()) { init_var($_POST['btn_cancel']); init_var($_POST['btn_delete']); require 'components/query_string_standard.php'; if ($_POST['btn_cancel']) { log_action('Pressed cancel button'); redirect("listview_citizen.php?{$query_string}"); } elseif ($_POST['btn_delete']) { log_action('Pressed delete button'); require_once 'subclasses/citizen.php'; $dbh_citizen = new citizen(); $object_name = 'dbh_citizen'; require 'components/create_form_data.php'; $dbh_citizen->delete($arr_form_data); redirect("listview_citizen.php?{$query_string}"); } } require 'subclasses/citizen_html.php'; $html = new citizen_html(); $html->draw_header('Delete Citizen', $message, $message_type); $html->draw_listview_referrer_info($filter_field_used, $filter_used, $page_from, $filter_sort_asc, $filter_sort_desc); $html->draw_hidden('citizen_id'); $html->detail_view = TRUE; $html->draw_controls('delete'); $html->draw_footer();