同一模型的多重关系 CakePHP

2021-11-30 00:00:00 mysql cakephp relationships associations

嘿，我们的数据库中有三个表，它们通过帐户和发票这两个关系连接.

Hey we have three tables in our database which are connected through two relationships which are Account and Invoices.

帐户(id....)发票(id、sender_id、receiver_id)关系(id、sender_id、receiver_id)

Accounts (id....) Invoices (id, sender_id, receiver_id) Relationships (id, sender_id, receiver_id)

发送者和接收者都是引用帐户表的外键，因此在 cakePHP 中是 account_id.关系表指定可以发送或接收发票的关系，发票表显示已发送的发票.

Sender and receiver are both foreign keys which reference the account table so in cakePHP an account_id. The relationship table specifies relationships where invoices can be sent or received and the invoice table displays the invoices that have been sent.

我们如何将这两个外键与 CakePHP 中的帐户联系起来?

How do we link both these foreign keys with Accounts in CakePHP?

Cake 发现存在关系并列出可向其发送发票的接收者.目前它向数据库发送了正确的sender_id，但将relationship_id 作为invoice 表中的receiver_id 发送到数据库.

Cake is finding there is a relationship and listing the receivers available to send an invoice to. At the moment its sending the right sender_id to the database but the sending the relationship_id to the database as the receiver_id in the invoice table.

已经通过这个但不起作用:http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html#hasandbelongstomany-habtm

Already gone through this but doesnt work: http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html#hasandbelongstomany-habtm

以下是我们的两个模型:

Here is what we have for our two models:

帐户模型:

class Account extends AppModel{

    var $name='Account';
    public $useTable = 'accounts';
    public $primaryKey = 'id';
    var $hasAndBelongsToMany = array(
        'User' =>
            array(
                'className'=>'User',
                )
            );
    var $hasMany = array(
        'Template' =>
            array(
                'className'=>'Template',
                'foreignKey'=>'account_id',     
            ),  
            'InvoiceRecieved' => array(
                'className'=>'Invoice',
                'foreignKey'=>'receiver_id',        
            ),
            'InvoiceSent' => array(
                'className'=>'Invoice',
                'foreignKey'=>'sender_id',      
            )

        );



    }

发票模型:

class Invoice extends AppModel{ 
    var $name='Invoice'; 
    var $hasAndBelongsToMany = array(
        'Field' =>
            array(
                'className'=>'Field',
                'joinTable'=>'fields_invoices'

                )
            );
    var $belongsTo = array(
            'Sender' => array(
            'className' => 'Account',
            'foreignKey' =>'account_id',
            ),
            'Receiver' => array(
            'className' => 'Account',
            'foreignKey' =>'receiver_id',
            )
        ); 

    public $useTable='invoices';
    public $primaryKey='id';

发票控制器:

 $accounts2=$this->User->AccountsUser->find('list', array(
            'fields'=>array('account_id'),'conditions' => array(
            'user_id' => $this->Auth->user('id'))));

    $accounts=$this->User->Relationship->find('list', array('fields'=>array('receiver_id'),'conditions' =>  array('sender_id' => $accounts2)));

if($this->request->is('post')){
        ($this->Invoice->set($this->request->data));
        //if($this->Invoice->validates(array('fieldList'=>array('receiver_id','Invoice.relationshipExists')))){

            $this->Invoice->save($this->request->data); 
            $this->Session->setFlash('The invoice has been saved');  
      }else { 
                $this->Session->setFlash('The invoice could not be saved. Please, try again.');
             }
    //}
     $this->set('accounts', $accounts); 
     $this->set('accounts2', $accounts2);

添加视图:

<?php
echo $this->Form->create('Invoice', array('action'=>'addinvoice'));
echo $this->Form->input('sender_id',array('label'=>'Sender: ', 'type' => 'select', 'options' => $accounts3));
echo $this->Form->input('receiver_id',array('label'=>'Receiver: ', 'type' => 'select', 'options' => $accounts));
echo $this->Form->end('Click here to submit Invoice');

?>

推荐答案

我认为您不需要发票、发送者和接收者的联接表.您可以将这些外键存储在您的发票表中.您的关系将是:

I don't think you need a join table for invoices, and senders and receivers. You can store these foreign keys in your invoices table. Your relationships would then be:

<?php
class Invoice extends AppModel {

    public $belongsTo = array(
        'Sender' => array(
            'className' => 'Account',
            'foreignKey' => 'sender_id'
        ),
        'Receiver' => array(
            'className' => 'Account',
            'foreignKey' => 'receiver_id'
        )
    );
}

如果您需要区分已发送或未发送的发票，您还可以添加一个名为 status_id 或类似的列，并将另一个外键存储到新的 statuses> 表，带有 ID 列和名称列，以及以下示例数据:

If you then need to distinguish invoices that have been sent or not, you could also add a column called status_id or similar, and store another foreign key to a new statuses table, with an ID column and name column, and the following sample data:

id name
== ====
1  Draft
2  Sent

以及您可能需要的任何其他状态.

And any other statuses you may need.

相关文章