| #1 | debug | SELECT * FROM `roles_users` WHERE `codrole` IS NULL | |
| #2 | debug | SELECT * FROM `roles_users` WHERE `codrole` IS NULL | |
| #3 | debug | SELECT * FROM `roles_users` WHERE `codrole` IS NULL | |
| #4 | debug | SELECT * FROM `roles_users` WHERE `codrole` IS NULL | |
| #5 | debug | SELECT * FROM `roles_users` WHERE `codrole` IS NULL | |
| #6 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'default' LIMIT 1 OFFSET 0; | |
| #7 | debug | Begin Transaction | |
| #8 | debug | UPDATE `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\":1771591536,\"telemetrykey\":\"fmfu62aVYtduZG18TrxU\",\"enableupdatesbeta\":\"\",\"comissionposition\":\"modal\",\"columnetosubtotal\":\"subtotal\",\"levelcostsales\":\"0\",\"levelbenefitsales\":\"0\",\"idloginimage\":0,\"tablesize\":\"big\",\"days_log_retention\":\"1\",\"enable_api\":\"\"}' WHERE `name` = 'default' | |
| #9 | debug | Commit Transaction | |
| #10 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'email' LIMIT 1 OFFSET 0; | |
| #11 | debug | UPDATE `settings` SET `name` = 'email', `properties` = '{\"enc\":\"ssl\",\"host\":\"smtp.gmail.com\",\"mailer\":\"smtp\",\"port\":\"465\",\"email\":null}' WHERE `name` = 'email' | |
| #12 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'loginscreen' LIMIT 1 OFFSET 0; | |
| #13 | debug | UPDATE `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' | |
| #14 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'notificaciones' LIMIT 1 OFFSET 0; | |
| #15 | debug | UPDATE `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' | |
| #16 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'plantillaspdf' LIMIT 1 OFFSET 0; | |
| #17 | debug | UPDATE `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' | |
| #18 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'proyectos' LIMIT 1 OFFSET 0; | |
| #19 | debug | UPDATE `settings` SET `name` = 'proyectos', `properties` = '{\"patron\":\"{ANYO}-{MES}{0NUM}\",\"longnumero\":\"3\",\"stock\":\"\",\"burnstock\":\"\"}' WHERE `name` = 'proyectos' | |
| #20 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'richitheme' LIMIT 1 OFFSET 0; | |
| #21 | debug | UPDATE `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' | |
| #22 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'rrhh' LIMIT 1 OFFSET 0; | |
| #23 | debug | UPDATE `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' | |
| #24 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'servicios' LIMIT 1 OFFSET 0; | |
| #25 | debug | UPDATE `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' | |
| #26 | debug | SELECT * FROM `settings` | |