Implement OrangeHRM DAO methods with Doctrine QueryBuilder and Paginator conventions.
npx skills add https://github.com/orangehrm/orangehrm --skill daos
Please help me install this Agent Skill. Skill: daos Source: https://github.com/orangehrm/orangehrm/tree/main/.agents/skills/daos Command: npx skills add https://github.com/orangehrm/orangehrm --skill daos
OrangeHRM enforces a strict, consistent data access pattern across all its plugins, and deviating from this pattern leads to inconsistent code, performance bugs (especially with joined queries and pagination), and avoidable errors like SQL injection or incorrect transaction handling. This Skill eliminates the guesswork by providing a complete reference for the project's standard DAO implementation practices.
<Name>Dao classes extending BaseDao, the EntityManagerHelperTrait method catalog, and the full lifecycle of DAO methods from API request to data return.Paginator for accurate counts on joined queries, QueryBuilderWrapper for returning buildable query builders, and explicit transaction management for multi-step atomic writes.Use the daos skill to write a new DAO method that retrieves a paginated list of job titles filtered by name, with accurate total count for the UI.
High-intent search queries and answers about installing and using this skill.
To write a paginated, filtered list endpoint in OrangeHRM, implement a custom DAO method using Doctrine QueryBuilder with expression builders for filtering and the Paginator class to retrieve accurate total counts for joined queries.
Joined query counts in OrangeHRM return incorrect totals due to duplicate rows from JOIN operations. Use Doctrine's Paginator class to compute accurate counts by handling join duplication properly instead of counting raw query results directly.
To manage atomic multi-step database writes in OrangeHRM, wrap the operations within explicit transaction boundaries provided by the EntityManagerHelperTrait to ensure data consistency and rollback on failure.
The standard OrangeHRM DAO pattern involves creating plugin-specific classes extending BaseDao, utilizing the EntityManagerHelperTrait, and using QueryBuilderWrapper to return buildable query objects safely.
Prevent SQL injection in OrangeHRM QueryBuilder queries by applying safe parameter binding practices, passing all user inputs through Doctrine's parameter binding methods rather than concatenating strings into DQL statements.
Use a custom QueryBuilder query in OrangeHRM when you need complex conditional joins, filtered pagination, or partial DTO projections for blob columns, and rely on simple repository lookups only for basic primary key fetches.
orangehrmConfigure Doctrine ORM 2.20 EntityManager and entity discovery in OrangeHRM.
AutomatticIntegrate the ActivityPub plugin with WordPress plugins via hooks and filters.
orangehrmStandardize OrangeHRM REST API v2 endpoint implementation and maintenance.
MacPhobosEnforce EspoCRM architectural patterns for custom module development.