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

436 lines
No EOL
28 KiB
PHP
Raw Permalink Blame History

<?php
header('Content-Type: text/html; charset=utf-8');
/**
* Gmail attachment extractor.
*
* Downloads attachments from Gmail and saves it to a file.
* Uses PHP IMAP extension, so make sure it is enabled in your php.ini,
* extension=php_imap.dll
*
*/
//-----------------------------------------------------------------------
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);
date_default_timezone_set('Europe/London');
//-----------------------------------------------------------------------
set_time_limit(3000);
$hostname = '{imap.jb-transport.de:143/imap/novalidate-cert}INBOX';
$username = 'edv@jb-transport.de'; # e.g somebody@gmail.com
$password = 'maxdata-01';
/* try to connect */
$inbox = imap_open($hostname,$username,$password) or die('Cannot connect to Mail: ' . imap_last_error());
$emails = imap_search($inbox,'UNSEEN');
$max_emails = 9999;
if($emails) {
$count = 1;
rsort($emails);
foreach($emails as $email_number) {
$overview = imap_fetch_overview($inbox,$email_number,0);
$message = imap_fetchbody($inbox,$email_number,2);
$structure = imap_fetchstructure($inbox, $email_number);
$attachments = array();
if(isset($structure->parts) && count($structure->parts)) { /* if any attachments found... */
for($i = 0; $i < count($structure->parts); $i++) {
$attachments[$i] = array(
'is_attachment' => false,
'filename' => '',
'name' => '',
'attachment' => ''
);
if($structure->parts[$i]->ifdparameters) {
foreach($structure->parts[$i]->dparameters as $object) {
if(strtolower($object->attribute) == 'filename') {
$attachments[$i]['is_attachment'] = true;
$attachments[$i]['filename'] = $object->value;
//echo $attachments[$i]['filename'];
}
}
}
if($structure->parts[$i]->ifparameters) {
foreach($structure->parts[$i]->parameters as $object) {
if(strtolower($object->attribute) == 'name') {
$attachments[$i]['is_attachment'] = true;
$attachments[$i]['name'] = $object->value;
}
}
}
if($attachments[$i]['is_attachment']) {
$attachments[$i]['attachment'] = imap_fetchbody($inbox, $email_number, $i+1);
if($structure->parts[$i]->encoding == 3) {
$attachments[$i]['attachment'] = base64_decode($attachments[$i]['attachment']);
}
elseif($structure->parts[$i]->encoding == 4) {
$attachments[$i]['attachment'] = quoted_printable_decode($attachments[$i]['attachment']);
}
}
}
}
foreach($attachments as $attachment) {
if($attachment['is_attachment'] == 1) {
$filename = $attachment['name'];
if(empty($filename)) $filename = $attachment['filename'];
$fp = fopen('upload/'.$filename, "w+"); // $email_number . "-" .
fwrite($fp, $attachment['attachment']);
fclose($fp);
}
$filename='upload/'.$attachment['name'];
$datei=$attachment['name'];
//-----------------------------------------------------------------------------------------------------
//-----------------------------------------------------------------------------------------------------
$dat=substr($filename,-3);
if ($dat=='xls' || $dat=='lsx' || $dat=='XLS') { //-------------------------------------------- Excel file
// echo '<br>--'.$dat;
//-----------------------------------------------------------------------------------------------------
$dat=substr($filename, 7,8);
// echo $dat;
//-----------------------------------------------------------------------------------------------------
//----------------------------------------- NORMPLAN --------------------------------------------------
//-----------------------------------------------------------------------------------------------------
if ($dat=='Normplan') {
define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
require_once dirname(__FILE__) . '/lib/PHPExcel.php';
$objPHPExcel = PHPExcel_IOFactory::load($filename);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true); $key=0; $test=0;
$key=0;
foreach ($sheetData as $index => $row) {
if ($key==0) {
$datum_arr = explode('-',$row['B']); $timestamp1 = mktime(0,0,0, $datum_arr[0] , $datum_arr[1] ,$datum_arr[2]);
// $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==5) {
$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['K']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_city='".$row['R']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_city='".$row['Y']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_city='".$row['AF']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_city='".$row['AM']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
if ($key==6) {
$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['K']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_bgz ='".$row['R']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_bgz ='".$row['Y']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_bgz ='".$row['AF']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_bgz ='".$row['AM']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
if ($key==7) {
$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['K']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_dek ='".$row['R']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_dek ='".$row['Y']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_dek ='".$row['AF']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_dek ='".$row['AM']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
if ($key==8) {
$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['K']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_mtk ='".$row['R']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_mtk ='".$row['Y']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_mtk ='".$row['AF']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET lvz_mtk ='".$row['AM']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
if ($key==10) {
$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['K']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET tz ='".$row['R']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET tz ='".$row['Y']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET tz ='".$row['AF']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET tz ='".$row['AM']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
if ($key==11) {
$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['K']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET oaz ='".$row['R']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET oaz ='".$row['Y']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET oaz ='".$row['AF']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET oaz ='".$row['AM']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
if ($key==12) {
$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['K']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET daz ='".$row['R']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET daz ='".$row['Y']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET daz ='".$row['AF']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET daz ='".$row['AM']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
if ($key==13) {
$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['K']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET ovz ='".$row['R']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET ovz ='".$row['Y']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET ovz ='".$row['AF']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET ovz ='".$row['AM']."' WHERE tag='".$tag6."' AND monat='".$monat6."' AND jahr='".$jahr6."'");
}
if ($key==14) {
$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['K']."' WHERE tag='".$tag2."' AND monat='".$monat2."' AND jahr='".$jahr2."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET dnn ='".$row['R']."' WHERE tag='".$tag3."' AND monat='".$monat3."' AND jahr='".$jahr3."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET dnn ='".$row['Y']."' WHERE tag='".$tag4."' AND monat='".$monat4."' AND jahr='".$jahr4."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET dnn ='".$row['AF']."' WHERE tag='".$tag5."' AND monat='".$monat5."' AND jahr='".$jahr5."'");
$GLOBALS['mysql']->insert("UPDATE normplan SET dnn ='".$row['AM']."' 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');
}
//-----------------------------------------------------------------------------------------------------
//------------------------------------------------------------------------------ HEINIKE --------------
//-----------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------- saso 2
$dat=substr($filename,-12,6);
// echo $dat;
if ($dat=='ULS 02') {
define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
require_once dirname(__FILE__) . '/lib/PHPExcel.php';
$objPHPExcel = PHPExcel_IOFactory::load($filename);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true); $key=0; $test=0;
foreach ($sheetData as $index => $row) {
echo "<pre>"; print_r($row); echo "</pre>";
if ($key==1) {
$datum_arr = explode('-',$row['B']);
$stag=$datum_arr[0];
$smonat=$datum_arr[1];
$sjahr=$datum_arr[2];
$timestamp = mktime(0,0,0, $datum_arr[0] , $datum_arr[1] ,$datum_arr[2]);
$norm=$row['D'];
}
if ($key>4) {
if($row['C']>0 and $row['A']>0) {
$bereich=$row['A'];
$iftest = $GLOBALS['mysql']->query_single("SELECT * FROM tourenplan WHERE tag='".$stag."' AND monat='".$smonat."' AND jahr='".$sjahr."' and bereich='".$row['A']."'");
if($iftest['num_rows']==0) {
$GLOBALS['mysql']->insert("INSERT INTO tourenplan (tag,monat,jahr,bereich) VALUES('".$stag."','".$smonat."','".$sjahr."','".$bereich."')");
} else { /// bereits eine liste vorhanden
$GLOBALS['mysql']->insert("UPDATE tourenplan SET tag ='".$stag."',monat='".$smonat."',jahr='".$sjahr."' WHERE bereich='".$bereich."'");
}
$GLOBALS['mysql']->insert("UPDATE tourenplan SET exemplare='".$row['C']."',typ='".$row['G']."',tour=802 WHERE bereich='".$bereich."'");
$GLOBALS['mysql']->insert("UPDATE tourenplan SET norm='".$norm."' WHERE bereich='".$bereich."'");
$tempadress=strpos($row['B'],'/');
if ($tempadress === false) {
$GLOBALS['mysql']->insert("UPDATE tourenplan SET adresse='".$row['B']."' WHERE bereich='".$bereich."'");
} else {
$tempdata = explode('/',$row['B']);
$GLOBALS['mysql']->insert("UPDATE tourenplan SET adresse='".utf8_decode($tempdata['0'])."' WHERE bereich='".$bereich."'");
$GLOBALS['mysql']->insert("UPDATE tourenplan SET info='".utf8_decode($tempdata['1'])."' WHERE bereich='".$bereich."'");
}
} else {
$info=$tempdata['1']." ".$row['B'];
$GLOBALS['mysql']->insert("UPDATE tourenplan SET info='".utf8_decode($info)."' WHERE bereich='".$bereich."'");
unset ($tempdata); $bereich=0;
}
}
$key++;
}
}
//----------------------------------------------------------------------------------------------------- SaSo 3
$dat=substr($filename,-11,7);
// echo $dat;
if ($dat=='TMLLS03') {
define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
require_once dirname(__FILE__) . '/lib/PHPExcel.php';
$objPHPExcel = PHPExcel_IOFactory::load($filename);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true); $key=0; $test=0;
foreach ($sheetData as $index => $row) {
// echo "<pre>"; print_r($row); echo "</pre>";
if ($key==1) {
$datum_arr = explode('-',$row['B']);
$stag=$datum_arr[0];
$smonat=$datum_arr[1];
$sjahr=$datum_arr[2];
$timestamp = mktime(0,0,0, $datum_arr[0] , $datum_arr[1] ,$datum_arr[2]);
$norm=$row['D'];
}
if ($key>4) {
if($row['C']>0 and $row['A']>0) {
$bereich=$row['A'];
$iftest = $GLOBALS['mysql']->query_single("SELECT * FROM tourenplan WHERE tag='".$stag."' AND monat='".$smonat."' AND jahr='".$sjahr."' and bereich='".$row['A']."'");
if($iftest['num_rows']==0) {
$GLOBALS['mysql']->insert("INSERT INTO tourenplan (tag,monat,jahr,bereich) VALUES('".$stag."','".$smonat."','".$sjahr."','".$bereich."')");
} else { /// bereits eine liste vorhanden
$GLOBALS['mysql']->insert("UPDATE tourenplan SET tag ='".$stag."',monat='".$smonat."',jahr='".$sjahr."' WHERE bereich='".$bereich."'");
}
$GLOBALS['mysql']->insert("UPDATE tourenplan SET exemplare='".$row['C']."',typ='".$row['G']."',tour=803 WHERE bereich='".$bereich."'");
$GLOBALS['mysql']->insert("UPDATE tourenplan SET norm='".$norm."' WHERE bereich='".$bereich."'");
$tempadress=strpos($row['B'],'/');
if ($tempadress === false) {
$GLOBALS['mysql']->insert("UPDATE tourenplan SET adresse='".$row['B']."' WHERE bereich='".$bereich."'");
} else {
$tempdata = explode('/',$row['B']);
$GLOBALS['mysql']->insert("UPDATE tourenplan SET adresse='".utf8_decode($tempdata['0'])."' WHERE bereich='".$bereich."'");
$GLOBALS['mysql']->insert("UPDATE tourenplan SET info='".utf8_decode($tempdata['1'])."' WHERE bereich='".$bereich."'");
}
} else {
$info=$tempdata['1']." ".$row['B'];
$GLOBALS['mysql']->insert("UPDATE tourenplan SET info='".utf8_decode($info)."' WHERE bereich='".$bereich."'");
unset ($tempdata); $bereich=0;
}
}
$key++;
}
}
//-----------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------- SaSo 35
$dat=substr($filename,-11,7);
echo $filename;
if ($filename=='upload/Tour Steinmacher 35.xlsx') {
define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
require_once dirname(__FILE__) . '/lib/PHPExcel.php';
$objPHPExcel = PHPExcel_IOFactory::load($filename);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true); $key=0; $test=0;
foreach ($sheetData as $index => $row) {
echo "<pre>"; print_r($row); echo "</pre>";
if ($key==2) {
$datum_arr = explode('-',$row['A']);
$smonat=$datum_arr[0];
$stag=$datum_arr[1];
$sjahr=$datum_arr[2];
$timestamp = mktime(0,0,0, $datum_arr[1] , $datum_arr[0] ,$datum_arr[2]);
// $norm=$row['D'];
}
if ($key==5) {
$norn=$row['C'];
}
if ($key>6) {
if($row['C']>0 and $row['B']>0) {
$bereich=$row['B'];
$iftest = $GLOBALS['mysql']->query_single("SELECT * FROM tourenplan WHERE tag='".$stag."' AND monat='".$smonat."' AND jahr='".$sjahr."' and bereich='".$row['B']."'");
if($iftest['num_rows']==0) {
$GLOBALS['mysql']->insert("INSERT INTO tourenplan (tag,monat,jahr,bereich) VALUES('".$stag."','".$smonat."','".$sjahr."','".$bereich."')");
} else { /// bereits eine liste vorhanden
$GLOBALS['mysql']->insert("UPDATE tourenplan SET tag ='".$stag."',monat='".$smonat."',jahr='".$sjahr."' WHERE bereich='".$bereich."'");
}
$GLOBALS['mysql']->insert("UPDATE tourenplan SET exemplare='".$row['C']."',typ='".$row['F']."',tour=835 WHERE bereich='".$bereich."'");
$GLOBALS['mysql']->insert("UPDATE tourenplan SET norm='".$norm."' WHERE bereich='".$bereich."'");
$tempadress=strpos($row['A'],'/');
if ($tempadress === false) {
$tempadress=strpos($row['A'],'(');
}
if ($tempadress === false) {
$GLOBALS['mysql']->insert("UPDATE tourenplan SET adresse='".utf8_decode($row['A'])."' WHERE bereich='".$bereich."'");
} else {
$tempdata = explode('/',$row['A']);
$GLOBALS['mysql']->insert("UPDATE tourenplan SET adresse='".utf8_decode($tempdata['0'])."' WHERE bereich='".$bereich."'");
$GLOBALS['mysql']->insert("UPDATE tourenplan SET info='".utf8_decode($tempdata['1'])."' WHERE bereich='".$bereich."'");
}
} else {
$info=$tempdata['1']." ".$row['A'];
$GLOBALS['mysql']->insert("UPDATE tourenplan SET info='".utf8_decode($info)."' WHERE bereich='".$bereich."'");
unset ($tempdata); $bereich=0;
}
}
$key++;
}
}
//-----------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------- SaSo 40
$dat=substr($filename,-11,7);
echo $filename;
if ($filename=='upload/Tour Steinmacher 40.xlsx') {
define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
require_once dirname(__FILE__) . '/lib/PHPExcel.php';
$objPHPExcel = PHPExcel_IOFactory::load($filename);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true); $key=0; $test=0;
foreach ($sheetData as $index => $row) {
echo "<pre>"; print_r($row); echo "</pre>";
if ($key==2) {
$datum_arr = explode('-',$row['A']);
$stag=$datum_arr[0];
$smonat=$datum_arr[1];
$sjahr=$datum_arr[2];
$timestamp = mktime(0,0,0, $datum_arr[1] , $datum_arr[0] ,$datum_arr[2]);
// $norm=$row['D'];
}
if ($key==6) {
$norn=$row['C'];
}
if ($key>6) {
if($row['C']>0 and $row['B']>0) {
$bereich=$row['B'];
$iftest = $GLOBALS['mysql']->query_single("SELECT * FROM tourenplan WHERE tag='".$stag."' AND monat='".$smonat."' AND jahr='".$sjahr."' and bereich='".$row['B']."'");
if($iftest['num_rows']==0) {
$GLOBALS['mysql']->insert("INSERT INTO tourenplan (tag,monat,jahr,bereich) VALUES('".$stag."','".$smonat."','".$sjahr."','".$bereich."')");
} else { /// bereits eine liste vorhanden
$GLOBALS['mysql']->insert("UPDATE tourenplan SET tag ='".$stag."',monat='".$smonat."',jahr='".$sjahr."' WHERE bereich='".$bereich."'");
}
$GLOBALS['mysql']->insert("UPDATE tourenplan SET exemplare='".$row['C']."',typ='".$row['F']."',tour=840 WHERE bereich='".$bereich."'");
$GLOBALS['mysql']->insert("UPDATE tourenplan SET norm='".$norm."' WHERE bereich='".$bereich."'");
$tempadress=strpos($row['A'],'/');
if ($tempadress === false) {
$GLOBALS['mysql']->insert("UPDATE tourenplan SET adresse='".utf8_decode($row['A'])."' WHERE bereich='".$bereich."'");
} else {
$tempdata = explode('/',$row['A']);
$GLOBALS['mysql']->insert("UPDATE tourenplan SET adresse='".utf8_decode($tempdata['0'])."' WHERE bereich='".$bereich."'");
$GLOBALS['mysql']->insert("UPDATE tourenplan SET info='".utf8_decode($tempdata['1'])."' WHERE bereich='".$bereich."'");
}
} else {
$info=$tempdata['1']." ".$row['A'];
$GLOBALS['mysql']->insert("UPDATE tourenplan SET info='".utf8_decode($info)."' WHERE bereich='".$bereich."'");
unset ($tempdata); $bereich=0;
}
}
$key++;
}
}
//-----------------------------------------------------------------------------------------------------
//-----------------------------------------------------------------------------------------------------
//-----------------------------------------------------------------------------------------------------
//-----------------------------------------------------------------------------------------------------
//-----------------------------------------------------------------------------------------------------
//-----------------------------------------------------------------------------------------------------
unlink($filename);
//-----------------------------------------------------------------------------------------------------
}
if($count++ >= $max_emails) break;
}
}
}
/* close the connection */
imap_close($inbox);
echo "Done";
?>
Reference in a new issue View git blame Copy permalink