Viewing file:  sistemasbuz4.php (18.81 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 == "rep") {
include('conexion.php');
$query ="UPDATE soporte SET 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;
}
function MM_callJS(jsStr) { //v2.0
return eval(jsStr)
}
//-->
</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><div align="center"><font color="#003366" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Herramientas
para la búsqueda de un registro de soporte</strong></font></div></td>
<td><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="#" onClick="MM_callJS('history.go(-1);')">Regresar</a></font></div></td>
</tr>
<tr>
<td colspan="2" valign="top"> <form name="form3" method="post" action="reqsistemasbuz3.php">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> <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="center">
<input name="fid" type="text" id="fid" size="10">
<font color="#EAF3FF"> d</font>
<input type="submit" name="Submit3" value="Ver...">
<input name="acc" type="hidden" id="acc22" value="id">
</div></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 bgcolor="#FFFFFF">
<td><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Datos
Generales del Soporte</font></strong></td>
<td valign="top"><strong><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Estado</font></strong></td>
</tr>
<tr>
<?php
require('conexion.php');
if ($acc == "all") {
$consul7 = "SELECT *
FROM soporte"
. " order by id DESC";
}
if ($acc == "normal" or $acc == "arc" or $acc == "arc2" or $acc == "rep") {
$consul7 = "SELECT *
FROM soporte where status=0 or status=1"
. " order by id DESC";
}
if ($acc == "id") {
$consul7 = "SELECT *
FROM soporte where id=$fid";
}
if ($acc == "user") {
$consul7 = "SELECT *
FROM soporte where user='$user1'";
}
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'";
}
$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"];
$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 = "Subsecretaría General";
}
if ($sdep == 1) {
$sdepl = "Of. Asesora de PLaneación Corporativa";
}
if ($sdep == 2) {
$sdepl = "Dir. de Control y Seguimiento Ambiental";
}
if ($sdep == 3) {
$sdepl = "Dir. Legal Ambiental";
}
if ($sdep == 4) {
$sdepl = "Of. de Control Interno";
}
if ($sdep == 5) {
$sdepl = "Of. de Participación Comunitaria, Educación Ambiental y Comunicaciones";
}
if ($sdep == 6) {
$sdepl = "Dir de PLaneación y Gestión Ambiental";
}
if ($sdep == 7) {
$sdepl = "Dir. de Gestión Corporativa";
}
if ($sdep == 8) {
$sdepl = "Secretaría General";
}
?>
<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">
<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 ($swho != "") { ?>
<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><br><font size="1" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $sres; ?></font></p></td>
<td width="10%" valign="top"> <table width="100%" border="0" cellpadding="4" cellspacing="0">
<tr>
<td width="20" height="20" bgcolor="<?php echo $back2; ?>">
<div align="center">
<?php if ($ssta == 0) { ?>
<font face="Verdana, Arial, Helvetica, sans-serif"><strong></strong></font>
<?php } ?>
<?php if ($ssta == 1) { ?>
<font face="Verdana, Arial, Helvetica, sans-serif"><strong></strong></font>
<?php } ?>
</div></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#FFFFFF">
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><font size="1" face="Arial, Helvetica, sans-serif">Convenciones:
</font></td>
<td width="20"> <table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td width="20" bgcolor="#FFCC99"> </td>
</tr>
</table></td>
<td><table width="100%" border="0" cellspacing="0" cellpadding="4">
<tr>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">En
espera por respuesta del técnico</font></td>
</tr>
</table></td>
<td width="20"> <table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td width="20" bgcolor="#66CC00"> </td>
</tr>
</table></td>
<td><table width="100%" border="0" cellspacing="0" cellpadding="4">
<tr>
<td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Con
respuesta y atendido por el técnico</font></td>
</tr>
</table></td>
<td width="20"> <table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td bgcolor="#000000"> </td>
</tr>
</table></td>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="4">
<tr>
<td valign="middle"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Caso
Cerrado</font></td>
</tr>
</table>
</td>
</tr>
</table></td>
<td valign="top"> </td>
</tr>
<?php } ?>
</table>
<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>
|