<?php
//--Class StudentAbsent--------------------------

include_once "clsbase_StudentAbsent.php";

class StudentAbsent extends base_StudentAbsent {

function RSStudentAbsentByStId($stId){
	$this->SetQuery("select * from StudentAbsent where studentId='$stId' order by acadYear, dateFrom");
}

function GetNextSeqByStId($xKey){
	$this->SetQuery("select max(sequenceId) as num from StudentAbsent where studentId='$xKey'");
	if ($result=$this->GetResult()) {
		return $result['num']+1;
	}
}

function RSStudentAbsentByStIdAndGEAdY($stId, $adY){
	$this->SetQuery("select * from StudentAbsent 
						where studentId='$stId' and acadYear>='$adY' 
						order by acadYear, dateFrom");
}

function RSStudentAbsentByStIdAndLTAdY($stId, $adY){
	$this->SetQuery("select * from StudentAbsent 
						where studentId='$stId' and acadYear<'$adY' 
						order by acadYear, dateFrom");
}

} //--End class StudentAbsent--
?>