thalysjuvenal/advpl-specialist

ADVPL Code Generation generates new ADVPL and TLPP code for TOTVS Protheus, including functions, classes, MVC screens, REST/SOAP services, reports, jobs, and workflows. Use it when creating new .prw or .tlpp files with required naming and structure rules.

ADVPL Code Review inspects existing ADVPL/TLPP code for best practices, performance, security, and modernization issues. Use it before merge or deploy, or when checking TLPP migration readiness and TOTVS SonarQube rule alignment.

ADVPL Debugging helps diagnose and fix ADVPL/TLPP errors in TOTVS Protheus, including compilation failures, runtime exceptions, locks, slow routines, and AppServer log analysis. Use it when you have an error message, stack trace, or failing routine to investigate.

ADVPL Refactoring helps restructure existing ADVPL/TLPP code without changing behavior. Use it to extract long functions, simplify nested conditionals, remove dead code, improve naming, and reduce duplication or parameter bloat.

ADVPL To TLPP Migration converts legacy ADVPL procedural routines into TLPP classes for TOTVS Protheus. Use it when migrating User Functions and Static Functions to namespaced classes while preserving backward-compatible wrappers.

ADVPR Test Automation helps write, run, and troubleshoot automated regression tests for TOTVS Protheus routines with ADVPR. It covers FWTestHelper, TestSuite setup, headless execution, routine preparation, and common patterns like MVC, ExecAuto, reports, webservices, SmartLink, and Smart View.

Changelog Patterns analyzes ADVPL/TLPP diffs or changed-file lists to generate structured changelogs and delivery notes. It classifies changes, estimates business impact, and detects affected database tables for TOTVS Protheus work.

Code Explanation helps explain existing ADVPL/TLPP routines in plain language for junior developers, senior developers, or functional consultants. Use it to understand legacy code, assess a customization, or fill gaps in documentation.

Documentation Patterns generates Protheus-standard documentation for ADVPL/TLPP code, including Protheus.doc headers, full routine specs, and REST API endpoint docs. Use it when documenting legacy routines, modules, or APIs in TOTVS Protheus.

Embedded SQL helps write, review, and migrate SQL in ADVPL/TLPP using BeginSQL/EndSQL blocks, macro expressions, joins, aggregations, subqueries, and TCSqlExec. Use it when converting TCQuery code or building safer queries with filial and deletion filters.

ProBat Testing covers writing and running TLPP unit, functional, and integration tests with tlppCore’s native ProBat engine. Use it for fixtures, annotations, assertions, setup/teardown, and TDD or CI test workflows.

Protheus Business Processes explains TOTVS Protheus ERP workflows across Compras, Estoque, Faturamento, Financeiro, Contabilidade, Fiscal, PCP, and Manutencao de Ativos. Use it to trace routines, tables, fields, rules, and cross-module integration.

Protheus Locks And Deadlocks explains RecLock, MsUnlock, SoftLock, LockByName, and transaction scoping in Protheus. Use it to diagnose record locks, deadlocks, and lock leaks, or to apply safer lock ordering and BEGIN SEQUENCE/RECOVER patterns.

Protheus Reference is a quick lookup guide for TOTVS Protheus native functions, SX data dictionary tables, MV_* parameters, SX3 field validation, and REST endpoint patterns. Use it to confirm syntax, return values, and restricted/internal-only functions.

Query Builder helps build, choose, and optimize SQL against Protheus ERP tables. It covers DbSeek versus Embedded SQL, mandatory D_E_L_E_T_/xFilial filters, index-aligned WHERE clauses, and parameterized queries for safer cross-database use.

SX Configuration generates and validates Protheus data dictionary scripts for SX2, SX3, SIX, SXG, SXA, SX1, SX5, SXB, and SX7. Use it when creating custom tables, fields, indexes, F3 queries, report questions, or field triggers.

Smart X Development covers building, migrating, and troubleshooting TOTVS Smart X routines that generate PO-UI screens from the data dictionary. It includes the Model, Interface, and Launcher chain plus ADVPL integration and legacy MVC browse migration.

TDN Lookup uses a tiered fallback to find official TOTVS documentation when local ADVPL/TLPP references are incomplete. It checks local caches first, then TDN's REST API, browser automation, web search, and manual site search.