{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 5601, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\":1,\"62\":\"DULO0001\",\"63\":\"\",\"64\":18,\"598\":25}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 1, "ctd_foronlineisenable": 1, "ctd_enabledproductdesktop": "31,57,58,59,60,61,62,65,66,69,70,71,73,74,75,76,108,120,153,156,164,168,172,173,174,176,178,182,184,185,186,190,191,192,248,249,250,251,252,254,255,257", "ctd_enabledproductonline": "31,57,58,59,60,61,62,65,66,69,70,71,73,74,75,76,108,120,153,156,164,168,172,173,174,176,178,182,184,185,186,190,191,192,248,249,250,251,252,254,255,257", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "1", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "5601", "ctd_createdat": 1741173292, "ctd_updatedat": 1754381398, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 6972, "cci_customerid": 5601, "cci_templateid": 3, "roleid": 1, "cci_customizedarray": "{\"62\":\"\",\"75\":2,\"76\":\"\",\"77\":\"Mary\",\"78\":\"\",\"79\":\"Dulowaah\",\"81\":\"\",\"82\":\"\",\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"86\":\"\",\"87\":\"103 Hilton Close\",\"88\":\"MK42 7FS\",\"89\":\"Kempston\",\"90\":19,\"91\":\"Bedford\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "6972", "cci_createdat": 1741173293, "cci_updatedat": 1754381398, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [ { "app_eventid": 17174, "app_description": "Fitter", "app_summary": null, "app_private": 1, "app_appointmentType": 2, "app_userId": 14, "app_orderId": 0, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Kolkata", "app_latitude": 0, "app_longitude": 0, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": null, "app_onsiteMinute": null, "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 843, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": null, "app_deviceplatform": 2, "app_recurrenceexception_date": null, "app_deliveryaddressid": null, "id": "17174", "app_sdate": 1754352000, "app_edate": 1754352000, "app_stime": 1754382650, "app_etime": 1754386250, "app_sdatetime": 1754382650, "app_edatetime": 1754386250, "app_until": null, "app_createdAt": 1754380636, "app_updatedAt": 1754380636, "app_createdBy": 1, "app_updatedBy": null }, { "app_eventid": 17175, "app_description": "New appointment", "app_summary": "10990-Mary Dulowaah-103 Hilton Close", "app_private": 0, "app_appointmentType": 2, "app_userId": 17, "app_orderId": 12251, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Kolkata", "app_latitude": 0, "app_longitude": 0, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": null, "app_onsiteMinute": null, "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 845, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": null, "app_deviceplatform": 2, "app_recurrenceexception_date": null, "app_deliveryaddressid": 6972, "id": "17175", "app_sdate": 1754352000, "app_edate": 1754352000, "app_stime": 1754382644, "app_etime": 1754386244, "app_sdatetime": 1754382644, "app_edatetime": 1754386244, "app_until": null, "app_createdAt": 1754381155, "app_updatedAt": 1754381155, "app_createdBy": 1, "app_updatedBy": null } ], "updated": [ { "app_eventid": 17171, "app_description": "Live test", "app_summary": null, "app_private": 1, "app_appointmentType": 3, "app_userId": 7, "app_orderId": 0, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Kolkata", "app_latitude": 0, "app_longitude": 0, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": "[]", "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "00", "app_onsiteHour": null, "app_onsiteMinute": null, "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 844, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": null, "app_deviceplatform": 2, "app_recurrenceexception_date": null, "app_deliveryaddressid": null, "id": "17171", "app_sdate": 1754352000, "app_edate": 1754352000, "app_stime": 1754375402, "app_etime": 1754379002, "app_sdatetime": 1754375402, "app_edatetime": 1754379002, "app_until": null, "app_createdAt": 1754377358, "app_updatedAt": 1754380832, "app_createdBy": 1, "app_updatedBy": 1 } ], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 13586, "jd_customerid": 5601, "jd_contactid": 6972, "jd_additionalcontacts": "6972", "jd_templateid": 1, "jd_jobmultiquoteid": 13622, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "CON12108", "jd_jobstatus": 11, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "DULO0001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 2, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": null, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": null, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "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": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":18,\"45\":\"Mary\",\"46\":\"Dulowaah\",\"49\":\"103 Hilton Close\",\"50\":\"Kempston\",\"51\":\"Bedford\",\"53\":\"MK42 7FS\",\"54\":19,\"62\":\"DULO0001\",\"63\":\"\",\"76\":\"\",\"78\":\"\",\"81\":\"\",\"82\":\"\",\"83\":\"1\",\"86\":\"\",\"285\":2,\"598\":25,\"34\":\"CON12108\",\"35\":\"DULO0001\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "jd_organizationid": 25, "id": "13586", "jd_createddate": 1754352000, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1754381297, "jd_updatedat": 1754381398 } ], "updated": [ { "jd_id": 12251, "jd_customerid": 5601, "jd_contactid": 6972, "jd_additionalcontacts": "6972", "jd_templateid": 1, "jd_jobmultiquoteid": 12251, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "10990", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "DULO0001", "jd_invoiceno": "", "jd_listprice": "3044.31", "jd_netprice": "3044.31", "jd_vat": "608.87", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "3653.18", "jd_grossprofit": "2029.54", "jd_costprice": "1014.77", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "3653.18", "jd_totpaid": "0.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": null, "jd_endcustomeroverridenetprice": "3044.31", "jd_endcustomeroverridevatprice": "608.87", "jd_endcustomeroverridegrossprice": "3653.18", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 8, "jd_updatedby": 10, "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\": 18, \"41\": 8, \"44\": \"\", \"45\": \"Mary\", \"46\": \"Dulowaah\", \"47\": \"\", \"48\": \"\", \"49\": \"103 Hilton Close\", \"50\": \"Kempston\", \"51\": \"Bedford\", \"52\": \"\", \"53\": \"MK42 7FS\", \"54\": 19, \"285\": 2, \"286\": \"\", \"287\": \"Follow Up Sent 4 April\", \"288\": \"\", \"289\": \"\", \"551\": 8, \"558\": \"\", \"612\": \"\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "jd_organizationid": 25, "id": "12251", "jd_createddate": 1741132800, "jd_orderdate": null, "jd_duedate": 1741219200, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1741173293, "jd_updatedat": 1754381398 }, { "jd_id": 13586, "jd_customerid": 5601, "jd_contactid": 6972, "jd_additionalcontacts": "6972", "jd_templateid": 1, "jd_jobmultiquoteid": 13622, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "CON12108", "jd_jobstatus": 11, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "DULO0001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 2, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": null, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": null, "jd_deliverycostid": null, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "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": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":18,\"45\":\"Mary\",\"46\":\"Dulowaah\",\"49\":\"103 Hilton Close\",\"50\":\"Kempston\",\"51\":\"Bedford\",\"53\":\"MK42 7FS\",\"54\":19,\"62\":\"DULO0001\",\"63\":\"\",\"76\":\"\",\"78\":\"\",\"81\":\"\",\"82\":\"\",\"83\":\"1\",\"86\":\"\",\"285\":2,\"598\":25,\"34\":\"CON12108\",\"35\":\"DULO0001\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "jd_organizationid": 25, "id": "13586", "jd_createddate": 1754352000, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1754381297, "jd_updatedat": 1754381398 } ], "deleted": [] }, "bm_orderitem": { "created": [], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 486218, "nl_ordertempid": 0, "nl_orderid": 13586, "nl_notescategory": 1, "nl_type": 5, "nl_platform": 2, "nl_desc": "New job has been created in job", "nl_manualNotes": null, "nl_createdby": "1", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 0, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "486218", "nl_endddate": 1754352000, "nl_starttime": 1754381297, "created_at": 1754381297, "updated_at": 1754381398, "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": [], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 13622, "jmq_jobid": 13586, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "0.00", "jmq_netprice": "0.00", "jmq_vat": "0.00", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 2, "jmq_orderformprice": "0.00", "jmq_editpricebyid": null, "jmq_isroundon": null, "jmq_grossprice": "0.00", "jmq_grossprofit": "0.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "0.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": null, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 0, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 0, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 0, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 0, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "0.000", "jmq_cdeliveryvatperc": "0.000", "id": "13622", "jmq_duedate": null, "jmq_sceduleddate": null, "jmq_createdat": "1754381297.000000", "jmq_updatedat": null, "jmq_createdby": 1, "jmq_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 14647, "jst_jobid": 13586, "jst_job_current_status": 11, "id": "14647", "jst_createdat": "1754381398.823089" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 45872, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 13586, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 13586, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Concorde Blinds, Curtains, Shutters\",\"Account Type\":\"Domestic\",\"Source\":\"Blind Screen\",\"First Name\":\"Mary\",\"Last Name\":\"Dulowaah\",\"Address1\":\"103 Hilton Close\",\"Address2\":\"Kempston\",\"Town \\\/ City\":\"Bedford\",\"Zipcode \\\/ Postcode\":\"MK42 7FS\",\"Country\":\"UK\",\"Account Ref\":\"DULO0001\",\"Default Contact\":\"1\",\"Salutation\":\"Mrs.\",\"\":\"DULO0001\",\"Additional Contacts\":\"6972\",\"Job Ref No\":\"CON12108\",\"Job Status\":\"mufasa\",\"Order Status\":\"1) Enquiry\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"jd_organizationid\":25,\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":13586,\"jd_customerid\":5601,\"jd_contactid\":6972,\"jd_additionalcontacts\":\"6972\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":18,\\\"45\\\":\\\"Mary\\\",\\\"46\\\":\\\"Dulowaah\\\",\\\"49\\\":\\\"103 Hilton Close\\\",\\\"50\\\":\\\"Kempston\\\",\\\"51\\\":\\\"Bedford\\\",\\\"53\\\":\\\"MK42 7FS\\\",\\\"54\\\":19,\\\"62\\\":\\\"DULO0001\\\",\\\"63\\\":\\\"\\\",\\\"76\\\":\\\"\\\",\\\"78\\\":\\\"\\\",\\\"81\\\":\\\"\\\",\\\"82\\\":\\\"\\\",\\\"83\\\":\\\"1\\\",\\\"86\\\":\\\"\\\",\\\"285\\\":2,\\\"598\\\":25,\\\"34\\\":\\\"CON12108\\\",\\\"35\\\":\\\"DULO0001\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-08-05\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_duedatechangedmanually\":0,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"CON12108\",\"jd_jobstatus\":11,\"jd_contactaddid\":0,\"jd_orderstatus\":3,\"jd_accref\":\"DULO0001\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":2,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":null,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":null,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_accountingsoftware_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_organizationid\":25,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":1,\"jd_createdat\":\"2025-08-05T08:08:17.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-08-05T08:09:58.000000Z\",\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":0,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"0.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"0.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0,\"salesorderid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "45872", "cl_createdat": "1754381398.000000", "cl_updatedat": null }, { "cl_id": 45873, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 17174, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 17174, "cl_parentsubjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on August 05\",\"Description\":\"Fitter\",\"Private\":\"enabled\",\"Appointment Type\":\"Fitters\",\"Staff\":\"Yogeshwari\",\"Start Date & Time\":\"2025-08-05 08:30:50\",\"End Date & Time\":\"2025-08-05 09:30:50\",\"Appointment Status\":\"Inprogress\",\"app_jobtimehour\":\"1\",\"app_deviceplatform\":2}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":17174,\"app_description\":\"Fitter\",\"app_summary\":null,\"app_private\":1,\"app_appointmentType\":2,\"app_userId\":14,\"app_orderId\":0,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-08-05\",\"app_edate\":\"2025-08-05\",\"app_stime\":\"08:30:50\",\"app_etime\":\"09:30:50\",\"app_sdatetime\":\"2025-08-05 08:30:50\",\"app_edatetime\":\"2025-08-05 09:30:50\",\"app_timezone\":\"Asia\\\/Kolkata\",\"app_latitude\":0,\"app_longitude\":0,\"app_parentappid\":null,\"app_recurrencerule\":null,\"app_userdefinedValue\":\"[]\",\"app_recurrenceexception\":null,\"app_recurrenceexception_date\":null,\"app_attachment\":null,\"guid\":\"\",\"app_outlookuid\":null,\"app_until\":null,\"app_staff\":\"\",\"app_appointtype\":\"\",\"app_confirmed\":0,\"app_coordinates\":\"\",\"app_travelHour\":\"0\",\"app_travelMinute\":\"0\",\"app_onsiteHour\":null,\"app_onsiteMinute\":null,\"app_location\":null,\"app_traveltime\":null,\"app_googleid\":\"0\",\"app_platform\":\"web\",\"app_cal_status\":843,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":1,\"app_updatedBy\":null,\"app_createdAt\":\"2025-08-05T07:57:16.000000Z\",\"app_updatedAt\":\"2025-08-05T07:57:16.000000Z\",\"app_runid\":null,\"app_deliveryaddressid\":null,\"app_jobtimehour\":\"1\",\"app_jobtimeminute\":\"0\",\"app_products\":null,\"app_deviceplatform\":2,\"app_statusInOutlook\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "45873", "cl_createdat": "1754381398.000000", "cl_updatedat": null }, { "cl_id": 45874, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 17175, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 12251, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on August 05\",\"Description\":\"New appointment\",\"app_summary\":\"10990-Mary Dulowaah-103 Hilton Close\",\"Appointment Type\":\"Fitters\",\"Staff\":\"Rex\",\"Job Ref No\":\"10990\",\"Start Date & Time\":\"2025-08-05 08:30:44\",\"End Date & Time\":\"2025-08-05 09:30:44\",\"Appointment Status\":\"Complete\",\"app_deliveryaddressid\":6972,\"app_jobtimehour\":\"1\",\"app_deviceplatform\":2}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":17175,\"app_description\":\"New appointment\",\"app_summary\":\"10990-Mary Dulowaah-103 Hilton Close\",\"app_private\":0,\"app_appointmentType\":2,\"app_userId\":17,\"app_orderId\":12251,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-08-05\",\"app_edate\":\"2025-08-05\",\"app_stime\":\"08:30:44\",\"app_etime\":\"09:30:44\",\"app_sdatetime\":\"2025-08-05 08:30:44\",\"app_edatetime\":\"2025-08-05 09:30:44\",\"app_timezone\":\"Asia\\\/Kolkata\",\"app_latitude\":0,\"app_longitude\":0,\"app_parentappid\":null,\"app_recurrencerule\":null,\"app_userdefinedValue\":\"[]\",\"app_recurrenceexception\":null,\"app_recurrenceexception_date\":null,\"app_attachment\":null,\"guid\":\"\",\"app_outlookuid\":null,\"app_until\":null,\"app_staff\":\"\",\"app_appointtype\":\"\",\"app_confirmed\":0,\"app_coordinates\":\"\",\"app_travelHour\":\"0\",\"app_travelMinute\":\"0\",\"app_onsiteHour\":null,\"app_onsiteMinute\":null,\"app_location\":null,\"app_traveltime\":null,\"app_googleid\":\"0\",\"app_platform\":\"web\",\"app_cal_status\":845,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":1,\"app_updatedBy\":null,\"app_createdAt\":\"2025-08-05T08:05:55.000000Z\",\"app_updatedAt\":\"2025-08-05T08:05:55.000000Z\",\"app_runid\":null,\"app_deliveryaddressid\":6972,\"app_jobtimehour\":\"1\",\"app_jobtimeminute\":\"0\",\"app_products\":null,\"app_deviceplatform\":2,\"app_statusInOutlook\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "45874", "cl_createdat": "1754381398.000000", "cl_updatedat": null }, { "cl_id": 45875, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 486218, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 13586, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"Job Created\",\"Platform\":\"Trade\",\"Description\":\"New job has been created in job\",\"Created By\":\"admin\",\"Date\":\"2025-08-05\",\"Time\":\"08:08:17\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":486218,\"nl_ordertempid\":0,\"nl_orderid\":13586,\"nl_notescategory\":1,\"nl_type\":5,\"nl_platform\":2,\"nl_desc\":\"New job has been created in job\",\"nl_manualNotes\":null,\"nl_createdby\":\"1\",\"nl_endddate\":\"2025-08-05\",\"nl_starttime\":\"08:08:17\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-08-05T08:08:17.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-08-05T08:09:58.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "45875", "cl_createdat": "1754381398.000000", "cl_updatedat": null }, { "cl_id": 45876, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in CON12108", "cl_event": "created", "cl_subjectid": 13622, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 13586, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":13622,\"jmq_jobid\":13586,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"List Price\":\"0.00\",\"Net Price\":\"0.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":2,\"Discount\":\"0.00\",\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"0.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":13622,\"jmq_jobid\":13586,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"0000-00-00\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"0.00\",\"jmq_netprice\":\"0.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":2,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":null,\"jmq_grossprice\":\"0.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":null,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"0.000\",\"jmq_cdeliveryvatperc\":\"0.000\",\"jmq_createdby\":1,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-08-05T08:08:17.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "45876", "cl_createdat": "1754381398.000000", "cl_updatedat": null }, { "cl_id": 45877, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Multi Quote Id", "cl_event": "modified", "cl_subjectid": 13586, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 13586, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":13622}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":13622},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "45877", "cl_createdat": "1754381398.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": [ { "organization_id": 25, "organizationname": "Concorde Blinds, Curtains, Shutters", "address": "4 Sunbeam Rd", "address2": "Woburn Road Industrial Estate", "addres3": null, "city": "Kempston", "state": "Bedford", "country": null, "code": "MK42 7BY", "phone": "01234 841535", "mobile1": null, "mobile2": null, "fax": "01234 840682", "email3": null, "email1": null, "email2": null, "website": null, "logoname": "CONCORDE.png", "logo": "054311-CONCORDE.png", "vatnumber": "985 1548 80", "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": null, "countryid": 18, "bankname": "HSBC", "comregistrationno": null, "defaultsalestax": 1, "defaultsalestaxlabel": "VAT", "accountnumber": "31293818", "currencyid": 18, "sortcode": "40-26-32", "status": 0, "isdefault": 1, "id": "25", "created_at": 1754381398, "updated_at": 1754381398, "created_by": 1, "updated_by": 24 }, { "organization_id": 27, "organizationname": "BAILEYS", "address": "null", "address2": "null", "addres3": "null", "city": "null", "state": "null", "country": null, "code": "null", "phone": "null", "mobile1": "null", "mobile2": "null", "fax": "null", "email3": "null", "email1": "null", "email2": "null", "website": "null", "logoname": null, "logo": null, "vatnumber": null, "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": "null", "countryid": 18, "bankname": null, "comregistrationno": null, "defaultsalestax": 1, "defaultsalestaxlabel": "VAT", "accountnumber": null, "currencyid": 18, "sortcode": null, "status": 0, "isdefault": 0, "id": "27", "created_at": 1754381398, "updated_at": 1754381398, "created_by": 26, "updated_by": null } ], "updated": [ { "organization_id": 25, "organizationname": "Concorde Blinds, Curtains, Shutters", "address": "4 Sunbeam Rd", "address2": "Woburn Road Industrial Estate", "addres3": null, "city": "Kempston", "state": "Bedford", "country": null, "code": "MK42 7BY", "phone": "01234 841535", "mobile1": null, "mobile2": null, "fax": "01234 840682", "email3": null, "email1": null, "email2": null, "website": null, "logoname": "CONCORDE.png", "logo": "054311-CONCORDE.png", "vatnumber": "985 1548 80", "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": null, "countryid": 18, "bankname": "HSBC", "comregistrationno": null, "defaultsalestax": 1, "defaultsalestaxlabel": "VAT", "accountnumber": "31293818", "currencyid": 18, "sortcode": "40-26-32", "status": 0, "isdefault": 1, "id": "25", "created_at": 1754381398, "updated_at": 1754381398, "created_by": 1, "updated_by": 24 } ], "deleted": [] }, "bm_applicationSetup": { "created": [], "updated": [], "deleted": [] }, "bm_price_setup": { "created": [], "updated": [], "deleted": [] }, "bm_calendarsetup": { "created": [], "updated": [], "deleted": [] }, "bm_appointmenttype": { "created": [], "updated": [], "deleted": [] }, "bm_userWorkDay": { "created": [], "updated": [], "deleted": [] }, "bm_users": { "created": [], "updated": [ { "userid": 1, "roleid": 1, "username": "admin", "firstname": "Third", "lastname": "admin", "gender": "", "password": "0!a2#A0a@AcA", "hash_password": "ak9JRFZ6L2hpYlVOUkI5bVpQM2x0RmtXR2N1SVVYWnBwR2pvRHdnMkZDZz0=", "active": 0, "email": "kishoreblindmatrix@gmail.com", "color_code": "#7acb56", "web_theme": "default", "addressline1": "111", "addressline2": "222", "county": "UK", "townorcity": "Chennai", "country": 18, "zipcode": "HGJH", "notification_subscription": "{\"endpoint\":\"https:\/\/updates.push.services.mozilla.com\/wpush\/v2\/gAAAAABojIO4eI0JpEnIDp62Gpr7ut63Z_W-ezu8ASqICtVUUz8oNlcjPtk40eVALboDnBPkHm1_ITJSALjkW21tYngEUvbHzmycUAcQpp5Mo5hTb9X1DSX9PIsYiZ4oXeL2YOToJUILp9-wimZgQgXQeEx2Ezg1GXf2btQayYYrie5AFEw7xXc\",\"expirationTime\":null,\"keys\":{\"auth\":\"eYVu3oCQNkCc6RpT5iJv5w\",\"p256dh\":\"BPZwv6BAKKHwE8Hs2sMLX0Zw62Zy_v9-ojrF6W_fzC4GOG7B7oQEpIGUSdObc4mthl94s2RkBJSaKTHyepmL4yg\"}}", "mobile": null, "authenticationonoff": 1, "smsauthentication": null, "otpvaliddays": 5, "emailauthentication": null, "appauthentication": null, "appauthkey": null, "backupcodes": null, "otpcode": "", "otpverifieddate": null, "fromemailname": null, "signature": "", "profileimage": null, "platformaccess": "1", "companyId": 25, "recover_key": null, "imapview": 1, "updatesreadnotification": "150", "viewappointment": "2,3,4,5,6,7,8,9,10,11,16,24", "appointmenttypefilter": "8,3,2,6,5,4,7,9", "staff_filter": "2,3,4,7,8,9,10,11,24", "status": 0, "seq": 5, "isdefault": 1, "user_latitude": null, "user_longitude": null, "user_validgeoaddress": "NotDefined", "user_cv_seq": "9,67,23,24,25,37,61,63,64", "costprice_in_mobile": 1, "netprice_in_mobile": 1, "id": "1", "created_at": 1631498546, "updated_at": 1754380878, "created_by": 1, "updated_by": 1 } ], "deleted": [] }, "custom_fields": { "created": [], "updated": [], "deleted": [] }, "customfieldvalues": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": { "bm_jobdetails": { "41754381297": 13586 }, "bm_appointment": { "151754380636": 17174, "151754380637": 17175 }, "bm_notelist": { "61754381297": 486218 }, "bm_jobmultiquote": { "141754381297": 13622 } }, "timestamp": 1754381398 }