steven/jb-data.de
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
jb-data.de/scripts/ifazs.php
steven 72a26edcff init
2025-08-11 22:23:30 +02:00

215 lines
11 KiB
PHP
Raw Permalink Blame History

<?php
$_SESSION['m1']=3; $_SESSION['m2']=14;
echo "test";
error_reporting(E_ALL); error_reporting(1);
//--------- jahrauswahl
$pjahr=date('W', (mktime(0, 0, 0, 1, 1, $jahr+1) - 4*86400));
$ijahr=date('W', (mktime(0, 0, 0, 1, 1, $jahr) - 4*86400));
$mjahr=date('W', (mktime(0, 0, 0, 1, 1, $jahr-1) - 4*86400));
if($_GET['wahl']==1) {
if($_GET['kw']==1) {
$kw=$mjahr; $jahr=$_GET['jahr']-1;
} else {
$kw=$_GET['kw']-1; $jahr=$_GET['jahr'];
}
}
elseif($_GET['wahl']==2) {
if($_GET['kw']==$ijahr) {
$kw=1; $jahr=$_GET['jahr']+1;
} else {
$kw=$_GET['kw']+1; $jahr=$_GET['jahr'];
}
} else {
if(isset($_GET['jahr'])) { $jahr = $_GET['jahr']; } else { $jahr = (int)date('Y'); }
if(isset($_GET['kw'])) { $kw = $_GET['kw']; } else { $kw = (int)date('W'); }
}
//-----------------------------------------------
// echo "<pre>"; print_r($ssz); echo "</pre>";
//------------------------------------------------------------------------------------------------------------
//------------------------------------------------------------------------------------------------------------
//------------------------------------------------------------------------------------------------------------
if(isset($_POST['msg'])) {
$infotest = $GLOBALS['mysql']->query_single("SELECT * FROM fazinfo WHERE abonr='".$_POST['abonr']."'");
if($infotest['num_rows']==0) {
$GLOBALS['mysql']->insert("INSERT INTO fazinfo (abonr,info)
VALUES(
'".$_POST['abonr']."',
'".$_POST['msg']."')
");
} else {
$GLOBALS['mysql']->insert("UPDATE fazinfo SET info='".$_POST['msg']."' WHERE abonr='".$_POST['abonr']."'");
}
}
//------------------------------------------------------------------------------------------------------------
//------------------------------------------------------------------------------------------------------------
//------------------------------------------------------------------------------------------------------------
//------------------------------------------ auswahla Auslesen
if(isset($_GET['edit'])) {
$template->assign('edit',$_GET['edit']);
//$haupt = $GLOBALS['mysql']->query_array("SELECT * FROM fazs WHERE plz='".$anz."' and jahr='".$jahr."' and kw='".$kw."' order by strasse");
//$template->assign('haupt', $haupt);
if(isset($_GET['iabo'])) {
$infoanz = $GLOBALS['mysql']->query_single("SELECT * FROM fazs WHERE auftragnr='".$_GET['iabo']."'");
$template->assign('infoanz', $infoanz);
//-------------- informationen für Zusteller
$i_tour=$GLOBALS['mysql']->query_single("SELECT * FROM fazinfo WHERE abonr='".$_GET['iabo']."'");
if($i_tour['num_rows'] !=0) {
$template->assign('kdnrinfo', $i_tour['info']);
$template->assign('ubk', $i_tour['unbekannt']);
}
$fazw_tour = $GLOBALS['mysql']->query("SELECT * FROM fazs WHERE auftragnr='".$_GET['iabo']."'"); $key=0;
//echo "<pre>"; print_r($fazw_tour); echo "</pre>";
while($row = $fazw_tour->fetch_assoc()) {
$aboinfo[$key]['datum']= $row['zustelldate'];
$aboinfo[$key]['meldung']= $row['meldung'];
$aboinfo[$key]['abo']= $row['abo'];
$aboinfo[$key]['id']= $row['id'];
$aboinfo[$key]['rekla']=$row['rekla'];
$aboinfo[$key]['nl']= $row['nl'];
//-------------- wer ist wann gefahren id auslesen
$tliste1 = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE tag='".$row['tag']."' and monat='".$row['monat']."' and jahr='".$row['jahr']."' and tour='".$row['plz']."'");
//-------------- wer ist wann gefahren id in Namen umwandeln
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$tliste1['fahrer']."'");
$aboinfo[$key]['fahrer']= $row_fahrerx['name'];
$aboinfo[$key]['name']= $row['name'];
$key++;
$template->assign('aboinfo', $aboinfo);
//echo "<pre>"; print_r($row); echo "</pre>";
}
}
// $testa = $GLOBALS['mysql']->query("SELECT * FROM fazs WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'"); $menge=0;
// $aboanz = $GLOBALS['mysql']->query_single("SELECT * FROM fazs WHERE plz='".$anz."' and jahr='".$jahr."' and kw='".$kw."' order by strasse");
}
if(isset($_GET['anz'])) {
$anz=$_GET['anz'];
if($anz>0) {
$haupt = $GLOBALS['mysql']->query_array("SELECT * FROM fazs WHERE plz='".$anz."' and jahr='".$jahr."' and kw='".$kw."' order by strasse");
$template->assign('haupt', $haupt);
}
} else {
$anz=0;
}
$template->assign('anz', $anz);
//------------------------------------------------------------------------------------------------------------
// echo'<pre>'; print_r($rowf); echo'</pre>';
//----------------------------------------------------------------------------------------------------------------------------------------
$menue1 = $GLOBALS['mysql']->query_array("SELECT * FROM touren WHERE typ=15 and utyp=1"); $template->assign('menue1', $menue1);
$menue2 = $GLOBALS['mysql']->query_array("SELECT * FROM touren WHERE typ=15 and utyp=2"); $template->assign('menue2', $menue2);
$menue3 = $GLOBALS['mysql']->query_array("SELECT * FROM touren WHERE typ=15 and utyp=3"); $template->assign('menue3', $menue3);
$menue4 = $GLOBALS['mysql']->query_array("SELECT * FROM touren WHERE typ=15 and utyp=4"); $template->assign('menue4', $menue4);
//----------------------------------------------------------------------------------------------------------------------------------------
//----------------------------------------- Stückzahlen eingestellt KW -------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------------------------------------------
$fazw_tour = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ=15 and utyp=1"); $mengeW=0;
while($row = $fazw_tour->fetch_assoc()) {
$testa = $GLOBALS['mysql']->query("SELECT * FROM fazs WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'"); $menge=0;
while($rowf = $testa->fetch_assoc()) {
$menge=$menge+$rowf['abo'];
}
$mengeW=$mengeW+$menge;
}
//----------------------------------------------------------------------------------------------------------------------------------------
$fazn_tour = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ=15 and utyp=2"); $mengeN=0;
while($row = $fazn_tour->fetch_assoc()) {
$testa = $GLOBALS['mysql']->query("SELECT * FROM fazs WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'"); $menge=0;
while($rowf = $testa->fetch_assoc()) {
$menge=$menge+$rowf['abo'];
}
$mengeN=$mengeN+$menge;
}
//----------------------------------------------------------------------------------------------------------------------------------------
$fazs_tour = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ=15 and utyp=3"); $mengeS=0;
while($row = $fazs_tour->fetch_assoc()) {
$testa = $GLOBALS['mysql']->query("SELECT * FROM fazs WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'"); $menge=0;
while($rowf = $testa->fetch_assoc()) {
$menge=$menge+$rowf['abo'];
}
$mengeS=$mengeS+$menge;
}
//----------------------------------------------------------------------------------------------------------------------------------------
$fazs_tour = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ=15 and utyp=4"); $mengeO=0;
while($row = $fazs_tour->fetch_assoc()) {
$testa = $GLOBALS['mysql']->query("SELECT * FROM fazs WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'"); $menge=0;
while($rowf = $testa->fetch_assoc()) {
$menge=$menge+$rowf['abo'];
}
$mengeO=$mengeO+$menge;
}
//----------------------------------------------------------------------------------------------------------------------------------------
$mengeG=$mengeW+$mengeN+$mengeS+$mengeO;
$template->assign('mengeW', $mengeW);
$template->assign('mengeN', $mengeN);
$template->assign('mengeS', $mengeS);
$template->assign('mengeO', $mengeO);
$template->assign('mengeG', $mengeG);
//----------------------------------------------------------------------------------------------------------------------------------------
//----------------------------------------- Veränderungen --------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------------------------------------------
$fazw_tour = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ=15 and utyp=1"); $mengeVW=0;
while($row = $fazw_tour->fetch_assoc()) {
$testa = $GLOBALS['mysql']->query("SELECT * FROM fazv WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'");
while($rowf = $testa->fetch_assoc()) {
$mengeVW++;
}
}
//----------------------------------------------------------------------------------------------------------------------------------------
$fazn_tour = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ=15 and utyp=2"); $mengeVN=0;
while($row = $fazn_tour->fetch_assoc()) {
$testa = $GLOBALS['mysql']->query("SELECT * FROM fazv WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'");
while($rowf = $testa->fetch_assoc()) {
$mengeVN++;
}
}
//----------------------------------------------------------------------------------------------------------------------------------------
$fazs_tour = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ=15 and utyp=3"); $mengeVS=0;
while($row = $fazs_tour->fetch_assoc()) {
$testa = $GLOBALS['mysql']->query("SELECT * FROM fazv WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'");
while($rowf = $testa->fetch_assoc()) {
$mengeVS++;
}
}
//----------------------------------------------------------------------------------------------------------------------------------------
$fazs_tour = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ=15 and utyp=4"); $mengeVO=0;
while($row = $fazs_tour->fetch_assoc()) {
$testa = $GLOBALS['mysql']->query("SELECT * FROM fazv WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'");
while($rowf = $testa->fetch_assoc()) {
$mengeVO++;
}
}
//----------------------------------------------------------------------------------------------------------------------------------------
$mengeVG=$mengeVW+$mengeVN+$mengeVS+$mengeVO;
$template->assign('mengeVW', $mengeVW);
$template->assign('mengeVN', $mengeVN);
$template->assign('mengeVS', $mengeVS);
$template->assign('mengeVO', $mengeVO);
$template->assign('mengeVG', $mengeVG);
//----------------------------------------------------------------------------------------------------------------------------------------
//-------------- Datensätze zählen
$data1 = $GLOBALS['mysql']->query_single("SELECT * FROM fazs WHERE kw='".$kw."' and jahr='".$jahr."'"); $datas=0;
if($data1['num_rows'] != 0) { $datas++; $template->assign('danz1', $data1['num_rows']); }
$data2 = $GLOBALS['mysql']->query_single("SELECT * FROM fazv WHERE kw='".$kw."' and jahr='".$jahr."'");
if($data2['num_rows'] != 0) { $datas++; $template->assign('danz2', $data2['num_rows']); }
if($datas != 0) { $template->assign('dataanz', $datas); }
//----------------------------------------------------------------------------------------------------------------------------------------
//-----------------------------------------------
//-----------------------------------------------
$template->assign('jahr', $jahr);
$template->assign('kw', $kw);
$template->assign('datum', $datum);
$template->assign('content', 'tpl/ifazs.tpl');
?>
Reference in a new issue View git blame Copy permalink