webOffice_alt/includes/functions.inc.php

<?php

// Label functions

function getLabels() {
	global $db;

	$return = array();
	$labels = $db->query("SELECT * FROM `labels`;");

	foreach($labels as $label) {
		$return[] = new Label($label->id, $label->name);
	}

	return $return;
}

function getLabelById($labelId) {
	global $db;

	$return = array();
	$labels = $db->query("SELECT * FROM `labels` WHERE `id` = " . $labelId . ";");

	foreach($labels as $label) {
		$return[] = new Label($label->id, $label->name);
	}

	return $return;
}

function getDocumentsByLabelId($labelId) {
	global $db;

	$return = array();
	$documents = $db->query("SELECT * FROM `documents` WHERE `label_id` = " . $labelId . ";");

	foreach($documents as $document) {
		$return[] = new Document($document->id, $document->filename, $document->path, $document->label_id, $document->draft, $document->created, $document->last_change);
	}

	return $return;
}

?>