function login($login, $pass)
{
global $messa;
$login = uppercase($login);
if (strlen($login) == 0 or strlen($pass) == 0) {
$this->user_erro = -3;
$this->user_msg = 'login_required';
return -3;
} else {
$login = troca($login, "'", "´");
$pass = troca($pass, "'", "´");
$sql = "select * from " . $this->usuario_tabela;
$sql .= " where " . $this->usuario_tabela_email . " = '" . LowerCase($login) . "' ";
$resrlt = db_query($sql);
if ($result = db_read($resrlt)) {
$user_senha = trim($result[$this->usuario_tabela_pass]);
if ($result['senha_md5'] == 1) {
$pass = md5($pass);
}
if ($user_senha == $pass) {
$this->user_erro = 1;
$this->user_msg = '';
$this->user_login = trim($result[$this->usuario_tabela_login]);
$this->user_nome = trim($result[$this->usuario_tabela_nome]);
$this->user_nivel = trim($result[$this->usuario_tabela_nivel]);
$this->user_id = trim($result[$this->usuario_tabela_id]);
$this->user_codigo = trim($result['us_codigo']);
$this->user_perfil = trim($result['us_perfil']);
$this->LiberarUsuario();
} else {
$this->user_erro = -2;
$this->user_msg = 'password_incorrect';
}
} else {
$this->user_erro = -1;
$this->user_msg = 'login_invalid';
}
}
if ($this->user_erro == 1) {
$this->LiberarUsuario();
return True;
} else {
return False;
}
}
* @copyright © Pan American Health Organization, 2013. All rights reserved.
* @access public
* @version v0.11.29
* @package index
* @subpackage ged
*/
$include = '../';
require "db.php";
require '_class/_class_message.php';
/* Mensagens */
$tabela = 'ged_upload';
$link_msg = '../messages/msg_' . $tabela . '.php';
if (file_exists($link_msg)) {
require $link_msg;
}
$id = $dd[0];
$secu = uppercase($secu);
$chk1 = checkpost($id . $secu);
$secu = '';
$chk2 = checkpost($id);
$secu = $dd[91];
$chk1 = checkpost($id . $secu);
if ($dd[90] == $chk1 or $dd[90] == $chk2) {
require "_ged_config.php";
if (strlen($dd[50]) > 0) {
$ged->tabela = $dd[50];
}
echo $ged->download($id);
} else {
echo msg('erro_post');
}
function frame3()
{
global $islinux, $cmd_arg, $chmod_arg, $zip_dir, $fm_current_root, $cookie_cache_time;
global $dir_dest, $current_dir, $dir_before;
global $selected_file_list, $selected_dir_list, $old_name, $new_name;
global $action, $or_by, $order_dir_list_by;
if (!isset($order_dir_list_by)) {
$order_dir_list_by = "1A";
setcookie("order_dir_list_by", $order_dir_list_by, time() + $cookie_cache_time, "/");
} elseif (strlen($or_by)) {
$order_dir_list_by = $or_by;
setcookie("order_dir_list_by", $or_by, time() + $cookie_cache_time, "/");
}
html_header();
echo "<body>\n";
if ($action) {
switch ($action) {
case 1:
// create dir
if (strlen($cmd_arg)) {
$cmd_arg = format_path($current_dir . $cmd_arg);
if (!file_exists($cmd_arg)) {
@mkdir($cmd_arg, 0755);
@chmod($cmd_arg, 0755);
reloadframe("parent", 2, "&ec_dir=" . $cmd_arg);
} else {
alert(et('FileDirExists') . ".");
}
}
break;
case 2:
// create arq
if (strlen($cmd_arg)) {
$cmd_arg = $current_dir . $cmd_arg;
if (!file_exists($cmd_arg)) {
if ($fh = @fopen($cmd_arg, "w")) {
@fclose($fh);
}
@chmod($cmd_arg, 0644);
} else {
alert(et('FileDirExists') . ".");
}
}
break;
case 3:
// rename arq ou dir
if (strlen($old_name) && strlen($new_name)) {
rename($current_dir . $old_name, $current_dir . $new_name);
if (is_dir($current_dir . $new_name)) {
reloadframe("parent", 2);
}
}
break;
case 4:
// delete sel
if (strstr($current_dir, $fm_current_root)) {
if (strlen($selected_file_list)) {
$selected_file_list = explode("<|*|>", $selected_file_list);
if (count($selected_file_list)) {
for ($x = 0; $x < count($selected_file_list); $x++) {
$selected_file_list[$x] = trim($selected_file_list[$x]);
if (strlen($selected_file_list[$x])) {
total_delete($current_dir . $selected_file_list[$x], $dir_dest . $selected_file_list[$x]);
}
}
}
}
if (strlen($selected_dir_list)) {
$selected_dir_list = explode("<|*|>", $selected_dir_list);
if (count($selected_dir_list)) {
for ($x = 0; $x < count($selected_dir_list); $x++) {
$selected_dir_list[$x] = trim($selected_dir_list[$x]);
if (strlen($selected_dir_list[$x])) {
total_delete($current_dir . $selected_dir_list[$x], $dir_dest . $selected_dir_list[$x]);
}
}
reloadframe("parent", 2);
}
}
}
break;
case 5:
// copy sel
if (strlen($dir_dest)) {
if (uppercase($dir_dest) != uppercase($current_dir)) {
if (strlen($selected_file_list)) {
$selected_file_list = explode("<|*|>", $selected_file_list);
if (count($selected_file_list)) {
for ($x = 0; $x < count($selected_file_list); $x++) {
$selected_file_list[$x] = trim($selected_file_list[$x]);
if (strlen($selected_file_list[$x])) {
total_copy($current_dir . $selected_file_list[$x], $dir_dest . $selected_file_list[$x]);
}
}
}
}
if (strlen($selected_dir_list)) {
$selected_dir_list = explode("<|*|>", $selected_dir_list);
if (count($selected_dir_list)) {
for ($x = 0; $x < count($selected_dir_list); $x++) {
$selected_dir_list[$x] = trim($selected_dir_list[$x]);
if (strlen($selected_dir_list[$x])) {
total_copy($current_dir . $selected_dir_list[$x], $dir_dest . $selected_dir_list[$x]);
}
}
reloadframe("parent", 2);
}
}
$current_dir = $dir_dest;
}
}
break;
case 6:
// move sel
if (strlen($dir_dest)) {
if (uppercase($dir_dest) != uppercase($current_dir)) {
if (strlen($selected_file_list)) {
$selected_file_list = explode("<|*|>", $selected_file_list);
if (count($selected_file_list)) {
for ($x = 0; $x < count($selected_file_list); $x++) {
$selected_file_list[$x] = trim($selected_file_list[$x]);
if (strlen($selected_file_list[$x])) {
total_move($current_dir . $selected_file_list[$x], $dir_dest . $selected_file_list[$x]);
}
}
}
}
if (strlen($selected_dir_list)) {
$selected_dir_list = explode("<|*|>", $selected_dir_list);
if (count($selected_dir_list)) {
for ($x = 0; $x < count($selected_dir_list); $x++) {
$selected_dir_list[$x] = trim($selected_dir_list[$x]);
if (strlen($selected_dir_list[$x])) {
total_move($current_dir . $selected_dir_list[$x], $dir_dest . $selected_dir_list[$x]);
}
}
reloadframe("parent", 2);
}
}
$current_dir = $dir_dest;
}
}
break;
case 71:
// compress sel
if (strlen($cmd_arg)) {
ignore_user_abort(true);
ini_set("display_errors", 0);
ini_set("max_execution_time", 0);
$zipfile = false;
if (strstr($cmd_arg, ".tar")) {
$zipfile = new tar_file($cmd_arg);
} elseif (strstr($cmd_arg, ".zip")) {
$zipfile = new zip_file($cmd_arg);
} elseif (strstr($cmd_arg, ".bzip")) {
$zipfile = new bzip_file($cmd_arg);
} elseif (strstr($cmd_arg, ".gzip")) {
$zipfile = new gzip_file($cmd_arg);
}
if ($zipfile) {
$zipfile->set_options(array('basedir' => $current_dir, 'overwrite' => 1, 'level' => 3));
if (strlen($selected_file_list)) {
$selected_file_list = explode("<|*|>", $selected_file_list);
if (count($selected_file_list)) {
for ($x = 0; $x < count($selected_file_list); $x++) {
$selected_file_list[$x] = trim($selected_file_list[$x]);
if (strlen($selected_file_list[$x])) {
$zipfile->add_files($selected_file_list[$x]);
}
}
}
}
if (strlen($selected_dir_list)) {
$selected_dir_list = explode("<|*|>", $selected_dir_list);
if (count($selected_dir_list)) {
for ($x = 0; $x < count($selected_dir_list); $x++) {
$selected_dir_list[$x] = trim($selected_dir_list[$x]);
if (strlen($selected_dir_list[$x])) {
$zipfile->add_files($selected_dir_list[$x]);
}
}
}
}
$zipfile->create_archive();
}
unset($zipfile);
}
break;
case 72:
// decompress arq
if (strlen($cmd_arg)) {
if (file_exists($current_dir . $cmd_arg)) {
$zipfile = false;
if (strstr($cmd_arg, ".zip")) {
zip_extract();
} elseif (strstr($cmd_arg, ".bzip") || strstr($cmd_arg, ".bz2") || strstr($cmd_arg, ".tbz2") || strstr($cmd_arg, ".bz") || strstr($cmd_arg, ".tbz")) {
$zipfile = new bzip_file($cmd_arg);
} elseif (strstr($cmd_arg, ".gzip") || strstr($cmd_arg, ".gz") || strstr($cmd_arg, ".tgz")) {
$zipfile = new gzip_file($cmd_arg);
} elseif (strstr($cmd_arg, ".tar")) {
$zipfile = new tar_file($cmd_arg);
}
if ($zipfile) {
$zipfile->set_options(array('basedir' => $current_dir, 'overwrite' => 1));
$zipfile->extract_files();
}
unset($zipfile);
reloadframe("parent", 2);
}
}
break;
case 8:
// delete arq/dir
if (strlen($cmd_arg)) {
if (file_exists($current_dir . $cmd_arg)) {
total_delete($current_dir . $cmd_arg);
}
if (is_dir($current_dir . $cmd_arg)) {
reloadframe("parent", 2);
}
}
break;
case 9:
// CHMOD
if (strlen($chmod_arg) == 4 && strlen($current_dir)) {
if ($chmod_arg[0] == "1") {
$chmod_arg = "0" . $chmod_arg;
} else {
$chmod_arg = "0" . substr($chmod_arg, strlen($chmod_arg) - 3);
}
$new_mod = octdec($chmod_arg);
if (strlen($selected_file_list)) {
$selected_file_list = explode("<|*|>", $selected_file_list);
if (count($selected_file_list)) {
for ($x = 0; $x < count($selected_file_list); $x++) {
$selected_file_list[$x] = trim($selected_file_list[$x]);
if (strlen($selected_file_list[$x])) {
@chmod($current_dir . $selected_file_list[$x], $new_mod);
}
}
}
}
if (strlen($selected_dir_list)) {
$selected_dir_list = explode("<|*|>", $selected_dir_list);
if (count($selected_dir_list)) {
for ($x = 0; $x < count($selected_dir_list); $x++) {
$selected_dir_list[$x] = trim($selected_dir_list[$x]);
if (strlen($selected_dir_list[$x])) {
@chmod($current_dir . $selected_dir_list[$x], $new_mod);
}
}
}
}
}
break;
}
if ($action != 10) {
dir_list_form();
}
} else {
dir_list_form();
}
echo "</body>\n</html>";
}
if (count($filterArray) != 0) {
ksort($filterArray);
foreach ($filterArray as $type => $value) {
$sel = false;
# check for filter querystring
if (isset($_GET['type']) && $_GET['type'] == $type) {
$sel = true;
}
if (isset($_GET['type']) && $_GET['type'] == 'images' && $type == 'image') {
$sel = true;
}
// alias for image (images)
if (count($filterArray) == 1 && isset($filterArray['image'])) {
$sel = true;
}
echo '<option value="' . $type . '" ' . ($sel ? 'selected' : '') . '>' . i18n_r('FTYPE_' . uppercase($type)) . '</option>';
}
}
}
echo '</select>';
exec_action(get_filename_id() . '-edit-nav');
echo "</div>";
exec_action(get_filename_id() . '-body');
$pathParts = explode("/", $subPath);
$urlPath = null;
// preserve querystring, but remove path
$root = 'upload.php?' . merge_queryString(array('path' => null));
echo '<div class="h5 clearfix"><div class="crumbs">/ <a href="' . $root . '">' . i18n_r('FILES') . '</a> / ';
foreach ($pathParts as $pathPart) {
if ($pathPart != '') {
$urlPath .= $pathPart . '/';
<?php
$tabs = explode(',', getDef('GSTABS'));
// $tabs = array_keys($sidemenudefinition); // debug all
$current = get_filename_id();
// if current tab is not in GSTABS, then set its parent tab as current
if (!in_array($current, $tabs)) {
if (isset($sidemenudefinition[$current]) && !empty($sidemenudefinition[$current])) {
$current = $sidemenudefinition[$current];
}
}
if ($tabs) {
foreach ($tabs as $tab) {
if (empty($tab)) {
continue;
}
$tabtitle = i18n_r('TAB_' . uppercase($tab));
$class = $tab == $current ? ' current' : '';
echo '<li id="nav_' . $tab . '" ><a class="' . $tab . $class . '" href="' . $tab . '.php" accesskey="' . find_accesskey($tabtitle) . '" >' . $tabtitle . '</a></li>';
}
}
exec_action('nav-tab');
// @hook nav-tab backend after navigation tab list html output
?>
<li id="nav_loaderimg" ><img class="toggle" id="loader" src="template/images/ajax.gif" alt="" /></li>
<li class="rightnav" ><a class="settings first" href="settings.php" accesskey="<?php
echo find_accesskey(i18n_r('TAB_SETTINGS'));
?>
" ><?php
i18n('TAB_SETTINGS');
<html>
<?php
if (isset($_GET['sentence'])) {
$string = $_GET['sentence'];
$result = uppercase($string);
echo $result;
}
function uppercase($string)
{
$length = strlen($string);
$up = "";
for ($i = 0; $i < $length; $i++) {
if (ord($string[$i]) >= 97 && ord($string[$i]) <= 122) {
$str = chr(ord($string[$i]) - ord('a') + ord('A'));
} else {
$str = $string[$i];
}
$up .= $str;
}
return $up;
}
?>
<body>
<form action = "uppercasefunction.php" method="get">
Given string:<input type="text" name="sentence"/>
<br>
<button type="submit">click here</button>
</form>
</body>
echo $dc_date;
?>
</i> at <i><?php
echo $dc_time;
?>
</i> and after the Poll, these should be returned to collecting centre at <i><?php
echo $rcvenue;
?>
</i>.</td>
</tr>
<tr>
<td class='spacer' colspan='3'> </td>
</tr>
<tr>
<td colspan='2' valign='middle' align='left'>Place : <?php
print uppercase($_SESSION['dist_name']);
?>
<br />
Date : <?php
print date('d/m/Y');
?>
</td>
<td align='center' valign='top'>Signature<br /><img src=<?php
print "../images/deo/{$_SESSION['signature']}";
?>
alt='' height='50px' width='100px' /><br />
(__________________)<br />District Election Officer<br /><?php
print wordcase($_SESSION['dist_name']);
?>
District</td>
</tr>
/**
* get editor attributes for textareas
* If func name not provided , we will attempt to get a function name from 'GS'.uppercase($collectionid).'ATTRIB'
* eg. GSSNIPPETSATTRIB which it will execute and use for inserting into the textarea
* @param str $collectionid id for this kind of editor
* @param string $class extra classes
* @param str $funcname function name to call to get attributes
* @return str html fragment
*/
function getEditorAttribCallout($collectionid, $class = '', $funcname = null)
{
if (!$funcname) {
$call = getDef('GS' . uppercase($collectionid) . 'ATTRIB');
} else {
$call = $funcname;
}
if (function_exists($call)) {
return $call($class);
}
}
$postnaam = "";
$postbeschrijving = "";
$postcat = "";
// post is gedaan
if (isset($_POST["Toevoegen"]) || isset($_POST["Terug"])) {
if (!isset($_POST["Naam"]) || $_POST["Naam"] == "" || !is_numeric($_POST["categorie"])) {
// check naam is leeg
$Naamerror = "Er moet een naam worden ingevuld.";
} else {
// check naam al bestaad
$invoerDatabase[] = uppercase($_POST["Naam"]);
$uitvoerDatabase = query("SELECT Subcategorie_naam FROM subcategorie WHERE Subcategorie_naam = ?", $invoerDatabase);
if (count($uitvoerDatabase) === 0) {
// subcat bestaat nog niet dus invoeren
$toevoegenSubcategorie[] = uppercase($_POST["Naam"]);
$toevoegenSubcategorie[] = uppercase($_POST["Beschrijving"]);
$toevoegenSubcategorie[] = $_POST["categorie"];
query("INSERT INTO subcategorie (Subcategorie_naam, Beschrijving, CategorieID) VALUES (?, ?, ?)", $toevoegenSubcategorie);
$saved = true;
} else {
// bestaat al
$errorMessage = "Toevoegen subcategorie is mislukt, subcategorie bestaat al.";
}
}
$postnaam = $_POST["Naam"];
$postbeschrijving = $_POST["Beschrijving"];
$postcat = $_POST["categorie"];
}
// terug naar overzicht
if ($saved && isset($_POST["Terug"])) {
header("location:subcategorieList.php?x=1");
/**
* Snippet for displaying node default content options
*
* @param Node $node
* @return string
*/
public function treeNodeOptions(Node $node)
{
return $this->nodeOptions($node, '<div class="dropdown__info navigation-module__info" style="background-color:' . $node->getNodeType()->color . ';">' . uppercase($node->getNodeType()->label) . '</div>', false);
}
<body oncontextmenu="return false;" onload="javascript: bind_all();">
<div width="100%" align="center">
<table cellpadding="2" cellspacing="0" border="0" width="100%">
<tr>
<td align="center"><table width="1000px" class="table_blue">
<tr><td align="center"><div width="50%" class="h2"><?php
print isset($environment) ? $environment : "";
?>
</div></td>
</tr>
<tr><td align="center"><?php
print uppercase($district);
?>
DISTRICT</td></tr>
<tr><td align="center"><?php
echo uppercase($subdiv_name) . " SUBDIVISION";
?>
</td></tr>
<tr><td align="center">EMPLOYEE DETAILS ENTRY</td></tr>
<tr><td align="center"><form method="post" name="form1" id="form1" enctype="multipart/form-data">
<table width="95%" class="form" cellpadding="0">
<tr>
<td align="center" colspan="4"><img src="images/blank.gif" alt="" height="1px" /></td>
</tr>
<tr>
<td height="16px" colspan="4" align="center"><?php
print isset($msg) ? $msg : "";
?>
<span id="msg" class="error"></span></td>
</tr>
<tr>
/**
* Snippet for generating navigation menu openings
*
* @param string $icon
* @param string $title
* @return string
*/
public function navigationModuleOpen($icon, $title)
{
return sprintf('<li class="navigation-module has-dropdown" data-hover="true">
<i class="navigation-module__icon dropdown-icon %s"></i>
<div class="dropdown navigation-module__dropdown">
<div class="dropdown__info navigation-module__info">%s</div>
<ul class="dropdown-sub navigation-module-sub">', $icon, uppercase(trans($title)));
}
// update schilderij
if (isset($_POST["knop"])) {
$correct = true;
$schilderij = array();
$schilderijUpdate = array();
// validate inputs
if (!isset($_POST["titel"]) || trim($_POST["titel"]) == "") {
$titelError = "Titel is verplicht";
$correct = false;
}
$schilderij["Titel"] = $_POST["titel"];
$schilderijUpdate[] = uppercase($_POST["titel"]);
$schilderij["OpWebsite"] = $_POST["OpWebsite"];
$schilderijUpdate[] = $_POST["OpWebsite"] ? 1 : 0;
$schilderij["Beschrijving"] = $_POST["beschrijving"];
$schilderijUpdate[] = uppercase($_POST["beschrijving"]);
$schilderij["lijst"] = isset($_POST["lijst"]);
$schilderijUpdate[] = $schilderij["lijst"] ? 1 : 0;
$schilderij["passepartout"] = isset($_POST["passepartout"]);
$schilderijUpdate[] = $schilderij["passepartout"] ? 1 : 0;
$schilderij["isStaand"] = $_POST["isStaand"] == "true";
$schilderijUpdate[] = $schilderij["isStaand"] ? 1 : 0;
if (!is_numeric($_POST["jaar"]) && isset($_POST["jaar"]) && trim($_POST["jaar"]) != "") {
$jaarError = "Jaar is geen getal";
$correct = false;
}
$schilderij["Jaar"] = $_POST["jaar"];
$schilderijUpdate[] = $_POST["jaar"] == "" ? null : $_POST["jaar"];
if (!is_numeric($_POST["prijs"]) && isset($_POST["prijs"]) && trim($_POST["prijs"]) != "") {
$jaarError = "Prijs is geen getal";
$correct = false;
$correct = false;
}
if ($commentaar == "") {
$commentaarleeg = "Commentaar is verplicht";
$correct = false;
}
if ($correct) {
$naamklant = str_replace("<", "<", $_POST["naam"]);
$naamklant = str_replace(">", ">", $naamklant);
$naamklant = uppercase($naamklant);
$email = str_replace("<", "<", $_POST["email"]);
$email = str_replace(">", ">", $email);
$email = uppercase($naamklant);
$commentaar = str_replace("<", "<", $_POST["commentaar"]);
$commentaar = str_replace(">", ">", $commentaar);
$commentaar = uppercase($commentaar);
$input = array($naamklant, $email, $commentaar, $_GET["id"]);
query("insert into commentaar (Naam_klant, Email_klant, Opmerking, Schilderij_ID) VALUES (?, ?, ?, ?)", $input);
//mailen van het commentaar
$to = query("SELECT email FROM schilder limit 0,1", NULL);
$to = $to[0]['email'];
$subject = "Commentaar op " . $schilderij['titel'];
$message = "Naam afzender: " . $naamklant . "\nEmail-adres afzender: " . $email . "\nCommentaar op " . $schilderij['titel'] . ":\n " . $commentaar;
$header = "From:commentaar@hofvanellen.nl \r\n";
mail($to, $subject, $message, $header);
?>
<script>
alert("Commentaar is toegevoegd");
</script>
<?php
}
</td>
</tr>
<tr>
<td>
Alle velden met een ster zijn verplicht
</td>
</tr>
</table>
</form>
<?php
// verwerken van formulier gegevens en naar database schrijven
if (isset($_POST["knopje"])) {
if (isset($_POST["Subcategorie_Naam"]) && $_POST["Subcategorie_Naam"] !== "" && is_numeric($_POST["categorie"])) {
$id = $_GET["id"];
$invoerDatabase2 = [uppercase($_POST["Subcategorie_Naam"]), uppercase($_POST["BEschrijving"]), $_POST["categorie"], $_GET["id"]];
query("UPDATE subcategorie SET Subcategorie_naam = ?, Beschrijving = ?, CategorieID = ? WHERE SubcategorieID = ?", $invoerDatabase2);
header('location:subcategorieList.php#Wijzigingen zijn opgeslagen');
exit;
}
}
?>
<!-- script voor pop-up verwijderen -->
<script>
document.getElementById("verwijderen").onclick = function () {
if (confirm("Weet u zeker dat u deze subcategorie wilt verwijderen?")) {
window.location = "deleteSubcategorie.php?id=<?php
echo $id;
?>
";
$saved = false;
$toevoegenMateriaal = [];
$doorgaan_naam = false;
$invoerDatabase = [];
// post is gedaan
if (isset($_POST["Toevoegen"])) {
if (!isset($_POST["Naam"]) || $_POST["Naam"] == "") {
$Naamerror = "Er moet een naam worden ingevuld.";
} else {
// check of materiaal al bestaat indb
$invoerDatabase[] = uppercase($_POST["Naam"]);
$uitvoerDatabase = query("SELECT Materiaal_soort FROM materiaal WHERE Materiaal_soort = ?", $invoerDatabase);
if (count($uitvoerDatabase) === 0) {
// materiaal bestaat nog niet
$toevoegenMateriaal[] = uppercase($_POST["Naam"]);
$toevoegenMateriaal[] = uppercase($_POST["Beschrijving"]);
// add materiaal
query("INSERT INTO materiaal (Materiaal_soort, Beschrijving) VALUES (?, ?)", $toevoegenMateriaal);
$saved = true;
} else {
// bestaat al
$errorMessage = "Toevoegen materiaal is mislukt, materiaal bestaat al.";
}
}
}
// terug naar overzicht
if ($saved && isset($_POST["Terug"])) {
header("location:materiaalList.php?x=1");
exit;
// op pagina blijven
} elseif ($saved && isset($_POST["Toevoegen"])) {
$correct = true;
$schilderij = array();
//zet waardes voor inputs
$schilderInsert = array();
// waardes voor query params
// check titel
if (!isset($_POST["titel"]) || trim($_POST["titel"]) == "") {
$titelError = "Titel is verplicht";
$correct = false;
}
$schilderij["Titel"] = $_POST["titel"];
$schilderInsert[] = uppercase($_POST["titel"]);
$schilderij["OpWebsite"] = $_POST["OpWebsite"];
$schilderInsert[] = $_POST["OpWebsite"] ? 1 : 0;
$schilderij["Beschrijving"] = $_POST["beschrijving"];
$schilderInsert[] = uppercase($_POST["beschrijving"]);
$schilderij["lijst"] = isset($_POST["lijst"]);
$schilderInsert[] = $schilderij["lijst"] ? 1 : 0;
$schilderij["passepartout"] = isset($_POST["passepartout"]);
$schilderInsert[] = $schilderij["passepartout"] ? 1 : 0;
$schilderij["isStaand"] = $_POST["isStaand"] == "true";
$schilderInsert[] = $schilderij["isStaand"] ? 1 : 0;
// check jaar
if (!is_numeric($_POST["jaar"]) && isset($_POST["jaar"]) && trim($_POST["jaar"]) != "") {
$jaarError = "Jaar is geen getal";
$correct = false;
}
$schilderij["Jaar"] = $_POST["jaar"];
$schilderInsert[] = $_POST["jaar"];
// check prijs
if (!is_numeric($_POST["prijs"]) && isset($_POST["prijs"]) && trim($_POST["prijs"]) != "") {
/**
* Snippet for displaying header action opening
*
* @param string $text
* @param string $class
* @param bool $secondary
* @return string
*/
public function headerActionOpen($text, $class = "header__action--left", $secondary = false)
{
return sprintf('<div class="header__action %s %s">
<div class="header__action-header">%s</div>
<div class="header__action-options">', $class, $secondary ? 'header__action--secondary' : '', uppercase(trans($text)));
}
mysqli_close($link);
} else {
$msg = "<div class='alert-error'>Selected persons are not available for training</div>";
}
}
?>
<body>
<div width="100%" align="center">
<table cellpadding="2" cellspacing="0" border="0" width="100%">
<tr><td align="center"><table width="1000px" class="table_blue">
<tr><td align="center"><div width="50%" class="h2"><?php
print isset($environment) ? $environment : "";
?>
</div></td></tr>
<tr><td align="center"><?php
print uppercase($district);
?>
DISTRICT</td></tr>
<tr>
<td align="center">FIRST APPOINTMENT LETTER ISSUE</td></tr>
<tr><td align="center"><form method="post" name="form1" id="form1" >
<table width="70%" class="form" cellpadding="0">
<tr><td height="18px" colspan="2" align="center"><?php
print isset($msg) ? $msg : "";
?>
<span id="msg" class="error"></span></td></tr>
<tr><td colspan="2" style="height:10px" align="center"> </td></tr>
<tr><td align="center"><img src="images/blank.gif" alt="" height="5px" /></td><td align="right"><strong>»</strong> <a href="first-appointment-letter3-print.php" class="k-button">Print Letter</a></td></tr>
<tr>
<td align="left"><span class="error">*</span>Subdivision</td>
<td align="left"><select name="Subdivision" id="Subdivision" style="width:240px;">
function upper()
{
return uppercase($this->string);
}
stm_aix("p0i5","p0i0",[0,"Signout","","",-1,-1,0,"signout.php","_self"],80,25);
stm_ep();
stm_em();
</script>
<span class="form">Hi, <?php
print $_SESSION['user'];
?>
</span>
<?php
$user_cat = isset($_SESSION['user_cat']) ? $_SESSION['user_cat'] : '';
$sql_env = "select * from environment where dist_cd='{$dist_cd}'";
$rs_env = execSelect($sql_env);
if (rowCount($rs_env) > 0) {
$row_env = getRows($rs_env);
$environment = uppercase($row_env['environment']);
$_SESSION['environment'] = $environment;
$distnm_cap = $row_env['distnm_cap'];
$_SESSION['distnm_cap'] = $distnm_cap;
$apt1_orderno = $row_env['apt1_orderno'];
$_SESSION['apt1_orderno'] = $apt1_orderno;
$apt1_date = new DateTime($row_env['apt1_date']);
$_SESSION['apt1_date'] = $apt1_date->format('d/m/Y');
$apt2_orderno = $row_env['apt2_orderno'];
$_SESSION['apt2_orderno'] = $apt2_orderno;
$apt2_date = new DateTime($row_env['apt2_date']);
$_SESSION['apt2_date'] = $apt2_date->format('d/m/Y');
$signature = $row_env['signature'];
$_SESSION['signature'] = $signature;
} else {
if ($user_cat != "Administrator") {
$id = $_GET["id"];
$invoerDatabase = [$_GET["id"]];
$uitvoerDatabase = query("SELECT * FROM materiaal WHERE MateriaalID = ?", $invoerDatabase);
// check of schiderij is gekoppeld voor verwijderen
$schilderijResult = query("SELECT COUNT(*) c FROM schilderij WHERE MateriaalID = ?", $invoerDatabase);
$verwijderPossible = $schilderijResult[0]["c"] == 0;
}
if (!isset($uitvoerDatabase) || count($uitvoerDatabase) == 0) {
header("location:materiaalList.php");
exit;
}
// verwerken gegevens formulier en naar database schrijven
if (isset($_POST["knopje"])) {
if (isset($_POST["Materiaal_Soort"]) && $_POST["Materiaal_Soort"] !== "") {
$id = $_GET["id"];
$invoerDatabase2 = [uppercase($_POST["Materiaal_Soort"]), uppercase($_POST["BEschrijving"]), $_GET["id"]];
query("UPDATE materiaal SET Materiaal_soort = ?, Beschrijving = ? WHERE MateriaalID = ?", $invoerDatabase2);
header('location:materiaalList.php#Wijzigingen zijn opgeslagen');
exit;
} else {
$Naamerror = "Er moet een soort worden ingevuld.";
}
}
?>
<!-- this form is used to retrieve the user data-->
<form action="editMateriaal.php?id=<?php
echo $id;
?>
" method="post">
<h1>Pas hier de categorienaam en/of beschrijving aan.</h1>
$training_time = $rowAppDtl['training_time'];
mysqli_stmt_bind_param($stmt, 'ssssssssssssssssssssssssssssss', $rowApp['officer_name'], $rowApp['person_desig'], $rowApp['personcd'], $rowApp['officer_desig'], $office_address, $rowApp['postoffice'], $rowApp['subdivision'], $rowApp['policestation'], $rowApp['district'], $rowApp['pin'], $rowApp['officecd'], $rowApp['poststatus'], $rowApp['mob_no'], $training_desc, $venuename, $venue_add, $training_dt, $training_time, $rowApp['forpc'], $rowApp['pcname'], $rowApp['forsubdivision'], $rowApp['epic'], $rowApp['acno'], $rowApp['partno'], $rowApp['slno'], $rowApp['bank_name'], $rowApp['branch_name'], $rowApp['bank_acc_no'], $rowApp['ifsc_code'], $token_no);
mysqli_stmt_execute($stmt);
$rowAppDtl = NULL;
}
unset($rsAppDtl);
} else {
$training_desc = '';
$venuename = '';
$venue_add = '';
$training_dt = '';
$training_time = '';
mysqli_stmt_bind_param($stmt, 'ssssssssssssssssssssssssssssss', $rowApp['officer_name'], $rowApp['person_desig'], $rowApp['personcd'], $rowApp['officer_desig'], $office_address, $rowApp['postoffice'], $rowApp['subdivision'], $rowApp['policestation'], $rowApp['district'], $rowApp['pin'], $rowApp['officecd'], $rowApp['poststatus'], $rowApp['mob_no'], $training_desc, $venuename, $venue_add, $training_dt, $training_time, $rowApp['forpc'], $rowApp['pcname'], $rowApp['forsubdivision'], $rowApp['epic'], $rowApp['acno'], $rowApp['partno'], $rowApp['slno'], $rowApp['bank_name'], $rowApp['branch_name'], $rowApp['bank_acc_no'], $rowApp['ifsc_code'], $token_no);
mysqli_stmt_execute($stmt);
}
echo "\r\n </table>\r\n</div>\r\n<hr width='750px' />\r\n<div align='center'>\r\n<table cellspacing='0' cellpadding='0' width='750'>\r\n\t<tr><td align='left'> This is a compulsory duty on your part to attend the said programme, as per the provisions of The Representation of the People Act, 1951. <br />\r\n You are directed to bring your Elector's Photo Identity Card (EPIC) or any proof of Identity affixed with your Photograph.</td></tr></table></div>\r\n<div align='center'>\r\n<table cellspacing='0' cellpadding='0' width='750'>\r\n\t<tr><td height='20px' colspan='2'> </td></tr>\r\n\t<tr><td align='right' colspan='2'>Signature </td></tr></div>\r\n<tr><td align='left'>Place: " . uppercase($distnm_cap) . "</td><td rowspan='3' align='right'><img src='../images/deo/{$_SESSION['signature']}' alt='' height='50px' width='100px' /></td></tr>\r\n<tr><td align='left'>Date: " . date('d/m/Y') . "</td></tr>\r\n<tr><td height='30px' align='right'> </td></tr>\r\n<tr><td align='right' colspan='2'>District Election Officer <br />\r\nDistrict " . wordcase($distnm_cap) . " </td></tr></table>\r\n<hr width='750px' />\r\n<table cellspacing='0' cellpadding='0' width='750px'>\r\n <tr>\r\n <td width='5%' rowspan='6' valign='top'>NB.</td>\r\n <td width='5%' valign='top'>1.</td>\r\n <td width='90%' align='left'>Please fillup form 12A (for Election Duty Certificate) if you have been deployed for poll duty within your home Parliamentary Constituency. In other cases fill up form form 12 (for Postal Ballot).</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'>2.</td>\r\n <td align='left'>Please submit duly filled in form 12/12A allong with duplicate copy of appointment letter at training venue on the first day of training.</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'>3.</td>\r\n <td align='left'>Please write particulars on the supplied blank Identity Card and also affix your colour passport size photograph on it. Please bring it at training venue for attestation.</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'>4.</td>\r\n <td align='left'>Please check your electoral data and bank details given below. For any inconsistancy please inform the authority.</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'> </td>\r\n <td align='left'>EPIC No.- {$rowApp['epic']} Assembly- {$rowApp['acno']} Part No.- {$rowApp['partno']} Sl. No.- {$rowApp['slno']} <br /> Bank- {$rowApp['bank_name']} Branch- {$rowApp['branch_name']} A/c No.- {$rowApp['bank_acc_no']} IFS Code- {$rowApp['ifsc_code']}</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'>5.</td>\r\n <td align='left'>Please bring in the filled up data sheet, as attached herewith, during the first training.</td>\r\n </tr>\r\n</table>\r\n<table width='750px' cellspacing='0' cellpadding='0'>\r\n <tr>\r\n <td>---------------------------------------------------------------------------------------------------------------------------------------------------</td>\r\n </tr>\r\n <tr>\r\n <td>Copy to DDO / Head of Office to serve the Letter and submit the service return.</td>\r\n </tr>\r\n <tr>\r\n <td>---------------------------------------------------------------------------------------------------------------------------------------------------</td>\r\n </tr>\r\n</table>\r\n<p> </p>\r\n<div align='center'>\r\n <table width='700' border='0' cellspacing='0' cellpadding='0'>\r\n <tr>\r\n <td width='70%' valign='top'>Receipt of Appointment Letter</td>\r\n <td width='30%' valign='top'>Signature of the Recepient<br />\r\n Date:</td>\r\n </tr>\r\n </table>\r\n</div>";
echo "\n<h6></h6>\n";
echo "\n<h6></h6>\n";
$rowPer = NULL;
}
unset($rsId, $num_rows);
if (!mysqli_commit($link)) {
print "Transaction commit failed\n";
exit;
}
mysqli_stmt_close($stmt);
mysqli_close($link);
//delete_temp_app_letter($usercd);
}
?>
</td></tr></table>
/**
* Snippet for generating an action button
*
* @param string $link
* @param string $icon
* @param string $text
* @param string $class
* @param string $iconSide
* @return string
*/
public function actionButton($link, $icon, $text = '', $class = 'button--emphasis', $iconSide = 'r')
{
$iconType = empty($text) ? '<i class="' . $icon . ' button__icon button__icon--action"></i>' : ($iconSide === 'r' ? uppercase($text) . ' <i class="' . $icon . ' button__icon button__icon--right"></i>' : '<i class="' . $icon . ' button__icon button__icon--left"></i> ' . uppercase($text));
return sprintf('<a href="%s" class="button %s">' . $iconType . '</a>', $link, $class);
}
$training_time = $rowAppDtl['training_time'];
mysqli_stmt_bind_param($stmt, 'ssssssssssssssssssssssssssssss', $rowApp['officer_name'], $rowApp['person_desig'], $rowApp['personcd'], $rowApp['officer_desig'], $office_address, $rowApp['postoffice'], $rowApp['subdivision'], $rowApp['policestation'], $rowApp['district'], $rowApp['pin'], $rowApp['officecd'], $rowApp['poststatus'], $rowApp['mob_no'], $training_desc, $venuename, $venue_add, $training_dt, $training_time, $rowApp['forpc'], $rowApp['pcname'], $rowApp['forsubdivision'], $rowApp['epic'], $rowApp['acno'], $rowApp['partno'], $rowApp['slno'], $rowApp['bank_name'], $rowApp['branch_name'], $rowApp['bank_acc_no'], $rowApp['ifsc_code'], $token_no);
mysqli_stmt_execute($stmt);
$rowAppDtl = NULL;
}
unset($rsAppDtl);
} else {
$training_desc = '';
$venuename = '';
$venue_add = '';
$training_dt = '';
$training_time = '';
mysqli_stmt_bind_param($stmt, 'ssssssssssssssssssssssssssssss', $rowApp['officer_name'], $rowApp['person_desig'], $rowApp['personcd'], $rowApp['officer_desig'], $office_address, $rowApp['postoffice'], $rowApp['subdivision'], $rowApp['policestation'], $rowApp['district'], $rowApp['pin'], $rowApp['officecd'], $rowApp['poststatus'], $rowApp['mob_no'], $training_desc, $venuename, $venue_add, $training_dt, $training_time, $rowApp['forpc'], $rowApp['pcname'], $rowApp['forsubdivision'], $rowApp['epic'], $rowApp['acno'], $rowApp['partno'], $rowApp['slno'], $rowApp['bank_name'], $rowApp['branch_name'], $rowApp['bank_acc_no'], $rowApp['ifsc_code'], $token_no);
mysqli_stmt_execute($stmt);
}
echo "\r\n </table>\r\n</div>\r\n<hr width='750px' />\r\n<div align='center'>\r\n<table cellspacing='0' cellpadding='0' width='750'>\r\n\t<tr><td align='left'> This is a compulsory duty on your part to attend the said programme, as per the provisions of The Representation of the People Act, 1951. <br />\r\n You are directed to bring a copy of 1st. page of your bank pass book where your account details are available and photo copy of your Elector's Photo Identity Card (EPIC).</td></tr></table></div>\r\n<div align='center'>\r\n<table cellspacing='0' cellpadding='0' width='750'>\r\n\t<tr><td height='20px' colspan='2'> </td></tr>\r\n\t<tr><td align='right' colspan='2'>Signature </td></tr></div>\r\n<tr><td align='left'>Place: " . uppercase($_SESSION['dist_name']) . "</td><td rowspan='3' align='right'><img src='../images/deo/{$_SESSION['signature']}' alt='' height='50px' width='100px' /></td></tr>\r\n<tr><td align='left'>Date: " . date('d/m/Y') . "</td></tr>\r\n<tr><td height='30px' align='right'> </td></tr>\r\n<tr><td align='right' colspan='2'>District Election Officer <br />\r\nDistrict " . wordcase($_SESSION['dist_name']) . " </td></tr></table>\r\n<hr width='750px' />\r\n<table cellspacing='0' cellpadding='0' width='750px'>\r\n <tr>\r\n <td width='5%' rowspan='6' valign='top'>NB.</td>\r\n\t<td width='5%' valign='top'>1.</td>\r\n <td>Please check A/c No, Part No., Sl.No., EPIC No., mobile no. in the prefilled Form 12 (for postal ballot)/12A (for Election Duty Certificate).</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'>2.</td>\r\n <td>Please write your address in 12/12A and sign it.</td>\r\n </tr>\r\n\r\n <tr>\r\n <td valign='top'>3.</td>\r\n <td>Please submit duly filled in form 12/12A allong with duplicate copy of appointment letter and photo copy of voter card at training venue on the first day of training.</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'>4.</td>\r\n <td>Please write particulars on the supplied blank Identity Card and also affix your colour passport size photograph on it. Please bring it at training venue for attestation.</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'>5.</td>\r\n <td>Your electroral details, Bank details and mobile no. are given below. Please check the details and make correction in Form 12/12A and attendance sheet in case of any discripancy.</td>\r\n </tr>\r\n <tr>\r\n <td valign='top'> </td>\r\n <td>EPIC : {$rowApp['epic']} AC No. : {$rowApp['acno']} Part No. : {$rowApp['partno']} Sl. No. : {$rowApp['slno']} <br /> Bank : {$rowApp['bank_name']} Branch : {$rowApp['branch_name']} <br>IFSC : {$rowApp['ifsc_code']} Bank A/c No. : {$rowApp['bank_acc_no']} Mobile No. : {$rowApp['mob_no']}</td>\r\n </tr>\r\n </table>\r\n<table width='750px' cellspacing='0' cellpadding='0'>\r\n <tr>\r\n <td>---------------------------------------------------------------------------------------------------------------------------------------------------</td>\r\n </tr>\r\n <tr>\r\n <td>Copy to DDO / Head of Office to serve the Letter and submit the service return.</td>\r\n </tr>\r\n <tr>\r\n <td>---------------------------------------------------------------------------------------------------------------------------------------------------</td>\r\n </tr>\r\n</table>\r\n<p> </p>\r\n<div align='center'>\r\n <table width='700' border='0' cellspacing='0' cellpadding='0'>\r\n <tr>\r\n <td width='70%' valign='top'>Receipt of Appointment Letter</td>\r\n <td width='30%' valign='top'>Signature of the Recepient<br />\r\n Date:</td>\r\n </tr>\r\n </table>\r\n</div>";
echo "\n<h6></h6>\n";
echo "\n<h6></h6>\n";
$rowPer = NULL;
}
unset($rsId, $num_rows);
if (!mysqli_commit($link)) {
print "Transaction commit failed\n";
exit;
}
mysqli_stmt_close($stmt);
mysqli_close($link);
//delete_temp_app_letter($usercd);
}
?>
</td></tr></table>
<tr>
<td>
Alle velden met een ster zijn verplicht
</td>
</tr>
</table>
</form>
<?php
// verwerkern gegevens formulier en naar database schrijven
if (isset($_POST["knopje"])) {
if (isset($_POST["Categorie_Naam"]) && $_POST["Categorie_Naam"] !== "") {
// correcte invoer
$id = $_GET["id"];
$invoerDatabase2 = [uppercase($_POST["Categorie_Naam"]), uppercase($_POST["BEschrijving"]), $id];
// BEschrijving?? (zelfde als op regel 38)
query("UPDATE categorie SET Categorie_naam = ?, Beschrijving = ? WHERE CategorieID = ?", $invoerDatabase2);
header('location:categorieList.php#Wijzigingen zijn opgeslagen');
exit;
}
}
?>
<!-- script voor pop-up verwijderen -->
<script>
document.getElementById("verwijderen").onclick = function () {
if (confirm("Weet u zeker dat u deze categorie wilt verwijderen?")) {
window.location = "deleteCategorie.php?id=<?php
echo $id;
?>
/**
* log fileio operations
*
* since 3.4
* @param str $operation file operation or functionname to log
* @param mixed $status if bool evals to success and fail, else shows status as string
* @param mixed variable length args any other arguments are outputted at end
* @return mixed returns status untouched, passthrough
*/
function fileLog($operation, $status = null)
{
if (!getDef('GSDEBUGFILEIO', true)) {
return $status;
}
$args = array_slice(func_get_args(), 2);
// grab arguments past first 2 for output
if (is_bool($status)) {
$logstatus = $status === true ? uppercase(i18n_r('SUCCESS', 'SUCCESS')) : uppercase(i18n_r('FAIL', 'FAIL'));
} else {
$logstatus = (string) $status;
}
$args = convertPathArgs($args);
debugLog("• fileio: [{$logstatus}] " . uppercase($operation) . ": " . implode(" - ", $args));
return $status;
}
$emailFout = "Er moet een email worden ingevuld";
}
if (isset($doorgaan_naam) && isset($doorgaan_email)) {
if ($doorgaan_naam === true && $doorgaan_email === true) {
if (isset($_POST["Telefoon"]) && $_POST["Telefoon"] !== "") {
$telefoon1 = $_POST["Telefoon"];
} else {
$telefoon1 = NULL;
}
if (isset($_POST["Woonplaats"]) && $_POST["Woonplaats"] !== "") {
$woonplaats1 = uppercase($_POST["Woonplaats"]);
} else {
$woonplaats1 = NULL;
}
if (isset($_POST["Adres"]) && $_POST["Adres"] !== "") {
$adres1 = uppercase($_POST["Adres"]);
} else {
$adres1 = NULL;
}
if (isset($_POST["Gebdat"]) && $_POST["Gebdat"] !== "") {
$gebdat1 = $_POST["Gebdat"];
} else {
$gebdat1 = NULL;
}
$naam1 = $_POST["Naam_schilder"];
$email1 = $_POST["Email"];
$invoerDatabase = [$naam1, $email1, $telefoon1, $woonplaats1, $adres1, $gebdat1];
query("UPDATE schilder SET Naam_schilder=?, Email=?, Telefoon=?, Woonplaats=?, Adres=?, Gebdat=?", $invoerDatabase);
header('location:main.php#Wijzigingen zijn opgeslagen');
exit;
}
@extends('partials.modals.base')
<?php
$modalButtons = '<button class="button button--close">' . uppercase(trans('general.dismiss')) . '</button>';
@extends('partials.modals.base')
<?php
$modalButtons = '<button class="button button--close">' . uppercase(trans('general.dismiss')) . '</button>
<button class="button button--emphasis button--confirm">' . uppercase(trans('general.confirm')) . '</button>';
