
<?php

include_once "../class/clsStudentMaster.php";

include_once "../class/clsProgram.php";



$conn = new Connection();



$oSm = new StudentMaster();

$oPg = new Program();

?>

<html>

<head>

<title>ตารางหลักสูตรและปีที่รับเข้า</title>

<meta http-equiv="Content-Type" content="text/html; charset=tis-620">

<link href="./source/style.css" rel="stylesheet" type="text/css">

<style>

<!--

A:link {text-decoration: none }

A:visited {text-decoration: none}

A:hover {text-decoration: none; font-weight: underline}

-->

</style>



<!---------------------------------------Begin JavaScript---------------------------------------->

<script language="JavaScript">

    function ReturnValue(programId,programName,admitAcadYear,admitSemester,studentYear)

    {

        window.opener.document.pc.programId.value = programId;

        window.opener.document.pc.programName.value = programName;

        window.opener.document.pc.admitAcadYear.value = admitAcadYear;

        window.opener.document.pc.admitSemester.value = admitSemester;

        window.opener.document.pc.studentYear.value = studentYear;

        window.close();

    }

</script>

</head>



<body bgcolor="#FFFFFF">

<table width="100%" border="0" cellspacing="1" cellpadding="1" bgcolor="silver">

    <tr bgcolor="#0066CC"> 

        <td width="12%" align="center"><font face="MS Sans Serif" size="2" color="#FFFFFF"><b>ลำดับที่</b></font></td>

        <td width="88%" align="center"><font face="MS Sans Serif" size="2" color="#FFFFFF"><b>หลักสูตร</b></font></td>

    </tr>

<?php

    $oSm->RSStudentMasterByGSGroupPgIdAndAdY('Y');

    $numRow = $oSm->NumRow();

    $page_size = 10;

    $total_page = (int)($numRow/$page_size);

    if(($numRow%$page_size) != 0)

        $total_page++;



    if(isset($page_id))

        $start = $page_size*($page_id-1);

    else {

        $page_id = 1;

        $start = 0;

    }



    $i = 0;

    $oSm->RSStudentMasterByGSGroupPgIdAndAdYLimit('Y', $start, $page_size);

    while($oSm->GetRecord()) {

        $oPg->SearchByKey($oSm->programId);

        $oPg->GetRecord();

?>

    <tr> 

        <td align="center" bgcolor="#FFFFFF"><font size="2" style="CURSOR: hand" onClick='ReturnValue("<?php echo $oSm->programId;?>","<?php echo $oPg->programName;?>","<?php echo $oSm->admitAcadYear;?>","<?php echo $oSm->admitSemester;?>","<?php echo $oSm->studentYear;?>")'><?php echo $start+$i+1;?></font></td>

        <td bgcolor="#FFFFFF"><font size="2" style="CURSOR: hand" onClick='ReturnValue("<?php echo $oSm->programId;?>","<?php echo $oPg->programName;?>","<?php echo $oSm->admitAcadYear;?>","<?php echo $oSm->admitSemester;?>","<?php echo $oSm->studentYear;?>")'><?php echo $oPg->programName.' (ปีการศึกษา '.$oSm->admitAcadYear.')';?></font></td>

    </tr>

<?php    

        $i++;

    }

    $oPg->Destroy();

    $oSm->Destroy();

    $conn->Disconnect();

    

    if($i == 0) {

?>

    <tr>

        <td colspan="2" align="center" bgcolor="#FFFFFF"><font size="2" color="#FF0000">** ไม่ปรากฏรายการดังกล่าวในฐานข้อมูล **</font></td>

    </tr>

<?php

    }

?>

</table>

<table width="100%" border="0" cellspacing="1" cellpadding="1" bgcolor="silver">

    <tr>

        <td><font size="2" face="MS Sans Serif" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">หน้า-&gt;

<?php

        for ($num=1; $num<=$total_page; $num++) {    

            if($num == $page_id)

                echo $num." ";

            else {

?>

                <a href="pgAndAdYAndSeAndStYAndGSIsYTable.php?page_id=<?php echo $num;?>"><?php echo '[ '.$num.' ]';?></a> 

<?php

            }

        }

?>

        </font></td>

        <td align="right"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>">รวม <?php echo $numRow;?> รายการ</font></td>

    </tr>

</body>

</html>