<?php
//--Class CourseFeeTP--------------------------

include_once "clsbase_CourseFeeTP.php";

class CourseFeeTP extends base_CourseFeeTP{

function RSCourseFeeTPGroupAcY(){
	$this->SetQuery("select acadYear from CourseFeeTP group by acadYear");
}

function RSCourseFeeTPByAcYGroupPgId($xKey){
	$this->SetQuery("select c.programId from CourseFeeTP c, Program p 
						where c.acadYear='$xKey' and c.programId=p.programId and p.programStatus='Y' 
						group by programId");
}

function RSCourseFeeTPByPgIdAndAcY($xKey, $yKey){
	$this->SetQuery("select * from CourseFeeTP where programId='$xKey' and acadYear='$yKey'");
}

} //--End class CourseFeeTP--
?>