Project

General

Profile

Download (3.66 KB)

Bug #4163 ยป PDSCMBSSALESDOCSTATUS_20260209.sql

Tri Rizqiaty, 02/09/2026 04:39 PM

 
1 
??ALTER PROCEDURE [dbo].[PDSCMBSSALESDOCSTATUS]
2
3 
(
4
5 
	@DocType VARCHAR(20)
6
7 
	,@MenuID VARCHAR(250)
8
9 
)
10
11 
AS
12
13
14
15 
--DECLARE @DocType VARCHAR(20) = ''
16
17 
--DECLARE @MenuID VARCHAR(250) = 'SALESORDERREQ'
18
19
20
21 
IF(@MenuID = 'SALESINQDRAFT')
22
23 
BEGIN
24
25 
	SELECT *
26
27 
	FROM dbo.PCMBSSALESDOCSTATUS
28
29 
	WHERE DocStatus = '1' AND DocType = 'SINQ'
30
31 
END
32
33 
ELSE IF(@MenuID = 'SALESINQ')
34
35 
BEGIN
36
37 
	SELECT *
38
39 
	FROM dbo.PCMBSSALESDOCSTATUS
40
41 
	WHERE DocType = 'SINQ'
42
43 
END
44
45 
ELSE IF(@MenuID = 'SALESORDERDRAFT')
46
47 
BEGIN
48
49 
	SELECT *
50
51 
	FROM dbo.PCMBSSALESDOCSTATUS
52
53 
	WHERE DocStatus IN ('4') AND DocType = 'SORD'--DocStatus IN ('7','9') AND DocType = 'SORD'
54
55 
END
56
57 
ELSE IF(@MenuID = 'SALESORDERREQ')
58
59 
BEGIN
60
61 
	SELECT *
62
63 
	FROM dbo.PCMBSSALESDOCSTATUS
64
65 
	WHERE DocStatus IN ('4','1','5') AND DocType = 'SORD'
66
67 
END
68
69 
ELSE IF(@MenuID = 'SALESORDERAPR')
70
71 
BEGIN
72
73 
	SELECT *
74
75 
	FROM dbo.PCMBSSALESDOCSTATUS
76
77 
	WHERE DocStatus IN ('1','3','5') AND DocType = 'SORD'
78
79 
END
80
81 
ELSE IF(@MenuID = 'SALESORDER')
82
83 
BEGIN
84
85 
	SELECT *
86
87 
	FROM dbo.PCMBSSALESDOCSTATUS
88
89 
	WHERE DocType = 'SORD'
90
91 
END
92
93 
ELSE IF(@MenuID = 'SALESQUOTADRAFT')
94
95 
BEGIN
96
97 
	SELECT *
98
99 
	FROM dbo.PCMBSSALESDOCSTATUS
100
101 
	WHERE DocStatus IN ('1') AND DocType = 'SQUO'
102
103 
END
104
105 
ELSE IF(@MenuID = 'SALESQUOTAREQ')
106
107 
BEGIN
108
109 
	SELECT *
110
111 
	FROM dbo.PCMBSSALESDOCSTATUS
112
113 
	WHERE DocStatus IN ('4','1','5') AND DocType = 'SQUO'
114
115 
END
116
117 
ELSE IF(@MenuID = 'SALESQUOTAAPR')
118
119 
BEGIN
120
121 
	SELECT *
122
123 
	FROM dbo.PCMBSSALESDOCSTATUS
124
125 
	WHERE DocStatus IN ('1','3','5') AND DocType = 'SQUO'
126
127 
END
128
129 
ELSE IF(@MenuID = 'SALESQUOTA')
130
131 
BEGIN
132
133 
	SELECT *
134
135 
	FROM dbo.PCMBSSALESDOCSTATUS
136
137 
	WHERE DocType = 'SQUO'
138
139 
END
140
141 
ELSE IF(@MenuID = 'SALESRETURN')
142
143 
BEGIN
144
145 
	SELECT *
146
147 
	FROM dbo.PCMBSSALESDOCSTATUS
148
149 
	WHERE DocType = 'SRTN'
150
151 
END
152
153 
ELSE IF(@MenuID = 'PREORDER')
154
155 
BEGIN
156
157 
	SELECT *
158
159 
	FROM dbo.PCMBSSALESDOCSTATUS
160
161 
	WHERE DocType = 'PREOD'
162
163 
END
164
165 
ELSE
166
167 
BEGIN
168
169 
	SELECT DISTINCT *
170
171 
	FROM dbo.PCMBSSALESDOCSTATUS
172
173 
END
    (1-1/1)