<?php include "common/user_log.php"; ?>

<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>Sampathbay</title>
    <!-- Place favicon.ico in the root directory -->
   <link rel="shortcut icon" type="image/x-icon" href="../img/S_favicon.ico"> 
    <!-- Tell the browser to be responsive to screen width -->
    <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
    <!-- Bootstrap 3.3.5 -->
    <link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
    <!-- Font Awesome -->
    <link rel="stylesheet" href="dist/css/font-awesome.min.css">
    <!-- Ionicons -->
    <link rel="stylesheet" href="dist/css/ionicons.min.css">
    <!-- daterange picker -->
    <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker-bs3.css">
    <!-- iCheck for checkboxes and radio inputs -->
    <link rel="stylesheet" href="plugins/iCheck/all.css">
    <!-- Bootstrap Color Picker -->
    <link rel="stylesheet" href="plugins/colorpicker/bootstrap-colorpicker.min.css">
    <!-- Bootstrap time Picker -->
    <link rel="stylesheet" href="plugins/timepicker/bootstrap-timepicker.min.css">
    <!-- Select2 -->
    <link rel="stylesheet" href="plugins/select2/select2.min.css">
	<!-- DataTables -->
    <link rel="stylesheet" href="plugins/datatables/dataTables.bootstrap.css">
    <!-- Theme style -->
    <link rel="stylesheet" href="dist/css/AdminLTE.min.css">
    <!-- AdminLTE Skins. Choose a skin from the css/skins
         folder instead of downloading all of them to reduce the load. -->
    <link rel="stylesheet" href="dist/css/skins/_all-skins.min.css">
    <link rel="stylesheet" href="bootstrap-sweetalert/lib/sweet-alert.css" />
    <link rel="stylesheet" href="amcharts/style.css" type="text/css">
    <script src="amcharts/amcharts.js" type="text/javascript"></script>
    <script src="amcharts/serial.js" type="text/javascript"></script>
 <!-- combo -->
<style type="text/css">
#form1 p {
}
#apDiv1 {
	position:absolute;
	width:200px;
	height:23px;
	z-index:1;
	left: 164px;
	top: 420px;
}
</style>


<!--GET SUBCATAGORIES FROM A CATAGORY-->
  </head>
  <body class="hold-transition skin-blue sidebar-mini">
    <div class="wrapper">

      <header class="main-header">
        <!-- Logo -->
          <a href="home.php" class="logo">
          <!-- mini logo for sidebar mini 50x50 pixels -->
         <span class="logo-mini"><img src="img/logo_mini.png" width="50"></span>
          <!-- logo for regular state and mobile devices -->
        <span class="logo-lg"><b><img src="img/logo.png" width="200"></b></span>
        </a>
        <!-- Header Navbar: style can be found in header.less -->
        <nav class="navbar navbar-static-top" role="navigation">
          <!-- Sidebar toggle button-->
          <a href="#" class="sidebar-toggle" data-toggle="offcanvas" role="button">
            <span class="sr-only">Toggle navigation</span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
			 <span class="logo-lg">
             &nbsp;&nbsp;<font face="Lucida Sans Unicode, Lucida Grande, sans-serif">Sampathbay</font></span>
          </a>
		
          <div class="navbar-custom-menu">
            <ul class="nav navbar-nav">

              <!-- User Account: style can be found in dropdown.less -->
              <li class="dropdown user user-menu">
                <a href="#" class="dropdown-toggle" data-toggle="dropdown">
                  <img src="dist/img/user2-160x160.png" class="user-image" alt="User Image">
                  <span class="hidden-xs"><?php echo $name; ?></span>
                </a>
                <ul class="dropdown-menu">
                  <!-- User image -->
                  <li class="user-header">
                    <img src="dist/img/user2-160x160.png" class="img-circle" alt="User Image">
                    <p>
                Sampathbay 
                    
                    </p>
                  </li>
                  <!-- Menu Body -->
                 
                  <!-- Menu Footer-->
                  <li class="user-footer">
                    <div class="pull-left">
                      
                    </div>
                    <div class="pull-right">
                      <a href="distroy.php" class="btn btn-default btn-flat">Sign out</a>
                    </div>
                  </li>
                </ul>
              </li>
              <!-- Control Sidebar Toggle Button -->
              <li>
                <a href="#" data-toggle="control-sidebar"><i class="fa fa-gears"></i></a>
              </li>
            </ul>
          </div>
        </nav>
      </header>
      <!-- Left side column. contains the logo and sidebar -->
      <aside class="main-sidebar">
        <!-- sidebar: style can be found in sidebar.less -->
        <section class="sidebar">
          <!-- Sidebar user panel -->
          
        <?php include "common/sidebar.php"; ?> 
        
        </section>
        <!-- /.sidebar -->
      </aside>

      <!-- Content Wrapper. Contains page content -->
      <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
          <h1>
            Item wise Sales
          </h1>
          
    <ol class="breadcrumb">
      <li><a href="home.php"><i class="fa fa-home"></i> Home</a></li>
    </ol>
        </section>

        <!-- Main content -->
        <section class="content">

