summaryrefslogtreecommitdiff
path: root/admin/dect_cron.php
diff options
context:
space:
mode:
authorcookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>2005-09-10 17:25:43 +0000
committercookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>2005-09-10 17:25:43 +0000
commit310c2ce98fc8c0e94559c9ed8587101d92f6e853 (patch)
tree7093065a133e434fb7e551803e8700661d04c5bb /admin/dect_cron.php
add total system
git-svn-id: svn://svn.cccv.de/engel-system@1 29ba0400-6e00-0410-a75a-ca02368028f8
Diffstat (limited to 'admin/dect_cron.php')
-rwxr-xr-xadmin/dect_cron.php69
1 files changed, 69 insertions, 0 deletions
diff --git a/admin/dect_cron.php b/admin/dect_cron.php
new file mode 100755
index 00000000..00119567
--- /dev/null
+++ b/admin/dect_cron.php
@@ -0,0 +1,69 @@
+<?PHP
+
+
+include ("./inc/db.php");
+include ("./inc/config.php");
+include ("./inc/funktion_modem.php");
+
+//ausfuerungs Ruetmuss (in s)
+$StartTimeBeforEvent = (60/4)*60;
+
+
+
+
+function UID2DECT($UID)
+{
+ include ("./inc/db.php");
+
+ $SQL = "SELECT DECT FROM `User` WHERE UID='$UID'";
+ $Erg = mysql_query($SQL, $con);
+
+ return mysql_result($Erg, 0);
+}
+
+
+$SQL = "SELECT Shifts.DateS, ShiftEntry.UID ".
+ "FROM `Shifts` INNER JOIN `ShiftEntry` ON `Shifts`.`SID` = `ShiftEntry`.`SID` ".
+ "WHERE ((`Shifts`.`DateS`>'". gmdate("Y-m-d H:i:s", time()+3600+120). "') AND ".
+ "(`Shifts`.`DateS`<='". gmdate("Y-m-d H:i:s", time()+3600+120+$StartTimeBeforEvent). "') );";
+// "WHERE (Shifts.DateS>'2004-12-27 10:45:00' AND ".
+// "Shifts.DateS<='2004-12-27 11:00:00');";
+
+$Erg = mysql_query($SQL, $con);
+
+echo mysql_error($con);
+
+for( $i=0; $i<mysql_num_rows($Erg); $i++)
+{
+// echo mysql_result($Erg, $i, "UID");
+ if( mysql_result($Erg, $i, "UID")>0)
+ {
+ $SQL2 = "SELECT DECT FROM `User` WHERE ( `UID`='". mysql_result($Erg, $i, "UID"). "');";
+ $Erg2 = mysql_query($SQL2, $con);
+
+ $Number = mysql_result($Erg2, 0, "DECT");
+ if( $Number!="")
+ {
+ $TimeH = substr( mysql_result($Erg, $i, "DateS"), 11, 2);
+ $TimeM = substr( mysql_result($Erg, $i, "DateS"), 14, 2);
+ $TimeM = substr( mysql_result($Erg, $i, "DateS"), 14, 2) - 5;
+ if( $TimeM < 0 )
+ {
+ $TimeM += 60;
+ $TimeH -= 1;
+ }
+ if( $TimeH < 0 )
+ $TimeH += 24;
+
+ if( strlen( $TimeH) == 1)
+ $TimeH = "0".$TimeH;
+
+ SetWackeup( $Number, $TimeH, $TimeM);
+ }
+ }
+}
+
+return 0;
+
+?>
+