$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));
}
?>
