Viewing file:      v_repSummary.php (16.66 KB)      -rwxr-xr-x Select action/file-type:    (+) |   (+) |   (+) | Code (+) | Session (+) |   (+) | SDB (+) |   (+) |   (+) |   (+) |   (+) |   (+) |
 
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
     <tr>
         <td><div align="center"><br />
             <table width="100%" align="center" border="0" cellpadding="0" cellspacing="1">
                 <tr>
                     <td align="center"><font size="3" color="<?php //echo $GLOBALS["COLOR_FONT_3"];?>"><b>รายงานประจำปี</b></font></td>
                 </tr>
                 <tr>
                     <td height="22"></td>
                 </tr>
                 <tr>
                     <td><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><b>ปีการศึกษา</b></font>
 <?php
                     $js = "id=\"acY\" onChange=\"sendPost('hidform', {'acY':this.value}, 'sm_show')\"";
                     echo form_dropdown('acY', $rs_tmc, $acY, $js);
 ?>
                     </td>
                 </tr>
                 <tr>
                     <td height="22"></td>
                 </tr>
                 <tr>
                     <td height="22"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><b>จำนวนนักศึกษาที่เข้าศึกษาในวิทยาลัย</b></font></td>
                 </tr>
                 <tr>
                     <td><table width="100%" class="headCol">
                         <tr bgcolor="<?php //echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
                             <th align="center"><font size="2" ><b>หลักสูตร</b></font></th>
                             <th align="center"><font size="2" ><b>ปีการศึกษาที่เข้า</b></font></th>
                             <th align="center"><font size="2" ><b>ประเภททุน</b></font></th>
                             <th align="center"><font size="2" ><b>เพศ</b></font></th>
                             <th align="center" class="amtCol"><font size="2" ><b>จำนวนนักศึกษา</b></font></th>
                         </tr>
 <?php
                         $i = 0;
                         foreach ($rs_sm1->result() as $row_sm) {
                             if (($i%2) == 0)
                                 echo "<tr>";
                             else
                                 //echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TABLE_3"]."\">";
 ?>
                             <td class="indent"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_sm->curName;?></font></td>
                             <td align="center"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_sm->smAdY;?></font></td>
                             <td class="indent"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_sm->etName;?></font></td>
                             <td align="center"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_sm->smStdSex;?></font></td>
                             <td align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_sm->smNumAdmitSt;?></font></td>
                         </tr>
 <?php
                             $i++;
                         }
 
                         if($i == 0) {
 ?>
                         <tr>
                             <td height="22" colspan="5" align="center"><span class="error">** ไม่ปรากฏรายการในฐานข้อมูล **</span></td>
                         </tr>
 <?php
                         }
 ?>
                         <tr bgcolor="<?php //echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
                             <td height="22" colspan="4" align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_1"];?>"><b>รวมจำนวนนักศึกษา</b></font></td>
                             <td align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_1"];?>"><b><?php echo number_format($sumNumAdmitSt);?></b></font></td>
                         </tr>
                     </table><br /></td>
                 </tr>
                 <tr>
                     <td height="22"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><b>จำนวนนักศึกษาที่ศึกษาในวิทยาลัย/จำนวนนักศึกษาจำแนกรายหลักสูตรและชั้นปี</b></font></td>
                 </tr>
                 <tr>
                     <td><table width="100%" class="headCol">
                         <tr bgcolor="<?php //echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
                             <th align="center"><font size="2"><b>หลักสูตร</b></font></th>
                             <th align="center"><font size="2"><b>ปีการศึกษาที่เข้า</b></font></th>
                             <th align="center"><font size="2"><b>ชั้นปี</b></font></th>
                             <th align="center"><font size="2"><b>ประเภททุน</b></font></th>
                             <th align="center"><font size="2"><b>เพศ</b></font></th>
                             <th align="center" class="amtCol"><font size="2"><b>จำนวนนักศึกษา</b></font></th>
                         </tr>
 <?php
                         $i = 0;
                         foreach ($rs_smy1->result() as $row_smy) {
                             if (($i % 2) == 0)
                                 echo "<tr>";
                             else
                                 //echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TABLE_3"]."\">";
 ?>
                             <td class="indent"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->curName;?></font></td>
                             <td align="center"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->smyAdY;?></font></td>
                             <td align="center"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->syCode;?></font></td>
                             <td class="indent"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->etName;?></font></td>
                             <td align="center"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->smyStdSex;?></font></td>
                             <td align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->smyNumSt;?></font></td>
                         </tr>
 <?php
                             $i++;
                         }
 
                         if ($i == 0) {
 ?>
                         <tr>
                             <td height="22" colspan="6" align="center"><span class="error">** ไม่ปรากฏรายการในฐานข้อมูล **</span></td>
                         </tr>
 <?php
                         }
 ?>
                         <tr bgcolor="<?php //echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
                             <td height="22" colspan="5" align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_1"];?>"><b>รวมจำนวนนักศึกษา</b></font></td>
                             <td align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_1"];?>"><b><?php echo number_format($sumNumSt);?></b></font></td>
                         </tr>
                     </table><br /></td>
                 </tr>
                 <tr>
                     <td height="22"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><b>จำนวนนักศึกษาที่สำเร็จการศึกษาในแต่ละหลักสูตร</b></font></td>
                 </tr>
                 <tr>
                     <td><table width="100%" class="headCol">
                         <tr bgcolor="<?php //echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
                             <th align="center"><font size="2"><b>หลักสูตร</b></font></th>
                             <th align="center"><font size="2"><b>ปีการศึกษาที่เข้า</b></font></th>
                             <th align="center"><font size="2"><b>ประเภททุน</b></font></th>
                             <th align="center"><font size="2"><b>เพศ</b></font></th>
                             <th align="center" class="amtCol"><font size="2"><b>จำนวนนักศึกษา</b></font></th>
                         </tr>
 
 <?php
                         $i = 0;
                         foreach ($rs_sm2->result() as $row_sm) {
                             if (($i % 2) == 0)
                                 echo "<tr>";
                             else
                                 //echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TABLE_3"]."\">";
 ?>
                             <td class="indent"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_sm->curName;?></font></td>
                             <td align="center"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_sm->smAdY;?></font></td>
                             <td class="indent"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_sm->etName;?></font></td>
                             <td align="center"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_sm->smStdSex;?></font></td>
                             <td align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_sm->smNumGraduateSt;?></font></td>
                         </tr>
 <?php
                             $i++;
                         }
 
                         if ($i == 0) {
 ?>
                         <tr>
                             <td height="22" colspan="5" align="center"><span class="error">** ไม่ปรากฏรายการในฐานข้อมูล **</span></td>
                         </tr>
 <?php
                         }
 ?>
                         <tr bgcolor="<?php //echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
                             <td height="22" colspan="4" align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_1"];?>"><b>รวมจำนวนนักศึกษา</b></font></td>
                             <td align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_1"];?>"><b><?php echo number_format($sumNumGraduateSt);?></b></font></td>
                         </tr>
                     </table><br /></td>
                 </tr>
                 <tr>
                     <td height="22"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><b>จำนวนผู้รับทุนของวิทยาลัย</b></font></td>
                 </tr>
                 <tr>
                     <td><table width="100%" class="headCol">
                         <tr bgcolor="<?php //echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
                             <th align="center"><font size="2"><b>หลักสูตร</b></font></th>
                             <th align="center"><font size="2"><b>ปีการศึกษาที่เข้า</b></font></th>
                             <th align="center"><font size="2"><b>ประเภททุน</b></font></th>
                             <th align="center"><font size="2"><b>เพศ</b></font></th>
                             <th align="center" class="amtCol"><font size="2"><b>จำนวนนักศึกษา</b></font></th>
                         </tr>
 <?php
                         $i = 0;
                         foreach ($rs_sm3->result() as $row_sm) {
                             if (($i % 2) == 0)
                                 echo "<tr>";
                             else
                                 //echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TABLE_3"]."\">";
 ?>
                             <td class="indent"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_sm->curName;?></font></td>
                             <td align="center"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_sm->smAdY;?></font></td>
                             <td class="indent"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_sm->etName;?></font></td>
                             <td align="center"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_sm->smStdSex;?></font></td>
                             <td align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_sm->smNumScholarSt;?></font></td>
                         </tr>
 <?php
                             $i++;
                         }
 
                         if ($i == 0) {
 ?>
                         <tr>
                             <td height="22" colspan="5" align="center"><span class="error">** ไม่ปรากฏรายการในฐานข้อมูล **</span></td>
                         </tr>
 <?php
                         }
 ?>
                         <tr bgcolor="<?php //echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
                             <td height="22" colspan="4" align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_1"];?>"><b>รวมจำนวนนักศึกษา</b></font></td>
                             <td align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_1"];?>"><b><?php echo number_format($sumNumScholarSt);?></b></font></td>
                         </tr>
                     </table><br /></td>
                 </tr>
                 <tr>
                     <td height="22"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><b>จำนวนนักศึกษาที่ซ้ำชั้นในแต่ละหลักสูตรจำแนกรายชั้นปี</b></font></td>
                 </tr>
                 <tr>
                     <td><table width="100%" class="headCol">
                         <tr bgcolor="<?php //echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
                             <th align="center"><font size="2"><b>หลักสูตร</b></font></th>
                             <th align="center"><font size="2"><b>ปีการศึกษาที่เข้า</b></font></th>
                             <th align="center"><font size="2"><b>ชั้นปี</b></font></th>
                             <th align="center"><font size="2"><b>ประเภททุน</b></font></th>
                             <th align="center"><font size="2"><b>เพศ</b></font></th>
                             <th align="center" class="amtCol"><font size="2"><b>จำนวนนักศึกษา</b></font></th>
                         </tr>
 <?php
                         $i = 0;
                         foreach ($rs_smy2->result() as $row_smy) {
                             if (($i % 2) == 0)
                                 echo "<tr>";
                             else
                                 //echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TABLE_3"]."\">";
 ?>
                             <td class="indent"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->curName;?></font></td>
                             <td align="center"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->smyAdY;?></font></td>
                             <td align="center"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->syCode;?></font></td>
                             <td class="indent"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->etName;?></font></td>
                             <td align="center"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->smyStdSex;?></font></td>
                             <td align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->smyNumRepeatClassSt;?></font></td>
                         </tr>
 <?php
                             $i++;
                         }
 
                         if ($i == 0) {
 ?>
                         <tr>
                             <td height="22" colspan="6" align="center"><span class="error">** ไม่ปรากฏรายการในฐานข้อมูล **</span></td>
                         </tr>
 <?php
                         }
 ?>
                         <tr bgcolor="<?php //echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
                             <td height="22" colspan="5" align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_1"];?>"><b>รวมจำนวนนักศึกษา</b></font></td>
                             <td align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_1"];?>"><b><?php echo number_format($sumNumRepeatClassSt);?></b></font></td>
                         </tr>
                     </table><br /></td>
                 </tr>
                 <tr>
                     <td height="22"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><b>จำนวนนักศึกษาที่ออกนอกระบบ (ตาย/ลาออก/ให้ออก)</b></font></td>
                 </tr>
                 <tr>
                     <td><table width="100%" class="headCol">
                         <tr bgcolor="<?php //echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
                             <th align="center"><font size="2"><b>หลักสูตร</b></font></th>
                             <th align="center"><font size="2"><b>ปีการศึกษาที่เข้า</b></font></th>
                             <th align="center"><font size="2"><b>ชั้นปี</b></font></th>
                             <th align="center"><font size="2"><b>ประเภททุน</b></font></th>
                             <th align="center"><font size="2"><b>เพศ</b></font></th>
                             <th align="center" class="amtCol"><font size="2"><b>จำนวนนักศึกษา</b></font></th>
                         </tr>
 <?php
                         $i = 0;
                         foreach ($rs_smy3->result() as $row_smy) {
                             if (($i % 2) == 0)
                                 echo "<tr>";
                             else
                                 //echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TABLE_3"]."\">";
 ?>
                             <td class="indent"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->curName;?></font></td>
                             <td align="center"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->smyAdY;?></font></td>
                             <td align="center"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->syCode;?></font></td>
                             <td class="indent"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->etName;?></font></td>
                             <td align="center"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->smyStdSex;?></font></td>
                             <td align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $row_smy->smyNumOutSt;?></font></td>
                         </tr>
 <?php
                             $i++;
                         }
 
                         if ($i == 0) {
 ?>
                         <tr>
                             <td height="22" colspan="6" align="center"><span class="error">** ไม่ปรากฏรายการในฐานข้อมูล **</span></td>
                         </tr>
 <?php
                         }
 ?>
                         <tr bgcolor="<?php //echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
                             <td height="22" colspan="5" align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_1"];?>"><b>รวมจำนวนนักศึกษา</b></font></td>
                             <td align="right" class="indentR"><font size="2" color="<?php //echo $GLOBALS["COLOR_FONT_1"];?>"><b><?php echo number_format($sumNumOutSt);?></b></font></td>
                         </tr>
                     </table><br /></td>
                 </tr>
                 <tr>
                     <td height="22"><span class="error"><strong>หมายเหตุ : </strong>ปรับปรุงข้อมูลล่าสุด ณ วันที่ <?php echo (isset($row_sm) && getval('smUpdateDate', $row_sm)) ? getval('smUpdateDate', $row_sm) : (isset($row_smy) ? getval('smyUpdateDate', $row_smy) : '');?></span></td>
                 </tr>
             </table></div><br /></td>
     </tr>
 </table>
  |