code for interactive grid to get data

PHOTO EMBED

Thu Jan 27 2022 07:00:10 GMT+0000 (Coordinated Universal Time)

Saved by @ahsankhan007

var htmldb_delete_message='"DELETE_CONFIRM_MSG


(function($){
    function update(model){
        var amt = model.getFieldKey("QTY1"),
            custAmt = model.getFieldKey("RATE"),
            total = 0;
        model.forEach(function(record, index, id){
           var v_amt = record[amt],
               v_custAmt = record[custAmt],
               meta = model.getRecordMetadata(id);
           var all_v_amt = Number(v_amt.replace(/,/g, ''));
           var all_v_custAmt = Number(v_custAmt.replace(/,/g, ''));  
                
           if(!isNaN(all_v_amt, all_v_custAmt) && !meta.deleted && !meta.agg){
              total += all_v_amt * all_v_custAmt;
           }
        });
        var all_total = total.toFixed(2); 
        console.log('>>', all_total);
        $s('P11201_GROSS_TOTAL', all_total);
        $s('P11201_GROSS_TOTAL_PAY', all_total);
        $s('P11201_NET', all_total);
        $s('P11201_NET_PAY', all_total);
}
$(function(){
        $("#invDtl").on("interactivegridviewmodelcreate", function(event, ui) {
            var sid,
            model = ui.model;
            if ( ui.viewId === "grid" ){
                sid = model.subscribe({
                    onChange: function(type, change){
                        if(type === "set"){
                            if(change.field === "QTY1"){
                                update(model);
                            }else if(change.field === "RATE"){
                                update(model);
                            }
                        }else if(type !== "move" && type !== "metaChange"){
                            update(model);
                        }
                    },
                    progressView: $("#P11201_GROSS_TOTAL")
                });
                update(model);
                model.fetchAll(function() {});
            }
        });
    });
})(apex.jQuery);




content_copyCOPY