598 lines
26 KiB
PHP
598 lines
26 KiB
PHP
<?php
|
|
//echo'<pre>'; print_r($row); echo'</pre>';
|
|
setlocale(LC_TIME, "de_DE.utf8");
|
|
error_reporting(E_ALL); ini_set('display_errors',1);
|
|
|
|
|
|
|
|
|
|
|
|
$template->assign('atime', $atime);
|
|
$template->assign('ktime', utf8_decode(strftime("%B %Y", $atime)));
|
|
//---------------------------------
|
|
$kal_tage_gesamt = date("t", $atime);
|
|
$kal_start_timestamp = mktime(0,0,0,date("n",$atime),1,date("Y",$atime));
|
|
$kal_start_tag = date("N", $kal_start_timestamp);
|
|
$kal_ende_tag = date("N", mktime(0,0,0,date("n",$atime),$kal_tage_gesamt,date("Y",$atime)));
|
|
|
|
for($i = 1; $i <= $kal_tage_gesamt+($kal_start_tag-1)+(7-$kal_ende_tag); $i++) {
|
|
$kd[$i]['int']=0;
|
|
$kal_anzeige_akt_tag = $i - $kal_start_tag;
|
|
$kal_anzeige_heute_timestamp = strtotime($kal_anzeige_akt_tag." day", $kal_start_timestamp);
|
|
$kal_anzeige_heute_tag = date("j", $kal_anzeige_heute_timestamp); $kd[$i]['inx']=$kal_anzeige_heute_tag;
|
|
$kd[$i]['ts']=$kal_anzeige_heute_timestamp;
|
|
if(date("N",$kal_anzeige_heute_timestamp) == 1) { $kd[$i]['int']=1; }
|
|
if(date("dmY", $atime) == date("dmY", time())) { $kd[$i]['int']=6; }
|
|
if(date("dmY", $atime) == date("dmY", $kal_anzeige_heute_timestamp)) { $kd[$i]['int']=2; $itime=$kal_anzeige_heute_timestamp;
|
|
$xt=date("j", $kd[$i]['ts']);
|
|
$xm=date("n", $kd[$i]['ts']);
|
|
$xj=date("Y", $kd[$i]['ts']); }
|
|
elseif($kal_anzeige_akt_tag >= 0 AND $kal_anzeige_akt_tag < $kal_tage_gesamt) { $kd[$i]['int']=3; }
|
|
else { $kd[$i]['int']=4; }
|
|
if(date("N",$kal_anzeige_heute_timestamp) == 7 AND $kd[$i]['int']!=4) { $kd[$i]['int']=5; }
|
|
|
|
|
|
$ftag = $GLOBALS['mysql']->query_single("SELECT * FROM feiertage WHERE tag='".date("j", $kd[$i]['ts'])."' and monat='".date("n", $kd[$i]['ts'])."' and jahr='".date("Y", $kd[$i]['ts'])."'");
|
|
if($ftag['num_rows'] > 0) { $kd[$i]['int']=7; $kd[$i]['inx']=$kal_anzeige_heute_tag; $kd[$i]['info']=$ftag['info']; }
|
|
//echo'<pre>'; print_r($ftag); echo'</pre>';
|
|
// if feiertag
|
|
}
|
|
$template->assign('kd', $kd);
|
|
$template->assign('itime', $itime);
|
|
$template->assign('xt', $xt);
|
|
$template->assign('xm', $xm);
|
|
$template->assign('xj', $xj);
|
|
//----------------------------------------------------------------------------------------------
|
|
$old=0; if ($itime<time()) { $old=1; } $template->assign('old', $old);
|
|
//----------------------------------------------------------------------------------------------
|
|
|
|
//-------------------- wiederkehrende abfragen -------------------------------------------------
|
|
//$a_touren = $GLOBALS['a_touren'];
|
|
//$a_fahrzg = $GLOBALS['a_fahrzg'];
|
|
//$a_fahrer = $GLOBALS['a_fahrer'];
|
|
//$a_planbz = $GLOBALS['a_planbz'];
|
|
//$a_planbf = $GLOBALS['a_planbf'];
|
|
//----------------------------------------------------------------------------------------------
|
|
//--- Linke Tourspalte PVL
|
|
$tt1 = $GLOBALS['mysql']->sql("SELECT * FROM tourenliste WHERE tag='".$xt."' and monat='".$xm."' and jahr='".$xj."' and typ in (2,3) ORDER BY typ,tour");
|
|
$key=0; $menge=0; $stamminfo=" ";
|
|
//--- trennung bei typwechsel
|
|
while($row = $tt1->fetch_assoc()) {
|
|
if ($i!=$row['typ'] && $key!=0) { $nt1[$key]['test']=99; } else { $nt1[$key]['test']=1; }
|
|
|
|
|
|
$nt1[$key]['aktiv'] = $_SESSION['tour'][$row['tour']]['aktiv'];
|
|
$nt1[$key]['tour'] = $_SESSION['tour'][$row['tour']]['tour'];
|
|
$stammfahrer = $_SESSION['tour'][$row['tour']]['s_fahrer'];
|
|
$nt1[$key]['fname'] = $_SESSION['ma_all'][$row['fahrer']]['name'];
|
|
$nt1[$key]['id']=$row['id'];
|
|
$nt1[$key]['typ']=$row['typ'];
|
|
$nt1[$key]['smsstatus']=$row['smsstatus'];
|
|
$nt1[$key]['kz']=$_SESSION['car'][$row['auto']]['kz'];;
|
|
$nt1[$key]['smsid']=$row['smsid'];
|
|
$nt1[$key]['infotext']=$row['infotext'];
|
|
|
|
//-------------------------------------------------------------------------- sicher unnötige
|
|
$nt1[$key]['fahrer_id']=$row['fahrer'];
|
|
$nt1[$key]['auto_id']=$row['auto'];
|
|
$nt1[$key]['kw']=$row['kw'];
|
|
$nt1[$key]['tid']=$row['tour'];
|
|
$nt1[$key]['tourid'] = $_SESSION['tour'][$row['tour']]['id']; // fraglich
|
|
$i=$row['typ'];
|
|
$t=$row['tour'];
|
|
//--------------------------------------------------------------------------
|
|
|
|
|
|
//------------- geschätzte km eintragen
|
|
if ($row['km']<1) {
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET km='".$_SESSION['tour'][$row['tour']]['km']."' WHERE id='".$row['id']."'");
|
|
//echo $_SESSION['tour'][$row['tour']]['km']."-";
|
|
|
|
|
|
}
|
|
//------------- kein Stammfahrer
|
|
$nt1[$key]['stamm_info']=0;
|
|
if($stammfahrer ==0) {
|
|
$nt1[$key]['stamm_info']=2;
|
|
$stamminfo="kein Stammfahrer";
|
|
}
|
|
//------------- Stammfahrer da
|
|
$test_sf = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE tag='".$xt."' AND monat='".$xm."' AND jahr='".$xj."' AND mid='".$stammfahrer."' ");
|
|
if($test_sf['num_rows'] > 0) {
|
|
$nt1[$key]['stamm_info']=1;
|
|
$maf1[$key]['fahrer'] = $_SESSION['ma_all'][$row['fahrer']]['name'];
|
|
$fahrertest = $_SESSION['ma_all'][$stammfahrer]['name'];
|
|
$pnichtda = $_SESSION['pbz'][$test_sf['grund']]['nichtda'];
|
|
$grundtext = $_SESSION['pbz'][$test_sf['grund']]['bez'];
|
|
if($pnichtda==$row['typ']) {
|
|
$stamminfo=$fahrertest." ".$grundtext;
|
|
}
|
|
if($pnichtda==1) {
|
|
$stamminfo=$fahrertest." ".$grundtext;
|
|
}
|
|
}
|
|
$nt1[$key]['stamminfo']=str_replace(" ","_",$stamminfo); // umwandlung für Tooltip
|
|
//------------- Mitarbeiter da
|
|
$test_ma = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE tag='".$xt."' AND monat='".$xm."' AND jahr='".$xj."' AND mid='".$row['fahrer']."' ");
|
|
if($test_ma['num_rows'] > 0) {
|
|
$pnichtda = $_SESSION['pbz'][$test_ma['grund']]['nichtda'];
|
|
if($pnichtda==$row['typ']) { $nt1[$key]['fahrer_ok']=0; }
|
|
else if($pnichtda==1) { $nt1[$key]['fahrer_ok']=0; }
|
|
else if($pnichtda==99) { $nt1[$key]['fahrer_ok']=3; }
|
|
else { $tag_tour2[$key]['fahrer_ok']=2; }
|
|
} else {
|
|
$tag_tour2[$key]['fahrer_ok']=1;
|
|
}
|
|
|
|
//-------------- Abnahmetour
|
|
$nt1[$key]['zusatz']=0;
|
|
if($row['tour']>90000) {
|
|
if($row['tour']<91000) { $nt1[$key]['zusatz']=1; } else { $nt1[$key]['zusatz']=2;
|
|
}
|
|
}
|
|
//nt1[$key]['n_update']= $_SESSION['ma_all'][$row['m_update']]['name'];
|
|
//nt1[$key]['var']=$_SESSION['ma_all'][$row['m_update']]['name']." am: ".$row['t_update'];
|
|
$nt1[$key]['m_update']=$row['m_update'];
|
|
$nt1[$key]['t_update']=$row['t_update'];
|
|
$key++;
|
|
}
|
|
//if ($test>0) { $test=0; nt1[$key]['tour']=99999999; $key++; }// trennlinie
|
|
//
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$template->assign('nt1', $nt1);
|
|
//----------------------------------------------------------------------------------------------
|
|
//--- rechte Tourspalte LVZ
|
|
$tt2 = $GLOBALS['mysql']->sql("SELECT * FROM tourenliste WHERE tag='".$xt."' and monat='".$xm."' and jahr='".$xj."' and typ in (4,5,17) ORDER BY typ,tour"); $key=0; $menge=0; $stamminfo=" ";
|
|
|
|
$key=0; $menge=0; $stamminfo=" ";
|
|
//--- trennung bei typwechsel
|
|
while($row = $tt2->fetch_assoc()) {
|
|
if ($i!=$row['typ'] && $key!=0) { $nt2[$key]['test']=99; } else { $nt2[$key]['test']=1; }
|
|
|
|
|
|
$nt2[$key]['aktiv'] = $_SESSION['tour'][$row['tour']]['aktiv'];
|
|
$nt2[$key]['tour'] = $_SESSION['tour'][$row['tour']]['tour'];
|
|
$stammfahrer = $_SESSION['tour'][$row['tour']]['s_fahrer'];
|
|
$nt2[$key]['fname'] = $_SESSION['ma_all'][$row['fahrer']]['name'];
|
|
$nt2[$key]['id']=$row['id'];
|
|
$nt2[$key]['typ']=$row['typ'];
|
|
$nt2[$key]['smsstatus']=$row['smsstatus'];
|
|
$nt2[$key]['kz']=$_SESSION['car'][$row['auto']]['kz'];;
|
|
$nt2[$key]['smsid']=$row['smsid'];
|
|
$nt2[$key]['infotext']=$row['infotext'];
|
|
|
|
//-------------------------------------------------------------------------- sicher unnötige
|
|
$nt2[$key]['fahrer_id']=$row['fahrer'];
|
|
$nt2[$key]['auto_id']=$row['auto'];
|
|
$nt2[$key]['kw']=$row['kw'];
|
|
$nt2[$key]['tid']=$row['tour'];
|
|
$nt2[$key]['tourid'] = $_SESSION['tour'][$row['tour']]['id']; // fraglich
|
|
$i=$row['typ'];
|
|
$t=$row['tour'];
|
|
//--------------------------------------------------------------------------
|
|
|
|
|
|
//------------- geschätzte km eintragen
|
|
if ($row['km']<1) {
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET km='".$_SESSION['tour'][$row['tour']]['km']."' WHERE id='".$row['id']."'");
|
|
//echo $_SESSION['tour'][$row['tour']]['km']."-";
|
|
|
|
|
|
}
|
|
//------------- kein Stammfahrer
|
|
$nt2[$key]['stamm_info']=0;
|
|
if($stammfahrer ==0) {
|
|
$nt2[$key]['stamm_info']=2;
|
|
$stamminfo="kein Stammfahrer";
|
|
}
|
|
//------------- Stammfahrer da
|
|
$test_sf = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE tag='".$xt."' AND monat='".$xm."' AND jahr='".$xj."' AND mid='".$stammfahrer."' ");
|
|
if($test_sf['num_rows'] > 0) {
|
|
$nt2[$key]['stamm_info']=1;
|
|
$maf1[$key]['fahrer'] = $_SESSION['ma_all'][$row['fahrer']]['name'];
|
|
$fahrertest = $_SESSION['ma_all'][$stammfahrer]['name'];
|
|
$pnichtda = $_SESSION['pbz'][$test_sf['grund']]['nichtda'];
|
|
$grundtext = $_SESSION['pbz'][$test_sf['grund']]['bez'];
|
|
if($pnichtda==$row['typ']) {
|
|
$stamminfo=$fahrertest." ".$grundtext;
|
|
}
|
|
if($pnichtda==1) {
|
|
$stamminfo=$fahrertest." ".$grundtext;
|
|
}
|
|
}
|
|
$nt2[$key]['stamminfo']=str_replace(" ","_",$stamminfo); // umwandlung für Tooltip
|
|
//------------- Mitarbeiter da
|
|
$test_ma = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE tag='".$xt."' AND monat='".$xm."' AND jahr='".$xj."' AND mid='".$row['fahrer']."' ");
|
|
if($test_ma['num_rows'] > 0) {
|
|
$pnichtda = $_SESSION['pbz'][$test_ma['grund']]['nichtda'];
|
|
if($pnichtda==$row['typ']) { $nt2[$key]['fahrer_ok']=0; }
|
|
else if($pnichtda==1) { $nt2[$key]['fahrer_ok']=0; }
|
|
else if($pnichtda==99) { $nt2[$key]['fahrer_ok']=3; }
|
|
else { $tag_tour2[$key]['fahrer_ok']=2; }
|
|
} else {
|
|
$tag_tour2[$key]['fahrer_ok']=1;
|
|
}
|
|
|
|
//-------------- Abnahmetour
|
|
$nt2[$key]['zusatz']=0;
|
|
if($row['tour']>90000) {
|
|
if($row['tour']<91000) { $nt2[$key]['zusatz']=1; } else { $nt2[$key]['zusatz']=2;
|
|
}
|
|
}
|
|
//nt1[$key]['n_update']= $_SESSION['ma_all'][$row['m_update']]['name'];
|
|
//nt1[$key]['var']=$_SESSION['ma_all'][$row['m_update']]['name']." am: ".$row['t_update'];
|
|
$nt2[$key]['m_update']=$row['m_update'];
|
|
$nt2[$key]['t_update']=$row['t_update'];
|
|
$key++;
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
$template->assign('nt2', $nt2);
|
|
//----------------------------------------------------------------------------------------------
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
//--------------------------------------------- SMS Senden neu mit onclick
|
|
if(isset($_GET['sms'])) {
|
|
$tourid=$_GET['sms'];
|
|
$row_smstour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE id='".$tourid."'");
|
|
$row_smstour2 = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row_smstour['tour']."'");
|
|
$sms_tour=$row_smstour2['tour'];
|
|
$sms_tag=$row_smstour['tag'];
|
|
$sms_monat=$row_smstour['monat'];
|
|
$sms_jahr=$row_smstour['jahr'];
|
|
$sms_auto=$row_smstour['auto'];
|
|
$row_autox = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$sms_auto."'");
|
|
$sms_autoname=$row_autox['kz'];
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row_smstour['fahrer']."'");
|
|
$sms_nummer[0]=$row_fahrerx['handy'];
|
|
$MessageText = "Änderung Einsatzplan ".$sms_tag.".".$sms_monat.".".$sms_jahr." * Tour: ".$sms_tour." mit ".$sms_autoname;
|
|
//------------------------------ SMS in Dabank zum senden speichern
|
|
$GLOBALS['cms']->sendcms($MessageText,$sms_nummer,$tourid);
|
|
|
|
//$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsid='".$_SESSION['messageId']."' WHERE id='".$tourid."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus=20,fertig=1,logid='".time()."' WHERE id='".$tourid."'");
|
|
$success="SMS an: ".$sms_nummer[0]." gespeichert."; $template->assign('success', $success);
|
|
//------------------------------ Datum für anzeige übernehmen
|
|
$jahr = $_GET['jahr'];
|
|
$monat = $_GET['monat'];
|
|
$tag = $_GET['tag'];
|
|
}
|
|
//--------------------------------------------- tour hinzufügen
|
|
if(isset($_GET['dazu'])) {
|
|
$newtour=90000+$_GET['dazu'];
|
|
$testtour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$newtour."'");
|
|
if($testtour['num_rows'] > 0) {
|
|
$teile = explode(":", $testtour['kalzeit']);
|
|
$startzeit=mktime((int)$teile[0],(int)$teile[1], 0,(int)$_GET['monat'],(int)$_GET['tag'],(int)$_GET['jahr']);
|
|
$GLOBALS['mysql']->insert("INSERT INTO tourenliste (tour,zeit,fahrer,auto,kw,tag,monat,jahr,typ,time)
|
|
VALUES(
|
|
'".$newtour."',
|
|
'".$testtour['kalzeit']."',
|
|
'".$testtour['s_fahrer']."',
|
|
'".$testtour['s_auto']."',
|
|
'".$_GET['kw']."',
|
|
'".$_GET['tag']."',
|
|
'".$_GET['monat']."',
|
|
'".$_GET['jahr']."',
|
|
'".$testtour['typ']."',
|
|
'".$startzeit."')
|
|
");
|
|
$success="Tour hinzugefügt !"; $template->assign('success', $success);
|
|
} else {
|
|
$success="Tour in Datenbank nicht gefunden !"; $template->assign('error', $success);
|
|
}
|
|
}
|
|
//--------------------------------------------- tour löschen
|
|
if(isset($_GET['daweg'])) {
|
|
$GLOBALS['mysql']->sql("DELETE FROM tourenliste WHERE id='".$_GET['daweg']."'");
|
|
$success="Tour gelöscht !!!"; $template->assign('warning', $success);
|
|
}
|
|
|
|
|
|
|
|
//--------------------------------------------------------------------------------------------------------------------------------------------------
|
|
|
|
//--------------------------------------------- vortag übernehmen
|
|
if(isset($_POST['vortag'])) {
|
|
$vdate= mktime(0,0,0,$monat,$tag,$jahr);
|
|
//$wochentag=date("w",$vdate);
|
|
if(date("w",$vdate)==1) { $vdate2=strtotime("-2 day",$vdate); } else { $vdate2=strtotime("-1 day",$vdate); }
|
|
|
|
$vjahr = (int)date('Y',$vdate2);
|
|
$vmonat = (int)date('m',$vdate2);
|
|
$vtag = (int)date('d',$vdate2);
|
|
|
|
$ftt = $GLOBALS['mysql']->query_single("SELECT * FROM feiertage WHERE tag='".$vtag."' and monat='".$vmonat."' and jahr='".$vjahr."'");
|
|
if($ftt['num_rows'] >0) {
|
|
$vdate2=strtotime('-1 day',$vdate2);
|
|
$vjahr = (int)date('Y',$vdate2);
|
|
$vmonat = (int)date('m',$vdate2);
|
|
$vtag = (int)date('d',$vdate2);
|
|
}
|
|
|
|
$loginfo="Planung von Vortag (Nacht) übernommen";
|
|
/*
|
|
$vjahr = $jahr; $vmonat = $monat; $vtag = $tag;
|
|
$vtag--;
|
|
if($vtag==0) {
|
|
if($vmonat==1) {
|
|
$vmonat=12; $vtag=31; $vjahr--;
|
|
} else {
|
|
$vmonat--; $vtag=date("t",mktime(0, 0, 0,$vmonat,$vtag,$vjahr));
|
|
}
|
|
}
|
|
$wochentag=date("w",mktime(0, 0, 0,$vmonat,$vtag,$vjahr));
|
|
if($wochentag==0) {
|
|
$vtag--;
|
|
if($vtag==0) {
|
|
if($vmonat==1) {
|
|
$vmonat=12; $vtag=31; $vjahr--;
|
|
} else {
|
|
$vmonat--; $vtag=date("t",mktime(0, 0, 0,$vmonat,$vtag,$vjahr));
|
|
}
|
|
}
|
|
}
|
|
*/
|
|
//echo "data: ".$vtag.".".$vmonat.".".$vjahr;
|
|
//----------------------
|
|
$tour = $GLOBALS['mysql']->sql("SELECT * FROM tourenliste WHERE tag='".$vtag."' and monat='".$vmonat."' and jahr='".$vjahr."' and typ in (2,3,4,5,17) ");
|
|
while($row = $tour->fetch_assoc()) {
|
|
|
|
$test = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE tag='".$tag."' and monat='".$monat."' and jahr='".$jahr."' and tour='".$row['tour']."'");
|
|
if($test['num_rows'] >0) {
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET typ='".$row['typ']."' WHERE id='".$test['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET utyp='".$row['utyp']."' WHERE id='".$test['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET time=0 WHERE id='".$test['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET fahrer='".$row['fahrer']."' WHERE id='".$test['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET zeit='".$row['zeit']."' WHERE id='".$test['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET tour='".$row['tour']."' WHERE id='".$test['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET auto='".$row['auto']."' WHERE id='".$test['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET infotext='".$row['infotext']."' WHERE id='".$test['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET tarif='".$row['tarif']."' WHERE id='".$test['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET tarifh='".$row['tarifh']."' WHERE id='".$test['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET timestamp=0 WHERE id='".$test['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET m_update='".$_SESSION['benutzer']."' WHERE id='".$test['id']."'");
|
|
}
|
|
}
|
|
}
|
|
|
|
//------------------------------------------ komplette SMS Senden
|
|
if(isset($_POST['smspower'])) {
|
|
$key=0; $ssms=0;
|
|
$row_smstour = $GLOBALS['mysql']->sql("SELECT * FROM tourenliste WHERE tag='".$tag."' and monat='".$monat."' and jahr='".$jahr."' and typ in (2,3,4,5,17) ORDER BY tour");
|
|
while($row = $row_smstour->fetch_assoc()) {
|
|
$nosms = $_SESSION['ma_all'][$row['fahrer']]['nosms'];
|
|
if ($nosms!=1) {
|
|
$sms_nummer[0] = $_SESSION['ma_all'][$row['fahrer']]['handy'];
|
|
$sms_name = $_SESSION['ma_all'][$row['fahrer']]['name'];
|
|
$sms_auto = $_SESSION['car'][$row['auto']]['kz'];
|
|
$sms_tour = $_SESSION['tour'][$row['tour']]['tour'];
|
|
|
|
$sms_zeit=$row['zeit'];
|
|
|
|
$MessageText = "Einsatzplan ".$row['tag'].".".$row['monat'].".".$row['jahr']." * Tour: ".$sms_tour." mit ".$sms_auto;
|
|
//------------------------------ sms neu
|
|
|
|
$GLOBALS['cms']->sendcms($MessageText,$sms_nummer,$row['id']);
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus=20,fertig=1,logid='".time()."' WHERE id='".$row['id']."'");
|
|
}
|
|
$key++;
|
|
}
|
|
$success="Hinweis: ".$key." SMS zum senden vorgemerkt.";
|
|
$template->assign('success', $success);
|
|
}
|
|
//------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
//--------------------------------------------------
|
|
//-------------------- Auslesen --------------------
|
|
//--------------------------------------------------
|
|
$ptime=time()-mktime(0, 0, 0,$xm,$xt,$xj); $key=0; $test=0; $aquery=0; $i=0; // wohl überflüssig
|
|
//-------------------- erstaufruf. $anz setzten ----
|
|
if(isset($_GET['anz'])) { $anz=$_GET['anz']; } else { $anz=2; }
|
|
//-------------------- Auslesen --------------------
|
|
//-------------------- Feiertag --------------------
|
|
$ftag2 = $GLOBALS['mysql']->query_single("SELECT * FROM feiertage WHERE tag='".$tag."' and monat='".$monat."' and jahr='".$jahr."' "); $ftx=0;
|
|
if($ftag2['num_rows'] != 0) {
|
|
$ftx=1;
|
|
$ftrow['tag']=$ftag2['tag'].".".$ftag2['monat'].".".$ftag2['jahr'];
|
|
$ftrow['bez']=$ftag2['info'];
|
|
|
|
$template->assign('ftrow', $ftrow);
|
|
}
|
|
$template->assign('fttest', $ftx);
|
|
|
|
//--------------------- TYP 3 - GH ----------------------------
|
|
$fa2_3 = $GLOBALS['mysql']->query_array("SELECT DISTINCT mitarbeiter.id, mitarbeiter.name FROM mitarbeiter WHERE aktiv>0 AND gh>0 ORDER BY name"); $template->assign('fahrer_array3' , $fa2_3);
|
|
//--------------------- TYP 4 - LVZ ----------------------------
|
|
$fa2_4 = $GLOBALS['mysql']->query_array("SELECT DISTINCT mitarbeiter.id, mitarbeiter.name FROM mitarbeiter WHERE aktiv>0 AND lvz>0 ORDER BY name"); $template->assign('fahrer_array4' , $fa2_4);
|
|
//--------------------- TYP 5 - LVZ ----------------------------
|
|
$fa2_5 = $GLOBALS['mysql']->query_array("SELECT DISTINCT mitarbeiter.id, mitarbeiter.name FROM mitarbeiter WHERE aktiv>0 AND pin>0 ORDER BY name"); $template->assign('fahrer_array5' , $fa2_5);
|
|
//--------------------- TYP 17 - Zust. ----------------------------
|
|
$fa2_17 = $GLOBALS['mysql']->query_array("SELECT DISTINCT mitarbeiter.id, mitarbeiter.name FROM mitarbeiter WHERE aktiv>0 AND lvzz>0 ORDER BY name"); $template->assign('fahrer_array17', $fa2_17);
|
|
|
|
//----------------------------------------------------------------------
|
|
$tt = $GLOBALS['mysql']->sql("SELECT * FROM tourenliste WHERE tag='".$tag."' and monat='".$monat."' and jahr='".$jahr."'
|
|
and typ in (2,3,4,5,17) ORDER BY typ,tour"); $key=0; $menge=0; $stamminfo=" ";
|
|
|
|
|
|
//----------------------------auslesen aktuell änderbar
|
|
//---------------------------------------------------------------------- trennung bei typwechsel
|
|
while($row = $tt->fetch_assoc()) { //echo'<pre>'; print_r($row['tour']); echo'</pre>';
|
|
if ($i!=$row['typ'] && $key!=0) { $tag_tour2[$key]['test']=99; } else { $tag_tour2[$key]['test']=1; }
|
|
$i=$row['typ'];
|
|
$t=$row['tour'];
|
|
$tag_tour2[$key]['tid']=$key;
|
|
|
|
//$_SESSION['tour'][$row['tour']]['id'];
|
|
$tag_tour2[$key]['tourid'] = $_SESSION['tour'][$row['tour']]['id'];
|
|
$tag_tour2[$key]['aktiv'] = $_SESSION['tour'][$row['tour']]['aktiv'];
|
|
$tag_tour2[$key]['tour'] = $_SESSION['tour'][$row['tour']]['tour'];
|
|
$stammfahrer = $_SESSION['tour'][$row['tour']]['s_fahrer'];
|
|
|
|
$tag_tour2[$key]['id']=$row['id'];
|
|
$tag_tour2[$key]['kw']=$row['kw'];
|
|
$tag_tour2[$key]['tid']=$row['tour'];
|
|
$tag_tour2[$key]['typ']=$row['typ'];
|
|
$tag_tour2[$key]['smsstatus']=$row['smsstatus'];
|
|
$tag_tour2[$key]['smsid']=$row['smsid'];
|
|
//-------------- Abnahmetour
|
|
$tag_tour2[$key]['zusatz']=0;
|
|
if($row['tour']>90000) {
|
|
if($row['tour']<91000) { $tag_tour2[$key]['zusatz']=1; } else { $tag_tour2[$key]['zusatz']=2;
|
|
}
|
|
}
|
|
//------------- geschätzte km eintragen
|
|
if ($row['km']<1) {
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET km='".$_SESSION['tour'][$row['tour']]['km']."' WHERE id='".$row['id']."'");
|
|
//echo $_SESSION['tour'][$row['tour']]['km']."-";
|
|
|
|
|
|
}
|
|
//------------- kein Stammfahrer
|
|
$tag_tour2[$key]['stamm_info']=0;
|
|
if($stammfahrer ==0) {
|
|
$tag_tour2[$key]['stamm_info']=2;
|
|
$stamminfo="kein Stammfahrer";
|
|
}
|
|
//------------- Stammfahrer da
|
|
$test_sf = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE tag='".$xt."' AND monat='".$xm."' AND jahr='".$xj."' AND mid='".$stammfahrer."' ");
|
|
if($test_sf['num_rows'] > 0) {
|
|
$tag_tour2[$key]['stamm_info']=1;
|
|
$maf1[$key]['fahrer'] = $_SESSION['ma_all'][$row['fahrer']]['name'];
|
|
$fahrertest = $_SESSION['ma_all'][$stammfahrer]['name'];
|
|
$pnichtda = $_SESSION['pbz'][$test_sf['grund']]['nichtda'];
|
|
$grundtext = $_SESSION['pbz'][$test_sf['grund']]['bez'];
|
|
if($pnichtda==$row['typ']) {
|
|
$stamminfo=$fahrertest." ".$grundtext;
|
|
}
|
|
if($pnichtda==1) {
|
|
$stamminfo=$fahrertest." ".$grundtext;
|
|
}
|
|
}
|
|
$tag_tour2[$key]['stamminfo']=str_replace(" ","_",$stamminfo); // umwandlung für Tooltip
|
|
//------------- Mitarbeiter da
|
|
$test_ma = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND mid='".$row['fahrer']."' ");
|
|
if($test_ma['num_rows'] > 0) {
|
|
$pnichtda = $_SESSION['pbz'][$test_ma['grund']]['nichtda'];
|
|
if($pnichtda==$row['typ']) { $tag_tour2[$key]['fahrer_ok']=0; }
|
|
else if($pnichtda==1) { $tag_tour2[$key]['fahrer_ok']=0; }
|
|
else if($pnichtda==99) { $tag_tour2[$key]['fahrer_ok']=3; }
|
|
else { $tag_tour2[$key]['fahrer_ok']=2; }
|
|
} else {
|
|
$tag_tour2[$key]['fahrer_ok']=1;
|
|
}
|
|
|
|
$tag_tour2[$key]['fahrer_id']=$row['fahrer'];
|
|
$tag_tour2[$key]['auto_id']=$row['auto'];
|
|
$tag_tour2[$key]['smsid']=$row['smsid'];
|
|
$tag_tour2[$key]['infotext']=$row['infotext'];
|
|
//$tag_tour2[$key]['n_update']= $_SESSION['ma_all'][$row['m_update']]['name'];
|
|
//$tag_tour2[$key]['var']=$_SESSION['ma_all'][$row['m_update']]['name']." am: ".$row['t_update'];
|
|
$tag_tour2[$key]['m_update']=$row['m_update'];
|
|
$tag_tour2[$key]['t_update']=$row['t_update'];
|
|
$key++;
|
|
}
|
|
//if ($test>0) { $test=0; $tag_tour2[$key]['tour']=99999999; $key++; }// trennlinie
|
|
//
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
//----------------------- Kalender ----------------------------------
|
|
//----------------------- Mitarbeiter
|
|
$ma_kalender = $GLOBALS['mysql']->sql("SELECT * FROM planer WHERE tag='".$xt."' AND monat='".$xm."' AND jahr='".$xj."'"); $key=0; unset($maf1);
|
|
while($row = $ma_kalender->fetch_assoc()) {
|
|
$maf1[$key]['fahrer'] = $_SESSION['ma_all'][$row['mid']]['name'];
|
|
$maf1[$key]['bez'] = $_SESSION['pbz'][$row['grund']]['bez'];
|
|
$maf1[$key]['icon'] = $_SESSION['pbz'][$row['grund']]['fa'];
|
|
$maf1[$key]['na'] = $_SESSION['pbz'][$row['grund']]['nichtda'];
|
|
$key++;
|
|
}
|
|
//----------------------- Fahrzeuge
|
|
$auto = $GLOBALS['mysql']->sql("SELECT * FROM fplaner WHERE tag='".$xt."' AND monat='".$xm."' AND jahr='".$xj."'");
|
|
while($rowf = $auto->fetch_assoc()) {
|
|
$maf1[$key]['fahrer'] = $_SESSION['car'][$rowf['fid']]['kz'];
|
|
$maf1[$key]['bez'] = $_SESSION['fbz'][$rowf['grund']]['bez'];
|
|
$maf1[$key]['icon'] = $_SESSION['fbz'][$rowf['grund']]['fa'];
|
|
$maf1[$key]['na'] = $_SESSION['fbz'][$rowf['grund']]['aktiv'];
|
|
$key++;
|
|
}
|
|
//----------------------- // auslesen geburtstag
|
|
$bday = $GLOBALS['mysql']->sql("SELECT * FROM mitarbeiter WHERE aktiv >0 and gebtag='".$xt."' AND gebmonat='".$xm."'");
|
|
while($row = $bday->fetch_assoc()) {
|
|
if($row['gebjahr']>0) {
|
|
$fname=$row['name'];
|
|
$maf1[$key]['fahrer']=substr($fname,0,17);
|
|
$jahre=$jahr-$row['gebjahr'];
|
|
$maf1[$key]['bez']=$jahre.". Geburtstag";
|
|
$maf1[$key]['icon']='fad fa-birthday-cake';
|
|
$key++;
|
|
}
|
|
}
|
|
//---------------------------
|
|
// echo'<pre>'; print_r($ma_kalender); echo'</pre>';
|
|
//---------------------------
|
|
//---------------------------
|
|
//---------------------------
|
|
//--------------------- Fahrer und Auto Array
|
|
//$fahrer_array = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 ORDER BY name"); // noch auswählen ob für lvz bzw nachttouren zugelassen
|
|
$auto_array = $GLOBALS['mysql']->query_id("SELECT * FROM fahrzeuge WHERE aktiv>0 AND typ>0 ORDER BY kz"); $template->assign('auto_array', $auto_array);
|
|
//---------------------------------------------------------------------------------------------------------
|
|
//$loginfo="Planung Nacht aufgerufen"; $GLOBALS['syslog']->syslog($loginfo); //syslog
|
|
//----------------------------------------------------------------------------------------------------------
|
|
if(isset($tag_tour2)) {$template->assign('tag_tour2', $tag_tour2); }
|
|
$template->assign('maf1', $maf1);
|
|
|
|
$template->assign('anz', $anz);
|
|
$template->assign('tag', $tag); $template->assign('monat', (int)$monat); $template->assign('jahr', $jahr);
|
|
//$template->assign('cardate', $jahr."-".$monat."-".$tag);
|
|
$template->assign('datum_unix', mktime(0,0,0, $xm,$xt,$xj));
|
|
$template->assign('tage', $tage);
|
|
//$template->assign('test', "yellow");
|
|
|
|
$template->assign('content', 'tpl/p_night_tdd.tpl');
|
|
?>
|