1 | ABSVMS1 ;OAKLAND/DPC-VSS MIGRATION;7/31/2002
|
---|
2 | ;;4.0;VOLUNTARY TIMEKEEPING;**31,33**;Jul 1994
|
---|
3 | ;
|
---|
4 | SENDPROC(ABSVMTO,ABSSDA) ;
|
---|
5 | ;Driver for sending data to SQL database.
|
---|
6 | D CLEANXTP^ABSVMUT1
|
---|
7 | D SETUPXTP^ABSVMUT1
|
---|
8 | D LDCDS^ABSVMUT1
|
---|
9 | D SERVSP(.ABSVMTO,.ABSSDA)
|
---|
10 | D ORGSP(.ABSVMTO,.ABSSDA)
|
---|
11 | D VOLSP(.ABSVMTO,.ABSSDA)
|
---|
12 | D OHRSSP(.ABSVMTO,.ABSSDA)
|
---|
13 | D RHRSSP(.ABSVMTO,.ABSSDA)
|
---|
14 | D CLEANXTP^ABSVMUT1
|
---|
15 | Q
|
---|
16 | ;
|
---|
17 | SERVSP(ABSVMWHO,ABSSDA) ;
|
---|
18 | ;Process for sending Services. Includes Validation.
|
---|
19 | N FL,EXPORT,TOSEND,TXTFILE
|
---|
20 | N ABSSRES
|
---|
21 | ;
|
---|
22 | W !,"Validating Services"
|
---|
23 | D SRVVAL^ABSVMRV1("S",.ABSSRES)
|
---|
24 | W !,"Errors found in Service Codes: "_ABSSRES("ERRCNT")
|
---|
25 | S ABSSDA(ABSSRES("DA"))=""
|
---|
26 | ;
|
---|
27 | S FL=503332
|
---|
28 | S EXPORT="ABSVM SERVICE CODES EXPORT"
|
---|
29 | S TOSEND="ABSVM SERVICES TOSEND"
|
---|
30 | S TXTFILE="VtkServices"
|
---|
31 | W !,"Sending Services.."
|
---|
32 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
33 | W !
|
---|
34 | Q
|
---|
35 | ;
|
---|
36 | ORGSP(ABSVMWHO,ABSSDA) ;
|
---|
37 | ;Send Process for Organizations.
|
---|
38 | N FL,EXPORT,TOSEND,TXTFILE
|
---|
39 | N ABSSRES
|
---|
40 | W !,"Validating Organizations"
|
---|
41 | D ORGVAL^ABSVMRV1("S",.ABSSRES)
|
---|
42 | W !,"Errors found in Organization Codes: "_ABSSRES("ERRCNT")
|
---|
43 | S ABSSDA(ABSSRES("DA"))=""
|
---|
44 | ;
|
---|
45 | W !,"Sending Organizations.."
|
---|
46 | S FL=503334
|
---|
47 | S EXPORT="ABSVM ORGANIZATION EXPORT"
|
---|
48 | S TOSEND="ABSVM ORGANIZATIONS TOSEND"
|
---|
49 | S TXTFILE="VtkOrganizations"
|
---|
50 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
51 | W !
|
---|
52 | Q
|
---|
53 | ;
|
---|
54 | VOLSP(ABSVMWHO,ABSSDA) ;
|
---|
55 | ;Send Process for Volunteers
|
---|
56 | N FL,EXPORT,TOSEND,TXTFILE
|
---|
57 | N ABSSRES,EXSITES
|
---|
58 | D EXSITES^ABSVMUT1
|
---|
59 | W !,"Building List of Volunteers with Hours"
|
---|
60 | D BLDVOLLT^ABSVMUT1()
|
---|
61 | W !,"Validating Volunteers"
|
---|
62 | D VALVOL^ABSVMVV1("S",.ABSSRES)
|
---|
63 | W !,"Errors found in Volunteer data: "_ABSSRES("ERRCNT")
|
---|
64 | S ABSSDA(ABSSRES("DA"))=""
|
---|
65 | ;
|
---|
66 | S FL=503330
|
---|
67 | ; Volunteer Master
|
---|
68 | S EXPORT="ABSVM VOL MASTER EXPORT"
|
---|
69 | S TOSEND="ABSVM VOLUNTEER TOSEND"
|
---|
70 | S TXTFILE="VtkVolunteers"
|
---|
71 | W !,"Sending Volunteer Master Information.."
|
---|
72 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
73 | ;CONTACTS
|
---|
74 | S EXPORT="ABSVM VOL CONTACT EXPORT"
|
---|
75 | S TOSEND="ABSVM VOLUNTEER TOSEND"
|
---|
76 | S TXTFILE="VtkVolContacts"
|
---|
77 | W !,"Sending Volunteer Contact Information.."
|
---|
78 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
79 | ;COMBINATION CODES
|
---|
80 | N COMBDIS
|
---|
81 | S EXPORT="ABSVM VOL COMBINATIONS EXPORT"
|
---|
82 | S TOSEND=""
|
---|
83 | S COMBDIS(0)="I $D(^XTMP(""ABSVMVOLCB"",""IEN"",D0))"
|
---|
84 | S TXTFILE="VtkVolCombinations"
|
---|
85 | W !,"Sending Combination code Information.."
|
---|
86 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,,.COMBDIS)
|
---|
87 | ;PROFILES
|
---|
88 | N PROFDIS
|
---|
89 | S EXPORT="ABSVM PROFILES EXPORT"
|
---|
90 | S TOSEND=""
|
---|
91 | S TXTFILE="VtkVolProfiles"
|
---|
92 | S PROFDIS(0)="I $D(^XTMP(""ABSVMVOLP"",""IEN"",D0))"
|
---|
93 | W !,"Sending Volunteer Profile Information.."
|
---|
94 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,,.PROFDIS)
|
---|
95 | ;PARKING STICKERS
|
---|
96 | N PARKDIS
|
---|
97 | S EXPORT="ABSVM PARKING EXPORT"
|
---|
98 | S TOSEND=""
|
---|
99 | S TXTFILE="VtkVolParking"
|
---|
100 | S PARKDIS(0)="I $D(^XTMP(""ABSVMVOLPK"",""IEN"",D0))"
|
---|
101 | W !,"Sending Parking Sticker Information.."
|
---|
102 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,,.PARKDIS)
|
---|
103 | W !
|
---|
104 | Q
|
---|
105 | ;
|
---|
106 | OHRSSP(ABSVMWHO,ABSSDA) ;
|
---|
107 | ;Occasional Hours Processing.
|
---|
108 | N FL,EXPORT,TOSEND,TXTFILE
|
---|
109 | N ABSSRES,EXSITES
|
---|
110 | D EXSITES^ABSVMUT1
|
---|
111 | W !,"Validating Occasional Hours"
|
---|
112 | D OHRSVAL^ABSVMHV1("S",.ABSSRES)
|
---|
113 | W !,"Errors found in Occasional Hours: "_ABSSRES("ERRCNT")
|
---|
114 | S ABSSDA(ABSSRES("DA"))=""
|
---|
115 | ;
|
---|
116 | S FL=503336
|
---|
117 | S EXPORT="ABSVM OCCASIONAL EXPORT"
|
---|
118 | S TOSEND="ABSVM OCCASIONAL HOURS TOSEND"
|
---|
119 | S TXTFILE="VtkOccHours"
|
---|
120 | W !,"Sending Occasional Hours.."
|
---|
121 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
122 | W !
|
---|
123 | Q
|
---|
124 | ;
|
---|
125 | RHRSSP(ABSVMWHO,ABSSDA) ;
|
---|
126 | ;Regular hours processing.
|
---|
127 | N FL,EXPORT,TOSEND,TXTFILE
|
---|
128 | N ABSSRES,EXSITES
|
---|
129 | D EXSITES^ABSVMUT1
|
---|
130 | W !,"Validating Regular Hours"
|
---|
131 | D RHRSVAL^ABSVMHV1("S",.ABSSRES)
|
---|
132 | W !,"Errors found in Regular Hours: "_ABSSRES("ERRCNT")
|
---|
133 | S ABSSDA(ABSSRES("DA"))=""
|
---|
134 | ;
|
---|
135 | S FL=503331
|
---|
136 | S EXPORT="ABSVM REGULAR HOURS EXPORT"
|
---|
137 | W !,"Sending Regular Hours.."
|
---|
138 | ;97
|
---|
139 | S TOSEND="ABSVM REG HOURS 97Q1 TOSEND"
|
---|
140 | S TXTFILE="VtkRegHours97Q1"
|
---|
141 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
142 | ;97Q2
|
---|
143 | S TOSEND="ABSVM REG HOURS 97Q2 TOSEND"
|
---|
144 | S TXTFILE="VtkRegHours97Q2"
|
---|
145 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
146 | ;97Q3
|
---|
147 | S TOSEND="ABSVM REG HOURS 97Q3 TOSEND"
|
---|
148 | S TXTFILE="VtkRegHours97Q3"
|
---|
149 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
150 | ;97Q4
|
---|
151 | S TOSEND="ABSVM REG HOURS 97Q4 TOSEND"
|
---|
152 | S TXTFILE="VtkRegHours97Q4"
|
---|
153 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
154 | ;98
|
---|
155 | S TOSEND="ABSVM REG HOURS 98Q1 TOSEND"
|
---|
156 | S TXTFILE="VtkRegHours98Q1"
|
---|
157 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
158 | ;98Q2
|
---|
159 | S TOSEND="ABSVM REG HOURS 98Q2 TOSEND"
|
---|
160 | S TXTFILE="VtkRegHours98Q2"
|
---|
161 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
162 | ;98Q3
|
---|
163 | S TOSEND="ABSVM REG HOURS 98Q3 TOSEND"
|
---|
164 | S TXTFILE="VtkRegHours98Q3"
|
---|
165 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
166 | ;98Q4
|
---|
167 | S TOSEND="ABSVM REG HOURS 98Q4 TOSEND"
|
---|
168 | S TXTFILE="VtkRegHours98Q4"
|
---|
169 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
170 | ;99
|
---|
171 | S TOSEND="ABSVM REG HOURS 99Q1 TOSEND"
|
---|
172 | S TXTFILE="VtkRegHours99Q1"
|
---|
173 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
174 | ;99Q2
|
---|
175 | S TOSEND="ABSVM REG HOURS 99Q2 TOSEND"
|
---|
176 | S TXTFILE="VtkRegHours99Q2"
|
---|
177 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
178 | ;99Q3
|
---|
179 | S TOSEND="ABSVM REG HOURS 99Q3 TOSEND"
|
---|
180 | S TXTFILE="VtkRegHours99Q3"
|
---|
181 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
182 | ;99Q4
|
---|
183 | S TOSEND="ABSVM REG HOURS 99Q4 TOSEND"
|
---|
184 | S TXTFILE="VtkRegHours99Q4"
|
---|
185 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
186 | ;00
|
---|
187 | S TOSEND="ABSVM REG HOURS 00Q1 TOSEND"
|
---|
188 | S TXTFILE="VtkRegHours00Q1"
|
---|
189 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
190 | ;00Q2
|
---|
191 | S TOSEND="ABSVM REG HOURS 00Q2 TOSEND"
|
---|
192 | S TXTFILE="VtkRegHours00Q2"
|
---|
193 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
194 | ;00Q3
|
---|
195 | S TOSEND="ABSVM REG HOURS 00Q3 TOSEND"
|
---|
196 | S TXTFILE="VtkRegHours00Q3"
|
---|
197 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
198 | ;00Q4
|
---|
199 | S TOSEND="ABSVM REG HOURS 00Q4 TOSEND"
|
---|
200 | S TXTFILE="VtkRegHours00Q4"
|
---|
201 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
202 | ;01
|
---|
203 | S TOSEND="ABSVM REG HOURS 01Q1 TOSEND"
|
---|
204 | S TXTFILE="VtkRegHours01Q1"
|
---|
205 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
206 | ;01Q2
|
---|
207 | S TOSEND="ABSVM REG HOURS 01Q2 TOSEND"
|
---|
208 | S TXTFILE="VtkRegHours01Q2"
|
---|
209 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
210 | ;01Q3
|
---|
211 | S TOSEND="ABSVM REG HOURS 01Q3 TOSEND"
|
---|
212 | S TXTFILE="VtkRegHours01Q3"
|
---|
213 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
214 | ;01Q4
|
---|
215 | S TOSEND="ABSVM REG HOURS 01Q4 TOSEND"
|
---|
216 | S TXTFILE="VtkRegHours01Q4"
|
---|
217 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
218 | ;02
|
---|
219 | S TOSEND="ABSVM REG HOURS 02Q1 TOSEND"
|
---|
220 | S TXTFILE="VtkRegHours02Q1"
|
---|
221 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
222 | ;02Q2
|
---|
223 | S TOSEND="ABSVM REG HOURS 02Q2 TOSEND"
|
---|
224 | S TXTFILE="VtkRegHours02Q2"
|
---|
225 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
226 | ;02Q3
|
---|
227 | S TOSEND="ABSVM REG HOURS 02Q3 TOSEND"
|
---|
228 | S TXTFILE="VtkRegHours02Q3"
|
---|
229 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
230 | ;02Q4
|
---|
231 | S TOSEND="ABSVM REG HOURS 02Q4 TOSEND"
|
---|
232 | S TXTFILE="VtkRegHours02Q4"
|
---|
233 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
234 | ;03
|
---|
235 | S TOSEND="ABSVM REG HOURS 03Q1 TOSEND"
|
---|
236 | S TXTFILE="VtkRegHours03Q1"
|
---|
237 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
238 | ;03Q2
|
---|
239 | S TOSEND="ABSVM REG HOURS 03Q2 TOSEND"
|
---|
240 | S TXTFILE="VtkRegHours03Q2"
|
---|
241 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
242 | ;03Q3
|
---|
243 | S TOSEND="ABSVM REG HOURS 03Q3 TOSEND"
|
---|
244 | S TXTFILE="VtkRegHours03Q3"
|
---|
245 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
246 | ;03Q4
|
---|
247 | S TOSEND="ABSVM REG HOURS 03Q4 TOSEND"
|
---|
248 | S TXTFILE="VtkRegHours03Q4"
|
---|
249 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
250 | ;04
|
---|
251 | S TOSEND="ABSVM REG HOURS 04Q1 TOSEND"
|
---|
252 | S TXTFILE="VtkRegHours04Q1"
|
---|
253 | D SEND(TXTFILE,.ABSVMWHO,FL,EXPORT,TOSEND)
|
---|
254 | Q
|
---|
255 | ;
|
---|
256 | SEND(TEXTFILE,ABSVMWHO,FILE,XPTEMP,SORTTEMP,SCREEN) ;
|
---|
257 | ;Sending data.
|
---|
258 | N ABSVHFS,ABSVDEL,XMDUZ,XMY,XMSUB,XMTEXT,XMZ,%ZIS,IOP,Y
|
---|
259 | ;set MailMan variables
|
---|
260 | M XMY=ABSVMWHO
|
---|
261 | S XMDUZ=DUZ,XMSUB="$Station$ "_$P($G(^DIC(4,+$$KSP^XUPARAM("INST"),99)),U)_" :"_TEXTFILE_" -- "_$$FMTE^XLFDT($$NOW^XLFDT)
|
---|
262 | ;set device handler variables
|
---|
263 | S ABSVHFS="ABSVMIGRATION.DAT",IOP="HFS",%ZIS="",%ZIS("HFSMODE")="W",%ZIS("HFSNAME")=ABSVHFS
|
---|
264 | D EXPORT^DDXP(FILE,XPTEMP,0,$G(SORTTEMP),,,.SCREEN,,IOP)
|
---|
265 | ;create message and get message number
|
---|
266 | F D XMZ^XMA2 Q:XMZ>0 H 1
|
---|
267 | ;import from HFS to message global
|
---|
268 | S Y=$$FTG^%ZISH("",ABSVHFS,$NA(^XMB(3.9,XMZ,2,1,0)),4)
|
---|
269 | ;send message
|
---|
270 | S XMDUZ=DUZ
|
---|
271 | D ENT1^XMD
|
---|
272 | ;delete HFS file
|
---|
273 | S ABSVDEL(ABSVHFS)="",Y=$$DEL^%ZISH("",$NA(ABSVDEL))
|
---|
274 | W !," Message #",XMZ
|
---|
275 | Q
|
---|