FacturaScripts

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

#1kernel::init0ms28.42kb
#2plugins::init198ms4.17mb
#3kernel::run37ms756.73kb
#4Controller::html-render28ms472.44kb
#1Memory usage5.3mb
#2Memory peak5.67mb
#1StatusConnected
#2Typemysql
#3Version11.8.6-MariaDB-log
#1debugSELECT * FROM `roles_users` WHERE `codrole` IS NULL
#2debugSELECT * FROM `roles_users` WHERE `codrole` IS NULL
#3debugSELECT * FROM `roles_users` WHERE `codrole` IS NULL
#4debugSELECT * FROM `roles_users` WHERE `codrole` IS NULL
#5debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'AiScan' LIMIT 1 OFFSET 0;1.6ms
#6debugBegin Transaction
#7debugUPDATE `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'
#8debugCommit Transaction
#9debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'backup' LIMIT 1 OFFSET 0;
#10debugUPDATE `settings` SET `name` = 'backup', `properties` = '{\"frequency\":\"1 week\",\"weekly_day\":1,\"monthly_day\":1,\"hour\":3}' WHERE `name` = 'backup'
#11debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'default' LIMIT 1 OFFSET 0;0.6ms
#12debugUPDATE `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'
#13debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'email' LIMIT 1 OFFSET 0;0.2ms
#14debugUPDATE `settings` SET `name` = 'email', `properties` = '{\"enc\":\"ssl\",\"host\":\"smtp.gmail.com\",\"mailer\":\"smtp\",\"port\":\"465\",\"email\":null}' WHERE `name` = 'email'
#15debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'gestoranticipos' LIMIT 1 OFFSET 0;
#16debugUPDATE `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'
#17debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'loginscreen' LIMIT 1 OFFSET 0;
#18debugUPDATE `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'
#19debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'notificaciones' LIMIT 1 OFFSET 0;
#20debugUPDATE `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'
#21debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'plantillaspdf' LIMIT 1 OFFSET 0;
#22debugUPDATE `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'
#23debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'proyectos' LIMIT 1 OFFSET 0;
#24debugUPDATE `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'
#25debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'richitheme' LIMIT 1 OFFSET 0;
#26debugUPDATE `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'
#27debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'rrhh' LIMIT 1 OFFSET 0;
#28debugUPDATE `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'
#29debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'servicios' LIMIT 1 OFFSET 0;
#30debugUPDATE `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'
#31debugSELECT * FROM `settings`