1 | CCRUTIL ;CCRCCD/SMH - Various Utilites for generating the CCR/CCD;06/15/08
|
---|
2 | ;;0.1;CCRCCD;;Jun 15, 2008;
|
---|
3 | ;Copyright 2008 WorldVistA. Licensed under the terms of the GNU
|
---|
4 | ;General Public License See attached copy of the License.
|
---|
5 | ;
|
---|
6 | ;This program is free software; you can redistribute it and/or modify
|
---|
7 | ;it under the terms of the GNU General Public License as published by
|
---|
8 | ;the Free Software Foundation; either version 2 of the License, or
|
---|
9 | ;(at your option) any later version.
|
---|
10 | ;
|
---|
11 | ;This program is distributed in the hope that it will be useful,
|
---|
12 | ;but WITHOUT ANY WARRANTY; without even the implied warranty of
|
---|
13 | ;MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
---|
14 | ;GNU General Public License for more details.
|
---|
15 | ;
|
---|
16 | ;You should have received a copy of the GNU General Public License along
|
---|
17 | ;with this program; if not, write to the Free Software Foundation, Inc.,
|
---|
18 | ;51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
|
---|
19 | ;
|
---|
20 | W "No Entry at Top!"
|
---|
21 | Q
|
---|
22 | ;
|
---|
23 | FMDTOUTC(DATE,FORMAT) ; Convert Fileman Date to UTC Date Format; PUBLIC; Extrinsic
|
---|
24 | ; FORMAT is Format of Date. Can be either D (Day) or DT (Date and Time)
|
---|
25 | ; If not passed, or passed incorrectly, it's assumed that it is D.
|
---|
26 | ; FM Date format is "YYYMMDD.HHMMSS" HHMMSS may not be supplied.
|
---|
27 | ; UTC date is formatted as follows: YYYY-MM-DDThh:mm:ss_offsetfromUTC
|
---|
28 | ; UTC, Year, Month, Day, Hours, Minutes, Seconds, Time offset (obtained from Mailman Site Parameters)
|
---|
29 | N UTC,Y,M,D,H,MM,S,OFF
|
---|
30 | S Y=1700+$E(DATE,1,3)
|
---|
31 | S M=$E(DATE,4,5)
|
---|
32 | S D=$E(DATE,6,7)
|
---|
33 | S H=$E(DATE,9,10)
|
---|
34 | I $L(H)=1 S H="0"_H
|
---|
35 | S MM=$E(DATE,11,12)
|
---|
36 | I $L(MM)=1 S MM="0"_MM
|
---|
37 | S S=$E(DATE,13,14)
|
---|
38 | I $L(S)=1 S S="0"_S
|
---|
39 | S OFF=$$TZ^XLFDT ; See Kernel Manual for documentation.
|
---|
40 | ; If H, MM and S are empty, it means that the FM date didn't supply the time.
|
---|
41 | ; In this case, set H, MM and S to "00"
|
---|
42 | ; S:('$L(H)&'$L(MM)&'$L(S)) (H,MM,S)="00" ; IF ONLY SOME ARE MISSING?
|
---|
43 | S:'$L(H) H="00"
|
---|
44 | S:'$L(MM) MM="00"
|
---|
45 | S:'$L(S) S="00"
|
---|
46 | S UTC=Y_"-"_M_"-"_D_"T"_H_":"_MM_$S(S="":":00",1:":"_S)_OFF ; Skip's code to fix hanging colon if no seconds
|
---|
47 | I $L($G(FORMAT)),FORMAT="DT" Q UTC ; Date with time.
|
---|
48 | E Q $P(UTC,"T")
|
---|
49 | ;
|
---|
50 | SORTDT(V1,V2,ORDR) ; DATE SORT ARRAY AND RETURN INDEX IN V1 AND COUNT
|
---|
51 | ; AS EXTRINSIC ORDR IS 1 OR -1 FOR FORWARD OR REVERSE
|
---|
52 | ; DATE AND TIME ORDER. DEFAULT IS FORWARD
|
---|
53 | ; V2 IS AN ARRAY OF DATES IN FILEMAN FORMAT
|
---|
54 | ; V1 IS RETURNS INDIRECT INDEXES OF V2 IN REVERSE DATE ORDER
|
---|
55 | ; SO V2(V1(X)) WILL RETURN THE DATES IN DATE/TIME ORDER
|
---|
56 | ; THE COUNT OF THE DATES IS RETURNED AS AN EXTRINSIC
|
---|
57 | ; BOTH V1 AND V2 ARE PASSED BY REFERENCE
|
---|
58 | N VSRT ; TEMP FOR HASHING DATES
|
---|
59 | N ZI,ZJ,ZTMP,ZCNT,ZP1,ZP2
|
---|
60 | S ZCNT=0 ; COUNTING NUMBER OF DATES
|
---|
61 | S ZTMP="" ;
|
---|
62 | F ZI=0:0 D Q:$O(V2(ZTMP))="" ; FOR EACH DATE IN THE ARRAY
|
---|
63 | . S ZCNT=ZCNT+1 ; INCREMENT THE COUNT
|
---|
64 | . S ZTMP=$O(V2(ZTMP)) ; NEXT DATE
|
---|
65 | . I $D(V2(ZTMP)) D ; IF THE DATE EXISTS
|
---|
66 | . . S ZP1=$P(V2(ZTMP),".",1) ; THE DATE PIECE
|
---|
67 | . . S ZP2=$P(V2(ZTMP),".",2) ; THE TIME PIECE
|
---|
68 | . . S VSRT(ZP1,ZP2_"00000"_ZCNT)=ZCNT ; HASH ON DATE AND TIME
|
---|
69 | . . ; S VSRT($P(V2(ZTMP),U,4)_"000000"_ZCNT)=ZCNT ; PULL DATE
|
---|
70 | . I DEBUG W "ZTMP=",ZTMP," "
|
---|
71 | S V1(0)=ZCNT ; ARRAYS ARE THE SAME SIZE
|
---|
72 | ; I DEBUG ZWR V2
|
---|
73 | ; I DEBUG ZWR VSRT
|
---|
74 | N ZD,ZT ; DATA AND TIME ITERATORS
|
---|
75 | N ZDONE ; DONE FLAG
|
---|
76 | S (ZD,ZT)=""
|
---|
77 | S ZDONE=0
|
---|
78 | N UORDR ; ORDER TO USE 1=FORWARD -1=REVERSE
|
---|
79 | S UORDR=ORDR ; DIRECTION TO SORT
|
---|
80 | I ORDR="" S UORDR=1
|
---|
81 | N ZZCNT S ZZCNT=0 ; ANOTHER COUNTER
|
---|
82 | F ZI=0:0 D Q:ZDONE ; VISIT THE ARRAY IN DATE ORDER
|
---|
83 | . S ZD=$O(VSRT(ZD),UORDR) ; NEXT DATE
|
---|
84 | . I ZD="" S ZDONE=1
|
---|
85 | . I 'ZDONE D ; MORE DATES
|
---|
86 | . . S ZT="" ; WANT FIRST TIME FOR THIS DATE
|
---|
87 | . . F ZJ=0:0 D Q:$O(VSRT(ZD,ZT),UORDR)="" ; LOOP THROUGH ALL TIMES
|
---|
88 | . . . S ZT=$O(VSRT(ZD,ZT),UORDR) ; NEXT TIME
|
---|
89 | . . . S ZZCNT=ZZCNT+1 ; INCREMENT COUNTER
|
---|
90 | . . . S V1(ZZCNT)=VSRT(ZD,ZT) ; PULL OUT THE INDEX
|
---|
91 | Q ZCNT
|
---|
92 | ;
|
---|
93 | SORTDT2(V1,V2,ORDR) ; REWRITE TO USE 3 INSTEAD OF 2 LVLS OF INDEX
|
---|
94 | ; AND $Q INSTEAD OF $O
|
---|
95 | ; DATE SORT ARRAY AND RETURN INDEX IN V1 AND COUNT
|
---|
96 | ; AS EXTRINSIC ORDR IS 1 OR -1 FOR FORWARD OR REVERSE
|
---|
97 | ; DATE AND TIME ORDER. DEFAULT IS FORWARD
|
---|
98 | ; V2 IS AN ARRAY OF DATES IN FILEMAN FORMAT
|
---|
99 | ; V1 IS RETURNS INDIRECT INDEXES OF V2 IN REVERSE DATE ORDER
|
---|
100 | ; SO V2(V1(X)) WILL RETURN THE DATES IN DATE/TIME ORDER
|
---|
101 | ; THE COUNT OF THE DATES IS RETURNED AS AN EXTRINSIC
|
---|
102 | ; BOTH V1 AND V2 ARE PASSED BY REFERENCE
|
---|
103 | N VSRT ; TEMP FOR HASHING DATES
|
---|
104 | N ZI,ZJ,ZTMP,ZCNT,ZP1,ZP2
|
---|
105 | S ZCNT=0 ; COUNTING NUMBER OF DATES
|
---|
106 | S ZTMP="" ;
|
---|
107 | F ZI=0:0 D Q:$O(V2(ZTMP))="" ; FOR EACH DATE IN THE ARRAY
|
---|
108 | . S ZCNT=ZCNT+1 ; INCREMENT THE COUNT
|
---|
109 | . S ZTMP=$O(V2(ZTMP)) ; NEXT DATE
|
---|
110 | . I $D(V2(ZTMP)) D ; IF THE DATE EXISTS
|
---|
111 | . . S ZP1=$P(V2(ZTMP),".",1) ; THE DATE PIECE
|
---|
112 | . . S ZP2=$P(V2(ZTMP),".",2) ; THE TIME PIECE
|
---|
113 | . . S VSRT(ZP1,ZP2,ZCNT)=ZCNT ; HASH ON DATE AND TIME
|
---|
114 | . I DEBUG W "ZTMP=",ZTMP," "
|
---|
115 | S V1(0)=ZCNT ; ARRAYS ARE THE SAME SIZE
|
---|
116 | ; I DEBUG ZWR V2
|
---|
117 | ; I DEBUG ZWR VSRT
|
---|
118 | N ZD,ZT ; DATA AND TIME ITERATORS
|
---|
119 | N ZDONE ; DONE FLAG
|
---|
120 | S (ZD,ZT)=""
|
---|
121 | S ZDONE=0
|
---|
122 | N UORDR ; ORDER TO USE 1=FORWARD -1=REVERSE
|
---|
123 | S UORDR=ORDR ; DIRECTION TO SORT
|
---|
124 | I ORDR="" S UORDR=1
|
---|
125 | N ZZCNT S ZZCNT=0 ; ANOTHER COUNTER
|
---|
126 | F ZI=0:0 D Q:ZDONE ; VISIT THE ARRAY IN DATE ORDER
|
---|
127 | . S ZD=$O(VSRT(ZD),UORDR) ; NEXT DATE fix this
|
---|
128 | . I ZD="" S ZDONE=1
|
---|
129 | . I 'ZDONE D ; MORE DATES
|
---|
130 | . . S ZT="" ; WANT FIRST TIME FOR THIS DATE
|
---|
131 | . . F ZJ=0:0 D Q:$O(VSRT(ZD,ZT),UORDR)="" ; LOOP THROUGH ALL TIMES
|
---|
132 | . . . S ZT=$O(VSRT(ZD,ZT),UORDR) ; NEXT TIME
|
---|
133 | . . . S ZZCNT=ZZCNT+1 ; INCREMENT COUNTER
|
---|
134 | . . . S V1(ZZCNT)=VSRT(ZD,ZT) ; PULL OUT THE INDEX
|
---|
135 | Q ZCNT
|
---|
136 | ; |
---|