<?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--
?>