-
Notifications
You must be signed in to change notification settings - Fork 0
/
f_izq.php
122 lines (99 loc) · 4.23 KB
/
f_izq.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
<html>
<head>
<title>Untitled Document</title>
<link rel="stylesheet" href="estilos_totales.css">
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" background="img/fondo_izq.gif">
<table border="0" cellpadding="0" cellspacing="0" width="173">
<!-- fwtable fwsrc="img_menu_carpetas.png" fwbase="img_menu_izq.gif" -->
<tr> <!-- Shim row, height 1. -->
<td><img src="img/shim.gif" width="173" height="1" border="0"></td>
<td><img src="img/shim.gif" width="1" height="1" border="0"></td>
</tr>
<tr valign="top"><!-- row 1 -->
<td><img name="img_menu_izq_r1_c1" src="img/img_menu_izq_r1_c1.gif" width="173" height="57" border="0"></td>
<td><img src="img/shim.gif" width="1" height="57" border="0"></td>
</tr>
<tr valign="top"><!-- row 2 -->
<td background="img/img_menu_izq_r2_c1.gif">
<table width="140" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<?php
//<meta http-equiv="Refresh" content="3;URL=http://www.algunsitio.com/nuevo.html">,
$servidor = "localhost";
$bd = "bdprueba";
$usuario = "root";
$contrasena= "jhlc";
putenv("ORACLE_SID=DBPRUEBA");
putenv("ORACLE_HOME=/oracle1/product/817");
$handle = ora_logon("fldoc@bdprueba", "Fldoc");
ora_commiton($handle);
$cursor = ora_open($handle);
$numeroa=0;$numero=0;$numeros=0;$numerot=0;$numerop=0;$numeroh=0;
echo "<center>DocuImage - WEB <BR> CONTROL DOCUMENTOS DE CORRESPONDENCIA</center>";
echo "<table border=1 width=100%>";
echo "<td width=35%>";
echo "<br>";
$isql = "select USUA_LOGIN,USUA_PASW from usuario where USUA_LOGIN ='$krd'";
$resultado = ora_parse($cursor,$isql);
$resultado = ora_exec($cursor);
$row=array();
ora_fetch_into($cursor,$row, ORA_FETCHINTO_NULLS|ORA_FETCHINTO_ASSOC);
//echo $row["usuario"].$krd;
echo "<font size=1>Usuario ".$row["USUA_LOGIN"]."<br>";
if (trim($row["USUA_LOGIN"])==trim($krd))
{
$contraxx=$row["USUA_PASW"];
if (trim($contraxx)==SUBSTR(md5(trim($drd)),1,26))
{
$iusuario = " and us_usuario='$krd'";
$isql ="select * from carpeta order by carp_codi ";
//$isql ="select * from radicado_rd where rd_estado=5 $iusuario ";
// $result1 = ora_do($handle,$isql);
ora_parse($cursor,$isql);
ora_exec($cursor);
$numerot = ora_numrows($cursor);
$row = array();
while($result1=ora_fetch_into($cursor,$row, ORA_FETCHINTO_NULLS|ORA_FETCHINTO_ASSOC))
{ $row1 = array();
//$data = trim(ora_getcolumn($cursor, 1));
$data = trim($row["CARP_DESC"]);
$numdata = trim($row["CARP_CODI"]);
if($data =="") $data = "NULL";
//$numerot = ora_numrows($cursor2);
if($carpeta==$numdata){$imagen="folder_open.gif";}else{$imagen="carpeta.gif";}
echo "<a href='cuerpo.php?carpeta=$numdata&contra=".md5($drd)."&usua=".md5($krd)."&drd=$drd&krd=$krd' target='f_des' alt='Seleccione una Carpeta'><img src='iconos/$imagen' border=0 alt='$data'><font size=1><b>$data ($numerot)</font></a> <br>";
}
//$isql = "INSERT INTO USUARIO (USUA_CODI,DEPE_CODI,USUA_LOGIN,USUA_PASW,USUA_ESTA,usua_fech_crea)";
//$isql .="VALUES(99,1,'jh2','". substr(md5("jhlc"),1,26) ."','1',to_date('".date("d-m-y")."','dd-mm-yy'))";
//ECHO $isql;
//$TT =ora_parse($cursor,$isql) or die ("No se pudo Agregar Usuario1");
//$TT =ora_exec($cursor) or die ("No se pudo Agregar Usuario2");
echo "</td>";
echo "<td width=65%>";
$row = array();
}
}
//*********************TRANSACCIONES DEL CURSOR DE CONSULTA PRIMARIA**************************************************************************************************
?>
</td>
</tr>
<tr>
<td>
<p align="center"><img src="img/img_logo_sspd.gif" width="100" height="75"></p>
</td>
</tr>
</table>
</td>
<td><img src="img/shim.gif" width="1" height="4" border="0"></td>
</tr>
<tr valign="top"><!-- row 3 -->
<td height="47"><img name="img_menu_izq_r3_c1" src="img/img_menu_izq_r3_c1.gif" width="173" height="49" border="0"></td>
<td height="47"><img src="img/shim.gif" width="1" height="49" border="0"></td>
</tr>
<!-- This table was automatically created with Macromedia Fireworks 3.0 -->
<!-- http://www.macromedia.com -->
</table>
</body>
</html>