Just for conformation that the loop is running twice, I added some console logs. It gave me the folllowing result:
itemObj1.productBcid = 9789353163150
first if ran successfully
Hook afterQuery for collection products result ignored! Expected hook result to resolve to an object with an ‘_id’ property, but got [Undefined]
Hook afterQuery for collection products result ignored! Expected hook result to resolve to an object with an ‘_id’ property, but got [Undefined]
itemObj1.productBcid = 9789353163150
second if ran successfully
Revised code:
import wixData from ‘wix-data’;
$w.onReady( function () {
$w(‘#input342’).focus();
});
export function input342_change(event) {
var invser
var newinvser
invser = parseInt($w(‘#invseries’).value);
$w(‘#dataset14’).setFilter(wixData.filter().eq(‘phone’, $w(‘#input342’).value));
newinvser = invser + 1;
$w(‘#input340’).value = ‘AAW’ + newinvser;
$w(‘#input1’).focus();
}
export function cancel1_click(event) {
$w(‘#id1’).value = “”;
$w(‘#an1’).value = “”;
$w(‘#hsn1’).value = “”;
$w(‘#qty1’).value = “”;
$w(‘#p1’).value = “”;
$w(‘#dp1’).value = “”;
$w(‘#da1’).value = “”;
$w(‘#na1’).value = “”;
$w(‘#tp1’).value = “”;
$w(‘#ta1’).value = “”;
$w(‘#netamt1’).value = “”;
($w(‘#dataset12’).setFilter(wixData.filter().eq(‘productBcid’, $w(‘#input1’).value)))
let itemObj = $w(“#dataset12”).getCurrentItem();
$w(“#dataset12”).setFieldValue(“qtyS”, itemObj.qtyS - 1);
$w(‘#dataset12’).save().then(() => { $w(‘#dataset12’).refresh(); });
$w(‘#input1’).focus()
}
export function input1_change(event) {
($w(‘#dataset12’).setFilter(wixData.filter().eq(‘productBcid’, $w(‘#input1’).value))).then(()=>{
let itemObj1 = $w(“#dataset12”).getCurrentItem();
$w(“#dataset12”).setFieldValue(“qtyS”, itemObj1.qtyS + 1);
console.log("itemObj1.productBcid = " + itemObj1.productBcid);
if ($w(‘#an1’).value === “”) {
$w(‘#id1’).value = itemObj1.productBcid;
$w(‘#an1’).value = itemObj1.name;
$w(‘#hsn1’).value = itemObj1.hsn;
$w(‘#p1’).value = itemObj1.price;
$w(‘#qty1’).value = $w(‘#mqty’).value;
$w(‘#dp1’).value = itemObj1.discount;
$w(‘#da1’).value = itemObj1.discnetamt;
$w(‘#na1’).value = itemObj1.netamt;
$w(“#tp1”).value = itemObj1.tax;
$w(‘#ta1’).value = itemObj1.taxamt;
$w(“#netamt1”).value = itemObj1.finalamt;
$w(‘#dataset12’).save();
newfield();
console.log(“first if ran successfully”);
}
else if ($w(‘#an2’).value === “”) {
$w(‘#id2’).value = itemObj1.productBcid;
$w(‘#an2’).value = itemObj1.name;
$w(‘#hsn2’).value = itemObj1.hsn;
$w(‘#p2’).value = itemObj1.price;
$w(‘#qty2’).value = $w(‘#mqty’).value;
$w(‘#dp2’).value = itemObj1.discount;
$w(‘#da2’).value = itemObj1.discnetamt;
$w(‘#na2’).value = itemObj1.netamt;
$w(“#tp2”).value = itemObj1.tax;
$w(‘#ta2’).value = itemObj1.taxamt;
$w(“#netamt2”).value = itemObj1.finalamt;
$w(‘#dataset12’).save();
newfield();
console.log(“second if ran successfully”)
}
else { }
})
}
function newfield () {
$w(‘#input1’).focus();
$w(‘#input1’).value = null ;
}