Viewing file:  searchalumniforQn.php (5.81 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include_once "template.php";
showHeader();
include_once("../class/clsPrefix.php");
include_once("../class/clsGeneration.php");
$oPf = new Prefix($oC2);
$oGn = new Generation($oC2);
include_once "../class/clsalumnimain.php";
include_once("../class/clsprogramalumni.php");
confirmSubmit();
openWindow();
$oAm = new AlumniMain($oC1);
$oAm2 = new AlumniMain($oC1);
$oPg_A = new Programalumni($oC1);
$oPg_A2 = new Programalumni($oC1);
?>
<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>
<?
if($admitAcadYear == "")
$admitAcadYear = getNowDateTh2()-1;
//$admitAcadYear = 2551;
?>
<tr>
<td ><table width="700" border="0" cellspacing="1" cellpadding="1" bordercolor="<?php echo $GLOBALS["COLOR_BORDER_TABLE_1"];?>" align="center">
<tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<td colspan="3"height=22 align="center" ><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><b> ชื่อ - สกุล</b>
<input type="text" name="Name" size="30" value="<? echo $Name; ?>">
</font></td>
</tr>
<tr >
<td align="center" colspan="3"> </td>
</tr>
<tr >
<td align="center" colspan="3"><input type="submit" name="add" value="ค้นหา" >
<input type="reset" name="clear" value="ลบข้อมูล"></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="101" height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ลำดับ</strong></font></td>
<td width="200" height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ชื่อ-นามสกุล</strong></font></td>
<td width="305" height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>หลักสูตร</strong></font></td>
<td width="120" height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ปีที่จบการศึกษา</strong></font></td>
</tr>
<?
$i=0;
//$oAm2->RSAlumniMainadmitAcadYearAndprogramIdAndstudentStatusAndstudentName($admitAcadYear,$programalumniId,4,$fName,$lName,$oGn->genId);
$oAm2->RSAlumniMainstudentName($Name);
while($oAm2->GetRecord())
{
$oPf->SearchByKey($oAm2->prefixId);
$oPf->GetRecord();
$oPg_A->SearchByKey($oAm2->programId);
$oPg_A->GetRecord();
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"];?>"><a href="alumniQn.php?alumniId=<?php echo $oAm2->alumniId;?>"><? echo $oPf->prefixName.$oAm2->studentName." ".$oAm2->studentSurname; ?></a></font></td>
<td height="22" align="left"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $oPg_A->programalumniName;?></font></td>
<td height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $oAm2->graduateYear;?></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='?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
showFooter();
?>
|