/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/ga/month_report.aspx
215 строк
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 report</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: 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="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-22,440)*0.158 + 22,440*0.308 // MROT = 22,440 // TC PROFIT = 11% <hr /> </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="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 * FROM ( SELECT t1.[month] , t1.DRIVER , t1.this_month_work_days , t1.worked_days , t1.month_rate , t1.salary , t1.overtime , t1.gross_salary , t1.expense , t1.prepayment , t1.tc_profit , t1.second_payment , t1.tax_13 , t1.tax_305 , t1.total , t1.total - t1.prepayment as SUB_TOTAL , '~/handlers/getfile.ashx?storage=UserModulesAttachments.[user].[DRIVERS_LIST]&id=' + cast((SELECT TOP 1 id from UserModulesAttachments.[user].DRIVERS_LIST where parentId = t2.id and deleted='N') as varchar (2)) as photo , MONTH_IS_FIXED FROM hr. [dbo].[TB_DRIVER_MONTHLY_PAYMENTS] t1 LEFT JOIN UserModules.[user].DRIVERS_LIST t2 on t1.DRIVER = t2.NAME WHERE t2.ACTIVE_194 = 'Y' UNION select [month], 'ЯЯЯЯЯ' , sum(cast (tt.this_month_work_days as integer)) , sum(cast (worked_days as integer)) , sum(cast(month_rate as integer)) , sum(salary) , sum(overtime) , sum(gross_salary) , sum(expense) , sum(prepayment) , sum(tc_profit) , sum(second_payment) , sum(tax_13) , sum(tax_305) , sum(total) , sum(sub_total) , '' , 0 FROM ( SELECT * , total - prepayment as SUB_TOTAL FROM hr. [dbo].[TB_DRIVER_MONTHLY_PAYMENTS] )TT GROUP BY [month] )TTT 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> </form> </body> </html>