<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
	<meta http-equiv="Content-type" content="application/vnd.ms-excel; charset=UTF-8">
</head>
<body>
<div class="row">
	<div class="col-md-12">
		<div class="margin-top-20">
			<div class="card">
				<table class="table table-striped" border="0">
					<thead>
						<tr>
							<th colspan="9"> <%= t("views.right_panel.detail.from_date") %> : <%= @from.utc.getlocal.strftime("%Y-%b-%d") rescue '-' %>  - <%= t("views.right_panel.detail.to_date") %> : <%= @to ? @to.utc.getlocal.strftime("%Y-%b-%d") : '-'%></th>
						</tr>
						<% if @shift_from %>
						<tr>
							<% if @shift_data.employee %>		
							<% cashier_name = !@shift_data.nil? ? @shift_data.employee.name : '-' %>
							<% end %>			
							<th colspan="9"><%= t("views.right_panel.detail.shift_name") %> =  <%= @shift_from %> - <%= @shift_to %> ( <%= cashier_name %> )</th>
						</tr>
						<% end %>	 

						<tr>
							<th><%= t("views.right_panel.detail.receipt_no") %></th>
							<th><%= t :cashier %> <%= t("views.right_panel.detail.name") %></th>		
							<th><%= t("views.right_panel.detail.total") %> <%= t("views.right_panel.detail.amount") %></th>
							<th><%= t("views.right_panel.detail.discount") %> <%= t("views.right_panel.detail.amount") %> </th>
							<% @tax_profiles.each do |tax| %>
							<th><%= tax.name %></th>		
							<% end %>
							<!-- <th>Other Amount</th> -->
							<th><%= t("views.right_panel.detail.grand_total") %></th>
							<th><%= t("views.right_panel.detail.rnd_adj_sh") %></th>
							<th><%= t("views.right_panel.detail.grand_total") %> +<br/>
								<%= t("views.right_panel.detail.rnd_adj_sh") %>
							</th>
						</tr>
					</thead>
					<tbody>
						<% grand_total = 0 %>
						<% old_grand_total = 0 %>
						<% total_tax = 0 %>
						<% guest_count = 0 %>
						<% total_sum = 0 %>	
						<% discount_amt = 0 %>		    
						<% other_amt = 0 %>
						<% total_nett = 0 %>	 
						<% rounding_adj = 0%> 	 <% gov_tax = 0 %> <% service_charge = 0 %>	    	  
						<%if @sale_data %> 
						<% @sale_data.each do |result| %>

						<% grand_total = grand_total.to_f + result.grand_total.to_f %>
						<% old_grand_total = old_grand_total.to_f + result.old_grand_total.to_f %>
						<% total_tax += result.total_tax.to_f %>
						<% total_sum += result.total_amount.to_f %>	
						<% discount_amt += result.total_discount.to_f %>
						<% rounding_adj += result.rounding_adjustment.to_f %>

						<% tax_profile_count = @tax_profiles.length %>
						<% sale_tax_count = result.sale_taxes.length %>
						<% tax_count = tax_profile_count - sale_tax_count %>
						<tr>

							<td><%= result.receipt_no rescue '-' %> </td>
							<td><%= result.cashier_name rescue '-' %></td>
							<td><%= result.total_amount rescue '-' %></td>
							<td><%= result.total_discount rescue '-' %></td>
							<!-- <%if result.customer.customer_type == "Takeaway"%>
							    <td>0.0</td>
							<%end%> -->
							<% if !result.sale_taxes.empty? %>
								<% num = 1 
								if tax_count > 0 %>
									<% while num <= tax_count %>
										<td>0</td>
									<% num += 1 
									end %>
								<% end %>
								<% result.sale_taxes.each do |tax| %>
									<td>
										<%= tax.tax_payable_amount rescue '-' %>
									</td>
								<%end%>
							<% else %>
								<% @tax_profiles.each do |tax| %>
									<td>0</td>
								<% end %>
							<%end%>

							<td><%= result.grand_total %></td>			
							<td><%= result.rounding_adjustment.to_f rescue '-' %></td>			
							<td><%= result.grand_total_after_rounding()  rescue '-'%></td>
						</tr>

						<% end %>
						<tr style="border-top:4px double #666;">
							<td colspan="2">&nbsp;</td>
							<td><b><%= total_sum  rescue '-'%></b></td>
							<td><b><%= discount_amt  rescue '-'%></b></td>
							<% @sale_taxes.each do |tax| %>
							<td><b><%= tax.st_amount.round(2) %></b></td>
							<% end %>
							<td><b><%= grand_total.to_f.round(2)  rescue '-'%></b></td>		
							<td><b><%= rounding_adj  rescue '-'%></b></td>		
							<td><b><%= grand_total.to_f.round + rounding_adj %></b></td>				
						</tr>
						<tr>
							<td colspan="2">&nbsp;</td>
							<td><%= t("views.right_panel.detail.total") %> <%= t("views.right_panel.detail.amount") %></td>
							<td><%= t("views.right_panel.detail.discount") %> <%= t("views.right_panel.detail.amount") %></td>
							
							<% @tax_profiles.each do |tax| %>
								<td><%= tax.name %></td>
							<% end %>
							<td><%= t("views.right_panel.detail.grand_total") %></td>
							<td><%= t("views.right_panel.detail.rnd_adj_sh") %></td>
							<td><%= t("views.right_panel.detail.grand_total") %> +<br/>
								<%= t("views.right_panel.detail.rnd_adj_sh") %>
							</td>
						</tr>
						<%end%>
					</tbody>
				</table>
			</div>
		</div>
	</div>
</div>
</body>
</html>