GesDix

Escriba su nombre de usuario y contraseña para iniciar sesión

He olvidado mi contraseña
#1kernel::init2ms67.52kb
#2plugins::init332ms4.74mb
#3kernel::run72ms828.9kb
#1Memory usage5.99mb
#2Memory peak6.1mb
#1StatusConnected
#2Typemysql
#3Version11.8.9-MariaDB-deb11-log
/Plugins/PmsManager/Assets/JS/pms-unread-messages.js?v=1
/Plugins/PmsManager/Assets/JS/pms-hostel-terminology.js?v=03-10-2026
https://cdn.jsdelivr.net/npm/qz-tray@2.2.5/qz-tray.js
#1debugSHOW COLUMNS FROM `dix_salones`;0.3ms
#2debugSHOW COLUMNS FROM `dix_estado`;0.2ms
#3debugSHOW COLUMNS FROM `dix_tipo_mesa`;
#4debugSHOW COLUMNS FROM `dix_tarifas`;0.2ms
#5debugSHOW COLUMNS FROM `dix_mesa`;0.5ms
#6debugSHOW COLUMNS FROM `dix_comanda`;0.5ms
#7debugSHOW COLUMNS FROM `dix_details_comanda`;0.5ms
#8debugSHOW COLUMNS FROM `dix_reservas`;0.4ms
#9debugSHOW COLUMNS FROM `dixtpv`;0.6ms
#10debugSHOW COLUMNS FROM `dixtpv_cajas`;0.4ms
#11debugSHOW COLUMNS FROM `dixtpv_movimientos`;0.4ms
#12debugSHOW COLUMNS FROM `dix_productos_resumen`;0.4ms
#13debugSHOW COLUMNS FROM `dix_tipo_iva_resumen`;0.4ms
#14debugSHOW COLUMNS FROM `dix_formas_pago_resumen`;0.4ms
#15debugSHOW COLUMNS FROM `dix_comanderos`;0.4ms
#16debugSHOW COLUMNS FROM `dix_listafins`;0.4ms
#17debugSHOW COLUMNS FROM `dixtpv_productosextras`;0.4ms
#18debugSHOW COLUMNS FROM `dix_albaranes_caja`;0.4ms
#19debugSHOW COLUMNS FROM `dix_pedidos_caja`;0.4ms
#20debugSHOW COLUMNS FROM `dix_details_comanda`;0.4ms
#21debugSHOW COLUMNS FROM `dix_details_comanda`;0.4ms
#22debugSHOW COLUMNS FROM `dix_details_comanda`;0.4ms
#23debugSHOW COLUMNS FROM `dix_mesa`;0.5ms
#24debugSHOW COLUMNS FROM `dixtpv`;0.6ms
#25debugSHOW COLUMNS FROM `dix_comanda`;0.4ms
#26debugSHOW COLUMNS FROM `dixtpv`;0.6ms
#27debugSHOW COLUMNS FROM `dixtpv`;0.6ms
#28debugSHOW COLUMNS FROM `dixtpv`;0.6ms
#29debugSHOW COLUMNS FROM `dixtpv`;0.6ms
#30debugSHOW COLUMNS FROM `dixtpv`;0.6ms
#31debugSHOW COLUMNS FROM `productos`;0.5ms
#32debugSHOW COLUMNS FROM `productos`;0.5ms
#33debugSHOW COLUMNS FROM `familias`;0.4ms
#34debugSHOW COLUMNS FROM `dixtpv`;0.6ms
#35debugSHOW COLUMNS FROM `dix_cashdro_operations`;0.4ms
#36debugSHOW COLUMNS FROM `dix_cashdro_devices`;0.4ms
#37debugSELECT * FROM `pages_options` WHERE `name` = 'EditFormaPago'0.3ms
#38debugSHOW COLUMNS FROM `pages_options`;0.4ms
#39debugSELECT * FROM dix_tipo_mesa
#40debugSHOW COLUMNS FROM `clientes`;0.5ms
#41debugSELECT * FROM `pages_options` WHERE `name` = 'EditCliente'
#42debugSHOW COLUMNS FROM `cp_clases_peligro`;0.4ms
#43debugSHOW COLUMNS FROM `cp_cartas_portes`;0.4ms
#44debugSHOW COLUMNS FROM `cp_embalajes`;0.4ms
#45debugSHOW COLUMNS FROM `cp_numeros_onu`;0.4ms
#46debugSHOW COLUMNS FROM `cp_porteadores`;0.5ms
#47debugSHOW COLUMNS FROM `cp_productos`;0.4ms
#48debugSHOW COLUMNS FROM `cp_vehiculos`;0.4ms
#49debugSHOW COLUMNS FROM `cp_productos_carta_portes`;0.4ms
#50debugSHOW COLUMNS FROM `settings`;0.4ms
#51debugSELECT * FROM `settings` WHERE `name` = 'pmsmanager_persistent' LIMIT 1 OFFSET 0;
#52debugSELECT * FROM `settings` WHERE `name` = 'pmsmanager' LIMIT 1 OFFSET 0;
#53debugSELECT * FROM `settings` WHERE `name` = 'pmsmanager' LIMIT 1 OFFSET 0;
#54debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'pmsmanager_persistent' LIMIT 1 OFFSET 0;
#55debugBegin Transaction
#56debugUPDATE `settings` SET `name` = 'pmsmanager_persistent', `properties` = '{\"twig_hash_pmsscheduler\":\"7b2eddd6d3d7474acba2abd0f3451581\",\"guest_portal_enabled\":\"1\",\"guest_portal_allow_contact_edit\":\"1\",\"guest_portal_allow_cancellation\":\"1\",\"municipality_seed_version\":\"ine_codmun_2026\",\"stable_room_order_version\":\"1\",\"overbooking_marker_version\":\"1\",\"channex_api_key\":\"\",\"backup_channex_api_key\":\"\",\"channex_webhook_token\":\"\",\"backup_channex_webhook_token\":\"\",\"seeded\":true,\"portal_title\":\"Reserva tu estancia\",\"portal_instructions\":\"Elige las fechas de entrada y salida para comprobar disponibilidad en tiempo real.\",\"portal_success\":\"Hemos recibido tu solicitud y te confirmaremos cuanto antes.\",\"portal_primary_color\":\"#2563EB\",\"portal_accent_color\":\"#F97316\",\"portal_background_color\":\"#F8FAFC\",\"portal_payment_mode\":\"redsys\",\"portal_charge_policy\":\"now\",\"portal_deposit_percent\":\"100\",\"portal_rate_adjustment_type\":\"percent_increase\",\"portal_rate_adjustment_value\":\"10\",\"portal_allowed_frame_origins\":\"\",\"portal_card_payment_code\":\"TARJETA\",\"calendar_last_seen_fiz\":\"2026-08-24 11:13:14\",\"calendar_last_seen_hadrian\":\"2026-09-15 08:17:15\",\"auto_arrival_enabled\":\"0\",\"calendar_last_seen_dario\":\"2026-07-31 12:02:28\",\"default_status\":\"pending\",\"portal_woo_api_url\":\"\",\"portal_woo_consumer_key\":\"\",\"portal_woo_consumer_secret\":\"\",\"ses_environment\":null,\"ses_test_property\":\"0\",\"ses_help\":\"\",\"channex_environment\":null,\"channex_base_url\":\"https://staging.channex.io/api/v1\",\"channex_ota_name\":\"Offline\",\"channex_min_interval_ms\":\"200\",\"channex_test_property\":\"0\",\"ota_reservations_paid\":null,\"channex_messages_enabled\":\"Sí\",\"invoice_series\":null,\"invoice_tax\":null,\"checkin_scan_enabled\":\"Sí\",\"housekeeping_enabled\":null,\"seam_enabled\":\"Sí\",\"seam_api_key\":\"seam_test32XE_BTadYcXEkxwbfkEm5KBExBRF\",\"seam_code_length\":\"4\",\"seam_base_url\":\"https://connect.getseam.com\",\"backup_seam_api_key\":\"seam_test32XE_BTadYcXEkxwbfkEm5KBExBRF\",\"seam_help\":null,\"seam_webhook_secret\":\"whsec_JoswzdvxvCa/BrNdJOhzlWQonCU37BLa\",\"dixtpv_sync_enabled\":\"Sí\",\"property_mode\":\"single\",\"portal_tpv_protocol\":null,\"portal_redsys_tpv_id\":null,\"gestorpms_reservations_enabled\":\"1\",\"gestorpms_cleaning_enabled\":\"1\",\"gestorpms_settlements_enabled\":\"0\",\"gestorpms_messages_enabled\":\"1\"}' WHERE `name` = 'pmsmanager_persistent'0.2ms
#57debugCommit Transaction
#58debugSELECT * FROM `settings`
#59debugSHOW COLUMNS FROM `pms_properties`;0.6ms
#60debugSHOW COLUMNS FROM `pms_rooms`;0.5ms
#61debugSHOW COLUMNS FROM `pms_room_components`;0.4ms
#62debugSHOW COLUMNS FROM `pms_room_rates`;0.6ms
#63debugSHOW COLUMNS FROM `pms_reservations`;0.5ms
#64debugSHOW COLUMNS FROM `pms_reservation_guests`;0.5ms
#65debugSHOW COLUMNS FROM `pms_reservation_payments`;0.4ms
#66debugSHOW COLUMNS FROM `pms_reservation_charges`;0.4ms
#67debugSHOW COLUMNS FROM `pms_reservation_statuses`;0.4ms
#68debugSHOW COLUMNS FROM `pms_ses_logs`;0.4ms
#69debugSHOW COLUMNS FROM `pms_reservation_history`;0.4ms
#70debugSHOW COLUMNS FROM `pms_guest_portal_access`;0.5ms
#71debugSHOW COLUMNS FROM `pms_room_units`;0.5ms
#72debugUPDATE pms_room_units u JOIN pms_rooms r ON u.idroom = r.id SET u.idproperty = r.idproperty WHERE u.idproperty IS NULL OR u.idproperty = 00.3ms
#73debugSHOW COLUMNS FROM `pms_device_tokens`;0.5ms
#74debugSHOW COLUMNS FROM `pms_channex_message_watermarks`;0.4ms
#75debugSHOW COLUMNS FROM `pms_push_log`;0.4ms
#76debugSELECT * FROM `pms_reservation_statuses` WHERE `code` = 'pending' LIMIT 1 OFFSET 0;
#77debugSELECT * FROM `pms_reservation_statuses` WHERE `code` = 'confirmed' LIMIT 1 OFFSET 0;
#78debugSELECT * FROM `pms_reservation_statuses` WHERE `code` = 'cancelled' LIMIT 1 OFFSET 0;
#79debugSELECT * FROM `pms_reservation_statuses` WHERE `code` = 'check-in' LIMIT 1 OFFSET 0;
#80debugSELECT * FROM `pms_reservation_statuses` WHERE `code` = 'arrival' LIMIT 1 OFFSET 0;
#81debugSELECT * FROM `pms_reservation_statuses` WHERE `code` = 'check-out' LIMIT 1 OFFSET 0;
#82debugSELECT * FROM `pms_rooms` ORDER BY `id` ASC
#83debugSELECT COUNT(*) as _count FROM `pms_room_units` WHERE `idroom` = '24' LIMIT 1 OFFSET 0;
#84debugSELECT COUNT(*) as _count FROM `pms_room_units` WHERE `idroom` = '25' LIMIT 1 OFFSET 0;
#85debugSELECT COUNT(*) as _count FROM `pms_room_units` WHERE `idroom` = '26' LIMIT 1 OFFSET 0;
#86debugSELECT COUNT(*) as _count FROM `pms_room_units` WHERE `idroom` = '28' LIMIT 1 OFFSET 0;
#87debugSELECT COUNT(*) as _count FROM `pms_room_units` WHERE `idroom` = '31' LIMIT 1 OFFSET 0;
#88debugSELECT COUNT(*) as _count FROM `pms_room_units` WHERE `idroom` = '32' LIMIT 1 OFFSET 0;
#89debugSELECT COUNT(*) as _count FROM `pms_room_units` WHERE `idroom` = '34' LIMIT 1 OFFSET 0;
#90debugSELECT COUNT(*) as _count FROM `pms_room_units` WHERE `idroom` = '35' LIMIT 1 OFFSET 0;
#91debugSELECT COUNT(*) as _count FROM `pms_room_units` WHERE `idroom` = '36' LIMIT 1 OFFSET 0;
#92debugSELECT COUNT(*) as _count FROM `pms_room_units` WHERE `idroom` = '78' LIMIT 1 OFFSET 0;
#93debugSELECT COUNT(*) as _count FROM `pms_room_units` WHERE `idroom` = '79' LIMIT 1 OFFSET 0;
#94debugSELECT COUNT(*) as _count FROM `pms_room_units` WHERE `idroom` = '80' LIMIT 1 OFFSET 0;
#95debugSHOW COLUMNS FROM `pms_room_rates`;0.6ms
#96debugSHOW COLUMNS FROM `pms_room_rates`;0.6ms
#97debugSHOW COLUMNS FROM `pms_room_rates`;0.6ms
#98debugSHOW COLUMNS FROM `pms_room_rates`;0.5ms
#99debugSHOW COLUMNS FROM `pms_room_rates`;0.5ms
#100debugSHOW COLUMNS FROM `pms_room_rates`;0.5ms
#101debugSHOW COLUMNS FROM `pms_room_rates`;0.6ms
#102debugSHOW COLUMNS FROM `pms_room_rates`;0.5ms
#103debugSHOW COLUMNS FROM `pms_room_rates`;0.5ms
#104debugSHOW COLUMNS FROM `pms_room_rates`;0.5ms
#105debugSHOW COLUMNS FROM `pms_room_rates`;0.6ms
#106debugSHOW COLUMNS FROM `pms_room_rates`;0.6ms
#107debugSHOW COLUMNS FROM `pms_room_blocks`;0.4ms
#108debugSHOW COLUMNS FROM `pms_reservations`;0.5ms
#109debugSHOW COLUMNS FROM `pms_reservations`;0.5ms
#110debugSHOW COLUMNS FROM `pms_rooms`;0.4ms
#111debugSHOW COLUMNS FROM `pms_room_units`;0.4ms
#112debugUPDATE pms_reservations SET channex_updated_at = COALESCE(updated_at, created_at) WHERE channex_updated_at IS NULL AND channex_booking_id IS NOT NULL AND channex_booking_id <> ''0.3ms
#113debugSHOW COLUMNS FROM `pms_room_blocks`;0.4ms
#114debugSELECT * FROM `pms_room_blocks` WHERE `idparentblock` IS NULL ORDER BY `id` ASC0.2ms
#115debugSELECT * FROM `pms_room_units` WHERE `id` = '16' LIMIT 1 OFFSET 0;
#116debugSELECT * FROM `pms_rooms` WHERE `id` = '35' LIMIT 1 OFFSET 0;
#117debugSELECT * FROM `pms_room_blocks` WHERE `idparentblock` = '16' ORDER BY `id` ASC
#118debugSELECT * FROM `pms_room_units` WHERE `id` = '14' LIMIT 1 OFFSET 0;
#119debugSELECT * FROM `pms_rooms` WHERE `id` = '34' LIMIT 1 OFFSET 0;
#120debugSELECT * FROM `pms_room_components` WHERE `idroom` = '34' ORDER BY `id` ASC
#121debugSELECT * FROM `pms_room_units` WHERE `id` = '10' LIMIT 1 OFFSET 0;
#122debugSELECT * FROM `pms_room_blocks` WHERE `idparentblock` = '17' ORDER BY `id` ASC
#123debugSELECT * FROM `pms_room_blocks` WHERE `idroomunit` = '10' AND `checkin` < '2026-11-26 00:00:00' AND `checkout` > '2026-11-25 00:00:00' ORDER BY `id` ASC
#124debugSELECT COUNT(*) as _count FROM `pms_room_blocks` WHERE `id` = '32' LIMIT 1 OFFSET 0;
#125debugUPDATE `pms_room_blocks` SET `id` = '32', `idroomunit` = '10', `idreservation` = NULL, `checkin` = '2026-11-25 00:00:00', `checkout` = '2026-11-26 00:00:00', `reason` = 'CM validation migrated to main unit only · bloqueo compuesto #17', `active` = TRUE, `channex_task_id` = '', `idparentblock` = '17' WHERE `id` = '32'
#126debugSELECT * FROM `pms_room_units` WHERE `id` = '14' LIMIT 1 OFFSET 0;
#127debugSELECT * FROM `pms_rooms` WHERE `id` = '34' LIMIT 1 OFFSET 0;
#128debugSELECT * FROM `pms_room_blocks` WHERE `idparentblock` = '30' ORDER BY `id` ASC
#129debugSELECT * FROM `pms_room_blocks` WHERE `idroomunit` = '10' AND `checkin` < '2026-06-20 12:00:00' AND `checkout` > '2026-06-19 15:00:00' ORDER BY `id` ASC
#130debugSELECT COUNT(*) as _count FROM `pms_room_blocks` WHERE `id` = '33' LIMIT 1 OFFSET 0;
#131debugUPDATE `pms_room_blocks` SET `id` = '33', `idroomunit` = '10', `idreservation` = NULL, `checkin` = '2026-06-19 15:00:00', `checkout` = '2026-06-20 12:00:00', `reason` = 'Bloqueo compuesto #30', `active` = TRUE, `channex_task_id` = '', `idparentblock` = '30' WHERE `id` = '33'
#132debugSELECT * FROM `pms_reservations` WHERE `idroomunit` IS NULL AND `overbooking_warning` = FALSE AND `status` NOT IN ('cancelled','canceled','cancelado','cancelada','anulado','anulada') ORDER BY `id` ASC0.3ms
#133debugSELECT * FROM `pms_reservations` ORDER BY `id` ASC
#134debugSELECT * FROM `pms_reservation_guests` WHERE `idreservation` = '39' ORDER BY `id` ASC
#135debugSELECT * FROM `pms_reservation_guests` WHERE `idreservation` = '40' ORDER BY `id` ASC
#136debugSELECT * FROM `pms_reservation_guests` WHERE `idreservation` = '41' ORDER BY `id` ASC
#137debugSELECT * FROM `pms_reservation_guests` WHERE `idreservation` = '43' ORDER BY `id` ASC
#138debugSELECT * FROM `pms_reservation_guests` WHERE `idreservation` = '46' ORDER BY `id` ASC
#139debugSHOW COLUMNS FROM `facturascli`;0.5ms
#140debugSHOW COLUMNS FROM `facturasprov`;0.3ms
#141debugSHOW COLUMNS FROM `modrrhh_employeegroups`;0.3ms
#142debugSHOW COLUMNS FROM `modrrhh_employeegroup_members`;0.3ms
#143debugSHOW COLUMNS FROM `modrrhh_publicholiday_groups`;0.2ms
#144debugSHOW COLUMNS FROM `rrhh_employees`;0.3ms
#145debugSHOW COLUMNS FROM `rrhh_employees`;0.3ms
#146debugSHOW COLUMNS FROM `rrhh_employeesholidays`;0.3ms
#147debugSHOW COLUMNS FROM `rrhh_employeesholidays`;0.3ms
#148debugSHOW COLUMNS FROM `rrhh_employeesworkperiods`;0.2ms
#149debugSHOW COLUMNS FROM `modrrhh_shifts`;0.3ms
#150debugSHOW COLUMNS FROM `modrrhh_shiftassignments`;0.2ms
#151debugSHOW COLUMNS FROM `modrrhh_shiftrules`;0.2ms
#152debugSHOW COLUMNS FROM `modrrhh_shiftassignments`;0.2ms
#153debugSHOW INDEXES FROM modrrhh_shiftassignments;
#154debugSHOW COLUMNS FROM `modrrhh_shifts`;0.2ms
#155debugSHOW COLUMNS FROM `rrhh_employeescourses`;0.3ms
#156debugSHOW COLUMNS FROM `rrhh_employeescourses`;0.2ms
#157debugSELECT id FROM rrhh_absencesconcepts WHERE LOWER(name) = LOWER('Curso de formación') LIMIT 1
#158debugSHOW COLUMNS FROM `trabajos`;0.4ms
#159debugSHOW COLUMNS FROM `tipo_tarea`;0.2ms
#160debugSHOW COLUMNS FROM `tipo_trabajo`;0.2ms
#161debugSELECT COUNT(*) AS total FROM roles_access WHERE pagename = 'EditCliente' AND onlyownerdata = 1
#162debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = '__empty_settings_backup_20260507_090805' LIMIT 1 OFFSET 0;
#163debugUPDATE `settings` SET `name` = '__empty_settings_backup_20260507_090805', `properties` = '{\"openai_api_key\":\"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\",\"openai_model\":\"gpt-4.1-mini\",\"webhook_token\":\"\",\"whatsapp_enabled\":\"1\",\"email_enabled\":\"1\",\"auto_send_checkin\":\"1\",\"system_prompt\":\"Eres un asistente de recepcion para alojamientos. Responde breve, claro y solo sobre reservas, check-in y cambios basicos.\"}' WHERE `name` = '__empty_settings_backup_20260507_090805'
#164debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'AiScan' LIMIT 1 OFFSET 0;
#165debugUPDATE `settings` SET `name` = 'AiScan', `properties` = '{\"enabled\":\"1\",\"default_provider\":\"openai\",\"max_upload_size_mb\":\"10\",\"allowed_extensions\":\"pdf,jpg,jpeg,png,webp\",\"auto_scan\":\"0\",\"debug_mode\":\"\",\"max_parallel_requests\":\"5\",\"request_timeout\":\"120\",\"openai_model\":\"gpt-5-nano\",\"openai_base_url\":\"https://api.openai.com/v1\",\"gemini_model\":\"gemini-2.5-flash-lite\",\"mistral_model\":\"mistral-small-latest\",\"openai_api_key\":\"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\",\"gemini_api_key\":\"\",\"mistral_api_key\":\"\",\"custom_api_key\":\"\",\"custom_model\":\"\",\"custom_base_url\":\"\",\"additional_prompt\":\"\"}' WHERE `name` = 'AiScan'
#166debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'aloxameia' LIMIT 1 OFFSET 0;
#167debugUPDATE `settings` SET `name` = 'aloxameia', `properties` = '{\"enabled\":\"1\",\"model\":\"gpt-5-mini\",\"instructions\":\"\"}' WHERE `name` = 'aloxameia'
#168debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'aloxamesimple' LIMIT 1 OFFSET 0;
#169debugUPDATE `settings` SET `name` = 'aloxamesimple', `properties` = '{\"pms_backup_channex_api_key\":\"\",\"pms_backup_channex_webhook_token\":\"\",\"pms_backup_seam_api_key\":\"\"}' WHERE `name` = 'aloxamesimple'
#170debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'analiticasaloxame' LIMIT 1 OFFSET 0;
#171debugUPDATE `settings` SET `name` = 'analiticasaloxame', `properties` = '{\"page_version\":\"2\"}' WHERE `name` = 'analiticasaloxame'
#172debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'anticipos' LIMIT 1 OFFSET 0;
#173debugUPDATE `settings` SET `name` = 'anticipos', `properties` = '{\"pdAnticipos\":true,\"level\":20}' WHERE `name` = 'anticipos'
#174debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'citas' LIMIT 1 OFFSET 0;
#175debugUPDATE `settings` SET `name` = 'citas', `properties` = '{\"duration\":60,\"patron\":\"CITA{ANYO}-{0NUM}\",\"longnumero\":1}' WHERE `name` = 'citas'
#176debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'default' LIMIT 1 OFFSET 0;
#177debugUPDATE `settings` SET `name` = 'default', `properties` = '{\"codpais\":\"ESP\",\"currency_position\":\"right\",\"item_limit\":50,\"decimals\":2,\"decimal_separator\":\",\",\"thousands_separator\":\" \",\"codalmacen\":null,\"coddivisa\":null,\"codpago\":null,\"enable_api\":true,\"telemetryinstall\":null,\"idempresa\":1,\"codserie\":null,\"finofertadays\":null,\"codretencion\":null,\"tipoidfiscal\":null,\"decimales\":2,\"codimpuesto\":null,\"ventasinstock\":false,\"autobatchserialsales\":false,\"taxcalculationmethod\":\"classic\",\"autogenbarcodes\":false,\"columnetosubtotal\":\"subtotal\"}' WHERE `name` = 'default'
#178debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'dixtpvbonos' LIMIT 1 OFFSET 0;
#179debugUPDATE `settings` SET `name` = 'dixtpvbonos', `properties` = '{\"nombre_bono\":\"Bar Reynolds\"}' WHERE `name` = 'dixtpvbonos'
#180debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'email' LIMIT 1 OFFSET 0;
#181debugUPDATE `settings` SET `name` = 'email', `properties` = '{\"enc\":\"ssl\",\"host\":\"smtp.gmail.com\",\"mailer\":\"smtp\",\"port\":\"465\",\"email\":\"fizdixome@gmail.com\",\"password\":\"mxmb yynv ovhx wrjk\",\"idlogo\":null,\"signature\":\"\",\"user\":\"\",\"authtype\":\"\",\"lowsecure\":\"\",\"replytouseremail\":\"1\",\"emailcc\":\"\",\"emailbcc\":\"\",\"name\":\"\"}' WHERE `name` = 'email'
#182debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'formacionia' LIMIT 1 OFFSET 0;
#183debugUPDATE `settings` SET `name` = 'formacionia', `properties` = '{\"api_key\":\"sk-00e9cb90999b4bab901ea2a649dc4f7d\",\"daily_limit\":\"100\",\"embedding_model\":\"deepseek-embed\",\"chat_model\":\"deepseek-chat\"}' WHERE `name` = 'formacionia'
#184debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'gesdix' LIMIT 1 OFFSET 0;
#185debugUPDATE `settings` SET `name` = 'gesdix', `properties` = '{\"invoice-creation-date-backfill\":\"1\",\"purchase-invoice-creation-date-backfill\":\"1\"}' WHERE `name` = 'gesdix'
#186debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'GesDixAI' LIMIT 1 OFFSET 0;
#187debugUPDATE `settings` SET `name` = 'GesDixAI', `properties` = '{\"enabled\":\"1\",\"model\":\"gpt-5-mini\",\"additional_instructions\":\"\",\"max_output_tokens\":\"2048\",\"daily_request_limit\":\"200\",\"request_timeout\":\"60\",\"provider\":\"openai\",\"model_choice\":\"gpt-5-mini\",\"custom_model\":\"\"}' WHERE `name` = 'GesDixAI'
#188debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'gesdixonboarding' LIMIT 1 OFFSET 0;
#189debugUPDATE `settings` SET `name` = 'gesdixonboarding', `properties` = '{\"completed\":\"1\",\"installation_key\":\"\"}' WHERE `name` = 'gesdixonboarding'
#190debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'informeine' LIMIT 1 OFFSET 0;
#191debugUPDATE `settings` SET `name` = 'informeine', `properties` = '{\"enabled\":\"1\",\"idproperty\":\"4\",\"survey_type\":\"EOAL\",\"official_places\":\"0\",\"establishment_code\":\"\"}' WHERE `name` = 'informeine'
#192debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'modcitassms' LIMIT 1 OFFSET 0;
#193debugUPDATE `settings` SET `name` = 'modcitassms', `properties` = '{\"twilio_sid\":\"AC98765330a6134c52c9288f554c66a3c0\",\"twilio_token\":\"1920ab27c9f0df54601f874b3302297c\",\"twilio_from\":\"+19892671907\",\"reminder_minutes\":\"5\",\"default_warehouse\":\"ALG\",\"default_state_id\":\"1\",\"portal_state_id\":\"1\",\"confirm_message\":\"Tu cita para el %FECHA% a las %HORA% ha sido confirmada.\",\"reminder_message\":\"Recordatorio: tienes una cita el %FECHA% a las %HORA%.\",\"portal_business_name\":\"Peluquería Darío\",\"portal_title\":\"Reserva tu cita\",\"portal_cover_text\":\"Reserva online de forma rápida\",\"portal_instructions\":\"Selecciona servicio, agente y horario disponible para solicitar tu cita.\",\"portal_success_message\":\"Tu solicitud se ha recibido correctamente. Te confirmaremos la cita en breve.\",\"portal_primary_color\":\"#111827\",\"portal_accent_color\":\"#00A887\",\"portal_background_color\":\"#F6F4EF\",\"portal_show_prices\":\"1\",\"portal_iframe_allowed_sites\":\"\"}' WHERE `name` = 'modcitassms'
#194debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'modlog' LIMIT 1 OFFSET 0;
#195debugUPDATE `settings` SET `name` = 'modlog', `properties` = '{\"solucion\":\"Gestión de Clientes\"}' WHERE `name` = 'modlog'
#196debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'modpartesproyectos' LIMIT 1 OFFSET 0;
#197debugUPDATE `settings` SET `name` = 'modpartesproyectos', `properties` = '{\"manualedition\":\"1\"}' WHERE `name` = 'modpartesproyectos'
#198debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'modplantillas_layout' LIMIT 1 OFFSET 0;
#199debugUPDATE `settings` SET `name` = 'modplantillas_layout', `properties` = '{\"format_0\":\"{\\\"left_margin_text\\\":\\\"Pagina lateralxcavaciones Rias Baixas S.L.Lg\\\\/. Ribocias, 24. Caldas de Reis. 36654 Pontevedra. Inscrita en Registro Mercantil de Pontevedra Tomo:4141 Libro:4141 Folio:100 Hoja: PO-60611 Inscrip: 1\\\",\\\"show_contact_separator\\\":false,\\\"money_decimals\\\":2}\"}' WHERE `name` = 'modplantillas_layout'
#200debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'modplantillas_tax' LIMIT 1 OFFSET 0;
#201debugUPDATE `settings` SET `name` = 'modplantillas_tax', `properties` = '{\"format_3\":\"[\\\"tax\\\",\\\"base\\\",\\\"tax_amount\\\",\\\"surcharge\\\",\\\"line_total\\\"]\",\"format_0\":\"[\\\"base\\\",\\\"tax\\\",\\\"tax_amount\\\",\\\"surcharge\\\",\\\"line_total\\\"]\",\"format_4\":\"[\\\"tax\\\",\\\"base\\\",\\\"tax_amount\\\",\\\"surcharge\\\",\\\"line_total\\\"]\",\"format_2\":\"[\\\"tax\\\",\\\"base\\\",\\\"tax_amount\\\",\\\"surcharge\\\",\\\"line_total\\\"]\",\"format_1\":\"[\\\"tax\\\",\\\"base\\\",\\\"tax_amount\\\",\\\"surcharge\\\",\\\"line_total\\\"]\"}' WHERE `name` = 'modplantillas_tax'
#202debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'modtalleres' LIMIT 1 OFFSET 0;
#203debugUPDATE `settings` SET `name` = 'modtalleres', `properties` = '{\"mt_data_version\":2}' WHERE `name` = 'modtalleres'
#204debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'motordecisionesai' LIMIT 1 OFFSET 0;
#205debugUPDATE `settings` SET `name` = 'motordecisionesai', `properties` = '{\"openai_api_key\":\"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\",\"openai_model\":\"gpt-4.1-mini\",\"analysis_start_date\":\"2026-05-05\",\"analysis_end_date\":\"2027-05-05\",\"current_occupancy_pct\":\"0\",\"upcoming_events\":\"\",\"pricing_notes\":\"\",\"decision_prompt\":\"Eres un motor de decisiones para un PMS hotelero. Tu objetivo es maximizar ingresos y ocupacion sin aplicar cambios automaticamente. Devuelve SOLO JSON valido con el formato solicitado.\",\"code\":\"motordecisionesai\"}' WHERE `name` = 'motordecisionesai'
#206debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'neriochat' LIMIT 1 OFFSET 0;0.2ms
#207debugUPDATE `settings` SET `name` = 'neriochat', `properties` = '{\"openai_api_key\":\"v1:mK2qAz/T33rjQvoT4V7hL2XmlwLky4V4vqgiFuie/k1qwmg3EaQeGWSm5cB298gelI+F7F10747itxN29PTUfDGdALEo6oqJjQ97PyERydQ+blDhnC8WO1KEevLHernGZLake4lnSu1ZjnxrBiyq0mX1TKDokJvX9y9PA7UG4T6uABJ+unZ60SORwoS3dM78MHAore0S8W9vhjykDoeNgBXkb/ERV/xD/Hyv5rmBx6ktKRAkU6zfwnXe/li8e2zuOtCklP5rFnlpLl9/dA0ZIsN0k0pFVYwW83NpB28w1tg=\",\"chat_model\":\"gpt-5-mini\",\"embedding_model\":\"text-embedding-3-small\"}' WHERE `name` = 'neriochat'
#208debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'ocrdocuments' LIMIT 1 OFFSET 0;
#209debugUPDATE `settings` SET `name` = 'ocrdocuments', `properties` = '{\"urlapi\":\"https://api.gesdix.com/index.php\",\"cifnif\":\"00000014Z\",\"apikey\":\"0499a2d70274b2f94a1a452d1a9d076e\",\"adjuntar\":true}' WHERE `name` = 'ocrdocuments'
#210debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'ocrmanager' LIMIT 1 OFFSET 0;
#211debugUPDATE `settings` SET `name` = 'ocrmanager', `properties` = '{\"api_key\":\"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\",\"model\":\"gpt-4o-mini\",\"endpoint\":\"https://api.openai.com/v1/responses\",\"temperature\":\"0\",\"max_tokens\":\"900\",\"monthly_limit\":\"10000\",\"usage_month\":\"2026-08\",\"usage_count\":\"20\",\"auto_import\":\"0\",\"auto_create_customers\":\"0\",\"auto_create_suppliers\":\"0\",\"keep_original_number\":\"1\",\"minimum_confidence\":\"0.85\"}' WHERE `name` = 'ocrmanager'
#212debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'plantillaspdf' LIMIT 1 OFFSET 0;
#213debugUPDATE `settings` SET `name` = 'plantillaspdf', `properties` = '{\"template\":\"Template1\",\"size\":\"A4\",\"orientation\":\"portrait\",\"idlogo\":null,\"logosize\":\"0\",\"logoalign\":\"left\",\"topmargin\":\"0\",\"bottommargin\":\"0\",\"font\":\"AboriginalSansREGULAR\",\"fontsize\":\"0\",\"titlefontsize\":\"0\",\"color1\":\"#FFFFFF\",\"color2\":\"#FFFFFF\",\"color3\":\"#FFFFFF\",\"fontcolor\":\"#FFFFFF\",\"showcustomercode\":\"\",\"showcustomerphones\":\"\",\"showcustomeremail\":\"\",\"shownumero2\":\"\",\"shownumproveedor\":\"\",\"showpaymentdate\":\"\",\"showagent\":\"\",\"showinvoicesketch\":\"\",\"show_parent_documents\":\"\",\"hideshipping\":\"\",\"hidenumberinvoice\":\"\",\"hideserieinvoice\":\"\",\"hideobservations\":\"\",\"hidepaymentmethods\":\"\",\"hidereceipts\":\"\",\"hideexpirationpayment\":\"\",\"print_attachment_document\":\"\",\"linecols\":\"\",\"linecolalignments\":\"\",\"linecoltypes\":\"\",\"linesheight\":\"0\",\"endtext\":\"\",\"endfontsize\":\"0\",\"endalign\":\"left\",\"idimagetext\":null,\"imagetextsize\":\"0\",\"thankstitle\":\"\",\"thankstext\":\"\",\"footertext\":\"\",\"footerfontsize\":\"0\",\"footeralign\":\"left\",\"idimagefooter\":null,\"imagefootersize\":\"0\",\"password\":\"\",\"productimagewidth\":\"0\",\"productimageheight\":\"0\"}' WHERE `name` = 'plantillaspdf'
#214debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'pmsagenteia' LIMIT 1 OFFSET 0;0.4ms
#215debugUPDATE `settings` SET `name` = 'pmsagenteia', `properties` = '{\"openai_api_key\":\"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\",\"openai_model\":\"gpt-4.1-mini\",\"webhook_token\":\"\",\"whatsapp_enabled\":\"1\",\"email_enabled\":\"1\",\"auto_send_checkin\":\"1\",\"system_prompt\":\"Eres un asistente de recepcion para alojamientos. Responde breve, claro y solo sobre reservas, check-in y cambios basicos.\",\"code\":\"pmsagenteia\",\"webmail_auto_reply\":\"1\",\"webmail_poll_limit\":3}' WHERE `name` = 'pmsagenteia'
#216debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'pmsmanager' LIMIT 1 OFFSET 0;
#217debugUPDATE `settings` SET `name` = 'pmsmanager', `properties` = '{\"twig_hash_pmsscheduler\":\"7b2eddd6d3d7474acba2abd0f3451581\",\"guest_portal_enabled\":\"1\",\"guest_portal_allow_contact_edit\":\"1\",\"guest_portal_allow_cancellation\":\"1\",\"municipality_seed_version\":\"ine_codmun_2026\",\"stable_room_order_version\":\"1\",\"overbooking_marker_version\":\"1\",\"channex_api_key\":\"\",\"backup_channex_api_key\":\"\",\"channex_webhook_token\":\"\",\"backup_channex_webhook_token\":\"\",\"seeded\":true,\"portal_title\":\"Reserva tu estancia\",\"portal_instructions\":\"Elige las fechas de entrada y salida para comprobar disponibilidad en tiempo real.\",\"portal_success\":\"Hemos recibido tu solicitud y te confirmaremos cuanto antes.\",\"portal_primary_color\":\"#2563EB\",\"portal_accent_color\":\"#F97316\",\"portal_background_color\":\"#F8FAFC\",\"portal_payment_mode\":\"redsys\",\"portal_charge_policy\":\"now\",\"portal_deposit_percent\":\"100\",\"portal_rate_adjustment_type\":\"percent_increase\",\"portal_rate_adjustment_value\":\"10\",\"portal_allowed_frame_origins\":\"\",\"portal_card_payment_code\":\"TARJETA\",\"calendar_last_seen_fiz\":\"2026-08-24 11:13:14\",\"calendar_last_seen_hadrian\":\"2026-09-15 08:17:15\",\"auto_arrival_enabled\":\"0\",\"calendar_last_seen_dario\":\"2026-07-31 12:02:28\",\"default_status\":\"pending\",\"portal_woo_api_url\":\"\",\"portal_woo_consumer_key\":\"\",\"portal_woo_consumer_secret\":\"\",\"ses_environment\":null,\"ses_test_property\":\"0\",\"ses_help\":\"\",\"channex_environment\":null,\"channex_base_url\":\"https://staging.channex.io/api/v1\",\"channex_ota_name\":\"Offline\",\"channex_min_interval_ms\":\"200\",\"channex_test_property\":\"0\",\"ota_reservations_paid\":null,\"channex_messages_enabled\":\"Sí\",\"invoice_series\":null,\"invoice_tax\":null,\"checkin_scan_enabled\":\"Sí\",\"housekeeping_enabled\":null,\"seam_enabled\":\"Sí\",\"seam_api_key\":\"seam_test32XE_BTadYcXEkxwbfkEm5KBExBRF\",\"seam_code_length\":\"4\",\"seam_base_url\":\"https://connect.getseam.com\",\"backup_seam_api_key\":\"seam_test32XE_BTadYcXEkxwbfkEm5KBExBRF\",\"seam_help\":null,\"seam_webhook_secret\":\"whsec_JoswzdvxvCa/BrNdJOhzlWQonCU37BLa\",\"dixtpv_sync_enabled\":\"Sí\",\"property_mode\":\"single\",\"portal_tpv_protocol\":null,\"portal_redsys_tpv_id\":null,\"gestorpms_reservations_enabled\":\"1\",\"gestorpms_cleaning_enabled\":\"1\",\"gestorpms_settlements_enabled\":\"0\",\"gestorpms_messages_enabled\":\"1\"}' WHERE `name` = 'pmsmanager'
#218debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'pmsmanager_persistent' LIMIT 1 OFFSET 0;
#219debugUPDATE `settings` SET `name` = 'pmsmanager_persistent', `properties` = '{\"twig_hash_pmsscheduler\":\"7b2eddd6d3d7474acba2abd0f3451581\",\"guest_portal_enabled\":\"1\",\"guest_portal_allow_contact_edit\":\"1\",\"guest_portal_allow_cancellation\":\"1\",\"municipality_seed_version\":\"ine_codmun_2026\",\"stable_room_order_version\":\"1\",\"overbooking_marker_version\":\"1\",\"channex_api_key\":\"\",\"backup_channex_api_key\":\"\",\"channex_webhook_token\":\"\",\"backup_channex_webhook_token\":\"\",\"seeded\":true,\"portal_title\":\"Reserva tu estancia\",\"portal_instructions\":\"Elige las fechas de entrada y salida para comprobar disponibilidad en tiempo real.\",\"portal_success\":\"Hemos recibido tu solicitud y te confirmaremos cuanto antes.\",\"portal_primary_color\":\"#2563EB\",\"portal_accent_color\":\"#F97316\",\"portal_background_color\":\"#F8FAFC\",\"portal_payment_mode\":\"redsys\",\"portal_charge_policy\":\"now\",\"portal_deposit_percent\":\"100\",\"portal_rate_adjustment_type\":\"percent_increase\",\"portal_rate_adjustment_value\":\"10\",\"portal_allowed_frame_origins\":\"\",\"portal_card_payment_code\":\"TARJETA\",\"calendar_last_seen_fiz\":\"2026-08-24 11:13:14\",\"calendar_last_seen_hadrian\":\"2026-09-15 08:17:15\",\"auto_arrival_enabled\":\"0\",\"calendar_last_seen_dario\":\"2026-07-31 12:02:28\",\"default_status\":\"pending\",\"portal_woo_api_url\":\"\",\"portal_woo_consumer_key\":\"\",\"portal_woo_consumer_secret\":\"\",\"ses_environment\":null,\"ses_test_property\":\"0\",\"ses_help\":\"\",\"channex_environment\":null,\"channex_base_url\":\"https://staging.channex.io/api/v1\",\"channex_ota_name\":\"Offline\",\"channex_min_interval_ms\":\"200\",\"channex_test_property\":\"0\",\"ota_reservations_paid\":null,\"channex_messages_enabled\":\"Sí\",\"invoice_series\":null,\"invoice_tax\":null,\"checkin_scan_enabled\":\"Sí\",\"housekeeping_enabled\":null,\"seam_enabled\":\"Sí\",\"seam_api_key\":\"seam_test32XE_BTadYcXEkxwbfkEm5KBExBRF\",\"seam_code_length\":\"4\",\"seam_base_url\":\"https://connect.getseam.com\",\"backup_seam_api_key\":\"seam_test32XE_BTadYcXEkxwbfkEm5KBExBRF\",\"seam_help\":null,\"seam_webhook_secret\":\"whsec_JoswzdvxvCa/BrNdJOhzlWQonCU37BLa\",\"dixtpv_sync_enabled\":\"Sí\",\"property_mode\":\"single\",\"portal_tpv_protocol\":null,\"portal_redsys_tpv_id\":null,\"gestorpms_reservations_enabled\":\"1\",\"gestorpms_cleaning_enabled\":\"1\",\"gestorpms_settlements_enabled\":\"0\",\"gestorpms_messages_enabled\":\"1\"}' WHERE `name` = 'pmsmanager_persistent'
#220debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'portalcliente' LIMIT 1 OFFSET 0;
#221debugUPDATE `settings` SET `name` = 'portalcliente', `properties` = '{\"catalogue_company\":null,\"shop_warehouse\":null,\"shop_document\":\"PedidoCliente\"}' WHERE `name` = 'portalcliente'
#222debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'preciosdinamicos' LIMIT 1 OFFSET 0;
#223debugUPDATE `settings` SET `name` = 'preciosdinamicos', `properties` = '{\"installation_uuid\":\"cc9f6589-df33-4369-a0ee-897bf8288b64\",\"openai_enabled\":false,\"marketfield_enabled\":false,\"property_sync_last_attempt_at\":\"2026-08-24 11:00:02\"}' WHERE `name` = 'preciosdinamicos'
#224debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'proveedoralmacen' LIMIT 1 OFFSET 0;
#225debugUPDATE `settings` SET `name` = 'proveedoralmacen', `properties` = '{\"sales_lines\":true}' WHERE `name` = 'proveedoralmacen'
#226debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'proyectos' LIMIT 1 OFFSET 0;
#227debugUPDATE `settings` SET `name` = 'proyectos', `properties` = '{\"patron\":\"PR-{ANYO}-{NUM}\",\"longnumero\":6,\"burnstock\":0,\"stock\":false}' WHERE `name` = 'proyectos'
#228debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'reservas' LIMIT 1 OFFSET 0;
#229debugUPDATE `settings` SET `name` = 'reservas', `properties` = '{\"portal_title\":\"Reservas online\",\"portal_instructions\":\"Introduce tus datos para solicitar una reserva en uno de nuestros restaurantes.\",\"portal_success_message\":\"Hemos recibido tu solicitud. Te confirmaremos la reserva pronto.\",\"default_warehouse\":\"2\",\"portal_state_id\":\"1\",\"lunch_start\":\"13:00\",\"lunch_end\":\"16:00\",\"dinner_start\":\"20:00\",\"dinner_end\":\"23:30\",\"restaurant_1_name\":\"ALMACEN CAMIÑOS CHANS\",\"restaurant_1_warehouse\":\"1\",\"restaurant_2_name\":\"Cospeito\",\"restaurant_2_warehouse\":\"2\",\"restaurant_3_name\":\"Empresa de Prueba SL\",\"restaurant_3_warehouse\":\"ALG\"}' WHERE `name` = 'reservas'
#230debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'reservasrestaurante' LIMIT 1 OFFSET 0;
#231debugUPDATE `settings` SET `name` = 'reservasrestaurante', `properties` = '{\"default_duration\":120,\"portal_enabled\":true,\"portal_title\":\"Reserva tu mesa\",\"portal_intro\":\"Selecciona restaurante, fecha, hora y número de comensales.\",\"primary_color\":\"#8b1e2d\",\"min_notice_hours\":2,\"max_advance_days\":90,\"slot_minutes\":30,\"max_guests_online\":20,\"deposit_mode\":\"none\",\"deposit_amount\":0,\"deposit_from_guests\":1,\"payment_gateway\":\"none\",\"currency\":\"EUR\",\"auto_confirm_without_deposit\":true,\"privacy_url\":\"\",\"success_text\":\"Hemos recibido tu reserva. Recibirás la confirmación en breve.\"}' WHERE `name` = 'reservasrestaurante'
#232debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'reservatucita' LIMIT 1 OFFSET 0;
#233debugUPDATE `settings` SET `name` = 'reservatucita', `properties` = '{\"show_families\":1,\"show_advanced\":0,\"push_last_dispatch\":\"2026-10-03 05:20:01\",\"push_vapid\":\"{\\\"publicKey\\\":\\\"BBj-c9a8Y4lHxM3yUaN5Jk6_G6Of385XbuW3L8t-C2jO6dumNOOvSG57zYl40F9kCHFuUPudGLP8C8SqXZSEFEc\\\",\\\"privateKey\\\":\\\"ALxGCtQxnBtjeJxupCCT_QJ8joVN7qlqFPiW2VQ7w1U\\\"}\",\"push_subject\":\"https://pruebaslucas.gesdix.com\"}' WHERE `name` = 'reservatucita'
#234debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'revenue' LIMIT 1 OFFSET 0;
#235debugUPDATE `settings` SET `name` = 'revenue', `properties` = '{\"enabled\":\"0\"}' WHERE `name` = 'revenue'
#236debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'rrhh' LIMIT 1 OFFSET 0;
#237debugUPDATE `settings` SET `name` = 'rrhh', `properties` = '{\"journal\":\"1\",\"extra-hours\":\"5\",\"biodevice\":\"0\",\"filtercheckdate\":\"\",\"allowmanual\":\"1\",\"overtime\":null,\"notificationemail\":\"fizdixome@gmail.com\",\"credentialmaxlen\":\"4\",\"inputdelay\":\"0\",\"maxdelay\":\"0\",\"perioddelay\":\"0\",\"allowcomputable\":\"0\",\"minforextra\":\"0\",\"locationgps\":\"\",\"absencealertemail\":\"\",\"absencealertinterval\":\"5\",\"absencealertstate\":\"{\\\"8\\\":{\\\"input\\\":{\\\"date\\\":\\\"2026-02-01\\\",\\\"time\\\":\\\"01-02-2026 20:05:02\\\"}},\\\"9\\\":{\\\"input\\\":{\\\"date\\\":\\\"2026-01-31\\\",\\\"time\\\":\\\"31-01-2026 08:05:01\\\"}},\\\"4\\\":{\\\"input\\\":{\\\"date\\\":\\\"2026-02-05\\\",\\\"time\\\":\\\"05-02-2026 08:25:01\\\"}},\\\"2\\\":{\\\"input\\\":{\\\"date\\\":\\\"2026-01-28\\\",\\\"time\\\":\\\"28-01-2026 11:50:02\\\"}},\\\"11\\\":{\\\"input\\\":{\\\"date\\\":\\\"2026-02-04\\\",\\\"time\\\":\\\"04-02-2026 20:05:01\\\"}},\\\"12\\\":{\\\"input\\\":{\\\"date\\\":\\\"2026-01-30\\\",\\\"time\\\":\\\"30-01-2026 10:00:02\\\"}},\\\"10\\\":{\\\"input\\\":{\\\"date\\\":\\\"2026-02-05\\\",\\\"time\\\":\\\"05-02-2026 08:25:01\\\"}}}\",\"vacationworkdays\":\"1\",\"attendancebackbutton\":\"1\",\"dashboardrequests\":\"1\"}' WHERE `name` = 'rrhh'
#238debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'rrhhrules' LIMIT 1 OFFSET 0;
#239debugUPDATE `settings` SET `name` = 'rrhhrules', `properties` = '{\"rules\":\"nueva regla\"}' WHERE `name` = 'rrhhrules'
#240debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'servicios' LIMIT 1 OFFSET 0;
#241debugUPDATE `settings` SET `name` = 'servicios', `properties` = '{\"mt_dias_escalado\":3}' WHERE `name` = 'servicios'
#242debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'stripe' LIMIT 1 OFFSET 0;
#243debugUPDATE `settings` SET `name` = 'stripe', `properties` = '{\"sks\":\"a:1:{i:0;a:4:{s:4:\\\"name\\\";s:22:\\\"Digitalización Dixome\\\";s:2:\\\"sk\\\";s:107:\\\"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\\\";s:8:\\\"codserie\\\";s:1:\\\"A\\\";s:5:\\\"token\\\";s:32:\\\"e4c8aa5b9295ee58f6b57554ae3104c8\\\";}}\"}' WHERE `name` = 'stripe'
#244debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'tpvredsys' LIMIT 1 OFFSET 0;
#245debugUPDATE `settings` SET `name` = 'tpvredsys', `properties` = '{\"token\":\"438f83938bee837bc75dcaa0a65ea1ceae8e3f21a21a0391\"}' WHERE `name` = 'tpvredsys'
#246debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'verifactu' LIMIT 1 OFFSET 0;
#247debugUPDATE `settings` SET `name` = 'verifactu', `properties` = '{\"send_last_date\":null}' WHERE `name` = 'verifactu'
#248debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'webmailinbox' LIMIT 1 OFFSET 0;
#249debugUPDATE `settings` SET `name` = 'webmailinbox', `properties` = '{\"user\":\"fizdixome@gmail.com\",\"password\":\"roafyhuplzivhevy\",\"host\":\"imap.gmail.com\",\"port\":\"993\",\"enc\":\"ssl\",\"folder\":\"INBOX\",\"imap_validate\":\"\",\"pop_host\":\"pop.gmail.com\",\"pop_port\":\"995\",\"pop_enc\":\"ssl\",\"spam_folder\":\"Spam\"}' WHERE `name` = 'webmailinbox'
#250debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'webmailinbox_legacy' LIMIT 1 OFFSET 0;
#251debugUPDATE `settings` SET `name` = 'webmailinbox_legacy', `properties` = '{\"user\":\"no-reply@dixome.net\",\"password\":\"Acceso1?\",\"host\":\"gesdix-com.correoseguro.dinaserver.com\",\"port\":\"993\",\"enc\":\"ssl\",\"folder\":\"\",\"imap_validate\":\"\"}' WHERE `name` = 'webmailinbox_legacy'
#252debugSHOW COLUMNS FROM `pms_website_templates`;0.4ms
#253debugSELECT * FROM `settings`
#254debugSHOW COLUMNS FROM `pms_websites`;0.3ms
#255debugSHOW COLUMNS FROM `pms_website_pages`;0.2ms
#256debugSHOW COLUMNS FROM `pms_website_sections`;0.2ms
#257debugSHOW COLUMNS FROM `pms_website_media`;0.2ms
#258debugSELECT * FROM `pms_website_templates` WHERE `code` = 'lodgify-livingstone' LIMIT 1 OFFSET 0;
#259debugSELECT * FROM `pms_website_templates` WHERE `code` = 'lodgify-tideway' LIMIT 1 OFFSET 0;
#260debugSELECT * FROM `pms_website_templates` WHERE `code` = 'lodgify-brooklyn' LIMIT 1 OFFSET 0;
#261debugSELECT * FROM `pms_website_templates` WHERE `code` = 'lodgify-capucine' LIMIT 1 OFFSET 0;
#262debugSELECT * FROM `pms_website_templates` WHERE `code` = 'hotel-moderna' LIMIT 1 OFFSET 0;
#263debugSELECT COUNT(*) as _count FROM `pms_website_templates` WHERE `id` = '1' LIMIT 1 OFFSET 0;
#264debugUPDATE `pms_website_templates` SET `id` = '1', `code` = 'hotel-moderna', `name` = 'Plantilla Hotel Moderna', `description` = 'Diseño moderno para hoteles urbanos.', `preview_image` = '', `default_config_json` = '{\"primary\":\"#0ea5e9\",\"secondary\":\"#1e293b\",\"background\":\"#f8fafc\",\"surface\":\"#ffffff\",\"text\":\"#0f172a\",\"hero_overlay\":\"#0f172a\",\"radius\":\"14\",\"font\":\"DM Sans\"}', `default_sections_json` = '{\"hero_title\":\"Reserva tu estancia ideal\",\"hero_subtitle\":\"Motor de reservas integrado con disponibilidad real.\",\"description\":\"Alojamiento con atención personalizada, ubicaciones excelentes y confirmación inmediata.\",\"services\":[\"WiFi alta velocidad\",\"Late check-out\",\"Desayuno gourmet\",\"Spa y bienestar\"],\"contact_phone\":\"+34 900 000 000\",\"contact_email\":\"reservas@hotel.com\",\"cta_text\":\"Reservar ahora\",\"nav_link_1\":\"Galería\",\"nav_link_2\":\"Servicios\",\"nav_link_3\":\"Reservar\",\"hero_badge\":\"Reserva directa\",\"booking_bar_title\":\"Comprueba disponibilidad en segundos\",\"booking_bar_text\":\"Disponibilidad real, confirmación inmediata y atención personalizada.\",\"intro_title\":\"Una estancia preparada para disfrutar\",\"intro_text\":\"Alojamiento con atención personalizada, ubicaciones excelentes y confirmación inmediata.\",\"gallery_title\":\"El alojamiento en imágenes\",\"rooms_title\":\"Habitaciones y espacios\",\"rooms_text\":\"Espacios preparados para descansar y disfrutar con comodidad.\",\"room_item_title\":\"Espacio\",\"room_item_text\":\"Preparado para descansar, cocinar y disfrutar con privacidad.\",\"services_title\":\"Servicios destacados\",\"feature_1_title\":\"Reserva\",\"feature_1_text\":\"Directa y segura\",\"feature_2_title\":\"Estancia\",\"feature_2_text\":\"Familias y grupos\",\"feature_3_title\":\"Servicios\",\"feature_3_text\":\"Todo incluido\",\"feature_4_title\":\"Confirmación\",\"feature_4_text\":\"Inmediata\",\"trust_1_title\":\"Directo\",\"trust_1_text\":\"Sin comisiones externas\",\"trust_2_title\":\"Seguro\",\"trust_2_text\":\"Confirmación inmediata\",\"trust_3_title\":\"Flexible\",\"trust_3_text\":\"Atención personalizada\",\"booking_section_title\":\"Reserva tu estancia\",\"footer_text\":\"\",\"custom_texts\":[{\"title\":\"Reserva directa\",\"content\":\"Consigue disponibilidad real, confirmación inmediata y trato personalizado desde la web oficial.\"},{\"title\":\"Ubicación y experiencia\",\"content\":\"Describe aquí la zona, los puntos de interés cercanos y los motivos por los que tus huéspedes eligen el alojamiento.\"}]}', `active` = TRUE WHERE `id` = '1'
#265debugSELECT * FROM `pms_website_templates` WHERE `code` = 'apartamentos-turisticos' LIMIT 1 OFFSET 0;
#266debugSELECT COUNT(*) as _count FROM `pms_website_templates` WHERE `id` = '2' LIMIT 1 OFFSET 0;
#267debugUPDATE `pms_website_templates` SET `id` = '2', `code` = 'apartamentos-turisticos', `name` = 'Plantilla Apartamentos Turísticos', `description` = 'Enfoque en estancias familiares y largas.', `preview_image` = '', `default_config_json` = '{\"primary\":\"#14b8a6\",\"secondary\":\"#0f172a\",\"background\":\"#f0fdfa\",\"surface\":\"#ffffff\",\"text\":\"#0f172a\",\"hero_overlay\":\"#0f172a\",\"radius\":\"14\",\"font\":\"Manrope\"}', `default_sections_json` = '{\"hero_title\":\"Reserva tu estancia ideal\",\"hero_subtitle\":\"Motor de reservas integrado con disponibilidad real.\",\"description\":\"Alojamiento con atención personalizada, ubicaciones excelentes y confirmación inmediata.\",\"services\":[\"Cocina equipada\",\"WiFi incluido\",\"Parking cercano\",\"Ideal familias\"],\"contact_phone\":\"+34 900 000 000\",\"contact_email\":\"reservas@hotel.com\",\"cta_text\":\"Reservar ahora\",\"nav_link_1\":\"Galería\",\"nav_link_2\":\"Servicios\",\"nav_link_3\":\"Reservar\",\"hero_badge\":\"Reserva directa\",\"booking_bar_title\":\"Comprueba disponibilidad en segundos\",\"booking_bar_text\":\"Disponibilidad real, confirmación inmediata y atención personalizada.\",\"intro_title\":\"Una estancia preparada para disfrutar\",\"intro_text\":\"Alojamiento con atención personalizada, ubicaciones excelentes y confirmación inmediata.\",\"gallery_title\":\"El alojamiento en imágenes\",\"rooms_title\":\"Habitaciones y espacios\",\"rooms_text\":\"Espacios preparados para descansar y disfrutar con comodidad.\",\"room_item_title\":\"Espacio\",\"room_item_text\":\"Preparado para descansar, cocinar y disfrutar con privacidad.\",\"services_title\":\"Servicios destacados\",\"feature_1_title\":\"Reserva\",\"feature_1_text\":\"Directa y segura\",\"feature_2_title\":\"Estancia\",\"feature_2_text\":\"Familias y grupos\",\"feature_3_title\":\"Servicios\",\"feature_3_text\":\"Todo incluido\",\"feature_4_title\":\"Confirmación\",\"feature_4_text\":\"Inmediata\",\"trust_1_title\":\"Directo\",\"trust_1_text\":\"Sin comisiones externas\",\"trust_2_title\":\"Seguro\",\"trust_2_text\":\"Confirmación inmediata\",\"trust_3_title\":\"Flexible\",\"trust_3_text\":\"Atención personalizada\",\"booking_section_title\":\"Reserva tu estancia\",\"footer_text\":\"\",\"custom_texts\":[{\"title\":\"Pensado para estancias cómodas\",\"content\":\"Añade información sobre distribución, equipamiento, normas y ventajas para familias o estancias largas.\"},{\"title\":\"Planifica tu viaje\",\"content\":\"Recomienda restaurantes, transporte, actividades y puntos de interés para mejorar la experiencia del huésped.\"}]}', `active` = TRUE WHERE `id` = '2'
#268debugSELECT * FROM `pms_website_templates` WHERE `code` = 'rural' LIMIT 1 OFFSET 0;
#269debugSELECT COUNT(*) as _count FROM `pms_website_templates` WHERE `id` = '3' LIMIT 1 OFFSET 0;
#270debugUPDATE `pms_website_templates` SET `id` = '3', `code` = 'rural', `name` = 'Plantilla Rural', `description` = 'Estética natural para casas rurales.', `preview_image` = '', `default_config_json` = '{\"primary\":\"#16a34a\",\"secondary\":\"#14532d\",\"background\":\"#f7fee7\",\"surface\":\"#ffffff\",\"text\":\"#14532d\",\"hero_overlay\":\"#14532d\",\"radius\":\"12\",\"font\":\"Nunito Sans\"}', `default_sections_json` = '{\"hero_title\":\"Reserva tu estancia ideal\",\"hero_subtitle\":\"Motor de reservas integrado con disponibilidad real.\",\"description\":\"Alojamiento con atención personalizada, ubicaciones excelentes y confirmación inmediata.\",\"services\":[\"Rutas naturales\",\"Desayuno casero\",\"Chimenea\",\"Parking\"],\"contact_phone\":\"+34 900 000 000\",\"contact_email\":\"reservas@hotel.com\",\"cta_text\":\"Reservar ahora\",\"nav_link_1\":\"Galería\",\"nav_link_2\":\"Servicios\",\"nav_link_3\":\"Reservar\",\"hero_badge\":\"Reserva directa\",\"booking_bar_title\":\"Comprueba disponibilidad en segundos\",\"booking_bar_text\":\"Disponibilidad real, confirmación inmediata y atención personalizada.\",\"intro_title\":\"Una estancia preparada para disfrutar\",\"intro_text\":\"Alojamiento con atención personalizada, ubicaciones excelentes y confirmación inmediata.\",\"gallery_title\":\"El alojamiento en imágenes\",\"rooms_title\":\"Habitaciones y espacios\",\"rooms_text\":\"Espacios preparados para descansar y disfrutar con comodidad.\",\"room_item_title\":\"Espacio\",\"room_item_text\":\"Preparado para descansar, cocinar y disfrutar con privacidad.\",\"services_title\":\"Servicios destacados\",\"feature_1_title\":\"Reserva\",\"feature_1_text\":\"Directa y segura\",\"feature_2_title\":\"Estancia\",\"feature_2_text\":\"Familias y grupos\",\"feature_3_title\":\"Servicios\",\"feature_3_text\":\"Todo incluido\",\"feature_4_title\":\"Confirmación\",\"feature_4_text\":\"Inmediata\",\"trust_1_title\":\"Directo\",\"trust_1_text\":\"Sin comisiones externas\",\"trust_2_title\":\"Seguro\",\"trust_2_text\":\"Confirmación inmediata\",\"trust_3_title\":\"Flexible\",\"trust_3_text\":\"Atención personalizada\",\"booking_section_title\":\"Reserva tu estancia\",\"footer_text\":\"\",\"custom_texts\":[{\"title\":\"Entorno natural\",\"content\":\"Cuenta qué rutas, paisajes o actividades hay cerca del alojamiento.\"},{\"title\":\"Detalles de la casa\",\"content\":\"Destaca zonas exteriores, barbacoa, chimenea, habitaciones y servicios incluidos.\"}]}', `active` = TRUE WHERE `id` = '3'
#271debugSELECT * FROM `pms_website_templates` WHERE `code` = 'luxury' LIMIT 1 OFFSET 0;
#272debugSELECT COUNT(*) as _count FROM `pms_website_templates` WHERE `id` = '4' LIMIT 1 OFFSET 0;0.3ms
#273debugUPDATE `pms_website_templates` SET `id` = '4', `code` = 'luxury', `name` = 'Plantilla Luxury', `description` = 'Visual premium para hoteles de lujo.', `preview_image` = '', `default_config_json` = '{\"primary\":\"#b45309\",\"secondary\":\"#111827\",\"background\":\"#0b1020\",\"surface\":\"#ffffff14\",\"text\":\"#f3f4f6\",\"hero_overlay\":\"#0b1020\",\"radius\":\"12\",\"font\":\"Source Sans 3\"}', `default_sections_json` = '{\"hero_title\":\"Reserva tu estancia ideal\",\"hero_subtitle\":\"Motor de reservas integrado con disponibilidad real.\",\"description\":\"Alojamiento con atención personalizada, ubicaciones excelentes y confirmación inmediata.\",\"services\":[\"Concierge privado\",\"Piscina infinity\",\"Spa signature\",\"Desayuno gourmet\"],\"contact_phone\":\"+34 900 000 000\",\"contact_email\":\"reservas@hotel.com\",\"cta_text\":\"Reservar ahora\",\"nav_link_1\":\"Galería\",\"nav_link_2\":\"Servicios\",\"nav_link_3\":\"Reservar\",\"hero_badge\":\"Reserva directa\",\"booking_bar_title\":\"Comprueba disponibilidad en segundos\",\"booking_bar_text\":\"Disponibilidad real, confirmación inmediata y atención personalizada.\",\"intro_title\":\"Una estancia preparada para disfrutar\",\"intro_text\":\"Alojamiento con atención personalizada, ubicaciones excelentes y confirmación inmediata.\",\"gallery_title\":\"El alojamiento en imágenes\",\"rooms_title\":\"Habitaciones y espacios\",\"rooms_text\":\"Espacios preparados para descansar y disfrutar con comodidad.\",\"room_item_title\":\"Espacio\",\"room_item_text\":\"Preparado para descansar, cocinar y disfrutar con privacidad.\",\"services_title\":\"Servicios destacados\",\"feature_1_title\":\"Reserva\",\"feature_1_text\":\"Directa y segura\",\"feature_2_title\":\"Estancia\",\"feature_2_text\":\"Familias y grupos\",\"feature_3_title\":\"Servicios\",\"feature_3_text\":\"Todo incluido\",\"feature_4_title\":\"Confirmación\",\"feature_4_text\":\"Inmediata\",\"trust_1_title\":\"Directo\",\"trust_1_text\":\"Sin comisiones externas\",\"trust_2_title\":\"Seguro\",\"trust_2_text\":\"Confirmación inmediata\",\"trust_3_title\":\"Flexible\",\"trust_3_text\":\"Atención personalizada\",\"booking_section_title\":\"Reserva tu estancia\",\"footer_text\":\"\",\"custom_texts\":[{\"title\":\"Experiencia premium\",\"content\":\"Describe servicios diferenciales, atención personalizada y detalles exclusivos de la estancia.\"},{\"title\":\"Reserva oficial\",\"content\":\"Refuerza las ventajas de reservar directamente: mejor comunicación, condiciones claras y confirmación inmediata.\"}]}', `active` = TRUE WHERE `id` = '4'
#274debugSELECT * FROM `pms_website_templates` WHERE `code` = 'minimalista' LIMIT 1 OFFSET 0;
#275debugSELECT COUNT(*) as _count FROM `pms_website_templates` WHERE `id` = '5' LIMIT 1 OFFSET 0;
#276debugUPDATE `pms_website_templates` SET `id` = '5', `code` = 'minimalista', `name` = 'Plantilla Minimalista', `description` = 'Minimal clean con foco en conversión.', `preview_image` = '', `default_config_json` = '{\"primary\":\"#111827\",\"secondary\":\"#6b7280\",\"background\":\"#ffffff\",\"surface\":\"#ffffff\",\"text\":\"#111827\",\"hero_overlay\":\"#ffffff\",\"radius\":\"10\",\"font\":\"Outfit\"}', `default_sections_json` = '{\"hero_title\":\"Reserva tu estancia ideal\",\"hero_subtitle\":\"Motor de reservas integrado con disponibilidad real.\",\"description\":\"Alojamiento con atención personalizada, ubicaciones excelentes y confirmación inmediata.\",\"services\":[\"Ubicación céntrica\",\"Cancelación flexible\",\"Atención 24h\"],\"contact_phone\":\"+34 900 000 000\",\"contact_email\":\"reservas@hotel.com\",\"cta_text\":\"Reservar ahora\",\"nav_link_1\":\"Galería\",\"nav_link_2\":\"Servicios\",\"nav_link_3\":\"Reservar\",\"hero_badge\":\"Reserva directa\",\"booking_bar_title\":\"Comprueba disponibilidad en segundos\",\"booking_bar_text\":\"Disponibilidad real, confirmación inmediata y atención personalizada.\",\"intro_title\":\"Una estancia preparada para disfrutar\",\"intro_text\":\"Alojamiento con atención personalizada, ubicaciones excelentes y confirmación inmediata.\",\"gallery_title\":\"El alojamiento en imágenes\",\"rooms_title\":\"Habitaciones y espacios\",\"rooms_text\":\"Espacios preparados para descansar y disfrutar con comodidad.\",\"room_item_title\":\"Espacio\",\"room_item_text\":\"Preparado para descansar, cocinar y disfrutar con privacidad.\",\"services_title\":\"Servicios destacados\",\"feature_1_title\":\"Reserva\",\"feature_1_text\":\"Directa y segura\",\"feature_2_title\":\"Estancia\",\"feature_2_text\":\"Familias y grupos\",\"feature_3_title\":\"Servicios\",\"feature_3_text\":\"Todo incluido\",\"feature_4_title\":\"Confirmación\",\"feature_4_text\":\"Inmediata\",\"trust_1_title\":\"Directo\",\"trust_1_text\":\"Sin comisiones externas\",\"trust_2_title\":\"Seguro\",\"trust_2_text\":\"Confirmación inmediata\",\"trust_3_title\":\"Flexible\",\"trust_3_text\":\"Atención personalizada\",\"booking_section_title\":\"Reserva tu estancia\",\"footer_text\":\"\",\"custom_texts\":[{\"title\":\"Información clara\",\"content\":\"Resume lo esencial del alojamiento para que el huésped pueda decidir rápido.\"},{\"title\":\"Reserva sin complicaciones\",\"content\":\"Disponibilidad real, contacto directo y proceso de reserva integrado.\"}]}', `active` = TRUE WHERE `id` = '5'
#277debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = '__empty_settings_backup_20260507_090805' LIMIT 1 OFFSET 0;
#278debugUPDATE `settings` SET `name` = '__empty_settings_backup_20260507_090805', `properties` = '{\"openai_api_key\":\"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\",\"openai_model\":\"gpt-4.1-mini\",\"webhook_token\":\"\",\"whatsapp_enabled\":\"1\",\"email_enabled\":\"1\",\"auto_send_checkin\":\"1\",\"system_prompt\":\"Eres un asistente de recepcion para alojamientos. Responde breve, claro y solo sobre reservas, check-in y cambios basicos.\"}' WHERE `name` = '__empty_settings_backup_20260507_090805'
#279debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'AiScan' LIMIT 1 OFFSET 0;
#280debugUPDATE `settings` SET `name` = 'AiScan', `properties` = '{\"enabled\":\"1\",\"default_provider\":\"openai\",\"max_upload_size_mb\":\"10\",\"allowed_extensions\":\"pdf,jpg,jpeg,png,webp\",\"auto_scan\":\"0\",\"debug_mode\":\"\",\"max_parallel_requests\":\"5\",\"request_timeout\":\"120\",\"openai_model\":\"gpt-5-nano\",\"openai_base_url\":\"https://api.openai.com/v1\",\"gemini_model\":\"gemini-2.5-flash-lite\",\"mistral_model\":\"mistral-small-latest\",\"openai_api_key\":\"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\",\"gemini_api_key\":\"\",\"mistral_api_key\":\"\",\"custom_api_key\":\"\",\"custom_model\":\"\",\"custom_base_url\":\"\",\"additional_prompt\":\"\"}' WHERE `name` = 'AiScan'
#281debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'aloxameia' LIMIT 1 OFFSET 0;
#282debugUPDATE `settings` SET `name` = 'aloxameia', `properties` = '{\"enabled\":\"1\",\"model\":\"gpt-5-mini\",\"instructions\":\"\"}' WHERE `name` = 'aloxameia'
#283debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'aloxamesimple' LIMIT 1 OFFSET 0;
#284debugUPDATE `settings` SET `name` = 'aloxamesimple', `properties` = '{\"pms_backup_channex_api_key\":\"\",\"pms_backup_channex_webhook_token\":\"\",\"pms_backup_seam_api_key\":\"\"}' WHERE `name` = 'aloxamesimple'
#285debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'analiticasaloxame' LIMIT 1 OFFSET 0;
#286debugUPDATE `settings` SET `name` = 'analiticasaloxame', `properties` = '{\"page_version\":\"2\"}' WHERE `name` = 'analiticasaloxame'
#287debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'anticipos' LIMIT 1 OFFSET 0;
#288debugUPDATE `settings` SET `name` = 'anticipos', `properties` = '{\"pdAnticipos\":true,\"level\":20}' WHERE `name` = 'anticipos'
#289debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'citas' LIMIT 1 OFFSET 0;
#290debugUPDATE `settings` SET `name` = 'citas', `properties` = '{\"duration\":60,\"patron\":\"CITA{ANYO}-{0NUM}\",\"longnumero\":1}' WHERE `name` = 'citas'
#291debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'default' LIMIT 1 OFFSET 0;
#292debugUPDATE `settings` SET `name` = 'default', `properties` = '{\"codpais\":\"ESP\",\"currency_position\":\"right\",\"item_limit\":50,\"decimals\":2,\"decimal_separator\":\",\",\"thousands_separator\":\" \",\"codalmacen\":null,\"coddivisa\":null,\"codpago\":null,\"enable_api\":true,\"telemetryinstall\":null,\"idempresa\":1,\"codserie\":null,\"finofertadays\":null,\"codretencion\":null,\"tipoidfiscal\":null,\"decimales\":2,\"codimpuesto\":null,\"ventasinstock\":false,\"autobatchserialsales\":false,\"taxcalculationmethod\":\"classic\",\"autogenbarcodes\":false,\"columnetosubtotal\":\"subtotal\"}' WHERE `name` = 'default'
#293debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'dixtpvbonos' LIMIT 1 OFFSET 0;
#294debugUPDATE `settings` SET `name` = 'dixtpvbonos', `properties` = '{\"nombre_bono\":\"Bar Reynolds\"}' WHERE `name` = 'dixtpvbonos'
#295debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'email' LIMIT 1 OFFSET 0;
#296debugUPDATE `settings` SET `name` = 'email', `properties` = '{\"enc\":\"ssl\",\"host\":\"smtp.gmail.com\",\"mailer\":\"smtp\",\"port\":\"465\",\"email\":\"fizdixome@gmail.com\",\"password\":\"mxmb yynv ovhx wrjk\",\"idlogo\":null,\"signature\":\"\",\"user\":\"\",\"authtype\":\"\",\"lowsecure\":\"\",\"replytouseremail\":\"1\",\"emailcc\":\"\",\"emailbcc\":\"\",\"name\":\"\"}' WHERE `name` = 'email'
#297debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'formacionia' LIMIT 1 OFFSET 0;
#298debugUPDATE `settings` SET `name` = 'formacionia', `properties` = '{\"api_key\":\"sk-00e9cb90999b4bab901ea2a649dc4f7d\",\"daily_limit\":\"100\",\"embedding_model\":\"deepseek-embed\",\"chat_model\":\"deepseek-chat\"}' WHERE `name` = 'formacionia'
#299debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'gesdix' LIMIT 1 OFFSET 0;
#300debugUPDATE `settings` SET `name` = 'gesdix', `properties` = '{\"invoice-creation-date-backfill\":\"1\",\"purchase-invoice-creation-date-backfill\":\"1\"}' WHERE `name` = 'gesdix'
#301debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'GesDixAI' LIMIT 1 OFFSET 0;
#302debugUPDATE `settings` SET `name` = 'GesDixAI', `properties` = '{\"enabled\":\"1\",\"model\":\"gpt-5-mini\",\"additional_instructions\":\"\",\"max_output_tokens\":\"2048\",\"daily_request_limit\":\"200\",\"request_timeout\":\"60\",\"provider\":\"openai\",\"model_choice\":\"gpt-5-mini\",\"custom_model\":\"\"}' WHERE `name` = 'GesDixAI'
#303debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'gesdixonboarding' LIMIT 1 OFFSET 0;
#304debugUPDATE `settings` SET `name` = 'gesdixonboarding', `properties` = '{\"completed\":\"1\",\"installation_key\":\"\"}' WHERE `name` = 'gesdixonboarding'
#305debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'informeine' LIMIT 1 OFFSET 0;
#306debugUPDATE `settings` SET `name` = 'informeine', `properties` = '{\"enabled\":\"1\",\"idproperty\":\"4\",\"survey_type\":\"EOAL\",\"official_places\":\"0\",\"establishment_code\":\"\"}' WHERE `name` = 'informeine'
#307debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'modcitassms' LIMIT 1 OFFSET 0;
#308debugUPDATE `settings` SET `name` = 'modcitassms', `properties` = '{\"twilio_sid\":\"AC98765330a6134c52c9288f554c66a3c0\",\"twilio_token\":\"1920ab27c9f0df54601f874b3302297c\",\"twilio_from\":\"+19892671907\",\"reminder_minutes\":\"5\",\"default_warehouse\":\"ALG\",\"default_state_id\":\"1\",\"portal_state_id\":\"1\",\"confirm_message\":\"Tu cita para el %FECHA% a las %HORA% ha sido confirmada.\",\"reminder_message\":\"Recordatorio: tienes una cita el %FECHA% a las %HORA%.\",\"portal_business_name\":\"Peluquería Darío\",\"portal_title\":\"Reserva tu cita\",\"portal_cover_text\":\"Reserva online de forma rápida\",\"portal_instructions\":\"Selecciona servicio, agente y horario disponible para solicitar tu cita.\",\"portal_success_message\":\"Tu solicitud se ha recibido correctamente. Te confirmaremos la cita en breve.\",\"portal_primary_color\":\"#111827\",\"portal_accent_color\":\"#00A887\",\"portal_background_color\":\"#F6F4EF\",\"portal_show_prices\":\"1\",\"portal_iframe_allowed_sites\":\"\"}' WHERE `name` = 'modcitassms'
#309debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'modlog' LIMIT 1 OFFSET 0;
#310debugUPDATE `settings` SET `name` = 'modlog', `properties` = '{\"solucion\":\"Gestión de Clientes\"}' WHERE `name` = 'modlog'
#311debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'modpartesproyectos' LIMIT 1 OFFSET 0;
#312debugUPDATE `settings` SET `name` = 'modpartesproyectos', `properties` = '{\"manualedition\":\"1\"}' WHERE `name` = 'modpartesproyectos'
#313debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'modplantillas_layout' LIMIT 1 OFFSET 0;
#314debugUPDATE `settings` SET `name` = 'modplantillas_layout', `properties` = '{\"format_0\":\"{\\\"left_margin_text\\\":\\\"Pagina lateralxcavaciones Rias Baixas S.L.Lg\\\\/. Ribocias, 24. Caldas de Reis. 36654 Pontevedra. Inscrita en Registro Mercantil de Pontevedra Tomo:4141 Libro:4141 Folio:100 Hoja: PO-60611 Inscrip: 1\\\",\\\"show_contact_separator\\\":false,\\\"money_decimals\\\":2}\"}' WHERE `name` = 'modplantillas_layout'
#315debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'modplantillas_tax' LIMIT 1 OFFSET 0;
#316debugUPDATE `settings` SET `name` = 'modplantillas_tax', `properties` = '{\"format_3\":\"[\\\"tax\\\",\\\"base\\\",\\\"tax_amount\\\",\\\"surcharge\\\",\\\"line_total\\\"]\",\"format_0\":\"[\\\"base\\\",\\\"tax\\\",\\\"tax_amount\\\",\\\"surcharge\\\",\\\"line_total\\\"]\",\"format_4\":\"[\\\"tax\\\",\\\"base\\\",\\\"tax_amount\\\",\\\"surcharge\\\",\\\"line_total\\\"]\",\"format_2\":\"[\\\"tax\\\",\\\"base\\\",\\\"tax_amount\\\",\\\"surcharge\\\",\\\"line_total\\\"]\",\"format_1\":\"[\\\"tax\\\",\\\"base\\\",\\\"tax_amount\\\",\\\"surcharge\\\",\\\"line_total\\\"]\"}' WHERE `name` = 'modplantillas_tax'
#317debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'modtalleres' LIMIT 1 OFFSET 0;
#318debugUPDATE `settings` SET `name` = 'modtalleres', `properties` = '{\"mt_data_version\":2}' WHERE `name` = 'modtalleres'
#319debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'motordecisionesai' LIMIT 1 OFFSET 0;0.3ms
#320debugUPDATE `settings` SET `name` = 'motordecisionesai', `properties` = '{\"openai_api_key\":\"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\",\"openai_model\":\"gpt-4.1-mini\",\"analysis_start_date\":\"2026-05-05\",\"analysis_end_date\":\"2027-05-05\",\"current_occupancy_pct\":\"0\",\"upcoming_events\":\"\",\"pricing_notes\":\"\",\"decision_prompt\":\"Eres un motor de decisiones para un PMS hotelero. Tu objetivo es maximizar ingresos y ocupacion sin aplicar cambios automaticamente. Devuelve SOLO JSON valido con el formato solicitado.\",\"code\":\"motordecisionesai\"}' WHERE `name` = 'motordecisionesai'
#321debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'neriochat' LIMIT 1 OFFSET 0;
#322debugUPDATE `settings` SET `name` = 'neriochat', `properties` = '{\"openai_api_key\":\"v1:mK2qAz/T33rjQvoT4V7hL2XmlwLky4V4vqgiFuie/k1qwmg3EaQeGWSm5cB298gelI+F7F10747itxN29PTUfDGdALEo6oqJjQ97PyERydQ+blDhnC8WO1KEevLHernGZLake4lnSu1ZjnxrBiyq0mX1TKDokJvX9y9PA7UG4T6uABJ+unZ60SORwoS3dM78MHAore0S8W9vhjykDoeNgBXkb/ERV/xD/Hyv5rmBx6ktKRAkU6zfwnXe/li8e2zuOtCklP5rFnlpLl9/dA0ZIsN0k0pFVYwW83NpB28w1tg=\",\"chat_model\":\"gpt-5-mini\",\"embedding_model\":\"text-embedding-3-small\"}' WHERE `name` = 'neriochat'
#323debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'ocrdocuments' LIMIT 1 OFFSET 0;
#324debugUPDATE `settings` SET `name` = 'ocrdocuments', `properties` = '{\"urlapi\":\"https://api.gesdix.com/index.php\",\"cifnif\":\"00000014Z\",\"apikey\":\"0499a2d70274b2f94a1a452d1a9d076e\",\"adjuntar\":true}' WHERE `name` = 'ocrdocuments'
#325debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'ocrmanager' LIMIT 1 OFFSET 0;
#326debugUPDATE `settings` SET `name` = 'ocrmanager', `properties` = '{\"api_key\":\"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\",\"model\":\"gpt-4o-mini\",\"endpoint\":\"https://api.openai.com/v1/responses\",\"temperature\":\"0\",\"max_tokens\":\"900\",\"monthly_limit\":\"10000\",\"usage_month\":\"2026-08\",\"usage_count\":\"20\",\"auto_import\":\"0\",\"auto_create_customers\":\"0\",\"auto_create_suppliers\":\"0\",\"keep_original_number\":\"1\",\"minimum_confidence\":\"0.85\"}' WHERE `name` = 'ocrmanager'
#327debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'plantillaspdf' LIMIT 1 OFFSET 0;
#328debugUPDATE `settings` SET `name` = 'plantillaspdf', `properties` = '{\"template\":\"Template1\",\"size\":\"A4\",\"orientation\":\"portrait\",\"idlogo\":null,\"logosize\":\"0\",\"logoalign\":\"left\",\"topmargin\":\"0\",\"bottommargin\":\"0\",\"font\":\"AboriginalSansREGULAR\",\"fontsize\":\"0\",\"titlefontsize\":\"0\",\"color1\":\"#FFFFFF\",\"color2\":\"#FFFFFF\",\"color3\":\"#FFFFFF\",\"fontcolor\":\"#FFFFFF\",\"showcustomercode\":\"\",\"showcustomerphones\":\"\",\"showcustomeremail\":\"\",\"shownumero2\":\"\",\"shownumproveedor\":\"\",\"showpaymentdate\":\"\",\"showagent\":\"\",\"showinvoicesketch\":\"\",\"show_parent_documents\":\"\",\"hideshipping\":\"\",\"hidenumberinvoice\":\"\",\"hideserieinvoice\":\"\",\"hideobservations\":\"\",\"hidepaymentmethods\":\"\",\"hidereceipts\":\"\",\"hideexpirationpayment\":\"\",\"print_attachment_document\":\"\",\"linecols\":\"\",\"linecolalignments\":\"\",\"linecoltypes\":\"\",\"linesheight\":\"0\",\"endtext\":\"\",\"endfontsize\":\"0\",\"endalign\":\"left\",\"idimagetext\":null,\"imagetextsize\":\"0\",\"thankstitle\":\"\",\"thankstext\":\"\",\"footertext\":\"\",\"footerfontsize\":\"0\",\"footeralign\":\"left\",\"idimagefooter\":null,\"imagefootersize\":\"0\",\"password\":\"\",\"productimagewidth\":\"0\",\"productimageheight\":\"0\"}' WHERE `name` = 'plantillaspdf'
#329debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'pmsagenteia' LIMIT 1 OFFSET 0;
#330debugUPDATE `settings` SET `name` = 'pmsagenteia', `properties` = '{\"openai_api_key\":\"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\",\"openai_model\":\"gpt-4.1-mini\",\"webhook_token\":\"\",\"whatsapp_enabled\":\"1\",\"email_enabled\":\"1\",\"auto_send_checkin\":\"1\",\"system_prompt\":\"Eres un asistente de recepcion para alojamientos. Responde breve, claro y solo sobre reservas, check-in y cambios basicos.\",\"code\":\"pmsagenteia\",\"webmail_auto_reply\":\"1\",\"webmail_poll_limit\":3}' WHERE `name` = 'pmsagenteia'
#331debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'pmsmanager' LIMIT 1 OFFSET 0;
#332debugUPDATE `settings` SET `name` = 'pmsmanager', `properties` = '{\"twig_hash_pmsscheduler\":\"7b2eddd6d3d7474acba2abd0f3451581\",\"guest_portal_enabled\":\"1\",\"guest_portal_allow_contact_edit\":\"1\",\"guest_portal_allow_cancellation\":\"1\",\"municipality_seed_version\":\"ine_codmun_2026\",\"stable_room_order_version\":\"1\",\"overbooking_marker_version\":\"1\",\"channex_api_key\":\"\",\"backup_channex_api_key\":\"\",\"channex_webhook_token\":\"\",\"backup_channex_webhook_token\":\"\",\"seeded\":true,\"portal_title\":\"Reserva tu estancia\",\"portal_instructions\":\"Elige las fechas de entrada y salida para comprobar disponibilidad en tiempo real.\",\"portal_success\":\"Hemos recibido tu solicitud y te confirmaremos cuanto antes.\",\"portal_primary_color\":\"#2563EB\",\"portal_accent_color\":\"#F97316\",\"portal_background_color\":\"#F8FAFC\",\"portal_payment_mode\":\"redsys\",\"portal_charge_policy\":\"now\",\"portal_deposit_percent\":\"100\",\"portal_rate_adjustment_type\":\"percent_increase\",\"portal_rate_adjustment_value\":\"10\",\"portal_allowed_frame_origins\":\"\",\"portal_card_payment_code\":\"TARJETA\",\"calendar_last_seen_fiz\":\"2026-08-24 11:13:14\",\"calendar_last_seen_hadrian\":\"2026-09-15 08:17:15\",\"auto_arrival_enabled\":\"0\",\"calendar_last_seen_dario\":\"2026-07-31 12:02:28\",\"default_status\":\"pending\",\"portal_woo_api_url\":\"\",\"portal_woo_consumer_key\":\"\",\"portal_woo_consumer_secret\":\"\",\"ses_environment\":null,\"ses_test_property\":\"0\",\"ses_help\":\"\",\"channex_environment\":null,\"channex_base_url\":\"https://staging.channex.io/api/v1\",\"channex_ota_name\":\"Offline\",\"channex_min_interval_ms\":\"200\",\"channex_test_property\":\"0\",\"ota_reservations_paid\":null,\"channex_messages_enabled\":\"Sí\",\"invoice_series\":null,\"invoice_tax\":null,\"checkin_scan_enabled\":\"Sí\",\"housekeeping_enabled\":null,\"seam_enabled\":\"Sí\",\"seam_api_key\":\"seam_test32XE_BTadYcXEkxwbfkEm5KBExBRF\",\"seam_code_length\":\"4\",\"seam_base_url\":\"https://connect.getseam.com\",\"backup_seam_api_key\":\"seam_test32XE_BTadYcXEkxwbfkEm5KBExBRF\",\"seam_help\":null,\"seam_webhook_secret\":\"whsec_JoswzdvxvCa/BrNdJOhzlWQonCU37BLa\",\"dixtpv_sync_enabled\":\"Sí\",\"property_mode\":\"single\",\"portal_tpv_protocol\":null,\"portal_redsys_tpv_id\":null,\"gestorpms_reservations_enabled\":\"1\",\"gestorpms_cleaning_enabled\":\"1\",\"gestorpms_settlements_enabled\":\"0\",\"gestorpms_messages_enabled\":\"1\"}' WHERE `name` = 'pmsmanager'
#333debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'pmsmanager_persistent' LIMIT 1 OFFSET 0;
#334debugUPDATE `settings` SET `name` = 'pmsmanager_persistent', `properties` = '{\"twig_hash_pmsscheduler\":\"7b2eddd6d3d7474acba2abd0f3451581\",\"guest_portal_enabled\":\"1\",\"guest_portal_allow_contact_edit\":\"1\",\"guest_portal_allow_cancellation\":\"1\",\"municipality_seed_version\":\"ine_codmun_2026\",\"stable_room_order_version\":\"1\",\"overbooking_marker_version\":\"1\",\"channex_api_key\":\"\",\"backup_channex_api_key\":\"\",\"channex_webhook_token\":\"\",\"backup_channex_webhook_token\":\"\",\"seeded\":true,\"portal_title\":\"Reserva tu estancia\",\"portal_instructions\":\"Elige las fechas de entrada y salida para comprobar disponibilidad en tiempo real.\",\"portal_success\":\"Hemos recibido tu solicitud y te confirmaremos cuanto antes.\",\"portal_primary_color\":\"#2563EB\",\"portal_accent_color\":\"#F97316\",\"portal_background_color\":\"#F8FAFC\",\"portal_payment_mode\":\"redsys\",\"portal_charge_policy\":\"now\",\"portal_deposit_percent\":\"100\",\"portal_rate_adjustment_type\":\"percent_increase\",\"portal_rate_adjustment_value\":\"10\",\"portal_allowed_frame_origins\":\"\",\"portal_card_payment_code\":\"TARJETA\",\"calendar_last_seen_fiz\":\"2026-08-24 11:13:14\",\"calendar_last_seen_hadrian\":\"2026-09-15 08:17:15\",\"auto_arrival_enabled\":\"0\",\"calendar_last_seen_dario\":\"2026-07-31 12:02:28\",\"default_status\":\"pending\",\"portal_woo_api_url\":\"\",\"portal_woo_consumer_key\":\"\",\"portal_woo_consumer_secret\":\"\",\"ses_environment\":null,\"ses_test_property\":\"0\",\"ses_help\":\"\",\"channex_environment\":null,\"channex_base_url\":\"https://staging.channex.io/api/v1\",\"channex_ota_name\":\"Offline\",\"channex_min_interval_ms\":\"200\",\"channex_test_property\":\"0\",\"ota_reservations_paid\":null,\"channex_messages_enabled\":\"Sí\",\"invoice_series\":null,\"invoice_tax\":null,\"checkin_scan_enabled\":\"Sí\",\"housekeeping_enabled\":null,\"seam_enabled\":\"Sí\",\"seam_api_key\":\"seam_test32XE_BTadYcXEkxwbfkEm5KBExBRF\",\"seam_code_length\":\"4\",\"seam_base_url\":\"https://connect.getseam.com\",\"backup_seam_api_key\":\"seam_test32XE_BTadYcXEkxwbfkEm5KBExBRF\",\"seam_help\":null,\"seam_webhook_secret\":\"whsec_JoswzdvxvCa/BrNdJOhzlWQonCU37BLa\",\"dixtpv_sync_enabled\":\"Sí\",\"property_mode\":\"single\",\"portal_tpv_protocol\":null,\"portal_redsys_tpv_id\":null,\"gestorpms_reservations_enabled\":\"1\",\"gestorpms_cleaning_enabled\":\"1\",\"gestorpms_settlements_enabled\":\"0\",\"gestorpms_messages_enabled\":\"1\"}' WHERE `name` = 'pmsmanager_persistent'
#335debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'portalcliente' LIMIT 1 OFFSET 0;
#336debugUPDATE `settings` SET `name` = 'portalcliente', `properties` = '{\"catalogue_company\":null,\"shop_warehouse\":null,\"shop_document\":\"PedidoCliente\"}' WHERE `name` = 'portalcliente'
#337debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'preciosdinamicos' LIMIT 1 OFFSET 0;
#338debugUPDATE `settings` SET `name` = 'preciosdinamicos', `properties` = '{\"installation_uuid\":\"cc9f6589-df33-4369-a0ee-897bf8288b64\",\"openai_enabled\":false,\"marketfield_enabled\":false,\"property_sync_last_attempt_at\":\"2026-08-24 11:00:02\"}' WHERE `name` = 'preciosdinamicos'
#339debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'proveedoralmacen' LIMIT 1 OFFSET 0;
#340debugUPDATE `settings` SET `name` = 'proveedoralmacen', `properties` = '{\"sales_lines\":true}' WHERE `name` = 'proveedoralmacen'
#341debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'proyectos' LIMIT 1 OFFSET 0;
#342debugUPDATE `settings` SET `name` = 'proyectos', `properties` = '{\"patron\":\"PR-{ANYO}-{NUM}\",\"longnumero\":6,\"burnstock\":0,\"stock\":false}' WHERE `name` = 'proyectos'
#343debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'reservas' LIMIT 1 OFFSET 0;
#344debugUPDATE `settings` SET `name` = 'reservas', `properties` = '{\"portal_title\":\"Reservas online\",\"portal_instructions\":\"Introduce tus datos para solicitar una reserva en uno de nuestros restaurantes.\",\"portal_success_message\":\"Hemos recibido tu solicitud. Te confirmaremos la reserva pronto.\",\"default_warehouse\":\"2\",\"portal_state_id\":\"1\",\"lunch_start\":\"13:00\",\"lunch_end\":\"16:00\",\"dinner_start\":\"20:00\",\"dinner_end\":\"23:30\",\"restaurant_1_name\":\"ALMACEN CAMIÑOS CHANS\",\"restaurant_1_warehouse\":\"1\",\"restaurant_2_name\":\"Cospeito\",\"restaurant_2_warehouse\":\"2\",\"restaurant_3_name\":\"Empresa de Prueba SL\",\"restaurant_3_warehouse\":\"ALG\"}' WHERE `name` = 'reservas'
#345debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'reservasrestaurante' LIMIT 1 OFFSET 0;
#346debugUPDATE `settings` SET `name` = 'reservasrestaurante', `properties` = '{\"default_duration\":120,\"portal_enabled\":true,\"portal_title\":\"Reserva tu mesa\",\"portal_intro\":\"Selecciona restaurante, fecha, hora y número de comensales.\",\"primary_color\":\"#8b1e2d\",\"min_notice_hours\":2,\"max_advance_days\":90,\"slot_minutes\":30,\"max_guests_online\":20,\"deposit_mode\":\"none\",\"deposit_amount\":0,\"deposit_from_guests\":1,\"payment_gateway\":\"none\",\"currency\":\"EUR\",\"auto_confirm_without_deposit\":true,\"privacy_url\":\"\",\"success_text\":\"Hemos recibido tu reserva. Recibirás la confirmación en breve.\"}' WHERE `name` = 'reservasrestaurante'
#347debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'reservatucita' LIMIT 1 OFFSET 0;
#348debugUPDATE `settings` SET `name` = 'reservatucita', `properties` = '{\"show_families\":1,\"show_advanced\":0,\"push_last_dispatch\":\"2026-10-03 05:20:01\",\"push_vapid\":\"{\\\"publicKey\\\":\\\"BBj-c9a8Y4lHxM3yUaN5Jk6_G6Of385XbuW3L8t-C2jO6dumNOOvSG57zYl40F9kCHFuUPudGLP8C8SqXZSEFEc\\\",\\\"privateKey\\\":\\\"ALxGCtQxnBtjeJxupCCT_QJ8joVN7qlqFPiW2VQ7w1U\\\"}\",\"push_subject\":\"https://pruebaslucas.gesdix.com\"}' WHERE `name` = 'reservatucita'
#349debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'revenue' LIMIT 1 OFFSET 0;
#350debugUPDATE `settings` SET `name` = 'revenue', `properties` = '{\"enabled\":\"0\"}' WHERE `name` = 'revenue'
#351debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'rrhh' LIMIT 1 OFFSET 0;
#352debugUPDATE `settings` SET `name` = 'rrhh', `properties` = '{\"journal\":\"1\",\"extra-hours\":\"5\",\"biodevice\":\"0\",\"filtercheckdate\":\"\",\"allowmanual\":\"1\",\"overtime\":null,\"notificationemail\":\"fizdixome@gmail.com\",\"credentialmaxlen\":\"4\",\"inputdelay\":\"0\",\"maxdelay\":\"0\",\"perioddelay\":\"0\",\"allowcomputable\":\"0\",\"minforextra\":\"0\",\"locationgps\":\"\",\"absencealertemail\":\"\",\"absencealertinterval\":\"5\",\"absencealertstate\":\"{\\\"8\\\":{\\\"input\\\":{\\\"date\\\":\\\"2026-02-01\\\",\\\"time\\\":\\\"01-02-2026 20:05:02\\\"}},\\\"9\\\":{\\\"input\\\":{\\\"date\\\":\\\"2026-01-31\\\",\\\"time\\\":\\\"31-01-2026 08:05:01\\\"}},\\\"4\\\":{\\\"input\\\":{\\\"date\\\":\\\"2026-02-05\\\",\\\"time\\\":\\\"05-02-2026 08:25:01\\\"}},\\\"2\\\":{\\\"input\\\":{\\\"date\\\":\\\"2026-01-28\\\",\\\"time\\\":\\\"28-01-2026 11:50:02\\\"}},\\\"11\\\":{\\\"input\\\":{\\\"date\\\":\\\"2026-02-04\\\",\\\"time\\\":\\\"04-02-2026 20:05:01\\\"}},\\\"12\\\":{\\\"input\\\":{\\\"date\\\":\\\"2026-01-30\\\",\\\"time\\\":\\\"30-01-2026 10:00:02\\\"}},\\\"10\\\":{\\\"input\\\":{\\\"date\\\":\\\"2026-02-05\\\",\\\"time\\\":\\\"05-02-2026 08:25:01\\\"}}}\",\"vacationworkdays\":\"1\",\"attendancebackbutton\":\"1\",\"dashboardrequests\":\"1\"}' WHERE `name` = 'rrhh'
#353debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'rrhhrules' LIMIT 1 OFFSET 0;
#354debugUPDATE `settings` SET `name` = 'rrhhrules', `properties` = '{\"rules\":\"nueva regla\"}' WHERE `name` = 'rrhhrules'
#355debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'servicios' LIMIT 1 OFFSET 0;
#356debugUPDATE `settings` SET `name` = 'servicios', `properties` = '{\"mt_dias_escalado\":3}' WHERE `name` = 'servicios'
#357debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'stripe' LIMIT 1 OFFSET 0;
#358debugUPDATE `settings` SET `name` = 'stripe', `properties` = '{\"sks\":\"a:1:{i:0;a:4:{s:4:\\\"name\\\";s:22:\\\"Digitalización Dixome\\\";s:2:\\\"sk\\\";s:107:\\\"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\\\";s:8:\\\"codserie\\\";s:1:\\\"A\\\";s:5:\\\"token\\\";s:32:\\\"e4c8aa5b9295ee58f6b57554ae3104c8\\\";}}\"}' WHERE `name` = 'stripe'
#359debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'tpvredsys' LIMIT 1 OFFSET 0;
#360debugUPDATE `settings` SET `name` = 'tpvredsys', `properties` = '{\"token\":\"438f83938bee837bc75dcaa0a65ea1ceae8e3f21a21a0391\"}' WHERE `name` = 'tpvredsys'
#361debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'verifactu' LIMIT 1 OFFSET 0;
#362debugUPDATE `settings` SET `name` = 'verifactu', `properties` = '{\"send_last_date\":null}' WHERE `name` = 'verifactu'
#363debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'webmailinbox' LIMIT 1 OFFSET 0;
#364debugUPDATE `settings` SET `name` = 'webmailinbox', `properties` = '{\"user\":\"fizdixome@gmail.com\",\"password\":\"roafyhuplzivhevy\",\"host\":\"imap.gmail.com\",\"port\":\"993\",\"enc\":\"ssl\",\"folder\":\"INBOX\",\"imap_validate\":\"\",\"pop_host\":\"pop.gmail.com\",\"pop_port\":\"995\",\"pop_enc\":\"ssl\",\"spam_folder\":\"Spam\"}' WHERE `name` = 'webmailinbox'
#365debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'webmailinbox_legacy' LIMIT 1 OFFSET 0;
#366debugUPDATE `settings` SET `name` = 'webmailinbox_legacy', `properties` = '{\"user\":\"no-reply@dixome.net\",\"password\":\"Acceso1?\",\"host\":\"gesdix-com.correoseguro.dinaserver.com\",\"port\":\"993\",\"enc\":\"ssl\",\"folder\":\"\",\"imap_validate\":\"\"}' WHERE `name` = 'webmailinbox_legacy'
#367debugSHOW COLUMNS FROM `mod_hibernacion_properties`;0.3ms
#368debugSELECT * FROM `settings`
#369debugSHOW COLUMNS FROM `mod_hibernacion_properties`;0.2ms
#370debugSHOW COLUMNS FROM `revenue_sync_logs`;0.3ms
#371debugSHOW COLUMNS FROM `revenue_decisions`;0.3ms
#372debugSELECT * FROM `pages` WHERE `name` IN ('ListGestorPmsCommission','EditGestorPmsCommission','ListGestorPmsDelivery','EditGestorPmsDelivery','ListGestorPmsProperty','EditGestorPmsProperty','ListGestorPmsSettlement','EditGestorPmsSettlement','ListGestorPmsMessage','EditGestorPmsMessage') AND `showonmenu` = TRUE
#373debugSHOW COLUMNS FROM `dixtpv_bonos`;0.3ms
#374debugSHOW COLUMNS FROM `dixtpv_bonos_movimientos`;0.2ms
#375debugSELECT * FROM `empresas` ORDER BY `nombre` ASC
#376debugSHOW COLUMNS FROM `empresas`;0.4ms