add(new NTKLabel("", "Neue Produkte / Preise online stellen"), 200, 10, "font-style: bold; background-color: #dfe7f3;"); // // $button_next = new NTKButton("button_next", "Weiter", "location.replace('websync.php?action=upload_1');"); // $main_box->add($button_next); // } if($action == "upload_0") { require_once("DataBase/Priceset.php"); require_once("DataBase/Customer.php"); require_once("DataBase/Product.php"); 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;"); $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]); $date = getdate(time()); $new_bill_id = $bill->create("", array($bills[$i][1], $customer_data[0][12], $date['year']."-".$date['mon']."-".$date['mday'], $tour_data[0][2], -2, $bills[$i][6])); $bill_products = $bill_product_import->getByBillId($bills[$i][0]); for($j = 0; $j < count($bill_products); $j++) { $bill_product->create(array($new_bill_id, $bill_products[$j][2], $bill_products[$j][3], $bill_products[$j][4], 0, 0, 0)); } } } $main_box->add($spacer, True, True, "background-color: #dfe7f3;"); $main_box->add(new NTKLabel("", "Fertig"), False, False, "font-style: bold; background-color: #dfe7f3;"); $main_box->add($spacer, True, True, "background-color: #dfe7f3;"); } else { $main_box->add($spacer, True, True, "background-color: #dfe7f3;"); $main_box->add(new NTKLabel("", "neue Bestellungen laden schlug fehl.
In ein paar Minuten nochmal versuchen."), False, False, "color: #ff0000; font-style: bold; background-color: #dfe7f3;"); $main_box->add($spacer, True, True, "background-color: #dfe7f3;"); } } else { // small Toolbar include("Modules/Websync/toolbar.php"); // main content $main_box->add(new NTKLabel("", "Internet Synchronisation"), 200, -1, "background-color: #dfe7f3;"); } // tools // $tool_box = new NTKVBox("online_box", 5, 0, False); // // $online_export_button = new NTKButton("", "online export", "window.open('http://www.natuerlich-grobi.de/db_export.php', 'Online Export', 'width=300,height=200');"); // $tool_box->add($online_export_button, 60, 60, $style); // // $download_button = new NTKButton("", "download", ""); // $tool_box->add($download_button, 60, 60, $style); // // $local_import_button = new NTKButton("", "Local Import", "location.replace('websync.php?action=local_import');"); // $tool_box->add($local_import_button, 60, 60, $style); // // $local_sync_button = new NTKButton("", "Local Sync", "location.replace('websync.php?action=local_sync');"); // $tool_box->add($local_sync_button, 60, 60, $style); // // $local_export_button = new NTKButton("", "Local Export", "location.replace('websync.php?action=local_export');"); // $tool_box->add($local_export_button, 60, 60, $style); // // $upload_button = new NTKButton("", "upload", ""); // $tool_box->add($upload_button, 60, 60, $style); // // $online_import_button = new NTKButton("", "online import", "window.open('http://www.natuerlich-grobi.de/db_import.php', 'Online Import', 'width=300,height=200');"); // $tool_box->add($online_import_button, 60, 60, $style); // // // add toolbars // $main_box->add($tool_box, True, True); // if($action == "local_import") // { // require_once("DataBase_Net/Bill_Net.php"); // require_once("DataBase_Net/Bill_Product_Net.php"); // // $bill_net = new Bill_Net(); // $bill_product_net = new Bill_Product_Net(); // // $bill_net->import("mysql_import/bill.csv"); // $bill_product_net->import("mysql_import/bill_product.csv"); // // $main_box->add(new NTKLabel("", "Local Import erfolgreich"), 200, -1, "background-color: #dfe7f3;"); // } // elseif($action == "local_sync") // { // include("Modules/Websync/PricesetSync.php"); // include("Modules/Websync/CustomerSync.php"); // include("Modules/Websync/ProductSync.php"); // include("Modules/Websync/BillSync.php"); // // $main_box->add(new NTKLabel("", "Local Sync erfolgreich"), 200, -1, "background-color: #dfe7f3;"); // } // elseif($action == "local_export") // { // require_once("DataBase_Net/Priceset_Net.php"); // require_once("DataBase_Net/Customer_Net.php"); // require_once("DataBase_Net/Product_Net.php"); // require_once("DataBase_Net/Price_Net.php"); // require_once("DataBase_Net/Category_Net.php"); // // // $priceset_net = new Priceset_Net(); // $customer_net = new Customer_Net(); // $product_net = new Product_Net(); // $price_net = new Price_Net(); // $category_net = new Category_Net(); // // $priceset_net->export("mysql_export/priceset.csv"); // $customer_net->export("mysql_export/customer.csv"); // $product_net->export("mysql_export/product.csv"); // $price_net->export("mysql_export/price.csv"); // $category_net->export("mysql_export/category.csv"); // // $main_box->add(new NTKLabel("", "Local Export erfolgreich"), 200, -1, "background-color: #dfe7f3;"); // } echo $main_box->getHtml(); ?>