时间戳

首页 > 解决方案 > Cakephp 在更改字段时更新另一个表

cakephp-3.x - Cakephp 在更改字段时更新另一个表

问题描述

我有 2 个表：Clients 和 AssetsAssignations。客户表有一个字段：is_active。

在编辑模式下，当 is_active 从 TRUE 更改为 FALSE 时，我需要通过为所选客户的所有 assets_assignations 设置 end_date=TODAY 来更新分配表。

AssetsAssignations 包含以下字段：（id、asset_id、client_id、room_id、ip_address、starting_date、ending_date）。在 AssetsAssignationsTable 中：

public function initialize(array $config)
{
    parent::initialize($config);

    $this->table('assets_assignations');
    $this->displayField('id');
    $this->primaryKey('id');

    $this->belongsTo('Assets', [
        'foreignKey' => 'asset_id'
    ]);
    $this->belongsTo('Clients', [
        'foreignKey' => 'client_id'
    ]);
    $this->belongsTo('Rooms', [
        'foreignKey' => 'room_id'
    ]);

}

在客户表中：

public function initialize(array $config)
{
    parent::initialize($config);

    $this->table('clients');
    $this->DisplayField('full_name');
    $this->primaryKey('id');

    $this->hasMany('AssetsAssignations', [
        'foreignKey' => 'client_id'
    ]);

    ....
}

这是我对客户的编辑功能：

public function edit($id = null)
{
    $client = $this->Clients->get($id, [
        'contain' => []
    ]);
    if ($this->request->is(['patch', 'post', 'put'])) {
        $client = $this->Clients->patchEntity($client, $this->request->data);
        if ($this->Clients->save($client)) {
            $this->Flash->success(__('The client has been saved.'));

            return $this->redirect(['action' => 'index']);
        }
        $this->Flash->error(__('The client could not be saved. Please, try again.'));
    }
    $clientTypes = $this->Clients->ClientTypes->find('list', ['limit' => 200]);
    $this->set(compact('client', 'clientTypes'));
    $this->set('_serialize', ['client']);
}

标签： cakephp-3.x

解决方案

我的建议：

在 ClientsTable.php 中，添加

use ArrayObject;
use Cake\Datasource\EntityInterface;
use Cake\Event\Event;
use Cake\I18n\FrozenDate;

/**
 * Perform additional operations after it is saved.
 *
 * @param \Cake\Event\Event $event The afterSave event that was fired
 * @param \Cake\Datasource\EntityInterface $entity The entity that was saved
 * @param \ArrayObject $options The options passed to the save method
 * @return void
 */
public function afterSave(Event $event, EntityInterface $entity, ArrayObject $options) {
    // For CakePHP 3.4.3 or later, use isDirty instead of dirty
    if (!$entity->isNew() && $entity->dirty('is_active') && !$entity->is_active) {
        $this->AssetsAssignations->updateAll(['end_date' => FrozenDate::now()], ['client_id' => $entity->id]);
    }
}

通过将此代码放置在 afterSave 事件处理程序中，您可以确保在标志更改为 false 的任何时候都会发生这种情况is_active，无论该更改来自编辑页面还是其他地方。（现在可能没有其他地方可以更新此内容，但这可以为您提供未来证明，以防以后添加此类内容。）

推荐阅读