Public scan — anyone with this URL can view this analysis. Sign up to track your own repos privately, run scheduled re-scans, and get AI fix prompts via your dashboard.
Sign up free Scan another repo

carlosmega/erp_constructoras_backend

https://github.com/carlosmega/erp_constructoras_backend · scanned 2026-06-17 01:46 UTC (1 month, 1 week ago)

88 raw signals (0 security + 88 graph)

File as issue Image
UNIFIED Repobility · multi-layer engine · AI coders

Complete repo analysis

Last scanned 1 month, 1 week ago · v2 · last Δ -6.8 (diff) · 73 actionable findings from 1 signal source. 15 repeated signals grouped for readability. Security checks, system graph analysis, and verified AI-agent feedback are merged into one review queue.

JSON
Combined
69.9
/100
Security checks
70
0 findings
System graph
70
88.9% cov · 73 findings
Critical
1
click to filter
Agents
10
0 votes
Crowd
0
reported
Severity distribution — click a segment to filter
Active filters: excluding tests × Reset all
Severity: Critical 1 High 0 Medium 29 Low 36 9-Layer: Software Security Quality Integrity Frontend Hardware Data Network Cicd Source: Security checks 0 System graph 73 Crowd 0 Layer: Software 12 Security 1 Cicd 1 Quality 59
Corpus Intelligence Cross-corpus context (cohort percentile, top patterns, fix plan) is shown only on repositories you own. Sign up and connect your repo to view it.
Scan summary Repository scanned at 69.9/100 with 88.9% coverage. It contains 7081 nodes across 30 cross-layer flows, written primarily in mixed languages. Engine surfaced 88 findings — concentrated in quality (72), software (12), cicd (3). Risk profile is high: 1 critical, 0 high, 29 medium. Recommended next step: open the quality layer findings first — that's where the highest-impact wins live.

Showing 61 of 73 actionable findings. 88 raw detector signals were grouped into reader-sized issues. Click TP / FP to vote on a finding's accuracy — votes adjust the confidence weighting and improve detection across the platform.

