<?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;");
<?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
$small_toolbar = new NTKHBox("small_toolbar", 5, 0, False);
$new_button = new NTKButton("new_button", "Neue Rechnung eintragen", "location.replace('bill.php?action=new');");
$small_toolbar->add($new_button, 230);
$small_toolbar->add($spacer);
$search_toolbar = new NTKHBox("search_toolbar", 2, 0, False);
$search_entry = new NTKEntry("search_entry");
$search_toolbar->add($search_entry, 150);
$search_button = new NTKButton("search_button", "Suchen", "document.forms['search'].submit();");
$search_toolbar->add($search_button, 80);
$search_form = new NTKForm("search", "bill.php", $search_toolbar);
$search_form->addAttribute("action", "search");
$small_toolbar->add($search_form, 240);
$main_box->add($small_toolbar, True, False, "background-color: #dfe7f3;");
$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>
</html>
$price_list_label = new NTKLabel("", "Preisliste:");
$table->add($price_list_label, 8, 0);
$price_list_list = new NTKComboBox("pricelist_id", $priceset->get());
$table->add($price_list_list, 8, 1);
$tour_label = new NTKLabel("", "Tour:");
$table->add($tour_label, 8, 2);
$tour_list = new NTKComboBox("tour_id", $tour->get());
$table->add($tour_list, 8, 3);
$details_label = new NTKLabel("", "Anmerkung:");
$table->add($details_label, 9, 0);
$details_entry = new NTKEntry("details");
$table->add($details_entry, 9, 1);
$blz_label = new NTKLabel("", "BLZ:");
$table->add($blz_label, 11, 0);
$blz_entry = new NTKEntry("blz");
$table->add($blz_entry, 11, 1);
$ktno_label = new NTKLabel("", "Kontonummer:");
$table->add($ktno_label, 11, 2);
$ktno_entry = new NTKEntry("bank_account");
$table->add($ktno_entry, 11, 3);
$bankname_label = new NTKLabel("", "Bankverbindung:");
$table->add($bankname_label, 12, 0);
$bankname_entry = new NTKEntry("bank_name");
$table->add($bankname_entry, 12, 1);
$cancel_button = new NTKButton("cancel", "Abbrechen", "location.href = 'customer.php';");
$table->add($cancel_button, 14, 2);
$submit_button = new NTKButton("submit", "Kunde erstellen", "document.forms['customer'].submit();");
$table->add($submit_button, 14, 3);
$form = new NTKForm("customer", "customer.php", $table);
$form->addAttribute("db_action", "new");
$main_box->add($form, False, True, "background-color: #dfe7f3; vertical-align: middle; align: center;");
<?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;");
$list_view->addLines($tour->get('', array('tour_id', 'name'), "tour_id LIKE '%{$search}%' OR name LIKE'%{$search}%'"));
$main_box->add($list_view, -1, -1, "background-color: #dfe7f3; vertical-align: top;");
} elseif ($action == "list_tour") {
$assistant = new Assistant();
$tour = new Tour();
$bill_box = new NTKHBox("bill_box", 0, 0);
$bill_box->add(new NTKLabel("", "<b>Tournummer: " . $tour_id . " - Datum: " . $datum . "</b>"), False, False, "background-color: #dfe7f3;");
$bill_box->add(new NTKLabel("", "Kundennummer:"), 150);
$bill_box->add(new NTKEntry("customer_id", ""), 120);
$bill_box->add(new NTKLabel("", "Mitarbeiter:"), 120);
$bill_box->add(new NTKComboBox("assistant_id", $assistant->get()), 120);
$bill_box->add(new NTKLabel("", "Tour:"), 80);
$bill_box->add(new NTKComboBox("tour_id", $tour->get()), 120);
$bill_box->add(new NTKButton("bill_button", "Erstelle Rechnung", "document.forms['bill_form'].submit();"), 200);
$bill_form = new NTKForm("bill_form", "tour.php", $bill_box);
$bill_form->addAttribute("db_action", "tour_to_bill");
$bill_form->addAttribute("date", $datum);
$bill_form->addAttribute("current_tour_id", $tour_id);
$main_box->add($bill_form, 0, 0, "background-color: #dfe7f3; vertical-align: top;");
$list_view = new NTKListView("list_view", array('Rechnungsnummer', 'Kunde'), "location.href = 'bill.php?from_page=tour&fp_tour_id={$tour_id}&fp_date=" . $datum . "&action=edit&bill_id=%0%';");
$list_view->addLines($bill->get('', array('bill_id', 'bill.customer_id'), "bill.tour_id='{$tour_id}' AND date='" . $datum . "'"));
$main_box->add($list_view, -1, -1, "background-color: #dfe7f3; vertical-align: top;");
} else {
$list_view = new NTKListView("list_view", array('Tournummer', 'Bezeichner'), "location.href = 'tour.php?action=edit&tour_id=%0%';");
$list_view->addLines($tour->get('', array('tour_id', 'name')));
$main_box->add($list_view, -1, -1, "background-color: #dfe7f3; vertical-align: top;");
}
// main content
$main_box->add($spacer, -1, -1, "background-color: #dfe7f3;");
echo getHead();
echo $main_box->getHtml();
<?php
$table = new NTKTable("table", 2, 4, False);
$name_label = new NTKLabel("", "Bezeichner:");
$table->add($name_label, 0, 0);
$name_entry = new NTKEntry("name", $data[0][1]);
$table->add($name_entry, 0, 1);
$assistant_id_label = new NTKLabel("", "Mitarbeiter:");
$table->add($assistant_id_label, 0, 2);
$assistant_id_entry = new NTKComboBox("assistant_id", $assistant->get(), $data[0][2]);
$table->add($assistant_id_entry, 0, 3);
$delete_button = new NTKButton("delete", "Löschen", "if(confirm('Wirklich loeschen?')) location.href = 'tour.php?db_action=delete&tour_id=" . $data[0][0] . "';");
$table->add($delete_button, 1, 1);
$cancel_button = new NTKButton("cancel", "Abbrechen", "location.href = 'tour.php';");
$table->add($cancel_button, 1, 2);
$submit_button = new NTKButton("submit", "Speichern", "document.forms['tour'].submit();");
$table->add($submit_button, 1, 3);
$form = new NTKForm("tour", "tour.php", $table);
$form->addAttribute("db_action", "edit");
$form->addAttribute("tour_id", $data[0][0]);
$main_box->add($form, False, True, "background-color: #dfe7f3; vertical-align: middle; align: center;");
$assistant_id_entry = new NTKComboBox("assistant_id", $assistant->get(), $data[0][4]);
$table->add($assistant_id_entry, 2, 1);
} else {
$assistant_id_entry = new NTKLabel("assistant_id", $data[0][4]);
$table->add($assistant_id_entry, 2, 1, 150);
}
$delete_button = new NTKButton("delete", "Löschen", "if(confirm('Wirklich loeschen?')) location.href = 'bill.php?db_action=delete&bill_id=" . $data[0][0] . "&from_page={$from_page}&fp_date={$fp_date}&fp_tour_id={$fp_tour_id}';");
$table->add($delete_button, 4, 1);
$cancel_button = new NTKButton("cancel", "Abbrechen", "location.href = 'bill.php';");
$table->add($cancel_button, 4, 2);
if ($data[0][5] == -2) {
$submit_button = new NTKButton("submit", "Speichern/RechnungsNr. -1", "document.forms['bill_form'].submit();");
} else {
$submit_button = new NTKButton("submit", "Speichern", "document.forms['bill_form'].submit();");
}
$table->add($submit_button, 4, 3);
$form = new NTKForm("bill_form", "bill.php", $table);
if ($data[0][5] == -2) {
$form->addAttribute("bill_number", -1);
} else {
$form->addAttribute("bill_number", $data[0][5]);
}
if ($data[0][5] != -1) {
$form->addAttribute("assistant_id", $data[0][4]);
}
$form->addAttribute("db_action", "edit");
$form->addAttribute("bill_id", $data[0][0]);
$form->addAttribute("from_page", $from_page);
$form->addAttribute("fp_tour_id", $fp_tour_id);
$form->addAttribute("fp_date", $fp_date);
$main_box->add($form, -1, -1, "background-color: #dfe7f3; vertical-align: middle; align: center;");
$anmerkung_label = new NTKLabel("", "Anmerkung:");
$table->add($anmerkung_label, 5, 2);
$anmerkung_entry = new NTKEntry("anmerkung", $data[0][8]);
$table->add($anmerkung_entry, 5, 3);
// adding dynamic-pricesets
$row = 6;
for ($i = 0; $i < count($priceset_list); $i++) {
$priceset_label = new NTKLabel("", $priceset_list[$i][1] . ":");
$table->add($priceset_label, $row, 0);
$tmp_price = $price->getPrice($priceset_list[$i][0], $data[0][0]);
if (count($tmp_price) > 0) {
$priceset_entry = new NTKEntry("priceset_price_" . $i, $tmp_price[0][3]);
} else {
$priceset_entry = new NTKEntry("priceset_price_" . $i, 0);
}
$table->add($priceset_entry, $row, 1);
$row++;
}
$delete_button = new NTKButton("delete", "Löschen", "if(confirm('Wirklich loeschen?')) location.href = 'product.php?db_action=delete&product_id=" . $data[0][0] . "';");
$table->add($delete_button, $row, 1);
$cancel_button = new NTKButton("cancel", "Abbrechen", "location.href = 'product.php';");
$table->add($cancel_button, $row, 2);
$submit_button = new NTKButton("submit", "Speichern", "document.forms['product'].submit();");
$table->add($submit_button, $row, 3);
$form = new NTKForm("product", "product.php", $table);
$form->addAttribute("db_action", "edit");
$form->addAttribute("product_id", $data[0][0]);
for ($i = 0; $i < count($priceset_list); $i++) {
$form->addAttribute("priceset_id_" . $i, $priceset_list[$i][0]);
}
$main_box->add($form, False, True, "background-color: #dfe7f3; vertical-align: middle; align: center;");
$table->add($utax_id_label, 5, 2);
$utax_id_entry = new NTKEntry("utax_id");
$table->add($utax_id_entry, 5, 3);
$blz_label = new NTKLabel("", "BLZ:");
$table->add($blz_label, 6, 0);
$blz_entry = new NTKEntry("blz");
$table->add($blz_entry, 6, 1);
$bank_account_label = new NTKLabel("", "Kontonummer:");
$table->add($bank_account_label, 6, 2);
$bank_account_entry = new NTKEntry("bank_account");
$table->add($bank_account_entry, 6, 3);
$bank_name_label = new NTKLabel("", "Bankverbindung:");
$table->add($bank_name_label, 7, 0);
$bank_name_entry = new NTKEntry("bank_name");
$table->add($bank_name_entry, 7, 1);
$additional_label = new NTKLabel("", "Zusatz:");
$table->add($additional_label, 7, 2);
$additional_entry = new NTKEntry("additional");
$table->add($additional_entry, 7, 3);
$bill_ext_label = new NTKLabel("", "Ökokontrollstelle:");
$table->add($bill_ext_label, 8, 2);
$bill_ext_entry = new NTKEntry("bill_ext");
$table->add($bill_ext_entry, 8, 3);
$cancel_button = new NTKButton("cancel", "Abbrechen", "location.href = 'assistant.php';");
$table->add($cancel_button, 10, 2);
$submit_button = new NTKButton("submit", "Mitarbeiter erstellen", "document.forms['assistant'].submit();");
$table->add($submit_button, 10, 3);
$form = new NTKForm("assistant", "assistant.php", $table);
$form->addAttribute("db_action", "new");
$form->addAttribute("assistant_id", "");
$main_box->add($form, False, True, "background-color: #dfe7f3; vertical-align: middle; align: center;");
$table->add($tour_label, 8, 2);
$tour_list = new NTKComboBox("tour_id", $tour->get(), $data[0][12]);
$table->add($tour_list, 8, 3);
# Anmerkung
$details_label = new NTKLabel("", "Anmerkung:");
$table->add($details_label, 9, 0);
$details_entry = new NTKEntry("details", $data[0][14]);
$table->add($details_entry, 9, 1);
#Bank
$blz_label = new NTKLabel("", "BLZ:");
$table->add($blz_label, 11, 0);
$blz_entry = new NTKEntry("blz", $data[0][17]);
$table->add($blz_entry, 11, 1);
$ktno_label = new NTKLabel("", "Kontonummer:");
$table->add($ktno_label, 11, 2);
$ktno_entry = new NTKEntry("bank_account", $data[0][16]);
$table->add($ktno_entry, 11, 3);
$bankname_label = new NTKLabel("", "Bankverbindung:");
$table->add($bankname_label, 12, 0);
$bankname_entry = new NTKEntry("bank_name", $data[0][15]);
$table->add($bankname_entry, 12, 1);
$delete_button = new NTKButton("delete", "Löschen", "if(confirm('Wirklich loeschen?')) location.href = 'customer.php?db_action=delete&customer_id=" . $data[0][0] . "';");
$table->add($delete_button, 14, 1);
$cancel_button = new NTKButton("cancel", "Abbrechen", "location.href = 'customer.php';");
$table->add($cancel_button, 14, 2);
$submit_button = new NTKButton("submit", "Speichern", "document.forms['customer'].submit();");
$table->add($submit_button, 14, 3);
$form = new NTKForm("customer", "customer.php", $table);
$form->addAttribute("db_action", "edit");
$form->addAttribute("customer_number", $data[0][0]);
$main_box->add($form, False, True, "background-color: #dfe7f3; vertical-align: middle; align: center;");
$group_id_entry = new NTKComboBox("group_id", $group->get());
$table->add($group_id_entry, 4, 3);
$order_number_label = new NTKLabel("", "Bestellnummer:");
$table->add($order_number_label, 5, 0);
$order_number_entry = new NTKEntry("order_number");
$table->add($order_number_entry, 5, 1);
$anmerkung_label = new NTKLabel("", "Anmerkung:");
$table->add($anmerkung_label, 5, 2);
$anmerkung_entry = new NTKEntry("anmerkung");
$table->add($anmerkung_entry, 5, 3);
// adding dynamic-pricesets
$row = 6;
for ($i = 0; $i < count($priceset_list); $i++) {
$priceset_label = new NTKLabel("", $priceset_list[$i][1] . ":");
$table->add($priceset_label, $row, 0);
$tmp_price = $price->getPrice($priceset_list[$i][0], "");
$priceset_entry = new NTKEntry("priceset_price_" . $i, "");
$table->add($priceset_entry, $row, 1);
$row++;
}
$cancel_button = new NTKButton("cancel", "Abbrechen", "location.href = 'product.php';");
$table->add($cancel_button, $row, 2);
$submit_button = new NTKButton("submit", "Produkt erstellen", "document.forms['product'].submit();");
$table->add($submit_button, $row, 3);
$form = new NTKForm("product", "product.php", $table);
$form->addAttribute("db_action", "new");
// $form->addAttribute("product_id", $data[0][0]);
for ($i = 0; $i < count($priceset_list); $i++) {
$form->addAttribute("priceset_id_" . $i, $priceset_list[$i][0]);
}
$main_box->add($form, False, True, "background-color: #dfe7f3; vertical-align: middle; align: center;");
$table->add($utax_id_entry, 5, 3);
$blz_label = new NTKLabel("", "BLZ:");
$table->add($blz_label, 6, 0);
$blz_entry = new NTKEntry("blz", $data[0][11]);
$table->add($blz_entry, 6, 1);
$bank_account_label = new NTKLabel("", "Kontonummer:");
$table->add($bank_account_label, 6, 2);
$bank_account_entry = new NTKEntry("bank_account", $data[0][12]);
$table->add($bank_account_entry, 6, 3);
$bank_name_label = new NTKLabel("", "Bankverbindung:");
$table->add($bank_name_label, 7, 0);
$bank_name_entry = new NTKEntry("bank_name", $data[0][15]);
$table->add($bank_name_entry, 7, 1);
$additional_label = new NTKLabel("", "Zusatz:");
$table->add($additional_label, 7, 2);
$additional_entry = new NTKEntry("additional", $data[0][13]);
$table->add($additional_entry, 7, 3);
$bill_ext_label = new NTKLabel("", "Ökokontrollstelle:");
$table->add($bill_ext_label, 8, 0);
$bill_ext_entry = new NTKEntry("bill_ext", $data[0][16]);
$table->add($bill_ext_entry, 8, 1);
$delete_button = new NTKButton("delete", "Löschen", "if(confirm('Wirklich loeschen?')) location.href = 'assistant.php?db_action=delete&assistant_id=" . $data[0][0] . "';");
$table->add($delete_button, 10, 1);
$cancel_button = new NTKButton("cancel", "Abbrechen", "location.href = 'assistant.php';");
$table->add($cancel_button, 10, 2);
$submit_button = new NTKButton("submit", "Speichern", "document.forms['assistant'].submit();");
$table->add($submit_button, 10, 3);
$form = new NTKForm("assistant", "assistant.php", $table);
$form->addAttribute("db_action", "edit");
$form->addAttribute("assistant_id", $data[0][0]);
$main_box->add($form, False, True, "background-color: #dfe7f3; vertical-align: middle; align: center;");
