<?php header('Content-Type: application/json; charset=utf-8'); ?>

	<?php


	error_reporting(E_ALL);
	//error_reporting(E_ERROR | E_WARNING | E_PARSE);
	//error_reporting(0);



	class ResultError{
		public $isError=false;
		public $error='';
	}

	class ResultCustomers{
		public $isError=false;
		public $error='';
		public $liste = array();
	}




	function quoted($item) {
		return "'" . $item . '\'';
	}

	function getConnection() {
		$servername='localhost';
		$username='root';
		$passwd='';
		$database='amacon';
		$conn = new mysqli($servername, $username, $passwd, $database);
		if ($conn->connect_error)  {
			die('Connection failded: ' . $conn->connect_error);
		}
		return $conn;
	}



	function getDBSequence() {
		$conn = getConnection();
		if ($conn->connect_error)  {
			return 0;
		}
		$sql = 'UPDATE sequence SET id=LAST_INSERT_ID(id+1);';
		$result = $conn->query($sql);
		if ( $result ){
			$sql ='SELECT * FROM `sequence` '; // SELECT LAST_INSERT_ID()';
			$result = $conn->query($sql);
			if ( $result ){
				while ( $row = $result->fetch_array() ) {
					$sequence = intval($row[0]) ;
				} // while
			}  // if


		}
		else {
			// die('SQL-Anweisung gescheitert');
			$sequence = 0;
		}
		return $sequence;
	}


	// Result  isError, error, liste
	function loadCustomersFromDB() {
		$result = new ResultCustomers();
		$conn = getConnection();
		if ($conn->connect_error)  {
			$result->isError=true;
			$result->error = $conn->connect_error;
			return $result;
		}

		$sql = 'SELECT PINDEX, CNR, LASTNAME, FIRSTNAME, STREET, BIRTHDAY FROM customer';
		$resultSQL = $conn->query($sql);
		if (!$resultSQL) {
			$result->isError=true;
			$result->error = 'Fehlerhafte SQL-Anweisung<br />' . $conn->error . '<br />' . $sql;
		}
		else {
			while ($row=$resultSQL->fetch_array()) {
				$customer = new Customer();
				$customer->pindex = intval($row['PINDEX']);
				$customer->cnr= intval($row['CNR']);
				$customer->lastname = $row['LASTNAME'];
				$customer->firstname = $row['FIRSTNAME'];
				$customer->street = $row['STREET'];
				$customer->birthday = $row['BIRTHDAY'];
				$result->liste[] = $customer;
			}  // while
			$resultSQL->close();
		}

		$conn->close();

		return $result;
	}  // loadCustomersFromDB



	// wegen Plausi
	function loadCnrCustomersFromDB($pindex) {
		$arr = array();
		$conn = getConnection();
		if ($conn->connect_error)  {
			return $arr;
		}
		$sql = 'SELECT CNR FROM customer WHERE pindex!=' . $pindex;
		$result = $conn->query($sql);
		if ($result) {
			while($row=$result->fetch_array()) {
				$cnr=intval($row['CNR']);
				//echo $row['CNR'] . '<br />';
				$arr[] = $cnr;
			}
		}
		$conn->close();

		return $arr;
	}  // loadCustomersFromDB


	class ResultCustomerPattern{
		public $isError=false;
		public $error='';
		public $customer;

		public $uipatternliste = array();
	}

	class ResultPattern{
		public $isError=false;
		public $error='';
		public $uipatternliste = array();
	}

	class UIPattern{
		public $uikey='';
		public $uityp='';
		public $caption='';
		public $minval=0;
		public $maxval=0;
		public $uipattern='';
	}

	function loadCustomerFromDB($pindex) {
		$result = new ResultCustomerPattern();
		$conn = getConnection();
		if ($conn->connect_error)  {
			$result->isError=true;
			$result->error = $conn->connect_error;
			return $result;
		}

		$sql = 'SELECT PINDEX, CNR, LASTNAME, FIRSTNAME, STREET, BIRTHDAY FROM customer WHERE pindex=' . $pindex;
		$resultSQL = $conn->query($sql);

		if (!$resultSQL) {
			$result->isError=true;
			$result->error = 'Fehlerhafte SQL-Anweisung<br />' . $conn->error . '<br />' . $sql;
		}
		else {
			$result->customer = new Customer();
			while($row=$resultSQL->fetch_array()) {
				$result->customer->pindex=intval($row['PINDEX']);
				$result->customer->cnr=intval($row['CNR']);
				$result->customer->lastname=$row['LASTNAME'];
				$result->customer->firstname=$row['FIRSTNAME'];
				//$result->customer->firstname='AbcÜÄÖßüäö';
				$result->customer->street=$row['STREET'];
				$result->customer->birthday=$row['BIRTHDAY'];
			}  // while
			$resultPattern=getCustomerPatternFromDB();
			if ($resultPattern->isError) {
				$result->isError=true;
				$result->error = $resultPattern->error;
			}
			else {
				$result->uipatternliste = $resultPattern->uipatternliste;
			}

		}  // else

		$conn->close();

		/*
		$filename = "pattern.txt";
		$handle = fopen($filename,"w");
		foreach ($result->uipatternliste as $pattern) {
			fwrite($handle, $pattern->caption . "\r\n");
			fwrite($handle, $pattern->uipattern . "\r\n");
		}

		fclose($handle);
		*/


		return $result;
	}  // loadCustomerFromDB




	function  updateCustomerDB($customer) {
		$result = new ResultError();

		$conn = getConnection();
		if ($conn->connect_error)  {
			$result->isError=true;
			$result->error = $conn->connect_error;
			return $result;
		}

		$sql = 'UPDATE customer ' .
		' SET '.
		' CNR=' . $customer->cnr. ', ' .
		' LASTNAME=' . quoted($customer->lastname) . ', ' .
		' FIRSTNAME=' . quoted($customer->firstname) . ', ' .
		' STREET=' . quoted($customer->street) . ', ' .
		' BIRTHDAY=' . quoted($customer->birthday) .
		" WHERE PINDEX=$customer->pindex ";


		$resultSQL = $conn->query($sql);

		// $conn->close(); // Problem wenn cnr schon da ist

		if ($resultSQL) {
			$result->isError=false;
		}
		else {
			$result->isError=true;
			$result->error = 'Fehlerhafte SQL-Anweisung<br />' . $conn->error . '<br />' . $sql;
		}
		return $result;
	}  // updateCustomerDB




	function deleteCustomerDB($pindex) {
		$result = new ResultError();

		$conn = getConnection();
		if ($conn->connect_error)  {
			$result->isError=true;
			$result->error = $conn->connect_error;
			return $result;
		}

		$sql = 'DELETE FROM customer ' .'  WHERE `PINDEX`=' . $pindex;
		//echo $sql . '<br />';
		if ($conn->query($sql))  {
			$result->isError=false;
		}
		else {
			$result->isError=true;
			$result->error = 'Fehlerhafte SQL-Anweisung' . $conn->error .  $sql;
		}
		$conn->close();
		return $result;
	} // deleteCustomerDB







	function insertCustomerDB($customer) {
		$result = new ResultError();
		/*
		$cnrArray = loadCnrCustomersFromDB(-1);
		foreach ($cnrArray as $cnr) {
			if ($cnr==$customer->cnr) {
				$result->isError=true;
				$result->error = 'Fehler:  die cnr ist schon vorhanden';
				return $result;
			}
		}
		*/

		$conn = getConnection();
		if ($conn->connect_error)  {
			$result->isError=true;
			$result->error = $conn->connect_error;
			return $result;
		}

		$customer->pindex = getDBSequence();

		$sql = 'INSERT INTO customer(PINDEX, CNR, LASTNAME, FIRSTNAME, STREET,  BIRTHDAY)' .
		' VALUES(  ' .
		' ' . $customer->pindex . ', ' .
		' ' . $customer->cnr . ', ' .
		' ' . quoted($customer->lastname) . ', ' .
		' ' . quoted($customer->firstname) . ', ' .
		' ' . quoted($customer->street) . ', ' .
		' ' . quoted($customer->birthday) .
		' )';


		//echo $sql . '<br />';
		if ($conn->query($sql))  {
			$result->isError=false;
		}
		else {
			$result->isError=true;
			$result->error = 'Fehlerhafte SQL-Anweisung<br />' . $conn->error . '<br />' . $sql;
		}
		$conn->close();
		return $result;
	} // insertCustomerDB




	function convertUmlaute($text) {
		$umlaute1 = array('Ä','Ö','Ü','ä','ö','ü','ß');
		$umlaute2 = array('_Ae_','_Oe_','_Ue_','_ae_','_oe_','_ue_','_ss_');

		$text2 = str_replace($umlaute1, $umlaute2, $text);
		return $text2;
	}




	function getCustomerPatternFromDB() {
		$result = new ResultPattern();
		//  $isError,  $error,  $uipatternliste
		$conn = getConnection();
		if ($conn->connect_error)  {
			$result->isError=true;
			$result->error = $conn->connect_error;
			return $result;
		}

		$sql = 'SELECT uikey, uityp, caption, minval, maxval, pattern from uipattern';
		$resultSQL = $conn->query($sql);

		//  __construct($uikey, $uityp, $caption, $minval, $maxval,  $pattern) {

			if ($resultSQL) {
				while($row=$resultSQL->fetch_array()) {
					$uipattern = new UIPattern();
					$uipattern->uikey=$row['uikey'];
					$uipattern->uityp=$row['uityp'];
					$uipattern->caption=$row['caption'];
					$uipattern->minval=intval($row['minval']);
					$uipattern->maxval=intval($row['maxval']);
					$uipattern->uipattern=$row['pattern'];

					// utf8_encode
					// $uipattern->uipattern=utf8_encode('AÜÖÄBC'); //AZÜÄÖazüäöß';
					$result->uipatternliste[] = $uipattern;
				}  // while
			}  // else
			else {
				$result->isError=true;
				$result->error = 'Fehlerhafte SQL-Anweisung<br />' . $conn->error . '<br />' . $sql;
			}

			$conn->close();

			return $result;
		}



	?>