cakephp 3属于Stomany赢得了任何结果

发布于 2025-01-21 17:46:27 字数 1505 浏览 4 评论 0原文

我有以下表

用户我和公司

有很多命名为users_companies的表

在我拥有的用户表上

    $this->belongsToMany('Companies', [
        'targetForeignKey' => 'company_id',
        'foreignKey' => 'user_id',
        'joinTable' => 'users_companies',
    ]);

：但是

 $result = $this->find('all', array(
            'conditions' => array(
                'Users.id' => 1,
            ),
 ))->contain(['Roles', 'Companies']);

这样做并没有为许多公司带来很多东西。

在查询。log上，我看到了：

SELECT
    UsersCompanies. ID AS "Companies_CJoin__id",
    UsersCompanies.user_id AS "Companies_CJoin__user_id",
    UsersCompanies.company_id AS "Companies_CJoin__company_id",
    Companies. ID AS "Companies__id",
    Companies. NAME AS "Companies__name",
    Companies.user_id AS "Companies__user_id",
    Companies.created AS "Companies__created",
    Companies.modified AS "Companies__modified",
    Companies.reason_type AS "Companies__reason_type",
    Companies.fantasy_name AS "Companies__fantasy_name",
    Companies.document_type AS "Companies__document_type",
    Companies.document_id AS "Companies__document_id",
    Companies.avatar AS "Companies__avatar"
FROM
    companies Companies
INNER JOIN users_companies UsersCompanies ON Companies. ID = (UsersCompanies.company_id)
WHERE
    (
        UsersCompanies.user_id IN (1)
        AND Companies. ID = NULL
    )

我想知道我在做什么错，因为在Where子句中，它添加了Companies.ID = null。因此，它不会带来公司。

原文

I have the following tables

Users
Companies

and i have a Many to Many table named users_companies

On the Users table i have:

    $this->belongsToMany('Companies', [
        'targetForeignKey' => 'company_id',
        'foreignKey' => 'user_id',
        'joinTable' => 'users_companies',
    ]);

But doing

 $result = $this->find('all', array(
            'conditions' => array(
                'Users.id' => 1,
            ),
 ))->contain(['Roles', 'Companies']);

It doesn't bring anything on the Companies Many to Many.

On the query.log i see this:

SELECT
    UsersCompanies. ID AS "Companies_CJoin__id",
    UsersCompanies.user_id AS "Companies_CJoin__user_id",
    UsersCompanies.company_id AS "Companies_CJoin__company_id",
    Companies. ID AS "Companies__id",
    Companies. NAME AS "Companies__name",
    Companies.user_id AS "Companies__user_id",
    Companies.created AS "Companies__created",
    Companies.modified AS "Companies__modified",
    Companies.reason_type AS "Companies__reason_type",
    Companies.fantasy_name AS "Companies__fantasy_name",
    Companies.document_type AS "Companies__document_type",
    Companies.document_id AS "Companies__document_id",
    Companies.avatar AS "Companies__avatar"
FROM
    companies Companies
INNER JOIN users_companies UsersCompanies ON Companies. ID = (UsersCompanies.company_id)
WHERE
    (
        UsersCompanies.user_id IN (1)
        AND Companies. ID = NULL
    )

I'm wondering what i'm doing wrong because on the Where clause, it adds Companies.id = NULL. Because of that , it won't bring the Companies.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

作业与我同在 2025-01-28 17:46:27

我留下了一些可以帮助您的步骤：

您是否手动创建了这些模型？
烘焙控制台可以帮助减少错误。
应命名加入表compission_users而不是
users_companies。您可以阅读数据库约定。 >

检查您的userscompaniestable.php（应该是
CompaniesSustable.php如果您在步骤2上接受了我的建议）。
它应该看起来像：

  $ this-＆gt;
    'foreferkey'=＆gt; '用户身份'，
    'toctype'=＆gt; '内'，
）;
$ this-＆gt;
    'foreferkey'=＆gt; “ company_id'，
    'toctype'=＆gt; '内'，
）;

I left some steps that could help you:

did you create these models manually?
The bake console could help to reduce errors.
Join table should be named companies_users instead of
users_companies. You can read the Database Conventions.

Check your UsersCompaniesTable.php (it should be
CompaniesUsersTable.php if you accepted my suggestion on step 2).
It should look like:

$this->belongsTo('Users', [
    'foreignKey' => 'user_id',
    'joinType' => 'INNER',
]);
$this->belongsTo('Companies', [
    'foreignKey' => 'company_id',
    'joinType' => 'INNER',
]);

回复收藏 0 原文

~没有更多了~