>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
<>
]/ID[<2F56FA2421F140C1B911F01F54C41969><3757A236142F494CA0CAC7CC3C1E587C>]/UF(vorlagen/form_Anbauempfehlung2018.pdf)/F(vorlagen/form_Anbauempfehlung2018.pdf)>>>>
endobj
trailer
<>
%%EOF';
$start=0;
$end=50000;
//hole csv-Daten
$fp=file($csv);
$csvData=array();
while (list($index,$line)=each($fp)){
if ($index>=$start && $index <=$end){
$line=preg_replace("/\r\n/","",$line);
$line=addslashes($line);
if ($index>=$offset) {
$csvData[$index] = preg_split('/;(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))/', $line);
}
}
}
reset ($csvData);
function cleaner($wert){
# $wert=preg_replace('/\(/','[',$wert);
# $wert=preg_replace('/\)/',']',$wert);
if (!$wert) return("");
if (preg_match('/\"([^\"]+)\"/',stripslashes($wert))) $wert=substr(trim(stripslashes($wert)),1,-1);
$wert=preg_replace('/\"\"/','\"',stripslashes(trim($wert)));
if (preg_match('/\@/',$wert)){
$len=strlen($wert);
if ($len < 35){
for ($x=$len; $x<=35;$x++){
$wert=$wert." ";
}
}
}
return(($wert));
}
/*
$con=mysql_connect("localhost","typo3","bitgeheim08");
$db=mysql_select_db("db_ebvportal");
*/
while (list($count,$data)=each($csvData)){
if ($count>$limit) exit;
/*
$query='update adressen set saatflaeche="'.$data[19].'" where gp_nummer="'.trim($data[0]).'"';
mysql_query($query) || die('geht nicht');
print '
'.$query;
print '
'.mysql_affected_rows();
continue;
*/
//Spalte 19 wird neu eingefügt
//if (1==1){
//10001757
//10033149
/*
10001757 (bei LBG Neindorf)
10003376 Jürgen Winter, Ackerbau, (Kto. Kühn, Tiegen)
10032947 (bei F. Hünersdorf)
10033149
*/
//Hier wird nun einfach mal ein neuer Wert eingetragen
var_dump($data[0]);
$adresse='';
if ($data[2]) $adresse.="\r\n".cleaner($data[2]);
if ($data[3]) $adresse.="\r\n".cleaner($data[3]);
if ($data[4]) $adresse.="\r\n".cleaner($data[4]);
if ($data[5]) $adresse.="\r\n".cleaner($data[5]);
if ($data[6]) $adresse.="\r\n".cleaner($data[6]);
if ($data[7]) $adresse.="\r\n".cleaner($data[7]);
$ac='';
if ($data[8]) $ac.="\r\n".cleaner($data[8]);
if ($data[9]) $ac.="\r\n".cleaner($data[9]);
if ($data[10]) $ac.="\r\n".cleaner($data[10]);
if ($data[11]) $ac.="\r\n".cleaner($data[11]);
$content=str_replace('###adresse###',($adresse),$fdf);
$content=str_replace('###datum###',strftime('%d. %B %Y'),$content);
$content=str_replace('###gp###',"\r\n".cleaner($data[0]),$content);
//Neues Feld: Name -> Position folgt
$content=str_replace('###name###',"\r\n".cleaner($data[1]),$content);
$content=str_replace('###EMPFHA###',"\r\n".cleaner($data[21]),$content);
$content=str_replace('###FLBED###',"\r\n".cleaner($data[22]),$content);
$content=str_replace('###VM###',"\r\n".cleaner($data[23]),$content);
$content=str_replace('###MJZG###',"\r\n".cleaner($data[24]),$content);
$content=str_replace('###MJRE###',"\r\n".cleaner($data[25]),$content);
$content=str_replace('###ac###',$ac,$content);
$content=str_replace('###la1fix17###',cleaner($data[23]),$content);
$content=str_replace('###la1var17###',cleaner($data[28]),$content);
$content=str_replace('###la3fix17###',cleaner($data[33]),$content);
$content=str_replace('###la3var17###',cleaner($data[38]),$content);
$content=str_replace('###lasum17###',cleaner($data[43]),$content);
$content=str_replace('###fm1fix17###',cleaner($data[48]),$content);
$content=str_replace('###fm1var17###',cleaner($data[53]),$content);
$content=str_replace('###fm3var17###',cleaner($data[58]),$content);
$content=str_replace('###fmsum17###',cleaner($data[64]),$content);
$content=str_replace('###sumvm17###',cleaner($data[68]),$content);
$content=str_replace('###la1fix18###',cleaner($data[24]),$content);
$content=str_replace('###la1var18###',cleaner($data[29]),$content);
$content=str_replace('###la3fix18###',cleaner($data[34]),$content);
$content=str_replace('###la3var18###',cleaner($data[39]),$content);
$content=str_replace('###fm1fix18###',cleaner($data[49]),$content);
$content=str_replace('###fm1var18###',cleaner($data[54]),$content);
$content=str_replace('###fm3var18###',cleaner($data[59]),$content);
$content=str_replace('###lasum18###',cleaner($data[44]),$content);
$content=str_replace('###fmsum18###',cleaner($data[65]),$content);
$content=str_replace('###sumvm18###',cleaner($data[69]),$content);
$content=str_replace('###lasum19###',cleaner($data[45]),$content);
$content=str_replace('###la1fix19###',cleaner($data[25]),$content);
$content=str_replace('###la1var19###',cleaner($data[30]),$content);
$content=str_replace('###la3fix19###',cleaner($data[35]),$content);
$content=str_replace('###la3var19###',cleaner($data[40]),$content);
$content=str_replace('###fm1fix19###',cleaner($data[50]),$content);
$content=str_replace('###fm1var19###',cleaner($data[55]),$content);
$content=str_replace('###fm3var19###',cleaner($data[60]),$content);
$content=str_replace('###fmsum19###',cleaner($data[66]),$content);
$content=str_replace('###sumvm19###',cleaner($data[70]),$content);
$content=str_replace('###lasum20###',cleaner($data[46]),$content);
$content=str_replace('###la1fix20###',cleaner($data[26]),$content);
$content=str_replace('###la1var20###',cleaner($data[31]),$content);
$content=str_replace('###la3fix20###',cleaner($data[36]),$content);
$content=str_replace('###la3var20###',cleaner($data[41]),$content);
$content=str_replace('###lasum20###',cleaner($data[46]),$content);
$content=str_replace('###fm1fix20###',cleaner($data[51]),$content);
$content=str_replace('###fm1var20###',cleaner($data[56]),$content);
$content=str_replace('###fm3var20###',cleaner($data[61]),$content);
$content=str_replace('###fmsum20###',cleaner($data[67]),$content);
$content=str_replace('###sumvm20###',cleaner($data[71]),$content);
$content=str_replace('###5jzg###',cleaner($data[21]),$content);
$content=str_replace('###5jtha###',cleaner($data[22]),$content);
$content=str_replace('###gp_addr###',cleaner($data[0]).', '.cleaner($data[2]),$content);
ob_flush();
flush();
$namestr=$data[0].'_'.date("d").'.'.date("m").'.'.date("Y");
var_dump($content);
//erzeuge fdf
$fdfname='ready/'.$namestr.'.fdf';
//schreiben
$fdffp=fopen($fdfname,'w');
fputs($fdffp,$content);
fclose($fdffp);
//erzeuge pdf
exec('pdftk /var/www/anbauberatung/vorlagen/'.$vorlage.' fill_form /var/www/anbauberatung/'.$fdfname.' output /var/www/anbauberatung/ready/'.$namestr.'.pdf flatten');
}
?>