include "Modules/toolbar.php";
// small Toolbar
include "Modules/Product/toolbar.php";
// main content
$action = var_get_post("action", "");
$search = var_post("search_entry", "");
$product_id = var_get_post("product_id", "");
$onload .= "document.getElementById('search_entry').focus();";
if ($action == "new") {
include "Modules/Product/new_form.php";
} elseif ($action == "edit" && $product_id != "") {
$data = $product->get($product_id);
include "Modules/Product/edit_form.php";
} elseif ($action == "search" && $search != "") {
$search_toggle = var_post("search_toggle", "");
$search_category = var_post("search_category", "");
$search_in = "";
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) {
<html>
<head>
<title> Index </title>
<?php
include "Modules/Assistant/db_action.php";
$main_box = new NTKVBox("main_box", 0, 0, False);
// Toolbar
$page = "assistant";
$printfile = "";
include "Modules/toolbar.php";
// small Toolbar
include "Modules/Assistant/toolbar.php";
// main content
$action = var_get_post("action", "");
$search = var_post("search_entry", "");
$assistant_id = var_get("assistant_id", "");
if ($action == "new") {
include "Modules/Assistant/new_form.php";
} elseif ($action == "edit" && $assistant_id != "") {
$data = $assistant->get($assistant_id);
include "Modules/Assistant/edit_form.php";
} elseif ($action == "search" && $search != "") {
$list_view = new NTKListView("list_view", array('Mitarbeiternummer', 'Vorname', 'Nachname'), "location.href = 'assistant.php?action=edit&assistant_id=%0%';");
$list_view->addLines($assistant->get('', array('assistant_id', 'prename', 'postname'), "assistant_id LIKE '%{$search}%' OR prename LIKE'%{$search}%' OR postname LIKE '%{$search}%'"));
$main_box->add($list_view, -1, -1, "background-color: #dfe7f3; vertical-align: top;");
} else {
$list_view = new NTKListView("list_view", array('Mitarbeiternummer', 'Vorname', 'Nachname'), "location.href = 'assistant.php?action=edit&assistant_id=%0%';");
$list_view->addLines($assistant->get('', array('assistant_id', 'prename', 'postname')));
$main_box->add($list_view, -1, -1, "background-color: #dfe7f3; vertical-align: top;");
}
<?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;");
<?php
require_once "util.php";
require_once "NTK/NTK.php";
require_once "DataBase/Category.php";
$db_action = var_get_post("db_action", "");
$category = new Category();
switch ($db_action) {
case "new":
$category->create(array(var_post("category_id", ""), var_post("name", ""), var_post("details", "")));
break;
case "edit":
$category->update(var_post("category_id", ""), array(var_post("name", ""), var_post("details", "")));
break;
case "delete":
$category->delete(var_get("category_id", ""));
break;
}
} else {
$search .= "(product_id >=" . var_post("product_id", "") . ") ";
}
}
if (var_post("date_from", "")) {
if ($search) {
$search .= " AND (date >='" . var_post("date_from", "") . "') ";
} else {
$search .= "(date >='" . var_post("date_from", "") . "') ";
}
}
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);
<?php
require_once "util.php";
require_once "DataBase/Customer.php";
require_once "DataBase/Tour.php";
require_once "DataBase/Priceset.php";
$db_action = var_get_post("db_action", "");
$customer = new Customer();
$tour = new Tour();
$priceset = new Priceset();
switch ($db_action) {
case "new":
$customer->create(var_post("customer_number", ""), array(var_post("password", ""), var_post("prename", ""), var_post("postname", ""), var_post("street", ""), var_post("streetnumber", ""), var_post("plz", ""), var_post("city", ""), var_post("telephone", ""), var_post("telefax", ""), var_post("email", ""), var_post("pricelist_id", ""), var_post("tour_id", ""), var_post("rabatt", ""), var_post("details", ""), var_post("bank_name", ""), var_post("bank_account", ""), var_post("blz", "")));
break;
case "edit":
$customer->update(var_post("customer_number", ""), array(var_post("password", ""), var_post("prename", ""), var_post("postname", ""), var_post("street", ""), var_post("streetnumber", ""), var_post("plz", ""), var_post("city", ""), var_post("telephone", ""), var_post("telefax", ""), var_post("email", ""), var_post("pricelist_id", ""), var_post("tour_id", ""), var_post("rabatt", ""), var_post("details", ""), var_post("bank_name", ""), var_post("bank_account", ""), var_post("blz", "")));
break;
case "delete":
$customer->delete(var_get("customer_id", ""));
break;
}
require_once "DataBase/Price.php";
$db_action = var_get_post("db_action", "");
$product = new Product();
$tax = new Tax();
$category = new Category();
$priceset = new Priceset();
$price = new Price();
$group = new Group();
switch ($db_action) {
case "new":
$product->create(var_post("product_id", ""), array(var_post("name", ""), var_post("details", ""), var_post("category_id", ""), var_post("tax_id", ""), var_post("available", ""), var_post("group_id", ""), var_post("order_number", ""), var_post("anmerkung", "")));
$priceset_list = $priceset->get();
for ($i = 0; $i < count($priceset_list); $i++) {
$price->create(var_post("priceset_id_" . $i, ""), var_post("product_id", ""), array(var_post("priceset_price_" . $i, "")));
}
break;
case "edit":
$product->update(var_post("product_id", ""), array(var_post("name", ""), var_post("details", ""), var_post("category_id", ""), var_post("tax_id", ""), var_post("available", ""), var_post("group_id", ""), var_post("order_number", ""), var_post("anmerkung", "")));
$priceset_list = $priceset->get();
for ($i = 0; $i < count($priceset_list); $i++) {
if ($price->exists(var_post("priceset_id_" . $i, ""), var_post("product_id", ""))) {
$price->update(var_post("priceset_id_" . $i, ""), var_post("product_id", ""), array(var_post("priceset_price_" . $i, "")));
} else {
$price->create(var_post("priceset_id_" . $i, ""), var_post("product_id", ""), array(var_post("priceset_price_" . $i, "")));
}
}
break;
case "delete":
$product->delete(var_get("product_id", ""));
break;
}
$assistant = new Assistant();
$bill = new Bill();
$var_print = var_post("print", "");
$var_group_all = var_post("group_all", "");
$var_group = var_post("group", "");
$var_category_all = var_post("category_all", "");
$var_category = var_post("category", "");
$var_available = var_post("available", "");
$var_not_available = var_post("not_available", "");
$var_product_id_from = var_post("product_id_from", "");
$var_product_id_to = var_post("product_id_to", "");
$var_assistant = var_post("assistant", "");
$var_priceset = var_post("priceset", "");
$var_product_id = var_post("product_id", "");
$var_date_from = var_post("date_from", "");
$var_date_to = var_post("date_to", "");
if ($var_print == "print") {
$search = "";
if (!$var_group_all) {
if ($search) {
$search .= " AND group_id='" . $var_group . "' ";
} else {
$search .= "group_id='" . $var_group . "' ";
}
}
if (!$var_category_all) {
if ($search) {
$search .= " AND category_id='" . $var_category . "' ";
} else {
$search .= "category_id='" . $var_category . "' ";
}
<TD WIDTH="1" align="center" class="list_header">Inkl.Ust.</TD>
<?php
} else {
?>
<TD WIDTH="1" align="center" class="list_header">Exkl.Ust.</TD>
<?php
}
?>
<TD WIDTH="1" align="center" class="list_header">Steuer</TD>
</TR>
</THEAD>
<TBODY>
<?php
for ($i = 0; $i < count($product_data); $i++) {
$price_data = $price->getPrice(var_post("priceset", ""), $product_data[$i][0]);
$tax_data = $tax->get($product_data[$i][4]);
?>
<TR VALIGN=TOP>
<TD WIDTH="1" align="center" class="list"><?php
echo $product_data[$i][0] . " ";
?>
</TD>
<TD WIDTH="80%" align="left" class="list"><?php
echo $product_data[$i][1] . " ";
?>
</TD>
<TD WIDTH="1" align="left" class="list"><?php
echo $product_data[$i][2] . " ";
?>
</TD>
<?php
require_once "util.php";
require_once "NTK/NTK.php";
require_once "DataBase/Customer.php";
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();
<?php
require_once "util.php";
require_once "DataBase/Assistant.php";
$db_action = var_get_post("db_action", "");
$assistant = new Assistant();
switch ($db_action) {
case "new":
$assistant->create(var_post("assistant_id", ""), array(var_post("prename", ""), var_post("postname", ""), var_post("street", ""), var_post("streetnumber", ""), var_post("plz", ""), var_post("city", ""), var_post("telephone", ""), var_post("telefax", ""), var_post("email", ""), var_post("tax_number", ""), var_post("blz", ""), var_post("bank_account", ""), var_post("additional", ""), var_post("utax_id", ""), var_post("bank_name", ""), var_post("bill_ext", "")));
break;
case "edit":
$assistant->update(var_post("assistant_id", ""), array(var_post("prename", ""), var_post("postname", ""), var_post("street", ""), var_post("streetnumber", ""), var_post("plz", ""), var_post("city", ""), var_post("telephone", ""), var_post("telefax", ""), var_post("email", ""), var_post("tax_number", ""), var_post("blz", ""), var_post("bank_account", ""), var_post("additional", ""), var_post("utax_id", ""), var_post("bank_name", ""), var_post("bill_ext", "")));
break;
case "delete":
$assistant->delete(var_get("assistant_id", ""));
break;
}
<?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;");
if ($message != "") {
print "<div class=\"error\">" . $message . "</div><br>";
}
?>
<table border="0">
<tr>
<td>Kundennummer:</td>
<td><input type="text" name="username" value="<?php
var_post("username", "");
?>
"></td>
</tr>
<tr>
<td>Passwort:</td>
<td><input type="password" name="password" value="<?php
var_post("password", "");
?>
"></td>
</tr>
<tr>
<td colspan="2" align="right"><a href="#" onclick="javascript: document.forms['login_form'].submit();">Anmelden</a></td>
</tr>
</table>
</div>
<input type="submit" value="" class="invisible_submit">
</form>
<?php
include "footer.php";
?>
<?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;");
require_once "DataBase/Assistant.php";
require_once "DataBase/Bill_Product.php";
$db_action = var_get_post("db_action", "");
$tour = new Tour();
$bill = new Bill();
$assistant = new Assistant();
switch ($db_action) {
case "new":
$tour->create(array(var_post("name", ""), var_post("assistant_id", "")));
break;
case "edit":
$tour->update(var_post("tour_id", ""), array(var_post("name", ""), var_post("assistant_id", "")));
break;
case "delete":
$tour->delete(var_get("tour_id", ""));
break;
case "tour_to_bill":
$tour = new Tour();
$tmp = $tour->get(var_get("tour_id", ""));
$tour_data = $tmp[0];
$bill = new Bill();
$new_bill_id = $bill->create('', array(var_post("customer_id", ""), var_post("tour_id", ""), var_post("date", ""), var_post("assistant_id", ""), -1, 0));
$bill_product = new Bill_Product();
$product = new Product();
$product_data = $product->get();
$result = $bill_product->getTourZusammenfassung(var_post("current_tour_id", ""), var_post("date", ""));
for ($i = 0; $i < count($result); $i++) {
$bill_product->create(array($new_bill_id, $result[$i][0], $result[$i][2], '', '', '', ''));
}
break;
}
case "delete":
$bill->delete(var_get("bill_id", ""));
if ($fp_tour_id != "") {
$onload .= "location.href = 'tour.php?action=list_tour&tour_id=" . $fp_tour_id . "&date=" . $fp_date . "';";
}
break;
case "position_add":
$bill_data = $bill->get(var_post("bill_id", ""));
/* autoset anmerkung vom produkt, wenn nichts als anmerkung gegeben */
$details = var_post("details", "");
if ($details == "") {
$product_data = $product->get(var_post("product_id", ""));
$details = $product_data[0][8];
}
if ($bill_data[0][5] == -1) {
$bill_product->create(array(var_post("bill_id", ""), var_post("product_id", ""), var_post("amount", ""), $details, var_post("rabatt", ""), 0, 0));
} else {
$customer_data = $customer->get($bill_data[0][1]);
$price_data = $price->getPrice($customer_data[0][11], var_post("product_id", ""));
$product_data = $product->get(var_post("product_id", ""));
$tax_data = $tax->get($product_data[0][4]);
$bill_product->create(array(var_post("bill_id", ""), var_post("product_id", ""), var_post("amount", ""), $details, var_post("rabatt", ""), $price_data[0][3], $tax_data[0][2]));
}
break;
case "position_delete":
$bill_product->delete(var_get("bill_product_id", ""));
break;
case "position_edit":
$bill_product->update(var_post("bill_product_id", ""), array(var_post("bill_id", ""), var_post("product_id", ""), var_post("amount", ""), var_post("details", ""), var_post("rabatt", ""), var_post("price", ""), var_post("tax", "")));
break;
}
