59 lines
No EOL
2.5 KiB
PHP
59 lines
No EOL
2.5 KiB
PHP
<?php
|
|
header("Content-Type: text/html; charset=utf-8");
|
|
|
|
error_reporting(E_ALL);
|
|
ini_set('display_errors', 1);
|
|
|
|
$kw_aktuell = (int)date('W');
|
|
$a_jahr = (int)date('Y');
|
|
require('lib/config.php');
|
|
session_name(CONFIG_SESSION);
|
|
session_start(); require('lib/mysql.class.php');
|
|
$GLOBALS['mysql'] = new mysql(CONFIG_MYSQL_HOST,CONFIG_MYSQL_USER,CONFIG_MYSQL_PW,CONFIG_MYSQL_DB);
|
|
// $GLOBALS['mysql']->mysql_query("SET NAMES 'utf8'");
|
|
// $GLOBALS['mysql']->mysql_query("SET CHARACTER SET 'utf8'");
|
|
date_default_timezone_set('Europe/Berlin');
|
|
//----------------------------------------------------------------------------------------------------------------
|
|
$zeitsperre=0; $kartefrei=0; $mitarbeiteraktiv=0; $aufmachen=0; $mitarbeiter=0;
|
|
if($_GET['karte']>0) {
|
|
// $GLOBALS['mysql']->insert("INSERT INTO kartenerror (karte,zeit,zeit2,user) VALUES('".$GLOBALS['mysql']->clean($_GET['karte'])."','".time()."','".date("d.m.Y H:i")."',9999)");
|
|
$m_data = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE karte='".$GLOBALS['mysql']->clean($_GET['karte'])."'");
|
|
if($m_data['num_rows'] != 0) {
|
|
$kartefrei=1; $mitarbeiter=$m_data['id'];
|
|
} else {
|
|
$m_data = 0;
|
|
$m_data = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE karte2='".$GLOBALS['mysql']->clean($_GET['karte'])."'");
|
|
if($m_data['num_rows'] != 0) { $kartefrei=1; $mitarbeiter=$m_data['id']; }
|
|
}
|
|
//----------------------------------------------------------------------------------------------------------------------------------------
|
|
if($kartefrei==1) {
|
|
if($m_data['aktiv'] != 0) {
|
|
if($m_data['zeitzugang']==0) {
|
|
$aufmachen=1;
|
|
} else {
|
|
//---------------------------- Zeitzugang einbauen !!!!!!!!!!!!!!!!!!!!!!!
|
|
$aufmachen=0;
|
|
$grund='Zeitzugangssperre';
|
|
}
|
|
} else {
|
|
$aufmachen=0;
|
|
$grund='Mitarbeiter Inaktiv';
|
|
}
|
|
} else {
|
|
$aufmachen=0;
|
|
$grund='Karte nicht registriert';
|
|
}
|
|
if($aufmachen==1) {
|
|
$GLOBALS['mysql']->insert("INSERT INTO kartenlog (karte,zeit,zeit2,user) VALUES('".$GLOBALS['mysql']->clean($_GET['karte'])."','".time()."','".date("d.m.Y H:i")."','".$m_data['id']."')");
|
|
echo "1";
|
|
} else {
|
|
$GLOBALS['mysql']->insert("INSERT INTO kartenerror (karte,zeit,zeit2,user,grund) VALUES('".$GLOBALS['mysql']->clean($_GET['karte'])."','".time()."','".date("d.m.Y H:i")."','".$mitarbeiter."','".$grund."')");
|
|
echo "0";
|
|
}
|
|
}
|
|
//------------------------------------------------------------
|
|
// echo "<pre>"; print_r($row['A']); echo "</pre>";
|
|
//------------------------------------------------------------
|
|
|
|
|
|
?>
|