Untitled

<?php	// UTF-8 marker äöüÄÖÜß€
/**
 * Class PageTemplate for the exercises of the EWA lecture
 * Demonstrates use of PHP including class and OO.
 * Implements Zend coding standards.
 * Generate documentation with Doxygen or phpdoc
 *
 * PHP Version 5
 *
 * @category File
 * @package  Pizzaservice
 * @author   Bernhard Kreling, <b.kreling@fbi.h-da.de>
 * @author   Ralf Hahn, <ralf.hahn@h-da.de>
 * @license  http://www.h-da.de  none
 * @Release  1.2
 * @link     http://www.fbi.h-da.de
 */

// to do: change name 'PageTemplate' throughout this file
require_once './Page.php';

/**
 * This is a template for top level classes, which represent
 * a complete web page and which are called directly by the user.
 * Usually there will only be a single instance of such a class.
 * The name of the template is supposed
 * to be replaced by the name of the specific HTML page e.g. baker.
 * The order of methods might correspond to the order of thinking
 * during implementation.

 * @author   Bernhard Kreling, <b.kreling@fbi.h-da.de>
 * @author   Ralf Hahn, <ralf.hahn@h-da.de>
 */
class Bestellung extends Page
{

    // to do: declare reference variables for members
    // representing substructures/blocks

    /**
     * Instantiates members (to be defined above).
     * Calls the constructor of the parent i.e. page class.
     * So the database connection is established.
     *
     * @return none
     */
    protected function __construct()
    {
        parent::__construct();
        // to do: instantiate members representing substructures/blocks
    }

    /**
     * Cleans up what ever is needed.
     * Calls the destructor of the parent i.e. page class.
     * So the database connection is closed.
     *
     * @return none
     */
    protected function __destruct()
    {
        parent::__destruct();
    }

    /**
     * Fetch all data that is necessary for later output.
     * Data is stored in an easily accessible way e.g. as associative array.
     *
     * @return none
     */
    protected function getViewData()
    {
		// to do: fetch data for this view from the database
		$angebot = array();

		$SQLabfrage = "SELECT * FROM angebot";
		$Recordset = $this->_database  ->query ($SQLabfrage);//$Recordset = $this->_database  ->query ($SQLabfrage);		//wird hier jetzt iwie einfach ein recordset deklariert (ohne klasse usw?)

		if (!$Recordset)
			throw new Exception("Query failed: ".$Connection->error);

		//return $Recordset;


		$counter = 0;
		$pizza = array();					//konnte man iwie net drinnen definieren??
		while ($record = $Recordset->fetch_assoc()){
			$pizza["PizzaNummer"] = $record["PizzaNummer"];
			$pizza["PizzaName"]	  = $record["PizzaName"];
			$pizza["Preis"] 	  = $record["Preis"];
			$pizza["Bilddatei"]	  = $record["Bilddatei"];
			//$angebot[0] = $pizza;
			array_push($angebot, $pizza);
		}

		return $angebot;
	}


