Viewing file:  searchalumniforconfig.php (8.73 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include_once "template.php";
showHeader();
include_once "../global.php";
include_once("../class/clsProgram.php");
include_once("../class/clsPrefix.php");
include_once("../class/clsGeneration.php");
$oPg = new Program($oC2);
$oPg2 = new Program($oC2);
$oPf = new Prefix($oC2);
$oGn = new Generation($oC2);
include_once "../class/clsalumnimain.php";
confirmSubmit();
openWindow();
$oAm = new AlumniMain($oC1);
$oAm2 = new AlumniMain($oC1);
?>
<script>
function checkFormat(){
if((document.getElementById('ch1').checked==false && document.getElementById('ch2').checked==false && document.getElementById('ch3').checked==false && document.getElementById('ch4').checked==false)){
alert("กรุณาเลือกหน่วยงานต้นสังกัด !");
return false;
}
if((document.getElementById('cha1').checked==false && document.getElementById('cha2').checked==false && document.getElementById('cha3').checked==false)){
alert("กรุณาเลือกหน่วยงานที่สังกัด !");
return false;
}
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<link href="../source/style.css" rel="stylesheet" type="text/css">
<table width="740" border="0" align="center" cellpadding="0" cellspacing="0">
<tr align="left">
<td><br><fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><a href="?mm=1">การกำหนดสิทธิ์ใช้งานระบบ
</a>
<img src="../picture/ico3.gif" align="absmiddle" border="0">กำหนดสิทธิ์ให้ศิษย์เก่า</font></legend>
<label>
<div align="center"><br>
<form name="ps" method="post" action="<?php echo $PHP_SELF;?>"><table width="700" align="center" border="0" cellpadding="0" cellspacing="1">
<tr>
<td align="center" colspan="2"><font size="3" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><strong>รายชื่อศิษย์เก่า</strong></font></td>
</tr>
<tr>
<td align="center" colspan="2"> </td>
</tr>
<?
$oPg2->SearchByKey($programId);
$oPg2->GetRecord();
?>
<tr>
<td ><table width="700" border="0" cellspacing="1" cellpadding="1" bordercolor="<?php echo $GLOBALS["COLOR_BORDER_TABLE_1"];?>" align="center">
<tr >
<td height=22 width="79"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><b>หลักสูตร</b></font></td>
<td height=22 width="10"> </td>
<td height=22 width="601">
<input type="text" name="programName" class="input1" size="40" readonly value="<? echo $oPg2->programName;?>">
<IMG src="../icons/icon_search.gif" width="19" height="16" class='box' border="0" align="absmiddle" id=IMG3 style="CURSOR: hand" onclick='OpenWindow("programTable.php",400,400)'></td>
<input type="hidden" name="programId" >
</tr>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td height=22 width="79"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><b>ชื่อรุ่น</b></font></td>
<td height=22 width="10"> </td>
<td height=22 width="601"><input type="text" name="genNo" size="10" value="<? echo $genNo; ?>">
</tr>
<tr >
<td align="left" height=22 ><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b> ปีการศึกษา</b></font></td>
<td > </td>
<td ><? echo $oAm->selectHTMLGroupadmitAcadYear("admitAcadYear",$admitAcadYear);?></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td align="left" height=22 ><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b> ชื่อ</b></font></td>
<td > </td>
<td ><input type="text" name="fName" size="30" value="<? echo $fName; ?>"> <font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b>นามสกุล</b></font>
<input type="text" name="lName" size="30" <? echo $lName; ?>></td>
</tr>
<tr >
<td align="center" colspan="3"> </td>
</tr>
<tr >
<td align="center" colspan="3"><input type="submit" name="add" value="ตกลง" onClick="return checkFormat()"><input type="button" name="clear" value="ลบข้อมูล" onClick="location.href = 'reportrateperson.php?poskindId=&partyName=&status='"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="22" colspan="2" > </td>
</tr>
<tr>
<td height="22" colspan="2" > </td>
</tr>
<tr>
<td colspan="2" align="center"><table width="700" border="1" cellspacing="0" cellpadding="1" bordercolor="<?php echo $GLOBALS["COLOR_BORDER_TABLE_1"]; ?>">
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_1"];?>">
<td colspan="5" align="center" height="22"><font size="3" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>รายชื่อศิษย์เก่า</strong></font></td>
</tr>
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
<td width="95" height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ลำดับ</strong></font></td>
<td width="158" height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ชื่อ-นามสกุล</strong></font></td>
<td width="164" height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>หลักสูตร</strong></font></td>
<td width="265" height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>สิทธิ์</strong></font></td>
</tr>
<?
$i=0;
$oGn->SearchByGenNo($genNo);
$oGn->GetRecord();
// echo ">>".$genNo.">>".$oGn->genId;
$oAm2->RSAlumniMainadmitAcadYearAndprogramIdAndstudentStatusAndstudentName($admitAcadYear,$programId,4,$fName,$lName,$oGn->genId);
while($oAm2->GetRecord())
{
$oPf->SearchByKey($oAm2->prefixId);
$oPf->GetRecord();
$oPg->SearchByKey($oAm2->programId);
$oPg->GetRecord();
if($oAm2->glantId == 'N')
$pm = "ไม่มีสิทธิ์";
else if($oAm2->glantId == 'R')
$pm = "รอการตรวจสอบ";
else if($oAm2->glantId == 'Y')
$pm = "มีสิทธิ์";
if(($i%2) == 0)
echo "<tr>";
else
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TABLE_3"]."\">";
?>
<td height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $i+1; ?></font></td>
<td height="22" align="left"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $oPf->prefixName.$oAm2->studentName." ".$oAm2->studentSurname; ?></font></td>
<td height="22" align="left"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $oPg->programName;?></font></td>
<td height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">
<input name="glantId.<? echo $oAm2->alumniId?>" type="radio" value="Y" <? if($oAm2->glantId == 'Y') { ?>checked<? } ?>>มีสิทธิ์
<input name="glantId.<? echo $oAm2->alumniId?>" type="radio" value="N" <? if($oAm2->glantId == 'N') { ?>checked<? } ?>>ไม่มีสิทธิ์
<input name="glantId.<? echo $oAm2->alumniId?>" type="radio" value="R" <? if($oAm2->glantId == 'R') { ?>checked<? } ?>>รอการยืนยันสิทธิ์
</font></td>
</tr>
<?
$i++;
}
if($i==0)
{
?>
<tr>
<td colspan="5" align="center" height="22"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">** ไม่ปรากฏรายการในฐานข้อมูล **</font></td>
</tr>
<?
}
?>
<tr align="left">
<td height="22"><input type="button" name="back" value="กลับเมนูหลัก" onClick="location.href='menuperson.php?mm=1' "></td>
<td height="22" align="right" colspan="4"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>">รวม <?php echo $i;?>
รายการ</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" align="center"></td>
</tr>
</table>
</form>
</div>
</fieldset>
<font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>" size="2" face="MS Sans Serif"><br>
</font>
<br>
</label>
<br><br><br><br>
</td>
</tr>
</table>
<?php
$oC ->Disconnect();
showFooter();
?>
<script language="JavaScript" type="text/JavaScript">
function checkout() {
if(document.ps.out.checked) {
document.ps.partyType.disabled = false;
}else{
document.ps.partyType.disabled = true;
}
}
</script>
|