Mohammad Chowdhury

Thursday, July 25, 2024

Dyncraft_Barcode

As many of you are aware or are noticing, each sprint the scrum masters are planning a variety or projects/programs. As we presented a few weeks ago at our all-hands, we are doing our best to adjust but yet we have additional work coming at us from ITD Security team. Adjustments have been made and the Scrum masters are aware - please do what we can to get these requests groomed and worked as quickly as possible. Going forward, please only work on IR's that are P1 or P2, for the application team. All others will be planned during sprint planning. For Operations continue to focus as a first in first out process (FIFO) by priority (meaning P3's should be handled first). At this time, SR's will remain with a 10 day SLA. The management team continues to monitor the SR efforts so we can adjust based on customer asks. Overall this means that you need to focus on your sprint items, so we can support the business requests (SR/IR's) later in the sprints.

Text fields on the label: Date of programming, Truck Plant, Chassis #, Sequence number, Firmware Version, test result

Label should be triggered by DAVIE flashing process.

Label dimensions must fit within X by X.

DMB can transmit Chassis information.
Requirement on the drawing to have a removable label.

Notes:

Truck plant is the second character in the chassis number prefix. DAVIE has the two-character prefix in the chassis.

Spike needed with Joonbo- Options for triggering a label from DAVIE

Dependency - DAVIE backoffice needed before this story can be worked.

There will only be one printer and one flash station.

Order Type: ZCAS

USE [EWI_Admin]

