How to subtract date?

Denmark_Del_Puso · February 8, 2018, 7:12am

yes ill try but cant get the result

magic-overflow · February 8, 2018, 7:13am

is there any message in browser console?

Denmark_Del_Puso · February 8, 2018, 7:15am

no message but the result like this when i save.

magic-overflow · February 8, 2018, 7:23am

I know the problem. the child in payment reference is added automatically. I will let you know later.

Denmark_Del_Puso · February 8, 2018, 7:24am

ok ill wait thanks @magic-overflow

magic-overflow · February 8, 2018, 7:44am

It will calculate different day and assign to no_of_days_fr_delivery before the form Payment Entry save. After form saved, you can see the diff date.

 frappe.ui.form.on("Payment Entry", {
            validate: function(frm) {
               $.each(frm.doc.references || [], function(i, d) {
                    var diff_day = frappe.datetime.get_diff(d.due_date, frm.doc.posting_date);
                    frappe.model.set_value(d.doctype, d.name, "no_of_days_fr_delivery", diff_day);
               });
            }
        });

magic-overflow · February 8, 2018, 7:55am

if you want to see diff day before form Payment Entry save, you may consider to change the core.

github.com

frappe/erpnext/blob/152bf37e7fddaf7f2902d52225ca555b79f069a3/erpnext/accounts/doctype/payment_entry/payment_entry.js#L507


      
          					"payment_type": frm.doc.payment_type,
          					"party": frm.doc.party,
          					"party_account": frm.doc.payment_type=="Receive" ? frm.doc.paid_from : frm.doc.paid_to
          				}
          			},
          			callback: function(r, rt) {
          				if(r.message) {
          					var total_positive_outstanding = 0;
          					var total_negative_outstanding = 0;
          
          					$.each(r.message, function(i, d) {
          						var c = frm.add_child("references");
          						c.reference_doctype = d.voucher_type;
          						c.reference_name = d.voucher_no;
          						c.due_date = d.due_date
          						c.total_amount = d.invoice_amount;
          						c.outstanding_amount = d.outstanding_amount;
          						c.bill_no = d.bill_no;
          
          						if(!in_list(["Sales Order", "Purchase Order", "Expense Claim", "Fees"], d.voucher_type)) {
          							if(flt(d.outstanding_amount) > 0)

c.no_of_days_fr_delivery = frappe.datetime.get_diff(d.due_date, cur_frm.doc.posting_date);

Denmark_Del_Puso · February 8, 2018, 7:59am

before i save the result is still empty and the due date appear when the form is save.

magic-overflow · February 8, 2018, 8:08am

after you saved the Payment Entry, field No of Days fr delivery is still empty?

Denmark_Del_Puso · February 8, 2018, 8:10am

yes still empty.

magic-overflow · February 8, 2018, 8:14am

can you use the code below and share the message in you browser console?

 frappe.ui.form.on("Payment Entry", {
            validate: function(frm) {
               $.each(frm.doc.references || [], function(i, d) {
                    var diff_day = frappe.datetime.get_diff(d.due_date, frm.doc.posting_date);
                    console.log(diff_day, d);
               });
            }
        });

Denmark_Del_Puso · February 8, 2018, 8:17am

magic-overflow · February 8, 2018, 8:27am

The script was called. but wrong calculation as it return zero or post date == due_date. can you expend Object in console and check what is the due_date?

Denmark_Del_Puso · February 8, 2018, 8:29am

magic-overflow · February 8, 2018, 8:50am

Child table doesn’t store due_date, so it always return zero. Please try code below.

 frappe.ui.form.on("Payment Entry", {
            validate: function(frm) {
               $.each(frm.doc.references || [], function(i, d) {
                    frappe.db.get_value(d.reference_doctype,d.reference_name,"due_date", function(value){
                        var diff_day = frappe.datetime.get_diff(value["due_date"], frm.doc.posting_date);
                        frappe.model.set_value(d.doctype, d.name, "no_of_days_fr_delivery", diff_day);
                    });                    
               });
            }
        });

Denmark_Del_Puso · February 8, 2018, 8:54am

Hi! @magic-overflow i appreciate your help but still the same .

magic-overflow · February 8, 2018, 9:07am

When you’re at Payment Entry and Payment Entry Reference have items loaded.

can you run the code below in your browser console, and check whether No of Days fr Delivery have value.
I have tested it, it works.

$.each(cur_frm.doc.references || [], function(i, d) {
    frappe.db.get_value(d.reference_doctype,d.reference_name,"due_date", function(value){
        var diff_day = frappe.datetime.get_diff(value["due_date"], cur_frm.doc.posting_date);
        frappe.model.set_value(d.doctype, d.name, "no_of_days_fr_delivery", diff_day);
     });                    
});

Denmark_Del_Puso · February 8, 2018, 9:12am

ill try but the value looks like. you said that it works to you .

magic-overflow · February 8, 2018, 9:19am

posting date = “2018-02-08”
due_date = “2017-10-23”
diff_date = -108

I have assigned diff_day to allocated_amount as image below.

Denmark_Del_Puso · February 9, 2018, 1:28am

yes it works but theres a mild error here when ill try to make another it will not compute the result. but when i refresh and save again the answer will show.