· 6 years ago · Oct 24, 2019, 07:18 AM
1delete from tblFormViewTemplate where key1='pr_RetMoveBlock'
2INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetMoveBlock',30,'????? ????',0,'Date1','EditTextBox',0,1,'','','d,m','','',2,'','','',12)
3INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetMoveBlock',40,'?.?????',0,'StartTime','EditTextBox',0,1,'','','t,m','','',2,'','','',12)
4INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetMoveBlock',50,'?.????',0,'EndTime','EditTextBox',0,0,'','','t,m','','',2,'','','',12)
5INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetMoveBlock',60,'??? ?????',0,'RoomName','ddl',0,0,'RoomID','RoomName','_','','',0,'','','',0)
6GO
7----------------------------------
8Create PROCEDURE pr_RetMoveBlock
9@ID int=0,
10@Language nvarchar(max)='',
11@ProfileID int=0
12as
13BEGIN
14select * from tblFormViewTemplate ft where ft.Key1='pr_RetMoveBlock'
15and
16EXISTS(select * from tblProfileAuth where ProfileID=@ProfileID and Key1=ft.AllowView or ft.AllowView='' or ISNULL(ft.AllowView, '#')='#')
17order by ordId
18select
19b.id,
20Date1,
21StartTime,
22EndTime,
23room.item as RoomName,
24room.id as RoomID
25from tblBlocks b
26inner join tblDefRooms room on b.RoomID=room.id
27where b.id=@id
28SELECT rm.id as RoomID,rm.Item+' ['+
29isnull(
30Stuff(
31(
32select ','+tp.Item
33FROM tblRoomsToSubject sb
34inner join tbldefparitmiun tp on tp.id=sb.SubjectId
35where sb.RoomId=rm.id and sb.bRecommendation=0
36FOR XML PATH('')
37),1,1,''),'')+']' as RoomName
38from tbldefrooms rm
39order by rm.id
40END
41
42--------------------
43Create procedure pr_MoveBlock
44@id int=0,
45@Date1 datetime='',
46@StartTime nvarchar(10)='',
47@EndTime nvarchar(10)='',
48@RoomID int=0,
49@UserIdCreate int=0
50as
51begin
52if not exists (select * from tblBlocks where id=@id)
53begin
54select 'err: ????? ?? ????'
55return
56end
57/*???? ?????? ????*/
58declare @srcB nvarchar(max)=''
59declare @srcA nvarchar(max)=''
60set @srcB=isnull((SELECT top 1 * FROM tblBlocks where @id>0 and id=@id FOR XML RAW),'')
61/*????? ???? ?? 1*/
62declare @orgroomId int=0
63declare @CyclicCounter smallint=1
64set @orgRoomId=isnull(@RoomID,0)
65declare @warning nvarchar(max)=''
66declare @bHaveSubject bit=0
67declare @SubjectID int = (select SubjectId from tblBlocks where id=@id)
68if cast(@Date1 as date)<cast(getdate() AS DATE)
69begin
70select 'err:??? ?????? ????? ???? ?? ????? ???????'
71return
72end
73if (DATEDIFF(MINUTE, @StartTime ,@EndTime)<30)
74begin
75select 'err:??? ????? ???????? ??? 30 ????'
76return
77end
78re1:
79/*????? ????? ????? ?? ????=????? ????? ?????? */
80if @RoomID>0 and exists (select * from tblBlocks where BlockStatus=2 and RoomID=@RoomID and id<>@id
81and Date1=@Date1 and
82(
83StartTime between @StartTime and @Endtime
84or
85EndTime between @StartTime and @Endtime
86or
87((@StartTime > StartTime and @EndTime < EndTime) or
88(@StartTime < StartTime and @EndTime > EndTime))))
89begin
90select 'err: ???? ????? ????? ??? ???? ????'
91return
92end
93/*??? ??? ??? ?????? ????? ??? ????*/
94if @RoomID=0
95Begin
96/*??? 1 ??? ?????? ????? ????*/
97select top 1 @RoomID=rm.id from tbldefrooms rm
98inner join tblRoomsToSubject rs on rs.roomid=rm.id and rs.bRecommendation=1 and rs.subjectid=@SubjectID
99and not exists
100(
101select * from tblBlocks bl
102where bl.RoomID=rm.id
103and
104BlockStatus=1
105and Roomid=rm.id
106and (Date1=@Date1
107and StartTime between @StartTime and @Endtime
108or EndTime between @StartTime and @Endtime)
109or
110((@StartTime > StartTime and @EndTime < EndTime)
111or
112(@StartTime < StartTime and @EndTime > EndTime))
113)
114/*?????? ??? ??? ????*/
115if @RoomID is null or @RoomID=0
116Begin
117select top 1 @RoomID=rm.id from tbldefrooms rm
118inner join tblRoomsToSubject rs on rs.roomid=rm.id and rs.bRecommendation=0 and rs.subjectid=@SubjectID
119and not exists
120(
121select * from tblBlocks bl
122where bl.RoomID=rm.id
123and
124BlockStatus=1
125and RoomId=rm.id
126and (Date1=@Date1
127and StartTime between @StartTime and @Endtime
128or EndTime between @StartTime and @Endtime)
129or
130((@StartTime > StartTime and @EndTime < EndTime)
131or
132(@StartTime < StartTime and @EndTime > EndTime))
133)
134End
135End
136/*????? ???? ???????? ??? ???*/
137if @RoomID is null or @RoomID=0
138begin
139select 'err: ?? ???? ??? ???? ?????? ??????'
140return
141end
142/*?? ??? ?? ???? ?????? ?????*/
143if (@RoomID > 0)
144begin
145if @bHaveSubject=1 and not exists (select * from tblRoomsToSubject where roomid=@RoomID and subjectid=@SubjectID and bRecommendation=1)
146begin
147set @warning=@warning+'?????: '+convert(nvarchar(10),@Date1,103)+ ' ??? ??: ???? ????? ?? ?????? ??????? ???????? ????? ??????'+ '<br/>'
148end
149end
150
151update tblBlocks
152set
153Date1 = @Date1,
154StartTime = @StartTime,
155EndTime = @EndTime,
156RoomID = @RoomID
157where @id=id
158nxtlvl:
159declare @Retid int
160declare @ActionID int
161set @ActionID=(case when @id>0 then 2 else 1 end)
162if @id>0
163 set @Retid=@id
164else
165set @Retid=SCOPE_IDENTITY()
166set @srcA=isnull((SELECT top 1 * FROM tblBlocks where @Retid>0 and id=@Retid FOR XML RAW),'')
167exec [pr_UpdateBlockLog] @Retid,@ActionID,@UserIdCreate,@srcB,@srcA
168if @warning<>''
169 select 'warning:' + @warning
170else
171 select @Retid
172end
173go
174ALTER procedure pr_UpdateT17
175@ID int=0,
176@ClientId int=0,
177@Date1 datetime,
178@Date2 datetime,
179@Reference nvarchar(max)='',
180@Deductible int=0,
181@Kod1 nvarchar(max)='',
182@KodSapak nvarchar(max)='',
183@Kod2 nvarchar(max)='',
184@KodSapak2 nvarchar(max)='',
185@Kod3 nvarchar(max)='',
186@KodSapak3 nvarchar(max)='',
187@FileScan nvarchar(max)='',
188@EquipmentSum money=0,
189@UserIDCreate int=-1
190as
191begin
192declare @warning nvarchar(max)=''
193declare @DateSur date
194declare @SponserID int=0
195declare @Relatedid int=0
196select @ClientId=sl.Clientid,@DateSur=cast(b.date1 as date),@SponserID=SponserID from tblsurgerieslist sl
197inner join tblblocks b on b.id=sl.blockid
198where sl.id=@ID
199if @SponserID in (50,51)
200begin
201select 'err:??? ?????? ????? ???? ???????? ?????? ????'
202return
203end
204/*????? ??????*/
205if @Date2<@Date1
206begin
207select 'err:???? ???????? ?? ????'
208return
209end
210if (@date1>@DateSur or @date2<@dateSur)
211begin
212set @warning=@warning+ '??? ??: ???? ???????? ????? ?? ???? ?????? ??????'
213end
214/*????? ?????? ???? ???? ??? ????*/
215if (
216select sum
217(
218(case when sl.Kod1<>'' then 1 else 0 end)
219+(case when sl.Kod2<>'' then 1 else 0 end)
220+(case when sl.Kod3<>'' then 1 else 0 end)
221)
222from tblSurgeriesList sl where id=@id)
223<>
224sum(case when @Kod1<>'' then 1 else 0 end)
225+(case when @Kod2<>'' then 1 else 0 end)+(case when @Kod3<>'' then 1 else 0 end)
226begin
227set @warning=@warning+'?? ???? ??:????? ?????? ????? ???? ???? ????? ????? ????? ????????'
228end
229if not exists (select * from tbl17Forms where surid=@id)
230begin
231insert into tbl17Forms (ClientID, BeginDate, EndDate, Reference, kod1,kod2,kod3,Deductible,surid,FileScan,EquipmentSum, UserIdCreate)
232values (@Clientid, @Date1,@Date2, @Reference,@Kod1,@kod2,@kod3,@Deductible,@id,@FileScan,@EquipmentSum, @UserIDCreate)
233set @Relatedid= SCOPE_IDENTITY()
234--????? ???? ??????
235if @FileScan<>''
236begin
237insert into tblClientDocs(ClientID,NameDoc,folderDoc,RelatedID,Memo) values (@ClientId,@FileScan,@ClientId,@Relatedid,'????? ???? 17 ???? ?????')
238end
239end
240else
241begin
242update tbl17forms
243set
244BeginDate = @Date1,
245EndDate = @Date2,
246Reference = @Reference,
247kod1 = @Kod1,
248kod2 = @Kod2,
249kod3 = @Kod3,
250Deductible = @Deductible,
251clientid=@ClientId,
252FileScan=@FileScan,
253EquipmentSum=@EquipmentSum,
254UserIdUpdate=@UserIDCreate
255where surid=@ID
256if @warning<>''
257select 'warning:' + @warning
258else
259select @ID
260end
261end
262go
263delete from tblGridViewTemplate where key1='pr_GetAll_SurgeriesToDay2'
264INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',0,'?????',5,'Client','ItemView',0,0,'Client','ClientName',0,'_','pr_ClientAutocompleteHandler','',0,'')
265INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',10,'??? ?????',5,'Age','ItemView',0,0,'','',0,'_','','',0,'')
266INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',20,'????',5,'DoctorName','ItemView',0,0,'DoctorId','DoctorName',0,'_','','',0,'')
267INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',20,'?.?????',5,'Date1','ItemView',0,0,'DoctorId','DoctorName',0,'_','','',0,'')
268INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',30,'?????',1,'SurgeryName','ItemView',0,0,'SurgeryId','SurgeryName',0,'_','','',0,'')
269INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',40,'???<br>?????',1,'Start','ItemView',0,0,'','',0,'t','','',0,'')
270INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',50,'????? ????? <br>??????',5,'DateR','ItemView',0,0,'','',0,'t','','',0,'')
271INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',60,'????<br>????',5,'SponserName','ItemView',0,0,'Client','ClientName',0,'_','pr_ClientAutocompleteHandler','',0,'')
272INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',70,'??? <br>??????',5,'Duration','ItemView',0,0,'Client','ClientName',0,'_','pr_ClientAutocompleteHandler','',0,'')
273INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',80,'??? <br>?????',5,'DurationReal','ItemView',0,0,'Client','ClientName',0,'_','pr_ClientAutocompleteHandler','',0,'')
274INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',80,'??? <br>????',5,'t17_1','ItemView',0,0,'','',0,'_','','',0,'')
275INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',80,'??? <br>????-2',5,'t17_2','ItemView',0,0,'','',0,'_','','',0,'')
276INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',80,'???<br> ????-3',5,'t17_3','ItemView',0,0,'','',0,'_','','',0,'')
277INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',80,'????<br>????????',5,'t17','ItemView',0,0,'','',0,'_','','',0,'')
278INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',90,'??? Icd',5,'Kod1','ItemView',0,0,'Client','ClientName',0,'_','pr_ClientAutocompleteHandler','',0,'')
279INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',100,'??? Icd 2',5,'Kod2','ItemView',0,0,'Client','ClientName',0,'_','pr_ClientAutocompleteHandler','',0,'')
280INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',110,'??? Icd 3',5,'Kod3','ItemView',0,0,'Client','ClientName',0,'_','pr_ClientAutocompleteHandler','',0,'')
281INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',120,'??? <br>?????',5,'A1','ItemView',0,0,'Client','ClientName',0,'_','pr_ClientAutocompleteHandler','',0,'')
282INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',130,'?????? <br>??????',5,'A2','ItemView',0,0,'Client','ClientName',0,'_','pr_ClientAutocompleteHandler','',0,'')
283INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',140,'??????<br> ?????',5,'A3','ItemView',0,0,'Client','ClientName',0,'_','pr_ClientAutocompleteHandler','',0,'')
284INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',150,'??? ?????<br>??????',5,'A4','ItemView',0,0,'Client','ClientName',0,'_','pr_ClientAutocompleteHandler','',0,'')
285INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',160,'??? ?????<br> ?????',5,'A5','ItemView',0,0,'Client','ClientName',0,'_','pr_ClientAutocompleteHandler','',0,'')
286INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',170,'????',5,'moneyStatus','ItemView',0,0,'','',0,'_','pr_ClientAutocompleteHandler','',0,'')
287INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',180,'??????',5,'Status','ItemView',0,0,'','',0,'_','pr_ClientAutocompleteHandler','',0,'')
288INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',190,'????<br>?????',5,'ZimunCreator','ItemView',0,0,'','',0,'_','pr_ClientAutocompleteHandler','',0,'')
289INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',200,'????<br>????????',5,'ChargeCreator','ItemView',0,0,'','',0,'_','pr_ClientAutocompleteHandler','',0,'')
290INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',210,'????<br>????<br>?????',5,'RecieptCreator','ItemView',0,0,'','',0,'_','pr_ClientAutocompleteHandler','',0,'')
291INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',220,'??????<br>????',5,'BakaraDone','ItemView',0,0,'','',0,'_','pr_ClientAutocompleteHandler','',0,'')
292INSERT INTO [tblGridViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[bTableKey],[ValidatorStatus],[Param3],[ParentField],[InputSize],[Default])VALUES('pr_GetAll_SurgeriesToDay2',220,'???',5,'Room','ItemView',0,0,'','',0,'_','pr_ClientAutocompleteHandler','',0,'')
293GO
294ALTER procedure pr_GetAll_SurgeriesToDay2
295@LocationID Int=0, --??? ???? ??? ??? ?????? ??? ?? ?? ???????
296@Lang nvarchar(100)='',
297@UserId int=0,
298@Profile int=0,
299@Token nvarchar(max)='',
300@uid int=0,
301@docfilter int=0,
302@roomfilter int=0,
303@typefilter int=0,
304@date1 nvarchar(100)='',
305@Date2 nvarchar(100)='',
306@SearchParam nvarchar(100)=''
307as
308BEGIN
309select * from tblGridViewTemplate where Key1='pr_GetAll_SurgeriesToDay2' order by ordId
310select
311tblSurgeriesList.id as RelatedID,
312FORMAT(
313isnull(moneyStatus,0), 'C', 'he-IL') as moneyStatus
314,
315--tblSurgeriesList.clientid as id,
316cast(tblSurgeriesList.ID as nvarchar)+ ':'+ cast(tblSurgeriesList.clientid as nvarchar) as id,
317PMD.KODICD AS KOD1,'' as A1,'' as A2,'' as A3,IshpuzDays as a4,
318PMD2.KODICD AS Kod2, PMD3.KODICD AS Kod3,
319DATEDIFF(DAY,b.date1,GETDATE()) as a5,
320RoomId as RoomName, room.item as RoomId,s.nameview as SponserName,
321convert(nvarchar(10),b.Date1,103) as Date1,
322tblSurgeriesList.Start as [Start],
323Duration,
324'<li>' +pr.paritname + '</li>'
325+(case when tblSurgeriesList.Kod2<>'' then '<li>'+pr2.ParitName else '' end) + '</li>'
326+(case when tblSurgeriesList.Kod3<>'' then '<li>'+pr3.ParitName else '' end) + '</li>'
327as SurgeryName,
328(case when tblSurgeriesList.id=24 then '<i class="fa fa-money" aria-hidden="true"></i>' else '<span class="badge badge-danger">??? ?????</span>' end) as m1,
329(case when tblSurgeriesList.id=170 then '<i class="fas fa-id-card"></i>' else '<span class="badge badge-danger">??</span>' end) as m2,
330(case when tblSurgeriesList.id=11 then '????? ?????' else '?? ????' end) as m3,
331w.NameView as DoctorName, w.id as DoctorId,tblSurgeriesList.Duration as Duration,
332(case when smd.surgerystary<>'' and smd.surgeryend<>'' then DATEDIFF(MINUTE,surgerystary,surgeryend) else '' end) as DurationReal,
333convert(nvarchar(10),DATEADD(dd,IshpuzDays,b.Date1),103) as dateR,
334pr.ParitName as SurgeryName,
335'' as CapitalName,t17_1,t17_2,t17_3,
336ss.Item as Status,
337(case when Reference<>'' AND filescan<>'' then
338'<a target="_blank" href="http://192.168.1.21:444/' +filescan + '">'+Reference+'</a>'
339WHEN
340Reference<>'' AND filescan='' then '<b><font color=red>!'+ Reference + '</font></b>'
341when tblSurgeriesList.SponserID not in (50,51) then '???? ???? ????????' else '' end)
342as t17,
343tblClients2.NameView as ClientName, tblClients2.NameView as Client,
344(CONVERT(int,CONVERT(char(8),getdate(),112))-CONVERT(char(8),cd.BirthDay,112))/10000 as Age,
345'' as ZimunCreator,
346'' as ChargeCreator,
347'' as RecieptCreator,
348case when BakaraDone=0 then '<i class="fa fa-times"></i>' else '<i class="fa fa-check"></i>' end as BakaraDone,
349room.Item as Room
350from tblSurgeriesList
351inner join tblPritim pr on pr.Kod=tblSurgeriesList.kod1
352left join tblPritim pr2 on pr2.Kod=tblSurgeriesList.kod2
353left join tblPritim pr3 on pr3.Kod=tblSurgeriesList.kod3
354inner join tblBlocks b on b.id=tblSurgeriesList.Blockid
355inner join tblClients w on w.id=b.Doctorid
356INNER join tblDefRooms room on B.roomid=room.id
357inner join tblDefSurgeryStatus ss on ss.id=tblSurgeriesList.StatusID
358inner join tblclients tblClients2 on tblSurgeriesList.clientid=tblclients2.id
359inner join tblClientDetails cd on tblclients2.id=cd.mainid
360inner join tblclients s on tblSurgeriesList.sponserid=s.id
361LEFT JOIN tblPritimMoreDetails PMD ON PMD.ParitKod=PR.Kod
362LEFT JOIN tblPritimMoreDetails PMD2 ON PMD2.ParitKod=PR2.Kod
363LEFT JOIN tblPritimMoreDetails PMD3 ON PMD3.ParitKod=PR3.Kod
364left join tblSurgerieMoreDetails smd on smd.surid=tblSurgeriesList.id
365outer apply(
366select 1.17*sum(case when DocNameID in(15) then -1*docsum else DocSum end) as moneyStatus
367from tblHeshDocuments where DocNameID in(1,14,15,7,18) and tblHeshDocuments.ClientID=tblSurgeriesList.clientid
368) as tblMoneyStatus
369outer apply
370(
371select top 1 Reference,FileScan,
372lpd.kodsapak as t17_1,
373lpd2.kodsapak as t17_2,
374lpd3.kodsapak as t17_3
375FROM tbl17Forms t17
376inner join tblSurgeriesList sl on sl.id=t17.surId
377INNER JOIN tblListPrices lp ON lp.ParentID=sl.SponserID
378left join tblPritim p on p.kod=t17.kod1
379left join tblListPriceDetails lpd on lpd.ListID=lp.id and lpd.ParitKod=p.Kod
380left join tblPritim p2 on p2.kod=t17.kod2
381left join tblListPriceDetails lpd2 on lpd.ListID=lp.id and lpd2.ParitKod=p2.Kod
382left join tblPritim p3 on p3.kod=t17.kod3
383left join tblListPriceDetails lpd3 on lpd.ListID=lp.id and lpd3.ParitKod=p3.Kod
384where t17.surid=tblSurgeriesList.id
385) as t17
386where
3871=1
388and (@roomfilter=0 or room.id=@roomfilter)
389and (@docfilter=0 or w.id=@docfilter)
390and (@typefilter=0 or b.SubjectID=@typefilter)
391--and ((@date1<>'' or @date2<>'') or b.date1>=cast(getdate() as date))
392and (@date1='' or b.Date1>=@date1)
393and (@date2='' or b.Date1<=@date2)
394and (@SearchParam='' or ((tblClients2.NameView like '%' + @SearchParam + '%' ) or (tblClients2.idCard like '%' + @SearchParam+ '%')))
395and tblSurgeriesList.StatusID=100
396END
397go
398ALTER TABLE tblSurgeriesList
399add BakaraDone bit not null default(0)
400go
401create procedure pr_MarkBakaraDone
402@surgeryid int
403as
404begin
405update tblSurgeriesList
406set BakaraDone=1
407OUTPUT INSERTED.*
408where id=@surgeryid
409end
410go
411insert into tblEnvDataToEnvironment (Env, EnvKey, Orderid) values ('envSurgerieBakara', 'SurgeryScanAndHesh', 1)
412go
413delete from tblFormViewTemplate where key1='pr_retsurgeries'
414INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',10,'????',400,'BlockName','HTML',0,0,'','','_','','',12,'',NULL,'',0)
415INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',20,'?????',400,'ClientHeader','HTML',0,0,'','','_','','',12,'',NULL,'',0)
416INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',30,'',400,'','HTML',0,0,'<div style="background-color: rgba(239, 239, 239, 0.50);padding:10px"><h3><i class="fas fa-list"></i> ???? ?????</h3>','','_','','',12,'',NULL,'',0)
417INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',31,'????? ?????',400,'KodName1','ddl',0,1,'Kod1','KodName1','m','','',4,'',NULL,'',0)
418INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',32,'????? ????',400,'KodName2','ddl',0,1,'Kod2','KodName2','_','','',4,'',NULL,'',0)
419INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',33,'????? ????',400,'KodName3','ddl',0,0,'Kod3','KodName3','_','','',4,'',NULL,'',0)
420INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',40,'??? ?????',400,'Start','EditTextBox',0,1,'','','t,m','','',2,'',NULL,'',11)
421INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',50,'??? (????)',400,'Duration','EditTextBox',0,0,'','','m,n|1','','',2,'',NULL,'',12)
422INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',60,'',400,'','HTML',0,0,'</div>','','_','','',12,'',NULL,'',0)
423INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',70,'',400,'','HTML',0,0,'<div style="background-color: rgba(239, 239, 239, 0.50);padding:10px"><h3><i class="fas fa-cog"></i> ????</h3>','','_','','',12,'',NULL,'',0)
424GO
425INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',80,'???? ??????',400,'CapitalList','ddlMulti',0,1,'CapitalList','CapitalListName','_','','',6,'',NULL,'',0)
426INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',90,'???? ?????',400,'pritimConsumableList','ddlMulti',0,0,'pritimConsumableList','pritimConsumableListName','_','','',6,'',NULL,'',0)
427INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',100,'??????',400,'pritimimplantsList','ddlMulti',0,0,'pritimimplantsList','pritimimplantsListName','_','','',6,'',NULL,'',0)
428INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',105,'?????',400,'PritimDetails','TextArea',0,0,'','','_','','',12,'',NULL,'',0)
429INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',110,'',400,'','HTML',0,0,'</div>','','_','','',12,'',NULL,'',0)
430INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',120,'',400,'','HTML',0,0,'<div style="background-color: rgba(239, 239, 239, 0.50);padding:10px"><h3><i class="fa fa-hospital-o"></i> ???? ?????</h3>','','_','','',12,'',NULL,'',0)
431INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',130,'??? ?????',400,'Anesthesia','ddl',0,1,'AnesthesiaID','Anesthesia','_','','',2,'',NULL,'',0)
432INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',140,'???? ??? ?????',400,'IshpuzDays','EditTextBox',0,1,'','','n|0','','',1,'',NULL,'',0)
433INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',150,'?????',400,'Insulation','ddl',0,1,'InsulationID','Insulation','_','','',2,'',NULL,'',0)
434INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',160,'??? ???? ????? ?????',400,'IshpuzNeeded','ddl',0,1,'IshpuzNeededID','IshpuzNeeded','_','','',2,'',NULL,'',0)
435INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',170,'??? ???? ????',400,'Trom','ddl',0,0,'TromID','Trom','_','','',2,'',NULL,'',0)
436INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',180,'??? ???? ???? ????',400,'AssistantNeed','ddl',0,1,'AssistantNeedID','AssistantNeed','_','','',2,'',NULL,'',0)
437INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',190,'???? ??????',400,'AssistantNum','EditTextBox',0,1,'','','n|0','','',1,'',NULL,'',0)
438INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',200,'??? ???? ????? ?????',400,'Xray','ddl',0,1,'XrayID','Xray','_','','',2,'',NULL,'',0)
439INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',210,'Frozen',400,'Frozen','ddl',0,1,'FrozenID','Frozen','_','','',2,'',NULL,'',0)
440INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',220,'??? ???? ????????',400,'Patology','ddl',0,1,'PatologyID','Patology','_','','',2,'',NULL,'',0)
441INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',220,'??? ???? ????? ????',400,'ICU','ddl',0,0,'ICUID','ICU','_','','',2,'',NULL,'',0)
442INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',230,'',400,'','HTML',0,0,'</div>','','_','','',12,'',NULL,'',0)
443INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',280,'?????',400,'SurgeryDetails','TextArea',0,1,'','','','','',6,'',NULL,'',0)
444INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',285,'????? ????????',400,'AdminDetails','TextArea',0,0,'','','','','',6,'',NULL,'',0)
445INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',285,'',400,'','HTML',0,0,'<div style="background-color: rgba(239, 239, 239, 0.50);padding:10px"><h3><i class=""fas fa-info-circle"></i> ????</h3>','','_','','',12,'',NULL,'',0)
446INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',310,'??? ???? ???',400,'SabatKeep','ddl',0,0,'SabatKeepID','SabatKeep','_','','',2,'',NULL,'',0)
447INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',320,'',400,'','HTML',0,0,'</div>','','_','','',12,'',NULL,'',0)
448INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',330,'??????',400,'StatusName','ddl',0,0,'StatusID','StatusName','_','','',2,'',NULL,'1',0)
449INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',400,'',400,'','HTML',0,0,'<div style="background-color: rgba(239, 239, 239, 0.50);padding:10px"><h3><i class="fas fa-shekel-sign"></i> ????</h3>','','_','','',12,'',NULL,'',0)
450INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',410,'???? ????',400,'SponserName','ddl',0,1,'SponserID','SponserName','m','','',3,'',NULL,'',0)
451INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',420,'??? ????',400,'Wage','EditTextBox',0,1,'','','n|0','','',2,'InviteSurgeriesShowMoney',NULL,'',0)
452INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',430,'???? ????? (???? ????)',400,'SurgerySum','EditTextBox',0,1,'','','n|0','','',2,'InviteSurgeriesShowMoney',NULL,'',0)
453INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',440,'????? ??? ???? ?? ???',400,'WageBy','ddl',0,0,'WageByID','WageBy','_','','',2,'InviteSurgeriesShowMoney',NULL,'',0)
454INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',450,'????? ???? 1',400,'FileScan1','file',0,1,'','','','','',12,NULL,NULL,'',4)
455INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',460,'????? ???? 2',400,'FileScan2','file',0,1,'','','','','',12,NULL,NULL,'',4)
456INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',470,'????? ???? 3',400,'FileScan3','file',0,0,'','','','','',12,NULL,NULL,'',4)
457INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',475,'',400,'ScanInfo','HTML',0,0,'','','_','','',12,'InviteSurgeriesShowMoney',NULL,'',6)
458INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',480,'',400,'T17Info','HTML',0,0,'','','_','','',12,'InviteSurgeriesShowMoney',NULL,'',6)
459INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_RetSurgeries',490,'',400,'','HTML',0,0,'</div>','','_','','',12,'',NULL,'',0)
460go
461
462
463delete from tblFormViewTemplate where key1='pr_SurgerieMoreDetails'
464INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_SurgerieMoreDetails',100,'',400,'','HTML',0,0,'<div style="background-color: rgba(239, 239, 239, 0.50);padding:10px;margin-bottom:1rem;">','','_','','',12,'',NULL,'',0)
465INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_SurgerieMoreDetails',200,'????',400,'ArrivalTime','EditTextBox',0,1,'','','t','','',6,NULL,NULL,'',0)
466INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_SurgerieMoreDetails',300,'???? ???? ??????',400,'NurseReception','EditTextBox',0,1,'','','t','','',6,NULL,NULL,'',0)
467INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_SurgerieMoreDetails',400,'???? ?????',400,'AnestheticReception','EditTextBox',0,1,'','','t','','',6,NULL,NULL,'',0)
468INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_SurgerieMoreDetails',500,'????? ?????',400,'AnestheticStart','EditTextBox',0,1,'','','t','','',6,NULL,NULL,'',0)
469INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_SurgerieMoreDetails',600,'????? ?????',400,'SurgeryStary','EditTextBox',0,1,'','','t','','',6,NULL,NULL,'',0)
470INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_SurgerieMoreDetails',700,'???? ?????',400,'SurgeryEnd','EditTextBox',0,1,'','','t','','',6,NULL,NULL,'',0)
471INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_SurgerieMoreDetails',800,'??? ?????',400,'AnestheticEnd','EditTextBox',0,1,'','','t','','',6,NULL,NULL,'',0)
472INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_SurgerieMoreDetails',900,'????? ?????????',400,'RecoveryStart','EditTextBox',0,1,'','','t','','',6,NULL,NULL,'',0)
473INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_SurgerieMoreDetails',1000,'????? ??????',400,'departmentStart','EditTextBox',0,1,'','','t','','',6,NULL,NULL,'',0)
474GO
475INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_SurgerieMoreDetails',1100,'????? ?????',400,'ReleaseTime','EditTextBox',0,1,'','','t','','',6,NULL,NULL,'',0)
476INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_SurgerieMoreDetails',1200,'?????',400,'anestheticName','ddl',0,1,'anestheticID','anestheticName','','','',12,'',NULL,'',0)
477INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_SurgerieMoreDetails',1300,'?????',400,'SurgerieDetails','TextArea',0,1,'','','','','',12,NULL,NULL,'',0)
478INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_SurgerieMoreDetails',1400,'',400,'','HTML',0,0,'</div>','','_','','',12,'',NULL,'',0)
479INSERT INTO [tblFormViewTemplate] ([Key1],[ordId],[FieldCap],[SizeCont],[FieldName],[ControlType],[bLock],[bNoBreakCell],[Param1],[Param2],[ValidatorStatus],[Param3],[ParentField],[InputSize],[AllowView],[AllowUpdate],[Default],[InputSize2])VALUES('pr_SurgerieMoreDetails',1500,'??? ????? ??????',200,'NameAvhana','Autocomplete',0,0,'KodAvhana','NameAvhana','_','pr_AvhanaAutocompleteHandler','',0,NULL,NULL,'',12)
480go
481
482alter procedure pr_SurgerieMoreDetails
483@ID INT=0,
484@Language nvarchar(max)='',
485@ProfileID int=0,
486@ClientId int=0,
487@uid int=0
488as
489BEGIN
490select * from tblFormViewTemplate ft
491where ft.Key1='pr_SurgerieMoreDetails' and
492EXISTS(select * from tblProfileAuth where ProfileID=@ProfileID and Key1=ft.AllowView or ft.AllowView='' or ISNULL(ft.AllowView, '#')='#')
493order by ordId
494if not exists (select * from tblSurgerieMoreDetails where surid=@id)
495begin
496 select 0 as id,
497'' as ArrivalTime
498,'' as NurseReception
499,'' as AnestheticReception
500,'' as AnestheticStart
501,'' as SurgeryStary
502,'' as SurgeryEnd
503,'' as AnestheticEnd
504,'' as RecoveryStart
505,'' as departmentStart
506,'' as ReleaseTime
507,'' as SurgerieDetails
508,'' as anestheticName
509,0 as KodAvhana, '' as NameAvhana
510,0 as anestheticID
511
512end
513else
514begin
515select surid as id,
516ArrivalTime
517,NurseReception
518,AnestheticReception
519,AnestheticStart
520,SurgeryStary
521,SurgeryEnd
522,AnestheticEnd
523,RecoveryStart
524,departmentStart
525,ReleaseTime
526,tblSurgerieMoreDetails.SurgerieDetails
527,c.id as anestheticID,c.NameView as anestheticName
528,sl.KodAvhana as KodAvhana, av.Item as NameAvhana
529from tblSurgerieMoreDetails
530left join tblclients c on c.id=tblSurgerieMoreDetails.anestheticID
531inner join tblSurgeriesList sl on sl.id=tblSurgerieMoreDetails.surid
532inner join tblAvhanot av on av.ID=sl.KodAvhana
533where tblSurgerieMoreDetails.surid=@id
534end
535select id as anestheticID,NameView as anestheticName from tblClients where nType2=40 and nType=1
536Return
537End
538go