/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/logistics/month_report.aspx
224 строки
11 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="month_report.aspx.vb" Inherits="GA_month_report" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Drivers monthly reportr</title> <link href="../Styles/page.css" rel="stylesheet" /> <link href="../Styles/Site.css" rel="stylesheet" /> <link href="../Styles/editableGrid1.css" rel="stylesheet" /> <style type="text/css"> td { padding: 10px; } </style> </head> <body> <form id="form1" runat="server"> <asp:Label ID="Label1" runat="server" Text="Label" Visible="False"></asp:Label> <div class="center" style="vertical-align: center;"> <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_LOGISTICS] ORDER BY [MONTH] DESC"></asp:SqlDataSource> <asp:ImageButton ID="refresh" runat="server" ImageUrl="~/Images/Refresh.png" ToolTip="Refresh information" /> <asp:ImageButton ID="confirm" runat="server" ImageUrl="~/Images/Buttons/24/Ok_red.png" ToolTip="Fix month data" /> <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/Images/back.png" ToolTip="Undo month fixing" /> <br /> Period: <asp:Label runat="server" ID="lblPeriod"></asp:Label> <hr /> TAX 30.8 = (Gross salary-19 242)*0.158 + 19 242*0.308 // MROT = 19 242 // TC PROFIT = 11% <hr /> <asp:Label runat="server" ID="lblDebug"></asp:Label> </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" /> <asp:TemplateField></asp:TemplateField> <asp:BoundField DataField="DRIVER" HeaderText="Driver name" SortExpression="DRIVER" /> <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="WORKED_DAYS" HeaderText="Worked days" SortExpression="WORKED_DAYS"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="MONTH_RATE" HeaderText="Monthly rate" SortExpression="MONTH_RATE" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="THIS_MONTH_WORK_HOURS" HeaderText="Plan hours" SortExpression="THIS_MONTH_WORK_HOURS" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="PER_HOUR" HeaderText="Per hour" SortExpression="PER_HOUR" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="T_04" HeaderText="x0.4" SortExpression="T_04" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="T_1" HeaderText="x1" SortExpression="T_1" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="T_15" HeaderText="x1.5" SortExpression="T_15" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="T_2" HeaderText="x2" SortExpression="T_2" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="T_1" HeaderText="1" SortExpression="T_1" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <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" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="EXPENSE" HeaderText="Expense" SortExpression="EXPENSE" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="GROSS_SALARY" HeaderText="Gross salary" SortExpression="GROSS_SALARY" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="PREPAYMENT" HeaderText="Prepayment" SortExpression="PREPAYMENT" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="TAX_13" HeaderText="Tax 13%" SortExpression="TAX_13" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="SECOND_PAYMENT" HeaderText="Final payment" SortExpression="SECOND_PAYMENT" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="TAX_305" HeaderText="Tax 30.8%" SortExpression="TAX_305" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="TC_PROFIT" HeaderText="TC Profit" SortExpression="TC_PROFIT" ItemStyle-CssClass="border_left" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" /> </asp:BoundField> <asp:BoundField DataField="SUB_TOTAL" HeaderText="SUB Total" ReadOnly="True" SortExpression="SUB_TOTAL" ItemStyle-CssClass="border_left_bold" DataFormatString="{0:n}"> <ItemStyle HorizontalAlign="Center" Font-Bold="True" /> </asp:BoundField> <asp:BoundField DataField="TOTAL" HeaderText="Total" ReadOnly="True" SortExpression="TOTAL" ItemStyle-CssClass="border_left_bold" 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 T1.[MONTH] , T1.DRIVER , T1.THIS_MONTH_WORK_DAYS , T1.WORKED_DAYS , T1.MONTH_RATE , T1.THIS_MONTH_WORK_HOURS , CAST(T1.PER_HOUR AS VARCHAR)PER_HOUR , CAST(T1.T_04 AS VARCHAR) T_04 , CAST(T1.T_1 AS VARCHAR) T_1 , CAST(T1.T_15 AS VARCHAR) T_15 , CAST(T1.T_2 AS VARCHAR) T_2 , T1.SALARY , T1.OVERTIME , T1.GROSS_SALARY , T1.EXPENSE , T1.PREPAYMENT , T1.TAX_13 , T1.SECOND_PAYMENT , T1.TAX_305 , T1.TC_PROFIT , T1.TOTAL - T1.PREPAYMENT AS SUB_TOTAL , T1.TOTAL , '~/HANDLERS/GETFILE.ASHX?STORAGE=USERMODULESATTACHMENTS.[USER].[DRIVERS_LIST_2]&ID=' + CAST((SELECT TOP 1 ID FROM USERMODULESATTACHMENTS.[USER].DRIVERS_LIST_2 WHERE PARENTID = T2.ID AND DELETED='N') AS VARCHAR (2)) AS PHOTO , MONTH_IS_FIXED FROM HR.[DBO].[TB_DRIVER_MONTHLY_PAYMENTS_2] T1 LEFT JOIN USERMODULES.[USER].DRIVERS_LIST_2 T2 ON T1.DRIVER COLLATE CYRILLIC_GENERAL_CI_AI = T2.NAME COLLATE CYRILLIC_GENERAL_CI_AI WHERE T2.ACTIVE_194 = 'Y' AND [MONTH]=@MONTH UNION SELECT [MONTH] , N'ЯЯЯЯЯЯ' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , SUM(SALARY) , SUM(OVERTIME) , SUM(GROSS_SALARY) , SUM(EXPENSE) , SUM(PREPAYMENT) , SUM(TAX_13) , SUM(SECOND_PAYMENT) , SUM(TAX_305) , SUM(TC_PROFIT) , SUM(SUB_TOTAL) , SUM(TOTAL) , '' , 0 FROM ( SELECT * , TOTAL - PREPAYMENT AS SUB_TOTAL FROM HR. [DBO].[TB_DRIVER_MONTHLY_PAYMENTS_2] )TT WHERE [MONTH]=@MONTH GROUP BY [MONTH] "> <SelectParameters> <asp:ControlParameter ControlID="month" Name="MONTH" PropertyName="SelectedValue" /> </SelectParameters> </asp:SqlDataSource> <hr /> </div> </form> </body> </html>