| 1 | BMXADOS ; IHS/CIHA/GIS - UPDATE THE BMX ADO SCHEMA FILE ;
|
|---|
| 2 | ;;2.1;BMX;;Jul 26, 2009
|
|---|
| 3 | ; ENABLES NAVIGATION TO SUBFILES PRIOR TO UPDATING THE SCHEMA FILE ENTRY
|
|---|
| 4 | ;
|
|---|
| 5 | ;
|
|---|
| 6 | ;
|
|---|
| 7 | UPDATE ; UPDATE THE SCHEMA FILE
|
|---|
| 8 | N DIC,X,Y,%,STOP,FIEN,FNAME,SNAME,SIEN
|
|---|
| 9 | UDIC S DIC("A")="Enter schema name: " ; EP FROM VENPCCTU
|
|---|
| 10 | S DIC(0)="AEQLM",DIC="^BMXADO("
|
|---|
| 11 | D ^DIC I Y=-1 G FIN
|
|---|
| 12 | SCHEMA S SNAME=$P(Y,U,2),SIEN=+Y
|
|---|
| 13 | S FIEN=$$FILE(SIEN) I 'FIEN G FIN
|
|---|
| 14 | I FIEN'=$P($G(^BMXADO(SIEN,0)),U,2) S DIE=DIC,DA=SIEN,DR=".02////^S X=FIEN" D ^DIE
|
|---|
| 15 | F D FLD(FIEN,SIEN) I $G(STOP) Q ; GET FIELD INFO
|
|---|
| 16 | FIN D ^XBFMK
|
|---|
| 17 | Q
|
|---|
| 18 | ;
|
|---|
| 19 | FLD(FIEN,SIEN) ; GET THE FIELD
|
|---|
| 20 | N DIC,X,Y,DIE,DA,DR,FLDIEN,FLDNAME,FLDTYPE,FDEF,TRANS
|
|---|
| 21 | N %,%Y,HDR,DTYPE,LEN,FARR,I,TOT,PAUSE,PFLAG,IFLAG,IMSG,STG,READ
|
|---|
| 22 | D FLIST(.FARR,FIEN,0)
|
|---|
| 23 | S TOT=$O(FARR(9999),-1) I 'TOT S STOP=1 Q
|
|---|
| 24 | W !,"Select a field from this "_$S($D(^DD(FIEN,0,"UP")):"sub-",1:"")_"file: "
|
|---|
| 25 | S I=0 F S I=$O(FARR(I)) Q:'I S PAUSE=$$PAUSE(I) Q:PAUSE'="" W I,?3,FARR(I)
|
|---|
| 26 | I $G(PAUSE)=U S STOP=1 Q
|
|---|
| 27 | I $G(PAUSE) S Y=PAUSE G FLD1
|
|---|
| 28 | S DIR(0)="NO^1:"_TOT_":",DIR("A")="Select a field from the list" K DA D ^DIR K DIR
|
|---|
| 29 | I 'Y S STOP=1 Q
|
|---|
| 30 | FLD1 S %=FARR(+Y)
|
|---|
| 31 | S FLDIEN=+$P(%," [",2),FLDNAME=$P(%," [")
|
|---|
| 32 | I $$FDEL(SIEN,FLDIEN) Q ; FIELD DELETED
|
|---|
| 33 | S X=$$FDEF(FIEN,FLDIEN) I '$L(X) W " ??" Q
|
|---|
| 34 | S DTYPE=$E(X),LEN=+$E(X,2,6)
|
|---|
| 35 | S DIR(0)="F^1:30",DIR("A")="Column header",DIR("B")=FLDNAME D ^DIR K DIR
|
|---|
| 36 | S HDR=Y,TRANS=0
|
|---|
| 37 | S %=$P($G(^DD(FIEN,FLDIEN,0)),U,2) ; CHECK FM DD TO SEE IF FIELD IS REQUIRED
|
|---|
| 38 | I %["R" W !,"FileMan requires a non-null value for this field" S %=2
|
|---|
| 39 | E W !,"Is null allowed" S %=$S(FLDIEN=.01:2,1:1) D YN^DICN I %Y?1."^" Q
|
|---|
| 40 | I %=2 S TRANS=1 ; NON NULL VALUE REQUIRED TO COMPLETE THE TRANSACTION OR THERE WILL BE ROLLBACK
|
|---|
| 41 | I $G(PFLAG) D ; IF POINTER, ASK IF USER WANTS TO AUTOMATICALLY INSERT THE LOOKUP VALUE FIELD IN THE SCHEMA
|
|---|
| 42 | . W !,"This field is a pointer value (IEN)."
|
|---|
| 43 | . W !,"Want to automatically insert the lookup value in the schema"
|
|---|
| 44 | . S %=2 D YN^DICN W ! I %=1 S PFLAG=2
|
|---|
| 45 | . Q
|
|---|
| 46 | IFLG I $G(IFLAG) D ; NON-POINTER .01 FIELD. ASK IF USER WANTS TO REFERENCE IDENTIFIER EP
|
|---|
| 47 | . W !,"Want to display identifiers with this field"
|
|---|
| 48 | . S %=2 D YN^DICN W ! I %'=1 Q
|
|---|
| 49 | . S IMSG="Respond with a valid entry point in the format 'TAG^ROUTINE'."
|
|---|
| 50 | . W !,"Entry Point to generate Identifiers: " R Y:$G(DTIME,60) E Q
|
|---|
| 51 | . I Y?1."^" Q
|
|---|
| 52 | . I Y?1."?" W !,IMSG S IFLAG(0)="!" Q
|
|---|
| 53 | . I Y'?1U.7UN1"^"1U.7UN S IFLAG(0)="!" W " ??"
|
|---|
| 54 | . I $L(Y)>2 S IFLAG(0)=Y,IFLAG=2
|
|---|
| 55 | . Q
|
|---|
| 56 | I $G(IFLAG(0))="!" W !,IMSG K IPFLAG(0),IMSG W !!! G IFLG
|
|---|
| 57 | S DA(1)=SIEN,DIC="^BMXADO("_DA(1)_",1,"
|
|---|
| 58 | S DIC("P")=90093.991,DIC(0)="L",X=FLDIEN
|
|---|
| 59 | I '$D(^BMXADO(SIEN,1,0)) S ^BMXADO(SIEN,1,0)="^90093.991^^"
|
|---|
| 60 | D ^DIC I Y=-1 Q
|
|---|
| 61 | S READ=($P($G(^DD(FIEN,FLDIEN,0)),U,2)["C") ; COMPUTED FIELDS ARE READ ONLY!
|
|---|
| 62 | S DIE=DIC,DA=+Y
|
|---|
| 63 | S DR=".02///^S X=DTYPE;.03///^S X=LEN;.04///^S X=HDR;.05///^S X=READ;.06///0;.07///^S X=('TRANS)"
|
|---|
| 64 | D ^DIE
|
|---|
| 65 | I $G(IFLAG)=2 D ID
|
|---|
| 66 | I $G(PFLAG)'=2 Q
|
|---|
| 67 | LKUP ; AUTOMATICALLY ADD A LOOKUP FIELD TO THE SCHEMA
|
|---|
| 68 | S X=FLDIEN_"IEN"
|
|---|
| 69 | D ^DIC I Y=-1 Q
|
|---|
| 70 | W !,"The LOOKUP field '"_X_"' has been added to the schema",!
|
|---|
| 71 | S HDR=HDR_"_IEN",DTYPE="I",LEN="00009"
|
|---|
| 72 | S DIE=DIC,DA=+Y
|
|---|
| 73 | S DR=".02///^S X=DTYPE;.03///^S X=LEN;.04///^S X=HDR;.05///^S X=READ;.06///0;.07///^S X=('TRANS)"
|
|---|
| 74 | D ^DIE
|
|---|
| 75 | Q
|
|---|
| 76 | ;
|
|---|
| 77 | ID ; AUTOMATICALLY ADD AN IDENTIFIER REFERENCE
|
|---|
| 78 | N X,Y,DIE,DR,DA,REF
|
|---|
| 79 | S X=".01ID",DA(1)=SIEN
|
|---|
| 80 | S REF=IFLAG(0) I '$L(REF) Q
|
|---|
| 81 | D ^DIC I Y=-1 Q
|
|---|
| 82 | W !,"The identifier field '"_X_"' has been added to the schema",!
|
|---|
| 83 | S HDR=HDR_"_ID",DTYPE="T",LEN="00017"
|
|---|
| 84 | S DIE=DIC,DA=+Y
|
|---|
| 85 | S DR=".02///^S X=DTYPE;.03///^S X=LEN;.04///^S X=HDR;.05///^S X=READ;.06///0;.07///^S X=('TRANS);1///^S X=REF"
|
|---|
| 86 | D ^DIE
|
|---|
| 87 | Q
|
|---|
| 88 | ;
|
|---|
| 89 | FDEL(SIEN,FIELD) ; DELETE AN EXISTING ENTRY FROM THE 'FIELD' MULTIPLE. RETURN '1' IF THE RECORD WAS DELETED
|
|---|
| 90 | N FIEN,DA,DIK
|
|---|
| 91 | S FIEN=$O(^BMXADO(SIEN,1,"B",FIELD,0)) I 'FIEN Q 0 ; THIS IS A NEW ENTRY
|
|---|
| 92 | W !,"This field already is attached to the schema. Want to delete it"
|
|---|
| 93 | S %=2 D YN^DICN
|
|---|
| 94 | I %'=1 Q 0
|
|---|
| 95 | S DA(1)=SIEN,DIK="^BMXADO("_DA(1)_",1,",DA=FIEN
|
|---|
| 96 | D ^DIK
|
|---|
| 97 | S FIEN=$O(^BMXADO(SIEN,1,"B",(FIELD_"IEN"),0))
|
|---|
| 98 | I FIEN S DA=FIEN D ^DIK ; DELETE LOOKUP VALUE FIELD AS WELL
|
|---|
| 99 | W " Done!",!
|
|---|
| 100 | Q 1
|
|---|
| 101 | ;
|
|---|
| 102 | FDEF(FILE,FIELD) ;EP - GIVEN A FILEMAN FILE AND FIELD, RETURN THE DATA DEFINITION IN ADO FORMAT
|
|---|
| 103 | N %,X,Y,Z,STG,I,DTYPE,FNAME,LEN,DNAME
|
|---|
| 104 | I '$D(^DD(+$G(FILE),+$G(FIELD),0)) Q ""
|
|---|
| 105 | S STG=$G(^DD(FILE,FIELD,0)) I '$L(STG) Q "" ; GET DATA DEF STRING
|
|---|
| 106 | DTYPE S %="DNSFWCPVM",X=$P(STG,U,2),DTYPE="" ; GET DATA TYPE
|
|---|
| 107 | F I=1:1:$L(%) S Y=$E(%,I) I X[Y S DTYPE=Y Q
|
|---|
| 108 | I DTYPE="" Q ""
|
|---|
| 109 | FNAME S DNAME=$P(STG,U) I '$L(DNAME) Q "" ; FIELD NAME
|
|---|
| 110 | DDA ; ADO FORMAT
|
|---|
| 111 | I DTYPE="D" D Q "D"_LEN_DNAME
|
|---|
| 112 | . S LEN="00021"
|
|---|
| 113 | . I STG["S %DT=" S %=$P(STG,"S %DT=",2),%=$P(%,$C(34))
|
|---|
| 114 | . I $G(FLDIEN)=.01 S IFLAG=1
|
|---|
| 115 | . I %["S" S LEN="00019" Q
|
|---|
| 116 | . I %["T" S LEN="00018" Q
|
|---|
| 117 | . Q
|
|---|
| 118 | I DTYPE="N",STG["1N.N" D Q:'LEN "" Q "I"_LEN_DNAME ; INTEGER
|
|---|
| 119 | . S %=+$P(STG,"K:+X'=X!(X>",2)
|
|---|
| 120 | . S Y=$L(%)
|
|---|
| 121 | . S LEN=$E("00000",1,5-$L(Y))_Y
|
|---|
| 122 | . Q
|
|---|
| 123 | I DTYPE="N" D Q:'LEN "" Q "N"_LEN_DNAME ; NUMBER (COULD HAVE A DECIMAL VALUE)
|
|---|
| 124 | . S %=+$P(STG,"!(X?.E1"".""",2)
|
|---|
| 125 | . S X=+$P(STG,"K:+X'=X!(X>",2)
|
|---|
| 126 | . S Y=%+($L(+X))
|
|---|
| 127 | . S LEN=$E("00000",1,5-$L(Y))_Y
|
|---|
| 128 | . Q
|
|---|
| 129 | I DTYPE="F" D Q:'LEN "" Q "T"_LEN_DNAME
|
|---|
| 130 | . S Y=+$P(STG,"K:$L(X)>",2)
|
|---|
| 131 | . S LEN=$E("00000",1,5-$L(Y))_Y
|
|---|
| 132 | . I 'LEN S LEN="00030"
|
|---|
| 133 | . I $G(FLDIEN)=.01 S IFLAG=1
|
|---|
| 134 | . Q
|
|---|
| 135 | I DTYPE="S" D Q:'LEN "" Q "T"_LEN_DNAME
|
|---|
| 136 | . S X=$P(STG,U,3),Y=0
|
|---|
| 137 | . F I=1:1:$L(X,":") S Z=$P(X,":",2),Z=$P(Z,";"),%=$L(Z) I %>Y S Y=%
|
|---|
| 138 | . S LEN=$E("00000",1,5-$L(Y))_Y
|
|---|
| 139 | . Q
|
|---|
| 140 | I DTYPE="P" S PFLAG=1 Q "T00030"_DNAME
|
|---|
| 141 | I DTYPE="W" Q "T05000"_DNAME
|
|---|
| 142 | I DTYPE="V" Q ""
|
|---|
| 143 | Q "T00250"_DNAME
|
|---|
| 144 | ;
|
|---|
| 145 | FILE(SIEN) ; GET THE FILE OR SUBFILE NUMBER
|
|---|
| 146 | N FNO,FIEN,DIC,X,Y,%,FILE,NSTG,GBL,FNAME,SUB,FARR,TOT,I
|
|---|
| 147 | S (FILE,FNO)=$P(^BMXADO(SIEN,0),U,2)
|
|---|
| 148 | OLD I FNO D I $G(FIEN) Q FIEN
|
|---|
| 149 | . S NSTG=$O(^DD(FNO,0,"NM",""))
|
|---|
| 150 | . F S FNO=$G(^DD(FNO,0,"UP")) Q:'FNO S NSTG=$O(^DD(FNO,0,"NM",""))_"/"_NSTG
|
|---|
| 151 | OLD1 . W !,$S(NSTG["/":"Sub-",1:""),"File #",FILE," (",NSTG,") is linked to this schema."
|
|---|
| 152 | . W !,"Want to keep it" S %=1
|
|---|
| 153 | . D YN^DICN I %'=2 W:%=1 " OK" S FIEN=FILE Q
|
|---|
| 154 | . W !!,"If you change or delete this file number,",!,"all the information in this schema will be deleted."
|
|---|
| 155 | . W !,"Are you sure you want to do this" S %=2 D YN^DICN
|
|---|
| 156 | . I %'=1 W !! G OLD1
|
|---|
| 157 | . S GBL="^BMXADO("_SIEN_")"
|
|---|
| 158 | . K @GBL@(1),@GBL@(2)
|
|---|
| 159 | . S $P(@GBL@(0),U,2)=""
|
|---|
| 160 | . W !,"This schema definition has been deleted. You may redefine it now"
|
|---|
| 161 | . Q
|
|---|
| 162 | NEW S DIC=1,DIC(0)="AEQM" D ^DIC I Y=-1 Q ""
|
|---|
| 163 | S FNO=+Y,FNAME=$P(Y,U,2)
|
|---|
| 164 | NEW1 D SC(.FARR,FNO,1)
|
|---|
| 165 | S TOT=$O(FARR(999999),-1) I 'TOT Q FNO ; NO SUBFILES FOUND
|
|---|
| 166 | W !!,"The ",FNAME," file contains the following sub-file" I TOT>1 W "s"
|
|---|
| 167 | W !
|
|---|
| 168 | S I=0 F S I=$O(FARR(I)) Q:'I S PAUSE=$$PAUSE(I) Q:PAUSE'="" W I,?3,FARR(I)
|
|---|
| 169 | I $G(PAUSE)=U Q ""
|
|---|
| 170 | I $G(PAUSE) S Y=PAUSE G NEW2
|
|---|
| 171 | W !!,"Is the schema linked to a sub-file in this list"
|
|---|
| 172 | S %=2 D YN^DICN I %=2 Q FNO
|
|---|
| 173 | S DIR(0)="NO^1:"_TOT_":",DIR("A")="Select a sub-file from the list" K DA D ^DIR K DIR
|
|---|
| 174 | I 'Y Q ""
|
|---|
| 175 | NEW2 Q +$P(FARR(+Y)," (",2)
|
|---|
| 176 | ;
|
|---|
| 177 | PAUSE(I) ; SCROLL CHECK
|
|---|
| 178 | N %
|
|---|
| 179 | W !
|
|---|
| 180 | I (I#20) Q ""
|
|---|
| 181 | W "Select a number from the list (1-",(I-1),") or press <ENTER> to continue: "
|
|---|
| 182 | R %:$G(DTIME,60) E Q ""
|
|---|
| 183 | I %?1."^" Q U
|
|---|
| 184 | I $L(%),$D(FARR(I)) Q %
|
|---|
| 185 | I $L(%) W " ??" H 2
|
|---|
| 186 | W $C(13),?79,$C(13)
|
|---|
| 187 | Q ""
|
|---|
| 188 | ;
|
|---|
| 189 | SC(OUT,FILE,MODE) ;EP - SUB CRAWLER. GIVEN A FILE NUMBER RETURN ALL OF ITS DESCENDANT FILES IN AN ARRAY
|
|---|
| 190 | I '$D(^DD(FILE,"SB")) Q ; NO DESCENDANTS
|
|---|
| 191 | N TOT,FNO,FNAME,FIEN,LEVEL,NODE,SARR,STG,X,%,UP,ARR
|
|---|
| 192 | S FIEN=FILE,TOT=0
|
|---|
| 193 | D PASS1
|
|---|
| 194 | I '$O(ARR(0)) Q
|
|---|
| 195 | SC2 ; SECOND PASS. BUILD THE INTERMEDIATE ARRAY
|
|---|
| 196 | S FNO=0 F S FNO=$O(ARR(FNO)) Q:'FNO D
|
|---|
| 197 | . I $P($G(^DD(FNO,.01,0)),U,2)["W" K ARR(FNO) Q ; WORD PROCESSING FIELDS DO NOT COUNT
|
|---|
| 198 | . S STG=FNO,UP=FNO
|
|---|
| 199 | . F S UP=$G(^DD(UP,0,"UP")) Q:'UP S STG=UP_","_STG ; BUILD DESCENDANT STRING
|
|---|
| 200 | . I $G(MODE) S STG=$$ASTG(STG)
|
|---|
| 201 | . S STG=$P(STG,",",2,99) ; DONT NEED TOP LEVEL FILE
|
|---|
| 202 | . I '$L(STG) Q ; SOMETHING IS SCREWED UP
|
|---|
| 203 | . S LEVEL=$L(STG,",")
|
|---|
| 204 | . S FNAME=$O(^DD(FNO,0,"NM",""))
|
|---|
| 205 | . S X="SARR("_STG_")"
|
|---|
| 206 | . S @X=FNAME_U_LEVEL_U_FNO
|
|---|
| 207 | . K ARR(FNO)
|
|---|
| 208 | . Q
|
|---|
| 209 | SC3 ; 3RD PASS. BUILD OUTPUT ARAY
|
|---|
| 210 | S NODE="SARR"
|
|---|
| 211 | F S NODE=$Q(@NODE) Q:NODE="" D
|
|---|
| 212 | . S X=@NODE
|
|---|
| 213 | . S TOT=TOT+1
|
|---|
| 214 | . S FNAME=$P(X,U)
|
|---|
| 215 | . S LEVEL=$P(X,U,2)
|
|---|
| 216 | . S FNO=$P(X,U,3)
|
|---|
| 217 | . S OUT(TOT)=$E(" ",1,LEVEL)_FNAME_" ("_FNO_")"
|
|---|
| 218 | . Q
|
|---|
| 219 | Q
|
|---|
| 220 | ;
|
|---|
| 221 | PASS1 ; PASS 1. BUILD THE ARRAY OF ALL SUBFILES
|
|---|
| 222 | N FNO S FNO=0
|
|---|
| 223 | F S FNO=$O(^DD(FIEN,"SB",FNO)) Q:'FNO D
|
|---|
| 224 | . S ARR(FNO)=""
|
|---|
| 225 | . I '$D(^DD(FNO,"SB")) Q
|
|---|
| 226 | . N FIEN S FIEN=FNO
|
|---|
| 227 | . D PASS1 ; RECURSION!!
|
|---|
| 228 | . Q
|
|---|
| 229 | Q
|
|---|
| 230 | ;
|
|---|
| 231 | ASTG(STG) ; CONVERT STRING FROM FILE NUMBERS TO FILE NAMES
|
|---|
| 232 | N PCE,LEV,FNO,NAME
|
|---|
| 233 | S LEV=$L(STG,",")
|
|---|
| 234 | F PCE=1:1:LEV S FNO=+$P(STG,",",PCE) D I '$L(STG) Q ""
|
|---|
| 235 | . S NAME=$O(^DD(FNO,0,"NM",""))
|
|---|
| 236 | . I $E(NAME)="*" S NAME=$E(NAME,2,99)
|
|---|
| 237 | . I '$L(NAME) S STG="" Q
|
|---|
| 238 | . S $P(STG,",",PCE)=""""_NAME_""""
|
|---|
| 239 | . Q
|
|---|
| 240 | Q STG
|
|---|
| 241 | ;
|
|---|
| 242 | FLIST(OUT,FILE,MODE) ;EP - GIVEN A FILE RETURN THE FILEDS IN AN ARRAY MODE=0: NUMERIC ORDER, MODE=1: ALPHA ORDER
|
|---|
| 243 | ; ONLY NON MULTIPLES AND WORD PROCESSING FIELDS ARE LISTED
|
|---|
| 244 | N FLD,TOT,NAME,ARR,SS,%,WP
|
|---|
| 245 | S FLD=0,TOT=0
|
|---|
| 246 | F1 F S FLD=$O(^DD(FILE,FLD)) Q:'FLD D ; PASS 1
|
|---|
| 247 | . S STG=$G(^DD(FILE,FLD,0)) I '$L(STG) Q
|
|---|
| 248 | . S %=$P(STG,U,2)
|
|---|
| 249 | . I %,$P($G(^DD(%,.01,0)),U,2)'["W" Q ; EXCLUDE ALL MULTIPLE FIELDS EXCEPT WORD PROCESSING FIELDS
|
|---|
| 250 | . S WP=0 I % S WP=1
|
|---|
| 251 | . S NAME=$P(STG,U)
|
|---|
| 252 | . S SS=FLD
|
|---|
| 253 | . I $G(MODE)=1 S %=NAME S:$E(%)="*" %=$E(%,2,99) S SS=%
|
|---|
| 254 | . S ARR(SS)=FLD_U_NAME_U_WP
|
|---|
| 255 | . Q
|
|---|
| 256 | F2 S SS=""
|
|---|
| 257 | F S SS=$O(ARR(SS)) Q:SS="" D
|
|---|
| 258 | . S TOT=TOT+1
|
|---|
| 259 | . S %=ARR(SS)
|
|---|
| 260 | . S OUT(TOT)=$P(%,U,2)_" ["_+%_"]"_$S($P(%,U,3):" (word processing)",1:"")
|
|---|
| 261 | . K ARR(SS)
|
|---|
| 262 | . Q
|
|---|
| 263 | Q
|
|---|
| 264 | ;
|
|---|
