Hourly QC onLoad
Thu Jan 16 2025 05:12:22 GMT+0000 (Coordinated Universal Time)
Saved by @Nisha
hide Hourly_Production_Balance;
hide Hourly_Production_Done_Qty;
disable MRP_Actual_Qty;
if(Release_Production_wo_recid != null && Form_Mode == "Create")
{
input.Hourly_Quality_ID = input.ID;
input.Actual_Date = zoho.currentdate;
relprdsf = Release_Production_workorder_subform[Release_Production_wo_existid == input.Release_Production_wo_recid] sort by Production_Sequence_No asc;
relprdmain = Release_Production_workorder[ID == input.Release_Production_wo_recid];
fet_hour_prod = Hourly_Production_Process[Release_Production_wo_mainid == relprdmain.ID] sort by Production_Sequence_No asc;
fet_prodsub = Hourly_Production_Process_Subform[Hourly_Production_Report_RECID == fet_hour_prod.ID];
//hour_prodsub1 = Hourly_Production_Process_Subform[Hourly_Production_Report_RECID == fet_hour_prod.ID].sum(Actual_Qty);
if(input.Line.Department != "Raw Material")
{
input.MRP_No = relprdmain.MRP_No;
}
input.Shift = fet_hour_prod.Shift;
//input.Start_Time = fet_hour_prod.Start_Time;
//input.End_Time = fet_hour_prod.End_Time;
input.Hourly_QC_Date = zoho.currentdate;
input.Production_Date = relprdmain.Production_Date;
input.Actual_Production_Date = fet_hour_prod.Actual_Date;
disable Actual_Production_Date;
//input.Production_Date = fet_hour_prod.Actual_Date;
input.Line = relprdsf.Production_Department;
input.Work_Order_No = ifnull(relprdmain.Work_Order_No,"");
input.Production_workorder = ifnull(relprdmain.ID,"");
input.Production_Sequence_No = ifnull(relprdmain.Production_Sequence_No,"");
input.Part_No1:ui.add(relprdsf.Part_No.getall());
input.Part_Name1:ui.add(relprdsf.Part_Name.getall());
//input.Actual_Qty = fet_hour_prod.Total_Completed_Qty;
input.MRP_Block_Qty = ifnull(relprdmain.MRP_Block_Qty,0);
input.MRP_Actual_Qty = ifnull(relprdmain.MRP_Actual_Qty,0);
input.Actual_Qty = ifnull(relprdmain.Actual_Qty,0.0);
//input.Actual_Qty = ifnull(relprdmain.MRP_Actual_Qty,0);
input.Hourly_Production_Done_Qty = ifnull(relprdmain.Actual_Qty,0);
input.Hourly_Production_Balance = ifnull(relprdmain.Balance_Production_Qty,0);
if(zoho.loginuserid == "admin@carrierwheels.com")
{
show Hourly_Production_Balance;
show Hourly_Production_Done_Qty;
}
hourqc = Hourly_Quality_Report[Release_Production_wo_recid == input.Release_Production_wo_recid && Hourly_Production_Done_Qty > 0 && Hourly_Production_Balance > 0] sort by Added_Time desc;
//info hourqc.ID +"-----HHHH";
if(hourqc.count() > 0 && hourqc.Do_you_want_to_Complete_QC_fully == true || hourqc.Do_you_want_to_Complete_QC_fully == false)
{
input.Hourly_QC_Completed_Qty = ifnull(hourqc.Hourly_Production_Done_Qty,0);
newactual = ifnull(relprdmain.Actual_Qty,0) - ifnull(hourqc.Hourly_Production_Done_Qty,0);
//info newactual;
input.Actual_Qty = ifnull(newactual,0);
}
fet_hourqc = Hourly_Quality_Report[Release_Production_wo_recid == input.Release_Production_wo_recid].sum(Total_Complete_Qty);
if(fet_hourqc > 0)
{
input.Actual_Qty_sofar = ifnull(fet_hourqc,0);
hide No_Defects;
}
else
{
show No_Defects;
}
//info input.Actual_Qty_sofar;
input.Balance_Qty = ifnull(input.Actual_Qty,0) - ifnull(input.Actual_Qty_sofar,0);
input.Planned_Qty = input.MRP_No.MRP_Qty;
input.Quality_supervisor = Employee_Details[Employee_Email == zoho.loginuserid].ID;
input.Inspector_Name = Employee_Details[Employee_Email == zoho.loginuserid].ID;
input.Production_Supervisor_Name = Employee_Details[Employee_Email == zoho.loginuserid].ID;
//input.Actual_Qty = input.MRP_No.MRP_Qty;
gettotqty = Hourly_Quality_Report[Work_Order_No == input.Work_Order_No && Production_workorder == input.Production_workorder && Line == input.Line].sum(Total_Complete_Qty);
//input.Total_Complete_Qty = gettotqty;
// if(relprdmain.Planned_Date == null)
// {
// input.Planned_Date = Confirm_Release_Production[Work_Order_No == input.Work_Order_No].Added_Time;
// }
// else
// {
// input.Planned_Date = ifnull(relprdmain.Planned_Date,"");
// }
// if(relprdmain.Production_Date != null)
// {
// input.Production_Date = relprdmain.Production_Date;
// }
partnolist = List();
partnalist = List();
for each relprec in relprdsf
{
partnolist.add(relprec.Part_No);
partnalist.add(relprec.Part_Name);
}
input.Part_No1 = partnolist;
input.Part_Name1 = partnalist;
if(input.Line.Department == "Raw Material")
{
hide Specifications.Type_field;
hide Specifications.hr1;
hide Specifications.hr2;
hide Specifications.hr3;
hide Specifications.hr4;
hide Specifications.hr5;
hide Specifications.hr6;
hide Specifications.hr7;
hide Specifications.hr8;
hide Specifications.hr9;
hide Specifications.hr10;
hide Specifications.hr11;
hide Specifications.hr12;
hide Specifications.Process;
show Specifications.Start_Date;
show Specifications.End_Date;
}
if(input.Line.Department != "Raw Material")
{
hide Specifications.Start_Date;
hide Specifications.End_Date;
}
//__________________________________________________________________________________
// fet_qc = QC_Department_Master[Production_Department == input.Line];
// fet_def = Defects_Master[QC_Department == fet_qc.ID] sort by Prority asc;
// if(input.Line.Department != "Raw Material")
// {
// i = 0;
// insrow = Hourly_Quality_Report.Specifications();
// for each ins in fet_def
// {
// i = i + 1;
// insrow.S_No=i;
// insrow.Defects=ins.ID;
// insrow.Process=ins.Process;
// insrow.Type_field=ins.ID;
// insrow.Planned_Qty=relprdmain.MRP_No.MRP_Qty;
// col = Collection();
// col.insert(insrow);
// input.Specifications.insert(col);
// }
// }
// else if(input.Line.Department == "Raw Material")
// {
// hoursfrow = Hourly_Quality_Report.Specifications();
// //show Hourly_Production_Details.Production_Date;
// hoursfrow.S_No=1;
// hoursfrow.Start_Date=zoho.currentdate;
// hoursfrow.End_Date=zoho.currentdate;
// hoursfrow.Planned_Qty=relprdmain.MRP_No.MRP_Qty;
// hoursfcol = Collection();
// hoursfcol.insert(hoursfrow);
// input.Specifications.insert(hoursfcol);
// }
}
//--------------------------------------------------------------------------------------------------------------------------------
gethour = Hourly_Quality_Report[Work_Order_No == input.Work_Order_No && Line == input.Line && Production_workorder == input.Production_workorder && Status == "Hourly QC Partially Completed"];
if(gethour.count() == 0)
{
hide plain1;
}
if(gethour.count() > 0)
{
show plain1;
history = "<table border=1 Style ='color:#2186EA;border-collapse:collapse;'><tr border=1><th>S.No</th><th>Actual Date</th><th>From Time</th><th>To time</th><th>Defect Type</th><th>Department</th><th>Defects</th><th>Qty</th><th>Remarks</th></tr>";
sno = 0;
totqty = 0;
for each rec in gethour
{
//info gethour +"qc";
hqrsub = Hourly_Quality_Subform[Exists_ID == rec.ID];
//&& Defect_Type != "No Defects"
for each fullsub in hqrsub
{
// info "for";
totqty = totqty + ifnull(fullsub.Actual_Qty,0);
hqccc = Hourly_Quality_Report[ID == fullsub.Exists_ID];
sno = sno + 1;
if(fullsub.Defect_Type == "Rejected")
{
// info "if";
history = history + "<tr style ='color: #ff6666;'><td>" + ifnull(sno,"") + "</td> <td>" + ifnull(hqccc.Actual_Date,"") + "</td><td>" + ifnull(fullsub.From_Time.toString(),"") + "</td><td>" + ifnull(fullsub.To_Time.toString(),"") + "</td><td>" + ifnull(fullsub.Defect_Type,"") + "</td><td>" + ifnull(fullsub.Department.Department,"") + "</td><td>" + ifnull(fullsub.Defects.Defects,"") + "</td> <td>" + ifnull(fullsub.Actual_Qty,0) + "</td> <td>" + ifnull(fullsub.Remarks,"") + "</td></tr>";
}
else if(fullsub.Defect_Type == "Rework" || fullsub.Defect_Type == "COD" || fullsub.Defect_Type == "No Defects")
{
//info "else";
history = history + "<tr><td>" + ifnull(sno,"") + "</td> <td>" + ifnull(hqccc.Actual_Date,"") + "</td><td>" + ifnull(fullsub.From_Time.toString(),"") + "</td><td>" + ifnull(fullsub.To_Time.toString(),"") + "</td><td>" + ifnull(fullsub.Defect_Type,"") + "</td><td>" + ifnull(fullsub.Department.Department,"") + "</td><td>" + ifnull(fullsub.Defects.Defects,"") + "</td> <td>" + ifnull(fullsub.Actual_Qty,0) + "</td> <td>" + ifnull(fullsub.Remarks,"") + "</td></tr>";
}
input.plain1 = history;
}
}
}
input.Actual_Qty_sofar = totqty;
Comments