From d49556b05b7223dc098939b9f04550a297ec04f4 Mon Sep 17 00:00:00 2001 From: cookie Date: Tue, 15 Nov 2005 23:13:35 +0000 Subject: es wird jetzt die PSID (penterbarf SID) an statt FormPentabarf git-svn-id: svn://svn.cccv.de/engel-system@57 29ba0400-6e00-0410-a75a-ca02368028f8 --- www-ssl/inc/funktion_xml_schudle.php | 47 +++++++++++++++++++----------------- 1 file changed, 25 insertions(+), 22 deletions(-) (limited to 'www-ssl/inc/funktion_xml_schudle.php') diff --git a/www-ssl/inc/funktion_xml_schudle.php b/www-ssl/inc/funktion_xml_schudle.php index 05727127..4fd750fd 100755 --- a/www-ssl/inc/funktion_xml_schudle.php +++ b/www-ssl/inc/funktion_xml_schudle.php @@ -11,7 +11,7 @@ function SaveSchedule() global $RoomID, $RoomName; include ("./inc/db.php"); - if( isset($_GET["SIDXML"]) && + if( isset($_GET["PSIDXML"]) && isset($_GET["DateXML"]) && isset($_GET["RIDXML"]) && isset($_GET["LenXML"]) && @@ -37,18 +37,17 @@ function SaveSchedule() $_GET["RIDXML"] = $RoomName[$_GET["RIDXML"]]; //Update OR insert ? - $SQL1 = "Select `SID` FROM `Shifts` WHERE `SID`='". $_GET["SIDXML"]. "';"; + $SQL1 = "Select `SID` FROM `Shifts` WHERE `PSID`='". $_GET["PSIDXML"]. "';"; $Erg1 = mysql_query($SQL1, $con); if( mysql_num_rows($Erg1)==0) - $SQL= "INSERT INTO `Shifts` (`SID`, `DateS`, `DateE`, `Len`, `RID`, `Man`, `FromPentabarf`, `URL`) ". - "VALUES ('". $_GET["SIDXML"]. "', ". + $SQL= "INSERT INTO `Shifts` (`PSID`, `DateS`, `DateE`, `Len`, `RID`, `Man`, `URL`) ". + "VALUES ('". $_GET["PSIDXML"]. "', ". "'". $_GET["DateXML"]. "', ". "'". $DateEnd. "', ". "'". $_GET["LenXML"]. "', ". "'". $_GET["RIDXML"]. "', ". "'". mysql_escape_string($_GET["ManXML"]). "', ". - "'Y', ". "'". $_GET["URLXML"]. "'". ");"; else @@ -58,16 +57,19 @@ function SaveSchedule() "`Len` = '". $_GET["LenXML"]. "', ". "`RID` = '". $_GET["RIDXML"]. "', ". "`Man` = '". mysql_escape_string($_GET["ManXML"]). "', ". - "`FromPentabarf`= 'Y', ". "`URL`= '". $_GET["URLXML"]. "' ". - "WHERE `SID` = '". $_GET["SIDXML"]. "' LIMIT 1;"; + "WHERE `PSID` = '". $_GET["PSIDXML"]. "' LIMIT 1;"; $Erg = mysql_query($SQL, $con); if( $Erg ) { - echo "Aenderung, am Schedule '". $_GET["SIDXML"]. "', war erfogreich
\n"; + echo "Aenderung, am Schedule '". $_GET["PSIDXML"]. "', war erfogreich
\n"; if( mysql_num_rows($Erg1)==0) { echo "-->Create Shifts:
\n"; + + //SID auslesen + $SQL1 = "Select `SID` FROM `Shifts` WHERE `PSID`='". $_GET["PSIDXML"]. "';"; + $Erg1 = mysql_query($SQL1, $con); // erstellt ein Array der Reume $sql2 = "SELECT * FROM `Room` ". @@ -83,7 +85,7 @@ function SaveSchedule() for( $i=0; $i < mysql_result($Erg2, 0, $j); $i++ ) { $SQL3 = "INSERT INTO `ShiftEntry` (`SID`, `TID`) VALUES (". - "'". $_GET["SIDXML"]. "', ". + "'". mysql_result($Erg1, 0, 0). "', ". "'". substr( mysql_field_name($Erg2, $j), 12). "');"; $Erg3 = mysql_query($SQL3, $con); @@ -100,7 +102,7 @@ function SaveSchedule() } } else - echo "Aenderung, am Schedule '". $_GET["SIDXML"]. "', war nicht erfogreich.(". + echo "Aenderung, am Schedule '". $_GET["PSIDXML"]. "', war nicht erfogreich.(". mysql_error($con). ")
[$SQL]
\n"; } else @@ -117,7 +119,7 @@ $Where = ""; //ausgabe echo "\n"; -echo "". +echo "". "\n"; echo "". "\n"; @@ -130,7 +132,7 @@ foreach($XMLmain->sub as $EventKey => $Event) echo "\n"; echo "\t\n"; - $SIDXML = substr( getXMLsubData( $Event, "UID"), 0, strpos( getXMLsubData( $Event, "UID"), "@" )); + $PSIDXML = getXMLsubData( $Event, "UID"); $DateXML = substr( getXMLsubData( $Event, "DTSTART"), 0, 4). "-". substr( getXMLsubData( $Event, "DTSTART"), 4, 2). "-". @@ -144,7 +146,7 @@ foreach($XMLmain->sub as $EventKey => $Event) if( isset($_GET["UpdateALL"])) { - $_GET["SIDXML"] = $SIDXML; + $_GET["PSIDXML"] = $PSIDXML; $_GET["DateXML"] = $DateXML; $_GET["LenXML"] = $LenXML; $_GET["RIDXML"] = $RIDXML; @@ -153,11 +155,12 @@ foreach($XMLmain->sub as $EventKey => $Event) SaveSchedule(); } - $SQL = "SELECT * FROM `Shifts` WHERE SID=$SIDXML"; + $SQL = "SELECT * FROM `Shifts` WHERE PSID='$PSIDXML'"; $Erg = mysql_query($SQL, $con); if(mysql_num_rows($Erg)>0) { $SIDDB = mysql_result($Erg, 0, "SID"); + $PSIDDB = mysql_result($Erg, 0, "PSID"); $TimeDB = mysql_result($Erg, 0, "DateS"); $LenDB = mysql_result($Erg, 0, "Len"); if( isset($RoomID[mysql_result($Erg, 0, "RID")])) @@ -169,9 +172,9 @@ foreach($XMLmain->sub as $EventKey => $Event) $URLDB = mysql_result($Erg, 0, "URL"); } else - $SIDDB = $TimeDB = $LenDB = $RIDDB = $ManDB = $URLDB = ""; + $SIDDB = $PSIDDB = $TimeDB = $LenDB = $RIDDB = $ManDB = $URLDB = ""; - echo "\t\n"; + echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\t\n"; - echo "\t\n"; echo "\t\n"; - if( !( $SIDXML==$SIDDB && + if( !( $PSIDXML==$PSIDDB && $DateXML==$TimeDB && $RIDXML==$RIDDB && $LenXML==$LenDB && @@ -195,12 +197,12 @@ foreach($XMLmain->sub as $EventKey => $Event) } else { - echo "\t\n"; + echo "\t\n"; $DS_OK++; } echo "\t\n"; echo "\n"; - $Where.= " OR SID=$SIDXML"; + $Where.= " OR `PSID`='$PSIDXML'"; } } echo "\n"; @@ -208,11 +210,12 @@ echo "\n"; //Anzeige von nicht im XML File vorkommende entraege if( $Where =="") - $SQL2 = "SELECT * FROM `Shifts` WHERE FromPentabarf = 'Y';"; + $SQL2 = "SELECT * FROM `Shifts` WHERE NOT PSID = '';"; else - $SQL2 = "SELECT * FROM `Shifts` WHERE NOT (".substr( $Where, 4). ") AND FromPentabarf = 'Y';"; + $SQL2 = "SELECT * FROM `Shifts` WHERE NOT (".substr( $Where, 4). ") AND NOT PSID = '';"; $Erg2 = mysql_query($SQL2, $con); +echo mysql_error($con); if(mysql_num_rows($Erg2)>0 && $EnableSchudleDB ) for( $i=0; $i
SIDDate
PSIDDateRoomLenNamestate
XML - DBXML - DBXML - DBXML - DBXML - DB
\n\t\t". "\n\t\t". @@ -180,10 +183,9 @@ foreach($XMLmain->sub as $EventKey => $Event) "\n\t\t". "editedit
status: $DS_KO/$DS_OK nicht Aktuel.
status: $DS_KO/$DS_OK nicht Aktuel.