<?php $this->load->view("common/header"); ?>
<!-- end: HEAD -->

<!-- start: CSS REQUIRED FOR THIS PAGE ONLY -->
<link rel="stylesheet" type="text/css" href="<?php echo asset_url(); ?>plugins/select2/select2.css" />
<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/DataTables/media/css/DT_bootstrap.css" />
<link href="<?php echo asset_url(); ?>plugins/bootstrap-modal/css/bootstrap-modal-bs3patch.css" rel="stylesheet" type="text/css"/>
<link href="<?php echo asset_url(); ?>plugins/bootstrap-modal/css/bootstrap-modal.css" rel="stylesheet" type="text/css"/>
<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/bootstrap-fileupload/bootstrap-fileupload.min.css">
<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/select2/select2.css">
<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/select2/select2.css">
<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/datepicker/css/datepicker.css">
<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/bootstrap-timepicker/css/bootstrap-timepicker.min.css">
<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/bootstrap-daterangepicker/daterangepicker-bs3.css">
<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/bootstrap-colorpicker/css/bootstrap-colorpicker.css">
<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/jQuery-Tags-Input/jquery.tagsinput.css">
<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/bootstrap-fileupload/bootstrap-fileupload.min.css">
<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/summernote/build/summernote.css">
<style type="text/css">
.table > thead:first-child > tr:first-child > th, .table > thead:first-child > tr:first-child > td, .table-striped thead tr.primary:nth-child(2n+1) th {
	background-color: #428bca;
	border-color: #357ebd;
	border-top: 1px solid #357ebd;
	color: white;
	text-align: center;
}
</style>
<style>
.loader {
  border: 16px solid #f3f3f3;
  border-radius: 50%;
  border-top: 16px solid #3498db;
  width: 240px;
  height: 240px;
  -webkit-animation: spin 2s linear infinite; /* Safari */
  animation: spin 2s linear infinite;
}

/* Safari */
@-webkit-keyframes spin {
  0% { -webkit-transform: rotate(0deg); }
  100% { -webkit-transform: rotate(360deg); }
}

@keyframes spin {
  0% { transform: rotate(0deg); }
  100% { transform: rotate(360deg); }
}
</style>
<!-- end: CSS REQUIRED FOR THIS PAGE ONLY -->
<!-- end: HEAD -->
<!-- start: BODY -->
<body>
<!-- start: HEADER -->
<div class="navbar navbar-inverse navbar-fixed-top"> 
  <!-- start: TOP NAVIGATION CONTAINER -->
  <div class="container">
    <div class="navbar-header"> 
      <!-- start: RESPONSIVE MENU TOGGLER -->
      <button data-target=".navbar-collapse" data-toggle="collapse" class="navbar-toggle" type="button"> <span class="clip-list-2"></span> </button>
      <!-- end: RESPONSIVE MENU TOGGLER --> 
      <!-- start: LOGO -->
      <?php $this->load->view("common/logo"); ?>
      <!-- end: LOGO --> 
    </div>
    <div class="navbar-tools"> 
      <!-- start: TOP NAVIGATION MENU -->
      <?php $this->load->view("common/notifications.php"); ?>
      <!-- end: TOP NAVIGATION MENU --> 
    </div>
  </div>
  <!-- end: TOP NAVIGATION CONTAINER --> 
</div>
<!-- end: HEADER --> 
<!-- start: MAIN CONTAINER -->
<div class="main-container">
<div class="navbar-content"> 
  <!-- start: SIDEBAR -->
  <?php $this->load->view("common/navigation"); ?>
  <!-- end: SIDEBAR --> 
