# |
Jul 25th 2016, 22:24 |
sat |
Where problems? |
# |
Jul 25th 2016, 22:24 |
mikatone |
that's it |
# |
Jul 25th 2016, 22:24 |
mikatone |
Technicians as many Certificates |
# |
Jul 25th 2016, 22:23 |
mikatone |
I can illustrate the database tables in question |
# |
Jul 25th 2016, 22:23 |
mikatone |
sat Impossible |
# |
Jul 25th 2016, 22:21 |
sat |
send me your error |
# |
Jul 25th 2016, 22:21 |
mikatone |
sat apart from that do you see anything suspicious ? :) |
# |
Jul 25th 2016, 22:20 |
sat |
yes |
# |
Jul 25th 2016, 22:20 |
sat |
where(['Technicians.id' |
# |
Jul 25th 2016, 22:20 |
mikatone |
sat you mean where(['Technicians .id' |
# |
Jul 25th 2016, 22:19 |
sat |
Technicians.id =>... |
# |
Jul 25th 2016, 22:19 |
sat |
use |
# |
Jul 25th 2016, 22:19 |
sat |
in where |
# |
Jul 25th 2016, 22:18 |
mikatone |
little help humm? |
# |
Jul 25th 2016, 22:16 |
mikatone |
but somethigns wrong ... ^^ |
# |
Jul 25th 2016, 22:16 |
mikatone |
$result = $this->Technicians->find()->select(['id', 'name'])->contain(['Certificates' => ['fields' => ['id','number','technician_id']]])->where(['id' => $id])->execute(); |
# |
Jul 25th 2016, 22:16 |
mikatone |
Hi guys need to get this query to work :) |
# |
Jul 25th 2016, 21:49 |
azzenovic |
I see |
# |
Jul 25th 2016, 21:44 |
sat |
i may add another field to user : address_id |
# |
Jul 25th 2016, 21:43 |
sat |
i think if i used address hasOne user |
# |
Jul 25th 2016, 21:40 |
sat |
help |
# |
Jul 25th 2016, 21:37 |
azzenovic |
thx cakebot which search plugin do you recommend though? |
# |
Jul 25th 2016, 21:36 |
sat |
in my case i used belongsTo or hasOne |
# |
Jul 25th 2016, 21:35 |
sat |
help |
# |
Jul 25th 2016, 21:33 |
slackebot2 |
~tell azzenovic about awesome |
# |
Jul 25th 2016, 21:33 |
slackebot2 |
Command sent from Slack by admad: |
# |
Jul 25th 2016, 21:27 |
azzenovic |
Hi guys! I am currently using cakephp and I was wondering if there is a plugin with a search bar functionality . |
# |
Jul 25th 2016, 21:20 |
sat |
help |
# |
Jul 25th 2016, 21:18 |
sat |
have some one? |
# |
Jul 25th 2016, 21:18 |
sat |
hi |
# |
Jul 25th 2016, 21:15 |
sat |
help |
# |
Jul 25th 2016, 21:15 |
sat |
? |
# |
Jul 25th 2016, 21:15 |
sat |
but cake how to detect that |
# |
Jul 25th 2016, 21:14 |
sat |
i know those are hasOne |
# |
Jul 25th 2016, 21:14 |
sat |
? |
# |
Jul 25th 2016, 21:14 |
sat |
$this->belongsTo('Users'); |
# |
Jul 25th 2016, 21:14 |
sat |
or |
# |
Jul 25th 2016, 21:14 |
sat |
$this->hasOne('Users'); ? |
# |
Jul 25th 2016, 21:13 |
sat |
in addresses table how defiend relation? |
# |
Jul 25th 2016, 21:13 |
sat |
i defiend $this->hasOne('Addresses'); in users table |
# |
Jul 25th 2016, 21:12 |
sat |
i want put foreign key in addresses table |