<?php
require_once "NTK/NTK.php";
require_once "DataBase/Product.php";
?>
<html>
<head>
<title> Index </title>
<?php
echo getHead();
include "Modules/Product/db_action.php";
$main_box = new NTKVBox("main_box", 0, 0, False);
$main_box->add(new NTKLabel("", "Programmversion: 1.5"), -1, -1);
echo $main_box->getHtml();
?>
</body>
</html>
<?php
require_once "util.php";
$group = new Group();
if ($action == "new") {
$group->create(var_post("group_id", ""), array(var_post("group_name", "")));
} elseif ($action == "edit") {
$group->update(var_post("group_id", ""), array(var_post("group_name", "")));
} elseif ($action == "delete") {
$group->delete(var_get("group_id", ""));
}
$group_box = new NTKVBox("group_box", 0, 0, False);
$label = new NTKLabel("group_label", "<h3>Gruppen</h3>");
$group_box->add($label);
$group_list = $group->get('');
for ($i = 0; $i < count($group_list); $i++) {
$group_box->add(new NTKEGroup($group_list[$i][0], $group_list[$i][1]));
}
$label = new NTKLabel("group_label", "<h4>neue Gruppe</h4>");
$group_box->add($label);
$group_box->add(new NTKEGroup("", "", True), -1);
$main_box->add($group_box, -1, -1, "background-color: #dfe7f3; vertical-align: top;");
if ($search_category != "") {
if ($search_toggle && count($search_category) > 0) {
for ($i = 0; $i < count($search_category); $i++) {
$search_in .= " category_id='" . $search_category[$i] . "' AND ";
}
} elseif (count($search_category) > 0) {
for ($i = 0; $i < count($search_category); $i++) {
$search_in .= " category_id<>'" . $search_category[$i] . "' AND ";
}
}
}
$list_view = new NTKListView("list_view", array('Produktnummer', 'Name', 'Beschreibung'), "location.href = 'product.php?action=edit&product_id=%0%';");
$results = $product->get('', array('product_id', 'name', 'details'), $search_in . " (product_id LIKE '%{$search}%' OR name LIKE'%{$search}%' OR details LIKE '%{$search}%' OR order_number LIKE '%{$search}%')");
if (count($results) == 1) {
$onload = "location.href = 'product.php?action=edit&product_id=" . $results[0][0] . "';";
}
$list_view->addLines($results);
$main_box->add($list_view, -1, -1, "background-color: #dfe7f3; vertical-align: top;");
} else {
/*$list_view = new NTKListView("list_view", array('Produktnummer','Name','Beschreibung'), "location.href = '$PHP_SELF?action=edit&product_id=%0%';");
$list_view->addLines($product->get('', array('product_id', 'name', 'details')));
$main_box->add($list_view, -1, -1, "background-color: #dfe7f3; vertical-align: top;");*/
$main_box->add(new NTKSpacer(), -1, -1);
}
echo getHead();
echo $main_box->getHtml();
?>
</body>
</html>
<?php
require_once "util.php";
require_once "NTK/NTK.php";
require_once "DataBase/Customer.php";
?>
<html>
<head>
<title> Index </title>
<?php
echo getHead();
$search = var_get("search", "");
if (strlen($search) >= 3) {
$customer = new Customer();
$main_box = new NTKVBox("main_box", 0, 0, False);
$list_view = new NTKListView("list_view", array('Kundennummer', 'Vorname', 'Nachname'), "parent.frames['main'].document." . var_get("form", "") . "." . var_get("entry", "") . ".value = '%0%';parent.frames['main'].document." . var_get("form", "") . "." . var_get("next", "") . ".focus();");
$list_view->addLines($customer->get('', array('customer_id', 'prename', 'postname'), "customer_id LIKE '%{$search}%' OR prename LIKE'%{$search}%' OR postname LIKE '%{$search}%'"));
$main_box->add($list_view, -1, -1, "background-color: #dfe7f3; vertical-align: top;");
echo $main_box->getHtml();
}
?>
</body>
</html>
$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>
<head>
<title> Index </title>
<?php
echo getHead();
$main_box = new NTKVBox("main_box", 0, 0, False);
// Toolbar
$page = "configuration";
$printfile = "";
include "Modules/toolbar.php";
// small Toolbar
include "Modules/Configuration/toolbar.php";
// main content
$action = var_get_post("action", "");
$page = var_get_post("page", "");
// tax
if ($page == "tax") {
include "Modules/Configuration/tax.php";
} elseif ($page == "priceset") {
include "Modules/Configuration/priceset.php";
} elseif ($page == "group") {
include "Modules/Configuration/group.php";
} else {
$main_box->add($spacer, -1, -1, "background-color: #dfe7f3; vertical-align: top;");
}
echo $main_box->getHtml();
?>
</body>
</html>
$printfile = "print_tour.php?tour_id=" . $tour_id . "&date=" . $datum;
}
include "Modules/toolbar.php";
// small Toolbar
include "Modules/Tour/toolbar.php";
// main content
if ($action == "new") {
include "Modules/Tour/new_form.php";
} elseif ($action == "edit" && $tour_id != "") {
$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);
<?php
$bill_box = new NTKVBox("bill_box", 0, 0, False);
$customer_data = $customer->get($data[0][1]);
$label = new NTKLabel("bill_label", "<b>Rechung: " . $data[0][5] . "<br>" . $customer_data[0][2] . " " . $customer_data[0][3] . "</b><br><br>");
$bill_box->add($label);
$bill_list = $bill_product->getByBillId($data[0][0]);
$bill_pos_table = new NTKTable("", count($bill_list) + 2, 7, False);
$bill_pos_table->add(new NTKLabel("", "Produktnummer"), 0, 0, 100);
$bill_pos_table->add(new NTKLabel("", "Produkt"), 0, 1);
$bill_pos_table->add(new NTKLabel("", "Stück"), 0, 2, 60);
$bill_pos_table->add(new NTKLabel("", "Anmerkung"), 0, 3, 200);
$bill_pos_table->add(new NTKLabel("", "Rabatt"), 0, 4, 60);
$bill_pos_table->addFormRow("bill_product_form_new", "bill.php", 1, array(array('db_action', 'position_add'), array('bill_product_id', ''), array('bill_id', $data[0][0]), array('action', 'edit'), array('from_page', $from_page), array('fp_tour_id', $fp_tour_id), array('fp_date', $fp_date)));
$product_id_entry = new NTKEntry("product_id", "");
$product_id_entry->addEvent("onkeyup", "parent.frames['action'].location.href='action_product.php?form=bill_product_form_new&entry=product_id&next=amount&search='+this.value;");
$onload .= "document.getElementById('product_id').focus();";
$bill_pos_table->add($product_id_entry, 1, 0, 100);
$bill_pos_table->add(new NTKLabel("", " "), 1, 1);
$bill_pos_table->add(new NTKEntry("amount", ""), 1, 2, 60);
$bill_pos_table->add(new NTKEntry("details", ""), 1, 3, 200);
$bill_pos_table->add(new NTKEntry("rabatt", ""), 1, 4, 60);
$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);
require_once "NTK/NTK.php";
?>
<html>
<head>
<title> Index </title>
<?php
echo getHead();
?>
</head>
<body>
<?php
$main_box = new NTKVBox("main_box", 0, 0, False);
// Toolbar
$page = "sync";
include "Lib/toolbar.php";
// small Toolbar
include "Lib/customer_toolbar.php";
// main content
$main_box->add($spacer, -1, -1, "background-color:\t\t#dfe7f3;");
echo $main_box->getHtml();
?>
</body>
</html>
require_once "DataBase/Price.php";
require_once "DataBase/Category.php";
$priceset = new Priceset();
$customer = new Customer();
$product = new Product();
$price = new Price();
$category = new Category();
$priceset->export("mysql_export/priceset.csv");
$customer->export("mysql_export/customer.csv");
$product->export("mysql_export/product.csv");
$price->export("mysql_export/price.csv");
$category->export("mysql_export/category.csv");
// upload all db-files "mysql_export"
$handle = popen("/var/www/ursprung/bin/upload.sh", "r");
pclose($handle);
$main_box->add(new NTKLabel("", "Schritt erfolgreich"), 200, -1, "color: #00ff00; background-color: #dfe7f3;");
$button_next = new NTKButton("button_next", "Weiter", "location.replace('websync.php?action=upload_1');");
$main_box->add($button_next, 500);
} elseif ($action == "upload_1") {
$iframe = new NTKIFrame("upload_frame", "http://www.natuerlich-grobi.de/db_import.php", "width: 300px; height: 200px; background-color: #dfe7f3;");
$main_box->add($spacer, True, True, "background-color: #dfe7f3;");
$main_box->add(new NTKLabel("", "Serverausgabe (dauert etwas):"), False, False, "font-style: bold; background-color: #dfe7f3;");
$main_box->add($iframe, False, False, "background-color: #dfe7f3;");
$main_box->add($spacer, True, True, "background-color: #dfe7f3;");
} elseif ($action == "download_0") {
$iframe = new NTKIFrame("download_frame", "http://www.natuerlich-grobi.de/db_export.php", "width: 300px; height: 200px; background-color: #dfe7f3;");
// $iframe = new NTKIFrame("download_frame", "http://localhost/ursprung/db_export.php", "width: 300px; height: 200px; background-color: #dfe7f3;");
$main_box->add($spacer, True, True, "background-color: #dfe7f3;");
$main_box->add(new NTKLabel("", "Serverausgabe (dauert etwas):"), False, False, "font-style: bold; background-color: #dfe7f3;");
$main_box->add($iframe, False, False, "background-color: #dfe7f3;");
$main_box->add($spacer, True, True, "background-color: #dfe7f3;");
<?php
require_once "util.php";
$priceset = new Priceset();
if ($action == "new") {
$priceset->create(var_post("priceset_id", ""), array(var_post("priceset_name", ""), var_post("priceset_netto", "")));
} elseif ($action == "edit") {
$priceset->update(var_post("priceset_id", ""), array(var_post("priceset_name", ""), var_post("priceset_netto", "")));
} elseif ($action == "delete") {
$priceset->delete(var_get("priceset_id", ""));
}
$priceset_box = new NTKVBox("priceset_box", 0, 1, False);
$label = new NTKLabel("priceset_label", "<h3>Preissätze</h3>");
$priceset_box->add($label);
$priceset_list = $priceset->get('');
for ($i = 0; $i < count($priceset_list); $i++) {
$priceset_box->add(new NTKEPriceset($priceset_list[$i][0], $priceset_list[$i][1], $priceset_list[$i][2]));
}
$label = new NTKLabel("priceset_label", "<h4>neuer Preissatz</h4>");
$priceset_box->add($label);
$priceset_box->add(new NTKEPriceset("", "", 1, True), -1);
$main_box->add($priceset_box, -1, -1, "background-color: #dfe7f3; vertical-align: top;");
<html>
<head>
<title> Index </title>
<?php
echo getHead();
?>
</head>
<body>
<?php
$main_box = new NTKVBox("main_box", 0, 0, False);
// Toolbar
$page = "sync";
$printfile = "";
include "Modules/toolbar.php";
// $handle = popen("C:\apache\htdocs\bin\backup.bat", "r");
$handle = popen("sudo /var/www/ursprung/bin/backup.sh", "r");
$read = fread($handle, 2096);
pclose($handle);
// main content
$main_box->add(new NTKLabel("", "Datensicherung " . $read), 200, -1, "background-color:\t\t#dfe7f3;");
$main_box->add($spacer, -1, -1, "background-color:\t\t#dfe7f3;");
echo $main_box->getHtml();
?>
</body>
</html>
$result_box->add(new NTKLabel("", "<b>" . round($product_amount, 2) . "</b>"), 1, 1);
$result_box->add(new NTKLabel("", "In Rechnungen (Menge):"), 2, 0);
$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();
?>
<?php
require_once "util.php";
$tax = new Tax();
if ($action == "new") {
$tax->create(var_post("tax_id", ""), array(var_post("tax_name", ""), var_post("tax_rate", "")));
} elseif ($action == "edit") {
$tax->update(var_post("tax_id", ""), array(var_post("tax_name", ""), var_post("tax_rate", "")));
} elseif ($action == "delete") {
$tax->delete(var_get("tax_id", ""));
}
$tax_box = new NTKVBox("tax_box", 0, 0, False);
$label = new NTKLabel("tax_label", "<h3>Steuersätze</h3>");
$tax_box->add($label);
$taxlist = $tax->get('');
for ($i = 0; $i < count($taxlist); $i++) {
$tax_box->add(new NTKETax($taxlist[$i][0], $taxlist[$i][1], $taxlist[$i][2]));
}
$label = new NTKLabel("tax_label", "<h4>neuer Steuersatz</h4>");
$tax_box->add($label);
$tax_box->add(new NTKETax("", "", "", True), -1);
$main_box->add($tax_box, -1, -1, "background-color: #dfe7f3; vertical-align: top;");