</div>
<!-- start: PAGE -->
<div class="main-content"> 
  <!-- end: SPANEL CONFIGURATION MODAL FORM -->
  <div class="container"> 
    <!-- start: PAGE HEADER -->
    <div class="row">
      <div class="col-sm-12"> 
        <!-- start: PAGE TITLE & BREADCRUMB -->
        <ol class="breadcrumb">
          <li> <a href="<?php echo base_url('dashboard'); ?>"> Dashboard </a> </li>
          <li> <a href="#"> Reports </a> </li>
          <li class="active"> Product Item Sale Value Report </li>
          <li class="search-box">
            <form class="sidebar-search">
              <div class="form-group">
                <input type="text" placeholder="Start Searching...">
                <button class="submit"> <i class="clip-search-3"></i> </button>
              </div>
            </form>
          </li>
        </ol>
        <div class="page-header">
          <h1>Product Item Sale Value Report </h1>
        </div>
        <p>Please use the table below to navigate or filter the results. </p>
      </div>
    </div>
    <!-- end: PAGE HEADER --> 
    <!-- start: PAGE CONTENT 
                    <!-- start grid -->
    <div class="row">
      <div class="col-md-12"> 
        <!-- start: DYNAMIC TABLE PANEL -->
        <div class="panel panel-default">
          <div class="panel-heading"> <i class="fa fa-external-link-square"></i> Product Item Sale Value Report
            <div class="panel-tools" style="top:2px;">
              <button onClick="printDiv('printableArea')" class="btn btn-blue dropdown-toggle" data-toggle="dropdown"> <i class="fa fa-print"></i> </button>
            </div>
          </div>
        </div>
        <div class="panel-body">
          <div id="error"></div>
          <div class="col-md-12">
            <div class="panel panel-default">
              <div style="font-weight: 700;" class="panel-heading"></div>
              <div class="panel-body">
                <div class="col-sm-3">
                  <div class="form-group">
                    <label>Warehouse </label>
                    <select id="srh_warehouse_id" class="form-control" name="srh_warehouse_id">
                      <!-- <option value="">-- Select Warehouse --</option>-->
                      <?php 
																 $ss_warehouse_id=$this->session->userdata('ss_warehouse_id'); 
                                                              foreach ($warehouse_list as $row)
                                                              {
																  $sel='';
																  if($ss_warehouse_id==$row->id)
																  {
																	  $sel=' selected="selected"';
																  }
                                                              ?>
                      <option value="<?php echo $row->id; ?>" <?php echo $sel; ?>> <?php echo $row->name; ?> </option>
                      <?php }?>
                    </select>
                  </div>
                </div>
                
                 <div class="col-sm-3" style="display: none;" >
                  <div class="form-group">
                    <label>Sift </label>
                    <select id="float_id" class="form-control" name="float_id">
                      <option value="">-- All Sifts --</option>
                      <?php   //foreach ($floate_list as $row) {?>
                      <option value="<?php //echo $row['c_float_mstr_id']; ?>" > <?php //echo $row['user_first_name']." [ ".$row['c_f_m_date_time']." ]"; ?> </option>
                      <?php //}?>
                    </select>
                  </div>
                </div>
                
                                                       <div class="col-md-3">