/****** Object: StoredProcedure [dbo].[DynaSequencerFuelTank_PrintLabelK1] Script Date: 7/25/2024 4:32:46 PM ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

-- =============================================

-- Author: Brad Schmidt

-- Create date: 11/15/2019

-- Modified: 2.3.20 added import and print date cols, update print col

-- 2.5.20 move all changes from the testing script,

-- 10.28.20 split fuel side right was showing hydraulic for engraver field

-- -- IR749285 - Printer machine is changed from DYNMCKZ015 to DYNMCKZ017

-- Description: Prints single fuel tank label from EWI sequencer screen

-- NOTE: for split tanks if "A" postion is 1, Hydraulic tanks is 1st(left) and Fuel tanks is 2nd(right)

-- if "A" position is 2, its reversed, fuel 1st/left and hydro 2nd/right

-- =============================================

ALTER PROCEDURE [dbo].[DynaSequencerFuelTank_PrintLabelK1]

@id INT

BEGIN

SET NOCOUNT ON;

DECLARE @result BIT,

@Salvagnini VARCHAR(20),

@SalvagniniL2 VARCHAR(20),

@Seam VARCHAR(20),

@SeamL2 VARCHAR(20),

@LongSeam INT,

@Raw VARCHAR(20),

@RawL2 VARCHAR(20),

@Shell VARCHAR(20),

@ShellL2 VARCHAR(20),

@Assembly VARCHAR(25),

@Chassis VARCHAR(10),

@Sequence VARCHAR(10),

@Motoman VARCHAR(35),

@MotomanL2 VARCHAR(35),

@Engraver VARCHAR(40),

@EngraverL2 VARCHAR(40),

@TankType CHAR(1),

@Title VARCHAR(40),

@TitleL2 VARCHAR(40),

@EXP VARCHAR(200)

--@K2Fitting VARCHAR(40);

--SELECT @Salvagnini = seq.PartNumber

-- ,@SalvagniniL2 = seq.PartNumber

SELECT @Salvagnini = CASE

WHEN SUBSTRING(seq.PartNumber,4,1) = '0' THEN seq.PartNumber

WHEN SUBSTRING(seq.PartNumber,4,1) = '1' THEN CONCAT(seq.PartNumber, '_H')

WHEN SUBSTRING(seq.PartNumber,4,1) = '2' THEN seq.PartNumber

WHEN SUBSTRING(seq.PartNumber,4,1) = '3' THEN seq.PartNumber

ELSE 'NA'

END

,@SalvagniniL2 = CASE

WHEN SUBSTRING(seq.PartNumber,4,1) = '0' THEN seq.PartNumber

WHEN SUBSTRING(seq.PartNumber,4,1) = '1' THEN seq.PartNumber

WHEN SUBSTRING(seq.PartNumber,4,1) = '2' THEN CONCAT(seq.PartNumber, '_H')

WHEN SUBSTRING(seq.PartNumber,4,1) = '3' THEN seq.PartNumber

ELSE 'NA'

END

,@Seam = CASE ---check with tim if keep it the same...

WHEN SUBSTRING(seq.PartNumber,4,1) = '0' THEN CONCAT(kf.TankDiameter, '/L', kf.TankLength)

WHEN SUBSTRING(seq.PartNumber,4,1) = '1' THEN CONCAT(ksh.TankDiameter, '/L', ksh.TankLength)

WHEN SUBSTRING(seq.PartNumber,4,1) = '2' THEN CONCAT(ksf.TankDiameter, '/L', ksf.TankLength)

WHEN SUBSTRING(seq.PartNumber,4,1) = '3' THEN CONCAT(kh.TankDiameter, '/L', kh.TankLength)

ELSE 'NA'

END

,@LongSeam = CASE ---check with tim if keep it the same...

WHEN SUBSTRING(seq.PartNumber,4,1) = '0' THEN

--CONCAT(kf.TankDiameter, '/L', kf.TankLength)

(SELECT [LSWid] FROM [EWI_Admin].[dbo].[FuelTankLongSeam] WHERE [Diameter]=kf.TankDiameter AND [Length]=kf.TankLength)

WHEN SUBSTRING(seq.PartNumber,4,1) = '1' THEN

--CONCAT(ksh.TankDiameter, '/L', ksh.TankLength)

(SELECT [LSWid] FROM [EWI_Admin].[dbo].[FuelTankLongSeam] WHERE [Diameter]=ksh.TankDiameter AND [Length]=ksh.TankLength)

WHEN SUBSTRING(seq.PartNumber,4,1) = '2' THEN

--CONCAT(ksf.TankDiameter, '/L', ksf.TankLength)

(SELECT [LSWid] FROM [EWI_Admin].[dbo].[FuelTankLongSeam] WHERE [Diameter]=ksf.TankDiameter AND [Length]=ksf.TankLength)

WHEN SUBSTRING(seq.PartNumber,4,1) = '3' THEN

--CONCAT(kh.TankDiameter, '/L', kh.TankLength)

(SELECT [LSWid] FROM [EWI_Admin].[dbo].[FuelTankLongSeam] WHERE [Diameter]=kh.TankDiameter AND [Length]=kh.TankLength)

ELSE 'NA'

END

,@SeamL2 = CASE

WHEN SUBSTRING(seq.PartNumber,4,1) = '0' THEN NULL

WHEN SUBSTRING(seq.PartNumber,4,1) = '1' THEN CONCAT(ksf.TankDiameter, '/L', ksf.TankLength)

WHEN SUBSTRING(seq.PartNumber,4,1) = '2' THEN CONCAT(ksh.TankDiameter, '/L', ksh.TankLength)

WHEN SUBSTRING(seq.PartNumber,4,1) = '3' THEN NULL

ELSE 'NA'

END

,@Raw = CASE

WHEN SUBSTRING(seq.PartNumber,4,1) = '0' THEN kf.RawFamily

WHEN SUBSTRING(seq.PartNumber,4,1) = '1' THEN ksh.RawFamily

WHEN SUBSTRING(seq.PartNumber,4,1) = '2' THEN ksf.RawFamily

WHEN SUBSTRING(seq.PartNumber,4,1) = '3' THEN kh.RawFamily

ELSE 'NA'

END

,@RawL2 = CASE

WHEN SUBSTRING(seq.PartNumber,4,1) = '0' THEN NULL

WHEN SUBSTRING(seq.PartNumber,4,1) = '1' THEN ksf.RawFamily

WHEN SUBSTRING(seq.PartNumber,4,1) = '2' THEN ksh.RawFamily

WHEN SUBSTRING(seq.PartNumber,4,1) = '3' THEN NULL

ELSE 'NA'

END

,@Shell = 'NA'

,@Assembly = seq.PartNumber

,@Sequence = seq.SequenceNumber

,@Chassis = seq.ChassisNumber

--,@Motoman = seq.PartNumber ---confirm just want assembly instead of: CONCAT(RIGHT(' ' + CAST(ld.TankCapacity AS VARCHAR(3)), 3), '.F.', seq.PartNumber)

,@Motoman = CASE

WHEN SUBSTRING(seq.PartNumber,4,1) = '0' THEN seq.PartNumber

WHEN SUBSTRING(seq.PartNumber,4,1) = '1' THEN 'N/A'

WHEN SUBSTRING(seq.PartNumber,4,1) = '2' THEN seq.PartNumber

WHEN SUBSTRING(seq.PartNumber,4,1) = '3' THEN 'N/A'

ELSE 'NA'

END

,@MotomanL2 = CASE

WHEN SUBSTRING(seq.PartNumber,4,1) = '0' THEN seq.PartNumber

WHEN SUBSTRING(seq.PartNumber,4,1) = '1' THEN seq.PartNumber

WHEN SUBSTRING(seq.PartNumber,4,1) = '2' THEN 'N/A'

WHEN SUBSTRING(seq.PartNumber,4,1) = '3' THEN 'N/A'

ELSE 'NA'

END

,@Engraver = CASE

WHEN SUBSTRING(seq.PartNumber,4,1) = '0' THEN CONCAT(LEFT(CAST(kf.TankCapacity AS VARCHAR(3)) + ' ', 3), '.F .',seq.PartNumber)

WHEN SUBSTRING(seq.PartNumber,4,1) = '1' THEN CONCAT(ksh.TankCapacity, '.H .',seq.PartNumber)

WHEN SUBSTRING(seq.PartNumber,4,1) = '2' THEN CONCAT(LEFT(CAST(ksf.TankCapacity AS VARCHAR(3)) + ' ', 3), '.F .',seq.PartNumber)

WHEN SUBSTRING(seq.PartNumber,4,1) = '3' THEN CONCAT(kh.TankCapacity, '.H .',seq.PartNumber)

ELSE 'NA'

END

,@EngraverL2 = CASE

WHEN SUBSTRING(seq.PartNumber,4,1) = '0' THEN NULL

WHEN SUBSTRING(seq.PartNumber,4,1) = '1' THEN CONCAT(LEFT(CAST(ksf.TankCapacity AS VARCHAR(3)) + ' ', 3), '.F .',seq.PartNumber)

WHEN SUBSTRING(seq.PartNumber,4,1) = '2' THEN CONCAT(ksh.TankCapacity, '.H .',seq.PartNumber)

WHEN SUBSTRING(seq.PartNumber,4,1) = '3' THEN NULL

ELSE 'NA'

END

,@TankType = SUBSTRING(seq.PartNumber,4,1)

,@Title = CASE

WHEN SUBSTRING(seq.PartNumber,4,1) = '0' THEN 'FUEL'

WHEN SUBSTRING(seq.PartNumber,4,1) = '1' THEN 'SPLIT-HYDR(Left)'

WHEN SUBSTRING(seq.PartNumber,4,1) = '2' THEN 'SPLIT-FUEL(Left)'

WHEN SUBSTRING(seq.PartNumber,4,1) = '3' THEN 'HYDRAULIC'

ELSE 'NA'

END

,@TitleL2 = CASE

WHEN SUBSTRING(seq.PartNumber,4,1) = '0' THEN NULL

WHEN SUBSTRING(seq.PartNumber,4,1) = '1' THEN 'SPLIT-FUEL(Right)'

WHEN SUBSTRING(seq.PartNumber,4,1) = '2' THEN 'SPLIT-HYDR(Right)'

WHEN SUBSTRING(seq.PartNumber,4,1) = '3' THEN NULL

ELSE 'NA'

END

--EXP barcode for chassis, sequence, K1 part, and K2 fitting

,@EXP = CONCAT(seq.ChassisNumber,'.', seq.SequenceNumber,'.', seq.PartNumber,'.',ftpm.K2Part)

--,@K2Fitting = etaf.FittingPN

--,ksh.*

--,ksf.*

--,seq.*

FROM [EWI_Admin].[dbo].DynaSequencerFuelTank seq

LEFT JOIN [EWI_Admin].[dbo].DynaK1FuelTankRef kf

ON SUBSTRING(seq.PartNumber,4,1) = '0'

AND SUBSTRING(seq.PartNumber,5,1) = kf.Map

AND kf.[Option] = 'B'

LEFT JOIN [EWI_Admin].[dbo].DynaK1FuelTankRef ksh

ON SUBSTRING(seq.PartNumber,4,1) IN('1','2')

AND SUBSTRING(seq.PartNumber,12,1) = ksh.Map

AND ksh.[Option] = 'J'

LEFT JOIN [EWI_Admin].[dbo].DynaK1FuelTankRef ksf

ON SUBSTRING(seq.PartNumber,4,1) IN('1','2')

AND SUBSTRING(seq.PartNumber,5,1) = ksf.Map

AND ksf.[Option] = 'B'

LEFT JOIN [EWI_Admin].[dbo].DynaK1FuelTankRef kh

ON SUBSTRING(seq.PartNumber,4,1) = '3'

AND SUBSTRING(seq.PartNumber,5,1) = kh.Map

AND kh.[Option] = 'B'

--Tanks and fittings join for K2 part number

LEFT JOIN EWI_DataWarehouse.dbo.EXP_FuelTankPlumbingMatch AS ftpm

ON ftpm.K1Part = seq.PartNumber AND ftpm.MatchedLineSeqNbr = seq.SequenceNumber

WHERE seq.DynaSequencerFuelTankID = @id

IF (@Sequence IS NOT NULL)

BEGIN

--SELECT @Salvagnini Salvagnini,

-- @Seam Seam,

-- @Raw Raw,

-- @Shell Shell,

-- @Assembly [Assembly],

-- @Sequence [Sequence],

-- @Chassis Chassis,

-- @Motoman Motoman,

-- @Engraver Engraver,

-- @TankType TankType,

-- @Title Title,

-- @EXP [EXP]

DECLARE @FileName VARCHAR(MAX),

@FileText VARCHAR(MAX)

SET @FileName = CONCAT('\\DYNMCKMVPP1801\Bartender\Fuel_Tank\', @Chassis,'-',@Sequence,'-',@Assembly,'.ztt')

-- IR749285 - Printer machine is changed from DYNMCKZ015 to DYNMCKZ017

SET @FileText = CONCAT('%BTW% /AF=C:\Labels\AllTanks_DEV.btw /D=%Trigger File Name% /PRN="\\DYNMCKMVPP1801\DYNMCKZ017" /C=1 /R=003 /P',CHAR(13),CHAR(10),'%END%',CHAR(13),CHAR(10),---z017 is fuel by Mo

--SET @FileText = CONCAT('%BTW% /AF=C:\Labels\AllTanks.btw /D=%Trigger File Name% /PRN="\\DYNMCKMVPP1801\DYNMCKZ015" /C=1 /R=003 /P',CHAR(13),CHAR(10),'%END%',CHAR(13),CHAR(10),---z015 is fuel by Mo

--SET @FileText = CONCAT('%BTW% /AF=C:\Labels\AllTanks.btw /D=%Trigger File Name% /PRN="\\DYNMCKMVPP1801\DYNMCKZ023" /C=1 /R=003 /P',CHAR(13),CHAR(10),'%END%',CHAR(13),CHAR(10),---z023 is fab, far corner

--SELECT @filename [filename], @filetext filetext

------------------------------------------------

EXEC dbo.WriteToFile @FileName, @FileText;

------------------------------------------------

IF @TankType IN('1','2')

BEGIN

--SELECT @SalvagniniL2 SalvagniniL2,

-- @SeamL2 SeamL2,

-- @RawL2 RawL2,

-- @ShellL2 ShellL2,

-- @Assembly [Assembly],

-- @Sequence [Sequence],

-- @Chassis Chassis,

-- @MotomanL2 MotomanL2,

-- @EngraverL2 EngraverL2,

-- @TankType TankType,

-- @TitleL2 TitleL2,

-- @EXP [EXP]

SET @FileName = CONCAT('\\DYNMCKMVPP1801\Bartender\Fuel_Tank\', @Chassis,'-',@Sequence,'-',@Assembly,'-L2.ztt')

--SET @FileText = CONCAT('%BTW% /AF=C:\Labels\AllTanks.btw /D=%Trigger File Name% /PRN="\\DYNMCKMVPP1801\DYNMCKZ015" /C=1 /R=003 /P',CHAR(13),CHAR(10),'%END%',CHAR(13),CHAR(10),---z022 is by brandon, 15 is the one by fuel...

--SELECT @filename [filename], @filetext filetext

------------------------------------------------

EXEC dbo.WriteToFile @FileName, @FileText;

------------------------------------------------

END

UPDATE dbo.DynaSequencerFuelTank

SET IsLabelPrinted = 1,

PrintDate = GETDATE()

WHERE DynaSequencerFuelTankID = @id;

SET @result = 1;

END;

ELSE

BEGIN

SET @result = 0;

END;

--SELECT @result;

RETURN @result;

END;

Wednesday, February 28, 2024

UML /uml

The Unified Modeling Language (UML) is a graphical language for Object-Oriented Analysis and Design(OOAD) that gives a standard way to write a software system's blueprint. It helps to visualize, specify, construct, and document the artifacts of an object-oriented system

The UML uses mostly graphical notations to express the design of software projects. Using the UML helps project teams communicate, explore potential designs, and validate the architectural design of the software.

UML diagrams are used in software development and systems analysis to visually represent different aspects of a system or software application. UML diagrams provide a standardized way to communicate and document the structure, behavior, and interactions of the system.

There are several types of UML diagrams, each serving a specific purpose: 1. Use Case Diagram: Used to capture the interactions between users (actors) and the system. It visually represents the functional requirements of the system. 2. Class Diagram: Represents the structure of the system by showing the classes, their attributes, relationships, and methods. It helps in understanding the static structure of the system. 3. Sequence Diagram: Illustrates the interactions between objects or components in a chronological order. It shows the flow of messages between the objects and helps in understanding the dynamic behavior of the system. 4. Activity Diagram: Represents the flow of activities or processes within a system. It is useful for modeling business processes, workflow, or the behavior of a single use case. 5. State Machine Diagram: Demonstrates the different states and transitions of an object or system. It helps in modeling the behavior of an object or system that changes its state in response to events. 6. Component Diagram: Illustrates the physical components or modules of a system and their dependencies. It helps in understanding the software architecture and system structure. 7. Deployment Diagram: Represents the physical deployment of software components on hardware nodes. It shows how the software is distributed across different hardware devices. UML diagrams serve as visual communication tools that aid in understanding, designing, and documenting complex systems. They help in capturing requirements, designing solutions, and communicating ideas among stakeholders in a clear and concise manner.

Monday, February 12, 2024

Blazor

https://blazorhelpwebsite.com/ViewBlogPost/56

In this code snippet, `@onclick` is an attribute used in frameworks like Blazor or Razor Pages to define an event handler for the `onclick` event. The `()=>OnSearch()` part is a lambda expression that defines an anonymous function. In this case, it is used to call the `OnSearch()` method when the `onclick` event is triggered.

Thursday, December 28, 2023

Dyncraft MVC

https://paccar.service-now.com/now/nav/ui/classic/params/target/change_request.do%3Fsys_id%3Db497a552eb82d6501a95ffd6bad0cdb1%26sysparm_view%3Ddefault

**ADO User Story Refinement** refers to the process of reviewing, clarifying, and improving user stories within an Agile development framework, particularly in environments that use Azure DevOps (ADO) or similar tools. The goal of refinement is to ensure that user stories are well-defined, understood by the team, and ready for implementation in upcoming sprints or iterations.

EWI : Electronic Work Instruction

BOM: Build of Material

NCP:Non Conformance Part

TBD: To be Determind

AddTechnology.cshtml

In Agile methodologies, a "retro" (short for retrospective) is a meeting held at the end of a sprint or project phase where team members reflect on what went well, what didn't, and how processes can be improved for future iterations.

Technology.cshtml

ManageTechnology.cshtml

[Authorize(Roles = "SG-DYNLOU-UAM-DEV-Hose21mFittingVolume-Edit")]

EWI_ADMIN >_Navigation.js(Controllers\API\App_NavController.cs)

//Uri uri = new Uri(HttpContext.Current.Request.Url.AbsoluteUri);

Uri uri = new Uri("https://dynlou.na.paccar.com/EWI/DashBoard/DashBoard");

string host = uri.Scheme + Uri.SchemeDelimiter + uri.Host + ":" + uri.Port;

string host2 = "http://" + HttpContext.Current.Request.Url.Authority;

// string host3 = uri.Scheme + Uri.SchemeDelimiter + HttpContext.Current.Request.Url.Authority;

EWI_ADMIN >_Navigation.js(\Scripts\PageScripts\_Navigation.js)

let url = location.href;

let prefix = url.includes('/EWI/') ? '/EWI' : '';

var appuri = prefix + '/Controllers/API/App_Nav/AppNav'

var reporturi = prefix + '/Controllers/API/App_Nav/ReportNav'

var opsuri = prefix + '/Controllers/API/App_Nav/OpsNav'

var produri = prefix + '/Controllers/API/App_Nav/ProdNav'

var areasetupuri = prefix + '/Controllers/API/App_Nav/AreaSetupNav'

পদ্ধতি ১: window.location ব্যবহার করে

// বর্তমান হোস্ট থেকে ডাইনামিক URL তৈরি

var host = window.location.host; // উদাহরণ: localhost:5000 বা www.example.com

var protocol = window.location.protocol; // উদাহরণ: http: বা https:

var uriOrderTypes = protocol + '//' + host + '/DashBoard/DashPlantOrderType';
console.log(uriOrderTypes);

✔ এই কোডে:

Localhost হলে http://localhost:5000/DashBoard/DashPlantOrderType
Production হলে https://www.example.com/DashBoard/DashPlantOrderType
পদ্ধতি ২: Environment Variable ব্যবহার করে

[HttpPost] //SG-DYNLOU-EWI-Admins

//[Authorize(Roles = "Administrator, PowerUser")]

[Authorize(Roles = "SG-DYNLOU-UAM-DEV-EWI_Assembly-ADMIN-MasterAssemblies-Edit")]

//[Authorize(Roles = "SG-DYNLOU-EWI-Admins")]

--------------

[OutputCache(Duration = 0)]

// [Authorize(Roles = "SG-DYNLOU-UAM-DEV-EWI_Assembly-ADMIN-MasterAssemblies-Edit")]

[Authorize(Roles = "SG-DYNLOU-EWI-Admins")]

Read Active User AD:

WindowsIdentity identity = WindowsIdentity.GetCurrent();

string username = identity.Name; // This will give you the domain and username (e.g., DOMAIN\username)

Console.WriteLine($"Current User: {username}");

// Optional: If you want just the username without the domain

string[] parts = username.Split('\\');

string samAccountName = parts.Length > 1 ? parts[1] : username;

Mohammad Chowdhury

Thursday, July 25, 2024

Dyncraft_Barcode

Wednesday, February 28, 2024

UML /uml

Monday, February 12, 2024

Blazor

Thursday, December 28, 2023

Dyncraft MVC

Docker

Report Abuse