<?
	include "db_connect.php";

    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Banjarnegara'";
    $result=mysqli_query($db,$sql);
    $row1=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Banyumas'";
    $result=mysqli_query($db,$sql);
    $row2=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Batang'";
    $result=mysqli_query($db,$sql);
    $row3=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Blora'";
    $result=mysqli_query($db,$sql);
    $row4=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Boyolali'";
    $result=mysqli_query($db,$sql);
    $row5=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Brebes'";
    $result=mysqli_query($db,$sql);
    $row6=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Cilacap'";
    $result=mysqli_query($db,$sql);
    $row7=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Demak'";
    $result=mysqli_query($db,$sql);
    $row8=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Grobogan'";
    $result=mysqli_query($db,$sql);
    $row9=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Jepara'";
    $result=mysqli_query($db,$sql);
    $row10=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Karanganyar'";
    $result=mysqli_query($db,$sql);
    $row11=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Kebumen'";
    $result=mysqli_query($db,$sql);
    $row12=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Kendal'";
    $result=mysqli_query($db,$sql);
    $row13=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Klaten'";
    $result=mysqli_query($db,$sql);
    $row14=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Kudus'";
    $result=mysqli_query($db,$sql);
    $row15=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Magelang'";
    $result=mysqli_query($db,$sql);
    $row16=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Pati'";
    $result=mysqli_query($db,$sql);
    $row17=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Pekalongan'";
    $result=mysqli_query($db,$sql);
    $row18=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Pemalang'";
    $result=mysqli_query($db,$sql);
    $row19=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Purbalingga'";
    $result=mysqli_query($db,$sql);
    $row20=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Purworejo'";
    $result=mysqli_query($db,$sql);
    $row21=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Rembang'";
    $result=mysqli_query($db,$sql);
    $row22=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Semarang'";
    $result=mysqli_query($db,$sql);
    $row23=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Sragen'";
    $result=mysqli_query($db,$sql);
    $row24=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Sukoharjo'";
    $result=mysqli_query($db,$sql);
    $row25=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Tegal'";
    $result=mysqli_query($db,$sql);
    $row26=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Temanggung'";
    $result=mysqli_query($db,$sql);
    $row27=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Wonogiri'";
    $result=mysqli_query($db,$sql);
    $row28=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kabupaten Wonosobo'";
    $result=mysqli_query($db,$sql);
    $row29=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kota Magelang'";
    $result=mysqli_query($db,$sql);
    $row30=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kota Pekalongan'";
    $result=mysqli_query($db,$sql);
    $row31=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kota Salatiga'";
    $result=mysqli_query($db,$sql);
    $row32=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kota Semarang'";
    $result=mysqli_query($db,$sql);
    $row33=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kota Surakarta'";
    $result=mysqli_query($db,$sql);
    $row34=mysqli_fetch_row($result);
    $sql = "SELECT count(*) FROM `agro` WHERE `kabkota`= 'Kota Tegal'";
    $resul=mysqli_query($db,$sql);
    $row35=mysqli_fetch_row($result);

?>
<!DOCTYPE html>
<html lang="en">
<head>

	<!-- Basic Page Needs
	================================================== -->
	<meta charset="utf-8">
    <title>SIIDa - Disperindag Jateng</title>
    <meta name="description" content="">
	<meta name="author" content="masbam">
	<meta name="robots" content="noindex">
  <meta name="googlebot" content="noindex">
	<!-- Mobile Specific Metas
	================================================== -->
	<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">

	<!-- Favicons
	================================================== -->
  <link rel="icon" type="image/png" href="assets/img/favicon.png">


	<!-- CSS
	================================================== -->

	<!-- Bootstrap -->
	<link rel="stylesheet" href="css/bootstrap.min.css">
	<!-- Template styles-->
	<link rel="stylesheet" href="css/style.css">
	<!-- Responsive styles-->
	<link rel="stylesheet" href="css/responsive.css">
	<!-- FontAwesome -->
	<link rel="stylesheet" href="css/font-awesome.min.css">
	<!-- Animation -->
	<link rel="stylesheet" href="css/animate.css">
	<!-- Prettyphoto -->
	<link rel="stylesheet" href="css/prettyPhoto.css">
	<!-- Owl Carousel -->
	<link rel="stylesheet" href="css/owl.carousel.css">
	<link rel="stylesheet" href="css/owl.theme.css">
	<!-- Flexslider -->
	<link rel="stylesheet" href="css/flexslider.css">
	<!-- Flexslider -->
	<link rel="stylesheet" href="css/cd-hero.css">
	<!-- Style Swicther -->
	<link id="style-switch" href="css/presets/preset3.css" media="screen" rel="stylesheet" type="text/css">

	<!-- HTML5 shim, for IE6-8 support of HTML5 elements. All other JS at the end of file. -->
    <!--[if lt IE 9]>
      <script src="js/html5shiv.js"></script>
      <script src="js/respond.min.js"></script>
    <![endif]-->
