1

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

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

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.

using $this->paginate();

eg.

table_products

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

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

*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*

Libu
  • 213
  • 3
  • 10

1 Answers1

0

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.

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');

Good Luck

pleasedontbelong
  • 19,542
  • 12
  • 53
  • 77
  • will this work in this situation ? http://stackoverflow.com/questions/5675225/create-temporary-table-in-cakephp-and-load-it-as-a-model as I seem to get a "table not found" error?? –  Apr 15 '11 at 10:19
  • well now that you've loaded the class.. the pagination should work – pleasedontbelong Apr 15 '11 at 10:57