公开记录中等
软件健康报告模式 0.26.0 · 指标 1.13.0 · 2026-07-22 18:04 UTC
kirschbaum-development / eloquent-power-joins
The Laravel magic you know, now applied to joins.
kirschbaum-development/eloquent-power-joins 的健康指数为 100 分中的 63 分，处于「中等」区间。 其得分最高的类别是Community & Adoption（77/100），最低的是Security（34/100）。 最近一次更新在 54 天前。 近期的大部分工作由 1 位贡献者完成。
63
总分 / 100软件健康指数
指标归入加权类别，统一采用 1–100 量表。总体分先取类别加权平均；当公开证据触发高风险司法辖区政策时，评级会按政策调整，并设置 49（有风险）的上限。AI 就绪度不计入总体分。
63
优秀85-100堪称典范；基本满足所有检验标准
良好70-84健康；仅有轻微不足
中等50-69可接受，但存在明显不足；建议进行审查
存在风险30-49存在重大薄弱环节；采用时应保持审慎
危急1-29问题严重（项目被弃置、仅有单一维护者、缺乏基本工程规范）
评分画像
每条轴代表一个类别。形状比平均值更重要——健康的对象会填满整个图形，而“一峰一谷”式画像意味着某一维度的优势正掩盖另一维度的风险。
所有权
软件包生态系统
| 注册表 | 软件包 | 版本 | 月下载量 | 版本数 | 最近发布 | 标签 |
|---|---|---|---|---|---|---|
| Packagist | kirschbaum-development/eloquent-power-joins | 4.3.2 | 2,922,088 | 78 | 54 天前 | mysqllaraveljoineloquent |
按类别列示的指标
活力
项目是否仍有生命——是否仍在编写代码，是否仍在发布版本？
60
开发活跃度
34存在风险
评分方式
| 18/36 | 推送新近度 — 最近一次推送于 54 天前 |
| 5.5/36 | 提交节奏 — 52 周中有 8 周有提交 |
| 9/18 | 提交量 — 最近一年 9 次提交 |
| 1/10 | OpenSSF Scorecard：Maintained — 1 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 1 |
所用输入
| commits_last_year | 9 |
| human_commit_share | 1 |
| days_since_last_push | 54 |
| active_weeks_last_year | 8 |
发布纪律
100优秀
评分方式
| 27/27 | 有发布版本 — 已发布 71 个发布版本 |
| 36/36 | 发布时效 — 最近一次发布版本于 54 天前 |
| 27/27 | 发布节奏 — 约每 35.8 天发布一次 |
| 0/10 | OpenSSF Scorecard：Signed-Releases — 无数据 |
所用输入
| releases_count | 71 |
| latest_release_tag | 4.3.2 |
| releases_from_tags | 否 |
| days_since_latest_release | 54 |
| mean_days_between_releases | 35.8 |
已排除计分（无数据或不适用）：OpenSSF Scorecard：Signed-Releases。 其余权重已重新归一化。
社区与采用
项目是否拥有用户、下载量与关注度，并具备欢迎贡献者参与的配置？
77
流行度与采用
76良好
评分方式
| 51.8/60 | 星标 — 1,571 个星标 |
| 16.7/25 | 复刻 — 102 个复刻 |
| 8/15 | 关注者 — 28 位关注者 |
所用输入
| forks | 102 |
| stars | 1,571 |
| watchers | 28 |
| growth_state | unverified |
| growth_factor_pct | 100 |
| growth_unverified_reason | no_history |
社区健康
70良好
评分方式
| 22.5/22.5 | README |
| 22.5/22.5 | 许可证 — 可识别的许可证（MIT） |
| 18/18 | CONTRIBUTING 指南 |
| 0/13.5 | 行为准则 |
| 0/7.2 | 议题模板 |
| 0/6.3 | PR 模板 |
所用输入
| has_readme | 是 |
| has_license | 是 |
| has_contributing | 是 |
| has_issue_template | 否 |
| has_code_of_conduct | 否 |
| has_pull_request_template | 否 |
生态采用（下载量）
90优秀
评分方式
| 80/80 | 月度下载量 — packagist 合计每月 2,922,088 次下载 |
| 10.4/20 | 注册表被依赖数 — 35 个软件包依赖它 |
所用输入
| packages | kirschbaum-development/eloquent-power-joins |
| dependents | 35 |
| ecosystems | packagist |
| total_downloads | 34,766,417 |
| monthly_downloads | 2,922,088 |
可持续性与治理
项目能否在其成员之外延续——巴士系数、响应能力、由谁支持，以及软件包的维护状况？
68
维护者韧性（巴士系数）
37存在风险
评分方式
| 9/54 | 巴士系数 — 1 位贡献者贡献了半数提交 |
| 4.8/22.5 | 提交分布 — 头号贡献者编写了 79% 的提交 |
| 13.5/13.5 | 贡献者广度 — 35 位贡献者 |
| 10/10 | OpenSSF Scorecard：Contributors — project has 4 contributing companies or organizations |
所用输入
| bus_factor | 1 |
| contributors_sampled | 35 |
| top_contributor_share | 0.788 |
议题与 PR 响应能力
78良好
评分方式
| 43.1/46.8 | 议题解决 — 92% 的议题已关闭 |
| 30.5/38.3 | PR 接受 — 已裁定的 PR 中 83/104 已合并 |
| 4.5/15 | OpenSSF Scorecard：Code-Review — Found 11/30 approved changesets -- score normalized to 3 |
所用输入
| merged_prs | 83 |
| open_issues | 10 |
| closed_issues | 118 |
| issue_closed_ratio | 0.922 |
| closed_unmerged_prs | 21 |
所有权与托管责任
70良好
评分方式
| 30/30 | 所有权背书 — 组织持有 |
| 0/20 | 已验证域名 |
| 15.8/25 | 所有者影响力 — kirschbaum-development 有 159 位关注者 |
| 24.4/25 | 既往记录 — 49 个公开仓库，账户约 8 年 |
所用输入
| followers | 159 |
| owner_type | Organization |
| is_verified | — |
| owner_login | kirschbaum-development |
| public_repos | 49 |
| account_age_days | 3,106 |
软件包维护
100优秀
评分方式
| 25/25 | 已发布且可解析 — packagist 上有 1 个软件包 |
| 35/35 | 发布时效 — 最近一次发布于 54 天前 |
| 20/20 | 版本历史 — 78 个已发布版本 |
| 20/20 | 未被弃用 — 活跃，未被弃用或撤回 |
所用输入
| packages | kirschbaum-development/eloquent-power-joins |
| ecosystems | packagist |
| any_deprecated | 否 |
| min_days_since_publish | 54 |
工程质量
基础的工程与文档实践是否到位？
71
工程实践
78良好
评分方式
| 24/24 | CI 工作流 — 2 个工作流 |
| 24/24 | 存在测试 |
| 16/16 | Linter 配置 — .php-cs-fixer.php |
| 0/9.6 | Pre-commit 钩子 |
| 6.4/6.4 | .editorconfig |
| 8/20 | OpenSSF Scorecard：CI-Tests — 10 out of 21 merged PRs checked by a CI test -- score normalized to 4 |
所用输入
| has_ci | 是 |
| has_tests | 是 |
| has_editorconfig | 是 |
| has_linter_config | 是 |
| has_precommit_config | 否 |
文档
60中等
评分方式
| 30/30 | README |
| 0/25 | 文档目录 |
| 0/15 | 文档 / 主页站点 |
| 10/10 | 仓库描述 |
| 10/10 | 主题标签 — 3 个主题标签 |
| 10/10 | Wiki |
所用输入
| topics | hacktoberfest, laravel, php |
| has_wiki | 是 |
| homepage | — |
| has_readme | 是 |
| has_docs_dir | 否 |
| has_description | 是 |
安全
可见的安全与供应链实践是否稳固，且不存在未解决的高风险司法辖区暴露？
34
安全态势
34存在风险
评分方式
| 7.5/7.5 | Binary-Artifacts — no binaries found in the repo |
| 0/7.5 | Branch-Protection — branch protection not enabled on development/release branches |
| 1/2.5 | CI-Tests — 10 out of 21 merged PRs checked by a CI test -- score normalized to 4 |
| 0/2.5 | CII-Best-Practices — no effort to earn an OpenSSF best practices badge detected |
| 2.2/7.5 | Code-Review — Found 11/30 approved changesets -- score normalized to 3 |
| 2.5/2.5 | Contributors — project has 4 contributing companies or organizations |
| 0/10 | Dangerous-Workflow — 无数据 |
| 0/7.5 | Dependency-Update-Tool — no update tool detected |
| 0/5 | Fuzzing — project is not fuzzed |
| 2.5/2.5 | 许可证 — license file detected |
| 0.8/7.5 | Maintained — 1 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 1 |
| 0/5 | Packaging — 无数据 |
| 0/5 | Pinned-Dependencies — 无数据 |
| 0/5 | SAST — SAST tool is not run on all commits -- score normalized to 0 |
| 0/5 | Security-Policy — security policy file not detected |
| 0/7.5 | Signed-Releases — 无数据 |
| 0/7.5 | Token-Permissions — 无数据 |
| 7.5/7.5 | Vulnerabilities — 0 existing vulnerabilities detected |
所用输入
| source | openssf_scorecard |
| checks_evaluated | 13 |
| scorecard_version | v5.5.0 |
| checks_inconclusive | 5 |
| scorecard_aggregate | 3.4 |
已排除计分（无数据或不适用）：dangerous_workflow, packaging, pinned_dependencies, signed_releases, token_permissions。 其余权重已重新归一化。
AI 就绪度
该仓库在多大程度上具备与 AI 编码代理协同开发与维护的条件？这是一枚独立的实验性徽章——权重为 0.0，因此单独呈现，不影响总体健康评分。
53
AI 代理上下文与指引
74良好
评分方式
| 45/45 | 代理指令 — AGENTS.md |
| 0/15 | 机器可读文档（llms.txt） |
| 28.8/40 | 可读的提交历史 — 100 次人类提交中有 54 次说明了意图（结构化标题或解释性正文） |
所用输入
| has_llms_txt | 否 |
| legible_history_share | 0.54 |
| agent_instruction_files | AGENTS.md |
| agent_instruction_max_bytes | 1,115 |
验证循环（构建 / 测试 / 类型检查）
37存在风险
评分方式
| 0/18 | 一条命令的引导启动 |
| 22/22 | 自动化测试 |
| 11/11 | Lint / 格式化配置 — .php-cs-fixer.php |
| 0/11 | 静态类型检查 |
| 0/10 | 可复现环境 |
| 0/10 | 已体现的代理实践 — 最近 100 次提交中没有代理编写的提交 |
| 0/8 | 自动化维护 — 未观察到自动依赖更新 |
| 0/10 | OpenSSF Scorecard：Pinned-Dependencies — 无数据 |
所用输入
| has_nix | 否 |
| has_tests | 是 |
| lockfiles | — |
| has_dockerfile | 否 |
| typed_language | 否 |
| bootstrap_files | — |
| has_devcontainer | 否 |
| has_linter_config | 是 |
| typecheck_configs | — |
| agent_commit_share | 0 |
| toolchain_manifests | — |
| dependency_bot_commit_share | 0 |
已排除计分（无数据或不适用）：OpenSSF Scorecard：Pinned-Dependencies。 其余权重已重新归一化。
面向模型的代码可读性
55中等
评分方式
| 0/45 | 可类型检查的代码 — PHP，未配置类型检查 |
| 55/55 | 可控的文件大小 — 采样的 58 个源文件中有 0 个超过 60KB |
所用输入
| primary_language | PHP |
| largest_source_bytes | 35,930 |
| source_files_sampled | 58 |
| oversized_source_files | 0 |
关键数据
1,571GitHub 星标
35贡献者
9最近 12 个月提交数
54距最近推送天数
71发布版本数
1巴士系数（bus factor）
10开放议题
Packagist软件包生态系统数
数据采集警告
- Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token
- No resolved dependencies carried a version and a supported ecosystem
更多细节
Star 与 Fork 历史 0 ★ / 102 ⇿
0Star
102Fork
70发布
每颗 star 和每个 fork 的添加时间，来自 GitHub 并按天汇总。累计增长位于其构成来源——每日新增——的正上方，二者可相互对照：稳定的自然增长与短暂的突增形态截然不同。当这一差别可被衡量时，它会作为增长真实性予以报告。
主版本 3次版本 15修订 52
每个点涵盖 6 天。
OpenSSF Scorecard 3.4 / 10
3.4综合
来自开源项目 OpenSSF Scorecard 的独立、工具无关的安全评估。每项检查奖励的是安全实践本身，而非特定供应商的工具。Scorecard 无法判定的检查项标记为 不适用，并从安全评分中剔除（绝不按零分计）。
| 10 | Binary-Artifacts | no binaries found in the repo |
| 0 | Branch-Protection | branch protection not enabled on development/release branches |
| 4 | CI-Tests | 10 out of 21 merged PRs checked by a CI test -- score normalized to 4 |
| 0 | CII-Best-Practices | no effort to earn an OpenSSF best practices badge detected |
| 3 | Code-Review | Found 11/30 approved changesets -- score normalized to 3 |
| 10 | Contributors | project has 4 contributing companies or organizations |
| 不适用 | Dangerous-Workflow | no workflows found |
| 0 | Dependency-Update-Tool | no update tool detected |
| 0 | Fuzzing | project is not fuzzed |
| 10 | License | license file detected |
| 1 | Maintained | 1 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 1 |
| 不适用 | Packaging | packaging workflow not detected |
| 不适用 | Pinned-Dependencies | no dependencies found |
| 0 | SAST | SAST tool is not run on all commits -- score normalized to 0 |
| 0 | Security-Policy | security policy file not detected |
| 不适用 | Signed-Releases | no releases found |
| 不适用 | Token-Permissions | No tokens found |
| 10 | Vulnerabilities | 0 existing vulnerabilities detected |
直接依赖 2
| 注册表 | 软件包 | 版本约束 | 清单文件 |
|---|---|---|---|
| Packagist | illuminate/support | ^11.42|^12.0|^13.0 | composer.json |
| Packagist | illuminate/database | ^11.42|^12.0|^13.0 | composer.json |
全部依赖 7
来自 GitHub 依赖图的完整解析依赖集合：2 个直接依赖与 5 个间接（传递）软件包。仓库提交锁文件时，传递闭包才是完整的。
| 注册表 | 软件包 | 版本 | 关系 |
|---|---|---|---|
| Packagist | illuminate/database | — | 直接 |
| Packagist | illuminate/support | — | 直接 |
| Packagist | friendsofphp/php-cs-fixer | — | 间接 |
| Packagist | laravel/legacy-factories | — | 间接 |
| Packagist | orchestra/testbench | — | 间接 |
| Packagist | php | — | 间接 |
| Packagist | phpunit/phpunit | — | 间接 |
依赖安全公告 未评估
本报告未能完成公告比对：No resolved dependencies carried a version and a supported ecosystem
原始 JSON 报告 机器可读
{
"data": {
"repo": {
"topics": [
"hacktoberfest",
"laravel",
"php"
],
"is_fork": false,
"size_kb": 603,
"has_wiki": true,
"homepage": null,
"languages": {
"PHP": 208477
},
"pushed_at": "2026-05-28T20:36:23Z",
"created_at": "2020-03-17T00:32:57Z",
"owner_type": "Organization",
"updated_at": "2026-07-21T21:44:48Z",
"description": "The Laravel magic you know, now applied to joins.",
"is_archived": false,
"is_disabled": false,
"license_spdx": "MIT",
"default_branch": "master",
"license_spdx_raw": "MIT",
"primary_language": "PHP",
"significant_languages": [
"PHP"
]
},
"owner": {
"blog": "https://kirschbaumdevelopment.com",
"name": "Kirschbaum Development Group, LLC",
"type": "Organization",
"login": "kirschbaum-development",
"company": null,
"location": "Northampton, MA",
"followers": 159,
"avatar_url": "https://avatars.githubusercontent.com/u/35586907?v=4",
"created_at": "2018-01-19T03:07:23Z",
"is_verified": null,
"public_repos": 49,
"account_age_days": 3106
},
"license": {
"state": "standard",
"spdx_id": "MIT",
"raw_spdx": "MIT",
"file_present": true,
"scorecard_found": true,
"profile_has_license": true
},
"activity": {
"releases": [
{
"tag": "4.3.2",
"kind": "patch",
"published_at": "2026-05-28T20:36:23Z"
},
{
"tag": "4.3.1",
"kind": "patch",
"published_at": "2026-03-29T12:05:30Z"
},
{
"tag": "4.3.0",
"kind": "minor",
"published_at": "2026-03-17T16:43:27Z"
},
{
"tag": "4.2.11",
"kind": "patch",
"published_at": "2025-12-17T00:38:10Z"
},
{
"tag": "4.2.10",
"kind": "patch",
"published_at": "2025-11-13T14:58:23Z"
},
{
"tag": "4.2.9",
"kind": "patch",
"published_at": "2025-10-25T11:39:34Z"
},
{
"tag": "4.2.8",
"kind": "patch",
"published_at": "2025-08-14T18:43:30Z"
},
{
"tag": "4.2.7",
"kind": "patch",
"published_at": "2025-08-06T10:46:36Z"
},
{
"tag": "4.2.6",
"kind": "patch",
"published_at": "2025-07-10T16:55:51Z"
},
{
"tag": "4.2.5",
"kind": "patch",
"published_at": "2025-07-10T15:27:08Z"
},
{
"tag": "4.2.4",
"kind": "patch",
"published_at": "2025-05-19T14:15:00Z"
},
{
"tag": "4.2.3",
"kind": "patch",
"published_at": "2025-04-01T14:42:15Z"
},
{
"tag": "4.2.2",
"kind": "patch",
"published_at": "2025-03-08T01:26:21Z"
},
{
"tag": "4.2.1",
"kind": "patch",
"published_at": "2025-03-05T10:11:54Z"
},
{
"tag": "4.2.0",
"kind": "minor",
"published_at": "2025-02-13T23:30:54Z"
},
{
"tag": "4.1.0",
"kind": "minor",
"published_at": "2025-02-12T11:14:57Z"
},
{
"tag": "4.0.1",
"kind": "patch",
"published_at": "2024-11-26T13:22:27Z"
},
{
"tag": "4.0.0",
"kind": "major",
"published_at": "2024-10-06T12:34:28Z"
},
{
"tag": "3.5.8",
"kind": "patch",
"published_at": "2024-09-10T10:28:25Z"
},
{
"tag": "3.5.7",
"kind": "patch",
"published_at": "2024-06-26T13:11:09Z"
},
{
"tag": "3.5.6",
"kind": "patch",
"published_at": "2024-04-09T00:35:55Z"
},
{
"tag": "3.5.5",
"kind": "patch",
"published_at": "2024-03-27T11:14:31Z"
},
{
"tag": "3.5.4",
"kind": "patch",
"published_at": "2024-03-26T19:21:08Z"
},
{
"tag": "3.5.3",
"kind": "patch",
"published_at": "2024-03-26T10:43:58Z"
},
{
"tag": "3.5.2",
"kind": "patch",
"published_at": "2024-03-20T10:23:43Z"
},
{
"tag": "3.5.1",
"kind": "patch",
"published_at": "2024-03-19T22:46:06Z"
},
{
"tag": "3.5.0",
"kind": "minor",
"published_at": "2024-02-13T15:40:41Z"
},
{
"tag": "3.4.0",
"kind": "minor",
"published_at": "2023-12-07T10:45:10Z"
},
{
"tag": "3.3.4",
"kind": "patch",
"published_at": "2023-12-07T10:39:55Z"
},
{
"tag": "3.3.3",
"kind": "patch",
"published_at": "2023-10-31T18:02:25Z"
},
{
"tag": "3.3.2",
"kind": "patch",
"published_at": "2023-10-29T00:53:20Z"
},
{
"tag": "3.3.1",
"kind": "patch",
"published_at": "2023-10-28T13:49:05Z"
},
{
"tag": "3.3.0",
"kind": "minor",
"published_at": "2023-10-22T13:04:40Z"
},
{
"tag": "3.2.4",
"kind": "patch",
"published_at": "2023-09-12T17:07:54Z"
},
{
"tag": "3.2.3",
"kind": "patch",
"published_at": "2023-09-04T10:22:18Z"
},
{
"tag": "3.2.2",
"kind": "patch",
"published_at": "2023-08-28T10:27:36Z"
},
{
"tag": "3.2.1",
"kind": "patch",
"published_at": "2023-07-30T02:16:23Z"
},
{
"tag": "3.2.0",
"kind": "minor",
"published_at": "2023-06-25T11:42:28Z"
},
{
"tag": "3.1.1",
"kind": "patch",
"published_at": "2023-06-20T13:50:44Z"
},
{
"tag": "3.1.0",
"kind": "minor",
"published_at": "2023-06-15T10:44:47Z"
},
{
"tag": "3.0.3",
"kind": "patch",
"published_at": "2023-06-04T12:21:20Z"
},
{
"tag": "3.0.2",
"kind": "patch",
"published_at": "2023-03-16T14:41:57Z"
},
{
"tag": "3.0.1",
"kind": "patch",
"published_at": "2023-03-07T15:59:05Z"
},
{
"tag": "3.0.0",
"kind": "major",
"published_at": "2023-03-05T12:22:03Z"
},
{
"tag": "2.7.3",
"kind": "patch",
"published_at": "2023-03-05T11:19:55Z"
},
{
"tag": "2.7.2",
"kind": "patch",
"published_at": "2023-02-08T11:00:04Z"
},
{
"tag": "2.7.1",
"kind": "patch",
"published_at": "2023-02-05T11:15:25Z"
},
{
"tag": "2.7.0",
"kind": "minor",
"published_at": "2023-01-23T11:04:52Z"
},
{
"tag": "2.6.5",
"kind": "patch",
"published_at": "2022-12-09T10:31:51Z"
},
{
"tag": "2.6.4",
"kind": "patch",
"published_at": "2022-04-06T22:58:53Z"
},
{
"tag": "2.6.3",
"kind": "patch",
"published_at": "2022-03-05T19:16:22Z"
},
{
"tag": "2.6.2",
"kind": "patch",
"published_at": "2022-03-05T18:40:14Z"
},
{
"tag": "2.6.1",
"kind": "patch",
"published_at": "2022-02-15T01:13:46Z"
},
{
"tag": "2.6.0",
"kind": "minor",
"published_at": "2022-02-09T13:37:42Z"
},
{
"tag": "2.5.2",
"kind": "patch",
"published_at": "2022-02-06T13:13:13Z"
},
{
"tag": "2.5.1",
"kind": "patch",
"published_at": "2021-11-18T17:09:34Z"
},
{
"tag": "2.5.0",
"kind": "minor",
"published_at": "2021-10-24T23:01:30Z"
},
{
"tag": "2.4.1",
"kind": "patch",
"published_at": "2021-08-30T10:20:15Z"
},
{
"tag": "2.4.0",
"kind": "minor",
"published_at": "2021-04-18T22:41:13Z"
},
{
"tag": "2.3.3",
"kind": "patch",
"published_at": "2021-04-07T12:22:10Z"
},
{
"tag": "2.3.2",
"kind": "patch",
"published_at": "2020-12-29T19:21:24Z"
},
{
"tag": "2.3.1",
"kind": "patch",
"published_at": "2020-12-22T16:03:12Z"
},
{
"tag": "2.3.0",
"kind": "minor",
"published_at": "2020-11-28T15:07:08Z"
},
{
"tag": "2.2.3",
"kind": "patch",
"published_at": "2020-10-30T18:46:37Z"
},
{
"tag": "2.2.2",
"kind": "patch",
"published_at": "2020-10-24T01:05:14Z"
},
{
"tag": "2.2.1",
"kind": "patch",
"published_at": "2020-10-14T19:26:38Z"
},
{
"tag": "2.2.0",
"kind": "minor",
"published_at": "2020-10-09T00:38:30Z"
},
{
"tag": "2.1.0",
"kind": "minor",
"published_at": "2020-09-10T23:50:51Z"
},
{
"tag": "2.0.0",
"kind": "major",
"published_at": "2020-08-30T14:37:30Z"
},
{
"tag": "1.1.1",
"kind": "patch",
"published_at": "2020-05-14T22:14:18Z"
},
{
"tag": "1.1.0",
"kind": "minor",
"published_at": "2020-04-13T13:26:19Z"
}
],
"recent_commits": [
{
"oid": "33c189bd51a510c1ceba67222395ead08a29863a",
"body": "performJoinForEloquentPowerJoinsForMorph used $this->parent->getTable()\ndirectly, ignoring any alias set via StaticCache. All other join methods\nalready use StaticCache::getTableOrAliasForModel($this->parent) for this.\n\nCo-authored-by: Marick van Tuil <marick@dolphiq.nl>",
"is_bot": false,
"headline": "bugfix: use parent table alias in MorphOneOrMany join (#236)",
"author_name": "Marick van Tuil",
"author_login": "marickvantuil",
"committed_at": "2026-05-28T20:35:55Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3f77b096c1e8b5aa1fc40d7080e55e795f3430ae",
"body": "* Added failing test\n\n* Fix joinRelationship overriding columns passed to get()/first()\n\nDefer the default select('table.*') to a beforeQuery callback so it\nonly fires when no explicit columns have been set by query execution\ntime. This allows columns passed to get()/first() to take precedence\nvia L\n[…]\nchanism.\n\nAlso adds explicit select guards in orderByPowerJoins and\nperformHavingForEloquentPowerJoins which use selectRaw internally\nand need the base table columns present.\n\nFixes #229\n\n* Code style",
"is_bot": false,
"headline": "Fix joinRelationship overriding columns in get()/first() (#233)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2026-03-29T12:05:03Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "dbf2dfaa1900152f2e3dc42b30b67f67a82e7c36",
"body": "* because we don't want to version idea\n\n* laravel 13 support\n\n* bump legacy factories\n\n* Fix CI failures for PHPUnit 12 and PHP-CS-Fixer\n- Remove unnecessary else after return in PowerJoinClause::where\n- Add test_ prefix to LaravelScopeAttributeTest method (PHPUnit 12 dropped @test annotation discovery)\n- Update phpunit.xml.dist to use PHPUnit 10+ config format",
"is_bot": false,
"headline": "Laravel 13 support (#232)",
"author_name": "Babacar Cissé Dia",
"author_login": "babacarcissedia",
"committed_at": "2026-03-17T16:43:01Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0e3e3372992e4bf82391b3c7b84b435c3db73588",
"body": null,
"is_bot": false,
"headline": "Added PHP 8.5 support (#227)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2025-12-17T00:37:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a42cf9d6ab7f8c39e46056832d86b727643f8f89",
"body": "* Added failing test\n\n* Fixed fromRaw\n\n* Fixed tests",
"is_bot": false,
"headline": "Fix: TypeError with fromRaw() when using alias from 'from' method (#226)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2025-12-17T00:30:26Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ccda351a75701f5b0a6f94586d9a40f1114302b4",
"body": "* Added a failing test\n\n* Fixed usage of alias coming from the 'from' method",
"is_bot": false,
"headline": "Using alias from the 'from' method when set (#224)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2025-11-13T14:57:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "32ec75ffee5f8f66e2c95e4030fa0b2454e51048",
"body": "…able twice (#222)",
"is_bot": false,
"headline": "fix alias not applying in \"through\" joins when referencing the same t…",
"author_name": "Henrik",
"author_login": "henrik0804",
"committed_at": "2025-10-25T11:39:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d67c7e2efa886d2ef8bb29e86c3ddb9438ac6390",
"body": "* Update .gitattributes\n\n* Update .gitattributes",
"is_bot": false,
"headline": "Exclude files (#221)",
"author_name": "Bert",
"author_login": "bert-w",
"committed_at": "2025-08-14T18:43:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f2f8d3575a54d91b3e5058d65ac1fccb3ea7dd94",
"body": "…s (#217)\n\n* Added failing test\n\n* Added ability to call scoped method via attributes\n\n* Removed FKs 🤢\n\n* Made method public\n\n* wip",
"is_bot": false,
"headline": "Add support for Laravel scope attributes in joinRelationship callback…",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2025-08-06T10:46:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "72cff1e838bb3f826dc09a5566219ad7fa56237f",
"body": "…e times (#214)\n\n* Fix duplicate alias generation when joining same relationship multiple times\n\nReplace time() with uniqid() in generateAliasForRelationship() to ensure unique aliases are generated even when called multiple times within the same second. This prevents later joins from overwriting ea\n[…]\n Fix test to be database-agnostic for MySQL compatibility\n\nUpdate alias count check to handle both double quotes (PostgreSQL/SQLite) and backticks (MySQL) when counting table aliases in generated SQL.",
"is_bot": false,
"headline": "Fix duplicate alias generation when joining same relationship multipl…",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2025-07-10T16:55:34Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "96e1a061ab97f36afb8ccfcd6c02b07f702d36e6",
"body": "…(#213)\n\n* Added failing test\n\n* Fix latestOfMany relationships using wrong foreign key in subqueries\n\nWhen using leftJoinRelationship with latestOfMany relationships that have custom foreign keys, the generated subquery was incorrectly using the parent model's primary key instead of the relationshi\n[…]\n[opencode](https://opencode.ai)\n\nCo-Authored-By: opencode <noreply@opencode.ai>\n\n* wip\n\n* Changed min stability to stable\n\n* Fixed code style\n\n---------\n\nCo-authored-by: opencode <noreply@opencode.ai>",
"is_bot": false,
"headline": "Fix latestOfMany relationships using wrong foreign key in subqueries …",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2025-07-10T15:26:42Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "63f0aeb6301488ab9956f2d38d168b8bdeee0aff",
"body": null,
"is_bot": false,
"headline": "Run tests",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2025-07-09T16:07:29Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4a8012cef7abed8ac3633a180c69138a228b6c4c",
"body": "…s (#210)\n\nCo-authored-by: Marick van Tuil <marick@dolphiq.nl>",
"is_bot": false,
"headline": "Correct 'through' relation alias, add missing alias to morph relation…",
"author_name": "Marick van Tuil",
"author_login": "marickvantuil",
"committed_at": "2025-05-19T14:14:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d04e06b12e5e7864c303b8a8c6045bfcd4e2c641",
"body": null,
"is_bot": false,
"headline": "Merging casts when cloning (#208)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2025-04-01T14:41:56Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f91ef1b6311d7cccbec20cd08ed6250f07cd98d8",
"body": null,
"is_bot": false,
"headline": "Updating to use L12 stable version",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2025-04-01T11:29:06Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a307fab78c291526fba754e6ac8a86f7bd58d45d",
"body": "* Fix alias not fully applying in has one/many through\n\n* Fix tes\n\n---------\n\nCo-authored-by: Marick van Tuil <marick@Mac.home>",
"is_bot": false,
"headline": "Fix alias not fully applying in has one/many through (#205)",
"author_name": "Marick van Tuil",
"author_login": "marickvantuil",
"committed_at": "2025-03-08T01:26:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "84a24784d9abde8bafb1998a0841a6bc10fa6f8e",
"body": "* add failing test case\n\n* do not skip soft delete wheres when using alias\n\n* fix tests\n\n* linter",
"is_bot": false,
"headline": "fix: include soft delete conditions when using named aliases (#204)",
"author_name": "luisvdbk",
"author_login": "luisvdbk",
"committed_at": "2025-03-05T10:11:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b092366fd69edd81da8b1b7da73160ff18806d8a",
"body": null,
"is_bot": false,
"headline": "Update README.md",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2025-02-27T11:08:57Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "aafbe349e0ad4862273880652d0141bb753c4fc7",
"body": "* Testing on Laravel 12\r\n\r\n* wip\r\n\r\n* wip\r\n\r\n* wip",
"is_bot": false,
"headline": "Laravel 12 official support (#203)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2025-02-13T23:30:29Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ee219efc978803726633299b952d2b23b8bcbbd0",
"body": "* Fix relationship already joined cache\r\n\r\n* Revert \"Fix relationship already joined cache\"\r\n\r\nThis reverts commit ed09eea525a55f357ef00c662f60f9041dac061f.\r\n\r\n* WIP\r\n\r\n* Working WIP\r\n\r\n* Working\r\n\r\n* WIP\r\n\r\n* Update JoinRelationshipTest.php\r\n\r\n* WIP\r\n\r\n* WIP\r\n\r\n* WIP\r\n\r\n* WIP\r\n\r\n* WIP\r\n\r\n* WIP\r\n\r\n*\n[…]\nw\r\n\r\n* WIP\r\n\r\n* Update JoinsHelper.php\r\n\r\n* WIP\r\n\r\n* Update JoinsHelper.php\r\n\r\n* Executing the queries to make sure they work in tests\r\n\r\n---------\r\n\r\nCo-authored-by: Luís Dalmolin <luis.nh@gmail.com>",
"is_bot": false,
"headline": "Fix: relationship join cache with query clones (#202)",
"author_name": "Ralph J. Smit",
"author_login": "ralphjsmit",
"committed_at": "2025-02-13T23:18:28Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "d6c5cb1b90c0bd033a8f9159a78fd6a23e9ac5c2",
"body": "* Fix relatedKey for BelongsToMany relationship\r\n\r\n* Add slugPosts relationship and related tests for Group model\r\n\r\n* Change post_slug column type from unsignedInteger to string in post_groups_slug table\r\n\r\n---------\r\n\r\nCo-authored-by: Luís Dalmolin <luis.nh@gmail.com>",
"is_bot": false,
"headline": "Fix relatedKey for BelongsToMany relationship (#196)",
"author_name": "Kadir Gün",
"author_login": "kadirgun",
"committed_at": "2025-02-12T11:14:14Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "cc592470ece5faf556cd73d3622698273e28de02",
"body": "* Updated CI config\r\n\r\n* Updated cache version\r\n\r\n* Added --default-authentication-plugin=mysql_native_password to MySQL\r\n\r\n* Revert that\r\n\r\n* wip\r\n\r\n* Removing PHP 8.1\r\n\r\n* Added php 8.4\r\n\r\n* Added Laravel 12",
"is_bot": false,
"headline": "Update CI config; PHP 8.4 full support; (#201)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2025-02-11T20:36:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "aeaf359c06ac850dd0de07d8fc4dd15b09e98737",
"body": null,
"is_bot": false,
"headline": "Updated CI config",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2025-02-11T18:47:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "98bb3eb24e7a28792ed3c6e07e2df69588f707c3",
"body": null,
"is_bot": false,
"headline": "fix: typo in docs (#199)",
"author_name": "Daniel",
"author_login": "danielgnh",
"committed_at": "2025-02-05T14:02:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3c1af9b86b02f1e39219849c1d2fee7cf77e8638",
"body": "… #191 (#192)",
"is_bot": false,
"headline": "Add extra condition to avoid wrong on clause on MorphTo joins, closes…",
"author_name": "Sébastien JEAN",
"author_login": "sebj54",
"committed_at": "2024-11-26T13:22:08Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a01958a522d4a0e5e84bbb7ccf008c8c83f904b7",
"body": null,
"is_bot": false,
"headline": "Temporary revert",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2024-11-17T19:55:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "bd8681969b4b79a370f41e2ed0a4bf69f5abbe4e",
"body": null,
"is_bot": false,
"headline": "Using the actual php version on tests",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2024-10-21T17:09:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c6c42a52c5a097cc11761e72782b2d0215692caf",
"body": null,
"is_bot": false,
"headline": "Removed deprecated methods from stubs",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2024-10-06T12:28:14Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "470a34eaa59b6bc633653ddf6d26d204cba39716",
"body": null,
"is_bot": false,
"headline": "Code style adjustments",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2024-10-06T12:26:30Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "13308c00f26527234ef6be32ff2968dcdf5f2451",
"body": null,
"is_bot": false,
"headline": "Updated readme",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2024-10-06T12:19:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3da344597a09107ffa7f655f10b1dec075e7f5d4",
"body": null,
"is_bot": false,
"headline": "Adjusted stubs",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2024-10-06T12:17:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "98127656bad90c580500b58e9321e715a619f9d8",
"body": null,
"is_bot": false,
"headline": "Types and stubs",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2024-10-03T14:13:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "013c4fef432345b751a6b3da941b80070146ec3b",
"body": "feat: add cs fixer",
"is_bot": false,
"headline": "Merge pull request #165 from GeoSot/feat/gs/add-cs-fixer",
"author_name": "Dan Harrin",
"author_login": "danharrin",
"committed_at": "2024-10-02T20:31:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "257ddeebad43410d27fb954a99ec8ccb59e01b9f",
"body": null,
"is_bot": false,
"headline": "Run formatter",
"author_name": "Dan Harrin",
"author_login": "danharrin",
"committed_at": "2024-10-02T20:29:57Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "03257fb04dbbe3b75915e44f61151053c8e6ef4f",
"body": null,
"is_bot": false,
"headline": "Merge branch 'master' into pr/165",
"author_name": "Dan Harrin",
"author_login": "danharrin",
"committed_at": "2024-10-02T20:27:52Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "090faa7c46a96a372fa45f3a8d2b31aaa5a8fa4e",
"body": null,
"is_bot": false,
"headline": "Update .php-cs-fixer.php",
"author_name": "Dan Harrin",
"author_login": "danharrin",
"committed_at": "2024-10-02T20:27:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ae86d14abd4f9c3498c7b2206fa54a5d93509815",
"body": null,
"is_bot": false,
"headline": "add config file on ci",
"author_name": "GeoSot",
"author_login": "GeoSot",
"committed_at": "2024-10-02T20:26:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f2cd0af3e2918547c127ba7ea6a1ba455d027d69",
"body": null,
"is_bot": false,
"headline": "add config file on ci",
"author_name": "GeoSot",
"author_login": "GeoSot",
"committed_at": "2024-10-02T20:26:49Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a5ee29cae5cb24fac91642c8224388977b5f5dba",
"body": "* Update README.md\r\n\r\nDocumentation for join type in joinRelationship()\r\n\r\n* Possibility to indicate join type for each relation in joinRelationship callbacks:\r\n\r\n User::joinRelationship('posts.comments', [\r\n 'posts' => function ($join) {\r\n $join->where('posts.published', true);\r\n },\r\n \n[…]\no be changed for pull request.\r\n\r\n* Code style\r\n\r\n* Fixed tests\r\n\r\n* Removed test\r\n\r\n---------\r\n\r\nCo-authored-by: Dima Kamynin <dima@ociohoteles.com>\r\nCo-authored-by: Luís Dalmolin <luis.nh@gmail.com>",
"is_bot": false,
"headline": "Join type in nested sub-relations (#104)",
"author_name": "dmikam",
"author_login": "dmikam",
"committed_at": "2024-10-02T20:15:40Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "3e820ba0a406f3913872c14927ce77b37462503a",
"body": "* Allow to join nested MorphTo relations\r\n\r\n* Add test for joining nested MorphTo relations",
"is_bot": false,
"headline": "Allow to join nested MorphTo relations (#180)",
"author_name": "Aztek-Johan",
"author_login": "Aztek-Johan",
"committed_at": "2024-10-02T19:51:25Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "a0d2aec84abb03bc75b47163abd79fc498641665",
"body": "* wip\r\n\r\n* wip\r\n\r\n* Update OrderByTest.php\r\n\r\n* Fixed hasOneOfMany for MySQL and Postgres\r\n\r\n* Removed readme\r\n\r\n* Handling left joins in one of many\r\n\r\n* Add phpunit.xml to gitignore\r\n\r\n* Remove support for unsupported PHP/Laravel versions\r\n\r\n* Remove DB setup in test case\r\n\r\n* Add CI jobs for test\n[…]\nate JoinRelationshipTest.php\r\n\r\n* Update 2020_03_16_000000_create_tables.php\r\n\r\n* Dropped PowerJoins trait\r\n\r\n* Removed PowerJoins traits\r\n\r\n---------\r\n\r\nCo-authored-by: Dan Harrin <git@danharrin.com>",
"is_bot": false,
"headline": "Enhance and test support for PostgreSQL (#189)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2024-10-02T19:46:23Z",
"body_truncated": true,
"is_coding_agent": false
},
{
"oid": "397ef08f15ceff48111fd7f57d9f1fd41bf1a453",
"body": null,
"is_bot": false,
"headline": "Support HasOneThrough (#187)",
"author_name": "Amando",
"author_login": "AmandoVledder",
"committed_at": "2024-09-10T10:28:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "aeae41d6600dea972e9e6dc2bdb8812c787e7567",
"body": "The link to the more detailed blog post is broken as the link has changed.",
"is_bot": false,
"headline": "Update README.md (#185)",
"author_name": "Richard Howes",
"author_login": "richardhowes",
"committed_at": "2024-07-10T21:13:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3f57b398117d97bae4dfd5c37ea0f8f48f296c97",
"body": "…rectly (#183)",
"is_bot": false,
"headline": "Using model scopes instead of checking the soft delete scope trait di…",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2024-06-26T13:09:29Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6de51d9ec43af34e77bd1d9908173de1416a0aed",
"body": null,
"is_bot": false,
"headline": "Added calling of the queries to ensure test coverage",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2024-04-09T00:35:30Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "c430a7705e837faab5eeaca49c90650c28c2387e",
"body": null,
"is_bot": false,
"headline": "Allow pass relationship aliases to orderByPowerJoins (#179)",
"author_name": "Luis Andrés Arce C",
"author_login": "luilliarcec",
"committed_at": "2024-04-09T00:31:59Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1c656e69f04600f8360010bedd87d489d3e417cd",
"body": null,
"is_bot": false,
"headline": "Update README.md",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2024-03-27T11:17:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ed5af4788f0dad3ce35bb883cecac4293496139a",
"body": null,
"is_bot": false,
"headline": "Set model in eloquent builder",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2024-03-27T11:14:14Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fc8bb379f062cd120ffab20a6913ad824c3366d8",
"body": "…the joins",
"is_bot": false,
"headline": "Added the ability to call methods from custom eloquent builders from …",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2024-03-26T19:12:33Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4b948b1682ef565aa367e3a651ae69fe37b0f400",
"body": null,
"is_bot": false,
"headline": "Replacing dots in table definition alias to avoid issues with postgres",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2024-03-26T10:38:51Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2fae3aca9eefd4591603a7e53406ab9f56b69fad",
"body": "…: 7 ERROR\" #172 (#174)",
"is_bot": false,
"headline": "Fixed: Upgrading from 3.2.1 to 3.5.0 produces error \"Undefined column…",
"author_name": "Vedmant",
"author_login": "vedmant",
"committed_at": "2024-03-20T10:23:27Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "571f09c4b23c349cb1a5db8bb88af291ed30389c",
"body": null,
"is_bot": false,
"headline": "fix: allow non nested joins to specify pivot information (#173)",
"author_name": "Alexandru Bucur",
"author_login": "CoolGoose",
"committed_at": "2024-03-19T22:45:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "01e70ed600570d7b91d1f21f445b2890e7b753d6",
"body": null,
"is_bot": false,
"headline": "Update README.md",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2024-03-01T19:48:30Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "13feb3692ab6c0475b2c05de131d5f5822fb250a",
"body": "* Laravel 11 support\r\n\r\n* wip",
"is_bot": false,
"headline": "Laravel 11 support (#169)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2024-02-13T15:40:14Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9238fcb53d777265ee9d8d139810e2cadecde079",
"body": null,
"is_bot": false,
"headline": "PHP 8.3 support (#166)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-12-07T10:44:41Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "4718c937275e8a2428976cffd341a598ab420d2a",
"body": null,
"is_bot": false,
"headline": "Making sure PowerJoinClause can be type-hinted",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-12-07T10:38:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "06ab09cea917d0ff1ddee9ce24f186d6158f7ad7",
"body": null,
"is_bot": false,
"headline": "feat: add cs fixer",
"author_name": "GeoSot",
"author_login": "GeoSot",
"committed_at": "2023-11-02T10:52:30Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e55fa70dfa4a5e897443454825b9d4ce6081786a",
"body": "* Fixes to avoid passing null values to qualiyColumn method\r\n\r\n* Fixed test\r\n\r\n* Removed debug code",
"is_bot": false,
"headline": "Issue 160: Avoid calling internal methods with `null` (#164)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-10-31T18:01:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9ffa7d4f9e50f427e751f0cb5a090f3433ed5c6c",
"body": null,
"is_bot": false,
"headline": "Removed trait PowerJoins set up",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-10-30T19:47:22Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "260f8d24306ec1731bd270104f0bc3655c4dbd32",
"body": null,
"is_bot": false,
"headline": "Added ability to use array callbacks in nested powerJoinWhereHas (#163)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-10-29T00:53:00Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "52a1282c0938fd5396a7bf970e6a0a8c56c8f560",
"body": "* Added support for powerJoinHas with MorphTo relationships\r\n\r\n* Readme addition",
"is_bot": false,
"headline": "Added support for powerJoinHas with MorphTo relationships (#162)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-10-28T13:48:46Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "2cb2d8763d55ef9d1e7362232d1404681cc8e895",
"body": null,
"is_bot": false,
"headline": "Removed unused function",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-10-26T22:48:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9dd336b17cca5c82315365c5323895297fc35037",
"body": null,
"is_bot": false,
"headline": "Added support for morphTo (#158)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-10-22T13:00:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "d1054e647e45fd21afbe483212b47ce288cb1705",
"body": null,
"is_bot": false,
"headline": "Fixed test name",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-09-12T20:24:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "fadc20d436b0693a34c4b611d07954818e46eb4d",
"body": null,
"is_bot": false,
"headline": "Clear the joins cache before starting a join",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-09-12T17:02:05Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e9d936e0071d47796735b40ed6cce5dfd0a4305d",
"body": null,
"is_bot": false,
"headline": "Update RelationshipsExtraMethods.php (#154)",
"author_name": "s-7777",
"author_login": "s-7777",
"committed_at": "2023-09-04T10:21:44Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "23650f7707e25190511ab15b22a95e3a32ad277b",
"body": null,
"is_bot": false,
"headline": "Change alias generation for aggregate sort functions (#152)",
"author_name": "Luis Andrés Arce C",
"author_login": "luilliarcec",
"committed_at": "2023-08-28T10:27:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e92329b3d89c0e56e0ae32ba76e332f1848769a0",
"body": null,
"is_bot": false,
"headline": "Fixed clone of queries that were duplicating joins",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-07-30T02:14:27Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ef388b6b6ae1502fac172b8beb6f13ffe541569b",
"body": "* Added support for hasOne()->ofMany()\r\n\r\n* Improved tests; Added additional check:",
"is_bot": false,
"headline": "Feature: Has one of many support (#141)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-06-25T11:42:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f8187582bcc87e951c91ed2e07fd53c3182a98f6",
"body": "* ref: add `as` method docblock to FakeJoinCallback\r\n\r\n* ref: add StaticCache methods and make consistent usage of them",
"is_bot": false,
"headline": "Ref: use methods accessing StaticCache (#139)",
"author_name": "GeoSot",
"author_login": "GeoSot",
"committed_at": "2023-06-25T11:06:58Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "24af544ca28dd3300e9ee74e4b041da01818c4b1",
"body": null,
"is_bot": false,
"headline": "feat: support for statically added closure global scopes (#140)",
"author_name": "Billy",
"author_login": null,
"committed_at": "2023-06-20T13:50:15Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "0eb823dd3e5630acabd89caae2c8df4c1fd7bfb7",
"body": "Co-authored-by: Bruno Lopes <bruno.lrocha@americanas.io>",
"is_bot": false,
"headline": "adds where has belongs to many test (#138)",
"author_name": "Bruno Lopes",
"author_login": "lopesrbruno",
"committed_at": "2023-06-19T19:52:57Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e20600bcf0bcd978888baf0bfcf5edd4ebbe8842",
"body": "Co-authored-by: Bruno Lopes <bruno.lrocha@americanas.io>",
"is_bot": false,
"headline": "fix morph to many (#137)",
"author_name": "brunolopesr",
"author_login": "lopesrbruno",
"committed_at": "2023-06-15T10:43:02Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "7b4c6b7b9977fd9ca98b7403dadfcda3bd93434f",
"body": "* ref: Move PowerJoins Trait to JoinRelationship Mixin\r\n\r\n* fix(caching): each builder instance must have its own cache",
"is_bot": false,
"headline": "Move PowerJoins Trait to JoinRelationship Mixin (#135)",
"author_name": "GeoSot",
"author_login": "GeoSot",
"committed_at": "2023-06-15T10:41:04Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "85ff7684a25049aee6a1c9e26a751ce5be60d6d9",
"body": null,
"is_bot": false,
"headline": "Fixed morph relationships using alias",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-06-04T12:19:28Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b9aa4c2364e2776e5aacca49160d4b519ae82768",
"body": "…n name (#127)\n\n* Fix many to many nested\r\n\r\n* check with dots if is already replaced\r\n\r\n---------\r\n\r\nCo-authored-by: Alex Osendi <alejandro.osendi@doubledot.es>",
"is_bot": false,
"headline": "Fix nested many to many alias, allow callbacks using the full relatio…",
"author_name": "Runig006",
"author_login": "Runig006",
"committed_at": "2023-03-16T14:41:20Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "6b312354b99695d864edad2fc4aeeb0cdaf30128",
"body": "…onship",
"is_bot": false,
"headline": "Fixed join of multiple nested relationships with the same base relati…",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-03-07T15:57:57Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "92ce06ef916c5426fa6c8d3c6692a17b1112e3ff",
"body": "* Updated version compatibility\r\n\r\n* Fixed usage of ->as alias on BelongsToMany relationships",
"is_bot": false,
"headline": "Fixed usage of ->as alias on BelongsToMany relationships (#124)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-03-05T12:21:13Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "14eb8de38e30ce8f7323beb45800673467567f56",
"body": "* wip\r\n\r\n* wip\r\n\r\n* wip\r\n\r\n* wip",
"is_bot": false,
"headline": "Fix tests by using Composer v2 (#123)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-03-05T11:19:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f02079962b0bd48a39ffc4980c30fc7748cc9289",
"body": null,
"is_bot": false,
"headline": "Updated test versions",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-03-02T18:04:31Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "179ed3ba61bcd37ebd5711e1fc01c46569631b95",
"body": null,
"is_bot": false,
"headline": "Using composer v2",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-03-02T18:03:36Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "76f6ed5844af2dc1bafef251398d488fdf992841",
"body": null,
"is_bot": false,
"headline": "Update PowerJoinClause.php (#122)",
"author_name": "Runig006",
"author_login": "Runig006",
"committed_at": "2023-03-02T17:59:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "9db3de5c4be225d9fd19676c4219ec39c4d0e003",
"body": "* Fixes for nested where conditions in join clauses\r\n\r\n* Fixed other use cases",
"is_bot": false,
"headline": "Fixes for nested where conditions in join clauses (#119)",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-02-08T10:57:50Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "54c290c932e9f6bc41d4a8bc330de67456fb306f",
"body": null,
"is_bot": false,
"headline": "Code style adjustments",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-02-05T11:14:16Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f620a93350953543a67909f1536e6e39240afbd5",
"body": "* Encapsulate nested conditions inside a where function\r\n\r\n* More complex nested condition test",
"is_bot": false,
"headline": "Encapsultate nested conditions inside a where statement (#116)",
"author_name": "toyi",
"author_login": "toyi",
"committed_at": "2023-02-05T11:13:09Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "be1b04e754db238e0e07a18ae595cd7594c68a1d",
"body": null,
"is_bot": false,
"headline": "Added Laravel 10 support",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2023-01-23T11:00:47Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "b3c95fc63535c59a7fb98ea3e86947078f3f3154",
"body": "* Laravel 10.x support\r\n\r\n* exclude laravel 7 8 from php 8.2",
"is_bot": false,
"headline": "Laravel 10.x support (#115)",
"author_name": "Ngô Quốc Đạt",
"author_login": "datlechin",
"committed_at": "2023-01-23T10:57:06Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3efd1f4850da899b02067d84b135022374f83215",
"body": null,
"is_bot": false,
"headline": "Changed Github badge",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2022-12-16T14:38:18Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "e69c88349f89639a8d83f66741a2b31cf6baba4d",
"body": "* Allow macros calls on JoinClause\r\n\r\n* Fix variable name for macro\r\n\r\n* Fixing the formatting\r\n\r\nCo-authored-by: Luís Dalmolin <luis.nh@gmail.com>\r\n\r\nCo-authored-by: Luís Dalmolin <luis.nh@gmail.com>",
"is_bot": false,
"headline": "Allow Macro calls on JoinClause (#112)",
"author_name": "glamax13",
"author_login": "glamax13",
"committed_at": "2022-12-09T10:31:12Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "ad4ce611a67b60780507fb52eee7d62c810cd0ef",
"body": "…g_polymorphic_relationships_in_readme\n\nFix class name in Joining polymorphic relationships section of Readme",
"is_bot": false,
"headline": "Merge pull request #108 from kirschbaum-development/fix/update_joinin…",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2022-08-24T14:22:24Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "eb56b2095ed5b0277eca85091d3df2343febf44f",
"body": null,
"is_bot": false,
"headline": "Fix class name in Joining polymorphic relationships section of Readme",
"author_name": "Fabian Alvarez",
"author_login": "fabalv",
"committed_at": "2022-08-24T00:44:43Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "5285a670d5aa04db12317016247119da447e6196",
"body": "Improve docs and tests on joins with a intermediate table",
"is_bot": false,
"headline": "Merge pull request #103 from marickvantuil/master",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2022-06-23T01:20:19Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "1035dfca918963c7484c0c67a79ed1cb8fae55e9",
"body": null,
"is_bot": false,
"headline": "Improve docs and tests on joins with a intermediate table",
"author_name": "Marick van Tuil",
"author_login": "marickvantuil",
"committed_at": "2022-06-22T19:48:48Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "98e0ecc6844014a0169115ebea9985a89bbc61f2",
"body": "Fixed using withTrashed and having an alias on a join clause",
"is_bot": false,
"headline": "Merge pull request #97 from jonneroelofs/jr_fix_wheres_become_collection",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2022-04-06T22:58:03Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "3eef220c1c6b3c9b55b6c372d3f088c08a698c0d",
"body": "…ame time.\n\nAdded a test.",
"is_bot": false,
"headline": "Fixed using withTrashed and having an alias on a join clause at the s…",
"author_name": "jonneroelofs",
"author_login": "jonneroelofs",
"committed_at": "2022-04-06T07:47:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "f66789d6468280a4cef136056ceae177476c3cb4",
"body": null,
"is_bot": false,
"headline": "Addded Laravel 9 badge",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2022-03-06T01:37:17Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "71ffabe68e8c6de0b04f9b6904636d0d323a732e",
"body": null,
"is_bot": false,
"headline": "Added additional test",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2022-03-06T01:03:55Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "704a3835ff4eb2cb8c66c8d69cbfd0a604a83a1f",
"body": "Fixes for PHP 8.1 and Laravel 9",
"is_bot": false,
"headline": "Merge pull request #93 from kirschbaum-development/laravel-9-php-81",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2022-03-05T19:14:37Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "98c60cf9d56bb0802fa8d97288c365bd138a9bc4",
"body": null,
"is_bot": false,
"headline": "Fixed for PHP 8.1 and Laravel 9",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2022-03-05T19:07:32Z",
"body_truncated": false,
"is_coding_agent": false
},
{
"oid": "11a252145f953ec106c56160b3771b03f0afdccb",
"body": "Potential Fix: Using `joinRelationship` on the same base relationship(s)",
"is_bot": false,
"headline": "Merge pull request #92 from kirschbaum-development/fix-issue-90",
"author_name": "Luís Dalmolin",
"author_login": "luisdalmolin",
"committed_at": "2022-03-05T18:39:07Z",
"body_truncated": false,
"is_coding_agent": false
}
],
"releases_count": 71,
"commits_last_year": 9,
"latest_release_at": "2026-05-28T20:36:23Z",
"latest_release_tag": "4.3.2",
"releases_from_tags": false,
"days_since_last_push": 54,
"active_weeks_last_year": 8,
"days_since_latest_release": 54,
"mean_days_between_releases": 35.8
},
"community": {
"has_readme": true,
"has_license": true,
"has_description": true,
"has_contributing": true,
"health_percentage": 50,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"ecosystem": {
"packages": [
{
"name": "kirschbaum-development/eloquent-power-joins",
"exists": true,
"license": "MIT",
"keywords": [
"mysql",
"laravel",
"join",
"eloquent"
],
"ecosystem": "packagist",
"matches_repo": true,
"registry_url": "https://packagist.org/packages/kirschbaum-development/eloquent-power-joins",
"is_deprecated": false,
"latest_version": "4.3.2",
"repository_url": "https://github.com/kirschbaum-development/eloquent-power-joins",
"versions_count": 78,
"total_downloads": 34766417,
"dependents_count": 35,
"deprecation_note": null,
"maintainers_count": null,
"monthly_downloads": 2922088,
"first_published_at": null,
"latest_published_at": "2026-05-28T20:35:55Z",
"latest_version_yanked": null,
"days_since_latest_publish": 54
}
]
},
"popularity": {
"forks": 102,
"stars": 1571,
"watchers": 28,
"fork_history": {
"days": [
{
"date": "2020-04-18",
"count": 1
},
{
"date": "2020-04-19",
"count": 1
},
{
"date": "2020-04-20",
"count": 1
},
{
"date": "2020-05-27",
"count": 1
},
{
"date": "2020-09-03",
"count": 1
},
{
"date": "2020-09-18",
"count": 1
},
{
"date": "2020-11-15",
"count": 1
},
{
"date": "2020-11-27",
"count": 1
},
{
"date": "2021-01-06",
"count": 1
},
{
"date": "2021-01-18",
"count": 1
},
{
"date": "2021-02-17",
"count": 1
},
{
"date": "2021-02-20",
"count": 1
},
{
"date": "2021-03-11",
"count": 1
},
{
"date": "2021-03-26",
"count": 2
},
{
"date": "2021-03-31",
"count": 2
},
{
"date": "2021-04-07",
"count": 1
},
{
"date": "2021-04-10",
"count": 1
},
{
"date": "2021-04-16",
"count": 2
},
{
"date": "2021-05-09",
"count": 1
},
{
"date": "2021-05-19",
"count": 1
},
{
"date": "2021-06-30",
"count": 1
},
{
"date": "2021-07-01",
"count": 1
},
{
"date": "2021-08-05",
"count": 1
},
{
"date": "2021-08-20",
"count": 1
},
{
"date": "2021-09-09",
"count": 1
},
{
"date": "2021-09-17",
"count": 1
},
{
"date": "2021-10-03",
"count": 1
},
{
"date": "2021-10-14",
"count": 2
},
{
"date": "2021-10-28",
"count": 1
},
{
"date": "2021-11-01",
"count": 1
},
{
"date": "2021-11-02",
"count": 1
},
{
"date": "2021-12-09",
"count": 1
},
{
"date": "2021-12-21",
"count": 2
},
{
"date": "2021-12-28",
"count": 1
},
{
"date": "2022-01-28",
"count": 1
},
{
"date": "2022-02-03",
"count": 1
},
{
"date": "2022-02-06",
"count": 1
},
{
"date": "2022-02-08",
"count": 1
},
{
"date": "2022-02-09",
"count": 1
},
{
"date": "2022-03-16",
"count": 1
},
{
"date": "2022-04-06",
"count": 2
},
{
"date": "2022-04-11",
"count": 1
},
{
"date": "2022-05-30",
"count": 1
},
{
"date": "2022-07-11",
"count": 1
},
{
"date": "2022-08-01",
"count": 1
},
{
"date": "2022-08-06",
"count": 1
},
{
"date": "2022-08-26",
"count": 1
},
{
"date": "2022-09-03",
"count": 1
},
{
"date": "2022-10-04",
"count": 1
},
{
"date": "2022-10-31",
"count": 1
},
{
"date": "2022-12-20",
"count": 1
},
{
"date": "2023-02-20",
"count": 1
},
{
"date": "2023-03-13",
"count": 1
},
{
"date": "2023-04-03",
"count": 1
},
{
"date": "2023-04-08",
"count": 1
},
{
"date": "2023-04-23",
"count": 1
},
{
"date": "2023-04-24",
"count": 1
},
{
"date": "2023-06-14",
"count": 1
},
{
"date": "2023-06-20",
"count": 1
},
{
"date": "2023-09-01",
"count": 1
},
{
"date": "2023-09-12",
"count": 1
},
{
"date": "2023-09-27",
"count": 1
},
{
"date": "2023-10-06",
"count": 1
},
{
"date": "2023-10-12",
"count": 1
},
{
"date": "2023-10-28",
"count": 1
},
{
"date": "2024-02-02",
"count": 1
},
{
"date": "2024-02-13",
"count": 1
},
{
"date": "2024-02-16",
"count": 1
},
{
"date": "2024-03-05",
"count": 1
},
{
"date": "2024-03-19",
"count": 1
},
{
"date": "2024-03-20",
"count": 2
},
{
"date": "2024-04-19",
"count": 1
},
{
"date": "2024-04-23",
"count": 1
},
{
"date": "2024-07-10",
"count": 1
},
{
"date": "2024-07-26",
"count": 1
},
{
"date": "2024-09-09",
"count": 1
},
{
"date": "2024-11-09",
"count": 1
},
{
"date": "2024-11-26",
"count": 1
},
{
"date": "2025-01-27",
"count": 1
},
{
"date": "2025-02-05",
"count": 2
},
{
"date": "2025-03-02",
"count": 1
},
{
"date": "2025-03-04",
"count": 1
},
{
"date": "2025-04-03",
"count": 1
},
{
"date": "2025-05-03",
"count": 1
},
{
"date": "2025-07-23",
"count": 1
},
{
"date": "2025-08-08",
"count": 1
},
{
"date": "2025-08-14",
"count": 1
},
{
"date": "2025-10-03",
"count": 1
},
{
"date": "2026-01-25",
"count": 1
},
{
"date": "2026-02-13",
"count": 1
},
{
"date": "2026-02-22",
"count": 1
},
{
"date": "2026-04-15",
"count": 1
},
{
"date": "2026-05-28",
"count": 1
},
{
"date": "2026-07-21",
"count": 1
}
],
"complete": true,
"collected": 102,
"total_forks": 102
},
"star_history": null,
"open_issues_and_prs": 13
},
"ai_readiness": {
"has_nix": false,
"example_dirs": [],
"has_llms_txt": false,
"has_dockerfile": false,
"has_mcp_signal": false,
"bootstrap_files": [],
"api_schema_files": [],
"has_devcontainer": false,
"typecheck_configs": [],
"toolchain_manifests": [],
"largest_source_bytes": 35930,
"source_files_sampled": 58,
"oversized_source_files": 0,
"agent_instruction_files": [
"AGENTS.md"
],
"agent_instruction_max_bytes": 1115
},
"dependencies": {
"manifests": [
"composer.json"
],
"advisories": {
"error": "No resolved dependencies carried a version and a supported ecosystem",
"scope": "repository_graph",
"source": null,
"findings": [],
"collected": false,
"malicious": [],
"truncated": false,
"by_severity": {},
"advisory_count": 0,
"affected_count": 0,
"assessed_count": 0,
"malicious_count": 0,
"assessed_package": null,
"unassessed_count": 7,
"direct_affected_count": 0
},
"ecosystems": [
"packagist"
],
"dependencies": [
{
"name": "illuminate/support",
"manifest": "composer.json",
"ecosystem": "packagist",
"version_constraint": "^11.42|^12.0|^13.0"
},
{
"name": "illuminate/database",
"manifest": "composer.json",
"ecosystem": "packagist",
"version_constraint": "^11.42|^12.0|^13.0"
}
],
"all_dependencies": {
"error": null,
"source": "github-sbom",
"packages": [
{
"name": "illuminate/database",
"direct": true,
"version": null,
"ecosystem": "packagist"
},
{
"name": "illuminate/support",
"direct": true,
"version": null,
"ecosystem": "packagist"
},
{
"name": "friendsofphp/php-cs-fixer",
"direct": false,
"version": null,
"ecosystem": "packagist"
},
{
"name": "laravel/legacy-factories",
"direct": false,
"version": null,
"ecosystem": "packagist"
},
{
"name": "orchestra/testbench",
"direct": false,
"version": null,
"ecosystem": "packagist"
},
{
"name": "php",
"direct": false,
"version": null,
"ecosystem": "packagist"
},
{
"name": "phpunit/phpunit",
"direct": false,
"version": null,
"ecosystem": "packagist"
}
],
"collected": true,
"truncated": false,
"total_count": 7,
"direct_count": 2,
"indirect_count": 5
}
},
"maintainership": {
"issues": {
"open_prs": 3,
"merged_prs": 83,
"open_issues": 10,
"closed_ratio": 0.922,
"closed_issues": 118,
"closed_unmerged_prs": 21
},
"bus_factor": 1,
"bot_contributors": 0,
"top_contributors": [
{
"type": "User",
"login": "luisdalmolin",
"commits": 212,
"avatar_url": "https://avatars.githubusercontent.com/u/403446?v=4"
},
{
"type": "User",
"login": "GeoSot",
"commits": 5,
"avatar_url": "https://avatars.githubusercontent.com/u/22406063?v=4"
},
{
"type": "User",
"login": "niektenhoopen",
"commits": 5,
"avatar_url": "https://avatars.githubusercontent.com/u/3450011?v=4"
},
{
"type": "User",
"login": "brandonferens",
"commits": 4,
"avatar_url": "https://avatars.githubusercontent.com/u/1819546?v=4"
},
{
"type": "User",
"login": "danharrin",
"commits": 4,
"avatar_url": "https://avatars.githubusercontent.com/u/41773797?v=4"
},
{
"type": "User",
"login": "marickvantuil",
"commits": 4,
"avatar_url": "https://avatars.githubusercontent.com/u/647007?v=4"
},
{
"type": "User",
"login": "jonneroelofs",
"commits": 3,
"avatar_url": "https://avatars.githubusercontent.com/u/20800818?v=4"
},
{
"type": "User",
"login": "lopesrbruno",
"commits": 2,
"avatar_url": "https://avatars.githubusercontent.com/u/88719327?v=4"
},
{
"type": "User",
"login": "Runig006",
"commits": 2,
"avatar_url": "https://avatars.githubusercontent.com/u/26311663?v=4"
},
{
"type": "User",
"login": "luilliarcec",
"commits": 2,
"avatar_url": "https://avatars.githubusercontent.com/u/27895611?v=4"
}
],
"contributors_sampled": 35,
"top_contributor_share": 0.788
},
"quality_signals": {
"has_ci": true,
"has_tests": true,
"ci_workflows": [
"ci.yaml",
"lint.yml"
],
"has_docs_dir": false,
"linter_configs": [
".php-cs-fixer.php"
],
"has_editorconfig": true,
"has_linter_config": true,
"has_precommit_config": false
},
"security_signals": {
"lockfiles": [],
"scorecard": {
"checks": [
{
"name": "Binary-Artifacts",
"score": 10,
"reason": "no binaries found in the repo",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#binary-artifacts"
},
{
"name": "Branch-Protection",
"score": 0,
"reason": "branch protection not enabled on development/release branches",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#branch-protection"
},
{
"name": "CI-Tests",
"score": 4,
"reason": "10 out of 21 merged PRs checked by a CI test -- score normalized to 4",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#ci-tests"
},
{
"name": "CII-Best-Practices",
"score": 0,
"reason": "no effort to earn an OpenSSF best practices badge detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#cii-best-practices"
},
{
"name": "Code-Review",
"score": 3,
"reason": "Found 11/30 approved changesets -- score normalized to 3",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#code-review"
},
{
"name": "Contributors",
"score": 10,
"reason": "project has 4 contributing companies or organizations",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#contributors"
},
{
"name": "Dangerous-Workflow",
"score": null,
"reason": "no workflows found",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dangerous-workflow"
},
{
"name": "Dependency-Update-Tool",
"score": 0,
"reason": "no update tool detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#dependency-update-tool"
},
{
"name": "Fuzzing",
"score": 0,
"reason": "project is not fuzzed",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#fuzzing"
},
{
"name": "License",
"score": 10,
"reason": "license file detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#license"
},
{
"name": "Maintained",
"score": 1,
"reason": "1 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 1",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#maintained"
},
{
"name": "Packaging",
"score": null,
"reason": "packaging workflow not detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#packaging"
},
{
"name": "Pinned-Dependencies",
"score": null,
"reason": "no dependencies found",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#pinned-dependencies"
},
{
"name": "SAST",
"score": 0,
"reason": "SAST tool is not run on all commits -- score normalized to 0",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#sast"
},
{
"name": "Security-Policy",
"score": 0,
"reason": "security policy file not detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#security-policy"
},
{
"name": "Signed-Releases",
"score": null,
"reason": "no releases found",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#signed-releases"
},
{
"name": "Token-Permissions",
"score": null,
"reason": "No tokens found",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#token-permissions"
},
{
"name": "Vulnerabilities",
"score": 10,
"reason": "0 existing vulnerabilities detected",
"documentation_url": "https://github.com/ossf/scorecard/blob/c395761df6afe1a69e476bc60a013a94bcbc153f/docs/checks.md#vulnerabilities"
}
],
"commit": "33c189bd51a510c1ceba67222395ead08a29863a",
"ran_at": "2026-07-22T18:04:31Z",
"aggregate_score": 3.4,
"scorecard_version": "v5.5.0"
},
"has_codeql_workflow": false,
"has_security_policy": false,
"has_dependabot_config": false
},
"contribution_flow": {
"collected": true,
"ci_last_run_at": "2026-05-28T20:38:16Z",
"oldest_open_prs": [
{
"number": 142,
"created_at": "2023-07-06T23:47:18Z",
"last_comment_at": "2023-10-22T19:25:15Z",
"last_comment_author": "GeoSot"
},
{
"number": 220,
"created_at": "2025-08-06T12:47:40Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 234,
"created_at": "2026-04-15T05:38:34Z",
"last_comment_at": "2026-04-27T18:17:55Z",
"last_comment_author": "vasconcelos-giovanni"
}
],
"last_merged_pr_at": "2026-05-28T20:35:56Z",
"ci_last_conclusion": "SUCCESS",
"oldest_open_issues": [
{
"number": 34,
"created_at": "2020-10-26T17:25:09Z",
"last_comment_at": "2023-11-14T15:29:25Z",
"last_comment_author": "luisdalmolin"
},
{
"number": 49,
"created_at": "2021-04-04T21:56:42Z",
"last_comment_at": "2023-06-19T19:56:43Z",
"last_comment_author": "luisdalmolin"
},
{
"number": 156,
"created_at": "2023-09-26T09:52:45Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 181,
"created_at": "2024-06-12T17:05:51Z",
"last_comment_at": "2024-06-12T17:21:16Z",
"last_comment_author": "luisdalmolin"
},
{
"number": 190,
"created_at": "2024-11-02T20:46:35Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 193,
"created_at": "2024-12-11T12:23:35Z",
"last_comment_at": "2025-09-01T06:19:14Z",
"last_comment_author": "Estigy"
},
{
"number": 197,
"created_at": "2025-01-27T07:21:28Z",
"last_comment_at": "2025-01-27T09:04:53Z",
"last_comment_author": "luisdalmolin"
},
{
"number": 218,
"created_at": "2025-08-06T10:51:11Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 219,
"created_at": "2025-08-06T10:51:54Z",
"last_comment_at": null,
"last_comment_author": null
},
{
"number": 235,
"created_at": "2026-05-13T09:48:19Z",
"last_comment_at": "2026-05-13T10:09:44Z",
"last_comment_author": "mschop"
}
]
}
},
"config": {
"disabled_metrics": [],
"disabled_categories": [],
"disabled_components": {}
},
"source": {
"url": "https://github.com/kirschbaum-development/eloquent-power-joins",
"host": "github.com",
"name": "eloquent-power-joins",
"owner": "kirschbaum-development"
},
"metrics": {
"overall": {
"key": "overall",
"band": "moderate",
"name": "Overall health",
"note": null,
"notes": [],
"value": 63,
"inputs": {
"security": 34,
"vitality": 60,
"community": 77,
"governance": 68,
"engineering": 71
},
"components": []
},
"categories": [
{
"key": "vitality",
"band": "moderate",
"name": "Vitality",
"value": 60,
"weight": 0.22,
"metrics": [
{
"key": "development_activity",
"band": "at_risk",
"name": "Development activity",
"note": null,
"notes": [],
"value": 34,
"inputs": {
"commits_last_year": 9,
"human_commit_share": 1,
"days_since_last_push": 54,
"active_weeks_last_year": 8
},
"components": [
{
"key": "push_recency",
"name": "Push recency",
"detail": "last push 54 days ago",
"points": 18,
"status": "partial",
"details": [
{
"code": "push_recency",
"params": {
"days": 54
}
}
],
"max_points": 36
},
{
"key": "commit_cadence",
"name": "Commit cadence",
"detail": "8/52 weeks with commits",
"points": 5.5,
"status": "partial",
"details": [
{
"code": "commit_cadence_weeks",
"params": {
"weeks": 8
}
}
],
"max_points": 36
},
{
"key": "commit_volume",
"name": "Commit volume",
"detail": "9 commits in the last year",
"points": 9,
"status": "partial",
"details": [
{
"code": "commits_last_year",
"params": {
"count": 9
}
}
],
"max_points": 18
},
{
"key": "openssf_scorecard_maintained",
"name": "OpenSSF Scorecard: Maintained",
"detail": "1 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 1",
"points": 1,
"status": "partial",
"details": [],
"max_points": 10
}
]
},
{
"key": "release_discipline",
"band": "excellent",
"name": "Release discipline",
"note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Signed-Releases. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"openssf_scorecard_signed_releases"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 100,
"inputs": {
"releases_count": 71,
"latest_release_tag": "4.3.2",
"releases_from_tags": false,
"days_since_latest_release": 54,
"mean_days_between_releases": 35.8
},
"components": [
{
"key": "ships_releases",
"name": "Ships releases",
"detail": "71 releases published",
"points": 27,
"status": "met",
"details": [
{
"code": "releases_published",
"params": {
"count": 71
}
}
],
"max_points": 27
},
{
"key": "release_recency",
"name": "Release recency",
"detail": "latest release 54 days ago",
"points": 36,
"status": "met",
"details": [
{
"code": "release_recency",
"params": {
"days": 54
}
}
],
"max_points": 36
},
{
"key": "release_cadence",
"name": "Release cadence",
"detail": "a release every ~35.8 days",
"points": 27,
"status": "met",
"details": [
{
"code": "release_cadence",
"params": {
"gap": 35.8
}
}
],
"max_points": 27
},
{
"key": "openssf_scorecard_signed_releases",
"name": "OpenSSF Scorecard: Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 10
}
]
},
{
"key": "abandonment",
"band": "excellent",
"name": "Abandonment",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"cap": null,
"state": "maintained",
"guards": [],
"signals": [],
"red_flag": false,
"multiplier_pct": 100,
"declared_reason": null,
"unverified_reason": null,
"unanswered_open_prs": null,
"unanswered_open_issues": null,
"days_since_last_merged_pr": null,
"days_since_last_human_commit": 54,
"days_since_last_human_commit_is_floor": false
},
"components": [
{
"key": "project_is_still_maintained",
"name": "Project is still maintained",
"detail": "last human commit 54 days ago",
"points": 100,
"status": "met",
"details": [
{
"code": "abandonment_maintained",
"params": {
"days": 54
}
}
],
"max_points": 100
}
]
}
],
"description": "Is the project alive — is code being written and are releases shipping?"
},
{
"key": "community",
"band": "good",
"name": "Community & Adoption",
"value": 77,
"weight": 0.18,
"metrics": [
{
"key": "popularity",
"band": "good",
"name": "Popularity & adoption",
"note": null,
"notes": [],
"value": 76,
"inputs": {
"forks": 102,
"stars": 1571,
"watchers": 28,
"growth_state": "unverified",
"growth_factor_pct": 100,
"growth_unverified_reason": "no_history"
},
"components": [
{
"key": "stars",
"name": "Stars",
"detail": "1,571 stars",
"points": 51.8,
"status": "partial",
"details": [
{
"code": "stars",
"params": {
"count": 1571
}
}
],
"max_points": 60
},
{
"key": "forks",
"name": "Forks",
"detail": "102 forks",
"points": 16.7,
"status": "partial",
"details": [
{
"code": "forks",
"params": {
"count": 102
}
}
],
"max_points": 25
},
{
"key": "watchers",
"name": "Watchers",
"detail": "28 watchers",
"points": 8,
"status": "partial",
"details": [
{
"code": "watchers",
"params": {
"count": 28
}
}
],
"max_points": 15
}
]
},
{
"key": "community_health",
"band": "good",
"name": "Community health",
"note": null,
"notes": [],
"value": 70,
"inputs": {
"has_readme": true,
"has_license": true,
"has_contributing": true,
"has_issue_template": false,
"has_code_of_conduct": false,
"has_pull_request_template": false
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 22.5,
"status": "met",
"details": [],
"max_points": 22.5
},
{
"key": "license",
"name": "License",
"detail": "recognized license (MIT)",
"points": 22.5,
"status": "met",
"details": [
{
"code": "license_standard",
"params": {}
},
{
"code": "license_spdx",
"params": {
"spdx": "MIT"
}
}
],
"max_points": 22.5
},
{
"key": "contributing_guide",
"name": "CONTRIBUTING guide",
"detail": null,
"points": 18,
"status": "met",
"details": [],
"max_points": 18
},
{
"key": "code_of_conduct",
"name": "Code of conduct",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 13.5
},
{
"key": "issue_template",
"name": "Issue template",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.2
},
{
"key": "pr_template",
"name": "PR template",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 6.3
}
]
},
{
"key": "ecosystem_adoption",
"band": "excellent",
"name": "Ecosystem adoption (downloads)",
"note": null,
"notes": [],
"value": 90,
"inputs": {
"packages": [
"kirschbaum-development/eloquent-power-joins"
],
"dependents": 35,
"ecosystems": "packagist",
"total_downloads": 34766417,
"monthly_downloads": 2922088
},
"components": [
{
"key": "monthly_downloads",
"name": "Monthly downloads",
"detail": "2,922,088 downloads/month across packagist",
"points": 80,
"status": "met",
"details": [
{
"code": "downloads_monthly",
"params": {
"count": 2922088,
"ecosystems": "packagist"
}
}
],
"max_points": 80
},
{
"key": "registry_dependents",
"name": "Registry dependents",
"detail": "35 packages depend on it",
"points": 10.4,
"status": "partial",
"details": [
{
"code": "registry_dependents",
"params": {
"count": 35
}
}
],
"max_points": 20
}
]
}
],
"description": "Does the project have users, downloads, attention, and a welcoming setup for contributors?"
},
{
"key": "governance",
"band": "moderate",
"name": "Sustainability & Governance",
"value": 68,
"weight": 0.24,
"metrics": [
{
"key": "maintainer_resilience",
"band": "at_risk",
"name": "Maintainer resilience (bus factor)",
"note": null,
"notes": [],
"value": 37,
"inputs": {
"bus_factor": 1,
"contributors_sampled": 35,
"top_contributor_share": 0.788
},
"components": [
{
"key": "bus_factor",
"name": "Bus factor",
"detail": "1 contributor(s) cover half of all commits",
"points": 9,
"status": "partial",
"details": [
{
"code": "bus_factor",
"params": {
"count": 1
}
}
],
"max_points": 54
},
{
"key": "commit_distribution",
"name": "Commit distribution",
"detail": "top contributor authored 79% of commits",
"points": 4.8,
"status": "partial",
"details": [
{
"code": "top_contributor_share",
"params": {
"share": 79
}
}
],
"max_points": 22.5
},
{
"key": "contributor_breadth",
"name": "Contributor breadth",
"detail": "35 contributors",
"points": 13.5,
"status": "met",
"details": [
{
"code": "contributors_sampled",
"params": {
"count": 35
}
}
],
"max_points": 13.5
},
{
"key": "openssf_scorecard_contributors",
"name": "OpenSSF Scorecard: Contributors",
"detail": "project has 4 contributing companies or organizations",
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
},
{
"key": "responsiveness",
"band": "good",
"name": "Issue & PR responsiveness",
"note": null,
"notes": [],
"value": 78,
"inputs": {
"merged_prs": 83,
"open_issues": 10,
"closed_issues": 118,
"issue_closed_ratio": 0.922,
"closed_unmerged_prs": 21
},
"components": [
{
"key": "issue_resolution",
"name": "Issue resolution",
"detail": "92% of issues closed",
"points": 43.1,
"status": "partial",
"details": [
{
"code": "issues_closed_share",
"params": {
"share": 92
}
}
],
"max_points": 46.75
},
{
"key": "pr_acceptance",
"name": "PR acceptance",
"detail": "83/104 decided PRs merged",
"points": 30.5,
"status": "partial",
"details": [
{
"code": "decided_prs_merged",
"params": {
"merged": 83,
"decided": 104
}
}
],
"max_points": 38.25
},
{
"key": "openssf_scorecard_code_review",
"name": "OpenSSF Scorecard: Code-Review",
"detail": "Found 11/30 approved changesets -- score normalized to 3",
"points": 4.5,
"status": "partial",
"details": [],
"max_points": 15
}
]
},
{
"key": "stewardship",
"band": "good",
"name": "Ownership & stewardship",
"note": null,
"notes": [],
"value": 70,
"inputs": {
"followers": 159,
"owner_type": "Organization",
"is_verified": null,
"owner_login": "kirschbaum-development",
"public_repos": 49,
"account_age_days": 3106
},
"components": [
{
"key": "ownership_backing",
"name": "Ownership backing",
"detail": "organization-owned",
"points": 30,
"status": "met",
"details": [
{
"code": "owner_organization",
"params": {}
}
],
"max_points": 30
},
{
"key": "verified_domain",
"name": "Verified domain",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 20
},
{
"key": "owner_reach",
"name": "Owner reach",
"detail": "159 followers of kirschbaum-development",
"points": 15.8,
"status": "partial",
"details": [
{
"code": "owner_followers",
"params": {
"count": 159,
"login": "kirschbaum-development"
}
}
],
"max_points": 25
},
{
"key": "track_record",
"name": "Track record",
"detail": "49 public repos, account ~8 yr old",
"points": 24.4,
"status": "partial",
"details": [
{
"code": "public_repos",
"params": {
"count": 49
}
},
{
"code": "account_age_years",
"params": {
"years": 8
}
}
],
"max_points": 25
}
]
},
{
"key": "package_maintenance",
"band": "excellent",
"name": "Package maintenance",
"note": null,
"notes": [],
"value": 100,
"inputs": {
"packages": [
"kirschbaum-development/eloquent-power-joins"
],
"ecosystems": "packagist",
"any_deprecated": false,
"min_days_since_publish": 54
},
"components": [
{
"key": "published_resolvable",
"name": "Published & resolvable",
"detail": "1 package(s) on packagist",
"points": 25,
"status": "met",
"details": [
{
"code": "packages_published",
"params": {
"count": 1,
"ecosystems": "packagist"
}
}
],
"max_points": 25
},
{
"key": "publish_recency",
"name": "Publish recency",
"detail": "latest publish 54 days ago",
"points": 35,
"status": "met",
"details": [
{
"code": "publish_recency",
"params": {
"days": 54
}
}
],
"max_points": 35
},
{
"key": "version_history",
"name": "Version history",
"detail": "78 published versions",
"points": 20,
"status": "met",
"details": [
{
"code": "published_versions",
"params": {
"count": 78
}
}
],
"max_points": 20
},
{
"key": "not_deprecated",
"name": "Not deprecated",
"detail": "active, not deprecated or yanked",
"points": 20,
"status": "met",
"details": [
{
"code": "package_not_deprecated",
"params": {}
}
],
"max_points": 20
}
]
}
],
"description": "Will the project survive its people — bus factor, responsiveness, who backs it, and package upkeep?"
},
{
"key": "engineering",
"band": "good",
"name": "Engineering Quality",
"value": 71,
"weight": 0.2,
"metrics": [
{
"key": "engineering_practices",
"band": "good",
"name": "Engineering practices",
"note": null,
"notes": [],
"value": 78,
"inputs": {
"has_ci": true,
"has_tests": true,
"has_editorconfig": true,
"has_linter_config": true,
"has_precommit_config": false
},
"components": [
{
"key": "ci_workflows",
"name": "CI workflows",
"detail": "2 workflow(s)",
"points": 24,
"status": "met",
"details": [
{
"code": "ci_workflows",
"params": {
"count": 2
}
}
],
"max_points": 24
},
{
"key": "tests_present",
"name": "Tests present",
"detail": null,
"points": 24,
"status": "met",
"details": [],
"max_points": 24
},
{
"key": "linter_config",
"name": "Linter config",
"detail": ".php-cs-fixer.php",
"points": 16,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": ".php-cs-fixer.php"
}
}
],
"max_points": 16
},
{
"key": "pre_commit_hooks",
"name": "Pre-commit hooks",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 9.6
},
{
"key": "editorconfig",
"name": ".editorconfig",
"detail": null,
"points": 6.4,
"status": "met",
"details": [],
"max_points": 6.4
},
{
"key": "openssf_scorecard_ci_tests",
"name": "OpenSSF Scorecard: CI-Tests",
"detail": "10 out of 21 merged PRs checked by a CI test -- score normalized to 4",
"points": 8,
"status": "partial",
"details": [],
"max_points": 20
}
]
},
{
"key": "documentation",
"band": "moderate",
"name": "Documentation",
"note": null,
"notes": [],
"value": 60,
"inputs": {
"topics": [
"hacktoberfest",
"laravel",
"php"
],
"has_wiki": true,
"homepage": null,
"has_readme": true,
"has_docs_dir": false,
"has_description": true
},
"components": [
{
"key": "readme",
"name": "README",
"detail": null,
"points": 30,
"status": "met",
"details": [],
"max_points": 30
},
{
"key": "documentation_directory",
"name": "Documentation directory",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 25
},
{
"key": "documentation_homepage_site",
"name": "Documentation / homepage site",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
},
{
"key": "repository_description",
"name": "Repository description",
"detail": null,
"points": 10,
"status": "met",
"details": [],
"max_points": 10
},
{
"key": "topics",
"name": "Topics",
"detail": "3 topics",
"points": 10,
"status": "met",
"details": [
{
"code": "topics_count",
"params": {
"count": 3
}
}
],
"max_points": 10
},
{
"key": "wiki",
"name": "Wiki",
"detail": null,
"points": 10,
"status": "met",
"details": [],
"max_points": 10
}
]
}
],
"description": "Are baseline engineering and documentation practices in place?"
},
{
"key": "security",
"band": "at_risk",
"name": "Security",
"value": 34,
"weight": 0.16,
"metrics": [
{
"key": "security_posture",
"band": "at_risk",
"name": "Security posture",
"note": "Excluded from scoring (no data or not applicable): Dangerous-Workflow, Packaging, Pinned-Dependencies, Signed-Releases, Token-Permissions. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"dangerous_workflow",
"packaging",
"pinned_dependencies",
"signed_releases",
"token_permissions"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 34,
"inputs": {
"source": "openssf_scorecard",
"checks_evaluated": 13,
"scorecard_version": "v5.5.0",
"checks_inconclusive": 5,
"scorecard_aggregate": 3.4
},
"components": [
{
"key": "binary_artifacts",
"name": "Binary-Artifacts",
"detail": "no binaries found in the repo",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
},
{
"key": "branch_protection",
"name": "Branch-Protection",
"detail": "branch protection not enabled on development/release branches",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "ci_tests",
"name": "CI-Tests",
"detail": "10 out of 21 merged PRs checked by a CI test -- score normalized to 4",
"points": 1,
"status": "partial",
"details": [],
"max_points": 2.5
},
{
"key": "cii_best_practices",
"name": "CII-Best-Practices",
"detail": "no effort to earn an OpenSSF best practices badge detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 2.5
},
{
"key": "code_review",
"name": "Code-Review",
"detail": "Found 11/30 approved changesets -- score normalized to 3",
"points": 2.2,
"status": "partial",
"details": [],
"max_points": 7.5
},
{
"key": "contributors",
"name": "Contributors",
"detail": "project has 4 contributing companies or organizations",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "dangerous_workflow",
"name": "Dangerous-Workflow",
"detail": "no workflows found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 10
},
{
"key": "dependency_update_tool",
"name": "Dependency-Update-Tool",
"detail": "no update tool detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 7.5
},
{
"key": "fuzzing",
"name": "Fuzzing",
"detail": "project is not fuzzed",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "license",
"name": "License",
"detail": "license file detected",
"points": 2.5,
"status": "met",
"details": [],
"max_points": 2.5
},
{
"key": "maintained",
"name": "Maintained",
"detail": "1 commit(s) and 1 issue activity found in the last 90 days -- score normalized to 1",
"points": 0.8,
"status": "partial",
"details": [],
"max_points": 7.5
},
{
"key": "packaging",
"name": "Packaging",
"detail": "packaging workflow not detected",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 5
},
{
"key": "pinned_dependencies",
"name": "Pinned-Dependencies",
"detail": "no dependencies found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 5
},
{
"key": "sast",
"name": "SAST",
"detail": "SAST tool is not run on all commits -- score normalized to 0",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "security_policy",
"name": "Security-Policy",
"detail": "security policy file not detected",
"points": 0,
"status": "missed",
"details": [],
"max_points": 5
},
{
"key": "signed_releases",
"name": "Signed-Releases",
"detail": "no releases found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 7.5
},
{
"key": "token_permissions",
"name": "Token-Permissions",
"detail": "No tokens found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 7.5
},
{
"key": "vulnerabilities",
"name": "Vulnerabilities",
"detail": "0 existing vulnerabilities detected",
"points": 7.5,
"status": "met",
"details": [],
"max_points": 7.5
}
]
},
{
"key": "high_risk_jurisdiction_exposure",
"band": "excellent",
"name": "High-Risk Jurisdiction Exposure",
"note": "Only high-confidence self-published location evidence affects this multiplier. Ambiguous matches are review-only; country evidence is not proof of nationality, citizenship, legal registration, malicious intent, or sanctions status.",
"notes": [
{
"code": "jurisdiction_evidence_limits",
"params": {}
}
],
"value": 100,
"inputs": {
"meaning": "self-published location evidence; not nationality or citizenship",
"red_flag": false,
"exposures": [],
"policy_countries": [
"Russia",
"Iran",
"North Korea"
],
"review_only_matches": 0,
"assessed_self_published_locations": 13
},
"components": [
{
"key": "policy_exposure_multiplier",
"name": "Policy exposure multiplier",
"detail": "no confirmed policy-scope location match",
"points": 100,
"status": "met",
"details": [
{
"code": "jurisdiction_no_match",
"params": {}
}
],
"max_points": 100
}
]
}
],
"description": "Are visible security and supply-chain practices strong, with no malicious dependency and no unresolved high-risk jurisdiction exposure?"
},
{
"key": "ai_readiness",
"band": "moderate",
"name": "AI Readiness",
"value": 53,
"weight": 0,
"metrics": [
{
"key": "ai_agent_context",
"band": "good",
"name": "Agent context & guidance",
"note": null,
"notes": [],
"value": 74,
"inputs": {
"has_llms_txt": false,
"legible_history_share": 0.54,
"agent_instruction_files": [
"AGENTS.md"
],
"agent_instruction_max_bytes": 1115
},
"components": [
{
"key": "agent_instructions",
"name": "Agent instructions",
"detail": "AGENTS.md",
"points": 45,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": "AGENTS.md"
}
}
],
"max_points": 45
},
{
"key": "machine_readable_docs_llms_txt",
"name": "Machine-readable docs (llms.txt)",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 15
},
{
"key": "legible_commit_history",
"name": "Legible commit history",
"detail": "54 of 100 human commits state their intent (structured subject or explanatory body)",
"points": 28.8,
"status": "partial",
"details": [
{
"code": "legible_history",
"params": {
"legible": 54,
"sampled": 100
}
}
],
"max_points": 40
}
]
},
{
"key": "ai_verify_loop",
"band": "at_risk",
"name": "Verify loop (build / test / typecheck)",
"note": "Excluded from scoring (no data or not applicable): OpenSSF Scorecard: Pinned-Dependencies. Remaining weights renormalized.",
"notes": [
{
"code": "excluded_no_data",
"params": {
"components": [
"openssf_scorecard_pinned_dependencies"
]
}
},
{
"code": "weights_renormalized",
"params": {}
}
],
"value": 37,
"inputs": {
"has_nix": false,
"has_tests": true,
"lockfiles": [],
"has_dockerfile": false,
"typed_language": false,
"bootstrap_files": [],
"has_devcontainer": false,
"has_linter_config": true,
"typecheck_configs": [],
"agent_commit_share": 0,
"toolchain_manifests": [],
"dependency_bot_commit_share": 0
},
"components": [
{
"key": "one_command_bootstrap",
"name": "One-command bootstrap",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 18
},
{
"key": "automated_tests",
"name": "Automated tests",
"detail": null,
"points": 22,
"status": "met",
"details": [],
"max_points": 22
},
{
"key": "lint_format_config",
"name": "Lint / format config",
"detail": ".php-cs-fixer.php",
"points": 11,
"status": "met",
"details": [
{
"code": "file_list",
"params": {
"files": ".php-cs-fixer.php"
}
}
],
"max_points": 11
},
{
"key": "static_type_checking",
"name": "Static type checking",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 11
},
{
"key": "reproducible_environment",
"name": "Reproducible environment",
"detail": null,
"points": 0,
"status": "missed",
"details": [],
"max_points": 10
},
{
"key": "demonstrated_agent_practice",
"name": "Demonstrated agent practice",
"detail": "no agent-authored commits among the last 100",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_agent_authored_commits",
"params": {
"sampled": 100
}
}
],
"max_points": 10
},
{
"key": "automated_maintenance",
"name": "Automated maintenance",
"detail": "no automated dependency updates observed",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_dependency_automation",
"params": {}
}
],
"max_points": 8
},
{
"key": "openssf_scorecard_pinned_dependencies",
"name": "OpenSSF Scorecard: Pinned-Dependencies",
"detail": "no dependencies found",
"points": 0,
"status": "excluded",
"details": [
{
"code": "no_data",
"params": {}
}
],
"max_points": 10
}
]
},
{
"key": "ai_code_legibility",
"band": "moderate",
"name": "Code legibility for models",
"note": null,
"notes": [],
"value": 55,
"inputs": {
"primary_language": "PHP",
"largest_source_bytes": 35930,
"source_files_sampled": 58,
"oversized_source_files": 0
},
"components": [
{
"key": "type_checkable_code",
"name": "Type-checkable code",
"detail": "PHP without a type-check config",
"points": 0,
"status": "missed",
"details": [
{
"code": "no_typecheck_config_language",
"params": {
"language": "PHP"
}
}
],
"max_points": 45
},
{
"key": "manageable_file_sizes",
"name": "Manageable file sizes",
"detail": "0/58 source files over 60KB",
"points": 55,
"status": "met",
"details": [
{
"code": "oversized_source_files",
"params": {
"kb": 60,
"sampled": 58,
"oversized": 0
}
}
],
"max_points": 55
}
]
}
],
"description": "How well is the repo equipped to be developed and maintained with AI coding agents? An independent, experimental badge — weight 0.0, so it is surfaced on its own and does not affect the overall health score."
}
],
"metrics_version": "1.13.0"
},
"warnings": [
"Star history unavailable: GitHub GraphQL error: Resource not accessible by personal access token",
"No resolved dependencies carried a version and a supported ecosystem"
],
"report_type": "repository",
"generated_at": "2026-07-22T18:04:56.916285Z",
"schema_version": "0.26.0",
"badge_url": "https://raw.githubusercontent.com/inspect-software/badges/main/v1/k/kirschbaum-development/eloquent-power-joins.svg",
"full_name": "kirschbaum-development/eloquent-power-joins",
"license_state": "standard",
"license_spdx": "MIT"
}