<?php
//--Class StudentBehavior--------------------------

include_once "clsbase_StudentBehavior.php";

class StudentBehavior extends base_StudentBehavior {

function RSStudentBehaviorByStId($stId){
	$this->SetQuery("select * from StudentBehavior where studentId='$stId' order by acadYear, semester, recordDate");
}

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

function RSStudentBehaviorByStIdAndGEAdY($stId, $adY){
	$this->SetQuery("select * from StudentBehavior 
						where studentId='$stId' and acadYear>='$adY' 
						order by acadYear, semester, recordDate");
}

function RSStudentBehaviorByStIdAndLTAdY($stId, $adY){
	$this->SetQuery("select * from StudentBehavior 
						where studentId='$stId' and acadYear<'$adY' 
						order by acadYear, semester, recordDate");
}

function RSStudentBehaviorByStIdAndGood($xKey){
	$this->SetQuery("select * from StudentBehavior where studentId='$xKey' and disciplineId>=2");
}

function GetSumCutPointByStIdAndAcYAndSe($xKey, $yKey, $zKey){
	$this->SetQuery("select sum(cutPoint) as num from StudentBehavior where studentId='$xKey' and acadYear='$yKey' and semester='$zKey'");
    if ($result=$this->GetResult()) {
        return $result['num'];
    }
}

} //--End class StudentBehavior--
?>