[2026-01-08 12:15: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":14521,"jd_customerid":6567,"jd_contactid":8172,"jd_additionalcontacts":"8172","jd_templateid":1,"jd_jobcustomoizedkeyvalue":"{\"33\":25,\"37\":1,\"39\":1,\"41\":3,\"44\":\"\",\"45\":\"Paul\",\"46\":\"Downing\",\"47\":\"\",\"48\":\"paul_dowling@hotmail.com\",\"49\":\"30 Waltham Drive\",\"50\":\"Elstow\",\"51\":\"Bedford\",\"52\":\"\",\"53\":\"MK42 9GA\",\"54\":19,\"285\":1,\"286\":\"07507594900\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"616\":\"\"}","jd_deletedcustokeyvalue":"{}","jd_createddate":"2026-01-05","jd_orderdate":null,"jd_sceduleddate":null,"jd_invoicedate":null,"jd_completeddate":null,"jd_jobstatus":1,"jd_contactaddid":0,"jd_orderstatus":3,"jd_listprice":"2941.96","jd_netprice":"2941.96","jd_vat":"588.44","jd_isvaton":1,"jd_deliverycost":"0.00","jd_deliverycosttypeid":1,"jd_overridetypeid":1,"jd_orderformprice":"0.00","jd_editpricebyid":0,"jd_isroundon":0,"jd_grossprice":"3530.40","jd_grossprofit":"0.00","jd_costprice":"1662.57","jd_overrideprice":null,"jd_overridenetprice":null,"jd_overridevatprice":null,"jd_overridegrossprice":null,"jd_amountoutstanding":"3530.40","jd_totpaid":"0.00","jd_creditlimit":"0.00","jd_creditbalance":"0.00","jd_overdue":"0.00","jd_userdefinedarray":"\"\"","jd_deliverycostid":0,"jd_iscostpriceon":0,"jd_isonlineorder":1,"jd_isonlineordersubmitted":0,"jd_endcustomervatprice":null,"jd_endcustomeroverridetype":1,"jd_endcustomeroverridevalue":null,"jd_endcustomeroverridenetprice":"0.00","jd_endcustomeroverridevatprice":"0.00","jd_endcustomeroverridegrossprice":"0.00","jd_endcustomerdeliverycost":null,"jd_endcustomerdeliverycostinclvat":1,"jd_endcustomerfittingcost":null,"jd_endcustomerfittingcostinclvat":1,"jd_onlinedeliveryaddreddtype":0,"jd_onlinedeliveryaddreddid":0,"jd_seq":0,"jd_status":0,"jd_createdby":3,"jd_updatedby":3,"jd_deviceplatform":0,"jd_fromdbname":"","jd_importorder":0,"jd_quickquote":0,"jd_deliveryvatperc":"0.000","jd_cdeliveryvatperc":"0.000","jd_createdat":"2026-01-05 11:00:38","jd_duedate":"2026-01-08","jd_commission":"\"\"","jd_commissionsetting":0,"jd_commissionprice":"0.00","jd_commissionaddedvalue":"0.00","jd_organizationid":25,"jd_jobref":"12915","jd_accref":"DOWN0002"}],"deleted":[]},"bm_jobmultiquote":{"created":[],"updated":[{"jmq_id":14527,"jmq_jobid":14521,"jmq_quotationname":"Q1","jmq_isdefault":0,"jmq_isaccepted":1,"jmq_isdeclined":0,"jmq_acceptanceplatform":0,"jmq_ismigrated":0,"jmq_duedate":"0000-00-00","jmq_sceduleddate":"0000-00-00","jmq_listprice":"2941.96","jmq_netprice":"2941.96","jmq_vat":"588.44","jmq_isvaton":1,"jmq_deliverycost":"0.00","jmq_deliverycosttypeid":1,"jmq_overridetypeid":1,"jmq_orderformprice":"0.00","jmq_editpricebyid":0,"jmq_isroundon":0,"jmq_grossprice":"3530.40","jmq_grossprofit":"0.00","jmq_costprice":"1662.57","jmq_overrideprice":"","jmq_overridenetprice":null,"jmq_overridevatprice":null,"jmq_overridegrossprice":null,"jmq_amountoutstanding":"3530.40","jmq_totpaid":"0.00","jmq_creditlimit":"0.00","jmq_creditbalance":"0.00","jmq_overdue":"0.00","jmq_userdefinedarray":null,"jmq_deliverycostid":0,"jmq_iscostpriceon":0,"jmq_isonlineorder":1,"jmq_isonlineordersubmitted":0,"jmq_endcustomervatprice":null,"jmq_endcustomeroverridetype":1,"jmq_endcustomeroverridevalue":null,"jmq_endcustomeroverridenetprice":"0.00","jmq_endcustomeroverridevatprice":"0.00","jmq_endcustomeroverridegrossprice":"0.00","jmq_endcustomerdeliverycost":null,"jmq_endcustomerdeliverycostinclvat":1,"jmq_endcustomerfittingcost":null,"jmq_endcustomerfittingcostinclvat":1,"jmq_onlinedeliveryaddreddtype":0,"jmq_onlinedeliveryaddreddid":null,"jmq_commission":"\"\"","jmq_createdby":3,"jmq_updatedby":null,"jmq_deliveryvatperc":"0.000","jmq_cdeliveryvatperc":"0.000","jmq_createdat":"2026-01-05 11:00:38","jmq_commissionsetting":0}],"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":778740919730,"oi_qty":1,"oi_jobid":14521,"oi_jobtempid":"0","oi_jobmultiquoteid":14527,"oi_credit_id":0,"oi_productid":251,"oi_recipeid":251,"oi_ruleid":0,"oi_seq":1,"oi_customseq":1,"oi_productcustomseq":0,"oi_jsondata":"[{\"id\":22764,\"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\":22763,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22767,\"labelname\":\"Room\",\"value\":\"Cnservatoryo\",\"valueid\":\"\",\"type\":29,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22765,\"labelname\":\"Supplier\",\"value\":22,\"valueid\":\"\",\"type\":17,\"optionid\":\"22\",\"optionvalue\":[{\"id\":22,\"optionid\":22,\"optionname\":\"Home Creations\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22768,\"labelname\":\"Size\",\"value\":\"Glass\",\"valueid\":\"62283\",\"type\":3,\"optionid\":\"43422\",\"optionvalue\":[{\"optionid\":43422,\"optionname\":\"Glass\",\"description\":\"\",\"optioncode\":4475,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,Light Filtering,Blackout,PFit Band A,PFit Band B,PFit Band C,PFit Band D,PF Day Night J05,Fit to Frame A,Fit to Frame B,Fit to Frame C,Fit to Frame D,Fit to Frame E,Band A,Band B,Band C\",\"optionqty\":1,\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":62283,\"forchildfieldoptionlinkid\":\"3_62283\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22769,\"labelname\":\"Width\",\"value\":\"655\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22770,\"labelname\":\"Drop\",\"value\":\"307\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22771,\"labelname\":\"Fabric\",\"value\":\"Mode BO\",\"valueid\":\"17021\",\"type\":5,\"optionid\":\"17021\",\"optionvalue\":[{\"optionid\":17021,\"optionname\":\"Mode BO\",\"optionquantity\":1,\"fieldoptionlinkid\":17021,\"forchildfieldoptionlinkid\":\"5_2_17021_1\",\"optionimage\":\"\",\"subdatacount\":1,\"pricegroup\":\"Band C\",\"pricegroupid\":1542}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":23644,\"labelname\":\"Color\",\"value\":\"Snow\",\"valueid\":\"87322\",\"type\":5,\"optionid\":\"87322\",\"optionvalue\":[{\"optionid\":87322,\"optionname\":\"Snow\",\"optionquantity\":1,\"fieldoptionlinkid\":87322,\"forchildfieldoptionlinkid\":\"5_3_87322_1\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"optionimage\":\"\",\"subdatacount\":0}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22766,\"labelname\":\"Pricing Group\",\"value\":1542,\"valueid\":\"1543\",\"type\":13,\"optionid\":\"1542\",\"optionvalue\":[{\"id\":1543,\"fieldid\":22766,\"fieldoptionlinkid\":1543,\"optionid\":1542,\"mainsupplier\":22,\"blindtypecode\":\"HCCPFC\",\"optionname\":\"Band C\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22932,\"labelname\":\"Frame\",\"value\":\"Perfect Fit Frame\",\"valueid\":\"62515\",\"type\":3,\"optionid\":\"43484\",\"optionvalue\":[{\"optionid\":43484,\"optionname\":\"Perfect Fit Frame\",\"description\":\"\",\"optioncode\":27201,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,Light Filtering,Blackout,PFit Band A,PFit Band B,PFit Band C,PFit Band D,Band A,Band B,Band C\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":62515,\"forchildfieldoptionlinkid\":\"3_62515\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":3,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":62515}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22943,\"labelname\":\"Frame Colour\",\"value\":\"White\",\"valueid\":\"62517\",\"type\":3,\"optionid\":\"43485\",\"optionvalue\":[{\"optionid\":43485,\"optionname\":\"White\",\"description\":\"\",\"optioncode\":69434,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":62517,\"forchildfieldoptionlinkid\":\"3_62517\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":62517}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22944,\"labelname\":\"Brackets\",\"value\":\"20mm\",\"valueid\":\"62521\",\"type\":3,\"optionid\":\"43488\",\"optionvalue\":[{\"optionid\":43488,\"optionname\":\"20mm\",\"description\":\"\",\"optioncode\":69437,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":62521,\"forchildfieldoptionlinkid\":\"3_62521\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":62521}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22945,\"labelname\":\"Handles\",\"value\":\"Folding Handles\",\"valueid\":\"62528\",\"type\":3,\"optionid\":\"43494\",\"optionvalue\":[{\"optionid\":43494,\"optionname\":\"Folding Handles\",\"description\":\"\",\"optioncode\":71576,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":62528,\"forchildfieldoptionlinkid\":\"3_62528\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":62528}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22948,\"labelname\":\"Operation\",\"value\":\"Top Down Bottom Up\",\"valueid\":\"62548\",\"type\":3,\"optionid\":\"43512\",\"optionvalue\":[{\"optionid\":43512,\"optionname\":\"Top Down Bottom Up\",\"description\":\"\",\"optioncode\":27217,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,Light Filtering,Blackout,PFit Band A,PFit Band B,PFit Band C,PFit Band D,Band A,Band B,Band C\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":62548,\"forchildfieldoptionlinkid\":\"3_62548\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":62548}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22952,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22957,\"labelname\":\"Fitting\",\"value\":\"Fitting\",\"valueid\":\"62583\",\"type\":3,\"optionid\":\"43540\",\"optionvalue\":[{\"optionid\":43540,\"optionname\":\"Fitting\",\"description\":\"\",\"optioncode\":27218,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,Light Filtering,Blackout,PFit Band A,PFit Band B,PFit Band C,PFit Band D,PF Day Night J05,Fit to Frame A,Fit to Frame B,Fit to Frame C,Fit to Frame D,Fit to Frame E,Band A,Band B,Band C\",\"optionqty\":1,\"unittype\":null,\"unitcost\":16.66,\"fieldoptionlinkid\":62583,\"forchildfieldoptionlinkid\":\"3_62583\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"16.66\",\"fieldid\":62583}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22958,\"labelname\":\"Special Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22959,\"labelname\":\"Workroom Notes\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]","oi_description":"Room: Cnservatoryo, Supplier: Home Creations, Size: Glass, Width: 655, Drop: 307, Fabric: Mode BO, Color: Snow, Pricing Group: Band C, Frame: Perfect Fit Frame, Frame Colour: White, Brackets: 20mm, Handles: Folding Handles, Operation: Top Down Bottom Up, Fitting: Fitting","oi_reportdescription":"##Quantity: 1##,##Room: Cnservatoryo##,##Supplier: Home Creations##,##Size: Glass##,##Width: 655 mm##,##Drop: 307 mm##,##Fabric: Mode BO##,##Color: Snow##,##Pricing Group: Band C##,##Frame: Perfect Fit Frame##,##Frame Colour: White##,##Brackets: 20mm##,##Handles: Folding Handles##,##Operation: Top Down Bottom Up##,##Fitting: Fitting##","oi_reporttitles":"##Quantity:
##Room:
##Supplier:
##Size:
##Width:
##Drop:
##Fabric:
##Color:
##Pricing Group:
##Frame:
##Frame Colour:
##Brackets:
##Handles:
##Operation:
##Fitting:","oi_productionformulajsondata":"[]","oi_productiondate":"2026-01-08 12:07:22","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\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"52.77\",\"show_hide\":true,\"category\":3}","oi_productionstatus":null,"oi_costoverride":0,"oi_costprice":"69.430","oi_netprice":"122.200","oi_pricesfromoperations":null,"oi_vatprice":"24.440","oi_vatvalue":"20.000","oi_vatselected":1,"oi_vattype":1,"oi_vatonoff":1,"oi_grossprice":"146.640","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":"122.200","oi_endcustomeroverridevatprice":"24.440","oi_endcustomeroverridegrossprice":"146.640","oi_sage_flag":0,"oi_status":0,"oi_createdby":13,"oi_createdat":"2026-01-08 12:08:12","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":778741039630,"oi_qty":1,"oi_jobid":14521,"oi_jobtempid":"0","oi_jobmultiquoteid":14527,"oi_credit_id":0,"oi_productid":251,"oi_recipeid":251,"oi_ruleid":0,"oi_seq":2,"oi_customseq":2,"oi_productcustomseq":0,"oi_jsondata":"[{\"id\":22764,\"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\":22763,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22767,\"labelname\":\"Room\",\"value\":\"Cnservatoryo\",\"valueid\":\"\",\"type\":29,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22765,\"labelname\":\"Supplier\",\"value\":22,\"valueid\":\"\",\"type\":17,\"optionid\":\"22\",\"optionvalue\":[{\"id\":22,\"optionid\":22,\"optionname\":\"Home Creations\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22768,\"labelname\":\"Size\",\"value\":\"Glass\",\"valueid\":\"62283\",\"type\":3,\"optionid\":\"43422\",\"optionvalue\":[{\"optionid\":43422,\"optionname\":\"Glass\",\"description\":\"\",\"optioncode\":4475,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,Light Filtering,Blackout,PFit Band A,PFit Band B,PFit Band C,PFit Band D,PF Day Night J05,Fit to Frame A,Fit to Frame B,Fit to Frame C,Fit to Frame D,Fit to Frame E,Band A,Band B,Band C\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":62283,\"forchildfieldoptionlinkid\":\"3_62283\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22769,\"labelname\":\"Width\",\"value\":\"658\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22770,\"labelname\":\"Drop\",\"value\":\"678\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22771,\"labelname\":\"Fabric\",\"value\":\"Mode BO\",\"valueid\":\"17021\",\"type\":5,\"optionid\":\"17021\",\"optionvalue\":[{\"optionid\":17021,\"optionname\":\"Mode BO\",\"optionquantity\":1,\"fieldoptionlinkid\":17021,\"forchildfieldoptionlinkid\":\"5_2_17021_1\",\"subdatacount\":1,\"optionimage\":null,\"pricegroup\":\"Band C\",\"pricegroupid\":1542}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":23644,\"labelname\":\"Color\",\"value\":\"Snow\",\"valueid\":\"87322\",\"type\":5,\"optionid\":\"87322\",\"optionvalue\":[{\"optionid\":87322,\"optionname\":\"Snow\",\"optionquantity\":1,\"fieldoptionlinkid\":87322,\"forchildfieldoptionlinkid\":\"5_87322\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22766,\"labelname\":\"Pricing Group\",\"value\":1542,\"valueid\":\"1543\",\"type\":13,\"optionid\":\"1542\",\"optionvalue\":[{\"id\":1543,\"fieldid\":22766,\"fieldoptionlinkid\":1543,\"optionid\":1542,\"mainsupplier\":22,\"blindtypecode\":\"HCCPFC\",\"optionname\":\"Band C\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22932,\"labelname\":\"Frame\",\"value\":\"Perfect Fit Frame\",\"valueid\":\"62515\",\"type\":3,\"optionid\":\"43484\",\"optionvalue\":[{\"optionid\":43484,\"optionname\":\"Perfect Fit Frame\",\"description\":\"\",\"optioncode\":27201,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,Light Filtering,Blackout,PFit Band A,PFit Band B,PFit Band C,PFit Band D,Band A,Band B,Band C\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":62515,\"forchildfieldoptionlinkid\":\"3_62515\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":3,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":62515}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22943,\"labelname\":\"Frame Colour\",\"value\":\"White\",\"valueid\":\"62517\",\"type\":3,\"optionid\":\"43485\",\"optionvalue\":[{\"optionid\":43485,\"optionname\":\"White\",\"description\":\"\",\"optioncode\":69434,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"fieldoptionlinkid\":62517,\"forchildfieldoptionlinkid\":\"3_62517\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":\"\",\"unitcost\":0,\"reportprice\":\"0.00\",\"fieldid\":62517}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22944,\"labelname\":\"Brackets\",\"value\":\"20mm\",\"valueid\":\"62521\",\"type\":3,\"optionid\":\"43488\",\"optionvalue\":[{\"optionid\":43488,\"optionname\":\"20mm\",\"description\":\"\",\"optioncode\":69437,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"fieldoptionlinkid\":62521,\"forchildfieldoptionlinkid\":\"3_62521\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":\"\",\"unitcost\":0,\"reportprice\":\"0.00\",\"fieldid\":62521}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22945,\"labelname\":\"Handles\",\"value\":\"Folding Handles\",\"valueid\":\"62528\",\"type\":3,\"optionid\":\"43494\",\"optionvalue\":[{\"optionid\":43494,\"optionname\":\"Folding Handles\",\"description\":\"\",\"optioncode\":71576,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"fieldoptionlinkid\":62528,\"forchildfieldoptionlinkid\":\"3_62528\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":\"\",\"unitcost\":0,\"reportprice\":\"0.00\",\"fieldid\":62528}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22948,\"labelname\":\"Operation\",\"value\":\"Top Down Bottom Up\",\"valueid\":\"62548\",\"type\":3,\"optionid\":\"43512\",\"optionvalue\":[{\"optionid\":43512,\"optionname\":\"Top Down Bottom Up\",\"description\":\"\",\"optioncode\":27217,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,Light Filtering,Blackout,PFit Band A,PFit Band B,PFit Band C,PFit Band D,Band A,Band B,Band C\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":62548,\"forchildfieldoptionlinkid\":\"3_62548\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":62548}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22952,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22957,\"labelname\":\"Fitting\",\"value\":\"Fitting\",\"valueid\":\"62583\",\"type\":3,\"optionid\":\"43540\",\"optionvalue\":[{\"optionid\":43540,\"optionname\":\"Fitting\",\"description\":\"\",\"optioncode\":27218,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,Light Filtering,Blackout,PFit Band A,PFit Band B,PFit Band C,PFit Band D,PF Day Night J05,Fit to Frame A,Fit to Frame B,Fit to Frame C,Fit to Frame D,Fit to Frame E,Band A,Band B,Band C\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":16.66,\"fieldoptionlinkid\":62583,\"forchildfieldoptionlinkid\":\"3_62583\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"16.66\",\"fieldid\":62583}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22958,\"labelname\":\"Special Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22959,\"labelname\":\"Workroom Notes\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]","oi_description":"Room: Cnservatoryo, Supplier: Home Creations, Size: Glass, Width: 658, Drop: 678, Fabric: Mode BO, Color: Snow, Pricing Group: Band C, Frame: Perfect Fit Frame, Frame Colour: White, Brackets: 20mm, Handles: Folding Handles, Operation: Top Down Bottom Up, Fitting: Fitting","oi_reportdescription":"##Quantity: 1##,##Room: Cnservatoryo##,##Supplier: Home Creations##,##Size: Glass##,##Width: 658 mm##,##Drop: 678 mm##,##Fabric: Mode BO##,##Color: Snow##,##Pricing Group: Band C##,##Frame: Perfect Fit Frame##,##Frame Colour: White##,##Brackets: 20mm##,##Handles: Folding Handles##,##Operation: Top Down Bottom Up##,##Fitting: Fitting##","oi_reporttitles":"##Quantity:
##Room:
##Supplier:
##Size:
##Width:
##Drop:
##Fabric:
##Color:
##Pricing Group:
##Frame:
##Frame Colour:
##Brackets:
##Handles:
##Operation:
##Fitting:","oi_productionformulajsondata":"[]","oi_productiondate":"2026-01-08 12:07:22","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\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"59.56\",\"show_hide\":true,\"category\":3}","oi_productionstatus":null,"oi_costoverride":0,"oi_costprice":"76.220","oi_netprice":"135.780","oi_pricesfromoperations":null,"oi_vatprice":"27.160","oi_vatvalue":"20.000","oi_vatselected":1,"oi_vattype":1,"oi_vatonoff":1,"oi_grossprice":"162.940","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":"135.780","oi_endcustomeroverridevatprice":"27.160","oi_endcustomeroverridegrossprice":"162.940","oi_sage_flag":0,"oi_status":0,"oi_createdby":13,"oi_createdat":"2026-01-08 12:08:23","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":778741170660,"oi_qty":1,"oi_jobid":14521,"oi_jobtempid":"0","oi_jobmultiquoteid":14527,"oi_credit_id":0,"oi_productid":251,"oi_recipeid":251,"oi_ruleid":0,"oi_seq":3,"oi_customseq":3,"oi_productcustomseq":0,"oi_jsondata":"[{\"id\":22764,\"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\":22763,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22767,\"labelname\":\"Room\",\"value\":\"Cnservatoryo\",\"valueid\":\"\",\"type\":29,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22765,\"labelname\":\"Supplier\",\"value\":22,\"valueid\":\"\",\"type\":17,\"optionid\":\"22\",\"optionvalue\":[{\"id\":22,\"optionid\":22,\"optionname\":\"Home Creations\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22768,\"labelname\":\"Size\",\"value\":\"Glass\",\"valueid\":\"62283\",\"type\":3,\"optionid\":\"43422\",\"optionvalue\":[{\"optionid\":43422,\"optionname\":\"Glass\",\"description\":\"\",\"optioncode\":4475,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,Light Filtering,Blackout,PFit Band A,PFit Band B,PFit Band C,PFit Band D,PF Day Night J05,Fit to Frame A,Fit to Frame B,Fit to Frame C,Fit to Frame D,Fit to Frame E,Band A,Band B,Band C\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":62283,\"forchildfieldoptionlinkid\":\"3_62283\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22769,\"labelname\":\"Width\",\"value\":\"558\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22770,\"labelname\":\"Drop\",\"value\":\"214\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22771,\"labelname\":\"Fabric\",\"value\":\"Mode BO\",\"valueid\":\"17021\",\"type\":5,\"optionid\":\"17021\",\"optionvalue\":[{\"optionid\":17021,\"optionname\":\"Mode BO\",\"optionquantity\":1,\"fieldoptionlinkid\":17021,\"forchildfieldoptionlinkid\":\"5_2_17021_1\",\"subdatacount\":1,\"optionimage\":null,\"pricegroup\":\"Band C\",\"pricegroupid\":1542}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":23644,\"labelname\":\"Color\",\"value\":\"Snow\",\"valueid\":\"87322\",\"type\":5,\"optionid\":\"87322\",\"optionvalue\":[{\"optionid\":87322,\"optionname\":\"Snow\",\"optionquantity\":1,\"fieldoptionlinkid\":87322,\"forchildfieldoptionlinkid\":\"5_87322\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22766,\"labelname\":\"Pricing Group\",\"value\":1542,\"valueid\":\"1543\",\"type\":13,\"optionid\":\"1542\",\"optionvalue\":[{\"id\":1543,\"fieldid\":22766,\"fieldoptionlinkid\":1543,\"optionid\":1542,\"mainsupplier\":22,\"blindtypecode\":\"HCCPFC\",\"optionname\":\"Band C\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22932,\"labelname\":\"Frame\",\"value\":\"Perfect Fit Frame\",\"valueid\":\"62515\",\"type\":3,\"optionid\":\"43484\",\"optionvalue\":[{\"optionid\":43484,\"optionname\":\"Perfect Fit Frame\",\"description\":\"\",\"optioncode\":27201,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,Light Filtering,Blackout,PFit Band A,PFit Band B,PFit Band C,PFit Band D,Band A,Band B,Band C\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":62515,\"forchildfieldoptionlinkid\":\"3_62515\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":3,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":62515}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22943,\"labelname\":\"Frame Colour\",\"value\":\"White\",\"valueid\":\"62517\",\"type\":3,\"optionid\":\"43485\",\"optionvalue\":[{\"optionid\":43485,\"optionname\":\"White\",\"description\":\"\",\"optioncode\":69434,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"fieldoptionlinkid\":62517,\"forchildfieldoptionlinkid\":\"3_62517\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":\"\",\"unitcost\":0,\"reportprice\":\"0.00\",\"fieldid\":62517}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22944,\"labelname\":\"Brackets\",\"value\":\"20mm\",\"valueid\":\"62521\",\"type\":3,\"optionid\":\"43488\",\"optionvalue\":[{\"optionid\":43488,\"optionname\":\"20mm\",\"description\":\"\",\"optioncode\":69437,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"fieldoptionlinkid\":62521,\"forchildfieldoptionlinkid\":\"3_62521\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":\"\",\"unitcost\":0,\"reportprice\":\"0.00\",\"fieldid\":62521}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22945,\"labelname\":\"Handles\",\"value\":\"Folding Handles\",\"valueid\":\"62528\",\"type\":3,\"optionid\":\"43494\",\"optionvalue\":[{\"optionid\":43494,\"optionname\":\"Folding Handles\",\"description\":\"\",\"optioncode\":71576,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"fieldoptionlinkid\":62528,\"forchildfieldoptionlinkid\":\"3_62528\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":\"\",\"unitcost\":0,\"reportprice\":\"0.00\",\"fieldid\":62528}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22948,\"labelname\":\"Operation\",\"value\":\"Top Down Bottom Up\",\"valueid\":\"62548\",\"type\":3,\"optionid\":\"43512\",\"optionvalue\":[{\"optionid\":43512,\"optionname\":\"Top Down Bottom Up\",\"description\":\"\",\"optioncode\":27217,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,Light Filtering,Blackout,PFit Band A,PFit Band B,PFit Band C,PFit Band D,Band A,Band B,Band C\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":62548,\"forchildfieldoptionlinkid\":\"3_62548\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":62548}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22952,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22957,\"labelname\":\"Fitting\",\"value\":\"Fitting\",\"valueid\":\"62583\",\"type\":3,\"optionid\":\"43540\",\"optionvalue\":[{\"optionid\":43540,\"optionname\":\"Fitting\",\"description\":\"\",\"optioncode\":27218,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,Light Filtering,Blackout,PFit Band A,PFit Band B,PFit Band C,PFit Band D,PF Day Night J05,Fit to Frame A,Fit to Frame B,Fit to Frame C,Fit to Frame D,Fit to Frame E,Band A,Band B,Band C\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":16.66,\"fieldoptionlinkid\":62583,\"forchildfieldoptionlinkid\":\"3_62583\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"16.66\",\"fieldid\":62583}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22958,\"labelname\":\"Special Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22959,\"labelname\":\"Workroom Notes\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]","oi_description":"Room: Cnservatoryo, Supplier: Home Creations, Size: Glass, Width: 558, Drop: 214, Fabric: Mode BO, Color: Snow, Pricing Group: Band C, Frame: Perfect Fit Frame, Frame Colour: White, Brackets: 20mm, Handles: Folding Handles, Operation: Top Down Bottom Up, Fitting: Fitting","oi_reportdescription":"##Quantity: 1##,##Room: Cnservatoryo##,##Supplier: Home Creations##,##Size: Glass##,##Width: 558 mm##,##Drop: 214 mm##,##Fabric: Mode BO##,##Color: Snow##,##Pricing Group: Band C##,##Frame: Perfect Fit Frame##,##Frame Colour: White##,##Brackets: 20mm##,##Handles: Folding Handles##,##Operation: Top Down Bottom Up##,##Fitting: Fitting##","oi_reporttitles":"##Quantity:
##Room:
##Supplier:
##Size:
##Width:
##Drop:
##Fabric:
##Color:
##Pricing Group:
##Frame:
##Frame Colour:
##Brackets:
##Handles:
##Operation:
##Fitting:","oi_productionformulajsondata":"[]","oi_productiondate":"2026-01-08 12:07:22","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\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"50.51\",\"show_hide\":true,\"category\":3}","oi_productionstatus":null,"oi_costoverride":0,"oi_costprice":"67.170","oi_netprice":"117.680","oi_pricesfromoperations":null,"oi_vatprice":"23.540","oi_vatvalue":"20.000","oi_vatselected":1,"oi_vattype":1,"oi_vatonoff":1,"oi_grossprice":"141.220","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":"117.680","oi_endcustomeroverridevatprice":"23.540","oi_endcustomeroverridegrossprice":"141.220","oi_sage_flag":0,"oi_status":0,"oi_createdby":13,"oi_createdat":"2026-01-08 12:08:37","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":778741302680,"oi_qty":1,"oi_jobid":14521,"oi_jobtempid":"0","oi_jobmultiquoteid":14527,"oi_credit_id":0,"oi_productid":251,"oi_recipeid":251,"oi_ruleid":0,"oi_seq":4,"oi_customseq":4,"oi_productcustomseq":0,"oi_jsondata":"[{\"id\":22764,\"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\":22763,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22767,\"labelname\":\"Room\",\"value\":\"Cnservatoryo\",\"valueid\":\"\",\"type\":29,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22765,\"labelname\":\"Supplier\",\"value\":22,\"valueid\":\"\",\"type\":17,\"optionid\":\"22\",\"optionvalue\":[{\"id\":22,\"optionid\":22,\"optionname\":\"Home Creations\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22768,\"labelname\":\"Size\",\"value\":\"Glass\",\"valueid\":\"62283\",\"type\":3,\"optionid\":\"43422\",\"optionvalue\":[{\"optionid\":43422,\"optionname\":\"Glass\",\"description\":\"\",\"optioncode\":4475,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,Light Filtering,Blackout,PFit Band A,PFit Band B,PFit Band C,PFit Band D,PF Day Night J05,Fit to Frame A,Fit to Frame B,Fit to Frame C,Fit to Frame D,Fit to Frame E,Band A,Band B,Band C\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":62283,\"forchildfieldoptionlinkid\":\"3_62283\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22769,\"labelname\":\"Width\",\"value\":\"650\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22770,\"labelname\":\"Drop\",\"value\":\"680\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22771,\"labelname\":\"Fabric\",\"value\":\"Mode BO\",\"valueid\":\"17021\",\"type\":5,\"optionid\":\"17021\",\"optionvalue\":[{\"optionid\":17021,\"optionname\":\"Mode BO\",\"optionquantity\":1,\"fieldoptionlinkid\":17021,\"forchildfieldoptionlinkid\":\"5_2_17021_1\",\"subdatacount\":1,\"optionimage\":null,\"pricegroup\":\"Band C\",\"pricegroupid\":1542}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":23644,\"labelname\":\"Color\",\"value\":\"Snow\",\"valueid\":\"87322\",\"type\":5,\"optionid\":\"87322\",\"optionvalue\":[{\"optionid\":87322,\"optionname\":\"Snow\",\"optionquantity\":1,\"fieldoptionlinkid\":87322,\"forchildfieldoptionlinkid\":\"5_87322\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22766,\"labelname\":\"Pricing Group\",\"value\":1542,\"valueid\":\"1543\",\"type\":13,\"optionid\":\"1542\",\"optionvalue\":[{\"id\":1543,\"fieldid\":22766,\"fieldoptionlinkid\":1543,\"optionid\":1542,\"mainsupplier\":22,\"blindtypecode\":\"HCCPFC\",\"optionname\":\"Band C\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22932,\"labelname\":\"Frame\",\"value\":\"Perfect Fit Frame\",\"valueid\":\"62515\",\"type\":3,\"optionid\":\"43484\",\"optionvalue\":[{\"optionid\":43484,\"optionname\":\"Perfect Fit Frame\",\"description\":\"\",\"optioncode\":27201,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,Light Filtering,Blackout,PFit Band A,PFit Band B,PFit Band C,PFit Band D,Band A,Band B,Band C\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":62515,\"forchildfieldoptionlinkid\":\"3_62515\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":3,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":62515}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22943,\"labelname\":\"Frame Colour\",\"value\":\"White\",\"valueid\":\"62517\",\"type\":3,\"optionid\":\"43485\",\"optionvalue\":[{\"optionid\":43485,\"optionname\":\"White\",\"description\":\"\",\"optioncode\":69434,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"fieldoptionlinkid\":62517,\"forchildfieldoptionlinkid\":\"3_62517\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":\"\",\"unitcost\":0,\"reportprice\":\"0.00\",\"fieldid\":62517}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22944,\"labelname\":\"Brackets\",\"value\":\"20mm\",\"valueid\":\"62521\",\"type\":3,\"optionid\":\"43488\",\"optionvalue\":[{\"optionid\":43488,\"optionname\":\"20mm\",\"description\":\"\",\"optioncode\":69437,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"fieldoptionlinkid\":62521,\"forchildfieldoptionlinkid\":\"3_62521\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":\"\",\"unitcost\":0,\"reportprice\":\"0.00\",\"fieldid\":62521}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22945,\"labelname\":\"Handles\",\"value\":\"Folding Handles\",\"valueid\":\"62528\",\"type\":3,\"optionid\":\"43494\",\"optionvalue\":[{\"optionid\":43494,\"optionname\":\"Folding Handles\",\"description\":\"\",\"optioncode\":71576,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"fieldoptionlinkid\":62528,\"forchildfieldoptionlinkid\":\"3_62528\",\"hasstock\":0,\"subdatacount\":0,\"hasprice\":1,\"optionimage\":\"\",\"unitcost\":0,\"reportprice\":\"0.00\",\"fieldid\":62528}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22948,\"labelname\":\"Operation\",\"value\":\"Top Down Bottom Up\",\"valueid\":\"62548\",\"type\":3,\"optionid\":\"43512\",\"optionvalue\":[{\"optionid\":43512,\"optionname\":\"Top Down Bottom Up\",\"description\":\"\",\"optioncode\":27217,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,Light Filtering,Blackout,PFit Band A,PFit Band B,PFit Band C,PFit Band D,Band A,Band B,Band C\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":0,\"fieldoptionlinkid\":62548,\"forchildfieldoptionlinkid\":\"3_62548\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":62548}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22952,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22957,\"labelname\":\"Fitting\",\"value\":\"Fitting\",\"valueid\":\"62583\",\"type\":3,\"optionid\":\"43540\",\"optionvalue\":[{\"optionid\":43540,\"optionname\":\"Fitting\",\"description\":\"\",\"optioncode\":27218,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,Light Filtering,Blackout,PFit Band A,PFit Band B,PFit Band C,PFit Band D,PF Day Night J05,Fit to Frame A,Fit to Frame B,Fit to Frame C,Fit to Frame D,Fit to Frame E,Band A,Band B,Band C\",\"optionqty\":\"1\",\"unittype\":null,\"unitcost\":16.66,\"fieldoptionlinkid\":62583,\"forchildfieldoptionlinkid\":\"3_62583\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"16.66\",\"fieldid\":62583}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22958,\"labelname\":\"Special Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22959,\"labelname\":\"Workroom Notes\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]","oi_description":"Room: Cnservatoryo, Supplier: Home Creations, Size: Glass, Width: 650, Drop: 680, Fabric: Mode BO, Color: Snow, Pricing Group: Band C, Frame: Perfect Fit Frame, Frame Colour: White, Brackets: 20mm, Handles: Folding Handles, Operation: Top Down Bottom Up, Fitting: Fitting","oi_reportdescription":"##Quantity: 1##,##Room: Cnservatoryo##,##Supplier: Home Creations##,##Size: Glass##,##Width: 650 mm##,##Drop: 680 mm##,##Fabric: Mode BO##,##Color: Snow##,##Pricing Group: Band C##,##Frame: Perfect Fit Frame##,##Frame Colour: White##,##Brackets: 20mm##,##Handles: Folding Handles##,##Operation: Top Down Bottom Up##,##Fitting: Fitting##","oi_reporttitles":"##Quantity:
##Room:
##Supplier:
##Size:
##Width:
##Drop:
##Fabric:
##Color:
##Pricing Group:
##Frame:
##Frame Colour:
##Brackets:
##Handles:
##Operation:
##Fitting:","oi_productionformulajsondata":"[]","oi_productiondate":"2026-01-08 12:07:22","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\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"59.56\",\"show_hide\":true,\"category\":3}","oi_productionstatus":null,"oi_costoverride":0,"oi_costprice":"76.220","oi_netprice":"135.780","oi_pricesfromoperations":null,"oi_vatprice":"27.160","oi_vatvalue":"20.000","oi_vatselected":1,"oi_vattype":1,"oi_vatonoff":1,"oi_grossprice":"162.940","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":"135.780","oi_endcustomeroverridevatprice":"27.160","oi_endcustomeroverridegrossprice":"162.940","oi_sage_flag":0,"oi_status":0,"oi_createdby":13,"oi_createdat":"2026-01-08 12:08:50","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":778741436210,"oi_qty":1,"oi_jobid":14521,"oi_jobtempid":"0","oi_jobmultiquoteid":14527,"oi_credit_id":0,"oi_productid":251,"oi_recipeid":251,"oi_ruleid":0,"oi_seq":5,"oi_customseq":5,"oi_productcustomseq":0,"oi_jsondata":"[{\"id\":22764,\"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\":22763,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22767,\"labelname\":\"Room\",\"value\":\"Cnservatoryo\",\"valueid\":\"\",\"type\":29,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":22765,\"labelname\":\"Supplier\",\"value\":22,\"valueid\":\"\",\"type\":17,\"optionid\":\"22\",\"optionvalue\":[{\"id\":22,\"optionid\":22,\"optionname\":\"Home Creations\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":22768,\"labelname\":\"Size\",\"value\":\"Glass\",\"valueid\":\"62283\",\"type\":3,\"optionid\":\"43422\",\"optionvalue\":[{\"optionid\":43422,\"optionname\":\"Glass\",\"description\":\"\",\"optioncode\":4475,\"pricegroups\":\"Elements PF,Band A PF,Band B PF,Band C PF,Band D PF,Band E PF,Night & Day PF,Elemen PF,PF Softcell A,PF Softcell B,PF Softcell C,PF Softcell D,PF Softcell E,Cellular PF 1,Cellular PF 2,Cellular PF 3,Cellular PF 3+10per,Cellular PF 3+30per,Cellular PF 3+60per,Cellular PF 3+75per,Pleated PF 1,Pleated PF 2,Pleated PF 3,Pleated PF 3+10per,Pleated PF 3+15per,Pleated PF 3+20per,L, 1970-01-01 00:00:00, ?, , 2026-01-08 12:15:04))----760---/var/www/html/api/vendor/laravel/framework/src/Illuminate/Database/Connection.php for database: CONCORDE