79 lines
No EOL
4.8 KiB
PHP
79 lines
No EOL
4.8 KiB
PHP
<?php
|
|
error_reporting(E_ALL);
|
|
ini_set('display_errors',1);
|
|
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);
|
|
$GLOBALS['rasql'] = new mysql(CONFIG_RASQL_HOST,CONFIG_RASQL_USER,CONFIG_RASQL_PW,CONFIG_RASQL_DB);
|
|
header("Content-Type: text/html; charset=utf-8");
|
|
//----------------------------------------------------------------------------------------------------------
|
|
//date_default_timezone_set('Europe/London');
|
|
date_default_timezone_set('Europe/Berlin');
|
|
$jahr = (int)date('Y');
|
|
$monat = (int)date('n');
|
|
$tag = (int)date('j');
|
|
$kw = (int)date('W');
|
|
//----------------------------------------------------------------------------------------------------------
|
|
//----------------------------------------------------------------------------------------------------------
|
|
//----------------------------------------------------------------------------------------------------------
|
|
//----------------------------------------------------------------------------------------------------------
|
|
//----------------------------------------------------------------------------------------------------------
|
|
//----------------------------------------------------------------------------------------------------------
|
|
// if (date("w")==6) {
|
|
$stour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE typ=13 and kw='".$kw."' and jahr='".$jahr."'");
|
|
while($row = $stour->fetch_assoc()) {
|
|
$m_data = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
|
|
$test_data = $GLOBALS['rasql']->query_single("SELECT * FROM fahrer WHERE tour='".$row['tour']."'");
|
|
//-------------- tournummerid herausfinden
|
|
$oid = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$tid = $GLOBALS['rasql']->query_single("SELECT * FROM touren WHERE tour='".$oid['tour']."'");
|
|
echo "orginalJB: ".$oid['tour']." MPV: ".$tid['id']."</br>";
|
|
if($test_data['num_rows'] != 0) {
|
|
$GLOBALS['rasql']->insert("UPDATE fahrer SET name='".$m_data['name']."' WHERE tour='".$tid['id']."'");
|
|
$GLOBALS['rasql']->insert("UPDATE fahrer SET nummer='".$m_data['handy']."' WHERE tour='".$tid['id']."'");
|
|
echo "name: ".$m_data['name']." - Tourid: ".$tid['id'];
|
|
$GLOBALS['rasql']->insert("UPDATE tliste SET fahrer='".$m_data['name']."' WHERE tour='".$tid['id']."' and kw='".$kw."' and jahr='".$jahr."'");
|
|
$GLOBALS['rasql']->insert("UPDATE tliste SET fahrernummer='".$m_data['handy']."' WHERE tour='".$tid['id']."' and kw='".$kw."' and jahr='".$jahr."'");
|
|
|
|
} else {
|
|
$GLOBALS['rasql']->insert("INSERT INTO fahrer (name,nummer,tour)
|
|
VALUES(
|
|
'".$m_data['name']."',
|
|
'".$m_data['handy']."',
|
|
'".$tid['id']."')
|
|
");
|
|
$GLOBALS['rasql']->insert("UPDATE tliste SET fahrer='".$m_data['name']."' WHERE tour='".$tid['id']."' and kw='".$kw."' and jahr='".$jahr."'");
|
|
$GLOBALS['rasql']->insert("UPDATE tliste SET fahrernummer='".$m_data['handy']."' WHERE tour='".$tid['id']."' and kw='".$kw."' and jahr='".$jahr."'");
|
|
}
|
|
|
|
}
|
|
//----------------------------------------------------------------------------------------------------------
|
|
//----------------------------------------------------------------------------------------------------------
|
|
//----------------------------------------------------------------------------------------------------------
|
|
$stour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE typ=19 and kw='".$kw."' and jahr='".$jahr."'");
|
|
while($row = $stour->fetch_assoc()) {
|
|
$test_data = $GLOBALS['rasql']->query_single("SELECT * FROM fahrer WHERE tour='".$row['tour']."'");
|
|
if($test_data['num_rows'] != 0) {
|
|
$m_data = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
|
|
$GLOBALS['rasql']->insert("UPDATE fahrer SET name='".$m_data['name']."' WHERE tour='".$row['tour']."'");
|
|
$GLOBALS['rasql']->insert("UPDATE fahrer SET nummer='".$m_data['handy']."' WHERE tour='".$row['tour']."'");
|
|
$GLOBALS['rasql']->insert("UPDATE tliste SET fahrer='".$m_data['name']."' WHERE tour='".$row['tour']."'");
|
|
$GLOBALS['rasql']->insert("UPDATE tliste SET fahrernummer='".$m_data['handy']."' WHERE tour='".$row['tour']."'");
|
|
echo "name: ".$m_data['name']." - Tourid: ".$row['tour']."</br>";
|
|
} else {
|
|
$GLOBALS['rasql']->insert("INSERT INTO fahrer (name,nummer,tour)
|
|
VALUES(
|
|
'".$m_data['name']."',
|
|
'".$m_data['handy']."',
|
|
'".$row['tour']."')
|
|
");
|
|
$GLOBALS['rasql']->insert("UPDATE tliste SET fahrer='".$m_data['name']."' WHERE tour='".$row['tour']."'");
|
|
$GLOBALS['rasql']->insert("UPDATE tliste SET fahrernummer='".$m_data['handy']."' WHERE tour='".$row['tour']."'");
|
|
}
|
|
|
|
}
|
|
// }
|
|
//mysql_close($GLOBALS['mysql']);
|
|
//mysql_close($GLOBALS['rasql']);
|
|
echo"fertig_saso nummer copy";
|
|
?>
|