<!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="15"> <%= t("views.right_panel.detail.from_date") %> : <%= @from.strftime("%Y-%b-%d") rescue '-' %>  - <%= t("views.right_panel.detail.to_date") %> : <%= @to.strftime("%Y-%b-%d")  rescue '-'%></th>
						</tr>
						<% if @shift_from %>
						<tr>
							<% if @shift_data.employee %>		
							<% cashier_name = !@shift_data.nil? ? @shift_data.employee.name : '-' %>
							<% end %>			
							<th colspan="15"><%= t("views.right_panel.detail.shift_name") %> =  <%= @shift_from %> - <%= @shift_to %> ( <%= cashier_name %> )</th>
						</tr>
						<% end %>	 

						<tr>
							<th><%= t("views.right_panel.detail.receipt_date") %></th>
							<th> <%= t("views.right_panel.detail.receipt_no") %></th>
							<th><%= t :reference_number %></th>
							<th><%= t :customer %></th>
							<!-- <th><%= t("views.right_panel.detail.type") %></th> -->
							<th><%= t("views.right_panel.detail.provider") %></th>
							<th><%= t :payment_method %></th>
							<th><%= t :payment %> <%= t("views.right_panel.detail.status")%></th>
							<th><%= t("views.right_panel.detail.sub_total") %></th>
							<th><%= t("views.right_panel.detail.discount_amount") %></th>
							<th><%= t("views.right_panel.detail.delivery_fee") %></th>
							<th><%= t("views.right_panel.detail.convenience_charge") %></th>
							<!-- <th><%= t("views.right_panel.detail.delivery_tax") %></th>
							<th><%= t("views.right_panel.detail.convenience_tax") %></th>
							<th><%= t("views.right_panel.detail.commercial_tax") %></th> -->
							<th><%= t("views.right_panel.detail.total") %> <%= t("views.right_panel.detail.tax") %></th>
							<th><%= t("views.right_panel.detail.grand_total") %></th>
							<th><%= t("views.right_panel.detail.transaction_fee") %></th>
						</tr>
					</thead>
					<tbody>
						<%
					    	
					    	discount_amount = 0.0
					    	delivery_fee = 0.0
					    	convenience_charge = 0.0
					    	delivery_tax = 0.0
					    	convenience_tax = 0.0
					    	commercial_tax = 0.0

					    	total_discount_amount = 0
					    	total_delivery_fee = 0
					    	total_convenience_charge = 0
					    	total_delivery_tax = 0
					    	total_convenience_tax = 0
					    	total_commercial_tax = 0
					    	total_tax = 0.0
					    	total_amount = 0.0
					    	grand_total = 0.0
					    	transaction_fee = 0.0
					    %>
					    <% unless @order_reservation_data.blank? %>
							<% @order_reservation_data.each do |order_reservation| %>
								<% 
									provider = "" 
									discount_amount = order_reservation.discount_amount
									delivery_fee = order_reservation.delivery_fee ? order_reservation.delivery_fee : 0.0
									convenience_charge = order_reservation.convenience_charge
									if !JSON.parse(order_reservation.taxes).nil? && !JSON.parse(order_reservation.taxes).empty?
										JSON.parse(order_reservation.taxes).each do |tax_data|
											if tax_data[0] == "delivery_tax"
												delivery_tax = tax_data[1]
											elsif tax_data[0] == "convenience_tax"
												convenience_tax = tax_data[1]
											elsif tax_data[0] == "commercial_tax"
												commercial_tax = tax_data[1]
											end
										end
									end

									total_discount_amount += discount_amount.to_f
									total_delivery_fee += delivery_fee.to_f
									total_convenience_charge += convenience_charge.to_f
									total_delivery_tax += delivery_tax.to_f
									total_convenience_tax += convenience_tax.to_f
									total_commercial_tax += commercial_tax.to_f
									total_tax += order_reservation.total_tax.to_f
									total_amount += order_reservation.total_amount.to_f
									grand_total += order_reservation.grand_total.to_f
								%>
								<% if order_reservation.transaction_fee && order_reservation.transaction_fee > 0
									transaction_fee += order_reservation.transaction_fee.to_f 
								 end %>
								<%
									if order_reservation.provider == 'pick_up'
										provider = "Pick-Up"
									elsif order_reservation.provider == 'direct_delivery'
										provider = "Direct Delivery"
									elsif order_reservation.provider == 'turbo'
										provider = "TURBO"
									else
										provider = order_reservation.provider
									end
									payment_type = ""
									if order_reservation.payment_type == "cash_on_delivery"
										payment_type = "COD"
									elsif order_reservation.payment_type == "dinga"
										payment_type = "DINGA"
									end
								%>
								<tr>
									<td><%= order_reservation.receipt_date.strftime("%Y-%m-%d") %></td>
									<td><%= order_reservation.receipt_no %></td>
									<td><%= order_reservation.transaction_ref %></td>
									<td><%= order_reservation.name %></td>
									<!-- <td><%= order_reservation.order_reservation_type %></td> -->
									<td><%= provider%></td>
									<td><%= payment_type%></td>
									<td><%= order_reservation.payment_status%></td>
									<td><%= order_reservation.total_amount rescue '0.0'%></td>
									<td><%= discount_amount rescue '0.0'%></td>
									<td><%= delivery_fee rescue '0.0'%></td>
									<td><%= convenience_charge rescue '0.0'%></td>
									<!-- <td><%= delivery_tax rescue '0.0'%></td>
									<td><%= convenience_tax rescue '0.0'%></td>
									<td><%= commercial_tax rescue '0.0'%></td> -->
									<td><%= order_reservation.total_tax rescue '0.0'%></td>
									<td><%= order_reservation.grand_total rescue '0.0' %></td>
									<td><%= order_reservation.transaction_fee rescue '0.0' %></td>
								</tr>
							<% end 
						end %>

						<tr>
							<td colspan="7"><b>Total</b></td>
							<td><b><%= total_amount rescue '0.0'%></b></td>
							<td><b><%= total_discount_amount rescue '0.0'%></b></td>
							<td><b><%= total_delivery_fee rescue '0.0'%></b></td>
							<td><b><%= total_convenience_charge rescue '0.0'%></b></td>
							<!-- <td><b><%= total_delivery_tax rescue '0.0'%></b></td>
							<td><b><%= total_convenience_tax rescue '0.0'%></b></td>
							<td><b><%= total_commercial_tax rescue '0.0'%></b></td> -->
							<td><b><%= total_tax rescue '0.0'%></b></td>
							<td><b><%= grand_total rescue '0.0'%></b></td>
							<td><b><%= transaction_fee rescue '0.0'%></b></td>
						</tr>
					</tbody>
				</table>
			</div>
		</div>
	</div>
</div>
</body>
</html>