    /**
     * First the necessary data is fetched and then the HTML is
     * assembled for output. i.e. the header is generated, the content
     * of the page ("view") is inserted and -if avaialable- the content of
     * all views contained is generated.
     * Finally the footer is added.
     *
     * @return none
     */
    protected function generateView() 					//warum geht $record (in schleife) benutzen hier nicht, aber in getviewdata schon??
    {

        $dbergebnisse = $this->getViewData();
		//$record = $this->$Recordset;
		//$aktnummer = $record["PizzaNummer"];
        $this->generatePageHeader('Bestellung');
        // to do: call generateView() for all members
			//<form action="https://echo.fbi.h-da.de/" method="POST">
			//<form action="http://127.0.0.1/pizzaservice/Kundeerbend.php" method="POST">	//original

		//$_SESSION["testwert"] = "bla";
		//<form action="http://127.0.0.1/pizzaservice/Kundeerbend.php" method="POST">
	echo <<< test1
		<body onload="isorderable()">

		<form action="http://127.0.0.1/pizzaservice/ewa/Kundeerbend.php" method="POST" onsubmit="selectAll()">

		<h2> Bestellung</h2>
		<h2> Speisekarte</h2>
test1;

		foreach($dbergebnisse as $pizza){
			$aktpizzanummer = $pizza["PizzaNummer"];
			$aktname	  = $pizza["PizzaName"];
			$aktpreis 	  = $pizza["Preis"];
			$aktbilddatei  = $pizza["Bilddatei"];
echo <<< test10
		<p hidden id= $aktpizzanummer data-preis=$aktpreis> idptemp </p>
		<p>$aktname</p>
		<p>$aktpreis €</p>
		<img src=$aktbilddatei alt="margherita" width="80" height="80" onclick="addpizza($aktpizzanummer,'$aktname',$aktpreis)" onclick="isorderable()">
test10;

		}

/*
		echo <<< test1
		<body>
	<form action="http://127.0.0.1/pizzaservice/Kundeerbend.php" method="POST">
 	<h2> Bestellung</h2>
	<h2> Speisekarte</h2>
*/
/*

	<!-- Pizzen aus Datenbank -->
	<img src="ewabild.jpg" alt="margherita" width="80" height="80">
	<p>Margherita</p>
	<p>4.00€</p>
	<img src="ewabild.jpg" alt="salami" width="80" height="80">
	<p>Salami</p>
	<p>4.50€</p>
	<img src="ewabild.jpg" alt="hawaii" width="80" height="80">
	<p>Hawaii</p>
	<p>5.50€</p>
*/
		$angebotsgroesse = count($dbergebnisse);			//kein code in ausgabe!! (also nicht nach echo)
echo <<< test1
	<h2>Warenkorb</h2>


	<select name="top[]" id= "warenkorb" size=" $angebotsgroesse " multiple>
test1;
/*
foreach($dbergebnisse as $pizza){
			$aktpizzanummer = $pizza["PizzaNummer"];
			$aktname	  = $pizza["PizzaName"];
			$aktpreis 	  = $pizza["Preis"];
			$aktbilddatei  = $pizza["Bilddatei"];

echo <<< test1
			<option value = "$aktpizzanummer"> $aktname </option>
test1;
}
*/
echo "</select>";


/*
echo <<< test2
<table name = "blatabelle" id="infoetc" size=" $angebotsgroesse " multiple>
<tr>
	<td>"bla</td>
</tr>
test2;


foreach($dbergebnisse as $pizza){
			$aktpizzanummer = $pizza["PizzaNummer"];
			$aktname	  = $pizza["PizzaName"];
			$aktpreis 	  = $pizza["Preis"];
			$aktbilddatei  = $pizza["Bilddatei"];

echo <<< test1
			<tr id = "$aktpizzanummer">
				<td data-name>$aktname</td>
				<td data-preis>$aktpreis</td>
			</tr>
test1;
}

echo "</table>";
*/


echo <<< test1
	<p id="gesamtpreisanzeige">0</p>
	<input id = "gesamtpreisanzeigeinput" type="hidden" name="gesamtpreis" value="14.50" />
	<p><label>
		<input type="text" id='kundenadresse' name="kundenadresse"  onchange="isorderable()" onClick="selectAll()"/>
		</label></p>
	<input type="reset" name="Alle löschen" value="Alle Löschen" onclick= "deleteAll()"/>
	<input type="button" name="Auswahl löschen" value="Auswahl Löschen" onclick = "deleteSome()"/>
	<input type="submit" id="bestellen" name="bestellen" value="Bestellen"  />
	</form>
	<script type ="text/javascript" src="MyJS.js"></script>
	<script type="text/javascript">
    isorderable();
	</script>
</body>

test1;


        // to do: output view of this page
        $this->generatePageFooter();
    }

    /**
     * Processes the data that comes via GET or POST i.e. CGI.
     * If this page is supposed to do something with submitted
     * data do it here.
     * If the page contains blocks, delegate processing of the
	 * respective subsets of data to them.
     *
     * @return none
     */
    protected function processReceivedData()
    {
        parent::processReceivedData();
        // to do: call processReceivedData() for all members

    }

    /**
     * This main-function has the only purpose to create an instance
     * of the class and to get all the things going.
     * I.e. the operations of the class are called to produce
     * the output of the HTML-file.
     * The name "main" is no keyword for php. It is just used to
     * indicate that function as the central starting point.
     * To make it simpler this is a static function. That is you can simply
     * call it without first creating an instance of the class.
     *
     * @return none
     */
    public static function main()
    {
        //session_start();
		try {
            $page = new Bestellung();
            $page->processReceivedData();

            $page->generateView();
        }
        catch (Exception $e) {
            header("Content-type: text/plain; charset=UTF-8");
            echo $e->getMessage();
        }
    }
}

// This call is starting the creation of the page.
// That is input is processed and output is created.
Bestellung::main();

// Zend standard does not like closing php-tag!
// PHP doesn't require the closing tag (it is assumed when the file ends).
// Not specifying the closing ? >  helps to prevent accidents
// like additional whitespace which will cause session
// initialization to fail ("headers already sent").
//? >