Viewing file:  soporte.php (22.72 KB) -rw-rw-rw-
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
$accion = isset($acc);
if ($accion == true) {
if ($acc == "arc") {
include('hoy.php');
include('conexion.php');
$query ="UPDATE soporte SET status=1, fecha_res='$fyt', respuest='$respuesta', who='$who' WHERE id='$id'";
$result = mysql_query($query,$db);
}
if ($acc == "arc2") {
include('hoy.php');
include('conexion.php');
$query ="UPDATE soporte SET status=2, fecha_upd='$fyt' WHERE id='$id'";
$result = mysql_query($query,$db);
}
}else{
$acc = "normal";
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Oficina Asesora de Planeación, Sistemas</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/JavaScript">
<!--
<!--
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_showHideLayers() { //v6.0
var i,p,v,obj,args=MM_showHideLayers.arguments;
for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null) { v=args[i+2];
if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v=='hide')?'hidden':v; }
obj.visibility=v; }
}
//-->
function despMenu(nombre,sn)
{
obj = document.all[nombre];
if (sn>0)
obj.style.visibility = "visible";
else
obj.style.visibility = "hidden";
}
function destacar(obj, val)
{
if (val==1)
{
itemOrig = obj.style.backgroundColor;
obj.style.backgroundColor="#FFFAD7";
}
else
obj.style.backgroundColor= itemOrig;
}
//-->
</script>
<style type="text/css">
<!--
input {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 9px;
color: #666666;
}
select {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 9px;
color: #666666;
background-color: #FFFFFF;
}
-->
</style>
</head>
<body link="#0066CC" vlink="#0066CC" alink="#0066CC" topmargin="0">
<table width="100%" border="0" cellpadding="6">
<tr>
<td width="25%"> </td>
<td width="50%"><img src="sys/bann.gif" width="600" height="120"></td>
<td width="25%"> </td>
</tr>
<tr>
<td> </td>
<td valign="top" bgcolor="#FFFFFF"><table width="100%" border="1" cellpadding="6" cellspacing="0" bordercolor="#B9D7FF" bgcolor="#EAF3FF">
<tr bgcolor="#B9D7FF">
<td colspan="3"><div align="center"><font color="#003366" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Buzón
requerimientos de soporte</strong></font> <font color="#003366" size="4" face="Arial, Helvetica, sans-serif"><strong>I</strong></font>
<font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="reqsoporte.php?acc=normal">Normal
</a></font><font color="#003366" size="4" face="Arial, Helvetica, sans-serif"><strong>I</strong></font>
<font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>
</strong></font><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="reqsoporte.php?acc=all">Ver
el listado completo</a></font><font color="#FFFFFF" size="1" face="Verdana, Arial, Helvetica, sans-serif"><strong>
</strong></font></div></td>
</tr>
<tr>
<td width="30%" valign="top"> <form name="form3" method="post" action="reqsoporte.php">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2"> <div align="center">
<table width="100%" border="2" cellpadding="4" cellspacing="0" bordercolor="#EAF3FF">
<tr>
<td bgcolor="#97C4FF"> <div align="center"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Buscar
por ticket</font></div></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td><div align="right">
<input name="fid" type="text" id="fid" size="10">
<font color="#EAF3FF"> d</font> </div></td>
<td><input type="submit" name="Submit3" value="Ver...">
<input name="acc" type="hidden" id="acc22" value="id"></td>
</tr>
</table>
</form>
<p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"></font></p></td>
<td width="35%" valign="middle"> <form name="form1" method="post" action="reqsoporte.php">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2"> <div align="center">
<table width="100%" border="2" cellpadding="4" cellspacing="0" bordercolor="#EAF3FF">
<tr>
<td bgcolor="#97C4FF">
<div align="center"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Buscar
por usuarios</font></div></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td><div align="right">
<select name="user1" id="user1">
<?php
require('conexion2.php');
$stmt = Ociparse($c1, " SELECT EU_USERNAME FROM envista.env_users");
echo $c1;
$result = OCIExecute($stmt);
if ($result == false) {
echo OCIError($stmt);
}else{
while (OCIFetchInto($stmt, $value1)) {
foreach ($value1 as $val1)
{
$usrx = $val1;
echo "<option value=\"$usrx\">$usrx</option>";
}}}
$c2 = OciLogoff($c1);
?>
</select>
<font color="#EAF3FF"> d</font> </div></td>
<td><input type="submit" name="Submit" value="Ver..."> <input name="acc" type="hidden" id="acc" value="user"></td>
</tr>
</table>
</form></td>
<td width="35%" valign="middle"> <form name="form2" method="post" action="reqsoporte.php">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2"> <div align="center">
<table width="100%" border="2" cellpadding="4" cellspacing="0" bordercolor="#EAF3FF">
<tr>
<td bgcolor="#97C4FF">
<div align="center"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Buscar
por fechas</font></div></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td> <div align="right">
<select name="ano" id="ano">
<option value="2004">2004</option>
<option value="2005">2005</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
</select>
<select name="mes" id="mes">
<option value="01">Ene</option>
<option value="02">Feb</option>
<option value="03">Mar</option>
<option value="04">Abr</option>
<option value="05">May</option>
<option value="06">Jun</option>
<option value="07">Jul</option>
<option value="08">Ago</option>
<option value="09">Sep</option>
<option value="10">Oct</option>
<option value="11">Nov</option>
<option value="12">Dic</option>
</select>
<select name="dia" id="dia">
<option value="01">1</option>
<option value="02">2</option>
<option value="03">3</option>
<option value="04">4</option>
<option value="05">5</option>
<option value="06">6</option>
<option value="07">7</option>
<option value="08">8</option>
<option value="09">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<font color="#EAF3FF"> d</font> </div></td>
<td><input type="submit" name="Submit2" value="Ir.."> <input name="acc" type="hidden" id="acc" value="fecha"></td>
</tr>
</table>
</form></td>
</tr>
</table></td>
<td> </td>
</tr>
<tr>
<td width="25%"> </td>
<td width="50%"> <table width="100%" border="1" cellpadding="6" cellspacing="0" bordercolor="#B9D7FF" bgcolor="#EAF3FF">
<tr>
<td> <table width="100%" border="1" cellpadding="4" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<?php
require('conexion.php');
if ($acc == "all") {
$consul7 = "SELECT *
FROM soporte where tipo_req=0 and (tipo_pro = 0 or tipo_pro = 1 or tipo_pro = 7 or tipo_pro = 8)"
. " order by id DESC";
}
if ($acc == "normal" or $acc == "arc" or $acc == "arc2") {
$consul7 = "SELECT *
FROM soporte where status<=1 and tipo_req=0 and (tipo_pro = 0 or tipo_pro = 1 or tipo_pro = 7 or tipo_pro = 8)"
. " order by id DESC";
}
if ($acc == "id") {
$consul7 = "SELECT *
FROM soporte where id=$fid";
}
if ($acc == "user") {
$consul7 = "SELECT *
FROM soporte where user='$user1' and tipo_req=0 and (tipo_pro = 0 or tipo_pro = 1 or tipo_pro = 7 or tipo_pro = 8)";
}
if ($acc == "fecha") {
$fecha_comp = $ano . "-" . $mes . "-" . $dia . " 00:00:00";
$fecha_comp2 = $ano . "-" . $mes . "-" . $dia . " 23:59:59";
$consul7 = "SELECT *
FROM soporte where (fecha_ing > '$fecha_comp' and fecha_ing < '$fecha_comp2') and tipo_req=0 and (tipo_pro = 0 or tipo_pro = 1 or tipo_pro = 7 or tipo_pro = 8)";
}
$result7 = mysql_query($consul7,$db);
$num_filas7 = mysql_num_rows($result7);
while ($myrow7 = mysql_fetch_array($result7))
{
$sid = $myrow7["id"];
$susr = $myrow7["user"];
$sdep = $myrow7["dependencia"];
$st_f = $myrow7["tipo_fun"];
$st_r = $myrow7["tipo_req"];
$st_p = $myrow7["tipo_pro"];
$sdes = $myrow7["descripcion"];
$sf_i = $myrow7["fecha_ing"];
$sf_u = $myrow7["fecha_upd"];
$sf_r = $myrow7["fecha_res"];
$scon = $myrow7["contact"];
$ssta = $myrow7["status"];
$sres = $myrow7["respuest"];
$sres = str_replace("\n", "<br>", $sres);
$swho = $myrow7["who"];
$sres = "<br><font size=\"1\"><b>Respuesta: </b>" . $sres ."</font>";
//////////// Fecha actaulizacion /////
if ($sf_r == "0000-00-00 00:00:00") {
$sf_r = "";
}else{
$sf_r = "<br><font size=\"1\"><b>Con respuesta en la fecha: </b></font>" . $sf_r . "<br>";
}
if ($sf_u == "0000-00-00 00:00:00") {
$sf_u = "";
$sf_t = "";
}else{
$actual = $sf_u;
$anterior = $sf_i;
list($fechaAct, $horaAct) = explode(" ", $actual);
list($yearAct, $mesAct, $dayAct) = explode("-", $fechaAct);
list($horaAct, $minAct, $secAct) = explode(":", $horaAct);
list($fechaAnt, $horaAnt) = explode(" ", $anterior);
list($yearAnt, $mesAnt, $dayAnt) = explode("-", $fechaAnt);
list($horaAnt, $minAnt, $secAnt) = explode(":", $horaAnt);
$sAct = mktime($horaAct, $minAct, $secAct, $mesAct, $dayAct, $yearAct);
$sAnt = mktime($horaAnt, $minAnt, $secAnt, $mesAnt, $dayAnt, $yearAnt);
$diffSeg = $sAct - $sAnt;
$diffMin = $diffSeg / 60;
$diffHoras = $diffMin / 60;
$diffDays = $diffHoras / 24;
//echo $diffMin;
///////////////////////////////////////
$sday = $diffMin / 1440;
$temp = explode(".",$sday);
$sday = $temp[0];
$diasp = $diffDays - $sday;
$diasp = $diasp * 24;
$temp = explode(".",$diasp);
$shor = $temp[0];
$minp = $diffMin - (($shor * 60) + ($sday * 1440));
$minp = round($minp);
//$minp = $diasp * 24;
$sf_t = "<br><font size=\"1\"><b>Resuelto en: </b>" . $sday . " Días / " . $shor . " Horas / " . $minp . " Minutos </font>";
$sf_u = "<br><font size=\"1\"><b>Resuelto en la fecha:</b></font> " . $sf_u;
}
/////////// Status ////////////////
if ($ssta == 0) {
$back2 = "#FDE0B5";
}
if ($ssta == 1) {
$back2 = "#C1FD68";
}
if ($ssta == 2) {
$back2 = "#000000";
}
/////////// Problemas //////////////
if ($st_r == 0) {
$d = "Tengo un problema con: ";
if ($st_p == "0") {
$st_pl = "El computador (Hardware)";
$back = "#DFEDFF";
}
if ($st_p == "1") {
$st_pl = "Los programas (Windows, Word, Excel, Power Point)";
$back = "#DFEDFF";
}
if ($st_p == "7") {
$st_pl = "La red";
$back = "#DFEDFF";
}
if ($st_p == "8") {
$st_pl = "La impresora o para imprimir";
$back = "#DFEDFF";
}
if ($st_p == "2") {
$st_pl = "Aplicaciones SIA DAMA";
$back = "#FFFAD7";
}
if ($st_p == "3") {
$st_pl = "Datos SIA DAMA";
$back = "#FFFAD7";
}
if ($st_p == "4") {
$st_pl = "Programas SIG (ArcExplorer)";
$back = "#FEEBCF";
}
if ($st_p == "5") {
$st_pl = "Datos SIG";
$back = "#FEEBCF";
}
if ($st_p == "6") {
$st_pl = "El uso o consulta de datos en la WEB";
$back = "#E8FEC7";
}
}
//////////////// Citas //////////////
if ($st_r == 1) {
$d = "Necesito una cita: ";
if ($st_p == "9") {
$st_pl = "Imprimir en el Plotter";
$back = "#DFEDFF";
}
if ($st_p == "10") {
$st_pl = "Copiar Datos en CD";
$back = "#DFEDFF";
}
if ($st_p == "0") {
$st_pl = "Sesión de Desarrollo SIA";
$back = "#FFFAD7";
}
if ($st_p == "1") {
$st_pl = "Carga de Datos en el SIA";
$back = "#FFFAD7";
}
if ($st_p == "2") {
$st_pl = "Reporte de Datos del SIA";
$back = "#FFFAD7";
}
if ($st_p == "3") {
$st_pl = "Capacitación en el SIA";
$back = "#FFFAD7";
}
if ($st_p == "4") {
$st_pl = "Sesión de Desarrollo SIG";
$back = "#FEEBCF";
}
if ($st_p == "5") {
$st_pl = "Revisión, planeación o carga de información SIG";
$back = "#FEEBCF";
}
if ($st_p == "6") {
$st_pl = "Sesión de Georeferenciación";
$back = "#FEEBCF";
}
if ($st_p == "7") {
$st_pl = "Reporte de Datos SIG";
$back = "#FEEBCF";
}
if ($st_p == "8") {
$st_pl = "Capacitación SIG";
$back = "#FEEBCF";
}
if ($st_p == "11") {
$st_pl = "Sesión de Desarrollo WEB";
$back = "#E8FEC7";
}
if ($st_p == "12") {
$st_pl = "Publicación WEB";
$back = "#E8FEC7";
}
if ($st_p == "13") {
$st_pl = "Capacitación WEB";
$back = "#E8FEC7";
}
}
////////// Dependencia /////////////
if ($sdep == 0) {
$sdepl = "Ambiental Sectorial";
}
if ($sdep == 1) {
$sdepl = "Ecosistemas Estratégicos";
}
if ($sdep == 2) {
$sdepl = "Jurídica";
}
if ($sdep == 3) {
$sdepl = "Administrativa";
}
if ($sdep == 4) {
$sdepl = "Control de Vivienda";
}
if ($sdep == 5) {
$sdepl = "Gestión Local";
}
if ($sdep == 6) {
$sdepl = "Of. Asesora de Planeación";
}
if ($sdep == 7) {
$sdepl = "Of. de Control Interno";
}
if ($sdep == 8) {
$sdepl = "Dirección";
}
?>
<td width="90%" bgcolor="<?php echo $back; ?>"> <p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong><font color="#FF9900"><?php echo $sid; ?></font></strong>,
<font color="#003366">
<?php if ($ssta==1) { ?>
(<a href="reqsistemasbuz2.php?id=<?php echo $sid; ?>&d=<?php echo $d; ?>&pro=<?php echo $st_pl; ?>">Imprimir</a>)
<?php } ?>
<strong> <?php echo $d; ?></strong></font>, <strong><?php echo $st_pl; ?></strong><br>
<strong><font size="1">Ingresado por:</font></strong> <?php echo $susr; ?>,
<?php echo $sdepl; ?> <br>
<strong><font size="1">Ingresado el:</font></strong> <font color="#666666"><?php echo $sf_i; ?></font>
<?php echo $sf_r; ?> <?php echo $sf_u; ?> <?php echo $sf_t; ?><br>
<strong><font size="1">Contactar en:</font></strong> <?php echo $scon; ?><br>
<?php if ($ssta != 0) { ?>
<strong><font size="1">Atendido por:</font></strong> <?php echo $swho; ?><?php } ?>
</font></p>
<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
</font><font size="1" face="Verdana, Arial, Helvetica, sans-serif">>>
<?php echo $sdes; ?></font> <font size="1" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $sres; ?></font><br>
</p></td>
<td width="10%" valign="top"> <table width="100%" border="0" cellpadding="4" cellspacing="0">
<tr>
<td width="20" height="20"><div align="center"><font face="Verdana, Arial, Helvetica, sans-serif"><strong><?php echo $st_f; ?></strong></font></div></td>
<td width="20" height="20" bgcolor="<?php echo $back2; ?>">
<div align="center">
<?php if ($ssta == 0) { ?>
<font face="Verdana, Arial, Helvetica, sans-serif"><strong><a href="reqsistemasbuz1.php?id=<?php echo $sid; ?>&w=s&who=soporte">R</a></strong></font>
<?php } ?>
<?php if ($ssta == 1) { ?>
<font face="Verdana, Arial, Helvetica, sans-serif"><strong>A</strong></font>
<?php } ?>
</div></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#FFFFFF">
<td> </td>
<td valign="top"> </td>
</tr>
<?php } ?>
</table>
<p align="center"> </p>
<p align="center"><a href="javascript:window.close()"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Cerrar...</strong></font></a></p></td>
</tr>
</table></td>
<td width="25%"> </td>
</tr>
<tr>
<td width="25%"> </td>
<td width="50%"><div align="center"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Todos
los derechos reservados para el <br>
Departamento Técnico Administrativo del Medio Ambiente. <br>
<strong>DAMA 2005</strong><br>
<em>Bogotá, Colombia.</em></font></div></td>
<td width="25%"> </td>
</tr>
</table>
<p> </p>
</body>
</html>
|