	<?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;
			}
#s2id_srh_customer_id{
	border: 0 none;
padding: 0;
}
button.dt-button, div.dt-button, a.dt-button {
  -moz-user-select: none;
  background-color: #e9e9e9;
  background-image: linear-gradient(to bottom, #fff 0%, #e9e9e9 100%);
  border: 1px solid #999;
  border-radius: 2px;
  box-sizing: border-box;
  color: black;
  cursor: pointer;
  display: inline-block;
  font-size: 0.88em;
  margin-right: 0.333em;
  outline: medium none;
  overflow: hidden;
  padding: 0.5em 1em;
  position: relative;
  text-decoration: none;
  white-space: nowrap;
}

.enquery_spe_cls{
   font-weight: bolder;
    text-decoration: underline;
    background-color: #5cb85c;
    padding: 3px;
}

		</style>
        
		<!-- end: CSS REQUIRED FOR THIS PAGE ONLY -->
	<!-- end: HEAD -->
	<!-- start: BODY -->
	<body>
		<!-- start: HEADER -->
		<div class="navbar navbar-inverse navbar-fixed-top">
			<!-- start: TOP NAVIGATION CONTAINER -->
			<div class="container">
				<div class="navbar-header">
					<!-- start: RESPONSIVE MENU TOGGLER -->
					<button data-target=".navbar-collapse" data-toggle="collapse" class="navbar-toggle" type="button">
						<span class="clip-list-2"></span>
					</button>
					<!-- end: RESPONSIVE MENU TOGGLER -->
					<!-- start: LOGO -->
					<?php $this->load->view("common/logo"); ?>
					<!-- end: LOGO -->
				</div>
				<div class="navbar-tools">
					<!-- start: TOP NAVIGATION MENU -->
				<?php $this->load->view("common/notifications.php"); ?>
					<!-- end: TOP NAVIGATION MENU -->
				</div>
			</div>
			<!-- end: TOP NAVIGATION CONTAINER -->
		</div>
		<!-- end: HEADER -->
		<!-- start: MAIN CONTAINER -->
		<div class="main-container">
			<div class="navbar-content">
				<!-- start: SIDEBAR -->
				<?php $this->load->view("common/navigation"); ?>
				<!-- end: SIDEBAR -->
			</div>
			<!-- start: PAGE -->
			<div class="main-content">
				<!-- end: SPANEL CONFIGURATION MODAL FORM -->
				<div class="container">
					<!-- start: PAGE HEADER -->
					<div class="row">
						<div class="col-sm-12">
							<!-- start: PAGE TITLE & BREADCRUMB -->
							<ol class="breadcrumb">
								<li>
									<a href="<?php echo base_url('dashboard'); ?>">
										 Dashboard 
									</a>
								</li>
                                <li>
									<a href="#">
										 Reports 
									</a>
								</li>
                                                                
								<li class="active">
									Product Enquiry Report
							  </li>
								<li class="search-box">
									<form class="sidebar-search">
										<div class="form-group">
											<input type="text" placeholder="Start Searching...">
											<button class="submit">

												<i class="clip-search-3"></i>
											</button>
										</div>
									</form>
								</li>
							</ol>
							<div class="page-header">
								<h1>Product Enquiry Report</h1>
							</div>

                            <p>Please use the table below to navigate or filter the results. </p>
						</div>
					</div>
					<!-- end: PAGE HEADER -->
					<!-- start: PAGE CONTENT 
                    <!-- start grid -->
                    
 <!--start emi no search-->       
 <div class="row">
						<div class="col-sm-12">
							<div class="panel panel-default">
								<div class="panel-heading">
									<i class="fa fa-bar-chart-o"></i>
									Product Enquiry Report with Serial No.
								</div>
													<div class="panel-body">
                                                        <div class="col-sm-4">
                                                      	<div class="form-group">
															<label>Serail No. </label>
                                                         <input id="serail_no" name="serail_no" type='text' class="form-control " value="" data-bv-field=""  onChange="searchDetails()"  onClick="this.select()"/> 
                                                         </div>
														</div>
                                                        
                                                    
                                                    <div class="col-sm-4 pull-right">
                                                      	<div class="form-group">
															<label for="s2id_autogen1">&nbsp;<br><br>
</label> <input type="submit" name="add_category" value="Search" class="btn btn-primary" onClick="searchDetails()">          
														</div>
													</div>	
                                                    
								
                              
                           <!-- table start--> 
                            <div class="col-sm-12">
                            <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="products_table">
									  <thead>
							              <tr>
                                    <th class="col-sm-1">#</th>
                                    <th style="text-align:left;" class="col-sm-6">Product Name</th>
                                     <th class="col-sm-2">Serial No.</th>
                                      <th class="">Type</th>
                                       <th class="col-sm-1">Reference No</th>
                                    </tr>
							          </thead>
							          <tfoot>
										 <tr>
                                    <th>&nbsp;</th>
                                    <th>&nbsp;</th>
                                    <th>&nbsp;</th>
                                      <th>&nbsp;</th>
                                       <th>&nbsp;</th>
                                    </tr>
								           
						          </table>
                            </div>  
                             <!-- end start-->
                                		
                            </div>
                            
                            
                            
                            
							</div>
                            
                            
						</div>
					</div>
 
 <!--end emi no search-->     
 
 
 
 
 
 
 
 
  <!--start with out emi no search-->       
 <div class="row">
						<div class="col-sm-12">
							<div class="panel panel-default">
								<div class="panel-heading">
									<i class="fa fa-bar-chart-o"></i>
									Product Enquiry Report with Out Serial No.
								</div>
													<div class="panel-body">
                                                    
                                                    <div class="col-sm-4">
                                                      	<div class="form-group">
															<label>Product Code/Product Name </label>
                                                         <input id="product_code" name="product_code" type='text' class="form-control " value="" data-bv-field=""/> 
                                                      </div>
													  </div>
                                                        
                                                      <div class="col-sm-4">
                                                      	<div class="form-group">
															<label>Warehouse </label>
                                                       <select id="srh_warehouse_id" class="form-control" 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 }?>
																		
																	</select>                                          
														</div>
														</div>
                                                        
                                                    
                                                    <div class="col-sm-4 pull-right">
                                                      	<div class="form-group">
															<label for="s2id_autogen1">&nbsp;<br><br>
</label> <input type="submit" name="add_category" value="Search" class="btn btn-primary" onClick="searchDetailsByProductCode()">          
														</div>
													</div>	
                                                    
								
                              
                           <!-- table start--> 
                            <div class="col-sm-12">
                            <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="products_table_with_product_code">
									  <thead>
							              <tr>
                                    <th class="col-sm-1">Product Code</th>
                                    <th style="text-align:left;" class="col-sm-2">Product Name</th>
                                     <th class="col-sm-1">Type</th>
                                       <th class="col-sm-1">Reference No</th>
                                       <th class="col-sm-2">Date</th>
                                        </tr>
							          </thead>
							          <tfoot>
										 <tr>
                                    <th>&nbsp;</th>
                                    <th>&nbsp;</th>
                                    <th>&nbsp;</th>
                                       <th>&nbsp;</th>
                                       <th>&nbsp;</th>
                                        </tr>
								           
						          </table>
                            </div>  
                             <!-- end start-->
                                		
                            </div>
                            
                            
                            
                            
							</div>
                            
                            
						</div>
					</div>
 
 <!--end with out emi no search-->        
                    
                    
                

                    <!-- end grid -->
                    
                    
					
			</div>
			<!-- end: PAGE -->
		</div>
		<!-- end: MAIN CONTAINER -->
		<!-- start: FOOTER -->
		<div class="footer clearfix">
			<div class="footer-inner">
				<?php $this->load->view("common/site_by"); ?>
			</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"); ?>
        <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 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 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>

function fbs_click(id) {
	u=location.href;
	t=document.title;
	window.open('<?php echo base_url();?>transfer/trnsfr_details?trnsfr_id='+id,'sharer','toolbar=0,status=0,width=626,height=700, left=10, top=10,scrollbars=yes');return false;
	

}
		
		function searchDetailsReset(){
			$('#srh_to_date').val('');
			$('#srh_from_date').val('');
		}
		function searchDetails(){
					
					loadGrid();
		}
				

		function searchDetailsByProductCode(){
			//alert();
			loadGridProductCode();
		}				
			jQuery(document).ready(function() {
				FormElements.init();
					$("#srh_customer_id").select2();
					
					$("#serail_no").focus();

			});


			function loadGrid() {
			var srh_warehouse_id=2;
				var cat_srh=$('#cat_srh').val();
				var srh_from_date=$('#srh_from_date').val();
				var serail_no=$('#serail_no').val();
				//buttons: ['copy', 'csv', 'excel', 'pdf','print'],

					    $('#products_table').DataTable({
							dom: 'Bfrtip',
							buttons: [
       { extend: 'print', text: 'Print',footer: true},
        { extend: 'excel', text: 'Save as Excel',footer: true},
		 { extend: 'pdf', text: 'Save as Pdf',footer: true},
		
    ],
					        "ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports/get_list_product_for_product_enquiry_report');?>',
							'data': {
							   srh_warehouse_id: srh_warehouse_id,
							   cat_srh: cat_srh,
							   srh_from_date: srh_from_date,
							   serail_no: serail_no,
							}
							},
					        "bDestroy": true,
					        "iDisplayLength": 20,
							"order": [[ 0, "asc" ]], "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;
				var ser_cost_tot=0
				var ser_price_tot=0
				//alert(aaData.length);
                for (var i = 0; i < aaData.length; i++) {
					//alert(aaData[[i]][5]);
                   // p = (aaData[aiDisplay[i]][2]).split('__');
					ser_tot += parseFloat(aaData[[i]][11]);
					ser_price_tot += parseFloat(aaData[[i]][9]);
					ser_cost_tot += parseFloat(aaData[[i]][10]);
                }
                var nCells = nRow.getElementsByTagName('th');
				//nCells[11].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot, "", 2, ",", ".")+' </div>';
				//nCells[9].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_price_tot, "", 2, ",", ".")+' </div>';
				//nCells[10].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_cost_tot, "", 2, ",", ".")+' </div>';
              
            }
					    
					    });
					    
					    
					    setTimeout(
  function() 
  {
    //do something special
     $("#serail_no").val('');
  }, 5000);
  
					    //

					}
					


			function loadGridProductCode() {
				//alert(1);
			var srh_warehouse_id=$('#srh_warehouse_id').val();
				var cat_srh=$('#cat_srh').val();
				var srh_from_date=$('#srh_from_date').val();
				var product_code=$('#product_code').val();
				//buttons: ['copy', 'csv', 'excel', 'pdf','print'],

					    $('#products_table_with_product_code').DataTable({
							dom: 'Bfrtip',
							buttons: [
       { extend: 'print', text: 'Print',footer: true},
        { extend: 'excel', text: 'Save as Excel',footer: true},
		 { extend: 'pdf', text: 'Save as Pdf',footer: true},
		
    ],
					        "ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports/get_list_product_by_product_code_for_product_enquiry_report');?>',
							'data': {
							   srh_warehouse_id: srh_warehouse_id,
							   cat_srh: cat_srh,
							   srh_from_date: srh_from_date,
							   product_code: product_code,
							}
							},
					        "bDestroy": true,
					        "iDisplayLength": 20,
							"order": [[ 1, "asc" ]], "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;
				var ser_cost_tot=0
				var ser_price_tot=0
				//alert(aaData.length);
                for (var i = 0; i < aaData.length; i++) {
					//alert(aaData[[i]][5]);
                   // p = (aaData[aiDisplay[i]][2]).split('__');
					ser_tot += parseFloat(aaData[[i]][11]);
					ser_price_tot += parseFloat(aaData[[i]][9]);
					ser_cost_tot += parseFloat(aaData[[i]][10]);
                }
                var nCells = nRow.getElementsByTagName('th');
				//nCells[11].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot, "", 2, ",", ".")+' </div>';
				//nCells[9].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_price_tot, "", 2, ",", ".")+' </div>';
				//nCells[10].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_cost_tot, "", 2, ",", ".")+' </div>';
              
            }
					    
					    });
					    
					   // alert();
					   

					}
					


</script>

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