Viewing file: clsStudentBehavior.php (1.36 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?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-- ?>
|