49 lines
No EOL
3.1 KiB
PHP
49 lines
No EOL
3.1 KiB
PHP
<?php
|
|
$kw_aktuell = (int)date('W');
|
|
$jahr = (int)date('Y');
|
|
require('lib/config.php');
|
|
require('lib/mysql.class.php');
|
|
$GLOBALS['mysql'] = new mysql(CONFIG_MYSQL_HOST,CONFIG_MYSQL_USER,CONFIG_MYSQL_PW,CONFIG_MYSQL_DB);
|
|
mysqli_set_charset($mysql, 'utf8');
|
|
|
|
header("Content-Type: text/html; charset=utf-8");
|
|
//-----------------------------------------------------------
|
|
// delete alle einträge für ma = x
|
|
$ma = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter ORDER BY id");
|
|
while($row = $ma->fetch_assoc()) {
|
|
// alles löschen
|
|
$mx=$GLOBALS['mysql']->summe("SELECT * FROM ma_ttyp WHERE maid='".$row['id']."'");
|
|
if ($mx!=0) { $GLOBALS['mysql']->update("delete * FROM ma_ttyp WHERE maid='".$row['id']."'"); }
|
|
|
|
if ($row['paket']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',1)"); }
|
|
if ($row['gh']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',3)"); }
|
|
if ($row['lvz']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',4)"); }
|
|
if ($row['pin']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',5)"); }
|
|
if ($row['post']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',6)"); }
|
|
if ($row['rs']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',7)"); }
|
|
if ($row['saso']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',8)"); }
|
|
if ($row['mp']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',10)"); }
|
|
if ($row['werb']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',11)"); }
|
|
if ($row['mb']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',12)"); }
|
|
if ($row['tip']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',13)"); }
|
|
if ($row['werb']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',14)"); }
|
|
if ($row['faz']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',15)"); }
|
|
if ($row['pleer']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',16)"); }
|
|
if ($row['lvzz']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',17)"); }
|
|
if ($row['sasoz']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',18)"); }
|
|
if ($row['saso']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',19)"); }
|
|
if ($row['sonstige']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',20)"); }
|
|
if ($row['sonstige']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',99)"); }
|
|
|
|
echo 'Mitarbeiter: '.$row['name'].'</br>';
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
echo "<pre>"; print_r($output); echo "</pre>";
|
|
//-----------------------------------------------------------
|
|
|
|
|
|
?>
|