06.06 php saved
palam
Tags add more
 
Note
issue : custom model function not recognised
  1. //Controller fone_controller.php
  2. <?php
  3.     class FoneclubsController extends AppController{
  4.         var $uses = array('Centre');
  5.        
  6.         function locations($city=null,$centreid=null,$name=null){
  7.             var_dump($this->Centre->findById(1));   //works
  8.             $cities=$this->Centre->getCitiesListForCentreType('fone'); // doesn't work - query generated = getCitiesListForCentreType
  9.         }
  10.     }
  11. ?>
  12.  
  13. //model Centre.php
  14. <?php
  15. class Centre extends AppModel {
  16.     var $name = 'Centre';
  17.     var $belongsTo = 'City';
  18.     function getCitiesListForCentreType($type){
  19.         $type=($type=='fone')?0:1;
  20.         $query="SELECT cities.name,cities.id FROM centres LEFT JOIN cities ON centres.city_id = cities.id WHERE centres.pink=$type GROUP BY centres.city_id";
  21.         $result=$this->query($query);
  22.         return $result;
  23.     }
  24. }
  25. ?>
  26.  
  27. //model City.php (not relevant)
  28. <?php
  29. class City extends AppModel {
  30.     var $name = 'City';
  31.     var $hasMany = 'Centre';
  32. }
  33. ?>
  34.  
Parsed in 0.046 seconds, using GeSHi 1.0.7.14

Modify this Paste