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

$profit_hide='';
$profit_hide=1;

?>

		<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/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="fa fa-list"></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="<?php echo base_url('sales'); ?>">
										 Sales 
									</a>
								</li>
                               
								<li class="active">
									List Sales
								</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>Invoiced Items</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>
									Invoied items
                                    <div class="panel-tools" style="top:2px;">
                                        
                                        <!-- 
												<button class="btn btn-blue dropdown-toggle" data-toggle="dropdown">
													<i class="clip-list-5"></i> Add New
												</button>
												<ul class="dropdown-menu dropdown-light pull-right">
														<li>
															<a id="" data-toggle="modal" href="<?php echo base_url('sales/add'); ?>">
																<i class="fa fa-plus"></i> Add Sales
															</a>
														</li>
														
													</ul>
													-->
												</div>
								</div>
								</div>
                                <!--seach start-->
                                
<?php $ss_group_id=$this->session->userdata('ss_group_id') ?>
              
                              <div class="col-sm-12">
	<div class="form-group" <?php if ($ss_group_id==1 || $ss_group_id==9 || $ss_group_id==8) echo ""; else echo " style=\"display:none;\""; ?>>
															<label>Warehouse </label>
                                                        <select multiple='multiple' id="srh_warehouse_id" class="form-control search-select" name="srh_warehouse_id">           
																  <?php 
																 $ss_warehouse_id=$this->session->userdata('ss_warehouse_id'); 
                                                              foreach ($warehouse_list as $row)
                                                              {
																  $sel='';
																  if($ss_warehouse_id==$row->id)
																  {
																	  $sel=' selected="selected"';
																  }
                                                              ?>  
                                                                        
															<option value="<?php echo $row->id; ?>" <?php echo $sel; ?>>
																		<?php echo $row->name; ?>
                                                                        </option>
                                                              <?php }?>
																		
                                                                        
 <option value="">-All-</option> 
																	</select>                                          
														</div>
														</div>
 <div class="col-sm-3">
                                                      	<div class="form-group">

															<label>Sales Rep. </label>

                                                            <?php //print_r($rep_list);?>

                                                       <select id="srh_sales_rep_id" class="form-control" name="srh_sales_rep_id">

                                                               

																 <option value="">-All-</option>

									                            <?php 

															

															foreach ($rep_list as $row)

															{

																

															?> 

 <option value="<?php echo $row->user_id;?>"><?php echo $row->user_first_name; if($row->user_phone) echo " / ".$row->user_phone;?>  </option>

															 <?php }  ?>

							                              </select>                                       

														</div>

													  </div>                                                        
                                                        
<div class="col-sm-3">
<div class="form-group">
<label>Department </label>
<?php 

?>

<select class="form-control" id="category" name="category">
												<option value="">-All-</option>
													<?php foreach ($category_list as $key => $category) 
													{
														if($category->cat_name)
														{
															$sel='';
															//if($category->cat_id==3) $sel='selected';
															?>
														<option <?php echo $sel ?> value="<?php echo $category->cat_id; ?>"><?php echo $category->cat_name; ?></option>										
													<?php 
													}  } ?>
												</select>                                        
</div>
</div> 

 <div class="col-sm-3">                                                       
  <div class="form-group">
											<label class=" control-label" for="form-field-3" >
												Category 
											</label>
											
											
											
											
                                           <!--  <div id="subcat_data">
											<select onChange="" data-placeholder="Select Category to load Subcategories" id="subcategory" class="form-control search-select" name="subcategory">
											<option selected="selected" value=""></option>
											</select>
                                            </div>
                                            -->
                                            
                                            <select id="srh_sub_cat" class="form-control search-select" name="srh_sub_cat">
                                                <option value="">-Select-</option>
											         
											         <?php
											         foreach ($sub_category as $key => $item)
											{
											$sel_com='';
											
											?>
                    <option value="<?php echo $item->sub_cat_id;?>" <?php echo $sel_com;?>><?php echo $item->sub_cat_name;?></option>
                    <?php } ?>
											         
                       
                      </select>
											</div>
										</div>  

<div class="col-sm-3">                                                       
  <div class="form-group">
      
      <label class=" control-label" for="form-field-3" >
												Brand
											</label>
											
											<?php
											
											 //print_r($department_list);
											 ?>
											
											<select id="dep_id" class="form-control search-select" name="dep_id">
											         
											         <?php
											         
											         $sel_s='';
											         $sel_ser='';
											        
											        
											         ?>
											        
											        <option value=""<?php //echo $sel_0; ?>>-Select-</option> 
											        
											          <?php 
											     //department_list
											
											foreach ($department_list as $key => $item)
											{
											$sel_com='';
											 if($product_details->dep_id==$item->department_id){
											             $sel_com='selected';
											         }
											?>
											         <option value="<?php echo $item->department_id;?>" <?php echo $sel_com;?>><?php echo $item->department_name;?></option>
											         <?php } ?>
											         <!-- 
											         <option value="1"<?php echo $sel_s; ?>>Mobile Phone</option>
                        
                        <option value="2"<?php echo $sel_ser; ?>>Service Repair</option>
                        
                        <option value="3"<?php echo $sel_com; ?>>Computer</option> -->
                       
                      </select>
      </div>
      </div>  

<!-- 
	<div class="col-sm-3">                                                       
  <div class="form-group">
      
      <label class=" control-label" for="form-field-3" >
												Brand
											</label>
											
											<?php
											
											 //print_r($department_list);
											 ?>
											
											<select id="dep_id" class="form-control search-select" name="dep_id">
											         
											         <?php
											         
											         $sel_s='';
											         $sel_ser='';
											        
											        
											         ?>
											        
											        <option value=""<?php //echo $sel_0; ?>>-Select-</option> 
											        
											          <?php 
											     //department_list
											
											foreach ($department_list as $key => $item)
											{
											$sel_com='';
											 if($product_details->dep_id==$item->department_id){
											             $sel_com='selected';
											         }
											?>
											         <option value="<?php echo $item->department_id;?>" <?php echo $sel_com;?>><?php echo $item->department_name;?></option>
											         <?php } ?>
											         
                       
                      </select>
      </div>
      </div>
      -->
      
       <div class="col-md-3">
<div class="form-group">
<label>Item  </label><?php //print_r($suppliers);?>

<input type="hidden" id="product_id"  name="product_id" class="js-data-product-sn-ajax form-control" style="padding:0px 0px; border: none; box-shadow: none" placeholder="-Select Item-" onChange="setitemselect()"/>

</div>
</div>  
                                                         
                                                        
                                                        <div class="col-sm-3">
                                                      	<div class="form-group">
															<label>From Date  </label>
                                                         <!--<input id="srh_from_date" name="srh_from_date" type='text' class="form-control date" value="" data-bv-field="date"/>-->
                                                         <input id="srh_from_date" name="srh_from_date" type='text' class="form-control date-picker" value="<?php echo date('m/d/Y'); ?>" data-bv-field="date"/>                                                             
														</div>
														</div>
                                                        
                                                        <div class="col-sm-3">
                                                      	<div class="form-group">
															<label for="s2id_autogen1">To Date </label>
                                                          
															 <input id="srh_to_date" name="srh_to_date" type='text' class="form-control date-picker" value="<?php echo date('m/d/Y'); ?>" data-bv-field="date"/>        
														</div>
													</div>
                                                    
                                                     <div class="col-sm-3">
                                                      	<div class="form-group">
															<label for="s2id_autogen1"><strong>Summary</strong></label>
                                                          <br>
                                                          <div id="summary_des"></div>
                                                          
                                                            
                                                           
                                                         <!-- <label for="s2id_autogen1">Phones</label>
                                                          <br>
                                                          <label for="s2id_autogen1">Accessories</label>
                                                          <br>
                                                          <label for="s2id_autogen1">Tab</label>
                                                          <br>-->

															    
														</div>
													</div>
                                                    
                                                    <div class="col-sm-3 pull-right">
                                                      	<div class="form-group">
															<label for="s2id_autogen1">&nbsp;<br><br>
