Viewing file:  v_rptRis116.php (4.78 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<style>
td
{ white-space: nowrap; margin: 0; }
</style>
<table align="center">
<tr><td colspan="3" align="left">
<input type="button" value="กลับ" onClick="location.href='<?php echo "searchRptRis116";?>'">
<!-- <input type="button" value="กลับ" onclick="history.back()"/> -->
</td></tr>
<tr><td colspan="3" align="left"><hr/></td></tr>
<tr>
<td><img src="<?=base_url().$this->config->item('rg_upload_picture').$cfgClgLogo;?>" width="111" height="95" align="absmiddle" border="0"></td>
<td><font size="2"><b><?=$cfgClgName;?><br><?=$cfgSiteName;?></b></font></td>
<td align="right" valign="top"><font size="2"><b>RIS116</b></font></td>
</tr>
<tr valign="top">
<td align="center" colspan="3"><hr color="#000000" noshade><br></td>
</tr>
<tr>
<td colspan="3" height="22" align="center"><font size="3" ><b>ตารางสอนรวมประจำภาคการศึกษา</b></font></td>
</tr>
<tr>
<td colspan="3" height="22" align="center"><font size="2" ><b>ภาคการศึกษาที่</b> <?php echo $tmId; ?>
<b>ปีการศึกษา</b> <?php echo $acY;?></font></td>
</tr>
<tr>
<td colspan="3" height="22" align="center"><font size="2" ><b>วันเปิด-ปิดภาคการศึกษา</b> <? if($qu_sd->num_rows()) { $row = $qu_sd->row(); echo abbreDate(splitDateDb2($row->sdSDate)).' - '.abbreDate(splitDateDb2($row->sdEDate)); }?></font></td>
</tr>
<tr>
<td colspan="3" height="22" align="center"><font size="2" ><b>วันสอบกลางภาค</b> <? if($qu_sd->num_rows()) { $row = $qu_sd->row(); echo abbreDate(splitDateDb2($row->sdMidExamSDate)).' - '.abbreDate(splitDateDb2($row->sdMidExamEDate)); }?></font></td>
</tr>
<tr>
<td colspan="3" height="22" align="center"><font size="2" ><b>วันสอบปลายภาค</b> <? if($qu_sd->num_rows()) { $row = $qu_sd->row(); echo abbreDate(splitDateDb2($row->sdFinalExamSDate)).' - '.abbreDate(splitDateDb2($row->sdFinalExamEDate)); }?></font></td>
</tr>
<tr>
<td colspan="3" height="22"></td>
</tr>
<tr>
<td colspan="3"><table border="1" cellspacing="0" cellpadding="0" bordercolor="#000000" style="border-collapse: collapse" align="center">
<tr>
<td height="22" align="center"><font size="2" ><b>วัน</b></font></td>
<td align="center"><font size="2" ><b>หลักสูตร</b></font></td>
<td align="center"><font size="2" ><b>ชั้นปี</b></font></td>
<?php
if($rs_prd->num_rows()) {
foreach($rs_prd->result() as $row) {
?>
<td align="center"><font size="2"><b><?php echo substr($row->prdFrTime, 0, 5).' - '.substr($row->prdToTime, 0, 5);?></b></font></td>
<?php
}
}
if($rs_dy->num_rows()) {
foreach($rs_dy->result() as $row) {
$rs_co = $co->qryCurIdJOINTtCof($acY,$tmId,$row->dyId);
$i = 0;
foreach ($rs_co->result() as $row_co) {
$j = 0;
$rs_co2 = $co->qrySyIdJOINTtCofCurSy($row_co->coCurId, $acY, $tmId, $row->dyId);
foreach ($rs_co2->result() as $row_co2) {
?>
<tr>
<?php
if($i == 0) {
?>
<td rowspan="<?php echo $rs_co->num_rows()*$rs_co2->num_rows();?>" height="22" align="center"><font size="2" ><?php echo $row->dyName;?></font></td>
<?php
}
if($j == 0) {
?>
<td rowspan="<?php echo $rs_co2->num_rows();?>"><font size="2" ><?php echo $row_co->curName;?></font></td>
<?php
}
?>
<td><font size="2" ><?php echo $row_co2->syName;?></font></td>
<?php
foreach($rs_prd->result() as $row_prd) {
$k = 0;
$str = '';
$rs_co3 = $co->qryCoBetweenPr($row_co->coCurId, $acY, $row_co2->coSyId, $tmId, $row->dyId, $row_prd->prdId);
foreach($rs_co3->result() as $row_co3) {
$rs_tt = $tt->qryTTJOINRoom($row_co3->coId, $row->dyId, $row_prd->prdId);
$m = 0;
$officerNames = '';
foreach($rs_tt->result() as $row_tt) {
if($m == 0)
$officerNames = 'อ.'.$row_tt->prsName;
else
$officerNames .= ', อ.'.$row_tt->prsName;
$m++;
} // end while $oCt
if($k == 0)
$str = $row_co->crsCode.' '.$row_co->crsName.' กลุ่ม '.$row_co3->coSectionClass.' ห้อง '.$row_tt->plRmNo.' '.$officerNames;
else
$str .= '<br>'.$row_co->crsCode.' '.$row_co->crsName.' กลุ่ม '.$row_co3->coSectionClass.' ห้อง '.$row_tt->plRmNo.' '.$officerNames;
$k++;
} // end while $oCl3
?>
<td><font size="2" ><?php echo $str;?></font></td>
<?php
} // end while rs_prd
?>
</tr>
<?php
$j++;
$i++;
} // end while rs_co2
} // end while rs_co
} // end while rs_dy
}
?>
</table></td>
</tr>
</table>
|