ModuleMaster/elc/cushion_status.aspx - main - ivan/ModMas

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

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Cushion dashboard</title>
    <script src="../Scripts/jquery-1.9.1.min.js"></script>
    <script src="../Scripts/bootstrap.js"></script>
    <script src="../Scripts/popover.js"></script>

    <style>
        #blink {
                -webkit-animation: blink 2s linear infinite;
                  animation: blink 2s linear infinite;
                }
                @-webkit-keyframes blink {
                  50% { color: rgb(255, 0, 0); }
                 }        
                @keyframes blink {
                  50% { color: rgb(255, 0, 0); }
                }
        @font-face {
            font-family: "Agency FB";
            src: url('../fonts/AGENCYB.TTF');
        }
        html, body, form {
            width: 100%;
            height: 100%;
            background-color: transparent;
            font-family: 'Agency FB', 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            font-size: 18pt !important;
            margin: 0;
        }
        table {
            width: 100%;
            height: 100%;
            text-align : center;
        }
        #report td {
            width: 9%;
            font-size: 22pt;
        }
        th{
            background-color: steelblue;
            color: white;
            font-size: 26pt;
        }

         .footer td{
            background-color: steelblue;
            color: white;
            font-size: 26pt;
        }

        caption
		{
			color: White;
			font-weight: bold;
			background-color: DarkGray;
		}
        .header{
            background-color: navy;
            color: white;
        }


        .simplepopup
		{
			background-color: Navy;
			color: White;
		}
		
		.tooltip
		{
			position: absolute;
			z-index: 1030;
			display: block;
			font-size: 12px;
			line-height: 1.4;
			visibility: visible;
			max-width: 1100px !important;
		}
		
		.tooltip-inner
		{
			max-width: 1000px;
			padding: 3px 8px;
			color: #000000;
			text-align: center;
			text-decoration: none;
			background-color: White;
			border-radius: 4px;
		}


        .detailTable td{
            font-size: 18pt !important;
        }




    </style>
</head>
<body>
    <form id="form1" runat="server">
        <div>
<%-- 
FITST TABLE
-------------------------------------------------------------------------------------------------------                
-------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
--%>


              <asp:GridView ID="report" runat="server" CellPadding="4" ForeColor="#333333"
            Style="margin: 0 auto;" AutoGenerateColumns="False" HorizontalAlign="Center">

            <AlternatingRowStyle BackColor="White" />
            <EditRowStyle BackColor="#2461BF" />
            <EmptyDataRowStyle BackColor="Red" />
            <FooterStyle BackColor="#229EE5" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#229EE5" Font-Bold="True" ForeColor="White" />
            <PagerSettings Mode="NumericFirstLast" PageButtonCount="5" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#EFF3FB" HorizontalAlign="Center" VerticalAlign="Middle" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#F5F7FB" />
            <SortedAscendingHeaderStyle BackColor="#6D95E1" />
            <SortedDescendingCellStyle BackColor="#E9EBEF" />
            <SortedDescendingHeaderStyle BackColor="#4870BE" />
            <Columns>
                <asp:BoundField HeaderText="Type" DataField="Type" />
                <asp:BoundField HeaderText="Line" DataField="Line" />
                <asp:BoundField HeaderText="Model" DataField="Model" />
                <asp:BoundField HeaderText="Material" DataField="Material" />
                <asp:BoundField HeaderText="Plan start" DataField="plan_start" />
                <asp:BoundField HeaderText="Plan end" DataField="plan_end" />
                <asp:BoundField HeaderText="Acrual start" DataField="actual_start" />
                <asp:BoundField HeaderText="Actual end" DataField="actual_end" />
                <asp:BoundField HeaderText="plan" DataField="plan" />
                <asp:BoundField HeaderText="target" DataField="target" />
                <asp:BoundField HeaderText="prod" DataField="prod" />


            </Columns>
        </asp:GridView>
                   

            
            <asp:SqlDataSource ID="sdsPlanStatus" runat="server" ConnectionString="<%$ ConnectionStrings:CATVConnectionString %>" SelectCommand="
select 
case when line &lt;&gt; 'W' then 'TV'
else 'WM'
end as [type]
,[line]
,[material]
,[model]
, SUBSTRING([plan start], 1,2) + ':' + SUBSTRING([plan start], 3,2) + ':00' as plan_start
, SUBSTRING([plan end], 1,2) + ':' + SUBSTRING([plan end], 3,2) + ':00' as plan_end
,case 
	when (len([Actual start]) &gt; 1) then SUBSTRING([Actual start], 1,2) + ':' + SUBSTRING([Actual start], 3,2) + ':00'
	else [Actual start]
end  as actual_start
,case 
	when (len([Actual end]) &gt; 1) then SUBSTRING([Actual end], 1,2) + ':' + SUBSTRING([Actual end], 3,2) + ':00'
	else [Actual end]
end  as actual_end
,[Actual end] as actual_end
,[plan]
,[target]
,[Prod]
,[CURRENT_PROD]
,[po]
from [CATV].[dbo].[TB_CATV_MAIN_LINE_DETAILS]
left join [usermodules].[user].[PICK_LIST_MAIN_LINE] 
on cast([CATV].[dbo].[TB_CATV_MAIN_LINE_DETAILS].[po] as numeric ) = cast([usermodules].[user].[PICK_LIST_MAIN_LINE].[order] as numeric)
where WORK_DATE = cast(getdate() as date)
and [MRP_CONTR] = 'J03'
order by line, model, [plan start], [plan end]
"></asp:SqlDataSource>
        </div>
        

        <script type="text/javascript">
			$(document).ready(function () {
				$("[data-toggle=popover]").popover();
				$("[data-toggle=tooltip]").tooltip();
				//startTime();
			});
		</script>

        <asp:Timer ID="Timer1" runat="server" Interval="60000">
        </asp:Timer>
         <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>

    </form>
</body>
</html>