<?php
//--Class StudentMaster--------------------------

include_once "clsbase_StudentMaster.php";

class StudentMaster extends base_StudentMaster{

// This function use on page calGradeProg.php
function RSStudentMasterGetProgId($xKey){
	$this->SetQuery("select studentCode from StudentMaster where studentId='$xKey' ");
}
//-- The end --

// This function use on page processGenTotalPoint.php
function RSStudentMasterGenTotalPoint(){
	$this->SetQuery("select * from StudentMaster where studentCode!='' and studentStatus='1' and totalPoint!=100 ");
}

function RSStudentMasterCountStudGenTP(){
	$this->SetQuery("select count(studentId) as num from StudentMaster where studentCode!='' and studentStatus='1' and totalPoint!=100 ");
	$result=$this->GetResult();
	return $result['num'];
}
//-- The end --

// This function on file studentTable.php
function RSStudentMasterLimit($start, $pageSize){
	$this->SetQuery("select * from StudentMaster where studentCode!='' and studentStatus='1' limit $start, $pageSize");
}

function RSStudentMasterLimitByStudCode($sKey, $start, $pageSize){
	$this->SetQuery("select * from StudentMaster where studentCode LIKE '%$sKey%' and studentStatus='1' Limit $start, $pageSize");
}

function RSStudentMasterByStudCode(){
	$this->SetQuery("select * from StudentMaster where studentCode!='' and studentStatus='1' order by studentId");
}

function RSStudentMasterCountStudByOffIdStudIdND($aKey, $bKey){
	$this->SetQuery("select count(studentId) as num from StudentMaster where studentId='$aKey' and programId='$bKey' and officerId1!='NULL' and studentStatus='1' ");
	$result=$this->GetResult();
	return $result['num'];
}
/**  The End  **/

/*function RSStudentMasterByPgIdGroupAdY($xKey){
	$this->SetQuery("select * from StudentMaster where programId= '$xKey' group by admitAcadYear");
}*/

function RSStudentMasterByPgIdGroupAdY($xKey){
	$sql="select admitAcadYear, max(studentYear) as studentYear
			from StudentMaster 
			where programId='$xKey' and genStatus='Y' group by admitAcadYear";
	$this->SetQuery($sql);
}

function RSStudentMasterByPgIdAndAdY($xKey, $yKey){
	$this->SetQuery("select * from StudentMaster where programId='$xKey' and admitAcadYear='$yKey' order by studentCode");
}

function RSStudentMasterByPgIdAndStYAndAdY($xKey, $yKey, $zKey){
	//$programId, $studentYear, $admitAcadYear
	$sql="select * 
			from StudentMaster 
			where programId='$xKey' and studentYear='$yKey' and admitAcadYear='$zKey' order by studentCode";
	$this->SetQuery($sql);
}

function RSStudentMasterByPgIdAndAdYLimit($xKey, $yKey, $start, $pageSize){
	$this->SetQuery("select * from StudentMaster where programId='$xKey' and admitAcadYear='$yKey' limit $start, $pageSize");
}

function GetNextCodeByPgIdAndAdY($xKey, $yKey){
	$this->SetQuery("select max(studentCode) as num from StudentMaster where programId='$xKey' and admitAcadYear='$yKey'");
	if ($result=$this->GetResult()) {
		return $result['num']+1;
	}
}

function RSStudentMasterByPgIdAndAdYGS($xKey, $yKey){
	$this->SetQuery("select * from StudentMaster where programId='$xKey' and admitAcadYear='$yKey' and genStatus='Y'");
}

function RSStudentMasterByGSGroupPgIdAndAdY($xKey){
	$this->SetQuery("select programId, admitAcadYear from StudentMaster where genStatus='$xKey' group by programId, admitAcadYear");
}

function RSStudentMasterByGSGroupPgIdAndAdYLimit($xKey, $start, $pageSize){
	$this->SetQuery("select programId, admitAcadYear from StudentMaster where genStatus='$xKey' group by programId, admitAcadYear limit $start, $pageSize");
}

function RSStudentMasterByPgIdAndAdYOrderStNm($xKey, $yKey){
	$this->SetQuery("select * from StudentMaster where programId='$xKey' and admitAcadYear='$yKey' order by studentName");
}

function RSStudentMasterByPgIdAndGeId($xKey, $yKey){
	$this->SetQuery("select * from StudentMaster where programId= '$xKey' and generationId= '$yKey' order by studentId");
}

function RSStudentMasterByPgIdAndStY($xKey, $yKey){
	// รหัสหลักสูตร, ปีที่เข้า
	$sql="select * 
			from StudentMaster 
			where programId='$xKey' and studentYear='$yKey' group by admitAcadYear";
	$this->SetQuery($sql);
}

function RSStudentMasterByPgIdAndAdYAndExpectGD($xKey, $yKey){
	$this->SetQuery("select * from StudentMaster where programId= '$xKey' and admitAcadYear='$yKey' and studentStatus='3' and finishDate=0000-00-00 and graduateYear='0'");
}

function RSStudentMasterByPgIdAndAdYAndExpectGDAndGD($xKey, $yKey){
	$this->SetQuery("select * from StudentMaster where programId= '$xKey' and admitAcadYear='$yKey' and ((studentStatus='3'and finishDate=0000-00-00 and graduateYear='0') or studentStatus='4')");
}

function RSStudentMasterByPgIdAndAdYAndGD($xKey, $yKey){
	$this->SetQuery("select * from StudentMaster where programId= '$xKey' and admitAcadYear='$yKey' and studentStatus='4' and finishDate<>0000-00-00 and graduateYear<>'0'");
}

function RSStudentMasterByPgIdAndAdYAndStYAndStudying($xKey, $yKey, $zKey){
	$this->SetQuery("select * from StudentMaster where programId= '$xKey' and admitAcadYear='$yKey' and studentYear='$zKey' and studentStatus='1' and finishDate=0000-00-00 and graduateYear='0'");
}

function RSStudentMasterByPgIdAndAdYOrderGPATtPt($xKey, $yKey){
	$this->SetQuery("select * from StudentMaster where programId='$xKey' and admitAcadYear='$yKey' order by GPA desc, totalPoint desc");
}

function RSStudentMasterGroupGdY(){
	$this->SetQuery("select graduateYear from StudentMaster group by graduateYear");
}

function RSStudentMasterByPgIdAndFinishDateAndGdY($wKey, $xKey, $yKey, $zKey){
	$this->SetQuery("select * from StudentMaster where programId='$wKey' and finishDate>='$xKey' and finishDate<='$yKey' and graduateYear='$zKey'");
}

// Get by ProgramId
function RSStudentMasterByPgId($xKey){
	$this->SetQuery("select * from StudentMaster where programId= '$xKey' order by studentId");
}

function RSStudentMasterByPgIdOrderByStdNameAndStdStatus($xKey){
	$this->SetQuery("select * from StudentMaster where programId= '$xKey' and studentStatus != 6 order by studentName");
}

function RSStudentMasterByPgIdGroupByStYAndStdStatus($xKey){
	$this->SetQuery("select * from StudentMaster where programId= '$xKey' and studentStatus != 6 group by studentYear");
}

function RSStudentMasterByPgIdOrderByStdName($xKey){
	$this->SetQuery("select * from StudentMaster where programId= '$xKey' order by studentName");
}

function RSCountStudentMaster($xKey, $yKey){
	$this->SetQuery("select count(studentId) as countStudent from StudentMaster where programId='$xKey' and studentYear='$yKey' group by programId, studentYear");
	$result=$this->GetResult();
	return $result['countStudent'];
}

function RSCountStudentSexM($xKey, $yKey){
	$this->SetQuery("select count(studentSex) as countStudentSexM from StudentMaster where programId='$xKey' and studentSex='M' and studentYear='$yKey' group by programId, studentYear ");
	$result=$this->GetResult();
	return $result['countStudentSexM'];
}

function RSCountStudentSexF($xKey, $yKey){
	$this->SetQuery("select count(studentSex) as countStudentSexF from StudentMaster where programId='$xKey' and studentSex='F' and studentYear='$yKey' group by programId, studentYear");
	$result=$this->GetResult();
	return $result['countStudentSexF'];
}

//Count EntryType
function RSCountEntryType1($xKey, $yKey){
	$this->SetQuery("select count(entryTypeId) as countEntryType1 from StudentMaster where programId='$xKey' and entryTypeId='1' and studentYear='$yKey' group by programId, studentYear");
	$result=$this->GetResult();
	return $result['countEntryType1'];
}
function RSCountEntryType2($xKey, $yKey){
	$this->SetQuery("select count(entryTypeId) as countEntryType2 from StudentMaster where programId='$xKey' and entryTypeId='2' and studentYear='$yKey' group by programId, studentYear");
	$result=$this->GetResult();
	return $result['countEntryType2'];
}
function RSCountEntryType3($xKey, $yKey){
	$this->SetQuery("select count(entryTypeId) as countEntryType3 from StudentMaster where programId='$xKey' and entryTypeId='3' and studentYear='$yKey' group by programId, studentYear");
	$result=$this->GetResult();
	return $result['countEntryType3'];
}
function RSCountEntryType4($xKey, $yKey){
	$this->SetQuery("select count(entryTypeId) as countEntryType4 from StudentMaster where programId='$xKey' and entryTypeId='4' and studentYear='$yKey' group by programId, studentYear");
	$result=$this->GetResult();
	return $result['countEntryType4'];
}
function RSCountEntryType5($xKey, $yKey){
	$this->SetQuery("select count(entryTypeId) as countEntryType5 from StudentMaster where programId='$xKey' and entryTypeId='5' and studentYear='$yKey' group by programId, studentYear");
	$result=$this->GetResult();
	return $result['countEntryType5'];
}
function RSCountEntryType6($xKey, $yKey){
	$this->SetQuery("select count(entryTypeId) as countEntryType6 from StudentMaster where programId='$xKey' and entryTypeId='6' and studentYear='$yKey' group by programId, studentYear");
	$result=$this->GetResult();
	return $result['countEntryType6'];
}
// Get num student by programId and studentYear=1
function RSCountStudentSexM11($xKey){
	$this->SetQuery("select count(studentId) as countStudentSexM1 from StudentMaster where programId='$xKey' and studentSex='M' and entryTypeId='1' and studentYear='1' ");
	$result=$this->GetResult();
	return $result['countStudentSexM1'];
}

function RSCountStudentSexM21($xKey){
	$this->SetQuery("select count(studentId) as countStudentSexM2 from StudentMaster where programId='$xKey' and studentSex='M' and entryTypeId != '1' and studentYear='1' ");
	$result=$this->GetResult();
	return $result['countStudentSexM2'];
}

function RSCountStudentSexF11($xKey){
	$this->SetQuery("select count(studentId) as countStudentSexF1 from StudentMaster where programId='$xKey' and studentSex='F' and entryTypeId='1' and studentYear='1' ");
	$result=$this->GetResult();
	return $result['countStudentSexF1'];
}

function RSCountStudentSexF21($xKey){
	$this->SetQuery("select count(studentId) as countStudentSexF2 from StudentMaster where programId='$xKey' and studentSex='F' and entryTypeId != '1' and studentYear='1' ");
	$result=$this->GetResult();
	return $result['countStudentSexF2'];
}
//-----------------------------------------------

// Get num student by programId and studentYear=2
function RSCountStudentSexM12($xKey){
	$this->SetQuery("select count(studentId) as countStudentSexM1 from StudentMaster where programId='$xKey' and studentSex='M' and entryTypeId='1' and studentYear='2' ");
	$result=$this->GetResult();
	return $result['countStudentSexM1'];
}

function RSCountStudentSexM22($xKey){
	$this->SetQuery("select count(studentId) as countStudentSexM2 from StudentMaster where programId='$xKey' and studentSex='M' and entryTypeId != '1' and studentYear='2' ");
	$result=$this->GetResult();
	return $result['countStudentSexM2'];
}

function RSCountStudentSexF12($xKey){
	$this->SetQuery("select count(studentId) as countStudentSexF1 from StudentMaster where programId='$xKey' and studentSex='F' and entryTypeId='1' and studentYear='2' ");
	$result=$this->GetResult();
	return $result['countStudentSexF1'];
}

function RSCountStudentSexF22($xKey){
	$this->SetQuery("select count(studentId) as countStudentSexF2 from StudentMaster where programId='$xKey' and studentSex='F' and entryTypeId != '1' and studentYear='2' ");
	$result=$this->GetResult();
	return $result['countStudentSexF2'];
}
//-----------------------------------------------

// Get num student by programId and studentYear=3
function RSCountStudentSexM13($xKey){
	$this->SetQuery("select count(studentId) as countStudentSexM1 from StudentMaster where programId='$xKey' and studentSex='M' and entryTypeId='1' and studentYear='3' ");
	$result=$this->GetResult();
	return $result['countStudentSexM1'];
}

function RSCountStudentSexM23($xKey){
	$this->SetQuery("select count(studentId) as countStudentSexM2 from StudentMaster where programId='$xKey' and studentSex='M' and entryTypeId != '1' and studentYear='3' ");
	$result=$this->GetResult();
	return $result['countStudentSexM2'];
}

function RSCountStudentSexF13($xKey){
	$this->SetQuery("select count(studentId) as countStudentSexF1 from StudentMaster where programId='$xKey' and studentSex='F' and entryTypeId='1' and studentYear='3' ");
	$result=$this->GetResult();
	return $result['countStudentSexF1'];
}

function RSCountStudentSexF23($xKey){
	$this->SetQuery("select count(studentId) as countStudentSexF2 from StudentMaster where programId='$xKey' and studentSex='F' and entryTypeId != '1' and studentYear='3' ");
	$result=$this->GetResult();
	return $result['countStudentSexF2'];
}
//-----------------------------------------------

// Get num student by programId and studentYear=4
function RSCountStudentSexM14($xKey){
	$this->SetQuery("select count(studentId) as countStudentSexM1 from StudentMaster where programId='$xKey' and studentSex='M' and entryTypeId='1' and studentYear='4' ");
	$result=$this->GetResult();
	return $result['countStudentSexM1'];
}

function RSCountStudentSexM24($xKey){
	$this->SetQuery("select count(studentId) as countStudentSexM2 from StudentMaster where programId='$xKey' and studentSex='M' and entryTypeId != '1' and studentYear='4' ");
	$result=$this->GetResult();
	return $result['countStudentSexM2'];
}

function RSCountStudentSexF14($xKey){
	$this->SetQuery("select count(studentId) as countStudentSexF1 from StudentMaster where programId='$xKey' and studentSex='F' and entryTypeId='1' and studentYear='4' ");
	$result=$this->GetResult();
	return $result['countStudentSexF1'];
}

function RSCountStudentSexF24($xKey){
	$this->SetQuery("select count(studentId) as countStudentSexF2 from StudentMaster where programId='$xKey' and studentSex='F' and entryTypeId != '1' and studentYear='4' ");
	$result=$this->GetResult();
	return $result['countStudentSexF2'];
}
//-----------------------------------------------

// Get by ProgramId Limit
function RSStudentMasterByPgIdLimit($xKey, $start, $pageSize){
	$this->SetQuery("select * from StudentMaster where programId= '$xKey' order by studentId limit $start, $pageSize");
}

function RSStudentMasterByPgIdAndGeIdOrderStCd($xKey, $yKey){
	$this->SetQuery("select * from StudentMaster where programId= '$xKey' and generationId= '$yKey' order by studentCode");
}

function RSStudentMasterByPgIdAndGeIdOrderStNm($xKey, $yKey){
	$this->SetQuery("select * from StudentMaster where programId= '$xKey' and generationId= '$yKey' order by studentName");
}

function RSStudentMasterByStCdAndNmAndSm($xKey, $yKey, $zKey){
	$this->SetQuery("select * from StudentMaster where studentCode like '$xKey%' and studentName like '$yKey%' and studentSurname like '$zKey%' order by studentCode");
}

// Get num of officerId1 and officerId2 use on page addOfficerMeeting.php
function RSStudentMasterByOffId1($aKey){
	$this->SetQuery("select count(studentId) as num from StudentMaster where officerId1='$aKey' and studentStatus='1' order by studentId");
	$result=$this->GetResult();
	return $result['num'];
}

// Get by OfficerId1 Limit use on page addOfficerMeeting.php
function RSStudentMasterByOfIdAndDateLimit($xKey, $start, $pageSize){
	$this->SetQuery("select * from StudentMaster where officerId1='$xKey' and studentStatus='1' order by studentId limit $start, $pageSize");
}
//-- The End --

// Get num student by programId and studentYear and nowDate use on page addClass.php and processClass.php
function RSStudentMasterCountStudByPgIdStudYearNowDate($aKey, $bKey){
	$this->SetQuery("select count(studentId) as num from StudentMaster where studentCode!='' and programId='$aKey' and studentYear='$bKey' and studentStatus='1' order by studentId");
	$result=$this->GetResult();
	return $result['num'];
}
//-- The End --

// Get num of officerId2 use on page showOfficerClass.php and addOfficerClass.php
function RSStudentMasterCountStud($aKey, $bKey){
	$this->SetQuery("select count(officerId2) as num from StudentMaster where officerId2!=0 and programId='$aKey' and studentYear='$bKey' and studentStatus='1' group by officerId2");
	$result=$this->GetResult();
	return $result['num'];
}

function RSStudentMasterByPgIdStudYearAndND($aKey, $bKey){
	$this->SetQuery("select officerId2 from StudentMaster where officerId2!=0 and programId='$aKey' and studentYear='$bKey' and studentStatus='1' group by officerId2");
}

function Edit2($aKey,$bKey,$cKey){
	$sql = "update StudentMaster set officerId2='$aKey' where programId='$bKey' and studentYear='$cKey' and studentStatus='1' ";
	$this->SetQuery($sql);
}
//--The end --

// Get student by programId StudentYear and nowDate use on page editStudentUpStatusProg.php
function RSStudentMasterByPgIdSySsNd($aKey,$bKey){
	$this->SetQuery("select * from StudentMaster where studentCode!='' and programId='$aKey' and studentYear='$bKey' and studentStatus='1' order by studentId");
}
//-- The End --

// Use on page addResultExamOcc.php
function RSStudentMasterByPgIdAndGdY($xKey, $yKey){
	$this->SetQuery("select * from StudentMaster where programId='$xKey' and graduateYear='$yKey' and studentStatus='4'");
}
//-- The end --

// Use on page addDebt.php
function SearchByStCodeAndStudying($xKey){
	/*$sql="select * from StudentMaster where studentCode='$xKey' and studentStatus='1'";
	die($sql);*/
	if ($this->SetQuery("select * from StudentMaster where studentCode='$xKey' and studentStatus='1'")){
		return 1;
	}else {
		return 0;
	}
}
//-- The end --

function SearchByStCodeAndStudyingAndTransferSt($xKey){
	if ($this->SetQuery("select * from StudentMaster where studentCode='$xKey' and studentStatus='1' and entryTypeId2='2'")){
		return 1;
	}else {
		return 0;
	}
}

function SearchByStCode($xKey){
	if ($this->SetQuery("select * from StudentMaster where studentCode='$xKey'")){
		return 1;
	}else {
		return 0;
	}
}

function RSStudentMasterByPgIdAndStuY($PgId,$StuY)
{
	if($this->SetQuery("Select * From StudentMaster Where programId='$PgId' And studentYear='$StuY' Order By studentCode"))
	{
		return 1;
	} else
		{
			return 0;
		}
}

//-- Use on page processChgStudYProg.php --
function SearchByStudID($StID){
	$this->SetQuery("select * from StudentMaster where studentId= '$StID'");
}

function CountGPANoZero($PgID, $AmaY){
	$this->SetQuery("select count(studentId) as num from StudentMaster where programId= '$PgID' and admitAcadYear='$AmaY' and GPA!=0 and creditAttempt!=0 and creditSatisfy!=0  order by studentCode");
	$result=$this->GetResult();
	return $result['num'];	
}

function RSStudentMasterGroupAdY(){
	$this->SetQuery("select admitAcadYear from StudentMaster group by admitAcadYear");
}

function RSStudentMasterGroupGenNo($PgId, $AmAcY){
	$this->SetQuery("select genNo from StudentMaster where programId='$PgId' and admitAcadYear='$AmAcY' group by genNo");
}

function sumOverYearProgram($PgID, $StID){
	include_once "../link/function.php";
	include_once "clsAcadYearConfig.php";
	include_once "clsProgram.php";
	$oPg = new Program();
	$oAy = new AcadYearConfig();
	// Get date
	$oAy->RSAcadYearConfigByDate(getNowDateTh());
	$oAy->GetRecord();	
	
	$this->SearchByStudID($StID);
	$this->GetRecord();	
	
	$overYear=$oAy->acadYear - $this->admitAcadYear;
	
	$oPg->SearchByKey($PgID);
	$oPg->GetRecord();

	if($oPg->studyYearMax < $overYear){
		// เรียนเกินไปแล้ว
		return 1;
	}else{
		// เรียนพอดีแล้ว
		return 0;
	}
}
//-- The end --

// Use on page addResultExitExam.php
function RSStudentBioByStudIdNonEx($StID){
	$this->SetQuery("select count(exitExam) as num from StudentMaster where studentId='$StID' and exitExam='N' ");
	if ($result=$this->GetResult()) {
		return $result['num'];
	}	
}
//-- The End --

function CheckCredit($stId, &$msg){
	include_once "clsStudentMaster.php";
	include_once "clsProgramStructure.php";
	include_once "clsEnrollItem.php";
	
	$obj1 = new StudentMaster();
	$obj2 = new ProgramStructure();
	$obj3 = new ProgramStructure();
	$obj4 = new EnrollItem();
	
	$obj1->SearchByKey($stId);
	$obj1->GetRecord();
	
	$flag = 1;
	// Find conditionId1
	$obj2->RSProgramStructureByPgIdAndCdId2IsH($obj1->programId);
	while($obj2->GetRecord()) {
		// Find conditionId2
		$obj3->RSProgramStructureByPgIdAndCd1($obj1->programId, $obj2->conditionId1);
		while($obj3->GetRecord()) {
			// Check credit of conditionId2
			$sumCrAtCdId2 = $obj4->GetSumCrAtByStIdAndCdIdAndCdId2($stId, $obj2->conditionId1, $obj3->conditionId2);
			if($sumCrAtCdId2 >= $obj3->creditTotal)
				$msg[$obj3->conditionId2] = intval($sumCrAtCdId2).':PASS';
			else {
				$msg[$obj3->conditionId2] = intval($sumCrAtCdId2).':FAIL';
				$flag = 0;
			}
		}
		
		// Check credit of conditionId1
		$sumCrAtCdId = $obj4->GetSumCrAtByStIdAndCdId($stId, $obj2->conditionId1);
		if($sumCrAtCdId >= $obj2->creditTotal)
			$msg[$obj2->conditionId1] = intval($sumCrAtCdId).':PASS';
		else {
			$msg[$obj2->conditionId1] = intval($sumCrAtCdId).':FAIL';
			$flag = 0;
		}
	}
	
	return $flag;
}

//-- Use on page searchStudReStatus.php --
function SearchByStCodeAndStudyingReStatus($StCode){
	$this->SetQuery("select * from StudentMaster where studentCode='$StCode' and (studentStatus='2' or studentStatus='7' or studentStatus='8' or studentStatus='9')");	
}
//-- The end --

//-- Use on page printRepRis128.php--
function RSStudentMasterByPgIdAndLvId($programId,$levelId){
	$this->SetQuery("select * from StudentMaster where programId='$programId' and levelId='$levelId' and studentStatus=1 ");	
}
//-- The end --

//-- Use on page beforeShowClassStudy.php --
function SearchByStCodeStNStSn($StC,$StN,$StSn){
	$this->SetQuery("select * from StudentMaster where studentCode='$StC' or studentName='$StN' or studentSurname='$StSn' ");
}
//-- The end --

//-- Use on page showStudentMB.php--
function RSStudentMasterByPgIdAndStY2($xKey, $yKey){
	$this->SetQuery("select * from StudentMaster where programId='$xKey' and studentYear='$yKey' order by studentCode");
}
//-- The end --

} //--End class StudentMaster--
?>