<?php session_start();
/* Copyright 2005 Flávio Ribeiro
This file is part of OCOMON.
OCOMON is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
OCOMON is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with Foobar; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
if (!isset($_SESSION['s_logado']) || $_SESSION['s_logado'] == 0)
{
print "<script>window.open('../../index.php','_parent','')</script>";
exit;
}
include ("../../includes/include_geral.inc.php");
include ("../../includes/include_geral_II.inc.php");
include ("../../includes/classes/paging.class.php");
print "<html>";
print "<body>";
print "<TABLE class='header_centro' border-top: thin solid #999999;}' border='0' cellpadding='5' cellspacing='0' align='center' width='100%' bgcolor='".$cor."'>";
print "<TR class='header'>";
print "
<TD class='line' ><a title='Posição do atendimento'>".TRANS('OCO_NUMBER_PS')."</a></TD>
<TD class='line' ><a title='Número do Chamado'>".TRANS('OCO_NUMBER_CH')."</a></TD>
<TD class='line' ><a title='Nome Solicitante'>".TRANS('OCO_CONTACT')."</a></TD>
<TD class='line' ><a title='Atende que está realizando o chamado'>".TRANS('TXTAREA_IN_ATTEND_BY')."</a></TD>
<TD class='line' ><a title='Data Abertura'>".TRANS('OCO_FIELD_DATE_OPEN')."</a></TD>
<TD class='line' ><a title='Status do Chamado'>".TRANS('OCO_STATUS')."</a></TD>";
print "</TR>";
$valign = " VALIGN = TOP ";
$qry = "select nome from usuarios where user_id = ".$_SESSION['s_uid']."";
$exec = mysql_query($qry);
$r_user = mysql_fetch_array($exec);
$contato = $r_user['nome'];
$sqlSubCall = "SELECT u.nivel as nivel,numero,data_abertura,oco_prior,prior_atend.pr_nivel,prior_atend.pr_desc,u.nome,s.status, aberto_por, u2.nome as abertopor
FROM ocorrencias o INNER JOIN status s on o.status=s.stat_id
INNER JOIN usuarios u on o.operador=u.user_id
INNER JOIN usuarios u2 on o.aberto_por = u2.user_id
INNER JOIN prior_atend on o.oco_prior=prior_atend.pr_nivel
where o.status <> '4' and o.status <> '12' and o.status <> '3'
order by numero
";
$execSubCall = mysql_query($sqlSubCall) or die (TRANS('ERR_QUERY').'<br>'.$sqlSubCall);
$regSub = mysql_num_rows($execSubCall);
$count = 1;
$j = 0;
while ($row = mysql_fetch_array($execSubCall))
{
$data2 = $row['data_abertura'];
$data = date('d/m/Y H:i:s ', strtotime($data2));
$cor1 = '#f6f6f6';
$cor2 = '#e3e1e1';
$cor3 = '#1E90FF';
$destaca = '#cccccc';
if($contato == $row['abertopor']){
$cor = $cor3;
}else {
if ($j % 2) {
$cor = $cor2;
} else {
$cor = $cor1;
}}
$j++;
if($row['nivel'] == '1'){
$atendente = $row['nome'];
}else{$atendente = 'Aguardando Atendimento';
}
print "<tr style='background:$cor;' id='linhax".$j."' onMouseOver=\"javascript:this.style.backgroundColor='$destaca'\" onMouseOut=\"javascript:this.style.backgroundColor='$cor'\" onMouseDown=\"marca('linhax".$j."','".$_SESSION['s_colorMarca']."');\">";
print "<TD class='line' ".$valign."><b>$count</TD>";
print "<TD class='line' ".$valign.">".$row['numero']."<br>";
print "<TD class='line' ".$valign.">".$row['abertopor']."<br>";
print "<TD class='line' ".$valign.">$atendente<br>";
print "<TD class='line' ".$valign.">$data<br>";
print "<TD class='line' ".$valign.">".$row['status']."<br>";
$count++;
}
print "</TABLE>";
print "</body>";
print "</html>";
?>
Início 