[2026-01-16 12:07:04] production.INFO: getManualSyncError: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ush_userid' cannot be null (SQL: insert into `bm_user_sync_histories` (`ush_userid`, `ush_deviceplatform`, `ush_devicename`, `ush_deviceversion`, `ush_deviceuniqueid`, `ush_sync_type`, `ush_inputrequestjson`, `ush_synctime`, `ush_createdby`, `ush_usersyncfilename`, `ush_createdat`) values (?, ?, ?, ?, ?, ?, {"customerdetailsarray":[{"bm_customercontactinfo":{"created":[],"updated":[],"deleted":[]},"bm_customertemplatedata":{"created":[],"updated":[],"deleted":[]}}],"jobdetailsarray":[{"bm_jobdetails":{"created":[],"updated":[{"jd_id":13553,"jd_updatedby":2,"jd_additionalcontacts":"12663","jd_listprice":"2625.25","jd_netprice":"2625.25","jd_vat":"525.04","jd_grossprice":"3150.29","jd_costprice":"1218.58","jd_amountoutstanding":"3150.29","jd_duedate":"2026-01-16"},{"jd_id":13555,"jd_updatedby":2,"jd_additionalcontacts":"4810","jd_listprice":"1436.00","jd_netprice":"1436.00","jd_vat":"287.20","jd_grossprice":"1723.20","jd_costprice":"680.40","jd_amountoutstanding":"1723.20","jd_duedate":"2026-01-16"}],"deleted":[]},"bm_jobmultiquote":{"created":[],"updated":[{"jmq_id":13646,"jmq_jobid":13553,"jmq_updatedby":null,"jmq_listprice":"2625.25","jmq_netprice":"2625.25","jmq_vat":"525.04","jmq_overridetypeid":1,"jmq_grossprice":"3150.29","jmq_costprice":"1218.58","jmq_amountoutstanding":"3150.29","jmq_duedate":"0000-00-00","jmq_sceduleddate":"0000-00-00"},{"jmq_id":13648,"jmq_jobid":13555,"jmq_updatedby":null,"jmq_listprice":"1436.00","jmq_netprice":"1436.00","jmq_vat":"287.20","jmq_overridetypeid":1,"jmq_grossprice":"1723.20","jmq_costprice":"680.40","jmq_amountoutstanding":"1723.20","jmq_duedate":"0000-00-00","jmq_sceduleddate":"0000-00-00"}],"deleted":[]},"bm_appointment":{"created":[],"updated":[],"deleted":[]},"bm_notelist":{"created":[],"updated":[],"deleted":[]},"bm_job_paymentlist":{"created":[],"updated":[],"deleted":[]},"bm_paymentlist":{"created":[],"updated":[],"deleted":[]},"bm_orderitem":{"created":[{"oi_id":785626166070,"oi_qty":1,"oi_jobid":13555,"oi_jobtempid":"0","oi_jobmultiquoteid":13648,"oi_credit_id":0,"oi_productid":13,"oi_recipeid":13,"oi_ruleid":0,"oi_seq":1,"oi_customseq":1,"oi_productcustomseq":0,"oi_jsondata":"[{\"id\":1779,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":\"2\",\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1778,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1781,\"labelname\":\"Supplier\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":13221,\"labelname\":\"Supplier\",\"value\":434,\"valueid\":\"\",\"type\":17,\"optionid\":\"434\",\"optionvalue\":[{\"id\":434,\"optionid\":434,\"optionname\":\"STORTBLINDS\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1782,\"labelname\":\"ROOM\",\"value\":\"front right\",\"valueid\":\"\",\"type\":18,\"optionid\":\"front right\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1783,\"labelname\":\"EXACT OR RECESS\",\"value\":\"Exact Size\",\"valueid\":\"2357\",\"type\":3,\"optionid\":\"767\",\"optionvalue\":[{\"optionid\":767,\"optionname\":\"Exact Size\",\"description\":\"\",\"optioncode\":559,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2357,\"forchildfieldoptionlinkid\":\"3_2357\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1791,\"labelname\":\"PANEL STYLE\",\"value\":\"Split No mid rail\",\"valueid\":\"2164\",\"type\":21,\"optionid\":\"2164\",\"optionvalue\":[{\"optionid\":2164,\"optionname\":\"Split No mid rail\",\"optioncode\":1218,\"optionquantity\":1,\"fieldoptionlinkid\":2164,\"forchildfieldoptionlinkid\":\"21_2_2164_0\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":1,\"optionimage\":\"\",\"description\":\"\"}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1794,\"labelname\":\"Product\",\"value\":\"Rhapsody HPUPVC\",\"valueid\":\"9383\",\"type\":21,\"optionid\":\"9383\",\"optionvalue\":[{\"optionid\":9383,\"optionname\":\"Rhapsody HPUPVC\",\"optioncode\":31546,\"optionquantity\":1,\"fieldoptionlinkid\":9383,\"forchildfieldoptionlinkid\":\"21_9383\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":0,\"optionimage\":\"\",\"description\":\"\"}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1784,\"labelname\":\"WIDTH\",\"value\":\"1832\",\"valueid\":\"\",\"type\":8,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1785,\"labelname\":\"DROP\",\"value\":\"1033\",\"valueid\":\"\",\"type\":10,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1786,\"labelname\":\"COLOUR\",\"value\":\"Vivid White\",\"valueid\":\"2367\",\"type\":3,\"optionid\":\"777\",\"optionvalue\":[{\"optionid\":777,\"optionname\":\"Vivid White\",\"description\":\"\",\"optioncode\":1750,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2367,\"forchildfieldoptionlinkid\":\"3_2367\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1787,\"labelname\":\"TILT ROD STYLE\",\"value\":\"Half Hidden\",\"valueid\":\"2382\",\"type\":3,\"optionid\":\"792\",\"optionvalue\":[{\"optionid\":792,\"optionname\":\"Half Hidden\",\"description\":\"\",\"optioncode\":7925,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2382,\"forchildfieldoptionlinkid\":\"3_2382\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":2382}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":13213,\"labelname\":\"PANEL LAYOUT\",\"value\":\"LTRTR\",\"valueid\":\"\",\"type\":18,\"optionid\":\"LTRTR\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1789,\"labelname\":\"PANEL STYLE\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1790,\"labelname\":\"LEAD TIME EST\",\"value\":\"12-16 weeks\",\"valueid\":\"2440\",\"type\":3,\"optionid\":\"850\",\"optionvalue\":[{\"optionid\":850,\"optionname\":\"12-16 weeks\",\"description\":\"\",\"optioncode\":3831,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":2440,\"forchildfieldoptionlinkid\":\"3_2440\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1796,\"labelname\":\"SLAT SIZE\",\"value\":\"63mm\",\"valueid\":\"2447\",\"type\":3,\"optionid\":\"853\",\"optionvalue\":[{\"optionid\":853,\"optionname\":\"63mm\",\"description\":\"\",\"optioncode\":562,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2447,\"forchildfieldoptionlinkid\":\"3_2447\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1797,\"labelname\":\"SPLIT HEIGHT\",\"value\":\"660\",\"valueid\":\"\",\"type\":18,\"optionid\":\"65\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1798,\"labelname\":\"T POSTS\",\"value\":\"603/1235\",\"valueid\":\"\",\"type\":18,\"optionid\":\"603/1235\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1799,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1800,\"labelname\":\"FRAME\",\"value\":\"L Frame with Double Insert 60mm\",\"valueid\":\"2495\",\"type\":3,\"optionid\":\"901\",\"optionvalue\":[{\"optionid\":901,\"optionname\":\"L Frame with Double Insert 60mm\",\"description\":\"\",\"optioncode\":8381,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2495,\"forchildfieldoptionlinkid\":\"3_2495\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":2495}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1801,\"labelname\":\"Hinge Colors\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1802,\"labelname\":\"Special Shapes\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1803,\"labelname\":\"Tracking Options\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1788,\"labelname\":\"PANEL\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1804,\"labelname\":\"Notes\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":13223,\"labelname\":\"Fitting Cost\",\"value\":25,\"valueid\":\"\",\"type\":6,\"optionid\":\"25\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]","oi_description":"ROOM: front right, EXACT OR RECESS: Exact Size, PANEL STYLE: Split No mid rail, Product: Rhapsody HPUPVC, WIDTH: 1832, DROP: 1033, COLOUR: Vivid White, TILT ROD STYLE: Half Hidden, PANEL LAYOUT: LTRTR, LEAD TIME EST: 12-16 weeks, SLAT SIZE: 63mm, SPLIT HEIGHT: 660, T POSTS: 603/1235, FRAME: L Frame with Double Insert 60mm, Fitting Cost: 25","oi_reportdescription":"##Quantity: 1##,##ROOM: front right##,##EXACT OR RECESS: Exact Size##,##PANEL STYLE: Split No mid rail##,##Product: Rhapsody HPUPVC##,##WIDTH: 1832 mm##,##DROP: 1033 mm##,##COLOUR: Vivid White##,##TILT ROD STYLE: Half Hidden##,##PANEL LAYOUT: LTRTR##,##LEAD TIME EST: 12-16 weeks##,##SLAT SIZE: 63mm##,##SPLIT HEIGHT: 660##,##T POSTS: 603/1235##,##FRAME: L Frame with Double Insert 60mm##,##Fitting Cost: 25##","oi_reporttitles":"##Quantity:<br/>##ROOM:<br/>##EXACT OR RECESS:<br/>##PANEL STYLE:<br/>##Product:<br/>##WIDTH:<br/>##DROP:<br/>##COLOUR:<br/>##TILT ROD STYLE:<br/>##PANEL LAYOUT:<br/>##LEAD TIME EST:<br/>##SLAT SIZE:<br/>##SPLIT HEIGHT:<br/>##T POSTS:<br/>##FRAME:<br/>##Fitting Cost:","oi_productionformulajsondata":"[{\"productionoveride\":0,\"id\":63,\"value\":\"25.00\",\"formula\":\"FittingCost\",\"price\":\"\",\"recipeid\":13,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"25.00\"},{\"productionoveride\":0,\"id\":128,\"value\":\"\",\"formula\":\"If(TILTRODSTYLE=\\\"RPS\\\",(SeparatePrice*(WIDTH*DROP))*0.1,0)*Quantity\",\"price\":\"\",\"recipeid\":13,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":0},{\"productionoveride\":0,\"id\":131,\"value\":\"\",\"formula\":\"If(TILTRODSTYLE=\\\"RPSHamptonNevada\\\",(SeparatePrice*(WIDTH*DROP))*0.15,0)*Quantity\",\"price\":\"\",\"recipeid\":13,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":0}]","oi_productiondate":"2026-01-16 11:23:35","oi_operationstatus":null,"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\":\"198.45\",\"show_hide\":true,\"category\":5}","oi_productionstatus":null,"oi_costoverride":0,"oi_costprice":"198.450","oi_netprice":"403.000","oi_pricesfromoperations":null,"oi_vatprice":"80.600","oi_vatvalue":"20.000","oi_vatselected":1,"oi_vattype":1,"oi_vatonoff":1,"oi_grossprice":"483.600","oi_overrideprice":"0.000","oi_overridetype":2,"oi_overridevalue":null,"oi_overridenetprice":"0.000","oi_overridevatprice":"0.000","oi_overridegrossprice":"0.000","oi_ready":0,"oi_onhold":0,"oi_copiedfrom":0,"oi_isonlineorder":0,"oi_endcustomervatprice":null,"oi_endcustomeroverridetype":2,"oi_endcustomeroverridevalue":null,"oi_endcustomeroverridenetprice":"403.000","oi_endcustomeroverridevatprice":"80.600","oi_endcustomeroverridegrossprice":"483.600","oi_sage_flag":0,"oi_status":0,"oi_createdby":5,"oi_createdat":"2026-01-16 11:23:36","oi_updatedby":5,"oi_jsondataid":null,"oi_deviceplatform":2,"oi_editransfer":0,"oi_apisup_orderid":0,"oi_commissionprice":"0.000","oi_commissionvatprice":"0.000"},{"oi_id":785629912290,"oi_qty":1,"oi_jobid":13555,"oi_jobtempid":"0","oi_jobmultiquoteid":13648,"oi_credit_id":0,"oi_productid":13,"oi_recipeid":13,"oi_ruleid":0,"oi_seq":2,"oi_customseq":2,"oi_productcustomseq":0,"oi_jsondata":"[{\"id\":1779,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":\"2\",\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1778,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1781,\"labelname\":\"Supplier\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":13221,\"labelname\":\"Supplier\",\"value\":434,\"valueid\":\"\",\"type\":17,\"optionid\":\"434\",\"optionvalue\":[{\"id\":434,\"optionid\":434,\"optionname\":\"STORTBLINDS\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1782,\"labelname\":\"ROOM\",\"value\":\"bathroom \",\"valueid\":\"\",\"type\":18,\"optionid\":\"front right\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1783,\"labelname\":\"EXACT OR RECESS\",\"value\":\"Exact Size\",\"valueid\":\"2357\",\"type\":3,\"optionid\":\"767\",\"optionvalue\":[{\"optionid\":767,\"optionname\":\"Exact Size\",\"description\":\"\",\"optioncode\":559,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2357,\"forchildfieldoptionlinkid\":\"3_2357\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1791,\"labelname\":\"PANEL STYLE\",\"value\":\"Split No mid rail\",\"valueid\":\"2164\",\"type\":21,\"optionid\":\"2164\",\"optionvalue\":[{\"optionid\":2164,\"optionname\":\"Split No mid rail\",\"optioncode\":1218,\"optionquantity\":1,\"fieldoptionlinkid\":2164,\"forchildfieldoptionlinkid\":\"21_2_2164_0\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":1,\"optionimage\":\"\",\"description\":\"\"}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1794,\"labelname\":\"Product\",\"value\":\"Rhapsody HPUPVC\",\"valueid\":\"9383\",\"type\":21,\"optionid\":\"9383\",\"optionvalue\":[{\"optionid\":9383,\"optionname\":\"Rhapsody HPUPVC\",\"optioncode\":31546,\"optionquantity\":1,\"fieldoptionlinkid\":9383,\"forchildfieldoptionlinkid\":\"21_9383\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":0,\"optionimage\":\"\",\"description\":\"\"}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1784,\"labelname\":\"WIDTH\",\"value\":\"1166\",\"valueid\":\"\",\"type\":8,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1785,\"labelname\":\"DROP\",\"value\":\"982\",\"valueid\":\"\",\"type\":10,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1786,\"labelname\":\"COLOUR\",\"value\":\"Vivid White\",\"valueid\":\"2367\",\"type\":3,\"optionid\":\"777\",\"optionvalue\":[{\"optionid\":777,\"optionname\":\"Vivid White\",\"description\":\"\",\"optioncode\":1750,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2367,\"forchildfieldoptionlinkid\":\"3_2367\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1787,\"labelname\":\"TILT ROD STYLE\",\"value\":\"Half Hidden\",\"valueid\":\"2382\",\"type\":3,\"optionid\":\"792\",\"optionvalue\":[{\"optionid\":792,\"optionname\":\"Half Hidden\",\"description\":\"\",\"optioncode\":7925,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2382,\"forchildfieldoptionlinkid\":\"3_2382\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":2382}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":13213,\"labelname\":\"PANEL LAYOUT\",\"value\":\"LR\",\"valueid\":\"\",\"type\":18,\"optionid\":\"LTRTR\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1789,\"labelname\":\"PANEL STYLE\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1790,\"labelname\":\"LEAD TIME EST\",\"value\":\"12-16 weeks\",\"valueid\":\"2440\",\"type\":3,\"optionid\":\"850\",\"optionvalue\":[{\"optionid\":850,\"optionname\":\"12-16 weeks\",\"description\":\"\",\"optioncode\":3831,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":2440,\"forchildfieldoptionlinkid\":\"3_2440\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1796,\"labelname\":\"SLAT SIZE\",\"value\":\"63mm\",\"valueid\":\"2447\",\"type\":3,\"optionid\":\"853\",\"optionvalue\":[{\"optionid\":853,\"optionname\":\"63mm\",\"description\":\"\",\"optioncode\":562,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2447,\"forchildfieldoptionlinkid\":\"3_2447\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1797,\"labelname\":\"SPLIT HEIGHT\",\"value\":\"660\",\"valueid\":\"\",\"type\":18,\"optionid\":\"660\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1798,\"labelname\":\"T POSTS\",\"value\":\"nil\",\"valueid\":\"\",\"type\":18,\"optionid\":\"603/1235\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1799,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1800,\"labelname\":\"FRAME\",\"value\":\"L Frame with Double Insert 60mm\",\"valueid\":\"2495\",\"type\":3,\"optionid\":\"901\",\"optionvalue\":[{\"optionid\":901,\"optionname\":\"L Frame with Double Insert 60mm\",\"description\":\"\",\"optioncode\":8381,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2495,\"forchildfieldoptionlinkid\":\"3_2495\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":2495}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1801,\"labelname\":\"Hinge Colors\",\"value\":\"White\",\"valueid\":\"2496\",\"type\":3,\"optionid\":\"902\",\"optionvalue\":[{\"optionid\":902,\"optionname\":\"White\",\"description\":\"\",\"optioncode\":1749,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":2496,\"forchildfieldoptionlinkid\":\"3_2496\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1802,\"labelname\":\"Special Shapes\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1803,\"labelname\":\"Tracking Options\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1788,\"labelname\":\"PANEL\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1804,\"labelname\":\"Notes\",\"value\":\"white silicone \",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":13223,\"labelname\":\"Fitting Cost\",\"value\":25,\"valueid\":\"\",\"type\":6,\"optionid\":\"25\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]","oi_description":"ROOM: bathroom , EXACT OR RECESS: Exact Size, PANEL STYLE: Split No mid rail, Product: Rhapsody HPUPVC, WIDTH: 1166, DROP: 982, COLOUR: Vivid White, TILT ROD STYLE: Half Hidden, PANEL LAYOUT: LR, LEAD TIME EST: 12-16 weeks, SLAT SIZE: 63mm, SPLIT HEIGHT: 660, T POSTS: nil, FRAME: L Frame with Double Insert 60mm, Hinge Colors: White, Notes: white silicone , Fitting Cost: 25","oi_reportdescription":"##Quantity: 1##,##ROOM: bathroom ##,##EXACT OR RECESS: Exact Size##,##PANEL STYLE: Split No mid rail##,##Product: Rhapsody HPUPVC##,##WIDTH: 1166 mm##,##DROP: 982 mm##,##COLOUR: Vivid White##,##TILT ROD STYLE: Half Hidden##,##PANEL LAYOUT: LR##,##LEAD TIME EST: 12-16 weeks##,##SLAT SIZE: 63mm##,##SPLIT HEIGHT: 660##,##T POSTS: nil##,##FRAME: L Frame with Double Insert 60mm##,##Hinge Colors: White##,##Notes: white silicone ##,##Fitting Cost: 25##","oi_reporttitles":"##Quantity:<br/>##ROOM:<br/>##EXACT OR RECESS:<br/>##PANEL STYLE:<br/>##Product:<br/>##WIDTH:<br/>##DROP:<br/>##COLOUR:<br/>##TILT ROD STYLE:<br/>##PANEL LAYOUT:<br/>##LEAD TIME EST:<br/>##SLAT SIZE:<br/>##SPLIT HEIGHT:<br/>##T POSTS:<br/>##FRAME:<br/>##Hinge Colors:<br/>##Notes:<br/>##Fitting Cost:","oi_productionformulajsondata":"[{\"productionoveride\":0,\"id\":63,\"value\":\"25.00\",\"formula\":\"FittingCost\",\"price\":\"\",\"recipeid\":13,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"25.00\"},{\"productionoveride\":0,\"id\":128,\"value\":\"\",\"formula\":\"If(TILTRODSTYLE=\\\"RPS\\\",(SeparatePrice*(WIDTH*DROP))*0.1,0)*Quantity\",\"price\":\"\",\"recipeid\":13,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":0},{\"productionoveride\":0,\"id\":131,\"value\":\"\",\"formula\":\"If(TILTRODSTYLE=\\\"RPSHamptonNevada\\\",(SeparatePrice*(WIDTH*DROP))*0.15,0)*Quantity\",\"price\":\"\",\"recipeid\":13,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":0}]","oi_productiondate":"2026-01-16 11:23:35","oi_operationstatus":null,"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\":\"120.75\",\"show_hide\":true,\"category\":5}","oi_productionstatus":null,"oi_costoverride":0,"oi_costprice":"120.750","oi_netprice":"255.000","oi_pricesfromoperations":null,"oi_vatprice":"51.000","oi_vatvalue":"20.000","oi_vatselected":1,"oi_vattype":1,"oi_vatonoff":1,"oi_grossprice":"306.000","oi_overrideprice":"0.000","oi_overridetype":2,"oi_overridevalue":null,"oi_overridenetprice":"0.000","oi_overridevatprice":"0.000","oi_overridegrossprice":"0.000","oi_ready":0,"oi_onhold":0,"oi_copiedfrom":0,"oi_isonlineorder":0,"oi_endcustomervatprice":null,"oi_endcustomeroverridetype":2,"oi_endcustomeroverridevalue":null,"oi_endcustomeroverridenetprice":"255.000","oi_endcustomeroverridevatprice":"51.000","oi_endcustomeroverridegrossprice":"306.000","oi_sage_flag":0,"oi_status":0,"oi_createdby":5,"oi_createdat":"2026-01-16 11:29:51","oi_updatedby":null,"oi_jsondataid":null,"oi_deviceplatform":2,"oi_editransfer":0,"oi_apisup_orderid":0,"oi_commissionprice":"0.000","oi_commissionvatprice":"0.000"},{"oi_id":785631533330,"oi_qty":1,"oi_jobid":13555,"oi_jobtempid":"0","oi_jobmultiquoteid":13648,"oi_credit_id":0,"oi_productid":13,"oi_recipeid":13,"oi_ruleid":0,"oi_seq":3,"oi_customseq":3,"oi_productcustomseq":0,"oi_jsondata":"[{\"id\":1779,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":\"2\",\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1778,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1781,\"labelname\":\"Supplier\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":13221,\"labelname\":\"Supplier\",\"value\":434,\"valueid\":\"\",\"type\":17,\"optionid\":\"434\",\"optionvalue\":[{\"id\":434,\"optionid\":434,\"optionname\":\"STORTBLINDS\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1782,\"labelname\":\"ROOM\",\"value\":\"landing\",\"valueid\":\"\",\"type\":18,\"optionid\":\"bathroom \",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1783,\"labelname\":\"EXACT OR RECESS\",\"value\":\"Exact Size\",\"valueid\":\"2357\",\"type\":3,\"optionid\":\"767\",\"optionvalue\":[{\"optionid\":767,\"optionname\":\"Exact Size\",\"description\":\"\",\"optioncode\":559,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2357,\"forchildfieldoptionlinkid\":\"3_2357\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1791,\"labelname\":\"PANEL STYLE\",\"value\":\"Split No mid rail\",\"valueid\":\"2164\",\"type\":21,\"optionid\":\"2164\",\"optionvalue\":[{\"optionid\":2164,\"optionname\":\"Split No mid rail\",\"optioncode\":1218,\"optionquantity\":1,\"fieldoptionlinkid\":2164,\"forchildfieldoptionlinkid\":\"21_2_2164_0\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":1,\"optionimage\":\"\",\"description\":\"\"}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1794,\"labelname\":\"Product\",\"value\":\"Rhapsody HPUPVC\",\"valueid\":\"9383\",\"type\":21,\"optionid\":\"9383\",\"optionvalue\":[{\"optionid\":9383,\"optionname\":\"Rhapsody HPUPVC\",\"optioncode\":31546,\"optionquantity\":1,\"fieldoptionlinkid\":9383,\"forchildfieldoptionlinkid\":\"21_9383\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":0,\"optionimage\":\"\",\"description\":\"\"}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1784,\"labelname\":\"WIDTH\",\"value\":\"1215\",\"valueid\":\"\",\"type\":8,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1785,\"labelname\":\"DROP\",\"value\":\"1037\",\"valueid\":\"\",\"type\":10,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1786,\"labelname\":\"COLOUR\",\"value\":\"Vivid White\",\"valueid\":\"2367\",\"type\":3,\"optionid\":\"777\",\"optionvalue\":[{\"optionid\":777,\"optionname\":\"Vivid White\",\"description\":\"\",\"optioncode\":1750,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2367,\"forchildfieldoptionlinkid\":\"3_2367\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1787,\"labelname\":\"TILT ROD STYLE\",\"value\":\"Half Hidden\",\"valueid\":\"2382\",\"type\":3,\"optionid\":\"792\",\"optionvalue\":[{\"optionid\":792,\"optionname\":\"Half Hidden\",\"description\":\"\",\"optioncode\":7925,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2382,\"forchildfieldoptionlinkid\":\"3_2382\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":2382}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":13213,\"labelname\":\"PANEL LAYOUT\",\"value\":\"LR\",\"valueid\":\"\",\"type\":18,\"optionid\":\"LR\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1789,\"labelname\":\"PANEL STYLE\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1790,\"labelname\":\"LEAD TIME EST\",\"value\":\"12-16 weeks\",\"valueid\":\"2440\",\"type\":3,\"optionid\":\"850\",\"optionvalue\":[{\"optionid\":850,\"optionname\":\"12-16 weeks\",\"description\":\"\",\"optioncode\":3831,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":2440,\"forchildfieldoptionlinkid\":\"3_2440\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1796,\"labelname\":\"SLAT SIZE\",\"value\":\"63mm\",\"valueid\":\"2447\",\"type\":3,\"optionid\":\"853\",\"optionvalue\":[{\"optionid\":853,\"optionname\":\"63mm\",\"description\":\"\",\"optioncode\":562,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2447,\"forchildfieldoptionlinkid\":\"3_2447\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1797,\"labelname\":\"SPLIT HEIGHT\",\"value\":\"nil\",\"valueid\":\"\",\"type\":18,\"optionid\":\"660\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1798,\"labelname\":\"T POSTS\",\"value\":\"nil\",\"valueid\":\"\",\"type\":18,\"optionid\":\"nil\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1799,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1800,\"labelname\":\"FRAME\",\"value\":\"L Frame with Double Insert 60mm\",\"valueid\":\"2495\",\"type\":3,\"optionid\":\"901\",\"optionvalue\":[{\"optionid\":901,\"optionname\":\"L Frame with Double Insert 60mm\",\"description\":\"\",\"optioncode\":8381,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2495,\"forchildfieldoptionlinkid\":\"3_2495\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":2495}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1801,\"labelname\":\"Hinge Colors\",\"value\":\"White\",\"valueid\":\"2496\",\"type\":3,\"optionid\":\"902\",\"optionvalue\":[{\"optionid\":902,\"optionname\":\"White\",\"description\":\"\",\"optioncode\":1749,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2496,\"forchildfieldoptionlinkid\":\"3_2496\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1802,\"labelname\":\"Special Shapes\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1803,\"labelname\":\"Tracking Options\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1788,\"labelname\":\"PANEL\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1804,\"labelname\":\"Notes\",\"value\":\"high up on stairs need adjustable ladders\",\"valueid\":\"\",\"type\":18,\"optionid\":\"white silicone \",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":13223,\"labelname\":\"Fitting Cost\",\"value\":\"65\",\"valueid\":\"\",\"type\":6,\"optionid\":\"25\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1}]","oi_description":"ROOM: landing, EXACT OR RECESS: Exact Size, PANEL STYLE: Split No mid rail, Product: Rhapsody HPUPVC, WIDTH: 1215, DROP: 1037, COLOUR: Vivid White, TILT ROD STYLE: Half Hidden, PANEL LAYOUT: LR, LEAD TIME EST: 12-16 weeks, SLAT SIZE: 63mm, SPLIT HEIGHT: nil, T POSTS: nil, FRAME: L Frame with Double Insert 60mm, Hinge Colors: White, Notes: high up on stairs need adjustable ladders, Fitting Cost: 65","oi_reportdescription":"##Quantity: 1##,##ROOM: landing##,##EXACT OR RECESS: Exact Size##,##PANEL STYLE: Split No mid rail##,##Product: Rhapsody HPUPVC##,##WIDTH: 1215 mm##,##DROP: 1037 mm##,##COLOUR: Vivid White##,##TILT ROD STYLE: Half Hidden##,##PANEL LAYOUT: LR##,##LEAD TIME EST: 12-16 weeks##,##SLAT SIZE: 63mm##,##SPLIT HEIGHT: nil##,##T POSTS: nil##,##FRAME: L Frame with Double Insert 60mm##,##Hinge Colors: White##,##Notes: high up on stairs need adjustable ladders##,##Fitting Cost: 65##","oi_reporttitles":"##Quantity:<br/>##ROOM:<br/>##EXACT OR RECESS:<br/>##PANEL STYLE:<br/>##Product:<br/>##WIDTH:<br/>##DROP:<br/>##COLOUR:<br/>##TILT ROD STYLE:<br/>##PANEL LAYOUT:<br/>##LEAD TIME EST:<br/>##SLAT SIZE:<br/>##SPLIT HEIGHT:<br/>##T POSTS:<br/>##FRAME:<br/>##Hinge Colors:<br/>##Notes:<br/>##Fitting Cost:","oi_productionformulajsondata":"[{\"productionoveride\":0,\"id\":63,\"value\":\"65.00\",\"formula\":\"FittingCost\",\"price\":\"\",\"recipeid\":13,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"65.00\"},{\"productionoveride\":0,\"id\":128,\"value\":\"\",\"formula\":\"If(TILTRODSTYLE=\\\"RPS\\\",(SeparatePrice*(WIDTH*DROP))*0.1,0)*Quantity\",\"price\":\"\",\"recipeid\":13,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":0},{\"productionoveride\":0,\"id\":131,\"value\":\"\",\"formula\":\"If(TILTRODSTYLE=\\\"RPSHamptonNevada\\\",(SeparatePrice*(WIDTH*DROP))*0.15,0)*Quantity\",\"price\":\"\",\"recipeid\":13,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":0}]","oi_productiondate":"2026-01-16 11:23:35","oi_operationstatus":null,"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\":\"132.30\",\"show_hide\":true,\"category\":5}","oi_productionstatus":null,"oi_costoverride":0,"oi_costprice":"132.300","oi_netprice":"317.000","oi_pricesfromoperations":null,"oi_vatprice":"63.400","oi_vatvalue":"20.000","oi_vatselected":1,"oi_vattype":1,"oi_vatonoff":1,"oi_grossprice":"380.400","oi_overrideprice":"0.000","oi_overridetype":2,"oi_overridevalue":null,"oi_overridenetprice":"0.000","oi_overridevatprice":"0.000","oi_overridegrossprice":"0.000","oi_ready":0,"oi_onhold":0,"oi_copiedfrom":0,"oi_isonlineorder":0,"oi_endcustomervatprice":null,"oi_endcustomeroverridetype":2,"oi_endcustomeroverridevalue":null,"oi_endcustomeroverridenetprice":"317.000","oi_endcustomeroverridevatprice":"63.400","oi_endcustomeroverridegrossprice":"380.400","oi_sage_flag":0,"oi_status":0,"oi_createdby":5,"oi_createdat":"2026-01-16 11:32:33","oi_updatedby":null,"oi_jsondataid":null,"oi_deviceplatform":2,"oi_editransfer":0,"oi_apisup_orderid":0,"oi_commissionprice":"0.000","oi_commissionvatprice":"0.000"},{"oi_id":785632595310,"oi_qty":1,"oi_jobid":13555,"oi_jobtempid":"0","oi_jobmultiquoteid":13648,"oi_credit_id":0,"oi_productid":13,"oi_recipeid":13,"oi_ruleid":0,"oi_seq":4,"oi_customseq":4,"oi_productcustomseq":0,"oi_jsondata":"[{\"id\":1779,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":\"2\",\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1778,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1781,\"labelname\":\"Supplier\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":13221,\"labelname\":\"Supplier\",\"value\":434,\"valueid\":\"\",\"type\":17,\"optionid\":\"434\",\"optionvalue\":[{\"id\":434,\"optionid\":434,\"optionname\":\"STORTBLINDS\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1782,\"labelname\":\"ROOM\",\"value\":\"lounge\",\"valueid\":\"\",\"type\":18,\"optionid\":\"front right\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1783,\"labelname\":\"EXACT OR RECESS\",\"value\":\"Exact Size\",\"valueid\":\"2357\",\"type\":3,\"optionid\":\"767\",\"optionvalue\":[{\"optionid\":767,\"optionname\":\"Exact Size\",\"description\":\"\",\"optioncode\":559,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2357,\"forchildfieldoptionlinkid\":\"3_2357\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1791,\"labelname\":\"PANEL STYLE\",\"value\":\"Split No mid rail\",\"valueid\":\"2164\",\"type\":21,\"optionid\":\"2164\",\"optionvalue\":[{\"optionid\":2164,\"optionname\":\"Split No mid rail\",\"optioncode\":1218,\"optionquantity\":1,\"fieldoptionlinkid\":2164,\"forchildfieldoptionlinkid\":\"21_2_2164_0\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":1,\"optionimage\":\"\",\"description\":\"\"}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1794,\"labelname\":\"Product\",\"value\":\"Rhapsody HPUPVC\",\"valueid\":\"9383\",\"type\":21,\"optionid\":\"9383\",\"optionvalue\":[{\"optionid\":9383,\"optionname\":\"Rhapsody HPUPVC\",\"optioncode\":31546,\"optionquantity\":1,\"fieldoptionlinkid\":9383,\"forchildfieldoptionlinkid\":\"21_9383\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":0,\"optionimage\":\"\",\"description\":\"\"}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1784,\"labelname\":\"WIDTH\",\"value\":\"1838\",\"valueid\":\"\",\"type\":8,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1785,\"labelname\":\"DROP\",\"value\":\"1185\",\"valueid\":\"\",\"type\":10,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1786,\"labelname\":\"COLOUR\",\"value\":\"Vivid White\",\"valueid\":\"2367\",\"type\":3,\"optionid\":\"777\",\"optionvalue\":[{\"optionid\":777,\"optionname\":\"Vivid White\",\"description\":\"\",\"optioncode\":1750,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2367,\"forchildfieldoptionlinkid\":\"3_2367\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1787,\"labelname\":\"TILT ROD STYLE\",\"value\":\"Half Hidden\",\"valueid\":\"2382\",\"type\":3,\"optionid\":\"792\",\"optionvalue\":[{\"optionid\":792,\"optionname\":\"Half Hidden\",\"description\":\"\",\"optioncode\":7925,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2382,\"forchildfieldoptionlinkid\":\"3_2382\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":2382}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":13213,\"labelname\":\"PANEL LAYOUT\",\"value\":\"LTRTR\",\"valueid\":\"\",\"type\":18,\"optionid\":\"LTRTR\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1789,\"labelname\":\"PANEL STYLE\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1790,\"labelname\":\"LEAD TIME EST\",\"value\":\"12-16 weeks\",\"valueid\":\"2440\",\"type\":3,\"optionid\":\"850\",\"optionvalue\":[{\"optionid\":850,\"optionname\":\"12-16 weeks\",\"description\":\"\",\"optioncode\":3831,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":2440,\"forchildfieldoptionlinkid\":\"3_2440\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1796,\"labelname\":\"SLAT SIZE\",\"value\":\"63mm\",\"valueid\":\"2447\",\"type\":3,\"optionid\":\"853\",\"optionvalue\":[{\"optionid\":853,\"optionname\":\"63mm\",\"description\":\"\",\"optioncode\":562,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2447,\"forchildfieldoptionlinkid\":\"3_2447\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1797,\"labelname\":\"SPLIT HEIGHT\",\"value\":\"660\",\"valueid\":\"\",\"type\":18,\"optionid\":\"660\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1798,\"labelname\":\"T POSTS\",\"value\":\"585/1250\",\"valueid\":\"\",\"type\":18,\"optionid\":\"603/1235\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1799,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1800,\"labelname\":\"FRAME\",\"value\":\"L Frame with Double Insert 60mm\",\"valueid\":\"2495\",\"type\":3,\"optionid\":\"901\",\"optionvalue\":[{\"optionid\":901,\"optionname\":\"L Frame with Double Insert 60mm\",\"description\":\"\",\"optioncode\":8381,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":2495,\"forchildfieldoptionlinkid\":\"3_2495\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":2495}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":1801,\"labelname\":\"Hinge Colors\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1802,\"labelname\":\"Special Shapes\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1803,\"labelname\":\"Tracking Options\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1788,\"labelname\":\"PANEL\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1804,\"labelname\":\"Notes\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":13223,\"labelname\":\"Fitting Cost\",\"value\":25,\"valueid\":\"\",\"type\":6,\"optionid\":\"25\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]","oi_description":"ROOM: lounge, EXACT OR RECESS: Exact Size, PANEL STYLE: Split No mid rail, Product: Rhapsody HPUPVC, WIDTH: 1838, DROP: 1185, COLOUR: Vivid White, TILT ROD STYLE: Half Hidden, PANEL LAYOUT: LTRTR, LEAD TIME EST: 12-16 weeks, SLAT SIZE: 63mm, SPLIT HEIGHT: 660, T POSTS: 585/1250, FRAME: L Frame with Double Insert 60mm, Fitting Cost: 25","oi_reportdescription":"##Quantity: 1##,##ROOM: lounge##,##EXACT OR RECESS: Exact Size##,##PANEL STYLE: Split No mid rail##,##Product: Rhapsody HPUPVC##,##WIDTH: 1838 mm##,##DROP: 1185 mm##,##COLOUR: Vivid White##,##TILT ROD STYLE: Half Hidden##,##PANEL LAYOUT: LTRTR##,##LEAD TIME EST: 12-16 weeks##,##SLAT SIZE: 63mm##,##SPLIT HEIGHT: 660##,##T POSTS: 585/1250##,##FRAME: L Frame with Double Insert 60mm##,##Fitting Cost: 25##","oi_reporttitles":"##Quantity:<br/>##ROOM:<br/>##EXACT OR RECESS:<br/>##PANEL STYLE:<br/>##Product:<br/>##WIDTH:<br/>##DROP:<br/>##COLOUR:<br/>##TILT ROD STYLE:<br/>##PANEL LAYOUT:<br/>##LEAD TIME EST:<br/>##SLAT SIZE:<br/>##SPLIT HEIGHT:<br/>##T POSTS:<br/>##FRAME:<br/>##Fitting Cost:","oi_productionformulajsondata":"[{\"productionoveride\":0,\"id\":63,\"value\":\"25.00\",\"formula\":\"FittingCost\",\"price\":\"\",\"recipeid\":13,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"25.00\"},{\"productionoveride\":0,\"id\":128,\"value\":\"\",\"formula\":\"If(TILTRODSTYLE=\\\"RPS\\\",(SeparatePrice*(WIDTH*DROP))*0.1,0)*Quantity\",\"price\":\"\",\"recipeid\":13,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":0},{\"productionoveride\":0,\"id\":131,\"value\":\"\",\"formula\":\"If(TILTRODSTYLE=\\\"RPSHamptonNevada\\\",(SeparatePrice*(WIDTH*DROP))*0.15,0)*Quantity\",\"price\":\"\",\"recipeid\":13,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":0}]","oi_productiondate":"2026-01-16 11:23:35","oi_operationstatus":null,"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\":\"228.90\",\"show_hide\":true,\"category\":5}","oi_productionstatus":null,"oi_costoverride":0,"oi_costprice":"228.900","oi_netprice":"461.000","oi_pricesfromoperations":null,"oi_vatprice":"92.200","oi_vatvalue":"20.000","oi_vatselected":1,"oi_vattype":1,"oi_vatonoff":1,"oi_grossprice":"553.200","oi_overrideprice":"0.000","oi_overridetype":2,"oi_overridevalue":null,"oi_overridenetprice":"0.000","oi_overridevatprice":"0.000","oi_overridegrossprice":"0.000","oi_ready":0,"oi_onhold":0,"oi_copiedfrom":0,"oi_isonlineorder":0,"oi_endcustomervatprice":null,"oi_endcustomeroverridetype":2,"oi_endcustomeroverridevalue":null,"oi_endcustomeroverridenetprice":"461.000","oi_endcustomeroverridevatprice":"92.200","oi_endcustomeroverridegrossprice":"553.200","oi_sage_flag":0,"oi_status":0,"oi_createdby":5,"oi_createdat":"2026-01-16 11:34:19","oi_updatedby":null,"oi_jsondataid":null,"oi_deviceplatform":2,"oi_editransfer":0,"oi_apisup_orderid":0,"oi_commissionprice":"0.000","oi_commissionvatprice":"0.000"},{"oi_id":785638668110,"oi_qty":1,"oi_jobid":13553,"oi_jobtempid":"0","oi_jobmultiquoteid":13646,"oi_credit_id":0,"oi_productid":13,"oi_recipeid":13,"oi_ruleid":0,"oi_seq":1,"oi_customseq":1,"oi_productcustomseq":0,"oi_jsondata":"[{\"id\":1779,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":\"2\",\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1778,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":1781,\"labelname\":\"Supplier\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfract, 1970-01-01 00:00:00, ?, , 2026-01-16 12:07:04))----760---/var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php for database: STORTBLINDS