FacturaScripts

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

#1kernel::init0ms28.42kb
#2plugins::init223ms4.17mb
#3kernel::run33ms734.18kb
#1Memory usage5.28mb
#2Memory peak5.61mb
#1StatusConnected
#2Typemysql
#3Version11.8.6-MariaDB-log
#1debugSELECT * FROM `roles_users` WHERE `codrole` IS NULL
#2debugSELECT * FROM `roles_users` WHERE `codrole` IS NULL0.2ms
#3debugSELECT * FROM `roles_users` WHERE `codrole` IS NULL
#4debugSELECT * FROM `roles_users` WHERE `codrole` IS NULL2.8ms
#5debugSELECT * FROM `roles_users` WHERE `codrole` IS NULL
#6debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'AiScan' LIMIT 1 OFFSET 0;
#7debugBegin Transaction
#8debugUPDATE `settings` SET `name` = 'AiScan', `properties` = '{\"enabled\":\"1\",\"default_provider\":\"gemini\",\"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\":\"\",\"gemini_api_key\":\"AIzaSyD23-9gvfoWJRXV8zJqzpeMvTCPtcP0_R8\",\"mistral_api_key\":\"\",\"custom_api_key\":\"\",\"custom_model\":\"\",\"custom_base_url\":\"\",\"additional_prompt\":\"\"}' WHERE `name` = 'AiScan'
#9debugCommit Transaction
#10debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'backup' LIMIT 1 OFFSET 0;
#11debugUPDATE `settings` SET `name` = 'backup', `properties` = '{\"frequency\":\"1 week\",\"weekly_day\":1,\"monthly_day\":1,\"hour\":3}' WHERE `name` = 'backup'
#12debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'default' LIMIT 1 OFFSET 0;
#13debugUPDATE `settings` SET `name` = 'default', `properties` = '{\"codpais\":\"ESP\",\"currency_position\":\"right\",\"item_limit\":\"50\",\"decimals\":\"2\",\"decimal_separator\":\",\",\"thousands_separator\":\" \",\"tipoidfiscal\":\"NIF\",\"codalmacen\":\"ALG\",\"idempresa\":\"1\",\"coddivisa\":\"EUR\",\"codimpuesto\":\"IVA21\",\"codpago\":\"CONT\",\"codserie\":\"A\",\"codserierec\":\"R\",\"updatesupplierprices\":\"1\",\"validate_iban\":\"1\",\"homepage\":\"Dashboard\",\"costpricepolicy\":\"last-price\",\"ventasinstock\":\"\",\"site_url\":\"https://test25.viviendasanaservicios.es\",\"codretencion\":null,\"finofertadays\":\"0\",\"codrole\":\"employee\",\"telemetryinstall\":23463,\"telemetrylastu\":1782279936,\"telemetrykey\":\"fmfu62aVYtduZG18TrxU\",\"enableupdatesbeta\":\"\",\"comissionposition\":\"modal\",\"columnetosubtotal\":\"subtotal\",\"levelcostsales\":\"0\",\"levelbenefitsales\":\"0\",\"idloginimage\":0,\"tablesize\":\"big\",\"days_log_retention\":\"1\",\"enable_api\":\"\"}' WHERE `name` = 'default'
#14debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'email' LIMIT 1 OFFSET 0;
#15debugUPDATE `settings` SET `name` = 'email', `properties` = '{\"enc\":\"ssl\",\"host\":\"smtp.gmail.com\",\"mailer\":\"smtp\",\"port\":\"465\",\"email\":null}' WHERE `name` = 'email'
#16debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'gestoranticipos' LIMIT 1 OFFSET 0;
#17debugUPDATE `settings` SET `name` = 'gestoranticipos', `properties` = '{\"productoanticipo\":\"ANTICIPO\",\"observacionesanticipo\":\"Factura de anticipo correspondiente al [PORCENTAJE] del total del contrato.\",\"serieanticipo\":\"A\",\"recuperar_estado_defecto\":true,\"estadoanticipoven\":\"\",\"estadoanticipocom\":\"\",\"avisoanticipo100\":\"<strong>¡Atención! Anticipo del 100%:</strong> Se generará una factura detallada con todas las líneas de producto. El documento actual no marcará sus líneas como servidas para mantener el ciclo logístico abierto (Albaranes), pero su total quedará contablemente a cero mediante una línea de compensación.\",\"avisoanticipoerror\":\"<strong>¡Error!</strong> El importe del anticipo no puede superar el total pendiente del documento. Por favor, reduzca el importe para continuar.\",\"desc_doc_origen\":\"Compensación de anticipo recibido s/ Factura [CODIGO_FACTURA] pagado mediante [FORMA_PAGO]\",\"desc_factura_anticipo\":\"Anticipo s/ [TIPO_DOC] [CODIGO_ORIGEN] pagado mediante [FORMA_PAGO]\"}' WHERE `name` = 'gestoranticipos'
#18debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'loginscreen' LIMIT 1 OFFSET 0;
#19debugUPDATE `settings` SET `name` = 'loginscreen', `properties` = '{\"login_primary_color\":\"#0424AA\",\"login_background_id\":0,\"login_image_id\":0,\"login_footer_content\":null,\"login_secondary_color\":\"#111C2A\"}' WHERE `name` = 'loginscreen'
#20debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'notificaciones' LIMIT 1 OFFSET 0;
#21debugUPDATE `settings` SET `name` = 'notificaciones', `properties` = '{\"load_notifications_minutes\":3,\"load_chat_seconds\":60,\"sound_notifications\":false,\"update_notices\":true,\"group_sales_estimation\":null,\"group_sales_order\":null,\"group_sales_receipt\":null,\"group_remesas_sepa\":null,\"group_stock\":null,\"group_customer\":null}' WHERE `name` = 'notificaciones'
#22debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'plantillaspdf' LIMIT 1 OFFSET 0;0.7ms
#23debugUPDATE `settings` SET `name` = 'plantillaspdf', `properties` = '{\"bottommargin\":\"20\",\"color1\":\"#2770CA\",\"color2\":\"#FFFFFF\",\"color3\":\"#F1F1F1\",\"endalign\":\"justify\",\"endfontsize\":\"10\",\"endtext\":\"Prueba de como quedaria el texto si se añade una linea para por ejemplo meter el RGPD\",\"font\":\"DejaVuSans\",\"fontcolor\":\"#000000\",\"fontsize\":\"12\",\"footeralign\":\"center\",\"footerfontsize\":\"10\",\"footertext\":\"{PAGENO} / {nbpg}\",\"linecols\":\"descripcion,cantidad,pvpunitario,dtopor,pvptotal,iva,recargo,irpf\",\"linecolalignments\":\"left,right,right,right,right,right,right,right\",\"linecoltypes\":\"text,number2,number,percentage,number,percentage1,percentage1,percentage1\",\"linesheight\":\"400\",\"logoalign\":\"right\",\"logosize\":\"100\",\"orientation\":\"portrait\",\"password\":\"\",\"productimageheight\":\"50\",\"productimagewidth\":\"50\",\"qrbgcolor\":\"#FFFFFF\",\"qrcolor\":\"#000000\",\"qrsize\":80,\"qrtransparent\":1,\"size\":\"A4\",\"thankstext\":\"\",\"thankstitle\":\"\",\"template\":\"TemplateRetencionGarantia\",\"titlefontsize\":\"18\",\"topmargin\":\"50\",\"idlogo\":null,\"showcustomercode\":\"\",\"showcustomerphones\":\"\",\"showcustomeremail\":\"\",\"shownumero2\":\"\",\"shownumproveedor\":\"\",\"showpaymentdate\":\"\",\"showagent\":\"\",\"showinvoicesketch\":\"\",\"show_parent_documents\":\"\",\"hideshipping\":\"\",\"hidenumberinvoice\":\"\",\"hideserieinvoice\":\"\",\"hideobservations\":\"\",\"hidepaymentmethods\":\"\",\"hidereceipts\":\"\",\"hideexpirationpayment\":\"\",\"print_attachment_document\":\"\",\"idimagetext\":null,\"imagetextsize\":\"0\",\"idimagefooter\":null,\"imagefootersize\":\"0\"}' WHERE `name` = 'plantillaspdf'
#24debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'proyectos' LIMIT 1 OFFSET 0;
#25debugUPDATE `settings` SET `name` = 'proyectos', `properties` = '{\"patron\":\"{ANYO}-{MES}{0NUM}\",\"longnumero\":\"3\",\"stock\":\"\",\"burnstock\":\"\",\"reiniciar_patron_anualmente\":\"\",\"reiniciar_patron_mensualmente\":\"1\",\"usar_serie_numerada\":\"1\",\"inicio_numero\":\"11\"}' WHERE `name` = 'proyectos'
#26debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'richitheme' LIMIT 1 OFFSET 0;
#27debugUPDATE `settings` SET `name` = 'richitheme', `properties` = '{\"lbgcolor\":\"#f7f7f7\",\"fbgcolor\":\"#ffffff\",\"lbtncolor\":\"#2770ca\",\"lfoodis\":0,\"lrpdis\":0,\"sbgcolor\":\"#f7f7f7\",\"subbgcolor\":\"#ffffff\",\"itembgcolor\":\"#edf5fc\",\"accentcolor\":\"#000000\",\"lsfile\":\"0\",\"tbgcolor\":\"#ffffffb3\",\"tcndis\":0,\"stxtcolor\":\"#444b52\",\"ttxtcolor\":\"#1a1f36\",\"itxtcolor\":\"#6c757d\",\"uigradient\":\"#2770ca\"}' WHERE `name` = 'richitheme'
#28debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'rrhh' LIMIT 1 OFFSET 0;
#29debugUPDATE `settings` SET `name` = 'rrhh', `properties` = '{\"journal\":\"1\",\"extra-hours\":\"5\",\"biodevice\":\"0\",\"filtercheckdate\":null,\"allowmanual\":\"1\",\"overtime\":null,\"notificationemail\":\"\",\"credentialmaxlen\":\"0\",\"inputdelay\":\"0\",\"maxdelay\":\"0\",\"perioddelay\":\"0\",\"allowcomputable\":\"0\",\"minforextra\":\"0\",\"locationgps\":\"1\"}' WHERE `name` = 'rrhh'
#30debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'servicios' LIMIT 1 OFFSET 0;
#31debugUPDATE `settings` SET `name` = 'servicios', `properties` = '{\"workstatus\":\"0\",\"print_ticket_footer_text\":\"\",\"print_pdf_footer_text\":\"\",\"longnumero\":\"6\",\"patron\":\"SER{ANYO}-{NUM}\",\"new_service_without_machine\":\"1\",\"disablestockmanagement\":\"\",\"print_pdf_machine_info\":\"\",\"print_pdf_observations\":\"\",\"print_pdf_agent\":\"\",\"print_pdf_assigned\":\"\",\"print_pdf_works\":\"\",\"print_pdf_work_reference\":\"\",\"print_pdf_work_description\":\"\",\"print_pdf_work_quantity\":\"\",\"print_pdf_work_price\":\"\",\"print_ticket_machine_info\":\"\",\"print_ticket_observations\":\"\",\"print_ticket_agent\":\"\",\"print_ticket_assigned\":\"\",\"print_ticket_works\":\"\",\"print_ticket_work_reference\":\"\",\"print_ticket_work_description\":\"\",\"print_ticket_work_quantity\":\"\",\"print_ticket_work_price\":\"\",\"document_description\":\"\",\"document_material\":\"\",\"document_solution\":\"\",\"document_observations\":\"\",\"document_start_date\":\"\",\"document_end_date\":\"\",\"document_machine\":\"\"}' WHERE `name` = 'servicios'
#32debugSELECT * FROM `settings`