Thanks a lot @Leandro Machado Pereira
i tried & working fine
$departments = $this->Companies->Departments->find('list')->select(['id', 'name'])->where(['company_id' => $company->id]);
Bayezid
On Thu, Nov 20, 2014 at 8:35 PM, Leandro Machado Pereira <llpereiras@gmail.com> wrote:
Hi Dear,
see this:try this:$departments = $this->Companies->Departments->find('list')->select(['id', 'name'])->where(['id !=' => 1])->order(['created' => 'DESC']);Em Thu Nov 20 2014 at 12:07:22, Md Bayezid Alam <bayezidece@gmail.com> escreveu:----Dear All,How do i apply condition at find('list') at Cakephp 3.0?i have a Companies, Departments and EmployeesCompanies hasMany Department.Companies hasMany EmployeesDepartments has Many Employees.i want to add Employees from company & want to get departments list of that company.My Add method:public function add($companyId = null){if (!$companyId){throw new NotFoundException(__('A Company is required'));}$this->loadModel('Companies');$company = $this->Companies->get($companyId);$employee = $this->Employees->newEntity($this->request->data);if ($this->request->is('post')){$employee->company_id = $company->id;if ($this->Employees->save($employee)){$this->Flash->success(__('The employee has been added successfully'));return $this->redirect(['action' => 'index']);} else {$this->Flash->error(__('Unable to add the employee, please try again'));}}$departments = $this->Companies->Departments->find('list'); // Here, Want to get only Departments lists of that company passed through $companyId$this->set(compact('employee','departments'));}Could you please help suggesting me on this regard?Note: Sorry for my bad EnglishThanksBayezid
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment