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

<!-- start: CSS REQUIRED FOR THIS PAGE ONLY -->
<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>
<link rel="stylesheet" href="<?php echo asset_url();?>css/buttons.dataTables.min.css" type="text/css" />
<style type="text/css">
.dt-button-collection {
	font-size: 1.4em;
}
.dt-button-collection .active span:after {
	font-family: FontAwesome;
	content: " \f00c";
	text-align: right
}
a.dt-button, button.dt-button, div.dt-button, .dt-buttons {
	font-size: .83em;
	float: right!important;
	/*  background-color:#e9e9e9;
    background-image:linear-gradient(to bottom,#fff 0,#e9e9e9 100%);*/
		
	margin-left: .3em;
}
</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="#"> REPORT </a> </li>
        <li class="active">PRODUCTION REPORT
        <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">
        <h3>PRODUCTION REPORT</h3>
      </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> PRODUCTION REPORT
          <div class="panel-tools" style="top:2px;">
            <!--<button onClick="JavaScript:fbs_click('<?php echo base_url('reports/print_sale?srh_warehouse_id=1'); ?>');" 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-4">
                <div class="form-group">
                  <label>Product Name </label>
                  <select id="sales_rep_id" class="form-control search-select" name="sales_rep_id">
                        <option value="" > All  </option>
                    <?php 
                             foreach ($delivery_list as $row)
                               {                        ?>
                    <option value="<?php echo $row['product_id']; ?>" > <?php echo $row['product_name']; ?> <?php echo $row['product_code']; ?>  </option>
                    <?php }?>
                  </select>
                </div>
              </div>
              <div class="col-sm-4" >
                <div class="form-group">
                  <label>From Date </label>
                  <input autocomplete="off" id="srh_from_date" name="srh_from_date" type='text' class="form-control date-picker" value="<?php // date('m/d/Y'); ?>" data-bv-field="date"/>
                </div>
              </div>
              
               <div class="col-sm-4" >
                <div class="form-group">
                  <label>To Date </label>
                  <input autocomplete="off" id="srh_to_date" name="srh_to_date" type='text' class="form-control date-picker" value="<?php // 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" id="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 class="panel collapse ">
            <div class="panel-heading"> <i class="fa fa-external-link-square"></i>PRODUCTION REPORT</div>
            <div class="panel-body">
                <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="">   
                  <tr>
                    <th width="50%">area</th>
                    <td width="50%"><div id="area_field">............</div></td>
                  </tr>
                  <tr>
                    <th>representative</th>
                    <td><div id="rep_field">............</div></td>
                  </tr>
                  <tr>
                    <th>date</th>
                    <td><div id="date_field">............</div></td>
                  </tr>
                  
                   <tr>
                    <th>+ sale</th>
                    <td><div id="total_sale_field">............</div></td>
                  </tr>
                  
                   <tr>
                    <th>- cost of sale</th>
                    <td><div id="total_cost_field">............</div></td>
                  </tr>
                  
                   <tr>
                    <th>= gross profit</th>
                    <td><div id="gross_profit_field">............</div></td>
                  </tr>
                  <tr style="display: none">
                    <th>Total Sale Return Cost</th>
                    <td><div id="total_sale_return_cost_field">............</div></td>
                  </tr>
                   <tr>
                    <th>- sale return</th>
                    <td><div id="total_sale_return_field">............</div></td>
                  </tr>
                    <tr>
                    <th>- expencess</th>
                    <td><div id="total_expenses_field">............</div></td>
                  </tr>
                  <tr>
                    <th>= net profit</th>
                    <td><div id="net_profit__field" style="border-top:1px solid gray; border-bottom:4px double gray;">............</div></td>
                  </tr>
                  <tr>
                    <th>&nbsp; </th>
                    <td><div >&nbsp; </div></td>
                  </tr>
                   <tr>
                    <th>+ collected cash</th>
                    <td><div id="total_collected_cash_field">............</div></td>
                  </tr>
                   <tr>
                    <th>+ collected cheque</th>
                    <td><div id="total_collected_cheque_field">............</div></td>
                  </tr>
                  
                   <tr>
                    <th>= collected payment</th>
                    <td><div  id="total_collected_payment_field">............</div></td>
                  </tr>
                    <tr>
                    <th>- bank deposit</th>
                    <td><div id="total_bank_deposit_field">............</div></td>
                  </tr>
                  
                   </tr>
                    <tr>
                    <th>- expencess</th>
                    <td><div id="total_finance_expencess_field">............</div></td>
                  </tr>
                 
                   <tr>
                    <th>= collected payment on hand</th>
                    <td><div style="border-top:1px solid gray; border-bottom:4px double gray;"  id="total_cash_on_hand_field">............</div></td>
                  </tr>
                   <tr>
                    <th>&nbsp; </th>
                    <td><div >&nbsp; </div></td>
                  </tr>
                  <tr>
                    <th>credit note</th>
                    <td><div id="total_collected_credit_note_field">............</div></td>
                  </tr>
                  
                  <tr>
                    <th>&nbsp; </th>
                    <td><div >&nbsp; </div></td>
                  </tr>
                  
                   <tr>
                    <th>item discount</th>
                    <td><div id="total_item_discount">............</div></td>
                  </tr>
                  <tr>
                    <th>item discount in sale %</th>
                    <td><div id="total_item_discount_in_sale">............</div></td>
                  </tr>
                   
                </table>
              </div>
            </div>
            <br>
            <br>
            <br>
            <!--<div class="panel-heading"> <i class="fa fa-external-link-square"></i> collected cash List </div>
            <br>
            <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="warehouse_table">
              <thead>
                <tr>
                  <th>Card Number / Invoice No</th>
                  <th>Payment</th>
                </tr>
              </thead>
              <tfoot>
                <tr>
                  <th>Card Number / Invoice No</th>
                  <th>Payment</th>
                </tr>
            </table>
               </div>
          </div>-->
          <div class="panel">
            <div class="panel-heading"> <i class="fa fa-external-link-square"></i> PRODUCTION REPORT </div>
            <div class="panel-body">
                <h4>PRODUCTION REPORT </h4>
              <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="delivery_product_table">
                <thead>
                  <tr>
                   <th>Date</th>
                    <th>Batch No</th>
                    <th>Ingredients</th>
                    <th>Estimated Qty</th>
                    <th>Addtional Qty</th>
                    <th>Total  Qty</th>
                    <th>Estimated Cost</th>
                    <th>Addtional Cost</th>
                    <th>Total  Cost</th>
                    
                  </tr>
                </thead>
                <tfoot>
                  <tr>
                      <th>Date</th>
                    <th>Batch No</th>
                    <th>Ingredients</th>
                    <th>Estimated Qty</th>
                    <th>Addtional Qty</th>
                    <th>Total  Qty</th>
                    <th>Estimated Cost</th>
                    <th>Addtional Cost</th>
                    <th>Total  Cost</th>
                  </tr>
                </tfoot>
              </table>
            </div>
          </div>
         
          <div >
            <div class="panel-heading"> <i class="fa fa-external-link-square"></i> PRODUCTION REPORT SUMMARY </div>
             <input type="button" onClick="fbs_click()" value="PRINT PRODUCTION REPORT" class="pull-right"/>
            <div class="panel-body">
                <h4>PRODUCTION REPORT SUMMARY</h4>
              <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="sales_sale_table">
                <thead>
                  <tr>
                  
                    <th>Ingredients</th>
                    <th>Estimated Qty</th>
                    <th>Addtional Qty</th>
                    <th>Total  Qty</th>
                     <th>Estimated  Cost</th>
                     <th>Addtional  Cost</th>
                     <th>Total  Cost</th>
                  </tr>
                </thead>
                <tfoot>
                  <tr>
                   
                    <th>Ingredients</th>
                    <th>Estimated Qty</th>
                    <th>Addtional Qty</th>
                    <th>Total  Qty</th>
                     <th>Estimated  Cost</th>
                     <th>Addtional  Cost</th>
                     <th>Total  Cost</th>
                    
                  </tr>
                </tfoot>
              </table>
            </div>
          </div>
          
            <div class="panel collapse ">
            <div class="panel-heading"> <i class="fa fa-external-link-square"></i> Delivery customer wise invoice product list </div>
            <div class="panel-body">
                <h4> Customer wise invoice product list </h4>
              <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="sales_cus_product_table">
                <thead>
                  <tr>
                    <th>Customer</th>
                    <th>Invoice</th>
                    <th>Date</th>
                   <th>Product Code</th>
                    <th>Product Name</th>
                    <th>Invoice Qty</th>
                     <th>Product Original Price</th>
                    <th>Product Invoice Price</th>
                    <th>Gross Total</th>
                  </tr>
                </thead>
                <tfoot>
                  <tr>
                       <th>Customer</th>
                      <th>Invoice</th>
                      <th>Date</th>
                     <th>Product Code</th>
                    <th>Product Name</th>
                    <th>Invoice Qty</th>
                     <th>Product Original Price</th>
                    <th>Product Invoice Price</th>
                    <th>Gross Total</th>
                  </tr>
                </tfoot>
              </table>
            </div>
          </div>
          
          
          <div class="panel collapse ">
            <div class="panel-heading"> <i class="fa fa-external-link-square"></i> Delivery return product summary </div>
            <div class="panel-body">
                <h4>Delivery return product summary</h4>
              <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="sales_sale_return_table">
                <thead>
                  <tr>
                   <th>Product Code</th>
                    <th>Product Name</th>
                    <th>Return Qty</th>
                    <th>Authorize Qty</th>
                    <th>Authorize Rejected Qty</th>
                    <th>Qty On Delivery</th>
                    <th>Cost Total</th>
                    <th>Price Total</th>
                  </tr>
                </thead>
                <tfoot>
                  <tr>
                     <th>Product Code</th>
                    <th>Product Name</th>
                    <th>Return Qty</th>
                    <th>Authorize Qty</th>
                    <th>Authorize Rejected Qty</th>
                    <th>Qty On Delivery</th>
                    <th>Cost Total</th>
                    <th>Price Total</th>
                  </tr>
                </tfoot>
              </table>
            </div>
          </div>
          
          
          <div class="panel collapse ">
            <div class="panel-heading"> <i class="fa fa-external-link-square"></i> Delivery customer wise market return product list </div>
            <div class="panel-body">
                <h4> Customer wise market return product list  </h4>
              <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="sales_cus_return_product_table">
                <thead>
                  <tr>
                     <th>Customer Code</th>
                    <th>Customer Name</th>
                    <th>Ref.No</th>
                    <th>Date</th>
                    <th>Return Type</th>
                     <th>Return Reason</th>
                   <th>Product Code</th>
                    <th>Product Name</th>
                    <th>Qty</th>
                     
                    <th>Total Cost</th>
                    <th>Total Price</th>
                  </tr>
                </thead>
                <tfoot>
                  <tr>
                   <th>Customer Code</th>
                    <th>Customer Name</th>
                    <th>Ref.No</th>
                    <th>Date</th>
                    <th>Return Type</th>
                     <th>Return Reason</th>
                   <th>Product Code</th>
                    <th>Product Name</th>
                    <th>Qty</th>
                     
                    <th>Total Cost</th>
                    <th>Total Price</th>
                  </tr>
                </tfoot>
              </table>
            </div>
          </div>
          
          <div class="panel collapse ">
            <div class="panel-heading"> <i class="fa fa-external-link-square"></i> Delivery product unload to warehouse  </div>
            <div class="panel-body">
                <h4>Product unload to warehouse</h4>
              <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="return_item_table">
                <thead>
                  <tr>
                   <th>Product Code</th>
                    <th>Product Name</th>
                    <th>Unloaded Qty</th>
                    <th>Unloaded Date</th>
                  </tr>
                </thead>
                <tfoot>
                  <tr>
                    <th>Product Code</th>
                    <th>Product Name</th>
                    <th>Unloaded Qty</th>
                    <th>Unloaded Date</th>
                  </tr>
              </table>
            </div>
          </div>
          
          
          
           <div class="panel collapse ">
            <div class="panel-heading"> <i class="fa fa-external-link-square"></i> Delivery collected customer payment  </div>
            <div class="panel-body">
                <h4>Collected customer payment</h4>
              <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="payment_item_table">
                <thead>
                  <tr>
                   <th>Ref Code</th>
                   <th>Date</th>
                   <th>Payment Type</th>
                    <th>Customer Name</th>
                    <th>Payment Amount</th>
                    
                  </tr>
                </thead>
                <tfoot>
                  <tr>
                    <th>Ref Code</th>
                   <th>Date</th>
                   <th>Payment Type</th>
                    <th>Customer Name</th>
                    <th>Payment Amount</th>
                  </tr>
              </table>
            </div>
          </div>
          
          
           <div class="panel collapse ">
            <div class="panel-heading"> <i class="fa fa-external-link-square"></i> Delivery Expenses list  </div>
            <div class="panel-body">
                <h4>Expenses list</h4>
              <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="expencess_item_table">
                <thead>
                  <tr>
                   <th>Ref Code</th>
                   <th>Date</th>
                    <th>Expenses Category</th>
                    <th>Rule</th>
                    <th>Debit</th>
                    <th>Credit</th>
                    <th>Remarks</th>
                    <th>Amount</th>
                    
                  </tr>
                </thead>
                <tfoot>
                  <tr>
                    <th>Ref Code</th>
                   <th>Date</th>
                    <th>Expenses Category</th>
                    <th>Rule</th>
                    <th>Debit</th>
                    <th>Credit</th>
                    <th>Remarks</th>
                    <th>Amount</th>
                  </tr>
              </table>
            </div>
          </div>
          
           <div class="panel collapse ">
            <div class="panel-heading"> <i class="fa fa-external-link-square"></i> Bank Deposit list  </div>
            <div class="panel-body">
                <h4>Bank Deposit list</h4>
              <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="bank_deposit_item_table">
                <thead>
                  <tr>
                   <th>Ref Code</th>
                   <th>Date</th>
                    <th>Bank</th>
                    <th>Bank Recipt</th>
                    <th>Remarks</th>
                    <th>Amount</th>
                  </tr>
                </thead>
                <tfoot>
                  <tr>
                     <th>Ref Code</th>
                   <th>Date</th>
                    <th>Bank</th>
                    <th>Bank Recipt</th>
                    <th>Remarks</th>
                    <th>Amount</th>
                  </tr>
              </table>
            </div>
          </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">

