{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [], "deleted": [] }, "bm_appointment": { "created": [ { "app_eventid": 15439, "app_description": "Private 1", "app_summary": "11370-Siva Pradhosh-987", "app_private": 0, "app_appointmentType": 3, "app_userId": 10, "app_orderId": 12692, "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": "[\"\\\/storage\\\/attachments\\\/TESTING3TEST\\\/calendar\\\/15439_mobileattachment1747117492_0.jpg\"]", "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": 844, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "0", "app_jobtimeminute": "20", "app_products": null, "app_deviceplatform": 2, "app_recurrenceexception_date": null, "app_deliveryaddressid": null, "id": "15439", "app_sdate": 1747267200, "app_edate": 1747267200, "app_stime": 1747114252, "app_etime": 1747115452, "app_sdatetime": 1747287052, "app_edatetime": 1747288252, "app_until": null, "app_createdAt": 1747117460, "app_updatedAt": 1747117492, "app_createdBy": 1, "app_updatedBy": null } ], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [], "updated": [ { "jd_id": 12692, "jd_customerid": 5819, "jd_contactid": 7233, "jd_additionalcontacts": "7233", "jd_templateid": 1, "jd_jobmultiquoteid": 12699, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "11370", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "PRAD0001", "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": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": null, "jd_isroundon": 0, "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": 0, "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": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"11370\",\"35\":\"PRAD0001\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":1,\"40\":3,\"41\":1,\"44\":\"\",\"45\":\"Siva\",\"46\":\"Pradhosh\",\"47\":\"987\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":19,\"285\":1,\"286\":\"987\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"612\":\"\",\"countryText\":\"UK\",\"adminUser\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "12692", "jd_createddate": 1747094400, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1747116416, "jd_updatedat": 1747117492 } ], "deleted": [] }, "bm_orderitem": { "created": [], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [], "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": [], "updated": [], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 13516, "jst_jobid": 12692, "jst_job_current_status": 1, "id": "13516", "jst_createdat": "1747116647.110736" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 31811, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 12692, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 12692, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Concorde Blinds, Curtains, Shutters\",\"\":1,\"Account Type\":\"Domestic\",\"Source\":\"Website\",\"Created By\":\"admin\",\"First Name\":\"Siva\",\"Last Name\":\"Pradhosh\",\"Mobile\":\"987\",\"Country\":\"UK\",\"Salutation\":\"Mr.\",\"Phone\":\"987\",\"Assigned to\":1,\"Additional Contacts\":\"7233\",\"Job Ref No\":\"11370\",\"Job Status\":\"Lead\",\"Order Status\":\"1) Enquiry\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"20.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":12692,\"jd_customerid\":5819,\"jd_contactid\":7233,\"jd_additionalcontacts\":\"7233\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"11370\\\",\\\"35\\\":\\\"PRAD0001\\\",\\\"36\\\":1,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":1,\\\"40\\\":3,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Siva\\\",\\\"46\\\":\\\"Pradhosh\\\",\\\"47\\\":\\\"987\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":19,\\\"285\\\":1,\\\"286\\\":\\\"987\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":1,\\\"558\\\":\\\"\\\",\\\"612\\\":\\\"\\\",\\\"countryText\\\":\\\"UK\\\",\\\"adminUser\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-05-13\",\"jd_orderdate\":null,\"jd_duedate\":null,\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"11370\",\"jd_jobstatus\":1,\"jd_contactaddid\":0,\"jd_orderstatus\":3,\"jd_accref\":\"PRAD0001\",\"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\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"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\":0,\"jd_iscostpriceon\":0,\"jd_xero_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\":0,\"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-05-13T06:06:56.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-05-13T06:10:47.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\":\"20.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"20.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": "31811", "cl_createdat": "1747116647.000000", "cl_updatedat": null }, { "cl_id": 31812, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 15438, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 15438, "cl_parentsubjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on May 13\",\"Private\":\"enabled\",\"Appointment Type\":\"Surveyors\",\"Staff\":\"Kieren\",\"Start Date & Time\":\"2025-05-14 05:30:22\",\"End Date & Time\":\"2025-05-14 06:30:22\",\"Appointment Status\":\"Ready\",\"app_jobtimehour\":\"1\",\"app_deviceplatform\":2}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":15438,\"app_description\":null,\"app_summary\":null,\"app_private\":1,\"app_appointmentType\":3,\"app_userId\":2,\"app_orderId\":0,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-05-14\",\"app_edate\":\"2025-05-14\",\"app_stime\":\"05:30:22\",\"app_etime\":\"06:30:22\",\"app_sdatetime\":\"2025-05-14 05:30:22\",\"app_edatetime\":\"2025-05-14 06:30:22\",\"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_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\":844,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":1,\"app_updatedBy\":null,\"app_createdAt\":\"2025-05-13T06:02:32.000000Z\",\"app_updatedAt\":\"2025-05-13T06:02:32.000000Z\",\"app_runid\":null,\"app_deliveryaddressid\":null,\"app_jobtimehour\":\"1\",\"app_jobtimeminute\":\"0\",\"app_products\":null,\"app_deviceplatform\":2}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "31812", "cl_createdat": "1747116647.000000", "cl_updatedat": null }, { "cl_id": 31813, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 485549, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 12692, "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-05-13\",\"Time\":\"06:06:56\",\"Is online note\":\"No\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":485549,\"nl_ordertempid\":0,\"nl_orderid\":12692,\"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-05-13\",\"nl_starttime\":\"06:06:56\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":0,\"nl_seq\":0,\"nl_status\":0,\"created_by\":1,\"created_at\":\"2025-05-13T06:06:56.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-05-13T06:10:47.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "31813", "cl_createdat": "1747116647.000000", "cl_updatedat": null }, { "cl_id": 31814, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in 11370", "cl_event": "created", "cl_subjectid": 12699, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 12692, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":12699,\"jmq_jobid\":12692,\"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\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"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\",\"jmq_deliverycostid\":0,\"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\":\"20.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":12699,\"jmq_jobid\":12692,\"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\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"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\":0,\"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\":\"20.000\",\"jmq_cdeliveryvatperc\":\"20.000\",\"jmq_createdby\":1,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-05-13T06:06:56.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": "31814", "cl_createdat": "1747116647.000000", "cl_updatedat": null }, { "cl_id": 31815, "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": 12692, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 12692, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":12699}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":12699},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "31815", "cl_createdat": "1747116647.000000", "cl_updatedat": null }, { "cl_id": 31816, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 15439, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 12692, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on May 13\",\"Description\":\"Private 1\",\"app_summary\":\"11370-Siva Pradhosh-987\",\"Appointment Type\":\"Surveyors\",\"Staff\":\"Margaret\",\"Job Ref No\":\"11370\",\"Start Date & Time\":\"2025-05-15 05:30:52\",\"End Date & Time\":\"2025-05-15 05:50:52\",\"Appointment Status\":\"Ready\",\"app_jobtimeminute\":\"20\",\"app_deviceplatform\":2}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":15439,\"app_description\":\"Private 1\",\"app_summary\":\"11370-Siva Pradhosh-987\",\"app_private\":0,\"app_appointmentType\":3,\"app_userId\":10,\"app_orderId\":12692,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-05-15\",\"app_edate\":\"2025-05-15\",\"app_stime\":\"05:30:52\",\"app_etime\":\"05:50:52\",\"app_sdatetime\":\"2025-05-15 05:30:52\",\"app_edatetime\":\"2025-05-15 05:50:52\",\"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_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\":844,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":1,\"app_updatedBy\":null,\"app_createdAt\":\"2025-05-13T06:24:20.000000Z\",\"app_updatedAt\":\"2025-05-13T06:24:42.000000Z\",\"app_runid\":null,\"app_deliveryaddressid\":null,\"app_jobtimehour\":\"0\",\"app_jobtimeminute\":\"20\",\"app_products\":null,\"app_deviceplatform\":2}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "31816", "cl_createdat": "1747117492.000000", "cl_updatedat": null }, { "cl_id": 31817, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "Appointment has been updated the fields Uploaded Attachment,app_googleid", "cl_event": "modified", "cl_subjectid": 15439, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 12692, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "[]", "cl_changedto": "{\"Uploaded Attachment\":\"[\\\"\\\\\\\/storage\\\\\\\/attachments\\\\\\\/TESTING3TEST\\\\\\\/calendar\\\\\\\/15439_mobileattachment1747117492_0.jpg\\\"]\",\"app_googleid\":\"0\"}", "cl_customproperties": "{\"attributes\":{\"app_attachment\":\"[\\\"\\\\\\\/storage\\\\\\\/attachments\\\\\\\/TESTING3TEST\\\\\\\/calendar\\\\\\\/15439_mobileattachment1747117492_0.jpg\\\"]\",\"guid\":\"\",\"app_staff\":\"\",\"app_appointtype\":\"\",\"app_coordinates\":\"\",\"app_googleid\":\"0\",\"app_platform\":\"web\",\"app_updatedAt\":\"2025-05-13T06:24:52.000000Z\"},\"old\":{\"app_attachment\":null,\"guid\":null,\"app_staff\":null,\"app_appointtype\":null,\"app_coordinates\":null,\"app_googleid\":null,\"app_platform\":null,\"app_updatedAt\":\"2025-05-13T06:24:42.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "31817", "cl_createdat": "1747117492.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": { "bm_appointment": { "151747117460": 15439 } }, "timestamp": 1747117492 }