//$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"); $politedb=$ff->qaconsultas("SELECT polite AS campo FROM qa_calls WHERE id='$id'","uncampo"); $supervisordb=$ff->qaconsultas("SELECT calledSupervisor AS campo FROM qa_calls WHERE id='$id'","uncampo"); $performancedb=$ff->qaconsultas("SELECT performance AS campo FROM qa_calls WHERE id='$id'","uncampo"); $englishdb=$ff->qaconsultas("SELECT english AS campo FROM qa_calls WHERE id='$id'","uncampo");
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"); $fecha=$ff->qaconsultas("SELECT DATE(fecha) AS campo FROM qa_chats WHERE id='$id'","uncampo"); $shiftdb=$ff->qaconsultas("SELECT shift AS campo FROM qa_chats WHERE id='$id'","uncampo"); $idselected=$ff->qaconsultas("SELECT idTeam AS campo FROM qa_chats WHERE id='$id'","uncampo");