$conexion = new conexion(); $cont = 0; function codifica($arg) { foreach ($arg as $key => $val) { //$arg[$key] = utf8_decode(htmlentities($val)); $arg[$key] = utf8_encode($val); } return $arg; } if (isset($_GET['leido'])) { $user = $_GET["user"]; $pass = $_GET["pass"]; $existeUser = false; $sql = "SELECT * FROM usuario WHERE u_usuario='{$user}' AND u_passwd='{$pass}'"; $res = $conexion->consultar($sql); if (mysql_num_rows($res) > 0) { $existeUser = true; while ($row = codifica(mysql_fetch_assoc($res))) { $response = array("existeUser" => $existeUser, "leido" => $row["u_manual_leido"], "id" => $row["u_id"]); } } else { $response = array("existeUser" => $existeUser); } echo json_encode($response); } if (isset($_GET['updateLeido'])) { $usuarioId = $_GET["usuarioId"]; echo $sql = "UPDATE usuario SET u_manual_leido = 1 WHERE u_id = {$usuarioId}"; $res = $conexion->consultar($sql); }
$sql = "SELECT * FROM cat_conceptos WHERE cp_cuenta = 2150005"; $res = $conexion->consultar($sql); echo json_encode(codifica(mysql_fetch_assoc($res))); } if (isset($_POST['retISR'])) { $concepto = $_POST["concepto"]; $sql = "SELECT * FROM cat_conceptos WHERE cp_cuenta = 2150103"; $res = $conexion->consultar($sql); echo json_encode(codifica(mysql_fetch_assoc($res))); } if (isset($_POST['descuento'])) { $concepto = $_POST["concepto"]; $sql = "SELECT * FROM cat_conceptos WHERE cp_concepto = 'Descuento'"; $res = $conexion->consultar($sql); echo json_encode(codifica(mysql_fetch_assoc($res))); } if (isset($_POST['IEPS'])) { $concepto = $_POST["concepto"]; $sql = "SELECT * FROM cat_conceptos WHERE cp_concepto = 'IEPS'"; $res = $conexion->consultar($sql); echo json_encode(codifica(mysql_fetch_assoc($res))); } if (isset($_POST['borraFactura'])) { $idFactura = $_POST['idF']; $sql = "DELETE FROM factura \n\t\t\t\tWHERE id_factura = '{$idFactura}'"; $conexion->ejecutar($sql); echo json_encode(array(true)); } ?>