162 lines
No EOL
5.2 KiB
PHP
162 lines
No EOL
5.2 KiB
PHP
<?php
|
||
header("Content-Type: text/html; charset=utf-8");
|
||
|
||
error_reporting(E_ALL);
|
||
ini_set('display_errors', 1);
|
||
|
||
$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');
|
||
//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'];
|
||
|
||
if($_FILES['datei']['type'] == 'application/vnd.ms-excel') {
|
||
move_uploaded_file($_FILES['datei']['tmp_name'], $_FILES['datei']['name']);
|
||
$ok=1; $dat=substr($_FILES['datei']['name'], 0,8);
|
||
|
||
//-------------------------------------------------------------------------------------------------------------- FAZ ABO liste
|
||
if ($dat=='zb_Leip_') {
|
||
$tag =substr($_FILES['datei']['name'], -6,2); //echo "Tag: ",$tag;
|
||
$monat=substr($_FILES['datei']['name'], -8,2); //echo "Monat: ",$monat;
|
||
$jahr =substr($_FILES['datei']['name'],-12,4); //echo "Jahr: ",$jahr;
|
||
|
||
//kw erstellen aus tag / monat / jahr
|
||
|
||
|
||
$kw= date("W", mktime(0, 0, 0,$monat,$tag,$jahr)); // Ausgabe: KW
|
||
$kwjahr= date("o", mktime(0, 0, 0,$monat,$tag,$jahr)); // Ausgabe: jahr kw -- übergreifend wenn jaheswechsel
|
||
|
||
|
||
$handle = fopen ($_FILES['datei']['name'],'r'); $key=0;
|
||
while (($fd = fgetcsv ($handle, 1000, ';')) !== FALSE ) {
|
||
|
||
$replace="_";
|
||
$search="'";
|
||
$fd4=str_replace($search, $replace,$fd[4]);
|
||
$fd5=str_replace($search, $replace,$fd[5]);
|
||
$fd8=str_replace($search, $replace,$fd[8]);
|
||
$fd9=str_replace($search, $replace,$fd[9]);
|
||
$search="/";
|
||
$fd4=str_replace($search, $replace,$fd[4]);
|
||
$fd5=str_replace($search, $replace,$fd[5]);
|
||
$fd8=str_replace($search, $replace,$fd[8]);
|
||
$fd9=str_replace($search, $replace,$fd[9]);
|
||
$search="´";
|
||
$fd4=str_replace($search, $replace,$fd[4]);
|
||
$fd5=str_replace($search, $replace,$fd[5]);
|
||
$fd8=str_replace($search, $replace,$fd[8]);
|
||
$fd9=str_replace($search, $replace,$fd[9]);
|
||
$search="'";
|
||
$fd4=str_replace($search, $replace,$fd[4]);
|
||
$fd5=str_replace($search, $replace,$fd[5]);
|
||
$fd8=str_replace($search, $replace,$fd[8]);
|
||
$fd9=str_replace($search, $replace,$fd[9]);
|
||
|
||
if ($fd[0]!="VBDAT2") {
|
||
$GLOBALS['mysql']->insert("INSERT INTO fazs (kw,kwjahr,tag,monat,jahr,zustelldate,anrede,titel,name,name2,name3,name4,strasse,bemerkung,hnr,hnrz,plz,ort,abo,pausevon,pausebis,stadtteil,kdnr,auftragnr)
|
||
VALUES(
|
||
'".$kw."',
|
||
'".$kwjahr."',
|
||
'".$tag."',
|
||
'".$monat."',
|
||
'".$jahr."',
|
||
'".$fd[0]."',
|
||
'".$fd[2]."',
|
||
'".$fd[3]."',
|
||
'".$fd4."',
|
||
'".$fd5."',
|
||
'".$fd[6]."',
|
||
'".$fd[7]."',
|
||
'".$fd8."',
|
||
'".$fd9."',
|
||
'".$fd[10]."',
|
||
'".$fd[11]."',
|
||
'".$fd[12]."',
|
||
'".$fd[13]."',
|
||
'".$fd[15]."',
|
||
'".$fd[23]."',
|
||
'".$fd[24]."',
|
||
'".$fd[27]."',
|
||
'".$fd[19]."',
|
||
'".$fd[20]."'
|
||
)
|
||
");
|
||
|
||
}
|
||
// echo "<pre>"; print_r($fd); echo "</pre>";
|
||
}
|
||
|
||
|
||
|
||
fclose($handle);
|
||
|
||
|
||
header('Location: https://edv.jb-transport.de/index.php?s=ifazs');
|
||
}
|
||
//------------------------------------------------------------
|
||
//------------------------------------ Veränderungen
|
||
//------------------------------------------------------------
|
||
if ($dat=='zva_Leip') {
|
||
$tag =substr($_FILES['datei']['name'], -6,2); //echo "Tag: ",$tag;
|
||
$monat=substr($_FILES['datei']['name'], -8,2); //echo "Monat: ",$monat;
|
||
$jahr =substr($_FILES['datei']['name'],-12,4); //echo "Jahr: ",$jahr;
|
||
$kw= date("W", mktime(0, 0, 0,$monat,$tag,$jahr)); // Ausgabe: KW
|
||
$kwjahr= date("o", mktime(0, 0, 0,$monat,$tag,$jahr)); // Ausgabe: jahr kw -- übergreifend wenn jaheswechsel
|
||
$datum=$tag.".".$monat.".".$jahr;
|
||
$handle = fopen ($_FILES['datei']['name'],'r'); $key=0;
|
||
while (($fd = fgetcsv ($handle, 1000, ';')) !== FALSE ) {
|
||
//echo $fd[12];
|
||
if ($fd[0]!="FCODE") {
|
||
$GLOBALS['mysql']->insert("INSERT INTO fazv (kw,kwjahr,tag,monat,jahr,zustelldate,status,auftragnr,pausevon,pausebis,abo,anrede,titel,name,name2,name3,name4,strasse,hnr,hnrz,plz,ort,bemerkung)
|
||
VALUES(
|
||
'".$kw."',
|
||
'".$kwjahr."',
|
||
'".$tag."',
|
||
'".$monat."',
|
||
'".$jahr."',
|
||
'".$datum."',
|
||
'".$fd[0]."',
|
||
'".substr($fd[1],0,10)."',
|
||
'".$fd[4]."',
|
||
'".$fd[5]."',
|
||
'".$fd[7]."',
|
||
'".$fd[8]."',
|
||
'".$fd[9]."',
|
||
'".$fd[12]."',
|
||
'".$fd[13]."',
|
||
'".$fd[14]."',
|
||
'".$fd[15]."',
|
||
'".$fd[16]."',
|
||
'".$fd[17]."',
|
||
'".$fd[18]."',
|
||
'".$fd[19]."',
|
||
'".$fd[20]."',
|
||
'".$fd[22]."'
|
||
)
|
||
");
|
||
|
||
}
|
||
// echo "<pre>"; print_r($fd); echo "</pre>";
|
||
}
|
||
fclose($handle);
|
||
//header('Location: https://edv.jb-transport.de/index.php?s=ifazs');
|
||
}
|
||
//------------------------------------------------------------
|
||
}
|
||
|
||
//------------------------------------------------------------
|
||
// echo "<pre>"; print_r($row['A']); echo "</pre>";
|
||
//------------------------------------------------------------
|
||
|
||
|
||
?>
|