ModuleMaster/ga/noaccident.aspx - main - ivan/ModMas

ModuleMaster/ga/noaccident.aspx
242 строки10 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:4900d9fb6
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="noaccident.aspx.vb" Inherits="GA_noaccdayscount" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <%--    <meta http-equiv="refresh" content="20" />--%>
    <title>Safety first!</title>
    <style>
        @font-face {
            font-family: Consolas;
            src: url('../fonts/consolab.ttf');
        }

        html, body, form {
            width: 100%;
            height: 100%;
            margin: 0;
            overflow: hidden;
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            background-color: gray;
            background-image: url('../Images/yellowblack.jpg');
        }

        #mainDiv {
            padding: 30px;
            height: 1010px;
            margin: 5px;
            /*background-color: white;*/
            background: #74b5f7; /* Old browsers */
            background: -moz-linear-gradient(top, #74b5f7 0%, #e5e5e5 100%); /* FF3.6-15 */
            background: -webkit-linear-gradient(top, #74b5f7 0%,#e5e5e5 100%); /* Chrome10-25,Safari5.1-6 */
            background: linear-gradient(to bottom, #74b5f7 0%,#e5e5e5 100%); /* W3C, IE10+, FF16+, Chrome26+, Opera12+, Safari7+ */
            filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#74b5f7', endColorstr='#e5e5e5',GradientType=0 ); /* IE6-9 */
        }

        div {
            text-align: center;
        }

        table {
            margin: 0 auto;
        }

        .target {
            font-size: 48pt;
            font-weight: bold;
            border-left: 3px solid navy;
            border-top: 3px solid navy;
            border-right: 3px solid navy;
            margin: 0px 150px 0px 150px;
            padding: 10px;
            background-color: white;
        }

        .today {
            font-size: 54pt;
            color: navy;
            font-weight: bold;
            border: 3px solid navy;
            margin: 5px 150px 0px 150px;
            padding: 20px;
            background-color: white;
        }

        th {
            font-size: 24pt;
        }

        .acccount {
            font-size: 24pt;
            font-weight: bold;
            color: white;
            background-color: navy;
        }

        .dptcount {
            font-size: 78pt;
            font-weight: bold;
            color: green;
            background-color: white;
            font-family: Consolas;
        }

        #itemPlaceholderContainer {
            width: 99%;
            margin: 25px auto;
            
        }

            #itemPlaceholderContainer td {
                width: 17%;
            }

            #itemPlaceholderContainer th {
                color: white;
                background-color: navy;
            }

        .dayslabel {
            vertical-align: middle;
            padding: 10px;
        }

        .days {
            vertical-align: middle;
            background-color: green;
            color: white;
            font-weight: bold;
            font-size: 98pt;
            padding: 5px 50px 5px 50px;
            font-family: Consolas;
        }

        .borderRadius {
            border: solid 5px #1d005c;
            -moz-border-radius-topleft: 17px;
            -moz-border-radius-topright: 17px;
            -moz-border-radius-bottomleft: 17px;
            -moz-border-radius-bottomright: 17px;
            -webkit-border-top-left-radius: 17px;
            -webkit-border-top-right-radius: 17px;
            -webkit-border-bottom-left-radius: 17px;
            -webkit-border-bottom-right-radius: 17px;
            border-top-left-radius: 17px;
            border-top-right-radius: 17px;
            border-bottom-left-radius: 17px;
            border-bottom-right-radius: 17px;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
        <div id="mainDiv">
            <asp:Panel runat="server" ID="pnlData" Visible="False">
                <div class="target borderRadius">
                    <span>Наша цель:
                        <asp:Label runat="server" ID="lblTarget" Text="100" ForeColor="Blue" />&nbsp;дней без происшествий<br />
                        ~<br />
                        С
                        <asp:Label ID="lblDateFrom" runat="server" Text="02.09.2016" ForeColor="Blue" />&nbsp;до
                    <asp:Label runat="server" ID="lblDateTo" Text="11.12.2016" ForeColor="Blue" /></span>
                </div>
                <div class="today borderRadius">
                    <span>SERK&nbsp;&nbsp;&nbsp;
                    <asp:Label runat="server" ID="lblCurDate" Text='<%# Date.Today.ToString("dd.MM.yyyy") %>'></asp:Label>
                    </span>

                    <table>
                        <tr>
                            <td class="days borderRadius">
                                <asp:Label ID="lblDaysWOAccident" runat="server" Text="Label"></asp:Label>
                            </td>
                            <td class="dayslabel">&nbsp;-&nbsp;
                                <asp:Label runat="server" ID="lblDays" />
                                без происшествий!</td>
                        </tr>
                    </table>
                </div>
                <div>
                    <asp:ListView ID="ListView1" ClientIDMode="Static" runat="server" DataSourceID="SqlDataSource1">
                        <EmptyDataTemplate>
                            <table runat="server" style="background-color: #FFFFFF; border-collapse: collapse; border-color: #999999; border-style: none; border-width: 1px;">
                                <tr>
                                    <td>No data was returned.</td>
                                </tr>
                            </table>
                        </EmptyDataTemplate>
                        <ItemTemplate>
                            <tr style="background-color: #E0FFFF; color: #333333;">
                                <td class="acccount">Кол-во
                                <br />
                                    происшествий</td>
                                <td class="dptcount">
                                    <asp:Label ID="VD_Production_Label" runat="server" Text='<%# Eval("[VD production]") %>' />
                                </td>
                                <td class="dptcount">
                                    <asp:Label ID="WM_Production_Label" runat="server" Text='<%# Eval("[WM production]") %>' />
                                </td>
                                <td class="dptcount">
                                    <asp:Label ID="Injection_Label" runat="server" Text='<%# Eval("Injection") %>' />
                                </td>
                                <td class="dptcount">
                                    <asp:Label ID="Finish_Goods_Label" ForeColor='<%# IIf(Eval("[Finish Goods]") = 0, Drawing.Color.Green, Drawing.Color.OrangeRed) %>' runat="server" Text='<%# Eval("[Finish Goods]") %>' />
                                </td>
                                <td class="dptcount">
                                    <asp:Label ID="MM_Label" runat="server" Text='<%# Eval("MM") %>' />
                                </td>
                            </tr>
                        </ItemTemplate>
                        <LayoutTemplate>
                            <table id="itemPlaceholderContainer" runat="server" border="1" style="background-color: #FFFFFF; border-collapse: collapse; border-color: #999999; border-style: none; border-width: 1px; font-family: Verdana, Arial, Helvetica, sans-serif;">
                                <tr runat="server" style="background-color: #E0FFFF; color: #333333;">
                                    <th>Отделы</th>
                                    <th runat="server">VD
                                        <br />
                                        production</th>
                                    <th runat="server">WM
                                        <br />
                                        production</th>
                                    <th runat="server">Injection</th>
                                    <th runat="server">Finish
                                        <br />
                                        Goods</th>
                                    <th runat="server">MM</th>
                                </tr>
                                <tr id="itemPlaceholder" runat="server">
                                </tr>
                            </table>
                        </LayoutTemplate>
                    </asp:ListView>
                    <div style="padding: 5px;" class ="acccount borderRadius">
                        <asp:Literal runat="server"  ID="lblAccidentDescirption" Text="!!!!!" />
                    </div>
                </div>
            </asp:Panel>
            <asp:Panel runat="server" ID="pnlPhoto" Visible="True">
                <asp:Image runat="server" ID="imgPhoto"
                    ImageUrl="~/handlers/getimage.ashx?id=3&storage=UserModulesAttachments.[user].[SAFETY_HISTORY_LOG]"
                    Style="width: auto; height: 1000px;" />
            </asp:Panel>
        </div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="

select * from
(select id, DEPARTMENT from usermodules.[user].SAFETY_HISTORY_LOG WHERE SHOW_IN_TOTAL = 'Y' )
src PIVOT (count(id) for DEPARTMENT in (
[VD production]
,[WM production]
,[Injection]
,[Finish Goods]
,[MM]
)) pvt
left join (
SELECT COUNT(*) -1  as [Total] FROM usermodules.[user].SAFETY_HISTORY_LOG WHERE SHOW_IN_TOTAL = 'Y'
) Ttl on 1=1"></asp:SqlDataSource>
        <asp:HiddenField runat="server" ID="hfWhatToShow" Value="photo" />
        <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <asp:Timer ID="Timer1" runat="server" Enabled="false" Interval="20000"></asp:Timer>
    </form>
</body>
</html>