<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

/**
 * Description of  model
 *
 * @author Liesbeth
 * @date april 25 2013
 */

class ModPartActKosten extends MY_Model{

	protected $tablename 	= 'tbPartActKosten';


	function __construct(){
		// parent::__construct();
		//$models = array();
		//$this->load->model($models);
	}
	function get_kosten_per_activiteit($actID){
		$this->sql = "SELECT id, omschrijving, kosten, activiteitID as actID
					    FROM tbPartActKosten
					  WHERE activiteitID = $actID"  ;
		$results = $this->get_query_result(); 
		if (! empty($results)) {
			foreach ($results as $result) {
				$result->kosten = mysql2bedrag($result->kosten);
			};
		};
		return $results;
	}
	function get_kosten_per_regel($kostID){
		$this->sql = "SELECT id, omschrijving, kosten , activiteitID as actID
					    FROM tbPartActKosten
					  WHERE id = $kostID"  ;
		 $results = $this->get_query_row(); 
		if (! $results) $results = new stdClass();
		$results->kosten = mysql2bedrag($results->kosten);
		return $results;
	}
}