Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!-- <html>
- <head>
- <title>Dynamic Column Chart in Codeigniter using Ajax</title>
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
- <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
- </head>
- <body> -->
- <style>
- div#example1_filter {
- float: right;
- }
- </style>
- <section class="content container-fluid">
- <div class="box">
- <div class="box-header with-border">
- <h3 class="box-title">Grafik Kegiatan Per Sekolah</h3>
- <div class="box-tools pull-right">
- <button type="button" class="btn btn-box-tool" data-widget="collapse" data-toggle="tooltip" title="Collapse">
- <i class="fa fa-minus"></i></button>
- </div>
- </div>
- <div class="box-body">
- <div style="margin-bottom: 20px;">
- <div class="panel panel-default">
- <div class="panel-heading">
- <div class="row">
- <div class="col-md-3">
- <small class="text-muted">Nama Sekolah</small>
- <select name="id_sekolah" id="id_sekolah" class="form-control">
- <option value="">Select Id sekolah</option>
- <?php
- foreach ($id_sekolah->result_array() as $row) {
- echo '<option name="' . $row["nama_sekolah"] . '" value="' . $row["id_sekolah"] . '">' . $row["nama_sekolah"] . '</option>';
- }
- ?>
- </select>
- </div>
- <div class="col-md-3">
- <small class="text-muted">Tanggal Awal</small>
- <input type="date" name="tgl_awal" id="tgl_awal" class="form-control">
- </div>
- <div class="col-md-3">
- <small class="text-muted">Tanggal Akhir</small>
- <input type="date" name="tgl_akhir" id="tgl_akhir" class="form-control">
- </div>
- <div class="col-md-3">
- <small class="text-muted"><br></small>
- <input type="submit" class="btn btn-primary" value="filter" name="filter" id="filter">
- </div>
- </div>
- </div>
- <div class="panel-body">
- <div id="chart_area" style="width: 1000px; height: 620px;"></div>
- </div>
- </div>
- </div>
- </div>
- </div>
- </section>
- <!-- </body>
- </html> -->
- <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
- <script type="text/javascript">
- google.charts.load('current', {
- 'packages': ['corechart', 'line']
- });
- google.charts.setOnLoadCallback();
- function load_monthwise_data(id_sekolah, tgl_awal, tgl_akhir, title) {
- var temp_title = title + ' ' + id_sekolah + ' ' + tgl_awal + ' ' + tgl_akhir;
- $.ajax({
- url: "<?php echo base_url('grafik/fetch_data'); ?>",
- method: "POST",
- data: {
- id_sekolah: id_sekolah,
- tgl_awal: tgl_awal,
- tgl_akhir: tgl_akhir
- },
- dataType: "JSON",
- success: function(data) {
- drawMonthwiseChart(data, temp_title);
- }
- });
- }
- function drawMonthwiseChart(chart_data, chart_main_title) {
- var jsonData = chart_data;
- var data = new google.visualization.DataTable();
- data.addColumn('string', 'Tgl Kegiatan');
- data.addColumn('number', 'Nilai');
- $.each(jsonData, function(i, jsonData) {
- var label = 1;
- // rowCount = jsonData.id_sekolah.length - 1;
- // for (var i = 1; i < jsonData.id_sekolah.length; i++) {
- // sumVal = label + parseInt(jsonData.nilai[i]);
- // }(jsonData.nilai + jsonData.nilai) / (label += jsonData.id_sekolah - 1);
- // hasil = parseInt(sumVal / rowCount);
- var tgl_kegiatan = jsonData.tgl_kegiatan;
- var nilai = jsonData.nilai;
- data.addRows([
- [tgl_kegiatan, nilai]
- ]);
- });
- var options = {
- title: chart_main_title,
- hAxis: {
- title: "Tgl"
- },
- vAxis: {
- title: 'Nilai'
- },
- chartArea: {
- width: '80%',
- height: '85%'
- }
- }
- var chart = new google.visualization.LineChart(document.getElementById('chart_area'));
- chart.draw(data, options);
- }
- </script>
- <script type="text/javascript">
- $(document).ready(function() {
- $('#filter').click(function() {
- var id_sekolah = $('#id_sekolah').val();
- var tgl_awal = $('#tgl_awal').val();
- var tgl_akhir = $('#tgl_akhir').val();
- if (id_sekolah != '' & tgl_awal != '' & tgl_akhir != '') {
- load_monthwise_data(id_sekolah, tgl_awal, tgl_akhir);
- }
- });
- });
- </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement