	<?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;
			}
			
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;
}
		</style>
		<!-- end: CSS REQUIRED FOR THIS PAGE ONLY -->
	<!-- end: HEAD -->
	<!-- start: BODY -->
	<body onLoad="colapseMe()">
		<!-- 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">
									 Cash 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>Cash 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 -->
                    <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>
									User Payments
                                    <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" style="display:none">
                                                      	<div class="form-group">
<?php
$ss_group_id=$this->session->userdata('ss_group_id');

$disable = 'disabled';
$collapse    = 'collapse';
//if($ss_group_id ==1)
{
	$disable  ='';
	$collapse ='';
	}
	
?>  
<input type="hidden" id="user_group" name="user_group" value=" <?php echo $ss_group_id ?>" >                                                      
															<label>User </label>
                                                       <select id="srh_user_id" class="form-control" name="srh_user_id" 
<?php //echo $disable ?>
>
                                                               <option value="">
																		-Select-
                                                         </option> 
													     <?php 
																 $ss_user_id=$this->session->userdata('ss_user_id'); 
                                                              foreach ($user_list as $row)
                                                              {
																  $sel='';
																  if($ss_user_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>Type </label>
<select id="srh_type" class="form-control" name="srh_type">
<option value="">-- Select --</option>
<option value="sale">
Sales
</option>
<option value="sales_return">
Sales Return
</option>		
</select>  
</div>
</div>

<div class="col-sm-4">
<div class="form-group">
<label>Payment Term </label>
<select id="srh_payment_term" class="form-control" name="srh_payment_term">
<option value="">-- Select --</option>
<option value="Cash">
Cash
</option>
<option value="Cheque">
Cheque
</option>	
<option value="Return Payment">
Return Payment
</option>	
<option value="Credit Card">
Credit Card
</option>
</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" 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"/>  
                                                           <?php //echo date('m/d/Y', strtotime('-1 day', strtotime(date('m/d/Y')))); ?>
                                    
                                                                    
														</div>
														</div>
                                                        
                                                       <div class="col-sm-4">
                                                      	<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" value="" data-bv-field="date"/>        -->
                                                             
                                                             <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>
                                                    <?php
													 $ss_warehouse_id=$this->session->userdata('ss_warehouse_id'); 
													  $ss_group_id=$this->session->userdata('ss_group_id'); 
													  
													  
													  
													  
													  
													?>
                                                     <div class="col-sm-4" <?php if ($ss_group_id==1 || $ss_group_id==9) echo ""; else echo " style=\"display:none;\""; ?>>
                                                      	<div class="form-group">
															
                                                            <?php
				$ss_group_id=$this->session->userdata('ss_group_id');
				//echo $ss_group_id;
				// if ($ss_group_id==1) 
				 {?>
                 <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 }?>
                                                              
                                                              <option value="">-All-</option>
																		
														  </select>  
                                                                 
                                                                    <?php } 
																	//else {
					
					?>
               <!-- <input name="srh_warehouse_id" type="text" value="<?php echo $this->session->userdata('ss_warehouse_id');?>">-->
                <?php //}?>                                     
														</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()"> &nbsp;&nbsp;
                                                             
                                                             <input type="submit" name="add_category" value="Reset" class="btn btn-danger" onClick="searchDetailsReset()">&nbsp;&nbsp;
                                                             
                                                           <!--  <input onClick="print_booking_report();" type="submit" name="add_category" value="Print" class="btn btn-success">-->
                                                             
														</div>
													</div>
                                                   
                                                    
												</div>
											</div>  
                                

 <button class="btn btn-blue dropdown-toggle" data-toggle="dropdown" id="excel">
<i class="fa fa-fw" aria-hidden="true" title="Copy to use file-excel-o"></i>
</button> 
 
 <button onClick="printDiv('printableArea')" class="btn btn-blue dropdown-toggle" data-toggle="dropdown">
<i class="fa fa-print"></i>
</button>

<!-- <input type="button" class="pull-right" value="Print Cash Report" onClick="printDiv('printableArea')">-->
 <br><br>
 <div id="ExcelArea">
 <div id="printableArea">
            <div class="page-header">
                <h1>Cash Report</h1>
                <button style="display:none" value="hello" data-toggle="collapse" data-onstyle="success" data-size="small" data-target="#not_for_sales_staff" />
            </div>  
                                  
            <table id="" class="table table-bordered table-condensed table-hover table-striped dataTable">
                <tbody>
                    <tr>
                    <td></td>
                    <td class="text-right">From Date:  <span id="f-date-txt"></span>, To Date: <span id="t-date-txt"></span></td>
                    </tr>
                    <tr>
                      <th>	Opening Balance</th>
                      <td><div id="opening_balance_summ_tbl">0.00</div>
                      <input name="opening_balance_val" type="hidden" id="opening_balance_val" value="0"></td>
                    </tr>
                    <tr>
                      <th>Today Sales Collection</th>
                      <td><div id="today_sales_collection">0.00</div>
                    </tr>
                    <tr>
                      <th>Credit Collection</th>
                      <td><div id="credit_collection">0.00</div>
                    </tr>
                    <tr>
                      <th>	Bank Deposit</th>
                      <td><div id="bank_deposit_summ_tbl">0.00</div>
                      <input name="bank_deposit_val" type="hidden" id="bank_deposit_val" value="0"></td>
                    </tr>
                    <tr>
                      <th>	Cash Transfer</th>
                      <td><div id="cash_transfer_summ_tbl">0.00</div>
                      <input name="cash_transfer_val" type="hidden" id="cash_transfer_val" value="0"></td>
                    </tr>
                     <th>	Cash Transfer Reserved</th>
                      <td><div id="cash_transfer_res_summ_tbl">0.00</div>
                      <input name="cash_transfer_res_val" type="hidden" id="cash_transfer_res_val" value="0"></td>
                    </tr>
                    <tr>
                    <th width="50%">Sales Total Reseved Amount</th>
                    <td width="50%"><div id="sales_summ_tbl">0.00</div></td>
                    </tr>
                    <tr class="">
                      <th>Cash</th>
                      <td><div id="cash_summ_tbl">0.00</div></td>
                    </tr>
                    <tr class="">
                      <th>Credit Card</th>
                      <td><div id="credit_card_summ_tbl">0.00</div></td>
                    </tr>
                    <tr class="">
                      <th>Cheque</th>
                      <td><div id="cheque_summ_tbl">0.00</div></td>
                    </tr>
                     <tr class="">
                      <th>Credit Card Interest</th>
                      <td><div id="credit_card_int_summ_tbl">0.00</div></td>
                    </tr>
                    <tr class="">
                    <th width="50%">Sales Return</th>
                    <td width="50%"><div id="sales_return_tbl">0.00</div></td>
                    </tr>
                    <tr class="" style="display:none">
                    <th width="50%">GRN</th>
                    <td width="50%"><div id="sales_grn_tbl">0.00</div></td>
                    </tr>
                    <tr class="" style="display:none">
                    <th width="50%">GRN Return</th>
                    <td width="50%"><div id="sales_return_grn_tbl">0.00</div></td>
                    </tr>
                    <tr>
                    <th>Expenses</th>
                    <td><div id="exp_summ_tbl">0.00</div></td>
                    </tr>
                    <!-- <tr>
                    <th>Sales Return </th>
                    <td><div id="sales-rtn-cost-tbl">0.00</div></td>
                    </tr>-->
                    <tr>
                      <th>Service</th>
                      <td><div id="ser_summ_tbl">0.00</div></td>
                    </tr>
                    <tr>
                    <th>Cash in Hand</th>
                    <td><div id="cash_in_hand_tbl_2">0.00</div></td>
                    </tr>
                </tbody>
            </table>
</div>

<br>
<br>


                               
                                
                                
                                <div class="panel-heading">
<i class="fa fa-external-link-square"></i>
Sales List
</div>
<div>&nbsp;</div>
								  <table width="100%" class="table table-bordered table-condensed table-hover table-striped dataTable" id="warehouse_table">
									  <thead>
							              <tr>
							               
                                             <th>Ref. No.</th>
                                             <th>Payment Date</th>
											  <th>Invoice No</th>
                                              <th>Customer</th>
											 
											  <th class="text-right" style="text-align:right !important;">Type</th>
											  <th class="text-right" style="text-align:right !important;">Payment Term</th>
                                                <th class="text-right" style="text-align:right !important;">Paid Amount</th>
                                                <th class="text-right" style="text-align:right !important;">Credit Card Interest (3%)</th>
                                                <th class="text-right" style="text-align:right !important;">Total Paid</th>
                                                <th class="text-right" style="text-align:right !important;">Returned Status</th>
                                              
							              </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>&nbsp;</th>
                                                <th>&nbsp;</th>
                                                <th>&nbsp;</th>
							            </tr>
								      </tfoot>     
						          </table>
                                  <div>&nbsp;</div>
          </div>                        
                                  
                                  
                                  <br>
<br>
<div class="<?php echo $collapse; ?>" id="not_for_sales_staff" >
<div class="panel-heading">
<i class="fa fa-external-link-square"></i>
Sales Return List
</div>
<div>&nbsp;</div>
								  <table width="100%" class="table table-bordered table-condensed table-hover table-striped dataTable" id="warehouse_table_rtn">
									  <thead>
							              <tr>
                                            <th>Ref. No.</th>
                                            <th>Payment Date</th>
                                            <th>Return Invoice No</th>										  <th>Customer</th>
                                            
                                            <th class="text-right" style="text-align:right !important;">Type</th>
                                            <th class="text-right" style="text-align:right !important;">Payment Term</th>
                                            <th class="text-right" style="text-align:right !important;">Paid Amount</th>
                                        </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>
							              </tr>
								           
						          </table>
                                  
   <div>&nbsp;</div>                               
 <br>
<br>

<div class="panel-heading">
<i class="fa fa-external-link-square"></i>
GRN List
</div>
<div>&nbsp;</div>
								  <table width="100%" class="table table-bordered table-condensed table-hover table-striped dataTable" id="warehouse_table_grn">
                                  
                                  
									  <thead>
							              <tr>
							               
                                             <th>Ref. No.</th>
                                             <th>Payment Date</th>
											  <th>GRN Invoice No</th>
											  <th class="text-right" style="text-align:right !important;">Supplier Name</th>
											 
											  <th class="text-right" style="text-align:right !important;">Type</th>
											  <th class="text-right" style="text-align:right !important;">Payment Term</th>
                                                <th class="text-right" style="text-align:right !important;">Paid Amount</th>
                                              
							              </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>
							              </tr>
								           
						          </table>   
<div>&nbsp;</div>                                  
 <br>
<br>


								  
                                   
  </div>                                 
                                  
                                  <br>
<br>
  <div class="panel-heading">
<i class="fa fa-external-link-square"></i>
Expenses
</div>
<div>&nbsp;</div>						
                        		  <table width="100%" class="table table-bordered table-condensed table-hover table-striped dataTable" id="expenses_table">
									  <thead>
							              <tr>
							                <th>#</th>
							               
                                             <th>Ref. No.</th>
                                             <th>Date</th>
											  <th>Expenses Type</th>
											 
											 
											  <th>Rate</th>
											  <th class="text-right" style="text-align:right !important;">Qty</th>
											  <th class="text-right" style="text-align:right !important;">Discount</th>
                                                <th class="text-right" style="text-align:right !important;">Sub Total</th>
                                              
							              </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>&nbsp;</th>
							              </tr>
								           
						          </table>
                                  
                              <div>&nbsp;</div>
                               <div>&nbsp;</div>     
                                  <div>&nbsp;</div>
                                <div class="panel-heading">
<i class="fa fa-external-link-square"></i>
Service
</div>
<div>&nbsp;</div>                                  
                                  <table width="100%" class="table table-bordered table-condensed table-hover table-striped dataTable" id="service_table">
									  <thead>
							              <tr>
							                <th>#</th>
							               
                                             <th>Ref. No.</th>
                                             <th>Payment Date</th>
											  <th>Service Ref. No.</th>
											  <th class="text-right" style="text-align:right !important;">Customer</th>
											 
											  <th class="text-right" style="text-align:right !important;">Payment Term</th>
											  <th class="text-right" style="text-align:right !important;">Amount</th>
											  <th class="text-right" style="text-align:right !important;">Returned Status</th>
                                              
							              </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>&nbsp;</th>
						                  </tr>
								           
						          </table>
                                  
                            <div>&nbsp;</div>      
 
                                
 
								</div>
           
							</div>
                            

							<!-- end: DYNAMIC TABLE PANEL -->
						</div>
					</div>

                    <!-- end grid -->
                    
                    
          <input name="" id="credit_card_summ_fld" type="hidden">
          <input name="" id="cheque_summ_fld" type="hidden">
          <input name="" id="credit_card_int_summ_tbl" type="hidden">
           <input name="" id="sales_summ_fld" type="hidden">
           <input name="" id="sales_rtn_summ_fld" type="hidden">
          
          <input name="" id="grn_summ_fld" type="hidden">    
          <input name="" id="grn_return_summ_fld" type="hidden">    
           <input name="" id="exp_summ_fld" type="hidden">
            <input name="" id="ser_summ_fld" type="hidden">
                
					
			</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"); ?>
        <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="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" language="javascript" src="https://cdn.datatables.net/buttons/1.2.3/js/dataTables.buttons.min.js">
	</script>
	<script type="text/javascript" language="javascript" src="//cdn.datatables.net/buttons/1.2.3/js/buttons.print.min.js">
	</script>
	<script type="text/javascript" language="javascript" src="//cdn.datatables.net/buttons/1.2.3/js/buttons.flash.min.js">
	</script>
	<script type="text/javascript" language="javascript" src="//cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js">
	</script>
	<script type="text/javascript" language="javascript" src="//cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/pdfmake.min.js">
	</script>
	<script type="text/javascript" language="javascript" src="//cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/vfs_fonts.js">
	</script>
	<script type="text/javascript" language="javascript" src="//cdn.datatables.net/buttons/1.2.3/js/buttons.html5.min.js">
	</script>
	<script type="text/javascript" language="javascript" src="//cdn.datatables.net/buttons/1.2.3/js/buttons.print.min.js"></script>
               
        <script>
		function opening_balance_get(){
			var srh_from_date=$('#srh_from_date').val();
			var srh_to_date=$('#srh_to_date').val();
			var srh_warehouse_id=$('#srh_warehouse_id').val();
		//	$.post( "<?php echo base_url();?>reports/opening_balance_get")
			$.ajax({
							'type': 'POST',
							'url': '<?php echo base_url('reports/opening_balance_get');?>',
							'data': {
							   srh_from_date: srh_from_date,
							   srh_to_date: srh_to_date,
							   srh_warehouse_id: srh_warehouse_id,
							 
							},
							success: function(response)
       {
			var obj = jQuery.parseJSON(response);
			//alert(obj.opening_balance_summ);
			$('#opening_balance_summ_tbl').html(accounting.formatMoney(obj.opening_balance_summ, "", 2, ",", "."));
			$('#opening_balance_val').val(obj.opening_balance_summ);
    	}
						});
			
		}
		
		//(accounting.formatMoney(credit_card_summ, "", 2, ",", "."));
		
		function bank_deposit_get(){
			var srh_from_date=$('#srh_from_date').val();
			var srh_to_date=$('#srh_to_date').val();
			var srh_warehouse_id=$('#srh_warehouse_id').val();
		//	$.post( "<?php echo base_url();?>reports/bank_deposit_get")
			$.ajax({
							'type': 'POST',
							'url': '<?php echo base_url('reports/bank_deposit_get');?>',
							'data': {
							   srh_from_date: srh_from_date,
							   srh_to_date: srh_to_date,
							   srh_warehouse_id: srh_warehouse_id,
							 
							},
							success: function(response)
       {
			var obj = jQuery.parseJSON(response);
			//alert(obj.bank_deposit_summ);
			$('#bank_deposit_summ_tbl').html(accounting.formatMoney(obj.bank_deposit_summ, "", 2, ",", "."));
			$('#bank_deposit_val').val(obj.bank_deposit_summ);
    	}
						});
			
		}
		
		function cash_transfer_get(){
		   // alert(1);
			var srh_from_date=$('#srh_from_date').val();
			var srh_to_date=$('#srh_to_date').val();
			var srh_warehouse_id=$('#srh_warehouse_id').val();
			$.ajax({
							'type': 'POST',
							'url': '<?php echo base_url('reports/cash_transfer_get');?>',
							'data': {
							   srh_from_date: srh_from_date,
							   srh_to_date: srh_to_date,
							   srh_warehouse_id: srh_warehouse_id,
							 
							},
							success: function(response)
       {
			var obj = jQuery.parseJSON(response);
			//alert(obj.bank_deposit_summ);
			$('#cash_transfer_summ_tbl').html(accounting.formatMoney(obj.cash_transfer_summ, "", 2, ",", "."));
			$('#cash_transfer_val').val(obj.cash_transfer_summ);
    	}
						});
			
		}
		
		function cash_transfer_res_get(){
		   // alert(1);
			var srh_from_date=$('#srh_from_date').val();
			var srh_to_date=$('#srh_to_date').val();
			var srh_warehouse_id=$('#srh_warehouse_id').val();
			$.ajax({
							'type': 'POST',
							'url': '<?php echo base_url('reports/cash_transfer_res_get');?>',
							'data': {
							   srh_from_date: srh_from_date,
							   srh_to_date: srh_to_date,
							   srh_warehouse_id: srh_warehouse_id,
							 
							},
							success: function(response)
       {
			var obj = jQuery.parseJSON(response);
			//alert(obj.bank_deposit_summ);
			$('#cash_transfer_res_summ_tbl').html(accounting.formatMoney(obj.cash_transfer_res_summ, "", 2, ",", "."));
			$('#cash_transfer_res_val').val(obj.cash_transfer_res_summ);
    	}
						});
			
		}
		
		function searchDetailsReset(){
			$('#srh_to_date').val('');
			$('#srh_from_date').val('');
		}
		function searchDetails(){
			
			opening_balance_get();
			bank_deposit_get();
				cash_transfer_get();
				cash_transfer_res_get();
				
					loadGrid();
					//loadexpenses();
		}
				
				

//fu//nction loadexpenses(){
	
//}

			function loadGrid() {
			var srh_from_date=$('#srh_from_date').val();
			var srh_to_date=$('#srh_to_date').val();
			
			$('#f-date-txt').text(srh_from_date);
			$('#t-date-txt').text(srh_to_date);
			var srh_warehouse_id=$('#srh_warehouse_id').val();
				var srh_type=$('#srh_type').val();
	var srh_payment_term=$('#srh_payment_term').val();
	var ss_user_id=$('#srh_user_id').val();
		//	alert(ss_user_id);
		
		var message="<div  style='text-align:center'>  <h4></h4><br/> <br/><h4>Cash Report / Invoice Payments</h4></div>";
							
					    $('#warehouse_table').DataTable({
							
dom: 'Blfrtip',
						buttons: [
       { extend: 'print', text: 'Print',footer: true, message: message,title: ''},
        { extend: 'excel', text: 'Save as Excel',footer: true, message: message},
    ],
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports/get_list_payments_for_report');?>',
							'data': {
							   srh_from_date: srh_from_date,
							   srh_to_date: srh_to_date,
							   srh_warehouse_id: srh_warehouse_id,
							   srh_type: srh_type,
							   srh_payment_term: srh_payment_term,
							   ss_user_id: ss_user_id,
							}
							},
					        "bDestroy": true,
					        "iDisplayLength": 20,
							"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 pay_type='';
				var credit_card_summ=0;
				var cheque_summ=0;
				var sales_return_tot=0;
				var sales_grn_tot=0;
				var cash_summ=0;
				var credit_card_int_summ=0;
				var credit_collection=0;
				var today_sales_collection=0;
				
				//var sales_rtn=0;
                for (var i = 0; i < aaData.length; i++) {
					//alert(aaData[[i]][5]);
                   // p = (aaData[aiDisplay[i]][2]).split('__');
                   
                   var text=aaData[[i]][2];
                   var result=text.split('-');
                   var sale_date=result[1];
                   var paymnet_date=aaData[[i]][1];
                   
                       if(aaData[[i]][4]=='sale'){
                           if(sale_date!=paymnet_date){
                            credit_collection=credit_collection+parseFloat(aaData[[i]][6]);
                           }else{
                               today_sales_collection=today_sales_collection+parseFloat(aaData[[i]][6]);
                           }
                       }
                   
                   
                   
                   
					ser_tot1 += parseFloat(aaData[[i]][4]);
					
					
					//pay_type=aaData[[i]][4];
					if(aaData[[i]][4]=='sale'){
						ser_tot2 += parseFloat(aaData[[i]][6]);
						
						//alert(aaData[[i]][5]);
						if(aaData[[i]][5]=='Credit Card' && aaData[[i]][9]==''){
							credit_card_summ += parseFloat(aaData[[i]][6]);
							
								credit_card_int_summ += parseFloat(aaData[[i]][7]);
								//alert(credit_card_int_summ);
						}
						
						if(aaData[[i]][5]=='Cheque' && aaData[[i]][9]==''){
							cheque_summ += parseFloat(aaData[[i]][6]);
							//credit_card_int_summ += parseFloat(aaData[[i]][7]);
						}
						
						if(aaData[[i]][5]=='Cash' && aaData[[i]][9]==''){
							cash_summ += parseFloat(aaData[[i]][6]);
						}
						//alert(aaData[[i]][4]);
						//alert(ser_tot2);
					}else {
						
						//ser_tot2 -= parseFloat(aaData[[i]][6]);
						if(aaData[[i]][4]=='grn' && aaData[[i]][9]==''){
							sales_grn_tot += parseFloat(aaData[[i]][6]);
						}
						
						if(aaData[[i]][4]=='sales_return' && aaData[[i]][9]==''){
							//alert(aaData[[i]][4]);
							sales_return_tot += parseFloat(aaData[[i]][6]);
							//alert(sales_return_tot);
							
							//add sales return amount
							//ser_tot2 += parseFloat(aaData[[i]][6]);
						}
					//	if(aaData[[i]][4]=='sales'){
							//alert(aaData[[i]][4]);
						
							//alert(sales_return_tot);
						//}
					}
					//ser_tot3 += parseFloat(aaData[[i]][5]);	
                }
                var nCells = nRow.getElementsByTagName('th');
			//	nCells[3].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';
				
				
				//nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2-sales_grn_tot-sales_return_tot, "", 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;
				//alert(ser_tot2);
				$('#sales_summ_tbl').text(accounting.formatMoney(ser_tot2, "", 2, ",", "."));
				
				$('#credit_card_summ_tbl').text(accounting.formatMoney(credit_card_summ, "", 2, ",", "."));
				$('#credit_card_summ_fld').val(credit_card_summ);
				
				$('#cheque_summ_tbl').text(accounting.formatMoney(cheque_summ, "", 2, ",", "."));
				$('#cheque_summ_fld').val(cheque_summ);
				
				
				$('#credit_card_int_summ_tbl').text(accounting.formatMoney(credit_card_int_summ, "", 2, ",", "."));
				$('#credit_card_int_summ_fld').val(credit_card_int_summ);
				
				
				$('#cash_summ_tbl').text(accounting.formatMoney(cash_summ, "", 2, ",", "."));
				
					$('#credit_collection').text(accounting.formatMoney(credit_collection, "", 2, ",", "."));
						$('#today_sales_collection').text(accounting.formatMoney(today_sales_collection, "", 2, ",", "."));
				
				
				//$('#credit_card_summ_fld').val(credit_card_summ);
				
				
			//	$('#sales_grn_tbl').text(accounting.formatMoney(sales_grn_tot, "", 2, ",", "."));
			//	$('#sales_return_tbl').text(accounting.formatMoney(sales_return_tot, "", 2, ",", "."));
				$('#sales_summ_fld').val(ser_tot2-sales_grn_tot-sales_return_tot);
			//	$('#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, ",", "."));
				
				
				
				calculate_cah_in_hand();
              
            }
					    });
						
						
						
	var message="<div  style='text-align:center'>  <h4>RS MARKETING</h4>#258, 317 A ,HIGHLEVEL ROAD,WATARAKA,PADUKKA, Phone: 0112 184 316 <br/> Email: newhirursmarketing@gmail.com<br/><h4>Cash Report / Invoice Return Payments</h4></div>";


					
		/* return start */
		 $('#warehouse_table_rtn').DataTable({
							
dom: 'Blfrtip',
						buttons: [
       { extend: 'print', text: 'Print',footer: true, message: message,title: ''},
        { extend: 'excel', text: 'Save as Excel',footer: true, message: message},
    ],
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports/get_list_payments_for_report_rtn');?>',
							'data': {
							   srh_from_date: srh_from_date,
							   srh_to_date: srh_to_date,
							   srh_warehouse_id: srh_warehouse_id,
							   srh_type: srh_type,
							   srh_payment_term: srh_payment_term,
							   ss_user_id: ss_user_id,
							}
							},
					        "bDestroy": true,
					        "iDisplayLength": 20,
							"order": [[ 1, "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 pay_type='';
				var sales_return_tot=0;
				var sales_grn_tot=0;
				//var sales_rtn=0;
                for (var i = 0; i < aaData.length; i++) {


					//alert(aaData[[i]][5]);
                   // p = (aaData[aiDisplay[i]][2]).split('__');
					ser_tot1 += parseFloat(aaData[[i]][4]);
					//pay_type=aaData[[i]][4];
					if(aaData[[i]][4]=='sale'){
						ser_tot2 += parseFloat(aaData[[i]][6]);
						//alert(aaData[[i]][4]);
						//alert(ser_tot2);
					}else {
						
						//ser_tot2 -= parseFloat(aaData[[i]][6]);
						if(aaData[[i]][4]=='grn'){
							sales_grn_tot += parseFloat(aaData[[i]][6]);
						}
						if(aaData[[i]][4]=='sales_return'){
							//alert(aaData[[i]][4]);
						//	sales_return_tot += parseFloat(aaData[[i]][5]);
							//alert(sales_return_tot);
						}
					}
					//ser_tot3 += parseFloat(aaData[[i]][5]);	

					sales_return_tot += parseFloat(aaData[[i]][6]);
                }
                var nCells = nRow.getElementsByTagName('th');
			//	nCells[3].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';
				
				
				//nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(sales_return_tot, "", 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;
				//alert(ser_tot2);
				//$('#sales_summ_tbl').text(accounting.formatMoney(ser_tot2, "", 2, ",", "."));
				//$('#sales_grn_tbl').text(accounting.formatMoney(sales_grn_tot, "", 2, ",", "."));
				$('#sales_return_tbl').text(accounting.formatMoney(sales_return_tot, "", 2, ",", "."));
				$('#sales_rtn_summ_fld').val(sales_return_tot);
				//$('#sales_summ_fld').val(ser_tot2-sales_grn_tot-sales_return_tot);
			//	$('#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, ",", "."));
				
				
			calculate_cah_in_hand();	
				
              
            }
					    });
		
		/* return end */
		
		
		
		
		
		
	/* service start */
		 $('#service_table').DataTable({
							
dom: 'Blfrtip',
						buttons: [
       { extend: 'print', text: 'Print',footer: true, message: message,title: ''},
        { extend: 'excel', text: 'Save as Excel',footer: true, message: message},
    ],
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports/get_list_payments_for_report_service');?>',
							'data': {
							   srh_from_date: srh_from_date,
							   srh_to_date: srh_to_date,
							   srh_warehouse_id: srh_warehouse_id,
							   srh_type: 'service',
							   srh_payment_term: srh_payment_term,
							   ss_user_id: ss_user_id,
							}
							},
					        "bDestroy": true,
					        "iDisplayLength": 20,
							"order": [[ 1, "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 pay_type='';
				var sales_return_tot=0;
				var sales_grn_tot=0;
				var service_amount=0;
				//var sales_rtn=0;
                for (var i = 0; i < aaData.length; i++) {
					
					if(aaData[[i]][7]==''){
					service_amount += parseFloat(aaData[[i]][6]);
					}

					//alert(service_amount);
                   // p = (aaData[aiDisplay[i]][2]).split('__');
				   
					ser_tot1 += parseFloat(aaData[[i]][4]);
					//pay_type=aaData[[i]][4];
					if(aaData[[i]][4]=='sale'){
						//ser_tot2 += parseFloat(aaData[[i]][6]);

					}else {
						
						//ser_tot2 -= parseFloat(aaData[[i]][6]);
						if(aaData[[i]][4]=='grn'){
							//sales_grn_tot += parseFloat(aaData[[i]][6]);
						}
						if(aaData[[i]][4]=='sales_return'){

						}
					}
					

					//sales_return_tot += parseFloat(aaData[[i]][6]);
                }
                var nCells = nRow.getElementsByTagName('th');
			
				
				nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(service_amount, "", 2, ",", ".")+' </div>';
			
				
				var sales_rtn_tot_cost=ser_tot1;
				var sales_rtn_tot_val=ser_tot2;

				$('#ser_summ_tbl').text(accounting.formatMoney(service_amount, "", 2, ",", "."));
				$('#ser_summ_fld').val(service_amount);
				
				
				
			calculate_cah_in_hand();	
				
              
            }
					    });
		
		/* service end */	
		
		
		
		
		
		
		
		
		
		
		

var message="<div  style='text-align:center'>  <h4>RS MARKETING</h4>#258, 317 A ,HIGHLEVEL ROAD,WATARAKA,PADUKKA, Phone: 0112 184 316 <br/> Email: newhirursmarketing@gmail.com<br/><h4>Cash Report / GRN Payments</h4></div>";
		
		
		/* grn start */
		 $('#warehouse_table_grn').DataTable({
			 
			 	dom: 'Blfrtip',
						buttons: [
       { extend: 'print', text: 'Print',footer: true, message: message,title: ''},
        { extend: 'excel', text: 'Save as Excel',footer: true, message: message},
    ],
							
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports/get_list_payments_for_report_grn');?>',
							'data': {
							   srh_from_date: srh_from_date,
							   srh_to_date: srh_to_date,
							   srh_warehouse_id: srh_warehouse_id,
							   srh_type: srh_type,
							   srh_payment_term: srh_payment_term,
							   ss_user_id: ss_user_id,
							}
							},
					        "bDestroy": true,
					        "iDisplayLength": 20,
							"order": [[ 1, "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 pay_type='';
				var sales_return_tot=0;
				var sales_grn_tot=0;
				var sale_paid_amount=0;
				//var sales_rtn=0;
                for (var i = 0; i < aaData.length; i++) {


					//alert(aaData[[i]][5]);
                   // p = (aaData[aiDisplay[i]][2]).split('__');
					ser_tot1 += parseFloat(aaData[[i]][3]);
					//pay_type=aaData[[i]][4];
					if(aaData[[i]][3]=='sale'){
						ser_tot2 += parseFloat(aaData[[i]][5]);
						sale_paid_amount += parseFloat(aaData[[i]][6]);
						//alert(aaData[[i]][4]);
						//alert(ser_tot2);
					}else {
						
						//ser_tot2 -= parseFloat(aaData[[i]][6]);
						if(aaData[[i]][4]=='grn'){
							sales_grn_tot += parseFloat(aaData[[i]][6]);
						}
						if(aaData[[i]][3]=='sales_return'){
							//alert(aaData[[i]][4]);
						//	sales_return_tot += parseFloat(aaData[[i]][5]);
							//alert(sales_return_tot);
						}
					}
					//ser_tot3 += parseFloat(aaData[[i]][5]);	

					sales_return_tot += parseFloat(aaData[[i]][6]);
                }
                var nCells = nRow.getElementsByTagName('th');
				
				
			//	nCells[3].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';
				
				
				//nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(sales_grn_tot, "", 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;
				//alert(ser_tot2);
				//$('#sales_summ_tbl').text(accounting.formatMoney(ser_tot2, "", 2, ",", "."));
				//$('#sales_grn_tbl').text(accounting.formatMoney(sales_grn_tot, "", 2, ",", "."));
				$('#sales_grn_tbl').text(accounting.formatMoney(sales_grn_tot, "", 2, ",", "."));
				$('#grn_summ_fld').val(sales_return_tot);
				//$('#sales_summ_fld').val(ser_tot2-sales_grn_tot-sales_return_tot);
			//	$('#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, ",", "."));
				
				
			calculate_cah_in_hand();	
				
              
            }
					    });
		
		/* grn end */	
				
						
						//loadexpenses
						//alert();
						
						var message="<div  style='text-align:center'>  <h4></h4><br/>  </h4></div>";
						
						 $('#expenses_table').DataTable({
							dom: 'Blfrtip',
						buttons: [
       { extend: 'print', text: 'Print',footer: true, message: message,title: ''},
        { extend: 'excel', text: 'Save as Excel',footer: true, message: message},
    ],
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports/get_list_expenses_for_report');?>',
							'data': {
							   srh_from_date: srh_from_date,
							   srh_to_date: srh_to_date,
							   srh_warehouse_id: srh_warehouse_id,
							    srh_type: srh_type,
								 srh_payment_term: srh_payment_term,
								 ss_user_id: ss_user_id,
							}
							},
					        "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;
				//alert(aaData.length);
				var ser_tot3=0;
				var ser_tot2=0;
				var ser_tot1=0;
				var ser_tot4=0;
				var pay_type='';
				//var sales_rtn=0;
                for (var i = 0; i < aaData.length; i++) {
					//alert(aaData[[i]][5]);
                   // p = (aaData[aiDisplay[i]][2]).split('__');
					ser_tot1 += parseFloat(aaData[[i]][3]);
					//pay_type=aaData[[i]][4];
					//if(aaData[[i]][4]=='sale'){
					ser_tot2 += parseFloat(aaData[[i]][7]);
					//}else {
						//ser_tot2 -= parseFloat(aaData[[i]][6]);
					//}
					//ser_tot3 += parseFloat(aaData[[i]][5]);	
                }
                var nCells = nRow.getElementsByTagName('th');
			//	nCells[3].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';
				
				
				//nCells[7].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;
				
				
				$('#exp_summ_tbl').text(accounting.formatMoney(ser_tot2, "", 2, ",", "."));
				$('#exp_summ_fld').val(ser_tot2);
			//	$('#sales_summ_fld').val(sales_summ_fld);
				//$('#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, ",", "."));
				
				var cash_in_hand=0;
				cash_in_hand=$('#sales_summ_fld').val()-ser_tot2;
				
				//alert();
				
				$('#cash_in_hand_tbl').text(accounting.formatMoney(cash_in_hand, "", 2, ",", "."));
				
			calculate_cah_in_hand();	
              
            }
			
			
			
			
					    }); 

					}
					
					
					
			
					
					
					
					
					
					
					
					
					function calculate_cah_in_hand(){
					
					var sales_summ_fld=parseFloat($('#sales_summ_fld').val());
					var sales_rtn_summ_fld=parseFloat($('#sales_rtn_summ_fld').val());
					var exp_summ_fld=parseFloat($('#exp_summ_fld').val());
					var grn_summ_fld=parseFloat($('#grn_summ_fld').val());
					var grn_return_summ_fld=0;//parseFloat($('#grn_return_summ_fld').val());
					var ser_summ_fld=parseFloat($('#ser_summ_fld').val());
					var credit_card_summ_fld=parseFloat($('#credit_card_summ_fld').val());
					var cheque_summ_fld=parseFloat($('#cheque_summ_fld').val());
					var opening_balance_val=parseFloat($('#opening_balance_val').val());
					var bank_deposit_val=parseFloat($('#bank_deposit_val').val());
					var cash_transfer_val=parseFloat($('#cash_transfer_val').val());
					var cash_transfer_res_val=parseFloat($('#cash_transfer_res_val').val());
					var cash_in_hand_tbl=0;
					/*
					alert('sales_summ_fld:'+sales_summ_fld+','+
					'ser_summ_fld:'+ser_summ_fld+','+
					'sales_rtn_summ_fld:'+sales_rtn_summ_fld+','+
					'exp_summ_fld:'+exp_summ_fld+','+
					'grn_summ_fld:'+grn_summ_fld
					);*/
					grn_summ_fld=0;
					cash_in_hand_tbl=sales_summ_fld-cash_transfer_val+cash_transfer_res_val+ser_summ_fld-sales_rtn_summ_fld-exp_summ_fld-grn_summ_fld-credit_card_summ_fld-cheque_summ_fld+opening_balance_val-bank_deposit_val;
					
					//alert(cash_in_hand_tbl);
					$('#cash_in_hand_tbl_2').text(accounting.formatMoney(cash_in_hand_tbl, "", 2, ",", "."));
				}
					

			jQuery(document).ready(function() {
				
				//calculate_cah_in_hand();
				
				
				//TableData.init();
				var tomorrow = new Date();
				currentDate=tomorrow.setDate(tomorrow.getDate() - 30);
				
				
				/*$('#srh_to_date').datetimepicker({
					//defaultDate: new Date()
				});*/
				
				
				//loadGrid();
			});
			

