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

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

Subversion-Projekte lars-tiefland.content-management

(root)/trunk/Warenwirtschaft/lieferschein.php – Revision 2