{"id":2784,"date":"2022-08-30T15:27:45","date_gmt":"2022-08-30T15:27:45","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/02\/16\/cake-php-paginate-multiple-tables-of-one-model-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:27:45","modified_gmt":"2022-08-30T15:27:45","slug":"cake-php-paginate-multiple-tables-of-one-model-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/cake-php-paginate-multiple-tables-of-one-model-collection-of-common-programming-errors\/","title":{"rendered":"Cake PHP paginate multiple tables of one model-Collection of common programming errors"},"content":{"rendered":"

community, there is a problem with multiple tables which receive their entries of the same model “Post” on the same page. When clicking a paginator-number the app will change the page for both tables.<\/p>\n

I tried it with dummy classes in the AppModel which should work but I get an error saying an internal error has occurred (error 500). I found out that there is a problem with the corresponding SQL-statement with a not found row.<\/p>\n

In the AppModel:<\/p>\n

class PostHood extends Post {\n    public $useTable = 'posts';\n};\n<\/code><\/pre>\n
That code uses the table “cake_posts” of “class Post extends AppModel”. In the controller I tried to get the PostHood like following:<\/p>\n
$this->paginate['PostHood'] = array(\n    'conditions' => array('OR' => array(stuff)),\n    'limit' => 5\n);\n$this->set('postsHood', $this->paginate('PostHood'));\n<\/code><\/pre>\n
In the view there is a foreach-loop using the $postsHood as $post. Maybe you have an idea, thanks in advance \ud83d\ude42<\/p>\n
EDIT 1: I got some error notices after changing the code. May be you have an idea what to do. Change of the AppModel:<\/p>\n
class PostHood extends AppModel {\n    var $name = 'Post';\n    public $useTable = 'posts';\n};\n<\/code><\/pre>\n
The Controller:<\/p>\n
$this->loadModel('PostHood');\n$this->paginate = array(\n    'conditions' => array('OR' =>\n    array(\n        array('AND' => array(   \n        array('PostHood.ZIPCODE LIKE' => $userArea . '%'),\n            array('PostHood.ALTDATE >' => date(\"Y-m-d\")),\n        array('PostHood.AGENT' => '0'),\n        array('PostHood.OWNER ' => $this->UserAuth->getUserId()),\n        array('PostHood.PARENTID' => '0'),\n        array('PostHood.ACCEPTED' => '0')\n    )), [MORE AND ARRAYS]\n$this->set('postsHood', $this->paginate('PostHood'));\n<\/code><\/pre>\n
The corresponding error in the view:<\/p>\n
Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Post.DATE' in 'order clause'\n<\/code><\/pre>\n
SQL Query: SELECT PostHood<\/code>.id<\/code>, PostHood<\/code>.B\/S<\/code>, PostHood<\/code>.H<\/code>, PostHood<\/code>.CITY<\/code>, PostHood<\/code>.MARKET<\/code>, PostHood<\/code>.DATE<\/code>, PostHood<\/code>.ALTDATE<\/code>, PostHood<\/code>.TIME<\/code>, PostHood<\/code>.INCOME<\/code>, PostHood<\/code>.ZIPCODE<\/code>, PostHood<\/code>.ALIAS<\/code>, PostHood<\/code>.VEHICLE<\/code>, PostHood<\/code>.DELIVERYAREA<\/code>, PostHood<\/code>.SPACE<\/code>, PostHood<\/code>.STREET<\/code>, PostHood<\/code>.HOUSENUMBER<\/code>, PostHood<\/code>.NAME<\/code>, PostHood<\/code>.CART<\/code>, PostHood<\/code>.TEL<\/code>, PostHood<\/code>.OWNER<\/code>, PostHood<\/code>.created<\/code>, PostHood<\/code>.modified<\/code>, PostHood<\/code>.AGENT<\/code>, PostHood<\/code>.EXTRADATA<\/code>, PostHood<\/code>.PARENTID<\/code>, PostHood<\/code>.BRATED<\/code>, PostHood<\/code>.SRATED<\/code>, PostHood<\/code>.REQUESTED<\/code>, PostHood<\/code>.ACCEPTED<\/code> FROM usr_web126986_4<\/code>.cake_posts<\/code> AS PostHood<\/code> WHERE 1 = 1 ORDER BY Post<\/code>.DATE<\/code> asc LIMIT 5<\/p>\n
Obviously Cake tries to fetch data with “PostHood” but the table “posts” which I actually want to use is listening to “Post.field”. How can I fix that? Thanks \ud83d\ude42<\/p>\n
    \n
  1. \n
    You should try something like this:<\/p>\n
    $this->paginate = array(\n    'conditions' => array('OR' => array(stuff)),\n    'limit' => 5\n);\n$this->set('postsHood', $this->paginate('PostHood'));\n<\/code><\/pre>\n
    I am just curious as to why you want to structure your model extending another model.<\/p>\n<\/li>\n
  2. \n
    Got it working with the great plugin DataTables. That overrides the cake-pagination and uses JSON to display the results.<\/p>\n
    In order to implement it into cake you need<\/p>\n
    1.) a cake component for interpreting sql-statements: https:\/\/github.com\/cnizzdotcom\/cakephp-datatable<\/p>\n
    2.) the plugin: http:\/\/www.datatables.net\/index<\/p>\n
    3.) implementation:<\/p>\n
    $this->paginate = array(\n    'fields' => array('Model.field1', 'Model.field2'),\n    'conditions' => array( stuff )\n);\n$response = $this->DataTable->getResponse();\n$this->set('response', $response);\n$this->set('_serialize','response');\n$encode = json_encode($response);\n$this->set('dataTablesData', $encode);\n<\/code><\/pre>\n
    Then you can grab the data in the view.<\/p>\n<\/li>\n<\/ol>\n
    Originally posted 2014-02-16 13:13:06. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
    community, there is a problem with multiple tables which receive their entries of the same model “Post” on the same page. When clicking a paginator-number the app will change the page for both tables. I tried it with dummy classes in the AppModel which should work but I get an error saying an internal error […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2784","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/2784","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=2784"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/2784\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=2784"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=2784"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=2784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}