function createBill() { $bill = new Bill(); $customer = new Customer(); $tour = new Tour(); $bill_product = new Bill_Product(); $customer_data = $customer->get($this->customer_id); if (count($customer_data) == 0) { echo "<div class=\"error\">Fehler in Session, bitte neu anmelden</div><br>\n"; return -1; } $tour_data = $tour->getByAssistant($customer_data[0][12]); $bill_id = $bill->create("", array($this->customer_id, $customer_data[0][12], "", $tour_data[0][2], -2, time())); $list = $this->getItems(); for ($i = 0; $i < count($list); $i++) { if ($list[$i][2] > 0) { $bill_product->create(array($bill_id, $list[$i][0], $list[$i][2], $list[$i][5], "", 0, 0, time())); } } return 0; }
<?php include "DataBase/database.php"; include "DataBase/Bill.php"; include "DataBase/Bill_Product.php"; $bill = new Bill(); $bill_product = new Bill_Product(); $folder = "mysql_export/"; if ($bill->export($folder . "bill.csv")) { echo "rechnung export erfolgreich<br>"; } else { echo "rechnung export schlug fehl<br>"; } if ($bill_product->export($folder . "bill_product.csv")) { echo "bill_product export erfolgreich<br>"; } else { echo "bill_product export schlug fehl<br>"; } ?> <br> Synchronisation abgeschlossen
<?php require_once "DataBase_Net/Bill_Net.php"; require_once "DataBase_Net/Bill_Product_Net.php"; require_once "DataBase/Bill.php"; require_once "DataBase/Bill_Product.php"; // sync Bill database $bill = new Bill(); $bill_net = new Bill_Net(); $bill_product = new Bill_Product(); $bill_product_net = new Bill_Product_Net(); $new_bills_count = 0; $new_position_count = 0; // fetch all remote bills $remote_bills = $bill_net->getPlainBills(); foreach ($remote_bills as $tmp) { $new_bill_id = $bill->create("", array_slice($tmp, 1)); $new_bills_count++; // check for bill_products $remote_bill_products = $bill_product_net->getByBillId($tmp[0]); foreach ($remote_bill_products as $tmp1) { $tmp1[1] = $new_bill_id; $bill_product->create(array_slice($tmp1, 1)); $new_position_count++; } } $main_box->add(new NTKLabel("", "neue Rechnungen: " . $new_bills_count), 200, 0, "background-color: #dfe7f3;"); $main_box->add(new NTKLabel("", "neue Positionen: " . $new_position_count), 200, 0, "background-color: #dfe7f3;"); // now we should have added all bills let's delete them remote $bill_net->clearTable(); $bill_product_net->clearTable();
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"; ?>
$main_box->add($iframe, False, False, "background-color: #dfe7f3;"); $main_box->add($spacer, True, True, "background-color: #dfe7f3;"); $main_box->add(new NTKButton("button_next", "Weiter", "ntk_show_splash('bitte warten ...'); location.replace('websync.php?action=download_1');"), 500); } elseif ($action == "download_1") { // download all db-files "mysql_import" $handle = popen("/var/www/ursprung/bin/download.sh", "r"); pclose($handle); require_once "DataBase/Bill.php"; require_once "DataBase/Bill_Product.php"; require_once "DataBase/Bill_Import.php"; require_once "DataBase/Bill_Product_Import.php"; require_once "DataBase/Customer.php"; require_once "DataBase/Tour.php"; // import new bills $bill = new Bill(); $bill_product = new Bill_Product(); $bill_import = new Bill_Import(); $bill_product_import = new Bill_Product_Import(); $customer = new Customer(); $tour = new Tour(); if ($bill_import->import("mysql_import/bill.csv") == 0 && $bill_product_import->import("mysql_import/bill_product.csv") == 0) { /* import bills from bill_import and products from bill_product_import */ $bills = $bill_import->get(); for ($i = 0; $i < count($bills); $i++) { if (!$bill->hasTimestamp($bills[$i][6])) { $customer_data = $customer->get($bills[$i][1]); if (count($customer_data) == 0) { echo "Fehler: websync.php import bills from bill_import no customer data"; continue; } $tour_data = $tour->get($customer_data[0][12]);
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; }
<?php require_once "DataBase/Bill.php"; require_once "DataBase/Bill_Product.php"; require_once "DataBase/Tour.php"; require_once "DataBase/Assistant.php"; require_once "DataBase/Product.php"; require_once "DataBase/Customer.php"; require_once "DataBase/Price.php"; require_once "DataBase/Tax.php"; $db_action = var_get_post("db_action", ""); $bill = new Bill(); $tour = new Tour(); $assistant = new Assistant(); $bill_product = new Bill_Product(); $product = new Product(); $customer = new Customer(); $price = new Price(); $tax = new Tax(); switch ($db_action) { case "new": $customer_data = $customer->get(var_post("customer_id", "")); if (count($customer_data) > 0) { $tour_data = $tour->getByAssistant($customer_data[0][12]); if (count($tour_data) > 0) { $bill_id = $bill->create(var_post("bill_id", ""), array(var_post("customer_id", ""), $customer_data[0][12], var_post("date", ""), $tour_data[0][2], -1, 0)); } else { $bill_id = $bill->create(var_post("bill_id", ""), array(var_post("customer_id", ""), $customer_data[0][12], var_post("date", ""), 1, -1, 0)); } } else { $bill_id = $bill->create(var_post("bill_id", ""), array(var_post("customer_id", ""), '', var_post("date", ""), var_post("assistant_id", "1"), -1, 0));