<div class="form-group">
<label>Item  </label>
<input type="hidden" id="product_id"  name="product_id" class="js-data-product-sn-ajax form-control" style="padding:0px 0px; border: none; box-shadow: none" placeholder="-Select Item-" /><!--onChange="setitemselect()"-->
</div>
</div>
                
                <div class="col-sm-2">
                  <div class="form-group">
                    <label>From Date </label>
                    <!--    <input id="srh_from_date" name="srh_from_date" type='text' class="form-control date" value="" data-bv-field="date"/>               -->
                    
                    <input id="srh_from_date" name="srh_from_date" type='text' class="form-control date-picker" value="<?php echo date('m/d/Y'); ?>" data-bv-field="date"/>
                  </div>
                </div>
                <div class="col-sm-2" >
                  <div class="form-group">
                    <label for="s2id_autogen1">To Date </label>
                    
                    <!-- <input id="srh_to_date" name="srh_to_date" type='text' class="form-control date" value="" data-bv-field="date"/>        -->
                    
                    <input id="srh_to_date" name="srh_to_date" type='text' class="form-control date-picker" value="<?php echo date('m/d/Y'); ?>" data-bv-field="date"/>
                  </div>
                </div>
                <div class="col-sm-4 pull-right">
                  <div class="form-group">
                    <label for="s2id_autogen1">&nbsp;<br>
                      <br>
                    </label>
                    <input type="submit" name="add_category" value="Search" class="btn btn-primary" onClick="searchDetails()">
                    &nbsp;&nbsp;
                    <input type="submit" name="add_category" value="Reset" class="btn btn-danger" onClick="searchDetailsReset()">
                  </div>
                </div>
              </div>
            </div>
            <input type="button" onClick="printDiv('printableArea')" value="Print Daily Sales Report" class="pull-right"/>
            <div id="printableArea">
              <div id="printableArea">
                <div class="page-header">
                  <h3>Product Summary  </h3>
                </div>
                <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="">
                  <tr>
                    <td></td>
                    <td class="text-right">Date <span id="f-date-txt">Loading....</span><!--, To Date: <span id="t-date-txt">Loading....</span>--></td>
                  </tr>
                 
                   <tr>
                    <th>Sold Value</th>
                    <td><div id="sale-tbl">Loading....</div></td>
                  </tr>
                  <tr>
                  <tr>
                    <th width="50%">Cost Value </th>
                    <td width="50%"><div id="cost-tbl">Loading....</div></td>
                  </tr>
                  <tr>
                    <th>Sale return  Value</th>
                    <td><div id="sales-rtn-val-tbl">Loading....</div></td>
                  </tr>
                 
                    <th>Sales Return Cost Value</th>
                    <td><div id="sales-rtn-cost-tbl">Loading....</div></td>
                  </tr>
                  
                   <tr>
                    <th>Profit Value</th>
                    <td><div id="profit-tbl">Loading....</div></td>
                  </tr>
                  
                  <tr>
                    <th>Profit %</th>
                    <td><div id="percentage-tbl">Loading....</div></td>
                  </tr>
                  
                   <tr>
                    <th>Solt Total QTY</th>
                    <td><div id="sold_qty-tbl">Loading....</div></td>
                  </tr>
                  
                   <tr>
                    <th>Sale Return Total Qty</th>
                    <td><div id="sale_return_qty-tbl">Loading....</div></td>
                  </tr>
                </table>
              </div>
            </div>
             <br>
            <br>
            <br>
            
             <div class="panel-heading"> <i class="fa fa-external-link-square"></i> Sold Item List </div>
            <br>
            <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="warehouse_table_1">
              <thead>
                <tr>
                  <th>Product Code</th>
                  <th>Product Name</th>
                  <th>Btach Number</th>
                  <th>Bill No</th>
                    <th>Bill Date</th>
                   <th>Unit Price</th>
                   <th>Cost Price</th>
                   <th>Discount</th>
                   <th>Sold Qty</th>
                   <th>Sale Total</th>
                   <th>Cost Total</th>
                   <th>Profit %</th>
                    <!--<th>Total Product Qty</th>
                    <th>Total Stock Value </th>-->
                </tr>
              </thead>
              <tfoot>
                <tr>
              <th>Product Code</th>
                  <th>Product Name</th>
                  <th>Btach Number</th>
                  <th>Bill No</th>
                    <th>Bill Date</th>
                   <th>Unit Price</th>
                   <th>Cost Price</th>
                   <th>Discount</th>
                   <th>Sold Qty</th>
                   <th>Sale Total</th>
                   <th>Cost Total</th>
                   <th>Profit %</th>
                    <!--<th>Total Product Qty</th>
                    <th>Total Stock Value </th>-->
                </tr>
            </table>
            
            
          
            
             <div class="panel-heading"> <i class="fa fa-external-link-square"></i> Sale Return Item List </div>
            <br>
            <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="warehouse_table_2">
              <thead>
                <tr>
                  <th>Product Code</th>
                  <th>Product Name</th>
                  <th>Btach Number</th>
                  <th>Sale Return No</th>
                    <th>Sale Return Date</th>
                   <th>Unit Price</th>
                   <th>Discount</th>
                   <th>return Qty</th>
                   <th>return Value</th>
                    <!--<th>Total Product Qty</th>
                    <th>Total Stock Value </th>-->
                </tr>
              </thead>
              <tfoot>
                <tr>
             <th>Product Code</th>
                  <th>Product Name</th>
                  <th>Btach Number</th>
                  <th>Sale Return No</th>
                    <th>Sale Return Date</th>
                   <th>Unit Price</th>
                   <th>Discount</th>
                   <th>return Qty</th>
                   <th>return Value</th>
                    <!--<th>Total Product Qty</th>
                    <th>Total Stock Value </th>-->
                </tr>
            </table>
            
            
         
            <div class="panel-heading"> <i class="fa fa-external-link-square"></i> Purchased Item List </div>
            <br>
           <!-- <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="warehouse_table">
              <thead>
                <tr>
                  <th>Product Code</th>
                  <th>Product Name</th>
                  <th>Btach Number</th>
                  <th>GRN No</th>
                    <th>GRN Date</th>
                   <th>Cost</th>
                   <th>GRN Qty</th>
                   <th>GRNk Value</th>
                    <th>Total Product Qty</th>
                    <th>Total Stock Value </th>
                </tr>
              </thead>
              <tfoot>
                <tr>
             <th>Product Code</th>
                  <th>Product Name</th>
                  <th>Btach Number</th>
                  <th>GRN No</th>
                    <th>GRN Date</th>
                   <th>Cost</th>
                   <th>GRN Qty</th>
                   <th>GRNk Value</th>
                    <th>Total Product Qty</th>
                    <th>Total Stock Value </th>
                </tr>
            </table>-->
            
            
             <div class="panel-heading"> <i class="fa fa-external-link-square"></i> Purchese Return Item List </div>
            <br>
           <!-- <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="warehouse_table_3">
              <thead>
                <tr>
                  <th>Product Code</th>
                  <th>Product Name</th>
                  <th>Btach Number</th>
                  <th>GRN Return No</th>
                    <th>GRN Return Date</th>
                   <th>Unit Price</th>
                   <th>Discount</th>
                   <th>return Qty</th>
                   <th>return Value</th>
                    <th>Total Product Qty</th>
                    <th>Total Stock Value </th>
                </tr>
              </thead>
              <tfoot>
                <tr>
             <th>Product Code</th>
                  <th>Product Name</th>
                  <th>Btach Number</th>
                  <th>GRN Return No</th>
                    <th>GRN Return Date</th>
                   <th>Unit Price</th>
                   <th>Discount</th>
                   <th>return Qty</th>
                   <th>return Value</th>
                    <th>Total Product Qty</th>
                    <th>Total Stock Value </th>
                </tr>
            </table>-->
            
            
            <br>
          
          </div>
        </div>
        <!-- end: DYNAMIC TABLE PANEL --> 
      </div>
    </div>
    
    <!-- end grid --> 
    
  </div>
  <!-- end: PAGE --> 