</label>
                                                          
															 <input type="submit" name="add_category" value="Search" class="btn btn-primary" onClick="searchDetails()"> &nbsp;&nbsp;
                                                             
                                                             <input type="submit" name="add_category" value="Reset" class="btn btn-danger" onClick="searchDetailsReset()">
														</div>
													</div>  
                                                    
                                <!--end search-->
                                
                                
                               
                                
                                
    <div class="col-sm-12">&nbsp;</div> 
                           
                                
							  <div class="panel-body">
							    <div id="error"></div>
								  <table width="100%" class="table table-bordered table-condensed table-hover table-striped dataTable" id="warehouse_table">
									  <thead>
							            <tr>
                                    <th class="col-sm-2">Date</th>
                                    <th>Invoice No</th>
                                    <th>Customer</th>
									<th>Total Amount</th>
									<th class="col-sm-4">Item Name</th>
								
									<!--<th>Return</th>
									<th>Total to be paid</th>
									<th>Paid</th>
                                    <th>Balance</th>
                                    <th>Payment Status</th>
                                     <th>Cost</th>-->
                                    <?php  if($this->session->userdata('ss_group_id')==1){ ?>
                                        <th>Cost</th>
                                    <?php } ?>
                                    
                                    <th>Tot.  Items </th>
                                    <th><?php if(!$profit_hide) echo "Profit";?></th>
                                   	<th class="col-sm-">Serial</th>
                                   	<?php  if($this->session->userdata('ss_group_id')==1){ ?>
                                        <th>Serial Cost</th>
                                    <?php } ?>
                                        </tr>
							          </thead>
							          <tfoot>
        								<tr>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                            <th>&nbsp;</th>
                                           
        									<th>&nbsp;</th>
        									<th>&nbsp;</th>
        									<!--<th>&nbsp;</th>
        									<th>&nbsp;</th>
        									<th>Paid</th>
                                            <th>Balance</th>
                                            <th>Payment Status</th>
                                            <th>&nbsp;</th>-->
                                            <?php  if($this->session->userdata('ss_group_id')==1){ ?>
                                                <th>&nbsp;</th>
                                            <?php } ?>
                                             <th>&nbsp;</th>
                                             <th>&nbsp;</th>
                                             <th>&nbsp;</th>
                                             <?php  if($this->session->userdata('ss_group_id')==1){ ?>
                                                <th>&nbsp;</th>
                                            <?php } ?>
                                     
                                        </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">
				
			</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>

		<!-- 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"); ?>
		<!-- end: MAIN JAVASCRIPTS -->
		<!--<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" src="<?php echo asset_url(); ?>js/accounting.js"></script>
          <script type="text/javascript" src="<?php echo asset_url(); ?>js/accounting.min.js"></script>
          	<script type="text/javascript" src="<?php echo asset_url(); ?>js/bootstrap-datetimepicker.js"></script>-->
   
   
    <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/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="<?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 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" 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 searchDetails(){
				
					loadGrid();
		}
			
