	<?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>
		<!-- 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 Sales Note</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>Daily Sales Note</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>
									Daily Sales Note
                                    <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>Sales Representative Name </label>
                                                       <select id="sales_rep_id" class="form-control" name="sales_rep_id">
                                                                   <option value="">-- Select Representative --</option>
																  <?php 
																 $ss_warehouse_id=$this->session->userdata('ss_warehouse_id'); 
                                                              foreach ($sales_rep_list as $row)
                                                              {
																  $sel='';
																  if($ss_warehouse_id==$row['user_id'])
																  {
																	  $sel=' selected="selected"';
																  }
                                                              ?>  
                                                                        
															<option value="<?php echo $row['user_id']; ?>" <?php echo $sel; ?>>
																		<?php echo $row['user_first_name']; ?>
                                                                        </option>
                                                              <?php }?>
																		
																	</select>                                          
														</div>
														</div>
                                                        
                                                        <div class="col-sm-4">
                                                      	<div class="form-group">
															<label>From Date  </label>
                                                    
                                                         
                                                         <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-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 id="printableArea">



 <div id="printableArea">
  <h3>Daily Sales Summary (Sales Representative)</h3>
 <div class="page-header">
								
							</div> <?php /*
	$daily_sales = new reports_marketing_model();
	
	$results = $daily_sales->get_daily_sale_by_rep_id_and_date_summary_cheque(2,"2017/09/14");
	
	print_r($results);
	 
	*/?>                                        
  <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="">
   <!--<tr>
    <td></td>
    <td class="text-right">  <span id="f-date-txt"></span> <span id="t-date-txt"></span></td>
  </tr>
  <tr>-->
    <th width="50%">Sales Representative Name</th>
    <td width="50%"><div id="sale_rep_name">............</div></td>
  </tr>
  <tr>
    <th>Route</th>
    <td><div id="rout">............</div></td>
  </tr>
  <tr>
    <th>Sales Total</th>
    <td><div id="sales-total-tbl">............</div></td>
  </tr>
   <tr>
    <th>Collected Cash Value</th>
    <td><div id="cash-total-tbl">............</div></td>
  </tr>
  <tr>
    <th>Collected Cheque Value</th>
    <td><div id="cheque-total-tbl">............</div></td>
  </tr>
 
  <tr>
    <th>Total Collected Payments</th>
    <td><div id="total-payment-tbl">............</div></td>
  </tr>
</table>
</div>

</div>
<br>
<br>
<br>

                                          
 <div class="panel-heading">
									<i class="fa fa-external-link-square"></i>
									Sales Item 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>Product Name</th>
                                    <th>Qty</th>
                                   <th>Gross Total</th>
                                   <th>Down Payment</th>
                                   <th>Payment</th>
									<th>Payment By</th>
                                  <!--  <th>To Be Collect</th>-->
									<th>Payment Status</th>
                                    
                                    
                                    
                                    </tr>
							          </thead>
							          <tfoot>
											  <tr>
                                    <th>Card Number / Invoice No</th>
                                    <th>Product Name</th>
                                    <th>Qty</th>
                                   <th>Gross Total</th>
                                   <th>Down Payment</th>
                                   <th>Payment</th>
									<th>Payment By</th>
                                  <!--  <th>To Be Collect</th>-->
									<th>Payment Status</th>
                                    
                                    
                                    </tr>
								           
						          </table>
                                  
                                  
<br>
<div class="panel-heading">
<i class="fa fa-external-link-square"></i>
Sales Invoice List
</div>
<br>

<table class="table table-bordered table-condensed table-hover table-striped dataTable" id="sales_return_table">
									  <thead>
							            <tr>
                                     <th>Card Number / Invoice No</th>
                                    <th>Customer</th>
                                    <th>Sale Total</th>
                                   
                                  <th>Down Payment</th>
                                   <th>Payment</th>
                                   <th>To Be Paid</th>
									<th>Payment By</th>
									
                                    
                                    
                                    
                                    </tr>
							          </thead>
							          <tfoot>
											  <tr>
                                    <th>Card Number / Invoice No</th>
                                    <th>Customer</th>
                                    <th>Sale Total</th>
                                   
                                  <th>Down Payment</th>
                                   <th>Payment</th>
                                   <th>To Be Paid</th>
									<th>Payment By</th>
									
                                    
                                    
                                    </tr>
								           
						          </table>
								</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/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>
		
		var total_sale_payment=0;
		
		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_from_date').val('');
		}
		function searchDetails(){
					
					loadGrid();
					loadGridSalesReturn();
					//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();
			});