</div>
<!-- end: MAIN CONTAINER --> 
<!-- start: FOOTER -->
<div class="footer clearfix">
  <div class="footer-inner"> 2014 &copy; clip-one by cliptheme. </div>
  <div class="footer-items"> <span class="go-top"><i class="clip-chevron-up"></i></span> </div>
</div>
<!-- end: FOOTER --> 
<!-- start: RIGHT SIDEBAR --> 
<!-- end: RIGHT SIDEBAR -->
<div id="event-management" class="modal fade" tabindex="-1" data-width="760" style="display: none;">
  <div class="modal-dialog">
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> &times; </button>
        <h4 class="modal-title">Event Management</h4>
      </div>
      <div class="modal-body"></div>
      <div class="modal-footer">
        <button type="button" data-dismiss="modal" class="btn btn-light-grey"> Close </button>
        <button type="button" class="btn btn-danger remove-event no-display"> <i class='fa fa-trash-o'></i> Delete Event </button>
        <button type='submit' class='btn btn-success save-event'> <i class='fa fa-check'></i> Save </button>
      </div>
    </div>
  </div>
</div>
<input name="sales-rtn-val-cost" type="text" id="sales-rtn-cost-fld" value="0">
<input name="sales-rtn-val-fld" type="text" id="sales-rtn-val-fld" value="0">
<input name="sales-val-cost" type="text" id="sales-cost-fld" value="0">
<input name="sales-val-fld" type="text" id="sales-val-fld" value="0">
<input name="sale_prof" type="hidden" id="sale_prof" value="0">
<input name="return_prof" type="hidden" id="return_prof" value="0">
<!-- start ajax model -->
<div id="ajax-modal" class="modal fade" data-backdrop="static" data-keyboard="false" tabindex="-1" style="display: none;"></div>
<!-- end ajax model --> 