jQuery(document).ready(function() {
				
					
				//TableData.init();
				loadGrid();
				
				
			});		
		
		
			jQuery(document).ready(function() {
				//TableData.init();
				loadGrid();
			});


			function loadGrid() {
				var srh_from_date=$('#srh_from_date').val();
				var srh_to_date=$('#srh_to_date').val();
				var srh_warehouse_id=$('#srh_warehouse_id').val();
				var srh_sales_rep_id=$('#srh_sales_rep_id').val();
				var category=$('#category').val();
				var cat_name=$( "#cat_srh option:selected" ).text();
			var sub_cat_name=$( "#subcategory option:selected" ).text();
			var srh_sales_rep_id=$('#srh_sales_rep_id').val();
			var rep_name=$( "#srh_sales_rep_id option:selected" ).text();
			var warehouse_name=$( "#srh_warehouse_id option:selected" ).text();
			var dep_id=$('#dep_id').val();
			var srh_sub_cat=$('#srh_sub_cat').val();
			var product_id=$('#product_id').val();
			
				
				var message="<div  style='text-align:center'>  <h2>"+warehouse_name+"</h2><h5>Rep. : "+rep_name +"</h5><h5>Category: "+cat_name +" , Sub Category: "+sub_cat_name +" </h5><h5>From Date:"+ srh_from_date +" , To Date:"+ srh_to_date +"</h5><h5>Date Created: <?php echo display_date_time_format(date("Y-m-d H:i:s")); ?></h5></div>";

					    $('#warehouse_table').DataTable({
							dom: 'Blfrtip',
						
							buttons: [
									   { extend: 'print', text: '<i class="fa fa-print fa-2x"></i>',footer: true, message: message,title: ''},
									// { extend: 'print', text: 'Print',footer: true, message: message,title: '',
										{ extend: 'excel', text: '<i class="fa fa-file-excel-o fa-2x"></i>',footer: true},
										 { extend: 'pdf', text: '<i class="fa fa-file-pdf-o fa-2x"></i>',footer: true}
										
									],
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('sales/list_sale_items');?>',
							'data': {
							   srh_from_date: srh_from_date,
							   srh_to_date: srh_to_date,
							   srh_warehouse_id: srh_warehouse_id,
							   srh_sales_rep_id: srh_sales_rep_id,
							    category: category,
							    dep_id:dep_id,
							    srh_sub_cat:srh_sub_cat,
							    product_id:product_id
							}
							}, 
							"bProcessing": true,
        					 "serverSide": true,
					        "bDestroy": true,
					        "lengthMenu": [[-1,50,30,40,500 ], ["All",50,30,40, 500]],
							
							"order": [[ 0, "desc" ]], "fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay) {
				
                var pq = 0, sq = 0, bq = 0, pa = 0, grand_tot = 0, tech_tot = 0, parts_tot=0 , ser_tot=0;
				//alert(aaData.length);
				var ser_tot3=0;
				var ser_tot2=0;
				var ser_tot1=0;
				var ser_tot4=0;
				var ser_tot5=0;
				var ser_tot6=0;
				var ser_tot7=0;
				var ser_tot8=0;
				var phone_sub_to=0;
				//var sales_rtn=0;
                for (var i = 0; i < aaData.length; i++) {
					//alert(aaData[[i]][3]);
                   // p = (aaData[aiDisplay[i]][2]).split('__');
				   if(parseFloat(aaData[[i]][3])){
					ser_tot1 += parseFloat(aaData[[i]][3]);
				   }
				   if(parseFloat(aaData[[i]][5])){
					   //alert(aaData[[i]][5]);
					ser_tot5 += parseFloat(aaData[[i]][5]);
				   }
				   if(parseFloat(aaData[[i]][6])){
					   //alert(aaData[[i]][5]);
					ser_tot6 += parseFloat(aaData[[i]][6]);
				   }
				   if(parseFloat(aaData[[i]][7])){
					   //alert(aaData[[i]][5]);
					ser_tot7 += parseFloat(aaData[[i]][7]);
				   }
				   if(parseFloat(aaData[[i]][9])){
					   //alert(aaData[[i]][5]);
					ser_tot8 += parseFloat(aaData[[i]][9]);
				   }
				/*	ser_tot2 += parseFloat(aaData[[i]][4]);
					ser_tot3 += parseFloat(aaData[[i]][5]);	*/
                }
                var nCells = nRow.getElementsByTagName('th');
				nCells[3].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';
				
				<?php if($this->session->userdata('ss_group_id')==1){?>
				
				    nCells[5].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot5, "", 2, ",", ".")+' </div>';
				    
				<?php } ?>
				<?php if($this->session->userdata('ss_group_id')==1){?>
				nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot6, "", 2, ",", ".")+' </div>';
				<?php }?>
				
				nCells[7].innerHTML = '<div class="text-right">'+ser_tot7+' </div>';
				
				<?php if($this->session->userdata('ss_group_id')==1){?>
				    nCells[9].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot8, "", 2, ",", ".")+' </div>';
				<?php }?>
				
				//
				
				//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>';
				
				var sales_rtn_tot_cost=ser_tot1;
				var sales_rtn_tot_val=ser_tot2;
				$('#sales-rtn-cost-fld').val(accounting.formatMoney(sales_rtn_tot_cost, "", 2, ",", "."));
				//$('#sales-rtn-val-fld').val(accounting.formatMoney(sales_rtn_tot_val, "", 2, ",", "."));
				//$('#sales-rtn-cost-tbl').text(accounting.formatMoney(sales_rtn_tot_cost, "", 2, ",", "."));
				//$('#sales-rtn-val-tbl').text(accounting.formatMoney(sales_rtn_tot_val, "", 2, ",", "."));
				
				//set summary
			
				var cat_name=$( "#category option:selected" ).text();
				var srh_sales_rep_name=$( "#srh_sales_rep_id option:selected" ).text();
				$("#cat_tot_amount").html(accounting.formatMoney(ser_tot6, "", 2, ",", "."));
				var cat_tot_amount=ser_tot6;
				//	alert(cat_name);
				
				var summary_des="";
				summary_des+='<div class="col-sm-6" id="cat_name">Sales Rep. : </div>';
				summary_des+='<div class="col-sm-6" id="cat_name">'+srh_sales_rep_name+'</div>';
				
				summary_des+='<div class="col-sm-6" id="cat_name">From Date : </div>';
				summary_des+='<div class="col-sm-6" id="cat_name">'+srh_from_date+'</div>';
				
				summary_des+='<div class="col-sm-6" id="cat_name">To Date : </div>';
				summary_des+='<div class="col-sm-6" id="cat_name">'+srh_to_date+'</div>';
				
				summary_des+='<div class="col-sm-6" id="cat_name">'+cat_name+' : </div>';
				summary_des+='<div class="col-sm-6" id="cat_name">'+accounting.formatMoney(cat_tot_amount, "", 2, ",", ".")+'</div>';
				
				$("#summary_des").html(summary_des);
				
				$("#rep_name").html('Sales Rep.');
				$("#rep_name_val").html(srh_sales_rep_name);
				
				
              
            }
					    });

					}
					