<script type="text/javascript" src="js/Chart.js"></script>
</head>

<body>
	<div class="body-inner">
	<!-- Header start -->
	<header id="header" class="navbar-fixed-top header" role="banner">
		<div class="container">
			<div class="row">
				<!-- Logo start -->
				<div class="navbar-header">
				    <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
				        <span class="sr-only">Toggle navigation</span>
				        <span class="icon-bar"></span>
				        <span class="icon-bar"></span>
				        <span class="icon-bar"></span>
				    </button>
				    <div class="navbar-brand navbar-bg">
					    <a href="index.php">
					    	<img class="img-responsive" src="images/logo.png" alt="logo">
					    </a>
				    </div>
				</div><!--/ Logo end -->
				<nav class="collapse navbar-collapse clearfix" role="navigation">
					<ul class="nav navbar-nav navbar-right">
						<li>
                       		<a href="index.php">Beranda</a>
	          </li>
            <li class="dropdown">
                          <a href="#" class="dropdown-toggle" data-toggle="dropdown">Tentang Kami <i class="fa fa-angle-down"></i></a>
                          <div class="dropdown-menu">
                            <ul>
                                <li><a href="about.php">SIIDa</a></li>
                                <li><a href="https://stats.uptimerobot.com/rWZWjCrB0X" target="_blank">Server Status</a></li>
                            </ul>
                        </div>
                      </li>
						<li class="dropdown active">
                       		<a href="#" class="dropdown-toggle" data-toggle="dropdown">Agro <i class="fa fa-angle-down"></i></a>
                       		<div class="dropdown-menu">
														<ul>
																<li><a href="agro.php">Data</a></li>
																<li class="active"><a href="#">Grafik</a></li>
																<li><a href="map-agro.php">Map Data</a></li>
														</ul>
	                    	</div>
	                    </li>
						<li class="dropdown">
                       		<a href="#" class="dropdown-toggle" data-toggle="dropdown">Non Agro <i class="fa fa-angle-down"></i></a>
                       		<div class="dropdown-menu">
														<ul>
		                            <li><a href="nonagro.php">Data</a></li>
		                            <li><a href="chart_nonagro.php">Grafik</a></li>
		                            <li><a href="map-nonagro.php">Map Data</a></li>
		                        </ul>
	                    	</div>
	                    </li>

	                    <li class="dropdown">
                       		<a href="#" class="dropdown-toggle" data-toggle="dropdown">Layanan <i class="fa fa-angle-down"></i></a>
                       		<div class="dropdown-menu">
														<ul>
		                           	 <li><a href="../pos">Pojok Akuntansi</a></li>
	                            	<li><a href="market.php">Market Jateng</a></li>
                                <li><a href="speedtest.php">Speed Test</a></li>
		                        </ul>
	                    	</div>
	                    </li>
	                    <li class="dropdown">
                       		<a href="#" class="dropdown-toggle" data-toggle="dropdown">Kontak <i class="fa fa-angle-down"></i></a>
	                    </li>
            			<li><a href="../admin3">Login</a></li>
                    </ul>
				</nav><!--/ Navigation end -->
			</div><!--/ Row end -->
		</div><!--/ Container end -->
	</header><!--/ Header end -->

	<div id="banner-area">
		<img src="images/banner/banner1.jpg"width="100%"  alt ="" />
		<div class="parallax-overlay"></div>
			<!-- Subpage title start -->
			<div class="banner-title-content">
	        	<div class="text-center">
		        	<h2>Data Agro</h2>
	          	</div>
          	</div><!-- Subpage title end -->
	</div><!-- Banner area end -->

	<!-- Main container start -->

	<section id="main-container">
		<div class="container">

			<!-- Company Profile -->

			<div class="row">
				<div class="col-md-12 heading text-center">
					<h2 class="title2">Grafik Data Agro SIIDa - Jateng
						<span class="title-desc">Data Agro Dinas Perindustrian dan Perdagangan Propinsi Jawa Tengah</span>
					</h2>
				</div>
			</div><!-- Title row end -->

			<div class="row about-wrapper-top">

      <!--  <div style="width: 1245px;height: 40px">-->
          <canvas id="myChart"></canvas>
          <!--<center><font color="red"><i><sup>*</sup>Data Realtime Industri Agro dari SIIDa</i></font></center>
        </div>-->


        <script>
          var ctx = document.getElementById("myChart").getContext('2d');
          var myChart = new Chart(ctx, {
            type: 'bar',
            data: {
              labels: ["Banjarnegara", "Banyumas", "Batang", "Blora", "Boyolali", "Brebes","Cilacap","Demak","Grobogan","Jepara","Karanganyar","Kebumen","Kendal","Klaten","Kudus","Magelang","Pati","Pekalongan","Pemalang","Purbalingga","Purworejo","Rembang","Semarang","Sragen","Sukoharjo","Tegal","Temanggung","Wonogiri","Wonosobo","Kota Magelang","Kota Pekalongan","Kota Salatiga","Kota Semarang","Kota Surakarta","Kota Tegal"],
              datasets: [{
                label: 'Data Agro',
                data: [
                <? echo $row1[0];?>,
                <? echo $row2[0];?>,
                <? echo $row3[0];?>,
                <? echo $row4[0];?>,
                <? echo $row5[0];?>,
                <? echo $row6[0];?>,
                <? echo $row7[0];?>,
                <? echo $row8[0];?>,
                <? echo $row9[0];?>,
                <? echo $row10[0];?>,
                <? echo $row11[0];?>,
                <? echo $row12[0];?>,
                <? echo $row13[0];?>,
                <? echo $row14[0];?>,
                <? echo $row15[0];?>,
                <? echo $row16[0];?>,
                <? echo $row17[0];?>,
                <? echo $row18[0];?>,
                <? echo $row19[0];?>,
                <? echo $row20[0];?>,
                <? echo $row21[0];?>,
                <? echo $row22[0];?>,
                <? echo $row23[0];?>,
                <? echo $row24[0];?>,
                <? echo $row25[0];?>,
                <? echo $row26[0];?>,
                <? echo $row27[0];?>,
                <? echo $row28[0];?>,
                <? echo $row29[0];?>,
                <? echo $row30[0];?>,
                <? echo $row31[0];?>,
                <? echo $row32[0];?>,
                <? echo $row33[0];?>,
                <? echo $row34[0];?>,
                <? echo $row35[0];?>
                ],
                backgroundColor: [
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)',
                'rgba(54, 162, 235, 0.2)'
                ],
                borderColor: [
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)',
                'rgba(54, 162, 235, 1)'
                ],
                borderWidth: 1
              }]
            },
            options: {
              scales: {
                yAxes: [{
                  ticks: {
                    beginAtZero:true
                  }
                }]
              }
            }
          });
        </script>

			</div><!--/ Content row end -->


		</div><!--/ 1st container end -->

    <section class="call-to-action">
  			<div class="container">
  				<div class="row">
  					<div class="col-sm-12">
  						<h3>Bergabunglah dengan Layanan Pojok Akuntansi</h3>
  						<a href="#" class="pull-right btn btn-primary white">Daftar Sekarang</a>
  					</div>
  				</div>
  			</div>
  		</section>
		<div class="gap-60"></div>


	</section><!--/ Main container end -->


	<div class="gap-40"></div>


	<!-- Footer start -->
	<section id="copyright" class="copyright angle">
		<div class="container">
			<div class="row">
				<div class="col-md-12 text-center">
					<ul class="footer-social unstyled">

					</ul>
				</div>
			</div><!--/ Row end -->
			<div class="row">
				<div class="col-md-12 text-center">
					<div class="copyright-info">
         			 &copy; Copyright <? echo date("Y")?> SIIDa. <span>Designed by <a href="https://ichahouse.com">masbam</a></span>
        			</div>
				</div>
			</div><!--/ Row end -->
		   <div id="back-to-top" data-spy="affix" data-offset-top="10" class="back-to-top affix">
				<button class="btn btn-primary" title="Back to Top"><i class="fa fa-angle-double-up"></i></button>
			</div>
		</div><!--/ Container end -->
	</section><!--/ Footer end -->

	<!-- Javascript Files
	================================================== -->

	<!-- initialize jQuery Library -->
	<script type="text/javascript" src="js/jquery.js"></script>
	<!-- Bootstrap jQuery -->
	<script type="text/javascript" src="js/bootstrap.min.js"></script>
	<!-- Style Switcher -->
	<script type="text/javascript" src="js/style-switcher.js"></script>
	<!-- Owl Carousel -->
	<script type="text/javascript" src="js/owl.carousel.js"></script>
	<!-- PrettyPhoto -->
	<script type="text/javascript" src="js/jquery.prettyPhoto.js"></script>
	<!-- Bxslider -->
	<script type="text/javascript" src="js/jquery.flexslider.js"></script>
	<!-- Owl Carousel -->
	<script type="text/javascript" src="js/cd-hero.js"></script>
	<!-- Isotope -->
	<script type="text/javascript" src="js/isotope.js"></script>
	<script type="text/javascript" src="js/ini.isotope.js"></script>
	<!-- Wow Animation -->
	<script type="text/javascript" src="js/wow.min.js"></script>
	<!-- SmoothScroll -->
	<script type="text/javascript" src="js/smoothscroll.js"></script>
	<!-- Eeasing -->
	<script type="text/javascript" src="js/jquery.easing.1.3.js"></script>
	<!-- Counter -->
	<script type="text/javascript" src="js/jquery.counterup.min.js"></script>
	<!-- Waypoints -->
	<script type="text/javascript" src="js/waypoints.min.js"></script>
	<!-- Template custom -->
	<script type="text/javascript" src="js/custom.js"></script>

	</div><!-- Body inner end -->
</body>
</html>
<?
$lihat="Grafik Agro";

include "log.php";
mysqli_close($db);
?>