=".$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();
}
?>