var test1=1;
function loadGridSalesReturn() {
	test1=2;
			var srh_from_date=$('#srh_from_date').val();
			
			var sales_rep_id=$('#sales_rep_id').val();
			
							
					    $('#sales_return_table').DataTable({
							
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports_marketing/get_daily_sale_by_rep_id_and_date_final');?>?rep_id='+sales_rep_id +'&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>';
				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>';
				
				
				
				
				
			
				
              
            }
					    });

					}

			function loadGrid() {
				
				
				
			var srh_from_date=$('#srh_from_date').val();
			
			var sales_rep_id=$('#sales_rep_id').val();
			
			
			
			
		  $.post('<?php echo base_url('reports_marketing/get_daily_sale_by_rep_id_and_date_summary');?>?rep_id='+sales_rep_id +'&date='+srh_from_date,
        {
          //name: "Donald Duck",
          //city: "Duckburg"
        },
        function(data,status){
			
			
			var obj = JSON.parse(data);
			
			//window.alert(obj.data.all_downpayment); 
			
			document.getElementById("sales-total-tbl").innerHTML =accounting.formatMoney(obj.data.all_sale_total, "", 2, ",", ".");
			//document.getElementById("total-payment-tbl").innerHTML =accounting.formatMoney(total_sale_payment, "", 2, ",", ".");
			document.getElementById("sale_rep_name").innerHTML =(obj.data.user_first_name);
			document.getElementById("rout").innerHTML =(obj.data.route_name);
			//window.alert(total_sale_payment);
			//$('#sales-total-tbl').val(accounting.formatMoney(obj.data.all_sale_total, "", 2, ",", "."));
			
        });			
			
			
			$.post('<?php echo base_url('reports_marketing/get_daily_sale_by_rep_id_and_date_summary_cash');?>?rep_id='+sales_rep_id +'&date='+srh_from_date,
        {
          //name: "Donald Duck",
          //city: "Duckburg"
        },
        function(data,status){
			
			
			var obj = JSON.parse(data);
			
			var cash_value=parseFloat(obj.data.all_cash_sale_pymnt_amount);
			
			if(isNaN(cash_value))
			{
				cash_value=0;
			}
			
			total_sale_payment=total_sale_payment+cash_value;
			//window.alert(total_sale_payment);
			//window.alert(obj.data.all_downpayment); 
			//document.getElementById("total-payment-tbl").innerHTML =accounting.formatMoney(total_sale_payment, "", 2, ",", ".");
			
			document.getElementById("cash-total-tbl").innerHTML =accounting.formatMoney(obj.data.all_cash_sale_pymnt_amount, "", 2, ",", ".");
			
			
        });	
		
		$.post('<?php echo base_url('reports_marketing/get_daily_sale_by_rep_id_and_date_summary_cheque');?>?rep_id='+sales_rep_id +'&date='+srh_from_date,
        {
          //name: "Donald Duck",
          //city: "Duckburg"
        },
        function(data,status){
			
			
			var obj = JSON.parse(data);
			
			//window.alert(obj.data.all_downpayment);
			var Cheqe_value=parseFloat(obj.data.all_cheque_sale_pymnt_amount);
			
			if(isNaN(Cheqe_value))
			{
				Cheqe_value=0;
			}
			 
			total_sale_payment=total_sale_payment+ Cheqe_value;
			//window.alert(total_sale_payment);
			document.getElementById("total-payment-tbl").innerHTML =accounting.formatMoney(total_sale_payment, "", 2, ",", ".");
			document.getElementById("cheque-total-tbl").innerHTML =accounting.formatMoney(obj.data.all_cheque_sale_pymnt_amount, "", 2, ",", ".");
			
			
        });			
			
			
			
							
					    $('#warehouse_table').DataTable({
							
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports_marketing/get_daily_sale_by_rep_id_and_date');?>?rep_id='+sales_rep_id +'&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_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]);
					
					
						
                }
				
			
				
				
				
				
				
				
			
                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 fbs_click(url) {
		var srh_from_date=$('#srh_from_date').val();
			
			var sales_rep_id=$('#sales_rep_id').val();
	
	u=location.href;
	t=document.title;
	url='<?php echo base_url();?>'+'reports_marketing/get_daily_sale_by_rep_id_and_date_summary_print?rep_id='+sales_rep_id +'&date='+srh_from_date;
	window.open(url,'sharer','toolbar=0,status=0,width=750,height=436, left=10, top=10,scrollbars=yes');return false;
}





</script>

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