How to populate Repeater with queries in each container?

Ask the community
, ,
1

I have a repeater that looks like this:

Per date is one container
Each 00000 has it’s own query.

964×370 32.1 KB

If I run my codes, the result looks like this:

931×476 41.1 KB

Some provide the correct answer, some container seems did not get the result.

What do you think is lacking?

function populateRepeater() {
    $w('#storeRepeater').onItemReady(($w, itemData) => {
        $w('#text536').text = itemData.deliveryDate; 
 
        wixData.query("delivery")
        .eq("storeId", $w('#storeSelect').value)
        .eq("description", "500 ml")
        .contains("deliveryDate",itemData.deliveryDate)
        .find()
        .then( (results) => {
 if(results.items.length > 0) {
 let firstItem = results.items[0];
 let dqty = firstItem.quantity/2;
              $w('#text542').text = "" + dqty;
              $w('#text592').text =  "₱  " + firstItem.amount.toLocaleString();

                    wixData.query("PullOut")
                    .eq("storeName", $w('#storeSelect').value).and(wixData.query("PullOut")
                    .eq("description", "500 ml"))
                    .eq("title", firstItem.title)
                    .find()
                    .then((result) => {
 if(result.items.length > 0) {
 let pullitem = result.items[0];
 let pqty = pullitem.quantity/2;
                            $w('#text594').text = "" + pqty;
                            $w('#text596').text = "₱  " + pullitem.amount.toLocaleString();
 let qty = (pqty/dqty)*100;
 let percentage = parseFloat(qty).toFixed(2);
                            $w('#text598').text = percentage + "%";
                        }  else {
                            $w('#text594').text = "0";
                            $w('#text596').text = "₱ 0";
                            $w('#text596').text = "0%";
                        }          
                    });
            } 
        } );

        wixData.query("delivery")
        .eq("storeId", $w('#storeSelect').value)
        .eq("description", "1 Liter")
        .contains("deliveryDate",itemData.deliveryDate)
        .find()
        .then( (results) => {
 if(results.items.length > 0) {
 let firstItem = results.items[0];
 let dqty = firstItem.quantity;
              $w('#text591').text = "" + dqty;
              $w('#text593').text =  "₱  " + firstItem.amount.toLocaleString();

                    wixData.query("PullOut")
                    .eq("storeName", $w('#storeSelect').value).and(wixData.query("PullOut")
                    .eq("description", "1 Liter"))
                    .eq("title", firstItem.title)
                    .find()
                    .then((result) => {
 if(result.items.length > 0) {
 let pullitem = result.items[0];
 let pqty = pullitem.quantity;
                            $w('#text595').text = "" + pqty;
                            $w('#text597').text = "₱  " + pullitem.amount.toLocaleString();
 let qty = (pqty/dqty)*100;
 let percentage = parseFloat(qty).toFixed(2);
                            $w('#text599').text = percentage + "%";
                        }  else {
                            $w('#text595').text = "0";
                            $w('#text597').text = "₱ 0";
                            $w('#text599').text = "0%";
                        }          
                    });
            } 
        } );

    });
}