This pull request introduces several improvements to the TemplateState logic in the desktop app and refactors permission handling in the API to enhance maintainability and functionality. Key changes include removing unused code in the TemplateState class, centralizing permission checks with a new utility function, and optimizing database queries for template access.

Desktop App Changes:

• Code Simplification in TemplateState:
  • Removed unused injectDataFunction logic and associated background task handling, simplifying the getTemplates method (apps/desktop/components/tauri-provider/template-state.ts: [1] [2].
  • Adjusted the fetcher call to clean up redundant null assertion (apps/desktop/components/tauri-provider/template-state.ts: apps/desktop/components/tauri-provider/template-state.tsL102-R100).

API Changes:

• Permission Handling Refactor:

  • Introduced a new utility function has_role_permission to centralize permission checks, replacing inline logic across the codebase (packages/api/src/permission/role_permission.rs: [1] packages/api/src/middleware/jwt.rs: [2].
  • Updated imports to include has_role_permission, ensuring consistent usage (packages/api/src/middleware/jwt.rs: [1] packages/api/src/routes/user/templates.rs: [2].

• Database Query Optimization:

  • Improved the query for retrieving user app IDs with template access by reducing redundant filtering and leveraging tuple extraction for efficiency (packages/api/src/routes/user/templates.rs: packages/api/src/routes/user/templates.rsR32-R57).
  • Adjusted the limit parameter handling to use min instead of max for clarity and correctness (packages/api/src/routes/user/templates.rs: packages/api/src/routes/user/templates.rsR32-R57).

• Metadata Fallback Logic:

  • Added an additional fallback to use the first metadata entry if no language match is found (packages/api/src/routes/user/templates.rs: packages/api/src/routes/user/templates.rsR104).… logic