<?php
/*
* Altera<EFBFBD> <EFBFBD> o: 28-04-2016 Mozart: Corre<EFBFBD> <EFBFBD> o nos filtros para "TRANSBORDANDO" E "TRANSBORDADO"
* quando "ABANDON" esta presente que <EFBFBD> caracteristica do transbordo assistido.
*/
$tpLayout = 1;
$ramal = trim($_GET["ramal"]);
if (IsAjax()) {
$order = $_SESSION['order'];
$servidorApi = "127.0.0.1";
$userApi = "sinccontasenha";
$senhaApi = "s3ncC0nt@S2nh@";
$acao = $_GET["acao"];
if (strtoupper($acao) == "DISCAR") {
$numero = trim($_GET["numero"]);
$_SESSION[AGT_NUM_DISC] = $numero;
if (!GetUrl(AST_DISCAR)) {
echo "ERRO";
exit(0);
}
echo "OK";
exit(0);
}
}
$dac = $_GET["dac"];
$tipo = $_GET["origem"];
$diasAbandon = GetDiasAbandonada();
$nomeTpl = 'relDacAbandonadasRet.tpl';
$linha = ' < tr align = "center" >
< td nowrap align = "center" class = "headData" > %s< / td >
< td nowrap align = "center" class = "headData" > %s< / td >
< td nowrap align = "center" class = "headData" > %s< / td >
< td nowrap align = "center" class = "headData" > %s< / td >
< td nowrap align = "center" class = "headData" > %s< / td >
< td nowrap align = "center" class = "headData" > %s< / td >
< / tr > ';
// verifica se a chamada anterior foi classificada para permitir retornar a chamada abandonada.
if ($tipo == "agente") {
$login = GetLogin();
$sql = "select chamada_classificado from pbx_supervisor_agentes where nome = '$login' ";
$result = pg_query($dbcon, $sql);
$param = pg_fetch_array($result);
$classiCham = $param[0];
}
$query = "select b.fila, c.data_bilhete as data, a.abdsr_numero as origem, count(*) as qtde, sum(strtoint(b.param3)) as tempo, max(c.calldate) as ult_abandono
from pbx_abandonadas_semretorno a
inner join ast_eventos_dacs b on b.uid2 = a.abdsr_uniqueid and b.evento = 'ABANDON' and fila = a.abdsr_fila
inner join ast_bilhetes c on c.uniqueid = b.uid2
where a.abdsr_data_hora_retorno is null
and a.abdsr_data >= (now()::date - $diasAbandon)
and a.abdsr_fila = upper('$dac')
group by b.fila, c.data_bilhete, a.abdsr_numero
order by 2;";
//if(IsAdmin()){ echo $query; }
$result = pg_query($dbcon, $query);
$numrow = 0;
$linhas = "";
$duracaoTotal = '';
while ($row = pg_fetch_array($result)) {
$origem = $row["origem"];
$discar = RemoveDddPadrao($origem);
$acao = "< img src = \"imgSite/ramalOn16.png\" border = \"0\" width = \"20\" height = \"20\" alt = \"Retornar Chamada Perdida \ " title = \"Retornar Chamada Perdida \ " > ";
//$linkRamal = "< a href = \"javaScript:DiscarDiretoRet('$origem','$ramal');\" > $acao< / a > ";
$linkRamal = "< a href = \"javaScript:RetornaAbd('$discar');\" > $acao< / a > ";
if ($tipo == "agente")
$linkRamal = ($classiCham < > 0 ) ? $linkRamal : "< img src = \"imgSite/ramalOff16.png\" border = \"0\" width = \"20\" height = \"20\" alt = \"Chamada n <EFBFBD> o classificada \ " title = \"Chamada n <EFBFBD> o classificada \ " > ";
$linhas .= sprintf($linha, FormataDBDataHora($row["data"]), FormataDBDataHora($row["ult_abandono"]), $row["origem"], $row["qtde"], SecondToStrTime($row["tempo"]), $linkRamal);
$duracaoTotal += $row["tempo"];
$numrow++;
}
$duracaoTotal = SecondToStrTime($duracaoTotal);
$linha = " < tr align = \"center\" >
< th nowrap align = \"left\" colspan = \"4\" > Total< / th >
< th nowrap class = \"headData\" > $numrow< / th >
< th nowrap class = \"headData\" > $duracaoTotal< / th >
< / tr > ";
$linhas .= $linha;
$smarty->assign('linhas', $linhas);
GetTemplate($smarty, $nomeTpl);
?>