grafik_kiloan_dll.php

<?
include 'head.php';
include 'sidebar.php';
include 'topbar.php';

mysql_connect( 'localhost','root','' );
mysql_select_db( 'quickly' );

// BEGIN DECLARATION
$bulan = $_POST['bulan'];
$tahun = $_POST['tahun'];
$bulan2 = $_POST['bulan2'];
$hariini = date("Y-m-d h:is");
// END DECLARATION
?>

<!-- page content -->
<div class="right_col" role="main">
  <div class="">
    <div class="clearfix"></div>
    <div class="row" id="noprint">
      <div class="col-md-12 col-xs-12">
        <div class="x_panel">

          <div class="x_title">
            <h2>Form Filter<small></small></h2>
            <div class="clearfix"></div>
          </div>
          <div class="x_content">
            <br />
            <form role="form" class="form-horizontal form-label-left" method="POST"> <!-- Important: method="POST" -->

              <div class="form-group">
                <label class="control-label col-md-3 col-sm-3 col-xs-12">Tahun</label>
                <div class="col-md-6 col-sm-6 col-xs-12">
                  <select class="form-control select2" name="tahun" required>
                    <option value="" disabled selected>--Pilih Tahun--</option>
                    <?
                    $year = date("Y");
                    $newyear = strtotime('-2 year', strtotime($year));
                    $year2 = date("Y", $newyear);
                    for($i=$year2;$i<=date("Y");$i++) {
                      ?>
                      <option><?=$i?></option>
                      <?
                    }
                    ?>
                  </select>
                </div>
              </div>

              <div class="form-group">
                <label class="control-label col-md-3 col-sm-3 col-xs-12">Bulan</label>
                <div class="col-md-3 col-sm-3 col-xs-12">
                  <select class="form-control select2" name="bulan" required>
                    <option value="" disabled selected>--Pilih Bulan Mulai--</option>
                    <option value="01" > Januari </option>
                    <option value="02" > Februari </option>
                    <option value="03" > Maret </option>
                    <option value="04" > April </option>
                    <option value="05" > Mei </option>
                    <option value="06" > Juni </option>
                    <option value="07" > Juli </option>
                    <option value="08" > Agustus </option>
                    <option value="09" > September </option>
                    <option value="10" > Oktober </option>
                    <option value="11" > November </option>
                    <option value="12" > Desember </option>
                  </select>
                </div>
                <div class="col-md-3 col-sm-3 col-xs-12">
                  <select class="form-control select2" name="bulan2" required>
                    <option value="" disabled selected>--Pilih Bulan Selesai--</option>
                    <option value="01" > Januari </option>
                    <option value="02" > Februari </option>
                    <option value="03" > Maret </option>
                    <option value="04" > April </option>
                    <option value="05" > Mei </option>
                    <option value="06" > Juni </option>
                    <option value="07" > Juli </option>
                    <option value="08" > Agustus </option>
                    <option value="09" > September </option>
                    <option value="10" > Oktober </option>
                    <option value="11" > November </option>
                    <option value="12" > Desember </option>
                  </select>
                </div>
                <button type="submit" class="btn btn-success" name="submit" value="action"><i class="fa fa-download"></i></button>
              </div>
            </form>
          </div>
        </div>
      </div>
    </div>

    <?
    $query = mysql_query("
      SELECT (temp.bulan) AS bulanx FROM (
      (SELECT month(a.datecreated) bulan FROM transaksi_kiloan a WHERE month(a.datecreated) >= '$bulan' AND month(a.datecreated) <= '$bulan2' GROUP BY month(a.datecreated))
      UNION
      (SELECT month(b.datecreated) bulan FROM transaksi_potongan b WHERE month(b.datecreated) >= '$bulan' AND month(b.datecreated) <= '$bulan2' GROUP BY month(b.datecreated))
      ) AS temp");
    $data = mysql_fetch_array($query);
    $bulanx = $data['bulanx'];
    ?>

    <script type="text/javascript" src="js/jquery.min.js"></script>
    <script type="text/javascript">
      $(function () {
        var chart;
        $(document).ready(function() {
          chart = new Highcharts.Chart({
            chart: {
              renderTo: 'container',
              type: 'column',
              marginRight: 130,
              marginBottom: 25
            },
            title: {
              text: 'Grafik Pendapatan Bersih',
                x: -20 //center
              },
              subtitle: {
                text: 'Bulan (<?=$bulan?> - <?=$bulan2?>) Tahun <?=$tahun?>',
                x: -20
              },
              xAxis: {
                categories: ['', 'Jan', 'Feb', 'Maret', 'April', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember']
              },
              yAxis: {
                title: {
                  text: 'Pendapatan Bersih'
                },
                plotLines: [{
                  value: 0,
                  width: 1,
                  color: '#808080'
                }]
              },
              tooltip: {
                formatter: function() {
                  return '<b>' + this.series.name
                  + '</b><br/>' + this.x + ': ' + this.y + ' Rupiah';
                }
              },
              legend: {
                layout: 'vertical',
                align: 'right',
                verticalAlign: 'top',
                x: -0,
                y: 100,
                borderWidth: 0
              },
              series: [
              <?
              $kiloan = $potongan = $total = array_fill(0,12,0);

              // Query Perhitungan Kiloan
              $sql = "SELECT month(datecreated) AS bln, SUM(total-totalgaji) AS kiloan FROM transaksi_kiloan WHERE month(datecreated) BETWEEN '$bulan' AND '$bulan2' AND year(datecreated) = '$tahun' GROUP BY bln";
              $query = mysql_query($sql);
              while ($data = mysql_fetch_array($query)) {
                $bln = $data['bln'];
                $jml = $data['kiloan'];
                $kiloan[$bln-1] = $jml;
              }
              mysql_free_result($query);

              // Query Perhitungan Potongan
              $sql = "SELECT month(datecreated) AS bln, SUM(grandtotal-grandtotalgaji) AS potongan FROM transaksi_potongan WHERE month(datecreated) BETWEEN '$bulan' AND '$bulan2' AND year(datecreated) = '$tahun' GROUP BY bln";
              $query = mysql_query($sql);
              while ($data = mysql_fetch_array($query)) {
                $bln = $data['bln'];
                $jml = $data['potongan'];
                $potongan[$bln-1] = $jml;
              }
              mysql_free_result($query);

              // Query Perhitungan Total
              $sql = "SELECT temp.bln AS bln, SUM(temp.pendapatan-temp.pengeluaran) AS total FROM
              ((SELECT month(a.datecreated) bln, SUM(a.total) pendapatan, SUM(a.totalgaji) pengeluaran FROM transaksi_kiloan a WHERE month(a.datecreated) BETWEEN '$bulan' AND '$bulan2' AND year(a.datecreated) = '$tahun' GROUP BY bln)
              UNION
              (SELECT month(b.datecreated) bln, SUM(b.grandtotal) pendapatan, SUM(b.grandtotalgaji) pengeluaran FROM transaksi_potongan b WHERE month(b.datecreated) BETWEEN '$bulan' AND '$bulan2' AND year(b.datecreated) = '$tahun' GROUP BY bln))
              AS temp GROUP BY bln";
              $query = mysql_query($sql);
              while ($data = mysql_fetch_array($query)) {
                $bln = $data['bln'];
                $jml = $data['total'];
                $total[$bln-1] = $jml;
              }
              mysql_free_result($query);
             ?>
               {
                 pointStart: <?=$bulanx?>,
                 name: 'Kiloan',
                 data: [<? echo implode(',',$kiloan); ?>]
               },
               {
                 pointStart: <?=$bulanx?>,
                 name: 'Potongan',
                 data: [<? echo implode(',',$potongan); ?>]
               },
               {
                 pointStart: <?=$bulanx?>,
                 name: 'Total',
                 data: [<? echo implode(',',$total); ?>]
               }
               ]
        });
        });
      });
    </script>

    <div class="row">
      <div class="col-md-12">
        <div class="x_panel">
          <div class="x_content" id="container">
            <script src="js/highchart/highcharts.js"></script>
            <script src="js/highchart/modules/exporting.js"></script>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>
<!-- /page content -->
<? include 'footer.php'; ?>