<!-- ************************************************* -->


 <div class="box box-info"> 
          <div class="box-header with-border"> 
            <h3 class="box-title">Item Details</h3>
          </div>
		  
            <div class="box-body"> 
			
		      <form id="itm_form" action="" method="post">

						  <!-- text area input -->
            <div class="form-group">
              <label>Select Category:<font color="#FF0000"><strong>*</strong></font></label>
              <!-- <select class="form-control select2" name="cat_id" id="main_cats" style="width: 100%;"><option>Test</option></select> -->
              <select class="form-control" name="cat_main" id="cat_main"> <option>Select Main Category...</option> </select>
              <span id="cat_val_msg" style="color: red; display: none">*Select Main Category</span>
            </div>

            <!-- text area input -->
            <div class="form-group">
              <label>Select Sub Category:<font color="#FF0000"><strong>*</strong></font></label>
              <!-- <select class="form-control select2" name="cat_id" id="main_cats" style="width: 100%;"><option>Test</option></select> -->
              <select class="form-control" name="sub_cat" id="sub_cat"> <option value="empty">Select Sub Category...</option> </select>
              <span id="subcat_val_msg" style="color: red; display: none">*Select Sub Category</span>
            </div>

            <!-- text area input -->
            <div class="form-group">
              <label>Select Item:<font color="#FF0000"><strong>*</strong></font></label>
              <!-- <select class="form-control select2" name="cat_id" id="main_cats" style="width: 100%;"><option>Test</option></select> -->
              <select class="form-control" name="item" id="item"> <option value="empty">Select Item...</option> </select>
              <span id="op_val_msg" style="color: red; display: none">*Select item first</span>
            </div>

            <div class="form-group">
              <label>Select Year:<font color="#FF0000"><strong>*</strong></font></label>
              <input class="date-own form-control" name="year" style="width: 300px;" type="text">
              <span id="op_val_msg_year" style="color: red; display: none">*Select Year</span>
            </div>
            <div class="form-group">
              <input type="submit" name="btn_sub" class="btn btn-primary">
            </div>
        </form>
			</div>
      </div>
                  





 <!-- /.table -->
        
    <div class="box box-info"> 
      <div class="box-header"> 
        
      </div>
      <!-- /.box-header -->
      <div class="box-body"> 
        <div id="chartdiv" style="width: 100%; height: 500px; background-color:#fff;"></div>
        <script type="text/javascript">
        AmCharts.makeChart("chartdiv",
          {
            "type": "serial",
            "categoryField": "category",
            "startDuration": 1,
            "categoryAxis": {
              "gridPosition": "start"
            },
            "chartCursor": {
              "bulletsEnabled": true,
              "fullWidth": true,
              "valueLineAlpha": 0.06
            },
            "chartScrollbar": {},
            "trendLines": [],
            "graphs": [
              {
                "balloonText": "[[title]] of [[category]]:[[value]]",
                "bullet": "round",
                "id": "AmGraph-1",
                "title": "Sales Quantity",
                "valueField": "Income"
              },

            ],
            "guides": [],
            "valueAxes": [
              {
                "id": "ValueAxis-1",
                "title": "Quantity"
              }
            ],
            "allLabels": [],
            "balloon": {
              "animationDuration": 0.08
            },
            "legend": {
              "useGraphSettings": true
            },
            "titles": [
              {
                "id": "Title-1",
                "size": 15,
                "text": "Item wise Sales"
              }
            ],
            "dataProvider": [       
              <?php   
              
              $month = array(1,2,3,4,5,6,7,8,9,10,11,12);

              foreach ($month as $key => $value) {
                //$s2 = 0; 
                
                if (isset($_POST['item']) AND isset($_POST['year'])) {

                  $sqlch="SELECT SUM(`Qty`) AS qty FROM `cart_details` WHERE Item_Code=$item AND EXTRACT(MONTH FROM order_date) = $value AND EXTRACT(YEAR FROM order_date) = $year";
                  $resultch=mysqli_query($conn,$sqlch);
                  $rowch = mysqli_fetch_array($resultch);
                  if ($rowch['qty'] === NULL) {
                    $s1 = 0;
                  }else{
                    $s1 = $rowch['qty'];
                  }
                  //$s1=10;
                }else{
                  $s1 = 0;
                }
              ?>                  
              {
                "category": "<?php echo $value; ?>",
                "Income": <?php echo $s1; ?>,
              },            
              <?php } ?>
            ]
          }
        );

      </script>
      </div>
      <!-- /.box-body -->
    </div>
    
    </section>
    
      </div>
	      <!-- /.End table -->
