<?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="#"> Marketing Reports </a> </li>
        <li class="active">Daily Delivery Summary
        <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>Daily Delivery Summary</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> Daily Delivery Summary
          <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>Delivery Name </label>
                  <select id="sales_rep_id" class="form-control" name="sales_rep_id">
                    <option value="">-- ALL-</option>
                    <?php 
							$ss_warehouse_id=$this->session->userdata('ss_warehouse_id'); 
                             foreach ($delivery_list as $row)
                               {
							
                        ?>
                    <option value="<?php echo $row['id']; ?>" > <?php echo $row['loading_ref_no']." (".$row['vehicle_code'].")"; ?> </option>
                    <?php }?>
                  </select>
                </div>
              </div>
              <div class="col-sm-4">
                <div class="form-group">
                  <label>Date </label>
                  <input 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 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">
            <div class="panel-heading"> <i class="fa fa-external-link-square"></i> Daily delivery sales list </div>
            <div class="panel-body">
              <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="sales_sale_table">
                <thead>
                  <tr>
                   <th>Product Code</th>
                    <th>Product Name</th>
                    <th>Sale Qty</th>
                    <th>Gross Total</th>
                  </tr>
                </thead>
                <tfoot>
                  <tr>
                     <th>Product Code</th>
                    <th>Product Name</th>
                    <th>Sale Qty</th>
                    <th>Gross Total</th>
                  </tr>
                </tfoot>
              </table>
            </div>
          </div>
          <div class="panel">
            <div class="panel-heading"> <i class="fa fa-external-link-square"></i> Daily delivery return list  </div>
            <div class="panel-body">
              <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>Return Qty</th>
                    <th>Return Date</th>
                  </tr>
                </thead>
                <tfoot>
                  <tr>
                    <th>Product Code</th>
                    <th>Product Name</th>
                    <th>Return Qty</th>
                    <th>Return Date</th>
                  </tr>
              </table>
            </div>
          </div>
          
           <div class="panel">
            <div class="panel-heading"> <i class="fa fa-external-link-square"></i> Delivery Expences list  </div>
            <div class="panel-body">
              <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="return_item_table">
                <thead>
                  <tr>
                   <th>Tranpost Ex Code</th>
                    <th>Category</th>
                    <th>Roule</th>
                    <th>Amount</th>
                  </tr>
                </thead>
                <tfoot>
                  <tr>
                     <th>Tranpost Ex Code</th>
                    <th>Category</th>
                    <th>Roule</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>
		
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();
					loadGridReturn();
					//load_summary();
		}
				
				
			jQuery(document).ready(function() {
				
				
				FormElements.init();
				
				//var currentDate = new Date();
				var tomorrow = new Date();
				currentDate=tomorrow.setDate(tomorrow.getDate() + 1);
				
				//TableData.init();
				//loadGrid();
				//loadGridSalesReturn();
			});


function loadGrid() {
			var srh_from_date=$('#srh_from_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]},
						   { 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_sale_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_tot1 += parseFloat(aaData[[i]][2]);
					ser_tot2 += parseFloat(aaData[[i]][3]);
					ser_tot3 += parseFloat(aaData[[i]][4]);
					ser_tot4 += parseFloat(aaData[[i]][5]);		*/				
                }					
                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>';*/
				
            }
					    });
		}
	
	
	
	
	
	
	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": [[ 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]][2]);
					ser_tot2 += parseFloat(aaData[[i]][3]);
					ser_tot3 += parseFloat(aaData[[i]][4]);
					ser_tot4 += parseFloat(aaData[[i]][5]);		*/				
                }					
                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>';*/
				
            }
					    });
		}
	
		

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