| Server IP : 103.6.199.200 / Your IP : 3.144.40.216 Web Server : Microsoft-IIS/10.0 System : Windows NT EMPUSA 10.0 build 20348 (Windows Server 2016) i586 User : EMPUSA$ ( 0) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Domains/airzones/mpos.airzone.sg/wwwroot/ |
Upload File : |
<%@ Page Language="C#" AutoEventWireup="true" EnableEventValidation="false" MasterPageFile="~/APOS.Master"
CodeBehind="DailySalesReport.aspx.cs" Inherits="Megazip.DailySalesReport" %>
<asp:Content ContentPlaceHolderID="Content_Admin" ID="body" runat="server">
<ul class="breadcrumb push-down-0">
<li><a href="#">Super Admin</a></li>
<li class="active">Daily Sales Report</li>
</ul>
<script src="js/jquery-1.7.2.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(function() {
$("#ctl00_Content_Admin_txtfromdate").datepicker();
$("#ctl00_Content_Admin_txtto_date").datepicker();
});
</script>
<script type="text/javascript">
$(document).ready(function() {
$('#ctl00_Content_Admin_txtstarttime').mask("99:99");
$('#ctl00_Content_Admin_txtEndTime').mask("99:99");
});
</script>
<style type="text/css">
.ui-datepicker
{
font-size: 8pt !important;
}
</style>
<div class="page-content-wrap">
<form id="Form1" runat="server">
<div class="row">
<div class="col-md-12">
<div class="panel panel-success panel-hidden-controls">
<div class="panel-heading">
<h3 class="panel-title">
Daily Sales Report</h3>
<ul class="panel-controls">
<li><a href="#" class="panel-fullscreen"><span class="fa fa-expand"></span></a></li>
<li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown"><span
class="fa fa-cog"></span></a>
<ul class="dropdown-menu">
<li><a href="#" class="panel-collapse"><span class="fa fa-angle-down"></span>Collapse</a></li>
<li><a href="#" class="panel-refresh"><span class="fa fa-refresh"></span>Refresh</a></li>
</ul>
</li>
<li><a href="#" class="panel-remove"><span class="fa fa-times"></span></a></li>
</ul>
</div>
<div class="panel-body">
<div class="row">
<div class="col-md-6">
<div class="row">
<div class="form-group">
<asp:Label ID="lbllocation" runat="server" class="col-md-4 col-xs-12 control-label">Location Name</asp:Label>
<div class="col-md-6 col-xs-12">
<asp:DropDownList ID="ddllocation" AutoPostBack="true" CssClass="form-control selected"
TabIndex="1" runat="server" OnSelectedIndexChanged="ddllocation_SelectedIndexChanged">
</asp:DropDownList>
</div>
</div>
</div>
</br>
<div class="row">
<div class="form-group">
<asp:Label ID="lblfrom" runat="server" class="col-md-4 col-xs-12 control-label">From Date</asp:Label>
<div class="col-md-6 col-xs-12">
<asp:TextBox ID="txtfromdate" Enabled="True" runat="server" class="form-control"
TabIndex="2"></asp:TextBox>
</div>
</div>
</div>
<br />
<div class="row">
<div class="form-group">
<asp:Label ID="lblto_date" runat="server" class="col-md-4 col-xs-12 control-label">To Date</asp:Label>
<div class="col-md-6 col-xs-12">
<asp:TextBox ID="txtto_date" Enabled="True" runat="server" class="form-control" TabIndex="3"></asp:TextBox>
</div>
</div>
</div>
<br />
</div>
<div class="col-md-6">
<div class="row">
<div class="form-group">
<asp:Label ID="Label2" runat="server" class="col-md-4 col-xs-12 control-label">Start Time</asp:Label>
<div class="col-md-6 col-xs-12">
<div class="timepicki">
<asp:TextBox ID="txtstarttime" runat="server" class=" form-control" type="text" TabIndex="6"
MaxLength="5" name="timepicker1" placeholder="09:00"></asp:TextBox>
<label style="color: blue;">
Format (HH:mm)</label>
<asp:RequiredFieldValidator runat="server" ID="RequiredFieldValidator1" ControlToValidate="txtstarttime"
ErrorMessage="Please select start Time!" />
</div>
</div>
</div>
</div>
<br />
<br />
<br />
<br />
<div class="row">
<div class="form-group">
<asp:Label ID="Label3" runat="server" class="col-md-4 col-xs-12 control-label">End Time</asp:Label>
<div class="col-md-6 col-xs-12">
<asp:TextBox ID="txtEndTime" runat="server" class=" form-control" type="text" TabIndex="7"
MaxLength="5" name="timepicker2" placeholder="22:00"></asp:TextBox>
<label style="color: blue;">
Format (HH:mm)</label>
<asp:RequiredFieldValidator runat="server" ID="RequiredFieldValidator2" ControlToValidate="txtEndTime"
ErrorMessage="Please select End Time!" />
</div>
</div>
</div>
<br />
</div>
</div>
<br />
<br />
<br />
<div class="row">
<div class="form-group">
<asp:Label ID="Label5" runat="server" class="col-md-4 col-xs-12 control-label"></asp:Label>
<div class="col-md-12 col-xs-12">
<center>
<asp:Button ID="btn_LocationMaster" Text="Submit" runat="server" class="btn btn-success"
OnClick="btn_LocationMaster_Click" />
<asp:Button ID="btnClear" runat="server" Text="Clear" class="btn btn-danger" OnClick="btnClear_Click" />
</center>
</div>
</div>
</div>
<br />
<div id="Gridvie" runat="server">
<div class="page-content-wrap table-responsive">
<div class="panel-body">
<asp:GridView ID="Salesview" runat="server" CssClass="table datatable" AutoPostBack="True"
ShowFooter="true" AutoGenerateColumns="False" CaptionAlign="Top" BorderStyle="Solid"
Caption="Daily Sales Report" OnRowCommand="Salesview_RowCommand" OnRowDataBound="Salesview_RowDataBound"
OnRowDeleting="Salesview_RowDeleting" OnRowEditing="Salesview_RowEditing" OnPageIndexChanging="Salesview_PageIndexChanging">
<Columns>
<%--<asp:TemplateField HeaderText="Location Name">
<ItemTemplate>
<asp:LinkButton ID="lbtnEdit" runat="server" CommandArgument='<%# Eval("Location") %>'
Text='<%# Eval("Location") %>' CommandName="Edit"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>--%>
<asp:BoundField DataField="Location" HeaderText="Location Name" ReadOnly="true" ItemStyle-HorizontalAlign="Center">
</asp:BoundField>
<asp:BoundField DataField="Created_Date" HeaderText="Time log in" ReadOnly="true"
ItemStyle-HorizontalAlign="Center"></asp:BoundField>
<asp:BoundField DataField="ModifiedDate" HeaderText="Time log out" ItemStyle-HorizontalAlign="Center">
</asp:BoundField>
<asp:BoundField DataField="UserName" HeaderText="Operator Name" ItemStyle-HorizontalAlign="Left">
</asp:BoundField>
<asp:BoundField DataField="FloatID" HeaderText="Float ID" ItemStyle-HorizontalAlign="Left">
</asp:BoundField>
<asp:BoundField DataField="FirstFloat" HeaderText="Float Declared" ItemStyle-HorizontalAlign="Right">
</asp:BoundField>
<asp:BoundField DataField="CashinHand" HeaderText="Sales revenue including float"
ItemStyle-HorizontalAlign="Right"></asp:BoundField>
<%-- <asp:BoundField DataField="Paid" HeaderText="Sales revenue declared excluding float"
ItemStyle-HorizontalAlign="Right"></asp:BoundField>--%>
<asp:BoundField DataField="Change" HeaderText="Variance" ItemStyle-HorizontalAlign="Right">
</asp:BoundField>
<asp:BoundField DataField="Total_Gst" HeaderText="Total of all PLU including DSC"
ItemStyle-HorizontalAlign="Left"></asp:BoundField>
<asp:TemplateField HeaderText="Control">
<ItemTemplate>
<asp:LinkButton ID="lbtnEdit" runat="server" CommandArgument='<%# Eval("UserName") %>'
class="btn btn-primary clickMe fa fa-edit" CommandName="Edit"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<AlternatingRowStyle BackColor="#F3F5F8" />
</asp:GridView>
</div>
</div>
</div>
<br />
<div id="divproduct" runat="server">
<div class="page-content-wrap table-responsive">
<div class="panel-body">
<asp:GridView ID="ProductDetails" runat="server" CssClass="table datatable" AutoPostBack="True"
AutoGenerateColumns="False" CaptionAlign="Top" Caption="Product Details" OnRowDataBound="ProductDetails_RowDataBound"
OnPageIndexChanging="ProductDetails_PageIndexChanging" OnRowCommand="ProductDetails_RowCommand"
ShowFooter="true" BorderColor="#000000" BorderStyle="Solid" BorderWidth="1px"
EmptyDataText="No Records Found" Font-Bold="False" Font-Names="Arial" Font-Size="12px"
Width="100%" Height="70px">
<Columns>
<%--<asp:TemplateField HeaderText="Product Id">
<ItemTemplate>
<asp:LinkButton ID="lbtnEdit" runat="server" CommandArgument='<%# Eval("ProductId") %>'
Text='<%# Eval("ProductId") %>' CommandName="Edit1"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>--%>
<asp:BoundField DataField="ProductId" HeaderText="Product Code"></asp:BoundField>
<asp:BoundField DataField="Description" HeaderText="Product Name"></asp:BoundField>
<asp:BoundField DataField="Qty" HeaderText="Quantity"></asp:BoundField>
<asp:BoundField DataField="Value" HeaderText="Product Price"></asp:BoundField>
<asp:BoundField DataField="Total_Gst" HeaderText="Total Sold" DataFormatString="{0:N2}">
</asp:BoundField>
<asp:TemplateField HeaderText="Control">
<ItemTemplate>
<asp:LinkButton ID="lbtnEdit" runat="server" CommandArgument='<%# Eval("ProductId") %>'
class="btn btn-primary clickMe fa fa-edit" CommandName="Edit1"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<AlternatingRowStyle BackColor="#F7F3E8" />
</asp:GridView>
<br />
</div>
</div>
</div>
<div id="divDiscount" runat="server">
<div class="page-content-wrap table-responsive">
<div class="panel-body">
<asp:GridView ID="DiscountDetails" runat="server" CssClass="table datatable" AutoPostBack="True"
AutoGenerateColumns="False" DataKeyNames="DiscountId" CaptionAlign="Top" Caption="Discount Details"
ShowFooter="true" OnPageIndexChanging="DiscountDetails_PageIndexChanging" OnRowCommand="DiscountDetails_RowCommand"
OnRowDataBound="DiscountDetails_RowDataBound" BorderColor="#000000" BorderStyle="Solid"
BorderWidth="1px" EmptyDataText="No Records Found" Font-Bold="False" Font-Names="Arial"
Font-Size="12px" Width="100%">
<Columns>
<%--<asp:TemplateField HeaderText="Discount ID">
<ItemTemplate>
<asp:LinkButton ID="lbtnEdit" runat="server" CommandArgument='<%# Eval("DiscountId") %>'
Text='<%# Eval("DiscountId") %>' CommandName="Edit2"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>--%>
<asp:BoundField DataField="DiscountId" HeaderText="Discount Id"></asp:BoundField>
<asp:BoundField DataField="DiscountName" HeaderText="Discount Name"></asp:BoundField>
<asp:BoundField DataField="Qty" HeaderText="Discount Quantity"></asp:BoundField>
<asp:BoundField DataField="Total" HeaderText="Discount Value"></asp:BoundField>
<asp:BoundField DataField="Total_Gst" HeaderText="Total Discount" DataFormatString="{0:N2}">
</asp:BoundField>
</Columns>
<AlternatingRowStyle BackColor="#F7F3E8" />
<AlternatingRowStyle BackColor="#F7F3E8" />
</asp:GridView>
</div>
</div>
<br />
<div class="page-content-wrap table-responsive">
<div class="panel-body">
<asp:GridView ID="RedeemDetails" runat="server" CssClass="table datatable" AutoPostBack="True"
AutoGenerateColumns="False" CaptionAlign="Top" Caption="Redeem Details" ShowFooter="true"
OnRowCreated="RedeemDetails_RowCreated" BorderColor="#000000" BorderStyle="Solid"
BorderWidth="1px" EmptyDataText="No Records Found" Font-Bold="False" Font-Names="Arial"
Font-Size="12px" Width="100%">
<Columns>
<asp:BoundField DataField="ProductName" HeaderText="Product Name" ItemStyle-HorizontalAlign="Left">
</asp:BoundField>
<asp:BoundField DataField="NRedeem" HeaderText="Not Redeemed Coupon" ItemStyle-HorizontalAlign="Right">
</asp:BoundField>
<asp:BoundField DataField="ProductName" HeaderText="Product Name" ItemStyle-HorizontalAlign="Left">
</asp:BoundField>
<asp:BoundField DataField="YRedeem" HeaderText="Redeemed Coupon" ItemStyle-HorizontalAlign="Right">
</asp:BoundField>
</Columns>
<AlternatingRowStyle BackColor="#F7F3E8" />
</asp:GridView>
</div>
</div>
<br />
<div id="divrbtnStatus" runat="server">
<div class="row">
<div class="form-group">
<div class="col-md-6 col-xs-12">
<div class="input-group">
<asp:RadioButtonList ID="rbtnStatus" RepeatDirection="Horizontal" runat="server">
<%--<asp:ListItem Text="Vertical" Value="1" Selected="True"> </asp:ListItem>--%>
<asp:ListItem Text="Horizontal" Value="2"></asp:ListItem>
</asp:RadioButtonList>
</div>
</div>
</div>
</div>
</div>
<div class="pull-right">
<asp:Button ID="btnExport" runat="server" class="btn btn-success" Text="Export To Excel"
OnClick="btnExport_Click" />
</div>
</div>
</div>
</div>
</div>
</div>
</form>
</div>
</asp:Content>