=".$var_product_id_from.") "; else $search .= "(product_id >=".$var_product_id_from.") "; } if($var_product_id_to) { if($search) $search .= " AND (product_id <=".$var_product_id_to.") "; else $search .= "(product_id <=".$var_product_id_to.") "; } $product_data = $product->get('', array(), $search); $assistant_data = $assistant->get($var_assistant); $priceset = new Priceset(); $tmp = $priceset->get($var_priceset); $priceset_data = $tmp[0]; include("Druckvorlagen/zeilen.php"); include("Druckvorlagen/list.php"); } elseif($var_print == "print_re") { $search = ""; if($var_product_id) { if($search) $search .= " AND (product_id >=".$var_product_id.") "; else $search .= "(product_id >=".$var_product_id.") "; } if($var_date_from) { if($search) $search .= " AND (date >='".$var_date_from."') "; else $search .= "(date >='".$var_date_from."') "; } if($var_date_to) { if($search) $search .= " AND (date <='".$var_date_to."') "; else $search .= "(date <='".$var_date_to."') "; } $bill_data = $bill->get("", array("bill_id"), $search); $bill_product = new Bill_Product(); $tour_data[1] = "( Alle Touren )"; $product = new Product(); $product_data = $product->get(); include("Druckvorlagen/tour.php"); } elseif($var_print == "print_2") { if($var_product_id != "" && $var_date_from != "" && $var_date_to != "") { $product_amount = $product->getAmountByDate($var_product_id, $var_date_from, $var_date_to); echo "Menge von Produkt ".$var_product_id." : ".$product_amount; } } else { echo getHead(); $main_box = new NTKTable("main_box", 14, 4, False); $main_box->setStyle("background-color: #dfe7f3;"); $main_box->add(new NTKLabel("", "Produktnummer von:"), 1, 0); $main_box->add(new NTKEntry("product_id_from", ""), 1, 1); $main_box->add(new NTKLabel("", "bis: "), 1, 2); $main_box->add(new NTKEntry("product_id_to", ""), 1, 3); $main_box->add(new NTKLabel("", "alle Gruppen"), 3, 0); $main_box->add(new NTKCheckbox("group_all", 1, True), 3, 1); $main_box->add(new NTKLabel("", "aus Gruppe"), 3, 2); $main_box->add(new NTKComboBox("group", $group->get("")), 3, 3); $main_box->add(new NTKLabel("", "verfügbare"), 5, 0); $main_box->add(new NTKCheckbox("available", 1, True), 5, 1); $main_box->add(new NTKLabel("", "nicht verfügbare"), 5, 2); $main_box->add(new NTKCheckbox("not_available", 1, False), 5, 3); $main_box->add(new NTKLabel("", "aus Preisliste"), 7, 0); $main_box->add(new NTKComboBox("priceset", $priceset->get("")), 7, 1); $main_box->add(new NTKLabel("", "alle Kategorien"), 9, 0); $main_box->add(new NTKCheckbox("category_all", 1, True), 9, 1); $main_box->add(new NTKLabel("", "aus Kategorie"), 9, 2); $main_box->add(new NTKComboBox("category", $category->get("")), 9, 3); $main_box->add(new NTKLabel("", "Mitarbeiter"), 11, 0); $main_box->add(new NTKComboBox("assitant", $assistant->get("")), 11, 1); $main_box->add(new NTKButton("submit", "Druckvorschau", "document.forms['print'].submit();"), 13, 3); $form = new NTKForm("print", "print.php", $main_box); $form->addAttribute("print", "print"); echo $form->getHtml(); $main_box = new NTKTable("main_box", 3, 4, False); $main_box->setStyle("background-color: #dfe7f3;"); $main_box->add(new NTKLabel("", "Rechnungszusammenfassung nach Datum"), 0, 0); $main_box->add(new NTKLabel("", "Von:"), 1, 0); $main_box->add(new NTKEntry("date_from", ""), 1, 1); $main_box->add(new NTKLabel("", "Bis:"), 1, 2); $main_box->add(new NTKEntry("date_to", ""), 1, 3); $main_box->add(new NTKButton("submit", "Druckvorschau", "document.forms['print_re'].submit();"), 2, 3); $form = new NTKForm("print_re", "print.php", $main_box); $form->addAttribute("print", "print_re"); echo $form->getHtml(); # maske zur listenerzeugung von verkaufszahlen pro produkt in einem bestimmten Zeitraum $main_box = new NTKTable("main_box", 5, 4, False); $main_box->setStyle("background-color: #dfe7f3;"); $main_box->add(new NTKLabel("", "Produktverkauf in einem bestimmten Zeitraum"), 0, 0); $main_box->add(new NTKLabel("", "Produktnummer:"), 1, 0); $main_box->add(new NTKEntry("product_id", ""), 1, 1); $main_box->add(new NTKLabel("", "Von:"), 2, 0); $main_box->add(new NTKEntry("date_from", ""), 2, 1); $main_box->add(new NTKLabel("", "Bis:"), 2, 2); $main_box->add(new NTKEntry("date_to", ""), 2, 3); $main_box->add(new NTKButton("submit", "Druckvorschau", "document.forms['print_2'].submit();"), 4, 3); $form = new NTKForm("print_2", "print.php", $main_box); $form->addAttribute("print", "print_2"); echo $form->getHtml(); } ?>