<!-- start: MAIN JAVASCRIPTS -->
<?php $this->load->view("common/footer"); ?>
<script src="<?php echo asset_url(); ?>js/jquery-ui.js" ></script> 
<script src="<?php echo asset_url(); ?>js/moment-with-locales.js"></script> 
<script type="text/javascript" src="<?php echo asset_url(); ?>js/bootstrap-datetimepicker.js"></script> 
<script type="text/javascript" src="<?php echo asset_url(); ?>js/bootstrap-datepicker.js"></script> 
<script type="text/javascript" src="<?php echo asset_url(); ?>js/bootbox.min.js"></script> 
<script type="text/javascript" src="<?php echo asset_url(); ?>js/accounting.js"></script> 
<script type="text/javascript" src="<?php echo asset_url(); ?>js/accounting.min.js"></script> 
<!-- end: MAIN JAVASCRIPTS --> 
<script type="text/javascript" src="https://cdn.datatables.net/1.10.10/js/jquery.dataTables.min.js"></script> 
<script type="text/javascript" src="https://cdn.datatables.net/1.10.10/js/dataTables.bootstrap.min.js"></script> 
<script src="<?php echo asset_url(); ?>/plugins/jquery-inputlimiter/jquery.inputlimiter.1.3.1.min.js"></script> 
<script src="<?php echo asset_url(); ?>/plugins/autosize/jquery.autosize.min.js"></script> 
<script src="<?php echo asset_url(); ?>/plugins/select2/select2.min.js"></script> 
<script src="<?php echo asset_url(); ?>/plugins/jquery.maskedinput/src/jquery.maskedinput.js"></script> 
<script src="<?php echo asset_url(); ?>/plugins/jquery-maskmoney/jquery.maskMoney.js"></script> 
<script src="<?php echo asset_url(); ?>/plugins/bootstrap-datepicker/js/bootstrap-datepicker.js"></script> 
<script src="<?php echo asset_url(); ?>/plugins/bootstrap-timepicker/js/bootstrap-timepicker.min.js"></script> 
<script src="<?php echo asset_url(); ?>/plugins/bootstrap-daterangepicker/moment.min.js"></script> 
<script src="<?php echo asset_url(); ?>/plugins/bootstrap-daterangepicker/daterangepicker.js"></script> 
<script src="<?php echo asset_url(); ?>/plugins/bootstrap-colorpicker/js/bootstrap-colorpicker.js"></script> 
<script src="<?php echo asset_url(); ?>/plugins/bootstrap-colorpicker/js/commits.js"></script> 
<script src="<?php echo asset_url(); ?>/plugins/jQuery-Tags-Input/jquery.tagsinput.js"></script> 
<script src="<?php echo asset_url(); ?>/plugins/bootstrap-fileupload/bootstrap-fileupload.min.js"></script> 
<script src="<?php echo asset_url(); ?>/plugins/summernote/build/summernote.min.js"></script> 
<script src="<?php echo asset_url(); ?>/plugins/ckeditor/ckeditor.js"></script> 
<script src="<?php echo asset_url(); ?>/plugins/ckeditor/adapters/jquery.js"></script> 
<script src="<?php echo asset_url(); ?>/js/form-elements.js"></script> 
<script type="text/javascript" src="<?php echo asset_url(); ?>js/jquery.dataTables.min.js"></script> 
<script type="text/javascript" src="<?php echo asset_url(); ?>js/dataTables.bootstrap.min.js"></script> 
<script>
		
		
		function printDiv(divName) {
             var printContents = document.getElementById(divName).innerHTML;
             var originalContents = document.body.innerHTML;
             document.body.innerHTML = printContents;
             window.print();
            document.body.innerHTML = originalContents;
        }
		
		function searchDetailsReset(){
			$('#srh_to_date').val('');
			$('#srh_from_date').val('');
		}
		function searchDetails(){
		            load_summary();
					//loadGrid();
					loadGridSold();
					loadGridSaleReturn();
					//loadGridGRNReturn();
				
		}
				
			jQuery(document).ready(function() {
				FormElements.init();
				//var currentDate = new Date();
				var tomorrow = new Date();
				currentDate=tomorrow.setDate(tomorrow.getDate() + 1);
				/*$('#srh_to_date').datetimepicker({
					defaultDate: currentDate
				});
				$('#srh_from_date').datetimepicker({
					defaultDate: new Date()
				});*/
				//TableData.init();
				load_summary();
				loadGrid();
				loadGridSold();
				loadGridSaleReturn();
				loadGridGRNReturn();
				//loadGridSalesReturn();
			});

		function loadGrid() {
		    var srh_from_date=$('#srh_from_date').val();
			var srh_to_date=$('#srh_to_date').val();
			var srh_warehouse_id=$('#srh_warehouse_id').val();
		    var product_id=$('#product_id').val();
					    $('#warehouse_table').DataTable({
					        "ajax": "<?php echo base_url('reports/get_grn_item_list?product_id=')?>"+product_id+"&srh_from_date="+srh_from_date+"&srh_to_date="+srh_to_date+"&srh_warehouse_id="+srh_warehouse_id,
					        "data": {
							   srh_from_date: srh_from_date,
							   srh_to_date: srh_to_date,
							   srh_warehouse_id: srh_warehouse_id,
							   product_id: product_id,
							},
					        oLanguage: {
                            sProcessing: '<div class="loader" id="loader"></div><div><h1>Loading......</h1></div>'
                            },
                            "processing": true,
					        "bDestroy": true,
							"serverSide": true,
					        "iDisplayLength": 20,
							"order": [[ 0, "desc" ]], "fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay) {
				
                var pq = 0, sq = 0, bq = 0, pa = 0, grand_tot = 0, tech_tot = 0, parts_tot=0 , ser_tot=0;
				//alert(aaData.length);
				var ser_tot3=0;
				var ser_tot2=0;
				var ser_tot1=0;
				var ser_tot4=0;
				//var sales_rtn=0;
                for (var i = 0; i < aaData.length; i++) {
					//alert(aaData[[i]][5]);
                   // p = (aaData[aiDisplay[i]][2]).split('__');
					ser_tot1 += parseFloat(aaData[[i]][6]);
					ser_tot2 += parseFloat(aaData[[i]][7]);
					//ser_tot3 += parseFloat(aaData[[i]][5]);	
                }
                var nCells = nRow.getElementsByTagName('th');
				nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 3, ",", ".")+' </div>';
				nCells[7].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 2, ",", ".")+' </div>';
				//nCells[5].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot3, "", 2, ",", ".")+' </div>';
            }
			});
		}
		
		function loadGridSold() {
		    var srh_from_date=$('#srh_from_date').val();
			var srh_to_date=$('#srh_to_date').val();
			var srh_warehouse_id=$('#srh_warehouse_id').val();
		    var product_id=$('#product_id').val();
					    $('#warehouse_table_1').DataTable({
					        "ajax": "<?php echo base_url('reports/get_sold_item_list_for_item_report?product_id=')?>"+product_id+"&srh_from_date="+srh_from_date+"&srh_to_date="+srh_to_date+"&srh_warehouse_id="+srh_warehouse_id,
					        "data": {
							   srh_from_date: srh_from_date,
							   srh_to_date: srh_to_date,
							   srh_warehouse_id: srh_warehouse_id,
							   product_id: product_id,
							},
					        oLanguage: {
                            sProcessing: '<div class="loader" id="loader"></div><div><h1>Loading......</h1></div>'
                            },
                            "processing": true,
					        "bDestroy": true,
							"serverSide": true,
					        "iDisplayLength": 20,
							"order": [[ 0, "desc" ]], "fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay) {
				
                var pq = 0, sq = 0, bq = 0, pa = 0, grand_tot = 0, tech_tot = 0, parts_tot=0 , ser_tot=0;
				//alert(aaData.length);
				var ser_tot3=0;
				var ser_tot2=0;
				var ser_tot1=0;
				var ser_tot4=0;
				//var sales_rtn=0;
                for (var i = 0; i < aaData.length; i++) {
					//alert(aaData[[i]][5]);
                   // p = (aaData[aiDisplay[i]][2]).split('__');
					ser_tot1 += parseFloat(aaData[[i]][6]);
					ser_tot2 += parseFloat(aaData[[i]][7]);
					ser_tot3 += parseFloat(aaData[[i]][8]);	
                }
                var nCells = nRow.getElementsByTagName('th');
				nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';
				nCells[7].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 3, ",", ".")+' </div>';
				nCells[8].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot3, "", 2, ",", ".")+' </div>';
            }
			});
		}
		
		function loadGridSaleReturn() {
		    var srh_from_date=$('#srh_from_date').val();
			var srh_to_date=$('#srh_to_date').val();
			var srh_warehouse_id=$('#srh_warehouse_id').val();
		    var product_id=$('#product_id').val();
					    $('#warehouse_table_2').DataTable({
					        "ajax": "<?php echo base_url('reports/get_sale_return_item_list?product_id=')?>"+product_id+"&srh_from_date="+srh_from_date+"&srh_to_date="+srh_to_date+"&srh_warehouse_id="+srh_warehouse_id,
					        "data": {
							   srh_from_date: srh_from_date,
							   srh_to_date: srh_to_date,
							   srh_warehouse_id: srh_warehouse_id,
							   product_id: product_id,
							},
					        oLanguage: {
                            sProcessing: '<div class="loader" id="loader"></div><div><h1>Loading......</h1></div>'
                            },
                            "processing": true,
					        "bDestroy": true,
							"serverSide": true,
					        "iDisplayLength": 20,
							"order": [[ 0, "desc" ]], "fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay) {
				
                var pq = 0, sq = 0, bq = 0, pa = 0, grand_tot = 0, tech_tot = 0, parts_tot=0 , ser_tot=0;
				//alert(aaData.length);
				var ser_tot3=0;
				var ser_tot2=0;
				var ser_tot1=0;
				var ser_tot4=0;
				//var sales_rtn=0;
                for (var i = 0; i < aaData.length; i++) {
					//alert(aaData[[i]][5]);
                   // p = (aaData[aiDisplay[i]][2]).split('__');
					ser_tot1 += parseFloat(aaData[[i]][6]);
					ser_tot2 += parseFloat(aaData[[i]][7]);
					ser_tot3 += parseFloat(aaData[[i]][8]);	
                }
                var nCells = nRow.getElementsByTagName('th');
				nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';
				nCells[7].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 3, ",", ".")+' </div>';
				nCells[8].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot3, "", 2, ",", ".")+' </div>';
            }
			});
		}
		
		function loadGridGRNReturn() {
		    var srh_from_date=$('#srh_from_date').val();
			var srh_to_date=$('#srh_to_date').val();
			var srh_warehouse_id=$('#srh_warehouse_id').val();
		    var product_id=$('#product_id').val();
					    $('#warehouse_table_3').DataTable({
					        "ajax": "<?php echo base_url('reports/get_grn_return_item_list?product_id=')?>"+product_id+"&srh_from_date="+srh_from_date+"&srh_to_date="+srh_to_date+"&srh_warehouse_id="+srh_warehouse_id,
					        "data": {
							   srh_from_date: srh_from_date,
							   srh_to_date: srh_to_date,
							   srh_warehouse_id: srh_warehouse_id,
							   product_id: product_id,
							},
					        oLanguage: {
                            sProcessing: '<div class="loader" id="loader"></div><div><h1>Loading......</h1></div>'
                            },
                            "processing": true,
					        "bDestroy": true,
							"serverSide": true,
					        "iDisplayLength": 20,
							"order": [[ 0, "desc" ]], "fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay) {
				
                var pq = 0, sq = 0, bq = 0, pa = 0, grand_tot = 0, tech_tot = 0, parts_tot=0 , ser_tot=0;
				//alert(aaData.length);
				var ser_tot3=0;
				var ser_tot2=0;
				var ser_tot1=0;
				var ser_tot4=0;
				//var sales_rtn=0;
                for (var i = 0; i < aaData.length; i++) {
					//alert(aaData[[i]][5]);
                   // p = (aaData[aiDisplay[i]][2]).split('__');
					ser_tot1 += parseFloat(aaData[[i]][6]);
					ser_tot2 += parseFloat(aaData[[i]][7]);
					ser_tot3 += parseFloat(aaData[[i]][5]);	
                }
                var nCells = nRow.getElementsByTagName('th');
				nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';
				nCells[7].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 3, ",", ".")+' </div>';
				nCells[5].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot3, "", 2, ",", ".")+' </div>';
            }
			});
		}
		
				
				
				
	function load_summary(){
        var srh_from_date=$('#srh_from_date').val();
		var srh_to_date=$('#srh_to_date').val();
		var srh_warehouse_id=$('#srh_warehouse_id').val();
		var product_id=$('#product_id').val();
        $.ajax({
        url:"<?php echo base_url('reports/get_product_value_sumary');?>",
        type:"POST",
        data:{
          srh_from_date: srh_from_date,srh_to_date:srh_to_date,srh_warehouse_id:srh_warehouse_id,product_id: product_id,
        },
        success:function(response) {
          var obj = JSON.parse(response);
          		$('#cost-tbl').text(accounting.formatMoney(obj.cost_total, "", 3, ",", "."));
				$('#sale-tbl').text(accounting.formatMoney(obj.sale_total, "", 3, ",", "."));
				$('#sales-rtn-val-tbl').text(accounting.formatMoney(obj.sale_return_total, "", 3, ",", "."));
				$('#sales-rtn-cost-tbl').text(accounting.formatMoney(obj.cost_return_total, "", 3, ",", "."));
				$('#profit-tbl').text(accounting.formatMoney(obj.profit, "", 3, ",", "."));
				$('#f-date-txt').text($('#srh_from_date').val());
				$('#t-date-txt').text($('#srh_to_date').val());
				$('#percentage-tbl').text(obj.ff_qty);
				$('#sale_return_qty-tbl').text(obj.sale_return_qty);
				$('#sold_qty-tbl').text(obj.sold_qty);
				
				
				
				
       },
       error:function(){
        alert("error");
       }

      });

}


