bcompiler v0.21s
dataSourcePHP
A __construct dataSourceName classe __construct @ @ PDO <
session_start
B < < P trim ( x!h $+ dataSourceName P B < < trim x x!h $+ classe m q getinstance = x!h $+ instance > a /home/wwwdisco1/portal/html/pr/secfinancas/emprel/dicionariodados/dataSourcePHP/dataSourcePHP.php
dataSourcePHP ! dataSourceNameŕ}qqT classe˱ ?f$nm getnomedatasource getNomeDataSource m " q getdatasourcexml " = ( " & P ( " G x $ & x $ R
datasource
% M % N % % & @ % R name & B < & < utf8_decode & h name & & R 0 description ' B 0 < ' < X utf8_decode ' description ' X ' X ( ( * $+ ) 1 ) C < * < sort * > + > , , a /home/wwwdisco1/portal/html/pr/secfinancas/emprel/dicionariodados/dataSourcePHP/dataSourcePHP.php
dataSourcePHP xmlObject
\ sr dsnܕ| ds k atributos" &;%pr 9͏}aƜ getatributosdatasource dataSourceName getAtributosDataSource V V ? 3 m 6 q getdatasourcexml 6 = ( 6 & P ( 6 G x 9 & x 9 R
datasource
: M D : N D : : & @ : R h name ; B h < ; <
strtoupper
; B < ; <
strtoupper
; ; + C $+ ; R 0 name < B 0 < < < X utf8_decode < name < X < R description = B < = < utf8_decode = description = = R p engine > B p < > < utf8_decode > H engine > > R host ? B < ? < 8 utf8_decode ? host ? 8 ` ? R database @ B < @ < utf8_decode @ database @ @ R P user A B P < A < x utf8_decode A ( user A x A R password B B < B < utf8_decode B password B @ B R port C B < C < utf8_decode C h port C C R 0 protocol D B 0 < D < X utf8_decode D protocol D X D 1 E > E * C $+ F * $+ G 1 G B < H < count H H + T $+ H m PDOException I D R I 5 H I 7 H H No existe o DSN ( I R p hh $+ dataSourceName I 8 H H p I 6 H H ) I A H = I = I l I * T $+ J > K K 8 D a /home/wwwdisco1/portal/html/pr/secfinancas/emprel/dicionariodados/dataSourcePHP/dataSourcePHP.php
dataSourcePHP dataSourceNameŕ}qqT xmlObject
\ sr atributos" &;%pr ds k nWr|i getinstance getInstance R hh $+ dataSourceName T ( T + ( $+ T > U * $+ V R P Hh $+ classe X x P X / x x $+ X R h $+ classe X B < X G PDO X H PEAR X A < X < in_array X
X 4 x X + x $+ X m @ @ PDOException Y D h @ @ Y A 8 Classes disponveis (PDO ou PEAR). Classe default (PDO).8 = Y = Y l h Y * $+ Z m ] q getatributosdatasource ] ^ h $+ dataSourceName ] B = ] = ] & 0 ] & X ` m ` P dbInstances ` B < ` < count ` ` - 5 ' ` $ ` F ` * $+ ` m H H a P dbInstances H H a Q p a Q p a R h $+ dataSourceName a a + 4 $+ a m 8 8 b P dbInstances 8 8 b Q ` b Q ` b > b * 4 $+ c * $ $+ d R 8 h $+ classe g PEAR g + $+ g I ( /usr/share/pear/DB.php h Q P engine i B P < i < x
strtoupper
i x DB2 i + O $+ i Q user j odbc:// j : j m @ @ j q @ @ getsenha j ] h password j B h = j = j j @ j & j Q 0 host l X 0 / l Q database l X l l * y $+ m Q engine n B < n <
strtoupper
n H OCI n + H g $+ n Q p engine o p 8:// o Q user o o : o m 8 8 o q 8 8 getsenha o ] ` password o B ` = o = o o @ o &
o Q (
host q P
(
/ q Q x
database q
P
x
q
q * y $+ r Q
engine s
:// s Q @ user s h @ s h : s m s q getsenha s ] password s B = s = s 0 s X 0 @ s & X s Q host u / u Q database u
u H
u m
DB y q
connect y B = y =
y p
^h $+ instance y
y m
z R ^h $+ instance z S ` dbInstances
z T ` z 8 z z m { R x x_h $+ dataSourceName { S P dbInstances { T P { ( { x { * $+ | Q engine } B < } <
strtoupper
} DB2 } + $+ } @ odbc:DSN=DB2_DSN; database= ~ Q h database ~ @ h ~
;hostname=
~ Q host ~ ~ & 0 ~ * $+ Q X engine B X < <
strtoupper
SQL + $+ Q database odbc:Driver=SQLTest; database= ; Server= Q H host p H & p * $+ Q engine :dbname= Q database 8 ` 8 ;host= Q host ` & s port
( + ( $+ Q P port x ; port= P x * $+ s protocol
+ $+ Q protocol @
;protocol=
h @ * $+ m PDO D B = ] user B = m 0 0 q 0 0 getsenha ] X password B X = = j = hch $+ instance m R p ch $+ instance S H dbInstances T H p m R ` hdh $+ dataSourceName S 8 dbInstances T 8 ` m q setlogacesso A Solicitou Instncia = = m P x dbInstances Q ( x Q P ( > P > ' $ 5 a /home/wwwdisco1/portal/html/pr/secfinancas/emprel/dicionariodados/dataSourcePHP/dataSourcePHP.php
dataSourcePHP atributos" &;%pr iwY dbInstances7 dsnܕ| J|E getdatasourcexml getDataSourceXML R gh $+ fileXML B < < ( file_exists + ( $+ R P gh $+ fileXML B P < < x simplexml_load_file > x * $+ m PDOException D
A Arquivo xml no encontrado. = = l > a /home/wwwdisco1/portal/html/pr/secfinancas/emprel/dicionariodados/dataSourcePHP/dataSourcePHP.php
dataSourcePHP -0w getsenha str getSenha _ _ @ & 123chavesecreta123 B < A < A < < ( substr & P ( x + x $+ m PDOException D
A / Erro na recuperao da chave (EnCrypt/DeCrypt)./ = = l * $+ A < < chr j A < B < < @ str_replace & h @ B < < strlen + $+ m PDOException D A . Erro na formatao da chave (EnCrypt/DeCrypt).. = = 0 l * $+ B < < X strlen X + ( $+ B < < strlen * ) $+ & G & H & p - 9 2 $ F * - $+ Q B < < 8 ord
` 8 ` * / $+ & & B < < strlen ( - ( \ B $ P F P * ; $+ Q x B x < < ord &
+ N $+ Q @ h @ A h < < chr * Q $+ B < < chr $ 0 F 0 X + X Y $+ * Z $+ & * ? $+ > > 2 2 / 9 B ? \ a /home/wwwdisco1/portal/html/pr/secfinancas/emprel/dicionariodados/dataSourcePHP/dataSourcePHP.php
dataSourcePHP str>| ky kl kxY iwY jwY eJwY 0k5
setlogacesso acao setLogAcesso ) ) ? R Prh $+ fileLog B < A a < < ( fopen & P ( & x
A d/m/Y < < date
A h:i:s < < date @ h @
h
P 0 _SERVER Q X 0 REMOTE_ADDR X
P _SERVER Q SCRIPT_NAME H p H
p R bi $+ dataSourceName
8 `
B < B < < fwrite B < < fclose > a /home/wwwdisco1/portal/html/pr/secfinancas/emprel/dicionariodados/dataSourcePHP/dataSourcePHP.php
dataSourcePHP acaoy=1 fp;s log-| CB setdatasourcexml acao str setDataSourceXML @ @ I . $+ ( A 4 ( . $+ P E 4 P + $+ m x x PDOException D x x A 7 Aes permitidas (I)ncluso, (A)lterao ou (E)xcluso.7 = = l * $+ B < < utf8_encode & B < < @ simplexml_load_string & h @ m q criticadatasourcexml B = = <
session_id
/tmp/ 0 .xml & X 0 m q getdatasourcexml = & A d/m/Y H:i:s < R /i $+ fileXML B < < filemtime j < H date & p H m SimpleXMLElement D - A ! ! = = & R 8
datasource
M ` 8 o N ` o & R name R
datasource
R ( name B ( < < P
strtoupper
x P A x < <
strtoupper
+ n $+ p addChild A
datasource
= = & p @ addChild A name = ^ h name B h = = p addChild A description = ^ description B = = p 0 addChild A engine = ^ X engine B X = = p addChild A host = ^ host B = = p addChild A database = ^ H database B H = = p p addChild A user = ^ user B = = p addChild A password = ^ 8 password B 8 = = ` p addChild A port = ^ port B = = p
addChild A protocol = ^ (
protocol B (
= = P
* n $+ * 0 $+ 1 ` 0 x
I + x
s $+ * u $+
0 x
A
+ x
$+
p
addChild A
datasource
= =
&
p addChild A name = ^ @
datasource
^ h @ name B h = = p addChild A description = ^
datasource
^ description B = = 0 p X addChild A engine = ^
datasource
^ engine B = = p addChild A host = ^
datasource
^ H
host B H
= = p
p
addChild A database = ^
datasource
^
database B
= = p 8 addChild A user = ^ `
datasource
^ ` user B = = R
datasource
R password & ( p P addChild A password = m x x q x x getsenha 5 8 A = = j = p addChild A port = ^ @
datasource
^ h @ port B h = = p addChild A protocol = ^
datasource
^ protocol B = = 0 * $+ p X asXML B = = + $+ A d/m/Y H:i:s < R ki $+ fileXML B < < filemtime j < date + $+ B < R H ki $+ fileXML B H < < p copy + p $+ m " q setlogacesso " A
Manipulou XML
= " = " B < # < unlink # > $ * $+ % m PDOException & D 8 & A Falha durante cpia do xml. = & = ` & l 8 & * $+ ( m PDOException ) D ) A C Falha na gravao do xml (E01). Arquivo alterado por outro usurio.C = ) = ) l ) * $+ + m PDOException , D ( , P + Falha na gravao do xml (E02) temporrio (+ , x P ). , A x = , = , l ( , > . . 3 0 o p a /home/wwwdisco1/portal/html/pr/secfinancas/emprel/dicionariodados/dataSourcePHP/dataSourcePHP.php
dataSourcePHP
acaoy=1 str>| xmlParametro⓮ fileTempXML̉ xmlObject
\ sr dataHoraAntlۖy9 dsnܕ| ds k
datasourcePx} passwdw cw copiadatasourcexml dsOrigem str copiaDataSourceXML @ 5 @ 5 & 7 B < : < ( utf8_encode : & P ( : B < ; < x simplexml_load_string ; & x ; > + $+ > m PDOException ? D ? A ) Informe o nome do data source para cpia.) = ? = @ ? l ? * $+ @ m h h C q h h criticadatasourcexml C B = C = C <
session_id
F /tmp/ F .xml F & 0 F m X X I q X X getdatasourcexml I = I & I A d/m/Y H:i:s < L R i $+ fileXML L B < L < filemtime L j L < date L & H L m p p SimpleXMLElement O D p p ( O A ! ! = O = O & O R
datasource
R M 8 R N ` 8 R R & ` R p addChild S A
datasource
= S = S & S p ( addChild T A name = T ^ P name T B P = T = x T p addChild U A description = U ^ description U B = U = U p addChild V A engine = V ^ @ engine V B @ = V = h V p addChild W A host = W ^ host W B = W = W p addChild X A database = X ^ 0 database X B 0 = X = X X p addChild Y A user = Y ^ user Y B = Y = Y p addChild Z A password = Z ^ password Z B = Z = H Z p p addChild [ A port = [ ^ port [ B = [ = [ p addChild \ A protocol = \ ^ protocol \ B = \ = 8 \ R ` name ` B ` < ` <
strtoupper
` B < ` <
strtoupper
` ` + $+ ` p
addChild a A
datasource
= a = (
a & P
(
a p x
addChild b A name = b ^
datasource
b ^
name b B
= b =
b p addChild c A description = c ^ @
datasource
c ^ h @ description c B h = c = c p addChild d A engine = d ^
datasource
d ^ engine d B = d = 0 d p X addChild e A host = e ^
datasource
e ^ host e B = e = e p addChild f A database = f ^
datasource
f ^ H
database f B H
= f = p
f p
addChild g A user = g ^
user g B
= g =
g p addChild h A password = h ^ 8 password h B 8 = h = ` h p addChild i A port = i ^
datasource
i ^ port i B = i = i p ( addChild j A protocol = j ^ P
datasource
j ^ x P protocol j B x = j = j & k * $+ l * + $+ m 1 8 m p asXML p B = p = p + $+ p A d/m/Y H:i:s < r R @ ti $+ fileXML r B @ < r < h filemtime r j h r < date r r + $+ r B < t R ti $+ fileXML t B < t < copy t + $+ t B < u < 0 unlink u + $+ v m X X x q X X setlogacesso x A
Manipulou XML
= x = x > y * $+ z > { * $+ } m PDOException ~ D ~ A Falha durante cpia do xml. = ~ = ~ l ~ * $+ m PDOException D H A C Falha na gravao do xml (E03). Arquivo alterado por outro usurio.C = = p l H * $+ m PDOException D + Falha na gravao do xml (E04) temporrio (+ ). A = = 8 l > | . + a /home/wwwdisco1/portal/html/pr/secfinancas/emprel/dicionariodados/dataSourcePHP/dataSourcePHP.php
dataSourcePHP
dsOrigemjgw str>| copiaOkVF xmlParametro⓮ fileTempXML̉ xmlObject
\ sr dataHoraAntlۖy9 dsnܕ| ds k
datasourcePx} 8O9 #B criticadatasourcexml xmlParametro criticaDataSourceXML f f ? & R (
datasource
R P ( name B P < A < A < < x substr & x R
datasource
R name B < A < A < < substr & @ R h
datasource
R h name B < A < A < < substr & ( DS + $+ 0 Parte fixa deve ser (DS) * $+ B < < X trim j X < strlen + $ $+ 0
Quatro (4) caracteres para o nome do sistema0 * $ $+ R
datasource
R description B < < H trim p H + p , $+
Informe a descrio * , $+ R
datasource
R engine B < G db2 H firebird H mysql H odbc H oci H pgsql H sql A < < 8 in_array
` 8 + ` < $+ Z
Engines permitidos (db2, firebird, mysql, odbc, oci (Oracle) sql (sqlserver) ou pgsql)Z * < $+ R
datasource
R host B < < trim ( + ( D $+ P
Informe o host * D $+ R x
datasource
R x database B < < trim + L $+
Informe o database * L $+ R @
datasource
R h @ user B h < < trim + T $+
Informe o usurio * T $+ R
datasource
R 0 password B 0 < < X trim X + \ $+
Informe a senha * \ $+ + d $+ m PDOException D b B = = H l * d $+ > 6 a /home/wwwdisco1/portal/html/pr/secfinancas/emprel/dicionariodados/dataSourcePHP/dataSourcePHP.php
dataSourcePHP xmlParametro⓮ mens1 dsFixo& dsSistema]^Lpr dsSequ' im- disconnect
disconnect / / R i $+ instance ( + ( ( $+ & P m x x P dbInstances x x B < < count - '
$ F * $+ m @ @ P dbInstances @ @ Q h Q h R i $+ instance + & $+ m 0 0 _ dbInstances 0 0 ` X K X m _ H dbInstances ` H K p PEAR + p " $+ R i $+ instance p
disconnect
= * $ $+ i $+ instance 2 * & $+ *
$+ * - $+ m 8 8 PDOException D ` 8 8 , A No existe instncia aberta. = = l ` >
' a /home/wwwdisco1/portal/html/pr/secfinancas/emprel/dicionariodados/dataSourcePHP/dataSourcePHP.php
dataSourcePHP iwY dbInstances7 class;:R D; '
dataSourcePHP dataSourceName 8\g$+ b7 dataSourcePHP fileXML $ /etc/dataSourcePHP/dataSourcePHP.xml$ b7 dataSourcePHP fileLog ) /var/log/php/datasource/dataSourcePHP.log) SE/
ֈ * instance C$+ 7 dbInstances dataSourcePHP dbInstances Fc]ŕ}qqT dataSourceName dataSourcePHP dataSourceName D; '
Vh3 fileXML dataSourcePHP fileXML b7g3 fileLog dataSourcePHP fileLog b7]w instance * instance SE/
ֈ Fc] dataSourcePHP dbInstances datasourcephp
> a /home/wwwdisco1/portal/html/pr/secfinancas/emprel/dicionariodados/dataSourcePHP/dataSourcePHP.php Q