| # |
Jan 6th 2020, 15:59 |
 ricksaccous |
just don't use get() |
| # |
Jan 6th 2020, 15:59 |
gianmarxgagliardi |
```$matchHome = $this->Matches->get($id, [ 'contain' => ['SeasonReferees','SeasonReferees.Referees', 'ClubsHome', 'MatchPlayers','MatchPlayers.SeasonPlayers','MatchPlayers.SeasonPlayers.Players'], ])->matching('MatchPlayers.SeasonPlayers', function ($q) { return $q->where(['SeasonPlayers.club_id' => 3]); });``` |
| # |
Jan 6th 2020, 15:58 |
gianmarxgagliardi |
if instead everything is compact |
| # |
Jan 6th 2020, 15:58 |
ricksaccous |
```$query = $matchHome->find();``` |
| # |
Jan 6th 2020, 15:58 |
ricksaccous |
your mistake is this line |
| # |
Jan 6th 2020, 15:58 |
ricksaccous |
yeah that part is fine |
| # |
Jan 6th 2020, 15:57 |
gianmarxgagliardi |
```// In a controller or table method. $query = $products->find()->matching( 'Shops.Cities.Countries', function ($q) { return $q->where(['Countries.name' => 'Japan']); } );``` |
| # |
Jan 6th 2020, 15:57 |
gianmarxgagliardi |
https://book.cakephp.org/3/en/orm/retrieving-data-and-resultsets.html |
| # |
Jan 6th 2020, 15:57 |
gianmarxgagliardi |
on the guide I had found this example |
| # |
Jan 6th 2020, 15:54 |
ricksaccous |
get returns an entity |
| # |
Jan 6th 2020, 15:54 |
ricksaccous |
you have an entity |
| # |
Jan 6th 2020, 15:54 |
ricksaccous |
because you don't have a query object |
| # |
Jan 6th 2020, 15:52 |
slackebot |
<gianmarxgagliardi> |
| # |
Jan 6th 2020, 15:51 |
gianmarxgagliardi |
I would like to compare the underlined fields in order to take only the players who are associated with a certain id and not all the players |
| # |
Jan 6th 2020, 15:49 |
slackebot |
$q->where(['SeasonPlayers.club_id' => ($matchHome->club_home_id)]); });``` |
| # |
Jan 6th 2020, 15:49 |
gianmarxgagliardi |
```$matchHome = $this->Matches->get($id, [ 'contain' => ['SeasonReferees','SeasonReferees.Referees', 'ClubsHome', 'MatchPlayers','MatchPlayers.SeasonPlayers','MatchPlayers.SeasonPlayers.Players'], ]); $query = $matchHome->find(); $query->matching('MatchPlayers.SeasonPlayers', function ($q) { return |
| # |
Jan 6th 2020, 15:49 |
gianmarxgagliardi |
I'm trying to get his players selected for a team that just gives me a mistake: `Call to undefined method App\Model\Entity\Match::find()` |
| # |
Jan 6th 2020, 15:49 |
luizcmarin |
I have some views created on mysql. Can I use them the same way as a normal table in cake? |
| # |
Jan 6th 2020, 15:41 |
etibor |
interestingly in the '[original]' array its shows the request->getData('visible') value the issue is that is not saved |
| # |
Jan 6th 2020, 15:37 |
etibor |
i dont understand why this not working in edit function but in add working fine |
| # |
Jan 6th 2020, 15:33 |
etibor |
thats why i havent post the request->getData content |
| # |
Jan 6th 2020, 15:32 |
etibor |
@ndm well i would like to use this : $tst->_joinData->visible = $this->request->getData('visible'); |
| # |
Jan 6th 2020, 15:32 |
ndm |
Could be all sorts of things... Maybe something changes the layout at `beforeRender` |
| # |
Jan 6th 2020, 15:31 |
alexdd55976 |
any idea what could possibly interfer with that? |
| # |
Jan 6th 2020, 15:31 |
ndm |
No |
| # |
Jan 6th 2020, 15:30 |
alexdd55976 |
not really? |
| # |
Jan 6th 2020, 15:30 |
alexdd55976 |
do i have to add a helper here? |
| # |
Jan 6th 2020, 15:30 |
ndm |
@alexdd55976 Work's fine for me |
| # |
Jan 6th 2020, 15:30 |
gianmarxgagliardi |
even if late good year |
| # |
Jan 6th 2020, 15:28 |
alexdd55976 |
works fine in 3.x so its kind of confusing |
| # |
Jan 6th 2020, 15:28 |
ricksaccous |
I haven't used cake4 yet just curious |
| # |
Jan 6th 2020, 15:28 |
alexdd55976 |
yes |
| # |
Jan 6th 2020, 15:28 |
ricksaccous |
you're doing that from a controller action? |
| # |
Jan 6th 2020, 15:25 |
alexdd55976 |
can anyone confirm that `$this->viewBuilder()->setLayout('ajax');`works in cake4? can not make it happen.. whysoever |
| # |
Jan 6th 2020, 15:23 |
johnpaul5421 |
I think the problem is the Controller and Action method is not receiving the Posted form data at all, not sure if i'm doing it correctly, Any Examples or Pointers? much appreciated. |
| # |
Jan 6th 2020, 15:22 |
johnpaul5421 |
Thanks, if anyone can provide some Form Help or examples for Passing data from a Controller to a View class. Just a Simple Form 1 variable or a Checklist array. |
| # |
Jan 6th 2020, 15:20 |
johnpaul5421 |
receiving it in an example action = add in controller = shoppingListsController, using if ($this->request->is('post')), set compact, flashing the error. |
| # |
Jan 6th 2020, 15:19 |
ndm |
@etibor That's only half of the output, request data debug is missing |
| # |
Jan 6th 2020, 15:19 |
johnpaul5421 |
Anyone can provide a simple example of Posting a form from a view class passing data from the View to the Controller, using $this->Form->create and $this->Form->control, $this->Form->hidden and $this-Form-end(); |
| # |
Jan 6th 2020, 15:16 |
johnpaul5421 |
i'm trying to keep it simple using $this->request->is('post')); or I may try ajax. |
| # |
Jan 6th 2020, 15:15 |
etibor |
and the issue is with the visible field |