bug.php

Bug tracker, and reporter.

<?php
class Bug extends Zend_Db_Table {
	
	protected $_name = "bugs";
	
	public function getOne($id){
		$tab = $this -> fetchRow('bug_id = '.$id);
		
		$retour = array();
		$user = new User();
		$type = new Type();
		$priorite = new Priorite();
		$status = new Status();
		
		$retour = array();
		
		$isbuser = $user -> fetchRow('user_id = '.$tab -> send_by);
		$iatuser = $user -> fetchRow('user_id = '.$tab -> affected_to);
		$iprio = $priorite -> fetchRow('priorite_id = '.$tab -> priority_id);
		$istat = $status -> fetchRow('status_id = '.$tab -> status_id);
		$itype = $type -> fetchRow('type_id = '.$tab -> type_id);
		
		$retour['bug_id'] = ($tab -> bug_id);
		$retour['titre'] = $tab -> titre;
		$retour['sendby'] = $isbuser -> nom .' '.$isbuser -> prenom;
		$retour['affectedto'] = $iatuser -> nom .' '.$iatuser -> prenom;
		$retour['priorite'] = $iprio -> priorite_label;
		$retour['status'] = $istat -> label;
		$retour['type'] = $itype -> label; 
		$retour['date'] = new Zend_Date($tab -> date,null,'fr');
		$retour['contenu'] = $tab -> contenu;
		return $retour;
	}
	
	public function exist($id){
		if($this -> fetchRow('bug_id = '.$id)){
			return true;
		}
		return false;
	}
	
	
}
?>