<!-- 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/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 -->
<?php /*?><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><?php */?>
<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(); ?>/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/autosize/jquery.autosize.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(); ?>/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 type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/dataTables.buttons.min.js">
        </script> 
<script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/buttons.print.min.js">
        </script> 
<script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/buttons.flash.min.js">
        </script> 
<script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/jszip.min.js">
        </script> 
<script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/pdfmake.min.js">
        </script> 
<script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/vfs_fonts.js">
        </script> 
<script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/buttons.html5.min.js">
        </script> 
<script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/buttons.print.min.js"></script> 
<script>



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

		
var total_sale_payment=0;
		
function printDiv(divName) {
     var printContents = document.getElementById(divName).innerHTML;
     var originalContents = document.body.innerHTML;

     document.body.innerHTML = printContents;
	 
    

     document.body.innerHTML = originalContents;
}
		
		function searchDetailsReset(){
			
			$('#srh_from_date').val('');
		}
		function searchDetails(){
				$('#pdate').html("Date:"+$('#srh_from_date').val());
				loadGrid();
				loadGrid6();
		}
				
				
			jQuery(document).ready(function() {
				FormElements.init();
				var tomorrow = new Date();
				currentDate=tomorrow.setDate(tomorrow.getDate() + 1);
                 $("#sales_rep_id").select2();
			});

