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;