Viewing file:  clsEnrollItem.php (21.06 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class EnrollItem--------------------------
include_once "clsbase_EnrollItem.php";
class EnrollItem extends base_EnrollItem{
function GetSumCr1ByStIdAndAcYAndSe($xKey, $yKey, $zKey){
$this->SetQuery("select sum(credit1) as num from EnrollItem where studentId='$xKey' and acadYear='$yKey' and semester='$zKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetSumCr2ByStIdAndAcYAndSe($xKey, $yKey, $zKey){
$this->SetQuery("select sum(credit2) as num from EnrollItem where studentId='$xKey' and acadYear='$yKey' and semester='$zKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSEnrollItemByStIdAndAcYAndSe($xKey, $yKey, $zKey){
$this->SetQuery("select * from EnrollItem where studentId='$xKey' and acadYear='$yKey' and semester='$zKey'");
}
function RSEnrollItemByStIdAndAcYAndSeAndCdId($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from EnrollItem where studentId='$wKey' and acadYear='$xKey' and semester='$yKey' and conditionId='$zKey'");
}
function GetSumCrAtByStId($xKey){
$this->SetQuery("select sum(creditAttempt) as num from EnrollItem where studentId='$xKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetSumCrAtByStIdAndAcYAndSe($xKey, $yKey, $zKey){
$this->SetQuery("select sum(creditAttempt) as num from EnrollItem
where studentId='$xKey' and acadYear='$yKey' and semester='$zKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSEnrollItemByStIdAndAcYAndSeAndClId($wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from EnrollItem
where studentId='$wKey' and acadYear='$xKey' and semester='$yKey'
and classId='$zKey'");
}
function RSEnrollItemByStIdAndAcYAndSeAndCoId($stId, $acY, $se, $coId){
$this->SetQuery("select e.* from EnrollItem e, Class c
where e.studentId='$stId' and e.acadYear='$acY' and e.semester='$se'
and e.classId=c.classId and c.courseId='$coId' and c.declareStatus='Y'");
}
function GetSumCrAtByStIdAndCdIdAndCdId2($xKey, $yKey, $zKey){
$this->SetQuery("select sum(creditAttempt) as num from EnrollItem where studentId='$xKey' and conditionId='$yKey' and conditionId2='$zKey' and grade!='F'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSEnrollItemByStIdAndCdIdAndCdId2($xKey, $yKey, $zKey){
$this->SetQuery("select * from EnrollItem where studentId='$xKey' and conditionId='$yKey' and conditionId2='$zKey'");
}
function GetSumCrAtByStIdAndCdId($xKey, $yKey){
$this->SetQuery("select sum(creditAttempt) as num from EnrollItem where studentId='$xKey' and conditionId='$yKey' and grade!='F'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSEnrollItemByStIdAndCdId($xKey, $yKey){
$this->SetQuery("select e.* from EnrollItem e, Class c
where e.studentId='$xKey' and e.conditionId='$yKey'
and e.classId=c.classId order by c.courseId");
}
function RSEnrollItemByStIdAndGradeIsF($xKey){
$this->SetQuery("select * from EnrollItem where studentId='$xKey' and grade='F'");
}
function RSEnrollItemByStId($xKey){
$this->SetQuery("select * from EnrollItem where studentId='$xKey'");
}
function RSEnrollItemByClId($xKey){
$this->SetQuery("select e.* from EnrollItem e, StudentMaster s
where e.classId='$xKey' and e.studentId=s.studentId order by s.studentCode");
}
function RSEnrollItemByClIdAndStudying($xKey){
$this->SetQuery("select e.* from EnrollItem e, StudentMaster s
where e.classId='$xKey' and e.studentId=s.studentId and s.studentStatus=1 order by s.studentCode");
}
function GetCountStIdByClIdAndStSexAndStudying($xKey, $yKey){
$this->SetQuery("select count(s.studentId) as num from EnrollItem e, StudentMaster s
where e.classId='$xKey' and e.studentId=s.studentId and s.studentStatus=1 and s.studentSex='$yKey'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function SearchByStIdAndAcYAndSeAndCoId($stId, $acY, $se, $coId){
$sql = "select * from EnrollItem e, Class c
where studentId='$stId' and concat($acY, $se)>concat(e.acadYear, e.semester)
and e.classId=c.classId and courseId='$coId' and grade!='F'";
$this->SetQuery($sql);
if ($result=$this->GetResult()) {
return 1;
}else {
return 0;
}
}
// Use on page classTable.php
function RSEnrollItemByClassId($cKey, $dKey, $eKey){
$this->SetQuery("select classId from EnrollItem where classId='$cKey' and semester='$dKey' and acadYear='$eKey' group by classId");
}
//-- The end --
function RSEnrollItemByClsIdAcySem($clId, $acY, $se){
$this->SetQuery("select ei.* from EnrollItem ei, StudentMaster s
where ei.classId='$clId' and ei.acadYear='$acY' and ei.semester='$se'
and ei.studentId=s.studentId and s.studentStatus=1 order by s.studentCode");
}
function RSEnrollItemCountStIdByGrade($ClsId,$AcY,$SeM,$Gd){
$this->SetQuery("select count(studentId) as num from EnrollItem where classId='$ClsId' and acadYear='$AcY' and semester='$SeM' and grade='$Gd' order by studentId");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSEnrollItemCountStIdByAllGrade($ClsId,$AcY,$SeM){
$this->SetQuery("select count(studentId) as num from EnrollItem where classId='$ClsId' and acadYear='$AcY' and semester='$SeM' and grade!='F' and grade!='' order by studentId");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
//-- The end --
// Use on page processSendGrade.php
function SearchByKeyStudIdClsIdAcySem($wKey, $xKey, $yKey, $zKey){
if ($this->SetQuery("select * from EnrollItem where studentId='$wKey' and classId='$xKey' and acadYear='$yKey' and semester='$zKey' order by studentId")){
return 1;
}else {
return 0;
}
}
//-- The End --
// Use on page calGradeProg.php
function RSEnrollItemByAcySem($bKey,$cKey){
$this->SetQuery("select studentId from EnrollItem where acadYear='$bKey' and semester='$cKey' group by studentId");
}
//-- The end --
//-- Use on page calGradeProg.php --
function RSEnrollItemGetStud($aKey, $bKey, $cKey){
$this->SetQuery("select * from EnrollItem where studentId='$aKey' and acadYear='$bKey' and semester='$cKey' and noCalGPA='N'");
}
//-- The end --
function RSEnrollItemByPgIdAndAdYAndStYAndAcYAndSeAndGradeIsNotEmptyAndSendGrIsY($vKey, $wKey, $xKey, $yKey, $zKey){
$this->SetQuery("select * from EnrollItem, StudentMaster, Class where StudentMaster.programId='$vKey' and admitAcadYear='$wKey' and StudentMaster.studentYear='$xKey' and EnrollItem.acadYear='$yKey' and EnrollItem.semester='$zKey' and grade!='' and sendGradeStatus='Y' and EnrollItem.studentId=StudentMaster.studentId and EnrollItem.classId=Class.classId");
}
function RSEnrollItemCountGradeByStId($StId, $AcY, $SeM){
$this->SetQuery("select count(grade) as num from EnrollItem where studentId='$StId', acadYear='$AcY' and semester='$SeM'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSEnrollItemByStIdGroupAcYAndSe($xKey){
$this->SetQuery("select acadYear, semester from EnrollItem where studentId='$xKey' group by acadYear, semester");
}
/****************************** Start Cal Grade ******************************/
function RSEnrollItemSemGradeCr($stId, $acY, $se, $str){
$this->SetQuery("select sum(ei.creditAttempt) as num from EnrollItem ei, Class c
where ei.studentId='$stId' and ei.acadYear='$acY' and ei.semester='$se' and ei.noCalGPA='N'
and ei.grade in ($str) and ei.classId=c.classId and c.declareStatus='Y'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSEnrollItemCumGradeCr($stId, $acY, $se, $str){
$this->SetQuery("select sum(creditAttempt) as num from EnrollItem
where studentId='$stId' and concat($acY, $se) >= concat(acadYear,semester) and noCalGPA='N'
and grade in ($str)");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSEnrollItemCumGradeCr2($stId, $acY, $se, $str){
$this->SetQuery("select sum(ei.creditAttempt) as num from EnrollItem ei, Class c
where ei.studentId='$stId' and concat($acY, $se) >= concat(ei.acadYear,ei.semester) and ei.noCalGPA='N'
and ei.grade in ($str) and ei.classId=c.classId and c.declareStatus='Y'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function calCreditSatisfy($stId, $acY, $se){
include_once "clsGradeConfig.php";
$oGc = new GradeConfig();
$sumCreditSatisfy = 0;
$i = 0;
$oGc->RSGradeConfig();
while($oGc->GetRecord()){
if($oGc->grade!='F' && $oGc->calCredit=='Y'){
if($i == 0)
$strGnfy = "'".$oGc->grade."'";
else
$strGnfy .= ",'".$oGc->grade."'";
}
$i++;
}
$sumCreditSatisfy = $this->RSEnrollItemSemGradeCr($stId, $acY, $se, $strGnfy);
return $sumCreditSatisfy;
}
function calCumCreditAttempt($stId, $acY, $se){
include_once "clsGradeConfig.php";
$oGc = new GradeConfig();
$cumCreditAttmp = 0;
$i = 0;
$oGc->RSGradeConfig();
while($oGc->GetRecord()){
if($i == 0)
$strGay="'".$oGc->grade."',".$strGay;
else
$strGay="'".$oGc->grade."',".$strGay;
$i++;
}
$strGay .= "''";
$cumCreditAttmp = $this->RSEnrollItemCumGradeCr($stId, $acY, $se, $strGay);
return $cumCreditAttmp;
}
function calCumCreditSatisfy($stId, $acY, $se){
include_once "clsGradeConfig.php";
$oGc = new GradeConfig();
$cumCreditSatisfy = 0;
$i = 0;
$oGc->RSGradeConfig();
while($oGc->GetRecord()){
if($oGc->grade!='F' && $oGc->calCredit=='Y'){
if($i == 0)
$strGnfy = "'".$oGc->grade."'";
else
$strGnfy .= ",'".$oGc->grade."'";
}
$i++;
}
$cumCreditSatisfy = $this->RSEnrollItemCumGradeCr2($stId, $acY, $se, $strGnfy);
return $cumCreditSatisfy;
}
function GetDividendGPA($stId, $acY, $se){
$this->SetQuery("select sum(ei.creditAttempt*gc.gradePoint) as dividend from EnrollItem ei, Class c, GradeConfig gc
where ei.studentId='$stId' and ei.acadYear='$acY' and ei.semester='$se'
and ei.classId=c.classId and c.declareStatus='Y' and ei.grade=gc.grade");
if ($result=$this->GetResult()) {
return $result['dividend'];
}
}
function GetDividendGPAX($stId, $acY, $se){
$acYSe = $acY.$se;
$this->SetQuery("select sum(ei.creditAttempt*gc.gradePoint) as dividend from EnrollItem ei, Class c, GradeConfig gc
where ei.studentId='$stId' and concat(ei.acadYear, ei.semester)<='$acYSe'
and ei.classId=c.classId and c.declareStatus='Y' and ei.grade=gc.grade");
if ($result=$this->GetResult()) {
return $result['dividend'];
}
}
function GetDividendAYRGPA($stId, $acY){
$this->SetQuery("select sum(ei.creditAttempt*gc.gradePoint) as dividend from EnrollItem ei, Class c, GradeConfig gc
where ei.studentId='$stId' and ei.acadYear='$acY'
and ei.classId=c.classId and c.declareStatus='Y' and ei.grade=gc.grade");
if ($result=$this->GetResult()) {
return $result['dividend'];
}
}
function GetAllFDivisorGPA($stId, $acY, $se){
$this->SetQuery("select sum(ei.creditAttempt) as divisor from EnrollItem ei, Class c, GradeConfig gc
where ei.studentId='$stId' and ei.acadYear='$acY' and ei.semester='$se'
and ei.classId=c.classId and c.declareStatus='Y'
and ei.grade=gc.grade and gc.calGrade='Y'");
if ($result=$this->GetResult()) {
return $result['divisor'];
}
}
function GetAllFDivisorGPAX($stId, $acY, $se){
$acYSe = $acY.$se;
$this->SetQuery("select sum(ei.creditAttempt) as divisor from EnrollItem ei, Class c, GradeConfig gc
where ei.studentId='$stId' and concat(ei.acadYear, ei.semester)<='$acYSe'
and ei.classId=c.classId and c.declareStatus='Y'
and ei.grade=gc.grade and gc.calGrade='Y'");
if ($result=$this->GetResult()) {
return $result['divisor'];
}
}
function GetOneFDivisorGPAX($stId, $acY, $se){
$acYSe = $acY.$se;
$this->SetQuery("select sum(tt) as divisor from (
select sum(ei.creditAttempt) as tt
from EnrollItem ei, Class c, GradeConfig gc
where ei.studentId='$stId' and concat(ei.acadYear, ei.semester)<='$acYSe'
and ei.classId=c.classId and c.declareStatus='Y' and ei.grade=gc.grade and gc.gradePoint<>0
and c.courseId not in (select courseId from EnrollItem ei, Class c
where studentId='$stId' and concat(ei.acadYear, ei.semester)<='$acYSe'
and ei.classId=c.classId
group by studentId, courseId
having count(courseId)>1)
union
select sum(ei.creditAttempt) as tt
from EnrollItem ei, Class c, GradeConfig gc
where ei.studentId='$stId' and concat(ei.acadYear, ei.semester)<='$acYSe'
and ei.classId=c.classId and c.declareStatus='Y' and ei.grade<>'F' and ei.grade=gc.grade
and c.courseId in (select courseId from EnrollItem ei, Class c
where studentId='$stId' and concat(ei.acadYear, ei.semester)<='$acYSe'
and ei.classId=c.classId
group by studentId, courseId
having count(courseId)>1)
) aa");
if ($result=$this->GetResult()) {
return $result['divisor'];
}
}
function GetAllFDivisorAYRGPAX($stId, $acY){
$this->SetQuery("select sum(ei.creditAttempt) as divisor from EnrollItem ei, Class c, GradeConfig gc
where ei.studentId='$stId' and ei.acadYear='$acY'
and ei.classId=c.classId and c.declareStatus='Y'
and ei.grade=gc.grade and gc.calGrade='Y'");
if ($result=$this->GetResult()) {
return $result['divisor'];
}
}
function CalGradeByStIdAndAcYAndSe($stId, $acY, $se, $createUserId, $updateUserId){
include_once "../global0.php";
include_once "../class/clsStudentStatus.php";
include_once "../class/clsStudentMaster.php";
$conn = new Connection();
$oSm = new StudentMaster();
$oSs = new StudentStatus();
if($GLOBALS["CALGRADEF"] == '1')
$divisor = $this->GetAllFDivisorGPAX($stId, $acY, $se);
else if($GLOBALS["CALGRADEF"] == '2')
$divisor = $this->GetOneFDivisorGPAX($stId, $acY, $se);
// Update StudentMaster
$oSm->SearchByKey($stId);
$oSm->GetRecord();
$oSm->Edit();
$oSm->creditAttempt=$this->calCumCreditAttempt($stId, $acY, $se);
$oSm->creditSatisfy=$this->calCumCreditSatisfy($stId, $acY, $se);
$oSm->GPA=$this->GetDividendGPAX($stId, $acY, $se) / $divisor;
if(is_null($oSm->officerId1))
$oSm->officerId1 = 'NULL';
if(is_null($oSm->officerId2))
$oSm->officerId2 = 'NULL';
$oSm->updateUserId=$updateUserId;
$oSm->updateDateTime=date('Y-m-d H:i:s');
if(is_null($oSm->citizenId))
$oSm->citizenId = 'NULL';
if(is_null($oSm->preAdmitPositionId))
$oSm->preAdmitPositionId = 'NULL';
if($oSm->GPA < 1.75)
$oSm->studentStatusTmp = 7;
else
$oSm->studentStatusTmp = 1;
$oSm->Save();
// StudentStatus
$oSs->SearchByKey($stId, $acY, $se);
if($oSs->GetRecord()) {
// Update StudentStatus
$oSs->Edit();
$oSs->GPA=$this->GetDividendGPA($stId, $acY, $se) / $this->GetAllFDivisorGPA($stId, $acY, $se);
$oSs->creditAttempt=$this->GetSumCrAtByStIdAndAcYAndSe($stId, $acY, $se);
$oSs->creditSatisfy=$this->calCreditSatisfy($stId, $acY, $se);
$oSs->creditPoint=$this->GetAllFDivisorGPA($stId, $acY, $se);
$oSs->GPAX=$this->GetDividendGPAX($stId, $acY, $se) / $divisor;
$oSs->sumCreditAttempt=$this->calCumCreditAttempt($stId, $acY, $se);
$oSs->sumCreditSatisfy=$this->calCumCreditSatisfy($stId, $acY, $se);
$oSs->sumCreditPoint=$divisor;
$oSs->updateDateTime=date('Y-m-d H:i:s');
$oSs->updateUserId=$updateUserId;
if(is_null($oSs->approveSpe))
$oSs->approveSpe = 'NULL';
}
else {
// Insert StudentStatus
$oSs->AddNew();
$oSs->studentId=$stId;
$oSs->acadYear=$acY;
$oSs->semester=$se;
$oSs->studentStatus=$oSm->studentStatus;
$oSs->GPA=$this->GetDividendGPA($stId, $acY, $se) / $this->GetAllFDivisorGPA($stId, $acY, $se);
$oSs->creditAttempt=$this->GetSumCrAtByStIdAndAcYAndSe($stId, $acY, $se);
$oSs->creditSatisfy=$this->calCreditSatisfy($stId, $acY, $se);
$oSs->creditPoint=$this->GetAllFDivisorGPA($stId, $acY, $se);
$oSs->GPAX=$this->GetDividendGPAX($stId, $acY, $se) / $divisor;
$oSs->sumCreditAttempt=$this->calCumCreditAttempt($stId, $acY, $se);
$oSs->sumCreditSatisfy=$this->calCumCreditSatisfy($stId, $acY, $se);
$oSs->sumCreditPoint=$divisor;
$oSs->createDateTime=date('Y-m-d H:i:s');
$oSs->createUserId=$createUserId;
$oSs->updateDateTime=date('Y-m-d H:i:s');
$oSs->updateUserId=$updateUserId;
if(is_null($approveSpe))
$approveSpe = 'NULL';
$oSs->approveSpe=$approveSpe;
$oSs->approver=$approver;
$oSs->refNo=$refNo;
$oSs->approveDate=$approveDate;
$oSs->passStatus=$passStatus;
}
$oSs->Save();
}
/****************************** End Cal Grade ******************************/
/****************************** Start Pass Student ******************************/
function GetCountGradeByStIdAndAcYAndGradeIsF($xKey, $yKey){
$this->SetQuery("select count(grade) as num from EnrollItem where studentId='$xKey' and acadYear='$yKey' and noCalGPA='N' and grade='F'");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSEnrollItemByStIdAndAcY($xKey, $yKey){
$this->SetQuery("select * from EnrollItem where studentId='$xKey' and acadYear='$yKey'");
}
function RSEnrollItemByStIdAndAcYAndSendGrIsNUnionGradeInIEPX($stId, $acY){
$sql = "select e.* from EnrollItem e, Class c
where e.studentId='$stId' and e.acadYear='$acY' and e.classId=c.classId and c.sendGradeStatus='N'
union
select e.* from EnrollItem e
where e.studentId='$stId' and e.acadYear='$acY' and e.grade in ('I', 'E', 'P', 'X', '')";
$this->SetQuery($sql);
}
function GetPassStatusByStIdAndAcY($stId, $acY){
include_once "../class/clsStudentMaster.php";
include_once "../class/clsProgram.php";
$conn = new Connection();
$oSm = new StudentMaster();
$oPg = new Program();
$oSm->SearchByKey($stId);
$oSm->GetRecord();
$oPg->SearchByKey($oSm->programId);
$oPg->GetRecord();
if($oSm->studentStatus==7 || $oSm->studentStatus==9 || intval($acY - $oSm->admitAcadYear)>$oPg->studyYearMax)
return 5;
else {
if($oSm->totalPoint < 80)
return 4;
else {
if($oSm->GPA >= $GLOBALS["ANNUALGPAX"]) {
if($this->GetCountGradeByStIdAndAcYAndGradeIsF($stId, $acY) == 0)
return 1;
else
return 2;
}
else if($oSm->GPA>=1.95 && $oSm->GPA<$GLOBALS["ANNUALGPAX"])
return 3;
else
return 4;
}
}
}
/****************************** End Pass Student ******************************/
// Use on page beforeShowClassTeach.php
function RSEnrollItemByAcySem2($bKey,$cKey){
$this->SetQuery("select * from EnrollItem where acadYear='$bKey' and semester='$cKey' order by studentId");
}
function SearchByKeyClsId($ClsId){
if($this->SetQuery("select count(classId) as num from EnrollItem where classId='$ClsId' order by classId")){
return 1;
}else{
return 0;
}
}
//-- The end --
function SearchCourseByStIdAcYSemTssDay($StId,$AcY,$SeM,$Tss,$Dy){
$this->setQuery("select cr.courseCode, e.classId, e.section, r.roomNo, t.timeSlotStart, t.timeSlotEnd
from EnrollItem e, Class c, ClassTimeTable t, Course cr, Room r
where e.studentId='$StId' and e.acadYear='$AcY' and e.semester='$SeM' and
e.classId=c.classId and c.classId=t.classId and c.courseId=cr.courseId and
t.roomId=r.roomId and t.timeSlotStart='$Tss' and t.weekDay='$Dy'");
}
function ClearData(){
$this->tcourseCode ='';
$this->tsection ='';
$this->troomNo ='';
$this->tTimeSlotStart ='';
$this->tTimeSlotEnd ='';
}
function RSEnrollItemByAcYAndSeGroupClId($xKey, $yKey){
$this->SetQuery("select ei.classId from EnrollItem ei, Class cl, Course co
where ei.acadYear='$xKey' and ei.semester='$yKey' and ei.classId=cl.classId
and cl.courseId=co.courseId group by ei.classId
order by cl.programId, co.courseCode, co.courseName");
}
function RSEnrollItemByAcYAndSeAndPgIdGroupClId($xKey, $yKey, $zKey){
$this->SetQuery("select e.classId from EnrollItem e, Class c
where e.acadYear='$xKey' and e.semester='$yKey' and e.classId=c.classId
and c.programId='$zKey' group by e.classId");
}
function RSEnrollItemByAcYAndSeAndPgIdIsNullGroupClId($acY, $se, $pgId){
$this->SetQuery("select e.classId from EnrollItem e, Class c, ClassOpenFor f
where e.acadYear='$acY' and e.semester='$se' and e.classId=c.classId
and c.programId is null and c.classId=f.classId and f.programId='$pgId'
group by e.classId");
}
function CountConIdIs3AndGB($StId, $AcY, $SeM){
$this->SetQuery("SELECT count(et.conditionId) as num FROM EnrollItem et, GradeConfig g WHERE et.conditionId=3 and et.grade=g.grade and g.gradePoint < 3 and et.studentId='$StId' and et.acadYear='$AcY' and et.semester='$SeM' ");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function CountConIdIsNot3AndGC($StId, $AcY, $SeM){
$this->SetQuery("SELECT count(et.conditionId) as num FROM EnrollItem et, GradeConfig g WHERE et.conditionId!=3 and et.grade=g.grade and g.gradePoint < 5 and et.studentId='$StId' and et.acadYear='$AcY' and et.semester='$SeM' ");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSEnrollItemByStIdAndAcYAndSeAndSeq($stId, $acY, $se, $seq){
$this->SetQuery("select * from EnrollItem where studentId='$stId' and acadYear='$acY' and semester='$se' and sequence='$seq'");
}
function RSEnrollItemByStIdAndAcYAndClIdAndGrInAtoF($stId, $acY, $clId){
$sql = "select count(ei.grade) as num from EnrollItem ei where ei.studentId='$stId' and ei.acadYear='$acY' and ei.classId='$clId'
and exists (select gc.grade from GradeConfig gc where gc.calGrade='Y' and gc.grade=ei.grade)";
$this->SetQuery($sql);
if ($result=$this->GetResult()) {
return $result['num'];
}
}
} //--End class EnrollItem--
?>
|