Log message #4264956

# At Username Text
# Jun 6th 2021, 20:11 kupe3b and without switching debug to false
# Jun 6th 2021, 20:11 kupe3b hi, anyone knows how can i disable PHP notices from cakephp (without changing php.ini)?
# Jun 6th 2021, 18:12 slackebot 'FtpLoginData.id' ] ) ->matching( 'ConnectionTypes', function( $q ) use ( $filter_connection_type ) { /** @var $q Query */ return $q->where( [ 'ConnectionTypes.id' => $filter_connection_type ] ); } ); }``` But if you use the friendsofcake/search plugin there are different ways how you adjust the query
# Jun 6th 2021, 18:12 kevin.pfeifer well, as always, there are many ways you can do such a thing. I did it via a GET form (so the filter parameters are present in the URL) and check them in my controller/custom finder method via something like that ```$filter_connection_type = $current_request->getQuery( 'filter_connection_type' ); if( $filter_connection_type != 'all' andand !is_null( $filter_connection_type ) ) { $query->distinct( [
# Jun 6th 2021, 18:06 etibor okey thank you, @kevin.pfeifer so basically for a filter form page there is not necesserly to check the request method
# Jun 6th 2021, 18:03 kevin.pfeifer therefore if you call `/categories/add` "normally" (= GET method) you get the add form and when the form is being submited via POST to the same URL it actually saves the data
# Jun 6th 2021, 18:02 slackebot $this->redirect( [ 'action' => 'index' ] ); } $this->Flash->error( __( 'The category could not be saved. Please, try again.' ) ); } $this->set( compact( 'category' ) ); }```
# Jun 6th 2021, 18:02 kevin.pfeifer thats why e.g. the add function has only the save logic inside such an if ``` public function add() { $category = $this->Categories->newEmptyEntity(); if( $this->request->is( 'post' ) ) { $category = $this->Categories->patchEntity( $category, $this->request->getData() ); if( $this->Categories->save( $category ) ) { $this->Flash->success( __( 'The category has been saved.' ) ); return
# Jun 6th 2021, 18:01 kevin.pfeifer controller functions basically don't care from which HTTP method they are called. You can restrict logic inside your controller functions with something like that ```if( $this->request->is( 'get' ) ) { // Code only executed on GET requests } if( $this->request->is( 'post' ) ) { // Code only executed on POST requests } // Code executed for ALL HTTP methods```
# Jun 6th 2021, 17:57 etibor is there a universal request method for handling post and get like the $_REQUEST in core php?
# Jun 6th 2021, 17:10 kevin.pfeifer :wave:
# Jun 6th 2021, 17:08 etibor hello everyone
# Jun 6th 2021, 14:17 fresnel.brieuc Yup, thanks
# Jun 6th 2021, 14:16 isvyas @fresnel.brieuc complication is handled by Laravel mix: https://laravel-mix.com/ Which you can find in package.json file.
# Jun 6th 2021, 14:16 fresnel.brieuc I have no idea what I'm doing wow
# Jun 6th 2021, 14:02 fresnel.brieuc Or does vue maybe does that automatically?
# Jun 6th 2021, 14:01 fresnel.brieuc @isvyas Sorry to bother you again but I have a question concerning the repo you sent me yesterday https://github.com/ishanvyas22/cakephpvue-spa, does the config compile components css/scss ? How does it work ? (Not talking about the resources/css directory you made, talking about the css inside vue component files)
# Jun 5th 2021, 19:24 etibor i think i made a fault by, adding a ```if($this->request->is('post')){ }else{//no form submit }```
# Jun 5th 2021, 19:18 kevin.pfeifer so your paginated table was only built when you click on a button which submits a form?
# Jun 5th 2021, 19:08 etibor i haven properly definied the Form
# Jun 5th 2021, 19:07 etibor the issue is similiar: ```The reason why the error did not occur when you submit the form is because the $_POST variables exist in the server but if you click the page button IE <a href="search?page=2">2</a> the $_POST will gone That's why this occurs Notice (8): Undefined index: to [APP/Controller/Admin/ScheduleController.php, line 257] to fix that change your method to GET```
# Jun 5th 2021, 18:56 kevin.pfeifer so it does happen on page=1 but not on page=2?
# Jun 5th 2021, 18:55 etibor the issue is probably related to a form filter
# Jun 5th 2021, 18:41 etibor after the first post it does render the 30 record
# Jun 5th 2021, 18:40 etibor hm, interestingly it happened when click on the page number
# Jun 5th 2021, 18:26 kevin.pfeifer well does the array change when you go into your template
# Jun 5th 2021, 18:26 etibor so it may passed for the view
# Jun 5th 2021, 18:26 etibor $documents->toArray() shows the 30 record
# Jun 5th 2021, 18:23 kevin.pfeifer `->count()` is the whole query without limit but `$douments->toArray()` is actually the array whicht gets passed to your view
# Jun 5th 2021, 18:23 etibor ```LIMIT 30 OFFSET 30```
# Jun 5th 2021, 18:23 etibor yes you are right @kevin.pfeifer it does got the : ```LIMIT 30 OFFSET 0``` on the first page, while on the second
# Jun 5th 2021, 18:22 kevin.pfeifer otherwise you result object only has one entry in there?
# Jun 5th 2021, 18:20 kevin.pfeifer after doing the `->paginate()` function on your query object it should have the limit inside the `->sql()` function
# Jun 5th 2021, 18:17 etibor thank you @kevin.pfeifer
# Jun 5th 2021, 18:16 etibor $documents->count() returns 1210
# Jun 5th 2021, 18:15 etibor i checked $documents->sql() it does not contain any limit or offset
# Jun 5th 2021, 18:12 kevin.pfeifer when you check the sql query with debugkit does it say limit 30?
# Jun 5th 2021, 18:06 etibor and debug($this->paginate); shows limit 30 record / page
# Jun 5th 2021, 18:05 etibor i dont know whats the reason why pagination return only one record per page, because at the bottom of the page its shows 30 record/page
# Jun 5th 2021, 18:04 etibor Hello everyone
# Jun 5th 2021, 15:47 admad Regardless I approve of the tweet for Linkin Park reference :)