{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [], "deleted": [] }, "bm_appointment": { "created": [], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [], "updated": [ { "jd_id": 12683, "jd_customerid": 5812, "jd_contactid": 7224, "jd_additionalcontacts": "7224", "jd_templateid": 1, "jd_jobmultiquoteid": 12690, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "11361", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "NAMB0001", "jd_invoiceno": "", "jd_listprice": "1465.68", "jd_netprice": "1515.68", "jd_vat": "530.49", "jd_isvaton": 1, "jd_deliverycost": "50.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 2, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "2046.17", "jd_grossprofit": "145.88", "jd_costprice": "1369.80", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "2026.17", "jd_totpaid": "20.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "1325.08", "jd_endcustomeroverridevatprice": "265.02", "jd_endcustomeroverridegrossprice": "1590.10", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":1,\"41\":1,\"44\":\"\",\"45\":\"Kalai\",\"46\":\"Nambi\",\"47\":\"\",\"48\":\"\",\"49\":\"Ymca\",\"50\":\"Nandanam\",\"51\":\"Chennai\",\"52\":\"\",\"53\":\"600035\",\"54\":19,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"0\",\"612\":\"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "12683", "jd_createddate": 1746662400, "jd_orderdate": null, "jd_duedate": 1746662400, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1746688533, "jd_updatedat": 1747125557 } ], "deleted": [] }, "bm_orderitem": { "created": [], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 485550, "nl_ordertempid": null, "nl_orderid": 12683, "nl_notescategory": 1, "nl_type": 4, "nl_platform": 3, "nl_desc": "Payment Added succesfully for this job amount (20)", "nl_manualNotes": "", "nl_createdby": "1", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "485550", "nl_endddate": 1747094400, "nl_starttime": 1747129157, "created_at": 1747125557, "updated_at": 1747125557, "created_by": 1, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [], "updated": [], "deleted": [] }, "bm_InvoiceDetails": { "created": [], "updated": [], "deleted": [] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [ { "jp_id": 310, "jp_job_id": 12683, "jp_amount": "20.000", "jp_amountoutstanding": "20.000", "jp_paymentmethod": 17, "jp_paymentcategory": 1, "jp_paymenttype": 8, "jp_surchargetype": 0, "jp_surchargemethod": 0, "jp_surchargeamount": "0.000", "jp_surchargevalue": "0.000", "jp_surchargetotal": "0.000", "jp_userid": 1, "jp_decription": "", "jp_deviceplatform": 1, "jp_status": 0, "jp_transfer": 0, "jp_transfer_id": null, "id": "310", "jp_paiddate": 1747094400, "jp_createdat": 1747125557, "jp_updatedat": 1747125557, "jp_createdby": 1, "jp_updatedby": null } ], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [], "updated": [ { "jmq_id": 12690, "jmq_jobid": 12683, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "1465.68", "jmq_netprice": "1515.68", "jmq_vat": "530.49", "jmq_isvaton": 1, "jmq_deliverycost": "50.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 2, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "2046.17", "jmq_grossprofit": "145.88", "jmq_costprice": "1369.80", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "2026.17", "jmq_totpaid": "20.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "1325.08", "jmq_endcustomeroverridevatprice": "265.02", "jmq_endcustomeroverridegrossprice": "1590.10", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "20.000", "jmq_cdeliveryvatperc": "20.000", "id": "12690", "jmq_duedate": 1746662400, "jmq_sceduleddate": null, "jmq_createdat": "1746688533.000000", "jmq_updatedat": "1747125557.000000", "jmq_createdby": 1, "jmq_updatedby": 1 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 31818, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Amount Outstanding,Total Paid", "cl_event": "modified", "cl_subjectid": 12683, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 12683, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"Amount Outstanding\":\"2046.17\",\"Total Paid\":\"0.00\"}", "cl_changedto": "{\"Amount Outstanding\":\"2026.17\",\"Total Paid\":\"20.00\"}", "cl_customproperties": "{\"attributes\":{\"jd_amountoutstanding\":\"2026.17\",\"jd_totpaid\":\"20.00\",\"jd_updatedat\":\"2025-05-13T08:39:17.000000Z\"},\"old\":{\"jd_amountoutstanding\":\"2046.17\",\"jd_totpaid\":\"0.00\",\"jd_updatedat\":\"2025-05-08T07:33:34.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "31818", "cl_createdat": "1747125557.000000", "cl_updatedat": null }, { "cl_id": 31819, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 485550, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 12683, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"Payment Added succesfully for this job amount (20)\",\"Created By\":\"admin\",\"Date\":\"2025-05-13\",\"Time\":\"09:39:17\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":485550,\"nl_ordertempid\":null,\"nl_orderid\":12683,\"nl_notescategory\":1,\"nl_type\":4,\"nl_platform\":3,\"nl_desc\":\"Payment Added succesfully for this job amount (20)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-05-13\",\"nl_starttime\":\"09:39:17\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-05-13T08:39:17.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-05-13T08:39:17.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "31819", "cl_createdat": "1747125557.000000", "cl_updatedat": null } ], "updated": [], "deleted": [] }, "bm_productInfo": { "created": [], "updated": [], "deleted": [] }, "bm_fields": { "created": [], "updated": [], "deleted": [] }, "bm_fieldOptionLink": { "created": [], "updated": [], "deleted": [] }, "bm_option": { "created": [], "updated": [], "deleted": [] }, "bm_optionproduct": { "created": [], "updated": [], "deleted": [] }, "bm_linkedfieldswithproduct": { "created": [], "updated": [], "deleted": [] }, "bm_productionstatus": { "created": [], "updated": [], "deleted": [] }, "bm_productpricemap": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipe": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipemap": { "created": [], "updated": [], "deleted": [] }, "bm_supproductcode": { "created": [], "updated": [], "deleted": [] }, "bm_rulesetup": { "created": [], "updated": [], "deleted": [] }, "bm_formulas": { "created": [], "updated": [], "deleted": [] }, "bm_customercommission": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupdetails": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupmaterialmap": { "created": [], "updated": [], "deleted": [] }, "bm_productpricedetails": { "created": [], "updated": [], "deleted": [] }, "bm_fabriccolourmap": { "created": [], "updated": [], "deleted": [] }, "bm_fabricdetails": { "created": [], "updated": [], "deleted": [] }, "bm_colordetails": { "created": [], "updated": [], "deleted": [] }, "bm_optiondiscount": { "created": [], "updated": [], "deleted": [] }, "bm_optionpricebook": { "created": [], "updated": [], "deleted": [] }, "bm_allowances": { "created": [], "updated": [], "deleted": [] }, "bm_xyoptionpricedata": { "created": [], "updated": [], "deleted": [] }, "bm_delivery_cost_setup": { "created": [], "updated": [], "deleted": [] }, "bm_organizationdetails": { "created": [], "updated": [], "deleted": [] }, "bm_applicationSetup": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": [], "timestamp": 1747128013 }