[613] | 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
|
---|