Paginate TEMPORARY TABLE在Cakephp？ [英] Paginate TEMPORARY TABLE in Cakephp?

问题描述

假设我有一个名为products的表和名为Product的模型。

Let say I have a table named 'products' and Model named 'Product'.

'products'表有3个字段id，title，price，created

'products' table has 3 fields id,title,price,created

我想计算cal_price（每个记录和搜索日期不同），并创建一个包含4个字段的临时表，即id，title，price，cal_price，order by cal_price

I want to calculate cal_price (which varies per record and day of search) and create a temporary table with 4 fields i.e. id,title,price,cal_price with order by cal_price

现在，我只需要分页这个临时表。

Now, all I want is to paginate this temporary table.

使用$ this-> paginate

using $this->paginate();

例如

table_products

 id    title    price   created
 3      demo1    23     2011-12-12
 4      demo2    43     2011-12-13
 56     demo3    26     2011-12-16

通过cal_price和paginate对'temp_table'排序

sort 'temp_table' order by cal_price and paginate

temp_table

 id    title    price   cal_price created
 3      demo1    23        12       2011-12-12
 4      demo2    43        43       2011-12-13
 56     demo3    26        88       2011-12-16

*解决方案的基本问题是如何将temp_table指定给模型因为一旦我这样做，我可以使用$ this-> paginate（'temp_model'）并解决问题*

*The underlying problem to the solution is HOW DO I assign temp_table to a model at run time because once I do it I can use $this->paginate('temp_model') and solve the problem*

推荐答案

如果您尊重了您不需要临时表的模型， nofollow>约定的表名，所以temp_table不工作，因为名称必须是复数。

you dont need a model for your temporary table if you have respected the conventions for the tables' names, so "temp_table" wont work, cause the name must be plural.

被称为temp_prices（我不使用表上的前缀）
，模型的名称应该是TempPrice。要对页面进行分页，请在控制器上使用此标签。

Let's say that your temporary table is called "temp_prices" (i'm not using prefixes on tables) ,the name of the Model should be "TempPrice". To paginate the table use this on your controller

$this->loadModel('TempPrice'); //will load the model on the controller
$this->paginate['TempPrice'] = array(); //you can change the pagination options here
$resp = $this->paginate('TempPrices');

祝你好运

这篇关于Paginate TEMPORARY TABLE在Cakephp？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！