Cell(20,7,'Menge',1);
$this->Cell(40,7,'Nummer',1);
$this->Cell(130,7,'Artikel',1);
$this->Ln();
$tmp = array_shift($data);
$tmp = array_pop($data); // Warum auch immer ein leeres Array am Ende ist.
//Data
foreach($data as $row) {
if ( substr($row[0],0,3) == '###' ) {
$this->MultiCell(190,6,utf8_decode(substr($row[0],3)),0,'L',0);
} else {
$this->Cell(20,6,$row[2],1);
$this->Cell(40,6,$row[1],1);
$this->Cell(130,6,utf8_decode(substr($row[0],0,70)),1);
}
$this->Ln();
}
}
function Titel($txt) {
$this->Cell(200,10,$txt,0);
$this->Ln();
}
};
if ( $_POST ) {
$dir = 'tmp/';
$filecsv = 'packliste.csv';
$filepdf = 'packliste.pdf';
$datum = $_POST['datum'];
$output = 'Packliste ab: '.$datum.'
';
if ( $_POST['read'] != '' ) {
$tmp = split('\.',$datum);
$date = $tmp[2].'-'.$tmp[1].'-'.$tmp[0];
$sql = 'select parts.description,partnumber,sum(qty) as qty ';
$sql .= 'from invoice left join parts on parts.id=parts_id ';
$sql .= 'where trans_id in ';
$sql .= '(SELECT id from ar where amount > 0 and transdate between \''.$date.'\' and now() ) '; //= \''.$date.'\') ';
$sql .= 'group by partnumber,parts.description order by qty desc'; //partnumber';
$rs = $_SESSION['db']->getAll($sql);
$line = " | ";
$line .= " | ";
$line .= " |
\n";
if ( $rs ) {
$output .= ''."\n";
} else {
$output .= 'Keine Treffer
';
}
} else if ( $_POST['generate'] != '' ) {
$output = '';
$f = fopen($dir.$filecsv,'w');
fputs($f,'description;partnumber;qty'."\n");
$data = $_POST['data'];
for ( $i = 0; $i < count($data['qty']); $i++) {
if ( $data['qty'][$i] > 0 )
fputs($f,'"'.$data['description'][$i].'";"'.$data['partnumber'][$i].'";'.$data['qty'][$i]."\n");
};
if ( $_POST['notiz'] != '' ) { fputs($f,'"###'.$_POST['notiz'].'"'); };
fclose($f);
$pdf=new PDF();
$data=$pdf->LoadData($dir.$filecsv);
$pdf->SetFont('Arial','',10);
$pdf->AddPage();
$pdf->SetTitle('Packliste ab '.$datum);
$pdf->Titel('Packliste ab '.$datum);
$pdf->SetDrawColor(255, 255, 255);
$pdf->BasicTable($data);
$pdf->Output($dir.$filepdf,"F");
if ( file_exists($dir.$filepdf) ) {
if ( $_POST['weg'] == 2 ){
$headers = array(
"From" => $_SESSION['email'],
"X-Mailer" => "PHP/".phpversion(),
"Subject" => 'Packliste ab '.$datum);
$mime = new Mail_Mime(array('eol'=>"\n"));
$csv = $mime->addAttachment($dir.$filecsv,mime_content_type($dir.$filecsv),$filecsv);
$pdf = $mime->addAttachment($dir.$filepdf,mime_content_type($dir.$filepdf),$filepdf);
$mime->setTXTBody('Packliste');
$hdrs = $mime->headers($headers);
$body = $mime->get();
$mail = Mail::factory("mail");
$mail->_params = "-f ".$_SESSION['email'];
$rc = $mail->send($_SESSION['email'], $hdrs, $body);
$output = 'E-Mail verschickt';
#unlink($dir.$filepdf);
} else {
header('Content-type: application/pdf');
header('Content-Disposition: attachment; filename="packliste.pdf"');
readfile($dir.$filepdf);
#unlink($dir.$filepdf);
}
} else {
$output .= 'Konnte kein PDF erstellen.
';
};
} else {
$output .= 'Keine Treffer
';
};
};
?>