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

867 lines
No EOL
58 KiB
PHP
Raw Permalink Blame History

<?php
header("Content-Type: text/html; charset=utf-8");
error_reporting(E_ALL);
ini_set('display_errors', 0);
$kw_aktuell = (int)date('W');
$a_jahr = (int)date('Y');
require('lib/config.php');
session_name(CONFIG_SESSION);
session_start(); require('lib/mysql.class.php');
$GLOBALS['mysql'] = new mysql(CONFIG_MYSQL_HOST,CONFIG_MYSQL_USER,CONFIG_MYSQL_PW,CONFIG_MYSQL_DB);
//$GLOBALS['mysql']->mysql_query("SET NAMES 'utf8'");
//$GLOBALS['mysql']->mysql_query("SET CHARACTER SET 'utf8'");
// date_default_timezone_set('Europe/London');
date_default_timezone_set('Europe/Berlin');
print_r($_POST);
$dateityp = GetImageSize($_FILES['datei']['tmp_name']);
//echo $_FILES['datei']['name'];
//echo $_FILES['datei']['tmp_name'];
//echo $_FILES['datei']['size'];
//echo $_FILES['datei']['type'];
//
//move_uploaded_file($_FILES['datei']['tmp_name'],'uploads/'.$_FILES['datei']['name']);
if($_FILES['datei']['type'] == 'application/vnd.ms-excel') {
move_uploaded_file($_FILES['datei']['tmp_name'], $_FILES['datei']['name']);
echo $_FILES['datei']['name'];
$ok=1; $dat=substr($_FILES['datei']['name'], 0,6);
//-------------------------------------------------------------------------------------------------------------- Normplan !!!!!!!!!!
if ($dat=='Normpl') {
define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
require_once dirname(__FILE__) . '/lib/PHPExcel.php';
$objPHPExcel = PHPExcel_IOFactory::load($_FILES['datei']['name']);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true); $key=0; $test=0;
$key=0;
foreach ($sheetData as $index => $row) {
if ($key==00) {
$datum_arr = explode('-',$row['H']); $timestamp1 = mktime(0,0,0, $datum_arr[0] , $datum_arr[1] ,$datum_arr[2]);
// echo "<pre>"; print_r($datum_arr); echo "</pre>";
// $jahr=substr($inputFileName, -14,4); $monat=substr($inputFileName, -9,2); $tag=substr($inputFileName, -6,2); // datum aus File auslesen !
// $tmpdate=$datum_arr[2]."-".$datum_arr[1]."-".$datum_arr[0];
// $timestamp1 = strtotime("+0 day", $timestampx);
$timestamp2 = strtotime("+1 day", $timestamp1);
$timestamp3 = strtotime("+2 day", $timestamp1);
$timestamp4 = strtotime("+3 day", $timestamp1);
$timestamp5 = strtotime("+4 day", $timestamp1);
$timestamp6 = strtotime("+5 day", $timestamp1);
$kw=date('W',$timestamp1);
$tag1=date("d",$timestamp1); $monat1 = date("m",$timestamp1); $jahr1 = date("Y",$timestamp1);
$tag2=date("d",$timestamp2); $monat2 = date("m",$timestamp2); $jahr2 = date("Y",$timestamp2);
$tag3=date("d",$timestamp3); $monat3 = date("m",$timestamp3); $jahr3 = date("Y",$timestamp3);
$tag4=date("d",$timestamp4); $monat4 = date("m",$timestamp4); $jahr4 = date("Y",$timestamp4);
$tag5=date("d",$timestamp5); $monat5 = date("m",$timestamp5); $jahr5 = date("Y",$timestamp5);
$tag6=date("d",$timestamp6); $monat6 = date("m",$timestamp6); $jahr6 = date("Y",$timestamp6);
$lesetest1 = $GLOBALS['mysql']->query_single("SELECT * FROM normplan WHERE tag='".$tag1."' AND monat='".$monat1."' AND jahr='".$jahr1."'");
$lesetest2 = $GLOBALS['mysql']->query_single("SELECT * FROM normplan WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$lesetest3 = $GLOBALS['mysql']->query_single("SELECT * FROM normplan WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$lesetest4 = $GLOBALS['mysql']->query_single("SELECT * FROM normplan WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$lesetest5 = $GLOBALS['mysql']->query_single("SELECT * FROM normplan WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$lesetest6 = $GLOBALS['mysql']->query_single("SELECT * FROM normplan WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
if($lesetest1['num_rows']==0) { $GLOBALS['mysql']->insert("INSERT INTO normplan (tag,monat,jahr,kw) VALUES('".$tag1."','".$monat1."','".$jahr1."','".$kw."')"); }
if($lesetest2['num_rows']==0) { $GLOBALS['mysql']->insert("INSERT INTO normplan (tag,monat,jahr,kw) VALUES('".$tag2."','".$monat2."','".$jahr2."','".$kw."')"); }
if($lesetest3['num_rows']==0) { $GLOBALS['mysql']->insert("INSERT INTO normplan (tag,monat,jahr,kw) VALUES('".$tag3."','".$monat3."','".$jahr3."','".$kw."')"); }
if($lesetest4['num_rows']==0) { $GLOBALS['mysql']->insert("INSERT INTO normplan (tag,monat,jahr,kw) VALUES('".$tag4."','".$monat4."','".$jahr4."','".$kw."')"); }
if($lesetest5['num_rows']==0) { $GLOBALS['mysql']->insert("INSERT INTO normplan (tag,monat,jahr,kw) VALUES('".$tag5."','".$monat5."','".$jahr5."','".$kw."')"); }
if($lesetest6['num_rows']==0) { $GLOBALS['mysql']->insert("INSERT INTO normplan (tag,monat,jahr,kw) VALUES('".$tag6."','".$monat6."','".$jahr6."','".$kw."')"); }
}
if ($key==7) {
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_city='".$row['D']."' WHERE tag='".$tag1."' AND monat='".$monat1."' AND jahr='".$jahr1."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_city='".$row['G']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_city='".$row['J']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_city='".$row['M']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_city='".$row['P']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_city='".$row['S']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
if ($key==8) { // lvz_bgz
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_bgz='".$row['D']."' WHERE tag='".$tag1."' AND monat='".$monat1."' AND jahr='".$jahr1."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_bgz='".$row['G']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_bgz='".$row['J']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_bgz='".$row['M']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_bgz='".$row['P']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_bgz='".$row['S']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
if ($key==9) { // lvz_dek
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_dek='".$row['D']."' WHERE tag='".$tag1."' AND monat='".$monat1."' AND jahr='".$jahr1."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_dek='".$row['G']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_dek='".$row['J']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_dek='".$row['M']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_dek='".$row['P']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_dek='".$row['S']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
if ($key==10) { // lvz_mtk
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_mtk='".$row['D']."' WHERE tag='".$tag1."' AND monat='".$monat1."' AND jahr='".$jahr1."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_mtk='".$row['G']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_mtk='".$row['J']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_mtk='".$row['M']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_mtk='".$row['P']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_mtk='".$row['S']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
if ($key==12) { // tz
$GLOBALS['mysql']->insert("UPDATE normplan SET tz='".$row['D']."' WHERE tag='".$tag1."' AND monat='".$monat1."' AND jahr='".$jahr1."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET tz='".$row['G']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET tz='".$row['J']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET tz='".$row['M']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET tz='".$row['P']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET tz='".$row['S']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
if ($key==13) { // oaz
$GLOBALS['mysql']->insert("UPDATE normplan SET oaz='".$row['D']."' WHERE tag='".$tag1."' AND monat='".$monat1."' AND jahr='".$jahr1."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET oaz='".$row['G']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET oaz='".$row['J']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET oaz='".$row['M']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET oaz='".$row['P']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET oaz='".$row['S']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
if ($key==14) { // daz
$GLOBALS['mysql']->insert("UPDATE normplan SET daz='".$row['D']."' WHERE tag='".$tag1."' AND monat='".$monat1."' AND jahr='".$jahr1."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET daz='".$row['G']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET daz='".$row['J']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET daz='".$row['M']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET daz='".$row['P']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET daz='".$row['S']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
if ($key==15) { // ovz
$GLOBALS['mysql']->insert("UPDATE normplan SET ovz='".$row['D']."' WHERE tag='".$tag1."' AND monat='".$monat1."' AND jahr='".$jahr1."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET ovz='".$row['G']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET ovz='".$row['J']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET ovz='".$row['M']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET ovz='".$row['P']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET ovz='".$row['S']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
if ($key==16) { // dnn
$GLOBALS['mysql']->insert("UPDATE normplan SET dnn='".$row['D']."' WHERE tag='".$tag1."' AND monat='".$monat1."' AND jahr='".$jahr1."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET dnn='".$row['G']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET dnn='".$row['J']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET dnn='".$row['M']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET dnn='".$row['P']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET dnn='".$row['S']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
// echo "<pre>";
// print_r($row);
// echo "</pre>";
$key++;
} header('Location: https://edv.jb-transport.de/index.php?s=inormplan');
}
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
if ($dat=='FAS Ab') {
$jahr=substr($_FILES['datei']['name'], -6,2); $jahr=$jahr+2000; $monat=substr($_FILES['datei']['name'], -9,2); $tag=substr($_FILES['datei']['name'], -12,2); // datum aus File auslesen !
define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
require_once dirname(__FILE__) . '/lib/PHPExcel.php';
$objPHPExcel = PHPExcel_IOFactory::load($_FILES['datei']['name']);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true); $key=0; $test=0;
foreach ($sheetData as $index => $row) {
if($key == 0) {
if(isset($row['A'])) if ($row['A']=='KUNDE_MC2') { $kdname1= 2; } // kundenname = spalte A
if(isset($row['B'])) if ($row['B']=='KUNDE_MC2') { $kdname1= 3; } // kundenname = spalte B
if(isset($row['C'])) if ($row['C']=='KUNDE_MC2') { $kdname1= 4; } // kundenname = spalte C
if(isset($row['D'])) if ($row['D']=='KUNDE_MC2') { $kdname1= 5; } // kundenname = spalte D
if(isset($row['B'])) if ($row['B']=='KUNDE_MC2_ABO') { $kdname2= 2; } // kundenname 2 = spalte B
if(isset($row['C'])) if ($row['C']=='KUNDE_MC2_ABO') { $kdname2= 3; } // kundenname 2 = spalte C
if(isset($row['D'])) if ($row['D']=='KUNDE_MC2_ABO') { $kdname2= 4; } // kundenname 2 = spalte D
if(isset($row['E'])) if ($row['E']=='KUNDE_MC2_ABO') { $kdname2= 5; } // kundenname 2 = spalte E
if(isset($row['C'])) if ($row['C']=='NAME4') { $kdname3= 2; } // kundenname = spalte C
if(isset($row['D'])) if ($row['D']=='NAME4') { $kdname3= 3; } // kundenname = spalte D
if(isset($row['E'])) if ($row['E']=='NAME4') { $kdname3= 4; } // kundenname = spalte E
if(isset($row['F'])) if ($row['F']=='NAME4') { $kdname3= 5; } // kundenname = spalte F
if(isset($row['D'])) if ($row['D']=='PLZ_HS') { $kd_plz= 2; } // kd_plz = spalte D
if(isset($row['E'])) if ($row['E']=='PLZ_HS') { $kd_plz= 3; } // kd_plz = spalte E
if(isset($row['F'])) if ($row['F']=='PLZ_HS') { $kd_plz= 4; } // kd_plz = spalte F
if(isset($row['G'])) if ($row['G']=='PLZ_HS') { $kd_plz= 5; } // kd_plz = spalte G
if(isset($row['E'])) if ($row['E']=='WOHNORT_ID') { $kd_ort= 2; } // kd_ort = spalte E
if(isset($row['F'])) if ($row['F']=='WOHNORT_ID') { $kd_ort= 3; } // kd_ort = spalte F
if(isset($row['G'])) if ($row['G']=='WOHNORT_ID') { $kd_ort= 4; } // kd_ort = spalte G
if(isset($row['H'])) if ($row['H']=='WOHNORT_ID') { $kd_ort= 5; } // kd_ort = spalte H
if(isset($row['F'])) if ($row['F']=='ORTSTEIL') { $kd_oteil= 2; } // kd_oteil = spalte F
if(isset($row['G'])) if ($row['G']=='ORTSTEIL') { $kd_oteil= 3; } // kd_oteil = spalte G
if(isset($row['H'])) if ($row['H']=='ORTSTEIL') { $kd_oteil= 4; } // kd_oteil = spalte H
if(isset($row['I'])) if ($row['I']=='ORTSTEIL') { $kd_oteil= 5; } // kd_oteil = spalte I
if(isset($row['G'])) if ($row['G']=='STRASSE_ID') { $kd_strasse= 2; } // kd_strasse = spalte G
if(isset($row['H'])) if ($row['H']=='STRASSE_ID') { $kd_strasse= 3; } // kd_strasse = spalte H
if(isset($row['I'])) if ($row['I']=='STRASSE_ID') { $kd_strasse= 4; } // kd_strasse = spalte I
if(isset($row['J'])) if ($row['J']=='STRASSE_ID') { $kd_strasse= 5; } // kd_strasse = spalte J
if(isset($row['H'])) if ($row['H']=='HAUSNRV') { $kd_hnr= 2; } // kd_hnr = spalte H
if(isset($row['I'])) if ($row['I']=='HAUSNRV') { $kd_hnr= 3; } // kd_hnr = spalte I
if(isset($row['J'])) if ($row['J']=='HAUSNRV') { $kd_hnr= 4; } // kd_hnr = spalte J
if(isset($row['K'])) if ($row['K']=='HAUSNRV') { $kd_hnr= 5; } // kd_hnr = spalte K
if(isset($row['I'])) if ($row['I']=='HAUSNRV_A') { $kd_hnrz= 2; } // kd_hnrz = spalte I
if(isset($row['J'])) if ($row['J']=='HAUSNRV_A') { $kd_hnrz= 3; } // kd_hnrz = spalte J
if(isset($row['K'])) if ($row['K']=='HAUSNRV_A') { $kd_hnrz= 4; } // kd_hnrz = spalte K
if(isset($row['L'])) if ($row['L']=='HAUSNRV_A') { $kd_hnrz= 5; } // kd_hnrz = spalte L
if(isset($row['j'])) if ($row['J']=='ABO_MENGE') { $kd_amenge= 2; } // kd_amenge = spalte J
if(isset($row['K'])) if ($row['K']=='ABO_MENGE') { $kd_amenge= 3; } // kd_amenge = spalte K
if(isset($row['L'])) if ($row['L']=='ABO_MENGE') { $kd_amenge= 4; } // kd_amenge = spalte L
if(isset($row['M'])) if ($row['M']=='ABO_MENGE') { $kd_amenge= 5; } // kd_amenge = spalte M
if(isset($row['K'])) if ($row['K']=='UNT_MENGE') { $kd_umenge= 2; } // untrnge = spalte K
if(isset($row['L'])) if ($row['L']=='UNT_MENGE') { $kd_umenge= 3; } // untrnge = spalte L
if(isset($row['M'])) if ($row['M']=='UNT_MENGE') { $kd_umenge= 4; } // untrnge = spalte M
if(isset($row['N'])) if ($row['N']=='UNT_MENGE') { $kd_umenge= 5; } // untrnge = spalte N
/*
if(isset($row['L'])) if ($row['L']=='UML_MENGE') { $kd_uml= 2; } // kd_uml = spalte L
if(isset($row['M'])) if ($row['M']=='UML_MENGE') { $kd_uml= 3; } // kd_uml = spalte M
if(isset($row['N'])) if ($row['N']=='UML_MENGE') { $kd_uml= 4; } // kd_uml = spalte N
if(isset($row['O'])) if ($row['O']=='UML_MENGE') { $kd_uml= 5; } // kd_uml = spalte O
*/
if(isset($row['M'])) if ($row['M']=='FMLD_NR') { $kd_tel= 2; } // kd_tel = spalte M
if(isset($row['N'])) if ($row['N']=='FMLD_NR') { $kd_tel= 3; } // kd_tel = spalte N
if(isset($row['O'])) if ($row['O']=='FMLD_NR') { $kd_tel= 4; } // kd_tel = spalte O
if(isset($row['P'])) if ($row['P']=='FMLD_NR') { $kd_tel= 5; } // kd_tel = spalte P
if(isset($row['N'])) if ($row['N']=='LIEF_HINW') { $kd_hinw= 2; } // kd_hinw = spalte N
if(isset($row['O'])) if ($row['O']=='LIEF_HINW') { $kd_hinw= 3; } // kd_hinw = spalte O
if(isset($row['P'])) if ($row['P']=='LIEF_HINW') { $kd_hinw= 4; } // kd_hinw = spalte P
if(isset($row['Q'])) if ($row['Q']=='LIEF_HINW') { $kd_hinw= 5; } // kd_hinw = spalte Q
$key++;
} else { //------------ ab. 1. datensatz
if($test == 0) {
$row_faz = $GLOBALS['mysql']->query_single("SELECT * FROM faz WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
if($row_faz['num_rows'] > 0) {
$GLOBALS['mysql']->query("DELETE FROM faz WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
$test=1;
}
}
if ($kdname1==2) { $data_kdname1=$row['A']; }
if ($kdname1==3) { $data_kdname1=$row['B']; }
if ($kdname1==4) { $data_kdname1=$row['C']; }
if ($kdname1==5) { $data_kdname1=$row['D']; }
if ($kdname2==2) { $data_kdname2=$row['B']; }
if ($kdname2==3) { $data_kdname2=$row['C']; }
if ($kdname2==4) { $data_kdname2=$row['D']; }
if ($kdname2==5) { $data_kdname2=$row['E']; }
if ($kdname3==2) { $data_kdname3=$row['C']; }
if ($kdname3==3) { $data_kdname3=$row['D']; }
if ($kdname3==4) { $data_kdname3=$row['E']; }
if ($kdname3==5) { $data_kdname3=$row['F']; }
if ($kd_plz==2) { $data_kd_plz=$row['D']; }
if ($kd_plz==3) { $data_kd_plz=$row['E']; }
if ($kd_plz==4) { $data_kd_plz=$row['F']; }
if ($kd_plz==5) { $data_kd_plz=$row['G']; }
if ($kd_ort==2) { $data_kd_ort=$row['E']; }
if ($kd_ort==3) { $data_kd_ort=$row['F']; } //
if ($kd_ort==4) { $data_kd_ort=$row['G']; } //
if ($kd_ort==5) { $data_kd_ort=$row['H']; } //
if ($kd_oteil==2) { $data_kd_oteil=$row['F']; } // kd_oteil = spalte F
if ($kd_oteil==3) { $data_kd_oteil=$row['G']; } // kd_oteil = spalte G
if ($kd_oteil==4) { $data_kd_oteil=$row['H']; } // kd_oteil = spalte H
if ($kd_oteil==5) { $data_kd_oteil=$row['I']; } // kd_oteil = spalte I
if ($kd_strasse==2) { $data_kd_strasse=$row['G']; } // kd_strasse = spalte G
if ($kd_strasse==3) { $data_kd_strasse=$row['H']; } // kd_strasse = spalte H
if ($kd_strasse==4) { $data_kd_strasse=$row['I']; } // kd_strasse = spalte I
if ($kd_strasse==5) { $data_kd_strasse=$row['J']; } // kd_strasse = spalte J
if ($kd_hnr==2) { $data_kd_hnr=$row['H']; } // kd_hnr = spalte H
if ($kd_hnr==3) { $data_kd_hnr=$row['I']; } // kd_hnr = spalte I
if ($kd_hnr==4) { $data_kd_hnr=$row['J']; } // kd_hnr = spalte J
if ($kd_hnr==5) { $data_kd_hnr=$row['K']; } // kd_hnr = spalte K
if ($kd_hnrz==2) { $data_kd_hnrz=$row['I']; } // kd_hnrz = spalte I
if ($kd_hnrz==3) { $data_kd_hnrz=$row['J']; } // kd_hnrz = spalte J
if ($kd_hnrz==4) { $data_kd_hnrz=$row['K']; } // kd_hnrz = spalte K
if ($kd_hnrz==5) { $data_kd_hnrz=$row['L']; } // kd_hnrz = spalte L
if ($kd_amenge==2) { $data_kd_amenge=$row['J']; } // kd_amenge = spalte J
if ($kd_amenge==3) { $data_kd_amenge=$row['K']; } // kd_amenge = spalte K
if ($kd_amenge==4) { $data_kd_amenge=$row['L']; } // kd_amenge = spalte L
if ($kd_amenge==5) { $data_kd_amenge=$row['M']; } // kd_amenge = spalte M
if ($kd_umenge==2) { $data_kd_umenge=$row['K']; } // untrnge = spalte K
if ($kd_umenge==3) { $data_kd_umenge=$row['L']; } // untrnge = spalte L
if ($kd_umenge==4) { $data_kd_umenge=$row['M']; } // untrnge = spalte M
if ($kd_umenge==5) { $data_kd_umenge=$row['N']; } // untrnge = spalte N
/*
if ($kd_uml==2) { $data_kd_uml=$row['L']; } // kd_uml = spalte L
if ($kd_uml==3) { $data_kd_uml=$row['M']; } // kd_uml = spalte M
if ($kd_uml==4) { $data_kd_uml=$row['N']; } // kd_uml = spalte N
if ($kd_uml==5) { $data_kd_uml=$row['O']; } // kd_uml = spalte O
*/
if ($kd_tel==2) { $data_kd_tel=$row['M']; } // kd_tel = spalte M
if ($kd_tel==3) { $data_kd_tel=$row['N']; } // kd_tel = spalte N
if ($kd_tel==4) { $data_kd_tel=$row['O']; } // kd_tel = spalte O
if ($kd_tel==5) { $data_kd_tel=$row['P']; } // kd_tel = spalte P
if ($kd_hinw==2) { $data_kd_hinw=$row['N']; } // kd_hinw = spalte N
if ($kd_hinw==3) { $data_kd_hinw=$row['O']; } // kd_hinw = spalte O
if ($kd_hinw==4) { $data_kd_hinw=$row['P']; } // kd_hinw = spalte P
if ($kd_hinw==5) { $data_kd_hinw=$row['Q']; } // kd_hinw = spalte Q
// echo $data_kdname1;
$plzstelle=strlen($data_kd_plz);
if($plzstelle==5) { $data_kd_plz = substr($data_kd_plz, -4); }
$GLOBALS['mysql']->insert("INSERT INTO faz (tag,monat,jahr,name,name2,name3,plz,ort,ortsteil,strasse,hnr,hnrz,abo,pause,telefon,bemerkung)
VALUES(
'".$tag."',
'".$monat."',
'".$jahr."',
'".utf8_decode ($data_kdname1)."',
'".utf8_decode ($data_kdname2)."',
'".utf8_decode ($data_kdname3)."',
'".$data_kd_plz."',
'".utf8_decode ($data_kd_ort)."',
'".utf8_decode ($data_kd_oteil)."',
'".utf8_decode ($data_kd_strasse)."',
'".$data_kd_hnr."',
'".$data_kd_hnrz."',
'".$data_kd_amenge."',
'".$data_kd_umenge."',
'".$data_kd_tel."',
'".utf8_decode ($data_kd_hinw)."')
");
$key++;
}
} header('Location: https://edv.jb-transport.de/index.php?s=ifaz');
}
//------------------------------------------------------------------------------------------------------------------------------- GEWICHTE
/*
if ($dat=='Gewich') {
define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
require_once dirname(__FILE__) . '/lib/PHPExcel.php';
$objPHPExcel = PHPExcel_IOFactory::load($_FILES['datei']['name']);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
$auslese = $sheetData;
foreach ($sheetData as $index => $rowa) {
$auslese_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE tour2='".$rowa['A']."' AND tour2!=''");
if($auslese_tour['num_rows'] > 0) {
if($auslese_tour['typ'] == 7) { $wtyp=7; break; } //-------- Rundschau
if($auslese_tour['typ'] == 8) { $wtyp=8; break; } //-------- saso
if($auslese_tour['typ'] ==11) { $wtyp=11; } //-------- Werbung
// break;
}
}
//---------------------------- end gewicht lesen und speichern
$lasttour=0; $key=0; $tmp_data=''; $ltour=0;
foreach ($sheetData as $index => $row) {
// if($ltour==1) { $lasttour=0; $ltour==0; }
if($row['A']!='Tour' || $row['A']!='Created by Online2PDF.com') {
if($row['A']!='') {
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE typ='".$wtyp."' AND tour2='".$row['A']."'");
if(isset($row_tour['id'])) {
$lasttour=$row_tour['id'];
if(isset($row['Z'])) { $alg=$row['Z']; }
elseif(isset($row['Y'])) { $alg=$row['Y']; }
elseif(isset($row['X'])) { $alg=$row['X']; }
elseif(isset($row['W'])) { $alg=$row['W']; }
elseif(isset($row['V'])) { $alg=$row['V']; }
elseif(isset($row['U'])) { $alg=$row['U']; }
elseif(isset($row['T'])) { $alg=$row['T']; }
elseif(isset($row['S'])) { $alg=$row['S']; }
elseif(isset($row['R'])) { $alg=$row['R']; }
elseif(isset($row['Q'])) { $alg=$row['Q']; }
elseif(isset($row['P'])) { $alg=$row['P']; }
elseif(isset($row['O'])) { $alg=$row['O']; }
elseif(isset($row['N'])) { $alg=$row['N']; }
elseif(isset($row['M'])) { $alg=$row['M']; }
elseif(isset($row['L'])) { $alg=$row['L']; }
elseif(isset($row['K'])) { $alg=$row['K']; }
} else { $lasttour=0 ; }
} elseif($lasttour>0) { // wichtig für den ersten Datensatz
if(isset($row['Z'])) { $alg=$row['Z']; }
elseif(isset($row['Y'])) { $alg=$row['Y']; }
elseif(isset($row['X'])) { $alg=$row['X']; }
elseif(isset($row['W'])) { $alg=$row['W']; }
elseif(isset($row['V'])) { $alg=$row['V']; }
elseif(isset($row['U'])) { $alg=$row['U']; }
elseif(isset($row['T'])) { $alg=$row['T']; }
elseif(isset($row['S'])) { $alg=$row['S']; }
elseif(isset($row['R'])) { $alg=$row['R']; }
elseif(isset($row['Q'])) { $alg=$row['Q']; }
elseif(isset($row['P'])) { $alg=$row['P']; }
elseif(isset($row['O'])) { $alg=$row['O']; }
elseif(isset($row['N'])) { $alg=$row['N']; }
elseif(isset($row['M'])) { $alg=$row['M']; }
elseif(isset($row['L'])) { $alg=$row['L']; }
elseif(isset($row['K'])) { $alg=$row['K']; }
// $ltour=1;
}
if(isset($alg)) {
$x=strlen($alg); $tmpdata=""; $wert=1; //echo $row['A']."-".$tmp_data."*";
echo $x."~";
if($x==7) { $tmpdata = substr($alg,1,3); if(substr($alg,5,1)>4) { $tmpdata++; }}
// if($x==7 && $wtyp == 7) { $tmpdata = substr($alg,0,3); if(substr($alg,4,1)>4) { $tmpdata++; }}
if($x==8) { $tmpdata = substr($alg,0,1).substr($alg,2,3); if(substr($alg,7,1)>4) { $tmpdata++; }}
if($x>10 || $wtyp == 8) { $tmpdata = substr($alg,-8,1).substr($alg,-6,3); if(substr($alg-2,1)>4) { $tmpdata++; }}
// $tmp=substr($tmpdata,-4,1); if ($tmp=".") { $gewicht=substr($tmpdata,-5,1).substr($tmpdata,-3,3); } else { $gewicht=$tmpdata; }
echo $tmpdata."-";
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht='".$tmpdata."' WHERE kw='".$kw_aktuell."' AND jahr='".$a_jahr."' AND tour='".$lasttour."'");
$auslese_test = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste_all WHERE kw='".$kw_aktuell."' AND jahr='".$a_jahr."' AND tour='".$lasttour."'");
if($auslese_test['num_rows'] != 0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste_all SET gewicht='".$tmpdata."' WHERE kw='".$kw_aktuell."' AND jahr='".$a_jahr."' AND tour='".$lasttour."'");
} else {
$auslese_data = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE kw='".$kw_aktuell."' AND jahr='".$a_jahr."' AND tour='".$lasttour."'");
if(isset($auslese_data['tour'])) {
$GLOBALS['mysql']->insert("INSERT INTO tourenliste_all (tag,monat,jahr,kw,gewicht4,exemplare,zeit,tour,gewicht)
VALUES(
'".$auslese_data['tag']."',
'".$auslese_data['monat']."',
'".$auslese_data['jahr']."',
'".$auslese_data['kw']."',
'".$auslese_data['gewicht4']."',
'".$auslese_data['exemplare']."',
'".$auslese_data['zeit']."',
'".$auslese_data['tour']."',
'".$tmpdata."')
");
}
}
}
}
}
// if ($wtyp== 7) { header('Location: https://edv.jb-transport.de/index.php?s=irundschau&info=1'); }
// if ($wtyp== 8) { header('Location: https://edv.jb-transport.de/index.php?s=psaso&info=1'); }
// if ($wtyp==11) { header('Location: https://edv.jb-transport.de/index.php?s=iwerbung&info=1'); }
if ($wtyp== 7) { header('Location: https://edv.jb-transport.de/index.php?s=irundschau&info=1'); }
if ($wtyp== 8) { header('Location: https://edv.jb-transport.de/index.php?s=psaso&info=1'); }
if ($wtyp==11) { header('Location: https://edv.jb-transport.de/index.php?s=iwerbung&info=1'); }
}
/*
$key=0; $wtyp=0; $lasttyp=0; $lasttour=0; $tmp_data=''; $wert=0;
foreach ($sheetData as $index => $row) {
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE tour2='".$row['A']."' AND tour2!=''");
if($row_tour['num_rows'] > 0) {
if($row_tour['typ'] == 7) { if($row['X']=='') { $tmp_data=$row['V']; }else{ $tmp_data=$row['X']; } $wtyp=7; } //-------- Rundschau
if($row_tour['typ'] == 8) { $tmp_data=$row['S']; $wtyp=8; } //-------- saso
if($row_tour['typ'] ==11) { $tmp_data=$row['X']; $wtyp=11; } //-------- Werbung
$lasttour=$row_tour['id']; $lasttyp=$row_tour['typ'];
$x=strlen($tmp_data); $tmpdata =""; $wert=1; //echo $row['A']."-".$tmp_data."*";
if($x==7) { $tmpdata = substr($tmp_data,1,3); if(substr($tmp_data,5,1)>4) { $tmpdata++; }}
if($x==7 && $lasttyp == 7) { $tmpdata = substr($tmp_data,0,3); if(substr($tmp_data,4,1)>4) { $tmpdata++; }}
if($x==8) { $tmpdata = substr($tmp_data,0,1).substr($tmp_data,2,3); if(substr($tmp_data,7,1)>4) { $tmpdata++; }}
if($x>10 || $lasttyp == 8) { $tmpdata = substr($tmp_data,-8,1).substr($tmp_data,-6,3); if(substr($tmp_data,-2,1)>4) { $tmpdata++; }}
// $tmp=substr($tmpdata,-4,1); if ($tmp=".") { $gewicht=substr($tmpdata,-5,1).substr($tmpdata,-3,3); } else { $gewicht=$tmpdata; }
$gewicht=$tmpdata; echo "-".$tmpdata."-";
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht='".$gewicht."' WHERE kw='".$kw_aktuell."' AND jahr='".$a_jahr."' AND tour='".$row_tour['id']."'");
//-----------------------------
} else {
if($wert==1 || $lasttyp!=7) {
if($lasttyp!=8) {
if($lasttyp == 7) { if($row['X']=='') { $tmp_data=$row['V']; }else{ $tmp_data=$row['X']; } $wtyp=7; } //-------- Rundschau
if($lasttyp == 8) { $tmp_data=$row['S']; $wtyp=8; } //-------- saso
if($lasttyp ==11) { $tmp_data=$row['X']; $wtyp=11; } //-------- Werbung
if($row['A']=='' && $tmp_data!='') {
$x=strlen($tmp_data); $tmpdata =""; $wert=0; //echo $tmp_data."++";
if($x==7 && $lasttyp == 7) { $tmpdata = substr($tmp_data,0,3); if(substr($tmp_data,4,1)>4) { $tmpdata++; }}
if($x==7) { $tmpdata = substr($tmp_data,1,3); if(substr($tmp_data,5,1)>4) { $tmpdata++; }}
if($x==8) { $tmpdata = substr($tmp_data,0,1).substr($tmp_data,2,3); if(substr($tmp_data,6,1)>4) { $tmpdata++; }}
// $tmp=substr($tmpdata,-4,1); if ($tmp=".") { $gewicht=substr($tmpdata,-5,1).substr($tmpdata,-3,3); } else { $gewicht=$tmpdata; }
$gewicht=$tmpdata; echo "*".$tmpdata."*";
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht='".$gewicht."' WHERE kw='".$kw_aktuell."' AND jahr='".$a_jahr."' AND tour='".$row_tour['id']."'");
}
}
}
}
//-----------------------------
$key++;
}
if ($wtyp== 7) { header('Location: https://edv.jb-transport.de/index.php?s=irundschau'); }
if ($wtyp== 8) { header('Location: https://edv.jb-transport.de/index.php?s=psaso'); }
if ($wtyp==11) { header('Location: https://edv.jb-transport.de/index.php?s=iwerbung'); }
}
*/
//-----------------------------------------------------------
//------------------------------------Gewichte neu
if ($dat=='Gewich') {
define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
require_once dirname(__FILE__) . '/lib/PHPExcel.php';
$objPHPExcel = PHPExcel_IOFactory::load($_FILES['datei']['name']);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
$auslese = $sheetData;
foreach ($sheetData as $index => $rowa) {
$auslese_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE tour3='".$rowa['C']."' AND tour2!=''");
if($auslese_tour['num_rows'] > 0) {
if($auslese_tour['typ'] == 7) { $wtyp=7; break; } //-------- Rundschau
if($auslese_tour['typ'] == 8) { $wtyp=8; break; } //-------- saso
if($auslese_tour['typ'] ==11) { $wtyp=11; } //-------- Werbung
if($auslese_tour['typ'] ==19) { $wtyp=19; } //-------- saso neu
// break;
}
}
//---------------------------- end gewicht lesen und speichern
$lasttour=0; $key=0; $tmp_data=''; $ltour=0; $wtyp=0;
foreach ($sheetData as $index => $row) {
echo'<pre>'; print_r($row); echo'</pre>';
// if($ltour==1) { $lasttour=0; $ltour==0; }
if($row['C']!='') {
$tmpvar=substr($row['C'],0,-9);
if($wtyp==11) {
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE typ=11 AND tour3='".$tmpvar."' OR typ=14 AND tour3='".$tmpvar."'");
} else {
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE typ='".$wtyp."' AND tour3='".$tmpvar."'");
}
if(isset($row_tour['id'])) { $alg=$row['F']; $lasttour=$row_tour['id']; }
}
if(isset($alg)) {
$x=strlen($alg); $tmpdata=""; $wert=1; //echo $row['A']."-".$tmp_data."*";
echo $x."~";
if($x==7) { $tmpdata = substr($alg,1,3); if(substr($alg,5,1)>4) { $tmpdata++; }}
// if($x==7 && $wtyp == 7) { $tmpdata = substr($alg,0,3); if(substr($alg,4,1)>4) { $tmpdata++; }}
if($x==8) { $tmpdata = substr($alg,0,1).substr($alg,2,3); if(substr($alg,7,1)>4) { $tmpdata++; }}
if($x>10 || $wtyp == 8) { $tmpdata = substr($alg,-8,1).substr($alg,-6,3); if(substr($alg-2,1)>4) { $tmpdata++; }}
if($x>10 || $wtyp =19) { $tmpdata = substr($alg,-8,1).substr($alg,-6,3); if(substr($alg-2,1)>4) { $tmpdata++; }}
// $tmp=substr($tmpdata,-4,1); if ($tmp=".") { $gewicht=substr($tmpdata,-5,1).substr($tmpdata,-3,3); } else { $gewicht=$tmpdata; }
echo $tmpdata."-";
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht='".$tmpdata."' WHERE kw='".$kw_aktuell."' AND jahr='".$a_jahr."' AND tour='".$lasttour."'");
$auslese_test = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste_all WHERE kw='".$kw_aktuell."' AND jahr='".$a_jahr."' AND tour='".$lasttour."'");
if($auslese_test['num_rows'] != 0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste_all SET gewicht='".$tmpdata."' WHERE kw='".$kw_aktuell."' AND jahr='".$a_jahr."' AND tour='".$lasttour."'");
} else {
$auslese_data = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE kw='".$kw_aktuell."' AND jahr='".$a_jahr."' AND tour='".$lasttour."'");
if(isset($auslese_data['tour'])) {
$GLOBALS['mysql']->insert("INSERT INTO tourenliste_all (tag,monat,jahr,kw,gewicht4,exemplare,zeit,tour,gewicht)
VALUES(
'".$auslese_data['tag']."',
'".$auslese_data['monat']."',
'".$auslese_data['jahr']."',
'".$auslese_data['kw']."',
'".$auslese_data['gewicht4']."',
'".$auslese_data['exemplare']."',
'".$auslese_data['zeit']."',
'".$auslese_data['tour']."',
'".$tmpdata."')
");
}
}
}
}
if ($wtyp== 7) { header('Location: https://edv.jb-transport.de/index.php?s=irundschau&info=1'); }
if ($wtyp== 8) { header('Location: https://edv.jb-transport.de/index.php?s=psaso&info=1'); }
if ($wtyp==11) { header('Location: https://edv.jb-transport.de/index.php?s=iwerbung&info=1'); }
}
//-----------------------------------------------------------
//-----------------------------------------------------------
//------------------------------------Gewichte neu
if ($dat=='Sasoneu') {
define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
require_once dirname(__FILE__) . '/lib/PHPExcel.php';
$objPHPExcel = PHPExcel_IOFactory::load($_FILES['datei']['name']);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
$auslese = $sheetData;
//---------------------------- end gewicht lesen und speichern
$lasttour=0; $key=0; $tmp_data=''; $ltour=0; $wtyp=0;
foreach ($sheetData as $index => $row) {
//-------------------------------------------------------
echo'<pre>'; print_r($row); echo'</pre>';
// if($ltour==1) { $lasttour=0; $ltour==0; }
if($row['B']!='') {
$tmpvar=substr($row['B'],0,-9); echo $tmpvar;
if($wtyp==11) {
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE typ=11 AND tour3='".$tmpvar."' OR typ=14 AND tour3='".$tmpvar."'");
} else {
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE typ='".$wtyp."' AND tour3='".$tmpvar."'");
}
if(isset($row_tour['id'])) { $alg=$row['D']; $lasttour=$row_tour['id']; }
}
if(isset($alg)) {
$x=strlen($alg); $tmpdata=""; $wert=1; //echo $row['A']."-".$tmp_data."*";
echo $x."~";
if($x==7) { $tmpdata = substr($alg,1,3); if(substr($alg,5,1)>4) { $tmpdata++; }}
// if($x==7 && $wtyp == 7) { $tmpdata = substr($alg,0,3); if(substr($alg,4,1)>4) { $tmpdata++; }}
if($x==8) { $tmpdata = substr($alg,0,1).substr($alg,2,3); if(substr($alg,7,1)>4) { $tmpdata++; }}
if($x>10 || $wtyp == 8) { $tmpdata = substr($alg,-8,1).substr($alg,-6,3); if(substr($alg-2,1)>4) { $tmpdata++; }}
if($x>10 || $wtyp =19) { $tmpdata = substr($alg,-8,1).substr($alg,-6,3); if(substr($alg-2,1)>4) { $tmpdata++; }}
// $tmp=substr($tmpdata,-4,1); if ($tmp=".") { $gewicht=substr($tmpdata,-5,1).substr($tmpdata,-3,3); } else { $gewicht=$tmpdata; }
echo $tmpdata."-";
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht='".$tmpdata."' WHERE kw='".$kw_aktuell."' AND jahr='".$a_jahr."' AND tour='".$lasttour."'");
$auslese_test = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste_all WHERE kw='".$kw_aktuell."' AND jahr='".$a_jahr."' AND tour='".$lasttour."'");
if($auslese_test['num_rows'] != 0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste_all SET gewicht='".$tmpdata."' WHERE kw='".$kw_aktuell."' AND jahr='".$a_jahr."' AND tour='".$lasttour."'");
} else {
$auslese_data = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE kw='".$kw_aktuell."' AND jahr='".$a_jahr."' AND tour='".$lasttour."'");
if(isset($auslese_data['tour'])) {
$GLOBALS['mysql']->insert("INSERT INTO tourenliste_all (tag,monat,jahr,kw,gewicht4,exemplare,zeit,tour,gewicht)
VALUES(
'".$auslese_data['tag']."',
'".$auslese_data['monat']."',
'".$auslese_data['jahr']."',
'".$auslese_data['kw']."',
'".$auslese_data['gewicht4']."',
'".$auslese_data['exemplare']."',
'".$auslese_data['zeit']."',
'".$auslese_data['tour']."',
'".$tmpdata."')
");
}
}
}
}
if ($wtyp== 7) { header('Location: https://edv.jb-transport.de/index.php?s=irundschau&info=1'); }
if ($wtyp== 8) { header('Location: https://edv.jb-transport.de/index.php?s=psaso&info=1'); }
if ($wtyp==11) { header('Location: https://edv.jb-transport.de/index.php?s=iwerbung&info=1'); }
}
//-----------------------------------------------------------
//------------------------------------------------- RUNDSCHAU Daten
if ($dat=='Rundsc') {
$jahrtest=substr($_FILES['datei']['name'], -14,4);
if ($jahrtest==date("Y") OR $jahrtest==date("Y")+1) {
$jahr=substr($_FILES['datei']['name'], -14,4); $monat=substr($_FILES['datei']['name'], -9,2); $tag=substr($_FILES['datei']['name'], -6,2); // datum aus File auslesen !
} else {
$jahr=substr($_FILES['datei']['name'], -15,4); $monat=substr($_FILES['datei']['name'], -10,2); $tag=substr($_FILES['datei']['name'], -7,2); // datum aus File auslesen !
}
define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
require_once dirname(__FILE__) . '/lib/PHPExcel.php';
$objPHPExcel = PHPExcel_IOFactory::load($_FILES['datei']['name']);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
$key=0;
foreach ($sheetData as $index => $row) {
$data=substr($row['A'], 0,6);
if($data=="City N") { $data2 =substr($row['A'], 16,2); }
if($data=="City W") { $data3 =substr($row['A'], 16,2); }
if($data=="City N") { $data4 =substr($row['A'], 16,2); }
if($data=="City S") { $data5 =substr($row['A'], 16,2); }
if($data=="Osterl") { $data6 =substr($row['A'], 16,2); }
if($data=="City N") { $data7 =substr($row['A'], 16,2); }
if($data=="Borna/") { $data8 =substr($row['A'], 16,2); }
if($data=="Grimma") { $data9 =substr($row['A'], 16,2); }
if($data=="Wurzen") { $data10=substr($row['A'], 16,2); }
if($data=="Delitz") { $data11=substr($row['A'], 16,2); }
if($data=="Eilenb") { $data12=substr($row['A'], 16,2); }
if($data=="Döbel") { $data13=substr($row['A'], 16,2); }
if($data=="Oschat") { $data14=substr($row['A'], 16,2); }
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE tour3='".$row['C']."'");
if($row_tour['num_rows'] > 0) {
if($row_tour['utyp']==2) { $GLOBALS['mysql']->insert("UPDATE tourenliste SET Norm='".$data2."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'"); }
if($row_tour['utyp']==3) { $GLOBALS['mysql']->insert("UPDATE tourenliste SET Norm='".$data3."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'"); }
if($row_tour['utyp']==4) { $GLOBALS['mysql']->insert("UPDATE tourenliste SET Norm='".$data4."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'"); }
if($row_tour['utyp']==5) { $GLOBALS['mysql']->insert("UPDATE tourenliste SET Norm='".$data5."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'"); }
$tmp=substr($row['D'],-4,1); $exemplare=0;
if ($tmp=".") {
$x=strlen($row['D']);
if($x==5) { $exemplare=substr($row['D'],-5,1).substr($row['D'],-3,3); }
if($x==6) { $exemplare=substr($row['D'],-6,2).substr($row['D'],-3,3); }
} else { $exemplare=$row['D']; }
$GLOBALS['mysql']->insert("UPDATE tourenliste SET exemplare='".$exemplare."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
$tmp=substr($row['F'],-4,1); if ($tmp=".") { $gewicht=substr($row['F'],-5,1).substr($row['F'],-3,3); } else { $exemplare=$row['F']; }
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht4='".$gewicht."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET zeit='".$row['H']."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
}
$key++;
} header('Location: https://edv.jb-transport.de/index.php?s=irundschau');
}
//------------------------------------------------- Werbung
if ($dat=='Exxtra') {
echo "extra";
$jahrtest=substr($_FILES['datei']['name'], -14,4);
if ($jahrtest==date("Y") OR $jahrtest==date("Y")+1) {
$jahr=substr($_FILES['datei']['name'], -14,4); $monat=substr($_FILES['datei']['name'], -9,2); $tag=substr($_FILES['datei']['name'], -6,2); // datum aus File auslesen !
} else {
$jahr=substr($_FILES['datei']['name'], -15,4); $monat=substr($_FILES['datei']['name'], -10,2); $tag=substr($_FILES['datei']['name'], -7,2); // datum aus File auslesen !
}
// $tagp = strtotime("-1 day",mktime(0, 0, 0,$tmpmonat,$tmptag,$tmpjahr)); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp)
$tagp = strtotime("-1 day",mktime(0, 0, 0,$monat,$tag,$jahr)); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp);
define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
require_once dirname(__FILE__) . '/lib/PHPExcel.php';
$objPHPExcel = PHPExcel_IOFactory::load($_FILES['datei']['name']);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
$key=0;
foreach ($sheetData as $index => $row) {
$data=substr($row['A'], 0,6); if($data=="Exxtra") { $data2 =substr($row['A'], 16,2); } //--------------- norm auslesen
$lasttour=0; //-------- test
/*
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE tour='".$row['A']."'");
if($row_tour['num_rows'] > 0) { $lasttour=$row_tour['id']; }
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE tour='".$row['B']."'");
if($row_tour['num_rows'] > 0) { $lasttour=$row_tour['id']; }
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE tour='".$row['C']."'");
if($row_tour['num_rows'] > 0) { $lasttour=$row_tour['id']; }
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE tour='".$row['D']."'");
if($row_tour['num_rows'] > 0) { $lasttour=$row_tour['id']; }
*/
//----------------------------------------------------
$d_tourname =$row['C'];
$d_exemplare=$row['D'];
$d_g_gewicht=$row['F'];
$d_uhrzeit = $row['H'];
//----------------------------------------------------
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE tour3='".$d_tourname."'");
if($row_tour['num_rows'] > 0) { $lasttour=$row_tour['id']; }
if($lasttour > 1) {
//echo $lasttour;
if($row_tour['utyp']>0 && $row_tour['aktiv']>0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste SET Norm='".$data2."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
}
$tmp=substr($d_exemplare,-4,1); $exemplare=0;
if ($tmp=".") {
$x=strlen($d_exemplare);
if($x==5) { $exemplare=substr($d_exemplare,-5,1).substr($d_exemplare,-3,3); }
if($x==6) { $exemplare=substr($d_exemplare,-6,2).substr($d_exemplare,-3,3); }
} else { $exemplare=$d_exemplare; }
$GLOBALS['mysql']->insert("UPDATE tourenliste SET exemplare='".$exemplare."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
$tmp=substr($d_g_gewicht,-4,1); if ($tmp=".") { $gewicht=substr($d_g_gewicht,-5,1).substr($d_g_gewicht,-3,3); }
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht4='".$gewicht."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET zeit='".$d_uhrzeit."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
$teile = explode(":", $d_uhrzeit);
$stellzeit=mktime($teile[0],$teile[1], 0,$monat,$tag,$jahr);
$GLOBALS['mysql']->insert("UPDATE tourenliste SET timestamp='".date("Y-m-d H:i:s", $stellzeit)."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET time='".$stellzeit."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
/*
} else { //------------- verschoben ab 2. seite
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE tour='".$row['A']."'");
if($row_tour['num_rows'] > 0) {
if($row_tour['utyp']>0 && $row_tour['aktiv']>0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste SET Norm='".$data2."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
}
$tmp=substr($row['B'],-4,1); $exemplare=0;
if ($tmp=".") {
$x=strlen($row['B']);
if($x==5) { $exemplare=substr($row['B'],-5,1).substr($row['B'],-3,3); }
if($x==6) { $exemplare=substr($row['B'],-6,2).substr($row['B'],-3,3); }
} else { $exemplare=$row['B']; }
$GLOBALS['mysql']->insert("UPDATE tourenliste SET exemplare='".$exemplare."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
$tmp=substr($row['E'],-4,1); if ($tmp=".") { $gewicht=substr($row['E'],-5,1).substr($row['E'],-3,3); }
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht4='".$gewicht."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET zeit='".$row['H']."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
}
*/
}
$key++;
} header('Location: https://edv.jb-transport.de/index.php?s=iwerbung');
}
//------------------------------------------------- Sachsen Sonntag
if ($dat=='Sachse') {
$jahrtest=substr($_FILES['datei']['name'], -14,4);
if ($jahrtest==date("Y") OR $jahrtest==date("Y")+1) {
$jahr=substr($_FILES['datei']['name'], -14,4); $monat=substr($_FILES['datei']['name'], -9,2); $tag=substr($_FILES['datei']['name'], -6,2); // datum aus File auslesen !
} else {
$jahr=substr($_FILES['datei']['name'], -15,4); $monat=substr($_FILES['datei']['name'], -10,2); $tag=substr($_FILES['datei']['name'], -7,2); // datum aus File auslesen !
}
define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
require_once dirname(__FILE__) . '/lib/PHPExcel.php';
$objPHPExcel = PHPExcel_IOFactory::load($_FILES['datei']['name']);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
$key=0;
foreach ($sheetData as $index => $row) {
$data=substr($row['A'], 0,4);
if($data=="City") { $data2 =substr($row['A'], 16,2); }
if($data=="Born") { $data3 =substr($row['A'], 16,2); }
if($data=="Oste") { $data4 =substr($row['A'], 16,2); }
if($data=="Deli") { $data5 =substr($row['A'], 16,2); }
if($data=="Eile") { $data6 =substr($row['A'], 16,2); }
if($data=="Grim") { $data7 =substr($row['A'], 16,2); }
if($data=="Wurz") { $data8 =substr($row['A'], 16,2); }
if($data=="Döbe") { $data9 =substr($row['A'], 16,2); }
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE tour3='".$row['C']."' AND aktiv>0");
if($row_tour['num_rows'] > 0) {
if($row_tour['utyp']==1){ $GLOBALS['mysql']->insert("UPDATE tourenliste SET Norm='".$data2."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'"); }
if($row_tour['utyp']==2){ $GLOBALS['mysql']->insert("UPDATE tourenliste SET Norm='".$data3."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'"); }
if($row_tour['utyp']==3){ $GLOBALS['mysql']->insert("UPDATE tourenliste SET Norm='".$data4."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'"); }
if($row_tour['utyp']==4){ $GLOBALS['mysql']->insert("UPDATE tourenliste SET Norm='".$data5."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'"); }
if($row_tour['utyp']==5){ $GLOBALS['mysql']->insert("UPDATE tourenliste SET Norm='".$data6."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'"); }
if($row_tour['utyp']==6){ $GLOBALS['mysql']->insert("UPDATE tourenliste SET Norm='".$data7."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'"); }
if($row_tour['utyp']==7){ $GLOBALS['mysql']->insert("UPDATE tourenliste SET Norm='".$data8."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'"); }
if($row_tour['utyp']==8){ $GLOBALS['mysql']->insert("UPDATE tourenliste SET Norm='".$data9."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'"); }
//---------------------------------------------- saso spalen
$tmp=substr($row['D'],-4,1); $exemplare=0;
if ($tmp=".") {
$x=strlen($row['D']);
if($x==5) { $exemplare=substr($row['D'],-5,1).substr($row['D'],-3,3); }
if($x==6) { $exemplare=substr($row['D'],-6,2).substr($row['D'],-3,3); }
} else { $exemplare=$row['D']; }
$GLOBALS['mysql']->insert("UPDATE tourenliste SET exemplare='".$exemplare."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
$tmp=substr($row['F'],-4,1); if ($tmp=".") { $gewicht=substr($row['F'],-5,1).substr($row['F'],-3,3); } else { $exemplare=$row['F']; }
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht4='".$gewicht."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
// $test=$gewicht/100; $test=$gewicht+$test; // pauschal aufrechnen
$test=$gewicht;
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht='".$test."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
$teile = explode(":", $row['H']);
$stellzeit=mktime($teile[0],$teile[1], 0,$monat,$tag,$jahr);
$GLOBALS['mysql']->insert("UPDATE tourenliste SET timestamp='".date("Y-m-d H:i:s", $stellzeit)."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET time='".$stellzeit."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET zeit='".$row['H']."' WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."' AND tour='".$row_tour['id']."'");
}
$key++;
} header('Location: https://edv.jb-transport.de/index.php?s=psaso');
}
}
//------------------------------------------------------------
// echo "<pre>"; print_r($row['A']); echo "</pre>";
//------------------------------------------------------------
?>
Reference in a new issue View git blame Copy permalink