Latest posts
-
Hello world!
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!
// Registrar endpoints en la REST API de WordPress add_action('rest_api_init', function () { // Endpoint para GUARDAR un pago register_rest_route('gestor/v1', '/guardar-pago', array( 'methods' => 'POST', 'callback' => 'guardar_pago_base_datos', 'permission_callback' => '__return_true' // Puedes restringir según tus necesidades )); // Endpoint para OBTENER los pagos al cargar la página register_rest_route('gestor/v1', '/obtener-pagos', array( 'methods' => 'GET', 'callback' => 'obtener_pagos_base_datos', 'permission_callback' => '__return_true' )); }); // Función para insertar en la Base de Datos function guardar_pago_base_datos($request) { global $wpdb; $tabla = $wpdb->prefix . 'gestion_pagos'; $params = $request->get_json_params(); $resultado = $wpdb->insert( $tabla, array( 'house_id' => sanitize_text_field($params['houseId']), 'room_number' => sanitize_text_field($params['roomNumber']), 'tenant_name' => sanitize_text_field($params['tenantName']), 'amount' => floatval($params['amount']), 'payment_date' => sanitize_text_field($params['paymentDate']), 'payment_method' => sanitize_text_field($params['paymentMethod']), 'notes' => sanitize_textarea_field($params['notes']) ) ); if ($resultado === false) { return new WP_Error('db_error', 'No se pudo guardar en la base de datos', array('status' => 500)); } return array('success' => true, 'id' => $wpdb->insert_id); } // Función para obtener los registros guardados function obtener_pagos_base_datos() { global $wpdb; $tabla = $wpdb->prefix . 'gestion_pagos'; $resultados = $wpdb->get_results("SELECT * FROM $tabla ORDER BY created_at DESC", ARRAY_A); return $resultados; }
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!