<?php

class Facturen extends Database {
	public $klant = '';
	public $id = '';
	public $titel = '';
	public $factuurnummer = '';
	public $verloopdatum = '';
	public $totaal = '';
	public $betaald = 'Nee';

	function Facturen() {

	}

	function get($limit = false, $sort = "id", $sortascdesc = "ASC") {
		$query = "SELECT * FROM facturen ORDER BY ". $sort ." ". $sortascdesc;

		if($limit) {
			$query .= " LIMIT ". $limit;
		}

		$result = mysql_query($query);

		$facturen = array();

		while($row = mysql_fetch_array($result)) {
			$factuur = new Facturen();
			$factuur = $factuur->getByID($row['id']);

			$facturen[] = $factuur;
		}

		return $facturen;
	}

	function getByKlant($klant, $limit = false, $sort = "id", $sortascdesc = "ASC") {
		$query = "SELECT id FROM facturen WHERE klant='". $klant ."' ORDER BY ". $sort ." ". $sortascdesc;

		if($limit) {
			$query .= " LIMIT ". $limit;
		}

		$result = mysql_query($query);

		$facturen = array();

		while($row = mysql_fetch_array($result)) {
			$factuur = new Facturen();
			$factuur = $factuur->getByID($row['id']);

			$facturen[] = $factuur;
		}

		return $facturen;
	}

	function getByID($id) {
		$result = mysql_fetch_array(mysql_query("SELECT * FROM facturen WHERE id='". $id ."'"));

		$klanten = new Klant();

		$this->klant = $klanten->getByID($result['klant']);

		$this->id = $result['id'];
		$this->totaal = $result['totaalprijs'];
		$this->titel = $result['titel'];
		$this->factuurnummer = $result['factuurnummer'];
		$this->verloopdatum = $result['verloopdatum'];
		$this->betaald = $result['betaald'];

		return $this;
	}
}
?>