User input-Defect Type
Thu Jan 16 2025 05:13:57 GMT+0000 (Coordinated Universal Time)
Saved by @Nisha
gethourdata = Hourly_Quality_Report[Release_Production_wo_recid == input.Release_Production_wo_recid].sum(Total_Complete_Qty);
hourdata = Hourly_Quality_Report[Release_Production_wo_recid == input.Release_Production_wo_recid];
hourdatanew = Hourly_Quality_Report[Release_Production_wo_recid == input.Release_Production_wo_recid] sort by Added_Time desc;
for each rec in input.Specifications
{
if(row.Defect_Type = "No Defects" && row.S_No == 1 && hourdatanew.Status == null)
{
input.Total_OK_Qty = ifnull(input.Actual_Qty,0);
}
if(row.Defect_Type = "No Defects" && row.S_No == 1 && hourdatanew.Status == "Hourly QC Partially Completed")
{
//input.Total_OK_Qty = ifnull(hourdatanew.Total_OK_Qty,0);
input.Total_OK_Qty = ifnull(input.Actual_Qty,0);
}
if(row.Defect_Type = "No Defects")
{
if(hourdata.count() == 0)
{
row.Actual_Qty=null;
}
//input.Total_OK_Qty = ifnull(input.Actual_Qty,0);
disable row.Defects;
disable row.Actual_Qty;
}
else
{
enable row.Defects;
enable row.Actual_Qty;
}
/* if(rec.Defect_Type = "No Defects")
{
if(hourdata.count() == 0)
{
//rec.Actual_Qty=ifnull(input.Actual_Qty,0);
rec.Actual_Qty=null;
}
else if(hourdata.count() > 0)
{
rec.Actual_Qty=ifnull(input.Actual_Qty,0) - ifnull(gethourdata,0);
}
input.Do_you_want_to_Complete_QC_fully = True;
//input.Total_OK_Qty = ifnull(input.Actual_Qty,0);
disable row.Defects;
disable row.Actual_Qty;
} */
// if(hourdata.count() == 0 || hourdata.count() > 0 && row.Defect_Type == "No Defects")
// {
// alert "You can only choose No Defects, If the above rows not choosed as Reject/Rework/COD";
// row.Defect_Type=null;
// row.Actual_Qty=null;
// input.Do_you_want_to_Complete_QC_fully = null;
// }
// else
// {
// input.Do_you_want_to_Complete_QC_fully = False;
// enable row.Actual_Qty;
// enable row.Defects;
// }
}
if(row.Defect_Type != "COD")
{
fet_qc = QC_Department_Master[Production_Department == input.Line];
fet_def = Defects_Master[QC_Department == fet_qc.ID && Defect_Type == row.Defect_Type].ID.getAll();
row.Defects:ui.add(fet_def);
}
//---If COD choosen & ,Department RIM / Disc means show all Raw material defects & if Assembly Means show All defects Raw+Rim+Disc Defects-------------
if(row.Defect_Type == "COD")
{
//info"cod";
if(row.Department.Department == "Front Rim Line" || row.Department.Department == "Rear Rim Line" || row.Department.Department == "Front Disc Line" || row.Department.Department == "Rear Disc Line")
{
//info "---" + row.Department.Department;
//fet_qc = QC_Department_Master[Production_Department.Department == "Raw Material"];
fet_def1 = Defects_Master[QC_Department.QC_Department == "Raw Material"].ID.getAll();
info fet_def1;
row.Defects:ui.add(fet_def1);
}
else if(row.Department.Department == "Front Assembly" || row.Department.Department == "Rear Assembly" || row.Department.Department == "Rear Lug Welding" || row.Department.Department == "Front Lug Welding")
{
//info "--Assebly--" + row.Department.Department;
//fet_qc = QC_Department_Master[Production_Department.Department == "Raw Material"];
fet_def2 = Defects_Master[QC_Department.QC_Department == "Raw Material" || QC_Department.QC_Department == "Rim Line" || QC_Department.QC_Department == "Disc Line"].ID.getAll();
//info fet_def2;
row.Defects:ui.add(fet_def2);
/* raw = List();
rim =List();
disc = List();
fet_def3 = Defects_Master[QC_Department.QC_Department == "Raw Material" ].ID.getAll();
fet_def4 = Defects_Master[QC_Department.QC_Department == "Rim Line" ].ID.getAll();
fet_def5 = Defects_Master[QC_Department.QC_Department == "Disc Line" ].ID.getAll();
row.Defects:ui.add(fet_def3);
row.Defects:ui.add(fet_def4);
row.Defects:ui.add(fet_def5); */
}
}
//-----------------------COLOUR Change Option-------------
// if(row.Defect_Type == "Rejected")
// {
// css = "<style>";
// //css = css + "#zc-BoM_Details_CWPL-S_No {background : red;}";
// //css = css + "#s2id_autogen39 {background : red;}";
// // css = css + "#zc-BoM_Details_CWPL-Level {background : #ff3333;}";
// //
// css = css + "#zc-Specifications {background : #ff3333;}";
// css = css + ".zc-Specifications-S_No {background : #ff3333;}";
// css = css + ".zc-Specifications-From_Time {background : #ff3333;}";
// css = css + ".zc-Specifications-To_Time {background : #ff3333;}";
// css = css + ".zc-Specifications-Defect_Type {background : #ff3333;}";
// css = css + ".zc-Specifications-Actual_Qty {background : #ff3333;}";
// css = css + ".zc-Specifications-Defects {background : #ff3333;}";
// css = css + ".zc-Specifications-Department {background : #ff3333;}";
// css = css + ".zc-Specifications-Remarks {background : #ff3333;}";
// css = css + ".zc-BoM_Details_CWPL-S_No {background : #ff3333;}";
// css = css + "</style>";
// input.plain2 = css;
// }
// else
// {
// css1 = "<style>";
// css1 = css1 + "#zc-Specifications {background : #ffffff;}";
// css1 = css1 + "</style>";
// input.plain2 = css1;
// }



Comments