Advertisement
Guest User

Untitled

a guest
Aug 18th, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.36 KB | None | 0 0
  1. // into controller
  2.  
  3. $this->Jobcategory->find('all', array(
  4.     'contain' => array('UsersJobcategory'),
  5.     'recursive' => 1,
  6.     'conditions' => array(
  7.         'UsersJobcategory.type' => 'favorite',
  8.     ),
  9.     'fields' => array(
  10.         'UsersJobcategory.*'
  11.     )
  12. ));
  13.  
  14. $this->Jobcategory->find('all', array(
  15.     'contain' => array('UsersJobcategory' => array(
  16.         'conditions' => array(
  17.             'UsersJobcategory.type' => 'favorite',
  18.         ),
  19.     'className' => 'UsersJobcategory'
  20.     )),
  21.            
  22. ));
  23.  
  24.  
  25. // SQL query
  26.  
  27. SELECT `Jobcategory`.`id`, `Jobcategory`.`category`, `Jobcategory`.`parent_category_id`, `Jobcategory`.`domain_id`, `Jobcategory`.`active`, `Jobcategory`.`created`, `Jobcategory`.`modified` FROM `jobcategories` AS `Jobcategory`   WHERE `UsersJobcategory`.`type` = 'favorite'    
  28.  
  29.  
  30. // Jobcategory model
  31.  
  32. class Jobcategory extends AppModel {
  33.  
  34.     var $name = 'Jobcategory';
  35.     var $recursive = 1;
  36.    
  37.     var $hasMany = array(
  38.  
  39.             'UsersJobcategory' => array(
  40.                 'className' => 'UsersJobcategory',
  41.                 'foreignKey' => 'jobcategory_id'
  42.             )
  43.     );
  44.  
  45.  
  46. // UsersJobcategory
  47.  
  48. class UsersJobcategory extends AppModel {
  49.    
  50.     var $name = 'UsersJobcategory';
  51.    
  52.     var $belongsTo = array(
  53.         'Jobcategory' => array(
  54.             'className' => 'Jobcategory',
  55.             'foreignKey' => 'jobcategory_id'
  56.         )
  57.     );
  58.  
  59.  
  60. // AppModel
  61.  
  62. class AppModel extends Model {
  63.     var $actsAs = array('Containable', 'Linkable.Linkable');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement