{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [], "deleted": [] }, "bm_appointment": { "created": [], "updated": [], "deleted": [ "456" ] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [], "updated": [ { "jd_id": 842, "jd_customerid": 591, "jd_contactid": 613, "jd_additionalcontacts": "613", "jd_templateid": 1, "jd_jobmultiquoteid": 865, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN807", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "SIVA0006", "jd_invoiceno": "", "jd_listprice": "36441.30", "jd_netprice": "36441.30", "jd_vat": "1093.24", "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": "37534.54", "jd_grossprofit": "0.00", "jd_costprice": "328.30", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "37534.54", "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": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"JBN807\",\"35\":\"SIVA0006\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":24,\"40\":1,\"41\":1,\"44\":\"\",\"45\":\"Sivaraj\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"698705\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":1,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\",\"countryText\":\"Australia\",\"adminUser\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "842", "jd_createddate": 1742774400, "jd_orderdate": null, "jd_duedate": 1742774400, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742801615, "jd_updatedat": 1742809352 }, { "jd_id": 845, "jd_customerid": 594, "jd_contactid": 616, "jd_additionalcontacts": "616", "jd_templateid": 1, "jd_jobmultiquoteid": 868, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "JBN810", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 1, "jd_accref": "QUOT0025", "jd_invoiceno": "", "jd_listprice": "162.24", "jd_netprice": "162.24", "jd_vat": "4.87", "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": "167.11", "jd_grossprofit": "14.27", "jd_costprice": "147.97", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "167.11", "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": 26, "jd_updatedby": 26, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 24, "jd_deliveryvatperc": "3.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"JBN810\",\"35\":\"QUOT0025\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":24,\"40\":1,\"41\":26,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 24\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 24\",\"50\":\"\",\"51\":\"Quote 24\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":17,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"521\":\"\",\"522\":\"\",\"523\":\"\",\"555\":\"\",\"586\":\"\",\"587\":\"\",\"588\":\"\",\"616\":\"\",\"617\":\"\",\"618\":26,\"625\":2,\"633\":\"\",\"634\":\"\",\"666\":\"\",\"667\":\"\",\"700\":\"\",\"701\":\"\",\"702\":1,\"703\":\"\",\"704\":\"\",\"countryText\":\"Australia\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "3.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "845", "jd_createddate": 1742774400, "jd_orderdate": 1742774400, "jd_duedate": 1742774400, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1742809085, "jd_updatedat": 1742809261 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 2129, "oi_jobid": 835, "oi_jobtempid": "0", "oi_jobmultiquoteid": 858, "oi_productid": 38, "oi_recipeid": 38, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":2398,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Quantity\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":14,\"mandatory\":0,\"fieldname\":\"Quantity\",\"fieldid\":2398,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":6493,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":2,\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"issubfabric\":0,\"labelnamecode\":\"Unit Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":34,\"mandatory\":0,\"fieldname\":\"Unit Type\",\"fieldid\":6493,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":2,\"optionsvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"editruleoverride\":0},{\"id\":2399,\"labelname\":\"Supplier\",\"value\":\"21\",\"valueid\":null,\"type\":17,\"optionid\":\"21\",\"optionvalue\":[{\"id\":21,\"optionid\":21,\"optionname\":\"Live Source\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"Supplier\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":17,\"mandatory\":0,\"fieldname\":\"Supplier\",\"fieldid\":2399,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"21\",\"optionsvalue\":[{\"id\":21,\"optionid\":21,\"optionname\":\"Live Source\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":3126,\"labelname\":\"width\",\"value\":1500,\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"width\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"width\",\"fieldid\":3126,\"subchild\":[],\"fieldInformation\":null,\"ruleoverride\":0,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3127,\"labelname\":\"drop\",\"value\":2000,\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_mm_3_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"drop\",\"fieldid\":3127,\"subchild\":[],\"fieldInformation\":null,\"ruleoverride\":0,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2400,\"labelname\":\"Slat Colour\",\"value\":136,\"valueid\":\"164\",\"type\":13,\"optionid\":136,\"optionvalue\":[{\"id\":164,\"fieldid\":2400,\"fieldoptionlinkid\":164,\"optionid\":136,\"mainsupplier\":\"21\",\"blindtypecode\":\"1\",\"optionname\":\"n\",\"optionquantity\":1,\"subcount\":1,\"status\":0,\"subdatacount\":1}],\"issubfabric\":0,\"labelnamecode\":\"Slat Colour\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Slat Colour\",\"fieldid\":2400,\"subchild\":[{\"fieldtypeid\":3,\"labelnamecode\":\"Option\",\"fieldid\":7417,\"fieldname\":\"Option\",\"selection\":1,\"seq\":22,\"mandatory\":0,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"field_has_sub_option\":1,\"fabricorcolor\":0,\"subfieldlinkid\":164,\"forchildsubfieldlinkid\":\"13_164\",\"optionsvalue\":[{\"optionid\":116,\"optionqty\":\"1\",\"optionname\":\"Dimmer Emitter 4 Channels SOURCE\",\"optioncode\":\"29 004 006 000_Panther\",\"description\":null,\"pricegroups\":null,\"unittype\":null,\"fieldoptionlinkid\":9444,\"forchildfieldoptionlinkid\":\"13_9444\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null}],\"optionsbackup\":[{\"optionid\":116,\"optionqty\":\"1\",\"optionname\":\"Dimmer Emitter 4 Channels SOURCE\",\"optioncode\":\"29 004 006 000_Panther\",\"description\":null,\"pricegroups\":null,\"unittype\":null,\"fieldoptionlinkid\":9444,\"forchildfieldoptionlinkid\":\"13_9444\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null}],\"editablecolumns\":[\"optionqty\"],\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionqty\":\"Option Qty\",\"optionname\":\"Option Name\",\"optioncode\":\"Option Code\",\"description\":\"Description\",\"pricegroups\":\"Price Groups\"},\"optiondefault\":null,\"masterparentfieldid\":2400,\"subchild\":[],\"value\":null,\"issubfabric\":0,\"supplierid\":\"21\",\"editruleoverride\":null,\"textfieldheight\":1,\"fieldInformation\":null,\"numeric_minvalue\":0,\"numeric_maxvalue\":0,\"dumydata\":[]}],\"fieldInformation\":null,\"optiondefault\":136,\"optionsvalue\":[{\"id\":164,\"fieldid\":2400,\"fieldoptionlinkid\":164,\"optionid\":136,\"mainsupplier\":\"21\",\"blindtypecode\":\"1\",\"optionname\":\"n\",\"optionquantity\":1,\"subcount\":1,\"status\":0,\"subdatacount\":1}],\"editruleoverride\":0},{\"id\":7417,\"labelname\":\"Option\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Option\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Option\",\"fieldid\":7417,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":3125,\"labelname\":\"Blinds Slat Materials\",\"value\":\"Driftwood\",\"valueid\":\"1447\",\"type\":20,\"optionid\":\"1447\",\"optionvalue\":[{\"optionid\":1447,\"optionname\":\"Driftwood\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":1447,\"forchildfieldoptionlinkid\":\"20_3_1447_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":\"\\\/storage\\\/attachments\\\/TESTING3TEST\\\/material\\\/colour\\\/1447_224.webp\",\"subdatacount\":0,\"pricegroup\":\"n\",\"pricegroupid\":136,\"flagcolor\":1}],\"issubfabric\":0,\"labelnamecode\":\"Blinds Slat Materials\",\"fabricorcolor\":2,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":20,\"mandatory\":0,\"fieldname\":\"Blinds Slat Materials\",\"fieldid\":3125,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1447\",\"optionsvalue\":[{\"optionid\":1447,\"optionname\":\"Driftwood\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":1447,\"forchildfieldoptionlinkid\":\"20_3_1447_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":\"\\\/storage\\\/attachments\\\/TESTING3TEST\\\/material\\\/colour\\\/1447_224.webp\",\"subdatacount\":0,\"pricegroup\":\"n\",\"pricegroupid\":136,\"flagcolor\":1}],\"editruleoverride\":1},{\"id\":7449,\"labelname\":\"Numeric 01\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric 01\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":6,\"mandatory\":0,\"fieldname\":\"Numeric 01\",\"fieldid\":7449,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7450,\"labelname\":\"Numeric 02\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Numeric 02\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":6,\"mandatory\":0,\"fieldname\":\"Numeric 02\",\"fieldid\":7450,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7458,\"labelname\":\"Extras\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":0,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":7458,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Live Source, width: 1500, drop: 2000, Slat Colour: n, Blinds Slat Materials: Driftwood", "oi_reportdescription": "##Quantity: 1##,##Supplier: Live Source##,##width: 1500 mm##,##drop: 2000 mm##,##Slat Colour: n##,##Blinds Slat Materials: Driftwood##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##width:<\/br>##drop:<\/br>##Slat Colour:<\/br>##Blinds Slat Materials:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":592,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":38,\"stockupdate\":0,\"fieldid\":\"1447\",\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":600,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":38,\"stockupdate\":0,\"fieldid\":9444,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Dimmer Emitter 4 Channels SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":560,\"value\":\"1500.00\",\"formula\":\"width\",\"price\":\"1500.00\",\"recipeid\":38,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"1500.00\"}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":61,\"process_id\":29,\"product_id\":38,\"phc_id\":61,\"pd_id\":29,\"name\":\"Test\",\"phc_linkstations\":0,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":1,\"phc_domesticsellingprice\":\"9.50\",\"phc_contractsellingprice\":\"9.50\",\"phc_tradesellingprice\":\"9.50\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"9.50\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"9.50\",\"Hour\\\/mins\":\"-\",\"phc_processcostid\":1,\"markupprice\":\"9.50\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"9.50\",\"cost_with_discount\":\"9.50\",\"cost_with_markup\":\"9.50\",\"gross_price\":\"9.79\",\"vat_price\":\"0.28\"}", "oi_pricecomesfrom_calculations": "[]", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "1509.500", "oi_netprice": "1509.500", "oi_pricesfromoperations": null, "oi_vatprice": "45.280", "oi_vatvalue": "3.000", "oi_vatselected": 3, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "1554.790", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "1509.500", "oi_endcustomeroverridevatprice": "45.280", "oi_endcustomeroverridegrossprice": "1554.780", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[2398, 6493, 2399, 3126, 3127, 2400, 7417, 3125, 7449, 7450, 7458]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "2129", "oi_productiondate": 1742821997, "oi_createdat": 1742821997, "oi_updatedat": 1742802224, "oi_createdby": 1, "oi_updatedby": null }, { "oi_id": 2130, "oi_jobid": 836, "oi_jobtempid": "0", "oi_jobmultiquoteid": 859, "oi_productid": 11, "oi_recipeid": 11, "oi_ruleid": 0, "oi_qty": 11, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":6468,\"labelname\":\"Unit Type\",\"value\":4,\"valueid\":\"4\",\"type\":34,\"optionid\":4,\"optionvalue\":[{\"optionid\":4,\"optionname\":\"Inches\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":4,\"forchildfieldoptionlinkid\":\"34_4\"}],\"issubfabric\":0,\"labelnamecode\":\"Unit Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":34,\"mandatory\":0,\"fieldname\":\"Unit Type\",\"fieldid\":6468,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":4,\"optionsvalue\":[{\"optionid\":4,\"optionname\":\"Inches\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":4,\"forchildfieldoptionlinkid\":\"34_4\"}],\"editruleoverride\":0},{\"id\":76,\"labelname\":\"Quantity\",\"value\":\"11\",\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Quantity\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":14,\"mandatory\":0,\"fieldname\":\"Quantity\",\"fieldid\":76,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":77,\"labelname\":\"Supplier\",\"value\":4,\"valueid\":null,\"type\":17,\"optionid\":4,\"optionvalue\":[{\"id\":4,\"optionid\":4,\"optionname\":\"Aquaris\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"Supplier\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":17,\"mandatory\":0,\"fieldname\":\"Supplier\",\"fieldid\":77,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":4,\"optionsvalue\":[{\"id\":4,\"optionid\":4,\"optionname\":\"Aquaris\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":78,\"labelname\":\"Width\",\"value\":\"11\",\"valueid\":null,\"type\":8,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0_Inches_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":8,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":78,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":79,\"labelname\":\"Drop\",\"value\":\"11\",\"valueid\":null,\"type\":10,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_Inches_3_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":10,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":79,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":80,\"labelname\":\"Material\",\"value\":\"Berumuda\",\"valueid\":\"9\",\"type\":21,\"optionid\":\"9\",\"optionvalue\":[{\"optionid\":9,\"optionname\":\"Berumuda\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":9,\"forchildfieldoptionlinkid\":\"21_2_9_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":4,\"fabricmapid\":9}],\"issubfabric\":0,\"labelnamecode\":\"Material\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":21,\"mandatory\":0,\"fieldname\":\"Material\",\"fieldid\":80,\"subchild\":[{\"fieldtypeid\":21,\"labelnamecode\":\"Color\",\"fieldid\":81,\"status\":0,\"fieldname\":\"Color\",\"field_has_sub_option\":1,\"selection\":0,\"seq\":1,\"mandatory\":0,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"fabricorcolor\":2,\"optionsvalue\":[{\"optionid\":12,\"optionname\":\"Red\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":36,\"forchildfieldoptionlinkid\":\"21_3_36_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":9627,\"optionname\":\"Green\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":22536,\"forchildfieldoptionlinkid\":\"21_3_22536_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null}],\"optionsbackup\":[{\"optionid\":12,\"optionname\":\"Red\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":36,\"forchildfieldoptionlinkid\":\"21_3_36_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null},{\"optionid\":9627,\"optionname\":\"Green\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":22536,\"forchildfieldoptionlinkid\":\"21_3_22536_0\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null}],\"editablecolumns\":[],\"subfieldlinkid\":9,\"forchildsubfieldlinkid\":\"21_2_9_1\",\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionname\":\"Color Name\",\"optioncode\":\"Color Code\"},\"optiondefault\":null,\"value\":null,\"issubfabric\":0,\"masterparentfieldid\":80,\"hasstock\":0,\"subchild\":[],\"supplierid\":\"0\",\"editruleoverride\":null,\"linktopricegroup\":0,\"dualseq\":1,\"fieldInformation\":null,\"multiseq\":0,\"dumydata\":[],\"blindswidth\":0},{\"fieldtypeid\":3,\"labelnamecode\":\"List 01\",\"fieldid\":7400,\"fieldname\":\"List 01\",\"selection\":1,\"seq\":17,\"mandatory\":0,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"field_has_sub_option\":1,\"fabricorcolor\":0,\"subfieldlinkid\":9,\"forchildsubfieldlinkid\":\"21_2_9\",\"optionsvalue\":[{\"optionid\":1077,\"optionqty\":\"1\",\"optionname\":\"Grey\",\"optioncode\":\"SLX-CAS-R09\",\"description\":null,\"pricegroups\":\"Test A,BAND B\",\"unittype\":null,\"fieldoptionlinkid\":9428,\"forchildfieldoptionlinkid\":\"21_9428\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null}],\"optionsbackup\":[{\"optionid\":1077,\"optionqty\":\"1\",\"optionname\":\"Grey\",\"optioncode\":\"SLX-CAS-R09\",\"description\":null,\"pricegroups\":\"Test A,BAND B\",\"unittype\":null,\"fieldoptionlinkid\":9428,\"forchildfieldoptionlinkid\":\"21_9428\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null}],\"editablecolumns\":[\"optionqty\"],\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionqty\":\"Option Qty\",\"optionname\":\"Option Name\",\"optioncode\":\"Option Code\",\"description\":\"Description\",\"pricegroups\":\"Price Groups\"},\"optiondefault\":null,\"masterparentfieldid\":80,\"subchild\":[],\"value\":null,\"issubfabric\":0,\"supplierid\":\"1,4\",\"editruleoverride\":null,\"textfieldheight\":1,\"fieldInformation\":null,\"numeric_minvalue\":0,\"numeric_maxvalue\":0,\"dumydata\":[],\"blindswidth\":0}],\"fieldInformation\":null,\"optiondefault\":\"9\",\"optionsvalue\":[{\"optionid\":9,\"optionname\":\"Berumuda\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":9,\"forchildfieldoptionlinkid\":\"21_2_9_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":4,\"fabricmapid\":9}],\"editruleoverride\":1},{\"id\":81,\"labelname\":\"Color\",\"value\":null,\"valueid\":null,\"type\":21,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Color\",\"fabricorcolor\":2,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":21,\"mandatory\":0,\"fieldname\":\"Color\",\"fieldid\":81,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7400,\"labelname\":\"List 01\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"List 01\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"List 01\",\"fieldid\":7400,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":83,\"labelname\":\"Extras\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":83,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2284,\"labelname\":\"Battens\",\"value\":null,\"valueid\":null,\"type\":33,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"BattensBa225\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":33,\"mandatory\":0,\"fieldname\":\"Battens\",\"fieldid\":2284,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"optionlength\":null,\"editruleoverride\":0}]", "oi_description": "Supplier: Aquaris, Width: 11, Drop: 11, Material: Berumuda", "oi_reportdescription": "##Quantity: 11##,##Supplier: Aquaris##,##Width: 11 Inches##,##Drop: 11 Inches##,##Material: Berumuda##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Width:<\/br>##Drop:<\/br>##Material:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":331,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":11,\"stockupdate\":0,\"fieldid\":2503,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Dimmer Emitter Channels\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":334,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":11,\"stockupdate\":0,\"fieldid\":2504,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Test\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":157,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":11,\"stockupdate\":0,\"fieldid\":196,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"One\",\"list_option_name\":\"One\",\"list_description\":\"des\",\"list_option_code\":\"ON0025\",\"list_unit_type\":\"Each\",\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Shutter cost\",\"unit_type\":\"-\",\"cost_price\":\"10.56\",\"show_hide\":true,\"category\":5}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "10.560", "oi_netprice": "10.560", "oi_pricesfromoperations": null, "oi_vatprice": "0.320", "oi_vatvalue": "3.000", "oi_vatselected": 3, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "10.880", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "10.560", "oi_endcustomeroverridevatprice": "0.320", "oi_endcustomeroverridegrossprice": "10.880", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[6468, 76, 77, 78, 79, 80, 81, 7400, 83, 2284]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "2130", "oi_productiondate": 1742822071, "oi_createdat": 1742822071, "oi_updatedat": 1742802286, "oi_createdby": 1, "oi_updatedby": null } ], "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": [ { "jmq_id": 868, "jmq_jobid": 845, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "162.24", "jmq_netprice": "162.24", "jmq_vat": "4.87", "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": "167.11", "jmq_grossprofit": "14.27", "jmq_costprice": "147.97", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "0.00", "jmq_totpaid": "167.11", "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": "3.000", "jmq_cdeliveryvatperc": "3.000", "id": "868", "jmq_duedate": 1742774400, "jmq_sceduleddate": null, "jmq_createdat": "1742809085.000000", "jmq_updatedat": "1742809259.000000", "jmq_createdby": 26, "jmq_updatedby": 26 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 896, "jst_jobid": 845, "jst_job_current_status": 3, "id": "896", "jst_createdat": "1742809259.104981" }, { "jst_id": 897, "jst_jobid": 845, "jst_job_current_status": 4, "id": "897", "jst_createdat": "1742809261.499839" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 17801, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 845, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 845, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 26, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"BlindMatrix\",\"\":\"Australia\",\"Account Type\":\"Domestic\",\"Source\":\"Linked In\",\"Created By\":\"Bharani\",\"Last Name\":\"Quote 24\",\"Address1\":\"Quote 24\",\"Town \\\/ City\":\"Quote 24\",\"Country\":\"Australia\",\"Salutation\":\"Hap\",\"Check Box\":\"Disabled\",\"Date & Time1\":\"03-24-2025 09:40:58\",\"Assigned to\":26,\"Role\":2,\"Date1\":\"2025-03-24\",\"Delivery date1\":\"2025-03-24\",\"Rework date\":\"2025-03-24\",\"Additional Contacts\":\"616\",\"Production Due Date\":\"2025-03-24\",\"Job Ref No\":\"JBN810\",\"Job Status\":\"Quote\",\"Order Status\":\"Order1\",\"Net Price\":\"162.24\",\"VAT Price\":\"4.87\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"167.11\",\"Gross Profit\":\"14.27\",\"Total CostPrice\":\"147.97\",\"Total Paid\":\"167.11\",\"jd_isonlineorder\":1,\"jd_quickquote\":24,\"Delivery Vat Percentage\":\"3.000\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":845,\"jd_customerid\":594,\"jd_contactid\":616,\"jd_additionalcontacts\":\"616\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"JBN810\\\",\\\"35\\\":\\\"QUOT0025\\\",\\\"36\\\":3,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":24,\\\"40\\\":1,\\\"41\\\":26,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"Quote 24\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"Quote 24\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"Quote 24\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":4,\\\"285\\\":17,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"521\\\":\\\"\\\",\\\"522\\\":\\\"\\\",\\\"523\\\":\\\"\\\",\\\"555\\\":\\\"\\\",\\\"586\\\":\\\"\\\",\\\"587\\\":\\\"\\\",\\\"588\\\":\\\"\\\",\\\"616\\\":\\\"\\\",\\\"617\\\":\\\"\\\",\\\"618\\\":26,\\\"625\\\":2,\\\"633\\\":\\\"\\\",\\\"634\\\":\\\"\\\",\\\"666\\\":\\\"\\\",\\\"667\\\":\\\"\\\",\\\"700\\\":\\\"\\\",\\\"701\\\":\\\"\\\",\\\"702\\\":1,\\\"703\\\":\\\"\\\",\\\"704\\\":\\\"\\\",\\\"countryText\\\":\\\"Australia\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-03-24\",\"jd_orderdate\":null,\"jd_duedate\":\"2025-03-24\",\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"JBN810\",\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":1,\"jd_accref\":\"QUOT0025\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"162.24\",\"jd_netprice\":\"162.24\",\"jd_vat\":\"4.87\",\"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\":\"167.11\",\"jd_grossprofit\":\"14.27\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"147.97\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"167.11\",\"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_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":26,\"jd_createdat\":\"2025-03-24T09:38:05.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-03-24T09:40:58.000000Z\",\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":24,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"3.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"3.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}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17801", "cl_createdat": "1742809259.000000", "cl_updatedat": null }, { "cl_id": 17802, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in JBN810", "cl_event": "created", "cl_subjectid": 868, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 845, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 26, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":868,\"jmq_jobid\":845,\"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\":\"162.24\",\"Net Price\":\"162.24\",\"VAT Price\":\"4.87\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"167.11\",\"Gross Profit\":\"14.27\",\"Total CostPrice\":\"147.97\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"167.11\",\"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\":\"3.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":868,\"jmq_jobid\":845,\"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\":\"162.24\",\"jmq_netprice\":\"162.24\",\"jmq_vat\":\"4.87\",\"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\":\"167.11\",\"jmq_grossprofit\":\"14.27\",\"jmq_costprice\":\"147.97\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"167.11\",\"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\":\"3.000\",\"jmq_cdeliveryvatperc\":\"3.000\",\"jmq_createdby\":26,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-03-24T09:38:05.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": "17802", "cl_createdat": "1742809259.000000", "cl_updatedat": null }, { "cl_id": 17803, "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": 845, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 845, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 26, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":868}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":868},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17803", "cl_createdat": "1742809259.000000", "cl_updatedat": null }, { "cl_id": 17804, "cl_logname": "default", "cl_type": null, "cl_modulename": "Line Item", "cl_message": "Q1 - new item has been created in Line Item for the product of Roller blinds", "cl_event": "created", "cl_subjectid": 2135, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 845, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 26, "cl_changedfrom": "null", "cl_changedto": "{\"Unit Type\":\" Inches\",\" Quantity\":\" 1\",\" Width\":\" 56\",\" Drop\":\" 67\",\" Product Type\":\" ARt 02\",\" Extras\":\" Manual\",\" Test Sub2\":\" 100Banna2\",\" Control\":\" LEDs in Arms Labour LIVE\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":2135,\"oi_jobid\":845,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":868,\"oi_credit_id\":0,\"oi_productid\":1,\"oi_recipeid\":1,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":6459,\\\"labelname\\\":\\\"Unit Type\\\",\\\"value\\\":4,\\\"valueid\\\":\\\"4\\\",\\\"type\\\":34,\\\"optionid\\\":\\\"4\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":4,\\\"optionname\\\":\\\"Inches\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"unittype\\\":0,\\\"unitcost\\\":0,\\\"pricingtype\\\":0,\\\"fieldoptionlinkid\\\":4,\\\"forchildfieldoptionlinkid\\\":\\\"34_4\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":1,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":2,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":\\\"35\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"35\\\",\\\"optionvalue\\\":[{\\\"id\\\":35,\\\"optionid\\\":35,\\\"optionname\\\":\\\"Aarthi\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":12,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"56\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"0_Inches_3_0\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":7403,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"67\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"0_Inches_3_0\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":3,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":269,\\\"valueid\\\":\\\"610\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"269\\\",\\\"optionvalue\\\":[{\\\"id\\\":610,\\\"fieldid\\\":3,\\\"fieldoptionlinkid\\\":610,\\\"optionid\\\":269,\\\"mainsupplier\\\":\\\"35\\\",\\\"blindtypecode\\\":\\\"\\\",\\\"optionname\\\":\\\"ARt 02\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":4,\\\"labelname\\\":\\\"Fabric\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":5,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":1,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":11,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":\\\"Manual\\\",\\\"valueid\\\":\\\"5\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"3\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":3,\\\"optionname\\\":\\\"Manual\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"MN005\\\",\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":14.27,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":5,\\\"forchildfieldoptionlinkid\\\":\\\"3_5\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":3,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"28.54\\\",\\\"fieldid\\\":5}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":2287,\\\"labelname\\\":\\\"Test Sub2\\\",\\\"value\\\":\\\"100Banna2\\\",\\\"valueid\\\":\\\"2549\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"177\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":177,\\\"optionname\\\":\\\"100Banna2\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"39 114 700 909_Panther\\\",\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":20.24,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":2549,\\\"forchildfieldoptionlinkid\\\":\\\"3_2549\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"36.84\\\",\\\"fieldid\\\":2549}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":2288,\\\"labelname\\\":\\\"Test Sub3\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":106,\\\"labelname\\\":\\\"Control\\\",\\\"value\\\":\\\"LEDs in Arms Labour LIVE\\\",\\\"valueid\\\":\\\"209\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"172\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":172,\\\"optionname\\\":\\\"LEDs in Arms Labour LIVE\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":\\\"Panther\\\",\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":null,\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":209,\\\"forchildfieldoptionlinkid\\\":\\\"3_209\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":2269,\\\"labelname\\\":\\\"Text\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":6390,\\\"labelname\\\":\\\"P2\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Unit Type: Inches, Quantity: 1, Width: 56, Drop: 67, Product Type: ARt 02, Extras: Manual, Test Sub2: 100Banna2, Control: LEDs in Arms Labour LIVE\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Width: 56 Inches##,##Drop: 67 Inches##,##Product Type: ARt 02##,##Extras: Manual##,##Test Sub2: 100Banna2##,##Control: LEDs in Arms Labour LIVE##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Width:##Drop:##Product Type:##Extras:##Test Sub2:##Control:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-03-24 09:38:27\",\"oi_operationstatus\":null,\"oi_scanstatus\":\"\",\"oi_operationworkroom_data\":\"[]\",\"oi_operationcalender_data\":\"[]\",\"oi_operation_calculations\":\"[]\",\"oi_pricecomesfrom_calculations\":\"{}\",\"oi_pricetablepriceevenbom\":\"{}\",\"oi_productionstatus\":null,\"oi_costoverride\":0,\"oi_costprice\":\"147.970\",\"oi_netprice\":\"162.240\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"4.870\",\"oi_vatvalue\":\"3.000\",\"oi_vatselected\":3,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"167.110\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":1,\"oi_overridevalue\":null,\"oi_overridenetprice\":\"0.000\",\"oi_overridevatprice\":\"0.000\",\"oi_overridegrossprice\":\"0.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":1,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"0.000\",\"oi_endcustomeroverridevatprice\":\"0.000\",\"oi_endcustomeroverridegrossprice\":\"0.000\",\"oi_sage_flag\":0,\"oi_status\":0,\"oi_createdby\":26,\"oi_createdat\":\"2025-03-24T09:39:37.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[6459, 1, 2, 12, 7403, 3, 4, 11, 2287, 2288, 106, 2269, 6390]\",\"oi_deviceplatform\":2,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"oi_commissionprice\":\"0.000\",\"oi_commissionvatprice\":\"0.000\",\"oi_jsondatabackup\":\"\",\"oi_stockdeduct\":0,\"oi_deductedstockdetails\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17804", "cl_createdat": "1742809259.000000", "cl_updatedat": null }, { "cl_id": 17805, "cl_logname": "model", "cl_type": "QUEUE_121", "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 845, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 845, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 26, "cl_changedfrom": "{\"Job Status\":\"Quote\"}", "cl_changedto": "{\"Job Status\":\"Order\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17805", "cl_createdat": "1742809261.000000", "cl_updatedat": null }, { "cl_id": 17806, "cl_logname": "QUEUE_121", "cl_type": "QUEUE_121", "cl_modulename": "Job", "cl_message": "Job has been updated the field Job Rework Enable", "cl_event": "modified", "cl_subjectid": 845, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 845, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 26, "cl_changedfrom": "{\"Job Rework Enable\":\"Off\"}", "cl_changedto": "{\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_jobstatus\":4,\"jd_updatedat\":\"2025-03-24T09:41:01.000000Z\",\"jd_rework_enable\":1},\"old\":{\"jd_jobstatus\":3,\"jd_updatedat\":\"2025-03-24T09:40:59.000000Z\",\"jd_rework_enable\":0}}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17806", "cl_createdat": "1742809261.000000", "cl_updatedat": null }, { "cl_id": 17807, "cl_logname": "default", "cl_type": "QUEUE_122", "cl_modulename": "EMAIL", "cl_message": "(Email) Sent to rakeshreal91@gmail.com.", "cl_event": "", "cl_subjectid": 845, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 845, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 26, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "17807", "cl_createdat": "1742809266.000000", "cl_updatedat": "1742809266.000000" }, { "cl_id": 17808, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 456, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 842, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on March 24\",\"app_summary\":\"JBN807-Sivaraj-698705\",\"Appointment Type\":\"Miscellaneous\",\"Staff\":\"Siva\",\"Job Ref No\":\"JBN807\",\"All Day\":\"Enabled\",\"Start Date & Time\":\"2025-03-24 18:29:59\",\"End Date & Time\":\"2025-03-24 18:29:59\",\"Uploaded Attachment\":\"[]\",\"Appointment Status\":\"sdsd33\",\"app_jobtimeminute\":\"30\",\"app_deviceplatform\":1}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":456,\"app_description\":null,\"app_summary\":\"JBN807-Sivaraj-698705\",\"app_private\":0,\"app_appointmentType\":67,\"app_userId\":27,\"app_orderId\":842,\"app_customerId\":0,\"app_isAllDay\":1,\"app_sdate\":\"2025-03-24\",\"app_edate\":\"2025-03-24\",\"app_stime\":\"18:29:59\",\"app_etime\":\"18:29:59\",\"app_sdatetime\":\"2025-03-24 18:29:59\",\"app_edatetime\":\"2025-03-24 18:29:59\",\"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\":\"[]\",\"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\":811,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":27,\"app_updatedBy\":null,\"app_createdAt\":\"2025-03-24T09:42:19.000000Z\",\"app_updatedAt\":\"2025-03-24T09:42:19.000000Z\",\"app_runid\":null,\"app_deliveryaddressid\":null,\"app_jobtimehour\":\"0\",\"app_jobtimeminute\":\"30\",\"app_products\":null,\"app_deviceplatform\":1}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17808", "cl_createdat": "1742809352.000000", "cl_updatedat": null }, { "cl_id": 17809, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "Appointment is deleted ", "cl_event": "deleted", "cl_subjectid": 456, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 842, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "{\"app_status\":0}", "cl_changedto": "{\"app_status\":1}", "cl_customproperties": "{\"attributes\":{\"app_status\":1,\"app_updatedBy\":1,\"app_updatedAt\":\"2025-03-24T09:43:31.000000Z\"},\"old\":{\"app_status\":0,\"app_updatedBy\":null,\"app_updatedAt\":\"2025-03-24T09:42:19.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "17809", "cl_createdat": "1742809411.000000", "cl_updatedat": null } ], "updated": [ { "cl_id": 17807, "cl_logname": "default", "cl_type": "QUEUE_122", "cl_modulename": "EMAIL", "cl_message": "(Email) Sent to rakeshreal91@gmail.com.", "cl_event": "", "cl_subjectid": 845, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 845, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 26, "cl_changedfrom": null, "cl_changedto": null, "cl_customproperties": null, "cl_attachment": null, "cl_deviceplatform": null, "cl_deviceipaddress": null, "cl_devicenameversion": null, "cl_devicelocation": null, "cl_causertype": "", "id": "17807", "cl_createdat": "1742809266.000000", "cl_updatedat": "1742809266.000000" } ], "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": 1742809930 }