WebSVN – lars-tiefland.content-management – Blame – /trunk/Warenwirtschaft/angebot.php

Revision	Autor	Zeilennr.	Zeile
1	lars	1	`<?`
		2	`// $Id: angebot.php 3931 2011-09-16 08:17:57Z tiefland $`
		3	`require_once "connect2.php";`
		4	`require_once "includes/bestellungen/system/mysql_query_logged.php";`
		5	`require_once "Weban_Smarty.class.php";`
		6	`require_once "includes/angebot/body_$site.inc.php";`
		7
		8	`// Angebotsbausteine?`
		9
		10	`if ( !defined("LEISTUNGS_DATUM") )`
		11	`{`
		12	`define( "LEISTUNGS_DATUM", false );`
		13	`}`
		14	`$sql_b = "SELECT * FROM Bestellung WHERE ID=$b_id";`
		15	`$res_b = mysql_query_logged( $sql_b );`
		16	`$row_b = mysql_fetch_assoc( $res_b );`
		17	`$b_name = $row_b["letzte_Aenderung_von"];`
		18	`$b_name = substr( $b_name, 0, strpos($b_name, "@") );`
		19	`$dat = datetime2human( $row_b["letzte_Aenderung_am"] );`
		20	`$sql_l = "SELECT * FROM Logins WHERE ID=" . $row_b["Login"];`
		21	`$res_l = mysql_query_logged( $sql_l );`
		22	`$row_l = mysql_fetch_assoc( $res_l );`
		23	`$name = ( $row_l["Vorname"] ) ? $row_l["Vorname"] . " " . $row_l['Name1'] :`
		24	`$row_l["Name1"];`
		25	`$anrede = $row_l["Anrede"];`
		26	`$plz = $row_l["PLZ"];`
		27	`$ort = $row_l["ORT"];`
		28	`$str = $row_l["Strasse"];`
		29	`$str .= ( isset($row_l["Hausnummer"]) ) ? " " . $row_l["Hausnummer"] :`
		30	`"";`
		31	`$firma = ( isset($row_l["Name2"]) ) ? $row_l["Name2"] : "";`
		32	`require_once "fpdf/fpdf.php";`
		33	`class PDF extends FPDF`
		34	`{`
		35	`function generate_LN( $bestell_id, $art, $Nummernkreis )`
		36	`{`
		37	`if ( $Nummernkreis )`
		38	`{`
		39	`$sql =`
		40	`"SELECT l_nr AS ln FROM nummernkreis_angebot WHERE jahr=" .`
		41	`date( "Y" );`
		42	`$res = mysql_query_logged( $sql );`
		43	`if ( $res )`
		44	`{`
		45	`if ( mysql_num_rows($res) )`
		46	`{`
		47	`$row = mysql_fetch_assoc( $res );`
		48	`$ln = $row["ln"];`
		49	`$ln++;`
		50	`}`
		51	`else`
		52	`{`
		53	`$ln = 1;`
		54	`$sql = "`
		55	`INSERT INTO`
		56	`nummernkreis_angebot`
		57	`VALUES(`
		58	`$ln," . date( "Y" ) . "`
		59	`)`
		60	`";`
		61	`mysql_query_logged( $sql );`
		62	`}`
		63	`}`
		64	`else`
		65	`{`
		66	`$ln = 1;`
		67	`}`
		68	`$sql = "`
		69	`UPDATE`
		70	`nummernkreis_angebot`
		71	`SET`
		72	`l_nr=" . $ln . "`
		73	`WHERE`
		74	`jahr=" . date( "Y" );`
		75	`mysql_query_logged( $sql );`
		76	`}`
		77	`else`
		78	`{`
		79	`$date = date( "Y-m-d" );`
		80	`$f_name = $art . "_" . $bestell_id . "_" . $date;`
		81	`$sql =`
		82	`"SELECT MAX(document) AS dokument FROM dokumente WHERE document LIKE '$f_name%'";`
		83	`$res = mysql_query( $sql );`
		84	`if ( $res )`
		85	`{`
		86	`if ( mysql_num_rows($res) )`
		87	`{`
		88	`$row = mysql_fetch_assoc( $res );`
		89	`$dokument = substr( $row["dokument"], 0, strlen($row["dokument"]) -`
		90	`4 );`
		91	`$dokument = explode( "_", $dokument );`
		92	`$ln = $dokument[count( $dokument ) - 1];`
		93	`$ln++;`
		94	`}`
		95	`else`
		96	`{`
		97	`$ln = 1;`
		98	`}`
		99	`}`
		100	`else`
		101	`{`
		102	`$ln = 1;`
		103	`die( mysql_error() );`
		104	`}`
		105	`}`
		106	`return $ln;`
		107	`}`
		108	`//Page header`
		109	`function Header()`
		110	`{`
		111	`global $site, $r_nr;`
		112	`require_once "includes/angebot/header_$site.inc.php";`
		113	`}`
		114
		115	`//Page footer`
		116	`function Footer()`
		117	`{`
		118	`global $site;`
		119	`require_once "includes/angebot/footer_$site.inc.php";`
		120	`}`
		121	`function NbLines( $w, $txt )`
		122	`{`
		123	`//Computes the number of lines a MultiCell of width w will take`
		124	`$cw = &$this->CurrentFont['cw'];`
		125	`if ( $w == 0 )`
		126	`$w = $this->w - $this->rMargin - $this->x;`
		127	`$wmax = ( $w - 2 * $this->cMargin ) * 1000 / $this->FontSize;`
		128	`$s = str_replace( "\r", '', $txt );`
		129	`$nb = strlen( $s );`
		130	`if ( $nb > 0 and $s[$nb - 1] == "\n" )`
		131	`$nb--;`
		132	`$sep = -1;`
		133	`$i = 0;`
		134	`$j = 0;`
		135	`$l = 0;`
		136	`$nl = 1;`
		137	`while ( $i < $nb )`
		138	`{`
		139	`$c = $s[$i];`
		140	`if ( $c == "\n" )`
		141	`{`
		142	`$i++;`
		143	`$sep = -1;`
		144	`$j = $i;`
		145	`$l = 0;`
		146	`$nl++;`
		147	`continue;`
		148	`}`
		149	`if ( $c == ' ' )`
		150	`$sep = $i;`
		151	`$l += $cw[$c];`
		152	`if ( $l > $wmax )`
		153	`{`
		154	`if ( $sep == -1 )`
		155	`{`
		156	`if ( $i == $j )`
		157	`$i++;`
		158	`}`
		159	`else`
		160	`$i = $sep + 1;`
		161	`$sep = -1;`
		162	`$j = $i;`
		163	`$l = 0;`
		164	`$nl++;`
		165	`}`
		166	`else`
		167	`$i++;`
		168	`}`
		169	`return $nl;`
		170	`}`
		171	`}`
		172
		173	`if ( !$b_id )`
		174	`{`
		175	`if ( $_GET["b_id"] )`
		176	`{`
		177	`$b_id = ( int )$_GET["b_id"];`
		178	`} elseif ( $_POST["b_id"] )`
		179	`{`
		180	`$b_id = ( int )$_POST["b_id"];`
		181	`}`
		182	`else`
		183	`{`
		184	`die( "Keine Bestellung angegeben!" );`
		185	`}`
		186	`}`
		187
		188	`// Angebotsbausteine?`
		189	`if ( ($web_rechte["Warenwirtschaft"]["bestellung"]["angebotsbausteine"]) and`
		190	`(!$_POST['action']) )`
		191	`{`
		192	`$bausteinIDs = explode( ";", $web_rechte["Warenwirtschaft"]["bestellung"]["angebotsbausteine"] );`
		193	`$where_part = implode( " OR ID=", $bausteinIDs );`
		194	`// die Texte zu den Bausteinen ermitteln`
		195	`$sql = "SELECT`
		196	`*`
		197	`FROM`
		198	`web_settings`
		199	`WHERE`
		200	`ID=" . $where_part . "`
		201	`ORDER BY`
		202	`Rang";`
		203	`if ( $q = mysql_query($sql) )`
		204	`{`
		205	`while ( $r = mysql_fetch_assoc($q) )`
		206	`{`
		207	`$bausteine[$r['ID']] = $r['Inhalt'];`
		208	`}`
		209	`}`
		210	`$GLOBALS["ui"] = new Weban_Smarty();`
		211	`$GLOBALS["ui"]->assign( "b_id", $b_id );`
		212	`$GLOBALS["ui"]->assign( "bausteine", $bausteine );`
		213	`$GLOBALS["ui"]->assign( "rechnungsbausteine", true );`
		214	`$GLOBALS["ui"]->display( "rechnungsbausteine.tpl" );`
		215
		216
		217	`}`
		218	`else`
		219	`{`
		220
		221	`//Instanciation of inherited class`
		222	`$showLieferadresse = 0;`
		223	`$pdf = new PDF();`
		224	`if ( isset($web_rechte["Warenwirtschaft"]["bestellung"]["angebot"]) )`
		225	`{`
		226	`$Status = false;`
		227	`$Nummernkreis = false;`
		228	`$Speichern = false;`
		229
		230	`$daten = explode( ";", $web_rechte["Warenwirtschaft"]["bestellung"]["angebot"] );`
		231
		232
		233	`$id = array_search( "Status", $daten );`
		234	`if ( $id !== false )`
		235	`{`
		236	`$Status = true;`
		237	`}`
		238	`$id = array_search( "Nummernkreis", $daten );`
		239	`if ( $id !== false )`
		240	`{`
		241	`$Nummernkreis = true;`
		242	`if ( !isset($anz_stellen) )`
		243	`{`
		244	`$anz_stellen = 5;`
		245	`}`
		246	`$r_nr = sprintf( "%0" . $anz_stellen . "d", $pdf->`
		247	`generate_LN($b_id, "R", true) );`
		248	`$r_nr = date( "y" ) . $r_nr;`
		249	`$fName = "AG" . $r_nr . ".pdf";`
		250	`}`
		251	`else`
		252	`{`
		253	`$date = date( "Y-m-d" );`
		254	`$ln = $pdf->generate_LN( $b_id, "L", false );`
		255	`if ( !isset($anz_stellen) )`
		256	`{`
		257	`$anz_stellen = 5;`
		258	`}`
		259	`$r_nr = sprintf( "%0" . $anz_stellen . "d", $ln );`
		260	`$fName = "AG_" . $b_id . "_" . $date . "_" . $r_nr . ".pdf";`
		261	`}`
		262	`$id = array_search( "Speichern", $daten );`
		263	`if ( $id !== false )`
		264	`{`
		265	`$Speichern = true;`
		266	`}`
		267	`}`
		268
		269	`$pdf->setSubject( "Angebot" );`
		270	`$pdf->setAuthor( $haendler_name );`
		271	`$pdf->setCreator( "fpdf PHP Library" );`
		272	`$pdf->AliasNbPages();`
		273	`$pdf->AddPage();`
		274	`$pdf->setY( 45 );`
		275	`$pdf->setFont( 'Arial', '', 8 );`
		276	`$pdf->cell( 80, 4, $umschlag, "B", 1, "L" );`
		277	`$pdf->setFont( 'Arial', '', 10 );`
		278	`$pdf->ln( 5 );`
		279	`$pdf->setX( 20 );`
		280	`if ( !$firma )`
		281	`{`
		282	`$pdf->setX( 20 );`
		283	`$pdf->cell( 80, 4, $anrede, 0, 1, "L" );`
		284	`$pdf->setX( 20 );`
		285	`$pdf->cell( 80, 4, $name, 0, 1, "L" );`
		286	`}`
		287	`else`
		288	`{`
		289	`$pdf->setX( 20 );`
		290	`$pdf->cell( 80, 4, $firma, 0, 1, "L" );`
		291	`$pdf->setX( 20 );`
		292	`$pdf->cell( 80, 4, $anrede . " " . $name, 0, 1, "L" );`
		293	`}`
		294	`$pdf->setX( 20 );`
		295	`$pdf->cell( 80, 4, $str, 0, 1, "L" );`
		296	`$pdf->setX( 20 );`
		297	`$pdf->cell( 80, 4, "$plz $ort", 0, 1, "L" );`
		298	`if ( $Infozeile != 'on' )`
		299	`{`
		300	`$pdf->setY( 80 );`
		301	`$pdf->cell( 150, 4, "Kunden Nr.:", 0, 0, "R" );`
		302	`$pdf->cell( 0, 4, $row_l["ID"], 0, 1, "R" );`
		303	`$pdf->cell( 150, 4, "Bearbeiter:", 0, 0, "R" );`
		304	`$pdf->cell( 0, 4, $b_name, 0, 1, "R" );`
		305	`$pdf->cell( 150, 4, "USt-IdNr.:", 0, 0, "R" );`
		306	`$pdf->cell( 0, 4, $haendler_ust_id, 0, 1, "R" );`
		307
		308	`if ( LEISTUNGS_DATUM == true )`
		309	`{`
		310	`$pdf->cell( 150, 4, "Leistungsdatum:", 0, 0, "R" );`
		311	`$pdf->cell( 0, 4, $dat["Datum"], 0, 0, "R" );`
		312	`}`
		313	`else`
		314	`{`
		315	`$pdf->cell( 150, 4, "Datum:", 0, 0, "R" );`
		316	`$pdf->cell( 0, 4, date("d.m.Y"), 0, 0, "R" );`
		317	`}`
		318	`}`
		319
		320	`// Lieferadresse auf Angebot ausdrucken?`
		321	`if ( (isset($web_rechte["Warenwirtschaft"]["bestellung"]["angebot"]) and`
		322	`(isset($web_rechte["Warenwirtschaft"]["bestellung"]["lieferadresse_auf_angebot"]) and`
		323	`($row_b['liefer_Strasse']))) )`
		324	`{`
		325	`$pdf->setY( 50 );`
		326	`$pdf->setX( 135 );`
		327	`$pdf->setFont( 'Arial', 'B', 8 );`
		328	`$pdf->cell( 145, 4, "Lieferadresse:", 0, 2, "L" );`
		329	`$pdf->setFont( 'Arial', '', 8 );`
		330	`if ( $row_b['liefer_Firma'] )`
		331	`$pdf->cell( 145, 4, $row_b['liefer_Firma'], 0, 2, "L" );`
		332	`if ( $row_b['liefer_Name'] )`
		333	`$pdf->cell( 145, 4, $row_b['liefer_Name'], 0, 2, "L" );`
		334	`if ( $row_b['liefer_Strasse'] )`
		335	`$pdf->cell( 145, 4, $row_b['liefer_Strasse'] . " " . $row_b['liefer_Str_Nr'],`
		336	`0, 2, "L" );`
		337	`if ( $row_b['liefer_Ort'] )`
		338	`$pdf->cell( 145, 4, $row_b['liefer_PLZ'] . " " . $row_b['liefer_Ort'],`
		339	`0, 2, "L" );`
		340	`if ( $row_b['liefer_Land'] )`
		341	`$pdf->cell( 145, 4, $row_b['liefer_Land'], 0, 2, "L" );`
		342	`}`
		343
		344	`$pdf->ln( 10 );`
		345	`$pdf->SetFont( 'Arial', 'B', 14 );`
		346	`if ( !$Rechungsueberschrift )`
		347	`{`
		348	`$pdf->cell( 0, 4, $REName, 0, 1, "C" );`
		349	`}`
		350	`else`
		351	`{`
		352	`$fill = "cell( 0, 4, \'Angebot\' , 0, 1, \'L\' )";`
		353	`$pdf->$fill;`
		354	`}`
		355	`$pdf->ln( 5 );`
		356	`$pdf->SetFont( 'Arial', 'B', 9 );`
		357	`$sql = "SELECT * FROM artikel_to_Bestellung WHERE Bestellung=$b_id AND status!='storniert'";`
		358	`/*if ( $Status )`
		359	`{`
		360	`$sql .= " AND rechnungStatus = 'schreiben'";`
		361	`}*/`
		362	`$sql .= " ORDER BY Rang";`
		363	`$res = mysql_query_logged( $sql );`
		364	`$summe_n = array();`
		365	`$summe_b = array();`
		366	`$preis_n = 0;`
		367	`$g_preis = 0;`
		368	`$g_preis_n = 0;`
		369	`$pos = 1;`
		370	`$mwst_arr = array( 0 => 19, 1 => 7, null => 19 );`
		371
		372	`//Zusatzkopf`
		373	`if ( $Infozeile == 'on' )`
		374	`{`
		375	`$pdf->Ln( 15 );`
		376	`$pdf->setFillColor( 204 );`
		377	`$pdf->cell( 30, 4, "Angebots Nr.", "LTR", 0, "C", 1 );`
		378	`$pdf->cell( 30, 4, "Kunden Nr.", "LTR", 0, "C", 1 );`
		379	`$pdf->cell( 70, 4, "Bearbeiter", "LTR", 0, "C", 1 );`
		380	`if ( LEISTUNGS_DATUM == true )`
		381	`{`
		382	`$pdf->cell( 34, 4, "Leistungsdatum", "LTR", 0, "C", 1 );`
		383	`}`
		384	`else`
		385	`{`
		386	`$pdf->cell( 34, 4, "Datum", "LTR", 0, "C", 1 );`
		387	`}`
		388	`$pdf->cell( 0, 4, "Seite", "LTR", 1, "C", 1 );`
		389	`$pdf->setFillColor( 255 );`
		390	`$pdf->cell( 30, 4, "AG $r_nr", "LBR", 0, "C", 1 );`
		391	`$pdf->cell( 30, 4, $row_l['ID'], "LBR", 0, "C", 1 );`
		392	`$pdf->cell( 70, 4, "$b_name", "LBR", 0, "C", 1 );`
		393	`if ( LEISTUNGS_DATUM == true )`
		394	`{`
		395	`$pdf->cell( 34, 4, $dat["Datum"], "LBR", 0, "C", 1 );`
		396	`}`
		397	`else`
		398	`{`
		399	`$pdf->cell( 34, 4, date('d.m.Y'), "LBR", 0, "C", 1 );`
		400	`}`
		401	`$pdf->cell( 0, 4, $pdf->PageNo(), "LBR", 1, "C", 1 );`
		402	`}`
		403	`$pdf->setFillColor( 204 );`
		404	`$pdf->cell( 10, 4, "$Pos_text", "LTR", 0, "C", 1 );`
		405	`$pdf->cell( 20, 4, "$Menge_text", "LTR", 0, "C", 1 );`
		406	`$pdf->cell( 20, 4, "$Kennung_text", "LTR", 0, "C", 1 );`
		407	`$pdf->cell( 100, 4, "$Text_text", "LTR", 0, "C", 1 );`
		408	`$pdf->cell( 20, 4, "$Einzelpreis_text", "LTR", 0, "C", 1 );`
		409	`$pdf->cell( 0, 4, "$Gesamtpreis_text", "LTR", 1, "C", 1 );`
		410	`$pdf->cell( 10, 4, "", "LBR", 0, "C", 1 );`
		411	`$pdf->cell( 20, 4, "", "LBR", 0, "C", 1 );`
		412	`$pdf->cell( 20, 4, "", "LBR", 0, "C", 1 );`
		413	`$pdf->cell( 100, 4, "", "LBR", 0, "C", 1 );`
		414	`$pdf->cell( 20, 4, "€", "LBR", 0, "C", 1 );`
		415	`$pdf->cell( 0, 4, "€", "LBR", 1, "C", 1 );`
		416	`$pdf->setFillColor( 255 );`
		417	`$pdf->SetFont( 'Arial', '', 9 );`
		418	`while ( $row = mysql_fetch_assoc($res) )`
		419	`{`
		420	`$menge = $row["Menge"];`
		421	`$e_preis = $row["Preis_pro_Stueck"];`
		422	`if ( $row["artikel"] != 999999 && $row["artikel"] != "0" )`
		423	`{`
		424	`$sql_a = "SELECT * from artikel WHERE ID=" . $row["artikel"];`
		425	`$res_a = mysql_query( $sql_a );`
		426	`$row_a = mysql_fetch_assoc( $res_a );`
		427	`$kennung = $row_a["kennung"];`
		428	`$mwst = ( $row["mwst"] != "0.00" ) ? $row["mwst"] : $mwst_arr[$row_a["tax1"]];`
		429	`$preis_n = $e_preis - ( $e_preis * $mwst / (100 + $mwst) );`
		430	`if ( $row_a["Father"] == -3 )`
		431	`{`
		432	`$versandname = $row["Bezeichnung"];`
		433	`$pos = "";`
		434	`$menge = "";`
		435	`$g_preis = $e_preis;`
		436	`$g_preis_n = $preis_n;`
		437	`}`
		438	`else`
		439	`{`
		440	`$g_preis = $e_preis * $menge;`
		441	`$g_preis_n = $preis_n * $menge;`
		442	`}`
		443	`}`
		444	`else`
		445	`{`
		446	`$mwst = 19;`
		447	`$preis_n = $e_preis - ( $e_preis * $mwst / (100 + $mwst) );`
		448	`$g_preis = $e_preis * $menge;`
		449	`$g_preis_n = $preis_n * $menge;`
		450	`$kennung = "";`
		451	`}`
		452	`$summe_b[$mwst] += $g_preis;`
		453	`$summe_n[$mwst] += $g_preis_n;`
		454	`$a_name = $row["Bezeichnung"];`
		455	`$h = $pdf->NbLines( 100, $a_name );`
		456	`$h = 5 * $h;`
		457	`//var_dump($h);`
		458	`$x = $pdf->GetX();`
		459	`$y = $pdf->GetY();`
		460	`$pdf->Multicell( 10, $h, $pos, 1, "C" );`
		461	`$pdf->SetXY( $x + 10, $y );`
		462	`$x = $pdf->GetX();`
		463	`$y = $pdf->GetY();`
		464	`$pdf->Multicell( 20, $h, (is_numeric($pos)) ? number_format($menge,`
		465	`2, ',', '.') : "", 1, "R" );`
		466	`$pdf->SetXY( $x + 20, $y );`
		467	`$x = $pdf->GetX();`
		468	`$y = $pdf->GetY();`
		469	`$pdf->Multicell( 20, $h, $kennung, 1, "C" );`
		470	`$pdf->SetXY( $x + 20, $y );`
		471	`$x = $pdf->GetX();`
		472	`$y = $pdf->GetY();`
		473	`$pdf->Multicell( 100, 5, $a_name, 1, "L" );`
		474	`$pdf->SetXY( $x + 100, $y );`
		475	`$x = $pdf->GetX();`
		476	`$y = $pdf->GetY();`
		477	`$pdf->Multicell( 20, $h, number_format($preis_n, 3, ',', '.'), 1,`
		478	`"R" );`
		479	`$pdf->SetXY( $x + 20, $y );`
		480	`$pdf->Multicell( 0, $h, number_format($g_preis_n, 2, ',', '.'),`
		481	`1, "R" );`
		482	`//$pdf->ln( 4 );`
		483	`/*if ( $Status )`
		484	`{`
		485	`$sql_s =`
		486	`"UPDATE artikel_to_Bestellung SET rechnungStatus='geschrieben' WHERE ID=" .`
		487	`$row["ID"];`
		488	`mysql_query_logged( $sql_s ) or die( mysql_errno() . ": " .`
		489	`mysql_error() );`
		490	`}*/`
		491	`$pos++;`
		492	`}`
		493	`$sql = "`
		494	`SELECT`
		495	`ab.*`
		496	`FROM`
		497	`artikel_to_Bestellung ab,`
		498	`artikel a`
		499	`WHERE`
		500	`Bestellung=$b_id`
		501	`AND`
		502	`ab.status!='storniert'`
		503	`AND`
		504	`a.ID=ab.artikel`
		505	`AND`
		506	`a.Father=-3`
		507	`";`
		508	`$res = mysql_query_logged( $sql ) or mail( "niewerth@weban.de",`
		509	`"Fehler in createMailOrderText.php", mysql_errno() . ": " .`
		510	`mysql_error() . "<hr>$query<hr>",`
		511	`"from: cms_Warenwirtschaft_rechung.php select artikel_to_Bestellung" );`
		512	`if ( mysql_num_rows($res) )`
		513	`{`
		514	`$row = mysql_fetch_assoc( $res );`
		515	`$menge = $row["Menge"];`
		516	`$e_preis = $row["Preis_pro_Stueck"];`
		517	`if ( $row["artikel"] != 999999 )`
		518	`{`
		519	`$sql_a = "SELECT * from artikel WHERE ID=" . $row["artikel"];`
		520	`$res_a = mysql_query( $sql_a ) or die( mysql_errno() . ": " .`
		521	`mysql_error() );`
		522	`if ( !$res_a )`
		523	`{`
		524	`echo mysql_error() . "<br>$sql_a";`
		525	`var_dump( $row );`
		526	`}`
		527	`$row_a = mysql_fetch_assoc( $res_a );`
		528	`$kennung = $row_a["kennung"];`
		529	`$mwst = ( $row["mwst"] != "0.00" ) ? $row["mwst"] : $mwst_arr[$row_a["tax1"]];`
		530
		531	`$preis_n = $e_preis - ( $e_preis * $mwst / (100 + $mwst) );`
		532	`if ( $row_a["Father"] == -3 )`
		533	`{`
		534	`$versandname = $row["Bezeichnung"];`
		535	`$pos = "";`
		536	`$menge = "";`
		537	`$g_preis = $e_preis;`
		538	`$g_preis_n = $preis_n;`
		539	`}`
		540	`else`
		541	`{`
		542	`$g_preis = $e_preis * $menge;`
		543	`$g_preis_n = $preis_n * $menge;`
		544	`}`
		545	`}`
		546	`else`
		547	`{`
		548	`$mwst = 19;`
		549	`$preis_n = $e_preis - ( $e_preis * $mwst / (100 + $mwst) );`
		550	`$g_preis = $e_preis * $menge;`
		551	`$g_preis_n = $preis_n * $menge;`
		552	`$kennung = "";`
		553	`}`
		554	`$summe_b[$mwst] += $g_preis;`
		555	`$summe_n[$mwst] += $g_preis_n;`
		556	`$a_name = $row["Bezeichnung"];`
		557	`$pdf->cell( 10, 4, $pos, 1, 0, "C" );`
		558	`$pdf->cell( 20, 4, (is_numeric($pos)) ? number_format($menge, 2,`
		559	`',', '.') : "", 1, 0, "R" );`
		560	`$pdf->cell( 20, 4, $kennung, 1, 0, "C" );`
		561	`$pdf->cell( 100, 4, $a_name, 1, 0, "L", 0, "", 0, 0 );`
		562	`$pdf->cell( 20, 4, number_format($preis_n, 3, ',', '.'), 1, 0,`
		563	`"R" );`
		564	`$pdf->cell( 0, 4, number_format($g_preis_n, 2, ',', '.'), 1, 0,`
		565	`"R" );`
		566	`$pdf->ln( 4 );`
		567	`$pos++;`
		568	`}`
		569
		570	`foreach ( $summe_n as $mwst => $betrag )`
		571	`{`
		572	`$summe_n["total"] += $betrag;`
		573	`}`
		574	`foreach ( $summe_b as $mwst => $betrag )`
		575	`{`
		576	`$summe_b["total"] += $betrag;`
		577	`}`
		578	`$pdf->cell( 170, 4, "Gesamt Netto", 1, 0, "L" );`
		579	`$pdf->cell( 0, 4, number_format($summe_n["total"], 2, ',', '.'), 1,`
		580	`1, "R" );`
		581	`foreach ( $summe_n as $mwst => $betrag )`
		582	`{`
		583	`if ( $mwst != "total" )`
		584	`{`
		585	`$pdf->cell( 50, 4, "zzgl. $mwst % MwSt. auf ", "LBT", 0, "L" );`
		586	`//$summe_n[$mwst]=$summe_b[$mwst]* $mwst / 100+$mwst;`
		587	`$pdf->cell( 120, 4, number_format($betrag, 2, ',', '.'),`
		588	`"BTR", 0, "R" );`
		589	`$pdf->cell( 0, 4, number_format($betrag * ($mwst / 100), 2,`
		590	`',', '.'), 1, 1, "R" );`
		591	`}`
		592	`}`
		593	`$pdf->setFont( 'Arial', 'B', 12 );`
		594	`$pdf->cell( 170, 8, "Gesamtbetrag", "LBR", 0, "L" );`
		595	`$pdf->cell( 0, 8, number_format($summe_b["total"], 2, ',', '.'),`
		596	`"LBR", 1, "R" );`
		597	`$pdf->cell( 0, 8, "", "T", 1 );`
		598	`$pdf->setFont( 'Arial', '', 9.5 );`
		599	`if ( $row_b["Bemerkung_extern"] )`
		600	`{`
		601	`// externe Bemerkung`
		602	`$pdf->multiCell( 35, 4, "", 0, 0, "L" );`
		603	`$pdf->setFont( 'Arial', 'B', 9.5 );`
		604	`$pdf->multiCell( 0, 4, $row_b["Bemerkung_extern"], 0, 1, "L" );`
		605	`$pdf->setFont( 'Arial', '', 9.5 );`
		606	`}`
		607	`if ( VERSAND_ANZEIGEN )`
		608	`{`
		609	`$pdf->multiCell( 0, 4, "\r\nZahlung: $versandname\n$zahlungs_hinweis",`
		610	`0, 1, "L" );`
		611	`}`
		612	`else`
		613	`{`
		614	`$pdf->multiCell( 0, 4, "\r\n$zahlungs_hinweis", 0, 1, "L" );`
		615	`}`
		616
		617	`// START die Anzeige der ausgewählten Angebotsbausteine`
		618	`if ( ($web_rechte["Warenwirtschaft"]["bestellung"]["angebotsbausteine"]) and`
		619	`($_POST['action'] == "genPDF") )`
		620	`{`
		621	`//$pdf->multiCell( 0, 4, "Bemerkung:", 0, 1, "L" );`
		622	`//$pdf->setFont( 'Arial', '', 9.5 );`
		623
		624	`foreach ( $_POST['baustein'] as $kk => $vv )`
		625	`{`
		626
		627	`$pdf->multiCell( 0, 4, $vv, 0, 1, "L" );`
		628	`$pdf->setFont( 'Arial', '', 9.5 );`
		629	`}`
		630	`}`
		631	`// ENDE die Anzeige der ausgewählten Angebotsbausteine`
		632
		633	`if ( $Speichern )`
		634	`{`
		635	`$pdf->Output( $webs['verzeichnis'] . "/images/dokumente/" . $fName,`
		636	`"F" );`
		637	`$sql = "`
		638	`INSERT INTO`
		639	`dokumente`
		640	`(`
		641	`table_foreign,`
		642	`row_foreign,`
		643	`data_foreign,`
		644	`document,`
		645	`letzte_Aenderung_am,`
		646	`letzte_Aenderung_von`
		647	`)`
		648	`VALUES`
		649	`(`
		650	`'Bestellung',`
		651	`'ID',`
		652	`$b_id,`
		653	`'$fName',`
		654	`NOW(),`
		655	`'" . $_SERVER["PHP_AUTH_USER"] . "'`
		656	`)`
		657	`";`
		658	`mysql_query_logged( $sql ) or mail( "niewerth@weban.de",`
		659	`"Fehler in createMailOrderText.php", mysql_errno() . ": " .`
		660	`mysql_error() . "<hr>$query<hr>",`
		661	`"from: cms_Warenwirtschaft_rechung.php into documente" );`
		662	`}`
		663	`$pdf->Output();`
		664	`}`
		665
		666	`?>`

Subversion-Projekte lars-tiefland.content-management

(root)/trunk/Warenwirtschaft/angebot.php – Revision 1