Question

我试图创建一个站点, 当我们发送发票时, 发件人和接收人之间的关系必须活跃起来。这是在一个单独的表格中完成的, 并要求在另一张表格中有一个布尔值。

发票将保存在表格invoices 中,其结构如下:

id
sender
receiver
amount
date due

relation 表格的结构如下:

id
partyone
partytwo
active

partyone 和 party2 参考用户表格。

user 表格的结构如下:

id
username
password

我想看到的是,如果关系表包含党内和党二和布林是等于一个。

这是我在发票表中添加新发票的功能。在用户与该用户保持积极关系之前, 无法将其添加到数据库。

public function addinvoice(){
if($this->request->is( post )) {
    $this->Invoice->create();
    if (0 === $this->relationship->find( count ,array( conditions =>array( activate =>1, relationship => $relationship)))) {
        $this->Session->setFlash( Sorry, you do not have an active relationship. );
        $this->redirect($this->referer());
    }
    if ($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. );
}
}

Answer 1

这是你问题的简单答案

像这样修改您的发现 :

$relationship = $this->relationship->find( count , array(
     conditions  => array(
         partyone  => $user_one_id,
         partytwo  => $user_two_id,
    ),
));

if (!$relationship) {
    //Error here
} else {
    //Save here
}

友情链接