ItemDetails_DelRow_Validation
Tue Jan 07 2025 15:31:27 GMT+0000 (Coordinated Universal Time)
Saved by @Pooja
aa = 0;
gt = 0;
it = 0;
for each vv in input.Item_Details
{
if(vv == row)
{
continue;
}
else
{
aa = aa + 1;
vv.S_No=aa;
gt = gt + ifnull(vv.Sub_Total,0);
it = it + ifnull(vv.Item_Total,0);
}
}
input.Gross_Total = gt;
input.Overall_Total = it;
for each recval in input.Delivery_Schedule
{
if(recval.Part_No == row.Part_Description)
{
recval.Part_No=null;
recval.Quantity=null;
recval.Delivery_Date=null;
}
}
itemlist = List();
qtyList = List();
dateList = List();
remarksList = List();
fullQtyList = List();
for each rec in input.Delivery_Schedule
{
if(rec.Part_No != null)
{
itemlist.add(rec.Part_No);
qtyList.add(rec.Quantity);
dateList.add(rec.Delivery_Date);
remarksList.add(rec.Remarks);
fullQtyList.add(rec.Full_Quantity);
}
}
input.Delivery_Schedule.clear();
i = 0;
s_no = 0;
for each items in itemlist
{
s_no = s_no + 1;
row1 = Purchase_Order.Delivery_Schedule();
row1.Part_No=items;
row1.S_No=s_no;
row1.Quantity=qtyList.get(i);
row1.Delivery_Date=dateList.get(i);
row1.Remarks=remarksList.get(i);
row1.Full_Quantity=fullQtyList.get(i);
input.Delivery_Schedule.insert(row1);
i = i + 1;
}
///
check_ven_map = 0;
check_ven_lis = List();
for each sub_val in input.Item_Details
{
if(sub_val.Part_No != row.Part_No)
{
check_vendor = Vendor_Contract_Subform[Vendor_Name == input.Vendor_Name && Part_Description == sub_val.Part_Description && Effective_From <= zoho.currentdate && Effective_To >= zoho.currentdate && sf_Status == "Active"];
if(check_vendor.count() == 0)
{
check_ven_lis.add(sub_val.Part_No.Part_No);
check_ven_map = 1;
}
}
}
if(check_ven_map == 1)
{
show asso_vendors;
create_tab = "<table border=1 Style ='color:#ff8b3b'><tr><th>S.No</th><th>Part No</th><th>Associated Vendor(s)</th></tr>";
sno = 1;
for each tab in check_ven_lis
{
ven_lis = List();
for each ven in Vendor_Contract_Subform[Part_Description.Part_No == tab && Effective_From <= zoho.currentdate && Effective_To >= zoho.currentdate && sf_Status == "Active"]
{
if(ven.Vendor_Name.Status == "Active")
{
ven_lis.add(ven.Vendor_Name.Vendor_Name);
}
}
create_tab = create_tab + "<tr><td>" + sno + "</td><td>" + tab + "</td><td>" + if(ven_lis.size() == 0,"<b>Not Associated</b>",ven_lis) + "</td></tr>";
sno = sno + 1;
}
create_tab = create_tab + "</table>";
str = "Selected Vendor <b>" + input.Vendor_Name.Vendor_Name + "</b> is not mapped against the following Item(s) : <br><br> " + create_tab;
input.asso_vendors = str;
Do_you_want_to_proceed_anyway = "";
Flag_for_Not_Associated_Vendors = true;
}
else
{
hide asso_vendors;
Flag_for_Not_Associated_Vendors = false;
}



Comments