PageRenderTime 46ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 1ms

/Summary_grafik_detail_kecamatan.php

https://bitbucket.org/ArgoWibowo/si_aktivitas_tani
PHP | 210 lines | 193 code | 17 blank | 0 comment | 1 complexity | 3e69f124ec0b215946d08d2398aedd09 MD5 | raw file
    

  1. <?php 
    2. 

  2. $id_spesies = $_GET['spesies'];
    3. 

  3. $tahun = $_GET['tahun'];
    4. 

  4. ?>
    5. 

  5. <html><head>
    6. 

  6.         <meta charset="utf-8">
    7. 

  7.         <meta name="viewport" content="width=device-width, initial-scale=1">
    8. 

  8.         <script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>
    9. 

  9.         <script type="text/javascript" src="http://netdna.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js"></script>
    10. 

  10.         <link href="http://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.3.0/css/font-awesome.min.css" rel="stylesheet" type="text/css">
    11. 

  11.         <link href="css/Aktivitas Pertanian.css" rel="stylesheet" type="text/css">
    12. 

  12.         <link href="css/side-bar.css" rel="stylesheet">
    13. 

  13.     </head><body>
    14. 

  14.  <nav class="navbar navbar-default">
    15. 

  15.   <div class="container-fluid">
    16. 

  16.     <div class="navbar-header">
    17. 

  17.       <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
    18. 

  18.         <span class="sr-only">Toggle navigation</span>
    19. 

  19.         <span class="icon-bar"></span>
    20. 

  20.         <span class="icon-bar"></span>
    21. 

  21.         <span class="icon-bar"></span>
    22. 

  22.       </button>
    23. 

  23.       <a class="navbar-brand" href="index_home.php">Sistem Informasi Tanaman Pertanian</a>
    24. 

  24.     </div>  
    25. 

  25.     <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
    26. 

  26.       <ul class="nav navbar-nav navbar-right">
    27. 

  27.         <li><a href="login.php">Masuk</a></li>
    28. 

  28.           </ul>
    29. 

  29.         </li>
    30. 

  30.       </ul>
    31. 

  31.     </div>
    32. 

  32.   </div>
    33. 

  33. </nav>
    34. 

  34. 

  35. <nav class="navbar navbar-default no-margin">
    36. 

  36.     <!-- Brand and toggle get grouped for better mobile display -->
    37. 

  37.                 <div class="navbar-header fixed-brand">
    38. 

  38.                     <button type="button" class="navbar-toggle collapsed" data-toggle="collapse"  id="menu-toggle">
    39. 

  39.                       <span class="glyphicon glyphicon-th-large" aria-hidden="true"></span>
    40. 

  40.                     </button>
    41. 

  41.                     <a class="navbar-brand" href="#" id="menu-toggle-2"><i class="fa fa-server fa-4"></i> MENU</a> 
    42. 

  42.                 </div><!-- navbar-header-->
    43. 

  43.  
    44. 

  44.                 <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
    45. 

  45.                             <ul class="nav navbar-nav">
    46. 

  46.                                 
    47. 

  47.                             </ul>
    48. 

  48.                             <ul>
    49. 

  49.                                 <div style="margin-bottom:15px;" align="right">
    50. 

  50.                                     
    51. 

  51.                                 </div>
    52. 

  52.                             </ul>
    53. 

  53.                 </div><!-- bs-example-navbar-collapse-1 -->
    54. 

  54.           </div>
    55. 

  55.     </nav>
    56. 

  56. 

  57.      <div id="wrapper">
    58. 

  58.         <!-- Sidebar -->
    59. 

  59.         <div id="sidebar-wrapper">
    60. 

  60.             <ul class="sidebar-nav nav-pills nav-stacked" id="menu" >
    61. 

  61.                 <li>
    62. 

  62.                     <a href="#"><span class="fa-stack fa-lg pull-left"><i class="fa fa-server fa-stack-1x  "></i></span>Daftar Tanaman</a>
    63. 

  63.                     <ul class="nav-pills nav-stacked" style="list-style-type:none;">
    64. 

  64.                         <li><a href="Daftar Tanaman-lihat.php"> Tanaman</a></li>
    65. 

  65.                         <li><a href="Daftar morfologi-lihat.php"> Morfologi Tanaman</a></li>
    66. 

  66.                         <li><a href="Daftar Kalender Tanam-lihat.php"> Kalender Tanaman</a></li>
    67. 

  67.                         <li><a href="Daftar Peta Lahan-lihat.php"> Peta Lahan</a></li>
    68. 

  68.                     </ul>
    69. 

  69.                 </li>
    70. 

  70.                 <li>
    71. 

  71.                     <a href="#"><span class="fa-stack fa-lg pull-left"><i class="fa fa-server fa-stack-1x "></i></span>Informasi Tanaman</a>
    72. 

  72.                     <ul class="nav-pills nav-stacked" style="list-style-type:none;">
    73. 

  73.                         <li><a href="Grafik_jenis_tanaman.php"></span> Grafik Jenis Tanaman</a></li>
    74. 

  74.                         <li><a href="Grafik_jenis_tanah.php"></span> Grafik jenis tanah</a></li>
    75. 

  75.                     </ul>
    76. 

  76.                 </li>
    77. 

  77.                  <li>
    78. 

  78.                     <a href="#"><span class="fa-stack fa-lg pull-left"><i class="fa fa-server fa-stack-1x "></i></span>Informasi Aktivitas</a>
    79. 

  79.                     <ul class="nav-pills nav-stacked" style="list-style-type:none;">
    80. 

  80.                         <li><a href="Daftar_trans_aktivitas_lihat.php"> Aktivitas petani</a></li>
    81. 

  81.                         <li><a href="Grafik_aktivitas_pertanian.php"> Grafik Aktivitas Daerah</a></li>
    82. 

  82.                         <li><a href="Grafik_aktivitas_tanaman.php"> Grafik Aktivitas Tanaman</a></li>
    83. 

  83.                         <li><a href="Daftar Hasil Panen-lihat.php"> Hasil Panen</a></li>
    84. 

  84.                         <li><a href="Grafik_panen_tanaman.php"></span> Grafik Hasil Panen Tanaman</a></li>
    85. 

  85.                         <li><a href="Perkiraan_panen.php"> Perkiraan Panen</a></li>
    86. 

  86.                         <li><a href="Grafikpanen.php"></span> Grafik Hasil Panen</a></li>
    87. 

  87.                         <li><a href="Grafik_detail_panen.php"></span> Grafik Hasil Panen Detail</a></li>
    88. 

  88.                     </ul>
    89. 

  89.                 </li>
    90. 

  90.             </ul>
    91. 

  91.         </div><!-- /#sidebar-wrapper -->
    92. 

  92. 

  93. <div id="page-content-wrapper">
    94. 

  94.             <div class="container-fluid xyz">
    95. 

  95.                 <div class="row">
    96. 

  96.                     <div class="col-lg-12">
    97. 

  97.                         <!--konten-->
    98. 

  98.                             <div>
    99. 

  99.                                 <div class="container">
    100. 

  100.                                     <div class="row">
    101. 

  101.                                         <div class="col-md-12">
    102. 

  102.                                             <?php                                                         
    103. 

  103.                                             mysql_connect("localhost","root","") or die(mysql_error());
    104. 

  104.                                             mysql_select_db("iais_ukdw") or die("Database tidak ditemukan");
    105. 

  105.                                             $query= mysql_query("SELECT * FROM master_spesies_tanaman where ID_Spesies = '$id_spesies';");
    106. 

  106.                                             $brsnama = mysql_fetch_assoc($query);
    107. 

  107.                                             ?>
    108. 

  108.                                             <h1>Summary Hasil Panen <?php echo $brsnama['Nama_Tanaman']?> Kecamatan <?php echo $tahun?></h1>
    109. 

  109.                                              <div class="col-md-2">
    110. 

  110.                                                 <a style="font-size:20px". onclick="window.history.go(-1);"><span class="glyphicon glyphicon-chevron-left"></span> Kembali</a>
    111. 

  111.                                             </div>
    112. 

  112.                                             <div class="col-md-2">
    113. 

  113.                                                 <a style="font-size:20px". href="Daftar laporan detail panen kecamatan.php?Kabupaten=<?php echo $_GET['Kabupaten']?>&spesies=<?php echo $id_spesies ?>&tahun=<?php echo $tahun;?>"><span class="glyphicon glyphicon-print"></span> Cetak</a>
    114. 

  114.                                             </div>
    115. 

  115.                                         </div>
    116. 

  116.                                     </div>
    117. 

  117.                                 </div>
    118. 

  118.                             </div>
    119. 

  119.                            
    120. 

  120.                             <div class="section">
    121. 

  121.                                 <div class="container">
    122. 

  122.                                     <div class="row">
    123. 

  123.                                         <div class="col-md-12">
    124. 

  124.                                            <table class="table" style="width: 500px;">
    125. 

  125.                              <thead>
    126. 

  126.                             <div style="margin-bottom:15px;" align="center">
    127. 

  127.                               
    128. 

  128.                             </div>
    129. 

  129.                               <tr>
    130. 

  130.                                    <th>No</th>
    131. 

  131.                                    <th>Wilayah</th>
    132. 

  132.                                    <th>Jumlah</th>
    133. 

  133.                               </tr>
    134. 

  134.                              </thead>
    135. 

  135.                                             
    136. 

  136.                                             <tbody>
    137. 

  137.                                             <?php
    138. 

  138.                                                 $koneksi = include("koneksi.php");                      
    139. 

  139.                                                 $hasil = mysqli_query($koneksi,"select * from kecamatan WHERE Nama_Kabupaten = '$_GET[Kabupaten]'  order by Nama_Kecamatan");
    140. 

  140.                                                 $no = 1;
    141. 

  141.                                                 $total=0;
    142. 

  142.                                                 while($kecamatan = mysqli_fetch_array($hasil)){
    143. 

  143.                                             ?>  
    144. 

  144.                                                 <tr>
    145. 

  145.                                                     <td><?php echo $no++ ?></td>
    146. 

  146.                                                     <td> 
    147. 

  147.                                                     <?php
    148. 

  148.                                                         $hasil3 = mysqli_query($koneksi,"select * from kelurahan_desa WHERE Nama_Kecamatan = '$kecamatan[Nama_Kecamatan]' order by Nama_Desa");
    149. 

  149.                                                         while($data3 = mysqli_fetch_array($hasil3)){
    150. 

  150.                                                             echo $data3['Nama_Desa'].'<br/>';
    151. 

  151.                                                         }
    152. 

  152.                                                     ?>
    153. 

  153.                                                     <?php echo "&nbsp;&nbsp;&nbsp;&nbsp;". $kecamatan['Nama_Kecamatan']?>
    154. 

  154.                                                     </td>
    155. 

  155.                                                     <td>
    156. 

  156.                                                    <?php
    157. 

  157.                                                    $hasil2 = mysqli_query($koneksi,"SELECT master_petani.Kecamatan as nama, sum(trans_hasil_panen.Jumlah_hasil_Panen) AS jumlah FROM master_petani Inner JOIN trans_hasil_panen ON master_petani.ID_User = trans_hasil_panen.ID_Petani where ID_Spesies='$id_spesies' and Tahun_Panen='$tahun' And Kecamatan = '$kecamatan[Nama_Kecamatan]'");
    158. 

  158.                                                    
    159. 

  159.                                                     $data2 = mysqli_fetch_array($hasil2);
    160. 

  160.                                                     
    161. 

  161.                                                     $total=$total+$data2['jumlah'];
    162. 

  162.                                                     ?>
    163. 

  163.                                                     <?php
    164. 

  164.                                                         $hasil3 = mysqli_query($koneksi,"select * from kelurahan_desa WHERE Nama_Kecamatan = '$kecamatan[Nama_Kecamatan]' order by Nama_Kecamatan");
    165. 

  165.                                                         while($kecamatan = mysqli_fetch_array($hasil3)){
    166. 

  166.                                                         
    167. 

  167.                                                             $hasil4 = mysqli_query($koneksi,"SELECT master_petani.Kecamatan as nama, sum(trans_hasil_panen.Jumlah_hasil_Panen) AS jumlah FROM master_petani Inner JOIN trans_hasil_panen ON master_petani.ID_User = trans_hasil_panen.ID_Petani where ID_Spesies='$id_spesies' and Tahun_Panen='$tahun' And Kecamatan = '$kecamatan[Nama_Kecamatan]' AND Desa_Kelurahan = '$kecamatan[Nama_Desa]'");
    168. 

  168.                                                             $data4 = mysqli_fetch_array($hasil4);
    169. 

  169.                                                                 echo $data4['jumlah'].'<br/>';
    170. 

  170.                                                         
    171. 

  171.                                                         }
    172. 

  172.                                                     ?>
    173. 

  173.                                                     <?php echo "&nbsp;&nbsp;&nbsp;&nbsp;". $data2['jumlah']; ?>
    174. 

  174.                                                     </td>
    175. 

  175.                                                 </tr>
    176. 

  176.                                                 <?php
    177. 

  177.                                                 
    178. 

  178.                                                 }
    179. 

  179. 

  180.                                                 ?>
    181. 

  181.                                                 <tr>
    182. 

  182.                                                     <td>&nbsp;</td>
    183. 

  183.                                                     <td>Total
    184. 

  184.                                                     </td>
    185. 

  185.                                                     <td>
    186. 

  186.                                                    <?php
    187. 

  187.                                                     echo $total;
    188. 

  188.                                                     ?>
    189. 

  189.                                                     </td>
    190. 

  190.                                                 </tr>
    191. 

  191.                                             </tbody>
    192. 

  192.                                             
    193. 

  193.                   
    194. 

  194.                                         </table>
    195. 

  195.                                         </div>
    196. 

  196.                                     </div>
    197. 

  197.                                 </div>
    198. 

  198.                             </div>
    199. 

  199.                         <!--end konten-->
    200. 

  200.                      </div>
    201. 

  201.                 </div>
    202. 

  202.             </div>
    203. 

  203.          </div>
    204. 

  204.           <script src="css/side_menu.js"></script>
    205. 

  205.         <footer class="navbar navbar-default navbar-fixed-bottom">
    206. 

  206.             <div class="container-fluid">
    207. 

  207.                 <a class="navbar-brand">Sistem Informasi Tanaman Pertanian</a>
    208. 

  208.             </div>
    209. 

  209.         </footer>                         
    210. 

  210. </body></html>
    211.