function fbs_click(url) {
	var srh_from_date=$('#srh_from_date').val();
	var srh_to_date=$('#srh_to_date').val();
	var srh_warehouse_id=$('#srh_warehouse_id').val();
	var float_id=$('#float_id').val();
	
	
	u=location.href;
	t=document.title;
	url='<?php echo base_url();?>'+'reports/print_sale?srh_warehouse_id='+srh_warehouse_id+'&srh_from_date='+srh_from_date+'&srh_to_date='+srh_to_date;
	window.open(url,'sharer','toolbar=0,status=0,width=750,height=436, left=10, top=10,scrollbars=yes');return false;
}

$(".js-data-product-sn-ajax").select2({
	  // var cat_srh=$("#cat_srh").val();
	 //  var subcategory=$("#subcategory").val();
        ajax: {
			'type': 'POST',
				'url': '<?php echo base_url('reports/get_product_sn?srh_warehouse_id=');?>'+$("#warehouse_id").val(),
                dataType: 'json',
                delay: 0,
			
                data: function (query) {
							//alert(1);
                if (!query)
                        query = '';
                return {
                search_string: query,
				 cat_srh: $("#cat_srh").val(),
				  subcategory: $("#subcategory").val(),
				//service_item_avalable: $("#service_item_avalable").val(),
                        format: 'json'
                };
                },
                results: function (data) {
                return {
                results: $.map(data, function (item) {
                return {
					//alert();
                text: item.product_name+' ('+item.product_code+')',
                        slug: item.product_id,
                        id: item.product_id
                };
                })
                };
                },
                cache: true
         }
        });




</script>
</body>
<!-- end: BODY -->
</html>