<?php $tipo = $_GET['tipo']; $usuario = $_GET['usuario']; include_once("perfil_funciones.php"); $f=new funciones(); switch($_GET["accion"]){ case "chats": $plantilla=$f->leer_plantilla("formbuskedachats.html"); $optionsagent=$f->qaconsultas("SELECT id_usuario AS id, nombre AS nombre FROM usuario WHERE estado='1' AND id_tipo_usuario='3'","options"); $plantilla=str_replace("{fecha}",$f->fechadehoy(),$plantilla); $plantilla=str_replace("{optionsagent}",$optionsagent,$plantilla); echo $plantilla; break; case "mails": $plantilla=$f->leer_plantilla("formbuskedamails.html"); $optionsagent=$f->qaconsultas("SELECT id_usuario AS id, nombre AS nombre FROM usuario WHERE estado='1' AND id_tipo_usuario='3'","options"); $plantilla=str_replace("{fecha}",$f->fechadehoy(),$plantilla); $plantilla=str_replace("{optionsagent}",$optionsagent,$plantilla); echo $plantilla; break; case "calls": $plantilla=$f->leer_plantilla("formbuskedacalls.html"); $optionsagent=$f->qaconsultas("SELECT id_usuario AS id, nombre AS nombre FROM usuario WHERE estado='1' AND id_tipo_usuario='3'","options");
INSERT INTO qa_calls (id,idAgent,idAdmin,fecha,shift,customerName,polite,performance,english,calledSupervisor,comments,idTeam,id_puntos) VALUES (Null,'$idAgent','$idAdmin','$fecha','$shift','$customerName','$polite','$performance','$english','$calledSupervisor','$comments','$idTeam','$idpunts') "; //$ff->grabardatos($sql); if($ff->grabardatos($sql)){$ff->escribir_archivo("qa/calls/".$idAgent.".txt","w",$idAgent);} include_once("vercalls.php"); break; case "delete": $id=$_POST["iddelete"]; $idcalls=$ff->qaconsultas("SELECT id_puntos AS campo FROM qa_calls WHERE id='$id'","uncampo"); $ff->grabardatos("DELETE FROM qa_calls WHERE id='$id' "); //tabla,nombre ID, valor del Id $ff->borrarId("puntos","id_puntos",$idcalls); include_once("vercalls.php"); break; case "showform_edit": $id=$_POST["idmodify"]; $plantilla=$ff->leer_plantilla("qacalls_edit.html"); $shiftdb=$ff->qaconsultas("SELECT shift AS campo FROM qa_calls WHERE id='$id'","uncampo");
AND idAgent LIKE '%$xagentex%' ORDER BY id DESC "; } elseif($_POST["idcall"]!=""){ $sql="SELECT id AS campo FROM qa_chats WHERE id='".$_POST["idcall"]."'"; } else{ $sql="SELECT id AS campo FROM qa_calls WHERE DATE(fecha)='$fecha' ORDER BY id DESC"; } //////////////////////////////// Chats ////////////////////////////////////// $ids=$ff->qaconsultas($sql,"ids"); $total=count($ids); $ultimo=$ids[$total-1]; for($x=0;$x<$total;$x++){ $id=$ids[$x]; $consultacalls="AS campo FROM qa_calls WHERE id='$id' "; //$consultacalls="AS campo FROM qa_calls WHERE fecha='$fecha' AND shift='$idshift' AND idAgent='$idagent'"; $callcustomer=$ff->qaconsultas("SELECT customerName $consultacalls","uncampo"); $polite=$ff->qaconsultas("SELECT polite $consultacalls","uncampo"); $performance=$ff->qaconsultas("SELECT performance $consultacalls","uncampo"); $english=$ff->qaconsultas("SELECT english $consultacalls","uncampo"); $supervisor=$ff->qaconsultas("SELECT calledSupervisor $consultacalls","uncampo"); $callscomments=$ff->qaconsultas("SELECT comments $consultacalls","uncampo");
if($_POST["xagentex"]!="" && $_POST["fechainicio"]!="" && $_POST["fechafin"]!="" && $_POST["xagentex"]!=""){ $sql=" SELECT id AS campo FROM qa_emails WHERE DATE(fecha) BETWEEN '$fechainicio' AND '$fechafin' AND shift='$xshiftx' AND idAgent LIKE '%$xagentex%' ORDER BY id DESC "; } else{ $sql="SELECT id AS campo FROM qa_emails WHERE DATE(fecha)='$fecha' ORDER BY id DESC"; } //////////////////////////////// mails ////////////////////////////////////// $ids=$ff->qaconsultas($sql,"ids"); $total=count($ids); $ultimo=$ids[$total-1]; for($x=0;$x<$total;$x++){ $id=$ids[$x]; $consultaemails="AS campo FROM qa_emails WHERE id='$id' "; $emailteam=$ff->qaconsultas("SELECT team $consultaemails","uncampo"); $emailteam=$ff->qaconsultas("SELECT team AS campo FROM teams WHERE id_team='$emailteam'","uncampo"); $emailcustomer=$ff->qaconsultas("SELECT customerName $consultaemails","uncampo"); $emailemail=$ff->qaconsultas("SELECT email $consultaemails","uncampo"); $emailcomments=$ff->qaconsultas("SELECT comments $consultaemails","uncampo"); $given=$ff->qaconsultas("SELECT answerGiven $consultaemails","uncampo"); $correct=$ff->qaconsultas("SELECT correctAnswer $consultaemails","uncampo");
$ff->grabardatos($sql); include_once("vermails.php"); break; case "delete": $id=$_POST["iddelete"]; $ff->grabardatos("DELETE FROM qa_emails WHERE id='$id'"); include_once("vermails.php"); break; case "showform_edit": $id=$_POST["idmodify"]; $plantilla=$ff->leer_plantilla("qamails_edit.html"); $consulta="AS campo FROM qa_emails WHERE id='$id'"; $idAgent=$ff->qaconsultas("SELECT idAgent $consulta","uncampo"); $fecha=$ff->qaconsultas("SELECT fecha $consulta","uncampo"); $shift=$ff->qaconsultas("SELECT shift $consulta","uncampo"); $customerName=$ff->qaconsultas("SELECT customerName $consulta","uncampo"); $email=$ff->qaconsultas("SELECT email $consulta","uncampo"); $comments=$ff->qaconsultas("SELECT comments $consulta","uncampo"); $answerGiven=$ff->qaconsultas("SELECT answerGiven $consulta","uncampo"); $correctAnswer=$ff->qaconsultas("SELECT correctAnswer $consulta","uncampo"); $shiftdb=$ff->qaconsultas("SELECT shift $consulta","uncampo"); $idselected=$ff->qaconsultas("SELECT idAgent $consulta","uncampo"); $optionsagent=$ff->qaconsultas("SELECT id_usuario AS id, nombre AS nombre FROM usuario WHERE id_tipo_usuario='3' AND estado='1' ","options"); $idselected=$ff->qaconsultas("SELECT team $consulta","uncampo"); $optionsteam=$ff->qaconsultas("SELECT id_team AS id, team AS nombre FROM teams ","options");
<?php $tipo = $_GET['tipo']; $usuario = $_GET['usuario']; include ("validar.php"); include ("header.php"); $transaccion = $_GET['transaccion']; include_once("perfil_funciones.php"); $f=new funciones(); $idshift=$_POST["shift"]; $fecha=$_POST["year"]."-".$_POST["mes"]."-".$_POST["dia"]; $agent=$f->qaconsultas("SELECT nombre AS campo FROM usuario WHERE login='******'","uncampo"); $agent.=" ".$f->qaconsultas("SELECT 1erApellido AS campo FROM usuario WHERE login='******'","uncampo"); $idagent=$f->id_usuario($usuario); $shift=$f->qaconsultas("SELECT hora_inicio AS campo FROM shift WHERE id_shift='".$idshift."'","uncampo"); function return_chats($id){ global $f; $consulta="AS campo FROM qa_chats WHERE id='$id'"; $chatcustomer=$f->qaconsultas("SELECT customerName $consulta","uncampo"); $email=$f->qaconsultas("SELECT emailAddress $consulta","uncampo"); $wait=$f->qaconsultas("SELECT waitTime $consulta","uncampo"); $duration=$f->qaconsultas("SELECT duration $consulta","uncampo"); $chatcomments=$f->qaconsultas("SELECT comments $consulta","uncampo"); $chatby=$f->qaconsultas("SELECT idAdmin $consulta","uncampo"); $chatby=$f->qaconsultas("SELECT nombre AS campo FROM usuario WHERE id_usuario='$chatby'","uncampo");
AND idAgent LIKE '%$xagentex%' ORDER BY id DESC "; } elseif($_POST["idchat"]!=""){ $sql="SELECT id AS campo FROM qa_chats WHERE id='".$_POST["idchat"]."'"; } else{ $sql="SELECT id AS campo FROM qa_chats WHERE DATE(fecha)='$fecha' ORDER BY id DESC"; } //////////////////////////////// Chats ////////////////////////////////////// $ids=$ff->qaconsultas($sql,"ids"); $total=count($ids); $ultimo=$ids[$total-1]; for($x=0;$x<$total;$x++){ $id=$ids[$x]; $consulta="AS campo FROM qa_chats WHERE id='$id' "; $chatcustomer=$ff->qaconsultas("SELECT customerName $consulta","uncampo"); $email=$ff->qaconsultas("SELECT emailAddress $consulta","uncampo"); $wait=$ff->qaconsultas("SELECT waitTime $consulta","uncampo"); $duration=$ff->qaconsultas("SELECT duration $consulta","uncampo"); $chatcomments=$ff->qaconsultas("SELECT comments $consulta","uncampo"); $chatby=$ff->qaconsultas("SELECT idAdmin $consulta","uncampo"); $chatby=$ff->qaconsultas("SELECT nombre AS campo FROM usuario WHERE id_usuario='$chatby'","uncampo");
$sql=" INSERT INTO qa_chats(id,idAgent,idAdmin,fecha,shift,customerName,emailAddress,waitTime,comments,idTeam,duration,id_puntos) VALUES (Null,'$idAgent','$idAdmin','$fecha','$shift','$customerName','$emailAddress','$waitTime','$comments','$idTeam','$duration','$idpunts')"; if($ff->grabardatos($sql)){$ff->escribir_archivo("qa/chats/".$idAgent.".txt","w",$idAgent);} include_once("verchats.php"); break; case "delete": $id=$_POST["iddelete"]; $idchat=$ff->qaconsultas("SELECT id_puntos AS campo FROM qa_chats WHERE id='$id'","uncampo"); $ff->grabardatos("DELETE FROM qa_chats WHERE id='$id' "); // borrar puntos cuando se borra un registro de chat // nombre de la tabla, nombre del campo (id), valor $ff->borrarId("puntos","id_puntos",$idchat); include_once("verchats.php"); break; case "showform_edit": $id=$_POST["idmodify"]; $plantilla=$ff->leer_plantilla("qachats_edit.html");