Viewing file:  printrep_addresssplitprogram.php (6.36 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include_once "../../class/clsConnection.php";
include_once "../../class/clsDB.php";
include_once "../global.php";
include_once("../class/clsPrefix.php");
include_once "../class/clsProvince.php";
include_once "../class/clsDistrict.php";
include_once "../class/clsAmphur.php";
$oPf = new Prefix($oC2);
$oDt = new District($oC2);
$oAp = new Amphur($oC2);
$oPv = new Province($oC2);
include_once "../class/clsalumnimain.php";
include_once("../class/clsprogramalumni.php");
$oAm = new AlumniMain($oC1);
$oPg_A = 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>
<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">
<?
$oPg_A->SearchByKey($programId);
$oPg_A->GetRecord();
?>
<tr>
<td align="center" colspan="2"><font size="3" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><strong>ที่อยู่ที่ติดต่อได้ของศิษย์เก่า ปีที่จบการศึกษา <? echo $finishAcadYear; ?><br>หลักสูตร<? echo $oPg_A->programalumniName;?></strong></font></td>
</tr>
<tr>
<td height="22" colspan="2" > </td>
</tr>
<tr>
<td colspan="2" align="center"><table width="740" border="1" cellspacing="0" cellpadding="1" bordercolor="<?php echo $GLOBALS["COLOR_BORDER_TABLE_1"]; ?>">
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
<td height="22" align="center" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ลำดับ</strong></font></td>
<td height="22" align="center" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ชื่อ-นามสกุล</strong></font></td>
<td height="22" align="center" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ปีที่จบการศึกษา</strong></font></td>
<td height="22" align="center" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ที่อยู่</strong></font></td>
<td height="22" align="center" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ตำบล</strong></font></td>
<td height="22" align="center" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>อำเภอ</strong></font></td>
<td height="22" align="center" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>จังหวัด</strong></font></td>
<td height="22" align="center" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>รหัสไปรษณีย์</strong></font></td>
<td height="22" align="center" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>โทรศัพท์</strong></font></td>
<td height="22" align="center" nowrap><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);
$oAm->RSAlumniMainJAlumniBioProgramIdAndFinishAcadYear($programId,$finishAcadYear);
while($oAm->GetRecord())
{
$oPf->SearchByKey($oAm->prefixId);
$oPf->GetRecord();
$oDt->districtName = '';
$oAp->amphurName = '';
$oPv->provinceName = '';
$oDt->SearchByKey($oAm->currentDistrictId);
$oDt->GetRecord();
$oAp->SearchByKey($oAm->currentAmphurId);
$oAp->GetRecord();
$oPv->SearchByKey($oAm->currentProvinceId);
$oPv->GetRecord();
?>
<tr>
<td height="22" align="center" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $i+1; ?></font></td>
<td height="22" align="left" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $oPf->prefixName.$oAm->studentName." ".$oAm->studentSurname; ?></font></td>
<td height="22" align="center" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $oAm->graduateYear;?></font></td>
<td height="22" align="left" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $oAm->currentAddress;?></font></td>
<td height="22" align="center" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $oDt->districtName;?></font></td>
<td height="22" align="center" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $oAp->amphurName;?></font></td>
<td height="22" align="center" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $oPv->provinceName;?></font></td>
<td height="22" align="center" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $oAm->currentZipcode;?></font></td>
<td height="22" align="center" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $oAm->currentPhoneNo;?></font></td>
<td height="22" align="left" nowrap><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $oAm->studentEmail;?></font></td>
</tr>
<?
$i++;
}
if($i==0)
{
?>
<tr>
<td colspan="10" align="center" height="22"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">** ไม่ปรากฏรายการในฐานข้อมูล **</font></td>
</tr>
<?
}
?>
<tr align="left">
<td height="22"> </td>
<td height="22" align="right" colspan="9"><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>
<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>
|