Viewing file:      v_rptRis133.php (5.4 KB)      -rwxr-xr-x 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 "searchRptRis133";?>'">
         <!-- <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>RIS133</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 height="22" align="center" colspan="3"><font size="3" ><b>หลักสูตร : </b><?=$curName;?> (ปีการศึกษาที่เข้า <?=$adY;?>)</font></td>
     </tr>
     <tr>
         <td height="22" colspan="3"></td>
     </tr>
 <!-- แก้ไขตรงนี้ -->
 <?php
 $con_sy = array('rspCurId'    => $curId,
                 'rspAdY'    => $adY);
 $grp_sy = array('rspSyId'    => "rspSyId");
 $sy = $rsp->qryRsp($con_sy,'',$grp_sy);
 
 if($sy->num_rows()) {
     foreach($sy->result() as $row_sy) {
         $studyyear->syId = $row_sy->rspSyId;
         $studyyear->get_by_key(TRUE);
 ?>
     <tr>
         <td height="22" align="center" colspan="3"><font size="3"><b>ชั้นปีที่ </b><?php echo (isset($studyyear->syCode)) ? $studyyear->syCode : "";?></font></td>
     </tr>
     <tr>
         <td height="22" align="center" colspan="3">
         <table width="600" border="1" cellspacing="0" cellpadding="2" align="center" bordercolor="#000000" style="border-collapse: collapse">
             <tr>
                 <td width="60%" rowspan="2" align="center"><font size="2"><b>รายวิชา</b></font></td>
                 <td width="10%" rowspan="2" align="center"><font size="2"><b>หน่วยกิต</b></font></td>
                 <td width="30%" colspan="3" align="center"><font size="2"><b>จำนวนชั่วโมง/สัปดาห์</b></font></td>
             </tr>
             <tr>
                 <td width="10%" align="center"><font size="2"><b>ทฤษฎี</b></font></td>
                 <td width="10%" align="center"><font size="2"><b>ทดลอง/ปฏิบัติ</b></font></td>
                 <td width="10%" align="center"><font size="2"><b>ศึกษาด้วย<br>ตนเอง</b></font></td>
             </tr>
 <?php
         $con_tm = array('rspCurId'    => $curId,
                         'rspAdY'    => $adY,
                         'rspSyId'    => $row_sy->rspSyId);
         $grp_tm = array('rspTmId'    => 'rspTmId');
         $tm = $rsp->qryRsp($con_tm,'',$grp_tm);
         if($tm->num_rows()) {
             foreach($tm->result() as $row_tm) {
                 $term->tmId = $row_tm->rspTmId;
                 $term->get_by_key(TRUE);
 ?>
             <tr><td height="22" colspan="5"><font size="3"><b>ภาคการศึกษาที่ <?php echo (isset($term->tmCode)) ? $term->tmCode : "";?></b></font></td></tr>
 <?php
                 $sumCreditTotal = 0;
                 $sumPeriod1 = 0;
                 $sumPeriod2 = 0;
                 $sumPeriod3 = 0;
 
                 $rs_cs = $cs->qryCsCdId1ByCsCurId($curId);
                 if($rs_cs->num_rows()) {
                     foreach($rs_cs->result() as $row_cs) {
                         $con_cd1 = array('rspCurId'    => $curId,
                                             'rspSyId'    => $row_sy->rspSyId,
                                             'rspTmId'    => $row_tm->rspTmId,
                                             'rspAdY'    => $adY,
                                             'rspCdId1'    => $row_cs->csCdId1);
                         $cd1 = $rsp->qryRsp($con_cd1);
                         // แสดงหมวด
                         if($cd1->num_rows()) {
                             $condition->cdId = $cd1->row()->rspCdId1;
                             $condition->get_by_key(TRUE);
 ?>
             <tr><td height="22" colspan="5"><font size="2"><b><?php echo (isset($condition->cdName)) ? $condition->cdName : "";?></b></font></td></tr>
 <?php
                         }
                         // แสดงวิชา
                         if($cd1->num_rows()) {
                             foreach($cd1->result() as $row_crs) {
                                 $course->crsId = $row_crs->rspCrsId;
                                 $course->get_by_key(TRUE);
 
                                 $sumCreditTotal += $course->crsCreditTotal;
                                 $sumPeriod1 += $course->crsPeriod1;
                                 $sumPeriod2 += $course->crsPeriod2;
                                 $sumPeriod3 += $course->crsPeriod3;
 ?>
             <tr>
                 <td height="22"><font size="2"><?php echo $course->crsCode.' '.explodeSquare($course->crsName);?></font></td>
                 <td align="center"><font size="2"><?php echo $course->crsCreditTotal;?></font></td>
                 <td align="center"><font size="2"><?php echo $course->crsPeriod1;?></font></td>
                 <td align="center"><font size="2"><?php echo $course->crsPeriod2;?></font></td>
                 <td align="center"><font size="2"><?php echo $course->crsPeriod3;?></font></td>
             </tr>
 <?php
                             }
                         }
                     }
                 }
 ?>
             <tr>
                 <td height="22" align="right"><font size="2"><b>รวมหน่วยกิต</b></font></td>
                 <td align="center"><font size="2"><?php echo $sumCreditTotal;?></font></td>
                 <td align="center"><font size="2"><?php echo $sumPeriod1;?></font></td>
                 <td align="center"><font size="2"><?php echo $sumPeriod2;?></font></td>
                 <td align="center"><font size="2"><?php echo $sumPeriod3;?></font></td>
             </tr>
 <?php
             }
         }
 ?>
 
 
 
         </table></td>
     </tr>
     <tr>
         <td><br /></td>
     </tr>
 <?php
     }
 } else {
 ?>
     <tr>
         <td height="22" align="center" colspan="3"><font size="2">ไม่พบข้อมูล</font></td>
     </tr>
 <?php
 }
 ?>
 </table>
  |