{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [], "deleted": [] }, "bm_appointment": { "created": [ { "app_eventid": 15541, "app_description": "Job test", "app_summary": "11444-Test A", "app_private": 0, "app_appointmentType": 5, "app_userId": 2, "app_orderId": 12778, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Calcutta", "app_latitude": 0, "app_longitude": 0, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": null, "app_onsiteMinute": null, "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 843, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "0", "app_jobtimeminute": "20", "app_products": null, "app_deviceplatform": 1, "app_recurrenceexception_date": null, "app_deliveryaddressid": 7296, "id": "15541", "app_sdate": 1748822400, "app_edate": 1748822400, "app_stime": 1748845821, "app_etime": 1748847021, "app_sdatetime": 1748845821, "app_edatetime": 1748847021, "app_until": null, "app_createdAt": 1748846729, "app_updatedAt": 1748846729, "app_createdBy": 1, "app_updatedBy": null } ], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [], "updated": [ { "jd_id": 12778, "jd_customerid": 5879, "jd_contactid": 7296, "jd_additionalcontacts": "7296", "jd_templateid": 1, "jd_jobmultiquoteid": 12782, "jd_deletedcustokeyvalue": "{\"32\":\"\",\"34\":\"11444\",\"35\":\"ATES0001\",\"36\":1,\"38\":\"\",\"40\":3,\"countryText\":\"UK\",\"adminUser\":1}", "jd_jobref": "11444", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 3, "jd_accref": "ATES0001", "jd_invoiceno": "", "jd_listprice": "1200.00", "jd_netprice": "1200.00", "jd_vat": "240.00", "jd_isvaton": 1, "jd_deliverycost": "200.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "1440.00", "jd_grossprofit": "-800.00", "jd_costprice": "2000.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "1440.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 0, "jd_iscostpriceon": 1, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 0, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "1000.00", "jd_endcustomeroverridevatprice": "200.00", "jd_endcustomeroverridegrossprice": "1200.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 0, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 0, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "20.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":1,\"41\":1,\"44\":\"\",\"45\":\"Test\",\"46\":\"A\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"09\",\"54\":19,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"612\":\"\",\"614\":\"\",\"615\":\"\",\"32\":\"\",\"34\":\"11444\",\"35\":\"ATES0001\",\"36\":1,\"38\":\"\",\"40\":3,\"countryText\":\"UK\",\"adminUser\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "20.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "12778", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": 1748390400, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748417077, "jd_updatedat": 1748846741 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 80485, "oi_jobid": 0, "oi_jobtempid": "c058a347", "oi_jobmultiquoteid": null, "oi_productid": 279, "oi_recipeid": 279, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 66, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":24910,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":2,\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"issubfabric\":0,\"labelnamecode\":\"Unit Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":34,\"mandatory\":0,\"fieldname\":\"Unit Type\",\"fieldid\":24910,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":2,\"optionsvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"editruleoverride\":0},{\"id\":24912,\"labelname\":\"Product Type\",\"value\":\"22\",\"valueid\":\"1845\",\"type\":13,\"optionid\":\"22\",\"optionvalue\":[{\"id\":1845,\"fieldid\":24912,\"fieldoptionlinkid\":1845,\"optionid\":22,\"mainsupplier\":\"31\",\"blindtypecode\":null,\"optionname\":\"Eyelet 5 Blackout Lining_BGC\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":24912,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"22\",\"optionsvalue\":[{\"id\":1845,\"fieldid\":24912,\"fieldoptionlinkid\":1845,\"optionid\":22,\"mainsupplier\":\"31\",\"blindtypecode\":null,\"optionname\":\"Eyelet 5 Blackout Lining_BGC\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":24909,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Quantity\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":14,\"mandatory\":0,\"fieldname\":\"Quantity\",\"fieldid\":24909,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24911,\"labelname\":\"Supplier\",\"value\":\"31\",\"valueid\":null,\"type\":17,\"optionid\":\"31\",\"optionvalue\":[{\"id\":31,\"optionid\":31,\"optionname\":\"Blinds 2 Go\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"Supplier\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":17,\"mandatory\":0,\"fieldname\":\"Supplier\",\"fieldid\":24911,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"31\",\"optionsvalue\":[{\"id\":31,\"optionid\":31,\"optionname\":\"Blinds 2 Go\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":1}]", "oi_description": "Product Type: Eyelet 5 Blackout Lining_BGC, Supplier: Blinds 2 Go", "oi_reportdescription": "##Product Type: Eyelet 5 Blackout Lining_BGC##,##Quantity: 1##,##Supplier: Blinds 2 Go##", "oi_reporttitles": "##Product Type:<\/br>##Quantity:<\/br>##Supplier:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":23,\"value\":\"0.11\",\"formula\":\"If(MaterialType=\\\"Standard\\\",If(And(Fabric_FabricRollWidth<=1500,Fabric_Patternrepeat=0),((DropfromSuspensionPoint+290)*(TotalNoofwidths))\\\/1000,If(and(Fabric_FabricRollWidth<=1500,Fabric_Patternrepeat>0),(True),0)),(WidthofTrackPole*DefaultFullness)\\\/1000)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"0.11\"},{\"productionoveride\":0,\"id\":2,\"value\":null,\"formula\":\"If(MaterialType=\\\"Standard\\\",Round((If(MaterialType=\\\"Standard\\\",Fabric_UnitCost*((FabricQty)+Extrafabrictoorder),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder)))+Round((If(MaterialType=\\\"Standard\\\",Fabric_UnitCost*((FabricQty)+Extrafabrictoorder),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder)))\\\/100*FabricMarkUp),2,2),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder))\",\"price\":\"0.00\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":3,\"value\":\"44.88\",\"formula\":\"Heading_PriceTablePrice\",\"price\":\"44.88\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"44.88\"},{\"productionoveride\":0,\"id\":4,\"value\":\"2.50\",\"formula\":\"If(Heading=\\\"Eyelet5_BGC\\\",2,If(Heading=\\\"PencilPleat5_BGC\\\",2,If(Heading=\\\"TwinPleat5_BGC\\\",2,If(Heading=\\\"Eyelet5BlackoutLining_BGC\\\",2,If(Heading=\\\"PencilPleat5BlackoutLining_BGC\\\",2,If(Heading=\\\"TwinPleat5BlackoutLining_BGC\\\",2,If(Heading=\\\"Eyelet5Thermal_BGC\\\",2,If(Heading=\\\"PencilPleat5Thermal_BGC\\\",2,If(Heading=\\\"TwinPleat5Thermal_BGC\\\",2,If(Heading=\\\"Eyelet5Thermal+BO_BGC\\\",2,If(Heading=\\\"PencilPleat5Thermal+BO_BGC\\\",2,If(Heading=\\\"TwinPleat5Thermal+BO_BGC\\\",2,If(Heading=\\\"MachinedEyelet_CC\\\",1.8,If(Heading=\\\"MachinedPencilPleat_CC\\\",2.5,If(Heading=\\\"MachinedWave_CC\\\",2.3,If(Heading=\\\"MachinedTriplePinchPleat_CC\\\",2.2,If(Heading=\\\"MachinedTwinPleat_CC\\\",2.2,If(Heading=\\\"HandFinishedEyelet_CC\\\",1.8,If(Heading=\\\"HandFinishedPencilPleat_CC\\\",2,If(Heading=\\\"HandFinishedWave_CC\\\",2.3,If(Heading=\\\"HandFinishedTriplePinchPleat_CC\\\",2.2,If(Heading=\\\"SlotTop_CC\\\",2,If(Heading=\\\"PencilPleat-HandFinished_PCC\\\",2,If(Heading=\\\"PinchPleat-HandFinished_PCC\\\",2,If(Heading=\\\"Eyelet-HandFinished_PCC\\\",2,If(Heading=\\\"Wave-HandFinished_PCC\\\",2,If(Heading=\\\"PencilPleat-Machined_PCC\\\",2,If(Heading=\\\"PinchPleat-Machined_PCC\\\",2,If(Heading=\\\"Eyelet-Machined_PCC\\\",2,If(Heading=\\\"Wave-Machined_PCC\\\",2,If(Heading=\\\"Eyelet_WGC\\\",2,If(Heading=\\\"PencilPleat_WGC\\\",2,If(Heading=\\\"Wave_WGC\\\",2.3,If(Heading=\\\"Wave(lessfull)_WGC\\\",2.1,If(Heading=\\\"TriplePinchPleat_WGC\\\",2.5,If(Heading=\\\"DoublePinchPleat_WGC\\\",2.3,If(Heading=\\\"SinglePleat_WGC\\\",2,If(Heading=\\\"EyeletWideWidth_WGC\\\",2,If(Heading=\\\"PencilPleatWideWidth_WGC\\\",2,If(Heading=\\\"WaveWideWidth_WGC\\\",2.3,If(Heading=\\\"TriplePinchPleatWideWidth_WGC\\\",2.5,If(Heading=\\\"DoublePinchPleatWideWidth_WGC\\\",2,If(Heading=\\\"SinglePleatWideWidth_WGC\\\",2,0)))))))))))))))))))))))))))))))))))))))))))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"2.50\"},{\"productionoveride\":0,\"id\":6,\"value\":null,\"formula\":\"If(PairorSingle=\\\"Pair\\\",Widths*2,Widths)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":7,\"value\":\"0.11\",\"formula\":\"((FabricQty)+Extrafabrictoorder)*Quantity\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"0.11\"},{\"productionoveride\":0,\"id\":8,\"value\":null,\"formula\":\"(((FabricQty)+Extrafabrictoorder)*Quantity)*Lining_MakeupperWidth\",\"price\":null,\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":9,\"value\":null,\"formula\":\"Round(Widths*3,1)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":10,\"value\":null,\"formula\":\"RoundUp(Widths,0)-1\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":11,\"value\":null,\"formula\":\"if(UnitType=\\\"Inches\\\",(JoiningAllowance*25.4)\\\/10,if(UnitType=\\\"cm\\\",JoiningAllowance*10,JoiningAllowance))*(Numberofjoins)+ (if(UnitType=\\\"inches\\\",(SideTurningsDeduction*25.4)\\\/10,if(UnitType=\\\"cm\\\",(SideTurningsDeduction*10),SideTurningsDeduction)))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":5,\"value\":null,\"formula\":\"IF(PairorSingle=\\\"Pair\\\",RoundUp(IF(UnitType=\\\"mm\\\",WidthofTrackPole\\\/10,IF(UnitType=\\\"inch\\\",(WidthofTrackPole*25.4)\\\/10,IF(UnitType=\\\"inch\\\",WidthofTrackPole\\\/100,WidthofTrackPole)))*DefaultFullness\\\/If(MaterialType=\\\"Standard\\\",Fabric_FabricRollWidth\\\/10,Fabric_FabricRollDrop\\\/10),0)\\\/2,RoundUp((IF(UnitType=\\\"mm\\\",WidthofTrackPole\\\/10,IF(UnitType=\\\"inch\\\",(WidthofTrackPole*25.4)\\\/10,IF(UnitType=\\\"inch\\\",WidthofTrackPole\\\/100,WidthofTrackPole)))*DefaultFullness)\\\/If(MaterialType=\\\"Standard\\\",Fabric_FabricRollWidth\\\/10,Fabric_FabricRollDrop\\\/10),0))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":12,\"value\":\"294.50\",\"formula\":\"IF(UnitType=\\\"mm\\\",DropfromSuspensionPoint\\\/10,IF(UnitType=\\\"cm\\\",DropfromSuspensionPoint,IF(UnitType=\\\"inch\\\",(DropfromSuspensionPoint*25.4)\\\/10,DropfromSuspensionPoint\\\/100)))+IF(UnitType=\\\"inch\\\",(HeadingTurn*25.4),IF(UnitType=\\\"cm\\\",HeadingTurn*10,HeadingTurn))+IF(UnitType=\\\"inch\\\",(HemTurn*25.4),IF(UnitType=\\\"cm\\\",HemTurn*10,HemTurn))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"294.50\"},{\"productionoveride\":0,\"id\":13,\"value\":null,\"formula\":\"IF(Fabric_Patternrepeat>0,RoundUp((DropfromSuspensionPoint+HeadingTurn+HemTurn)\\\/(Fabric_Patternrepeat\\\/10),0),\\\"0\\\")\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":14,\"value\":\"294.50\",\"formula\":\"IF(NoOfPatternRepeats>0,NoOfPatternRepeats * IF(Fabric_Patternrepeat>0,Fabric_Patternrepeat\\\/10,1),FinishedCutLengths)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"294.50\"},{\"productionoveride\":0,\"id\":15,\"value\":null,\"formula\":\"RoundUp(Widths*If(MaterialType=\\\"Standard\\\",(Fabric_FabricRollWidth\\\/10),(If(MaterialType=\\\"Continuous\\\",(Fabric_FabricRollDrop\\\/10),\\\"\\\"))),0)-(Totalseamsandturnings)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":16,\"value\":null,\"formula\":\"Round(IF(PairorSingle=\\\"Pair\\\", Round(((IF(UnitType=\\\"mm\\\",WidthofTrackPole\\\/10,IF(UnitType=\\\"Inches\\\",(WidthofTrackPole*25.4)\\\/10,IF(UnitType=\\\"Inches\\\",WidthofTrackPole\\\/100,WidthofTrackPole)))+(Leftreturn\\\/10))+(Rightreturn\\\/10+Overlap\\\/10*2)+(Springbacktolerance*2))\\\/2,2), (IF(UnitType=\\\"mm\\\",WidthofTrackPole\\\/10,IF(UnitType=\\\"Inches\\\",(WidthofTrackPole*25.4)\\\/10,IF(UnitType=\\\"Inches\\\",WidthofTrackPole\\\/100,WidthofTrackPole)))+Leftreturn\\\/10+Rightreturn\\\/10+Springbacktolerance)),0)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":17,\"value\":null,\"formula\":\"((Finishedwidthoffabric)-(Spaceallowancesfinishedwidth))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":18,\"value\":null,\"formula\":\"Round((Spaceallowancesfinishedwidth\\\/10-(If(Leftreturn>0,Leftreturn\\\/10,Leftreturn\\\/10)+If(Overlap>0,Overlap\\\/10,Overlap\\\/10)))\\\/Qtyofspaces,0)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":19,\"value\":null,\"formula\":\"Round((RoundUp(Spaceallowancesfinishedwidth\\\/10,0)-((Leftreturn\\\/10)+(Overlap\\\/10)))\\\/if(Suspensionpointtowall>0,(Suspensionpointtowall\\\/10*2),1),0)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":20,\"value\":null,\"formula\":\"Qtyofspaces+1\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":21,\"value\":null,\"formula\":\"Round((Pleatsallowance)\\\/(Qtyofpleats),1)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":22,\"value\":\"245.00\",\"formula\":\"if(OR(Heading=\\\"Eyelet_WGC\\\",Heading=\\\"PencilPleat_WGC\\\",Heading=\\\"Wave_WGC\\\",Heading=\\\"TriplePinchPleat_WGC\\\",Heading=\\\"DoublePinchPleat_WGC\\\"),DropfromSuspensionPoint+200,0)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"245.00\"},{\"productionoveride\":0,\"id\":89,\"value\":null,\"formula\":\"(RoundUp((DropfromSuspensionPoint+290)\\\/Fabric_Patternrepeat,0)*Fabric_Patternrepeat)*(TotalNoofwidths)\\\/1000\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":98,\"value\":null,\"formula\":\"(Priceoftotalfabric+Makeupchargeoffabric+Makeupchargeoflining)\",\"price\":null,\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":99,\"value\":null,\"formula\":\"if(Border<>\\\"\\\",(TotalCost*0.2),0)\",\"price\":\"0.00\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "[]", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "0.000", "oi_netprice": "0.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.000", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "0.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_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[24910, 24912, 24909, 24911]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "80485", "oi_productiondate": 1748864475, "oi_createdat": 1748864475, "oi_updatedat": 1748844723, "oi_createdby": 14, "oi_updatedby": null }, { "oi_id": 80486, "oi_jobid": 0, "oi_jobtempid": "c058a347", "oi_jobmultiquoteid": null, "oi_productid": 276, "oi_recipeid": 276, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 67, "oi_customseq": 2, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":24899,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":2,\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"issubfabric\":0,\"labelnamecode\":\"Unit Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":34,\"mandatory\":0,\"fieldname\":\"Unit Type\",\"fieldid\":24899,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":2,\"optionsvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"editruleoverride\":0},{\"id\":24901,\"labelname\":\"Product Type\",\"value\":\"87\",\"valueid\":\"1842\",\"type\":13,\"optionid\":\"87\",\"optionvalue\":[{\"id\":1842,\"fieldid\":24901,\"fieldoptionlinkid\":1842,\"optionid\":87,\"mainsupplier\":\"15\",\"blindtypecode\":null,\"optionname\":\"Range 6+5per_EX_RB\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":24901,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"87\",\"optionsvalue\":[{\"id\":1842,\"fieldid\":24901,\"fieldoptionlinkid\":1842,\"optionid\":87,\"mainsupplier\":\"15\",\"blindtypecode\":null,\"optionname\":\"Range 6+5per_EX_RB\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":24898,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Quantity\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":14,\"mandatory\":0,\"fieldname\":\"Quantity\",\"fieldid\":24898,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24900,\"labelname\":\"Supplier\",\"value\":\"15\",\"valueid\":null,\"type\":17,\"optionid\":\"15\",\"optionvalue\":[{\"id\":15,\"optionid\":15,\"optionname\":\"Excel\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"Supplier\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":17,\"mandatory\":0,\"fieldname\":\"Supplier\",\"fieldid\":24900,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"15\",\"optionsvalue\":[{\"id\":15,\"optionid\":15,\"optionname\":\"Excel\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":1}]", "oi_description": "Product Type: Range 6+5per_EX_RB, Supplier: Excel", "oi_reportdescription": "##Product Type: Range 6+5per_EX_RB##,##Quantity: 1##,##Supplier: Excel##", "oi_reporttitles": "##Product Type:<\/br>##Quantity:<\/br>##Supplier:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":23,\"value\":\"0.11\",\"formula\":\"If(MaterialType=\\\"Standard\\\",If(And(Fabric_FabricRollWidth<=1500,Fabric_Patternrepeat=0),((DropfromSuspensionPoint+290)*(TotalNoofwidths))\\\/1000,If(and(Fabric_FabricRollWidth<=1500,Fabric_Patternrepeat>0),(True),0)),(WidthofTrackPole*DefaultFullness)\\\/1000)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"0.11\"},{\"productionoveride\":0,\"id\":2,\"value\":null,\"formula\":\"If(MaterialType=\\\"Standard\\\",Round((If(MaterialType=\\\"Standard\\\",Fabric_UnitCost*((FabricQty)+Extrafabrictoorder),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder)))+Round((If(MaterialType=\\\"Standard\\\",Fabric_UnitCost*((FabricQty)+Extrafabrictoorder),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder)))\\\/100*FabricMarkUp),2,2),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder))\",\"price\":\"0.00\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":3,\"value\":\"44.88\",\"formula\":\"Heading_PriceTablePrice\",\"price\":\"44.88\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"44.88\"},{\"productionoveride\":0,\"id\":4,\"value\":\"2.50\",\"formula\":\"If(Heading=\\\"Eyelet5_BGC\\\",2,If(Heading=\\\"PencilPleat5_BGC\\\",2,If(Heading=\\\"TwinPleat5_BGC\\\",2,If(Heading=\\\"Eyelet5BlackoutLining_BGC\\\",2,If(Heading=\\\"PencilPleat5BlackoutLining_BGC\\\",2,If(Heading=\\\"TwinPleat5BlackoutLining_BGC\\\",2,If(Heading=\\\"Eyelet5Thermal_BGC\\\",2,If(Heading=\\\"PencilPleat5Thermal_BGC\\\",2,If(Heading=\\\"TwinPleat5Thermal_BGC\\\",2,If(Heading=\\\"Eyelet5Thermal+BO_BGC\\\",2,If(Heading=\\\"PencilPleat5Thermal+BO_BGC\\\",2,If(Heading=\\\"TwinPleat5Thermal+BO_BGC\\\",2,If(Heading=\\\"MachinedEyelet_CC\\\",1.8,If(Heading=\\\"MachinedPencilPleat_CC\\\",2.5,If(Heading=\\\"MachinedWave_CC\\\",2.3,If(Heading=\\\"MachinedTriplePinchPleat_CC\\\",2.2,If(Heading=\\\"MachinedTwinPleat_CC\\\",2.2,If(Heading=\\\"HandFinishedEyelet_CC\\\",1.8,If(Heading=\\\"HandFinishedPencilPleat_CC\\\",2,If(Heading=\\\"HandFinishedWave_CC\\\",2.3,If(Heading=\\\"HandFinishedTriplePinchPleat_CC\\\",2.2,If(Heading=\\\"SlotTop_CC\\\",2,If(Heading=\\\"PencilPleat-HandFinished_PCC\\\",2,If(Heading=\\\"PinchPleat-HandFinished_PCC\\\",2,If(Heading=\\\"Eyelet-HandFinished_PCC\\\",2,If(Heading=\\\"Wave-HandFinished_PCC\\\",2,If(Heading=\\\"PencilPleat-Machined_PCC\\\",2,If(Heading=\\\"PinchPleat-Machined_PCC\\\",2,If(Heading=\\\"Eyelet-Machined_PCC\\\",2,If(Heading=\\\"Wave-Machined_PCC\\\",2,If(Heading=\\\"Eyelet_WGC\\\",2,If(Heading=\\\"PencilPleat_WGC\\\",2,If(Heading=\\\"Wave_WGC\\\",2.3,If(Heading=\\\"Wave(lessfull)_WGC\\\",2.1,If(Heading=\\\"TriplePinchPleat_WGC\\\",2.5,If(Heading=\\\"DoublePinchPleat_WGC\\\",2.3,If(Heading=\\\"SinglePleat_WGC\\\",2,If(Heading=\\\"EyeletWideWidth_WGC\\\",2,If(Heading=\\\"PencilPleatWideWidth_WGC\\\",2,If(Heading=\\\"WaveWideWidth_WGC\\\",2.3,If(Heading=\\\"TriplePinchPleatWideWidth_WGC\\\",2.5,If(Heading=\\\"DoublePinchPleatWideWidth_WGC\\\",2,If(Heading=\\\"SinglePleatWideWidth_WGC\\\",2,0)))))))))))))))))))))))))))))))))))))))))))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"2.50\"},{\"productionoveride\":0,\"id\":6,\"value\":null,\"formula\":\"If(PairorSingle=\\\"Pair\\\",Widths*2,Widths)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":7,\"value\":\"0.11\",\"formula\":\"((FabricQty)+Extrafabrictoorder)*Quantity\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"0.11\"},{\"productionoveride\":0,\"id\":8,\"value\":null,\"formula\":\"(((FabricQty)+Extrafabrictoorder)*Quantity)*Lining_MakeupperWidth\",\"price\":null,\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":9,\"value\":null,\"formula\":\"Round(Widths*3,1)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":10,\"value\":null,\"formula\":\"RoundUp(Widths,0)-1\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":11,\"value\":null,\"formula\":\"if(UnitType=\\\"Inches\\\",(JoiningAllowance*25.4)\\\/10,if(UnitType=\\\"cm\\\",JoiningAllowance*10,JoiningAllowance))*(Numberofjoins)+ (if(UnitType=\\\"inches\\\",(SideTurningsDeduction*25.4)\\\/10,if(UnitType=\\\"cm\\\",(SideTurningsDeduction*10),SideTurningsDeduction)))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":5,\"value\":null,\"formula\":\"IF(PairorSingle=\\\"Pair\\\",RoundUp(IF(UnitType=\\\"mm\\\",WidthofTrackPole\\\/10,IF(UnitType=\\\"inch\\\",(WidthofTrackPole*25.4)\\\/10,IF(UnitType=\\\"inch\\\",WidthofTrackPole\\\/100,WidthofTrackPole)))*DefaultFullness\\\/If(MaterialType=\\\"Standard\\\",Fabric_FabricRollWidth\\\/10,Fabric_FabricRollDrop\\\/10),0)\\\/2,RoundUp((IF(UnitType=\\\"mm\\\",WidthofTrackPole\\\/10,IF(UnitType=\\\"inch\\\",(WidthofTrackPole*25.4)\\\/10,IF(UnitType=\\\"inch\\\",WidthofTrackPole\\\/100,WidthofTrackPole)))*DefaultFullness)\\\/If(MaterialType=\\\"Standard\\\",Fabric_FabricRollWidth\\\/10,Fabric_FabricRollDrop\\\/10),0))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":12,\"value\":\"294.50\",\"formula\":\"IF(UnitType=\\\"mm\\\",DropfromSuspensionPoint\\\/10,IF(UnitType=\\\"cm\\\",DropfromSuspensionPoint,IF(UnitType=\\\"inch\\\",(DropfromSuspensionPoint*25.4)\\\/10,DropfromSuspensionPoint\\\/100)))+IF(UnitType=\\\"inch\\\",(HeadingTurn*25.4),IF(UnitType=\\\"cm\\\",HeadingTurn*10,HeadingTurn))+IF(UnitType=\\\"inch\\\",(HemTurn*25.4),IF(UnitType=\\\"cm\\\",HemTurn*10,HemTurn))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"294.50\"},{\"productionoveride\":0,\"id\":13,\"value\":null,\"formula\":\"IF(Fabric_Patternrepeat>0,RoundUp((DropfromSuspensionPoint+HeadingTurn+HemTurn)\\\/(Fabric_Patternrepeat\\\/10),0),\\\"0\\\")\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":14,\"value\":\"294.50\",\"formula\":\"IF(NoOfPatternRepeats>0,NoOfPatternRepeats * IF(Fabric_Patternrepeat>0,Fabric_Patternrepeat\\\/10,1),FinishedCutLengths)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"294.50\"},{\"productionoveride\":0,\"id\":15,\"value\":null,\"formula\":\"RoundUp(Widths*If(MaterialType=\\\"Standard\\\",(Fabric_FabricRollWidth\\\/10),(If(MaterialType=\\\"Continuous\\\",(Fabric_FabricRollDrop\\\/10),\\\"\\\"))),0)-(Totalseamsandturnings)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":16,\"value\":null,\"formula\":\"Round(IF(PairorSingle=\\\"Pair\\\", Round(((IF(UnitType=\\\"mm\\\",WidthofTrackPole\\\/10,IF(UnitType=\\\"Inches\\\",(WidthofTrackPole*25.4)\\\/10,IF(UnitType=\\\"Inches\\\",WidthofTrackPole\\\/100,WidthofTrackPole)))+(Leftreturn\\\/10))+(Rightreturn\\\/10+Overlap\\\/10*2)+(Springbacktolerance*2))\\\/2,2), (IF(UnitType=\\\"mm\\\",WidthofTrackPole\\\/10,IF(UnitType=\\\"Inches\\\",(WidthofTrackPole*25.4)\\\/10,IF(UnitType=\\\"Inches\\\",WidthofTrackPole\\\/100,WidthofTrackPole)))+Leftreturn\\\/10+Rightreturn\\\/10+Springbacktolerance)),0)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":17,\"value\":null,\"formula\":\"((Finishedwidthoffabric)-(Spaceallowancesfinishedwidth))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":18,\"value\":null,\"formula\":\"Round((Spaceallowancesfinishedwidth\\\/10-(If(Leftreturn>0,Leftreturn\\\/10,Leftreturn\\\/10)+If(Overlap>0,Overlap\\\/10,Overlap\\\/10)))\\\/Qtyofspaces,0)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":19,\"value\":null,\"formula\":\"Round((RoundUp(Spaceallowancesfinishedwidth\\\/10,0)-((Leftreturn\\\/10)+(Overlap\\\/10)))\\\/if(Suspensionpointtowall>0,(Suspensionpointtowall\\\/10*2),1),0)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":20,\"value\":null,\"formula\":\"Qtyofspaces+1\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":21,\"value\":null,\"formula\":\"Round((Pleatsallowance)\\\/(Qtyofpleats),1)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":22,\"value\":\"245.00\",\"formula\":\"if(OR(Heading=\\\"Eyelet_WGC\\\",Heading=\\\"PencilPleat_WGC\\\",Heading=\\\"Wave_WGC\\\",Heading=\\\"TriplePinchPleat_WGC\\\",Heading=\\\"DoublePinchPleat_WGC\\\"),DropfromSuspensionPoint+200,0)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"245.00\"},{\"productionoveride\":0,\"id\":89,\"value\":null,\"formula\":\"(RoundUp((DropfromSuspensionPoint+290)\\\/Fabric_Patternrepeat,0)*Fabric_Patternrepeat)*(TotalNoofwidths)\\\/1000\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":98,\"value\":null,\"formula\":\"(Priceoftotalfabric+Makeupchargeoffabric+Makeupchargeoflining)\",\"price\":null,\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":99,\"value\":null,\"formula\":\"if(Border<>\\\"\\\",(TotalCost*0.2),0)\",\"price\":\"0.00\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "0.000", "oi_netprice": "0.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.000", "oi_vatvalue": "20.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "0.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_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[24899, 24901, 24898, 24900]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "80486", "oi_productiondate": 1748864495, "oi_createdat": 1748864495, "oi_updatedat": 1748844723, "oi_createdby": 14, "oi_updatedby": null } ], "updated": [], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [], "updated": [], "deleted": [] }, "bm_InvoiceDetails": { "created": [], "updated": [], "deleted": [] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [], "updated": [], "deleted": [] }, "bm_jobstatus_tracks": { "created": [], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 33250, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 15541, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 12778, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on June 02\",\"Description\":\"Job test\",\"app_summary\":\"11444-Test A\",\"Appointment Type\":\"Annual Leave\",\"Staff\":\"Kieren\",\"Job Ref No\":\"11444\",\"Start Date & Time\":\"2025-06-02 06:30:21\",\"End Date & Time\":\"2025-06-02 06:50:21\",\"Appointment Status\":\"Inprogress\",\"app_deliveryaddressid\":7296,\"app_jobtimeminute\":\"20\",\"app_deviceplatform\":1}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":15541,\"app_description\":\"Job test\",\"app_summary\":\"11444-Test A\",\"app_private\":0,\"app_appointmentType\":5,\"app_userId\":2,\"app_orderId\":12778,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-06-02\",\"app_edate\":\"2025-06-02\",\"app_stime\":\"06:30:21\",\"app_etime\":\"06:50:21\",\"app_sdatetime\":\"2025-06-02 06:30:21\",\"app_edatetime\":\"2025-06-02 06:50:21\",\"app_timezone\":\"Asia\\\/Calcutta\",\"app_latitude\":0,\"app_longitude\":0,\"app_parentappid\":null,\"app_recurrencerule\":null,\"app_userdefinedValue\":\"[]\",\"app_recurrenceexception\":null,\"app_recurrenceexception_date\":null,\"app_attachment\":null,\"guid\":\"\",\"app_until\":null,\"app_staff\":\"\",\"app_appointtype\":\"\",\"app_confirmed\":0,\"app_coordinates\":\"\",\"app_travelHour\":\"0\",\"app_travelMinute\":\"0\",\"app_onsiteHour\":null,\"app_onsiteMinute\":null,\"app_location\":null,\"app_traveltime\":null,\"app_googleid\":\"0\",\"app_platform\":\"web\",\"app_cal_status\":843,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":1,\"app_updatedBy\":null,\"app_createdAt\":\"2025-06-02T06:45:29.000000Z\",\"app_updatedAt\":\"2025-06-02T06:45:29.000000Z\",\"app_runid\":null,\"app_deliveryaddressid\":7296,\"app_jobtimehour\":\"0\",\"app_jobtimeminute\":\"20\",\"app_products\":null,\"app_deviceplatform\":1}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "33250", "cl_createdat": "1748846741.000000", "cl_updatedat": null } ], "updated": [], "deleted": [] }, "bm_productInfo": { "created": [], "updated": [ { "pi_productid": 60, "pi_productname": "Allusion Blind", "pi_pcode": "206", "pi_category": 3, "pi_productgroup": 1, "pi_producttype": 0, "pi_qtyperunit": "0.00", "pi_unitprice": "0.00", "pi_costfactor": null, "pi_commissionrate": "0.000", "pi_commissionmethod": null, "pi_reorderlevel": null, "pi_taxclass": null, "pi_serialno": null, "pi_qtyinstock": null, "pi_supplierid": null, "pi_imagename": null, "pi_currencyid": null, "pi_supplierdefault": null, "pi_productseqno": null, "pi_domesticmarkup": "0.00", "pi_contractmarkup": "0.00", "pi_trademarkup": "0.00", "pi_childsafe": null, "pi_quantyshowhide": null, "pi_compquantyshowhide": null, "pi_stockcontrol": null, "pi_productiontab": null, "pi_fabriccolorcodehide": null, "pi_defaultunitfornewcurtainsorder": null, "pi_costpricecomesfrom": "2", "pi_netpricecomesfrom": "2", "pi_shuttercontract": "0.00", "pi_shuttertrade": "0.00", "pi_shutterdomestic": "0.00", "pi_shutterecommerce": "0.00", "pi_customerdiscount": null, "pi_discountoverridesubwidth": null, "pi_manufacturer_cost": null, "pi_fabrichide": null, "pi_hidecompparameter": null, "pi_factorybarcodeproduct": null, "pi_showhideproductorder": 1, "pi_ecommercestatus": 0, "pi_productdescription": "", "pi_ecomproductdesc": null, "pi_homeimage": null, "pi_galleryimage": null, "pi_innerpageimage": null, "pi_frameimage": "[\"\\\/storage\\\/attachments\\\/TESTING3TEST\\\/productframeimages\\\/60\\\/Whiteflag_60.jpg\"]", "pi_ecommercecompmarkup": "0.00", "pi_showframeminmax": null, "pi_fabricdefaultdiscount": null, "pi_productstatusmultiple": 2, "pi_followproductionseq": 1, "pi_productionformulasheetname": null, "pi_productrules": null, "pi_showexcelfromula": null, "pi_supplierheading": null, "pi_producttypehide": null, "pi_dualproducttypeheading": "Fabric 2", "pi_fabricheading": null, "pi_dualproducttypeenable": 0, "pi_fabricbeforeproducttype": null, "pi_suppliermandatory": null, "pi_showfabric": null, "pi_ecommercesample": "1", "pi_priceavalcheck": null, "pi_showcomponentcode": null, "pi_showmaxarea": null, "pi_recessallowance": null, "pi_deductionname": null, "pi_deductionvalue": "0.00", "pi_stackqty": null, "pi_blindstype": null, "pi_suppliershowhide": null, "pi_pricealert": null, "pi_metatitle": null, "pi_metadescription": null, "pi_metakeyword": null, "pi_canonicaltag": null, "pi_alttexttag": null, "pi_headertag": "H1", "pi_productimage": "[\"\\\/storage\\\/attachments\\\/TESTING3TEST\\\/productimages\\\/60\\\/Bug_60.jpg\"]", "pi_workroom": 1, "pi_mobileapp": 1, "pi_jobtransfer": 1, "pi_seq": 2, "pi_status": 0, "pi_createdby": 1, "pi_defaultunittype": 2, "pi_jobfraction": 1, "pi_unittypeseq": "2,3,1,4", "pi_deafultimage": "{\"defaultimage\":{\"framedefault\":\"Whiteflag_60.jpg\",\"productdefault\":\"Bug_60.jpg\",\"backgrounddefault\":\"BulbOn_60.png\",\"bannerdefault\":\"Awnings_60.jpg\"}}", "pi_backgroundimage": "[\"\\\/storage\\\/attachments\\\/TESTING3TEST\\\/productbackgroundimages\\\/60\\\/AeroTrans_60.png\",\"\\\/storage\\\/attachments\\\/TESTING3TEST\\\/productbackgroundimages\\\/60\\\/BulbOn_60.png\",\"\\\/storage\\\/attachments\\\/TESTING3TEST\\\/productbackgroundimages\\\/60\\\/Car_60.jpg\",\"\\\/storage\\\/attachments\\\/TESTING3TEST\\\/productbackgroundimages\\\/60\\\/Hand_60.jpg\",\"\\\/storage\\\/attachments\\\/TESTING3TEST\\\/productbackgroundimages\\\/60\\\/India_60.jpg\",\"\\\/storage\\\/attachments\\\/TESTING3TEST\\\/productbackgroundimages\\\/60\\\/Lion1_60.jpg\",\"\\\/storage\\\/attachments\\\/TESTING3TEST\\\/productbackgroundimages\\\/60\\\/Kalai1_60.jpg\"]", "pi_discountappliesto": "{\"optionschk\":1,\"operationschk\":1,\"pricetablechk\":1}", "pi_ecomProductName": null, "pi_productgroupseq": null, "pi_unitypedata": "{\"1\":1,\"2\":1,\"3\":1,\"4\":1}", "id": "60" } ], "deleted": [] }, "bm_fields": { "created": [ { "fi_fieldId": 25335, "fi_fieldName": "Sub 1", "fi_fieldCode": null, "fi_fieldparamid": "95,96,94,433,97", "fi_productId": 60, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 3, "fi_fieldLevel": 2, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 1, "fi_isMandatory": 0, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 27, "fi_supplierid": "15,19", "id": "25335" } ], "updated": [], "deleted": [] }, "bm_fieldOptionLink": { "created": [ { "fol_fieldOptionLinkId": 66437, "fol_fieldId": 3904, "fol_optionId": 25482, "fol_productId": 60, "fol_masterParentFieldId": 3904, "fol_parentlinkid": 0, "fol_optionpricegroup": "0", "fol_pricegroupsupplier": "0", "fol_linkType": 1, "fol_seq": 6, "fol_status": 0, "id": "66437" }, { "fol_fieldOptionLinkId": 66438, "fol_fieldId": 25335, "fol_optionId": 25482, "fol_productId": 60, "fol_masterParentFieldId": 3904, "fol_parentlinkid": 66437, "fol_optionpricegroup": "0", "fol_pricegroupsupplier": "0", "fol_linkType": 0, "fol_seq": 1, "fol_status": 0, "id": "66438" }, { "fol_fieldOptionLinkId": 66439, "fol_fieldId": 25335, "fol_optionId": 25482, "fol_productId": 60, "fol_masterParentFieldId": 3904, "fol_parentlinkid": 0, "fol_optionpricegroup": "1571,62,65", "fol_pricegroupsupplier": "", "fol_linkType": 1, "fol_seq": 1, "fol_status": 0, "id": "66439" } ], "updated": [ { "fol_fieldOptionLinkId": 66439, "fol_fieldId": 25335, "fol_optionId": 25482, "fol_productId": 60, "fol_masterParentFieldId": 3904, "fol_parentlinkid": 0, "fol_optionpricegroup": "1571,62,65", "fol_pricegroupsupplier": "", "fol_linkType": 1, "fol_seq": 1, "fol_status": 0, "id": "66439" } ], "deleted": [] }, "bm_option": { "created": [ { "op_optionId": 25482, "op_jobtempid": "0", "op_fieldTypeId": 3, "op_optionType": 3, "op_customerType": "{\"1\":true,\"2\":true,\"3\":true}", "op_customisedformdata": "{\"94\":\"175mm Valance\",\"95\":\"\",\"96\":27849,\"97\":\"1571,62,65\",\"98\":\"\",\"101\":\"\",\"102\":\"\",\"103\":\"\",\"104\":1.5,\"105\":\"\",\"106\":1.5,\"107\":\"\",\"108\":1.5,\"109\":\"\",\"110\":\"\",\"111\":\"\",\"112\":\"\",\"113\":\"\",\"114\":\"\",\"115\":\"\",\"116\":\"\",\"117\":\"\",\"118\":\"\",\"119\":\"\",\"120\":\"\",\"123\":\"\",\"127\":3,\"258\":\"\",\"290\":\"\",\"433\":1,\"464\":\"\",\"503\":\"\",\"559\":1,\"581\":\"\",\"582\":\"\",\"583\":\"\",\"584\":\"\",\"585\":\"\",\"586\":\"\",\"593\":\"\"}", "op_hasprice": 1, "op_hasstock": 0, "op_filterbycontacttype": 0, "op_filterbypricegroup": 1, "op_filterbysupplier": 1, "op_filterbyshuttertype": 1, "op_filterbyshuttersupplier": 1, "op_filterbyminmax": 0, "op_active": 0, "op_status": 0, "id": "25482" } ], "updated": [ { "op_optionId": 25482, "op_jobtempid": "0", "op_fieldTypeId": 3, "op_optionType": 3, "op_customerType": "{\"1\":true,\"2\":true,\"3\":true}", "op_customisedformdata": "{\"94\":\"175mm Valance\",\"95\":\"\",\"96\":27849,\"97\":\"1571,62,65\",\"98\":\"\",\"101\":\"\",\"102\":\"\",\"103\":\"\",\"104\":1.5,\"105\":\"\",\"106\":1.5,\"107\":\"\",\"108\":1.5,\"109\":\"\",\"110\":\"\",\"111\":\"\",\"112\":\"\",\"113\":\"\",\"114\":\"\",\"115\":\"\",\"116\":\"\",\"117\":\"\",\"118\":\"\",\"119\":\"\",\"120\":\"\",\"123\":\"\",\"127\":3,\"258\":\"\",\"290\":\"\",\"433\":1,\"464\":\"\",\"503\":\"\",\"559\":1,\"581\":\"\",\"582\":\"\",\"583\":\"\",\"584\":\"\",\"585\":\"\",\"586\":\"\",\"593\":\"\"}", "op_hasprice": 1, "op_hasstock": 0, "op_filterbycontacttype": 0, "op_filterbypricegroup": 1, "op_filterbysupplier": 1, "op_filterbyshuttertype": 1, "op_filterbyshuttersupplier": 1, "op_filterbyminmax": 0, "op_active": 0, "op_status": 0, "id": "25482" } ], "deleted": [] }, "bm_optionproduct": { "created": [], "updated": [], "deleted": [] }, "bm_linkedfieldswithproduct": { "created": [], "updated": [], "deleted": [] }, "bm_productionstatus": { "created": [], "updated": [], "deleted": [] }, "bm_productpricemap": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipe": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipemap": { "created": [ { "prm_id": 434152, "prm_recipeid": 60, "prm_fieldtypeid": 3, "prm_fieldvalueid": 66437, "prm_status": 0, "id": "434152" }, { "prm_id": 434153, "prm_recipeid": 60, "prm_fieldtypeid": 3, "prm_fieldvalueid": 66439, "prm_status": 0, "id": "434153" } ], "updated": [ { "prm_id": 434153, "prm_recipeid": 60, "prm_fieldtypeid": 3, "prm_fieldvalueid": 66439, "prm_status": 0, "id": "434153" } ], "deleted": [] }, "bm_supproductcode": { "created": [], "updated": [], "deleted": [] }, "bm_rulesetup": { "created": [], "updated": [], "deleted": [] }, "bm_formulas": { "created": [], "updated": [], "deleted": [] }, "bm_customercommission": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupdetails": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupmaterialmap": { "created": [], "updated": [], "deleted": [] }, "bm_productpricedetails": { "created": [], "updated": [], "deleted": [] }, "bm_fabriccolourmap": { "created": [], "updated": [], "deleted": [] }, "bm_fabricdetails": { "created": [], "updated": [], "deleted": [] }, "bm_colordetails": { "created": [], "updated": [], "deleted": [] }, "bm_optiondiscount": { "created": [], "updated": [], "deleted": [] }, "bm_optionpricebook": { "created": [], "updated": [], "deleted": [] }, "bm_allowances": { "created": [], "updated": [], "deleted": [] }, "bm_xyoptionpricedata": { "created": [], "updated": [ { "xyo_id": 7679, "xyo_optionid": 25482, "xyo_unittype": 2, "xyo_length": 6000, "xyo_inches": "0.00", "xyo_fractionid": 0, "xyo_optiontype": 3, "xyo_price": "222.00", "xyo_unitjson": "{\"2\":\"6000.00\",\"3\":\"6.00\",\"1\":\"600.00\",\"4\":\"236.22\"}", "xyo_status": 0, "id": "7679" } ], "deleted": [] }, "bm_delivery_cost_setup": { "created": [], "updated": [], "deleted": [] }, "bm_organizationdetails": { "created": [], "updated": [], "deleted": [] }, "bm_applicationSetup": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": { "bm_appointment": { "151748846729": 15541 } }, "timestamp": 1748846741 }