$conexion = new Connex(); $mysqlconn = $conexion->conectar(); //se capturan los datos del formulario $con_gestor = $_POST['gestor']; $con_numcas = $_POST['numcas']; $con_feulac = $_POST['feulac']; $con_fechac = $_POST['fechac']; $con_asun = $_POST['asun']; $con_estatus = $_POST['estatus']; $con_nomusu = $_POST['nomusu']; $con_estado = $_POST['estado']; $con_numov = $_POST['nummov']; $con_numcontac = $_POST['numcontac']; $con_obserges = $_POST['obserges']; $con_obserusu = $_POST['obserusu']; $con_tipocas = $_POST['tipocas']; require "../modelo/mod_conatel.php"; $registro = new conatel(); $inserto = $registro->agregar($con_gestor, $con_numcas, $con_feulac, $con_asun, $con_estatus, $con_nomusu, $con_estado, $con_numov, $con_numcontac, $con_obserges, $con_obserusu, $con_fechac, $con_tipocas, $mysqlconn); if ($inserto == true) { header("Location: ../vista/registro_conatel.php"); /*$consulta= $registro->obtener($emp_cedula,$mysqlconn); if(mysqli_num_rows($consulta)>0){ $row=mysqli_fetch_row($empleado); header("Location: ../index.php"); } }*/ } else { echo "error en el ingreso de datos"; }
<?php require '../modelo/mod_connex.php'; $conexion = new Connex(); $mysqlconn = $conexion->conectar(); //se capturan los datos del formulario $con_id = $_GET['cas']; $con_feulac = $_POST['con_feulac']; $con_estatus = $_POST['estatus']; $con_obserusu = $_POST['con_obserusu']; $con_obserges = $_POST['con_obserges']; $con_gestor = $_GET['ges']; require "../modelo/mod_conatel.php"; $registro = new conatel(); $inserto = $registro->actualizar($con_id, $con_feulac, $con_estatus, $con_obserusu, $con_obserges, $con_gestor, $mysqlconn); if ($inserto == true) { echo "\n<body>\n\t\t\t\t\t\t<meta http-equiv='content-type' content='text/html; charset=utf-8' />\n\t\t\t\t\t\t\t<link rel='stylesheet' type='text/css' href='../vista/sweetalert/lib/sweet-alert.css'>\n\t\t\t\t\t\t\t<script type='text/javascript' src='../vista/sweetalert/lib/sweet-alert.min.js' ></script>\n\t\t\t\t\t\t\t<script type='text/javascript'>swal({title:'', text:'Registro Actualizado', type: 'success',confirmButtonText:'Cerrar'},function(){window.location.href='../vista/consulta_conatel.php'});\n\t\t\t \t</script>\n</body>"; } else { echo "\n<body>\n\t\t\t\t\t\t<meta http-equiv='content-type' content='text/html; charset=utf-8' />\n\t\t\t\t\t\t\t<link rel='stylesheet' type='text/css' href='../vista/sweetalert/lib/sweet-alert.css'>\n\t\t\t\t\t\t\t<script type='text/javascript' src='../vista/sweetalert/lib/sweet-alert.min.js' ></script>\n\t\t\t\t\t\t\t<script type='text/javascript'>swal({title:'Error!', text:'Registro No Actualizado', type: 'error',confirmButtonText:'Cerrar'},function(){window.location.href='../vista/consulta_conatel.php'});\n\t\t\t \t</script>\n</body>"; }
<?php require '../modelo/mod_connex.php'; $conexion = new Connex(); $mysqlconn = $conexion->conectar(); require "../modelo/mod_conatel.php"; $consulta = new conatel(); $listar = $consulta->obtenercompleto($mysqlconn); if (mysqli_num_rows($listar) > 0) { ?> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <style type="text/css"> <!-- .style2 {color: #000000; font-weight: bold; } .style5 {color: #000000} .style5c {color: #000000; font-size:13px;} --> </style> <table width="580px" border="1" align="left" id="listado"> <thead> <tr> <!--<th align="right">Nombre del Gestor</th>--> <th align="right" bgcolor="#eeece1"><div align="center" class="style2">Caso</div></th> <th align="right" bgcolor="#eeece1"><div align="center" class="style2">Gestor</div></th> <th align="right" bgcolor="#eeece1"><div align="center" class="style2">Fecha Actualización</div></th> <th align="right" bgcolor="#eeece1"><div align="center" class="style2">Asunto</div></th> <!--<th align="right">Canal receptor de la queja</th>--> <th align="right" bgcolor="#eeece1"><div align="center" class="style2">Usuario</div></th> <!--<th align="right">Ciudad de la OC</th> <th align="right">Fecha de Recepción del equipo en la OC</th>-->
<?php session_start(); $_SESSION['emp_login']; $_SESSION['emp_perfil']; $_SESSION['emp_clave']; if (!isset($_SESSION['emp_login'])) { header('Location: index.php'); } else { } $con_numcas = $_POST['con_numcas']; require '../modelo/mod_connex.php'; $conexion = new Connex(); $mysqlconn = $conexion->conectar(); require "../modelo/mod_conatel.php"; $consulta = new conatel(); $listar = $consulta->buscar($con_numcas, $mysqlconn); if (mysqli_num_rows($listar) <= 0) { echo "\n<body>\n\t\t\t\t\t\t<meta http-equiv='content-type' content='text/html; charset=utf-8' />\n\t\t\t\t\t\t\t<link rel='stylesheet' type='text/css' href='sweetalert/lib/sweet-alert.css'>\n\t\t\t\t\t\t\t<script type='text/javascript' src='sweetalert/lib/sweet-alert.min.js' ></script>\n\t\t\t\t\t\t\t<script type='text/javascript'>swal({title:'Error!', text:'No Existen Casos Asociados Al Número Indicado', type: 'error',confirmButtonText:'Cerrar'},function(){window.location.href='../vista/consulta_conatel.php'});\n\t\t\t \t</script>\n</body>"; } else { $row = mysqli_fetch_array($listar, MYSQLI_ASSOC); $con_id = $row["con_id"]; $con_gestor = $row["con_gestor"]; $con_numcas = $row["con_numcas"]; $con_feulac = $row["con_feulac"]; $con_asun = $row["con_asun"]; $con_estatus = $row["con_estatus"]; $con_nomusu = $row["con_nomusu"]; $con_estado = $row["con_estado"]; $con_numov = $row["con_numov"]; $con_numcontac = $row["con_numcontac"];
<?php require '../modelo/mod_connex.php'; $conexion = new Connex(); $mysqlconn = $conexion->conectar(); require "../modelo/mod_conatel.php"; $consulta = new conatel(); $listar = $consulta->obtener($mysqlconn); if (mysqli_num_rows($listar) > 0) { ?> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <style type="text/css"> <!-- .style2 {color: #000000; font-weight: bold; } .style5 {color: #000000} .style5c {color: #000000; font-size:13px;} --> </style> <table width="580px" border="1" align="left" id="listado"> <thead> <tr> <!--<th align="right">Nombre del Gestor</th>--> <th align="right" bgcolor="#eeece1"><div align="center" class="style2">Caso</div></th> <th align="right" bgcolor="#eeece1"><div align="center" class="style2">Gestor</div></th> <th align="right" bgcolor="#eeece1"><div align="center" class="style2">Asunto</div></th> <th align="right" bgcolor="#eeece1"><div align="center" class="style2">Abierto</div></th> <!--<th align="right">Canal receptor de la queja</th>--> <th align="right" bgcolor="#eeece1"><div align="center" class="style2">Actualizado</div></th> <!--<th align="right">Ciudad de la OC</th> <th align="right">Fecha de Recepción del equipo en la OC</th>-->