//payment_item_table
function loadGrid() {
			var srh_from_date=$('#srh_from_date').val();
			var srh_to_date=$('#srh_to_date').val();
			var sales_rep_id=$('#sales_rep_id').val();			
						
					    $('#sales_sale_table').DataTable({
							dom: 'Blfrtip',
				lengthMenu: [[10, 25, 50, -1 ], [10, 25, 50, "All"]],
				buttons: [
						{ extend: 'copy', text: '<i class="fa fa-copy fa-2x"></i>',footer: true, exportOptions:
				 [ 0,1,2,3,4,5,6]},
						   { extend: 'print', text: '<i class="fa fa-print fa-2x"></i>',footer: true,
						    exportOptions:{ columns: [0,1,2,3,4,5,6] },title:"PRODUCTION REPORT SUMMARY"+srh_from_date+""
						   },
						   {
						       extend: 'excel', text: '<i class="far fa-file-excel fa-2x"></i>Excel',footer: true,
						   exportOptions:{ columns: [0,1,2,3,4,5,6] },
						   title:"PRODUCTION REPORT SUMMARY"},
							 { extend: 'pdf', text: '<i class="far fa-file-pdf fa-2x"></i>PDF',footer: true,exportOptions:
	 { columns: [0,1,2,3,4,5,6] },title:"PRODUCTION REPORT SUMMARY"},							 
						],
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('report_stock_ctrl/get_production_summary_data');?>?rep_id='+sales_rep_id +'&from_date='+srh_from_date+'&to_date='+srh_to_date,
							'data': {							  
							}
							},
					        "bDestroy": true,
					        "bDestroy": true,
					        "iDisplayLength": 100,
							"order": [[ 1, "desc" ]], "fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay) {
				
				var ser_tot3=0;
				var ser_tot2=0;
				var ser_tot1=0;
				var ser_tot4=0;				
                for (var i = 0; i < aaData.length; i++) {					
					ser_tot1 += parseFloat(aaData[[i]][4]);	
					ser_tot2 += parseFloat(aaData[[i]][5]);
				ser_tot3 += parseFloat(aaData[[i]][6]);
								
                }					
                var nCells = nRow.getElementsByTagName('th');
				nCells[4].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';				
				nCells[5].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 2, ",", ".")+' </div>';
				nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot3, "", 2, ",", ".")+' </div>';
            }
					    });
		}
	
	function loadGrid2() {
			var srh_from_date=$('#srh_from_date').val();			
			var sales_rep_id=$('#sales_rep_id').val();			
						
					    $('#sales_cus_product_table').DataTable({
							dom: 'Blfrtip',
				lengthMenu: [[10, 25, 50, -1 ], [10, 25, 50, "All"]],
				buttons: [
						{ extend: 'copy', text: '<i class="fa fa-copy fa*/-2x"></i>',footer: true, exportOptions:
				 [ 0,1,2,3]},
						   { extend: 'print', text: '<i class="fa fa-print fa-2x"></i>',footer: true,exportOptions:
	 { columns: [0,1,2,3] },title:"<center>Daily delivery sales list <br><small>"+srh_from_date+"</small></center>"},
							{ extend: 'excel', text: '<i class="far fa-file-excel fa-2x"></i>Excel',footer: true,
							//exportOptions:	 { columns: [0,1,2,3] },
							title:"Daily delivery sales list "},
							 { extend: 'pdf', text: '<i class="far fa-file-pdf fa-2x"></i>PDF',footer: true,exportOptions:
	 { columns: [0,1,2,3] },title:"Daily delivery sales list "},							 
						],
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports_marketing/get_delivery_customer_sale_product_list_by_date');?>?rep_id='+sales_rep_id +'&from_date='+srh_from_date,
							'data': {							  
							}
							},
					        "bDestroy": true,
					        "iDisplayLength": 10,
					        "bDestroy": true,
					        "iDisplayLength": 20,
							"order": [[ 0, "asc" ]], "fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay) {
				
				var ser_tot3=0;
				var ser_tot2=0;
				var ser_tot4=0;
				var ser_tot5=0;				
                for (var i = 0; i < aaData.length; i++) {					
				
					ser_tot4 += parseFloat(aaData[[i]][5]);
					ser_tot5 += parseFloat(aaData[[i]][8]);				
                }					
                var nCells = nRow.getElementsByTagName('th');
				nCells[5].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot4, "", 2, ",", ".")+' </div>';				
				nCells[8].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot5, "", 2, ",", ".")+' </div>';
            }
		 });
		}
	
	
	
	
	function loadGridReturn() {
			var srh_from_date=$('#srh_from_date').val();			
			var sales_rep_id=$('#sales_rep_id').val();			
						
					    $('#return_item_table').DataTable({
							dom: 'Blfrtip',
				lengthMenu: [[10, 25, 50, -1 ], [10, 25, 50, "All"]],
				buttons: [
						{ extend: 'copy', text: '<i class="fa fa-copy fa-2x"></i>',footer: true, exportOptions:
				 [ 0,1,2,3]},
						   { extend: 'print', text: '<i class="fa fa-print fa-2x"></i>',footer: true,exportOptions:
	 { columns: [0,1,2,3] },title:"<center>Daily delivery return list<br><small>"+srh_from_date+"</small></center>"},
							{ extend: 'excel', text: '<i class="far fa-file-excel fa-2x"></i>Excel',footer: true,
							//exportOptions:	 { columns: [0,1,2,3] },
							title:"Daily delivery return list"},
							 { extend: 'pdf', text: '<i class="far fa-file-pdf fa-2x"></i>PDF',footer: true,exportOptions:
	 { columns: [0,1,2,3] },title:"Daily delivery return list"},							 
						],
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports_marketing/get_delivery_return_list_by_date');?>?rep_id='+sales_rep_id +'&from_date='+srh_from_date,
							'data': {							  
							}
							},
					        "bDestroy": true,
					        "iDisplayLength": 10,
					        "bDestroy": true,
					        "iDisplayLength": 20,
							"order": [[ 0, "asc" ]], "fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay) {
				
				var ser_tot3=0;
				var ser_tot2=0;
				var ser_tot1=0;
				var ser_tot4=0;				
                for (var i = 0; i < aaData.length; i++) {					
				ser_tot2 += parseFloat(aaData[[i]][2]);
                }					
                var nCells = nRow.getElementsByTagName('th');
				nCells[2].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 2, ",", ".")+' </div>';
				
            }
					    });
		}
		
		function loadGrid3() {
			var srh_from_date=$('#srh_from_date').val();			
			var sales_rep_id=$('#sales_rep_id').val();			
						
					    $('#payment_item_table').DataTable({
							dom: 'Blfrtip',
				lengthMenu: [[10, 25, 50, -1 ], [10, 25, 50, "All"]],
				buttons: [
						{ extend: 'copy', text: '<i class="fa fa-copy fa-2x"></i>',footer: true, exportOptions:
				 [ 0,1,2,3,4]},
						   { extend: 'print', text: '<i class="fa fa-print fa-2x"></i>',footer: true,exportOptions:
	 { columns: [0,1,2,3,4] },title:"<center>Daily delivery sales list <br><small>"+srh_from_date+"</small></center>"},
							{ extend: 'excel', text: '<i class="far fa-file-excel fa-2x"></i>Excel',footer: true,
							//exportOptions:	 { columns: [0,1,2,3] },
							title:"Daily delivery sales list "},
							 { extend: 'pdf', text: '<i class="far fa-file-pdf fa-2x"></i>PDF',footer: true,exportOptions:
	 { columns: [0,1,2,3,4] },title:"Daily delivery sales list "},							 
						],
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports_marketing/get_delivery_payment_list_by_date');?>?rep_id='+sales_rep_id +'&from_date='+srh_from_date,
							'data': {							  
							}
							},
					        "bDestroy": true,
					        "iDisplayLength": 10,
					        "bDestroy": true,
					        "iDisplayLength": 20,
							"order": [[ 1, "desc" ]], "fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay) {
				
				var ser_tot3=0;
				var ser_tot2=0;
				var ser_tot1=0;
				var ser_tot4=0;				
                for (var i = 0; i < aaData.length; i++) {					
					//ser_tot2 += parseFloat(aaData[[i]][2]);	
					ser_tot4 += parseFloat(aaData[[i]][4]);
					//ser_tot4 += parseFloat(aaData[[i]][4]);
								
                }					
                var nCells = nRow.getElementsByTagName('th');
				//nCells[2].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 2, ",", ".")+' </div>';				
				nCells[4].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot4, "", 2, ",", ".")+' </div>';
				
            }
					    });
		}
		
			function loadGrid4() {
			var srh_from_date=$('#srh_from_date').val();			
			var sales_rep_id=$('#sales_rep_id').val();			
						
					    $('#expencess_item_table').DataTable({
							dom: 'Blfrtip',
				lengthMenu: [[10, 25, 50, -1 ], [10, 25, 50, "All"]],
				buttons: [
						{ extend: 'copy', text: '<i class="fa fa-copy fa-2x"></i>',footer: true, exportOptions:
				 [ 0,1,2,3]},
						   { extend: 'print', text: '<i class="fa fa-print fa-2x"></i>',footer: true,exportOptions:
	 { columns: [0,1,2,3] },title:"<center>Daily delivery sales list <br><small>"+srh_from_date+"</small></center>"},
							{ 
							    extend: 'excel',
							    text: '<i class="far fa-file-excel fa-2x"></i>Excel',
							    footer: true,
							    //exportOptions:{ columns: [0,1,2,3] },
							    title:"Daily delivery sales list "},
							    
							 { extend: 'pdf', text: '<i class="far fa-file-pdf fa-2x"></i>PDF',footer: true,exportOptions:
	 { columns: [0,1,2,3] },title:"Daily delivery sales list "},							 
						],
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports_marketing/get_delivery_expencess_list_by_date');?>?rep_id='+sales_rep_id +'&from_date='+srh_from_date,
							'data': {							  
							}
							},
					        "bDestroy": true,
					        "iDisplayLength": 10,
					        "bDestroy": true,
					        "iDisplayLength": 20,
							"order": [[ 1, "desc" ]], "fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay) {
				
				var ser_tot3=0;
				var ser_tot2=0;
				var ser_tot1=0;
				var ser_tot4=0;				
                for (var i = 0; i < aaData.length; i++) {					
					ser_tot2 += parseFloat(aaData[[i]][4]);	
					ser_tot3 += parseFloat(aaData[[i]][5]);
					ser_tot4 += parseFloat(aaData[[i]][7]);
								
                }					
                var nCells = nRow.getElementsByTagName('th');
				nCells[4].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 2, ",", ".")+' </div>';				
				nCells[5].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot3, "", 2, ",", ".")+' </div>';
				nCells[7].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot4, "", 2, ",", ".")+' </div>';
				
            }
					    });
		}
		
			function loadGrid5() {
			var srh_from_date=$('#srh_from_date').val();			
			var sales_rep_id=$('#sales_rep_id').val();			
						
					    $('#bank_deposit_item_table').DataTable({
							dom: 'Blfrtip',
				lengthMenu: [[10, 25, 50, -1 ], [10, 25, 50, "All"]],
				buttons: [
						{ extend: 'copy', text: '<i class="fa fa-copy fa-2x"></i>',footer: true, exportOptions:
				 [ 0,1,2,3]},
						   { extend: 'print', text: '<i class="fa fa-print fa-2x"></i>',footer: true,exportOptions:
	 { columns: [0,1,2,3] },title:"<center>Daily delivery sales list <br><small>"+srh_from_date+"</small></center>"},
							{ extend: 'excel', text: '<i class="far fa-file-excel fa-2x"></i>Excel',footer: true,
						//	exportOptions:	 { columns: [0,1,2,3] },
							title:"Daily delivery sales list "},
							 { extend: 'pdf', text: '<i class="far fa-file-pdf fa-2x"></i>PDF',footer: true,exportOptions:
	 { columns: [0,1,2,3] },title:"Daily delivery sales list "},							 
						],
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports_marketing/get_delivery_deposit_list_by_date');?>?rep_id='+sales_rep_id +'&from_date='+srh_from_date,
							'data': {							  
							}
							},
					        "bDestroy": true,
					        "iDisplayLength": 10,
					        "bDestroy": true,
					        "iDisplayLength": 20,
							"order": [[ 1, "desc" ]], "fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay) {
				
				var ser_tot3=0;
				var ser_tot2=0;
				var ser_tot1=0;
				var ser_tot4=0;				
                for (var i = 0; i < aaData.length; i++) {					
				//	ser_tot2 += parseFloat(aaData[[i]][4]);	
					ser_tot3 += parseFloat(aaData[[i]][5]);
				//	ser_tot4 += parseFloat(aaData[[i]][7]);
								
                }					
                var nCells = nRow.getElementsByTagName('th');
			//	nCells[4].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 2, ",", ".")+' </div>';				
				nCells[5].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot3, "", 2, ",", ".")+' </div>';
			//	nCells[7].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot4, "", 2, ",", ".")+' </div>';
				
            }
					    });
		}
		function load_summary(){
		$.post('<?php echo base_url('reports_marketing/get_delivery_summary');?>?',
        {
          delivery_id: $('#sales_rep_id').val(),
          srh_from_date:$('#srh_from_date').val() 
        },
        function(data,status){
			var obj = JSON.parse(data);
			document.getElementById("total_sale_field").innerHTML =accounting.formatMoney(obj.sale_total, "", 2, ",", ".");
			document.getElementById("total_cost_field").innerHTML =accounting.formatMoney(obj.cost_total, "", 2, ",", ".");
		    document.getElementById("gross_profit_field").innerHTML =accounting.formatMoney(obj.gross_profit, "", 2, ",", ".")+" ( "+obj.gross_profit_precentage+ " )";
		    document.getElementById("total_expenses_field").innerHTML =accounting.formatMoney(obj.expencess_total, "", 2, ",", ".");
		    document.getElementById("net_profit__field").innerHTML =accounting.formatMoney(obj.net_profit, "", 2, ",", ".")+" ( "+obj.net_profit_precentage+ " )";
			document.getElementById("total_expenses_field").innerHTML =accounting.formatMoney(obj.expencess_total, "", 2, ",", ".");
			document.getElementById("total_collected_payment_field").innerHTML =accounting.formatMoney(obj.payment_total, "", 2, ",", ".");
			document.getElementById("total_collected_cash_field").innerHTML =accounting.formatMoney(obj.cash_total, "", 2, ",", ".");
			document.getElementById("total_collected_cheque_field").innerHTML =accounting.formatMoney(obj.cheque_total, "", 2, ",", ".");
			document.getElementById("total_bank_deposit_field").innerHTML =accounting.formatMoney(obj.bank_deposit_total, "", 2, ",", ".");
			document.getElementById("total_cash_on_hand_field").innerHTML =accounting.formatMoney(obj.onhand_total, "", 2, ",", ".");
			document.getElementById("area_field").innerHTML =obj.area_name;
			document.getElementById("date_field").innerHTML =obj.date;
			document.getElementById("rep_field").innerHTML =obj.rep;
			document.getElementById("total_sale_return_cost_field").innerHTML =obj.total_return_cost;
			document.getElementById("total_sale_return_field").innerHTML =obj.total_return_value;
			document.getElementById("total_collected_credit_note_field").innerHTML =obj.credit_note_total;
			document.getElementById("total_finance_expencess_field").innerHTML =obj.expencess_total;
			document.getElementById("total_item_discount").innerHTML =obj.item_discount_total;
			document.getElementById("total_item_discount_in_sale").innerHTML =accounting.formatMoney(obj.item_discount_in_sale, "", 2, ",", ".")+" %";
			
			
        });	
		}
		
		function loadGrid6() {
			var srh_from_date=$('#srh_from_date').val();	
			var srh_to_date=$('#srh_to_date').val();
			var sales_rep_id=$('#sales_rep_id').val();			
						
					    $('#delivery_product_table').DataTable({
							dom: 'Blfrtip',
				lengthMenu: [[10, 25, 50, -1 ], [10, 25, 50, "All"]],
				buttons: [
						{ extend: 'copy', text: '<i class="fa fa-copy fa-2x"></i>',footer: true, exportOptions:
				 [ 0,1,2,3,4,5]},
						   { extend: 'print', text: '<i class="fa fa-print fa-2x"></i>',footer: true,exportOptions:
	 { columns: [0,1,2,3,4,5] },title:"PRODUCTION REPORT "+srh_from_date+"  to "+srh_to_date},
							{ extend: 'excel', text: '<i class="far fa-file-excel fa-2x"></i>Excel',footer: true,
						//	exportOptions:	 { columns: [0,1,2,3] },
							title:"PRODUCTION REPORT "},
							 { extend: 'pdf', text: '<i class="far fa-file-pdf fa-2x"></i>PDF',footer: true,exportOptions:
	 { columns: [0,1,2,3,4,5] },title:"PRODUCTION REPORT  "},							 
						],
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('report_stock_ctrl/get_production_data');?>?rep_id='+sales_rep_id +'&from_date='+srh_from_date+'&to_date='+srh_to_date,
							'data': {							  
							}
							},
					        "bDestroy": true,
					        "iDisplayLength": 50,
					        "bDestroy": true,
							"order": false, "fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay) {
				
				var ser_tot3=0;
				var ser_tot2=0;
				var ser_tot1=0;
				var ser_tot4=0;				
                for (var i = 0; i < aaData.length; i++) {					
					ser_tot2 += parseFloat(aaData[[i]][6]);	
					ser_tot3 += parseFloat(aaData[[i]][7]);
				ser_tot4 += parseFloat(aaData[[i]][8]);
								
                }					
                var nCells = nRow.getElementsByTagName('th');
				nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 2, ",", ".")+' </div>';				
				nCells[7].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot3, "", 2, ",", ".")+' </div>';
				nCells[8].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot4, "", 2, ",", ".")+' </div>';
				
            }
					    });
		}
		
		//############################################################################################### 2021-12-23 sachtih ernaga 
		function loadGrid7() {
			var srh_from_date=$('#srh_from_date').val();			
			var sales_rep_id=$('#sales_rep_id').val();			
						
					    $('#sales_sale_return_table').DataTable({
							dom: 'Blfrtip',
				lengthMenu: [[10, 25, 50, -1 ], [10, 25, 50, "All"]],
				buttons: [
						{ extend: 'copy', text: '<i class="fa fa-copy fa-2x"></i>',footer: true, exportOptions:
				 [ 0,1,2,3]},
						   { extend: 'print', text: '<i class="fa fa-print fa-2x"></i>',footer: true,
						    exportOptions:{ columns: [0,1,2,3] },title:"<center>Daily delivery sales list <br><small>"+srh_from_date+"</small></center>"
						   },
						   {
						       extend: 'excel', text: '<i class="far fa-file-excel fa-2x"></i>Excel',footer: true,
						   //exportOptions:{ columns: [0,1,2,3] },
						   title:"Daily delivery sales list "},
							 { extend: 'pdf', text: '<i class="far fa-file-pdf fa-2x"></i>PDF',footer: true,exportOptions:
	 { columns: [0,1,2,3] },title:"Delivery market return list "},							 
						],
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports_marketing/get_delivery_market_return_items');?>?id='+sales_rep_id +'&from_date='+srh_from_date,
							'data': {							  
							}
							},
					        "bDestroy": true,
					        "iDisplayLength": 10,
					        "bDestroy": true,
					        "iDisplayLength": 20,
							"order": [[ 1, "desc" ]], "fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay) {
				
				var ser_tot6=0;
				var ser_tot5=0;
				var ser_tot4=0;
				var ser_tot3=0;
				var ser_tot2=0;
				var ser_tot1=0;
								
                for (var i = 0; i < aaData.length; i++) {
                    ser_tot1 += parseFloat(aaData[[i]][2]);
					ser_tot2 += parseFloat(aaData[[i]][3]);	
					ser_tot3 += parseFloat(aaData[[i]][4]);
					ser_tot4 += parseFloat(aaData[[i]][5]);
					ser_tot5 += parseFloat(aaData[[i]][6]);
					ser_tot6 += parseFloat(aaData[[i]][7]);
								
                }					
                var nCells = nRow.getElementsByTagName('th');
				nCells[2].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';				
				nCells[3].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 2, ",", ".")+' </div>';
				nCells[4].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot3, "", 2, ",", ".")+' </div>';
				nCells[5].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot4, "", 2, ",", ".")+' </div>';
				nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot5, "", 2, ",", ".")+' </div>';
				nCells[7].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot6, "", 2, ",", ".")+' </div>';
            }
					    });
		}
		
			//############################################################################################### 2021-12-23 sachtih ernaga 
		function loadGrid8() {
			var srh_from_date=$('#srh_from_date').val();			
			var sales_rep_id=$('#sales_rep_id').val();			
						
					    $('#sales_cus_return_product_table').DataTable({
							dom: 'Blfrtip',
				lengthMenu: [[10, 25, 50, -1 ], [10, 25, 50, "All"]],
				buttons: [
						{ extend: 'copy', text: '<i class="fa fa-copy fa-2x"></i>',footer: true, exportOptions:
				 [ 0,1,2,3]},
						   { extend: 'print', text: '<i class="fa fa-print fa-2x"></i>',footer: true,
						    exportOptions:{ columns: [0,1,2,3] },title:"<center>Daily delivery sales list <br><small>"+srh_from_date+"</small></center>"
						   },
						   {
						       extend: 'excel', text: '<i class="far fa-file-excel fa-2x"></i>Excel',footer: true,
						   //exportOptions:{ columns: [0,1,2,3] },
						   title:"Daily delivery sales list "},
							 { extend: 'pdf', text: '<i class="far fa-file-pdf fa-2x"></i>PDF',footer: true,exportOptions:
	 { columns: [0,1,2,3] },title:"Delivery market return list "},							 
						],
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports_marketing/get_delivery_customer_wise_market_return_items');?>?id='+sales_rep_id +'&from_date='+srh_from_date,
							'data': {							  
							}
							},
					        "bDestroy": true,
					        "iDisplayLength": 10,
					        "bDestroy": true,
					        "iDisplayLength": 20,
							"order": [[ 1, "desc" ]], "fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay) {
				
				var ser_tot6=0;
				var ser_tot5=0;
				var ser_tot4=0;
				var ser_tot3=0;
				var ser_tot2=0;
				var ser_tot1=0;
								
                for (var i = 0; i < aaData.length; i++) {
                    ser_tot1 += parseFloat(aaData[[i]][8]);
					ser_tot2 += parseFloat(aaData[[i]][9]);	
					ser_tot3 += parseFloat(aaData[[i]][10]);
								
                }					
                var nCells = nRow.getElementsByTagName('th');
				nCells[8].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';				
				nCells[9].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 2, ",", ".")+' </div>';
				nCells[10].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot3, "", 2, ",", ".")+' </div>';
			
            }
					    });
		}





		

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