require_once "DataBase/Bill.php"; require_once "DataBase/Assistant.php"; require_once "DataBase/Customer.php"; require_once "DataBase/Product.php"; require_once "DataBase/Bill_Product.php"; require_once "DataBase/Price.php"; require_once "DataBase/Priceset.php"; require_once "DataBase/Tax.php"; $bill_id = var_get_post("bill_id", ""); $bill = new Bill(); $tmp = $bill->get($bill_id); $bill_data = $tmp[0]; $customer = new Customer(); $tmp = $customer->get($bill_data[1]); $customer_data = $tmp[0]; $assistant = new Assistant(); $tmp = $assistant->get($bill_data[4]); $assistant_data = $tmp[0]; $priceset = new Priceset(); $tmp = $priceset->get($customer_data[11]); $priceset_data = $tmp[0]; $bill_product = new Bill_Product(); $bill_product_data = $bill_product->getByBillId($bill_id); $product = new Product(); $price = new Price(); $tax = new Tax(); include "Druckvorlagen/zeilen.php"; include "Druckvorlagen/rechnung.php"; ?>
$data = $tour->get($tour_id); include "Modules/Tour/edit_form.php"; } elseif ($action == "search" && var_post("search_entry", "") != "") { $search = var_post("search_entry", ""); $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'), "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;");
if ($var_product_id_from) { if ($search) { $search .= " AND (product_id >=" . $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) {