<?php
$table = new NTKTable("table", 3, 4, False);
$number_label = new NTKLabel("", "Kategorienummer:");
$table->add($number_label, 0, 0);
$number_entry = new NTKLabel("category_id", $data[0][0]);
$table->add($number_entry, 0, 1, 150);
$name_label = new NTKLabel("", "Bezeichner:");
$table->add($name_label, 1, 0);
$name_entry = new NTKEntry("name", $data[0][1]);
$table->add($name_entry, 1, 1);
$onload .= "document.getElementById('name').focus();";
$details_label = new NTKLabel("", "Beschreibung:");
$table->add($details_label, 1, 2);
$details_entry = new NTKEntry("details", $data[0][2]);
$table->add($details_entry, 1, 3);
$delete_button = new NTKButton("delete", "Löschen", "if(confirm('Wirklich loeschen?')) location.href = 'category.php?db_action=delete&category_id=" . $data[0][0] . "';");
$table->add($delete_button, 2, 1);
$cancel_button = new NTKButton("cancel", "Abbrechen", "location.href = 'category.php';");
$table->add($cancel_button, 2, 2);
$submit_button = new NTKButton("submit", "Speichern", "document.forms['category'].submit();");
$table->add($submit_button, 2, 3);
$form = new NTKForm("category", "category.php", $table);
$form->addAttribute("db_action", "edit");
$form->addAttribute("category_id", $data[0][0]);
$main_box->add($form, False, True, "background-color: #dfe7f3; vertical-align: middle; align: center;");
<?php
$table = new NTKTable("table", 2, 4, False);
$name_label = new NTKLabel("", "Bezeichner:");
$table->add($name_label, 0, 0);
$name_entry = new NTKEntry("name");
$table->add($name_entry, 0, 1);
$onload .= "document.getElementById('name').focus();";
$assistant_id_label = new NTKLabel("", "Mitarbeiter:");
$table->add($assistant_id_label, 0, 2);
$assistant_id_entry = new NTKComboBox("assistant_id", $assistant->get());
$table->add($assistant_id_entry, 0, 3);
$cancel_button = new NTKButton("cancel", "Abbrechen", "location.href = 'tour.php';");
$table->add($cancel_button, 1, 2);
$submit_button = new NTKButton("submit", "Tour erstellen", "document.forms['tour'].submit();");
$table->add($submit_button, 1, 3);
$form = new NTKForm("tour", "tour.php", $table);
$form->addAttribute("db_action", "new");
$form->addAttribute("tour_id", "");
$main_box->add($form, False, True, "background-color: #dfe7f3; vertical-align: middle; align: center;");
if (var_post("date_to", "")) {
if ($search) {
$search .= " AND (date <='" . var_post("date_to", "") . "') ";
} else {
$search .= "(date <='" . var_post("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";
} else {
$toolbar_box = new NTKVBox("toolbar_box", 0, 0, False);
$main_box = new NTKTable("main_box", 5, 4, False);
$main_box->setStyle("background-color: #dfe7f3;");
$main_box->add(new NTKLabel("", "<b>Rechnungszusammenfassung nach Datum</b>"), 0, 0);
$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_re'].submit();"), 4, 3);
$form = new NTKForm("print_re", "stat_bill_merge.php", $main_box);
$form->addAttribute("print", "print_re");
$toolbar_box->add($form, 0, 0);
echo getHead();
echo $toolbar_box->getHtml();
}
?>
</body>
<?php
$table = new NTKTable("table", 15, 4, False);
$number_label = new NTKLabel("", "Kundennummer:");
$table->add($number_label, 0, 0);
$number_entry = new NTKEntry("customer_number");
$table->add($number_entry, 0, 1, 150);
$onload .= "document.getElementById('customer_number').focus();";
$password_label = new NTKLabel("", "Passwort:");
$table->add($password_label, 0, 2);
$password_entry = new NTKEntry("password");
$table->add($password_entry, 0, 3, 150);
$prename_label = new NTKLabel("", "Name:");
$table->add($prename_label, 2, 0);
$prename_entry = new NTKEntry("prename");
$table->add($prename_entry, 2, 1);
$postname_label = new NTKLabel("", "Details:");
$table->add($postname_label, 2, 2);
$postname_entry = new NTKEntry("postname");
$table->add($postname_entry, 2, 3);
$street_label = new NTKLabel("", "Straße:");
$table->add($street_label, 3, 0);
$street_entry = new NTKEntry("street");
$table->add($street_entry, 3, 1);
$street_number_label = new NTKLabel("", "Hausnummer:");
$table->add($street_number_label, 3, 2);
$street_number_entry = new NTKEntry("streetnumber");
$table->add($street_number_entry, 3, 3);
$plz_label = new NTKLabel("", "PLZ:");
$table->add($plz_label, 4, 0);
$plz_entry = new NTKEntry("plz");
$bill_pos_table->add(new NTKButton("", "hinzufügen", "document.forms['bill_product_form_new'].submit();"), 1, 6);
for ($i = 0; $i < count($bill_list); $i++) {
$product_data = $product->get($bill_list[$i][2]);
$bill_pos_table->addFormRow("bill_product_form_" . $bill_list[$i][0], "bill.php", $i + 2, array(array('db_action', 'position_edit'), array('bill_product_id', $bill_list[$i][0]), array('bill_id', $bill_list[$i][1]), array('action', 'edit'), array('price', $bill_list[$i][6]), array('tax', $bill_list[$i][7]), array('from_page', $from_page), array('fp_tour_id', $fp_tour_id), array('fp_date', $fp_date)));
$product_id_entry = new NTKEntry("product_id", $bill_list[$i][2]);
$product_id_entry->addEvent("onkeyup", "parent.frames['action'].location.href='action_product.php?form=bill_product_form_" . $bill_list[$i][0] . "&entry=product_id&next=amount&search='+this.value;");
$bill_pos_table->add($product_id_entry, $i + 2, 0, 100);
$bill_pos_table->add(new NTKLabel("", $product_data[0][1]), $i + 2, 1);
$bill_pos_table->add(new NTKEntry("amount", $bill_list[$i][3]), $i + 2, 2, 60);
$bill_pos_table->add(new NTKEntry("details", $bill_list[$i][4]), $i + 2, 3, 200);
$bill_pos_table->add(new NTKEntry("rabatt", $bill_list[$i][5]), $i + 2, 4, 60);
$bill_pos_table->add(new NTKButton("", "ok", "document.forms['bill_product_form_" . $bill_list[$i][0] . "'].submit();"), $i + 2, 5);
$bill_pos_table->add(new NTKButton("", "löschen", "if(confirm('Wirklich loeschen?')) location.href = 'bill.php?action=edit&bill_id=" . $bill_list[$i][1] . "&db_action=position_delete&bill_product_id=" . $bill_list[$i][0] . "&from_page={$from_page}&fp_date={$fp_date}&fp_tour_id={$fp_tour_id}';"), $i + 2, 6);
}
$main_box->add($bill_pos_table, -1, -1, "background-color: #dfe7f3; vertical-align: top;");
$table = new NTKTable("table", 5, 4, False);
if ($data[0][5] == -1) {
$number_label = new NTKLabel("", "Rechnungsnummer:");
$table->add($number_label, 0, 0);
$number_entry = new NTKButton("bill_number", "Nummer setzen", "location.href = 'bill.php?db_action=set_number&bill_id=" . $data[0][0] . "';");
$table->add($number_entry, 0, 1, 150);
} elseif ($data[0][5] == -2) {
$number_label = new NTKLabel("", "kommt von der Homepage", "color: #00ff00;");
$table->add($number_label, 0, 0);
} else {
$number_label = new NTKLabel("", "Rechnungsnummer:");
$table->add($number_label, 0, 0);
$number_entry = new NTKLabel("bill_number", $data[0][5]);
$table->add($number_entry, 0, 1, 150);
}
$date_label = new NTKLabel("", "Datum (2006-01-30):");
<?php
$table = new NTKTable("table", 4, 4, False);
$number_label = new NTKLabel("", "Rechnungsnummer:");
$table->add($number_label, 0, 0);
$number_label = new NTKLabel("", "fortlaufend");
$table->add($number_label, 0, 1);
$date_label = new NTKLabel("", "Datum:");
$table->add($date_label, 1, 2);
$date = getdate(time());
$date_entry = new NTKEntry("date", $date['year'] . "-" . $date['mon'] . "-" . $date['mday']);
$table->add($date_entry, 1, 3);
$customer_id_label = new NTKLabel("", "Kundennummer:");
$table->add($customer_id_label, 1, 0);
$customer_id_entry = new NTKEntry("customer_id");
$onload .= "document.getElementById('customer_id').focus();";
$customer_id_entry->addEvent("onkeyup", "parent.frames['action'].location.href='action_customer.php?form=bill_form&entry=customer_id&next=date&search='+this.value;");
$table->add($customer_id_entry, 1, 1);
$cancel_button = new NTKButton("cancel", "Abbrechen", "location.href = 'bill.php';");
$table->add($cancel_button, 3, 2);
$submit_button = new NTKButton("submit", "Rechnung eintragen", "document.forms['bill_form'].submit();");
$table->add($submit_button, 3, 3);
$form = new NTKForm("bill_form", "bill.php", $table);
$form->addAttribute("db_action", "new");
$form->addAttribute("action", "edit");
$main_box->add($form, False, True, "background-color: #dfe7f3; vertical-align: middle; align: center;");
$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("", "<b>Rechnungszusammenfassung nach Datum</b>"), 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("", "<b>Produktverkauf in einem bestimmten Zeitraum</b>"), 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();
}
?>
</body>
<?php
$table = new NTKTable("table", 3, 4, False);
$category_id_label = new NTKLabel("", "Kategorienummer:");
$table->add($category_id_label, 0, 0);
$category_id_entry = new NTKEntry("category_id");
$table->add($category_id_entry, 0, 1);
$onload .= "document.getElementById('category_id').focus();";
$prename_label = new NTKLabel("", "Bezeichner:");
$table->add($prename_label, 1, 0);
$prename_entry = new NTKEntry("name");
$table->add($prename_entry, 1, 1);
$postname_label = new NTKLabel("", "Beschreibung:");
$table->add($postname_label, 1, 2);
$postname_entry = new NTKEntry("details");
$table->add($postname_entry, 1, 3);
$cancel_button = new NTKButton("cancel", "Abbrechen", "location.href = 'category.php';");
$table->add($cancel_button, 2, 2);
$submit_button = new NTKButton("submit", "Kategorie erstellen", "document.forms['category'].submit();");
$table->add($submit_button, 2, 3);
$form = new NTKForm("category", "category.php", $table);
$form->addAttribute("db_action", "new");
$main_box->add($form, False, True, "background-color: #dfe7f3; vertical-align: middle; align: center;");
<?php
$priceset_list = $priceset->get();
$table = new NTKTable("table", 7 + count($priceset_list), 4, False);
$number_label = new NTKLabel("", "Produktnummer:");
$table->add($number_label, 0, 0);
$number_entry = new NTKLabel("product_id", $data[0][0]);
$table->add($number_entry, 0, 1, 150);
$name_label = new NTKLabel("", "Bezeichnung:");
$table->add($name_label, 2, 0);
$name_entry = new NTKEntry("name", $data[0][1]);
$table->add($name_entry, 2, 1);
$details_label = new NTKLabel("", "Details:");
$table->add($details_label, 2, 2);
$details_entry = new NTKEntry("details", $data[0][2]);
$table->add($details_entry, 2, 3);
$category_id_label = new NTKLabel("", "Kategorie:");
$table->add($category_id_label, 3, 0);
$category_id_entry = new NTKComboBox("category_id", $category->get(), $data[0][3]);
$table->add($category_id_entry, 3, 1);
$tax_label = new NTKLabel("", "Steuer:");
$table->add($tax_label, 3, 2);
$tax_entry = new NTKComboBox("tax_id", $tax->get(), $data[0][4]);
$table->add($tax_entry, 3, 3);
$avilable_id_label = new NTKLabel("", "Zur Zeit verfügbar:");
$table->add($avilable_id_label, 4, 0);
$avilable_id_entry = new NTKCheckbox("available", 1, $data[0][5]);
$table->add($avilable_id_entry, 4, 1);
$group_id_label = new NTKLabel("", "Gruppe:");
$table->add($group_id_label, 4, 2);
$group_id_entry = new NTKComboBox("group_id", $group->get(), $data[0][6]);
require_once "DataBase/Tour.php";
$customer = new Customer();
$tour = new Tour();
if (var_post("print", "") == "print") {
$search = "";
$tour_data = "";
if (!var_post("tour_all", "")) {
$search = " tour_id='" . var_post("tour", "") . "' ";
$tour_data = $tour->get(var_post("tour", ''), array());
}
$customer_data = $customer->get('', array(), $search);
include "Druckvorlagen/zeilen.php";
include "Druckvorlagen/customer_list.php";
} else {
$toolbar_box = new NTKVBox("toolbar_box", 0, 0, False);
$main_box = new NTKTable("main_box", 3, 2, False);
$main_box->setStyle("background-color: #dfe7f3;");
$main_box->add(new NTKLabel("", "alle Touren"), 0, 0);
$main_box->add(new NTKCheckbox("tour_all", 1, False), 0, 1);
$main_box->add(new NTKLabel("", "aus Tour"), 1, 0);
$main_box->add(new NTKComboBox("tour", $tour->get("")), 1, 1);
$main_box->add(new NTKButton("submit", "Druckvorschau", "document.forms['print'].submit();"), 2, 1);
$form = new NTKForm("print", "stat_customer_list.php", $main_box);
$form->addAttribute("print", "print");
$toolbar_box->add($form, 0, 0);
echo getHead();
echo $toolbar_box->getHtml();
}
?>
</body>
</html>
<?php
$table = new NTKTable("table", 11, 4, False);
$prename_label = new NTKLabel("", "Vorname:");
$table->add($prename_label, 0, 0);
$prename_entry = new NTKEntry("prename");
$table->add($prename_entry, 0, 1);
$onload .= "document.getElementById('prename').focus();";
$postname_label = new NTKLabel("", "Nachname:");
$table->add($postname_label, 0, 2);
$postname_entry = new NTKEntry("postname");
$table->add($postname_entry, 0, 3);
$street_label = new NTKLabel("", "Straße:");
$table->add($street_label, 1, 0);
$street_entry = new NTKEntry("street");
$table->add($street_entry, 1, 1);
$street_number_label = new NTKLabel("", "Hausnummer:");
$table->add($street_number_label, 1, 2);
$street_number_entry = new NTKEntry("streetnumber");
$table->add($street_number_entry, 1, 3);
$plz_label = new NTKLabel("", "PLZ:");
$table->add($plz_label, 2, 0);
$plz_entry = new NTKEntry("plz");
$table->add($plz_entry, 2, 1);
$city_label = new NTKLabel("", "Ort:");
$table->add($city_label, 2, 2);
$city_entry = new NTKEntry("city");
$table->add($city_entry, 2, 3);
$telephone_label = new NTKLabel("", "Telefon:");
$table->add($telephone_label, 3, 0);
$telephone_entry = new NTKEntry("telephone");
$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_dialog.php", $main_box);
$form->addAttribute("print", "print");
$main_box->add($form, False, False, "background-color: #dfe7f3;");
$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_dialog.php", $main_box);
$form->addAttribute("print", "print_re");
$main_box->add($form, False, False, "background-color: #dfe7f3;");
echo getHead();
echo $main_box->getHtml();
}
?>
$bills = "";
for ($i = 0; $i < count($bill_data); $i++) {
$bills = $bills . " " . $bill_data[$i][0] . " (";
$bills = $bills . " " . $bill_data[$i][1] . ") ; ";
}
$result_box->add(new NTKLabel("", $bills), 2, 1);
$result_box->add(new NTKLabel("", "Von Kunden:"), 3, 0);
$customer_string = "";
for ($i = 0; $i < count($customer_data); $i++) {
$customer_string = $customer_string . " " . $customer_data[$i][0] . "(";
$customer_string = $customer_string . " " . $customer_data[$i][1] . ") ; ";
}
$result_box->add(new NTKLabel("", $customer_string), 3, 1);
$toolbar_box->add($result_box, 0, 0);
}
$main_box = new NTKTable("main_box", 6, 4, False);
$main_box->setStyle("background-color: #dfe7f3;");
$main_box->add(new NTKLabel("", "<b>Produktverkauf in einem bestimmten Zeitraum</b>"), 0, 0);
$main_box->add(new NTKLabel("", "Produktnummer:"), 2, 0);
$main_box->add(new NTKEntry("product_id", $product_id), 2, 1);
$main_box->add(new NTKLabel("", "Von:"), 3, 0);
$main_box->add(new NTKEntry("date_from", $date_from), 3, 1);
$main_box->add(new NTKLabel("", "Bis:"), 3, 2);
$main_box->add(new NTKEntry("date_to", $date_to), 3, 3);
$main_box->add(new NTKButton("submit", "OK", "document.forms['stat_product_date_count'].submit();"), 5, 3);
$form = new NTKForm("stat_product_date_count", "stat_product_date_count.php", $main_box);
$toolbar_box->add($form, 10, 0);
echo $toolbar_box->getHtml();
?>
</body>
</html>
