/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/ga/month_report_new.aspx
316 строк
18 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="month_report_new.aspx.vb" Inherits="GA_month_report_new" %> <%@ Register Src="~/UserControls/Auth.ascx" TagPrefix="uc1" TagName="Auth" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Drivers monthly report</title> <link href="../Styles/page.css" rel="stylesheet" /> <%-- <link href="../Styles/Site.css" rel="stylesheet" /> <link href="../Styles/editableGrid1.css" rel="stylesheet" />--%> <script src="jquery3.7.1.js"></script> <style type="text/css"> td { padding: 10px; align-content: center; writing-mode: horizontal-tb !important; } .work_days { writing-mode: sideways-lr; } </style> </head> <body> <form id="form1" runat="server"> <asp:Label ID="lblMessage" runat="server" Text="???" Visible="True"></asp:Label> <div class="center" style="vertical-align: middle;"> <br /> Month: <asp:DropDownList runat="server" ID="month" DataSourceID="sdsMonth" DataTextField="month" DataValueField="month" AutoPostBack="true"></asp:DropDownList> <asp:SqlDataSource ID="sdsMonth" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="SELECT distinct [month] FROM hr.[dbo].[VI_DRIVER_MONTHLY_PAYMENTS] ORDER BY [MONTH] DESC"></asp:SqlDataSource> <asp:ImageButton ID="refresh" runat="server" ImageUrl="~/Images/Refresh.png" ToolTip="Refresh information" /> <asp:ImageButton ID="ibMonthConfirmation" runat="server" ImageUrl="~/Images/Buttons/24/Ok_red.png" ToolTip="Fix month data" /> <asp:ImageButton ID="ibUndoMonthConfirmation" runat="server" ImageUrl="~/Images/back.png" ToolTip="Undo month fixing" /> <asp:ImageButton ID="ibExcelDownload" runat="server" ImageUrl="~/Images/excel1.png" ToolTip="Download as excel" /> <br /> Period: <asp:Label runat="server" ID="lblPeriod"></asp:Label> <hr /> <asp:Label runat="server" ID="lblFormula"> TAX 30.8 = (Gross salary-40639.50)*0.158 + 40639.50*0.308 // 1.5 MROT = </asp:Label> <asp:Label runat="server" id="lblMrotNogiVRot">40639.50</asp:Label> <hr /> </div> <div class="center" style="vertical-align: middle;"> </div> <div class="ceter"> <asp:GridView ID="report" runat="server" AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333"> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> <Columns> <asp:BoundField DataField="MONTH" HeaderText="MONTH" SortExpression="MONTH" ItemStyle-CssClass="border_left"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="DRIVER" HeaderText="DRIVER" SortExpression="DRIVER" ItemStyle-CssClass="border_left"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="THIS_MONTH_WORK_DAYS" HeaderText="WORK DAYS" SortExpression="THIS_MONTH_WORK_DAYS" ItemStyle-CssClass="border_left"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="NORMAL" HeaderText="NORMAL" SortExpression="NORMAL"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="VACATION" HeaderText="VACATION" SortExpression="VACATION"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="PROSTOY" HeaderText="PROSTOY" SortExpression="PROSTOY"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="SHORTEN_DAY" HeaderText="SHORTEN DAY" SortExpression="SHORTEN_DAY"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="HOLYDAY" HeaderText="HOLYDAY" SortExpression="HOLYDAY"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="ILNESS" HeaderText="ILNESS" SortExpression="ILNESS"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="WEEKEND" HeaderText="WEEKEND" SortExpression="WEEKEND"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="TOTAL_WORKED_DAYS" HeaderText="TOTAL WORKED DAYS" SortExpression="TOTAL_WORKED_DAYS" ItemStyle-CssClass="border_left"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="MONTH_RATE" HeaderText="MONTH RATE" SortExpression="MONTH_RATE" ItemStyle-CssClass="border_left"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="SALARY" HeaderText="SALARY" SortExpression="SALARY" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="OVERTIME" HeaderText="OVERTIME" SortExpression="OVERTIME" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="EXPENSE" HeaderText="EXPENSE" SortExpression="EXPENSE" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="GROSS_SALARY" HeaderText="GROSS SALARY" SortExpression="GROSS_SALARY" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="ADV_PAYMENT" HeaderText="ADVANCE PAYMENT" SortExpression="ADV_PAYMENT" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="PERSONAL_INCOME_TAX" HeaderText="PERSONAL INCOME TAX" SortExpression="PERSONAL_INCOME_TAX" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="FNL_PAYMENT" HeaderText="FINAL PAYMENT" SortExpression="FNL_PAYMENT" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="SOCIAL_TAX" HeaderText="SOCIAL TAX" SortExpression="SOCIAL_TAX" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="INCOME_TAX" HeaderText="INCOME TAX" SortExpression="INCOME_TAX" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="TOTAL_PAYMENT" HeaderText="TOTAL PAYMENT" SortExpression="TOTAL_PAYMENT" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="TOTAL_PAYMENT_PROFIT_TAX" HeaderText="TOTAL PAYMENT PROFIT TAX" SortExpression="TOTAL_PAYMENT_PROFIT_TAX" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="TOTAL_PAYMENT_WITH_PROFIT_TAX" HeaderText="TOTAL PAYMENT WITH PROFIT TAX" SortExpression="TOTAL_PAYMENT_WITH_PROFIT_TAX" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="ADVANCE_PAYMENT" HeaderText="ADVANCE PAYMENT" SortExpression="ADVANCE_PAYMENT" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="ADVANCE_PAYMENT_PROFIT_TAX" HeaderText="ADVANCE PAYMENT PROFIT TAX" SortExpression="ADVANCE_PAYMENT_PROFIT_TAX" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="ADVANCE_PAYMENT_WITH_PROFIT_TAX" HeaderText="ADVANCE PAYMENT WITH PROFIT TAX" SortExpression="ADVANCE_PAYMENT_WITH_PROFIT_TAX" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="FINAL_PAYMENT" HeaderText="FINAL PAYMENT" SortExpression="FINAL_PAYMENT" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="FINAL_PAYMENT_PROFIT_TAX" HeaderText="FINAL PAYMENT PROFIT TAX" SortExpression="FINAL_PAYMENT_PROFIT_TAX" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="FINAL_PAYMENT_WITH_PROFIT_TAX" HeaderText="FINAL PAYMENT WITH PROFIT TAX" SortExpression="FINAL_PAYMENT_WITH_PROFIT_TAX" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> </Columns> <EditRowStyle BackColor="#999999" /> <FooterStyle BackColor="Gray" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /> <RowStyle BackColor="#F7F6F3" ForeColor="#333333" /> <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /> <SortedAscendingCellStyle BackColor="#E9E7E2" /> <SortedAscendingHeaderStyle BackColor="#506C8C" /> <SortedDescendingCellStyle BackColor="#FFFDF8" /> <SortedDescendingHeaderStyle BackColor="#6F8DAE" /> </asp:GridView> <asp:SqlDataSource ID="sdsReport" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="SELECT * , 0 AS MONTH_IS_FIXED , 0 AS CONFIRMED FROM HR.dbo.FN_DRIVERS_MONTHLY_PAYMENTS (@MONTH, @MROT, 0.308, 0.158, 0.13, 0.06, 0.05, 100000.00) UNION ALL SELECT 1 A,'2' B,'TOTAL' -- C,4 D,5 E,6 F,7 G,8 H,9 I,10 J,11 K,12 L,13 M,14 N,15 -- O,0 P,0 Q,0 R,0 S,0 T,0 U ,SUM([THIS_MONTH_WORK_DAYS]) AS [THIS_MONTH_WORK_DAYS] ,SUM([NORMAL]) AS [NORMAL] ,SUM([VACATION]) AS [VACATION] ,SUM([PROSTOY]) AS [PROSTOY] ,SUM([SHORTEN_DAY]) AS [SHORTEN_DAY] ,SUM([HOLYDAY]) AS [HOLYDAY] ,SUM([ILNESS]) AS [ILNESS] ,SUM([WEEKEND]) AS [WEEKEND] ,SUM([TOTAL_WORKED_DAYS]) AS [TOTAL_WORKED_DAYS] ,SUM([MONTH_RATE]) AS [MONTH_RATE] ,SUM([SALARY]) AS [SALARY] ,SUM([OVERTIME]) AS [OVERTIME] ,SUM([EXPENSE]) AS [EXPENSE] ,SUM([GROSS_SALARY]) AS [GROSS_SALARY] ,SUM([ADV_PAYMENT]) AS [ADV_PAYMENT] ,SUM([PERSONAL_INCOME_TAX]) AS [PERSONAL_INCOME_TAX] ,SUM([FNL_PAYMENT]) AS [FNL_PAYMENT] ,SUM([SOCIAL_TAX]) AS [SOCIAL_TAX] ,SUM([INCOME_TAX]) AS [INCOME_TAX] ,SUM([TOTAL_PAYMENT]) AS [TOTAL_PAYMENT] ,SUM([TOTAL_PAYMENT_PROFIT_TAX]) AS [TOTAL_PAYMENT_PROFIT_TAX] ,SUM([TOTAL_PAYMENT_WITH_PROFIT_TAX]) AS [TOTAL_PAYMENT_WITH_PROFIT_TAX] ,SUM([ADVANCE_PAYMENT]) AS [ADVANCE_PAYMENT] ,SUM([ADVANCE_PAYMENT_PROFIT_TAX]) AS [ADVANCE_PAYMENT_PROFIT_TAX] ,SUM([ADVANCE_PAYMENT_WITH_PROFIT_TAX]) AS [ADVANCE_PAYMENT_WITH_PROFIT_TAX] ,SUM([FINAL_PAYMENT]) AS [FINAL_PAYMENT] ,SUM([FINAL_PAYMENT_PROFIT_TAX]) AS [FINAL_PAYMENT_PROFIT_TAX] ,SUM([FINAL_PAYMENT_WITH_PROFIT_TAX]) AS [FINAL_PAYMENT_WITH_PROFIT_TAX] , 0 AS MONTH_IS_FIXED , 0 AS CONFIRMED FROM HR.dbo.FN_DRIVERS_MONTHLY_PAYMENTS (@MONTH, @MROT, 0.308, 0.158, 0.13, 0.06, 0.05, 100000.00) "> <SelectParameters> <asp:ControlParameter ControlID="month" Name="MONTH" PropertyName="SelectedValue" /> </SelectParameters> <SelectParameters> <asp:ControlParameter ControlID="lblMrotNogiVrot" Name="MROT" PropertyName="Text" /> </SelectParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="sdsConfirmedReport" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="select * from HR.dbo.TB_FN_DRIVERS_MONTHLY_PAYMENTS WHERE [MONTH]=@MONTH UNION ALL SELECT 1 A,'2' B,'TOTAL' -- C,4 D,5 E,6 F,7 G,8 H,9 I,10 J,11 K,12 L,13 M,14 N,15 -- O,0 P,0 Q,0 R,0 S,0 T,0 U ,SUM([THIS_MONTH_WORK_DAYS]) AS [THIS_MONTH_WORK_DAYS] ,SUM([NORMAL]) AS [NORMAL] ,SUM([VACATION]) AS [VACATION] ,SUM([PROSTOY]) AS [PROSTOY] ,SUM([SHORTEN_DAY]) AS [SHORTEN_DAY] ,SUM([HOLYDAY]) AS [HOLYDAY] ,SUM([ILNESS]) AS [ILNESS] ,SUM([WEEKEND]) AS [WEEKEND] ,SUM([TOTAL_WORKED_DAYS]) AS [TOTAL_WORKED_DAYS] ,SUM([MONTH_RATE]) AS [MONTH_RATE] ,SUM([SALARY]) AS [SALARY] ,SUM([OVERTIME]) AS [OVERTIME] ,SUM([EXPENSE]) AS [EXPENSE] ,SUM([GROSS_SALARY]) AS [GROSS_SALARY] ,SUM([ADV_PAYMENT]) AS [ADV_PAYMENT] ,SUM([PERSONAL_INCOME_TAX]) AS [PERSONAL_INCOME_TAX] ,SUM([FNL_PAYMENT]) AS [FNL_PAYMENT] ,SUM([SOCIAL_TAX]) AS [SOCIAL_TAX] ,SUM([INCOME_TAX]) AS [INCOME_TAX] ,SUM([TOTAL_PAYMENT]) AS [TOTAL_PAYMENT] ,SUM([TOTAL_PAYMENT_PROFIT_TAX]) AS [TOTAL_PAYMENT_PROFIT_TAX] ,SUM([TOTAL_PAYMENT_WITH_PROFIT_TAX]) AS [TOTAL_PAYMENT_WITH_PROFIT_TAX] ,SUM([ADVANCE_PAYMENT]) AS [ADVANCE_PAYMENT] ,SUM([ADVANCE_PAYMENT_PROFIT_TAX]) AS [ADVANCE_PAYMENT_PROFIT_TAX] ,SUM([ADVANCE_PAYMENT_WITH_PROFIT_TAX]) AS [ADVANCE_PAYMENT_WITH_PROFIT_TAX] ,SUM([FINAL_PAYMENT]) AS [FINAL_PAYMENT] ,SUM([FINAL_PAYMENT_PROFIT_TAX]) AS [FINAL_PAYMENT_PROFIT_TAX] ,SUM([FINAL_PAYMENT_WITH_PROFIT_TAX]) AS [FINAL_PAYMENT_WITH_PROFIT_TAX] , 0 AS MONTH_IS_FIXED , 0 AS CONFIRMED FROM HR.dbo.TB_FN_DRIVERS_MONTHLY_PAYMENTS WHERE [MONTH]=@MONTH"> <SelectParameters> <asp:ControlParameter ControlID="month" Name="MONTH" PropertyName="SelectedValue" /> </SelectParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="sdsCarReport" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="SELECT * FROM hr.[dbo].[VI_CARS_MONTHLY_STAT] WHERE [MONTH]=@MONTH"> <SelectParameters> <asp:ControlParameter ControlID="month" Name="MONTH" PropertyName="SelectedValue" /> </SelectParameters> </asp:SqlDataSource> <hr /> <asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" AutoGenerateColumns="False" DataSourceID="sdsCarReport" AllowPaging="True" AllowSorting="True"> <AlternatingRowStyle BackColor="White" /> <Columns> <asp:BoundField DataField="Month" HeaderText="Month" SortExpression="month" /> <asp:BoundField HeaderText="Car number" DataField="CAR_NUMBER" SortExpression="CAR_NUMBER" /> <asp:BoundField HeaderText="Start ODO" DataField="start_odo" SortExpression="start_odo" ItemStyle-Width="75"> <ItemStyle HorizontalAlign="Right" /> </asp:BoundField> <asp:BoundField HeaderText="End ODO" DataField="end_odo" SortExpression="end_odo" ItemStyle-Width="75"> <ItemStyle HorizontalAlign="Right" /> </asp:BoundField> <asp:BoundField HeaderText="Mileage" DataField="mileage" SortExpression="mileage" ItemStyle-Width="75"> <ItemStyle HorizontalAlign="Right" /> </asp:BoundField> <asp:BoundField HeaderText="Fuel" DataField="fuel" SortExpression="fuel" ItemStyle-Width="50"> <ItemStyle HorizontalAlign="Right" /> </asp:BoundField> <asp:BoundField HeaderText="AVG Fuel" DataField="avg_fuel" SortExpression="avg_fuel" ItemStyle-Width="50"> <ItemStyle HorizontalAlign="Right" /> </asp:BoundField> </Columns> <EditRowStyle BackColor="#2461BF" /> <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" /> <RowStyle BackColor="#EFF3FB" /> <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" /> <SortedAscendingCellStyle BackColor="#F5F7FB" /> <SortedAscendingHeaderStyle BackColor="#6D95E1" /> <SortedDescendingCellStyle BackColor="#E9EBEF" /> <SortedDescendingHeaderStyle BackColor="#4870BE" /> </asp:GridView> </div> <asp:PlaceHolder runat="server" ID="phScripts"></asp:PlaceHolder> </form> </body> </html>