ModuleMaster/hr/restaurant02.aspx - main - ivan/ModMas

ModuleMaster/hr/restaurant02.aspx
109 строк5 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:4900d9fb6
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="restaurant02.aspx.vb" Inherits="HR_restaurant" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Restaurant statistics</title>
<link href="../Styles/page.css" rel="stylesheet" />
    <script src="../Scripts/jquery-1.9.1.min.js"></script>
</head>
<body>
    <form id="form1" runat="server">
        <div class="center">
            Company:
            <asp:DropDownList runat="server" ID="company" DataSourceID="sdsCompany" DataTextField="company" DataValueField="company" AutoPostBack="True"></asp:DropDownList>
            <asp:SqlDataSource ID="sdsCompany" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="select * from OPENQUERY(ORCHESTRA2,'
select distinct company from orchestra_new.`hr_dplan_employees`' )"></asp:SqlDataSource>
            Period:
            <asp:TextBox runat="server" ID="fromDate" TextMode="Date" Width="130px"></asp:TextBox>~<asp:TextBox runat="server" ID="toDate" TextMode="Date" Width="130px" ></asp:TextBox>
            <asp:Button runat="server" ID="refresh" Text ="Refresh" />
            <asp:Button runat="server" ID="excel" Text="Excel" />
            <hr />
        </div>
        <div>
            <asp:GridView ID="GridView1" runat="server" 
                BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" 
                BorderWidth="1px" 
                CellPadding="5" 
                AllowSorting="True" 
                AutoGenerateColumns="False" PageSize="30" >
                <Columns>
                    <asp:BoundField DataField="company" HeaderText="company" SortExpression="company" />
                    <asp:BoundField DataField="gen" HeaderText="gen" SortExpression="gen" />
                    <asp:BoundField DataField="fullname" HeaderText="fullname" SortExpression="fullname" />
                    <asp:BoundField DataField="Quantity" HeaderText="Quantity" SortExpression="Quantity" ReadOnly="True" />
                    <asp:BoundField DataField="cost" HeaderText="cost" SortExpression="cost" ReadOnly="True" />
                </Columns>
                <FooterStyle BackColor="White" ForeColor="#000066" />
                <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
                <RowStyle ForeColor="#000066"  />
                <AlternatingRowStyle BackColor ="#EFEFEF" ForeColor="#000066" />
                <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                <SortedAscendingCellStyle BackColor="#F1F1F1" />
                <SortedAscendingHeaderStyle BackColor="#007DBB" />
                <SortedDescendingCellStyle BackColor="#CAC9C9" />
                <SortedDescendingHeaderStyle BackColor="#00547E" />
            </asp:GridView>
            <asp:SqlDataSource ID="sdsRestStat" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="
select t1.*, t2.Quantity, t2.cost from (
select * from OPENQUERY(ORCHESTRA2,'
select distinct company, gen, fullname from orchestra_new.`hr_dplan_employees` 
where company=''@company'' and date
between ''@from'' and ''@to''
')
) t1 left join (
SELECT 
employeeno,
employeename,
count (*) as Quantity,
sum(cost) as Cost
FROM [user].[RESTAURANT_STATISTICS]
WHERE 
procdate between '@from' and '@to'
group by 
employeeno,
employeename
) t2 on t1.gen collate Cyrillic_General_CI_AI  = t2.employeeno collate Cyrillic_General_CI_AI ">
            </asp:SqlDataSource>
        </div>
        <div id="details" style="background-color: white; display : none; border: 2px solid gray;">
            <div class="right">
                <img id="closePopup" src="../Images/Cancel.png" class="click"/>
            </div>
            <div id="detailsBody">
            </div>
        </div>
        <script type="text/javascript">
            $("#closePopup").click(function () {
                $("#details").css("display", "none")
            })
            $("#GridView1 tr").dblclick(function () {
                var request = $.ajax({
                    url: "reststatbyperson.aspx",
                    data: {
                        gen: $(this).attr("gen"),
                        from: $("#fromDate").val(),
                        to: $("#toDate").val()
                    }
                });
                request.done(showDetails);
                request.fail(showDetailsFails);
            })
            function showDetails(result) {
                $("#detailsBody").html(result);
                centerPopup($("#details"));
            }
            function showDetailsFails() {
            }
            function centerPopup(popup) {
                popup.css("display", "");
                popup.css("position", "absolute");
                popup.css("top", (($(window).height() - popup.outerHeight()) / 2) + $(window).scrollTop() + "px");
                popup.css("left", (($(window).width() - popup.outerWidth()) / 2) + $(window).scrollLeft() + "px");
            }
        </script>
    </form>
</body>
</html>