public static function getDBH()
{
if (empty(self::$dbh)) {
self::$dbh = DBManager::create();
self::$dbh->connect();
}
return self::$dbh;
}
public function route()
{
$pagename = Registry::$controller[strtolower($this->getRequestedPage($_SERVER['REQUEST_URI']))];
if ($pagename === "Controller" || $pagename == null) {
$pagename = Registry::$controller["default"];
}
MonitorEntry::updateEntry($_SERVER['REQUEST_URI']);
$request = Request::val($_GET, $_POST);
$controller = $this->getController($pagename);
$controller->showPage($request);
}
public function showPage(Request $request)
{
// creating MainPage and modifing header information
$page = MainPage::create();
$page->getLayoutElem("header")->addHeaderElem('<link rel="stylesheet" type="text/css" href="' . Registry::$settings['config']['CSS_PATH'] . 'products_view_layout.css">');
$page->getLayoutElem("header")->addHeaderElem('
<script type="text/javascript">
var edi_feld_focused = false;
var basket = new Basket();
document.onkeydown = function(e){
var evt = e ? e:event;
var keyCode = evt.keyCode;
if(keyCode == 13 && edi_feld_focused){
search();
}
};
function search(){
//alert(document.getElementById("search_string").value);
var url ="products?search="+document.getElementById("search_string").value;
window.location.href = url;
}
function addToBasket(productid){
var oldCookie = document.cookie;
document.cookie = oldCookie+""
}
function Basket(){
this.items = {};
}
Basket.prototype.addItem = function(itemID){
if(this.items[itemID] == undefined){
this.items[itemID] = 1;
}else{
var tmp = this.items[itemID];
this.items[itemID] = tmp+1;
}
};
Basket.prototype.removeItem = function(itemID){
if(!this.items[itemID] == undefined){
var tmp = this.items[itemID];
this.items[itemID] = tmp-1;
}
};
</script>');
// deciding which content to build
// this $request->get doesnt mean get, its the PHP $_GET which is wraped in Request class
ErrorReporter::logVarExport(__CLASS__ . "::showPage(request) => request get export", $request->get);
ErrorReporter::logVarExport(__CLASS__ . "::showPage(request) => request post export", $request->post);
$search_string = $request->get["search"];
$basketItem = $request->get["itemID"];
if (!empty($basketItem)) {
if (empty($_SESSION["basket"])) {
$_SESSION["basket"] = array();
}
$itemID = mysql_real_escape_string($basketItem);
$count = $_SESSION["basket"][$itemID];
if (!empty($count)) {
$_SESSION["basket"][$itemID] = $count + 1;
} else {
$_SESSION["basket"][$itemID] = 1;
}
}
if (!empty($search_string)) {
// fetch sql data
// var_dump(mysql_real_escape_string($search_string));
$resultSet = TeileMapperImpl::make()->getListOfTeileByBezeichnung(mysql_real_escape_string($search_string));
if (count($resultSet) == 1) {
MonitorEntry::updateEntry($resultSet[0]->getBezeichnung);
}
$prev_search = "search=" . $search_string . "&";
} else {
// fetch sql data
// $resultSet = TeileMapperImpl::make()->getAlleProdukte();
$resultSet = TeileMapperImpl::make()->getProdukte();
}
// fetch view and apply data to view
$page->setContentView(Products_View::create());
$page->getLayoutElem("contentview")->applyData(array("products" => $resultSet, "prev_search" => $prev_search));
// show view
$page->showPage($page->layoutElementMap);
}
public function show()
{
?>
<div id="adminpanel">
<div id="stueckliste">
<div style='float: left;'>
Erstelle Stueckliste von <input id='stueckliste_produkt' type='text' value='<?php
if (isset($this->dataMap["stueckliste_produkt"])) {
echo $this->dataMap["stueckliste_produkt"]->name();
} else {
echo "Produkt1";
}
?>
'>
</div>
<div style='float:left;cursor: pointer;' onclick='javascript:stueckListeVonAnfordern();'>
Erstellen
</div>
<?php
if (!empty($this->dataMap["stueckliste_produkt"])) {
Stueckliste::printTeil($this->dataMap["stueckliste_produkt"]);
}
?>
</div>
<div id="abc_analyse">
ABC Analyse
<?php
echo "<div class='abc_row'><div class='abc_col'> TeilID </div> <div class='abc_col'> TeilBezeichnung </div><div class='abc_col'> Preis </div><div class='abc_col'> Kategorie</div></div>";
foreach ($this->dataMap["abc_analyse_array"] as $abc_adt) {
echo "<div class='abc_row' onmouseout='javascript:unhighlight_row(this);' onmouseover='javascript:highlight_row(this);'>\r\n <div class='abc_col'>" . $abc_adt->productID() . "</div>" . "<div class='abc_col' style='cursor:pointer;' onclick=\"location.href='products?search=" . $abc_adt->productName() . "'\">" . $abc_adt->productName() . "</div>" . "<div class='abc_col'>" . number_format($abc_adt->wholePrice(), 2, ',', '.') . "</div>" . "<div class='abc_col'>" . $abc_adt->categorie() . "</div>\r\n </div>";
}
// echo("Name: ".$abc_adt->productName() ." :: Kategorie: ".$abc_adt->categorie()." :: Preis: ".number_format($abc_adt->wholePrice(),2,',','.')."<br>");
?>
</div>
<div id="bedarfs_analyse">
<div>
<div> Primaerbedarfs Analyse </div>
<div>TeilName<input id="teilname" value="<?php
echo $this->dataMap["bedarfsanalyse_teilname"];
?>
"></div>
<div>Letzter Monat<input id="monat" value="<?php
echo $this->dataMap["bedarfsanalyse_monat"];
?>
"></div>
<div>Jahr<input id="jahr" value="<?php
echo $this->dataMap["bedarfsanalyse_jahr"];
?>
"></div>
<div>Glaettungfaktor <input id="glaettungsfaktor" value="<?php
echo $this->dataMap["bedarfsanalyse_faktor"];
?>
"></div>
<button onclick="javascript:berechnen()">Berechnen</button>
<div>Ergebnis <input id="ergebnis" value="<?php
echo $this->dataMap["bedarfsanalyse_ergebnis"];
?>
"></div>
</div>
</div>
<div id="operationen">
<div id ="einfuegen">
<div id="teil">
Teil erstellen
<input type="text" id="teil_bezeichnung" value="Produkt1">
<input type="text" id="teil_preis" value="Preis">
<input type="text" id="teil_typ" value="Kategorie">
<input type="text" id="teil_angeboten" value="wird es angeboten?">
<input type="text" id="teil_bild" value="bildurl">
<input type="text" id="teil_beschreibung" value="beschreibung" size="94">
<button onclick="javascript:teil_hinzufuegen()">Eintragen</button>
</div>
<div id="struktur">
Struktur erstellen
<input type="text" id="struktur_otnr" value="OTNR">
<input type="text" id="struktur_utnr" value="UTNR">
<input type="text" id="struktur_menge" value="Menge">
<button onclick="javascript:struktur_hinzufuegen()">Eintragen</button>
</div>
<div id="kunde">
Kunde erstellen
<input type="text" id="kunde_Name" value="Name">
<input type="text" id="kunde_Vorname" value="Vorname">
<input type="text" id="kunde_eMail" value="eMail">
<button onclick="javascript:kunde_hinzufuegen()">Eintragen</button>
</div>
<div id="bestellung">
Bestellung erstellen
<input type="text" id="bestellung_KundenNr" value="KundenNr">
<button onclick="javascript:bestllung_hinzufuegen()">Eintragen</button>
Artikel der Bestellung hinzufuegen
<input type="text" id="bestellung_BestellungsNr" value="BestellungsNr">
<input type="text" id="bestellung_TNr" value="TeileNr">
<button onclick="javascript:artikel_bestellung_hinzufuegen()">Eintragen</button>
</div>
<div id="pagehits">
Seiten Statistik
<?php
MonitorEntry::showPageHits();
?>
</div>
<div id="artikelhits">
</div>
<div id="bedarfs_daten">
Bedarfs Daten
<?php
AuftragsVerfolgung::printBedarfTabelle($this->dataMap["bedarfs_daten"]);
?>
</div>
<div id="bedarfsableitungs_daten">
Bedarfsableitungen
<?php
AuftragsVerfolgung::printBedarfAbleitungsTabelle($this->dataMap["bedarfsableitungs_daten"]);
?>
</div>
</div>
</div>
</div>
<?php
}