critical System graph security Secrets conf 1.00 Possible secret in backend/apps/users/management/commands/setup_e2e_user.py
Detected pattern matching password_literal. Rotate the credential and move to a secret manager.
backend/apps/users/management/commands/setup_e2e_user.py:20
medium System graph quality Agent instructions conf 1.00 Agent instructions exist but release-hardening basics are missing
AI-coder instruction files were found, but the repo is missing license. Treat this as a contract gap: the agent is guided, but the generated output is not yet guarded by the controls that make it repeatable.
Repo hardeningGenerated repo pattern
medium System graph quality Placeholder conf 1.00 Critical user flow still appears backed by mock or placeholder data
A payment/auth/admin/order/billing-style flow contains mock, fake, TODO, dummy, or placeholder markers in runtime source. In the Fable corpus this is a high-leverage completeness smell: the app can look finished while the money, identity, or tenant flow is still scaffolded.
Mock dataCritical flowGenerated repo pattern
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for absence in …` triggers a query per row — backend/apps/agents/engines/attendance_anomaly.py:98
The loop iterates a Django queryset and accesses `absence.attendancedate.strftime` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in …
backend/apps/agents/engines/attendance_anomaly.py:98 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for act in …` triggers a query per row — backend/apps/agents/engines/meeting_prep.py:183
The loop iterates a Django queryset and accesses `act.createdon.isoformat` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 quer…
backend/apps/agents/engines/meeting_prep.py:183 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for assignment in …` triggers a query per row — backend/apps/agents/engines/project_staffing.py:72
The loop iterates a Django queryset and accesses `assignment.projectid.name` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 qu…
backend/apps/agents/engines/project_staffing.py:72 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for bd in …` triggers a query per row — backend/apps/proyeccion/services.py:2112
The loop iterates a Django queryset and accesses `bd.supplyid.supplyid` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries…
backend/apps/proyeccion/services.py:2112 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for bd in …` triggers a query per row — backend/scripts/import_estudio_excel.py:967
The loop iterates a Django queryset and accesses `bd.description.strip` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries…
backend/scripts/import_estudio_excel.py:967 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for bd in …` triggers a query per row — backend/scripts/seed_san_cristobal_fase5.py:95
The loop iterates a Django queryset and accesses `bd.description.strip` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries…
backend/scripts/seed_san_cristobal_fase5.py:95 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for entry in …` triggers a query per row — backend/apps/agents/engines/payroll_validation.py:148
The loop iterates a Django queryset and accesses `entry.employeeid.employeeid` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 …
backend/apps/agents/engines/payroll_validation.py:148 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for exp in …` triggers a query per row — backend/apps/invoiceinbox/services.py:370
The loop iterates a Django queryset and accesses `exp.projectid.name` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries i…
backend/apps/invoiceinbox/services.py:370 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for exp in …` triggers a query per row — backend/apps/invoiceinbox/services.py:388
The loop iterates a Django queryset and accesses `exp.projectid.name` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries i…
backend/apps/invoiceinbox/services.py:388 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for exp in …` triggers a query per row — backend/apps/invoiceinbox/services.py:410
The loop iterates a Django queryset and accesses `exp.projectid.name` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries i…
backend/apps/invoiceinbox/services.py:410 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for log in …` triggers a query per row — backend/apps/agents/engines/audit_compliance.py:171
The loop iterates a Django queryset and accesses `log.timestamp.isoformat` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 quer…
backend/apps/agents/engines/audit_compliance.py:171 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for log in …` triggers a query per row — backend/apps/agents/engines/audit_compliance.py:99
The loop iterates a Django queryset and accesses `log.timestamp.hour` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries i…
backend/apps/agents/engines/audit_compliance.py:99 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for model in …` triggers a query per row — backend/apps/audit/services.py:240
The loop iterates a Django queryset and accesses `model._meta.pk` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries inste…
backend/apps/audit/services.py:240 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for opp in …` triggers a query per row — backend/apps/activities/matching_service.py:282
The loop iterates a Django queryset and accesses `opp.modifiedon.isoformat` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 que…
backend/apps/activities/matching_service.py:282 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for opp in …` triggers a query per row — backend/apps/agents/engines/pipeline_forecast.py:104
The loop iterates a Django queryset and accesses `opp.createdon.date` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries i…
backend/apps/agents/engines/pipeline_forecast.py:104 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for opp in …` triggers a query per row — backend/apps/agents/engines/pipeline_forecast.py:139
The loop iterates a Django queryset and accesses `opp.ownerid.fullname` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries…
backend/apps/agents/engines/pipeline_forecast.py:139 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for order in …` triggers a query per row — backend/core/management/commands/load_dummy_data.py:1293
The loop iterates a Django queryset and accesses `order.name.replace` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries i…
backend/core/management/commands/load_dummy_data.py:1293 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for provision in …` triggers a query per row — backend/apps/agents/engines/provision_reconciliation.py:51
The loop iterates a Django queryset and accesses `provision.createdon.date` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 que…
backend/apps/agents/engines/provision_reconciliation.py:51 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for quote in …` triggers a query per row — backend/core/management/commands/load_dummy_data.py:1231
The loop iterates a Django queryset and accesses `quote.name.replace` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 queries i…
backend/core/management/commands/load_dummy_data.py:1231 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for user in …` triggers a query per row — backend/apps/agents/engines/permission_anomaly.py:154
The loop iterates a Django queryset and accesses `user.securityroleid.name` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 que…
backend/apps/agents/engines/permission_anomaly.py:154 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for user in …` triggers a query per row — backend/apps/agents/engines/permission_anomaly.py:176
The loop iterates a Django queryset and accesses `user.securityroleid.name` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2 que…
backend/apps/agents/engines/permission_anomaly.py:176 N plus onePerformance
medium System graph quality Integrity conf 1.00 Likely N+1 query: `for user in …` triggers a query per row — backend/apps/agents/engines/permission_anomaly.py:94
The loop iterates a Django queryset and accesses `user.lastlogindate.isoformat` per row, which fires an additional database query each iteration. Add `.select_related('<fk_field>')` for FK / O2O relations or `.prefetch_related('<m2m_or_reverse>')` for many-related lookups, to load everything in 1-2…
backend/apps/agents/engines/permission_anomaly.py:94 N plus onePerformance
medium System graph quality Placeholder conf 1.00 Placeholder or mock-heavy implementation detected
Found 18 placeholder/mock markers across 6 source files. This often means the repo looks complete while core flows still use generated scaffolding or fake data.
Mock dataIncompleteGenerated repo pattern
low System graph quality Debug conf 1.00 Debug logging residue appears in source files
Found 276 console/debugger/print-style debug statements in non-test source. This is a common fast-generation residue before production cleanup.
CleanupRepo hardeningGenerated repo pattern
low System graph quality Integrity conf 1.00 Near-duplicate function bodies in 10 places
Functions with the same first-5-line body hash: backend/apps/machinery/schemas.py:resolve_ownername, backend/apps/machinery/schemas.py:resolve_ownername, backend/apps/machinery/schemas.py:resolve_ownername, backend/apps/machinery/schemas.py:resolve_ownername This is *the* AI-coder failure mode (4×…
duplicatesduplication
low System graph quality Integrity conf 1.00 Near-duplicate function bodies in 11 places
Functions with the same first-5-line body hash: backend/apps/opportunities/schemas.py:resolve_state_name, backend/apps/leads/schemas.py:resolve_state_name, backend/apps/leads/schemas.py:resolve_state_name, backend/apps/contacts/schemas.py:resolve_state_name This is *the* AI-coder failure mode (4× …
duplicatesduplication
low System graph quality Integrity conf 1.00 9 occurrences Near-duplicate function bodies in 2 places
Functions with the same first-5-line body hash: backend/scripts/seed_san_cristobal_fase8.py:to_int, backend/scripts/import_estudio_excel.py:to_int This is *the* AI-coder failure mode (4× more duplication in vibe-coded repos — see https://jw.hn/ai-code-hygiene). Consolidate or document why they're …
9 occurrences
repo-level (9 hits)
duplicatesduplication
low System graph quality Integrity conf 1.00 4 occurrences Near-duplicate function bodies in 3 places
Functions with the same first-5-line body hash: backend/scripts/seed_san_cristobal_fase3.py:to_decimal, backend/scripts/seed_san_cristobal_fase2.py:to_decimal, backend/scripts/seed_san_cristobal_fase4.py:to_decimal This is *the* AI-coder failure mode (4× more duplication in vibe-coded repos — see …
4 occurrences
repo-level (4 hits)
duplicatesduplication
low System graph quality Integrity conf 1.00 3 occurrences Near-duplicate function bodies in 4 places
Functions with the same first-5-line body hash: backend/scripts/seed_san_cristobal_fase8.py:read_sheet, backend/scripts/seed_san_cristobal_fase3.py:read_sheet, backend/scripts/seed_san_cristobal_fase4.py:read_sheet, backend/scripts/seed_san_cristobal_fase6.py:read_sheet This is *the* AI-coder fail…
3 occurrences
repo-level (3 hits)
duplicatesduplication
low System graph quality Integrity conf 1.00 Near-duplicate function bodies in 6 places
Functions with the same first-5-line body hash: backend/apps/opportunities/admin.py:save_model, backend/apps/users/admin.py:save_model, backend/apps/contacts/admin.py:save_model, backend/apps/accounts/admin.py:save_model This is *the* AI-coder failure mode (4× more duplication in vibe-coded repos …
duplicatesduplication
low System graph quality Integrity conf 1.00 Near-duplicate function bodies in 8 places
Functions with the same first-5-line body hash: backend/apps/opportunities/schemas.py:resolve_customerid, backend/apps/orders/schemas.py:resolve_customerid, backend/apps/orders/schemas.py:resolve_customerid, backend/apps/quotes/schemas.py:resolve_customerid This is *the* AI-coder failure mode (4× …
duplicatesduplication
low System graph quality License conf 1.00 No license file detected
No LICENSE/COPYING/NOTICE file was found. Generated repositories often omit licensing, which blocks reuse and automated intake.
Repo hardeningGenerated repo pattern
low System graph quality Integrity conf 1.00 Old/deprecated-named symbol `_adapt_v1_to_v2` in backend/apps/proyeccion/versioning.py:28
Names with suffixes like `_old`, `_v1`, `_deprecated` usually indicate replaced-but-not-removed code (typical AI-coder leftover). Confirm and delete, or rename if it's the active version.
old markerDead code
low System graph quality Integrity conf 1.00 Old/deprecated-named symbol `include_copy` in backend/apps/proyeccion/management/commands/import_historical_pu.py:97
Names with suffixes like `_old`, `_v1`, `_deprecated` usually indicate replaced-but-not-removed code (typical AI-coder leftover). Confirm and delete, or rename if it's the active version.
old markerDead code
low System graph quality Integrity conf 1.00 Old/deprecated-named symbol `needs_old` in backend/apps/audit/services.py:232
Names with suffixes like `_old`, `_v1`, `_deprecated` usually indicate replaced-but-not-removed code (typical AI-coder leftover). Confirm and delete, or rename if it's the active version.
old markerDead code
low System graph quality Integrity conf 1.00 Old/deprecated-named symbol `test_create_budget_creates_v1` in backend/apps/corporate/tests/test_services.py:36
Names with suffixes like `_old`, `_v1`, `_deprecated` usually indicate replaced-but-not-removed code (typical AI-coder leftover). Confirm and delete, or rename if it's the active version.
old markerDead code
low System graph quality Integrity conf 1.00 Old/deprecated-named symbol `unpaid_old` in backend/apps/projects/services.py:801
Names with suffixes like `_old`, `_v1`, `_deprecated` usually indicate replaced-but-not-removed code (typical AI-coder leftover). Confirm and delete, or rename if it's the active version.
old markerDead code
low System graph software Dead code conf 1.00 Possibly dead Python function: col_letter_to_idx
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
backend/scripts/seed_san_cristobal_fase6.py:58
low System graph software Dead code conf 1.00 Possibly dead Python function: decorator
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
backend/apps/audit/services.py:207
low System graph software Dead code conf 1.00 Possibly dead Python function: is_num
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
backend/scripts/seed_san_cristobal_fase2.py:50
low System graph software Dead code conf 1.00 Possibly dead Python function: register_agent
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
backend/apps/agents/services.py:36
low System graph software Dead code conf 1.00 Possibly dead Python function: run_fase_1
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
backend/scripts/import_estudio_excel.py:294
low System graph software Dead code conf 1.00 Possibly dead Python function: run_fase_2
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
backend/scripts/import_estudio_excel.py:505
low System graph software Dead code conf 1.00 Possibly dead Python function: run_fase_3
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
backend/scripts/import_estudio_excel.py:718
low System graph software Dead code conf 1.00 Possibly dead Python function: run_fase_4
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
backend/scripts/import_estudio_excel.py:884
low System graph software Dead code conf 1.00 Possibly dead Python function: run_fase_5
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
backend/scripts/import_estudio_excel.py:942
low System graph software Dead code conf 1.00 Possibly dead Python function: run_fase_6
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
backend/scripts/import_estudio_excel.py:1038
low System graph software Dead code conf 1.00 Possibly dead Python function: run_fase_7
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
backend/scripts/import_estudio_excel.py:1121
low System graph software Dead code conf 1.00 Possibly dead Python function: run_fase_8
No callers detected by AST scan in this repo. Could be exported for external callers or a framework handler.
backend/scripts/import_estudio_excel.py:1162
low System graph quality Integrity conf 1.00 Stub function `noop_reverse` (body is just `pass`/`return`) — backend/apps/proyeccion/migrations/0023_unify_external_into_indirect.py:34
Likely an AI scaffold that was never filled in. Remove or implement.
Empty handlerDead code
low System graph quality Complexity conf 1.00 Very large file: backend/apps/products/management/commands/generate_dummy_products.py (1530 lines)
Files with >800 lines often hide complexity hotspots and discourage tests.
low System graph quality Complexity conf 1.00 Very large file: backend/apps/proyeccion/models.py (1803 lines)
Files with >800 lines often hide complexity hotspots and discourage tests.
low System graph quality Complexity conf 1.00 Very large file: backend/apps/proyeccion/routers.py (1777 lines)
Files with >800 lines often hide complexity hotspots and discourage tests.
low System graph quality Complexity conf 1.00 Very large file: backend/apps/proyeccion/services.py (6430 lines)
Files with >800 lines often hide complexity hotspots and discourage tests.
low System graph quality Complexity conf 1.00 Very large file: backend/apps/proyeccion/tests/test_services.py (2162 lines)
Files with >800 lines often hide complexity hotspots and discourage tests.
low System graph quality Complexity conf 1.00 Very large file: backend/core/management/commands/load_dummy_data.py (1545 lines)
Files with >800 lines often hide complexity hotspots and discourage tests.
low System graph quality Complexity conf 1.00 Very large file: backend/core/tests/test_rbac_matrix.py (1198 lines)
Files with >800 lines often hide complexity hotspots and discourage tests.
low System graph quality Complexity conf 1.00 Very large file: backend/scripts/import_estudio_excel.py (1517 lines)
Files with >800 lines often hide complexity hotspots and discourage tests.
For AI agents: Voting guide (TP/FP) MCP manifest Stdio wrapper SARIF Integrate Findings queue Vote TP/FP on findings to calibrate the engine.
For AI agents + API integrations
Email me when this repo regresses
Free. We re-scan periodically; new criticals → your inbox. No signup required for the scan itself.
API access

This page is publicly accessible at: https://repobility.com/scan/92aad080-f5b2-4721-8106-e855af51d25b/

To check status programmatically (no auth required): 

curl -s https://repobility.com/api/v1/public/scan/92aad080-f5b2-4721-8106-e855af51d25b/

Important — please don't re-submit the same URL repeatedly. The submission endpoint is idempotent: re-submitting the same git URL returns this same scan_token, not a new one. To re-scan this repo, sign up free and use the dashboard.