API tools faq
paste
Advertisement
dhanianwar

Untitled

dhanianwar
Apr 28th, 2016
108
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 6.89 KB | None | 0 0
raw download clone embed print report
  1. <table class="table table-bordered table-striped table-condensed">
  2.                 <thead>
  3.                   <tr>
  4.                     <td>Judul Pelatihan</td><td width=1>:</td><td><?php echo $data['NM_PELATIHAN']; ?> (<?php echo $data['MATERI']; ?>)</td>
  5.                   </tr>
  6.                   <tr>
  7.                     <td>Pengajar Pelatihan</td><td width=1>:</td><td><?php echo $data['NM_PENGAJAR']; ?></td>
  8.                   </tr>
  9.                   <tr>
  10.                     <td>Tempat, Tgl Pelatihan</td><td width=1>:</td><td><?php echo $data['KOTA_JADWAL']; ?>, <?php echo $data['TGL_AWAL']; ?> s/d <?php echo $data['TGL_AKHIR']; ?></td>
  11.                   </tr>
  12.                   <tr>
  13.                     <td>Pimpinan Pelatihan</td><td width=1>:</td><td><?php echo $data['NM_PIMPINAN']; ?></td>
  14.                   </tr>
  15.                   <tr>
  16.                     <td>Jumlah Peserta</td><td width=1>:</td><td><?php echo $djq['jum']; ?> Orang</td>
  17.                   </tr>
  18.                 </table>
  19.  
  20.                 <?php
  21.                 //$qangket = "select * from m_unsur a, m_katunsur b where a.KD_KATUNSUR=b.KD_KATUNSUR and a.KD_KATUNSUR='$data[KD_KATUNSUR]'";
  22.                 if($x == 'ajar'){
  23.                 $qangket = "select * from h_angket a, m_unsur b where a.KD_UNSUR=b.KD_UNSUR and a.KD_PESERTA='$data[KD_PESERTA]' and a.JNS_ANGKET='PENGAJARAN'"; }
  24.                 elseif($x == 'ikm'){
  25.                 $qangket = "select * from h_angket a, m_unsur b where a.KD_UNSUR=b.KD_UNSUR and a.KD_PESERTA='$data[KD_PESERTA]' and a.JNS_ANGKET='IKM'"; }
  26.  
  27.                 $qhasil = mysqli_query($GLOBALS,$qangket);
  28.                 ?>
  29.                 <div class="control-group">
  30.                 <div class="row-fluid sortable">  
  31.         <div class="box span12">
  32.           <div class="box-content">
  33.           <B>A. UMUM</B>
  34.             <table class="table table-bordered table-striped table-condensed">
  35.                 <thead>
  36.                   <tr>
  37.                     <th>No</th>
  38.                     <th>Unsur</th>
  39.                     <th><center>Nilai</center></th>
  40.                     <th><center>Konversi</center></th>
  41.                     <th><center><font size="2">Tidak Baik</font></center></th>
  42.                     <th><center><font size="2">Kurang Baik</font></center></th>
  43.                     <th><center><font size="2">Baik</font></center></th>
  44.                     <th><center><font size="2">Sangat Baik</font></center></th>
  45.                   </tr>
  46.                 </thead>  
  47.                 <tbody>
  48.                 <?php $ii = 0; $jumh = 0; $konv = 0;
  49.                 while($qdata = mysqli_fetch_array($qhasil)){ $ii++;
  50.     $kdkatu = $data['KD_KATUNSUR'];
  51.     if($x == 'ajar'){
  52.     $sql_jumkat = "select count(*) jkat from m_unsur where KD_KATUNSUR='$kdkatu'";}
  53.     if($x == 'ikm'){
  54.     $sql_jumkat = "select count(*) jkat from m_unsur where KD_KATUNSUR='KU00003'";}
  55.     $msql = mysqli_query($GLOBALS, $sql_jumkat);
  56.     $rjumkat = mysqli_fetch_array($msql);
  57.     $jkat = $rjumkat['jkat'];
  58.    
  59.   //Nilai
  60. $isi = "select count(NIL1) as jml from h_angket where KD_UNSUR='$qdata[KD_UNSUR]'";
  61. $sisi = mysqli_query($GLOBALS, $isi);
  62. $risi = mysqli_fetch_array($sisi);
  63.  
  64. $hit1 = "select sum(NIL1) as jumlah from h_angket where KD_UNSUR='$qdata[KD_UNSUR]'";
  65. $shit = mysqli_query($GLOBALS, $hit1);
  66. $rhit = mysqli_fetch_array($shit);
  67. $tnilai = $rhit['jumlah'];
  68. $tisi = $risi['jml'];
  69. $jhsl = $tnilai / $tisi;
  70. $njhsl = number_format($jhsl,2);
  71.  
  72. $konv = $jhsl * 25 ;
  73. $konv = number_format($konv, 2);
  74. if($x == 'ajar'){
  75. $qry  = "select * from h_angket where KD_UNSUR='$qdata[KD_UNSUR]' and JNS_ANGKET = 'PENGAJARAN' ";
  76. $qkomen  = "select * from h_angket where KD_UNSUR='$qdata[KD_UNSUR]' and JNS_ANGKET = 'PENGAJARAN' ";}
  77. elseif($x == 'ikm'){
  78. $qry  = "select * from h_angket where KD_UNSUR='$qdata[KD_UNSUR]' and JNS_ANGKET = 'IKM' ";
  79. $qkomen  = "select * from h_angket where KD_UNSUR='$qdata[KD_UNSUR]' and JNS_ANGKET = 'IKM' "; }
  80. $hsl  = mysqli_query($GLOBALS,$qry); $hkomen  = mysqli_query($GLOBALS,$qkomen);
  81. $rw   = mysqli_fetch_array($hsl);
  82. $batasan = 70;
  83. $batasan = number_format($batasan, 2);
  84. $style = '';
  85. //echo "tnilai = $tnilai<br>tisi = $tisi<br>konv = $konv <br>batas = $batasan";
  86. if (number_format($konv, 2) < number_format($batasan, 2)) {
  87. $style = 'background-color: red; color: white;';
  88. }
  89.  
  90. //var_dump($konv);
  91.  
  92. echo '<tr style="';
  93.             echo $style;
  94.             echo '">'; ?>
  95. <td><?php echo $ii; ?></td>
  96. <td class="center"><?php echo $qdata['NM_UNSUR']; ?>
  97. <input type="hidden" class="input-xlarge focused" name="kdu<?=$ii?>" id="kdu" value="<?php echo $qdata['KD_UNSUR']; ?>"/></td>
  98. <td class="center"><center>
  99. <?php
  100. if($rw['NIL1'] == '1'){
  101.   $abjad = 'D'; $ket = "TIDAK BAIK";
  102. }
  103. elseif($rw['NIL1'] == '2'){
  104.   $abjad = 'C'; $ket = "KURANG BAIK";
  105. }
  106. elseif($rw['NIL1'] == '3'){
  107.   $abjad = 'B'; $ket = "BAIK";
  108. }
  109. elseif($rw['NIL1'] == '4'){
  110.   $abjad = 'A'; $ket = "SANGAT BAIK";
  111. }
  112.  
  113. echo number_format($njhsl,2);
  114. /*
  115. 1 = 1.00 - 1.75 / 25.00 - 43.75 D  
  116. 2 = 1.76 - 2.50 / 43.75 - 62.50 C
  117. 3 = 2.51 - 3.25 / 62.51 - 81.25 B
  118. 4 = 3.26 - 4.00 / 81.26 - 100.00 A
  119. */
  120. ?></center></td>
  121. <td class="center"><center><?php echo $konv; ?></center></td>
  122. <td><?php if(($jhsl >= '1.00')&&($jhsl <= '1.75')){ $abjad = D; echo "<center>$abjad</center>";}?></td>
  123. <td><?php if(($jhsl >= '1.76')&&($jhsl <= '2.50')){ $abjad = C; echo "<center>$abjad</center>";}?></td>
  124. <td><?php if(($jhsl >= '2.51')&&($jhsl <= '3.25')){ $abjad = B; echo "<center>$abjad</center>";}?></td>
  125. <td><?php if(($jhsl >= '3.26')&&($jhsl <= '4.00')){ $abjad = A; echo "<center>$abjad</center>";}?></td>
  126. </tr></tr>
  127. <?php
  128. $jumh =+ ($jumh + $jhsl);
  129. //echo number_format($jumh, 2);
  130. } $jumh = $jumh/$jkat;
  131. //jumlah responden = x ;
  132. //nilai tiap unsur dijumlahkan dari tiap responden = y ;
  133. //nilai = y/x
  134. $nki = $jumh * 25;
  135.  
  136. ?>  
  137. <tr>
  138.           <th colspan="2">Nilai Interval IKM = Jumlah NRR IKM Tertimbang Per Unsur</th>
  139.                     <td><center><b><?php echo number_format($jumh,2);?></b></center></td>
  140.                     <td><?php if(($jumh >= '1.00')&&($jumh <= '1.75')){ $abjad = D; echo "<center>$abjad</center>";}?></td>
  141. <td><?php if(($jumh >= '1.76')&&($jumh <= '2.50')){ $abjad = C; echo "<center><b>$abjad</b></center>";}?></td>
  142. <td><?php if(($jumh >= '2.51')&&($jumh <= '3.25')){ $abjad = B; echo "<center><b>$abjad</b></center>";}?></td>
  143. <td><?php if(($jumh >= '3.26')&&($jumh <= '4.00')){ $abjad = A; echo "<center><b>$abjad</b></center>";}?></td><td></td>
  144.                     </tr>
  145.                     <tr>
  146.                     <th colspan="2">Nilai Konversi IKM = Jumlah Nilai Interval X Nilai Dasar</th>
  147.                     <th><center><b><?php echo number_format($nki,2);?></b></center></th>
  148.                     <td><?php if(($nki >= '25.00')&&($nki <= '43.75')){ $abjad2 = D; echo "<center><b>$abjad2</b></center>";}?></td>
  149. <td><?php if(($nki >= '43.76')&&($nki <= '62.50')){ $abjad2 = C; echo "<center><b>$abjad2</b></center>";}?></td>
  150. <td><?php if(($nki >= '62.51')&&($nki <= '81.25')){ $abjad2 = B; echo "<center><b>$abjad2</b></center>";}?></td>
  151. <td><?php if(($nki >= '81.26')&&($nki <= '100.00')){ $abjad2 = A; echo "<center><b>$abjad2</b></center>";}?></td>
  152. <td></td>
  153.                   </tr>
  154. </tbody>
  155.              </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!