function click_sales_view_btn(sale_id){	
	var $modal = $('#ajax-modal');
	 $('body').modalmanager('loading');
			setTimeout(function () {
				$modal.load('<?php echo base_url("sales/sale_details?sale_id="); ?>'+sale_id, '', function () {
					$modal.modal();
					$(".search-select").select2({
				            placeholder: "Select a State",
				            allowClear: true
				        });
				});
			}, 1000);
}


function fbs_click(id) {
	u=location.href;
	t=document.title;
	window.open('sales/sale_details?sale_id='+id,'sharer','toolbar=0,status=0,width=626,height=700, left=10, top=10,scrollbars=yes');return false;
	

}


function resetfun(){
 this.location.reload();
}
	
	function delete_invoice(sid)
  {
      jQuery.ajax({
       type: "POST",
       url: "<?php echo base_url().'sales/sales_delete?sale_id='?>"+sid,
//       data: 'id='+id,
       cache: false,
       success: function(response)
       {
//		var price = $('#'+count).val();
//		var twoPlacedFloat = parseFloat(price).toFixed(2)
//		$('#'+count).val(twoPlacedFloat);
		displayNotice('page','Successfully Deleted!!');
//		setTimeout(resetfun(),30000);

setTimeout(resetfun, 2000)

    }
     });

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

jQuery(document).ready(function() {

				FormElements.init();

			});
			
		</script>

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