| # |
Jun 21st 2019, 09:30 |
 conehead |
I don't really get what you are trying to achive. Count all where `role = 1`) |
| # |
Jun 21st 2019, 09:27 |
kgb.acct.personal |
It looks like this. But it seems hackish ``` $users->func()->count('DISTINCT CASE WHEN role = 1 THEN role END') ``` |
| # |
Jun 21st 2019, 09:27 |
conehead |
https://book.cakephp.org/3.0/en/orm/table-objects.html#afterdelete |
| # |
Jun 21st 2019, 09:27 |
kgb.acct.personal |
How do I do conditional count? |
| # |
Jun 21st 2019, 09:26 |
conehead |
Well you could check in afterSave or afterSaveCommit |
| # |
Jun 21st 2019, 09:12 |
peppejaripappalardo |
Hi guys, i need an help please. I adding muffin/trash behavior a run time into the controller, because i have many entity related and that can give problem if i put the behavior into the table, e.g. Historical View. I need to cascade soft-delete item, there is a way to append into the table AddBehavior if Users deleted entity is not null? |
| # |
Jun 21st 2019, 07:36 |
graziel |
then its in link i gave : ) |
| # |
Jun 21st 2019, 07:35 |
nuzulfikrie |
i am using the latest version |
| # |
Jun 21st 2019, 07:35 |
graziel |
dont remember the older |
| # |
Jun 21st 2019, 07:35 |
graziel |
in newer i think yes, https://github.com/cakephp/app/blob/master/config/routes.php#L58 |
| # |
Jun 21st 2019, 07:27 |
nuzulfikrie |
my question now is does CAKEPHP CSRF is enabled by default ? . |
| # |
Jun 21st 2019, 07:26 |
nuzulfikrie |
disabling this line 'code' $this->loadComponent('Csrf'); 'code' resolve error. |
| # |
Jun 21st 2019, 07:26 |
nuzulfikrie |
hi team, need help. i am having ' CRSF token mismatch error ' on delete action. |
| # |
Jun 21st 2019, 06:49 |
conehead |
Good morning everyone |
| # |
Jun 21st 2019, 06:09 |
noypi2020 |
Hi, Good day! mod_rewrite is enabled on the server and the .htaccess files were intact. I cannot figure out where to fix those errors. |
| # |
Jun 21st 2019, 04:19 |
joey.mukherjee |
Looks like this works! In case someone else searches for it: ` $routes->connect ('/:uuiid', ['controller' => 'Plots', 'action' => 'view']) ->setPatterns (['uuid' => '[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}']);` |
| # |
Jun 21st 2019, 04:11 |
joey.mukherjee |
Is there a better way of capturing a UUID from the url? |
| # |
Jun 21st 2019, 04:03 |
joey.mukherjee |
I copied directly from that page in the book! That's how I got the errors. Ok, I also have this: `$routes->connect ('/**', ['controller' => 'Plots', 'action' => 'view']);` I need that since I want to pass a UUID on the url? |
| # |
Jun 21st 2019, 03:59 |
mrfeedback |
@joey.mukherjee https://book.cakephp.org/3.0/en/development/routing.html#prefix-routing |
| # |
Jun 21st 2019, 03:59 |
challgren |
Just do something like this @joey.mukherjee |
| # |
Jun 21st 2019, 03:57 |
joey.mukherjee |
question about admin routing... If I want an admin prefix, I add ```Router::prefix('admin', function (RouteBuilder $routes) { $routes->connect ('/', ['controller' => 'admin', 'action' => 'index']); |
| # |
Jun 20th 2019, 20:04 |
ricksaccous |
I think it's because I'm not using the OrmPolicy but the mapper policy which runs in the middleware before the controller is hit |
| # |
Jun 20th 2019, 19:59 |
ricksaccous |
is not stopping the policy from happening |
| # |
Jun 20th 2019, 19:59 |
ricksaccous |
my skipAuthorization method from my component |
| # |
Jun 20th 2019, 19:59 |
ricksaccous |
hmmm |
| # |
Jun 20th 2019, 19:53 |
ricksaccous |
actually i think i'll be fine pushing them back to their dashboard |
| # |
Jun 20th 2019, 19:52 |
ricksaccous |
i suppose i'll just have to write a handle that extends redirect |
| # |
Jun 20th 2019, 19:41 |
ricksaccous |
hmm |
| # |
Jun 20th 2019, 19:41 |
ricksaccous |
there must be an easy way to redirect to referer |
| # |
Jun 20th 2019, 19:40 |
ricksaccous |
https://book.cakephp.org/authorization/1.1/en/middleware.html#handling-unauthorized-requests |
| # |
Jun 20th 2019, 18:06 |
mdotobie |
gotcha. well this actually might be a better way to do this |
| # |
Jun 20th 2019, 18:05 |
admad |
Webservice is akin to db connection and Driver is akin to pdo driver |
| # |
Jun 20th 2019, 18:04 |
admad |
Endpoint is akin to Table and Resource is akin to Entity |
| # |
Jun 20th 2019, 18:02 |
mdotobie |
Any insight on the difference between Endpoint and Resource? |
| # |
Jun 20th 2019, 18:00 |
admad |
Endpoint is your model abstraction. You would create a driver which reads the json file instead of making a GET request |
| # |
Jun 20th 2019, 17:59 |
mdotobie |
The other thing I would have wanted to add @admad would be a way to define the schema of the loaded data for validation purposes (since it’s handwritten). But I really liked the _transformResults method it has for parsing the JSON, however, I’m basically using `JsonConfig` through the `Configure` class to perform the same function. |
| # |
Jun 20th 2019, 17:57 |
mdotobie |
@admad on this particular use the JSON is written by hand in advance it isn’t coming from a service. But I was thinking about how I could extend it in the future. I did come across Webservice when I was researching if what I was trying to do was possible and how would I architect it. My only question was around whether an “endpoint” could be a file or was a URL you’re only option. |
| # |
Jun 20th 2019, 17:52 |
admad |
@mdotobie if you are fetching data from an external API is suggest you checkout muffin/webservice |
| # |
Jun 20th 2019, 17:48 |
mdotobie |
I think a really good way I intend to extend this is for caching JSON data from sources. Then the cached JSON can be read in as config data and can be updated on a schedule or on demand. But it doesn’t need to be retrieved fresh on each request because it won’t change often. |
| # |
Jun 20th 2019, 17:46 |
mdotobie |
I think I like this architecture. |
| # |
Jun 20th 2019, 17:46 |
slackebot1 |
`\App\Model\Table` namespace as `ShippingItemTable`. Instead of extending `\Cake\ORM\Table` like a normal Table, it extends `App\Model\Datasource\Json`. In turn, the Entity is in the `\App\Model\Entity` namespace as `ShippingItem` |