public function viewNoResult() { // Filtering $filter_excursion = Tour::get(); $filter_cities = City::get(); return array('filter_excursion' => $filter_excursion, 'filter_cities' => $filter_cities); }
function getTourObject() { $q = "select Tours.ID from Shows, Tours where Shows.date >= Tours.start_date and Shows.date <= Tours.end_date and Shows.ID = " . $this->ID; $r = mysql_query($q); if (!$r) { return Error::MySQL(); } $row = mysql_fetch_assoc($r); $to = Tour::get($row['ID']); return $to; }
<?php include 'base.php'; User::protect(); include_class('tours'); include_class('m2'); // type is only used on initial entry, not on an actual submit $to = Tour::get($_GET['id']); if (!db::isError($to)) { $doSubmit = false; if (!$_POST['area']) { $type = $_REQUEST['type'] == 'av' ? 'av' : 'photos'; $ma = $type == 'av' ? $to->getAVAreaObject() : $to->getPhotoAreaObject(); } else { if ($_POST['area'] == $to->getAVAreaID() || $_POST['area'] == $to->getPhotoAreaID()) { $doSubmit = true; } } if ($doSubmit) { $ma = MediaArea::get($_POST['area']); if (!db::isError($ma)) { if ($_POST['localfile']) { $res = $ma->addMediaUpload('mediafile', $to); } else { if ($_POST['url']) { $res = $ma->addMediaRemote($_POST['url'], $to); } else { if ($_POST['toAdd'] == 'all') { $keepCopy = $_POST['copyFromIncoming'] ? 1 : 0; $res = $ma->addAllMediaIncoming($keepCopy, $to); } else {
<?php require_once "util.php"; require_once "DataBase/Product.php"; require_once "DataBase/Bill.php"; require_once "DataBase/Tour.php"; require_once "DataBase/Bill_Product.php"; $tour_id = var_get("tour_id", ""); $date = var_get("date", ""); $bill = new Bill(); $bill_data = $bill->get("", array("bill_id"), "tour_id='" . $tour_id . "' AND date='" . $date . "'"); $tour = new Tour(); $tmp = $tour->get($tour_id); $tour_data = $tmp[0]; $bill_product = new Bill_Product(); $product = new Product(); $product_data = $product->get(); include "Druckvorlagen/tour.php"; ?>
public function privacyAndPolicy() { if (Session::has('st_date')) { $st_date = Session::get('st_date'); } else { $st_date = date("Y/m/d"); } //Session::flush(); if (Session::has('ed_date')) { $ed_date = Session::get('ed_date'); } else { $ed_date = date("Y/m/d", strtotime($st_date . ' + 2 days')); } $filter_tours = Tour::get(); $filter_cities = City::get(); $path = array(); // dd(DB::getQueryLog()); return View::make('pages.privacy_policy')->with(array('path' => $path, 'st_date' => $st_date, 'ed_date' => $ed_date, 'filter_tours' => $filter_tours, 'filter_cities' => $filter_cities)); }
function add($postArray) { $db = new db(); if (!User::isAdmin()) { return Error::create("Only an administrator may add tours."); } $title = $db->sanitize_to_db($postArray['title']); $start_date = $db->sanitize_to_db($postArray['start_date']); $end_date = $db->sanitize_to_db($postArray['end_date']); $sd = strtotime($start_date); $start_date = date('Y-m-d', $sd); $ed = strtotime($end_date); $end_date = date('Y-m-d', $ed); $description = $db->sanitize_to_db($postArray['description']); if (!$title) { $title = '(untitled tour)'; } $r = @mysql_query("insert into Tours (title, start_date, end_date, description, is_active) values ('{$title}', '{$start_date}', '{$end_date}', '{$description}','" . DEFAULT_ACTIVE . "')"); if ($r) { return Tour::get(mysql_insert_id()); } else { return Error::MySQL(); } }
} 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;"); } // main content
$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.<br>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;");
<?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();
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; }