ModuleMaster/production/capa.aspx - main - ivan/ModMas

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

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Production status</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 {
            height: 7%;
            font-size: 20pt;
        }
        .remark {
            font-size: 20pt !important;
        }
        .time {
            font-size: 40pt !important;
        }
        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;
		}
    
    </style>
</head>
<body>
    <form id="form1" runat="server">
        <div>
<%-- 
FITST TABLE
-------------------------------------------------------------------------------------------------------                
-------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
--%>
            <table>
                <tr>
                    <td>
                        <asp:Label ID="sop" runat="server" Text="SOP version: "></asp:Label>
                    </td>
                    <td>
                        <asp:Label ID="tt" runat="server" Text="Tacktime uploaded: "></asp:Label>
                    </td>
                </tr>
            </table>

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

            <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 DataField="year" Visible="true"  HeaderText="Year" />
                      <asp:BoundField DataField="Model" Visible="true" HeaderText="Model"/>
                      <asp:BoundField DataField="Planner's TackTime" Visible="true" HeaderText="Planner's TackTime"/>
                      <asp:BoundField DataField="Line" Visible="true" HeaderText="Line"/>
                      <asp:BoundField DataField="Catalog Capa" Visible="true" HeaderText="Catalog Capa"/>
                      <asp:BoundField DataField="Catalog TackTime" Visible="true" HeaderText="Catalog TackTime"/>
                      <asp:BoundField DataField="Upload date" Visible="true" HeaderText="Upload date"/>
                      <%--<asp:BoundField DataField="Flag" Visible="true" HeaderText="Flag"/>--%>

                  </Columns>


        </asp:GridView>
                   

            
            <asp:SqlDataSource ID="queue" runat="server" ConnectionString="<%$ ConnectionStrings:CATVConnectionString %>" SelectCommand="
select 
model_year as [year]
,model as Model
,cast(pc.TT as decimal(20,2)) as [Planner's TackTime]
,LINE
,v1 as [Catalog Capa]
,cast(v2 as decimal(20,2)) as [Catalog TackTime]
,CREATE_DATE as [Upload date]
--, case
--  when exists 
--		(
--		select distinct material, plan_id
--		from [UserModules].[user].[SOP_FLUCTUATION]
--		where plan_id =
--			(
--				select distinct top 1 plan_id
--				from [UserModules].[user].[SOP_FLUCTUATION]
--				order by plan_id desc
--			)
--		and CURWEEK &lt;&gt; 0
--		and material not in (select product from [UserModules].[user].[PRODUCTION_TT])
--		and material = model
--		)
--	then 'N'
--	else 'Y'
--end as Flag


from [UserModules].[user].[PLANNING_TT] as PC

left join
(


	select capa.product, replace(v1, ',','.') as v1, capa, replace(v2,',','.') as v2, tt
	from (
		select *
		from [UserModules].[user].[PRODUCTION_TT]
		) capa
	unpivot (v1 for capa in (M01_capa, M03_capa, M04_capa, M05_capa, M07_capa, M08_capa)) as capa

	left join
	(
		select product,  v2, tt
		from (
			select *
			from [UserModules].[user].[PRODUCTION_TT]
			) p
		unpivot (v2 for tt in (M01_tt, M03_tt, M04_tt, M05_tt, M07_tt, M08_tt)) as unp
	) tt
	on capa.product = tt.PRODUCT and left(capa.capa,3) = left(tt.tt,3)
	where capa.product in (select model from [UserModules].[user].[PLANNING_TT] where cast(CREATE_DATE as date) = (select max(cast(create_date as date)) from [UserModules].[user].[PLANNING_TT]))
	and v1 &lt;&gt; '' and v2 &lt;&gt; '' and v1 is not null and v2 is not null
) as p
on pc.model = p.PRODUCT and pc.line = left(p.tt,3) collate Cyrillic_General_CI_AI

left join [UserModules].[user].[PRODUCTION_TT] m_y
on pc.MODEL = m_y.PRODUCT

"></asp:SqlDataSource>
        </div>
         <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>

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