· 6 years ago · Oct 03, 2019, 06:38 AM
1--<IssueID:106172>,Date:01-Oct-2018,Done By:Anvesh Kumar Dubey<1394>
2--<IssueID:108637>,Date:12-Oct-2018,Done By:Anvesh Kumar Dubey<1394>
3--<IssueID:118776>,Date:26-Nov-2018,Done By:Anvesh Kumar Dubey<1394>
4--<IssueID:120138>,Date:12 Dec 2018,Done By:Sarvajit<1381>
5--<IssueID:120138>,Date:13 Dec 2018,Done By:Sarvajit<1381>
6/*<IssueID:123790>,Date:01-Feb-2019,Done By:Aakshi Gupta<1284>*/
7/*<IssueID:125662>,Date:27-Mar-2019,Done By:Sumit Bhardwaj<1414>*/
8/*<IssueID:112364>,Date:27-Jun-2019,Done By:Anvesh Kumar Dubey<1394>*/
9/*<IssueID:140066>,Date:03-Sep-2019,Done By:Anvesh Kumar Dubey<1394>*/
10if exists(Select Top 1 1 from sys.procedures where Name='xspOCGetJsonDef')
11 DROP PROCEDURE xspOCGetJsonDef
12GO
13CREATE PROCEDURE xspOCGetJsonDef
14(
15 @guid xdtName,
16 @pageName xdtName,
17 @pageParams NVARCHAR(max)='',
18 @errorMsg NVARCHAR(max)='' out
19)
20AS
21BEGIN
22 SET NOCOUNT ON;
23 BEGIN TRY
24 DECLARE @companyCode xdtCompanyCode,@memberCompanyCode xdtCompanyCode,@userName xdtName,@languageCode xdtName,@sectionName xdtName,@FromPage xdtName
25 EXEC xspGetSessionVariable @guid =@guid,@companyCode =@companyCode OUTPUT,@memberCompanyCode =@memberCompanyCode OUTPUT,
26 @userName=@userName OUTPUT,@languageCode=@languageCode OUTPUT
27 --Start<IssueID:108637>
28 /*Start<IssueID:140066>*/
29 DECLARE @EnablePaymentTerms xdtName,@ExportColList NVARCHAR(MAX),@CalledFor xdtName,
30 @From xdtName, @EnablePCDDateMandatoryOC xdtName = '0',@Action xdtName = '', @IsActionView xdtName = '0'
31 /*End<IssueID:140066>*/
32 --End<IssueID:108637>
33 Declare @ToShowActualPOPacketTargetDateOnSalesOrderList int,@POPacketTargetDateVisible int, @EnableRequestForCancellation int,
34 @FulfillmentTypeVisible int,@EnableRequestforBudgetonOC INT,@EnableSalesOrderCategory int,@EnableFactoryAllocationInSummaryOC xdtName
35 select @ToShowActualPOPacketTargetDateOnSalesOrderList=0,@POPacketTargetDateVisible=0,@FulfillmentTypeVisible=0 ,
36 @EnableRequestforBudgetonOC=0,@EnableSalesOrderCategory=0,@EnableFactoryAllocationInSummaryOC='0'
37
38 Declare @mnuPostShipmentCostSheetReport int,@mnuOrderpendingforClosure int,@mnuPOLinkWithOC int,@mnuPOLinkWithOCList int,
39 @mnuManageSalesOrders int,@mnuManageSalesOrdersList int,@mnuEnableDeleteOrder int,@mnuEnableCancelOrder int,
40 @mnuManageBuyingOrdersList int,@mnuEnableCloseOrder int,@mnuManageSalesOrdersNew int,@mnuRequestForBudget int,
41 @mnuPostShipmentCostSheetReportPermissionType int,@mnuOrderpendingforClosurePermissionType int,
42 @mnuPOLinkWithOCPermissionType int,@mnuPOLinkWithOCListPermissionType int,
43 @mnuManageSalesOrdersPermissionType int,@mnuManageSalesOrdersListPermissionType int,@mnuEnableDeleteOrderPermissionType int,
44 @mnuEnableCancelOrderPermissionType int,@mnuManageBuyingOrdersListPermissionType int,@mnuEnableCloseOrderPermissionType int,
45 @mnuManageSalesOrdersNewPermissionType int,@mnuRequestForBudgetPermissionType int
46
47 Select @mnuPostShipmentCostSheetReport =0,@mnuOrderpendingforClosure =0,@mnuPOLinkWithOC =0,@mnuPOLinkWithOCList =0,
48 @mnuManageSalesOrders =0,@mnuManageSalesOrdersList =0,@mnuEnableDeleteOrder =0,@mnuEnableCancelOrder =0,
49 @mnuManageBuyingOrdersList =0, @mnuEnableCloseOrder =0,@mnuManageSalesOrdersNew =0,@mnuRequestForBudget =0
50 ,@mnuPostShipmentCostSheetReportPermissionType =-1,@mnuOrderpendingforClosurePermissionType =-1,@mnuPOLinkWithOCPermissionType =-1,
51 @mnuPOLinkWithOCListPermissionType =-1,@mnuManageSalesOrdersPermissionType =-1,@mnuManageSalesOrdersListPermissionType =-1,
52 @mnuEnableDeleteOrderPermissionType =-1,@mnuEnableCancelOrderPermissionType =-1,@mnuManageBuyingOrdersListPermissionType =-1,
53 @mnuEnableCloseOrderPermissionType =-1,@mnuManageSalesOrdersNewPermissionType =-1,@mnuRequestForBudgetPermissionType =-1
54 /*Start<IssueID:140066>*/
55 if ISNULL(@pageParams,'')<>''
56 begin
57 Create table #paramList(ParamName varchar(200),ParamValue varchar(8000))
58 Exec xspGetTableFromString @Details =@pageParams,@RowSeprator='~',@ColumnSeperator='|',@TableName ='#paramList'
59 Select @sectionName=ParamValue From #paramList Where ParamName='sectionName'
60 Select @EnablePaymentTerms=ParamValue From #paramList Where ParamName='EnablePaymentTerms'
61 SELECT @FromPage = ParamValue from #paramList where ParamName='FromPage'
62 SELECT @CalledFor = ParamValue from #paramList where ParamName='CalledFor'
63 SELECT @From = ParamValue from #paramList where ParamName='from'
64 SELECT @Action = ParamValue From #paramList where ParamName='Action'
65 End
66
67 IF @Action = 'View'
68 SELECT @IsActionView = '1'
69 /*End<IssueID:140066>*/
70 SELECT @EnableFactoryAllocationInSummaryOC = dbo.xfGetCompanySettingV1(@CompanyCode , 'Misc' , 'EnableFactoryAllocationInSummaryOC',@memberCompanyCode)
71
72 SELECT Programname,FieldName,FieldValue
73 into #CompanySettings
74 from xtCompanySettings (nolock)
75 where Companycode=@companyCode
76 and Programname in ('Misc' ,'OC')
77 and FieldName in ('ToShowActualPOPacketTargetDateOnSalesOrderList','POPacketTargetDateVisible','EnableRequestForCancellation','FulfillmentTypeVisible','EnableRequestforBudgetonOC','EnableSalesOrderCategory')
78 and FieldValue=1
79
80 if exists(select top 1 1 from #CompanySettings where Programname ='Misc' and FieldName='ToShowActualPOPacketTargetDateOnSalesOrderList')
81 set @ToShowActualPOPacketTargetDateOnSalesOrderList=1
82
83 if exists(select top 1 1 from #CompanySettings where Programname ='OC' and FieldName='POPacketTargetDateVisible')
84 set @POPacketTargetDateVisible=1
85
86 if exists(select top 1 1 from #CompanySettings where Programname ='Misc' and FieldName='EnableRequestForCancellation')
87 set @EnableRequestForCancellation=1
88
89 if exists(select top 1 1 from #CompanySettings where Programname ='OC' and FieldName='FulfillmentTypeVisible')
90 set @FulfillmentTypeVisible=1
91 if exists(select top 1 1 from #CompanySettings where Programname ='Misc' and FieldName='EnableSalesOrderCategory')
92 set @EnableSalesOrderCategory=1
93 if exists(select top 1 1 from #CompanySettings where Programname ='Misc' and FieldName='EnableRequestforBudgetonOC')
94 set @EnableRequestforBudgetonOC=1
95
96 ------Menu
97 Select @mnuPostShipmentCostSheetReport = dbo.xfGetMenuPermissionAll('mnuPostShipmentCostSheetReport',@userName,@companyCode,0)
98 Select @mnuOrderpendingforClosure =dbo.xfGetMenuPermissionAll('mnuOrderpendingforClosure',@userName,@companyCode,0)
99 Select @mnuPOLinkWithOC =dbo.xfGetMenuPermissionAll('mnuPOLinkWithOC',@userName,@companyCode,0)
100 Select @mnuPOLinkWithOCList =dbo.xfGetMenuPermissionAll('mnuPOLinkWithOCList',@userName,@companyCode,0)
101 Select @mnuManageSalesOrders =dbo.xfGetMenuPermissionAll('mnuManageSalesOrders',@userName,@companyCode,0)
102 Select @mnuManageSalesOrdersList =dbo.xfGetMenuPermissionAll('mnuManageSalesOrdersList',@userName,@companyCode,0)
103 Select @mnuEnableDeleteOrder =dbo.xfGetMenuPermissionAll('mnuEnableDeleteOrder',@userName,@companyCode,0)
104 Select @mnuEnableCancelOrder =dbo.xfGetMenuPermissionAll('mnuEnableCancelOrder',@userName,@companyCode,0)
105 Select @mnuManageBuyingOrdersList =dbo.xfGetMenuPermissionAll('mnuManageBuyingOrdersList',@userName,@companyCode,0)
106 Select @mnuEnableCloseOrder =dbo.xfGetMenuPermissionAll('mnuEnableCloseOrder',@userName,@companyCode,0)
107 Select @mnuManageSalesOrdersNew =dbo.xfGetMenuPermissionAll('mnuManageSalesOrdersNew',@userName,@companyCode,0)
108 Select @mnuRequestForBudget =dbo.xfGetMenuPermissionAll('mnuRequestForBudget',@userName,@companyCode,0)
109 ---Menu PermissionType
110 Select @mnuPostShipmentCostSheetReportPermissionType=dbo.xfGetBaseProgramPermissionType(@CompanyCode , @MemberCompanyCode , @UserName , 'mnuPostShipmentCostSheetReport')
111 Select @mnuOrderpendingforClosurePermissionType=dbo.xfGetBaseProgramPermissionType(@CompanyCode , @MemberCompanyCode , @UserName , 'mnuOrderpendingforClosure')
112 Select @mnuPOLinkWithOCPermissionType=dbo.xfGetBaseProgramPermissionType(@CompanyCode , @MemberCompanyCode , @UserName , 'mnuPOLinkWithOC')
113 Select @mnuPOLinkWithOCListPermissionType=dbo.xfGetBaseProgramPermissionType(@CompanyCode , @MemberCompanyCode , @UserName , 'mnuPOLinkWithOCList')
114 Select @mnuManageSalesOrdersPermissionType=dbo.xfGetBaseProgramPermissionType(@CompanyCode , @MemberCompanyCode , @UserName , 'mnuManageSalesOrders')
115 Select @mnuManageSalesOrdersListPermissionType=dbo.xfGetBaseProgramPermissionType(@CompanyCode , @MemberCompanyCode , @UserName , 'mnuManageSalesOrdersList')
116 Select @mnuEnableDeleteOrderPermissionType=dbo.xfGetBaseProgramPermissionType(@CompanyCode , @MemberCompanyCode , @UserName , 'mnuEnableDeleteOrder')
117 Select @mnuEnableCancelOrderPermissionType=dbo.xfGetBaseProgramPermissionType(@CompanyCode , @MemberCompanyCode , @UserName , 'mnuEnableCancelOrder')
118 Select @mnuManageBuyingOrdersListPermissionType=dbo.xfGetBaseProgramPermissionType(@CompanyCode , @MemberCompanyCode , @UserName , 'mnuManageBuyingOrdersList')
119 Select @mnuEnableCloseOrderPermissionType=dbo.xfGetBaseProgramPermissionType(@CompanyCode , @MemberCompanyCode , @UserName , 'mnuEnableCloseOrder')
120 Select @mnuManageSalesOrdersNewPermissionType=dbo.xfGetBaseProgramPermissionType(@CompanyCode , @MemberCompanyCode , @UserName , 'mnuManageSalesOrdersNew')
121 Select @mnuRequestForBudgetPermissionType=dbo.xfGetBaseProgramPermissionType(@CompanyCode , @MemberCompanyCode , @UserName , 'mnuRequestForBudget')
122
123 --Start<IssueID:108637>
124 --Start<IssueID:118776>
125 If Exists( select Top 1 1 from xtCompanySettings where Companycode=@companyCode and Programname in ('Misc')
126 and FieldName in ('PCDDateMandatoryOC') and FieldValue=1)
127 begin
128 set @EnablePCDDateMandatoryOC = '1'
129 end
130 --End<IssueID:118776>
131 --End<IssueID:108637>
132
133 Declare @JSONKey xdtUniCodeMaxText,@JSONDefSP xdtName
134 Select @JSONDefSP='xspOCGetJsonDef'
135 /*Start<IssueID:123790>*/
136 /*Start<IssueID:140066>*/
137 Select @JSONKey=''
138 Select @JSONKey=cast(ISNULL(@EnablePaymentTerms,'') as varchar)+'|'+cast(ISNULL(@CalledFor,'') as varchar)+'|'+cast(ISNULL(@From,'') as varchar)
139 Select @JSONKey=@JSONKey+'|'+cast(ISNULL(@EnablePCDDateMandatoryOC,'') as varchar)+'|'+cast(ISNULL(@sectionName,'') as varchar)+'|'+cast(isnull(@FromPage,'') as varchar)
140 Select @JSONKey=@JSONKey+'|'+cast(@ToShowActualPOPacketTargetDateOnSalesOrderList as varchar)+'|'+cast(@POPacketTargetDateVisible as varchar)+'|'+cast(isnull(@EnableRequestForCancellation,'') as varchar)
141 Select @JSONKey=@JSONKey+'|'+cast(@FulfillmentTypeVisible as varchar)+'|'+cast(@EnableRequestforBudgetonOC as varchar)+'|'+cast(@EnableSalesOrderCategory as varchar)
142 Select @JSONKey=@JSONKey+'|'+cast(@EnableFactoryAllocationInSummaryOC as varchar)
143 Select @JSONKey=@JSONKey+'|'+cast(@mnuPostShipmentCostSheetReport as varchar)+'|'+cast(@mnuPostShipmentCostSheetReportPermissionType as varchar)
144 Select @JSONKey=@JSONKey+'|'+cast(@mnuOrderpendingforClosure as varchar)+'|'+cast(@mnuOrderpendingforClosurePermissionType as varchar)
145 Select @JSONKey=@JSONKey+'|'+cast(@mnuPOLinkWithOC as varchar)+'|'+cast(@mnuPOLinkWithOCPermissionType as varchar)
146 Select @JSONKey=@JSONKey+'|'+cast(@mnuPOLinkWithOCList as varchar)+'|'+cast(@mnuPOLinkWithOCListPermissionType as varchar)
147 Select @JSONKey=@JSONKey+'|'+cast(@mnuManageSalesOrders as varchar)+'|'+cast(@mnuManageSalesOrdersPermissionType as varchar)
148 Select @JSONKey=@JSONKey+'|'+cast(@mnuManageSalesOrdersList as varchar)+'|'+cast(@mnuManageSalesOrdersListPermissionType as varchar)
149 Select @JSONKey=@JSONKey+'|'+cast(@mnuEnableDeleteOrder as varchar)+'|'+cast(@mnuEnableDeleteOrderPermissionType as varchar)
150 Select @JSONKey=@JSONKey+'|'+cast(@mnuEnableCancelOrder as varchar)+'|'+cast(@mnuEnableCancelOrderPermissionType as varchar)
151 Select @JSONKey=@JSONKey+'|'+cast(@mnuManageBuyingOrdersList as varchar)+'|'+cast(@mnuManageBuyingOrdersListPermissionType as varchar)
152 Select @JSONKey=@JSONKey+'|'+cast(@mnuEnableCloseOrder as varchar)+'|'+cast(@mnuEnableCloseOrderPermissionType as varchar)
153 Select @JSONKey=@JSONKey+'|'+cast(@mnuManageSalesOrdersNew as varchar)+'|'+cast(@mnuManageSalesOrdersNewPermissionType as varchar)
154 Select @JSONKey=@JSONKey+'|'+cast(@mnuRequestForBudget as varchar)+'|'+cast(@mnuRequestForBudgetPermissionType as varchar)
155 Select @JSONKey=@JSONKey+'|'+@IsActionView
156 Select @JSONKey=@JSONKey+ '~'
157 /*End<IssueID:140066>*/
158 /*End<IssueID:123790>*/
159 If exists(Select top 1 1 from xtCompanyWisePageJSONData (nolock) where CompanyCode=@companyCode and PageName=@pageName and JSONDefSP=@JSONDefSP and JSONKey=@JSONKey)
160 Begin
161 Select Sno,SectionID,SectionType,DataSource,JSONData
162 from xtCompanyWisePageJSONData (nolock) where CompanyCode=@companyCode and PageName=@pageName and JSONDefSP=@JSONDefSP and JSONKey=@JSONKey
163 Order By Sno
164 Return
165 End
166
167 SELECT * INTO #Sections FROM dbo.xfGetXMLSectionDefinition()
168 SELECT * INTO #TitleBarDefinition FROM dbo.xfGetXMLTitleBarDefinition()
169 SELECT * INTO #TitleBarToolsDefinition FROM dbo.xfGetXMLTitleBarToolsDefinition()
170 SELECT * INTO #SectionRows FROM dbo.xfGetXMLRowsDefinition()
171 SELECT * INTO #SectionCells FROM dbo.xfGetXMLCellsDefinition()
172 SELECT * INTO #SectionItems FROM dbo.xfGetXMLItemsDefinition()
173 SELECT * INTO #SectionAttributes FROM dbo.xfGetXMLAttributesDefinition()
174 SELECT * INTO #SectionAttributesParams FROM dbo.xfGetXMLAttributesParamsDefinition()
175
176 SELECT * INTO #SectionGridColumns FROM dbo.xfGetXMLGridColumnsDefinition()
177 SELECT * INTO #SectionGridColumnItem FROM dbo.xfGetXMLGridColumnItemDefinition()
178 SELECT * INTO #SectionGridColumnItemAttributes FROM dbo.xfGetXMLGridColumnItemAttributesDefinition()
179 SELECT * INTO #SectionGridColumnItemAttributesParams FROM dbo.xfGetXMLGridColumnItemAttributesParamsDefinition()
180
181 if (@FromPage in ('WFXOCASNDelayOrShort','WFXOrderTransferPrice'))
182 Begin
183 SET @pageName = @FromPage
184 END
185
186 EXEC xspCompanyWiseJSONGetData @companyCode =@companyCode,@memberCompanyCode =@memberCompanyCode,@pageName =@pageName,
187 @userName =@userName,@languageCode=@languageCode,@action= 'SetRawXML',@errorMsg=@errorMsg OUT
188 IF (@errorMsg <> '') RETURN
189
190 IF @sectionName = 'LCUpdate'
191 Begin
192 Delete #TitleBarToolsDefinition where SectionID = 'sectionOCList'
193 and ToolType in ('AddnContinue','AddnClose','CloseWindow')
194 Delete #SectionGridColumns where SectionID = 'sectionOCList'
195 and ColID not in ('ColCheckBox','ColBuyer','ColOCNo','ColDeliveryStartDate','colTotalValue','colLCRequestNo','colLCAllocatedValue','ColOrderedQty','ColCurrencyCode','ColLCTerm')
196
197 UPDATE #SectionGridColumnItem SET Value='Quantity' WHERE SectionID = 'sectionOCList' and ColID='ColOrderedQty' AND ItemID='lblQty'
198 UPDATE #SectionGridColumnItem SET Value='BuyerCompanyName' WHERE SectionID = 'sectionOCList' and ColID='ColBuyer' AND ItemID='lblBuyer'
199 IF @EnablePaymentTerms = '0'
200 DELETE #SectionGridColumns where SectionID = 'sectionOCList' and ColID = 'ColLCTerm'
201 End
202
203 if (@FromPage = 'WFX_OC' )
204 BEGIN
205 Delete #Sections where SectionID<>'sectionOCList'
206
207 Delete #TitleBarToolsDefinition
208 where SectionID = 'sectionOCList' and ToolType<>'Ok' and ToolType<>'CloseDiv'
209
210 update #TitleBarDefinition set SectionTitle='',TooltipTranslationID='', TranslationID='' where SectionID='sectionOCList'
211
212 Delete #SectionGridColumns where SectionID='sectionOCList' and ColID not in('colSelector','ColBuyer','ColOrderRefNo','ColBuyerStyleRef','colSealByDate','ColTechnicalManagerName')
213
214 update #SectionGridColumns
215 set Visible='true'
216 where SectionID='sectionOCList' and ColID in('colSelector', 'ColBuyer','ColOrderRefNo','ColBuyerStyleRef','colSealByDate','ColTechnicalManagerName')
217
218 update #SectionGridColumns set Sort='true' where SectionID='sectionOCList' and ColID in( 'ColBuyer','ColOrderRefNo')
219
220 END
221 Else
222 Begin
223 Delete #TitleBarToolsDefinition where SectionID = 'sectionOCList' and ToolType in ('Ok','CloseDiv')
224 End
225
226 if (@FromPage = 'WFXOrderPendingForClosure' )
227 BEGIN
228 update #TitleBarToolsDefinition set ToolValue='Close OC' where SectionID='sectionOrderClosureDetail'
229 and TitleBarId='titlebarOrderClosureDetail' AND ToolType='save'
230
231 END
232
233 if (@FromPage = 'WFXOCList' OR @FromPage = 'wfx_CostSheetRO')
234 begin
235
236 IF @FromPage = 'wfx_CostSheetRO'
237 BEGIN
238 DELETE FROM #SectionGridColumns WHERE SectionID NOT IN('sectionOC')
239 DELETE #TitleBarToolsDefinition WHERE toolType not in ('Confirm','Exit')
240
241 Delete #SectionGridColumns where SectionID='sectionOC'
242 and ColID not in('ColCheckBox','colBuyerName','colOCDivisionName','colMainOCNumWithBuyerRefNum','colProformaInvoiceNumWithOrderRefNum','colTotalQty','ColSeason','ColOCUOM','ColIsSAMProdEffVAUpdated')
243
244 UPDATE #SectionGridColumns SET value='Company Division' where SectionID='sectionOC' and ColID='colOCDivisionName'
245 UPDATE #SectionGridColumns SET value='Main OC' where SectionID='sectionOC' and ColID='colMainOCNumWithBuyerRefNum'
246 UPDATE #SectionGridColumns SET value='Summary OC' where SectionID='sectionOC' and ColID='colProformaInvoiceNumWithOrderRefNum'
247 UPDATE #SectionGridColumns SET value='Quantity' where SectionID='sectionOC' and ColID='colTotalQty'
248
249 UPDATE #SectionGridColumns set visible='true' where ColID='ColCheckBox'
250 UPDATE #TitleBarToolsDefinition set visible='true' where toolType='Confirm'
251 UPDATE #TitleBarToolsDefinition set visible='true' where toolType='Exit'
252 UPDATE #SectionGridColumns set visible='true' where sectionid='sectionOC' and ColID in ('ColSeason','ColOCUOM','ColIsSAMProdEffVAUpdated')
253 UPDATE #SectionGridColumnItem SET ItemType='Label'
254 WHERE sectionid='sectionOC' AND ItemType='LinkButton' AND ColID IN ('colMainOCNumWithBuyerRefNum','colProformaInvoiceNumWithOrderRefNum','colBuyerName')
255 END
256 ELSE IF(@CalledFor='OCDeliveryUpdate' AND @From='OC')
257 BEGIN
258 DELETE #TitleBarToolsDefinition WHERE toolType not in ('Save','Export')
259 Delete #SectionGridColumns where SectionID='sectionOC'
260 and ColID in('colSelector','colOverPlannedProduced','colTrack','colDispatch','colPostShipmentCostSheet','colRequestforCancellation','colOrderClosureDetails','colPOs',
261 'colOCDivisionName','colCreatedByUser','colEndCustomer','colOrderCode','colTaskName','colTaskStatus','colTaskColor')
262
263 UPDATE #TitleBarDefinition set SectionTitle='Purchase Orders From Buyers - Delivery Update' WHERE SectionID='titlebarOC'
264 UPDATE #TitleBarToolsDefinition set visible='true' where toolType='Save'
265 /*Start<IssueID:125662>*/
266 UPDATE #SectionGridColumnItem SET ItemType='Label'
267 WHERE sectionid='sectionOC' AND ItemType='LinkButton' AND ColID IN ('colMainOCNumWithBuyerRefNum','colBuyerName','colBuyerStyleRefNum','colOrderCode')
268 /*End<IssueID:125662>*/
269 --Start<IssueID:108637>
270 UPDATE #SectionGridColumns set visible='true' where sectionid='sectionOC' and ColID in ('colBuyerDeliveryDate','colOCDeliveryDate','colBuyerOrderDate','colPCDDate')
271 if (@EnablePCDDateMandatoryOC = '1')
272 UPDATE #SectionGridColumnItem set Mandatory='true' where sectionid='sectionOC' and ItemID in ('dtPCDDate','dtBuyerDeliveryDate','dtOCDeliveryDate','dtBuyerOrderDate')
273 else
274 UPDATE #SectionGridColumnItem set Mandatory='true' where sectionid='sectionOC' and ItemID in ('dtBuyerDeliveryDate','dtOCDeliveryDate','dtBuyerOrderDate')
275 --End<IssueID:108637>
276 END
277 ELSE IF(@CalledFor='OCDeliveryUpdate' AND @From='DeliveryOC')
278 BEGIN
279 DELETE #TitleBarToolsDefinition WHERE toolType not in ('Save','Export')
280 Delete #SectionGridColumns where SectionID='sectionDeliveryOC'
281 and ColID in('colOverPlannedProduced','colTrack','colDispatch','colPostShipmentCostSheet','colRequestforCancellation','colOrderClosureDetails','colPOs')
282
283 UPDATE #TitleBarDefinition set SectionTitle='Purchase Orders From Buyers - Delivery Update'
284 UPDATE #TitleBarToolsDefinition set visible='true' where toolType='Save'
285 /*Start<IssueID:125662>*/
286 UPDATE #SectionGridColumnItem SET ItemType='Label'
287 WHERE sectionid='sectionDeliveryOC' AND ItemType='LinkButton' AND ColID IN ('colMainOCNumWithBuyerRefNum','colBuyerName','colBuyerStyleRefNum','colOrderCode')
288 /*End<IssueID:125662>*/
289 --Start<IssueID:108637>
290 UPDATE #SectionGridColumns set visible='true' where sectionid='sectionDeliveryOC' and ColID in ('colBuyerOrderDate','colPCDDate')
291 if (@EnablePCDDateMandatoryOC = '1')
292 UPDATE #SectionGridColumnItem set Mandatory='true' where sectionid='sectionDeliveryOC' and ItemID in ('dtPCDDate','dtBuyerDeliveryDate','dtOCDeliveryDate','dtBuyerOrderDate')
293 else
294 UPDATE #SectionGridColumnItem set Mandatory='true' where sectionid='sectionDeliveryOC' and ItemID in ('dtBuyerDeliveryDate','dtOCDeliveryDate','dtBuyerOrderDate')
295 --End<IssueID:108637>
296 END
297 ELSE
298 BEGIN
299 DELETE #Sections where SectionID IN('sectionOCTabControl','sectionDeliveryOC')
300 if(@pageName='WFXOCList')
301 begin
302 update #SectionGridColumns set visible='true' where SectionID='sectionOC'
303 and ColID = 'ColSeason'
304 end
305 END
306
307 DELETE fROM #Sections WHERE SectionID IN('sectionOCList','sectionShowOCOrderHeader')
308 IF(@CalledFor='OCDeliveryUpdate')
309 BEGIN
310 Select @ExportColList=N'|~Status|StatusToShow~Company|OCCompanyName~Main OC No.|MainOCNumWithBuyerRefNum'
311 Select @ExportColList=@ExportColList +N'~OC No.(Buyer Order Ref.)|ProformaInvoiceNumWithOrderRefNum~Buyer|BuyerName'
312 Select @ExportColList=@ExportColList +N'~Article|BuyerStyleRefNum~Factory Order Type|FactoryOrderType~Initial/Repeat|InitialOrRepeat'
313 Select @ExportColList=@ExportColList +N'~Fulfillment Type|FulfillmentType~Qty.|TotalQty~First Delivery Date|TargetDate~Buyer Delivery Date|BuyerDeliveryDate~OC Delivery Date|OCDeliveryDate~'
314 IF @From='OC'
315 Select @ExportColList=@ExportColList +N'|'
316 ELSe If @From='DeliveryOC'
317 BEGIN
318 SELECT @ExportColList=@ExportColList +N'Delivery Order Ref No.|DeliveryOrderRefNo~'
319 Select @ExportColList=@ExportColList +N'|'
320 END
321 END
322 ELSE
323 BEGIN
324 Select @ExportColList=N'|~Status|StatusToShow~Company|OCCompanyName~Division Company|OCDivisionName~Main OC No.|MainOCNumWithBuyerRefNum~Last Created/Revised By|CreatedByUser'
325 Select @ExportColList=@ExportColList +N'~OC No.(Buyer Order Ref.)|ProformaInvoiceNumWithOrderRefNum~Over Planned/Produced|MismatchQtyDesc~PO(s)|OCGMPOMismatchButtonName~Buyer|BuyerName'
326 Select @ExportColList=@ExportColList +N'~End Customer|EndCustomer~Article|BuyerStyleRefNum~Order Code|OrderCode~Factory Order Type|FactoryOrderType~Initial/Repeat|InitialOrRepeat'
327 Select @ExportColList=@ExportColList +N'~Fulfillment Type|FulfillmentType~Qty.|TotalQty~First Delivery Date|TargetDate~Task|TaskName~Task Color|TaskColor~Task Status|TaskStatus~PO Packet Date|POPacketDate~Actual PO Packet Date|ActualPOPacketDate~'
328 Select @ExportColList=@ExportColList +N'|'
329 END
330 Update #SectionItems
331 SET ExportColList = @ExportColList
332 Where SectionID='sectionOC' and ItemID='gridOC'
333
334 if @FulfillmentTypeVisible=0
335 begin
336 update #SectionGridColumns set visible='false' where sectionid='sectionOC' and ColID in ('colFulfillmentType')
337 end
338 if @EnableSalesOrderCategory=1
339 begin
340 update #SectionGridColumns set visible='true' where sectionid='sectionOC' and ColID in ('colSalesOrderCategory')
341 end
342 if (@ToShowActualPOPacketTargetDateOnSalesOrderList=0 or @POPacketTargetDateVisible=0)
343 begin
344 update #SectionGridColumns set visible='false' where sectionid='sectionOC' and ColID in ('colPOPacketDate','colActualPOPacketDate')
345 end
346
347
348 if @mnuManageSalesOrders=0
349 begin
350 update #TitleBarToolsDefinition set visible='false' where toolType in ('Generate MRL','Search')
351 end
352
353
354 if @mnuManageSalesOrdersNew=0
355 begin
356 update #TitleBarToolsDefinition set visible='false' where toolType in ('New')
357 end
358
359 if @mnuEnableDeleteOrder=0
360 begin
361 update #TitleBarToolsDefinition set visible='false' where toolType in ('Delete')
362 end
363
364 if @mnuEnableCancelOrder=0
365 begin
366 update #TitleBarToolsDefinition set visible='false' where toolType in ('Cancel')
367 end
368
369 if @mnuManageBuyingOrdersListPermissiontype<>3
370 begin
371 update #TitleBarToolsDefinition set visible='false' where toolType in ('Cancel')
372 end
373 if @mnuEnableCloseOrder=0
374 begin
375 update #TitleBarToolsDefinition set visible='false' where toolType in ('Close')
376 end
377
378 if @mnuManageSalesOrdersListPermissiontype<>3
379 begin
380 update #TitleBarToolsDefinition set visible='false' where toolType in ('Close','Notes')
381 end
382
383 if @mnuManageSalesOrdersListPermissiontype not in(1,2,3)
384 begin
385 update #TitleBarToolsDefinition set visible='false' where toolType in ('Delete Track')
386 update #SectionGridColumns set visible='false' where sectionid='sectionOC' and ColID in ('colRequestforCancellation')
387 end
388 if @EnableRequestForCancellation=0
389 begin
390 update #SectionGridColumns set visible='false' where sectionid='sectionOC' and ColID in ('colRequestforCancellation')
391 end
392 if @mnuPostShipmentCostSheetReport=0
393 begin
394 update #SectionGridColumns set visible='false' where sectionid='sectionOC' and ColID in ('colPostShipmentCostSheet')
395 end
396 if @mnuOrderpendingforClosure=0
397 begin
398 update #SectionGridColumns set visible='false' where sectionid='sectionOC' and ColID in ('colOrderClosureDetails')
399 end
400
401 if (@mnuPOLinkWithOC=1 or @mnuPOLinkWithOCList=1)
402 begin
403 update #SectionGridColumns set visible='true' where sectionid='sectionOC' and ColID in ('colPOs')
404 end
405 else
406 begin
407 update #SectionGridColumns set visible='false' where sectionid='sectionOC' and ColID in ('colPOs')
408 end
409
410 IF @FromPage = 'WFXOCList' AND @EnableRequestforBudgetonOC=1
411 BEGIN
412 UPDATE #SectionGridColumns set visible='true' where sectionid='sectionOC' and ColID='colRequestforBudget'
413 UPDATE #TitleBarToolsDefinition set visible='true' where toolType='Save'
414
415 IF @mnuRequestForBudget=0
416 BEGIN
417 UPDATE #TitleBarToolsDefinition set visible='false' where toolType='Save'
418 DELETE FROM #SectionGridColumnItem
419 WHERE SectionID='sectionOC' AND GridItemType='EditItem' AND ColID='colRequestforBudget'
420 END
421 END
422 IF @FromPage = 'WFXOCList' and @EnableFactoryAllocationInSummaryOC = '1'
423 BEGIN
424 UPDATE #TitleBarToolsDefinition set visible='true' where toolType='Update Factory'
425 update #SectionGridColumns set visible='true' where sectionid='sectionOC' and ColID in ('ColAllocationStatus')
426 END
427 END
428 ELSE
429 BEGIN
430 DELETE fROM #Sections WHERE SectionID IN('sectionOC','titlebarOC')
431 END
432 --Start<IssueID:106172>
433 IF (@CalledFor = 'WFXBuyerBlockBooking')
434 BEGIN
435 UPDATE #TitleBarToolsDefinition set visible='true' where toolType='Ok'
436 UPDATE #SectionGridColumns set visible='true' where sectionid='sectionOC' and ColID ='ColCheckBox'
437 UPDATE #SectionGridColumns set visible='true' where sectionid='sectionOC' and ColID ='ColCurrency'
438 UPDATE #SectionGridColumns set Width='325px' where sectionid='sectionOC' and ColID ='colBuyerStyleRefNum'
439 Delete #TitleBarToolsDefinition where toolType not in ('Ok','Cancel')
440 Delete #SectionGridColumns where sectionid = 'sectionOC'
441 and ColID Not In ('ColCheckBox','colBuyerName','colBuyerStyleRefNum','colProformaInvoiceNumWithOrderRefNum','colTargetDate','colTotalQty','ColCurrency','ColSeason')
442 END
443 /*Start<IssueID:112364>*/
444 IF(@CalledFor = 'WFXStyleReconciliationList')
445 BEGIN
446 /*Start<IssueID:140066>*/
447 IF ISNULL(@Action,'')='View'
448 BEGIN
449 Delete #SectionGridColumnItem where GridItemType='EditItem'
450 Delete #SectionAttributes where AttributeType='Function'
451 Update #SectionItems SET Value=ValueText where ItemType='Select'
452 Update #SectionItems SET ItemSubType='',Mandatory='false'
453 Update #SectionItems SET ItemType='Label' where ItemType in ('Select','TextBox','DatePicker','TextArea')
454 UPDATE #TitleBarToolsDefinition Set Visible ='true' Where SectionID = 'titlebarOCASNDelayOrShort'
455 And ToolType In ('Revise','Exit')
456 UPDATE #SectionItems Set Visible ='false' Where SectionID = 'sectionOCASNDelayOrShortFilter'
457 and ItemID Not In ('lblStyleCodeCaption','lblStyleCode','lblStyleNameCaption','lblStyleName','lblBuyerStyleRef','lblBuyerStyleRefCaption')
458 UPDATE #SectionItems Set Visible ='true' Where SectionID = 'sectionOCASNDelayOrShortFilter'
459 and ItemID In ('lblStyleCodeCaption','lblStyleCode','lblStyleNameCaption','lblStyleName','lblBuyerStyleRef','lblBuyerStyleRefCaption')
460
461 END
462 ELSE
463 BEGIN
464
465 UPDATE #SectionItems Set Visible ='false' Where SectionID = 'sectionOCASNDelayOrShortFilter'
466 and ItemID Not In ('lblStyleCodeCaption','lblStyleCode','lblStyleNameCaption','lblStyleName','lblBuyerStyleRef','lblBuyerStyleRefCaption')
467 UPDATE #SectionItems Set Visible ='true' Where SectionID = 'sectionOCASNDelayOrShortFilter'
468 and ItemID In ('lblStyleCodeCaption','lblStyleCode','lblStyleNameCaption','lblStyleName','lblBuyerStyleRef','lblBuyerStyleRefCaption')
469
470 UPDATE #TitleBarToolsDefinition Set Visible ='true' Where SectionID <> 'titlebarOCASNDelayOrShort'
471
472 UPDATE #TitleBarDefinition set SectionTitle = 'Style Reconciliation' Where TitleBarID = 'titlebarOCASNDelayOrShort'
473 and SectionID = 'titlebarOCASNDelayOrShort'
474 UPDATE #TitleBarDefinition set SectionTitle = 'Reason for Shipment Delay/Short Shipment' Where TitleBarID = 'titlebarOCASNDelayOrShort'
475 and SectionID = 'sectionOCASNDelayOrShort'
476 UPDATE #SectionGridColumns Set Visible ='false' Where SectionID In ('sectionOCASNDelayOrShort')
477 and ColID In ('colShipmentNo','colStyle','colBuyerOrderRef','colDivisionManager')
478
479 UPDATE #TitleBarToolsDefinition SET Visible = 'true' Where SectionID = 'titlebarOCASNDelayOrShort' and TitleBarID = 'titlebarOCASNDelayOrShort'
480 and ToolType IN ('Confirm','Exit')
481 END
482 /*End<IssueID:140066>*/
483
484 END
485 ELSE
486 BEGIN
487 UPDATE #TitleBarToolsDefinition Set Visible = 'true' Where SectionID='titlebarOCASNDelayOrShort'
488 END
489
490 /*End<IssueID:112364>*/
491 EXEC xspCompanyWiseJSONGetData @companyCode =@companyCode,@memberCompanyCode =@memberCompanyCode,@pageName =@pageName,
492 @userName =@userName,@languageCode =@languageCode,@action= 'GetPageJSON',@errorMsg=@errorMsg OUT ,
493 @JSONDefSP = @JSONDefSP, @JSONKey = @JSONKey
494 --End<IssueID:106172>
495 END TRY
496 BEGIN CATCH
497 SET @errorMsg=ERROR_MESSAGE();
498 END CATCH
499
500END