function print_booking_report(url) {
	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_type=$('#srh_type').val();
	var srh_payment_term=$('#srh_payment_term').val();
	var ss_user_id=$('#ss_user_id').val();
	u=location.href;
	t=document.title;
	url='<?php echo base_url();?>'+'reports/print_booking_report?srh_warehouse_id='+srh_warehouse_id+'&srh_from_date='+srh_from_date+'&srh_to_date='+srh_to_date+'&srh_type='+srh_type+'&srh_payment_term='+srh_payment_term+'&ss_user_id='+ss_user_id;
	window.open(url,'sharer','toolbar=0,status=0,width=750,height=436, left=10, top=10,scrollbars=yes');return false;
}
</script>

   <script>
   function changeColectedStatus(id,sta){
	   var fld_id='collected_'+id;
	  // alert(sta);
	  paymnt_id=id;
	  if(sta){
		  pymnt_collected=1;
	  }else {
		  pymnt_collected=0;
	  }

			$.post( "<?php echo base_url();?>booking/change_collected_status", {paymnt_id:paymnt_id, pymnt_collected:pymnt_collected})
	  .done(function( data ) {
		
	  	var obj = jQuery.parseJSON(data);
		 if (obj.status==0) 
		{
		
		}
		});
		
			  
	  
	   if(sta){
		   displayNotice('Payment','Advance Payment Collected');
    	 // Code in the case checkbox is checked.
		} else {
			displayNotice('Payment','Deleted Advance payment collect status');
		  // alert('no');
     		// Code in the case checkbox is NOT checked.
		
		}
	   return false;
	   
   }
jQuery(document).ready(function() {

				FormElements.init();

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

     document.body.innerHTML = printContents;

     window.print();

     document.body.innerHTML = originalContents;
}


</script>   

<!--<script type="text/javascript" src="http://code.jquery.com/jquery-1.9.0.js">            </script>-->
<script type="text/javascript">
$(function(){
    $('#excel').click(function(){
        var url='data:application/vnd.ms-excel,' + encodeURIComponent($('#ExcelArea').html()) 
        location.href=url
        return false
    })
})

function colapseMe(){
	
	//alert('test');
	}
</script>

 <div id="log"> </div>   
	</body>
	<!-- end: BODY -->
</html>