<!-- ************************************************* -->
      
           <!-- /.col -->
              </div><!-- /.row -->
            </div><!-- /.box-body -->
            
          

          <div class="row">
            
    
    
      </div>
      <!-- /.col (right) -->
         

      </div>

<footer class="main-footer"> 
<div class="pull-right hidden-xs">
          
        </div>  <strong>Copyright &copy; Sampathbay</strong> All rights reserved.
      </footer>

      <!-- Control Sidebar -->
      <aside class="control-sidebar control-sidebar-dark">
        <!-- Create the tabs -->
        <ul class="nav nav-tabs nav-justified control-sidebar-tabs">
          <li><a href="#control-sidebar-home-tab" data-toggle="tab"><i class="fa fa-home"></i></a></li>
          <li><a href="#control-sidebar-settings-tab" data-toggle="tab"><i class="fa fa-gears"></i></a></li>
        </ul>
        <!-- Tab panes -->
        <div class="tab-content">
          <!-- Home tab content -->
          <div class="tab-pane" id="control-sidebar-home-tab">

          </div><!-- /.tab-pane -->
         
          </div><!-- /.tab-pane -->
        </div>
      </aside><!-- /.control-sidebar -->
      <!-- Add the sidebar's background. This div must be placed
           immediately after the control sidebar -->
      <div class="control-sidebar-bg"></div>
    </div><!-- ./wrapper -->


    <!-- jQuery 2.1.4 -->
    <script src="plugins/jQuery/jQuery-2.1.4.min.js"></script>
    <!-- Bootstrap 3.3.5 -->
    <script src="bootstrap/js/bootstrap.min.js"></script>
    <!-- Select2 -->
    <script src="plugins/select2/select2.full.min.js"></script>
	<!-- DataTables -->
    <script src="plugins/datatables/jquery.dataTables.min.js"></script>
    <script src="plugins/datatables/dataTables.bootstrap.min.js"></script>
    <!-- InputMask -->
    <script src="plugins/input-mask/jquery.inputmask.js"></script>
    <script src="plugins/input-mask/jquery.inputmask.date.extensions.js"></script>
    <script src="plugins/input-mask/jquery.inputmask.extensions.js"></script>
    <!-- date-range-picker -->
    <script src="plugins/daterangepicker/moment.min.js"></script>
    <script src="plugins/daterangepicker/daterangepicker.js"></script>
    <!-- bootstrap color picker -->
    <script src="plugins/colorpicker/bootstrap-colorpicker.min.js"></script>
    <!-- bootstrap time picker -->
    <script src="plugins/timepicker/bootstrap-timepicker.min.js"></script>
    <!-- SlimScroll 1.3.0 -->
    <script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>
    <!-- iCheck 1.0.1 -->
    <script src="plugins/iCheck/icheck.min.js"></script>
    <!-- FastClick -->
    <script src="plugins/fastclick/fastclick.min.js"></script>
    <!-- AdminLTE App -->
    <script src="dist/js/app.min.js"></script>
    <!-- AdminLTE for demo purposes -->
    <script src="dist/js/demo.js"></script>
    <script src="bootstrap-sweetalert/lib/sweet-alert.min.js"></script>
    <script src="input-mask/input-mask.min.js"></script>

    
    <!-- Page script -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.5.0/js/bootstrap-datepicker.js"></script>
    <link href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.5.0/css/bootstrap-datepicker.css" rel="stylesheet">
    <script type="text/javascript">
      $('.date-own').datepicker({
         minViewMode: 2,
         format: 'yyyy'
       });
    </script>
    <script>
      /*$(function () {
        //Initialize Select2 Elements
        $(".select2").select2();

        //Datemask dd/mm/yyyy
        $("#datemask").inputmask("dd/mm/yyyy", {"placeholder": "yyyy-mm-dd"});
        //Datemask2 mm/dd/yyyy
        $("#datemask2").inputmask("mm/dd/yyyy", {"placeholder": "yyyy-mm-dd"});
        //Money Euro
        $("[data-mask]").inputmask();

        //Date range picker
        $('#reservation').daterangepicker();
        //Date range picker with time picker
		   $('#reservationtime').daterangepicker({timePicker: false, timePickerIncrement: 30, format: 'YYYY-MM-DD'});
        //Date range as a button
        $('#daterange-btn').daterangepicker(
            {
              ranges: {
                'Today': [moment(), moment()],
                'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
                'Last 7 Days': [moment().subtract(6, 'days'), moment()],
                'Last 30 Days': [moment().subtract(29, 'days'), moment()],
                'This Month': [moment().startOf('month')],
                'Last Month': [moment().subtract(1, 'month').startOf('month')]
              },
              startDate: moment().subtract(29, 'days'),
           
            },
        function (start) {
          $('#reportrange span').html(start.format('MMMM D, YYYY'));
        }
        );

        //iCheck for checkbox and radio inputs
        $('input[type="checkbox"].minimal, input[type="radio"].minimal').iCheck({
          checkboxClass: 'icheckbox_minimal-blue',
          radioClass: 'iradio_minimal-blue'
        });
        //Red color scheme for iCheck
        $('input[type="checkbox"].minimal-red, input[type="radio"].minimal-red').iCheck({
          checkboxClass: 'icheckbox_minimal-red',
          radioClass: 'iradio_minimal-red'
        });
        //Flat red color scheme for iCheck
        $('input[type="checkbox"].flat-red, input[type="radio"].flat-red').iCheck({
          checkboxClass: 'icheckbox_flat-green',
          radioClass: 'iradio_flat-green'
        });

        
      });*/

      function data_load(){
        $.post('function/sub_cat.php', {'load_subcat': 'data'}, function (data) {
          $("#cat_main").html(data);
        });
        
      }
      function load_subcat(id){
        $.post('function/add_options_to_item_back.php', {'load_subcat': 'data' , id : id}, function (data) {
          $("#sub_cat").html(data);
        });
      }

      $(document).ready(function(){
        data_load();



        $("#cat_main").change(function(){
          var val = $(this).val();
          load_subcat(val);
        })

        $("#sub_cat").on('change',function(){
          if ([!$("#cat_main")=='empty'] && [!$("#sub_cat")=='empty']) {
            var main = $("#cat_main").val();
            var sub_cat = $("#sub_cat").val();
            $.post('function/add_options_to_item_back.php', {'load_items': 'data' , main : main , sub_cat : sub_cat}, function (data) {
              $("#item").html(data);
            });
          }
        });

      });

    </script>



        


	
	<script>
      $(function () {
        $("#example1").DataTable();
        $('#example2').DataTable({
          "paging": true,
          "lengthChange": false,
          "searching": false,
          "ordering": true,
          "info": true,
          "autoWidth": false
        });
      });
    </script>
  </body>
</html>
