# |
Jul 4th 2018, 07:24 |
Boom |
hey |
# |
Jul 4th 2018, 07:24 |
Boom |
Hello everyone |
# |
Jul 4th 2018, 07:22 |
Boom |
hi |
# |
Jul 4th 2018, 06:59 |
saeideng |
see other methods |
# |
Jul 4th 2018, 06:30 |
lubos |
How can I use MapReduce to filter data, examples I see are returning 2 or more resultSets, but I want just filter some results in same collection |
# |
Jul 4th 2018, 05:33 |
slackebot4 |
'Offers', 'foreignKey' => 'offer_id', 'targetForeignKey' => 'related_id', 'joinTable' => 'offers_related', 'conditions' => [ 'OffersRelated.type' => 'upsell', ] ]); ``` I am using `offers_related` table as joinTable and type condition just because I am same joinTable for multiple associations. In your case related / suppressed will be affilated |
# |
Jul 4th 2018, 05:33 |
lubos |
@pmoraes Here is my example in `OffersTable.php` ``` $this->belongsToMany('Suppressed', [ 'className' => 'Offers', 'foreignKey' => 'offer_id', 'targetForeignKey' => 'related_id', 'joinTable' => 'offers_related', 'conditions' => [ 'OffersRelated.type' => 'suppressed', ] ]); $this->belongsToMany('Upsell', [ 'className' => |
# |
Jul 4th 2018, 05:29 |
lubos |
I think your className and the name of association should be different |
# |
Jul 4th 2018, 05:19 |
liaogz82 |
can a custom field be created out from the entity? |
# |
Jul 4th 2018, 04:55 |
liaogz82 |
say I want a custom field `date` from `created_at` datetime field. Just the date will do |
# |
Jul 4th 2018, 04:54 |
liaogz82 |
guys how do I make custom fields in cakephp? |
# |
Jul 4th 2018, 02:54 |
pmoraes |
``` $this->belongsToMany('AffiliatedCompanies', [ 'className' => 'Companies', 'foreignKey' => 'company_id', 'targetForeignKey' => 'affiliated_company_id', 'joinTable' => 'affiliated_companies' ]);```` |
# |
Jul 4th 2018, 02:53 |
pmoraes |
Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'company_id' in 'where clause' |
# |
Jul 4th 2018, 02:53 |
pmoraes |
let me check |
# |
Jul 4th 2018, 02:53 |
pmoraes |
hmm |
# |
Jul 4th 2018, 02:53 |
hmic |
only the association name |
# |
Jul 4th 2018, 02:52 |
hmic |
no, classname does not change there |
# |
Jul 4th 2018, 02:52 |
pmoraes |
this its not saving anything |
# |
Jul 4th 2018, 02:52 |
pmoraes |
```$this->belongsToMany('AffiliatedCompanies', [ 'className' => 'AffiliatedCompanies', 'foreignKey' => 'company_id', 'targetForeignKey' => 'affiliated_company_id', 'joinTable' => 'affiliated_companies' ]);``` |
# |
Jul 4th 2018, 02:50 |
pmoraes |
I already did that many times |
# |
Jul 4th 2018, 02:50 |
hmic |
pmoraes: it would rather need to read ...belongsToMany('AffiliatedCompanies', [ ... |
# |
Jul 4th 2018, 02:49 |
pmoraes |
anyone has some idea about what is happening? |
# |
Jul 4th 2018, 02:49 |
pmoraes |
$this->Form->control('companies._ids' |
# |
Jul 4th 2018, 02:49 |
pmoraes |
in my form I have |
# |
Jul 4th 2018, 02:48 |
pmoraes |
File uploaded https://cakesf.slack.com/files/U6X99ATG8/FBKMD6VV5/captura_de_tela_2018-07-03_a__s_23.48.10.png / https://slack-files.com/T053DPNCM-FBKMD6VV5-8264b4b991 |
# |
Jul 4th 2018, 02:48 |
pmoraes |
its saving so |
# |
Jul 4th 2018, 02:48 |
pmoraes |
if I invert the foreignKey and targetForeignKey |
# |
Jul 4th 2018, 02:48 |
pmoraes |
File uploaded https://cakesf.slack.com/files/U6X99ATG8/FBJ3FDR97/captura_de_tela_2018-07-03_a__s_23.47.28.png / https://slack-files.com/T053DPNCM-FBJ3FDR97-166d34e044 |
# |
Jul 4th 2018, 02:47 |
pmoraes |
in this case it saving the affiliated_company_id in company_in and in affiliated_company_id its saving 0 |
# |
Jul 4th 2018, 02:46 |
pmoraes |
company_id and affiliated_company_id |
# |
Jul 4th 2018, 02:46 |
pmoraes |
in my affiliated_companies I have |
# |
Jul 4th 2018, 02:45 |
pmoraes |
`$this->belongsToMany('Companies', [ 'className' => 'Companies', 'foreignKey' => 'company_id', 'targetForeignKey' => 'affiliated_company_id', 'joinTable' => 'affiliated_companies' ]);` |
# |
Jul 4th 2018, 02:45 |
pmoraes |
I'm doing this |
# |
Jul 4th 2018, 02:44 |
pmoraes |
I will have affiliated companies |
# |
Jul 4th 2018, 02:44 |
pmoraes |
or better |
# |
Jul 4th 2018, 02:44 |
pmoraes |
like Companies belongsToMany Companies |
# |
Jul 4th 2018, 02:44 |
pmoraes |
I need to make a relation between the same table |
# |
Jul 4th 2018, 02:44 |
pmoraes |
I'm having a doubt about the HABTM |
# |
Jul 4th 2018, 02:44 |
pmoraes |
Hey guys |
# |
Jul 3rd 2018, 16:32 |
dakota |
You would get the response body using the response object like `(string)$this->_response->getBody()` |
# |
Jul 3rd 2018, 16:32 |
dakota |
https://book.cakephp.org/3.0/en/development/testing.html#testing-a-json-responding-controller |