Geek Answers Handbook

Cakephp find returns null

Hi, all I'm trying to do two things with a find, model disputes belong to the accounts.

find all invoices where

invoice.receiver_id=account.id

and

dispute.invoice_id=invoice.id

currently the array returns null when debugging. There must be 2 results in the find statement

here is the code in my dispute controller

 public function index_admin(){ $id = $this->Auth->User('account_id'); $receiver = $this->Invoice->find('all',array( 'conditions'=>array("AND"=>array( 'Invoice.id'=>'Dispute.invoice_id', 'receiver_id'=>$id)))); $this->set('id',$id); $this->set('receiver', $receiver); }

This is in the dispute controller, since I want to print a list of invoices that have disputes.

 Query Error Affected Num. rows Took (ms) 1 SELECT `Invoice`.`id`, `Invoice`.`scheduled`, `Invoice`.`paid`, `Invoice`.`sender_id`, `Invoice`.`receiver_id`, `Invoice`.`template_id`, `Invoice`.`created`, `Invoice`.`expiry_date`, `Invoice`.`total_amount`, `ReceiverAccount`.`id`, `ReceiverAccount`.`street`, `ReceiverAccount`.`city`, `ReceiverAccount`.`postcode`, `ReceiverAccount`.`state`, `ReceiverAccount`.`country`, `ReceiverAccount`.`active`, `ReceiverAccount`.`account_name`, `ReceiverAccount`.`abn`, `SenderAccount`.`id`, `SenderAccount`.`street`, `SenderAccount`.`city`, `SenderAccount`.`postcode`, `SenderAccount`.`state`, `SenderAccount`.`country`, `SenderAccount`.`active`, `SenderAccount`.`account_name`, `SenderAccount`.`abn`, `Template`.`id`, `Template`.`name`, `Template`.`description`, `Template`.`account_id`, `Template`.`active` FROM `pra`.`invoices` AS `Invoice` LEFT JOIN `pra`.`accounts` AS `ReceiverAccount` ON (`Invoice`.`receiver_id` = `ReceiverAccount`.`id`) LEFT JOIN `pra`.`accounts` AS `SenderAccount` ON (`Invoice`.`sender_id` = `SenderAccount`.`id`) LEFT JOIN `pra`.`templates` AS `Template` ON (`Invoice`.`template_id` = `Template`.`id`) WHERE `Invoice`.`id` = 'Dispute.invoice_id' AND `Invoice`.`receiver_id` = 2

EDIT ---------------------

 invoices tables has - id, sender_id, receiver_id, amount, expiry_date, created, paid disputes table has - id, dispute_date, comment, active

the dispute model looks like this:

 public $belongsTo = array( 'Invoice' => array( 'className' => 'Invoice', 'foreignKey' => 'invoice_id', 'conditions' => '', 'fields' => '', 'order' => '' ) ); public $hasOne = array( 'Sender' => array( 'className' => 'Account', 'foreignKey' =>'sender_id', 'associationForeignKey' => 'accounts_id',), 'Receiver'=> array( 'className' => 'Account', 'foreignKey' =>'receiver_id', 'associationForeignKey' => 'accounts_id', ) );

Disputes have one sender and one receiver, since one invoice can only have one dispute.

+7
source share
2 answers

try this code if you are in DisputeController: I don't know if the table name is accounts

  $id = $this->Auth->User('account_id'); $options['joins'] = array( array( 'table' => 'invoices', 'alias' => 'i', 'type' => 'INNER', 'conditions' => array( 'i.id' => 'invoice_id', 'i.receiver_id' => $id ) )); $receiver = $this->Dispute->find('all', $options); $this->set('id',$id); $this->set('receiver', $receiver);
+1
source 
 public function index_admin(){ $id = $this->Auth->User('account_id'); $this->Invoice->bindModel(array('hasMany'=>array('Dispute' => array ('className' => 'Dispute','foreignKey' => 'invoice_id')))); $receiver = $this->Invoice->find('all',array('conditions'=>array('Invoice.receiver_id'=>$id))); $this->set('id',$id); $this->set('receiver', $receiver); }

============= Updated answer =================

 public function index_admin(){ $id = $this->Auth->User('account_id'); $this->Invoice->bindModel(array('hasMany'=>array('Dispute' => array ('className' => 'Dispute','foreignKey' => 'invoice_id','conditions'=>array('receiver_id'=>$id))))); $receiver = $this->Invoice->find('all'); $this->set('id',$id); $this->set('receiver', $receiver); }

Try my updated answer and let me know.

0
source

More articles:


All Articles